Create a matrix of payment amounts or borrowed amounts.
Interest rate steps along the x-axis
Term steps down the y-axis
The loan matrix calculator is used to calculate:
loan payments based on different interest rates and terms
loan payments based on different interest rates and loan amounts
possible loan amounts based on different interest rates and payment terms for a specified payment
The purpose of a matrix calculator is to present multiple results at one time. This approach eliminates the need to perform a series of separate scenario calculations.
Loan Matrix Calculator-save time by avoiding what-if calculations
To set your preferred currency and date format, click the “$ : MM/DD/YYYY” link in the lower-right corner of any calculator.
Information
This text is dynamically cleared and added as needed.
Click to make smaller (-) or larger (+).
Some additional notes:
Payment method: When payments start. If the first payment is due on the day the loan originates, select “start-of-period;” otherwise, select “end-of-period.”
Compound frequency: If the compounding frequency is not specified by the lender, or you do not know it, select the same value as “payment frequency.”
Step values: The amount by which to increase the x-axis and y-axis values from their initial settings. For example, if you set the “initial interest rate” to 5% and the “rate step value” to 0.5%, the calculator sets the second interest rate (x-axis) to 5.5%.
Loan Matrix Help
On the “Payment Amount — term varies” tab, you can calculate a matrix of potential periodic payments for a given loan amount while varying the loan term and interest rate.
On the “Payment Amount — loan amount varies” tab, you can calculate a matrix of potential periodic payments for a given term while varying the loan amount and interest rate.
The “Loan Amount” tab allows you to calculate a matrix of loan amounts that can be borrowed for a specified payment amount across different terms and interest rates.
The “step values” on each tab control the amount by which the interest rate and term will increase.
Note: It is not necessary to clear a calculation before starting another one. You may change a value and recalculate.
Currency and Date Conventions
All calculators will remember your choice. You may also change it at any time.
Clicking “Save changes” will cause the calculator to reload. Your edits will be lost.
Comments, suggestions & questions welcomed...