I am using Excel

Part A: A proposed $6.0 M investment at an ethanol facility will save the plant $1.0 Mfyr in energy costs. The equipment needs maintenance every 3 years (year 3, 6. 9), costing $700k each time. The equipment has a useful life of 11 years. The applicable interest rate is 18%fyr. Should the plant make this investment. and why? Draw a cash flow diagram and solve on paper scan it to submit in your document. Part B: Use the applicable Excel functions to solve the same problem in Part A. I Check your math against your answer from Part A; correct any problems. I Screenshot your spreadsheet for submission in your document. I Also screenshot the formula view: Formulas tab >> Formula Auditing > > Show Formulas; put this screenshot in the document. Part C: A proposed $6.0 M investment at an ethanol facility will save the plant $1.0 Mfyr in energy costs. The equipment needs maintenance every 3 years (year 3, 6. 9), costing $700k each time. The equipment has a useful life of 11 years. What is the effective internal rate of return (expressed as 96!er on this project this is the value of i that leads to PT = 0? lf you have set up your spreadsheet nicely, this can just be playing around with i until the net present value is zero. Provide a screenshot that clearly shows your answer in your document