Financial Modelling and Valuation in Excel
Why colleges run this
Financial modelling is the core screening skill for finance, consulting and analyst roles; a working valuation model is the most persuasive artefact a student can bring to those interviews.
Course outcomes
CO1
Structure a three-statement financial model with linked statements
K3CO2
Forecast financial statements from stated business drivers
K3CO3
Build a discounted-cash-flow valuation
K3CO4
Value a company using trading multiples
K3CO5
Justify a valuation in a written investment memo
K5Modules tap a module for its theory & lab
Hours shown are the recommended 5-day format — module time scales to the duration you pick.
01Excel for finance5 h
Theory
Functions, formatting, model structure
Lab
Build a clean model template
Output
Model template
02Three-statement foundations5 h
Theory
Income statement, balance sheet, cash-flow links
Lab
Map the statement linkages
Output
Linkage map
03Building the income statement5 h
Theory
Revenue drivers, cost structure
Lab
Model revenue and costs
Output
Income statement
04Balance sheet and cash flow5 h
Theory
Working capital, statement linkages
Lab
Complete the linked statements
Output
Linked model
05Forecasting and assumptions5 h
Theory
Drivers, scenarios, sensitivity
Lab
Forecast under scenarios
Output
Scenario model
06Discounted cash flow5 h
Theory
Free cash flow, WACC, terminal value
Lab
Build a DCF valuation
Output
DCF valuation
07Relative valuation5 h
Theory
Multiples, comparable companies
Lab
Value using multiples
Output
Comparables analysis
08Capstone valuation5 h
Theory
A complete model and valuation memo
Lab
Value a company end to end
Output
Model and valuation memo
Every participant receives
Certificate of completion Course material LMS access Interview question bank Mock interview & viva practice Optional nasscom NSQF assessment