Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a formula across a row or down a column, an absolute cell reference or a mixed cell reference may be preferred. If a specific Excel function is to be used, the directions will specify the use of that function. Do not type in numerical data into a cell or function. Instead, make a reference to the cell in which the data is found. Make your-computations only in the blue cells highlighted below. In all cases, unless otherwise directed, use the,eartiest appearance of the data in your formulas, usually the Given Data section. You have 3 projects with the following cash flows: a. For which of these projects is the IRR rule reliable? b. Estimate the IRR for each project (to the nearest 1%. c. What is the NPV of each project if the cost of capitar is 5%?20% ? 50% ? a. For which of these projects is the IRR rule reliable? The IRR rule is reliable for b. Estimate the IRR for each project (to the nearest 1% ). c. What is the NPV of each project if the cost of capital is 5%?20%?50%