General Real World 500 cost comparison

[cowabunga]

View attachment 500 cost comparison V1.zip

Hi all

In an attempt to dispel some 500 myths with respect to costs I have put together the following model attached.

In the attached all you need to do is select the models and then modify the variable BLUE BOXES by choosing from the dropdown menu's to real world values, in order to obtain real world costs. The costs should automatically change as variables change, if they do not press f9 on your PC or trun on autocalculate.

At the moment I have just selected approximate arbitrary values for the variables but these can be updated to the users requirement and what they believe is accurate.

The model is a 1st draft so I would appreciate comments to refine this for greater accuracy over time.

Hope you enjoy it, and look forward to constructive comments in due course!

 

[cowabunga]

I've spotted a mistake already before the paint's even dry on it, will modify and repost shortly.

 

[rkt2003]

I inputed additional costs to the m-jet up to £800 more on service work etc and it only works out at 1p per mile more which is not to bad ,although all them 1p`s add up .

 

[cowabunga]

I've spotted a mistake already before the paint's even dry on it, will modify and repost shortly.

Got the depreciation calc wrong, sorted now

 

[rkt2003]

Still not a huge difference even when i add £800 on for tyres ,servicing/ extras ,the m-jet for me was my choice ,but now i would test drive the twin-air as well which in july 08 was still in development

 

[cowabunga]

I inputed additional costs to the m-jet up to £800 more on service work etc and it only works out at 1p per mile more which is not to bad ,although all them 1p`s add up .

I think it's good to get it all down, and it's opened my eyes a bit. I always expected the 1.2 would be significantly cheaper than the others, and while in most cases it's cheaper, the difference is not that much really, just a couple of percent.

That said im using variable many will disagree with, such as 43 mpg for the 1.2, 47mpg for the TA, etc.

Just flex to what you think fits best and it does the calcs for you.

 

[cowabunga]

Version 3 already!!!! i'll get there, lol.

 

[rkt2003]

Mmmn interesting makes mine about £250 more per year to run !!!

 

[cowabunga]

Mmmn interesting makes mine about £250 more per year to run !!!

Ive just worked out mine

I'm not costs conscious because I wanted the best non abarth performance (missus didnt like em) and the TA was not around at the time so went MJD 95hp. Only do 4k miles a yr too.

I reckon in my case the MJD costs £2 less pw than the 1.4, £5 a wk more the TA, and £10 a wk more than the 1.2.

 

[rkt2003]

Ive just worked out mine

I'm not costs conscious because I wanted the best non abarth performance (missus didnt like em) and the TA was not around at the time so went MJD 95hp. Only do 4k miles a yr too.

I reckon in my case the MJD costs £2 less pw than the 1.4, £5 a wk more the TA, and £10 a wk more than the 1.2.

Lessons to be learned ,but as i always say if your enjoying it, it softens the blow and next time do the sums lol.

 

[cowabunga]

Lessons to be learned ,but as i always say if your enjoying it, it softens the blow and next time do the sums lol.

I did the sums last time and they were easy as it was a straight contest between the 1.4 vs mjd because I wanted the extra performance over the 1.2.

I made the right choice for my needs/ wants, however if i was making the decision now the TA would definitely be in with a shout.

 

[ahmett]

I did the sums last time and they were easy as it was a straight contest between the 1.4 vs mjd because I wanted the extra performance over the 1.2.

I made the right choice for my needs/ wants, however if i was making the decision now the TA would definitely be in with a shout.

Yes, while the 1.4 makes my pocket cry at times, the second i redline the car on an empty road by the seaside all is forgiven!

 

[306maxi]

I'm sorry but that spreadsheet is more or less useless as it doesn't contain things like extra tyre wear which IS an extra cost for someone looking at owning a diesel 500. The servicing costs are your estimates and are wildly incorrect.

There are so many variables in there that the person using it could "assume" so as to influence the figures coming out at the end.

How is someone who has never owned a 500 going to know what MPG a twinair typically gets? How are they going to know what percentage of depreciation each model is likely to have? How are they going to know whether their style of driving is going to mean that their MJ is going to need an extra oil change or 7 every year?

It's essentially just a calculator which shows you the price of owning any car in the UK based on what YOU perceive to be the costs of things like servicing, fuel and so on. Someone who's only just started looking into a 500 simply doesn't know what servicing or tyres are going to cost them.

This is what I tried to get across in the other thread but sadly you just didn't want to listen.

But whatever, I doubt you'll care if someone buys a 500 based on the figures in your spreadsheet and the actual cost of owning it is a lot more......

 

[rkt2003]

You can add on additional costs in, i added on £800 for the m-jet running costs which came to an additional £250 per year running costs .

 

[306maxi]

You can add on additional costs in, i added on £800 for the m-jet running costs which came to an additional £250 per year running costs .

Yes, but if you don't want to add in additional costs then you don't need to and it may make one car look better than another when in reality the opposite is true.

 

[RobW]

if you really want a cheap small Fiat you should buy Panda

 

[rkt2003]

Yes, but if you don't want to add in additional costs then you don't need to and it may make one car look better than another when in reality the opposite is true.

Have you completed yours with all the factors included?

 

[306maxi]

Have you completed yours with all the factors included?

Mine includes tyre wear and has a figure in there for extra servicing which Cowabunga's doesn't.

This is basically just a standard total cost of ownership comparison chart which just like the ones on parkers, doesn't take into account the apetite of some models for tyres and realistic costs for servicing. Which cowabunga would be aware of if he'd actually had long term experience on the forum and knew the foibles of the certain models. But hey, let's not try and give potential owners a realistic picture of the cost of ownership

 

[rkt2003]

Mine includes tyre wear and has a figure in there for extra servicing which Cowabunga's doesn't.

This is basically just a standard total cost of ownership comparison chart which just like the ones on parkers, doesn't take into account the apetite of some models for tyres and realistic costs for servicing. Which cowabunga would be aware of if he'd actually had long term experience on the forum and knew the foibles of the certain models. But hey, let's not try and give potential owners a realistic picture of the cost of ownership

That`s what we are here for to help each other& new members (me less due to my long hours at work lol.) But enjoying catching up, i say well done for your efforts people!

 

[cowabunga]

Have you completed yours with all the factors included?

Of course he hasnt. Just doesnt understand how basic his methodology and mindset is.

In all the excitement I forgot about tyres (Only likely to be 2-3% of total cost but a critical ommission according to some which makes my model wortless, lol) , I will revise and submit as V4 shortly.

In the meantime ask the troll to post his v basic model he posted on the other thread, we could all do with a good laugh again.