Showing posts with label yearly recap. Show all posts
Showing posts with label yearly recap. Show all posts

Thursday, January 10, 2008

2007 Expenses vs. Budget

2007 was a weird year for expenses. Not as weird as last year, when I went from being a renter to a homeowner (with a phase of quasi-homelessness in between). But this year, I still had some adjusting to do, and it will probably come as no surprise to anyone that I went well over budget!
Here's the data:

Category Actual Budget Variance % Var
Taxes $29,070 $24,504 $4,566 19%
Housing $19,241 $16,812 $2,429 14%
Dining $7,984 $7,200 $784 11%
Household $7,980 $600 $7,380 1230%
Travel $3,354 $4,032 -$678 -17%
Clothing $2,940 $1,800 $1,140 63%
Misc $2,478 $1,500 $978 65%
Utilities $2,445 $2,400 $45 2%
Gifts Given $2,300 $1,200 $1,100 92%
Gym & Fitness $1,199 $1,200 -$1 0%
Medical $1,029 $1,227 -$198 -16%
Subscriptions $969 $924 $45 5%
Education $421 $540 -$119 -22%
Charity $343 $300 $43 14%
Home Insurance $320 $400 -$80 -20%
Entertainment $291 $600 -$309 -51%
Home Repair $290 $0 $290 n/a
Bank charge $78 $72 $6 8%
Total Expenses $82,622 $65,311 $17,311 26%


A few notes:
  • Taxes: My income went up slightly, and I got a bigger bonus than expected, so taxes were higher.
  • Housing: As I've mentioned before, my property taxes were out of whack as a 421a abatement hadn't kicked in yet. Also, this figure does not include the portion of my housing costs that goes towards my mortgage principal, as at least by some reckonings, that is money that I still have in my net worth in the form of home equity. I do include this part of my housing cost when I am looking at monthly spending budgets, though, since I do have to make sure I have the cash to pay it!
  • Dining: Always my bête noire, dining continued to be a big expense this year. I am happy to report that I do not weigh 14% more than last year, though.
  • Household: As you can see, I was still buying furniture and various items for my new home. The biggies were a bed and mattress, a bookcase, and DIY custom closet shelving. This category also tracks little things like laundry.
  • Travel: My big New Zealand trip was actually not that expensive, since I used frequent flyer miles for my ticket.
  • Clothing: I really needed some new ones, considering I didn't spend much on clothes last year. Also, I became single again and needed to start thinking about more colorful feathers with which to attract a mate.
  • Miscellaneous: This was mainly thrown off by my purchase of a new Treo and some related accessories.
  • Gifts Given: This includes a $1,000 savings bond purchased for my nephew, which won't be an annual occurrence.
  • Entertainment: Funny, I didn't spend much but I haven't felt the least bit bored this year! I think I budgeted higher after buying theater tickets last year, but this year I didn't do anything that expensive and mainly entertained myself by reading free books!
  • Subscriptions: I subscribed to a couple new magazines in order to get some decorating ideas, but I've let them expire without renewing, as I didn't find them that valuable. One of them was Martha Stewart's Blueprint magazine, which I just heard has folded anyway-- good thing I didn't renew! The person who told me this said they would have substituted another Martha Stewart magazine for the rest of the subscription. I had to laugh at the idea of getting a forced subscription to Martha Stewart Weddings! What would my mother say if she came to visit again!?!?
  • Charity: I had wanted to increase my giving a bit, and did so. (This doesn't include the donations I do with all the proceeds from this website.) I still don't feel like I'm giving a huge amount, but I think I'll be in a position to prioritize that more later in life.
  • Home Repair: You're probably thinking "huh? She lives in a brand-new home, what could possibly need to be repaired already?" This category might overlap somewhat with Household, but I had intended to use it to track things that would go towards the cost basis of my home if I were to sell it. These are supposed to be things that permanently increase the value of your home, that can't be taken with you when you move. The IRS doesn't seem to give any more specific guidelines, but I may have to go back over my receipts from Lowe's and Home Depot, etc. to see what really counts and maybe recategorize some things.
  • Bank charge: I thought that seemed high until I remembered that I pay an annual fee for my credit card, which is now $60. That seems kind of annoying but I do earn a ton of frequent flyer miles on that card, and use them for things like tickets to New Zealand which cost way more than $60.


Stay tuned for some further analysis on how my spending changed from 2006 to 2007, and how I'll finalize my budget and goals for 2008.

2007 Income

Here's how much money I made in 2007:

Salary $91,029
Investment Income (div, cg, etc) $19,001
Bonus $10,500
Other Income $5,496
Tax Refund $2,844
Gift Received $1,645
Interest Income $1,163
TOTAL INFLOWS $131,678


Notes:
  • As I'd previously mentioned, it was very nice to finally hit a six-figure income this year. My total income including investment dividends, etc. was over six figures last year, but that is not the same as seeing a number over $100,000 on your final paystub! I wish my salary alone was over $100k, but that will take another couple of years, I think, and in the meantime, I'm happy to have a bonus that makes up the gap, assuming it's big enough to do so again next year!
  • All the investment income-- dividends and capital gains-- ends up being reinvested in either my 401k or my E*Trade investment account, so I don't think of it as spendable income.
  • Other Income is mostly my employer's matching contributions to my 401k.
  • A tax refund doesn't really feel like "income" to me, but that is how Quicken categorizes it.
  • $1,000 of the Gift Received line is a check given to me by my mother, which I see more as money that I am holding in trust for her, in case she gets into debt again. (backstory here)
  • I am not including the (very modest) ad revenue this site generates, as I have been donating it to various charities.
That's the scoop-- coming soon will be a post on my 2007 expenses.

Tuesday, January 08, 2008

Year-end Net Worth

It was a squeaker, but I made it!
I was so depressed the other night when I was looking at my net worth in Quicken and seeing a figure of about $349,300. I knew all my salary and credit card transactions had been entered for the year, and the interest on my main bank accounts. I was bummed out that my net worth was below my $350,000 goal, and nowhere near my $370,000 revised goal that I set mid-year. When I got to work the next day, I remembered to check Paypal and another bank account, and sure enough, I had a little more interest but not enough to save the day. My last hope was that my investment accounts would be showing some pretty nice dividends in December, and sure enough, they managed to save the day! Here's how things ended up:

ASSETS:

Cash and Bank Accounts

  • Cash $119
  • Chase CD 6 mo. $3,054
  • Chase Checking $179
  • Chase Savings $5,018
  • E*Trade 2-Yr CD $5,972
  • E*Trade Money Market $5,021
  • E*Trade Savings $12
  • FNBO Direct Savings $11,104
  • Laundry Quarters $6
  • PayPal $152
  • Misc foreign currency $30

Retirement
  • 401k $195,613
  • E*Trade Roth IRA $23,453
  • Chase Roth IRA CD $3,037
  • Chase Roth IRA CD $2,639

Investment
  • E*Trade $17,255
  • Treasury Direct & Bonds $4,583

Other Assets
  • Condo equity $84,620


LIABILITIES:

Credit Cards
  • Visa $1,859


Net Worth as of 12/31/07: $360,008
+$7,331 (up 2%) in December
+$47,237 (up 15%) for the year.



A few notes:
As usual, I am showing the equity I have in my condo, rather than breaking out its value and the balance owed on my mortgage. I haven't adjusted the value of my condo up or down since I initially determined the number last year after I moved in. Despite the rocky real estate market, I think my valuation is probably slightly conservative, but I'm going to sit tight until I see more condos similar to mine being sold in this area. The rest of the accounts are pretty self-explanatory, I think.

Overall, I feel okay about my result at the end of this year, but now that more and more of my net worth resides in assets other than cash, it's hard to use net worth alone as a goal. If I wanted to, I could reasonably assume that my condo is worth $10,000 more and say I'd met my goal of $370,000 net worth. Or I could look at the peak prices of my stocks and mutual funds this year and say that if they hadn't fallen from there, I "would have" made my goal. Neither of these things would change how much money I managed to save or spend or earn this year, which is more important.
I can't just compare the total for my "cash and bank accounts" group to try to break out the investment fluctuations, since I moved some money between that group and the retirement and investment groups. So where did the gain in my net worth come from? Here's a few factors:

  • My 401k statement says my rate of return was 6.8% for the year.
  • My main E*Trade account was up 8.4%, and my Roth IRA at E*Trade was down 9.5% for the year. (The S&P 500 was up about 3.5% for the year.) I think have to make some changes in that Roth IRA portfolio-- it's never done all that well, but this is ridiculous.
  • I had a little more than $20,000 of interest and investment income from all accounts for the year. This includes dividends and capital gain distributions which were reinvested. I was kind of amazed at this number, and it really shows you how important it is to build up capital! It's not like I'm anywhere near the point where I could live off my investment income, but it's encouraging to feel like I'll get there someday! And to put this in perspective, it was only 16 years ago that my gross salary was less than $20,000...
  • I had about $5,500 in "other income" this year, which is mainly 401k matching contributions from my employer.
  • My "savings," as defined as salary and bonus earnings minus my expenses, not counting what went into equity on my condo, was about $18,500. (Of that, $15,500 was from payroll deductions for my 401k.) 2007 may mark the first time I ever made more from investments than I saved in cash!

Looking at all the factors that contributed to my net worth increase has been helpful-- it's made it easier for me to start thinking about goals for 2008 in terms of things that I can actually control as well as outside factors like market performance. But that is a topic for another post! Until then, onward and upward!