Fill online: Thirteen-week cash-flow forecast and twelve-month working-capital workbook

Try the first few blanks free and watch the document fill in on the right. Pay, and the whole document opens here to finish and download in Word and PDF.

0 of 403 blanks filled

Leave a blank empty and it stays highlighted in your document, to fill by hand. Your answers are saved in this browser only.

Try the first 5 blanks free. After payment the whole document opens here: every blank, and clean Word and PDF downloads.

Your details

Name of the client

Fills 2 places in the document.

Name of the firm

Forecast start date

Fills 2 places in the document.

Forecast version number

Fills 2 places in the document.

Name of the preparer

Fills 3 places in the document.

Name of the approver

Customer threshold for individual forecasting in Rs

Day of the weekly forecast

Variance threshold for explanation in Rs

Opening cash and bank balance in Rs

Minimum cash buffer in Rs

Sanctioned limit in Rs

Margin on paid stock

Margin on book debts

Eligibility period for book debts in days

Days after which stock is ineligible

Collection period in days

Supplier credit period in days

Salary payment day

Monthly / Quarterly (QRMP)

Interest rate on cash credit

Collections from debtors: Wk 1 (Rs)

Collections from debtors: Wk 2 (Rs)

Collections from debtors: Wk 3 (Rs)

Collections from debtors: Wk 4 (Rs)

Collections from debtors: Wk 5 (Rs)

Collections from debtors: Wk 6 (Rs)

Collections from debtors: Wk 7 (Rs)

Collections from debtors: Wk 8 (Rs)

Collections from debtors: Wk 9 (Rs)

Collections from debtors: Wk 10 (Rs)

Collections from debtors: Wk 11 (Rs)

Collections from debtors: Wk 12 (Rs)

Collections from debtors: Wk 13 (Rs)

Cash sales and gateway or marketplace: Wk 1 (Rs)

Cash sales and gateway or marketplace: Wk 2 (Rs)

Cash sales and gateway or marketplace: Wk 3 (Rs)

Cash sales and gateway or marketplace: Wk 4 (Rs)

Cash sales and gateway or marketplace: Wk 5 (Rs)

Cash sales and gateway or marketplace: Wk 6 (Rs)

Cash sales and gateway or marketplace: Wk 7 (Rs)

Cash sales and gateway or marketplace: Wk 8 (Rs)

Cash sales and gateway or marketplace: Wk 9 (Rs)

Cash sales and gateway or marketplace: Wk 10 (Rs)

Cash sales and gateway or marketplace: Wk 11 (Rs)

Cash sales and gateway or marketplace: Wk 12 (Rs)

Cash sales and gateway or marketplace: Wk 13 (Rs)

Other income: interest, rent, scrap: Wk 1 (Rs)

Other income: interest, rent, scrap: Wk 2 (Rs)

Other income: interest, rent, scrap: Wk 3 (Rs)

Other income: interest, rent, scrap: Wk 4 (Rs)

Other income: interest, rent, scrap: Wk 5 (Rs)

Other income: interest, rent, scrap: Wk 6 (Rs)

Other income: interest, rent, scrap: Wk 7 (Rs)

Other income: interest, rent, scrap: Wk 8 (Rs)

Other income: interest, rent, scrap: Wk 9 (Rs)

Other income: interest, rent, scrap: Wk 10 (Rs)

Other income: interest, rent, scrap: Wk 11 (Rs)

Other income: interest, rent, scrap: Wk 12 (Rs)

Other income: interest, rent, scrap: Wk 13 (Rs)

GST and income-tax refunds: Wk 1 (Rs)

GST and income-tax refunds: Wk 2 (Rs)

GST and income-tax refunds: Wk 3 (Rs)

GST and income-tax refunds: Wk 4 (Rs)

GST and income-tax refunds: Wk 5 (Rs)

GST and income-tax refunds: Wk 6 (Rs)

GST and income-tax refunds: Wk 7 (Rs)

GST and income-tax refunds: Wk 8 (Rs)

GST and income-tax refunds: Wk 9 (Rs)

GST and income-tax refunds: Wk 10 (Rs)

GST and income-tax refunds: Wk 11 (Rs)

GST and income-tax refunds: Wk 12 (Rs)

GST and income-tax refunds: Wk 13 (Rs)

Loans drawn: term loan, unsecured loans: Wk 1 (Rs)

Loans drawn: term loan, unsecured loans: Wk 2 (Rs)

Loans drawn: term loan, unsecured loans: Wk 3 (Rs)

Loans drawn: term loan, unsecured loans: Wk 4 (Rs)

Loans drawn: term loan, unsecured loans: Wk 5 (Rs)

Loans drawn: term loan, unsecured loans: Wk 6 (Rs)

Loans drawn: term loan, unsecured loans: Wk 7 (Rs)

Loans drawn: term loan, unsecured loans: Wk 8 (Rs)

Loans drawn: term loan, unsecured loans: Wk 9 (Rs)

Loans drawn: term loan, unsecured loans: Wk 10 (Rs)

Loans drawn: term loan, unsecured loans: Wk 11 (Rs)

Loans drawn: term loan, unsecured loans: Wk 12 (Rs)

Loans drawn: term loan, unsecured loans: Wk 13 (Rs)

Equity or capital introduced: Wk 1 (Rs)

Equity or capital introduced: Wk 2 (Rs)

Equity or capital introduced: Wk 3 (Rs)

Equity or capital introduced: Wk 4 (Rs)

Equity or capital introduced: Wk 5 (Rs)

Equity or capital introduced: Wk 6 (Rs)

Equity or capital introduced: Wk 7 (Rs)

Equity or capital introduced: Wk 8 (Rs)

Equity or capital introduced: Wk 9 (Rs)

Equity or capital introduced: Wk 10 (Rs)

Equity or capital introduced: Wk 11 (Rs)

Equity or capital introduced: Wk 12 (Rs)

Equity or capital introduced: Wk 13 (Rs)

Suppliers of goods and services: Wk 1 (Rs)

Suppliers of goods and services: Wk 2 (Rs)

Suppliers of goods and services: Wk 3 (Rs)

Suppliers of goods and services: Wk 4 (Rs)

Suppliers of goods and services: Wk 5 (Rs)

Suppliers of goods and services: Wk 6 (Rs)

Suppliers of goods and services: Wk 7 (Rs)

Suppliers of goods and services: Wk 8 (Rs)

Suppliers of goods and services: Wk 9 (Rs)

Suppliers of goods and services: Wk 10 (Rs)

Suppliers of goods and services: Wk 11 (Rs)

Suppliers of goods and services: Wk 12 (Rs)

Suppliers of goods and services: Wk 13 (Rs)

Salaries and wages (net pay): Wk 1 (Rs)

Salaries and wages (net pay): Wk 2 (Rs)

Salaries and wages (net pay): Wk 3 (Rs)

Salaries and wages (net pay): Wk 4 (Rs)

Salaries and wages (net pay): Wk 5 (Rs)

Salaries and wages (net pay): Wk 6 (Rs)

Salaries and wages (net pay): Wk 7 (Rs)

Salaries and wages (net pay): Wk 8 (Rs)

Salaries and wages (net pay): Wk 9 (Rs)

Salaries and wages (net pay): Wk 10 (Rs)

Salaries and wages (net pay): Wk 11 (Rs)

Salaries and wages (net pay): Wk 12 (Rs)

Salaries and wages (net pay): Wk 13 (Rs)

Rent and premises: Wk 1 (Rs)

Rent and premises: Wk 2 (Rs)

Rent and premises: Wk 3 (Rs)

Rent and premises: Wk 4 (Rs)

Rent and premises: Wk 5 (Rs)

Rent and premises: Wk 6 (Rs)

Rent and premises: Wk 7 (Rs)

Rent and premises: Wk 8 (Rs)

Rent and premises: Wk 9 (Rs)

Rent and premises: Wk 10 (Rs)

Rent and premises: Wk 11 (Rs)

Rent and premises: Wk 12 (Rs)

Rent and premises: Wk 13 (Rs)

GST paid in cash: Wk 1 (Rs)

GST paid in cash: Wk 2 (Rs)

GST paid in cash: Wk 3 (Rs)

GST paid in cash: Wk 4 (Rs)

GST paid in cash: Wk 5 (Rs)

GST paid in cash: Wk 6 (Rs)

GST paid in cash: Wk 7 (Rs)

GST paid in cash: Wk 8 (Rs)

GST paid in cash: Wk 9 (Rs)

GST paid in cash: Wk 10 (Rs)

GST paid in cash: Wk 11 (Rs)

GST paid in cash: Wk 12 (Rs)

GST paid in cash: Wk 13 (Rs)

TDS and TCS deposited: Wk 1 (Rs)

TDS and TCS deposited: Wk 2 (Rs)

TDS and TCS deposited: Wk 3 (Rs)

TDS and TCS deposited: Wk 4 (Rs)

TDS and TCS deposited: Wk 5 (Rs)

TDS and TCS deposited: Wk 6 (Rs)

TDS and TCS deposited: Wk 7 (Rs)

TDS and TCS deposited: Wk 8 (Rs)

TDS and TCS deposited: Wk 9 (Rs)

TDS and TCS deposited: Wk 10 (Rs)

TDS and TCS deposited: Wk 11 (Rs)

TDS and TCS deposited: Wk 12 (Rs)

TDS and TCS deposited: Wk 13 (Rs)

PF, ESI, professional tax and labour welfare: Wk 1 (Rs)

PF, ESI, professional tax and labour welfare: Wk 2 (Rs)

PF, ESI, professional tax and labour welfare: Wk 3 (Rs)

PF, ESI, professional tax and labour welfare: Wk 4 (Rs)

PF, ESI, professional tax and labour welfare: Wk 5 (Rs)

PF, ESI, professional tax and labour welfare: Wk 6 (Rs)

PF, ESI, professional tax and labour welfare: Wk 7 (Rs)

PF, ESI, professional tax and labour welfare: Wk 8 (Rs)

PF, ESI, professional tax and labour welfare: Wk 9 (Rs)

PF, ESI, professional tax and labour welfare: Wk 10 (Rs)

PF, ESI, professional tax and labour welfare: Wk 11 (Rs)

PF, ESI, professional tax and labour welfare: Wk 12 (Rs)

PF, ESI, professional tax and labour welfare: Wk 13 (Rs)

Loan EMIs and interest: Wk 1 (Rs)

Loan EMIs and interest: Wk 2 (Rs)

Loan EMIs and interest: Wk 3 (Rs)

Loan EMIs and interest: Wk 4 (Rs)

Loan EMIs and interest: Wk 5 (Rs)

Loan EMIs and interest: Wk 6 (Rs)

Loan EMIs and interest: Wk 7 (Rs)

Loan EMIs and interest: Wk 8 (Rs)

Loan EMIs and interest: Wk 9 (Rs)

Loan EMIs and interest: Wk 10 (Rs)

Loan EMIs and interest: Wk 11 (Rs)

Loan EMIs and interest: Wk 12 (Rs)

Loan EMIs and interest: Wk 13 (Rs)

Capital expenditure: Wk 1 (Rs)

Capital expenditure: Wk 2 (Rs)

Capital expenditure: Wk 3 (Rs)

Capital expenditure: Wk 4 (Rs)

Capital expenditure: Wk 5 (Rs)

Capital expenditure: Wk 6 (Rs)

Capital expenditure: Wk 7 (Rs)

Capital expenditure: Wk 8 (Rs)

Capital expenditure: Wk 9 (Rs)

Capital expenditure: Wk 10 (Rs)

Capital expenditure: Wk 11 (Rs)

Capital expenditure: Wk 12 (Rs)

Capital expenditure: Wk 13 (Rs)

Advance tax and other taxes: Wk 1 (Rs)

Advance tax and other taxes: Wk 2 (Rs)

Advance tax and other taxes: Wk 3 (Rs)

Advance tax and other taxes: Wk 4 (Rs)

Advance tax and other taxes: Wk 5 (Rs)

Advance tax and other taxes: Wk 6 (Rs)

Advance tax and other taxes: Wk 7 (Rs)

Advance tax and other taxes: Wk 8 (Rs)

Advance tax and other taxes: Wk 9 (Rs)

Advance tax and other taxes: Wk 10 (Rs)

Advance tax and other taxes: Wk 11 (Rs)

Advance tax and other taxes: Wk 12 (Rs)

Advance tax and other taxes: Wk 13 (Rs)

Other payments: Wk 1 (Rs)

Other payments: Wk 2 (Rs)

Other payments: Wk 3 (Rs)

Other payments: Wk 4 (Rs)

Other payments: Wk 5 (Rs)

Other payments: Wk 6 (Rs)

Other payments: Wk 7 (Rs)

Other payments: Wk 8 (Rs)

Other payments: Wk 9 (Rs)

Other payments: Wk 10 (Rs)

Other payments: Wk 11 (Rs)

Other payments: Wk 12 (Rs)

Other payments: Wk 13 (Rs)

Undrawn cash-credit or overdraft available: Wk 1 (Rs)

Undrawn cash-credit or overdraft available: Wk 2 (Rs)

Undrawn cash-credit or overdraft available: Wk 3 (Rs)

Undrawn cash-credit or overdraft available: Wk 4 (Rs)

Undrawn cash-credit or overdraft available: Wk 5 (Rs)

Undrawn cash-credit or overdraft available: Wk 6 (Rs)

Undrawn cash-credit or overdraft available: Wk 7 (Rs)

Undrawn cash-credit or overdraft available: Wk 8 (Rs)

Undrawn cash-credit or overdraft available: Wk 9 (Rs)

Undrawn cash-credit or overdraft available: Wk 10 (Rs)

Undrawn cash-credit or overdraft available: Wk 11 (Rs)

Undrawn cash-credit or overdraft available: Wk 12 (Rs)

Undrawn cash-credit or overdraft available: Wk 13 (Rs)

Collections from debtors: Actual, week 1 (Rs)

Timing / Permanent (1)

Collections from debtors: Explanation

Other receipts: Actual, week 1 (Rs)

Timing / Permanent (2)

Other receipts: Explanation

Suppliers of goods and services: Actual, week 1 (Rs)

Timing / Permanent (3)

Suppliers of goods and services: Explanation

Salaries and wages: Actual, week 1 (Rs)

Timing / Permanent (4)

Salaries and wages: Explanation

GST, TDS, PF, ESI and advance tax: Actual, week 1 (Rs)

Timing / Permanent (5)

GST, TDS, PF, ESI and advance tax: Explanation

Loan EMIs and interest: Actual, week 1 (Rs)

Timing / Permanent (6)

Loan EMIs and interest: Explanation

Capital expenditure: Actual, week 1 (Rs)

Timing / Permanent (7)

Capital expenditure: Explanation

Rent and other payments: Actual, week 1 (Rs)

Timing / Permanent (8)

Rent and other payments: Explanation

Closing cash and bank balance (per bank): Actual, week 1 (Rs)

Month ending date of the first month

Credit sales incl. GST (Rs), row 1

Cost of goods sold (Rs), row 1

Credit purchases incl. GST (Rs), row 1

Closing trade receivables (Rs), row 1

Closing inventory (Rs), row 1

Closing trade payables (Rs), row 1

=IF(ISNUMBER(A2),EOMONTH(A2,1),""): Credit sales incl. GST (Rs)

=IF(ISNUMBER(A2),EOMONTH(A2,1),""): Cost of goods sold (Rs)

=IF(ISNUMBER(A2),EOMONTH(A2,1),""): Credit purchases incl. GST (Rs)

=IF(ISNUMBER(A2),EOMONTH(A2,1),""): Closing trade receivables (Rs)

=IF(ISNUMBER(A2),EOMONTH(A2,1),""): Closing inventory (Rs)

=IF(ISNUMBER(A2),EOMONTH(A2,1),""): Closing trade payables (Rs)

=IF(ISNUMBER(A3),EOMONTH(A3,1),""): Credit sales incl. GST (Rs)

=IF(ISNUMBER(A3),EOMONTH(A3,1),""): Cost of goods sold (Rs)

=IF(ISNUMBER(A3),EOMONTH(A3,1),""): Credit purchases incl. GST (Rs)

=IF(ISNUMBER(A3),EOMONTH(A3,1),""): Closing trade receivables (Rs)

=IF(ISNUMBER(A3),EOMONTH(A3,1),""): Closing inventory (Rs)

=IF(ISNUMBER(A3),EOMONTH(A3,1),""): Closing trade payables (Rs)

=IF(ISNUMBER(A4),EOMONTH(A4,1),""): Credit sales incl. GST (Rs)

=IF(ISNUMBER(A4),EOMONTH(A4,1),""): Cost of goods sold (Rs)

=IF(ISNUMBER(A4),EOMONTH(A4,1),""): Credit purchases incl. GST (Rs)

=IF(ISNUMBER(A4),EOMONTH(A4,1),""): Closing trade receivables (Rs)

=IF(ISNUMBER(A4),EOMONTH(A4,1),""): Closing inventory (Rs)

=IF(ISNUMBER(A4),EOMONTH(A4,1),""): Closing trade payables (Rs)

=IF(ISNUMBER(A5),EOMONTH(A5,1),""): Credit sales incl. GST (Rs)

=IF(ISNUMBER(A5),EOMONTH(A5,1),""): Cost of goods sold (Rs)

=IF(ISNUMBER(A5),EOMONTH(A5,1),""): Credit purchases incl. GST (Rs)

=IF(ISNUMBER(A5),EOMONTH(A5,1),""): Closing trade receivables (Rs)

=IF(ISNUMBER(A5),EOMONTH(A5,1),""): Closing inventory (Rs)

=IF(ISNUMBER(A5),EOMONTH(A5,1),""): Closing trade payables (Rs)

=IF(ISNUMBER(A6),EOMONTH(A6,1),""): Credit sales incl. GST (Rs)

=IF(ISNUMBER(A6),EOMONTH(A6,1),""): Cost of goods sold (Rs)

=IF(ISNUMBER(A6),EOMONTH(A6,1),""): Credit purchases incl. GST (Rs)

=IF(ISNUMBER(A6),EOMONTH(A6,1),""): Closing trade receivables (Rs)

=IF(ISNUMBER(A6),EOMONTH(A6,1),""): Closing inventory (Rs)

=IF(ISNUMBER(A6),EOMONTH(A6,1),""): Closing trade payables (Rs)

=IF(ISNUMBER(A7),EOMONTH(A7,1),""): Credit sales incl. GST (Rs)

=IF(ISNUMBER(A7),EOMONTH(A7,1),""): Cost of goods sold (Rs)

=IF(ISNUMBER(A7),EOMONTH(A7,1),""): Credit purchases incl. GST (Rs)

=IF(ISNUMBER(A7),EOMONTH(A7,1),""): Closing trade receivables (Rs)

=IF(ISNUMBER(A7),EOMONTH(A7,1),""): Closing inventory (Rs)

=IF(ISNUMBER(A7),EOMONTH(A7,1),""): Closing trade payables (Rs)

=IF(ISNUMBER(A8),EOMONTH(A8,1),""): Credit sales incl. GST (Rs)

=IF(ISNUMBER(A8),EOMONTH(A8,1),""): Cost of goods sold (Rs)

=IF(ISNUMBER(A8),EOMONTH(A8,1),""): Credit purchases incl. GST (Rs)

=IF(ISNUMBER(A8),EOMONTH(A8,1),""): Closing trade receivables (Rs)

=IF(ISNUMBER(A8),EOMONTH(A8,1),""): Closing inventory (Rs)

=IF(ISNUMBER(A8),EOMONTH(A8,1),""): Closing trade payables (Rs)

=IF(ISNUMBER(A9),EOMONTH(A9,1),""): Credit sales incl. GST (Rs)

=IF(ISNUMBER(A9),EOMONTH(A9,1),""): Cost of goods sold (Rs)

=IF(ISNUMBER(A9),EOMONTH(A9,1),""): Credit purchases incl. GST (Rs)

=IF(ISNUMBER(A9),EOMONTH(A9,1),""): Closing trade receivables (Rs)

=IF(ISNUMBER(A9),EOMONTH(A9,1),""): Closing inventory (Rs)

=IF(ISNUMBER(A9),EOMONTH(A9,1),""): Closing trade payables (Rs)

=IF(ISNUMBER(A10),EOMONTH(A10,1),""): Credit sales incl. GST (Rs)

=IF(ISNUMBER(A10),EOMONTH(A10,1),""): Cost of goods sold (Rs)

=IF(ISNUMBER(A10),EOMONTH(A10,1),""): Credit purchases incl. GST (Rs)

=IF(ISNUMBER(A10),EOMONTH(A10,1),""): Closing trade receivables (Rs)

=IF(ISNUMBER(A10),EOMONTH(A10,1),""): Closing inventory (Rs)

=IF(ISNUMBER(A10),EOMONTH(A10,1),""): Closing trade payables (Rs)

=IF(ISNUMBER(A11),EOMONTH(A11,1),""): Credit sales incl. GST (Rs)

=IF(ISNUMBER(A11),EOMONTH(A11,1),""): Cost of goods sold (Rs)

=IF(ISNUMBER(A11),EOMONTH(A11,1),""): Credit purchases incl. GST (Rs)

=IF(ISNUMBER(A11),EOMONTH(A11,1),""): Closing trade receivables (Rs)

=IF(ISNUMBER(A11),EOMONTH(A11,1),""): Closing inventory (Rs)

=IF(ISNUMBER(A11),EOMONTH(A11,1),""): Closing trade payables (Rs)

=IF(ISNUMBER(A12),EOMONTH(A12,1),""): Credit sales incl. GST (Rs)

=IF(ISNUMBER(A12),EOMONTH(A12,1),""): Cost of goods sold (Rs)

=IF(ISNUMBER(A12),EOMONTH(A12,1),""): Credit purchases incl. GST (Rs)

=IF(ISNUMBER(A12),EOMONTH(A12,1),""): Closing trade receivables (Rs)

=IF(ISNUMBER(A12),EOMONTH(A12,1),""): Closing inventory (Rs)

=IF(ISNUMBER(A12),EOMONTH(A12,1),""): Closing trade payables (Rs)

=IF(ISNUMBER('Working capital'!A2),'Working: Ineligible stock (Rs)

=IF(ISNUMBER('Working capital'!A2),'Working: Creditors for goods (Rs)

=IF(ISNUMBER('Working capital'!A2),'Working: Book debts within eligibility (Rs)

=IF(ISNUMBER('Working capital'!A2),'Working: Ineligible debts within that period (Rs)

=IF(ISNUMBER('Working capital'!A2),'Working: Outstanding in the account (Rs)

=IF(ISNUMBER('Working capital'!A3),'Working: Ineligible stock (Rs)

=IF(ISNUMBER('Working capital'!A3),'Working: Creditors for goods (Rs)

=IF(ISNUMBER('Working capital'!A3),'Working: Book debts within eligibility (Rs)

=IF(ISNUMBER('Working capital'!A3),'Working: Ineligible debts within that period (Rs)

=IF(ISNUMBER('Working capital'!A3),'Working: Outstanding in the account (Rs)

=IF(ISNUMBER('Working capital'!A4),'Working: Ineligible stock (Rs)

=IF(ISNUMBER('Working capital'!A4),'Working: Creditors for goods (Rs)

=IF(ISNUMBER('Working capital'!A4),'Working: Book debts within eligibility (Rs)

=IF(ISNUMBER('Working capital'!A4),'Working: Ineligible debts within that period (Rs)

=IF(ISNUMBER('Working capital'!A4),'Working: Outstanding in the account (Rs)

=IF(ISNUMBER('Working capital'!A5),'Working: Ineligible stock (Rs)

=IF(ISNUMBER('Working capital'!A5),'Working: Creditors for goods (Rs)

=IF(ISNUMBER('Working capital'!A5),'Working: Book debts within eligibility (Rs)

=IF(ISNUMBER('Working capital'!A5),'Working: Ineligible debts within that period (Rs)

=IF(ISNUMBER('Working capital'!A5),'Working: Outstanding in the account (Rs)

=IF(ISNUMBER('Working capital'!A6),'Working: Ineligible stock (Rs)

=IF(ISNUMBER('Working capital'!A6),'Working: Creditors for goods (Rs)

=IF(ISNUMBER('Working capital'!A6),'Working: Book debts within eligibility (Rs)

=IF(ISNUMBER('Working capital'!A6),'Working: Ineligible debts within that period (Rs)

=IF(ISNUMBER('Working capital'!A6),'Working: Outstanding in the account (Rs)

=IF(ISNUMBER('Working capital'!A7),'Working: Ineligible stock (Rs)

=IF(ISNUMBER('Working capital'!A7),'Working: Creditors for goods (Rs)

=IF(ISNUMBER('Working capital'!A7),'Working: Book debts within eligibility (Rs)

=IF(ISNUMBER('Working capital'!A7),'Working: Ineligible debts within that period (Rs)

=IF(ISNUMBER('Working capital'!A7),'Working: Outstanding in the account (Rs)

=IF(ISNUMBER('Working capital'!A8),'Working: Ineligible stock (Rs)

=IF(ISNUMBER('Working capital'!A8),'Working: Creditors for goods (Rs)

=IF(ISNUMBER('Working capital'!A8),'Working: Book debts within eligibility (Rs)

=IF(ISNUMBER('Working capital'!A8),'Working: Ineligible debts within that period (Rs)

=IF(ISNUMBER('Working capital'!A8),'Working: Outstanding in the account (Rs)

=IF(ISNUMBER('Working capital'!A9),'Working: Ineligible stock (Rs)

=IF(ISNUMBER('Working capital'!A9),'Working: Creditors for goods (Rs)

=IF(ISNUMBER('Working capital'!A9),'Working: Book debts within eligibility (Rs)

=IF(ISNUMBER('Working capital'!A9),'Working: Ineligible debts within that period (Rs)

=IF(ISNUMBER('Working capital'!A9),'Working: Outstanding in the account (Rs)

=IF(ISNUMBER('Working capital'!A10),'Working: Ineligible stock (Rs)

=IF(ISNUMBER('Working capital'!A10),'Working: Creditors for goods (Rs)

=IF(ISNUMBER('Working capital'!A10),'Working: Book debts within eligibility (Rs)

=IF(ISNUMBER('Working capital'!A10),'Working: Ineligible debts within that period (Rs)

=IF(ISNUMBER('Working capital'!A10),'Working: Outstanding in the account (Rs)

=IF(ISNUMBER('Working capital'!A11),'Working: Ineligible stock (Rs)

=IF(ISNUMBER('Working capital'!A11),'Working: Creditors for goods (Rs)

=IF(ISNUMBER('Working capital'!A11),'Working: Book debts within eligibility (Rs)

=IF(ISNUMBER('Working capital'!A11),'Working: Ineligible debts within that period (Rs)

=IF(ISNUMBER('Working capital'!A11),'Working: Outstanding in the account (Rs)

=IF(ISNUMBER('Working capital'!A12),'Working: Ineligible stock (Rs)

=IF(ISNUMBER('Working capital'!A12),'Working: Creditors for goods (Rs)

=IF(ISNUMBER('Working capital'!A12),'Working: Book debts within eligibility (Rs)

=IF(ISNUMBER('Working capital'!A12),'Working: Ineligible debts within that period (Rs)

=IF(ISNUMBER('Working capital'!A12),'Working: Outstanding in the account (Rs)

=IF(ISNUMBER('Working capital'!A13),'Working: Ineligible stock (Rs)

=IF(ISNUMBER('Working capital'!A13),'Working: Creditors for goods (Rs)

=IF(ISNUMBER('Working capital'!A13),'Working: Book debts within eligibility (Rs)

=IF(ISNUMBER('Working capital'!A13),'Working: Ineligible debts within that period (Rs)

=IF(ISNUMBER('Working capital'!A13),'Working: Outstanding in the account (Rs)

Date of preparation

Designation of the approver

Date of approval

[Name of the client] · prepared by [Name of the firm]

THIRTEEN-WEEK CASH-FLOW FORECAST AND WORKING-CAPITAL WORKBOOK

Forecast start: [Forecast start date] · Version: [Forecast version number] · Prepared by: [Name of the preparer] · Approved by: [Name of the approver]

This is management's forecast, prepared with the firm's help. It is not an examination of prospective financial information under SAE 3400, and it must leave the company over a member of management's name, not the firm's.

What the workbook does

The workbook answers three questions every week: will the company have enough cash in each of the next thirteen weeks, where is the working capital tied up, and how much can be drawn on the cash-credit limit. It has six sheets. Assumptions holds every input that is not a weekly figure. Week calendar turns the start date into thirteen weeks and marks the weeks in which TDS, PF and ESI, GST, month-end payments and advance tax fall due. 13-week cash flow is the forecast itself. Weekly variance compares last week's forecast with what happened. Working capital computes debtor, inventory and creditor days and the cash conversion cycle for twelve months. Drawing power computes the drawing power under the cash-credit limit from the same month-end figures.

Method

1. Start from cash, not profit. The forecast uses the direct method: actual receipts and actual payments, week by week. Opening cash is the sum of the reconciled bank balances of every account on the start date, taken from the Bank reconciliation statement (FV06-E3), plus cash in hand. A drawn cash credit or overdraft is entered as a negative balance. Deposits under lien and margin money are excluded, because they cannot be spent.

The rest of this format (31 more paragraphs and tables) opens here after payment, to fill in the same way.

₹199 + GST, for the finished document, Word and PDF

The short sample is the opening of the document with your details, marked SAMPLE.

A drafted format for your use. It is not legal advice; for a complex matter, consult a professional. About this format