Generating Compound Interest Formula

	A	B	C	D	E	F
1	Simple interest annually	Principle (P)	Rate	Time	Interest per year	simple interest
2	Year 1	1000	0.1	1	100	1100
3	Year 2	1000	0.1	1	100	1200
4	Year 3	1000	0.1	1	100	1300
5	Year 4	1000	0.1	1	100	1400
6	Year 5	1000	0.1	1	100	1500
7	Year 6	1000	0.1	1	100	1600
8	Year 7	1000	0.1	1	100	1700
9	Year 8	1000	0.1	1	100	1800
10	Year 9	1000	0.1	1	100	1900
11	Year 10	1000	0.1	1	100	2000
12	Year 11	1000	0.1	1	100	2100
13	Year 12	1000	0.1	1	100	2200
14
15
16	Interest compounded annually	Principle (P)	Rate	Time	Interest per year	compound interest
17	Year 1	1000	0.1	1	100.00	1100.00
18	Year 2	1100.00	0.1	1	110.00	1210.00
19	Year 3	1210.00	0.1	1	121.00	1331.00
20	Year 4	1331.00	0.1	1	133.10	1464.10
21	Year 5	1464.10	0.1	1	146.41	1610.51
22	Year 6	1610.51	0.1	1	161.05	1771.56
23	Year 7	1771.56	0.1	1	177.16	1948.72
24	Year 8	1948.72	0.1	1	194.87	2143.59
25	Year 9	2143.59	0.1	1	214.36	2357.95
26	Year 10	2357.95	0.1	1	235.79	2593.74
27	Year 11	2593.74	0.1	1	259.37	2853.12
28	Year 12	2853.12	0.1	1	285.31	3138.43
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100