Exercise 5-18 (Algo) Calculate receivables ratios (LO5-8)Below are amounts (in millions) from three companies' annual reports.WalCoTarMartCostbetBeginning AccountsReceivable$1,7956,066609Ending AccountsReceivable$2,7426,594645Net Sales$320,42765,87866,963Required:1. Calculate the receivables turnover ratio and the average collection period for WalCo, TarMart and CostGet2. Which company appears most efficient in collecting cash from sales?Complete this question by entering your answers in the tabs below.Required 1 Required CCalculate the receivables turnover ratio and the average collection period for WalCo, TarMart and CostGet. (Enter your answers in millionsrounded to 1 decimal place.)Receivables Turnover Ratio:WalCo STarMart. SCostGet SChoose NumeratorChoose Numerator"ValCoFarMartCostGet320,427$65.87866,963Choose DenominatorReceivables turnover ratio2,742.0116.9 times0 times0 timesAverage Collection PeriodChoose DenominatorAverage collection period0 days0 days0 days

Receivables turnover refers to a metric that estimates the average number of times the receivables…

Answered: Exercise 5-18 (Algo) Calculate…

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 9E

See similar textbooks

Similar questions

Whalen Company had net sales of 125,500,250,000. Whalen had the following balances: Required: Note: Round answers to two decimal places. 1. Calculate the average accounts receivable. 2. Calculate the accounts receivable turnover ratio. 3. Calculate the accounts receivable turnover in days.
Montalcino Company had net sales of 54,000,000. Montalcino had the following balances: Required: Note: Round answers to one decimal place. 1. Calculate the average accounts receivable. 2. Calculate the accounts receivable turnover ratio. 3. Calculate the accounts receivable turnover in days.
FINANCIAL RATIOS Use the work sheet and financial statements prepared in Problem 15-8B. All sales are credit sales. The Accounts Receivable balance on January 1 was 38,200. REQUIRED Prepare the following financial ratios: (a)Working capital (b)Current ratio (c)Quick ratio (d)Return on owners equity (e)Accounts receivable turnover and the average number of days required to collect receivables (f)Inventory turnover and the average number of days required to sell inventory
Exercise 5-18 (Algo) Calculate receivables ratios (LO5-8) Below are amounts (in millions) from three companies' annual reports. WalCo TarMart CostGet Required: Beginning Accounts Receivable $1,775 5,966 589 Ending Accounts Receivable $2,722 6,494 625 Net Sales $318,427 63,878 64,963 1. Calculate the receivables turnover ratio and the average collection period for WalCo, TarMart and CostGet. 2. Which company appears most efficient in collecting cash from sales? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Calculate the receivables turnover ratio and the average collection period for WalCo, TarMart and CostGet. (Enter your answers in millions rounded to 1 decimal place.) WalCo TarMart CostGet WalCo TarMart CostGet Choose Numerator Receivables Turnover Ratio Choose Denominator Receivables turnover ratio times times times Average Collection Period Choose Numerator Choose Denominator Average collection period days days days
tres
a
Accounts Receivable Analysis The following data are taken from the financial statements of Basinger Inc. Terms of all sales are 2/10, n/45. 20Y3 20Y2 20Y1 Accounts receivable, end of year $196,800 $212,000 $226,000 Sales on account 1,369,480 1,292,100 a. For 20Y2 and 20Y3, determine (1) the accounts receivable turnover and (2) the number of days' sales in receivables. Round interim calculations to the nearest dollar and final answers to one decimal place. Assume a 365-day year. 20Y3 20Y2 1. Accounts receivable turnover 2. Number of days' sales in receivables days days b. The collection of accounts receivable has improved . This can be seen in both the increase in accounts receivable turnover and the decrease in the collection period.
Accounts Receivable Analysis The following data are taken from the financial statements of Sigmon Inc. Terms of all sales are 2/10, n/45. 20Y3 20Y2 20Υ1 Accounts receivable, end of year $113,600 $120,000 $128,200 Sales on account 829,280 781,830 a. For 20Y2 and 20Y3, determine (1) the accounts receivable turnover and (2) the number of days' sales in receivables. Round answers to one decimal place. Assume a 365-day year. 20Υ3 20Y2 1. Accounts receivable turnover 2. Number of days' sales in receivables days days
Accounts Receivable Analysis The following data are taken from the financial statements of Sigmon Inc. Terms of all sales are 2/10, n/45. 20Y3 20Υ2 20Υ1 Accounts receivable, end of year $175,000 $190,000 $204,200 Sales on account 1,003,750 985,500 a. For 20Y2 and 20Y3, determine (1) the accounts receivable turnover and (2) the number of days' sales in receivables. Round answers to one decimal place. Assume a 365-day year. 20Υ3 20Υ2 1. Accounts receivable turnover 2. Number of days' sales in receivables days days b. The collection of accounts receivable has improved v This can be seen in both the increase v in accounts receivable turnover and the decrease in the collection period. Feedback Check My Work a.1. Divide net sales by average accounts receivable. Average Accounts receivable = (Beginning Accounts Receivable + Ending Accounts Receivable) ÷ 2. a.2. Divide average accounts receivable by average daily sales on account. Average Accounts receivable = (Beginning Accounts Receivable +…
Accounts Receivable Analysis The following data are taken from the financial statements of Basinger Inc. Terms of all sales are 2/10, n/45. 20Y3 20Y2 20Y1 Accounts receivable, end of year $157,200 $164,000 $171,800 Sales on account 883,300 789,130 a. For 20Y2 and 20Y3, determine (1) the accounts receivable turnover and (2) the number of days' sales in receivables. Round interim calculations to the nearest dollar and final answers to one decimal place. Assume a 365-day year. 20Y3 20Y2 1. Accounts receivable turnover 2. Number of days' sales in receivables days days This can be seen in both the in accounts receivable b. The collection of accounts receivable has turnover and the in the collection period.
3. The following data are taken from the financial statements of Sigmon Inc. Terms of all are 2/10, n/45. Accounts Receivable, end of year Sales on account of Required: 20Y3 $725,000 $5,637,000 a. For 20Y2 and 20Y3, determine: 1. Accounts Receivable Turnover 2. The number of Days' Sales in Receivables 20Y2 $650,000 $4,687,000 20Y1 $600,000 b. What conclusions can you draw from these data concerning Sigmon's accounts receivable and credit policies?
Accounts Receivable Analysis The following data are taken from the financial statements of Sigmon Inc. Terms of all sales are 2/10, n/45. 20Y3 20Y2 20Y1 Accounts receivable, end of year $142,000 $150,000 $156,600 Sales on account 890,600 858,480 a. For 20Y2 and 20Y3, determine (1) the accounts receivable turnover and (2) the number of days' sales in receivables. Round answers to one decimal place. Assume a 365-day year. 20Y3 20Y2 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

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

Managerial Accounting: The Cornerstone of Busines…

Accounting

ISBN:

9781337115773

Author:

Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:

Cengage Learning

College Accounting, Chapters 1-27 (New in Account…

Accounting

ISBN:

9781305666160

Author:

James A. Heintz, Robert W. Parry

Publisher:

Cengage Learning

Managerial Accounting

Accounting

ISBN:

9781337912020

Author:

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

Publisher:

South-Western College Pub

Managerial Accounting: The Cornerstone of Busines…

Accounting

ISBN:

9781337115773

Author:

Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:

Cengage Learning

College Accounting, Chapters 1-27 (New in Account…

Accounting

ISBN:

9781305666160

Author:

James A. Heintz, Robert W. Parry

Publisher:

Cengage Learning

Survey of Accounting (Accounting I)

Accounting

ISBN:

9781305961883

Author:

Carl Warren

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS