Spreadsheet: benjamin_rogers__1046__Nominal$ Email Format
Sheet: Caledonia

Unit Dispatch: | Caledonia |  |  | Capacity | 498 | MW
Dispatch and Revenue Output: | Enron Low Case |  |  | Heat Rate | 11602 | btu/kWh
Nominal Dollars
Region : TVA
 |  | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020
GDP Inflator (1998 = 1) |  | 1.03935 | 1.06533375 | 1.09196709375 | 1.1592740743 | 1.194052296529 | 1.22987386542487 | 1.266770081387616 | 1.304773183829244 | 1.343916379344122 | 1.384233870724445 | 1.425760886846179 | 1.468533713451564 | 1.512589724855111 | 1.557967416600764 | 1.604706439098787 | 1.652847632271751 | 1.702433061239903 | 1.7535060530771 | 1.806111234669413 | 1.860294571709495 | 1.91610340886078
Net Generation
Peak 1/ | (000 MWh) | 17.36519428571428 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 39.54426738636364 | 27.87415321956944 | 19.64806706663028 | 13.84962392987681 | 9.76238946806042 | 6.88136 | 0.2952156814777041 | 0.01266498171732699 | 0.0005433375391758825 | 2.330960186652448e-05 | 1e-06
Off-Peak | (000 MWh) | 9.009255714285715 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14.61235261363636 | 0.5392325687349302 | 0.0198990382228472 | 0.0007343245663430639 | 2.709842368742252e-05 | 1e-06 | 1e-06 | 1e-06 | 1e-06 | 1e-06 | 1e-06
All Hours | (000 MWh) | 26.37445 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 54.15662 | 35.8472708254862 | 23.72797315703517 | 15.70598534214481 | 10.39608288222163 | 6.88136 | 0.2952156814777041 | 0.01266498171732699 | 0.0005433375391758825 | 2.330960186652448e-05 | 1e-06
Capacity Factor |  | 0.006045746914599036 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.01241418184152134 | 0.00821717711610969 | 0.005439101877151338 | 0.00360024237180338 | 0.00238306717331005 | 0.001577396343364325 | 6.767152662652988e-05 | 2.903160981214123e-06 | 1.245478579101526e-07 | 5.343199709001413e-09 | 2.292274119308283e-10
Realized Energy Price
Peak | $/MWh | 34.35142941140866 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 37.24964857064716 | 39.78808339384972 | 42.49950377796105 | 45.39569809115564 | 48.489258038161 | 51.79363340486758 | 0 | 0 | 0 | 0 | 0
Off-Peak | $/MWh | 32.76165108065128 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 36.68868555449502 | 4.957609165455447 | 0.66990376640508 | 0.09052166906797382 | 0.01223186520479553 | 0.001652847632271751 | 0 | 0 | 0 | 0 | 0
All-Hours | $/MWh | 33.8083765890437 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 37.09829146240769 | 39.65869349673474 | 42.39580605650552 | 45.32182512086077 | 48.44978839530035 | 51.79363340486758 | 0 | 0 | 0 | 0 | 0
Realized Capacity Price
Annual | $/kW-yr | 57.16425 | 59.21904999869517 | 61.34771089882152 | 65.82456465109502 | 68.52330174842999 | 71.33268419464245 | 69.83653691527086 | 68.37177015531815 | 66.93772573292442 | 65.53375927107975 | 64.15923990807804 | 66.08401710532037 | 68.06653761848 | 70.1085337470344 | 72.21178975944542 | 74.37814345222878 | 75.91607511346034 | 77.48580689344772 | 79.08799632956945 | 80.72331455523518 | 82.39244658101356
Revenues
Energy Revenue | ($000) | 891.6773379289035 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2009.118073378858 | 1421.655926362399 | 1005.966548079632 | 711.8239210274897 | 503.6880157836421 | 356.4106371669196 | 0 | 0 | 0 | 0 | 0
Capacity Revenue | ($000) | 28467.7965 | 29491.08689935019 | 30551.16002761312 | 32780.63319624532 | 34124.60427071813 | 35523.67672893194 | 34778.59538380489 | 34049.14153734843 | 33334.98741499636 | 32635.81211699771 | 31951.30147422286 | 32909.84051844954 | 33897.13573400304 | 34914.04980602313 | 35961.47130020382 | 37040.31543920993 | 37806.20540650325 | 38587.93183293696 | 39385.82217212558 | 40200.21064850712 | 41031.43839734475
Total | ($000) | 29359.4738379289 | 29491.08689935019 | 30551.16002761312 | 32780.63319624532 | 34124.60427071813 | 35523.67672893194 | 34778.59538380489 | 34049.14153734843 | 33334.98741499636 | 32635.81211699771 | 33960.41954760172 | 34331.49644481194 | 34903.10228208267 | 35625.87372705062 | 36465.15931598746 | 37396.72607637685 | 37808.1917040877 | 38587.94290269101 | 39385.82223381798 | 40200.21064885094 | 41031.43839734667
Production Costs
Variable
Realized Fuel Cost
Total Delivered | ($/mmbtu) | 2.279904973280469 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2.556096056404113 | 2.657377013797376 | 2.762671056811892 | 2.872137197137696 | 2.985940747032504 | 3.104253568970992 | 0 | 0 | 0 | 0 | 0
Total Delivered | ($/MWh) | 26.4514575 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 29.65582644640052 | 30.83088811407715 | 32.05250960113158 | 33.32253576119155 | 34.64288454707111 | 36.01554990720145 | 0 | 0 | 0 | 0 | 0
SO2 Cost |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
SO2 Cost | $/mmBtu | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
SO2 Cost | $/MWh | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Variable O&M | $/MWh | 6.1425585 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 7.18583486970474 | 7.640923410246288 | 8.124833317196543 | 8.639389886267585 | 9.186534011592085 | 9.768329506726047 | 0 | 0 | 0 | 0 | 0
Total | $/MWh | 32.594016 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 36.84166131610525 | 38.47181152432344 | 40.17734291832812 | 41.96192564745913 | 43.8294185586632 | 45.78387941392749 | 0 | 0 | 0 | 0 | 0
 | ($000) | 859.6492452912 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1995.219852065012 | 1379.109446859483 | 953.3269142870865 | 659.0533891471636 | 455.6542680154455 | 315.0553564438241 | 0 | 0 | 0 | 0 | 0
Fixed
Fixed O&M 2/ | $/kW-yr | 10.18563 | 10.44027075 | 10.70127751875 | 11.36088592814 | 11.7017125059842 | 12.05276388116373 | 12.41434679759864 | 12.7867772015266 | 13.17038051757239 | 13.56549193309957 | 13.97245669109255 | 14.39163039182533 | 14.82337930358009 | 15.26808068268749 | 15.72612310316812 | 16.19790679626316 | 16.68384400015105 | 17.18435932015558 | 17.69989009976025 | 18.23088680275306 | 18.77781340683565
Total | ($000) | 5072.443740000001 | 5199.2548335 | 5329.2362043375 | 5657.72119221372 | 5827.452827980132 | 6002.276412819536 | 6182.344705204121 | 6367.815046360245 | 6558.849497751053 | 6755.614982683584 | 6958.283432164091 | 7167.031935129014 | 7382.042893182885 | 7603.504179978371 | 7831.609305377721 | 8066.557584539053 | 8308.554312075225 | 8557.810941437481 | 8814.545269680606 | 9078.981627771023 | 9351.351076604155
Total Costs | ($000) | 5932.0929852912 | 5199.2548335 | 5329.2362043375 | 5657.72119221372 | 5827.452827980132 | 6002.276412819536 | 6182.344705204121 | 6367.815046360245 | 6558.849497751053 | 6755.614982683584 | 8953.503284229104 | 8546.141381988497 | 8335.369807469971 | 8262.557569125536 | 8287.263573393166 | 8381.612940982877 | 8308.872602511483 | 8557.811267237747 | 8814.54527001901 | 9078.98162777138 | 9351.351076604155
Net Revenues
Net Revenues | ($000) | 23558.99391405899 | 24291.83206585019 | 25221.92382327562 | 27122.9120040316 | 28297.151442738 | 29521.40031611241 | 28596.25067860077 | 27681.32649098819 | 26776.13791724531 | 25880.19713431413 | 25006.91626337262 | 25785.35506282344 | 26567.7324746127 | 27363.31615792509 | 28177.89574259429 | 29015.11313539397 | 29499.31910157622 | 30030.13163545327 | 30571.27696379897 | 31121.22902107956 | 31680.08732074251
Energy Margin | ($000) | 32.02809263770348 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 13.89822131384517 | 42.54647950291519 | 52.63963379254551 | 52.77053188032619 | 48.03374776819663 | 41.35528072309552 | 0 | 0 | 0 | 0 | 0
Capacity Margin | ($000) | 23395.35276 | 24291.83206585019 | 25221.92382327562 | 27122.9120040316 | 28297.151442738 | 29521.40031611241 | 28596.25067860077 | 27681.32649098819 | 26776.13791724531 | 25880.19713431413 | 24993.01804205877 | 25742.80858332053 | 26515.09284082015 | 27310.54562604476 | 28129.8619948261 | 28973.75785467088 | 29497.65109442802 | 30030.12089149948 | 30571.27690244498 | 31121.2290207361 | 31680.0873207406
NPV (2000-2020) @ 14.0% Discount Rate | ($000) | 177765.5040383402
NPV (2000-2020) | ($/kW) | 356.9588434504822
Energy Margin @ 14.0 % Discount Rate | ($000) | 70.21874442001851
Energy Margin | ($/kW) | 0.1410014948193143
Capacity Margin @ 14.0 % Discount Rate | ($000) | 177579.8352400418
Capacity Margin | ($/kW) | 356.5860145382366
Notes
1: Peak reflects 6:00 a.m. to 10:00 p.m. weekdays