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,

Please show all work within excel using formulas for excel and explain. Thank you! Please show all work within excel using formulas for excel and explain.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!