Question: can you please use excel to answer the question as I want to know how to do it on excel ? BANK 3009 CVRM Continuous
can you please use excel to answer the question as I want to know how to do it on excel ?

BANK 3009 CVRM Continuous Assessment Questions 1A Please submit your answers to the following questions in Excel file format via learnonline. 1) Consider the following two sets of project cash flows: Discount Project Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Rate -830 145 158 193 253 288 290 0.123 Y -510 193 193 91 81 88 90 0.123 A) Assume that projects X and Y are mutually exclusive. The correct investment decision and the best rational for that decision is to: i) invest in Project Y since IRRY > IRRX. ii) invest in Project Y since NPVy > NPVX. iii) neither of the above. B) What are the incremental IRR and NPV of Project X? C) Is the use of the incremental measures in B) appropriate to your evaluation of the preferred project? Explain. D) Which is the preferred project? Explain and justify the basis for your choice
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
