solution

Tennyson Investments, a hotel investment company, has identified a potential midscale branded hotel prospect located in a major metropolitan area. The Mason Hotel, a franchised property, is on the market, and the owners are looking to sell the asset quickly because they need cash to invest in other projects they currently own and operate. The Mason Hotel is located next to a midscale limited-service hotel, across the street from a historic conference center and an upscale full-service hotel and adjacent to a new major-league baseball stadium. The property consists of a 124-room full-service hotel with a leased restaurant, a forty-space parking garage in the basement, a gift shop, an exercise room, and meeting rooms. The property is currently being marketed at an asking price of $6.4 million. Tennyson Investments offered $5 million, which was accepted by the sellers, and has secured a new nonrecourse first mortgage with a 6.4% interest rate for 70% of the total project cost of $5,977,335. Tennyson has estimated the following cash flows for the first five years of the project. 1. How much money has Tennyson Investments borrowed for this project based on a 70% loan-to-value ratio? 2. What is the maximum amount available for debt service in the first year if the lender requires a 1.25 debt service coverage ratio? 3. Utilizing the debt service payment calculated in the previous question, calculate the ideal amortization rate for the first mortgage at the 6.4% annual interest rate. 4. Tennyson Investments has hired Geoff Strips Management Co. to operate the hotel. The Strips Co. has negotiated a 10% equity kicker on the sale of the property if the hotel meets or exceeds projected cash flows. If the property is sold in Year 5, what dollar amount would Geoff Strips Management receive? Utilize the capitalization rate method of valuation based on a 10% cap rate. 5. Calculate the NPV for this project based on a 12% cost of capital. What is the IRR?