|
117,500.00$
<br />2.96$
<br />39.68
<br />33.30
<br />52,000.00
<br />35%
<br />7.50%
<br />0.50%
<br />0.0700$
<br />2.00%
<br />0.14$
<br />0.0850$
<br />3.5%
<br />3.00%
<br />$76,002.60
<br />15.86%
<br />Build Cost O&M Power Sales Made in Minnesota
<br />(PBI)
<br />State
<br />Depreciation
<br />Federal
<br />Depreciation
<br />Federal Tax
<br />Credit Net Cash Flow Cumulative Cash Flow
<br />0 (117,500.00)$ (117,500.00)$ (117,500.00)$ 0 -$ -$
<br />1 -$ 3,640.00$ 7,280.00 1,498.13$ 6,991.25$ 35,250.00$ 54,659.38$ (62,840.63)$ 1 0.015$ 780.00$
<br />2 -$ 3,694.24$ 7,243.60 2,397.00$ 11,186.00$ 24,520.84$ (38,319.79)$ 2 0.017$ 857.59$
<br />3 -$ 3,749.28$ 7,207.38 1,438.20$ 6,711.60$ 19,106.46$ (19,213.33)$ 3 0.018$ 938.30$
<br />4 -$ 3,805.14$ 7,171.35 862.92$ 4,026.96$ 15,866.37$ (3,346.96)$ 4 0.020$ 1,022.25$
<br />5 -$ 3,861.84$ 7,135.49 862.92$ 4,026.96$ 15,887.21$ 12,540.25$ 5 0.022$ 1,109.53$
<br />6 -$ 3,919.38$ 7,099.81 431.46$ 2,013.48$ 13,464.13$ 26,004.39$ 6 0.024$ 1,200.26$
<br />7 -$ 3,977.78$ 7,064.31 11,042.09$ 37,046.48$ 7 0.026$ 1,294.55$
<br />8 -$ 4,037.05$ 7,028.99 11,066.04$ 48,112.52$ 8 0.028$ 1,392.53$
<br />9 -$ 4,097.20$ 6,993.85 11,091.05$ 59,203.57$ 9 0.030$ 1,494.32$
<br />10 -$ 4,158.25$ 6,958.88 11,117.13$ 70,320.69$ 10 0.032$ 1,600.03$
<br />11 -$ 4,220.21$ 4,220.21$ 74,540.90$ 11 0.035$ 1,709.82$
<br />12 -$ 4,283.09$ 4,283.09$ 78,823.99$ 12 0.037$ 1,823.80$
<br />13 -$ 4,346.91$ 4,346.91$ 83,170.90$ 13 0.040$ 1,942.12$
<br />14 -$ 4,411.68$ 4,411.68$ 87,582.58$ 14 0.042$ 2,064.92$
<br />15 -$ 4,477.41$ 4,477.41$ 92,059.99$ 15 0.045$ 2,192.35$
<br />16 -$ 4,544.12$ 4,544.12$ 96,604.11$ 16 0.048$ 2,324.56$
<br />17 -$ 4,611.83$ 4,611.83$ 101,215.94$ 17 0.051$ 2,461.71$
<br />18 -$ 4,680.55$ 4,680.55$ 105,896.49$ 18 0.055$ 2,603.97$
<br />19 -$ 4,750.29$ 4,750.29$ 110,646.78$ 19 0.058$ 2,751.49$
<br />20 -$ 4,821.07$ 4,821.07$ 115,467.84$ 20 0.061$ 2,904.45$
<br />21 -$ -$ -$ 115,467.84$ 21 0.169$ 7,955.93$
<br />22 -$ -$ -$ 115,467.84$ 22 0.175$ 8,193.21$
<br />23 -$ -$ -$ 115,467.84$ 23 0.181$ 8,437.58$
<br />24 -$ -$ -$ 115,467.84$ 24 0.188$ 8,689.23$
<br />25 -$ -$ -$ 115,467.84$ 25 0.194$ 8,948.38$
<br />(117,500.00)$ -$ 84,087.32$ 71,183.65$ 7,490.63$ 34,956.25$ 35,250.00$ 115,467.84$ 76,692.88$
<br />City Current Power Rate:
<br />Estimated Utility Inflation Rate:
<br />Cash Flow:2017 Made in Minnesota Solar - Investor Owned, 20 Yr PPA
<br />Savings Per
<br />kWh
<br />Total Power
<br />Savings
<br />Investor Benefits City Benefits
<br />Figures for solar offset account for module degradation and utility inflation as listed above. Prospective customer is assumed to be a taxable entity and able to take full
<br />advantage of the tax benefits. Cedar Creek Energy has used good faith efforts to represent the available tax incentives for the proposed solar system. Your Company's
<br />specification tax situation may impact your ability to benefit from these incentives. Please consult your tax advisor regarding your specific situation. Depreciation tax savings are
<br />based on 5-Year MACRS, on an adjusted basis listed above.
<br />State Tax Rate:
<br />Module Degradation Rate:
<br />Year 1 Solar Power Rate ($/kWh):
<br />Solar Power Esclation Rate:
<br />2858 Centerville Road, Little Canada, MN 55117
<br />Xcel
<br />51-5317475-9
<br />304432351
<br />Value of Production Incentive ($/kWh):Meter #12231739
<br />Investor Build Cost:
<br />System Price Per Watt:
<br />System Size (DC):
<br />System Size (AC):
<br />Estimated Year 1 Production:
<br />Federal Tax Rate:
<br />Year
<br />Customer:
<br />Address:
<br />Utility:
<br />Account #
<br />Premise #
<br />City of Little Canada
<br />Outflows Inflows Totals
<br />Year
<br /> (Investor) Discount Rate
<br /> (Investor) Net Present Value (NPV)
<br /> (Investor) Internal Rate of Return (IRR)
|