Project finance and infrastructure models

Project finance lends against one asset’s cash flows rather than against a company, so the model is the deal: the construction budget and its funding, the revenue the contract allows, the cash available for debt service, debt sized and repaid to keep coverage above what the lenders require, the reserves that protect them, and what is left for equity. Infrastructure comes in two broad kinds. Revenue-based projects such as a wind farm carry volume risk, so their debt is sculpted to the cash flow and protected by reserves and a lock-up. Availability-based PPPs are paid for keeping a hospital, school or road available, so their risk is performance, their debt is often an annuity, and the model’s job is to price the bid.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: project finance.Updated 5 November 2026

The models

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
Advanced15 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.

Other areas: Core modelling · M&A and private equity · Credit and restructuring · Real estate · Healthcare · Technology · Financial institutions · All 57 models

How to work through it

Start with the DSCR sculpting lab, which sizes the same loan by hand two ways, sculpted and level. Then open the wind farm model to see sculpting, the debt service reserve and the lock-up working over twenty years. The renewables model adds what a solar or wind lender sizes on: an energy yield with degradation, a PPA over part of the output with a merchant tail, and debt that is the lesser of a gearing cap and the DSCR. The PPP model takes the other half of infrastructure: switch its performance case and watch deductions pass the contractor’s cap and reach equity, then read the value-for-money test the authority runs on the same numbers. The regulated utility model is the network that is never handed back: a rate base that grows with the capital plan, revenue built from the return the regulator allows on it, the lag between rate cases, and debt and new shares raised to hold the equity layer. The aircraft leasing model moves the same discipline to a lessor: rent from a lease rate factor, maintenance reserves held apart from revenue, a secured loan tested for DSCR and LTV through the year an aircraft is off lease, and a return that rests on the residual value. The data centre colocation model builds a campus in phases: megawatts pre-leased and absorbed, power passed through at PUE, a construction loan converted to a term loan sized on the next year’s NOI, and a yield on cost read against the exit cap rate. The telecom tower model rents structures that already stand: tenancies per tower rolled forward with an anchor on every site, an inflation escalator held between a floor and a cap, a ground lease buy-out programme, and the yield on cost of one tower with one, two and three tenants read against the price a buyer pays. The GPU cloud model applies the same discipline to compute: a term loan per cohort sized on its contract and repaid over it, and liquidity tested in the years the contracts end and the notes fall due. The upstream oil and gas model values an asset that depletes: wells on a decline curve, reserves rolled forward as drilling replaces production, and the proved developed reserves discounted to PV-10 and a NAV per share at three price decks. The mining model does the same for a single open-pit mine: a reserve scheduled through a mill, cash costs per pound, a closure cost at the end and a life-of-mine NAV with the cover ratios and reserve tail a project lender asks for. The container shipping model takes a fleet of long-lived ships owned or chartered by an operator rather than one asset: newbuilds paid for in yard instalments before they earn, a freight rate on a cycle against costs that follow the ships, and leverage read through the trough. Each model has a starter workbook that leaves one schedule for you to build.

The mechanics they share

Each schedule is one reusable calculation, explained on its own page with the rows it occupies in every model that uses it.

Project finance schedules

Construction funding

Draws, interest during construction, fees, equity

Project finance schedules

CFADS

Cash flow available for debt service

Project finance schedules

Debt sculpting

Service shaped to CFADS at a target DSCR

Project finance schedules

Coverage ratios

DSCR, LLCR and PLCR

Project finance schedules

Reserve accounts

Debt service reserve and maintenance reserve

Project finance schedules

Distribution waterfall

Debt service, reserves, lock-up, equity

Project finance schedules

Project and equity returns

Gearing, project IRR, equity IRR and multiple

Project finance schedules

Energy yield and power revenue

P50 energy, degradation, PPA and merchant revenue

Valuation and returns

Sensitivity tables

Two assumptions at once, without a data table

Project finance schedules

Unitary charge and deductions

The availability payment, its indexation and the deductions

Project finance schedules

Annuity repayment

Level debt service: interest falls, principal rises

Project finance schedules

Pricing a PPP bid

The unitary charge that gives the target equity IRR

Project finance schedules

Value for money

PPP payments against the public sector comparator

Operating schedules

Rate base roll-forward

Opening, capital plan, regulatory depreciation, closing

Operating schedules

Allowed revenue: the building blocks

Return on rate base, depreciation, opex and tax allowances

Operating schedules

Regulatory lag: earned against allowed return

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

The statements

Operating costs and margins

Cost of sales, opex, EBITDA

The statements

Tax

Tax on profit, and tax on operating profit

Financing schedules

Debt schedule

Tranches, interest, amortisation and the sweep

The statements

Equity roll-forward

Share capital and retained earnings

Valuation and returns

Discounting and terminal value

Discount factors, two terminal methods, reconciled

Valuation and returns

Enterprise value to equity value

Debt off, cash on, per share

Financing schedules

Lessor lease revenue and re-leasing

Lease rate factor, straight-line rent, downtime

Financing schedules

Maintenance reserves and security deposits

Restricted cash held for the lessee

Financing schedules

Book depreciation, residual value and sale

Book value against market value at exit

Real estate schedules

Development budget and draw profile

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

Real estate schedules

Data centre capacity and lease-up

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

Project finance schedules

Data centre power: PUE and pass-through

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

Real estate schedules

NOI build

Gross rent to net operating income

Real estate schedules

Loan sizing: LTV, DSCR and debt yield

The lender lends to the tightest of three constraints

Real estate schedules

Development returns and spread

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

Operating schedules

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

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

Operating schedules

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

Anchor tenancies, colocation adds and churn, tenancy ratio

The statements

Revenue build

Where the top line comes from

Operating schedules

Ground lease schedule: rent, escalators and buy-outs

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

Operating schedules

Capex and depreciation (PP&E roll-forward)

Opening, plus capex, less depreciation, closing

Operating schedules

Tower unit economics: yield on cost by tenant

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

Valuation and returns

Returns analysis

Exit value, MOIC, IRR and the bridge

Operating schedules

Container fleet: owned, chartered, newbuilds and scrapping

Capacity in TEU, yard instalments, charters returned

Operating schedules

Liftings and freight rate: a liner’s revenue

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

Operating schedules

Bunker fuel and the bunker adjustment factor

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

Operating schedules

Working capital schedule

Receivables, inventory and payables in days

Operating schedules

Capacity cohorts: MW, GPUs, utilisation and revenue

Cohorts of compute, GPU-hours, power and revenue

Operating schedules

Backlog roll-forward: contracts to revenue to cash

Bookings, revenue recognised, backlog, prepayments

Financing schedules

Facility debt: contract-backed term loans and notes

Delayed-draw loans by cohort, DSCR, notes

Financing schedules

Covenant compliance and headroom

Leverage, interest cover, fixed charge cover, EBITDA cushion

Restructuring schedules

Liquidity forecast and covenant headroom

Cash, availability, headroom, shortfall

Financing schedules

Maturity profile and refinancing

What falls due when, and whether it can be refinanced

Transaction schedules

Sources and uses

What the deal costs and who funds it

The statements

Cash flow statement

Indirect method, closing on balance-sheet cash

The statements

Balance sheet

Every line from a schedule, and the check

Financial institutions schedules

Residual income valuation and the justified P/TBV

Profit above the cost of equity, on tangible book

Financing schedules

Aircraft leases, lease liability and EBITDAR

Rent by vintage, lease liability, lease-adjusted debt

Operating schedules

Realised prices and the field netback

Benchmarks, differentials, royalties, costs per boe

Operating schedules

Type curves and production decline

Arps decline, EUR, the base and wells drilled

Operating schedules

Oil and gas reserves roll-forward

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

Operating schedules

Units-of-production DD&A

A cost pool over reserves, times production

Valuation and returns

PV-10 and upstream NAV

Proved developed reserves valued, net debt, per share

Operating schedules

Mine plan: from ore reserve to payable metal

Ore and waste, head grade, recovery, smelter payables

Operating schedules

C1 cash cost and all-in sustaining cost

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

Operating schedules

Mine closure and rehabilitation provision

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

Practise first

DSCR Sculpting · 12 min

Sculpt debt service to CFADS at a target DSCR, size the loan as its present value, split a payment into interest and principal, and explain why a level repayment profile fails a project lender.

Optimal Capital Structure · 15 min

Explain why more debt stops helping: watch coverage, rating and spread move as leverage rises until WACC turns.

WACC Builder · 12 min

Build a discount rate you can defend line by line: beta, equity risk premium and cost of debt, each from a source you can name.

EV to Equity Bridge · 12 min

Walk from enterprise value to a price per share without dropping a claim: net debt, pensions, minorities, leases and options.

IRR by Eye · 3 min

Say the IRR for any multiple and hold before the interviewer finishes the sentence, and the multiple for any IRR.

DCF Builder · 15 min

Build a DCF by hand from revenue to a share price, know how much of it sits in the terminal value, and name the one assumption the answer hinges on.

Unit Economics · 12 min

Build an LTV:CAC you could defend under questioning, and answer payback as its own question.

Covenant Headroom · 10 min

Compute the three maintenance ratios from a certificate, find the binding test and its EBITDA cushion, and say whether a given downside breaches.

Depreciation Waterfall · 10 min

Forecast depreciation from a capex plan rather than a ratio, read a capex-to-depreciation multiple, and say which part of the spend is buying growth and which is only standing still.

Three-Statement Linker · 8 min

Walk any event through all three statements in the right order, with the right signs, and prove the balance sheet balances rather than asserting it.

LBO Modelling Test · 60 min

Sit the one-hour test under a clock, in the browser or in your own workbook, and get every line of the build marked.

Capital Stack Challenge · 15 min

Finance a real buyout from revolver to equity, hold it through a shock, and explain every layer against the deal the sponsor actually did.

Reverse DCF · 10 min

Read off the growth a share price already assumes, and say whether that is plausible before anyone asks.

Paper LBO Trainer · 8 min

Solve MOIC and IRR in your head from a deal you have never seen, in under ten minutes.

Napkin LBO · 12 min

Sketch a full buyout by hand, from sources and uses through the debt paydown to the return, and say which bucket the return depends on.

Beta Refresher · 10 min

Estimate a beta, see how far one regression lands from the truth, and know when to use raw, adjusted, unlevered or bottom-up.

Where this work is done

Infrastructure & Real Assets

Long-dated, cash-yielding assets. Different maths, much longer horizons.

Debt Capital Markets

Price and place bonds and loans. Closest thing in banking to a markets seat with banking hours.

Private Credit

Lend to the same companies PE buys. Downside-focused: you get paid back or you do not.

Read

The vocabulary

Questions

What is the difference between project finance and corporate finance?

Corporate lending looks at a company’s whole balance sheet and lends against its earnings, usually as a multiple of EBITDA. Project finance lends to a company that owns one asset and nothing else, without recourse to its sponsors, so the only security is that asset’s cash flow. The debt is sized on coverage of debt service in every period, not on a multiple, and the contracts that fix revenue and cost are what the lenders underwrite.

What is the difference between an availability PPP and a revenue project?

A revenue project, such as a wind farm or a toll road, earns from what it sells or how much it is used, so it carries volume or price risk and its debt is sculpted to the cash it expects. An availability PPP is paid by a public authority for the asset being available and performing, whether or not it is used, so its risks are construction and performance and its debt is often a level annuity.

Which numbers do project finance interviews test?

CFADS and the DSCR, how sculpting sizes debt and why it is not circular when written well, LLCR against DSCR, what a debt service reserve and a lock-up do to equity, and for PPP roles the unitary charge, deductions and pass-down, and how a bid is priced to a target equity IRR. The DSCR lab drills the sizing, and each model page lists the mistakes a reviewer looks for.