Interest Rate Table Creator

Interest Rate Tables
Future Value (FV) : Columns
Columns (20 max):  
Starting Value: $
Increments: $
Periods (n) : Rows
Rows (50 max):  
Starting Period:  
Increments:  

About this Table Creator

Create a printable interest rate table to lookup the interest rate required to grow $1 to a future value amount.

Starting with the formula for future value

\[ FV=PV(1+i)^n \]

and solving the equation for interest rate (i), we use the formula

\[ i=\left(\frac{FV}{PV}\right)^{1/n}-1 \]

replacing the present value sum with $1, PV = $1

\[ i=\left(\frac{FV}{\$1}\right)^{1/n}-1 \]

let I = i * 100 then the rate in percentage form is given by

\[ I=\left[\left(\frac{FV}{\$1}\right)^{1/n}-1\right]*100 \]

where FV is the future value, PV is the investment principal amount = $1, i is the interest rate in decimal form and n is the period number. PV is the amount of money = $1 to be invested at the end of each equal period which will grow to FV after n Number of Time Periods and at an Interest Rate i per period.  i is in decimal form for calculations.

If you decide to drop the $1 your final formula is

\[ I=\left(FV^{1/n}-1\right)*100 \]

You can, for example, look up I in the table to find an applicable interest rate for your desired investment performance.

Example Use: You want to invest $10,000 and triple your investment over time.  How many years will it take for you to triple your investment and at what interest rate?

  1. Create a table that includes FV = $3.00 since the table is based on $1.00 investments. Also include a sufficient range of rows for n.
    1. Start 5 colums of FV at 2 with increments of 0.5
    2. Start 20 rows of n at 10 with increments of 1
  2. Look at the FV column for $3.00.
  3. In the $3.00 column you can lookup interest rates and the corresponding number of periods, n, it will take to triple your investment.
 

Cite this content, page or calculator as:

Furey, Edward "Interest Rate on $1 Table Creator" From http://www.CalculatorSoup.com - Online Calculator Resource.

Powered by MathJax