solution

Nance’s Restaurant, a local independent restaurant, is evaluating new point-of-sale (POS) systems and must determine if a new installation is feasible. A new POS installation would include both software and hardware, with a total cost of $20,000. Nance’s Restaurant is currently operating without a point-of-sale system and utilizes a chit system with carbon copy papers that allow the waitstaff to provide a copy to the kitchen and the customer while retaining a copy for accounting purposes. Management is aware that this is an archaic system and that a POS system will create efficiencies, but they are not sure it is worth the cost. Through analysis, management has determined that a POS system would allow the waitstaff to turn tables quicker, therefore increasing the number of guests serviced and the sales volume. Another advantage of the POS system is that it provides reports to management, allowing them to better analyze their business. Taking all of these factors into consideration, Nance’s management forecasts incremental increases in profit over the next three years of $8,000, $9,000, and $10,000. 1. Determine the payback period, present value, and net present value of this project for the three-year period, utilizing an 8% discount rate. 2. Management has received an offer from another POS vendor with installation costs of $25,000. The second vendor is offering increased functionality in the form of additional cost control reports, which would allow the restaurant to realize an additional $500 in incremental profits per year for a total of $8,500, $9,500, and $10,500. Financially, does this option fit Nance’s Restaurant’s criteria? Please explain your answer.

 

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

solution

The eighteen-hole Redwood Golf Course is in need of a new sprinkler system, which is estimated to cost $1 million. The Golf Course Superintendent, who is in charge of maintaining the golf course, has advised the members that the system must be replaced within the next year because the system is beginning to fail. The board of directors has known about this problem for several years but has been putting off the repair due to the cost. The members, however, have been complaining because the condition of the course is deteriorating. After looking into the matter further, the Board estimates that the property has lost nearly $250,000 in incremental profits over the past year alone due to membership terminations and lower guest fees and golf shop sales. If this problem is not solved quickly, more members will leave and revenues will continue to decrease. Mr. Hans Tripler, general manager of Redwood, has requested a loan for $1 million from a local bank. The bank has offered to grant the loan at a 6.5% interest rate for a term of ten years. 1. Calculate the annual payment on the loan. 2. Calculate the payback period on the project based on the amount of revenues currently being lost by the golf operation. 3. The golf professional believes that with the installation of the new sprinkler system the club will see new members joining and golf shop revenues increasing. He estimates the club will enjoy the following incremental profits, which level off in year 5. Incremental Profits 1 $ 150,000 2 $ 175,000 3 $ 200,000 4 $ 225,000 5 $ 250,000 Based on the incremental profits in the table and a discount rate of 9%, calculate the PV, NPV, and IRR of the irrigation project, assuming the sprinkler system has a ten-year useful life with no salvage value at the end of ten years

 

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

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!"