Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using the provided 3 years worth of financial statements for your chosen company, perform a ratio analysis for the below key ratios and write a
Using the provided 3 years worth of financial statements for your chosen company, perform a ratio analysis for the below key ratios and write a 2 -3 page analysis of your findings. Be sure to compare and contrast your data, including your interpretation of the data. Also, embed the results from your Excel spreadsheet in the appendix of your Word document.
Liquidity
- Current ratio
- Quick ratio
Asset utilization
- Inventory turnover
- Total asset turnover
Debt utilization
- Debt to total assets
- Times interest earned
Profitability ratios
- Profit margin
ROE (DuPont Formula)
| Balance Sheet | ||||
| All numbers in thousands | ||||
| Period Ending | 12/31/2017 | 12/31/2016 | 12/31/2015 | 12/31/2014 |
| Current Assets | ||||
| Cash And Cash Equivalents | 11,212,000 | 9,774,000 | 12,138,000 | 15,954,000 |
| Short Term Investments | 8,313,000 | 11,841,000 | 7,582,000 | 9,222,000 |
| Net Receivables | 8,164,000 | 8,700,000 | 8,337,000 | 9,078,000 |
| Inventory | 10,663,000 | 11,040,000 | 13,764,000 | 13,642,000 |
| Other Current Assets | 3,831,000 | 14,619,000 | 4,510,000 | 15,092,000 |
| Total Current Assets | 68,744,000 | 76,203,000 | 69,408,000 | 83,626,000 |
| Long Term Investments | 7,886,000 | 8,052,000 | 9,201,000 | 8,350,000 |
| Property Plant and Equipment | 36,253,000 | 32,603,000 | 31,229,000 | 27,743,000 |
| Goodwill | 490,000 | 490,000 | - | - |
| Intangible Assets | 3,959,000 | 4,259,000 | 4,547,000 | 4,983,000 |
| Accumulated Amortization | - | - | - | - |
| Other Assets | 27,946,000 | 45,918,000 | 39,350,000 | 27,695,000 |
| Deferred Long Term Asset Charges | 23,544,000 | 33,172,000 | 36,860,000 | 25,414,000 |
| Total Assets | 212,482,000 | 221,690,000 | 194,338,000 | 177,501,000 |
| Current Liabilities | ||||
| Accounts Payable | 23,929,000 | 23,333,000 | 24,062,000 | 22,529,000 |
| Short/Current Long Term Debt | - | - | - | - |
| Other Current Liabilities | 8,507,000 | 20,112,000 | 10,765,000 | 11,293,000 |
| Total Current Liabilities | 76,890,000 | 85,181,000 | 71,217,000 | 65,657,000 |
| Long Term Debt | 10,544,000 | 9,500,000 | 7,948,000 | 8,853,000 |
| Other Liabilities | 32,138,000 | 41,108,000 | 39,249,000 | 44,099,000 |
| Deferred Long Term Liability Charges | - | - | - | - |
| Minority Interest | 1,199,000 | 239,000 | 452,000 | 567,000 |
| Negative Goodwill | - | - | - | - |
| Total Liabilities | 176,282,000 | 177,615,000 | 154,015,000 | 141,477,000 |
| Stockholders' Equity | ||||
| Misc. Stocks Options Warrants | - | - | - | - |
| Redeemable Preferred Stock | - | - | - | - |
| Preferred Stock | - | - | - | - |
| Common Stock | 14,000 | 15,000 | 15,000 | 16,000 |
| Retained Earnings | 17,627,000 | 26,168,000 | 20,285,000 | 14,577,000 |
| Treasury Stock | -8,011,000 | -9,330,000 | -8,036,000 | -8,073,000 |
| Capital Surplus | 25,371,000 | 26,983,000 | 27,607,000 | 28,937,000 |
| Other Stockholder Equity | -8,011,000 | -9,330,000 | -8,036,000 | -8,073,000 |
| Total Stockholder Equity | 35,001,000 | 43,836,000 | 39,871,000 | 35,457,000 |
| Net Tangible Assets | 29,152,000 | 37,687,000 | 33,924,000 | 29,047,000 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered 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