Loan Amortization Calculator
Generate a complete loan amortization schedule and loan amortization table — see your monthly payment, total interest, and payoff date for any loan.
Loan Details
Annual Payment Breakdown
Amortization Schedule
Year-by-year breakdown of principal, interest, and remaining balance
| Year | Annual Payment | Principal | Interest | Balance |
|---|
What Is a Loan Amortization Calculator?
A loan amortization calculator is a financial tool that uses the standard amortization formula to compute your fixed monthly payment and generate a complete loan amortization schedule. Enter your loan amount, annual interest rate, and repayment term to instantly see how each payment is divided between principal and interest — and how your balance decreases from the first payment to the last.
Understanding loan amortization is essential for anyone borrowing money. A mortgage, auto loan, student loan, or personal loan all follow the same mathematical structure. This loan amortization schedule calculator works accurately for all of them. Whether you're comparing loan offers or planning your debt payoff, the amortization schedule reveals the true cost of borrowing at every stage.
The Loan Amortization Formula Explained
The loan amortization formula is: M = P × [r(1+r)^n] ÷ [(1+r)^n − 1]
- M = monthly payment
- P = loan principal (amount borrowed)
- r = monthly interest rate (annual rate ÷ 12)
- n = total number of monthly payments (years × 12)
This formula calculates the constant monthly payment that fully repays the loan — covering all interest — by the final payment. Once this payment is known, the full loan amortization schedule is built by iterating: for each period, interest = balance × monthly rate; principal = payment − interest; new balance = old balance − principal. The result is a schedule where every payment is equal, but the interest-to-principal ratio shifts steadily over time.
What Is a Loan Amortization Table?
A loan amortization table displays every payment over the life of the loan in a structured format. Each row shows the payment period, how much went to interest, how much reduced the principal, and the remaining balance. Our calculator produces a year-by-year loan amortization table that makes it easy to track payoff progress without scrolling through hundreds of monthly rows.
In the early rows of the loan amortization table, the interest column is large relative to principal. This is the nature of front-loaded amortization — lenders collect the most interest when the balance is highest. Over time, the principal column grows and the interest column shrinks, until the final payments are almost entirely principal. Seeing this pattern in the loan amortization table is a powerful reminder of why early extra payments save disproportionately more money than the same payments made later.
Loan Amortization Schedule in Excel vs. Our Online Calculator
Many borrowers search for a loan amortization schedule Excel template to track payments manually. In Excel, you'd use the PMT function for the monthly payment and IPMT/PPMT functions to split each payment. While a loan amortization schedule Excel spreadsheet works, it requires careful setup and is prone to formula errors — especially when comparing multiple loan scenarios.
Our free online loan amortization schedule calculator produces the same results instantly. For most borrowers, it's faster and more reliable than building a loan amortization schedule Excel file from scratch. Simply change any input and the schedule updates immediately — no drag-to-fill, no cell references to manage.
Using This as a Personal Loan Amortization Calculator
This tool works equally well as a personal loan amortization calculator. Personal loans are unsecured installment loans with fixed interest rates and terms typically ranging from 12 to 84 months. Because they're fully amortizing, the standard formula applies directly.
Use this personal loan amortization calculator to compare offers from multiple lenders before you borrow. Enter the loan amount, rate, and term from each offer to see which has the lower total interest cost — not just the lower monthly payment. A slightly lower payment stretched over a longer term can cost significantly more in total interest over the life of the loan.
Tips for Reducing Your Total Loan Cost
- Make extra principal payments. Every dollar above the minimum reduces your balance immediately and lowers all future interest charges. Even modest extra payments compounded over years add up to thousands in savings.
- Choose the shortest term you can afford. Shorter terms carry lower rates and far less total interest. Compare 15-year and 30-year scenarios in the calculator to see the difference clearly.
- Shop multiple lenders. A 0.5% lower rate on a $250,000 30-year loan saves approximately $27,000 in total interest. Use this loan amortization schedule calculator to compare offers side by side.
- Start with a larger down payment. Borrowing less means less interest on every payment — from the very first month of your loan amortization schedule.
- Refinance when rates drop significantly. A meaningful rate reduction resets your amortization schedule at a lower cost. Use this calculator to model your current loan vs. a hypothetical refinanced loan.
Frequently Asked Questions
What is a loan amortization calculator? ▼
A loan amortization calculator is a financial tool that computes your fixed monthly payment and generates a complete loan amortization schedule showing how each payment is split between principal and interest. Enter your loan amount, interest rate, and term to instantly see your total cost, payoff date, and a year-by-year loan amortization table — no spreadsheet required.
How do I calculate a loan amortization schedule? ▼
To calculate a loan amortization schedule, you need three inputs: loan principal, annual interest rate, and loan term. Apply the loan amortization formula M = P[r(1+r)^n] / [(1+r)^n − 1] to find the fixed monthly payment, then for each period compute interest (balance × monthly rate) and principal (payment − interest), reducing the balance until it reaches zero. Our loan amortization schedule calculator does all of this automatically.
What is a loan amortization table? ▼
A loan amortization table is a complete breakdown of every payment over the life of a loan. Each row shows the payment period, the portion going to principal, the portion going to interest, and the remaining balance. Our calculator displays a year-by-year loan amortization table so you can see your exact payoff progress and total interest cost at a glance.
How is loan amortization calculated? ▼
Loan amortization is calculated by first using the amortization formula to determine the fixed monthly payment, then iterating through each payment period: multiply the current balance by the monthly interest rate (annual rate ÷ 12) to get the interest charge, subtract from the payment to get the principal reduction, and reduce the balance accordingly. This repeats until the balance reaches zero at the end of the loan term.
What is the loan amortization formula? ▼
The loan amortization formula is M = P × [r(1+r)^n] ÷ [(1+r)^n − 1], where M is the monthly payment, P is the loan principal, r is the monthly interest rate (annual rate ÷ 12), and n is the total number of monthly payments. This formula calculates the equal payment that fully repays the loan over n periods with no balance remaining.
How can I create a loan amortization schedule in Excel? ▼
To create a loan amortization schedule in Excel, use =PMT(rate/12, term*12, -principal) for the monthly payment. Then set up columns for period, beginning balance, payment, interest (balance × rate/12), principal (payment − interest), and ending balance, and drag the formulas down for each period. Our free online loan amortization schedule calculator gives you the same results instantly — no Excel required.
What is the difference between loan amortization and loan repayment? ▼
Loan amortization specifically refers to paying off debt through scheduled, equal payments where the principal/interest split shifts over time — interest dominates early, principal dominates later. Loan repayment is the broader concept of returning borrowed money, which may include interest-only periods, balloon payments, or variable payment structures. A fully amortizing loan has equal payments and a zero balance at the end of the term.
How does a personal loan amortization calculator work? ▼
A personal loan amortization calculator applies the amortization formula to your personal loan amount, interest rate, and term. Personal loans are typically unsecured with fixed interest rates and terms from 12 to 84 months. Enter your loan details to see your exact monthly payment and a full repayment schedule. Use it to compare offers from multiple lenders to find the lowest total cost — not just the lowest monthly payment.
Can I make extra payments to pay off my loan faster? ▼
Yes, and extra payments can save a significant amount of interest. Every dollar of extra principal payment reduces your balance immediately, which reduces the interest charged in all future months. Even $50–$100 extra per month can shave years off a long-term loan and save thousands in total interest. Use our Extra Payments calculator to see the exact impact for your specific loan.
What happens to my amortization schedule if I make extra payments? ▼
When you make extra principal payments, your loan balance falls faster than the standard schedule, reducing future interest charges and shortening your loan term. The interest savings compound: each early extra payment reduces the balance that generates interest for all remaining months. Use our Extra Payments calculator to model the exact difference on your loan amortization schedule.