Spreadsheet: james_steffes__12981__Savings_Analysis
Sheet: Stranded Costs

Standed Costs Assessment
 | Quantity (MWh) from fig. 4 of DWR Presentation |  |  | Total Annual Cost ($million) |  | Drop in Gas Costs Late May to 062201 | Reduction in Cost due to gas curve. [NAME]: | Total Annual Cost Adjusted for Gas Indx ($million) |  | Forward Curve | Market Value ($MILLION) |  | Stranded Cost  ($MILLION) |  | Discounted Stranded Cost  ($MILLION)
Year | Executed | Executed LT and AIP | DWR Overall-Price | Executed | Executed LT and AIP | $/MMBtu | 8500 | Executed | Executed LT and AIP |  | Executed | Executed LT and AIP | Executed | Executed LT and AIP | Executed | Executed LT and AIP
2001 | 18000000 | 20000000 | 138 |  |  | 3.649200000000001 | 33.44510526736851 | 2450.554894732632 | 2726.554894732632 | 75.94362001347592 | 1366.985160242567 | 1518.872400269518 | 1083.569734490065 | 1207.682494463113 | 1045.817348271604 | 1165.60592614543
2002 | 30000000 | 45000000 | 106 |  |  | 0.9718461538461541 | 390.9858157263081 | 2789.014184273692 | 4379.014184273692 | 51.39626040082226 | 1541.887812024668 | 2312.831718037002 | 1247.126372249024 | 2066.18246623669 | 1121.262738240403 | 1857.657300293429
2003 | 50000000 | 68000000 | 89 |  |  | 0.3504615384615389 | 637.8079723553147 | 3812.192027644685 | 5414.192027644685 | 37.63150532773381 | 1881.57526638669 | 2558.942362285899 | 1930.616761257995 | 2855.249665358787 | 1616.929000460923 | 2391.326999806367
2004 | 65000000 | 87000000 | 75 |  |  | 0.2977692307692311 | 1253.97211469443 | 3621.02788530557 | 5271.02788530557 | 35.7085251737398 | 2321.054136293087 | 3106.641690115363 | 1299.973749012483 | 2164.386195190207 | 1014.208887107472 | 1688.603109072135
2005 | 60000000 | 83000000 | 64 |  |  | 0.3027692307692311 | 1275.028220986122 | 2564.971779013878 | 4036.971779013878 | 35.71052988116942 | 2142.631792870166 | 2963.973980137062 | 422.3399861437128 | 1072.997798876816 | 306.9396417329754 | 779.8114570554832
2006 | 62500000 | 85000000 | 61 |  |  | 0.3027692307692311 | 1275.028220986122 | 2537.471779013878 | 3909.971779013878 | 35.9164995911913 | 2244.781224449456 | 3052.90246525126 | 292.6905545644222 | 857.0693137626181 | 198.1515342152852 | 580.2360096780108
2007 | 62500000 | 82000000 | 60 |  |  | 0.3027692307692311 | 1275.028220986122 | 2474.971779013878 | 3644.971779013878 | 36.20809324545766 | 2263.005827841104 | 2969.063646127528 | 211.9659511727746 | 675.9081328863504 | 133.6757985867662 | 426.2597786812758
2008 | 62500000 | 82000000 | 60 |  |  | 0.3027692307692311 | 1275.028220986122 | 2474.971779013878 | 3644.971779013878 | 36.5041596749445 | 2281.509979684031 | 2993.341093345449 | 193.4617993298471 | 651.6306856684291 | 113.6527260043446 | 382.812545064918
2009 | 62500000 | 82000000 | 60 |  |  | 0.3027692307692311 | 1275.028220986122 | 2474.971779013878 | 3644.971779013878 | 36.91420029220627 | 2307.137518262892 | 3026.964423960915 | 167.8342607509862 | 618.0073550529637 | 91.84662565622989 | 338.2020449124108
2010 | 62500000 | 82000000 | 59 |  |  | 0.3027692307692311 | 1275.028220986122 | 2412.471779013878 | 3562.971779013878 | 37.37831329110632 | 2336.144580694145 | 3065.021689870719 | 76.32719831973327 | 497.9500891431599 | 38.90987700972614 | 253.8436776413599
10 Year Average |  |  |  |  |  |  |  | 2761.261966603985 | 4023.561966603986 |  | 2068.67132987488 | 2756.855546940072 | 692.5906367291043 | 1266.706419663913 | 568.139417728573 | 986.4358848350819
10 Year sum |  |  |  |  |  |  |  | 27612.61966603985 | 40235.61966603986 |  | 20686.7132987488 | 27568.55546940072 | 6925.906367291043 | 12667.06419663914 | 5681.39417728573 | 9864.35884835082
6-year average |  |  |  |  |  |  |  | 2962.538758330722 | 4289.622091664056 |  | 1916.485898711106 | 2585.694102682684 | 1046.052859619617 | 1703.927988981372 | 883.8848583381105 | 1410.540133675142
Source: Stranded Cost Analysis 062601