Car Cost Comparison Calculator

Honest John Back Room » Motoring discussion
What is life like with your car? Let us know and win £500 in John Lewis vouchers | No thanks
View Threaded
Mon 12 Sep 2011 23:59
Car Cost Comparison Calculator - koksieboy

Hi all,

Over the last couple of weeks, I've been researching for the best option for my next car and I've had excellent recommendations on this forum. Based on these recommendations I decided to create an excel sheet to calculate the total cost of ownership (over 3 years) for different cars that I have considered. I’ve used actual available data (MPG, VED etc) and used prices for similar car specs (leather seats, SATNAV etc but not engine size) on Autotrader. This is just a little tool to help in my decision making and I thought to post it as a way of giving back to the forum for the excellent help to me and just in case someone else finds it useful.

It would be interesting to see which of the cars would be selected by most people, so please indicate your preferred choice if you were to buy any of the cars.

Item Description BMW 520d Auto BMW 520d BMW320d Auto BMW320d Insignia Elite Honda CRV Toyota RAV4 Nissan Qashqai Year (Reg) 2008(08) 2008 (08) 2008(08) 2008(08) 2009 (59) 2008 (08) 2008 (08) 2008(08) Current Milage 85000 82000 85191 102000 20000 80617 95000 70040 Tax Band F E E D H G E Insurance Grp 33.00 33.00 14(29) 14(29) 11(22) 12.00 12 (26) Fuel Economy (Combined) 50.00 55.00 53.30 60.10 49.60 44.00 47.00 54.30 Annual Mileage 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 10000.00 Cost £12,000.00 £12,000.00 £11,000.00 £8,995.00 £13,000.00 £10,790.00 £9,800.00 £10,799.00 Road Tax £130.00 £115.00 £115.00 £95.00 £130.00 £190.00 £165.00 £120.00 Insurance Cost £351.90 £351.90 £377.36 £369.78 £370.00 £342.89 £364.88 £400.00 fuel price £1.39 £1.39 £1.39 £1.39 £1.39 £1.39 £1.39 £1.39 Extended Warranty Cost £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 £0.00 Annual Fuel Cost £1,265.63 £1,150.57 £1,187.27 £1,052.94 £1,274.01 £1,438.22 £1,346.42 £1,165.41 Total cost 1st yr £13,747.53 £13,617.47 £12,679.63 £10,512.72 £14,774.01 £12,761.11 £11,676.30 £12,484.41 Total cost 2nd yr £15,495.06 £15,234.95 £14,359.26 £12,030.44 £16,548.01 £14,732.22 £13,552.59 £14,169.81 Total Cost 3rd yr £17,242.60 £16,852.42 £16,038.90 £13,548.16 £18,322.02 £16,703.32 £15,428.89 £15,855.22
Reply | Report as offensive | Link
Tue 13 Sep 2011 00:01
Car Cost Comparison Calculator - jamie745

Copycat! LOL!

Its a bit awkward to read like that maybe it'd be better if you could give us a link to download the excel sheet from and have a look ourselves.

Reply | Report as offensive | Link
Tue 13 Sep 2011 00:27
Car Cost Comparison Calculator - koksieboy

Yeah! I admit I got some idea from you....lol!

you can get the excel sheet from the link below......let me know if it works.

www.mediafire.com/download.php?b85daj0f502dzb3

Reply | Report as offensive | Link
Tue 13 Sep 2011 00:30
Car Cost Comparison Calculator - jamie745

Unzipped it with winRar and just got lots of mostly dead XML files.

Reply | Report as offensive | Link
Tue 13 Sep 2011 00:32
Car Cost Comparison Calculator - jamie745

One thing i can tell you without seeing the file is you can take that Nissan Qashqai out of there for a start! The Back Rooms most hated car!

Reply | Report as offensive | Link
Tue 13 Sep 2011 00:40
Car Cost Comparison Calculator - koksieboy

No need to unzip it......try this

download776.mediafire.com/ipwu372kpkmg/b85daj0f502...x

Reply | Report as offensive | Link
Tue 13 Sep 2011 23:52
Car Cost Comparison Calculator - barney100

Qashqais seem awful expensive to me, a mate bought one thats got bells and whistles and it cost him something like 27k. It's a nice nice car but nothing to justify that price I can see.

Reply | Report as offensive | Link
Wed 14 Sep 2011 00:25
Car Cost Comparison Calculator - jamie745

Thats alot of money for what is essentially a big hatchback.

Reply | Report as offensive | Link

A guide to how much VED you will need to pay on your car.

Road Tax Bands and Rates