  Thread Tools  Search this Thread 
17th October 2017, 10:15  #16 
BHPian Join Date: Nov 2007 Location: Bangalore
Posts: 740
Thanked: 783 Times
 Re: Revenue calculation of cars sold in India  How many $$$ each model brings to its maker Thank you for doing this on a consistent basis. I love reading these statistics that show how much these guys are raking in. While we can talk a lot about sales positions etc. in the end, it's the money that matters for these manufacturers. Also, this could be an indication of how much they are willing to invest in future models or variants. 
(1) Thanks 

17th October 2017, 10:19  #17 
BHPian Join Date: Aug 2017 Location: Bengaluru
Posts: 106
Thanked: 361 Times
 Re: Revenue calculation of cars sold in India  How many $$$ each model brings to its maker This is a tremendous effort JpCoolGuy, Amazing! Humongous data that you have collected, analyzed and presented it lucidly. Since this effort has now completed one year, may be some charts on revenue trends of manufacturers over the year would be interesting to study. Examples: Volume chart of different makers over the year, Revenue chart, Volume vs Revenue chart  the way different manufacturers have adjusted their strategies over the year and the effect on their revenues. Since you have so much of data, may be we can derive meaningful information from them. 
(1) Thanks 
4th November 2017, 14:54  #18  
BHPian Join Date: Jan 2016 Location: Chennai
Posts: 244
Thanked: 526 Times
 Re: Revenue calculation of cars sold in India  How many $$$ each model brings to its maker Quote:
Only thing I can do is to extrapolate the prices of Dec '16 to first 3 months of 2017 and extrapolate the prices of Jun '17 to the next 3 months of 2017, which would lead to more approximation. I can continue this exercise for another 2 months and may be we can have the charts for 6 months atleast in Jan '18.  
(1) Thanks 
10th November 2017, 22:46  #19 
BHPian Join Date: Jan 2016 Location: Chennai
Posts: 244
Thanked: 526 Times
 Re: Revenue calculation of cars sold in India  How many $$$ each model brings to its maker Revenue Calculation data for last month sales  Oct '17. Top 25 Cars based on Revenue (calculated based on 75th Percentile of the Avg. ExShowroom Price): 1. Dzire has cooled down to 20K levels, from the humongous 33K levels for past 2 months, but still kept the top position  the revenue was "just" 1339 crores. 2. Baleno has retained the second position, but Creta and Innova surpassed Brezza and pushed it to 5th position. But, mind you, all these are very closely placed and these numbers are just approximations, so it could be either Brezza, Creta or Innova in 3rd/4th/5th  take your pick. 3. Hyundai has Grand i10 and i20 at 6th and 7th positions respectively and Maruti Suzuki has filled the last 3 positions in the Top10. 4. Maruti Suzuki has 6 cars in Top 10, Hyundai has 3 and Toyota has Innova. Maruti Suzuki also has Celerio just outside of Top10. 5. In Top 25 positions, Maruti Suzuki has 10 cars, followed by Hyundai with 5 cars, M&M with 3 cars, Toyota and Honda with 2 each and Tata, Jeep and Renault sharing the remaining 3 positions with 1 each. 7. Bolero is the highest ranking car (at 13) for M&M, City (at 16) for Honda, Compass (at 17) for Jeep, Tiago (at 22) for Tata, Kwid (at 23) for Renault, Polo (at 33) for VW, Endeavor (at 41) for Ford, Rapid (at 43) for Skoda, RediGo (at 46) for Datsun, Micra (at 55) for Nissan and Punto (at 73) for Fiat. 7. Xcent (24 / 27), Eeco (17 / 29), KUV 100 (23 / 30) and Omni (14 / 34) from the Top25 based on sales volume have moved out of the Top25 chart based on sales revenue. They are replaced by Fortuner (35 / 12), Compass (33 / 17), Scorpio (26 / 18) and XUV500 (30 / 19)  note that the first value within brackets denotes the Volume rank and the second value denotes the corresponding Revenue rank. 8. Compared to the last month's (Sep '17) Top25 revenue ranking, Ecosport (59 / 18), Ignis (31 / 24) and Eeco (29 / 25) have moved out and they are replaced by SCross (14 / 57), Celerio (11 / 29) and Eon (25 / 31)  note that the first value within brackets denotes Oct '17 Revenue rank and the second value denotes the Sep '17 Revenue rank. Top 25 Cars based on Sales Volume (and their corresponding Revenue rank): OEM's Volume Market Share Vs Revenue Market Share: 1. As always, Maruti Suzuki's revenue market share is approx. 8% lesser than their volume market share. As someone suggested, I have also taken the Ratio which is really a good metric to understand the Revenue Vs Volume figures. Maruti is gaining 0.84 revenue per car sold, whereas Toyota is exactly doubling the rate (ratio at 2.0). 2. Renault, Tata & Datsun are the manufacturers other than Maruti to see a fall in terms of Revenue Market Share compared to the Volume Market Share  as expected, due to their larger volume in small cars. 3. RenaultNissanDatsun alliance has bigger market share in terms of Volume (5.21%), but when it comes to Revenue they have only 3.36% (lesser by 1.85%, when compared to volume market share). P.S.: Please note the revenues for the 3 Germans, JLR, Volvo, Porsche and other Luxury car makers are not included, who may have more revenue market share when compared to their minimal volume market share. For example, Mercedes Benz's revenue might be close to VW's revenue or may be more than that and this might have some impact in the actual revenue calculations. But, we do not have the individual numbers of the Luxury cars to do the calculation. Full Chart for your perusal: Last edited by jpcoolguy : 10th November 2017 at 22:48. 
(4) Thanks 
10th November 2017, 23:26  #20 
BHPian Join Date: Aug 2017 Location: Bengaluru
Posts: 106
Thanked: 361 Times
 Re: Revenue calculation of cars sold in India  How many $$$ each model brings to its maker Thanks again for sharing JP. The story of Compass is intriguing. The revenue to volume share ratio is astounding 2.14. If I assume Toyota's major bread winners are Innova and Fortuner, that sums up to 1275 Cr. The Compass alone is 324 Cr. That would be 25% of Toyota's revenue. Achieving these figures in just 3 months by someone with barely any service and sales network is astonishing. 
(1) Thanks 
27th December 2017, 13:03  #21 
BHPian Join Date: Jan 2016 Location: Chennai
Posts: 244
Thanked: 526 Times
 Re: Revenue calculation of cars sold in India  How many $$$ each model brings to its maker Revenue Calculation data for last month sales  Nov '17. Top 25 Cars based on Revenue (calculated based on 75th Percentile of the Avg. ExShowroom Price): 1. This month, we have 3 cars surpassing the 1000 Cr thresold  Dzire, Baleno and Brezza (all in that order), all belonging to Maruti Suzuki. It's very surprising that when other manufacturers have posted negative growth this month, MSIL keeps churning out money making machines. No wonder the shares of MSIL is at an all time high. 2. Innova and Creta complete the Top 5, with Creta losing some steam this month. 3. Again MSIL has Alto and Swift in 6th and 7th positions respectively, followed by the regular entries from Hyundai  Grand i10 and i20, with WagonR rounding off the Top 10 list. 4. Maruti Suzuki has 6 cars in Top 10, Hyundai has 3 and Toyota has Innova (Toyota also has Fortuner at 11th position, just outside of Top 10). 5. In Top 25 positions, Maruti Suzuki has 11 cars (only these 3 cars  Ignis, Omni and Gypsy out of 14 cars in their portfolio are outside of Top 25), followed by Hyundai with 4 cars, M&M, Toyota, Honda and Tata with 2 each and Jeep and Ford sharing the remaining 2 positions with 1 each. 6. No cars from Renault, this time, inside Top 25 (Kwid is at 27). Compass has moved upto 13th position and Nexon is a new entrant in Top 25  well done both. 7. Ecosport is the highest ranking car (at 12) for Ford, Compass (at 13) for Jeep, Scorpio (at 14) for M&M, City (at 18) for Honda, Tiago (at 19) for Tata, Kwid (at 27) for Renault, Polo (at 38) for VW, Rapid (at 44) for Skoda, RediGo (at 49) for Datsun, Micra (at 55) for Nissan and Punto (at 75) for Fiat. 8. Ignis (25 / 26), Kwid (15 / 27), Eon (17 / 28) and Omni (13 / 31) from the Top25 based on sales volume have moved out of the Top25 chart based on sales revenue. They are replaced by Fortuner (31 / 11), Compass (29 / 13), City (27 / 18) and SCross (26 / 24)  note that the first value within brackets denotes the Volume rank and the second value denotes the corresponding Revenue rank. 9. Compared to the last month's (Oct '17) Top25 revenue ranking, XUV 500 (32 / 19), Kwid (27 / 23) and Eon (28 / 25) have moved out and they are replaced by Ecosport (12 / 59), Nexon (21 / 26) and Eeco (25 / 29)  note that the first value within brackets denotes Nov '17 Revenue rank and the second value denotes the Oct '17 Revenue rank. Top 25 Cars based on Sales Volume (and their corresponding Revenue rank): OEM's Volume Market Share Vs Revenue Market Share: 1. Due to their dependency on smaller cars, Maruti Suzuki's revenue market share is approx. 8% lesser than their volume market share. In terms of Ratio of revenue per number of cars sold  Maruti has a ratio of 0.84, whereas Toyota, Jeep and Skoda (with their minuscule portfolio but having larger cars) are more than doubling their revenue per number of cars sold. 2. To understand better, Maruti has to sell 119 cars (per every 100 cars sold in the market) to break even in Revenue terms (which anyway they sell happily more than any other manufacturers, churning out blockbuster products), whereas Toyota/Jeep/Skoda have to sell only 49 cars (per every 100 cars sold in the market) to break even (and they have been contend to do so, by not introducing the mass market cars). Datsun has sell approx. 204 cars (per every 100 cars), since their ratio is only 0.49. Renault is the other manufacturer who has least ratio than Maruti, with 0.77, needing to sell at least 129 cars (per every 100 cars). 3. Renault, Tata & Datsun are the manufacturers other than Maruti to see a fall in terms of Revenue Market Share compared to the Volume Market Share  as expected, due to their larger volume in small cars. P.S.: Please note the revenues for the 3 Germans, JLR, Volvo, Porsche and other Luxury car makers are not included, who may have more revenue market share when compared to their minimal volume market share. For example, Mercedes Benz's revenue might be close to VW's revenue or may be more than that and this might have some impact in the actual revenue calculations. But, we do not have the individual numbers of the Luxury cars to do the calculation. Full Chart for your perusal: 
(8) Thanks 
8th January 2018, 12:54  #22 
BHPian Join Date: Jan 2016 Location: Chennai
Posts: 244
Thanked: 526 Times
 Re: Revenue calculation of cars sold in India  How many $$$ each model brings to its maker Recently, saw a recent article in Autopunditz w.r.t the sales split up based on fuel type (Petrol / Diesel). http://www.autopunditz.com/autopedia...ngervehicles/ So, I thought of using this split up to incorporate few changes in the revenue calculation model, to increase the accuracy of the calculations  but remember still these are approximations. Now, I need to tweak the logic, in order to capture the exshowroom price of Petrol and Diesel variants separately and then calculating the 75th Percentile of the price and also to change the GST + Cess % accordingly  29% for Petrol cars in < 4m segment and 31% for Diesel cars in < 4m segment. And that is humongous amount of data to be processed and let me try to incorporate these changes in the latest monthly sales  Dec '17, which is yet to be published. The existing logic will still hold true for all the vehicles powered by a single fuel type  either Petrol or Diesel. For all the other vehicles, which has both Petrol and Diesel variants, the new logic will have more accuracy since the 75th Percentile price will be calculated separately for Petrol and Diesel variants. In the earlier logic, the 75th percentile price will always be in the Diesel variants territory. The cars which are Petrol biased (like Baleno, Grand i10, Tiago, Ignis, Jazz, City, Tigor, Micra, etc) will be negatively impacted by this new calculation  their revenue may be scaled down. On the other hand, the cars which are Diesel biased (like Ecosport, Compass, Nexon, Etios, Duster, Rapid, Zest, Tucson, Bolt, Terrano, etc) will be positively impacted  their revenue may be scaled up. There are also some cars which are almost neutral (like Ameo, Dzire, Verna, Ciaz, WRV, Liva, Aspire, BRV, etc) which will be marginally impacted, due to new calculations. I will try to explain the logic changes with few examples shown below, based on Nov '17 data  I had taken the examples from both the extremes as stated above. Example # 1: Maruti Suzuki Ignis Petrol  93% and Diesel  7% Old Calculation Logic: 75th Percentile  725,000 GST + Cess  30% Final Price  557,692 So, the revenue from the 3,412 units sold in Nov '17 was 190.28 Cr (557,692 x 3,412). New Calculation Logic: Now, the revenue calculation formula is  3,412 x 0.93 x 503,876 + 3,412 x 0.07 x 580,153 = 173.74 Cr. Example # 2: Tata Nexon Petrol  29% and Diesel  71% Old Calculation Logic: 75th Percentile  875,000 GST + Cess  30% Final Price  673,077 So, the revenue from the 4,163 units sold in Nov '17 was 280.2 Cr (673,077 x 4,163). New Calculation Logic: Now, the revenue calculation formula is  4,163 x 0.29 x 624,031 + 4,163 x 0.71 x 706,107 = 284.04 Cr. As mentioned earlier, you can see how the revenues are impacted for both type of vehicles. I will incorporate these calculations as part of Dec '17 revenue calculations and post them here. 
(5) Thanks 
10th January 2018, 14:23  #23 
BHPian Join Date: Jan 2016 Location: Chennai
Posts: 244
Thanked: 526 Times
 Re: Revenue calculation of cars sold in India  How many $$$ each model brings to its maker Revenue Calculation data for last month sales  Dec '17. Note: Please refer to my previous post, on the new calculations based on the Fuel splitup, in order to increase the accuracy of the numbers (but mind you, these are still just approximate numbers, mostly the projections based on few assumptions and few facts). Top 25 Cars based on Revenue (calculated based on 75th Percentile of the Avg. ExShowroom Price): 1. As the year end sales are sluggish as expected, we have only Dzire crossing the 1000 Cr thresold. 2. The usual suspects, Baleno, Brezza and Innova follows Dzire with a surprise entry of Grand i10 in 5th position. Creta, with a below average month, moved down the pecking order to 8th position. 3. i20, Alto and Swift, WagonR sandwiches Creta completing the Top10. 4. Maruti Suzuki has 6 cars in Top 10, Hyundai has 3 and Toyota has Innova. City has improved to 11th position and Compass has moved up one position to 12th, with Fortuner moving down 2 positions to 13th. 5. In Top 25 positions, Maruti Suzuki has 11 cars (only these 3 cars  Ignis, Omni and Gypsy out of 14 cars in their portfolio are outside of Top 25), followed by Hyundai with 4 cars, M&M, Toyota, Honda and Tata with 2 each and Jeep and Renault sharing the remaining 2 positions with 1 each. 6. City is the highest ranking car (at 11) for Honda, Compass (at 12) for Jeep, Scorpio (at 14) for M&M, Nexon (at 16) for Tata, Kwid (at 20) for Renault, Aspire (at 30) for Ford, Polo (at 37) for VW, Rapid (at 38) for Skoda, RediGo (at 48) for Datsun, Micra (at 61) for Nissan and Punto (at 76) for Fiat. 7. Xcent (25 / 28) and Omni (14 / 33) from the Top25 based on sales volume have moved out of the Top25 chart based on sales revenue. They are replaced by Fortuner (36 / 13) and Ciaz (26 / 25)  note that the first value within brackets denotes the Volume rank and the second value denotes the corresponding Revenue rank. 8. Compared to the last month's (Nov '17) Top25 revenue ranking, Ecosport (32 / 12) and Verna (26 / 16) have moved out and they are replaced by Kwid (20 / 27) and Eon (23 / 28)  note that the first value within brackets denotes Dec '17 Revenue rank and the second value denotes the Nov '17 Revenue rank. Top 25 Cars based on Sales Volume (and their corresponding Revenue rank): OEM's Volume Market Share Vs Revenue Market Share: 1. Due to their dependency on smaller cars, Maruti Suzuki's revenue market share is approx. 8% lesser than their volume market share. In terms of Ratio of revenue per number of cars sold  Maruti has a ratio of 0.83, whereas Toyota, Jeep and Skoda (with their minuscule portfolio but having larger cars) are more than doubling their revenue per number of cars sold. 2. To understand better, Maruti has to sell 120 cars (per every 100 cars sold in the market) to break even in Revenue terms (which anyway they sell happily more than any other manufacturers, churning out blockbuster products). Below is the list with number of cars, every manufacturer have to sell, per 100 cars sold in the market. Number of Cars, to be sold, per 100 cars, in order to break even in revenue terms: Maruti Suzuki  120 Hyundai  99 Toyota  49 M&M  83 Honda  81 Tata  104 Ford  82 Renault  143 Jeep  45 VW  84 Skoda  48 Datsun  196 Nissan  103 Fiat  97 Mitsubishi  32 3. The Sales Volume have been down by 13.24% this month, when compared to last month, whereas the Sales Revenue have been down by 16.93%. P.S.: Please note the revenues for the 3 Germans, JLR, Volvo, Porsche and other Luxury car makers are not included, who may have more revenue market share when compared to their minimal volume market share. For example, Mercedes Benz's revenue might be close to VW's revenue or may be more than that and this might have some impact in the actual revenue calculations. But, we do not have the individual numbers of the Luxury cars to do the calculation. Full Chart for your perusal: 
(4) Thanks 
9th February 2018, 21:22  #24 
BHPian Join Date: Jan 2016 Location: Chennai
Posts: 244
Thanked: 526 Times
 Re: Revenue calculation of cars sold in India  How many $$$ each model brings to its maker Revenue Calculation data for last month sales  Jan '18. Top 25 Cars based on Revenue (calculated based on 75th Percentile of the Avg. ExShowroom Price): 1. After the lacklustre December, January seems to have been very good for most of the manufacturers. We have 2 cars this time in 1000 Cr. club  Dzire and Baleno. 2. Vitara Brezza have been pushed down to 5th position, due to pretty good sales for Innova and Creta both of which have leapfrogged Brezza and occupies the 3rd and 4th slots. 3. Swift, i20, i10, WagonR and Alto forms the bottom five of the Top10 positions respectively. 4. Maruti Suzuki has 6 cars in Top 10, Hyundai has 3 and Toyota has Innova. Ecosport with its best ever sales is just outside of Top10 in the 11th position and City was pushed down to 17th from the 11th slot last month. 5. In Top 25 positions, Maruti Suzuki has 10 cars, followed by Hyundai with 4 cars, M&M with 3 cars, Toyota, Honda and Tata with 2 each and Ford and Jeep sharing the remaining 2 positions with 1 each. No Renault this time in Top25, instead Ford has entered inside. 6. Ecosport is the highest ranking car (at 11) for Ford, Scorpio (at 12) for M&M, City (at 17) for Honda, Nexon (at 18) for Tata, Compass (at 24) for Jeep, Kwid (at 31) for Renault, Polo (at 39) for VW, RediGo (at 46) for Datsun, Rapid (at 47) for Skoda, Micra (at 59) for Nissan, Pajero Sport (at 73) for HMMitsubishi and Punto (at 78) for Fiat. 7. Eon (16 / 27), Eeco (17 / 28), Kwid (18 / 31) and Omni (15 / 36) from the Top25 based on sales volume have moved out of the Top25 chart based on sales revenue. They are replaced by Fortuner (36 / 13), City (26 / 17), Compass (37 / 24) and XUV 500 (34 / 25)  note that the first value within brackets denotes the Volume rank and the second value denotes the corresponding Revenue rank. 8. Compared to the last month's (Dec '17) Top25 revenue ranking, Kwid (31 / 20), SCross (26 / 21), Eon (27 / 23) and Eeco (28 / 24) have moved out and they are replaced by Ecosport (11 / 32), Verna (15 / 28), Ciaz (16 / 26) and XUV 500 (25 / 38)  note that the first value within brackets denotes Jan '18 Revenue rank and the second value denotes the Dec '17 Revenue rank. Top 25 Cars based on Sales Volume (and their corresponding Revenue rank): OEM's Volume Market Share Vs Revenue Market Share: 1. Due to their dependency on smaller cars, Maruti Suzuki's revenue market share is approx. 8% lesser than their volume market share. In terms of Ratio of revenue per number of cars sold  Maruti has a ratio of 0.84, whereas Toyota is having a ratio of 2.09 more than doubling their revenue per number of cars sold. 2. To understand better, Maruti has to sell 119 cars (per every 100 cars sold in the market) to break even in Revenue terms. Below is the list with number of cars, every manufacturer have to sell, per 100 cars sold in the market. Number of Cars, to be sold, per 100 cars, in order to break even in revenue terms: Maruti Suzuki  119 Hyundai  96 M&M  84 Toyota  48 Honda  85 Tata  115 Ford  78 Renault  147 Jeep  46 VW  86 Skoda  49 Datsun  204 Nissan  106 Fiat  99 Mitsubishi  33 3. The Sales Volume has increased by 19.17% this month when compared to last month, and the Sales Revenue has increased by 21.56%. P.S.: Please note the revenues for the 3 Germans, JLR, Volvo, Porsche and other Luxury car makers are not included, who may have more revenue market share when compared to their minimal volume market share. For example, Mercedes Benz's revenue might be close to VW's revenue or may be more than that and this might have some impact in the actual revenue calculations. But, we do not have the individual numbers of the Luxury cars to do the calculation. Full Chart for your perusal: 
(2) Thanks 
Thread Tools  Search this Thread 
Similar Threads  
Thread  Thread Starter  Forum  Replies  Last Post 
How much profit do they make on each new car sold?  sbasak  The Indian Car Scene  49  19th October 2011 09:30 
2011 i10 Asta A/T  its Korean, its new, its fast, its red, and its coming.  nirupesh  TestDrives & Initial Ownership Reports  1  8th January 2011 10:45 
FIAT GROUP Q1: 13th Consecutive quarterly growth as revenue exceeds 15 billion Euros  sushanthr77  The International Automotive Scene  1  25th April 2008 15:53 
Completely Ignored Value/Revenue Chain  theMAG  The Indian Car Scene  26  24th November 2006 11:37 