Loan Amortization Table for 240 Months

A 240-month loan amortization table shows how each of 240 monthly payments is divided between interest and principal, along with the remaining balance after each payment. Enter the loan amount, annual APR, and term to calculate the fixed monthly payment and total interest; the schedule itself can then be built by applying the same monthly calculation 240 times.

Formula

The calculator uses the standard fixed-payment loan formula. It calculates the monthly payment from the starting principal, monthly interest rate, and number of monthly payments:

Payment = P × r ÷ [1 − (1 + r)⁻ⁿ]

• P is the amount borrowed, in dollars.
• r is the monthly interest rate as a decimal: annual APR ÷ 1,200.
• n is the number of monthly payments: years × 12.
• Payment is the level monthly payment, in dollars.

Total interest is calculated as (monthly payment × n) − P. For a 240-month schedule, set the term to 20 years, because 20 × 12 = 240. This calculator accepts years, so its output follows the term entered; it does not automatically force every loan to 240 months.

Worked Example

Using the calculator’s default values—$20,000 principal, 8% APR, and 5 years—the example has 60 monthly payments, not 240. It demonstrates the formula; to model 240 months, change the term to 20 years.

1. Convert APR to a monthly decimal rate: 8 ÷ 1,200 = 0.0066667.
2. Find the payment count: 5 × 12 = 60.
3. Apply the formula: $20,000 × 0.0066667 ÷ [1 − (1.0066667)⁻⁶⁰] = approximately $405.53 per month, rounded to cents.
4. Calculate total interest using the rounded payment: $405.53 × 60 − $20,000 = $4,331.80.

The calculator therefore displays a monthly payment of $405.53 and total interest of $4,331.80 for its defaults. Those figures use the rounded monthly payment, as the total-interest expression specifies.

Assumptions

• The interest rate stays fixed for the full term.
• Payments are level monthly payments made at the end of each monthly period.
• Interest is calculated monthly at APR ÷ 12.
• Fees, taxes, insurance, PMI, escrow, and other charges are not included.

How a 240-Month Amortization Table Works

Each row in a full table represents one payment period. The interest portion is generally the balance at the start of the month multiplied by the monthly rate. Subtract that interest from the scheduled payment to find the principal portion. Then subtract the principal portion from the opening balance to get the next month’s balance.

For example, with a $200,000 balance and a monthly rate of 0.5%, the first month’s interest is $1,000. If the scheduled payment is $1,432.86, then $432.86 goes toward principal, leaving a balance of $199,567.14. In later months, the balance is lower, so the interest portion usually falls and more of the same payment goes to principal.

A 240-month table contains 240 payment rows plus a starting-balance row. To produce it, repeat the calculation through month 240. Because displayed amounts are rounded to cents, a lender’s final payment can differ slightly from a simple repeated calculation; the lender’s method and exact payment dates determine the actual schedule.

How to Read and Use the Table

For each month, check the opening balance, payment, interest, principal, and closing balance. The closing balance in one row should match the next row’s opening balance, subject to rounding. The last balance should reach zero or be close to it. If it does not, check that the term, APR, payment amount, and rounding method are consistent.

• Opening balance: the amount still owed before that payment.
• Interest: the period’s financing cost under the assumed rate.
• Principal: the amount that reduces the debt.
• Closing balance: the remaining principal after the payment.
• Cumulative interest: interest added across payments so far; it is not the remaining balance.

A 240-month term spreads repayment over 20 years. For the same principal and APR, a longer term generally produces a lower required monthly payment than a shorter term, while the loan remains outstanding longer and the sum of scheduled interest can be greater. The exact difference depends on the inputs; compare calculated schedules rather than assuming a particular saving.

Common Errors and Calculator Limits

A frequent mistake is entering “240” in a years field. Here, 240 months means 20 years; entering 240 years would describe a different term. Another mistake is entering an APR such as 8 as a decimal rate. The input expects 8 for 8%, and the formula converts it to a monthly decimal rate.

This calculator estimates a level-payment loan with a fixed APR and monthly periods. It does not create all 240 row entries, account for variable rates, irregular payment dates, fees, payment holidays, or extra principal payments. If the loan has any of these features, the actual schedule can differ. Obtain the contract’s payment amount and rate details from the lender and use those figures for a closer comparison.

Frequently Asked Questions

How many years is a 240-month loan?
240 months divided by 12 months per year equals 20 years.

How do I calculate a 240-month loan payment?
Use the fixed-payment formula with n = 240 and the monthly rate equal to APR ÷ 1,200. This calculator uses years, so enter 20 for a 240-month term.

Does a 240-month amortization table mean 240 payments?
Usually, it means 240 monthly payment periods. The loan documents determine the actual payment dates and any final-payment adjustment.

Why does the interest portion shrink over time?
With a fixed rate, interest is calculated on the remaining balance. As principal is repaid, that balance falls, so less interest accrues in subsequent periods.

Does the monthly payment include taxes and insurance?
Not in this calculator. It estimates principal and interest only; taxes, insurance, escrow, PMI, and fees are excluded.

The result is an estimate, and the lender’s disclosure gives the exact figures.

Related

• Variable Rate Loan Amortization Table Calculator
• Home Loan Amortization Table: Payments and Balance
• House Amortization Table: Monthly Payment and Balance

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