calculate-loan

01 Loan payments

Amortization Schedule with Dates and Totals

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

Monthly payment $405.53
Total interest
$4,331.67
= Monthly payment × loan term × 12 − loan amount
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.

An amortization schedule with dates and totals is a table that lists each loan payment by its due date, breaking down how much goes to interest and principal, and showing the remaining balance after every payment. You enter the loan amount, annual interest rate (APR), and term, and the schedule shows the exact payment for each month, the total interest paid over the life of the loan, and the final payoff date.

Formula

The monthly payment for a fixed-rate loan is calculated using the standard amortization formula:

M = P × [r(1 + r)^n] / [(1 + r)^n − 1]

Where:

  • M = monthly payment (in dollars)
  • P = principal loan amount (in dollars)
  • r = monthly interest rate = APR / 12 / 100 (as a decimal)
  • n = total number of payments = years × 12

For each payment period, the interest portion is the current balance times the monthly rate, and the principal portion is the payment minus that interest. The new balance is the old balance minus the principal portion.

Worked Example

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

  1. Monthly rate r = 8 / 1200 = 0.0066667
  2. Number of payments n = 5 × 12 = 60
  3. Payment M = 20000 × (0.0066667 × (1.0066667)^60) / ((1.0066667)^60 − 1)
  4. Compute (1.0066667)^60 ≈ 1.489845
  5. Numerator: 20000 × (0.0066667 × 1.489845) = 20000 × 0.0099323 = 198.646
  6. Denominator: 1.489845 − 1 = 0.489845
  7. M = 198.646 / 0.489845 = 405.53 (rounded to cents)

Total paid = 405.53 × 60 = $24,331.80. Total interest = $24,331.80 − $20,000 = $4,331.80. These match the calculator outputs.

Assumptions

  • Fixed interest rate for the entire term (no adjustable-rate changes).
  • Payments are made monthly at the end of each period.
  • Interest compounds monthly at APR / 12.
  • No fees, taxes, insurance, PMI, or escrow are included.
  • All payments are made on time and in full; no prepayment penalties or extra payments are considered.

How to Read an Amortization Schedule

Each row of a full amortization schedule shows the payment number, the payment date (typically the same day each month after the first payment), the payment amount, the interest portion, the principal portion, and the remaining balance. In the early months, most of the payment goes to interest; as the balance decreases, the interest portion shrinks and the principal portion grows. The final row shows a zero balance on the payoff date. The totals row sums the interest and principal columns—the principal total equals the original loan amount, and the interest total is what you pay over the life of the loan.

Why Dates Matter

Dates affect the schedule because interest accrues daily in most loans, but the standard amortization formula assumes equal monthly periods. In practice, your first payment may be due one full month after the loan funds, but if your closing date is mid-month, the first interest amount may be prorated. Some lenders use a “daily interest” method for the first payment, which can slightly change the first payment amount and the total interest. For a typical schedule, you can generate dates by adding one month to the previous payment date, adjusting for month-end (e.g., Jan 31 → Feb 28).

Common Mistakes and Misconceptions

  • Using APR as a monthly rate: Always divide by 12 and by 100. For 8% APR, the monthly rate is 0.0066667, not 0.08.
  • Rounding the payment too early: If you round the payment to $405.53 but use an unrounded payment in further calculations, the final balance may be off by a few cents. Use the rounded payment for the schedule to match the lender.
  • Ignoring the first payment date: If your first payment is due 45 days after closing, the first interest charge will be higher than the formula predicts.
  • Assuming total interest = payment × term − principal: This is correct only if you make every payment on time and never make extra payments.
  • Thinking the schedule is linear: The principal portion increases exponentially, not linearly, so the balance drops slowly at first and faster later.

Extra Payments and Refinancing

Making extra principal payments shortens the term and reduces total interest, but it does not change your scheduled monthly payment. For example, adding $50 per month to the $405.53 payment on the $20,000 loan at 8% would pay off the loan in about 53 months instead of 60, saving roughly $500 in interest. To see the effect, you would recalculate the schedule with the extra amount applied to principal each month. Refinancing replaces the loan with a new one, often with a new rate and term; the new amortization schedule starts from the remaining balance, not the original amount.

Frequently Asked Questions

How do I get an amortization schedule with exact dates?
Start with your loan funding date and first payment date. Each subsequent payment is due the same day of the month (e.g., the 15th). If the day doesn’t exist in a month (like the 31st), use the last day of that month. The schedule’s last payment date is your payoff date.

Why does my first payment interest differ from the schedule?
Lenders often use a simple daily interest calculation for the first payment period. If your first payment is due more or less than one full month after funding, the interest portion will be adjusted. The standard formula assumes exactly equal months, so your actual first payment may be slightly different.

Can I make an amortization schedule in Excel?
Yes. Use the PMT function to get the payment, then for each row calculate interest = balance × monthly rate, principal = payment − interest, and new balance = balance − principal. Fill down for the number of payments. Add a date column by using EDATE on the previous date.

What happens if I miss a payment?
Missing a payment typically triggers a late fee and may cause interest to accrue on the unpaid amount. The schedule becomes inaccurate because the balance is higher than planned, and future interest charges increase. Contact your lender about forbearance or deferment options.

Does the schedule include taxes and insurance?
No, unless you add them as separate inputs. Property taxes, homeowners insurance, and PMI are usually escrowed and paid separately from the principal and interest. The amortization schedule only covers the loan itself.

How do I calculate total interest for a shorter term?
Use the same formula with a smaller number of payments. For example, a 3-year term on the same $20,000 at 8% gives a payment of $626.73 and total interest of $2,562.28. A shorter term means higher payments but much less total interest.

This calculator provides an estimate; your lender’s amortization disclosure will show the exact figures, including any fees or adjustments.

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 →