Question

In: Accounting

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.

Solutions

Expert Solution

Xavier Lestrade
1. Accounts receivable turnover 10.0 7.0
2. Number of days' sales in receivables 36.5 52.1
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.
Workings:
Average Receivables:
Xavier 850000 =(820000+880000)/2
Lestrade 655000 =(600000+710000)/2
Xavier Lestrade
Sales 8500000 4585000
Divide by Average Receivables 850000 655000
Accounts receivable turnover 10.0 7.0
Xavier Lestrade
Days in a year 365 365
Divide by Accounts receivable turnover 10.0 7.0
Number of days' sales in receivables 36.5 52.1

Related Solutions

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 $292,000 $408,800 Credit card receivables—beginning 44,298 40,499 Credit card receivables—ending 36,982 31,181 a. (1) Determine the accounts receivable turnover for both companies. Round to one decimal place. Bassett...
You are consulting with the manager of an Accounts Receivable department of a large manufacturing company....
You are consulting with the manager of an Accounts Receivable department of a large manufacturing company. The manager is concerned that some of the customer accounts are not being paid promptly under the current payment terms. The current payment terms specify 14 days for receipt of payment of all bills. Since the manager did not have any hard evidence, you suggested that the manager collect some data that could then be analyzed. Based on your advice, the manager collects a...
BeachTime Company uses a perpetual inventory system and both an accounts receivable and an accounts payable...
BeachTime Company uses a perpetual inventory system and both an accounts receivable and an accounts payable subsidiary ledger. Balances related to both the general ledger and the subsidiary ledger for the company are indicated in the working papers. Below are a series of transactions for BeachTime Co. for the month of January. Credit sales terms are 2/10, n/30. The cost of all merchandise sold was 57% of the sales price. Jan.3  Sell merchandise on account to M. Knast $2,900, invoice...
BeachTime Company uses a perpetual inventory system and both an accounts receivable and an accounts payable...
BeachTime Company uses a perpetual inventory system and both an accounts receivable and an accounts payable subsidiary ledger. Balances related to both the general ledger and the subsidiary ledger for the company are indicated in the working papers. Below are a series of transactions for BeachTime Co. for the month of January. Credit sales terms are 2/10, n/30. The cost of all merchandise sold was 57% of the sales price. Jan.3  Sell merchandise on account to M. Knast $2,900, invoice...
High Inc. has an accounts receivable turnover ratio of 7.3. Low Company has an accounts receivable...
High Inc. has an accounts receivable turnover ratio of 7.3. Low Company has an accounts receivable turnover ratio of 5. Assuming that High and Low have the same sales​ level, which of the following statements is​ correct? A. Low Company has​ (on average) a lower accounts receivable balance than does High. B. ​Low's average collection period is less than​ High's. C. ​High's average collection period is less than​ Low's. D. High has a higher accounts receivable balance on average than...
King Company makes a single product that it sells to retail stores. The firm’s finishing department...
King Company makes a single product that it sells to retail stores. The firm’s finishing department uses hand labor to perform its work on all products. A proposal has been made by the company’s vice president to acquire machinery that will perform most of the functions of this department. The finishing department has consistently produced 50,000 units a year, and that is the estimated production for the foreseeable future. A summary of the manufacturing costs of the department follows:   ...
A chocolate company markets a 500g box of chocolates to large retail stores for Valentine’s Day....
A chocolate company markets a 500g box of chocolates to large retail stores for Valentine’s Day. This year, they project the mean order quantity will be greater than last year. Last year, the mean order quantity was 500 boxes per large retail store. This year, a random sample of 4 large retail stores gave a sample mean order quantity of 490 boxes. Assume a population standard deviation of 50 boxes, and that the mean order quantity follows a Normal distribution....
A chocolate company markets a 500g box of chocolates to large retail stores for Valentine’s Day....
A chocolate company markets a 500g box of chocolates to large retail stores for Valentine’s Day. This year, they project the mean order quantity will be greater than last year. Last year, the mean order quantity was 500 boxes per large retail store. This year, a random sample of 4 large retail stores gave a sample mean order quantity of 490 boxes. Assume a population standard deviation of 50 boxes, and that the mean order quantity follows a Normal distribution....
A chocolate company markets a 500g box of chocolates to large retail stores for Valentine’s Day....
A chocolate company markets a 500g box of chocolates to large retail stores for Valentine’s Day. This year, they project the mean order quantity will be greater than last year. Last year, the mean order quantity was 500 boxes per large retail store. This year, a random sample of 4 large retail stores gave a sample mean order quantity of 490 boxes. Assume a population standard deviation of 50 boxes, and that the mean order quantity follows a Normal distribution....
Bayview Manufacturing Company has an accounts receivable department that performs three activities within the department: invoicing...
Bayview Manufacturing Company has an accounts receivable department that performs three activities within the department: invoicing customers, processing customer credit applications, and performing collection activities. During interviews, the employee survey reports that they spend 15 percent of their time invoicing customers, 55 percent of their time processing credit applications, and 30 percent of their time on collection activities. The accounts receivable department employs 10 associates for a total monthly cost of $50,000. Assume each associate works 8 hours per day,...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT