Cash Budget Worksheet
LINE Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
1 Forecasted Sales
2 Forecasted Purchases
3 Beginning Cash
4 Cash Collections
5 Accounts Receivable Collections
6 Total Cash Available (L3+L4+L5)
7 Accounts Payable
8 Operating Expenses
9 Principal Repayment: Long Term Debt
10 Total Cash Outflows (L7+L8+L9)
11 Cash Flow from Operations (L6-L10)
12 Capital Expenditures
13 New Long Term Debt
14 Cash Surplus of (Deficit) (L11-L12+L13)
15 Short Term Loan or (Repayment)
16 Ending Cash (L14+L15)
17 Cumulative Short-Term Borrowings
This worksheet is provided for your convenience only.
There is no guarantee of its accuracy.
Neither the publisher nor distributor is in the business
of rendering legal, accounting or professional services.
It is recommended that you consult your professional
advisors regarding your individual situation.