Vehicle cost of ownership comparison tool

I created a very simple excel sheet that compares two cars on basic ownership on annual basis.  The key purpose was to allow comparison with an Hybrid 🙂 which since then expanded in applicability.

Link to the tool Basic Auto Ownership Comparer

The sheet allows comparison based on the the following,

  1. Purchase price (to work out payback in case the second car is more expensive in purchase but cheaper in running)
  2. Insurance (also allowed to indicate the insured amount, as under value is also a practice that we see commonly)
  3. Service
  4. Fuel economy, this has been broken into three groups rather than the usual two taking into account what we see here a lot in asia.  Also possible is the break the % of the driving conditions compared to the total mileage (the example has 80% City, 15% Urban and 5% highway, which is what i face)
    1. City – The worst nightmare, the bumper to bumper traffic with lots of stop and go and idle scenarios
    2. Urban – City (or driving in areas where there is still a degree of congestion) but when the traffic is low, but still with loads of stop and go scenarios, but less idle mode
    3. Long Distance / Highway – Where you can cruise at set speeds with minimal stop and go scenarios
  5. Other (to allow including ATF oil change, maybe change in batteries, timing belt vs timing chain costs, special tires, etc)
  6. Cost per liter of fuel
The comparison tool provides you a very high level capability to see the difference in fuel costs and include common annual costs (service, insurance) and then compare.  It also allows to identify the payback period of a car is say more expensive to purchase but cheaper on the annual running costs.
Would be great if blog commuters provide the following as comments to this post to help others compare vehicles.  I will post on my current vehicle and any that i have been tracking which are used by colleagues.
  • Vehicle Model
  • Model Year
  • Engine
  • City economy (kpl)
  • Urban economy (kpl)
  • Highway economy (kpl)
  • Other costs – Indicate any such as Hybrid Battery change, that were not the usual costs

4 thoughts on “Vehicle cost of ownership comparison tool”

  1. Vehicle Model Toyota corolla 2008 141
    Model Year 2007/ 2008 / 2009 – 141
    3ZZ-FE 1600CC

    7.5 – 8 KMPL City economy (kpl)
    10 -11 KMPL Urban economy (kpl)
    12 – 16 KMPL Highway economy (kpl)

    Every 5000 Engine Oil change / Service
    Every 10000 Oil filter
    Every 20000 Engine Tune up / Air filter / Brake pad / Wheel Alignment
    Every 30000 Tires
    Every 2 1/2 yrs or 30000KM Battery change
    Every 40000 ATF / Brake Fluid / Drive belt / Radiator Coolant
    Every 80000 Injector clean up / Petrol filter
    Every 100000 Suspension Repair / Replace

    0-100 in 10.1Sec
    Top speed :199KMPH (Officially 173KMPH) 😉

  2. • Vehicle Model: Suzuki A-Star Vxi AT
    • Model Year:2010
    • Engine: Suzuki KB10 – 998cc
    • City economy (kpl): 10-11kpl
    • Urban economy (kpl): 11-12kpl
    • Highway economy (kpl): 13-14kpl

  3. Vehicle Model: Toyota Prius ZVW30 (3rd generation)
    Model Year: 2010
    Engine: 1.8L
    City economy (kpl): 16 kmpl
    Urban economy (kpl): 20 kmpl
    Highway economy (kpl): 30 kmpl
    Other costs – service intervals every 15,000km since wear on the engine is less than normal, battery replacement period unknown.

  4. Vehicle Model: Honda Stream RN6 1.8 RSZ
    Model Year: 2007
    City economy (kpl): 7.5kmpl
    Urban economy (kpl): 9 kmpl
    Highway economy (kpl): 11 kmpl
    Other costs – ATF oil every 30,000km

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s