Running costs calculator
Running costs calculator
Author
Discussion

thinfourth2

Original Poster:

32,414 posts

233 months

Tuesday 26th July 2011
quotequote all
This should really be in the domestic appliance section

But has anyone got a nice excel spreadsheet for comparing the running costs of various cars.

The other halfs shiny car has burped its turbo and Honda want £2500 to change it

I want to scrap the bloody unreliable overly complicated thing and spend the same money on a banger or buy an aygo

She wants to fix it and then trade it in for another shiny

If anyone has a nice little spreadsheet for working through the costs of the various options.

This isn't a what fun car I want the cheapest and least hassle way of getting her to work.

Nick3point2

3,920 posts

209 months

Tuesday 26th July 2011
quotequote all
I do have such a spreadsheet but I've spent a lot of time perfecting it so don't want to see it shared for free!

Honestly though, it's not hard!

Dave 500

7,882 posts

271 months

Tuesday 26th July 2011
quotequote all
How about using the one on here?

thinfourth2

Original Poster:

32,414 posts

233 months

Tuesday 26th July 2011
quotequote all
Nick3point2 said:
I do have such a spreadsheet but I've spent a lot of time perfecting it so don't want to see it shared for free!
beer ?

thinfourth2

Original Poster:

32,414 posts

233 months

Tuesday 26th July 2011
quotequote all
Dave 500 said:
How about using the one on here?
Where is it?

miniman

30,049 posts

291 months

Tuesday 26th July 2011
quotequote all
thinfourth2 said:
Dave 500 said:
How about using the one on here?
Where is it?
My Profile -> My Garage -> Select / add a car -> add costs

e.g.

http://www.pistonheads.com/members/showServiceHist...

Caulkhead

4,938 posts

186 months

Tuesday 26th July 2011
quotequote all
You really think Excel logic can beat wife logic? hehe

thinfourth2

Original Poster:

32,414 posts

233 months

Tuesday 26th July 2011
quotequote all
Caulkhead said:
You really think Excel logic can beat wife logic? hehe
Shes not quite normal for a women

She didn't complain once at me using a digger for diggng the garden and was only mildly annoyed when i ran over the patio furniture in the Unimog which she half owns

neiljohnson

11,298 posts

236 months

Tuesday 26th July 2011
quotequote all
£2500 for a turbo yikes that sounds way over the top what car is it ?????

thinfourth2

Original Poster:

32,414 posts

233 months

Tuesday 26th July 2011
quotequote all
neiljohnson said:
£2500 for a turbo yikes that sounds way over the top what car is it ?????
A fecking turbo diesel accord

hateful hateful car

As to the main dealers the swear word has not been invented as to how i feel about them

neiljohnson

11,298 posts

236 months

Tuesday 26th July 2011
quotequote all
thinfourth2 said:
A fecking turbo diesel accord

hateful hateful car

As to the main dealers the swear word has not been invented as to how i feel about them
No way i would be paying that, cost wise £1000 is closer to the mark on either the 1.9 or 2.2 unless there is other work required such as intercooler etc then they are taking you for a ride!!

DuncanM

7,464 posts

308 months

Tuesday 26th July 2011
quotequote all
thinfourth2 said:
As to the main dealers the swear word has not been invented as to how i feel about them
What a brilliant turn of phrase smile.

I think small petrol is the way forward, Aygo sounds like a plan.

Duncan

tr7v8

7,621 posts

257 months

Tuesday 26th July 2011
quotequote all
I have a spreadsheet not sur f it'll do what you want but ping me a PM with your mail address & I'll give you a copy.

miniman

30,049 posts

291 months

Tuesday 26th July 2011
quotequote all
neiljohnson said:
thinfourth2 said:
A fecking turbo diesel accord

hateful hateful car

As to the main dealers the swear word has not been invented as to how i feel about them
No way i would be paying that, cost wise £1000 is closer to the mark on either the 1.9 or 2.2 unless there is other work required such as intercooler etc then they are taking you for a ride!!
Can't beat kicking a man when he's down hehewink

jimbobsimmonds

1,824 posts

194 months

Tuesday 26th July 2011
quotequote all
thinfourth2 said:
unreliable...

Honda...
I just don't know whhow I could be more dissolutioned than I am right now...

thinfourth2

Original Poster:

32,414 posts

233 months

Tuesday 26th July 2011
quotequote all
neiljohnson said:
No way i would be paying that, cost wise £1000 is closer to the mark on either the 1.9 or 2.2 unless there is other work required such as intercooler etc then they are taking you for a ride!!
The quote was £4500 for fixing the turbo and replacing all the brakes as they were all dangerously worn

ANYWAY

Does anyone have a nice spreadsheet for working out the running costs of a new car taking into account depreciation, finance payments etc.

I'm happy with runing a shed but the wife isn't

Cub911

350 posts

210 months

Tuesday 26th July 2011
quotequote all
[smug/geek mode on]

If I have time, i'll build one over lunch and get it on here for the end of the day.

Running cost wise, what do you want it to cover;

Petrol (i'll get this working on an average mpg input against forecasted miles per year against average price per gallon)
MOT
Tyres / Consumables
Dealer Repairs
Insurance
Road Tax
Depreciation (clearly this is subject to personal view, so it will be built on a percentage input and people can alter it accordingly).
Finance, i may need to do a straight capital purchase vs a finance agreement model. The capital finance will be done first as its easiest.

Shout if you want anything else on it.

It will work on a discounted cashflow basis, probably using a 3.5% discount rate (i'll make it so you can change it as to your treatment of money over time). The model will allow upto four car comparison, and be on a Net Present Cost basis. I.e. what it would cost you over 5 years to run in today present cash value.

It in essence allows a life cost comparison, in todays values.

[smug/geek mode off]

I don't mind sharing it for the PH massive, because I'm full of the milk of human kindness, unlike matey above......

It will of course come with a load of caveats that mean if you use it to make an investment decision and its wrong in any way....its your problem...etc etc.

Edited by Cub911 on Tuesday 26th July 11:15

thinfourth2

Original Poster:

32,414 posts

233 months

Tuesday 26th July 2011
quotequote all
Cub911][smug/geek mode on said:
If I have time, i'll build one over lunch and get it on here for the end of the day.

[smug/geek mode off]

I don't mind sharing it for the PH massive, because I'm full of the milk of human kindness, unlike matey above......
PM received

Which is exactly what i want

if someone can host it and folk contribute to it is would be excellent

I would write one myself and let it out for genral use but it would take me a week and it would be st

Cub911

350 posts

210 months

Tuesday 26th July 2011
quotequote all
Ok, i'll get onto it over my mundane lunch.

I'm not going to write any complicated Macros into it, as to be honest it just needs to be functional and easy to use.

But yes, if I build it, I don't mind people hosting it elsewhere or even on here.

I'll send an update on this thread later on today / tonight.

thinfourth2

Original Poster:

32,414 posts

233 months

Tuesday 26th July 2011
quotequote all
miniman said:
Can't beat kicking a man when he's down hehewink
I'm not down i'm just pissed off

Anyway the brakes i'll do myself as i'm not buying new discs when i can skim the old ones on my lathe

I'd do the turbo but the access is bugger all and i don't have a 2 post lift to do it from underneath. I ain't lying on the floor to do it as that pisses me off no end i'd be sorely tempted to set fire to the bloody thing