Episode 399: James Choi - Portfolio Theory in a Spreadsheet

In this episode, we welcome back James Choi, Professor of Finance at the Yale School of Management, to unpack one of the most important—and misunderstood—questions in personal finance: How much of your portfolio should be in stocks? Drawing on his new paper, Practical Finance: An Approximate Solution to Lifecycle Portfolio Choice, James walks us through the classic portfolio choice problem first solved by Robert C. Merton, later extended by Francisco Gomes and co-authors, and now made dramatically more usable through a spreadsheet-based approximation. We explore how risk aversion, wealth, labor income risk, and expected returns shape optimal asset allocation, why simple rules like "100 minus your age" aren't terrible but still costly, and how James and his co-authors managed to approximate a complex dynamic optimization model with an error of less than 0.1% in lifetime welfare.

 

Key Points From This Episode:

(0:04) Introduction and why this episode delivers on "mathy roots."

(1:10) James Choi's new paper: Making lifecycle portfolio choice solvable in a spreadsheet.

(5:15) The portfolio choice problem: How much should you allocate to stocks versus risk-free assets?

(6:09) The classic Merton (1969, 1971) solution and the "Merton share."

(8:00) The equity premium formula: Expected excess return ÷ (risk aversion × variance).

(11:20) Extending the model to risky labor income (Cocco, Gomes, and Maenhout).

(14:27) Why labor income behaves bond-like—even when it's risky.

(16:33) How wealth, risk aversion, and labor income characteristics affect optimal equity allocation.

(20:52) Transitory vs. permanent labor income risk—and why permanent risk matters more.

(23:04) Solving thousands of parameter sets to approximate optimal lifecycle allocations.

(27:09) How close is the approximation? ~3–4 percentage points on average, with