Italian Valley Inc. 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 Incorporated. 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.68 million. An additional $585,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 $55,000 and inventory of $20,000. Accounts payable should average $20,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% over year one in the second year, 15% over year two in the third year, and continue increasing at 8% thereafter. Fixed annual operating costs are estimated to be as follows. Employee salaries = $150,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 20% of net revenues. Your plan is to run the bar for 5 years, then to sell it to an investor for $2,000,000.

Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
icon
Related questions
Question

Italian Valley Inc. 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 Incorporated. 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.68 million. An additional $585,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 $55,000 and inventory of $20,000. Accounts payable should average $20,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% over year one in the second year, 15% over year two in the third year, and continue increasing at 8% thereafter. Fixed annual operating costs are estimated to be as follows.

Employee salaries = $150,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 20% of net revenues.

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

A. Prepare a cash flow analysis which includes:
a.
the initial investment,
b. the annual after-tax operating cash flows, and
С.
the terminal year non-operating cash flow in year 5.
B. What is the Net Present Value (NPV) and Internal Rate of Return (IRR) of this venture?
C. Should you invest in this venture and why?
*MACRS Depreciation Table
MACRS Depreciation Table
3-yr
Year
5-yr
7-yr
10-yr
1
33.0
20.0
14.0
10.0
2.
3
45.0
32.0
25.0
18.0
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
Transcribed Image Text:A. Prepare a cash flow analysis which includes: a. the initial investment, b. the annual after-tax operating cash flows, and С. the terminal year non-operating cash flow in year 5. B. What is the Net Present Value (NPV) and Internal Rate of Return (IRR) of this venture? C. Should you invest in this venture and why? *MACRS Depreciation Table MACRS Depreciation Table 3-yr Year 5-yr 7-yr 10-yr 1 33.0 20.0 14.0 10.0 2. 3 45.0 32.0 25.0 18.0 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
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
New Line profitability analysis
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Essentials Of Investments
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
FUNDAMENTALS OF CORPORATE FINANCE
FUNDAMENTALS OF CORPORATE FINANCE
Finance
ISBN:
9781260013962
Author:
BREALEY
Publisher:
RENT MCG
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Foundations Of Finance
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education