1. Prepare an Excel spreadsheet with the following calculations in a format you feel is appropriate: The annual generation (MWh/year) and the Levelized cost of wind power supply ($/MWh) in real 2018 $$, based on the following inputs: 100-megawatt wind farm o Capacity factor (average annual generation of electricity as a percentage of maximum rated generated at ideal wind speeds): 35% Capital cost: $2 million per MW 20-year life o 5% discount rate (real 2018$) NPV, IRR, payback period (years) and benefit-cost ratio of a high-efficiency house: o Incremental capital cost of a high-efficiency house $10,000 o DSM utility rebate of $2,000 o Annual electricity savings: 2,000 kWh o Consistent savings over 30 years o Average electricity rate for your home city (see utility tariff for residential, Step 1) o Assume a real electricity price escalation of 2%