®

Online Calculator Resource

Interest Rate on $1 Table Creator

Interest Rate Table
Future Value (FV) : Columns

Periods (n) : Rows
Answer:
Interest Rate to Grow $1
\[ I=\left[\left(\frac{FV}{\$1}\right)^{1/n}-1\right]*100 \]
n / FV
$2.00
$2.50
$3.00
10
7.1773
9.5958
11.6123
11
6.5041
8.6867
10.5032
12
5.9463
7.9348
9.5873
13
5.4766
7.3027
8.8182
14
5.0757
6.7639
8.1633
15
4.7294
6.2990
7.5990
16
4.4274
5.8940
7.1075
17
4.1616
5.5378
6.6758
18
3.9259
5.2223
6.2935
19
3.7155
4.9408
5.9526
20
3.5265
4.6880
5.6467
21
3.3558
4.4599
5.3707
22
3.2008
4.2529
5.1205
23
3.0596
4.0643
4.8925
24
2.9302
3.8917
4.6839
25
2.8114
3.7332
4.4924
26
2.7018
3.5870
4.3160
27
2.6004
3.4519
4.1528
28
2.5064
3.3266
4.0016
29
2.4190
3.2101
3.8610

Share this Calculator & Page

Calculator Use

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(\dfrac{FV}{PV}\right)^{1/n}-1 \)

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

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

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

\( I=\left[\left(\dfrac{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.

Follow CalculatorSoup:
Powered by MathJax