I don't understand how this goes in an Excel file.

For any time value computations, must use the FV, PV, PMT functions in Excel, as appropriate. explanations should also be placed in the same Excel workbook

1.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 Net Present Value (NPV) method to evaluate capital budgeting projects and its discount rate is 10%.

Project AProject BProject C

Initial cash outlay (cost)-$5,000,000-$6,000,000-$2,500,000

Cash inflows per year$1,500,000$1,800,000$600,000

Residual value$ 500,0000$100,000

2.If the projects are mutually exclusive, which, if any, should the company accept?Why?

3.If the projects are independent, which, if any, should the company accept?Why?

4.One of the company's managers states "To me, no matter what else we do, Project C needs to be our first choice because it has the lowest initial cost of $2,500,000."Comment on this manager's proposal, considering the concepts of NPV and Payback Method.