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 this process is the cash budget. The following information has 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 $2,140 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) Beginning Cash Balance Total Receipts Add V $32,100 26,750 4,280 Investment Interest Sale of Equipment Collections from Clients 149,800 149,800 7,490 82,390 107,000 Prepare a cash budget for each of the first two quarters of 2020. 53,500 74,900 53,500 12,840 251,450 406,600 214 SHERIDAN DENTAL CLINIC Cash Budget For the Two Quarters Ending June 30, 2020 1st Quarter 32100 2nd Quarter 26750

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 this process is the cash budget. The following information has 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 $2,140 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) Beginning Cash Balance Total Receipts Add V $32,100 26,750 4,280 Investment Interest Sale of Equipment Collections from Clients 149,800 149,800 7,490 82,390 107,000 Prepare a cash budget for each of the first two quarters of 2020. 53,500 74,900 53,500 12,840 251,450 406,600 214 SHERIDAN DENTAL CLINIC Cash Budget For the Two Quarters Ending June 30, 2020 1st Quarter 32100 2nd Quarter 26750

Fundamentals Of Financial Management, Concise Edition (mindtap Course List)

10th Edition

ISBN:9781337902571

Author:Eugene F. Brigham, Joel F. Houston

Publisher:Eugene F. Brigham, Joel F. Houston

Chapter15: Working Capital Management

Section: Chapter Questions

Problem 10P: CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of...

See similar textbooks

Similar questions

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 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.220 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) $33,300 27.750 4,440 155,400 155,400 7,770 85,470 111,000 55,500 77,700 55.500 13.320 260,850 421,800 222 Prepare a cash budget for each of the first two quarters of 2020. PLETCHER DENTAL CLINIC Cash Budget 1…
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 $30,900 Required minimum cash balance 25,750 Payment of income taxes (2nd quarter) 4,120 Professional salaries: 1st quarter 144,200 2nd quarter 144,200 Interest from investments (2nd quarter) 7,210 Overhead costs: 1st quarter 79,310 2nd quarter 103,000 Selling and administrative costs, including $2,060 depreciation: 1st quarter 51,500 2nd quarter 72,100 Purchase of equipment (2nd quarter) 51,500 Sale of equipment (1st quarter) 12,360 Collections from clients: 1st quarter 242,050 2nd quarter 391,400 Interest payments…
1. Donnegal 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 2010. 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 Required minimum cash balance Payment of income taxes (2nd quarter) $ 30,000 25,000 4,000 Professional salaries: 1st quarter 2nd quarter Interest from investments (2nd quarter) Overhead costs: 140,000 140,000 5,000 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) 75,000 100,000 50,000 70,000 50,000 15,000 Collections from clients: 1st quarter 2nd quarter Interest payments (2nd quarter) 230,000 380,000 300 Instructions Prepare a cash budget for each of the first two quarters of 2010. 2. In the month of…
B. Mahmoud Repair Company is preparing its budget for the first quarter of 2021. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected. Clients usually pay 60% of their fee in the month that service is provided, 30% the month after, and 10% the second month after receiving service. Actual service revenue for 2016 and expected service revenues for 2021 are: November 2020, $120,000; December 2020, $110,000; January 2021, $140,000; February 2021, $160,000; March 2021, $170,000. Purchases on landscaping supplies (direct materials) are paid 40% in the month of purchase and 60% the following month. Actual purchases for 2020 and expected purchases for 2021 are: December 2020, $21,000; January 2021, $20,000; February 2021, $22,000; March 2021, $27,000. Instructions (a) Prepare the following schedules for each month in the first quarter of 2021 and for the quarter in total: (1)…
Sunland Landscaping Inc. is preparing its budget for the first quarter of 2020. The next step in the budgeting process is to prepare a cash receipts schedule and a cash payments schedule. To that end the following information has been collected.Clients usually pay 60% of their fee in the month that service is performed, 30% the month after, and 10% the second month after receiving service.Actual service revenue for 2019 and expected service revenues for 2020 are November 2019, $93,620; December 2019, $83,630; January 2020, $102,120; February 2020, $123,950; and March 2020, $133,630.Purchases of landscaping supplies (direct materials) are paid 60% in the month of purchase and 40% the following month. Actual purchases for 2019 and expected purchases for 2020 are December 2019, $16,410; January 2020, $13,540; February 2020, $18,970; and March 2020, $23,150.(a)Prepare the following schedules for each month in the first quarter of 2020 and for the quarter in total:(1) Expected collections…
Whispering Winds Landscaping Company is preparing its budget for the first quarter of 2022. The next step in the budgeting process is to prepare cash receipts and cash payments schedules. To that end the following information has been collected.Clients usually pay 60% of their fee in the month that service is provided, 30% the month after, and 10% the second month after receiving service.Actual service revenue for 2021 and expected service revenues for 2022 are: November 2021, $130,000; December 2021, $100,000; January 2022, $144,000; February 2022, $161,000; March 2022, $170,000.Purchases of landscaping supplies are paid 30% in the month of purchase and 70% the following month. Actual purchases for 2021 and expected purchases for 2022 are: December 2021, $21,000; January 2022, $19,600; February 2022, $22,400; March 2022, $27,500. Determine the account receivable balances at March 31, 2022.
Styles Abuhatim LLC has given the following particulars. You are required to prepare a cash budget for the three months ending 31st December 2019 Months Sales Materials Wages ( OMR) Over heads (OMR) (OMR) (OMR) August September October 20000 10200 3800 1900 21000 10000 3800 2100 23000 9800 4000 2300 November 25000 10000 4200 2400 December 30000 10800 4500 2500 Credit terms are 1.. Sales /Debtors 10% sales are on Cash, 50% of the credit sales are collected in next month and the balance in the following month 2. Creditors- materials 2 months Wages 1 month -1 month Overheads 3. Cash balance on 1st October is expected to be Ro.8000 4. A machinery will be installed in August at a cost of RO.100000, the monthly instalment of RO.5000 is payable from October onwards 5. Dividend at 10% on preference share capital RO.300,000 will be paid on 1* December 2019 6. Advance to be received for the sale of vehicles RO.20000in December 7. Income tax to be received in December RO.5000
REQUIRED Use the information given below to prepare the Cash Budget for each of the first three months of operations (i.e. January, February, March 2024). Use separate monetary columns for each month. INFORMATION The following information relates to Baby Manufacturers which will commence business on 01 January 2024 with R750 000 cash: 1. New machinery and equipment will be purchased on 02 January 2024 for R300 000. A deposit of 20% will be paid immediately. The balance of the debt as well as finance charges of R18 000 will be paid in 12 equal instalments commencing February 2024. 2. Production will commence on 05 January 2024 and 30% of the sales for February's will be manufactured in January. Each month thereafter the production will consist of 70% of the current month's sales and 30% of the following month's sales. 3. Estimated sales at R72 per unit are as follows: January February March April Units 0 8 500 11 000 10 500 4. Cash sales are expected to comprise 60% of the total sales.…
Prepare schedules for cash receipts and cash payments, and determine the ending balances for the relevant balance sheet accounts. E10.30 (LO 4, 5) Service Environmental Landscaping Inc. is preparing its budget for the first quarter of 2022. The next step is to prepare a cash receipts schedule and a cash payments schedule. The following information has been collected: 1. Clients usually pay 50% of their fee in the month when the service is provided, 40% the next month, and 10% in the second month after receiving the service. 2. Actual service revenues for 2021 and expected service revenues for 2022 are as follows: November 2021, $90,000; December 2021, $70,000; January 2022, $110,000; February 2022, $120,000; and March 2022, $130,000. 3. The company pays for purchases of landscaping supplies (direct materials) 60% in the month of purchase and 40% the following month. Actual purchases for 2021 and expected purchases for 2022 are: December 2021, $14,000; January 2022, $13,000; February…
2. AP Sutton's Electronic Repair Shop has budgeted the following time and material for 2020. d Sutton's Electronic Repair Shop Budgeted Costs for the Year 2020 Time Charges Material Loading Charges Aatici, Shop employees' wages and benefits $108,000 Parts manager's salary and benefits $25,400 - Office employee's salary and benefits 13,600 23,500 Overhead (supplies, depreciation, advertising, utilities) 26,000 16,000 Total budgeted costs Sutton's budgets 5,000 hours of repair time in 2020 and will bill a profit of $10 per labor hour along with a 25% profit markup on the invoice cost of parts. The estimated invoice cost for parts to be used is $100,00o. $157,500 $55,000 ect 15 On January 5, 2020, Sutton's is asked to submit a price estimate to fix a 72-inch flat- screen TV. Sutton's estimates that this job will consume 4 hours of labor and $200 in parts. Instructions a. Compute the labor rate for Sutton's Electronic Repair Shop for the year 2020. b. Compute the material loading charge…
Please answer with excel forumlas and step by step explanations. Kayak Company budgeted the following cash receipts (excluding cash receipts from loans received) and cash payments (excluding cash payments for loan principal and interest payments) for the first three months of next year. Cash Receipts Cash payments January $ 569,000 $ 508,000 February 455,000 425,000 March 505,000 600,000 Kayak requires a minimum cash balance of $38,000 at each month-end. Loans taken to meet this requirement charge 0.7% interest per month, paid at each month-end. The interest is computed based on the beginning balance of the loan for the month. Any preliminary cash balance above $38,000 is used to repay loans at month-end. The company has a cash balance of $38,000 and a loan balance of $76,000 at January 1. Prepare monthly cash budgets for January, February, and March.
Mast Corporation seeks your assistance in developing cash and other budget information for May, June, and July. At April 30, the company had cash of $12,000, accounts receivable of $868,000, inventories of $117,720, and accounts payable of $26,674. The budget is to be based on the following assumptions. • Each month's sales are billed on the last day of the month. • Customers are allowed a 2 percent discount if payment is made within 10 days after the billing date. Receivables are recorded in the accounts at their gross amounts (not net of discounts). • The billings are collected as follows: 65 percent within the discount period, 20 percent by the end of the month, and 12 percent by the end of the following month. Three percent is uncollectible. Purchase data are as follows. • Of all purchases of merchandise and selling, general, and administrative expenses, 64 percent is paid in the month purchased and the remainder in the following month. • The number of units in each month's ending…