$(4$ points$)$ Evaluate these three technologies used to obtain energy and atmosphere credits towards LEED certification by calculating total NPV and gross NPV at $R=7\%$ and complete the table for gross and net NPV values. If you could only recommend one to your client, which would you recommend and why? Suggestion: Set this up in an Excel spreadsheet to make your calculations a little easier to keep track of$.$ If you do that, please include that spreadsheet with your assignment.

$\backslash$table$[[\backslash$table$[[$Building$],[$Technology$]],\backslash$table$[[$Incremental$],[$Cost$]],\backslash$table$[[$Annual$],[$Total$],[$Savings$]],\frac{SPP}{(Yrs)},\backslash$table$[[$Investment$],[$Life $($Yrs$).]],\frac{\text{G}\text{r}\text{o}\text{s}\text{s}}{NPV},$Net NPV$],[\backslash$table$[[$Install high$],[$efficiency packaged$],[$rooftop units$],[($RTUs$)]],$$$50,000,$$$10,000,5,12,,],[\backslash$table$[[$Comprehensive$],[$lighting and plug$],[$load efficiency$],[$strategy$]],$$$50,000,$$$5,000,10,10,,],[\backslash$table$[[$Enhanced$],[$insulation and$],[$glazing package for$],[$building envelope$]],$$$50,000,$$$10,000,5,15,,]]$

$(1$ point$)$ Based on what you know about the time value of money, which of the following investments would you prefer, based purely on the value of the return in present day dollars? Assume the same discount rate in each scenario $($but the actual discount rate is irrelevant$).$ Don't calculate these, just answer based on your knowledge of what happens to the value of money over time.

a$.$ Invest $$1,000$ and make $$120$ at the end of year $3$

b$.$ Invest $$1,000$ and make $$40$ at the end of year $1,$$$40$ at the end of year $2,$ and $$40$ at the end year $3$

c$.$ Invest $$1,000$ and make $$60$ at the end of year $1$ and $$60$ at the end of year $2$