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

Project finance ratios from contract to model

A financial modeller and a lawyer on project finance ratios: how loan documents define them, where covenants use them and how to model them in Excel.

Browse coursesView more resources

Webinar · Recording · Presented by Leigh Tomlinson and Calvin Walker · 4 July 2024

Project finance ratios webinar materials

The materials from this webinar.

Download the materials (opens in a new tab)

Turning project finance contracts into a financial model is hard, particularly when you interpret the definitions and apply the calculations. Financial ratios are an area of the finance documents that needs careful drafting and an accurate reflection in the model.

This webinar covers the role, definition and calculation of project finance ratios, with real examples of drafting and modelling. It brings two views: a financial modeller, Leigh Tomlinson of Forvis Mazars, and a lawyer, Calvin Walker of CCC Training. Forvis Mazars and CCC Training hosted it together.

What you will learn

  1. Legal definitions

    The role and legal definition of financial ratios, and their components, in project finance documents.

  2. Covenants in the documents

    How and where financial covenants and ratios are used, with examples of drafting from loan documentation.

  3. Modelling ratios in Excel

    Best practice approaches to modelling financial ratios in Excel.

  4. Minimum and average ratios

    How to extract metrics such as the minimum and average ratios from your model.

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

Debt service coverage ratio (DSCR) in financial models

What the debt service coverage ratio (DSCR) measures, how to model it step by step and how lenders use it to sculpt debt service and set covenants.

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.

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