Project Finance Modeling for Renewable Energy

Project Finance Modeling for Renewable Energy, available at $159.99, has an average rating of 4.52, with 115 lectures, 4 quizzes, based on 515 reviews, and has 1480 subscribers.

You will learn about 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; 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. This course is ideal for individuals who are Typical students include finance students, recent graduates, analysts, managers, senior managers, associate directors, advisers, financiers and CFOs from financial and infrastructure companies. It is particularly useful for Typical students include finance students, recent graduates, analysts, managers, senior managers, associate directors, advisers, financiers and CFOs from financial and infrastructure companies.

Enroll now: Project Finance Modeling for Renewable Energy

Summary

Title: Project Finance Modeling for Renewable Energy

Price: $159.99

Average Rating: 4.52

Number of Lectures: 115

Number of Quizzes: 4

Number of Published Lectures: 115

Number of Published Quizzes: 4

Number of Curriculum Items: 119

Number of Published Curriculum Objects: 119

Original Price: $159.99

Quality Status: approved

Status: Live

What You Will Learn

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;

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.

Who Should Attend

Typical students include finance students, recent graduates, analysts, managers, senior managers, associate directors, advisers, financiers and CFOs from financial and infrastructure companies.

Target Audiences

Typical students include finance students, recent graduates, analysts, managers, senior managers, associate directors, advisers, financiers and CFOs from financial and infrastructure companies.

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 VBAcodes 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.

Course Curriculum

Chapter 1: Introduction to the Course

Lecture 1: Intro to the Course

Chapter 2: Part 1 – Basics of Wind and Solar Projects Development

Lecture 1: Renewable Energy Overview

Lecture 2: Wind and Solar Equipment

Lecture 3: Energy Generation

Lecture 4: Wind and Solar Resources

Lecture 5: P-Value, Probability and Excel

Lecture 6: Selling Energy under the PPA

Lecture 7: Risk Allocation under the PPA

Lecture 8: PPA terms

Lecture 9: Construction Contracts in Renewable Energy Development

Lecture 10: Construction Risks

Lecture 11: Operating costs

Lecture 12: Financing of Renewable Energy Project

Lecture 13: Role of the SPV in Financing

Lecture 14: Sources of Financing for Renewable Energy Projects

Lecture 15: Loan Agreement

Lecture 16: Debt Sizing

Lecture 17: Debt Sizing Example

Lecture 18: Control Accounts & Cash Flow Waterfall

Lecture 19: Covenants in Project Finance

Chapter 3: Part 2 – Excel Refresher

Lecture 1: Calculations In Blocks

Lecture 2: Paste Forward Link

Lecture 3: Daisy Chains and Link Formatting

Lecture 4: Using Placeholders

Lecture 5: Excel Shortcut Keys

Lecture 6: Understanding Anchoring

Lecture 7: Understanding Dates

Lecture 8: Understanding IF Statements

Lecture 9: Understanding SUMIF function

Lecture 10: Understanding LOOKUP function

Lecture 11: Understanding MIN MAX functions

Chapter 4: Part 3 – Financial Modeling For Wind and Solar Projects (SPV pays taxes)

Lecture 1: Introduction to the Financial Model and Case Study

Lecture 2: Timing and Flags

Lecture 3: Modeling Dates

Lecture 4: Modeling Flags 1

Lecture 5: Modeling Flags 2

Lecture 6: Modeling Flags 3

Chapter 5: Modeling Energy Generation

Lecture 1: Energy Generation Recap

Lecture 2: Modeling Energy Generation

Lecture 3: Modeling Energy Generation with Seasonality Factor

Chapter 6: Selling Energy

Lecture 1: Selling Energy Recap

Lecture 2: Modelling Revenue

Chapter 7: Operating Costs

Lecture 1: Operating Costs Recap

Lecture 2: Modeling Operating Costs

Chapter 8: Working Capital

Lecture 1: Understanding Working Capital

Lecture 2: Modeling Working Capital

Chapter 9: PP&E and Depreciation

Lecture 1: Understanding PP&E and Depreciation

Lecture 2: Modeling PP& and Depreciation

Chapter 10: Tax Expense and Tax Paid

Lecture 1: Understanding Taxes

Lecture 2: Net Operating Losses

Lecture 3: Modeling Taxes 1

Lecture 4: Modeling Taxes 2

Chapter 11: Equity, Dividends and Cash

Lecture 1: Understanding Equity

Lecture 2: Modeling Equity, Dividends and Cash – 1

Lecture 3: Modeling Equity, Dividends and Cash – 2

Chapter 12: Sizing the Debt for Wind and Solar Projects

Lecture 1: Debt Sizing for Renewable Projects

Lecture 2: Sizing the Debt -1

Lecture 3: Sizing the Debt – 2

Chapter 13: Modeling Construction Phase

Lecture 1: Construction Timing

Lecture 2: Modeling Construction Costs

Lecture 3: Understanding Construction Funding

Lecture 4: Construction Funding Overview

Lecture 5: Modeling Construction Funding 1

Lecture 6: Modeling Construction Funding 2

Lecture 7: Financing costs 1

Lecture 8: Financing costs 2

Lecture 9: Linking Funding Sheet to Operations 1

Lecture 10: Linking Funding Sheet to Operations 2

Chapter 14: Term Loan

Lecture 1: Modeling Term Loan

Chapter 15: Project Finance Debt Ratios

Lecture 1: Understanding DSCR

Lecture 2: Modeling DSCR

Lecture 3: Understanding LLCR & PLCR

Lecture 4: Modeling LLCR

Lecture 5: Modeling LLCR based on effective interest rate

Chapter 16: Debt Service Reserve Account (DSRA)

Lecture 1: Understanding DRSA – 1

Lecture 2: Understanding DSRA – 2

Lecture 3: Modeling DSRA 1

Lecture 4: Modeling DSRA 2

Lecture 5: Modeling DSRA 3

Lecture 6: Modeling DSRA 4

Instructors

Greg Ahuy
Financial Modeler at FMO – Financial Model Online

Rating Distribution

1 stars: 7 votes

2 stars: 1 votes

3 stars: 38 votes

4 stars: 172 votes

5 stars: 297 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!