Loan Amortization Calculator — Full Payment Schedule
Generate a full amortization schedule for any loan, showing principal, interest, and remaining balance for every payment.
Reviewed for accuracy by Manoj Kumar, Mathematics Educator
Loan Amortization Calculator — Full Payment Schedule
Calculator
Adjust values & calculateEnter your values below. Every result is computed in your browser — no data is sent to any server.
Formula: M = P x r(1+r)^n / ((1+r)^n - 1)
Worked example — Monthly Payment: $1,799 | Total Interest: $347,515 | Total Paid: $647,515
Formula
M = P x r(1+r)^n / ((1+r)^n - 1)
Where M = monthly payment, P = principal loan amount, r = monthly interest rate (annual rate / 12), and n = total number of payments. Each payment splits between interest (balance x rate) and principal (payment minus interest). Extra payments reduce principal directly, saving future interest.
Worked Examples
Example 1: Standard 30-Year Mortgage
Problem:Calculate the monthly payment and total interest on a $300,000 mortgage at 6% for 30 years.
Solution:Monthly rate r = 0.06/12 = 0.005, periods n = 360 M = 300,000 x 0.005(1.005)^360 / ((1.005)^360 - 1) M = 300,000 x 0.005 x 6.02258 / (6.02258 - 1) M = 300,000 x 0.030113 / 5.02258 M = $1,798.65 per month Total paid = $1,798.65 x 360 = $647,515 Total interest = $647,515 - $300,000 = $347,515
Result:Monthly Payment: $1,799 | Total Interest: $347,515 | Total Paid: $647,515
Example 2: Impact of Extra $200/Month
Problem:Same $300,000 loan at 6% for 30 years, but adding $200/month extra toward principal.
Solution:Base monthly payment: $1,798.65 With $200 extra: $1,998.65/month The extra $200 goes entirely to principal each month New payoff time: approximately 303 months (25.25 years) Total interest with extra payments: $282,744 Interest saved: $347,515 - $282,744 = $64,771 Months saved: 360 - 303 = 57 months (4.75 years)
Result:Saves $64,771 in interest | Pays off 4.75 years early | 57 fewer payments
Frequently Asked Questions
What is loan amortization and how does it work?
Loan amortization is the process of paying off a loan through regular scheduled payments that cover both principal and interest over a set period. Each payment is divided into two parts: the interest portion calculated on the remaining balance, and the principal portion that reduces the outstanding debt. In the early years, most of each payment goes toward interest because the balance is highest. As the balance decreases over time, more of each payment applies to principal. This gradual shift is what creates the classic amortization curve. Understanding this process helps borrowers see how much of their money goes to interest versus actually paying down the loan.
How is the monthly payment on an amortized loan calculated?
The monthly payment is calculated using the formula M = P x r(1+r)^n / ((1+r)^n - 1), where P is the principal loan amount, r is the monthly interest rate (annual rate divided by 12), and n is the total number of monthly payments. This formula ensures that each equal payment covers the interest due and progressively pays down principal so the loan reaches zero at the end of the term. For a $250,000 loan at 6.5% over 30 years, the monthly payment would be $1,580. The formula comes from setting the present value of all future payments equal to the initial loan amount.
How do extra payments affect my loan payoff?
Extra payments go entirely toward reducing the principal balance, which has a powerful compounding effect. By lowering the principal faster, you reduce the interest charged in every subsequent month, creating a snowball effect. Even an extra $100 per month on a $250,000 mortgage at 6.5% can save you over $50,000 in interest and shave nearly 5 years off a 30-year loan. The key is that extra payments eliminate future interest that would have been charged on that principal amount for the remaining life of the loan. Making extra payments early in the loan term has the greatest impact because there are more remaining years for the savings to compound.
What is the difference between a 15-year and 30-year mortgage?
A 15-year mortgage has higher monthly payments but saves dramatically on total interest paid. For a $300,000 loan at 6%, the 30-year payment is $1,799 with $347,515 total interest, while the 15-year payment is $2,532 with $155,683 total interest. That means the 15-year option saves $191,832 in interest despite only $733 more per month. Additionally, 15-year mortgages typically come with lower interest rates, usually 0.5% to 0.75% less than 30-year rates, which increases the savings further. The tradeoff is reduced cash flow flexibility and the opportunity cost of not investing the payment difference.
What happens to the interest-to-principal ratio over the life of a loan?
The interest-to-principal ratio shifts dramatically throughout the loan term, following a pattern that surprises many borrowers. In the first year of a 30-year mortgage at 6%, approximately 80% of each payment goes to interest and only 20% to principal. By the halfway point around year 15, the split is roughly 50/50. In the final years, nearly all of each payment goes to principal. This front-loading of interest is why refinancing after many years of payments may not save as much as expected, since you would restart the amortization schedule. It also explains why extra payments in the early years have the most dramatic effect on total interest savings.
Should I refinance my mortgage to get a lower rate?
Refinancing can be beneficial when rates drop significantly, but several factors must be considered. The general rule of thumb is that refinancing makes sense if you can reduce your rate by at least 0.75% to 1% and plan to stay in the home long enough to recoup closing costs. Calculate your break-even point by dividing total closing costs (typically 2-5% of the loan amount) by the monthly payment savings. If you plan to stay beyond that break-even point, refinancing likely makes sense. Also consider how far into your current loan you are, since refinancing restarts amortization and you may end up paying more total interest despite a lower rate.
How does an amortization schedule help with financial planning?
An amortization schedule provides a complete roadmap of your loan, showing exactly how much goes to principal and interest each month for the entire loan term. This transparency enables several planning strategies. You can see how much equity you will have at any future point, which is important for home equity loans or selling decisions. You can calculate the impact of extra payments before committing to them. Tax planners use the schedule to project mortgage interest deductions for future years. It also helps compare different loan options side by side, revealing the true cost differences that are not apparent from just looking at monthly payments.
What is negative amortization and when does it occur?
Negative amortization occurs when monthly payments are insufficient to cover the interest due, causing the unpaid interest to be added to the loan balance. This means you actually owe more over time instead of less. It commonly happens with certain adjustable-rate mortgages (ARMs) that offer artificially low initial payments, payment-option loans, or income-driven student loan repayment plans. For example, if interest due is $1,500 per month but the minimum payment is only $1,200, then $300 gets added to your balance each month. Negative amortization is generally considered risky because borrowers can end up owing significantly more than their property is worth, especially in declining markets.
How do adjustable-rate mortgages affect amortization?
Adjustable-rate mortgages (ARMs) complicate amortization because the interest rate changes at predetermined intervals after an initial fixed-rate period. When rates adjust, the payment amount is recalculated based on the remaining balance, new rate, and remaining term. If rates increase, payments go up and a larger portion goes to interest, slowing principal paydown. If rates decrease, payments may drop and more goes to principal. Most ARMs have caps limiting how much the rate can increase per adjustment period and over the loan lifetime. When analyzing ARM amortization, it is crucial to model different rate scenarios to understand the range of possible outcomes and plan accordingly.
What are the tax implications of loan amortization?
For mortgage loans on primary and secondary residences, the interest portion of your payment is generally tax-deductible up to certain limits established by tax law. Since amortization front-loads interest in early years, the tax benefit is greatest when the loan is new and decreases over time. The 2017 Tax Cuts and Jobs Act limited the mortgage interest deduction to interest on up to $750,000 of mortgage debt for loans taken after December 15, 2017. For investment property loans, interest is deductible as a business expense regardless of amount. Student loan interest has separate deduction rules with income phase-outs. Understanding these tax implications helps calculate the true after-tax cost of borrowing.
References
Reviewed for accuracy by Manoj Kumar, Mathematics Educator · Editorial policy
Related Calculators
🧮Associative Property Calculator
Calculate associative property with inputs, formulas, and instant results.
🧮Distributive Property Calculator
Calculate distributive property with inputs, formulas, and instant results.
📈Compound Interest
See how your money grows over time with compound interest
🏠Mortgage Calculator
Calculate your monthly mortgage payment with taxes and insurance
💳Debt Payoff
Create a debt payoff plan
🧮Annulus Area Calculator
Calculate annulus area with inputs, formulas, and instant results.
🧮Area Calculator
Calculate area with inputs, formulas, and instant results.
🧮Area of a Rectangle Calculator
Calculate the area, perimeter, and diagonal of a rectangle. Find missing sides from known area. Convert between metric and imperial area units.