Financial Modelling Course Delhi - Excel & Valuation Training | Rankers Financial Academy
Enroll Now
📊 HANDS-ON TRAINING • ENROLLMENTS OPEN

Financial Modelling & Excel Mastery

Build investment-grade financial models from scratch — Advanced Excel, DCF valuation, scenario analysis and executive dashboards. Leave with a portfolio of real models you built yourself.

5 Modules
2–3 Months
Delhi + Online

Program Highlights

A practical, output-driven course — every session ends with a model you built and can show employers

Real Company Data
Models built on actual listed companies — not hypothetical numbers
Hands-on Every Session
No slide-only lectures — you build in Excel throughout
Portfolio of 4+ Models
Walkable, interview-ready models for banking and finance roles
Completion Certificate
Rankers Financial Academy certificate on successful completion
Valuation Focus
DCF, comparable company analysis and LBO fundamentals
Small Batches
Instructor reviews your model, not just a template answer

Course Modules

Five progressive modules — from Excel foundations to investment-grade valuation models

Module 1Advanced Excel for Finance
Weeks 1–2 · Keyboard shortcuts, power functions, dynamic arrays
▸ Financial keyboard shortcuts & formatting best practices  ▸ Advanced lookup functions: XLOOKUP, INDEX/MATCH, OFFSET  ▸ Dynamic arrays: FILTER, SORT, UNIQUE, SEQUENCE  ▸ Named ranges & structured table references  ▸ Data validation, dropdown lists & error trapping  ▸ PivotTables for financial data & Power Query basics
Excel
Module 2Financial Statement Modelling
Weeks 3–4 · 3-statement model linking P&L, balance sheet & cash flow
▸ Historical data input & normalisation  ▸ Revenue & cost driver assumptions  ▸ Depreciation, capex & fixed asset schedules  ▸ Working capital schedule (AR, AP, inventory days)  ▸ Debt schedule & interest calculations  ▸ Balancing the balance sheet & cash flow statement  ▸ Circular reference handling (iterative calculation)
Modelling
Module 3DCF Valuation & Business Valuation
Weeks 5–6 · WACC, terminal value, comparable company analysis
▸ Free Cash Flow to Firm (FCFF) projection  ▸ WACC: cost of equity (CAPM), cost of debt, capital structure  ▸ Terminal value: Gordon Growth vs exit multiple methods  ▸ Enterprise value to equity bridge  ▸ Comparable company analysis (trading comps)  ▸ Precedent transaction analysis  ▸ Football field chart — presenting a valuation range
Valuation
Module 4Scenario & Sensitivity Analysis
Week 7 · Data tables, scenario manager, Monte Carlo basics
▸ One-way and two-way data tables  ▸ Scenario manager: bull / base / bear cases  ▸ Tornado chart for key value drivers  ▸ Goal Seek & Solver for target-driven analysis  ▸ Introduction to Monte Carlo simulation in Excel  ▸ Presenting sensitivity analysis to management
Analysis
Module 5Dashboard & Executive Reporting
Week 8 · Interactive dashboards, charts, management reporting
▸ Dashboard design principles for finance  ▸ Dynamic charts: waterfall, combo, sparklines  ▸ Slicers, timelines & interactive filters  ▸ KPI tiles & conditional formatting techniques  ▸ Management report layouts — monthly P&L decks  ▸ Protecting, sharing & publishing Excel models
Dashboard

Study Pathway

1
Excel Foundations (Weeks 1–2)
Master the tools — functions, arrays, pivot tables — before touching a financial model
2
3-Statement Model (Weeks 3–4)
Build a fully linked P&L, balance sheet and cash flow using a real listed company
3
DCF Valuation (Weeks 5–6)
Layer valuation onto the 3-statement model — WACC, terminal value, comps and football field
4
Scenario & Sensitivity (Week 7)
Stress-test your valuation — data tables, scenarios and tornado charts
5
Dashboard & Certification (Week 8)
Build a management dashboard, polish your portfolio, receive your completion certificate

Who Is This For?

Anyone who works with — or wants to work with — financial data

Finance & MBA Students
Build the practical Excel skills that campus placements expect but courses don't teach
CFA & CA Candidates
Complement your theoretical finance knowledge with real model-building ability
Working Professionals
Analysts and finance associates who want to move from data entry to model ownership
Career Switchers
Engineers or non-finance graduates targeting IB, PE, equity research or corporate finance

Program Details

Course Fee
Contact for Pricing
Full program pricing on enquiry
Modules
5 (Excel → Dashboard)
Duration
2–3 months
Certificate
On completion
Mode
Delhi + Live Online
Enrollments
Open — Join Now
Enroll Now →

What You Build

3-Statement Financial Model
Fully integrated P&L, balance sheet and cash flow on a real Indian listed company
DCF Valuation Model
WACC-based valuation with comps and a football field presentation
Scenario Analysis Model
Bull/base/bear scenarios with tornado charts and data tables
Executive Dashboard
Dynamic, slicer-driven dashboard ready to present to senior management

Have Questions?

📞 +91 9818834083
📍 Karkardooma Complex, Anand Vihar, Delhi
Chat on WhatsApp