In: Finance
Using the financial statements for the Snider Corporation,
calculate the 13 basic ratios found in the
chapter.
SNIDER CORPORATION Balance Sheet December 31, 20X1 |
|||
Assets | |||
Current assets: | |||
Cash | $ | 58,700 | |
Marketable securities | 23,200 | ||
Accounts receivable (net) | 230,000 | ||
Inventory | 247,000 | ||
Total current assets | $ | 558,900 | |
Investments | 64,100 | ||
Plant and equipment. | $695,000 | ||
Less: Accumulated depreciation | 216,000 | ||
Net plant and equipment | 479,000 | ||
Total assets | $ | 1,102,000 | |
Liabilities and Stockholders' Equity | |||
Current liabilities: | |||
Accounts payable | $ | 96,900 | |
Notes payable | 75,700 | ||
Accrued taxes | 16,400 | ||
Total current liabilities | $ | 189,000 | |
Long-term liabilities: | |||
Bonds payable | 158,700 | ||
Total liabilities | $ | 347,700 | |
Stockholders' equity | |||
Preferred stock, $50 par value | $ | 100,000 | |
Common stock, $1 par value | 80,000 | ||
Capital paid in excess of par | 190,000 | ||
Retained earnings | 384,300 | ||
Total stockholders' equity | $ | 754,300 | |
Total liabilities and stockholders' equity | $ | 1,102,000 | |
SNIDER CORPORATION Income Statement For the Year Ending December 31, 20X1 |
|||
Sales (on credit) | $ | 2,024,000 | |
Cost of goods sold | 1,354,000 | ||
Gross profit | $ | 670,000 | |
Selling and administrative expenses | 511,000 | * | |
Operating profit (EBIT) | $ | 159,000 | |
Interest expense | 31,600 | ||
Earnings before taxes (EBT) | $ | 127,400 | |
Taxes | 89,400 | ||
Earnings after taxes (EAT) | $ | 38,000 | |
*Includes $40,800 in lease payments.
Using the above financial statements for the Snider Corporation,
calculate the following ratios.
a. Profitability ratios. (Do not round
intermediate calculations. Input your answers as a percent rounded
to 2 decimal places.)
b. Assets utilization ratios. (Do not
round intermediate calculations. Round your answers to 2 decimal
places.)
c. Liquidity ratios. (Do not round
intermediate calculations. Round your answers to 2 decimal
places.)
d. Debt utilization ratios. (Do not round
intermediate calculations. Input your debt to total assets answer
as a percent rounded to 2 decimal places. Round your other answers
to 2 decimal places.)
Calculation | Ratio | |||
a) | PROFITABILITY RATIOS: | |||
Profit margin | =38000/2024000 = | 1.88% | ||
Return on assets (investment) | =38000/1102000 = | 3.45% | ||
Return on equity | =38000/754300 = | 5.04% | ||
b) | ASSET UTILIZATION RATIOS: | |||
Receivable turnover | =2024000/230000 = | 8.80 | times | |
Average collection period | =365/8.8 = | 41.48 | days | |
Inventory turnover | =1354000/247000 = | 5.48 | times | |
Fixed asset turnover | =2024000/479000 = | 4.23 | times | |
Total asset turnover | =2024000/1102000 = | 1.84 | times | |
c) | LIQUIDITY RATIOS; | |||
Current ratio | =558900/189000 = | 2.96 | times | |
Quick ratio | =(58700+23200+230000)/189000 = | 1.65 | times | |
d) | DEBT UTILIZATION RATIOS: | |||
Debt to total assets | =347700/1102000 = | 0.32 | times | |
Times interest earned | =159000/31600 = | 5.03 | times | |
Fixed charge coverage ratio | =(159000+40800)/(31600+40800) = | 2.76 | times |