Annuity Investment calculator by Finacue

	B	C	D	E	F	G	I
1	Annuity investment
2
3	Present value		10,000.00		Value after 7 years	₹23,067.23
4	Interest rate		12.00%		Monthly payment after 7 years	₹228.39
5	Term (in years)		20		Value after 20 years	₹108,925.54
6	Contribution each month (reinvested interest)		100.0%		Monthly payment after 20 years	₹1,078.47
7
8	Month	Balance	Interest earned	Interest + balance	Amount paid to investor	New balance
9	1	10,000.00	100.00	10,100.00	0.00	10,100.00
10	2	10,100.00	101.00	10,201.00	0.00	10,201.00
11	3	10,201.00	102.01	10,303.01	0.00	10,303.01
12	4	10,303.01	103.03	10,406.04	0.00	10,406.04
13	5	10,406.04	104.06	10,510.10	0.00	10,510.10
14	6	10,510.10	105.10	10,615.20	0.00	10,615.20
15	7	10,615.20	106.15	10,721.35	0.00	10,721.35
16	8	10,721.35	107.21	10,828.57	0.00	10,828.57
17	9	10,828.57	108.29	10,936.85	0.00	10,936.85
18	10	10,936.85	109.37	11,046.22	0.00	11,046.22
19	11	11,046.22	110.46	11,156.68	0.00	11,156.68
20	12	11,156.68	111.57	11,268.25	0.00	11,268.25
21	13	11,268.25	112.68	11,380.93	0.00	11,380.93
22	14	11,380.93	113.81	11,494.74	0.00	11,494.74
23	15	11,494.74	114.95	11,609.69	0.00	11,609.69
24	16	11,609.69	116.10	11,725.79	0.00	11,725.79
25	17	11,725.79	117.26	11,843.04	0.00	11,843.04
26	18	11,843.04	118.43	11,961.47	0.00	11,961.47
27	19	11,961.47	119.61	12,081.09	0.00	12,081.09
28	20	12,081.09	120.81	12,201.90	0.00	12,201.90
29	21	12,201.90	122.02	12,323.92	0.00	12,323.92
30	22	12,323.92	123.24	12,447.16	0.00	12,447.16
31	23	12,447.16	124.47	12,571.63	0.00	12,571.63
32	24	12,571.63	125.72	12,697.35	0.00	12,697.35
33	25	12,697.35	126.97	12,824.32	0.00	12,824.32
34	26	12,824.32	128.24	12,952.56	0.00	12,952.56
35	27	12,952.56	129.53	13,082.09	0.00	13,082.09
36	28	13,082.09	130.82	13,212.91	0.00	13,212.91
37	29	13,212.91	132.13	13,345.04	0.00	13,345.04
38	30	13,345.04	133.45	13,478.49	0.00	13,478.49
39	31	13,478.49	134.78	13,613.27	0.00	13,613.27
40	32	13,613.27	136.13	13,749.41	0.00	13,749.41
41	33	13,749.41	137.49	13,886.90	0.00	13,886.90
42	34	13,886.90	138.87	14,025.77	0.00	14,025.77
43	35	14,025.77	140.26	14,166.03	0.00	14,166.03
44	36	14,166.03	141.66	14,307.69	0.00	14,307.69
45	37	14,307.69	143.08	14,450.76	0.00	14,450.76
46	38	14,450.76	144.51	14,595.27	0.00	14,595.27
47	39	14,595.27	145.95	14,741.23	0.00	14,741.23
48	40	14,741.23	147.41	14,888.64	0.00	14,888.64
49	41	14,888.64	148.89	15,037.52	0.00	15,037.52
50	42	15,037.52	150.38	15,187.90	0.00	15,187.90
51	43	15,187.90	151.88	15,339.78	0.00	15,339.78
52	44	15,339.78	153.40	15,493.18	0.00	15,493.18
53	45	15,493.18	154.93	15,648.11	0.00	15,648.11
54	46	15,648.11	156.48	15,804.59	0.00	15,804.59
55	47	15,804.59	158.05	15,962.63	0.00	15,962.63
56	48	15,962.63	159.63	16,122.26	0.00	16,122.26
57	49	16,122.26	161.22	16,283.48	0.00	16,283.48
58	50	16,283.48	162.83	16,446.32	0.00	16,446.32
59	51	16,446.32	164.46	16,610.78	0.00	16,610.78
60	52	16,610.78	166.11	16,776.89	0.00	16,776.89
61	53	16,776.89	167.77	16,944.66	0.00	16,944.66
62	54	16,944.66	169.45	17,114.10	0.00	17,114.10
63	55	17,114.10	171.14	17,285.25	0.00	17,285.25
64	56	17,285.25	172.85	17,458.10	0.00	17,458.10
65	57	17,458.10	174.58	17,632.68	0.00	17,632.68
66	58	17,632.68	176.33	17,809.01	0.00	17,809.01
67	59	17,809.01	178.09	17,987.10	0.00	17,987.10
68	60	17,987.10	179.87	18,166.97	0.00	18,166.97
69	61	18,166.97	181.67	18,348.64	0.00	18,348.64
70	62	18,348.64	183.49	18,532.12	0.00	18,532.12
71	63	18,532.12	185.32	18,717.44	0.00	18,717.44
72	64	18,717.44	187.17	18,904.62	0.00	18,904.62
73	65	18,904.62	189.05	19,093.66	0.00	19,093.66
74	66	19,093.66	190.94	19,284.60	0.00	19,284.60
75	67	19,284.60	192.85	19,477.45	0.00	19,477.45
76	68	19,477.45	194.77	19,672.22	0.00	19,672.22
77	69	19,672.22	196.72	19,868.94	0.00	19,868.94
78	70	19,868.94	198.69	20,067.63	0.00	20,067.63
79	71	20,067.63	200.68	20,268.31	0.00	20,268.31
80	72	20,268.31	202.68	20,470.99	0.00	20,470.99
81	73	20,470.99	204.71	20,675.70	0.00	20,675.70
82	74	20,675.70	206.76	20,882.46	0.00	20,882.46
83	75	20,882.46	208.82	21,091.28	0.00	21,091.28
84	76	21,091.28	210.91	21,302.20	0.00	21,302.20
85	77	21,302.20	213.02	21,515.22	0.00	21,515.22
86	78	21,515.22	215.15	21,730.37	0.00	21,730.37
87	79	21,730.37	217.30	21,947.68	0.00	21,947.68
88	80	21,947.68	219.48	22,167.15	0.00	22,167.15
89	81	22,167.15	221.67	22,388.82	0.00	22,388.82
90	82	22,388.82	223.89	22,612.71	0.00	22,612.71
91	83	22,612.71	226.13	22,838.84	0.00	22,838.84
92	84	22,838.84	228.39	23,067.23	0.00	23,067.23	<--84 months is the 7-year mark.
93	85	23,067.23	230.67	23,297.90	0.00	23,297.90
94	86	23,297.90	232.98	23,530.88	0.00	23,530.88
95	87	23,530.88	235.31	23,766.19	0.00	23,766.19
96	88	23,766.19	237.66	24,003.85	0.00	24,003.85
97	89	24,003.85	240.04	24,243.89	0.00	24,243.89
98	90	24,243.89	242.44	24,486.33	0.00	24,486.33
99	91	24,486.33	244.86	24,731.19	0.00	24,731.19
100	92	24,731.19	247.31	24,978.50	0.00	24,978.50