Chapter 15: Q3RQ (page 835)
Question: What is horizontal analysis, and how is a percentage change computed?
Short Answer
Answer
It was used for the analysis of horizontal data over the last years to make decisions.
Chapter 15: Q3RQ (page 835)
Question: What is horizontal analysis, and how is a percentage change computed?
Answer
It was used for the analysis of horizontal data over the last years to make decisions.
All the tools & learning materials you need for study success - in one app.
Get started for freeQuestion: P15-38 Using ratios to evaluate a stock investment
This problem continues the Canyon Canoe Company situation from Chapter 14. The company wants to invest some of its excess cash in trading securities and is considering two investments, The Paddle Company (PC) and Recreational Life Vests (RLV). The income statement, balance sheet, and other data for both companies follow for 2019 and 2018, as well as selected data for 2017:
THE PADDLE COMPANY Comparative Financial Statements Years Ended December 31 | RECREATIONAL LIFE VESTS Comparative Financial Statements Years Ended December 31 | ||||||
Income statement | 2019 | 2018 | 2017 | 2019 | 2018 | 2017 | |
Net sales revenue | \(430,489 | \)425,410 | \(410,570 | \)383,870 | |||
Cost of goods sold | 258,756 | 256,797 | 299,110 | 280,190 | |||
Gross profit | 171,733 | 168,613 | 111,460 | 103,680 | |||
Operating expenses | 153,880 | 151,922 | 78,290 | 70,830 | |||
Operating income | 17,853 | 16,691 | 33,170 | 32,850 | |||
Interest expenses | 865 | 788 | 2,780 | 2,980 | |||
Income before income tax | 16,988 | 15,903 | 30,390 | 29,870 | |||
Income tax expenses | 5,137 | 4,809 | 8,780 | 8,630 | |||
Net income | \(11,851 | \)11,094 | \(21,610 | \)21,240 | |||
Balance sheet | |||||||
Assets | |||||||
Cash & Cash Equivalents | \(69,159 | \)70,793 | \(65,730 | \)55,270 | |||
Accounts Receivable | 44,798 | 44,452 | \(44,104 | 39,810 | 38,650 | \)36,460 | |
Merchandise Inventory | 79,919 | 66,341 | 76,363 | 68,500 | 65,230 | 59,930 | |
Other Current Assets | 15,494 | 16,264 | 24,450 | 37,630 | |||
Total Current Assets | 209,370 | 197,850 | 198,490 | 196,780 | |||
Long-term Assets | 89,834 | 90,776 | 116,760 | 116,270 | |||
Total Assets | \(299,204 | \)288,626 | \(276,482 | \)315,250 | $$313,050 | \(310,640 | |
Liabilities | |||||||
Current Liabilities | \)69,554 | \(60,232 | \)90,810 | \(90,010 | |||
Long-term Liabilities | 31,682 | 29,936 | 96,310 | 105,890 | |||
Total Liabilities | 101,236 | 90,168 | 187,120 | 195,900 | |||
Stockholders’ Equity | |||||||
Common Stock | 72,795 | 80,885 | 111,530 | 102,480 | |||
Retained Earnings | 125,173 | 117,573 | 16,600 | 14,670 | |||
Total Stockholders’ Equity | 197,968 | 198,458 | 128,130 | 117,150 | 103,840 | ||
Total Liabilities and Stockholder’s Equity | \)299,204 | \(288,626 | \)315,250 | \(313,050 | |||
Other data | |||||||
Market price per share | \)21.38 | \(33.82 | \)46.37 | $51.64 | |||
Annual dividend per share | 0.32 | 0.30 | 0.53 | 0.45 | |||
Weighted average number of shares outstanding | 9,000 | 8,000 | 9,000 | 8,000 |
Requirements
a. Current ratio | h. Profit margin ratio |
b. Cash ratio | i. Asset turnover ratio |
c. Inventory turnover | j. Rate of return on common stockholders’ equity |
d. Accounts receivable turnover | k. Earnings per share |
e. Gross profit percentage | l. Price/earnings ratio |
f. Debt ratio | m. Dividend yield |
g. Debt to equity ratio | n. Dividend payout |
Old Mills’s income statement appears as follows (amounts in thousands):
Use the following ratio data to complete Old Mills’s income statement:
1. Inventory turnover is 3.70 (beginning Merchandise Inventory was \(810; ending
Merchandise Inventory was \)770).
2. Profit margin ratio is 14%.
Using ratios to evaluate a stock investment
Comparative financial statement data of Garfield, Inc. follow:
GARFIELD, INC Comparative Income Statement Years Ended December 31, 2018 and 2017 | ||
2018 | 2017 | |
Net sales revenue | \(461,000 | \)424,000 |
Cost of goods sold | 241,000 | 211,000 |
Gross profit | 220,000 | 213,000 |
Operating expenses | 137,000 | 135,000 |
Income from operations | 83,000 | 78,000 |
Interest expenses | 9,000 | 13,000 |
Income before taxes | 74,000 | 65,000 |
Income tax expenses | 18,000 | 24,000 |
Net income | \(56,000 | \)41,000 |
GARFIELD, INC Comparative Income Statement Years Ended December 31, 2018 and 2017 | |||
2018 | 2017 | 2016 | |
Assets | |||
Current assets | |||
Cash | \(99,000 | \)98,000 | |
Accounts receivables, Net | 108,000 | 114,000 | 107,000 |
Merchandise inventory | 146,000 | 164,000 | 202,000 |
Prepaid expenses | 20,000 | 9,000 | |
Total current assets | 373,000 | 385,000 | |
Property, plant, and equipment | 211,000 | 181,000 | |
Total assets | \(584,000 | \)566,000 | \(602,000 |
Liabilities | |||
Total current liabilities | \)227,000 | \(246,000 | |
Long-term liabilities | 117,000 | 100,000 | |
Total liabilities | 344,000 | 346,000 | |
Stockholder’s equity | |||
Preferred stock, 3% | 98,000 | 98,000 | |
Common stockholder equity, no par | 142,000 | 122,000 | 89,000 |
Total liabilities and stockholder’s equity | \)584,000 | \(566,000 |
1. Market price of Garfield’s common stock: \)69.36 at December 31, 2018, and $38.04 at December 31, 2017.
2. Common shares outstanding: 14,000 on December 31, 2018 and 12,000 on December 31, 2017 and 2016.
3. All sales are on credit.
Requirements
1. Compute the following ratios for 2018 and 2017:
a. Current ratio
b. Cash ratio
c. Times-interest-earned ratio
d. Inventory turnover
e. Gross profit percentage
f. Debt to equity ratio
g. Rate of return on common stockholders’ equity
h. Earnings per share of common stock
i. Price/earnings ratio
2. Decide (a) whether Garfield’s ability to pay debts and to sell inventory improved or deteriorated during 2018 and (b) whether the investment attractiveness of its common stock appears to have increased or decreased.
Explaining financial statements
Caleb King is interested in investing in Orange Corporation. What types of tools should Caleb use to evaluate the company?
Monroe Corp. reported the following amounts on its balance sheet at December 31, 2018 and 2017:
2018, 2017
Cash and Receivables \( 35,000 \) 40,000
Merchandise Inventory 20,000 15,000
Property, Plant, and Equipment, Net 80,000 60,000
Total Assets \( 135,000 \) 115,000
Prepare a vertical analysis of Monroe Corp. for 2018 and 2017.
What do you think about this solution?
We value your feedback to improve our textbook solutions.