In Sunday’s Getting Paid To Flip Million Dollar Coins, I mentioned that exponential functions such as investment compounding are best displayed on a semi-log chart. Let’s do another example of that step-by-step for anyone that wants to learn or anyone who has struggled to teach it to someone else.
Suppose your wealth grows according to this compounding formula:
Wealth = a(1+r)ᵗ
where:
a = starting wealth
r= compounding rate (ie 10%)
t = time in years
For our examples we just use a = 1, so our charts are “growth of a dollar”.
For rule of 72 fans, you know that at a 10% growth rate wealth doubles every 7 years.
Wealth = (1.10)⁷ = 1.95
If you started with $10,000 after 30 years you’d have about $175k.
This chart is not necessarily hard on the eyes, but the fact that time is the exponential variable is a clue that over long stretches an exponential chart is going to become low resolution.
Here’s a 90 cumulative return history for the SP500
2 observations:
Here’s the log chart:
The log chart now shows the resolution of zigs and zags in the early years by making the Y-axis distance between wealth levels of 10 and100 the same as 100 to 1,000 or 1,000 to 10,000.
To create our own log chart, we transform the wealth function:
Wealth = a(1+r)ᵗ
Log(Wealth) = Log(a) + Log(1+r)ᵗ
Log(Wealth) = Log(a) + t * Log(1+r)
This fits the form of a line:
Y = b + mX
Set “starting wealth” to a = $1.
That reduces the equation to:
Log(Wealth) = t * Log(1+r)
t, time, is our independent variable and Log(1+r) is a constant slope that depends on the rate of return.
Rule of 72 enjoyyyers know compounding at 10% for 7 years doubles wealth:
Wealth = (1.10)⁷ = 2
We take the log of both sides:
Log(Wealth) = Log(2) = 7 * Log(1.10)
You can just use a calculator to see that log(2) rounds to .29 and slope of the log chart will be Log(1.10) = .041
To interpret the log chart we observe, if:
Let’s now chart the wealth function as Log(Wealth):
Note: each of the 10 series corresponds to a rate of return of 10%, 9%, 8% and so on. The middle series (purple) is 5% per year and the flattest line corresponds to 1% per year.
Also note that at 10% growth per year we computed the slope of the log chart earlier to be Log(1.10) = .041.
And voila, it takes about 25 years (1/.04) to 10x your wealth, aka Log(Wealth) = 1, a whole order of magnitude.
Moving your eyes to the right along the line where Y=.3, to the light blue numbers. Those numbers represent a rate of return of 4%. You can see that it takes 4 extra years to get to the same level of wealth if you compound at 4% instead of 5%.
What you can generally observe is that earning 2% instead of 1%, is vastly more important than going from 9% ror to 10% ror. This idea is captured in the fact that 2% is double the rate of return of 1% and 10% is only 11% bigger than 9% but in practical terms it is a reminder that:
Here’s the chart zoomed in to holding periods of at least 10 years:
At 5% per year, you’ll double wealth in 14 years. At 3% it will take almost a decade longer.
If you use options to hedge or invest, check out the moontower.ai option trading analytics platform
I’ve been burying you with investment material, including an analysis of the TIPs + oil…
It recently came to my attention that fellow contributor to the upcoming How I Invest…
From the team behind the Arbor Trading Bootcamps which I constantly say are so good…
A great Munchie today. As usual, I highlight the parts I want to keepsake and…
Workflows are Moontower’s screeners organized around what you’re trying to do: sell premium (Income), buy…
Exponential Wealth: Centuries of Stock and Bond Returns free PDF · 380 pp. In 1976,…
View Comments
I’m a mechanical engineer and use log charts on the daily to review frequency domain information from vibration tests. I always tell people who are new to them: log charts let you see the “shape” of the plot, regardless of the scale. You can’t do this on a linearly-scaled plot because the few data points you have furthest from zero obscure the shape everywhere else. (Just try looking for selloffs in the linear scale plot of the S&P before 1990!)