below are amounts (in millions) from three companies annual reports.\n\n| | beginning accounts receivable |…

below are amounts (in millions) from three companies annual reports.\n\n| | beginning accounts receivable | ending accounts receivable | net sales |\n|--|--|--|--|\n| walco | $1,665 | $2,612 | $307,427 |\n| tarmart | 5,416 | 5,944 | 52,878 |\n| costget | 479 | 515 | 53,963 |\n\nrequired:\n\n1. calculate the receivables turnover ratio and the average collection period for walco, tarmart and costget\n2. which company appears most efficient in collecting cash from sales?\n\ncomplete this question by entering your answers in the tabs below.\n\n| | | receivables turnover ratio | | |\n|--|--|--|--|--|\n| | choose numerator | choose denominator | = | receivables turnover ratio |\n| walco | | | | times |\n| tarmart | | | | times |\n| costget | | | | times |\n\n| | | average collection period | | |\n|--|--|--|--|--|\n| | choose numerator | choose denominator | = | average collection period |\n| walco | | | | days |\n| tarmart | | | | days |\n| costget | | | | days |

below are amounts (in millions) from three companies annual reports.\n\n| | beginning accounts receivable | ending accounts receivable | net sales |\n|--|--|--|--|\n| walco | $1,665 | $2,612 | $307,427 |\n| tarmart | 5,416 | 5,944 | 52,878 |\n| costget | 479 | 515 | 53,963 |\n\nrequired:\n\n1. calculate the receivables turnover ratio and the average collection period for walco, tarmart and costget\n2. which company appears most efficient in collecting cash from sales?\n\ncomplete this question by entering your answers in the tabs below.\n\n| | | receivables turnover ratio | | |\n|--|--|--|--|--|\n| | choose numerator | choose denominator | = | receivables turnover ratio |\n| walco | | | | times |\n| tarmart | | | | times |\n| costget | | | | times |\n\n| | | average collection period | | |\n|--|--|--|--|--|\n| | choose numerator | choose denominator | = | average collection period |\n| walco | | | | days |\n| tarmart | | | | days |\n| costget | | | | days |

Answer

Explanation:

Step1: Calculate average accounts receivable

The formula for average accounts - receivable is $\text{Average Accounts Receivable}=\frac{\text{Beginning Accounts Receivable}+\text{Ending Accounts Receivable}}{2}$. For WalCo: $\text{Average Accounts Receivable}{WalCo}=\frac{1665 + 2612}{2}=\frac{4277}{2}=2138.5$ (in millions). For TarMart: $\text{Average Accounts Receivable}{TarMart}=\frac{5416+5944}{2}=\frac{11360}{2}=5680$ (in millions). For CostGet: $\text{Average Accounts Receivable}_{CostGet}=\frac{479 + 515}{2}=\frac{994}{2}=497$ (in millions).

Step2: Calculate receivables turnover ratio

The formula for receivables turnover ratio is $\text{Receivables Turnover Ratio}=\frac{\text{Net Sales}}{\text{Average Accounts Receivable}}$. For WalCo: $\text{Receivables Turnover Ratio}{WalCo}=\frac{307427}{2138.5}\approx143.7$ (times). For TarMart: $\text{Receivables Turnover Ratio}{TarMart}=\frac{52878}{5680}\approx9.3$ (times). For CostGet: $\text{Receivables Turnover Ratio}_{CostGet}=\frac{53963}{497}\approx108.6$ (times).

Step3: Calculate average collection period

The formula for average collection period is $\text{Average Collection Period}=\frac{365}{\text{Receivables Turnover Ratio}}$. For WalCo: $\text{Average Collection Period}{WalCo}=\frac{365}{143.7}\approx2.5$ (days). For TarMart: $\text{Average Collection Period}{TarMart}=\frac{365}{9.3}\approx39.2$ (days). For CostGet: $\text{Average Collection Period}_{CostGet}=\frac{365}{108.6}\approx3.4$ (days).

Answer:

Receivables Turnover Ratio

Company Numerator (Net Sales) Denominator (Average Accounts Receivable) Receivables turnover ratio (times)
WalCo $307427$ (in millions) $2138.5$ (in millions) $143.7$
TarMart $52878$ (in millions) $5680$ (in millions) $9.3$
CostGet $53963$ (in millions) $497$ (in millions) $108.6$

Average Collection Period

Company Numerator ($365$) Denominator (Receivables Turnover Ratio) Average collection period (days)
WalCo $365$ $143.7$ $2.5$
TarMart $365$ $9.3$ $39.2$
CostGet $365$ $108.6$ $3.4$
  1. WalCo appears most efficient in collecting cash from sales as it has the highest receivables - turnover ratio and the shortest average collection period among the three companies.