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

1、流動(dòng)資金缺口測(cè)算表單單位位：萬萬元元用用款款企企業(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ù)債債銷銷售售收收入入銷銷售售成成本本利利潤潤總總額額凈凈利利潤潤現(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è)算算未未來來一一年年流流動(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ù)上上年年度度利利潤潤總總額額上上年年度度銷銷售售利利潤潤率率預(yù)預(yù)測(cè)測(cè)銷銷售售收收入入增增長長率率XXX公司00000000.000.000.00000000.000.000#DIV/0!10%單位：萬元預(yù)預(yù)測(cè)測(cè)銷銷售售收收入入營營運(yùn)運(yùn)資資金金周周轉(zhuǎn)轉(zhuǎn)次次數(shù)數(shù)流流動(dòng)動(dòng)資資金金需需求求量量公公司司自自有有流流動(dòng)動(dòng)資資金金公公司司現(xiàn)現(xiàn)有有銀銀行行短短貸貸其其他他渠渠道道的的營營運(yùn)運(yùn)資資金金流流動(dòng)動(dòng)資資金金缺缺口口0.000.000.000.000