Loan Matrix Calculator

Help with a Loan Matrix

On the "Payment Amount" tab you can calculate a matrix of potential periodic payments for a given loan amount while varying the term and interest rate for the loan.

The "Loan Amount" tab allows you to calculate a matrix of various loan amounts that can be borrowed for a given payment amount for different terms and interest rates.

The "step values" on either tab control by what amount the interest rate and term are going to increase.

Note: It is not necessary to clear one calculation before doing the next. You can change one value and recalculate.