Financial Statement Modelling (live-online)

Best practice financial modelling 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. For those with limited experience, the course is an excellent introduction to best practice financial modeling. Experienced modellers find the quality and productivity of their modeling improves through the introduction of a standardized approach to model design and construction.

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

To get more information, please contact info@f1f9.com

Course topics:

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 finalization:

• placeholder management
• flag management
• relocating inputs