NPV or PV functions must be used in Excel. Your explanations are also required to describe each one. Please show me the formulas so I know how to practice. I NEED TO SEE THE FORMULAS PLEASE TO PRACTICE AND KNOW WHAT I AM DOING IN EXCEL

A company is considering three capital budgeting projects. Data relative to each is given below. Each project has a life of 5 years. The company uses the NPV method to evaluate capital budgeting projects and its discount rate is 5%. (hint: Residual Value is part of the cash flow for year 5) Initial cash outlay (cost) Project A Project B $6,000,000 $5,000,000 Project C -$3,000,000 Cash inflows year 1 2,750,000 1,800,000 600,000 Cash inflows year 2 1,500,000 1,800,000 600,000 Cash inflows year 3 1,500,000 1,800,000 600,000 Cash inflows year 4 1,100,000 1,800,000 600,000 Cash inflows year 5 500,000 1,800,000 600,000 Residual Value: 500,000 0.00 100,000 1. Using the Payback method, how long does each project take to re-coup the investment? 2. If the projects are mutually exclusive, using the NPV formula, which, if any, should the company accept? Why? 3. If the projects are independent, which, if any, should the company accept? Why