Matthew Young has been working on Sheffield Paints' cash budget for the coming year. Based on his projections for March, the beginning cash balance will be $40,700, cash collections will be $550,000, and cash disbursements will be $584,000. Sheffield Paints desires to maintain a $45,000 minimum cash balance. The company has a 12% open line of credit with its bank, which provides short- term borrowings in $500 increments. All borrowings are made at the beginning of the month, and all repayments are made at the end of the month (in $500 increments). Accrued interest is paid at the time of repayment. (a) How much will Sheffield Paints need to borrow from the bank at the beginning of March? Sheffield Paints should borrow 2$

Matthew Young has been working on Sheffield Paints' cash budget for the coming year. Based on his projections for March, the beginning cash balance will be $40,700, cash collections will be $550,000, and cash disbursements will be $584,000. Sheffield Paints desires to maintain a $45,000 minimum cash balance. The company has a 12% open line of credit with its bank, which provides short- term borrowings in $500 increments. All borrowings are made at the beginning of the month, and all repayments are made at the end of the month (in $500 increments). Accrued interest is paid at the time of repayment. (a) How much will Sheffield Paints need to borrow from the bank at the beginning of March? Sheffield Paints should borrow 2$

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

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 1st Quarter $ 210,000 $ 281,000 The company's beginning cash balance for the upcoming fiscal year will be $26,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. Beginning cash balance Total cash receipts Total cash available Total cash disbursements Excess (deficiency) of cash available over disbursements Financing: Borrowings Repayments Interest Required: Prepare the company's cash budget for the upcoming fiscal year.…
Motors Corporation manufactures motors for dirt bikes. The company requires a minimum $30,000 cash balance at each month-end. If necessary, the company borrows to meet this requirement at a cost of 3% interest per month (paid at the end of each month). Any preliminary cash balance above $30,000 at month-end is used to repay loans. The cash balance on July 1 is $43,000, and the company has no outstanding loans. Budgeted cash receipts and budgeted cash payments (other than for interest on the loan and loan activity) follow. July Cash receipts Cash payments $ 94,000 122,000 August September $120,000 108,900 $ 159,000 136,400 Prepare a cash budget for July, August, and September. Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar. Answer is not complete. MOTORS CORPORATION Cash Budget July August September Beginning cash balance $ 43,000 $ 30,000 $ 30,000 Add: Cash receipts 94,000 120,000…
Bagel Company is preparing its cash budget for the upcoming month. The beginning cash balance for the month is expected to be $17,000. Budgeted cash receipts are $87,000, while budgeted cash disbursements are $70,000. Bagel Company wants to have an ending cash balance of $50,000. The excess (deficiency) of cash available over disbursements for the month would be
Lane Products manufactures a popular kitchen utensil. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It opened negotiations with the local bank for a one-month loan of $56,000 starting March 1. The bank would charge interest at the rate of 0.5 percent per month and require the company to repay interest and principal on March 31. In considering the loan, the bank requested a projected income statement and cash budget for March. The following information is available: . The company budgeted sales at 20,000 units per month in February, April, and May and at 17,000 units in March. The selling price is $68 per unit. The company offers a 2 percent discount for cash sales. The company's experience is that bad debts average 1 percent of credit sales. The inventory of finished goods on February 1 was 3,200 units. The desired finished goods inventory at the end of each month equals 25 percent of sales anticipated for the…
Western Company is preparing a cash budget for June. The company has $10,400 in cash at the beginning of June and anticipates $31,600 in cash receipts and $37,700 in cash payments during June. Western Company has an agreement with its bank to maintain a minimum cash balance of $10,000. As of May 31, the company has no loans outstanding. To maintain the $10,000 required balance, during June the company must:
Urban Industries needs to maintain a minimum cash balance of $10,000 and has entered into an agreement with their bank to accomplish this. Urban is preparing a cash budget for September. Urban has $11,300 in cash at the beginning of September and anticipates $30,700 in cash receipts and $35,900 in cash payments during September. As of August 31, the company has no loans outstanding. To maintain the $10,000 required balance, during September the company must: O A. Borrow $3,900. O B. Borrow $10,000. OC. Borrow $5,200. OD. Repay $3,900. OE.Repay $6.100.
Foyert Corporation requires a minimum $7,000 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid at the end of each month). Any preliminary cash balance above $7,000 is used to repay loans at month-end. The cash balance on October 1 is $7,000, and the company has an outstanding loan of $3,000. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. (please see picture for other info) October November December Cash receipts $ 23,000 $ 17,000 $ 21,000 Cash payments 25,500 16,000 15,000 Prepare a cash budget for October, November, and December.
Karim Corporation requires a minimum $9,000 cash balance. Loans taken to meet this requirement cost 1% interest per month (paid at the end of each month). Any preliminary cash balance above $9,000 is used to repay loans at month-end. The cash balance on July 1 is $9,400, and the company has no outstanding loans. Budgeted cash receipts (other than for loans received) and budgeted cash payments (other than for loan or interest payments) follow. July August September Cash receipts $ 25,000 $ 33,000 $ 41,000 Cash payments 29,500 31,000 33,000 Prepare a cash budget for July, August, and September. (Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Round your final answers to the nearest whole dollar.)
The Hubbard Corporation is a distributor of hair care products and is ready to start the third quarter, in which its peak sales occur. The company has requested a $100,000, 90-day loan from its bank to help them meet their cash requirements for the third quarter. Since Hubbard Corporation has experienced difficulty in paying off their loans in previous years, the loan officer has requested the company prepare a cash budget for the third quarter. The following data has been gathered by the staff. On July 1, 2021, the beginning of the third quarter, the company will have a cash balance of $75,000. Actual sales for the last 2 months and budgeted sales for the third quarter (all sales are on account). Month Amount in Dollars ($) May (actual) 500,000 June (actual) 480,000 July (budgeted) 520,000 August (budgeted) 550,000 September (budgeted) 600,000 Past experience shows that 30% of a month's sales are collected in the month of sale, 60% in the month…
Lane Products manufactures a popular kitchen utensil. The company recently expanded, and the controller believes that it will need to borrow cash to continue operations. It opened negotiations with the local bank for a one-month loan of $40,000 starting March 1. The bank would charge interest at the rate of 0.5 percent per month and require the company to repay interest and principal on March 31. In considering the loan, the bank requested a projected income statement and cash budget for March. The following information is available: The company budgeted sales at 12,000 units per month in February, April, and May and at 9,000 units in March. The selling price is $60 per unit. The company offers a 2 percent discount for cash sales. The company's experience is that bad debts average 1 percent of credit sales. The inventory of finished goods on February 1 was 2,400 units. The desired finished goods inventory at the end of each month equals 25 percent of sales anticipated for the…
Getty Company expects sales for the first three months of next year to be $205,000, $270,000 and $300,000, respectively. Getty expects 30 percent of its sales to be cash and the remainder to be credit sales. The credit sales will be collected as follows: 10 percent in the month of the sale and 90 percent in the following month. Compute a schedule of Getty's cash receipts for the months of February and March. February March Budgeted cash receipts
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. January February March Cash Receipts Cash payments $ 525,000 400,000 450,000 $ 475,000 350,000 525,000 Kayak requires a minimum cash balance of $30,000 at each month-end. Loans taken to meet this requirement charge 1% 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 $30,000 is used to repay Ibans at month-end. The company has a cash balance of $30,000 and a loan balance of $60,000 at January 1. Prepare monthly cash budgets for January, February, and March Note: Negative balances and Loan repayment amounts (if any) should be indicated with minus sign. Beginning cash balance Add Cash receipts Total cash available Less Cash payments for Interest on loan Total…