In the fall of 2000, ScrapperMom and I made our first big purchase together: We bought a puppy. As two engineers are apt to do, we researched this purchase to the Nth degree: What kind of dog? Who from? How much? Vet? Crate? etc…
When we finally took the plunge, we ended up bringing home an adorable 20 pound Great Dane puppy (from a reputable dealer…). Two years later, we decided that one 120 pound Great Dane was not enough for one household, and that our little deer (pun intended) needed company during the day, and so we made the mistake of bringing home another Great Dane puppy.
ScrapperMom wondered recently how the dogs fit into our financial picture, and Gather Little By Little spurred me on with a recent post about the rising cost of spending on pets.
Below is the result of the report I ran in Quicken to find out just how much we have been spending on our small horses:
Cost of Unconditional Love
| Category |
Cost |
|
| Vet |
$6,589.43 |
|
| Food |
$6,555.09 |
|
| Supplies |
$4,962.79 |
|
| Training |
$3,687.50 |
|
| Boarding |
$3,645.00 |
|
| Dogs |
$1,966.90 |
|
| Dog Walkers |
$1,362.00 |
|
| Doggie Day School |
$1,102.50 |
|
| Damage Repair Payments |
$218.16 |
|
| Registrations |
$209.74 |
|
| Books |
$171.43 |
|
| Supplements |
$155.15 |
|
| Dog Shows |
$132.45 |
|
| Fines |
$40.00 |
|
Total
|
$30,798.14
|
|
Yes, you read that right. We have spent thirty thousand, seven hundred, ninety-eight dollars and fourteen cents on our dogs since the fall of 2000.
For us, this was a shockingly large number on first inspection. That’s $335/month, on average, for the last 92 months. That’s a little over $11 per day. I can think of worse ways to spend $11, but I still felt that this spending was pretty high in the grand scheme of our general finances, especially when our budget in the “Dogs” category for the past year has only been carrying about $150/month.
My next step was to see how the spending varied over time, since there was definitely a dual (large) income, no kids period where a weekly trip to Petsmart was no expense spared. So I ran a new report:
This report is really inconclusive. On the one hand, it’s looks like spending has tapered off since about early 2007. This correlates with the birth of our daughter, so it’s really no surprise that we have paid less attention to our pooches (sorry, pups!) and consequently spent less on them. On the other hand, spending was way up as recently as the middle of 2006.
In looking at ways to cut spending in the future, I identified a number of categories that are not likely to see much new spending anytime soon: Dog Walkers, Day School, and the Dogs themselves. Additionally, there are some categories that are really not fair to charge to the Dog account, such as boarding, since this is really a vacation expense that gets budgeted for separately. A number of other categories don’t see much spending in the first place.
With the elimination of all of those expenses, we’re still at a $233/month average outlay. There’s a pretty good chance that we won’t be doing as much training, since we don’t have that much time anymore, and the supply bill should stay pretty low since most of the costs there were “startup” costs of ownership. That basically leaves food and vet bills. If you count only those two categories, we’re right down under the $150/month budgeted amount.
I’m sure that we’ll have to end up spending more than this per month, since we’ll inevitably have to buy supplies and other items in the coming years. Maybe we can look for ways to save on food and vet bills for now, and bump the monthly budget up to something like $175 and see how it goes.
How much do you spend on your pets? How much have you spent on your pets? What have you done, if anything, to cut costs on them? What is your cost for unconditional love?
In Part I of this series, I explained a way of creating a spending plan. Now we should look at how to put it and keep it in action, as well as how to fine tune the plan. Now that the plan is in place, I would like to make a very important point about spending plans:
Spending plans are not static.
Many people set up a spending plan and then begin to hate it, eventually giving up on it altogether, as they feel boxed into having to spend a certain way every month. This is simply not the case.
At the end of every month, I review my spending plan for the previous month and determine how closely my plan met reality. Since many of my plan entries are averages, I usually compare with my plan from one or two months earlier to determine whether the number in the plan is correct or whether it should be adjusted up or down. As long as I’m hitting the average over a number of months, I don’t worry too much: underages simply get swept into my money market account, and overages are absorbed by that same account. If, however, the number in the plan is no longer average, I have to adjust the entry for the next month’s spending plan. Of late, I have adjusted Fuel and Food up, and Electricity, DirecTV, and Auto Insurance down.
Since I’m using a simple spreadsheet for my spending plan, it’s easy to create a plan for the coming month. To do so, I simply copy the current sheet in the spreadsheet to a new sheet, and then rename the sheet for the upcoming month. In addition to the changes that may be necessary to some of the average categories, any special spending categories or extra expected income should be entered. If there is special spending (upcoming car maintenance, wedding present, etc.), it should be accounted for such that spending in another category is reduced to compensate. Ideally, debt and savings should be tapped only AFTER discretionary spending is reduced. In the same way, if you’ve got extra income this month, consider applying some or all of it to your debt snowball (sometimes referred to as “snowflaking”…) or to additional savings before applying it to discretionary spending.
We looked at the concept of “snowballing” debt reduction in my post Getting Out of Debt. My sample budget includes a number of items that should fit into a debt snowball plan. As time goes by and the first debt disappears, you need to update your spending plan to reflect this, as well as to apply the snowball payment plus the minimum payment from the paid off debt to the next debt on the list.
If you get paid irregularly, on a term greater than 1 month, or get paid irregular amounts, entering the income section of your plan can be tricky. Chances are that if you’re in this camp, you’ve already learned how to budget pretty effectively. But if you haven’t, there are a few ways to handle this. These solutions all make some assumptions that you have an idea what your average income will be.
- If you have enough experience with your income to be able to create an average, then you can enter this and work off of it as if it were one of the expenses discussed above. You will have to review this monthly to be sure that you’re not spending more than you’re earning.
- You can enter the full amount that you expect to make in the coming month. If this expected income is greater than average, allocate the difference to savings. If the expected income is less than the average, draw the difference from savings as if it were another source of income.
If you don’t know what your average expected income will be, then you’d better eliminate most of your discretionary spending until you get a better handle on your income.
In conclusion, it takes some time to set up a spending plan. Once set up, it becomes a living document that is pretty easy to maintain from month to month. A spending plan has proven essential to meeting my savings and debt reduction plans.
Click
here for actual spreadsheet.
“Budget” is a dirty word in many households, and it’s no surprise why. Budgets are hard to create, hard to keep, and nearly always imply sacrifice. So for the sake of being pleasant, I will refer to budgets in this post as Spending Plans. A budget is, after all, simply a way to spend and earn money on paper before you actually spend and earn it, and therefore the term spending plan makes more intuitive sense to me. Answers.com defines budget:
budg·et (bŭj’ĭt)
- An itemized summary of estimated or intended expenditures for a given period along with proposals for financing them: submitted the annual budget to Congress.
- A systematic plan for the expenditure of a usually fixed resource, such as money or time, during a given period: A new car will not be part of our budget this year.
The creation of a working spending plan frustrated me for many years, primarily because I was trying to create one using Quicken’s Auto Budget creation feature. The problem I had with it was similar to the problem I had with tracking spending in the past: Too many categories. I was being asked to figure out how much money I would spend on small things like a pair of sneakers simply because I had a Clothing:Men’s:Footware category in Quicken. So if I buy (1) $75 pair of sneakers per year, Quicken would fill in $6.25 per month for sneakers. Multiply this by dozens or a hundred other detailed categories and very quickly the whole thing become unruly.
As discussed in one of my first posts on Getting Out of Debt, one must first understand where his* money goes every month. Some things are easy to figure out: gather up your mortgage (or rent), auto loan, student loan, credit card, insurance, cell phone, and any other bills that are fixed monthly expenses. My list also includes things like Netflix, water, and internet access. List each of these items with the associated monthly payment. I use a Google Spreadsheet for this. You will notice that there are some discretionary expenses in here, and that’s okay for now.
Next, I went through the last few months of expenses in Quicken, and pulled out other essentials that aren’t necessarily the same cost from month to month or even year to year: food, fuel, pet care, utilities, etc. I put 4-6 months worth of each of these items on separate lines, and then averaged the each line to get a monthly expense. Utility bills usually have a 1 year rolling history of usage, so this can also be used to predict upcoming usage. Entering all these average or estimated expense creates a starting point.
The next thing I did was to look at expenses that occur on an annual basis: excise taxes on my vehicles, life insurance premiums, disability insurance premiums, Christmas presents, etc. I took each of these annual amounts and divided by 12 to figure out how much I need to allocate to each of these each month. I listed these next.
Last, but certainly not least, I have included my savings contributions. The last place inclusion should certainly not indicate the relative importance of these entries. Indeed, these may be the most important entries in the list under the “pay yourself first” mantra. If you already contribute to a 401(k) plan through payroll deductions, you may not need to even bother making an entry here.
Having entered most of your expenses (most discretionary expenses are still absent), it is now time to enter your income. For most of us, this will be rather easy since we get paid a fixed amount on a set period from few sources. Others with irregular and/or multiple source incomes will have to figure out a way to average this income to create a starting point for now.
Now add up all of the incomes and subtract all of the expenses. What’s left is what you can afford to spend on discretionary items. Is this number negative? If so, you had better go back through your expenses and start trimming until you get to at least zero. If you have an option to earn more income, that can help too. If the number is positive, then you’re already doing better than many people today. Now you need to decide if it’s positive enough to satisfy your wants during the month. The only way to change this number is to decrease other expenses or increase income. You have to weigh priorities against each other, and I strongly suggest that you contribute as much as possible towards consumer debt and savings. My sample budget spreadsheet includes a post-tax savings percentage calculator.
Congratulations! You have now created a budget! Next time we’ll look at how to tweak the budget to be closer to reality, as well as how to manage your budget going forward.
Please see Part II here.
*Too many Web 2.0 contributors would have written “their” (or worse “there”) here because of a political correctness fear of being labeled sexist. Personally, I prefer to use proper English, and “his” won the coin flip. In all likelihood I have made a grammatical or spelling mistake in this aside simply because it would be ironic.
I’ve written about snowflaking here before as it relates to debt reduction, and I want to add another thought on the subject. As I discussed in a recent post, ScrapperMom got a raise AND missed a paycheck due to some personnel problems at the payroll service that her company uses. ScrapperMom gets paid bi-weekly, and when she missed her paycheck, the fix was to pay her for 3 weeks on the very next week, rather than for 4 weeks on her next regularly scheduled payday. The result of this was to shift her pay schedule by one week.
In making this shift, she ended up getting paid on the first of May, which sets up May to be a 3 paycheck month. As most people who get paid weekly or bi-weekly know, there are 4 or 2 “bonus” checks per year by virtue of the fact that there are really 13 months worth of weeks in a year (in the same way that a typical pregnancy is 10 months of weeks instead of 9…). Most of us understand that a month is 4 weeks, but a calendar month can be anywhere from 4 weeks (non leap year February) to 4.43 weeks (any 31 day month). Those extra fractions of a week per 30 or 31 day month add up to an extra “month” over the course of a year.
If you got this far, you may be thinking, “So what?” Well, so what is that most people are used to living on 4 weeks worth of paychecks per month, and that means that the “bonus” month worth of pay is just that: bonus. So what should you do with this bonus? Personally, we will be using all of our bonuses this year to reduce the balance on our car loan. Our debt reduction plan, as well as our budget, do not include these bonus paychecks. By applying them to debt reduction we will accelerate the payoff of our car. Later, these payments will snowball into paying off our final outstanding credit card, and later still into our savings goals.
By leaving these bonuses out of our monthly spending plan, we give ourselves a bit more breathing room if we need it and a faster route to getting out of debt.
Do you have a plan for your “bonus” checks? How will you spend it? Leave a comment below and let us know!
My wife and I are big fans of Google Apps, a suite of office type applications that run in a web browser and provide such services as Calendar, Spreadsheet, Document, RSS Reader, Email, and more. We have been sharing a number of calendars for a few years now, which is a fantastic way to keep track of all kinds of appointments from any internet connected computer. More recently, we have been using Google Documents, including Spreadsheets to share all kinds of information.
Google Apps are fantastic for collaborating on a project. Anyone with a Google account can share a Google item with any other Google user. Each user can see the item, whether it be a calendar entry, spreadsheet, or Reader item, and depending on the level of permission, can also edit the item. Multiple people can even be working on the same document simultaneously, and Google will merge the concurrent changes as they are made and refresh the other participants’ views.
This functionality seemed perfect to become a key tool for tracking spending and budgeting. A major problem that we had with tracking spending was capturing odd purchases or dividing up single bills into multiple spending categories. Often ScrapperMom or I would purchase something online from a vendor whose name we would not recognize at the end of the month when I sat down with Quicken to review and categorize our finances. A Google spreadsheet seemed like the perfect place to record such a transaction, since it was accessible nearly everywhere by both of us. Some other typical entries include grocery bills that also include a cash back portion, or bank deposits that include multiple checks.
Another great use for a Google spreadsheet is a budget. I can view and reorganize our monthly budget from anywhere. At the end of the month, I simply copy last month’s budget to a new sheet, and then make some minor modifications, if necessary, to prepare the spending plan for the coming month.
Lastly, I use Google Calendar to alert me when bills, transfers, or paychecks are due. I also set up alerts to remind me to check bank balances to make sure that always meet my minimum balances.
What technologies do you use to keep track of your finances?
