HOME
 

Financial Statement Modelling (Live Online)

F1F9
Course summary
Corporate Training for Teams
4 days
1,295 GBP excl. VAT
Part time
Corporate Training for Teams
Course Dates
Online courses
1,295 GBP
6, 7 & 8 June (9am to 5pm Dubai time)

Online courses
1,295 GBP
5, 6 & 7 September (9am to 5pm Dubai time)

Online courses
1,295 GBP
24, 26 & 28 October (9am to 5pm London time)
Financial Statement Modelling

Course description

Financial Statement Modelling

This course teaches the core financial model design and construction techniques that every professional should know. It is designed for those working with financial models in the corporate, business modelling, banking, treasury, financial advisory, government and infrastructure sectors.

In-person participants will receive post-course access to the online version of the course. Online access and post-course support is ongoing.

Suitability - Who should attend?

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 best practice 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.

Outcome / Qualification etc.

We will work closely with you, sharing insights and putting into practice core financial modelling techniques as you model a case study based on a business acquisition.

You will learn to create the step-by-step calculations required to forecast the three primary financial statements — income, balance sheet, and cash flow. More advanced topics will include a valuation of the equity in the case study company (based upon the present value of forecast dividends).

Participants can expect detailed instruction and hands-on practice with a focus on developing and working with a financial model that they have built from scratch.

Post-course, you will receive full and ongoing access to the online version of the course as well as online support from our team of modelling experts.

Training Course Content

Building the primary financial statements:

  • the accounting equation
  • tracking retained cash and retained earnings

Revenue:

  • price
  • demand / volume drivers
  • flags / placeholder flags

Operating costs:

  • fixed costs
  • variable costs

Escalation / indexation / inflation:

  • day counts
  • date functions
  • data picks: VLOOKUP vs INDEX / MATCH vs LOOKUP / SUMIFS
  • ISNA

Deferred tax:

  • tax expense vs tax paid
  • tax losses carried forward

Non-current assets:

  • balances: initial, BEG and END
  • corkscrews
  • accounting depreciation
  • look back functions: OFFSET vs HLOOKUP vs SUMIFS
  • capital expenditure

Tax effects of non-current assets:

  • tax depreciation

Working capital:

  • accounts receivable
  • accounts payable
  • inventory

Equity finance:

  • share capital
  • dividends

Debt finance:

  • simple scenario selection: nested IF vs CHOOSE vs OFFSET vs INDEX
  • debt principal repayment
  • debt interest

Key outputs / analysis:

  • sensitivities and scenario managers
  • equity valuation: NPV vs XPNV
  • equity returns: IRR vs XIRR
  • performance ratios / lender ratios

Quality control:

  • track sheets
  • checks and alerts

Model finalisation:

  • placeholder management
  • flag management
  • relocating inputs

Course delivery details

In-person courses take place over 2 full classroom days as standard (but in-company courses can be extended or condensed if required). 

Live online courses are run via Zoom, and usually take place on non-consecutive days. The live tuition takes place over 3 x 1-hour sessions per day, with assignments set after each session. 

Why choose F1F9

Sharing financial modelling expertise since 1999

Outstanding feedback: our courses have an average rating of 4.6 stars out of 5

Unparalleled post-course support: our instructors remain available for any questions long after your course is over

Expenses

Course fee is £1,295

Get Inspired! Watch the Video

About provider

F1F9

F1F9 training courses are designed to transform your financial modelling skills. We are financial modelling experts, and our instructors have taught thousands of people to build best practice financial models that can be easily adapted, shared and understood. Our post-course...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Financial Statement Modelling (Live Online).

  Contact the provider

  Get more information

  Register your interest

Country *

Contact info

F1F9

The Guild, High Street
BA1 5EB Bath

 Show phone number
www.f1f9.com


Reviews

Average rating 4.7

Based on 41 reviews.

Robert Nuta
the course is well designed and each session only ads one new topic so that you do not get overloaded with information
Mariam Zaldastanishvili
The couse was planned perfectly, and super interesting thanks to the intstructor!
Matias Vitie
Good combination of distant study and doing work on your own.
Request information

Find out more about this Financial Statement Modelling (Live Online) course - simply fill out your details:

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here