What is the correct amount for year 1 for each below? Show formulas on excel.

Depreciation

Tax savings from depreciation

Net savings

12 year NPV of net savings

30 year NPV of net savings

Tax incentive

12 year NPV W/ Tax incen

30 year NPV W/ Tax incen

Solar Incentive Program (SIP)

Solar Incentive Program Tax

Solar Incentive Program Net

12 year NPV W/ Tax incen and SIP

30 year NPV W/ Tax incen and SIP

Total CF

Cumulative CF

Payback

WELLS FARGO: SOLAR ENERGY FOR LOS ANGELES BRANCHES Pro Forma Economic Model Size, kW cost per kW Efficiency rating annual degradation Time Electricity Generation Costs 15 kW $7,000 $ per kW 18% % 0.50% % 8760 23652 KWH Total cost end-of-life s value to dep SIP rate system rating design factor $1.95 per W 12585 W 0.9 tax rate tax credit 38% of profits 30% of system cost Electricity cost annual increase $0.17 per kWh 3% maintainance annual increase $15 per kW 2% insurance annual increase 0.30% of total cost 2% hurdle rate 3.53% electricity cost electricity generation electricity cost savings year 1 2 3 $0.17 $0.18 $0.18 $23,652.00 $ 23,533.74 $ 23,416.07 $ $4,020.84 $4, 120.76 $4,223.16 23 $4 maintainance cost per kW total maint cost $15 $15 $15.30 $30.30 $15.61 $45.91 electricity cost electricity generation electricity cost savings 1 $0.17 $23,652.00 $4,020.84 maintainance cost per kW total maint cost $15 $15 insurance cost total insurance 0.30% 315.00 $ total cost savings tax on cost savings $3,690.84 $1,402.52 Depreciation Tax savings from depreciation Net savings 12 year NPV of net savings 30 year NPV of net savings Tax incentive 12 year NPV W/ Tax incen 30 year NPV W/ Tax incen Solar Incentive Program (SIP) Solar Incentive Program Tax Solar Incentive Program Net 8 9 12 year NPV W/ Tax incen and SIP 0 30 year NPV W/ Tax incen and SIP 1 2 3 Total CF 4 5 Cumulative CF 6 Payback