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 Long-term (Investment) Activity Ratios
Quarterly Data

Microsoft Excel

Long-term Activity Ratios (Summary)

Ulta Beauty Inc., long-term (investment) activity 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
Net fixed asset turnover 10.00 10.29 10.11 10.04 10.27 9.94 9.44 8.91 8.42 7.20 6.18 6.01 5.93 5.95 6.14 5.85 5.82 5.74 5.48 5.19 5.20 5.13 4.95
Net fixed asset turnover (including operating lease, right-of-use asset) 4.09 4.07 3.97 3.85 3.87 3.77 3.60 3.41 3.22 2.83 2.46 2.45 2.43 2.50 2.70 2.61 2.61 2.58 5.48 5.19 5.20 5.13 4.95
Total asset turnover 2.04 1.95 1.90 1.82 1.89 1.80 1.81 1.53 1.55 1.36 1.21 1.28 1.16 1.23 1.52 1.46 1.51 1.45 2.10 1.96 2.05 2.02 2.02
Equity turnover 5.23 5.20 5.21 5.05 5.30 5.18 5.62 4.08 4.07 3.75 3.08 3.38 3.61 3.89 3.89 3.91 3.86 3.56 3.69 3.56 3.48 3.43 3.32

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

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Ulta Beauty Inc. net fixed asset turnover ratio improved from Q4 2023 to Q1 2024 but then deteriorated significantly from Q1 2024 to Q2 2024.
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Ulta Beauty Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Ulta Beauty Inc. total asset turnover ratio improved from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Ulta Beauty Inc. equity turnover ratio deteriorated from Q4 2023 to Q1 2024 but then improved from Q1 2024 to Q2 2024 exceeding Q4 2023 level.

Net Fixed Asset Turnover

Ulta Beauty Inc., net fixed asset turnover 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)
Net sales 2,529,809 2,634,263 3,226,773 2,338,793 2,297,113 2,345,901 2,729,388 1,995,775 1,967,207 1,938,519 2,198,701 1,552,033 1,228,009 1,173,210 2,305,918 1,682,514 1,666,607 1,743,029 2,124,716 1,560,011 1,488,221 1,543,667 1,937,592 1,342,181 1,289,854 1,314,879
Property and equipment, net 1,073,144 1,019,978 1,009,273 967,039 912,017 909,543 914,476 908,665 909,507 960,440 995,795 1,042,262 1,077,825 1,148,341 1,205,524 1,233,412 1,219,948 1,205,919 1,226,029 1,257,775 1,212,978 1,190,969 1,189,453 1,172,682 1,095,135 1,020,853
Long-term Activity Ratio
Net fixed asset turnover1 10.00 10.29 10.11 10.04 10.27 9.94 9.44 8.91 8.42 7.20 6.18 6.01 5.93 5.95 6.14 5.85 5.82 5.74 5.48 5.19 5.20 5.13 4.95
Benchmarks
Net Fixed Asset Turnover, Competitors2
Amazon.com Inc. 2.82 2.82 2.78 2.75 2.75 2.83 2.80 2.84 2.93 3.11 3.32 3.45 3.41 3.48 3.72 3.81 3.86
Home Depot Inc. 5.98 6.07 6.14 6.23 6.15 6.06 6.00 5.92 5.83 5.73 5.35 5.27 5.10 4.94 4.84 4.94 4.91 4.92 4.84
Lowe’s Cos. Inc. 5.37 5.50 5.53 5.55 5.10 5.05 5.05 5.03 4.97 4.95 4.68 4.57 4.32 4.00 3.86 3.91 3.94 3.95 3.87
TJX Cos. Inc. 8.31 8.53 8.63 8.84 9.21 9.43 9.21 8.84 8.46 7.46 6.38 6.67 6.61 7.08 7.83 7.74 7.94 7.88 7.42

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
Net fixed asset turnover = (Net salesQ2 2024 + Net salesQ1 2024 + Net salesQ4 2023 + Net salesQ3 2023) ÷ Property and equipment, net
= (2,529,809 + 2,634,263 + 3,226,773 + 2,338,793) ÷ 1,073,144 = 10.00

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover An activity ratio calculated as total revenue divided by net fixed assets. Ulta Beauty Inc. net fixed asset turnover ratio improved from Q4 2023 to Q1 2024 but then deteriorated significantly from Q1 2024 to Q2 2024.

Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset)

Ulta Beauty Inc., net fixed asset turnover (including operating lease, right-of-use asset) 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)
Net sales 2,529,809 2,634,263 3,226,773 2,338,793 2,297,113 2,345,901 2,729,388 1,995,775 1,967,207 1,938,519 2,198,701 1,552,033 1,228,009 1,173,210 2,305,918 1,682,514 1,666,607 1,743,029 2,124,716 1,560,011 1,488,221 1,543,667 1,937,592 1,342,181 1,289,854 1,314,879
 
Property and equipment, net 1,073,144 1,019,978 1,009,273 967,039 912,017 909,543 914,476 908,665 909,507 960,440 995,795 1,042,262 1,077,825 1,148,341 1,205,524 1,233,412 1,219,948 1,205,919 1,226,029 1,257,775 1,212,978 1,190,969 1,189,453 1,172,682 1,095,135 1,020,853
Operating lease right-of-use assets 1,549,146 1,559,560 1,561,263 1,556,940 1,509,246 1,488,040 1,482,256 1,464,533 1,470,166 1,487,616 1,504,614 1,510,030 1,548,239 1,583,490 1,537,565 1,529,524 1,499,556 1,479,132
Property and equipment, net (including operating lease, right-of-use asset) 2,622,290 2,579,538 2,570,536 2,523,979 2,421,263 2,397,583 2,396,732 2,373,198 2,379,673 2,448,056 2,500,409 2,552,292 2,626,064 2,731,831 2,743,089 2,762,936 2,719,504 2,685,051 1,226,029 1,257,775 1,212,978 1,190,969 1,189,453 1,172,682 1,095,135 1,020,853
Long-term Activity Ratio
Net fixed asset turnover (including operating lease, right-of-use asset)1 4.09 4.07 3.97 3.85 3.87 3.77 3.60 3.41 3.22 2.83 2.46 2.45 2.43 2.50 2.70 2.61 2.61 2.58 5.48 5.19 5.20 5.13 4.95
Benchmarks
Net Fixed Asset Turnover (including Operating Lease, Right-of-Use Asset), Competitors2
Amazon.com Inc. 2.08 2.07 2.04 2.03 2.03 2.10 2.09 2.13 2.17 2.30 2.51 2.61 2.56 2.59 2.80 2.85 2.87
Home Depot Inc. 4.69 4.78 4.83 4.95 4.95 4.90 4.85 4.79 4.70 4.63 4.31 4.29 4.14 3.96 3.89 3.95 3.90 3.93 4.84
Lowe’s Cos. Inc. 4.43 4.58 4.60 4.62 4.17 4.15 4.15 4.12 4.14 4.11 3.90 3.79 3.59 3.31 3.20 3.23 3.24 3.25 3.87
TJX Cos. Inc. 3.29 3.34 3.36 3.38 3.45 3.47 3.44 3.19 3.02 2.66 2.29 2.38 2.38 2.58 2.90 2.84 2.86 2.86 7.42

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
Net fixed asset turnover (including operating lease, right-of-use asset) = (Net salesQ2 2024 + Net salesQ1 2024 + Net salesQ4 2023 + Net salesQ3 2023) ÷ Property and equipment, net (including operating lease, right-of-use asset)
= (2,529,809 + 2,634,263 + 3,226,773 + 2,338,793) ÷ 2,622,290 = 4.09

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Net fixed asset turnover (including operating lease, right-of-use asset) An activity ratio calculated as total revenue divided by net fixed assets (including operating lease, right-of-use asset). Ulta Beauty Inc. net fixed asset turnover ratio (with operating lease, right-of-use asset) improved from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.

Total Asset Turnover

Ulta Beauty Inc., total asset turnover 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)
Net sales 2,529,809 2,634,263 3,226,773 2,338,793 2,297,113 2,345,901 2,729,388 1,995,775 1,967,207 1,938,519 2,198,701 1,552,033 1,228,009 1,173,210 2,305,918 1,682,514 1,666,607 1,743,029 2,124,716 1,560,011 1,488,221 1,543,667 1,937,592 1,342,181 1,289,854 1,314,879
Total assets 5,248,760 5,375,719 5,370,411 5,331,549 4,945,994 5,012,036 4,764,379 5,287,767 4,954,585 5,087,544 5,089,969 4,870,994 5,497,121 5,530,551 4,863,872 4,928,848 4,710,375 4,766,353 3,191,172 3,332,691 3,073,349 3,022,249 2,908,687 2,834,873 2,702,217 2,707,601
Long-term Activity Ratio
Total asset turnover1 2.04 1.95 1.90 1.82 1.89 1.80 1.81 1.53 1.55 1.36 1.21 1.28 1.16 1.23 1.52 1.46 1.51 1.45 2.10 1.96 2.05 2.02 2.02
Benchmarks
Total Asset Turnover, Competitors2
Amazon.com Inc. 1.09 1.14 1.13 1.13 1.11 1.17 1.16 1.16 1.12 1.20 1.23 1.30 1.20 1.23 1.25 1.34 1.25
Home Depot Inc. 2.03 2.04 2.06 2.05 2.05 1.99 2.10 2.02 2.04 1.95 1.87 1.88 1.88 1.91 2.15 2.12 2.12 2.13 2.46
Lowe’s Cos. Inc. 2.09 2.09 2.22 2.04 2.04 1.92 2.16 1.93 1.92 1.84 1.92 1.68 1.55 1.62 1.83 1.80 1.76 1.66 2.07
TJX Cos. Inc. 1.77 1.75 1.76 1.73 1.83 1.80 1.71 1.52 1.50 1.25 1.04 1.06 1.27 1.45 1.73 1.67 1.75 1.76 2.72

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
Total asset turnover = (Net salesQ2 2024 + Net salesQ1 2024 + Net salesQ4 2023 + Net salesQ3 2023) ÷ Total assets
= (2,529,809 + 2,634,263 + 3,226,773 + 2,338,793) ÷ 5,248,760 = 2.04

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Total asset turnover An activity ratio calculated as total revenue divided by total assets. Ulta Beauty Inc. total asset turnover ratio improved from Q4 2023 to Q1 2024 and from Q1 2024 to Q2 2024.

Equity Turnover

Ulta Beauty Inc., equity turnover 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)
Net sales 2,529,809 2,634,263 3,226,773 2,338,793 2,297,113 2,345,901 2,729,388 1,995,775 1,967,207 1,938,519 2,198,701 1,552,033 1,228,009 1,173,210 2,305,918 1,682,514 1,666,607 1,743,029 2,124,716 1,560,011 1,488,221 1,543,667 1,937,592 1,342,181 1,289,854 1,314,879
Stockholders’ equity 2,051,877 2,018,068 1,959,811 1,922,255 1,769,068 1,745,620 1,535,373 1,986,800 1,879,813 1,844,717 1,999,549 1,854,437 1,770,793 1,753,959 1,902,094 1,847,156 1,839,451 1,941,568 1,820,218 1,835,736 1,812,478 1,783,433 1,774,217 1,616,051 1,635,350 1,641,657
Long-term Activity Ratio
Equity turnover1 5.23 5.20 5.21 5.05 5.30 5.18 5.62 4.08 4.07 3.75 3.08 3.38 3.61 3.89 3.89 3.91 3.86 3.56 3.69 3.56 3.48 3.43 3.32
Benchmarks
Equity Turnover, Competitors2
Amazon.com Inc. 2.85 3.03 3.19 3.40 3.52 3.65 3.70 3.57 3.40 3.80 3.86 4.06 4.13 4.20 4.36 4.54 4.52
Home Depot Inc. 116.01 430.25 100.77 121.18 655.02 142.70 69.80 80.86 40.05 81.84
Lowe’s Cos. Inc. 212.01 62.35 20.95 18.46 43.17 36.59 29.20 27.19 22.15 19.57
TJX Cos. Inc. 7.75 7.83 7.85 8.70 9.20 8.91 8.09 7.08 6.75 6.16 5.51 6.00 7.24 7.78 7.01 7.33 7.55 7.71 7.72

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
Equity turnover = (Net salesQ2 2024 + Net salesQ1 2024 + Net salesQ4 2023 + Net salesQ3 2023) ÷ Stockholders’ equity
= (2,529,809 + 2,634,263 + 3,226,773 + 2,338,793) ÷ 2,051,877 = 5.23

2 Click competitor name to see calculations.

Long-term activity ratio Description The company
Equity turnover An activity ratio calculated as total revenue divided by shareholders’ equity. Ulta Beauty Inc. equity turnover ratio deteriorated from Q4 2023 to Q1 2024 but then improved from Q1 2024 to Q2 2024 exceeding Q4 2023 level.