$1.$ Overall, determine and fill$-$in the values for each of the shaded cells in light blue. $2.$ First, determine the total net lighting investment $($item A$)$ or net capital expenditures for this project by completing cells B$11,$ B$13,$ B$14,$ B$17$ and B$18.$Note that the rebates help reduce the total lighting investment. $3.$ Second, determine the energy avoided in electrical use between the old system and the new system by completing cells G$12,$ G$13,$ G$14,$ and G$17($old system$)$ and cells H$12,$ H$13,$ H$14$ and H$17($old system$).$This will calculate the annual avoided cost in total kilowatts $/$year $($item C$).4.$ Third, determine the savings from energy avoidance in kilowatts per hour by completing cell M$11($item B$)$ and inserting the annual cost avoidance in kilowatts$/$ year $($item C$)$ into cell M$17.5.$ Then use the Excel spreadsheet to a$)$ calculate the NPV at $10\%$ and b$)$ the IRR at $5$ year, $7$ year, $10$ year and $20$ year intervals.