please solve using Excel and create 3 different tables for each project and also describe the use of NPV,IRR, and payback not define describe in details please, with advantages and disadvantages.

16SC VE311: Civil Construction Assignment # 1: Investment Appraisal Tools and Techniques Summer 2020 You are working for a real estate developer in Kuwait; your manager requested from you to write a 300 words memorandum to management including the following: 1. Describe the use of net present value (NPV), internal rate of return (IRR), and the payback method in evaluating projects cash flows. (5 marks) 2. Describe the advantages and disadvantages of each method. (5 marks) Your manager also requested from you to create/ setup an Excel spreadsheet that can calculate NPV and IRR, and to apply it on the following opportunity: Year Project A Project Project C B 0 -500 -500 1 129 200 180 2 120 250 200 3 140 300 300 4 200 200 400 300 50 100 -500 Your spreadsheet must be constructed in such a way that it can accommodate different values of the discount rate and must be as efficient as possible. All three projects should be in one sheet for the comparison. 1. From the spreadsheet, calculate the NPV for all projects, using a discount rate = 7%, 8%, and 10%. (3 marks) a. Which project is the best? And why? (2 marks) 2. From the spreadsheet, calculate the IRR for all projects a. which project is the best? And why? (3 marks) (2 marks) 3. Calculate the payback period for all three projects