Training on Financial Modeling using Excel

Module 1: Introduction to Financial Modeling

• Fundamentals and purpose of financial modeling
• Key concepts and best practices in model building
• Steps in developing effective financial models
• Common applications of financial models in business decision-making
• Case Study: Using financial modeling to evaluate a new business opportunity
• Practical: Designing a simple financial model structure

Module 2: Excel Tools & Techniques for Financial Modeling

• Understanding modern versions of Excel
• Risks, limitations, and alternatives to Excel
• Cell referencing, linking worksheets, and naming ranges
• Productivity shortcuts and efficiency tools
• Essential and advanced Excel formulas/functions for finance
• Case Study: Improving reporting accuracy through Excel automation
• Practical: Applying advanced Excel tools and formulas in finance models

Module 3: Planning, Designing & Scenario Analysis

• Defining the business problem your model should solve
• Structuring inputs, calculations, and output sections
• Gathering data and documenting assumptions/limitations
• Scenario analysis, drop-down models, and sensitivity testing
• Using Scenario Manager and Data Tables
• Case Study: Loan repayment and investment scenario comparisons
• Practical: Building a scenario-based financial model

Module 4: Financial Statements Modeling

• Entering assumptions and drivers
• Revenue and expense forecasting
• Building the Income Statement
• Building the Cash Flow Statement
• Building the Balance Sheet
• Integrating linked financial statements
• Case Study: Building a three-statement model for a growing company
• Practical: Creating a dynamic integrated financial statements model

Module 5: Valuation, Reporting & Advanced Model Outputs

• Discounted Cash Flow (DCF) valuation fundamentals
• Calculating Free Cash Flow to Firm (FCFF)
• Weighted Average Cost of Capital (WACC)
• Terminal value and valuation outputs
• Charts, dashboards, and presentation of model outputs
• Budget templates, depreciation, and asset planning models
• Case Study: Valuing a company using DCF analysis
• Practical: Building a valuation model and presenting results visually