***Please show in Excel W/Formulas***

Using the replacement chain (common-life) approach, can you type the net present value of the project you would choose (A or B)? ..... Assume the discount rate is 5% Year 0 1 Project A Project B -117,106 -73,883 57,214 51,126 42,643 53,501 47,830 55,589 2 3 4 * Round your answer to the nearest two decimals if needed. Do not type the $ symbol