Future Value of Monthly Investment

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 7

1 30000 10% 33000.

0 1 30000
2 33000.0 10% 36300.0 2 30000
3 36300.0 10% 39930.0 3 30000
4 39930.0 10% 43923.0 4 30000
5 43923.0 10% 48315.3 5 30000
6 48315.3 10% 53146.8 6 30000
7 53146.8 10% 58461.5 7 30000
8 58461.5 10% 64307.7 8 30000
9 64307.7 10% 70738.4 9 30000
10 70738.4 10% 77812.3 10 30000
11 77812.3 10% 85593.5 11 30000
12 85593.5 10% 94152.9 12 30000
30000 10% 33000.0
63000 10% 69300.0 69300.0
132300 10% 145530.0 30000
277830 10% 305613.0 99300.0
583443 10% 641787.3
1225230 10% 1347753.3
2572984 10% 2830282.0
5403266 10% 5943592.2
11346858 10% 12481543.6
23828401 10% 26211241.5
50039643 10% 55043607.2
105083250 10% 115591575.2
Start date 7/1/2021 Est.rate 20%

Investment 30000 Bal.at 10yrs. 0

Fixed Variable

Date Investment Return/Loss Balance Annul r


1 7/1/2021 30000 500 30500
2 8/1/2021 30000 1008.33 61508.33
3 9/1/2021 30000 1,525.14 93033.47
4 10/1/2021 30000 0.00 123033.47
5 11/1/2021 30000 0.00 153033.47
6 12/1/2021 30000 0.00 183033.47
7 1/1/2022 30000 0.00 213033.47
8 2/1/2022 30000 0.00 243033.47
9 3/1/2022 30000 0.00 273033.47
10 4/1/2022 30000 0.00 303033.47
11 5/1/2022 30000 0.00 333033.47
12 6/1/2022 30000 0.00 363033.47
13 7/1/2022 30000 0.00 393033.47
14 8/1/2022 30000 0.00 423033.47
15 9/1/2022 30000 0.00 453033.47
16 10/1/2022 30000 0.00 483033.47
17 11/1/2022 30000 0.00 513033.47
18 12/1/2022 30000 0.00 543033.47
19 1/1/2023 30000 0.00 573033.47
20 2/1/2023 30000 0.00 603033.47
21 3/1/2023 30000 0.00 633033.47
22 4/1/2023 30000 0.00 663033.47
23 5/1/2023 30000 0.00 693033.47
24 6/1/2023 30000 0.00 723033.47
25 7/1/2023 30000 0.00 753033.47
26 8/1/2023 30000 0.00 783033.47
27 9/1/2023 30000 0.00 813033.47
28 10/1/2023 30000 0.00 843033.47
29 11/1/2023 30000 0.00 873033.47
30 12/1/2023 30000 0.00 903033.47
31 1/1/2024 30000 0.00 933033.47
32 2/1/2024 30000 0.00 963033.47
33 3/1/2024 30000 0.00 993033.47
34 4/1/2024 30000 0.00 1023033.47
35 5/1/2024 30000 0.00 1053033.47
36 6/1/2024 30000 0.00 1083033.47
37 7/1/2024 30000 0.00 1113033.47
38 8/1/2024 30000 0.00 1143033.47
39 9/1/2024 30000 0.00 1173033.47
40 10/1/2024 30000 0.00 1203033.47
41 11/1/2024 30000 0.00 1233033.47
42 12/1/2024 30000 0.00 1263033.47
43 1/1/2025 30000 0.00 1293033.47
44 2/1/2025 30000 0.00 1323033.47
45 3/1/2025 30000 0.00 1353033.47
46 4/1/2025 30000 0.00 1383033.47
47 5/1/2025 30000 0.00 1413033.47
48 6/1/2025 30000 0.00 1443033.47
49 7/1/2025 30000 0.00 1473033.47
50 8/1/2025 30000 0.00 1503033.47
51 9/1/2025 30000 0.00 1533033.47
52 10/1/2025 30000 0.00 1563033.47
53 11/1/2025 30000 0.00 1593033.47
54 12/1/2025 30000 0.00 1623033.47
55 1/1/2026 30000 0.00 1653033.47
56 2/1/2026 30000 0.00 1683033.47
57 3/1/2026 30000 0.00 1713033.47
58 4/1/2026 30000 0.00 1743033.47
59 5/1/2026 30000 0.00 1773033.47
60 6/1/2026 30000 0.00 1803033.47
Variable

Return/Loss Balance
Month Amount Interest Future value
1 ₹ 30,000.00 10% ₹ 30,000.00
2 ₹ 30,000.00 10% ₹ 63,000.00
3 ₹ 30,000.00 10% ₹ 99,300.00
4 ₹ 30,000.00 10% ₹ 139,230.00
5 ₹ 30,000.00 10% ₹ 183,153.00
6 ₹ 30,000.00 10% ₹ 231,468.30
7 ₹ 30,000.00 10% ₹ 284,615.13
8 ₹ 30,000.00 10% ₹ 343,076.64
9 ₹ 30,000.00 10% ₹ 407,384.31
10 ₹ 30,000.00 10% ₹ 478,122.74
11 ₹ 30,000.00 10% ₹ 555,935.01
12 ₹ 30,000.00 10% ₹ 641,528.51
13 ₹ 30,000.00 10% ₹ 735,681.36
14 ₹ 30,000.00 10% ₹ 839,249.50
15 ₹ 30,000.00 10% ₹ 953,174.45
16 ₹ 30,000.00 10% ₹ 1,078,491.90
17 ₹ 30,000.00 10% ₹ 1,216,341.09
18 ₹ 30,000.00 10% ₹ 1,367,975.19
19 ₹ 30,000.00 10% ₹ 1,534,772.71
20 ₹ 30,000.00 10% ₹ 1,718,249.98
21 ₹ 30,000.00 10% ₹ 1,920,074.98
22 ₹ 30,000.00 10% ₹ 2,142,082.48
23 ₹ 30,000.00 10% ₹ 2,386,290.73
24 ₹ 30,000.00 10% ₹ 2,654,919.80
25 ₹ 30,000.00 10% ₹ 2,950,411.78
26 ₹ 30,000.00 10% ₹ 3,275,452.96
27 ₹ 30,000.00 10% ₹ 3,632,998.26
28 ₹ 30,000.00 10% ₹ 4,026,298.08
29 ₹ 30,000.00 10% ₹ 4,458,927.89
30 ₹ 30,000.00 10% ₹ 4,934,820.68
31 ₹ 30,000.00 10% ₹ 5,458,302.75
32 ₹ 30,000.00 10% ₹ 6,034,133.02
33 ₹ 30,000.00 10% ₹ 6,667,546.33
34 ₹ 30,000.00 10% ₹ 7,364,300.96
35 ₹ 30,000.00 10% ₹ 8,130,731.05
36 ₹ 30,000.00 10% ₹ 8,973,804.16
37 ₹ 30,000.00 10% ₹ 9,901,184.58
38 ₹ 30,000.00 10% ₹ 10,921,303.03
39 ₹ 30,000.00 10% ₹ 12,043,433.34
40 ₹ 30,000.00 10% ₹ 13,277,776.67
41 ₹ 30,000.00 10% ₹ 14,635,554.34
42 ₹ 30,000.00 10% ₹ 16,129,109.77
43 ₹ 30,000.00 10% ₹ 17,772,020.75
44 ₹ 30,000.00 10% ₹ 19,579,222.82
45 ₹ 30,000.00 10% ₹ 21,567,145.11
46 ₹ 30,000.00 10% ₹ 23,753,859.62
47 ₹ 30,000.00 10% ₹ 26,159,245.58
48 ₹ 30,000.00 10% ₹ 28,805,170.14
49 ₹ 30,000.00 10% ₹ 31,715,687.15
50 ₹ 30,000.00 10% ₹ 34,917,255.86
51 ₹ 30,000.00 10% ₹ 38,438,981.45
52 ₹ 30,000.00 10% ₹ 42,312,879.60
53 ₹ 30,000.00 10% ₹ 46,574,167.55
54 ₹ 30,000.00 10% ₹ 51,261,584.31
55 ₹ 30,000.00 10% ₹ 56,417,742.74
56 ₹ 30,000.00 10% ₹ 62,089,517.02
57 ₹ 30,000.00 10% ₹ 68,328,468.72
58 ₹ 30,000.00 10% ₹ 75,191,315.59
59 ₹ 30,000.00 10% ₹ 82,740,447.15
60 ₹ 30,000.00 10% ₹ 91,044,491.86

You might also like