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) / 2T = n / (1 − (1 + R)^n · V / G)t = T − nC = 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.
| T | 290.79407867 |
|---|---|
| C | 39.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.