某铜矿现金流量计算表Word.doc

某铜矿现金流量计算表序号项目合计基建期（年）生 产 期 （年）01234567891011121314Ⅰ矿石产量（万吨）2385.949.579.299999999999999999999Ⅱ现金流入（万元）销售收入75704.611570.6352513.0163141.273141.273141.273141.273141.273141.273141.273141.273141.273141.27流动资金回流800固定资产残值160合计76664.611570.6352513.0163141.273141.273141.273141.273141.273141.273141.273141.273141.273141.27Ⅲ现金流出（万元）基建投资-4640-1040-2000-1600流动资金占用-800-400-400经营费-38770.9-804.375-1287-1608.75-1608.75-1608.75-1608.75-1608.75-1608.75-1608.75-1608.75-1608.75-1608.75维简费上缴-2385.9-49.5-79.2-99-99-99-99-99-99-99-99-99-99正常设备更新费-700-50-50-50-50-50-50-50产品税-2271.14-47.1191-75.3905-94.2381-94.2381-94.2381-94.2381-94.2381-94.2381-94.2381-94.2381-94.2381-94.2381合计-49567.9-1040-2000-2000-1300.99-1441.59-1801.99-1801.99-1801.99-1851.99-1851.99-1851.99-1851.99-1851.99-1851.99-1851.99Ⅳ净现金（万元）流量-1040-2000-2000269.6411071.4261339.2821339.2821339.2821289.2821289.2821289.2821289.2821289.2821289.2821289.282合计27096.69-1040-3040-5040-4770.36-3698.93-2359.65-1020.37318.91221608.1942897.4764186.7585476.046765.3228054.6049343.885Ⅴ贴现值计算i=19%贴现系数10.8403360.7061650.5934160.4986690.4190490.3521420.2959180.2486710.2089670.1756020.1475650.1240040.1042050.087567贴现值-62.7277-1040-1680.67-1412.33160.0092534.2864561.2252471.6178396.3175320.6064269.4171226.401190.2529159.8764134.3499112.8991i=18%贴现系数10.8474580.7181840.6086310.5157890.4371090.3704320.3139250.2660380.2254560.1910640.1619190.137220.1162880.098549贴现值214.7267-1040-1694.92-1436.37164.1118552.6294585.4125496.1123420.4341342.9982290.6764246.336208.7593176.9147149.9277127.0573Ⅵ企业内部收益收益率 某铜矿现金流量计算表（续上表）序号项目1516171819202122232425262728Ⅰ矿石产量999999999999999999999979.259.439.6Ⅱ现金流入（万元）销售收入3141.273141.273141.273141.273141.273141.273141.273141.273141.273141.273141.272513.0161884.7621256.508流动资金回流固定资产残值合计3141.273141.273141.273141.273141.273141.273141.273141.273141.273141.273141.272513.0161884.7621256.508Ⅲ现金流出（万元）基建投资流动资金占用经营费-1608.75-1608.75-1608.75-1608.75-1608.75-1608.75-1608.75-1608.75-1608.75-1608.75-1608.75-1287-965.25-643.5维简费上缴-99-99-99-99-99-99-99-99-99-99-99-79.2-59.4-39.6正常设备更新费-50-50-50-50-50-50-50产品税-94.2381-94.2381-94.2381-94.2381-94.2381-94.2381-94.2381-94.2381-94.2381-94.2381-94.2381-75.3905-56.5429-37.6952合计-1851.99-1851.99-1851.99-1851.99-1851.99-1851.99-1851.99-1801.99-1801.99-1801.99-1801.99-1441.59-1081.19-720.795Ⅳ净现金（万元）流量1289.2821289.2821289.2821289.2821289.2821289.2821289.2821339.2821339.2821339.2821339.2821071.426803.5691535.7128合计10633.1711922.4513211.7314501.0115790.2917079.5818368.8619708.1421047.4222386.723725.9924797.4125600.9826136.69Ⅴ贴现值计算i=19%贴现系数0.0735860.0618370.0519640.0436670.0366950.0308360.0259130.0217750.0182990.0153770.0129220.0108590.0091250.007668贴现值94.8731879.7253666.996156.2992547.3102939.7565533.4088629.1634524.507120.594217.3060511.634327.3325544.107874i=18%贴现系数0.0835160.0707760.059980.050830.0430770.0365060.0309370.0262180.0222180.0188290.0159570.0135230.011460.009712贴现值107.675791.2506177.3310265.5347755.5379447.0660539.8864835.1129929.7567725.217621.3708514.488719.2089275.202784 （注：文件素材和资料部分来自网络，供参考。

请预览后才下载，期待你的好评与关注。