Learning Outcomes

• Participants should be able to build a well structured three statement financial model for companies in manufacturing & service sectors.
• They should also be able to build trading comps and DCF models
  

Who should attend?

• Professionals aspiring for career in valuation, equity research, investment banking, general purpose financial models
  

Course Structure

Day 1

Session 1

MS Excel for financial modelling 

• MS Excel best practices for financial modelling
• Working with Tables
• Set functions (Sumifs, Countifs, etc)
• Lookup functions
• Financial function
  

Session 2

Steps in building a financial model

• CAGR vs arithmetic mean
• Enhanced application of TVM concepts
• Numerical series (AP/GP) applications in financial modelling
• Handling circular references through algebra
  

Session 3

IndAS and challenges to analyzing historicals

• Overview of IndAS 109, IndAS 115, and IndAS 116
• Impact of change in standards on historical financials

Session 4

Modelling revenue

• Identifying the right business drivers
• Computing organic and inorganic growth rates
• Modelling with volume and price
• Complex revenue modelling
  

Session 5

• Modelling expense as percentage of sales
• Reading fixed asset schedule
• Modelling capex and depreciation
• Capex and depreciation modelling under SLM method
  

Day 2

Session 6

Modelling debt and interest

• Reading debt schedule
• Calculating effective interest rate
• Modelling repayments
• Forecasting future borrowings
• Modelling short term debt with cash sweep
• Debt sculpting using LLCR 

Session 7

Modelling other line items

• Modelling non-operating income
• Modelling taxes
• Modelling minority interest
• Modelling basic and diluted EPS
  

Session 8

Integrating financial models

• Linking income statement and balance sheet
• Modelling cash flow statement
• Creating checks
• Troubleshooting balance sheet mismatch
  

Session 9

Valuation

• Approaches to valuation
• Firm value and equity value
• DCF modelling principles and practice
• Preparing trading comps
• Preparing transaction comps
• Filter extreme values in trading / transaction comps
• Sensitivity analysis

Trainer Profile

The trainer has rich expertise in advanced financial modelling, advanced MS Excel, IFRS, capital markets and wealth management. He teaches various courses including financial modelling, financial engineering and actuarial science. He is CA ,CFA and FRM by education .

Training dates - August 19-20, 2025

Training fees - ₹ 30,000 + applicable taxes