Question

Cola Inc. and Soda Co. are two of the largest and most successful beverage companies in...

Cola Inc. and Soda Co. 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).

Cola Inc. Soda Co.
Fiscal Year Ended: 2015 2014 2013 2015 2014 2013
Net Sales $ 30,319 $ 25,690 $ 26,944 $ 52,448 $ 38,232 $ 38,251
Accounts Receivable 4,378 3,713 3,041 6,367 4,614 3,684
Allowance for Doubtful Accounts 38 45 41 134 80 60
Accounts Receivable, Net of Allowance 4,340 3,668 3,000 6,233 4,534 3,624

Required:

Calculate the receivables turnover ratios and days to collect for Cola Inc. and Soda Co. for 2015 and 2014. (Use 365 days in a year. Do not round intermediate calculations on Accounts Receivable Turnover Ratio. Round your final answers to 1 decimal place. Use final rounded answers from Accounts Receivable Turnover Ratio for Days to Collect ratio calculation.)

2015 2014
Cola Inc. Soda Co. Cola Inc. Soda Co.
Receivables Turnover Ratio
Days to collect

Homework Answers

Answer #1

Solution:

Cola Inc. Soda Inc.
Fiscal Year Ended: 2015 2014 2013 2015 2014 2013
Net Sales $30,319.00 $25,690.00 $26,944.00 $52,448.00 $38,232.00 $38,251.00
Accounts Receivable, Net of Allowance $4,340.00 $3,668.00 $3,000.00 $6,233.00 $4,534.00 $3,624.00
Average Net Accounts Receivable [(Beginning +Ending)/2] $4,004.00 $3,334.00 $5,383.50 $4,079.00
Receivable Turnover ratio (Net Sales / Average Accounts Receivable) 7.6 7.7 9.7 9.4
Days To collect (Number of days in a year / Average Receivable turnover ratio) 48.0 47.4 37.6 38.8
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
cola inc, and soda Co. are two of the largest and most successful beverage companies in...
cola inc, and soda Co. are two of the largest and most successful beverage companies in the world in termns of the products that they sell and their receivable management practices. to evaluate their ability to collected on credit sales, consider the following rounded amounts reported in their annual reports cola inc soda co fical year ended 2015 2014 2013 2015    2014    2013 net sales 33319* 28990 30440 56338    41732    41751 acc receivable    4448 3783...
Comparing Two Companies in the Same Industry: Under Armour and Columbia Sportswear The following information is...
Comparing Two Companies in the Same Industry: Under Armour and Columbia Sportswear The following information is available from the financial statements included in Form 10-K for fiscal years 2014 and 2013 for Under Armour, Inc. and Columbia Sportswear Company (in thousands of dollars): Under Armour, Inc. Columbia Sportswear Company Net revenues (Net sales for Under Armour, Inc. & Columbia Sportswear) for the year ended December 31, 2014 $3,084,370 $2,100,590 Accounts receivable, net: December 31, 2014 279,835 344,390 December 31, 2013...
The following information is available for Bergstrom Inc. and Sineann Inc. at December 31, 2016:   Accounts...
The following information is available for Bergstrom Inc. and Sineann Inc. at December 31, 2016:   Accounts Bergstrom Sineann   Accounts receivable $ 56,200 $ 76,000   Allowance for doubtful accounts 2,748 2,356   Sales revenue 636,960 917,100 Required a. What is the accounts receivable turnover for each of the companies for 2016? (Round your answers to 1 decimal place.) Company Accounts Receivable Turnover Bergstrom times Sineann times b. What is the average days to collect the receivables for 2016? (Use 365 days in...
Purrfect Pets, Inc., had sales revenue of $1,718,380 during 2011. The company had credit card discounts...
Purrfect Pets, Inc., had sales revenue of $1,718,380 during 2011. The company had credit card discounts of $16,180 and sales returns of $3,500. The balance in accounts receivable on December 31, 2010 was $102,600 and on December 31, 2011 it was $127,800. Calculate the receivables turnover ratio and days to collect measure for 2011   Receivables turnover ratio   Days to collect
Xavier Stores Company and Lestrade Stores Inc. are large retail department stores. Both companies offer credit...
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 $211,700 $295,650 Credit card receivables-beginning 37,489 68,098 Credit card receivables-ending 31,299 52,430 a. Determine the (1) accounts receivable turnover and (2) the number of days' sales in receivables for both companies. Round answers to one...
At December 31, 2021, Splish Brothers Inc. reported this information on its balance sheet. Accounts receivable...
At December 31, 2021, Splish Brothers Inc. reported this information on its balance sheet. Accounts receivable $581,000 Less: Allowance for doubtful accounts 37,000 During 2022, the company had the following transactions related to receivables. 1. Sales on account $2,355,000 2. Sales returns and allowances 49,000 3. Collections of accounts receivable 2,050,000 4. Write-offs of accounts receivable deemed uncollectible 38,000 5. Recovery of bad debts previously written off as uncollectible 16,000 Compute the accounts receivable turnover and average collection period, assuming...
sel, Inc. reported net sales revenue of $600,000 in 2018 and $500,000 in 2019. The company’s...
sel, Inc. reported net sales revenue of $600,000 in 2018 and $500,000 in 2019. The company’s ending net receivables were $120,000 during 2017 and $130,000 during 2018. At December 31, 2019, the company had Accounts Receivable of $148,000 and an unadjusted debit balance in its Allowance for Doubtful Accounts account of $1,000. The company reported Bad Debt Expense of $6,000 during 2019. Required: Determine the net receivables at December 31, 2019. Calculate the receivables turnover ratio for 2018 and 2019....
Accounts Receivable Analysis Xavier Stores Company and Lestrade Stores Inc. are large retail department stores. Both...
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 $240,900 $335,800 Credit card receivables-beginning 41,653 66,638 Credit card receivables-ending 34,775 51,306 a. Determine the (1) accounts receivable turnover and (2) the number of days' sales in receivables for both companies. Round...
Assume selected financial data for Sun Health Group and Select Medical Corporation, two companies in the...
Assume selected financial data for Sun Health Group and Select Medical Corporation, two companies in the health-care industry, are as follows: ($ in millions) Net Sales Beginning Accounts Receivable Ending Accounts Receivable Sun Health $ 2,530 $ 245 $ 232 Select Medical 2,840 444 383    Required: 1-a. Calculate the receivables turnover ratio and average collection period for Sun Health and Select Medical. (Round Average accounts receivable to 1 decimal place. Enter your answers in millions.)    Receivables Turnover Ratio...
Accounts Receivable Analysis The following data are taken from the financial statements of Sigmon Inc. Terms...
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 $725,000 $650,000 $600,000 Sales on account 5,637,500 4,687,500 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...