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
SAFE conversion
What a post-money SAFE turns into at the round
In Cap table and exit waterfall model
Priced round and option pool
Pre-money to price per share, with the pool shuffle
In Cap table and exit waterfall model
Exit waterfall
Preference or conversion, then what reaches the common
In Cap table and exit waterfall model, ICG management buyout model
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
Cash receipts and the collections curve
Sales to cash, week by week
In 13-week cash flow model
Cash disbursements by calendar
What is paid, and on which Friday
In 13-week cash flow model
Borrowing base and availability
What the revolver will actually lend this week
In 13-week cash flow model
Liquidity forecast and covenant headroom
Cash, availability, headroom, shortfall
In 13-week cash flow model, GPU cloud infrastructure model, CoreWeave operating model
Claims by class
The claims register a recovery is built on
In Recovery waterfall model
Absolute priority distribution
Value paid out by seniority, collateral first
In Credit model, Recovery waterfall model
Fulcrum analysis and implied returns
Which class is the fulcrum, and what it returns
In Recovery waterfall model
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