) DesignaspreadsheetthatcalculatestheLCOEatcapacityfactorsfrom0to100%anddrawcurves of LCOE against capacity factor for the following plants: 200 MW hydropower 200 MW gas turbine using natural gas 25 MW wind turbine 25 MW solar a) Use current investment cost data and state your sources b) Use current natural gas cost and state your source c) All other data should come from Lesson 2. d) Use 8% discount rate. (2) Tabulate the LCOE at a typical operational capacity factor for each of the above plant. (2 marks) (3) Comparethedatafor (i) the 200 MW hydropower and gas turbine plants (ii) the 25 MW wind turbine and solar plants