QUESTION 1 INSTRUCTIONS: 1. Read the information below, including Parts a and b of Question 1. 2. Create a new Excel spreadsheet. Record your answers to all parts of the question into the spreadsheet. Use bold text to clearly label your responses to Part a and Part b. Save your work regularly. 3. Check the exam timer regularly. Allow ample time to upload your Excel spreadsheet before the exam ends. 4. Select the Browse My Computer button to upload the completed Excel spreadsheet. It may take several seconds for the file to upload. Once uploaded, the name of the file will appear next to Selected Answer. 5. You can upload only one file in response to this question. You can replace the file as many times as you like. (a) For the following mutually exclusive projects (A, B, C and D) find the Payback period, NPV, and IRR, given the required rate of return is 11.00%.p.a. (Assume all future cash flows only occur by the end of each year). Based on your results, which project should be accepted and why. Year 4 7 500 A B 0 1 2 3 -8,500 1,500 2,500 3,000 -4,100 1200 1200 1200 -4,000 2,000 1,000 -500 -3,500 1,700 1,700 1,700 2000 1200 2,000 5 6 1500 1,000 1200 -600