Answered step by step
Verified Expert Solution
Link Copied!

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

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

Campaign Finance Legislation In Congress

Authors: Joseph E. Cantor, R. Sam Garrett

1st Edition

1604566574, 9781604566574

More Books

Students also viewed these Finance questions