ࡱ> $# - \pAmit Kumar Purohit Ba==x7w.8X@"19Arial19Arial19Arial19Arial19Arial1 9Arial159Arial19Arial1 9Arial19Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)                + ) , *     @ @  ,@ @  H   H  $@ @  H5 (0@ @  ,@ @  l@ @  @  D  ,@ @  `@ @ /   l@ @ /   L  h@ @ /   l@ @ /   ` Indica Vista"Sheet2#Sheet3",Y9UNote: Please enter inputs only in Pink color and Car A cost should be more than Car BCar A(Diesel) Vs Car B(Petrol)Units Car A costRsInputs Car B costOutputsDifference in costOptional InputsCar A Total CostCar B Total CostDifference in Total costCar A Fuel CostCar B Fuel Cost Car A average kms/litre Car B average'Car A Service Period (service interval)kms'Car B Service Period (service interval)Car A Service Cost -1timeCar B Service Cost -1timeACar A extra Maintenance cost (Through years of possesion of car)ACar B extra Maintenance cost (Through years of possesion of car)Car A Maintenance cost per kmCar B Maintenance cost per kmCar A Total Maintenance cost Car B Total Maintenance cost Car A Fuel Cost per kmCar B Fuel Cost per kmCar A Total Cost per kmCar B Total Cost per kmKms in a Month"Kms Extra for long trips in a year Kms YearlyKms at which Car is sold!No. of Years of Possession of CarYearsKms for BreakevenYears for BreakevenCar A Total Fuel CostCar B Total Fuel CostDifference in Total Fuel costCar A Total Running CostCar B Total Running CostCar A Total Cost of ownershipCar B Total Cost of ownership Difference Assumptions:1) Rate of Interest for calculation is based considering we keep the difference money in a Fixed Deposit in Bank for 8.5% (Cell7);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 of Years of Car ownership. Notes:{It shows that even after Car ownership of 85000kms or 8 years of possession of car still its economical to own a Petrol CarIt seems that over the coming years the difference between Diesel and Petrol Prices will become lower and so marginal gain with a diesel car wont make any economical sense.The above excel sheet already shows a calculation done for Indica Vista Aqua TDI (Diesel) Vs Indica Vista Saffire Aqua (Petrol) (Pune Onroad Prices)B>  [ M ]G # cc -  6"  dMbP?_*+%"??puU} *}  } }  6                            ~ $A   ~ A   !P@ DD    F'l2A0DD!@dD D?   AD   ! lT@! DD   ~ D@   ~ I@   ~ .@   ~ )@   ~ @  ~ @@  %b@ ,  !8@   ~ L@  ~   -|I?DDDD  -?DDDD  ! @, DD !0@ DD !UUUUUU@ D D   !@ D D   !NN @& DD   !fffff@' DD  !~ y@  "~  @  #%ȹ@ D D  $~ @  ! %! "|)@ DD &  ! D lLLYf;A4444**EA**MM==AAAA**E@! " # $ % & ' ( ) * + , - . / 0 1 2 3 4 5  !#'(!$LH,ϫ@"D DD !! % "#(!"$sB)@ D!D" ! #)!#UUUUU A% DD ## ! $*!$A# DD $$ ! %+!%VUUUU@  D$D# %% ! &,!&A( DD && ! '-!'A) DD '' ! (&.!('颋&A* DD& (( ! )&/!)'G&A DD' )) ! *#0!*'袋r@$ D)D( ** % + ! ,1, ! -2- ! .3. ! /4/ ! 0 ! 1 ! 252 ! 38 46 5(75)))).7^KWWWWWWWW$$$$$>@ 7 -  @#  dMbP?_*+%"??(U>@ 7 -  G$  dMbP?_*+%"??(U>@ 7 Oh+'0@Hd Amit Kumar PurohitAmit Kumar PurohitMicrosoft Excel@/^@HC_՜.+,0 PXh px Deere'  Indica VistaSheet2Sheet3  Worksheets  !"Root Entry FWorkbook$SummaryInformation(DocumentSummaryInformation8