Capital Budgeting Techniques

$$ Instruction$>$

This assignment must be completed in Excel. If your work is not completed in Excel, it won't be graded.

CSUSM is considering two mutually exclusive investments. The projects' expected net cash flows are as follows:

Expected Net Cash Flows

a$.$ Construct NPV profiles for Projects A and B$.(20$ points$)$

b$.$ Calculate each project's IRR $(15$ points$).$

d$.$ At what rate do the NPV profiles of the two projects cross? $(20$ points$)$

scenario? $(30$ points$)$