Advanced Renewable Energy Financial Modeling

Learn how to build an integrated project finance model for renewable energy investments from scratch.

4.66 (578 reviews)
Udemy
platform
English
language
Financial Modeling & Ana
category
Advanced Renewable Energy Financial Modeling
2,960
students
15 hours
content
Jan 2024
last update
$174.99
regular price

What you will learn

Build a fully integrated 3-statement project finance model for renewable energy investments

Model sculpted debt financing structures and learn how to break common circularities with macros using VBA

Learn diverse valuation approaches for renewable energy projects

Model different PPA offtake structures with different hedging ratios

Learn how to value projects from a developer's or investor's perspective

Implement P50, P75, and P90 energy yields and dynamically adjust to any other P-value

Understand contractual relations within a project finance deal

Build an investment dashboard with dynamic charts and key industry KPIs which support investment decision-making

Description

This course is part of a larger educational framework available at Renewables Valuation Institute (RVI). Explore the Renewables Valuation Analyst (RVA) Program for a comprehensive learning experience. Find the website link by clicking on the instructor's profile!


Are you working in finance, or do you want to start your career in the infrastructure investments sector?

Kickstart your career and learn how to build a project finance model with the highest industry standards.


Advanced financial modeling for renewable energy investments

This 15-hour online course will guide you through building a fully integrated project finance model step-by-step from scratch in Microsoft Excel - with particular attention to renewable energy requirements and market best practices.


Renewable energy project case study

Learn how it's done in the real market. This 100% online video course is based on a real-world case study. A typical information memorandum (IM) offers all information needed to build a project finance model. The course instructor will guide you through building the project finance model based on an IM which covers all essential information required to value any renewables project.


Already have modeling experience?

Great! You will certainly be able to enhance your knowledge by taking this course. This course is made for professionals within the renewable energy sector or those pursuing to enter the industry and wishing to get up to speed when it comes to financial modeling for renewables investments.


Did you ever wonder how to model energy-related investment specifics?

Learn how to model:

  • PPA offtake structures considering adjustable energetic hedging ratios

  • Macros which can break any circularity commonly observable within project finance models

  • Different investment scenarios using various sensitivities

  • Availabilities & degradation which change over specific periods

  • Seasonality of energy production

  • P50, P75, P90, or any other P-Value considering various production uncertainties

  • Different construction periods considering flexibly adjustable capital calls

  • Energy-related operational expenditures such as O&M, TMA, CMA, route to market, insurance, land lease, and other costs

  • Major Maintenance Reserve Account (MMRA)

  • Decommissioning Reserve Account (DRA)

  • Different tax structures easily adjustable for various jurisdictions

  • Interest barriers and tax-optimizing shareholder loan structures


Enroll now and learn how financial modeling is done in the real market at your own pace.

Content

Setting up the Model Framework

Course Introduction
Final Model - Dashboard
Introduction to Start File
Technical Inputs
Scenario Selection
Shortcuts Quiz #1
General Inputs
Shortcuts Quiz #2
Timing Sheet
Model Timeline
Macroeconomics
Shortcuts Quiz #3

Building a Project Finance Model

Project Finance - Contractual Relations
Information Memorandum
Uses of Funds
Sources of Funds
Shortcuts Quiz #4
Creating Checks
Checks Sheet
Depreciation Categories
Power Generation Inputs
Availability, Degradation & Seasonality
Net Power Generation
PPA & Merchant Inputs
Generation Allocation (PPA vs Merchant)
PPA & Merchant Revenue
Operational Expenditure Inputs
Operational Expenditures
MMRA Inputs
Major Maintenance Reserve Account
Decommissioning Reserve Account Inputs
Decommissioning Reserve Account
SPV Cash Reserve
Working Capital Adjustments
Accounting & Tax Depreciation
Depreciation Summary & Income Statement
Tax Inputs
Debt Financing Inputs
Linear Debt Repayment Structure
Sculpted Debt Repayment Structure
Applied Debt & Breaking Circularities
Macro Sheet
Debt Interest & Principal Macro
Debt Service Coverage Ratio
Equity Inputs
Shareholder Loan Interest & Principal
Dividends, CFS, ICS & BS
Capital Structure Macro
Master Macro
Interest Barrier
Corporate Tax
Trade Tax, Other Local Taxes & SHL Interest Macro
Unlevered Taxes
Debt Service Reserve Account

Asset Valuation

Valuation Sheet
Levered Internal Rate of Return (IRR)
Adjusting SHL Payments
Levered Net Present Value (NPV)
FCFE / Invested Equity
Payback Period
Unlevered Project Return
Unlevered Equity Return
Unlevered IRR & NPV
Unlevered FCFE / Equity & Payback Period
Developer's vs. Investor's Perspective
Enterprise Value @Target IRR Macro
Master Macro Developer's Perspective
Master Macro Investor's Perspective

Investment Dashboard

Dashboard Sheet
General Project Info
Capital Structure
Valuation Summary
Revenue Metrics
Investment Ratios & Multiples
Charts Sheet
Contracted vs. Merchant Revenue Chart
FCFE / Equity Chart
Cashflow Waterfall Chart Inputs
Cashflow Waterfall Chart
Debt Service Coverage Ratio Chart
Using Different Scenarios

Reviews

Yana
September 22, 2023
Very informative and full with valuable info course. Be aware, though, that its truly advanced level and basic knowledge and previous experience is more than required. Highly recommended for those that would like to understand all about financial modeling of renewables on a very detailed level. Personal advice - read instructions and google as much as you can.
Kelvin
September 19, 2023
This is a high quality model that offers great flexibility. Along the classes, I had valuable insights and learned some nice Excel tips along the way. Overall, it was a rewarding learning experience.
Evan
September 12, 2023
Everything was very good, he does go at a fast pace but it is manageable. There will be slightly different formulas and settings you will have to use for USA users.
Pardeep
September 3, 2023
Course was good. but need to during course was start share the excel sheet and also aware about the excel version so students help to better understanding.
HEP
August 6, 2023
Bisher ist der Kurs sehr gut geeignet für mich. Es wird alles gut bis ins Detail erklärt und auch warum, man welche Schritte wählt wird erklärt.
Leo
July 9, 2023
Very useful to understand how to build a top-notch financial model. But incredibly difficult in some sections with low explanations sometimes about the logic used behind calcs.
John
July 3, 2023
I spent two years in a specialist big 4 financial modelling team and I still must say this is some of the best modelling training I have seen in the market and the end result is a highly dynamic, best in class project finance model. I took this course to brush up on my skills- and it didnt disappoint. This training is perfect for any project finance professional starting off in the industry or even more seasoned professionals. Lukas was highly responsive to all of the questions and perfect help throughout.
Blaise
June 30, 2023
Excellent course that gives all the insights of the industry. Really useful when starting an internship to well understand how to model! Hope I can use it soon during my internship. Thanks a lot Lukas
Akash
May 3, 2023
Super clarity about basic metrics so far and name manager of excel. Name manager is a real time manager for your model
Forrest
February 22, 2023
As an investment professional in energy transition, I believe this one of the best courses in the market to get up to speed on project modeling regardless of project jurisdiction. I was very impressed by how smooth Lukas was at navigating different segments of the model and how concise was his explanation at key concepts. Bravo!
Murat
December 24, 2022
I'm in this business for 8 years and working international both in Solar and Wind PP. With that experience I can say that this is the most valuable and conprehensive model that I have ever seen. I am really surprised that you are selling this information bundle with such a price. Congragulations and many thanks! Just a contribution; It would be great if the model has exchange options
Frank
December 4, 2022
Great course! The model is highly flexible and still easy to use! Haven't seen such a well structured model with such great flexibility before. Thank you for making this knowledge available!
Nathan
November 25, 2022
fantastic lectures I have very little macro experience & this was explained well Also the practical scenarios/explanations as the course progresses are great
Máximo
September 29, 2022
The model isn´t flexible. When trying to shorten life expectancy or modify durations, you have to go cell by cell to adjust the values. Which is quite inconvenient given the size and amount of cells in the model.
Michele
June 9, 2022
It started well but finished in a disappointing way. There should be more explanation of Theory rather than just limiting to compile the excel model with unclear formulas. Last section was better but still find the core part could be much better.

Charts

Price

Advanced Renewable Energy Financial Modeling - Price chart

Rating

Advanced Renewable Energy Financial Modeling - Ratings chart

Enrollment distribution

Advanced Renewable Energy Financial Modeling - Distribution chart
4653234
udemy ID
4/21/2022
course created date
7/12/2022
course indexed date
Bot
course submited by