Project how an education fund grows before your child starts college, with regular contributions and compounding.
How the College Savings Calculator works
The calculator grows your 529 balance with a standard future-value formula, then races that balance against tuition inflated at its own faster rate so you see the real coverage gap.
Fund growth uses: Projected fund = P(1 + r/n)nt + PMT x [((1 + r/n)nt - 1) / (r/n)]. Here P is your starting 529 balance, PMT is the recurring contribution, r is the annual return as a decimal, n is compounding periods per year (12 for monthly), and t is years until enrollment. The first term compounds today's lump sum; the second term sums every future deposit and the tax-deferred interest each one earns.
What makes this an education tool rather than a generic savings projection is the second engine: it inflates the projected cost of college with Future cost = Cost_today x (1 + g)t, where g is the tuition growth rate. The default is set near 5% because published tuition and fees have historically climbed faster than the broad Consumer Price Index of roughly 2-3%, so using a general inflation rate here would badly understate the bill.
Step by step, the tool: (1) reads P, PMT, return r, years t, and compounding n; (2) computes the projected 529 balance at enrollment; (3) splits that balance into total contributions versus the tax-free earnings that escape tax when spent on qualified education; (4) inflates the current sticker cost at the tuition rate g over the same t years; (5) subtracts the fund from future cost to show the dollar shortfall; and (6) divides fund by future cost to report the percentage of total college cost your plan covers.
Edge cases it handles: a zero return (it switches to simple addition of P plus PMT x n x t to avoid dividing by zero); a tuition rate set equal to or below your return (coverage can exceed 100%, the over-funding warning zone); a starting balance of zero (a pure contribution stream); and a partial-coverage goal, where you can target, say, 50% of the bill rather than the full sticker price - reflecting that grants, scholarships, and current income usually pay the rest of an education bill.
Example calculation
These three scenarios show the same engine producing very different coverage because timing, contributions, and the assumed return shift the outcome against tuition rising at 5%.
Example 1 - Newborn, steady plan. You open a 529 with $5,000 and add $300/month for 18 years at a 6% return, compounded monthly. The fund grows to $130,890, of which $69,800 is contributions and $61,090 is tax-free earnings. A 4-year cost of $100,000 today, inflated at 5% for 18 years, becomes $240,662. The plan covers about 54%, leaving a $109,772 gap to fill with income, aid, or scholarships.
Example 2 - Late start at age 10. You begin with $2,000 and contribute $400/month for 8 years at 5%. The fund reaches $50,077 ($40,400 contributed, $9,677 earned). A $60,000 cost today inflated at 5% for 8 years is $88,647, so you cover about 57% despite the heavier monthly deposit - proof that the missing decade of compounding, not the contribution size, is what hurts.
Example 3 - Aggressive early start. A $10,000 opening balance plus $500/month for 18 years at 7% grows to $250,486 ($118,000 contributed, $132,486 earned). A $150,000 cost inflated at 5% becomes $360,993, covering about 69%.
| Scenario | Start / Monthly / Return / Years | Projected fund | Future cost (5%) | % covered |
|---|---|---|---|---|
| 1. Newborn steady | $5,000 / $300 / 6% / 18 | $130,890 | $240,662 | 54% |
| 2. Age-10 late start | $2,000 / $400 / 5% / 8 | $50,077 | $88,647 | 57% |
| 3. Aggressive early | $10,000 / $500 / 7% / 18 | $250,486 | $360,993 | 69% |
Notice that in Example 1, tax-free earnings make up about 47% of the fund, but in Example 2 only 19% - the eight-year horizon never lets compounding catch up. Every plan above also clears the bill by less than 70%, which is the recurring lesson of a tuition-inflation overlay: even disciplined saving rarely covers the full sticker price once college costs grow at 5% a year.
Tips for using the College Savings Calculator
- Set the tuition inflation rate near 5%, not the 3% you might use elsewhere - published college costs have historically outpaced general CPI, and using a CPI rate here will overstate the share your 529 covers by 20-30 percentage points.
- Aim to cover a target percentage, not 100%. Many families plan for the 529 to fund roughly half of college, with current income, scholarships, grants, and student aid handling the rest; over-saving in a 529 risks the 10% non-qualified withdrawal penalty on earnings.
- Check your own state's plan before any out-of-state option - most states that offer a deduction or credit only grant it for contributions to the in-state 529, an instant guaranteed return on top of investment growth that no fund can match.
- Front-load early. Example 2 shows a $400 monthly deposit covering barely more than a $300 deposit started a decade earlier, because tax-deferred earnings come from years in the market, not dollars added late.
- Model an age-based glide path by lowering your return assumption as enrollment nears - run 6-7% for the early years and re-run at 3-4% for the final stretch, since these 529 portfolios shift from stocks to bonds and cash automatically.
- Use the 5-year gift-tax election (superfunding) when modeling a large lump sum - federal rules let you front-load five years of annual gift-tax exclusion into one 529 contribution, which the P term in this calculator captures as accelerated, tax-deferred compounding.
- Re-run the tool every year with the actual balance. Real returns are lumpy, so an annual reset keeps your coverage percentage honest and tells you whether to raise contributions before the window closes.
- Keep the 529 in the account owner's name (parent), not the student's - parent-owned 529 assets are assessed far more lightly than student-owned assets in federal financial-aid formulas, preserving aid eligibility.
- Remember qualified K-12 tuition (up to a federal annual limit), certain apprenticeship costs, and a lifetime cap on student-loan payoff now count as qualified 529 expenses - if you plan those uses, shorten your time horizon t accordingly.
- Leftover funds are not stranded: a beneficiary change to another family member, or a limited rollover of unused 529 funds to the beneficiary's Roth IRA under current rules, can rescue an over-funded plan - so penalty fear should not cap your contributions far below your real target.
529 plan vs taxable brokerage account for college
A 529 wins for money you are confident will fund education because its qualified growth and withdrawals are federally tax-free, while a taxable account stays flexible but loses a slice of every gain to tax.
The trade-off is flexibility versus tax efficiency, and for a defined goal like college the 529's tax shield usually dominates. A 529 grows tax-deferred, comes out tax-free for qualified education costs, and may earn a state deduction - but non-qualified withdrawals owe income tax plus a 10% penalty on the earnings portion only. A taxable brokerage account can be spent on anything, yet you pay tax on dividends every year and capital-gains tax when you sell. On a mid-size 18-year plan, that tax difference can run past $10,000 (see the FAQs below).
| Feature | 529 plan | Taxable brokerage |
|---|---|---|
| Growth on qualified use | Tax-free | Taxed (dividends + gains) |
| State tax break | Often yes | No |
| Spend on anything | No (10% penalty on earnings) | Yes |
| Financial-aid impact | Lower (parent asset) | Higher if student-owned |
Run both: enter the same inputs in this tool and in the investment calculator, then haircut the taxable result by your expected tax drag - roughly 15% of the gains for a long-term holder - to see the 529 advantage in dollars rather than in theory.
The tuition-inflation gap most savers miss
The reason a healthy-looking 529 balance still falls short is that published tuition has historically climbed around 5% a year - faster than the general inflation rate of roughly 2-3%.
That extra few points compounds brutally over an 18-year horizon. A $100,000 cost today becomes about $240,662 in 18 years at 5%, but only about $170,243 at 3%. Planning on a 3% rate would leave you roughly $70,419 short on a single child before you account for a dollar of return shortfall. This is the core difference between this tool and a generic projection: it inflates the education target faster than ordinary prices, so the coverage percentage you read reflects the bill you will actually face.
To see how a single rate distorts long-range numbers, compare the general-price effect in the inflation calculator against the steeper tuition curve here. Your job is not to beat tuition inflation outright with investment returns - it is to close enough of the gap that current income, scholarships, and aid can cover the remainder.
Common mistakes that wreck a college plan
The biggest 529 errors are inflating tuition at CPI, starting late, and assuming the plan must cover 100% of the bill.
- Inflating tuition at CPI. Using 3% instead of ~5% can overstate coverage by 20-30 percentage points and lull you into under-contributing for years.
- Counting on the full sticker price. Few families pay the published cost; grants, merit aid, and need-based aid commonly reduce it. Targeting 50-70% coverage from the 529 is realistic.
- Holding too much cash too long. A 529 parked in a money-market option for 18 years barely outruns 5% tuition. Growth assets early are what build the tax-free earnings shown in the examples.
- Over-funding past need. Leftover earnings face a 10% penalty on non-qualified withdrawal. Size contributions to a target, and lean on the savings goal calculator to set that target before maxing out.
- Putting the account in the child's name. Student-owned 529 assets cut federal financial aid more than parent-owned ones, so the owner field matters as much as the balance.
How to do it by hand or in Excel
You can reproduce this calculator with two spreadsheet formulas: one for tax-deferred fund growth and one for tuition inflated at its faster rate.
For the projected 529 balance, use the future-value function. Signs matter: enter contributions and the starting balance as negatives so the result is positive:
- =FV(rate/12, years*12, -PMT, -P)
- Example 1: =FV(0.06/12, 18*12, -300, -5000) returns $130,890.
For inflated tuition, raise one plus the tuition rate to the number of years:
- =Cost_today*(1+g)^years
- Example 1: =100000*(1.05)^18 returns $240,662.
Then coverage is simply =FV_result / future_cost, or 130890 / 240662 = 0.544, about 54%. To solve the reverse - the monthly deposit needed to hit a tuition target - use =PMT(rate/12, years*12, -P, future_goal). The growth half of this math also powers the compound interest calculator if you want to study the compounding term on its own, but only the 529 view pairs it with the tuition-inflation target.
Is your plan on track? Benchmarks to check
The cleanest 529 benchmark is the percentage of projected total college cost your fund covers, read against the bands below.
A common rule of thumb is to have roughly one times a year of expected college cost saved by age 5, about three times by age 10, and the full multi-year target by enrollment - but because tuition keeps inflating, the coverage percentage this tool reports is the more honest gauge:
| Coverage of total cost | What it means |
|---|---|
| Under 30% | Behind; raise contributions or extend the timeline |
| 40-60% | Solid - aid, income, and work can bridge the rest |
| 70-90% | Strong; on pace for most public and many private schools |
| Over 100% | Watch for over-funding; consider capping 529 contributions |
Most well-funded family plans land in the 40-70% band, not 100%, which matches the three worked examples above. If your number is far below 30%, the fix is usually time and contribution size - raise PMT and re-run, the way you would tune a target in the future value calculator, then re-check coverage against the inflated bill rather than against today's price.
Age-based glide paths and the return you should assume
Because most 529 plans automatically shift from stocks toward bonds and cash as college nears, your assumed return should fall over time rather than stay fixed.
A newborn's age-based 529 portfolio might reasonably assume 6-7% while heavily in equities; a 16-year-old's option, now mostly bonds and cash, might assume 3-4%. If you plug a flat 7% across all 18 years, you will overstate the final balance, because the glide path deliberately trades growth for stability in the last few years to protect against a market drop right before the first tuition bill is due. For a $300 monthly deposit, a flat 7% projects about $129,216 while a flat 5% projects about $104,761 - the glide path lands between them, near $116,000 at a blended ~6%.
The practical move is a two-stage estimate: run the early years at a growth rate, then re-run the final 3-5 years at a conservative rate using the projected balance as your new starting P. This mirrors how a 529 age-based option actually behaves and produces a more honest coverage figure than a single optimistic rate carried across the whole horizon.
State tax breaks and qualified expenses
Many states give a deduction or credit for contributions to their own 529 plan, which acts like an instant, guaranteed return on top of investment growth.
Rules vary widely: some states deduct contributions up to a yearly cap, a few offer a flat credit, and several have no state income tax so the break does not apply. A deduction works on your marginal rate - a $10,000 contribution in a 5% state saves about $500 that year - and because the break usually requires the in-state plan, that home-state benefit often outweighs a slightly cheaper out-of-state option. This calculator models investment growth only; treat any state break as a separate bonus that effectively lowers your net cost of contributing.
On the spending side, qualified expenses include tuition, mandatory fees, required books and equipment, and room and board for at least half-time students, plus - under current federal rules - limited K-12 tuition, certain apprenticeship costs, and a lifetime cap on student-loan repayment. Spending on non-qualified items triggers income tax plus a 10% penalty on the earnings portion only, which is why sizing the plan to a realistic target matters more than maxing it out.
529 projection vs. tuition inflation: quick-reference table
The table below shows what a monthly 529 contribution grows to over 18 years with no starting balance, compounded monthly, and how much of that is tax-free growth you keep.
Every figure is recomputed. Remember the catch a generic savings tool hides: a $50,000 cost today rises to about $120,331 at 5% tuition inflation over 18 years, so even strong saving may cover only part of the bill - the reason this calculator overlays tuition inflation on your fund growth.
| Monthly deposit | You contribute (18 yrs) | Fund at 4% | Fund at 6% | Fund at 8% | Tax-free growth at 6% |
|---|---|---|---|---|---|
| $100 | $21,600 | $31,559 | $38,735 | $48,009 | $17,135 |
| $200 | $43,200 | $63,118 | $77,471 | $96,017 | $34,271 |
| $300 | $64,800 | $94,678 | $116,206 | $144,026 | $51,406 |
| $500 | $108,000 | $157,796 | $193,677 | $240,043 | $85,677 |
The final column is the growth that escapes tax in a 529 (fund minus contributions, at 6%). In a taxable account, roughly 15% of that could be lost to capital-gains tax - for the $300/month saver that is about $7,711 kept. Test your own deposit, return, and tuition assumptions, then compare the result against your projected tuition bill rather than today's price.
Related on this site
Savings Goal Calculator · Investment Calculator · Compound Interest Calculator · Future Value Calculator · Inflation Calculator · Rule of 72 Calculator
For a related deep dive, see SEC introduction to 529 plans.
College Savings Calculator — frequently asked questions
- What is a 529?
- A tax-advantaged US account for education costs; earnings grow tax-free for qualified expenses.
- Will it cover tuition?
- Compare the projection with rising tuition estimates; you may need to adjust contributions.
- What is a 529 plan?
- A US tax-advantaged account where investment growth is tax-free for qualified education expenses.
- Will this cover full tuition?
- Compare the projection with rising tuition estimates and adjust contributions.
- How much will $300 a month in a 529 grow to in 18 years at a 6% return?
- About $116,206, of which roughly $51,406 is tax-free investment growth. Saving $300 a month for 18 years means you contribute $64,800 of your own money ($300 x 12 x 18). At 6% compounded monthly, the balance reaches <strong>$116,206</strong>. In a 529 that ~$51,406 of growth is never taxed if used for qualified education costs. Run your own figures in the <a href="/college-savings-calculator/">college savings calculator</a>.
- If college costs $50,000 today, what will it cost in 18 years at 5% tuition inflation?
- About $120,331, more than double today's price. Tuition has historically risen near 5% a year, well above general CPI. A $50,000 cost today, grown at 5% for 18 years ($50,000 x 1.05<sup>18</sup>), becomes roughly <strong>$120,331</strong>. That is why a 529 earning 6% barely outpaces tuition: your real gain is only about 1% a year. Model the gap in the <a href="/college-savings-calculator/">college savings calculator</a>.
- What percentage of college costs will $300 a month actually cover?
- Often less than half. If a four-year in-state public bill totals about $112,000 today and rises 5% a year, in 18 years it reaches roughly $269,541. A $300/month plan at 6% grows to about $116,206 over the same period. That covers only <strong>~43%</strong> of the projected total. The tuition-inflation overlay in the <a href="/college-savings-calculator/">college savings calculator</a> exposes this coverage gap that plain savings tools hide.
- How much does the tax-free growth in a 529 actually save versus a taxable account?
- Roughly $10,616 on a mid-size plan. Putting in $10,000 now plus $300 a month for 18 years at 6% grows to about $145,574, including ~$70,774 of investment growth. In a taxable brokerage that growth could face about 15% long-term capital-gains tax, costing roughly <strong>$10,616</strong>. In a 529 it is $0 if spent on qualified education. That tax shield is the core 529 advantage over an ordinary investment account.
- Is a 529 plan worth it if my return barely beats tuition inflation?
- Yes, mainly because of the tax break, not the raw return. Even when a 6% return only edges out ~5% tuition inflation, the 529 wins because qualified growth is tax-free and many states add a deduction. Skipping the 529 means paying capital-gains tax on every dollar of growth. The slim ~1% real return still compounds, and the combined tax savings can exceed $10,000 on a typical 18-year plan.
- How much state tax do I save by contributing $10,000 to a 529 in a state with a 5% income tax?
- About $500 in that tax year. A state income-tax deduction works on your marginal rate, so $10,000 deducted at 5% saves <strong>$10,000 x 0.05 = $500</strong>. A $5,000 contribution in a 4.25% state saves about $212.50. Limits and rules vary by state, and several states give no deduction or have no income tax, so check your own plan. The federal benefit - tax-free qualified growth - applies regardless of state.
- What does an age-based glide path do to my projected 529 balance?
- It lowers your end balance modestly in exchange for less risk near enrollment. A glide path shifts from stocks to bonds as the child ages, so your blended return drifts down. At a flat 7%, $300/month over 18 years grows to about $129,216; at a more conservative 5%, it is about $104,761. The glide path lands between those, near <strong>$116,000</strong> at a blended ~6%, protecting the fund from a crash right before tuition is due.
- How much would $200 a month earn in a 529 over 18 years at different returns?
- Between about $63,118 and $96,017 depending on return. Contributing $200 a month is $43,200 of your own money over 18 years. At 4% it grows to about <strong>$63,118</strong>; at 6%, about $77,471; at 8%, about $96,017. Higher equity exposure raises the projection but adds risk as enrollment nears. Test each rate in the <a href="/college-savings-calculator/">college savings calculator</a> and compare against your projected tuition bill.
- How do I calculate a 529 projection by hand or in Excel?
- Use the future value formula that combines a lump sum and monthly deposits. By hand: FV = P(1+r)<sup>n</sup> + PMT x [((1+r)<sup>n</sup> - 1) / r], where r is the monthly rate and n is total months. In Excel, type <strong>=FV(0.06/12, 18*12, -300, -5000)</strong> for $5,000 plus $300/month at 6% for 18 years, which returns about <strong>$130,890</strong>. Keep deposits and the starting balance negative so the result is positive.
- At 5% tuition inflation, how many years until college costs double?
- About 14.4 years, by the Rule of 72. Divide 72 by the growth rate: <strong>72 / 5 = 14.4 years</strong> for tuition to double at 5%. A 529 earning 6% doubles faster, in about 72 / 6 = 12 years. Because tuition often compounds at 5% or more, starting your plan even a few years earlier meaningfully closes the gap. See the <a href="/rule-of-72-calculator/">Rule of 72 calculator</a> to test other rates.
- What happens to the tax benefit if I use 529 money for something other than college?
- You lose it: the earnings face income tax plus a 10% penalty. On a non-qualified withdrawal, only the growth portion is hit, not your original contributions. If $20,000 of the withdrawal is earnings, the 10% penalty is <strong>$2,000</strong> and income tax at a 22% rate adds about $4,400 - roughly $6,400 total. A scholarship, a different school, or a sibling beneficiary can avoid most of this, so plan before withdrawing.
- How much does starting a 529 at birth versus age 9 change the result?
- Starting at birth roughly doubles your projected fund. At $300 a month and 6%, saving for the full 18 years grows to about <strong>$116,206</strong>; starting at age 9 (only 9 years) reaches just about $42,822 - despite contributing for half as long, the difference is far more than half because early dollars compound longest. Early years do the heaviest lifting, which is why the tuition-inflation gap punishes late starters most.
- What return do I need to keep pace with 5% tuition inflation?
- You need more than 5% just to stay even in real terms against college costs. If tuition rises 5% a year and your 529 earns 5%, your purchasing power is flat - $300/month at 5% over 18 years grows to about $104,761, but the bill grew at the same pace. To gain real ground you want a return above 5%; at a net real 1% ($300/month), 18 years yields only about <strong>$70,966</strong> in today's dollars.
- How much will a single $10,000 lump sum grow inside a 529 over 18 years?
- About $29,368 at a 6% return, with roughly $19,368 of tax-free growth. A one-time $10,000 deposit, left to compound monthly at 6% for 18 years ($10,000 x 1.005<sup>216</sup>), reaches <strong>$29,368</strong>. Adding monthly contributions accelerates this sharply. A lump sum early is powerful because every year of compounding counts; the same $10,000 added at age 14 would barely grow. Compare scenarios in the <a href="/compound-interest-calculator/">compound interest calculator</a>.
- Is $500 a month enough in a 529 to cover a $112,000 four-year bill?
- It builds a strong fund but may still fall short of inflated costs. $500 a month at 6% for 18 years grows to about <strong>$193,677</strong>, with $108,000 contributed. But a $112,000 four-year bill rising 5% a year reaches about $269,541 in 18 years, so even this plan covers only about 72%. The takeaway: the tuition-inflation overlay shows that generous saving still leaves a gap to bridge with income, scholarships, or aid.
Guides & articles
- How Much to Save for College by Age, With a Tuition-Inflation Math Breakdown
- 529 Plan Tax Benefits Explained: Tax-Free Growth, State Deductions, and a Worked Example
Related calculators
Compound Interest Calculator · Simple Interest Calculator · Savings Calculator · CD Calculator · APY Calculator · Investment Calculator