Advanced Fundamentals

Advanced Fundamentals

  • Income Statement
  • Balance Sheet
  • Cash Flow
  Year Ending Jun 2018 (Update) Year Ending Jun 2017 (Update) Year Ending Jun 2016 (Update) Year Ending Jun 2015 (Update)
Net Sales 1.54M 1.43M 1.35M 1.26M
Revenue 1.54M 1.43M 1.35M 1.26M
Total Revenue 1.54M 1.43M 1.35M 1.26M
Cost of Revenue 873.64 819.03 773.65 720.34
Cost of Revenue, Total 873.64 819.03 773.65 720.34
Gross Profit 662.96 612.08 581.00 535.85
Selling/General/Administrative Expense 182.15 162.90 157.59 153.37
Selling/General/Administrative Expenses, Total 182.15 162.90 157.59 153.37
Research & Development 90.34 84.75 81.23 71.50
Other Unusual Expense (Income) -1.89 -3.27 -19.49 -6.87
Unusual Expense (Income) -1.89 -3.27 -19.49 -6.87
Total Operating Expense 1.14M 1.06M 992.99 938.33
Operating Income 392.37 367.70 361.66 317.87
Interest Expense - Non-Operating -1.92 -1.00 -1.43 -1.59
Interest Expense, Net Non-Operating -1.92 -1.00 -1.43 -1.59
Interest Income, Non-Operating 0.58 0.25 0.31 0.17
Interest/Investment Income, Non-Operating 0.58 0.25 0.31 0.17
Interest Income (Expense), Net-Non-Operating, Total -1.35 -0.75 -1.12 -1.43
Net Income Before Taxes 391.02 366.95 360.54 316.44
Income Tax – Total 132.73 121.16 111.67 105.22
Income After Tax 258.29 245.79 248.87 211.22
Net Income Before Extraordinary Items 258.29 245.79 248.87 211.22
Discontinued Operations
Extraordinary Item 118.37
Total Extraordinary Items 118.37
Net Income 376.66 245.79 248.87 211.22
Income Available to Common Excluding Extraordinary Items 258.29 245.79 248.87 211.22
Income Available to Common Stocks Including Extraordinary Items 376.66 245.79 248.87 211.22
Basic Weighted Average Shares 77.25 77.86 79.42 81.35
Basic EPS Excluding Extraordinary Items 3.34 3.16 3.13 2.60
Basic EPS Including Extraordinary Items 4.88 3.16 3.13 2.60
Diluted Net Income 376.66 245.79 248.87 211.22
Diluted Weighted Average Shares 77.59 78.26 79.73 81.60
Diluted EPS Excluding Extraordinary Items 3.33 3.14 3.12 2.59
Diluted EPS Including Extraordinary Items 4.85 3.14 3.12 2.59
DPS - Common Stock Primary Issue 1.36 1.18 1.06 0.94
Gross Dividends - Common Stock 105.02 91.71 84.12 76.41
Total Special Items -1.89 -3.27 -19.49 -6.87
Normalized Income Before Taxes 389.13 363.68 341.05 309.57
Effect of Special Items on Income Taxes -0.64 -1.08 -6.04 -2.29
Income Taxes Excluding Impact of Special Items 132.09 120.08 105.63 102.93
Normalized Income After Taxes 257.04 243.60 235.41 206.63
Normalized Income Available to Common 257.04 243.60 235.41 206.63
Basic Normalized EPS 3.33 3.13 2.96 2.54
Diluted Normalized EPS 3.31 3.11 2.95 2.53
Amortization of Intangibles, Supplemental 104.01 90.11 79.08 64.84
Depreciation, Supplemental 47.98 49.68 50.57 54.16
Interest Expense, Supplemental 1.92 1.00 1.43 1.59
Interest Capitalized, Supplemental
Rental Expense, Supplemental 10.84 10.20 10.17 9.55
Stock-Based Compensation, Supplemental 11.76 11.13 10.72 10.11
Research & Development Expense, Supplemental 90.34 84.75 81.23 71.50
Audit-Related Fees, Supplemental 1.63 1.54 1.62 0.52
Audit-Related Fees 2.58 1.11 1.36 1.55
Tax Fees, Supplemental 0.13 0.02 -- 0.09
All Other Fees Paid to Auditor, Supplemental -- -- -- --
Gross Margin 43.14 42.77 42.89 42.66
Operating Margin 25.53 25.69 26.70 25.30
Pretax Margin 25.45 25.64 26.61 25.19
Effective Tax Rate 33.94 33.02 30.97 33.25
Net Profit Margin 16.81 17.17 18.37 16.81
Normalized EBIT 390.48 364.43 342.17 310.99
Normalized EBITDA 542.46 504.22 471.82 429.99
Current Tax - Domestic 56.06 80.75 66.57 70.56
Current Tax - Local 9.95 9.47 7.57 5.22
Current Tax - Total 66.01 90.22 74.15 75.78
Deferred Tax - Domestic 59.42 25.76 34.36 28.02
Deferred Tax - Local 7.30 5.18 3.17 1.43
Deferred Tax - Total 66.72 30.94 37.52 29.44
Income Tax - Total 132.73 121.16 111.67 105.22
Defined Contribution Expense - Domestic 18.82 17.55 16.79 15.38
Total Pension Expense 18.82 17.55 16.79 15.38
  Year Ending Jun 2018 (Update) Year Ending Jun 2017 (Update) Year Ending Jun 2016 (Update) Year Ending Jun 2015 (Update)
Cash & Equivalents 31.44 114.77 70.31 148.31
Short Term Investments 0.00 0.00 0.00 0.00
Cash and Short Term Investments 31.44 114.77 70.31 148.31
Accounts Receivable - Trade, Net 291.63 276.92 253.92 245.39
Receivables - Other 21.67 20.14 15.64 2.75
Total Receivables, Net 313.30 297.06 269.56 248.14
Prepaid Expenses 84.81 66.89 56.59 69.10
Deferred Income Tax - Current Asset 0.00 0.00 0.00 0.00
Other Current Assets 38.99 41.31 35.47 27.95
Other Current Assets, Total 38.99 41.31 35.47 27.95
Total Current Assets 468.54 520.03 431.93 493.50
Buildings - Gross 145.02 143.35 146.46 144.41
Land/Improvements - Gross 98.49 97.64 97.35 82.58
Machinery/Equipment - Gross 367.63 370.99 375.53 365.64
Construction in Progress - Gross 39.87 15.97 7.37 23.56
Property/Plant/Equipment, Total - Gross 651.00 627.95 626.72 616.21
Accumulated Depreciation, Total -364.15 -345.01 -328.16 -319.87
Property/Plant/Equipment, Total - Net 286.85 282.93 298.56 296.33
Goodwill, Net 649.93 552.47 552.85 550.37
Intangibles - Gross 1,044.15 877.80 797.78 737.70
Accumulated Intangible Amortization -602.48 -503.65 -435.87 -389.92
Intangibles, Net 441.67 374.14 361.91 347.78
Deferred Charges 95.54 96.85 99.80 96.42
Other Long Term Assets 107.78 82.53 70.46 52.43
Other Long Term Assets, Total 203.32 179.37 170.26 148.86
Total Assets 2,050.30 1,908.95 1,815.51 1,836.84
Accounts Payable 34.51 6.84 14.60 9.93
Accrued Expenses 97.85 81.57 85.41 78.96
Notes Payable/Short Term Debt 0.00 0.00 0.00 0.00
Current Portion of Long Term Debt/Capital Leases 0.00 0.00 0.20 2.60
Customer Advances 355.54 382.78 343.53 339.54
Income Taxes Payable 0.00 0.00 0.00 5.54
Deferred Income Tax - Current Liability 0.00 0.00 0.00 7.03
Other Current liabilities, Total 355.54 382.78 343.53 352.12
Total Current Liabilities 487.90 471.19 443.73 443.61
Long Term Debt 0.00 50.00 0.00 50.00
Capital Lease Obligations 0.00 0.00 0.00 0.10
Total Long Term Debt 0.00 50.00 0.00 50.10
Total Debt 0.00 50.00 0.20 52.70
Deferred Income Tax - Long Term Liability 189.61 219.54 188.60 150.22
Deferred Income Tax 189.61 219.54 188.60 150.22
Other Long Term Liabilities 105.97 136.16 186.97 201.37
Other Liabilities, Total 105.97 136.16 186.97 201.37
Total Liabilities 783.48 876.89 819.30 845.30
Convertible Preferred Stock – Non-Redeemable 0.00 0.00 0.00 0.00
Preferred Stock - Non Redeemable, Net 0.00 0.00 0.00 0.00
Common Stock 1.03 1.03 1.03 1.03
Common Stock, Total 1.03 1.03 1.03 1.03
Additional Paid-In Capital 464.14 452.02 440.12 424.54
Retained Earnings (Accumulated Deficit) 1,856.92 1,585.28 1,431.19 1,266.44
Treasury Stock - Common -1,055.26 -1,006.27 -876.13 -700.47
Total Equity 1,266.83 1,032.05 996.21 991.53
Total Liabilities & Shareholders' Equity 2,050.30 1,908.95 1,815.51 1,836.84
Shares Outstanding – Common Stock Primary Issue 77.17 77.42 78.70 80.85
Total Common Shares Outstanding 77.17 77.42 78.70 80.85
Treasury Shares – Common Primary Issue 26.11 25.66 24.21 21.84
Employees 6,307.00 5,972.00 5,861.00 5,822.00
Number of Common Shareholders 125,900.00 94,800.00 92,900.00 70,300.00
Accumulated Intangible Amortization 602.48 503.65 435.87 389.92
Deferred Revenue - Current 355.54 382.78 343.53 339.54
Deferred Revenue - Long Term 93.09 128.61 177.53 192.44
Total Current Assets less Inventory 468.54 520.03 431.93 493.50
Quick Ratio 0.96 1.10 0.97 1.11
Current Ratio 0.96 1.10 0.97 1.11
Net Debt -31.44 -64.77 -70.11 -95.62
Tangible Book Value 175.23 105.44 81.45 93.39
Tangible Book Value per Share 2.27 1.36 1.04 1.16
Total Long Term Debt, Supplemental 0.00 50.00 0.00 50.00
Long Term Debt Maturing within 1 Year 0.00 0.00 0.00 0.00
Long Term Debt Maturing in Year 2 0.00 0.00 0.00 0.00
Long Term Debt Maturing in Year 3 0.00 0.00 0.00 0.00
Long Term Debt Maturing in Year 4 0.00 0.00 0.00 0.00
Long Term Debt Maturing in Year 5 0.00 50.00 0.00 50.00
Long Term Debt Maturing in 2-3 Years 0.00 0.00 0.00 0.00
Long Term Debt Maturing in 4-5 Years 0.00 50.00 0.00 50.00
Long Term Debt Maturing in Year 6 & Beyond 0.00 0.00 0.00 0.00
Total Capital Leases 0.00 0.00 0.20 9.14
Capital Lease Payments Due in Year 1 0.00 0.00 0.20 5.41
Capital Lease Payments Due in Year 2 0.00 0.00 0.00 1.86
Capital Lease Payments Due in Year 3 0.00 0.00 0.00 1.86
Capital Lease Payments Due in Year 4 0.00 0.00 0.00 0.00
Capital Lease Payments Due in Year 5 0.00 0.00 0.00 0.00
Capital Lease Payments Due in 2-3 Years 0.00 0.00 0.00 3.73
Capital Lease Payments Due in 4-5 Years 0.00 0.00 0.00 0.00
Capital Lease Payments Due in Year 6 & Beyond 0.00 0.00 0.00 0.00
Total Operating Leases 63.37 47.99 49.37 26.57
Operating Lease Payments Due in Year 1 12.76 10.95 9.52 8.55
Operating Lease Payments Due in Year 2 11.59 8.17 8.52 7.16
Operating Lease Payments Due in Year 3 9.07 6.68 5.97 5.73
Operating Lease Payments Due in Year 4 7.37 4.58 4.87 2.85
Operating Lease Payments Due in Year 5 6.23 3.32 3.59 1.67
Operating Lease Payments Due in 2-3 Years 20.66 14.85 14.49 12.89
Operating Lease Payments Due in 4-5 Years 13.59 7.90 8.45 4.52
Standardized Operating Lease Payments Due in Year 6 and Beyond 16.35 14.30 16.92 0.61
  Year Ending Jun 2018 (Update) Year Ending Jun 2017 (Update) Year Ending Jun 2016 (Reclassified) Year Ending Jun 2015 (Update)
Net Income/Starting Line 376.66 245.79 248.87 211.22
Depreciation – Supplemental 47.98 49.68 50.57 54.16
Depreciation/Depletion 47.98 49.68 50.57 54.16
Amortization of Intangibles 104.01 90.11 79.08 64.84
Amortization 104.01 90.11 79.08 64.84
Deferred Taxes -51.64 30.94 37.52 29.44
Unusual Items -0.95 4.77 -16.89 -5.05
Other Non-Cash Items 11.76 11.13 10.72 5.77
Non-Cash Items 10.80 15.90 -6.17 0.72
Accounts Receivable -9.22 -22.50 -13.74 -21.35
Prepaid Expenses -28.45 -25.09 -29.58 -33.86
Accounts Payable 11.07 -7.81 4.66 -0.58
Accrued Expenses 9.09 -4.45 7.46 14.48
Taxes Payable 5.11 -6.44 -16.62 14.15
Other Liabilities -63.26 -8.80 4.36 40.57
Changes in Working Capital -75.66 -75.10 -43.45 13.41
Cash from Operating Activities 412.14 357.32 366.42 373.79
Purchase of Fixed Assets -40.14 -41.95 -56.33 -54.41
Purchase/Acquisition of Intangibles -13.14 -16.61 -11.83 -14.02
Software Development Costs -96.65 -89.63 -96.41 -76.87
Capital Expenditures -149.92 -148.19 -164.56 -145.30
Acquisition of Business -137.56 -- -8.28 --
Sale of Business 0.35 5.63 34.03
Sale of Fixed Assets 0.31 0.97 2.84 8.32
Sale/Maturity of Investment
Purchase of Investments -5.00
Other Investing Cash Flow --
Other Investing Cash Flow Items, Total -141.91 6.60 28.60 8.32
Cash from Investing Activities -291.83 -141.59 -135.96 -136.98
Other Financing Cash Flow -7.33 -5.48 -2.59 -4.51
Financing Cash Flow Items -7.33 -5.48 -2.59 -4.51
Cash Dividends Paid - Common -105.02 -91.71 -84.12 -76.41
Total Cash Dividends Paid -105.02 -91.71 -84.12 -76.41
Sale/Issuance of Common 7.52 6.25 5.71 4.88
Repurchase/Retirement of Common -48.99 -130.14 -175.66 -122.69
Common Stock, Net -41.46 -123.90 -169.95 -117.81
Options Exercised 0.18 0.00 0.70 0.64
Issuance (Retirement) of Stock, Net -41.29 -123.89 -169.25 -117.17
Long Term Debt Issued 125.00 80.00 100.00 90.00
Long Term Debt, Net 125.00 80.00 100.00 90.00
Total Debt Reduction -175.00 -30.20 -152.50 -50.78
Issuance (Retirement) of Debt, Net -50.00 49.80 -52.50 39.22
Cash from Financing Activities -203.64 -171.28 -308.46 -158.87
Net Change in Cash -83.33 44.46 -78.00 77.94
Net Cash - Beginning Balance 114.77 70.31 148.31 70.38
Net Cash - Ending Balance 31.44 114.77 70.31 148.31
Cash Interest Paid 1.75 0.77 1.32 1.11
Cash Taxes Paid 60.38 96.07 90.31 61.89

Copyright West LLC. Minimum 15 minutes delayed.

Copyright Morningstar