||Home|| Book || Featured PF Models || Featured Corp Models || Featured Acq Models || PF Exercises || Corp Exercises || Download to Excel || Scenario Analysis || Tornado Diagrams || Monte Carlo || Flexible Graphs || Real Estate || Acq Exercises || Macros || Reading PDF || Waterfall Graphs || Circular Ref || Depreciation || Financial Ratio || Value Driver || Renewable || Testimony || Pricing Case Studies ||

This page addresses issues that are specific to wind production, wind resource analysis and wind financing. Wind resource analysis deals with some tricky wind resource subjects that I think are difficult including understanding the difference between measurements of production using a P90 ten year estimate and a P90 one year (you could substitute P90, P95, P75 etc.). In the first section titled "Wind Resource Analysis" I have put together a case study from an old credit report that had one and ten year production estimates for different projects with different probabilities. I have also compiled an analysis of the variability in wind after projects are operating relative to before they are operating. My key theme is that standard deviations underlying the ten year P90 are very subjective where standard deviation in things like wake effect, availability, turbulence, correlation to historic site, wind shear, losses and other factors. One of the main tools in analysis of wind production with different probabilities is use the NORMINV function in excel to understand data in wind studies. After the wind resource analysis, the effects of wind probabilities on debt sizing are evaluated in the second lesson set. The Final lesson set involves computing a wind project finance model that includes a partnership with a flip structure and a DRO.


Lesson Set 1: Wind Resource Analysis


The first lesson set addresses computing wind capacity factors from wind data and power curves as well as causes of uncertainty that are not "mean revering". The videos and files also cover a subject that I find one of the most difficult issues to explain -- i.e. the difference between one year P90 and ten-year or twenty-year P90. I have tried to explain this with file named "Wind Study" listed below. This file uses a nice old financial analysis report that listed P50, P75, P90 and P95 for a series of different wind farms. It also reported the production statistics on an 1-year basis and on a 10-year basis. Using the P90 etc. production statistics you can back out the standard deviation that is related to wind variation only as well as the variation that is only related to permanent effects. I have also compiled an analysis of the variability in wind after projects are operating relative to before they are operating. My key theme is that standard deviations underlying the ten year P90 are subjective. I demonstrate how to use the NORMINV function in excel to understand data in wind studies.


Videos associated with Lesson Set 1: Wind Resource Analysis


Subject

Excel File

Video Link





Working with P50 and P90 One Year and Ten Year

Wind Analysis.xlsm

https://www.youtube.com/watch?v=WXP6x74QmHE
Isolating Permanent Effects and Wind Movements

Wind Analysis.xlsm

https://www.youtube.com/watch?v=hXwlTeSpjuw
Different Production Constraints and

P90, P99 DSCR Constraint

https://www.youtube.com/watch?v=UAMed97wCRk
Debt Sizing with P99, P90 and P50

P90, P99 Debt Sizing

https://www.youtube.com/watch?v=47XBFymVzCQ
Acquiring EIA Data on Wind Forecasts

EIA Database

https://www.youtube.com/watch?v=NUdYzd1rEOQ
Wind Data Analysis with EIA Data - Part 1

Wind Generation Database

https://www.youtube.com/watch?v=PoAvXzsrZqQ
Wind Data Analysis with EIA Data - Part 2

Wind Generation Database

https://www.youtube.com/watch?v=Hhx3trJMZck
……………………………………………………………………………

……………………………………………………………

……………………………………………………………………………………….


Files associated with Lesson Set 1: Wind Resource Analysis


In this section I describe how to compute the P90, P99 etc. from power curves and historic wind data. This involves compiling hourly wind data and matching the wind data against power curves. In addition, actual wind variation is evaluated for a number of wind farms using the Generation Database below. Computing the P90 or P99 etc. can be derived from hourly wind data and power curves. You can use the LOOKUP function to evaluate the amount of power at different wind speeds and the NORINV function to evaluate probability distributions. The hourly distribution of wind can also be computed from a Wiebull function as illustrated in one of the files below.







Lesson Set 2: Debt Sizing with P50 and P99 etc.


It has become standard in the industry to apply different debt service coverage ratios to different wind production cases. A typical scenario is that a 1.35x coverage ratio is applied to the P50 case while either a 1.2x coverage is applied to a P90 ten-year case or a 1.0x coverage is applied to the P99 one year case. The modelling issues can be a little difficult as the debt may be sized on one scenario but the equity IRR is computed from a different scenario. The exercise below applies these concepts.




Computing P50 from Historic Wind Data and Power Curves







Wind Analysis