Question

Italian Valley Restaurant Having assessed the changing dietary needs of your town, you are considering investing...

Italian Valley Restaurant

Having assessed the changing dietary needs of your town, you are considering investing in a new Italian restaurant which you plan to name Italian Valley. The restaurant will feature live musicians, appetizers, and a stocked bar. You are trying to assess the likely profitability of this business venture. As a new graduate of the UWI your first step is to prepare a complete capital budgeting analysis for the 5 years you plan to operate the restaurant before you sell it.

Having spoken with local vendors, other restaurant owners, bankers, and builders you collected the following data and information about the proposal.

You plan to use a building currently owned by your family, however there will be need for some renovation and improvements to the property. Your parents have said that you can use the retail space in any way you wish for free. After checking on local lease rates you determine this space would lease for $75,500 per year. Your family also owns another restaurant downtown. You predict that your new one will decrease its revenues by $15,000 per year. Your parents tell you that this sum will be taken from your annual family stipend.

Some of the major improvements to the property include the purchase of cooking equipment, building a stage, seating, and interior décor. The construction is estimated to cost $1.75 million. An additional $375,000 will be spent on chairs, tables, bar equipment, and decorations. Depreciation will be over 7 years using MACRS*. You determine that you will require an average cash balance of $15,000 and inventory of $20,000. Accounts payable should average $10,000. Your local bank has agreed to loan you monies to pay for these expenses at a 15% interest rate.

You plan to hire a research consultant to conduct a market study, since you believe your chances of success will increase with greater information about the restaurant market. The charge for this report will be $200,000.

Revenues are estimated to be $600,000 the first year. Revenues are expected to increase by 20% the second year, 15% the third year, and continue increasing at 8% thereafter. Fixed annual operating costs are estimated to be as follows.

Employee salaries = $110,000; Heat, electricity, water, and janitorial services =$75,000.

The food and liquor bill is expected to be 15% of revenues. Total taxes are estimated to be 40% of net revenues.

Your plan is to run the bar for 5 years, then to sell it to an investor for $2,000,000.

Required: 1. Prepare a cash flow analysis which includes:

a. the initial investment, ( 5 points)

b. the annual net cash flows, and (46 points)

c. the terminal cash flow. (7 points)

2. What is the Net Present Value (NPV) and Internal Rate of Return (IRR) of this venture? (5 points)

3. Should you invest in this venture and why? (2 points)

(TOTAL 65 POINTS)

MACRS Depreciation Table

Year

3-yr

5-yr

7-yr

10-yr

1

33.0

20.0

14.0

10.0

2

45.0

32.0

25.0

18.0

3

15.0

19.0

17.0

14.0

4

7.0

12.0

13.0

12.0

5

12.0

9.0

9.0

6

5.0

9.0

7.0

7

9.0

7.0

8

4.0

7.0

9

7.0

10

6.0

11

3.0

Individual Assignment Rubric

  1. Prepare a cash flow analysis which includes:

  1. the initial investment, (includes purchase price 2 points; NWC 2 points; total costs 1 point) ( 5 points)
  2. the annual net cash flows, (includes Revenues 5 points; Breakdown of all expenses 6 points; total operating expenses 5 points; depreciation 5 points; Earnings Before Taxes 5 points; Taxes 5 points; Earnings After Taxes 5 points; Depreciation Add back 5 points) (46 points)
  3. the terminal cash flows (include taxes on sale 5 points, NWC 1 point, Terminal Sale 1 point) (7 points)

  1. Correct Calculation of Net Present Value (NPV) (3 points) ; Correct Calculation of Internal Rate of Return (IRR) (2 points) (5 points)

  1. Correct decision to invest in this venture and why? (2 points)

Homework Answers

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Fresh off the excitement of the 2012 London Olympic Games, you decide that you want your...
Fresh off the excitement of the 2012 London Olympic Games, you decide that you want your firm to take advantage of the profits to be made for the 2016 games in Rio de Jeneiro. To do so you plan to open a factory in Brazil. After examining the idea, your CFO projects revenues next year (2013) to be $15 million and costs to be $8 million. Both of these are expected to grow at a rate of 29.0% per year...
A capital budgeting project is being considered for implementation. The asset is a 3-year MACRS class...
A capital budgeting project is being considered for implementation. The asset is a 3-year MACRS class asset with a four-year project life. The cost of the asset, and the first year revenue and operating cost projections are provided in the table below: Price of Asset $280,000.00 Freight / Installation $20,000.00 Depreciation Schedule: Year 1 $99,000.00 Year 2 $135,000.00 Year 3 $45,000.00 Year 4 $21,000.00 Salvage Value $30,000.00 Increase in NWC $25,000.00 Revenues from project $260,000.00 Operating Costs (excluding depreciation) $115,000.00...
Commercial Decor Pty Ltd is considering investing in a new machine to assemble its furniture. The...
Commercial Decor Pty Ltd is considering investing in a new machine to assemble its furniture. The machine is estimated to cost $150,000 which can last for 5 years before it becomes unreliable and can be sold for scrap at $12,000. The project is estimated to bring in additional $40,000 net cash inflow annually. The net cash flow in year 5 also includes the scrap value. The company uses a 13 per cent discount rate as the required rate of return...
You have been asked by an investor to value a restaurant. Last year, the restaurant earned...
You have been asked by an investor to value a restaurant. Last year, the restaurant earned pretax operating income of $350,000. Income has grown 5% annually during the last five years, and it is expected to continue growing at that rate into the foreseeable future. The annual change in working capital is $30,000, and capital spending for maintenance exceeded depreciation in the prior year by $20,000. Both working capital and the excess of capital spending over depreciation are projected to...
Q5) Your corporation is considering investing in a new product line. The annual revenues (sales) for...
Q5) Your corporation is considering investing in a new product line. The annual revenues (sales) for the new product line are expected to be $163,994.00 with variable costs equal to 50% of these sales. In addition annual fixed costs associated with this new product line are expected to be $56,720.00 . The old equipment currently has no market value. The new equipment cost $74,629.00 . The new equipment will be depreciated to zero using straight-line depreciation for the three-year life...
Sugar Land Company is considering adding a new line to its product mix, and the capital...
Sugar Land Company is considering adding a new line to its product mix, and the capital budgeting analysis is being conducted by a MBA student. The production line would be set up in unused space (Market Value Zero) in Sugar Land’ main plant. Total cost of the machine is $330,000. The machinery has an economic life of 4 years and will be depreciated using MACRS for 3-year property class. The machine will have a salvage value of $35,000 after 4...
Problem 1 (85% of grade) Summer Tyme, Inc. has cash available and is considering a new...
Problem 1 (85% of grade) Summer Tyme, Inc. has cash available and is considering a new three-year expansion project that requires an initial fixed asset investment of $195.5 million. The fixed assets will be depreciated straight-line to zero over its three-year tax life. The fixed assets will have a market value of $95,871,755 at the end of the project. The project is estimated to generate following revenues during those three years: $84,563,662 for year one, $66,352,100 for year two, and...
The ABD company is considering the purchase of a new machine to replace an out of...
The ABD company is considering the purchase of a new machine to replace an out of date machine that has a book value of $18000 and can be sold today for $2,000. The old machine is being depreciated on a straightline basis over 4 more years to a book value of $2000 at the end of the fourth year. The old machine generates annual revenues of $105000 and annual expenses of $75000. This machine requires a fixed investment of $5000...
This case continues following the new project of the WePPROMOTE Company, that you and your partner...
This case continues following the new project of the WePPROMOTE Company, that you and your partner own. WePROMOTE is in the promotional materials business. The project being considered is to manufacture a very unique case for smart phones. The case is very durable, attractive and fits virtually all models of smart phone. It will also have the logo of your client, a prominent, local company and is planned to be given away at public relations events by your client. As...
HEALTHY OPTIONS INC. Healthy Options is a Pharmaceutical Company which is considering investing in a new...
HEALTHY OPTIONS INC. Healthy Options is a Pharmaceutical Company which is considering investing in a new production line of portable electrocardiogram (ECG) machines for its clients who suffer from cardiovascular diseases. The company has to invest in equipment which costs $2,500,000 and falls within a MARCS depreciation of 5 years, and is expected to have a scrap value of $200,000 at the end of the project. Other than the equipment, the company needs to increase its cash and cash equivalents...