Fundamentals - Annual Balance Sheet

Fundamentals - Annual Balance Sheet

  Year Ending Mar 2017 (Update) Year Ending Mar 2016 (Update) Year Ending Mar 2015 (Reclassified) Year Ending Mar 2014 (Restated) Year Ending Mar 2013 (Restated)
Cash & Equivalents 69.63 20.98 32.62 29.00 32.04
Cash and Short Term Investments 69.63 20.98 32.62 29.00 32.04
Accounts Receivable - Trade, Gross 316.35 450.70 528.08 523.84 454.24
Provision for Doubtful Accounts -4.56 -6.49 -6.48 -6.54 -5.37
Accounts Receivable - Trade, Net 311.79 444.21 521.60 517.30 448.87
Total Receivables, Net 311.79 444.21 521.60 517.30 448.87
Inventories - Finished Goods 118.27 124.74 91.64 67.61 46.88
Inventories - Work In Progress 1.30M 1.10M 1.31M 1.10M 963.66
Inventories - Raw Materials 89.07 81.99 73.17 106.55 99.13
Inventories - Other -165.15 -123.16 -189.92 -165.02 -124.13
Total Inventory 1.34M 1.18M 1.28M 1.11M 985.54
Prepaid Expenses 30.06 41.26 23.07 24.90 24.48
Deferred Income Tax - Current Asset 57.31 99.55
Discontinued Operations - Current Asset 21.26 14.75
Other Current Assets 51.95 48.82 41.67 34.85
Other Current Assets, Total 21.26 51.95 48.82 98.97 149.15
Total Current Assets 1.77M 1.74M 1.91M 1.78M 1.64M
Buildings - Gross 378.19 371.34 374.76 269.21
Land/Improvements - Gross 65.34 72.20 72.89 46.75
Machinery/Equipment - Gross 982.24 989.42 947.15 778.35
Construction in Progress - Gross 31.81 40.77 53.48 81.95
Other Property/Plant/Equipment - Gross 160.30 159.51 146.83 119.77
Property/Plant/Equipment, Total - Gross 1.62M 1.63M 1.60M 1.30M
Accumulated Depreciation, Total -812.85 -743.51 -644.38 -480.94
Property/Plant/Equipment, Total - Net 805.03 889.73 950.73 931.43 815.08
Goodwill, Net 1.14M 1.44M 2.02M 1.79M 1.72M
Intangibles - Gross 883.27 904.93 1.18M 1.14M 1.12M
Accumulated Intangible Amortization -290.90 -255.32 -214.54 -166.51 -127.88
Intangibles, Net 592.36 649.61 966.37 978.17 995.52
Deferred Income Tax - Long Term Asset
Other Long Term Assets 101.68 108.85 108.00 69.95 66.79
Other Long Term Assets, Total 101.68 108.85 108.00 69.95 66.79
Total Assets 4.41M 4.84M 5.96M 5.55M 5.24M
Accounts Payable 481.24 410.23 429.13 317.33 327.01
Accrued Expenses 212.71 261.90 241.79 273.29 209.14
Notes Payable/Short Term Debt -- -- -- -- --
Current Portion of Long Term Debt/Capital Leases 160.63 42.44 42.26 49.58 133.93
Customer Advances 256.28 78.93 33.46 32.30
Income Taxes Payable 3.87 2.47 2.52
Deferred Income Tax - Current Liability
Discontinued Operations – Current Liability 18.01 2.62
Other Current Liabilities 201.53 339.91 134.08 42.25
Other Current liabilities, Total 479.68 421.31 170.06 77.17
Total Current Liabilities 1.33M 1.14M 883.24 640.20 747.25
Long Term Debt 1.04M 1.37M 1.33M 1.50M 1.20M
Total Long Term Debt 1.04M 1.37M 1.33M 1.50M 1.20M
Total Debt 1.20M 1.42M 1.37M 1.55M 1.33M
Deferred Income Tax - Long Term Liability 68.11 62.45 261.10 385.19 310.79
Deferred Income Tax 68.11 62.45 261.10 385.19 310.79
Pension Benefits - Underfunded 592.13 664.66 538.38 508.52 671.18
Other Long Term Liabilities 537.96 662.28 811.48 234.76 268.87
Other Liabilities, Total 1.13M 1.33M 1.35M 743.28 940.05
Total Liabilities 3.57M 3.90M 3.82M 3.27M 3.19M
Common Stock 0.05 0.05 0.05 0.05 0.05
Common Stock, Total 0.05 0.05 0.05 0.05 0.05
Additional Paid-In Capital 846.81 851.10 851.94 866.28 848.37
Retained Earnings (Accumulated Deficit) 579.49 630.37 1.69M 1.46M 1.26M
Treasury Stock - Common -183.70 -199.42 -203.51 -19.13 --
Cumulative Translation Adjustment -87.21 -58.82 -46.75 0.20 3.51
Minimum Pension Liability Adjustment -311.12 -285.43 -149.40 -20.60 -64.62
Other Comprehensive Income 2.15 -2.92 -2.76 1.50 0.13
Other Equity, Total -396.18 -347.16 -198.91 -18.91 -60.97
Total Equity 846.47 934.94 2.14M 2.28M 2.05M
Total Liabilities & Shareholders' Equity 4.41M 4.84M 5.96M 5.55M 5.24M
Shares Outstanding – Common Stock Primary Issue 49.57 49.33 49.27 52.16 50.12
Total Common Shares Outstanding 49.57 49.33 49.27 52.16 50.12
Treasury Shares – Common Primary Issue 2.89 3.13 3.19 0.30 --
Employees 14.31M 14.60M 15.15M 13.83M 13.90M
Number of Common Shareholders 30.00M 30.00M 30.00M 30.00M
Accumulated Intangible Amortization 290.90 255.32 214.54 166.51 127.88
Deferred Revenue - Current 256.28 78.93 33.46 32.30
Total Current Assets less Inventory 432.74 558.40 626.11 670.17 654.53
Quick Ratio 0.32 0.49 0.71 1.05 0.88
Current Ratio 1.33 1.53 2.16 2.78 2.19
Net Debt 1.13M 1.40M 1.34M 1.52M 1.30M
Tangible Book Value -888.50 -1,158.92 -855.43 -486.15 -672.08
Tangible Book Value per Share -17.92 -23.49 -17.36 -9.32 -13.41
Total Long Term Debt, Supplemental 1.21M 1.43M
Long Term Debt Maturing within 1 Year 160.63 42.44
Long Term Debt Maturing in Year 2 52.66 238.27
Long Term Debt Maturing in Year 3 50.22 191.89
Long Term Debt Maturing in Year 4 55.94 255.70
Long Term Debt Maturing in Year 5 579.05 17.71
Long Term Debt Maturing in 2-3 Years 102.88 430.16
Long Term Debt Maturing in 4-5 Years 634.99 273.41
Long Term Debt Maturing in Year 6 & Beyond 309.55 680.28
Total Operating Leases 152.12 168.31
Operating Lease Payments Due in Year 1 27.64 27.90
Operating Lease Payments Due in Year 2 22.28 24.54
Operating Lease Payments Due in Year 3 22.28 21.68
Operating Lease Payments Due in Year 4 14.87 17.93
Operating Lease Payments Due in Year 5 14.87 15.71
Operating Lease Payments Due in 2-3 Years 44.56 46.22
Operating Lease Payments Due in 4-5 Years 29.73 33.64
Standardized Operating Lease Payments Due in Year 6 and Beyond 50.18 60.54
Pension Obligation - Domestic 2.35M 2.43M
Post-Retirement Obligation 164.13 179.90
Plan Assets - Domestic 1.90M 1.93M
Plan Assets - Post-Retirement -- --
Funded Status - Domestic -446.62 -504.63
Funded Status - Post-Retirement -164.13 -179.90
Accumulated Obligation - Domestic 2.34M 2.42M
Accumulated Obligation - Post-Retirement 164.13 179.90
Total Funded Status -610.75 -684.53
Discount Rate - Domestic 2.87 3.25
Discount Rate - Post-Retirement 3.86 3.73
Compensation Rate - Domestic 3.50 3.50
Prepaid Benefits - Domestic 1.47 --
Prepaid Benefits - Post-Retirement -- --
Accrued Liabilities - Domestic -596.23 -668.29
Accrued Liabilities - Post-Retirement -15.98 -16.25
Net Assets Recognized on Balance Sheet -610.75 -684.53
Equity % - Domestic 48.00 48.00
Debt Securities % - Domestic 47.00 48.00
Private Investments % - Domestic 5.00 4.00
Other Investments % - Domestic
Total Plan Obligations 2.51M 2.61M
Total Plan Assets 1.90M 1.93M

Copyright Thomson Reuters Corporation