solution

The Star Restaurant Company owns and operates Chinese restaurants throughout the northwestern United States. Paris Brown, vice president of development, has been analyzing a new metropolitan market for expansion opportunities. The company’s best option would be to acquire a distressed property at a low price and turn it into a money-making venture. Ms. Brown is contemplating taking over a restaurant that recently failed and is currently closed. The restaurant is located in the parking lot of a large regional shopping mall. The mall owner is anxious to reopen the restaurant, as in its current state it is an eyesore and a deterrent to attracting retail customers. Ms. Brown asks the previous owner for historical operating results for the failed restaurant, and she is provided with the following information: Based on Paris’s market analysis, tour of the competition, inspection of the subject property, and interviews with the prior owner, she concludes a Star Restaurant would work in the subject space, but it would require approximately $200,000 of renovation and conversion cost in addition to the land purchase price of $2,000,000. By Year 5, the restaurant could generate $2.5 million in annual food revenue and $1.5 million in annual beverage revenue. Ms. Brown estimates the following cash flows for the first five years of operations, with cash flows leveling off in Year 5. 1. Calculate the IRR and NPV of this project utilizing a 12% discount rate and a 15% cap rate. Ms. Brown was able to secure a loan for $1,540,000, and an equity investor agreed to invest the remaining $660,000 in exchange for 20% ownership in the project. 2. What is the loan-to-value ratio for this project? 3. What would the investor’s ROI be for this 5-year project if the restaurant achieved its budgeted operating results for the year? 4. If the investor has a hurdle rate of 15%, does this project meet or exceed the investor’s requirements?

The Star Restaurant Company owns and operates Chinese restaurants throughout the northwestern United...-1           The Star Restaurant Company owns and operates Chinese restaurants throughout the northwestern United...-2

 

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

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?

Tennyson Investments, a hotel investment company, has identified a potential midscale branded hotel...-1

Tennyson Investments, a hotel investment company, has identified a potential midscale branded hotel...-2

 

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Nicole Sharp, director of acquisitions for Sahara Hotels Corp., has discovered a promising location for a future hotel. The subject property is located in a densely populated urban setting and borders the business district in Shepard City. Ms. Sharp is in the process of developing an investment package for potential equity investors and has put together the following fact outline: â–  The location of the proposed hotel is excellent, as it is located in one of the fastest-growing market areas in Shepard. Businesses have been readily moving to Shepard because of favorable tax incentives. Along with increased business development, local hotels have experienced an increase in ADR and revenue per available room. â–  The acquisition price of the land will be $3.5 million, with an additional $15 million needed for construction costs for the proposed 197-room property. In total, the project will cost $18.6 million. â–  The city is currently in the process of building a major freeway in front of the proposed build site, which will increase land values and traffic. â–  The hotel competition in the immediate area consists of two major branded hotels and one independently operated property. Competitor A is a budget hotel, Competitor B is a midmarket property without food and beverage facilities, and Competitor C is an upscale independent property with food and beverage facilities. Ms. Sharp is proposing to build a 197-room upscale full-service property to meet the underserved business travelers currently visiting the area. The following is a pro forma for the first six years of operation. Ms. Sharp has projected six years because she has set a timeline to sell the property in Year 6 at an 11% cap rate. 1. Is any information missing that should go into an equity investment package? If so, list the information missing. 2. Calculate the return on investment in Year 1 for an equity investor who provides 45% of the total project cost. 3. Calculate the internal rate of return for this project with a sale in Year 6. (Utilize the cap rate method for sale price in Year 6.) 4. Would you invest in this project? Why or why not?

Nicole Sharp, director of acquisitions for Sahara Hotels Corp., has discovered a promising location...

 

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

While negotiating a loan, Christian is hitting some roadblocks. The lender wants to charge him 5 points on the loan and asks him for a personal guarantee and additional collateral. Christian senses the lender has some objections to his deal. While he was preparing for the loan negotiation, a friend told Christian that if he senses anything negative from the lender, the lender is just bluffing and Christian should tell the lender that the pro forma numbers are strictly the worst-case scenario and that he will go back and rework them for further discussion. In his heart and mind, Christian knows the numbers as presented are realistic. Is there anything wrong with his friend’s suggestion?

 

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"