$\backslash$table$[[$Cash Flow in years of Occurrence$],[$Year $(n),$Install Cost,$\backslash$table$[[$Energy Savings$],[$Escalation Rate$],[2\%$ per Year$]],\backslash$table$[[$Repair and$],[$Maintenance Rate$],[$Escalation Rate$],[3\%$ per Year$]],\backslash$table$[[$Total Annual$],[$Cash Flow$]],\backslash$table$[[$Present Value$],[$Total Annual$],[$Discount Rate$],[5\%$ per Year$]],],[0,45,000,,,45,000,45,000,],[1,,8,300,850,,,],[2,,,,,,],[3,,,,,,],[4,,,,,,],[5,,,,,,],[6,,,,,,],[7,,,,,,],[8,,,,,,],[9,,,,,,],[10,,,,,,]]$

Net Present Value of Life$-$Cycle Cash Flows $($$$)$

ROI

Year $0$ represents the purchase and equipment start$-$up date

TotalAnnual Cash Flow $-$ this is the cash amount and is aways

in the year in which it occururs $($in dollars$)$

Present Value $=$ Future Val