WEEK 3: COURSE PROJECT ACTIVITY

BudgetProposalWorkbook-1.xlsx

Instructions

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.

Put your sales forecasting calculations here.
	Year 1	Year 2	Year 3	Year 4	Year 5
Sales - Products	500,000	535,500	573,521	614,240	657,852
Sales - Services	7,500	8,033	8,603	9,214	9,868
Products - Volume	Year 1	Year 2	Year 3	Year 4	Year 5
Sales - units	500.00	525.00	551.25	578.81	607.75
Avg. Price / unit	1,000.00	1,020.00	1,040.40	1,061.21	1,082.43
Services - Volume	Year 1	Year 2	Year 3	Year 4	Year 5
Service units	75.00	78.75	82.69	86.82	91.16
Avg. Price / Service	100.00	102.00	104.04	106.12	108.24
Sales - ( $ )	Year 1	Year 2	Year 3	Year 4	Year 5
Sales - Product ( $ )	500,000	535,500	573,521	614,240	657,852
Sales - Services ( $ )	7,500	8,033	8,603	9,214	9,868

Put your detailed cash inflows and cash outflows here, also showing net cash flow.

Create an NPV analysis here.

Show your rate of return calculations in this worksheet.

Show your payback period calculations here.

Put your pro forma income statement, balance sheet, and cash budget here, along with any other supporting calculations or schedules.