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
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 flowsProvide 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 AnalysisProvide a screenshot of your Excel NPV analysis here, and describe its highlights.
4.3 Rate of ReturnProvide a screenshot of your IRR and accounting rate of return calculations here, and explain the highlights.
4.4 Payback PeriodProvide a screenshot of your Excel calculation of the payback period for this venture.
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 ventureStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started