Learning Resources
Financial Modelling Blogs & Articles
Longer-form writing on modelling practice, Excel developments, sector reflections and industry news, including our published research on where AI helps in financial modelling and where it fails.
See our trainingAll resources- FreeEvery article, at no charge
- ResearchIncluding our published
AI benchmark study - Practitioner-ledWritten by our model
auditors and trainers - Sector-awareEnergy, infrastructure
and natural resources
All articles
Where modelling practice is heading
Popular articles come first, then the rest newest to oldest. Reflections from the work, sector commentary and published research where we have tested a claim ourselves.
| Article |
|---|
| PopularCan Claude replace a model audit?We Hid 44 Errors in a Financial Model to Find Out. The short answer No, not on this evidence. The strongest configuration we tested, Claude working... |
| PopularGovernance sets the pace for AI in financial modellingDiscover insights from the IPFA report on AI in financial modelling and how it affects project finance and infrastructure. |
| PopularWorking capital in financial modelsWorking capital is one of those areas of a financial model that looks simple on the surface but causes a disproportionate number of errors. The Forvis... |
| PopularNPV, IRR and common return errors in project financeReturns are the main output investors, lenders and sponsors look at when they decide whether to invest in a project, divest from a portfolio or refinance... |
| PopularTop 10 ways to fix an unbalanced balance sheetFinancial statements are a series of double entries. When we are setting up our Financial Statements, we must make sure we bring in both sides of... |
| Observations on AI in financial modellingAI is being described as the biggest economic shift since the industrial revolution. Yet when you look closely at how financial institutions, investment managers and advisors... |
| Investing in data centres: trends, risks and strategiesThis article summarises the Forvis Mazars webinar Investing in Data Centers, hosted with Aurora Energy Research. Neethu Ram moderated, with panellists Anton Yunussov (Cybersecurity Practice Lead,... |
| Depreciation methods, tax and common modelling errorsThis article summarises our webinar Mastering depreciation and avoiding modelling pitfalls, presented by Leigh Tomlinson and Keshav Rana of our EMEA financial modelling training team. Depreciation... |
| AI and project finance models: an industry updateArtificial intelligence is no longer a fringe topic in project finance. Over recent months the market has seen a rapid acceleration in the development of AI-driven... |
| Financial Modelling Services in SingaporeFinancial modelling, model audit, training and advisory across infrastructure, energy and project finance. Delivered by our team in Singapore and across Southeast Asia. Singapore is a... |
| Global Model Auditor of the Year at the IJGlobal AwardsWe are proud to announce that Forvis Mazars has been awarded Global Model Auditor of the Year at the IJGlobal Awards 2025. |
| Our AI in project finance webinar and courseTo help practitioners understand and apply AI in a practical disciplined way Forvis Mazars APAC Energy has launched two complementary initiatives the AI in Project Finance... |
| Sydney Financial Modelling: Project Finance, Energy and InfrastructureAustralia's energy transition is reshaping capital flows across the country. From large-scale solar and wind farms backed by ARENA and CEFC funding, to utility-scale battery storage... |
| Top 5 most downloaded financial modelling tutorialsExplore our Top 5 financial modelling tutorials — clear, practical walkthroughs of key project finance concepts like CFADS, DSCR, LLCR and cash flow waterfalls. Each tutorial... |
| How to use the Copilot function in ExcelWhat is the Excel Copilot function? The Excel Copilot function is an AI formula in Microsoft 365. You type a prompt in plain language into a... |
| Summary of the EMIS ASEAN M&A outlook webinarThis article summarises an ASEAN M&A Trends 2025 webinar run by EMIS Insights. Advisors and market analysts discussed deal volume and value, the sectors drawing investment,... |
| Why you need an operational model, and how to build oneIn project finance, the model used to close the deal is rarely the one that guides the project through its operating life. After financial close, the... |
| Developing portfolio models for consolidation insightsAs energy and infrastructure portfolios grow in scale and complexity, the financial models behind them need to keep pace. To address this, Forvis Mazars held in-person... |
| Circular references in project finance modelsIn a recent webinar hosted by Forvis Mazars, financial modellers were given an in-depth look at managing circular references in financial models. The session, led by... |
| London Infrastructure and Energy Financial Modelling ServicesInfrastructure and energy finance runs deep in London, from the lenders and advisors who structure global transactions to the secondary market that trades them. The city... |
| Financial modelling for battery energy storage systemsBattery Energy Storage Systems (BESS) are revolutionizing the energy sector by providing efficient and reliable solutions for storing and managing electricity. In our webinar on 23rd... |
| Ten of our most watched financial modelling webinarsIn the fast-paced world of financial modelling, staying ahead of industry trends, mastering best practices, and avoiding common pitfalls can make all the difference. Whether you're... |
| Why ethical principles matter in model auditFor major energy and infrastructure transactions, the financing documents often require the model auditor to be an accountancy firm of sufficient standing. When it matters most,... |
| The rise and rise of lithiumWhat is not to like about the lithium success story for the production of batteries to power electric vehicles (EVs). |
| Financial modelling courses in Perth – 2022 schedule updateFinancial Modelling courses in Perth - 2022 Mazars Financial Modelling digital and in-person course update |
| Our sessions at the Global Excel SummitFrom our archiveWe gave these sessions at the Global Excel Summit in February 2022, as Mazars. For our more recent work on model review, watch Financial... |
| A course for people who review financial modelsAn effective financial model review can ensure that decisions are made with an understanding of evidence with risk and help to ensure integrity of the outputs.... |
| Sustainable finance policy tracker with OMFIFFor many professionals working in financial modelling for energy and infrastructure, the topic of Sustainable Finance is a topic of clear interest. Sustainable finance reaches well... |
| Use VBA to extract the currency from a number formatUse VBA to extract the Currency from an Excel Custom Format, as it's not possible with Excel functions |
| How to speed up your models: Part 3This article is Part 3 in the series “How to speed up your models”; Part 1 and Part 2 are available on the Mazars Financial Modelling... |
| Your financial model described as a cityFollowing an initial review of a client’s financial model our team often has a conversation on the topic “what do you think of the model?” A... |
| Mazars Infrastructure & Energy team- #1 Model Auditors!Being ranked #1 for the third consecutive year (by Inframationnews) is a great achievement and testament to the hard work and dedication of the Infrastructure &... |
| On the WaterThere is no question that the U.S. water infrastructure needs repair. The unprecedented flooding and droughts across the country over the past 15 years and the... |
| Subsidy-free renewables: have we reached the tipping point?In July, Mazars and Eversheds Sutherland jointly hosted a panel event attended by nearly 100 industry participants focusing on the viability of subsidy-free renewables in the... |
| Mazars expands its Canadian presence with new Toronto office and launch of the Infrastructure Finance business unitWe are pleased to announce the opening of our new office in Toronto and the launch of our Infrastructure Finance business unit. |
| 2018 Financial modelling resolutionsFor better financial modelling in 2018, here is your Top 10 New Year’s Resolution list ready to print and pin up by your desk. I will... |
| Debt sizing and debt sculpting in project financeThe modelling of debt facilities is at the heart of every project finance transaction. The term sheet sets out the basic terms and conditions, but senior... |
More resources
Keep going
See all tutorials and webinars, 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