Question

In: Accounting

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 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 days
Fox Stores days

Solutions

Expert Solution

(1).

Bassett Stores

7.2

Fox Stores

11.4

Explanation;

Formula for Accounts receivable turnover ratio = (Net credit sales / Average accounts receivable)

Accounts receivable turnover for Bassett Stores;

Net credit sales is given = $292000

Average accounts receivable ($44298 + $36982 / 2) = $40640

Accounts receivable turnover ratio ($292000 / $40640) = 7.2 (Approx.)

Accounts receivable turnover for Fox Stores;

Net credit sales is given = $408800

Average accounts receivable ($40499 + $31181 / 2) = $35840

Accounts receivable turnover ratio ($408800 / $35840) = 11.4 (Approx.)

(2).

Bassett Stores

50.7 days

Fox Stores

32 days

Explanation;

Formula for days' sales in receivables = (365 / Accounts receivable turnover ratio)

Days' sales in receivables for Bassett Stores;

Number of days = 365

Accounts receivable turnover ratio = 7.2

Days’ sales in receivable (365 / 7.2) = 50.7 days

Days' sales in receivables for Fox Stores;

Number of days = 365

Accounts receivable turnover ratio = 11.4

Days’ sales in receivable (365 / 11.4) = 32.01 days OR 32 days


Related Solutions

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...
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