Eli Lilly & Co. (LLY)

Analysis of Investments

Difficulty: Advanced

Eli Lilly & Co., adjustment to Net Income (loss)

USD $ in thousands

	12 months ended	Dec 31, 2017	Dec 31, 2016	Dec 31, 2015	Dec 31, 2014	Dec 31, 2013
	Net income (loss) (as reported)
	Add: Change in net unrealized gains and losses on securities
	Net income (loss) (adjusted)

Eli Lilly & Co., adjusted ratios

	Dec 31, 2017	Dec 31, 2016	Dec 31, 2015	Dec 31, 2014	Dec 31, 2013
Net Profit Margin
Reported net profit margin	%	%	%	%	%
Adjusted net profit margin	%	%	%	%	%
Return on Equity (ROE)
Reported ROE	%	%	%	%	%
Adjusted ROE	%	%	%	%	%
Return on Assets (ROA)
Reported ROA	%	%	%	%	%
Adjusted ROA	%	%	%	%	%

Ratio	Description	The company
Adjusted net profit margin	An indicator of profitability, calculated as adjusted net income divided by revenue.	Eli Lilly & Co.'s adjusted net profit margin improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.
Adjusted ROE	A profitability ratio calculated as adjusted net income divided by shareholders' equity.	Eli Lilly & Co.'s adjusted ROE improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.
Adjusted ROA	A profitability ratio calculated as adjusted net income divided by total assets.	Eli Lilly & Co.'s adjusted ROA improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.

	Dec 31, 2017	Dec 31, 2016	Dec 31, 2015	Dec 31, 2014	Dec 31, 2013
As Reported
Net income (loss) (USD $ in thousands)
Revenue (USD $ in thousands)

Net profit margin¹	%	%	%	%	%
Adjusted: Mark to Market Available-for-sale Securities
Adjusted net income (loss) (USD $ in thousands)
Revenue (USD $ in thousands)

Adjusted net profit margin²	%	%	%	%	%

2017 Calculations

¹ Net profit margin = 100 × Net income (loss) ÷ Revenue
= 100 × hidden ÷ hidden = hidden %

² Adjusted net profit margin = 100 × Adjusted net income (loss) ÷ Revenue
= 100 × hidden ÷ hidden = hidden %

Ratio	Description	The company
Adjusted net profit margin	An indicator of profitability, calculated as adjusted net income divided by revenue.	Eli Lilly & Co.'s adjusted net profit margin improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.

	Dec 31, 2017	Dec 31, 2016	Dec 31, 2015	Dec 31, 2014	Dec 31, 2013
As Reported
Net income (loss) (USD $ in thousands)
Total Eli Lilly and Company shareholders' equity (USD $ in thousands)

ROE¹	%	%	%	%	%
Adjusted: Mark to Market Available-for-sale Securities
Adjusted net income (loss) (USD $ in thousands)
Total Eli Lilly and Company shareholders' equity (USD $ in thousands)

Adjusted ROE²	%	%	%	%	%

2017 Calculations

¹ ROE = 100 × Net income (loss) ÷ Total Eli Lilly and Company shareholders' equity
= 100 × hidden ÷ hidden = hidden %

² Adjusted ROE = 100 × Adjusted net income (loss) ÷ Total Eli Lilly and Company shareholders' equity
= 100 × hidden ÷ hidden = hidden %

Ratio	Description	The company
Adjusted ROE	A profitability ratio calculated as adjusted net income divided by shareholders' equity.	Eli Lilly & Co.'s adjusted ROE improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.

	Dec 31, 2017	Dec 31, 2016	Dec 31, 2015	Dec 31, 2014	Dec 31, 2013
As Reported
Net income (loss) (USD $ in thousands)
Total assets (USD $ in thousands)

ROA¹	%	%	%	%	%
Adjusted: Mark to Market Available-for-sale Securities
Adjusted net income (loss) (USD $ in thousands)
Total assets (USD $ in thousands)

Adjusted ROA²	%	%	%	%	%

2017 Calculations

¹ ROA = 100 × Net income (loss) ÷ Total assets
= 100 × hidden ÷ hidden = hidden %

² Adjusted ROA = 100 × Adjusted net income (loss) ÷ Total assets
= 100 × hidden ÷ hidden = hidden %

Ratio	Description	The company
Adjusted ROA	A profitability ratio calculated as adjusted net income divided by total assets.	Eli Lilly & Co.'s adjusted ROA improved from 2015 to 2016 but then deteriorated significantly from 2016 to 2017.

	Eli Lilly & Co.	Other companies (not purchased previously)
Financial Statements
Common-Size Financial Statements
Ratios
Relative Valuation
Discounted Cash Flow (DCF) Valuation
Economic Value Added (EVA)
Long-term Trends
Analysis
Financial Reporting Quality

	All companies
Financial Statements
Common-Size Financial Statements
Ratios
Relative Valuation
Discounted Cash Flow (DCF) Valuation
Economic Value Added (EVA)
Long-term Trends
Analysis
Financial Reporting Quality