Briefly describe theNVP, IRR, accounting rate of return, and payback period for this analysis. Indicate the discount rate you used, and how you arrived at it.
4.1Cashflows
Provide an excel spreadsheet screenshot that shows how you arrive at the net cashflows for each period in your planning horizon and describe its highlights.
4.2NPV Analysis
Provide a screen shot of your Excel NPV Analysis here, and describe its highlights.
4.3Rate of Return
Provide a screen shot of your IRR and Accounting Rate of Return calculations here, and explain the highlights.
4.4Payback Period
Provide a screen shot of your Excel calculation of the payback period for this venture.
Papa Geo’s Restaurant Budget Proposal For [5 Years] Table of Contents Section?Title?Subsection?Title?Page Number??1.0?Executive summary?????2.0?Sales Forecast???????2.1?Sales Forecast?????2.2?Methods and Assumptions???3.0?Capital Expenditure Budget?????4.0?Investment Analysis???????4.1?Cash flows?????4.2?NPV Analysis?????4.3?Rate of Return Calculations?????4.4?Payback Period Calculations???5.0?Pro Forma Financial Statements ???????5.1?Pro Forma Income Statement?????5.2?Pro-Forma Cash flow Statement?????5.3?Pro-Forma Balance Sheets???6.0?Works Cited?????7.0?Appendices???????7.1?Appendix 1: [description]?????7.2?Appendix 2:?[description] etc??? [Please put page numbers in the last column of the table of contents above, as they apply to your finished assignment. Do this after your project is complete. Also, remove this text and all text that is in italics in this template when finished your project.] [Also, please submit your Excel Spreadsheet which shows your supporting calculations] 1.0 Executive Summary The first paragraph of this executive summary should give a brief description of the business to which this budget applies.Very briefly describe the products and services of this company, the geographical or demographics of the customers it serves, and why people purchase the main product of this business. Much or all of this will be found in the Business Profile provided to you. Please use your own words, and please do not simply copy and paste the explanation in the course materials. Make assumptions if necessary.? Also, provide a second paragraph which describeshow the budget supports the company’s strategy. Finally, provide a third paragraph where you summarize the key points from your budget, including the planning horizon, the amount of up-front investment, the NPV, Payback and IRR of the project, as well as key figures from your income statement, cashflow statement, and balance sheet. Remember, this is not a thesis or introduction of…
Attachments:
project_budge….docx
proposal_work….xlsx