LLCR (Loan Life Coverage Ratio)

Definition¶

The Loan Life Coverage Ratio (LLCR) is a project finance metric that measures the ratio of the net present value (NPV) of all projected cash available for debt service (CADS) over the remaining loan life to the current outstanding debt balance. It is a forward-looking coverage ratio that tests whether the project has sufficient projected cash generation to repay all outstanding debt.

The LLCR formula is:

LLCR = NPV of CADS over remaining loan life / Outstanding debt balance

Where:
NPV of CADS is discounted at the loan interest rate (or a specified hurdle rate as defined in the loan agreement)
Remaining loan life runs from the test date to the scheduled debt maturity date
Outstanding debt balance is measured at the test date

LLCR is expressed as a ratio: an LLCR of 1.25x means that the NPV of projected cash available for debt service is 1.25 times the outstanding debt balance.

Why It Matters¶

LLCR addresses a fundamental limitation of the DSCR: DSCR measures coverage in a single period, while LLCR measures coverage over the entire remaining loan life. A project can have a compliant DSCR in the current period while being on a trajectory that will produce a shortfall in future periods. LLCR captures this forward-looking risk.

For lenders in long-tenor project finance transactions, LLCR is often the more important metric:

• A project with strong near-term DSCR but declining long-term cash generation may show LLCR deterioration before DSCR breach
• LLCR is more sensitive to changes in long-term assumptions (revenue growth, cost escalation, maintenance capex) than DSCR
• A lender who tests only DSCR may miss early warning signals that LLCR would reveal

In financial model audit, LLCR requires careful attention because it is sensitive to the discount rate assumption and the completeness of projected cash flows over the remaining loan life.

Technical Background¶

LLCR Calculation: Step-by-Step¶

Step 1: Identify the test date The test date is the date as at which LLCR is calculated. In the financial model, this is typically every covenant test date.

Step 2: Define the remaining loan life The remaining loan life is the number of periods from the test date to the scheduled final maturity of the loan. In the model, this is determined by the debt schedule.

Step 3: Project CADS over remaining loan life CADS is calculated in each future period using the same definition as for DSCR:

CADS = Operating Revenue - Operating Costs - Taxes - Changes in Working Capital - Capital Expenditure - Reserve Account Movements

Step 4: Calculate NPV of projected CADS Discount the projected CADS series from Step 3 at the specified discount rate (usually the loan interest rate or a blended average of the debt cost). In Excel:

=NPV(discount_rate, CADS_range)

Note: Excel's NPV function discounts from period 1, assuming cash flows begin one period after the starting point. Adjust for the timing of CADS if cash flows begin at a different point. XNPV is the appropriate function for non-uniform periods:

=XNPV(discount_rate, CADS_range, date_range)

Step 5: Divide by outstanding debt

LLCR = NPV of CADS / Outstanding debt balance at test date

LLCR vs DSCR¶

Note: Covenant thresholds are transaction and market specific. The ranges cited above are illustrative only and are not market benchmarks.

PLCR: Project Life Coverage Ratio¶

Some loan agreements also include the Project Life Coverage Ratio (PLCR), which extends the CADS projection beyond the debt maturity to the end of the project's economic life:

PLCR = NPV of CADS over remaining project life / Outstanding debt balance

PLCR is less commonly used than LLCR but appears in transactions where the project has significant post-debt-maturity cash generation that should be available as a recovery buffer for lenders.

Discount Rate Selection¶

The discount rate used in the LLCR NPV calculation is specified in the loan agreement. It is typically:

• The loan interest rate (most common)
• A fixed hurdle rate agreed at financial close
• A blended average of fixed and floating rate components

The choice of discount rate materially affects the LLCR result. A higher discount rate reduces the NPV of distant cash flows, making LLCR more sensitive to early-period cash generation. A lower discount rate gives more weight to long-term cash flows. Auditors must verify that the discount rate in the model matches the loan agreement definition.

Audit Considerations¶

1. Discount Rate Verification¶

Verify that the discount rate used in the LLCR NPV calculation matches the definition in the loan agreement. The most common error is using the nominal interest rate when the agreement specifies the effective or all-in rate (including fees), or vice versa.

2. CADS Definition Consistency¶

Confirm that CADS used in the LLCR calculation is defined consistently with CADS used in the DSCR calculation. Inconsistent definitions between the two calculations produce results that cannot be compared or interpreted correctly.

3. Remaining Loan Life Calculation¶

Verify that the model correctly identifies the remaining loan life from each test date. Errors can arise when:

• The debt maturity date is hardcoded rather than derived from the debt schedule
• The model uses calendar years rather than periods, creating timing mismatches
• The debt includes tranches with different maturities that are not correctly weighted

4. Reserve Account Treatment¶

Confirm whether reserve account balances (DSRA, MRA) are included in the outstanding debt balance or in the CADS projection, as specified in the loan agreement. Inconsistent treatment will produce incorrect LLCR results.

5. LLCR at Minimum Point¶

Identify the period in the model where LLCR is at its minimum and confirm headroom above the covenant threshold. LLCR typically declines as the loan matures and the remaining cash flow profile shortens. The minimum LLCR is usually in the final years of the loan when the remaining CADS projection is small.

6. Sensitivity Testing¶

Test LLCR sensitivity to changes in the discount rate and long-term CADS assumptions. Because LLCR is a long-horizon metric, small changes in revenue growth or cost escalation assumptions in later years can materially affect the result.

Common Errors¶

Best Practices¶

Present LLCR alongside DSCR in a dedicated covenant compliance section of the financial model, showing both metrics at every test date throughout the loan life. This allows a credit analyst or auditor to see the full coverage picture — current period and forward-looking — in a single view.

Document the discount rate assumption explicitly and cross-reference it to the relevant clause in the loan agreement.

Run the LLCR calculation in a separate section of the model that clearly traces the discount rate input, the CADS series, and the outstanding debt balance, so that each component can be independently verified.

Continue Reading¶

Prerequisites¶

• What Is a Project Finance Model Audit? — the parent pillar

Related Glossary¶

• Financial Covenant
• Project Finance Model
• Infrastructure Model
• Debt Service
• Debt Sculpting
• Tail Ratio
• Financial Close