,流動(dòng)資金需求測(cè)算表,,,,,,,,,0

,銷售收入（萬(wàn)元）,"9,996.00",銷售成本（萬(wàn)元）,"8,110.00",預(yù)計(jì)增長(zhǎng)率,30%,銷售利潤(rùn)率,1.80%,,0

,存貨,,應(yīng)收賬款,萬(wàn)元,應(yīng)付賬款,萬(wàn)元,預(yù)付賬款,萬(wàn)元,預(yù)收賬款,萬(wàn)元

,年初,232.00,年初,"5,210.00",年初,"5,182.00",年初,"3,077.00",年初,188.00

,年末,"1,381.00",年末,"3,618.00",年末,"4,628.00",年末,"2,433.00",年末,49.00

,平均存貨,806.50,平均應(yīng)收,"4,414.00",平均應(yīng)付,"4,905.00",平均預(yù)付,"2,755.00",平均預(yù)收,65.61

,存貨周轉(zhuǎn)天數(shù),35.80,應(yīng)收周轉(zhuǎn)天數(shù),158.97,應(yīng)付周轉(zhuǎn)天數(shù),217.73,預(yù)付周轉(zhuǎn)天數(shù),122.29,預(yù)收周轉(zhuǎn)天數(shù),2.36

,營(yíng)運(yùn)資金需求,"3,437.19",自有資金量,"2,944.00",現(xiàn)有流貸,0.00,融資需求,493.19,營(yíng)運(yùn)資金周轉(zhuǎn)次數(shù),3.71

,本表格只需要填寫淺藍(lán)色格，黃色白色框數(shù)據(jù)自動(dòng)生成。,,,,,,,,,

,本表中應(yīng)收賬款不計(jì)應(yīng)收票據(jù)、其他應(yīng)收款，應(yīng)付賬款不計(jì)應(yīng)付票據(jù)、其他應(yīng)付款,,,,,,,,,

,營(yíng)運(yùn)資金量＝上年度銷售收入×（1－上年度銷售利潤(rùn)率）×（1＋預(yù)計(jì)銷售收入年增長(zhǎng)率）/營(yíng)運(yùn)資金周轉(zhuǎn)次數(shù),,,,,,,,,

,營(yíng)運(yùn)資金周轉(zhuǎn)次數(shù)＝360/(存貨周轉(zhuǎn)天數(shù)+應(yīng)收賬款周轉(zhuǎn)天數(shù)－應(yīng)付賬款周轉(zhuǎn)天數(shù)＋預(yù)付賬款周轉(zhuǎn)天數(shù)－預(yù)收賬款周轉(zhuǎn)天數(shù)),,,,,,,,,

,,流動(dòng)資金需求測(cè)算表,,,,,,,,

,,銷售收入（萬(wàn)元）,"9,996.00",年利潤(rùn)率,1.80%,,,,,

,,銷售成本（萬(wàn)元）,"8,110.00",預(yù)計(jì)增長(zhǎng)率,30.00%,,,,,

,,存貨（年初）,232.00,存貨周轉(zhuǎn)天數(shù)（天）,35.8002,,,,,

,,存貨（年末）,"1,381.00",（+）應(yīng)收賬款周轉(zhuǎn)天數(shù),158.9676,,,,,

,,應(yīng)收賬款（年初）,"5,210.00",（-）應(yīng)付賬款周轉(zhuǎn)天數(shù),217.7312,,,,,

,,應(yīng)收賬款（年末）,"3,618.00",（+）預(yù)付賬款周轉(zhuǎn)天數(shù),122.2935,,,,,

,,應(yīng)付賬款（年初）,"5,182.00",（-）預(yù)收賬款周轉(zhuǎn)天數(shù),2.3629,,,,,

,,應(yīng)付賬款（年末）,"4,628.00",營(yíng)運(yùn)資金周轉(zhuǎn)天數(shù),96.9672,,,,,

,,預(yù)付賬款（年初）,"3,077.00",營(yíng)運(yùn)資金需求量（萬(wàn)元）,"3,437.19",,,,,

,,預(yù)付賬款（年末）,"2,433.00",自有資金,"2,944.00",,,,,

,,預(yù)收賬款（年初）,188.00,現(xiàn)有借款,0.00,,,,,

,,預(yù)收賬款（年末）,49.00,融資需求（萬(wàn)元）,493.19,,,,,

,自有資金,借款人自由流動(dòng)資金=貨幣資金＋短期投資＋應(yīng)收票據(jù)＋預(yù)付賬款＋存貨＋應(yīng)收賬款-流動(dòng)負(fù)債,,,,,（我行貨押打分卡中公式）,,,

,,,,,,,,,,,

,,自有資金=上年未分配利潤(rùn)+本期凈利潤(rùn)+折舊-本期資本性支出-應(yīng)付股利-到期銀行借款或其他借款（結(jié)果為負(fù)值則取零）,,,,,,（銀監(jiān)會(huì)案例提供）,,

,,,,,,,,,,,

,,借款人自有流動(dòng)資金=所有者權(quán)益-固定資產(chǎn)占用-無(wú)形遞延資產(chǎn)占用-長(zhǎng)期投資占用,,,,,（銀聯(lián)信分析機(jī)構(gòu)提供）,,,

,,,,,,,,,,,

,,借款人自有流動(dòng)資金=流動(dòng)資產(chǎn)-流動(dòng)負(fù)債-長(zhǎng)期性債務(wù)形成的流動(dòng)資產(chǎn)+短貸長(zhǎng)用部分,,,,,（銀聯(lián)信分析機(jī)構(gòu)提供）,,,

,,,,,,,,,,,

,,借款人自有流動(dòng)資金=貨幣資金-受限貨幣資金-貸