Certified Financial Modelling for Decision Making

Overview
Course Outline
Scheduled Dates

Course Overview

This intensive five-day certification course is designed for finance professionals and decision-makers who want to master the tools and techniques of financial modelling to support business strategy, investment analysis, risk evaluation, and planning.

Participants will gain hands-on experience in building financial models from scratch in Excel, applying structured modelling principles, using forecasting and valuation techniques, and running scenario-based simulations to make informed, data-driven decisions. The course includes in-depth coverage of Monte Carlo simulation, sensitivity analysis, and practical risk management strategies — all aligned with industry best practices.

Objective:

By the end of this programme, participants will be able to:

Apply Best Practices in Financial Model Design and Construction: Develop robust, transparent, and user-friendly financial models adhering to industry standards.
Master Advanced Forecasting Techniques: Utilise sophisticated methods like time series analysis, Monte Carlo simulation, and regression analysis to generate insightful projections.
Construct Integrated Three-Statement Financial Models: Build comprehensive models linking the Income Statement, Balance Sheet, and Cash Flow Statement.
Develop and Analyse Discounted Cash Flow (DCF) Valuation Models: Apply DCF methodology to determine the intrinsic value of a business or project.
Calculate and Interpret Key Feasibility and Valuation Indicators: Understand and utilise metrics such as NPV, IRR, Payback Period, and valuation multiples.
Evaluate and Apply Various Valuation Methodologies: Understand forecasting and non-forecasting valuation approaches beyond DCF.

Course Outline

Day 1: Foundations and Best Practices in Financial Modelling

Introduction to Advanced Financial Modelling: Purpose and Applications
Defining the Scope and Structure of Complex Financial Models
Establishing Best Practices in Model Design and Construction: Layout, Formula Integrity, Documentation
Avoiding Common Pitfalls and Worst Practices in Financial Modelling

Day 2: Advanced Forecasting Techniques and Technical Study

In-depth Exploration of Forecasting Guidelines: Linkage, Injection, Time Series Analysis
Applying Statistical Forecasting Methods: Regression Analysis and its Applications
Understanding and Implementing Monte Carlo Simulation for Scenario Planning
Technical Study Deep Dive: Modelling Capital Expenditure, Operational Expenses, Pricing Strategies, and Cost Structures

Day 3: Building the Integrated Financial Statements

Projecting the Income Statement: Detailed Modelling of Revenue, Cost of Goods Sold (COGS), and Operating Expenses (OpEx)
Projecting Working Capital: Understanding and Modelling Inventory, Receivables, and Payables
Projecting Capital Expenditure (CapEx) and Depreciation Schedules
Developing the Balance Sheet: Ensuring Accounting Equation Integrity and Interlinkages

Day 4: Modelling Capital Structure, Cost of Financing, and Free Cash Flow

Projecting the Capital Structure: Incorporating Debt and Equity Financing
Building the Loan Amortisation Schedule for Complex Debt Structures
Projecting the Cost of Financing: Detailed Calculation of Cost of Equity (CAPM, Multi-Factor Models) and Cost of Debt
Modelling the Free Cash Flow (FCF) Statement: Deriving FCF from Financial Statements

Day 5: Discounted Cash Flow Valuation and Other Valuation Methods

Building a Comprehensive Discounted Cash Flow (DCF) Model in Excel: Discount Rates, Terminal Value Calculation
Calculating and Interpreting Key Feasibility Indicators: Payback Period (PBP), Discounted Payback Period (DPBP), Net Present Value (NPV), Internal Rate of Return (IRR), Profitability Index (PI)
Understanding and Applying Non-Forecasting Valuation Methods: Methods of Comparable, Multiple Screening, Asset-Based Valuation
Overview of Other Forecasting Valuation Methods: Dividends Discounting, Residual Earnings Analysis, Earnings Growth Analysis

Schedule & Fees

3 For 2Offer

Get the most out of group training with our special discount! Register 3 of your participants together on the same course and only pay for 2.

Select Month

All
June
September
December

Location

All
London

New

London

$5,300

Duration: 5 Days

date: 23 - 27 Jun 2025

New

London

$5,300

Duration: 5 Days

date: 22 - 26 Sep 2025

New

London

$5,300

Duration: 5 Days

date: 29 Dec, 2025 - 02 Jan, 2026

Finance and Accounting

Certified Financial Modelling for Decision Making

Duration:5 Days

date:23 - 27 Jun 2025

London

$5,300

CPD Standards

Employees of professional or formally regulated bodies are generally expected to have CPD accredited training. This type of accreditation ensures that the training is knowledgeable, informed and constantly updated. It ensures our standards as a company are kept high and consistent.

100000+ Members in
59+ Countries with
3000+ Chapters

Our LTFE-Certified courses are designed for those ready to go the extra mile. Participants who complete the course and pass the final assessment on the last day will be awarded our LondonTFE Professional Certificate (LTFE), a testament to their commitment and expertise.

Why Choose London Training For Excellence?

Reliability

We will never cancel a confirmed booking
Support

We offer around the clock support
Tailored

We customise our courses to suit your personal learning needs
Quality

Our courses are delivered by highly experienced industry experts
Recognition

All our courses are accredited by the CPD Standards Agency

Frequently Asked Questions

How can training courses be used as a company benefit?

Training is hugely beneficial to both yourself and your company. It enables you to employ new technologies, increases your productivity and enables you to be more autonomous. Have a look here at our infographic on the importance of training and development!

How often do you update your course content to ensure relevancy?

Our course content is constantly reviewed and updated to ensure we stay up to date with all the latest trends. After every course is completed we review the feedback and improve the material where necessary.

Do you keep your classroom environment and instructional methodologies current with today’s real-world workplace?

Yes, we focus our training on ‘real-world’ scenarios and our trainers are all highly experienced and skilled in their relevant fields.

Are your courses eligible for professional certification?

Yes, we offer certification with all our courses, every course is entitled to CPD (Continuous Professional Development) hours which you can put towards your professional portfolio.

Get In Touch Today