calculate-loan

01 Loan payments

Projections for Bank Loan: How to Forecast Payments

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

The calculator on this page is switched off while it is checked. The formula is below, and the worked example shows how to do the sum by hand.

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.

Projections for a bank loan estimate your future monthly payments, total interest, and payoff schedule based on the loan amount, interest rate, and term you input. Enter those three figures into the calculator below to see your projected payment and total interest, then read on for how the math works, what affects your projection, and how to use it responsibly.

Formula

The calculator uses the standard level-payment formula for a fixed-rate loan:

Monthly payment = P × (r × (1 + r)^n) / ((1 + r)^n − 1)

Where:

  • P = loan amount (principal) in dollars
  • r = monthly interest rate = annual percentage rate (APR) divided by 12, expressed as a decimal (e.g., 8% APR → 0.08/12 = 0.0066667)
  • n = total number of monthly payments = loan term in years × 12

Total interest = (monthly payment × n) − P. This formula assumes a fixed interest rate for the entire term and that payments are made at the end of each month.

Worked Example

Using the defaults: loan amount $20,000, APR 8%, term 5 years.

  1. Convert APR to monthly rate: r = 8 / 1200 = 0.0066667
  2. Number of payments: n = 5 × 12 = 60
  3. Compute (1 + r)^n = (1.0066667)^60 ≈ 1.48985
  4. Payment = 20000 × (0.0066667 × 1.48985) / (1.48985 − 1) = 20000 × (0.0099323) / 0.48985 ≈ 20000 × 0.020276 = 405.52
  5. Total paid = 405.52 × 60 = 24,331.20
  6. Total interest = 24,331.20 − 20,000 = 4,331.20

The calculator shows a monthly payment of $405.52 and total interest of $4,331.20, matching the example.

Assumptions

  • Fixed interest rate for the entire loan term (no adjustable-rate changes).
  • Payments are made monthly at the end of each period.
  • Interest compounds monthly at APR/12.
  • No fees, closing costs, taxes, insurance, or prepayment penalties are included.

What Affects Your Loan Projection

Three main inputs drive the projection:

  • Loan amount: Higher principal means higher payments and more total interest, all else equal.
  • Interest rate (APR): A higher rate increases both the monthly payment and the total interest paid. Even a 1% difference can add thousands over a long term.
  • Loan term: Longer terms lower the monthly payment but increase total interest because you pay interest for more months. Shorter terms raise the payment but reduce total interest.

For example, a $20,000 loan at 8% for 3 years has a payment of about $626.73 and total interest of $2,562.28, while the same loan for 7 years has a payment of about $311.24 and total interest of $6,144.16. The 7-year loan costs $3,581.88 more in interest.

How to Use the Projection

Use the projection to compare loan offers or to plan your budget. The monthly payment is the key number for your cash flow, but the total interest shows the long-term cost. To see how extra payments change the projection, you would need a more detailed amortization calculator that accounts for prepayment.

Remember that the projection is only as accurate as the inputs. Lenders may quote an APR that includes fees, but the actual payment can differ if fees are financed or if the rate is variable. Always check the lender’s disclosure for the exact figures.

Common Mistakes and Misconceptions

  • Using the nominal rate instead of APR: The APR includes certain fees and reflects the true cost, but the payment formula here uses the APR directly. If you use a nominal rate that excludes fees, the projection will be slightly off.
  • Rounding too early: Rounding the monthly rate to 0.007 instead of 0.0066667 can change the payment by a few cents, which over 60 payments adds up.
  • Ignoring the term length: Some people focus only on the monthly payment and miss that a longer term dramatically increases total interest.
  • Assuming the rate stays constant: For adjustable-rate loans, the projection is only valid until the rate changes. This calculator does not model rate adjustments.

Alternatives to a Fixed-Rate Loan

Not all bank loans are fixed-rate. Common alternatives include:

  • Adjustable-rate loans: The interest rate changes periodically based on an index. Your payment can go up or down, making projections less certain.
  • Interest-only loans: You pay only interest for a set period, then payments increase to cover principal. The early payment is lower, but total interest is higher.
  • Balloon loans: You make small payments for a term, then a large final payment. The projection here does not apply.
  • Lines of credit: You borrow as needed up to a limit, and payments vary with the balance. A fixed payment projection is not meaningful.

For these, you need a different calculation or a lender’s amortization schedule.

Frequently Asked Questions

What is a loan projection?

A loan projection is an estimate of future payments and total costs based on the loan amount, interest rate, and term. It helps you plan your budget and compare offers, but it is not a guarantee because actual terms may vary.

How accurate is this calculator?

It is mathematically exact for a fixed-rate loan with monthly compounding and no fees. Real-world accuracy depends on the lender’s exact APR, any fees, and whether the rate stays fixed. Your lender’s disclosure gives the precise numbers.

Does the projection include taxes and insurance?

No. This calculator only covers principal and interest. For a mortgage, you would add property taxes, homeowners insurance, and possibly PMI. For an auto loan, you might add sales tax and registration fees. Those are separate costs.

Can I use this for an adjustable-rate loan?

Only as a snapshot. The projection is valid for the current rate and term, but it does not predict future rate changes. For an adjustable-rate loan, ask the lender for a projection that shows how payments could change under different rate scenarios.

Why does a longer term mean more total interest?

Because you are borrowing the money for more months, so interest accrues longer. Even though the monthly payment is lower, the total interest paid over the life of the loan is higher. For example, a 5-year loan at 8% on $20,000 costs $4,331 in interest, while a 10-year loan costs about $9,555.

What if I make extra payments?

Extra payments reduce the principal faster, which lowers total interest and shortens the term. This calculator does not model extra payments. Use a loan payoff calculator that includes extra payments to see the effect.

The result is an estimate; your lender’s disclosure provides the exact figures for your loan.

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) / (1 - (1 + apr / 1200) ^ -(yrs * 12)) | 2
out int | Total interest | $ | pmt * yrs * 12 - p | 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 →