Hey, I just met you, and this is Lazy... get these fast finance fixes and mail me, maybe?

How Much Do I Need to Save for College?

Written by

College Advantage Savings Growth

That's a question that my friend Kevin asked me probably around 3 years ago. It was a simple question. He had recently had a son and he wanted to put aside money to cover his education. Kudos to him for starting early. The question lead me to write this article: Saving for College – An Exercise in Depression. In hindsight, it was a total cop-out as I never did answer his question.

Today, I think I'm going to do better... hopefully a lot better.

I have a vested interest this time around. My own son is four weeks old today and I'm in Kevin's shoes (not entirely, but I'll get to that the end). I got in reminder about all this from CollegeAdvantage, the place I determined had the best 529 plan for my niece and nephew. Specifically their newsletter had this image on the right (click for a larger view). The part that caught my attention is the bottom that assumed annual deposits of $2,400. For all practical purposes (minus some interest compounding) that's $200 a month.

This didn't answer Kevin's question, but goes down the right track, giving me a good estimate of how much I'd have if I saved roughly $200 a month. However, it didn't tell me how much college was going to be when Little Man is 18. Without this information I really can't know how much to save.

When in doubt, I fire up Excel and get nerdy with some math. Here's what my Excel spreadsheet looks like (click for larger) and I'll explain what I did here:

College Costs

On the right you'll see three headings with numbers below them, "Monthly, Interest, and College Increase." These are the main variables that I'm playing with here. If I save $674 a month (more on that seemingly random number later) and earn 6% interest I'll have the amount at the bottom of the "Interest" column under the Savings heading. The Interest column represents how much money I'd have at the end of year assuming deposits and interest. I could have titled this column better, but that's the beauty of Excel, I'm getting to the numbers quickly. For fun I've totaled up the amount of actually cash I'd be putting aside by saving $674 a month. So putting $145,584 over time yields me $350,957 when Little Man is 21. I didn't factor in taking the deductions out of this to actually pay for college, so there's room for improvement here. It is important to remember that this is an estimate and there's no guarantee of earning 6%.

Now let's turn our attention to the right column of College Costs. Using the "College Increase" value, I can estimate how much college might cost Little Man at age 18. The 4% is just a best guess. Ideally, I would know how much college costs are expected to go up over the next years. Perhaps some research group has a good answer there. I settled on 4% because quite honestly, if you put a 8% number in there the last year of private college is $212,000. I don't see that happening. Even at 4% the last year being $96,000 looks pretty daunting. However, in 18 years it might not be. I've totaled up the last four years of the college costs and you can see that public college is likely to cost around $184,500 with private school costing $363,000. Now it becomes a little clear where that $674 a month came from... that amount gives me the $350,000 range that covers 4 years of private college.

The last piece to the puzzle is where did I get the information for the public and private school costs to start with right now? The answer is Collegeboard's annual estimates. They did all the heavy lifting give me a number for how much an average public or private college would cost with most of the typical fees rolled in.

So now that I've gone through all this math, let me make things easy for you. Saving for College has a College Cost and Savings Calculator, which is dead simple. You just put in a child's age and it tells you a number that you need to save. I put in $0 just now and it came up with a $602 number that I have to save each month. From there, you can adjust the scenarios just like I could with my Excel spreadsheet. If I had seen this calculator first, I would have skipped the spreadsheet, but the spreadsheet does give me helpful checkpoints. When I did it a couple of weeks ago, I believe that number was $674. When I plugged that $674 number into my Excel spreadsheet things started to fall into place.

The calculator from Savings for College also has a lot of other valuable information. For example, it assumes a 6% cost of college increase using historical information. The 4% assumption in my spreadsheet looks to have been an underestimation. If that stands true, the last year of private school for Little Man is going to cost $143,543. Zoinks!

There are still a few different factors at play here. Going back to the CollegeAdvantage chart, there are taxes to consider, but 529 plans can help with that. If you are saving in a regular brokerage account, who knows what long-term capital gains are going to be at that time? Again, you just take your best guess and adjust as you get closer.

Now for the fun part... I get to throw most of this research in the trash. It turns out that Little Man appears to be eligible to get free public education thanks to my wife's GI Bill with the military. I knew that it was a tremendous benefit, but this exercise has put it in a whole new light.

Posted on October 24, 2012.

This post deals with:

, ,

... and focuses on:


Don't forget to these five minute financial fixes to save thousands!

8 Responses to “How Much Do I Need to Save for College?”

  1. I’m curious how many people are intending to foot 100% of the bill for their kids.

    I came from very modest means, and as a result, it was up to me to finance 100% of my college education.

    I think the experience was good for me, and that your focus is often better when you have some “skin” in the game. I definitely want my kids (age 5 and 3) to share some of the cost.

  2. Lazy Man says:

    Yeah, the how much should you pay is an entirely different topic. I thought about addressing that at the end of the article, but it was long enough without getting on that tangent.

    I agree with you on this having skin in the game. I got a full scholarship and I know I was willing to skip a few classes as long as the result was the degree. My wife had to foot much of the bill herself and she wasn’t skipping any of the classes she paid for.

    Let me ask this… how much is a good split of the costs?

  3. Around here, it seems common in divorce decrees to have each parent be responsible for 1/3 and the kid also be responsible for 1/3. It might even be a law – I have no idea.

    So maybe 1/3 could be a starting point for the discussion.

  4. Cassi says:

    I am a senior in high school, so this is practically my life right now. My family was always too poor to save money until recently, so I don’t have a college fund and have to rely on scholarships. College prices are insane now days, and I hope something changes so your 4 year old doesn’t have to go through what I am currently going through.

  5. Lazy Man says:

    Funny that you should mention that 1/3rd number. I was thinking of suggesting that parents do a 200% match for funds added by the child, which comes out to be the same thing.

  6. Lazy Man says:

    Thanks for you comment Cassi. I’m surprised to hear the story having followed your aunt for some time.

  7. […] How Much Do I Need to Save for College? – A new dad runs the numbers and learns that, under his assumptions, a flat $674/month (starting at birth) should do the trick. The assumptions may or may not be right, but the process is instructive. […]

  8. […] Man @ Lazy Man and Money writes How Much Do I Need to Save for College? – Saving for College has a College Cost and Savings Calculator, which is dead simple. You […]

Leave a Reply

Your email address will not be published. Required fields are marked *

Previous: The Best Baby Gear I’ve Found (So Far)
Next: Fun Things You Could Buy with a Million Dollars
Also from Lazy Man and Money
Lazy Man and Health | MLM Myth | Health MLM Scam | MonaVie Scam | Protandim Scams | How To Fix | How To Car | How To Computer