The future value matrix is a tool used to calculate:
the future value of a cash flow based on different rates of return and different numbers of investments
the periodic investment amount required to reach a specified future value, assuming different interest rates and different numbers of investments
The purpose of a matrix calculator is to present multiple results at one time. This approach saves you from running many separate “what-if” calculations.
Please rotate device or widen browser for a better experience.
Future Value 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:
Period method: Indicates when the periodic investment starts relative to the deposit frequency. If the first investment is assumed to be made “today,” then select “start-of-period,” otherwise select “end-of-period.”
Compound frequency: If the compounding frequency is not specified or you do not know it, then select the same value as “deposit frequency.”
Step values: Specifies how much to increase the x-axis and y-axis values from their initial values. For example, if you have set the “initial interest rate” to 5% and the “rate step value” to 0.5%, the calculator sets the second interest-rate value (x-axis) to 5.5%.
advertisement
Future Value Matrix Help
On the “Future Value” tab, you can calculate a matrix of future values for a specified deposit or investment amount while varying the term and the interest rate.
The “Deposit Amount” tab calculates a matrix of investment amounts (deposits) required to reach a specified future value under different terms and interest rates.
The “step amounts” on either tab control how much the interest rate and the term increase from one cell to the next.
Note: It is not necessary to clear one calculation before starting another. You can change any 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...