Need Excel formula on how to calculate regular paybacks!!!!!!!!!!!!!!!!!

- You may use Word or Excel, but you will find Excel to be most helpful for creating spreadsheets. - If you choose to solve the problems algebraically, be sure to show your computations. - If you use a financial calculator, show your input values. - If you use an Excel spreadsheet, show your input values and formulas. Problem 1: Capital Budgeting Criteria XYZ Inc. is considering two projects. Its WACC is 12 percent, and the projects' after-tax cash flows (in millions of dollars) would be as follows: 1. Calculate the projects' NPVs, IRRs, MIRRs, regular paybacks, and discounted paybacks. 2. How might conflicts exist between the NPV and the IRR when independent projects are evaluated? Explain your