Project finance model
Size a project loan by sculpting to a coverage target, run the reserve accounts and the lock-up through a full waterfall, and say what the equity earns on the base case and the downside.
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
Size a project loan by sculpting to a coverage target, run the reserve accounts and the lock-up through a full waterfall, and say what the equity earns on the base case and the downside.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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
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.
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
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.
Long-dated, cash-yielding assets. Different maths, much longer horizons.
Price and place bonds and loans. Closest thing in banking to a markets seat with banking hours.
Lend to the same companies PE buys. Downside-focused: you get paid back or you do not.
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.
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.
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.