资金缺口,测算公式

销售收入59,355,295.4900上年利润总额8,951,117.63应收账款期初数上年度销售利润率0.2498应收账款期末数1.0000上年度销售收入35,829,950.65平均应收账款0.5000本期销售收入(月)8560031.3应收账款周转率118,710,590.9800上期销售收入(月)7441000销售收入59,355,295.4900预计销售收入年增长率0.150387219预收账款期初数81,456,242.0000营运资金需求127,957,183.37预收账款期末数211,703,214.6500平均预收账款146,579,728.3250预收账款周转率0.4049销售成本39,688,264.4700自由资金1,810,499.23存货期初数62,380,323.0400现有流动资金贷款7,000,000.00存货期末数82,812,572.5800其他渠道提供资金0.00平均存货72,596,447.8100存货周转率0.5467最终流动资金贷款额度119,146,684.14销售成本39,688,264.4700预付账款期初数169,438,003.7400预付账款期末数215,671,877.7600平均预付账款192,554,940.7500预付账款周转率0.2061销售成本39,688,264.4700应付账款期初数5,805,000.0000应付账款期末数0.0000平均应付账款2,902,500.0000应付账款周转率13.6738应收账款周转率118,710,590.9800存货周转率0.5467预付账款周转率0.2061预收账款周转率0.4049应付账款周转率13.6738应收账款周转天数0.0000存货周转天数658.5000预付账款周转天数1,746.6064应付账款周转天数26.3277预收账款周转天数889.0311营运资金周转次数0.2417