Question
Ratios from Comparative and Common-Size Data Consider the following financial statements for Nixon Company. During the year, management obtained additional bond financing to enlarge its
Ratios from Comparative and Common-Size Data
Consider the following financial statements for Nixon Company.
During the year, management obtained additional bond financing to enlarge its production facilities. The plant addition produced a new high-margin product, which is supposed to improve the average rate of gross profit and return on sales.
As a potential investor, you decide to analyze the financial statements:
NIXON COMPANY Balance Sheets (Thousands of Dollars) | ||
---|---|---|
Dec. 31, 2019 | Dec. 31, 2018 | |
Assets | ||
Cash | $25,000 | $18,100 |
Accounts receivable (net) | 39,000 | 21,400 |
Inventory | 105,000 | 72,000 |
Prepaid expenses | 1,500 | 4,000 |
Plant and other assets (net) | 463,500 | 427,500 |
Total Assets | $634,000 | $543,000 |
Liabilities and Stockholders Equity | ||
Current liabilities | $80,000 | $48,000 |
9% Bonds payable | 187,500 | 150,000 |
8% Preferred stock, $50 Par Value | 60,000 | 60,000 |
Common stock, $10 Par Value | 225,000 | 225,000 |
Retained earnings | 81,500 | 60,000 |
Total Liabilities and Stockholders Equity | $634,000 | $543,000 |
NIXON COMPANY Income Statements (Thousands of Dollars) | ||
---|---|---|
2019 | 2018 | |
Sales revenue | $850,000 | $697,500 |
Cost of goods sold | 552,000 | 465,000 |
Gross profit on sales | 298,000 | 232,500 |
Selling and administrative expenses | 231,000 | 174,000 |
Income before interest expense and income taxes | 67,000 | 58,500 |
Interest expense | 17,000 | 13,500 |
Income before income taxes | 50,000 | 45,000 |
Income tax expense | 10,000 | 9,000 |
Net income | $40,000 | $36,000 |
Other financial data (thousands of dollars) | ||
Cash provided by operating activities | $28,000 | $24,000 |
Preferred stock dividends | 5,000 | 4,800 |
Required a. Calculate the following for each year: current ratio, quick ratio, operating-cash-flow-to-current- liabilities ratio (current liabilities were $40,000,000 at January 1, 2018), inventory turnover (inventory was $68,000,000 at January 1, 2018), debt-to-equity ratio, times-interest-earned ratio, return on assets (total assets were $490,000,000 at January 1, 2018), and return on common stockholders equity (common stockholders equity was $265,000,000 at January 1, 2018).
b. Calculate commonsize percentage for each years income statement. Round answers to two decimal places.
2019 | 2018 | |||
---|---|---|---|---|
Current ratio: | ||||
Quick ratio: | ||||
Operating-cash-flow-to-current-liabilities ratio: | ||||
Inventory turnover: | ||||
Debt-to-equity ratio: | ||||
Times-interest-earned ratio: | ||||
Return on assets: | % | % | ||
Return on common stockholders' equity: | % | % |
Round answers to one decimal place.
Consolidated Income Statements | ||||
---|---|---|---|---|
Year Ended 2019 | Common- Size | Year Ended 2018 | Common- Size | |
Sales revenue | $850,000 | $697,500 | ||
Cost of goods sold | 552,000 | 465,000 | ||
Gross profit on sales | 298,000 | 232,500 | ||
Selling and administrative expenses | 231,000 | 174,000 | ||
Income before interest expense and income taxes | 67,000 | 58,500 | ||
Interest expense | 17,000 | 13,500 | ||
Income before income taxes | 50,000 | 45,000 | ||
Income tax expense | 10,000 | 9,000 | ||
Net income | $40,000 | $36,000 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started