Financial Statement Modelling online

Financial Statement Modelling is designed for professionals who need to build, modify or run financial models. For those with limited experience, the course is an excellent introduction to real world financial modelling. Experienced modellers find the quality and productivity of their modelling improves through the introduction of a standardised approach to model design and construction.

What will you learn?

The Financial Statement Modelling course will teach you solid modelling techniques which will enable you to model financial statement based forecast models – including valuation methodologies, scenario managers and sensitivity analysis.

By the end of the course, you will be able to:

  • Read and understand financial models
  • Create a model containing the Income Statement, Balance Sheet and Cash Flow from scratch based on an existing assets basis
  • Build models that are easy to review and understand, and for colleagues to adapt while you are on holiday

Why should you sign up?

This course combines clear video tutorials with self-assessed modelling assignments and online support. You can view and revisit the tutorials as many times as you like and take advice from our modelling team as you implement the techniques in your own modelling.

This course is CPD certified for 25 hours.

Sign up online for instant access, contact us to request an invoice, and see below for the full list of modules.

Image

Book your course

Change currency

All of our courses are now available as Tutor-led Distance Learning; contact us to learn more about this option.

If you’d like to receive special offers and discounts via email let us know.

Date
Format
Location
Duration
Instructor
Price
Any
Video Based
Online
25 hours approx
Andrew Berkley
£395

Full list of modules

Primary Financial Statements
  • Placeholders
  • Calculation blocks
  • Corkscrews
  • Row anchored links
  • Copy or link?
  • Quick charts
  • Import / export
  • Equity
Revenue Price
  • Constants
  • Pyramid structure
  • Formatting numbers
  • Flags
  • Embedded constants
  • Precedents and dependents
  • Editing a formula
  • Revenue price
Revenue Demand
  • 2D calculation blocks
  • F1F9 macros
  • Find & replace
  • Revenue demand
Revenue Summary
  • Revenue summary case study
Operating Costs
  • Writing a good label
  • Sign conventions
  • Sign switch
  • Operating Costs
Escalation
  • Day counts
  • Date functions
  • Data picks
  • ISNA
  • Escalation
Deferred Tax
  • Counterflows
  • MIN and MAX
  • Goal seek
  • Deferred Tax
Business Operations
  • How to review a FAST model
  • Business Operations analysis
  • Model build challenge: Hotel Raja part 1
Non Current Assets
  • Initial balances
  • Accounting depreciation
  • Look back functions
  • Capital expenditure
Tax Effects of Non Current Assets
  • Tax depreciation
Working Capital
  • Accounts receivable
  • Accounts payable
Business Assets
  • Business Assets
  • Model build challenge: Hotel Raja part 2
Equity Finance
  • Share capital
  • Dividends
Debt Finance
  • Scenario selection (nested IF and CHOOSE)
  • Scenario selection (OFFSET)
  • Scenario selection (INDEX)
  • Senior debt principal repayment
  • Senior debt interest I
  • Senior debt interest II
Business Finance
  • Business Finance
  • Model build challenge: Hotel Raja part 3
Key Outputs / Analysis
  • Sensitivities & scenarios
  • NPV and XNPV
  • IRR and XIRR
  • Valuation
  • Ratios
Quality Control
  • Track sheet I
  • Track sheet II
  • Checks & alerts
Model Finalisation
  • Placeholders
  • Flags
  • Relocating inputs
  • Model build challenge: Hotel Raja part 4
  • Model build challenge: Hotel Raja part 5
  • Model build challenge: Hotel Raja part 6
Find out more: