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
Jun 30, 2025 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-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
Displayed notable fluctuations over the observed periods, peaking around the third and fourth quarters of 2020 and again in early 2023, followed by a general downward trend starting 2023, ending lower by mid-2025.
Short-term investments
Maintained a relatively low and stable percentage of total assets throughout the timeline, with slight increases into late 2022 and moderate declines afterward, indicating a consistent but minor allocation.
Accounts receivable, net of allowances
Exhibited mild fluctuations over the period, generally stable with a slight increasing trend toward late 2023 and 2024, suggesting consistent credit sales or collections processes.
Other receivables
Maintained a moderate and fairly steady share, with some peaks in the third quarter of 2023 and variability afterward, indicating occasional changes in miscellaneous receivables composition or timing.
Inventories
Showed a gradual increasing trend across the timeline, rising from approximately 7.5% to above 10% of total assets by mid-2025, which could reflect growing stock levels or changes in inventory management.
Prepaid expenses
Data was absent initially but appeared starting late 2023, showing a rapid increase, peaking at over 17% of total assets by mid-2025, indicating a significant growth in prepaid costs that may affect liquidity or operations.
Other current assets
Relatively stable through 2022 with a notable decline after early 2023, reaching minimal levels by mid-2025, which implies reclassification, utilization, or reduction in miscellaneous current assets.
Current assets
Remained generally stable around the mid-30% range through 2020 to early 2023, followed by a noticeable increase reaching nearly 50% of total assets by mid-2025, mainly driven by rises in prepaid expenses and inventories.
Investments
Experienced a gradual decline from over 7% in mid-2021 to around 3% by mid-2025, reflecting a reduction in long-term investment holdings as a percentage of total assets.
Goodwill
Demonstrated a consistent decline from about 9% of assets in early 2020 down to approximately 6% by mid-2025, suggesting amortization, impairment, or divestitures impacting intangible asset value.
Other intangibles, net
Showed a steady downward trajectory over the observed periods, dropping from nearly 19% to under 6% of total assets by mid-2025, indicating significant amortization or write-downs of intangible assets.
Deferred tax assets
Displayed a modest but steady increase from around 6% to slightly above 9% by early 2025, then a mild decline towards mid-2025, reflecting changes in tax positions or timing differences in recognition.
Property and equipment, net
Maintained relative stability between 18% and 22% of total assets, with minor fluctuations indicating consistent investment and depreciation patterns in fixed assets.
Other noncurrent assets
Generally stable with slight fluctuations, peaking near 9.5% around 2022 and declining gradually afterward to about 6% by mid-2025, suggesting either disposals or reclassification of noncurrent assets.
Noncurrent assets
Exhibited a downward trend from approximately 66% of total assets in early 2020 to just over 50% by mid-2025, indicating a shifting asset structure favoring current assets over time.
Total assets
Consistently represented 100%, serving as the base for all proportional analyses.