*** This is a calculation question ** Ensure that you do all rough work to 4 decimal places throughout. Final answer is decimal places unless the unit of the answers in dollars. Rough work must done on a separate piece of paper and a photo will be taken and submitted at the end of the exam. Excel cannot be used for rough work. Norough work. no marks even if your answer is correct. Put your final answer in the box below. Scenano in project management, it is not simple to decide on which projects to pick. All projects at face value seemmportant to an organization. One of the suggestions by the textbook is the use of two models - NPV and Muit weighted scoring. You have been asked by a company to do an analysis of Project and Projecte Al Determine the NPV for Project Alf it has a required return on percentage of 20%, with the cost of the project being $700.000, and for the next 5 years, the ) Determine the NPV for Project Bif it has a required return on percentage of 15t. With the cost of the project being 5650,000, and for the next 4 years, the party revenue is $270.000 (2 marks) Using the table below, determine the mult weighted score for Project A and Project marks) Critera Market Share Obstacle for competitors Enabler Core Tech SCM Dependency Legal issues Weight Project A Scom Project Score 2 2 1 0 1 2.5 6 5 2 4 6 8 Din the data from Dart A and of this oueston you have been asked by the Portfolio Manater for our opinion as to which oroiect should be Sandu A) Determine the NPV for Project Affit has a required return on percentage of 20 with the cost of the project being $700.000, and for the next year the yearly revenue is $250.000 (3 marks ) Determine the NPV for Projects that a required return on percentage of 15, with the cost of the project being 3650.000, and for the next years the yearly revenue 5270.000 (2 market) C) Using the table below.determine the mult weighted score for Project A and Project marks (criteria Market Share Obstacle for competitors Enabler Core Tech SCM Dependency Weight 2 2 2.5 1 Project A Score 4 3 2 0 0 1 Project Score 6 6 5 6 D D) Given the data from part AB and C of this question, you have been asked by the Portfolio Manager for your opinion as to which proct should be picked Or B? How did you come to your conclusion? justify your answer. 17 marks) (TYPE YOUR ANSWER IN THE BOX BELOW.. DO NOT WRITE THIS ANSWER ON YOUR ROUGH WORKS For the toolbar.press ALT F10 (PC) OF ALTF10 (Mac. BI U Paragraph TI 14px Anal !!! 11! A 2