
Assess the variability of solar and wind output using quantitative methods, examining p values across 10-year and 1-year samples to inform risk and financing decisions.
Explore how geographic diversification reduces wind and solar variability through portfolio effects, and learn to apply a seasonality profile to allocate annual output and price in renewable energy financial models.
Develop a configurable plant generation model that switches between wind and solar, loads technology-specific assumptions, applies degradation and availability controls, and computes seasonally adjusted generation with a revenues tab.
Set up cash waterfall and financial statements by linking opening and closing cash with revenues and expenses, using corkscrew balances to reconcile cash, PNL, and balance sheet.
Size non-recourse debt for renewable energy projects by sculpting debt service to cash flows using debt service coverage ratios, then validate with present value and leverage constraints.
Explore circularity in debt sizing for renewable energy, where CFADS and taxes drive iterative calculations that converge to a stable value via VBA.
Learn to size debt against P50 and P99 cfads under dual coverage tests in renewable energy finance, and automate multiple case testing with VBA while preserving model transparency.
Assess the project's debt service plan against actual repayment using DCR and other ratios, determine equity distributions or risk actions, and ensure lender covenant requirements are reflected in the model.
Design a clean, informative dashboard by keeping content in a single view, aligning inputs and charts, and using dynamic named ranges to adapt axes and data.
A special video I recorded for students completing this course!
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)