Instructions . 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 $, 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 utility tariff for residential, Step 11 Assume a real electricity price escalation of 2 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 formule to make the calculations capacity factor levezed cost. NPVIRA, payback and benefit costat Provide hyperlinks to utility cost dat . Instructions . 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 $, 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 utility tariff for residential, Step 11 Assume a real electricity price escalation of 2 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 formule to make the calculations capacity factor levezed cost. NPVIRA, payback and benefit costat Provide hyperlinks to utility cost dat