零碳园区光储智能微网投资收益测算模型.xlsx
下载文档
上传人:地**
编号:1232558
2024-10-11
40页
58.86KB
1、光储智能微网投资测算表光伏部分77,120,640单价(元/w)项目成本占比 光伏面积(m2)210,0004.5单位功率(Kw/m2)0.08光伏功率(Kw)17,138单位组件价格(Rmb/Kw)2,000含逆变器单位工程造价(Rmb/Kw)2,500含支架单位造价(Rmb/Kw)4,500*光伏转换衰减率0.45%光伏造价77,120,640储能部分16,000,000单价(元/kwh)储能系统(Kwh)3,2005000储能功率(Kw)2,520单位成本(Rmb/Kwh)4,375施工成本2,000,000电池衰减率2%运维成本984,896光伏单位运维(Rmb/Kw)50.00光伏小2、计856,896储能单位运维(Rmb/Kwh)40.00运维成本占比128,000*保险成本195,553保险成本占比0.21%占初始投资比光伏161,953储能33,600*场地租金-光伏面积(m2)210,000单位租金(Rmb/m2)-*峰谷套利476,063减少购电成本*M7-8非夏季循环模式谷-尖-平-峰-谷谷-峰-平-峰-谷尖谷价差0.606峰谷价差0.528 0.528峰平价差0.267 0.267充电上限100%100%放电下限5%5%充电深度95%95%*系统效率88%88%实际放电深度84%84%*每日套利1,304 1,304月度储能循环电量182,400182,400*3、月度余光储存电量48,00048,000市网占比74%74%首年套利收益476,063首年午峰晚纳减少上网收益 209,802税率政策所得税率25%三免三减半增值税率13%增值税附加税率13%折旧政策储能系统折旧年限10年限折旧法光伏系统折旧期限15年限折旧法残值率5%阳光工匠论坛()光伏/储能/能源/电力资料下载 QQ群:940233279 微信:15961178146(微信同号)电价信息时段M7-8非夏季谷时段0.2950.295平时段0.5560.556峰时段0.8230.823尖时段0.901上网电价0.360M7-8发电占比非夏季发电占比07:0010:00平10%平5%10:0014、1:00峰15%峰15%11:0013:00尖25%峰30%13:0015:00峰25%峰30%15:0016:00平10%平15%16:0017:00尖10%平5%17:0018:00平5%平18:0021:00峰峰21:0023:00平平23:0007:00谷谷电量信息利用小时1200系统效率99%发电量(Kwh)20,359,849 发电占比M7-8发电量3,848,01119%其中:平962,00325%峰1,539,20540%尖1,346,80435%非夏季发电量16,511,83881%其中:平4,127,95925%峰12,383,87875%M2-5发电量6,539,342M5、2-5余电上网2,712,00041%午峰余电上网M2-5充电减少余电上网345,600全年余光储存量576,0003%午峰电晚峰纳光储智能微网投资测算表发电收入年发电收入(标准)15,499,746其中:M7-8发电量3,014,321非夏季12,485,426峰电上网减少收入-1,095,643午峰电晚峰纳减少收入-56,886实际年发电收入14,347,218没储能时峰电上网-266,688没储能时实际收入14,137,415容量电价(Rmb/Kw)48减少最大需量节约成本-光伏受天气影响,很难减少最大需量项目融资融资比例70%融资期限10融资利率5.4%阳光工匠论坛()光伏/储能/能源6、/电力资料下载 QQ群:940233279 微信:15961178146(微信同号)项目测算类别项目名称金额(含税)占比 金额(不含税)运营收入光伏发电14,347,21897%12,696,653补贴收入0%-削峰填谷476,0633%421,294节约容量-0%-合计14,823,28013,117,947运营成本用电成本0%场地租金-0%-运维成本984,896100%929,147合计984,896929,147建设成本储能部分16,000,00017%14,159,292光伏部分77,120,64083%70,752,881合计93,120,64084,912,173项目EBITDA7、13,838,384.29项目回收周期(年)7.65全投资IRR10.83%权益回收周期(年)7.78权益IRR16.21%增值税1,650,565-54,768-14823280光伏发电14347218121951351,705,333984896削峰填谷476063404653.55-13838384小计14823281259978.8-85%运维成本984896837161.655,7491176262655,7492075757.61,840,7086,367,7598,208,4672152082.771409.45222349.2147734.4光储站收益模型测算表012光伏衰减率8、99.00%98.55%发电收入14,347,21814,139,828储能循环收入476,063466,542容量电价减免-销项税率1,705,3331,680,379年总收入13,117,94712,925,991场地费00折旧费用5,826,1495,826,149维护及其他984,896984,896保险费用195,553195,553增值税附加00进项税率8,208,467124,376124,376年总成本6,882,2226,882,222增值税留底税额8,208,4676,627,5105,071,507实缴增值税00毛利6,235,7256,043,769所得税净利润6,239、5,7256,043,769净现金流-93,120,64013,642,83113,425,921累计净现金流-93,120,640-79,477,809-66,051,888NPV3,433,955回收期7.65IRR10.83%阳光工匠论坛()光伏/储能/能源/电力资料下载 QQ群:940233279 微信:15961178146(微信同号)34567898.11%97.67%97.23%96.79%96.36%95.92%14,076,19914,012,85613,949,79813,887,02413,824,53313,762,322457,211448,066439,10543010、,323421,717413,282-1,671,9851,663,6461,655,3611,647,1281,638,9491,630,82212,861,42512,797,27712,733,54312,670,21912,607,30012,544,7830000005,826,1495,826,1495,826,1495,826,1495,826,1495,826,149984,896984,896984,896984,896984,896984,896195,553195,553195,553195,553195,553195,553000138,984196,895195,8311、8124,376124,376124,376124,376124,376124,3766,882,2226,882,2226,882,2227,021,2077,079,1177,078,0603,523,8971,984,627453,6420000001,069,1111,514,5731,506,4465,979,2035,915,0555,851,3215,649,0125,528,1845,466,723739,382731,415706,1271,382,0461,366,6815,979,2035,175,6735,119,9064,942,8864,146,1384,100,012、4213,352,96112,541,09212,477,03911,222,6769,972,2869,926,191-52,698,928-40,157,836-27,680,797-16,458,121-6,485,8353,440,356光储站收益模型测算表阳光工匠论坛()光伏/储能/能源/电力资料下载 QQ群:940233279 微信:15961178146(微信同号)9101112131495.49%95.06%94.63%94.21%93.78%93.36%13,700,39213,638,74013,367,56413,306,46513,245,64213,185,0934013、5,017396,916-1,622,7461,614,7221,537,8611,530,8321,523,8351,516,86912,482,66212,420,93511,829,70211,775,63311,721,80711,668,2240000005,826,1495,826,1494,481,0164,481,0164,481,0164,481,016984,896984,896984,896984,896984,896984,896195,553195,553195,553195,553195,553195,553194,788193,745183,753182,839114、81,930181,024124,376124,376124,376124,376124,376124,3767,077,0107,075,9675,720,8435,719,9295,719,0195,718,1140000001,498,3701,490,3461,413,4861,406,4571,399,4591,392,4935,405,6525,344,9686,108,8606,055,7046,002,7885,950,1101,351,4131,336,2421,527,2151,513,9261,500,6971,487,5284,054,2394,008,7264,58115、,6454,541,7784,502,0914,462,5839,880,3889,834,8749,062,6619,022,7948,983,1078,943,59813,320,74423,155,61832,218,27941,241,07350,224,17959,167,77815161718192092.94%92.52%92.11%91.69%91.28%90.87%13,124,81613,064,81013,005,07412,945,60712,886,40812,827,475-1,509,9351,503,0311,496,1591,489,3181,482,507116、,475,72711,614,88111,561,77911,508,91511,456,29011,403,90111,351,7480000004,481,01600000984,896984,896984,896984,896984,896984,896195,553195,553195,553195,553195,553195,553180,123179,225178,332177,442176,557175,676124,376124,376124,376124,376124,376124,3765,717,2121,235,2991,234,4051,233,5161,232,6317、11,231,7490000001,385,5591,378,6561,371,7831,364,9421,358,1311,351,3525,897,66910,326,48010,274,51010,222,77310,171,27010,119,9981,474,4172,581,6202,568,6272,555,6932,542,8182,530,0004,423,2527,744,8607,705,8827,667,0807,628,4537,589,9998,904,2687,744,8607,705,8827,667,0807,628,4537,589,99968,072,0418、575,816,90583,522,78891,189,86898,818,320106,408,319212223242590.46%90.05%89.65%89.25%88.84%12,768,80712,710,40312,652,26312,594,38312,536,764-1,468,9781,462,2591,455,5701,448,9111,442,28311,299,82911,248,14511,196,69311,145,47211,094,4820000000000984,896984,896984,896984,896984,896195,553195,55319519、,553195,553195,553174,798173,925173,055172,190171,328124,376124,376124,376124,376124,3761,230,8721,229,9981,229,1291,228,2631,227,402000001,344,6021,337,8831,331,1941,324,5361,317,90710,068,95710,018,1469,967,5649,917,2099,867,0802,517,2392,504,5372,491,8912,479,3022,466,7707,551,7187,513,6107,475,620、737,437,9067,400,3107,551,7187,513,6107,475,6737,437,9067,400,310113,960,037121,473,647128,949,319136,387,226143,787,536光储站收益模型测算表12发电收入14,347,21814,139,828储能循环收入476,063466,542容量电价减免-销项税率1,705,3331,680,379年总收入13,117,94712,925,991场地费00折旧费用5,826,1495,826,149维护及其他984,896984,896保险费用195,553195,553增值税附加0021、进项税率8,208,467124,376124,376财务费用3,343,9622,991,966年总成本10,226,1849,874,188增值税留底税额8,208,4676,627,5105,071,507实缴增值税00毛利2,891,7633,051,803所得税净利润2,891,7633,051,803净现金流-27,936,1923,780,4243,915,510累计净现金流-27,936,192-24,155,768-20,240,258NPV6,691,806回收期7.78IRR16.21%阳光工匠论坛()光伏/储能/能源/电力资料下载 QQ群:940233279 微信:1522、961178146(微信同号)34567814,076,19914,012,85613,949,79813,887,02413,824,53313,762,322457,211448,066439,105430,323421,717413,282-1,671,9851,663,6461,655,3611,647,1281,638,9491,630,82212,861,42512,797,27712,733,54312,670,21912,607,30012,544,7830000005,826,1495,826,1495,826,1495,826,1495,826,1495,826,1499823、4,896984,896984,896984,896984,896984,896195,553195,553195,553195,553195,553195,553000138,984196,895195,838124,376124,376124,376124,376124,376124,3762,639,9702,287,9741,935,9781,583,9821,231,986879,9909,522,1929,170,1968,818,2008,605,1898,311,1037,958,0503,523,8971,984,627453,6420000001,069,1111,514,24、5731,506,4463,339,2323,627,0813,915,3434,065,0304,296,1984,586,733453,385489,418508,1291,074,0491,146,6833,339,2323,173,6953,425,9253,556,9013,222,1483,440,0494,194,5464,020,6694,264,6143,318,2472,529,8522,747,753-16,045,713-12,025,043-7,760,430-4,442,183-1,912,331835,423光储站收益模型测算表阳光工匠论坛()光伏/储能/能源/电25、力资料下载 QQ群:940233279 微信:15961178146(微信同号)9101112131413,700,39213,638,74013,367,56413,306,46513,245,64213,185,093405,017396,916-1,622,7461,614,7221,537,8611,530,8321,523,8351,516,86912,482,66212,420,93511,829,70211,775,63311,721,80711,668,2240000005,826,1495,826,1494,481,0164,481,0164,481,0164,481,01626、984,896984,896984,896984,896984,896984,896195,553195,553195,553195,553195,553195,553194,788193,745183,753182,839181,930181,024124,376124,376124,376124,376124,376124,376527,994175,99800007,605,0047,251,9655,720,8435,719,9295,719,0195,718,1140000001,498,3701,490,3461,413,4861,406,4571,399,4591,392,49327、4,877,6585,168,9706,108,8606,055,7046,002,7885,950,1101,219,4151,292,2421,527,2151,513,9261,500,6971,487,5283,658,2443,876,7274,581,6454,541,7784,502,0914,462,5832,965,9473,184,4319,062,6619,022,7948,983,1078,943,5983,801,3706,985,80116,048,46125,071,25534,054,36242,997,96115161718192013,124,81613,028、64,81013,005,07412,945,60712,886,40812,827,475-1,509,9351,503,0311,496,1591,489,3181,482,5071,475,72711,614,88111,561,77911,508,91511,456,29011,403,90111,351,7480000004,481,01600000984,896984,896984,896984,896984,896984,896195,553195,553195,553195,553195,553195,553180,123179,225178,332177,442176,55729、175,676124,376124,376124,376124,376124,376124,3760000005,717,2121,235,2991,234,4051,233,5161,232,6311,231,7490000001,385,5591,378,6561,371,7831,364,9421,358,1311,351,3525,897,66910,326,48010,274,51010,222,77310,171,27010,119,9981,474,4172,581,6202,568,6272,555,6932,542,8182,530,0004,423,2527,744,86030、7,705,8827,667,0807,628,4537,589,9998,904,2687,744,8607,705,8827,667,0807,628,4537,589,99951,902,22859,647,08867,352,97075,020,05182,648,50390,238,502212223242512,768,80712,710,40312,652,26312,594,38312,536,764-1,468,9781,462,2591,455,5701,448,9111,442,28311,299,82911,248,14511,196,69311,145,47211,031、94,4820000000000984,896984,896984,896984,896984,896195,553195,553195,553195,553195,553174,798173,925173,055172,190171,328124,376124,376124,376124,376124,376000001,230,8721,229,9981,229,1291,228,2631,227,402000001,344,6021,337,8831,331,1941,324,5361,317,90710,068,95710,018,1469,967,5649,917,2099,867,32、0802,517,2392,504,5372,491,8912,479,3022,466,7707,551,7187,513,6107,475,6737,437,9067,400,3107,551,7187,513,6107,475,6737,437,9067,400,31097,790,220105,303,830112,779,502120,217,409127,617,719光储站收益模型测算表012光伏衰减率99.00%98.55%发电收入14,137,41513,933,059储能循环收入-容量电价减免-销项税率1,626,4281,602,918年总收入12,510,98712,333、30,141场地费00折旧费用4,481,0164,481,016维护及其他856,896856,896保险费用161,953161,953增值税附加00进项税率6,367,759107,748107,748年总成本5,392,1175,392,117增值税留底税额6,367,7594,849,0793,353,909实缴增值税00毛利7,118,8706,938,024所得税净利润7,118,8706,938,024净现金流-77,120,64013,118,56612,914,210累计净现金流-77,120,640-64,002,074-51,087,865NPV15,868,519回收34、期6.58IRR13.68%阳光工匠论坛()光伏/储能/能源/电力资料下载 QQ群:940233279 微信:15961178146(微信同号)3456798.11%97.67%97.23%96.79%96.36%13,870,36013,807,94413,745,80813,683,95213,622,374-1,595,7051,588,5241,581,3761,574,2601,567,17612,274,65512,219,41912,164,43212,109,69212,055,198000004,481,0164,481,0164,481,0164,481,0164,481,35、016856,896856,896856,896856,896856,896161,953161,953161,953161,953161,95300141,499190,647189,726107,748107,748107,748107,748107,7485,392,1175,392,1175,533,6165,582,7645,581,8431,865,952385,176000001,088,4521,466,5121,459,4286,882,5386,827,3026,630,8166,526,9286,473,356853,413828,852815,8661,618,339636、,882,5385,973,8895,801,9645,711,0624,855,01712,851,51111,935,68110,668,15510,192,0789,336,032-38,236,354-26,300,672-15,632,517-5,440,4393,895,593光储站收益模型测算表阳光工匠论坛()光伏/储能/能源/电力资料下载 QQ群:940233279 微信:15961178146(微信同号)8910111295.92%95.49%95.06%94.63%94.21%13,561,07313,500,04813,439,29813,378,82113,318,6137、7-1,560,1231,553,1031,546,114-12,000,95011,946,94511,893,18413,378,82113,318,617000004,481,0164,481,0164,481,0164,481,0164,481,016856,896856,896856,896856,896856,896161,953161,953161,953161,953161,953188,809187,896186,98800107,748107,748107,748107,748107,7485,580,9265,580,0135,579,1055,392,1175,392,38、117000107,748215,4961,452,3751,445,3551,438,366006,420,0246,366,9326,314,0807,986,7047,926,5001,605,0061,591,7331,578,5201,996,6761,981,6254,815,0184,775,1994,735,5605,990,0285,944,8759,296,0349,256,2159,216,57610,363,29610,318,14213,191,62722,447,84231,664,41842,027,71452,345,856阳光工匠论坛()光伏/储能/能源/电力39、资料下载 QQ群:940233279 微信:15961178146(微信同号)131415161793.78%93.36%92.94%92.52%92.11%13,258,68313,199,01913,139,62313,080,49513,021,633-13,258,68313,199,01913,139,62313,080,49513,021,633000004,481,0164,481,0164,481,01600856,896856,896856,896856,896856,896161,953161,953161,953161,953161,95300000107,748107,40、748107,748107,748107,7485,392,1175,392,1175,392,117911,101911,101323,244430,993538,741646,489754,237000007,866,5667,806,9027,747,50612,169,39412,110,5311,966,6411,951,7251,936,8773,042,3483,027,6335,899,9245,855,1765,810,6309,127,0459,082,89910,273,19210,228,44410,183,8979,019,2978,975,15062,619,04841、72,847,49283,031,38992,050,686101,025,837181920212291.69%91.28%90.87%90.46%90.05%12,963,03512,904,70212,846,63012,788,82112,731,271-12,963,03512,904,70212,846,63012,788,82112,731,2710000000000856,896856,896856,896856,896856,896161,953161,953161,953161,953161,95300000107,748107,748107,748107,748107,742、48911,101911,101911,101911,101911,101861,985969,7331,077,4811,185,2291,292,9780000012,051,93411,993,60011,935,52911,877,71911,820,1703,012,9842,998,4002,983,8822,969,4302,955,0429,038,9518,995,2008,951,6478,908,2908,865,1278,931,2028,887,4528,843,8998,800,5418,757,379109,957,039118,844,491127,688,3943、0136,488,932145,246,31123242589.65%89.25%88.84%12,673,98012,616,94712,560,171-12,673,98012,616,94712,560,171000000856,896856,896856,896161,953161,953161,953000107,748107,748107,748911,101911,101911,1011,400,7261,508,4741,616,22200011,762,87911,705,84611,649,0702,940,7202,926,4622,912,2678,822,1598,744、79,3858,736,8028,714,4118,671,6368,629,054153,960,722162,632,358171,261,413光储站收益模型测算表012光伏衰减率99.00%98.55%午峰晚纳减少上网收益209,802205,606储能循环收入476,063466,542容量电价减免-销项税率78,90577,327年总收入606,960594,821场地费00折旧费用1,345,1331,345,133维护及其他128,000128,000保险费用33,60033,600增值税附加00进项税率8,208,46716,62816,628年总成本1,490,1051,445、90,105增值税留底税额8,208,4678,146,1908,085,491实缴增值税00毛利-883,145-895,284所得税净利润-883,145-895,284净现金流-93,120,640524,265510,548累计净现金流-93,120,640-92,596,375-92,085,827NPV-82,592,226回收期0.00IRR-31.97%阳光工匠论坛()光伏/储能/能源/电力资料下载 QQ群:940233279 微信:15961178146(微信同号)345698.11%97.67%97.23%96.79%201,494197,464193,515189,64546、457,211448,066439,105430,323-75,78074,26572,77971,324582,925571,266559,841548,64400001,345,1331,345,1331,345,1331,345,133128,000128,000128,000128,00033,60033,60033,60033,600000016,62816,62816,62816,6281,490,1051,490,1051,490,1051,490,1058,026,3387,968,7017,912,5497,857,8530000-907,181-918,839-930,2647、4-941,461-114,855-116,283-117,683-907,181-803,984-813,981-823,779497,105598,786587,303576,050-91,588,722-90,989,937-90,402,634-89,826,583光储站收益模型测算表阳光工匠论坛()光伏/储能/能源/电力资料下载 QQ群:940233279 微信:15961178146(微信同号)7891096.36%95.92%95.49%95.06%185,852182,135178,492174,922421,717413,282405,017396,916-69,89768,48、49967,12965,787537,671526,918516,379506,05200001,345,1331,345,1331,345,1331,345,133128,000128,000128,000128,00033,60033,60033,60033,600000016,62816,62816,62816,6281,490,1051,490,1051,490,1051,490,1057,804,5837,752,7127,702,2107,653,0510000-952,434-963,188-973,726-984,053-238,109-240,797-243,431-246,49、013-714,326-722,391-730,294-738,040684,077674,614665,340656,252-89,142,507-88,467,893-87,802,553-87,146,301阳光工匠论坛()光伏/储能/能源/电力资料下载 QQ群:940233279 微信:15961178146(微信同号)11121314-000000000000000000000000000000000000000000-87,146,301-87,146,301-87,146,301-87,146,30115161718-00000000000000000000000000000000000000000000-87,146,301-87,146,301-87,146,301-87,146,30119202122-00000000000000000000000000000000000000000000-87,146,301-87,146,301-87,146,301-87,146,301232425-000000000000000000000000000000000-87,146,301-87,146,301-87,146,301
CAD图纸
上传时间:2022-06-30
21份