Stock Analysis on Net
AI Tokens
Stock Analysis on Net

Ulta Beauty Inc. (NASDAQ:ULTA)

This company has been moved to the archive! The financial data has not been updated since August 24, 2023.

Common-Size Balance Sheet: Assets
Quarterly Data

Ulta Beauty Inc., common-size consolidated balance sheet: assets (quarterly data)

Microsoft Excel
Jul 29, 2023 Apr 29, 2023 Jan 28, 2023 Oct 29, 2022 Jul 30, 2022 Apr 30, 2022 Jan 29, 2022 Oct 30, 2021 Jul 31, 2021 May 1, 2021 Jan 30, 2021 Oct 31, 2020 Aug 1, 2020 May 2, 2020 Feb 1, 2020 Nov 2, 2019 Aug 3, 2019 May 4, 2019 Feb 2, 2019 Nov 3, 2018 Aug 4, 2018 May 5, 2018 Feb 3, 2018 Oct 28, 2017 Jul 29, 2017 Apr 29, 2017
Cash and cash equivalents 7.40 11.84 13.74 4.70 8.78 13.06 9.06 11.44 15.54 18.62 20.55 11.52 21.05 18.87 8.07 4.24 3.77 6.86 12.82 8.91 7.71 7.67 9.54 1.65 3.44 11.88
Short-term investments 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1.99 2.26 0.00 3.18 4.09 0.00 0.00 4.85 7.85 4.13 2.12 6.66 5.54
Receivables, net 3.32 3.54 3.71 3.76 3.65 3.85 4.90 3.20 3.12 3.03 3.79 2.80 2.33 1.60 2.86 2.29 2.28 2.31 4.27 3.07 3.37 3.32 3.43 2.93 2.50 2.32
Merchandise inventories, net 34.59 32.58 29.86 39.66 33.69 31.34 31.47 36.24 29.14 26.61 22.95 29.54 24.90 24.24 26.60 32.81 27.94 26.23 38.05 44.55 39.69 37.61 37.69 47.61 42.36 38.72
Prepaid expenses and other current assets 2.11 2.01 2.43 2.58 2.49 2.28 2.33 2.00 2.18 2.13 2.11 2.05 1.87 1.75 2.13 2.40 2.78 2.88 4.33 3.60 3.37 3.19 3.39 3.58 3.63 3.32
Prepaid income taxes 0.57 0.00 0.71 0.80 0.79 0.00 0.12 0.71 0.37 0.00 0.00 0.18 0.78 0.89 0.34 0.82 0.82 0.01 0.53 0.67 0.56 0.00 0.05 0.19 0.34 0.00
Current assets 48.00% 49.97% 50.45% 51.50% 49.39% 50.52% 47.88% 53.59% 50.36% 50.39% 49.41% 46.09% 50.92% 49.34% 42.26% 42.55% 40.77% 42.37% 60.00% 60.79% 59.55% 59.65% 58.23% 58.07% 58.93% 61.79%
Property and equipment, net 20.45 18.97 18.79 18.14 18.44 18.15 19.19 17.18 18.36 18.88 19.56 21.40 19.61 20.76 24.79 25.02 25.90 25.30 38.42 37.74 39.47 39.41 40.89 41.37 40.53 37.70
Operating lease right-of-use assets 29.51 29.01 29.07 29.20 30.51 29.69 31.11 27.70 29.67 29.24 29.56 31.00 28.16 28.63 31.61 31.03 31.84 31.03 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Goodwill 0.21 0.20 0.20 0.20 0.22 0.22 0.23 0.21 0.22 0.21 0.21 0.22 0.20 0.20 0.22 0.22 0.23 0.23 0.34 0.27 0.00 0.00 0.00 0.00 0.00 0.00
Other intangible assets, net 0.01 0.02 0.02 0.02 0.02 0.03 0.03 0.03 0.04 0.04 0.05 0.06 0.05 0.06 0.07 0.07 0.08 0.09 0.14 0.21 0.00 0.00 0.00 0.00 0.00 0.00
Deferred compensation plan assets 0.76 0.69 0.66 0.59 0.68 0.72 0.81 0.69 0.73 0.67 0.65 0.62 0.52 0.46 0.57 0.53 0.52 0.50 0.64 0.64 0.64 0.61 0.58 0.56 0.54 0.51
Other long-term assets 1.06 1.14 0.80 0.35 0.74 0.69 0.75 0.60 0.62 0.56 0.55 0.62 0.53 0.55 0.48 0.56 0.66 0.48 0.46 0.34 0.35 0.33 0.30 0.00 0.00 0.00
Long-term assets 52.00% 50.03% 49.55% 48.50% 50.61% 49.48% 52.12% 46.41% 49.64% 49.61% 50.59% 53.91% 49.08% 50.66% 57.74% 57.45% 59.23% 57.63% 40.00% 39.21% 40.45% 40.35% 41.77% 41.93% 41.07% 38.21%
Total assets 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

Based on: 10-Q (reporting date: 2023-07-29), 10-Q (reporting date: 2023-04-29), 10-K (reporting date: 2023-01-28), 10-Q (reporting date: 2022-10-29), 10-Q (reporting date: 2022-07-30), 10-Q (reporting date: 2022-04-30), 10-K (reporting date: 2022-01-29), 10-Q (reporting date: 2021-10-30), 10-Q (reporting date: 2021-07-31), 10-Q (reporting date: 2021-05-01), 10-K (reporting date: 2021-01-30), 10-Q (reporting date: 2020-10-31), 10-Q (reporting date: 2020-08-01), 10-Q (reporting date: 2020-05-02), 10-K (reporting date: 2020-02-01), 10-Q (reporting date: 2019-11-02), 10-Q (reporting date: 2019-08-03), 10-Q (reporting date: 2019-05-04), 10-K (reporting date: 2019-02-02), 10-Q (reporting date: 2018-11-03), 10-Q (reporting date: 2018-08-04), 10-Q (reporting date: 2018-05-05), 10-K (reporting date: 2018-02-03), 10-Q (reporting date: 2017-10-28), 10-Q (reporting date: 2017-07-29), 10-Q (reporting date: 2017-04-29).

The asset composition of the entity underwent a significant structural transformation between 2017 and 2023, characterized by a shift in the balance between current and long-term assets and a major reclassification of long-term holdings.

Liquidity and Cash Management
Cash and cash equivalents exhibited substantial volatility, ranging from a low of 1.65% in October 2017 to a peak of 21.05% in August 2020. A notable surge in liquidity occurred during the first half of 2020, where cash holdings consistently remained above 18% of total assets, suggesting a strategic accumulation of liquid reserves during the onset of the global pandemic. Following this period, cash levels normalized, stabilizing between 7% and 14% through July 2023.
Structural Shift in Long-Term Assets
A fundamental change in the balance sheet occurred in May 2019 with the introduction of operating lease right-of-use assets, which immediately accounted for approximately 31% of total assets. This coincided with a sharp decline in the relative weight of property and equipment, net, which dropped from roughly 40% in early 2018 to a range of 18% to 20% from 2020 onwards. This transition indicates a shift in how the entity accounts for its physical footprint, moving from owned or capitalized assets to recognized lease liabilities and assets.
Inventory Trends
Merchandise inventories represent the largest component of current assets, though their relative weight has fluctuated. After peaking at 47.61% in October 2017, inventory levels saw a marked decrease in 2019, dropping to a low of 24.24% in May 2020. Recently, there has been a gradual upward trend, with inventories rising to 34.59% by July 2023, reflecting possible changes in stock management strategies or seasonal buildup.
Asset Mix and Composition
The ratio of current assets to total assets shifted from a dominant position of approximately 60% between 2017 and 2019 to a more balanced distribution of approximately 48% to 52% from 2020 through 2023. Consequently, long-term assets, which previously hovered around 40%, now constitute approximately 50% of the total asset base, primarily driven by the persistence of the operating lease right-of-use assets.
Other Asset Components
Goodwill and other intangible assets have remained negligible, collectively representing less than 0.3% of total assets throughout the analyzed period. Deferred compensation plan assets have remained stable, consistently ranging between 0.46% and 0.81% of the total asset mix.

AI Ask an analyst for more

My previous chats

Add tokens

Hi, I’m an AI-powered financial analyst at Stock Analysis on Net.
Without a user account, I tend to respond rather slowly.

How can I help you?