A B E 1 Production Plant Cash Flows Year Natural Gas Plant Cash Flows Nuclear Plant Cash Flows (In Wind Plant Cash Flows (In. Solar Plant Cash Flows (In Coal Plant Cash Flows (In Millions N In Millions S Millions S Millions S Millions S S) -650 5500 -15 -300 1800 0 0 0 0 0 2 0 0 0 42.5 0 0 4 85 0 3 97 5 85 680 97 6 85 680 97 10 85 580 8 650 9 680 10 680 11 680 12 680 13 680 14 580 15 680 16 580 20 17 680 21 18 680 22 19 680 23 20 680 24 21 680 25 22 680 26 23 680 27 24 180 28 25 680 29 26 680 30 27 580 31 28 680 32 29 680 33 30 680 D D D D O O O O O N N N N N N N N N N N N N N N N N N 19 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 9 34 35 WACC MUST ENTER Cost of Capital for NPV computations in spreadsheet below to calculate 36 37 =NPV(B35,B4:B33)+B3 38 NPV $837.50 $12,150.00 $23.00 $243.00) $819.00 39 IRR 7.99% 7.83% 10.18% -12.12% 2.33% 40 41 42 43