In: Finance
You have been asked to provide an estimate for the net operating income (NOI) of the Shared Office Space Building. The building consists of 16 suites evenly distributed in 4 floors (4 suites per floor). Today, the offices in the first-floor lease for $2,100 per month, while the rest of the offices lease for $1,600 per month. The market study reveals that the average vacancy in the market is 8% per year; the expected operating expenses are 41% of the effective gross income(EGI); and, the expected capital expenditure are 5% of the EGI each year. The annual market rent increases 3% per year. What is the estimated building’s Potential Gross Income, EGI and NOI for next year? If market caprate for this building is 7%, what is the building's value today?
Solution | Fig in ($) | |||||
Calcuation for Current Year | ||||||
There is 16 Suits out of which 4 suits ( i.e first floor rent is high then other rented office) | ||||||
Rent of First floor Office | =2100*4*12 | |||||
100800 | ||||||
Rent for rest of floor | =1600*12*12 | |||||
230400 | ||||||
Total Rent income/ Potential Gross income | 331200 | |||||
Less | Effective Expense | 135792 | ||||
=331200*41% | ||||||
Effective Gross Income | 195408 | |||||
NOI = Rental Income + Other Income – Vacancy Losses – Total Operating Expenses | ||||||
Since there is no Vacany loss | ||||||
Net operating income | 195408 | |||||
Calculation of value of Building | ||||||
Cap rate is 7% | ||||||
As we Know Cap rate | CAP RATE '=Net opearting income /Value | |||||
=195408/7% | ||||||
value =2791542.85714286 | ||||||
Calculation for next year | ||||||
There is 16 Suits out of which 4 suits ( i.e first floor rent is high then other rented office) | ||||||
But this year Rent is Increased by 3% | Revised Rent | |||||
For First floor Office rent is | =2100*3% | 63 | 2163 | |||
For Rest of the floor Office rent is | =1600*3% | 48 | 1648 | |||
Now | Calculation of NOI | |||||
Rent of First floor Office | =2163*4*12 | |||||
103824 | ||||||
Rent for rest of floor | =1648*12*12 | |||||
237312 | ||||||
Total Rent income/ Potential Gross income | 341136 | |||||
Less | Effective Expense | 139865.8 | ||||
=341136*41% | ||||||
Effective Gross Income | 201270.2 | |||||
Less | Vacancy Loss | |||||
=341136*8% | 27290.88 | |||||
NOI | 173979.4 | |||||
Calculation of value of Building | ||||||
Cap rate is 7% | ||||||
As we Know Cap rate | CAP RATE '=Net opearting income /Value | |||||
=173979.4/7% | ||||||
value =2485420 | ||||||
Note :- cap Expenditure is not allowed while calcuation of NOI so it is not Considered |