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 (S/MWh) in real 2018 55, 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 (real 20185) 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 utslity tariff for residential Step 1) Assume a real electricity price escalation of 2% 2. Prepare the assignment should by these specifications: In a spreadsheer that can be submitted to the instructor Have two worksheets with the wind power and high efficiency house - Use formule to make the calculations capacity factor levelted cost. NPV IRR, paytrack and benefit costat Provide hyperlinks to utility cont data 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 (S/MWh) in real 2018 55, 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 (real 20185) 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 utslity tariff for residential Step 1) Assume a real electricity price escalation of 2% 2. Prepare the assignment should by these specifications: In a spreadsheer that can be submitted to the instructor Have two worksheets with the wind power and high efficiency house - Use formule to make the calculations capacity factor levelted cost. NPV IRR, paytrack and benefit costat Provide hyperlinks to utility cont data