Skip to content
  • About
  • Contact
  • Contribute
  • Book
  • Careers
  • Podcast
  • Recommended
  • Speaking
  • All
  • Physician
  • Practice
  • Policy
  • Finance
  • Conditions
  • .edu
  • Patient
  • Meds
  • Tech
  • Social
  • Video
    • All
    • Physician
    • Practice
    • Policy
    • Finance
    • Conditions
    • .edu
    • Patient
    • Meds
    • Tech
    • Social
    • Video
    • About
    • Contact
    • Contribute
    • Book
    • Careers
    • Podcast
    • Recommended
    • Speaking

How do I know if I am done saving for college in my 529 plan?

James M. Dahle, MD
Finance
February 11, 2018
Share
Tweet
Share

Brian Canes sent me a question via Twitter, and I couldn’t quite answer it in 140 characters, so I decided to do a blog post about it since I thought it illustrated some important points. His question was:

“How do you calculate a % funded for a 529 account given an account balance and projected college tuition assuming no future contributions?”

In essence, Brian is asking “Am I done saving for college?” It is entirely possible that he is, but in order to decide, we’ll have to make a couple of key assumptions and do a little math.

In order to make this exercise a little more real, let’s use my own personal situation and numbers.

Whitney wants to go to Brigham Young University

WCI columnist Whitney is in 8th grade but has been talking about attending BYU already since she was very small. The 2017-2018 cost of attendance at BYU is $18,430. That’s a ridiculously inflated number for my daughter given tuition is only $5,460, and she’s been well taught in how to be a cheapskate, but that’s what we’ll use. In order to keep things easy, we’ll assume Whitney graduates in just four years, goes straight through, and that during school her 529 will have returns equal to cost of attendance inflation. She just started 8th grade, so she has five years left until she will need $18,430 * 4 = $73,720. We’ll also assume that the entire cost is paid for out of Whitney’s 529, which is most definitely NOT true.

So how much is in her 529? On the day I wrote this (back in August), there was $34,298.82.

Now we’ll need to make two key assumptions. First, we’ll need to make an assumption about investment returns for the next five years, and then we’ll need to make an assumption about the rate of cost of attendance inflation over the next five years. I’m going to use 8% and 5%. If you don’t like those numbers, use your own, but I think they’re reasonable for our situation (aggressive 529 investing and a reasonable rate of tuition increases).

Calculating Whitney’s 529 plan % funded

Now we’ll plug those numbers into a financial calculator, or my preference, the Excel Future Value function.

Without additional contributions, over the next five years, at 8%, her 529 will grow to

=FV(8%,5,0,-34298.82) = $50,396.22

Meanwhile, the cost of attendance will grow to:

ADVERTISEMENT

=FV(5%,5,0,-73720) = $94,087.48

So, Whitney’s 529 is $50,396.22/$94,087.48 * 100 = 53.6% funded.

Maren wants to go to the University of Utah

Maren is 2 1/2 years younger than Whitney, about the same height, and in the 5th grade. They have been intense rivals from the time Whitney took scissors to Maren’s arm during her infancy. When Maren found out Whitney wanted to go to BYU, she instantly decided she would spend her undergraduate years at the rival institution, the University of Utah. Let’s repeat the exercise for her using the same assumptions.

University of Utah 2017-2018 Cost of Attendance: $23,444

Maren’s 529 Account Balance: $34,318.63

Calculating Maren’s 529 plan % funded

Without additional contributions, over the next 5 years, at 8%, her 529 will grow to:

=FV(8%,8,0,-34318.63) = $63,521.39

Meanwhile, the cost of attendance will grow from $23,444*4 = $93,776 to:

=FV(5%,8,0,-93776) = $138,549.86

So, Maren’s 529 is $50,396.22/$94,087.48 * 100 = 45.8% funded. Perhaps surprising, given her younger age and equal 529 balance. Picking a more expensive school makes a big difference.

Whitney wants to go to medical school

Whitney has also been talking about going to medical school. If we look at the total burden of her education for both undergraduate (again at BYU) and medical school (at the University of Utah), what percentage of her education is already funded?

Again, we’ll make some simplifying assumptions. We’ll assume Whitney goes straight through and that any invested 529 money keeps up with cost of attendance inflation from the time she starts undergraduate until the time she finishes med school.

The University of Utah School of Medicine Cost of Attendance for 2017-2018 is around $56,000 per year. Again, Whitney has $34,298.82 in the 529.

Calculating Whitney’s 529 plan % funded to include medical school

Without additional contributions, over the next five years, at 8%, her 529 will grow to

=FV(8%,5,0,-34298.82) = $50,396.22

Meanwhile, over the next five years, the total cost of her education ($73,720 undergraduate + $224,000 medical = $297,720) will grow to:

=FV(5%,8,0,-297720) = $439,868.

Thus, her total educational cost is currently 11% funded.

Now, have I simplified things a lot? Absolutely. I only wanted big round numbers anyway, and the truth of the matter is my simplifications pale in comparison to the assumptions. If you want the most accurate numbers possible, be sure to repeat the exercise each year with updated numbers and assumptions.

Let’s use more realistic assumptions like scholarships, work, and additional 529 contributions

You can make it a lot more complex if you want to be super realistic. For instance, I have no intention of paying for all of Whitney’s undergraduate education, much less her graduate education. I expect her to work and get scholarships to help pay for undergraduate, and take out a few loans to pay for medical school. I also expect to make some more contributions to her 529.

Let’s say I invest another $4K per year for five years into that 529. Let’s also assume she gets a half tuition scholarship and keeps it for four years. And earns $8000 per year by working during the summers and the school year. And lives cheaply and so cuts another $2K of the cost of attendance.

How much should be left in her 529 after completing her undergraduate?

First, let’s calculate what’s in there when she starts undergraduate.

=FV(8%,5,-4000,-34298.82,1) = $75,739.94

Now, let’s decrease the cost of attendance by $8,000 per year for her work, $2,000 per year for her frugal living, and $3,000 per year for her scholarship, or $13,000 per year. That adds up to $52,000. $94,087.48 – $52,000 =  $42,087.48

$75,739.94 – $42,087.48 = $23,652

That will probably cover the first semester’s tuition for medical school. Now I could also add in amounts that I intend to cash flow and additional amounts I may contribute to the 529 above and beyond the tax-deductible $4K per year I’ve been putting in there and maybe we could get her into her 2nd or even 3rd year of medical school before she has to start taking out loans. But if my intent were to completely pay for eight years of education, you can see that I would need to be putting a ton of money into that 529 for each of the next five years. And these schools are cheap compared to most.

Well, this post ran 1000 words. No wonder I couldn’t fit it into a tweet.

James M. Dahle is the author of The White Coat Investor: A Doctor’s Guide To Personal Finance And Investing and blogs at the White Coat Investor. He is the creator of Fire Your Financial Advisor!, a high-quality 12 module course with a little over 7 hours of videos and screencasts, a pre-test, section quizzes with answer explanations, and a final exam. The goal is to take a high income professional from square one, teach them financial literacy and help them write their own financial plan.

Image credit: Shutterstock.com

Prev

Medical school admissions: Patience is a virtue

February 11, 2018 Kevin 1
…
Next

The huge impact a dying infant had on this physician

February 11, 2018 Kevin 2
…

Tagged as: Practice Management

Post navigation

< Previous Post
Medical school admissions: Patience is a virtue
Next Post >
The huge impact a dying infant had on this physician

ADVERTISEMENT

More by James M. Dahle, MD

  • 8 ways to go broke as a doctor

    James M. Dahle, MD
  • How physicians can retire early: 7 steps to follow

    James M. Dahle, MD
  • A physician’s defense of active income

    James M. Dahle, MD

Related Posts

  • Is this cost-saving Medicare proposal doomed?

    Martha Rosenberg
  • What does Kelly Loeffler’s health plan do to coverage for preexisting conditions?

    Robert Laszewski
  • Open enrollment: It’s time to leave your insurance plan behind

    Andy Schoonover
  • The fight to save Howard University College of Medicine

    Vicky Li and Naveen Balakrishnan
  • How the science of learning salvaged my college career

    Elijah Hamm
  • Saving our mothers requires taking more than baby steps 

    Janice Phillips, PhD, RN and Gina Lowell, MD, MPH

More in Finance

  • Physician practice ownership: risks, rewards, and reality

    Paul Morton, CFP
  • Smart asset protection strategies every doctor needs

    Paul Morton, CFP
  • Why taxing remittances harms families and global health care

    Dalia Saha, MD
  • A physician employment agreement term that often tricks physicians

    Dennis Hursh, Esq
  • Why hospital jobs are failing physicians: burnout, pay, and lost autonomy

    Justin Nabity, CFP
  • Decoding your medical bill: What those charges really mean

    Cheryl Spang
  • Most Popular

  • Past Week

    • Why palliative care is more than just end-of-life support

      Dr. Vishal Parackal | Conditions
    • When life makes you depend on Depends

      Francisco M. Torres, MD | Physician
    • Guilty until proven innocent? My experience with a state medical board.

      Jeffrey Hatef, Jr., MD | Physician
    • Why medical notes have become billing scripts instead of patient stories

      Sriman Swarup, MD, MBA | Tech
    • How denial of hypertension endangers lives and what doctors can do

      Dr. Aminat O. Akintola | Conditions
    • A powerful story of addiction, strength, and redemption

      Ryan McCarthy, MD | Physician
  • Past 6 Months

    • Why transgender health care needs urgent reform and inclusive practices

      Angela Rodriguez, MD | Conditions
    • COVID-19 was real: a doctor’s frontline account

      Randall S. Fong, MD | Conditions
    • Why primary care doctors are drowning in debt despite saving lives

      John Wei, MD | Physician
    • New student loan caps could shut low-income students out of medicine

      Tom Phan, MD | Physician
    • Confessions of a lipidologist in recovery: the infection we’ve ignored for 40 years

      Larry Kaskel, MD | Conditions
    • mRNA post vaccination syndrome: Is it real?

      Harry Oken, MD | Conditions
  • Recent Posts

    • How value-based care reshapes kidney disease management for better outcomes [PODCAST]

      The Podcast by KevinMD | Podcast
    • Imagining a career path beyond medicine and its impact

      Hunter Delmoe | Education
    • What is professional identity formation in medicine?

      Adrian Reynolds, PhD | Education
    • A step‑by‑step guide to crafting meaningful research questions

      Julian Gendreau, MD | Physician
    • When recurrent UTIs might actually be bladder cancer

      Fara Bellows, MD | Conditions
    • How restrictive opioid policies worsen the crisis

      Kayvan Haddadan, MD | Physician

Subscribe to KevinMD and never miss a story!

Get free updates delivered free to your inbox.


Find jobs at
Careers by KevinMD.com

Search thousands of physician, PA, NP, and CRNA jobs now.

Learn more

Leave a Comment

Founded in 2004 by Kevin Pho, MD, KevinMD.com is the web’s leading platform where physicians, advanced practitioners, nurses, medical students, and patients share their insight and tell their stories.

Social

  • Like on Facebook
  • Follow on Twitter
  • Connect on Linkedin
  • Subscribe on Youtube
  • Instagram

ADVERTISEMENT

ADVERTISEMENT

  • Most Popular

  • Past Week

    • Why palliative care is more than just end-of-life support

      Dr. Vishal Parackal | Conditions
    • When life makes you depend on Depends

      Francisco M. Torres, MD | Physician
    • Guilty until proven innocent? My experience with a state medical board.

      Jeffrey Hatef, Jr., MD | Physician
    • Why medical notes have become billing scripts instead of patient stories

      Sriman Swarup, MD, MBA | Tech
    • How denial of hypertension endangers lives and what doctors can do

      Dr. Aminat O. Akintola | Conditions
    • A powerful story of addiction, strength, and redemption

      Ryan McCarthy, MD | Physician
  • Past 6 Months

    • Why transgender health care needs urgent reform and inclusive practices

      Angela Rodriguez, MD | Conditions
    • COVID-19 was real: a doctor’s frontline account

      Randall S. Fong, MD | Conditions
    • Why primary care doctors are drowning in debt despite saving lives

      John Wei, MD | Physician
    • New student loan caps could shut low-income students out of medicine

      Tom Phan, MD | Physician
    • Confessions of a lipidologist in recovery: the infection we’ve ignored for 40 years

      Larry Kaskel, MD | Conditions
    • mRNA post vaccination syndrome: Is it real?

      Harry Oken, MD | Conditions
  • Recent Posts

    • How value-based care reshapes kidney disease management for better outcomes [PODCAST]

      The Podcast by KevinMD | Podcast
    • Imagining a career path beyond medicine and its impact

      Hunter Delmoe | Education
    • What is professional identity formation in medicine?

      Adrian Reynolds, PhD | Education
    • A step‑by‑step guide to crafting meaningful research questions

      Julian Gendreau, MD | Physician
    • When recurrent UTIs might actually be bladder cancer

      Fara Bellows, MD | Conditions
    • How restrictive opioid policies worsen the crisis

      Kayvan Haddadan, MD | Physician

MedPage Today Professional

An Everyday Health Property Medpage Today
  • Terms of Use | Disclaimer
  • Privacy Policy
  • DMCA Policy
All Content © KevinMD, LLC
Site by Outthink Group

Leave a Comment

Comments are moderated before they are published. Please read the comment policy.

Loading Comments...