ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
SIP Calculations Portfolio
2
Rebuilt replica — blue/yellow cells are your editable inputs; everything else is a live formula. See notes at the bottom for two assumptions made to fill gaps not visible in the recovered screenshot.
3
Years5
Installments/Year
12
Total Installments
60Inflation7.0%
4
5
Mutual FundsEquityNPSBondsTotalNature of SIP
6
FV (Future Value)₹580,216.84₹769,785.39₹587,814.85₹643,624.48₹2,581,441.56Uniform SIPTRUE
7
Rate (Annual)7.5%14.0%8.0%7.0%PredefinedFALSE
8
NPER (months)60606060
Uniform SIP Amount
₹8,000.00
9
PV / Lumpsum-₹40,000.00-₹50,000.00₹90,000.00
10
PMT (Auto Calculate)-₹930.73-₹990.06₹1,920.79Predefined Fixed SIP
11
If Uniform SIP₹8,000.00₹8,000.00₹8,000.00₹8,000.00₹32,000.00Mutual Funds₹6,000.00
12
Applied SIP Amount₹8,000.00₹8,000.00₹8,000.00₹8,000.00₹32,000.00Equity₹3,000.00
13
NPS₹2,000.00
14
Total SIP/Month₹32,000.00Bonds₹3,000.00
15
Total Corpus₹2,581,441.56
16
17
Inflation Adjustment
18
InvestedFinalGainsTypeJustification
19
Corpus Value₹2,010,000.00₹2,581,441.56₹571,441.56NominalBefore Inflation
20
PPV₹1,433,102.22₹1,840,532.16₹407,429.94Real
At Today's Value
21
FV Benchmark₹2,819,128.98₹2,581,441.56(₹237,687.42)Actual
At End of the Period
22
23
DecisionNot Financially Feasible
24
25
Notes on this rebuild:
1) "Applied SIP Amount" uses the same checkbox waterfall visible in the recovered formula (Uniform -> Predefined -> Auto-calculated PMT), corrected so each asset column pulls its OWN predefined amount (the recovered formula referenced a single fixed cell for every column).
2) "PMT (Auto Calculate)" is a reference calculation (payment that would draw the lumpsum PV to zero over NPER) since its exact original logic wasn't visible in the screenshot - it does not drive the model when a Uniform or Predefined SIP is active.
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