Financial Modelling
Unlock the power of financial analysis and create robust models for decision-making, forecasting, & business strategy.
Unlock Your Data Potential
Embark on a transformative journey to enhance your financial modelling skills. Our expert-led course will dive deep into advanced techniques, empowering you to create accurate forecasts and analysis. Join a community of like-minded learners to elevate your understanding and gain practical insights into the world of finance.
Hands-On Learning Experience
Engage in practical projects that allow you to apply your financial modelling skills in real-world contexts. Experience collaborative learning and receive immediate feedback.
Data-Driven Decision Making
Master financial modelling to make informed, data-backed decisions. Gain the ability to analyze financial performance and optimize business strategies.
Business Valuation Skills
Learn to build accurate financial models that assess company valuation, investment opportunities, and risk management.
Competitive Career Edge
Stand out in the finance and business world by acquiring a high-demand skill set. Financial modelling proficiency opens doors to investment banking and corporate finance.
Comprehensive Curriculum
Introduction to Financial Modelling & Valuation
- Refresher on fundamental accounting principles
- Building the Income Statement from the Trial Balance
- Building the Balance Sheet & Cash Flow Statement
- Introduction to Financial Ratios
Building a Financial Model Template
- Template Building from Scratch
- General Model Structure Design
- Working Across Multiple Sheets & Linking Sheets
- Absolute and Relative References
The Financial Model Core
- Projection Ratios and Scenarios (Optimistic, Base, Pessimistic)
- Financial Statements Forecasts
- Financial Project Planning Excel formulas
Different Types of Valuation Models
- Discounted Cash Flow (DCF) Model
- Comparative Company Analysis (comps) Model
- Leveraged Buy Out (LBO) & Merger and Acquisition (M&A) Models
- Sum-of-the-parts, Book value, and Dividend Discount Models
DCF Valuation & Ratios
- Calculation of WACC, CAPM and Cost of Debt
- Extracting The Equity Value from The Enterprise Value
- Sensitivity Analysis: WACC vs Perpetuity growth
- Liquidity, Asset Management, Leverage, and Profitability Ratios
Course FAQ
Got questions? We have answers. If you need more specific details, feel free to contact us.
What Our Clients Say
"The depth of the DCF valuation models taught here was exactly what our team needed. We rebuilt our internal forecasting sheets based entirely on this curriculum."
Capital Investment Group