A loan principal and interest schedule, also called an amortization schedule, is a table that shows each monthly payment split into the amount that goes toward the original loan balance (principal) and the amount that goes to the lender as the cost of borrowing (interest). You enter the loan amount, the annual interest rate, and the loan term, and the schedule lists every payment, the principal and interest portions, and the remaining balance after each payment.
Formula
The level monthly payment is calculated with the standard amortization formula:
M = P × (r × (1 + r)^n) / ((1 + r)^n – 1)
Where:
- M = monthly payment (in $)
- P = principal loan amount (in $)
- r = monthly interest rate = annual rate (APR) ÷ 12 ÷ 100 (as a decimal)
- n = total number of monthly payments = term in years × 12
For each payment, the interest portion is current balance × r, and the principal portion is M – interest. The new balance is the old balance minus the principal portion.
Worked Example
Using the default values from the calculator: loan amount $20,000, APR 8%, term 5 years.
- Monthly rate: r = 8 / 1200 = 0.0066667
- Number of payments: n = 5 × 12 = 60
- Payment: M = 20000 × (0.0066667 × (1.0066667)^60) / ((1.0066667)^60 – 1) = $405.53
- Total paid: 60 × 405.53 = $24,331.80
- Total interest: 24,331.80 – 20,000 = $4,331.80
The first payment’s interest is 20000 × 0.0066667 = $133.33, so the principal portion is 405.53 – 133.33 = $272.20, leaving a balance of $19,727.80. Each subsequent payment has a slightly lower interest portion and higher principal portion.
Assumptions
- Fixed interest rate for the entire term
- Payments are made at the end of each month
- Interest compounds monthly at the APR divided by 12
- No fees, taxes, insurance, PMI, or escrow are included
- No extra payments or prepayment penalties are considered
How the Schedule Works
In the early months, most of your payment goes to interest because the balance is highest. As you pay down the principal, the interest charge shrinks, so a larger share of the same payment goes to principal. This is called amortization. The total payment stays the same for a fixed-rate loan, but the internal split changes every month.
For example, with the $20,000 loan above, the 30th payment (halfway) has interest of about $70 and principal of about $335. The last payment has interest of only a few dollars and principal of nearly the full $405.53.
How to Read the Schedule
Each row of an amortization schedule shows:
- Payment number (1 to n)
- Payment amount (constant)
- Interest portion (decreases over time)
- Principal portion (increases over time)
- Remaining balance after payment (decreases to zero)
The schedule helps you see exactly how much interest you pay over the life of the loan and when your equity (ownership) grows. It also shows that making extra principal payments early saves more interest than doing so later.
Common Mistakes and Misconceptions
One common mistake is using the annual rate directly in the monthly formula. Always divide by 12. Another is rounding the payment too early—if you round to the nearest dollar, the final balance may not be zero. Use the exact payment to two decimals.
A frequent misconception is that the interest portion is simply the APR times the original loan amount each year. In reality, interest is recalculated on the remaining balance each month, so total interest is much less than that simple estimate.
Another error is confusing APR with the nominal rate. APR includes some fees, but the schedule here uses the interest rate only. If your loan has origination fees, the true cost may be slightly higher.
How to Choose a Loan Term
Shorter terms (e.g., 3 years vs. 5 years) have higher monthly payments but much lower total interest. Longer terms lower the monthly payment but increase total interest. Use the schedule to compare the total interest across different terms before deciding what fits your budget.
For the same $20,000 at 8%:
- 3-year term: payment $626.73, total interest $2,562.28
- 5-year term: payment $405.53, total interest $4,331.80
- 7-year term: payment $311.24, total interest $6,144.16
Notice the trade-off: a 2-year extension costs about $1,770 more in interest but reduces the payment by about $94 per month.
Extra Payments and Payoff
Making an extra principal payment reduces the balance faster, which shortens the term and lowers total interest. For example, paying an extra $50 per month on the $20,000 loan above would pay it off in about 55 months instead of 60 and save roughly $400 in interest.
To calculate the new term with extra payments, you can use a payoff calculator or adjust the formula. The general rule is: the earlier you make extra payments, the more interest you save because the balance is higher.
Frequently Asked Questions
What is the difference between principal and interest?
Principal is the original amount you borrowed. Interest is the fee the lender charges for lending you that money, calculated as a percentage of the remaining balance. Your monthly payment is the sum of both parts.
Why is the interest portion higher at the start?
Because interest is calculated on the current balance, which is largest at the beginning. As you pay down principal, the balance shrinks, so the interest charge decreases and more of your payment goes toward principal.
Can I change the schedule by paying extra?
Yes, any extra payment applied to principal will reduce the balance faster, shortening the loan term and reducing total interest. The schedule recalculates based on the new balance and remaining term.
Is the monthly payment always the same?
For a fixed-rate loan, yes, the payment amount is constant. For an adjustable-rate loan, the payment can change when the rate resets. The schedule shown here assumes a fixed rate.
Does the schedule include taxes and insurance?
No. The schedule only covers principal and interest. If your lender collects property taxes and insurance in an escrow account, those are added to your monthly payment but are not part of the loan amortization.
What happens if I miss a payment?
Missing a payment typically triggers a late fee and can affect your credit score. The interest continues to accrue on the unpaid balance, and the loan may go into default. Contact your lender immediately if you anticipate a missed payment.
This schedule is an estimate based on the inputs you provide; your lender’s official disclosure will show the exact payment and amortization for your specific 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
- Personal Loans Interest Free? The Real Answer$405.53
- Personal Loan 0% Interest: Is It Real?$405.53
- Personal Loan Zero Interest: Is It Real?$405.53
- Only Loans LLC: What It Is and How It Works$405.53
- Personal Loan and Interest Only Option?$133.33
- No Interest Personal Loan? What It Really Means$405.53