| |
B-3 Completed Cash Budget
ABC Company Cash Budget July-September 1993
| |
July |
August |
September |
| |
|
|
|
| Cash Receipts |
|
|
|
| Cash Sales |
$ 20,000 |
$ 15,000 |
$ 18,000 |
| Accounts Receivable |
78,750 |
142,500 |
126,000 |
| Investment Income |
100 |
100 |
|
| Investment Maturities |
20,000 |
20,000 |
|
| Sale of Fixed Assets |
|
5,000 |
|
| |
_______________ |
_______________ |
_______________ |
| Total Receipts |
$ 118,850 |
$ 182,600 |
$ 144,000 |
| |
|
|
|
| Cash Disbursements |
|
|
|
| Purchases-Inventory |
$ 69,350 |
$ 227,100 |
$ 46,000 |
| General Payables |
20,000 |
24,000 |
20,000 |
| Payroll (incl. taxes) |
22,000 |
25,000 |
23,000 |
| Taxes (Income) |
|
|
10,000 |
| Debt Repayment |
|
|
10,000 |
| Purchase of Fixed Assets |
|
|
|
| Investment Purchases |
10,000 |
|
|
| Other |
|
|
|
| |
_______________ |
_______________ |
_______________ |
| Total Disbursement |
$ 121,350 |
$ 276,100 |
$ 109,000 |
| |
|
|
|
| Recap: |
|
|
|
| Beginning Cash |
$ 71,000 |
$ 68,500 |
$ ( 25,000) |
| Add: Total Receipts |
118,850 |
182,600 |
144,000 |
| Less: |
|
|
|
| Total Disbursments |
121,350 |
276,100 |
109,000 |
| |
|
|
|
| Ending Cash |
68,500 |
(25,000) |
10,000 |
| Less: Minimum Cash |
(37,500) |
(37,500) |
(37,500) |
| |
_______________ |
_______________ |
_______________ |
| Available Cash |
$ 31,000 |
$ (62,500) |
$ (27,500) |
|