Answer to Accounting Test Question IFS No 1:

Inventory turnover ratio

=  Cost of Goods Sold/ Average Inventory Value

= $3,000,000/(830,000+710,000)/2

=$3,000,000/$770,000

= 3.89 times

Receivables turnover ratio

= Net Turnover/(Average Accounts Receivable)

=$7,000,000/($810,000+620,000)/2

= 9.79 times

Therefore,

Average collection period

=365 days/ 9.79

=37.28 days

Asset turnover ratio

= Net Turnover/ (Average Total Asset)

=$7,000,000/($4,430,000+3,990,000)/2

=1.66 times

Comparison of Company XYZ vs Industry Average

Tabulate above the efficiency of Company XYZ’s efficiency in asset management.

Company XYZ turns its inventory over 3.9 times per year compared to the industry average of 5 times per year. Its asset turnover ratio is also slightly better than the industry average (1.66 times per year versus 2 times).

These ratios indicated that Company XYZ is able to generate sales per dollar invested in inventory and in total assets than the industry averages.

Also, Company XYZ is able to collect its receivables quicker than the industry average ( 37.28 days compared to industry average of 45 days)