0% found this document useful (0 votes)
37 views3 pages

Compound Vs Simple Interest 8% Per Year For 40 Years

CPI

Uploaded by

tre
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
37 views3 pages

Compound Vs Simple Interest 8% Per Year For 40 Years

CPI

Uploaded by

tre
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLS, PDF, TXT or read online on Scribd

PV 1825

Rate 8%

Period FV (Simple Interest) FV (Compound Interest) Pick a Year: 40


0 1,825.00 1,825.00
1 1,971.00 1,971.00

Future Value
2 2,117.00 2,128.68 X Compound vs Simple Intere
Y
3 2,263.00 2,298.97 45,000.00
40.00 0.00 8% per year for 40 Years
4 2,409.00 2,482.89 40,000.00
40.00 7665.00
5 2,555.00 2,681.52 40.00 39647.25
35,000.00
6 2,701.00 2,896.05 30,000.00
7 2,847.00 3,127.73 25,000.00
8 2,993.00 3,377.95
20,000.00
9 3,139.00 3,648.18
10 3,285.00 3,940.04 15,000.00
11 3,431.00 4,255.24 10,000.00
12 3,577.00 4,595.66 5,000.00
13 3,723.00 4,963.31 -
14 3,869.00 5,360.38 0 5 10 15 20 25
15 4,015.00 5,789.21 Years
16 4,161.00 6,252.35 FV (Simple Interest)
Column F
17 4,307.00 6,752.53
18 4,453.00 7,292.74
19 4,599.00 7,876.15
20 4,745.00 8,506.25 This workbook is Copyright © 2007 by Timothy R. M
21 4,891.00 9,186.75
22 5,037.00 9,921.69 Please visit [Link] for free time va
23 5,183.00 10,715.42 calculator, and Microsoft Excel tutorials.
24 5,329.00 11,572.65
25 5,475.00 12,498.47
26 5,621.00 13,498.34
27 5,767.00 14,578.21
28 5,913.00 15,744.47
29 6,059.00 17,004.03
30 6,205.00 18,364.35
31 6,351.00 19,833.50
32 6,497.00 21,420.18
33 6,643.00 23,133.79
34 6,789.00 24,984.49
35 6,935.00 26,983.25
36 7,081.00 29,141.91
37 7,227.00 31,473.27
38 7,373.00 33,991.13
39 7,519.00 36,710.42
40 7,665.00 39,647.25
Compound vs Simple Interest
8% per year for 40 Years
39,647.25

7,665.00

10 15 20 25 30 35 40
Years
FV (Simple Interest) FV (Compound Interest)
Column F

ght © 2007 by Timothy R. Mayes, Ph.D.

[Link]/ for free time value of money, financial


Excel tutorials.
40

You might also like