Project Finance Debt Sculpting ModelFree Financial Model Download
Model project debt sculpting with tailored amortisation, coverage ratio covenants, and equity waterfall to match lender requirements and sponsor returns. Avoids trial-and-error adjustments by solving the optimal schedule against DSCR targets.
Free download. No sign-up required.
About this model
Design project debt repayment profiles that maintain target debt service coverage ratios (typically 1.25–1.30x) across changing project cash flows, from construction through mature operations. This template sculpts annual principal repayment as CFADS (cash flow available for debt service) grows, ensuring lenders maintain consistent coverage while equity receives maximum distributions after debt service. The model handles interest-only construction and early operations periods, then transitions to amortising debt during the stable cash generation phase.
The workbook includes a construction phase with capex phasing (S-curve), interest during construction accruals, a revenue model (toll revenue, PPA revenue, or concession availability payments depending on project type), an opex schedule, and a debt schedule sheet that calculates sculpted principal as MAX(0, CFADS/DSCR_Target − Interest_Expense). DSRA (debt service reserve account) is pre-funded at commercial operations date and monitored throughout. The waterfall prioritizes debt service, covenant calculations (DSCR, leverage), and equity lock-up mechanics (when DSCR drops below 1.15x, equity distributions are suspended). Project IRR and equity IRR are calculated from separate cash flow streams, showing leverage amplification.
Target users are project sponsors, infrastructure funds, pension funds, and project finance lenders evaluating greenfield projects, concessions, and infrastructure assets valued at $500M to $5B+.
Recolor to your brand.
Formatted to IB standards.
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with blue inputs, black formulas, and green cross-sheet links.
- Brand-ready
- Institutional grade
- Fully auditable
What's included
- Project cash flow from operations and capex schedule
- Debt sizing based on DSCR targets and lender requirements
- Tailored amortisation schedule matching project cash flow profile
- Interest reserve and cash sweep mechanics
- Debt service coverage ratio monitoring by year
Automated debt sculpting
Find amortisation profiles that meet minimum DSCR thresholds throughout project life without manually iterating between cash flow and debt schedules.
Covenant compliance tracking
Monitor DSCR, leverage ratios, and interest coverage against agreed thresholds and highlight periods where covenants are at risk.
Construction and operating phase modeling
Handle interest-only periods during construction, step-up amortisation, and covenant holiday periods before operations stabilise.
Frequently asked
What is debt sculpting in project finance?+
Debt sculpting tailors the amortisation schedule to the project cash flow profile so that debt service coverage ratios stay above covenant minimums throughout the loan life.
What is a typical project finance DSCR requirement?+
Minimum DSCRs typically range from 1.20x to 1.50x depending on project risk, lender appetite, and asset class. Riskier projects require higher coverage buffers.
Why is debt sculpting better than straight-line amortisation?+
It allows sponsors to maximise the upfront debt draw while ensuring coverage covenants are met throughout project life, which improves equity returns without breaching lender terms.
Can I model interest reserves and cash sweeps?+
Yes. The model tracks reserves funded at financial close and applies cash sweep mechanics to accelerate paydown when project cash flow exceeds target levels.
How do I stress test debt service coverage?+
Run downside cash flow scenarios against the sculpted debt schedule to evaluate how much revenue can fall before covenant thresholds are breached.
Alex Tapio
Founder of Finamodel • Professional Financial Modeller • Ex-Deloitte
Related templates
Public-Private Partnership Availability Model
Revenue availability model, unitary payments, debt service coverage, and equity IRR for PPP infrastructure projects.
Railway Concession and Operations Model
Passenger and freight revenue, operating costs, capital investment, and concessionaire returns for railway projects.
Toll Road Concession Model
Model toll road cash flows, traffic demand, toll rate escalation, and debt service with concession life assumptions.
Fibre Network Deployment Model
Capital and financial model for fiber optic network buildout with capex, subscribers, and ARPU.