Coming soon
Project Finance Model (SPV) Excel Template
Project finance / SPV model with DSCR-driven debt sizing, LLCR/PLCR cover ratios, multi-tranche debt sculpting, and equity IRR. For infrastructure, energy, and PPP deals.
Who it's for
Project finance teams at investment banks, infrastructure funds, energy developers, project sponsors, and PPP/concession advisors. Lenders modelling deals on the credit side.
What's in the model
COVER
Model documentation, hyperlinked tab index.
INPUTS
Construction cost, capex schedule, opex, revenue model, debt terms (rate, tenor, target DSCR), equity contribution.
CONSTRUCTION
Capex monthly drawdown, interest during construction (IDC), equity vs debt funding split.
OPERATING
Operating phase cash flow: revenue, opex, taxes, working capital, FCFF.
DEBT_SCHEDULE
Multi-tranche senior debt with sculpting (DSCR-driven amortisation). Optional mezzanine layer. DSRA modelling.
DSCR_LLCR
Debt service cover ratio (period and minimum). Loan life cover ratio. Project life cover ratio.
EQUITY_RETURNS
Equity IRR with dividend timing. Sensitivity to revenue / opex / capex overrun.
DEBT_SIZING
Solve maximum debt quantum from target DSCR. Iterate against target equity IRR.
OUTPUTS
Executive summary, key metrics, financing summary, sensitivity tables.
CHECKS
Sources = uses, debt schedule ties, cash sweep priority, IRR reconciles.
What makes this different
Debt sculpting
Senior debt amortisation calibrated to maintain target DSCR throughout the operating phase. Most templates use straight-line amortisation.
DSRA modelling
Debt Service Reserve Account funded at financial close, drawn down on cash flow shortfalls, replenished from project cash.
LLCR + PLCR + DSCR
All three cover ratios calculated — not just DSCR. Lenders will want all three.
Long-dated horizon
Up to 30-year forecast. Works for infrastructure concessions and PPP deals.
Debt sizing tool
Solves debt quantum from target DSCR, not the other way around. Standard at infrastructure desks.
Get notified when this launches
Excel (.xlsx) · ~12 tabs · up to 30-year horizon · expected pricing £495 · May 2026 launch target
No spam. One email when it ships. Or contact us at sfsmodels362@gmail.com for a custom early build.
Frequently asked questions
When will this be available?
Built as an .xlsx file already. Currently being prepared for launch — targeting May 2026. Sign up to get notified the moment it ships.
Will it support PPP / concession deals?
Yes — the same engine handles infrastructure, energy, PPP, concession deals. Toggle on INPUTS.
What about renewable energy specifics?
Solar, wind, battery storage all work. Revenue can be PPA-based, merchant-based, or blended.
Can I commission an early build?
Yes — for time-sensitive deals, we do custom builds with same-day delivery. Use the form below or contact us.
Related models (live now)
About SFS Models
SFS Models builds institutional-grade Excel financial models for banking and finance professionals. Used by FP&A, Treasury, ALM and Capital teams at US and UK regional banks, by PE firms, and by corporate finance consultancies. Open formulas, no VBA, fully auditable.