Episode 399: James Choi - Portfolio Theory in a Spreadsheet - Rational Reminder Recap
Podcast: Rational Reminder
Published: 2026-03-05
Duration: 1 hr 14 min
Guests: James Choi
Summary
James Choi introduces a spreadsheet tool that simplifies the complex problem of lifecycle portfolio choice. By approximating dynamic optimization models, Choi offers a practical solution for determining optimal stock and bond allocations.
What Happened
James Choi, a finance professor at Yale, has developed a new spreadsheet-based tool to address the complex portfolio choice problem. This tool is based on his paper 'Practical Finance: An Approximate Solution to Lifecycle Portfolio Choice,' which simplifies the allocation between stocks and bonds, making the process accessible for individual investors.
The podcast delves into Robert Merton's 1971 solution to the portfolio choice problem, which involved risk-free labor income. Choi extends this model to include risky labor income, as explored by Cocco, Gomes, and Maenhout, demonstrating that labor income behaves bond-like even when risky.
Choi's approximation model closely matches numerical solutions, deviating by only 3-4 percentage points on average, with a lifetime welfare error of less than 0.1%. The model suggests that simple rules like '100 minus your age' can result in significant welfare losses, with a 22-year-old losing 2% lifetime welfare.
Optimal portfolios, according to Choi, are heavily weighted in stocks, often up to 100% during an individual's working life. Human capital is treated as a bond-like asset, allowing for higher equity allocations until retirement, when de-risking occurs.
Choi provides a Google Sheet that requires inputs such as risk aversion, age, savings, and expected market returns to calculate optimal allocations. The model excludes housing due to its complexity and suggests updating assumptions only once a year.
Leveraged ETFs are discussed as a viable option for younger investors, with historical data indicating that they have outperformed unlevered investments over 20 years. Choi suggests that leveraging might be rational for young investors due to their stable income and long investment horizon.
Finally, Choi hints at future research plans, including tackling the 4% withdrawal rule and optimizing retirement spending, indicating ongoing efforts to simplify complex financial decisions for everyday investors.
Key Insights
- James Choi's spreadsheet tool simplifies portfolio decisions by treating human capital as a bond-like asset, allowing individuals to invest heavily in stocks during their working life. This approach deviates from common advice like '100 minus your age', which could lead to significant welfare losses, especially for younger investors.
- Robert Merton's 1971 financial model assumed risk-free labor income, but Choi adapts it to include risky labor income, showing it still behaves bond-like. This insight changes how labor income is considered in investment strategy, impacting optimal portfolio allocation.
- Choi's model demonstrates that simple rules can be costly; a 22-year-old following '100 minus your age' might lose 2% in lifetime welfare. His approximation model aligns closely with complex numerical solutions, deviating by only 3-4 percentage points on average.
- Leveraged ETFs could be a rational choice for young investors, according to Choi, as historical data shows they outperform traditional investments over 20 years. With a stable income and long investment horizon, younger individuals can tolerate the additional risk.
Key Questions Answered
What is the James Choi portfolio tool?
James Choi's portfolio tool is a spreadsheet-based model designed to simplify the lifecycle portfolio choice problem. It approximates dynamic optimization models to help individuals determine optimal stock and bond allocations.
How does labor income affect portfolio choice?
Labor income is treated as a bond-like asset in Choi's model, even when risky. This allows individuals to allocate more to equities during their working life, adjusting as their human capital diminishes with age.
Should young investors consider leveraged ETFs?
Leveraged ETFs can be a rational choice for young investors due to their long investment horizon and stable income. Historical data shows these ETFs have outperformed unlevered investments, making them a viable option.