Q49. Example II-B
Using the information presented below, calculate the solvency and activity ratios.
[Financial information]
Cash = $370,000
Accounts receivable = $780,000
Inventory = $970,000
Current assets = $2,120,000
Property, plant and equipment = $4,380,000
Total assets = $6,500,000
Accounts payable = $650,000
Short-term borrowings = $830,000
Current liabilities = $1,480,000
Long-term liabilities = $1,620,000
Total liabilities = $3,100,000
Total stockholders’ equity = $3,400,000
Total liabilities and stockholders’ equity = $6,500,000
Average accounts receivable = $740,000
Average inventory = $960,000
Average total assets = $6,250,000
Average accounts payable = $625,000
Average stockholders’ equity = $3,260,000
Cash sales = $1,150,000
Credit sales = $6,400,000
Sales = $7,550,000
Cost of goods sold = $4,830,000
Credit purchases = $4,720,000
Gross profit = $2,720,000
Earnings before interest and taxes (EBIT) = $1,550,000
Interest expense = $250,000
Tax expense = $410,000
Net income = $890,000
[Financial ratios to be calculated]
(1) Solvency ratios
a. Debt to equity ratio
b. Debt to assets ratio
c. Long-term debt to assets ratio
d. Times interest earned ratio
e. Assets to equity ratio
(2) Activity ratios
a. Assets turnover ratio
b. Inventory turnover ratio
c. Accounts receivable turnover ratio
d. Accounts payable turnover ratio
A49.
(1) Solvency ratios
a. Debt to equity ratio = 0.91
b. Debt to assets ratio = 0.48
c. Long-term debt to assets ratio = 0.25
d. Times interest earned ratio = 6.20
e. Assets to equity ratio = 1.92
(2) Activity ratios
a. Assets turnover ratio = 1.21
b. Inventory turnover ratio = 5.03
c. Accounts receivable turnover ratio = 8.65
d. Accounts payable turnover ratio = 7.55
[Note]
(1) Solvency ratios
a. Debt to equity ratio
= Total liabilities / Total stockholders’ equity
= $3,100,000 / $3,400,000 = 0.91
b. Debt to assets ratio
= Total liabilities / Total assets
= $3,100,000 / $6,500,000 = 0.48
c. Long-term debt to assets ratio
= Long-term liabilities / Total assets
= $1,620,000 / $6,500,000 = 0.25
d. Times interest earned ratio
= Earnings before interest and taxes (EBIT) / Interest expense
= (Net income + Interest expense + Tax expense) / Interest expense
= ($890,000 + $250,000 + $410,000) / $250,000
= $1,550,000 / $250,000 = 6.20
e. Assets to equity ratio
= Average total assets / Average stockholders’ equity
= $6,250,000 / $3,260,000 = 1.92
(2) Activity ratios
a. Assets turnover ratio
= Sales / Average total assets
= $7,550,000 / $6,250,000 = 1.21
b. Inventory turnover ratio
= Cost of goods sold / Average inventory
= $4,830,000 / $960,000 = 5.03
c. Accounts receivable turnover ratio
= Credit sales / Average accounts receivable
= $6,400,000 / $740,000 = 8.65
d. Accounts payable turnover ratio
= Credit purchases / Average accounts payable
= $4,720,000 / $625,000 = 7.55
© AccountingInfo.com