Question

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 $8,500,000 $4,585,000
Credit card receivables—beginning 820,000 600,000
Credit card receviables—ending 880,000 710,000

a. Determine the (1) accounts receivable turnover and (2) the number of days' sales in receivables for both companies. Round your calculations and 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 much higher  than Lestrade's. The number of days' sales in receivables is lower  for Xavier than for Lestrade. These differences indicate that Xavier is able to turn over its receivables more  quickly than Lestrade. As a result, it takes Xavier less  time to collect its receivables.

Homework Answers

Answer #1

SOLUTION

Xavier

Accounts receivables turnover = Net credit sales / Average accounts receivable

= $8,500,000 / 850,000

= 10 times

Average accounts receivable = (Beginning Accounts Receivable + Ending Accounts Receivable) / 2

= (820,000+880,000) / 2 = $850,000

Number of days' sales in receivables = 365 / Accounts receivables turnover

= 365 / 10 = 36.5 days

Lestrade

Accounts receivables turnover = Net credit sales / Average accounts receivable

= $4,585,000 / 655,000

= 7 times

Average accounts receivable = (Beginning Accounts Receivable + Ending Accounts Receivable) / 2

= (600,000+710,000) / 2 = $655,000

Number of days' sales in receivables = 365 / Accounts receivables turnover

= 365 / 7 = 52.1 days

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
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 $8,500,000 $4,585,000 Credit card receivables—beginning 820,000 600,000 Credit card receviables—ending 880,000 710,000 a. Determine the (1) accounts receivable turnover and (2) the number of days' sales in receivables for both companies. Round...
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...
Accounts Receivable Analysis Bassett Stores Company and Fox Stores Inc. are large retail department stores. Both...
Accounts Receivable Analysis 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 $255,500 $357,700 Credit card receivables—beginning 47,459 81,837 Credit card receivables—ending 39,621 63,007 a. (1) Determine the accounts receivable turnover for both companies. Round to one decimal place. Bassett...
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...
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 $660,000 $600,000 Sales on account 5,638,000 4,528,000 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Open spreadsheet a.) For 20Y2 and 20Y3, determine (1) the accounts receivable turnover and...
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 $135,400 $142,000 $150,000 Sales on account 901,550 861,400 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 2. Number of days' sales in...
Accounts Receivable Analysis The following data are taken from the financial statements of Outdoor Patio Inc....
Accounts Receivable Analysis The following data are taken from the financial statements of Outdoor Patio Inc. Terms of all sales are 2/10, n/60. Year 3 Year 2 Year 1 Accounts receivable, end of year $190,200 $204,000 $219,400 Sales 1,123,470 1,100,840 a. For Years 2 and 3, determine (1) the accounts receivable turnover and (2) the number of days' sales in receivables. Assume there are 365 days in the year. Round intermediate calculations to the nearest whole dollar and final answers...
Accounts Receivable Turnover and Days' Sales in Receivables Quasar, Inc. sells clothing, accessories, and personal care...
Accounts Receivable Turnover and Days' Sales in Receivables Quasar, Inc. sells clothing, accessories, and personal care products for men and women through its retail stores. Quasar reported the following data for two recent years: Year 2 Year 1 Sales $3,831,040 $3,798,190 Accounts receivable 306,600 292,000 Assume that accounts receivable were $335,800 at the beginning of Year 1. a. Compute the accounts receivable turnover for Year 2 and Year 1. Round to one decimal place. Year 2: Year 1: b. Compute...
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
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT