Question: Special Assignment 2 (Sheet 1-see bottom left corner in Excel) is a life cycle analysis of energy efficient windows in a residential house. The annual

Special Assignment 2 (Sheet 1-see bottom left corner 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
