Advanced Fundamentals

Advanced Fundamentals

  • Income Statement
  • Balance Sheet
  • Cash Flow
  Year Ending Jun 2020 (Update) Year Ending Jun 2019 (Update) Year Ending Jun 2018 (Restated) Year Ending Jun 2017 (Restated)
Net Sales 1,697.07 1,552.69 1,470.80 1,388.29
Revenue 1,697.07 1,552.69 1,470.80 1,388.29
Total Revenue 1,697.07 1,552.69 1,470.80 1,388.29
Cost of Revenue 1,008.46 923.03 853.14 805.86
Cost of Revenue, Total 1,008.46 923.03 853.14 805.86
Gross Profit 688.60 629.66 617.66 582.44
Selling/General/Administrative Expense 193.64 186.00 171.37 159.24
Selling/General/Administrative Expenses, Total 193.64 186.00 171.37 159.24
Research & Development 109.99 96.38 90.34 84.75
Loss (Gain) on Sale of Assets - Operating 4.35 -- -- --
Other Unusual Expense (Income) -- 0.00 -1.56 -3.27
Unusual Expense (Income) 4.35 0.00 -1.56 -3.27
Total Operating Expense 1,316.44 1,205.41 1,113.29 1,046.57
Operating Income 380.63 347.29 357.50 341.72
Interest Expense - Non-Operating -0.69 -0.93 -1.92 -1.00
Interest Expense, Net Non-Operating -0.69 -0.93 -1.92 -1.00
Interest Income, Non-Operating 1.14 0.88 0.58 0.25
Interest/Investment Income, Non-Operating 1.14 0.88 0.58 0.25
Interest Income (Expense), Net-Non-Operating, Total 0.45 -0.05 -1.35 -0.75
Net Income Before Taxes 381.08 347.24 356.16 340.97
Income Tax – Total 84.41 75.35 97.93 111.41
Income After Tax 296.67 271.89 258.23 229.56
Net Income Before Extraordinary Items 296.67 271.89 258.23 229.56
Extraordinary Item -- -- 106.80 --
Total Extraordinary Items -- -- 106.80 --
Net Income 296.67 271.89 365.03 229.56
Income Available to Common Excluding Extraordinary Items 296.67 271.89 258.23 229.56
Income Available to Common Stocks Including Extraordinary Items 296.67 271.89 365.03 229.56
Basic Weighted Average Shares 76.79 77.16 77.25 77.86
Basic EPS Excluding Extraordinary Items 3.86 3.52 3.34 2.95
Basic EPS Including Extraordinary Items 3.86 3.52 4.73 2.95
Diluted Net Income 296.67 271.89 365.03 229.56
Diluted Weighted Average Shares 76.93 77.35 77.59 78.26
Diluted EPS Excluding Extraordinary Items 3.86 3.52 3.33 2.93
Diluted EPS Including Extraordinary Items 3.86 3.52 4.70 2.93
DPS - Common Stock Primary Issue 1.66 1.54 1.36 1.18
Gross Dividends - Common Stock 127.42 118.75 105.02 91.71
Total Special Items 4.35 0.00 -1.56 -3.27
Normalized Income Before Taxes 385.43 347.24 354.60 337.70
Effect of Special Items on Income Taxes 0.96 0.00 -0.43 -1.07
Income Taxes Excluding Impact of Special Items 85.37 75.35 97.50 110.34
Normalized Income After Taxes 300.06 271.89 257.11 227.36
Normalized Income Available to Common 300.06 271.89 257.11 227.36
Basic Normalized EPS 3.91 3.52 3.33 2.92
Diluted Normalized EPS 3.90 3.52 3.31 2.91
Amortization of Intangibles, Supplemental 119.60 113.26 104.01 90.11
Depreciation, Supplemental 52.21 47.38 47.98 49.68
Interest Expense, Supplemental 0.69 0.93 1.92 1.00
Rental Expense, Supplemental 16.03 15.20 10.84 10.20
Stock-Based Compensation, Supplemental 16.88 12.59 11.76 11.13
Research & Development Expense, Supplemental 109.99 96.38 90.34 84.75
Audit-Related Fees, Supplemental 1.89 2.77 -- --
Audit-Related Fees 1.94 1.48 -- --
Tax Fees, Supplemental 0.11 0.14 -- --
All Other Fees Paid to Auditor, Supplemental 0.00 0.00 -- --
Gross Margin 40.58 40.55 41.99 41.95
Operating Margin 22.43 22.37 24.31 24.61
Pretax Margin 22.45 22.36 24.22 24.56
Effective Tax Rate 22.15 21.70 27.49 32.67
Net Profit Margin 17.48 17.51 17.56 16.54
Normalized EBIT 384.98 347.29 355.95 338.45
Normalized EBITDA 556.78 507.92 507.93 478.23
Current Tax - Domestic 46.14 54.80 56.06 80.75
Current Tax - Local 13.69 12.95 9.95 9.47
Current Tax - Total 59.83 67.75 66.01 90.22
Deferred Tax - Domestic 21.13 4.18 26.29 17.02
Deferred Tax - Local 3.45 3.43 5.63 4.17
Deferred Tax - Total 24.58 7.60 31.92 21.19
Income Tax - Total 84.41 75.35 97.93 111.41
Defined Contribution Expense - Domestic 25.16 21.00 -- --
Total Pension Expense 25.16 21.00 -- --
  Year Ending Jun 2020 (Update) Year Ending Jun 2019 (Update) Year Ending Jun 2018 (Restated) Year Ending Jun 2017 (Update)
Cash & Equivalents 213.35 93.63 31.44 114.77
Short Term Investments 0.00 0.00 0.00 0.00
Cash and Short Term Investments 213.35 93.63 31.44 114.77
Accounts Receivable - Trade, Net 322.55 310.08 297.27 276.92
Receivables - Other 21.05 17.82 21.67 20.14
Total Receivables, Net 343.61 327.90 318.94 297.06
Prepaid Expenses 73.92 106.47 96.07 66.89
Discontinued Operations - Current Asset 0.00 6.36 1.30 0.00
Other Current Assets 38.24 35.10 22.99 41.31
Other Current Assets, Total 38.24 41.46 24.29 41.31
Total Current Assets 669.10 569.45 470.74 520.03
Buildings - Gross 146.19 147.22 143.92 143.35
Land/Improvements - Gross 102.76 96.93 98.29 97.64
Machinery/Equipment - Gross 428.24 404.39 367.63 370.99
Construction in Progress - Gross 0.28 12.41 39.87 15.97
Other Property/Plant/Equipment - Gross 78.02 0.00 0.00 0.00
Property/Plant/Equipment, Total - Gross 755.49 660.96 649.70 627.95
Accumulated Depreciation, Total -418.11 -388.48 -364.15 -345.01
Property/Plant/Equipment, Total - Net 337.38 272.47 285.55 282.93
Goodwill, Net 686.33 666.94 649.93 552.47
Intangibles - Gross 1,278.35 1,158.65 1,044.15 877.80
Accumulated Intangible Amortization -812.86 -707.52 -602.48 -503.65
Intangibles, Net 465.49 451.14 441.67 374.14
Note Receivable - Long Term 54.29 0.00 0.00 0.00
Deferred Charges 113.53 90.08 74.87 96.85
Other Long Term Assets 102.35 134.74 110.30 82.53
Other Long Term Assets, Total 215.88 224.83 185.16 179.37
Total Assets 2,428.47 2,184.83 2,033.06 1,908.95
Accounts Payable 9.88 9.85 30.36 6.84
Accrued Expenses 166.69 120.36 88.76 81.57
Notes Payable/Short Term Debt 0.00 0.00 0.00 0.00
Current Portion of Long Term Debt/Capital Leases 0.12 0.00 0.00 0.00
Customer Advances 318.16 339.75 328.93 382.78
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 318.16 339.75 328.93 382.78
Total Current Liabilities 494.85 469.96 448.06 471.19
Long Term Debt 0.00 0.00 0.00 50.00
Capital Lease Obligations 0.21 0.00 0.00 0.00
Total Long Term Debt 0.21 0.00 0.00 50.00
Total Debt 0.32 0.00 0.00 50.00
Deferred Income Tax - Long Term Liability 244.00 217.01 208.30 219.54
Deferred Income Tax 244.00 217.01 208.30 219.54
Other Long Term Liabilities 139.74 68.84 53.86 136.16
Other Liabilities, Total 139.74 68.84 53.86 136.16
Total Liabilities 878.79 755.82 710.21 876.89
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.04 1.03 1.03
Common Stock, Total 1.04 1.04 1.03 1.03
Additional Paid-In Capital 495.01 472.03 464.14 452.02
Retained Earnings (Accumulated Deficit) 2,235.32 2,066.07 1,912.93 1,585.28
Treasury Stock - Common -1,181.67 -1,110.12 -1,055.26 -1,006.27
Total Equity 1,549.69 1,429.01 1,322.84 1,032.05
Total Liabilities & Shareholders' Equity 2,428.47 2,184.83 2,033.06 1,908.95
Shares Outstanding – Common Stock Primary Issue 76.63 76.99 77.17 77.42
Total Common Shares Outstanding 76.63 76.99 77.17 77.42
Treasury Shares – Common Primary Issue 26.99 26.51 26.11 25.66
Employees 6,717.00 6,402.00 6,307.00 5,972.00
Number of Common Shareholders 198,654.00 145,300.00 125,900.00 94,800.00
Accumulated Intangible Amortization 812.86 707.52 602.48 503.65
Deferred Revenue - Current 318.16 339.75 328.93 382.78
Deferred Revenue - Long Term 71.46 54.55 40.98 128.61
Total Current Assets less Inventory 669.10 569.45 470.74 520.03
Quick Ratio 1.35 1.21 1.05 1.10
Current Ratio 1.35 1.21 1.05 1.10
Net Debt -213.02 -93.63 -31.44 -64.77
Tangible Book Value 397.86 310.93 231.24 105.44
Tangible Book Value per Share 5.19 4.04 3.00 1.36
Total Long Term Debt, Supplemental 0.00 0.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 0.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 0.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.00 0.00
Capital Lease Payments Due in Year 1 0.00 0.00 0.00 0.00
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 68.31 71.63 0.00 47.99
Operating Lease Payments Due in Year 1 13.44 15.56 0.00 10.95
Operating Lease Payments Due in Year 2 12.45 13.54 0.00 8.17
Operating Lease Payments Due in Year 3 10.79 11.86 0.00 6.68
Operating Lease Payments Due in Year 4 8.64 10.17 0.00 4.58
Operating Lease Payments Due in Year 5 5.86 8.84 0.00 3.32
Operating Lease Payments Due in 2-3 Years 23.24 25.40 0.00 14.85
Operating Lease Payments Due in 4-5 Years 14.50 19.00 0.00 7.90
Standardized Operating Lease Payments Due in Year 6 and Beyond 17.13 11.67 0.00 14.30
Value of Backlog 904.30 785.20 676.20 630.30
  Year Ending Jun 2020 (Update) Year Ending Jun 2019 (Update) Year Ending Jun 2018 (Reclassified) Year Ending Jun 2017 (Reclassified)
Net Income/Starting Line 296.67 271.89 365.03 229.56
Depreciation – Supplemental 52.21 47.38 47.98 49.68
Depreciation/Depletion 52.21 47.38 47.98 49.68
Amortization of Intangibles 119.60 113.26 104.01 90.11
Amortization 119.60 113.26 104.01 90.11
Deferred Taxes 24.58 7.60 -74.88 21.19
Unusual Items 4.74 0.16 -0.95 4.77
Other Non-Cash Items 16.88 12.59 11.76 11.13
Non-Cash Items 21.62 12.75 10.80 15.90
Accounts Receivable 10.54 -11.78 21.49 -33.10
Prepaid Expenses -25.76 -62.17 -82.66 -24.99
Accounts Payable -0.05 -7.53 6.92 -7.81
Accrued Expenses 19.72 31.89 7.09 -11.97
Taxes Payable -3.72 4.18 5.11 -6.44
Other Liabilities -4.87 23.66 1.26 35.20
Changes in Working Capital -4.14 -21.74 -40.80 -49.11
Cash from Operating Activities 510.53 431.13 412.14 357.32
Purchase of Fixed Assets -53.54 -53.60 -40.14 -41.95
Purchase/Acquisition of Intangibles -6.71 -6.07 -13.14 -16.61
Software Development Costs -117.26 -111.11 -96.65 -89.63
Capital Expenditures -177.51 -170.78 -149.92 -148.19
Acquisition of Business -30.38 -19.98 -137.56 --
Sale of Business -- -- 0.35 5.63
Sale of Fixed Assets 11.13 0.13 0.31 0.97
Sale/Maturity of Investment
Purchase of Investments -1.15 -- -5.00 --
Other Investing Cash Flow
Other Investing Cash Flow Items, Total -20.40 -19.85 -141.91 6.60
Cash from Investing Activities -197.91 -190.64 -291.83 -141.59
Other Financing Cash Flow -3.74 -13.97 -7.33 -5.48
Financing Cash Flow Items -3.74 -13.97 -7.33 -5.48
Cash Dividends Paid - Common -127.42 -118.75 -105.02 -91.71
Total Cash Dividends Paid -127.42 -118.75 -105.02 -91.71
Sale/Issuance of Common 9.83 9.04 7.52 6.25
Repurchase/Retirement of Common -71.55 -54.86 -48.99 -130.14
Common Stock, Net -61.72 -45.82 -41.46 -123.90
Options Exercised -- 0.24 0.18 0.00
Issuance (Retirement) of Stock, Net -61.72 -45.59 -41.29 -123.89
Long Term Debt Issued 55.00 35.00 125.00 80.00
Long Term Debt Reduction -55.03
Long Term Debt, Net -0.03 35.00 125.00 80.00
Total Debt Reduction -35.00 -175.00 -30.20
Issuance (Retirement) of Debt, Net -0.03 -- -50.00 49.80
Cash from Financing Activities -192.91 -178.31 -203.64 -171.28
Net Change in Cash 119.72 62.19 -83.33 44.46
Net Cash - Beginning Balance 93.63 31.44 114.77 70.31
Net Cash - Ending Balance 213.35 93.63 31.44 114.77
Cash Interest Paid 0.48 0.69 1.75 0.77
Cash Taxes Paid 63.69 62.01 60.38 96.07

Data Provided by Refinitiv. Minimum 15 minutes delayed.

Data provided by Kaleidoscope.