Hi, Shrewd!        Login  
Shrewd'm.com 
A merry & shrewd investing community
Best Of MIBest OfAll BoardsThe Shrewd’m WeeklyLearn to InvestHow to Become Shrewd
Search
Shrewd'm.com Merry shrewd investors
Search
Best Of MIBest OfAll BoardsThe Shrewd’m WeeklyLearn to InvestHow to Become Shrewd


The week's question
In December 2024, in the thread "Re: BRK: Why Not XOM?", BreckHutHigh asked the members: "What about the long road trips with kids?" This week it is put to everyone again. The button below opens the small thread re-asking it - read what others have said so far, then give your own answer as an ordinary reply.
Answer this questionContinue to Shrewd'mThis note won't appear again
Investment Strategies / Mechanical Investing
Unthreaded | Threaded | Whole Thread (8) |
Author: mungofitch 🐝🐝🐝 GOLD
SHREWD
  😊 😞

Number: of 6131 
Subject: Re: Valuing QQQE
Date: 08/25/25 3:19 PM
Post New | Post Reply | Report Post | Recommend It!
No. of Recommendations: 17
The method goes like this:

Since the QQQE fund is equally weighted, the median earnings yield among those stocks is basically the same as the average, except in the case that there is a very wild outlier, in which case you want to ignore that...so use the median.

So I calculated the median earnings yield among the 100 Nas100 stocks for every day in the last 30-or-so years.
Multiplying by the price-only index level for the equal weight index in the same stretch, that gives you the index's earnings level for each day. Adjust that data series for inflation. Other than transient dips in recessions, the real earnings figures form an astoundingly straight line.

Fit a trend line through that to get a formula for the "normal real earnings for today". Given that, and today's equal weight index level, you get an idea of what the "on trend" earnings yield is today.
Compare that to the historical average earnings yield, and you get an idea of today's over- or under-valuation.

Last time I updated that calculation was a while ago, October 2023. I estimated value of QQQE at around $62-72 if it were trading at the "usual" multiple of on-trend earnings. That earnings figure rises with inflation (5.2% since then), and with time as the trend real earnings level is expected to rise (around inflation+8%/year). Combined, that would push the estimated fair value up around 21% to maybe $75-87 today. With QQQE at $98.16 now, it seems to be 12-30% more overvalued than historically typical. Best guess maybe 24% higher than usual / usual valuation level today $64.

I did that really quickly, so don't bet the rent on its precision.

Bottom line: unsurprisingly, QQQE certainly does not appear to be cheaper than usual today. But if the trend of earnings holds up in future years, it's not nearly as overvalued as the S&P 500 is (equal weight or not) using the same sort of logic.

Jim
Post New | Post Reply | Report Post | Recommend It!
Print the post
Members reply directly to mungofitch here — and replies get answered. Reading is free; so is joining the conversation. Join Shrewd'm »
This community has written 6,115 posts about Mechanical Investing. The article-length ones it recommended most:
Dividend investing · 52 recs · 2025
Non-Mag7 screen · 34 recs · 2025
OT - Div yields and returns · 32 recs · 2024
Using AI to generate backtesting programs · 30 recs · 2025
Rankings for 19Dec2022 · 29 recs · 2022
Unthreaded | Threaded | Whole Thread (8) |


Announcements
Mechanical Investing FAQ
Contact Shrewd'm
Contact the developer of these message boards.

Best Of MI | Best Of | Favourites & Replies | All Boards | Followed Shrewds | Open Questions | Moving a community