Please Explain and Show the Formulas

- Open a blank Excel workbook (i.e., do not use class exercise template) to perform your calculations. As I said in class, keep a data-entry section and calculation cells separated. - Click "Homework Assignments Ch _" and upload your completed Excel file. No submission will be accepted beyond the deadline. - Your Excel file needs to be named to reflect your name and the assignment number. For example, I may name my file for Assignment \#1 "nishi_hiro_A1." - Format your answers to two decimal places. In each question, highlight the cell of the you answer in yellow (e.g., $812.51,12.35% ). - Solutions will not be presented during the semester. Instead, we will go over some of the key problems in the exam review session(s). Moonlight Gas \& Electric Inc. is undertaking a 50-year project that requires an initial investment of $100 million. The project provides no annual cash inflow for the first ten years, an annual cash inflow of \$23 million from Year 11 through Year 20, and an annual cash inflow of \$36 million during the subsequent 30 years. If the firm's required return for this project is 10.20%, what is the internal rate of return (IRR) of this project? ( 2 points)