Financial Modelling for Renewable Energy Projects will give you the skills to efficiently develop, modify and analyse financial models in the renewable energy sector. The course covers essential topics including funding mechanics, operational analysis and investment metrics and gives you a robust platform for analysis in the most sophisticated environments.
You will learn the financial modelling techniques needed to build a best practice financial model suitable for debt structuring, investment analysis and operational scenario evaluation.
Perform project finance banking analysis, investment reviews or sponsor research
This hands-on course will clarify how project finance bankers, investors and external parties will analyse your project, and provide a deep understanding of the flexibility required in scenario analysis by a range of audiences.
Financial Modelling for Renewable Energy Projects will enable you to
Master best practice techniques for financial modelling of renewable energy projects to achieve flexibility and robustness
Build a flexible and powerful scenario manager to analyse your project’s sensitivity to key drivers
Prepare trusted analysis of commercial outputs tailored to investors and financiers, with a focus on valuation and risk
Understand a flexible framework for tax modelling, adaptable to regional jurisdictions
Develop flexible funding structures for analysis of project finance debt and other funding sources
Learn how to analyse GP/LP flip structures and tax equity for project financing
Do you build or analyse project finance models in the renewable energy sector?
If you need to build, review or analyse project finance models in the renewable energy sector, then this course is for you. Typical attendees include analysts, financial managers from project companies, advisors and financiers.
Required knowledge: Excel, Finance and the Renewables sector
It is expected that you have some previous experience with financial models in Excel, and foundation knowledge of investment concepts such as NPV and cash flows analysis.
Extend your understanding of project finance theory
To learn more about project finance theory, we recommend ‘Project finance: Concepts & Applications’ course. This one-day project finance training course covers topics from ‘What is project finance’ to examples of typical transaction structures, risk mitigation approaches and market examples.
Would a project finance modelling course be more interesting for you?
What is financial modelling and how can you learn more?
For a deeper understanding of Mazars approach to financial modelling and the Mazars Financial Modelling methodology (our globally acclaimed financial modelling methodology), we recommend reviewing and downloading some of our financial modelling tutorials from the Online Resources section of our website. Many of the free examples are inspired by content from our training courses in financial modelling and project finance, and from valuation modelling and theory.
Discuss the high-level HLBV concepts with tax equity (note: this is not an accounting course!).
Learn the skills required to develop a comprehensive financial model
Renewable energy projects often require significant financial analysis, and this hands-on financial modelling training course gives you the skills and confidence require to develop a comprehensive financial model for planning, investments and financing analysis. Focused on the US market, participants will gain a solid understanding of the common structures deployed.
Develop a strong understanding of typical financial structures, financial model architecture and process in the renewable energy sector, to ensure the big picture is always in mind:
Understand how to envision a financial modelling process from beginning to end
Recognise the process similarities in modelling for wind, solar or hydro projects and learn which modules can be standardised across energy sources
Gain insights into a typical financial model development process – step-by-step – for a renewable energy model
Benefit from a flexible timing framework to underpin the model architecture – an essential feature for projects where the dates / timings may change over time (which includes 99% of all projects)
Capture the structures deployed in the US including industry metrics, back-leverage, typical capital stacks and returns and the corporate structure with tax equity, partnership structures.
Representing the construction phase of a renewable energy project
Representing the construction phase of a renewable energy project in the Excel model:
Discuss funding alternatives for renewable energy projects (bank debt, equity, tax equity, capital markets, government supported structures, export agencies) and how this impacts the financial modelling process
Incorporate flexible functionality for funding
Integrate typical renewable energy construction contacts and contingencies
Modelling of pricing and purchase agreements
Modelling of pricing and purchase agreements in renewable energy:
Learn about off-take, prepaid and power purchase agreements (PPA) and renewable energy certificates (RECs) and the implication of these on funding
Integrate both PPA and merchant pricing into the operational calculations
Expand PPA analysis by having variable pricing structures, milestones, and penalties
Forecasting and modelling of production metrics
Understand application of different forecasting methods, the appropriate allocation of each
Learn to integrate multiple probability exceedance profiles concurrently (e.g., P50, P90
Convert gross production to net production by accounting for: Operational ramp up schedules, impact of production unit (e.g. turbines) availability and efficiency, and gains and losses of production such as seasonality of renewable energy.
Incentives in US renewable energy projects
Learn about renewable energy certificates (RECs) and their impact on funding projects
Discuss the typical types of local and state incentives available
Calculate the investment tac credit (ITC) and production tax credit (PTC) and apply them to equity and tax equity as per the partnership agreement
Financial modelling techniques for operational costs and project maintenance
Integrate fixed and variable costs typical of renewable energy projects
Learn how to model flexible volume driver controls for variable costs
Understand the important role of real vs. nominal costs (escalation) and how to integrate powerful indices
Review of leasing structures and application of in renewable energy projects
Discuss different reserve account structures (i.e. maintenance)
Incorporate the functionality of target Debt Service Coverage Ratio repayments
Discuss other repayment options including bullets and linear commonly used in project finance
Incorporate various debt sizing methodologies
Review depreciation and tax calculations
Flexible depreciation calculations for an efficient financial model structure
Understand how to develop flexible input structures for analysis of multiple depreciation methods
Correct taxable income for tax calculations and discuss the impact pre and post-flip as well as the difference at projectco and holdco level
Tax creditor accounts for correct assignation of tax payable and paid on a self-sheltering basis
Understand the working of tax loss accounts with self-sheltering and the differences for tax equity investors
Financial return analysis: Project Return – essential financial model output
Inclusion of best practice net present value (NPV) and internal rate of return (IRR) calculations for the renewable energy project both pre and post-flip
Discussion about key differences between XPNV vs. NPV functions
Calculate returns at projectco and holdco to equity and tax equity participants
Master Scenario Management with an efficient financial model structure
Work faster, better and with more insights using the Mazars Scenario Management solutions
Use commercial scenario analysis to assess the working of the financial model, and to sense check your logic and calculations
Build confidence in your analysis through pre-programmed combinations of model inputs
Optimize your project
Understand the tools available to optimize the project returns and debt size
Calculate indicative tac equity size based on partnership structure
Some of these cookies are necessary, while others help us analyse our traffic, serve advertising and deliver customised experiences for you. For more information on the cookies we use, please refer to our Privacy Policy
This website cannot function properly without these cookies.
Analytical cookies help us enhance our website by collecting information on its usage.
We use marketing cookies to increase the relevancy of our advertising campaigns.
Follow us
Corality is dedicated to exceptional financial modelling. As part of our commitment to raising the bar in financial modelling, we want to ensure the financial modelling community is kept up to date with the latest events, tips, techniques and training.
By registering for email updates from Corality you will be kept up to date about: