In: Finance
You have decided to invest in a small commercial office building that has one tenant for a price of $200,000. The tenant has a lease that calls for annual rent
payments of $15,000 per year for the next three years. Hint # 1 However, after that leases expires you expect to be able to increase the
rent by 4% per year for the next 7 years. Hint # 2 You plan to sell the building for $325, 000 ten years from now. Hint # 3
B. Assuming that you need to earn 11% on this investment, what is the maximum price you would be willing to pay for the building?
Please see the table below. Please be guided by the second column titled “Linkage” to understand the mathematics. The last row highlighted in yellow is your answer. Figures in parenthesis, if any, mean negative values. All financials are in $. Adjacent cells in blue contain the formula in excel I have used to get the final output. All the three parts have been solved consequentially in the table itself.