The Rational Reminder Podcast
The Rational Reminder Podcast

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 Solutio

Featured Speakers

Benjamin Felix, Cameron Passmore, and Dan Bortolotti HostJames Choi Guest

Topics Discussed

Episode Summary

Executive Summary: Episode 399 features James Choi explaining a practical, spreadsheet-friendly approximation to lifecycle portfolio choice. The discussion shows how human capital, labor-income risk, wealth, risk aversion, and returns jointly determine stock/bond allocation, why risky labor income often behaves bond-like, and why the model can closely match numerical optima with very small welfare loss.

Main Topics: Lifecycle portfolio choice and the Merton framework (Priority: 5/5): Choi explains the classic stock/bond allocation problem and how Merton’s models treat human capital as part of total wealth when labor income is risk-free, producing an intuitive asset-allocation rule. Risky labor income and human capital (Priority: 5/5): The conversation centers on how uncorrelated labor-income risk makes human capital act more like a bond than a stock, while correlated income risk becomes more stock-like. Practical Finance approximation (Priority: 5/5): Choi and co-authors approximate the numerical lifecycle solution with simple discount-rate formulas and a spreadsheet, making the model usable for normal investors and advisors. Comparative statics: wealth, risk aversion, and income risk (Priority: 4/5): They discuss how higher current wealth lowers optimal equity exposure, higher risk aversion lowers equity exposure, and more permanent income risk warrants more caution than transitory income risk. Model accuracy versus common rules of thumb (Priority: 4/5): The paper compares the approximate solution with rules like 100-minus-age and constant 60/40, showing those heuristics are worse but not disastrous, while the approximation is very close to optimal. Spreadsheet implementation and practical inputs (Priority: 4/5): Choi walks through how listeners can estimate risk aversion, forecast income, handle retirement benefits, and use the spreadsheet to compute equity shares and human capital value. Extensions and open problems (Priority: 3/5): The discussion ends with housing, mortgage decisions, retirement withdrawal rules, and leverage ETFs as future practical-finance targets, highlighting the limitations of current models.

Key Arguments: Human capital should be incorporated into portfolio choice because future labor income is a major part of total lifetime wealth. When labor income risk is uncorrelated with stock returns, human capital behaves more like a bond; with correlation, it becomes partly stock-like. High current financial wealth relative to future earnings should reduce equity exposure because the bond-like human capital cushion is smaller. Permanent labor-income risk matters much more than transitory risk for optimal stock allocation. The discount rate does not directly change today’s portfolio choice; it mainly matters indirectly through its effect on saving/consumption and future liquidity. The paper’s approximation is highly accurate: average portfolio-share error is only a few percentage points and welfare loss is tiny. Common heuristics such as 100-minus-age or 60/40 are inferior to the model, but 100% equities is not always disastrous for moderately risk-tolerant households. For many young investors, the model still implies very high equity allocations because human capital is large relative to saved wealth. Housing is intentionally omitted because it is too hard to model cleanly; the practical workaround is to ignore home equity in investable net worth. Leverage can be rational for some young investors, and leveraged ETFs may be a more practical borrowing tool than margin loans because they avoid margin calls.

Data Points: Episode number: 399 - Rational Reminder episode discussed in the introduction. Approximation error: about 3–4 percentage points - Average deviation of approximate equity allocations from the numerical optimum across thousands of parameter sets. Welfare loss from approximation: less than 0.1% - Lifetime discounted utility loss when following the approximate strategy instead of the exact optimum. Welfare loss using 100-minus-age: 2% - Lifetime welfare loss as a 22-year-old versus the optimal strategy. Welfare loss using constant 60/40: 3.75% - Lifetime welfare loss versus the optimal strategy. Welfare loss using 0% equities: 7.9% - Lifetime welfare loss across all parameter sets versus the optimal strategy. Welfare loss using 100% equities: 11.8% - Lifetime welfare loss across all parameter sets versus the optimal strategy. Welfare loss at risk aversion 4 with 100% equities: 0.56% - Illustrates that 100% equities may be acceptable for moderately risk-averse investors. Welfare loss at risk aversion 10 with 100% equities: 30% - Shows how extremely risk-averse investors can be badly harmed by all-equity portfolios. Illustrative human capital value: $2.2 million - Spreadsheet example using assumed wages and retirement benefits. Illustrative no-human-capital equity share: 17% - Portfolio equity share if human capital were ignored in the example spreadsheet. Illustrative equity share with human capital: 91% - Recommended financial-portfolio equity share in the spreadsheet example. Alternative spreadsheet equity share: 89% - Using the wage-imputed tab in the example. Example risk aversion sensitivity: 4 → 100%, 6 → 70% - Changing risk aversion in the spreadsheet materially changes the recommended stock share. Leveraged fund borrowing spread: ~70 basis points above Treasuries - Choi notes leveraged ETFs can borrow at low spreads through equity swaps. Historical/illustrative VIX spike: 83 - Referenced as an extreme volatility period where he personally pulled back from 100% equities. Average human-capital/wealth comparison: three to six times saved wealth - Example used to explain why young investors can often tolerate stock losses.

Pivotal Quotes: "Practical Finance: An Approximate Solution to Lifecycle Portfolio Choice" — Benjamin Felix: Title of Choi’s paper that anchors the episode’s main theme. "human capital behaves like a bond" — James Choi: Core intuition behind why labor income changes optimal financial portfolio allocation. "The depressing truth is every paycheck I get. In some sense, I'm not getting any richer or poorer." — James Choi: Explanation of how wages are transformed from human capital into financial capital over time.

Implications: The episode argues investors should think in lifetime balance-sheet terms, not just portfolio terms. For many households, especially younger ones, human capital justifies far more equity than common rules suggest, but housing and retirement spending remain major open practical-finance problems.

🔓 Sign Up for Unlimited Episode Search

About The Rational Reminder Podcast

A weekly reality check on sensible investing and financial decision-making, from three Canadians. Hosted by Benjamin Felix, Cameron Passmore, and Dan Bortolotti, Portfolio Managers at PWL Capital.

View all episodes from The Rational Reminder Podcast