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.

Analysis of Liquidity Ratios
Quarterly Data

Microsoft Excel

Liquidity Ratios (Summary)

Ulta Beauty Inc., liquidity ratios (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
Current ratio 1.69 1.64 1.61 1.62 1.63 1.58 1.46 1.74 1.81 1.68 1.87 1.82 2.64 2.49 1.81 1.67 1.80 1.93 2.32 2.06 2.41 2.42 2.64 2.30 2.79 2.86
Quick ratio 0.38 0.51 0.56 0.27 0.41 0.53 0.43 0.48 0.67 0.72 0.92 0.57 1.21 1.13 0.56 0.26 0.41 0.60 0.66 0.41 0.65 0.76 0.77 0.27 0.60 0.92
Cash ratio 0.26 0.39 0.44 0.15 0.29 0.41 0.28 0.37 0.56 0.62 0.78 0.46 1.09 1.05 0.44 0.17 0.31 0.50 0.50 0.30 0.51 0.63 0.62 0.15 0.48 0.81

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).

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Ulta Beauty Inc. current ratio improved from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Ulta Beauty Inc. quick ratio deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Ulta Beauty Inc. cash ratio deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.

Current Ratio

Ulta Beauty Inc., current ratio calculation (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
Selected Financial Data (US$ in thousands)
Current assets 2,519,248 2,685,980 2,709,304 2,745,815 2,442,913 2,531,867 2,281,183 2,833,693 2,494,934 2,563,756 2,514,777 2,245,009 2,799,188 2,728,820 2,055,317 2,097,468 1,920,600 2,019,332 1,914,861 2,025,973 1,830,158 1,802,699 1,693,743 1,646,288 1,592,494 1,672,972
Current liabilities 1,491,174 1,633,900 1,681,775 1,697,771 1,502,054 1,599,747 1,558,010 1,624,116 1,381,533 1,522,763 1,343,713 1,230,343 1,061,329 1,096,179 1,137,261 1,256,920 1,064,934 1,045,605 823,736 984,083 758,755 745,092 642,166 714,712 570,277 584,252
Liquidity Ratio
Current ratio1 1.69 1.64 1.61 1.62 1.63 1.58 1.46 1.74 1.81 1.68 1.87 1.82 2.64 2.49 1.81 1.67 1.80 1.93 2.32 2.06 2.41 2.42 2.64 2.30 2.79 2.86
Benchmarks
Current Ratio, Competitors2
Amazon.com Inc. 1.05 0.98 0.95 0.92 0.94 0.94 0.95 0.96 1.14 1.12 1.20 1.05 1.05 1.11 1.18 1.08 1.10 1.10 1.10 1.09
Home Depot Inc. 1.31 1.27 1.41 1.39 1.18 1.11 1.01 1.13 1.06 1.10 1.23 1.36 1.30 1.17 1.08 1.08 1.10 1.04 1.11 1.09 1.13 1.17
Lowe’s Cos. Inc. 1.26 1.25 1.10 1.20 1.11 1.17 1.02 1.19 1.16 1.17 1.19 1.38 1.30 1.20 1.01 1.04 1.06 1.09 0.98 1.00 1.06 1.02
TJX Cos. Inc. 1.20 1.20 1.21 1.16 1.17 1.25 1.27 1.29 1.33 1.52 1.46 1.41 1.51 2.20 1.24 1.22 1.25 1.23 1.53 1.55 1.64 1.69

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).

1 Q2 2024 Calculation
Current ratio = Current assets ÷ Current liabilities
= 2,519,248 ÷ 1,491,174 = 1.69

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Current ratio A liquidity ratio calculated as current assets divided by current liabilities. Ulta Beauty Inc. current ratio improved from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.

Quick Ratio

Ulta Beauty Inc., quick ratio calculation (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
Selected Financial Data (US$ in thousands)
Cash and cash equivalents 388,627 636,449 737,877 250,628 434,226 654,486 431,560 605,053 770,144 947,456 1,046,051 560,902 1,157,318 1,043,540 392,325 208,843 177,398 326,831 409,251 296,944 237,107 231,886 277,445 46,787 92,860 321,725
Short-term investments 110,000 110,000 150,000 195,000 149,000 237,193 120,000 60,000 180,000 150,000
Receivables, net 174,444 190,282 199,422 200,304 180,514 192,754 233,682 169,212 154,416 154,342 193,109 136,271 127,992 88,691 139,337 112,888 107,263 110,046 136,168 102,353 103,666 100,274 99,719 82,934 67,593 62,936
Total quick assets 563,071 826,731 937,299 450,932 614,740 847,240 665,242 774,265 924,560 1,101,798 1,239,160 697,173 1,285,310 1,242,231 641,662 321,731 434,661 631,877 545,419 399,297 489,773 569,353 497,164 189,721 340,453 534,661
 
Current liabilities 1,491,174 1,633,900 1,681,775 1,697,771 1,502,054 1,599,747 1,558,010 1,624,116 1,381,533 1,522,763 1,343,713 1,230,343 1,061,329 1,096,179 1,137,261 1,256,920 1,064,934 1,045,605 823,736 984,083 758,755 745,092 642,166 714,712 570,277 584,252
Liquidity Ratio
Quick ratio1 0.38 0.51 0.56 0.27 0.41 0.53 0.43 0.48 0.67 0.72 0.92 0.57 1.21 1.13 0.56 0.26 0.41 0.60 0.66 0.41 0.65 0.76 0.77 0.27 0.60 0.92
Benchmarks
Quick Ratio, Competitors2
Amazon.com Inc. 0.53 0.44 0.43 0.44 0.45 0.42 0.43 0.48 0.68 0.64 0.76 0.63 0.67 0.67 0.76 0.62 0.63 0.60 0.60 0.58
Home Depot Inc. 0.27 0.22 0.26 0.26 0.18 0.22 0.20 0.32 0.30 0.37 0.47 0.68 0.69 0.48 0.23 0.23 0.26 0.21 0.22 0.22 0.31 0.33
Lowe’s Cos. Inc. 0.22 0.18 0.09 0.18 0.09 0.17 0.07 0.32 0.29 0.31 0.28 0.52 0.60 0.34 0.06 0.06 0.13 0.18 0.05 0.12 0.18 0.11
TJX Cos. Inc. 0.49 0.53 0.59 0.35 0.40 0.49 0.64 0.65 0.77 0.95 1.01 0.93 0.92 0.96 0.50 0.33 0.39 0.40 0.61 0.52 0.63 0.70

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).

1 Q2 2024 Calculation
Quick ratio = Total quick assets ÷ Current liabilities
= 563,071 ÷ 1,491,174 = 0.38

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Quick ratio A liquidity ratio calculated as (cash plus short-term marketable investments plus receivables) divided by current liabilities. Ulta Beauty Inc. quick ratio deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.

Cash Ratio

Ulta Beauty Inc., cash ratio calculation (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
Selected Financial Data (US$ in thousands)
Cash and cash equivalents 388,627 636,449 737,877 250,628 434,226 654,486 431,560 605,053 770,144 947,456 1,046,051 560,902 1,157,318 1,043,540 392,325 208,843 177,398 326,831 409,251 296,944 237,107 231,886 277,445 46,787 92,860 321,725
Short-term investments 110,000 110,000 150,000 195,000 149,000 237,193 120,000 60,000 180,000 150,000
Total cash assets 388,627 636,449 737,877 250,628 434,226 654,486 431,560 605,053 770,144 947,456 1,046,051 560,902 1,157,318 1,153,540 502,325 208,843 327,398 521,831 409,251 296,944 386,107 469,079 397,445 106,787 272,860 471,725
 
Current liabilities 1,491,174 1,633,900 1,681,775 1,697,771 1,502,054 1,599,747 1,558,010 1,624,116 1,381,533 1,522,763 1,343,713 1,230,343 1,061,329 1,096,179 1,137,261 1,256,920 1,064,934 1,045,605 823,736 984,083 758,755 745,092 642,166 714,712 570,277 584,252
Liquidity Ratio
Cash ratio1 0.26 0.39 0.44 0.15 0.29 0.41 0.28 0.37 0.56 0.62 0.78 0.46 1.09 1.05 0.44 0.17 0.31 0.50 0.50 0.30 0.51 0.63 0.62 0.15 0.48 0.81
Benchmarks
Cash Ratio, Competitors2
Amazon.com Inc. 0.53 0.44 0.43 0.44 0.45 0.42 0.43 0.48 0.68 0.64 0.76 0.63 0.67 0.67 0.76 0.62 0.63 0.60 0.60 0.58
Home Depot Inc. 0.12 0.05 0.12 0.10 0.05 0.09 0.08 0.19 0.17 0.24 0.34 0.58 0.58 0.37 0.12 0.11 0.14 0.10 0.11 0.10 0.19 0.20
Lowe’s Cos. Inc. 0.22 0.18 0.09 0.18 0.09 0.17 0.07 0.32 0.29 0.31 0.28 0.52 0.60 0.34 0.06 0.06 0.13 0.18 0.05 0.12 0.18 0.11
TJX Cos. Inc. 0.44 0.48 0.53 0.30 0.35 0.43 0.59 0.60 0.71 0.89 0.97 0.90 0.87 0.92 0.45 0.27 0.33 0.34 0.55 0.45 0.56 0.63

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).

1 Q2 2024 Calculation
Cash ratio = Total cash assets ÷ Current liabilities
= 388,627 ÷ 1,491,174 = 0.26

2 Click competitor name to see calculations.

Liquidity ratio Description The company
Cash ratio A liquidity ratio calculated as (cash plus short-term marketable investments) divided by current liabilities. Ulta Beauty Inc. cash ratio deteriorated from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.