{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Read me first","Rebalancing Illustration","Annual Rebalancing Lumpsum","Annual Rebalancing SIP","Variable frequency Rebal. SIP","One-way Rebalancing SIP ","Threshold Rebalancing SIP","Annual Rebalancing Retirement","Sample Data and analysis"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":331,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Read me first","index":0,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Read me first"]
["1. Equity returns assumed are historical sensex returns computed for each financial year"]
["2. Debt returns are historcial FD returns from RBI website"]
["3. The last few debt returns (in red) have been added by hand as I could not get hold of actual data"]
["4. Rebalancing a porfolio may involve transaction costs especially in SIP mode if the holding period of equity is less than an year"]
["5. Debt instruments are taxable* so the final corpus will be lower in both cases and this tax may impact the benefit of rebalancing"]
["6. The rebalancing shown here is done during the growth phase of the portfolio when the goal if far away"]
["7. Close to goal (2-3 year) the equity component will be gradually or abruptly decreased and pushed to debt"]
["8. The above step does not constitute rebalancing is the sense that it is usually used"]
["9. The tool is only an indicator you would need to make a suitable choice depending on your personal situation."]
["* If the direct tax code comes to effect long term equity investments will also become taxable "]

{"sheet":"Rebalancing Illustration","index":1,"n_rows":27,"n_cols":15,"rows_kept":27,"cut":false,"hidden":false,"merged":[[3,11,3,12],[3,13,3,14],[2,11,2,14],[11,11,11,14],[12,11,12,12],[12,13,12,14]]}
["This is an illustration of portfolio rebalancing as found at"]
["http://www.jagoinvestor.com/2008/07/portfolio-rebalancing-today-i-am-going.html"]
["An investment of 1 lakhs is considered. Of this 30% is invested in equity and 70% in debt instruments",null,null,null,null,null,null,null,null,null,null,"Asset Allocation"]
["No Rebalancing. No futher changes are then made. The money is allowed to grow.",null,null,null,null,null,null,null,null,null,null,"Before investment",null,"After Investment."]
["Year","Sensex","investment","Total Equity",null,"FD","investment","Total FD","Total Corpus","Equity","Debt","Equity","Debt","Equity","Debt"]
[null,"return ",null,null,null,"return"]
[1,0.3,30000,{"$f":"IF(A7=0,0,(C7+D6)*(1+B7))","v":39000},null,0.09,70000,{"$f":"IF(A7=0,0,(G7+H6)*(1+F7))","v":76300},{"$f":"D7+H7","v":115300},{"$f":"IF(A7=0,0,D7/(D7+H7))","v":0.33824804856895058},{"$f":"IF(A7=0,0,H7/(D7+H7))","v":0.66175195143104948},{"$f":"C7/(C7+G7)","v":0.3},{"$f":"G7/(C7+G7)","v":0.7},{"$f":"D7/I7","v":0.33824804856895058},{"$f":"H7/I7","v":0.66175195143104948}]
[2,-0.35,{"$f":"IF(A8=0,0,(D7))","v":39000},{"$f":"IF(A8=0,0,(C8)*(1+B8))","v":25350},null,0.09,{"$f":"IF(A8=0,0,(H7) )","v":76300},{"$f":"IF(A8=0,0,(G8)*(1+F8))","v":83167},{"$f":"D8+H8","v":108517},{"$f":"IF(A8=0,0,D8/(D8+H8))","v":0.2336039514546108},{"$f":"IF(A8=0,0,H8/(D8+H8))","v":0.76639604854538923},{"$f":"C8/(C8+G8)","v":0.33824804856895058},{"$f":"G8/(C8+G8)","v":0.66175195143104948},{"$f":"D8/I8","v":0.2336039514546108},{"$f":"H8/I8","v":0.76639604854538923}]
[3,0.4,{"$f":"IF(A9=0,0,(D8))","v":25350},{"$f":"IF(A9=0,0,(C9)*(1+B9))","v":35490},null,0.09,{"$f":"IF(A9=0,0,(H8) )","v":83167},{"$f":"IF(A9=0,0,(G9)*(1+F9))","v":90652.030000000013},{"$f":"D9+H9","v":126142.03000000001},{"$f":"IF(A9=0,0,D9/(D9+H9))","v":0.28134952323186807},{"$f":"IF(A9=0,0,H9/(D9+H9))","v":0.71865047676813198},0.2336039514546108,0.76639604854538923,0.28134952323186807,0.71865047676813198]
[4,0.6,35490,56784,null,0.09,{"$f":"IF(A10=0,0,(H9) )","v":90652.030000000013},{"$f":"IF(A10=0,0,(G10)*(1+F10))","v":98810.712700000018},{"$f":"D10+H10","v":155594.71270000003},{"$f":"IF(A10=0,0,D10/(D10+H10))","v":0.36494813361354012},{"$f":"IF(A10=0,0,H10/(D10+H10))","v":0.63505186638645983},0.28134952323186807,0.71865047676813198,0.36494813361354012,0.63505186638645983]
[5,-0.3,56784,39748.799999999996,null,0.09,{"$f":"IF(A11=0,0,(H10) )","v":98810.712700000018},{"$f":"IF(A11=0,0,(G11)*(1+F11))","v":107703.67684300002},{"$f":"D11+H11","v":147452.47684300001},{"$f":"IF(A11=0,0,D11/(D11+H11))","v":0.26957024290831355},{"$f":"IF(A11=0,0,H11/(D11+H11))","v":0.73042975709168645},0.36494813361354012,0.63505186638645983,0.26957024290831355,0.73042975709168645]
[null,null,null,null,null,null,null,null,null,null,null,"Asset Allocation"]
["Rebalancing with 30% equity and 70% debt",null,null,null,null,null,null,null,null,null,null,"Before investment",null,"After Investment."]
["Each year 30% of total corpus earned is invested in equity and 70% in debt irrespective of returns earned the previous year",null,null,null,null,null,null,null,null,null,null,"Equity","Debt","Equity","Debt"]
["Year","Sensex","Investment","Total Equity",null,"FD","Investment","Total","Total Corpus","Equity","Debt"]
[null,"return ",null,null,null,"return"]
[1,0.3,30000,{"$f":"IF(A17=0,0,(C17)*(1+B17))","v":39000},null,0.09,70000,{"$f":"IF(A17=0,0,(G17)*(1+F17))","v":76300},{"$f":"D17+H17","v":115300},{"$f":"IF(A17=0,0,D17/(D17+H17))","v":0.33824804856895058},{"$f":"IF(A17=0,0,H17/(D17+H17))","v":0.66175195143104948},{"$f":"C17/(C17+G17)","v":0.3},{"$f":"G17/(C17+G17)","v":0.7},{"$f":"D17/I17","v":0.33824804856895058},{"$f":"H17/I17","v":0.66175195143104948}]
[2,-0.35,{"$f":"IF(A18=0,0,(30%*(D17+H17)))","v":34590},{"$f":"IF(A18=0,0,(C18)*(1+B18))","v":22483.5},null,0.09,{"$f":"IF(A18=0,0,(70%*(H17+D17)))","v":80710},{"$f":"IF(A18=0,0,(G18)*(1+F18))","v":87973.900000000009},{"$f":"D18+H18","v":110457.40000000001},{"$f":"IF(A18=0,0,D18/(D18+H18))","v":0.20354906054279748},{"$f":"IF(A18=0,0,H18/(D18+H18))","v":0.79645093945720247},{"$f":"C18/(C18+G18)","v":0.3},{"$f":"G18/(C18+G18)","v":0.7},{"$f":"D18/I18","v":0.20354906054279748},{"$f":"H18/I18","v":0.79645093945720247}]
[3,0.4,{"$f":"IF(A19=0,0,(30%*(D18+H18)))","v":33137.22},{"$f":"IF(A19=0,0,(C19)*(1+B19))","v":46392.108},null,0.09,{"$f":"IF(A19=0,0,(70%*(H18+D18)))","v":77320.180000000008},{"$f":"IF(A19=0,0,(G19)*(1+F19))","v":84278.996200000009},{"$f":"D19+H19","v":130671.1042},{"$f":"IF(A19=0,0,D19/(D19+H19))","v":0.35502958579881655},{"$f":"IF(A19=0,0,H19/(D19+H19))","v":0.64497041420118351},{"$f":"C19/(C19+G19)","v":0.3},{"$f":"G19/(C19+G19)","v":0.70000000000000007},0.35502958579881655,{"$f":"H19/I19","v":0.64497041420118351}]
[4,0.6,{"$f":"IF(A20=0,0,(30%*(D19+H19)))","v":39201.331259999999},{"$f":"IF(A20=0,0,(C20)*(1+B20))","v":62722.130016000003},null,0.09,{"$f":"IF(A20=0,0,(70%*(H19+D19)))","v":91469.772939999995},{"$f":"IF(A20=0,0,(G20)*(1+F20))","v":99702.052504599997},{"$f":"D20+H20","v":162424.18252060001},{"$f":"IF(A20=0,0,D20/(D20+H20))","v":0.38616251005631536},{"$f":"IF(A20=0,0,H20/(D20+H20))","v":0.61383748994368459},{"$f":"C20/(C20+G20)","v":0.3},{"$f":"G20/(C20+G20)","v":0.7},0.38616251005631536,{"$f":"H20/I20","v":0.61383748994368459}]
[5,-0.3,{"$f":"IF(A21=0,0,(30%*(D20+H20)))","v":48727.254756180002},{"$f":"IF(A21=0,0,(C21)*(1+B21))","v":34109.078329326003},null,0.09,{"$f":"IF(A21=0,0,(70%*(H20+D20)))","v":113696.92776442},{"$f":"IF(A21=0,0,(G21)*(1+F21))","v":123929.65126321782},{"$f":"D21+H21","v":158038.72959254382},{"$f":"IF(A21=0,0,D21/(D21+H21))","v":0.21582733812949639},{"$f":"IF(A21=0,0,H21/(D21+H21))","v":0.78417266187050361},{"$f":"C21/(C21+G21)","v":0.3},{"$f":"G21/(C21+G21)","v":0.7},0.21582733812949639,{"$f":"H21/I21","v":0.78417266187050361}]
[]
["In this case the rebalanced porfolio has done better. "]
["Is rebalancing crucial? It can be most times. The most important thing is what is your expected corpus for a goal. If this amount"]
["is lower then the corpus achieved with no rebalancing than your goal can be achieved."]
["However there is no way of knowing this.  Have a look at the sample data. It seems advantageous more often to rebalance"]
["In this example the rebalanced portfolio is 7% higher. A difference of greater than 5% can be taken as significant."]

{"sheet":"Annual Rebalancing Lumpsum","index":2,"n_rows":38,"n_cols":38,"rows_kept":38,"cut":false,"hidden":false,"merged":[[19,0,19,2],[20,0,20,2],[17,0,17,2],[1,23,1,24],[2,23,2,24],[1,9,1,10],[0,13,0,24],[0,26,0,37],[1,36,1,37],[2,36,2,37],[18,0,18,2]]}
["Enter data only in green cells",null,null,null,null,null,null,null,null,null,null,null,null,"No Rebalancing",null,null,null,null,null,null,null,null,null,null,null,null,"Annual Rebalancing"]
["Enter no of years (max 32)",null,null,25,null,null,null,null,null,"Annual CAGR",null,null,null,"Year of","Year","Sensex","investment","Total Corpus",null,"FD","Monthly","Total",null,"Asset Allocation",null,null,"Year of","Year","Sensex","Investment","Total",null,"FD","Monthly","Total",null,"Asset Allocation"]
["Choose a starting year between",null,null,1980,"and",{"$f":"2011-time1+1","v":1987},null,null,null,"No","With",null,null,"return",null,"return ",null,null,null,"return",null,null,null,"After Investment",null,null,"return",null,"return ",null,null,null,"return",null,null,null,"After investment"]
["Starting year",null,1987,null,null,null,null,null,null,"Rebalancing","Rebalancing",null,null,null,null,null,null,null,null,null,null,null,null,"Equity","Debt",null,null,null,null,null,null,null,null,null,null,null,"Equity","Debt"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(O5=0,\"\",((R5+V5)/cont1)^(1/O5)-1)","v":""},{"$f":"IF(O5=0,\"\",((AE5+AI5)/cont1)^(1/O5)-1)","v":""},null,null,1980,{"$f":"IF(T3=start-1+time1,0,IF(O3<>0,O3+1,IF(N5=start,1,0)))","v":0},0.34899276658629547,{"$f":"IF(T3=start-1+time1,0,IF(N5=start,cont1*eqper,0))","v":0},{"$f":"IF(O5=0,0,(Q5+R3)*(1+P5))","v":0},{"$f":"IF(O5=time1,R5,0)","v":0},7.4999999999999997E-2,{"$f":"IF(T3=start-1+time1,0,IF(N5=start,cont1*bondper,0))","v":0},{"$f":"IF(O5=0,0,(U5+V3)*(1+T5))","v":0},{"$f":"IF(O5=time1,V5,0)","v":0},{"$f":"IF(O5=0,0,R5/(R5+V5))","v":0},{"$f":"IF(O5=0,0,V5/(R5+V5))","v":0},null,1980,{"$f":"IF(AG3=start-1+time1,0,IF(AB3<>0,AB3+1,IF(AA5=start,1,0)))","v":0},0.34899276658629547,{"$f":"IF(AG3=start-1+time1,0,IF(AA5=start,cont1*eqper,0))","v":0},{"$f":"IF(AB5=0,0,(AD5+eqper*(AE3+AI3))*(1+AC5))","v":0},{"$f":"IF(AB5=time1,AE5,0)","v":0},7.4999999999999997E-2,{"$f":"IF(AG3=start-1+time1,0,IF(AA5=start,cont1*bondper,0))","v":0},{"$f":"IF(AB5=0,0,(AH5+bondper*(AE3+AI3))*(1+AG5))","v":0},{"$f":"IF(AB5=time1,AI5,0)","v":0},{"$f":"IF(AB5=0,0,AE5/(AE5+AI5))","v":0},{"$f":"IF(AB5=0,0,AI5/(AE5+AI5))","v":0}]
["Lumpsum investment",null,null,100,null,null,null,null,null,{"$f":"IF(O6=0,\"\",((R6+V6)/cont1)^(1/O6)-1)","v":""},{"$f":"IF(O6=0,\"\",((AE6+AI6)/cont1)^(1/O6)-1)","v":""},null,null,{"$f":"N5+1","v":1981},{"$f":"IF(N5=start-1+time1,0,IF(O5<>0,O5+1,IF(N6=start,1,0)))","v":0},0.25524677121771222,{"$f":"IF(T5=start-1+time1,0,IF(N6=start,cont1*eqper,0))","v":0},{"$f":"IF(O6=0,0,(Q6+R5)*(1+P6))","v":0},0,0.08,{"$f":"IF(T5=start-1+time1,0,IF(N6=start,cont1*bondper,0))","v":0},{"$f":"IF(O6=0,0,(U6+V5)*(1+T6))","v":0},0,0,0,null,{"$f":"AA5+1","v":1981},{"$f":"IF(AA5=start-1+time1,0,IF(AB5<>0,AB5+1,IF(AA6=start,1,0)))","v":0},0.25524677121771222,{"$f":"IF(AG5=start-1+time1,0,IF(AA6=start,cont1*eqper,0))","v":0},{"$f":"IF(AB6=0,0,(AD6+eqper*(AE5+AI5))*(1+AC6))","v":0},0,0.08,{"$f":"IF(AG5=start-1+time1,0,IF(AA6=start,cont1*bondper,0))","v":0},{"$f":"IF(AB6=0,0,(AH6+bondper*(AE5+AI5))*(1+AG6))","v":0},0,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(O7=0,\"\",((R7+V7)/cont1)^(1/O7)-1)","v":""},{"$f":"IF(O7=0,\"\",((AE7+AI7)/cont1)^(1/O7)-1)","v":""},null,null,{"$f":"N6+1","v":1982},0,-2.8478250884203839E-2,0,0,0,0.08,0,0,0,0,0,null,{"$f":"AA6+1","v":1982},0,-2.8478250884203839E-2,0,0,0,0.08,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(O8=0,\"\",((R8+V8)/cont1)^(1/O8)-1)","v":""},{"$f":"IF(O8=0,\"\",((AE8+AI8)/cont1)^(1/O8)-1)","v":""},null,null,1983,0,0.15989787716892828,0,0,0,0.08,0,0,0,0,0,null,1983,0,0.15989787716892828,0,0,0,0.08,0,0,0,0,0]
["% in equities",0.7,"% in FDs",{"$f":"100%-eqper","v":0.30000000000000004},null,null,null,null,null,{"$f":"IF(O9=0,\"\",((R9+V9)/cont1)^(1/O9)-1)","v":""},{"$f":"IF(O9=0,\"\",((AE9+AI9)/cont1)^(1/O9)-1)","v":""},null,null,1984,0,0.44238372803978315,0,0,0,0.08,0,0,0,0,0,null,1984,0,0.44238372803978315,0,0,0,0.08,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(O10=0,\"\",((R10+V10)/cont1)^(1/O10)-1)","v":""},{"$f":"IF(O10=0,\"\",((AE10+AI10)/cont1)^(1/O10)-1)","v":""},null,null,1985,0,0.62242129655796075,0,0,0,8.5000000000000006E-2,0,0,0,0,0,null,1985,0,0.62242129655796075,0,0,0,8.5000000000000006E-2,0,0,0,0,0]
["Total must be 100%",null,null,null,null,null,null,null,null,{"$f":"IF(O11=0,\"\",((R11+V11)/cont1)^(1/O11)-1)","v":""},{"$f":"IF(O11=0,\"\",((AE11+AI11)/cont1)^(1/O11)-1)","v":""},null,null,1986,0,-0.11104143805194128,0,0,0,8.5000000000000006E-2,0,0,0,0,0,null,1986,0,-0.11104143805194128,0,0,0,8.5000000000000006E-2,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(O12=0,\"\",((R12+V12)/cont1)^(1/O12)-1)","v":-0.12660333881965669},{"$f":"IF(O12=0,\"\",((AE12+AI12)/cont1)^(1/O12)-1)","v":-0.12660333881965669},null,null,1987,1,-0.21943334117093818,70,54.639666118034327,0,0.09,30.000000000000004,32.700000000000003,0,0.62559966790108967,0.37440033209891038,null,1987,1,-0.21943334117093818,70,54.639666118034327,0,0.09,30.000000000000004,32.700000000000003,0,0.62559966790108967,0.37440033209891038]
[null,"Equity corpus","Debt Corpus","Total corpus","% Equity","%Debt","CAGR",null,null,{"$f":"IF(O13=0,\"\",((R13+V13)/cont1)^(1/O13)-1)","v":0.15550425828562653},{"$f":"IF(O13=0,\"\",((AE13+AI13)/cont1)^(1/O13)-1)","v":0.17505797212149043},null,null,1988,2,0.79129954564851768,0,97.876009091621597,0,0.09,0,35.643000000000008,0,0.73304924712599129,0.26695075287400877,null,1988,2,0.79129954564851768,0,109.51605296402968,0,0.09,0,28.560070820597232,0,0.79315706410511899,0.20684293589488092]
["no rebalancing",{"$f":"MAX(S2:S57)","v":2387.1267340700674},{"$f":"MAX(W2:W57)","v":247.39399919743246},{"$f":"B14+C14","v":2634.5207332675},{"$f":"B14/D14","v":0.9060952544144153},{"$f":"C14/D14","v":9.3904745585584634E-2},{"$f":"(D14/cont1)^(1/time1)-1","v":0.13979845730760765},null,null,{"$f":"IF(O14=0,\"\",((R14+V14)/cont1)^(1/O14)-1)","v":0.13439070686789822},{"$f":"IF(O14=0,\"\",((AE14+AI14)/cont1)^(1/O14)-1)","v":0.14710024137852784},null,null,1989,3,9.4520739910313803E-2,0,107.12732189043028,0,0.09,0,38.850870000000015,0,0.73385839695040833,0.26614160304959161,null,1989,3,9.4520739910313803E-2,0,105.78902681808857,0,0.09,0,45.150892477573016,0,0.70086844694059158,0.29913155305940842]
["annual rebalancing",{"$f":"MAX(AF3:AF58)","v":2185.8160302788833},{"$f":"MAX(AJ3:AJ58)","v":1161.7526780909513},{"$f":"B15+C15","v":3347.5687083698349},{"$f":"B15/D15","v":0.65295628580042198},{"$f":"C15/D15","v":0.34704371419957797},{"$f":"(D15/cont1)^(1/time1)-1","v":0.15077171825283542},null,null,{"$f":"IF(O15=0,\"\",((R15+V15)/cont1)^(1/O15)-1)","v":0.19297085272376746},{"$f":"IF(O15=0,\"\",((AE15+AI15)/cont1)^(1/O15)-1)","v":0.19999507521759363},null,null,1990,4,0.49538441841111336,0,160.19652794106122,0,0.09,0,42.347448300000018,0,0.79092220323748619,0.20907779676251376,null,1990,4,0.49538441841111336,0,157.99924240167431,0,0.09,0,49.357353609681347,0,0.76196873135890819,0.23803126864109181]
["The % equity and debt shown here represents the final asset allocation",null,null,null,null,null,null,null,null,{"$f":"IF(O16=0,\"\",((R16+V16)/cont1)^(1/O16)-1)","v":0.44735634812099323},{"$f":"IF(O16=0,\"\",((AE16+AI16)/cont1)^(1/O16)-1)","v":0.43201251150717113},null,null,1991,5,2.6687586153753942,0,587.72239203699337,0,0.12,0,47.429142096000021,0,0.925326257519408,7.4673742480591887E-2,null,1991,5,2.6687586153753942,0,532.5189086501033,0,0.12,0,69.671816259815515,0,0.88430274101242978,0.1156972589875702]
["% difference bet the two corpuses",null,{"$f":"(D15-D14)/D14","v":0.27065567034576626},null,null,null,null,null,null,{"$f":"IF(O17=0,\"\",((R17+V17)/cont1)^(1/O17)-1)","v":0.24108722292400264},{"$f":"IF(O17=0,\"\",((AE17+AI17)/cont1)^(1/O17)-1)","v":0.27265299667956411},null,null,1992,6,-0.4677899649941657,0,312.79175483972091,0,0.11,0,52.64634772656003,0,0.85593634775122729,0.14406365224877271,null,1992,6,-0.4677899649941657,0,224.34436274914762,0,0.11,0,200.52951139500303,0,0.52802578930290345,0.4719742106970965]
["+ve means rebalanced portfolio is higher",null,null,null,null,null,null,null,null,{"$f":"IF(O18=0,\"\",((R18+V18)/cont1)^(1/O18)-1)","v":0.28427063791361995},{"$f":"IF(O18=0,\"\",((AE18+AI18)/cont1)^(1/O18)-1)","v":0.30163829029997324},null,null,1993,7,0.65707382526792135,0,518.31902970452222,0,0.1,0,57.91098249921604,0,0.89950023207270846,0.10049976792729148,null,1993,7,0.65707382526792135,0,492.83316311911437,0,0.1,0,140.20837846756976,0,0.77851630697703489,0.22148369302296511]
["Click on the macro to find out the % difference",null,null,null,null,null,null,null,null,{"$f":"IF(O19=0,\"\",((R19+V19)/cont1)^(1/O19)-1)","v":0.22633979654332825},{"$f":"IF(O19=0,\"\",((AE19+AI19)/cont1)^(1/O19)-1)","v":0.24924885303200517},null,null,1994,8,-0.13708160116856616,0,447.2670271964887,0,0.11,0,64.281190574129809,0,0.87433991881689266,0.12566008118310737,null,1994,8,-0.13708160116856616,0,382.38423542183483,0,0.11,0,210.80283334836588,0,0.64462672157469025,0.35537327842530969]
["between the two corpuses for all possible ",null,null,null,null,null,null,null,null,{"$f":"IF(O20=0,\"\",((R20+V20)/cont1)^(1/O20)-1)","v":0.20452430068669569},{"$f":"IF(O20=0,\"\",((AE20+AI20)/cont1)^(1/O20)-1)","v":0.22648367085282461},null,null,1995,9,3.2398434816741109E-2,0,461.75777882279175,0,0.12,0,71.994933443025388,0,0.8651155642143683,0.13488443578563175,null,1995,9,3.2398434816741109E-2,0,428.68378094632016,0,0.12,0,199.3108551067875,0,0.68262331608524696,0.31737668391475299]
["investment durations between",null,null,null,null,null,null,null,null,{"$f":"IF(O21=0,\"\",((R21+V21)/cont1)^(1/O21)-1)","v":0.1840457186274651},{"$f":"IF(O21=0,\"\",((AE21+AI21)/cont1)^(1/O21)-1)","v":0.20581778010924912},null,null,1996,10,-1.6990384986678749E-3,0,460.97323457951245,0,0.12,0,80.634325456188449,0,0.85112038419317249,0.14887961580682757,null,1996,10,-1.6990384986678749E-3,0,438.84935429264755,0,0.12,0,211.00619771384424,0,0.675302923761531,0.32469707623846905]
[{"$f":"D3","v":1980},"and",{"$f":"F3","v":1987},null,null,null,null,null,null,{"$f":"IF(O22=0,\"\",((R22+V22)/cont1)^(1/O22)-1)","v":0.18100894925133049},{"$f":"IF(O22=0,\"\",((AE22+AI22)/cont1)^(1/O22)-1)","v":0.20004111070399455},null,null,1997,11,0.15824974932235217,0,533.92213339603416,0,0.11,0,89.504101256369182,0,0.85643193006423135,0.14356806993576871,null,1997,11,0.15824974932235217,0,526.88652114508045,0,0.11,0,216.40189881816181,0,0.70885877809200426,0.29114122190799568]
["Average % difference bet the two corpuses",null,null,{"$f":"AVERAGE(B26:B48)","v":0.14664428892898157},null,null,null,null,null,{"$f":"IF(O23=0,\"\",((R23+V23)/cont1)^(1/O23)-1)","v":0.16293327939584157},{"$f":"IF(O23=0,\"\",((AE23+AI23)/cont1)^(1/O23)-1)","v":0.18233848838020661},null,null,1998,12,-3.9249887611585633E-2,0,512.96574966690173,0,0.105,0,98.902031888287951,0,0.83836045160458061,0.16163954839541933,null,1998,12,-3.9249887611585633E-2,0,499.88010311168432,0,0.105,0,246.40011121781484,0,0.6698289643934956,0.33017103560650446]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(O24=0,\"\",((R24+V24)/cont1)^(1/O24)-1)","v":0.17269866456982119},{"$f":"IF(O24=0,\"\",((AE24+AI24)/cont1)^(1/O24)-1)","v":0.18825305060737274},null,null,1999,13,0.33725494390314326,0,685.96598479504655,0,8.5000000000000006E-2,0,107.30870459879242,0,0.86472692746469737,0.13527307253530257,null,1999,13,0.33725494390314326,0,698.576834304454,0,8.5000000000000006E-2,0,242.91420976425201,0,0.74198988796060683,0.25801011203939306]
["Year","% difference",null,null,null,null,null,null,null,{"$f":"IF(O25=0,\"\",((R25+V25)/cont1)^(1/O25)-1)","v":0.13798263439855951},{"$f":"IF(O25=0,\"\",((AE25+AI25)/cont1)^(1/O25)-1)","v":0.15818401658534809},null,null,2000,14,-0.27930849702476163,0,494.36985657183158,0,8.5000000000000006E-2,0,116.42994448968977,0,0.8093811682856743,0.19061883171432575,null,2000,14,-0.27930849702476163,0,474.96721691132149,0,8.5000000000000006E-2,0,306.45533484436385,0,0.60782378988701324,0.39217621011298665]
[1980,0.10433950773826431,null,null,null,null,null,null,null,{"$f":"IF(O26=0,\"\",((R26+V26)/cont1)^(1/O26)-1)","v":0.12700417052904545},{"$f":"IF(O26=0,\"\",((AE26+AI26)/cont1)^(1/O26)-1)","v":0.14661523886664241},null,null,2001,15,-3.7462753649726219E-2,0,475.84940042323058,0,7.4999999999999997E-2,0,125.16219032641651,0,0.79174746002768326,0.20825253997231666,null,2001,15,-3.7462753649726219E-2,0,526.50381784204512,0,7.4999999999999997E-2,0,252.00877294120858,0,0.67629454433400349,0.32370545566599646]
[1981,5.4527041130009266E-2,null,null,null,null,null,null,null,{"$f":"IF(O27=0,\"\",((R27+V27)/cont1)^(1/O27)-1)","v":0.11225758639828398},{"$f":"IF(O27=0,\"\",((AE27+AI27)/cont1)^(1/O27)-1)","v":0.13154639141650892},null,null,2002,16,-0.12124173116001562,0,418.15659534446263,0,4.2500000000000003E-2,0,130.48158341528921,0,0.762171885831469,0.23782811416853109,null,2002,16,-0.12124173116001562,0,478.88706358277625,0,4.2500000000000003E-2,0,243.47981276746262,0,0.6629416149344427,0.3370583850655573]
[1982,6.961731037630732E-2,null,null,null,null,null,null,null,{"$f":"IF(O28=0,\"\",((R28+V28)/cont1)^(1/O28)-1)","v":0.13815834625027712},{"$f":"IF(O28=0,\"\",((AE28+AI28)/cont1)^(1/O28)-1)","v":0.15465518343448736},null,null,2003,17,0.8337531816631244,0,766.79598714632789,0,0.04,0,135.70084675190077,0,0.84963842347705865,0.1503615765229413,null,2003,17,0.8337531816631244,0,927.24979048471209,0,0.04,0,225.37846542127457,0,0.80446560782589616,0.1955343921741039]
[1983,1.2704611962253079E-2,null,null,null,null,null,null,null,{"$f":"IF(O29=0,\"\",((R29+V29)/cont1)^(1/O29)-1)","v":0.13853791552580241},{"$f":"IF(O29=0,\"\",((AE29+AI29)/cont1)^(1/O29)-1)","v":0.15319866769088675},null,null,2004,18,0.16138160483669003,0,890.54275413433629,0,5.2499999999999998E-2,0,142.82514120637555,0,0.86178674424631252,0.13821325575368748,null,2004,18,0.16138160483669003,0,937.04887753694686,0,5.2499999999999998E-2,0,363.94237180231534,0,0.72025763279564592,0.27974236720435414]
[1984,0.21754771594892322,null,null,null,null,null,null,null,{"$f":"IF(O30=0,\"\",((R30+V30)/cont1)^(1/O30)-1)","v":0.16075563704370999},{"$f":"IF(O30=0,\"\",((AE30+AI30)/cont1)^(1/O30)-1)","v":0.17065245198168433},null,null,2005,19,0.737303667743754,0,1547.1431930402066,0,0.06,0,151.3946496787581,0,0.91086766166103761,8.9132338338962419E-2,null,2005,19,0.737303667743754,0,1582.15180842574,0,0.06,0,413.7152172898854,0,0.79271403757895831,0.20728596242104169]
[1985,0.17820521757974506,null,null,null,null,null,null,null,{"$f":"IF(O31=0,\"\",((R31+V31)/cont1)^(1/O31)-1)","v":0.16022980150979227},{"$f":"IF(O31=0,\"\",((AE31+AI31)/cont1)^(1/O31)-1)","v":0.16858355339458075},null,null,2006,20,0.15887411347517733,0,1792.9441962536243,0,6.25E-2,0,160.85681528368048,0,0.91766980652901087,8.2330193470989077E-2,null,2006,20,0.15887411347517733,0,1619.0710410283737,0,6.25E-2,0,636.18261444685572,0,0.71791083770007291,0.28208916229992703]
[1986,0.26555723635058404,null,null,null,null,null,null,null,{"$f":"IF(O32=0,\"\",((R32+V32)/cont1)^(1/O32)-1)","v":0.16146002258995318},{"$f":"IF(O32=0,\"\",((AE32+AI32)/cont1)^(1/O32)-1)","v":0.16811313864399691},null,null,2007,21,0.19677787042632777,0,2145.7559369856567,0,7.0000000000000007E-2,0,172.11679235353813,0,0.92574363977153862,7.4256360228461341E-2,null,2007,21,0.19677787042632777,0,1889.3263669495857,0,7.0000000000000007E-2,0,723.93642340754877,0,0.72297603360869267,0.27702396639130727]
[1987,0.27065567034576626,null,null,null,null,null,null,null,{"$f":"IF(O33=0,\"\",((R33+V33)/cont1)^(1/O33)-1)","v":0.13158577203831512},{"$f":"IF(O33=0,\"\",((AE33+AI33)/cont1)^(1/O33)-1)","v":0.14540291366528457},null,null,2008,22,-0.37942650405256834,0,1331.5992632651457,0,0.08,0,185.88613574182119,0,0.87750383900664619,0.12249616099335384,null,2008,22,-0.37942650405256834,0,1135.2051379488869,0,0.08,0,846.69714407571178,0,0.57278562532822042,0.42721437467177953]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(O34=0,\"\",((R34+V34)/cont1)^(1/O34)-1)","v":0.15230739158419504},{"$f":"IF(O34=0,\"\",((AE34+AI34)/cont1)^(1/O34)-1)","v":0.16187636175865494},null,null,2009,23,0.80532523046814641,0,2403.9697468453633,0,0.09,0,202.61588795858512,0,0.92226770329230923,7.7732296707690815E-2,null,2009,23,0.80532523046814641,0,2504.5847358429824,0,0.09,0,648.08204622204391,0,0.79443369977795619,0.20556630022204378]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(O35=0,\"\",((R35+V35)/cont1)^(1/O35)-1)","v":0.15045654767167149},{"$f":"IF(O35=0,\"\",((AE35+AI35)/cont1)^(1/O35)-1)","v":0.15951906480427613},null,null,2010,24,0.10943116334797741,0,2667.038952895994,0,0.1,0,222.87747675444365,0,0.92287753567275199,7.7122464327247953E-2,null,2010,24,0.10943116334797741,0,2448.3667429724483,0,0.1,0,1040.3800380814589,0,0.70178975334885918,0.29821024665114071]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(O36=0,\"\",((R36+V36)/cont1)^(1/O36)-1)","v":0.13979845730760765},{"$f":"IF(O36=0,\"\",((AE36+AI36)/cont1)^(1/O36)-1)","v":0.15077171825283542},null,null,2011,25,-0.10495242993057337,0,2387.1267340700674,2387.1267340700674,0.11,0,247.39399919743246,247.39399919743246,0.9060952544144153,9.3904745585584634E-2,null,2011,25,-0.10495242993057337,0,2185.8160302788833,2185.8160302788833,0.11,0,1161.7526780909513,1161.7526780909513,0.65295628580042198,0.34704371419957797]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Note 35% returns listed against 1980 actually is the return"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"generated in the financial year 1980-1981"]

{"sheet":"Annual Rebalancing SIP","index":3,"n_rows":43,"n_cols":40,"rows_kept":43,"cut":false,"hidden":false,"merged":[[19,0,19,2],[20,0,20,2],[17,0,17,2],[0,7,0,20],[1,19,1,22],[3,19,3,20],[3,21,3,22],[0,24,0,39],[3,36,3,37],[3,38,3,39],[1,36,1,39],[18,0,18,2]]}
["Enter data only in green cells",null,null,null,null,null,null,"No Rebalancing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Rebalancing"]
["Enter no of years (max 32)",null,null,15,null,null,null,"Year of","Year","Sensex","Annual","invest. From","Total Equity",null,"FD","Annual","invest. From","Total Debt ",null,"Asset Allocation",null,null,null,null,"Year of","Year","Sensex","Annual","invest. From","Total Equity",null,"FD","Annual","invest. From","Total Debt ",null,"Asset Allocation"]
["Choose a starting year between",null,null,1980,"and",{"$f":"2011-time1+1","v":1997},null,"return",null,"return","investment","Previous","Corpus",null,"return","investment","Previous","Corpus",null,"Equity","Debt","Equity","Debt",null,null,null,"return ","Investment","Previous","Corpus",null,"return","investment","Previous","Corpus",null,"Equity","Debt","Equity","Debt"]
["Starting year",null,1980,null,null,null,null,null,null,null,null,"year",null,null,null,null,"year",null,null,"Prior investment",null,"After investment",null,null,"return",null,null,null,"year",null,null,null,null,"year",null,null,"Prior investment",null,"After investment"]
[null,null,null,null,null,null,null,1980,{"$f":"IF(H4=start-1+time1,0,IF(I4<>0,I4+1,IF(H5=start,1,0)))","v":1},0.34899276658629547,{"$f":"IF(I5=0,0,IF(O4=start-1+time1,0,IF(K4<>0,K4*(1+inca),IF(H5=start,12*cont1*eqper,0))))","v":84000},{"$f":"IF(I5=1,0,IF(I5=0,0,M4))","v":0},{"$f":"IF(I5=0,0,IF(I5=1,K5*(1+J5),(L5+K5)*(1+J5)))","v":113315.39239324883},{"$f":"IF(I5=time1,M5,0)","v":0},7.4999999999999997E-2,{"$f":"IF(I5=0,0,IF(O4=start-1+time1,0,IF(P4<>0,P4*(1+inca),IF(H5=start,12*cont1*bondper,0))))","v":36000.000000000007},{"$f":"IF(I5=1,0,IF(I5=0,0,R4))","v":0},{"$f":"IF(I5=0,0,IF(I5=1,P5*(1+O5),(Q5+P5)*(1+O5)))","v":38700.000000000007},{"$f":"IF(I5=time1,R5,0)","v":0},{"$f":"IF(I5=0,0,(K5+L5)/(K5+L5+P5+Q5))","v":0.7},{"$f":"IF(I5=0,0,(P5+Q5)/(K5+L5+P5+Q5))","v":0.30000000000000004},{"$f":"IF(I5=0,0,M5/(M5+R5))","v":0.7454205170231254},{"$f":"IF(I5=0,0,R5/(M5+R5))","v":0.25457948297687466},null,1980,{"$f":"IF(AF4=start-1+time1,0,IF(Z4<>0,Z4+1,IF(Y5=start,1,0)))","v":1},0.34899276658629547,{"$f":"IF(Z5=0,0,IF(AF4=start-1+time1,0,IF(AB4<>0,AB4*(1+inca),IF(Y5=start,12*cont1*eqper,0))))","v":84000},{"$f":"IF(Z5=1,0,IF(Z5=0,0,eqper*(AD4+AI4)))","v":0},{"$f":"IF(Z5=0,0,(AB5+AC5)*(1+AA5))","v":113315.39239324883},{"$f":"IF(Z5=time1,AD5,0)","v":0},7.4999999999999997E-2,{"$f":"IF(Z5=0,0,IF(AF4=start-1+time1,0,IF(AG4<>0,AG4*(1+inca),IF(Y5=start,12*cont1*bondper,0))))","v":36000.000000000007},{"$f":"IF(Z5=1,0,IF(Z5=0,0,bondper*(AD4+AI4)))","v":0},{"$f":"IF(Z5=0,0,(AG5+AH5)*(1+AF5))","v":38700.000000000007},{"$f":"IF(Z5=time1,AI5,0)","v":0},{"$f":"IF(Z5=0,0,(AB5+AC5)/(AB5+AC5+AG5+AH5))","v":0.7},{"$f":"IF(Z5=0,0,(AG5+AH5)/(AB5+AC5+AG5+AH5))","v":0.30000000000000004},{"$f":"IF(Z5=0,0,AD5/(AD5+AI5))","v":0.7454205170231254},{"$f":"IF(Z5=0,0,AI5/(AD5+AI5))","v":0.25457948297687466}]
["monthly contribution in 1st year",null,null,10000,null,null,null,{"$f":"H5+1","v":1981},2,0.25524677121771222,84000,{"$f":"IF(I6=1,0,IF(I6=0,0,M5))","v":113315.39239324883},{"$f":"IF(I6=0,0,IF(I6=1,K6*(1+J6),(L6+K6)*(1+J6)))","v":247679.50921318153},0,0.08,36000.000000000007,{"$f":"IF(I6=1,0,IF(I6=0,0,R5))","v":38700.000000000007},{"$f":"IF(I6=0,0,IF(I6=1,P6*(1+O6),(Q6+P6)*(1+O6)))","v":80676.000000000015},0,{"$f":"IF(I6=0,0,(K6+L6)/(K6+L6+P6+Q6))","v":0.72538318753665498},{"$f":"IF(I6=0,0,(P6+Q6)/(K6+L6+P6+Q6))","v":0.27461681246334496},0.75430288898359266,0.24569711101640729,null,{"$f":"Y5+1","v":1981},{"$f":"IF(Y5=start-1+time1,0,IF(Z5<>0,Z5+1,IF(Y6=start,1,0)))","v":2},0.25524677121771222,84000,106410.77467527417,{"$f":"IF(Z6=0,0,(AB6+AC6)*(1+AA6))","v":239012.51011620121},0,0.08,36000.000000000007,45604.617717974652,{"$f":"IF(Z6=0,0,(AG6+AH6)*(1+AF6))","v":88132.987135412637},0,{"$f":"IF(Z6=0,0,(AB6+AC6)/(AB6+AC6+AG6+AH6))","v":0.7},{"$f":"IF(Z6=0,0,(AG6+AH6)/(AB6+AC6+AG6+AH6))","v":0.3000000000000001},{"$f":"IF(Z6=0,0,AD6/(AD6+AI6))","v":0.73060003002997809},{"$f":"IF(Z6=0,0,AI6/(AD6+AI6))","v":0.2693999699700218}]
["% increase or","decrease each year",null,null,null,null,null,{"$f":"H6+1","v":1982},3,-2.8478250884203839E-2,84000,247679.50921318153,322233.85693665897,0,0.08,36000.000000000007,80676.000000000015,126010.08000000005,0,0.73976900561620273,0.26023099438379732,0.71888057011732331,0.28111942988267663,null,{"$f":"Y6+1","v":1982},3,-2.8478250884203839E-2,84000,229001.84807612971,304088.10291939822,0,0.08,36000.000000000007,98143.649175484185,144875.14110952296,0,0.7,0.3000000000000001,0.67731179993836998,0.32268820006163007]
[null,null,null,null,null,null,null,1983,4,0.15989787716892828,84000,322233.85693665897,471189.78829497687,0,0.08,36000.000000000007,126010.08000000005,174970.88640000005,0,0.7148934296186622,0.2851065703813378,0.72921458508350756,0.2707854149164925,null,1983,4,0.15989787716892828,84000,314274.2708202448,461957.48125540483,0,0.08,36000.000000000007,134688.97320867638,184344.09106537051,0,0.69999999999999984,0.30000000000000004,0.71477078354704049,0.28522921645295951]
["% in equities",0.7,"% in FDs",{"$f":"100%-eqper","v":0.30000000000000004},null,null,null,1984,5,0.44238372803978315,84000,471189.78829497687,800796.71661052655,{"$f":"IF(I9=time1,M9,0)","v":0},0.08,36000.000000000007,174970.88640000005,227848.55731200008,0,0.72463884747935992,0.27536115252064008,0.77849647192452787,0.22150352807547211,null,1984,5,0.44238372803978315,84000,452411.10062454274,773710.64308075106,{"$f":"IF(Z9=time1,AD9,0)","v":0},0.08,36000.000000000007,193890.47169623265,248281.70943193129,0,0.7,0.30000000000000004,0.75706108874346956,0.24293891125653042]
[null,null,null,null,null,null,null,1985,6,0.62242129655796075,84000,800796.71661052655,1435513.0361534772,{"$f":"IF(I10=time1,M10,0)","v":0},8.5000000000000006E-2,36000.000000000007,227848.55731200008,286275.68468352006,0,0.77029587523484977,0.22970412476515009,0.83373355788719794,0.16626644211280203,null,1985,6,0.62242129655796075,84000,715394.64675887756,1296954.8992560313,{"$f":"IF(Z10=time1,AD10,0)","v":0},8.5000000000000006E-2,36000.000000000007,306597.70575380477,371718.51074287813,0,0.7,0.30000000000000004,0.77723711032039455,0.22276288967960547]
["Total must be 100%",null,null,null,null,null,null,1986,7,-0.11104143805194128,84000,1435513.0361534772,1350784.1234803235,0,8.5000000000000006E-2,36000.000000000007,286275.68468352006,349669.11788161926,0,0.82502027456381499,0.17497972543618495,0.79436710791203002,0.20563289208797006,null,1986,7,-0.11104143805194128,84000,1168071.3869992364,1113039.5796431524,{"$f":"IF(Z11=time1,AD11,0)","v":0},8.5000000000000006E-2,36000.000000000007,500602.02299967286,582213.19495464512,0,0.7,0.30000000000000004,0.65656260607343553,0.34343739392656442]
[null,null,null,null,null,null,null,1987,8,-0.21943334117093818,84000,1350784.1234803235,1119944.6494060203,0,0.09,36000.000000000007,349669.11788161926,420379.33849096502,0,0.78814664990072081,0.21185335009927919,0.72708382016116502,0.27291617983883493,null,1987,8,-0.21943334117093818,84000,1186676.9422184583,991848.05523859081,0,0.09,36000.000000000007,508575.83237933932,593587.65729348001,0,0.7,0.30000000000000004,0.62559966790108956,0.37440033209891038]
[null,"Equity corpus","Debt Corpus","Total corpus","% Equity","%Debt",null,1988,9,0.79129954564851768,84000,1119944.6494060203,2156625.503466968,0,0.09,36000.000000000007,420379.33849096502,497453.47895515192,0,0.72512633569245211,0.27487366430754778,0.81257020523889056,0.18742979476110935,null,1988,9,0.79129954564851768,84000,1109804.9987724496,2138462.3518940182,0,0.09,36000.000000000007,475630.71375962137,557677.4779979873,0,0.7,0.30000000000000004,0.79315706410511899,0.20684293589488092]
["no rebalancing",{"$f":"MAX(N2:N57)","v":11080814.86524565},{"$f":"MAX(S2:S57)","v":1208986.4898252271},{"$f":"B14+C14","v":12289801.355070876},{"$f":"B14/D14","v":0.9016268485636354},{"$f":"C14/D14","v":9.8373151436364673E-2},null,1989,10,9.4520739910313803E-2,84000,2156625.503466968,2452411.0839165854,0,0.09,36000.000000000007,497453.47895515192,581464.29206111573,0,0.80770068828776465,0.19229931171223538,0.80834272341403213,0.19165727658596796,null,1989,10,9.4520739910313803E-2,84000,1887297.8809244039,2157626.4152130121,0,0.09,36000.000000000007,808841.94896760187,920877.72437468613,0,0.7,0.30000000000000004,0.70086844694059147,0.29913155305940842]
["annual rebalancing",{"$f":"MAX(AE4:AE58)","v":8580916.928613387},{"$f":"MAX(AJ4:AJ58)","v":4730533.9334482644},{"$f":"B15+C15","v":13311450.862061651},{"$f":"B15/D15","v":0.64462672157469025},{"$f":"C15/D15","v":0.35537327842530975},null,1990,11,0.49538441841111336,84000,2452411.0839165854,3792909.6135741048,0,0.09,36000.000000000007,581464.29206111573,673036.07834661624,0,0.80422045310851831,0.19577954689148169,0.84929595548727876,0.15070404451272129,null,1990,11,0.49538441841111336,84000,2154952.8977113888,3348095.2767940219,0,0.09,36000.000000000007,923551.24187630974,1045910.8536451777,0,0.7,0.30000000000000004,0.76196873135890819,0.23803126864109186]
["The % equity and debt shown here represents the final asset allocation",null,null,null,null,null,null,1991,12,2.6687586153753942,84000,3792909.6135741048,14223445.545831688,0,0.12,36000.000000000007,673036.07834661624,794120.40774821024,0,0.84538934257425713,0.15461065742574293,0.94712056466388228,5.287943533611765E-2,null,1991,12,2.6687586153753942,84000,3075804.2913074396,11592559.216634311,0,0.12,36000.000000000007,1318201.8391317599,1516706.0598275713,0,0.7,0.30000000000000004,0.88430274101242978,0.11569725898757019]
["% difference bet the two corpuses",null,{"$f":"(D15-D14)/D14","v":8.3129863329258313E-2},"if started at",{"$f":"start","v":1980},null,null,1992,13,-0.4677899649941657,84000,14223445.545831688,7614566.0947911507,0,0.11,36000.000000000007,794120.40774821024,921433.65260051342,0,0.94516156624560266,5.4838433754397231E-2,0.89205322400787623,0.10794677599212382,null,1992,13,-0.4677899649941657,84000,9176485.6935233176,4928523.4151210729,0,0.11,36000.000000000007,3932779.5829385654,4405345.3370618084,0,0.7,0.30000000000000004,0.52802578930290345,0.47197421069709644]
["+ve means rebalanced portfolio is higher",null,null,null,null,null,null,1993,14,0.65707382526792135,84000,7614566.0947911507,12757092.367773496,0,0.1,36000.000000000007,921433.65260051342,1053177.0178605649,0,0.88939074855114009,0.11060925144886004,0.9237395746272612,7.6260425372738749E-2,null,1993,14,0.65707382526792135,84000,6533708.1265280172,10966030.91973239,0,0.1,36000.000000000007,2800160.6256548651,3119776.6882203519,0,0.7,0.30000000000000004,0.77851630697703489,0.22148369302296514]
["Click on the macro to find out the % difference",null,null,null,null,null,null,1994,15,-0.13708160116856616,84000,12757092.367773496,11080814.86524565,11080814.86524565,0.11,36000.000000000007,1053177.0178605649,1208986.4898252271,1208986.4898252271,0.9218122070931517,7.8187792906848297E-2,0.9016268485636354,9.8373151436364673E-2,null,1994,15,-0.13708160116856616,84000,9860065.3255669195,8580916.928613387,8580916.928613387,0.11,36000.000000000007,4225742.2823858233,4730533.9334482644,4730533.9334482644,0.7,0.3,0.64462672157469025,0.35537327842530975]
["between the two corpuses for all possible ",null,null,null,null,null,null,1995,0,3.2398434816741109E-2,0,0,0,0,0.12,0,0,0,0,0,0,0,0,null,1995,0,3.2398434816741109E-2,0,0,0,0,0.12,0,0,0,0,0,0,0,0]
["investment durations between",null,null,null,null,null,null,1996,0,-1.6990384986678749E-3,0,0,0,0,0.12,0,0,0,0,0,0,0,0,null,1996,0,-1.6990384986678749E-3,0,0,0,0,0.12,0,0,0,0,0,0,0,0]
[{"$f":"D3","v":1980},"and",{"$f":"F3","v":1997},null,null,null,null,1997,0,0.15824974932235217,0,0,0,0,0.11,0,0,0,0,0,0,0,0,null,1997,0,0.15824974932235217,0,0,0,0,0.11,0,0,0,0,0,0,0,0]
["Average % difference bet the two corpuses",null,null,{"$f":"AVERAGE(B26:B48)","v":0.13054108980519613},null,null,null,1998,0,-3.9249887611585633E-2,0,0,0,0,0.105,0,0,0,0,0,0,0,0,null,1998,0,-3.9249887611585633E-2,0,0,0,0,0.105,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,1999,0,0.33725494390314326,0,0,0,0,8.5000000000000006E-2,0,0,0,0,0,0,0,0,null,1999,0,0.33725494390314326,0,0,0,0,8.5000000000000006E-2,0,0,0,0,0,0,0,0]
["Year","% difference",null,null,null,null,null,2000,0,-0.27930849702476163,0,0,0,0,8.5000000000000006E-2,0,0,0,0,0,0,0,0,null,2000,0,-0.27930849702476163,0,0,0,0,8.5000000000000006E-2,0,0,0,0,0,0,0,0]
[1980,7.7421755545598839E-2,null,null,null,null,null,2001,0,-3.7462753649726219E-2,0,0,0,0,7.4999999999999997E-2,0,0,0,0,0,0,0,0,null,2001,0,-3.7462753649726219E-2,0,0,0,0,7.4999999999999997E-2,0,0,0,0,0,0,0,0]
[1981,0.12649156826310287,null,null,null,null,null,2002,0,-0.12124173116001562,0,0,0,0,4.2500000000000003E-2,0,0,0,0,0,0,0,0,null,2002,0,-0.12124173116001562,0,0,0,0,4.2500000000000003E-2,0,0,0,0,0,0,0,0]
[1982,0.16898280245444378,null,null,null,null,null,2003,0,0.8337531816631244,0,0,0,0,0.04,0,0,0,0,0,0,0,0,null,2003,0,0.8337531816631244,0,0,0,0,0.04,0,0,0,0,0,0,0,0]
[1983,0.15814623125018631,null,null,null,null,null,2004,0,0.16138160483669003,0,0,0,0,5.2499999999999998E-2,0,0,0,0,0,0,0,0,null,2004,0,0.16138160483669003,0,0,0,0,5.2499999999999998E-2,0,0,0,0,0,0,0,0]
[1984,0.19836173589813128,null,null,null,null,null,2005,0,0.737303667743754,0,0,0,0,0.06,0,0,0,0,0,0,0,0,null,2005,0,0.737303667743754,0,0,0,0,0.06,0,0,0,0,0,0,0,0]
[1985,0.16774350294017182,null,null,null,null,null,2006,0,0.15887411347517733,0,0,0,0,6.25E-2,0,0,0,0,0,0,0,0,null,2006,0,0.15887411347517733,0,0,0,0,6.25E-2,0,0,0,0,0,0,0,0]
[1986,0.23356791040514169,null,null,null,null,null,2007,0,0.19677787042632777,0,0,0,0,7.0000000000000007E-2,0,0,0,0,0,0,0,0,null,2007,0,0.19677787042632777,0,0,0,0,7.0000000000000007E-2,0,0,0,0,0,0,0,0]
[1987,0.2091251719766902,null,null,null,null,null,2008,0,-0.37942650405256834,0,0,0,0,0.08,0,0,0,0,0,0,0,0,null,2008,0,-0.37942650405256834,0,0,0,0,0.08,0,0,0,0,0,0,0,0]
[1988,0.1732216228652744,null,null,null,null,null,2009,0,0.80532523046814641,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,2009,0,0.80532523046814641,0,0,0,0,0.09,0,0,0,0,0,0,0,0]
[1989,0.18645511262710007,null,null,null,null,null,2010,0,0.10943116334797741,0,0,0,0,0.1,0,0,0,0,0,0,0,0,null,2010,0,0.10943116334797741,0,0,0,0,0.1,0,0,0,0,0,0,0,0]
[1990,0.14918368023234435,null,null,null,null,null,2011,0,-0.10495242993057337,0,0,0,0,0.11,0,0,0,0,0,0,0,0,null,2011,0,-0.10495242993057337,0,0,0,0,0.11,0,0,0,0,0,0,0,0]
[1991,9.7853676586866195E-2,null,null,null,null,null,"Note 35% returns listed against 1980 actually is the return"]
[1992,4.874316573627048E-2,null,null,null,null,null,"generated in the financial year 1980-1981"]
[1993,1.4818852702242905E-2]
[1994,0.11125187491674095]
[1995,7.4583417708813243E-2]
[1996,6.2107760473172367E-2]
[1997,9.167977391123848E-2]

{"sheet":"Variable frequency Rebal. SIP","index":4,"n_rows":48,"n_cols":49,"rows_kept":48,"cut":false,"hidden":false,"merged":[[0,7,0,20],[0,24,0,40],[1,19,1,22],[1,37,1,40],[3,19,3,20],[3,21,3,22],[3,37,3,38],[3,39,3,40],[17,0,17,2],[18,0,18,2],[19,0,19,2],[20,0,20,2],[7,0,7,1]]}
["Enter data only in green cells",null,null,null,null,null,null,"No Rebalancing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Rebalancing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None"]
["Enter no of years (max 32)",null,null,10,null,null,null,"Year of","Year","Sensex","Annual","invest. From","Total Equity",null,"FD","Annual","invest. From","Total Debt ",null,"Asset Allocation",null,null,null,null,"Year of","Year",null,"Sensex","Annual","invest. From","Total Equity",null,"FD","Annual","invest. From","Total Debt ",null,"Asset Allocation",null,null,null,null,null,null,null,null,null,null,1]
["Choose a starting year between",null,null,1980,"and",{"$f":"2011-time1+1","v":2002},null,"return",null,"return","investment","Previous","Corpus",null,"return","investment","Previous","Corpus",null,"Equity","Debt","Equity","Debt",null,null,null,null,"return ","Investment","Previous","Corpus",null,"return","investment","Previous","Corpus",null,"Equity","Debt","Equity","Debt",null,null,null,null,null,null,null,{"$f":"IF(AW2<time1/2,AW2+1,\"\")","v":2}]
["Starting year",null,2002,null,null,null,null,null,null,null,null,"year",null,null,null,null,"year",null,null,"Prior investment",null,"After investment",null,null,"return",null,null,null,null,"year",null,null,null,null,"year",null,null,"Prior investment",null,"After investment",null,null,null,null,null,null,null,null,3]
["monthly contribution in 1st year",null,null,10000,null,null,null,1980,{"$f":"IF(H4=start-1+time1,0,IF(I4<>0,I4+1,IF(H5=start,1,0)))","v":0},0.34899276658629547,{"$f":"IF(I5=0,0,IF(O4=start-1+time1,0,IF(K4<>0,K4*(1+inca),IF(H5=start,12*cont1*eqper,0))))","v":0},{"$f":"IF(I5=1,0,IF(I5=0,0,M4))","v":0},{"$f":"IF(I5=0,0,IF(I5=1,K5*(1+J5),(L5+K5)*(1+J5)))","v":0},{"$f":"IF(I5=time1,M5,0)","v":0},7.4999999999999997E-2,{"$f":"IF(I5=0,0,IF(O4=start-1+time1,0,IF(P4<>0,P4*(1+inca),IF(H5=start,12*cont1*bondper,0))))","v":0},{"$f":"IF(I5=1,0,IF(I5=0,0,R4))","v":0},{"$f":"IF(I5=0,0,IF(I5=1,P5*(1+O5),(Q5+P5)*(1+O5)))","v":0},{"$f":"IF(I5=time1,R5,0)","v":0},{"$f":"IF(I5=0,0,(K5+L5)/(K5+L5+P5+Q5))","v":0},{"$f":"IF(I5=0,0,(P5+Q5)/(K5+L5+P5+Q5))","v":0},{"$f":"IF(I5=0,0,M5/(M5+R5))","v":0},{"$f":"IF(I5=0,0,R5/(M5+R5))","v":0},null,1980,{"$f":"IF(AG4=start-1+time1,0,IF(Z4<>0,Z4+1,IF(Y5=start,1,0)))","v":0},{"$f":"IF(Z5=0,\"\",IF(freq=\"None\",5,INT(Z5/freq)-(Z5/freq)))","v":""},0.34899276658629547,{"$f":"IF(Z5=0,0,IF(AG4=start-1+time1,0,IF(AC4<>0,AC4*(1+inca),IF(Y5=start,12*cont1*eqper,0))))","v":0},{"$f":"IF(Z5=1,0,IF(Z5=0,0,IF(AA5=0,eqper*(AE4+AJ4),AE4)))","v":0},{"$f":"IF(Z5=0,0,(AC5+AD5)*(1+AB5))","v":0},{"$f":"IF(Z5=time1,AE5,0)","v":0},7.4999999999999997E-2,{"$f":"IF(Z5=0,0,IF(AG4=start-1+time1,0,IF(AH4<>0,AH4*(1+inca),IF(Y5=start,12*cont1*bondper,0))))","v":0},{"$f":"IF(Z5=1,0,IF(Z5=0,0,IF(AA5=0,bondper*(AE4+AJ4),AJ4)))","v":0},{"$f":"IF(Z5=0,0,(AH5+AI5)*(1+AG5))","v":0},{"$f":"IF(Z5=time1,AJ5,0)","v":0},{"$f":"IF(Z5=0,0,(AC5+AD5)/(AC5+AD5+AH5+AI5))","v":0},{"$f":"IF(Z5=0,0,(AH5+AI5)/(AC5+AD5+AH5+AI5))","v":0},{"$f":"IF(Z5=0,0,AE5/(AE5+AJ5))","v":0},{"$f":"IF(Z5=0,0,AJ5/(AE5+AJ5))","v":0},null,null,null,null,null,null,null,4]
["% increase or decrease each year",null,null,0,null,null,null,{"$f":"H5+1","v":1981},0,0.25524677121771222,0,{"$f":"IF(I6=1,0,IF(I6=0,0,M5))","v":0},{"$f":"IF(I6=0,0,IF(I6=1,K6*(1+J6),(L6+K6)*(1+J6)))","v":0},0,0.08,0,{"$f":"IF(I6=1,0,IF(I6=0,0,R5))","v":0},{"$f":"IF(I6=0,0,IF(I6=1,P6*(1+O6),(Q6+P6)*(1+O6)))","v":0},0,{"$f":"IF(I6=0,0,(K6+L6)/(K6+L6+P6+Q6))","v":0},{"$f":"IF(I6=0,0,(P6+Q6)/(K6+L6+P6+Q6))","v":0},0,0,null,{"$f":"Y5+1","v":1981},{"$f":"IF(Y5=start-1+time1,0,IF(Z5<>0,Z5+1,IF(Y6=start,1,0)))","v":0},"",0.25524677121771222,0,0,{"$f":"IF(Z6=0,0,(AC6+AD6)*(1+AB6))","v":0},0,0.08,0,0,{"$f":"IF(Z6=0,0,(AH6+AI6)*(1+AG6))","v":0},0,{"$f":"IF(Z6=0,0,(AC6+AD6)/(AC6+AD6+AH6+AI6))","v":0},{"$f":"IF(Z6=0,0,(AH6+AI6)/(AC6+AD6+AH6+AI6))","v":0},{"$f":"IF(Z6=0,0,AE6/(AE6+AJ6))","v":0},{"$f":"IF(Z6=0,0,AJ6/(AE6+AJ6))","v":0},null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,{"$f":"H6+1","v":1982},0,-2.8478250884203839E-2,0,0,0,0,0.08,0,0,0,0,0,0,0,0,null,{"$f":"Y6+1","v":1982},0,"",-2.8478250884203839E-2,0,0,0,0,0.08,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["Frequency of rebalancing: Every",null,1,"Years",null,null,null,1983,0,0.15989787716892828,0,0,0,0,0.08,0,0,0,0,0,0,0,0,null,1983,0,"",0.15989787716892828,0,0,0,0,0.08,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,1984,0,0.44238372803978315,0,0,0,{"$f":"IF(I9=time1,M9,0)","v":0},0.08,0,0,0,0,0,0,0,0,null,1984,0,"",0.44238372803978315,0,0,0,{"$f":"IF(Z9=time1,AE9,0)","v":0},0.08,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["% in equities",0.5,"% in FDs",{"$f":"100%-eqper","v":0.5},null,null,null,1985,0,0.62242129655796075,0,0,0,{"$f":"IF(I10=time1,M10,0)","v":0},8.5000000000000006E-2,0,0,0,0,0,0,0,0,null,1985,0,"",0.62242129655796075,0,0,0,{"$f":"IF(Z10=time1,AE10,0)","v":0},8.5000000000000006E-2,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["Total must be 100%",null,null,null,null,null,null,1986,0,-0.11104143805194128,0,0,0,0,8.5000000000000006E-2,0,0,0,0,0,0,0,0,null,1986,0,"",-0.11104143805194128,0,0,0,{"$f":"IF(Z11=time1,AE11,0)","v":0},8.5000000000000006E-2,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,1987,0,-0.21943334117093818,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,1987,0,"",-0.21943334117093818,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
[null,"Equity corpus","Debt Corpus","Total corpus","% Equity","%Debt",null,1988,0,0.79129954564851768,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,1988,0,"",0.79129954564851768,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["without  rebalancing",{"$f":"MAX(N2:N57)","v":1451185.8048771338},{"$f":"MAX(S2:S57)","v":941949.10495299462},{"$f":"B14+C14","v":2393134.9098301283},{"$f":"B14/D14","v":0.60639531808933544},{"$f":"C14/D14","v":0.39360468191066456},null,1989,0,9.4520739910313803E-2,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,1989,0,"",9.4520739910313803E-2,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["with rebalancing",{"$f":"MAX(AF4:AF58)","v":1118498.4225860329},{"$f":"MAX(AK4:AK58)","v":1387114.2613952842},{"$f":"B15+C15","v":2505612.6839813171},{"$f":"B15/D15","v":0.446397174526106},{"$f":"C15/D15","v":0.55360282547389394},null,1990,0,0.49538441841111336,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,1990,0,"",0.49538441841111336,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["The % equity and debt shown here represents the final asset allocation",null,null,null,null,null,null,1991,0,2.6687586153753942,0,0,0,0,0.12,0,0,0,0,0,0,0,0,null,1991,0,"",2.6687586153753942,0,0,0,0,0.12,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["% difference bet the two corpuses",null,{"$f":"(D15-D14)/D14","v":4.7000181096841211E-2},null,null,null,null,1992,0,-0.4677899649941657,0,0,0,0,0.11,0,0,0,0,0,0,0,0,null,1992,0,"",-0.4677899649941657,0,0,0,0,0.11,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["+ve means rebalanced portfolio is higher",null,null,null,null,null,null,1993,0,0.65707382526792135,0,0,0,0,0.1,0,0,0,0,0,0,0,0,null,1993,0,"",0.65707382526792135,0,0,0,0,0.1,0,0,0,0,0,0,0,0]
["Click on the macro to find out the % difference",null,null,null,null,null,null,1994,0,-0.13708160116856616,0,0,0,0,0.11,0,0,0,0,0,0,0,0,null,1994,0,"",-0.13708160116856616,0,0,0,0,0.11,0,0,0,0,0,0,0,0]
["between the two corpuses for all possible ",null,null,null,null,null,null,1995,0,3.2398434816741109E-2,0,0,0,0,0.12,0,0,0,0,0,0,0,0,null,1995,0,"",3.2398434816741109E-2,0,0,0,0,0.12,0,0,0,0,0,0,0,0]
["investment durations between",null,null,null,null,null,null,1996,0,-1.6990384986678749E-3,0,0,0,0,0.12,0,0,0,0,0,0,0,0,null,1996,0,"",-1.6990384986678749E-3,0,0,0,0,0.12,0,0,0,0,0,0,0,0]
[{"$f":"D3","v":1980},"and",{"$f":"F3","v":2002},null,null,null,null,1997,0,0.15824974932235217,0,0,0,0,0.11,0,0,0,0,0,0,0,0,null,1997,0,"",0.15824974932235217,0,0,0,0,0.11,0,0,0,0,0,0,0,0]
["Average % difference bet the two corpuses",null,null,{"$f":"AVERAGE(B26:B48)","v":5.3647526594508908E-2},null,null,null,1998,0,-3.9249887611585633E-2,0,0,0,0,0.105,0,0,0,0,0,0,0,0,null,1998,0,"",-3.9249887611585633E-2,0,0,0,0,0.105,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,1999,0,0.33725494390314326,0,0,0,0,8.5000000000000006E-2,0,0,0,0,0,0,0,0,null,1999,0,"",0.33725494390314326,0,0,0,0,8.5000000000000006E-2,0,0,0,0,0,0,0,0]
["Year","% difference",null,null,null,null,null,2000,0,-0.27930849702476163,0,0,0,0,8.5000000000000006E-2,0,0,0,0,0,0,0,0,null,2000,0,"",-0.27930849702476163,0,0,0,0,8.5000000000000006E-2,0,0,0,0,0,0,0,0]
[1980,1.5325077140792098E-2,null,null,null,null,null,2001,0,-3.7462753649726219E-2,0,0,0,0,7.4999999999999997E-2,0,0,0,0,0,0,0,0,null,2001,0,"",-3.7462753649726219E-2,0,0,0,0,7.4999999999999997E-2,0,0,0,0,0,0,0,0]
[1981,-1.2503874279690578E-2,null,null,null,null,null,2002,1,-0.12124173116001562,60000,0,52725.496130399064,0,4.2500000000000003E-2,60000,0,62550,0,0.5,0.5,0.45738685063438156,0.54261314936561844,null,2002,1,0,-0.12124173116001562,60000,0,52725.496130399064,0,4.2500000000000003E-2,60000,0,62550,0,0.5,0.5,0.45738685063438156,0.54261314936561844]
[1982,-0.15737564058045814,null,null,null,null,null,2003,2,0.8337531816631244,60000,52725.496130399064,206710.73718367348,0,0.04,60000,62550,127452,0,0.47912127690476569,0.52087872309523431,0.61859302125016513,0.38140697874983487,null,2003,2,0,0.8337531816631244,60000,57637.748065199528,215718.59479824468,0,0.04,60000,57637.748065199528,122343.25798780752,0,0.5,0.5,0.63810392394307092,0.36189607605692908]
[1983,0.14056358666417243,null,null,null,null,null,2004,3,0.16138160483669003,60000,206710.73718367348,309752.94397755136,0,5.2499999999999998E-2,60000,127452,197293.23,0,0.58725808030307369,0.41274191969692631,0.61089691604943486,0.38910308395056509,null,2004,3,0,0.16138160483669003,60000,169030.92639302611,265992.3048515665,0,5.2499999999999998E-2,60000,169030.92639302611,241055.05002865999,0,0.49999999999999994,0.49999999999999994,0.52459065665454174,0.4754093433454582]
[1984,6.0190024363785212E-2,null,null,null,null,null,2005,4,0.737303667743754,60000,309752.94397755136,642373.14573125076,0,0.06,60000,197293.23,272730.82380000001,0,0.5896741887955268,0.4103258112044732,0.70196739072205905,0.2980326092779409,null,2005,4,0,0.737303667743754,60000,253523.67744011324,544685.83474121836,0,0.06,60000,253523.67744011324,332335.0980865201,0,0.5,0.5,0.62106366490593645,0.37893633509406355]
[1985,0.15786940130980878,null,null,null,null,null,2006,5,0.15887411347517733,60000,642373.14573125076,813962.05658807466,0,6.25E-2,60000,272730.82380000001,353526.50028750004,0,0.67855323369044951,0.32144676630955049,0.69719060781751441,0.30280939218248559,null,2006,5,0,0.15887411347517733,60000,438510.46641386923,577710.87482346979,0,6.25E-2,60000,438510.46641386923,529667.37056473608,0,0.49999999999999994,0.49999999999999994,0.52169245443407253,0.47830754556592747]
[1986,0.16987838176339995,null,null,null,null,null,2007,6,0.19677787042632777,60000,813962.05658807466,1045938.4489168898,0,7.0000000000000007E-2,60000,353526.50028750004,442473.35530762508,0,0.67881151402927464,0.32118848597072541,0.70272114608889413,0.29727885391110587,null,2007,6,0,0.19677787042632777,60000,553689.12269410293,734449.56136165,0,7.0000000000000007E-2,60000,553689.12269410293,656647.3612826902,0,0.5,0.5,0.5279643347679418,0.47203566523205825]
[1987,0.16605420510618984,null,null,null,null,null,2008,7,-0.37942650405256834,60000,1045938.4489168898,686316.08954703424,0,0.08,60000,442473.35530762508,542671.22373223514,0,0.6875965757103546,0.31240342428964535,0.55844033712256802,0.44155966287743209,null,2008,7,0,-0.37942650405256834,60000,695548.4613221701,468873.3500004019,0,0.08,60000,695548.4613221701,815992.33822794375,0,0.5,0.5,0.36492012690206882,0.63507987309793112]
[1988,0.13478359219843258,null,null,null,null,null,2009,8,0.80532523046814641,60000,686316.08954703424,1347343.2663635854,0,0.09,60000,542671.22373223514,656911.63386813633,0,0.55324174082319988,0.44675825917680018,0.67224147298221015,0.32775852701778979,null,2009,8,0,0.80532523046814641,60000,642432.84411417285,1268119.7361888147,0,0.09,60000,642432.84411417285,765651.80008444842,0,0.5,0.5,0.62353106706987893,0.37646893293012107]
[1989,0.14182123673531247,null,null,null,null,null,2010,9,0.10943116334797741,60000,1347343.2663635854,1561350.4772316951,0,0.1,60000,656911.63386813633,788602.79725495004,0,0.66251148400790649,0.33748851599209345,0.66441766914398637,0.33558233085601369,null,2010,9,0,0.10943116334797741,60000,1016885.7681366316,1194730.6305367036,0,0.1,60000,1016885.7681366316,1184574.3449502951,0,0.5,0.5,0.50213429671501653,0.49786570328498359]
[1990,0.10567905921920533,null,null,null,null,null,2011,10,-0.10495242993057337,60000,1561350.4772316951,1451185.8048771338,1451185.8048771338,0.11,60000,788602.79725495004,941949.10495299462,941949.10495299462,0.65642961507791131,0.34357038492208869,0.60639531808933544,0.39360468191066456,null,2011,10,0,-0.10495242993057337,60000,1189652.4877434992,1118498.4225860329,1118498.4225860329,0.11,60000,1189652.4877434992,1387114.2613952842,1387114.2613952842,0.5,0.5,0.446397174526106,0.55360282547389394]
[1991,7.234704506509386E-2,null,null,null,null,null,"Note 35% returns listed against 1980 actually is the return"]
[1992,-4.2145332480512431E-3,null,null,null,null,null,"generated in the financial year 1980-1981"]
[1993,-1.7875158306801427E-2]
[1994,5.7526073584621584E-2]
[1995,5.1606414776929482E-2]
[1996,2.073195459406384E-2]
[1997,-3.0541405660357433E-3]
[1998,-3.0142178657627087E-2]
[1999,7.4639008653092781E-2]
[2000,2.9406966962335548E-2]
[2001,1.3636428078292212E-2]
[2002,4.7000181096841211E-2]

{"sheet":"One-way Rebalancing SIP ","index":5,"n_rows":48,"n_cols":50,"rows_kept":48,"cut":false,"hidden":false,"merged":[[18,0,18,2],[19,0,19,2],[20,0,20,2],[17,0,17,2],[0,7,0,20],[0,24,0,40],[1,19,1,22],[1,37,1,40],[3,19,3,20],[3,21,3,22],[3,37,3,38],[3,39,3,40]]}
["Enter data only in green cells",null,null,null,null,null,null,"No Rebalancing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Rebalancing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None",1]
["Enter no of years (max 32)",null,null,10,null,null,null,"Year of","Year","Sensex","Annual","invest. From","Total Equity",null,"FD","Annual","invest. From","Total Debt ",null,"Asset Allocation",null,null,null,null,"Year of","Year",null,"Sensex","Annual","invest. From","Total Equity",null,"FD","Annual","invest. From","Total Debt ",null,"Asset Allocation",null,null,null,null,null,null,null,null,null,null,1]
["Choose a starting year between",null,null,1980,"and",{"$f":"2011-time1+1","v":2002},null,"return",null,"return","investment","Previous","Corpus",null,"return","investment","Previous","Corpus",null,"Equity","Debt","Equity","Debt",null,null,null,null,"return ","Investment","Previous","Corpus",null,"return","investment","Previous","Corpus",null,"Equity","Debt","Equity","Debt",null,null,null,null,null,null,null,{"$f":"IF(AW2<time1/2,AW2+1,\"\")","v":2}]
["Starting year",null,2002,null,null,null,null,null,null,null,null,"year",null,null,null,null,"year",null,null,"Prior investment",null,"After investment",null,null,"return",null,null,null,null,"year",null,null,null,null,"year",null,null,"Prior investment",null,"After investment",null,null,null,null,null,null,null,null,3]
["monthly contribution in 1st year",null,null,25000,null,null,null,1980,{"$f":"IF(H4=start-1+time1,0,IF(I4<>0,I4+1,IF(H5=start,1,0)))","v":0},0.34899276658629547,{"$f":"IF(I5=0,0,IF(O4=start-1+time1,0,IF(K4<>0,K4*(1+inca),IF(H5=start,12*cont1*eqper,0))))","v":0},{"$f":"IF(I5=1,0,IF(I5=0,0,M4))","v":0},{"$f":"IF(I5=0,0,IF(I5=1,K5*(1+J5),(L5+K5)*(1+J5)))","v":0},{"$f":"IF(I5=time1,M5,0)","v":0},7.4999999999999997E-2,{"$f":"IF(I5=0,0,IF(O4=start-1+time1,0,IF(K4<>0,K4*(1+inca),IF(H5=start,12*cont1*bondper,0))))","v":0},{"$f":"IF(I5=1,0,IF(I5=0,0,R4))","v":0},{"$f":"IF(I5=0,0,IF(I5=1,P5*(1+O5),(Q5+P5)*(1+O5)))","v":0},{"$f":"IF(I5=time1,R5,0)","v":0},{"$f":"IF(I5=0,0,(K5+L5)/(K5+L5+P5+Q5))","v":0},{"$f":"IF(I5=0,0,(P5+Q5)/(K5+L5+P5+Q5))","v":0},{"$f":"IF(I5=0,0,M5/(M5+R5))","v":0},{"$f":"IF(I5=0,0,R5/(M5+R5))","v":0},null,1980,{"$f":"IF(AG4=start-1+time1,0,IF(Z4<>0,Z4+1,IF(Y5=start,1,0)))","v":0},{"$f":"IF(Z5=0,\"\",IF(Z5=1,1,IF((AN4-eqper)>oneway,0,1)))","v":""},0.34899276658629547,{"$f":"IF(Z5=0,0,IF(AG4=start-1+time1,0,IF(AC4<>0,AC4*(1+inca),IF(Y5=start,12*cont1*eqper,0))))","v":0},{"$f":"IF(Z5=1,0,IF(Z5=0,0,IF(AA5=0,AE4*(1-oneway),AE4)))","v":0},{"$f":"IF(Z5=0,0,(AC5+AD5)*(1+AB5))","v":0},{"$f":"IF(Z5=time1,AE5,0)","v":0},7.4999999999999997E-2,{"$f":"IF(Z5=0,0,IF(AG4=start-1+time1,0,IF(AH4<>0,AH4*(1+inca),IF(Y5=start,12*cont1*bondper,0))))","v":0},{"$f":"IF(Z5=1,0,IF(Z5=0,0,IF(AA5=0,AJ4+oneway*AE4,AJ4)))","v":0},{"$f":"IF(Z5=0,0,(AH5+AI5)*(1+AG5))","v":0},{"$f":"IF(Z5=time1,AJ5,0)","v":0},{"$f":"IF(Z5=0,0,(AC5+AD5)/(AC5+AD5+AH5+AI5))","v":0},{"$f":"IF(Z5=0,0,(AH5+AI5)/(AC5+AD5+AH5+AI5))","v":0},{"$f":"IF(Z5=0,0,AE5/(AE5+AJ5))","v":0},{"$f":"IF(Z5=0,0,AJ5/(AE5+AJ5))","v":0},null,null,null,null,null,null,null,4]
["% increase or","decrease each year",null,0,null,null,null,{"$f":"H5+1","v":1981},0,0.25524677121771222,0,{"$f":"IF(I6=1,0,IF(I6=0,0,M5))","v":0},{"$f":"IF(I6=0,0,IF(I6=1,K6*(1+J6),(L6+K6)*(1+J6)))","v":0},0,0.08,0,{"$f":"IF(I6=1,0,IF(I6=0,0,R5))","v":0},{"$f":"IF(I6=0,0,IF(I6=1,P6*(1+O6),(Q6+P6)*(1+O6)))","v":0},0,{"$f":"IF(I6=0,0,(K6+L6)/(K6+L6+P6+Q6))","v":0},{"$f":"IF(I6=0,0,(P6+Q6)/(K6+L6+P6+Q6))","v":0},0,0,null,{"$f":"Y5+1","v":1981},{"$f":"IF(Y5=start-1+time1,0,IF(Z5<>0,Z5+1,IF(Y6=start,1,0)))","v":0},"",0.25524677121771222,0,0,{"$f":"IF(Z6=0,0,(AC6+AD6)*(1+AB6))","v":0},0,0.08,0,0,{"$f":"IF(Z6=0,0,(AH6+AI6)*(1+AG6))","v":0},0,{"$f":"IF(Z6=0,0,(AC6+AD6)/(AC6+AD6+AH6+AI6))","v":0},{"$f":"IF(Z6=0,0,(AH6+AI6)/(AC6+AD6+AH6+AI6))","v":0},{"$f":"IF(Z6=0,0,AE6/(AE6+AJ6))","v":0},{"$f":"IF(Z6=0,0,AJ6/(AE6+AJ6))","v":0},null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,{"$f":"H6+1","v":1982},0,-2.8478250884203839E-2,0,0,0,0,0.08,0,0,0,0,0,0,0,0,null,{"$f":"Y6+1","v":1982},0,"",-2.8478250884203839E-2,0,0,0,0,0.08,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["% in equities",0.5,"% in FDs",{"$f":"100%-eqper","v":0.5},null,null,null,1983,0,0.15989787716892828,0,0,0,0,0.08,0,0,0,0,0,0,0,0,null,1983,0,"",0.15989787716892828,0,0,0,0,0.08,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["Total must be 100%",null,null,null,null,null,null,1984,0,0.44238372803978315,0,0,0,{"$f":"IF(I9=time1,M9,0)","v":0},0.08,0,0,0,0,0,0,0,0,null,1984,0,"",0.44238372803978315,0,0,0,{"$f":"IF(Z9=time1,AE9,0)","v":0},0.08,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["Move from equity to debt only if equity allocation increases by (%)",null,null,null,0,null,null,1985,0,0.62242129655796075,0,0,0,{"$f":"IF(I10=time1,M10,0)","v":0},8.5000000000000006E-2,0,0,0,0,0,0,0,0,null,1985,0,"",0.62242129655796075,0,0,0,{"$f":"IF(Z10=time1,AE10,0)","v":0},8.5000000000000006E-2,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["0% is the same as no rebalancing",null,null,null,null,null,null,1986,0,-0.11104143805194128,0,0,0,0,8.5000000000000006E-2,0,0,0,0,0,0,0,0,null,1986,0,"",-0.11104143805194128,0,0,0,{"$f":"IF(Z11=time1,AE11,0)","v":0},8.5000000000000006E-2,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,1987,0,-0.21943334117093818,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,1987,0,"",-0.21943334117093818,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
[null,"Equity corpus","Debt Corpus","Total corpus","% Equity","%Debt",null,1988,0,0.79129954564851768,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,1988,0,"",0.79129954564851768,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["without  rebalancing",{"$f":"MAX(N2:N57)","v":3627964.5121928342},{"$f":"MAX(S2:S57)","v":2354872.7623824859},{"$f":"B14+C14","v":5982837.2745753201},{"$f":"B14/D14","v":0.60639531808933544},{"$f":"C14/D14","v":0.3936046819106645},null,1989,0,9.4520739910313803E-2,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,1989,0,"",9.4520739910313803E-2,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["with rebalancing",{"$f":"MAX(AF4:AF58)","v":3627964.5121928342},{"$f":"MAX(AK4:AK58)","v":2354872.7623824859},{"$f":"B15+C15","v":5982837.2745753201},{"$f":"B15/D15","v":0.60639531808933544},{"$f":"C15/D15","v":0.3936046819106645},null,1990,0,0.49538441841111336,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,1990,0,"",0.49538441841111336,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["The % equity and debt shown here represents the final asset allocation",null,null,null,null,null,null,1991,0,2.6687586153753942,0,0,0,0,0.12,0,0,0,0,0,0,0,0,null,1991,0,"",2.6687586153753942,0,0,0,0,0.12,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["% difference bet the two corpuses",null,{"$f":"(D15-D14)/D14","v":0},null,null,null,null,1992,0,-0.4677899649941657,0,0,0,0,0.11,0,0,0,0,0,0,0,0,null,1992,0,"",-0.4677899649941657,0,0,0,0,0.11,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["+ve means rebalanced portfolio is higher",null,null,null,null,null,null,1993,0,0.65707382526792135,0,0,0,0,0.1,0,0,0,0,0,0,0,0,null,1993,0,"",0.65707382526792135,0,0,0,0,0.1,0,0,0,0,0,0,0,0]
["Click on the macro to find out the % difference",null,null,null,null,null,null,1994,0,-0.13708160116856616,0,0,0,0,0.11,0,0,0,0,0,0,0,0,null,1994,0,"",-0.13708160116856616,0,0,0,0,0.11,0,0,0,0,0,0,0,0]
["between the two corpuses for all possible ",null,null,null,null,null,null,1995,0,3.2398434816741109E-2,0,0,0,0,0.12,0,0,0,0,0,0,0,0,null,1995,0,"",3.2398434816741109E-2,0,0,0,0,0.12,0,0,0,0,0,0,0,0]
["investment durations between",null,null,null,null,null,null,1996,0,-1.6990384986678749E-3,0,0,0,0,0.12,0,0,0,0,0,0,0,0,null,1996,0,"",-1.6990384986678749E-3,0,0,0,0,0.12,0,0,0,0,0,0,0,0]
[{"$f":"D3","v":1980},"and",{"$f":"F3","v":2002},null,null,null,null,1997,0,0.15824974932235217,0,0,0,0,0.11,0,0,0,0,0,0,0,0,null,1997,0,"",0.15824974932235217,0,0,0,0,0.11,0,0,0,0,0,0,0,0]
["Average % difference bet the two corpuses",null,null,{"$f":"AVERAGE(B26:B48)","v":0},null,null,null,1998,0,-3.9249887611585633E-2,0,0,0,0,0.105,0,0,0,0,0,0,0,0,null,1998,0,"",-3.9249887611585633E-2,0,0,0,0,0.105,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,1999,0,0.33725494390314326,0,0,0,0,8.5000000000000006E-2,0,0,0,0,0,0,0,0,null,1999,0,"",0.33725494390314326,0,0,0,0,8.5000000000000006E-2,0,0,0,0,0,0,0,0]
["Year","% difference",null,null,null,null,null,2000,0,-0.27930849702476163,0,0,0,0,8.5000000000000006E-2,0,0,0,0,0,0,0,0,null,2000,0,"",-0.27930849702476163,0,0,0,0,8.5000000000000006E-2,0,0,0,0,0,0,0,0]
[1980,0,null,null,null,null,null,2001,0,-3.7462753649726219E-2,0,0,0,0,7.4999999999999997E-2,0,0,0,0,0,0,0,0,null,2001,0,"",-3.7462753649726219E-2,0,0,0,0,7.4999999999999997E-2,0,0,0,0,0,0,0,0]
[1981,0,null,null,null,null,null,2002,1,-0.12124173116001562,150000,0,131813.74032599767,0,4.2500000000000003E-2,150000,0,156375,0,0.5,0.5,0.4573868506343815,0.54261314936561833,null,2002,1,1,-0.12124173116001562,150000,0,131813.74032599767,0,4.2500000000000003E-2,150000,0,156375,0,0.5,0.5,0.4573868506343815,0.54261314936561833]
[1982,0,null,null,null,null,null,2003,2,0.8337531816631244,150000,131813.74032599767,516776.84295918379,0,0.04,150000,156375,318630,0,0.47912127690476575,0.5208787230952342,0.61859302125016524,0.38140697874983481,null,2003,2,1,0.8337531816631244,150000,131813.74032599767,516776.84295918379,0,0.04,150000,156375,318630,0,0.47912127690476575,0.5208787230952342,0.61859302125016524,0.38140697874983481]
[1983,0,null,null,null,null,null,2004,3,0.16138160483669003,150000,516776.84295918379,774382.35994387849,0,5.2499999999999998E-2,150000,318630,493233.07500000001,0,0.58725808030307369,0.41274191969692631,0.61089691604943486,0.38910308395056503,null,2004,3,0,0.16138160483669003,150000,516776.84295918379,774382.35994387849,0,5.2499999999999998E-2,150000,318630,493233.07500000001,0,0.58725808030307369,0.41274191969692631,0.61089691604943486,0.38910308395056503]
[1984,0,null,null,null,null,null,2005,4,0.737303667743754,150000,774382.35994387849,1605932.8643281269,0,0.06,150000,493233.07500000001,681827.05949999997,0,0.58967418879552691,0.4103258112044732,0.70196739072205905,0.2980326092779409,null,2005,4,0,0.737303667743754,150000,774382.35994387849,1605932.8643281269,0,0.06,150000,493233.07500000001,681827.05949999997,0,0.58967418879552691,0.4103258112044732,0.70196739072205905,0.2980326092779409]
[1985,0,null,null,null,null,null,2006,5,0.15887411347517733,150000,1605932.8643281269,2034905.1414701866,0,6.25E-2,150000,681827.05949999997,883816.25071874994,0,0.67855323369044951,0.32144676630955044,0.69719060781751452,0.30280939218248559,null,2006,5,0,0.15887411347517733,150000,1605932.8643281269,2034905.1414701866,0,6.25E-2,150000,681827.05949999997,883816.25071874994,0,0.67855323369044951,0.32144676630955044,0.69719060781751452,0.30280939218248559]
[1986,0,null,null,null,null,null,2007,6,0.19677787042632777,150000,2034905.1414701866,2614846.1222922243,0,7.0000000000000007E-2,150000,883816.25071874994,1106183.3882690626,0,0.67881151402927453,0.32118848597072541,0.70272114608889413,0.29727885391110587,null,2007,6,0,0.19677787042632777,150000,2034905.1414701866,2614846.1222922243,0,7.0000000000000007E-2,150000,883816.25071874994,1106183.3882690626,0,0.67881151402927453,0.32118848597072541,0.70272114608889413,0.29727885391110587]
[1987,0,null,null,null,null,null,2008,7,-0.37942650405256834,150000,2614846.1222922243,1715790.2238675856,0,0.08,150000,1106183.3882690626,1356678.0593305877,0,0.68759657571035471,0.31240342428964535,0.55844033712256802,0.44155966287743204,null,2008,7,0,-0.37942650405256834,150000,2614846.1222922243,1715790.2238675856,0,0.08,150000,1106183.3882690626,1356678.0593305877,0,0.68759657571035471,0.31240342428964535,0.55844033712256802,0.44155966287743204]
[1988,0,null,null,null,null,null,2009,8,0.80532523046814641,150000,1715790.2238675856,3368358.1659089634,0,0.09,150000,1356678.0593305877,1642279.0846703406,0,0.55324174082319988,0.44675825917680018,0.67224147298221026,0.32775852701778974,null,2009,8,0,0.80532523046814641,150000,1715790.2238675856,3368358.1659089634,0,0.09,150000,1356678.0593305877,1642279.0846703406,0,0.55324174082319988,0.44675825917680018,0.67224147298221026,0.32775852701778974]
[1989,0,null,null,null,null,null,2010,9,0.10943116334797741,150000,3368358.1659089634,3903376.1930792374,0,0.1,150000,1642279.0846703406,1971506.9931373748,0,0.6625114840079066,0.33748851599209345,0.66441766914398637,0.33558233085601363,null,2010,9,0,0.10943116334797741,150000,3368358.1659089634,3903376.1930792374,0,0.1,150000,1642279.0846703406,1971506.9931373748,0,0.6625114840079066,0.33748851599209345,0.66441766914398637,0.33558233085601363]
[1990,0,null,null,null,null,null,2011,10,-0.10495242993057337,150000,3903376.1930792374,3627964.5121928342,3627964.5121928342,0.11,150000,1971506.9931373748,2354872.7623824859,2354872.7623824859,0.65642961507791142,0.34357038492208869,0.60639531808933544,0.3936046819106645,null,2011,10,0,-0.10495242993057337,150000,3903376.1930792374,3627964.5121928342,3627964.5121928342,0.11,150000,1971506.9931373748,2354872.7623824859,2354872.7623824859,0.65642961507791142,0.34357038492208869,0.60639531808933544,0.3936046819106645]
[1991,0,null,null,null,null,null,"Note 35% returns listed against 1980 actually is the return"]
[1992,0,null,null,null,null,null,"generated in the financial year 1980-1981"]
[1993,0]
[1994,0]
[1995,0]
[1996,0]
[1997,0]
[1998,0]
[1999,0]
[2000,0]
[2001,0]
[2002,0]

{"sheet":"Threshold Rebalancing SIP","index":6,"n_rows":43,"n_cols":50,"rows_kept":43,"cut":false,"hidden":false,"merged":[[18,0,18,2],[19,0,19,2],[20,0,20,2],[17,0,17,2],[9,0,9,1],[9,3,9,4],[0,7,0,20],[0,24,0,40],[1,19,1,22],[1,37,1,40],[3,19,3,20],[3,21,3,22],[3,37,3,38],[3,39,3,40]]}
["Enter data only in green cells",null,null,null,null,null,null,"No Rebalancing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Rebalancing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"None",1]
["Enter no of years (max 32)",null,null,15,null,null,null,"Year of","Year","Sensex","Annual","invest. From","Total Equity",null,"FD","Annual","invest. From","Total Debt ",null,"Asset Allocation",null,null,null,null,"Year of","Year",null,"Sensex","Annual","invest. From","Total Equity",null,"FD","Annual","invest. From","Total Debt ",null,"Asset Allocation",null,null,null,null,null,null,null,null,null,null,1]
["Choose a starting year between",null,null,1980,"and",{"$f":"2011-time1+1","v":1997},null,"return",null,"return","investment","Previous","Corpus",null,"return","investment","Previous","Corpus",null,"Equity","Debt","Equity","Debt",null,null,null,null,"return ","Investment","Previous","Corpus",null,"return","investment","Previous","Corpus",null,"Equity","Debt","Equity","Debt",null,null,null,null,null,null,null,{"$f":"IF(AW2<time1/2,AW2+1,\"\")","v":2}]
["Starting year",null,1997,null,null,null,null,null,null,null,null,"year",null,null,null,null,"year",null,null,"Prior investment",null,"After investment",null,null,"return",null,null,null,null,"year",null,null,null,null,"year",null,null,"Prior investment",null,"After investment",null,null,null,null,null,null,null,null,3]
["monthly contribution in 1st year",null,null,25000,null,null,null,1980,{"$f":"IF(H4=start-1+time1,0,IF(I4<>0,I4+1,IF(H5=start,1,0)))","v":0},0.34899276658629547,{"$f":"IF(I5=0,0,IF(O4=start-1+time1,0,IF(K4<>0,K4*(1+inca),IF(H5=start,12*cont1*eqper,0))))","v":0},{"$f":"IF(I5=1,0,IF(I5=0,0,M4))","v":0},{"$f":"IF(I5=0,0,IF(I5=1,K5*(1+J5),(L5+K5)*(1+J5)))","v":0},{"$f":"IF(I5=time1,M5,0)","v":0},7.4999999999999997E-2,{"$f":"IF(I5=0,0,IF(O4=start-1+time1,0,IF(P4<>0,P4*(1+inca),IF(H5=start,12*cont1*bondper,0))))","v":0},{"$f":"IF(I5=1,0,IF(I5=0,0,R4))","v":0},{"$f":"IF(I5=0,0,IF(I5=1,P5*(1+O5),(Q5+P5)*(1+O5)))","v":0},{"$f":"IF(I5=time1,R5,0)","v":0},{"$f":"IF(I5=0,0,(K5+L5)/(K5+L5+P5+Q5))","v":0},{"$f":"IF(I5=0,0,(P5+Q5)/(K5+L5+P5+Q5))","v":0},{"$f":"IF(I5=0,0,M5/(M5+R5))","v":0},{"$f":"IF(I5=0,0,R5/(M5+R5))","v":0},null,1980,{"$f":"IF(AG4=start-1+time1,0,IF(Z4<>0,Z4+1,IF(Y5=start,1,0)))","v":0},{"$f":"IF(Z5=0,\"\",IF(Z5=1,1,IF(ABS(AN4-eqper)>thres,0,1)))","v":""},0.34899276658629547,{"$f":"IF(Z5=0,0,IF(AG4=start-1+time1,0,IF(AC4<>0,AC4*(1+inca),IF(Y5=start,12*cont1*eqper,0))))","v":0},{"$f":"IF(Z5=1,0,IF(Z5=0,0,IF(AA5=0,eqper*(AE4+AJ4),AE4)))","v":0},{"$f":"IF(Z5=0,0,(AC5+AD5)*(1+AB5))","v":0},{"$f":"IF(Z5=time1,AE5,0)","v":0},7.4999999999999997E-2,{"$f":"IF(Z5=0,0,IF(AG4=start-1+time1,0,IF(AH4<>0,AH4*(1+inca),IF(Y5=start,12*cont1*bondper,0))))","v":0},{"$f":"IF(Z5=1,0,IF(Z5=0,0,IF(AA5=0,bondper*(AE4+AJ4),AJ4)))","v":0},{"$f":"IF(Z5=0,0,(AH5+AI5)*(1+AG5))","v":0},{"$f":"IF(Z5=time1,AJ5,0)","v":0},{"$f":"IF(Z5=0,0,(AC5+AD5)/(AC5+AD5+AH5+AI5))","v":0},{"$f":"IF(Z5=0,0,(AH5+AI5)/(AC5+AD5+AH5+AI5))","v":0},{"$f":"IF(Z5=0,0,AE5/(AE5+AJ5))","v":0},{"$f":"IF(Z5=0,0,AJ5/(AE5+AJ5))","v":0},null,null,null,null,null,null,null,4]
["% increase or","decrease each year",null,0.05,null,null,null,{"$f":"H5+1","v":1981},0,0.25524677121771222,0,{"$f":"IF(I6=1,0,IF(I6=0,0,M5))","v":0},{"$f":"IF(I6=0,0,IF(I6=1,K6*(1+J6),(L6+K6)*(1+J6)))","v":0},0,0.08,0,{"$f":"IF(I6=1,0,IF(I6=0,0,R5))","v":0},{"$f":"IF(I6=0,0,IF(I6=1,P6*(1+O6),(Q6+P6)*(1+O6)))","v":0},0,{"$f":"IF(I6=0,0,(K6+L6)/(K6+L6+P6+Q6))","v":0},{"$f":"IF(I6=0,0,(P6+Q6)/(K6+L6+P6+Q6))","v":0},0,0,null,{"$f":"Y5+1","v":1981},{"$f":"IF(Y5=start-1+time1,0,IF(Z5<>0,Z5+1,IF(Y6=start,1,0)))","v":0},"",0.25524677121771222,0,0,{"$f":"IF(Z6=0,0,(AC6+AD6)*(1+AB6))","v":0},0,0.08,0,0,{"$f":"IF(Z6=0,0,(AH6+AI6)*(1+AG6))","v":0},0,{"$f":"IF(Z6=0,0,(AC6+AD6)/(AC6+AD6+AH6+AI6))","v":0},{"$f":"IF(Z6=0,0,(AH6+AI6)/(AC6+AD6+AH6+AI6))","v":0},{"$f":"IF(Z6=0,0,AE6/(AE6+AJ6))","v":0},{"$f":"IF(Z6=0,0,AJ6/(AE6+AJ6))","v":0},null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,{"$f":"H6+1","v":1982},0,-2.8478250884203839E-2,0,0,0,0,0.08,0,0,0,0,0,0,0,0,null,{"$f":"Y6+1","v":1982},0,"",-2.8478250884203839E-2,0,0,0,0,0.08,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,6]
["% in equities",0.5,"% in FDs",{"$f":"100%-eqper","v":0.5},null,null,null,1983,0,0.15989787716892828,0,0,0,0,0.08,0,0,0,0,0,0,0,0,null,1983,0,"",0.15989787716892828,0,0,0,0,0.08,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,7]
["Total must be 100%",null,null,null,null,null,null,1984,0,0.44238372803978315,0,0,0,{"$f":"IF(I9=time1,M9,0)","v":0},0.08,0,0,0,0,0,0,0,0,null,1984,0,"",0.44238372803978315,0,0,0,{"$f":"IF(Z9=time1,AE9,0)","v":0},0.08,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,8]
["Rebalance only if equity deviates by (%)",null,0.05,"Typically 3-5% or so",null,null,null,1985,0,0.62242129655796075,0,0,0,{"$f":"IF(I10=time1,M10,0)","v":0},8.5000000000000006E-2,0,0,0,0,0,0,0,0,null,1985,0,"",0.62242129655796075,0,0,0,{"$f":"IF(Z10=time1,AE10,0)","v":0},8.5000000000000006E-2,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["0% is the same as annual rebalancing",null,null,null,null,null,null,1986,0,-0.11104143805194128,0,0,0,0,8.5000000000000006E-2,0,0,0,0,0,0,0,0,null,1986,0,"",-0.11104143805194128,0,0,0,{"$f":"IF(Z11=time1,AE11,0)","v":0},8.5000000000000006E-2,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,1987,0,-0.21943334117093818,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,1987,0,"",-0.21943334117093818,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
[null,"Equity corpus","Debt Corpus","Total corpus","% Equity","%Debt",null,1988,0,0.79129954564851768,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,1988,0,"",0.79129954564851768,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["without  rebalancing",{"$f":"MAX(N2:N57)","v":9093562.2622052729},{"$f":"MAX(S2:S57)","v":5783470.3219199525},{"$f":"B14+C14","v":14877032.584125225},{"$f":"B14/D14","v":0.61124839317141133},{"$f":"C14/D14","v":0.38875160682858872},null,1989,0,9.4520739910313803E-2,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,1989,0,"",9.4520739910313803E-2,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["with rebalancing",{"$f":"MAX(AF4:AF58)","v":7117237.7455785489},{"$f":"MAX(AK4:AK58)","v":8754265.3466626033},{"$f":"B15+C15","v":15871503.092241153},{"$f":"B15/D15","v":0.4484287155548512},{"$f":"C15/D15","v":0.5515712844451488},null,1990,0,0.49538441841111336,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,1990,0,"",0.49538441841111336,0,0,0,0,0.09,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["The % equity and debt shown here represents the final asset allocation",null,null,null,null,null,null,1991,0,2.6687586153753942,0,0,0,0,0.12,0,0,0,0,0,0,0,0,null,1991,0,"",2.6687586153753942,0,0,0,0,0.12,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["% difference bet the two corpuses",null,{"$f":"(D15-D14)/D14","v":6.6846026080301407E-2},null,null,null,null,1992,0,-0.4677899649941657,0,0,0,0,0.11,0,0,0,0,0,0,0,0,null,1992,0,"",-0.4677899649941657,0,0,0,0,0.11,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,""]
["+ve means rebalanced portfolio is higher",null,null,null,null,null,null,1993,0,0.65707382526792135,0,0,0,0,0.1,0,0,0,0,0,0,0,0,null,1993,0,"",0.65707382526792135,0,0,0,0,0.1,0,0,0,0,0,0,0,0]
["Click on the macro to find out the % difference",null,null,null,null,null,null,1994,0,-0.13708160116856616,0,0,0,0,0.11,0,0,0,0,0,0,0,0,null,1994,0,"",-0.13708160116856616,0,0,0,0,0.11,0,0,0,0,0,0,0,0]
["between the two corpuses for all possible ",null,null,null,null,null,null,1995,0,3.2398434816741109E-2,0,0,0,0,0.12,0,0,0,0,0,0,0,0,null,1995,0,"",3.2398434816741109E-2,0,0,0,0,0.12,0,0,0,0,0,0,0,0]
["investment durations between",null,null,null,null,null,null,1996,0,-1.6990384986678749E-3,0,0,0,0,0.12,0,0,0,0,0,0,0,0,null,1996,0,"",-1.6990384986678749E-3,0,0,0,0,0.12,0,0,0,0,0,0,0,0]
[{"$f":"D3","v":1980},"and",{"$f":"F3","v":1997},null,null,null,null,1997,1,0.15824974932235217,150000,0,173737.46239835283,0,0.11,150000,0,166500.00000000003,0,0.5,0.5,0.51063589874456439,0.48936410125543567,null,1997,1,1,0.15824974932235217,150000,0,173737.46239835283,0,0.11,150000,0,166500.00000000003,0,0.5,0.5,0.51063589874456439,0.48936410125543567]
["Average % difference bet the two corpuses",null,null,{"$f":"AVERAGE(B26:B48)","v":0.12303246154492532},null,null,null,1998,2,-3.9249887611585633E-2,157500,173737.46239835283,318236.42922647065,0,0.105,157500,166500.00000000003,358020,0,0.50552277823970992,0.49447722176029002,0.47058543989072649,0.52941456010927346,null,1998,2,1,-3.9249887611585633E-2,157500,173737.46239835283,318236.42922647065,0,0.105,157500,166500.00000000003,358020,0,0.50552277823970992,0.49447722176029002,0.47058543989072649,0.52941456010927346]
[null,null,null,null,null,null,null,1999,3,0.33725494390314326,165375,318236.42922647065,646711.77466116298,0,8.5000000000000006E-2,165375,358020,567883.57499999995,0,0.4802466153050835,0.5197533846949165,0.53245039579772546,0.46754960420227448,null,1999,3,1,0.33725494390314326,165375,318236.42922647065,646711.77466116298,0,8.5000000000000006E-2,165375,358020,567883.57499999995,0,0.4802466153050835,0.5197533846949165,0.53245039579772546,0.46754960420227448]
["Year","% difference",null,null,null,null,null,2000,4,-0.27930849702476163,173643.75,646711.77466116298,591223.25604209374,0,8.5000000000000006E-2,173643.75,567883.57499999995,804557.14762499987,0,0.52523499111289429,0.47476500888710566,0.42357899171588159,0.57642100828411835,null,2000,4,1,-0.27930849702476163,173643.75,646711.77466116298,591223.25604209374,0,8.5000000000000006E-2,173643.75,567883.57499999995,804557.14762499987,0,0.52523499111289429,0.47476500888710566,0.42357899171588159,0.57642100828411835]
[1980,0.10033192506152593,null,null,null,null,null,2001,5,-3.7462753649726219E-2,182325.9375,591223.25604209374,744569.91066848196,0,7.4999999999999997E-2,182325.9375,804557.14762499987,1060899.3165093749,0,0.4394086628130815,0.56059133718691845,0.41239689907776772,0.58760310092223222,null,2001,5,0,-3.7462753649726219E-2,182325.9375,697890.20183354686,847240.81894718111,0,7.4999999999999997E-2,182325.9375,697890.20183354686,946232.34978356282,0,0.5,0.5,0.4724022827432543,0.52759771725674576]
[1981,0.14157141874397378,null,null,null,null,null,2002,6,-0.12124173116001562,191442.234375,744569.91066848196,822528.41219161067,0,4.2500000000000003E-2,191442.234375,1060899.3165093749,1305566.0667969608,0,0.42772434217797456,0.57227565782202539,0.38650934923835584,0.61349065076164411,null,2002,6,1,-0.12124173116001562,191442.234375,847240.81894718111,912751.3218108291,0,4.2500000000000003E-2,191442.234375,946232.34978356282,1186025.7539853018,0,0.47725752212513883,0.52274247787486106,0.43489674646107629,0.56510325353892366]
[1982,0.17899346576135364,null,null,null,null,null,2003,7,0.8337531816631244,201014.34609375001,822528.41219161067,1876924.7895740303,0,0.04,201014.34609375001,1305566.0667969608,1566843.6294063393,0,0.4045426601937287,0.59545733980627136,0.54502061730670903,0.45497938269329102,null,2003,7,0,0.8337531816631244,201014.34609375001,1049388.5378980655,2292930.2668807385,0,0.04,201014.34609375001,1049388.5378980655,1300418.9993514882,0,0.5,0.5,0.63810392394307092,0.36189607605692903]
[1983,0.16317627538437876,null,null,null,null,null,2004,8,0.16138160483669003,211065.06339843752,1876924.7895740303,2424953.0063278894,0,5.2499999999999998E-2,211065.06339843752,1566843.6294063393,1871248.8991770276,0,0.54010466861661377,0.45989533138338623,0.56444111791410179,0.43555888208589832,null,2004,8,0,0.16138160483669003,211065.06339843752,1796674.6331161135,2331751.9508323981,0,5.2499999999999998E-2,211065.06339843752,1796674.6331161135,2113146.0305815651,0,0.5,0.5,0.52459065665454174,0.47540934334545826]
[1984,0.19791132095686068,null,null,null,null,null,2005,9,0.737303667743754,221618.31656835941,2424953.0063278894,4597898.0662130918,0,0.06,221618.31656835941,1871248.8991770276,2218439.2486901106,0,0.55841452554309934,0.44158547445690083,0.67454086466059604,0.32545913533940396,null,2005,9,1,0.737303667743754,221618.31656835941,2331751.9508323981,4435979.5306631858,0,0.06,221618.31656835941,2113146.0305815651,2474850.2079789201,0,0.52236087357333627,0.47763912642666373,0.64188812319586996,0.35811187680413004]
[1985,0.16402357745249538,null,null,null,null,null,2006,10,0.15887411347517733,232699.2323967774,4597898.0662130918,5598054.1619820986,0,6.25E-2,232699.2323967774,2218439.2486901106,2604334.6361548183,0,0.66338541314266641,0.33661458685733359,0.68249071090773406,0.31750928909226594,null,2006,10,0,0.15887411347517733,232699.2323967774,3455414.8693210529,4274059.9600235503,0,6.25E-2,232699.2323967774,3455414.8693210529,3918621.2330751945,0,0.5,0.5,0.52169245443407264,0.47830754556592747]
[1986,0.21476991848029001,null,null,null,null,null,2007,11,0.19677787042632777,244334.19401661627,5598054.1619820986,6992041.0948957158,0,7.0000000000000007E-2,244334.19401661627,2604334.6361548183,3048075.6482834355,0,0.67222988306825926,0.32777011693174063,0.69641033802179886,0.30358966197820103,null,2007,11,1,0.19677787042632777,244334.19401661627,4274059.9600235503,5407514.1334189596,0,7.0000000000000007E-2,244334.19401661627,3918621.2330751945,4454362.3069882374,0,0.52047139811768817,0.47952860188231194,0.5483250744516206,0.45167492554837935]
[1987,0.18498562748274727,null,null,null,null,null,2008,12,-0.37942650405256834,256550.9037174471,6992041.0948957158,4498284.0772759505,0,0.08,256550.9037174471,3048075.6482834355,3568996.6761609535,0,0.68686078695787067,0.31313921304212927,0.55759607416161217,0.44240392583838778,null,2008,12,1,-0.37942650405256834,256550.9037174471,5407514.1334189596,3514968.6413693591,0,0.08,256550.9037174471,4454362.3069882374,5087786.2675621398,0,0.54593512408707789,0.45406487591292199,0.40858639802931851,0.59141360197068149]
[1988,0.15145113356967915,null,null,null,null,null,2009,13,0.80532523046814641,269378.44890331948,4498284.0772759505,8607181.4488689359,0,0.09,269378.44890331948,3568996.6761609535,4183828.8863200578,0,0.55399043315716368,0.44600956684283627,0.67290864625368629,0.32709135374631371,null,2009,13,0,0.80532523046814641,269378.44890331948,4301377.4544657497,8251700.9546634052,0,0.09,269378.44890331948,4301377.4544657497,4982123.9346722858,0,0.5,0.5,0.62353106706987882,0.37646893293012107]
[1989,0.16971381418143519,null,null,null,null,null,2010,14,0.10943116334797741,282847.37134848547,8607181.4488689359,9862875.0162108615,0,0.1,282847.37134848547,4183828.8863200578,4913343.8834353983,0,0.66558546949847697,0.33441453050152303,0.6674830065252334,0.3325169934747666,null,2010,14,0,0.10943116334797741,282847.37134848547,6616912.444667846,7654808.5595046254,0,0.1,282847.37134848547,6616912.444667846,7589735.7976179654,0,0.5,0.5,0.50213429671501653,0.49786570328498353]
[1990,0.13377395445827087,null,null,null,null,null,2011,15,-0.10495242993057337,296989.73991590977,9862875.0162108615,9093562.2622052729,9093562.2622052729,0.11,296989.73991590977,4913343.8834353983,5783470.3219199525,5783470.3219199525,0.66101064575015367,0.33898935424984633,0.61124839317141133,0.38875160682858872,null,2011,15,1,-0.10495242993057337,296989.73991590977,7654808.5595046254,7117237.7455785489,7117237.7455785489,0.11,296989.73991590977,7589735.7976179654,8754265.3466626033,8754265.3466626033,0.50205425589393726,0.49794574410606268,0.4484287155548512,0.5515712844451488]
[1991,9.5777341779575351E-2,null,null,null,null,null,"Note 35% returns listed against 1980 actually is the return"]
[1992,5.1160249758501537E-2,null,null,null,null,null,"generated in the financial year 1980-1981"]
[1993,2.1449595947348951E-2]
[1994,9.0337987469850362E-2]
[1995,4.9646605972000796E-2]
[1996,3.8664069268066904E-2]
[1997,6.6846026080301407E-2]

{"sheet":"Annual Rebalancing Retirement","index":7,"n_rows":50,"n_cols":36,"rows_kept":50,"cut":false,"hidden":false,"merged":[[25,0,25,2],[26,0,26,2],[24,0,24,2],[17,0,17,2],[3,34,3,35],[1,34,1,35],[0,7,0,20],[2,19,2,20],[1,19,1,20],[0,22,0,35]]}
["Enter data only in green cells",null,null,null,null,null,null,"No Rebalancing",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Annual Rebalancing"]
["Enter no of years (max 32)",null,null,15,null,null,null,"Year of","Year","Sensex","Annual","invest. From","Total Equity",null,"FD","Annual","invest. From","Total Debt ",null,"Asset Allocation",null,null,"Year of","Year","Sensex","Annual","invest. From","Total Equity",null,"FD","Annual","invest. From","Total Debt ",null,"Asset Allocation"]
["Choose a starting year between",null,null,1980,"and",{"$f":"2011-time1+1","v":1997},null,"return",null,"return",null,"previous",null,null,"return",null,"previous",null,null,"After investment",null,null,null,null,"return ","Investment","Previous","Corpus",null,"return","investment","Previous","Corpus",null,"Equity","Debt"]
["Starting year",null,1997,null,null,null,null,null,null,null,null,"year",null,null,null,null,"year",null,null,"Equity","Debt",null,null,null,null,null,"year",null,null,null,null,"year",null,null,"After investment"]
["monthly contribution in 1st year",null,null,10000,null,null,null,1980,{"$f":"IF(O4=start-1+time1,0,IF(I4<>0,I4+1,IF(H5=start,1,0)))","v":0},0.34899276658629547,{"$f":"IF(O4=start-1+time1,0,IF(K4<>0,K4*(1+inca),IF(H5=start,cont1*eqper,0)))","v":0},{"$f":"IF(I5=0,0,K5*12)","v":0},{"$f":"IF(I5=0,0,(L5+M4)*(1+J5))","v":0},{"$f":"IF(I5=time1,M5,0)","v":0},7.4999999999999997E-2,{"$f":"IF(O4=start-1+time1,0,IF(P4<>0,P4*(1+inca),IF(H5=start,cont1*bondper,0)))","v":0},{"$f":"IF(I5=0,0,P5*12)","v":0},{"$f":"IF(I5=0,0,(Q5+R4)*(1+O5))","v":0},{"$f":"IF(I5=time1,R5,0)","v":0},{"$f":"IF(I5=0,0,M5/(M5+R5))","v":0},{"$f":"IF(I5=0,0,R5/(M5+R5))","v":0},null,1980,{"$f":"IF(AD4=start-1+time1,0,IF(X4<>0,X4+1,IF(W5=start,1,0)))","v":0},0.34899276658629547,{"$f":"IF(AD4=start-1+time1,0,IF(Z4<>0,Z4*(1+inca),IF(W5=start,cont1*eqper,0)))","v":0},{"$f":"IF(X5=0,0,Z5*12)","v":0},{"$f":"IF(X5=0,0,(AA5+AB4)*(1+Y5))","v":0},{"$f":"IF(X5=time1,AB5,0)","v":0},7.4999999999999997E-2,{"$f":"IF(AD4=start-1+time1,0,IF(AE4<>0,AE4*(1+inca),IF(W5=start,cont1*bondper,0)))","v":0},{"$f":"IF(X5=0,0,AE5*12)","v":0},{"$f":"IF(X5=0,0,(AF5+AG4)*(1+AD5))","v":0},{"$f":"IF(X5=time1,AG5,0)","v":0},{"$f":"IF(X5=0,0,AB5/(AB5+AG5))","v":0},{"$f":"IF(X5=0,0,AG5/(AB5+AG5))","v":0}]
["% increase or","decrease each year",null,0,null,null,null,{"$f":"H5+1","v":1981},{"$f":"IF(H5=start-1+time1,0,IF(I5<>0,I5+1,IF(H6=start,1,0)))","v":0},0.25524677121771222,{"$f":"IF(O5=start-1+time1,0,IF(K5<>0,K5*(1+inca),IF(H6=start,cont1*eqper,0)))","v":0},{"$f":"IF(I6=0,0,K6*12)","v":0},{"$f":"IF(I6=0,0,(L6+M5)*(1+J6))","v":0},0,0.08,0,0,{"$f":"IF(I6=0,0,(Q6+R5)*(1+O6))","v":0},0,{"$f":"IF(I6=0,0,M6/(M6+R6))","v":0},{"$f":"IF(I6=0,0,R6/(M6+R6))","v":0},null,{"$f":"W5+1","v":1981},{"$f":"IF(W5=start-1+time1,0,IF(X5<>0,X5+1,IF(W6=start,1,0)))","v":0},0.25524677121771222,0,{"$f":"IF(X6=0,0,Z6*12)","v":0},{"$f":"IF(X6=0,0,(AA6+eqper*(AB5+AG5))*(1+Y6))","v":0},0,0.08,0,0,{"$f":"IF(X6=0,0,(AF6+bondper*(AG5+AB5))*(1+AD6))","v":0},0,{"$f":"IF(X6=0,0,AB6/(AB6+AG6))","v":0},{"$f":"IF(X6=0,0,AG6/(AB6+AG6))","v":0}]
["% in equities",0.5,"% in FDs (debt)",{"$f":"100%-eqper","v":0.5},null,null,null,{"$f":"H6+1","v":1982},0,-2.8478250884203839E-2,0,0,0,0,0.08,0,0,0,0,0,0,null,{"$f":"W6+1","v":1982},0,-2.8478250884203839E-2,0,0,0,0,0.08,0,0,0,0,0,0]
["Total must be 100%",null,null,null,null,null,null,1983,0,0.15989787716892828,0,0,0,0,0.08,0,0,0,0,0,0,null,1983,0,0.15989787716892828,0,0,0,0,0.08,0,0,0,0,0,0]
["Enter a rate of inflation during retirement",null,null,0.08,null,null,null,1984,0,0.44238372803978315,0,0,0,{"$f":"IF(I9=time1,M9,0)","v":0},0.08,0,0,0,0,0,0,null,1984,0,0.44238372803978315,0,0,0,{"$f":"IF(X9=time1,AB9,0)","v":0},0.08,0,0,0,0,0,0]
["rate of interest you expect corpus to earn during retirement",null,null,0.08,null,null,null,1985,0,0.62242129655796075,0,0,0,{"$f":"IF(I10=time1,M10,0)","v":0},8.5000000000000006E-2,0,0,0,0,0,0,null,1985,0,0.62242129655796075,0,0,0,{"$f":"IF(X10=time1,AB10,0)","v":0},8.5000000000000006E-2,0,0,0,0,0,0]
["Enter the pension amt which will cover monthly expenses",null,null,40000,"(enter present expenses to try)",null,null,1986,0,-0.11104143805194128,0,0,0,0,8.5000000000000006E-2,0,0,0,0,0,0,null,1986,0,-0.11104143805194128,0,0,0,{"$f":"IF(X11=time1,AB11,0)","v":0},8.5000000000000006E-2,0,0,0,0,0,0]
[null,null,null,null,null,null,null,1987,0,-0.21943334117093818,0,0,0,0,0.09,0,0,0,0,0,0,null,1987,0,-0.21943334117093818,0,0,0,0,0.09,0,0,0,0,0,0]
[null,"Equity corpus","Debt Corpus","Total corpus","% Equity","%Debt",null,1988,0,0.79129954564851768,0,0,0,0,0.09,0,0,0,0,0,0,null,1988,0,0.79129954564851768,0,0,0,0,0.09,0,0,0,0,0,0]
["no rebalancing",{"$f":"MAX(N4:N57)","v":2807877.6028980715},{"$f":"MAX(S4:S57)","v":1707778.7832421456},{"$f":"B14+C14","v":4515656.3861402171},{"$f":"B14/D14","v":0.62180940328325573},{"$f":"C14/D14","v":0.37819059671674427},null,1989,0,9.4520739910313803E-2,0,0,0,0,0.09,0,0,0,0,0,0,null,1989,0,9.4520739910313803E-2,0,0,0,0,0.09,0,0,0,0,0,0]
["annual rebalancing",{"$f":"MAX(AC4:AC60)","v":2200582.1629339396},{"$f":"MAX(AH4:AH60)","v":2729068.5797484517},{"$f":"B15+C15","v":4929650.7426823918},{"$f":"B15/D15","v":0.446397174526106},{"$f":"C15/D15","v":0.55360282547389394},null,1990,0,0.49538441841111336,0,0,0,0,0.09,0,0,0,0,0,0,null,1990,0,0.49538441841111336,0,0,0,0,0.09,0,0,0,0,0,0]
["The % equity and debt shown here represents the final asset allocation",null,null,null,null,null,null,1991,0,2.6687586153753942,0,0,0,0,0.12,0,0,0,0,0,0,null,1991,0,2.6687586153753942,0,0,0,0,0.12,0,0,0,0,0,0]
["% difference bet the two corpuses",null,{"$f":"(D15-D14)/D14","v":9.1679773911238341E-2},null,null,null,null,1992,0,-0.4677899649941657,0,0,0,0,0.11,0,0,0,0,0,0,null,1992,0,-0.4677899649941657,0,0,0,0,0.11,0,0,0,0,0,0]
["+ve means rebalanced portfolio is higher",null,null,null,null,null,null,1993,0,0.65707382526792135,0,0,0,0,0.1,0,0,0,0,0,0,null,1993,0,0.65707382526792135,0,0,0,0,0.1,0,0,0,0,0,0]
[null,null,null,null,null,null,null,1994,0,-0.13708160116856616,0,0,0,0,0.11,0,0,0,0,0,0,null,1994,0,-0.13708160116856616,0,0,0,0,0.11,0,0,0,0,0,0]
["no rebalancing",{"$f":"NPER((1+rate)/(1+inf)-1,-exp*12,corp1,,1)","v":9.4076174711254517},null,"No of years corpus will last",null,null,null,1995,0,3.2398434816741109E-2,0,0,0,0,0.12,0,0,0,0,0,0,null,1995,0,3.2398434816741109E-2,0,0,0,0,0.12,0,0,0,0,0,0]
["annual rebalancing",{"$f":"NPER((1+rate)/(1+inf)-1,-exp*12,corp2,,1)","v":10.27010571392165},"Examples are availabe in the 'Sample Data and analysis sheet'",null,null,null,null,1996,0,-1.6990384986678749E-3,0,0,0,0,0.12,0,0,0,0,0,0,null,1996,0,-1.6990384986678749E-3,0,0,0,0,0.12,0,0,0,0,0,0]
["Here we assume we are saving for retirment and detemine the no of years ",null,null,null,null,null,null,1997,1,0.15824974932235217,5000,60000,69494.984959341135,0,0.11,5000,60000,66600,0,0.5106358987445645,0.48936410125543567,null,1997,1,0.15824974932235217,5000,60000,69494.984959341135,0,0.11,5000,60000,66600,0,0.5106358987445645,0.48936410125543567]
["the corpus will last from both approaches",null,null,null,null,null,null,1998,2,-3.9249887611585633E-2,5000,60000,124412.32135342302,0,0.105,5000,60000,139893,0,0.47071440225398153,0.52928559774601847,null,1998,2,-3.9249887611585633E-2,5000,60000,123021.64279089813,0,0.105,5000,60000,141492.47919003596,0,0.46508534920402256,0.53491465079597755]
[null,null,null,null,null,null,null,1999,3,0.33725494390314326,5000,60000,246606.28844652014,0,8.5000000000000006E-2,5000,60000,216883.905,0,0.53206365945469525,0.4679363405453047,null,1999,3,0.33725494390314326,5000,60000,257096.70530979021,0,8.5000000000000006E-2,5000,60000,208598.91117465671,0,0.55207027124417141,0.44792972875582865]
["Click on the macro to find out the % difference",null,null,null,null,null,null,2000,4,-0.27930849702476163,5000,60000,220968.54684218203,0,8.5000000000000006E-2,5000,60000,300419.03692500002,0,0.42380860941416715,0.5761913905858328,null,2000,4,-0.27930849702476163,5000,60000,211052.9270650924,0,8.5000000000000006E-2,5000,60000,317739.87194281246,0,0.39912216554586138,0.60087783445413867]
["between the two corpuses for all possible ",null,null,null,null,null,null,2001,5,-3.7462753649726219E-2,5000,60000,270442.69138851186,0,7.4999999999999997E-2,5000,60000,387450.464694375,0,0.4110738786199491,0.58892612138005085,null,2001,5,-3.7462753649726219E-2,5000,60000,312243.61710447771,0,7.4999999999999997E-2,5000,60000,348726.12946674885,0,0.47240228274325435,0.52759771725674576]
["investment durations between",null,null,null,null,null,null,2002,6,-0.12124173116001562,5000,60000,290379.24743539392,0,4.2500000000000003E-2,5000,60000,466467.10944388591,0,0.3836700075200476,0.61632999247995246,null,2002,6,-0.12124173116001562,5000,60000,343141.8112566662,0,4.2500000000000003E-2,5000,60000,407080.48040025181,0,0.45738685063438156,0.54261314936561844]
[{"$f":"D3","v":1980},"and",{"$f":"F3","v":1997},null,null,null,null,2003,7,0.8337531816631244,5000,60000,642509.05977338471,0,0.04,5000,60000,547525.79382164148,0,0.53990776642583371,0.46009223357416618,null,2003,7,0.8337531816631244,5000,60000,797886.44804002438,0,0.04,5000,60000,452515.59166159737,0,0.63810392394307092,0.36189607605692908]
[null,null,null,null,null,null,null,2004,8,0.16138160483669003,5000,60000,815881.09925192781,0,5.2499999999999998E-2,5000,60000,639420.89799727767,0,0.56062666085396462,0.43937333914603527,null,2004,8,0.16138160483669003,5000,60000,795779.86007007142,0,5.2499999999999998E-2,5000,60000,721174.0733929784,0,0.52459065665454185,0.4754093433454582]
["Average % difference bet. Corpuses",null,{"$f":"AVERAGE(B33:B64)","v":0.13054108980519619},null,null,null,null,2005,9,0.737303667743754,5000,60000,1521671.4462378051,0,0.06,5000,60000,741386.15187711432,0,0.67239625164879857,0.32760374835120137,null,2005,9,0.737303667743754,5000,60000,1421943.0362664605,0,0.06,5000,60000,867585.58473541646,0,0.62106366490593645,0.37893633509406355]
["Average no of additional years the rebalanced corpus will last",null,null,{"$f":"AVERAGE(C33:C64)","v":1.51723769672042},null,null,null,2006,10,0.15887411347517733,5000,60000,1832958.0950678377,0,6.25E-2,5000,60000,851472.78636943398,0,0.68281068726435346,0.31718931273564649,null,2006,10,0.15887411347517733,5000,60000,1396170.1722783081,0,6.25E-2,5000,60000,1280062.0799072471,0,0.52169245443407253,0.47830754556592747]
["Year","% difference","Additional years",null,null,null,null,2007,11,0.19677787042632777,5000,60000,2265450.3578215651,0,7.0000000000000007E-2,5000,60000,975275.88141529437,0,0.6990563813730355,0.3009436186269645,null,2007,11,0.19677787042632777,5000,60000,1673234.4399940218,0,7.0000000000000007E-2,5000,60000,1495984.2549192721,0,0.52796433476794169,0.4720356652320582]
[1980,7.7421755545599047E-2,1.6016376064194127,null,null,null,null,2008,12,-0.37942650405256834,5000,60000,1443112.8582055345,0,0.08,5000,60000,1118097.951928518,0,0.56344946401737339,0.43655053598262666,null,2008,12,-0.37942650405256834,5000,60000,1020600.9722189957,0,0.08,5000,60000,1776178.0952531791,0,0.36492012690206882,0.63507987309793124]
[1981,0.12649156826310309,2.302727130285362,null,null,null,null,2009,13,0.80532523046814641,5000,60000,2713607.567159541,0,0.09,5000,60000,1284126.7676020847,0,0.67878636745914389,0.32121363254085611,null,2009,13,0.80532523046814641,5000,60000,2632867.4211044344,0,0.09,5000,60000,1589644.5917723353,0,0.62353106706987893,0.37646893293012113]
[1982,0.16898280245444364,2.7044824694709924,null,null,null,null,2010,14,0.10943116334797741,5000,60000,3077126.6699045631,0,0.1,5000,60000,1478539.4443622932,0,0.67545043748223965,0.32454956251776029,null,2010,14,0.10943116334797741,5000,60000,2408859.0771492207,0,0.1,5000,60000,2388381.6070822235,0,0.50213429671501653,0.49786570328498353]
[1983,0.15814623125018584,2.5015724642585102,null,null,null,null,2011,15,-0.10495242993057337,5000,60000,2807877.6028980715,2807877.6028980715,0.11,5000,60000,1707778.7832421456,1707778.7832421456,0.62180940328325573,0.37819059671674427,null,2011,15,-0.10495242993057337,5000,60000,2200582.1629339396,2200582.1629339396,0.11,5000,60000,2729068.5797484517,2729068.5797484517,0.446397174526106,0.55360282547389394]
[1984,0.19836173589813155,2.6444518726327306,null,null,null,null,"Note 35% returns listed against 1980 actually is the return"]
[1985,0.16774350294017171,2.3251580566044741,null,null,null,null,"generated in the financial year 1980-1981"]
[1986,0.23356791040514163,2.3401165081963313]
[1987,0.20912517197669059,1.8988760348430773]
[1988,0.17322162286527495,1.3243728583179291]
[1989,0.1864551126271001,1.6432678599185007]
[1990,0.14918368023234418,1.2600863965704612]
[1991,9.7853676586866348E-2,0.99644088747356285]
[1992,4.8743165736270348E-2,0.48033468274336855]
[1993,1.4818852702243051E-2,0.15886921768807838]
[1994,0.11125187491674099,0.83161375442450947]
[1995,7.4583417708813396E-2,0.77544530905536391]
[1996,6.2107760473172749E-2,0.65833718926868912]
[1997,9.1679773911238341E-2,0.86248824279619818]

{"sheet":"Sample Data and analysis","index":8,"n_rows":43,"n_cols":9,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["SIP amt ",10000,null,"Lumpsum investment of 100000",null,null,"SIP amt ",10000,"inflation at 8%"]
["duration 10 years",null,null,"duration 10 years",null,null,"duration 20 years",null,"rate of inflation at 8%"]
["equity ",0.5,null,"equity ",0.5,null,"equity ",0.5,"pension is 40000"]
["debt",0.5,null,"debt",0.5,null,"debt",0.5]
["start year","% diff bet the corpuses",null,"start year","% diff bet the corpuses",null,"start year","% diff bet the corpuses","no of years rebalanced corpus will last longer"]
[1980,1.4999999999999999E-2,null,1980,-0.03,null,1980,0.11,4]
[{"$f":"A6+1","v":1981},-1.2999999999999999E-2,null,{"$f":"D6+1","v":1981},-0.04,null,{"$f":"G6+1","v":1981},0.25700000000000001,6]
[1982,-0.157,null,1982,-0.2,null,1982,0.27700000000000002,6]
[1983,0.14099999999999999,null,1983,7.0000000000000007E-2,null,1983,0.28699999999999998,5]
[1984,0.06,null,1984,-0.03,null,1984,0.25,5]
[1985,0.158,null,1985,0.16,null,1985,0.23300000000000001,5]
[1986,0.17,null,1986,0.28000000000000003,null,1986,0.14000000000000001,4]
[1987,0.16600000000000001,null,1987,0.25,null,1987,0.1,3]
[1988,0.13500000000000001,null,1988,0.12,null,1988,0.06,2]
[1989,0.14199999999999999,null,1989,0.26,null,1989,0.23,4]
[1990,0.106,null,1990,0.22,null,1990,0.16,3]
[1991,7.1999999999999995E-2,null,1991,0.34,null,1991,0.14000000000000001,3]
[1992,-4.0000000000000001E-3,null,1992,-0.04,null,1992,0.14000000000000001,3]
[1993,-1.7999999999999999E-2,null,1993,0.02]
[1994,5.8000000000000003E-2,null,1994,0.06,null,"Average",{"$f":"AVERAGE(H6:H18)","v":0.18338461538461545},{"$f":"AVERAGE(I6:I18)","v":4.0769230769230766}]
[1995,5.1999999999999998E-2,null,1995,0.08,null,"Std Dev",{"$f":"STDEV(H6:H18)","v":7.5137139575510353E-2},{"$f":"STDEV(I6:I18)","v":1.2557559782549625}]
[1996,2.1000000000000001E-2,null,1996,0.08]
[1997,-3.0000000000000001E-3,null,1997,0.05,null,"longer the duration higher is the benefit of rebalancing: 18% avg for 20 years compared to 5% for 10 years (more data though)"]
[1998,-0.03,null,1998,0.04,null,"Although large % difference variations does not lead to a big differnece"]
[1999,7.4999999999999997E-2,null,1999,0.14000000000000001,null,"in the no of extra years rebalancing adds to the folio"]
[2000,2.9000000000000001E-2,null,2000,0.13,null,"an average of 4 extra years is still significant"]
[2001,1.4E-2,null,2001,0.02,null,"I would think a % difference of less 5% should not make much"]
[2002,4.7E-2,null,2002,0.05,null,"of a difference to your financial goals"]
["+ve % means rebalanced portfolio is higher",null,null,null,null,null,"However we are using historical data and you will know if "]
["Average",{"$f":"AVERAGE(B6:B28)","v":5.3739130434782602E-2},null,"Average",{"$f":"AVERAGE(E6:E28)","v":8.8260869565217406E-2},null,"rebalancing has a made a difference only if you do it"]
["Std Dev",{"$f":"STDEV(B6:B28)","v":7.8323465305049578E-2},null,"Std Dev",{"$f":"STDEV(E6:E28)","v":0.12496007267461813},null,"It certainly can't hurt and is most likely to benefit you"]
[]
["As expected benefits of rebalancing are higher for lumpsum investments. On an average the rebalanced portfolio"]
["is 9% higher than the folio with no rebalancing. For SIP invesments it is 5% higher."]
["The standard deviation for lumpsum investment is 12% which means the spead in individuals nos is higher"]
[]
["A 5% higher corpus due to rebalancing a portfolio with SIP instruments is good"]
["But is it significant? This is tougher to answer."]
["If during the process of goal planning you had taken precautions to"]
["underestimate interest rates and overestimate inflation "]
["your extimated corpus is likely to be lower than the corpus obtained"]
["with no rebalancing. If so you don’t care about rebalancing"]
["There is no way to know unless you rebalance so might as well give it a shot. It can’t hurt!"]