All
I like to make Excel worksheets to help me make decisions.
Son #2 and I want to buy a work/personal pickup.
So I put together this worksheet to spell out how much this is going to cost him/me each month.
There is a amortization chart built into it.
Yellow cells require you to put information in (cost of car, interest rate ect.)
Gray cells have formulas in them.
Parents with teenagers can punch in different scenarios ( cost, money up front, MPG to see that reflected in monthly cost.
You will have to put in your own insurance, license and maintance cost.
The help dialog box always appears with his, so just close it.
You can use it on the BY screen or you can copy and paste it on a blank Excel sheet.
Rich
Replies
That's awsome.
I usually do all the computations manually.
I think a lot of people may be surprised to see what a car costs them every month
may be surprised
wow, $86 a month, up from $45 a month last year, mostly gas, then ins.
you don't count!
your vow to live the frugal live is rivaled only by a monks vow of silence.
Neat, I am a spreadsheet kind of guy too. And I mispell a lot too ( actually it is my dyslexic keyboard). Thanks for sharing!
I can't remember how to force the computer to open this in Excell instead of Open Office. I just added MS Office standard and had been using Open Off which is pretty darn good for free, not sure if I should just dump OO off.
Bob
Edited 9/3/2008 11:16 am ET by rasconc
3 vehicles = $396/month total expenses....
I gotta review that third vehicle's "reasonableness" again.... may be too costly.
A La Carte Government funding... the real democracy.
Hack
With the business and personal I have 7 vehicles. I don't want to know how much I spend. COL.
Rich
With two teenage drivers, both needing a good vehicle for travel to school, insurance is what gets me, but look how this played out:
Had 1997 Toyota RAV4 with collision coverage, 19 yr. old son listed as primary driver, insurance cost was 1475.00 per 6 months. Bought myself a used mitsubishi Eclipse convertible for fun. Put liability only on it (no collision). Listed son as primary driver, (even though he seldom does) cost for 6 months was 520.00 but the toyota, now listed with me as primary driver, dropped to 347.00 per 6 months. So, I saved 1128.00 per 6 months with the Toyota and spent the 520.00 extra for the mitsubishi leaving me a net savings of 608.00 every 6 months. Maybe that wont pay for the car, but It sure gave me a good excuse for buying it!
live
2 years ago we bought 97 Honda CRV, to replace 95 buick LeSabre.
teenage daughter would have to go on some vehicle.
Turns out it was $3/month cheaper to keep the LeSabre with her as the primary driver of that car.
Rich