How to use this calculator
Generate a monthly loan payment lookup table that varies two of loan size, term, and annual rate.
Worked example
Enter Row variable Loan amount · First row value 6000 · Row increment 1200 · Number of rows 3 · Column variable Months · First column value 12 · Column increment 12 · Number of columns 2 · Value for whichever variable is left 0. The result is 3 rows.
Calculation method
Set the range for two variables and keep the third constant. Each cell applies the fixed-payment loan formula. Copy exports the table as CSV.