Finance Brain
Sign in
← Back to decks
Sign in to save your progress.Sign in

Projecting a College Bill and the Savings It Needs

Parents ask two questions about college: what will it cost, and how much must we save? This lesson inflates today's costs, values a four-year bill at the start of college and today, and turns that value into a lump sum or a savings plan.

10 cards
Study this deck

Projecting a College Bill and the Savings It Needs

In this lesson · 5 sections
Step 4 of 5

Turning the target into savings

A family can fund the goal in several ways:

ApproachCalculation
Lump sum todayValue today ($99,834.77 in the example)
Level deposits at each year-end until collegePayment whose future value at the return equals the start-of-college value
Level deposits starting todayThe same payment divided by (1 + return)
Deposits rising each yearSerial payment at i*, then inflate the first payment

In the example, level deposits at the end of each of the next 10 years must grow to $196,390.10 at 7%: 196,390.10 / [(1.07^10 - 1) / 0.07] = $14,214.22 a year. This assumes saving stops when college starts; a family that keeps saving during college needs less. Money still invested during the four years keeps earning the return, which is why the start-of-college value is below the four bills added up ($217,643 in the example).

If education inflation exceeds the return, i* is negative and the amount needed today exceeds the four years' costs in today's dollars, because the money loses ground every year it waits.