Duke
<br />Energy
<br />1 QUM / : .7 rl U U1 IIIQ: RVVV *U VC1111LJ
<br />Cash f low and 1 state me nt
<br />BENEFIT DRIVERS
<br />Net Savings (as a result of changes /improvements)
<br />Energy efficiency and demand management
<br />Total annual benefits
<br />Implementation filter
<br />Total benefits realized
<br />YEAR
<br />0
<br />1
<br />2
<br />3
<br />4
<br />5
<br />$0 $0 $0
<br />$34,01
<br />$34,000
<br />$34,000
<br />$34,000
<br />$34,000
<br />$73,890
<br />$34,000
<br />$34,000
<br />$34,000
<br />$34,000
<br />$34,000
<br />$23,222
<br />100%
<br />100%
<br />100%
<br />100%
<br />100%
<br />($63,862)
<br />$34,000
<br />1 $34,000
<br />1 $34,000
<br />1 $34,000
<br />$34,000
<br />Benefits Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
<br />Annual benefitflow ($119,000) $34,000 $34,000 $34,000 $34,000 $34,000
<br />Cumulative benefit flow (119,000) (85,000) (51,000) (17,000) 17,000 1 51,000
<br />Discounted benefit flow
<br />Year 0
<br />Year 1
<br />Costs Year 0 Year 1
<br />Ongoing costs (administrative, maintenance, support, training)
<br />Initial investment 1 $119,000
<br />Year 2 Year 3 Year 4M��
<br />Year 4
<br />Total 1 $119,000 $0
<br />$0 $0 $0
<br />$0
<br />Benefits Year 0 Year 1 Year 2 Year 3 Year 4 Year 5
<br />Annual benefitflow ($119,000) $34,000 $34,000 $34,000 $34,000 $34,000
<br />Cumulative benefit flow (119,000) (85,000) (51,000) (17,000) 17,000 1 51,000
<br />Discounted benefit flow
<br />Year 0
<br />Year 1
<br />Year 2
<br />Year 3
<br />Year 4
<br />Year 5
<br />Discounted costs
<br />$119,000
<br />$108'182
<br />$98,347
<br />$89,406
<br />$81,279
<br />$73,890
<br />Discounted benefits
<br />$0
<br />$30,909
<br />$28,099
<br />$25,545
<br />$23,222
<br />$21,111
<br />Total discounted benefitflow
<br />($119,000)
<br />($77,273)
<br />($70,248)
<br />($63,862)
<br />($58,056)
<br />($52,778)
<br />Total cumulative discounted benefit flow
<br />($119,000)
<br />($196,273)
<br />($266,521)
<br />($330,382)
<br />($388,439)
<br />($441,217)
<br />Cost of capital
<br />Net present val ue $8,988
<br />Return on investment
<br />Payback (in years) 3.50
<br />Rev A 2012 -05 -15
<br />14% 1 18% 1 20% 1 22% 1 23%
<br />Page 28
<br />Final Draft
<br />G -2 Page 352
<br />Initial investment
<br />Net Investment
<br />Energy efficiency and demand management
<br />Year 0
<br />$119,000
<br />Year 1
<br />$119,000
<br />$119,000
<br />Year 2
<br />$119,000
<br />$119,000
<br />Year 3
<br />$119,000
<br />$119,000
<br />Year 4
<br />$119,000
<br />$119,000
<br />Year 5
<br />$119,000
<br />$119,000
<br />Net Investment
<br />Total
<br />$119,000
<br />$119,000
<br />$119,000
<br />$119,000
<br />$119,000
<br />$119,000
<br />Cost of capital
<br />Net present val ue $8,988
<br />Return on investment
<br />Payback (in years) 3.50
<br />Rev A 2012 -05 -15
<br />14% 1 18% 1 20% 1 22% 1 23%
<br />Page 28
<br />Final Draft
<br />G -2 Page 352
<br />
|