Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Pisani Dental Clinic is a medium-sized dental service specializing in family dental care. The clinic is currently preparing the budget for the first two quarters

Pisani Dental Clinic is a medium-sized dental service specializing in family dental care. The clinic is currently preparing the budget for the first two quarters of 2020. It still needs to do only the cash budget. It has collected the following information from parts of the master budget and elsewhere:

Beginning cash balance $ 30,100
Required minimum cash balance 20,000
Payment of income taxes (2nd quarter) 3,900
Professional salaries:
1st quarter 140,200
2nd quarter 140,200
Interest from investments (2nd quarter) 7,000
Overhead costs:
1st quarter 95,700
2nd quarter 118,600
Selling and administrative expenses, including
$3,000 depreciation:
1st quarter 49,600
2nd quarter 70,300
Purchase of equipment (2nd quarter) 50,400
Sale of equipment (1st quarter) 12,100
Collections from clients:
1st quarter 245,800
2nd quarter 388,700
Interest on repayments (2nd quarter) 290

Prepare a cash budget for each of the first two quarters of 2020.

image text in transcribed

image text in transcribed

PISANI DENTAL CLINIC Cash Budget For the Two Quarters Ending June 30, 2020 Quarters Total Beginning cash balance $ $ 30100 $ Add : Cash receipts Collections from clients 245800 388700 634500 Sale of equipment 12100 12100 Interest from investments 7000 7000 Total receipts 257900 395700 653600 Total available cash 288000 Less : Disbursements Income tax 0 3900 3900 Overhead 95700 118600 214300 Selling and administrative expenses Professional salaries 140200 140200 280400 Purchase of equinment 504nn 50400 Purchase of equipment 50400 50400 Total disbursements Excess of Cash Available Over Cash Disbursements Financing Borrowing Less : Repayment Less : Interest expense Total financing Ending cash balance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

A Concise Course On Auditing An Authoritative Text For Stakeholders

Authors: Onyuka Felix McDubus

1st Edition

3844395415, 978-3844395419

More Books

Students also viewed these Accounting questions

Question

Describe the appropriate use of supplementary parts of a letter.

Answered: 1 week ago