Sedita Inc. is working on its cash budget for July. The budgeted beginning cash balance is $14.000. Budgeted cash receipts total $183,000 and budgeted cash disbursements total $182,000. The desired ending cash balance is $33,000. The excess (deficiency) of cash available over disbursements for July will be: Multiple Cholce $15.000 $1,000 $13.000 $197,000

Sedita Inc. is working on its cash budget for July. The budgeted beginning cash balance is $14.000. Budgeted cash receipts total $183,000 and budgeted cash disbursements total $182,000. The desired ending cash balance is $33,000. The excess (deficiency) of cash available over disbursements for July will be: Multiple Cholce $15.000 $1,000 $13.000 $197,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

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= $39,000 Cash receipts from sales= $315,000 Budgeted cash disbursements for salaries=$83,000 Budgeted cash disbursements for purchases=$146,000
The company provides the following information regarding the cash budget for next year: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Beginning cash balance $5,000 $5,000 $5,000 $5,000 Excess (Deficiency) ($3,000) $2,000 ($2,500) $1,000 The company's policy is to start each quarter with a cash balance of $5,000.The company has access to a line of credit in the amount of $50,000 for any short term borrowing needs and pays the loans off as quickly as possible.The company assumes the cash budget for the year will begins with no loans.What is the expected loan balance at the end of Quarter 2 (ignore interest)?
Nestee controller for Mactan Relaters has assembled the following data to assist in the preparation of a cash budget for the third quarter of 2021: Sales- May $100,000 ;June $120,000; July $90,000 ; August $100,000 September $135,000; October $110,000 Each month, 30% of sales are for cash and 70% ore on credit. The collection pattern for credit sales is 20% in the month of sale, 50% in the following month, and 30% in the second month following the sale. Each month the ending inventory exactly equals 50% of the cost of next month's sales. The markup on goods is 25% of cost. Inventory purchases are paid in the month following the purchase. Monthly expenses are as follows: Salaries and wages $10,000; Depreciation $4,000; Utlites $1,000; Other $1,700. Property taxes of $15,000 are due and payable on July 15,2021. Advertising fees of $6,000 must be paid on August 20,2021. A lease on a new storage facility is scheduled to begin on September 2, 2021.Monthly payments are $5,000. The…
Verle, Inc. has a cash balance of $24,000 on April 1. The company is now preparing the cash budget for the second quarter. Budgeted cash collections and payments are as follows: Cash collections Cash payments: Purchases of direct materials Operating expenses Apr May Jun $24,000 $24,000 $25,000 5,800 4,600 4,600 6,000 3,500 5,300 There are no budgeted capital expenditures or financing transactions during the quarter. Based on the above data, calculate the projected cash balance at the end of May. OA. $60,200 OB. $24,000 OC. $52,100 OD. $55,600
Preparing a financial budget—schedule of cash receipts sensitivity analysis Marcel Company projects the following sales for the first three months of the year: $11,200 in January; $512,300 in February; and $11,100 in March. The company expects 60% of the sales to be cash and the remainder on account. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Accounts Receivable account has a zero balance on January l. Round to the nearest dollar. Requirements . Prepare a schedule of cash receipts for Marcel for January, February and March. What is the balance in Accounts Receivable on March 31? Prepare a revised schedule of cash receipts if receipts from sales on account are 60% in the month of the sale, 30% in the month following the sale, and 10% in the second month following the sale. What is the balance in Accounts Receivable on March 31?
Nana Kay company must maintain a minimum cash balance of ghc 25000. At the beginning June, the company's cash balance was ghc 17000. Budgeted cash receipts for June are ghc 150000 and budgeted cash disbursement are ghc 201000. Budgeted net income for July totals ghc 11,000. How much will Nana Kay company need to borrow by the end of June?
Laurey Inc. is working on its cash budget for June. The budgeted beginning cash balance is $45,100. Budgeted cash receipts total $129,000, and budgeted cash disbursements total $134,000. The desired ending cash balance is $60,000. To attain its desired ending cash balance for June, the company needs to borrow:
Your Company is working on its cash budget for July. The budgeted beginning cash balance is $46,000. Budgeted cash receipts total $174,000 and budgeted cash disbursements total $175,000. The desired ending cash balance is $50,000. What is the excess (deficiency) of cash available over disbursements for July? Group of answer choices $ 45,000 $221,000 $ 50,000 $ 1,000 $ 47,000
The budgeted sales of Kelley, SA for the given months are as follows: Cash Sales Credit Sales April $38,000 $256,000 May $54,000 $250,000 June $36,000 $192,000 July $33,000 $190,000 August $35,000 $287,000 To prepare a cash budget, the company needs to determine the expected cash collections each month, and has provided the following additional information: The Accounts Receivable balance on April 1 was $82,015. Of this amount, $57,015 represented uncollected March sales and $25,000 represented uncollected February sales. Collections on Credit sales: 65% in month of sale 30% in month following sale 5% in second month following sale Part 1: What should the April cash collected be? $BLANK Part 2: For August 1, what is budgeted Accounts Receivable? (76,100, 100,300, 109,950, 144950, OR 79,700)
Tucker Inc. had the following budgeted sales for the first half of the current year: Cash Sales Credit SalesJanuary $70,000 $340,000February 50,000 190,000March 40,000 135,000April 35,000 120,000May 45,000 160,000June 40,000 140,000The company is in the process of preparing a cash budget and must determine the expected cash collections by month. To this end, the following information has been assembled: Collections on credit sales: 60% in month of sale 30% in month following sale 10% in second month following sale There is no beginning accounts receivable balance. The total cash collected by Tucker Inc. during January would be: The total cash collected by Tucker Inc. during February would be: The total cash collected by Tucker Inc. during March would be: The total cash collected by Tucker Inc. during April would be: The total cash collected by Tucker Inc. during May would…
Garden Depot is a retailer that provided the following budgeted cash flows for next year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Total cash receipts $ 180,000 $330,000 $210,000 $230,000 Total cash disbursements $ 260,000 $230,000 $220,000 $240,000 The company's beginning cash balance for next year will be $20,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.
Determine the anticipated total cash receipts for the month of January for Madison Co. in preparing a Cash Budget, given the following info: Accounts Receivable balance as of January 1 $296,000.00 Budgeted Sales for January = $860,000.00 Madison Co. assumes all monthly sales are on account. And that 75% of the sales on account will be collected in the month of the sale, and that the remainder will be collected the following month. $688,000.00 $812,000.00 $941,000.00 O $468,000.00