Loan Amortization Schedule Calculator
Fast, accurate, and free online Loan Amortization Schedule Calculator tool that runs directly in your browser.
-
1Enter data
Enter content, paste text or load a file from disk. -
2Click the button
The tool will immediately process your data in the browser. -
3Get the result
Copy the finished text or save the file to your device.
return "Result ready in 0.1s";
}
Rate this tool:
Related tools
Other tools you may find usefulLoan repayment schedule calculator - online amortization table
Loan repayment schedule calculatorcalculates a detailed loan or credit repayment plan - monthly installments, division into principal and interest, balance after each installment and the total cost of the loan. Generates a full depreciation table for download.
What is a repayment schedule (amortization)?
The amortization schedule is a detailed table showing the division of each loan installment into two components: the capital part (repayment of the borrowed amount) and the interest part (the cost of using the money). At the beginning of repayment, most of the installment is interest and a smaller part is principal. With each subsequent installment, the proportion reverses - more and more goes to repaying the principal and less to interest.
Types of loan installments
Equal installments (annuity)- each installment has the same amount throughout the entire loan period. This is the most common type of installment in mortgage and cash loans. A fixed installment makes it easier to budget, but the total interest cost is higher than with decreasing installments.Decreasing installments (principal)- the capital part is fixed in each installment (loan amount / number of installments), while the interest decreases with each subsequent installment. The first installment is the highest, the last is the lowest. The total interest cost is lower, but requires a higher creditworthiness at the beginning of repayments.
How to use the calculator?
Enter: loan amount (e.g. PLN 300,000), annual interest rate (e.g. 7.5%), loan period in months or years (e.g. 25 years = 300 months) and installment type (equal or decreasing). The calculator will generate a complete amortization table with a division into each installment: installment number, total installment amount, principal part, interest part, remaining balance to be repaid. You can download the table as CSV or print it.
Total cost of credit and APR
The total cost of credit (CKK) is the sum of all installments minus the amount borrowed - in other words, how much total interest you will pay. APRC (Actual Annual Interest Rate) includes not only the nominal interest rate, but also all commissions, fees and insurance. When comparing loans, pay attention to the APR, not only to the nominal interest rate - it may turn out that a nominally cheaper loan with high commissions is more expensive.
Impact of early repayment on the schedule
If you pay an overpayment (additional money over the installment), you can: shorten the loan period (by the same installment - you will save on interest) or reduce the installment amount (maintaining the same period). In Poland, banks are obliged to allow early repayment - check if your loan has an early repayment fee (max. 3% for the first 3 years for fixed-rate loans).
Frequently asked questions
How to calculate the monthly loan installment?
Annuity installment formula: R = K × r / (1 - (1+r)^(-n)), where K = loan amount, r = monthly interest rate (annual/12), n = number of installments. Example: PLN 100,000, 6% per year, 10 years: r = 0.5%, n = 120. R = 100,000 × 0.005 / (1-(1,005)^-120) ≈ PLN 1,110.21 per month.
Is it possible to reduce the loan installment after taking out a loan?
Yes - the possibilities are: refinancing the loan with another bank at a lower interest rate, renegotiating the terms with the current bank (if interest rates have dropped), extending the loan period (lower installment, but more interest in total), loan holidays (temporary suspension of installments - available in some banks and crisis periods).
How to check how much interest I will pay over the entire loan period?
Total interest = (sum of all installments) - (loan amount). The calculator shows this value as "total interest cost". For a loan of PLN 300,000 for 25 years at an interest rate of 7.5%, the total interest may amount to over PLN 300,000 - that is, you pay twice as much for the loan as you borrowed.
Equal or decreasing installments – what to choose?
Decreasing installments: lower total cost of credit (less interest), but higher initial installments (require higher creditworthiness). Equal installments: fixed, predictable installments throughout the entire period - easier budget planning. Banks often prefer equal installments because they generate higher interest income.
What are credit holidays and when should you use them?
Credit holidays are a temporary suspension of the repayment of installments (principal or total) for a specified period of time. Interest usually continues to accrue or be added to the balance. It is worth using in case of a temporary financial problem (loss of job, illness), but remember - after the holidays the balance is higher and the repayment time is longer.