流動(dòng)資金缺口測(cè)算表

1、流動(dòng)資金缺口測(cè)算表單單位位：萬(wàn)萬(wàn)元元用用款款企企業(yè)業(yè)應(yīng)應(yīng)收收款款項(xiàng)項(xiàng)預(yù)預(yù)付付賬賬款款存存貨貨流流動(dòng)動(dòng)資資產(chǎn)產(chǎn)累累計(jì)計(jì)折折舊舊總總資資產(chǎn)產(chǎn)應(yīng)應(yīng)付付款款項(xiàng)項(xiàng)預(yù)預(yù)收收賬賬款款流流動(dòng)動(dòng)負(fù)負(fù)債債總總負(fù)負(fù)債債銷銷售售收收入入銷銷售售成成本本利利潤(rùn)潤(rùn)總總額額凈凈利利潤(rùn)潤(rùn)現(xiàn)現(xiàn)有有銀銀行行短短期期貸貸款款申申貸貸金金額額流流動(dòng)動(dòng)資資金金缺缺口口資資產(chǎn)產(chǎn)負(fù)負(fù)債債率率XXXXXX公公司司200920090 0#DIV/0!#DIV/0!20102010201120112012.22012.2涂涂黃黃區(qū)區(qū)域域?yàn)闉槿比笨诳跍y(cè)測(cè)算算關(guān)關(guān)聯(lián)聯(lián)數(shù)數(shù)據(jù)據(jù)區(qū)區(qū)域域, ,填填寫寫數(shù)數(shù)據(jù)據(jù)后后流流動(dòng)動(dòng)資資金金缺缺口口將將自自動(dòng)動(dòng)生生

2、成成，流流動(dòng)動(dòng)資資金金缺缺口口需需大大于于申申貸貸金金額額 資金缺口測(cè)算表中應(yīng)收、應(yīng)付款項(xiàng)取應(yīng)收、應(yīng)付賬款與應(yīng)收、應(yīng)付票據(jù)的合計(jì)數(shù)，企業(yè)自有流動(dòng)資金不能為負(fù)數(shù)，如為負(fù)數(shù)則按0取值。流流動(dòng)動(dòng)資資金金缺缺口口分分析析表表用用款款企企業(yè)業(yè)上上年年流流動(dòng)動(dòng)資資產(chǎn)產(chǎn)周周轉(zhuǎn)轉(zhuǎn)率率測(cè)測(cè)算算未未來(lái)來(lái)一一年年流流動(dòng)動(dòng)資資金金缺缺口口測(cè)測(cè)算算年年初初存存貨貨 年年末末存存貨貨年年初初應(yīng)應(yīng)付付款款項(xiàng)項(xiàng)年年末末應(yīng)應(yīng)付付款款項(xiàng)項(xiàng)年年初初預(yù)預(yù)付付賬賬款款年年末末預(yù)預(yù)付付賬賬款款年年銷銷售售成成本本存存貨貨周周轉(zhuǎn)轉(zhuǎn)天天數(shù)數(shù)應(yīng)應(yīng)付付款款項(xiàng)項(xiàng)周周轉(zhuǎn)轉(zhuǎn)天天數(shù)數(shù)預(yù)預(yù)付付款款項(xiàng)項(xiàng)周周轉(zhuǎn)轉(zhuǎn)天天數(shù)數(shù)年年初初應(yīng)應(yīng)收收款款項(xiàng)項(xiàng)年年末末應(yīng)應(yīng)收收款款項(xiàng)項(xiàng)年年初初預(yù)預(yù)收收帳帳款款年年末末預(yù)預(yù)收收帳帳款款年年銷銷售售收收入入應(yīng)應(yīng)收收款款項(xiàng)項(xiàng)周周轉(zhuǎn)轉(zhuǎn)天天數(shù)數(shù)預(yù)預(yù)收收帳帳款款周周轉(zhuǎn)轉(zhuǎn)天天數(shù)數(shù)上上年年度度利利潤(rùn)潤(rùn)總總額額上上年年度度銷銷售售利利潤(rùn)潤(rùn)率率預(yù)預(yù)測(cè)測(cè)銷銷售售收收入入增增長(zhǎng)長(zhǎng)率率XXX公司00000000.000.000.00000000.000.000#DIV/0!10%單位：萬(wàn)元預(yù)預(yù)測(cè)測(cè)銷銷售售收收入入營(yíng)營(yíng)運(yùn)運(yùn)資資金金周周轉(zhuǎn)轉(zhuǎn)次次數(shù)數(shù)流流動(dòng)動(dòng)資資金金需需求求量量公公司司自自有有流流動(dòng)動(dòng)資資金金公公司司現(xiàn)現(xiàn)有有銀銀行行短短貸貸其其他他渠渠道道的的營(yíng)營(yíng)運(yùn)運(yùn)資資金金流流動(dòng)動(dòng)資資金金缺缺口口0.000.000.000.000