In: Finance
Potential Gross Income 100,000 sq. ft for the coming year |
||
average rent $15.00 per ft. |
$ 1,500,000 |
|
Less Vacancy Allowance (average 8%) |
$ (120,000) |
|
Effective Gross Income |
$ 1,380,000 |
|
Cleaning expenses (5% of net rev) |
$ (69,000) |
|
Insurance ($ 0.02 per dollar replacement, R.C. = $40 per ft. |
$ (80,000) |
|
Management & Maintenance (11% of revenue) |
$ (151,800) |
|
Reserve for Replacement (savings for major repairs) |
$ (50,000) |
|
Property Taxes ($0.10 per $100 of R.C.) |
$ (4,000) |
|
$ (354,800) |
||
Estimated Net Operating Income |
$ 1,025,200 |
What is the NPV of this investment at a discount rate of 12% ? (use purcahse price of $9,500,000)
Present value of estimated net operating income = Estimated net operating income / (1 + Discount rate)
= $1,025,200 / (1 + 12%)
= $1,025,000 / 1.12
= $915,357.143
NPV of the investment = Present value of estimated net operating income - Purchase price
= $915,357.143 - $9,500,000
= $(-8,584,642.86)