KateHorrell

Helping Military and Veteran Families Be Confidently Prepared for The Next Stage of Life

  • Your Military Family’s Confidently Prepared™ Life Binder
  • Military Scholarships
  • Your PCS Checklist
  • Military Separation Checklist
  • Military Retirement Checklist
  • Books and Resources
  • Speaking and Workshops

College Shopping? Do All The Math – Free Template!

19 August 2024

This post may contain affiliate links, from which I may earn revenue to support this free site. All opinions are my own, and I only promote products that I use and love!

FacebookTweetPinEmail

It’s August, and college tuition bills have been coming due all month. I am often surprised when people tell me, “I didn’t know how much the bill would be.” I’m such an over-planner that this seems foreign to me. But there are quite a few ways that it happens. There are also solutions. One is forecasting even before college starts.
While you can’t avoid every single surprise, you can gather as much information as possible to make the best possible financial decision that fits in your family’s budget. Even if you’ve already moved your kid into the dorms, you can plot out what the future will look like.

Before you get started, you need to figure out some sort of way to capture all the information. I use a spreadsheet, and you’re welcome to use my template as a tool to get started. You’ll need to make a copy, and then you can rearrange, add subtract, and do whatever helps you see the big picture.

There are three pages in the template. The first page is a place to gather the scholarships you think are good fits for the individual student. Then there’s a page to compare the costs of various schools. You’ll have to add in a column for any state programs you have. You can see that the example below includes a column for the Florida Bright Futures program.

College Costs

 

The last page helps you spread this information over all four years. You’ll want to duplicate this page to compare various scenarios in your college funding strategy.

Be Sure You Are Comparing Apples to Apples

Then, you need to know the school’s cost of attendance. While there is a generally accepted definition, you need to be sure that you’re comparing the same things between schools. It doesn’t matter what you pick, as long as you are consistent and it fits with your vision. For example, when we were doing the math for my daughter’s college search last year, she rightly pointed out that for some schools, I was including transportation and personal expenses, and I wasn’t including that for other schools. She was right, and at about $3,000, that could make a big difference! And don’t forget about fees…

In my template, you’ll see that I’ve only included tuition and fees plus room and board. If you want to include other expenses, add a column!

Find Out About Fees

Find the FULL fees schedule for the schools your considering. Not just the simple schedule on the pretty part of the school’s website, but the big old list of everything they can charge. You might find it in the college catalog, or you may need to Google “(name of college) fee schedule.” Here’s an example from one of the schools my daughter considered: https://www.sju.edu/studentaccounts/parents-students/tuition-and-fees As you can see, there are a LOT of miscellaneous fees at this school.

Variable Tuition Can Be A Surprise

Check to see if the tuition rate changes after a certain number of credits, or if you are in certain majors, or at any other point. If you can’t find the information, call and ask. Schools are not trying to hide this info, but it might not be obvious if you don’t know where to look.

For example, the University of Virginia has announced that it will charge an additional $2,700 in tuition to third- and fourth-year students in the College of Arts and Sciences, with a rolling introduction starting in the 2021-2022 school year. In another variation, the University of Texas at Dallas has two different tuition rates: a guaranteed tuition rate, which starts higher and remains the same, or a variable tuition rate, which starts lower but will increase each year.

Tuition Will Increase – But How Much?

Do some research into historical tuition increases at the schools you are considering. You should expect that everything will go up, every year, unless your child selects a school that guarantees not to increase costs. If they do go to a school with such a guarantee, find out WHAT costs are covered. Do an internet search for “(name of college) tuition increase” to see if there are any relevant news articles discussing the school’s financial situation and whether there is an expectation of big increases.

I calculate costs using a 3% increase for tuition and fees. You may need to adjust or down if you have more information. For example, maybe one of the schools being considered has locked tuition if you remain continuously enrolled. Or maybe you know your state is in a big budget crisis and higher education will be impacted soon. Every situation is diferent.

Use The Net Price Calculators

Every school (that I know of) offers a tool called a Net Price Calculator (NPC). If it isn’t obvious on their website, do an internet search for “(name of school) net price calculator. While the the NPC isn’t precise, it is fairly accurate for the vast majority of people. Run the NPC on a ton of schools. . . it can be really fascinating!

Have A Back-up Plan for Financial Aid

You need a back-up plan for all financial aid that isn’t automatically renewable. Need-based aid can vary from year to year, depending on a variety of factors, and you just never know which scholarships you’ll be able to earn each year. Merit aid typically has academic requirements like GPA for renewal. While it is absolutely fine to be optimistic about those forms of support, figure out what you’ll do without them BEFORE you made a college decision. It might be more loans, it might mean taking on another job, or even taking a year off of school – there are no wrong answers.

There are a billion strategies for finding the right financial fit for your kid. But you can’t know if it’s the right financial fit if you don’t have all the information. And frankly, that information isn’t always obvious. You have to do your own research, and your own math, to come to your own decisions.

If you’ve got a high school student, this stuff is essential. It’s not too late for current college students to forecast the rest of their program. If you know someone with a high school student, please share.

If you want some help with your college financial strategy, including making the most of your Post 9/11 GI Bill benefits, consider hiring me to help. You can schedule a free 30 minute call to discuss your family’s specific concerns by using this link to my Calendly schedule.

 

Kate
FacebookTweetPinEmail

Leave a Comment
Filed Under: Education

About Kate Horrell

Leave a Reply Cancel reply

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

It’s here! My award-winning book is available on Amazon.

  • Email
  • Facebook
  • Instagram
  • LinkedIn
  • Pinterest
  • Twitter

Support This Site

You may have noticed that I've removed ads from the site. But keeping it up and running costs money! Together we can help all military and veteran families thrive! Click here to make a donation. Thank you for your support.

Search

WELCOME!

Confidently Prepared!™

Hi! I'm Kate! Accredited Financial Counselor®, Chartered Financial Consultant®, and Military Qualified Financial Planner®. I'm also the spouse of a retired sailor and mom of four young adults.

Here at the blog, I talk about the financial issues that affect military families - pay, allowances, and benefits. Plus college stuff, landlording, moving, taxes. We cover a little bit of everything.

My goal is to give you the tools to make the best decisions right now, so you'll be confidently prepared for whatever comes next - whether that's a PCS move, transition to civilian life, or retirement.

So grab a cup of coffee, tea, or whatever makes you happy, and let's get to know each other.

Confidently Prepared™ A Printable Binder to help your military family be ready for whatever surprises life throws at you next.

Categories

  • Deployment
  • Education
  • Housing
  • Income
  • Kids
  • Landlord
  • Medical
  • Moving
  • Overseas
  • Pay
  • Personal Finance
  • Retirement
  • Scholarships
  • Spending
  • Spouse Careers
  • Spouses
  • Taxes
  • Transition/Separating
  • Tricare
  • Uncategorized
  • Veterans

Confidently Prepared!™

Home About Resources Contact/Media Privacy Policy
  • Bloglovin
  • Email
  • Facebook
  • LinkedIn
  • Pinterest
  • Twitter

Affiliate Disclosure

This site does contain advertising and affiliate links. If you click on an advertisement or link, I may be compensated. I only promote companies that I love and trust. Kings High Media/KateHorrell.com is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com

Disclaimer

Kate does not represent the Department of Defense, the Department of Veterans Affairs, or any government agency. This blog is strictly for informational and entertainment purposes only. The content on this site should not be considered professional financial or legal advice. I may receive compensation through affiliate or advertising relationships from products mentioned on this site. All reviews on this site represent the personal opinions of the author. All references to third party products, rates, and offers may change without notice.

©2025 Kate Horrell and Kings High Media. All Rights Reserved.