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
Show one section at a time

Terms you'll meet

Tap a card to see what it means.

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.

Which costs to project

A school's cost of attendance, the figure federal aid rules use, includes tuition and fees, housing and food, books and supplies, transportation and personal expenses. Planners usually start from a school's current published cost (or an average for the type of school the family has in mind), choose an education inflation rate, and agree with the family which costs they will cover and which the student or aid will.

Projections rest on assumptions: which school, the education inflation rate, the investment return and the timing of payments. Small changes in the gap between the return and the inflation rate move the result a lot, so planners test a range and update the plan every year. A family with more than one child repeats the calculation for each child, with that child's own start date and school, and adds the results; the costs of overlapping college years then show up in the cash flow plan.

Inflating the bill

A cost of C today rising at g a year costs C x (1 + g)^n in n years. Counting n is where errors start: a child who is 8 now and starts college at 18 enrolls in 10 years, and the first-year bill is due then, at the start of the year.

Worked example. Annual costs today are $31,000, education costs rise 5% a year, and the child starts in 10 years. The first year will cost 31,000 x 1.05^10 = $50,495.73, and each later year 5% more.

Valuing the four years

College bills are paid at the start of each year and grow, so the four years form a growing annuity due. Discount them at the inflation-adjusted rate:

i* = (1 + return) / (1 + education inflation) - 1

Continuing the example with a 7% return, i* = 1.07 / 1.05 - 1 = 1.9048%.

  • Value at the start of college: 50,495.73 x [1 - 1.019048^(-4)] / 0.019048 x 1.019048 = $196,390.10
  • Value today: 196,390.10 / 1.07^10 = $99,834.77

The second step discounts at the nominal return, because $196,390.10 is in future dollars. Equivalently, value the four years in today's dollars at i* (using $31,000) and discount 10 years at i*; both routes give $99,834.77. Mixing them (future dollars discounted at i*) double-counts inflation.

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.

On the exam

  • Count the years to the first payment carefully, and treat college bills as paid at the start of each year.
  • Discount growing college costs at i* = (1 + r) / (1 + g) - 1, not r - g.
  • Discount a start-of-college value in future dollars at the nominal rate.
  • Read whether deposits are at the start or end of each period.

Independent exam-prep material. Not affiliated with the AICPA, NASBA, CFA Institute or CFP Board. Not financial advice. Learn more

Quiz me on this
Years to the first college payment
Save
Timing of college payments in funding problems
Save
Discounting a start-of-college value in future dollars
Save
Education inflation above the investment return
Save
Cost of attendance
Save