1. Given 4 interest rates located in the cells A2, 32, C2 and D2. And the input located in cell 62 (the input is the position of the rate to be used in this case is 3, meaning the 3rd rate which is 1.56%). Write the code to calculate the present value of the cash ow located in B7 in the cell B8. A B C D E F G CALCULATION RATES User Input Rate 1:] t I Cash Flow 1 S 234,908.89 W E lDGHO'IUI-bu-'lMH 3 . Complete the blanks with the missing statement in the calculation of a present value for 5 cash flows. Sub Question 2 ( ) K = 3 [ = 5. 3%/0 Cash Flow ! = Cells ( 2, 3 ) . value Cash Flow 2 = Cells ( 7 , 6 ) . value Cash Flow 3 = Cells ( 29, 19 ) . value For J = to K If K = 1 Then Cells ( 2 + K , 1 ) . value = Cash Flow ! ! ( 1 +r )~_ End if IF K =\ Then Cells ( 2 + , I ) . value = Cash Flow 2 / ( 1 + r ) " K End if If K = 3 Then Cells ( 2 + K , I ) . value = " ( 1 +r ) ' K End if Next J End Sub4 . Debug the following statements " Cont = 0 Cont K Cells ( K , 2 ) Cells ( K , 3 ) For K = 1 to 7 Cells ( K , 2 ) . value = K + 1. If K = 3 then Cont = Cont + 1 Cells ( K , 3 ) . value = " X" End if Next k