The Loan Life Cover Ratio (LLCR) is one of the most commonly used debt metrics in Project Finance. Unlike period-on-period measures such as the Debt Service Cover Ratio (DSCR) it provides an analyst with a measure of the number of times the cashflow over the scheduled life of the loan can repay the outstanding debt balance.
How many times more than the senior debt liability is the projects asset base (on a discounted basis), are the operational cashflows?
Interpretation of the Loan Life Cover Ratio (LLCR) – Example 1
An LLCR of 2.00x means that the Cashflow Available for Debt Service (“CFADS”), on a discounted basis, is double the amount of the outstanding debt balance.
Interpretation of the Loan Life Cover Ratio (LLCR) – Example 2
An LLCR of 1.00x means that the CFADS, on a discounted basis, is exactly equal to the amount of the outstanding debt balance. The movement of a key variable to achieve an LLCR of 1.00x is an important measure of the strength of the project economics, often referred to as the ‘LLCR break-even’. A typical example is analysis of a toll road where the analysis could be ‘the project achieves a break-even LLCR at 38% reduction of patronage from the Base Case’. In comparison the DSCR breakeven might only be 20%.
Generally the LLCR is calculated as:
LLCR = NPV [ CFADS over Loan Life ] / Debt Balance b/f
The Discount Rate used in the NPV calculation is usually the Cost of Debt, also known as the Weighted Average Cost of Debt.
Variations in LLCR Definition
From time to time Borrowers request and Lenders allow other ‘assets’ to be either included in the numerator or excluded from the denominator to reflect instances where there will be other cash deposits available to the lender in the event of default rather than just the NPV of the Cashflow.
For example it is not uncommon to find the balance of the project’s cash account, or the Debt Service Reserve Account (‘DSRA’) added to the numerator or netted from the numerator. Extreme caution needs to be applied when assessing the economics of a project where the LLCR is supported with cash account balances
When DSRA is included, the Loan Life Coverage Ratio shall then be calculated as:
LLCR = (NPV [ CFADS over Loan Life ] + DSRA/c Balance b/f ) / Debt Balance b/f
The LLCR does not pick up weak periods as it essentially represents a discounted average. For this reason, if the Project has steady cashflows with Credit Foncier repayment, a good rule of thumb is that the LLCR should be roughly equal to the average DSCR.
The example below illustrates a Project with a steady CFADS and Credit Foncier repayment. The example illustrates that the average DSCR is very close to the LLCR’s in this situation.
Screenshot #1: Example of LLCR and DSCR calculation
Common Errors and Oversights made when Modelling the LLCR
Algebraically the LLCR is a simple calculation, however it is also a calculation which is prone to error. Below are some of the frequently encountered mistakes:
- The NPV in the numerator has not calculated with the wrong base time so the LLCR values are all on different ‘time basis’.
- Incorrect use of the (X)NPV function in Excel.
- The discount rate has not been calculated as cost of debt, which includes interest and margin (and if appropriate PRI).
- The Discount Rate, which is usually the ‘Average Cost of Debt’ is overcomplicated rather than calculated simply as:
= Total Interest (for all tranches) / Total Debt Balance B/f (for all tranches)
- The formulas are too complicated making them hard to edit if the definition requires variation or to validate.
- The definition of the LLCR in the model is not clear and has not been validated against the debt term sheet.
- LLCR covenants are used to trigger cash sweeps, while at the same time including interest on reserve accounts / cash balances in the model resulting in a circular model.
- The inclusion of CFADS has not been correctly capped at the end of the loan life.
- CFADS has not been clearly presented in the cash waterfall and the LLCR is incorrectly referring to some other line in the waterfall.
- The discounting of CFADS is calculated incorrectly by confusing compound/simple interest rates.
- Adjustment has not been made and an annual discount rate is being applied to quarterly cashflows, or vice versa.
Caution needs to be applied when adding the DSRA/c Balance B/f into the numerator. Remember that the DSRA/c Balance shall be added to the NPV (CFADS) line, and not to be discounted as in CFADS. This clause must be carefully checked in the definition of LLCR in the Term Sheet.
Checking the Calculation of LLCR
Some good rules of thumb to check if LLCT has been calculated correctly:
- For steady cashflows with a Credit Foncier repayment the Average DSCR should be very close to the LLCR.This is a good rule of thumb to cross-check the LLCR and/or the average DSCR. This is not always the case especially in highly sculpted or exotic repayment scenarios.
- If CFADS is constant throughout and a Credit Foncier repayment is being adopted, then the calculated LLCR should also be constant.Please refer to the Screenshot #2, where the CFADS is USD 100 Million throughout and the Credit Foncier repayment is adopted. The LLCR is 1.66x throughout.
Screenshot #2: Example of constant LLCR