A1 Accounts Receivable AnalysisXavier Stores Company and Lestrade Stores Inc. are large retail department stores. Both companies offer credit to their customers through their own credit card operations. Information from the financial statements for both companies for tworecent years is as follows (in millions):SalesCredit card receivables-beginningCredit card receivables-endingXavierLestrade$277,400$386,90050,28441,98043,00133,107a. Determine the (1) accounts receivable turnover and (2) the number of days' sales in receivables for both companies. Round answers to one decimal place. Assume 365 days a year.1. Accounts receivable turnover2. Number of days' sales in receivablesXavierdaysLestradedays

Calculate the accounts receivable turnover and the number of days' sales in receivables for both…

Answered: Accounts Receivable Analysis Xavier…

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter16: Financial Statement Analysis

Section: Chapter Questions

Problem 10E: Accounts receivable analysis Xavier Stores Company and Lestrade Stores Inc. are large retail...

See similar textbooks

Similar questions

Accounts Receivable Analysis Xavier Stores Company and Lestrade Stores Inc. are large retail department stores. Both companies offer credit to their customers through their own credit card operations. Information from the financial statements for both companies for two recent years is as follows (in millions): Xavier Lestrade Sales $219,000 $306,600 Credit card receivables-beginning 40,352 63,501 Credit card receivables-ending 33,688 48,891 a. Determine the (1) accounts receivable turnover and (2) the number of days' sales in receivables for both companies. Round answers to one decimal place. Assume 365 days a year. Xavier Lestrade 1. Accounts receivable turnover fill in the blank 1 fill in the blank 2 2. Number of days' sales in receivables fill in the blank 3 days fill in the blank 4 days b. Xavier’s accounts receivable turnover is than Lestrade’s. The number of days' sales in receivables is for Xavier than for Lestrade. These…
Accounts Receivable Analysis Xavier Stores Company and Lestrade Stores Inc. are large retail department stores. Both companies offer credit to their customers through their own credit card operations. Information from the financial statements for both companies for two recent years is as follows (in millions): Хavier Lestrade Sales $310,250 $434,350 Credit card receivables-beginning 46,788 49,619 Credit card receivables-ending 39,062 38,203 a. Determine the (1) accounts receivable turnover and (2) the number of days' sales in receivables for both companies. Round answers to one decimal place. ASsume 365 days a year. Xavier Lestrade 1. Accounts receivable turnover 2. Number of days' sales in receivables days days b. Xavier's accounts receivable turnover is than Lestrade's. The number of days' sales in receivables is for Xavier than for Lestrade. These differences indicate that Xavier is able to turn over its receivables quickly than Lestrade. As a result, it takes Xavier time to collect…
Bassett Stores Company and Fox Stores Inc. are large retail department stores. Both companies offer credit to their customers through their own credit card operations. Information from the financial statements for both companies for two recent years is as follows (all numbers are in millions): Merchandise sales Bassett Fox $208,050 $292,000 53,969 16,961 41,551 Credit card receivables beginning 20,317 Credit card receivables-ending a. (1) Determine the accounts receivable turnover for both companies. Round to one decimal place. Bassett Stores Fox Stores (2) Determine the days' sales in receivables for both companies. Assume there are 365 days in the year. Round intermediate calculations to the nearest whole dollar and final answers to one decimal place. Bassett Stores Fox Stores days days b. What conclusion can be drawn regarding the two companies and their credit card policies?
Fizzy Sodas and Hayes Companies are two of the largest and most successful beverage companies in the world in terms of the products that they sell and their receivables management practices. To evaluate their ability to collect on credit sales, consider the following rounded amounts reported in their annual reports (amounts in millions). Fiscal Year Ended: Net Sales Accounts Receivable Allowance for Doubtful Accounts Accounts Receivable, Net of Allowance Req 1 Complete this question by entering your answers in the tabs below. Req 2A Required: 1. Calculate the receivables turnover ratios and days to collect for Fizzy Sodas and Hayes Companies for 2018 and 2017. 2-a. Which of the companies was quicker to convert its receivables into cash in 2018? 2-b. Which of the companies was quicker to convert its receivables into cash in 2017? Req 2B Receivables Turnover Ratio Days to collect 2018 2018 $ 40,630 4,410 620 3,790 Fizzy Sodas Fizzy Sodas 2017 $ 45,120 4,710 610 4,100 Hayes Companies…
Bassett Stores Company and Fox Stores Inc. are large retail department stores. Both companies offer credit to their customers through their own credit card operations. Information from the financial statements for both companies for two recent years is as follows (all numbers are in millions): Bassett Fox Merchandise sales $229,950 $321,200 Credit card receivables—beginning 37,356 66,625 Credit card receivables—ending 31,188 51,295 a. (1) Determine the accounts receivable turnover for both companies. Round to one decimal place. Bassett Stores fill in the blank 1 Fox Stores fill in the blank 2 (2) Determine the days' sales in receivables for both companies. Assume there are 365 days in the year. Round intermediate calculations to the nearest whole dollar and final answers to one decimal place. Bassett Stores fill in the blank 3 days Fox Stores fill in the blank 4 days b. What conclusion can be drawn regarding the two companies and…
Analyzing Accounts ReceivableThe following information is taken from the annual report of Coca-Cola Enterprises, Inc.: (amounts in millions) Year 1 Year 2 Net sales $19,058 $19,606 Accounts receivable (net) 1,884 1,802 Calculate the receivable turnover ratio and the receivable collection period for Year 1 and Year 2. Round your answer to two decimal places. Year 1 Year 2 Receivable turnover ratio Receivable collection period days days How much additional cash flow from operations could Coca-Cola Enterprises generate in Year 2 if it could reduce its receivable collection period to just 30 days?Round your final answer to the nearest million dollar. Year 2 Additional cash flow million
Assume selected financial data for Walmart and Target, two close competitors in the retail industry, are as follows: Net Beginning Accounts Ending Accounts ($ in millions) Sales Receivable Receivable $463,854 79,466 $6,064 6,653 $6,937 6,427 Walmart Target Required: 1-a. Calculate the receivables turnover ratio and average collection period for Walmart and Target. (Enter your answers in millions. Do not round your intermediate calculations and round your answers to 1 decimal place.) Receivables Turnover Ratio Receivables Turnover Ratio Walmart times %3D Target 0 times %3D Average Collection Period Average Collection Period %3D Walmart 0 days Target 0 days 1-b. Which company maintains a higher receivables turnover? Walmart Target II II II II
The following transactions affecting the accounts receivable of FST Inc. took place during the year ended December 31: Sales (Cash & Credit) 5,900,000 Cash received from credit customers, all of whom took advantage of the discount feature of the entity’s credit term 4/10, n/30 3,024,000 Cash received from cash customers 2,100,000 Accounts receivable written off as worthless 50,000 Credit memorandum issued to credit customers for sales return and allowances 250,000 Cash refund given to cash customers for sales return and allowances 20,000 Recoveries on account receivable written off as uncollectible in prior periods (not included in cash amount stated above) 80,000 The following balances were taken from the January 1 Statement of Financial Position: Accounts Receivable 950,000 Allowance for Doubtful account 100,000 The entity provided for uncollectible account losses by crediting allowance for doubtful accounts in the…
The following transactions affecting the accounts receivable of FST Inc. took place during the year ended December 31: Sales (Cash & Credit) 5,900,000 Cash received from credit customers, all of whom took advantage of the discount feature of the entity’s credit term 4/10, n/30 3,024,000 Cash received from cash customers 2,100,000 Accounts receivable written off as worthless 50,000 Credit memorandum issued to credit customers for sales return and allowances 250,000 Cash refund given to cash customers for sales return and allowances 20,000 Recoveries on account receivable written off as uncollectible in prior periods (not included in cash amount stated above) 80,000 The following balances were taken from the January 1 Statement of Financial Position: Accounts Receivable 950,000 Allowance for Doubtful account 100,000 The entity provided for uncollectible account losses by crediting allowance for doubtful accounts in the…
Classifying Items Related to Receivables and Payables in a Balance Sheet When examining the accounts of WholeFoods Company, we ascertain that balances relating to both receivables and payables are included in a single controlling account (called receivables), which has an $7,200 debit balance. An analysis of the details of this account reveals the following. Items Debit Credit Accounts receivable—customers $16,000 Accounts receivable—officers (current collection expected) 1,000 Travel advances to sales staff 400 Accounts payable for merchandise $7,700 Unpaid salaries 1,320 Credit balances in customer accounts (accounts receivable) 800 Cash received in advance from customers for goods not yet shipped 180 Allowance for doubtful accounts, adjusted 200 Indicate how each of the items should be reported on WholeFoods Company’s balance sheet. Some accounts below may have a zero balance. Do not use negative signs in your answers. Cash and…
es Fizzy Sodas and Hayes Companies are two of the largest and most successful beverage companies in the world in terms of the products that they sell and their receivables management practices. To evaluate their ability to collect on credit sales, consider the following rounded amounts reported in their annual reports (amounts in millions). Fiscal Year Ended: Net Sales Accounts Receivable Allowance for Doubtful Accounts Accounts Receivable, Net of Allowance 2018 $ 40,630 4,410 620 3,790 Fizzy Sodas 2017 $ 45,120 4,710 610 4,100 2016 $ 47,640 4,930 600 4,330 2018 $ 82,416 8,240 100 8,140 Hayes Companies 2017 $82,945 8,150 130 8,020 Required: 1. Calculate the receivables turnover ratios and days to collect for Fizzy Sodas and Hayes Companies for 2018 and 2017. 2-a. Which of the companies was quicker to convert its receivables into cash in 2018? 2-b. Which of the companies was quicker to convert its receivables into cash in 2017? 2016 $ 71,470 7,770 140 7,630
ed Softee Sodas and Patterson Beverage Company are two of the largest and most successful beverage companies in the world in terms of the products that they sell and their receivables management practices. To evaluate their ability to collect on credit sales, consider the following rounded amounts reported in their annual reports (amounts in millions). Fiscal Year Ended: Net Sales Accounts Receivable Allowance for Doubtful Accounts Accounts Receivable, Net of Allowance 2018 $ 35,660 4,130 550 3,580 Softee Sodas 2017 $ 39,520 4,390 540 3,850 Patterson Beverage Company 2016 $ 44,440 4,580 530 4,050 2018 $ 71,440 7,680 100 7,580 2017 $ 72,120 7,590 130 2016 $ 66,660 7,250 140 7,460 7,110 Required: 1. Calculate the receivables turnover ratios and days to collect for Softee Sodas and Patterson Beverage Company for 2018 and 2017. 2-a. Which of the companies was quicker to convert its receivables into cash in 2018? 2-b. Which of the companies was quicker to convert its receivables into cash…

SEE MORE QUESTIONS

Recommended textbooks for you

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Financial Accounting

Accounting

ISBN:

9781305088436

Author:

Carl Warren, Jim Reeve, Jonathan Duchac

Publisher:

Cengage Learning

Financial Accounting Intro Concepts Meth/Uses

Finance

ISBN:

9781285595047

Author:

Weil

Publisher:

Cengage

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

Carl Warren, Ph.d. Cma William B. Tayler

Publisher:

South-Western College Pub

Financial Accounting

Accounting

ISBN:

9781305088436

Author:

Carl Warren, Jim Reeve, Jonathan Duchac

Publisher:

Cengage Learning

Financial Accounting Intro Concepts Meth/Uses

Finance

ISBN:

9781285595047

Author:

Weil

Publisher:

Cengage

SEE MORE TEXTBOOKS