140426_北京_延慶平原區(qū)地表水供水工程及葡萄產(chǎn)業(yè)帶集中供水工程特許經(jīng)營項(xiàng)目_財務(wù)測算.xlsx
下載文檔
上傳人:正***
編號:855822
2023-12-21
31頁
77.91KB
1、基基本本情情況況基基本本假假設(shè)設(shè)資資產(chǎn)產(chǎn)總總額額總投資47500 萬元基本水價3.66資本金19000.00自來水價格2.4 元/立方米首創(chuàng)95%水資源費(fèi)價格1.26 元/立方米鼎華5%污水處理費(fèi)價格1.04 元/立方米融資28500.00貸款期限15 年運(yùn)運(yùn)營營補(bǔ)補(bǔ)貼貼貸款利率6.55%135490 萬元/年還款方式等額本息455950 萬元/年610(最高)2529 萬元/年特特許許經(jīng)經(jīng)營營期期補(bǔ)貼水價1.26 元/立方米長度30 年1130(最高)3219 萬元/年開始年份2014補(bǔ)貼水價1.26 元/立方米結(jié)束年份2043項(xiàng)項(xiàng)目目參參數(shù)數(shù)1保底水量131.5 萬t/d452.5 萬t/2、d6105.5 萬t/d11307 萬t/d2年工作天數(shù)365 天經(jīng)經(jīng)營營成成本本1原水萬元/年備注1.1原水價格0.3 元/噸1.2取用水量2電費(fèi)萬元/年2.1基本電費(fèi)萬元/年基本電價元/度容量度2.2電度電費(fèi)萬元/年單耗度/t電度電價元/度3藥劑萬元/年3.1單耗kg/t泥3.2單價元/kg4水費(fèi)萬元/年6管理費(fèi)用萬元/年7大修理基金提存率8日常檢修維護(hù)費(fèi)固定資產(chǎn)凈值所所得得稅稅率率25%1.72.4項(xiàng)項(xiàng)目目價價格格構(gòu)構(gòu)成成1經(jīng)營成本0.9813動力0.2481藥劑0.0028污泥處置0.0227原水費(fèi)0.3028人工成本0.1552大修費(fèi)0.1934管理費(fèi)0.05632折舊及攤銷0.743、463財務(wù)費(fèi)用0.26824所得稅0.77945凈利潤2.3381折折舊舊及及攤攤銷銷(單單位位:萬萬元元)序號年份1 12 23 34 45 56 67 7項(xiàng)目201420142015201520162016201720172018201820192019202020201 1折折舊舊1.1房屋建筑物1.1.1期初234002262021840210602028019500187201.1.2當(dāng)年折舊7807807807807807807801.1.3累計折舊7801560234031203900468054601.1.4固定資產(chǎn)增加1.1.5期末凈值226202184021060202804、1950018720179401.2設(shè)備1.2.1期初1.2.2當(dāng)年折舊1.2.3累計折舊1.2.4設(shè)備增加1.2.5期末凈值2 2攤攤銷銷2.1土地使用權(quán)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融融資資結(jié)結(jié)構(gòu)構(gòu)(單單位位:萬萬元元)序號年份1 12 23 34 45 56 6項(xiàng)目2014201420152015201620162017201720182018201920191 1借借款款及及還還本本付付息息1.1長期負(fù)債1.1.1年初借款本息合計27325.9526075.0024742.1223321.9321808.721.1.2本年借款285010、0.001.1.3本年應(yīng)計利息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流動負(fù)債1.2.1年初借款本息合計1.2.2本年借款1.2.3本年應(yīng)計利息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項(xiàng)目2014201420152015201620162017201720182018序號生產(chǎn)負(fù)荷()00000水量637955485485489139131 1經(jīng)經(jīng)營營成成本本753911334.151334.151334.151621.241621.241.1原水費(fèi)19319173.50173.50173.50285.65285.651.2藥劑費(fèi)12967180.20180.20180.20239.85239.85污泥處理14、費(fèi)144910.6810.6810.6818.6118.611.3動力費(fèi)15826150.73150.73150.73244.42244.421.4工資及福利9900330.00330.00330.00330.00330.001.5修理費(fèi)12340425.51425.51425.51425.51425.511.6管理費(fèi)359063.5363.5363.5377.2077.202 2折折舊舊和和攤攤銷銷475001583.331583.331583.331583.331583.333 3財財務(wù)務(wù)費(fèi)費(fèi)用用171121866.751789.851707.911620.611527.594 4總總成成15、本本1400034784.244707.344625.404825.184732.16生生產(chǎn)產(chǎn)負(fù)負(fù)荷荷產(chǎn)銷差率18.00%82.00%管網(wǎng)漏失率3.5 平原區(qū)41.8%41.8%41.8%72.8%72.8%供水量1.461.461.462.552.55售水量1.201.201.202.092.097.5 平原區(qū)二期0 供水量售水量0.00.00.00.00.01.4 北山葡萄產(chǎn)業(yè)帶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大岳首創(chuàng)大岳首創(chuàng)電費(fèi)0.1920.2630.3301.581藥劑0.1500.1060.2210.376污泥0.020人工費(fèi)用330812修理費(fèi)426585管理費(fèi)用38374折舊攤銷合計4750056670財務(wù)費(fèi)用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項(xiàng)目20142014201520152016201620172017201820181 1收收入入7493.857493.857493.859289.759289.751.1銷售收入2003.852003.852003.853339.753339.751.2補(bǔ)貼收入5490.005490.005490.005950.005950.002 2總總成成本本費(fèi)費(fèi)用用4784.244707.344625.429、04825.184732.163 3利利潤潤總總額額2709.612786.512868.454464.574557.593.1彌補(bǔ)以前年度虧損0.003.2應(yīng)納稅所得額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現(xiàn)現(xiàn)金金流流量量表表(單單位位:萬萬元元)序號年份0 01 12 23 34 45 56 6項(xiàng)目2014201420152015201620162017201720182018201920191 1現(xiàn)現(xiàn)金金流流入入0.0038、7493.857493.857493.859289.759289.756910.751.1銷售收入7493.857493.857493.859289.759289.756910.751.2回收固定資產(chǎn)余值1.3回收流動資金2 2現(xiàn)現(xiàn)金金流流出出19000.005052.355071.585092.065778.185801.435391.192.1初始投資19000.002.2流動資金2.3經(jīng)營成本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凈凈現(xiàn)現(xiàn)金金流流量量-19000.002441.502422.272401.793511.573488.321519.574 4財財務(wù)務(wù)評評價價4.1IRR17.70%補(bǔ)貼水量水價經(jīng)營成本敏感性分析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資資產(chǎn)產(chǎn)負(fù)負(fù)債債表表(單單位位:萬萬元元)序號年份0 01 12 23 34 45 56 6項(xiàng)目2014201420152015201620162017201720182018201920191 1資資產(chǎn)產(chǎn)1.1流動資產(chǎn)2441.504863.777265.5510777.1214265.4415785.011.2固定資產(chǎn)23400.00 22620.0021840.0021060.0020280.0019500.0018720.001.3無形資產(chǎn)24100.00 23296.6722445、93.3321690.0020886.6720083.3319280.001.4合計47500.00 48358.1649197.1050015.5551943.7953848.7753785.012 2負(fù)負(fù)債債和和所所有有者者權(quán)權(quán)益益2.1負(fù)債28500.00 27325.9526075.0024742.1223321.9321808.7220196.392.1.1流動負(fù)債2.1.2長期負(fù)債 28500.00 27325.9526075.0024742.1223321.9321808.7220196.392.2所有者權(quán)益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財財務(wù)務(wù)評評價價47、4.1凈資產(chǎn)利潤率10.15%9.47%8.89%12.43%11.27%4.72%凈資產(chǎn)利潤率=凈利潤*2/(本年期初凈資產(chǎn)+本年期末凈資產(chǎn))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%水資源費(fèi)污水處理費(fèi)自來水價格合計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補(bǔ)貼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%經(jīng)營成本-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%補(bǔ)貼自來水價格基本水量-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%補(bǔ)貼自來水價格基本水量
管理運(yùn)營
上傳時間:2024-12-17
57份
運(yùn)營管理
上傳時間:2021-04-23
8份
CAD圖紙
上傳時間:2024-05-06
12份
地產(chǎn)金融
上傳時間:2024-10-31
20份
商業(yè)廣場
上傳時間:2021-02-13
11份