The Star Restaurant Company owns and operates Chinese restaurants throughout the north-western United States. Paris Brown, vice president of development, has been analyzing a new metropolitan market for expansion opportunities. The companys 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:

Please prepare some calculations in Excel. 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. What is the loan-to-value ratio for this project? What would the investor's ROI be for this 5-year project if the restaurant achieved its budgeted operating results for the year? If the investor has a hurdle rate of 15%, does this project meet or exceed the investor's requirements?

Siesta Restaurant Operating Results (000) 2002 2004 2006 2003 2005 Revenue Food $975 $1,000 $900 $925 $950 Beverage 375 350 360 365 370 Total 1,345 1,250 1,285 1,315 1,375 Operating expenses Food cost 240 255 270 285 300 Beverage cost 57 50 53 54 60 Labor cost 650 550 585 615 685 Travel 120 120 120 120 120 Marketing 60 50 40 20 10 Utilities 75 65 60 70 80 Rent 162 150 160 163 165 Total 1,405 1,240 1,290 1,332 1,372 $(5) $(27) $(30) $(17) Operating Profit (Loss) $10 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. Cash Flow Year $695,000 1 876,250 1,057,500 4 1,238,750 1,420,000 Siesta Restaurant Operating Results (000) 2002 2004 2006 2003 2005 Revenue Food $975 $1,000 $900 $925 $950 Beverage 375 350 360 365 370 Total 1,345 1,250 1,285 1,315 1,375 Operating expenses Food cost 240 255 270 285 300 Beverage cost 57 50 53 54 60 Labor cost 650 550 585 615 685 Travel 120 120 120 120 120 Marketing 60 50 40 20 10 Utilities 75 65 60 70 80 Rent 162 150 160 163 165 Total 1,405 1,240 1,290 1,332 1,372 $(5) $(27) $(30) $(17) Operating Profit (Loss) $10 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. Cash Flow Year $695,000 1 876,250 1,057,500 4 1,238,750 1,420,000