Analysis of Long-term (Investment) Activity Ratios
Quarterly Data
Activity ratios measure how efficiently a company performs day-to-day tasks, such us the collection of receivables and management of inventory.
Long-term Activity Ratios (Summary)
Ulta Beauty Inc., long-term (investment) activity ratios (quarterly data)
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).
- Net Fixed Asset Turnover
- The net fixed asset turnover ratio shows a consistent upward trend beginning with a value around 4.95 in early 2018, increasing steadily to reach a peak near 10.29 by late 2022, before slightly declining to 10 in mid-2023. This gradual increase indicates improving efficiency in utilizing fixed assets to generate revenue over the analyzed periods.
- Net Fixed Asset Turnover (Including Operating Lease, Right-of-Use Asset)
- This adjusted net fixed asset turnover displays a marked divergence from the standard net fixed asset turnover from mid-2018 onwards. Initially matching the standard ratio at about 4.95, it sharply declines to levels between 2.43 and 2.7 during 2019 and 2020. Post-2020, a gradual recovery is observable, climbing to just over 4 by mid-2023. This pattern suggests the impact of including operating leases and right-of-use assets substantially increases the asset base, thereby lowering turnover ratios initially before some recovery as lease arrangements or asset utilization potentially optimize.
- Total Asset Turnover
- The total asset turnover ratio fluctuates more than the net fixed asset turnover metrics. It starts close to 2.02 in early 2018, dips to lower levels around 1.16 to 1.28 during much of 2020, and experiences an upward recovery afterward, peaking above 2.04 at mid-2023. The ratio's variations reflect periods of decreased efficiency or asset base increases that were not matched by revenue gains, followed by improvements in overall asset use efficiency.
- Equity Turnover
- Equity turnover exhibits a gradual increase from approximately 3.32 in 2018 to a peak value near 5.62 in late 2021. Following that peak, the ratio slightly declines and stabilizes around 5.2 through mid-2023. This trend indicates a general enhancement in revenue generation relative to shareholders' equity over time, carrying some volatility around 2020 likely tied to economic or operational disruptions.
Net Fixed Asset Turnover
Ulta Beauty Inc., net fixed asset turnover calculation (quarterly data)
| 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.74 | 2.81 | 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 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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.
- Net Sales
- The net sales figures demonstrate a generally upward trend across the quarters observed. Starting from approximately 1.31 billion USD in April 2017, net sales experienced fluctuations but showed significant growth peaks notably in February 2018 (about 1.94 billion USD) and again in subsequent years, culminating in the highest recorded value in April 2023 at around 3.23 billion USD. There were intermittent declines or plateau phases, such as mid-2018 and late 2019 to early 2020, but overall the long-term trajectory suggests robust revenue expansion.
- Property and Equipment, Net
- Property and equipment net values show a contrasting pattern to net sales, displaying a gradual decline over the observed period. Beginning near 1.02 billion USD in April 2017, the values increased slightly into late 2017 and early 2018 but then started a steady decrease, reaching a trough of approximately 909 million USD by mid-2021. Subsequent quarters evidenced some recovery towards 1.07 billion USD by July 2023 but the overall tendency points to reduced capital investment or asset base contraction over time.
- Net Fixed Asset Turnover Ratio
- The net fixed asset turnover ratio reflects efficiency in utilizing fixed assets to generate sales and is available from February 2018 onward. This ratio shows a consistent upward trend, starting from 4.95 and progressing steadily to a peak of around 10.29 by April 2023. The increase in this ratio suggests improving asset utilization, indicating the company has been generating more sales per unit of fixed asset despite the reduction in the asset base itself. This is indicative of more effective and possibly leaner asset use contributing to profitability.
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)
| 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.05 | 2.09 | 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 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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.
- Net Sales
- Over the examined periods, net sales demonstrated substantial seasonal fluctuations with a recurring pattern of increased sales during the first quarter of each fiscal year followed by lower figures in the subsequent quarters. There is an evident upward long-term trend in net sales, with significant growth from approximately 1.3 billion to over 3.2 billion US dollars at the peak in early 2023. The data reveals sharp increases in early 2018, early 2019, early 2020, early 2021, and most notably in early 2023, reflecting strong quarterly demand possibly linked to seasonal factors such as holidays or shopping events. Some dip or slower growth periods are observed mid-year in most years, but overall, the growth trajectory remains positive and robust.
- Property and Equipment, Net (Including Operating Lease, Right-of-Use Asset)
- The value of property and equipment steadily increased from around 1.02 billion in early 2017 to a peak exceeding 2.7 billion by early 2019, nearly doubling during this period. After this peak, the asset base contracted somewhat, declining gradually to about 2.4 billion by late 2021. Thereafter, it resumed growth, reaching approximately 2.6 billion by mid-2023. This pattern suggests initial heavy investment in fixed assets, followed by a period of consolidation or reduced capital expenditure, before resuming moderate asset growth again. The initial large jump around early 2019 might reflect acquisitions, expansion in store footprint, or adoption of leasing assets under new accounting standards.
- Net Fixed Asset Turnover (Including Operating Lease, Right-of-Use Asset)
- Starting data for fixed asset turnover is missing until early 2018, where the ratio was around 4.95. This ratio increased slightly reaching 5.48 by late 2018, indicating efficient utilization of fixed assets to generate sales during this phase. Subsequently, there is a notable decline in the ratio to approximately 2.5–2.7 throughout 2019 and 2020, coinciding with the period when property and equipment values were very high and net sales, although growing, did not keep pace proportionally. Post-2020, the turnover ratio steadily improved from 2.43 to over 4.0 by mid-2023, signaling enhanced asset efficiency. This improvement corresponds with the reduction in the asset base and robust sales growth, reflecting better management of assets or more revenue generated per dollar of fixed assets.
- Overall Insights
- The data indicates a company undergoing phases of significant capital investment followed by stabilization and optimization of asset use. The increasing trend in net sales, particularly strong in recent years, suggests positive market demand and effective sales strategies. The decline and subsequent recovery in fixed asset turnover mirror the changes in asset investment intensity and corresponding sales growth patterns. Notably, the improvement in asset turnover since 2020 points to enhanced operational efficiency. Seasonal fluctuations in net sales are recurrent and should be factored into forecasting and inventory management. The company's ability to grow sales substantially while managing asset base changes suggests a focus on scalable and efficient growth.
Total Asset Turnover
Ulta Beauty Inc., total asset turnover calculation (quarterly data)
| 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.11 | 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 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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.
The analysis of the quarterly financial data reveals several notable trends in net sales, total assets, and total asset turnover over the observed periods.
- Net Sales
- Net sales demonstrate a generally increasing trend across the quarters, with some fluctuations. Initial values remain relatively steady around 1.3 to 1.5 million US dollars (in thousands) between early 2017 and early 2018. There is a significant increase in the first quarter of 2018 to nearly 1.9 million, followed by some subsequent dips and rises. After a mid-2020 decline to around 1.2 million, net sales recover strongly, peaking at over 3.2 million in early 2023 before slightly declining again in mid-2023. This pattern suggests the company experienced some external or internal challenges around 2020 but managed to rebound decisively by 2023.
- Total Assets
- Total assets show a gradual increase from about 2.7 million US dollars (in thousands) in 2017 up to a peak exceeding 5.5 million in mid-2020. After this peak, assets stabilize around 5.0 to 5.3 million through 2021 to early 2023, with minor fluctuations. This steady growth until 2020, followed by stabilization, could indicate an expansion phase culminating in 2020, after which the company maintained a relatively stable asset base.
- Total Asset Turnover
- Total asset turnover ratios begin at approximately 2.0 in early 2018, reflecting efficient use of assets to generate sales. However, ratios decrease to a low of about 1.16 during mid-2020, corresponding with the dip in net sales and peak in total assets. From late 2020 onward, turnover improves consistently, reaching over 2.0 by mid-2023. This improvement highlights enhanced asset efficiency and better utilization of resources in driving revenue after the mid-2020 downturn.
Overall, the financial data indicates a period of asset accumulation and growth up to 2020, coupled with challenges affecting sales and asset turnover around mid-2020. Subsequently, the company exhibits recovery and stronger performance in asset utilization and sales generation through 2023, signaling improved operational effectiveness and resilience.
Equity Turnover
Ulta Beauty Inc., equity turnover calculation (quarterly data)
| 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.56 | 2.73 | 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 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
| 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 | — | — | — | — | — | — | — | — | — | — | — | ||||||||
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.
- Net Sales
- The net sales figures show a general upward trend over the analyzed periods, with seasonal fluctuations evident. Initial values around 1.3 million US dollars in early 2017 gradually increase, reaching peaks exceeding 3 million US dollars in early 2023. There is a notable surge starting in early 2018, with continued growth leading to strong increases particularly from early 2021 onward. Some dips are observed, such as during mid-2020, which may be attributed to external factors affecting sales performance temporarily. Overall, the trend indicates strengthening revenue generation activity over time.
- Stockholders’ Equity
- Stockholders' equity maintains a relatively stable range throughout the periods, beginning near 1.64 million US dollars in early 2017 and gradually rising with minor fluctuations to approximately 2.05 million US dollars by mid-2023. Despite some dips, the general pattern reflects incremental growth in equity, suggesting consistent reinvestment or retained earnings contributing to the company’s net worth. The variance in equity is more subdued compared to sales fluctuations, signaling stable capital structure management over time.
- Equity Turnover
- Equity turnover, available from early 2018 onward, exhibits a rising trend with some oscillations. Starting around 3.3, the ratio gradually increases, reaching above 5.0 in recent quarters and peaking at approximately 5.6 in early 2022. This upward trend indicates improving efficiency in generating sales from equity. The ratio portrays an enhanced capacity to utilize shareholder funds to drive revenue, with particularly strong performance noted post-2020, aligning with the surge observed in net sales.
- Summary
- The financial data portrays a company experiencing growth in revenue alongside stable growth in stockholders' equity. The increasing equity turnover reinforces the impression of enhanced operational efficiency. Together, these patterns suggest an improving financial position, with effective deployment of equity to increase sales. Fluctuations in sales across quarters are evident but do not hinder the general upward trajectory. The equity figures’ stability supports a sound balance sheet, while rising turnover ratios reflect positive developments in asset utilization and profitability potential.