NEED week 1-5
Papa Geo’s Restaurant
Budget Proposal
For
[5 Years]
|
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: BUSN278 Budgeting and Forecasting |
|
|
|
|
7.2 |
Appendix 2:
|
|
[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]
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 what you will talk about – it contains the major, specific content of each section. The second and third paragraph should be written after you have completed all other sections of this template.
As you complete sections of this template, please remove all italicized text in all sections of this template and replace it with your own or you will lose points!
Briefly introduce the sales forecast section.
Here you should include a simple table showing the years and the total sales for each year, along with a brief explanation of why sales are expected to rise, fall, change, or stay the same in certain years. Provide a brief explanation of the sales forecast, indicating why you expect sales to rise or fall during the planning horizon. Your explanation should be consistent with the trends and changes in sales found in your table:
|
|
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
Sales |
|
|
|
|
|
Here you should describe how you arrived at your sales forecast in section 2.1. You should also provide any detailed calculations that led you to the sales forecast values. You should also summarize any research or figures that led you to make this sales forecast.
|
3.0 Capital Expenditure Budget |
Here you should provide a screenshot of your capital expenditure budget, also listing the sources of data and assumptions that led to each line item in table format. Briefly describe the total investment and, if necessary, why major items are necessary to achieve the company’s strategy.
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.
Provide a screen shot of your Excel NPV Analysis here, and describe its highlights.
Provide a screen shot of your IRR and Accounting Rate of Return calculations here, and explain the highlights.
Provide a screen shot of your Excel calculation of the payback period for this venture.
|
5.0 Pro-Forma Financial Statements |
Briefly introduce this section here.
Describe key figures and assumptions from the income statement, such as important profit or sales figures and their causes. Also, provide a screen shot of your pro-forma income statement.
Provide a screen shot of the cashflow statement and describe the impact of the budget on cash balances.
List any sources you cited in the body of your report.
NOTE: Start this section at the top of a new page.
This section of the budget proposal is where you’ll attach all of the supporting materials that you’ve referenced in the preparation of your plan, and that is too detailed or extensive to be included in the body of the report. Use this page to separate the appendices from the text in the body of your report. Make certain that you update the table of contents to include the title of each exhibit in the appendix and its page number.
They have a magnificent team. These people are always kind and willing to listen to your concerns or issues. Better yet, your assignment is always ready before the time, they usually send you a draft to double-check before they finalize your paper.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more