Your dated savings plan
All costs and scholarships are entered at prices on your valuation date. They grow at the same chosen school-cost inflation rate until each bill. Savings, deposits and displayed bills are nominal dollars. Enter only the portion your savings account is meant to cover.
Can the planned deposits cover each bill?
Calculate to see a date-by-date plan. An ending balance alone cannot establish that earlier bills were funded.
- Sum of unfunded bill amounts (nominal, not discounted)
- First bill with a shortfall
- Total future net cost
- Account balance after final bill
- Future gross costs
- Future scholarships / aid
- Withdrawals actually funded
- Planned deposits through final bill
- Investment growth / loss
- Scheduled deposit count
- First permitted deposit date
- Last permitted deposit date
- Funding status
Shortfalls are unpaid needs, not loans or negative account balances. They do not earn returns and are not silently financed. Later savings do not erase an earlier shortfall. Find a separate funding source or change the plan before relying on it.
| School year | Withdrawal date | Cost | Scholarship / aid | Net need | Deposits | Growth / loss | Available before bill | Funded withdrawal | Shortfall | Balance after bill |
|---|---|---|---|---|---|---|---|---|---|---|
| Year 1 | ||||||||||
| Year 2 | ||||||||||
| Year 3 | ||||||||||
| Year 4 |
How the dated plan works
For a bill d days after valuation: future cost = entered cost x (1 + cost inflation)d/365, and future scholarship uses the same factor. Net need = future cost minus future scholarship. This treats both entries as valuation-date prices; do not enter an already inflated future quote and inflate it again.
Growth between events is balance x [(1 + annual return)actual days / 365 - 1]. Split an interval at enrollment when the return assumption changes. The day count always uses UTC calendar dates and a fixed 365 denominator, including leap years. Rates are effective annual nominal assumptions, not APRs or real returns; no additional general inflation subtraction is made. The monthly equivalent is (1 + annual return)1/12 - 1, but actual monthly deposit gaps use their actual day counts. Values are not rounded until display.
Each event accrues return, then adds a permitted deposit, then pays min(available balance, net need). The remainder is never negative. Any gap is recorded on that date and is not carried as debt. Projection ends immediately after the final selected bill. Annual bill dates are explicit, so uneven calendar spacing is supported; multiple withdrawals inside one school year are not separately modeled. All returns, scholarship availability and cost inflation are assumptions, not guarantees.
An example you can check independently
Value savings on January 1, 2027 at $6,000. Use two bills of $6,000 each, no scholarships, due January 1, 2028 and January 1, 2029. Set both returns and cost inflation to 0%. Deposit $500 monthly starting January 1, 2027, with last allowed date January 1, 2029, and keep the default stop-before-enrollment policy. Twelve deposits (January-December 2027) add $6,000. The first bill sees $12,000 available and leaves $6,000; the second is funded in full and leaves $0. Total need and funded withdrawals are $12,000; deposits $6,000; growth and shortfall $0. Allowing deposits during college instead permits 25 deposits through January 1, 2029, including same-day deposits before both bills, and leaves $6,500 after the second bill.
529 and taxable boundaries
The qualified-529 illustration assumes all modeled withdrawals are eligible qualified expenses under the rules that actually apply to you, with no withdrawal tax. It does not establish student, school, account or expense eligibility. The taxable illustration instead uses your return net of all applicable taxes and fees, including assumed liquidation tax effects. It does not calculate capital gains, basis, taxable income or annual tax drag from tax brackets.
No federal or state contribution deduction, credit, grant eligibility, tax credit coordination, penalty, contribution limit, gift-tax treatment or tax-law forecast is calculated. Nonqualified distributions, earnings/basis allocation, state recapture and withdrawal penalties are excluded; this model cannot price them. Do not assume every school cost qualifies for 529 treatment or count the same scholarship or other funding twice. Loans, uncertain investment paths, changing returns within a phase, extra bills and future borrowing costs are outside this bounded scenario.
Your entries are not sent to a calculator service, stored in your browser or added to a URL. This is a planned-contribution illustration, not a minimum-deposit optimizer. Review the funding for each year rather than relying on the ending balance.
