Requires a PMT, SUM, Subtraction, Multiplication, Division, and the utilization of devloping Tables- both one-variable and two-variable data tables.

please show all solutions and formulas.

E29 fx D Crain's Morgatage Calulator $ 150,000.00 $ 10,000.00 4.00% 30 12 1 2 3 Input Area 4 Cost of home 5 Down Payment 6 APR 7 No. Years for Loan 8 Payments Per Year 9 10 Output Area 11 Amount of loan 12 Periodic Rate 13 No. Payment Periods 14 Monthly Payment 15 Total to Repay Loan 16 Total interest Paid 17 10 19 20 21 One Variable Data Table: APR Calculated Results for Each APR APR Payment Total Repaid Total Interest 4.00N 4.25% 4.SON 4.75 5.00% 5.25 5.50% 5.75% 6.00 Two-Variable Data Table: APR and Cost of Home Monthly Payment by Cost/APR APR $200,000.00 $ 225,000.00 $ 250,000.00 4.00% 4.25% 4.50% 4.75% 5.00% 5.25% 5.50% 5.75% 6.00% 6.25% 6.50% 6.75 7.00N 7.25% 7.50% 7.75 8.00% 25