PV Rate Period 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
100 8% FV (Simple Interest) FV (Compound Interest) 100.00 100.00 108.00 108.00 116.00 116.64 124.00 125.97 132.00 136.05 140.00 146.93 148.00 158.69 156.00 171.38 164.00 185.09 172.00 199.90 180.00 215.89 188.00 233.16 196.00 251.82 204.00 271.96 212.00 293.72 220.00 317.22 228.00 342.59 236.00 370.00 244.00 399.60 252.00 431.57 260.00 466.10 268.00 503.38 276.00 543.65 284.00 587.15 292.00 634.12 300.00 684.85 308.00 739.64 316.00 798.81 324.00 862.71 332.00 931.73 340.00 1,006.27 348.00 1,086.77 356.00 1,173.71 364.00 1,267.60 372.00 1,369.01 380.00 1,478.53 388.00 1,596.82 396.00 1,724.56 404.00 1,862.53 412.00 2,011.53 420.00 2,172.45 Pick a Year:
30
X
2,500 30.00
Y
30.00 2,000 30.00 Future Value
1,500 1,000 500
0
0.00 340.00 1006.27
Compound vs Simple I 8% per year for 40 Y
0
5
10
15
FV (Simple Interest)
This workbook is Copyright © 2007 by Timothy R. M
Please visit http://www.tvmcalcs.com/ for free time v calculator, and Microsoft Excel tutorials.
Compound vs Simple Interest 8% per year for 40 Years
1006.27
340.00
15
20
25
30
35
40
Years
FV (Compound Interest)
FV (Simple Interest)
ght © 2007 by Timothy R. Mayes, Ph.D.
mcalcs.com/ for free time value of money, financial Excel tutorials.
30