Cost to performance comparison chart for airconditioners

[blr_p]

Re: Compare & Suggest Best VFM Split AC

Only models from BEE's list here

1 TONNER's

Manufacturer|

Voltas​

|

Voltas​

|

Whirlpool​

|

LG​

|

Voltas​

|

LG​

|

Carrier​

|
AC Type|

WIN​

|

SPLIT​

|

SPLIT​

|

SPLIT​

|

SPLIT​

|

SPLIT​

|

SPLIT​

|
Model#|

Plus 1T​

|

Plus 1T​

|

WASR12K30 1T​

|

LSA3FG3V TY1 1T​

|

Gold 1T​

|

LSA3ZB/G/S5NTY1 1T​

|

Estrella 1T​

|
AC Cost Price (CP) (MRP - Rs.500 or other quote)|

Rs.15,500​

|

Rs.22,000​

|

Rs.22,000​

|

Rs.24,500​

|

Rs.25,500​

|

Rs.25,500​

|

Rs.28,500​

|
Nominal Cooling Capacity (BTU/Hr) [specs]|

12000​

|

12000​

|

11704​

|

11997​

|

12000​

|

11997​

|

13300​

|
Nominal Cooling Capacity (Watts) [specs]|

3517​

|

3517​

|

3430​

|

3516​

|

3517​

|

3516​

|

3898​

|
(i) Nominal Cooling Capacity (Watts) [BEE] |

3510​

|

3510​

|

3430​

|

3516​

|

3510​

|

3516​

|

3693​

|
Nominal Power Input (Watts) [specs]|

1310​

|

1310​

|

1215​

|

1240​

|

1140​

|

1120​

|

1128​

|
(ii) Nominal Power Input (Watts) [BEE] |

1310​

|

1310​

|

1215​

|

1240​

|

1140​

|

1120​

|

1128​

|
Moisture Removal (1Lt/Hr)|

---​

|

---​

|

---​

|

---​

|

---​

|

---​

|

---​

|
Air Flow Volume CFM [CMH]|

[550]​

|

[450]​

|

---​

|

330​

|

[810]​

|

375​

|

370​

|
Compressor Type|

ROTARY​

|

ROTARY​

|

ROTARY​

|

ROTARY​

|

ROTARY​

|

ROTARY​

|

ROTARY​

|
Calculated EER (BTU/Hr/Watts)|

9.16​

|

9.16​

|

9.63​

|

9.68​

|

10.53​

|

10.71​

|

11.79​

|
BEE's EER (Watts/Watts)|

2.68​

|

2.68​

|

2.82​

|

2.84​

|

3.1​

|

3.14​

|

3.27​

|
BEE Rating (Jan '07-Dec '07)|

2-Star​

|

2-Star​

|

3-Star​

|

3-Star​

|

5-Star​

|

5-Star​

|

5-Star​

|
BEE Rating (Jan '08-Dec '09) |

1-Star​

|

1-Star​

|

2-Star​

|

2-Star​

|

4-Star​

|

4-Star​

|

4-Star​

|
BEE Rating (Jan '10-Dec '12)|

---​

|

---​

|

1-Star​

|

1-Star​

|

3-Star​

|

3-Star​

|

3-Star​

|
Noise Level High/Medium/Low (dB)|

50​

|

40​

|

30​

|

38​

|

45​

|

38​

|

41/35/31​

|
Power Consumed (Hourly) kWh
(i)/[(i)/(ii)]/1000 |

1.31​

|

1.31​

|

1.215​

|

1.24​

|

1.14​

|

1.12​

|

1.128​

|
Power Consumed (Daily @6hrs) kWh|

7.86​

|

7.86​

|

7.29​

|

7.44​

|

6.84​

|

6.72​

|

6.768​

|
Power Consumed (Monthly)x30|

235.80​

|

235.80​

|

218.70​

|

223.20​

|

205.20​

|

201.60​

|

203.04​

|
Power Consumed (Yearly@6months)|

1414.80​

|

1414.80​

|

1312.20​

|

1339.20​

|

1231.20​

|

1209.60​

|

1218.24​

|
Power Consumed (5 Years) kWh|

7074​

|

7074​

|

6561​

|

6696​

|

6156​

|

6048​

|

6091.20​

|
Power Cost (PC) (5 yrs) @Rs.5/kWh|

Rs.35,370​

|

Rs.35,370​

|

Rs.32,805​

|

Rs.33,480​

|

Rs.30,780​

|

Rs.30,240​

|

Rs.30,456​

|
Power Cost Inflation (PCI) (5yrs) (+25%)|

Rs.8,843​

|

Rs.8,843​

|

Rs. 8,201​

|

Rs. 8,370​

|

Rs. 7,695​

|

Rs. 7,560​

|

Rs. 7,614​

|
AC Cost Price (CP)|

Rs.15,500​

|

Rs.22,000​

|

Rs.22,000​

|

Rs.24,500​

|

Rs.25,500​

|

Rs.25,500​

|

Rs.28,500​

|
5yr Total Cost = PC + PCI + CP |

Rs.59,713​

|

Rs.66,213​

|

Rs.63,006​

|

Rs.66,350​

|

Rs.63,975​

|

Rs.63,300​

|

Rs.66,570​

|
|
Power Consumption (Lifetime) kWH|

14148​

|

14148​

|

13122​

|

13392​

|

12312​

|

12096​

|

12182.40​

|
PowerCost (PC) (lifetime) @Rs.5/kWh|

Rs.70,740​

|

Rs.70,740​

|

Rs.65,610​

|

Rs.66,960​

|

Rs.61,560​

|

Rs.60,480​

|

Rs.60,912​

|
Power Cost Inflation (PCI) (lifetime)(+60%)|

Rs.42,444​

|

Rs.42,444​

|

Rs.39,366​

|

Rs.40,176​

|

Rs.36,936​

|

Rs.36,288​

|

Rs.36,547​

|
AC Cost Price (CP)|

Rs.15,500​

|

Rs.22,000​

|

Rs.22,000​

|

Rs.24,500​

|

Rs.25,500​

|

Rs.25,500​

|

Rs.28,500​

|
Lifetime Total Cost = PC + PCI + CP |

Rs.1,28,684​

|

Rs.1,35,184​

|

Rs.1,26,976​

|

Rs.1,31,636​

|

Rs.1,23,996​

|

Rs.1,22,268​

|

Rs.1,25,959​

|

1 TONNER Ranking After 5yrs use (Lower the Total cost, better the rank)

Rank (for 5yrs usage)​

|

AC TYPE​

|

Manufacturer​

|

Model#​

|

BEE Rating (Jan '08-Dec '09)​

|

5yr Total Cost​

|

AC Cost Price (CP)​

|

BEST​

|

WIN​

|

Voltas​

|

Plus 1T​

|

1-Star​

|

Rs. 59,713​

|

Rs. 15,500​

|

SECOND​

|

SPLIT​

|

Whirlpool​

|

WASR12K30 1T​

|

2-Star​

|

Rs. 63,006​

|

Rs. 22,000​

|

THIRD​

|

SPLIT​

|

LG​

|

LSA3Z(B5/S5/G5)NTY1 1T​

|

4-Star​

|

Rs. 63,300​

|

Rs. 25,500​

|

4th​

|

SPLIT​

|

Voltas​

|

Gold 1T​

|

4-Star​

|

Rs. 63,975​

|

Rs. 25,500​

|

5th​

|

SPLIT​

|

Voltas​

|

Plus 1T​

|

1-Star​

|

Rs. 66,213​

|

Rs. 22,000​

|

6th​

|

SPLIT​

|

LG​

|

LSA3FG3VTY1 1T​

|

2-Star​

|

Rs. 66,350​

|

Rs. 24,500​

|

LAST​

|

SPLIT​

|

Carrier​

|

Estrella 1T​

|

4-Star​

|

Rs. 66,570​

|

Rs. 28,500​

|

1 TONNER Ranking After 10yrs use (Lower the Total cost, better the rank)

Rank (for lifetime usage)​

|

AC TYPE​

|

Manufacturer​

|

Model#​

|

BEE Rating (Jan '08-Dec'09)​

|

Lifetime TC​

|

AC Cost Price (CP)​

|

BEST​

|

SPLIT​

|

LG​

|

LSA3Z(B5/S5/G5)NTY1 1T​

|

4-Star​

|

Rs. 1,22,268​

|

Rs. 25,500​

|

SECOND​

|

SPLIT​

|

Voltas​

|

Gold 1T​

|

4-Star​

|

Rs. 1,23,996​

|

Rs. 25,500​

|

THIRD​

|

SPLIT​

|

Carrier​

|

Estrella 1T​

|

4-Star​

|

Rs. 1,25,959​

|

Rs. 28,500​

|

4th​

|

SPLIT​

|

Whirlpool​

|

WASR12K30 1T​

|

2-Star​

|

Rs. 1,26,976​

|

Rs. 22,000​

|
|

5th​

|

WIN​

|

Voltas​

|

Plus 1T​

|

1-Star​

|

Rs. 1,28,684​

|

Rs. 15,500​

|

6th​

|

SPLIT​

|

LG​

|

LSA3FG3VTY1 1T​

|

2-Star​

|

Rs. 1,31,636​

|

Rs. 24,500​

|

LAST​

|

SPLIT​

|

Voltas​

|

Plus 1T​

|

1-Star​

|

Rs. 1,35,184​

|

Rs. 22,000​

|

EDIT : Added Power Cost inflation to the tables to acount for power unit (kWh) cost increasing by 50% after 5 yrs and by 120%(!) after 10yrs (at least in Bangalore over the last 10 years )

So in the above table consider the 1st choice ie LG LSA3Z over the last choice ie Voltas Plus 1T, even though the LG is Rs.3500 more than the voltas, you still save nearly Rs.9,500 over its liftime compared to the Voltas.

The Voltas windows model in 5th place is a better buy than the voltas split in last place with a savings of Rs.7000.

The Estrella is a better buy then the 4th place Whirlpool even tho its Rs.6500 more.

I divided the lifetime table into two groups Best-4th and 5th-LAST as there is < Rs.5000 diff between models within them.

Looking at the 5yr & 10 yr tables, does it makes sense to swap the models every 5 yrs with a trade-in (MRP - 2k-4k) ?
eg. holding on to the voltas win plus 1T for 10 yrs costs Rs.1,35,000 so would a tradein, after 5 yrs for a similar model (in price & EER) work out cheaper ?

Replacing (with same unit) after 5 yrs |||||||
Manufacturer|

Voltas​

|

Voltas​

|

Whirlpool​

|

LG​

|

Voltas​

|

LG​

|

Carrier​

|
AC Type|

WIN​

|

SPLIT​

|

SPLIT​

|

SPLIT​

|

SPLIT​

|

SPLIT​

|

SPLIT​

|
Model#|

Plus 1T​

|

Plus 1T​

|

WASR12K30 1T​

|

LSA3FG3V TY1 1T​

|

Gold 1T​

|

LSA3ZB/G/S5NTY1 1T​

|

Estrella 1T​

|
Power Consumed (5 Years) kWh|

7074​

|

7074​

|

6561​

|

6696​

|

6156​

|

6048​

|

6091.20​

|
Power Cost (PC) (after 5 yrs) @Rs.7.5/kWh |

Rs.53,055​

|

Rs.53,055​

|

Rs.49,208​

|

Rs.50,220​

|

Rs.46,170​

|

Rs.45,360​

|

Rs.45,684​

|
Power Cost Inflation (PCI) (5yrs) (+25%)|

Rs.13,264​

|

Rs.13,264​

|

Rs.12,302​

|

Rs.12,555​

|

Rs.11,543​

|

Rs.11,340​

|

Rs.11,421​

|
AC Cost Price (CP) |

Rs.15,500​

|

Rs.22,000​

|

Rs.22,000​

|

Rs.24,500​

|

Rs.25,500​

|

Rs.25,500​

|

Rs.28,500​

|
CP Drop by Rs.4000 after trade-in|

Rs.11,500​

|

Rs.18,000​

|

Rs.18,000​

|

Rs.20,500​

|

Rs.21,500​

|

Rs.21,500​

|

Rs.24,500​

|
5yr Total Cost = PC + PCI + CP (drop)|

Rs.77,819​

|

Rs.84,319​

|

Rs.79,509​

|

Rs.83,275​

|

Rs.79,213​

|

Rs.78,200​

|

Rs.81,605​

|
5yr TC + replacement TC after 5 yrs |

Rs.1,37,531​

|

Rs.1,50,531​

|

Rs.1,42,516​

|

Rs.1,49,625​

|

Rs.1,43,188​

|

Rs.1,41,500​

|

Rs.1,48,175​

|
Increase compared to lifetime TC |

+Rs.8,847​

|

+Rs.15,347​

|

+Rs.15,540​

|

+Rs.17,989​

|

+Rs.19,192​

|

+Rs.19,232​

|

+Rs.22,216​

|

Not really as the figures in red show, the excess one would pay as a result of replacing after 5 years compared to holding onto the unit for its lifetime.

 

[blr_p]

Re: Compare & Suggest Best VFM Split AC

Now lets see the 1.5 TONNERS

Manufacturer​

|

Whirlpool​

|

Voltas​

|

Whirlpool​

|

Onida​

|

Whirlpool​

|

Whirlpool​

|

LG​

|

Whirlpool​

|

Voltas​

|

LG​

|

Carrier​

|

Daikin​

|

AC Type​

|

WIN​

|

WIN​

|

WIN​

|

SPLIT​

|

WIN​

|

SPLIT​

|

SPLIT​

|

SPLIT​

|

SPLIT​

|

SPLIT​

|

SPLIT​

|

SPLIT​

|

Model#​

|

WAWR18G10 1.5 T​

|

Plus 1.5T​

|

WAWR18G20 1.5T​

|

SZ18GRL2 1.5T​

|

WAWR18G30 1.5T​

|

WASR18K30 1.5T​

|

LSA5F(G3/S3)VTY1 1.5T​

|

WASR18K40 1.5T​

|

Gold 1.5T​

|

LSA5Z(B4/G4/S4)NTY1 1.5T​

|

Estrella 1.5T​

|

FT-50 1.5T​

|
AC Cost Price (CP) (MRP - Rs.500 or other quote)|

Rs.17,000​

|

Rs.18,000​

|

Rs.18,700​

|

Rs.21,500​

|

Rs.21,500​

|

Rs.24,500​

|

Rs.29,500​

|

Rs.28,500​

|

Rs.29,500​

|

Rs.32,500​

|

Rs.32,500​

|

Rs.49,500​

|
Nominal Cooling Capacity (BTU/Hr) [specs]|

17709​

|

18000​

|

17982​

|

20600​

|

17709​

|

18187​

|

17999​

|

19193​

|

18000​

|

17999​

|

19300​

|

18000​

|
Nominal Cooling Capacity (Watts) [specs]|

5190​

|

5275​

|

5275​

|

6037​

|

5190​

|

5330​

|

5275​

|

5625​

|

5275​

|

5275​

|

5656​

|

5275​

|
(i) Nominal Cooling Capacity (Watts) [BEE] |

5190​

|

5270​

|

5270​

|

4872​

|

5190​

|

5330​

|

5275​

|

5625​

|

5270​

|

5275​

|

5375​

|

5100​

|
Nominal Power Input (Watts) [specs]|

2020​

|

1980​

|

1990​

|

1980​

|

1800​

|

1910​

|

1880​

|

1860​

|

1720​

|

1785​

|

1696​

|

2000​

|
(ii) Nominal Power Input (Watts) [BEE] |

2020​

|

1980​

|

1990​

|

1854​

|

1800​

|

1910​

|

1880​

|

1860​

|

1720​

|

1785​

|

1696​

|

1750​

|
Moisture Removal (1Lt/Hr)|

---​

|

---​

|

---​

|

1.8​

|

---​

|

---​

|

---​

|

---​

|

---​

|

---​

|

---​

|

[840 (high)]​

|
Air Flow Volume CFM [CMH]|

---​

|

[730]​

|

---​

|

480​

|

---​

|

---​

|

500​

|

---​

|

[1020]​

|

500​

|

620​

|
Compressor Type|

ROTARY​

|

ROTARY​

|

ROTARY​

|

ROTARY​

|

ROTARY​

|

ROTARY​

|

ROTARY​

|

ROTARY​

|

ROTARY​

|

ROTARY​

|

ROTARY​

|

ROTARY​

|
Calculated EER (BTU/Hr/Watts)|

8.77​

|

9.09​

|

9.04​

|

11.11(!)​

|

9.84​

|

9.52​

|

9.57​

|

10.32​

|

10.47​

|

10.08​

|

11.38​

|

10.29​

|
BEE's EER (Watts/Watts)|

2.42 (* see BEE)​

|

2.66​

|

2.63​

|

2.63​

|

2.84​

|

2.79​

|

2.8​

|

3.02​

|

3​

|

2.96​

|

3.17​

|

2.91​

|
BEE Star Rating (Jan '07-Dec '07)|

1-Star​

|

2-Star​

|

2-Star​

|

2-Star​

|

3-Star​

|

3-Star​

|

3-Star​

|

4-Star​

|

4-Star​

|

4-Star​

|

5-Star​

|

4-Star​

|
BEE Star Rating (Jan '08-Dec '09) |

---​

|

1-Star​

|

1-Star​

|

1-Star​

|

2-Star​

|

2-Star​

|

2-Star​

|

3-Star​

|

3-Star​

|

3-Star​

|

4-Star​

|

3-Star​

|
BEE Star Rating (Jan '10-Dec '12)|

---​

|

---​

|

---​

|

---​

|

1-Star​

|

1-Star​

|

1-Star​

|

2-Star​

|

2-Star​

|

2-Star​

|

3-Star​

|

2-Star​

|
Noise Level High/Medium/Low (dB)|

48​

|

53​

|

48​

|

45​

|

47​

|

39​

|

40​

|

39​

|

46​

|

38​

|

49/44/33​

|

35​

|
Power Consumed (Hourly) kWh
(i)/[(i)/(ii)]/1000 |

2.02​

|

1.98​

|

1.99​

|

1.854​

|

1.8​

|

1.91​

|

1.88​

|

1.86​

|

1.72​

|

1.785​

|

1.696​

|

1.75​

|
Power Consumed (Daily @6hrs) kWh|

12.12​

|

11.88​

|

11.94​

|

11.124​

|

10.8​

|

11.46​

|

11.28​

|

11.16​

|

10.32​

|

10.71​

|

10.176​

|

10.5​

|
Power Consumed (Monthly)x30|

363.60​

|

356.40​

|

358.20​

|

333.72​

|

324​

|

343.80​

|

338.40​

|

334.80​

|

309.60​

|

321.30​

|

305.28​

|

315​

|
Power Consumed (Yearly@6months)|

2,181.60​

|

2,138.40​

|

2,149.20​

|

2,002.32​

|

1,944​

|

2,062.80​

|

2,030.40​

|

2,008.80​

|

1,857.60​

|

1,927.80​

|

1,831.68​

|

1,890​

|
|
Power Consumed (5 Years) kWh|

10,908​

|

10,692​

|

10,746​

|

10,011.60​

|

9,720​

|

10,314​

|

10,152​

|

10,044​

|

9,288​

|

9,639​

|

9,158.40​

|

9,450​

|
Power Cost (PC) (after 5 yrs) @Rs.5/kWh|

Rs.54,540​

|

Rs.53,460​

|

Rs.53,730​

|

Rs.50,058​

|

Rs.48,600​

|

Rs.51,570​

|

Rs.50,760​

|

Rs.50,220​

|

Rs.46,440​

|

Rs.48,195​

|

Rs.45,792​

|

Rs.47,250​

|
AC Cost Price (CP)|

Rs.17,000​

|

Rs.18,000​

|

Rs.18,700​

|

Rs.21,500​

|

Rs.21,500​

|

Rs.24,500​

|

Rs.29,500​

|

Rs.28,500​

|

Rs.29,500​

|

Rs.32,500​

|

Rs.32,500​

|

Rs.49,500​

|
Net 5yr Total Cost = PC + CP |

Rs.71,540​

|

Rs.71,460​

|

Rs.72,430​

|

Rs.71,558​

|

Rs.70,100​

|

Rs.76,070​

|

Rs.80,260​

|

Rs.78,720​

|

Rs.75,940​

|

Rs.80,695​

|

Rs.78,292​

|

Rs.96,750​

|
|
Power Consumed (Lifetime@10 yrs) kWh|

21,816​

|

21,384​

|

21,492​

|

20,023.20​

|

19,440​

|

20,628​

|

20,304​

|

20,088​

|

18,576​

|

19,278​

|

18,316.80​

|

18,900​

|
PowerCost (PC) (lifetime) @Rs.5/kWh|

Rs.1,09,080​

|

Rs.1,06,920​

|

Rs.1,07,460​

|

Rs.1,00,116​

|

Rs.97,200​

|

Rs.1,03,140​

|

Rs.1,01,520​

|

Rs.1,00,440​

|

Rs.92,880​

|

Rs.96,390​

|

Rs.91,584​

|

Rs.94,500​

|
AC Cost Price (CP)|

Rs.17,000​

|

Rs.18,000​

|

Rs.18,700​

|

Rs.21,500​

|

Rs.21,500​

|

Rs.24,500​

|

Rs.29,500​

|

Rs.28,500​

|

Rs.29,500​

|

Rs.32,500​

|

Rs.32,500​

|

Rs.49,500​

|
Net Lifetime Total Cost = PC + CP |

Rs.1,26,080​

|

Rs.1,24,920​

|

Rs.1,26,160​

|

Rs.1,21,616​

|

Rs.1,18,700​

|

Rs.1,27,640​

|

Rs.1,31,020​

|

Rs.1,28,940​

|

Rs.1,22,380​

|

Rs.1,28,890​

|

Rs.1,24,084​

|

Rs.1,44,000​

|

1.5 TONNER Ranking After 5yrs use (Lower the Total cost, better the rank)

Rank (for 5yrs usage)​

|

AC TYPE​

|

Manufacturer​

|

Model#​

|

BEE Rating (Jan '08-Dec '09)​

|

Net 5yr TC​

|

AC Cost Price (CP)​

|

BEST​

|

WIN​

|

Whirlpool​

|

WAWR18G30 1.5T​

|

2-Star​

|

Rs.70,100​

|

Rs.21,500​

|

SECOND​

|

WIN​

|

Voltas​

|

Plus 1.5T​

|

1-Star​

|

Rs.71,460​

|

Rs.18,000​

|

THIRD​

|

WIN​

|

Whirlpool​

|

WAWR18G10 1.5 T​

|

---​

|

Rs.71,540​

|

Rs.17,000​

|

4th​

|

SPLIT​

|

Onida​

|

SZ18GRL2 1.5T​

|

1-Star​

|

Rs.71,558​

|

Rs.21,500​

|

5th​

|

WIN​

|

Whirlpool​

|

WAWR18G20 1.5T​

|

1-Star​

|

Rs.72,430​

|

Rs.18,700​

|

6th​

|

SPLIT​

|

Voltas​

|

Gold 1.5T​

|

3-Star​

|

Rs.75,940​

|

Rs.29,500​

|
|

7th​

|

SPLIT​

|

Whirlpool​

|

WASR18K30 1.5T​

|

2-Star​

|

Rs.76,070​

|

Rs.24,500​

|

8th​

|

SPLIT​

|

Carrier​

|

Estrella 1.5T​

|

4-Star​

|

Rs.78,292​

|

Rs.32,500​

|

9th​

|

SPLIT​

|

Whirlpool​

|

WASR18K40 1.5T​

|

3-Star​

|

Rs.78,720​

|

Rs.28,500​

|

10th​

|

SPLIT​

|

LG​

|

LSA5F(G3/S3)VTY1 1.5T​

|

2-Star​

|

Rs.80,260​

|

Rs.29,500​

|

11th​

|

SPLIT​

|

LG​

|

LSA5Z(B4/G4/S4)NTY1 1.5T​

|

3-Star​

|

Rs.80,695​

|

Rs.32,500​

|
|

LAST​

|

SPLIT​

|

Daikin​

|

FT-50​

|

3-Star​

|

Rs.96,750​

|

Rs.49,500​

|

1.5 TONNER Ranking After 10yrs use (Lower the Total cost, better the rank)

Rank (for lifetime usage)​

|

AC TYPE​

|

Manufacturer​

|

Model#​

|

BEE Rating (Jan '08-Dec '09)​

|

Lifetime TC​

|

AC Cost Price (CP)​

|

BEST​

|

WIN​

|

Whirlpool​

|

WAWR18G30 1.5T​

|

2-Star​

|

Rs. 1,18,700​

|

Rs. 21,500​

|

SECOND​

|

SPLIT​

|

Onida​

|

SZ18GRL2 1.5T​

|

1-Star​

|

Rs. 1,21,616​

|

Rs. 21,500​

|

THIRD​

|

SPLIT​

|

Voltas​

|

Gold 1.5T​

|

3-Star​

|

Rs. 1,22,380​

|

Rs. 29,500​

|

4th​

|

SPLIT​

|

Carrier​

|

Estrella 1.5T​

|

4-Star​

|

Rs. 1,24,084​

|

Rs. 32,500​

|

5th​

|

WIN​

|

Voltas​

|

Plus 1.5T​

|

1-Star​

|

Rs. 1,24,920​

|

Rs. 18,000​

|
|

6th​

|

WIN​

|

Whirlpool​

|

WAWR18G10 1.5 T​

|

---​

|

Rs. 1,26,080​

|

Rs. 17,000​

|

7th​

|

WIN​

|

Whirlpool​

|

WAWR18G20 1.5T​

|

1-Star​

|

Rs. 1,26,160​

|

Rs. 18,700​

|

8th​

|

SPLIT​

|

Whirlpool​

|

WASR18K30 1.5T​

|

2-Star​

|

Rs. 1,27,640​

|

Rs. 24,500​

|

9th​

|

SPLIT​

|

LG​

|

LSA5Z(B4/G4/S4)NTY1 1.5T​

|

3-Star​

|

Rs. 1,28,890​

|

Rs. 32,500​

|

10th​

|

SPLIT​

|

Whirlpool​

|

WASR18K40 1.5T​

|

3-Star​

|

Rs. 1,28,940​

|

Rs. 28,500​

|

11th​

|

SPLIT​

|

LG​

|

LSA5F(G3/S3)VTY1 1.5T​

|

2-Star​

|

Rs. 1,31,020​

|

Rs. 29,500​

|
|

LAST​

|

SPLIT​

|

Daikin​

|

FT-50​

|

3-Star​

|

Rs. 1,44,000​

|

Rs. 49,500​

|

This Daikin model is for ppl with more money than sense!

Little more separation here between 1st,2nd & 11th. What's surprising is comparing the CP's, shows not only is it cheaper to buy them but it also works out cheaper to the tune of nearly 10k over their lifetimes!

Windows models are competitive compared to the splits but remember they are 50+dB's of noise (ie as loud as a normal conversation)!!

As luck would have it today i came across an ad in my local paper. LG's claims to energy savings are beyond my comprehension given that every model in there does *not* have any inverter tech. And to claim the savings LG did one wonders what they used to compare their models with. Speaking of inverters check this out, wonder how much for ?

One thing to keep in mind is that most of the BEE labels you see on models are out of date if you look at them carefully it says 2007, in 2008 the star ratings drop one star and again do so in 2010 for the same EER.

 

[Vandal]

Re: Compare & Suggest Best VFM Split AC

Very good...helpful. Repped!

 

[superczar]

one issue with the calculation though is that the power consumption figure happening over a period of 5 years is added in bulk to the cost price which is happening today...

Ideally, the Power consumption numbers should be converted to their present values ...To add to it, you have also added inflation values to tge Powe consumption numbers that will skew the numbers even more

If you adjust the power consumption costs to the Present value (at even a anominal rate of say 8%), the tables may change completely

In other words, A spending of 15K to start with and a spending of 15K in the 5th year on electricity bill cannot be added directly as 15K 5 years from now isn't exactly going to be worth what 15K is today

 

[blr_p]

They used an earlier version of the 1ton table which i've since updated to account for the 5yr replacement costs.

It does *not* make sense to replace every 5 yrs...as the table shows for either 1 or 1.5 tonners.

Hope that's what you were getting at

 

[colo]

Samsung and General do not figure in the list. Wonder why?

 

[blr_p]

General does not have any models in the BEE list,
Hmm, seems they have updated their list since i did the tables, notice more Onida's & Videocon in there as well!

Will update later when i have time.

Samsung for some reason does not seem very popular on this board, tho it does have some interesting models ie splits on offer.

 

[HailStonE]

General/Hitachi/Daikin.... I guess you also pay more for better quality & Less noise...

Also we should take a note of cost of servicing.... Some more than others....

 

[blr_p]

Until i see better stuff than what Daikin have in BEE i'll continue not to be impressed
Where are the 5-star models is what i want to know.

About servicing.. windows models have one type of servicing & splits another,

Costs within a type should be similar then right ?

So they would cancel out when comparing between models of the same type.

From my reading around i think its more important that they get serviced right as efficiency will depend a lot on it.

 

[m4w]

superczar meant this Present value - Wikipedia, the free encyclopedia.

 

[Gannu]

Excellent work man.. :O

Cant rep since I've to spread some.. :ashamed:

 

[m4w]

superczar meant this Present value - Wikipedia, the free encyclopedia.

So if you take 100 rupees 1 year from now at 5% inflation rate, it's worth 95 today. There's an Excel function that you can use, PV. Info: Simplifying-the-PV-NPV-and-FV-Functions-of-Excel-2003.

 

[blr_p]

Ahh, little clearer now and thx for the links

So..if i get this right, you prefer to see present values,

Is that as simple as taking the 5 (& 10) yr power cost and applying the formula ?

eg for the 1 tonner, voltas win plus 1T (first item in the 1 tonner table)

Power Cost (PC) (5 yrs) @Rs.5/kWh |

Rs.35,370​

|
PV cost (PvPC) = 35,370/(1 + 0.08)^5 |

Rs.24,072​

|
|
Power Cost Inflation (PCI) (5yrs) (+25%PC) |

Rs.8,843​

|
PV cost (PvPCI) = 8,843/(1 + 0.08)^5 |

Rs.6,018​

|
|
AC Cost Price (CP) |

Rs.15,500​

|
5yr Total Cost = PvPC + PvPCI + CP |

Rs.45,590​

|
|
Power Cost (PC) (10 yrs) @Rs.5/kWh |

Rs.70,740​

|
PV cost (PvPC) = 70,740/(1 + 0.08)^10 |

Rs.32,766​

|
|
Power Cost Inflation (PCI) (lifetime)(+60%PC) |

Rs.42,444​

|
PV cost (PvPCI) = 42,444/(1 + 0.08)^10 |

Rs.19,660​

|
|
AC Cost Price (CP) |

Rs.15,500​

|
Lifetime Total Cost = PvPC + PvPCI + CP |

Rs.67,926​

|

S0 the 5yr TC Pv value is Rs.45,590 instead of Rs.59,713 previously

and lifetime Pv TC is Rs.67,926 instead of Rs.1,28,684 previously.

I have taken 8% inflation(?) here and compounded anually for 5 yrs & 10 yrs respectively..and therfore only need to add a cpl of lines for PVPCI & PvPC in the tables.

Did i do this right ?

Another way using the excel formula =PV(rate,nper,pmt,[fv],[type])

Monthly payment is Rs.1,179 for 6 months/yr over 5 years at inflation of 8%.

Power Consumed (Monthly) kWh|

235.80​

|
Monthly Cost(MC) @Rs.5/kWh|

Rs.1,179​

|
Present value (PvMC)(5yrs)=PV(8%/12,5x6,MC)|

Rs.31,961​

|
|
Power Cost Inflation (PCI) (5yrs) (+25%PvMC) |

Rs.7,990​

|
|
AC Cost Price (CP) |Rs.15,500|
5yr Total Cost = PvMC + PCI + CP |

Rs.55,451​

|

and presumably the same for 10 yrs.

The 5yr TC using this method is now Rs.55,451 compared to the previous method that gave Rs.45,590.

If i still got it wrong, pls give the *correct* formula and where to use it

 

[m4w]

Pls put up the XLS as an attachment. You're on the right track but there are minor tweaks required.

eg. 2nd calculation you've messed up on the number of periods PV(8%/12,5x6,MC) should be PV(8/12, 5x12, MC) or just PV(8, 5, 12xMC). Also, need to look at the PCI factor's calculation. You've added 25% of the PV, which doesn't seem right. What was your assumption regarding PCI? 25% increase by year 5? or 25% increase annually?

ps. prices updated on CI.

 

[blr_p]

Pls put up the XLS as an attachment. You're on the right track but there are minor tweaks required.

Did not make any changes to the spreadsheet until i get this nailed down. All the calcs in my previous post are as is and were done manually.

eg. 2nd calculation you've messed up on the number of periods PV(8%/12,5x6,MC) should be PV(8/12, 5x12, MC) or just PV(8, 5, 12xMC).

I used 6 to indicate 6 months @8 hrs/day to be the avg annual consumption. Now its quite likely you might only need to use an AC for 3 months of the yr but i bet you would be running it more than 6 hrs/day in that case

So i chose 6 for periods instead of 12. As you would not be making payments for the remainder of the yr.

Is it still wrong ?

Also, need to look at the PCI factor's calculation. You've added 25% of the PV, which doesn't seem right. What was your assumption regarding PCI? 25% increase by year 5? or 25% increase annually?

Looking at past bills going back 10 yrs i noticed a jump of 50% on the avg. unit price within 5 yrs and a doubling in 8 going up to 120% by the 10 th yr.

Why did i pick 25% for PCI for 5 yrs ?

Just imagined it graphically

Think of a rectangle with a diagonal which then gives you two inner triangles. The triangles are identical and each occupies only half the area of the rectangle.

Therefore if price increases by 50% in 5 yrs then only take half of it to calculate the total increase over that period. Now that's an approximation and could possibly be bit more as the increases were discrete jumps. Stayed at one price for a few yrs, then suddenly jumped and cpl times again till the 10th yr. The triangle in the rectangle seemed like a good approximation to this.

ps. prices updated on CI.

It's been suggested i use the CI prices but CI only offers those prices in Delhi, Bumbay and recently Bangalore.

What if you don't live in those cities ?

The CI prices in some cases offer sizable reductions over the MRP, so are CI's prices close enough nationally ?

It would appear they are working like a co-operative not too different to the way GO's work here and the price is maybe cheaper than you could get from outside their network.

I felt anyone could haggle Rs.500 off the MRP, course if you get more off then kudos.

 

[Mohit]

Awesome job. Now can somebody advice on which 1.5 ton split a.c should I buy? I am thinking of the Onida SZ18GRL2 1.5T. What do you guys suggest?

 

[m4w]

I re-examined both your methods and I think you're fine using method 2 (the one that gives you a higher PV because of your treatment of power price increase). And yeah, since you're calculating monthly expenditure, the 6x5 periods is fine. BTW found this US AC TCO calculator here.

AFAIK CI prices are close to street prices (market operating prices) and are a better indicator of consumer pricing. If only there was a way to automate culling of prices from CI (free radical....you listening out there? .

 

[blr_p]

I re-examined both your methods and I think you're fine using method 2 (the one that gives you a higher PV because of your treatment of power price increase). And yeah, since you're calculating monthly expenditure, the 6x5 periods is fine. BTW found this US AC TCO calculator here.

Did some digging and found another (more recent) here by the same author.

Was looking at the formula used for calculating Lifetime costs, and the one used above is

=PV(Discount Rate@4%,9-yrs-lifetime,Annual Cost,,0)

For discount rate the following assumption is stated

A real discount rate of 4 percent is assumed, which is roughly equivalent to the nominal discount rate of 7 percent (4 percent real discount rate + 3 per cent inflation rate)

So is the 8% used earlier correct for India ?

Throwing the same values at both the spreadsheets reveals the same figure for lifetime costs so we have a winning formula here
Am still using 10-yrs for lifetime instead of 9

Admittedly its easier to take the annual cost (instead of months) and just use the yrs, 5 or 10 as periods (nper parameter in the excel formula) to work out with the discounted TC for those periods.

Looking at the spreadsheets, they have a mapping table correlating cooling hours with city & state, wonder if anything similar exists for India ?

So using the previous example

Power Consumed (Yearly@6months) kWh|

1414.80​

|
Annual Cost(AC) @Rs.5/kWh|

Rs.7,074​

|
Present value (PvAC)(5yrs)=PV(8%,5,7074)|

Rs.28,244​

|
|
Power Cost Inflation (PCI) (5yrs) (+25%PvAC) |

Rs.7,061​

|
|
AC Cost Price (CP) |Rs.15,500|
5yr Total Cost = PvAC + PCI + CP |

Rs.50,805​

|

Strange thing here is the difference in PV between the two formula.

Why does using =PV(8%/12,5x6,MC) give Rs.31,961

whereas =PV(8%,5,AC) gives Rs.28,244

One is saying use monthly payments 30 times vs annual payment 5 times :S

AFAIK CI prices are close to street prices (market operating prices) and are a better indicator of consumer pricing. If only there was a way to automate culling of prices from CI (free radical....you listening out there? .

Anyone else *not* from Delhi, Mumbai or Bangalore agree with this ?

 

[m4w]

Hmmm I think 8% is a tad bit high but who's to argue with recent economic trends. I say stick with it!

About the CI vs MRP argument, I'm sure no one ever pays MRP on ACs (or most durables) ever. MRP = indicative price. The MOP depends on a number of factors including channel promotions, channel rebates, landing price etc.

BTW guys checking out this thread, please vote and rep. Give blr_p the extra motivation to finish v2 of his TCO comparitive analysis.

 

[blr_p]

pls see the table above..did an edit while u posted :ashamed: