Certificate Course in Advanced Financial Modelling

Participants can convert historical financial information into a controlled three-statement model structure.

• Three-statement model layout linking income statement, balance sheet, and cash flow
• Historical financials normalized into consistent model-ready reporting lines
• Chart of accounts mapping between source data and model drivers
• Sign conventions, units, dates, and fiscal calendars controlled centrally
• Balance sheet balancing tests and cash flow reconciliation controls
• Source-data assumptions documented with owner, date, and evidence references

Participants can build forecast assumptions from operational drivers rather than unsupported growth rates.

• Driver trees connecting volume, price, mix, capacity, and cost
• Revenue build using units-times-price logic and commercial assumptions
• Operating expense forecasts separated into fixed, variable, and step costs
• Headcount schedules incorporating hires, attrition, salary inflation, and bonuses
• Assumption registers with base, upside, downside, and trigger definitions
• Timeline controls aligning monthly forecasts with contractual commencement dates

Participants can forecast profit and loss statements using linked operating schedules and accounting logic.

• Revenue recognition timing aligned with IFRS 15 performance obligations
• Cost of sales forecast using margin bridges and unit economics
• EBITDA, EBIT, and net income calculated through linked schedules
• Non-recurring items isolated from underlying operating performance measures
• Tax expense estimated from taxable profit, losses, and jurisdiction rates
• Income statement checks comparing margins, growth rates, and prior periods

Participants can forecast balance sheet accounts and working capital movements using operational assumptions.

• Working capital schedules for receivables, inventory, payables, and accrued expenses
• Days sales outstanding and inventory turns translated into balance forecasts
• Fixed asset register linked to capital expenditure and depreciation
• Lease liabilities and right-of-use assets modelled under IFRS 16
• Deferred tax movements derived from temporary differences and tax losses
• Balance sheet roll-forwards reconciled to opening balances and movements

Participants can prepare indirect cash flow statements and short-term liquidity forecasts.

• Indirect cash flow statement built from profit and non-cash adjustments
• Cash conversion cycle analysed through receivable, inventory, and payable days
• 13-week rolling cash forecast built from receipts, payroll, and supplier payments
• Minimum cash requirements and liquidity headroom monitored by period
• Restricted cash, overdrafts, and bank facilities classified correctly
• Cash flow reconciliation identifies timing differences and modelling errors

Participants can model capital investment, depreciation, disposals and related accounting effects.

• Capital expenditure pipeline scheduled by project, timing, and payment profile
• Depreciation calculated using straight-line, declining-balance, and useful-life assumptions
• Asset disposals modelled with proceeds, carrying value, and gain or loss
• Maintenance and growth capital expenditure separated within investment plans
• Construction-in-progress transfers triggered at operational commissioning dates
• Capitalized interest and borrowing costs treated under IAS 23

Participants can model debt facilities, interest costs, repayment profiles and covenant capacity.

• Debt schedule modelling drawdowns, amortization, refinancing, and maturity dates
• Interest expense calculated from opening balances, rates, and cash sweeps
• Revolver availability linked to borrowing bases and minimum liquidity
• Debt covenant calculations for net debt, interest cover, and headroom
• Mandatory prepayments and excess-cash sweeps incorporated into financing logic
• Circularity resolved through switches, algebraic methods, and iterative calculations

Participants can incorporate equity movements, dividends, options and ownership effects into forecasts.

• Share capital, share premium, and retained earnings roll-forward schedules
• Dividend policy linked to distributable reserves, payout ratios, and cash
• Employee options modelled using dilution, vesting, and exercise assumptions
• Weighted average shares calculated for earnings per share forecasts
• Minority interests and associate investments reflected in consolidated outputs
• Equity financing scenarios compared for ownership dilution and proceeds

Participants can complete an integrated model that reconciles automatically and flags control failures.

• Integrated three-statement model completed with automatic balance sheet balancing
• Control panel centralizes scenario selection, timing switches, and key assumptions
• Financial statements reconcile through linked schedules without hard-coded outputs
• Audit checks flag balance errors, broken links, and unexpected signs
• Model outputs formatted for monthly management reporting and lender review
• Version-control protocol records changes, approvals, and distribution status

Participants can value a business using discounted cash flow analysis and explain key value drivers.

• Enterprise value and equity value distinguished through debt and cash adjustments
• Free cash flow derived from NOPAT, investment, and working capital
• WACC assembled from risk-free rate, beta, market premium, and borrowing cost
• Terminal value estimated using perpetuity growth and exit multiple methods
• Discounted cash flow valuation reconciled to enterprise and equity value
• Valuation bridge explains operating drivers, discount rates, and terminal assumptions

Participants can apply market-based valuation methods and interpret differences between comparable evidence.

• Trading comparables selected using business model, geography, growth, and margin criteria
• Comparable-company data normalized for accounting policies and non-recurring items
• EV/EBITDA, EV/EBIT, and price-to-earnings multiples calculated across selected peer companies
• Peer-group quartiles, medians, and ranges interpreted with judgement
• Precedent transaction multiples adjusted for control premiums and market conditions
• Football-field valuation chart presents methods, ranges, and implied share values

Participants can construct driver-based budgets and explain forecast variances to management.

• Annual budget model phased monthly from operational drivers and calendar effects
• Rolling forecast replaces static budget assumptions with updated actuals
• Budget versus actual variance bridges separate volume, price, and mix
• Departmental cost centre templates consolidate into corporate financial plans
• Forecast governance assigns assumption owners, review dates, and approval thresholds
• Management reporting packs highlight exceptions, decisions, and corrective actions

Participants can quantify uncertainty and identify assumptions that most affect financial outcomes.

• Base, downside, and upside cases controlled through switchable assumption sets
• One-way and two-way data tables test critical value drivers
• Scenario manager documents correlated changes across commercial and financing inputs
• Break-even analysis calculates volume, price, and margin thresholds
• Goal Seek identifies required sales or funding outcomes
• Risk register links model sensitivities to mitigation owners and actions

Participants can assess transaction funding, purchase accounting and financial returns from acquisitions.

• Acquisition model separates purchase price, financing sources, and transaction costs
• Purchase price allocation identifies goodwill, intangibles, and fair-value adjustments
• Merger model combines buyer, target, expected savings, and integration costs
• Accretion and dilution calculated from financing, savings, and purchase accounting
• Pro forma financial statements incorporate acquisition timing and new debt
• Returns assessed using IRR, MOIC, and cash-on-cash measures

Participants can model project funding, debt service and sponsor returns for long-term assets.

• Project finance model separates construction, operations, funding, and distributions
• Sources and uses schedule reconciles capital costs with financing commitments
• Debt service coverage ratio calculated from cash available for debt service
• Reserve accounts modelled for maintenance, debt service, and contingencies
• Waterfall distributions allocate cash between lenders, sponsors, and reserves
• Project IRR and equity IRR tested against completion and tariff assumptions

Participants can adapt modelling methods to lending, infrastructure, consumer, public and donor-funded decisions.

• Bank lending case assesses covenant headroom and refinancing capacity
• Infrastructure concession case forecasts construction, demand, tariffs, and availability payments
• Consumer-products case models channel mix, promotions, and inventory investment
• Public-sector business case quantifies costs, benefits, and funding gaps
• NGO programme forecast links donor restrictions, grants, and delivery milestones
• Case assumptions challenged using source evidence and stakeholder questions

Participants can review financial models systematically and document issues requiring correction or escalation.

• Formula audit traces precedents, dependents, external links, and hidden sheets
• Model review checklist tests structure, logic, inputs, outputs, and documentation
• Error taxonomy distinguishes mechanical, logic, assumption, and presentation faults
• Independent review applies reasonableness tests, recalculation, and challenge questions
• Stress testing exposes liquidity shortfalls, covenant breaches, and funding requirements
• Model documentation records purpose, scope, limitations, and change history

Participants can present financial model outputs clearly for executive, lender and investment decisions.

• Executive dashboard selects valuation, liquidity, profitability, and return indicators
• Waterfall charts explain EBITDA, cash flow, and valuation movements
• Management narrative separates facts, assumptions, risks, and recommendations
• Decision papers present options, financial implications, and required approvals
• Model outputs adapted for investment committees, lenders, and senior executives
• Presentation quality checked for traceability, readability, and decision relevance

Participants can build, review and present a complete integrated financial model with a supported investment recommendation.

• Build an integrated model from supplied operating, financing, and historical data
• Construct linked revenue, cost, working capital, capital expenditure, and debt schedules
• Produce three-statement forecasts, cash headroom, valuation, and scenario outputs
• Apply audit checks, sensitivity tests, and documented assumption governance
• Review another participant's model using the formal review checklist
• Present investment recommendation, risks, and decision conditions to an approval panel