This report updates the trailing-twelve-months (TTM) PEBV ratio for the S&P 500 and all sectors as of 11/14/23.
This report is a free, abridged version of S&P 500 & Sectors: Price-to-Economic Book Value Ratio Update for 3Q23, one of our quarterly series on fundamental market and sector trends. The full reports are available to our Professional and Institutional members or can be purchased below.
The full version of this report analyzes[1],[2] the trailing price-to-economic book value (PEBV) ratio for the S&P 500 and its sectors (last quarter’s analysis is here) over the last twenty years.
This report leverages our cutting-edge Robo-Analyst technology to deliver proven-superior[3] fundamental research and support more cost-effective fulfillment of the fiduciary duty of care.
S&P 500 Trailing PEBV Vs. Last Quarter
The trailing PEBV ratio compares the S&P 500’s expected future profits (as reflected in its price) to its economic book value as of 11/14/23. The S&P 500’s current PEBV ratio implies the profits (NOPAT) of its constituents will increase dramatically from the TTM ended 3Q23 NOPAT levels.
See Figure 1 in the full version of our report for the chart of the PEBV ratio for the S&P 500 and each of its sectors from December 2004 through 11/14/23.
Key Details on Select S&P 500 Sectors
Only one S&P 500 sector, Energy, trades below its economic book value. The Energy sector has the lowest trailing PEBV ratio among all eleven S&P 500 sectors based on prices as of 11/14/23 and financial data from 3Q23 10-Qs.
A trailing PEBV ratio of 0.8 means the market expects the Energy sector’s profits to decline 20% from TTM ended 3Q23 levels. On the flip side, investors expect the Real Estate and Utilities sectors (trailing PEBV ratios of 7.1 and 4.1) to improve profits more than any other S&P 500 sectors.
Below, we highlight the Real Estate sector which has the highest trailing PEBV ratio in 3Q23.
Sample Sector Analysis[4]: Real Estate: Trailing PEBV Ratio = 7.1
Figure 1 shows the trailing PEBV ratio for the Real Estate sector rose from 8/15/23 to 11/14/23.
Figure 1: Real Estate Trailing PEBV Ratio: December 2004 – 11/14/23
Sources: New Constructs, LLC and company filings.
The November 14, 2023 measurement period uses price data as of that date and incorporates the financial data from 3Q23 10-Qs, as this is the earliest date for which all the calendar 3Q23 10-Qs for the S&P 500 constituents were available.
Figure 2 compares the trends for market cap and economic book value for the Real Estate sector since 2004. We sum the individual S&P 500/sector constituent values for market cap and economic book value. We call this approach the “Aggregate” methodology, and it matches S&P Global’s (SPGI) methodology for these calculations.
Figure 2: Real Estate Market Cap & Economic Book Value: December 2004 – 11/14/23
Sources: New Constructs, LLC and company filings.
The November 14, 2023 measurement period uses price data as of that date and incorporates the financial data from 3Q23 10-Qs, as this is the earliest date for which all the calendar 3Q23 10-Qs for the S&P 500 constituents were available.
The Aggregate methodology provides a straightforward look at the entire S&P 500/sector, regardless of firm size or index weighting, and matches how S&P Global (SPGI) calculates metrics for the S&P 500.
For additional perspective, we compare the Aggregate method for trailing PEBV ratio with two other market-weighted methodologies: market-weighted metrics and market-weighted drivers. Each method has its pros and cons, which are detailed in the Appendix.
Figure 3 compares these three methods for calculating the Real Estate sector trailing PEBV ratio.
Figure 3: Real Estate Trailing PEBV Ratio Methodologies Compared: December 2004 – 11/14/23
Sources: New Constructs, LLC and company filings.
The November 14, 2023 measurement period uses price data as of that date and incorporates the financial data from 3Q23 10-Qs, as this is the earliest date for which all the calendar 3Q23 10-Qs for the S&P 500 constituents were available.
This article was originally published on November 29, 2023.
Disclosure: David Trainer, Kyle Guske II, Italo Mendonça, and Hakan Salt receive no compensation to write about any specific stock, style, or theme.
Questions on this report or others? Join our Society of Intelligent Investors and connect with us directly.
Appendix: Analyzing Trailing PEBV Ratio with Different Weighting Methodologies
We derive the metrics above by summing the individual S&P 500/sector constituent values for market cap and economic book value to calculate trailing PEBV ratio. We call this approach the “Aggregate” methodology.
The Aggregate methodology provides a straightforward look at the entire S&P 500/sector, regardless of firm size or index weighting, and matches how S&P Global (SPGI) calculates metrics for the S&P 500.
For additional perspective, we compare the Aggregate method for trailing PEBV ratio with two other market-weighted methodologies. These market-weighted methodologies add more value for ratios that do not include market values, e.g. ROIC and its drivers, but we include them here, nonetheless, for comparison:
- Market-weighted metrics – calculated by market-cap-weighting the trailing PEBV ratio for the individual companies relative to their sector or the overall S&P 500 in each period. Details:
- Company weight equals the company’s market cap divided by the market cap of the S&P 500 or its sector
- We multiply each company’s trailing PEBV ratio by its weight
- S&P 500/Sector trailing PEBV equals the sum of the weighted trailing PEBV ratios for all the companies in the S&P 500/sector
- Market-weighted drivers – calculated by market-cap-weighting the market cap and economic book value for the individual companies in each sector in each period. Details:
- Company weight equals the company’s market cap divided by the market cap of the S&P 500 or its sector
- We multiply each company’s market cap and economic book value by its weight
- We sum the weighted market cap and weighted economic book value for each company in the S&P 500/each sector to determine the S&P 500 or sector’s weighted FCF and weighted enterprise value
- S&P 500/Sector trailing PEBV ratio equals weighted S&P 500/sector market cap divided by weighted S&P 500/sector economic book value
Each methodology has its pros and cons, as outlined below:
Aggregate method
Pros:
- A straightforward look at the entire S&P 500/sector, regardless of company size or weighting.
- Matches how S&P Global calculates metrics for the S&P 500.
Cons:
- Vulnerable to impact of companies entering/exiting the group of companies, which could unduly affect aggregate values. Also susceptible to outliers in any one period.
Market-weighted metrics method
Pros:
- Accounts for a firm’s market cap relative to the S&P 500/sector and weights its metrics accordingly.
Cons:
- Vulnerable to outlier results from a single company disproportionately impacting the overall trailing PEBV ratio, as we’ll show below.
Market-weighted drivers method
Pros:
- Accounts for a firm’s market cap relative to the S&P 500/sector and weights its size and economic book value accordingly.
- Mitigates the disproportionate impact of outlier results from one company on the overall results.
Cons:
- More susceptible to large swings in market cap or economic book value (which can be impacted by changes in WACC) period over period, particularly from firms with a large weighting in the S&P 500/Sector.
[1] We calculate these metrics based on S&P Global’s (SPGI) methodology, which sums the individual S&P 500 constituent values for market cap and economic book value before using them to calculate the metrics. We call this the “Aggregate” methodology.
[2] Analysis in this report is based on the latest audited financial data available, or 3Q23 10-Qs in most cases. Price data for the current period is as of 11/14/23. QoQ analysis is based on the change since last quarter’s report.
[3] Our research utilizes our Core Earnings, a more reliable measure of profits, as proven in Core Earnings: New Data & Evidence, written by professors at Harvard Business School (HBS) & MIT Sloan and published in The Journal of Financial Economics.
[4] The full version of this report provides analysis for every sector like what we show for this sector.