Finance & Economics · Personal Finance
College Savings Calculator
Estimates how much you need to save monthly to fund future college costs, accounting for education inflation, investment returns, and your current savings.
Calculator
Formula
PMT is the required monthly contribution. FV is the future value of total college costs (current annual cost escalated by education inflation over years until enrollment, then summed across college years). PV is the present value of existing savings. r is the monthly investment return rate (annual rate divided by 12). n is the total number of monthly contributions remaining until the first year of college.
Source: Time Value of Money — standard annuity formula (Brealey, Myers & Allen, Principles of Corporate Finance)
How it works
College savings planning combines two powerful financial concepts: the future value of education costs (driven by education inflation) and the future value of an annuity (driven by investment returns on monthly contributions). The core challenge is that tuition in 13 years will be dramatically higher than it is today — and your savings need to keep pace with both that inflation and the multi-year drawdown period of actually paying for school year by year.
The calculator first projects the total college fund needed by escalating today's annual college cost by education inflation for each year until and through college enrollment, then discounts those future cash outflows back to a single lump-sum equivalent at the start of college — expressed in future dollars. It then determines how much of that target will be covered by the growth of your existing savings, and finally uses the standard future-value-of-annuity formula to solve for the monthly payment (PMT) required to bridge the remaining gap. The formula is: PMT = FV × r / [(1 + r)^n - 1], where r is the monthly investment return and n is the number of months until college begins.
This approach is widely used by financial planners, 529 plan administrators, and college funding advisors. It accounts for the realistic fact that you are saving toward a multi-year spending stream, not a single lump sum — so each year of college tuition is weighted by when it will actually be paid. Inputs like education inflation (historically ~5% per year for four-year universities) and expected investment return (historically 6–8% for diversified equity portfolios) have a large impact on the result, underscoring the value of starting early to maximize compounding time.
Worked example
Suppose you have a 5-year-old child who will start college at age 18, attending for 4 years. Current annual college costs (tuition, room, board, and fees) at a target school are $35,000 per year. You assume 5% annual education inflation and expect your investments to earn 7% per year. You have already saved $5,000.
Step 1 — Years until college: 18 − 5 = 13 years (156 monthly contribution periods).
Step 2 — Project future college costs: In year 13, annual cost = $35,000 × (1.05)^13 ≈ $66,620. Year 14 ≈ $69,951, Year 15 ≈ $73,449, Year 16 ≈ $77,121. Total nominal cost over four years ≈ $287,141.
Step 3 — Present-value-equivalent lump sum at college start: Discounting each year's cost back to the start-of-college date at 7% yields a required fund of approximately $258,000–$270,000 (varies with exact timing assumption).
Step 4 — Future value of existing savings: $5,000 growing at 7%/year for 13 years = $5,000 × (1.00583)^156 ≈ $12,460.
Step 5 — Remaining gap: $265,000 − $12,460 ≈ $252,540.
Step 6 — Monthly payment: PMT = $252,540 × (0.00583) / [(1.00583)^156 − 1] ≈ $800–$860 per month. Starting at birth instead of age 5 would reduce this to roughly $500/month — illustrating the powerful effect of an earlier start.
Limitations & notes
This calculator assumes a constant annual investment return and a constant education inflation rate, both of which will vary in practice. Market downturns in the years immediately before college (sequence-of-returns risk) can significantly reduce the portfolio's value relative to projections, which is why most financial planners recommend gradually shifting a college portfolio toward more conservative assets (bonds, money market funds) as the enrollment date approaches. The calculator does not account for financial aid, scholarships, grants, or tax benefits — including the substantial tax-advantaged growth available inside a 529 plan, which can materially reduce the after-tax savings burden. It also does not model part-time student income, student loans, or work-study contributions. Education inflation has ranged widely depending on institution type (public in-state vs. private), so using a school-specific cost estimate will improve accuracy. Finally, the model assumes contributions are made at the end of each month (ordinary annuity); beginning-of-month contributions would slightly reduce the required PMT.
Frequently asked questions
What is a realistic education inflation rate to use?
Historically, U.S. college tuition and fees have inflated at approximately 4–6% per year over the past two decades, significantly outpacing general CPI inflation. The College Board reports that published tuition and fees at four-year public universities rose about 4% per year on average from 2002 to 2022. A rate of 5% is commonly used as a planning assumption, though private university costs have sometimes risen faster.
Should I use a 529 plan for college savings?
529 plans are the most tax-efficient vehicle for college savings in the United States. Contributions grow tax-free, and withdrawals for qualified education expenses — including tuition, room and board, and required fees — are also tax-free at the federal level and in most states. Many states offer an additional state income tax deduction for contributions. The 2022 SECURE 2.0 Act also allows unused 529 funds to be rolled into a Roth IRA after 15 years, reducing the penalty for over-saving.
How does starting earlier affect monthly savings requirements?
Starting earlier dramatically reduces the required monthly contribution because your money has more time to compound. For example, starting at a child's birth versus age 5 can reduce monthly contributions by 35–40% for the same savings goal. This is the single most powerful lever in college savings planning — more impactful than choosing a slightly better investment return or a marginally lower-cost school.
What investment return should I assume for a college savings portfolio?
For a long horizon (10+ years), a diversified equity portfolio has historically returned 7–10% annually before inflation. Most financial planners use 6–7% as a conservative long-term assumption net of fees, particularly for index-fund-based 529 portfolios. As the college start date approaches within 3–5 years, it is prudent to shift to a more conservative allocation (e.g., 4–5% return assumption) to protect against market volatility disrupting your near-term funding.
What if I cannot afford the calculated monthly savings amount?
If the required monthly payment is out of reach, there are several options: start with what you can afford and increase contributions annually as income grows; target a partial funding goal (e.g., cover 50% of projected costs) and plan to supplement with loans or aid; choose a lower-cost school or in-state public university as your cost baseline; or extend the savings timeline by encouraging the student to consider community college for the first two years. Even saving a portion is significantly better than saving nothing, due to the tax advantages of 529 plans and the power of compounding.
Last updated: 2025-01-15 · Formula verified against primary sources.