Please help me find the electricity cost (A35) and electricity generation kW (A36) for years 1-30. Formula used in B36 is: =$B$9*$B$11*365*24*(1-$B$12)^(B34-1)

15 kW $7,000 per kw 18% % 0.50% % Total cost $ end-of-life salvag value to deprecia $ 105,000.00 15% 89,250.00 $1.95 per W 12585 W 0.9 7 8 Assumptions for Case: 9 Size, kW 10 cost per kW 11 Efficiency rating 12 annual degradation 13 14 SIP rate 15 system rating 16 design factor 17 18 tax rate 19 tax credit 20 21 Electricity cost 22 annual increase 23 24 maintainance 25 annual increase 26 27 insurance 28 annual increase 29 30 discount rate 38% of profits 30% of system cost Notes: 1) Electricity generation for year 1 is in cell B36 based on a formula in that cell. For each succeeding year electricity generation declines by 0.5%, as stated in the case. 2) The hurdle rate or discount rate is in cell B30 and is based on an after-tax rate, since all of the cash flows are adjusted for taxes. 3) The formula for the Solar Incentive Program (SIP) is in cell B64. 4) Total cash flow for the payback method is the formula in cell 071. 5) Number of years for payback is in cell B74. 6) Initially assume straight line depreciation over 5 years; in question 3) you will use accelerated depreciation based on MACRS. $0.17 per kWh 3% $15 per kw 2% 0.30% of total cost 2% 3.53% 31 year 32 33 34 35 electricity cost 36 electricity generation kW 4 7 9 14 1 $0.17 23652 2 $0.18 3 $0.18 5 $0.19 6 $0.20 8 $0.21 10 $0.22 11 $0.23 12 $0.24 13 $0.24 15 $0.26 16 $0.26 17 $0.27 $0.19 $0.20 $0.22 $0.25