Student Project Activity—Week 6

Student Project Activity—Week 6

5. Week 6: Section 5.3: Pro Forma Cash Budget

 

1. 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

           

1. 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.

 

1. 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.

 

1. 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 Total Points 10 points

End of Week 6

Is this the question you were looking for? If so, place your order here to get started!