Financial Modelling Course

Our comprehensive Best Practice Financial Modelling certification program teaches the essential skills needed to build robust forecast models for companies. Through step-by-step video lessons and hands-on exercises, you will learn to create integrated balance sheet, income statement, and cash flow projections. 

Enroll today and gain the Excel proficiency needed to evaluate companies, make strategic decisions, and advance your finance career.

Whether you are an aspiring analyst or seasoned finance professional, this self-paced online course will advance your Excel modelling abilities and prepare you for careers in investment banking, private equity, corporate finance, and business valuation. Upon successful completion, you will receive a certificate affirming your new financial modelling skills.

Course Highlights:

• Essentials of financial model construction and design principles 
• Flexible time frameworks, forecasting operations, and linking historical data 
• Working capital modelling from an analyst perspective 
• Depreciation, debt structuring, interest expenses, and tax modelling 
• Key analysis techniques like DuPont Analysis and Discounted Cash Flow 
• Sensitivity analysis, scenario modelling, credit, and liquidity analysis 
• Certificate Upon Successful Completion 
• Empty space, drag to resize

Course Modules:

• Model Building
• This module guides learners through the essentials of constructing a robust financial model in Excel. Beginning with an introduction to financial modelling, it delves into modular design principles, golden rules for effective design, and the process of recasting financial statements for accurate modelling.
• Model Setup
• This module delves into the second phase of financial modelling, covering crucial aspects like proper model setup, creating a flexible time framework, linking historical data, forecasting operations, ensuring model balance, and a comprehensive debrief on linking operations.
• Working Capital
• Now lets look at working capital, first starting at an analysts perspective, then how to model working capital, and finishing off with quality control
• Asset and Liability Management
• Lets delve into topics such as depreciation, debt structures, interest expenses and income, modelling joint ventures and other assets, alongside a comprehensive examination of tax and deferred tax modelling. You will attain a solid understanding of managing assets and liabilities in financial models, ensuring accuracy and reliability in your financial analyses.
• DuPont
• This module introduces you to DuPont Analysis, a key financial analysis technique. You will understand the core components of DuPont Analysis, the calculation of capital employed, and practical implementation to assess a company's financial performance.
• Discounted Cash Flow
• This module guides you through fundamental valuation techniques in Excel, covering dividends, Discounted Cash Flow (DCF) analysis, Weighted Average Cost of Capital (WACC) calculation, and the determination of Enterprise Value (EV), Equity Value, and Share Price.
• Refining The Model
• This module enhances your financial modelling in Excel, covering margin sensitivity, refining CapEx/RoCE using DuPont analysis, and employing data tables for scenario analysis, enabling more accurate financial evaluations.
• Credit & Liquidity analysis
• This module provides you with a thorough understanding of credit and liquidity analysis, crucial for evaluating the financial health of businesses, especially in Excel.