Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the financial data below for the Example Company, and assess the value of the Company. All figures are 000s except for share price. Example
Consider the financial data below for the Example Company, and assess the value of the Company. All figures are 000s except for share price.
Example Company | ||||||||||||||||||||||||||||||||||
Selected Financial Data | ||||||||||||||||||||||||||||||||||
Account Description | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | ||||||||||||||||||||||||||||
Cash | 25,141 | 25,639 | 32,977 | 34,009 | 49,851 | 30,943 | ||||||||||||||||||||||||||||
Accounts receivable | 272,450 | 312,776 | 368,267 | 419,731 | 477,324 | 542,751 | ||||||||||||||||||||||||||||
Prepaids | 3,982 | 4,402 | 5,037 | 5,246 | 5,378 | 6,648 | ||||||||||||||||||||||||||||
Inventories | 183,722 | 208,623 | 222,128 | 260,492 | 298,696 | 399,533 | ||||||||||||||||||||||||||||
Property & equipment (net) | 47,578 | 49,931 | 55,311 | 61,832 | 77,173 | 91,420 | ||||||||||||||||||||||||||||
Other assets | 18,734 | 20,738 | 23,075 | 26,318 | 36,248 | 39,403 | ||||||||||||||||||||||||||||
Total assets | 551,607 | 622,109 | 706,795 | 807,628 | 944,670 | 1,110,698 | ||||||||||||||||||||||||||||
Accounts payable | 49,831 | 64,321 | 70,853 | 80,861 | 94,677 | 78,789 | ||||||||||||||||||||||||||||
Accrued expenses | 86,087 | 102,650 | 113,732 | 131,899 | 143,159 | 164,243 | ||||||||||||||||||||||||||||
Notes payable | 99,539 | 118,305 | 182,132 | 246,420 | 237,741 | 390,034 | ||||||||||||||||||||||||||||
Long-term debt | 62,622 | 43,251 | 35,407 | 32,301 | 128,432 | 126,672 | ||||||||||||||||||||||||||||
Deferred taxes payable | 7,551 | 7,941 | 8,286 | 8,518 | 9,664 | 11,926 | ||||||||||||||||||||||||||||
Other liabilities | 5,279 | 5,521 | 5,697 | 5,593 | 5,252 | 4,695 | ||||||||||||||||||||||||||||
Total liabilities | 310,909 | 341,989 | 416,107 | 505,592 | 618,925 | 776,359 | ||||||||||||||||||||||||||||
Capital stock | 73,253 | 87,581 | 79,009 | 71,601 | 81,238 | 73,186 | ||||||||||||||||||||||||||||
Retained earnings | 167,445 | 192,539 | 211,679 | 230,435 | 244,507 | 261,153 | ||||||||||||||||||||||||||||
Total stockholders equity | 240,698 | 280,120 | 290,688 | 302,036 | 325,745 | 334,339 | ||||||||||||||||||||||||||||
Total liabilities & equity | 551,607 | 622,109 | 706,795 | 807,628 | 944,670 | 1,110,698 | ||||||||||||||||||||||||||||
Net sales | 982,244 | 1,095,083 | 1,214,666 | 1,259,116 | 1,378,251 | 1,648,500 | ||||||||||||||||||||||||||||
Cost of goods sold | 669,560 | 739,459 | 817,671 | 843,192 | 931,237 | 1,125,261 | ||||||||||||||||||||||||||||
Depreciation expense | 8,303 | 8,380 | 8,972 | 9,619 | 10,577 | 12,004 | ||||||||||||||||||||||||||||
Interest expense | 11,248 | 13,146 | 14,919 | 18,874 | 16,562 | 21,128 | ||||||||||||||||||||||||||||
Income tax expense | 26,650 | 34,000 | 38,000 | 32,800 | 26,500 | 25,750 | ||||||||||||||||||||||||||||
Dividends paid | 13,805 | 17,160 | 19,280 | 20,426 | 20,794 | 20,807 | ||||||||||||||||||||||||||||
Net income | 32,563 | 37,895 | 41,809 | 39,577 | 35,212 | 37,787 | ||||||||||||||||||||||||||||
Number of common shares outstanding at year-end | 12,817 | 13,714 | 13,728 | 13,684 | 14,023 | 13,993 | ||||||||||||||||||||||||||||
Market price per share | 38 | 43 | 55 | 65 | 43 | 31 | ||||||||||||||||||||||||||||
Required:
1. Compute the liquidity and profitability ratios. (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places.)
Liquidity Ratios 2014 2015 2016 2017 2018 2019 A/R turnover Current ratio Quick ratio (Acid test) Inventory turnover Cash flow ratio Profitability Ratios 2014 2015 2016 2017 2018 2019 Return on total assets % % % % % % Return on equity % % % % % % Gross margin % % % % % % % Earnings per share
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