Please solve in EXCEL

A & B are mutually exclusive while C is independent.

Following are their expected cash flows year project A Project B 0 -60,000.00 -40,000.00 1 0 40,000.00 Project C -20,000.00 35,000.00 N 82,000.00 40,000.00 30,000.00 3 60,000.00 20,000.00 20,000.00 10,000.00 2,000.00 -40,000.00 4 Assuming no capitol rationing a required rate of return (cost of capital) of 12% for all three projects. 1) Calculate NPV for project A, B and C. 2) Calculate IRR for project A, B and C (2 IRRs for project C). 3) Calculate pl for project A