You are considering the following three projects. A & B are mutually exclusive while C is independent.

Question: On one graph, plot the NPV profile for Both projects, A&B.

please show how on excel

Following are their expected cash flows

year	project A	Project B	Project C
0	-60,000.00	-40,000.00	-20,000.00
1	0	40,000.00	35,000.00
2	82,000.00	40,000.00	30,000.00
3	60,000.00	20,000.00	2,000.00
4	20,000.00	10,000.00	-40,000.00