Free Financial Modelling and Valuation Course
Financial Modelling and Valuation
Practice financial modelling in this free beginner course covering Excel standards, historical data, three-statement links, forecasts, debt schedules, DCF, comps, scenarios, dashboards, and valuation decisions for analysts.
About this course
Financial Modelling and Valuation is for learners who know basic financial statements and want to turn that knowledge into decision-ready analysis. This free course builds from Excel modelling standards into clean structure, formatting discipline, flexible formulas, named ranges, audit checks, historical data cleanup, key ratios, revenue drivers, and one-time adjustments. Instead of treating Excel as a spreadsheet task, it shows how models support planning and valuation work.
Once the foundation is clear, you connect the income statement, balance sheet, and cash flow statement into an integrated model. The learning path adds working capital, PP&E, top-down and bottom-up forecasts, assumptions, debt schedules, revolvers, interest calculations, circular references, free cash flow, WACC, terminal value, comparable companies, precedent transactions, sensitivity tables, scenarios, dashboards, and stakeholder presentation. By the end, you can explain how valuation outputs are built.
Course outline
Building the Foundation: Modelling Principles and Excel Standards
In this module, you'll learn model structure, Excel formatting standards, flexible formulas, named ranges, and how to audit for common modelling errors.
From Financial Statements to Model-Ready Historical Data
In this module, you'll learn to source and clean historical financials, calculate key ratios, identify revenue drivers, and adjust for one-time items.
Integrating the Income Statement, Balance Sheet, and Cash Flow
In this module, you'll learn to link the three statements, model working capital and PP&E, balance the sheet, and audit the integrated model.
Driving the Model: Forecasting Techniques and Assumptions
In this module, you'll learn top-down and bottom-up forecasting, revenue and cost drivers, working capital assumptions, and building transparent assumption pages.
Modelling Debt and Managing Circular References
In this module, you'll learn debt schedules, revolving credit and term loan modelling, interest expense calculation, and managing circular references.
Discounted Cash Flow Valuation from First Principles
In this module, you'll learn unlevered free cash flow, WACC estimation, terminal value methods, and deriving enterprise and equity value.
Relative Valuation: Comps and Precedent Transactions
In this module, you'll learn to select comparables, normalize valuation multiples, build precedent transaction tables, and triangulate valuation across methods.
Stress-Testing, Finalizing, and Presenting Your Model
In this module, you'll learn scenario toggles, sensitivity analysis, dashboard design, and presenting model outputs clearly to stakeholders.
Get access to the complete curriculum once you enroll in the course
Frequently Asked Questions
Will I receive a certificate upon completing this free course?
Is this course free?
What will I learn in this free financial modelling course?
What will I learn in this free financial modelling course?
Is Financial Modelling and Valuation beginner friendly?
What Excel skills are used in financial modelling training?
What Excel skills are used in financial modelling training?
Will I learn to build a three-statement model?
Will I learn to build a three-statement model?
How does the course teach forecasting assumptions?
How does the course teach forecasting assumptions?
Does this course include debt schedules and circular references?
Will I learn DCF valuation from first principles?
Will I learn DCF valuation from first principles?
Are comparable company and precedent transaction methods included?
Are comparable company and precedent transaction methods included?
How are scenario analysis and sensitivity tables used?
Who should take financial modelling and valuation online?
How are scenario analysis and sensitivity tables used?
Who should take financial modelling and valuation online?