The Rational Reminder Podcast

Episode 399: James Choi - Portfolio Theory in a Spreadsheet

60 snips
Mar 5, 2026
James Choi, Yale finance professor known for practical household finance research, presents a spreadsheet-based shortcut to classic lifecycle portfolio choice. He explains Merton’s formula, how human capital often acts bond-like, the roles of wealth and risk aversion, transitory versus permanent wage risk, and how simple rules like 100-minus-age compare to his approximation.
Ask episode
AI Snips
Chapters
Transcript
Episode notes
INSIGHT

Risky Labor Income Often Acts Like A Bond

  • Gomes et al. found risky labor income uncorrelated with stocks behaves bond-like in portfolio choice.
  • That made human capital act like a smaller bond, simplifying allocation intuition despite added mathematical complexity.
ADVICE

Approximate Human Capital With Discount Rates

  • Use discount rates applied to future labor income to approximate human capital value and then compute your Merton-adjusted equity share.
  • James et al. regressed discount rates on model parameters to create a spreadsheet-friendly approximation.
INSIGHT

Approximation Is Practically Optimal

  • Their approximation averaged a 3–4 percentage-point allocation deviation but produced <0.1% lifetime welfare loss versus the numerical optimum.
  • They validated by simulating a 22-year-old following approximate vs optimal rules across parameter sets.
Get the Snipd Podcast app to discover more snips from this episode
Get the app