Anyone "Spreadsheet" their next car(s)?
Anyone "Spreadsheet" their next car(s)?
Author
Discussion

willisit

Original Poster:

2,186 posts

261 months

Friday 24th January 2014
quotequote all
Help me out here - does anyone go to these lengths? Adding up the service costs, potentials like tyres, fuel over 12,000 miles, insurance etc etc?

I'm doing it A LOT. Why? Well, I like a half dozen car ideas - some sensible, some not-so.

I realise that once I drive what I want, man maths may take over and I'll start justifying this with "SCIENCE IS WHY!" but for now... I like the numbers.

I'll even post the spreadsheet if you want to see the insanity. :P

Mr E

23,066 posts

289 months

Friday 24th January 2014
quotequote all
For a possible family barge replacement, yes.

For a car I'm buying with my heart, no.

mikeyr

3,399 posts

223 months

Friday 24th January 2014
quotequote all
Yep, and often use to list potential cars next to each other with pro's n con's!

Post your spreadsheet! type

mikeyr

3,399 posts

223 months

Friday 24th January 2014
quotequote all
Mr E said:
For a car I'm buying with my heart, no.
More so for that type of car as normally means I am pushing my budget!

vtecyo

2,122 posts

159 months

Friday 24th January 2014
quotequote all
No. You can't predict unforseen costs and replacing parts that wouldn't "normally" go, so why bother?

hornetrider

63,161 posts

235 months

Friday 24th January 2014
quotequote all
No. The only spreadsheet I do when buying a new car is to list all the potentials to try and find the sweet spot of value.

Model: Year: Miles: Price: Colour: FSH: Spec: Other

willisit

Original Poster:

2,186 posts

261 months

Friday 24th January 2014
quotequote all
vtecyo said:
No. You can't predict unforseen costs and replacing parts that wouldn't "normally" go, so why bother?
Fair point. No one can plan for a random clutch change (like the Audi is receiving) - but then, that's not really the aim. More like - tax, servicing and MPG over time. I don't care much about depreciation or purchase for example.

I guess, think of it this way - I own Car A and it costs me X over a year - is Car B worth two three.. four times that because it's a nicer car? When juggling costs, it's the sort of thing I stay awake at night mulling over.

When I was 20 I'd just buy a car (Porsche 993), drive it, get in debt... I'm not 20 anymore though :P

Sportidge

1,034 posts

267 months

Friday 24th January 2014
quotequote all
I did exactly this when looking for the car I have now. (The curse of being a Project Manager!) rolleyes

I was in the market for a faux-by-four, (everything in the range of X3, Tiguan, CX-5, Sportage, Kuga, Evoque, etc)

Whilst I didn't go down the route of daily running costs (Other than the 12-month 10k miles fuel costs), I did go down to the level of what spec for what price (and how much extras cost), size of boot, etc.

It was surprising to see what did and didn't come as standard across the range of manufacturers, and the fact that the most expensive of the list would have cost me around £10k more than what I eventually bought to get it to the same sort of spec toys-wise.....

You can probably tell from my Username what I ended up with wink

The dealer even took a copy of my spreadsheet so they could understand how their car stacked up against the competition hehe

willisit

Original Poster:

2,186 posts

261 months

Friday 24th January 2014
quotequote all
Not just me then... biggrin

Ved

3,949 posts

205 months

Friday 24th January 2014
quotequote all
Yep and it's put two Subarus on the drive way. Keen to see yours though so post a link and I'll see how badly weighted mine is smile

willisit

Original Poster:

2,186 posts

261 months

Friday 24th January 2014
quotequote all


Judge away... smile

Top two cars we already own - hence the comparison. The Audi isn't going anyway - just for my own amusement.

lightthefuse

426 posts

202 months

Friday 24th January 2014
quotequote all
Did it whilst investigating new company wheels (comparing brand new smaller/used larger) to replace my Shed Xedos 9 when running my own firm. Still went with my heart (somewhat) and bought a diesel Saab 9-5.

33q

1,628 posts

153 months

Friday 24th January 2014
quotequote all
Always do the spreadsheet thing. Then just adjust the figures to suit my heart.

For me the limiting factor is 'will it fit in the garage?'....hate leaving £20+K outside

willisit

Original Poster:

2,186 posts

261 months

Friday 24th January 2014
quotequote all
33q said:
Always do the spreadsheet thing. Then just adjust the figures to suit my heart.

For me the limiting factor is 'will it fit in the garage?'....hate leaving £20+K outside
Don't get me started on that...

Sportidge

1,034 posts

267 months

Friday 24th January 2014
quotequote all
Here's mine, RAG colour coded on "best, medium, worst" loserhehe

(Details correct at time of doing it, August 2012)


James_G

366 posts

214 months

Friday 24th January 2014
quotequote all
Not my future purchase, but I track all my running costs in a spreadsheet. This way I knew that for the last 6 years my "buy outright" approach to motoring has cost me £390 a month every month in depreciation and maintenance (fuel, insurance excluded). I therefore knew I could easily afford £390 a month on finance to buy a new car when looking recently, so that's what I did.

James_G

366 posts

214 months

Friday 24th January 2014
quotequote all
Ooh, RAG codes, hadn't thought of that.

willisit

Original Poster:

2,186 posts

261 months

Friday 24th January 2014
quotequote all
Sportidge said:
Here's mine, RAG colour coded on "best, medium, worst" loserhehe

(Details correct at time of doing it, August 2012)

Holy cow.. love that. RAG.. I think I'll steal that!

Martin350

4,616 posts

225 months

Friday 24th January 2014
quotequote all
willisit said:


Judge away... smile

Top two cars we already own - hence the comparison. The Audi isn't going anyway - just for my own amusement.
With those Porsches in there your spreadsheet needs a 'bork fund' column!

willisit

Original Poster:

2,186 posts

261 months

Friday 24th January 2014
quotequote all
Martin350 said:
With those Porsches in there your spreadsheet needs a 'bork fund' column!
Yep - typically all I can stand spending money on are the ones that are likely to throw intermediate shafts. They kinda qualify themselves right out! Mind you, I love 911s and once had a 993, so I'm familiar with the "you need 4 wheel alignment doing, so I'll just add a few zeros to your bill, here" smile