工程经济分析表格.xls

《工程经济分析表格.xls》由会员分享，可在线阅读，更多相关《工程经济分析表格.xls（12页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、原原始始数数据据表表年年达达产产情情况况建设期12345678910111213141516171819200100100100100100100100100100100100100100100100100100100100100正正常常生生产产期期年年成成本本费费用用（万万元元）合计 原材料燃料费 动力费工资福利费设备维护费折旧费摊销费 其他费用 管理费 销售费用利息大修基金807.76807.7669.12273.612.9670.5954 338.8580042.627500154.835建建设设期期项项目目投投资资情情况况（万万元元）工程费用 其他费用 预备费 固定资产贷款金额贷款利息

2、 调节税贷款利率5700.73717.1641.717059.54000运运营营期期流流动动资资金金（万万元元）流动资金借款利息贷款利率76.8200营营业业收收入入（万万元元）排污收费 中水收费污水量排污费产中水单价0146000.9400001其其他他基基础础数数据据（）残值率税率所得税率盈余公积应付利润 基准收益率45251006运运行行费费用用序序号号项项目目年年费费用用（万万元元）单单方方水水费费用用（元元/m/m3 3）1 1动动力力费费273.60273.600.1900.19002 2药药剂剂费费54.7254.720.0380.038清洗药剂54.720.0383 3水水暖暖

3、费费14.4014.400.0100.0104 4工工资资及及福福利利费费12.9612.960.0090.0095 5日日常常检检修修维维护护费费70.6070.600.0490.0496 6折折旧旧费费338.86338.860.2350.2357 7大大修修基基金金154.84154.840.1080.10810408 8管管理理费费及及其其他他费费用用42.6342.630.0300.0309 9合合计计962.60962.600.6680.668固定成本606.920.381可变成本355.680.2871010经经营营成成本本468.90468.900.3260.326附附表表4

4、4：投投资资计计划划与与资资金金筹筹措措表表人民币单位：万元，外币折合成人民币序序号号项项目目合合计计建建设设期期运运营营期期外外币币人人民民币币小小计计外外币币人人民民币币小小计计外外币币人人民民币币小小计计1 1建建设设项项目目总总投投资资0 0 7136.36487136.3648 7136.36487136.36480 07059.547059.547059.547059.540 0 76.82483376.824833 76.82483376.8248331.1固定资产投资07059.547059.5407059.547059.54000工程费用05700.735700.730570

5、0.735700.73000工程建设其他费用0717.1717.10717.1717.1000预备费用0641.71641.710641.71641.710001.2建设期贷款利息0000000001.3流动资金0 76.824833 76.82483300076.8276.821.4固定资产投资方向调节税0000000002 2资资金金筹筹措措0 0 7136.36487136.3648 7136.36487136.36480 07059.547059.547059.547059.540 0 76.82483376.824833 76.82483376.8248332.1自有资金（项目资本金

6、）0 7136.3648 7136.364807059.547059.540 76.824833 76.824833其中:固定资产投资07059.547059.5407059.547059.54000 流动资金0 76.824833 76.8248330000 76.824833 76.8248332.2银行借款000000000固定投资借款000000000建设期利息000000000流动资金借款000000002.3其他资金0000000附-6附附表表5 5：总总成成本本费费用用估估算算表表人民币单位：万元序序号号项项目目合合计计运运营营期期1 12 23 34 45 56 67 78 8

7、9 910101111121213131414151516161717181819192020生产负荷（）1001001001001001001001001001001001001001001001001001001001001原材料、燃料费用1382.4 69.12 69.12 69.12 69.12 69.12 69.12 69.12 69.12 69.12 69.12 69.12 69.12 69.12 69.12 69.12 69.12 69.12 69.12 69.12 69.122动力费5472273.6 273.6 273.6 273.6 273.6 273.6 273.6 27

8、3.6 273.6 273.6 273.6 273.6 273.6 273.6 273.6 273.6 273.6 273.6 273.6 273.63工资及福利费259.212.96 12.96 12.96 12.96 12.96 12.96 12.96 12.96 12.96 12.96 12.96 12.96 12.96 12.96 12.96 12.96 12.96 12.96 12.96 12.964日常检修维护费1411.970.670.670.670.670.670.670.670.670.670.670.670.670.670.670.670.670.670.670.670.6

9、5管理费及其他费用852.55 42.63 42.63 42.63 42.63 42.63 42.63 42.63 42.63 42.63 42.63 42.63 42.63 42.63 42.63 42.63 42.63 42.63 42.63 42.63 42.636经营成本12475623.7 623.7 623.7 623.7 623.7 623.7 623.7 623.7 623.7 623.7 623.7 623.7 623.7 623.7 623.7 623.7 623.7 623.7 623.7 623.77固定资产折旧费6777.2 338.9 338.9 338.9 338

10、.9 338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.98大修基金3096.7 154.8 154.8 154.8 154.8 154.8 154.8 154.8 154.8 154.8 154.8 154.8 154.8 154.8 154.8 154.8 154.8 154.8 154.8 154.8 154.89摊销费00000000000000000000010 利息支出00000000000000000000011 总成本19252962.6 9

11、62.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6其中:可变成本8266.3 413.3 413.3 413.3 413.3 413.3 413.3 413.3 413.3 413.3 413.3 413.3 413.3 413.3 413.3 413.3 413.3 413.3 413.3 413.3 413.3 固定成本10986549.3 549.3 549.3 549.3 549.3 549.3 549.3 549

12、.3 549.3 549.3 549.3 549.3 549.3 549.3 549.3 549.3 549.3 549.3 549.3 549.3附-7附附表表6 6：流流动动资资金金估估算算表表人民币单位：万元序序号号项项目目最最低低周周转转天天数数周周转转次次数数运运营营期期1 12 23 34 45 56 67 78 89 9101011111212131314141515161617171818191920201 1流流动动资资产产133.9 133.9 133.9 133.9 133.9 133.9 133.9 133.9 133.9 133.9 133.9 133.9 133.9

13、 133.9 133.9 133.9 133.9 133.9 133.9 133.91.1应收账款6061041041041041041041041041041041041041041041041041041041041041.2存货120323.04 23.04 23.04 23.04 23.04 23.04 23.04 23.04 23.04 23.04 23.04 23.04 23.04 23.04 23.04 23.04 23.04 23.04 23.04 23.041.3现金4586.948 6.948 6.948 6.948 6.948 6.948 6.948 6.948 6.94

14、8 6.948 6.948 6.948 6.948 6.948 6.948 6.948 6.948 6.948 6.948 6.9482 2流流动动负负债债57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.122.1应付账款60657.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.

15、12 57.12 57.12 57.12 57.123 3流流动动资资金金（1-21-2）76.82 76.82 76.82 76.82 76.82 76.82 76.82 76.82 76.82 76.82 76.82 76.82 76.82 76.82 76.82 76.82 76.82 76.82 76.82 76.824 4流流动动资资金金当当期期增增加加额额76.820000000000000000000附-8附附表表7 7：项项目目投投资资现现金金流流量量表表人民币单位：万元序序号号项项目目合合计计建建设设期期运运营营期期0 01 12 23 34 45 56 67 78 89 9

16、10101111121213131414151516161717181819192020生生产产负负荷荷（）01001001001001001001001001001001001001001001001001001001001001 1现现金金流流入入29559.21014601460146014601460146014601460146014601460146014601460146014601460146014601819.211.1营业收入292000146014601460146014601460146014601460146014601460146014601460146014601

17、46014601460排污收费0000000000000000000000中水收费292000146014601460146014601460146014601460146014601460146014601460146014601460146014601.2政府财政补助收入01.3回收固定资产余值282.3816282.3821.4回收流动资金76.8248376.82482 2现现金金流流出出23193.15 7059.54 879.664 802.839 802.839 802.839 802.839 802.839 802.839 802.839 802.839 802.839 802

18、.839 802.839 802.839 802.839 802.839 802.839 802.839 802.839 802.839 802.8392.1固定资产投资7059.54 7059.542.2流动资金76.8248376.824800000000000000000002.3经营成本12474.77623.7623.7623.7623.7623.7623.7623.7623.7623.7623.7623.7623.7623.7623.7623.7623.7623.7623.7623.7623.72.4销售税金及附加1460737373737373737373737373737373

19、73737373732.5所得税2122.019106.1106.1106.1106.1106.1106.1106.1106.1106.1106.1106.1106.1106.1106.1106.1106.1106.1106.1106.1106.13 3净净现现金金流流量量（1-21-2）6366.056-7060580.336 657.161 657.161 657.161 657.161 657.161 657.161 657.161 657.161 657.161 657.161 657.161 657.161 657.161 657.161 657.161 657.161 657.16

20、1 657.161 1016.374 4累累计计净净现现金金流流量量-7060-6479-5822-5165-4508-3851-3193-2536-1879-1222-56592750140720642721337840354693535063666 6所所得得税税前前净净现现金金流流量量（3+2.53+2.5）8488-706068676376376376376376376376376376376376376376376376376376311227 7累累计计所所得得税税前前净净现现金金流流量量-7060-6373-5610-4847-4083-3320-2557-1794-1030-2

21、674961260202327863549431350765839660273668488计算指标：所得税前所得税后财务内部收益率（）8.81%6.86%财务净现值（ic6）0.061,636488投资回收期（年）9.3510.86附-9附附表表8 8：损损益益表表人民币单位：万元序序号号项项目目合合计计运运营营期期1 12 23 34 45 56 67 78 89 910101111121213131414151516161717181819192020生生产产负负荷荷（）100100100100100100100100100100100100100100100100100100100100

22、1 1营营业业收收入入2920014601460146014601460146014601460146014601460146014601460146014601460146014601460排污收费000000000000000000000中水收费29200146014601460146014601460146014601460146014601460146014601460146014601460146014602 2销销售售税税金金及及附附加加146073737373737373737373737373737373737373733 3总总成成本本费费用用19252962.6 962.6

23、 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.6 962.64 4政政府府财财政政补补助助收收入入5 5利利润润总总额额（1-2-3+41-2-3+4）8488.1 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.46 6弥弥补补以以前前年年度度亏亏损损0

24、000000000000000000007 7应应纳纳税税所所得得额额（5-65-6）8488.1 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.48 8所所得得税税2122106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.

25、19 9净净利利润润（7-87-8）6366.1 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.31010可可供供分分配配利利润润6366.1 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.3 318.31111盈盈余余公公积积金金

26、636.61 31.83 31.83 31.83 31.83 31.83 31.83 31.83 31.83 31.83 31.83 31.83 31.83 31.83 31.83 31.83 31.83 31.83 31.83 31.83 31.831212应应付付利利润润0000000000000000000001313未未分分配配利利润润5729.5 286.5 286.5 286.5 286.5 286.5 286.5 286.5 286.5 286.5 286.5 286.5 286.5 286.5 286.5 286.5 286.5 286.5 286.5 286.5 286.51

27、414累累计计未未分分配配利利润润60159286.5 572.9 859.411461432171920052292257828653151343837244011429745844870515754435729附-10附附表表9 9：资资金金来来源源与与运运用用表表人民币单位：万元序序号号项项目目合合计计建建设设期期运运营营期期上上年年余余值值0 01 12 23 34 45 56 67 78 89 910101111121213131414151516161717181819192020生生产产负负荷荷(%)(%)0100100100100100100100100100100100100

28、1001001001001001001001001 1资资金金来来源源227617060840.1 763.3 763.3 763.3 763.3 763.3 763.3 763.3 763.3 763.3 763.3 763.3 763.3 763.3 763.3 763.3 763.3 763.3 763.3 763.3 359.21.1 利润总额8488424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4 424.4

29、1.2 折旧费6777338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.9 338.91.3 摊销费0000000000000000000001.4 长期借款001.5 流动资金借款0000000000000000000001.6 其他短期借款01.7 自有资金71367060 76.8200000000000000000001.8 回收固定资产余值282.4282.41.9 回收流动资金76.8276.822 2资资金金

30、运运用用92587060 182.9 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.12.1 固定资产投资706070602.2 建设期利息002.3 流动资金76.8276.8200000000000000000002.4 所得税2122106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 106.1 1

31、06.1 106.1 106.1 106.1 106.12.5 应付利润0000000000000000000002.6 长期借款本金偿还00000000000000000000002.7 流动资金借款本金偿还00000000000000000000002.8 其他短期借款本金偿还00000000000000000000003 3盈盈余余资资金金131430657.2 657.2 657.2 657.2 657.2 657.2 657.2 657.2 657.2 657.2 657.2 657.2 657.2 657.2 657.2 657.2 657.2 657.2 657.2 657.24

32、 4累累计计盈盈余余资资金金0657.21314197126293286394346005257591465727229788685439200985710515 11172 11829 12486 13143 13143投资利润率（）5.95%投资利税率（）6.97%附-11附附表表1010：资资产产负负债债表表人民币单位：万元序序号号项项目目建建设设期期运运营营期期0 01 12 23 34 45 56 67 78 89 9101011111212131314141515161617171818191920201 1资资产产706075127830814884678785910394229

33、74010058 10377106951101311331116501196812286126051292313241135601.1流动资产总额791.114482105276334204077473453916048 6705.6 7362.7 8019.986779334.2 9991.4 10649113061196312620132771.1.1 应收帐款104104104104104104104104104103.96 103.96 103.96 103.96 103.96 103.96 103.96 103.96 103.96 103.96 103.961.1.2 存货23.04

34、 23.04 23.04 23.04 23.04 23.04 23.04 23.04 23.04 23.0423.0423.0423.0423.0423.0423.0423.0423.0423.0423.041.1.3 现金6.948 6.948 6.948 6.948 6.948 6.948 6.948 6.948 6.948 6.9484 6.9484 6.9484 6.9484 6.9484 6.9484 6.9484 6.9484 6.9484 6.9484 6.94841.1.4 累计盈余资金657.213141971262932863943460052575914 6571.6 7

35、228.8 7885.9 8543.1 9200.3 9857.4 10515111721182912486131431.2在建工程70601.3固定资产净值6721638260435704536550264688434940103671 3332.1 2993.2 2654.4 2315.5 1976.7 1637.81299960.1 621.24 282.381.4无形资产及递延资产净值000000000000000000002 2负负债债及及所所有有者者权权益益706075127830814884678785910394229740 10058103771069511013113311

36、16501196812286126051292313241135602.1流动负债总额57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.1257.1257.1257.1257.1257.1257.1257.1257.1257.1257.122.1.1 应付帐款57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.1257.1257.1257.1257.1257.1257.1257.1257.1257.1257.122.1.2 流动资金借款00000000000000000

37、0002.1.3 其他短期借款2.2长期借款负债小计（2.1+2.2）057.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.12 57.1257.1257.1257.1257.1257.1257.1257.1257.1257.1257.122.3所有者权益706074557773809184108728904693649683 1000110319106381095611274115931191112229125481286613184135022.3.1 资本金7060713671367136713671367136713671367136

38、7136.4 7136.4 7136.4 7136.4 7136.4 7136.4 7136.4 7136.4 7136.4 7136.4 7136.42.3.2 资本公积金2.3.3 累计盈余公积金31.83 63.66 95.49 127.3 159.2191222.8 254.6 286.5 318.3 350.13 381.96 413.79 445.62 477.45 509.28 541.11 572.95 604.78 636.612.3.4 累计未分配利润286.5 572.9 859.4114614321719200522922578 2864.7 3151.2 3437.7

39、 3724.1 4010.6 4297.1 4583.648705156.554435729.5计算指标：资产负债率（）0.76%0.73%0.70%0.67%0.65%0.63%0.61%0.59%0.57%0.55%0.53%0.52%0.50%0.49%0.48%0.46%0.45%0.44%0.43%0.42%流动比率（）1385%2535%3686%4836%5987%7137%8288%9438%10589%11739%12890%14040%15191%16341%17492%18642%19793%20943%22094%23244%速动比率（）1345%2495%3646%4

40、796%5947%7097%8248%9398%10549%11699%12850%14000%15151%16301%17452%18602%19753%20903%22053%23204%附-12敏敏感感性性分分析析表表分析因素财务内部收益率（）变动因素-15%-10%-5%05%10%固定资产投资1312111098水价789101112经营成本11.51110.5109.59敏感性分析15%10%5%0%-5%-10%-15%2 4 6 8 10 12 14 16 18 变动幅度内部收益率固定资产投资水价经营成本15%7138.5敏感性分析15%10%5%0%-5%-10%-15%2 4 6 8 10 12 14 16 18 变动幅度内部收益率固定资产投资水价经营成本生产能力（）01固定成本（万元）549549总成本（万元）549963总收入（万元）01460盈亏平衡表100%90%80%70%60%50%40%30%20%10%0%0 200 400 600 800 1000 1200 1400 1600 生产能力金额（万元）固定成本总成本总收入