流动资金估算表及公式.xls

流动资金估算表及公式.xls

《流动资金估算表及公式.xls》由会员分享，可在线阅读，更多相关《流动资金估算表及公式.xls（5页珍藏版）》请在冰点文库上搜索。

附附表表3流流动动资资金金估估算算表表单位：

万元序号项目最低周转天数周转次数投产期达产期456789101流动资产6144.28571.779380.969380.969380.969380.969380.961.1应收账款30121531.262070.722250.542250.542250.542250.542250.541.2存货4443.776331.886961.256961.256961.256961.256961.251.2.1原材料6061574.852362.272624.752624.752624.752624.752624.751.2.2燃料606582.99874.49971.65971.65971.65971.65971.651.2.3在产品572244.25334.16364.13364.13364.13364.13364.131.2.4产成品4092041.682760.963000.723000.723000.723000.723000.721.2.5其他1.3现金1524169.17169.17169.17169.17169.17169.17169.172流动负债1078.921618.381798.21798.21798.21798.21798.22.1应付账款30121078.921618.381798.21798.21798.21798.21798.23流动资金（1-2）5065.286953.397582.767582.767582.767582.767582.764流动资金本年增加额5065.281888.11629.37黄色区域已经有公式生成周转次数=360/最低需要周转天数扩大指标估算法年流动资金额=年费用基数x各类流动资金率流动资金=流动资产流动负债预付账款=外购商品或服务年费用金额/预付账款周转次数预收账款=预收的营业收入年金额/预收账款周转次其他材料=年其他材料费用/其他材料周转次数11121314151617189380.969380.969380.969380.969380.969380.969380.969380.96流动资产=应收账款+预付账款+存货+库存现金2250.542250.542250.542250.542250.542250.542250.542250.54应收（预付）账款=年经营成本/周转次数6961.256961.256961.256961.256961.256961.256961.256961.25存货=外购原材料、燃料+其他材料+在产品+产成品2624.752624.752624.752624.752624.752624.752624.752624.75外购原材料、燃料=年外购原材料、燃料费用/周转次数971.65971.65971.65971.65971.65971.65971.65971.65364.13364.13364.13364.13364.13364.13364.13364.13在产品=（年外购原材料燃料及动力费+年工资及福利费+年修理费+年其他制造费用）/周转次数3000.723000.723000.723000.723000.723000.723000.723000.72产成品=（年经营成本-年其他营业费用）/产成品周转次数=（年外购原材料+燃料动力+备品备件费用）/周转次数169.17169.17169.17169.17169.17169.17169.17169.17现金=（年工资及福利费用+年其他费用）/周转次数1798.21798.21798.21798.21798.21798.21798.21798.2流动负债=应付账款+预收账款1798.21798.21798.21798.21798.21798.21798.21798.2应付账款=（外购原材料+燃料动力费+其他材料年费用）/应付账款周转次数7582.767582.767582.767582.767582.767582.767582.767582.76流动资金本年增加额=本年流动资金上年流动资金达产期流动资产=应收账款+预付账款+存货+库存现金应收（预付）账款=年经营成本/周转次数存货=外购原材料、燃料+其他材料+在产品+产成品外购原材料、燃料=年外购原材料、燃料费用/周转次数在产品=（年外购原材料燃料及动力费+年工资及福利费+年修理费+年其他制造费用）/周转次数产成品=（年经营成本-年其他营业费用）/产成品周转次数=（年外购原材料+燃料动力+备品备件费用）/周转次数现金=（年工资及福利费用+年其他费用）/周转次数流动负债=应付账款+预收账款应付账款=（外购原材料+燃料动力费+其他材料年费用）/应付账款周转次数流动资金本年增加额=本年流动资金上年流动资金