PROBLEM 8—23 schedule or Expected cash collections;
The president of the retailer Prime Products has just approached the company’s bank with a request for a $30,000. 90-day loan. The purpose of the loan is to assist the company in acquiring inventories. Because the company has had some difficulty in paying off its loans in the past the loan officer has asked for a cash budget to help determine whether the loan should be made. The following data are available for the months April through June, during which the loan will be used:
a. On April 1, the start of the loan period, die cash balance will be $24,000. Accounts receivable on April 1 will total $140,000, of which $120,000 will be collected during April and $16,000 will be collected during May. The remainder will be uncollectible.
b. Past experience shows that 30% of a mouth's sales are collected in the mouth of sale, 60% in the month following sale, and 8% in the second month following sale. The other 2% is
c. Merchandise purchases are paid in full during the month following purchase. Accounts payable for merchandise purchases during March, which will be paid in April, total $140,000.
d. In preparing the cash budget, assume that the $30,000 loan will he mode in April and repaid in June Interest on the loan will total $1,200.
Required:
- Calculate the expected cash collections for April, May, and Tune, and for the three months in total.
- Prepare a cash budget, by month and in total, for the three-month period.
- If the company needs a minimum cash balance of $20,000 to start each month, can the loan be repaid as planned? Explain.
Want to see the full answer?
Check out a sample textbook solutionChapter 8 Solutions
MANAGERIAL ACCOUNTING
- Question 2 A. The Rilex and Chill Coffee Shop has requested a cash budget for August. After examining the records of the company, you find the following: 1. Cash balance on 1 August is RM43,280. 2. Actual sales for June and July are as follows: June RM Cash sales Credit sales Total sales 10,200 26,100 36,300 July RM 14,700 33,900 48,600 3. Credit sales are collected over three months: 30% in the month of sales, 40% in the second month, and 25% in the third month. The customers who paid in the month of sales are qualified for 3% discounts on the amount owed. While the sales collected in the third month are subject to a 2% late fee, which is paid by those customers in addition to what they owe. The remaining sales are uncollectible. 4. Inventory purchases average 80% of a month's total sales. Of those purchases, 60% are paid for in the month of purchase. The remaining 40% is paid for in the following month. 5. Salaries and wages total RM13,800 per month. 6. The company received interest…arrow_forwardSaved Help 其 You received no credit for this question in the prevlous attempt Vie Exercise 13-35 (Algo) Estimate Cash Collections (LO 13-5) Minot Corporation is preparing its cash budget for August. The following information is availlable concerning its accounts receivable: Estimated credit sales for August Actual credit sales for July Estimated collections in August for credit sales in August Estimated collections in August for credit sales in July Estimated collections in August for credit sales prior to July Estimated write-offs in August for uncollectible credit sales Estimated provision for bad debts in August for credit sales in August $ 80,000 $ 60,000 25% 70% $6,000 $ 4,000 $2,700 Required: What is the estimated amount of cash receipts from accounts receivable collections in August? Estimated cash receipts $ 71,000arrow_forwardQUESTION 4 REQUIRED Use the information provided below to prepare the following for Xpanda Limited for February and March 2022: 4.1 Debtors Collection Schedule 4.2 Cash Budget. INFORMATION The following budgeted information was made available by Xpanda Limited for 2022: 1. An overdrawn bank balance of R125 000 is expected on 31 January 2022. 2. Forty percent (40%) of all sales are for cash; the balance is on credit. Sales for January and February 2022 (excluding discounts) are expected to be R640 000 and R900 000 respectively. Sales are expected to increase by 10% during March 2022. Twenty percent (20%) of the cash sales are to wholesalers and they are entitled to a discount of 10%. Thirty percent (30%) of the sales on credit is expected to be collected in the month of the sale for a cash discount of 5%. The balance is expected to be collected one month later. 3. Xpanda Limited sells its goods at cost plus 60%. All goods that are sold each month are replaced in the same month. Fifty…arrow_forward
- Question 9 View Policies Current Attempt in Progress The following information was taken from Waterway Industries's cash budget for the month of July: Beginning cash $450000 balance 364000 Cash receipts 494000 Cash disbursements If the company has a policy of maintaining a minimum end of the month cash balance of $390000, the amount the company would have to borrow is O $320000. O $60000. O $26000. $70000. hp 3 40 fho l ins prt sc 44 delete home & 7 num backspace lock P 7 H K L enter pause Σ Zarrow_forwardExercise 13-40 (Algo) Estimate Cash Collections (LO 13-4) All sales at Alaska Company are on credit. The company is preparing a cash budget for November. The following information on accounts receivable collections is available from customer payment history: Percent of current month's sales collected this month Percent of prior month's sales collected this month Percent of sales two months prior to current month collected this month Percent of sales three months prior to current month collected this month The remaining 4 percent is not collected and is written off as bad debts. Sales to date are as follows: November (estimated) October September August $ 280,000 600,000 250,000 670,000 Required: What are the estimated cash receipts from accounts receivable collections in November? Estimated cash receipts 25% 60 8 3 Karrow_forwardPROBLEM 9-23 Schedule of Expected Cash Collections; Cash Budget [LO2, LO8] Herbal Care Corp., a distributor of herb-based sunscreens, is ready to begin its third quarter, in which peak sales occur. The company has requested a $40,000, 90-day loan from its bank to help meet cash requirements during the quarter. Since Herbal Care has experienced difficulty in paying off its loans in the past, the loan officer at the bank has asked the company to prepare a cash budget for the quarter. In response to this request, the following data have been assembled: On July 1, the beginning of the third quarter, the company will have a cash balance of $44,500. a. b. Actual sales for the last two months and budgeted sales for the third quarter follow (all sales are on account): $250,000 May (actual). June (actual) July (budgeted) August (budgeted). September (budgeted) $300,000 $400,000 ৪600,000 $320,000 Past experience shows that 25% of a month's sales are collected in the month of sale, 70% in the…arrow_forward
- 6 00:50:46 ipped Book 8 Hint Print erences The following is the sales budget for Lemonis, Incorporated, for the first quarter of 2021: January February Sales budget $ 202,000 $ 222,000 March $ 245,000 Credit sales are collected as follows: 60 percent in the month of the sale. 30 percent in the month after the sale. 10 percent in the second month after the sale. The accounts receivable balance at the end of the previous quarter was $86,000 ($56,000 of which was uncollected December sales). a. Calculate the sales for November. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. Calculate the sales for December. (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. Calculate the cash collections from sales for each month from January through March. (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) a. November sales b. December sales c. January cash…arrow_forwardCASH BUDGETING Rework Problem 15-10 using a spreadsheet model. After completing Parts a through d, respond to the following: If Bowers customers began to pay late, collections would slow down, thus increasing the required loan amount. If sales declined, this also would have an effect on the required loan. Do a sensitivity analysis that shows the effects of these two factors on the maximum loan requirement.arrow_forwardCASH BUDGETING Rework problem 15-10 using a spreadsheet model. After completing parts a through d, respond to the following: If Bowers customers began to pay late, collections would slow down, thus increasing the required loan amount. If sales dedined, this also would have an effect on the required loan. Do a sensitivity analysis that shows the effects of these two factors on the maximum loan requirement. 15-10 CASH BUDGETING Helen Bowers, owner of Helens Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2016 and 2017. May 2016 180,000 June 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2017 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale. 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2016 90,000 June 90,000 July 126,000 August 882,000 September 306,000 October 234,000 November 162,000 December 90,000 General and administrative salaries are approximately 27,000 a month. Lease payments under long-term leases are 9,000 a month. Depredation charges are 36,000 a month. Miscellaneous expenses are 2,700 a month. Income tax payments of 63,000 are due in September and December. A progress payment of 180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be 132,000, and a minimum cash balance of 90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2016. b. Prepare monthly estimates of the required financing or excess fundsthat is, the amount of money Bowers will need to borrow or will have available to invest. c. Now suppose receipts from sales come in uniformly during the month (that is, cash receipts come in at the rate of 1/30 each day), but all outflows must be paid on the 5th. Will this affect the cash budget? That is, will the cash budget you prepared be valid under these assumptions? If not, what could be done to make a valid estimate of the peak financing requirements? No calculations are required, although if you prefer, you can use calculations to illustrate the effects. d. Bowers sales are seasonal; and her company produces on a seasonal basis, just ahead of sales. Without making any calculations, discuss how the companys current and debt ratios would vary during the year if ail financial requirements were met with short-term bank loans. Could changes in these ratios affect the firms ability to obtain bank credit? Explain. e. f. g. h.arrow_forward
- Question-4 REQUIRED Use the information provided by Empire Traders to prepare the following for March and April 2024: 4.1 Debtors Collection Schedule 4.2 Cash Budget. INFORMATION The following information was provided by Empire Traders: 1. Empire Traders expects to have a favourable bank balance of R60 000 on 28 February 2024. 2. Budgeted sales figures for 2024 are as follows: 3. 4. 5. 6. 7. Cash sales Credit sales 9. January R320 000 R370 000 Total purchases February R370 000 R390 000 March R310 000 R320 000 Thirty percent (30%) of the cash sales is to informal traders who are entitled to a discount of 10%. Collections from debtors are usually as follows: • 80% is collected in the month after the sale. 20% is collected two months after the sale. Purchases of inventory are expected to be as follows: January February R410 000 R460 000 April R250 000 R300 000 March R400 000 April R380 000 Sixty percent (60%) of the purchases is for cash to take advantage of a discount of 15%. The balance…arrow_forwardQUESTION 3 REQUIRED Use the information provided below to prepare the following for Mustang Enterprises for January and February 2024. 3.1 Debtors Collection Schedule 3.2 Cash Budget. INFORMATION The following information was supplied by Mustang Enterprises: 1. Mustang Enterprises expects to have an unfavourable bank balance of R40 000 on 31 December 2023. 2. The monthly sales were projected as follows: 2023 Units November 44 000 December 53 000 2024 Units January 47 000 February 31 000 3. The selling price is R20 per unit (excluding any discounts). All the goods produced each month are expected to be sold in the same month. Sixty percent (60%) of the sales is expected to be on credit and the balance is for cash. Thirty percent (30%) of the cash sales is subject to a discount of 10%. 4. Credit sales are usually collected as follows: 20% in the month of sale, and these debtors receive a 5% discount. 75% in the month after the sale, and the rest is usually written off as bad debts. 5.…arrow_forwardQuestion 4 Use the information provided below to prepare the following for January and February 2023: 4.1 Debtors Collection Schedule 4.2 Cash Budget INFORMATION The following information was provided by Intel Enterprises: 1. The bank balance on 31 December 2022 is expected to be R40 000 (unfavourable). 2. Credit sales are expected to be as follows: December 2022 January 2023 R576 000 R540 000 3. Credit sales usually make up 40% of the total sales. Cash sales make up the balance. Cash customers receive a 10% discount. * 65% in the following month The rest is usually written off as bad debts. 5. Budgeted purchases of inventory are as follows: December 2022 January 2023 R1 000 000 February 2023 4. Credit sales are normally collected as follows: * 30% in the month in which the transaction takes place, and these customers are entitled to a 5% discount. R648 000 R800 000 February 2023 R920 000 6. Fifty percent (50%) of the purchases are for cash. The remainder is paid in the month after the…arrow_forward
- Fundamentals of Financial Management, Concise Edi...FinanceISBN:9781285065137Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningFundamentals of Financial Management (MindTap Cou...FinanceISBN:9781285867977Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCornerstones of Financial AccountingAccountingISBN:9781337690881Author:Jay Rich, Jeff JonesPublisher:Cengage Learning
- Fundamentals of Financial Management, Concise Edi...FinanceISBN:9781305635937Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning