Skip to the main content

College funding

The planner covers the year of applying. This model covers the four years after it: costs inflated forward, savings accumulated as an annuity-due and drawn down semester by semester, then tested against simulated investment returns.

The three presets use typical published costs for U.S. residents. International students pay out-of-state tuition at public universities and usually qualify for less need-based aid, so replace the figures with the cost of attendance your own college publishes.

4-year college application & expense scenario

An accumulation phase followed by a decumulation phase — a pension in miniature, stress-tested against 1,200 market futures.

Fully funded
$52,000
$950.00
1 yr
6.0%
12%

Higher volatility widens the fan and raises the chance of running dry.

5.0%

College costs have historically outrun general CPI.

$4,000

Grants and scholarships, netted off the sticker price.

Total 4-year net cost

$104,158

Present value $89,008 discounted at 6.0%.

Balance at enrollment

$54,887

$109,950 contributed, $12,052 earned.

Funding surplus

$17,844

The plan never runs dry under the expected return.

Required contributionPMT∗PMT^{*}

$777.22/mo

Current contribution already covers it.

Savings balance with 1,200 simulated futures

10th–90th percentile fan
Probability of shortfallP(ruin)P(\text{ruin})

21.4%

Share of futures where the balance goes negative at any point.

Expected shortfall

$5,698

Average size of the hole, given that one opens.

Shortfall VaR (95%)VaR95\mathrm{VaR}_{95}

$8,748

Exceeded in only 1 future out of 20.

Shortfall TVaR (95%)TVaR95\mathrm{TVaR}_{95}

$12,001

Mean shortfall across the worst 5% of futures.

The mathematics behind this panel

Ck=C0(1+g)k,Bt+1=(Bt+PMT−Wt)(1+rm),rm=(1+r)1/12−1C_k = C_0(1+g)^k, \qquad B_{t+1} = \bigl(B_t + PMT - W_t\bigr)(1 + r_m), \qquad r_m = (1+r)^{1/12} - 1

Costs compound forward at gg; the balance is an annuity-due accumulation that switches into decumulation once bills land. Because contributions and withdrawals overlap, there is no closed form for the required payment — it is solved by bisection on the minimum balance, which is monotone in PMTPMT and therefore cannot diverge.