Instructions
Instructions
Instructions
1st quarter
2nd quarter
Purchase of equipment (2nd quarter)
Sale of equipment (1st quarter)
Collections from clients:
1st quarter
2nd quarter
Interest payments (2nd quarter)
Instructions
Prepare a cash budget for each of the first two quarters of 2011.
$ 30,000 CASH BUDGET
25,000 1st Quarter
4,000 Beginning Cash Balance $ 30,000
add: Receipts
140,000 Collection from clients $ 230,000
140,000 Sale of Equipment $ 15,000
5,000 Interest on Investments $ -
Total Receipts $ 245,000
75,000
100,000 Total Cash available $ 275,000
less: payments
Professional salaries $ 140,000
50,000 Overhead costs $ 75,000
70,000 Selling and administrative Costs $ 47,000
50,000 Purchase of Equipment $ -
15,000 Payment of Income taxes $ -
Total Payments $ 262,000
230,000
380,000 Excess/Deficiency $ 13,000
300
Borrowings $ 12,000
Repayments $ -
($ 12,000 principal add $ 300 interest)
Ending Cash Balance $ 25,000
2nd Quarter
$ 25,000
$ 380,000
$ -
$ 5,000
$ 385,000
$ 410,000
$ 140,000
$ 100,000
$ 67,000
$ 50,000
$ 4,000
$ 361,000
$ 49,000
$ -
$ 12,300
$ 36,700