Question

Calculate the accounts receivable turnover, average collection period (days), inventory turnover, fixed asset turnover, and total asset turnover for each period.

X2 X3 X4 $2,500,000 3.200,000 3,500,000 4,000,000 1.900.000 2400.0002.700.000 3200.000 800,000 400,00D 25,000 200,000 10.000 20.000 30.000 60.000 15,000 107,500 COST OF GOODS SOLD GROSS PROFIT SELLING & ADMINISTRATIVE EXPENSE DEPRECIATION LEASES MISCELLANEOUS EXPENSE 600,000 400,000 800,000 800,000 400,000 160,000 190,000 138,700 25,000 175,000 170,000 89,000 EARNINGS BEFORE INTEREST & TAXES INTEREST EARNINGS BEFORE TAXES TAXES (35%) NET INCOME DIVIDENDS RETAINED EARNINGS 125,000 87,000 56,550 7,850 50,000 40,000 CASH ACCOUNTS RECEIVABLE INVENTORY S 65,000 285,000 50,000 600,000 300,000 10 000 50,000 45,000 700,000 400,000 CURRENT ASSETS GROSS PLANT& EQUIPMENT 650,000 1,320,000 400,000 400,000 400,000 ACCUMULATED DEPRECIATION NET PLANT & EQUIPMENT OTHER FIXED ASSETS TOTAL ASSETS 100,000 150,000 1750 200,000 200,000 250,000 225,000 200,000 50,00060.00075000 85000 $900,000 ,120,000 1450,000 1,605,000 ACCOUNTS PAYABLE ACCRUALS NOTES PAYABLE 175,000 80,000 100000 170.000 250,000 250.000 50,000 90,000 60,000 140,000 60,000 450,000 450,000 CURRENT LIABILITIES 200,000 LONG-TERM DEBT 280,000 150,000 300,000 150,000 550,000 COMMON STOCK (at par) RETAINED EARNINGS 150,000 270,000 350,000 400.000 400.000 TOTAL LIABILITIES $900,000 1,120,000 1,450,000 AND OWNERS EQUITY

Answer 1

Accounts Receivable (Debtors) Turnover Ratio = $\frac{Net Credit Sales}{Accounts Receivables}$

Since no information is given in the question regarding credit sales hence we assume that all sales are on credit.

Average collection Period = $\frac{365 days}{Accounts Receivables Turnover Ratio}$

X1 X2 X3 X4 365 days 8.77 times 42 days 365 days 8 times 46 days 365 days 5.83 times 63 days 365 days 5.71 times 64 days Average collection Period

Inventory Turnover Ratio = $\frac { Cost of goods sold }{ Inventory of Finished Good }$

Fixed Asset Turnover Ratio = $\frac { Net Sales }{ Net Fixed assets }$

X1 X2 X3 2500000 250000 10 times 3200000 310000 10.32 times 3500000 300000 11.67 times 4000000 285000 14.04 times Fixed Asset Turnover Ratio

Total asset Turnover ratio = $\frac { Net Sales }{ Total assets }$