EMC电厂节能项目现金流量测算表表格文件下载.xls

EMC电厂节能项目现金流量测算表表格文件下载.xls

《EMC电厂节能项目现金流量测算表表格文件下载.xls》由会员分享，可在线阅读，更多相关《EMC电厂节能项目现金流量测算表表格文件下载.xls（26页珍藏版）》请在冰点文库上搜索。

100.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%0.00%银行贷款利率5.94%银行借款（70%）10,929.38自有资金（30%）4,684.00折折旧旧及及摊摊销销测测算算：

总额总额残值率Year1Year1Year2Year2Year3Year3Year4Year4Year5Year5Year6Year6Year7Year7Year8Year8Year9Year9Year10Year10前期费用-13,812.3712,661.37-固定资产（20年）5,695.03284.75270.51270.51270.51270.51270.51270.51270.51270.51270.51270.51固定资产（10年）9,268.35463.42880.49880.49880.49880.49880.49880.49880.49880.49880.49880.49小计14,963.38748.171,151.011,151.011,151.011,151.011,151.011,151.011,151.011,151.011,151.011,151.01年计提折旧1,151.011,151.011,151.011,151.011,151.011,151.011,151.011,151.011,151.011,151.01累计折旧与摊销1,151.012,302.013,453.024,604.035,755.046,906.048,057.059,208.0610,359.0711,510.07合合计计14,963.38748.17科科目目品品类类项项目目说说明明比比率率Year1Year1Year2Year2Year3Year3Year4Year4Year5Year5Year6Year6Year7Year7Year8Year8Year9Year9Year10Year10收收入入测测算算：

1、1台发电机11111111112、年运行时间1,0001,0001,0001,0001,0001,0001,0001,0001,0001,0003、年发电量（万KM.H）1,0001,0001,0001,0001,0001,0001,0001,0001,0001,0004、上网售电量（万KW.H）850.00850.00850.00850.00850.00850.00850.00850.00850.00850.005、上网电价0.750.750.750.750.750.750.750.750.750.756、年售电金额（含税）637.50637.50637.50637.50637.50637.50637.50637.50637.50637.507、年售电金额（不含税）544.87544.87544.87544.87544.87544.87544.87544.87544.87544.878、售电增值税收入92.6392.6392.6392.6392.6392.6392.6392.6392.6392.639、暖气供应（万平方米）40.0040.0040.0040.0040.0040.0040.0040.0040.0040.0010、年单价40.0040.0040.0040.0040.0040.0040.0040.0040.0040.0011、供暖气含税收入1,600.001,600.001,600.001,600.001,600.001,600.001,600.001,600.001,600.001,600.0012、供暖气不含税收入1,415.931,415.931,415.931,415.931,415.931,415.931,415.931,415.931,415.931,415.9313、供暖增值税收入184.07184.07184.07184.07184.07184.07184.07184.07184.07184.07不含税收入小计：

1,960.801,960.801,960.801,960.801,960.801,960.801,960.801,960.801,960.801,960.80返还的增值税收入：

276.70276.70276.70276.70276.70276.70276.70276.70276.70276.70售价增长：

销项税额276.70276.70276.70276.70276.70276.70276.70276.70276.70276.70进项税额-000000000应交增值税276.70276.70276.70276.70276.70276.70276.70276.70276.70276.70城建税7%19.3719.3719.3719.3719.3719.3719.3719.3719.3719.37教育费附加3%8.308.308.308.308.308.308.308.308.308.30堤围防护费0.13%主营业务税金及附加：

27.6727.6727.6727.6727.6727.6727.6727.6727.6727.67成成本本测测算算：

变变动动成成本本部部分分:

1、树枝及桔杆燃料数量（万吨）11111111112、薯渣及牛粪燃料数量（万吨）11111111113、树枝及桔杆燃料单价（到厂价）100.00100.00100.00100.00100.00100.00100.00100.00100.00100.004、薯渣及牛粪燃料单价（到厂价）100.00100.00100.00100.00100.00100.00100.00125.00125.00125.005、燃料成本（万元）200.00200.00200.00200.00200.00200.00200.00225.00225.00225.006、其他管理费用（按工资的30%计算）0.300.320.330.350.360.380.400.420.440.477、油料、水资源费、药品等1.001.001.001.001.001.001.001.001.001.008、银行借款利息（按5.94%）560.11367.06159.1627.60-变变动动成成本本小小计计：

#REF!

761.41568.37360.49228.95201.36201.38201.40226.42226.44226.47平平均均单单位位变变动动成成本本（元元/Kwh）/Kwh）：

0.760.760.570.570.360.360.230.230.200.200.200.200.200.200.230.230.230.230.230.23固固定定成成本本部部分分：

1、工资及福利费用1.001.051.101.161.221.281.341.411.481.552、机器维护费用1.001.001.001.00500.001.001.001.001.00500.003、折旧与摊销1,151.011,151.011,151.011,151.011,151.011,151.011,151.011,151.011,151.011,151.014、房产税（1.001.001.001.001.001.001.001.001.001.005、城镇土地使用税1.001.001.001.001.001.001.001.001.001.00固固定定成成本本小小计计：

1,155.011,155.061,155.111,155.161,654.221,155.281,155.351,155.411,155.481,654.56平平均均单单位位固固定定成成本本（元元/Kwh）/Kwh）：

1.161.161.161.161.161.161.161.161.651.651.161.161.161.161.161.161.161.161.651.65平平均均单单位位成成本本（元元/Kwh）/Kwh）：

1.921.921.721.721.521.521.381.381.861.861.361.361.361.361.381.381.381.381.881.88成成本本小小计计：

1,916.411,723.431,515.601,384.111,855.591,356.671,356.751,381.841,381.931,881.02毛毛利利润润：

16.72209.70417.54549.0277.54576.46576.38551.29551.2052.11毛毛利利率率：

0.85%10.69%21.29%28.00%3.95%29.40%29.40%28.12%28.11%2.66%control:

-诚亚节能项目营运费用测算表项项目目收收入入占占比比Year1Year1Year2Year2Year3Year3Year4Year4Year5Year5Year6Year6Year7Year7Year8Year8Year9Year9Year10Year10营营运运费费用用1、燃料成本（万元）200.00200.00200.00200.00200.00200.00200.00200.00200.00200.002、其他管理费用0.300.320.330.350.360.380.400.420.440.473、工资及福利费用（60人）1.001.051.101.161.221.281.341.411.481.554、机器维护费用1.001.001.001.00500.001.001.001.001.00500.005、折旧与摊销（元）1,151.011,151.011,151.011,151.011,151.011,151.011,151.011,151.011,151.011,151.016、银行借款利息560.11367.06159.1627.60-7、油料、水资源费、药品1.001.001.001.001.001.001.001.001.001.008、房产税（余值的1.2%）1.001.001.001.001.001.001.001.001.001.009、城镇土地使用税（4元/平方米）1.001.001.001.001.001.001.001.001.001.00营营运运费费用用合合计计：

1,916.411,723.431,515.601,384.111,855.591,356.671,356.751,356.841,356.931,856.02其中：

折旧与摊销1,151.011,151.011,151.011,151.011,151.011,151.011,151.011,151.011,151.011,151.01付付现现费费用用合合计计：

765.41572.42364.59233.11704.58205.66205.74205.83205.92705.02付付现现费费用用占占比比：

39.94%33.21%24.06%16.84%37.97%15.16%15.16%15.17%15.18%37.99%银行错款10,929.387,929.384,429.38929.38-本本期期偿偿还还3,000.003,500.003,500.00929.38-银银行行错错款款余余额额7,929.384,429.38929.38-本期利息5.94%560.11367.06159.1627.60-项目投资现金流量分析表项项目目Year0Year0Year1Year1Year2Year2Year3Year3现现金金流流出出项项目目:

一一、前前期期投投资资期期：

1、固定资金投资14,627.382、流动资金投资650.00二、运营期：

1、燃料成本（万元）200.00200.00200.002、其他管理费用2.302.322.333、工资及福利费用（60人）1.001.051.104、机器维护费用1.001.001.005、油料、水资源费、药品1.00100.00100.006、流转税27.6727.6727.67现金流出小计：

15,277.38232.97332.03332.10现金流入项目:

1、年售电金额（不含税）-544.87544.87544.872、供暖气收入（不含税）-1,415.931,415.931,415.933、返还的增值税收入276.70276.70276.704、收回的流动资金现金流入小计：

-2,237.502,237.502,237.50所得税前净现金流量:

-15,277.382,004.531,905.471,905.40累计所得税前净现金流量:

-15,277.38-13,272.85-11,367.38-9,461.99折折现现率率（6%6%）0.94340.89000.83960.7921所得税前折现净现金流量-14,412.681,784.031,599.831,509.26所得税前折现净现金流量累计-14,412.68-12,628.65-11,028.82-9,519.56企业所得税-所得税后净现金流量-15,277.382,004.531,905.471,905.40税得税后累计净现金流量-15,277.38-13,272.85-11,367.38-9,461.99折现所得税后净现金流量-14,412.681,784.031,599.831,509.26折现税得税后累计净现金流量-14,412.68-12,628.65-11,028.82-9,519.56项项目目财财务务指指标标：

11、财财务务内内部部收收益益率率（所所得得税税前前）-2.57%-2.57%22、财财务务内内部部收收益益率率（所所得得税税后后）-3.56%-3.56%33、财财务务净净现现值值（所所得得税税前前）-1,751.99-1,751.9944、财财务务净净现现值值（所所得得税税后后）-2,346.48-2,346.4855、动动态态收收资资回回收收期期（所所得得税税前前）9.699.6966、动动态态投投资资回回收收期期（所所得得税税后后）10.0710.07Year4Year4Year5Year5Year6Year6Year7Year7Year8Year8Year9Year9Year10Year10200.00200.00200.00200.00225.00225.00225.002.352.362.382.402.422.442.471.161.221.281.341.411.481.551.00500.001.001.001.001.00500.00100.00100.00100.00100.00100.00100.00100.0027.6727.6727.6727.6727.6727.6727.67332.17831.25332.33332.41357.50357.59856.69544.87544.87544.87544.87544.87544.87544.871,415.931,415.931,415.931,415.931,415.931,415.931,415.93276.70276.70276.70276.70276.70276.70276.702,237.502,237.502,237.502,237.502,237.502,237.502,237.501,905.331,406.251,905.171,905.091,880.001,879.911,380.81-7,556.66-6,150.41-4,245.24-2,340.15-460.151,419.762,800.570.74730.70500.66510.62740.59190.55840.52681,423.85991.411,267.131,195.251,112.771,049.74727.41-8,095.71-7,104.30-5,837.17-4,641.92-3,529.15-2,479.40-1,751.99103.2144.28106.65213.27207.00206.9882.201,802.111,361.971,798.531,691.821,673.001,672.931,298.61-7,659.88-6,297.91-4,499.38-2,807.56-1,134.56538.371,836.981,346.72960.191,196.201,061.45990.25934.17684.11-8,172.84-7,212.65-6,016.45-4,955.00-3,964.75-3,030.59-2,346.4830%资本金现金流量分析表（市场利率6.9%和贷款比例70%）项项目目Year0Year0Year1Year1现现金金流流出出项项目目:

1、项目投资4,684.00二、运营期：

1、燃料成本（万元）200.002、其他管理费用2.303、工资及福利费用（60人）1.004、机器维护费用1.005、借款利息650.636、油料、水资源费、药品1.007、流转税27.678、企业所得税-9、偿还借款3,000.00现金流出小计：

4,684.003,883.60现金流入项目:

1、年售电金额（不含税）-544.872、供暖气收入（不含税）-1,415.933、返还的增值税收入276.704、收回的流动资金现金流入小计：

-2,237.50所得税后净现金流量-4,684.00-1,646.1