用Excel和现金流量表计算投资项目财务指标.xls

1、投投资资项项目目财财务务现现金金流流量量表表（新新建建项项目目）单位：万元序号 项 目计算期（年）0123456789101生产负荷（%）50.00100.00100.0021.现金流入-7,285.008,540.008,216.009,114.009,653.0011,289.0011,444.0014,370.0015,276.0018,417.0031.1.产品销售收入5,920.007,252.006,890.007,925.008,321.009,869.0010,006.0012,890.0013,542.0015,840.0041.2.回收固定资产余值25.0010.003.0

2、021.0033.0054.0029.0032.0056.0077.0051.3.回收流动资金1,340.001,278.001,323.001,168.001,299.001,366.001,409.001,448.001,678.002,500.0061.4.其他现金流入72.现金流出12,032.006,465.006,300.005,813.006,745.007,076.006,666.007,227.008,023.0011,159.0012,506.0082.1.固定资产投资10,769.00367.00445.00340.0092.2.流动资金500.00600.00700.0

3、0480.00670.00380.00543.00890.00998.00690.001,203.00102.3.经营成本763.005,218.004,890.005,008.005,698.006,005.005,932.005,990.006,709.009,980.0010,987.00112.4.销售税金及附加67.0067.0069.0056.0031.0045.0039.0087.0054.0087.00122.5.所得税213.00198.00256.00321.00320.00146.00308.00229.00435.00229.00132.6.增值税142.7.其他现金流

4、出153.净现金流量-12,032.00820.002,240.002,403.002,369.002,577.004,623.004,217.006,347.004,117.005,911.00164.累计净现金流量-12,032.00-11,212.00-8,972.00-6,569.00-4,200.00-1,623.003,000.007,217.0013,564.0017,681.0023,592.0017-8.31E-05-8.92E-05-1.11E-04-1.52E-04-2.38E-04-6.16E-043.33E-041.39E-047.37E-055.66E-054.24

5、E-0518 计算指标：19项目财务内部收益率（%）19.499120项目财务净现值（ic=%）2,880.7644指定ic=15.000021项目投资回收期 （年）5.5419.49912,880.764463.00E+031623 说明：1、有颜色底纹栏已设置好公式（内部数据勿删），当在无颜色栏手工录入基础数据后，有颜色底纹栏内数据会自动计算生成。2、计算期小于10年，可从第N列向前删除若干列；大于10年，可在第N列后增加若干列，仿前设计表格仍可用。投投资资项项目目财财务务现现金金流流量量表表（新新建建项项目目）单位：万元序号 项 目计算期（年）012341 生产负荷（%）50.002 1

6、.现金流入-7,285.008,540.008,216.009,114.003 1.1.产品销售收入5,920.007,252.006,890.007,925.004 1.2.回收固定资产余值25.0010.003.0021.005 1.3.回收流动资金1,340.001,278.001,323.001,168.006 1.4.其他现金流入7 2.现金流出12,032.006,465.006,300.005,813.006,745.008 2.1.固定资产投资10,769.00367.00445.009 2.2.流动资金500.00600.00700.00480.00670.0010 2.3.

7、经营成本763.005,218.004,890.005,008.005,698.0011 2.4.销售税金及附加67.0067.0069.0056.0012 2.5.所得税213.00198.00256.00321.0013 2.6.增值税14 2.7.其他现金流出15 3.净现金流量-12,032.00820.002,240.002,403.002,369.0016 4.累计净现金流量-12,032.00-11,212.00-8,972.00-6,569.00-4,200.0018 计算指标：19项目财务内部收益率（%）19.499120项目财务净现值（ic=%）2,880.7644指定ic

8、=15.000021项目投资回收期 （年）5.54 说明：有颜色底纹栏已设置好公式（内部数据勿删），当在无颜色栏手工录入基础数据后，有颜色底纹栏内数据会自动计算生成。第 3 页，共 6 页56789101112100.00100.009,653.0011,289.0011,444.0014,370.0015,276.0018,417.00-8,321.009,869.0010,006.0012,890.0013,542.0015,840.0033.0054.0029.0032.0056.0077.001,299.001,366.001,409.001,448.001,678.002,500.0

9、07,076.006,666.007,227.008,023.0011,159.0012,506.00-340.00380.00543.00890.00998.00690.001,203.006,005.005,932.005,990.006,709.009,980.0010,987.0031.0045.0039.0087.0054.0087.00320.00146.00308.00229.00435.00229.002,577.004,623.004,217.006,347.004,117.005,911.00-1,623.003,000.007,217.0013,564.0017,681.0023,592.0023,592.0023,592.00第 4 页，共 6 页1314151617181920-23,592.0023,592.0023,592.0023,592.0023,592.0023,592.0023,592.0023,592.00第 5 页，共 6 页第 6 页，共 6 页