Financial Plan Excel spreadsheet Design a 3 to 5 year financial plan to implement the goals and objectives created in Part II of your strategic plan. The deliverables for the financial plan include a projected budget created in Microsoft® Excel that clarifies and explains the financial plan. Prepare a Projected Budget for your strategic plan in Microsoft Excel (See example in the course materials newsgroup)The projected budget should be a Microsoft® Excel® spreadsheet that contains a 3 to 5 year financial projection that includes detailed expenditures, income, contingency, gain or loss, and ROI (if applicable). When preparing a budget, nothing is in stone. Let your spreadsheet work for you. Identify assumptions in your spreadsheet. Use that section to build your formulas. (See example in the course materials newsgroup). If you use your assumptions in your formulas correctly, it allows you to make adjustments should contingencies arise. For example, if you build in 2.5% increase in salaries each you and you don’t perform well and salary projects have to be cut to 2%, you can change the assumption and you spreadsheet will adjust the calculations. If you cannot obtain financial details, the details may be assumed. In the spreadsheet identify the organization’s current business model.
0 comments:
Post a Comment