A spreadsheet in which you analyze the cost$-$benefit of several energy improvement options. Once you analyze each option, you will then analyze which set of options makes the most sense to recommend to meet your goal of reducing CO$2$ whereve it is economical. Your overall set of proposed measures should meet a minimum simple paybackLinks to an external site. of $7$ years to be considered $($It is okay if an individual measure doesn't meet that payback $-$ just the overall proposal must$).$

The spreadsheet will include full analysis of each proposed measure $($using the template provided$).$ The summary page should reflect the proposed energy measure$($s$)$ you choose to recommend. The spreadsheet should show a simple cash flow for each measure that accounts for expenses and income $($or savings$)$ from each measure. You should also include total savings of electricity $($kWh$),$ revenue $($$$)$ and carbon $($metric tons$)$ and simple payback for each measure. In addition, you should show those figures for your overall recommended set of savings measures that you propose for implementation.

A sample spreadsheet template $($without formulas$)$ is available here: SP$24$ Building Energy Options Template.xlsx Download SP$24$ Building Energy Options Template.xlsx$.$ Please note that the template is your starting point, but you will need to add information and formulas to it$.$

Assume initial capital costs occur in Year $0,$ and all operation of the project $($including savings$)$ occur annually starting in Year $1$ for the project life. If there are replacement capital costs, add those into the year in which they occur.

For project cashflow, you should include both the annual savings you have from lower electricity bills as well as the associated annual carbon "savings" based on that $$50/$ton$.$ That means that for each improvement, you need to calculate both the potential energy savings $($based on kWh$)$ and the annual carbon savings $($based on tons of CO$2)$ for each project year. These may change by year, so fill out each year's cashflow carefully.