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

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

《用Excel和现金流量表计算投资项目财务指标.xls》由会员分享，可在线阅读，更多相关《用Excel和现金流量表计算投资项目财务指标.xls（6页珍藏版）》请在冰点文库上搜索。

投投资资项项目目财财务务现现金金流流量量表表（新新建建项项目目）单位：

万元序号项目计算期（年）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.0021.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.00480.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.其他现金流出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.24E-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.0021.现金流入-7,285.008,540.008,216.009,114.0031.1.产品销售收入5,920.007,252.006,890.007,925.0041.2.回收固定资产余值25.0010.003.0021.0051.3.回收流动资金1,340.001,278.001,323.001,168.0061.4.其他现金流入72.现金流出12,032.006,465.006,300.005,813.006,745.0082.1.固定资产投资10,769.00367.00445.0092.2.流动资金500.00600.00700.00480.00670.00102.3.经营成本763.005,218.004,890.005,008.005,698.00112.4.销售税金及附加67.0067.0069.0056.00122.5.所得税213.00198.00256.00321.00132.6.增值税142.7.其他现金流出153.净现金流量-12,032.00820.002,240.002,403.002,369.00164.累计净现金流量-12,032.00-11,212.00-8,972.00-6,569.00-4,200.0018计算指标：

19项目财务内部收益率（%）19.499120项目财务净现值（ic=%）2,880.7644指定ic=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.007,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页