| |||||||
| Register | BHP Garage | Classifieds | Team-BHP FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Hatchbacks Alto, Indica, Swift, Fabia etc. |
![]() |
| | Thread Tools |
| | #1 (permalink) |
| BHPian Join Date: Jan 2008 Location: Chennai
Posts: 77
| 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. |
| |
| | #2 (permalink) |
| BHPian Join Date: Apr 2007 Location: Delhi
Posts: 853
| 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.
__________________ Car is no longer a luxury; parking space is. |
| |
| | #4 (permalink) |
| Senior - BHPian | 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
__________________ Become MAD SOON and join the MON SOON Drive. one more from me- hey MAN come SOON for the MONSOON drive |
| |
| | #5 (permalink) | ||
| BHPian Join Date: Jan 2008 Location: Chennai
Posts: 77
| Quote:
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:
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. | ||
| |
| | #6 (permalink) | |
| BHPian Join Date: Feb 2008 Location: Chennai
Posts: 295
| Quote:
AFAIK diesels have service frequency of 5K Kms against the 10K Kms of the petrols.
__________________ Anyone driving slower than you is an idiot, and anyone going faster than you is a maniac. ~Author Unknown | |
| |
| | #7 (permalink) | |
| BHPian Join Date: Jan 2008 Location: Chennai
Posts: 77
| Quote:
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). Will be good to have an indicative cost range for an year (assuming there are no other major problems). | |
| |
| | #10 (permalink) |
| BHPian Join Date: Sep 2007 Location: Chennai
Posts: 138
| 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 |
| |
| | #11 (permalink) |
| BHPian | 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)
__________________ Dont wear Helmets & Seatbelts to reach Heaven Faster You hardly have any time left in this world to be a sinner |
| |
| | #12 (permalink) |
| BHPian Join Date: Feb 2004 Location: Alleppey, Kerala
Posts: 363
| 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.
__________________ Rajesh -Marina LS, Oct 05, 44223 (44771) kms, 13.94 kpl -City CVT, Sep 07, 15423 kms, 13.23 kpl |
| |
| | #13 (permalink) | |
| Team-BHP Moderator ![]() | Quote:
Thread Closed
__________________ 180, 225, 150, ??? -> 159? | |
| |
![]() |
| Thread Tools | |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Swift Dzire - Short test drive and some pictures | Eddy | Test-Drives & Initial Ownership Reports | 262 | 25th July 2008 16:46 |
| Swift Petrol or Diesel? | rana_kirti | Hatchbacks | 56 | 6th May 2008 07:53 |
| swift (petrol/diesel) | rahul_9327 | Hatchbacks | 14 | 13th May 2007 12:03 |
| Help Choose: City vs Fiesta Diesel vs Verna Diesel vs Swift Diesel | aseem | Hatchbacks | 18 | 13th April 2007 15:02 |
| Diesel or Petrol hatchback ( Swift or Getz ) | navdeep | Hatchbacks | 6 | 10th November 2006 19:28 |
All times are GMT +5.5. The time now is 03:17.





, 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)
