You have decided to invest in a small commercial office building that has one tenant The tenant has a lease that calls for annual rent payments of $20,000 per year for the next three years However, after that lease expires you expect to be able to increase the rent by 4 per year for the next seven years You plan to sell the building for $350,000 ten years from now Create a table showing the projected cash flows for this investment assuming that the next lease payment will be made in one year Assuming that you need to earn 9 per year on this investment, what is the maximum price that you would be willing to pay for the building today Use the Npv function Notice that the cash flow stream starts out as a three year regular annuity, but it then changes into a seven year graduated annuity plus a lump sum in year 10 Use the principle of value additivity to calculate the present value of the cash flows Suppose that the current owner of the building is asking $275,000 for the building If you paid this price, what annual rate of return would you earn Should you buy the building at this price Show Excel Functions Growth Rate Required Return Year 1 Rent Years Stable Rent Years Growing Rent Year Sold Sale Price in 10 Years Ask Price Today 4 9 20,000 3 7 10 350,000 275,000 A Period Cash Flow 0 1 2 3 4 5 6 7 8 9 10 B C Present Value Present Value PV First 3 Years PV Next 7 Years PV Lump Sum Total PV D Yield

The Answer is in the image, click to view ...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Oct 02, 2024

You have decided to invest in a small commercial office building that has one tenant. The tenant has a lease that calls for annual rent

You have decided to invest in a small commercial office building that has one tenant. The tenant has a lease that calls for annual rent payments of $20,000 per year for the next three years. However, after that lease expires you expect to be able to increase the rent by 4% per year for the next seven years. You plan to sell the building for $350,000 ten years from now.
1. Create a table showing the projected cash flows for this investment assuming that the next lease payment will be made in one year.
2. Assuming that you need to earn 9% per year on this investment, what is the maximum price that you would be willing to pay for the building today? Use the Npv function.
3. Notice that the cash flow stream starts out as a three-year regular annuity, but it then changes into a seven-year graduated annuity plus a lump sum in year 10. Use the principle of value additivity to calculate the present value of the cash flows.
4. Suppose that the current owner of the building is asking $275,000 for the building. If you paid this price, what annual rate of return would you earn? Should you buy the building at this price? Show Excel Functions

Growth Rate Required Return Year 1 Rent Years Stable Rent Years Growing Rent Year Sold Sale Price in 10 Years Ask Price Today 4% 9% 20,000 3 7 10 350,000 275,000 A. Period Cash Flow 0 1 2 3 4 5 6 7 8 9 10 B. C. Present Value Present Value PV First 3 Years PV Next 7 Years PV Lump Sum Total PV D. Yield