Turning the target into savings
A family can fund the goal in several ways:
| Approach | Calculation |
|---|---|
| Lump sum today | Value today ($99,834.77 in the example) |
| Level deposits at each year-end until college | Payment whose future value at the return equals the start-of-college value |
| Level deposits starting today | The same payment divided by (1 + return) |
| Deposits rising each year | Serial payment at i*, then inflate the first payment |
In the example, level deposits at the end of each of the next 10 years must grow to $196,390.10 at 7%: 196,390.10 / [(1.07^10 - 1) / 0.07] = $14,214.22 a year. This assumes saving stops when college starts; a family that keeps saving during college needs less. Money still invested during the four years keeps earning the return, which is why the start-of-college value is below the four bills added up ($217,643 in the example).
If education inflation exceeds the return, i* is negative and the amount needed today exceeds the four years' costs in today's dollars, because the money loses ground every year it waits.