# Project Finance Debt Sculpting Model 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. - Canonical: https://finamodel.com/templates/project-finance-sculpting-model - Excel download: https://finamodel.com/templates/project-finance-sculpting.xlsx - Category: Infrastructure - Model type: Project finance - Difficulty: Advanced - Audiences: Developers & sponsors, Bankers & advisors, Project developers, Lenders, Infrastructure sponsors, Advisors - Tags: project-finance, debt-sculpting, dscr, amortization, lender-covenants ## Overview 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+. ## 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 - Debt size calculation based on DSCR targets - Tailored amortization schedule matching project maturity - Sponsor equity IRR under sculpted debt profile ## Project Finance Sculpting Model: How Debt Sizing and Amortisation Work This project finance sculpting model structures senior debt so repayments track a target coverage ratio rather than a flat schedule. It covers traffic-driven revenue, operating costs, reserve accounts, a refinancing, and an equity waterfall over a full concession life, letting you examine how gearing caps, coverage covenants and cash sweeps interact in one consistent framework. ### Operating Drivers and Revenue Build-Up Revenue starts with base traffic for each tolled segment, split by vehicle class. - A net demand factor combines a phased structural growth rate, a GDP-linked contribution, a ramp-up vector, price elasticity and diversion to a free alternative. - Tolls escalate with a CPI-linked formula subject to a cap and periodic regulatory resets, and peak pricing lifts the revenue base. - Leakage from violations and bad debt reduces gross toll income to net revenue, while service areas, advertising and utility leasing add smaller income streams. ### Cost Structure and Reserves Operating costs are fully indexed to CPI and include routine O&M driven by traffic and axle weight, tolling system costs per transaction, policing, employee costs, insurance and property taxes. - Concession and grantor payments sit inside EBITDA. - Routine lifecycle capex and lumpy major maintenance events are funded partly through a Major Maintenance Reserve Account with a look-forward accrual, while a handback reserve builds over the final operating years. - Both reserves open and close at zero, acting as timing devices only. ### Debt Sizing and Amortisation Debt capacity is calculated as the present value of pre-tax CADS divided by a target DSCR across the amortising window, discounted at the all-in rate to the end of the interest-only period. - Senior debt raised is the lower of this capacity and a gearing cap applied to total project cost. - A scale factor then adjusts the sculpted principal so that the loan amortises at a realised DSCR equal to the target divided by the scale. - If the gearing cap binds, realised coverage is higher and flatter than the sizing target. ### Waterfall, Refinancing and Outputs A cash waterfall funds construction, services debt, tops up reserves and distributes the residual above a minimum cash balance, subject to a lock-up if coverage falls below a threshold. - A cash sweep prepays debt only when coverage clears a trigger. - At senior maturity the model refinances the remaining balance, sized against DSCR and PLCR caps, with proceeds flowing through the waterfall. - Outputs include DSCR, LLCR and PLCR profiles, project and equity IRRs, and a dashboard of KPIs for evaluating the structure. ## 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. ## 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. ## Features - **Automated debt sculpting:** Uses iterative optimization to find amortization profiles that meet minimum DSCR thresholds throughout project life. - **Covenant compliance tracking:** Monitors DSCR, leverage ratios, and interest coverage against agreed thresholds and highlights violations. - **Construction and operating phase modeling:** Handles interest-only periods during construction, step-up amortization, and flexibility for covenant holiday periods. ## Use cases - **Lender term sheet negotiation and structuring:** Optimize debt amount and amortization schedule to balance equity returns and lender coverage requirements. - **Refinancing and secondary market sales:** Model debt paydown and refinancing opportunities to maximize sponsor equity at intermediate milestones. - **Stress testing and scenario analysis:** Test debt service coverage under downside cash flow scenarios to evaluate credit risk and loan resilience. ## Frequently asked questions ### 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. ## Related templates - [Public-Private Partnership Availability Model](https://finamodel.com/templates/ppp-availability-model) - [Railway Concession and Operations Model](https://finamodel.com/templates/rail-concession-model) - [Toll Road Concession Model](https://finamodel.com/templates/toll-road-model)