Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Pletcher 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
Pletcher 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.
Beginning cash balance | $35,400 | |
Required minimum cash balance | 29,500 | |
Payment of income taxes (2nd quarter) | 4,720 | |
Professional salaries: | ||
1st quarter | 165,200 | |
2nd quarter | 165,200 | |
Interest from investments (2nd quarter) | 8,260 | |
Overhead costs: | ||
1st quarter | 90,860 | |
2nd quarter | 118,000 | |
Selling and administrative costs, including | ||
$2,360 depreciation: | ||
1st quarter | 59,000 | |
2nd quarter | 82,600 | |
Purchase of equipment (2nd quarter) | 59,000 | |
Sale of equipment (1st quarter) | 14,160 | |
Collections from clients: | ||
1st quarter | 277,300 | |
2nd quarter | 448,400 | |
Interest payments (2nd quarter) | 236 |
Prepare a cash budget for each of the first two quarters of 2020. Please give steps on how to get the answers of the missing answers
PLETCHER DENTAL CLINIC Cash Budget For the Two Quarters Ending June 30, 2020 1st Quarter Beginning Cash Balance 35400 $ Add V: Receipts Collections from Clients 277300 Sale of Equipment 14160 Investment Interest i Total Receipts 291460 Total Cash Available 326860 Less V: Disbursements Professional Salaries 165200 i Payment of Income Taxes i Selling and Administrative Costs 56640 i Equipment Purchase i Overhead Costs 90860 i Total Disbursements 312700 Excess (Deficiency) of Cash Available Over Cash Disbursements Financing Add V: Borrowings 100 Less Repayments Ending Cash Balance $ $ 1st Quarter 2nd Quarter ce 35400 $ 29500 pts nts 277300 448400 14160 i i 8260 291460 456660 326860 486160 ursements 165200 i 165200 i axes i 4720 i ative Costs 56640 i 80240 i i 59000 i 90860 i 118000 i 312700 i 427160 Cash Available Over Cash Disbursements swings vments 1.0 fo. $Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started