What a 529 plan is, and what the projection has to get right
A 529 plan is a state-sponsored investment account under §529 of the Internal Revenue Code. Contributions are made with after-tax dollars, growth is not taxed while it stays in the account, and withdrawals are tax-free when spent on qualified education expenses. Many states add a deduction or credit on state income tax for contributions to their own plan. The tax shelter is the whole point: over a fifteen-year horizon, not paying tax on the growth is worth a meaningful share of the final balance.
Projecting one honestly needs three things that people routinely get wrong.
Two different compounding rates. Your account grows at an investment return; college costs grow at education inflation, which has historically run above general inflation. If cost inflation exceeds your return, the target is moving away from you, and the calculator warns when your inputs put you in that regime.
Bills that arrive over several years, not all at once. Four years of college means four bills, each larger than the last. The money for years two through four stays invested while year one is being paid, so the lump you need on day one is less than the sum of the bills. On the default case the bills total $227,567 but the lump needed at matriculation is $208,223.
A contribution schedule, not a single deposit. Monthly contributions are an annuity, and the future-value annuity factor is what converts them into a balance — 235.45 at 6% over thirteen years, so $300 a month becomes $70,634.
The three calculations
Growing the account. The existing balance compounds at the monthly return for the whole horizon, PV(1 + m)k, and the contributions form an ordinary annuity whose future value is PMT · ((1 + m)k − 1) / m. Add them.
Sizing the cost. Each year of enrolment is today's cost of attendance inflated to the year it falls due: cost_j = cost₀ × (1 + e)^(N + j) − aid, where N is years until matriculation and j counts the enrolment years from zero. Note the exponent — the first bill is inflated for N years, not for one.
Bringing them to the same date. Each bill is discounted back to matriculation at your assumed return, so the target is Σ costj / (1 + r)j. Discounting at the return rate is the right convention because that is what the money would earn if it stayed in the account.
The required contribution is then the same annuity identity solved the other way: subtract what the existing balance will grow into, and divide the remainder by the future-value annuity factor. If the balance alone already exceeds the goal, the required contribution is zero rather than negative.
Worked example: a five-year-old, $15,000 saved, $300 a month
Take the defaults — child aged 5, matriculating at 18, four years of enrolment, $15,000 in the account, $300 a month, 6% expected return, $28,000 of annual cost today growing at 5%, no aid assumed.
- Horizon. 18 − 5 = 13 years, so k = 156 months and m = 0.005.
- Growth factor. (1.005)156 = 2.1772366.
- Existing balance grows to. 15,000 × 2.1772366 = $32,658.55.
- Contributions grow to. The annuity factor is (2.1772366 − 1) ÷ 0.005 = 235.4473, so 300 × 235.4473 = $70,634.20.
- Projected balance. 32,658.55 + 70,634.20 = $103,292.75.
- The bills. 1.0513 = 1.885649, so the first year costs 28,000 × 1.885649 = $52,798.18. The following years are $55,438.08, $58,209.99 and $61,120.49, totalling $227,566.74.
- Lump needed at matriculation. Discount each at 6%: 52,798.18 + 52,300.08 + 51,806.68 + 51,318.00 = $208,222.88. Notice how nearly equal those four terms are — 5% inflation and 6% discounting almost cancel.
- The gap. 103,292.75 − 208,222.88 = −$104,930, so the plan covers 49.6% of the cost.
- Closing it. (208,222.88 − 32,658.55) × 0.005 ÷ 1.1772366 = $745.66 a month, against the $300 currently going in.
That result is typical rather than alarming, and it is why the next section is about what to do with a shortfall rather than how to eliminate it.
Reading a shortfall without panicking
A funding gap is normal and does not mean the plan has failed. Most families cover college from three sources — savings, current income during the college years, and borrowing — and a 529 is only the first. A plan covering half the published cost of a private-college sticker price is doing real work.
Three levers move the answer, in descending order of power. Time is the strongest: the reference table below shows that funding a $28,000-a-year college from scratch needs $686 a month starting at birth and $3,250 a month starting at fifteen — 4.7 times as much for one sixth of the horizon. The cost target is next, and it is the one people forget is a choice: an in-state public university and a private college differ by a factor of two or more in the table, and that difference dwarfs any plausible investment outperformance. The contribution comes third.
Be careful with the two cost outputs. The nominal total is what you will hand over; the lump needed is what you must have on day one. Quoting the nominal figure as a savings target overstates the job by the amount the account will earn during the college years — $19,344 in the default case.
And treat the aid field with suspicion. Institutional grants are real and often large, but they are re-assessed annually, depend on the college, and cannot be relied on before an offer exists. Assets in a parent-owned 529 are assessed on the FAFSA at a maximum of 5.64% of value, far more favourably than student-owned assets — so saving in a 529 reduces aid eligibility only slightly.
Monthly contribution needed to fully fund four years, starting from zero
| Years until college | $15,000 a year | $28,000 a year | $45,000 a year | $60,000 a year |
|---|---|---|---|---|
| 18 | $368 | $686 | $1,103 | $1,470 |
| 15 | $423 | $789 | $1,269 | $1,692 |
| 12 | $506 | $944 | $1,517 | $2,022 |
| 10 | $588 | $1,098 | $1,764 | $2,352 |
| 8 | $712 | $1,328 | $2,135 | $2,846 |
| 5 | $1,082 | $2,020 | $3,246 | $4,329 |
| 3 | $1,741 | $3,250 | $5,223 | $6,964 |
Every column scales exactly with the cost, because the cost enters the formula linearly. The rows do not scale with time at all: going from 18 years to 3 multiplies the required contribution by 4.7, not by 6, because a shorter horizon also gives inflation less time to raise the bill.
What this projection does not model
- State tax deductions. Many states allow a deduction or credit for contributions to their own plan, which effectively increases your contribution at no extra cost. The benefit varies enormously by state and is not included here.
- Sequence of returns. A single average return hides the risk that a bad market lands in the year before matriculation. Age-based 529 portfolios shift towards bonds precisely to manage this, which also means your realised return is likely to be lower in the last few years than in the first.
- Fees. Enter a return net of fund expenses. Direct-sold plans are usually materially cheaper than advisor-sold ones, and over eighteen years the difference compounds.
- Contribution limits and gift tax. There is no annual federal contribution cap, but contributions are gifts for tax purposes, with a five-year forward election available for large lump sums. Each state also sets an aggregate account balance limit.
- Non-qualified withdrawals. Earnings withdrawn for anything other than qualified expenses are taxed as ordinary income plus a 10% penalty. The penalty is waived, though not the tax, if the beneficiary receives a scholarship.
- Leftover funds. A 529 can be rolled to another qualifying family member, and since the SECURE 2.0 Act a limited amount may be rolled into the beneficiary's Roth IRA subject to conditions including a 15-year account age. Check the current rules before relying on either.
- Published cost is not net price. Sticker cost of attendance is what this calculator inflates; the price most families actually pay at private colleges is lower after institutional grants.
Where 529 saving sits in the plan
Order of operations matters more than optimisation. Retirement funding comes first, for a reason that sounds harsh and is simply true: your child can borrow for college and you cannot borrow for retirement. High-rate consumer debt comes next — clearing a card at 23% beats a 6% expected return with certainty, and the debt avalanche calculator shows the cheapest order to do it. Emergency reserves come before college saving too, because a family that has to withdraw from a 529 in a crisis pays tax and a penalty on the earnings.
Against the alternatives: a taxable brokerage account is more flexible and loses the tax shelter; a Coverdell ESA has a low annual limit; a UTMA custodial account becomes the child's property at majority and is assessed far more harshly for financial aid. For education specifically, the 529 is the default answer for most families.
Plan for the gap rather than pretending it away. Current income during the college years is a legitimate funding source that no projection captures, as is a student's own part-time earnings. Federal student loans in the student's name are the borrowing of last resort but carry protections that private loans do not — see the student loan payment calculator for what a given balance actually costs to repay. Working the shortfall out now, while there are still years to adjust, is the point of running this at all.