Loan Payment Table Generator

Generate a monthly loan payment lookup table that varies two of loan size, term, and annual rate.

Result
—

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.

OpenStax loan amortization

Related calculators