Financial models

Professional Excel models you can inspect before you download. Browse the full library by area, open any workbook in the browser, see how it works, then take the Excel version.

57 models567 sheets189 schedules8 areas of practice Every workbook opens in the browser, free

Just added 6 new models this month

The newest workbooks in the library, each open in the browser like the rest.

Preview the Telecom tower model: tenancies per tower workbook
NewInfrastructure and project financeAdvanced15 sheets~50 minPEIBER/HF

Telecom tower model: tenancies per tower

Build a tower portfolio from its sites and its tenants: ground towers and rooftops rolled forward with committed build-to-suit additions and decommissioning, an anchor tenancy on every site and colocation tenancies added and lost each year, an anchor fee under an inflation escalator with a floor and a cap, colocation rent, amendments and energy passed through at no margin, ground rent and a lease buy-out programme, EBITDAaL, AFFO and debt at a multiple, then the unit economics of one tower with one, two and three tenants, a DCF and a buyer’s equity IRR.

Preview the Carve-out and standalone cost model workbook
NewM&A and private equityAdvanced11 sheets~50 minIBPE

Carve-out and standalone cost model

Rebuild a division’s cost base from the bottom, bridge reported EBITDA to run-rate standalone EBITDA, schedule the transition services and the months of double running, split the separation costs between the parties, and then read the sale from both sides: the sponsor’s funding, debt and IRR, and the seller’s tax leakage, stranded costs and real multiple. At the asking price of 8.5x run-rate standalone EBITDA the base case returns 12.9% against a 15% target, so the model’s answer is that the price is too high; the grid shows the price that would clear it, 7.5x.

Preview the CLO cash flow and waterfall model workbook
NewCredit and restructuringAdvanced11 sheets~50 minER/HFPEIB

CLO cash flow and waterfall model

Build a CLO quarter by quarter: a loan portfolio that defaults, prepays and recovers with a lag, reinvested for three years; the interest waterfall with overcollateralisation and interest coverage tests, the closed-form cure that diverts interest to the senior notes and the deferral of unpaid mezzanine interest; the sequential principal waterfall; and the equity IRR and each tranche’s loss under a base, a stress and a severe case, with grids of the equity return and the interest diverted by default rate and recovery.

Preview the Private equity secondaries model: pricing an LP stake workbook
NewM&A and private equityAdvanced13 sheets~45 minPEIBER/HF

Private equity secondaries model: pricing an LP stake

Underwrite one LP stake in a mature buyout fund: price it as a percentage of reference NAV and settle the cash that moved before closing, project the calls on the unfunded commitment and the distributions from six named sales net of the fund’s carry, roll NAV forward and prove it, read the buyer’s IRR, multiple and peak capital at risk, solve the maximum bid for a target IRR in closed form and prove it, and see the price as the seller does.

Preview the Merger arbitrage model: deal spread, break risk and position size workbook
NewM&A and private equityAdvanced11 sheets~45 minER/HFIB

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

Price the target’s shares in an announced cash-and-stock deal: the offer value and the spread net of dividends, borrow and financing, the short that hedges the stock leg, the price the target falls to if the deal breaks, the probability of completion the price implies against your own, how the return erodes if completion slips toward the long-stop date, and the largest position a loss budget allows.

Preview the Telecom operator model: mobile and fibre workbook
NewTechnologyAdvanced13 sheets~45 minER/HFIBPE

Telecom operator model: mobile and fibre

Build an integrated telecom operator from its customers and its networks: postpaid and prepaid subscribers rolled forward by gross additions and churn, ARPU by segment, handset revenue kept apart from service revenue, a fibre network from homes passed to connections as penetration ramps, costs to EBITDA and then to EBITDAaL after leases, capital spending split between maintenance and the fibre build, a spectrum auction amortised over its licence, then leverage, equity free cash flow, dividend cover and a DCF checked against a peer multiple.

Core modelling 10 models

The models most analyst interviews test, whole companies built from their operating drivers, a retailer from its stores among them, and two businesses one person runs: a trading business and a newsletter.

Preview the Comparable companies model workbook
Core9 sheets~35 minIBER/HFPE

Comparable companies model

Bring a peer set to one calendar year and one trailing period, compute and defend the multiples, and carry each range through a football field to an implied value per share.

Preview the Airline operating and valuation model workbook
Advanced10 sheets~45 minER/HFIBPE

Airline operating and valuation model

Build an airline from its fleet: capacity in seat kilometres, traffic and revenue from load factor and yield, costs from the activity that causes them, leases on the balance sheet, three statements that balance, and a value per share checked against EV / EBITDAR.

Preview the Professional services utilisation model workbook
Core9 sheets~35 minPEIBER/HF

Professional services utilisation model

Build a professional services firm from its people: a pyramid by grade with hiring, attrition and promotion, billed hours from utilisation, fees from bill rates and realisation, pay and bonus pools, profit per partner, and the cash held in work in progress and receivables.

Preview the FP&A budget and variance model workbook
Core12 sheets~40 minPEIBER/HF

FP&A budget and variance model

Build a year’s plan from volume, price, unit cost, heads and cost per head, load the actuals for the months closed, roll the forecast forward, and explain every dollar of the gap to plan in price, volume, mix, unit cost, heads, cost per head and non-pay, ending in an EBITDA bridge that ties to the forecast.

Preview the Multi-store retail model workbook
Core11 sheets~40 minER/HFIBPE

Multi-store retail model

Build a retailer from its stores: roll the estate forward, trade each cohort of new stores up to the mature sales density, add online sales net of returns, take markdowns off the gross margin, work store four-wall EBITDA and central costs to EBITDA on both IFRS 16 bases, and carry it through stock days, capital spending, the payback on a new store, free cash flow and a valuation.

Preview the Restaurant franchise roll-out model workbook
Core12 sheets~45 minER/HFIBPE

Restaurant franchise roll-out model

Build a restaurant franchisor from its units: roll the company-operated and franchised estates forward with openings, closures and refranchising, grow average unit volume with traffic and price, separate system sales from reported revenue, take company restaurants through food and paper, labour and occupancy to the restaurant margin, add royalties, fees and overhead to EBITDA, test a new restaurant on its cash-on-cash return, and carry it through securitised notes, buybacks and a valuation that shows what the same restaurants are worth operated and franchised.

Preview the Independent trading business model workbook
Core10 sheets~40 minER/HF

Independent trading business model

Size positions from a volatility target and a VaR limit, derive the expected return from a Sharpe ratio rather than typing it, roll own capital forward through costs, a profit share, a draw and tax, and find the Sharpe ratio at which the business stands still.

Preview the Creator and newsletter model workbook
Foundation10 sheets~35 minPM/TechVC

Creator and newsletter model

Build a newsletter from its subscriber funnel to monthly cash, compare a per-subscriber platform fee with a revenue share, and read the lifetime value, acquisition cost and payback of a paid subscriber from the same lines.

M&A and private equity 9 models

The M&A and private equity hub

Buying a company, paying for it and dividing what it returns.

Preview the Merger arbitrage model: deal spread, break risk and position size workbook
NewAdvanced11 sheets~45 minER/HFIB

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

Price the target’s shares in an announced cash-and-stock deal: the offer value and the spread net of dividends, borrow and financing, the short that hedges the stock leg, the price the target falls to if the deal breaks, the probability of completion the price implies against your own, how the return erodes if completion slips toward the long-stop date, and the largest position a loss budget allows.

Preview the ICG management buyout model workbook
Advanced11 sheets~60 minPEIBER/HF

ICG management buyout model

Read a real management buyout from its announcement: separate equity value from enterprise value, cash from rollover, facilities from debt drawn and preferred from ordinary, and say what each class earns under the base, downside and upside cases.

Preview the Private equity fund model: cash flows, J-curve and waterfall workbook
Advanced12 sheets~45 minPEVCIB

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

Build a buyout fund over its life: commitments called for ten investments, a management fee that steps down from committed capital to invested cost, and fund expenses; NAV marked on a stated path; a whole-fund waterfall with a compounding preferred return, a GP catch-up and an 80/20 split; then the LPs’ net cash flows, the J-curve in TVPI, DPI, RVPI and IRR by year, the bridge from gross to net, and the clawback a deal-by-deal waterfall would leave.

Preview the Private equity secondaries model: pricing an LP stake workbook
NewAdvanced13 sheets~45 minPEIBER/HF

Private equity secondaries model: pricing an LP stake

Underwrite one LP stake in a mature buyout fund: price it as a percentage of reference NAV and settle the cash that moved before closing, project the calls on the unfunded commitment and the distributions from six named sales net of the fund’s carry, roll NAV forward and prove it, read the buyer’s IRR, multiple and peak capital at risk, solve the maximum bid for a target IRR in closed form and prove it, and see the price as the seller does.

Preview the Purchase price allocation model workbook
Advanced7 sheets~40 minIBPEER/HF

Purchase price allocation model

Allocate a purchase price across book assets, fair value write-ups and new intangibles, compute the deferred tax liability and goodwill in a stock deal and an asset deal, build the closing balance sheet, and say what the write-ups cost earnings and what a step-up is worth in cash.

Preview the Carve-out and standalone cost model workbook
NewAdvanced11 sheets~50 minIBPE

Carve-out and standalone cost model

Rebuild a division’s cost base from the bottom, bridge reported EBITDA to run-rate standalone EBITDA, schedule the transition services and the months of double running, split the separation costs between the parties, and then read the sale from both sides: the sponsor’s funding, debt and IRR, and the seller’s tax leakage, stranded costs and real multiple. At the asking price of 8.5x run-rate standalone EBITDA the base case returns 12.9% against a 15% target, so the model’s answer is that the price is too high; the grid shows the price that would clear it, 7.5x.

Credit and restructuring 4 models

The credit and restructuring hub

Lending against a business, and who is repaid when it fails.

Preview the Recovery waterfall model workbook
Advanced7 sheets~40 minIBER/HFPE

Recovery waterfall model

Distribute a restructured company’s value by an assumed priority ranking across a range of enterprise values, identify the fulcrum security in each, and calculate the return on each traded class at an assumed purchase price.

Preview the CLO cash flow and waterfall model workbook
NewAdvanced11 sheets~50 minER/HFPEIB

CLO cash flow and waterfall model

Build a CLO quarter by quarter: a loan portfolio that defaults, prepays and recovers with a lag, reinvested for three years; the interest waterfall with overcollateralisation and interest coverage tests, the closed-form cure that diverts interest to the senior notes and the deferral of unpaid mezzanine interest; the sequential principal waterfall; and the equity IRR and each tranche’s loss under a base, a stress and a severe case, with grids of the equity return and the interest diverted by default rate and recovery.

Real estate 4 models

The real estate hub

Buying, building and owning property, from the rent roll up.

Preview the Hotel underwriting model workbook
Advanced9 sheets~50 minPEIB

Hotel underwriting model

Build a hotel’s revenue from occupancy and ADR, carry it through a departmental operating statement to GOP, EBITDA and NOI after the FF&E reserve, size a senior loan to loan to cost, DSCR and debt yield with a mezzanine layer on top, and read the levered return and its sensitivity to occupancy and the exit cap rate.

Infrastructure and project finance 13 models

The infrastructure and project finance hub

Long-lived assets funded against their own cash flows.

Preview the Renewables project finance model workbook
Advanced10 sheets~60 minIBPE

Renewables project finance model

Build energy from a P50 capacity factor, availability and degradation, split it between a PPA and merchant sales, size the senior debt as the lesser of a gearing cap and a sculpted DSCR on the lenders’ case, and show what a weak year, lower merchant prices or a construction overrun do to coverage and to the equity return.

Preview the PPP availability payment model workbook
Advanced9 sheets~50 minIBPE

PPP availability payment model

Build an availability-based unitary charge with indexation and deductions, repay the debt as an annuity, smooth lifecycle costs through a reserve, solve the charge that delivers the target equity IRR, test lender coverage against the covenant, and compare the authority’s payments with a public sector comparator.

Preview the Regulated utility model: electricity network workbook
Advanced10 sheets~45 minER/HFIBPE

Regulated utility model: electricity network

Build a regulated network from its rate base up: the roll-forward with the capital plan and regulatory depreciation, the revenue requirement as its building blocks, revenue in rates between rate cases and the lag that opens against the requirement, actual costs against their allowances, debt and equity issued to hold the equity layer, FFO / debt against a rating threshold, EPS and a dividend grown at a set rate, then value from discounted dividends and as a premium to the rate base.

Preview the Aircraft leasing model workbook
Advanced14 sheets~50 minIBPE

Aircraft leasing model

Build a lessor’s portfolio from the aircraft up: rent from a lease rate factor, straight-line revenue against cash, downtime and the cost of moving an aircraft to its next airline, maintenance reserves held apart from revenue, a secured loan refinanced at maturity and tested for DSCR and LTV, and the sale against book value, then read what each of them does to the equity return.

Preview the Data centre colocation model workbook
Advanced13 sheets~50 minPEIB

Data centre colocation model

Build a colocation campus from its megawatts up: capacity by phase and its cost per MW, pre-leasing and absorption to stabilised occupancy, rent per kW with an escalator, power from utilisation and PUE billed at cost plus a margin or sold all-in, NOI, a construction loan converted to a term loan sized on LTV and DSCR, and a sale on forward NOI, then read the yield on cost against the exit cap rate.

Preview the Telecom tower model: tenancies per tower workbook
NewAdvanced15 sheets~50 minPEIBER/HF

Telecom tower model: tenancies per tower

Build a tower portfolio from its sites and its tenants: ground towers and rooftops rolled forward with committed build-to-suit additions and decommissioning, an anchor tenancy on every site and colocation tenancies added and lost each year, an anchor fee under an inflation escalator with a floor and a cap, colocation rent, amendments and energy passed through at no margin, ground rent and a lease buy-out programme, EBITDAaL, AFFO and debt at a multiple, then the unit economics of one tower with one, two and three tenants, a DCF and a buyer’s equity IRR.

Preview the Container shipping model: liner company workbook
Advanced13 sheets~45 minER/HFIBPE

Container shipping model: liner company

Build a container liner from its fleet up: owned and chartered-in capacity in TEU, newbuilds paid for in yard instalments and scrapping, liftings from slot turns and the load factor, a freight rate on a cycle, bunker fuel from vessel-days at sea with a bunker adjustment factor recovered a year late, charter hire, handling and port costs, vessels depreciated to scrap value and dry-docked every five years, then net debt, leverage and a value on through-the-cycle EBITDA.

Preview the GPU cloud infrastructure model workbook
Advanced10 sheets~50 minPEIBER/HF

GPU cloud infrastructure model

Build a GPU cloud from cohorts of capacity: GPUs and capital cost per MW, contracted and on-demand GPU-hours and revenue, a backlog roll-forward, power from PUE and the price per MWh, GPU and fit-out depreciation, a term loan per cohort sized on its contract, corporate notes and a revolver, liquidity, covenants and the equity return.

Preview the CoreWeave operating model workbook
Advanced11 sheets~60 minPEIBER/HF

CoreWeave operating model

Read a backlog the way a lender does, model revenue from megawatts, depreciate a fleet by asset class over its disclosed lives, list the debt facility by facility, roll it forward with a refinancing line, and set the contracted cash against the debt service year by year without mistaking any of it for a credit view.

Preview the AerCap operating model workbook
Advanced10 sheets~50 minIBER/HFPE

AerCap operating model

Read a lessor’s income statement as a spread on its fleet, roll the fleet’s book value forward, rebuild the company’s adjusted leverage, cost of debt and book value per share from the GAAP lines, forecast a balance sheet funded at a target leverage, value the equity on residual income, and work one lease from both sides: the lessor’s equity IRR and the airline’s lease liability under IFRS 16 and ASC 842.

Preview the Upstream oil and gas model: E&P workbook
Advanced9 sheets~50 minER/HFIBPE

Upstream oil and gas model: E&P

Build a producer from its wells: a hyperbolic type curve and its EUR, a base in decline, wells drilled from a development budget, production in boe with gas at 6 to 1, reserves rolled forward from proved developed to 2P, prices realised from a forward curve, royalties, costs and the netback, DD&A on units of production, then PV-10 and NAV per share, and read what a low or high price deck does to each.

Preview the Mining model: copper-gold mine NAV workbook
Advanced11 sheets~50 minER/HFIBPE

Mining model: copper-gold mine NAV

Build a single open-pit mine from its reserve: ore mined and milled against the mill’s throughput, waste from the strip ratio, a head grade that declines and reconciles to the reserve, recovery and smelter terms to payable copper and gold, prices on a deck, C1 cash cost and all-in sustaining cost per pound, depletion on units of production, a closure provision settled at the end, tax with losses carried forward and a project loan, then NAV per share and P/NAV in real terms.

Healthcare 4 models

The healthcare hub

Drug pipelines and royalties valued on probability, devices on their installed base, and hospitals on their beds and payers.

Preview the Medtech installed-base and consumables model workbook
Core8 sheets~35 minER/HFIBPE

Medtech installed-base and consumables model

Roll an installed base of sold and leased systems, drive procedures and consumables from utilisation, separate recurring from capital revenue, account for leased systems as capital, and decide whether a system is worth more sold or leased.

Preview the Healthcare services model: hospital operator workbook
Core10 sheets~40 minER/HFIBPE

Healthcare services model: hospital operator

Build a hospital operator from its beds: patient days, admissions and adjusted admissions, revenue by payer with price concessions on self-pay, labour from staffing ratios and contract labour, supplies, EBITDA, then free cash flow, a buyout’s debt and the sponsor’s return, and read what a payer mix shift or a labour shock does to each.

Preview the Pharma royalty and licensing model workbook
Advanced12 sheets~45 minER/HFIBPE

Pharma royalty and licensing model

Value a portfolio of drug royalties from the licensee’s sales: build each product’s sales curve to generic entry, apply the licence’s tiered rates band by band, end the royalty at patent expiry, weight development products by their probability of approval, collect with the lag, and price a new royalty purchase on its IRR.

Technology 9 models

The technology hub

Recurring revenue and two-sided markets, built from customers.

Preview the Marketplace model: GMV, take rate and contribution workbook
Core7 sheets~35 minER/HFVCPM/Tech

Marketplace model: GMV, take rate and contribution

Build GMV from buyer cohorts with retention and frequency by tenure, take it to net revenue through the take rate and incentives, to contribution per order and EBITDA, and judge a buyer’s lifetime value against its acquisition cost.

Preview the Payments processing and monetisation model workbook
Core10 sheets~40 minER/HFIBVCPM/Tech

Payments processing and monetisation model

Build a payments company from processed volume by channel and region, take it through gross receipts and the pass-through costs to net revenue and the net take rate, to costs, EBITDA and free cash flow, roll the settlement float forward, and value the company on forward multiples and a DCF.

Preview the Telecom operator model: mobile and fibre workbook
NewAdvanced13 sheets~45 minER/HFIBPE

Telecom operator model: mobile and fibre

Build an integrated telecom operator from its customers and its networks: postpaid and prepaid subscribers rolled forward by gross additions and churn, ARPU by segment, handset revenue kept apart from service revenue, a fibre network from homes passed to connections as penetration ramps, costs to EBITDA and then to EBITDAaL after leases, capital spending split between maintenance and the fibre build, a spectrum auction amortised over its licence, then leverage, equity free cash flow, dividend cover and a DCF checked against a peer multiple.

Preview the Semiconductor foundry model workbook
Advanced12 sheets~45 minER/HFIBPE

Semiconductor foundry model

Build a foundry from its fabs: capacity by node added a year after the spending, utilisation through a cycle, revenue as wafers times price per wafer, yield as a cost, fixed and variable cost of revenue, a vintage-by-vintage depreciation waterfall, and free cash flow valued in a DCF, then read what a downturn year does to gross margin.

Preview the Duolingo operating model workbook
Core9 sheets~45 minER/HFPM/TechVCIB

Duolingo operating model

Rebuild a company’s own non-GAAP measures from its GAAP lines, model a subscription business as subscribers times what each pays, carry it five years in three labelled cases, and read what the forecast is worth at a chosen discount rate without mistaking it for a view on the shares.

Preview the Airbnb operating model workbook
Core9 sheets~50 minER/HFPM/TechVCIB

Airbnb operating model

Build a marketplace from nights and the price of a night, derive a take rate the company never files for a year, tell bookings, revenue and cash apart in every row, keep customer funds out of company cash and value, and read what the forecast is worth without mistaking it for a view on the shares.

Preview the Spotify operating model workbook
Core9 sheets~50 minER/HFPM/TechIBVC

Spotify operating model

Model a two-segment streaming business from its own KPIs, keep a segment reclassification from manufacturing growth, separate share-price-driven items from earning power, carry the forecast five years in three labelled cases, and read what it is worth without mistaking it for a view on the shares.

Preview the Adyen operating model workbook
Core9 sheets~50 minER/HFIBPM/TechVC

Adyen operating model

Model a payments platform from volume and take rate, keep volume, gross and net revenue from being confused, read a take rate as the product of a mix and a set of pillar rates, measure operating leverage against a hiring plan, value the business without counting merchants’ money or the interest on it as the company’s, and read the value without mistaking it for a view on the shares.

Financial institutions 4 models

Banks, lenders, insurers and asset managers, built from the balance sheet or the assets they run.

Preview the Bank operating and valuation model workbook
Advanced10 sheets~50 minIBER/HF

Bank operating and valuation model

Build a bank from its balance sheet: loans and deposits priced from the policy rate through betas, net interest income and the margin, an expected-loss allowance by stage, risk-weighted assets and the CET1 ratio against its requirement, the distributions the excess allows, and a value per share from residual income on tangible book.

Preview the Consumer lending model: loan vintages workbook
Advanced12 sheets~50 minER/HFIBPE

Consumer lending model: loan vintages

Build a non-bank lender from its loan vintages: each year’s originations repaid, prepaid or charged off on curves by years on book, the matrix of charge-offs and balances by origination year and forecast year, an allowance for the lifetime loss still to come and the provision that builds it, yield and fees less the cost of securitisation and warehouse funding at their advance rates, the cost of acquiring and servicing each loan, tangible equity against a covenant, new shares when the facilities will not fund the book, and a value per share from residual income and price to tangible book.

Preview the Insurance underwriting and valuation model workbook
Advanced12 sheets~50 minIBER/HF

Insurance underwriting and valuation model

Build an insurer from its premium: written, ceded and earned through the unearned premium reserve; claims incurred by line and rolled through a reserve with prior-year development; the loss, expense and combined ratios; investment income on the float; a solvency ratio and the dividends it allows; and a value per share from price to book, an embedded-value style sum and a dividend discount.

Preview the Asset manager AUM and fee economics model workbook
Core9 sheets~40 minER/HFIBPE

Asset manager AUM and fee economics model

Build an asset manager from its assets: an AUM roll-forward by product with flows, markets and distributions kept apart, management fees on average AUM at compressing fee rates, probability-weighted performance fees, costs split into a compensation ratio and fixed costs, operating leverage made explicit, EPS after buybacks, and a value per share on P/E, EV/EBITDA and a DCF of the fee stream.

What you can open, and what you can keep

Every model above can be previewed without signing in, and worked with online once you do. Downloads come with an account.

Browse without an account

Preview every model online, sheet by sheet, with its outputs and checks.

Free account

Work with every model online: change the inputs, switch the case, see every formula. And every starter workbook, with its key schedules left blank to build.

L3VLUP Plus

Everything in Free, and one worked model each billing month as an Excel file: every schedule built, formulas live, checks at zero, yours to keep.

L3VLUP Pro

Everything in Plus, every worked model in the library, graded starters, and the Pro applications.

The Inner Circle includes everything in Pro. About Plus · What else Pro includes

Around every model

Understand, inspect, build, download, check, apply

Understand

A primer teaches the idea in the words an interviewer uses.

Inspect

The whole workbook in the browser, every sheet and every cell, before you download.

Build

A lab drills it against a clock, marked as you go.

Download

The worked model, formulas live, and a starter that leaves the hard part to you.

Check

Every model carries its own checks; the page tells you they hold before you open it.

Apply

A skill runs the same logic on a real company from its filings.

Go deeper by area of practice

M&A and private equity models

9 models, 38 schedules, 14 labs and 18 guides: leveraged buyout model, merger model: accretion and dilution, merger arbitrage model: deal spread, break risk and position size, icg management buyout model, private equity fund model: cash flows, j-curve and waterfall, private equity secondaries model: pricing an lp stake, purchase price allocation model, cap table and exit waterfall model, carve-out and standalone cost model.

Credit and restructuring models

4 models, 16 schedules, 6 labs and 8 guides: credit model, 13-week cash flow model, recovery waterfall model, clo cash flow and waterfall model.

Real estate models

4 models, 18 schedules, 6 labs and 8 guides: property acquisition model, real estate development model, reit model: ffo, affo and nav, hotel underwriting model.

Project finance and infrastructure models

13 models, 61 schedules, 16 labs and 20 guides: project finance model, renewables project finance model, ppp availability payment model, regulated utility model: electricity network, aircraft leasing model, data centre colocation model, telecom tower model: tenancies per tower, container shipping model: liner company, gpu cloud infrastructure model, coreweave operating model, aercap operating model, upstream oil and gas model: e&p, mining model: copper-gold mine nav.

Healthcare financial models

4 models, 20 schedules, 10 labs and 14 guides: biotech rnpv and sum-of-the-parts model, medtech installed-base and consumables model, healthcare services model: hospital operator, pharma royalty and licensing model.

Technology company financial models

9 models, 28 schedules, 17 labs and 13 guides: saas operating model, marketplace model: gmv, take rate and contribution, 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.

Schedules: the building blocks

All schedules

A schedule recurs across models. Learn the debt schedule once and you will recognise it in the LBO, the three-statement model and the credit case; each schedule page shows exactly where it sits in every model that uses it.

Operating schedules

Financing schedules

Transaction schedules

Financial institutions schedules

The house style

What every model here has in common

Inputs in one place. Drivers sit on the Assumptions sheet. Detailed schedules such as a rent roll, a claims register or a programme sheet carry their own inputs, and the cover lists every sheet that has them. Formulas carry no hardcoded numbers.

Three font colours. Blue for inputs, black for formulas, green for links to other sheets. Check rows are shaded and should read zero.

No circular references. Interest is charged on opening balances, as each cover states, so the workbook calculates without iteration. Each page shows whether every check reads zero.

Sensitivities as formulas. Each cell of a sensitivity grid recalculates the output in closed form, so it can be traced, and the centre cell is checked against the main sheet.

Tagged schedules. Rows are tagged to the schedule they belong to, which lets a starter workbook clear one schedule, such as the debt schedule, and leave the rest of the model intact.

Illustrative data. Each model uses illustrative data for a fictional company, property, project or transaction, except a Deal in Focus model, built from a real transaction’s published documents with every undisclosed term labelled, and a Model the business model, built from a real company’s filings with every assumption labelled. The inputs are starting assumptions, not forecasts or market data.

Questions

Are the models free?

To use online, yes. Anyone can preview every model on its page, sheet by sheet, without signing in. A free account works with every model online: change the inputs, switch the case, see every formula and watch the workbook recalculate. Every starter workbook downloads with a free L3VLUP account. A worked model downloads with L3VLUP Plus (one each billing month, kept for good) or L3VLUP Pro (every model). Signing in is one email, no password.

What makes these different from a template library?

Each model is one node in a learning path. The primer teaches the idea, the lab drills it against a clock, the guide walks through the build, the worked model shows a finished version you can trace cell by cell, the starter workbook makes you build the hard part, and the skill applies the same logic to a real company. A template is only the fourth of those six.

Can I use them for my own work?

Yes, for study, interview preparation and your own analysis. They are not for redistribution as templates. Each uses illustrative data for a fictional company, property, project or transaction, except a Deal in Focus model, built from a real transaction’s published documents, and a Model the business model, built from a real company’s filings, each of which says so on its cover; when you use one for a real company, replace the inputs and check the outputs yourself.

Why is there no circular reference in any of them?

Interest is charged on opening balances throughout. That is a deliberate choice, stated on every cover sheet: a model that always calculates, at the cost of a one-year lag on interest, is the right trade for a model built to be learnt from, and it is the reason a formula engine can verify every check in every one of them before you download it.

What is a schedule?

A building block that recurs across models: a debt schedule, a working-capital build, a sources-and-uses table. The schedule pages explain each one, show exactly where it lives inside each model, and link the lab that drills it. Learn the schedule once and you can find it in every model that uses it.