About this tool
Lenders and sellers often quote a payment rather than a rate: 495 a month for five years, or four payments of 250. An interest rate calculator works backwards from those numbers to the rate you are actually paying, so you can compare offers, check a dealer's quote or see what a buy-now-pay-later plan really costs.
The same math answers savings questions. If you know where you start, how much you can add each month and what you want to have in ten years, the calculator tells you the annual return your money has to earn, which helps you judge whether a goal is realistic for a savings account, bonds or a stock portfolio.
How it works
In loan mode, enter the amount you borrow, the regular payment and the term, and choose how often you pay. The calculator finds the rate per period at which the payments exactly repay the amount over payments, then converts it to an APR (the rate per period times the number of payments a year) and an effective annual rate, which includes compounding.
In savings mode, enter what you have now, the deposit you add each period, your goal and the number of years. The calculator finds the return per period that grows the starting amount and the deposits to the goal. There is no formula that gives directly, so the calculator scans for the rate where the equation balances, narrows it down by bisection and polishes it with Newton's method, the same approach as the RATE function in Excel and Google Sheets.
Example
You borrow 25,000 and pay 495.03 a month for 5 years, which is 60 payments. The rate that makes the 60 payments worth exactly 25,000 today is a month. The APR is , and the effective annual rate is . Over the loan you pay , so the interest costs 4,701.80.
For savings, start with 10,000 and add 200 a month for 10 years, aiming for 50,000. Your deposits add up to 34,000, so the remaining 16,000 has to come from growth. That takes a return of about 0.477% a month: an annual rate of 5.73% compounded monthly, or 5.88% a year effective.
Assumptions and limits
The calculator assumes equal payments at regular intervals, a fixed rate and payments at the end of each period. Fees, insurance and other charges are not included unless you account for them: to see the true cost of a loan with an origination fee, enter the amount you actually receive after the fee as the loan amount, and the rate you get is close to the APR that includes the fee.
The term is rounded to a whole number of payments. Loans with balloon payments, variable rates or irregular payment dates need a different method, such as Excel's XIRR. Results are estimates for comparison and planning, not a loan offer or financial advice; the lender's disclosure statement is the authoritative figure.
Frequently asked questions
How do I calculate the interest rate on a loan from the payment?
Enter the loan amount, the payment and the term. The rate cannot be isolated algebraically from , so it is found numerically: the calculator searches for the rate at which the present value of the payments equals the amount borrowed. Spreadsheets do the same with RATE(n, -payment, amount).
What is the difference between the APR and the effective annual rate?
The APR is the rate per period multiplied by the number of periods in a year, without compounding: 0.5833% a month is a 7% APR. The effective annual rate includes compounding, , so the same loan costs 7.23% a year effective. Savings accounts usually quote the effective rate as the APY.
Does the result match Excel's RATE function?
Yes. The calculator solves the same equation as RATE(nper, pmt, pv, [fv]) with payments at the end of each period. Microsoft's example RATE(48, -200, 8000) gives about 0.77% a month, a 9.24% annual rate, and this calculator returns the same value for a loan of 8,000 repaid with 48 monthly payments of 200.
Why does the calculator say the payment is too low?
If all the payments together add up to less than the loan amount, the loan would have a negative interest rate, which does not happen with ordinary loans. Check that the payment, the term and the payment frequency match the offer.
How do I include loan fees in the rate?
Subtract upfront fees from the loan amount and keep the payment unchanged. You pay the same installments for less money in hand, so the rate rises, and the result approximates the APR that lenders must disclose in many countries.
Link with your values
Add these parameters to this page’s address to open it with the values filled in, for example to share a calculation or to link to it from an AI assistant. The result is calculated in the browser: the page HTML shows an example for the default values, and the tool sets the data-url-params attribute once the link’s values are applied.
| Parameter | Value | If omitted |
|---|---|---|
currency | ISO 4217 code, for example USD or EUR | your saved or detected currency |
modeSolve for | one of: loan, savings | default loan |
frequencyPayment frequency | one of: annually, semiannually, quarterly, monthly, biweekly, weekly | default monthly |
loan_amountLoan amount | amount without a currency symbol; allowed > 0 – 10000000000; used with mode = loan | required |
payment_per_periodPayment | amount without a currency symbol; allowed > 0 – 10000000000; used with mode = loan | required |
term_yearsTerm | number; any unit in the name: _months, _years; allowed > 0 – 50 years; used with mode = loan | required |
starting_amountStarting amount | amount without a currency symbol; allowed 0–10000000000; used with mode = savings | optional |
deposit_per_periodDeposit each period | amount without a currency symbol; allowed 0–10000000000; used with mode = savings | optional |
goalGoal | amount without a currency symbol; allowed > 0 – 10000000000; used with mode = savings | required |
yearsYears | number; allowed > 0 – 50; used with mode = savings | required |
Examples
?loan_amount=18000&payment_per_period=350&term_years=5?currency=EUR&mode=savings&starting_amount=5000&deposit_per_period=250&goal=60000&years=12&frequency=monthly
Write decimals with a point. Encode a space as %20, + as %2B, # as %23 and & as %26.
Result elements: [data-result-block="interest_rate_calculator"]