Rows 25-28 contain a section for what-if analysis. In cell B27, use the RATE financial function to calculate the periodic rate using $1,400 as the monthly payment (cell B26), the NPER, and loan amount in the original input section.

D E A B C 1 Loan (PV) $ 300,000.00 2 APR 4.50% 3 Monthly Rate 0.38% 4 NPER 360 5 Monthly Payment $1,520.06 6 7 Payment Number Beg Balance Interest 8 1 $ 300,000.00 $1,125.00 9 2 $ 299,640.00 $1,123.52 10 3 $ 299,280.00 $1,122.03 11 4 $ 298,920.00 $1,120.54 12 5 $ 298,560.00 $1,119.04 13 6 $ 298,200.00 $1,117.54 14 7 $ 297,840.00 $1,116.03 15 8 $ 297,480.00 $1,114.51 16 9 $ 297,120.00 $1,112.99 17 10 $ 296,760.00 $1,111.47 18 11 $ 296,400.00 $1,109.93 19 12 $ 296,040.00 $1,108.39 20 21 Cumulative Totals after Year 1 22 Interest $ 13,400.99 23 Principal Paid $ 4,839.68 24 25 What if the goal is $1,400 monthly payment? 26 Monthly Payment $ 1,400.00 27 Monthly Rate Needed 28 APR Needed 29 30 31 32 33 34 35 Details Map Loan Principal $395.06 S396.06 $397.07 $398.08 $399.09 $400.10 $401.12 $402.14 $403.16 $404.18 $405.20 $406.23 21 LO Rows 25-28 contain a section for what-if analysis. In cell B27, use the RATE financial function to calculate the periodic rate using $1,400 as the monthly payment (cell B26), the NPER, and loan amount in the original input