in Excel) is a life cycle analysis of energy efficient windows in a residential house. The annual energy cost for the benchmark house as defined by the Building America House Simulation Protocols is $1,316 for electricity and $480 for gas. Energy efficient windows are available for an additional $1,600. The energy cost using the same benchmark house with the new windows is $1,117 for electricity and $476 for the gas. Assume a 30 year time frame and 3% interest rate to calculate the NPW, EUAW, Return on Investment and Payback Period using Excel. Your table should look quite similar to this. The shaded cells are formula that you will need to insert.

NAME:	Your Name
GIVENS:
Benchmark	Elec	$1,316
	Gas	$480
New	Elec	$1,117
	Gas	476
Additional Window Cost		$1,600
Interest		3	percent
Time frame		30	years
ANALYSIS	Utility	Annual Savings	NPW	EUAW	ROR	Payback Period
New Windows	Elec
	Gas
	Sum		*
Sheet 1