BANK 3009 Corporate Valuation and Risk Management

**PLS provides the formulas and functions used in excel**

1) Consider the following two sets of project cash flows:

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.

\begin{tabular}{lccccccccc} Project & Year 0 & Year 1 & Year 2 & Year 3 & Year 4 & Year 5 & Year 6 & Discount Rate \\ \hline X & 800 & 150 & 155 & 192 & 250 & 286 & 292 & 0.123 \\ \hline Y & 500 & 195 & 195 & 90 & 80 & 87 & 92 & 0.123 \\ \hline \end{tabular}