How To Calculate Monthly Interest for Loans, Bank Accounts, and More (2024)

Calculating interest month-by-month is an essential skill. You often see interest rates quoted asan annualized percentage—either an annual percentage yield (APY) or an annual percentage rate (APR)—but it’s helpful to know exactly how much that adds up to in dollars and cents. We commonly think in terms of monthly costs.

For example, you have monthly utility bills, food costs, or a car payment. Interest is also a monthly (if not daily) event, and those recurring interest calculations add up to big numbers over the course of a year. Whether you’re paying interest on a loan or earning interest in a savings account, the process of converting from an annual rate (APY or APR) to a monthly interest rate is the same.

Monthly Interest Rate Calculation Example

To calculate a monthly interest rate, divide the annual rate by 12 to reflect the 12 months in the year. You'll need to convert from percentage to decimal formatto complete these steps.

Example: Assume you have an APY or APR of 10%. What is your monthly interest rate, and how much would you pay or earn on $2,000?

  1. Convert the annual rate from a percent to a decimal by dividing by 100: 10/100 = 0.10
  2. Now divide that number by 12 to get the monthly interest rate in decimal form: 0.10/12 = 0.0083
  3. To calculate the monthly interest on $2,000, multiply that number by the total amount: 0.0083 x $2,000 = $16.60 per month
  4. Convert the monthly rate in decimal format back to a percentage (by multiplying by 100): 0.0083 x 100 = 0.83%
  5. Your monthly interest rate is 0.83%

Want a spreadsheet with this example filled in for you? See the​ freeMonthly Interest Example spreadsheet, and make a copy of the sheet to use with your own numbers. The example above is the simplest way to calculate monthly interest rates and costsfor a single month.

You can calculate interest for months, days, years, or any other period. Whatever period you choose, the rate you use in calculations is called the periodic interest rate. You’ll most often see rates quoted in terms of an annual rate, so you typically need to convert to whatever periodic rate matches your question or your financial product.

Note

You can use the same interest rate calculation concept with other time periods:

  • For a daily interest rate, divide the annual rate by 360 (or 365, depending on your bank).
  • For a quarterly rate, divide the annual rate by four.
  • For a weekly rate, divide the annual rate by 52.

Amortization

With many loans, your loan balance changes every month. For example, on auto, home, and personal loans, you gradually pay down your balance over time, and you usually end up with a lower balance each month.

That process is called amortization, and an amortization table helps you calculate (and shows you) exactly how much interest you pay every month.

Over time, your monthly interest costs decrease—and the amount that goes toward your loan balanceincreases.

Home Loans and Credit Cards

Home loans can be complicated. It is smart to use an amortization schedule to understand your interest costs, but you may need to do extra work to figure out your actual rate. You can use our mortgage calculator (below) to see how your principal payment, interest charges, taxes, and insurance add up to your monthly mortgage payment.

You might know the annual percentage rate (APR) on your mortgage, and keep in mind that APR can contain additional costsbesides interest charges(such as closing costs). Also, the rate on adjustable-rate mortgages can change.

With credit cards,you can add new charges and pay off debt numerous times throughout the month. All of that activity makes calculations more cumbersome, but it’s still worth knowing how your monthly interest adds up. In many cases, you can use anaverage daily balance, which is the sum of each day’s balance divided by the number of days in each month (and the finance charge is calculated using the average daily balance). In other cases, your card issuer charges interest daily (so you'd want to calculate a daily interest rate—not a monthly rate).

Interest Rates and APY

Note

Be sure to use the interestratein your calculations—not theannual percentage yield.

The APY accounts for compounding, which is the interest you earn as your account grows due to interest payments. APY will be higher than your actual rate unless the interest is compounded annually, so APY can provide an inaccurate result. That said, APY makes it easy to quickly find out how much you’ll earn annually on a savings account with no additions or withdrawals.

Frequently Asked Questions (FAQs)

What is a good interest rate for a credit card?

The average credit card interest rate was 16.17% in February 2022. You can expect to pay a few more points for store credit cards. Business and student credit cards will help you minimize your interest rate.

What is the prime interest rate?

The prime interest rate is what banks charge their best customers. In other words, it's the lowest possible rate on a given day. This rate is typically available only to institutional customers. The average consumer pays the prime rate plus another rate based on their riskiness as a borrower.

How do you reduce your credit card interest rate?

Credit card interest rates may be negotiable, but it's up to the card issuer. A card issuer is more likely to offer a lower rate if you have good credit habits like keeping up with monthly payments.

How To Calculate Monthly Interest for Loans, Bank Accounts, and More (2024)

FAQs

How do you calculate bank loan interest per month? ›

Here is how to use an interest rate calculator in three simple steps:
  1. Step 1: Enter the loan amount you want to avail. ...
  2. EMI = P x R x (1+R)^N / [(1+R)^N-1]
  3. P – Principal loan amount.
  4. R - Rate of interest (monthly)
  5. N – Tenure (months)
  6. A = P (1+RT)
  7. A = P (1 + r/n) ^ nt.

What is the formula for the monthly loan payment with interest? ›

So, to get your monthly loan payment, you must divide your interest rate by 12. Whatever figure you get, multiply it by your principal. A simpler way to look at it is monthly payment = principal x (interest rate / 12).

How do you calculate interest on a loan with monthly payments? ›

Divide your interest rate by the number of payments you'll make that year. If you have a 6 percent interest rate and you make monthly payments, you would divide 0.06 by 12 to get 0.005. Multiply that number by your remaining loan balance to find out how much you'll pay in interest that month.

What is the formula to calculate interest rates on a bank loan? ›

To calculate simple interest on a loan, multiply the principal (P) by the interest rate (R) by the loan term in years (T), then divide the total by 100. To use this formula, make sure you're expressing your interest rate as a percentage, not a decimal (i.e., a rate of 4% would go into the formula as 4, not 0.04).

What is the formula for simple interest? ›

Simple interest is calculated with the following formula: S.I. = (P × R × T)/100, where P = Principal, R = Rate of Interest in % per annum, and T = Time, usually calculated as the number of years. The rate of interest is in percentage R% (and is to be written as R/100, thus 100 in the formula).

What is the loan payment formula? ›

Monthly Payment = (P × r) ∕ n

Again, “P” represents your principal amount, and “r” is your APR. However, “n” in this equation is the number of payments you'll make over a year. Now for an example. Let's say you get an interest-only personal loan for $10,000 with an APR of 3.5% and a 60-month repayment term.

How much is the monthly payment on a 25k loan? ›

The monthly payment on a $25,000 loan ranges from $342 to $2,512, depending on the APR and how long the loan lasts. For example, if you take out a $25,000 loan for one year with an APR of 36%, your monthly payment will be $2,512.

How is interest calculated daily on a loan? ›

Multiply your principal balance by your interest rate. Divide your answer by 365 days (366 days in a leap year) to find your daily interest accrual or your per diem.

Top Articles
Latest Posts
Article information

Author: Errol Quitzon

Last Updated:

Views: 6310

Rating: 4.9 / 5 (59 voted)

Reviews: 82% of readers found this page helpful

Author information

Name: Errol Quitzon

Birthday: 1993-04-02

Address: 70604 Haley Lane, Port Weldonside, TN 99233-0942

Phone: +9665282866296

Job: Product Retail Agent

Hobby: Computer programming, Horseback riding, Hooping, Dance, Ice skating, Backpacking, Rafting

Introduction: My name is Errol Quitzon, I am a fair, cute, fancy, clean, attractive, sparkling, kind person who loves writing and wants to share my knowledge and understanding with you.