build an onshore wind farm over 20 years

Please prepare the following: 1. Financial Model (see the excel file) 2. PowerPoint presentation; please include: One page presentation on the sensitivities of key drivers (e.g., 10% increase in capex will lead to a 3% decrease in IRR) 3. Please list the top 5 key drivers by impact The client is hoping to build an onshore wind farm in BC. The client has sent over their assumptions and has requested you to build out a financial model to help them make an investment decision. The details of the model can be found in the excel file attached. The client is hoping to achieve a specific level of return, and needs help setting the price of their output. Additionally, they are also interested in the sensitivities of the model, i.e., they want to know how a change to any assumption within the model will affect their decisions. The client wants to know the top 5 key drivers behind the model by impact. Please prepare the financial model and a PowerPoint presentation to share your analysis with the client. Additional Details Capacity is expressed in Megawatts (MW) Capacity factor is the utilization of the turbines (ie. how often the wind blows) Total Generation Output is expressed in Megawatthours (MWh), it is the volume of power produced in a year. To get from MW to MWh, you need to multiple by 24 and 365 (hours a day, number of days in a year). Then to get to output you need to multiply with the Capacity (utilization). Levelized cost of energy (LCOE) is the unit price of power produced. Multiplying output with LCOE gives you the revenues. The debt schedule is based on equal debt service (interest + principal) payments over 20 years. PMT is a standard function in excel that that will give you levelized debt service. Inputs are number of periods, interest rates and present value of debt (ie. initial balance). Try to see if you can calculate based on the Key Assumptions Table on the right. Capital expenses will need to be calculated based on Key Assumptions: EPC Costs ($/kW) x CAPACITY (MW) will give you the required amount (capital cost of the facility build-out). You will need to convert MW to kW to calculate the correct $ amount. MACRS depreciation is an accelerated depreciation method for tax purposes. Here the full CAPEX will be depreciated over 5 years.