2. Recalculate the IRR for Project A and for Project B - again, to 0 decimal places - but this time, add a guess to the =IRR(values,[guess]) function: (a) If your guess in =IRR(values,[guess]) is 0, what is the IRR for each project? (b) If your guess in =IRR(values,[guess]) is 1, what is the IRR for each project? Based on your recalculated IRR alone, which do you conclude is the better project to invest in?

1 2 Year 3 0 4 1 5 2 6 3 7 4 8 5 9 Internal Rate of Return 10 IRR Guess O 11 IRR Guess 1 12 Net Present Value at Rate of... 13 5% 14 10% 15 15% B C Cash Flows Project A Project B S (15,000) S (15,000) S 4,600 S 10,000 S 4,600 S 15,000 S 4,600 S 20,000 S 4,600 S 10,000 S 4,600 S (50,000)