image
The Ultimate Drawing Course Beginner to Advanced...
$179
$79
image
User Experience Design Essentials - Adobe XD UI UX...
$179
$79
Total:
$659

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.
Who this course is for:
Infrastructure Investors
Project Developers
Private Equity Investors
Debt Financing Banks
Investment Banks
Asset Managers

What you'll 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

Requirements

  • You will need a copy of Adobe XD 2019 or above. A free trial can be downloaded from Adobe.
  • No previous design experience is needed.
  • No previous Adobe XD skills are needed.

Course Content

27 sections • 95 lectures
Expand All Sections
1-Setting up the Model Framework
12
1.1-Course Introduction
1.2-Final Model - Dashboard
1.3-Introduction to Start File
1.4-Technical Inputs
1.5-Scenario Selection
1.6-Shortcuts Quiz #1
1.7-General Inputs
1.8-Shortcuts Quiz #2
1.9-Timing Sheet
1.10-Model Timeline
1.11-Macroeconomics
1.12-Shortcuts Quiz #3
2-Building a Project Finance Model
42
2.1-Project Finance - Contractual Relations
2.2-Information Memorandum
2.3-Uses of Funds
2.4-Sources of Funds
2.5-Shortcuts Quiz #4
2.6-Creating Checks
2.7-Checks Sheet
2.8-Depreciation Categories
2.9-Power Generation Inputs
2.10-Availability, Degradation & Seasonality
2.11-Net Power Generation
2.12-PPA & Merchant Inputs
2.13-Generation Allocation (PPA vs Merchant)
2.14-PPA & Merchant Revenue
2.15-Operational Expenditure Inputs
2.16-Operational Expenditures
2.17-MMRA Inputs
2.18-Major Maintenance Reserve Account
2.19-Decommissioning Reserve Account Inputs
2.20-Decommissioning Reserve Account
2.21-SPV Cash Reserve
2.22-Working Capital Adjustments
2.23-Accounting & Tax Depreciation
2.24-Depreciation Summary & Income Statement
2.25-Tax Inputs
2.26-Debt Financing Inputs
2.27-Linear Debt Repayment Structure
2.28-Sculpted Debt Repayment Structure
2.29-Applied Debt & Breaking Circularities
2.30-Macro Sheet
2.31-Debt Interest & Principal Macro
2.32-Debt Service Coverage Ratio
2.33-Equity Inputs
2.34-Shareholder Loan Interest & Principal
2.35-Dividends, CFS, ICS & BS
2.36-Capital Structure Macro
2.37-Master Macro
2.38-Interest Barrier
2.39-Corporate Tax
2.40-Trade Tax, Other Local Taxes & SHL Interest Macro
2.41-Unlevered Taxes
2.42-Debt Service Reserve Account
3-Asset Valuation
14
3.1-Valuation Sheet
3.2-Levered Internal Rate of Return (IRR)
3.3-Adjusting SHL Payments
3.4-Levered Net Present Value (NPV)
3.5-FCFE / Invested Equity
3.6-Payback Period
3.7-Unlevered Project Return
3.8-Unlevered Equity Return
3.9-Unlevered IRR & NPV
3.10-Unlevered FCFE / Equity & Payback Period
3.11-Developer's vs. Investor's Perspective
3.12-Enterprise Value @Target IRR Macro
3.13-Master Macro Developer's Perspective
3.14-Master Macro Investor's Perspective
4-Investment Dashboard
13
4.1-Dashboard Sheet
4.2-General Project Info
4.3-Capital Structure
4.4-Valuation Summary
4.5-Revenue Metrics
4.6-Investment Ratios & Multiples
4.7-Charts Sheet
4.8-Contracted vs. Merchant Revenue Chart
4.9-FCFE / Equity Chart
4.10-Cashflow Waterfall Chart Inputs
4.11-Cashflow Waterfall Chart
4.12-Debt Service Coverage Ratio Chart
4.13-Using Different Scenarios