ABCDEJKLMNOPQRSTUVWXYZ
1
2
3
THE MARRIAGE GOAL
CALCULATOR
4
5
6
MARRIAGE CORPUS CALCULATION
7
Cost of Marriage todayRs 2,000,000
8
Years to Marriageyrs 5
9
Inflation in Marriage cost p.a.%10%
10
Future value of marriage costRs 3,221,020
11
Cost of Gold todayRs 500,000
12
Inflation in Gold yrs7%
13
Cost of Gold at MarriageRs 701,276
14
TOTAL COST OF MARRIAGE 3,922,296
15
16
17
Assets Availabe for the planRs 200,000
18
Growth expected in the assets%15%
19
Corpus at time of marriage goalRs 402,271
20
Additional Corpus Required Rs 3,520,024
23
#REF!
24
Investment required for the goalExpected Return On Portfolio
25
Particulars8%12%15%
29
Nominal Rate of Return7.72%11.39%14.06%
30
Monthly Investment Required For the Goal 48,256 43,813 40,774
31
Annual Investment Required For the Goal 603,361 560,883 531,911
32
One Time Investment Required For the Goal 2,426,873 2,052,967 1,823,555
33
34
Rationale :
35
36
37
38
39
40
Input:
41
42
1) It asks you to input the current cost of Marriage & Gold required for marriage
43
2) It asks you to input the time period to the marriage goal.
44
3) It asks you to input inflation rate.
45
4) It asks you to input investments already available for plan.
46
5) It asks you to input return on Investments.
47
6) It asks you to input different return on Investments if required.
48
49
Output:
50
51
52
53
Formula:
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
101
102
103
104
105