present it in 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

Annual Operating cost= $1,000,000/yr

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

In a spreadsheet

Have two worksheets with the wind power and high efficiency house.

Use formulae to make the calculations (capacity factor, levelized cost, NPV, IRR, payback and benefit-cost ratio).

Provide hyperlinks to utility cost data.

videos that can help : - https://www.youtube.com/watch?v=lWY3abc4hz0

https://www.youtube.com/watch?v=8mAR-Tpz_H0

https://www.youtube.com/watch?v=lWY3abc4hz0