流动资金估算表及公式

45678910111流动资产6144.28571.779380.969380.969380.969380.969380.969380.961.1应收账款30121531.262070.722250.542250.542250.542250.542250.542250.541.2存货4443.776331.886961.256961.256961.256961.256961.256961.251.2.1原材料6061574.852362.272624.752624.752624.752624.752624.752624.751.2.2燃料606582.99874.49971.65971.65971.65971.65971.65971.651.2.3在产品572244.25334.16364.13364.13364.13364.13364.13364.131.2.4产成品4092041.682760.963000.723000.723000.723000.723000.723000.721.2.5其他1.3现金1524169.17169.17169.17169.17169.17169.17169.17169.172流动负债1078.921618.381798.21798.21798.21798.21798.21798.22.1应付账款30121078.921618.381798.21798.21798.21798.21798.21798.23流动资金（1-2）5065.286953.397582.767582.767582.767582.767582.767582.764流动资金本年增加额5065.281888.11629.37序号项目最低周转天数周转次数黄色区域已经有公式生成周转次数=360/最低需要周转天数扩大指标估算法年流动资金额=年费用基数x各类流动资金率附表3流动资金估算表单位：万元投产期达产期其他材料=年其他材料费用/其他材料周转次数流动资金=流动资产—流动负债预付账款=外购商品或服务年费用金额/预付账款周转次数预收账款=预收的营业收入年金额/预收账款周转次121314151617189380.969380.969380.969380.969380.969380.969380.962250.542250.542250.542250.542250.542250.542250.546961.256961.256961.256961.256961.256961.256961.252624.752624.752624.752624.752624.752624.752624.75971.65971.65971.65971.65971.65971.65971.65364.13364.13364.13364.13364.13364.13364.133000.723000.723000.723000.723000.723000.723000.72169.17169.17169.17169.17169.17169.17169.171798.21798.21798.21798.21798.21798.21798.21798.21798.21798.21798.21798.21798.21798.27582.767582.767582.767582.767582.767582.767582.76外购原材料、燃料=年外购原材料、燃料费用/周转次数在产品=（年外购原材料燃料及动力费+年工资及福利费+年修理费+年其他制造费用）/周转次数产成品=（年经营成本-年其他营业费用）/产成品周转次数=（年外购原材料+燃料动力+备品备件费用）/周转次数现金=（年工资及福利费用+年其他费用）/周转次数流动负债=应付账款+预收账款应付账款=(外购原材料+燃料动力费+其他材料年费用)/应付账款周转次数流动资金本年增加额=本年流动资金—上年流动资金附表3流动资金估算表单位：万元达产期流动资产=应收账款+预付账款+存货+库存现金应收（预付）账款=年经营成本/周转次数存货=外购原材料、燃料+其他材料+在产品+产成品外购原材料、燃料=年外购原材料、燃料费用/周转次数在产品=（年外购原材料燃料及动力费+年工资及福利费+年修理费+年其他制造费用）/周转次数产成品=（年经营成本-年其他营业费用）/产成品周转次数=（年外购原材料+燃料动力+备品备件费用）/周转次数现金=（年工资及福利费用+年其他费用）/周转次数流动负债=应付账款+预收账款应付账款=(外购原材料+燃料动力费+其他材料年费用)/应付账款周转次数流动资金本年增加额=本年流动资金—上年流动资金流动资产=应收账款+预付账款+存货+库存现金应收（预付）账款=年经营成本/周转次数存货=外购原材料、燃料+其他材料+在产品+产成品