Question: Please show all work within excel using formulas for excel and explain. Thank you! Light-emitting diode (LED) light bulbs have become required in recent years,
Light-emitting diode (LED) light bulbs have become required in recent years, but do they make financial sense? Suppose a typical 60-watt incandescent bulb costs $.45 and lasts for 1.000 hours. A 7-watt LED, which provides the same light, costs $225 and lasts for 40,000 hours. A kilowatt-hour of electricity costs S.121, which is about the national average. A kilowatt-hour is 1,000 watts for 1 hour. If you require a 10 percent retum and use a light fixture 500 hours per year, what is the equivalent annual cost of each lightbulb? (A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answers to 2 decimal places, e.g. 32.16.) points eBook Equivalent annual cost Print 60-watt light bulb LED light bulb References
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
