Project Finance Modeling for Renewable Energy
Learn Financial Modeling for wind and solar projects
Lo que serás capaz de hacer
Project Finance Modeling for Renewable Energy course will give you the skills to develop and analyze financial models for wind and solar projects. The course covers essential topics including debt sizing and funding, wind and solar project operations, and investment returns, and will provide you with a robust financial modeling skillset for analysis of renewable projects in the most sophisticated environments. In an online environment you will go from a blank Excel workbook to a financial model suitable for investment analysis, debt structuring and operational scenario evaluation. This course will provide step-by-step instructions on how to build financial model suitable for analyzing wind and solar projects. What this course is about? Project finance models for renewable energy are used to assess the risk-reward of lending to and investing in renewable project (wind and solar). The project's debt capacity, investment returns and financial feasibility depend on expected future cash flows generated by the renewable energy project itself and a financial model is built to analyze this. In the Project Finance Modeling for Renewable Energy course we will model complex wind and solar project finance transactions from scratch in excel . You will learn about: - How to build a project finance model from scratch in excel for wind and solar projects; - Learn how renewable energy projects get developed and financed ; - How to create best practice macro’s and Excel VBA codes to break circularities; - Learn how to size debt based on multiple covenants for wind and solar projects; - How to model Debt Service Reserve Account ; - How to model unlevered project returns and blended equity returns ; - Learn to integrate multiple probability exceedance generation profiles (P50, P99) into the financial model; - Learn basics of GP/LP flip structures and tax equity for project financing ; - Gain insights into financial model development process, step-by-step – for a renewable energy model; - Optimize the model to achieve the requirements of lenders and investors. Why you should enroll in the Project Finance Modeling for Renewable Energy course? Realistic project finance training - The Project Finance Modeling for Renewable Energy course includes over 10 hours of instructor-led video content to learn at your own pace. After completing this course you will be able to build complex, real-life project finance model for wind and solar projects. Affordability - a similar course, which provides realistic project finance modeling training will cost you anywhere from US$1000 to US$3,000 per course. Learn anytime and anywhere - The Project Finance Modeling course is 100% online so you can learn the modeling when it is convenient for you. How does it work? The course length is over 10 hours. First, we will review the basics of wind and solar projects development, so we understand all essential components of project finance transactions in the context of renewable energy. Then, in the second part, we will review financial modeling methods and excel functions that we will use often in this course, to improve our productivity in excel. We will begin financial modeling in the third part, where we will build a financial model for wind and solar projects for the case when SPV pays taxes. And, finally, In the fourth part, we will review the peculiarities of the US renewable projects and build a financial model that takes into account the tax credits available in the US, and introduce to the new source of financing called tax equity. Is this course for you? Yes, if you need to build, review or analyse project finance models within the renewable energy sectors. Typical students include analysts, managers, senior managers, associate directors, financial advisors, financiers and CFOs from project companies, investment banks, private equity and infrastructure funds. This course prerequisites: You will need previous exposure to Excel in a financial modelling context and basic knowledge of investment concepts such as NPV and cash flows.
- How to build project finance model from scratch in excel for wind and solar projects;
- Learn how renewable energy projects get developed and financed;
- How to create best practice macro’s and Excel VBA codes to break circularities;
- Learn how to size debt based on multiple covenants for wind and solar projects;
- How to model Debt Service Reserve Account;
- How to model unlevered project returns and blended equity returns;
Temario
UNIDAD 1 - Introduction to the Course · 1 leccionesUNIDAD 1 - Introduction to the Course
UNIDAD 1 - Introduction to the Course
- Intro to the Course
UNIDAD 2 - Part 1 - Basics of Wind and Solar Projects Development · 23 leccionesUNIDAD 2 - Part 1 - Basics of Wind and Solar Projects Development
UNIDAD 2 - Part 1 - Basics of Wind and Solar Projects Development
- Renewable Energy Overview
- Wind and Solar Equipment
- Energy Generation
- Wind and Solar Resources
- P-Value, Probability and Excel
- Quiz 1 - Equipment, Energy Generation and Resources
- Selling Energy under the PPA
- Risk Allocation under the PPA
- PPA terms
- Quiz 2 - PPA terms
- Construction Contracts in Renewable Energy Development
- Construction Risks
- Operating costs
- Quiz 3 - Renewables Construction and Operations
- Financing of Renewable Energy Project
- Role of the SPV in Financing
- Sources of Financing for Renewable Energy Projects
- Loan Agreement
- Debt Sizing
- Debt Sizing Example
- Control Accounts & Cash Flow Waterfall
- Covenants in Project Finance
- Quiz 4 - Financing
UNIDAD 3 - Part 2 - Excel Refresher · 11 leccionesUNIDAD 3 - Part 2 - Excel Refresher
UNIDAD 3 - Part 2 - Excel Refresher
- Calculations In Blocks
- Paste Forward Link
- Daisy Chains and Link Formatting
- Using Placeholders
- Excel Shortcut Keys
- Understanding Anchoring
- Understanding Dates
- Understanding IF Statements
- Understanding SUMIF function
- Understanding LOOKUP function
- Understanding MIN MAX functions
UNIDAD 4 - Part 3 - Financial Modeling For Wind and Solar Projects (SPV pays taxes) · 6 leccionesUNIDAD 4 - Part 3 - Financial Modeling For Wind and Solar Projects (SPV pays taxes)
UNIDAD 4 - Part 3 - Financial Modeling For Wind and Solar Projects (SPV pays taxes)
- Introduction to the Financial Model and Case Study
- Timing and Flags
- Modeling Dates
- Modeling Flags 1
- Modeling Flags 2
- Modeling Flags 3
UNIDAD 5 - Modeling Energy Generation · 3 leccionesUNIDAD 5 - Modeling Energy Generation
UNIDAD 5 - Modeling Energy Generation
- Energy Generation Recap
- Modeling Energy Generation
- Modeling Energy Generation with Seasonality Factor
UNIDAD 6 - Selling Energy · 2 leccionesUNIDAD 6 - Selling Energy
UNIDAD 6 - Selling Energy
- Selling Energy Recap
- Modelling Revenue
UNIDAD 7 - Operating Costs · 2 leccionesUNIDAD 7 - Operating Costs
UNIDAD 7 - Operating Costs
- Operating Costs Recap
- Modeling Operating Costs
UNIDAD 8 - Working Capital · 2 leccionesUNIDAD 8 - Working Capital
UNIDAD 8 - Working Capital
- Understanding Working Capital
- Modeling Working Capital
UNIDAD 9 - PP&E and Depreciation · 2 leccionesUNIDAD 9 - PP&E and Depreciation
UNIDAD 9 - PP&E and Depreciation
- Understanding PP&E and Depreciation
- Modeling PP& and Depreciation
UNIDAD 10 - Tax Expense and Tax Paid · 4 leccionesUNIDAD 10 - Tax Expense and Tax Paid
UNIDAD 10 - Tax Expense and Tax Paid
- Understanding Taxes
- Net Operating Losses
- Modeling Taxes 1
- Modeling Taxes 2
UNIDAD 11 - Equity, Dividends and Cash · 3 leccionesUNIDAD 11 - Equity, Dividends and Cash
UNIDAD 11 - Equity, Dividends and Cash
- Understanding Equity
- Modeling Equity, Dividends and Cash - 1
- Modeling Equity, Dividends and Cash - 2
UNIDAD 12 - Sizing the Debt for Wind and Solar Projects · 3 leccionesUNIDAD 12 - Sizing the Debt for Wind and Solar Projects
UNIDAD 12 - Sizing the Debt for Wind and Solar Projects
- Debt Sizing for Renewable Projects
- Sizing the Debt -1
- Sizing the Debt - 2
UNIDAD 13 - Modeling Construction Phase · 10 leccionesUNIDAD 13 - Modeling Construction Phase
UNIDAD 13 - Modeling Construction Phase
- Construction Timing
- Modeling Construction Costs
- Understanding Construction Funding
- Construction Funding Overview
- Modeling Construction Funding 1
- Modeling Construction Funding 2
- Financing costs 1
- Financing costs 2
- Linking Funding Sheet to Operations 1
- Linking Funding Sheet to Operations 2
UNIDAD 14 - Term Loan · 1 leccionesUNIDAD 14 - Term Loan
UNIDAD 14 - Term Loan
- Modeling Term Loan
UNIDAD 15 - Project Finance Debt Ratios · 5 leccionesUNIDAD 15 - Project Finance Debt Ratios
UNIDAD 15 - Project Finance Debt Ratios
- Understanding DSCR
- Modeling DSCR
- Understanding LLCR & PLCR
- Modeling LLCR
- Modeling LLCR based on effective interest rate
UNIDAD 16 - Debt Service Reserve Account ("DSRA") · 6 leccionesUNIDAD 16 - Debt Service Reserve Account ("DSRA")
UNIDAD 16 - Debt Service Reserve Account ("DSRA")
- Understanding DRSA - 1
- Understanding DSRA - 2
- Modeling DSRA 1
- Modeling DSRA 2
- Modeling DSRA 3
- Modeling DSRA 4
UNIDAD 17 - Shareholder Loan · 5 leccionesUNIDAD 17 - Shareholder Loan
UNIDAD 17 - Shareholder Loan
- Understanding Shareholder Loan - 1
- Understanding Shareholder Loan - 2
- Modeling Shareholder Loan - 1
- Modeling Shareholder Loan - 2
- Modeling Shareholder Loan - 3
UNIDAD 18 - Project Returns · 4 leccionesUNIDAD 18 - Project Returns
UNIDAD 18 - Project Returns
- Project Returns Overview
- Modeling Project Returns - 1
- Modeling Project Returns - 2
- Project Optimization
UNIDAD 19 - Model Checks and Scenario Manager · 3 leccionesUNIDAD 19 - Model Checks and Scenario Manager
UNIDAD 19 - Model Checks and Scenario Manager
- Modeling Checks
- Modeling Scenario Manager
- Construction Funding Macro
UNIDAD 20 - Summary Sheet · 1 leccionesUNIDAD 20 - Summary Sheet
UNIDAD 20 - Summary Sheet
- Summary
UNIDAD 21 - Part - 4 Financial Modeling For Wind and Solar in US · 23 leccionesUNIDAD 21 - Part - 4 Financial Modeling For Wind and Solar in US
UNIDAD 21 - Part - 4 Financial Modeling For Wind and Solar in US
- Investment Structuring
- Tax Efficiency
- Production Tax Credits before Inflation Reduction Act
- PTC after Inflation Reduction Act
- Investment Tax Credit before Inflation Reduction Act
- ITC after Inflation Reduction Act
- IRA Bonus Credits ("Adders")
- Modeling PTC
- Modeling ITC
- Modeling Tax Benefits for Efficient Taxpayer
- Modeling Tax Benefits for Inefficient Taxpayer
- NPV of Tax Benefits
- Modeling Returns of the Efficient and Inefficient Taxpayer
- Understanding Tax Equity - 1
- Understanding Tax Equity - 2
- Intro into Tax Equity Modeling
- Tax Equity Modeling 1 - Sizing Tax Equity
- Tax Equity Modeling 2 - Sizing Back Leverage Debt
- Tax Equity Modeling 3 - Construction Funding
- Tax Equity Modeling 4 - Sponsor's Tax Credits and EBT
- Tax Equity Modeling 5 - Sponsor's Tax Liability
- Tax Equity Modeling 6 - Sponsor IRR
- Tax Equity Modeling 7 - Summary
UNIDAD 22 - Part 5 - Final Task · 2 leccionesUNIDAD 22 - Part 5 - Final Task
UNIDAD 22 - Part 5 - Final Task
- Final Task
- Final Task - Instructions
Tu certificado lo emite la SEP, no solo una plataforma
Al demostrar la competencia recibes un certificado emitido por la Secretaría de Educación Pública a través del Gobierno del Estado de México: un documento oficial que puedes presentar con confianza ante cualquier empleador o institución.
Tu certificado con INEC
- Lo emite la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México
- Documento oficial con folio verificable en línea
- Lo otorga la Universidad Tecnológica Fidel Velázquez
Otras plataformas en línea
- Constancia privada emitida por la misma plataforma
- Solo acredita horas cursadas o asistencia
- Sin respaldo de una autoridad educativa
Tu itinerario, de la inscripción al certificado
- 1
Inscripción con pago único
Pagas $2,800 MXN una sola vez y entras de inmediato al curso.
- 2
Estudias a tu ritmo
22 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.
- 3
Cuestionarios por unidad
4 cuestionarios para comprobar lo aprendido.
- 4
Certificado
Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.
Un certificado oficial de la SEP
- Emitido por la Secretaría de Educación Pública (SEP), a través del Gobierno del Estado de México. No es una constancia privada: es un documento oficial, y ese respaldo marca la diferencia frente a otras plataformas en línea.
- Contenido impartido por Greg Ahuy.
- Folio y QR verificables para compartirlo con quien te contrate.
Empieza hoy, a tu ritmo
Un solo pago y acceso inmediato al curso completo durante 12 meses.
- 22 unidades · 122 lecciones · 60 h
- 12 meses de acceso
- 4 cuestionarios de evaluación
- Certificado emitido por la SEP (Gob. del Estado de México) con folio verificable
Sobre tu inscripción
¿Cómo es el pago?
Un solo pago de $2,800 MXN. No hay mensualidades ni cargos recurrentes.
¿Cuánto tiempo tengo acceso?
12 meses desde tu inscripción, 24/7, para avanzar a tu ritmo.
¿Quién imparte el contenido?
El curso es impartido por Greg Ahuy; INEC gestiona tu inscripción, evaluación y certificado.
¿Qué pasa cuando vence mi acceso?
Puedes renovar tu cuenta tú mismo desde la plataforma, sin trámites ni esperas.


