How to use this calculator
Build a month-by-month mortgage schedule with principal, interest, and remaining balance.
Worked example
Enter Loan amount 100000 · Annual interest rate (%) 6 · Term in months 120. The result is 1110.21 per month.
Calculation method
Divide the annual percentage rate by 1,200 to get the monthly rate as a decimal. Discount the monthly payments to the original loan balance. At 0% interest, divide the balance by the number of payments. The table uses unrounded balances and rounds each displayed amount. Copy exports the schedule as CSV.