Spreadsheet: benjamin_rogers__1195__Value_Feb_2_24_00
Sheet: New Alb.

NEW ALBANY POWER 1, LLC, MS
COPIED TO THE CONSOLIDATED FILE
Plant Summary
Capacity |  | 458
Heat Rate |  | 11411
No. of Turbines |  | 6
Operating Hours |  | 1200
Start Up MMBTU's |  | 0
Book Income 1999 Costs
 |  | 1999
Fixed Operating Cost |  | 701.45
Variable Operating Cost |  | 482.02
Start Fuel |  | 0
Major [NAME]. |  | 1349.28
Insurance |  | 250.64
SG&A Cost |  | 334.105
Utility: Start Up Power |  | 77.052
Property Taxes & Other |  | 0 | 678.0867770848049 | 664.3880543154149 | 650.689331546025 | 636.990608776635 | 623.291886007245 | 609.5931632378549 | 589.0450790837699 | 568.4969949296849 | 547.9489107756 | 520.55146523682 | 1197.56500681212 | 1114.400770227945 | 1014.603686326935 | 914.8066024259249 | 815.0095185249149 | 681.946739990235 | 532.2511141387199 | 382.555488287205 | 332.6569463367 | 332.6569463367
Debt Service
Admin Fees |  | 126.9896193771626
O&M Fees |  | 200
Variable Revenue
Variable Energy Payment |  | 1.408748180494906
Start Payment/Turbine |  | 1874
Consolidated Check
 |  | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021
EGC EITDA |  | 4099.074795529242 | 16175.06760927457 | 16435.53234188312 | 16383.84119168491 | 20929.94965884431 | 24485.22500149138 | 24740.58303724961 | 24994.49828199015 | 25785.35099819452 | 26037.12441691849 | 26864.77888883702 | 26490.06939893402 | 27405.15979855477 | 27727.97580969796 | 28038.5147810571 | 28332.74500671686 | 28644.40974477815 | 28959.81055614217 | 29271.1051473904 | 29457.8087532586 | 29586.60103820424 | 29996.45436930041
New Albany |  | 7761.884690311421 | 15198.27924495672 | 15389.70894838735 | 15339.27058123783 | 20365.37819830858 | 24255.70607841371 | 24507.36487727463 | 24757.76764867923 | 25538.44995594941 | 25786.67831544442 | 26603.84441905301 | 26151.21941017582 | 27054.57702055283 | 27374.22553737325 | 27681.72116491864 | 27976.13686354285 | 28289.76660345502 | 28604.95928138433 | 28904.01534519071 | 29086.02056677889 | 29199.70383820621 | 0
 |  | -3662.809894782179 | 976.7883643178557 | 1045.823393495768 | 1044.570610447081 | 564.571460535728 | 229.5189230776668 | 233.2181599749747 | 236.7306333109118 | 246.9010422451138 | 250.4461014740737 | 260.9344697840097 | 338.8499887581966 | 350.5827780019426 | 353.7502723247126 | 356.7936161384641 | 356.6081431740167 | 354.643141323133 | 354.8512747578352 | 367.0898021996945 | 371.7881864797055 | 386.8971999980313 | 29996.45436930041 | 0
Plus : L/C |  | 32.21730749343967 | 195.2968506444801 | 128.8692299737587 | 128.8692299737587 | 128.8692299737587 | 122.079170019014 | 122.079170019014 | 122.079170019014 | 122.079170019014 | 122.079170019014 | 122.079170019014 | 109.757367697464 | 104.6043349769951 | 99.57001724149211 | 94.54300218678941 | 92.57922355187993 | 90.31053027534941 | 84.78450643870156 | 67.21647282024973 | 62.70023110549673 | 50.60464294515286 | 50.60464294515286 | #REF!
Less:  Interest |  | -50.60586167320051 | -199.6921927070935 | -202.907806689915 | -202.269644341789 | -258.3944402326458 | -302.2867284134738 | -305.4392967561679 | -308.5740528640759 | -318.3376666443769 | -321.4459804557839 | -331.6639368992225 | -327.0378938140003 | -338.3353061549972 | -342.3206890086169 | -346.1545034698407 | -349.7869753915663 | -353.6346882071377 | -357.5285253844712 | -361.3716684863013 | -363.6766512747975 | -365.266679484003 | -370.3265971518569 | #REF!
Difference |  | -3681.19844896194 | 972.3930222552424 | 971.7848167796116 | 971.1701960790506 | 435.0462502768409 | 49.31136468320699 | 49.85803323782073 | 50.23575046584989 | 50.64254561975088 | 51.07929103730379 | 51.34970290380119 | 121.5694626416603 | 116.8518068239406 | 110.9996005575878 | 105.1821148554128 | 99.40039133433038 | 91.31898339134466 | 82.10725581206555 | 72.93460653364298 | 70.81176631040472 | 72.2351634591812 | 29676.7324150937 | #REF!
 |  |  | 1999-07-30 00:00:00 | 1999-12-31 00:00:00 | 2000-12-31 00:00:00 | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00
 |  | 99 MW's |  | 1292 | 1292 | 1292 | 1292 | 1292
 |  | 00 MW's |  |  | 1584 | 1584 | 1584 | 1584
 |  | 99 Revenue @ 3.25 |  | 25194 | 50388 | 50388 | 50388 | 25194
 |  | 00 Revenue @ 3.25 |  | 0 | 30888 | 61776 | 61776 | 30888
 |  | Total Rev. @ 3.25 |  | 25194 | 81276 | 112164 | 112164 | 56082
 |  | 99 Revenue @ 4.00 |  | 31008 | 62016 | 62016 | 62016 | 31008
 |  | 00 Revenue @ 4.00 |  | 0 | 38016 | 76032 | 76032 | 38016
 |  | Total Rev. @ 4.00 |  | 31008 | 100032 | 138048 | 138048 | 69024
 |  | Difference in Capacity | 0 | 5814 | 18756 | 25884 | 25884 | 12942
 |  | NPV @ 8% Discount | 73008.08536396537
 |  | 50% of CF @ $4.00 | 0 | 8791.3536316796 | 27194.12270619485 | 35696.3750285108 | 33404.15588368355 | 30365.59301152745
 |  | NPV @ 8% | 109767.0692819185
 |  | 50% of CF @ $3.25 | 0 | 6326.11196403365 | 19903.3945854278 | 26238.14707600175 | 24037.1585446246 | 26065.43971921635
 |  | NPV @ 8% | 82742.95739519234
 |  | Difference in Revenue | 27024.11188672614
 |  | Net Difference in Cash Flows to Enron (50% Equity) of Capacity Price Increase to $4.0
 |  |  | -45983.97347723923