Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Briefly describe the NVP, IRR, accounting rate of return, and payback period for this analysis. Indicate the discount rate you used, and how you arrived

Briefly describe the NVP, IRR, accounting rate of return, and payback period for this analysis. Indicate the discount rate you used, and how you arrived at it.

4.1 Cash flows

Provide an Excel spreadsheet screenshot that shows how you arrive at the net cash flows for each period in your planning horizon and describe its highlights.

4.2 NPV Analysis

Provide a screenshot of your Excel NPV analysis here, and describe its highlights.

4.3 Rate of Return

Provide a screenshot of your IRR and accounting rate of return calculations here, and explain the highlights.

4.4 Payback Period

Provide a screenshot of your Excel calculation of the payback period for this venture.

image text in transcribed Papa Geo's first year will be between January and December, Papa Geo's will have an estimated Grand Opening date of July 31, 2017. During the remainder portion of the year which consists of five months will conclude the Papa Geo's Grand opening. With growing popularity, we are hoping to bring in more customers. With the assumption that at least 25% of the neighboring towns population of 10,000 come in to eat at Papa Geo's at least three times a month we project sales in 2018 to increase. By the end of 2018 we are anticipating for at least 50% of the neighboring population become regulars at our new family oriented restaurant. 2017 Sales 100,000 2018 120,000 2019 144,000 2020 230,400 2021 414,720 We estimate that Papa Geo will attract at least 1,000 families for dinner and entertainment at least once every time we offer specials during the year. We also are projecting that we will see at least 85% of the population will be dinning with us about 14 times a year from year 2019 on. While we have estimated that during the first three years our sales will steadily increase by 20% we are looking towards a 60% increase in year 2020, and an 80% increase in sales in year 2021. With the constant chance in our fast pace economy we expect our sales to fluctuate which means our sales should be monitored and a close eye on costs annually. Question: Briefly describe the NVP, IRR, accounting rate of return, and payback period for this analysis. Indicate the discount rate you used, and how you arrived at it. 4.1 Cash flows Provide an Excel spreadsheet screenshot that shows how you arrive at the net cash flows for each period in your planning horizon and describe its highlights. 4.2 NPV Analysis Provide a screenshot of your Excel NPV analysis here, and describe its highlights. 4.3 Rate of Return Provide a screenshot of your IRR and accounting rate of return calculations here, and explain the highlights. 4.4 Payback Period Provide a screenshot of your Excel calculation of the payback period for this venture

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Cost Accounting

Authors: William Lanen, Shannon Anderson

2nd Edition

0071332618, 978-0071332613

More Books

Students also viewed these Accounting questions

Question

Define logistics. How is it different from transportation?

Answered: 1 week ago

Question

Why was humanistic psychology referred to as a third force?

Answered: 1 week ago

Question

2. It is the results achieved that are important.

Answered: 1 week ago