Common-Size Balance Sheet: Assets
Quarterly Data
Eli Lilly & Co., common-size consolidated balance sheet: assets (quarterly data)
Based on: 10-Q (reporting date: 2025-09-30), 10-Q (reporting date: 2025-06-30), 10-Q (reporting date: 2025-03-31), 10-K (reporting date: 2024-12-31), 10-Q (reporting date: 2024-09-30), 10-Q (reporting date: 2024-06-30), 10-Q (reporting date: 2024-03-31), 10-K (reporting date: 2023-12-31), 10-Q (reporting date: 2023-09-30), 10-Q (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-K (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31).
- Cash and Cash Equivalents
- The proportion of cash and cash equivalents relative to total assets exhibits volatility over the periods. Initially rising from 4.13% to a peak of 8.18%, it subsequently fluctuates around 4-7% before falling to a low near 3.35% and then sharply increasing to 8.52% in the final period. This behavior suggests periodic adjustments in liquidity management or cash reserves.
- Short-term Investments
- This component remains relatively stable at a low percentage of total assets, fluctuating mostly between 0.05% and 0.29%, with minor decreases toward later periods. Short-term investments maintain a minor but consistent share of the asset base.
- Accounts Receivable, Net
- The accounts receivable as a percentage of total assets show moderate variation, generally oscillating between approximately 11% and 15%. There is a noticeable increase from early to middle periods, peaking above 15%, followed by moderate fluctuations toward the end, indicating steady revenue-related asset levels.
- Other Receivables
- The share of other receivables varies mildly, mostly ranging between 2.2% and 3.3%. It experiences small dips and rises without a clear long-term trend, suggesting relative stability in this asset component.
- Inventories
- Inventories show a gradual upward trend from around 7.5% to over 10%, indicating accumulation or higher investment in inventory assets over time. This reflects possible growth in product holdings or adjustments in supply chain management.
- Prepaid Expenses
- Data for prepaid expenses appears only in later periods, demonstrating a significant increasing trend from 8.66% to a peak of approximately 17.86%. This sharp rise may indicate prepayments becoming a more substantial asset category.
- Other Current Assets
- Other current assets fluctuate notably, initially around 5-7%, sharply declining to below 1% in later periods, and then slightly recovering. This steep decrease suggests a reclassification or reduction in other current asset holdings.
- Current Assets
- Overall current assets as a percentage of total assets show a steady increase over time, from about 34% up to 54%, indicating a strategic shift towards more liquid or short-term assets in the asset structure.
- Investments
- Investments decrease gradually from nearly 7% to below 2.5% of total assets, indicating a reduction in long-term investment holdings across the periods analysed.
- Goodwill
- Goodwill declines steadily from over 9% to about 5% of total assets, reflecting possible amortization, impairments, or divestitures impacting intangible asset values.
- Other Intangible Assets, Net
- There is a clear downward trajectory in other intangible assets, dropping from approximately 19% to about 5.6%, consistent with amortization or write-downs over the timeframe.
- Deferred Tax Assets
- Deferred tax assets show a modest upward trend, increasing from around 6% to a peak above 10%, before slightly declining near the end. This may correspond to changes in tax positions or timing differences on earnings recognition.
- Property and Equipment, Net
- Property and equipment as a percentage of total assets maintain relative stability around 18-21%, suggesting consistent investment and depreciation patterns without significant fluctuations.
- Other Noncurrent Assets
- This category rises in early periods to around 9.5%, then gradually declines to about 5.6%, indicating a reallocation or write-down of other long-term asset components over time.
- Noncurrent Assets
- Noncurrent assets as a share of total assets demonstrate a slow but steady decline from nearly 66% to under 46%. This overall reduction indicates a strategic shift from long-term to more current or liquid assets.
- Total Assets
- Total assets consistently represent 100% as expected, serving as the base for measuring relative asset proportions.