Best Practice Financial Modelling (in-person)

Best practice financial modeling taught using the FAST Standard

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.

Course Agenda:

Revenue
- price
- demand / volume drivers
- flags / placeholder flags

Operating costs
- fixed costs
- variable costs

Inflation
- real growth vs inflation / indexation / escalation
- data pick-up functions: VLOOKUP, INDEX / MATCH, LOOKUP / SUMIF

Building the primary financial statements
- tracking retained cash and retained earnings

Non-current assets
- balances: initial, BEG and END
- corkscrews
- accounting depreciation

Working capital
- accounts receivable
- accounts payable

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

Quality control
- track sheets
- checks and alerts