2. the annual after-tax operating cash flows, and 3.the terminal year non-operating cash flow in year 5.
2. the annual after-tax operating cash flows, and 3.the terminal year non-operating cash flow in year 5.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Prepare a cash flow analysis which includes:
1.the initial investment,
2. the annual after-tax operating
3.the terminal year non-operating cash flow in year 5.
|
![1. Having assessed the changing dietary needs of your town, you are considering investing in a new
Italian restaurant, which you plan to name Ital-Valley-Inc. 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 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.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F7b01907d-dd5f-45f6-9dab-be8fb7482ae8%2Fcf286816-3c1a-4d37-b8cf-8c36e8e82c69%2Fuerh7mf_processed.jpeg&w=3840&q=75)
Transcribed Image Text:1. Having assessed the changing dietary needs of your town, you are considering investing in a new
Italian restaurant, which you plan to name Ital-Valley-Inc. 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 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.
![*MACRS Depreciation Toble
MACRS Depreciation Table
3-yr
5-yr
7-yア
14.0
Year
10-yr
33.0
20.0
10.0
2
45.0
32.0
25.0
18.0
19.0
17.0
13.0
15.0
14.0
4
7.0
12.0
12.0
5
12.0
9.0
9.0
6.
5.0
9.0
7.0
7
9.0
7.0
4.0
7.0
7.0
10
6.0
11
3.0](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F7b01907d-dd5f-45f6-9dab-be8fb7482ae8%2Fcf286816-3c1a-4d37-b8cf-8c36e8e82c69%2F38185tg_processed.jpeg&w=3840&q=75)
Transcribed Image Text:*MACRS Depreciation Toble
MACRS Depreciation Table
3-yr
5-yr
7-yア
14.0
Year
10-yr
33.0
20.0
10.0
2
45.0
32.0
25.0
18.0
19.0
17.0
13.0
15.0
14.0
4
7.0
12.0
12.0
5
12.0
9.0
9.0
6.
5.0
9.0
7.0
7
9.0
7.0
4.0
7.0
7.0
10
6.0
11
3.0
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education