How to do this in excel Nadia wants to compare monthly payments, total interest, and total cost for interest rates that vary from 7.725% to 8.075%. She has already entered formulas to insert the monthly payment in cell D11, the total interest in cell E11, and the total cost in cell F11. Based on the range C11:F26, create a one-variable data table that uses the rate in cell D6 as the column input cell to provide the comparison that Nadia requests

Question

How to do this in excel Nadia wants to compare monthly payments, total interest, and total cost for interest rates that vary from 7.725% to 8.075%. She has already entered formulas to insert the monthly payment in cell D11, the total interest in cell E11, and the total cost in cell F11. Based on the range C11:F26, create a one-variable data table that uses the rate in cell D6 as the column input cell to provide the comparison that Nadia requests

Answer 1

To create a one-variable data table in Excel, follow these steps:

1. Select the range C11:F26.
2. Go to the "Data" tab on the Excel ribbon.
3. Click on the "What-If Analysis" dropdown menu and select "Data Table".
4. In the "Row input cell" box, reference the cell that contains the formula for the monthly payment (cell D11).
5. In the "Column input cell" box, reference the cell that contains the interest rate (cell D6).
6. Click OK.

Excel will now populate the data table with the monthly payments, total interest, and total cost for interest rates ranging from 7.725% to 8.075%, based on the formulas in cells D11, E11, and F11. This table will help Nadia compare the different values based on the varying interest rates.