Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / In the table below is data for two companies in a competitive industry

In the table below is data for two companies in a competitive industry

Finance

In the table below is data for two companies in a competitive industry. ($000) Company A Company B Revenues(sales) 132470 93440 Cost of Goods Sold 43645 49828 Average inventory 7358 8714 Average receivable 5551 7318 Average payable 7054 8663 Calculate the turnover ratios and evaluate the relative performance (operating efficiency) of both companies.

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

The turnover ratios are calculated as below:

Accounts Receivable Turnover Ratio

The value of accounts receivable turnover ratio for each company is calculated as below:

Accounts Receivable Turnover Ratio = Net Sales/Average Receivable

Using the values provided in the question, we get,

Company A = 132,470/5,551 = 23.86

Company B = 93,440/7,318 = 12.77

_____

Inventory Turnover Ratio

The value of inventory turnover ratio for each company is determined as follows:

Inventory Turnover Ratio = Cost of Goods Sold/Average Inventory

Using the values provided in the question, we get,

Company A = 43,645/7,358 = 5.93

Company B = 49,828/8,714 = 5.72

_____

Accounts Payable Turnover Ratio

The value of accounts payable turnover ratio for each company is arrived as below:

Accounts Payable Turnover Ratio = Cost of Goods Sold/Average Payable

Using the values provided in the question, we get

Company A = 43,645/7,054 = 6.19

Company B = 49,828/8,663 = 5.75

_____

Evaluation:

Based on the values calculated above, it can be concluded that Company A is operating more efficiently than Company B. This is evident from the fact that Company A is able to collect its receivables faster than Company B as it has a high accounts receivable turnover ratio of 23.86. Inventory turnover ratio indicates how quickly the company is able to sell its inventory and replace it. Again, for Company A, this ratio is higher at 5.93 as compared to Company B having a ratio of 5.72. Further, Company A is able to pay its suppliers more quickly as compared to Company B. This is indicated by the value of high accounts payable turnover ratio for Company A (6.19) when compared with Company B (5.75).