Docstoc

Petrol_or_Diesel

Document Sample
Petrol_or_Diesel Powered By Docstoc
					Note: Please enter inputs only in Pink color and Car A cost should be more than Car B
Car A(Diesel) Vs Car B(Petrol)
                                                                   Units
Car A cost                                              428342.00 Rs
Car B cost                                              394927.00 Rs
Difference in cost                                       33415.00 Rs
Car A Total Cost                                        471604.30 Rs
Car B Total Cost                                        394927.00 Rs
Difference in Total cost                                 76677.30 Rs
Car A Fuel Cost                                              40.00 Rs
Car B Fuel Cost                                              50.00 Rs
Car A average                                                15.00 kms/litre
Car B average                                                12.50 kms/litre
Car A Service Period (service interval)                   5000.00 kms
Car B Service Period (service interval)                   8000.00 kms
Car A Service Cost -1time                                 2225.00 Rs
Car B Service Cost -1time                                 1550.00 Rs
Car A extra Maintenance cost
(Through years of possesion of car)                      15000.00 Rs
Car B extra Maintenance cost
(Through years of possesion of car)                           0.00 Rs
Car A Maintenance cost per km                                 0.62 Rs
Car B Maintenance cost per km                                 0.19 Rs
Car A Total Maintenance cost                             52825.00
Car B Total Maintenance cost                             16468.75
Car A Fuel Cost per km                                        2.67 Rs
Car B Fuel Cost per km                                        4.00 Rs
Car A Total Cost per km                                       3.29 Rs
Car B Total Cost per km                                       4.19 Rs
Kms in a Month                                              400.00 kms
Kms Extra for long trips in a year                        1800.00 kms
Kms Yearly                                                6600.00 kms
Kms at which Car is sold                                 85000.00 kms
No. of Years of Possession of Car                            12.88 Years
Kms for Breakeven                                        84668.97 kms
Years for Breakeven                                          12.83
Car A Total Fuel Cost                                   226666.67 Rs
Car B Total Fuel Cost                                   340000.00 Rs
Difference in Total Fuel cost                           113333.33 Rs
Car A Total Running Cost                                279491.67 Rs
Car B Total Running Cost                                356468.75 Rs
Car A Total Cost of ownership                             751,096 Rs
Car B Total Cost of ownership                             751,396 Rs
Difference                                                     300 Rs

Assumptions:
1) Rate of Interest for calculation is based considering we keep the difference money in a Fixed Deposit in Bank for
2) 20% Depreciation on the Difference in Total Cost (Cell9)
3) This excel sheet does not take into consideration the price increase in costs of petrol and diesel over the period o
Notes:
The above excel sheet already shows a calculation done for Indica Vista Aqua TDI (Diesel) Vs Indica Vista Saffire A
It shows that even after Car ownership of 85000kms or 8 years of possession of car still its economical to own a Pe
It seems that over the coming years the difference between Diesel and Petrol Prices will become lower and so marg
             Inputs
             Outputs
             Optional Inputs




e money in a Fixed Deposit in Bank for 8.5% (Cell7)

ts of petrol and diesel over the period of Years of Car ownership.
 a TDI (Diesel) Vs Indica Vista Saffire Aqua (Petrol) (Pune Onroad Prices)
n of car still its economical to own a Petrol Car
  Prices will become lower and so marginal gain with a diesel car wont make any economical sense.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:6
posted:10/6/2011
language:English
pages:4