Duffy Corp. has provided a part of its budget for the second quarter.Apr$40,000Cash collectionsCash payments:Purchases of direct materialsOA. $42,000OB. $71,000O C. $53,000O D. $61,0005,0006,000Operating expenses6,0006,000Capital expenditures10,00020,000The cash balance on April 1 is $13,000. Assume that there will be no financing transactions or costs during the quarter. Calculate the projected cash balance at the end of April.4May$40,0005,0006,0000Jun$42,000D

PARTICULARS APRIL ($) BEGINING BALANCE $13,000 CASH COLLECTION $40,000 LESS : CASH…

Duffy Corp. has provided a part of its budget for the second quarter. Apr $40,000 Cash collections Cash payments: Purchases of direct materials 6,000 Operating expenses 6,000 Capital expenditures 20,000 The cash balance on April 1 is $13,000. Assume that there will be no financing transactions or costs du OA. $42,000 B. $71,000 C. $53,000 O D. $61,000 May Jun $40,000 $42,000 5,000 6,000 0 5,000 6,000 10,000 …….

Duffy Corp. has provided a part of its budget for the second quarter. Apr $40,000 Cash collections Cash payments: Purchases of direct materials 6,000 Operating expenses 6,000 Capital expenditures 20,000 The cash balance on April 1 is $13,000. Assume that there will be no financing transactions or costs du OA. $42,000 B. $71,000 C. $53,000 O D. $61,000 May Jun $40,000 $42,000 5,000 6,000 0 5,000 6,000 10,000 …….

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Cash Budget Brindle Arts had the following Cash Budget for Quarter 1, 2022. The company requires a minimum cash balance of $ 50,000 Fill in the missing values: **If a cell has a value of 0, type the 0. A blank cell will be marked as incorrect. January February March Quarter 1 Beginning Cash balance $ 50,000 $ 166,756 $ 50,000 Add cash collections Total cash available $ 662,638 $ 673,643 $ 812,693 $ 1,931,075 Less total cash disbursements: Purchases $ 185,078 $ 189,439 Direct labor $ 86,875 $ 82,875 $ 249,750 Variable manufacturing OH $ 65,156 $ 62,156 $ 187,313 Fixed manufacturing OH $ 83,333 $ 83,333 Variable S&A $ 38,750 $ 43,750 $ 125,000 Fixed S&A $ 38,333 $ 38,333 Equipment $ 150,000 $…
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July $109,000 $136,000 $174,000 M 46,000 58,000 63,000 32,000 Sales Manufacturing costs Selling and administrative expenses Capital expenditures 37,000 38,000 42,000 The company expects to sell about 15% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and the remainder the following month (second month following sale). Depreciation, insurance, and property tax expense represent $10,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in September, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 85% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of May 1 include cash of…
Prepare Cash Budget For 3 Months Brewster Corporation expects the following cash receipts and disbursements during the first quarter of the year (receipts exclude new borrowings and disbursements exclude interest payments on borrowings since January 1) January February March $280,000 $300,000 $270,000 Cash receipts Cash disbursements 260,000 340,000 280,000 The expected cash balance at January 1, is $62,000. Brewster wants to maintain a cash balance at the end of each month of at least $60,000. Short-term borrowings at 1% interest per month will be used to accomplish this, if necessary. Borrowings (in multiples of $1,000) will be made at the beginning of the month in which they are needed, with interest for that month paid at the end of the month. Prepare a cash budget for the quarter ended March 31. Brewster Corporation Cash Budget for the Quarter Ended March 31 January Beginning cash balance Cash receipts Short-term borrowings Cash available Cash disbursements Interest payment Total…
Schedule of Cash Payments for a Service Company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January-March). The Accrued Expenses Payable balance on January 1 is $25,600. The budgeted expenses for the next three months are as follows: January February $58,900 $71,700 $79,400 4,900 5,400 6,400 45,400 49,500 54,500 $109,200 $126,600 $140,300 Other operating expenses include $3,200 of monthly depreciation expense and $700 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 80% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December. Salaries Utilities Other operating expenses Total Prepare a schedule of cash payments for operations for January, February, and March. EastGate Physical Therapy Inc. Schedule of Cash Payments for Operations…
11 Skipped Campbell Medical Clinic has budgeted the following cash flows. January February March Cash receipts $104,000 $110,000 $130,000 Cash payments For inventory purchases For S&A expenses 92,000 74,000 33,000 34,000 Campbell Medical had a cash balance of $10,000 on January 1. The company desires to maintain a cash cushion of $9,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 2 percent per month. Repayments may be made in any amount available. Campbell pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Required Prepare a cash budget. (Round intermediate and final answers to the nearest whole dollar amounts. Any repayments/shortage should be indicated with a minus sign.) January February Cash Budget Section 1: Cash Receipts 87,000 29,000 Total cash available Section 2: Cash…
Fayette Medical Clinic has budgeted the following cash flows. February $232,000 January March Cash receipts Cash payments For inventory purchases For S&A expenses $240,000 $272,000 220,000 62,000 164,000 64,000 190,000 54,000 Fayette Medical had a cash balance of $16,000 on January 1. The company desires to maintain a cash cushion of $10,000. Funds are assumed to be borrowed, in increments of $2,000, and repaid on the last day of each month; the interest rate is 1 percent per month. Repayments may be made in any amount available. Fayette pays its vendors on the last day of the month also. The company had a monthly $80,000 beginning balance in its line of credit liability account from this year's quarterly results. Required Prepare a cash budget. (Any repayments/shortage should be indicated with a minus sign. Round intermediate and final answers to the nearest whole dollar amounts.) X Answer is not complete. Cash Budget January February March Section 1: Cash receipts Beginning cash…
Schedule of Cash Payments for a Service Company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January–March). The Accrued Expenses Payable balance on January 1 is $25,600. The budgeted expenses for the next three months are as follows: January February March Salaries $58,900 $71,700 $79,400 Utilities 4,900 5,400 6,400 Other operating expenses 44,800 48,800 53,800 Total $108,600 $125,900 $139,600 Other operating expenses include $3,200 of monthly depreciation expense and $700 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 70% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December.
Tomo, Inc. has prepared its third quarter budget and provided the following data: Jul $49,000 Aug $39,800 Sep $47,900 Cash collections Cash payments: Purchases of direct materials Operating expenses Capital expenditures 17,900 11,100 0 The cash balance on June 30 is projected to be $4,600. The company has to maintain a minimum cash balance of $5,000 and is authorized to borrow at the end of each month to make up any shortfalls. It may borrow in increments of $5,000 and has to pay interest every month at an annual rate of 5%. All financing transactions are assumed to take place at the end of the month. The loan balance should be repaid in increments of $5,000 whenever there is surplus cash. Calculate the final projected cash balance at the end of August taking into consideration all the financing transactions. 31,000 12,100 13,700 O A. $46600 OB. $-8842 OC. $15000 O D. $6158 21,800 8,700 24,900
Garden Depot Is a retailer that provided the following budgeted cash flows for next year. 1st Quarter 2nd Quarter $410,000 $ 260,000 $ 316,000 $ 286,000 3rd Quarter $ 290,000 $ 276,000 Total cash receipts Total cash disbursements The company's beginning cash balance for next year will be $36,000. The company requires a minimum cash balance of $10,000 and may borrow money at the beginning of any quarter and may repay any part of its loans at the end of any quarter. Interest payments, based on a quarterly Interest rate of 3%, are due on any principal at the time it is repaid. For simplicity, assume Interest is not compounded. Required: Prepare the company's cash budget for next year. Note: Repayments, Interest, and cash deficiencies should be indicated by a minus sign. Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing Borrowings Repayments Interest Total financing Ending cash balance…
The following information is available to assist you in preparing a company's cash budget. a. The cash balance on July 1 is $41,000. b. Actual sales for May and June and expected sales for July are as follows: May $ 68,400 $ 87,400 $ 95,800 $ 415,000 $ 614,000 $ 692,000 June July Cash sales Sales on account Sales on account are collected over a three-month period as follows: 20% collected in the month of sale, 60% collected in the month following sale, and 18% collected In the second month following sale. The remaining 2% is uncollectible. C. Purchases of inventory will total $376,000 for July. Thirty percent of a month's Inventory purchases are paid during the month of purchase. The accounts payable remaining from June's inventory purchases total $174,500, all of which will be paid in July. d. Selling and administrative expenses are budgeted at $452,000 for July. Of this amount, $63,500 is for depreciation. e. A new web server for the Marketing Department costing $86,500 will be…
Schedule of cash payments for a service company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January-March). The Accrued Expenses Payable balance on January 1 is $26,200. The budgeted expenses for the next three months are as follows: January February March Salaries $60,300 $73,400 $81,200 Utilities 5,000 5,500 6,600 Other operating expenses 46,400 50,600 $5,700 Total $111,700 $129,500 $143,500 Other operating expenses include $3,300 of monthly depreciation expense and $800 of monthly insurance expense that was prepaid for the year on May 1 of the previous year of the remaining expenses, 80% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December. Prepare a schedule of cash payments for operations for January, February, and March. EastGate Physical Therapy Inc. Schedule of Cash Payments for…
Newman Medical Clinic has budgeted the following cash flows. January February March $109,000 $115,000 $135,000 Cash receipts Cash payments For inventory purchases For S&A expenses Newman Medical had a cash balance of $12,500 on January 1. The company desires to maintain a cash cushion of $8,000. Funds are assumed to be borrowed, in increments of $1,000, and repaid on the last day of each month; the interest rate is 1 percent per month. Repayments may be made in any amount available. Newman pays its vendors on the last day of the month also. The company had a monthly $40,000 beginning balance in its line of credit liability account from this year's quarterly results. Required Prepare a cash budget. (Any repayments/shortage should be indicated with a minus sign. Round your answers to the nearest whole dollar amount.) 94,500 76,500 89,500 35,500 36,500 31,500 Cash Budget Cash available Less: Cash payments Total budgeted payments Payments minus receipts Financing Activity $ EA January 0 0…