Go Back   Team-BHP > BHP India > What Car? > Hatchbacks


Closed Thread
 
LinkBack Thread Tools Search this Thread
Old 24th March 2008, 10:53   #1
BHPian
 
Join Date: Jan 2008
Location: Chennai
Posts: 80
Thanked: 0 Times
Default Petrol Vs. Diesel (Swift Dzire)

Maybe the Petrol Vs. Diesel debate has been discussed to death before. However, the usual quote of breakeven if its 20000km/yr (or near about) travel to break even for diesel prompted me to do some calculations.

I've published a Google Spreadsheet comparing Swift Dzire Petrol and Diesel.

In the spreadsheet, I've assumed the following (for my case)
* Period for calculations - 5yrs
* Average yearly usage of ~6500km, increasing yearly by 10%.
* Petrol price increasing by Rs.2/- every year, beginning at Rs.52.
* Diesel price increasing by Re.1/- every year, beginning at Rs.37.
* Average mileage of Swift Dzire Petrol @ 11km/ltr and Diesel @ 14km/ltr (adopted from Swift's mileage according to IndiaAutomobile.com).

The sheet is also downloadable in XLS format from here. It provides an option to include/omit yearly distance increase, include/omit fuel price increase, etc. Feel free to play with it.

I have not included
* maintenance charges
* interest calculations on loan and related offsets

The calculation shows me that with a 10% increase in distance per year, break even occurs when first year travel is about 7000km/yr.

Without a 10% yearly increase in travel, break even occurs at about 8700km/yr.

Both of these are a far cry from the oft-quoted 15-20K km/yr mentioned frequently as break even for diesel vehicles. Note that I'm considering a diff of about 1Lac between petrol and diesel vehicles. For anything more than this, the break even point obviously increases.

I'm requesting fellow t-bhpians to validate the model and let me know if my inferences are right or whether I'm missing something.
sudhirlp is offline  

Old 24th March 2008, 11:44   #2
Team-BHP Support
 
Eddy's Avatar
 
Join Date: Apr 2007
Location: Delhi
Posts: 5,213
Thanked: 1,331 Times
Default

Err... quick question. How is the value in cell number C6 calculated ? If your daily run is 12 km on a weekday and 45 on a weekend, no way can you have 2400 as your monthly run.
Eddy is online now  
Old 24th March 2008, 11:55   #3
BHPian
 
amitwiz1's Avatar
 
Join Date: Aug 2007
Location: Bangalore
Posts: 187
Thanked: 6 Times
Default

^Try grouping the values.. havent looked at the sheet
amitwiz1 is offline  
Old 24th March 2008, 12:00   #4
Senior - BHPian
 
ram_hyundai's Avatar
 
Join Date: Jun 2006
Location: trivandrum,alleppey
Posts: 1,916
Thanked: 13 Times
Default

How did you calculate break even when you dont know the pricing of the car.The pricing of the car would be out in a day or two so that you can make a recalculation of the same.Good effort though.
ram
ram_hyundai is offline  
Old 24th March 2008, 12:17   #5
BHPian
 
Join Date: Jan 2008
Location: Chennai
Posts: 80
Thanked: 0 Times
Default

Quote:
Originally Posted by Eddy View Post
Err... quick question. How is the value in cell number C6 calculated ? If your daily run is 12 km on a weekday and 45 on a weekend, no way can you have 2400 as your monthly run.
My sheet shows 420, not 2400. Not sure if something is amiss somewhere. Which version (html, xls download) shows 2400 ?

420 = 12*5*5+45*4.

USING 4 Weeks a month.

Cell A9 provides an opportunity to include the duration lost due to assuming 4 weeks per month. For all practical purposes, that "slip" is about 28 days or approximately 1 month. I'm leaving that out in my calculation on account of holidays, travel other than road, etc. The worksheet provides an option to include that as well.

Quote:
Originally Posted by ram_hyundai View Post
How did you calculate break even when you dont know the pricing of the car.The pricing of the car would be out in a day or two so that you can make a recalculation of the same.Good effort though.
ram
This is a framework for calculation and uses a fair value assumption today. Plugging in the exact values tomorrow/day-after will provide the correct figures.

I want to vet the model rather than exact numbers at this point of time. If someone can provide a good handle on the maintenance charges part, I can plug that in as well (with an option to include/exclude it from calculations).

Last edited by Technocrat : 24th March 2008 at 17:25.
sudhirlp is offline  
Old 24th March 2008, 12:58   #6
BHPian
 
praveen_v's Avatar
 
Join Date: Feb 2008
Location: Chennai
Posts: 328
Thanked: 0 Times
Default

Quote:
Originally Posted by sudhirlp View Post
I have not included
* maintenance charges
* interest calculations on loan and related offsets

The calculation shows me that with a 10% increase in distance per year, break even occurs when first year travel is about 7000km/yr.

Without a 10% yearly increase in travel, break even occurs at about 8700km/yr.
That is a good effort. But maintanance cost and interest on the extra lakh also contribute a significant amount and have a major factor on the break-even point.

AFAIK diesels have service frequency of 5K Kms against the 10K Kms of the petrols.
praveen_v is offline  
Old 24th March 2008, 13:56   #7
BHPian
 
Join Date: Jan 2008
Location: Chennai
Posts: 80
Thanked: 0 Times
Default

Quote:
Originally Posted by praveen_v View Post
That is a good effort. But maintanance cost and interest on the extra lakh also contribute a significant amount and have a major factor on the break-even point.
The catch with interest rate part is that different people have different preferences, requirements.

For now, I've added a static interest rate of 11.75% for 5 yrs, taking into consideration rates from Bank of Maharashtra (the best deals my friend and I found in general). Total interest amount works out to around 34K.

The break even including this interest boils to around 9300km in first year (increasing 10% every year).

Quote:
Originally Posted by praveen_v View Post
AFAIK diesels have service frequency of 5K Kms against the 10K Kms of the petrols.
Will be good to have an indicative cost range for an year (assuming there are no other major problems).
sudhirlp is offline  
Old 24th March 2008, 14:07   #8
Team-BHP Support
 
Eddy's Avatar
 
Join Date: Apr 2007
Location: Delhi
Posts: 5,213
Thanked: 1,331 Times
Default

The excel version shows C6 as 2400 monthly running
Eddy is online now  
Old 24th March 2008, 14:26   #9
BHPian
 
Join Date: Jan 2008
Location: Chennai
Posts: 80
Thanked: 0 Times
Default

Quote:
Originally Posted by Eddy View Post
The excel version shows C6 as 2400 monthly running
This has been corrected now. Some problem with operator (+, *) precedence !
sudhirlp is offline  
Old 24th March 2008, 16:22   #10
BHPian
 
Join Date: Sep 2007
Location: Chennai
Posts: 290
Thanked: 6 Times
Default

Similar detailed analysis has already been done in
http://www.team-bhp.com/forum/indian...tml#post398485 (Maruti Swift diesel @ Rs 4.68 lakh) (Maruti Swift diesel @ Rs 4.68 lakh)

You can use that model
druva is offline  
Old 24th March 2008, 16:37   #11
Senior - BHPian
 
svsantosh's Avatar
 
Join Date: Mar 2008
Location: Hosur
Posts: 3,151
Thanked: 954 Times
Wink

for a moment I thought I am in the Microsoft Excel help desk, Just kidding, , But a quick add on, Swift DDIS avg in not 14 even in the worst scenario;s, One can expect 17-18 anytime in AC mode too. I personally have experienced it. If its any less then you must be in a city with parking lots between signals (Meant the jams)
svsantosh is offline  
Old 24th March 2008, 17:14   #12
Senior - BHPian
 
trrk's Avatar
 
Join Date: Feb 2004
Location: Alleppey, Kerala
Posts: 2,114
Thanked: 7 Times
Default

Hi,

> AFAIK diesels have service frequency of 5K Kms against the 10K Kms of the
> petrols.

The Viva CRDi I had between Nov 04 and Dec 05, had a 10000kms service interval. It had 2 services with me (10000, 20000) costing me Rs 2200.00. The charges were for the air and fuel filters as Hyundai was not charging for oil and oil filters even for free services then.

I assume the same cycle of services for the Accent CRDi. Not sure about the new launces, though.

The diesel Innova's oil change interval is 10000kms though there is a 5000km checkup.

In contrast, my Honda CVT has a 5000km oil change cycle, but the oil filter is changed only every 10000km. Strange, and useless wastage of engine oil, in my opinion.
trrk is offline  
Old 24th March 2008, 17:25   #13
Team-BHP Support
 
Technocrat's Avatar
 
Join Date: Feb 2004
Location: Central NJ
Posts: 13,862
Thanked: 1,589 Times
Exclamation Thread Closed

Quote:
Originally Posted by sudhirlp
Maybe the Petrol Vs. Diesel debate has been discussed to death before.
Yes this is correct, please search the forum & post this in one of the existing threads.

Thread Closed
Technocrat is offline  
Closed Thread


Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads
Thread Thread Starter Forum Replies Last Post
Swift VDI/Ford Ikon D/Swift Dzire Diesel udit78 Hatchbacks 12 28th February 2009 23:54
Perfomance of Petrol Swift Dzire kjrohit Sedans 3 13th September 2008 14:27
Dzire/Estilo/Swift - Petrol/Diesel sam_sant2005 Sedans 1 8th April 2008 20:22
Swift Dzire Petrol Vs. Swift Dzire Diesel reveal_da_zeal The Indian Car Scene 2 4th April 2008 21:52


All times are GMT +5.5. The time now is 12:29.

Copyright 2000 - 2014, Team-BHP.com
Proudly powered by E2E Networks