When making the Excel Sheet. Click on each cell and show the formula inside the cell. id like to be anle to create the spreadsheet myself so that u can learn the correct formulas. PLEASE SHOW FORMULAS.

1. (15 pts.) Make an Excel spreadsheet (sheet 1, renamed as "NPV") designed to calculate the NPV, IRR, profitability index and payback period for a project. Those are the outputs, and should be labelled. The inputs are the project's required rate of return and its 40 quarterly cash flows. To grade #1, I'll be putting the required rate of return into the cell where your label suggests, and I'll be cutting and pasting a column of 40 quarterly cash flows your spreadsheet's space for them. Then I'll verify your spreadsheet's four answers