Financial Projections: Where Will You Be In 5 Years?

This one is more for the nerds than the free spirits. Let’s face it. The nerd inside of us loves to project our financial futures. We whip out those budgeting spreadsheets and plug in the numbers into our custom-made formulas. Mostly it’s just for fun, but it can be very beneficial to see which direction we’re heading in life. Every few months I check my family’s financial course and with some financial projections and then adjust as needed. This is the process I go through when I project our future – and so far it’s been reasonably accurate!

First Steps: Gather The Data

It’s time for a scavenger hunt. Before you start crunching numbers, you’ll need several tools and pieces of data in order to get started. Some of these will be easy to find, others might take some time. If you’re missing one of these elements, your projections won’t be as accurate. Don’t skimp on these items!

Gather the following:

  • A computer. Good news! You’re looking at it!
  • At least 6-months of records showing your income and expenses. A year’s worth is preferred. If you’ve been keeping a regular budget, you’ll most likely find this information. If not, turn to your bank records – your online bank account is a great place to look!
  • A calculator. Of course you could use your computer’s software-based calculator, but I recommend a separate push-button calculator for fast entry.
  • A word processing document and spreadsheet application. I’m on a Mac, so naturally my favorite applications are “Pages” and “Numbers,” but Microsoft Word and Excel will do just fine. 😉
  • Your spouse! If you have one, you’ll need yours right beside you.

After you have these items, you’re all set! It’s time to sit down and get started. Let’s begin.

The Way I Project Into The Future

Let’s be perfectly clear about the purpose behind projecting into the future. It’s not to show off your mad number-crunching skills, and it’s certainly not something to count on more than God’s plan for your life. The only purpose for projecting your financial future is to get a glimpse of where you’ll probably end up if you continue on your current financial path. With that being said, let’s take a look at the variables that come into play when projecting your future.

Future variables:

  • Change in income or expenses. If you think that a new job or major expense is coming your way, make sure to mark it on your financial timeline. It can help to create a spreadsheet with the months of the year along a left-hand column and type any events along that timeline that you expect would change your calculations.
  • Goal transitioning. When you’re on a financial plan, you’ll have several points at which you change how you’ll spend your money. For example, one of your first goals might be to pay off debt. After that, you’ll transition to building your emergency fund. When you make this transition, where you have money saved will change. Write these variables in your spreadsheet.
  • Unknowns. To have a conservative estimate of the future, you’ll want to account for unknown expenses. This could be emergency spending or a drop in income. Project a 5 to 10% productivity loss due to unknowns.

Now that you understand some of the variables that come into play, you’ll be able to start projecting into the future using averages. Here’s how:

  1. Average out your income over the past 6 months to a year. Write that down.
  2. Average out your expenses over the past 6 months to a year. Write that down as well.
  3. Find the difference between those two averages and write that down. This number will be how much money you can have dedicated to each of your financial goals such as getting out of debt, building your emergency fund, paying for college, or getting braces for the young ones! You got the idea.
  4. Ask yourself where you’ll be next month, the month after that, and so on. Adjust as needed to based on your future variables.

I find that the farther I try and predict my financial future the worse the prediction. After all, we really don’t know what the future holds. But it is important to try and see where we’re going in life. Once you’ve projected where you’ll be in 1 year, 5 years, or more, ask yourself if you like where you see yourself at that point in time. If you don’t like what you see, what actions can you take today to change the direction of your life?

So I ask you . . . do you like what you see? How are your financial projections? Let us know in the comments below!

Ready to Quit Living Paycheck-to-Paycheck?

Just click to join 163,000+ others and take our FREE email course to better manage your money, pay off debt, and save!

  1. MoneyMan @ FinancialOdyssey

    I love doing this but I always have a hard time. I’m in college still and will graduate in December 2011. I have no idea what kind of salary I will be making or how long it will take to find a job. How would you work this into a 5 year projection? I usually end up just projecting what my finances will be like based on my current income.

  2. Easy Personal Finance

    I agree with John. Keep in mind that at least one spouse/partner should also track daily transactions to keep you both on track.

  3. Tim @ Faith and Finance

    I love your call to action John : If you don’t like what you see, what kinds of things can you do to change it?

    Many times projections can easily be attained if you actually make it a goal and have a plan to reach that goal.

    My wife and I just worked through a financial projection for next year and we’re hoping to knock out 20k of student loans! It’ll be a stretch, but with a little planning and a lot of focus, I think we can do it!


  4. Derek

    My wife and I began our lives together with practically nothing; well, actually, less than nothing because of debts. We have managed to knock $7,000 off our debts since January and we’re hoping to cancel out our remaining debts within the next 6 months. Without dramatically changing our lifestyle, we should be able to invest well and purchase a home free and clear within the next 5 years. I can’t wait!

  5. Terry

    I’ll be wherever God wants me to be. It’s not for me to determine my future; all things are in God’s hands.