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 |
Undertake a DuPont Analysis for 2015.
For 2015 Shareholders Equity = 129,495,000 - 67,076,000 = 62,419,000
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 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