calculate-loan

01 Loan payments

Interest-Only Loan Payment Calculator Excel

Calculator No. 01-22035 · Updated · Formula and assumptions shown below

Monthly payment $133.33
Total interest
$8,000.00
= Monthly payment × loan term × 12
Loan amount
$20,000
Input
Interest rate (APR)
8 %
Input
You enter
Loan amount ($), Interest rate (APR) (%), Loan term (years)
You get
Monthly payment ($), Total interest ($)
Rounding
2 dp

Estimate for education, not financial advice. The result follows from the numbers you enter and the formula shown. It is not a quote or an offer, and it does not include fees, taxes or insurance unless the calculator asks for them. Ask your lender for the exact figures.

This calculator works out the monthly payment for an interest-only loan, where you pay only the interest each month and the principal stays the same. You enter the loan amount, annual interest rate (APR), and loan term, and it returns the monthly interest payment and the total interest paid over the term. It is the same math you would build in an Excel spreadsheet, so you can use this page to check your own formulas.

Formula

The interest-only payment formula is simple:

Monthly payment = Loan amount × (Annual interest rate / 12)

In symbols: PMT = P × (r / 12), where:

  • P = loan amount (principal) in dollars
  • r = annual interest rate as a percentage (APR), e.g., 8 means 8% per year
  • PMT = monthly interest payment in dollars

The total interest over the term is simply that monthly payment multiplied by the number of months: Total interest = PMT × (years × 12).

Notice there is no compounding in the payment itself—you are not paying down principal, so the payment stays constant for the whole interest-only period. The rate is divided by 12 because interest is charged monthly, and the result is rounded to the nearest cent.

Worked Example

Using the default values from the calculator: loan amount = $20,000, APR = 8%, term = 5 years.

  1. Convert the annual rate to a monthly rate: 8% / 12 = 0.6666667% per month.
  2. As a decimal for the formula: 0.08 / 12 = 0.006666667.
  3. Monthly payment = $20,000 × 0.006666667 = $133.3333, which rounds to $133.33.
  4. Total interest = $133.33 × (5 × 12) = $133.33 × 60 = $7,999.80.

The calculator shows exactly that: monthly payment $133.33 and total interest $7,999.80. The slight difference from $20,000 × 8% × 5 = $8,000 is due to rounding the monthly payment to the cent.

Assumptions

  • The interest rate is fixed for the entire term.
  • Payments are made at the end of each month.
  • Interest is calculated monthly at APR / 12 (simple monthly interest, no intra-month compounding).
  • The loan amount does not change—no principal is repaid during the interest-only period.
  • This calculator does not include fees, taxes, insurance, or any principal repayment. It also does not model a later amortization phase, where you would start paying principal.

How to Build This in Excel

You can replicate this calculator in Excel in a few steps. The key is to use the same formula, but be careful with cell references and percentage formatting.

  1. In cell A1, enter the loan amount (e.g., 20000).
  2. In cell A2, enter the annual interest rate as a percentage (e.g., 8%). If you format the cell as a percentage, Excel stores 0.08; if you enter 8 as a plain number, you must divide by 100 in the formula.
  3. In cell A3, enter the loan term in years (e.g., 5).
  4. In cell A4, enter the formula: =A1*(A2/12) if A2 is a percentage (0.08). If A2 is 8 (plain number), use =A1*(A2/100/12).
  5. In cell A5, enter the total interest: =A4*(A3*12).

The most common mistake is mixing up the percentage format. If you type 8% in Excel, it displays 8% but the underlying value is 0.08. If you type 8 and then multiply by A1/12, you get 8 times the loan amount, which is wrong. Always test with a simple example: a $10,000 loan at 12% should give a monthly payment of $100 (since 12% per year = 1% per month).

When to Use an Interest-Only Payment Calculator

Interest-only loans are common for certain mortgages (often for a set period, like 5 or 10 years), construction loans, and some business or bridge financing. During the interest-only period, your monthly payment is lower than a fully amortizing loan because you are not paying any principal. This calculator is useful for:

  • Comparing the cash-flow difference between an interest-only payment and a fully amortizing payment.
  • Estimating how much interest you would pay during the interest-only phase.
  • Understanding how much of your payment goes to interest versus principal (here, all of it goes to interest).
  • Planning for a future when principal payments begin—your payment will increase significantly.

However, because you are not reducing the principal, you will not build equity during the interest-only period. If the property value falls, you could owe more than the property is worth. This is a risk to consider, but this calculator only shows the payment arithmetic; it does not assess risk.

Common Mistakes and Misconceptions

One common mistake is thinking that the interest-only payment is the same as the payment on a standard loan. For a $20,000 loan at 8% for 5 years, the fully amortizing payment would be about $405.53 per month, while the interest-only payment is $133.33. The difference is significant because the amortizing payment includes principal.

Another misconception is that the total interest shown here is the total cost of the loan. It is only the interest during the interest-only period. If the loan later converts to amortizing, you will pay additional interest on the remaining principal. Also, some loans have a balloon payment at the end, meaning you must repay the entire principal in one lump sum. This calculator does not show that balloon payment.

Also, be careful with the loan term input. Some interest-only periods are shorter than the full loan term. For example, a 30-year mortgage might have a 5-year interest-only period. Here, you should enter the length of the interest-only period (5 years), not the full 30-year term, because the payment formula only applies during the interest-only phase.

Comparing Interest-Only vs. Amortizing Payments

To see the difference, you can use this calculator for the interest-only payment, and a separate amortizing calculator for the standard payment. For the same $20,000 at 8% for 5 years:

  • Interest-only monthly payment: $133.33 (as calculated above).
  • Amortizing monthly payment: $405.53 (using the standard formula).
  • Total interest paid over 5 years: interest-only = $7,999.80; amortizing = $4,331.74 (approximately).

The interest-only option has lower monthly payments but higher total interest because you never reduce the principal. The amortizing option costs more each month but builds equity and reduces total interest. Neither is inherently better; it depends on your cash flow needs and how long you plan to keep the loan.

Limits of This Calculator

This calculator is intentionally simple. It does not account for:

  • Adjustable interest rates that change over time.
  • Fees, points, or closing costs that affect the effective rate.
  • Tax deductions or benefits (which vary by jurisdiction).
  • Prepayment penalties or extra payments.
  • The amortization phase after the interest-only period ends.
  • Any balloon payment due at maturity.

For a complete picture, you would need a full loan amortization schedule that includes the interest-only period and the subsequent repayment period. Also, the interest rate you enter should be the actual APR from your lender, not a rate you hope to get. Lenders determine your rate based on credit, market conditions, and loan type, and those factors are not part of this calculator.

Frequently Asked Questions

How do I calculate interest-only payments in Excel?

In Excel, use the formula =loan_amount * (annual_rate/12). For example, if the loan amount is in A1 and the annual rate (as a percentage, like 8%) is in A2, the monthly payment is =A1*(A2/12). If A2 is a plain number like 8, use =A1*(A2/100/12). Then multiply by the number of months for total interest.

What is the difference between interest-only and amortizing loans?

With an interest-only loan, your monthly payment covers only the interest, so the principal stays the same. With an amortizing loan, each payment includes interest plus a portion of principal, so the balance decreases over time. Interest-only payments are lower initially, but you pay more total interest and do not build equity.

Can I use this calculator for a mortgage?

Yes, but only for the interest-only period. Many mortgages have an interest-only option for the first few years (e.g., 5 or 10 years). Enter the loan amount, the annual interest rate, and the number of years of the interest-only period. The result is your monthly payment during that period, not for the entire mortgage.

What happens after the interest-only period ends?

Typically, the loan converts to a fully amortizing loan, and your monthly payment increases significantly because you start paying principal. Some loans require a balloon payment, where you must pay off the entire remaining principal at once. Check your loan agreement for the exact terms.

Is an interest-only loan a good idea?

It depends on your financial situation and goals. Interest-only loans can be useful for short-term financing or if you expect your income to increase. However, they are riskier because you do not build equity and may face higher payments later. This calculator only shows the payment math; it is not financial advice. Always consult a financial professional for advice tailored to your situation.

The result from this calculator is an estimate based on the inputs you provide. Your lender’s official loan disclosure will show the exact payment, interest rate, and terms.

Related

Formula used
in p | Loan amount | $ | 20000 | 1 | 100000000
in apr | Interest rate (APR) | % | 8 | 0.01 | 100
in yrs | Loan term | years | 5 | 0.0833 | 50
out pmt | Monthly payment | $ | p * (apr / 1200) | 2
out int | Total interest | $ | pmt * yrs * 12 | 2

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard loan formula for this calculation, fixed rate and monthly compounding unless stated, rounded as each result states. Not financial advice; no lender, rate or product is recommended. See formulas and assumptions, the disclaimer or report an error.

More in this section

The whole Loan payments section →