Solved

(CMA Jun 96 #6) All-Things Inc  Selected Financial Ratios \text { Selected Financial Ratios }

Question 148

Essay

(CMA Jun 96 #6) All-Things Inc.manufactures a variety of consumer products.The company's founders have managed the company for thirty years and are now interested in retiring.Consequently, they are seeking to sell the company.Trial Associates is looking into the acquisition of All-Things and has requested the latest financial statements and selected financial ratios in order to evaluate All-Things' financial stability and operating efficiency.The summary information provided by All-Things is presented below.
All-Things Inc.
Income Statement
For the Year Ended May 31, Year 6
(in thousands)
 Sales (net) $30,500 Interest income 500 Total revenue $31.000 Costs and expenses:  Cost of goods sold 17,600 Selling and administrative expense 3,550 Depreciation and amortization expense 1,890 Interest expense 900 Total costs and expenses $23,940 Income before taxes 7,060 Income taxes 2.900 Net income $4,160\begin{array}{lr}\text { Sales (net) } & \$ 30,500 \\\text { Interest income } & 500 \\\text { Total revenue } & \$ 31.000\\\text { Costs and expenses: } & \\\text { Cost of goods sold } & 17,600 \\\text { Selling and administrative expense } & 3,550 \\\text { Depreciation and amortization expense } &1,890 \\\text { Interest expense } &900 \\\text { Total costs and expenses }&\$23,940\\\text { Income before taxes } & 7,060 \\\text { Income taxes } & 2.900\\\text { Net income }&\$4,160\end{array}
 Selected Financial Ratios \text { Selected Financial Ratios }
 5-Year  All-Things  Industry  Year 4 Year 5 Average  Current ratio 1.621.611.63 Acid-test ratio .63.64.68 Total asset turnover 1.831.841.84 Inventory turnover 3.213.173.18 Times interest earned 8.508.558.45 Total debt to net worth (Total debt / Total shareholders’ equity) 1.02.861.03 Net profit margin 12.1%13.2%13.0%\begin{array}{llll}&& \text { 5-Year } \\&\text { All-Things } & \text { Industry } & \\ & \text { Year } 4 & \text { Year } 5 & \text { Average }\\\hline\text { Current ratio } & 1.62 & 1.61 & 1.63 \\\text { Acid-test ratio } & .63 & .64 & .68 \\\text { Total asset turnover } & 1.83 & 1.84 & 1.84 \\\text { Inventory turnover } & 3.21 & 3.17 & 3.18 \\\text { Times interest earned } & 8.50 & 8.55 & 8.45 \\\text { Total debt to net worth (Total debt / Total shareholders' equity) } & \mathbf{1 . 0 2} & .86 & \mathbf{1 . 0 3} \\\text { Net profit margin } & 12.1 \% & 13.2 \% & 13.0 \%\end{array}
 5- yearIndusty All-Things  Average  Yean 5 Year 41.631.611.62 Currentratio.68.64.63Acichtest ratio 1.841.841.83Total asset turnover 3.183.173.21Inventory turnover 8.458.558.50 Times interest earned1.03861.02Total debt to net worth (Total debt / Total shareholders’ equity) 13.0%13.2%12.1%Net profit margin \begin{array}{llll} \text { 5- year}\\ \text {Industy }& \text {All-Things }\\\text { Average } & \text { Yean } 5 & \text { Year } 4\\1.63 & 1.61 & 1.62 & \text { Currentratio}\\.68 & .64 & .63 & \text {Acichtest ratio }\\1.84 & 1.84 & 1.83& \text {Total asset turnover } \\3.18 & 3.17 & 3.21& \text {Inventory turnover } \\8.45 & 8.55 & 8.50 & \text { Times interest earned}\\\mathbf{1 . 0 3} & \mathbf{8 6} & \mathbf{1 . 0 2} & \text {Total debt to net worth (Total debt / Total shareholders' equity) }\\13.0 \% & 13.2 \% & 12.1 \%& \text {Net profit margin }\end{array} All-Things Inc.
Comparative Statement of Financial Position
As of May 31
(In thousands)
 Year 6 Year 7 Cash $400$500 Marketable securities (at cost) 500200 Accounts receivable (net) 3,2002,900 Inventory 5,8005,400 Total current assets $9,900$9,000 Property, plant, and equipment (net) 7.1007,000 Total assets $17,000$16,000 Accounts payable $3,700$3,400 Income taxes payable 900800 Accrued expenses 1.7001.400 Total current liabilities $6,300$5,600 Long-term debt 2.0001.800 Total liabilities $8,300$7,400 Common stock ( $1 par value) 2,7002,700 Paid-in-capital in excess of par 1,0001,000 Retained earnings 5,0004,900 Total shareholders’ equity $8.700$8.600 Total liabilities and shareholders’ equity $17.000$16.000\begin{array}{lll}&\text { Year } 6&\text { Year } 7\\\text { Cash } & \$ 400 & \$ 500 \\\text { Marketable securities (at cost) } & 500 & 200 \\\text { Accounts receivable (net) } & 3,200 & 2,900 \\\text { Inventory } &5,8 0 0 & 5,400 \\\text { Total current assets } & \overline{\$ 9,900} & \overline{\$ 9,000} \\\text { Property, plant, and equipment (net) } & 7.100 & 7,000\\\text { Total assets }&\$17,000&\$16,000\\\\\text { Accounts payable } & \$ 3,700 & \$ 3,400 \\\text { Income taxes payable } & 900 & 800 \\\text { Accrued expenses } & 1.700 & 1.400 \\\text { Total current liabilities } & \$ 6,300 & \$ 5,600 \\\text { Long-term debt } &2.000 & 1.800 \\\text { Total liabilities }&\$8,300&\$7,400\\\\\text { Common stock ( } \$ 1 \text { par value) } & 2,700 & 2,700 \\\text { Paid-in-capital in excess of par } & 1,000 & 1,000 \\\text { Retained earnings } & 5,000 & 4,900\\\text { Total shareholders' equity }&\$ 8.700 & \$ 8.600\\\text { Total liabilities and shareholders' equity }&\$ 17.000 & \$ 16.000\end{array} Required:
a. Calculate a new set of ratios for the fiscal Year 6 for All-Things Inc. based on the financial statements presented.
b. Briefly explain the analytical use of each of the seven ratios presented, describing what the investors can learn about All-Things Inc.'s financial stability and operating efficiency.
c. Identify two limitations of ratio analysis.

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents