For interest on borrowing you'd multiply it by 3 quarters instead of 2. Other than that, the previous answer is correct.
Problem 8-28 Cash Budget with Supporting Schedules (L08-2, L08-4, LO8-7, LO8-8) Westex Products is a wholesale...
Problem 8-28 Cash Budget with Supporting Schedules [LO8-2, LO8-4, LO8-7, LO8-8] pothes Westex Products is a wholesale distributor of industrial cleaning products. When the treasurer of Westex Products approached the company's bank late in the current year seeking short-term financing, he was told that money was very tight and that any borrowing over the next year would have to be supported by a detailed statement of cash collections and disbursements. The treasurer also was told that it would be very...
Thanks for your time!! Problem 8-28 Cash Budget with Supporting Schedules [LO8-2, LO8-4, LO8-7, LO8-8) Westex Products is a wholesale distributor of industrial cleaning products. When the treasurer of Westex Products approached the company's bank late in the current year seeking short term financing, he was told that money was very tight and that any borrowing over the next year would have to be supported by a detailed statement of cash collections and disbursements. The treasurer also was told that...
Problem 8-21 Schedules of Expected Cash Collections and Disbursements (L08-2, LO8-4, LO8-8) You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following Information is available about the company's operations: a. The cash balance on December 1 is $41,000. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October November December $ 68,400 $ 87.400 $ 95,800 $ 415,000 $...
Problem 8-24 Cash Budget with Supporting Schedules (LO8-2, LO8-4, LO8-8] Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: April May $ 600,000 $900,000 420,000...
Problem 8-24 Cash Budget with Supporting Schedules (LO8-2, LO8-4, LO8-8] Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: April May June July $ 540,000...
Problem 8-24 Cash Budget with Supporting Schedules [LO8-2, LO8-4, LO8-8] Garden Sales, Inc., sells garden supplies. Management is planning its cash needs for the second quarter. The company usually has to borrow money during this quarter to support peak sales of lawn care equipment, which occur during May. The following information has been assembled to assist in preparing a cash budget for the quarter: a. Budgeted monthly absorption costing income statements for April-July are: April $ 600,000 420,000 180,000 May...
Exercise 8-11 Cash Budget Analysis (L08-8) A cash budget, by quarters, is given below for a retail company (000 omitted). The company requires a minimum cash balance of at least $7,000 to start each quarter. Fill in the missing amounts. (Enter your answers in thousands of dollars. Cash deficiencies and Repayments should be indicated by a minus sign.) Quarter (000 omitted) 2 3 (000 omitted) Year 4 105 378 28 30 19| Cash balance, beginning Add collections from customers Total...
Problem 8-21 Schedules of Expected Cash Collections and Disbursements [LO8-2, LO8-4, LO8-8] You have been asked to prepare a December cash budget for Ashton Company, a distributor of exercise equipment. The following information is available about the company's operations: a. The cash balance on December 1 is $50,800. b. Actual sales for October and November and expected sales for December are as follows: Cash sales Sales on account October November December $ 77,800 $ 83,400 $ 99,800 $ 475,000 $...
Case 8-33 (Algo) Master Budget with Supporting Schedules (L08-2, L08-4, LO8-8, LO8-9, L08-10) You have just been hired as a new management trainee by Earrings Unlimited, a distributor of earrings to various retail outlets located in shopping malls across the country. In the past, the company has done very little in the way of budgeting and at certain times of the year has experienced a shortage of cash. Since you are well trained in budgeting, you have decided to prepare...
The president of Univax, Inc., has just approached the company's bank seeking short-term financing for the coming year, Year 2. Univax is a distributor of commercial vacuum cleaners. The bank has stated that the loan request must be accompanied by a detailed cash budget that shows the quarters in which financing will be needed, as well as the amounts that will be needed and the quarters in which repayments can be made To provide this information for the bank, the...