Celtics Reset 5-Year Cap Analysis

Date: 2026-05-17 Pre-memo: reports/trades/celtics_reset_5yr_cap_research_memo.md Engine: scripts/trades/model_celtics_reset_5yr_cap.py Inputs:

• data/trades/celtics_reset_salary_assumptions_2026_2031.csv
• data/trades/celtics_reset_cap_thresholds_2026_2031.csv Outputs:
• data/trades/celtics_reset_5yr_cap_scenarios.csv (5 scenarios × 5 seasons = 25 rows)
• data/trades/celtics_reset_5yr_player_salary_table.csv (340 player-season rows)

---

1. Executive verdict

The three-team reset does not materially change Boston's 2026-27 through 2028-29 cap usage. It substitutes one ~$58M player (Tatum) for a mix of Markkanen + Naz Reid + Ace + #2 rookie scale that totals roughly the same. The financial "savings" from the reset don't show up until 2029-30, when Lauri's contract ends, Naz's player option becomes binary, and Tatum's $71M PO is no longer on books.

The two-team Utah reset (keeping White) costs more, not less. Boston ends with bigger roster (keeps White) plus adds Lauri + Ace + #2 — net higher salary through 2028-29 because the trade removes only Tatum's $58M and adds back $77M+ in new contracts.

The Lauri + Kessler structure is the tightest. Three guaranteed contracts of $27M+ on top of Brown's supermax push Boston right to the first apron in 2026-27 ($1M cushion) and 2027-28 ($3M cushion). Very little room to add filler or use exceptions.

Status quo and three-team reset are essentially equivalent on cost through 2028-29. The decision should be made on basketball + future-pick value, not on cap savings.

The headline financial improvement from any reset materializes in 2029-30, when the Tatum supermax falls off. Status-quo Boston gets the same benefit (Tatum's PO is the contract that ends his books either way), but only if he opts in for 2029-30 at $71.4M.

---

2. Research memo summary

Multi-year salary data verified from cached Basketball-Reference HTML for Boston, Utah, and Minnesota (all retrieved 2026-05-17). 2026-27 cap thresholds verified from Spotrac. 2027-28 through 2030-31 cap thresholds are CBA-allowed 10% cap-growth projections — labeled.

Key assumption set (full memo at celtics_reset_5yr_cap_research_memo.md):

• All player options modeled as exercised (Tatum 2029-30, White 2028-29, Naz 2029-30).
• All team options modeled as exercised on cheap rookie scale deals (Ace, #2 pick, Gonzalez, Scheierman, Walsh).
• Brown 2029-30+ modeled at ~$67M Bird-max extension (speculative).
• 14 standard roster spots assumed each year. Open spots filled at minimum (~$2.4-2.9M projected).
• Markkanen ends 2028-29; not re-signed in model. Same for Hauser, Pritchard.

---

3. Cap / apron assumptions

Risk: actual cap may grow slower than 10% in any year. If so, apron headroom shown is overstated.

---

4. Status quo (Scenario 0) — 5-year outlook

Read: Boston stays out of apron territory for the next three years even with both supermaxes (Tatum + Brown), White, Hauser, Pritchard, and rookie minimums. They pay tax in 2027-28 and 2028-29 (modest). The 2029-30 drop is driven by White's contract ending and assumption Brown re-signs at a modest ~$67M (could be higher).

This is a stable, expensive-but-contending baseline. No financial pressure to move Tatum from a cap-perspective alone. Apron mechanics are NOT forcing a trade.

---

5. Three-team reset — 5-year outlook (Scenarios 1 & 2)

Both pick-rights (S1) and signed-pick (S2) execution produce identical 5-year cap pictures (the trade-year matching question doesn't affect downstream cap; once the rookie signs the salary counts either way).

Read: Cap usage is essentially identical to status quo through 2028-29. The 2029-30 jump is meaningful: Lauri ends, Naz still on books at $28.4M PO, rest of roster cheap. Boston has $131M of first-apron room — full cap-space flexibility for a free-agent run if desired.

The reset's cap benefit shows up in year 4 and year 5 only. Years 1-3 cost about the same. The trade should not be justified on Y1-Y3 cap improvement.

---

6. Two-team Utah reset (keeps White) — Scenario 3

Read: Two-team reset costs MORE than status quo through 2028-29. Why: trade replaces Tatum ($58M out) with Lauri ($46M) + Ace ($9.5M) + #2 ($13M) = $68.6M in. Net +$10M of salary added even before counting the kept White contract.

The reset doesn't save money — it shifts the contract mix from one star to three smaller players. White stays. Total commitments rise.

2029-30 onward is where the savings show: same as the three-team reset, all the new contracts roll off and Boston has cap room.

---

7. Lauri + Kessler comparison — Scenario 4

Read: The Lauri + Kessler structure is the most financially strained version. Boston is essentially AT the first apron in the trade year and the year after. One additional minimum signing on top of the modeled roster pushes Boston over the first apron and triggers all the apron restrictions. This structure has the least flexibility for in-season moves.

The Brown ($57M) + Lauri ($46M) + Kessler ($27M) + White ($30M) frontcourt-wing concentration is the financial weight. Plus #2 rookie ($13M) and Hauser ($11M) + Pritchard ($8M).

Conclusion: Lauri + Kessler trade leaves Boston with no in-season flexibility for 2026-27 or 2027-28.

---

8. Pick-rights vs signed-#2 timing

After year one, this distinction does not matter. Once the rookie signs, the $13M cap hit applies regardless of how the trade executed. The pick-rights vs signed mode only affects:

1. The matching math in the trade year itself (covered in prior reports).
2. Whether Boston triggers an expansion hard cap in the trade year.
3. The timing window for the trade execution (draft night vs post-rookie-signing).

Cap-wise from year 2 onward: identical outcomes.

---

9. Year-by-year apron / tax pressure

Across all scenarios:

The three-team reset is the least tax-restrictive scenario through 2027-28. Status quo and two-team reset both pay modest tax in 2027-28 and 2028-29. The Kessler scenario pays tax in 2026-27 AND 2027-28 with razor-thin first-apron cushions.

None of the scenarios trip the second apron in any year. None trigger the frozen-pick rule mechanism (which requires 2 of 4 consecutive seasons above second apron).

---

10. Flexibility gained / lost

What the three-team reset gains

• Tatum's $58-71M annual hit replaced by a mix of $46M (Lauri ends 2028-29) + $23-28M (Naz through 2029-30) + $9.5-12.6M (Ace TOs) + $13-18M (#2 TOs).
• After 2028-29: significant cap room ($131M of first-apron room in 2029-30).
• New trade-eligible mid-tier contracts (Naz, Lauri, Ace) — useful chips for future moves.
• Premium young assets on rookie-scale deals (Ace, #2 pick).

What it loses

• Tatum's superstar value (top-5 player when healthy).
• White's elite POA defense and locker-room captain role (three-team only).
• Boston's defensive identity. Naz Reid is not a rim protector; Lauri is not a stopper.
• Brand: losing Tatum + (potentially) White is the largest brand hit in this era.
• In-season trade flexibility through 2027-28 (especially in Scenario 4).

Net cap flexibility

• Marginal in years 1-3.
• Significant in years 4-5.
• The flexibility decision should be made on basketball value (Brown + new core) and future-pick capital, not on Y1-Y3 cap savings.

---

11. Basketball roster implications

Three-team reset post-trade starting 5 (likely):

• PG: Pritchard or Darryn Peterson (#2 pick)
• SG: AJ Dybantsa (#2 pick) or Hauser
• SF: Jaylen Brown (alpha)
• PF: Lauri Markkanen (star scoring 4)
• C: Naz Reid (offensive 5)

Bench: Ace Bailey, Scheierman, Gonzalez, Queta, Walsh, Garza, Williams, Harper.

• Offense: elite spacing (Lauri + Naz + Hauser + Brown). Top-5 offense potential.
• Defense: mediocre. Loses Tatum/White wing defense. Naz is not a rim anchor. Queta still has to play meaningful minutes for interior defense.
• Rookie upside: Peterson (if available) is a creation guard who could carry second-unit offense. Ace is a wing scoring bet.

Status quo starting 5:

• PG: Pritchard

• SG: White

• SF: Tatum

• PF: Brown

• C: Queta / mid-tier signing

• Offense: elite (Tatum + Brown + White).

• Defense: elite (White + Brown perimeter, Tatum length).

• Rim protection: still a gap (Queta is league-average rim protector).

• Risk: Tatum Achilles recovery is the unknown.

Lauri + Kessler reset starting 5:

• PG: Pritchard

• SG: White

• SF: Brown

• PF: Lauri Markkanen

• C: Walker Kessler

• Offense: Lauri/Brown/White is excellent. Kessler doesn't space.

• Defense: Kessler is elite rim protection. Lauri at 4 is okay. White + Brown perimeter elite.

• Cost: essentially zero in-season flexibility.

---

12. Risks and unknowns

1. 2027-28 onward cap is projected. Actual cap could grow slower than the 10% modeled. Headroom would shrink across all scenarios.
2. Brown's post-2028-29 extension is speculative. Could be much higher than $67M (35% max in 2029-30 would be ~$76.9M based on projected cap). Could also be lower if Brown is traded.
3. Naz Reid 2029-30 PO ($28.4M) is modeled as exercised. He may opt out and re-sign at a higher number, or take a different deal.
4. Tatum 2029-30 PO ($71.4M) is modeled as exercised in status quo. If he renegotiates earlier into a new max, the cap profile shifts.
5. #2 rookie-scale Y1 ($12.99M) is an estimate. The Spotrac chart was not retrievable.
6. Brown's projected extension is the biggest single financial swing variable in status quo. If he opts to leave or is traded, the model is wrong.
7. The roster filler estimates use minimum. If Boston signs via MLE or BAE in any year, the dollar value AND the hard-cap implications change.

---

13. Final recommendation

Cap analysis alone does not strongly differentiate between status quo and three-team reset for 2026-28. Boston pays modest tax in either case and stays under all aprons. The reset's financial benefit is 2029-30+.

The Lauri + Kessler structure is financially the worst — Boston ends right at the first apron with no room for in-season moves. Don't choose this on cap grounds.

The two-team Utah reset costs MORE than status quo through 2028-29 — same basketball cost (lose Tatum) but more salary on books (keep White and add Lauri + Ace + #2).

Recommendation by purpose:

Bottom line: do the three-team reset only if Boston is confident in (a) Tatum's recovery being uncertain enough to justify selling, (b) Brown's leadership being sufficient to anchor the rebuild, and (c) the future-pick package being substantial. The cap math supports it but doesn't demand it.

The cap math actively argues against the Lauri + Kessler structure — too strained.

The cap math actively argues against the two-team Utah keeping White — costs more without freeing flexibility.

The cap math is neutral between status quo and three-team reset. Basketball wisdom and future-pick capital make this decision.

---

14. RealGM paragraph

The 5-year cap model on Boston's projected 2026-27 through 2030-31 books is the lens that surprised me. The three-team Tatum + White out / Lauri + Naz + Ace + #2 in reset and the status quo cost almost the same money through 2028-29 — both stay under the first apron with single-digit-to-low-double-digit tax bills. The reset's real cap benefit doesn't show up until 2029-30, when Lauri ends, Naz hits his $28M player option, and Boston has $131M of first-apron room compared to status quo Boston still on Brown's projected extension and rookie scale. The two-team Utah reset keeping White is the worst of both worlds financially: same cost as the three-team for the next three years and a bigger roster (Lauri + Ace + #2 + retained White) than status quo. The Lauri + Kessler structure is the most financially strained version — Boston ends right at the first apron in 2026-27 with $1M of cushion. Cap math doesn't force any particular trade. It does argue against the Kessler version. Boston should make the Tatum decision on basketball value and future-pick capital, not on apron savings, because the apron savings don't show up until year 4. The strongest move financially over five years is the three-team reset because it shifts to mid-tier and rookie-scale contracts that roll off, leaving Boston with maximum cap room in 2029-30 to make their next move while Brown is still in his prime.

---

Direct answers to the questions

1. Does the three-team reset improve Boston's 5-year cap flexibility? Marginally in years 1-3 (~$1.7-2.0M less salary per year). Materially in years 4-5 (Boston has $131M of first-apron room in 2029-30 vs $103M in status quo).
2. Does it reduce tax/apron pressure? Modestly. Status quo pays tax in 2027-28 and 2028-29; three-team reset pays tax only in 2028-29. Three-team reset never trips first apron.
3. Does adding Lauri + Naz create a new expensive frontcourt problem? Lauri ends 2028-29 ($53.5M). Naz runs through 2029-30 PO ($28.4M). Combined they're under $80M for three years — manageable.
4. Does losing White materially improve future flexibility? White is on a 4y/$118M deal through 2028-29 PO. Losing him saves $30-35M per year through 2028-29. But the trade adds Lauri ($46M) and Naz ($23M+) which more than offset.
5. Does keeping White in the two-team Utah version make the cap tighter? Yes — Scenario 3 costs ~$5-8M more per year than status quo through 2028-29. Less flexibility.
6. How valuable is the #2 rookie-scale contract over five years? ~$59M total over four guaranteed/option years (~$13M, $14M, $14M, $18M). For a top-2 pick that's about half market value if the player is a starter. Excellent cap value.
7. Does Ace Bailey's rookie-scale contract meaningfully help? Yes — $31M total over four years (~$9.5M, $10M, $12.6M plus QO). Excellent cap value if Ace develops.
8. When do Brown, Lauri, Naz, Ace, Peterson, and Pritchard overlap financially? 2026-27 through 2028-29: Brown $57-65M + Lauri $46-54M + Naz $23-27M + Ace ~$10-13M + #2 ~$13-14M + Pritchard $7-8M = $156-181M for six players. Brown extension and Naz PO make 2029-30 a hinge year.
9. Does the reset create room for another move later? Yes — 2029-30 has $131M of first-apron room. Boston could pursue a max free agent.
10. Which scenario gives Boston the best balance of competitiveness and flexibility? Three-team reset has the best 2029-30 outlook. Status quo has the best 2026-28 ceiling.
11. Does the cap outlook support trading Tatum? Not strongly. The reset doesn't save money until 2029-30. Basketball reasons (Achilles risk, asset capture) must do the work.
12. Does the cap outlook support including White? No. White's trade adds Naz Reid's contract which roughly offsets White's. Cap-wise it's a wash; basketball-wise Naz doesn't replace White's defense.
13. Does the cap outlook argue for keeping White and avoiding the Naz three-team version? Cap-wise no significant preference. Basketball-wise yes (keep White's defense).
14. What is the biggest financial risk? Brown's post-2028-29 extension. If Brown re-signs at the projected $67M, Boston is fine. If Brown re-signs at $75-80M+ or demands an early extension at supermax-tier dollars, the 2029-30 cap room shrinks significantly. Secondary risk: 2027-28 actual cap if it grows slower than 10%.

---

Categorical labels

• "What the reset improves financially" — slight 2026-28 savings (~$1.7M/yr); meaningful 2029-30+ flexibility.
• "Rookie-scale upside" — Ace + #2 + Gonzalez + Scheierman delivers ~$130M of below-market value over five years if all develop.
• "Avoiding Tatum supermax years" — applies to 2029-30 PO ($71.4M) onward. Same effect achievable if Tatum opts in then is traded.
• "New asset flexibility" — Lauri, Naz, Ace become tradeable mid-tier chips.
• "Brown remains expensive" — $57-65M through 2028-29; potentially $67-77M+ after extension.
• "Lauri is expensive" — $46-54M through 2028-29. Front-loaded but manageable.
• "Naz is not cheap" — $23-28M through 2029-30. Mid-tier max.
• "Losing White may create basketball cost greater than cap benefit" — confirmed; cap-neutral, basketball-negative.
• "Reset may still live near tax/apron depending on roster filling" — yes, all scenarios pay tax in at least one year.
• "Rookie-scale value only matters if Peterson/Ace hit" — confirmed; if they bust, the cap savings vanish into replacement-level fillers anyway.

Final recommendation: Prefer the three-team reset only with strong future-pick package. Otherwise prefer status quo. Avoid Lauri + Kessler. Don't keep White if doing the Utah reset.