6 pages 15 hours
workprovider1
LLY.xlsxEli Lilly and Co | Ratios - Key
| Eli Lilly and Co | Ratios - Key Metrics | Thomson Reuters Eikon 22-Apr-2019 22:29 | |||||||||||
| Eli Lilly and Co | LLY | Last | 115.47 | c | USD | 0.27 | 0.23% | Close | 115.47 | Hold | |
| Ratios - Key Metrics | |||||||||||
| Annual Standardised in Millions of U.S. Dollars | |||||||||||
| Industry Median | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | |
| Earnings Quality Score | 52 | 64 | 88 | 99 | 95 | 72 | 81 | 88 | 97 | 92 | 95 |
| Profitability | |||||||||||
| Gross Margin | 73.3% | 80.6% | 81.1% | 79.1% | 78.8% | 78.8% | 74.9% | 74.8% | 73.4% | 73.5% | 73.8% |
| EBITDA Margin | 19.3% | 34.2% | 34.3% | 31.0% | 28.0% | 29.8% | 24.0% | 25.2% | 25.3% | 28.4% | 31.7% |
| Operating Margin | (0.8%) | 25.6% | 28.3% | 22.8% | 20.9% | 23.2% | 13.6% | 12.6% | 16.3% | 9.4% | 15.2% |
| Pretax Margin | (1.7%) | 24.5% | 28.3% | 22.0% | 23.9% | 25.5% | 15.3% | 14.0% | 15.9% | 9.6% | 15.5% |
| Effective Tax Rate | 9.7% | 19.2% | 22.3% | 18.7% | 24.4% | 20.5% | 20.3% | 13.7% | 18.9% | 22.2% | 10.2% |
| Net Margin | (0.1%) | 19.8% | 22.0% | 17.9% | 18.1% | 20.3% | 12.2% | 12.1% | 12.9% | 7.5% | 13.9% |
| DuPont/Earning Power | |||||||||||
| Asset Turnover | 0.28 | 0.77 | 0.79 | 0.75 | 0.66 | 0.66 | 0.55 | 0.56 | 0.57 | 0.55 | 0.55 |
| x Pretax Margin | (1.7%) | 24.5% | 28.3% | 22.0% | 23.9% | 25.5% | 15.3% | 14.0% | 15.9% | 9.6% | 15.5% |
| Pretax ROA | (4.4%) | 18.9% | 22.3% | 16.5% | 15.9% | 16.9% | 8.4% | 7.8% | 9.1% | 5.2% | 8.5% |
| x Leverage (Assets/Equity) | 1.87 | 2.88 | 2.50 | 2.49 | 2.33 | 2.00 | 2.36 | 2.44 | 2.77 | 3.88 | 4.47 |
| Pretax ROE | 2.3% | 65.9% | 59.5% | 41.2% | 38.2% | 36.4% | 18.2% | 18.6% | 23.6% | 17.2% | 35.4% |
| x Tax Complement | 0.94 | 0.81 | 0.78 | 0.81 | 0.76 | 0.80 | 0.80 | 0.86 | 0.81 | (0.09) | 0.85 |
| ROE | (7.2%) | 53.2% | 46.2% | 33.5% | 28.9% | 28.9% | 14.5% | 16.1% | 19.2% | 13.4% | 31.8% |
| x Earnings Retention | 1.00 | 0.50 | 0.57 | 0.50 | 0.47 | 0.55 | 0.12 | 0.11 | 0.21 | (0.31) | 0.30 |
| Reinvestment Rate | (8.4%) | 26.8% | 26.5% | 16.7% | 13.4% | 15.9% | 1.7% | 1.8% | 4.0% | (4.1%) | 9.7% |
| Liquidity | |||||||||||
| Quick Ratio | 1.84 | 1.47 | 1.78 | 1.34 | 1.24 | 1.14 | 0.94 | 1.11 | 1.05 | 1.01 | 1.38 |
| Current Ratio | 2.98 | 1.90 | 2.14 | 1.60 | 1.55 | 1.47 | 1.22 | 1.53 | 1.37 | 1.32 | 1.73 |
| Times Interest Earned | 0.8 | 24.4 | 36.5 | 34.0 | 28.2 | 34.7 | 22.4 | 22.3 | 20.9 | 21.9 | 22.7 |
| Cash Cycle (Days) | 153.0 | 209.9 | 202.8 | 157.9 | 166.1 | 184.4 | 199.9 | 207.3 | 216.0 | 238.8 | 249.0 |
| Leverage | |||||||||||
| Assets/Equity | 1.87 | 2.88 | 2.50 | 2.49 | 2.33 | 2.00 | 2.36 | 2.44 | 2.77 | 3.88 | 4.47 |
| Debt/Equity | 0.28 | 0.70 | 0.56 | 0.52 | 0.37 | 0.30 | 0.52 | 0.55 | 0.74 | 1.18 | 1.30 |
| % LT Debt to Total Capital | 20.6% | 41.0% | 35.0% | 26.6% | 27.2% | 18.4% | 22.8% | 35.3% | 34.3% | 39.3% | 49.2% |
| (Total Debt - Cash) / EBITDA | 1.42 | 0.45 | 0.15 | 0.02 | - | - | 0.32 | 0.67 | 0.73 | 0.76 | 0.66 |
| Operating | |||||||||||
| A/R Turnover | 4.5 | 6.1 | 5.8 | 5.8 | 5.6 | 5.8 | 5.0 | 5.1 | 4.8 | 4.6 | 4.3 |
| Avg. A/R Days | 78.0 | 59.6 | 63.4 | 63.3 | 65.8 | 62.6 | 73.0 | 72.2 | 76.2 | 80.2 | 85.5 |
| Inv Turnover | 1.8 | 1.6 | 1.6 | 2.1 | 1.9 | 1.8 | 1.7 | 1.6 | 1.6 | 1.5 | 1.5 |
| Avg. Inventory Days | 202.2 | 230.2 | 225.0 | 174.0 | 188.6 | 207.8 | 210.3 | 224.7 | 226.8 | 241.8 | 243.9 |
| Avg. A/P Days | 133.5 | 79.9 | 85.5 | 79.3 | 88.3 | 86.0 | 83.4 | 89.6 | 87.0 | 83.2 | 80.3 |
| Fixed Asset Turnover | 3.30 | 2.60 | 2.86 | 3.09 | 2.91 | 2.94 | 2.46 | 2.49 | 2.60 | 2.68 | 2.77 |
| WC / Sales Growth | (0.4%) | (3.2%) | 17.9% | (2.7%) | (5.2%) | (2.9%) | (2.9%) | 0.1% | 3.6% | (0.7%) | 7.9% |
| Bad Debt Allowance (% of A/R) | 1.8% | 2.9% | 1.9% | 2.6% | 2.8% | 1.5% | 1.4% | 1.1% | 0.8% | 0.7% | 0.5% |
| ROIC | - | 23.4% | 22.5% | 17.8% | 16.1% | 17.9% | 9.0% | 8.9% | 9.9% | 5.9% | 11.1% |
| Revenue per Employee ($) | - | $540,094.00 | $586,355.00 | $635,522.70 | $591,479.80 | $606,046.50 | $509,099.40 | $496,423.30 | $509,840.20 | $553,583.40 | $619,038.30 |
Eli Lilly and Co | Cash Flow |
| Eli Lilly and Co | Cash Flow | Thomson Reuters Eikon 22-Apr-2019 22:29 | ||||||||||
| Cash Flow | ||||||||||
| Annual Standardised in Millions of U.S. Dollars | ||||||||||
| 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | |
| Earnings Quality Score | 64 | 88 | 99 | 95 | 72 | 81 | 88 | 97 | 92 | 95 |
| Period End Date | 31-Dec-2009 | 31-Dec-2010 | 31-Dec-2011 | 31-Dec-2012 | 31-Dec-2013 | 31-Dec-2014 | 31-Dec-2015 | 31-Dec-2016 | 31-Dec-2017 | 31-Dec-2018 |
| Period Length | 12 Months | 12 Months | 12 Months | 12 Months | 12 Months | 12 Months | 12 Months | 12 Months | 12 Months | 12 Months |
| Statement Date | 31-Dec-2009 | 31-Dec-2010 | 31-Dec-2011 | 31-Dec-2012 | 31-Dec-2013 | 31-Dec-2016 | 31-Dec-2016 | 31-Dec-2016 | 31-Dec-2017 | 31-Dec-2018 |
| Cash Flow-Operating Activities ($ Millions) | ||||||||||
| Net Income/Starting Line | 4,328.8 | 5,069.5 | 4,347.7 | 4,088.6 | 4,684.8 | 2,390.5 | 2,408.4 | 2,737.6 | (204.1) | 3,232.0 |
| Depreciation/Depletion | 1,297.8 | 1,328.2 | 1,373.6 | 1,462.2 | 1,445.6 | 1,379.0 | 1,427.7 | 1,496.6 | 1,567.3 | 1,609.0 |
| Depreciation | 1,297.8 | 1,328.2 | 1,373.6 | 1,462.2 | 1,445.6 | 1,379.0 | 1,427.7 | 1,496.6 | 1,567.3 | 1,609.0 |
| Amortization | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Deferred Taxes | 189.9 | 559.7 | (268.5) | 126.0 | 285.9 | 36.8 | (748.4) | 439.5 | (787.9) | 326.8 |
| Non-Cash Items | (524.1) | 84.9 | 533.3 | (320.8) | (288.3) | 977.6 | 1,016.1 | 661.4 | 1,835.4 | 2,735.4 |
| Unusual Items | (1,313.6) | (112.3) | 151.5 | 205.0 | 0.0 | 340.7 | (186.1) | (3.4) | -- | 1,983.9 |
| Purchased R&D | 58.5 | 32.5 | 252.2 | 0.0 | 37.1 | 200.2 | 535.0 | 30.0 | 1,112.6 | -- |
| Other Non-Cash Items | 731.0 | 164.7 | 129.6 | (525.8) | (325.4) | 436.7 | 667.2 | 634.8 | 722.8 | 751.5 |
| Changes in Working Capital | (956.9) | (185.5) | 1,248.4 | (51.2) | (393.0) | (325.5) | (1,139.2) | (484.1) | 3,204.9 | (2,378.7) |
| Accounts Receivable | (492.9) | (319.1) | (188.8) | 361.8 | (152.7) | 117.4 | (304.5) | (709.4) | (357.0) | (996.7) |
| Inventories | (179.0) | 157.0 | 203.1 | (307.9) | (286.5) | (307.1) | (736.3) | (328.2) | (253.9) | 7.8 |
| Other Assets | (84.9) | 340.5 | 642.7 | 231.0 | 116.5 | 673.2 | (288.5) | (265.5) | (590.1) | (980.0) |
| Accounts Payable | (200.1) | (363.9) | 591.4 | (336.1) | (70.3) | (809.0) | 190.1 | 819.0 | 916.3 | (284.5) |
| Taxes Payable | -- | -- | -- | -- | -- | -- | -- | -- | 3,489.6 | (125.3) |
| Cash from Operating Activities | 4,335.5 | 6,856.8 | 7,234.5 | 5,304.8 | 5,735.0 | 4,458.4 | 2,964.6 | 4,851.0 | 5,615.6 | 5,524.5 |
| Cash Flow-Investing Activities ($ Millions) | ||||||||||
| Capital Expenditures | (855.0) | (1,186.7) | (1,692.9) | (1,044.2) | (1,093.3) | (1,565.9) | (1,626.2) | (1,092.0) | (2,163.6) | (3,018.2) |
| Purchase of Fixed Assets | (765.0) | (694.3) | (672.0) | (905.4) | (1,012.1) | (1,162.6) | (1,066.2) | (1,037.0) | (1,076.8) | (1,210.6) |
| Purchase/Acquisition of Intangibles | (90.0) | (492.4) | (1,020.9) | (138.8) | (81.2) | (403.3) | (560.0) | (55.0) | (1,086.8) | (1,807.6) |
| Other Investing Cash Flow Items, Total | 997.8 | (1,973.1) | (3,131.5) | (1,788.6) | (979.5) | (2,343.2) | 1,653.0 | (2,047.1) | (1,620.0) | 4,924.2 |
| Acquisition of Business | 0.0 | (609.4) | (307.8) | (199.3) | (43.7) | (551.4) | (5,283.1) | (45.0) | (882.1) | 0.0 |
| Sale of Fixed Assets | 17.7 | 24.6 | 25.3 | 22.0 | 179.4 | 15.3 | 92.6 | 73.4 | 40.7 | 3.6 |
| Sale/Maturity of Investment | 1,107.8 | 584.7 | 2,138.5 | 4,355.7 | 14,555.1 | 15,063.5 | 5,230.2 | 3,728.0 | 7,438.5 | 6,062.0 |
| Investment, Net | 399.1 | (686.5) | (250.9) | 375.1 | -- | -- | -- | -- | -- | -- |
| Purchase of Investments | (432.3) | (1,067.2) | (4,459.4) | (7,618.6) | (15,572.9) | (11,440.5) | (4,068.7) | (5,673.4) | (8,001.3) | (950.1) |
| Sale of Intangible Assets | -- | -- | -- | -- | -- | 0.0 | 410.0 | 0.0 | 0.0 | -- |
| Other Investing Cash Flow | (94.5) | (219.3) | (277.2) | 1,276.5 | (97.4) | (5,430.1) | 5,272.0 | (130.1) | (215.8) | (191.3) |
| Cash from Investing Activities | 142.8 | (3,159.8) | (4,824.4) | (2,832.8) | (2,072.8) | (3,909.1) | 26.8 | (3,139.1) | (3,783.6) | 1,906.0 |
| Cash Flow-Financing Activities ($ Millions) | ||||||||||
| Financing Cash Flow Items | 42.6 | 19.4 | 6.0 | 0.0 | 0.0 | 96.1 | (52.6) | (300.8) | (364.4) | (372.8) |
| Other Financing Cash Flow | 42.6 | 19.4 | 6.0 | 0.0 | 0.0 | 96.1 | (52.6) | (300.8) | (364.4) | (372.8) |
| Total Cash Dividends Paid | (2,152.1) | (2,165.3) | (2,180.1) | (2,187.4) | (2,120.7) | (2,101.2) | (2,127.3) | (2,158.5) | (2,192.1) | (2,311.8) |
| Cash Dividends Paid - Common | (2,152.1) | (2,165.3) | (2,180.1) | (2,187.4) | (2,120.7) | (2,101.2) | (2,127.3) | (2,158.5) | (2,192.1) | (2,311.8) |
| Issuance (Retirement) of Stock, Net | -- | 0.0 | 0.0 | (721.1) | (1,698.1) | (800.0) | (749.5) | (600.1) | (299.8) | (2,491.0) |
| Sale/Issuance of Common | -- | -- | -- | -- | -- | -- | -- | -- | -- | 1,659.7 |
| Repurchase/Retirement of Common | -- | 0.0 | 0.0 | (721.1) | (1,698.1) | (800.0) | (749.5) | (600.1) | (299.8) | (4,150.7) |
| Common Stock, Net | -- | 0.0 | 0.0 | (721.1) | (1,698.1) | (800.0) | (749.5) | (600.1) | (299.8) | (2,491.0) |
| Issuance (Retirement) of Debt, Net | (3,424.2) | 124.0 | (195.8) | (1,511.1) | (10.5) | 2,638.7 | (181.6) | 2,499.6 | 2,998.9 | (729.3) |
| Short Term Debt, Net | (5,824.2) | 123.9 | (141.2) | (10.5) | 0.0 | 2,680.6 | (2,680.6) | 1,293.2 | 1,397.5 | (2,197.9) |
| Long Term Debt Issued | 2,400.0 | 1.2 | 0.0 | -- | -- | 992.9 | 4,454.7 | 1,206.6 | 2,232.0 | 2,477.7 |
| Long Term Debt Reduction | 0.0 | (1.1) | (54.6) | (1,500.6) | (10.5) | (1,034.8) | (1,955.7) | (0.2) | (630.6) | (1,009.1) |
| Long Term Debt, Net | 2,400.0 | 0.1 | (54.6) | (1,500.6) | (10.5) | (41.9) | 2,499.0 | 1,206.4 | 1,601.4 | 1,468.6 |
| Cash from Financing Activities | (5,533.7) | (2,021.9) | (2,369.9) | (4,419.6) | (3,829.3) | (166.4) | (3,111.0) | (559.8) | 142.6 | (5,904.9) |
| Foreign Exchange Effects | 21.6 | (144.8) | (110.9) | 43.9 | (21.5) | (341.5) | (85.6) | (236.4) | (20.5) | (63.6) |
| Net Change in Cash | (1,033.8) | 1,530.3 | (70.7) | (1,903.7) | (188.6) | 41.4 | (205.2) | 915.7 | 1,954.1 | 1,462.0 |
| Net Cash - Beginning Balance | 5,496.7 | 4,462.9 | 5,993.2 | 5,922.5 | 4,018.8 | 3,830.2 | 3,871.6 | 3,666.4 | 4,582.1 | 6,536.2 |
| Net Cash - Ending Balance | 4,462.9 | 5,993.2 | 5,922.5 | 4,018.8 | 3,830.2 | 3,871.6 | 3,666.4 | 4,582.1 | 6,536.2 | 7,998.2 |
| Cash Interest Paid | 205.9 | 176.3 | 167.4 | 171.9 | 139.7 | 140.4 | 129.6 | 146.4 | 192.7 | 223.8 |
| Cash Taxes Paid | 1,140.0 | 861.0 | 943.0 | 992.0 | 1,260.0 | 729.7 | 969.0 | 700.6 | 246.5 | 1,101.5 |
| Reported Cash from Operating Activities | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Reported Cash from Investing Activities | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Reported Cash from Financing Activities | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Free Cash Flow | 3,480.5 | 5,670.1 | 5,541.6 | 4,260.6 | 4,641.7 | 2,892.5 | 1,338.4 | 3,759.0 | 3,452.0 | 2,506.3 |
Eli Lilly and Co | Balance Shee
| Eli Lilly and Co | Balance Sheet | Thomson Reuters Eikon 22-Apr-2019 22:29 | ||||||||||
| Eli Lilly and Co | LLY | Last | 115.47 | c | USD | 0.27 | 0.23% | Close | 115.47 | Hold |
| Balance Sheet | ||||||||||
| Annual Standardised in Millions of U.S. Dollars | ||||||||||
| 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | |
| Earnings Quality Score | 64 | 88 | 99 | 95 | 72 | 81 | 88 | 97 | 92 | 95 |
| Period End Date | 31-Dec-2009 | 31-Dec-2010 | 31-Dec-2011 | 31-Dec-2012 | 31-Dec-2013 | 31-Dec-2014 | 31-Dec-2015 | 31-Dec-2016 | 31-Dec-2017 | 31-Dec-2018 |
| Statement Date | 31-Dec-2010 | 31-Dec-2011 | 31-Dec-2011 | 31-Dec-2012 | 31-Dec-2014 | 31-Dec-2015 | 31-Dec-2015 | 31-Dec-2016 | 31-Dec-2017 | 31-Dec-2018 |
| Assets ($ Millions) | ||||||||||
| Cash and Short Term Investments | 4,498 | 6,727 | 6,897 | 5,684 | 5,397 | 4,827 | 4,452 | 6,039 | 8,034 | 8,086 |
| Cash & Equivalents | 4,463 | 5,993 | 5,923 | 4,019 | 3,830 | 3,872 | 3,666 | 4,582 | 6,536 | 7,998 |
| Short Term Investments | 35 | 734 | 975 | 1,666 | 1,567 | 955 | 785 | 1,457 | 1,498 | 88 |
| Accounts Receivable - Trade, Net | 3,343 | 3,494 | 3,598 | 3,336 | 3,434 | 3,235 | 3,513 | 4,029 | 4,546 | 5,247 |
| Accounts Receivable - Trade, Gross | 3,453 | 3,574 | 3,708 | 3,445 | 3,497 | 3,290 | 3,557 | 4,070 | 4,585 | 5,279 |
| Provision for Doubtful Accounts | (110) | (80) | (110) | (109) | (62) | (55) | (44) | (40) | (39) | (33) |
| Total Receivables, Net | 3,832 | 4,158 | 4,238 | 3,888 | 4,023 | 3,801 | 4,072 | 4,766 | 5,262 | 6,205 |
| Receivables - Other | 489 | 664 | 640 | 552 | 588 | 567 | 559 | 737 | 716 | 958 |
| Total Inventory | 2,850 | 2,518 | 2,300 | 2,644 | 2,929 | 2,740 | 3,446 | 3,562 | 4,458 | 4,112 |
| Inventories - Finished Goods | 938 | 801 | 786 | 834 | 968 | 838 | 1,053 | 987 | 1,211 | 988 |
| Inventories - Work In Progress | 1,830 | 1,714 | 1,518 | 1,736 | 1,868 | 1,715 | 2,058 | 2,117 | 2,698 | 2,628 |
| Inventories - Raw Materials | 228 | 221 | 206 | 256 | 259 | 315 | 403 | 435 | 489 | 507 |
| LIFO Reserve | (146) | (218) | (211) | (183) | (167) | (128) | (69) | 22 | 60 | (11) |
| Prepaid Expenses | 1,307 | 1,437 | 813 | 822 | 756 | 560 | 604 | 735 | 1,448 | 2,147 |
| Other Current Assets, Total | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Total Current Assets | 12,487 | 14,840 | 14,248 | 13,039 | 13,105 | 11,928 | 12,574 | 15,101 | 19,202 | 20,550 |
| Property/Plant/Equipment, Total - Gross | 15,100 | 14,487 | 14,594 | 14,918 | 15,647 | 16,029 | 16,661 | 16,778 | 18,091 | 18,464 |
| Buildings - Gross | 6,122 | 6,029 | 6,136 | 6,374 | 6,490 | 6,516 | 6,787 | 6,918 | 7,426 | 7,684 |
| Land/Improvements - Gross | 217 | 208 | 203 | 201 | 199 | 205 | 221 | 198 | 193 | 193 |
| Machinery/Equipment - Gross | 7,813 | 7,356 | 7,220 | 7,543 | 7,753 | 7,610 | 7,989 | 7,865 | 8,689 | 8,817 |
| Construction in Progress - Gross | 948 | 894 | 1,036 | 800 | 1,205 | 1,698 | 1,665 | 1,798 | 1,784 | 1,770 |
| Property/Plant/Equipment, Total - Net | 8,197 | 7,941 | 7,760 | 7,760 | 7,976 | 7,964 | 8,054 | 8,253 | 8,827 | 8,920 |
| Accumulated Depreciation, Total | (6,903) | (6,546) | (6,834) | (7,158) | (7,671) | (8,065) | (8,607) | (8,525) | (9,265) | (9,545) |
| Goodwill, Net | 1,175 | 1,424 | 1,910 | 1,566 | 1,517 | 1,758 | 4,040 | 3,973 | 4,370 | 4,348 |
| Intangibles, Net | 2,525 | 3,395 | 3,219 | 3,186 | 2,814 | 2,884 | 5,035 | 4,358 | 4,029 | 3,521 |
| Intangibles - Gross | 3,194 | 4,450 | 4,742 | 5,237 | 5,335 | 5,845 | 7,857 | 7,731 | 7,950 | 5,433 |
| Accumulated Intangible Amortization | (669) | (1,055) | (1,524) | (2,051) | (2,520) | (2,961) | (2,822) | (3,373) | (3,921) | (1,912) |
| Long Term Investments | 1,156 | 1,780 | 4,030 | 6,313 | 7,625 | 4,569 | 3,647 | 5,208 | 5,679 | 2,021 |
| LT Investment - Affiliate Companies | 157 | 164 | 160 | 233 | 354 | 447 | 671 | 569 | 585 | 305 |
| LT Investments - Other | 999 | 1,615 | 3,870 | 6,080 | 7,271 | 4,122 | 2,975 | 4,639 | 5,094 | 1,716 |
| Note Receivable - Long Term | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Other Long Term Assets, Total | 1,921 | 1,622 | 2,493 | 2,534 | 2,213 | 7,204 | 2,221 | 1,914 | 2,874 | 4,550 |
| Defered Income Tax - Long Term Asset | -- | -- | -- | -- | -- | -- | -- | -- | -- | 2,658 |
| Restricted Cash - Long Term | -- | -- | -- | -- | 0 | 5,406 | 0 | -- | -- | -- |
| Other Long Term Assets | 1,921 | 1,622 | 2,493 | 2,534 | 2,213 | 1,799 | 2,221 | 1,914 | 2,874 | 1,892 |
| Total Assets | 27,461 | 31,001 | 33,660 | 34,399 | 35,249 | 36,308 | 35,569 | 38,806 | 44,981 | 43,908 |
| Liabilities ($ Millions) | ||||||||||
| Accounts Payable | 968 | 1,072 | 1,125 | 1,188 | 1,119 | 1,128 | 1,338 | 1,349 | 1,411 | 1,412 |
| Payable/Accrued | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Accrued Expenses | 894 | 852 | 805 | 940 | 944 | 759 | 967 | 897 | 998 | 1,055 |
| Notes Payable/Short Term Debt | 27 | 156 | 1,522 | 12 | 0 | 0 | 0 | 1,299 | 2,697 | 499 |
| Current Port. of LT Debt/Capital Leases | -- | -- | -- | -- | 1,013 | 2,689 | 6 | 638 | 1,010 | 632 |
| Other Current liabilities, Total | 4,678 | 4,847 | 5,479 | 6,249 | 5,841 | 5,165 | 5,918 | 6,803 | 8,421 | 8,290 |
| Dividends Payable | 538 | 540 | 542 | 541 | 524 | 530 | 539 | 548 | 591 | 651 |
| Income Taxes Payable | 347 | 458 | 262 | 144 | 254 | 94 | 359 | 119 | 533 | 404 |
| Other Payables | 1,110 | 1,373 | 1,771 | 1,777 | 1,942 | 2,069 | 2,560 | 3,915 | 4,465 | 5,022 |
| Deferred Income Tax - Current Liability | -- | -- | 422 | 1,048 | 793 | -- | -- | -- | -- | -- |
| Other Current Liabilities | 2,684 | 2,477 | 2,481 | 2,739 | 2,328 | 2,473 | 2,460 | 2,221 | 2,832 | 2,213 |
| Total Current Liabilities | 6,568 | 6,927 | 8,931 | 8,390 | 8,917 | 9,741 | 8,230 | 10,987 | 14,536 | 11,888 |
| Total Long Term Debt | 6,635 | 6,771 | 5,465 | 5,519 | 4,200 | 5,333 | 7,972 | 8,368 | 9,941 | 11,640 |
| Long Term Debt | 6,635 | 6,771 | 5,465 | 5,519 | 4,200 | 5,333 | 7,972 | 8,359 | 9,932 | 11,632 |
| Capital Lease Obligations | -- | -- | -- | -- | -- | -- | -- | 9 | 9 | 7 |
| Total Debt | 6,662 | 6,927 | 6,987 | 5,531 | 5,213 | 8,022 | 7,979 | 10,305 | 13,647 | 12,771 |
| Deferred Income Tax | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Minority Interest | 2 | (8) | (6) | 9 | 9 | 15 | 19 | 73 | 76 | 1,080 |
| Other Liabilities, Total | 4,733 | 4,891 | 5,729 | 5,716 | 4,491 | 5,846 | 4,777 | 5,371 | 8,837 | 9,472 |
| Pension Benefits - Underfunded | 2,335 | 1,887 | 3,069 | 3,012 | 1,549 | 2,563 | 2,160 | 2,454 | 3,514 | 2,911 |
| Other Long Term Liabilities | 2,398 | 3,004 | 2,660 | 2,704 | 2,942 | 3,283 | 2,616 | 2,917 | 5,323 | 6,560 |
| Total Liabilities | 17,937 | 18,581 | 20,118 | 19,634 | 17,617 | 20,934 | 20,998 | 24,798 | 33,389 | 34,080 |
| Shareholders Equity ($ Millions) | ||||||||||
| Redeemable Preferred Stock, Total | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Preferred Stock - Non Redeemable, Net | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Common Stock, Total | 719 | 721 | 724 | 717 | 699 | 695 | 691 | 689 | 688 | 661 |
| Common Stock | 719 | 721 | 724 | 717 | 699 | 695 | 691 | 689 | 688 | 661 |
| Additional Paid-In Capital | 4,636 | 4,799 | 4,887 | 4,963 | 5,050 | 5,292 | 5,552 | 5,641 | 5,818 | 6,584 |
| Retained Earnings (Accumulated Deficit) | 9,830 | 12,733 | 14,898 | 16,088 | 16,992 | 16,483 | 16,012 | 16,046 | 13,894 | 11,396 |
| Treasury Stock - Common | (99) | (96) | (95) | (192) | (94) | (91) | (90) | (81) | (76) | (69) |
| ESOP Debt Guarantee | (77) | (52) | 0 | -- | -- | -- | -- | -- | -- | -- |
| Unrealized Gain (Loss) | -- | 129 | 15 | 73 | 205 | 100 | 10 | 224 | 114 | (22) |
| Other Equity, Total | (5,485) | (5,812) | (6,887) | (6,883) | (5,221) | (7,105) | (7,604) | (8,511) | (8,845) | (8,720) |
| Translation Adjustment | -- | 511 | 266 | 427 | 463 | (498) | (1,360) | (1,867) | (1,233) | (1,623) |
| Other Equity | (3,013) | (3,013) | (3,013) | (3,013) | (3,013) | (3,013) | (3,013) | (3,013) | (3,013) | (3,013) |
| Minimum Pension Liability Adjustment | -- | (3,176) | (4,032) | (4,195) | (2,489) | (3,402) | (3,012) | (3,372) | (4,341) | (3,857) |
| Other Comprehensive Income | (2,472) | (134) | (107) | (101) | (182) | (191) | (219) | (259) | (258) | (228) |
| Total Equity | 9,524 | 12,420 | 13,542 | 14,765 | 17,631 | 15,373 | 14,571 | 14,008 | 11,592 | 9,829 |
| Total Liabilities & Shareholders' Equity | 27,461 | 31,001 | 33,660 | 34,399 | 35,249 | 36,308 | 35,569 | 38,806 | 44,981 | 43,908 |
| Supplemental ($ Millions) | ||||||||||
| Shares Outstanding - Common Issue 2 | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Shares Outstanding - Common Issue 3 | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Shares Outstanding - Common Issue 4 | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Total Common Shares Outstanding | 1,149 | 1,153 | 1,158 | 1,144 | 1,117 | 1,111 | 1,105 | 1,101 | 1,100 | 1,057 |
| Shares Outs - Common Stock Primary Issue | 1,149 | 1,153 | 1,158 | 1,144 | 1,117 | 1,111 | 1,105 | 1,101 | 1,100 | 1,057 |
| Treas Shares - Common Stock Prmry Issue | 1 | 1 | 1 | 3 | 1 | 1 | 1 | 1 | 1 | 1 |
| Treasury Shares - Common Issue 2 | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Treasury Shares - Common Issue 3 | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Treasury Shares - Common Issue 4 | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Total Preferred Shares Outstanding | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Treasury Shares - Preferred Issue 1 | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Treasury Shares - Preferred Issue 2 | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Treasury Shares - Preferred Issue 3 | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Treasury Shares - Preferred Issue 4 | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Treasury Shares - Preferred Issue 5 | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Treasury Shares - Preferred Issue 6 | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Minority Interest - Redeemable | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Minority Interest - Non Redeemable | 2 | (8) | (6) | 9 | 9 | 15 | 19 | 73 | 76 | 1,080 |
| Total Equity & Minority Interest | 9,525 | 12,413 | 13,536 | 14,774 | 17,641 | 15,388 | 14,590 | 14,081 | 11,668 | 10,909 |
| Full-Time Employees | 40,360 | 38,350 | 38,080 | 38,350 | 37,925 | 39,135 | 41,275 | 41,975 | 40,655 | 38,680 |
| Part-Time Employees | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Number of Common Shareholders | 38,400 | 36,700 | 35,200 | 33,638 | 31,900 | 29,300 | 28,000 | 26,800 | 25,300 | 24,000 |
| Other Property/Plant/Equipment - Net | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Intangibles - Net | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Goodwill - Net | 1,175 | 1,424 | 1,910 | 1,566 | 1,517 | 1,758 | 4,040 | 3,973 | 4,370 | 4,348 |
| Accumulated Goodwill Amortization Suppl. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Accumulated Intangible Amort, Suppl. | 669 | 1,055 | 1,524 | 2,051 | 2,520 | 2,961 | 2,822 | 3,373 | 3,921 | 1,912 |
| Right-of-Use Assets-Cap.Lease,Net-Suppl. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Right-of-Use Assets-Cap.Lease,Gross-Sup. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Right-of-Use Assets-Cap.Lease,Depr.-Sup. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Right-of-Use Assets-Op.Lease, Net-Suppl. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Right-of-Use Assets-Op.Lease, Gross-Sup. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Right-of-Use Assets-Op.Lease, Depr.-Sup. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Non-Current Marketable Securities,Suppl. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Contract Assets - Short Term | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Contract Assets - Long Term | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Deferred Revenue - Current | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Deferred Revenue - Long Term | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Short Term Debt Financial Sector, Suppl. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Curr Port - LTD/Cap Lse Fin Sec., Suppl. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Long Term Debt Financial Sector, Suppl. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Capital Lease Oblig. - Fin Sector, Suppl | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Curr. Port. of LT Capital Leases, Suppl. | -- | -- | -- | -- | -- | -- | -- | -- | -- | 5 |
| Curr Port of LT Operating Leases, Suppl. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Long-Term Operating Lease Liabs., Suppl. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Curr Derivative Liab. Hedging, Suppl. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Curr Derivative Liab. Spec./Trdg, Suppl. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Non-Curr Derivative Liab. Hedging, Suppl | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Non-Curr Derivative Liab Spec/Trdg Suppl | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Leverage Ratio (Basel 3) | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Net Stable Funding Ratio (Basel 3) | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Liquidity Coverage Ratio (Basel 3) | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Capital Adequacy - Core Tier 1 (Value) | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Capital Adequacy - Hybrid Tier 1 (Value) | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Capital Adequacy -Tier 1 Capital (Value) | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Capital Adequacy -Tier 2 Capital (Value) | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Capital Adequacy -Tier 3 Capital (Value) | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Capital Adequacy - Total Capital (Value) | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Total Risk-Weighted Capital | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Capital Adequacy - Core Tier 1 Capital % | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Capital Adequacy - Tier 1 Capital % | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Capital Adequacy - Tier 2 Capital % | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Capital Adequacy - Tier 3 Capital % | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Capital Adequacy - Total Capital % | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Trading Account | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Credit Exposure | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Non-Performing Loans | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Assets under Management | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Total Current Assets less Inventory | 9,637 | 12,322 | 11,948 | 10,395 | 10,176 | 9,188 | 9,128 | 11,540 | 14,744 | 16,438 |
| Net Debt Incl. Pref.Stock & Min.Interest | 2,166 | 192 | 84 | (144) | (175) | 3,209 | 3,546 | 4,339 | 5,689 | 5,765 |
| Tangible Book Value, Common Equity | 5,824 | 7,602 | 8,414 | 10,013 | 13,300 | 10,731 | 5,497 | 5,677 | 3,193 | 1,960 |
| Reported Total Assets | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Reported Total Liabilities | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Shareholders' Equity Excl. Stock Subscr. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Reported Shareholder's Equity | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Reported Net Assets | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Reported Net Assets to Total Assets | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Reported Return on Assets | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Reported Return on Equity | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Islamic Investments & Deposits | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Islamic Receivables | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Islamic Debt | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Islamic Section, Supplemental | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Debt & Lease, Pension Items ($ Millions) | ||||||||||
| Total Long Term Debt, Supplemental | 2,570 | 2,576 | 2,737 | 2,235 | -- | -- | 2,047 | 2,240 | 3,084 | 3,800 |
| Long Term Debt Maturing within 1 Year | 20 | 18 | 1,510 | 12 | -- | -- | 6 | 635 | 1,009 | 635 |
| Long Term Debt Maturing in Year 2 | 16 | 1,520 | 10 | 1,010 | -- | -- | 635 | 999 | 604 | 34 |
| Long Term Debt Maturing in Year 3 | 1,510 | 16 | 1,010 | 9 | -- | -- | 803 | 603 | 3 | 942 |
| Long Term Debt Maturing in Year 4 | 14 | 1,010 | 5 | 204 | -- | -- | 602 | 2 | 1 | 1,439 |
| Long Term Debt Maturing in Year 5 | 1,010 | 12 | 201 | 1,000 | -- | -- | 1 | 1 | 1,467 | 750 |
| Long Term Debt Maturing in 2-3 Years | 1,526 | 1,536 | 1,020 | 1,019 | -- | -- | 1,438 | 1,602 | 607 | 976 |
| Long Term Debt Maturing in 4-5 Years | 1,024 | 1,022 | 207 | 1,204 | -- | -- | 602 | 2 | 1,469 | 2,189 |
| Long Term Debt Matur. in Year 6 & Beyond | 0 | 0 | 0 | 0 | -- | -- | 0 | 0 | 0 | 0 |
| Total Capital Leases, Supplemental | 39 | 39 | 61 | 42 | -- | -- | 16 | 14 | 13 | 12 |
| Capital Lease Payments Due in Year 1 | 14 | 14 | 8 | 15 | -- | -- | 5 | 5 | 5 | 5 |
| Capital Lease Payments Due in Year 2 | 7 | 7 | 6 | 11 | -- | -- | 4 | 3 | 3 | 3 |
| Capital Lease Payments Due in Year 3 | 7 | 7 | 6 | 11 | -- | -- | 4 | 3 | 3 | 3 |
| Capital Lease Payments Due in Year 4 | 5 | 4 | 6 | 2 | -- | -- | 1 | 1 | 1 | 1 |
| Capital Lease Payments Due in Year 5 | 5 | 4 | 6 | 2 | -- | -- | 1 | 1 | 1 | 1 |
| Capital Lease Payments Due in 2-3 Years | 13 | 13 | 13 | 22 | -- | -- | 9 | 7 | 7 | 6 |
| Capital Lease Payments Due in 4-5 Years | 9 | 9 | 12 | 5 | -- | -- | 2 | 2 | 2 | 1 |
| Cap. Lease Pymts. Due in Year 6 & Beyond | 3 | 3 | 29 | 0 | -- | -- | 0 | 0 | 0 | 0 |
| Total Operating Leases, Supplemental | 403 | 572 | 515 | 647 | 620 | -- | 934 | 874 | 773 | 805 |
| Operating Lease Payments Due in Year 1 | 109 | 109 | 112 | 145 | 137 | -- | 133 | 135 | 131 | 156 |
| Operating Lease Payments Due in Year 2 | 78 | 81 | 78 | 116 | 109 | -- | 91 | 115 | 112 | 128 |
| Operating Lease Payments Due in Year 3 | 78 | 81 | 78 | 116 | 109 | -- | 91 | 115 | 112 | 89 |
| Operating Lease Payments Due in Year 4 | 39 | 52 | 50 | 67 | 74 | -- | 122 | 85 | 86 | 75 |
| Operating Lease Payments Due in Year 5 | 39 | 52 | 50 | 67 | 74 | -- | 122 | 85 | 86 | 58 |
| Operating Lease Pymts. Due in 2-3 Years | 156 | 163 | 155 | 232 | 218 | -- | 181 | 231 | 225 | 217 |
| Operating Lease Pymts. Due in 4-5 Years | 78 | 103 | 100 | 134 | 147 | -- | 245 | 170 | 172 | 133 |
| Oper. Lse. Pymts. Due in Year 6 & Beyond | 60 | 198 | 148 | 136 | 118 | -- | 376 | 339 | 246 | 300 |
| Operating Leases - Interest Cost | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Total Funded Status | (2,398) | (1,893) | (2,975) | (2,957) | (372) | -- | (1,247) | (1,810) | (2,610) | (1,744) |
| Pension Obligation - Domestic | 7,554 | 8,115 | 9,191 | 10,424 | 9,976 | -- | 11,719 | 12,456 | 15,098 | 13,662 |
| Post-Retirement Obligation | 2,033 | 2,089 | 2,309 | 2,338 | 1,757 | -- | 1,467 | 1,495 | 1,729 | 1,544 |
| Plan Assets - Domestic | 6,009 | 6,983 | 7,186 | 8,287 | 9,482 | -- | 9,996 | 10,180 | 11,845 | 11,064 |
| Plan Assets - Post-Retirement | 1,181 | 1,328 | 1,339 | 1,518 | 1,880 | -- | 1,944 | 1,961 | 2,372 | 2,398 |
| Funded Status - Domestic | (1,545) | (1,132) | (2,005) | (2,137) | (495) | -- | (1,724) | (2,276) | (3,254) | (2,598) |
| Funded Status - Post-Retirement | (852) | (761) | (970) | (820) | 122 | -- | 476 | 467 | 644 | 854 |
| Accumulated Obligation - Domestic | -- | 7,230 | 8,200 | 9,460 | 9,130 | -- | 2,028 | 9,805 | 11,957 | 11,032 |
| Accumulated Obligation - Post-Retirement | 2,033 | 2,089 | 2,309 | 2,338 | -- | -- | 246 | 223 | 225 | 189 |
| Period End Assumptions | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Discount Rate - Domestic | 5.90% | 5.90% | 5.60% | 5.00% | 4.90% | -- | 4.30% | 3.90% | 3.40% | 3.90% |
| Discount Rate - Post-Retirement | 6.00% | 5.80% | 5.10% | 4.30% | 5.00% | -- | 4.50% | 4.30% | 3.70% | 4.40% |
| Compensation Rate - Domestic | 3.70% | 3.70% | 3.70% | 3.40% | 3.40% | -- | 3.40% | 3.40% | 3.40% | 3.40% |
| Net Assets Recognized on Balance Sheet | 2,578 | 2,876 | 2,932 | 3,113 | 3,231 | -- | (1,486) | (2,026) | (2,828) | (1,903) |
| Prepaid Benefits - Domestic | -- | -- | -- | -- | 881 | -- | 262 | 30 | 107 | 196 |
| Prepaid Benefits - Post-Retirement | -- | -- | -- | -- | 366 | -- | 722 | 689 | 869 | 1,044 |
| Accrued Liabilities - Domestic | (1,545) | (1,191) | (2,166) | (2,263) | (1,376) | -- | (1,985) | (2,306) | (3,361) | (2,794) |
| Accrued Liabilities - Foreign | -- | -- | -- | -- | -- | -- | (239) | (216) | (218) | (182) |
| Accrued Liabilities - Post-Retirement | (852) | (761) | (970) | (820) | (244) | -- | (246) | (223) | (225) | (167) |
| Other Assets, Net - Domestic | 3,869 | 3,853 | 4,915 | 5,243 | 3,597 | -- | -- | -- | -- | -- |
| Other Assets, Net - Post-Retirement | 1,106 | 974 | 1,152 | 953 | 7 | -- | -- | -- | -- | -- |
| Asset Allocation | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- |
| Equity % - Domestic | 50.30% | 35.20% | 26.67% | 28.52% | 30.42% | -- | 27.57% | 26.41% | 28.71% | 24.74% |
| Equity % - Post-Retirement | 20.40% | 14.13% | 10.31% | 11.40% | 10.99% | -- | 9.50% | 9.43% | 9.51% | 7.79% |
| Debt Securities % - Domestic | 10.00% | 16.15% | 17.69% | 17.83% | 14.96% | -- | 17.03% | 20.21% | 20.22% | 20.87% |
| Debt Securities % - Post-Retirement | 4.00% | 6.36% | 6.71% | 6.57% | 4.94% | -- | 5.05% | 5.64% | 5.24% | 5.11% |
| Real Estate % - Domestic | -- | 1.81% | 5.69% | 6.08% | 5.50% | -- | 5.17% | 4.95% | 4.76% | 4.75% |
| Real Estate % - Post-Retirement | -- | -- | 2.05% | 2.33% | 1.95% | -- | 1.71% | 1.77% | 1.39% | 1.16% |
| Private Investments % - Domestic | 35.40% | 40.57% | 44.29% | 42.80% | 41.89% | -- | 42.96% | 41.84% | 39.04% | 42.88% |
| Private Investments % - Post-Retirement | 17.30% | 19.56% | 21.88% | 20.81% | 79.38% | -- | 81.62% | 80.83% | 80.83% | 82.97% |
| Other Investments % - Domestic | 4.30% | 6.27% | 5.66% | 4.77% | 7.23% | -- | 7.27% | 6.59% | 7.27% | 6.75% |
| Other Investments % - Post-Retirement | 58.30% | 59.95% | 59.05% | 58.89% | 2.73% | -- | 2.11% | 2.32% | 3.03% | 2.97% |
| Total Plan Obligations | 9,587 | 10,204 | 11,500 | 12,762 | 11,734 | -- | 13,187 | 13,951 | 16,827 | 15,206 |
| Total Plan Assets | 7,189 | 8,311 | 8,525 | 9,805 | 11,361 | -- | 11,939 | 12,141 | 14,217 | 13,462 |
Eli Lilly and Co | Income State
| Eli Lilly and Co | Income Statement | Thomson Reuters Eikon 22-Apr-2019 22:28 | |||||||||||
| Eli Lilly and Co | LLY | Last | 115.47 | c | USD | 0.27 | 0.23% | Close | 115.47 | Hold | |
| Income Statement | |||||||||||
| Annual Standardised in Millions of U.S. Dollars | |||||||||||
| 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | ||
| Earnings Quality Score | 64 | 88 | 99 | 95 | 72 | 81 | 88 | 97 | 92 | 95 | |
| Period End Date | 31-Dec-2009 | 31-Dec-2010 | 31-Dec-2011 | 31-Dec-2012 | 31-Dec-2013 | 31-Dec-2014 | 31-Dec-2015 | 31-Dec-2016 | 31-Dec-2017 | 31-Dec-2018 | |
| Period Length | 12 Months | 12 Months | 12 Months | 12 Months | 12 Months | 12 Months | 12 Months | 12 Months | 12 Months | 12 Months | |
| Statement Date | 31-Dec-2009 | 31-Dec-2010 | 31-Dec-2011 | 31-Dec-2012 | 31-Dec-2013 | 31-Dec-2014 | 31-Dec-2015 | 31-Dec-2016 | 31-Dec-2017 | 31-Dec-2018 | |
| Revenue | 21,836 | 23,076 | 24,287 | 22,603 | 23,113 | 19,616 | 19,959 | 21,222 | 22,871 | 24,556 | |
| Net Sales | 21,836 | 23,076 | 24,287 | 22,603 | 23,113 | 19,616 | 19,959 | 21,222 | 22,871 | 24,556 | |
| Other Revenue, Total | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Total Revenue | 21,836 | 23,076 | 24,287 | 22,603 | 23,113 | 19,616 | 19,959 | 21,222 | 22,871 | 24,556 | |
| Cost of Revenue, Total | 4,247 | 4,366 | 5,068 | 4,797 | 4,908 | 4,933 | 5,037 | 5,655 | 6,070 | 6,430 | |
| Cost of Revenue | 4,247 | 4,366 | 5,068 | 4,797 | 4,908 | 4,933 | 5,037 | 5,655 | 6,070 | 6,430 | |
| Gross Profit | 17,589 | 18,710 | 19,219 | 17,807 | 18,205 | 14,683 | 14,922 | 15,567 | 16,801 | 18,126 | |
| Selling/General/Admin. Expenses, Total | 6,893 | 7,053 | 7,880 | 7,514 | 7,126 | 6,621 | 6,533 | 6,452 | 6,588 | 6,632 | |
| Selling/General/Administrative Expense | 6,893 | 7,053 | 7,880 | 7,514 | 7,126 | 6,621 | 6,533 | 6,452 | 6,588 | 6,632 | |
| Research & Development | 4,327 | 4,884 | 5,021 | 5,278 | 5,531 | 4,734 | 4,796 | 5,244 | 5,282 | 5,307 | |
| Depreciation/Amortization | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Interest Expense, Net - Operating | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Interest/Investment Income - Operating | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Interest Expense(Income) - Net Operating | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Interest Exp.(Inc.),Net-Operating, Total | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Unusual Expense (Income) | 783 | 242 | 789 | 281 | 178 | 669 | 1,069 | 413 | 2,786 | 2,466 | |
| Purchased R&D Written-Off | 90 | 50 | 388 | 0 | 57 | 200 | 535 | 30 | 1,113 | 1,984 | |
| Restructuring Charge | 99 | 142 | 252 | 75 | -- | -- | 141 | 127 | 697 | 143 | |
| Litigation | 230 | 0 | 0 | -- | -- | -- | -- | -- | -- | -- | |
| Impairment-Assets Held for Use | 364 | 50 | 150 | 207 | 121 | 469 | 227 | 256 | 976 | 339 | |
| Other Unusual Expense (Income) | -- | -- | -- | -- | -- | -- | 167 | 0 | 0 | -- | |
| Other Operating Expenses, Total | -- | -- | 0 | -- | -- | -- | -- | -- | -- | -- | |
| Other, Net | -- | -- | 0 | -- | -- | -- | -- | -- | -- | -- | |
| Total Operating Expense | 16,249 | 16,546 | 18,758 | 17,869 | 17,743 | 16,956 | 17,436 | 17,763 | 20,726 | 20,835 | |
| Operating Income | 5,587 | 6,530 | 5,529 | 4,734 | 5,370 | 2,660 | 2,523 | 3,459 | 2,145 | 3,721 | |
| Interest Expense, Net Non-Operating | (261) | (186) | (186) | (178) | (160) | (149) | (161) | (185) | (225) | (272) | |
| Interest Expense - Non-Operating | (292) | (212) | (212) | (199) | (160) | (187) | (216) | (233) | (282) | (272) | |
| Interest Capitalized - Non-Operating | 30 | 26 | 26 | 21 | -- | 38 | 55 | 48 | 57 | -- | |
| Interest/Invest Income - Non-Operating | 75 | 52 | 80 | 105 | 120 | 121 | 87 | 109 | 167 | 161 | |
| Interest Income - Non-Operating | 75 | 52 | 80 | 105 | 120 | 121 | 87 | 109 | 167 | 161 | |
| Interest Income(Exp), Net Non-Operating | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Interest Inc.(Exp.),Net-Non-Op., Total | (186) | (134) | (106) | (73) | (40) | (28) | (74) | (77) | (58) | (111) | |
| Gain (Loss) on Sale of Assets | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Other, Net | (43) | 129 | (73) | 747 | 559 | 368 | 342 | (8) | 110 | 186 | |
| Other Non-Operating Income (Expense) | (43) | 129 | (73) | 747 | 559 | 368 | 342 | (8) | 110 | 186 | |
| Net Income Before Taxes | 5,358 | 6,525 | 5,350 | 5,408 | 5,889 | 3,000 | 2,790 | 3,374 | 2,197 | 3,796 | |
| Provision for Income Taxes | 1,029 | 1,456 | 1,002 | 1,320 | 1,205 | 610 | 382 | 636 | 488 | 388 | |
| Net Income After Taxes | 4,329 | 5,070 | 4,348 | 4,089 | 4,685 | 2,391 | 2,408 | 2,738 | 1,710 | 3,407 | |
| Minority Interest | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Equity In Affiliates | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| U.S. GAAP Adjustment | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Net Income Before Extra. Items | 4,329 | 5,070 | 4,348 | 4,089 | 4,685 | 2,391 | 2,408 | 2,738 | 1,710 | 3,407 | |
| Accounting Change | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Discontinued Operations | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Extraordinary Item | -- | -- | -- | -- | -- | -- | -- | -- | (1,914) | (175) | |
| Tax on Extraordinary Items | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Total Extraordinary Items | -- | -- | -- | -- | -- | -- | -- | -- | (1,914) | (175) | |
| Net Income | 4,329 | 5,070 | 4,348 | 4,089 | 4,685 | 2,391 | 2,408 | 2,738 | (204) | 3,232 | |
| Preferred Dividends | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| General Partners' Distributions | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Miscellaneous Earnings Adjustment | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Pro Forma Adjustment | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Interest Adjustment - Primary EPS | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Total Adjustments to Net Income | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Income Available to Com Excl ExtraOrd | 4,329 | 5,070 | 4,348 | 4,089 | 4,685 | 2,391 | 2,408 | 2,738 | 1,710 | 3,407 | |
| Income Available to Com Incl ExtraOrd | 4,329 | 5,070 | 4,348 | 4,089 | 4,685 | 2,391 | 2,408 | 2,738 | (204) | 3,232 | |
| Basic Weighted Average Shares | 1,098 | 1,106 | 1,114 | 1,113 | 1,081 | 1,070 | 1,062 | 1,058 | 1,052 | 1,028 | |
| Basic EPS Excluding Extraordinary Items | 3.94 | 4.58 | 3.90 | 3.67 | 4.33 | 2.23 | 2.27 | 2.59 | 1.63 | 3.32 | |
| Basic EPS Including Extraordinary Items | 3.94 | 4.58 | 3.90 | 3.67 | 4.33 | 2.23 | 2.27 | 2.59 | (0.19) | 3.14 | |
| Dilution Adjustment | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Diluted Net Income | 4,329 | 5,070 | 4,348 | 4,089 | 4,685 | 2,391 | 2,408 | 2,738 | (204) | 3,232 | |
| Diluted Weighted Average Shares | 1,098 | 1,106 | 1,114 | 1,117 | 1,085 | 1,074 | 1,066 | 1,062 | 1,052 | 1,034 | |
| Diluted EPS Excluding ExtraOrd Items | 3.94 | 4.58 | 3.90 | 3.66 | 4.32 | 2.23 | 2.26 | 2.58 | 1.63 | 3.30 | |
| Diluted EPS Including ExtraOrd Items | 3.94 | 4.58 | 3.90 | 3.66 | 4.32 | 2.23 | 2.26 | 2.58 | (0.19) | 3.13 | |
| Supplemental ($ Millions) | |||||||||||
| DPS - Common Stock Primary Issue | 1.96 | 1.96 | 1.96 | 1.96 | 1.96 | 1.96 | 2.00 | 2.04 | 2.08 | 2.25 | |
| Dividends per Share - Com Stock Issue 2 | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Dividends per Share - Com Stock Issue 3 | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Dividends per Share - Com Stock Issue 4 | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Special DPS - Common Stock Primary Issue | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Special DPS - Common Stock Issue 2 | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Special DPS - Common Stock Issue 3 | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Special DPS - Common Stock Issue 4 | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Gross Dividends - Common Stock | 2,153 | 2,167 | 2,183 | 2,187 | 2,103 | 2,108 | 2,136 | 2,168 | 2,235 | 2,372 | |
| Pro Forma Stock Compensation Expense | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Net Income after Stock Based Comp. Exp. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Basic EPS after Stock Based Comp. Exp. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Diluted EPS after Stock Based Comp. Exp. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| (Gain) Loss on Sale of Assets, Suppl. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Impairment-Assets Held for Sale, Suppl. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Impairment-Assets Held for Use, Suppl. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Litigation Charge, Supplemental | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Purchased R&D Written-Off, Supplemental | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Restructuring Charge, Supplemental | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Other Unusual Expense(Income), Suppl. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Non-Recurring Items, Supplemental, Total | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Total Special Items | 783 | 242 | 789 | 281 | 178 | 669 | 1,069 | 413 | 2,786 | 2,466 | |
| Normalized Income Before Taxes | 6,141 | 6,767 | 6,139 | 5,689 | 6,067 | 3,669 | 3,859 | 3,787 | 4,984 | 6,262 | |
| Effect of Special Items on Income Taxes | 133 | 43 | 75 | 69 | 25 | 95 | 73 | 72 | 371 | 49 | |
| Inc Tax Ex Impact of Sp Items | 1,162 | 1,499 | 1,077 | 1,388 | 1,229 | 705 | 455 | 709 | 859 | 438 | |
| Normalized Income After Taxes | 4,978 | 5,269 | 5,062 | 4,301 | 4,838 | 2,964 | 3,405 | 3,078 | 4,125 | 5,824 | |
| Normalized Inc. Avail to Com. | 4,978 | 5,269 | 5,062 | 4,301 | 4,838 | 2,964 | 3,405 | 3,078 | 4,125 | 5,824 | |
| Basic Normalized EPS | 4.53 | 4.76 | 4.54 | 3.86 | 4.48 | 2.77 | 3.21 | 2.91 | 3.92 | 5.67 | |
| Diluted Normalized EPS | 4.53 | 4.76 | 4.54 | 3.85 | 4.46 | 2.76 | 3.19 | 2.90 | 3.92 | 5.63 | |
| EPS, Supplemental | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Funds From Operations - REIT | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Amort of Acquisition Costs, Supplemental | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Amort of Intangibles, Supplemental | 277 | 386 | 469 | 563 | 555 | 536 | 632 | 688 | 683 | 559 | |
| Amort. of Right-of-Use Intang.Assets,Sup | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Depreciation, Supplemental | 814 | 749 | 732 | 754 | 775 | 843 | 796 | 809 | 884 | 1,050 | |
| Depreciation of Right-of-Use Assets,Sup. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Interest Expense, Supplemental | 261 | 186 | 186 | 178 | 160 | 149 | 161 | 185 | 225 | 272 | |
| Interest Capitalized, Supplemental | (30) | (26) | (26) | (21) | -- | (38) | (55) | (48) | (57) | -- | |
| Interest Expense on Lease Liabs., Suppl. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Interest Expense (Financial Oper), Suppl | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Net Revenues | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Rental Expense, Supplemental | 338 | 256 | 267 | 286 | 227 | 227 | 226 | 221 | 225 | 223 | |
| Labor & Related Expense Suppl. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Stock-Based Compensation, Supplemental | 369 | 231 | 147 | 142 | 145 | 156 | 218 | 255 | 281 | 280 | |
| Advertising Expense, Supplemental | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Equity in Affiliates, Supplemental | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Minority Interest, Supplemental | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Income Taxes - Non-Recurring Tax Change | -- | -- | -- | -- | -- | -- | -- | -- | 1,914 | 175 | |
| Research & Development Exp, Supplemental | 4,327 | 4,884 | 5,021 | 5,278 | 5,531 | 4,734 | 4,796 | 5,244 | 5,282 | 5,307 | |
| Audit Fees | 8 | 9 | 9 | 9 | 9 | 10 | 13 | 13 | 15 | -- | |
| Audit-Related Fees | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | -- | |
| Tax Fees | 1 | 1 | 3 | 2 | 1 | 2 | 6 | 7 | 5 | -- | |
| All Other Fees | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | -- | -- | |
| Reported Recurring Revenue | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Reported Net Premiums Written | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Reported Total Revenue | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Reported Operating Revenue | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Reported Total Cost of Revenue | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Reported Total Sales, General & Admin. | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Reported Gross Profit | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Reported Operating Profit | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Reported Operating Profit Margin | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Reported Ordinary Profit | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Reported Net Income After Tax | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Reported Basic EPS | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Reported Diluted EPS | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Reported Net Business Profits | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Islamic Income | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Zakat | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Islamic Section, Supplemental | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Normalized EBIT | 6,370 | 6,772 | 6,318 | 5,015 | 5,548 | 3,329 | 3,592 | 3,871 | 4,931 | 6,187 | |
| Normalized EBITDA | 7,461 | 7,907 | 7,519 | 6,332 | 6,878 | 4,708 | 5,020 | 5,368 | 6,499 | 7,796 | |
| Tax & Pension Items ($ Millions) | |||||||||||
| Current Tax - Total | 867 | 913 | 1,408 | 1,194 | 939 | 573 | 1,130 | 197 | (58) | 35 | |
| Current Tax - Domestic | 46 | 376 | 671 | 597 | 259 | 169 | 661 | (57) | (101) | (54) | |
| Current Tax - Foreign | 772 | 514 | 760 | 541 | 553 | 406 | 422 | 379 | 39 | 80 | |
| Current Tax - Local | 49 | 23 | (23) | 56 | 126 | (2) | 48 | (125) | 4 | 10 | |
| Deferred Tax - Total | 162 | 542 | (406) | 126 | 266 | 37 | (748) | 440 | 546 | 353 | |
| Deferred Tax - Domestic | 83 | 624 | (399) | 87 | 297 | (83) | (690) | 517 | 802 | 64 | |
| Deferred Tax - Foreign | 80 | (55) | (35) | 30 | (28) | 120 | (66) | (83) | (256) | 286 | |
| Deferred Tax - Local | 0 | (27) | 27 | 9 | (3) | 0 | 7 | 6 | 0 | 3 | |
| Income Tax - Total | 1,029 | 1,456 | 1,002 | 1,320 | 1,205 | 610 | 382 | 636 | 488 | 388 | |
| Income Tax by Region - Total | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Domestic Pension Plan Expense | 167 | 184 | 207 | 313 | 441 | 243 | 404 | 244 | 673 | 257 | |
| Interest Cost - Domestic | 418 | 432 | 448 | 455 | 437 | 473 | 477 | 421 | 413 | 461 | |
| Service Cost - Domestic | 242 | 219 | 236 | 253 | 287 | 241 | 316 | 278 | 331 | 304 | |
| Prior Service Cost - Domestic | 8 | 9 | 9 | 4 | 4 | 4 | 10 | 12 | 6 | 5 | |
| Expected Return on Assets - Domestic | (585) | (638) | (686) | (685) | (702) | (757) | (782) | (752) | (776) | (848) | |
| Actuarial Gains and Losses - Domestic | 85 | 163 | 200 | 286 | 415 | 282 | 383 | 286 | 288 | 334 | |
| Curtailments & Settlements - Domestic | -- | -- | -- | -- | -- | -- | -- | -- | 94 | 1 | |
| Other Pension, Net - Domestic | -- | -- | -- | -- | -- | -- | -- | -- | 317 | 0 | |
| Foreign Pension Plan Expense | -- | -- | -- | -- | -- | -- | (91) | (86) | (90) | (80) | |
| Prior Service Cost - Foreign | -- | -- | -- | -- | -- | -- | (91) | (86) | (90) | (80) | |
| Post-Retirement Plan Expense | 91 | 103 | 107 | 110 | 82 | (45) | (95) | (125) | (30) | (182) | |
| Interest Cost - Post-Retirement | 120 | 121 | 118 | 115 | 98 | 86 | 63 | 53 | 53 | 57 | |
| Service Cost - Post-Retirement | 54 | 57 | 72 | 63 | 50 | 33 | 45 | 39 | 46 | 42 | |
| Prior Service Cost - Post-Retirement | (36) | (37) | (43) | (40) | (36) | (38) | (91) | (86) | (90) | (80) | |
| Expected Return on Assets - Post-Retir. | (118) | (123) | (129) | (127) | (131) | (146) | (150) | (150) | (161) | (178) | |
| Actuarial Gains and Losses - Post-Retir. | 72 | 85 | 89 | 98 | 101 | 21 | 38 | 19 | 18 | 6 | |
| Curtailments & Settlements - Post-Retir. | -- | -- | -- | -- | -- | -- | -- | -- | 66 | (29) | |
| Other Post-Retirement, Net | -- | -- | -- | -- | -- | -- | -- | -- | 38 | 0 | |
| Total Pension Expense | 386 | 407 | 432 | 550 | 523 | 198 | 217 | 33 | 553 | (4) | |
| Defined Contribution Expense - Domestic | 128 | 120 | 118 | 127 | -- | -- | -- | -- | -- | -- | |
| Assumptions | -- | -- | -- | -- | -- | -- | -- | -- | -- | -- | |
| Discount Rate - Domestic | 6.70% | 5.90% | 5.60% | 5.00% | 4.30% | 4.90% | 4.00% | 4.30% | 3.90% | 3.40% | |
| Discount Rate - Post-Retirement | 6.90% | 6.00% | 5.80% | 5.10% | 4.30% | 5.00% | 4.10% | 4.50% | 4.30% | 3.70% | |
| Expected Rate of Return - Domestic | 8.80% | 8.80% | 8.50% | 8.40% | 8.40% | 8.10% | 7.40% | 7.40% | 7.40% | 7.30% | |
| Expected Rate of Return - Post-Retir. | 9.00% | 9.00% | 8.80% | 8.80% | 8.80% | 8.50% | 8.00% | 8.00% | 8.00% | 8.00% | |
| Compensation Rate - Domestic | 4.10% | 3.70% | 3.70% | 3.70% | 3.40% | 3.40% | 3.40% | 3.40% | 3.40% | 3.40% | |
| Total Plan Interest Cost | 537 | 553 | 566 | 570 | 535 | 558 | 539 | 474 | 466 | 518 | |
| Total Plan Service Cost | 296 | 276 | 309 | 316 | 337 | 274 | 361 | 317 | 378 | 346 | |
| Total Plan Expected Return | (703) | (761) | (815) | (812) | (833) | (903) | (932) | (902) | (937) | (1,026) | |
| Total Plan Other Expense | -- | -- | -- | -- | -- | -- | -- | -- | 355 | 0 | |
| Dividends and Capital Changes | |||||||||||
| Eli Lilly Ord Shs | |||||||||||
| Cash Dividend | $0.49 I | $0.49 I | $0.49 I | $0.49 I | $0.49 I | $0.50 I | $0.51 I | $0.52 I | $0.56 I | $0.65 I | |
| (14-Dec) Ann. | (13-Dec) Ann. | (12-Dec) Ann. | (17-Dec) Ann. | (16-Dec) Ann. | (15-Dec) Ann. | (08-Dec) Ann. | (13-Dec) Ann. | (11-Dec) Ann. | (19-Dec) Ann. | ||
| $0.49 F | $0.49 F | $0.49 F | $0.49 F | $0.49 F | $0.49 F | $0.50 F | $0.51 F | $0.52 F | $0.56 F | ||
| (19-Oct) Ann. | (18-Oct) Ann. | (17-Oct) Ann. | (15-Oct) Ann. | (21-Oct) Ann. | (20-Oct) Ann. | (19-Oct) Ann. | (17-Oct) Ann. | (16-Oct) Ann. | (15-Oct) Ann. | ||
| $0.49 I | $0.49 I | $0.49 I | $0.49 I | $0.49 I | $0.49 I | $0.50 I | $0.51 I | $0.52 I | $0.56 I | ||
| (22-Jun) Ann. | (21-Jun) Ann. | (20-Jun) Ann. | (19-Jun) Ann. | (18-Jun) Ann. | (16-Jun) Ann. | (15-Jun) Ann. | (20-Jun) Ann. | (19-Jun) Ann. | (18-Jun) Ann. | ||
| $0.49 I | $0.49 I | $0.49 I | $0.49 I | $0.49 I | $0.49 I | $0.50 I | $0.51 I | $0.52 I | $0.56 I | ||
| (20-Apr) Ann. | (19-Apr) Ann. | (18-Apr) Ann. | (16-Apr) Ann. | (06-May) Ann. | (05-May) Ann. | (04-May) Ann. | (02-May) Ann. | (01-May) Ann. | (08-May) Ann. | ||
| Dividends & Capital Changes After Dec-2018 | |||||||||||
| Eli Lilly Ord Shs | |||||||||||
| 2019 | Exchange Offer | Adj. Factor 1x | |||||||||
| (30-Apr) |
