Required:

Prepare an Excel spreadsheet to compute the payback period, net present value $($NPV$),$ and IRR based on the cost savings from using the Alternate Design and the LED Design system over the Typical Deslen system.

Based on your results in question number $1,$ which lichting design system would you recommend to the GoGreen Supercenter? Be sure to include both the quantitative and the qualitative factors you would consider in evaluating the three deslens.

Repeat the analyals using $3\%$ cost of capltel and $10\%$ cont of cepital. Does the chenge in cost of capital change your dechions? Discuss.

The clectrical engineer to GoGreen Supercenter sugested considering a sole$-$powered lighthg system. Solar$-$powered systems have hicher instailation costs than any other llghting system but no ener $3.$ cost is assocdated with it$.$

Research and develop a prellminary cost estimate of a solar$-$powered lichting system Use this cost estimate to find the payback period, NPV$,$ and IRR of the solar$-$powered lyhting syitem and compare your results with the other two alternative lighting systems. Discuss the factors GoGreen Supercenter should consider in evaluating the solar$-$powered ilshting system as an alternathe.