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). Tempest Industries Inc. is considering a 13-year project that requires an initial investment of $50 million. The project provides no annual cash inflow for the first five years, an annual cash inflow of \$20 million for the subsequent five years, and an annual cash inflow of $25 million during the final three years. If the firm's required return for this project is 15%, what is the profitability index (PI) of this project? ( 2 points)