Question
SHOW YOUR CALCULATIONS. Below are the financial statements of a public company for the last three years. Income statement 2016 2015 2014 Total Revenue 65,299,000
SHOW YOUR CALCULATIONS.
Below are the financial statements of a public company for the last three years.
Income statement | 2016 | 2015 | 2014 |
Total Revenue | 65,299,000 | 70,749,000 | 74,401,000 |
Cost of Revenue | 32,909,000 | 37,056,000 | 39,030,000 |
Gross Profit | 32,390,000 | 33,693,000 | 35,371,000 |
Selling General and Administrative | 18,949,000 | 22,644,000 | 21,461,000 |
Operating Income | 13,441,000 | 11,049,000 | 13,910,000 |
Depreciation and Amortization | 507,000 | 589,000 | 308,000 |
Earnings Before Interest and Taxes | 12,934,000 | 10,460,000 | 13,602,000 |
Interest Expense | 579,000 | 626,000 | 709,000 |
Income Before Tax | 12,355,000 | 9,834,000 | 12,893,000 |
Income Tax Expense | 3,342,000 | 2,725,000 | 2,851,000 |
Net Income | 9,013,000 | 7,109,000 | 10,042,000 |
Assets | 2016 | 2015 | 2014 |
Cash And Cash Equivalents | 7,102,000 | 6,836,000 | 8,558,000 |
Short Term Investments | 6,246,000 | 4,767,000 | 2,128,000 |
Net Receivables | 5,880,000 | 5,924,000 | 7,478,000 |
Inventory | 4,716,000 | 4,979,000 | 6,759,000 |
Other Current Assets | 9,838,000 | 7,140,000 | 6,694,000 |
Total Current Assets | 33,782,000 | 29,646,000 | 31,617,000 |
Long Term Investments | 0 | 0 | 0 |
Property Plant and Equipment | 19,385,000 | 24,859,000 | 22,304,000 |
Goodwill | 44,350,000 | 44,622,000 | 53,704,000 |
Intangible Assets | 24,527,000 | 25,010,000 | 30,843,000 |
Accumulated Amortization | 0 | 0 | 0 |
Other Assets | 5,092,000 | 5,358,000 | 5,798,000 |
Deferred Long Term Asset Charges | 0 | 0 | 0 |
Total Assets | 127,136,000 | 129,495,000 | 144,266,000 |
| |||
Liabilities | 2016 | 2015 | 2014 |
Accounts Payable | 16,774,000 | 16,229,000 | 17,460,000 |
Short/Current Long Term Debt | 11,653,000 | 12,018,000 | 15,606,000 |
Other Current Liabilities | 2,343,000 | 1,543,000 | 660,000 |
Total Current Liabilities | 30,770,000 | 29,790,000 | 33,726,000 |
Long Term Debt | 18,945,000 | 18,327,000 | 19,811,000 |
Other Liabilities | 10,325,000 | 9,149,000 | 10,535,000 |
Deferred Long Term Liability Charges | 9,113,000 | 9,179,000 | 10,218,000 |
Minority Interest | 642,000 | 631,000 | 762,000 |
Negative Goodwill | 0 | 0 | 0 |
Total Liabilities | 69,795,000 | 67,076,000 | 75,052,000 |
Now answer the following questions:
Find out the total shareholders equity for the company for each of the three years.
Find out the financial leverage ratios for 2016.
What are the current ratios, quick ratios, and cash ratios for 2014 and 2015?
Find out the operating profitability of the company for each of the three years.
Undertake a DuPont Analysis for 2015.
Say the stock price of the company is $86.50 and there are 5.5 million shares outstanding, find out the following ratios/numbers for 2016:
Market capitalizations
Market to book ratio
P/E ratio.
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