光伏建设整县推进投资收益计算模型VIP专享VIP免费

版本号修改内容8.0初始基准稿8.18.118.128.138.148.158.168.178.18增加反向计算功能。1,通过给定年利用小时数,目标IRR值,上网电价,反向计算需要的初始投资成本。2,通过给定年利用小时数,目标IRR值,初始投资成本,反向计算需要的上网电价。修改维修费率默认值。1,原维修费率默认值,前2年为0.3%,0.3%,3到5年的维修费率为0.00001%,6到20年为1%。修改为和边界条件表保持一致。前2年0.2%,3到20年为0.8%。2,保险费率和材料费和边界条件对齐,改为保险费率0.25%,材料费0.15%修改维修费率默认值。1,解决了全投资税后IRR跟随利率变化的Issue。全投资税前/税后IRR跟利率没有关系,原版本存在Bug。2,租地费原853000没有依据,修改为土地费=每亩每年租用费MW土地亩数项目容量(缺省值为300块每亩每年,25亩/MW,100MW项目)修改了LCOE的计算公式增值税税率从17%下调到13%;增加发电量粗略估算修改项目地,按照固定支架自动填写简单测算发电量到表格中。修改了LCOE的计算公式,可支持到25年,利息计入运营成本修改了LCOE引用的折现值,可设置,利率4.9%,折现默认6%。根据利率可适当调整折现率。修改了反算Capex,可低到0.05,方便储能的价格反算1,修改自动计算回收期2,修正了财务计算中的其它费用和利息相关小错误3,删除反算电价,反算成本功能4,删除查询发电量,计算发电量按钮,改成自动查询和计算1,修改了可适应分布式客户用的材料费,运维费为0情况的测算2,城市建设税5%,教育费5%,作为附加税,可修改3,单独分布式测算的页面,简单输入,方面测算4,修正利息根据维修分+土地费判断的小错误ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为机密,未经许可不得扩散第2页,共89页输入信息项目值屋顶信息屋顶面积2000屋顶面积利用率70%组件信息组件功率570组件面积2.8组件每年衰减率0.70%是否配置优化器否成本信息光伏初装成本4.01运维费用0.02屋顶租赁费0.00保险费率0.25%售电信息首年发电量1002上网电价0.4153用电电价0.57自发自用率80%税费增值税13%所得税率25%贷款模式贷款年限15贷款利息4.35%贷款比例80%折现率4.00%输出信息可安装光伏容量285.00每平米安装容量142.50电站初装成本4.01电站首年发电量1002综合电价0.53906度电成本0.1733初始投资总计114.29自有资金22.86贷款资金91.43投资回收期4.9318.16%62.40%172.85388.09年均发电量46.381205.755727.33相当于种树7824全部投资IRR(税后)自有资金IRRNPV(全部投资)25年发电利润总额25年总发电量25年CO2减排ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为机密,未经许可不得扩散第3页,共89页发电每度电减少排放0.475kg,用电减少排放0.6kg,一棵树一年吸收18.3kgCO2,每棵树40年寿命ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为机密,未经许可不得扩散第4页,共89页备注优化器信息设置优化器成本0.4可利用面积发电量提升10%Wpm2需填写银行贷款年限银行贷款利息初始投资中贷款资金的比例可根据当地金融成本进行修改KWpWkWh/kWp万元万元万元年内部投资回报率内部投资回报率万元万元顿棵m2,需要填写元/Wp,不含优化器成本,需填写元/Wp/年元/Wp/年/总投资/年kWh/kWp,不含优化器提升,需填写元/kWh,需填写元/kWh,需填写元/Wp元/kWh元/kWh万Kwh万Kwh12345678910111213-2,000,000-1,000,000-1,000,0002,000,0003,000,0004,000,000所得税后净现金流累计ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为机密,未经许可不得扩散第5页,共89页用电减少排放0.6kg,一棵树一年吸收18.3kgee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为机密,未经许可不得扩散第6页,共89页化器信息设置初始投资成本参考费用名称光伏组件1.85光伏支架0.3组件优化器0逆变器0.18光伏并网箱0.08变压器0.2电缆0.3通信和监控0工程与其他0.5项目开发费0建设管理费0.1勘察设计费0.1其他税费0.2屋顶加固合计3.81元/Wp单W价格(元/W)45678910111213141516171819202122232425所得税后净现金流累计所得税后净现金流ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第7页,共89页初始投资成本运维及财务成本费用名称初始投资参数名称光伏组件1.7484,500电站规模光伏支架0.385,500投资周期逆变器0.1542,750度电价格光伏汇流箱0-贷款年限配电柜0.0822,800贷款利息变压器0-贷款比例电缆0.128,500流动资金升压站0-维修费率通信和监控0-运维人数安防工程与其他-人员薪资组件区施工0.385,500材料费厂区建筑-保险费率交通工程-所得税率建设用地费0.385,500上缴增值税率建设管理费-免税额生产准备费-资产残值率勘察设计费0.128,500固定资产比例其他税费-贷款金额合计3.03863,550租地费固定资产合计4.01001,142,850折现率初始投资合计4.01001,142,850动态投资合计4.10301,169,364投资期预研上网电量年份项目上网电量项目地区1,768,040503,891年发电小时1,755,664500,364组件衰减率1,743,374496,862支架类型1,731,170493,384直流配比1,719,052489,930灰尘遮挡1,707,019486,500总发电量1,695,070483,095年均发电小时1,683,204479,7131,671,422476,3551,659,722473,0211,648,104469,7101,636,567466,422单W价格固定资产折旧年限发电量default粗略每MW发电量第1年第2年第3年第4年第5年第6年第7年第8年第9年第10年第11年第12年ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第8页,共89页1,625,111463,1571,613,735459,9151,602,439456,6951,591,222453,4981,580,084450,3241,569,023447,1721,558,040444,0411,547,134440,9331,536,304437,8471,525,550434,7821,514,871431,7381,504,267428,7161,493,737425,7151,627,197463,75112057529.1911082第13年第14年第15年第16年第17年第18年第19年第20年第21年第22年第23年第24年第25年25年平均25年总发电量6.00008.000010.000012.0000ChartTitleee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第9页,共89页beforeafter税前回收期税后回收期1-879779.426916-879779.4269161.001.002-618610.247718588-618610.2477185881.001.003-387446.104239912-387446.1042399121.001.004-163697.185926022-186111.3211452581.001.00558425.590084670913800.5874340980.740.936278933.606788289212299.5816197640.000.007497838.167499981387586.9612935330.000.008715150.496411692561680.1671173160.000.009930881.739146021734587.5583080630.000.00101145042.96330621906317.4355682040.000.00111357645.159022281076878.041495250.000.00121568699.239493331246277.560988550.000.00131778216.041526091414524.121653110.000.00141986206.326069621581625.794200760.000.00152192680.778746341747590.59284830.000.00162397650.010379331912426.475713040.000.00172601124.557515882076141.345205460.000.00182803114.882947482238743.048419160.000.00193003631.376226062400239.377518090.000.00203202684.354176692560638.070121060.000.00213400284.061406662719946.809683540.000.00223596440.670811032878173.225876820.000.00233791164.284074563035324.894964470.000.00243984464.932170253191409.340176230.000.00254233495.075854273403576.532079250.000.00合计4.744.9380085090095010001050110011501200125013000.00002.00004.00006.00008.000010.000012.0000ChartTitleColumnPee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第10页,共89页运维及财务成本所得税减免注释参数值年数0.285电站运行年限25每度电售价(含税)0.5391银行贷款年限15银行贷款利息4.35%初始投资中贷款资金的比例80.00%0每年维修费用占初始成本比0.50%项目所需运维人员数量00维修费率变化每年材料费率0.00%0.00%年数每年保险费率0.25%所得税与利润总额的比例25.00%增值税额占销售额的比率13.00%可抵扣增值税的进项税额74,285折旧后剩余价值5.00%固定资产占总投资的比例100.00%贷款总金额914280整个项目每年的租地费用0折现率4.00%固定资产折旧年限25项目所在省市包头电站运行理论发电小时数(基线1768.0组件平均每年的衰减比0.70%项目支架类别固定支架1.3灰尘对组件功率的影响比值1.00%40679923平均每年的发电量小时数1627.20电站直流装机容量(MW)第1年第2年第3年第4年第5年第6年每MW所需流动成本(万元)第7年第8年运维人员薪资、福利(万元)第1年第2年第3年第4年第5年第6年第7年第8年第9年第10年发电量default粗略计算项目DC/AC比率电站投资周期内每MW总发电量ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第11页,共89页地区呼和浩特包头乌海赤峰通辽鄂尔多斯呼伦贝尔巴彦淖尔乌兰察布乌兰浩特锡林浩特西宁格尔木兰州嘉峪关金昌白银天水武威张掖酒泉平凉庆阳海南地区-共和县海北地区-海晏县海东地区-平安县海西地区-德令哈果洛地区-达日县玉树地区-玉树县黄南地区-同仁县ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第12页,共89页定西陇南临夏回族自治州甘南藏族自治州银川石嘴山吴忠(青铜峡)固原中卫乌鲁木齐克拉玛依哈密吐鲁番阿克苏喀什和田塔城阿勒泰伊宁博乐昌吉库尔勒阿图什昌都山南日喀则那曲阿里林芝西安宝鸡咸阳渭南铜川延安榆林汉中安康商洛济南青岛淄博东营潍坊ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第13页,共89页烟台枣庄威海济宁泰安日照莱芜临沂德州聊城滨州菏泽石家庄保定承德唐山秦皇岛邯郸邢台张家口沧州廊坊衡水太原大同朔州阳泉长治晋城忻州晋中临汾运城吕梁郑州开封洛阳焦作平顶山鹤壁新乡安阳濮阳商丘ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第14页,共89页许昌漯河信阳三门峡南阳周口驻马店武汉宜昌荆州十堰潜江黄石常德长沙株洲郴州衡阳合肥芜湖蚌埠淮南淮北安庆黄山阜阳宿州攀枝花甘孜阿坝昆明曲靖玉溪丽江普洱临沧德宏怒江迪庆楚雄昭通大理红河凉山-西昌ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第15页,共89页保山文山西双版纳广州清远韶关河源梅州潮州汕头揭阳汕尾惠州东莞深圳珠海中山江门佛山肇庆云浮阳江茂名湛江南宁桂林百色玉林钦州北海梧州柳州河池防城港贺州来宾崇左贵港海口三亚琼海白沙保亭昌江ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第16页,共89页澄迈儋州定安东方乐东临高陵水琼中屯昌万宁文昌五指山南京徐州连云港盐城泰州镇江南通常州无锡苏州淮安宿迁扬州杭州绍兴宁波湖州嘉兴金华丽水温州台州舟山衢州福州莆田南平厦门泉州漳州三明龙岩ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第17页,共89页宁德南昌九江景德镇上饶鹰潭宜春萍乡赣州吉安抚州新余北京上海天津ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第18页,共89页所得税减免财务指标汇总注释税率序号0.00%10.00%20.00%312.50%412.50%512.50%6789维修费率变化10注释费率110.00%120.00%130.00%140.00%150.00%160.00%170.00%180.00%190.00%200.00%212223第1年折扣的税率,没有请留空第2年折扣的税率,没有请留空第3年折扣的税率,没有请留空第4年折扣的税率,没有请留空第5年折扣的税率,没有请留空第6年折扣的税率,没有请留空第7年折扣的税率,没有请留空第8年折扣的税率,没有请留空第1年维修费率第2年维修费率第3年维修费率第4年维修费率第5年维修费率第6年维修费率第7年维修费率第8年维修费率第9年维修费率第10年维修费率ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第19页,共89页1768.04支架类型发电量平铺支架固定支架1768.04平单轴支架斜单轴支架双轴支架平铺支架固定支架平单轴支架1690.9941768.041745.8431704.7881524.8861731.6141653.6431815.6271917.9241617.9761660.8511659.5872009.4861783.2551892.5061637.7991975.6971522.9051686.3781824.5081402.3111847.7261778.9081708.5251420.6091787.5861785.7351763.7931412.5021645.301海南地区-共和县海北地区-海晏县海东地区-平安县海西地区-德令哈果洛地区-达日县玉树地区-玉树县黄南地区-同仁县ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第20页,共89页1485.71401.958临夏回族自治州1745.84甘南藏族自治州1676.4221727.2191745.143吴忠(青铜峡)1562.3551548.3191461.4321485.6581426.8941905.9991638.1151548.9081622.311668.8541758.4531747.1531556.9761580.4611486.7611562.3361665.0641694.9961440.1741914.7291753.9571979.1791592.9671152.5751202.9721194.6721151.6861241.6511332.0961451.7331128.363915.491234.7051309.3021339.4031334.3471364.4481341.821ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第21页,共89页1398.4551252.8751362.3111213.3651305.4541340.661311.7241245.991314.9991288.0171331.7891241.8881444.111413.0661544.2081441.81444.9661270.0871379.2221679.2461365.4571407.6521286.7681481.2611630.3061768.1561682.4621628.3231614.931704.6631699.8071602.2231527.1271693.7391273.6071257.4191285.1781291.2421164.9341252.7951287.5411260.7761227.1561234.637ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第22页,共89页1169.6081152.8791243.7171293.0321147.4761177.4011143.5331058.959988.9041116.751167.5611010.5921256.089942.7954.8571039.9851105.0581014.8871203.8641149.2441251.1831177.6521256.0991141.4811110.4911149.5261746.5031499.1981651.0881504.2551593.7791400.1621228.5961421.7511650.2961428.3661479.5671485.71280.1021570.0351433.9021332.3081531.2571432.97ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第23页,共89页1480.1871207.6031400.9711073.6391131.8641150.2951201.6621261.1451259.291257.2221150.7541206.2331152.0811150.0491171.8971233.251213.2391161.5211080.9921123.3871089.0491198.5481151.4361235.4831122.2441048.3481147.9591162.7871128.4311203.2171116.3461080.8091111.2771123.2291110.434998.511124.8331121.2921376.9111484.6261470.2031472.841487.8281481.044ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第24页,共89页1481.1441458.3271370.5141499.4621497.311396.361166.6331459.711451.6861352.7541353.1381368.3881162.9551260.4081281.8591249.3351199.5931159.8161263.81311.5121132.4561692.0311251.8131715.765976.7221077.4551256.3721317.4141292.9851301.8481200.341180.8441190.2481199.5931194.5851203.6881108.9771120.8321308.1111229.3861282.7581194.5261156.0811204.306ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第25页,共89页1167.5451200.6051169.6191222.3171105.9341186.8321196.9441067.1581144.221090.6831107.7951093.8251496.8151164.4641400.536ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第26页,共89页财务指标汇总项目名称数值单位装机容量285kw年上网电量463,751kwh总投资1,142,850元流动资金-元销售收入总额6,249,742总成本费用1,652,220销售税金附加总额716,611发电利润总额3,880,910经营期平均电价(不含增值税)0.4770元经营期平均电价(含增值税)0.53906元0.17330元投资回收期(所得税前)4.74年投资回收期(所得税后)4.93年全部投资内部收益率(所得税前)20.14%全部投资内部收益率(所得税后)18.16%IRR全部投资财务净现值(所得税前)¥2,186,545全部投资财务净现值(所得税后)¥1,728,517.57自有资金内部收益率62.40%自有资金财务净现值¥1,682,540.3816.98%投资利税率66.71%经营期度电成本(不含税)第20-25年平均电价(含增值税)总投资收益率(ROI)项目资本金净利润率(ROE)ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第27页,共89页0.22.24.26.28.210.212.2CAPEX与电价关系图ColumnLColumnMColumnNee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第28页,共89页斜单轴支架双轴支架ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第29页,共89页与电价关系图ColumnMColumnN使用帮助说明:1,简易发电量估算与经济测算2,手动输入发电量估算与经济测算参数取值范围运营期残值率5%折旧年限维修费率0.20%0.80%保险费率0.25%材料费0.15%职工工资及福利职工数量2还贷期增值税设备费进项税可抵扣所得税三免三减半投标电价根据建设成本和目标投资收益率计算组件衰减率20年20年9.6万/年/人15年第一年:2%第二年-第二十年:0.8%备注考虑建筑物、设备等综合折旧运营期前两年详见目标电价计算表自投入运营起执行标杆上网电价或电价补贴标准,期限原则上为20年运营期第3到第20年每10MW项目运维人数ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第35页,共89页财务指标汇总序号项目名称数值单位1装机容量285kw2年上网电量463,751kwh3总投资1,142,850元4流动资金-元5销售收入总额6,249,7420支架类型6总成本费用1,652,2200固定支架7销售税金附加总额716,6110平单轴8发电利润总额3,880,9100斜单轴9经营期平均电价(不含增值税)0.4770元10经营期平均电价(含增值税)0.53906元110.17330120元支架类型13投资回收期(所得税前)4.74年固定支架14投资回收期(所得税后)4.93年平单轴15全部投资内部收益率(所得税前)20.14%0斜单轴16全部投资内部收益率(所得税后)18.16%IRR17全部投资财务净现值(所得税前)¥2,186,545018全部投资财务净现值(所得税后)¥1,728,517.57019自有资金内部收益率62.40%020自有资金财务净现值¥1,682,540.3802116.98%022投资利税率002366.71%0经营期度电成本(不含税)第20-25年平均电价(含增值税)总投资收益率(ROI)项目资本金净利润率(ROE)ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第36页,共89页电站规模总投资年均发电量4.5MW40,176,7751680H0.531512.28%4MW36,223,8001903H0.484714.36%2.5MW24,364,8752152H0.502314.69%电站规模总投资年均发电量4.5MW40,176,7751655H0.539312.00%4MW36,223,8001879H0.49114.09%2.5MW24,364,8751974H0.547612.86%100亩项目无限电条件下各支架财务指标对比度电成本(LCOE)总投资内部收益率(IRR)100亩项目限电10%条件下各支架财务指标对比度电成本(LCOE)总投资内部收益率(IRR)ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第37页,共89页总投资回收期21.13%6.39%27.13%7.96%27.17%8.12%总投资回收期20.33%6.18%26.30%7.75%21.72%6.69%下各支架财务指标对比自有资金内部收益率(IRR)总投资收益率(ROI)6.92年6.06年6.03年件下各支架财务指标对比自有资金内部收益率(IRR)总投资收益率(ROI)7.05年6.17年6.8年ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第38页,共89页材料费---暂未启用序号项目合计输入项建设期12输出项1折旧费1,110,896-44,43644,436遗留问题2修理费142,500-5,7005,7003员工工资福利----4保险费71,428-2,8572,8575----6摊销费--7利息支出327,396-40,92538,1968其他费用--固定成本1,652,220-93,91891,189可变成本----总成本费用1,652,220-93,91891,189经营成本213,928-8,5578,55767.24%8.62%序号项目合计4.32%建设期1219.82%1增值税后营业收入5,530,745-240,378238,6961.1上网电量11,593,778-503,891500,3641.2电价(不含税)0.47700.47700.47701.3电价(含税)0.540.540.542营业税金及附加62,590-3,1253,103增值税718,99731,24931,0303抵扣后税费716,611---3总成本费用1,652,220-93,91891,1894补贴收入(免税)74,285-34,37434,1345利润总额3,880,910-177,710178,5376应纳税所得额298,153,734-218,635216,7337调整所得税829,919---8免税额74,285-74,28539,9119净利润3,050,992-177,710178,53710期末未分配利润--159,93911提取法定盈余公积金305,099-17,77117,85412可供分配利润-159,939320,62313应付利润----14未分配利润-159,939320,62315息税前利润4,208,307-218,635216,73316息税折旧摊销前利润5,319,203-263,071261,169序号项目合计建设期121长期贷款1.1年初借款余额-940,794878,0751.2当期还本付息1,268,190-103,644100,916本年还本940,794-62,72062,720本年付息327,396-40,92538,1961.3期末借款余额-878,075815,3552流动资金借款2.1流动资金借款累计---4.90%2.2流动资金利息---材料费+土地费ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第39页,共89页2.3---3短期贷款3.1偿还短期贷款本金-3.2短期贷款-3.3短期贷款利息-序号项目合计建设期121经营活动净现金流量4,414,999228,696227,0361.1现金流入6,249,742271,628269,7261.1.1营业收入5,530,745-240,378238,6961.1.2增值税销项税额718,997-31,24931,0301.1.3其他收入---1.2现金流出1,834,74342,93142,6911.2.1经营成本213,9288,5578,5571.2.2增值税进项税额-1.2.3营业税金及附加71,9003,1253,1031.2.4增值税718,99731,24931,030-1.2.6其他流出---2投资活动净现金流量-1,142,850-1,142,850--2.1现金流入----2.2现金流出1,142,8501,142,850--2.2.1建设投资1,142,8501,142,850--2.2.2维持运营投资-2.2.3流动资金----2.2.4其他流出----3筹资活动净现金流量-125,3401,142,850-103,644-100,9163.1现金流入1,142,8501,142,850--3.1.1项目资本金投入228,570228,570-3.1.2建设投资借款914,280914,280-3.1.3流动资金借款---3.1.4债券-3.1.5短期借款----3.1.6其他流入----3.2现金流出1,268,190103,644100,9163.2.1各种利息支出327,396-40,92538,1963.2.2偿还债务本金940,794-62,72062,7203.2.3应付利润----3.2.4其他流出----4净现金流量3,146,808125,052126,1205累计盈余资金37,339,152125,052251,172序号项目合计建设期121现金流入-274,753272,8291.1营业收入5,530,745-240,378238,6961.2补贴收入74,285-34,37434,1341.3回收固定资产余值57,143---1.4回收流动资金----2现金流出1,428,6781,142,85011,68211,660偿还流动资金借款本金ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第40页,共89页2.1建设投资1,142,8501,142,850-2.2流动资金---2.3经营成本213,9288,5578,5572.4营业税金及附加71,9003,1253,1032.5维持运营投资---3所得税前净现金流4,233,495-1,142,850263,071261,169442,331,391-1,142,850-879,779-618,6105调整所得税829,919---6所得税后净现金流3,403,577-1,142,850263,071261,169733,084,990-1,142,850-879,779-618,610序号项目合计建设期121现金流入5,662,173274,753272,8291.1营业收入5,530,745240,378238,6961.2补贴收入74,28534,37434,1341.3回收固定资产余值57,143--1.4回收流动资金---2现金流出2,612,507228,570115,326112,5762.1项目资本金228,570228,570-2.2借款本金偿还940,79462,72062,7202.3借款利息支付327,39640,92538,1962.4经营成本213,9288,5578,5572.5营业税金及附加71,9003,1253,1032.6所得税829,919--2.7维持运营投资---3净现金流量3,049,666-228,570159,426160,253序号项目合计建设期121初始投资成本1,169,3641,169,364-2运营成本-26,00223,9563发电量503,891500,3644折现率4.00%4.00%1.1投资折现1,169,3641,169,3641.2残值折现21,4351.3运营成本折现125,28225,00222,1491.4发电量折现7,347,158484,511462,615LCOE=0.17330.10713648累计所得税前净现金流累计所得税后净现金流ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第41页,共89页ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第42页,共89页--------总成34567891044,43644,43644,43644,43644,43644,43644,43644,4365,7005,7005,7005,7005,7005,7005,7005,700--------2,8572,8572,8572,8572,8572,8572,8572,857--------35,46832,74030,01127,28324,55521,82619,09816,37088,46185,73383,00480,27677,54874,81972,09169,363--------88,46185,73383,00480,27677,54874,81972,09169,3638,5578,5578,5578,5578,5578,5578,5578,557利润345678910237,025235,366233,718232,082230,458228,844227,243225,652496,862493,384489,930486,500483,095479,713476,355473,0210.47700.47700.47700.47700.47700.47700.47700.47700.540.540.540.540.540.540.540.543,0813,0603,0383,0172,9962,9752,9542,93330,81330,59830,38330,17129,95929,75029,54229,33528,11733,65733,42233,18832,95532,72532,49632,26888,46185,73383,00480,27677,54874,81972,09169,3635,778-------151,260146,573147,676148,789149,914151,050152,197153,356186,728179,313177,687176,072174,469172,876171,295169,725-22,41422,21122,00943,61743,21942,82442,4315,778-------151,260124,159125,465126,780106,297107,831109,373110,924320,623456,757568,500681,419795,521891,188988,2361,086,67215,12612,41612,54612,67810,63010,78310,93711,092456,757568,500681,419795,521891,188988,2361,086,6721,186,504--------456,757568,500681,419795,521891,188988,2361,086,6721,186,504186,728179,313177,687176,072174,469172,876171,295169,725231,164223,749222,123220,508218,905217,312215,731214,161借款345678910815,355752,635689,916627,196564,476501,757439,037376,31898,18895,45992,73190,00387,27484,54681,81879,08962,72062,72062,72062,72062,72062,72062,72062,72035,46832,74030,01127,28324,55521,82619,09816,370752,635689,916627,196564,476501,757439,037376,318313,598----------------ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第43页,共89页--------财务345678910225,387201,335199,912198,499175,287174,093172,907171,730267,838265,963264,102262,253260,417258,594256,784254,987237,025235,366233,718232,082230,458228,844227,243225,65230,81330,59830,38330,17129,95929,75029,54229,335--------42,45264,62964,19063,75485,13084,50183,87783,2578,5578,5578,5578,5578,5578,5578,5578,5573,0813,0603,0383,0172,9962,9752,9542,93330,81330,59830,38330,17129,95929,75029,54229,335---------------------------------------------------------98,188-95,459-92,731-90,003-87,274-84,546-81,818-79,089------------------------98,18895,45992,73190,00387,27484,54681,81879,08935,46832,74030,01127,28324,55521,82619,09816,37062,72062,72062,72062,72062,72062,72062,72062,720----------------127,199105,876107,181108,49688,01389,54791,09092,640378,371484,247591,428699,924787,937877,484968,5741,061,214项目345678910242,803235,366233,718232,082230,458228,844227,243225,652237,025235,366233,718232,082230,458228,844227,243225,6525,778-----------------------11,63811,61711,59511,57411,55311,53211,51111,491ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第44页,共89页8,5578,5578,5578,5578,5578,5578,5578,5573,0813,0603,0383,0172,9962,9752,9542,933--------231,164223,749222,123220,508218,905217,312215,731214,161-387,446-163,69758,426278,934497,838715,150930,8821,145,043-22,41422,21122,00943,61743,21942,82442,431231,164201,335199,912198,499175,287174,093172,907171,730-387,446-186,11113,801212,300387,587561,680734,588906,317项目资345678910242,803235,366233,718232,082230,458228,844227,243225,652237,025235,366233,718232,082230,458228,844227,243225,6525,778-----------------------109,826129,490126,537123,586142,445139,297136,153133,01162,72062,72062,72062,72062,72062,72062,72062,72035,46832,74030,01127,28324,55521,82619,09816,3708,5578,5578,5578,5578,5578,5578,5578,5573,0813,0603,0383,0172,9962,9752,9542,933-22,41422,21122,00943,61743,21942,82442,431--------132,977105,876107,181108,49688,01389,54791,09092,640项目资345678910--------21,91019,86417,81715,77113,72511,6799,6327,586496,862493,384489,930486,500483,095479,713476,355473,0214.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%19,47816,97914,64512,46410,4308,5346,7685,125441,708421,746402,687384,488367,112350,522334,681319,556ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第45页,共89页ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第46页,共89页--------总成本费用估算表111213141516171844,43644,43644,43644,43644,43644,43644,43644,4365,7005,7005,7005,7005,7005,7005,7005,700--------2,8572,8572,8572,8572,8572,8572,8572,857--------13,64210,9138,1855,4572,728---66,63463,90661,17858,45055,72152,99352,99352,993--------66,63463,90661,17858,45055,72152,99352,99352,9938,5578,5578,5578,5578,5578,5578,5578,557利润和利润分配表1112131415161718224,072222,504220,946219,400217,864216,339214,824213,321469,710466,422463,157459,915456,695453,498450,324447,1720.47700.47700.47700.47700.47700.47700.47700.47700.540.540.540.540.540.540.540.542,9132,8932,8722,8522,8322,8122,7932,77329,12928,92528,72328,52228,32228,12427,92727,73232,04231,81831,59531,37431,15530,93630,72030,50566,63463,90661,17858,45055,72152,99352,99352,993--------154,525155,705156,896158,098159,310160,533159,039157,554168,166166,618165,081163,554162,039160,533159,039157,55442,04241,65541,27040,88940,51040,13339,76039,389--------112,483114,050115,626117,209118,801120,400119,279118,1661,186,5041,287,7381,390,3841,494,4471,599,9351,706,8561,815,2161,922,56711,24811,40511,56311,72111,88012,04011,92811,8171,287,7381,390,3841,494,4471,599,9351,706,8561,815,2161,922,5672,028,916--------1,287,7381,390,3841,494,4471,599,9351,706,8561,815,2161,922,5672,028,916168,166166,618165,081163,554162,039160,533159,039157,554212,602211,054209,517207,990206,474204,969203,475201,990借款还本付息计划表1112131415161718313,598250,878188,159125,43962,720---76,36173,63370,90568,17665,448---62,72062,72062,72062,72062,720---13,64210,9138,1855,4572,728---250,878188,159125,43962,720--------------------ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第47页,共89页--------财务计划现金流量表1112131415161718170,561169,400168,247167,102165,965164,836163,715162,602253,202251,429249,669247,922246,186244,463242,752241,052224,072222,504220,946219,400217,864216,339214,824213,32129,12928,92528,72328,52228,32228,12427,92727,732--------82,64182,03081,42380,82080,22179,62779,03778,4518,5578,5578,5578,5578,5578,5578,5578,5572,9132,8932,8722,8522,8322,8122,7932,77329,12928,92528,72328,52228,32228,12427,92727,732---------------------------------------------------------76,361-73,633-70,905-68,176-65,448---------------------------76,36173,63370,90568,17665,448---13,64210,9138,1855,4572,728---62,72062,72062,72062,72062,720-------------------94,19995,76797,34298,925100,517164,836163,715162,6021,155,4141,251,1801,348,5231,447,4481,547,9651,712,8011,876,5162,039,117项目投资现金流量表1112131415161718224,072222,504220,946219,400217,864216,339214,824213,321224,072222,504220,946219,400217,864216,339214,824213,321------------------------11,47011,45011,42911,40911,38911,37011,35011,330ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第48页,共89页8,5578,5578,5578,5578,5578,5578,5578,5572,9132,8932,8722,8522,8322,8122,7932,773--------212,602211,054209,517207,990206,474204,969203,475201,9901,357,6451,568,6991,778,2161,986,2062,192,6812,397,6502,601,1252,803,11542,04241,65541,27040,88940,51040,13339,76039,389170,561169,400168,247167,102165,965164,836163,715162,6021,076,8781,246,2781,414,5241,581,6261,747,5911,912,4262,076,1412,238,743项目资本金现金流量表1112131415161718224,072222,504220,946219,400217,864216,339214,824213,321224,072222,504220,946219,400217,864216,339214,824213,321------------------------129,873126,737123,604120,474117,34751,50351,11050,71962,72062,72062,72062,72062,720---13,64210,9138,1855,4572,728---8,5578,5578,5578,5578,5578,5578,5578,5572,9132,8932,8722,8522,8322,8122,7932,77342,04241,65541,27040,88940,51040,13339,76039,389--------94,19995,76797,34298,925100,517164,836163,715162,602项目资本金现金流量表1112131415161718--------5,5403,4941,448-599-2,645-4,691-4,691-4,691469,710466,422463,157459,915456,695453,498450,324447,1724.00%4.00%4.00%4.00%4.00%4.00%4.00%4.00%3,5992,182869-346-1,469-2,505-2,408-2,316305,114291,326278,160265,589253,587242,126231,184220,736ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第49页,共89页-------1920212223242544,43644,43644,43644,43644,43644,43644,4365,7005,7005,7005,7005,7005,7005,7001-------2,8572,8572,8572,8572,8572,8572,857---------------52,99352,99352,99352,99352,99352,99352,993-------52,99352,99352,99352,99352,99352,99352,9938,5578,5578,5578,5578,5578,5578,55719202122232425211,827210,345208,872207,410205,958204,516203,085444,041440,933437,847434,782431,738428,716425,7150.47700.47700.47700.47700.47700.47700.47700.540.540.540.540.540.540.542,7542,7342,7152,6962,6772,6592,64027,53827,34527,15326,96326,77526,58726,40130,29130,07929,86929,66029,45229,24629,04152,99352,99352,99352,99352,99352,99352,993-------156,081154,617153,164151,721150,288148,865147,452156,081154,617153,164151,721150,288148,865147,45239,02038,65438,29137,93037,57237,21636,863-------117,060115,963114,873113,791112,716111,649110,5892,028,9162,134,2712,238,6372,342,0232,444,4352,545,8792,646,36311,70611,59611,48711,37911,27211,16511,0592,134,2712,238,6372,342,0232,444,4352,545,8792,646,3632,745,893-------2,134,2712,238,6372,342,0232,444,4352,545,8792,646,3632,745,893156,081154,617153,164151,721150,288148,865147,452200,516199,053197,600196,157194,724193,301191,88819202122232425-------------------------------------------------ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第50页,共89页-------19202122232425161,496160,399159,309158,226157,152156,084155,025239,365237,689236,026234,373232,733231,104229,486211,827210,345208,872207,410205,958204,516203,08527,53827,34527,15326,96326,77526,58726,401-------77,86977,29176,71776,14775,58175,01974,4618,5578,5578,5578,5578,5578,5578,5572,7542,7342,7152,6962,6772,6592,64027,53827,34527,15326,96326,77526,58726,401----------------------------------------------------------------------------------------------------------------161,496160,399159,309158,226157,152156,084155,0252,200,6142,361,0122,520,3212,678,5482,835,6992,991,7843,146,80819202122232425211,827210,345208,872207,410205,958204,516260,227211,827210,345208,872207,410205,958204,516203,085-------------57,143-------11,31111,29211,27211,25311,23511,21611,197ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第51页,共89页8,5578,5578,5578,5578,5578,5578,5572,7542,7342,7152,6962,6772,6592,640-------200,516199,053197,600196,157194,724193,301249,0303,003,6313,202,6843,400,2843,596,4413,791,1643,984,4654,233,49539,02038,65438,29137,93037,57237,21636,863161,496160,399159,309158,226157,152156,084212,1672,400,2392,560,6382,719,9472,878,1733,035,3253,191,4093,403,57719202122232425211,827210,345208,872207,410205,958204,516260,227211,827210,345208,872207,410205,958204,516203,085-------------57,143-------50,33149,94649,56349,18448,80748,43248,060--------------8,5578,5578,5578,5578,5578,5578,5572,7542,7342,7152,6962,6772,6592,64039,02038,65438,29137,93037,57237,21636,863-------161,496160,399159,309158,226157,152156,084212,16719202122232425--------4,691-4,691-4,691-4,691-4,691-4,691-4,691444,041440,933437,847434,782431,738428,716425,7154.00%4.00%4.00%4.00%4.00%4.00%4.00%-2,227-2,141-2,059-1,979-1,903-1,830-1,760210,761201,236192,142183,458175,168167,251159,693LCOE推演公式Pdynamic_costDdepreciationRtaxPo&M(1-Rtax)Vresidual_valueRdiscountEaccrual说明固定资产残值现值每年的发电量现值。建设期成本,就是初始动态投资,包含建设期成本和建设期利息建设期按照1年计算,建设期利息的计算=借款额x年利率/21,资产折旧,税收,税收采用所得税,资产折旧按照年限进行平均折旧。1,运维成本,包含投入的材料成本,修理费,员工工资福利,保险费,材料费,土地费,摊销费,利息支出2,Rtax所得税折限值,一般按照资本金内部收益率或者当前利率来折现,国内4.9%的利率,默认按照6%折现,部分民企贷款利率高会按照8%或者10%折现。备注总的公式参考GE公司写的各年应计算利息=(年初借款本息累计+本年借款额/2)年利率ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第58页,共89页序号项目合计序号成本项分项1折旧费1,110,8961初始投资成本折旧费2修理费142,5002运维成本修理费3员工工资福利-3员工工资福利4保险费71,4284保险费5-56摊销费-6摊销费7利息支出327,3967金融成本利息支出8其他费用-8总收入增值税后营业收入9固定成本1,652,2209税金成本抵扣后税费10可变成本-10调整所得税11总成本费用1,652,22011提取法定盈余公积金12经营成本213,9281213增值税后营业收入5,530,7451314抵扣后税费716,6111415调整所得税829,9191516提取法定盈余公积金305,09916收入总计1717成本总计费用名称初始投资光伏组件1.70484,500光伏支架0.3085,500逆变器0.1542,750光伏汇流箱--配电柜0.0822,800变压器--电缆0.1028,500升压站--通信和监控--安防工程与其他--组件区施工0.3085,500厂区建筑--交通工程--建设用地费0.3085,500建设管理费--生产准备费--勘察设计费0.1028,500其他税费--合计3.03863,550初始投资合计4.011,142,850材料费+土地费材料费+土地费单W价格31.71%6.11%9.34%52.85%总成本占比初运金税66.61%33.39%运维成本占比修理员工保险材料ee36427f-3419-4e3c-b4c2-5405d8ca4e38.xlsx文档密级08/31/2023华为保密信息,未经授权禁止扩散第59页,共89页分项值备注合计序号成本项总成本占比1,110,8961,110,8961初始投资成本31.71%142,500213,9282运维成本6.11%-3金融成本9.34%71,4284税金成本52.85%-5-未考虑327,396327,396序号成本项运维成本占比5,530,7455,530,7451修理费66.61%716,611城市建设税、教育税1,851,6292员工工资福利0.00%829,919三年免三减半3保险费33.39%305,09940.00%5摊销费0.00%序号成本项初始投资成本占比1固定资产58.10%5,530,7452施工成本7.48%3,503,8493税费9.98%457.44元/w,25年线性折旧每年0.8%20MW项目5人每年0.24%每年0.11%80%贷款15年利率5.65%材料费+土地费31.71%6.11%9.34%总成本占比初始投资成本运维成本金融成本税金成本66.61%运维成本占比修理费员工工资福利保险费材料费+土地费58.10%7.48%9.98%初始投资成本占比固定资产施工成本税费序号名称单位1装机容量MWp2多年平均上网电量3总投资(不含流动资金)万元3.1固定资产投资万元3.2建设期利息万元4流动资金万元5上网电价6发电销售收入总额万元7总成本费用万元8增值税销项税万元9补贴收入万元10营业税金及附加总额万元11发电利润总额万元12财务内部收益率12.1全部投资(所得税前)%12.2全部投资(所得税后)%13自有资金(所得税后)%14投资回收期(所得税后)年15借款偿还期年16资产负债率(高峰值)%万kWh元/kWh指标0.28546.4116.9114.32.700.53906625.0165.271.906.3388.120.14%18.16%62.40%4.931580%序号项目全部投资全部投资资本金(税后)1基本方案12.8611.3824.870.912投资变化10%0.915%0.91-5%0.91-10%0.913电量变化10%0.915%0.91-5%0.91-10%0.91财务内部收益率(%)上网电价(元/kWh)上网电价(元/kWh)(税前)暂时只能讲表格中的值一个一个算出来,填到表格里序号项目合计计算期11项目投入总资金116.9116.91.1固定资产投资114.3114.31.2建设期利息2.72.71.3流动资金002资金筹措116.9116.92.1资本金29.229.20.00.02.2银行借款87.787.72.2.1长期借款8888其中:本金85.185.12.2.2流动资金借款0.00.02.2.3其它短期借款002.3其它0012-1%-10000-5000-1000-5040.295717385-1016.183237其中:用于流动资金34567891011250025002500250025002500200100502560.9322581.5712602.3762623.3492644.4912665.803214.983108.357854.61553序号项目合计计算期123451电站发电成本165.20.09.49.18.88.61.1折旧费111.10.04.44.44.44.41.2固定修理费14.30.00.60.60.60.61.3工资福利等0.00.00.00.00.00.01.4保险费7.10.00.30.30.30.31.5租地费0.00.000001.6材料费0.00.00.00.00.00.01.7其它费用0.00.00.00.00.00.01.8利息支出32.70.04.13.83.53.31.9摊销费0000002经营成本21.40.00.90.90.90.9序号项目计算期1112131415161电站发电成本6.96.76.46.15.85.61.1折旧费4.44.44.44.44.44.41.2固定修理费0.60.60.60.60.60.61.3工资福利等0000001.4保险费0.30.30.30.30.30.31.5租地费0000001.6材料费0.00.00.00.00.00.01.7其它费用0.00.00.00.00.00.01.8利息支出1.61.41.10.80.50.31.9摊销费0000002经营成本0.90.90.90.90.90.9计算期6789108.38.07.87.57.24.44.44.44.44.40.60.60.60.60.60.00.00.00.00.00.30.30.30.30.3000000.00.00.00.00.00.00.00.00.00.03.02.72.52.21.9000000.90.90.90.90.9计算期17181920215.35.35.35.35.34.44.44.44.44.40.60.60.60.60.6000000.30.30.30.30.3000000.00.00.00.00.00.00.00.00.00.00.00.00.00.00.0000000.90.90.90.90.9序号项目合计计算期12340.2850.2850.2850.285050.450.049.700.539060.539060.539061发电销售收入508.6027.227.026.81.1营业收入450.1024.023.923.71.2增值税销项税额58.503.13.13.12增值税51.700.00.02.52.1应交增值税58.503.13.13.12.2可抵扣增值税6.803.13.10.63营业税金及附加4.900003.1城市维护建设税2.500.00.00.03.2教育费附加2.500.00.00.04发电成本费用138.709.49.18.85补贴收入0.000006利润总额312.9017.817.915.17弥补以前年度亏损000008应纳税所得额312.9017.817.915.19所得税64.200.00.00.010净利润248.7017.817.915.111提取法定盈余公积金24.901.81.81.512可供投资者分配的利润223.9016.016.113.613应付利润0000014未分配利润223.9016.016.113.615息税前利润345.7021.921.718.716息税折旧摊销前利润434.6026.326.123.1序号项目计算期11121314150.2850.2850.2850.2850.28547.347.046.646.346.00.539060.539060.539060.539060.539061发电销售收入25.525.325.125.024.81.1营业收入22.622.422.322.121.91.2增值税销项税额2.92.92.92.92.92增值税2.92.92.92.92.92.1应交增值税2.92.92.92.92.9上网容量(MW)上网电量(万kWh)上网电价(元/kWh)上网容量(MW)上网电量(万kWh)上网电价(元/kWh)2.2可抵扣增值税0.00.00.00.00.03营业税金及附加0.30.30.30.30.33.1城市维护建设税0.10.10.10.10.13.2教育费附加0.10.10.10.10.14发电成本费用6.96.76.46.15.85补贴收入000006利润总额15.315.515.615.715.87弥补以前年度亏损000008应纳税所得额15.315.515.615.715.89所得税4.24.24.24.14.110净利润11.111.211.411.611.711提取法定盈余公积金1.11.11.11.21.212可供投资者分配的利润10.010.110.310.410.513应付利润0000014未分配利润10.010.110.310.410.515息税前利润17.016.816.716.516.416息税折旧摊销前利润21.421.321.121.020.8计算期56789100.2850.2850.2850.2850.2850.28549.349.048.748.348.047.60.539060.539060.539060.539060.539060.5390626.626.426.226.025.925.723.523.423.223.022.922.73.13.03.03.03.03.03.13.03.03.03.03.03.13.03.03.03.03.00.00.00.00.00.00.00.30.30.30.30.30.30.20.20.20.10.10.10.20.20.20.10.10.18.68.38.07.87.57.200000014.714.814.915.015.115.200000014.714.814.915.015.115.22.22.22.24.44.34.312.412.512.710.610.810.91.21.31.31.11.11.111.211.311.49.69.79.800000011.211.311.49.69.79.817.917.817.617.417.317.122.422.222.121.921.721.6计算期1617181920210.2850.2850.2850.2850.2850.28545.745.345.044.744.444.10.539060.539060.539060.539060.539060.5390624.624.424.324.123.923.821.821.621.521.321.221.02.82.82.82.82.82.72.82.82.82.82.82.72.82.82.82.82.82.70.00.00.00.00.00.00.30.30.30.30.30.30.10.10.10.10.10.10.10.10.10.10.10.15.65.35.35.35.35.300000015.916.115.915.815.615.500000015.916.115.915.815.615.54.14.04.03.93.93.911.912.011.911.811.711.61.21.21.21.21.21.210.710.810.710.610.510.400000010.710.810.710.610.510.416.216.115.915.815.615.520.620.520.320.220.119.9序号项目计算期12341借款及还本付息1.1年初借款本息累计094.187.881.51.1.1本金091.487.881.51.1.2建设期利息0.02.7001.2本年借款91.40001.3本年应计利息2.74.13.83.51.4本年还本付息010.410.19.81.4.1本年付息04.13.83.51.4.2本年还本06.36.36.32偿还借款的资金来源2.1还贷利润00.00.01.32.2还贷折旧02.82.94.42.3还贷摊销00002.4计入成本的利息支出04.13.83.52.5其它03.43.40.6合计010.410.19.8序号项目91011121借款及还本付息1.1年初借款本息累计50.243.937.631.41.1.1本金50.243.937.631.41.1.2建设期利息00001.2本年借款00001.3本年应计利息2.21.91.61.41.4本年还本付息8.58.27.97.61.4.1本年付息2.21.91.61.41.4.2本年还本6.36.36.36.32偿还借款的资金来源2.1还贷利润1.81.81.81.82.2还贷折旧4.44.44.44.42.3还贷摊销00002.4计入成本的利息支出2.21.91.61.42.5其它0000合计8.58.27.97.6计算期567875.369.062.756.475.369.062.756.4000000003.33.02.72.59.59.39.08.73.33.02.72.56.36.36.36.31.81.81.81.84.44.44.44.400003.33.02.72.50.00.00.00.09.59.39.08.71314151625.118.812.56.325.118.812.56.3000000001.10.80.50.37.47.16.86.51.10.80.50.36.36.36.36.31.81.81.81.84.44.44.44.400001.10.80.50.300007.47.16.86.5序号项目合计计算期123451经营活动净现金流量370.7026.326.123.420.11.1现金流入508.6027.227.026.826.61.1.1营业收入450.1024.023.923.723.51.1.2增值税销项税额58.503.13.13.13.11.1.3补贴收入0000001.1.4其他流入0000001.1.5回收流动资金0000001.2现金流出137.900.90.93.46.51.2.1经营成本17.100.90.90.90.91.2.2增值税进项税额0000001.2.3营业税金及附加4.900.00.00.00.31.2.4增值税51.700.00.02.53.11.2.5所得税64.200.00.00.02.21.2.6其他流出0000002投资活动净现金流量-114.3-114.300002.1现金流入0000002.2现金流出114.3114.300002.2.1建设投资114.3114.300002.2.2维持运营投资0000002.2.3流动资金0000002.2.4其它流出0000003筹资活动净现金流量-12.5114.3-10.4-10.1-9.8-9.53.1现金流入114.3114.300003.1.1项目资本金投入22.922.900003.1.2建设投资借款91.491.400003.1.3流动资金借款0.00.000003.1.4债券0000003.1.5短期借款0000003.1.6其他流入0000003.2现金流出126.8010.410.19.89.53.2.1各种利息支出32.704.13.83.53.33.2.2偿还债务本金94.106.36.36.36.33.2.3流动资金本金偿还0.0000003.2.4应付利润(股利分配)0000003.2.5其他流出0000004净现金流量243.80.015.916.013.610.65累计盈余资金015.932.045.656.2计算期计算期6789101112131420.019.817.517.417.317.217.116.916.826.426.226.025.925.725.525.325.125.023.423.223.022.922.722.622.422.322.13.03.03.03.03.02.92.92.92.90000000000000000000000000006.46.48.58.58.48.38.38.28.10.90.90.90.90.90.90.90.90.90000000000.30.30.30.30.30.30.30.30.33.03.03.03.03.02.92.92.92.92.22.24.44.34.34.24.24.24.1000000000000000000000000000000000000000000000000000000000000000000000000-9.3-9.0-8.7-8.5-8.2-7.9-7.6-7.4-7.10000000000000000000000000000000000000000000000000000000000000009.39.08.78.58.27.97.67.47.13.02.72.52.21.91.61.41.10.86.36.36.36.36.36.36.36.36.300000000000000000000000000010.710.88.89.09.19.39.49.69.766.977.786.595.5104.6113.9123.3132.9142.6计算期1516171819202116.716.616.516.416.316.116.024.824.624.424.324.123.923.821.921.821.621.521.321.221.02.92.82.82.82.82.82.70000000000000000000008.18.08.07.97.87.87.70.90.90.90.90.90.90.900000000.30.30.30.30.30.30.32.92.82.82.82.82.82.74.14.14.04.03.93.93.900000000000000000000000000000000000000000000000000000000-6.8-6.50.00.00.00.00.000000000000000000000000000000000000000000000000006.86.50.00.00.00.00.00.50.30.00.00.00.00.06.36.30.00.00.00.00.00000000000000000000009.910.116.516.416.316.116.0152.5162.5179.0195.4211.6227.8243.8序号项目计算12341资产116.9129.5137.9146.21.1流动资产总值015.932.045.31.1.1流动资产00001.1.2累计盈余资金015.932.045.31.2在建工程110.10001.3固定资产净值0109.8105.4101.01.4无形及递延资产净值00001.5可抵扣增值税形成的资产6.83.70.60.02负债及所有者权益116.9129.5137.9146.22.1流动负债总额00002.1.1短期借款00002.1.2其他00002.2建设投资借款94.187.881.575.32.3流动资金借款0.00.00.00.02.4负债小计94.187.881.575.32.5所有者权益22.940.658.573.62.5.1资本金22.922.922.922.92.5.2资本公积金00002.5.3累计盈余公积金01.83.65.12.5.4累计未分配利润016.032.145.780.5%67.8%59.1%51.5%资产负债率(%)计算期56789101112152.4158.6165.0169.4173.9178.6183.4188.455.966.677.486.295.2104.3113.5123.00000000055.966.677.486.295.2104.3113.5123.00000000096.592.187.683.278.774.369.865.4000000000.00.00.00.00.00.00.00.0152.4158.6165.0169.4173.9178.6183.4188.400000000000000000000000069.062.756.450.243.937.631.425.10.00.00.00.00.00.00.00.069.062.756.450.243.937.631.425.186.098.6111.2121.9132.7143.6154.7165.922.922.922.922.922.922.922.922.9000000006.37.68.89.911.012.113.214.356.968.179.689.198.8108.7118.7128.845.3%39.5%34.2%29.6%25.2%21.1%17.1%13.3%计算期131415161718192021193.5198.8204.2209.9221.9233.8245.6257.3268.9132.5142.3152.2162.2178.7195.1211.3227.5243.5298000000000132.5142.3152.2162.2178.7195.1211.3227.5243.500000000061.056.552.147.643.238.734.329.925.40000000000.00.00.00.00.00.00.00.00.0193.5198.8204.2209.9221.9233.8245.6257.3268.900000000000000000000000000018.812.56.30.00.00.00.00.00.00.00.00.00.00.00.00.00.0018.812.56.30.00.00.00.00.00.0177.3188.9200.6212.5224.5236.5248.3260.0271.622.922.922.922.922.922.922.922.922.900000000015.416.617.819.020.221.422.523.724.9139.0149.4160.0170.7181.5192.3202.9213.4223.99.7%6.3%3.1%0.0%0.0%0.0%0.0%0.0%0.0%序号项目合计计算期1231现金流入534.0154027.227.01.1发电销售收入508.6021027.227.01.2补贴收入00001.3回收固定资产余值25.40001.4回收流动资金0.00002现金流出188.0114.30.90.92.1建设投资114.3114.3002.2流动资金0.00.0002.3经营成本17.100.90.92.4增值税51.700.00.02.5营业税金及附加4.900.00.02.6维持运营投资00003所得税前净现金流量346.0-114.326.326.14累计所得税前净现金流量-114.3-88.0-61.95调整所得税64.200.00.06所得税后净现金流量281.8-114.326.326.17累计所得税后净现金流量-114.3-88.0-61.918.0%计算期4567891011121326.826.626.426.226.025.925.725.525.325.126.826.626.426.226.025.925.725.525.325.10000000000000000000000000000003.44.24.24.24.24.14.14.14.14.0000000000000000000000.90.90.90.90.90.90.90.90.90.92.53.13.03.03.03.03.02.92.92.90.00.30.30.30.30.30.30.30.30.3000000000023.422.422.222.121.921.721.621.421.321.1-38.4-16.16.228.250.171.893.4114.8136.1157.20.02.22.22.24.44.34.34.24.24.223.420.120.019.817.517.417.317.217.116.9-38.4-18.33.926.045.767.589.1110.6131.9153.0计算期141516171819202125.024.824.624.424.324.123.949.225.024.824.624.424.324.123.923.800000000000000025.4000000004.04.04.03.93.93.93.93.900000000000000000.90.90.90.90.90.90.90.92.92.92.82.82.82.82.82.70.30.30.30.30.30.30.30.30000000021.020.820.620.520.320.220.145.3178.1198.9219.6240.1260.4280.6300.7346.04.14.14.14.04.03.93.93.916.816.716.616.516.416.316.141.5174.0194.8215.5236.1256.4276.7296.8342.1序号项目合计计算期123451现金流入534.0027.227.026.826.61.1发电销售收入508.6027.227.026.826.61.2补贴收入0000001.3回收固定资产余值25.4000001.4回收流动资金0.0000002现金流出287.622.911.210.913.216.02.1项目资本金22.922.900002.2借款本金偿还94.106.36.36.36.32.3借款利息支付32.704.13.83.53.32.4经营成本17.100.90.90.90.92.5增值税51.700.00.02.53.12.6营业税金及附加4.900.00.00.00.32.7所得税64.200.00.00.02.22.8维持运营投资0000003净现金流量246.4-22.915.916.013.610.662.6%计算期计算期678910111213141526.426.226.025.925.725.525.325.125.024.826.426.226.025.925.725.525.325.125.024.800000000000000000000000000000015.715.417.216.916.616.215.915.615.214.900000000006.36.36.36.36.36.36.36.36.36.33.02.72.52.21.91.61.41.10.80.50.90.90.90.90.90.90.90.90.90.93.03.03.03.03.02.92.92.92.92.90.30.30.30.30.30.30.30.30.30.32.22.24.44.34.34.24.24.24.14.1000000000010.710.88.89.09.19.39.49.69.79.9计算期16171819202124.624.424.324.123.949.224.624.424.324.123.923.80000000000025.400000014.68.07.97.87.87.70000006.30.00.00.00.00.00.30.00.00.00.00.00.90.90.90.90.90.92.82.82.82.82.82.70.30.30.30.30.30.34.14.04.03.93.93.900000010.116.516.416.316.141.5

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

碎片内容

碳中和
已认证
内容提供者

碳中和

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