Amortization Schedule Builder
Amortization Schedule Builder
| Year | Paid | Interest | Principal | Balance |
|---|---|---|---|---|
| Year 1 | $20,162 | $16,131 | $4,031 | $245,969 |
| Year 2 | $20,162 | $15,861 | $4,301 | $241,669 |
| Year 3 | $20,162 | $15,573 | $4,589 | $237,080 |
| Year 4 | $20,162 | $15,266 | $4,896 | $232,184 |
| Year 5 | $20,162 | $14,938 | $5,224 | $226,960 |
| Year 6 | $20,162 | $14,588 | $5,574 | $221,386 |
| Year 7 | $20,162 | $14,215 | $5,947 | $215,439 |
| Year 8 | $20,162 | $13,817 | $6,345 | $209,094 |
| Year 9 | $20,162 | $13,392 | $6,770 | $202,324 |
| Year 10 | $20,162 | $12,938 | $7,224 | $195,100 |
| Year 11 | $20,162 | $12,455 | $7,707 | $187,393 |
| Year 12 | $20,162 | $11,938 | $8,224 | $179,169 |
| Year 13 | $20,162 | $11,388 | $8,774 | $170,394 |
| Year 14 | $20,162 | $10,800 | $9,362 | $161,032 |
| Year 15 | $20,162 | $10,173 | $9,989 | $151,043 |
| Year 16 | $20,162 | $9,504 | $10,658 | $140,385 |
| Year 17 | $20,162 | $8,790 | $11,372 | $129,014 |
| Year 18 | $20,162 | $8,029 | $12,133 | $116,880 |
| Year 19 | $20,162 | $7,216 | $12,946 | $103,934 |
| Year 20 | $20,162 | $6,349 | $13,813 | $90,121 |
| Year 21 | $20,162 | $5,424 | $14,738 | $75,383 |
| Year 22 | $20,162 | $4,437 | $15,725 | $59,658 |
| Year 23 | $20,162 | $3,384 | $16,778 | $42,880 |
| Year 24 | $20,162 | $2,260 | $17,902 | $24,978 |
| Year 25 | $20,162 | $1,061 | $19,101 | $5,877 |
| Year 26 | $5,950 | $74 | $5,877 | $0 |
| Total | $510,001 | $260,001 | $250,000 | $0 |
What Is an Amortization Schedule Builder?
An amortization schedule builder turns a loan amount, a rate and a term into the full table of payments that follows. Instead of a single monthly figure, you get the split between interest and principal in every period, the balance that remains and the year in which the loan finally clears. Because the arithmetic is the same for mortgages, car loans, personal loans and student loans, the same builder describes almost any fixed-rate borrowing.
The useful part of a schedule is the shape of it. In the early years the balance is at its highest, so interest claims most of each payment and principal reduces slowly. As the balance falls, the fixed payment covers less interest and more principal, and the final years pass quickly. Seeing that curve is what makes the effect of an extra payment intuitive rather than abstract.
How the Schedule Is Built
The instalment is calculated once, using the standard amortising formula in which the payment is the loan amount multiplied by the monthly rate divided by one minus the monthly rate compounded back over the number of months. The builder then walks the loan month by month: it charges interest on the opening balance at the monthly rate, applies the payment to that charge first, and credits whatever is left as principal reduction.
Extra payments are handled as additional principal in the month they are made. A monthly extra is added to the scheduled payment throughout the loan, while a lump sum is applied once in the chosen payment number. Both reduce the balance immediately, which cuts the interest charged in every following month. The payoff month is detected by the balance reaching zero, and the months removed from the original term become the time saved.
Understanding Your Results
The primary card reports how long the loan lasts once extras are included, with the total interest and the amount saved against the scheduled term underneath. The three statistics beside it show the actual monthly payment, the interest saved and the time removed. The breakdown table is the schedule itself, rolled up by year, with a total row that must reconcile: payments less interest always equal the original principal.
Summary Statistics gathers the loan amount, the base instalment, the extra monthly and one-off payments, the payoff and scheduled terms, total interest both with and without extras, the interest and time saved, the total repaid and the share of first-year payments consumed by interest. Owners who can afford a modest extra monthly amount are often surprised by how much of the term it removes, because the saving compounds through every remaining month of the loan.
Frequently Asked Questions
Related Calculators
Home Loan Calculator
Calculate home loan EMI, total interest, and amortization schedule.
Auto Loan Calculator
Detailed auto loan with trade-in, taxes, fees, and amortization.
Bike Loan Calculator
Calculate bike loan EMI, total cost, and repayment breakdown.
Boat Loan Calculator
Estimate boat financing payments, interest, and amortization.
Student Loan Calculator
Calculate student loan payments with income-driven repayment plans.
Gold Loan Calculator
Calculate gold loan amount based on gold weight, purity, and LTV ratio.
USDA Loan Calculator
Calculate USDA loan payments with guarantee fee and income eligibility.
Loan Against Property Calculator
Calculate LAP EMI based on property value and loan-to-value ratio.