Financial statement analysis and common stock valuation

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

Analysis of Long-term (Investment) Activity Ratios

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
• Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)
• Total Asset Turnover
• Equity Turnover

Cash Flow Statement

The cash flow statement provides information about Eli Lilly & Co. cash receipts and cash payments during an accounting period, showing how these cash flows link the ending cash balance to the beginning balance shown on Eli Lilly & Co. balance sheet.

Enterprise Value (EV)

Enterprise value is total company value (the market value of common equity, debt, and preferred equity) minus the value of cash and short-term investments.

• Current EV
• Historical EV

Aggregate Accruals

Financial reporting quality relates to the accuracy with which Eli Lilly & Co. reported financial statements reflect its operating performance and to their usefulness for forecasting future cash flows.
Aggregate accruals deriving measures of the accrual component of Eli Lilly & Co. earnings.

• Balance-Sheet-Based Accruals Ratio
• Cash-Flow-Statement-Based Accruals Ratio

Analysis of Liquidity Ratios
Quarterly Data

Measures the adequacy of a Eli Lilly & Co. cash resources to meet its near-term cash obligations.

• Liquidity Ratios (Summary)
• Current Ratio
• Quick Ratio
• Cash Ratio

Balance Sheet: Liabilities and Stockholders’ Equity

The liabilities and stockholders’ equity reports major classes and amounts of external claims on assets and owners’ capital contributions, and other internally generated sources of capital.

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

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

Common-Size Income Statement

Income statement components (revenues and expenses) shown as percentage of total sales.

Common-Size Balance Sheet: Assets

Assets components shown as percentage of total assets.

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

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