Want to build a complete financial model from scratch and understand how analysts actually use financial modelling for equity research and valuation?
This 20-hour complete Financial Modelling Course covers the key concepts required to build an integrated financial model and move from historical financials to valuation.
?? What You’ll Learn
1. Financial Statement Modelling
Understanding the Income Statement, Balance Sheet & Cash Flow Statement
Linking the three financial statements
Building an integrated financial model
2. Financial Forecasting
Revenue forecasting
Expense & margin assumptions
Working capital forecasting
Building realistic financial projections
3. PPE Schedule
Property, Plant & Equipment schedule
Capex assumptions
Depreciation calculations
Linking PPE schedules with financial statements
4. Other Equity & Supporting Schedules
Equity schedules
Retained earnings
Debt and other supporting schedules
Understanding how schedules flow into the financial statements
5. DCF Valuation
Building a Discounted Cash Flow model
Free Cash Flow calculations
Terminal Value
Discounting future cash flows
Enterprise Value & Equity Value
6. WACC
Cost of Equity
Cost of Debt
Capital structure
Calculating Weighted Average Cost of Capital
7. Relative Valuation
P/E
EV/EBITDA
EV/Sales
Peer comparison
Understanding valuation multiples
?? By the End of This Course
You will have a practical understanding of how to build a complete financial model and value a company using both DCF and Relative Valuation.
This course is designed for MBA Finance students, CFA candidates, aspiring Equity Research Analysts, Investment Banking aspirants and finance professionals looking to develop practical modelling skills.
20 Hours | Practical Financial Modelling | DCF | Forecasting | Valuation
Subscribe to RK Advisory for more content on Equity Research, Financial Modelling, Valuation and Capital Markets.