Question: please take a look at and solve cash flow analysis (and solve for the NPV and IRR), if possible share excel document to me. AutoSave

please take a look at and solve cash flow analysis (and solve for the NPV and IRR), if possible share excel document to me.

please take a look at and solve cash flow
AutoSave ON F8 ? " C ... Debt Free Analysis - Saved me Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) v 11 A A ab Wrap Text v Custom Cell BIUV DVAv Merge & Center v $ ~ % " Conditional Format Insert Delete aste Formatting as Table Styles X fx D M N Q R S Property Characteristics 2 units Medium condition (some deferred maintenance); This will result in a $60,000 investment ($10,000 each month the first 6 months of ownership). Purchase price $800,000 Square feet 2000 Rent $ 2,900 per unit per month Vacancy Rate 10% Rent Increase 1% annual Expenses Purchase date Tax 1.25% of purchase price (annual) Dates of CF 1/1/23 Insurane $0.50 per square foot (annual) Rent Increase % Trash Removal $1,000.00 (annual) Gross Income Landscaping $1,000.00 (annual Vacanc Pest Control $600.00 (annual Effective Income Repairs/Reserve $6,000.00 (annual) in addition to the $60K above HCIDLA Fee $250.00 (annual Expenses J tilities $3,600.00 (annual Tax MIsc. $1,200.00 (annual Insurane Trash Removal Landscaping Purchase Date 1/1/23 Pest Control Future Sale Price $1,200,000 Repairs/Reserve Cost of Sale 4% HCIDLA Fee Date of sale 4 years from now Utilities Misc. Discount Rate 8.00% Net Operating Income (NOI) Purchase Price Selling Price Cost of Sale Net of all Cash Flows Net Present Value Internal Rate of Return

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!