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...
Request info
Contact info
F1F9
Reviews
Average rating 4.7
Based on 41 reviews.
Find out more about this Financial Statement Modelling (Live Online) course - simply fill out your details:
 |
Read the course |
|
 |
Fill in your details and Request information |
|
 |
Receive all the info you need |