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.

Learn how to use Excel's What-If Analysis tools, including Goal Seek and Scenario Manager, to explore different scenarios and outcomes using ...