Tuesday, November 20, 2012

Financial Analysis


I plan to use debt financing to purchase this property. The property costs $1,350,000 and, as mentioned above, the occupancy rate will be estimated to be around 95% and the monthly rental rate will be $750 per unit.

Here are the terms on the loan:
Amortization Period: 25 years
Interest Rate: 4.15%
Loan-to-Value ratio: 70%
Loan Amount: $945,000
Holding Period: 10 years
Cap Rate: 5.22%

Assumptions:
Vacancy Loss: 5%
Rental Growth Rate: 1.25%
Operating Expense Growth Rate: 2%

The operating expense ratio is 45% of the first year's effective gross income and has a growth rate of 2%. The reason is that I plan on renovating the property to increase the value of the property by the end of the holding period.


The sales price of the property is $2,302,203. This is calculated by taking the 11th year's NOI ($120,175) divided by the cap rate (5.22%). However, since I plan on financing the property when purchasing it, I will have to take out the balloon payment from the sales price to get the sales revenue of $1,624,142. These two numbers will be explained more below.



The required rate of return on this property is 13%. Since I plan on financing this purchase using debt, the leveraged IRR is 23%, which is 10% higher than the return I require on this property. Notice that there is a NPV of $370,653.40 for the 10 year holding period, which confirms that this investment is a good one. Trying to purchase this investment with equity only turns out to be a bad investment that produces an IRR of 12% and a NPV of -$44,682.13. Both numbers don’t meet my expectations of a 13% return and a positive NPV value.



No comments:

Post a Comment