10.AAAa. .,.., Too Millowski 1 $ 3A,LUU 00 $ 1. Kaleen now wishes to finalize the Amortization sched ule. 371,973 53 In cell 34, create a formula without using a function that subtracts the value in cell 14 from the value in cell H4 to determine how much of the mortgage 315.295.4, S 254.129 3 rincipal is being paid off each year. 69 234,129.30 21,713 4 7$ 27,713.495 243,S74.26 247,974 25 222.833 45 2. Copy the formula in cell 14 to the range 15:318. 1118.011. 10,149 52 3 In cell K4, create a formula using the IF function to calculate the interest paid 13 106,524.69 14 7,032.73 73,0327 57,563 42 on the mortgage (or the difference between the total payments made each year and the total amount of mortgage principal paid each year) The formula should first check if the value in cell H4 (the balance remaining on the loan each year) is greater than o. a. b. If the value in cell H4 is greater than O, the formula should return the value in J4 subtracted from the value in cell D5 multiplied by 12. Use a relative cell reference to cell 14 and an absolute cell reference to cell D5. (Hint: Use 12 SD$5-4 as the istrue argument value in the formula.) If the value in cell H4 is not greater than 0, the formula should return a value of 0 Copy the formula from cell K4 into the range KS: K13 4 3 4 5.7 U 9 10-1 23156|||8 9 20 2 2 2 2 25 26 2 2 2 3 3 1