ENERGY LIFE CYCLE COST SPREADSHEET 28-Oct-09 ------------------------------------P R O J E C T D A T A-----------------------------------------------------------------------PROJECT: Facility Name (Firm Name) ALT. No.: Description (Analyst's Name) -------------------D I S C O U N T & E S C A L A T I O N Real Rates as of November 2004------------------------Enter 1 or 0 for each fuel type: 1 = Yes 0 = No IOU Electricity Source* 1 0 POU Electricity Source** Natural Gas Fuel? 1 Propane Fuel? 0 Oil Fuel? 0
Years: Real Discount Rate (i) . . . . . . . . . . . 2010 - 2,060 . . . . . . . . Electricity. . . . . . . . . . . . . . . . . . . . . 2010 - 2,020 . . . (Investor Owned Utility) 2,021 - 2,035 . . . 2,036 - 2,060 . . . Natural Gas . . . . . . . . . . . . . . . . . . . . 2010 - 2,020 . . . And other fossil fuels 2,021 - 2,035 . . . 2,036 - 2,060 . . . Maintenance . . . . . . . . . . . . . . . . . . 2010 - 2,060 . . . . . . . . Inflation (Nominal , not used) . . . . . 2010 - 2,060 . . . . . . . .
Rate: 3.0% 1.0% 2.0% 2.0% 1.0% 1.0% 1.0% 2.0% 3.0%
* IOU = Invester Owned Utility ** POU = Publicly Owned Utility $0 =50-year LCC ---------------------A N N U A L R E A L C A S H F L O W S-------------------------------------------------------------(Begin) Year
First & Replace. Costs
2,010
$0
2,010 2,011 2,012 2,013 2,014 2,015 2,016 2,017 2,018 2,019 2,020 2,021 2,022 2,023 2,024 2,025 2,026 2,027 2,028 2,029 2,030 2,031 2,032 2,033 2,034 2,035 2,036 2,037 2,038 2,039 2,040 2,041 2,042 2,043 2,044 2,045 2,046 2,047 2,048 2,049 2,050 2,051 2,052 2,053 2,054 2,055 2,056 2,057 2,058 2,059
$0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Totals:
$0 1st+Repl
Annual Maint. Costs
Annual Nat.Gas Costs
$0 --
$0 --
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
$0 --
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
$0 Maint
Annual Electric Costs
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
$0 Fuel
$0 Elec
Total Annual Costs
Present Worth Factor $0 (1+i)^-n $0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
$0 Total Annual
1.00 0.97 0.94 0.92 0.89 0.86 0.84 0.81 0.79 0.77 0.74 0.72 0.70 0.68 0.66 0.64 0.62 0.61 0.59 0.57 0.55 0.54 0.52 0.51 0.49 0.48 0.46 0.45 0.44 0.42 0.41 0.40 0.39 0.38 0.37 0.36 0.35 0.33 0.33 0.32 0.31 0.30 0.29 0.28 0.27 0.26 0.26 0.25 0.24 0.23
Present Worth of Annual Costs $0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
Present Worth of Cumulative Costs $0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
$0 =50-year LCC