Question

Sheridan Dental Clinic is a medium sized dental service specializing in family dental care. The clinic is currently preparing the master budget for the first 2 quarters of 2020. All that remains in the process is the cash budget. The following information has been collected from other portions of the master budget and elsewhere Beginning cash balance Required cash balance Payment of income taxes (2nd quarter) Professional salaries: $350 29,500 4,720 165.200 165.200 260 90,860 118,000 2nd quarter Interest from investments (2nd quarter) Overhead costs ut quarter 2nd Quarter Selling and administrative costs, including $2,360 depreciation Ist quarter 2nd quarter Purchase of equipment (2nd quarter) Sale of equipment (1st Quarter) Collections from clients 59.000 32.100 59.000 14,160 2nd Quarter Interest payments (2nd quarters 27700 165.400 236 Prepare a cash budget for each of the first two quarters of 2020 SHERIDAN DENTAL CLINIC Cash Bala 1 Quarter 2 Quarter

Answer 1

SHERIDAN DENTAL CLINIC Cash Budget For the first two quarters of 2020 1st Quarter 2nd Quarter Cash balance, beginning $35,400 $29,500 --> (A) Total cash receipts: Interest from investments $8,260 Sale of equipment $14,160 Collections from clients $277,300 $448,400 Total cash receipts $291,460 $456,660 --> (B) Total cash available $326,860 $486,160 --> (C) = (A) + (B) Cash Disbursements: Income taxes $4,720 Professional salaries $165,200 $165,200 Overhead cost $90,860 $118,000 Selling and adminsitrative cost excluding depreciaiton $56,640 $80,240 ($59000 - $2360; $82600 - $2360] Purchase of equipment $59,000 Total cash disbursements $312,700 $427,160 --> (D) Excess (deficiency) of cash available over disbursements $14,160 $59,000 --> (E) = (C) - (D) Financing: Borrowings $15,340 - [$29500 - $14160] Repayments -$15,340 (Borrowed in Quarter-1 is repaid] Interest -$236 Total Financing $15,340 -$15,576 --> (F) Cash balance, ending $29,500 $43,424 --> (E) + (F)