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.