L3VLUP
Project finance schedules · in 1 model

Coverage ratios

DSCR, LLCR and PLCR.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: coverage ratios.Updated 30 September 2026

What it does

Three ratios on the same cash flows. DSCR is the period test, cash available over service in that period, reported as a minimum and an average across the tenor. LLCR takes the whole-loan view: the present value of the CFADS remaining inside the tenor over the balance outstanding. PLCR extends the same calculation to the end of the project life, crediting the tail after maturity. A model that quotes only the average DSCR has hidden the period the lender cares about.

Where it lives

The same schedule in each model that carries it, with the rows to open. Open a model in the browser, go to the sheet, and click the lines.

Project finance model
  • Debt, rows 20–25: DSCR, this case, LLCR: PV of remaining CFADS over the tenor, over the opening balance, CFADS inside the tenor (for the LLCR), PLCR: PV of all remaining CFADS over the opening balance…
  • Returns, rows 23–27: Minimum DSCR over the tenor, Average DSCR over the tenor, LLCR at commercial operation, PLCR at commercial operation…

What a reviewer looks for

  • Discounting the LLCR numerator at the equity rate rather than the loan rate.
  • A PLCR quoted as if it were an LLCR, so the tail flatters the loan.
  • The minimum DSCR read off an annual model.

Learn it, then build it

Vocabulary: DSCR (Debt Service Coverage Ratio), LLCR (Loan Life Coverage Ratio).

Other project finance schedules