The first picture is the solution. Need to figure how to get the solutions using the functions PMT, SUM, Subtraction, Multiplication, and Division.

One-Varia ble Data Table: APR Tuvo-Variable Data Table: APR a nd Cost of Home Input Area Cost of home Down Payment APR No. Years for Loarn Payments Per Year $150,000.00 Ca kuated Resu ts for Each APR Mo nth ly Payment by Cost/APR 10,000.00 APR Payment Total Repaid Total Interes APR 200,000.00 225,000.00 250,000.00 4.00% 4.00%s 668.38 $240,617. 31s 100,617.31 4.00%S 907.09 $ 1,026.44$ 1,145.80 30 4.25%$688. 72$247,937. 71$107, 937.71 4.25%S 934.69$ 1,057.67 $ 1,180.66 12 4.50% s 709.36 $255,369.40$115, 36 9.40 4.50% s 962.70$ 1,089.37$ 1,216.04 4.75%$730.31$262,910. 26 $ 122,910.26 4.75%S 991.13$ 1,121.54s 1,251.95 5.00%$751.55 $270,558 10 $130,558.10 5.00% s 1,019.96 $ 1,154.17 $ 1,288.37 $140,000.00 5.25%$ 773.09 $278,310.67 $138310.67 5.25% s 1,049.19 s 1,187.24 $ 1,325.29 0.33% 5.50%$794.90 $ 286,165. 66$146. 165.66 5.50% s 1,078.80 $ 1,220.75 $ 1,362.69 360 5.75%$817.00 $ 294,120.72 $154, 120.72 5.75%$ 1,108.79$ 1,254.68$ 1,400.57 $ 668.38 6.00%$ 839.37 $302,173.46 $ 162,173.46 6.00%s 1,139.15 $ 1,289.03 $ 1,438.92 6.25%$ 1,169.86 $ 1,323.79 $ 1,477.72 6.50%$ 1,200.93 $ 1,358.95 $ 1,516.96 6.75%S 1,232.34 $ 1,394.49 $ 1,556.64 7.00%$ 1,264.07 $ 1,430.40 $ 1,596.73 7.25%$ 1,296.13 $ 1,466.68 $ 1,637.22 7.50%$ 1,328.51 $ 1,503.31 $ 1,678.11 7.75%$ 1,361.18 $ 1,540.29 $ 1,719.39 800% 1,394.15 1,577.59 1,761.0:3 Output Area Amount of Loan Periodic Rate No. Paym ent Periods Monthly Payment Total to Repay Loan Total Intere st Paid 240,617.31 100,617.31