please answer using excel and explain

15) How much you will get if you invest the following cash flows at 12% per year? There is no function to calculate the future value of uneven cash flows. Therefore, we need to find the future value of each of the cash flows individually and then add them all together. The cash flow in period 1 needs to be taken four periods forward (moved from period 1 to 5 ) so the formula in C5 is: =FV(SB$1,$AS9A5,0,B5). Notice that NPer is calculated by taking the period of the last cash flow (5, in A9) minus the period of the current cash flow (1, in A5). Also, note that the dollar signs serve to freeze the reference so that when you copy the formula down those addresses won't change (i.e., they are absolute references). Copy and then paste that formula into A 6:A9. To find the future value of the cash flows in B11, use the formula: =SUM(C5:C9). Another way to find the future value of any set of cash flows is to first find the present value of those cash flows and then to find the future value of that present value. The picture, below, demonstrates the process: We already saw that we can calculate the present value of uneven cash flows using the NPV function, so we will use the NPV function for the PV argument in the FV function. The formula becomes: =FV(B1,A9,0,NPV(B1,B5:B9))