【Excel计算表】工商业用户侧储能投资效益测算表VIP专享VIP免费

技术参数指标电芯配组序号指标参数序号项目参数单位1模组38.4V1循环次数60002模组容量12518.4Wh3电池簇模组数个2充电/放电效率93%4单簇电压20V5单簇容量768Wh3放电深度90%6单簇BMU个数250368套7单簇高压盒含BCMU20套4系统功率(KW)10008mm9长1mm5电池容量(Wh)6,008,832.0010宽mm高6有效容量(Wh)5,407,948.807单次循环衰减3.3333333333E-058电池包电芯数(个)249电芯电压(V)3.210电芯容量(AH)163序号类别变量数量单位备注20尺1集装箱数量2个40尺集装箱2电池模块1.1元/Wh3BMS单价0.13元/Wh4集装箱单价0.15元/Wh5逆变升压一体仓0元/kW6PCS功率1000kW7系统确认EMS单价200000元/套8并网系统400000元/套9设计费0.01元/Wh10调试验收0.02元/Wh11土建施工及电气安装、装修0.1元/Wh12充电/放电效率93%%13每天充放次数2次/天1490%DOD循环6000次15土地租赁费0元/Wh16度电折扣元/kWh17峰值电价1.0377元/kWh18商务确认平时电价0.6104元/kWh19谷时电价0.232元/kWh20年有效工作天数330天21项目开发费用元/Wh1、企业资信良好,国企、央企、事业单位、上市公司优先考虑;2、项目单体容量不低于5MWh;一项目前期费用合计单价总价(元)1.1前期踏勘、初设等0-备注二设备费用合计6,008,832.00装机容量(Wh)单位投资(元/Wh)编号名称数量单位1.60985301635992单价小计7390863.361电池簇单位6,609,715.20元781,148.166609715.21.2电池组1套%450,662.40元0781148.161.3BMS1套%200000901324.8元400000901324.82集装箱系统元60,088.32元02.140尺集装箱2套元120,176.640-2000003电源转换系统单位200000元600,883.204000003.1逆变升压一体仓1000kW%400000元180264.964储能控制系统%60088.32元120176.644.1EMS1套元0元05并网元600883.2元600883.25.4系统并网1项9,673,336.326其他6.1设计费1项6.2调试验收1项7土地租赁费7.1土地租赁费1项8建安费8.1土建施工及电气安装、装修19合计三费用汇总项目数量单位1静态投资9,673,336.32元其中:可抵扣增值税1,141,628.15元无形资产摊销元固定资产2动态投资8,531,708.17元9,673,336.32元其中:可抵扣增值税1,141,628.15元无形资产摊销元固定资产3平均每瓦时首年运营成本8,531,708.17元首年运营费用元/Wh年均运营成本增幅四建设资本结构30,044.16元2%项目数量1资本金投入9,673,336.32-资本金投入占比100%2建设投资借款--借款占比0%3可抵扣增值税1,141,628.154无形资产摊销5固定资产净值8,531,708.176固定资产总值9,673,336.32五运营资本结构项目数量1资本金投入-资本金投入占比100.0%2运营投资借款-借款占比0.0%3可抵扣增值税无形资产-土地摊销费用-4固定资产净值8,531,7085股权溢价资产6固定资产总值-9,673,336储能电站效益分析一、前置条件峰平价差0.4273峰谷价差一般工商业用电高峰平段低谷电价(元/KWh)1.03770.61040.232储能电站循环2KWh12:00-14:0005846.43113513514二、长江采日储能电站收益情况03568.661564886490有效容量5407.94880充电时间24:00-8:0010:00-12:00分阶段充电电量5846.431135135145002.35264元储能站购电成本1356.37202335135储能电站供电放电时间5190.941334528元日均分阶段电量05456.84908081816元日均分阶段电费07403.26449304216储能站售电收入986222.182459019日均营业收入00986222.1824590197、8、9三月日节省电费0986222.182459019基本电费每年330天150063.349722499986222.182459019207291.405805181986222.182459019月均节省电费(以27.5天计)986222.1824590197、8、9三月节省电费1972444.36491804986222.182459019986222.182459019三、结论Wh986222.182459019每月节省电费Wh986222.182459019元986222.182459019第一年年节省电费元/Wh986222.182459019元/Wh986222.182459019装机容量6008832次986222.182459019有效容量4596756.48次986222.182459019总投资9673336.32装机单价1.60985301635992单位有效单价2.10438302792146元0.3C80%循环元单年循环6000元660元元收益年年节省电费元第一年收益867,185.17元第二年收益846,770.37元第三年收益826,355.57元第四年收益805,940.77元第五年收益785,525.97元第六年收益765,111.17元第七年收益744,696.37元第八年收益724,281.57元第九年收益703,866.77元第十年收益683,451.97第十一年收益663,037.17第十二年收益642,622.37第十三年收益622,207.57第十四年收益601,792.78第十五年收益581,377.98注意:1、储能电池可用至电池报废为止年份建设期运营期123456789101112序号109,841,932.19,991,86110,123,11010,221,59910,303,72210,369,46710,411,77310,476,85710,483,75110,476,77810,455,92910,421,192项目9,673,3369,673,336837,1411,653,2662,448,3643,208,3523,949,6254,672,1735,368,9336,495,3937,071,0677,632,8758,180,8078,714,850--1,653,2662,448,3643,208,3523,949,6254,672,1735,368,9336,495,3937,071,0677,632,8758,180,8071资产-837,141837,141795,098759,988741,273722,548696,7601,126,460575,674561,808547,931534,044---816,125----------1.1流动资产总值-8,531,7086,825,3676,256,5865,687,8055,119,0254,550,2443,981,4643,412,6832,843,9032,275,1221,706,3421.1.1累计盈余资金7,962,928-1.1.2流动资金8,531,708-7,394,1471.2在建工程-1,141,628-1.3固定资产净值-9,673,3361,041,863-----492,596-----1.4无形及其他资产净值9,841,932.1944,447849,380756,661666,291578,26910,411,77310,476,85710,483,75110,476,77810,455,92910,421,1921.5其他资产(商誉)1,141,628-9,991,86110,123,11010,221,59910,303,72210,369,4671.6可抵扣增值税形成的资产9,673,336--------2负债及所有者权益-------------2.1流动负债总额--------------2.1.1本年短期借款------------2.1.2其他--------------2.2建设投资借款--------------2.3运营期借款-----------2.3.1年初借款余额-----2.3.2当期还本付息2.3.3本年还本--------------2.3.4本年付息-------------2.4流动资金借款9,673,3369,673,3369,841,9329,991,86110,123,11010,221,59910,303,72210,369,46710,411,77310,476,85710,483,75110,476,77810,455,92910,421,1922.5负债小计(2.1+2.2+2.3+2.4)9,673,3369,673,3369,673,3369,673,3369,673,3369,673,3369,673,3369,673,3369,673,3369,673,3369,673,3369,673,3369,673,3369,673,3362.6所有者权益--------------2.6.1实收资本(股本)--16,86031,85244,97754,82663,03969,61373,84480,35281,04180,34478,25974,7862.6.2资本公积--151,736286,672404,797493,436567,347626,518664,593723,168729,373723,098704,333673,0702.6.3累计盈余公积金2.6.4累计未分配利润--------------2.6.5固定资产残值--------------3check0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%0.0%4资产负债率(%)Endofform00等额本金02.3运营期借款2.3.1年初借款余额2.3.2当期还本付息2.3.3本年还本2.3.4本年付息等额本息2.3运营期借款2.3.1年初借款余额2.3.2当期还本付息2.3.3本年还本2.3.4本年付息等额还息,到期还本2.3运营期借款2.3.1年初借款余额2.3.2当期还本付息2.3.3本年还本2.3.4本年付息年份合计建设期运营期1.002.003.004.005.006.007.008.009.001.00-867,185.17846,770.37826,355.57805,940.77785,525.97765,111.17744,696.37724,281.57703,866.77序号项目(单767,420.50749,354.31731,288.11713,221.92695,155.72677,089.53659,023.34640,957.14622,890.95位:元)1,249,866.43-1,141,628.15---------1.00总收入(10,864,223.56--------49,112.619,717.10所含增值---------28,649.025,668.31--------20,463.594,048.79税)--------409,271.7880,975.8299,764.6797,416.0695,067.4592,718.8590,370.2488,021.6485,673.0380,975.82主营业务9,614,357.13-99,764.67-97,416.06-95,067.45-92,718.85-90,370.24-88,021.64-85,673.0383,324.431.00收入(未--1,141,628.15-1,041,863.48-944,447.42-849,379.97-756,661.12-666,290.88-578,269.24-492,596.20--492,596.20税收入)12,988.59-1,041,863.48-944,447.42-849,379.97-756,661.12-666,290.88-578,269.24-492,596.20-7,576.68767,420.50749,354.31731,288.11713,221.92695,155.72677,089.53659,023.34-613,173.852.00主营业务690,069.76成本598,824.70599,425.59600,038.49600,663.65601,301.31601,951.73602,615.15603,982.07568,780.54568,780.54568,780.54568,780.54568,780.54568,780.54568,780.54603,291.84568,780.543.00销售税金568,780.54568,780.54568,780.54568,780.54568,780.54568,780.54568,780.54568,780.54568,780.54及附加568,780.54--------3.10城市维护---------建设税-教育费附3.20加、地方5,411.91教育费附加.1当期交增108,238.28值税.1.1增值税销1,249,866.43项税-进项税(万元).1.2当期抵扣-1,141,628.15.1.3进项税额-1,141,628.15可抵扣增值税进项税额.1.4期末可抵-5,329,508.32扣增值税(资产负债表)4.00主营业务9,601,368.54-利润5.00其他业务利润6.00经营总费9,051,274.36用8,531,708.176.108,531,708.176.1.1固定费用折旧费-6.1.2工资福利-、劳保统-筹和住房-基金6.1.3保险费6.1.4摊销费6.1.5利息支出6.20可变费用519,566.18--30,044.1630,645.0431,257.9431,883.1032,520.7733,171.1833,834.6034,511.3035,201.52经营成本519,566.1830,044.1630,645.0431,257.9431,883.1032,520.7733,171.1833,834.6034,511.3035,201.526.2.1-运营每瓦成本6.2.2维修费-6.2.3土地租赁-7.00营业利润550,094.19--168,595.80149,928.72131,249.62112,558.2793,854.4175,137.8156,408.1986,777.919,191.788.00补贴收入8.10(应税)--财政补贴+免征专项财政补贴8.20中央财政补贴增值税免征--应该少交的增值税8.30地方财政补贴增值税免征--应该少交的增值税9.00营业外支-168,595.80149,928.72131,249.62112,558.2793,854.4175,137.8156,408.1986,777.919,191.7810.00出550,094.19---------11.0011.10利润总额-168,595.80149,928.72131,249.62112,558.2793,854.4175,137.8156,408.1986,777.919,191.7811.2.1550,094.1911.2.2弥补以前11.2.3年度亏损-11.2.4-11.2.5利润总额--11.3.1弥补以前-5年亏损-弥补以前4年亏损-弥补以前-3年亏损弥补以前2年亏损弥补以前1年亏损结转以后年度亏损额(-5)11.3.2结转以后年度亏损额(-4)11.3.3结转以后年度亏损额(-3)11.3.4结转以后-年度亏损11.3.5额(-2)-12.0012.10结转以后52,435.38---14,069.7811,731.809,392.2314,102.0521,694.482,297.9512.20年度亏损12.30额(-1)550,094.19--168,595.80149,928.72131,249.62112,558.2793,854.4175,137.8156,408.1986,777.919,191.7813.0014.00企业所得-10,113.80---14,069.7811,731.809,392.2314,102.0521,694.482,297.95税15.00-16.00应纳税所17.00得额560,207.98--168,595.80149,928.72131,249.6298,488.4982,122.6165,745.5842,306.1465,083.446,893.8418.00应缴所得56,020.80--16,859.5814,992.8713,124.969,848.858,212.266,574.564,230.616,508.34689.38税504,187.19--151,736.22134,935.85118,124.6688,639.6473,910.3559,171.0238,075.5358,575.096,204.45所得税抵扣504,187.19--151,736.22134,935.85118,124.6688,639.6473,910.3559,171.0238,075.5358,575.096,204.45净利润550,094.19--168,595.80149,928.72131,249.62112,558.2793,854.4175,137.8156,408.1986,777.919,191.78提取法定盈余公积金可供投资者分配的利润应付利润当期未分配利润息税前利润(利润总额+利息支出)息税折旧摊销前利19.00润(利润总9,081,802.36--737,376.34718,709.26700,030.17681,338.82662,634.96643,918.35625,188.73655,558.46577,972.33额+折旧费)10.0011.0012.00683,451.97663,037.17642,622.37604,824.75586,758.56568,692.37---9,435.279,153.438,871.605,503.915,339.505,175.103,931.363,813.933,696.5078,627.2276,278.6173,930.0178,627.2276,278.6173,930.01---595,389.49577,605.13559,820.77604,686.10605,404.21606,136.68568,780.54568,780.54568,780.54568,780.54568,780.54568,780.54----35,905.5536,623.6637,356.1435,905.5536,623.6637,356.14-9,296.61-27,799.08-46,315.92-9,296.61-27,799.08-46,315.92----9,296.61-27,799.08-46,315.92-2,324.15-6,949.77-11,578.98-9,296.61-27,799.08-46,315.92-2,324.15-6,949.77-11,578.98-6,972.46-20,849.31-34,736.94-697.25-2,084.93-3,473.69-18,764.38-31,263.24-6,275.21-6,275.21-18,764.38-31,263.24-9,296.61-27,799.08-46,315.92559,483.94540,981.46522,464.63建设期运营期12345678910111210-837,1411,653,2662,448,3643,208,3523,949,6254,672,1735,368,9336,495,3937,071,0677,632,8758,180,8071期初(元)-9,673,336-9,673,336837,141816,125795,098759,988741,273722,548696,7601,126,460575,674547,931534,0442现金变化(元)561,8082.1净利润168,596149,929131,25098,48882,12365,74642,30665,0836,894-20,849-34,7372.2折旧568,781568,781568,781568,781568,781568,781568,781568,781568,781-6,972568,781568,7812.3摊销568,7812.4本金还款-----------2.5可抵扣增值税资产变化----------2.6建设投资99,76597,41695,06792,71990,37088,02285,673492,596----2.7回收固定资产余值--2.8流动资金回收-30,044-31,258-31,883-32,521-33,171-33,835-34,511-35,202-37,3563期末--30,645-35,906-36,624-837,1412,448,3643,208,3523,949,6254,672,1735,368,9336,495,3937,071,0678,714,850无杠杆回报1,653,2667,632,8758,180,807息税后净现金流量(元)837,141795,098759,988741,273722,548696,7601,126,460575,674534,044-9,673,336-9,673,336-8,836,195816,125-7,224,972-6,464,984-5,723,711-5,001,163-4,304,404-3,177,943-2,602,269561,808547,931-958,486累计息税后净现金流量(元)-8,836,195-8,020,070-2,040,461-1,492,53013.87年1.001.001.001.001.001.001.001.00无杠杆投资回收期1.001.000.000.000.000.000.000.000.000.000.000.001.001.00无杠杆项目回报率0.000.000.79%流动资金0123456780846,770.37826,355.57805,940.77785,525.970铺底流动资金0867,185.171售电收入(含税)-765,111.17744,696.37724,281.57-应缴纳电费---2应收账款----------------3库存----------------4现金-----33,171.1833,834.6034,511.3030,044.1630,645.0431,257.9431,883.1032,520.775应付账款-设备-33,171.18-33,834.60-34,511.30-30,044.16-30,645.04-31,257.94-31,883.10-32,520.776应付账款-建安-650.42-663.42-676.69-30,044.16-600.88-612.90-625.16-637.667应付账款-付现运---------9,392.2314,102.0521,694.48维-49,112.61---14,069.7811,731.80---409,271.788流动资金余额-------------1,126,460.189流动资金变动-722,547.76696,759.726,495,392.90837,141.01816,125.32795,097.62759,987.88741,273.404,672,173.005,368,932.7110当期还本付息837,141.011,653,266.332,448,363.953,208,351.833,949,625.2311企业所得税12销售税金及附加13应交增值税14流动资金余额15累计盈余资金9101112703,866.77683,451.97663,037.17642,622.37--------------------35,201.5235,905.5536,623.6637,356.14-36,623.66-37,356.14-35,201.52-35,905.55-718.11-732.47-690.23-704.03-6,949.77-11,578.989,153.438,871.60--76,278.6173,930.012,297.95-2,324.15547,931.239,717.109,435.278,180,806.60534,043.6180,975.8278,627.228,714,850.21575,674.38561,808.097,071,067.287,632,875.37借款总额1-利息34.95%-2-4偿还本金--借款余额----偿还利息----还本付息总额----等额本金56789--------------------10----

1、当您付费下载文档后,您只拥有了使用权限,并不意味着购买了版权,文档只能用于自身使用,不得用于其他商业用途(如 [转卖]进行直接盈利或[编辑后售卖]进行间接盈利)。
2、本站所有内容均由合作方或网友上传,本站不对文档的完整性、权威性及其观点立场正确性做任何保证或承诺!文档内容仅供研究参考,付费前请自行鉴别。
3、如文档内容存在违规,或者侵犯商业秘密、侵犯著作权等,请点击“违规举报”。

碎片内容

碳中和
已认证
内容提供者

碳中和

确认删除?
回到顶部
微信客服
  • 管理员微信
QQ客服
  • QQ客服点击这里给我发消息
客服邮箱