Instructions

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 3

E9-19 Deitz Dental Clinic is a medium-sized dental service specializing in family  den- tal care.

The clinic is currently prepar


master budget for the first 2 quarters of 2011. All that remains in this process is the cash budget. The following informatio
been collected from other portions of the master budget and elsewhere.

Beginning cash balance


Required minimum cash  balance
Payment of income taxes (2nd  quarter)
Professional salaries:
1st quarter
2nd quarter
Interest from investments (2nd quarter)
Overhead costs:
1st quarter
2nd quarter
Selling and administrative costs, including
$3,000 depreciation:

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

You might also like