《LNG加气站工程财务分析表.doc》由会员分享，可在线阅读，更多相关《LNG加气站工程财务分析表.doc（11页珍藏版）》请在taowenge.com淘文阁网|工程机械CAD图纸|机械工程制图|CAD装配图下载|SolidWorks_CaTia_CAD_UG_PROE_设计图分享下载上搜索。
1、LNG加气站工程财务分析表附表1现金流量表（总投资）1附表2 资金来源与运用表2附表3 项目资产折旧费估算表3附表4 总成本费用估算表4附表5 销售收入和销售税金及附加估算表6附表6 损益表7附表7 敏感性分析表8现金流量表（总投资）现金流量表（总投资）表：1 单位：万元序号年份项目合计建设期投产期20122013201420152016201720182019202020212022202320242025202620272028202920302031生产年序号1234567891011121314151617181920生产负荷（%）1现金流入46121622.91245.81893.7
2、2491.72491.72491.72491.72491.72491.72491.72491.72491.72491.72491.72491.72491.72491.72491.72491.72491.71.1产品销售收入46096622.91245.81868.72491.72491.72491.72491.72491.72491.72491.72491.72491.72491.72491.72491.72491.72491.72491.72491.72491.71.2回收固定资产余值1.3回收流动资金25.02现金流出427782292.81273.52713.92170.52145.52
3、145.52145.52145.52145.52145.52145.52145.52145.52145.52145.52145.52145.52145.52145.52145.52.1固定资产投资28101655.9112.41042.02.2流动资金25.02.3经营成本37828603.31088.81561.32033.82033.82033.82033.82033.82033.82033.82033.82033.82033.82033.82033.82033.82033.82033.82033.82033.82.4销售税金及附加620.41.42.43.43.43.43.43.43.4
4、3.43.43.43.43.43.43.43.43.43.43.42.5所得税205333.370.9108.3108.3108.3108.3108.3108.3108.3108.3108.3108.3108.3108.3108.3108.3108.3108.3108.3108.33净现金流量3342321.17346.17346.17346.17346.17346.17346.17346.17346.17346.17346.17346.17346.17346.17346.17346.17346.174累计净现金流量-1697.5-2517.7-2196.5-1850.4-1504.2-115
5、8.0-811.9-465.7-119.5226.6572.8919.01265.11611.31957.52303.62649.82996.03342.15所得税前净现金流量5394.9243.28429.42454.42454.42454.42454.42454.42454.42454.42454.42454.42454.42454.42454.42454.42454.42454.42454.426所得税前累计净现金流量-1593.3-2305.2-1875.8-1421.4-967.0-512.6-58.1396.3850.71305.11759.52214.02668.43122.83
6、577.24031.74486.14940.55394.9附表2 资金来源与运用表资金来源与运用表表：2 单位：万元序号年份项目合计建设期投产期2012201320142015201620172018201920202021202220232024202520262027202820292030203112345678910111213141516171819201资金来源109801697.11265.011344.00451.42451.42451.42451.42451.42451.42451.42451.42451.42451.42451.42451.42451.42451.42451
7、.42451.42451.421.1利润总额7777-2.14134.24283.63433.02433.02433.02433.02433.02433.02433.02433.02433.02433.02433.02433.02433.02433.02433.02433.02433.021.2折旧费36818.4018.4018.4018.4018.4018.4018.4018.4018.4018.4018.4018.4018.4018.4018.4018.4018.4018.4018.4018.401.3摊销费1.4长期借款1.5流动资金借款1.6其它借款1.7自有资金28351680.8
8、5112.361041.971.8回收固定资产余值1.9回收流动资金2资金运用48631689.14183.271150.22108.26108.26108.26108.26108.26108.26108.26108.26108.26108.26108.26108.26108.26108.26108.26108.26108.262.1固定资产投资28101655.85112.361041.972.2建设期利息2.3流动资金2.4所得税205333.2970.91108.26108.26108.26108.26108.26108.26108.26108.26108.26108.26108.261
9、08.26108.26108.26108.26108.26108.26108.262.5长期借款本金偿还2.6流动资金借款本金偿还3盈余资金61178821943433433433433433433433433433433433433433433433433434累计盈余资金890283627970131316561999234226863029337237154058440147455088543157746117附表3 项目资产折旧费估算表固定资产折旧估算表表:3 单位：万元年份原 值折旧年限建设期投产期2012201320142015201620172018201920202021202
10、2202320242025202620272028202920302031项目1234567891011121314151617181920房屋建筑物118.00205.95.95.95.95.95.95.95.95.95.95.95.95.95.95.95.95.95.95.95.9折旧112.1106.2100.394.488.582.676.770.864.959.053.147.241.335.429.523.617.711.85.9(0.0)净值机器设备250.002012.512.512.512.512.512.512.512.512.512.512.512.512.512.512
11、.512.512.512.512.512.5折旧237.5225.0212.5200.0187.5175.0162.5150.0137.5125.0112.5100.087.575.062.550.037.525.012.50.0净值原值368.00折旧18.418.418.418.418.418.418.418.418.418.418.418.418.418.418.418.418.418.418.418.4净值349.6331.2312.8294.4276.0257.6239.2220.8202.4184.0165.6147.2128.8110.492.073.655.236.818.40
12、.0附表4 总成本费用估算表总成本费用估算表表：4 单位：万元序号年份项目数量单价建设期投产期2012201320142015201620172018201920202021202220232024202520262027202820292030203112345678910111213141516171819201外购原材料3.6472.59451417.5189018901890189018901890189018901890189018901890189018901890189018902燃料、动力（水、电）3600.2382.882.882.882.882.882.882.882.88
13、2.882.882.882.882.882.882.882.882.882.882.882.83房屋、土地租赁1010101010101010101010101010101010101010104工资及福利费13213262626262626262626262626262626262626265折旧费18.418.418.418.418.418.418.418.418.418.418.418.418.418.418.418.418.418.418.418.46摊销费333333333333333333337修理费25252525252525252525252525252525252525258
14、利息支出其中：长期借款利息流动资金借款利息9其它费用10总成本费用624.71110.21582.72055.22055.22055.22055.22055.22055.22055.22055.22055.220552055.22055.220552055.220552055.22055.2其中：固定成本59.472.472.472.472.472.472.472.472.472.472.472.472.472.472.472.472.472.472.472.4可变成本565.31037.81510.31982.81982.81982.81982.81982.81982.81982.81982
15、.81982.819831982.81982.819831982.819831982.81982.811经营成本603.31088.81561.32033.82033.82033.82033.82033.82033.82033.82033.82033.820342033.82033.820342033.820342033.82033.812单位成本附表5 销售收入和销售税金及附加估算表 销售收入和销售税金及附加估算表表：5 单位：万元序号项目单价（元）2012年2013年2014年2015年2016年20172031年售气量金额售气量金额售气量金额售气量金额售气量金额售气量金额万m3万元万m3
16、万元万m3万元万m3万元万m3万元万m3万元1销售收入（天然气）4.2131.250 551.250 262.500 1102.500 393.750 1653.750 5252205.000 5252205.000 5252205.000 2销项税（13%）71.66 143.33 214.99 286.65 286.65 286.65 3进项税：68.09 129.52 190.94 252.37 252.37 252.37 其中： 天然气（13%）61.43 122.85 184.28 245.70 245.70 245.70 水（6%）4.97 4.97 4.97 4.97 4.97
17、4.97 电（17%）1.70 1.70 1.70 1.70 1.70 1.70 4增值税3.57 13.81 24.04 34.28 34.28 34.28 5城市维护建设税（7%）0.25 0.97 1.68 2.40 2.40 2.40 6教育费附加（3%）0.11 0.41 0.72 1.03 1.03 1.03 7销售税金及附加0.36 1.38 2.40 3.43 3.43 3.43 新能源有限公司 11附表6 损益表 损益表表：6 单位：万元 序号 年份项目合计建设期投产期201220132014201520162017201820192020202120222023202420
18、2520262027202820292030203112345678910111213141516171819201产品销售收入46096 622.9 1245.8 1868.7 2491.7 2491.7 2491.7 2491.7 2491.7 2491.7 2491.7 2491.7 2491.7 2491.7 2491.7 2491.7 2491.7 2491.7 2491.7 2491.7 2491.7 2销售税金及附加62 0.4 1.4 2.4 3.4 3.4 3.4 3.4 3.4 3.4 3.4 3.4 3.4 3.4 3.4 3.4 3.4 3.4 3.4 3.4 3.4
19、3总成本费用38256 624.7 1110.2 1582.7 2055.2 2055.2 2055.2 2055.2 2055.2 2055.2 2055.2 2055.2 2055.2 2055.2 2055.2 2055.2 2055.2 2055.2 2055.2 2055.2 2055.2 4利润总额7777 -2.1 134.2 283.6 433.0 433.0 433.0 433.0 433.0 433.0 433.0 433.0 433.0 433.0 433.0 433.0 433.0 433.0 433.0 433.0 433.0 5弥补以前年度亏损1.1 6应纳税所得额
20、133.2 283.6 433.0 433.0 433.0 433.0 433.0 433.0 433.0 433.0 433.0 433.0 433.0 433.0 433.0 433.0 433.0 433.0 433.0 7所得税1945 33.3 70.9 108.3 108.3 108.3 108.3 108.3 108.3 108.3 108.3 108.3 108.3 108.3 108.3 108.3 108.3 108.3 108.3 108.3 8税后利润5835 101.0 212.7 324.8 324.8 324.8 324.8 324.8 324.8 324.8 3
21、24.8 324.8 324.8 324.8 324.8 324.8 324.8 324.8 324.8 324.8 9盈余公积金、公益金15.1 31.9 48.7 48.7 48.7 48.7 48.7 48.7 48.7 48.7 48.7 48.7 48.7 48.7 48.7 48.7 48.7 48.7 48.7 10未分配利润4960 85.8 180.8 276.1 276.1 276.1 276.1 276.1 276.1 276.1 276.1 276.1 276.1 276.1 276.1 276.1 276.1 276.1 276.1 276.1 附表7 敏感性分析表敏感性分析表附表7单位：万元项目内部收益率（）净现值（万元）投资回收期（年）税前税后税前税后税前税后基本方案14.45 9.45 1228.70 267.27 7.13 9.35 固定资产投资增加57.41 5.28 -107.07 -473.93 10.63 12.33 销售收入减少54.87 3.27 -519.58 -756.46 12.70 14.36 经营成本增加55.62 3.14 -399.57 -780.74 12.02 14.51