Instructions Sally owns the East End Pizza Shop. She has been so busy and successful; she wants to open a second store called the West End Pizza Shop. She has lined up investors and a bank loan but before she signs on the dotted line, she is going to crunch some numbers. Here is the information that she has compiled: The cost of the new store's building is $200,000 The cost of new pizza ovens is $12,000 She will have to spend $50,000 to renovate the new building Sally wants to own the new shop for 5 years at which time she will close up and retire in Florida. In 5 years she expects to sell her business for $215,000 She expects to be able to sell 4,000 pizzas in the first year and 5% more pizzas each subsequent year The price of a pizza is $15.00 and costs $4.50 to make On average she sells 3.2 cans of pop with every pizza The price of a can of pop is $2.00 and costs $0.75 from the supplier Her electricity bill will be $500 per year She will have to pay $20,000 per year for part-time staff The combined required rate of return by both her investors and the bank is 12% What is the NPV of the new shop? What is your recommendation? Should she open the new store?

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
Items/ Year
Initial Investment
# Pizza's Sold
Pizza Revenue
Less: Pizza Cost
Net Pizza Cash Flow
# Pop Sold
Pop Revenue
Less: Pop Cost
Net Pop Cash Flow
Electricity
Salaries
Total Other Costs
Proceeds from Sale of Business
Net Cash Flow
Present Values of Cash Flows
NPV
Sally's West End Pizza Shop Opportunity
$
$
$
$
0
'
Pizza Sales
$
$
$
Pop Sales
SS
$
$
$
$
Other Costs
$
1
$
ՄԴ
$
$
-
-
I
I
-
eses es
$
$
$
$
ssssss
$
$
$
$
$
$
$
2
-
-
-
-
-
-
-
-
$
$
$
$
$
$
ess
$
$
in
in
$
$
3
-
-
-
-
-
-
I
-
$
en
in
$
$
ՄԴ
$
$
$
s
$
esss
$
$
$
$
4
-
-
-
-
$
sssss
$
$
SsSs
$
$
$
$
ssss
$
$
SSS
$
$
$
5
-
I
I
-
I
I
I
Transcribed Image Text:Items/ Year Initial Investment # Pizza's Sold Pizza Revenue Less: Pizza Cost Net Pizza Cash Flow # Pop Sold Pop Revenue Less: Pop Cost Net Pop Cash Flow Electricity Salaries Total Other Costs Proceeds from Sale of Business Net Cash Flow Present Values of Cash Flows NPV Sally's West End Pizza Shop Opportunity $ $ $ $ 0 ' Pizza Sales $ $ $ Pop Sales SS $ $ $ $ Other Costs $ 1 $ ՄԴ $ $ - - I I - eses es $ $ $ $ ssssss $ $ $ $ $ $ $ 2 - - - - - - - - $ $ $ $ $ $ ess $ $ in in $ $ 3 - - - - - - I - $ en in $ $ ՄԴ $ $ $ s $ esss $ $ $ $ 4 - - - - $ sssss $ $ SsSs $ $ $ $ ssss $ $ SSS $ $ $ 5 - I I - I I I
Instructions
Sally owns the East End Pizza Shop. She has been so busy and successful; she wants
to open a second store called the West End Pizza Shop. She has lined up investors and
a bank loan but before she signs on the dotted line, she is going to crunch some
numbers. Here is the information that she has compiled:
.
.
.
.
.
The cost of the new store's building is $200,000
The cost of new pizza ovens is $12,000
She will have to spend $50,000 to renovate the new building
Sally wants to own the new shop for 5 years at which time she will close up and
retire in Florida. In 5 years she expects to sell her business for $215,000
She expects to be able to sell 4,000 pizzas in the first year and 5% more pizzas
each subsequent year
The price of a pizza is $15.00 and costs $4.50 to make
On average she sells 3.2 cans of pop with every pizza
The price of a can of pop is $2.00 and costs $0.75 from the supplier
Her electricity bill will be $500 per year
She will have to pay $20,000 per year for part-time staff
The combined required rate of return by both her investors and the bank is 12%
What is the NPV of the new shop? What is your recommendation? Should she open
the new store?
Transcribed Image Text:Instructions Sally owns the East End Pizza Shop. She has been so busy and successful; she wants to open a second store called the West End Pizza Shop. She has lined up investors and a bank loan but before she signs on the dotted line, she is going to crunch some numbers. Here is the information that she has compiled: . . . . . The cost of the new store's building is $200,000 The cost of new pizza ovens is $12,000 She will have to spend $50,000 to renovate the new building Sally wants to own the new shop for 5 years at which time she will close up and retire in Florida. In 5 years she expects to sell her business for $215,000 She expects to be able to sell 4,000 pizzas in the first year and 5% more pizzas each subsequent year The price of a pizza is $15.00 and costs $4.50 to make On average she sells 3.2 cans of pop with every pizza The price of a can of pop is $2.00 and costs $0.75 from the supplier Her electricity bill will be $500 per year She will have to pay $20,000 per year for part-time staff The combined required rate of return by both her investors and the bank is 12% What is the NPV of the new shop? What is your recommendation? Should she open the new store?
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Factors Affecting Housing Decision
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
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