Answered step by step
Verified Expert Solution
Link Copied!

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

  1. Current ratio
  2. Quick ratio

Asset utilization

  1. Inventory turnover
  2. Total asset turnover

Debt utilization

  1. Debt to total assets
  2. Times interest earned

Profitability ratios

  1. 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Finance For A Better World

Authors: Henri-Claude De Bettignies, F. LĂ©pineux

2009th Edition

0230551300, 978-0230551305

More Books

Students also viewed these Finance questions