Worthington Company expects that cash sales will be 20% of total sales, credit card sales will be 50%of total sales, and account sales will be 30% of total sales. Credit card sales are collected in the monthfollowing the sale, net a 3% credit card fee. This means that if the sale is $100, thecredit card company's fee is $3, and Worthington receives $97. Account saleswill be collected as follows: 40% in the first month following the sale, 50% in the second monthfollowing the sale, 8% in the third month following the sale, and 2% never collected.The following table identifed the projected sales for the first year of operations:MonthSalesMonthJanuary $12,369,348 JulySales$21,747,839February 15,936,293 August14,908,534March13,294,309 September11,984,398April19,373,689 October18,894,535May20,957,566 November 21,983,545June18,874,717 December 20,408,367Complete the following statement showing the cash expected each month from the collections ofthese sales.Round all calculations to the nearest whole dollar amount.MonthJanuary $February $March $April $May $June $July $August $September $October $November $December $Cash Sales Credit Card Sales Account Sales Total Cash Collections$$"A$IA$$LA$$$$6A$$$+A$+ALALA$+A$LA$+A$$$ALAALAALALA$$+A$LA$LA$$

Worthington Company expects that cash sales will be 20% of total sales, credit card sales will be 50% of total sales, and account sales will be 30% of total sales. Credit card sales are collected in the month following the sale, net a 3% credit card fee. This means that if the sale is $100, the credit card company's fee is $3, and Worthington receives $97. Account sales will be collected as follows: 40% in the first month following the sale, 50% in the second month following the sale, 8% in the third month following the sale, and 2% never collected. The following table identifed the projected sales for the first year of operations:

Worthington Company expects that cash sales will be 20% of total sales, credit card sales will be 50% of total sales, and account sales will be 30% of total sales. Credit card sales are collected in the month following the sale, net a 3% credit card fee. This means that if the sale is $100, the credit card company's fee is $3, and Worthington receives $97. Account sales will be collected as follows: 40% in the first month following the sale, 50% in the second month following the sale, 8% in the third month following the sale, and 2% never collected. The following table identifed the projected sales for the first year of operations:

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter18: The Management Of Accounts Receivable And Inventories

Section: Chapter Questions

Problem 1P

See similar textbooks

Similar questions

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?
Earthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is collected in the month of sale, 15% is collected the month after the sale, and 10% is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $75,000 in April, $65,000 in May, and $90,000 in June?
A consumer goods company collects 70.00% of its sales in cash and gives 5.50% discount to cash customers. If the company's current monthly sales is $149.22 million dollars. How much cash will be collected from this month sales? Note: your answer should be in millions of dollars.
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.
Toshiba Company is considering offering a cash discount to speed up the collection of account receivable, currently the firm has an average collection period of 56 days, annual sales are 50,000 units, and the sales unit price is $40 with per unit variable cost is $30. A 2% discount estimates that 80% of its customers will take, if sales are expected to rise by 12%, and the average collection period increased to 60 days. The additional profit contribution from sales is
Chatsworth Company Month Expected Sales July $40,000 August $50.000 September $30,000
The Cannon Ball has projected its first quarter sales at $11,200, second quarter sales at $10,900, and third quarter sales at $13,300. The firm's cost of goods sold is equal to 71 percent of the next quarter's sales. The accounts receivable period is 30 days and the accounts payable period is 60 days. At the beginning of the first quarter, the firm has an accounts receivable balance of $2,800 and an accounts payable balance of $6,300. The firm pays $1,500 a month in cash expenses and $200 a month in taxes. At the beginning of the first quarter, the cash balance is $530 and the short-term loan balance is zero. During the first quarter, the firm is planning on spending $2,600 for some new equipment. The firm maintains a minimum cash balance of $20. Assume each month has 30 days. What is the cumulative cash surplus (deficit) at the end of the first quarter, prior to any shortterm borrowing?
Limitless Styles has a 45 day accounts payable period. The firm has expected sales of $900, $1,200, $1,900, and $2,600, respectively, by quarter for the next calendar year. The cost of goods sold for a quarter is equal to 70% of the next quarter sales. The firm has a beginning payables balance of $600 as of quarter one. What is the amount of the projected cash disbursements for accounts payable for Quarter 3 of the next year? Assume that a year has 360 days. A)$1,195 B)$1,085 C)$1,575
If a firm had credit sales of $1,550,000 for March and collected its sales 30% in the month of sale and 70% in the month following the sale, how much of March sales would be collected in cash in March?
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? NOTE: Enter amounts rounded to the nearest whole dollar. Cash sales Cash for collections the month of sale Cash for collections the month after sale Cash for collections two months after sale TOTAL cash receipts S S LA
The management of Kirkut Enterprises prepared the following forecasted total sales schedule for the five months ending December 2021 August September October November December R310 000 R330 000 R325 000 R340 000 R410 000 Additional information: Cash sales comprise 40% of total sales. These customers are entitles to a 4% discount. Credit sales are collected as follows: 40% in the month of sale - these customers get a 2% discount 55% in the month after the sale 5% is written off as bad debts Cash receipts for cash sales made for the period August to December will total: O A. R686 000 O B. R1 715 000 O C. R658 560 D. R1 646 400
Taylor Company provides the following information: Annual credit sales : $ 24,000,000Collection period : 3 monthsTerms : net/30Rate of return : 18% The company is considering changing the credit discount policy to 4/10, net 30. The company anticipates that thirty percent of consumers will take the discount. The receivable collection period is expected to be reduced to 2 months. Should the discount policy be implemented? Explain with calculations.