Michael's Incorporated expect the following sales: Credit Cash $90,000 $ 95,000 $ 30,000 $ 25,000 $ 35,000 $ 240,000 July August September October November The cash budget is being developed, and the accountant is computing the projected cash collections. He notices a pattern: 50% collected in the month of sale: 40% collected the next month; and 10% collected the following month. The Accounts Receivable balance on July 1 was $65,000, which includes $50,000of June's sales and $15,000 of May's sales. Compute the projected Accounts Receivable balance on November 30: Multiple Choice $116,000 $120,000 $ 190,000 $ 210,000 $ 170,000 $ 110,000 $131,000

Michael's Incorporated expect the following sales: Credit Cash $90,000 $ 95,000 $ 30,000 $ 25,000 $ 35,000 $ 240,000 July August September October November The cash budget is being developed, and the accountant is computing the projected cash collections. He notices a pattern: 50% collected in the month of sale: 40% collected the next month; and 10% collected the following month. The Accounts Receivable balance on July 1 was $65,000, which includes $50,000of June's sales and $15,000 of May's sales. Compute the projected Accounts Receivable balance on November 30: Multiple Choice $116,000 $120,000 $ 190,000 $ 210,000 $ 170,000 $ 110,000 $131,000

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter7: Budgeting

Section: Chapter Questions

Problem 14EA: Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is...

See similar textbooks

Similar questions

My Aunts Closet Store collects 60% of its accounts receivable in the month of sale and 35% in the month after the sale. Given the following sales, how much cash will be collected in March?
In an attempt to better understand RR’s cash position, Johnson developed a cash budget for the first 2 months of the year. She has the figures for the other months, but they are not shown. After looking at the cash budget, answer the following questions: What does the cash budget show regarding the target cash level? Should depreciation expense be explicitly included in the cash budget? Why or why not? What are some other potential cash inflows besides collections? How can interest earned or paid on short-term securities or loans be incorporated in the cash budget? In her preliminary cash budget, Johnson has assumed that all sales are collected and thus that RR has no bad debts. Is this realistic? If not, how would bad debts be dealt with in a cash budgeting sense? (Hint: Bad debts will affect collections but not purchases.)
A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000
Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August?
Assume that your credit sales for March was $16,288,for April was $33,301 and May was $29,261. If credit sales are collected 55% during the month of sale, 25% the month following the sale, and 15% in the second month following the sale, what is the total expected cash collections to be received in May? Round your answer to one dollar.
Schedule of Cash Collections on Accounts Receivable and Cash BudgetBennett Inc. found that about 15% of its sales during the month were forcash. Bennett has the following accounts receivable collectionexperience: Percent collected in the month of sale Percent collected in the month after the sale Percent collected in the second month after the sale 25 68 5 Bennett's anticipated sales for the next few months are as follows: AprilMayJuneJulyAugust $250,000290,000280,000295,000300,000 (Note: Round all amounts to the nearest dollar.) Required:1. Calculate credit sales for May, June, July, and August.2. Prepare a schedule of cash receipts for July and August.
Marlin Company projects the follwoing sales for the first thre months of the year: $11500 in January; $10100 in February and $10400 in March. the company expects 60% of the sales to be cash and the remainder on accounts. Sales on account are collected 50% in the month of the sale and 50% in the following month. The Account Receivable account has a zero on January. 1. Prepare a schedule of cash receipts for Marlin for January, February and March. What is the balance in Accounts Receivable on March 31? 2. Prepare a revised schedule of cash receipts if receipts from sales on account are 70% in the month of the sale, 20% in the following month of the sale and 10% in the second month of the sale. What is the balance in Accounts Receivable on March 31?
Wells Company reports the following sales forecast: September, $55,000; October, $66,000; and November, $80,000. All sales are on account. Collections of credit sales are received as follows: 25% in the month of sale, 60% in the first month after sale, and 10% in the second month after sale. 5% of all credit sales are written off as uncollectible. Prepare a schedule of cash receipts for November.
From past experience, the company has learned that 20% of a month’s sales are collected in the month of sale, another 75% are collected in the month following sale, and the remaining 5% are collected in the second month following sale. Bad debts are negligible and can be ignored. February sales totaled $270,000, and March sales totaled $300,000. Required: 1. Prepare a schedule of expected cash collections from sales, by month and in total, for the second quarter. 2. What is the accounts receivable balance on June 30th?
Budgeting Cash Collections. Spencer Consulting, which invoices its clients on terms 2/10, n/30, had credit sales for May and June of $150,000 and $170,000, respectively. Analysis of Spencer's operations indicates that the pattern of customers' payments on account is as follows (percentages are of total monthly credit sales): In month of sale In month of following sale Uncollectible accounts, returns, and allowances Beyond Receiving Discount Discount 50% 10% Period Totals 25% 75% 10% 20% 5% 100% Determine the estimated cash collected on customers' accounts in June.
The Palos Company expects sales for June, July, and August of $48,000, $54,000, and $44,000, respectively. Experience suggests that 40% of sales are for cash and 60% are on credit. The company collects 50% of its credit sales in the month following sale, 45% in the second month following sale, and 5% are not collected. What are the company's expected cash receipts for August from its current and past sales?
Jane MacDonald, Carroll Financial Analyst, prepared the following sales and cash disbursement estimates for the February-June period of this year. Month Sales Cash Disbursements February 500 400 March 600 300 April 400 600 May 200 500 June 200 200 MacDonald indicates that 30% of sales have been, historically, in cash. 70% of credit sales are collected one month after the sale, and the remaining 30% are collected two months after the sale. The company wants to keep a minimum final balance in its $ 25 cash account. Balances in excess of this amount will be invested in short-term government securities (marketable securities), while any deficits will be financed through short-term bank borrowing (payable securities). The cash balance initially on April 1 is $ 115. Prepare cash budgets for April, May, and June. How much, if any, of the maximum funding would Carroll require to meet its obligations within this three-month period?…