• No hay productos en el carrito.

Inicio / Cursos / Project Finance Modeling for Renewable Energy
Impartido por Greg AhuyPago único de $2,800 MXN · acceso por 12 meses

Project Finance Modeling for Renewable Energy

Learn Financial Modeling for wind and solar projects

Certificado oficial emitido por la SEPA través del Gobierno del Estado de México
12 meses de acceso En línea · 60 h 22 unidades
Qué aprenderás

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 lecciones

UNIDAD 1 - Introduction to the Course

  • Intro to the CourseVideo · 2 min
UNIDAD 2 - Part 1 - Basics of Wind and Solar Projects Development · 23 lecciones

UNIDAD 2 - Part 1 - Basics of Wind and Solar Projects Development

  • Renewable Energy OverviewVideo · 3 min
  • Wind and Solar EquipmentVideo · 3 min
  • Energy GenerationVideo · 5 min
  • Wind and Solar ResourcesVideo · 8 min
  • P-Value, Probability and ExcelVideo · 8 min
  • Quiz 1 - Equipment, Energy Generation and ResourcesCuestionario · 0 min
  • Selling Energy under the PPAVideo · 7 min
  • Risk Allocation under the PPAVideo · 4 min
  • PPA termsVideo · 5 min
  • Quiz 2 - PPA termsCuestionario · 0 min
  • Construction Contracts in Renewable Energy DevelopmentVideo · 5 min
  • Construction RisksVideo · 6 min
  • Operating costsVideo · 4 min
  • Quiz 3 - Renewables Construction and OperationsCuestionario · 0 min
  • Financing of Renewable Energy ProjectVideo · 4 min
  • Role of the SPV in FinancingVideo · 4 min
  • Sources of Financing for Renewable Energy ProjectsVideo · 6 min
  • Loan AgreementVideo · 6 min
  • Debt SizingVideo · 5 min
  • Debt Sizing ExampleVideo · 10 min
  • Control Accounts & Cash Flow WaterfallVideo · 6 min
  • Covenants in Project FinanceVideo · 4 min
  • Quiz 4 - FinancingCuestionario · 0 min
UNIDAD 3 - Part 2 - Excel Refresher · 11 lecciones

UNIDAD 3 - Part 2 - Excel Refresher

  • Calculations In BlocksVideo · 10 min
  • Paste Forward LinkVideo · 4 min
  • Daisy Chains and Link FormattingVideo · 4 min
  • Using PlaceholdersVideo · 2 min
  • Excel Shortcut KeysVideo · 8 min
  • Understanding AnchoringVideo · 4 min
  • Understanding DatesVideo · 5 min
  • Understanding IF StatementsVideo · 5 min
  • Understanding SUMIF functionVideo · 6 min
  • Understanding LOOKUP functionVideo · 6 min
  • Understanding MIN MAX functionsVideo · 3 min
UNIDAD 4 - Part 3 - Financial Modeling For Wind and Solar Projects (SPV pays taxes) · 6 lecciones

UNIDAD 4 - Part 3 - Financial Modeling For Wind and Solar Projects (SPV pays taxes)

  • Introduction to the Financial Model and Case StudyVideo · 5 min
  • Timing and FlagsVideo · 5 min
  • Modeling DatesVideo · 11 min
  • Modeling Flags 1Video · 8 min
  • Modeling Flags 2Video · 9 min
  • Modeling Flags 3Video · 16 min
UNIDAD 5 - Modeling Energy Generation · 3 lecciones

UNIDAD 5 - Modeling Energy Generation

  • Energy Generation RecapVideo · 1 min
  • Modeling Energy GenerationVideo · 14 min
  • Modeling Energy Generation with Seasonality FactorVideo · 9 min
UNIDAD 6 - Selling Energy · 2 lecciones

UNIDAD 6 - Selling Energy

  • Selling Energy RecapVideo · 1 min
  • Modelling RevenueVideo · 16 min
UNIDAD 7 - Operating Costs · 2 lecciones

UNIDAD 7 - Operating Costs

  • Operating Costs RecapVideo · 1 min
  • Modeling Operating CostsVideo · 12 min
UNIDAD 8 - Working Capital · 2 lecciones

UNIDAD 8 - Working Capital

  • Understanding Working CapitalVideo · 5 min
  • Modeling Working CapitalVideo · 12 min
UNIDAD 9 - PP&E and Depreciation · 2 lecciones

UNIDAD 9 - PP&E and Depreciation

  • Understanding PP&E and DepreciationVideo · 4 min
  • Modeling PP& and DepreciationVideo · 12 min
UNIDAD 10 - Tax Expense and Tax Paid · 4 lecciones

UNIDAD 10 - Tax Expense and Tax Paid

  • Understanding TaxesVideo · 6 min
  • Net Operating LossesVideo · 5 min
  • Modeling Taxes 1Video · 10 min
  • Modeling Taxes 2Video · 17 min
UNIDAD 11 - Equity, Dividends and Cash · 3 lecciones

UNIDAD 11 - Equity, Dividends and Cash

  • Understanding EquityVideo · 5 min
  • Modeling Equity, Dividends and Cash - 1Video · 12 min
  • Modeling Equity, Dividends and Cash - 2Video · 14 min
UNIDAD 12 - Sizing the Debt for Wind and Solar Projects · 3 lecciones

UNIDAD 12 - Sizing the Debt for Wind and Solar Projects

  • Debt Sizing for Renewable ProjectsVideo · 2 min
  • Sizing the Debt -1Video · 21 min
  • Sizing the Debt - 2Video · 15 min
UNIDAD 13 - Modeling Construction Phase · 10 lecciones

UNIDAD 13 - Modeling Construction Phase

  • Construction TimingVideo · 4 min
  • Modeling Construction CostsVideo · 12 min
  • Understanding Construction FundingVideo · 4 min
  • Construction Funding OverviewVideo · 7 min
  • Modeling Construction Funding 1Video · 13 min
  • Modeling Construction Funding 2Video · 16 min
  • Financing costs 1Video · 15 min
  • Financing costs 2Video · 21 min
  • Linking Funding Sheet to Operations 1Video · 12 min
  • Linking Funding Sheet to Operations 2Video · 14 min
UNIDAD 14 - Term Loan · 1 lecciones

UNIDAD 14 - Term Loan

  • Modeling Term LoanVideo · 11 min
UNIDAD 15 - Project Finance Debt Ratios · 5 lecciones

UNIDAD 15 - Project Finance Debt Ratios

  • Understanding DSCRVideo · 6 min
  • Modeling DSCRVideo · 8 min
  • Understanding LLCR & PLCRVideo · 6 min
  • Modeling LLCRVideo · 13 min
  • Modeling LLCR based on effective interest rateVideo · 15 min
UNIDAD 16 - Debt Service Reserve Account ("DSRA") · 6 lecciones

UNIDAD 16 - Debt Service Reserve Account ("DSRA")

  • Understanding DRSA - 1Video · 2 min
  • Understanding DSRA - 2Video · 5 min
  • Modeling DSRA 1Video · 18 min
  • Modeling DSRA 2Video · 9 min
  • Modeling DSRA 3Video · 10 min
  • Modeling DSRA 4Video · 12 min
UNIDAD 17 - Shareholder Loan · 5 lecciones

UNIDAD 17 - Shareholder Loan

  • Understanding Shareholder Loan - 1Video · 3 min
  • Understanding Shareholder Loan - 2Video · 4 min
  • Modeling Shareholder Loan - 1Video · 6 min
  • Modeling Shareholder Loan - 2Video · 14 min
  • Modeling Shareholder Loan - 3Video · 7 min
UNIDAD 18 - Project Returns · 4 lecciones

UNIDAD 18 - Project Returns

  • Project Returns OverviewVideo · 4 min
  • Modeling Project Returns - 1Video · 11 min
  • Modeling Project Returns - 2Video · 13 min
  • Project OptimizationVideo · 20 min
UNIDAD 19 - Model Checks and Scenario Manager · 3 lecciones

UNIDAD 19 - Model Checks and Scenario Manager

  • Modeling ChecksVideo · 22 min
  • Modeling Scenario ManagerVideo · 10 min
  • Construction Funding MacroVideo · 7 min
UNIDAD 20 - Summary Sheet · 1 lecciones

UNIDAD 20 - Summary Sheet

  • SummaryVideo · 3 min
UNIDAD 21 - Part - 4 Financial Modeling For Wind and Solar in US · 23 lecciones

UNIDAD 21 - Part - 4 Financial Modeling For Wind and Solar in US

  • Investment StructuringVideo · 3 min
  • Tax EfficiencyVideo · 8 min
  • Production Tax Credits before Inflation Reduction ActVideo · 5 min
  • PTC after Inflation Reduction ActVideo · 8 min
  • Investment Tax Credit before Inflation Reduction ActVideo · 4 min
  • ITC after Inflation Reduction ActVideo · 6 min
  • IRA Bonus Credits ("Adders")Video · 4 min
  • Modeling PTCVideo · 6 min
  • Modeling ITCVideo · 9 min
  • Modeling Tax Benefits for Efficient TaxpayerVideo · 3 min
  • Modeling Tax Benefits for Inefficient TaxpayerVideo · 12 min
  • NPV of Tax BenefitsVideo · 5 min
  • Modeling Returns of the Efficient and Inefficient TaxpayerVideo · 11 min
  • Understanding Tax Equity - 1Video · 4 min
  • Understanding Tax Equity - 2Video · 5 min
  • Intro into Tax Equity ModelingVideo · 4 min
  • Tax Equity Modeling 1 - Sizing Tax EquityVideo · 9 min
  • Tax Equity Modeling 2 - Sizing Back Leverage DebtVideo · 11 min
  • Tax Equity Modeling 3 - Construction FundingVideo · 15 min
  • Tax Equity Modeling 4 - Sponsor's Tax Credits and EBTVideo · 11 min
  • Tax Equity Modeling 5 - Sponsor's Tax LiabilityVideo · 10 min
  • Tax Equity Modeling 6 - Sponsor IRRVideo · 8 min
  • Tax Equity Modeling 7 - SummaryVideo · 18 min
UNIDAD 22 - Part 5 - Final Task · 2 lecciones

UNIDAD 22 - Part 5 - Final Task

  • Final TaskLectura · 0 min
  • Final Task - InstructionsVideo · 7 min
Certificado oficial

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
Cómo funciona

Tu itinerario, de la inscripción al certificado

  1. 1

    Inscripción con pago único

    Pagas $2,800 MXN una sola vez y entras de inmediato al curso.

  2. 2

    Estudias a tu ritmo

    22 unidades con videos, lecturas y actividades, disponibles 24/7 durante 12 meses.

  3. 3

    Cuestionarios por unidad

    4 cuestionarios para comprobar lo aprendido.

  4. 4

    Certificado

    Emitido por la SEP a través del Gobierno del Estado de México, con folio verificable.

Lo que obtienes

Un certificado oficial de la SEP

Muestra del certificado: Project Finance Modeling for Renewable Energy

Muestra · verificable por folio y QR

  • 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.
Medios que necesitas
Equipo de cómputo Conexión estable a internet
Pago único

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
Pago único
$2,800MXN
Acceso por 12 meses
Inscribirme Hablar con un asesor
Preguntas frecuentes

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.

Certificado emitido por la SEP a través del Gobierno del Estado de México · Project Finance Modeling for Renewable Energy

Inscribirme
  INEC es una Marca de SalesPartners Ciudad de México S de RL de CV. Template Design © Learnify LMS. All rights reserved. Terminos y Condiciones Aviso de Privacidad Politica de Devolución
Hide picture