Stock Analysis on Net
Stock Analysis on Net

O’Reilly Automotive Inc. (NASDAQ:ORLY)

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

Common-Size Balance Sheet: Assets 
Quarterly Data

O’Reilly Automotive Inc., common-size consolidated balance sheet: assets (quarterly data)

Microsoft Excel
Sep 30, 2022 Jun 30, 2022 Mar 31, 2022 Dec 31, 2021 Sep 30, 2021 Jun 30, 2021 Mar 31, 2021 Dec 31, 2020 Sep 30, 2020 Jun 30, 2020 Mar 31, 2020 Dec 31, 2019 Sep 30, 2019 Jun 30, 2019 Mar 31, 2019 Dec 31, 2018 Sep 30, 2018 Jun 30, 2018 Mar 31, 2018 Dec 31, 2017 Sep 30, 2017 Jun 30, 2017 Mar 31, 2017
Cash and cash equivalents 0.55 2.10 1.63 3.09 3.81 5.29 5.15 4.02 13.01 7.44 2.58 0.38 0.41 0.55 0.56 0.39 0.51 0.47 0.50 0.61 0.50 0.36 0.38
Accounts receivable, net 2.76 2.74 2.60 2.33 2.40 2.29 2.24 1.98 1.94 2.08 1.99 2.01 2.16 2.57 2.49 2.41 3.07 3.10 2.93 2.86 2.94 2.77 2.72
Amounts receivable from suppliers 1.11 1.02 0.84 0.97 0.94 0.95 0.97 0.87 0.72 0.74 0.75 0.74 0.73 0.76 0.66 0.98 1.05 1.02 1.02 1.01 1.06 0.84 0.99
Inventory 33.81 33.19 32.70 31.46 30.93 30.52 30.56 31.50 28.21 30.09 32.02 32.23 32.28 31.98 32.09 40.01 39.77 39.81 39.82 39.75 39.94 40.29 39.88
Other current assets 0.67 0.72 0.69 0.60 0.61 0.61 0.62 0.44 0.36 0.45 0.48 0.42 0.32 0.42 0.47 0.60 0.69 0.67 0.69 0.65 0.46 0.52 0.54
Current assets 38.90% 39.77% 38.46% 38.44% 38.70% 39.65% 39.56% 38.80% 44.25% 40.79% 37.82% 35.77% 35.91% 36.27% 36.27% 44.40% 45.09% 45.07% 44.95% 44.87% 44.90% 44.78% 44.50%
Property and equipment, at cost 59.58 59.34 59.92 59.29 58.31 56.64 56.12 56.57 51.96 54.60 56.84 57.77 58.36 57.69 57.26 70.74 69.82 69.33 69.03 68.56 68.39 68.55 68.51
Accumulated depreciation and amortization -24.09 -23.85 -23.89 -23.33 -22.67 -21.79 -21.42 -21.26 -19.39 -20.17 -20.76 -20.93 -21.04 -20.89 -20.72 -25.79 -25.47 -25.10 -24.82 -24.40 -24.36 -24.58 -24.44
Net property and equipment 35.49% 35.49% 36.02% 35.96% 35.64% 34.85% 34.71% 35.31% 32.57% 34.43% 36.09% 36.84% 37.32% 36.80% 36.54% 44.95% 44.36% 44.23% 44.21% 44.16% 44.02% 43.96% 44.07%
Operating lease, right-of-use assets 17.24 16.29 16.80 16.92 17.06 16.97 17.22 17.20 15.31 16.42 17.42 17.99 18.40 18.58 18.75 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Goodwill 7.20 7.30 7.50 7.50 7.45 7.37 7.42 7.60 6.99 7.44 8.19 8.74 7.79 7.92 8.04 10.12 10.00 10.16 10.29 10.42 10.53 10.71 10.91
Other assets, net 1.17 1.14 1.21 1.19 1.15 1.15 1.10 1.08 0.88 0.91 0.48 0.65 0.58 0.43 0.40 0.54 0.55 0.54 0.54 0.55 0.55 0.54 0.53
Noncurrent assets 61.10% 60.23% 61.54% 61.56% 61.30% 60.35% 60.44% 61.20% 55.75% 59.21% 62.18% 64.23% 64.09% 63.73% 63.73% 55.60% 54.91% 54.93% 55.05% 55.13% 55.10% 55.22% 55.50%
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%

Based on: 10-Q (reporting date: 2022-09-30), 10-Q (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-K (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-Q (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-K (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-Q (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-K (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-Q (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-K (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-Q (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-K (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30), 10-Q (reporting date: 2017-06-30), 10-Q (reporting date: 2017-03-31).

The analysis of the quarterly financial data reveals distinct trends and variations in the composition of assets over the observed periods.

Cash and Cash Equivalents
This category maintained a low proportion of total assets from 2017 through early 2019, generally below 1%. There was a significant upward spike in 2020 reaching a peak of 13.01% in September, likely reflecting increased liquidity management during that period. Subsequently, it declined sharply to around 3% by 2022.
Accounts Receivable, Net
Accounts receivable showed minor fluctuations but remained relatively stable, ranging between approximately 2% and 3% of total assets. There is a slight downward trend from 2017 through 2020, followed by a moderate increase towards 2022, indicating somewhat consistent credit extension to customers.
Amounts Receivable from Suppliers
This item exhibits modest variation around the 0.7% to 1.1% range. There is no pronounced trend, but values slightly increased toward 2022, potentially reflecting changes in supplier transactions or timing.
Inventory
Inventory consistently represented the largest portion of current assets, generally between 30% and 40% of total assets. Notably, there was a decrease from near 40% prior to 2019 to approximately 30% in 2020, followed by a gradual increase through 2022. This pattern may reflect inventory management adjustments or sales fluctuations during that time frame.
Other Current Assets
This component remained low, ranging around 0.3% to 0.7%, with slight increases observed post-2020. Overall, it is a minor contributor to total assets.
Current Assets
The total current assets as a percentage of total assets mirrored the inventory and cash trends, declining from around 45% in 2017-2018 to a low near 35% in late 2019, then rising sharply above 44% during 2020, before stabilizing near 39% in 2022. The sharp increase in 2020 aligns with the spike in cash and possibly inventory adjustments.
Property and Equipment, at Cost
This asset category maintained a substantial proportion of total assets, generally above 50%, but exhibited a declining trend from about 69% in 2017-2018 to near 52% in 2020, with recovery and stabilization close to 59% by 2022. This suggests changes in capital investment or asset composition during this period.
Accumulated Depreciation and Amortization
The accumulated depreciation increased gradually in absolute negative terms, indicating ongoing wear and consumption of fixed assets. The ratio relative to total assets decreased slightly from around -24% to just above -19% by 2020, then increased again towards -24% by 2022, corresponding with changes in the property and equipment base.
Net Property and Equipment
This net figure decreased from approximately 44% in 2017 to about 32.5% in 2020, followed by a recovery back to around 35% through 2022. The net property and equipment trend reflects both the cost and accumulated depreciation movements noted above.
Operating Lease, Right-of-Use Assets
Starting from 2019 data availability, this category consistently represented around 16% to 18.75% of total assets, with slight fluctuations. This indicates the recognition of lease assets and their material presence in the asset structure post-adoption of relevant accounting standards.
Goodwill
Goodwill as a percentage of total assets showed a gradual decline over the timeframe, dropping from nearly 11% in early 2017 to about 7% in 2022. This declining trend suggests possible impairments, write-downs, or acquisition pattern changes.
Other Assets, Net
Other assets remained a minor portion, fluctuating between 0.4% and 1.2%, and showing a mild increasing trend, particularly after 2019, possibly due to new asset recognition or reclassifications.
Noncurrent Assets
Noncurrent assets generally accounted for over half of total assets. Their proportion decreased from about 55% in 2017 to roughly 56% in 2020, then rose to approximately 61% by 2022. This trend indicates a shift towards greater noncurrent asset composition influenced by property, equipment, leases, and intangible assets changes.

In summary, the asset structure exhibited volatility around 2020, notably due to a sharp increase in cash holdings and changes in inventory and property assets. These shifts likely reflect strategic liquidity adjustments and operational adaptations during that period. Beyond 2020, the company appeared to stabilize its asset allocation, with a balanced proportion between current and noncurrent assets, moderate growth in receivables and inventory levels, and consistent recognition of lease assets. The gradual decline in goodwill warrants attention as it may impact long-term asset valuation.