Valuation ratios measure the quantity of an asset or flaw (e.g., earnings) associated with ownership of a specified claim (e.g., a share of ownership of the enterprise).
Historical Valuation Ratios (Summary)
Based on: 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30).
Valuation ratio | Description | The company |
---|---|---|
P/E ratio | The P/E ratio tells analyst how much an investor in common stock pays per dollar of current earnings. | Estée Lauder Cos. Inc. P/E ratio increased from Q2 2023 to Q3 2023 but then decreased significantly from Q3 2023 to Q4 2023. |
P/OP ratio | Because P/E ratio is calculated using net income, the ratio can be sensitive to nonrecurring earnings and capital structure, analysts may use price to operating profit. | Estée Lauder Cos. Inc. P/OP ratio decreased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
P/S ratio | An rationale for the P/S ratio is that sales, as the top line in an income statement, are generally less subject to distortion or manipulation than other fundamentals such as EPS or book value. Sales are also more stable than earnings and never negative. | Estée Lauder Cos. Inc. P/S ratio decreased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
P/BV ratio | The P/BV ratio is interpreted as an indicator of market judgment about the relationship between a company required rate of return and its actual rate of return. | Estée Lauder Cos. Inc. P/BV ratio decreased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
Price to Earnings (P/E)
Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | 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 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
No. shares of common stock outstanding1 | 357,690,815 | 357,413,019 | 357,220,198 | 356,812,327 | 356,903,600 | 357,347,200 | 358,666,520 | 359,947,394 | 361,287,242 | 362,511,874 | 362,759,496 | 361,605,644 | 360,804,641 | 359,998,626 | 359,540,246 | 359,813,553 | 360,756,333 | 361,872,568 | 361,162,511 | 362,852,542 | 367,194,210 | 367,038,912 | 367,777,184 | 368,237,122 | |||||||
Selected Financial Data (US$) | |||||||||||||||||||||||||||||||
Net earnings (loss) attributable to The Estée Lauder Companies Inc. (in millions) | (33) | 156) | 394) | 489) | 52) | 558) | 1,088) | 692) | 1,018) | 456) | 873) | 523) | (462) | (6) | 557) | 595) | 157) | 555) | 573) | 500) | 186) | 372) | 123) | 427) | |||||||
Earnings per share (EPS)2 | 2.81 | 3.05 | 4.18 | 6.13 | 6.70 | 9.39 | 9.07 | 8.44 | 7.94 | 3.83 | 2.56 | 1.69 | 1.90 | 3.62 | 5.18 | 5.22 | 4.95 | 5.01 | 4.52 | 3.25 | 3.02 | 0.00 | 0.00 | 0.00 | |||||||
Share price1, 3 | 156.69 | 202.70 | 268.41 | 189.96 | 265.43 | 245.52 | 303.12 | 338.62 | 340.82 | 288.93 | 272.81 | 223.85 | 222.93 | 172.54 | 211.53 | 186.27 | 197.15 | 170.30 | 152.02 | 137.44 | 135.59 | 132.59 | 134.39 | 122.12 | |||||||
Valuation Ratio | |||||||||||||||||||||||||||||||
P/E ratio4 | 55.71 | 66.40 | 64.22 | 30.99 | 39.64 | 26.14 | 33.41 | 40.11 | 42.90 | 75.35 | 106.64 | 132.26 | 117.59 | 47.67 | 40.80 | 35.65 | 39.84 | 33.97 | 33.66 | 42.23 | 44.93 | — | — | — | |||||||
Benchmarks | |||||||||||||||||||||||||||||||
P/E Ratio, Competitors5 | |||||||||||||||||||||||||||||||
Procter & Gamble Co. | 25.47 | 26.20 | 24.00 | 21.49 | 23.91 | 27.43 | 27.29 | 24.55 | 24.46 | 24.20 | 23.92 | 26.27 | 25.85 | 63.19 | 67.79 | 75.63 | 78.69 | — | — | — | — | — | — | — |
Based on: 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30).
1 Data adjusted for splits and stock dividends.
2 Q4 2023 Calculation
EPS
= (Net earnings (loss) attributable to The Estée Lauder Companies Inc.Q4 2023
+ Net earnings (loss) attributable to The Estée Lauder Companies Inc.Q3 2023
+ Net earnings (loss) attributable to The Estée Lauder Companies Inc.Q2 2023
+ Net earnings (loss) attributable to The Estée Lauder Companies Inc.Q1 2023)
÷ No. shares of common stock outstanding
= (-33,000,000 + 156,000,000 + 394,000,000 + 489,000,000)
÷ 357,690,815 = 2.81
3 Closing price as at the filing date of Estée Lauder Cos. Inc. Quarterly or Annual Report.
4 Q4 2023 Calculation
P/E ratio = Share price ÷ EPS
= 156.69 ÷ 2.81 = 55.71
5 Click competitor name to see calculations.
Valuation ratio | Description | The company |
---|---|---|
P/E ratio | The P/E ratio tells analyst how much an investor in common stock pays per dollar of current earnings. | Estée Lauder Cos. Inc. P/E ratio increased from Q2 2023 to Q3 2023 but then decreased significantly from Q3 2023 to Q4 2023. |
Price to Operating Profit (P/OP)
Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | 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 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
No. shares of common stock outstanding1 | 357,690,815 | 357,413,019 | 357,220,198 | 356,812,327 | 356,903,600 | 357,347,200 | 358,666,520 | 359,947,394 | 361,287,242 | 362,511,874 | 362,759,496 | 361,605,644 | 360,804,641 | 359,998,626 | 359,540,246 | 359,813,553 | 360,756,333 | 361,872,568 | 361,162,511 | 362,852,542 | 367,194,210 | 367,038,912 | 367,777,184 | 368,237,122 | |||||||
Selected Financial Data (US$) | |||||||||||||||||||||||||||||||
Operating income (in millions) | (5) | 297) | 556) | 661) | 79) | 738) | 1,418) | 935) | 234) | 616) | 1,063) | 705) | (543) | 109) | 261) | 779) | 216) | 674) | 771) | 652) | 277) | 497) | 710) | 568) | |||||||
Operating profit per share2 | 4.22 | 4.46 | 5.69 | 8.12 | 8.88 | 9.30 | 8.93 | 7.91 | 7.25 | 5.08 | 3.68 | 1.47 | 1.68 | 3.79 | 5.37 | 6.78 | 6.41 | 6.56 | 6.08 | 5.89 | 5.59 | 0.00 | 0.00 | 0.00 | |||||||
Share price1, 3 | 156.69 | 202.70 | 268.41 | 189.96 | 265.43 | 245.52 | 303.12 | 338.62 | 340.82 | 288.93 | 272.81 | 223.85 | 222.93 | 172.54 | 211.53 | 186.27 | 197.15 | 170.30 | 152.02 | 137.44 | 135.59 | 132.59 | 134.39 | 122.12 | |||||||
Valuation Ratio | |||||||||||||||||||||||||||||||
P/OP ratio4 | 37.14 | 45.48 | 47.14 | 23.40 | 29.88 | 26.39 | 33.94 | 42.80 | 47.03 | 56.89 | 74.19 | 152.15 | 132.73 | 45.50 | 39.41 | 27.47 | 30.75 | 25.96 | 24.99 | 23.35 | 24.26 | — | — | — | |||||||
Benchmarks | |||||||||||||||||||||||||||||||
P/OP Ratio, Competitors5 | |||||||||||||||||||||||||||||||
Procter & Gamble Co. | 20.19 | 20.94 | 19.37 | 17.32 | 19.41 | 22.11 | 22.17 | 19.20 | 19.08 | 18.81 | 18.46 | 21.16 | 21.01 | 42.45 | 45.33 | 48.96 | 52.12 | — | — | — | — | — | — | — |
Based on: 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30).
1 Data adjusted for splits and stock dividends.
2 Q4 2023 Calculation
Operating profit per share
= (Operating incomeQ4 2023
+ Operating incomeQ3 2023
+ Operating incomeQ2 2023
+ Operating incomeQ1 2023)
÷ No. shares of common stock outstanding
= (-5,000,000 + 297,000,000 + 556,000,000 + 661,000,000)
÷ 357,690,815 = 4.22
3 Closing price as at the filing date of Estée Lauder Cos. Inc. Quarterly or Annual Report.
4 Q4 2023 Calculation
P/OP ratio = Share price ÷ Operating profit per share
= 156.69 ÷ 4.22 = 37.14
5 Click competitor name to see calculations.
Valuation ratio | Description | The company |
---|---|---|
P/OP ratio | Because P/E ratio is calculated using net income, the ratio can be sensitive to nonrecurring earnings and capital structure, analysts may use price to operating profit. | Estée Lauder Cos. Inc. P/OP ratio decreased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
Price to Sales (P/S)
Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | 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 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
No. shares of common stock outstanding1 | 357,690,815 | 357,413,019 | 357,220,198 | 356,812,327 | 356,903,600 | 357,347,200 | 358,666,520 | 359,947,394 | 361,287,242 | 362,511,874 | 362,759,496 | 361,605,644 | 360,804,641 | 359,998,626 | 359,540,246 | 359,813,553 | 360,756,333 | 361,872,568 | 361,162,511 | 362,852,542 | 367,194,210 | 367,038,912 | 367,777,184 | 368,237,122 | |||||||
Selected Financial Data (US$) | |||||||||||||||||||||||||||||||
Net sales (in millions) | 3,609) | 3,751) | 4,620) | 3,930) | 3,561) | 4,245) | 5,539) | 4,392) | 3,936) | 3,864) | 4,853) | 3,562) | 2,430) | 3,345) | 4,624) | 3,895) | 3,590) | 3,744) | 4,005) | 3,524) | 3,295) | 3,370) | 3,744) | 3,274) | |||||||
Sales per share2 | 44.48 | 44.38 | 45.79 | 48.41 | 49.70 | 50.68 | 49.44 | 47.35 | 44.88 | 40.58 | 39.12 | 38.61 | 39.62 | 42.93 | 44.09 | 42.34 | 41.20 | 40.26 | 39.30 | 38.40 | 37.26 | 0.00 | 0.00 | 0.00 | |||||||
Share price1, 3 | 156.69 | 202.70 | 268.41 | 189.96 | 265.43 | 245.52 | 303.12 | 338.62 | 340.82 | 288.93 | 272.81 | 223.85 | 222.93 | 172.54 | 211.53 | 186.27 | 197.15 | 170.30 | 152.02 | 137.44 | 135.59 | 132.59 | 134.39 | 122.12 | |||||||
Valuation Ratio | |||||||||||||||||||||||||||||||
P/S ratio4 | 3.52 | 4.57 | 5.86 | 3.92 | 5.34 | 4.84 | 6.13 | 7.15 | 7.59 | 7.12 | 6.97 | 5.80 | 5.63 | 4.02 | 4.80 | 4.40 | 4.79 | 4.23 | 3.87 | 3.58 | 3.64 | — | — | — | |||||||
Benchmarks | |||||||||||||||||||||||||||||||
P/S Ratio, Competitors5 | |||||||||||||||||||||||||||||||
Procter & Gamble Co. | 4.46 | 4.54 | 4.19 | 3.82 | 4.31 | 4.93 | 4.96 | 4.41 | 4.51 | 4.50 | 4.39 | 4.88 | 4.65 | 4.24 | 4.44 | 4.43 | 4.22 | — | — | — | — | — | — | — |
Based on: 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30).
1 Data adjusted for splits and stock dividends.
2 Q4 2023 Calculation
Sales per share
= (Net salesQ4 2023
+ Net salesQ3 2023
+ Net salesQ2 2023
+ Net salesQ1 2023)
÷ No. shares of common stock outstanding
= (3,609,000,000 + 3,751,000,000 + 4,620,000,000 + 3,930,000,000)
÷ 357,690,815 = 44.48
3 Closing price as at the filing date of Estée Lauder Cos. Inc. Quarterly or Annual Report.
4 Q4 2023 Calculation
P/S ratio = Share price ÷ Sales per share
= 156.69 ÷ 44.48 = 3.52
5 Click competitor name to see calculations.
Valuation ratio | Description | The company |
---|---|---|
P/S ratio | An rationale for the P/S ratio is that sales, as the top line in an income statement, are generally less subject to distortion or manipulation than other fundamentals such as EPS or book value. Sales are also more stable than earnings and never negative. | Estée Lauder Cos. Inc. P/S ratio decreased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |
Price to Book Value (P/BV)
Jun 30, 2023 | Mar 31, 2023 | Dec 31, 2022 | 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 | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
No. shares of common stock outstanding1 | 357,690,815 | 357,413,019 | 357,220,198 | 356,812,327 | 356,903,600 | 357,347,200 | 358,666,520 | 359,947,394 | 361,287,242 | 362,511,874 | 362,759,496 | 361,605,644 | 360,804,641 | 359,998,626 | 359,540,246 | 359,813,553 | 360,756,333 | 361,872,568 | 361,162,511 | 362,852,542 | 367,194,210 | 367,038,912 | 367,777,184 | 368,237,122 | |||||||
Selected Financial Data (US$) | |||||||||||||||||||||||||||||||
Stockholders’ equity, The Estée Lauder Companies Inc. (in millions) | 5,585) | 5,877) | 5,902) | 5,517) | 5,590) | 6,150) | 6,218) | 6,081) | 6,057) | 5,528) | 5,421) | 4,452) | 3,935) | 4,329) | 4,574) | 4,530) | 4,386) | 4,588) | 4,306) | 4,406) | 4,688) | 4,711) | 4,565) | 4,731) | |||||||
Book value per share (BVPS)2 | 15.61 | 16.44 | 16.52 | 15.46 | 15.66 | 17.21 | 17.34 | 16.89 | 16.77 | 15.25 | 14.94 | 12.31 | 10.91 | 12.03 | 12.72 | 12.59 | 12.16 | 12.68 | 11.92 | 12.14 | 12.77 | 12.84 | 12.41 | 12.85 | |||||||
Share price1, 3 | 156.69 | 202.70 | 268.41 | 189.96 | 265.43 | 245.52 | 303.12 | 338.62 | 340.82 | 288.93 | 272.81 | 223.85 | 222.93 | 172.54 | 211.53 | 186.27 | 197.15 | 170.30 | 152.02 | 137.44 | 135.59 | 132.59 | 134.39 | 122.12 | |||||||
Valuation Ratio | |||||||||||||||||||||||||||||||
P/BV ratio4 | 10.04 | 12.33 | 16.25 | 12.29 | 16.95 | 14.27 | 17.48 | 20.04 | 20.33 | 18.95 | 18.26 | 18.18 | 20.44 | 14.35 | 16.63 | 14.80 | 16.22 | 13.43 | 12.75 | 11.32 | 10.62 | 10.33 | 10.83 | 9.51 | |||||||
Benchmarks | |||||||||||||||||||||||||||||||
P/BV Ratio, Competitors5 | |||||||||||||||||||||||||||||||
Procter & Gamble Co. | 7.83 | 8.15 | 7.56 | 6.97 | 7.42 | 8.63 | 8.70 | 7.38 | 7.40 | 7.24 | 6.74 | 7.33 | 7.09 | 6.56 | 6.78 | 6.54 | 6.06 | 4.70 | 4.39 | 4.16 | — | — | — | — |
Based on: 10-K (reporting date: 2023-06-30), 10-Q (reporting date: 2023-03-31), 10-Q (reporting date: 2022-12-31), 10-Q (reporting date: 2022-09-30), 10-K (reporting date: 2022-06-30), 10-Q (reporting date: 2022-03-31), 10-Q (reporting date: 2021-12-31), 10-Q (reporting date: 2021-09-30), 10-K (reporting date: 2021-06-30), 10-Q (reporting date: 2021-03-31), 10-Q (reporting date: 2020-12-31), 10-Q (reporting date: 2020-09-30), 10-K (reporting date: 2020-06-30), 10-Q (reporting date: 2020-03-31), 10-Q (reporting date: 2019-12-31), 10-Q (reporting date: 2019-09-30), 10-K (reporting date: 2019-06-30), 10-Q (reporting date: 2019-03-31), 10-Q (reporting date: 2018-12-31), 10-Q (reporting date: 2018-09-30), 10-K (reporting date: 2018-06-30), 10-Q (reporting date: 2018-03-31), 10-Q (reporting date: 2017-12-31), 10-Q (reporting date: 2017-09-30).
1 Data adjusted for splits and stock dividends.
2 Q4 2023 Calculation
BVPS = Stockholders’ equity, The Estée Lauder Companies Inc. ÷ No. shares of common stock outstanding
= 5,585,000,000 ÷ 357,690,815 = 15.61
3 Closing price as at the filing date of Estée Lauder Cos. Inc. Quarterly or Annual Report.
4 Q4 2023 Calculation
P/BV ratio = Share price ÷ BVPS
= 156.69 ÷ 15.61 = 10.04
5 Click competitor name to see calculations.
Valuation ratio | Description | The company |
---|---|---|
P/BV ratio | The P/BV ratio is interpreted as an indicator of market judgment about the relationship between a company required rate of return and its actual rate of return. | Estée Lauder Cos. Inc. P/BV ratio decreased from Q2 2023 to Q3 2023 and from Q3 2023 to Q4 2023. |