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!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024