College Savings 529 Plan Calculator: How Much Should You Save?

The cost of a four-year college education in the United States is projected to reach $100,000–$120,000 at an in-state public university and $250,000–$350,000 at a private university for a child starting college in the mid-2030s. Those numbers are not typos — they are the result of education inflation that has historically outpaced general inflation by 2–3 percentage points per year, compounded over the 10–18 years between a child’s birth and their first semester.

The instinct when confronting numbers this large is either to panic (start saving aggressively at the expense of retirement and current needs) or to give up (assume college will be funded through loans, scholarships, or “something will work out”). Both reactions are wrong. The correct response is to calculate how much you actually need to save per month, start now, and let compound growth close the gap between what feels affordable and what the target requires.

This spreadsheet runs that calculation. You enter your child’s age, your target institution type (in-state public, out-of-state public, private), your current savings, and your expected investment return. The calculator shows the projected total cost at enrolment, the monthly savings needed to reach the target, and how different contribution levels change the funding percentage at the start of freshman year. It also compares the 529 plan against alternative education savings vehicles so you can choose the right account for your situation.

Disclaimer: This calculator is provided for informational and educational purposes only. It does not constitute financial, tax, or education planning advice. College costs, investment returns, and tax rules change over time. Consult a qualified financial advisor for guidance specific to your family’s situation. SpreadsheetTemplates.info is not responsible for decisions made based on the information provided.

The Maths of College Savings#

Current Costs (2025–2026 Academic Year)#

Average annual costs for tuition, fees, room, and board: in-state public university — approximately $24,000–$28,000/year, out-of-state public university — approximately $44,000–$48,000/year, and private university — approximately $58,000–$62,000/year.

Education Inflation#

College costs have historically increased at approximately 5–6% annually — roughly double the rate of general consumer inflation. This means costs roughly double every 12–14 years. A child born today will face college costs that are 2–3× current levels when they enrol at age 18.

The Power of Starting Early#

A parent who saves $300/month starting at a child’s birth, earning 7% annual returns in a 529 plan, will accumulate approximately $122,000 by age 18. The same parent starting at age 8 would need to save $650/month to reach the same amount. Starting at age 13 would require over $1,600/month. The compound growth advantage of starting early is enormous — it is the difference between a manageable monthly contribution and a crushing one.

What the Calculator Models#

Inputs#

You enter the child’s current age, the target college start age (typically 18), the institution type (or a custom annual cost), the assumed education inflation rate (default 5.5%), your current education savings, your planned monthly contribution, and the expected annual investment return (default 7% for an age-based 529 portfolio).

Outputs#

The calculator projects the estimated total four-year cost at enrolment (current cost inflated to the target year), the projected savings at enrolment (current savings + contributions + investment growth), the funding percentage (projected savings ÷ total cost — your coverage level), the monthly contribution needed to reach 100% funding, the monthly contribution needed to reach 50% funding (a more achievable target that covers half the cost, with the rest from financial aid, scholarships, and student contribution), and a year-by-year growth projection showing how the account balance builds over time.

Scenario Modelling#

The spreadsheet models three contribution scenarios simultaneously: your current planned contribution, a contribution 25% higher, and a contribution 50% higher. Seeing all three side by side reveals how modest increases in monthly saving produce disproportionately larger funding percentages — due to the compounding effect over 10–18 years.

It also models three return scenarios (5%, 7%, 9%) to show how investment performance affects the outcome. This range reflects conservative, moderate, and optimistic equity returns within a 529 plan.

How to Choose a 529 Plan#

You can invest in any state’s 529 plan regardless of where you live, and the beneficiary can attend college in any state regardless of which plan you use. But not all plans are equal.

Check your state tax deduction first. Over 35 states offer a tax deduction or credit for 529 contributions to the state’s own plan. In states with generous deductions (such as New York, which allows up to $10,000 in deductions for joint filers), the tax benefit can be worth $500–$800/year — a meaningful boost on top of the tax-free growth. If your state offers a deduction only for contributions to its own plan, that plan should be your starting point.

Compare expense ratios. 529 plan fees vary widely — from 0.10% to over 1.00% annually. Over 18 years of compounding, a 0.50% difference in fees on a $100,000 balance costs roughly $10,000–$15,000 in lost growth. Low-cost plans (Utah’s my529, Nevada’s Vanguard 529, New York’s Direct Plan) offer index-fund-based portfolios with all-in fees below 0.20%.

Evaluate investment options. The best plans offer low-cost age-based portfolios from reputable providers (Vanguard, Fidelity, TIAA) that automatically rebalance from equity-heavy to bond-heavy as the child approaches college age. Avoid plans with limited investment options, high fees, or commissioned sales charges (advisor-sold plans typically carry higher fees than direct-sold plans).

Download: 529 Plan Calculator — Excel (.xlsx)

Education Savings Vehicle Comparison#

Feature	529 Plan	Coverdell ESA	Taxable Brokerage	UTMA/UGMA
Annual Contribution Limit	None (state maximums typically $300,000–$550,000 lifetime)	$2,000/year	No limit	No limit
Tax Benefit on Contributions	State tax deduction in 35+ states (not federal)	None	None	None
Tax-Free Growth	Yes (for qualified education expenses)	Yes (for qualified expenses)	No (capital gains taxed)	No (taxed at child’s rate, kiddie tax may apply)
Qualified Expenses	Tuition, room, board, books, computers, K-12 tuition (up to $10,000/yr)	Tuition, room, board, books, supplies, K-12	Any purpose	Any purpose (once child reaches majority)
Impact on Financial Aid	Moderate (parent-owned 529 counted as parental asset — up to 5.64% of value assessed)	Moderate (similar to 529)	Varies (parental asset if in parent’s name)	High (child’s asset — 20% assessed for financial aid)
Unused Funds	Roll to another beneficiary, or to a Roth IRA (up to $35,000 lifetime, subject to conditions)	Roll to another beneficiary	Withdraw freely	Belongs to the child at age of majority
Best For	Most families saving for college	Supplemental savings up to $2,000/yr	Families who want flexibility beyond education	Families certain the child will use the funds

The 529 plan is the default recommendation for most families. The state tax deduction (available in 35+ states), tax-free growth, and the ability to roll unused funds to a Roth IRA (under the SECURE 2.0 Act, up to $35,000 lifetime if the 529 has been open for 15+ years) make it the most flexible and tax-efficient vehicle. The Coverdell ESA is useful as a supplement but the $2,000 annual limit makes it inadequate as a primary savings vehicle.

The UTMA/UGMA has a significant disadvantage: funds become the child’s property at the age of majority (18 or 21, depending on the state), and the child can use them for any purpose — not just education. For financial aid purposes, UTMA assets are counted at 20% (child’s asset), versus 5.64% for parent-owned 529 plans — a meaningful penalty.

How Much Should You Actually Save?#

Here is the editorial position: do not try to save 100% of projected college costs. Target 50–70% of the projected cost and plan for the remainder through a combination of financial aid and scholarships (which reduce costs for most families), student contribution (part-time work, summer employment, co-op programmes), and moderate student loans (borrowing $20,000–$30,000 total over four years is manageable for most graduates and avoids the extremes of zero-debt obsession and crushing debt burden).

Targeting 50–70% also prevents the common mistake of over-saving for college at the expense of retirement. Your retirement cannot be funded by financial aid or loans. College can. If your budget forces a choice between maxing the 529 and contributing to your 401(k), prioritise retirement — especially if your employer offers a match.

For modelling how education savings fit alongside retirement savings, see our retirement savings tracker and FIRE planner. For tracking education savings as part of your overall financial picture, see our net worth tracker. And for modelling the tax benefit of 529 contributions in your state, see our tax estimator spreadsheet.

Frequently Asked Questions#

What is a 529 plan?

A 529 plan is a tax-advantaged investment account designed for education savings. Contributions grow tax-free, and withdrawals are tax-free when used for qualified education expenses (tuition, room, board, books, computers, and fees). Most states also offer a state income tax deduction or credit for contributions. Plans are sponsored by individual states but you can invest in any state’s plan regardless of where you live (though your own state’s plan may offer tax benefits unavailable elsewhere).

Can I use 529 funds for expenses other than college?

Qualified expenses include tuition, fees, room and board, books, supplies, computers, and required equipment at any accredited post-secondary institution. Up to $10,000/year can also be used for K-12 tuition. Under the SECURE 2.0 Act, unused 529 funds can be rolled into a Roth IRA for the beneficiary (subject to conditions: the 529 must have been open for 15+ years, and the lifetime rollover cap is $35,000). Non-qualified withdrawals are subject to income tax on the earnings plus a 10% penalty on the earnings.

What investment options are available in a 529 plan?

Most plans offer age-based portfolios (which automatically shift from aggressive to conservative as the child approaches college age) and static portfolios (where you choose a fixed allocation). The age-based option is the default recommendation for most families — it matches the investment risk to the time horizon without requiring ongoing management.

How does a 529 plan affect financial aid?

A parent-owned 529 is counted as a parental asset on the FAFSA, which assesses up to 5.64% of its value per year. On a $100,000 balance, the expected family contribution increases by approximately $5,640 per year. This is a moderate impact — meaningful but not disqualifying. Grandparent-owned 529s no longer count as student income on the simplified FAFSA (as of the 2024–2025 cycle), making them a useful planning tool.

What if my child does not go to college?

You have several options: change the beneficiary to another family member (sibling, cousin, yourself), roll up to $35,000 into a Roth IRA for the beneficiary (if the 529 has been open 15+ years), use funds for qualified vocational or trade school expenses (which are eligible 529 expenses), or withdraw the funds (earnings are subject to tax and 10% penalty, but contributions are returned tax-free). The flexibility of the 529 has improved significantly under recent legislation.

Should I save for college or pay off debt first?

If you have high-interest debt (credit cards, personal loans above 8–10%), paying off the debt first is almost always the right priority — the guaranteed return of eliminating 20%+ interest exceeds any likely investment return in a 529. If your debt is moderate-interest (student loans at 4–6%, auto loans), you can reasonably split your available savings between debt reduction and 529 contributions. The compound growth advantage of starting early means even small 529 contributions ($50–$100/month) are worthwhile alongside debt payoff.

What education inflation rate should I assume?

The historical average is approximately 5–6% annually, which is the spreadsheet’s default. However, there are signs that education inflation may moderate in coming years as competition from online education increases, demographic shifts reduce the college-age population, and public pressure on tuition transparency grows. Using 4–5% is a reasonable optimistic assumption; 5–6% is the conservative and historically accurate assumption.