Calculate the NPV and IRR for these two mutually exclusive projects. For both projects the required rate of return is 10%. Which project would you select and why? Provide sufficient detail to demonstrate your savvy financial skills.
Year 0 1 2 3 4 NPV IRR (%)
Project A -100 50 50 50 50
Project B -400 170 170 170 170
Please see the attached excel document.
Calculate the NPV and IRR for these two ...
The solution helps in calculating NPV and IRR for two mutually exclusive projects.