What the letters mean

r is the growth you expect in one month. g is how fast the amount you set aside grows each month. Both are fractions: 0.01 means 1%. G is the amount you want at the end. V is what you have now. n is how many months are left. Path(k) is what the account should be worth k months from now.

  • R = (r + g) / 2
  • T = n / (1 − (1 + R)^n · V / G)
  • t = T − n
  • C = G / (T · (1 + R)^T)
  • Path(k) = C · (t + k) · (1 + R)^(t + k)

R is the average of the growth and of how fast the amount you set aside grows. T is the length of the whole plan in months. t shifts the plan so today’s amount lands on it. C is the coefficient. Path(0) matches V. Path(n) matches G. Where these files come from is on the book page.

The 100,000 example

Numbers from the Chapter 5 Excel file Wiley published with the book. G = 100,000, V = 6,500, n = 204, r = 1% a month, g = 0.5% a month. That makes R = 0.0075.

The check for these numbers.
T290.79407867
C39.1536015
Path(1)6,624.2016
Path(21)9,444.1813
Path(204)100,000

The 10,000 example

This is our example on the same formulas. It is not in that Excel file. G = 10,000, V = 250, n = 36, and the amount you set aside does not grow. The rate r = 0.57% a month is ours, about 7% a year. At the end the plan lands on the goal. Path(36) = 10,000.

When you do not sell

If the next amount you need is below what you already hold, the trade is negative and the rule says to sell. The no-sale version takes the purchase as max(0, trade). Shares are not sold, and the difference stays in the reserve. More is on the no-sales page.

Open the calculator