Setting reasonable goals is an important part of financial planning. However, many people struggle with determining what constitutes as “reasonable” and end up with stupid goals instead. We all have a tendency to dream big without actually planning or executing big, but there’s a way to stop setting yourself up for failure. I find shorter timelines are the answer to making and achieving goals. A short timeline necessitates a reasonable goal as well as provides a sense of urgency.
Below is a chart I regularly use in my own financial goal setting:
Because I’m often managing multiple goals, I like to track them in one place so I know how much reaching for all of them will cost me — otherwise it’s so easy to think “I’m only saving $50 for this per month!” but if you’re doing it for 6 different goals you might end up feeling financially strapped.
Want the table for yourself?
I made the table using NUMBERS for Mac, but wordpress is currently not letting me upload the document. However…
Now I’ll walk you through it. The first thing you want to do is put in what you’re saving for, the interest/return rate on that account, what you currently have saved (it’s ok to set to $0!), and how much you plan to contribute per month.
From my example you can see I’m starting with $6,000 and plan to save $604 per month (note: not real numbers!). The table will auto-populate with the data changes based on your inputs, but we’ll revisit that in a sec. The next step is to set your goals for each account by inputing them at the bottom of the table:
Now the table might be doing wonky things based on how I’ve manipulated the formulas in each cell. Here’s what’s happening:
If you’re not saving enough each month for one of your goals, the “gap” cell will turn red and display the amount you’re short of this goal. In this example, I set the monthly saving of the Emergency fund to $80 a month, and now there’s a $25 gap between my goal and the amount I will actually finish with at the end of 24 months:
$80/mo is not enough to save in order to meet my goal of having $3,000 in my emergency fund at the end of two years, so let’s say I increase my savings rate to $82/mo by changing the monthly contribution at the top of the table:
Two things happen as a result: the number in the Gap row is now green, indicating that I’ve over-saved by $23 and some of the cells in that column have turned green:
From the green-colored cells I can see that I’ll have met my goal. Always nice to be ahead of schedule instead of behind!
If I want to use this table for tracking my savings as well as planning, I edit the values in the appropriate cell at the end of each month. For example, when I click on the cell for January, the formula is as follows:
But if I actually had $1,100 in that account instead of the $1,083 the table predicted, I will change that and enter my value:
The rest of the table will auto-populate with the new calculated values:
This way, you can go in to the table at the end of every month and enter in your new value and it will update the rest of the cells accordingly, and you’ll be able to see right away if you’re on track, behind or ahead of schedule — and you can adjust your monthly contribution accordingly.