EV_vs_Petrol_TCO_Calculator_EVKiReport.xlsx

	B	C	D
1	EV vs PETROL: Total Cost of Ownership Calculator
2	@evkireport \| No Hype. Just Real-Life Gyaan.
3	Bas apne numbers daalo - baaki sab automatic calculate hoga!
4
5	STEP 1: Apni Details Bharo (Yellow cells mein number daalo)
6	Aapki daily running	30	km/day
7	Mahine mein kitne din chalate ho?	25	days/month
8	Petrol ka rate (aapke area mein)	105	Rs./litre
9	Bijli ka rate (aapke area mein)	7.0	Rs./unit (kWh)
10	Petrol car mileage (city driving)	15	km/litre
11	EV efficiency (city, with AC)	7.0	km/kWh
12	Fast charging use (% of total charging)	20	% (0-100)
13	Fast charging rate	18	Rs./kWh (avg DC fast)
14
15	STEP 2: Monthly Fuel / Energy Cost (Auto-Calculated)
16	PETROL CAR	Calculation	Result
17	Monthly km driven	750
18	Petrol needed per month	50.0	litres
19	Monthly petrol cost	₹5,250
20
21	ELECTRIC VEHICLE	Calculation	Result
22	Monthly kWh needed	107.1	kWh
23	Home charging cost (per month)	₹600
24	Fast charging cost (per month)	₹386
25	Total monthly EV energy cost	₹986
26
27	STEP 3: Total Cost of Ownership - 5 Year Comparison
28	COST HEAD	PETROL CAR (5 Yr)	EV (5 Yr)
29	Car purchase price (on-road)	₹1,100,000	₹1,500,000
30	Fuel / Energy cost (5 years)	₹315,000	₹59,143
31	Insurance (avg annual premium x 5)	₹25,000	₹30,000
32	Maintenance / Servicing (5 years)	₹75,000	₹25,000
33	Tyre replacement (1 set in 5 years)	₹20,000	₹28,000
34	Battery replacement cost (if needed)	₹0	₹0
35	Resale value after 5 years (subtract)	₹450,000	₹500,000
36
37	TOTAL COST OF OWNERSHIP (5 Years)	₹1,185,000	₹1,262,143
38	Cost per km (total ownership)	₹26.33	₹28.05
39
40	YOUR RESULTS
41	Monthly fuel savings with EV	₹4,264	per month
42	Yearly fuel savings with EV	₹51,171	per year
43	5-Year TCO savings with EV	-₹77,143	over 5 years (total)
44	Break-even period	94	months
45	Break-even in years	7.8	years
46
47	VERDICT
48	Should you buy an EV?	WAIT - Abhi petrol/CNG better hai
49
50	Notes:
51	- Yellow cells = change these numbers to match YOUR situation
52	- Battery replacement: Most EVs have 8-year warranty. Put 0 if keeping <8 years, else ~Rs 3-5 lakh
53	- EV tyres cost more due to weight. Petrol ~Rs 4-5K/tyre, EV ~Rs 6-7K/tyre
54	- Insurance: EV premium slightly higher due to higher car value
55	- Maintenance: EVs have fewer moving parts = lower servicing cost
56	- Fast charging: DC fast chargers cost Rs. 15-22/kWh vs Rs. 5-8/kWh at home
57
58	Made by @evkireport \| Follow for daily EV Gyaan \| youtube.com/@evkireport
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100