An amortization schedule by month shows how each loan payment is divided between interest and principal, along with the balance remaining after each payment. Enter the loan amount, APR, and term to calculate the monthly payment and total interest; a full month-by-month schedule can then be built using the same payment and balance formulas.
Formula
For a fixed-rate loan with equal monthly payments, the payment is calculated as:
Payment = round[P × r ÷ (1 − (1 + r)−n), 2]
- P is the starting loan principal, in dollars.
- r is the monthly interest rate as a decimal: APR ÷ 1200. For an 8% APR, r = 0.08 ÷ 12.
- n is the number of monthly payments: term in years × 12.
- Payment is the scheduled monthly amount, rounded to cents.
For each month, calculate interest on the balance at the start of that period: monthly interest = starting balance × r. The principal portion is payment − monthly interest, and the new balance is starting balance − principal portion. Equivalently, the balance after k payments is P × (1 + r)k − Payment × ((1 + r)k − 1) ÷ r.
Worked Example
Using the calculator’s default inputs—$20,000 principal, 8% APR, and a five-year term—there are 5 × 12 = 60 monthly payments. The monthly rate is 8 ÷ 1200 = 0.0066667.
- Substitute into the payment formula: $20,000 × 0.0066667 ÷ [1 − (1 + 0.0066667)−60].
- Round the result to cents: the scheduled payment is $405.53 per month.
- The first month’s interest is $20,000 × 0.0066667 = $133.33. Principal paid is $405.53 − $133.33 = $272.20, leaving a balance of $19,727.80.
- Using the rounded payment, total scheduled payments are $405.53 × 60 = $24,331.80. Subtracting the original principal gives estimated total interest of $4,331.80.
The first row of a monthly schedule would therefore show a $405.53 payment, about $133.33 in interest, $272.20 in principal, and a $19,727.80 ending balance. Later rows repeat the calculation using each new starting balance. Values may differ slightly from a lender’s final schedule if the lender adjusts the last payment or uses different day-count or rounding practices.
Assumptions
- The interest rate is fixed for the whole modeled term.
- Payments are equal monthly payments made at the end of each monthly period.
- Interest accrues monthly at APR ÷ 12, with no separate daily accrual calculation.
- Fees, taxes, insurance, PMI, escrow, and irregular charges are not included.
How to Read a Monthly Schedule
A typical schedule has columns for payment number or date, beginning balance, payment, interest, principal, and ending balance. The beginning balance in one row becomes the ending balance in the prior row. At first, interest is a larger share of a level payment because the amount owed is larger. As the balance declines, the interest charge generally falls and more of the same payment goes to principal.
To construct a schedule, repeat these steps for each month:
- Multiply the current balance by the monthly rate to find that month’s interest.
- Subtract that interest from the scheduled payment to find principal repaid.
- Subtract principal repaid from the current balance to get the next balance.
- Continue until the balance is paid, checking the final row for a small rounding adjustment.
Do not confuse total interest with the monthly payment. Total interest is the sum of the interest amounts across the schedule; total payments include both principal and interest. In the example, $24,331.80 in scheduled payments consists of $20,000 principal plus $4,331.80 interest.
When This Estimate Is Useful
A monthly amortization schedule helps explain how a fixed-payment loan declines over time. It can show the approximate balance after a selected number of payments, how much interest is paid early in the term, and the overall interest implied by the entered principal, APR, and term. It is also a way to check the arithmetic of a quoted payment, provided the quote uses the same assumptions and excludes the same charges.
This calculator gives the payment, total interest, and first payment’s ending balance. To create later rows, apply the monthly steps above or use the balance formula with k set to the number of completed payments. For example, k = 12 represents the balance after 12 scheduled payments, not the balance at the end of the twelfth calendar month if payments were delayed or dates were irregular.
Common Issues and Limits
- APR is not entered as a decimal. Enter 8 for 8%, not 0.08; the formula converts the annual percentage to a monthly decimal.
- Term units matter. This calculator takes years, then multiplies by 12. A five-year term means 60 payments.
- Rounding changes totals. The example uses a payment rounded to cents and multiplies that amount by the number of payments. A lender may calculate with more precision internally and adjust the last installment.
- Variable rates do not follow one fixed schedule. If the rate changes, future interest and payments or payoff timing may change according to the loan terms.
- Extra payments are not modeled. Additional principal payments can change the balance path and may affect payoff timing or charges under the loan agreement.
The calculation assumes the same monthly period throughout. Real billing dates, payment processing, accrued interest, fees, and lender-specific rules can make an issued statement differ from this simplified estimate.
Frequently Asked Questions
How do I calculate monthly interest on an amortized loan?
Multiply the balance at the start of the month by the monthly rate. For an APR stated as a percentage, the monthly decimal rate is APR ÷ 1200.
Why does the principal portion increase each month?
With a fixed rate and level payment, the balance usually declines after each payment. That makes the next month’s interest charge smaller, leaving more of the payment to reduce principal.
Does an amortization schedule include taxes and insurance?
Not in this calculation. It models principal and interest only; taxes, insurance, escrow, PMI, and fees require separate figures and may be handled differently by a lender.
How can I find the balance after a certain number of months?
Use the balance formula with k equal to the number of completed payments, or calculate each monthly row in sequence. The result assumes payments were made as scheduled.
Why might my lender’s payment or final balance differ?
Possible reasons include fees, payment timing, daily interest accrual, rate changes, unmodeled charges, and rounding conventions. Check the lender’s disclosure and payment schedule for the contract-specific figures.
This result is an estimate for educational purposes, and the lender’s disclosure gives the exact figures.
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 | $ | round(p * (apr / 1200) / (1 - (1 + apr / 1200) ^ -(yrs * 12)), 2) | 2 out int | Total interest | $ | pmt * yrs * 12 - p | 2 out bal | Balance after first payment | $ | p * (1 + apr / 1200) - pmt | 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
- Amortization Schedule by Hand: Formula and Example$405.53
- Amortization Schedule Based on Payment Amount$405.53
- Amortization Schedule Calculator: Payments and Balance$405.53
- Auto Loan Amortization Schedule Calculator$405.53
- Adjustable Rate Amortization Schedule Calculator$405.53
- Amortization Schedule: Annual Payments in Excel$5,009.13