Question Details

BUSN 278 Week 6 Course Project
 
A.	Week 6: Section 5.3: Pro Forma Cash Budget

B.	TCOs Addressed 

TCO 7: Given a historical balance sheet, historical income statement, sales forecast, assumptions and target financial ratios for a simple merchandising operation, create and evaluate pro forma financial statements

TCO 10: Given a description of a new business, new product, service or project develop, present and defend the budget 
            
C.	Project Activity Overview—Scenario/Summary 
 
Use the Budget Proposal Workbook.xlsx and Budget Proposal Template.docx to develop pro forma cash budgets for the new business.
 
D.	Deliverables

Complete Section 5.3: Pro Forma Cash Budgets. Also, provide cash budgets and other supporting budget calculations in the MS Excel template tab 5.0 in Budget Proposal Workbook.xlsx.

Add Section 5.3 to the Budget Proposal Template.docx and save it as YourName_Project_WK6.docx. Also add Section 5.3 to your Budget Proposal workbook.xls and save it as YourName_Worksheet_WK6.xlsx, and then upload both files to the Week 6 Project Dropbox.
 
E.	Project Tasks

Task 1	Add Pro Forma Cash Budgets to Section 5.0 of the Budget Proposal Workbook.xls and the Budget Proposal Template.docx.
Task 2	Save the Excel and Word documents and submit them to the Week 6 Project Dropbox.

 

F.	Grading Criteria

Description	Suggested Points
The pro forma cash budget is properly constructed. 	3
Other necessary supporting budgets are present and all calculations are correct.	3
The sources of figures in the pro forma cash budgets and assumptions are identified.	4