Morningstar - Q2 2023 - 51

EXHIBIT 1
Equations Discussed in Life Annuities and The 7 Most Important Equations Quant U will focus on the shaded concepts
and equations.
Equation Solves For
How Long Will a Nest Egg Last?
Biological Mortality Rate
Survival Probabilities
Benjamin Gompertz's Law of Mortality
Basic Annuity Pricing Formula
Gompertz's Annuity Pricing Model
Duration and Interest Rate Sensitivity of a Life Annuity
Money's Worth Ratio of a Life Annuity
The Implied Longevity Yield
Lifetime Ruin Probability from Self-Annuitizing
Lifetime Ruin Probability
Payout of an Immediate Variable Annuity
Cost of a Tontine
Value of a Financial Legacy
Proper Spending Rate
Stocks vs. Cash Allocation
Source: Author.
t =
r�
r� = ln(1 + r)
Hence, as expected, to make a nest egg last longer,
you need to lower your withdrawal rate, obtain a
higher rate of return, or both.
The main limitation of this equation is that it
assumes a constant rate of return, which
is highly unlikely to be available. A more realistic
approach is to model each period's rate of
return as a random variable. I will discuss this
approach in a future issue of Quant U.
Benjamin Gompertz's Law of Mortality
This equation is so important that Milevsky
discusses it in both books (as Equation 2
in The 7 Most Important Equations and Equation 3
in Life Annuities).
In fact, I have considered it important for a long
time now, having already discussed it in
Quant U about eight years ago ( " When Will I Go? "
February/March 2015), based on Chapter 2 of
The 7 Most Important Equations.
While my notation differs a bit from Milevsky's, it
conveys the same relationship. I write the
Benjamin Gompertz Law of Mortality as follows:
t =
1
r�
ln
c
c - Wr
q(t; a, m, b) = exp 1 - exp
q( ; a, m, b) =
t
b
exp
a - m
b
The left-hand side of this equation is the
probability that a person of age a will live for at
least t more years, given the following parameters:
q(t; a, m, b) =
q(t; a, m, b) - q( ; a, m, b)
1 - q( ; a, m, b)
m = the mode of the distribution of the
age of death.
p(t; a, m, b) = q(t-1; a, m, b) -
T
LE (a, m, b) = a + t
t =1
∑
b = the dispersion of the age of death
around the mode.
p(t; a, m, b)
q(t; a, m, b)
The b parameter is like the standard deviation
parameter of a normal distribution.
LE (a, m + m, b) =
At Morningstar, we frequently use the
Gompertz formula to model longevity. We use
Parameter
m
b
Males
88.0
10.6
o
Females
91.0
8.9
The beauty of the Gompertz formula is that it
gives a very accurate estimate of a person's
probability of survival with only two parameters,
thus making it easy to customize. To model
the probability of survival of a person whose life
expectancy differs from the average life
expectancy for their sex, we just need to adjust
the m parameter, as I demonstrate below.
The Truncated Gompertz Formula
The Gompertz formula will give a survival
probability for any non-negative value of t, with
the value of q(t;a,m,b) decreasing as t increases
and tending toward 0. In practice, we need
morningstar.com/products/magazine
51
the following default values for m and b for males
and females generically:
Life Annuities
-
Equation 1
Equation 2
Equation 3
Equation 4
Equation 5
Equations 6, 7
Equation 8
Equation 9
Equation 10
-
The 7 Most Important
Equations
Equation 1
-
-
Equation 2
Equation 3
-
-
-
-
-
Equation 7
Equations 11a, 11b -
Equation 12b
-
-
-
1 -
ln
c
c - Wr�
Equation 6
Equation 4
Equation 5
Originators
Leonardo Fibonacci (1170-1250)
Not Indicated
Not Indicated
Benjamin Gompertz (1779-1865),
William Makeham (1826-1891)
Edmond Halley (1656-1742)
Moshe A. Milevsky
Moshe A. Milevsky
Not Indicated
Moshe A. Milevsky
Not Indicated
Andrei N. Kolmogorov (1903-1987)
Not Indicated
Moshe A. Milevsky
Solomon S. Huebner (1882-1964)
Irving Fisher (1867-1947), Menahem Yaari (b. 1935)
Paul Samuelson (1915-2009)
http://www.morningstar.com/products/magazine

Morningstar - Q2 2023

Table of Contents for the Digital Edition of Morningstar - Q2 2023

Contents
Morningstar - Q2 2023 - Cover1
Morningstar - Q2 2023 - Cover2
Morningstar - Q2 2023 - Contents
Morningstar - Q2 2023 - 2
Morningstar - Q2 2023 - 3
Morningstar - Q2 2023 - 4
Morningstar - Q2 2023 - 5
Morningstar - Q2 2023 - 6
Morningstar - Q2 2023 - 7
Morningstar - Q2 2023 - 8
Morningstar - Q2 2023 - 9
Morningstar - Q2 2023 - 10
Morningstar - Q2 2023 - 11
Morningstar - Q2 2023 - 12
Morningstar - Q2 2023 - 13
Morningstar - Q2 2023 - 14
Morningstar - Q2 2023 - 15
Morningstar - Q2 2023 - 16
Morningstar - Q2 2023 - 17
Morningstar - Q2 2023 - 18
Morningstar - Q2 2023 - 19
Morningstar - Q2 2023 - 20
Morningstar - Q2 2023 - 21
Morningstar - Q2 2023 - 22
Morningstar - Q2 2023 - 23
Morningstar - Q2 2023 - 24
Morningstar - Q2 2023 - 25
Morningstar - Q2 2023 - 26
Morningstar - Q2 2023 - 27
Morningstar - Q2 2023 - 28
Morningstar - Q2 2023 - 29
Morningstar - Q2 2023 - 30
Morningstar - Q2 2023 - 31
Morningstar - Q2 2023 - 32
Morningstar - Q2 2023 - 33
Morningstar - Q2 2023 - 34
Morningstar - Q2 2023 - 35
Morningstar - Q2 2023 - 36
Morningstar - Q2 2023 - 37
Morningstar - Q2 2023 - 38
Morningstar - Q2 2023 - 39
Morningstar - Q2 2023 - 40
Morningstar - Q2 2023 - 41
Morningstar - Q2 2023 - 42
Morningstar - Q2 2023 - 43
Morningstar - Q2 2023 - 44
Morningstar - Q2 2023 - 45
Morningstar - Q2 2023 - 46
Morningstar - Q2 2023 - 47
Morningstar - Q2 2023 - 48
Morningstar - Q2 2023 - 49
Morningstar - Q2 2023 - 50
Morningstar - Q2 2023 - 51
Morningstar - Q2 2023 - 52
Morningstar - Q2 2023 - 53
Morningstar - Q2 2023 - 54
Morningstar - Q2 2023 - 55
Morningstar - Q2 2023 - 56
Morningstar - Q2 2023 - 57
Morningstar - Q2 2023 - 58
Morningstar - Q2 2023 - 59
Morningstar - Q2 2023 - 60
Morningstar - Q2 2023 - 61
Morningstar - Q2 2023 - 62
Morningstar - Q2 2023 - 63
Morningstar - Q2 2023 - 64
Morningstar - Q2 2023 - 65
Morningstar - Q2 2023 - 66
Morningstar - Q2 2023 - 67
Morningstar - Q2 2023 - 68
Morningstar - Q2 2023 - 69
Morningstar - Q2 2023 - 70
Morningstar - Q2 2023 - 71
Morningstar - Q2 2023 - 72
Morningstar - Q2 2023 - 73
Morningstar - Q2 2023 - 74
Morningstar - Q2 2023 - 75
Morningstar - Q2 2023 - 76
Morningstar - Q2 2023 - 77
Morningstar - Q2 2023 - 78
Morningstar - Q2 2023 - 79
Morningstar - Q2 2023 - 80
Morningstar - Q2 2023 - Cover3
Morningstar - Q2 2023 - Cover4
https://www.nxtbook.com/nxtbooks/morningstar/magazine_2024q1
https://www.nxtbook.com/nxtbooks/morningstar/magazine_2023q4
https://www.nxtbook.com/nxtbooks/morningstar/magazine_2023q3
https://www.nxtbook.com/nxtbooks/morningstar/magazine_2023q2
https://www.nxtbook.com/nxtbooks/morningstar/magazine_2023q1
https://www.nxtbook.com/nxtbooks/morningstar/magazine_2022q4
https://www.nxtbook.com/nxtbooks/morningstar/magazine_2022q3
https://www.nxtbook.com/nxtbooks/morningstar/magazine_2022q2
https://www.nxtbook.com/nxtbooks/morningstar/magazine_2022q1
https://www.nxtbook.com/nxtbooks/morningstar/magazine_2021q4
https://www.nxtbook.com/nxtbooks/morningstar/magazine_2021q3
https://www.nxtbook.com/nxtbooks/morningstar/magazine_2021q2
https://www.nxtbook.com/nxtbooks/morningstar/magazine_2021q1
https://www.nxtbook.com/nxtbooks/morningstar/magazine_2020q4
https://www.nxtbook.com/nxtbooks/morningstar/magazine_2020q3
https://www.nxtbook.com/nxtbooks/morningstar/magazine_2020q2
https://www.nxtbook.com/nxtbooks/morningstar/magazine_2020q1
https://www.nxtbook.com/nxtbooks/morningstar/magazine_2019winter
https://www.nxtbook.com/nxtbooks/morningstar/magazine_2019fall
https://www.nxtbook.com/nxtbooks/morningstar/magazine_2019summer
https://www.nxtbook.com/nxtbooks/morningstar/magazine_2019spring
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20191201
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20181011
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20180809
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20180607
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20180405
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20180203
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20181201
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20171011
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20170809
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20170607
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20170405
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20170203
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20171201
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20161011
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20160809
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20160607
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20160405
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20160203
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20161201
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20151011
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20150809
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20150607
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20150405
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20150203
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20151201
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20141011
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20140809
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20140607
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20140405
https://www.nxtbook.com/nxtbooks/morningstar/magazine_20140203
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20141201
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20131011
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20130809
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20130607
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20130405
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20130203
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20131201
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20121011
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20120809
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20120607
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20120405
https://www.nxtbook.com/nxtbooks/morningstar/investorconference2012
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20120203
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20121201
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20111011
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20110809
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20110607
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20110405
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20110203
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20111201
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20101011
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20100809_lincoln
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20100809
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20100607_lincoln
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20100607
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20100405_lincoln
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20100405
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20100203
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20101201
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20091011
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20090809
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20090607
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20090405
https://www.nxtbook.com/nxtbooks/morningstar/advisor_20090203
https://www.nxtbook.com/nxtbooks/morningstar/advisor_2008fall
https://www.nxtbook.com/nxtbooks/morningstar/advisor_2008summer
https://www.nxtbook.com/nxtbooks/morningstar/advisor_2007spring
https://www.nxtbook.com/nxtbooks/morningstar/advisor_2007fall
https://www.nxtbook.com/nxtbooks/morningstar/advisor_2007summer
https://www.nxtbook.com/nxtbooks/morningstar/advisor_2008spring
https://www.nxtbook.com/nxtbooks/morningstar/advisor_2008catalog
https://www.nxtbook.com/nxtbooks/morningstar/advisor_2008winter
https://www.nxtbookmedia.com