Advanced Financial Modelling, Quantitative Finance and Econometrics · Physical, Online
Advanced Financial Modelling & Valuation Using Excel Training Workshop
10 Days5 sessions available Certificate on completion
The Advanced Financial Modelling & Valuation Using Excel Training Workshop equips participants with practical skills to develop dynamic, integrated, and decision-ready financial models using Microsoft Excel. The programme covers financial statement modelling, business forecasting, budgeting, cash flow projections, investment appraisal, company valuation, financing analysis, and financial risk assessment.
Participants learn to translate historical financial data and business assumptions into forward-looking models that support investment decisions, strategic planning, corporate finance, budgeting, and performance management. Advanced Excel capabilities—including financial functions, dynamic formulas, scenario analysis, sensitivity testing, Goal Seek, Data Tables, Solver, and interactive dashboards—are applied to realistic business and investment cases.
The workshop also covers model structuring, validation, error checking, documentation, and automation to improve the reliability, transparency, and usability of financial models.
Course objectives
Build integrated financial models linking income statements, balance sheets, and cash flow statements using advanced Excel techniques.
Design robust, auditable, and interactive financial models with automated calculations, validation controls, and management dashboards.
Conduct scenario analysis, sensitivity testing, and financial stress testing to evaluate uncertainty and investment risks.
Apply discounted cash flow (DCF), comparable-company valuation, and investment appraisal techniques to assess business and project value.
Who should attend
Financial Analysts, Corporate Finance Professionals, Investment Analysts, Investment Bankers, Accountants, Finance Managers, Financial Controllers, Chief Financial Officers, Treasury Professionals, Budget Officers, Investment and Portfolio Managers, Equity Research Analysts, Business Valuation Professionals, Project Finance Analysts, Risk Analysts, Credit Analysts, Financial Consultants, Business Analysts, Strategy and Planning Managers, Entrepreneurs, Business Owners, Private Equity Professionals, Venture Capital Professionals, Mergers and Acquisitions Analysts, and professionals responsible for financial planning, forecasting, valuation, or investment appraisal.
Course content
Module 1: Advanced Financial Modelling Principles and Model Design Financial modelling concepts and applications, financial model architecture and workbook organisation, separation of assumptions and calculations, model input and output design, spreadshe
Module 2: Advanced Excel Functions for Financial Modelling Advanced logical and lookup functions, XLOOKUP and INDEX-MATCH, SUMIFS and COUNTIFS, dynamic arrays, financial functions, date and time calculations, error-handling functions, named ranges, struc
Module 3: Historical Financial Statement Analysis Importing and organising historical financial statements, revenue and expense analysis, profitability and liquidity ratios, leverage and efficiency ratios, margin analysis, working capital assessment, cas
Module 4: Integrated Three-Statement Financial Modelling Building integrated income statement, balance sheet, and cash flow models, linking financial statements, forecasting revenue and operating expenses, modelling depreciation and amortisation, working
Module 5: Revenue Forecasting, Cost Modelling and Financial Projections Driver-based forecasting, revenue growth assumptions, price and volume modelling, customer and product revenue projections, fixed and variable cost modelling, operating margin foreca
Module 6: Budgeting, Cash Flow Forecasting and Financial Planning Operating and capital budgets, integrated budgeting models, monthly and annual cash flow forecasts, rolling forecasts, working capital planning, cash conversion cycle analysis, budget-vers
Module 7: Discounted Cash Flow (DCF) Valuation Free cash flow forecasting, free cash flow to the firm and equity, discount rate estimation, weighted average cost of capital (WACC), cost of equity and cost of debt, terminal value calculations, present val
Module 8: Comparable Company and Transaction Valuation Comparable-company selection, financial benchmarking, enterprise value and equity value, price-to-earnings ratios, EV/EBITDA and other valuation multiples, comparable-company analysis, precedent tran
Module 9: Capital Budgeting and Investment Appraisal Project cash flow modelling, capital expenditure evaluation, net present value (NPV), internal rate of return (IRR), modified internal rate of return (MIRR), payback period, discounted payback, profita
Module 10: Debt, Financing and Capital Structure Modelling Debt schedules, loan amortisation, interest calculations, repayment structures, debt capacity, debt-to-equity analysis, capital structure assumptions, refinancing scenarios, interest coverage, lo
Module 11: Scenario Analysis, Sensitivity Testing and Stress Testing Base-case, optimistic, and pessimistic scenarios, one-variable and two-variable Data Tables, Scenario Manager, Goal Seek, Solver, sensitivity matrices, revenue and cost shocks, interest
Module 12: Advanced Financial Modelling for Business Decisions Business expansion models, new product investment analysis, pricing and profitability models, cost-volume-profit analysis, break-even modelling, operational performance projections, business
Module 13: Mergers, Acquisitions and Transaction Modelling Transaction assumptions, sources and uses of funds, acquisition financing, purchase price analysis, pro forma financial statements, synergy estimates, integration costs, acquisition valuation, ea
Module 14: Financial Risk Analysis and Model Validation Financial risk identification, assumption validation, model error detection, formula consistency checks, balance sheet integrity checks, reconciliation procedures, sensitivity-based risk assessment,
Module 15: Financial Dashboards, Reporting and Model Automation Executive financial dashboards, dynamic charts, financial KPI reporting, PivotTables and PivotCharts, conditional formatting, interactive reporting, Power Query for financial data preparatio
Module 16: Integrated Financial Modelling Capstone Project Development of a complete financial model for a realistic business or investment case, historical financial analysis, integrated three-statement projections, revenue and expense forecasts, workin
General notes
Practical Outputs Participants will develop an integrated three-statement financial model, historical financial analysis workbook, five-year financial forecast, revenue and operating cost model, annual budget and rolling forecast, cash flow projection, working capital schedule, debt repayment schedule, DCF valuation model, comparable-company valuation, capital budgeting and investment appraisal model, scenario analysis framework, sensitivity analysis matrix, financial stress-testing workbook, break-even analysis, acquisition analysis model, financial KPI dashboard, model validation checklist, and final investment or business valuation report.
Tools and Technologies Microsoft Excel, advanced Excel formulas, XLOOKUP, INDEX-MATCH, SUMIFS, dynamic arrays, Excel financial functions, What-If Analysis, Scenario Manager, Goal Seek, Data Tables, Solver, PivotTables, PivotCharts, Power Query, conditional formatting, financial dashboards, and AI-assisted financial analysis tools.
Recommended Prerequisites Participants should have a working knowledge of Microsoft Excel and basic accounting or financial concepts. Familiarity with income statements, balance sheets, cash flow statements, and common financial ratios will help participants benefit fully from the advanced modelling exercises.
Frequently asked questions
The workshop is suitable for financial analysts, accountants, finance managers, investment analysts, corporate finance professionals, banking professionals, treasury officers, financial controllers, business valuation specialists, project finance analysts, investment managers, consultants, and business owners. It is particularly valuable for professionals who prepare financial forecasts, evaluate investments, develop budgets, or support strategic financial decisions.
You will learn how to build integrated financial statements, prepare financial forecasts, model revenue and operating costs, develop cash flow projections, calculate investment returns, value businesses, analyse financing structures, and conduct scenario and sensitivity analysis using Microsoft Excel. You will also practise model validation, error checking, and financial dashboard development.
Yes. Because this is an advanced workshop, participants should have a working knowledge of Microsoft Excel and basic accounting or financial concepts. Familiarity with income statements, balance sheets, cash flow statements, and financial ratios is recommended. Participants with limited experience may benefit from introductory Excel and financial analysis training before attending.
Yes. The programme covers discounted cash flow (DCF) valuation, weighted average cost of capital (WACC), enterprise and equity valuation, comparable-company analysis, net present value (NPV), internal rate of return (IRR), payback analysis, and capital budgeting. These techniques help participants assess business value, compare investment opportunities, and support financing and investment decisions.
Yes. The workshop emphasises hands-on modelling exercises and realistic business cases. Participants work towards developing an integrated three-statement financial model, financial forecasts, a DCF valuation model, investment appraisal worksheets, scenario and sensitivity analyses, and a financial dashboard. The practical work also covers model checks and validation to improve the reliability of financial calculations.
Yes. Banking and investment professionals can apply the techniques to credit and financing analysis, cash flow forecasting, debt repayment modelling, company valuation, capital structure analysis, investment appraisal, and financial risk assessment. The methods are also relevant to corporate banking, equity research, project finance, investment management, and corporate finance functions.