Dear, please add the formulas for each calculation thank you

Complete the following questions using Microsoft Word or Excel, as appropriate. Review the grading rubric to confirm you are meeting the assignment requirements Gyro Corporation is considering two investment projects, each of which will cost $1,460,000. The estimated cash flow for each project is as follows Plant Expansion Retail Store Expansion 525,000 425,000 400,000 260,000 250,000 1,860,000 Year 520,000 480,000 350,000 275,000 5160,000 2 4 Total 1,785,000 The company has decided that a 10% discount rate is appropriate for each project Required 1. Calculate the payback period for each project 2. Calculate the Net Present Value (NPV) of each project 3. Advise management which, if either, project to pursue and why