用Excel和现金流量表计算投资项目财务指标表格文件下载.xls
- 文档编号:13945227
- 上传时间:2022-10-15
- 格式:XLS
- 页数:6
- 大小:34KB
用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页
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- Excel 现金流 量表 计算 投资 项目 财务指标
![提示](https://static.bdocx.com/images/bang_tan.gif)