🎯Financial Modeling Course
Duration: 100 hours (Live session + Capstone)
Level: Beginner to Advanced
Format: Live Online Classes
Target Audience:
– UG/PG Finance Students
– Working Professionals
– Aspiring Equity Research Analysts, Invetsment Bankers, Corporate Finance Professionals
Outcome: Build real-world models from scratch, learn to study annual and equity research reports, and compare forecasts with expert reports.
- Introduction to Financial Modeling – Excel essentials, model design flow
- Understanding Annual & Equity Research Reports – Key components, extracting assumptions
- Excel for Finance – Advanced formulas, lookup & sensitivity tools
- Income Statement Modeling – Revenue forecasting, EBITDA build-up
- Balance Sheet Modeling – Linking assumptions, capex, working capital
- Cash Flow Statement Modeling – Indirect method, FCFF & FCFE
- Fully Integrated Financial Model – 3 statement linkage, circular references
- Valuation Techniques – DCF, Relative Valuation, Football Field Analysis
- Project Work – Model of listed company & expert report comparison
- Visualization & Presentation – Dashboards, pitchbook formatting
Speaker: Dipti Periwal
Assistant Professor | Founder, The Periwal School of Finance
