Business Planning and Financial Modeling using MS Excel

Business planning and financial modelling is a core skill that no financial professional should be without. This course is designed to teach participants the practicalities of modelling applied to a variety of different types of structures such as business planning, project financing, management and accounts and corporate structuring. This course will teach participants the modelling techniques available that can be used for accurate financial forecasting, and how to apply them using Excel. The course addresses the many shared characteristics of model types and identifies problems associated with the building of cash flow models.

Target Audience

• Finance and accounts professionals
• Operations and productions personnel
• Managers and departmental heads directly or indirectly involved in business planning, project financing, corporate structuring and financial modeling activities
• Knowledge workers who frequently work with data
• Professionals who want to increase their knowledge of intermediate to advanced features in Excel
• Data analysts, business intelligence professionals and individuals who need to translate data into meaningful results

• Spreadsheet Governance
• Key performance indicators (KPI)
• Financial
• Non-Financial
• Core structure of financial Models
• Perform corporate scenario analysis
• Corporate risk analysis
• Making the model intuitive
• Means of doing corporate valuation in case of Acquisition, Mergers
• Construction of financial modeling
• Some practical examples of financial modeling
• How to improve your model with appropriate ingredients/tools/synergy
• Format/flow of a model, (best Industrial practice)
• Whats a dashboard and effective use of the same
• Producing budget along with Its comparison
• Do visuals have magical powers: When good visuals go bad!
• Financial models with a complete mock example covering assumptions
• Model worksheet layout
• Operational assumptions in model
• Historical analysis and the weight to be given on it
• Key inputs to develop financial projections
• Based on corporate strategy
• Insight on stakeholders
• Insight on change in economic indicators and effect on projections
• Generic catalog of assumptions which can be used in nearly every business scenario
• Profit and Loss forecast
• Cash flow forecast
• Critical ratios
• Dashboard technique
• Investment appraisal
• IRR, NPV, MIRR, XIRR, Payback
• Financial calculations with and without beginning payment based on PMT, PV of loan
• Future values of yearly investment and future cash flows with annual incremental deposits
• Retirement plans
• Industrial ratios
• Manufacturing concerns
• Retail business
• Service organization
• Reason to avoid multiple clusters charts and stacked bar charts
• Banking models includes loan model using various tools like
• Data validation
• Scroll bars
• Various formulas
• Data tables (What-If Utility)
• Goal seek (What-If Utility)
• Graphs and Charts
• Conditional formatting
• Macros and using different ways to run them and allocating button to macros
• Naming names and its pros and cons
• Understanding protection in excel and protecting the model
• Some customization