Stock Analysis on Net

Eli Lilly & Co. (NYSE:LLY)

$24.99

Common-Size Balance Sheet: Assets
Quarterly Data

Paying user area

The data is hidden behind: . Unhide it.

This is a one-time payment. There is no automatic renewal.


We accept:

Visa Mastercard American Express Maestro Discover JCB PayPal Google Pay
Visa Secure Mastercard Identity Check American Express SafeKey

Eli Lilly & Co., common-size consolidated balance sheet: assets (quarterly data)

Microsoft Excel
Mar 31, 2025 Dec 31, 2024 Sep 30, 2024 Jun 30, 2024 Mar 31, 2024 Dec 31, 2023 Sep 30, 2023 Jun 30, 2023 Mar 31, 2023 Dec 31, 2022 Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020
Cash and cash equivalents
Short-term investments
Accounts receivable, net of allowances
Other receivables
Inventories
Prepaid expenses
Other current assets
Current assets
Investments
Goodwill
Other intangibles, net
Deferred tax assets
Property and equipment, net of accumulated depreciation
Other noncurrent assets
Noncurrent assets
Total assets

Based on: 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 percentage of cash and cash equivalents relative to total assets showed a fluctuating trend across the periods. Starting at 4.13% in March 2020, it peaked above 8% in the third quarter of 2020, followed by a general decline with some intermittent increases. Most recently, it decreased to 3.46% by March 2025, indicating a gradual reduction in liquid cash reserves as a portion of total assets.
Short-term Investments
Short-term investments remained consistently low, fluctuating between 0.05% and 0.29% of total assets throughout the timeframe. The highest values appeared towards late 2022, but a decline was evident by early 2025, dropping to 0.14%, suggesting minimal allocation to short-term investment assets.
Accounts Receivable, Net of Allowances
This item exhibited moderate variability, generally ranging between 11% and 15% of total assets. There was a slight upward trajectory from the lower end in early 2020 to peaks exceeding 15% in mid-2024, indicating increasing receivables volume or slower collections during some periods.
Other Receivables
Other receivables remained relatively stable, mostly between 2% and 3.5%. There were slight increases and decreases, with values tapering off towards 2.2% by the last reported period, suggesting a minor decline in miscellaneous receivables.
Inventories
Inventories as a percentage of total assets demonstrated an upward trend overall. Beginning at 7.55% in March 2020, the figure fluctuated but showed consistent growth, culminating at 10.42% in March 2025. This reflects increasing investment into inventory over the period.
Prepaid Expenses
Data for prepaid expenses starts from 2023 and shows a notable rise from 8.66% to a peak of 16.39% by June 2024. This marked increase may reflect changes in payment practices or asset recognition, indicating growing prepaid resource allocation.
Other Current Assets
Other current assets were generally between 5% and 9% until late 2023, after which a significant decline occurred, dropping to only 0.08% by March 2025. This sharp decrease points to substantial reclassification or disposal of these assets in the recent periods.
Current Assets
The proportion of current assets to total assets maintained a gradual increase from approximately 34% in early 2020 to over 46% by March 2025, suggesting an overall shift towards more liquid and short-term asset composition within the total asset base.
Investments
Investments as a percentage of total assets peaked around 7.27% in mid-2021 but then steadily declined to 3.61% by early 2025. This represents a significant reduction in investment holdings relative to total assets over the analyzed period.
Goodwill
Goodwill consistently constituted between 6% and 9% of total assets. After a moderate decline from just over 9% in early 2020, it stabilized around 7% in the later years, ending at 6.46% by March 2025, indicating some amortization or impairment activity.
Other Intangibles, Net
Other intangibles demonstrated a noticeable decreasing trend. Starting from 18.9% of total assets in early 2020, it declined steadily to 6.73% by March 2025. This suggests ongoing amortization or write-downs impacting intangible assets over time.
Deferred Tax Assets
Deferred tax assets showed an upward progression from around 6% in 2020 to just over 10% in late 2024, before slightly decreasing to 9.59% by March 2025. This increase reflects growing deferred tax recognition within the asset structure.
Property and Equipment, Net of Accumulated Depreciation
Property and equipment remained a significant component of total assets, fluctuating around 18% to 22%. The value trended upward, reaching a peak close to 21.73% in late 2024, indicating sustained or increased investment in fixed assets with some variability.
Other Noncurrent Assets
Other noncurrent assets exhibited minor fluctuations around 6.8% to 9.5%, mostly maintaining stability without significant long-term trend changes.
Noncurrent Assets
The share of noncurrent assets decreased over the reported periods from about 66% in early 2020 to approximately 54% by March 2025. This decline reflects a rebalancing towards current assets and reductions in certain long-term asset categories.
Total Assets
Total assets served as the base and remained constant at 100% throughout the reporting periods, serving as a reference for the percentage allocations of all individual asset categories.