WEEK 2 P

BudgetProposalWorkbookE.xlsx

Export Summary

This document was exported from Numbers. Each table was converted to an Excel worksheet. All other objects on each Numbers sheet were placed on separate worksheets. Please be aware that formula calculations may differ in Excel.
Numbers Sheet Name	Numbers Table Name	Excel Worksheet Name
Instructions
	Table 1	Instructions
2.1 & 2.2 Sales Forecast
	Table 1	2.1 & 2.2 Sales Forecast
3.0 Capital Expenditure Budget
	Table 1	3.0 Capital Expenditure Budget
4.1 Cashflows
	Table 1	4.1 Cashflows
4.2 NPV Analysis
	Table 1	4.2 NPV Analysis
4.3 Rate of Return Calculations
	Table 1	4.3 Rate of Return Calculations
4.4 Payback Period Calculations
	Table 1	4.4 Payback Period Calculations
5.0 Pro Forma Financials
	Table 1	5.0 Pro Forma Financials

BUSN278 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 in which 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.