Spreadsheet: benjamin_rogers__1264__NewCo-7-15-00
Sheet: NewCo_CF

NewCo ANNUAL CASH FLOW AND IRR
GENCO CASH FLOW
('000 $) | Close | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Check
 | 2001-01-01 00:00:00 | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00
ENA (EBITDA less Power Contract Amortization)
FPLE
EBITDA from Plants | 0
Less Corporate G&A
FPLE: Plus Revenue to FPLE (Fees & Interests)
FPLE: [NAME] paid to FPLE
FPLE: Less Debt Service
FPLE: Less Capital Expenditure
ENA: Plus Property Tax Liability | 0
ENA: Less Property Tax Expense | 0
ENA: Less Principal Payments | 0
ENA: Less Interest Payments | 0
Plus Interest Income
Pre-Tax Cash Flow
NewCo's State Tax Benefit/(Expense) | 0
NewCo's Federal Tax Benefit/(Expense) | 0
After-Tax Cash Flow
After-Tax Cash Flow with Development Pipeline
(Innclude after-tax interest income in 2001, 2002 and
after-tax interest expense of Construction Loan in 2003, 2004)
IRR Calculation
('000 $) | Close | 2001 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001
Equity's Contribution |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Equity's After-Tax Cashflow
Salvage Value | 0
Equity's Net Cashflow
IRR
Corporate Cash Flow with Development Pipeline
Capital Expenditure
Cash Flow from Operations |  | 201450.9593250846 | 250738.8462614225 |  |  | 544998.1961417663 | 624011.1776884384 | 649646.9494858205 | 682402.363827915 | 736112.9442772025 | 813179.192920902 | 831685.4985398211 | 833393.6758848028 | 852952.8658789898 | 900664.9348883079 | 942841.9062619964 | 1025250.479263545 | 1197364.542558173 | 1565128.568086281 | 1857613.325191744 | 2132773.253029164
Debt Proceeds
Contstruction Loan
IPO Proceeds | 500000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Net Capital Sources/(Uses)
Cumulative Capital
After-tax Interest Income with Development Pipeline |  |  |  | 0 | 0
After-tax Interest Income with existing assets
Cash Balance with existing assets |  | 181749.9343247516 | 347721.7569537251 | 532676.9045980975 | 853905.2565179772 | 1212299.498056546 | 1616975.799116305 | 2052099.816328432 | 2401197.262090153 | 2757273.415866899 | 3132920.599081423 | 3541388.70543828 | 3994394.062387568 | 4475353.857725263 | 4993710.100184222 | 5539988.866728263 | 6097551.586261712 | 6661966.024602908 | 7262502.54290211 | 7911288.972925494 | 8603311.355673052
Equity's After-Tax Cashflow
NOL Carryforward: Yes |  | 165109.9985214757 | 134136.5004616834 | 136186.4395326964 | 243049.8991829966 | 247403.3578447067 | 256635.6781417101 | 254709.6640323063 | 248326.9235509871 | 250442.3679838908 | 268123.7885460444 | 228578.3357830128 | 215298.5337703558 | 214631.0026579564 | 221180.0136605365 | 216593.4291946139 | 194696.7643679787 | 167960.1188302593 | 168344.2055511047 | 177984.7665636711 | 180038.3923431175
NOL Carryforward: No |  | 205928.1620675198 | 273572.1429019884 | 229592.8296179794 | 263163.3432328547 | 251822.0745410583 | 228042.4945422992 | 208063.127462611 | 202145.887819123 | 187796.8573877338 | 184856.3529852738 | 197719.6810230689 | 215298.5337703558 | 214631.0026579564 | 221180.0136605365 | 216593.4291946139 | 194696.7643679787 | 167960.1188302593 | 168344.2055511047 | 177984.7665636711 | 180038.3923431175