Learn how to use Goal Seek to calculate the interest rate for a loan based on the payment amount and term length. Follow the step-by-step example with screenshots and formulas.

You can use Goal Seek to determine what interest rate you must secure in order to meet your loan goal. Cells B1, B2, and B3 are the values for the loan amount, term length, and interest rate. Note: Goal Seek works with only one variable input value.

The Solver add-in is similar to Goal Seek, but it can accommodate more variables. You can also create forecasts by using the fill handle and various commands that are built into Excel.

You can use a few other Excel tools to perform what-if analysis if you have specific goals or larger sets of variable data. If you know the result to expect from a formula, but don't know precisely what input value the formula needs to get that result, use the Goal-Seek feature.

There are three kinds of what-if analysis tools in Excel: scenarios, data tables, and Goal Seek. Scenarios and data tables take sets of input values and determine possible results.

You can use Goal Seek when you know the desired result of a single formula but not the input value the formula needs to determine the result.

In Excel for the web, you can project values in a series by using worksheet functions, or you can click and drag the fill handle to create a linear trend of numbers.

Si conoce el resultado que desea de una fórmula pero no está seguro de qué entrada es necesaria para obtener dicho resultado, use la característica Buscar objetivo de Excel.

Use Solver, a Microsoft Excel add-in program you can use for what-if analysis, to determine an optimal product mix.

如果知道公式中想要的结果，但不确定公式需要什么输入值才能获取该结果，请使用“目标查找”功能。 例如，假设需要借款。 你知道你想要多少钱，你想花多长时间还清贷款，以及你每月可以支付多少。 可以使用目标寻求来确定需要确保的利率才能实现贷款目标。 注意: 使用规划求解定义和解决问题. 让我们分步查看前面的示例。 由于要计算达到目标所需的贷款利率，因此请使用 PMT 函数。 PMT 函数计算每月付款金额。 在此示例中，每月付款金额是你寻求的目标。 打开新的空白工作表。 首先，在第一列中添加一些标签，以便更轻松地阅读工作表。 在单元格 A1 中，键入 “贷款金额 ”。 在单元格 A2 中，键入 “以月份为单位的术语 ”。 在单元格 A3 中，键入 “利率 ”。 在单元格 A4 中，键入 “付款 ”。