Page 1 on 6

ROI calculation of a CFL or LED

published: 10/02/08, 19:04
by Christophe
After how many hours you win money by buying a CFL?

This is what will try to answer this small file excel or openoffice:

Image

Download here: https://www.econologie.com/telechargeme ... uo-ou-led/

(This file follows it: sustainable-consumption / fluorescent-bulbs-a-financial-benefit-of-466-in-21-months-t4742.html )

Edit 12 / 15 Here is a simplified version of Flash for those who do not have Office: https://www.econologie.com/shop/infos/c ... gie-co2-11

published: 10/02/08, 19:57
by Christophe
That file is available here: calculation of return on investment of an energy saving bulb (fluorescent or LED)

It would be nice to quickly compare our results ... Image :)

Any suggestion to amend or improvement is welcome :)

published: 10/02/08, 21:21
by nightrow
Good work :D

I made an attempt to amend emailed, which takes into account the lifetime of compact fluorescent bulbs to see the impact of his life on profitability.

here is my (small) contribution :D

published: 11/02/08, 09:25
by Christophe
Yes I have received your file.

I'll take this parameter into account. I would also take into account the number of hours of use per day and do an ROI on year.

I will also delete the version of OpenOffice puisqu'OpenOffice reads .xls (the reverse is false by cons).

published: 11/02/08, 11:36
by Christophe
That the file was updated, it now automatically calculates the gain that the bulb allows you to carry on its life.

I remind you the link: calculation of return on investment of an energy saving bulb (fluorescent or LED)

published: 11/02/08, 11:43
by gegyx
It's funny the possible interpretation of a comparative curve.

I note that the incandescent bulb is more profitable to 3000 hours.

I can conclude that the incandescent bulb is best to € ...
Provided replace all 3000 hours ... : Lol:

published: 11/02/08, 13:08
by Christophe
: Shock: Gegyx what you talking about? Already in 3000h you change in 3 bulbs then ...

You're completely wrong to think so because one could say this also (and after the original data file)

a) hourly cost of an economic bulb cents: + 0,108 1750 / 15 000 = 0,224 cents / h

b) hourly cost of a conventional bulb in cents: + 0,48 235 / 1000 = 0,715 cents / h

Using a conventional light bulb is therefore in our case: 3.2 times more expensive than CFL.

The longer the life of the energy-saving bulb, the better its "profitability" is therefore watch out for 100% Chinese bulbs which arrive on the market with 3000h of life ... !!

Even if they are "at a good price", it is not certain that they will be profitable one day !! I'm not even talking about the environmental cost of this type of bulb ... : Evil:

I invite you to have fun with this table to compare our results (in image if possible).

published: 11/02/08, 14:06
by Christophe
Following the remark I Gegyx I updated the file to account hourly costs.

published: 11/02/08, 14:44
by Christophe

published: 11/02/08, 14:47
by Christophe
Like a calculation of equity CO2 ca interested in the world or not?