Paying users zone. Data is covered by hidden.

  • Get to Eli Lilly & Co. for $17.99, or

  • get to whole website for at least 3 months from $49.99.

Microsoft Excel LibreOffice Calc

Eli Lilly & Co. (LLY)

Financial Reporting Quality: Aggregate Accruals

Difficulty: Advanced

Earnings can be decomposed into cash and accrual components. The accrual component (aggregate accruals) has been found to have less persistence than the cash component, and therefore (1) earnings with higher accrual component are less persistent than earnings with smaller accrual component, all else equal; and (2) the cash component of earnings should receive a higher weighting evaluating company performance.

Balance-Sheet-Based Accruals Ratio

Eli Lilly & Co., balance sheet computation of aggregate accruals

USD $ in thousands

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Operating Assets
Total assets hidden hidden hidden hidden hidden
Less: Cash and cash equivalents hidden hidden hidden hidden hidden
Less: Short-term investments hidden hidden hidden hidden hidden
Operating assets hidden hidden hidden hidden hidden
Operating Liabilities
Total liabilities hidden hidden hidden hidden hidden
Less: Short-term borrowings and current maturities of long-term debt hidden hidden hidden hidden hidden
Less: Long-term debt, excluding current maturities hidden hidden hidden hidden hidden
Operating liabilities hidden hidden hidden hidden hidden
Net operating assets1 hidden hidden hidden hidden hidden
Balance-sheet-based aggregate accruals2 hidden hidden hidden hidden hidden
Ratio
Balance-sheet-based accruals ratio3 hidden hidden hidden hidden hidden
Benchmarks
Balance-Sheet-Based Accruals Ratio, Competitors
Abbott Laboratories hidden hidden hidden hidden hidden
AbbVie Inc. hidden hidden hidden hidden hidden
Allergan PLC hidden hidden hidden hidden hidden
Amgen Inc. hidden hidden hidden hidden hidden
Biogen Inc. hidden hidden hidden hidden hidden
Bristol-Myers Squibb Co. hidden hidden hidden hidden hidden
Celgene Corp. hidden hidden hidden hidden hidden
Gilead Sciences Inc. hidden hidden hidden hidden hidden
Johnson & Johnson hidden hidden hidden hidden hidden
Merck & Co. Inc. hidden hidden hidden hidden hidden
Pfizer Inc. hidden hidden hidden hidden hidden
Regeneron Pharmaceuticals Inc. hidden hidden hidden hidden hidden
Balance-Sheet-Based Accruals Ratio, Sector
Pharmaceuticals & Biotechnology hidden hidden hidden hidden hidden
Balance-Sheet-Based Accruals Ratio, Industry
Health Care hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-20), 10-K (filing date: 2017-02-21), 10-K (filing date: 2016-02-19), 10-K (filing date: 2015-02-19), 10-K (filing date: 2014-02-19).

2017 Calculations

1 Net operating assets = Operating assets – Operating liabilities
= hidden – hidden = hidden

2 Balance-sheet-based aggregate accruals = Net operating assets 2017 – Net operating assets 2016
= hidden – hidden = hidden

3 Balance-sheet-based accruals ratio = 100 × Balance-sheet-based aggregate accruals ÷ Avg. net operating assets
= 100 × hidden ÷ [(hidden + hidden) ÷ 2] = hidden

Ratio Description The company
Balance-sheet-based accruals ratio Ratio is found by dividing balance-sheet-based aggregate accruals by average net operating assets. Using the balance-sheet-based accruals ratio, Eli Lilly & Co. deteriorated earnings quality from 2016 to 2017.

Cash-Flow-Statement-Based Accruals Ratio

Eli Lilly & Co., cash flow statement computation of aggregate accruals

USD $ in thousands

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
Net income (loss) hidden hidden hidden hidden hidden
Less: Net cash provided by operating activities hidden hidden hidden hidden hidden
Less: Net cash (used for) provided by investing activities hidden hidden hidden hidden hidden
Cash-flow-statement-based aggregate accruals hidden hidden hidden hidden hidden
Ratio
Cash-flow-statement-based accruals ratio1 hidden hidden hidden hidden hidden
Benchmarks
Cash-Flow-Statement-Based Accruals Ratio, Competitors
Abbott Laboratories hidden hidden hidden hidden hidden
AbbVie Inc. hidden hidden hidden hidden hidden
Allergan PLC hidden hidden hidden hidden hidden
Amgen Inc. hidden hidden hidden hidden hidden
Biogen Inc. hidden hidden hidden hidden hidden
Bristol-Myers Squibb Co. hidden hidden hidden hidden hidden
Celgene Corp. hidden hidden hidden hidden hidden
Gilead Sciences Inc. hidden hidden hidden hidden hidden
Johnson & Johnson hidden hidden hidden hidden hidden
Merck & Co. Inc. hidden hidden hidden hidden hidden
Pfizer Inc. hidden hidden hidden hidden hidden
Regeneron Pharmaceuticals Inc. hidden hidden hidden hidden hidden
Cash-Flow-Statement-Based Accruals Ratio, Sector
Pharmaceuticals & Biotechnology hidden hidden hidden hidden hidden
Cash-Flow-Statement-Based Accruals Ratio, Industry
Health Care hidden hidden hidden hidden hidden

Based on: 10-K (filing date: 2018-02-20), 10-K (filing date: 2017-02-21), 10-K (filing date: 2016-02-19), 10-K (filing date: 2015-02-19), 10-K (filing date: 2014-02-19).

2017 Calculations

1 Cash-flow-statement-based accruals ratio = 100 × Cash-flow-statement-based aggregate accruals ÷ Avg. net operating assets
= 100 × hidden ÷ [(hidden + hidden) ÷ 2] = hidden

Ratio Description The company
Cash-flow-statement-based accruals ratio Ratio is found by dividing cash-flow-statement-based aggregate accruals by average net operating assets. Using the cash-flow-statement-based accruals ratio, Eli Lilly & Co. deteriorated earnings quality from 2016 to 2017.