RD Interest and Maturity Calculator.xlsx

	B	C	D	E	F	G
1		Interest Compound		Quaterly
2		Rate of Interest		8.50%
3		Tenure		60 Months
4		Deposit p.m.		10000
5
6		Months	Deposit	Int	Int2	Closing Balance (Quaterly)
7	1	Jan	10000	71
8	2	Feb	10000	142
9	3	Mar	10000	213	0	30425
10	4	Apr	10000	71
11	5	May	10000	142
12	6	Jun	10000	213	647	61497
13	7	Jul	10000	71
14	8	Aug	10000	142
15	9	Sep	10000	213	1307	93228
16	10	Oct	10000	71
17	11	Nov	10000	142
18	12	Dec	10000	213	1981	125634
19			120000	1700	3934
20
21	Invested Amount					120,000.00
22	Interest Earned					5,634.43
23	Meturity Amount					125,634.43
24
25
26
27
28
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