189 schedules

The building blocks of every model

A model is a handful of schedules wired together. Learn the schedule and you can find it in every model that uses it; each page below explains one, lists the lines a good version carries, names the mistakes a reviewer looks for, and shows exactly where it sits in each downloadable model.

The statements

Revenue build

Where the top line comes from

In Integrated three-statement model, Discounted cash flow model, Leveraged buyout model, Telecom tower model: tenancies per tower, Mining model: copper-gold mine NAV, Restaurant franchise roll-out model, Telecom operator model: mobile and fibre, Semiconductor foundry model, ICG management buyout model, Duolingo operating model, Airbnb operating model, Spotify operating model, CoreWeave operating model

Operating costs and margins

Cost of sales, opex, EBITDA

In Integrated three-statement model, Regulated utility model: electricity network, Telecom tower model: tenancies per tower, Container shipping model: liner company, Consumer lending model: loan vintages, Restaurant franchise roll-out model, Payments processing and monetisation model, Telecom operator model: mobile and fibre, Semiconductor foundry model, Duolingo operating model, Airbnb operating model, Spotify operating model, CoreWeave operating model, Adyen operating model, AerCap operating model

Tax

Tax on profit, and tax on operating profit

In Discounted cash flow model, Leveraged buyout model, Merger model: accretion and dilution, Regulated utility model: electricity network, Mining model: copper-gold mine NAV, Airline operating and valuation model, Payments processing and monetisation model, Spotify operating model, Adyen operating model

Equity roll-forward

Share capital and retained earnings

In Integrated three-statement model, Regulated utility model: electricity network, AerCap operating model

Cash flow statement

Indirect method, closing on balance-sheet cash

In Integrated three-statement model, Discounted cash flow model, Leveraged buyout model, Airline operating and valuation model, Multi-store retail model, Restaurant franchise roll-out model, Duolingo operating model, Airbnb operating model, Spotify operating model, CoreWeave operating model, Adyen operating model, AerCap operating model

Balance sheet

Every line from a schedule, and the check

In Integrated three-statement model, Airline operating and valuation model, AerCap operating model

Operating schedules

Working capital schedule

Receivables, inventory and payables in days

In Integrated three-statement model, Discounted cash flow model, Leveraged buyout model, Container shipping model: liner company, Medtech installed-base and consumables model, Healthcare services model: hospital operator, Airline operating and valuation model, Professional services utilisation model, Multi-store retail model, Restaurant franchise roll-out model, Telecom operator model: mobile and fibre, Airbnb operating model

Capex and depreciation (PP&E roll-forward)

Opening, plus capex, less depreciation, closing

In Integrated three-statement model, Discounted cash flow model, Leveraged buyout model, Telecom tower model: tenancies per tower, Mining model: copper-gold mine NAV, Container shipping model: liner company, Medtech installed-base and consumables model, Healthcare services model: hospital operator, Airline operating and valuation model, Multi-store retail model, Restaurant franchise roll-out model, Payments processing and monetisation model, Telecom operator model: mobile and fibre, Semiconductor foundry model, GPU cloud infrastructure model, ICG management buyout model, CoreWeave operating model

Airline capacity and traffic: ASK, RPK and load factor

Fleet, block hours, seat kilometres, passengers

In Airline operating and valuation model

Airline unit revenue and unit cost: RASK and CASK

Yield, fares, RASK, CASK and CASK ex-fuel

In Airline operating and valuation model

Airline fuel cost and hedging

Burn per block hour, hedged share, price paid

In Airline operating and valuation model

Type curves and production decline

Arps decline, EUR, the base and wells drilled

In Upstream oil and gas model: E&P

Oil and gas reserves roll-forward

PD, PUD, 1P and 2P from one year to the next

In Upstream oil and gas model: E&P

Realised prices and the field netback

Benchmarks, differentials, royalties, costs per boe

In Upstream oil and gas model: E&P

Units-of-production DD&A

A cost pool over reserves, times production

In Upstream oil and gas model: E&P

Container fleet: owned, chartered, newbuilds and scrapping

Capacity in TEU, yard instalments, charters returned

In Container shipping model: liner company

Mine plan: from ore reserve to payable metal

Ore and waste, head grade, recovery, smelter payables

In Mining model: copper-gold mine NAV

C1 cash cost and all-in sustaining cost

Site costs, by-product credit, royalties, sustaining capital

In Mining model: copper-gold mine NAV

Mine closure and rehabilitation provision

A cost at the end of life, discounted, unwound, settled

In Mining model: copper-gold mine NAV

Liftings and freight rate: a liner’s revenue

Slot turns, load factor, TEU carried, rate per TEU

In Container shipping model: liner company

System sales and royalties: a franchisor’s units and volumes

Two unit roll-forwards, AUV, system sales, the royalty

In Restaurant franchise roll-out model

Restaurant unit economics: restaurant margin and new-unit returns

Food, labour, occupancy, restaurant margin, cash-on-cash

In Restaurant franchise roll-out model

Bunker fuel and the bunker adjustment factor

Vessel-days at sea, tonnes burned, BAF with a lag

In Container shipping model: liner company

Rate base roll-forward

Opening, capital plan, regulatory depreciation, closing

In Regulated utility model: electricity network

Allowed revenue: the building blocks

Return on rate base, depreciation, opex and tax allowances

In Regulated utility model: electricity network

Regulatory lag: earned against allowed return

Revenue in rates between rate cases, earned ROE, the gap

In Regulated utility model: electricity network

Headcount pyramid: hiring, attrition and promotion

Heads by grade, rolled forward year by year

In Professional services utilisation model

Mobile subscriber roll-forward: gross adds, churn, net adds

Postpaid and prepaid bases, gross adds, churn, net adds

In Telecom operator model: mobile and fibre

Fibre build: homes passed, penetration and connections

Homes passed, a penetration ramp, capex per home

In Telecom operator model: mobile and fibre

Spectrum licences: auction payments and amortisation

An auction paid in one year, amortised over the licence

In Telecom operator model: mobile and fibre

Tower site roll-forward: build-to-suit and decommissioning

Ground towers and rooftops, build-to-suit, overlap sites

In Telecom tower model: tenancies per tower

Tenancy roll-forward: anchor, colocation and the tenancy ratio

Anchor tenancies, colocation adds and churn, tenancy ratio

In Telecom tower model: tenancies per tower

Tower unit economics: yield on cost by tenant

One tower with one, two and three tenants, yield on cost

In Telecom tower model: tenancies per tower

Ground lease schedule: rent, escalators and buy-outs

Ground and rooftop rent, a buy-out programme at a multiple

In Telecom tower model: tenancies per tower

Utilisation and realisation: hours to fee revenue

Available hours, billed hours, rates and realisation

In Professional services utilisation model

Profit per partner: pay, bonus pools and partnership profit

Salaries, bonus pools, costs and what partners keep

In Professional services utilisation model

Store estate roll-forward and cohorts

Openings, closures, average trading stores, store age

In Multi-store retail model

Retail sales: density, like-for-like and online

Sales per sq ft by cohort, LFL growth, online returns, markdowns

In Multi-store retail model

Four-wall EBITDA and new-store payback

Store profit, online contribution, central costs, payback

In Multi-store retail model

Store leases under IFRS 16

Right-of-use assets, lease liabilities, EBITDA on both bases

In Multi-store retail model

Driver-based budget: volume, price, heads and cost per head

The plan by month, built from drivers

In FP&A budget and variance model

Rolling forecast: actuals, reforecast and the outturn

Actuals to date plus a reforecast of the rest

In FP&A budget and variance model

Price-volume-mix: revenue and margin variance

Price, volume and mix that add up to the variance

In FP&A budget and variance model

Cost variances: rate, volume, heads and cost per head

Direct cost and departmental spend against budget

In FP&A budget and variance model

EBITDA bridge: plan to actual and forecast

Plan EBITDA to actual, bar by bar

In FP&A budget and variance model

Capacity cohorts: MW, GPUs, utilisation and revenue

Cohorts of compute, GPU-hours, power and revenue

In GPU cloud infrastructure model, CoreWeave operating model

Backlog roll-forward: contracts to revenue to cash

Bookings, revenue recognised, backlog, prepayments

In GPU cloud infrastructure model, CoreWeave operating model

Capital roll-forward

Own capital month by month, runway and break-even

In Independent trading business model

Risk budget

Volatility target, VaR limit, position size, drawdown stop

In Independent trading business model

Trading cost base

Turnover costs, financing, fixed costs and the draw

In Independent trading business model

Sponsorship revenue

Opens sold, CPM and other revenue

In Creator and newsletter model

Financing schedules

Debt schedule

Tranches, interest, amortisation and the sweep

In Integrated three-statement model, Leveraged buyout model, Merger model: accretion and dilution, Credit model, Carve-out and standalone cost model, Regulated utility model: electricity network, Aircraft leasing model, Data centre colocation model, Telecom tower model: tenancies per tower, Mining model: copper-gold mine NAV, Container shipping model: liner company, Healthcare services model: hospital operator, Pharma royalty and licensing model, Airline operating and valuation model, Restaurant franchise roll-out model, Telecom operator model: mobile and fibre, ICG management buyout model, AerCap operating model

Fund cash flows: commitments, capital calls and NAV

Commitments, calls, paid-in capital, proceeds, NAV

In Private equity fund model: cash flows, J-curve and waterfall

Fund management fee: committed capital, then invested cost

The fee basis and rate before and after the step-down

In Private equity fund model: cash flows, J-curve and waterfall

Unfunded commitment: follow-on calls, fees and what is never called

Calls against the unfunded commitment and the share never drawn

In Private equity secondaries model: pricing an LP stake

Debt capacity

How much a borrower can borrow, and which test binds

In Credit model

Covenant compliance and headroom

Leverage, interest cover, fixed charge cover, EBITDA cushion

In Credit model, GPU cloud infrastructure model

Maturity profile and refinancing

What falls due when, and whether it can be refinanced

In Credit model, GPU cloud infrastructure model, CoreWeave operating model, AerCap operating model

CLO collateral roll-forward: defaults, recoveries and reinvestment

Performing par, defaults, a recovery lag, reinvestment

In CLO cash flow and waterfall model

CLO coverage tests: OC and IC ratios and the cure

OC and IC tests by class and the interest they divert

In CLO cash flow and waterfall model

CLO interest waterfall: costs, notes, cures and equity

Costs, five classes of interest, deferral, the residual

In CLO cash flow and waterfall model

CLO principal waterfall: sequential paydown and the call

Diverted interest, sequential principal, class balances

In CLO cash flow and waterfall model

Aircraft leases, lease liability and EBITDAR

Rent by vintage, lease liability, lease-adjusted debt

In Airline operating and valuation model, AerCap operating model

Lessor lease revenue and re-leasing

Lease rate factor, straight-line rent, downtime

In Aircraft leasing model, AerCap operating model

Maintenance reserves and security deposits

Restricted cash held for the lessee

In Aircraft leasing model, AerCap operating model

Book depreciation, residual value and sale

Book value against market value at exit

In Aircraft leasing model, AerCap operating model

Facility debt: contract-backed term loans and notes

Delayed-draw loans by cohort, DSCR, notes

In GPU cloud infrastructure model, CoreWeave operating model

Valuation and returns

Cost of capital (WACC)

CAPM, after-tax debt, target weights

In Discounted cash flow model, Airline operating and valuation model, Payments processing and monetisation model

Discounting and terminal value

Discount factors, two terminal methods, reconciled

In Discounted cash flow model, Regulated utility model: electricity network, Telecom tower model: tenancies per tower, Mining model: copper-gold mine NAV, Container shipping model: liner company, Airline operating and valuation model, Multi-store retail model, Restaurant franchise roll-out model, Payments processing and monetisation model, Telecom operator model: mobile and fibre, Semiconductor foundry model, Duolingo operating model, Airbnb operating model, Spotify operating model, Adyen operating model

Enterprise value to equity value

Debt off, cash on, per share

In Discounted cash flow model, Regulated utility model: electricity network, Telecom tower model: tenancies per tower, Container shipping model: liner company, Airline operating and valuation model, Payments processing and monetisation model, Telecom operator model: mobile and fibre, ICG management buyout model, Airbnb operating model, Spotify operating model, Adyen operating model

Returns analysis

Exit value, MOIC, IRR and the bridge

In Leveraged buyout model, Carve-out and standalone cost model, Telecom tower model: tenancies per tower, Healthcare services model: hospital operator, ICG management buyout model

Fund distribution waterfall: European and American carry

Capital, preferred return, catch-up, split, clawback

In Private equity fund model: cash flows, J-curve and waterfall

Fund performance: TVPI, DPI, RVPI, IRR and the J-curve

Net and gross multiples and IRR by year, gross to net

In Private equity fund model: cash flows, J-curve and waterfall

NAV roll-forward: calls, value growth and distributions

Opening NAV, calls, growth, distributions, closing NAV

In Private equity secondaries model: pricing an LP stake

Secondary buyer returns: IRR, capital at risk and the day-one uplift

Buyer IRR, multiple, peak risk, uplift, time to return cost

In Private equity secondaries model: pricing an LP stake

Sensitivity tables

Two assumptions at once, without a data table

In Discounted cash flow model, Leveraged buyout model, Merger model: accretion and dilution, Merger arbitrage model: deal spread, break risk and position size, Private equity fund model: cash flows, J-curve and waterfall, Private equity secondaries model: pricing an LP stake, CLO cash flow and waterfall model, Carve-out and standalone cost model, Regulated utility model: electricity network, Renewables project finance model, Aircraft leasing model, Data centre colocation model, Telecom tower model: tenancies per tower, Upstream oil and gas model: E&P, Mining model: copper-gold mine NAV, Container shipping model: liner company, Healthcare services model: hospital operator, Pharma royalty and licensing model, Airline operating and valuation model, Bank operating and valuation model, Consumer lending model: loan vintages, Insurance underwriting and valuation model, Asset manager AUM and fee economics model, Professional services utilisation model, FP&A budget and variance model, Multi-store retail model, Restaurant franchise roll-out model, Payments processing and monetisation model, Telecom operator model: mobile and fibre, Semiconductor foundry model, GPU cloud infrastructure model, ICG management buyout model, Duolingo operating model, Airbnb operating model, Spotify operating model, CoreWeave operating model, Adyen operating model, AerCap operating model, Independent trading business model, Creator and newsletter model

Calendarisation

Every peer on the same calendar year

In Comparable companies model

LTM build

Last fiscal year, plus the stub, less the prior stub

In Comparable companies model

Trading multiples

Enterprise value, the five multiples, and the range

In Comparable companies model

Precedent transactions

What acquirers paid for control

In Comparable companies model

Football field

Each range applied to the target, to a share price

In Comparable companies model

PV-10 and upstream NAV

Proved developed reserves valued, net debt, per share

In Upstream oil and gas model: E&P

Transaction schedules

Sources and uses

What the deal costs and who funds it

In Leveraged buyout model, Merger model: accretion and dilution, Purchase price allocation model, Carve-out and standalone cost model, Healthcare services model: hospital operator, Hotel underwriting model, GPU cloud infrastructure model, ICG management buyout model

Secondary pricing: the bid, the interim cash flows and the deferral

Bid on NAV, interim adjustment, deferral, maximum bid

In Private equity secondaries model: pricing an LP stake

Purchase price and consideration

Offer, premium, mix, new shares, exchange ratio

In Merger model: accretion and dilution

Synergies

Run-rate, phase-in, after tax

In Merger model: accretion and dilution

Standalone cost build: what a division costs to run alone

Functions rebuilt from heads, systems and third parties

In Carve-out and standalone cost model

TSA schedule: transition services, fees and double running

Terms in months, cost-plus fees, exits and overlap

In Carve-out and standalone cost model

Carve-out EBITDA bridge: reported to run-rate standalone

Reported EBITDA to run-rate, and the transition years

In Carve-out and standalone cost model

Stranded costs: what the seller cannot take out

Allocations the parent keeps, running off over time

In Carve-out and standalone cost model

Purchase accounting

The write-up that amortises

In Merger model: accretion and dilution, Purchase price allocation model

Pro forma EPS: accretion and dilution

Standalone to pro forma, per share

In Merger model: accretion and dilution

Contribution analysis

What each side brings against what it owns

In Merger model: accretion and dilution

Deal spread: gross, net of carry and annualised

Offer value, spread, carry and annualised return

In Merger arbitrage model: deal spread, break risk and position size

The merger arbitrage hedge: shorting the acquirer

The short that hedges the stock leg of a deal

In Merger arbitrage model: deal spread, break risk and position size

Break price analysis: what the target falls to

The break price, the loss per share and a higher bid

In Merger arbitrage model: deal spread, break risk and position size

Implied deal probability: what the spread says

The odds of completion in the price, against yours

In Merger arbitrage model: deal spread, break risk and position size

Arbitrage position sizing from the loss on a break

Position size, exposure and contribution to the fund

In Merger arbitrage model: deal spread, break risk and position size

Goodwill calculation

From the price to goodwill, through every write-up

In Purchase price allocation model

Deferred taxes in an acquisition

The DTL on write-ups, its unwind, and the step-up

In Purchase price allocation model

Closing balance sheet

Acquirer plus target plus adjustments, balanced

In Purchase price allocation model

Refranchising: selling company restaurants to franchisees

Proceeds, gain, margin given up, royalty kept, the premium

In Restaurant franchise roll-out model

Venture schedules

Project finance schedules

Construction funding

Draws, interest during construction, fees, equity

In Project finance model, Real estate development model, PPP availability payment model, Renewables project finance model, Data centre colocation model

CFADS

Cash flow available for debt service

In Project finance model, PPP availability payment model, Renewables project finance model, Aircraft leasing model, Data centre colocation model

Debt sculpting

Service shaped to CFADS at a target DSCR

In Project finance model, Renewables project finance model

Coverage ratios

DSCR, LLCR and PLCR

In Project finance model, PPP availability payment model, Renewables project finance model, Aircraft leasing model, Data centre colocation model, CoreWeave operating model

Reserve accounts

Debt service reserve and maintenance reserve

In Project finance model, PPP availability payment model, Renewables project finance model

Distribution waterfall

Debt service, reserves, lock-up, equity

In Project finance model, Renewables project finance model

Project and equity returns

Gearing, project IRR, equity IRR and multiple

In Project finance model, PPP availability payment model, Renewables project finance model, Aircraft leasing model, AerCap operating model

Unitary charge and deductions

The availability payment, its indexation and the deductions

In PPP availability payment model

Annuity repayment

Level debt service: interest falls, principal rises

In PPP availability payment model

Pricing a PPP bid

The unitary charge that gives the target equity IRR

In PPP availability payment model

Value for money

PPP payments against the public sector comparator

In PPP availability payment model

Energy yield and power revenue

P50 energy, degradation, PPA and merchant revenue

In Renewables project finance model

Data centre power: PUE and pass-through

IT load, PUE, power cost and how it is recovered

In Data centre colocation model

Real estate schedules

Rent roll

Every lease, year by year, with expiries priced in

In Property acquisition model

NOI build

Gross rent to net operating income

In Property acquisition model, Data centre colocation model

Loan sizing: LTV, DSCR and debt yield

The lender lends to the tightest of three constraints

In Property acquisition model, Real estate development model, Data centre colocation model, Hotel underwriting model

Mortgage debt schedule

Constant payment, interest, principal, balloon

In Property acquisition model, Hotel underwriting model

Property returns

Unlevered and levered IRR, multiple, cash-on-cash, exit cap sensitivity

In Property acquisition model, Hotel underwriting model

Equity waterfall: preferred return, catch-up, promote

How the levered cash is split between investors and sponsor

In Property acquisition model, Hotel underwriting model

Development budget and draw profile

Land, hard and soft costs, contingency, fee, S-curve

In Real estate development model, Data centre colocation model

Lease-up and stabilisation

Absorption, occupancy, NOI, TI and commissions

In Real estate development model

Development returns and spread

Yield on cost, development spread, profit on cost, IRR

In Real estate development model, Data centre colocation model

Same-store NOI and portfolio growth

Growth on buildings owned, plus what was bought and sold

In REIT model: FFO, AFFO and NAV

FFO and AFFO

From net income to the measures REITs are priced on

In REIT model: FFO, AFFO and NAV

REIT capital allocation

Funding deals, the dividend, leverage and the investment spread

In REIT model: FFO, AFFO and NAV

REIT net asset value

NAV per share, the premium or discount, the implied cap rate

In REIT model: FFO, AFFO and NAV

Occupancy, ADR and RevPAR build

Room nights, rate and revenue by department

In Hotel underwriting model

Hotel operating statement: departmental P&L to NOI

Departments, undistributed costs, GOP, fees, EBITDA

In Hotel underwriting model

FF&E reserve

Furniture, fixtures and equipment, set aside before NOI

In Hotel underwriting model

Data centre capacity and lease-up

MW by phase, pre-leasing, absorption, rent per kW

In Data centre colocation model

Restructuring schedules

Healthcare schedules

Clinical probability and stage gating

The chance of reaching the market, and what it weights

In Biotech rNPV and sum-of-the-parts model, Pharma royalty and licensing model

Launch curve

Patients times price, ramped to peak, eroded at exclusivity loss

In Biotech rNPV and sum-of-the-parts model

Programme rNPV

Revenue to risk-adjusted cash flow to a value

In Biotech rNPV and sum-of-the-parts model

Sum of the parts

Programmes, corporate costs, net cash, per share

In Biotech rNPV and sum-of-the-parts model

Binary events: the Phase 3 readout

Value on success, value on failure, the implied probability

In Biotech rNPV and sum-of-the-parts model

Installed base and utilisation

Systems shipped, retired and in use, and procedures

In Medtech installed-base and consumables model

Consumables pull-through and recurring revenue

Instruments per procedure, service, leases, margins

In Medtech installed-base and consumables model

Placement economics: sell or lease

Lifetime value of a system sold or leased, payback

In Medtech installed-base and consumables model

Hospital volumes and adjusted admissions

Beds, occupancy, length of stay, adjusted admissions

In Healthcare services model: hospital operator

Payer mix and hospital revenue

Revenue by payer, self-pay concessions, net revenue

In Healthcare services model: hospital operator

Hospital labour, supplies and EBITDA

FTEs per bed, wage inflation, contract labour, supplies

In Healthcare services model: hospital operator

Tiered royalty rates

Sales bands, marginal rates, step-down, royalty term

In Pharma royalty and licensing model

Royalty receipts and milestones

Sales curve, milestones, collection lag, operating costs

In Pharma royalty and licensing model

Royalty purchase returns

Price, receipts, IRR, multiple and the highest price

In Pharma royalty and licensing model

Technology schedules

Wafer capacity, utilisation and shipments

Fab capacity by node, the spending lag and the cycle

In Semiconductor foundry model

Fab cost structure: yield, fixed costs and margin

Variable and fixed cost of revenue, and operating leverage

In Semiconductor foundry model

Sales capacity

Reps, ramp, quota: the new ARR a team can close

In SaaS operating model

ARR roll-forward

Opening, new, expansion, churn, closing

In SaaS operating model

Bookings, billings and deferred revenue

Cash before revenue, and the balance in between

In SaaS operating model

SaaS profit and loss

Gross margin, sales and marketing, R&D, G&A, cash

In SaaS operating model, Duolingo operating model

Unit economics

CAC, payback, LTV, retention, magic number, burn multiple

In SaaS operating model, Duolingo operating model, Spotify operating model

Cohort GMV

Buyer cohorts, retention, frequency, orders, GMV

In Marketplace model: GMV, take rate and contribution

Take rate

From GMV to net revenue

In Marketplace model: GMV, take rate and contribution, Airbnb operating model

Contribution margin

What an order leaves after the costs it brings

In Marketplace model: GMV, take rate and contribution, Airbnb operating model

Buyer economics

One cohort: GMV retention, LTV to CAC, payback

In Marketplace model: GMV, take rate and contribution

Processed volume: TPV by channel and region

TPV, transactions and average transaction value

In Payments processing and monetisation model, Adyen operating model

Take rate and pass-through: gross receipts to net revenue

Interchange, scheme fees, acquiring costs, net take rate

In Payments processing and monetisation model, Adyen operating model

Settlement balances and the float

Due from schemes, due to merchants, the float

In Payments processing and monetisation model, Adyen operating model

Subscriber funnel

Sign-ups by channel, the free list and the paid list

In Creator and newsletter model

Subscription revenue and fees

Monthly and annual plans, platform and card fees

In Creator and newsletter model

Creator unit economics and breakeven

Contribution, cash, LTV, CAC payback, breakeven

In Creator and newsletter model

Financial institutions schedules

Bank balance sheet: loan book and funding

Loans by segment, deposits by type, wholesale funding

In Bank operating and valuation model

Net interest income and the margin

Yields, deposit betas, NII and NIM

In Bank operating and valuation model

Credit losses: expected-loss allowance and cost of risk

Stages, coverage, allowance roll-forward, cost of risk

In Bank operating and valuation model

Regulatory capital: RWA, CET1 and distributions

Risk densities, CET1 ratio, buffers, leverage, payouts

In Bank operating and valuation model

Residual income valuation and the justified P/TBV

Profit above the cost of equity, on tangible book

In Bank operating and valuation model, Consumer lending model: loan vintages, AerCap operating model

Insurance premium and claims reserves

Written to earned premium, UPR and the reserve roll

In Insurance underwriting and valuation model

Loss ratio, expense ratio and the combined ratio

Attritional and catastrophe losses, expenses, result

In Insurance underwriting and valuation model

Float and investment income

Policyholders’ money, invested in the meantime

In Insurance underwriting and valuation model

Insurance solvency ratio and dividend capacity

Required capital, own funds, the ratio and payouts

In Insurance underwriting and valuation model

Insurance valuation: P/B, embedded value and dividends

Justified P/B, value in force, dividend discount

In Insurance underwriting and valuation model

AUM roll-forward: flows, markets and distributions

Opening, net flows, market moves, distributions, closing

In Asset manager AUM and fee economics model

Asset manager fee economics and operating leverage

Fee rates, compression, performance fees, margin

In Asset manager AUM and fee economics model

Asset manager valuation: P/E, EV/EBITDA and DCF

Forward multiples against peers, and the fee stream

In Asset manager AUM and fee economics model

Loan vintages: run-off and the cumulative loss curve

Originations by year, charge-offs by years on book

In Consumer lending model: loan vintages

Allowance for expected credit losses on a lifetime basis

Loss still to come, reserve build, the provision

In Consumer lending model: loan vintages

Warehouse and securitisation funding at an advance rate

Notes, borrowing base, equity the lender funds itself

In Consumer lending model: loan vintages