Please solve the question by typing in the solution and showing all the steps thoroughly and clearly. (solve all 3 parts).

*use excel to do it and make sire your work is neat and east to read.

Consider the following cash flows of two mutually exclusive projects for Illinois Renewable Energy Company. Assume the discount rate for the company is 10 percent. Keep two decimal places when calculating. Year Project A Project B O -$1,700,000 -$750,000 1 1,100,000 375,000 N 900,000 600,000 3 750,000 390,000 a. Based on the payback period, which project should be taken? (1 pt) b. Based on the NPV, which project should be taken? (1 pt) c. Based on the IRR, which project should be taken? (1 pt)