use excel please

SPREADSHEET ASSIGNMENT (1) . Prepare 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 (S/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 speed : 35% Capital cost: $2 million per MW 20 vear life 5% discount rate - SPREADSHEET ASSIGNMENT (2) 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 $5,000 DSM utility rebate of $2,000 Annual electricity savings: 2,000 kWh Consistent savings over 30 years Average variable electricity rate $0.935/kWh Assume a real electricity price escalation of 2% -5% discount rate SPREADSHEET ASSIGNMENT (3) 2. Prepare the assignment should by these specifications: In a spreadsheet that can be submitted to the instructor .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