I basically need the formula which is not subtracting, to calculate the pricipal paid

Kaleen now wishes to finalize the Amortization schedule. In cell J4, create a formula without using a function that subtracts the value in cell I4 from the value in cell H4 to determine how much of the mortgage principal is being paid off each year.

3 Fird @ amp Millowski 1. Kaleen now wishes to finalize the Amortization schedule. 2 $ 371,973.23 S 4153.63 34,153335,231.65 4 5 3E9,281.ES315,26.47 5 5,2957 91,19.0 6 5 284,123.EOTL 713.49 7$ 271.7139247, 974 26 B S 24T,37426 222 833.46 S 4B8,000. 0 " crt 3,228 63 1,4542 In cell 14, 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 principal is being paid off each year. 2ULU |dalitdel 5 UUwnpayme' Varying Interest Rate Schedule 2. Copy the formula in cell 14 to the range J5:118. ,827. 605,139.33 614963 62384 5 633,5729 641,57 B3 654829 U 3 In cell K4, create a formula using the IF function to calculate the interest paid 128,853.20 924 3,974 29 1251-,142 U6, 524.69 on the mortgage (or the difference between the total payments made each year and the total amount of mortgage principal paid each year 175, 05.89 164,623,u1 3,786.7 183,037.68 73,032.73 S 7,563.42 8 The formula should first check if the value in cell H4 (the balance remaining on the loan each year) is greater than a. ,125 .175.82 663,C27.E3 21 b. If the value in cell H4 is greater than O, the formula should return the value in 14 subtracted from the value in cell DS multiplied by 12. Use 23 a relative cell reference to cell J4 and an absolute cell reference to cell 2,333 E6 21258.82 DS. (Hint: Use 12*sDS5-J4 as the is_true argument value in the formula.7.3 ,441 33 .494 84 715,950 2,235 9E 240,23.98 If the value in cell H4 is not greater than 0, the formula should return a value of 0 c. 'J Copy the formula from cell K4 into the range K5: K18 4. Apply the Accounting number format with two decimal places and $ as the symbol to the range K4:K18 5 In cell K20, create a formula without using a function that references the defined name DowIn_Payment. Dacumartahan Campground Mortgace