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