use excel format

Problem 1 PROBLEM 2 (Based on 14.2) Problem 2 Problem 3 Problem 4 Pentron is evaluating two investment projects, each of which requires an up-front expenditure of $12.45 million. The projects are expected to produce the following net cash inflows: Year a. What is each project's IRR? Project A: Project B: Project A Project B 0 1 2 3 b. What is each project's NPV if the cost Of capital is 6 percent? 12 ercent? 18 percent? Cost Of Capital Proj A Proj B