储能调峰项目经济性分析

序,项目,备注,合计,建设期,经营期,,,,,,,,,,,

,,,,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028

,,,,0,1,2,3,4,5,6,7,8,9,10,11,12

1,年利用电量（万kWh）,注意电池更换情况,1580.37,,143.70,138.67,133.82,129.13,124.61,120.25,143.70,138.67,133.82,129.13,124.61,120.25

1.1,峰电量,,,,143.70,138.67,133.82,129.13,124.61,120.25,143.70,138.67,133.82,129.13,124.61,120.25

1.2,尖峰电量,,,,,,,,,,,,,,,

1.3,平电量,,,,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

1.4,谷电量,,,,143.70,138.67,133.82,129.13,124.61,120.25,143.70,138.67,133.82,129.13,124.61,120.25

2,现金流入,,,,141.975,137.006,132.211,127.584,123.118,118.809,141.975,137.006,132.211,127.584,123.118,118.809

3,电费收入(税前),,1561.41,,141.98,137.01,132.21,127.58,123.12,118.81,141.98,137.01,132.21,127.58,123.12,118.81

3.1,峰电收入,1.04,1561.41,,141.975,137.006,132.211,127.584,123.118,118.809,141.975,137.006,132.211,127.584,123.118,118.809

3.2,尖峰电收入,0,0.00,,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000

3,削减容量,,,,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000

4,需求侧响应,,,,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000,0.000

5,补贴,,,0.000,,,,,,,,,,,,

6,资产残值（电池回收）,,92.42,,,,,,,46.20879121,,,,,,46.20879121

7,现金流出,,1041.19,¥474.07,48.21,46.60,45.04,49.56,59.92,404.90,62.66,60.21,61.76,69.93,67.43,64.96

7.0,谷电支出,0.32,,,45.98,44.37,42.82,41.32,39.88,38.48,45.98,44.37,42.82,41.32,39.88,38.48

7.0,平电支出,0.6117,,,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

7.1,场地租赁费用,,0.00,,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

7.2,偿还本金,,0.00,,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

7.3,偿还利息,,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

7.4,偿还手续费,,0.00,,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00

7.5,缴纳增值税,,48.65,,0.00,0.00,0.00,0.00,12.44,0.00,0.00,0.00,0.00,12.45,12.09,11.67

7,营业税金及附加,,5.84,,0.00,0.00,0.00,0.00,1.49,0.00,0.00,0.00,0.00,1.49,1.45,1.40

8,所得税,,74.54,,0.00,0.00,0.00,6.01,3.89,5.27,14.46,13.62,11.50,7.24,6.58,5.97

9,运维费用,,2.84,,0.24,0.24,0.24,0.24,0.24,0.24,0.24,0.24,0.24,0.24,0.24,0.24

10,电池和pcs更换费用,,358.93,,,,,,,358.9285714,,,,,,0.00

11,保险费用,,5.69,,0.47,0.47,0.47,0.47,0.47,0.47,0.47,0.47,0.47,0.47,0.47,0.47

12,厂用电,,38.98,,1.51,1.51,1.51,1.51,1.51,1.51,1.51,1.51,6.72,6.72,6.72,6.72

13,流动资金,,0.00,0,,,,,,,,,,,,

14,折旧,,431.28,,35.94,35.94,35.94,35.94,35.94,35.94,35.94,35.94,35.94,35.94,35.94,35.94

,所得税前利润,,,,57.83,54.47,51.23,48.10,31.15,42.17,57.83,54.47,46.02,28.95,26.32,23.88

,税后净现金流,,,(474.07),93.77,90.41,87.17,78.03,63.20,(239.89),79.31,76.79,70.45,57.65,55.68,100.06

,税后累计现金流,,,(474.07),(380.30),(289.89),(202.73),(124.70),(61.51),(301.39),(222.08),(145.29),(74.83),(17.18),38.50,138.56

,,,,,,,,,,,,,,,,,

,税后净现金流现值,,,(474.07),86.82,77.51,69.20,57.35,43.01,(151.17),46.28,,,,,

,税后累计现金流现值,,,(474.07),(387.25),(309.74),(240.54),(183.19),(140.18),(291.35),(245.07),,,,,

,,,,,,,,,,,,,,,,,

,电站净现值NPV,¥-168.34,电站现值,¥305.73,,,,,,,,,,,,

,IRR,4.38%,,,,,,,,,,,,,,

,静态回收期,0.00,,,,,,,,,,,,,,

,动态回收期,#DIV/0!,,,,,,,,,,,,,,

,LCOE,0.89,,,,,,,,,,,,,,

,增值税,,,,,,,,,,,,,,,

,进项税,注意更换设备情况,,52.59,6.68,6.45,6.22,6.00,5.79,57.74,6.68,6.45,6.22,6.00,5.79,5.59

,总进项税,,,52.59,59.27,65.72,71.94,77.94,83.74,141.48,148.16,6.45,12.67,18.67,24.47,30.06

,销项税,,,,20.63,19.91,19.21,18.54,17.89,17.26,20.63,19.91,19.21,18.54,17.89,17.26

,增值税抵扣,,,,20.63,19.91,19.21,18.20,5.79,17.26,20.63,57.74,0.00,0.00,0.00,0.00

,抵扣后余额,,,,38.64,25.18,12.19,-0.34,-12.44,40.48,26.53,13.07,0.09,-12.45,0.00,0.00

,实际缴纳增值税,,,,0.00,0.00,0.00,0.00,12.44,0.00,0.00,0,0,12.45,12.09,11.67

,静态回收期,,0.00,,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,10.31,0.00

,动态回收期,,#DIV/0!,,0.00,0.00,0.00,0.00,0.00,0.00,0.00,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!,#DIV/0!

,LCOE,0.89,,,,,,,,,,,,,,

,初始投资,(474.07),,,,,,,,,,,,,,

,增值税抵扣现值,,91.65,,19.10,17.07,15.25,13.38,3.94,10.88,12.04,,,,,

,运维费用现值,,237.76,,2.06,1.91,1.76,1.63,1.51,227.59,1.30,,,,,

,残值及流动资金现值,,0.00,,,,,,,,,,,,,

,电量现值,,697.52,,133.06,118.89,106.23,94.92,84.81,75.78,83.85,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,,,,,,,,,,,,,,

,,,,