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,536.60 1,431.12 1,354.65 1,256.19
Revenue 1,536.60 1,431.12 1,354.65 1,256.19
Total Revenue 1,536.60 1,431.12 1,354.65 1,256.19
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,144.23 1,063.42 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.00 0.09
All Other Fees Paid to Auditor, Supplemental 0.00 0.00 0.00 0.00
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 (Restated) 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 297.27 276.92 253.92 245.39
Receivables - Other 21.67 20.14 15.64 2.75
Total Receivables, Net 318.94 297.06 269.56 248.14
Prepaid Expenses 96.14 66.89 56.59 69.10
Deferred Income Tax - Current Asset 0.00 0.00 0.00 0.00
Other Current Assets 27.07 41.31 35.47 27.95
Other Current Assets, Total 27.07 41.31 35.47 27.95
Total Current Assets 473.59 520.03 431.93 493.50
Buildings - Gross 0.00 143.35 146.46 144.41
Land/Improvements - Gross 0.00 97.64 97.35 82.58
Machinery/Equipment - Gross 0.00 370.99 375.53 365.64
Construction in Progress - Gross 0.00 15.97 7.37 23.56
Other Property/Plant/Equipment - Gross 651.00 0.00 0.00 0.00
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 0.00 877.80 797.78 737.70
Accumulated Intangible Amortization 0.00 -503.65 -435.87 -389.92
Intangibles, Net 441.67 374.14 361.91 347.78
Deferred Charges 74.87 96.85 99.80 96.42
Other Long Term Assets 110.30 82.53 70.46 52.43
Other Long Term Assets, Total 185.16 179.37 170.26 148.86
Total Assets 2,037.21 1,908.95 1,815.51 1,836.84
Accounts Payable 34.51 6.84 14.60 9.93
Accrued Expenses 88.76 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 352.43 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 352.43 382.78 343.53 352.12
Total Current Liabilities 475.71 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 208.30 219.54 188.60 150.22
Deferred Income Tax 208.30 219.54 188.60 150.22
Other Long Term Liabilities 30.36 136.16 186.97 201.37
Other Liabilities, Total 30.36 136.16 186.97 201.37
Total Liabilities 714.36 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,912.93 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,322.84 1,032.05 996.21 991.53
Total Liabilities & Shareholders' Equity 2,037.21 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 0.00 503.65 435.87 389.92
Deferred Revenue - Current 352.43 382.78 343.53 339.54
Deferred Revenue - Long Term 17.48 128.61 177.53 192.44
Total Current Assets less Inventory 473.59 520.03 431.93 493.50
Quick Ratio 1.00 1.10 0.97 1.11
Current Ratio 1.00 1.10 0.97 1.11
Net Debt -31.44 -64.77 -70.11 -95.62
Tangible Book Value 231.24 105.44 81.45 93.39
Tangible Book Value per Share 3.00 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 0.00 47.99 49.37 26.57
Operating Lease Payments Due in Year 1 0.00 10.95 9.52 8.55
Operating Lease Payments Due in Year 2 0.00 8.17 8.52 7.16
Operating Lease Payments Due in Year 3 0.00 6.68 5.97 5.73
Operating Lease Payments Due in Year 4 0.00 4.58 4.87 2.85
Operating Lease Payments Due in Year 5 0.00 3.32 3.59 1.67
Operating Lease Payments Due in 2-3 Years 0.00 14.85 14.49 12.89
Operating Lease Payments Due in 4-5 Years 0.00 7.90 8.45 4.52
Standardized Operating Lease Payments Due in Year 6 and Beyond 0.00 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