
Estimating Q3 Earnings
I know it's a little early to be posting about Q3 but I've had some time to spare and seeing as the market is fairly awful right now I thought some of my findings could cheer people up. Buckle up because this is going to be both long and technical...
Last earnings season I posted my estimate for Q2 and ended up being pretty close to the mark. I jokingly attributed this to LBT reliably sandbagging his top line guidance by $1.5B each quarter however I actually came up with the figure by looking through Intels balance sheets.
Lucky for us Intel provides an extremely rich set of data for their quarterly earnings. Specifically for their reported inventories where they show the value of materials at each step of their manufacturing process, this being; Raw Materials, Work In Process, and Finished Goods.
I realised there's a reasonably strong fit when plotting Work in Process for a given quarter vs Manufacturing Output when adjusting for a quarterly lag. I define manufacturing output of a given quarter as the Cost of Goods Sold (adjusted to remove any GAAP charges) + the delta of Finished Goods.
Manufacturing Output = Adjusted COGS + Δ Finished Goods
Conceptually this makes a lot of sense as complex EUV chips that also require packaging can take almost two full quarters manufacture. I ran this system on pre 2013 data and found the lag was closer to 1 quarter which also makes sense in the simpler DUV era which was paired with lower inventories.
Below are two models comparing the system with a 1.5 and 1.7 quarter lag and result in a R^2 of around 0.4. Note a full 2 quarter lag also produces an ok fit.
Ok so what do we do with all of this?
You can see from the data below Intel posted two consecutive large jumps in WIP in Q4 2025 and Q1 2026 just as the comms around the server chip shortage was getting started. We also all know that Intel crushed their Q2 numbers. According to my hypothesis and model, that Q2 beat should have mostly been off the back of the Q4 2025 WIP ramp up and in Q3 2026 we should see the larger Q1 2026 ramp play out.
So how can we calculate Q3 you ask?
Plugging the WIP values into our Q3 estimate you get
Q3 WIP Signal
= 70% × Q1 WIP growth
+ 30% × Q2 WIP growth
= 0.70 × 14.85%
+ 0.30 × (-3.54%)
= 9.33%
Establish the Q2 manufacturing-output base
Q2 reported:
- COGS = $9.619B
- Q1 finished goods = $2.504B
- Q2 finished goods = $2.761B
​
Q2 Manufacturing Output
= Q2 COGS + change in Finished Goods
= $9.619B + $0.257B
= $9.876B
Calculate Q3 manufacturing output
Apply the predicted +7.94%:
Q3 Manufacturing Output
= $9.876B × 1.0794
= $10.660B
Convert COGS to revenue
Now we apply gross margin separately.
At 42% gross margin (Q2 Non-GAAP was 41.8%):
Revenue=1−0.41COGS=0.59COGS
$10.660B / 0.58
= $18.38B
Note I also calcualted the bounds but removed it from the steps above to make this post at least somewhat intelligible
-1 SD: $9.982B / 0.58 = $17.21B
+1 SD: $11.338B / 0.58 = $19.55B
So this gives us a Q3 revenue estimate of $18.38B, which once again beautifully fits into my LBT sandbagging guidance model:
LBT Q3 guidance between $15.8 billion and $16.8 billion
$16.8B + $1.5B = $18.3
Obviously the error bounds are large here so take it with a heap of salt and as always this is just my musings and certainly not #Financial Advice
I also modelled what this would mean for Q3 CPU Server marketshare. Depending if this kind of post gets any traction I'll do a follow up with those figures.
Intel reported quarter-end inventory balances:
| Quarter | Work in Process | Finished Goods | WIP + Finished Goods | WIP QoQ |
|---|---:|---:|---:|---:|
| Q1 2023 | $7,415m | $4,220m | $11,635m | — |
| Q2 2023 | $6,638m | $4,062m | $10,700m | -10.5% |
| Q3 2023 | $6,266m | $3,922m | $10,188m | -5.6% |
| Q4 2023 | $6,203m | $3,758m | $9,961m | -1.0% |
| Q1 2024 | $6,560m | $3,725m | $10,285m | +5.8% |
| Q2 2024 | $6,294m | $3,666m | $9,960m | -4.1% |
| Q3 2024 | $6,971m | $3,657m | $10,628m | +10.8% |
| Q4 2024 | $7,432m | $3,422m | $10,854m | +6.6% |
| Q1 2025 | $7,240m | $3,719m | $10,959m | -2.6% |
| Q2 2025 | $6,484m | $3,699m | $10,183m | -10.4% |
| Q3 2025 | $6,751m | $3,603m | $10,354m | +4.1% |
| Q4 2025 | $7,840m | $2,785m | $10,625m | +16.1% |
| Q1 2026 | $9,004m | $2,504m | $11,508m | +14.8% |
| Q2 2026 | $8,685m | $2,761m | $11,446m | -3.5% |