Show formulas for each box please

Assignment will close on Feb 13 at 11:59 PM Background utaminome common in rows barking in Engles include the motion for cow! wyments throughout the other while the loan be is fullypted the teacher in this type of an ng is your current augment In this article on the two tables, one ed One Variable Datable in the other two variable. These are the which would include the mount of worst and indollectively with the balance teacht Infort to describe the two-TABLE.ble datatable should go to the APR while the TABLE the cost of andere Hoos that comes with delome of the tables in the right Instructions wo sie Chastainement Thement remaM SUM Station Monthewiowe Tas both one and will . Bithyou the 215 B IC D E G H K Brooks 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 lepay Loan 16 Total interest Paid 17 18 19 20 21 22 23 24 One-Variable Data Table: APR Calculated Results for Each APR APR Payment Total Repaid Total interest 4.00% 4.25% 4.50% 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% 50X 5.75% 6.00% 6:25% 6.50% 6.75% 2.00% 7.25% 7.50% 7.75% 8.00% 26 Note: Always replace my name with yours at the Top! 27 This spreadsheet requires a Date Function! 23 HERE Home Loan Crain's Morgatage Calulator Input Area Cost of home Down Payment APR No. Years for Loan Payments Per Year $ 150,000.00 $ 10,000.00 4.00% 30 12 One-Variable Data Table: APR Calculated Results for Each APR APR Payment Total Repaid Total interest 4,00% $ 668.38 $ 240,617.31 $ 100,617.31 4.25% $ 688.72 $ 247,937.71 $ 107,937.71 4.50% $ 709.36 $ 255,369.40 $ 115,369.40 4.75% $ 730.31 $ 262,910.26 $ 122,910.26 5.00% $ 751.55 $ 270,558.10 $ 130,558.10 5.25% $ 773.09 $ 278,310.67 $ 138,310.67 5.50% $ 794.90 $ 286,165.66 $ 146,165.66 5.75% $ 817.00 $ 294,120.72 $ 154,120.72 6.0056 S 839.37 S 302,173.46 $ 162,173,46 Output Area Amount of loan Periodic Rate No. Payment Periods Monthly Payment Total to Repay Loan Total interest Paid $ 140,000.00 0.33% 360 $ 668.38 $ 240,617.31 $ 100,617,31 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% S 907.09 1,026,44 $ 1,145.80 4.25% S 934.69 $ 1,057.67 $ 1,180.66 4.50% $ 962.70 $ 1,089.375 1,216.04 4.75* $ 991.13 $ 1,121.54 $ 1,251,95 5.00 $ 1,019.96 $ 1.154.17 $ 1,288.32 5.25% $ 1.049.19 $ 1.187.24 $ 1,325.29 5.50% S 1.078.80 $ 1,220.75 $ 1,362.69 5.75% $ 1,108.79 $ 1.254.68 $ 1,400.57 6.00% $ 1.139.15$ 1.289.03 $ 1,438.92 6.25% $ 1,169.86 $ 1,323.79 5 1,477.72 6.50% S 1,200.93 $ 1,358.95 $ 1,516.96 6.75% $ 1,232.34 $ 1,394.49 $ 1,556.64 7.00% $ 1,264.07 $ 1,430,40 S 1,596.73 7.25% $ 1.296.13 $ 1,466.685 1,637.22 7.50% S 1,328.51 $ 1,503.31 $ 1,678.11 7.75$ 1,361.18 $ 1,540.29 $ 1.719.39 3.00 $ 1,394.15$ 1.577.59 $ 1,761.03 Note: Always replace my name with yours at the top! This spreadsheet requires a Date Function