Compute Target Percent Equity

How to use this calculator:

  1. Because the values of equities are volatile and can undergo large, long-lasting changes in value, predetermine the maximun percent of exposure of the portfolio to loss due to changes in value of equities (to preserve value) and the minimum percent (to take advantage of returns, i.e., dividends and rising value of equities). This should be done very infrequently. See notes below.
  2. Choose a model for projecting the "expected" value of the "Shiller PE10". See notes below.
  3. Periodically look up the "Shiller PE10" using the link below by the corresponding cell.
  4. For example, for a current PE10 of 31, a minimum projected exposure of 7%, and a maximum exposure of 15%:


Minimum % equity risk threshold:
Maximum % equity risk threshold:

16.32 (median for 1872-2020)
22.33 (trend for 1872-2020, projected to today)
Current PE10 from https://www.multpl.com/shiller-pe:


minimum percent equity: 14.79
maximum percent equity: 31.7

model_pe: 16.32
current_pe: 30.98
model: median
risk: 47.32%


Notes:

There is nothing mysterious about the calculations of minimum and maximum percent equity. Each is computed as:

    {percent equity} = ( {Current PE10} * {risk threshold percentage} ) / ( {Current PE10} - {Projected PE10} )
when
    100 * ( {Current PE10} - {Projected PE10} ) / ( {Current PE10} ) < {risk threshold percentage}
and
    {percent equity} = 100
otherwise.