ad info

 
CNN.com  technology > computing
    Editions | myCNN | Video | Audio | Headline News Brief | Feedback  

 

  Search
 
 

 
TECHNOLOGY
TOP STORIES

Consumer group: Online privacy protections fall short

Guide to a wired Super Bowl

Debate opens on making e-commerce law consistent

(MORE)

TOP STORIES

More than 11,000 killed in India quake

Mideast negotiators want to continue talks after Israeli elections

(MORE)

MARKETS
4:30pm ET, 4/16
144.70
8257.60
3.71
1394.72
10.90
879.91
 


WORLD

U.S.

POLITICS

LAW

ENTERTAINMENT

HEALTH

TRAVEL

FOOD

ARTS & STYLE



(MORE HEADLINES)
*
 
CNN Websites
Networks image


Use your Mac to track your money

MacWorld Online

June 1, 2000
Web posted at: 10:17 a.m. EDT (1417 GMT)

(IDG) -- Money may be the root of all evil, but better the devil you know than the devil you don't, to mix a couple of aphorisms. How well you manage your money -- whether you're saving it, spending it, or just trying to keep track of where the heck it went -- will influence your quality of life than just about anything this side of good personal hygiene.

Fortunately, your Mac (which probably entered your life as an expense) is a great tool for saving and managing money. OK, it's probably not as useful as a little common sense, but it's definitely more useful than an ATM machine, which is the primary personal-finance appliance for way too many people. (The ATM method of budgeting goes like this: If there's money in my checking account, then I can spend it! Needless to say, this is not wise.)

As a rule, I'll cover a wide range of subjects. Nevertheless, you can count on a few things:

  MESSAGE BOARD
 
  • It's a Quicken world. Because it's the de facto standard for Macintosh personal-finance software, Intuit's Quicken personal-finance program will be one of the main topics of this column. (It's amazing how easy it is to become a de facto standard when you don't have any competitors.)


  • We're in it for the long run. For the most part, I'll be looking at bread-and-butter long-term personal-finance strategies - the kind of stuff that makes the difference between a comfortable retirement and decades of scraping by on a fixed income. So don't expect to see tips on day-trading or on how to speculate with yen futures.


  • You can't work without a Net. The Internet is an invaluable tool for managing money -- provided you use it judiciously. I'll be pointing out sites that I think Mac users could use to their profit.

And now, on to today's topic: Excel

MORE COMPUTING INTELLIGENCE
IDG.net   IDG.net home page
  MacWorld Online home page
  Your guide to online banking
  New Internet bank targets wireless customers
  Intuit slapped with privacy violation suit
  Reviews & in-depth info at IDG.net
  E-BusinessWorld
  TechInformer
  Questions about computers? Let IDG.net's editors help you
  Subscribe to IDG.net's free daily newsletters
  Search IDG.net in 12 languages
  News Radio
  * Fusion audio primers
  * Computerworld Minute

This month, I'm going to discuss a relatively easy thing you can do to protect one of your biggest investments and avoid some of the most common surprise expenses -- track your car's maintenance and associated costs using Microsoft Excel.

Believe it or not, if you add up all the costs of operating a car for five years, the total expense will equal, if not surpass, the original purchase price of the car. So reducing those costs seems like a reasonable goal. Most late model cars, after all, are designed to run for at least 200,000 miles if properly maintained. Even if you're planning to ditch your car before the end of its useful life, you'll get more for your vehicle if you can show that it's been properly maintained.

Personally, I used a Microsoft Excel spreadsheet to keep track of the servicing of a car for nearly ten years. I didn't quite make it to 200,000 miles, but I knew all along how much the car was costing to operate, and when the time came to replace it I was able to get a price for it that made the costs of maintenance worth my while.

To do this, enter all the scheduled maintenance milestones from your car's owner's manual (making sure to include an oil change every 2,000 miles). By setting up a few simple Excel formulas (nothing more complicated than addition and division, you can see what they look like in this sample spreadsheet), you can not only track your maintenance data (what the mechanics did, when they did it, how much it cost, and what the mileage was at the time) but also see your average daily mileage during each period between servicings. It's even possible to track exactly how much per mile the car costs you to maintain. When those costs start rising, it may be time to think about replacing your vehicle.

Although it would definitely be useful to know your car's fuel mileage (a decline in miles per gallon is a good indicator of potential problems), I'm not dedicated enough to enter every single gasoline purchase. This way, the only time I have to enter any data into the spreadsheet is when I actually take the car in for servicing. Each time I do so, I make a note of the data for the next scheduled service and enter it in my Quicken calendar (see how hard it is to keep Quicken out of the picture?) and set a reminder.

Here's a sample of the first couple of years so you can see how the spreadsheet works.

As an added bonus to this column, I've also included an Excel template of my tracking spreadsheet for download below. It should help you get started in building your own vehicle maintainance tracking sheet.

If you don't want to use Excel (and you don't really care whether you can determine your average daily mileage between trips to the mechanic), you've got a couple of other options. One is a $5 shareware application from Pacific Cargo Co. called CarCare (link below). As with my spreadsheet method, CarCare is based on the notion that you're willing to enter data into your Mac about as often as you take the car in to be serviced. It's actually a FileMaker runtime template with fields for repair costs, dates, mileage, and so on, but you'll still need to set your own reminders for when your next service is due.

The other option, and the most convenient, is to go to Cars.com (link below, a Web site associated with the Car Talk guys from National Public Radio). Their "MyCarSite" feature lets you enter your car's year and model number and then automatically provides you with a service schedule as well as notification of any recalls or service bulletins. Of course, all your data will reside on their servers not on your Mac, but it's extremely convenient.

Regardless of how you choose to track your auto expenses, the knowledge you get from doing so will put you in the driver's seat when it comes to figuring out how much your vehicle is costing you to operate and documenting its value when it's time to get rid of it. This may seem like a fairly insignificant step toward saving money, but the principle behind it isn't. Becoming mindful of how money moves out of (and into) your pockets is the key to keeping your finances under control and is the foundation for budgeting, but that's a topic for another column.

To download the Microsoft Excel template for tracking your car's maintenance, click here.




RELATED STORIES:
iMac DV makes home video editing simple
March 10, 2000
Everything you always wanted to know about the G4
March 6, 2000
Hot-rod your Mac for gaming
February 28, 2000
Jobs unveils a bushel of new Macs
February 17, 2000
G4s go back to the future
February 18, 2000

RELATED IDG.net STORIES:
There's no accounting for Linux
(LinuxWorld)
New Internet bank targets wireless customers
(Computerworld)
Your guide to online banking
(PC World Online)
Get yours with PayMe.com
(PC World Online)
Digging digital gold
(FCW)
Taxpayers flock to e-filing
(FCW)
Intuit slapped with privacy violation suit
(Computerworld)
Cash in on the Internet with Calypso
(PC World Online)

RELATED SITES:
CarCare
Cars.com

Note: Pages will open in a new browser window
External sites are not endorsed by CNN Interactive.

 Search   

Back to the top   © 2001 Cable News Network. All Rights Reserved.
Terms under which this service is provided to you.
Read our privacy guidelines.