Course Outline:

Day 1: Introduction to Financial Modeling

• What is financial modeling?
• Basic concepts and purpose of financial models
• Overview of Excel functions relevant to financial modeling
• Case study: Introduction to a simple financial model

Day 2: Building a Basic Financial Model

• Structuring and organizing financial models
• Data inputs, assumptions, and linking cells
• Designing dynamic models: Relative and absolute cell references
• Project: Creating a basic financial model from scratch

Day 3: Financial Statements and Forecasting in Excel

• Building financial statements (Income statement, balance sheet, cash flow)
• Forecasting techniques: Simple growth, trend analysis, and assumptions
• Introduction to financial ratios and their calculations in Excel
• Real-life project: Forecasting financial statements for a sample company

Day 4: Scenario Analysis and Sensitivity Testing

• What-if analysis and scenario planning in financial models
• Using Excel tools: Data tables, Goal Seek, and Solver
• Sensitivity analysis: Understanding the impact of changing variables
• Case study: Applying scenario analysis in financial modeling

Day 5: Reporting and Presenting Financial Models

• Formatting financial models for clarity and ease of use
• Creating charts and graphs for data visualization
• Best practices in reporting financial model outputs
• Real-life project: Presenting a financial model to decision-makers