Consider the following two mutually exclusive projects. What is the IRR for each project? What is the crossover rate between the two projects? What is the NPV for each project at a required return of $11$ percent? What is the NPV for each project at the various interest rates shown?

Input area:

$$ A B $$

Year $0($$$41,300)($$$41,300)$

Year $119,1006,300$

Year $217,80014,200$

Year $315,20017,900$

Year $48,40030,300$

$$

Required return $11\%$

$$

Required return $0\%$

Required return $5\%$

Required return $10\%$

Required return $15\%$

Required return $20\%$

Required return $25\%$

$"$

$($Use cells A$6$ to C$20$ from the given information to complete this question. You must use the built$-$in Excel function to answer this question.$)"$

Output area:

IRR A $$

IRR B $$

$$

$$ CF difference $$

Year $0$

Year $1$

Year $2$

Year $3$

Year $4$

$$

Crossover rate $$

$$

NPV A $$

NPV B $$

$$

$$ NPV A NPV B $$

NPV at $0\%$

NPV at $5\%$

NPV at $10\%$

NPV at $15\%$

NPV at $20\%$

NPV at $25\%$