prepare a cash bidget for each lg thr first two quarters of 2020

Pharoah 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 this process is the cash budget. The following information has been collected from other portions of the master budget and elsewhere. $35,100 29,250 4,680 163,800 163,800 8,190 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 $2,340 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) 90,090 117,000 58,500 81,900 58,500 14,040 274,950 444,600 234