You are working for a real estate developer in Kuwait; your manager requested from you to create/ setup an Excel spreadsheet that can calculate NPV and IRR, and to apply

it on the following opportunity: 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%.(2 marks) a. Which project is the best? And why? 2. From the spreadsheet, calculate the IRR for all projects(2 marks) a. which project is the best? And why? 3. Calculate the payback period for all three projects.