Answered step by step
Verified Expert Solution
Question
1 Approved Answer
RATIO ANALYSIS Cerner Corp. 12/30/2017 12/31/2016 12/1/2015 Dec-14 Dec-13 $ Percent $ Percent $ Percent $ $ Income Statement Revenue 5,142 100.0% 4,796 100.0% 4,425
RATIO ANALYSIS | |||||||||
Cerner Corp. | 12/30/2017 | 12/31/2016 | 12/1/2015 | Dec-14 | Dec-13 | ||||
$ | Percent | $ | Percent | $ | Percent | $ | $ | ||
Income Statement | |||||||||
Revenue | 5,142 | 100.0% | 4,796 | 100.0% | 4,425 | 100.0% | 3,403 | 2,911 | |
Cost of Goods Sold | 854 | 16.6% | 779 | 16.2% | 751 | 17.0% | |||
Gross Profit | 4,288 | 83.4% | 4,017 | 83.8% | 3,674 | 83.0% | |||
R&D | 605 | 11.8% | 551 | 11.5% | 540 | 12.2% | |||
Selling General & Administrative | 2,632 | 51.2% | 2,464 | #REF! | 2,262 | 51.1% | |||
Non Recurring | 0 | 0.0% | 0 | 51.4% | 0 | 0.0% | |||
Others | 91 | 1.8% | 91 | 1.9% | 91 | 2.1% | |||
Operating Income | 960 | 18.7% | 911 | 19.0% | 781 | 17.6% | |||
Depreciation Expense | 0.0% | 0.0% | 0.0% | ||||||
Other Income/Expense | 15 | 0.3% | 12 | 0.3% | 0 | 0.0% | |||
EBIT | 967 | 18.8% | 918 | 19.1% | 781 | 17.6% | |||
Interest Expense | 8 | 0.2% | 4 | 0.1% | 0 | 0.0% | |||
Tax Expense | 100 | 1.9% | 282 | 5.9% | 242 | 5.5% | |||
Income from Cont Operations | 867 | 16.9% | 636 | 13.3% | 539 | 12.2% | 525 | 398 | |
Net Income | 867 | 16.9% | 636 | 13.3% | 539 | 12.2% | |||
Balance Sheet | |||||||||
Cash | 806 | 12.5% | 356 | 6.3% | 513 | 9.2% | |||
Short Term Investments | 0.0% | 0.0% | 0.0% | ||||||
Accounts Receivable | 1,030 | 15.9% | 916 | 16.3% | 995 | 17.9% | 616 | ||
Inventory | 16 | 0.2% | 15 | 0.3% | 16 | 0.3% | 24 | ||
Other Current Assets | 13 | 0.2% | 29 | 0.5% | 39 | 0.7% | |||
Total Current Assets | 2,380 | 36.8% | 1,619 | 28.8% | 1,828 | 32.9% | |||
Long Term Investments | 0.0% | 0.0% | 0.0% | ||||||
PP&E Net | 1,603 | 24.8% | 1,553 | 27.6% | 1,309 | 23.5% | |||
Goodwill | 853 | 13.2% | 844 | 15.0% | 799 | 14.4% | |||
Intangibles | 1,302 | 20.1% | 1,285 | 22.8% | 1,251 | 22.5% | |||
Other Assets | 134 | 2.1% | 219 | 3.9% | 202 | 3.6% | |||
Total Assets | 6,469 | 100.0% | 5,630 | 100.0% | 5,562 | 100.0% | 4,531 | ||
Accounts Payable | 219 | 3.4% | 238 | 4.2% | 216 | 3.9% | |||
Short/Current L.T. Debt | 0.0% | 0.0% | 0.0% | ||||||
Other Current Liabilities | 0.0% | 0 | 0.0% | 0 | 0.0% | ||||
Total Current Liabilities | 790 | 12.2% | 845 | 15.0% | 778 | 14.0% | |||
Long Term Debt | 0.0% | 0.0% | 0.0% | ||||||
Other Liabilities | 515 | 8.0% | 538 | 9.6% | 563 | 10.1% | |||
Minority Interest | 0 | 0.0% | 0 | 0.0% | 0.0% | ||||
Total Liabilities | 1,684 | 26.0% | 1,702 | 30.2% | 1,692 | 30.4% | |||
Preferred Stock | 0 | 0 | 0.0% | ||||||
Common Stock | 4 | 4 | 4 | 0.1% | |||||
Additional Paid In Capital | 1,380 | 1,231 | 1,076 | 19.3% | |||||
Retained Earnings | 4,939 | 4,094 | 3,458 | 62.2% | |||||
Treasury Stock (-) | -1,464 | -1,291 | -590 | -10.6% | |||||
Other Equity | -73 | -110 | -76 | -1.4% | |||||
Total Stockholders' Equity | 4,785 | 74.0% | 3,928 | 69.8% | 3,870 | 69.6% | 3,566 | ||
Total: | 6,469 | 100.0% | 5,630 | 100.0% | |||||
RATIO ANALYSIS | |||||||||
Growth Ratios | |||||||||
Sales Growth | 7.2% | 8.4% | 30.0% | 16.9% | |||||
Income Growth | 36.3% | 18.0% | 2.7% | 31.9% | |||||
Asset Growth | 14.9% | 1.2% | 22.8% | ||||||
Activity Ratios | |||||||||
Receivable Turnover | 5.3 | 5.0 | 5.5 | ||||||
Inventory Turnover | 55.1 | 50.3 | 37.6 | ||||||
Fixed Asset Turnover | 3.2 | 3.1 | 3.4 | ||||||
Profit Ratios | |||||||||
Profit Margin | 16.9% | 13.3% | 12.2% | ||||||
Return on Assets | 14.3% | 11.4% | 10.7% | ||||||
Return on Equity | 19.9% | 16.3% | 14.5% | ||||||
Liquidity Ratios | |||||||||
Current Ratio | 3.01 | 1.92 | 2.35 | ||||||
Quick Ratio | 2.99 | 1.90 | 2.33 | ||||||
Solvency Ratios | |||||||||
Debt to Total Assets | 0.26 | 0.30 | 0.30 | ||||||
Times Interest Earned (Accrual) | 121.88 | 230.50 | #DIV/0! |
| |||||
Above is a ration analysis of Cerner Corporation (CERN) I have done something wrong so my ratio are not coming out correctly. IS anyone willing to look at Cerner's financials and help me figure out where the errors are? |
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