14. Use the data in the Loan Worksheet sheet to run a what-if scenario for a client to show loan payments for a variety of interest rates and loan lengths. This what-if scenario requires a two-variable data table. a. Go to the Loan Worksheet sheet and familiarize yourself with the formula in cell B5. Pay close attention to the cell references b.Select cells B5:E25 to use the payment formula in B5 and the various years and rates as the data table. c. On the Data tab, in the Forecast group, click the What-lf Analysis button and click Data Table. d. In the Row input cell box, enter the cell reference for the length of the loanthe nper argument from the formula in cell B5: C2 e. In the Column input cell box, enter the cell reference for the loan interest ratethe interest argument from the formula in cell B5: A2. f. Click OK. (Data table values are inserted) =PMT(A2/12,c2*12,-C1) C11 E F G . $150,000 Borrowed 15 years Years If you can afford this loan: Loan Payment $690.42 Rate 3.70% Years 30 15 30 40 You can borrow this much: Amount to Borrow $ 150,000 Data Table ? A B 1 Loan Payment per 2 3.70% 3 4 Rates 5 $1,087.12 6 3.70% 7 3.75% 8 3.80% 9 3.85% 10 3.90% 11 3.95% 12 4.00% 13 4.05% 14 4.10% 15 4.15% 16 4.20% 17 4.25% 18 4.30% 19 4.35% 20 4.40% 21 4.45% 22 4.50% 23 4.55% 24 4.60% 25 4.65% 26 | 1 Row input cell: Column input cell: OK Cancel