### Caledonia: calculate payback period, NPV, IRR, and ranking conflict

I do not understand the NPV, or IRR. I have to answer these questions in an excel spreadsheet. File is attached. 12. Caledonia is considering two additional mutually exclusive projects. The cash flows associated with these projects are as follows: YEAR PROJECT A PROJECT B 0 −$100,000 −$100,000 1