Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. finance
  3. please shows step by steps solution! rick is

Please shows step by steps solution! Rick is considering expanding...

60.1K

Verified Solution

Question

Finance

image

Please shows step by steps solution!

Rick is considering expanding his pizza empire and opening up a new upscale pizza shop. The life of the pizza shop is expected to be 10 years, at which time Rick plans to retire. Rick is unsure of the proper discount rate to use (as he has not yet studied Chapter 14 of the textbook), but he believes it is either 7% or 12%. Likewise, he thinks his IRR Hurdle rate is 7% or 12%. Rick has developed two scenarios for the projected cash flows of his pizza empire. The cash flows are shown below. Prepare an analysis and state whether or not you believe that Rick should open up the new shop. Submit a Word document, but include any analysis that you believe is appropriate from Excel. Year 0 1 NM 4 5 6 Scenario 1 -1,200,000 -200,000 200,000 300,000 350,000 375,000 405,000 405,000 405,000 405,000 450,000 450,000 450,000 450,000 900,000 Scenario 2 -1,600,000 -600,000 -250,000 300,000 300,000 300,000 300,000 300,000 500,000 500,000 500,000 500,000 500,000 500,000 1,200,000 7 8 9 10 11 12 13 14

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Basic Math
1.2K views

a Sketch the graph of the parametric curve x 3 sint 3 y 4 cos...

Finance
1.2K views

Use the following returns for X and Y. Returns Year X Y 1 22.0 % 27.0...

Finance
1.2K views

Current one-year interest rates in Europe is 4 percent, while one-year interest rates in the U.S....

Psychology
1.2K views

What are some shortcomings in Karl Marx’s theory of history?

Biology
1.2K views

O is hydrophobic O consists of three fatty acids attached to a glycerol O O...

Calculus
1.2K views

Write each equation in logarithmic form 7 1 O log 0 1 O log 1...

Accounting
1.2K views

In a statement of cash flows, a change in prepaid expenses would be classified as...

Accounting
1.2K views

ABC purchases $1,000 of merchandise on account. ABC's journal entry to record this transaction includes...

Accounting
1.2K views

Accounting information Systems The second question (A) - The number of inventory control jobs? (B)...

Accounting
1.2K views

On December 1, Jasmin Ernst organized Ernst Consulting. On December 3 , the owner contributed...

Accounting
1.2K views

Consider the following balance sheet. Balance Sheet - Seagate Technology (in...

Finance
1.2K views

The US Treasury issues Inflation-Protected Securities, also known as TIPS. TIPS are issued with maturities...