Answer To: I need the excel sheet completed for Acquirere YTM which is for amazon using finra bonds data.**For...
Himanshu answered on Nov 22 2021
Target_AMC
AMC Entertainment Holdings, Inc. Class A Income Statement AMC Entertainment Holdings, Inc. Class A Common Size Income Statement AMC Entertainment Holdings, Inc. Class A Growth Rate Income Statement
Source: FactSet Fundamentals Source: FactSet Fundamentals Source: FactSet Fundamentals
MAR '11 MAR '12 DEC '12 DEC '13 DEC '14 DEC '15 DEC '16 DEC '17 DEC '18 DEC '19 MAR '11 MAR '12 DEC '12 DEC '13 DEC '14 DEC '15 DEC '16 DEC '17 DEC '18 DEC '19 ST AVG ST AVG LT AVG LT AVG MAR '11 MAR '12 DEC '12 DEC '13 DEC '14 DEC '15 DEC '16 DEC '17 DEC '18 DEC '19 ST AVG ST AVG LT AVG LT AVG
364 Days 641 Days 365 Days 365 Days 365 Days 366 Days 365 Days 365 Days 365 Days 364 Days 641 Days 365 Days 365 Days 365 Days 366 Days 365 Days 365 Days 365 Days 2-YR 2-YR 10-YR 10-YR 364 Days 641 Days 365 Days 365 Days 365 Days 366 Days 365 Days 365 Days 365 Days 2-YR 2-YR 9-YR 9-YR
Restate Restate Restate Restate Target Acquirer Target Acquirer Restate Restate Target Acquirer Target Acquirer
Sales 2,362.54 - 2,690.08 2,749.43 2,695.39 2,946.90 3,235.85 5,079.20 5,460.80 5,471.00 Sales 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% Sales 2.2% -2.0% 9.3% 9.8% 57.0% 7.5% 0.2% 3.8% 25.7% 12.0% 26.5%
Cost of Goods Sold (COGS) incl. D&A 1,842.94 - 1,981.78 2,014.24 1,986.55 2,173.68 2,368.16 3,940.00 4,170.90 4,114.40 Cost of Goods Sold (COGS) incl. D&A 78.0% 73.7% 73.3% 73.7% 73.8% 73.2% 77.6% 76.4% 75.2% 75.8% 59.4% 75.0% 68.7% Cost of Goods Sold (COGS) incl. D&A -25.1% -27.7% -19.4% -19.6% 21.8% -17.9% -24.7% -21.3% 21.6% -16.1% 22.8%
COGS excluding D&A 1,631.50 - 1,778.31 1,816.70 1,770.23 1,940.72 2,099.92 3,401.40 3,633.10 3,664.40 COGS excluding D&A 69.1% 66.1% 66.1% 65.7% 65.9% 64.9% 67.0% 66.5% 67.0% 66.8% 53.9% 66.5% 64.9% COGS excluding D&A -32.5% -35.6% -28.0% -28.7% 5.1% -28.5% -32.9% -30.7% 20.8% -25.9% 21.7%
Depreciation & Amortization Expense 211.44 - 203.47 197.54 216.32 232.96 268.24 538.60 537.80 450.00 Depreciation & Amortization Expense 8.9% 7.6% 7.2% 8.0% 7.9% 8.3% 10.6% 9.8% 8.2% 9.0% 5.5% 8.5% 3.8% Depreciation & Amortization Expense -92.7% -92.1% -91.4% -90.9% -83.4% -89.4% -91.8% -90.6% 30.9% -90.2% 50.1%
Depreciation 0.00 - 0.00 177.00 194.93 210.33 239.94 495.20 498.20 444.90 Depreciation
John: Percent of previous year PPE 0.0% 12.6% 11.9% 10.6% 6.3% 11.3% 10.5% 4.7% 7.6% 5.3% 8.5% 3.6% Depreciation -93.4% -92.9% -92.2% -91.9% -84.7% -90.2% -91.9% -91.0% 31.1% -91.0% 54.4%
Amortization of Intangibles 0.00 - 0.00 20.54 21.39 22.64 28.30 43.40 39.60 5.10 Amortization of Intangibles
John: Percent of previous year intangible assets 0.0% 7.5% 8.1% 8.1% 6.8% 9.3% 8.7% 2.6% 5.6% 0.2% 6.4% 0.2% Amortization of Intangibles -99.2% -99.2% -99.2% -99.0% -98.7% -99.2% -99.9% -99.6% 24.4% -99.2% 21.5%
Gross Income 519.60 - 708.30 735.19 708.84 773.22 867.68 1,139.20 1,289.90 1,356.60 Gross Income 22.0% 26.3% 26.7% 26.3% 26.2% 26.8% 22.4% 23.6% 24.8% 24.2% 40.6% 25.0% 31.3% Gross Income -72.7% -74.2% -71.3% -70.6% -64.8% -74.6% -75.2% -74.9% 32.4% -71.9% 35.3%
SG&A Expense 515.03 - 521.46 549.12 520.11 526.03 589.18 927.60 971.40 1,120.80 SG&A Expense 21.8% 19.4% 20.0% 19.3% 17.9% 18.2% 18.3% 17.8% 20.5% 19.1% 35.3% 19.2% 28.5% SG&A Expense -79.6% -81.1% -80.5% -80.0% -71.3% -80.9% -79.5% -80.2% 27.6% -79.0% 36.8%
Other SG&A 515.03 - 521.46 549.12 520.11 526.03 589.18 927.60 971.40 1,120.80 Other SG&A 21.8% 19.4% 20.0% 19.3% 17.9% 18.2% 18.3% 17.8% 20.5% 19.1% 22.7% 19.2% 18.5% Other SG&A -79.6% -81.1% -80.5% -80.0% -71.3% -80.9% -79.5% -80.2% 28.5% -79.0% 35.1%
EBIT (Operating Income) 4.57 - 186.84 186.07 188.73 247.19 278.50 211.60 318.50 235.80 EBIT (Operating Income) 0.2% 6.9% 6.8% 7.0% 8.4% 8.6% 4.2% 5.8% 4.3% 5.1% 5.4% 5.8% 2.8% EBIT (Operating Income) -93.1% -93.1% -90.8% -90.5% -93.5% -93.7% -95.7% -94.7% 105.1% -92.9% 94.7%
Nonoperating Income - Net 39.42 - 5.08 56.71 34.72 43.25 57.89 (161.10) 90.00 47.40 Nonoperating Income - Net 1.7% 0.2% 2.1% 1.3% 1.5% 1.8% -3.2% 1.6% 0.9% 1.3% 0.2% 0.9% -0.1% Nonoperating Income - Net -97.9% -98.7% -98.4% -98.0% -105.0% -98.2% -99.1% -98.7% 367.7% -99.3% 113.3%
Nonoperating Interest Income 0.48 - 0.05 2.87 8.18 5.96 8.34 22.60 6.20 6.70 Nonoperating Interest Income 0.0% 0.0% 0.1% 0.3% 0.2% 0.3% 0.4% 0.1% 0.1% 0.1% 0.2% 0.2% 0.1% Nonoperating Interest Income -99.9% -99.7% -99.8% -99.7% -99.3% -99.9% -99.9% -99.9% 103.5% -99.7% 46.7%
Equity in Earnings of Affiliates 17.18 - 6.75 47.44 26.62 37.13 47.72 (186.10) 84.50 30.60 Equity in Earnings of Affiliates 0.7% 0.3% 1.7% 1.0% 1.3% 1.5% -3.7% 1.5% 0.6% 1.1% -0.0% 0.5% -0.0% Equity in Earnings of Affiliates -98.2% -99.0% -98.6% -98.4% -105.8% -98.3% -99.4% -98.9% -290.3% -99.7% 23.8%
Other Income (Expense) 21.75 - (1.73) 6.41 (0.07) 0.16 1.84 2.40 (0.70) 10.10 Other Income (Expense) 0.9% -0.1% 0.2% -0.0% 0.0% 0.1% 0.0% -0.0% 0.2% 0.1% -0.1% 0.2% -0.2% Other Income (Expense) -99.8% -100.0% -100.0% -99.9% -99.9% -100.0% -99.8% -99.9% -855.2% -99.9% -158.0%
Interest Expense 183.66 - 156.18 140.23 120.94 106.09 121.54 274.00 342.30 340.80 Interest Expense
Phnesha Davis: Phnesha Davis:
Percent pf previous years interest bearing debt. 6.4% 5.5% 5.6% 6.0% 6.2% 7.0% 6.5% 6.7% 3.2% 6.2% 3.8% Interest Expense -94.8% -95.6% -96.1% -95.9% -91.5% -93.3% -93.8% -93.5% 40.0% -94.4% 54.4%
Unusual Expense - Net 29.62 - 10.38 2.84 5.27 20.81 65.22 109.60 (57.50) 114.00 Unusual Expense - Net 1.3% 0.4% 0.1% 0.2% 0.7% 2.0% 2.2% -1.1% 2.1% 0.5% 0.0% 0.9% -0.0% Unusual Expense - Net -99.9% -99.8% -99.2% -97.8% -96.6% -101.1% -97.9% -99.5% -164.3% -98.9% -88.6%
Impairments 12.78 - 0.00 1.37 3.15 1.70 5.54 43.60 13.80 87.90 Impairments 0.5% 0.0% 0.0% 0.1% 0.1% 0.2% 0.9% 0.3% 1.6% 0.9% ERROR:#N/A 0.4% ERROR:#N/A Impairments -99.9% -99.9% -99.9% -99.8% -98.7% -99.7% -98.4% -99.1% ERROR:#N/A -99.5% ERROR:#N/A
Property,Plant & Equipment 12.78 - 0.00 1.37 3.15 1.70 5.54 43.60 13.80 84.30 Property,Plant & Equipment 0.5% 0.0% 0.0% 0.1% 0.1% 0.2% 0.9% 0.3% 1.5% 0.9% ERROR:#N/A 0.4% ERROR:#N/A Property,Plant & Equipment -99.9% -99.9% -99.9% -99.8% -98.7% -99.7% -98.5% -99.1% ERROR:#N/A -99.5% ERROR:#N/A
Financial Fixed Assets - - - - - - - - - 3.60 Financial Fixed Assets 0.1% 0.1% ERROR:#N/A 0.1% ERROR:#N/A Financial Fixed Assets -99.9% -99.9% ERROR:#N/A -99.9% ERROR:#N/A
Restructuring Expense 16.84 - 10.38 0.00 10.51 8.43 53.10 65.60 34.00 15.50 Restructuring Expense 0.7% 0.4% 0.0% 0.4% 0.3% 1.6% 1.3% 0.6% 0.3% 0.5% ERROR:#N/A 0.6% ERROR:#N/A Restructuring Expense -100.0% -99.6% -99.7% -98.2% -98.0% -99.3% -99.7% -99.5% ERROR:#N/A -99.2% ERROR:#N/A
Legal Claim Expense - - - - - 0.00 7.00 - 5.70 - Legal Claim Expense 0.0% 0.2% 0.1% 0.1% ERROR:#N/A 0.1% ERROR:#N/A Legal Claim Expense -100.0% -99.8% -99.9% -99.9% ERROR:#N/A -99.9% ERROR:#N/A
Unrealized Valuation Gain/Loss - - - - - - - - 111.40 4.90 Unrealized Valuation Gain/Loss 2.0% 0.1% 1.1% -0.0% 1.1% 0.0% Unrealized Valuation Gain/Loss -97.8% -99.9% -98.9% -164.3% -98.9% -88.6%
Hedges/Derivatives - - - - - - - - 111.40 4.90 Hedges/Derivatives 2.0% 0.1% 1.1% -0.0% 1.1% 0.0% Hedges/Derivatives -97.8% -99.9% -98.9% -164.3% -98.9% -88.6%
Excpl Chrgs - Others - - - 1.47 (8.39) 10.68 (0.42) 0.40 0.40 15.50 Excpl Chrgs - Others 0.1% -0.3% 0.4% -0.0% 0.0% 0.0% 0.3% 0.1% ERROR:#N/A 0.1% ERROR:#N/A Excpl Chrgs - Others -99.9% -100.3% -99.6% -100.0% -100.0% -100.0% -99.7% -99.9% ERROR:#N/A -99.9% ERROR:#N/A
Restructuring of Debt - - - - (8.39) 10.68 0.00 0.40 0.40 16.60 Restructuring of Debt -0.3% 0.4% 0.0% 0.0% 0.0% 0.3% 0.2% ERROR:#N/A 0.1% ERROR:#N/A Restructuring of Debt -100.3% -99.6% -100.0% -100.0% -100.0% -99.7% -99.8% ERROR:#N/A -99.9% ERROR:#N/A
Calamitous Events - - - - - - - - 0.00 (1.10) Calamitous Events 0.0% -0.0% -0.0% ERROR:#N/A -0.0% ERROR:#N/A Calamitous Events -100.0% -100.0% -100.0% ERROR:#N/A -100.0% ERROR:#N/A
Other Unusual Expense - - - - 0.00 0.00 (0.42) - - - Other Unusual Expense 0.0% 0.0% -0.0% ERROR:#N/A -0.0% ERROR:#N/A Other Unusual Expense -100.0% -100.0% -100.0% ERROR:#N/A -100.0% ERROR:#N/A
Pretax Income (169.29) - 25.36 99.72 97.24 163.53 149.64 (333.10) 123.70 (171.60) (171.60) Pretax Income -7.2% 0.9% 3.6% 3.6% 5.5% 4.6% -6.6% 2.3% -3.1% -0.4% 4.9% 0.4% 2.4% Pretax Income -96.3% -96.5% -93.9% -94.9% -110.3% -97.6% -103.1% -100.4% 110.0% -98.9% -150.5%
Income Taxes 1.95 - 0.64 (263.38) 33.47 59.68 37.97 154.10 13.60 (22.50) 0.00 Income Taxes -1.2%
Phnesha Davis: Phnesha Davis:
Tax rate = Income Taxes/Pretax Income 2.5% -264.1% 34.4% 36.5% 25.4% -46.3% 11.0% 13.1% 12.1% 13.8% -21.0% 16.0% Income Taxes -109.8% -98.8% -97.8% -98.7% -95.2% -99.7% -100.4% -100.1% 77.0% -100.1% 66.4%
Income Tax Credits - - - 0.00 0.21 0.00 0.00 0.00 0.00 0.00 Income Tax Credits 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% ERROR:#N/A 0.0% ERROR:#N/A Income Tax Credits -100.0% -100.0% -100.0% -100.0% -100.0% -100.0% -100.0% -100.0% ERROR:#N/A -100.0% ERROR:#N/A
Consolidated Net Income (171.24) - 24.72 363.10 63.77 103.86 111.67 (487.20) 110.10 (149.10) Consolidated Net Income -7.2% 0.9% 13.2% 2.4% 3.5% 3.5% -9.6% 2.0% -2.7% -0.4% 4.2% 0.7% 1.7% Consolidated Net Income -86.5% -97.7% -96.1% -96.2% -115.1% -97.8% -102.7% -100.3% 123.6% -98.9% -101.8%
Net Income (171.24) - 24.72 363.10 63.77 103.86 111.67 (487.20) 110.10 (149.10) Net Income -7.2% 0.9% 13.2% 2.4% 3.5% 3.5% -9.6% 2.0% -2.7% -0.4% 4.2% 0.7% 1.7% Net Income -86.5% -97.7% -96.1% -96.2% -115.1% -97.8% -102.7% -100.3% 123.6% -98.9% -101.8%
Discontinued Operations (3.06) - 45.95 1.30 0.31 0.00 0.00 0.00 0.00 0.00 Discontinued Operations -0.1% 1.7% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% ERROR:#N/A 0.2% ERROR:#N/A Discontinued Operations -100.0% -100.0% -100.0% -100.0% -100.0% -100.0% -100.0% -100.0% ERROR:#N/A -100.0% ERROR:#N/A
Net Income available to Common (174.30) - 70.68 364.40 64.08 103.86 111.67 (487.20) 110.10 (149.10) Net Income available to Common -7.4% 2.6% 13.3% 2.4% 3.5% 3.5% -9.6% 2.0% -2.7% -0.4% 4.2% 0.8% 1.7% Net Income available to Common -86.5% -97.7% -96.1% -96.2% -115.1% -97.8% -102.7% -100.3% 123.6% -98.9% -101.8%
Per Share All figures in millions of U.S. Dollar except per share items. All figures in millions of U.S. Dollar except per share items.
EPS (recurring) (1.57) - 0.80 4.79 0.69 1.21 1.59 (3.20) 0.10 (0.67)
Basic Shares Outstanding 97.68 - 97.68 76.53 97.51 97.96 98.84 128.25 120.62 103.83
Total Shares Outstanding 97.68 - 97.68 94.61 97.25 97.24 110.03 127.64 103.48 103.85
EPS (diluted) (1.78) - 0.72 4.76 0.66 1.06 1.13 (3.80) 0.41 (1.44)
Diluted Shares Outstanding 97.68 - 97.68 76.53 97.70 98.03 98.87 128.25 130.11 103.83
Total Shares Outstanding 97.68 - 97.68 94.61 97.25 97.24 110.03 127.64 103.48 103.85
Earnings Persistence - - - 84.34 94.50 89.43 68.10 89.87 91.03 73.05
Dividends per Share 0.00 - - 0.00 0.60 0.80 0.80 0.80 0.80 0.80
Payout Ratio - - - 0.00 90.91 75.47 70.80 - 194.93 -
EBITDA
EBITDA 216.01 - 390.32 383.61 405.05 480.15 546.74 750.20 856.30 685.80
EBIT 4.57 - 186.84 186.07 188.73 247.19 278.50 211.60 318.50 235.80
Depreciation & Amortization Expense 211.44 - 203.47 197.54 216.32 232.96 268.24 538.60 537.80 450.00
All figures in millions of U.S. Dollar except per share items. 4.57
211.44
AMC Entertainment Holdings, Inc. Class A Balance Sheet AMC Entertainment Holdings, Inc. Class A Common Size Balance Sheet AMC Entertainment Holdings, Inc. Class A Growth Rate Balance Sheet
Source: FactSet Fundamentals Source: FactSet Fundamentals Source: FactSet Fundamentals
MAR '11 MAR '12 DEC '12 DEC '13 DEC '14 DEC '15 DEC '16 DEC '17 DEC '18 DEC '19 MAR '11 MAR '12 DEC '12 DEC '13 DEC '14 DEC '15 DEC '16 DEC '17 DEC '18 DEC '19 ST AVG ST AVG LT AVG LT AVG MAR '11 MAR '12 DEC '12 DEC '13 DEC '14 DEC '15 DEC '16 DEC '17 DEC '18 DEC '19 ST AVG ST AVG LT AVG LT AVG
641 Days 365 Days 365 Days 365 Days 366 Days 365 Days 365 Days 365 Days 641 Days 365 Days 365 Days 365 Days 366 Days 365 Days 365 Days 365 Days 2-YR 2-YR 10-YR 10-YR 641 Days 365 Days 365 Days 365 Days 366 Days 365 Days 365 Days 365 Days 2-YR 2-YR 9-YR 9-YR
Restate Restate Restate Restate Target Acquirer Target Acquirer Restate Restate Target Acquirer Target Acquirer
Assets Assets Assets
Cash & Short-Term Investments 133.07 546.45 218.21 211.25 230.21 318.30 324.00 275.50 Cash & Short-Term Investments 3.1% 10.8% 4.6% 4.2% 2.7% 3.2% 3.4% 2.0% 2.7% 25.1% 4.3% 32.0% Cash & Short-Term Investments 310.6% -60.1% -3.2% 9.0% 38.3% 1.8% -15.0% -6.6% 30.9% 40.2% 22.9%
Cash Only 133.07 546.45 218.21 211.25 230.21 318.30 324.00 275.50 Cash Only
John: Percentage of sales 4.9% 19.9% 8.1% 7.2% 7.1% 6.3% 5.9% 5.0% 5.5% 18.0% 8.1% 21.6% Cash Only 310.6% -60.1% -3.2% 9.0% 38.3% 1.8% -15.0% -6.6% 30.2% 40.2% 29.6%
Short-Term Receivables 102.91 110.02 102.28 106.08 222.39 298.00 284.20 265.90 Short-Term Receivables 2.4% 2.2% 2.1% 2.1% 2.6% 3.0% 3.0% 1.9% 2.5% 9.5% 2.4% 9.2% Short-Term Receivables 6.9% -7.0% 3.7% 109.6% 34.0% -4.6% -6.4% -5.5% 31.7% 19.5% 35.7%
Accounts Receivables, Net 97.11 106.15 99.25 105.51 213.67 271.50 259.50 160.30 Accounts Receivables, Net 2.3% 2.1% 2.1% 2.1% 2.5% 2.8% 2.7% 1.2% 2.0% 8.3% 2.2% 7.1% Accounts Receivables, Net 9.3% -6.5% 6.3% 102.5% 27.1% -4.4% -38.2% -21.3% 63.6% 13.7% 36.7%
Accounts Receivables, Gross 97.11 106.15 99.25 105.51 213.67 271.50 259.50 160.30 Accounts Receivables, Gross
John: Percentage of sales 3.6% 3.9% 3.7% 3.6% 6.6% 5.3% 4.8% 2.9% 3.8% 8.6% 4.3% 7.4% Accounts Receivables, Gross 9.3% -6.5% 6.3% 102.5% 27.1% -4.4% -38.2% -21.3% 62.8% 13.7% 36.3%
Other Receivables 5.81 3.87 3.03 0.57 8.72 26.50 24.70 105.60 Other Receivables
John: Percentage of sales
0.2% 0.1% 0.1% 0.0% 0.3% 0.5% 0.5% 1.9% 1.2% 1.3% 0.5% 2.2% Other Receivables -33.3% -21.8% -81.2% 1430.2% 203.8% -6.8% 327.5% 160.4% -51.0% 259.8% 22.1%
Inventories 8.86 10.65 10.52 13.99 29.04 34.00 35.20 37.50 Inventories
John: Percentage of sales 0.3% 0.4% 0.4% 0.5% 0.9% 0.7% 0.6% 0.7% 0.7% 9.8% 0.6% 14.8% Inventories 20.2% -1.2% 33.1% 107.6% 17.1% 3.5% 6.5% 5.0% 13.2% 26.7% 23.7%
Other Current Assets 86.26 176.41 178.74 83.05 202.00 222.10 137.90 94.20 Other Current Assets 2.0% 3.5% 3.8% 1.6% 2.3% 2.3% 1.5% 0.7% 1.1% 2.2% 1.3% Other Current Assets 104.5% 1.3% -53.5% 143.2% 9.9% -37.9% -31.7% -34.8% 19.4% 54.1%
Prepaid Expenses 47.60 37.84 55.53 59.62 93.28 114.10 99.80 63.40 Prepaid Expenses
John: Percentage of sales 1.8% 1.4% 2.1% 2.0% 2.9% 2.2% 1.8% 1.2% 1.5% ERROR:#N/A 1.9% ERROR:#N/A Prepaid Expenses -20.5% 46.8% 7.4% 56.5% 22.3% -12.5% -36.5% -24.5% ERROR:#N/A 9.1% ERROR:#N/A
Miscellaneous Current Assets 38.66 138.57 123.20 23.43 108.73 108.00 38.10 30.80 Miscellaneous Current Assets 0.9% 2.7% 2.6% 0.5% 1.3% 1.1% 0.4% 0.2% 0.3% 1.2% 1.3% Miscellaneous Current Assets 258.4% -11.1% -81.0% 364.0% -0.7% -64.7% -19.2% -41.9% 63.7% 54.1%
Total Current Assets 331.11 843.52 509.74 414.37 683.64 872.40 781.30 673.10 Total Current Assets 7.7% 16.7% 10.7% 8.1% 7.9% 8.9% 8.2% 4.9% 6.6% 44.5% 9.2% 56.4% Total Current Assets 154.8% -39.6% -18.7% 65.0% 27.6% -10.4% -13.8% -12.1% 26.5% 23.5% 24.3%
Net Property, Plant & Equipment 1,179.98 1,179.75 1,247.23 1,401.93 3,035.86 3,116.50 3,039.60 7,561.00 Net Property, Plant & Equipment 27.6% 23.4% 26.2% 27.6% 35.1% 31.8% 32.0% 55.3% 43.6% 40.7% 32.4% 29.4% Net Property, Plant & Equipment -0.0% 5.7% 12.4% 116.5% 2.7% -2.5% 148.7% 73.1% 42.4% 40.5% 51.9%
Property, Plant & Equipment - Gross 1,242.91 1,407.99 1,644.32 1,985.03 3,828.15 4,383.40 4,736.70 9,381.10 Property, Plant & Equipment - Gross 33.0% 32.6% 41.7% 75.2% 50.7% 48.3% 98.8% 73.5% 81.0% 54.3% 59.1% Property, Plant & Equipment - Gross 13.3% 16.8% 20.7% 92.9% 14.5% 8.1% 98.1% 53.1% 41.5% 37.8% 53.2%
Accumulated Depreciation 62.93 228.24 397.09 583.10 792.29 1,266.90 1,697.10 1,820.10 Accumulated Depreciation
Phnesha Davis: Phnesha Davis:
Percent of Gross PPE 5.1% 16.2% 24.1% 29.4% 20.7% 28.9% 35.8% 19.4% 27.6% 34.0% 22.5% 28.7% Accumulated Depreciation 262.7% 74.0% 46.8% 35.9% 59.9% 34.0% 7.2% 20.6% 40.5% 74.4% 57.1%
Total Investments and Advances 295.93 349.09 358.17 442.88 430.04 332.10 335.20 321.90 Total Investments and Advances 6.9% 6.9% 7.5% 8.7% 5.0% 3.4% 3.5% 2.4% 2.9% 0.6% 5.5% 0.9% Total Investments and Advances 18.0% 2.6% 23.7% -2.9% -22.8% 0.9% -4.0% -1.5% -22.4% 2.2% 50.8%
LT Investment - Affiliate Companies 267.42 338.35 346.87 419.67 416.49 309.50 232.40 239.10 LT Investment - Affiliate Companies 6.3% 6.7% 7.3% 8.2% 4.8% 3.2% 2.4% 1.7% 2.1% 0.0% 5.1% 0.1% LT Investment - Affiliate Companies 26.5% 2.5% 21.0% -0.8% -25.7% -24.9% 2.9% -11.0% 0.2% -26.1%
Other Long-Term Investments 28.51 10.73 11.30 23.21 13.56 22.60 102.80 82.80 Other Long-Term Investments 0.7% 0.2% 0.2% 0.5% 0.2% 0.2% 1.1% 0.6% 0.8% 0.6% 0.5% 0.8% Other Long-Term Investments -62.3% 5.3% 105.4% -41.6% 66.7% 354.9% -19.5% 167.7% -22.4% 58.4% 54.6%
Intangible Assets 2,460.87 2,563.36 2,553.93 2,685.45 4,351.68 5,395.90 5,245.10 4,984.40 Intangible Assets 57.6% 50.8% 53.6% 52.8% 50.4% 55.0% 55.2% 36.4% 45.8% 9.9% 51.5% 9.1% Intangible Assets 4.2% -0.4% 5.1% 62.0% 24.0% -2.8% -5.0% -3.9% 6.2% 12.5% 41.5%
Goodwill 2,217.69 2,289.80 2,289.80 2,406.69 3,932.96 4,931.70 4,788.70 4,789.10 Goodwill 51.9% 45.4% 48.1% 47.3% 45.5% 50.3% 50.4% 35.0% 42.7% 7.7% 46.7% 7.1% Goodwill 3.3% 0.0% 5.1% 63.4% 25.4% -2.9% 0.0% -1.4% 5.2% 13.5% 42.4%
Other Intangible Assets 243.18 273.56 264.13 278.75 418.72 464.20 456.40 195.30 Other Intangible Assets 5.7% 5.4% 5.5% 5.5% 4.8% 4.7% 4.8% 1.4% 3.1% 2.2% 4.7% 2.0% Other Intangible Assets 12.5% -3.4% 5.5% 50.2% 10.9% -1.7% -57.2% -29.4% 10.2% 2.4% 40.6%
Deferred Tax Assets 0.00 96.82 73.84 126.20 90.45 28.90 28.60 70.10 Deferred Tax Assets 0.0% 1.9% 1.6% 2.5% 1.0% 0.3% 0.3% 0.5% 0.4% 1.0% 2.1% Deferred Tax Assets -23.7% 70.9% -28.3% -68.0% -1.0% 145.1% 72.0% 15.8% 257.3%
Other Assets 4.79 14.18 20.82 17.50 50.17 60.10 66.00 65.30 Other Assets 0.1% 0.3% 0.4% 0.3% 0.6% 0.6% 0.7% 0.5% 0.6% 4.3% 0.4% 2.7% Other Assets 196.2% 46.8% -15.9% 186.7% 19.8% 9.8% -1.1% 4.4% 71.2% 63.2% 48.8%
Deferred Charges 0.00 7.84 13.13 9.69 26.58 36.40 32.40 30.90 Deferred Charges 0.0% 0.2% 0.3% 0.2% 0.3% 0.4% 0.3% 0.2% 0.3% ERROR:#N/A 0.2% ERROR:#N/A Deferred Charges 67.4% -26.2% 174.4% 37.0% -11.0% -4.6% -7.8% ERROR:#N/A 39.5% ERROR:#N/A
Tangible Other Assets 4.79 6.34 7.69 7.81 23.60 23.70 33.60 34.40 Tangible Other Assets 0.1% 0.1% 0.2% 0.2% 0.3% 0.2% 0.4% 0.3% 0.3% 4.3% 0.2% 2.7% Tangible Other Assets 32.4% 21.2% 1.6% 202.0% 0.4% 41.8% 2.4% 22.1% 71.2% 43.1% 48.8%
Total Assets 4,272.68 5,046.72 4,763.73 5,088.32 8,641.84 9,805.90 9,495.80 13,675.80 Total Assets 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% Total Assets 18.1% -5.6% 6.8% 69.8% 13.5% -3.2% 44.0% 20.4% 31.2% 20.5% 32.1%
Liabilities & Shareholders' Equity Liabilities & Shareholders' Equity 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Liabilities & Shareholders' Equity
Current Current 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Current
ST Debt & Curr. Portion LT Debt 14.28 16.08 23.60 18.79 81.24 87.70 82.20 616.10 ST Debt & Curr. Portion LT Debt 0.3% 0.3% 0.5% 0.4% 0.9% 0.9% 0.9% 4.5% 2.7% 6.1% 1.1% 4.5% ST Debt & Curr. Portion LT Debt 12.6% 46.8% -20.4% 332.5% 7.9% -6.3% 649.5% 321.6% 52.3% 146.1% 64.8%
Accounts Payable 226.22 268.16 262.64 313.03 501.76 569.60 452.60 543.30 Accounts Payable
John:
Percentage of sales 8.4% 9.8% 9.7% 10.6% 15.5% 11.2% 8.3% 9.9% 9.1% 22.2% 10.4% 32.4% Accounts Payable 18.5% -2.1% 19.2% 60.3% 13.5% -20.5% 20.0% -0.3% 16.9% 15.6% 22.1%
Income Tax Payable 0.00 46.25 - - - - - - Income Tax Payable
John: Percentage of sales
Phnesha Davis: Phnesha Davis:
Tax rate = Income Taxes/Pretax Income
John: Percentage of sales
John: Percentage of sales
John: Percentage of sales
0.0% 1.7% ERROR:#N/A 0.8% ERROR:#N/A Income Tax Payable ERROR:#N/A ERROR:#N/A
Other Current Liabilities 326.41 327.50 350.14 380.34 606.19 752.10 793.30 773.80 Other Current Liabilities 7.6% 6.5% 7.4% 7.5% 7.0% 7.7% 8.4% 5.7% 7.0% 12.2% 7.2% 13.5% Other Current Liabilities 0.3% 6.9% 8.6% 59.4% 24.1% 5.5% -2.5% 1.5% 24.1% 14.6% 32.7%
Accrued Payroll 18.80 59.38 28.45 32.67 77.60 48.90 79.20 76.80 Accrued Payroll 0.4% 1.2% 0.6% 0.6% 0.9% 0.5% 0.8% 0.6% 0.7% ERROR:#N/A 0.7% ERROR:#N/A Accrued Payroll 215.9% -52.1% 14.8% 137.5% -37.0% 62.0% -3.0% 29.5% ERROR:#N/A 48.3% ERROR:#N/A
Miscellaneous Current Liabilities 307.61 268.12 321.69 347.67 528.59 703.20 714.10 697.00 Miscellaneous Current Liabilities 7.2% 5.3% 6.8% 6.8% 6.1% 7.2% 7.5% 5.1% 6.3% 12.2% 6.5% 13.5% Miscellaneous Current Liabilities -12.8% 20.0% 8.1% 52.0% 33.0% 1.6% -2.4% -0.4% 24.1% 14.2% 32.7%
Total Current Liabilities 566.91 658.00 636.38 712.15 1,189.19 1,409.40 1,328.10 1,933.20 Total Current Liabilities 13.3% 13.0% 13.4% 14.0% 13.8% 14.4% 14.0% 14.1% 14.1% 40.5% 13.7% 50.4% Total Current Liabilities 16.1% -3.3% 11.9% 67.0% 18.5% -5.8% 45.6% 19.9% 23.3% 21.4% 27.0%
Long-Term Long-Term 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Long-Term
Long-Term Debt 2,187.04 2,178.93 1,876.67 1,995.87 4,355.11 4,799.00 5,201.00 9,736.80 Long-Term Debt 51.0%
Phnesha Davis: Phnesha Davis:
Previous years assets
John: Percentage of sales 37.2% 41.9% 85.6% 55.5% 53.0% 102.5% 77.8% 34.6% 61.0% 25.5% Long-Term Debt -0.4% -13.9% 6.4% 118.2% 10.2% 8.4% 87.2% 47.8% 31.9% 30.9% 78.0%
Long-Term Debt excl Lease Obligations 2,070.67 2,069.67 1,775.13 1,902.60 3,745.76 4,220.10 4,707.80 4,733.40 Long-Term Debt excl Lease Obligations 48.4%
Phnesha Davis: Phnesha Davis:
Previous years assets 35.2% 39.9% 73.6% 48.8% 48.0% 49.8% 48.9% 16.1% 49.1% 14.5% Long-Term Debt excl Lease Obligations -0.0% -14.2% 7.2% 96.9% 12.7% 11.6% 0.5% 6.1% -2.7% 16.4% 168.9%
Capital and Operating Lease Obligations 116.37 109.26 101.53 93.27 609.36 578.90 493.20 5,003.40 Capital and Operating Lease Obligations 2.6%
Phnesha Davis: Phnesha Davis:
Previous years assets
John: Percent of previous year PPE
John: Percentage of sales
John: Percent of previous year intangible assets
Phnesha Davis: Phnesha Davis:
Percent of previous year's assets
Phnesha Davis: Phnesha Davis:
Percent of Gross PPE 2.0% 2.0% 12.0% 6.7% 5.0% 52.7% 28.9% 18.4% 11.8% 11.0% Capital and Operating Lease Obligations -6.1% -7.1% -8.1% 553.3% -5.0% -14.8% 914.5% 449.8% 83.9% 203.8% 78.6%
Provision for Risks & Charges - 30.18 48.44 90.83 86.51 98.50 82.30 77.80 Provision for Risks & Charges 0.6% 1.0% 1.8% 1.0% 1.0% 0.9% 0.6% 0.7% 0.3% 1.0% 1.0% Provision for Risks & Charges 60.5% 87.5% -4.7% 13.9% -16.4% -5.5% -11.0% -55.4% 22.5% 8.6%
Deferred Tax Liabilities 40.75 0.00 - - - 49.60 41.60 46.00 Deferred Tax Liabilities 1.0% 0.0% 0.5% 0.4% 0.3% 0.4% 0.9% 0.4% 3.1% Deferred Tax Liabilities -100.0% -16.1% 10.6% -2.8% 50.5% -35.2% 9.5%
Other Liabilities 703.87 670.68 688.10 749.40 1,000.29 1,336.20 1,444.80 667.80 Other Liabilities 16.5% 13.3% 14.4% 14.7% 11.6% 13.6% 15.2% 4.9% 10.0% 5.3% 13.0% 3.9% Other Liabilities -4.7% 2.6% 8.9% 33.5% 33.6% 8.1% -53.8% -22.8% 44.9% 4.0% 39.5%
Other Liabilities (excl. Deferred Income) 385.72 266.86 551.87 529.73 642.70 1,251.20 1,330.70 667.80 Other Liabilities (excl. Deferred Income) 9.0% 5.3% 11.6% 10.4% 7.4% 12.8% 14.0% 4.9% 9.4% 4.5% 9.4% 3.5% Other Liabilities (excl. Deferred Income) -30.8% 106.8% -4.0% 21.3% 94.7% 6.4% -49.8% -21.7% 45.6% 20.6% 36.9%
Deferred Income 318.15 403.82 136.23 219.67 357.60 85.00 114.10 0.00 Deferred Income 7.4% 8.0% 2.9% 4.3% 4.1% 0.9% 1.2% 0.0% 0.6% 0.9% 3.6% 0.6% Deferred Income 26.9% -66.3% 61.3% 62.8% -76.2% 34.2% -100.0% -32.9% 41.4% -8.2% 71.9%
Total Liabilities 3,498.57 3,537.79 3,249.57 3,548.25 6,631.11 7,692.70 8,097.80 12,461.60 Total Liabilities 81.9% 70.1% 68.2% 69.7% 76.7% 78.4% 85.3% 91.1% 88.2% 72.8% 77.7% 74.7% Total Liabilities 1.1% -8.1% 9.2% 86.9% 16.0% 5.3% 53.9% 29.6% 26.0% 23.5% 34.3%
Non-Equity Reserves 0.00 1.47 1.43 0.00 0.00 0.00 0.00 0.00 Non-Equity Reserves 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% ERROR:#N/A 0.0% ERROR:#N/A Non-Equity Reserves -2.9% -100.0% ERROR:#N/A -51.5% ERROR:#N/A
Equity Equity 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Equity
Preferred Stock (Carrying Value) 0.00 0.00 0.00 1.36 1.08 0.80 0.40 0.00 Preferred Stock (Carrying Value) 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% ERROR:#N/A 0.0% ERROR:#N/A Preferred Stock (Carrying Value) -20.8% -25.9% -50.0% -100.0% -75.0% ERROR:#N/A -49.2% ERROR:#N/A
Redeemable Preferred Stock 0.00 0.00 0.00 1.36 1.08 0.80 0.40 0.00 Redeemable Preferred Stock 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% ERROR:#N/A 0.0% ERROR:#N/A Redeemable Preferred Stock -20.8% -25.9% -50.0% -100.0% -75.0% ERROR:#N/A -49.2% ERROR:#N/A
Common Equity 774.11 1,507.47 1,512.73 1,538.70 2,009.65 2,112.40 1,397.60 1,214.20 Common Equity 18.1% 29.9% 31.8% 30.2% 23.3% 21.5% 14.7% 8.9% 11.8% 27.2% 22.3% 25.3% Common Equity 94.7% 0.3% 1.7% 30.6% 5.1% -33.8% -13.1% -23.5% 49.8% 12.2% 28.9%
Common Stock Par/Carry Value 0.02 0.97 0.97 0.97 1.10 1.30 1.00 1.00 Common Stock Par/Carry Value 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Common Stock Par/Carry Value 6380.0% 0.0% 0.0% 13.2% 18.2% -23.1% 0.0% -11.5% 0.0% 912.6% 0.0%
Additional Paid-In Capital/Capital Surplus 801.80 1,161.15 1,172.52 1,182.92 1,627.38 2,241.60 1,998.40 2,001.90 Additional Paid-In Capital/Capital Surplus 18.8% 23.0% 24.6% 23.2% 18.8% 22.9% 21.0% 14.6% 17.8% 15.7% 20.9% 21.8% Additional Paid-In Capital/Capital Surplus 44.8% 1.0% 0.9% 37.6% 37.7% -10.8% 0.2% -5.3% 25.4% 15.9% 20.5%
Retained Earnings (37.15) 321.73 327.08 352.68 384.40 (207.90) (550.90) (706.20) Retained Earnings -0.9% 6.4% 6.9% 6.9% 4.4% -2.1% -5.8% -5.2% -5.5% 13.0% 1.3% 7.1% Retained Earnings -966.0% 1.7% 7.8% 9.0% -154.1% 165.0% 28.2% 96.6% 93.2% -129.8% 48.3%
Cumulative Translation Adjustment/Unrealized For. Exch. Gain (0.53) 0.00 0.63 2.10 (1.78) 129.90 7.20 (8.80) Cumulative Translation Adjustment/Unrealized For. Exch. Gain -0.0% 0.0% 0.0% 0.0% -0.0% 1.3% 0.1% -0.1% 0.0% 0.2% -1.0% Cumulative Translation Adjustment/Unrealized For. Exch. Gain -100.0% 235.1% -184.7% -7397.8% -94.5% -222.2% -158.3% -1294.0% 44.3%
Unrealized Gain/Loss Marketable Securities 1.91 0.00 3.81 1.47 0.24 0.60 0.00 0.00 Unrealized Gain/Loss Marketable Securities 0.0% 0.0% 0.1% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Unrealized Gain/Loss Marketable Securities -100.0% -61.6% -83.8% 152.1% -100.0% -100.0% -38.6% -306.4%
Other Appropriated Reserves 8.06 24.20 8.41 (0.76) (1.01) (4.90) (1.70) (17.30) Other Appropriated Reserves 0.2% 0.5% 0.2% -0.0% -0.0% -0.0% -0.0% -0.1% -0.1% -0.5% 0.1% -0.5% Other Appropriated Reserves 200.3% -65.3% -109.1% 32.4% 385.6% -65.3% 917.6% 426.2% 54.6% 185.2% 54.6%
Treasury Stock 0.00 (0.59) (0.68) (0.68) (0.68) (48.20) (56.40) (56.40) Treasury Stock 0.0% -0.0% -0.0% -0.0% -0.0% -0.5% -0.6% -0.4% -0.5% -1.0% -0.2% -2.8% Treasury Stock 15.6% 0.0% 0.0% 6988.2% 17.0% 0.0% 8.5% 0.0% 1170.1% 17.3%
Total Shareholders' Equity 774.11 1,507.47 1,512.73 1,540.07 2,010.73 2,113.20 1,398.00 1,214.20 Total Shareholders' Equity 18.1% 29.9% 31.8% 30.3% 23.3% 21.6% 14.7% 8.9% 11.8% 27.2% 22.3% 25.3% Total Shareholders' Equity 94.7% 0.3% 1.8% 30.6% 5.1% -33.8% -13.1% -23.5% 49.8% 12.2% 28.9%
Total Equity 774.11 1,507.47 1,512.73 1,540.07 2,010.73 2,113.20 1,398.00 1,214.20 Total Equity 18.1% 29.9% 31.8% 30.3% 23.3% 21.6% 14.7% 8.9% 11.8% 27.2% 22.3% 25.3% Total Equity 94.7% 0.3% 1.8% 30.6% 5.1% -33.8% -13.1% -23.5% 49.8% 12.2% 28.9%
Total Liabilities & Shareholders' Equity 4,272.68 5,046.72 4,763.73 5,088.32 8,641.84 9,805.90 9,495.80 13,675.80 Total Liabilities & Shareholders' Equity 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% 100.0% Total Liabilities & Shareholders' Equity 18.1% -5.6% 6.8% 69.8% 13.5% -3.2% 44.0% 20.4% 31.2% 20.5% 32.1%
Per Share All figures in...