Financial Modeling Solar Wind Power Plants 2018

Learn how build a financial model for solar plants and wind plants, and help seal renewable energy deals worldwide!

Last updated 2022-01-10 | 4.5

- The fundamentals of a power plants' business
- and their key value drivers
- How to model a plant's cashflow performance in Excel
- How to use this model to assess financing and commercial options for the plant and how they affect its value!

What you'll learn

The fundamentals of a power plants' business
and their key value drivers
How to model a plant's cashflow performance in Excel
How to use this model to assess financing and commercial options for the plant and how they affect its value!

* Requirements

* Be able to build a basic 3-statement model in Excel
* How to use the index-match combination in Excel

Description

Want to work on RENEWABLE ENERGY deals in WIND and SOLAR power?
Want to be part of the global shift to renewable energy? 
Want to break into a sector that is expected to have $10TRILLION poured into it through 2040? 

THIS is the course for YOU!

Go beyond filling out pre-prepared templates - build complex financial models from scratch!
Make a quantum leap in your financial modeling skills! 
Save hours at work - by learning Excel best practices and VBA!


This course takes an application-led approach which will guide you through an ENTIRE buyout valuation model for a newly operational WIND PLANT or SOLAR PLANT in Excel! 


You'll take a comprehensive a approach learning the BUSINESS AND RISK FUNDAMENTALS of wind and solar power plants' business, including how to find relevant information in technical engineering reports.

You won't just be taught how to build a financial model - you'll learn HOW TO USE IT. 


You'll prepare yourself for to work on solar and wind plant deals ALL AROUND THE WORLD with:

  • Banks

  • Advisory teams

  • Private equity funds

  • Debt funds

  • Industrial developers

  • Asset managers


You'll cover the theory and financial modeling for:

  • Solar and wind plant business and operations

  • Plant risk assessment

  • Debt sizing

  • Debt service sculpting/tailoring/payment structuring

  • Lender covenants

  • Complex cash waterfalls

  • Debt service ratios

  • Dynamic charts and dashboard design

  • Circular calculations common in plant financing deals


Your financial model will:

  • Handle complex financial engineering and analysis applicable to most wind and solar buyout deals

  • Calculate returns, a fair buyout price, and industry-specific multiple

  • Give you flexibility to assess multiple financing arrangements

  • Have clean, efficient VBA code to speed up your analysis and free up your time

  • Follow the very best practices actually used by professionals in the industry

 


This course gives you all the pro tips you'd other have to pay $1,000s to access as part of a corporate training programme!! 


DON'T WAIT ON YOUR BOSS TO APPROVE THE TRAINING YOU DESERVE!!


ENROLL NOW - there's ZERO RISK as you're covered by a 30-day money-back guarantee! 
(https://support.udemy.com/hc/en-us/articles/229604248-Refund-a-Course)

Who this course is for:

  • Students and young professionals interested in supporting commercial and financial deals for solar and wind power plants!

Course content

4 sections • 28 lectures

Energy and power Preview 05:16

Solar and wind generation - basics Preview 01:57

Solar and wind generation - losses Preview 05:11

Solar and wind generation - variability pt.1 Preview 03:02

Solar and wind generation - variability pt.2 Preview 03:35

Solar and wind generation - variability pt.3 Preview 03:03

Renewable power plant concept checker

This is a short quiz to test your understanding of high-level concepts introduced over the last few lectures.

Setting up the model Preview 17:19

Modelling plant generation Preview 04:34

Modelling plant commercial activity Preview 07:10

Setting up the waterfall and financial statements Preview 02:48

Modelling debt and interest Preview 06:26

Debt sizing and sculpting Preview 10:59

Modelling the buyout's cashflows Preview 03:51

Modelling depreciation and amortisation Preview 03:00

Modelling tax Preview 01:43

Managing circularities in debt sizing Preview 09:53

Debt sizing with multiple case testing Preview 18:57

Handling multiple stakeholder views Preview 04:58

Modelling lender covenants Preview 02:43

Modelling equity cashflows Preview 03:42

Valuing the buyout Preview 02:28

Automating the fair price calculation Preview 01:05

Perfecting the dashboard Preview 05:14

Exercise questions and materials Preview 00:05

Answers to exercises Preview 00:03

BONUS Preview 00:49

A special video I recorded for students completing this course!