(please help me learn and know about the formulas you write in the excel file to solve this problem)

Use an Excel spreadsheet with the following calculations in a format you feel is appropriate:

Wind Turbine: 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

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

5% discount rate

High-Efficiency House: NPV, IRR, payback period (years) and benefit-cost ratio of a high efficiency house:

Incremental capital cost of a high efficiency house $10,000

DSM utility rebate of $2,000

Annual electricity savings: 2,000 kWh

Consistent savings over 30 years

Average electricity rate for your home city (see utility tariff for residential, Step 1)

Assume a real electricity price escalation of 2%

5% discount rate