Goal Seek Effective Interest Rate: Calculator and Formula

Goal seek the effective interest rate by entering the loan’s payment count, payment amount, and amount borrowed; the calculator solves for the periodic rate and converts it to an annual percentage rate (APR). This estimate assumes equal payments at regular intervals and does not include fees or other cash flows.

Formula

The calculator finds the periodic interest rate that makes the present value of the level payments equal the amount borrowed:

PV = PMT × [1 − (1 + r)−n] / r

It solves this equation numerically for r, then reports APR = 12 × r × 100. The variables are:

• PV: amount borrowed, in dollars.
• PMT: equal payment each period, in dollars.
• n: total number of payment periods.
• r: interest rate per payment period, as a decimal.
• APR: the periodic rate multiplied by 12 and expressed as a percentage, assuming monthly periods.

The function rate(n, pmt, pv) returns the periodic rate as a decimal. Because this calculator uses monthly payments, multiplying by 1,200 converts that decimal rate to a nominal annual percentage. It is an APR-style annualization, not the annual effective rate after compounding. For a monthly rate r, the annual effective rate is ((1 + r)^12 − 1) × 100.

Worked Example

Using the default inputs—60 monthly payments of $405.53 on $20,000 borrowed—the solver finds a monthly rate of approximately 0.009996, or 0.9996% per month.

1. Set the present value to PV = $20,000, the payment to PMT = $405.53, and the number of payments to n = 60.
2. Solve 20,000 = 405.53 × [1 − (1 + r)−60] / r for r. Numerically, r ≈ 0.009996.
3. Annualize the periodic rate: 0.009996 × 12 × 100 ≈ 12.00% APR.
4. The effective rate per payment period is 0.009996 × 100 ≈ 0.9996%.

The calculator displays 12.00% APR and 0.9996% per period at its stated precision. The payment is treated as exactly $405.53 each month; rounding or changing any input can slightly change the solved rate.

Assumptions

• The interest rate is fixed, and every payment is the same amount.
• Payments occur monthly at regular intervals, with the first payment one period after borrowing.
• Compounding is monthly; APR is calculated as the monthly rate multiplied by 12.
• Fees, taxes, insurance, escrow, and any other charges or cash flows are not included. Enter the amount actually financed and payment amount relevant to the calculation; obtain actual figures from the lender.

When to Use Goal Seek

Goal seek is useful when you know the principal, payment, and number of payments but do not know the rate implied by those figures. It works backward from a payment schedule rather than applying a rate already given to calculate a payment. This is a mathematical estimate, not a substitute for a loan disclosure or a full cash-flow analysis.

For example, if a quoted payment and loan amount seem inconsistent with a stated rate, solving for the implied rate gives a way to check the arithmetic. Make sure the payment is for principal and interest alone and that its timing and term match the inputs. If the payment includes charges, a balloon amount, or an irregular first period, the simple level-payment model will not reproduce the full agreement.

How to Read the Rate

The headline result is the nominal annualized rate, calculated from a monthly periodic rate. The second result is the rate for one monthly payment period. These figures describe the same solved periodic rate in two different ways; the APR figure is not an effective annual yield.

For the example, 0.9996% per month compounds to an effective annual rate of about 12.68%: ((1 + 0.009996)^12 − 1) × 100. That differs from the 12.00% nominal APR because monthly interest compounds. The precise meaning of APR in a particular disclosure can also depend on included charges and applicable calculation conventions, none of which this calculator models.

Common Problems and Limits

• Payment does not repay the balance: If the payment is too small relative to the amount borrowed and term, there may be no positive rate that fits the inputs. The solver may return no usable result.
• Fees are omitted: A rate solved from principal and scheduled payments is not necessarily the all-in cost of borrowing. Fees paid upfront or financed can change the cash flows and the rate implied by them.
• Payment frequency is not monthly: The APR conversion here assumes 12 monthly periods per year. For weekly, biweekly, quarterly, or other schedules, solve for the rate per actual period and annualize using the correct number of periods; do not use the displayed APR conversion unchanged.
• Irregular cash flows: Variable payments, skipped payments, extra payments, and balloon balances need a cash-flow model that represents each amount and date.
• Rounding: Payments displayed to cents may be rounded from a more precise contractual amount. A small change in payment or term can alter the implied rate, particularly when the inputs are rounded.

The solver seeks a periodic rate consistent with the supplied level-payment equation; it cannot infer missing terms, verify a contract, or establish what a lender includes in a disclosed rate. Check the input values and payment schedule against the lender’s documents.

Frequently Asked Questions

What does goal seek mean for an interest rate?
It means solving backward for the rate that makes a payment schedule match a known loan amount, payment, and number of periods.

Is the goal-seek result an APR or an effective annual rate?
The headline result is a nominal APR-style annualization of the monthly rate. An effective annual rate accounts for monthly compounding and is higher for a positive rate.

Can I use this for a loan with fees?
Not as an all-in rate unless the relevant fees and cash flows are represented. This calculator uses only the amount borrowed and equal payments; compare with the lender’s disclosed figures.

Why might the calculator not find a rate?
The inputs may not describe a repayable level-payment loan—for instance, payments may be too small for the stated amount and term—or the actual schedule may include irregular cash flows.

Does it work with non-monthly payments?
The underlying rate solver can represent equal periods, but the displayed annualization assumes monthly payments. The conversion must be adjusted to match a different payment frequency.

This result is an estimate; the lender’s disclosure gives the exact figures.

Related

• Current Fed Interest Rate: The Latest Target Range
• Effective Interest Rate: Calculate and Understand It
• Car Loan Effective Interest Rate Calculator

in n | Number of payments | - | 60 | 1 | 600
in pmt | Payment amount | $ | 405.53 | 0.01 | 100000000
in pv | Amount borrowed | $ | 20000 | 0.01 | 100000000
out apr | Goal-seek APR | % | rate(n, pmt, pv) * 1200 | 2
out per | Effective rate per payment period | % | rate(n, pmt, pv) * 100 | 4