140426_北京_延庆平原区地表水供水工程及葡萄产业带集中供水工程特许经营项目_财务测算.xlsx
下载文档
上传人:正***
编号:855822
2023-12-21
31页
77.91KB
1、基基本本情情况况基基本本假假设设资资产产总总额额总投资47500 万元基本水价3.66资本金19000.00自来水价格2.4 元/立方米首创95%水资源费价格1.26 元/立方米鼎华5%污水处理费价格1.04 元/立方米融资28500.00贷款期限15 年运运营营补补贴贴贷款利率6.55%135490 万元/年还款方式等额本息455950 万元/年610(最高)2529 万元/年特特许许经经营营期期补贴水价1.26 元/立方米长度30 年1130(最高)3219 万元/年开始年份2014补贴水价1.26 元/立方米结束年份2043项项目目参参数数1保底水量131.5 万t/d452.5 万t/2、d6105.5 万t/d11307 万t/d2年工作天数365 天经经营营成成本本1原水万元/年备注1.1原水价格0.3 元/吨1.2取用水量2电费万元/年2.1基本电费万元/年基本电价元/度容量度2.2电度电费万元/年单耗度/t电度电价元/度3药剂万元/年3.1单耗kg/t泥3.2单价元/kg4水费万元/年6管理费用万元/年7大修理基金提存率8日常检修维护费固定资产净值所所得得税税率率25%1.72.4项项目目价价格格构构成成1经营成本0.9813动力0.2481药剂0.0028污泥处置0.0227原水费0.3028人工成本0.1552大修费0.1934管理费0.05632折旧及摊销0.743、463财务费用0.26824所得税0.77945净利润2.3381折折旧旧及及摊摊销销(单单位位:万万元元)序号年份1 12 23 34 45 56 67 7项目201420142015201520162016201720172018201820192019202020201 1折折旧旧1.1房屋建筑物1.1.1期初234002262021840210602028019500187201.1.2当年折旧7807807807807807807801.1.3累计折旧7801560234031203900468054601.1.4固定资产增加1.1.5期末净值226202184021060202804、1950018720179401.2设备1.2.1期初1.2.2当年折旧1.2.3累计折旧1.2.4设备增加1.2.5期末净值2 2摊摊销销2.1土地使用权2.1.1期初原值2410023296.6722493.3321690.0020886.6720083.3319280.002.1.2摊销803.33803.33803.33803.33803.33803.33803.332.1.3累计摊销803.331606.672410.003213.334016.674820.005623.332.1.4期末净值23296.6722493.3321690.0020886.6720083.33192805、.0018476.678 89 91010111112121313141415151616202120212022202220232023202420242025202520262026202720272028202820292029179401716016380156001482014040132601248011700780780780780780780780780780624070207800858093601014010920117001248017160163801560014820140401326012480117001092018476.6717673.3316870.00166、066.6715263.3314460.0013656.6712853.3312050.00803.33803.33803.33803.33803.33803.33803.33803.33803.336426.677230.008033.338836.679640.0010443.3311246.6712050.0012853.3317673.3316870.0016066.6715263.3314460.0013656.6712853.3312050.0011246.6717171818191920202121222223232424252520302030203120312032203227、0332033203420342035203520362036203720372038203810920101409360858078007020624054604680780780780780780780780780780132601404014820156001638017160179401872019500101409360858078007020624054604680390011246.6710443.339640.008836.678033.337230.006426.675623.334820.00803.33803.33803.33803.33803.33803.33803.38、3803.33803.3313656.6714460.0015263.3316066.6716870.0017673.3318476.6719280.0020083.3310443.339640.008836.678033.337230.006426.675623.334820.004016.672626272728282929303020392039204020402041204120422042204320433900312023401560780780780780780780202802106021840226202340031202340156078004016.673213.33249、10.001606.67803.33803.33803.33803.33803.33803.3320886.6721690.0022493.3323296.6724100.003213.332410.001606.67803.330.00融融资资结结构构(单单位位:万万元元)序号年份1 12 23 34 45 56 6项目2014201420152015201620162017201720182018201920191 1借借款款及及还还本本付付息息1.1长期负债1.1.1年初借款本息合计27325.9526075.0024742.1223321.9321808.721.1.2本年借款285010、0.001.1.3本年应计利息1866.751789.851707.911620.611527.591428.471.1.4本年还本1174.051250.951332.881420.191513.211612.331.1.5本年付息1866.751789.851707.911620.611527.591428.471.1.6本年还本付息3040.803040.803040.803040.803040.803040.801.2流动负债1.2.1年初借款本息合计1.2.2本年借款1.2.3本年应计利息1.2.4本年还本1.2.5本年付息1.2.6本年还本付息2 2借借款款本本金金的的偿偿还还来来11、源源2.1利润2.2折旧及摊销2.3其它资金3 3偿偿债债保保证证比比例例3.1平均偿债保证比例7 78 89 910101111121213131414151520202020202120212022202220232023202420242025202520262026202720272028202820196.3918478.4616648.0014697.6512619.5510405.338046.085532.302853.871322.861210.341090.44962.70826.58681.55527.02362.37186.931717.931830.461950.3512、2078.102214.222359.252513.782678.432853.871322.861210.341090.44962.70826.58681.55527.02362.37186.933040.803040.803040.803040.803040.803040.803040.803040.803040.801616171718181919202021212222232324242029202920302030203120312032203220332033203420342035203520362036203720370.002525262627272828292930302013、3820382039203920402040204120412042204220432043成成本本估估算算表表(单单位位:万万元元)年份合计1 12 23 34 45 5项目2014201420152015201620162017201720182018序号生产负荷()00000水量637955485485489139131 1经经营营成成本本753911334.151334.151334.151621.241621.241.1原水费19319173.50173.50173.50285.65285.651.2药剂费12967180.20180.20180.20239.85239.85污泥处理14、费144910.6810.6810.6818.6118.611.3动力费15826150.73150.73150.73244.42244.421.4工资及福利9900330.00330.00330.00330.00330.001.5修理费12340425.51425.51425.51425.51425.511.6管理费359063.5363.5363.5377.2077.202 2折折旧旧和和摊摊销销475001583.331583.331583.331583.331583.333 3财财务务费费用用171121866.751789.851707.911620.611527.594 4总总成成15、本本1400034784.244707.344625.404825.184732.16生生产产负负荷荷产销差率18.00%82.00%管网漏失率3.5 平原区41.8%41.8%41.8%72.8%72.8%供水量1.461.461.462.552.55售水量1.201.201.202.092.097.5 平原区二期0 供水量售水量0.00.00.00.00.01.4 北山葡萄产业带0%0%0%0%0%供水量售水量0.00.00.00.00.00.5 世葡会主会场73.2%73.2%73.2%100.0%100.0%供水量0.370.370.370.500.50售水量0.300.300.30016、.410.41总总供供水水量量1.831.831.833.053.05总总售售水水量量1.501.501.502.502.503.5+7.50.5大岳首创大岳首创电费0.1920.2630.3301.581药剂0.1500.1060.2210.376污泥0.020人工费用330812修理费426585管理费用38374折旧摊销合计4750056670财务费用13932139326 67 78 89 91010111112121313141420192019202020202021202120222022202320232024202420252025202620262027202700000017、0001197200820082008200825552555255525551834.202440.332440.331993.552440.332849.882849.882849.882849.88369.78609.22609.22609.22609.22771.00771.00771.00771.00285.01413.54413.54413.54413.54500.38500.38500.38500.3825.5545.3145.3145.3145.3158.6758.6758.6758.67311.01500.55500.55500.55500.55628.61628.6162818、.61628.61330.00330.00330.00330.00330.00330.00330.00330.00330.00425.51425.51425.51,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。,。425.51425.51425.51425.51425.5187.34116.21116.2194.93116.21135.71135.71135.71135.711583.331583.331583.331583.331583.331583.331583.331583.331583.331428.471322.861210.341090.44962.19、70826.58681.55527.02362.374846.015346.535234.014667.334986.365259.805114.764960.234795.587.83%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%3.503.503.503.503.503.503.503.503.502.872.872.872.872.872.872.872.872.8736.1%36.1%36.1%36.1%60.5%60.5%60.5%60.5%2.712.712.712.714.544.544.544.540.02.22220、.222.222.223.723.723.723.720%0%0%0%0%0%0%0%0%0.00.00.00.00.00.00.00.00.0100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%0.500.500.500.500.500.500.500.500.500.410.410.410.410.410.410.410.410.414.006.716.716.716.718.548.548.548.543.285.505.505.505.507.007.007.007.0015151616171718181919202021212221、2223232028202820292029203020302031203120322032203320332034203420352035203620360000000002555255525552555255525552555255525552849.882849.882849.882849.882849.882849.882849.882849.882849.88771.00771.00771.00771.00771.00771.00771.00771.00771.00500.38500.38500.38500.38500.38500.38500.38500.38500.3858.67522、8.6758.6758.6758.6758.6758.6758.6758.67628.61628.61628.61628.61628.61628.61628.61628.61628.61330.00330.00330.00330.00330.00330.00330.00330.00330.00425.51425.51425.51425.51425.51425.51425.51425.51425.51135.71135.71135.71135.71135.71135.71135.71135.71135.711583.331583.331583.331583.331583.331583.3315823、3.331583.331583.33186.930.000.000.000.000.000.000.000.004620.144433.224433.224433.224433.224433.224433.224433.224433.22100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%3.503.503.503.503.503.503.503.503.502.872.872.872.872.872.872.872.872.8760.5%60.5%60.5%60.5%60.5%60.5%60.5%60.5%60.5%4.544.544.24、544.544.544.544.544.544.543.723.723.723.723.723.723.723.723.720%0%0%0%0%0%0%0%0%0.00.00.00.00.00.00.00.00.0100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%100.0%0.500.500.500.500.500.500.500.500.500.410.410.410.410.410.410.410.410.418.548.548.548.548.548.548.548.548.547.007.007.007.007.007.007.007.025、07.00242425252626272728282929303020372037203820382039203920402040204120412042204220432043000000025552555255525552555255525552849.882849.882849.882849.882849.882849.882849.88771.00771.00771.00771.00771.00771.00771.00500.38500.38500.38500.38500.38500.38500.3858.6758.6758.6758.6758.6758.6758.67628.616226、8.61628.61628.61628.61628.61628.61330.00330.00330.00330.00330.00330.00330.00425.51425.51425.51425.51425.51425.51425.51135.71135.71135.71135.71135.71135.71135.711583.331583.331583.331583.331583.331583.331583.330.000.000.000.000.000.000.004433.224433.224433.224433.224433.224433.224433.22100.0%100.0%1027、0.0%100.0%100.0%100.0%100.0%3.503.503.503.503.503.503.502.872.872.872.872.872.872.8760.5%60.5%60.5%60.5%60.5%60.5%60.5%4.544.544.544.544.544.544.543.723.723.723.723.723.723.720%0%0%0%0%0%00.00.00.00.00.00.00.0100.0%100.0%100.0%100.0%100.0%100.0%100.0%0.500.500.500.500.500.500.500.410.410.410.410.41028、.410.418.548.548.548.548.548.548.547.007.007.007.007.007.007.00损损益益表表(单单位位:万万元元)序号年份1 12 23 34 45 5项目20142014201520152016201620172017201820181 1收收入入7493.857493.857493.859289.759289.751.1销售收入2003.852003.852003.853339.753339.751.2补贴收入5490.005490.005490.005950.005950.002 2总总成成本本费费用用4784.244707.344625.429、04825.184732.163 3利利润润总总额额2709.612786.512868.454464.574557.593.1弥补以前年度亏损0.003.2应纳税所得额2709.612786.512868.454464.574557.594 4所所得得税税49720677.40696.63717.111116.141139.405 5税税后后利利润润149160 2032.212089.882151.343348.433418.195.1盈余公积金(10)203.22208.99215.13334.84341.825.2未分配利润1828.991880.901936.203013.5930730、6.386 6累累计计未未分分配配利利润润1828.993709.885646.098659.6711736.056 67 78 89 9101011111212131320192019202020202021202120222022202320232024202420252025202620266910.759876.459876.459876.459876.4512570.3012570.3012570.304381.757347.457347.457347.457347.459351.309351.309351.30252925292529252925293219.003219.003231、19.004846.015346.535234.014667.334986.365259.805114.764960.232064.754529.924642.445209.124890.097310.507455.547610.072064.754529.924642.445209.124890.097310.507455.547610.07516.191132.481160.611302.281222.521827.631863.881902.521548.563397.443481.833906.843667.575482.885591.655707.55154.86339.74348.32、18390.68366.76548.29559.17570.751393.703057.703133.653516.163300.814934.595032.495136.7913129.7516187.4519321.1022837.2526138.0631072.6536105.1441241.9314141515161617171818191920202121202720272028202820292029203020302031203120322032203320332034203412570.3012570.3012570.3012570.3012570.3012570.30125733、0.3012570.309351.309351.309351.309351.309351.309351.309351.309351.303219.003219.003219.003219.003219.003219.003219.003219.004795.584620.144433.224433.224433.224433.224433.224433.227774.727950.168137.088137.088137.088137.088137.088137.087774.727950.168137.088137.088137.088137.088137.088137.081943.68134、987.542034.272034.272034.272034.272034.272034.275831.045962.626102.816102.816102.816102.816102.816102.81583.10596.26610.28610.28610.28610.28610.28610.285247.945366.365492.535492.535492.535492.535492.535492.5346489.8751856.2257348.7662841.2968333.8273826.3579318.8884811.42222223232424252526262727282835、2929203520352036203620372037203820382039203920402040204120412042204212570.3012570.3012570.3012570.3012570.3012570.3012570.3012570.309351.309351.309351.309351.309351.309351.309351.309351.303219.003219.003219.003219.003219.003219.003219.003219.004433.224433.224433.224433.224433.224433.224433.224433.2236、8137.088137.088137.088137.088137.088137.088137.088137.088137.088137.088137.088137.088137.088137.088137.088137.082034.272034.272034.272034.272034.272034.272034.272034.276102.816102.816102.816102.816102.816102.816102.816102.81610.28610.28610.28610.28610.28610.28610.28610.285492.535492.535492.535492.5337、5492.535492.535492.535492.5390303.9595796.48101289.01106781.54112274.08117766.61123259.14128751.6730302043204312570.309351.303219.004433.228137.088137.082034.276102.81610.285492.53134244.20现现金金流流量量表表(单单位位:万万元元)序号年份0 01 12 23 34 45 56 6项目2014201420152015201620162017201720182018201920191 1现现金金流流入入0.0038、7493.857493.857493.859289.759289.756910.751.1销售收入7493.857493.857493.859289.759289.756910.751.2回收固定资产余值1.3回收流动资金2 2现现金金流流出出19000.005052.355071.585092.065778.185801.435391.192.1初始投资19000.002.2流动资金2.3经营成本1334.151334.151334.151621.241621.241834.202.4还本付息3040.803040.803040.803040.803040.803040.802.5所得税6739、7.40696.63717.111116.141139.40516.193 3净净现现金金流流量量-19000.002441.502422.272401.793511.573488.321519.574 4财财务务评评价价4.1IRR17.70%补贴水量水价经营成本敏感性分析100%100%100%100%7 78 89 91010111112121313141415152020202020212021202220222023202320242024202520252026202620272027202820289876.459876.459876.459876.4512570.301257040、.3012570.3012570.3012570.309876.459876.459876.459876.4512570.3012570.3012570.3012570.3012570.306613.616641.746336.636703.657718.317754.567793.207834.367878.222440.332440.331993.552440.332849.882849.882849.882849.882849.883040.803040.803040.803040.803040.803040.803040.803040.803040.801132.481160.611341、02.281222.521827.631863.881902.521943.681987.543262.843234.713539.823172.804851.994815.744777.104735.944692.0816161717181819192020212122222323202920292030203020312031203220322033203320342034203520352036203612570.3012570.3012570.3012570.3012570.3012570.3012570.3012570.3012570.3012570.3012570.3012570.42、3012570.3012570.3012570.3012570.304884.154884.154884.154884.154884.154884.154884.154884.152849.882849.882849.882849.882849.882849.882849.882849.880.002034.272034.272034.272034.272034.272034.272034.272034.277686.157686.157686.157686.157686.157686.157686.157686.152424252526262727282829293030203720372043、382038203920392040204020412041204220422043204312570.3012570.3012570.3012570.3012570.3012570.3012570.3012570.3012570.3012570.3012570.3012570.3012570.3012570.304884.154884.154884.154884.154884.154884.154884.152849.882849.882849.882849.882849.882849.882849.882034.272034.272034.272034.272034.272034.272044、34.277686.157686.157686.157686.157686.157686.157686.15资资产产负负债债表表(单单位位:万万元元)序号年份0 01 12 23 34 45 56 6项目2014201420152015201620162017201720182018201920191 1资资产产1.1流动资产2441.504863.777265.5510777.1214265.4415785.011.2固定资产23400.00 22620.0021840.0021060.0020280.0019500.0018720.001.3无形资产24100.00 23296.6722445、93.3321690.0020886.6720083.3319280.001.4合计47500.00 48358.1649197.1050015.5551943.7953848.7753785.012 2负负债债和和所所有有者者权权益益2.1负债28500.00 27325.9526075.0024742.1223321.9321808.7220196.392.1.1流动负债2.1.2长期负债 28500.00 27325.9526075.0024742.1223321.9321808.7220196.392.2所有者权益19000.00 21032.2123122.0925273.4328646、21.8632040.0533588.612.2.1资本金 19000.00 19000.0019000.0019000.0019000.0019000.0019000.002.2.2盈余公积金203.22412.21627.34962.191304.011458.862.2.3 累计未分配利润1828.993709.885646.098659.6711736.0513129.752.3合计47500.00 48358.1649197.1050015.5551943.7953848.7753785.013 3判判断断0.000.000.000.000.000.000.004 4财财务务评评价价47、4.1净资产利润率10.15%9.47%8.89%12.43%11.27%4.72%净资产利润率=净利润*2/(本年期初净资产+本年期末净资产)54.757 78 89 910101111121213131414151520202020202120212022202220232023202420242025202520262026202720272028202819047.8422282.5525822.3728995.1733847.1738662.9043440.0148175.9552868.0317940.0017160.0016380.0015600.0014820.0014040.48、0013260.0012480.0011700.0018476.6717673.3316870.0016066.6715263.3314460.0013656.6712853.3312050.0055464.5157115.8959072.3760661.8463930.5067162.9070356.6773509.2876618.0318478.4616648.0014697.6512619.5510405.338046.085532.302853.870.0018478.4616648.0014697.6512619.5510405.338046.085532.302853.870.0049、36986.0540467.8844374.7348042.2953525.1759116.8264824.3770655.4176618.0319000.0019000.0019000.0019000.0019000.0019000.0019000.0019000.0019000.001798.612146.792537.472904.233452.524011.684582.445165.545761.8016187.4519321.1022837.2526138.0631072.6536105.1441241.9346489.8751856.2255464.5157115.895907250、.3760661.8463930.5067162.9070356.6773509.2876618.030.000.000.000.000.000.000.000.000.009.63%8.99%9.21%7.94%10.80%9.93%9.21%8.61%8.10%16161717181819192020212122222323242420292029203020302031203120322032203320332034203420352035203620362037203760554.1768240.3275926.4783612.6191298.7698984.91106671.051151、4357.20122043.3510920.0010140.009360.008580.007800.007020.006240.005460.004680.0011246.6710443.339640.008836.678033.337230.006426.675623.334820.0082720.8488823.6594926.47101029.28107132.09113234.91119337.72125440.53131543.350.000.000.000.000.000.000.000.000.0082720.8488823.6594926.47101029.28107132.52、09113234.91119337.72125440.53131543.3519000.0019000.0019000.0019000.0019000.0019000.0019000.0019000.0019000.006372.086982.377592.658202.938813.219423.4910033.7710644.0511254.3357348.7662841.2968333.8273826.3579318.8884811.4290303.9595796.48101289.0182720.8488823.6594926.47101029.28107132.09113234.9153、119337.72125440.53131543.350.000.000.000.000.000.000.000.000.007.66%7.12%6.64%6.23%5.86%5.54%5.25%4.99%4.75%252526262727282829293030203820382039203920402040204120412042204220432043129729.49137415.64145101.79152787.93160474.08168160.233900.003120.002340.001560.00780.000.004016.673213.332410.001606.6754、803.330.00137646.16143748.97149851.79155954.60162057.41168160.230.000.000.000.000.000.00137646.16143748.97149851.79155954.60162057.41168160.2319000.0019000.0019000.0019000.0019000.0019000.0011864.6212474.9013085.1813695.4614305.7414916.02106781.54112274.08117766.61123259.14128751.67134244.20137646.155、6143748.97149851.79155954.60162057.41168160.230.000.000.000.000.000.004.53%4.34%4.16%3.99%3.84%3.70%水资源费污水处理费自来水价格合计19910.30.319960.50.519970.80.819981.11.119991.61.620002220020.30.51.72.520030.60.61.72.920041.10.91.73.720091.261.041.7420141.571.362.075补贴0-5%-10%-15%-20%IRR17.70%17.23%16.78%16.34%1556、.92%自来水价格-5%-10%-15%-20%IRR17.70%17.22%16.74%16.24%15.74%基本水量-5%-10%-15%-20%IRR17.70%17.13%16.54%15.95%15.34%经营成本-5%10%15%20%IRR17.70%-20%-18%-16%-14%-12%-10%-8%-6%-4%-2%0%15.00%15.50%16.00%16.50%17.00%17.50%18.00%补贴自来水价格基本水量-20%-18%-16%-14%-12%-10%-8%-6%-4%-2%0%15.00%15.50%16.00%16.50%17.00%17.50%18.00%补贴自来水价格基本水量
CAD图纸
上传时间:2024-05-06
12份