Skip to content

Debt sizing and debt sculpting in project finance

Debt sizing and debt sculpting are often confused. How each works in a project finance model, how the DSCR connects them and what the target DSCR changes.

Article · 3 minute read · 7 February 2017

The modelling of debt facilities is at the heart of every project finance transaction. The term sheet sets out the basic terms and conditions, but senior bankers expect the industry’s accepted practices to be built into the model as a matter of course. Two of those practices, debt sizing and debt sculpting, are often confused.

Debt sizing in a project finance model

Sizing the debt means finding the largest amount of project finance debt the model shows the project can carry. That amount becomes the debt limit, and the amount the bank reserves capital for.

How the limit is calculated is a topic of its own. To keep it simple, assume it is the amount of debt that can be repaid while the debt service cover ratio (DSCR) stays above a set threshold, both the minimum and the average DSCR. Debt can also be sized to ratios other than the DSCR. Other things being equal, the stricter the covenants, such as the minimum DSCR or loan life cover ratio (LLCR) the lender requires, the riskier the project is considered to be.

How the DSCR is calculated

The DSCR compares the cash flow available for debt service (CFADS) in a period with the debt service due in that period.

DSCR=CFADSdebt service

The lender sets a minimum DSCR so the project can make its debt repayments in each period. The higher the minimum DSCR, the less the project can borrow.

Debt sculpting in a project finance model

In many project finance transactions the project’s cash flow varies from period to period. An oil and gas project, for example, has a very different cash flow profile over time from a toll road.

To increase the project’s debt capacity, the total debt service in each period is matched to the CFADS available to pay it. This matching is called sculpting. When we sculpt debt, we set the principal repayments so that total debt service follows CFADS and the DSCR follows a target profile. Sculpting goes hand in hand with sizing, but it is a different exercise.

Principal can be entered by hand for each period, but the most flexible approach calculates it:

principal repayment=CFADStarget DSCR− interest

A higher target DSCR reduces the repayments in every period except the last. That pushes the repayment profile later, which sponsors usually prefer. There is a limit to how high the target can go, because the debt still has to be repaid within the tenor. A lower target DSCR increases the repayments, so the debt is repaid sooner.

Tutorials on this topic

Learn financial modelling in a room

Hands-on courses in person and online, taught to more than 20,000 people on one modelling standard.

Best Practice Project Finance Modelling

Build and sensitise robust cashflow models from scratch, faster in Excel. Hands-on, practitioner-led, in person or online. See dates and book your place.

View full course details: Best Practice Project Finance Modelling

Advanced Project Finance Modelling

Debt sizing, covenant monitoring, DSRAs and integrated three-way statements. Hands-on, practitioner-led training, in person or online. See dates and book.

View full course details: Advanced Project Finance Modelling

Financial Model Review

Error classes, testing technique and where AI-assisted financial model review earns its place. 1-day course from our award-winning Model Audit team.

View full course details: Financial Model Review

Browse all training courses

More on this topic

Tutorials

Debt sculpting to target DSCR without VBA

An algebraic approach to debt sculpting that rearranges the DSCR formula to solve for the principal repayment in each period, with no VBA or macro.

Using a Goal Seek macro to find the maximum debt limit

How a goal seek macro solves for the largest amount of debt a project can carry at a target DSCR, with the debt sizing logic laid out in the model.

Services

Financial Model Development

Transaction and operational models built to one modelling standard, documented for lenders and investors and handed over with the logic explained.

Financial Model Audit

An independent opinion on the model behind your transaction, with a red flag report on any show-stopper issues in under 5 working days.

Learn to build these models yourself

We run public and in-house courses across the full financial modelling curriculum.