Advanced Fundamentals

Advanced Fundamentals

  • Income Statement
  • Balance Sheet
  • Cash Flow
  Year Ending Jun 2019 (Update) Year Ending Jun 2018 (Restated) Year Ending Jun 2017 (Restated) Year Ending Jun 2016 (Update)
Net Sales 1,552.69 1,470.80 1,388.29 1,354.65
Revenue 1,552.69 1,470.80 1,388.29 1,354.65
Total Revenue 1,552.69 1,470.80 1,388.29 1,354.65
Cost of Revenue 923.03 853.14 805.86 773.65
Cost of Revenue, Total 923.03 853.14 805.86 773.65
Gross Profit 629.66 617.66 582.44 581.00
Selling/General/Administrative Expense 186.00 171.37 159.24 157.59
Selling/General/Administrative Expenses, Total 186.00 171.37 159.24 157.59
Research & Development 96.38 90.34 84.75 81.23
Other Unusual Expense (Income) 0.00 -1.56 -3.27 -19.49
Unusual Expense (Income) 0.00 -1.56 -3.27 -19.49
Total Operating Expense 1,205.41 1,113.29 1,046.57 992.99
Operating Income 347.29 357.50 341.72 361.66
Interest Expense - Non-Operating -0.93 -1.92 -1.00 -1.43
Interest Expense, Net Non-Operating -0.93 -1.92 -1.00 -1.43
Interest Income, Non-Operating 0.88 0.58 0.25 0.31
Interest/Investment Income, Non-Operating 0.88 0.58 0.25 0.31
Interest Income (Expense), Net-Non-Operating, Total -0.05 -1.35 -0.75 -1.12
Net Income Before Taxes 347.24 356.16 340.97 360.54
Income Tax – Total 75.35 97.93 111.41 111.67
Income After Tax 271.89 258.23 229.56 248.87
Net Income Before Extraordinary Items 271.89 258.23 229.56 248.87
Discontinued Operations -- -- -- --
Extraordinary Item -- 106.80 -- --
Total Extraordinary Items -- 106.80 -- --
Net Income 271.89 365.03 229.56 248.87
Income Available to Common Excluding Extraordinary Items 271.89 258.23 229.56 248.87
Income Available to Common Stocks Including Extraordinary Items 271.89 365.03 229.56 248.87
Basic Weighted Average Shares 77.16 77.25 77.86 79.42
Basic EPS Excluding Extraordinary Items 3.52 3.34 2.95 3.13
Basic EPS Including Extraordinary Items 3.52 4.73 2.95 3.13
Diluted Net Income 271.89 365.03 229.56 248.87
Diluted Weighted Average Shares 77.35 77.59 78.26 79.73
Diluted EPS Excluding Extraordinary Items 3.52 3.33 2.93 3.12
Diluted EPS Including Extraordinary Items 3.52 4.70 2.93 3.12
DPS - Common Stock Primary Issue 1.54 1.36 1.18 1.06
Gross Dividends - Common Stock 118.75 105.02 91.71 84.12
Total Special Items 0.00 -1.56 -3.27 -19.49
Normalized Income Before Taxes 347.24 354.60 337.70 341.05
Effect of Special Items on Income Taxes 0.00 -0.43 -1.07 -6.04
Income Taxes Excluding Impact of Special Items 75.35 97.50 110.34 105.63
Normalized Income After Taxes 271.89 257.11 227.36 235.41
Normalized Income Available to Common 271.89 257.11 227.36 235.41
Basic Normalized EPS 3.52 3.33 2.92 2.96
Diluted Normalized EPS 3.52 3.31 2.91 2.95
Amortization of Intangibles, Supplemental 113.26 104.01 90.11 79.08
Depreciation, Supplemental 47.38 47.98 49.68 50.57
Interest Expense, Supplemental 0.93 1.92 1.00 1.43
Interest Capitalized, Supplemental -- -- -- --
Rental Expense, Supplemental 15.20 10.84 10.20 10.17
Stock-Based Compensation, Supplemental 12.59 11.76 11.13 10.72
Research & Development Expense, Supplemental 96.38 90.34 84.75 81.23
Audit-Related Fees, Supplemental 2.77 -- -- 1.62
Audit-Related Fees 1.48 -- -- 1.36
Tax Fees, Supplemental 0.14 -- -- 0.00
All Other Fees Paid to Auditor, Supplemental 0.00 -- -- 0.00
Gross Margin 40.55 41.99 41.95 42.89
Operating Margin 22.37 24.31 24.61 26.70
Pretax Margin 22.36 24.22 24.56 26.61
Effective Tax Rate 21.70 27.49 32.67 30.97
Net Profit Margin 17.51 17.56 16.54 18.37
Normalized EBIT 347.29 355.95 338.45 342.17
Normalized EBITDA 507.92 507.93 478.23 471.82
Current Tax - Domestic 54.80 56.06 80.75 66.57
Current Tax - Local 12.95 9.95 9.47 7.57
Current Tax - Total 67.75 66.01 90.22 74.15
Deferred Tax - Domestic 4.18 26.29 17.02 34.36
Deferred Tax - Local 3.43 5.63 4.17 3.17
Deferred Tax - Total 7.60 31.92 21.19 37.52
Income Tax - Total 75.35 97.93 111.41 111.67
Defined Contribution Expense - Domestic 21.00 -- -- 16.79
Total Pension Expense 21.00 -- -- 16.79
  Year Ending Jun 2019 (Update) Year Ending Jun 2018 (Restated) Year Ending Jun 2017 (Update) Year Ending Jun 2016 (Update)
Cash & Equivalents 93.63 31.44 114.77 70.31
Short Term Investments 0.00 0.00 0.00 0.00
Cash and Short Term Investments 93.63 31.44 114.77 70.31
Accounts Receivable - Trade, Net 310.08 297.27 276.92 253.92
Receivables - Other 17.82 21.67 20.14 15.64
Total Receivables, Net 327.90 318.94 297.06 269.56
Prepaid Expenses 106.47 96.07 66.89 56.59
Discontinued Operations - Current Asset 6.36 1.30 0.00 0.00
Other Current Assets 35.10 22.99 41.31 35.47
Other Current Assets, Total 41.46 24.29 41.31 35.47
Total Current Assets 569.45 470.74 520.03 431.93
Buildings - Gross 147.22 143.92 143.35 146.46
Land/Improvements - Gross 96.93 98.29 97.64 97.35
Machinery/Equipment - Gross 404.39 367.63 370.99 375.53
Construction in Progress - Gross 12.41 39.87 15.97 7.37
Property/Plant/Equipment, Total - Gross 660.96 649.70 627.95 626.72
Accumulated Depreciation, Total -388.48 -364.15 -345.01 -328.16
Property/Plant/Equipment, Total - Net 272.47 285.55 282.93 298.56
Goodwill, Net 666.94 649.93 552.47 552.85
Intangibles - Gross 1,158.65 1,044.15 877.80 797.78
Accumulated Intangible Amortization -707.52 -602.48 -503.65 -435.87
Intangibles, Net 451.14 441.67 374.14 361.91
Deferred Charges 90.08 74.87 96.85 99.80
Other Long Term Assets 134.74 110.30 82.53 70.46
Other Long Term Assets, Total 224.83 185.16 179.37 170.26
Total Assets 2,184.83 2,033.06 1,908.95 1,815.51
Accounts Payable 9.85 30.36 6.84 14.60
Accrued Expenses 120.36 88.76 81.57 85.41
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.00 0.20
Customer Advances 339.75 328.93 382.78 343.53
Income Taxes Payable 0.00 0.00 0.00 0.00
Deferred Income Tax - Current Liability 0.00 0.00 0.00 0.00
Other Current liabilities, Total 339.75 328.93 382.78 343.53
Total Current Liabilities 469.96 448.06 471.19 443.73
Long Term Debt 0.00 0.00 50.00 0.00
Capital Lease Obligations 0.00 0.00 0.00 0.00
Total Long Term Debt 0.00 0.00 50.00 0.00
Total Debt 0.00 0.00 50.00 0.20
Deferred Income Tax - Long Term Liability 217.01 208.30 219.54 188.60
Deferred Income Tax 217.01 208.30 219.54 188.60
Other Long Term Liabilities 68.84 53.86 136.16 186.97
Other Liabilities, Total 68.84 53.86 136.16 186.97
Total Liabilities 755.82 710.21 876.89 819.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.04 1.03 1.03 1.03
Common Stock, Total 1.04 1.03 1.03 1.03
Additional Paid-In Capital 472.03 464.14 452.02 440.12
Retained Earnings (Accumulated Deficit) 2,066.07 1,912.93 1,585.28 1,431.19
Treasury Stock - Common -1,110.12 -1,055.26 -1,006.27 -876.13
Total Equity 1,429.01 1,322.84 1,032.05 996.21
Total Liabilities & Shareholders' Equity 2,184.83 2,033.06 1,908.95 1,815.51
Shares Outstanding – Common Stock Primary Issue 76.99 77.17 77.42 78.70
Total Common Shares Outstanding 76.99 77.17 77.42 78.70
Treasury Shares – Common Primary Issue 26.51 26.11 25.66 24.21
Employees 6,402.00 6,307.00 5,972.00 5,861.00
Number of Common Shareholders 145,300.00 125,900.00 94,800.00 92,900.00
Accumulated Intangible Amortization 707.52 602.48 503.65 435.87
Deferred Revenue - Current 339.75 328.93 382.78 343.53
Deferred Revenue - Long Term 54.55 40.98 128.61 177.53
Total Current Assets less Inventory 569.45 470.74 520.03 431.93
Quick Ratio 1.21 1.05 1.10 0.97
Current Ratio 1.21 1.05 1.10 0.97
Net Debt -93.63 -31.44 -64.77 -70.11
Tangible Book Value 310.93 231.24 105.44 81.45
Tangible Book Value per Share 4.04 3.00 1.36 1.04
Total Long Term Debt, Supplemental 0.00 0.00 50.00 0.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 0.00 50.00 0.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 0.00 50.00 0.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.00 0.20
Capital Lease Payments Due in Year 1 0.00 0.00 0.00 0.20
Capital Lease Payments Due in Year 2 0.00 0.00 0.00 0.00
Capital Lease Payments Due in Year 3 0.00 0.00 0.00 0.00
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 0.00
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 71.63 0.00 47.99 49.37
Operating Lease Payments Due in Year 1 15.56 0.00 10.95 9.52
Operating Lease Payments Due in Year 2 13.54 0.00 8.17 8.52
Operating Lease Payments Due in Year 3 11.86 0.00 6.68 5.97
Operating Lease Payments Due in Year 4 10.17 0.00 4.58 4.87
Operating Lease Payments Due in Year 5 8.84 0.00 3.32 3.59
Operating Lease Payments Due in 2-3 Years 25.40 0.00 14.85 14.49
Operating Lease Payments Due in 4-5 Years 19.00 0.00 7.90 8.45
Standardized Operating Lease Payments Due in Year 6 and Beyond 11.67 0.00 14.30 16.92
Value of Backlog 785.20 676.20 630.30 620.60
  Year Ending Jun 2019 (Update) Year Ending Jun 2018 (Reclassified) Year Ending Jun 2017 (Reclassified) Year Ending Jun 2016 (Reclassified)
Net Income/Starting Line 271.89 365.03 229.56 248.87
Depreciation – Supplemental 47.38 47.98 49.68 50.57
Depreciation/Depletion 47.38 47.98 49.68 50.57
Amortization of Intangibles 113.26 104.01 90.11 79.08
Amortization 113.26 104.01 90.11 79.08
Deferred Taxes 7.60 -74.88 21.19 37.52
Unusual Items 0.16 -0.95 4.77 -16.89
Other Non-Cash Items 12.59 11.76 11.13 10.72
Non-Cash Items 12.75 10.80 15.90 -6.17
Accounts Receivable -11.78 21.49 -33.10 -13.74
Prepaid Expenses -62.17 -82.66 -24.99 -29.58
Accounts Payable -7.53 6.92 -7.81 4.66
Accrued Expenses 31.89 7.09 -11.97 7.46
Taxes Payable 4.18 5.11 -6.44 -16.62
Other Liabilities 23.66 1.26 35.20 4.36
Changes in Working Capital -21.74 -40.80 -49.11 -43.45
Cash from Operating Activities 431.13 412.14 357.32 366.42
Purchase of Fixed Assets -53.60 -40.14 -41.95 -56.33
Purchase/Acquisition of Intangibles -6.07 -13.14 -16.61 -11.83
Software Development Costs -111.11 -96.65 -89.63 -96.41
Capital Expenditures -170.78 -149.92 -148.19 -164.56
Acquisition of Business -19.98 -137.56 -- -8.28
Sale of Business -- 0.35 5.63 34.03
Sale of Fixed Assets 0.13 0.31 0.97 2.84
Sale/Maturity of Investment
Purchase of Investments -- -5.00 --
Other Investing Cash Flow
Other Investing Cash Flow Items, Total -19.85 -141.91 6.60 28.60
Cash from Investing Activities -190.64 -291.83 -141.59 -135.96
Other Financing Cash Flow -13.97 -7.33 -5.48 -2.59
Financing Cash Flow Items -13.97 -7.33 -5.48 -2.59
Cash Dividends Paid - Common -118.75 -105.02 -91.71 -84.12
Total Cash Dividends Paid -118.75 -105.02 -91.71 -84.12
Sale/Issuance of Common 9.04 7.52 6.25 5.71
Repurchase/Retirement of Common -54.86 -48.99 -130.14 -175.66
Common Stock, Net -45.82 -41.46 -123.90 -169.95
Options Exercised 0.24 0.18 0.00 0.70
Issuance (Retirement) of Stock, Net -45.59 -41.29 -123.89 -169.25
Long Term Debt Issued 35.00 125.00 80.00 100.00
Long Term Debt, Net 35.00 125.00 80.00 100.00
Total Debt Reduction -35.00 -175.00 -30.20 -152.50
Issuance (Retirement) of Debt, Net -- -50.00 49.80 -52.50
Cash from Financing Activities -178.31 -203.64 -171.28 -308.46
Net Change in Cash 62.19 -83.33 44.46 -78.00
Net Cash - Beginning Balance 31.44 114.77 70.31 148.31
Net Cash - Ending Balance 93.63 31.44 114.77 70.31
Cash Interest Paid 0.69 1.75 0.77 1.32
Cash Taxes Paid 62.01 60.38 96.07 90.31

Copyright West LLC. Minimum 15 minutes delayed.

Data provided by Kaleidoscope.