Thread: Cost to performance comparison chart for airconditioners

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.

Very good...helpful. Repped!

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

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

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

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.

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....

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.

Excellent work man..

Cant rep since I've to spread some..

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.

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

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.

Originally Posted by m4w

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.

Originally Posted by m4w

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 ?

Originally Posted by m4w

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.

Originally Posted by m4w

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.

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?