储能调峰项目经济性分析.xlsx
下载文档
上传人:正***
编号:854728
2023-12-21
56页
230.65KB
1、输入一电池(包含BMS)技术参数采购价格(含税)单价(元/wh)总价(万元)1电池需量规模(kWh)45002放电深度 70%3放电时间(小时)64负载功率(kW)7505电池效率95%6电池配置容量(kWh)6428.577电池残值15%8循环次数210010年衰减率3.5%9电池成本(RMB/kWh)500321.43二PCS1PCS双向变流器功率(kW)7502PCS双向变流器超负荷率13PCS双向变流器寿命(年)84AC/DC充电器效率98%5DC/AC逆变器效率98%6PCS双向变流器成本(RMB/kW)50037.5三其他设备1能源监控+配电+热管理系统(套)1150001.52箱2、变(个)1150001.5设备成本合计(万元)0.804361.93四施工1运输及安装(RMB/kWh)302改造(RMB)030五其他费用1设计、勘察(RMB/kWh)0202开发费用(RMB/Wh)0.0532.14施工及其他合计(万元)112.14总投资合计(万元)1.05474.07EPC成本(元/Wh)1.00电池成本占比67.80%设备成本占比76.34%每天循环次数1设备残值15.00%年运行天数(天)350电池残值(万元)41.21PCS、线缆残值(万元)5.00电池折旧(万元)233.52PCS、线缆折旧(万元)28.33电池折旧(年)6.00PCS、线缆折旧(年)6.00电3、池年折旧(万元)32.05PCS、线缆年折旧(万元)3.89电池寿命年限(年)6PCS、线缆使用年限(年)6.00增值税率17%固定资产设备进项税备注274.7346.7032.055.451.280.221.280.22309.3452.596.33%6.78%309.3452.5910%项目名称工业调峰储能电站项目项目单位有限公司输入参数值项目基本信息投资总额(万元)474.07电池需量规模(kWh)4500放电深度 70%电池配置容量(kWh)6428.57电池功率(kW)750.00放电时间(小时)6系统效率%91.24%衰减率3.50%年利用天数350电池组循环次数2100PCS寿命4、(年)8每天循环次数1项目地点湖北融资变量及参数(具体见租赁银行贷款表格)融资类型0项目贷款利率6.0%融资比例70.00%贷款融资年限(年)5宽限期0融资(租赁贷款)额度0.0保证金0.00%手续费1.00%手续费年限4宽限期满后一次性付本比例0%还款方式0电价变量及收入参数用电折扣95%峰电价1.04尖峰电价-平电价0.6117谷电价0.32平均电价差0.72峰电使用小时数6.0尖峰使用小时数0.0企业年用电天数350企业生产时间(h)24年电价差收入(万元)95.99容量费单价(元/kW/月)需量费单价(元/kW/月)0.00容量(kW)0.00需量(kW)0.00基础电费节省分成80.5、00%需量/容量费(万元/月)0削减需量/容量收入(万元/年)0永久性转移高峰电力负荷的奖励(元/Kw)0主动需求侧响应临时性减少高峰电力负荷的奖励(元/Kw)0年需求侧管理收入(万元/年)0初始投资比例0%初始投资补贴(万元)0费用变量及参数费用方式1年运营费用(如为外包)0.05%运营人数2运营人员工资(万元/年)5设备维护成本0.00年运维费用(万元/年)0.24电池更换成本(元/kWh)500电池折旧年限6电池更换次数0电池更换费用(万元)0保险费率0.10%保险费用(万元/年)0.47所需面积(平方米)212.14设备置放租金(万元/年)0.00厂用电(万元/年)1.51税费参数增值6、税率17%服务增值率6%设备占总投资比例76%增值税收政策所得税率25%所得税收政策通货膨胀率2%营业税金及附加12%流动资金0%NPV基准收益率8%年效率递减率0备注输出情况电站净现值NPV于设备工程参数表内输入修改IRR于设备工程参数表内输入修改静态回收期于设备工程参数表内输入修改动态回收期于设备工程参数表内输入修改LCOE于设备工程参数表内输入修改于设备工程参数表内输入修改于设备工程参数表内输入修改于设备工程参数表内输入修改投资单价(元/Wh)于设备工程参数表内输入修改循环次数于设备工程参数表内输入修改租金单价于设备工程参数表内输入修改运维费(万元/年)开发费电费折扣峰电电价(平均电价差7、)0为全投资,1为租赁,2为银行贷款综合利率(融资综合利率)利率银行贷款为总投资的比例,融资租赁为设备的比例#NAME?税后综合利率主要针对租赁#NAME?税前综合利率主要针对租赁70.0%融资额占总投资比例主要针对租赁主要针对租赁主要针对银行贷款,选择0等额本息,1为等额本金针对不同地区项目注意确认此值工业调峰储能电站项目有限公司项目基本信息融资变量及参数(具体见租赁银行贷款表格)电价变量及收入参数针对不同地区项目注意确认此值针对不同地区项目注意确认此值针对不同地区项目注意确认此值针对不同地区项目注意确认此值针对不同地区项目注意确认此值无基本电费容量改为需量节省的基础电费和业主8:2分成储能8、每天参与削峰填谷,能够实现永久性转移高峰电力负荷;奖励标准分为三挡:分别是350元/千瓦、450元/千瓦、550元/千瓦需具备临时响应计划,否则不计算;按照响应时间按(24小时、4小时、30分钟)签订合同,奖励标准分为三挡,分别为:80元/千瓦、100元/千瓦、120元/千瓦IF(C11150;30%;0)项目容量需超过150kW;补贴比例30%IF(C72000;C47*C7;2000)最高补贴2000万外包为1,自营为0根据总投资规模计算0.70%针对不同项目注意确认此值根据电池配置容量计算保险总费率,后框1表示有保险,0表示无1费用变量及参数33租金单价(元/平方米)03%经验值CPI城9、市建设维护费 7%必须缴纳教育费附加 3%必须缴纳地方教育费 1%、2%地区不同规定不同,好多地区可以不用缴纳此税种。首年预留流动资金占总投资比例技术参数情况需确定税费参数-168.344.38%0.00#DIV/0!0.89敏感性分析1.05210000.237035710.0595.00%1.046.00%序项目备注合计建设期经营期2016201720180121年利用电量(万kWh)注意电池更换情况1580.37143.70138.671.1峰电量143.70138.671.2尖峰电量1.3平电量0.000.001.4谷电量143.70138.672现金流入141.975137.006310、电费收入(税前)1561.41141.98137.013.1峰电收入1.041561.41141.975137.0063.2尖峰电收入00.000.0000.0003削减容量0.0000.0004需求侧响应0.0000.0005补贴0.0006资产残值(电池回收)92.427现金流出1041.19474.0748.2146.607.0谷电支出0.3245.9844.377.0平电支出0.61170.000.007.1场地租赁费用0.000.000.007.2偿还本金0.000.000.007.3偿还利息0.000.000.000.007.4偿还手续费0.000.000.007.5缴纳增值税4811、.650.000.007营业税金及附加5.840.000.008所得税74.540.000.009运维费用2.840.240.2410电池和pcs更换费用358.9311保险费用5.690.470.4712厂用电38.981.511.5113流动资金0.00014折旧431.2835.9435.94所得税前利润57.8354.47税后净现金流(474.07)93.7790.41税后累计现金流(474.07)(380.30)(289.89)税后净现金流现值(474.07)86.8277.51税后累计现金流现值(474.07)(387.25)(309.74)电站净现值NPV-168.34电站现值312、05.73IRR4.38%静态回收期0.00动态回收期#DIV/0!LCOE0.89增值税进项税注意更换设备情况52.596.686.45总进项税52.5959.2765.72销项税20.6319.91增值税抵扣20.6319.91抵扣后余额38.6425.18实际缴纳增值税0.000.00静态回收期0.000.000.00动态回收期#DIV/0!0.000.00LCOE0.89初始投资(474.07)增值税抵扣现值91.6519.1017.07运维费用现值237.762.061.91残值及流动资金现值0.00电量现值697.52133.06118.892019202020212022202313、202420252026345678910133.82129.13124.61120.25143.70138.67133.82129.13133.82129.13124.61120.25143.70138.67133.82129.130.000.000.000.000.000.000.000.00133.82129.13124.61120.25143.70138.67133.82129.13132.211127.584123.118118.809141.975137.006132.211127.584132.21127.58123.12118.81141.98137.01132.21127.514、8132.211127.584123.118118.809141.975137.006132.211127.5840.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.00046.2087945.0449.5659.92404.9062.6660.2161.7669.9342.8241.3239.8838.4845.9844.3742.8241.320.000.000.000.000.000.000.000.000.15、000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.0012.440.000.000.000.0012.450.000.001.490.000.000.000.001.490.006.013.895.2714.4613.6211.507.240.240.240.240.240.240.240.240.24358.92860.470.470.470.470.470.470.470.47116、.511.511.511.511.511.516.726.7235.9435.9435.9435.9435.9435.9435.9435.9451.2348.1031.1542.1757.8354.4746.0228.9587.1778.0363.20(239.89)79.3176.7970.4557.65(202.73)(124.70)(61.51)(301.39)(222.08)(145.29)(74.83)(17.18)69.2057.3543.01(151.17)46.28(240.54)(183.19)(140.18)(291.35)(245.07)6.226.005.7957.7417、6.686.456.226.0071.9477.9483.74141.48148.166.4512.6718.6719.2118.5417.8917.2620.6319.9119.2118.5419.2118.205.7917.2620.6357.740.000.0012.19-0.34-12.4440.4826.5313.070.09-12.450.000.0012.440.000.000012.450.000.000.000.000.000.000.000.000.000.000.000.000.00#DIV/0!#DIV/0!#DIV/0!15.2513.383.9410.8812.0418、1.761.631.51227.591.30106.2394.9284.8175.7883.85202720281112124.61120.25124.61120.250.000.00124.61120.25123.118118.809123.12118.81123.118118.8090.0000.0000.0000.0000.0000.00046.2087967.4364.9639.8838.480.000.000.000.000.000.000.000.000.000.0012.0911.671.451.406.585.970.240.240.000.470.476.726.7235.919、435.9426.3223.8855.68100.0638.50138.565.795.5924.4730.0617.8917.260.000.000.000.0012.0911.6710.310.00#DIV/0!#DIV/0!税前还款额1234-61.31-61.31-61.31-61.31税后还款额1234-58.85-59.25-59.67-60.13进项税2.462.061.631.18偿还本金44.7947.5650.4953.60偿还利息13.9811.228.295.17手续费2.532.532.532.53直租回租设备款361.9285714361.9285714融资金额2520、3.35253.35融资期数(月)6060宽限期00租赁利率6.00%6.00%手续费2.536.5871手续费年限4保证金0.0015.201月IRR年IRR0.627%7.78%期数7.520%本金余值租金本金第0月0现金流253.35第1月1253.35249.72-4.90(3.63)第2月2-7.43246.07-4.90(3.65)第3月3-4.90242.40-4.90(3.67)第4月4-4.90238.72-4.90(3.69)第5月5-4.90235.01-4.90(3.70)第6月6-4.90231.29-4.90(3.72)第7月7-4.90227.55-4.90(3.21、74)第8月8-4.90223.79-4.90(3.76)第9月9-4.90220.01-4.90(3.78)第10月10-4.90216.21-4.90(3.80)第11月11-4.90212.39-4.90(3.82)第12月12-4.90208.56-4.90(3.84)第13月13-4.90204.70-4.90(3.86)第14月14-7.43200.83-4.90(3.87)第15月15-4.90196.93-4.90(3.89)第16月16-4.90193.02-4.90(3.91)第17月17-4.90189.09-4.90(3.93)第18月18-4.90185.13-4.922、0(3.95)第19月19-4.90181.16-4.90(3.97)第20月20-4.90177.17-4.90(3.99)第21月21-4.90173.16-4.90(4.01)第22月22-4.90169.13-4.90(4.03)第23月23-4.90165.07-4.90(4.05)第24月24-4.90161.00-4.90(4.07)第25月25-4.90156.91-4.90(4.09)第26月26-7.43152.79-4.90(4.11)第27月27-4.90148.66-4.90(4.13)第28月28-4.90144.51-4.90(4.15)第29月29-4.901423、0.33-4.90(4.18)第30月30-4.90136.13-4.90(4.20)第31月31-4.90131.92-4.90(4.22)第32月32-4.90127.68-4.90(4.24)第33月33-4.90123.42-4.90(4.26)第34月34-4.90119.14-4.90(4.28)第35月35-4.90114.84-4.90(4.30)第36月36-4.90110.51-4.90(4.32)第37月37-4.90106.17-4.90(4.35)第38月38-7.43101.80-4.90(4.37)第39月39-4.9097.41-4.90(4.39)第40月4024、-4.9093.00-4.90(4.41)第41月41-4.9088.57-4.90(4.43)第42月42-4.9084.11-4.90(4.46)第43月43-4.9079.63-4.90(4.48)第44月44-4.9075.13-4.90(4.50)第45月45-4.9070.61-4.90(4.52)第46月46-4.9066.07-4.90(4.54)第47月47-4.9061.50-4.90(4.57)第48月48-4.9056.91-4.90(4.59)第49月49-4.9052.30-4.90(4.61)第50月50-4.9047.66-4.90(4.64)第51月51-4.25、9043.00-4.90(4.66)第52月52-4.9038.32-4.90(4.68)第53月53-4.9033.61-4.90(4.71)第54月54-4.9028.88-4.90(4.73)第55月55-4.9024.13-4.90(4.75)第56月56-4.9019.35-4.90(4.78)第57月57-4.9014.55-4.90(4.80)第58月58-4.909.72-4.90(4.83)第59月59-4.904.87-4.90(4.85)第60月60-4.900.00-4.90(4.87)第61月61-4.900.000.000.00第62月620.000.000.00026、.00第63月630.000.000.000.00第64月640.000.000.000.00第65月650.000.000.000.00第66月660.000.000.000.00第67月670.000.000.000.00第68月680.000.000.000.00第69月690.000.000.000.00第70月700.000.000.000.00第71月710.000.000.000.00第72月720.000.000.000.00第73月730.000.000.000.00第74月740.000.000.000.00第75月750.000.000.000.00第76月760.00027、.000.000.00第77月770.000.000.000.00第78月780.000.000.000.00第79月790.000.000.000.00第80月800.000.000.000.00第81月810.000.000.000.00第82月820.000.000.000.00第83月830.000.000.000.00第84月840.000.000.000.00第85月850.000.000.000.00第86月860.000.000.000.00第87月870.000.000.000.00第88月880.000.000.000.00第89月890.000.000.000.00第9028、月900.000.000.000.00第91月910.000.000.000.00第92月920.000.000.000.00第93月930.000.000.000.00第94月940.000.000.000.00第95月950.000.000.000.00第96月960.000.000.000.00第97月970.000.000.000.00第98月980.000.000.000.00第99月990.000.000.000.00第100月1000.000.000.000.00第101月1010.000.000.000.00第102月1020.000.000.000.00第103月1030.029、00.000.000.00第104月1040.000.000.000.00第105月1050.000.000.000.00第106月1060.000.000.000.00第107月1070.000.000.000.00第108月1080.000.000.000.00第109月1090.000.000.000.00第110月1100.000.000.000.00第111月1110.000.000.000.00第112月1120.000.000.000.00第113月1130.000.000.000.00第114月1140.000.000.000.00第115月1150.000.000.000.030、0第116月1160.000.000.000.00第117月1170.000.000.000.00第118月1180.000.000.000.00第119月1190.000.000.000.00第120月1200.000.000.000.000.005678910-58.780.000.000.000.000.005678910-58.500.000.000.000.000.000.270.000.000.0056.910.000.000.001.870.000.000.000.000.000.000.00利率项目年利率(%)六个月以内(含6个月)贷款4.35六个月至一年(含1年)贷款4.3531、一至三年(含3年)贷款4.75三至五年(含5年)贷款4.75五年以上贷款4.90利息手续费保证金租金增值税17%手续费营业税17%0-1.27-2.53350.000.180.43-1.250.000.18-1.230.000.18-16.25-1.210.000.18-1.190.000.17-1.180.000.17-14.17-1.160.000.17-1.140.000.17-1.120.000.16-14.20-1.100.000.16-1.080.000.16-1.060.000.15-14.22-1.04-2.53350.000.150.43-1.020.000.15-1.00032、.000.15-16.35-0.980.000.14-0.970.000.14-0.950.000.14-14.27-0.930.000.13-0.910.000.13-0.890.000.13-14.30-0.870.000.13-0.850.000.12-0.830.000.12-14.33-0.81-2.53350.000.120.43-0.780.000.11-0.760.000.11-16.45-0.740.000.11-0.720.000.10-0.700.000.10-14.38-0.680.000.10-0.660.000.10-0.640.000.09-14.41-0.62033、.000.09-0.600.000.09-0.570.000.08-14.43-0.55-2.53350.000.080.43-0.530.000.08-0.510.000.07-16.57-0.490.000.07-0.460.000.07-0.440.000.06-14.49-0.420.000.06-0.400.000.06-0.380.000.05-14.52-0.350.000.05-0.330.000.05-0.310.000.04-14.55-0.2800.000.040.00-0.260.000.04-0.240.000.03-14.58-0.210.000.03-0.190.34、000.03-0.170.000.02-14.61-0.140.000.02-0.120.000.02-0.100.000.01-14.64-0.070.000.01-0.050.000.01-0.020.000.00-14.670.0000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.0000.000.000.000.000.035、00.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.0000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.36、0000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.0000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.0037、0.000.000.000.000.005.891.721112131415NPV-19,587.46税前还款额123(5401.55)(5401.55)(5401.55)ABS(4861.39)(4861.39)(4861.39)净现金流(1801.80)(466.68)(543.36)参参数数值值当前利率0.500000%贷款253.35 期数按季按年结结果果期期数数当当期期本本金金当当期期利利息息还还款款金金额额-61.3113.631.274.90-61.3123.651.254.90-61.3133.671.234.90-61.3143.691.214.90-58.7853.701.38、194.900.0063.721.184.900.0073.741.164.900.0083.761.144.900.0093.781.124.900.00103.801.104.90113.821.084.90123.841.064.90133.861.044.90143.871.024.90153.891.004.90163.910.984.90173.930.974.90183.950.954.90193.970.934.90203.990.914.90214.010.894.90224.030.874.90234.050.854.90244.070.834.90254.090.814.39、90264.110.784.90274.130.764.90284.150.744.90294.180.724.90304.200.704.90314.220.684.90324.240.664.90334.260.644.90344.280.624.90354.300.604.90364.320.574.90374.350.554.90384.370.534.90394.390.514.90404.410.494.90414.430.464.90424.460.444.90434.480.424.90444.500.404.90454.520.384.90464.540.354.90474.40、570.334.90484.590.314.90494.610.284.90504.640.264.90514.660.244.90524.680.214.90534.710.194.90544.730.174.90554.750.144.90564.780.124.90574.800.104.90584.830.074.90594.850.054.90604.870.024.90610.000.000.00620.000.000.00630.000.000.00640.000.000.00650.000.000.00660.000.000.00670.000.000.00680.000.0041、0.00690.000.000.00700.000.000.00710.000.000.00720.000.000.00730.000.000.00740.000.000.00750.000.000.00760.000.000.00770.000.000.00780.000.000.00790.000.000.00800.000.000.00810.000.000.00820.000.000.00830.000.000.00840.000.000.00850.000.000.00860.000.000.00870.000.000.00880.000.000.00890.000.000.009042、0.000.000.00910.000.000.00920.000.000.00930.000.000.00940.000.000.00950.000.000.00960.000.000.00970.000.000.00980.000.000.00990.000.000.001000.000.000.001010.000.000.001020.000.000.001030.000.000.001040.000.000.001050.000.000.001060.000.000.001070.000.000.001080.000.000.001090.000.000.001100.000.00043、.001110.000.000.001120.000.000.001130.000.000.001140.000.000.001150.000.000.001160.000.000.001170.000.000.001180.000.000.001190.000.000.001200.000.000.00456789(5401.55)(4077.47)0.000.000.000.00(4861.39)(3669.72)(621.71)622.24月IRR0.532%60年IRR6.387%6.58%税后现金流5.47%253.35253.35-6.82-58.85-4.72-59.25-4.744、2-59.67-4.72-60.13-4.72-58.50-4.730.00-4.730.00-4.730.00-4.740.00-4.740.00-4.74-4.74-6.85-4.75-4.75-4.75-4.76-4.76-4.76-4.77-4.77-4.77-4.78-4.78-6.88-4.78-4.79-4.79-4.79-4.80-4.80-4.80-4.81-4.81-4.81-4.81-6.92-4.82-4.82-4.83-4.83-4.83-4.84-4.84-4.84-4.85-4.85-4.85-4.86-4.86-4.86-4.87-4.87-4.87-4.88-45、4.88-4.88-4.89-4.89-4.890.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00100.00利率项目年利率(%)六个月以内(含6个月)贷款4.3512六46、个月至一年(含1年)贷款4.35等额本息76.9976.99一至三年(含3年)贷款4.75等额本金84.4680.47三至五年(含5年)贷款4.75宽限期0五年以上贷款4.9等额本息偿还本金58.6762.29偿还利息18.3114.70等额本金偿还本金66.3766.37偿还利息18.0914.10等额本息方式参参数数值值当前利率0.500000%贷款331.85期数60结结果果期期数数当当期期本本金金当当期期利利息息还还款款金金额额年年还款额14.761.666.42176.9924.781.646.42276.9934.801.616.42376.9944.831.596.42476.947、954.851.566.42576.9964.881.546.4260.0074.901.516.4270.0084.931.496.4280.0094.951.476.4290.00104.971.446.42100.00115.001.426.42110.00125.021.396.42120.00135.051.376.42130.00145.071.346.42140.00155.101.326.42150.00165.131.296.42175.151.266.42185.181.246.42195.201.216.42205.231.196.42215.261.166.42225.48、281.136.42235.311.116.42245.331.086.42255.361.056.42265.391.036.42275.411.006.42285.440.976.42295.470.956.42305.500.926.42315.520.896.42325.550.866.42335.580.846.42345.610.816.42355.640.786.42365.660.756.42375.690.726.42385.720.706.42395.750.676.42405.780.646.42415.810.616.42425.840.586.42435.860.5549、6.42445.890.526.42455.920.496.42465.950.466.42475.980.436.42486.010.406.42496.040.376.42506.070.346.42516.100.316.42526.130.286.42536.160.256.42546.200.226.42556.230.196.42566.260.166.42576.290.136.42586.320.106.42596.350.066.42606.380.036.42610.000.000.00620.000.000.00630.000.000.00640.000.000.006550、0.000.000.00660.000.000.00670.000.000.00680.000.000.00690.000.000.00700.000.000.00710.000.000.00720.000.000.00730.000.000.00740.000.000.00750.000.000.00760.000.000.00770.000.000.00780.000.000.00790.000.000.00800.000.000.00810.000.000.00820.000.000.00830.000.000.00840.000.000.00850.000.000.00860.000.51、000.00870.000.000.00880.000.000.00890.000.000.00900.000.000.00910.000.000.00920.000.000.00930.000.000.00940.000.000.00950.000.000.00960.000.000.00970.000.000.00980.000.000.00990.000.000.001000.000.000.001010.000.000.001020.000.000.001030.000.000.001040.000.000.001050.000.000.001060.000.000.001070.0052、0.000.001080.000.000.001090.000.000.001100.000.000.001110.000.000.001120.000.000.001130.000.000.001140.000.000.001150.000.000.001160.000.000.001170.000.000.001180.000.000.001190.000.000.001200.000.000.001210.000.000.001220.000.000.001230.000.000.001240.000.000.001250.000.000.001260.000.000.001270.0053、0.000.001280.000.000.001290.000.000.001300.000.000.001310.000.000.001320.000.000.001330.000.000.001340.000.000.001350.000.000.001360.000.000.001370.000.000.001380.000.000.001390.000.000.001400.000.000.001410.000.000.001420.000.000.001430.000.000.001440.000.000.001450.000.000.001460.000.000.001470.0054、0.000.001480.000.000.001490.000.000.001500.000.000.001510.000.000.001520.000.000.001530.000.000.001540.000.000.001550.000.000.001560.000.000.001570.000.000.001580.000.000.001590.000.000.001600.000.000.001610.000.000.001620.000.000.001630.000.000.001640.000.000.001650.000.000.001660.000.000.001670.0055、0.000.001680.000.000.001690.000.000.001700.000.000.001710.000.000.001720.000.000.001730.000.000.001740.000.000.001750.000.000.001760.000.000.001770.000.000.001780.000.000.001790.000.000.001800.000.000.003456789101176.9976.9976.990.000.000.000.000.000.0076.4972.5168.530.000.000.000.000.000.0066.1370.56、2174.540.000.000.00331.8510.856.782.440.000.000.0053.0966.3766.3766.370.000.000.00331.8510.126.142.160.000.000.0050.61等额本金参参数数值值期数60当前利率#贷款331.85结结果果期期数数当当期期本本金金当当期期利利息息还还款款金金额额期期数数当当期期本本金金 当当期期利利息息还还款款金金额额14.75631.65936.415615.531.667.1924.78011.63556.415625.531.637.1634.8041.61166.415635.531.607.157、344.8281.58756.415645.531.587.1154.85221.56346.415655.531.557.0864.87641.53916.415665.531.527.0574.90081.51486.415675.531.497.0284.92531.49036.415685.531.477.0094.951.46566.415695.531.446.97104.97471.44096.4156105.531.416.94114.99961.4166.4156115.531.386.91125.02461.3916.4156125.531.366.89135.04971.58、36596.4156135.531.336.86145.07491.34066.4156145.531.306.83155.10031.31536.4156155.531.276.80165.12581.28986.4156165.531.246.78175.15151.26416.4156175.531.226.75185.17721.23846.4156185.531.196.72195.20311.21256.4156195.531.166.69205.22911.18656.4156205.531.136.66215.25531.16036.4156215.531.116.64225.59、28151.13416.4156225.531.086.61235.30791.10766.4156235.531.056.58245.33451.08116.4156245.531.026.55255.36121.05446.4156255.531.006.53265.3881.02766.4156265.530.976.50275.41491.00076.4156275.530.946.47285.4420.97366.4156285.530.916.44295.46920.94646.4156295.530.886.42305.49650.91916.4156305.530.866.3960、315.5240.89166.4156315.530.836.36325.55160.8646.4156325.530.806.33335.57940.83626.4156335.530.776.31345.60730.80836.4156345.530.756.28355.63530.78036.4156355.530.726.25365.66350.75216.4156365.530.696.22375.69180.72386.4156375.530.666.19385.72030.69536.4156385.530.646.17395.74890.66676.4156395.530.6161、6.14405.77760.6386.4156405.530.586.11415.80650.60916.4156415.530.556.08425.83550.586.4156425.530.536.06435.86470.55096.4156435.530.506.03445.8940.52156.4156445.530.476.00455.92350.49216.4156455.530.445.97465.95310.46256.4156465.530.415.95475.98290.43276.4156475.530.395.92486.01280.40286.4156485.530.62、365.89496.04290.37276.4156495.530.335.86506.07310.34256.4156505.530.305.84516.10350.31216.4156515.530.285.81526.1340.28166.4156525.530.255.78536.16460.25096.4156535.530.225.75546.19550.22016.4156545.530.195.72556.22640.18916.4156555.530.175.70566.25760.1586.4156565.530.145.67576.28890.12676.4156575.63、530.115.64586.32030.09536.4156585.530.085.61596.35190.06376.4156595.530.065.59606.38370.03196.4156605.530.035.5661000610.000.000.0062000620.000.000.0063000630.000.000.0064000640.000.000.0065000650.000.000.0066000660.000.000.0067000670.000.000.0068000680.000.000.0069000690.000.000.0070000700.000.000.64、0071000710.000.000.0072000720.000.000.0073000730.000.000.0074000740.000.000.0075000750.000.000.0076000760.000.000.0077000770.000.000.0078000780.000.000.0079000790.000.000.0080000800.000.000.0081000810.000.000.0082000820.000.000.0083000830.000.000.0084000840.000.000.0085000850.000.000.0086000860.000.65、000.0087000870.000.000.0088000880.000.000.0089000890.000.000.0090000900.000.000.0091000910.000.000.0092000920.000.000.0093000930.000.000.0094000940.000.000.0095000950.000.000.0096000960.000.000.0097000970.000.000.0098000980.000.000.0099000990.000.000.001000001000.000.000.001010001010.000.000.001020066、01020.000.000.001030001030.000.000.001040001040.000.000.001050001050.000.000.001060001060.000.000.001070001070.000.000.001080001080.000.000.001090001090.000.000.001100001100.000.000.001110001110.000.000.001120001120.000.000.001130001130.000.000.001140001140.000.000.001150001150.000.000.001160001160.67、000.000.001170001170.000.000.001180001180.000.000.001190001190.000.000.001200001200.000.000.001210001210.000.000.001220001220.000.000.001230001230.000.000.001240001240.000.000.001250001250.000.000.001260001260.000.000.001270001270.000.000.001280001280.000.000.001290001290.000.000.001300001300.000.0068、0.001310001310.000.000.001320001320.000.000.001330001330.000.000.001340001340.000.000.001350001350.000.000.001360001360.000.000.001370001370.000.000.001380001380.000.000.001390001390.000.000.001400001400.000.000.001410001410.000.000.001420001420.000.000.001430001430.000.000.001440001440.000.000.001469、50001450.000.000.001460001460.000.000.001470001470.000.000.001480001480.000.000.001490001490.000.000.001500001500.000.000.001510001510.000.000.001520001520.000.000.001530001530.000.000.001540001540.000.000.001550001550.000.000.001560001560.000.000.001570001570.000.000.001580001580.000.000.001590001570、90.000.000.001600001600.000.000.001610001610.000.000.001620001620.000.000.001630001630.000.000.001640001640.000.000.001650001650.000.000.001660001660.000.000.001670001670.000.000.001680001680.000.000.001690001690.000.000.001700001700.000.000.001710001710.000.000.001720001720.000.000.001730001730.00071、.000.001740001740.000.000.001750001750.000.000.001760001760.000.000.001770001770.000.000.001780001780.000.000.001790001790.000.000.001800001800.000.000.00121314150.000.000.000.000.000.000.000.00期数60剩剩余余本本金金年年还款额326.32184.46320.79280.47315.26376.49309.73472.51304.20568.53298.6760.00293.1370.00287.60872、0.00282.0790.00276.54100.00271.01110.00265.48120.00259.95130.00254.42140.00248.89150.00243.36237.83232.30226.76221.23215.70210.17204.64199.11193.58188.05182.52176.99171.46165.93160.39154.86149.33143.80138.27132.74127.21121.68116.15110.62105.0999.5694.0288.4982.9677.4371.9066.3760.8455.3149.7844.253873、.7233.1927.6522.1216.5911.065.530.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.0074、0.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.001投资单价(含开发费)(元/Wh)实际值浮动比例IRRNPV04.38%-168.33860.790119048-25%10.54%-48.827840.842793675、51-20%9.01%-72.729990.895468254-15%7.66%-96.632150.948142857-10%6.46%-120.53431.00081746-5%5.37%-144.43651.0534920630%4.38%-168.33861.1061666675%3.47%-192.24081.1588412710%2.64%-216.14291.21151587315%1.86%-240.04511.26419047620%1.15%-263.94721.31686507925%0.48%-287.84942循环次数实际值浮动比例IRRNPV04.38%-168.376、4 1575-25%0.04%-222.78 1680-20%1.21%-210.33 1785-15%1.74%-203.96 1890-10%2.79%-190.67 1995-5%3.77%-177.38 21000%4.38%-168.34 22055%4.38%-168.34 231010%4.38%-168.34 241515%4.38%-168.34 252020%4.14%-171.37 262525%4.14%-171.37 3场地租金(万/年)实际值浮动比例IRRNPV04.38%(168.34)0-100%4.38%(168.34)0-70%4.38%(168.34)0-77、50%4.38%(168.34)0-30%4.38%(168.34)0-10%4.38%(168.34)00%4.38%(168.34)050%4.38%(168.34)0100%4.38%(168.34)0200%4.38%(168.34)0500%4.38%(168.34)01000%4.38%(168.34)4运维费(万/年)百分比实际值浮动比例IRRNPV04.38%(168.34)0.01%0.023703571-90%4.44%-167.150.02%0.071110714-70%4.43%-167.410.03%0.118517857-50%4.41%-167.680.04%0.78、165925-30%4.40%-167.940.05%0.213332143-10%4.38%-168.210.05%0.2370357140%4.38%-168.340.06%0.26073928610%4.37%-168.470.07%0.30814642930%4.35%-168.740.08%0.35555357150%4.34%-169.000.09%0.40296071470%4.33%-169.270.10%0.45036785790%4.31%-169.535开发费(元/Wh)实际值浮动比例IRRNPV04.38%(168.34)0.005-90%5.60%-139.170.079、15-70%5.31%-145.650.025-50%5.04%-152.130.035-30%4.77%-158.610.045-10%4.51%-165.100.050%4.38%-168.340.05510%4.25%-171.580.06530%4.00%-178.060.07550%3.75%-184.540.08570%3.51%-191.030.09590%3.28%-197.516电费折扣实际值浮动比例IRRNPV04.38%(168.34)71.25%-25%-4.54%-337.80 76.00%-20%-2.72%-303.91 80.75%-15%-0.92%-270.80、02 85.50%-10%0.86%-236.12 90.25%-5%2.62%-202.23 0.05295.00%0%4.38%-168.34 0.002699.75%5%6.12%-134.45 7平均电价差(元/度)峰电价格浮动比例实际值IRRNPV00.724.38%(168.34)0.78-25%0.72-4.54%-337.80 0.832-20%0.72-2.72%-303.91 0.884-15%0.72-0.92%-270.02 0.936-10%0.720.86%-236.12 0.988-5%0.722.62%-202.23 1.040%0.724.38%-168.3481、 1.0925%0.726.12%-134.45 1.14410%0.727.85%-100.55 1.19615%0.7210.02%-56.44 1.24820%0.7211.68%-23.48 1.325%0.7212.49%-10.68 8综合利率利率浮动比例实际值IRRNPV6.00%0#NAME?4.38%(168.34)4.50%-25%#NAME?0.0437673(168.34)4.80%-20%#NAME?0.0437673(168.34)5.10%-15%#NAME?0.0437673(168.34)5.40%-10%#NAME?0.0437673(168.34)5.7082、%-5%#NAME?0.0437673(168.34)6.00%0%#NAME?0.0437673(168.34)6.30%5%#NAME?0.0437673(168.34)6.60%10%#NAME?0.0437673(168.34)6.90%15%#NAME?0.0437673(168.34)7.20%20%#NAME?0.0437673(168.34)7.50%25%#NAME?0.0437673(168.34)LCOE静态回收年 动态回收年0.8891160#DIV/0!0.71787694.0867418#DIV/0!0.00%0.00%0.00%0.75212474.463298#83、DIV/0!0.00%0.00%0.00%0.78637254.8402243#DIV/0!0.00%0.00%0.00%0.82062030#DIV/0!0.00%0.00%0.00%0.85486820#DIV/0!0.00%0.00%0.00%0.8891160#DIV/0!0.00%0.00%0.00%0.92336380#DIV/0!0.00%0.00%0.00%0.95761160#DIV/0!0.00%0.00%0.00%0.99185940#DIV/0!0.00%0.00%0.00%1.02610720#DIV/0!0.00%0.00%0.00%1.0603550#DIV/0!84、0.00%0.00%0.00%LCOE静态回收年 动态回收年0.890.00#DIV/0!1.090.00#DIV/0!0.00%0.00%0.00%1.040.00#DIV/0!0.00%0.00%0.00%1.000.00#DIV/0!0.00%0.00%0.00%0.960.00#DIV/0!0.00%0.00%0.00%0.920.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!85、0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%LCOE静态回收年 动态回收年0.890.00#DIV/0!0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!86、0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%LCOE静态回收年 动态回收年0.890.00#DIV/0!0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!87、0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%LCOE静态回收年 动态回收年0.890.00#DIV/0!0.850.00#DIV/0!0.00%0.00%0.00%0.860.00#DIV/0!0.00%0.00%0.00%0.870.00#DIV/0!88、0.00%0.00%0.00%0.880.00#DIV/0!0.00%0.00%0.00%0.880.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.900.00#DIV/0!0.00%0.00%0.00%0.910.00#DIV/0!0.00%0.00%0.00%0.920.00#DIV/0!0.00%0.00%0.00%0.930.00#DIV/0!0.00%0.00%0.00%LCOE静态回收年 动态回收年0.890.00#DIV/0!0.910.00#DIV/0!89、0.00%0.00%0.00%0.910.00#DIV/0!0.00%0.00%0.00%0.900.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%LCOE静态回收年 动态回收年0.890.00#DIV/0!0.910.00#DIV/0!0.00%0.00%0.00%0.910.00#DIV/0!0.00%0.00%0.00%0.900.00#DIV/0!90、0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.888.75#DIV/0!0.00%0.00%0.00%0.874.71#DIV/0!0.00%0.00%0.00%0.864.31#DIV/0!0.00%0.00%0.00%0.863.97#DIV/0!0.00%0.00%0.00%LCOE静态回收年 动态回收年0.890.00#DIV/0!0.890.00#DIV/0!91、0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%0.890.00#DIV/0!0.00%0.00%0.00%