Midus ind has the following data for the month ended on March 31. Prepare cash budget for the month of March 2021 with expected balance at the end. Beginning cash balance on March 1= $82,000 Cash repayment of bank loan= $18,000 Other budgeted cash expenses= S39,000 Cash receipts from sales= $315,000 Budgeted cash disbursements for salaries=$83,000 Budgeted cash disbursements for purchases=$146,000

Midus ind has the following data for the month ended on March 31. Prepare cash budget for the month of March 2021 with expected balance at the end. Beginning cash balance on March 1= $82,000 Cash repayment of bank loan= $18,000 Other budgeted cash expenses= S39,000 Cash receipts from sales= $315,000 Budgeted cash disbursements for salaries=$83,000 Budgeted cash disbursements for purchases=$146,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

Delbert, Inc. has prepared its third quarter budget and provided the following data: Jul Aug Sep Cash collections $49,000 $39,500 $46,000 Cash payments: Purchases of direct materials 30,000 22,100 17,600 Operating expenses 12.400 8,500 11,400 Capital expenditures 13,300 24,200 0 The cash balance on June 30 is projected to be $5,300. 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 4%. 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. How much will the company have to borrow at the end of July? OA. $15,000 OB. $10,000 OC. $5,000 OD. $0
You are provided with the following information taken from Wildhorse Inc.'s March 31, 2025, balance sheet. Cash Accounts receivable Inventory Property, plant, and equipment, net of depreciation Accounts payable Common stock Retained earnings 1. 2. 3. 4. 5. Additional information concerning Wildhorse Inc. is as follows. 6. 7. Gross profit is 25% of sales. Actual and budgeted sales data: March (actual) April (budgeted) March April Purchases March $48,200 $19,280 42,420 $61,700 Purchases April $11,600 70,700 20,180 36,010 Sales are both cash and credit. Cash collections expected in April are: (40% of $48,200) (60% of $70,700) 120,800 22,560 154,500 11.680 Half of a month's purchases are paid for in the month of purchase and half in the following month. Cash disbursements expecte $22,560 28,320 $50,880 Cash operating costs are anticipated to be $12,630 for the month of April. Equipment costing $2,560 will be purchased for cash in April. The company wishes to maintain a minimum cash balance…
A company is preparing its cash budget. Its cash balance on January 1 is $290,000, and it has a minimum cash requirement of $340,000. The following data have been provided: January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash payments 984,500 1,210,000 1,075,000 The amount of the deficiency or excess cash (after considering the minimum cash balance required) for January is a(n) a.excess of $60,000 b.deficiency of $136,700 c.excess of $356,700 d.excess of $26,700
Garden Depot is a retailer that is preparing its budget for the upcoming fiscal year. Management has prepared the following summary of its budgeted cash flows: Total cash receipts Total cash disbursements Beginning cash balance Total cash receipts Total cash available Total cash disbursements 1st Quarter $ 330,000 $ 379,000 The company's beginning cash balance for the upcoming fiscal year will be $22,000. The company requires a minimum cash balance of $10,000 and may borrow any amount needed from a local bank at a quarterly interest rate of 3%. The company may borrow any amount at the beginning of any quarter and may repay its loans, or any part of its loans, at the end of any quarter. Interest payments are due on any principal at the time it is repaid. For simplicity, assume that interest is not compounded. Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest 2nd Quarter $ 450,000 $ 349,000 Required: Prepare the company's cash budget for…
Prepare the cash budget for January and February of Gilmore Company using the following data: February P42,100 January Cash Receipts Cash Disbursements Beginning Cash Balance Ending P46,500 P38,320 P37,220 P5,210 As per computation Required Cash Balance (Minimum) P12,000 P12,000
ere are some important figures from the budget of Crenshaw, Inc., for the second quarter of 2019. April May June Credit sales $ 689,000 $ 598,000 $ 751,000 Credit purchases 302,000 282,000 338,000 Cash disbursements Wages, taxes, and expenses 137,000 129,000 179,000 Interest 15,600 15,600 15,600 Equipment purchases 53,500 6,600 248,000 The company predicts that 5 percent of its credit sales will never be collected, 35 percent of its sales will be collected in the month of the sale, and the remaining 60 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2019, credit sales were $561,000. Using this information, complete the following cash budget: (Do not round intermediate calculations and round your answers to the nearest whole number,…
Prepare a master budget for the three-month period ending June 30 that includes a schedule of expected cash collections, by month and in total.
1-> O O O O O O Baxter Company's budget committee provides the following information: (Click the icon to view the information.) Read the requirements. Requirement 1. Prepare the schedule of cash receipts from customers for January and February 2024. Assume cash receipts are 80% in sale and 20% in the month following the sale. Baxter Company Budgeted Cash Receipts from Customers Two Months Ended February 28, 2024 January Current month sales, 80% Prior month sales, 20% Total cash receipts Requirement 2. Prepare the schedule of cash payments for purchases for January and February 2024. Assume purchases are paid 60% purchase and 40% in the month following the purchase. Bud Tw 40% of last month's purcha 60% of current month's pu Total cash payments for pu Requirement 3. Prepare th accrual for Salaries and Co commissions are paid 30% is an expiration of the prep Budgeted Cash Variable expenses: 70% of last month's Comm 30% of current month's Co Total payments for variabl Fixed expenses 70%…
Grit Company was formed on May 1, 2023. During May, 2023, the company reported sales on account of $750,000. During June, 2023, Grit Company reportes sales on account of $800,000. Anticipated collections patterns of accounts receivable indicate 40% will be collected in the month of sale, 10% in the next month, and the remainder in the following month. How much will appear on the cash receipts and disbursements budget prepared for June, 2023? $620,000 O $465,000 O $545,000 O $540,000
The following information is available for Sunland Company for the month of January: expected cash receipts $58,360; expected cash disbursements $66,210; and cash balance on January 1, $11,630. Management wishes to maintain a minimum cash balance of $8,030. Prepare a basic cash budget for the month of January. SUNLAND COMPANY Cash Budget For the Month of January
Sedita Inc. is working on its cash budget for July. The budgeted beginning cash balance is $30.000. Budgeted cash receipts total $186,000 and budgeted cash disbursements total $185,000. The desired ending cash balance is $53,000. The excess (deficiency) of cash available over disbursements for July will be: Multple Choice O $1000 $216.000 $29.000 $31.000
Prepare a master budget for the three-month period ending June 30 that includes a budgeted balance sheet as of June 30.