Budgeting and Forcasting-Business Proposal wk 1-wk7
Instructions
| BUSN-278 Budgeting and Forecasting Template Instructions |
| Use this spreadsheet structure to lay out the various sections of your project. |
| The purpose of this spreadsheet is to make it easy for your professor to locate the |
| various sections of your project. Please don't alter the Worksheet Tabs or titles. |
| After you finish your calculations in this spreadsheet, you will have to |
| create a written report where you take screenshots from this spreadsheet |
| and put them in the Budget Proposal Template, along with necessary |
| explanations. Detailed instructions for how to write the report |
| are found in the Budget Proposal Template, a word document. |
2.1 & 2.2 Sales Forecast
| Put your sales forecasting calculations here. |
3.0 Capital Expenditure Budget
4.1 Cashflows
| Put your detailed cash inflows and cash outflows here, also showing net cash flow. |
4.2 NPV Analysis
| Create an NPV Analysis here. |
4.3 Rate of Return Calculations
| Show your rate of return calculations in this worksheet. |
4.4 Payback Period Calculations
| Show your payback period calculations here. |
5.0 Pro Forma Financials
| Put your Pro-Forma Income Statement, Balance sheet and statement of cash flows here, along with any other supporting calculations or schedules. |