Financial statement analysis and common stock valuation

Common-Size Balance Sheet: Liabilities and Stockholders’ Equity
Quarterly Data

Liabilities and stockholders’ equity components shown as percentage of total liabilities and stockholders’ equity.

Enterprise Value to EBITDA (EV/EBITDA)

To calculate EBITDA analysts start with net earnings. To that earnings number, interest, taxes, depreciation, and amortization are added. EBITDA as a pre-interest number is a flow to all providers of capital.

• Earnings before Interest, Tax, Depreciation and Amortization (EBITDA)
• EV to EBITDA Ratio, Current
• EV to EBITDA Ratio, Historical

Analysis of Solvency Ratios
Quarterly Data

Examines Eli Lilly & Co. capital structure in terms of the mix of its financing sources and the ability of the firm to satisfy its longer-term debt and investment obligations.

• Solvency Ratios (Summary)
• Debt to Equity
• Debt to Capital
• Debt to Assets
• Financial Leverage

Income Statement
Quarterly Data

The income statement (statement of earnings) reports on the performance of Eli Lilly & Co., the result of its operating activities.

Enterprise Value to FCFF (EV/FCFF)

Free cash flow to the firm is the cash flow available to the Eli Lilly & Co. suppliers of capital after all operating expenses have been paid and necessary investments in working and fixed capital have been made.

• Free Cash Flow to The Firm (FCFF)
• Interest Paid, Net of Tax
• EV to FCFF Ratio, Current
• EV to FCFF Ratio, Historical

DuPont Analysis: Disaggregation of ROE, ROA, and Net Profit Margin
Quarterly Data

An approach to decomposing Eli Lilly & Co. return on equity, return on assets, and net profit margin ratio as the product of other financial ratios.

• Two-Component Disaggregation of ROE
• Three-Component Disaggregation of ROE
• Two-Component Disaggregation of ROA

Present Value of Free Cash Flow to Equity (FCFE)

The FCFE valuation approach estimates the value of equity as the present value of future FCFE discounted at the required rate of return on equity.

• Intrinsic Stock Value (Valuation Summary)
• Required Rate of Return (r)
• FCFE Growth Rate (g)

Analysis of Short-term (Operating) Activity Ratios

Evaluates revenues and output generated by the Eli Lilly & Co. assets. Operating performance ratios describe the relationship between the Eli Lilly & Co. level of operations and the assets needed to sustain operating activities.

• Short-term Activity Ratios (Summary)
• Inventory Turnover
• Receivables Turnover
• Payables Turnover
• Working Capital Turnover
• Average Inventory Processing Period
• Average Receivable Collection Period
• Operating Cycle
• Average Payables Payment Period
• Cash Conversion Cycle

Analysis of Solvency Ratios

Examines Eli Lilly & Co. capital structure in terms of the mix of its financing sources and the ability of the firm to satisfy its longer-term debt and investment obligations.

• Solvency Ratios (Summary)
• Debt to Equity
• Debt to Equity (including Operating Lease Liability)
• Debt to Capital
• Debt to Capital (including Operating Lease Liability)
• Debt to Assets
• Debt to Assets (including Operating Lease Liability)
• Financial Leverage
• Interest Coverage
• Fixed Charge Coverage

Analysis of Long-term (Investment) Activity Ratios
Quarterly Data

Measures how efficiently Eli Lilly & Co. generates revenues from its investments in fixed or total assets.

• Long-term Activity Ratios (Summary)
• Net Fixed Asset Turnover
• Total Asset Turnover
• Equity Turnover

Balance Sheet: Assets

The assets reports major classes and amounts of resources owned or controlled by Eli Lilly & Co..

Analysis of Short-term (Operating) Activity Ratios
Quarterly Data

Evaluates revenues and output generated by the Eli Lilly & Co. assets. Operating performance ratios describe the relationship between the Eli Lilly & Co. level of operations and the assets needed to sustain operating activities.

• Short-term Activity Ratios (Summary)
• Inventory Turnover
• Receivables Turnover
• Payables Turnover
• Working Capital Turnover
• Average Inventory Processing Period
• Average Receivable Collection Period
• Operating Cycle
• Average Payables Payment Period
• Cash Conversion Cycle