1. Unleash the (CFPB) Hounds!

    For the three of you who are still wondering just what the heck the new Consumer Financial Protection Bureau (CFPB) is all about, well, I direct you to this fancy CNN Money presentation:

    CNN Money: The New Pup Watching Our Money

    I’m sure this new agency will cast just as watchful, keen, and vigilant an eye over our money as all the other government agencies do. I mean, this was Elizabeth Warren’s brainchild, so it has to be good, right?

    (If you think I’m being sarcastic, congrats! You’d win a cookie … if I had one to hand out.)

    And, in what has got to be one of the most pathetic “Reasons We Need This New Government Agency” passages I’ve yet seen, I encourage readers to mouse-over the red “16,109” circle in the “Mortgage Brokers” section of the CNN presentation. Read what Mr. Carlo Panno has to say about the “sack of money” the evil bank all but forced him to take to buy a house.

    Always the studious type, Mr. Panno carefully read his mortgage docs before signing them … noticed that his payments would balloon from $300/biweekly to $1000/biweekly after two years … and then STILL SIGNED THE NOTE because the broker “assured him” he could refinance before the two-year SAVINGS EXTRAVAGANZA expired. (Heard that one before? Yeah, me too. About a million times.)

    You know what I think? I am quite certain that there is not, and never will be, a government agency capable of protecting glasslickers like this from themselves. (Much less those dastardly banks and mortgage brokers — for whom, I should point out, I harbor scarce love.)

    Note to Mr. Panno: Next time you leave the house, don’t forget your helmet.




     

     

  2. Travel On the Edge

    As a guy who believes in keeping at least $50 in cash on me (plus the usual credit and debit cards) whenever I’m out and about, I simply do NOT understand why anyone would GO TRAVELLING WITH ABSOLUTELY NO CASH ON HAND.

    And yet, in the auto-service business, I see people doing this fairly often. Typically it involves someone’s vehicle breaking down, leaving them stranded — at least for a while — somewhere far from home. When this occurs, what are they carrying in their wallet or purse?

    A driver’s license, a debit card, some photos … and that’s it.

    Seriously?

    Can people just NOT think ahead at all? Does anyone play “What if?” before heading out across the state?

    What if you’re 500 miles from home, and, for who knows what reason, your debit card doesn’t work? With no credit cards in your wallet, and no cash, what will you do then?

    As I’ve said for years, debit cards are often NOT your best friend. I love my debit cards, but they’re certainly NOT a foolproof payment method when travelling.

    (And no, I don’t care what Dave Ramsey says about “All you ever need is a debit card.” I, for one, try not to live my life at the mercy of my bank’s change-on-a-whim debit-card policies.)

    Big Tip: Always Have More Than One Way To Pay

    As I mentioned in a 2007 post, I consider it vital that we ALWAYS have more than one way to pay. Whether “Plan B” is cash, credit card, or debit card, I don’t much care. I just make sure that there always IS a Plan B. And that goes for quick trips to the corner store as well as cross-country jaunts.

    So much that happens in life is out of your direct control. Doesn’t it make sense to exhibit some control where you can, and always have a backup method of payment?

    It sure does to me!




     

     

  3. More Credit-Card Debt Needed

    Last week we established that debt lifts young folks’ self esteem. The next step along this ridiculous path, of course, is that our struggling economy needs — wait for it — more credit-card debt.

    USA Today: More Credit Card Debt Might Be Good…

    I find this line of thinking fascinating, really. No one has any money; no one has any savings to speak of; no one is spending; thus, the economic recovery is faltering. The answer? More debt. That’s what it’ll take to get people spending now.

    Forget saving money and slowly repairing Joe Sixpack’s household balance sheet, so recently decimated by house-price declines and more than ten years of rollercoastering stock markets. No, what’s important is that those credit cards come back out and start lighting up cash registers again.

    Yeah, that’s the ticket.

    And I’m particularly enthralled with this last chunk of the article. Here we’re introduced to a Houston couple who’ve decided, apparently, that carrying $15k in plasti-debt is no reason to not “go get some stuff” again:

    Some are loosening up. Amy and Brian Stonesifer of Houston halved their $30,000 in credit card balances the past year after their interest rates soared and Amy, 45, began worrying about her job security at a promotions firm. But after a year of scrimping, they recently charged new clothes, a grill and other non-essential goods. “We just got tired of not having things,” she says.

    Only in America would you find someone who’d rung up $30k in credit-card debt lamenting the sad, sad state of “not having things.”

    My question: Which one of Dave Ramsey’s Baby Steps says to reduce your credit-card debt by half — to a level that’s still five digits’ worth, mind you — and then go out and charge a grill and some Dockers at Target?

    Hmmph. I totally missed that one.




     

     

  4. Survey: Debt Gives Young Adults Self-Esteem Boost

    I suspect that most of this has to do with the fact that young people tend to feel “invincible,” but it’s pretty interesting nonetheless:

    OSU: Young Adults Get Self-Esteem Boost From Debt

    From the article:

    For this study, the researchers examined data on two types of debt: loans taken out to pay for college, and total credit-card debt. They looked at how both forms of debt were related to people’s self-esteem and sense of mastery – their belief that they were in control of their life, and that they had the ability to achieve their goals.

    …Researchers found that the more credit card and college loan debt held by young adults aged 18 to 27, the higher their self-esteem and the more they felt like they were in control of their lives. The effect was strongest among those in the lowest economic class.

    Only the oldest of those studied – those aged 28 to 34 – began showing signs of stress about the money they owed.

    If anyone wondered just why it is that lending institutions make such an effort to get young adults into debt, well, wonder no more. You can build up an immense pile of debt between the ages of 18 and 28. By the time the invincibility of youth has worn off and reality has set in, your next 20 or 30 years of payments are already set in stone.

    Then, when that “expected future income” thing doesn’t pan out, you get a host of nasty little outcomes — like one in five student loans being in default.

    More from the study:

    But how debt affected young people depended on what other financial resources they had available, the study found.

    Results showed that those in the bottom 25 percent in total family income got the largest boost from holding debt – the more debt they held, both education and credit card, the bigger the positive impact on their self-esteem and mastery.

    Those in the middle class didn’t see any impact on their self-esteem and mastery by holding educational debt, perhaps because it is so common among their peers that it is seen as normal. But they did see boosts from holding credit-card debt – the more debt, the more positive effects.

    Whoopee. And the debt-induced beat goes on … so long as you get ’em hooked young!

    EDIT: A more in-depth opinion on this study can be found right here . . ..



     

     

  5. Can You Come Up With $2k in a Hurry?

    Sure, the data is a couple of years old, but I don’t doubt it a bit:

    WSJ: Nearly Half of Americans ‘Financially Fragile’

    According to the study, roughly half of Americans reported that they “probably” or “definitely” could not come up with $2,000 if needed within 30 days.

    From the WSJ:

    The survey asked a simple question, “If you were to face a $2,000 unexpected expense in the next month, how would you get the funds you need?” In the U.S., 24.9% of respondents reported being certainly able, 25.1% probably able, 22.2% probably unable and 27.9% certainly unable.

    Other recent, similar surveys have told us that more than 3/4 of us live paycheck-to-paycheck, and 27 percent of us have no personal savings. So it’s not as if this WSJ article’s story is a surprise.




     

     

  6. No Good Deed Goes Unpunished

    Wow. This story struck me harder than probably any other (of the personal-interest variety) within the last several months:

    WFAA (Dallas): Dallas Keeps $2k Found by Honest Teen

    Seems that 15-year-old lass Ashley Donaldson stumbled upon two thousand dollars in a Dallas parking lot last February. With a level of honesty that I imagine many folks don’t possess, Ms. Donaldson turned the money in to a local bank, “lost and found” style. From the article:

    The 15-year-old Shepton High School student spotted the money on the ground and took it to a nearby Chase Bank.

    Over the last three months, the bank and Dallas police have tried to find the owner, but have had no luck.

    On Tuesday, police said under a new city policy, the unclaimed money will go into Dallas’ general fund — not back to the person who found it, as in years past.

    Ummm … excuse me? To the city’s general fund? What what?

    “We appreciate your honesty,” said Dallas police spokesman Senior Cpl. Kevin Janse. “We’re going to put the money to good use. It’s not going to be wasted, but put to good use for the City of Dallas.”

    A fine kick in the pants that is. Well, at least we can state that Ms. Donaldson learned a fine lesson from this: Never trust the government.

    An expensive lesson, to be sure, but one best learned at age 15, I guess.

    Story Update (One I Really Like)

    I can freely admit that I was fairly ticked off after reading the story above. But it turns out my peeved-ness didn’t last long:

    WFAA (Dallas): Anonymous Donor Helps Honest Teen

    While it isn’t exactly the ending I would’ve chosen, this one will do:

    In February, Ashley found $2,000 in the parking lot at the Pavillion Center in North Dallas. Instead of keeping it, she turned it in, thinking she would get the money back if it was not claimed.

    Three months later, under a new policy, the City of Dallas told her the unclaimed money will go into a general fund and not back to the finder.

    But an anonymous donor from Fort Worth has stepped in a check for $4,000 to reward Ashley’s honesty — and to help her family.

    It’s worth noting that the Donaldson family — four siblings and two parents — were living in a one-bedroom apartment at the time that Ashley found the two thousand dollars. My admiration for her (and her parents’) honesty is about as stout as it could be.

    At school on Wednesday, Ashley said her teacher turned on a TV news report about her discovery. “It just really made me think of how many people would’ve done the opposite thing, and it made me feel even more proud of myself,” she said, adding this:

    “Stand for what you believe is right, no matter what anyone says, no matter what they might think, it really doesn’t matter. You have to know that you did the good thing.”

    And also that right after you’ve done your “good thing,” the government will be along in about five minutes:

    “We’re from the government, and we’re here to help.”




     

     

  7. Thinking of Strategically Defaulting?

    Well, you’ll be happy to know that the guys behind FICO are watching you:

    USA Today: Study: Underwater Homeowners Are Credit Savvy

    I’m not sure why a study was needed to figure any of this out, because it seems fairly obvious that “strategic defaulters” aren’t your typical Joe and Jane Sixpack. The very word “strategic” sort of implies that, yes?

    Ah well. Fair Isaac just wants to cover all the angles, I guess.




     

     

  8. Effective Tax Rate, 2010 Edition

    Each year, once I’ve completed and filed our income taxes, I like to spend a little time calculating my household’s effective tax rate. What’s an “effective tax rate,” you ask?

    Well, it’s a way for me to get outside of the usual “What tax bracket are you in?” thinking that so many folks seem mired in. Yes, income-tax brackets get all the media focus and hubbub, especially when tax rates change, but last time I checked, I pay more taxes than just the “income” variety.

    Since income taxes are really only part of our overall, real-world tax picture — think Medicare taxes, Social Security taxes, property taxes, and so on — it strikes me that figuring a more comprehensive “effective tax rate” gives a much better feel for how much of our money is really going out the door to the Tax Man.

    What’s Included in ETR?

    When I calculate my effective tax rate (“ETR,” for short), I start by figuring out my household’s gross annual income. That includes total wages and salaries (Form W-2, Box 3), interest earnings, non-retirement-account investment income, and any other sideline income that existed for that tax year. Added together, all those items get me the “Gross Income” figure for my formula below.

    On the taxes-paid side of things, I tally up our federal income taxes paid (Form 1040, Line 60), minus any credits below that line — the last two years’ “Making Work Pay” credits would qualify here. Added to that are state income taxes paid (if any), Social Security taxes, Medicare taxes, and any property or local taxes that I forked over during the year. If I have any excise or other taxes that I paid during the year, I lob those in here, too.

    Since I do separate some of my utility-bill taxes in Quicken, those figures go here, as well.

    What About Sales Taxes?

    Yes, to get a true tax picture, the year’s cumulative sales taxes also should get figured in.

    However, tracking sales taxes in Quicken with any sort of precision would mean that most every transaction becomes a split. Whilst I love me some in-depth financial data, I’m just not gung-ho enough to go that far. You gotta draw the line somewhere, right?

    (My annual use taxes do get figured in, though, because they’re included in the amount shown on the tax-form line I use for my Oklahoma “state taxes paid” above.)

    Initially, I planned to omit sales taxes altogether. But as I wrote this, it occurred to me that I could simply fire up an annual cash-flow report in Quicken, export it to Excel, and remove all categories that either (1) aren’t sales-taxable, or (2) already had use tax paid applied. I could take the remaining categories and do a little math on them.

    So I did. Figuring a rough estimate of total sales-taxes paid wasn’t too hard, with exception of auto fuel and its “cents-per-gallon, plus X percent sales tax” setup. Everything else? Pretty simple.

    For instance, our sales-tax rate on groceries was 8.25 percent, and we spent $5,332 on groceries last year, taxes and all. We can estimate that $406 of this was due to sales tax. [5332 − (5332 / 1.0825) = 406]

    Once I dumped that Quicken report into Excel, and autofilled the correct formulas, the sales-tax math was a breeze.

    (Yeah, over time, changes in sales-tax rates will complicate this. But again, all I’m looking for is a rough estimate!)

    A Tax Rate That’s “Effective”

    Once all those items are tallied up, the rest is easy:

    And that’s all. Take your [Total Taxes Paid] amount, and divide it by your [Total Gross Income] amount. The rate that results is your Effective Tax Rate.

    Now, I’ve been calculating my effective tax rate for years, though prior to 2010 I focused only on income taxes. Because I’m a dork who finds such comparisons fun, I tried to standardize things a bit this year so that I could go backwards through our tax returns and see how our ETR — now expanded to include all the other taxes we pay — has changed over time.

    2010 Effective Tax Rate: 21.9%

    So, for tax year 2010, roughly 21.9 percent of our income went toward taxes of one kind or another. For 2009, our effective tax rate was 21.5 percent. And back in 2008? A bit higher, at 23.9 percent.

    Summary

    For a while now, I’ve really preferred to think of my tax burden in terms of this overall “effective tax rate,” rather than in terms of federal and state tax-bracket rates … which is what so many people do. Income taxes are only part of the picture, after all. Until you look at your tax burden in total, taking into account all the directions from which the Tax Man gets into your wallet, then it’s pretty easy to miss the immense impact that taxes have on your total financial picture.

    As the figures above show, I might be in the 15 percent federal tax bracket … but that sure doesn’t mean I’m handing a mere 15 percent of my income to the tax authorities!




     

     

  9. Excel: Keyboard Shortcut to End of Column

    A purchaser of my Check Register spreadsheet recently emailed me, asking if there was a quick way to get to the bottom of her register — to get to the first blank row, in other words, in order to quickly add a new transaction. When you have five hundred transactions in your register, scrolling all the way to the bottom of your data so you can enter a new transaction … well, it just ain’t a lot of fun.

    Now, Excel has always had lots of keyboard shortcuts. The one that’s most applicable here would be the [CNTRL]-[DOWN ARROW], or [CNTRL]-↓, shortcut.

    Getting to the Bottom of It

    When I press the [CNTRL]-↓ combination, Excel will automatically take me down to the last nonblank cell in my current, active column. So, in the case of my Check Register spreadsheet, placing Excel’s cursor in any cell in the DATE column (Column C), and then pressing [CNTRL]-↓, will take me to the last nonblank cell in that column.

    From there, a single arrow-down keypress gets us to the next blank row, and we’re ready to enter the new transaction. No scrolling involved!

    (Conversely, pressing [CNTRL]-↑ would take you to the topmost nonblank cell in your current column.)




     

     

  10. Handling Paypal Refunds in Quickbooks

    Back in January, I wrote a post about how I handle Paypal transactions in Quickbooks. A reader inquired as to how I handle Paypal refunds in Quickbooks, so here’s a quick run-through. Grab some popcorn, kids.

    Quickbooks And Credit Memos

    Since Quickbooks won’t allow us to record a negative-amount sales receipt or invoice, we have to create a Credit Memo when we need to issue a refund.

    For the purposes of this lesson, let’s assume I need to refund in full the sales receipt (pdf) I showed in my previous post. On it, customer Mary McDoodle bought a $9.95 Kafluder valve, purchased via Paypal. Accounting-wise, I absorbed the 59-cent Paypal fee inside the same receipt, setting it up as an “Other Charge” in Quickbooks. This way, the total of the sales receipt reflected exactly what I saw when I looked at the transaction in my Paypal account; i.e., a net income of $9.36:

    Paypal Register Before Refund

    Now I need to refund Ms. McDoodle. Here’s how it’s done.

    Step 1: Set Up a Credit Memo

    On my Quickbooks desktop, I’ll click the “Refunds & Credits” icon. (You could also get to this by clicking CUSTOMERS in the menubar, and then selecting CREATE CREDIT MEMOS/REFUNDS from the dropdown menu.)

    This opens up a new Credit Memo form. It’ll look much like any other sales-receipt or invoice form you might see in Quickbooks.

    Once the Credit Memo form is open, fill it out so that it matches the receipt or invoice you’re refunding. In other words, enter the same items, in the same quantities, at the same prices. This includes the Paypal fee “Other Charge” item, if you’re entering them inside each receipt the way I do.

    Let’s take a quick look back at how I entered Ms. McDoodle’s initial sales receipt:

    McDoodle Sales Receipt

    And its accompanying Transaction Journal:

     

    Now for the Credit Memo. Here’s how it will look:

    McDoodle Credit Memo

    Note that I entered the same Items, quantities, and amounts in the Credit Memo as I did in the sales receipt. The Paypal fee is there because Paypal refunds it to me (the seller) when I process the refund in Paypal’s system, which I’ll do manually, outside of Quickbooks.

    When I save the Memo, Quickbook basically “reverses” what’s on it. At least, that’s how I think of it!

    Step 2: Apply the Credit Memo

    So we’ve created Ms. McDoodle’s Credit Memo. Note that nowhere in the Credit Memo form does Quickbooks ask us for the posting account (as it does in sales receipts). That’s because we could do different things with Credit Memos; we could:

    • Allow the customer to “retain” the available credit for later use;
    • Give a refund; or
    • Apply the credit to an invoice.

    When we save/close the Memo, Quickbooks automatically asks which of these options we want to perform. In our case, since we’re refunding the customer via our Paypal account, we’re going to opt to give a refund:

    QB Dialog: Credit Memo Action

    After that, Quickbooks’ “Issue a Refund” window appears:

    QB Dialog: Issue a Refund

    And right there is where we’ll select the account for the refund to come from — which is our Paypal account. One more click of the OK button, and the refund is posted. My Paypal account register shows:

    Paypal Register Shows Refund

    And that’s it — we’re all done with posting the Paypal refund in Quickbooks!