Paying users zone. Data is covered by 
.
Get to Eli Lilly & Co. for $19.99, or
get to entire website for at least 3 months from $49.99.
Analysis of Debt
Difficulty: Advanced
Total Debt (Carrying Amount)
Eli Lilly & Co., Statement of Financial Position, Debt
USD $ in thousands
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).
| Item | Description | The company |
|---|---|---|
| Total debt (carrying amount) | Sum of the carrying values as of the balance sheet date of all debt plus capital lease obligations. | Eli Lilly & Co.’s total debt increased from 2015 to 2016 and from 2016 to 2017. |
Total Debt (Fair Value)
| Dec 31, 2017 | |
|---|---|
| Selected Financial Data (USD $ in thousands) | |
| Short-term commercial paper borrowings | |
| Long-term debt, including current portion | |
| Total debt (fair value) | |
| Ratio | |
| Debt, fair value to carrying amount | |
Based on: 10-K (filing date: 2018-02-20).
Weighted-average Interest Rate on Debt
Weighted-average effective borrowing rate, including the effects of interest rate swaps for hedged debt obligations:
| Interest Rate | Debt Amount1 | Interest Rate × Debt Amount | Weighted-average Interest Rate2 | |
|---|---|---|---|---|
|
|
|
||
|
|
|
||
| Total | |
|
|
Based on: 10-K (filing date: 2018-02-20).
1 USD $ in thousands
2 Weighted-average interest rate = 100 × ÷ =
Interest Costs Incurred
Eli Lilly & Co.
USD $ in thousands
| 12 months ended | Dec 31, 2017 | Dec 31, 2016 | Dec 31, 2015 | Dec 31, 2014 | Dec 31, 2013 | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Interest expense | |
|
|
|
|
||||||
| Interest costs capitalized | |
|
|
|
|
||||||
| Interest costs incurred | |
|
|
|
|
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).
| Item | Description | The company |
|---|---|---|
| Interest expense | Amount of the cost of borrowed funds accounted for as interest expense for debt. | Eli Lilly & Co.’s interest expense increased from 2015 to 2016 and from 2016 to 2017. |
| Interest costs capitalized | Amount of interest costs capitalized disclosed as an adjusting item to interest costs incurred. | |
| Interest costs incurred | Total interest costs incurred during the period and either capitalized or charged against earnings. | Eli Lilly & Co.’s interest costs incurred increased from 2015 to 2016 and from 2016 to 2017. |
Adjusted Interest Coverage Ratio
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 Interest coverage ratio (excluding capitalized interest) = EBIT ÷ Interest expense
= ÷ =
2 Adjusted interest coverage ratio (including capitalized interest) = EBIT ÷ Interest costs incurred
= ÷ =
| Ratio | Description | The company |
|---|---|---|
| Adjusted interest coverage ratio | A solvency ratio calculated as EBIT divided by interest payments (including capitalized interest). | Eli Lilly & Co.’s adjusted interest coverage ratio improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017. |
