Excel can solve for unknown variables, either for a single cell with Goal Seek or multiple cells with Solver.

Use the PMT function to calculate the Monthly Payment Now, we will use Goal Seek. On the Data tab, click the What-if Analysis button in the Forecast group and select Goal Seek from its menu.

This month’s column shows how to use Excel’s Goal Seek for data analysis.