Financial modelling webinars: 2021 highlights

Tuesday 8th March 2022

Now that our 2022 webinar series is well and truly underway, we thought it might be a good time to look back at the webinars we hosted in 2021. There is plenty of content here for you to absorb and use to improve your skillset.

For aspiring world class financial modellers, we recommend the following parts of our website:

Now, for the highlights from our 2021 financial modelling webinar series, here it goes:

Project Finance: What is LLCR (Loan Life Coverage Ratio)

In this financial modelling focused webinar on the topic of LLCR (Loan Life Coverage Ratio) we cover the definition, the application in Project Finance, and how to apply the calculation in a financial model. In addition to the purely mechanical calculations, Shaun demonstrates some commercial reflections relation to how to sense-check your calculations. Learning objectives:

Understand the definition of LLCR (Loan Life Coverage Ratio)
Learn more about the commercial applications of this metric as a covenant in Project Finance
Discuss line-by-line calculations in a financial model to achieve a transparent and flexible LLCR module
Expand your financial modelling toolbox with a few tips on how to sense check your LLCR calculations in a range of scenarios

Related financial modelling courses:

November 2021 update: Asset valuation trends (infrastructure and energy)

This webinar focuses on the latest trends in renewable energy asset valuations, and explore the impact of recent power price volatility across multiple countries around the world. We will look at what dedicated renewable energy investment funds have been reporting and how far their own performance has been linked to short-term price movements.

Related courses in financial modelling, renewable energy and valuation techniques:

Introduction to the Debt Service Coverage Ratio

The Debt Service Coverage Ratio (DSCR) is modelled and analysed in the vast majority of project finance flavoured transactions across all sectors. This webinar covers the definition of DSCR, how to develop appropriate financial modelling modules, and the role of DSCR in debt sculpting applications. Learning outcomes:

Learn about the DSCR – it’s purpose and how to calculate it
Develop best practice techniques for financial modelling of DSCR
Understand how the DSCR is applied for ‘sculpted’ debt service
Appreciate the importance of the DSCR as a covenant

Related course:

Best Practice Project Finance Modelling

Modelling portfolios: What are the options and how to choose between them

As developers and investors in infrastructure projects start to grow their portfolio, it is a common step to develop one or more financial models to forecast the performance of their assets. In this webinar, Mazars’ experts Tom Brichieri-Colombi and John Yeldham share their experience of developing these tools for effective portfolio management. Learning outcomes:

Recap on how an operational model differs from a financial close model
Gain insights into the options for structuring portfolio models, and how this might change over time
Learn how to balance accuracy and usability of your tools
Understand the role of model audit in ensuring your tools are in good shape

Related course:

Project Finance modelling: DSRA (Debt Service Reserve Account)

Many projects in the energy and infrastructure sectors, and project finance more generally, have a Debt Service Reserve Account (“DSRA”) included as part of the financing package. Being confident about the commercial rationale of the DSRA, and associated financial modelling techniques, is an essential component for financial modelling, developers and credit analysts in the sector. This webinar focuses on the DSRA from a financial modelling perspective, while covering the commercial aspects required to fully understand that purposed of the account. We also explore the Debt Service Reserve Facility (DSRF) and how this differs from the account.

Related course:

Advanced Project Finance Modelling

Project Finance modelling: Project Returns vs Equity Returns

For informed investment and credit decision for real assets in infrastructure and energy, it is critical to have a full understanding of the financial returns. This free webinar outlines the concepts of ‘project returns’ and ‘equity returns’, and demonstrates in detail the required calculations. Learning objectives:

Understand the definition of ‘project return’ and ‘equity return’ in a project finance or real asset context
Review the typical modules covering the financial returns of a financial model
Learn how to use the Excel functions IRR, XIRR, NPV and XNPV and how they relate to first principles
Illustrate the analysis with scenario analysis demonstrating the financial return sensitivity on both project returns (and how this changes with debt leverage)

Related courses:

“If you are serious about your modelling, then the Mazars Financial Modelling webinar series and tutorial archives page should be on your favourites list”
Daniel Brooks, Manager, Mazars

The first three webinars scheduled for 2022 include the following topics:

Shareholder loans
Valuation trends – market vs. theoretical pricing flaws
How to Review a Spreadsheet: Spotting errors with Sparklines

Stay in the loop on our upcoming webinars by clicking on Register for Updates at https://financialmodelling.mazars.com/

Mazars Financial Modelling?

Mazars

Resources

Training Courses

Clients