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


Adjustments to Financial Statements

Difficulty: Advanced


Adjustments to Current Assets

Eli Lilly & Co., adjusted current assets

USD $ in thousands

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Current assets hidden hidden hidden hidden hidden
Adjustments
Add: Allowances for doubtful accounts hidden hidden hidden hidden hidden
Add: LIFO reserve1 hidden hidden hidden hidden hidden
After Adjustment
Adjusted current assets 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).

1 LIFO reserve. See Details »


Adjustments to Total Assets

Eli Lilly & Co., adjusted total assets

USD $ in thousands

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Total assets hidden hidden hidden hidden hidden
Adjustments
Add: Operating leased assets1 hidden hidden hidden hidden hidden
Add: Allowances for doubtful accounts hidden hidden hidden hidden hidden
Add: LIFO reserve2 hidden hidden hidden hidden hidden
After Adjustment
Adjusted total assets 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).

1 Operating leased assets. See Details »

2 LIFO reserve. See Details »


Adjustments to Current Liabilities

Eli Lilly & Co., adjusted current liabilities

USD $ in thousands

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Current liabilities hidden hidden hidden hidden hidden
Adjustments
Less: Deferred income taxes1 hidden hidden hidden hidden hidden
After Adjustment
Adjusted current liabilities 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).

1 Deferred income taxes. See Details »


Adjustments to Total Liabilities

Eli Lilly & Co., adjusted total liabilities

USD $ in thousands

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Total liabilities hidden hidden hidden hidden hidden
Adjustments
Add: Operating lease obligations1 hidden hidden hidden hidden hidden
Less: Deferred income taxes2 hidden hidden hidden hidden hidden
After Adjustment
Adjusted total liabilities 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).

1 Operating lease obligations. See Details »

2 Deferred income taxes. See Details »


Adjustments to Stockholders' Equity

Eli Lilly & Co., adjusted total Eli Lilly and Company shareholders' equity

USD $ in thousands

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Total Eli Lilly and Company shareholders' equity hidden hidden hidden hidden hidden
Adjustments
Less: Deferred tax assets (liabilities), net1 hidden hidden hidden hidden hidden
Add: Allowances for doubtful accounts hidden hidden hidden hidden hidden
Add: LIFO reserve2 hidden hidden hidden hidden hidden
Add: Noncontrolling interests hidden hidden hidden hidden hidden
After Adjustment
Adjusted total Eli Lilly and Company shareholders' equity 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).

1 Deferred tax assets (liabilities), net. See Details »

2 LIFO reserve. See Details »


Adjustments to Capitalization Table

Eli Lilly & Co., adjusted capitalization table

USD $ in thousands

Microsoft Excel LibreOffice Calc
Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Short-term borrowings and current maturities of long-term debt hidden hidden hidden hidden hidden
Long-term debt, excluding current maturities hidden hidden hidden hidden hidden
Total reported debt hidden hidden hidden hidden hidden
Total Eli Lilly and Company shareholders' equity hidden hidden hidden hidden hidden
Total reported capital hidden hidden hidden hidden hidden
Adjustments to Debt
Add: Operating lease obligations1 hidden hidden hidden hidden hidden
Adjusted total debt hidden hidden hidden hidden hidden
Adjustments to Equity
Less: Deferred tax assets (liabilities), net2 hidden hidden hidden hidden hidden
Add: Allowances for doubtful accounts hidden hidden hidden hidden hidden
Add: LIFO reserve3 hidden hidden hidden hidden hidden
Add: Noncontrolling interests hidden hidden hidden hidden hidden
Adjusted total Eli Lilly and Company shareholders' equity hidden hidden hidden hidden hidden
After Adjustment
Adjusted total capital 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).

1 Operating lease obligations. See Details »

2 Deferred tax assets (liabilities), net. See Details »

3 LIFO reserve. See Details »


Adjustments to Reported Income

Eli Lilly & Co., adjusted net income (loss)

USD $ in thousands

Microsoft Excel LibreOffice Calc
12 months ended Dec 31, 2017 Dec 31, 2016 Dec 31, 2015 Dec 31, 2014 Dec 31, 2013
As Reported
Net income (loss) hidden hidden hidden hidden hidden
Adjustments
Add: Deferred income tax expense (benefit)1 hidden hidden hidden hidden hidden
Add: Increase (decrease) in allowances for doubtful accounts hidden hidden hidden hidden hidden
Add: Increase (decrease) in LIFO reserve2 hidden hidden hidden hidden hidden
Add: Other comprehensive income (loss) hidden hidden hidden hidden hidden
After Adjustment
Adjusted net income (loss) 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).

1 Deferred income tax expense (benefit). See Details »

2 Increase (decrease) in LIFO reserve. See Details »