Past Savings Spreadsheet
This spreadsheet gives you a monthly analysis of how Price Protection would have generated savings last year. You may change the user selections (using the 3 drop downs at the top) to see how savings change and how they are calculated
| Fuel Type: |
|
| Monthly Gallons to protect: |
|
| Term of price protection: |
|
| |
Jan
2009 |
Feb
2009 |
Mar
2009 |
Apr
2009 |
May
2009 |
Jun
2009 |
Jul
2009 |
Aug
2009 |
Sep
2009 |
Oct
2009 |
Nov
2009 |
Dec
2009 |
| Monthly Gallons protected |
|
|
|
|
|
|
|
|
|
|
|
|
| Monthly Average NYMEX settelement price |
|
|
|
|
|
|
|
|
|
|
|
|
| Protected Starting Price (Dec 2008) |
|
|
|
|
|
|
|
|
|
|
|
|
| Increase from protected price |
|
|
|
|
|
|
|
|
|
|
|
|
| Monthly payout |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Total Monthly Payouts: |
|
| Price Protection Premium: |
|
| Net Savings: |
|
| Per Gallon savings |
|