Skip to content
Contact Visit forvismazars.com (opens in a new tab)
Register

LLCR and PLCR calculations and their common errors

How our model auditors check the LLCR and PLCR, with a step-by-step shadow modelling demonstration in Excel and the errors we find most often.

Browse coursesView more resources

Webinar · Recording · Presented by Ryan Humphrey · 12 November 2024

The loan life coverage ratio (LLCR) and project life cover ratio (PLCR) are two of the most often misunderstood and miscalculated ratios in project finance. Building on our earlier session on DSCR shadow modelling, this webinar shows how our model audit team checks these ratios and gives lenders and investors assurance that they are right.

What you will learn

  1. How model auditors test ratios

    How experienced model auditors evaluate the main financial ratios in a model.

  2. DSCR challenges

    A review of common DSCR challenges and how to solve them.

  3. Shadow modelling in Excel

    A step-by-step Excel demonstration of shadow modelling the LLCR and PLCR.

  4. Frequent errors

    The LLCR and PLCR errors our model audit team finds most often.

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

Webinars

Loan life coverage ratio (LLCR) in project finance

The loan life coverage ratio (LLCR) defined, built line by line in a transparent module and sense-checked across scenarios, and its use as a covenant.

Project finance ratios from contract to model

A modeller and a lawyer on project finance ratios: how loan documents define them, how covenants use them and how to model them so the two agree.

Services

Financial Model Audit

An independent opinion on your transaction model from the number one ranked global model audit practice. Red flag report in under 5 working days.

Financial Model Development

Transaction and operational models built to your specification, lender-ready and documented, then handed over to your team with the logic explained.

Learn to build these models yourself

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

Browse all training coursesSend enquiry