Learning Resources
Financial Modelling Webinars
Technical sessions run by our modelling and model audit teams, covering the calculations and review techniques we use in practice. Recordings and upcoming live events.
See our trainingAll resources- FreeEvery session, at no charge
- Worked examplesBuilt live in Excel,
not slideware - Practitioner-ledRun by our model
auditors and trainers - Live or recordedJoin a live event or
watch on demand
Upcoming live webinars
Join the next session live
Live sessions include the discussion and the questions the recording never carries. Registration is free.
LIVE EVENT
AI Can Build the Model. Can You Review It?
Drawing on a recent experiment in which multiple AI tools were asked to modify a project finance model, this webinar explores what AI does...
LIVE EVENT
Q3 2026 update and the use of Free Cashflow to Firm vs Free Cashflow to Equity within Infrastructure Valuation
Live webinar Q3 2026 update and the use of Free Cashflow to Firm vs Free Cashflow to Equity within Infrastructure Valuation A quarterly valuation...
All webinars
The recording library
Popular sessions come first, then the rest newest to oldest. Live events are marked; everything else is available to watch on demand.
| Webinar |
|---|
| PopularIs prompting Excel the wrong skill to teach your team?Most AI training for modelling teams focuses on writing better prompts. This session takes a different view: a live, side-by-side comparison of freeform prompting against a... |
| PopularModelling construction delay in renewable projectsThis webinar takes participants through the mechanics of building a flexible delay timing infrastructure into a project finance model, with a particular focus on how Interest... |
| PopularHow AI is used in project finance modellingOver recent months, the market has seen a rapid acceleration in the development of AI-driven tools for Excel and financial modelling. The underlying technology is advancing... |
| PopularBESS financial models: approaches and common errorsIn this webinar, we will explore various modelling approaches, discussing their advantages, limitations, and best practices. Additionally, we will highlight common errors encountered in BESS financial... |
| PopularDebt sizing for contracted and uncontracted revenueDebt sizing for renewable energy transactions requires a full understanding of how banks analyse contracted and uncontracted revenue streams. This webinar explains how to use the... |
| PopularFinancial modelling for IFRS 16 leasesIFRS 16 Leases has changed the way we look at financial statements forever. Lease costs which once sat above EBITDA now fall into depreciation expense while... |
| Q3 2026 update and the use of Free Cashflow to Firm vs Free Cashflow to Equity within Infrastructure ValuationLive webinar Q3 2026 update and the use of Free Cashflow to Firm vs Free Cashflow to Equity within Infrastructure Valuation A quarterly valuation update on... |
| AI Can Build the Model. Can You Review It? Drawing on a recent experiment in which multiple AI tools were asked to modify a project finance model, this webinar explores what AI does well, where... |
| Sum of the parts as a valuation methodOur Q2 2026 quarterly valuation webinar will provide a general update on the latest trends observed in the valuation of energy and infrastructure assets. |
| From transaction model to operations modelCongratulations on reaching financial close. However, now is the time to shift your focus. The model that got you through the deal may not be fit... |
| Infrastructure valuation in times of uncertaintyOur Q1 2026 quarterly valuation webinar will provide a general update on the latest trends observed in the valuation of energy and infrastructure assets. For this... |
| Discounted cash flow in financial modelsEnhance your expertise in project valuation using the discounted cash flow (DCF) method, drawing on project finance examples to illustrate the XNPV approach in Excel. The... |
| Interpreting returns in project finance modelsJoin us for an insightful webinar focused on how returns are interpreted within project finance models, with particular emphasis on the distinction between Project Returns and... |
| Terminal value in infrastructure valuationsOur start of 2026 quarterly valuation webinar will provide a general update on the latest trends seen in the valuation of energy and infrastructure assets. For... |
| Depreciation pitfalls in financial modelsDepreciation may seem like a simple accounting concept, but in project finance it can make or break the accuracy of your model. In this session, we’ll... |
| Modelling the DSRA and MRA in project financeEver wondered why lenders insist on reserve accounts like DSRA and MRA in project finance deals? In the realm of energy and infrastructure finance, reserve accounts... |
| Valuing battery storage in the new energy systemIn the context of a wide array of revenue strategies and volatility of forecast curves, how can investors and valuers get comfortable with forecast cashflows and... |
| Spotting financial fraud in M&A transactionsIn today's complex financial landscape, fraud can hide in plain sight – even after annual audits. This upcoming webinar explores how financial irregularities slip through the... |
| Trends, risks and strategies in data centre investmentThe rise of AI, cloud computing, and global data demand is accelerating investment in one of the most vital - and complex - asset classes: data... |
| Energy and infrastructure valuation: political riskAgainst a backdrop of increasing political uncertainty globally, how do markets consider generalised, national political, policy or regulatory risk? And what, if any, attempts can or... |
| What FIT to FIP conversion means for financial modelsIn recent years the prevalence of Feed-in-Premium (FIP) revenues in Japanese renewable energy projects has diminished, yet we see more and more legacy Feed-in-Tariff (FIT) projects... |
| Break-even analysis in mining project modelsThis session explores how break-even analysis enhances financial modelling for mining ventures by identifying the minimum operational and financial thresholds required for project viability. This approach supports... |
| Interest deductibility errors in financial modelsInterest deductibility (in respect to tax) is a complicated and often material aspect of financial modelling. This webinar will outline the theory, recommend best practices and... |
| Working capital modelling techniquesEffective working capital management is essential for maintaining liquidity, optimizing cash flow, and ensuring the financial health of a business. In this webinar, we will explore... |
| Developing a renewable energy portfolio modelBuilding on our initial webinar "Modelling portfolios: What are the options and how to choose between them", this session focuses on applying those concepts to renewable... |
| Tax and finance clauses in SPA negotiationsNegotiating appropriate tax and finance clauses in transaction documentation is crucial to maximise value, mitigate risks identified in the due diligence process and avoid post-closing disputes.... |
| Energy and infrastructure valuation: global tariffsOur regular quarterly valuation webinar will provide an update on the latest valuation trends in the energy and infrastructure market. For this quarter, presenters Charlie Williams... |
| Financial model review pitfalls and how to avoid themThis webinar explores the critical role of model reviews in ensuring accuracy, reliability, and effectiveness in financial models. |
| Closing mechanisms in M&A transactionsIn the intricate world of Mergers and Acquisitions (M&A), each transaction reflects the unique strategic objectives and challenges faced by the entities involved. The complexity of... |
| Reviewing credit agreements against the modelDo you feel overwhelmed by the extensive credit agreements? As an analyst, you’re at the heart of the credit approval process, ensuring that a loan is... |
| CCUS: revenue, risks and evaluationJoin us for an engaging webinar that delves into the key financial and technical aspects of Carbon Capture, Utilization, and Storage (CCUS). This session will cover... |
| Complexities and traps in Asian financial due diligenceOur partners from India, Korea and China share their expertise in navigating local and cross-border transactions. Gain insights into recent trends, best practices, key risk areas,... |
| Co-located BESS and long-duration energy storageThis webinar will focus on the role of long-duration and co-located battery storage in the development of the UK’s renewable energy system. Participants will gain a... |
| Integrity checks in financial modelsFinancial models are invaluable tools for forecasting, evaluating, and analysing investments and operations. However, even the best tools can be prone to errors. Join our financial... |
| Transaction multiples in infrastructure valuationDiscounted cashflow (DCF) analysis is the dominant approach used across energy and infrastructure valuations. But when should transaction multiple analysis also be used and how do... |
| Tax on asset and share deals in Asia PacificThis webinar will explore critical tax aspects of asset and share deals, offering insights into the latest trends, tax regulations, and strategic considerations. Participants will gain... |
| APAC deals: holding company structures and taxThis webinar will explore critical aspects of holding companies in a Deals context, offering insights into the latest trends, tax regulations, and strategic considerations. Participants will... |
| Bankability and modelling of BESS projectsWelcome to our follow-up webinar, building on the success of our first session “BESS financial models – modelling approaches and common errors.” In this continuation, we... |
| LLCR and PLCR calculations and their common errorsJoin our upcoming webinar as we delve into the intricacies of LLCR and PLCR calculations — two critical yet often misunderstood and miscalculated financial ratios in... |
| Valuing assets near the end of their lifeIn the Q3 2024 Forvis Mazars Energy & Infrastructure quarterly valuation update we will provide a snapshot of, and our views on, some of the main... |
| Direct power purchase agreements in VietnamWith recent developments in Vietnam with the adoption of Direct Power Purchase Agreements (DPPA), understanding the financial and regulatory intricacies is essential for stakeholders. Drawing on... |
| Tips and tricks to work smarter in ExcelFor anyone working extensively with financial models in Excel, it is important to continuously improve the speed of work, while increasing the quality of outputs. Sometimes... |
| Energy and infrastructure valuation: NPV calculationsIn the Q2 2024 Forvis Mazars Energy & Infrastructure quarterly valuation update we will provide a snapshot of, and our views on, some of the main... |
| Purchase price allocation in M&AGain insights from our industry experts, guiding you through the essential steps of PPA, from the initial assessment to the finalisation of the calculated goodwill. |
| Preparing for a successful sell‑side M&A processPlanning a business sale, carve-out, or related sell-side processes requires careful planning – before opening the door to buyers – to ensure a streamlined process and... |
| Project finance ratios from contract to modelUnderstanding how project finance contracts translate into the financial model can be difficult, particularly when interpreting definitions and the application of calculations. Financial ratios are an... |
| Operational models after financial closeIn the world of project finance, financial models are at the centre of getting deals done. Once the transaction is complete, an updated "operational model" is... |
| M&A preliminary due diligence and the non-binding offerThis webinar offers an overview into the intricate world of mergers and acquisitions (M&A), tailored specifically for participants engaging in preliminary assessments leading to Non-Binding Offer... |
| Key areas of model error: IFRIC 12This quarter we will provide a snapshot of some of the main publicly available debt and equity valuation trends across the energy and infrastructure sector. Gain... |
| Managing circular references in financial modelsA common challenge faced by financial modellers is how to deal with circular references in their models. Common across both the project finance and corporate finance... |
| Energy and infrastructure valuation: platform investmentsThis quarter we will provide a snapshot of some of the main publicly available debt and equity valuation trends across the energy and infrastructure sector. Gain... |
| Principles of valuation and financial modellingThis webinar provides an introduction to Valuations and its importance in financial decision-making. It will cover different valuation approaches, key factors influencing valuation, main valuation components... |
| Indexed debt: how to model itThis webinar will discuss the best practise financial modelling techniques for indexed debt instruments. We will discuss indexed linked bonds & senior debt and guide you... |
| End of life for energy projects in CEERecently, we had the pleasure, along with our partners from Bird&Bird, to conduct a webinar on Dealing with the end of life of an Energy project... |
| Country risk in energy and infrastructure valuationsJoin Julian Macmillan, Director, Mazars - Energy, Infrastructure & Environment, as he discusses what country risk premium (CRP) represents, how it is applied, what risks does... |
| Procuring model audit, due diligence and tax servicesAre you an infrastructure and energy professional looking to enhance the value you receive from your due diligence advisors? Join our upcoming webinar to unlock key... |
| Navigating Canadian Clean Energy Investment Tax Credits – An Update on Legislative Details and Labour RequirementsThis webinar will take a look at the Canadian Clean Energy Investment tax credits. Join us as we explore the draft legislation for the clean investment... |
| US projects under the Inflation Reduction ActThis webinar will dive into the dynamic landscape of projects aimed at mitigating inflation's impact, discussing the most recent developments and the hurdles they face. Join... |
| How debt affects equity valuations in infrastructureThis quarter we have included a spotlight on how debt impacts on equity valuations in the sector. Although traditional valuation theory links higher debt to more... |
| Modelling data centre contracts, churn and PUEThis webinar highlights our recommended approach to capturing revenue contracts in a financial model for a data centres, while also providing insights into different approaches around... |
| Reviewing DSCR, LLCR and PLCR by re‑performanceThis webinar will explain how our world-leading model audit team provides assurance to lenders and investors on key financial ratios with respect to some of the... |
| How ESG now affects asset valuationsCost of debt has settled in a new range, and asset owners are having to adapt to this. Long-dated gilt yields indicated a relatively stable trend... |
| Integrated financial statements in project financeThis webinar will provide a comprehensive overview of financial statements and their role in project finance models. You'll learn how to effectively create and analyse financial... |
| Working capital and the average balance approachWorking capital is often overlooked, but it can have a large effect on project cash flows, so any thorough analysis needs it. Modelling it accurately avoids... |
| Sculpted debt service with the DSCR and CFADSRepayments that follow the cash flow Sculpted debt service is an important repayment method to build into a financial model, particularly where cash flows are seasonal... |
| Avoiding modelling errors in solar and wind projectsDevelopment, financial structuring and investments in solar and wind projects require robust financial models for analysis of base case and scenarios. To assist you in ensuring... |
| Financial modelling of stockpiles in a mining projectThis webinar covers an approach to modelling stockpiles in mining projects, using a gold mine as an example. The methodology can be translated into any other... |
| NPV in Excel: functions and first principlesNet Present Value (NPV) is a standard method of capturing the time value of money to appraise long-term projects and investments. This webinar will focus on... |
| How to review a spreadsheet: tools within ExcelThis webinar will provide an overview of the best features native to Excel that we recommend to use when reviewing spreadsheets. We will look at the... |
| Managing project handbacks in PPP and PFIIn this webinar, we discuss the specific stage of the contract lifecycle, when these types of contracts are approaching expiry and an orderly transition to a... |
| Automated self-checks in financial modelsAutomated checks make a financial model more accurate, easier to build and easier to review, and the benefit lasts long after the model is finished. This... |
| Reviewing a spreadsheet with parallel computationIn this webinar, we will explain the basis of why we believe parallel computation to be the single best end-to-end methodology to identify errors in spreadsheets. |
| Estimating the terminal valueThis one hour webinar will guide you through the high level concepts of terminal value explaining what it represents and how it should be considered in... |
| Use LOOKUP to replace VLOOKUP and HLOOKUPIf you are interested in learning the most efficient way of looking up data from a table, you may enjoy this webinar. |
| How model builders and model auditors work togetherIn the world of transactions and investment, the financial model audit is a key piece of due diligence in the transaction process and often requires a... |
| The cash flow waterfall in project finance modelsThe cash flow waterfall is a central part of any project finance, infrastructure finance or real asset model. It shows every stakeholder the cash available at... |
| Market and theoretical approaches to discount ratesThis quarterly valuation update, recorded in early 2022, covers debt and equity trends in energy and infrastructure, then compares the theoretical and market approaches to discount... |
| Shareholder loans in project finance modelsDebt that works as equity Shareholder loans are a common feature of project finance deals and can be an efficient way to fund a project, so... |
| Reviewing a spreadsheet with sparklinesIn this webinar we will consider different ways in which Sparklines can be used to help review spreadsheets as well as some “real life” examples. |
| Project returns and equity returns in project financeFor 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... |
| Modelling the debt service reserve account (DSRA)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... |
| Structuring portfolio models for infrastructure assetsAs 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... |
| Debt service coverage ratio (DSCR) in financial modelsThe 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... |
| Renewable energy asset valuation trends in 2021This webinar was recorded in November 2021, while COP26 was under way and the energy transition was at the top of the public agenda. Funding and... |
| Restructuring PFI and PPP projects successfullyIn recent years, the market has seen an increasing number of high-profile defaults of Private Finance Initiatives (PFI) and Public-Private Partnerships (PPP) – and the risk... |
| Loan life coverage ratio (LLCR) in project financeIn this free financial modelling focused webinar on the topic of LLCR (Loan Life Coverage Ratio). Over 60 minutes, we will cover the definition, the application... |
| Self‑review techniques for financial modelsBen Kwan and Nidhi Kapania demonstrate a number techniques to help a modeller effectively self-review their own financial model in order to minimise errors. |
| Dealing with Delay (in Spanish)Mientras que nos encontramos en una situación sin precedentes e inmersos en una crisis global a diversos niveles, para los profesionales financieros, es mucha la importancia... |
| How to start a career in financial modellingThis webinar provides guidance on how to start a career focused on the field of financial modelling. Rickard Wärnelid explains the right approach to learning available... |
| Private debt market trends since Covid-19In this webinar Ben Morris shares his market observations on pricing and other trends in the private debt space since the onset of the Covid-19 pandemic.... |
| Waterfall and tornado charts in ExcelThis webinar explores how to create powerful analysis through Tornado and Waterfall charts to critically assess scenarios within your models. It demonstrates when these charts are... |
| Considerations in the financial modelling of taxes in the renewable energy sector in Colombia (In Spanish)Para aquellos que trabajan en el sector energético en el mercado colombiano, tener un correcto conocimiento de las regulaciones y actualizaciones fiscales es clave para un buen... |
| Sensitivity analysis of a financial model that you didn’t build yourself (in Spanish)For anyone working in credit analysis, project finance or with investments, performing scenario and sensitivity analysis of a third party financial model is part of your... |
| Dealing with delayAs we all move into tricker times, the ability for financial models to be able to forecast realistic downsides becomes important. We can expect delays, loss... |
| Cyber security threats to critical infrastructureJoin Nicolas Guerin for this free webinar on 'Critical Infrastructure: Cyber-security threats + how to fix them. |
| Operational models for asset managementAjit Chandra demonstrates the functionality to achieve this, discuss the different approaches to incorporate Historical Financial Statements (‘Actuals’) and showcase key challenges faced by the SPV... |
| Excel Blackbelt: Calculations with an eye on the future: 2D blocks and when to use themAs the world moves towards viewing everything as data and interfaces between systems become more and more prevalent, it is important to think about what structures... |
| Excel Blackbelt: New versions of old functionsThe function library of Excel keeps developing, and it can be challenging to stay on top of which changes are relevant in your particular situation. Learning... |
| Delta sheets for analysing financial modelsIn this webinar, Mazars’ financial modelling Partners Tom Brichieri-Colombi and Jerome Brice will provide insight into how to utilise the powerful analytical technique of Delta Sheets... |
| Use sparklines in your financial modelsEver since Edward Tufte formalised the concept of Sparklines as 'data-intense, design-simple, word-sized graphics', the inclusion of Sparklines in Financial Models has been much debated and... |
| Sensitivity tables for infrastructure project analysisUsing powerful Excel techniques, sensitivity and scenario tables can be used to prepare credit and investment submissions, but also to interrogate the robustness of a financial... |
| What lenders need from a mining project modelWhen communicating the financial viability of a mining project with project finance banks and investors the requirements on the financial model are drastically different to economic... |
| Top 10 errors in financial models (and how to fix them)This webinar aims to highlight the areas of a financial model where we typically find a higher risk of error. We will highlight these areas with... |
| Developing your next real estate finance modelIn a world where many real estate or property projects require analysis and functionality which exceeds what is offered in traditional templates and software, many organisations... |
| Transaction due diligence on a vendor modelUsing the financial model for an upcoming transaction, the due diligence process can provide deeper insight of the risks and rewards of the deal. |
| Financial modelling from bid to operationsFollowing a successful financial transaction (project finance, bid, M&A, re-financing, etc), it is regarded best-practice to convert the Transaction Model to an Operations Model. |
| Mastering timing flags in an Excel financial modelAlmost all financial models have critical functionality linked to specific timing events. These frequently include Financial Close date (project finance), Transaction date (M&A), Construction start (greenfield... |
| Sensitivity analysis of a model you didn’t buildFor anyone working in credit analysis, project finance or with investments, performing scenario and sensitivity analysis of a third party financial model is part of your... |
| Financial model integrity: lessons from model auditAchieving accurate forecasting in your financial models is essential to provide confidence for investment decisions, strategic option evaluation and project finance processes. |
| Modelling HoldCo portfolio debt in renewable energyTo support the growing trend of introducing holdco / portfolio level debt structures in the renewable energy sector, our next webinar shares our experience financial modelling... |
| Modelling a cash sweep in infrastructure financeTo fully master the Infrastructure sector, it is essential to have a clear grasp on the concept of ‘Cash Sweep’. By understanding the rationale of this... |
More resources
Keep going
See all tutorials and blogs and articles, or return to the resources hub.
Learn this properly
These are drawn from what we teach. The courses cover the whole methodology, with a trainer beside you through every exercise.
Browse coursesSend enquiry