please show all work in excel

11. Projects are mutually exclusive (NPV & IRR) Three projects, A, B, and C have free cash flows listed below. The firm has a cost of capital of 15%. Calculate the NPV and IRR of the projects and determine if these independent projects should be selected: Year o Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 -$15,000 $5,000 $4,000 $3,000 $2,000 $1,000 $1,000 $15,000 $2,667 $2,667 $2,667 $2,667 $2,667 $2,667 -$15,000 $1,000 $1,000 $3,000 $4,000 $5,000 $6,000