Three Tools for Managing Your Credit Card Debt – Calculators, Worksheets, and Forms

If you’re struggling with credit card debt, and many of us are these days as interest rates, oil prices, and economic problems all increase, then these tools can help you get a control of your spending.

Debt Repayment Calculator

The first tool you need is information. So, the debt final payment calculator from CNN is particularly useful for many reasons, and it’s quite intuitive to use. So rake through your wallet, and take out all your cards. Go find the matching statements from the most recent period. Then you need to enter each card and the total balance for each account; and the minimum monthly payment. Repeat this for as many cards as you have.

debt free calculator

Once you have tabulated the information, in the next box you need to check what kind of goal you have. There are three goals: Minimum payments, Fixed Payments, and Debt Deadline. Each of these has a different answer. I chose the first plan to shock myself. Since I currently don’t have any debt. I made up some numbers for show. It was quite a surprise.

plan a debt free calculator

If I didn’t add any purchases (yes, none! Nothing!) to the debt, it would take me 9 years to pay off the credit card debt, I’d pay interest of over 1/3 the amount; but most people use their credit card regularly, so they’d likely take much longer, perhaps never even reaching final payment, to pay off the full amount.

Once you try this calculation you can try the other variants. I particularly like the ability to calculate amounts that you would need to pay off the total within a particular period.

Debt Evaluation Calculator

debt evaluation calculator

This debt evaluation tool from MSN is presented in a wizard-type format with 3 data entry pages (all short), and two output pages (results and summary). So just fill in each page, then you’ll be able to calculate the rating. Is your debt level acceptable?

Enter your income: Easy.

income input

If you have more than one income, or more than one source of income, enter the total here. I noted that the number says ‘gross’, ie. before tax. As usual, I’d recommend that a certain conservatism is required here: tax rates vary hugely due to location, type of income, tax rate applicable, etc. So use an income amount net of tax.

Enter your housing expenses: Can be tricky.

house input

You might have trouble figuring out the entire expenses as taxes are usually paid annually. Just check your records, then divide by 12. Same goes for insurance amounts.

Enter Other Payments: Can be vexing.

other payments input

Now enter the other payments that you make, there are a number of set categories, but no way to additional categories in this wizard. So anything that is not listed, list under ‘other’. Typical items might include store cards, monthly debts not otherwise categorized (personal borrowings), etc.

And the results

The calculator is quite simple so then it jumps to the results, summarizing the total amount of debt and expressing it as a percentage.

results output #

There is also a summary page with each category clearly stated. Now you should probably treat the comment with some skepticism, but if you’re getting a high ratio, then perhaps that will confirm what you already know: too much of your income is now paying down unnecessary interest payments.

Debt Deadline Calculator

This is the third tool I have found that is worth mentioning: this tool is available on BankRate dot com and allows users to find out how to pay off their debt.

payment evaluator

It works in a pretty similar fashion to the first one, except that you can only choose one credit card amount or one interest rate. So for a quick and rough set of calculations, this should be fine.

Google Docs – Spreadsheets

This is probably an odd thing to add to the mix, but I’m adding it because of a new feature that Google just introduced for its spreadsheets: the online form. You create a form that you can access online, save the URL, then each time you spend money on your credit card, just enter the details in the form wherever you are: at home, at work, on the go (via your mobile), wherever. To do this is quite easy:

First, create a new spreadsheet in Google Docs, then click on ‘share’ to create the form.

create a form

It’s under the ‘to fill out a form’ (it’s checked), then hit ‘start editing your form’.

Second, enter the basic categories you need: the form title, the descriptions, the items, the type of credit card, the amount, and the date you bought it.

create your form

Third, then you’ll see the completed form at the specified location (you don’t have to email it, just keep the URL somewhere easy to find). Then when you buy something, load the URL, and enter the data.

credit card expenses form live

Fourth, when you come to view the form data in your spreadsheets, you’ll see the collated data.

final data entered

Just by keeping track of your spending, you will collate the data without much effort. Then at the end of the month, you can tabulate your spending properly. Next month, you can start to enter a budget limit to help keep your spending down.

Summary

Getting a handle on your debt requires finding out the current situation, gathering your current spending habits, collating your data, and making REASONABLE judgments. Slowly, but surely, your credit card debt can be tackled, especially with these four online tools.

What would you do if… (some bad news)

streams book

(ed. Backed date post to January 30th. Written February 2nd.)

We’re often told that we need to diversify our investments to protect them. We’re given that advice to ensure we don’t put ALL our money in just a few stocks or mutual funds or bonds or options or whatever. Why? To reduce the risk that we will lose everything in a downward turn of the stock or market or economy.

Conventional Wisdom

To my amazement, this is what most people do EVERYDAY (not with their stocks, though) but with their CAREERS. They rely on these careers to provide 100% of their personal income, whether they are high-flying lawyers, multiply-skilled engineers, or teachers in elementary schools.

To offset the risk of being injured, sick or dying, employees of all income levels are encouraged by employers, government and private industry to purchase insurance to cover these risks. Of course, these policies require that the employee shoulder the lion’s share of the premium (whether or not the companies contribute). To reduce the consequences of unemployment which in our World 2.0 seems to happen with increasing regularity, employees are required to take out unemployment insurance with the government agency tasked with employee welfare. In most cases, injury, sickness, death or unemployment means a reduced income for an indefinite or permanent period.

Dumb and Dumber

Given these risks, and the single source of income philosophy most employees share, you’d think people would be willing to look after their money sensibly. Well, it doesn’t happen. How? Because these self-same individuals then go borrow money at multiples to their current annual or monthly salary to buy houses, higher interest personal loans for cars, and usurious rates for credit card purchases. The items they then buy are then used, used up, consumed or thrown out even before the payments are finished. In nearly every case, the item’s value is depreciated considerably by time, such that hi-fi, TV, washing machines, etc which may last more than five years are often replaced before or just after the personal loan that financed their purchase expires. It still shocks me, once I realized how we were encouraged to play the game, that we all fall into this trap without so much as a look over our shoulder.

It can’t happen to me!

Given the risks employees hold to themselves and their jobs, and given the lifestyles that their jobs and careers finance, when misfortune happens (and it does), it comes as a shock. It is a shock that causes a lot of immediate distress IN ADDITION TO any emotional distress that are directly caused by the misfortune itself. An example:

John Smith works in a car assembly plant in Michigan (for one of the ‘Big Three’). It’s just after Christmas in 2008, and there’s news of closures across the US. The company is losing market share, has the wrong products in its showrooms, and is losing money by the truckload. Massive closures come. For John Smith, who has worked there 15 years since high school, it’s a personal disaster.

He is informed that he’ll lose his job in three weeks. Of course, he’ll get compensation. But still he loses his entire career at once; he’ll lose his teammates (similarly fired); and he’s going to face an uncertain future until he retrains or finds new work at the Toyota plant (where rates are 30% lower for the same work).

Worse, he just bought his own new 4×4 on a car loan; his family owe $17500 dollars on credit card; the house is 100% financed (and the realty market is also suffering); and his bank balance shows $400. Tuition payments, taxes, cable bills, etc. are also eating into his already reduced income. And there is NO emergency money. In addition to his personal worries, he’s a period of difficult financial uncertainty, too. (This is a fictitious example).

Yes, it can. Yes, it does. It might just happen to YOU!

In May 2005, I caught bronchitis, and that was the start of a journey that took a number of weird turns. I was forced to stay home for over 10 days as I was sick and feeble. Bronchitis isn’t pleasant by any means, unfortunately, I didn’t get it treated properly the first few days meaning that my recovery time was longer than it should have been. However, it allowed me a chance to think about Multiple Sources of Income in a very personal way. I had just leafed my way through the book by Robert Allen’s book of the same name.

Read Wednesday’s post “A Man WITH A Plan” to find out what that plan was.

NetWork Solutions: How YOU can gouge your customers in 10 steps or less – a case study

Or How Many Times Can YOU Upsell your products and GET Away With it!?

I had heard that Network Solutions had been trying to sell $9.95 domains for $34.99, so today… as I was cleaning out my closet, I decided to conduct a little experiment. I used Dreamhost to check for a domain that was available to register: I chose the one listed below and it showed it was available. I then repeated the experiment with a second domain (a different one entirely) to verify my results.

So here goes, is it true that Network Solutions is gouging customers?

On the first page, I entered the domain, I came across this oddly checked box (I had not submitted a request for dot net anyway, so I let it ride) – The FIRST UPSELL. But let’s not forget all the other domain boxes on that first page with four more attempts to get you to buy additional domains at greatly inflated prices…!

upsell#1

So I clicked ‘Add Domains to Order’. At this point I hadn’t seen a price on the page for the domain registration. The link shows the prices clearly elsewhere but NOT on the purchase order.

upsell#3

I was then asked to choose a public or private registration for $9 per year. So I clicked. Second Upsell – Checked!

upsell#2

Adding Hosting… Mmm. Well, it’s a reasonable question but… for someone with good quality hosting already, a superfluous question. And the prices: well, reasonable to pricy. Third Upsell.

upsell#3-8

Ok… In one fell swoop, you are asked about SEVEN additional products, taking you through to 10 upsell attempts in total… Let’s see… Fourth to Tenth Upsell in ONE Page. Oh, boy!

Upsell#10

And they’re not done yet! We’ve still got the pricing page: Upsell #11.

Did you see that? Not only did you get upsold on the domain with private registration (which my host throws in FREE!) but they defaulted to FIVE years payments… and the first year is $34.99. Quite shocking, really. An original bill for just $9.99 (using another company like Yahoo! Domains or GoDaddy or any of a dozen decent registrars) was upsold to over $289 dollars for a domain that was a NEW domain!

And the EXTRA value?

Of course, you are getting some extra value: a dot com and a dot net, but the private security… Mmm. Let’s face it: domain names became commodity type services years ago, so the upsell is Network Solutions trying to add extra profitability to its bottom line.

But the customers? Who cares… As long as you are making your own bottom line. Upsell all you want… customers love it, in fact, they come back for more, and more. NOT.

Don’t UPSELL me!

The last time a company tried to upsell me on an item I was purchasing on the Internet, I hate to say it but it was box PC from DELL. I looked through all the options in the page, and came away disgusted. I understood that computers are massively complicated items, but my own needs were specific and didn’t need much tweaking, yet I was faced with the UPSELL on warranties, software packs, monitors (grossly overpriced, I might add), …

When I know what I need, do NOT upsell to me. If it’s online, I’ll just close the browser. If it’s at a store, and I’m not ‘just browsing’, I’ll be complaining to the representative or heading for the exit. It’s not that I’m a cheapskate or what… I just do not like being treated as a cash machine for a company.

I prefer to see a product or service sold at a price that doesn’t need an UPSELL as the company make a decent profit, and the customer gets a quality product or service. That’s all.

Am I nuts? Or is this one of the axioms of American business these days? Does it bother you, too? Let me know.

Important CAVEAT

Oh, and by the way, the domain that I tried to register with Network Solutions is now no longer available! So don’t even try to do domain searches there, you’ll end up being held hostage for your domain at $34.99 for the first year. The second domain I searched for but didn’t complete the transaction is similarly unavailable. As is the third domain which I merely searched for. Dreamhost doesn’t do this, why does NetworkSolutions?

Note: I didn’t link to NS other than for the single price page. It’s too ridiculous.