Question 935 real estate, NPV, perpetuity with growth, multi stage growth model, DDM
You're thinking of buying an investment property that costs $1,000,000. The property's rent revenue over the next year is expected to be $50,000 pa and rent expenses are $20,000 pa, so net rent cash flow is $30,000. Assume that net rent is paid annually in arrears, so this next expected net rent cash flow of $30,000 is paid one year from now.
The year after, net rent is expected to fall by 2% pa. So net rent at year 2 is expected to be $29,400 (=30,000*(1-0.02)^1).
The year after that, net rent is expected to rise by 1% pa. So net rent at year 3 is expected to be $29,694 (=30,000*(1-0.02)^1*(1+0.01)^1).
From year 3 onwards, net rent is expected to rise at 2.5% pa forever. So net rent at year 4 is expected to be $30,436.35 (=30,000*(1-0.02)^1*(1+0.01)^1*(1+0.025)^1).
Assume that the total required return on your investment property is 6% pa. Ignore taxes. All returns are given as effective annual rates.
What is the net present value (NPV) of buying the investment property?