流动资金贷款需求量测算计算表

需求量测算项目万元、%数据来源上年度销售收入3,478.00利润表3,100.00上年度销售利润556.00利润表390.00上年度销售利润率0.16公式计算0.13至今年上月末销售收入2,800.00利润表3,100.00预计今年销售收入4,500.00预测数5,000.00预计销售收入年增长率0.29公式计算0.61上年度期初应收账款204.00资产负债表77.00上年度期末应收账款345.00资产负债表250.00上年度期初预收账款0.00资产负债表0.00上年度期末预收账款0.00资产负债表0.00上年度期初预付账款8.00资产负债表0.00上年度期末预付账款15.00资产负债表0.00上年度期初应付账款245.00资产负债表0.00上年度期末应付账款285.00资产负债表20.00上年度期初存货156.00资产负债表210.00上年度期末存货445.00资产负债表350.00上年度销售收入3,478.00利润表3,100.00上年度销售成本2,913.00利润表2,710.00应收账款周转次数=销售收入/（（期初应收账款+期末应收账款）/2）12.67公式计算18.96预收账款周转次数=销售收入/（（期初预收账款+期末预收账款）/2）0.00公式计算0.00预付账款周转次数=销售成本/（（期初预付账款+期末预付账款）/2）0.00公式计算0.00应付账款周转次数=销售成本/（（期初应付账款+期末应付账款）/2）10.99公式计算271.00存货周转次数=销售成本/（（期初存货+期末存货）/2）9.69公式计算9.68应收账款周转天数=360/应收账款周转次数28.41公式计算18.99预收账款周转天数=360/预收账款周转次数0.00公式计算预付账款周转天数=360/预付账款周转次数0.00公式计算应付账款周转天数=360/应付账款周转次数32.75公式计算1.33存货周转天数=360/存货周转次数37.14公式计算37.20营运资金周转次数=360/（存货周转天数+应收账款周转天数-应付账款周转天数+预付账款周转天数-预收账款周转天数)10.98公式计算6.56营运资金量=上年度销售收入×（1-上年度销售利润率）×（1+预计销售收入年增长率）/营运资金周转次数344.46公式计算666.02借款人自有资金0.00结合实际测算借款人现有流动资金贷款0.00资产负债表500.00其他渠道提供的营运资金资产负债表新增流动资金贷款额度=营运资金量-借款人自有资金-现有流动资金贷款-其他渠道提供的营运资金344.46公式计算166.02流动资金贷款需求量测算计算表企业名称：松阳县盛昌木制品厂注：1、如无销售收入、销售成本、销售利润数据可由利润表中主营业务收入、主营业务成本、主营业务利润代替；2、如应收账款、预收账款、预付账款、应付账款、存货期初期末数据均为0，周转次数一栏中直接输入0.3,100.003,100.003,200.003,200.003,200.003,300.003,300.003,300.00420.00450.00390.00420.00450.00390.00420.00450.000.140.150.120.130.140.120.130.143,200.003,300.003,100.003,200.003,300.003,100.003,200.003,300.005,000.005,000.005,000.005,000.005,000.005,000.005,000.005,000.000.610.610.560.560.560.520.520.5277.0077.0077.0077.0077.0077.0077.0077.00350.00450.00250.00300.00400.00250.00300.00350.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.0040.0010.0010.0020.0010.0020.0090.00180.00210.00210.00210.00210.00210.00210.00210.00210.00400.00450.00360.00420.00470.00380.00420.00490.003,100.003,100.003,200.003,200.003,200.003,300.003,300.003,300.002,680.002,650.002,810.002,780.002,750.002,910.002,880.002,850.0014.5211.7619.5716.9813.4220.1817.5115.460.000.000.000.000.000.000.000.000.000.000.000.000.000.000.000.00134.00530.00562.00278.00550.00291.0064.0031.678.798.039.868.838.099.869.148.1424.7930.6018.3921.2126.8317.8420.5623.292.690.680.641.290.651.245.6311.3740.9744.8336.5140.7944.5136.4939.3844.215.714.826.635.935.096.786.636.41757.38887.50661.83732.44843.69650.27658.35673.31500.00500.00500.00500.00500.00500.00500.00500.00257.38387.50161.83232.44343.69150.27158.35173.31