Create a 3- to 5-year financial plan to implement the goals and objectives created in Part 2 of your strategic plan. The deliverables for the financial plan include a projected budget created in Microsoft® Excel® and a report in Microsoft® Word that clarifies and explains the financial plan.
I. The Projected Budget – Microsoft Excel spreadsheet (see Preopening budget example!)
Create a projected budget
The projected budget should be a Microsoft® Excel® spreadsheet that contains a 3- to 5-year financial projection that includes:
Detailed revenue/income
Detailed Expenses
Net gain or loss
Capital Expenses / Contingency Plans
Description of Return on Investment.
The budget spreadsheet also includes:
Strategies to increase volume and
Budget assumptions. (See Preopening budget example).
II. Narrative: Financial Plan Explanation
Write a 1,050- to 1,400-word narrative discussing the fiscal details of the plan and the assumptions that were used in developing the projected budget. Include:
Describe the elements required in the projected budget. (Revenue and Expenses)
Describe capital expenditure planning and contingency plans for unexpected events.
Describe and identify the organization’s current business model.
Explain the details of the budget assumptions.
Explain the details of the strategies to increase volume.
