Stock Analysis on Net
Stock Analysis on Net

Keurig Dr Pepper Inc. (NASDAQ:KDP)

This company has been moved to the archive! The financial data has not been updated since July 28, 2022.

Common-Size Balance Sheet: Assets 

Keurig Dr Pepper Inc., common-size consolidated balance sheet: assets

Microsoft Excel
Dec 31, 2021 Dec 31, 2020 Dec 31, 2019 Dec 31, 2018
Cash and cash equivalents 1.12 0.48 0.15 0.17
Restricted cash and restricted cash equivalents 0.00 0.03 0.05 0.09
Trade accounts receivable, net 2.27 2.11 2.25 2.35
Inventories 1.77 1.53 1.32 1.28
Other receivables 0.22 0.17 0.13 0.10
Customer incentive programs 0.04 0.07 0.02 0.02
Derivative instruments 0.28 0.09 0.06 0.02
Prepaid marketing 0.02 0.03 0.03 0.06
Spare parts 0.14 0.11 0.10 0.09
Assets held for sale 0.00 0.00 0.33 0.02
Income tax receivable 0.03 0.02 0.01 0.04
Other 0.14 0.15 0.12 0.16
Prepaid expenses and other current assets 0.88% 0.65% 0.81% 0.52%
Current assets 6.04% 4.80% 4.59% 4.41%
Property, plant and equipment, net 4.93 4.44 4.10 4.72
Investments in unconsolidated affiliates 0.06 0.18 0.30 0.38
Goodwill 39.89 40.55 40.74 40.91
Other intangible assets, net 47.15 48.15 48.70 48.99
Customer incentive programs 0.12 0.14 0.07 0.07
Equity securities 0.11 0.08 0.08 0.09
Operating lease right-of-use assets 1.33 1.30 1.00 0.00
Derivative instruments 0.01 0.02 0.04 0.19
Equity securities without readily determinable fair values 0.00 0.00 0.00 0.00
Non-current restricted cash and restricted cash equivalents 0.00 0.00 0.02 0.02
Related party notes receivable 0.00 0.00 0.10 0.03
Other 0.28 0.25 0.20 0.12
Other non-current assets 1.85% 1.80% 1.51% 0.53%
Deferred tax assets 0.08 0.09 0.06 0.05
Non-current assets 93.96% 95.20% 95.41% 95.59%
Total assets 100.00% 100.00% 100.00% 100.00%

Based on: 10-K (reporting date: 2021-12-31), 10-K (reporting date: 2020-12-31), 10-K (reporting date: 2019-12-31), 10-K (reporting date: 2018-12-31).

Cash and cash equivalents
There is a notable upward trend in cash and cash equivalents as a percentage of total assets, increasing from 0.17% in 2018 to 1.12% in 2021. This suggests a growing liquidity position over the period.
Restricted cash and restricted cash equivalents
This category steadily declined from 0.09% in 2018 to zero in 2021, indicating a reduction in cash with restrictions or held for specific purposes.
Trade accounts receivable, net
A slight fluctuation is observed with a minor decrease from 2.35% in 2018 to 2.11% in 2020, followed by a small increase to 2.27% in 2021, suggesting relative stability in receivables management.
Inventories
Inventories rose steadily from 1.28% in 2018 to 1.77% in 2021, indicating increased inventory holdings relative to total assets.
Other receivables
A gradual upward trend is seen, from 0.10% in 2018 to 0.22% in 2021, reflecting a slight increase in miscellaneous receivables.
Customer incentive programs (current)
Values increased from 0.02% in 2018 to a peak of 0.07% in 2020 before declining to 0.04% in 2021, indicating some volatility in customer incentives on current levels.
Derivative instruments (current)
This item increased significantly from 0.02% in 2018 to 0.28% in 2021, suggesting increased use or valuation of derivative contracts.
Prepaid marketing
There is a decreasing trend from 0.06% in 2018 to 0.02% in 2021, indicating lower prepaid marketing expenses over the years.
Spare parts
Spare parts showed a slight increase from 0.09% to 0.14%, reflecting a modest rise in the inventory of parts.
Assets held for sale
This category increased sharply to 0.33% in 2019 but then fell to zero in 2021, reflecting divestitures or asset reclassifications after 2019.
Income tax receivable
Relatively low and stable, fluctuating slightly between 0.01% and 0.04%, indicating consistent minor tax receivables.
Other current assets
Maintained relative stability around 0.12%-0.16%, with a slight increase to 0.14% in 2021.
Prepaid expenses and other current assets
This category fluctuated, rising from 0.52% in 2018 to 0.88% in 2021, indicating increasing prepayments and other current assets.
Current assets
Overall, current assets as a percentage of total assets increased moderately from 4.41% in 2018 to 6.04% in 2021, suggesting improved current asset coverage.
Property, plant and equipment, net
A decline occurred from 4.72% in 2018 to 4.10% in 2019, followed by recovery to 4.93% in 2021, showing a rebound in investment or asset valuation.
Investments in unconsolidated affiliates
A pronounced decline from 0.38% in 2018 to 0.06% in 2021 indicates a reduction in equity investments in affiliates.
Goodwill
Goodwill steadily declined from 40.91% of total assets in 2018 to 39.89% in 2021, suggesting possible impairments or disposals.
Other intangible assets, net
This group also showed a downward trend, from 48.99% to 47.15%, indicating amortization or write-downs of intangible assets over the period.
Customer incentive programs (non-current)
Non-current customer incentive programs increased from 0.07% in 2018 to 0.14% in 2020, then slightly declined to 0.12% in 2021, mirroring trends seen in current customer incentives.
Equity securities
Small fluctuations were observed, with a slight increase from 0.09% in 2018 to 0.11% in 2021.
Operating lease right-of-use assets
Identified from 2019 onward, this asset grew from 1.00% in 2019 to 1.33% in 2021, reflecting adoption and growth of lease accounting recognition.
Derivative instruments (non-current)
A notable decline from 0.19% in 2018 to 0.01% in 2021 suggests reduced long-term derivative asset holdings.
Equity securities without readily determinable fair values
No values reported throughout the period, indicating no holdings in this category.
Non-current restricted cash and restricted cash equivalents
Minor and declining presence until disappearance after 2020, implying reduced restricted cash in non-current assets.
Related party notes receivable
Increased modestly in 2019 but data is missing for subsequent years, limiting analysis.
Other non-current assets
A marked increase from 0.53% in 2018 to 1.85% in 2021, indicating accumulation or reclassification of various non-current assets.
Deferred tax assets
A gradual increase from 0.05% in 2018 to 0.09% in 2020, with a minor decline to 0.08% in 2021, showing stable deferred tax recognition.
Non-current assets
Slight downward trend from 95.59% in 2018 to 93.96% in 2021, suggesting a marginal shift toward current assets.
Total assets
Maintained constant at 100% by definition.