 Online Calculators

# 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 ## 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"; CalculatorSoup, https://www.calculatorsoup.com - Online Calculators