please answer using excel and explain

14) You are offered an investment that will pay the following cash flows at the end of each of the next five years: How much would you be willing to pay for this investment if your required rate of return is 12% per year? Use Excel's =NPV(B1,B5:B9) function. Note that we did not include the period 0 's cash flow in the function. Excel's NPV function doesn't really calculate net present value. Instead, it simply calculates the present value of uneven cash flows. It does not take the cost of the initial outlay into account