{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Lump sum","SIP"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Lump sum","index":0,"n_rows":32,"n_cols":20,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Year","year start","Return","investment","year end","Inputs for IRR",null,"Year","year start","Return","investment","year end","Inputs for IRR",null,"Year","year start","Return","investment","year end"]
[0,0,0.2,12000,{"$f":"D2*(1+C2)","v":14400},{"$f":"-D2","v":-12000},null,0,0,0.2,12000,{"$f":"K2*(1+J2)","v":14400},{"$f":"-K2","v":-12000},null,0,0,0.2,12000,{"$f":"R2*(1+Q2)","v":14400},{"$f":"-R2","v":-12000}]
[{"$f":"A2+1","v":1},{"$f":"E2","v":14400},0.2,null,{"$f":"(D3+E2)*(1+C3)","v":17280},{"$f":"-D3","v":0},null,{"$f":"H2+1","v":1},{"$f":"L2","v":14400},-0.2,null,{"$f":"(K3+L2)*(1+J3)","v":11520},{"$f":"-K3","v":0},null,{"$f":"O2+1","v":1},{"$f":"S2","v":14400},-0.2,null,{"$f":"(R3+S2)*(1+Q3)","v":11520},{"$f":"-R3","v":0}]
[{"$f":"A3+1","v":2},{"$f":"E3","v":17280},0.2,null,{"$f":"(D4+E3)*(1+C4)","v":20736},0,null,{"$f":"H3+1","v":2},{"$f":"L3","v":11520},1.2250000000000001,null,{"$f":"(K4+L3)*(1+J4)","v":25632},0,null,{"$f":"O3+1","v":2},{"$f":"S3","v":11520},1.2250000000000001,null,{"$f":"(R4+S3)*(1+Q4)","v":25632},0]
[3,20736,0.2,null,24883.200000000001,0,null,3,25632,-0.1,null,23068.799999999999,0,null,3,25632,-0.1,null,23068.799999999999,0]
[4,24883.200000000001,0.2,null,29859.84,0,null,4,23068.799999999999,5.0602000000000001E-2,null,24236.127417600001,0,null,4,23068.799999999999,5.0602000000000001E-2,null,24236.127417600001,0]
[5,29859.84,0.2,null,35831.807999999997,0,null,5,24236.127417600001,0.1,null,26659.740159360004,0,null,5,24236.127417600001,0.1,null,26659.740159360004,0]
[6,35831.807999999997,0.2,null,42998.169599999994,0,null,6,26659.740159360004,-0.15,null,22660.779135456003,0,null,6,26659.740159360004,-0.15,null,22660.779135456003,0]
[7,42998.169599999994,0.2,null,51597.803519999994,0,null,7,22660.779135456003,0.15,null,26059.896005774401,0,null,7,22660.779135456003,0.15,null,26059.896005774401,0]
[8,51597.803519999994,0.2,null,61917.36422399999,0,null,8,26059.896005774401,1.25,null,58634.766012992404,0,null,8,26059.896005774401,1.25,null,58634.766012992404,0]
[9,61917.36422399999,0.2,null,74300.837068799985,0,null,9,58634.766012992404,0.3,null,76225.195816890133,0,null,9,58634.766012992404,0.3,null,76225.195816890133,0]
[10,74300.837068799985,0.2,null,89161.004482559976,0,null,10,76225.195816890133,0.4,null,106715.27414364618,0,null,10,76225.195816890133,0.4,null,106715.27414364618,0]
[11,89161.004482559976,0.2,null,106993.20537907197,0,null,11,106715.27414364618,-0.3,null,74700.691900552323,0,null,11,106715.27414364618,-0.3,null,74700.691900552323,0]
[12,106993.20537907197,0.2,null,128391.84645488636,0,null,12,74700.691900552323,0.8,null,134461.24542099418,0,null,12,74700.691900552323,0.706160605,null,127451.37768696494,0]
[13,128391.84645488636,0.2,null,154070.21574586362,0,null,13,134461.24542099418,0.25,null,168076.55677624274,0,null,13,127451.37768696494,0.22,null,155490.68077809722,0]
[14,154070.21574586362,0.2,null,184884.25889503633,0,null,14,168076.55677624274,0.1,null,184884.21245386702,0,null,14,155490.68077809722,0.01,null,157045.58758587818,0]
[15,{"$f":"E16","v":184884.25889503633},null,null,null,{"$f":"E16","v":184884.25889503633},null,15,184884.21245386702,null,null,null,{"$f":"L16","v":184884.21245386702},null,15,157045.58758587818,null,null,null,{"$f":"S16","v":157045.58758587818}]
[]
[null,"CAGR",{"$f":"((1+C2)*(1+C3)*(1+C4)*(1+C5)*(1+C6)*(1+C7)*(1+C8)*(1+C9)*(1+C10)*(1+C11)*(1+C12)*(1+C13)*(1+C14)*(1+C15)*(1+C16))^(1/15)-1","v":0.19999999999999996},null,"IRR",{"$f":"IRR(F2:F17)","v":0.19999999999999987},null,null,"CAGR",{"$f":"((1+J2)*(1+J3)*(1+J4)*(1+J5)*(1+J6)*(1+J7)*(1+J8)*(1+J9)*(1+J10)*(1+J11)*(1+J12)*(1+J13)*(1+J14)*(1+J15)*(1+J16))^(1/15)-1","v":0.1999999799047576},null,"IRR",{"$f":"IRR(M2:M17)","v":0.19999997990475757},null,null,null,{"$f":"((1+Q2)*(1+Q3)*(1+Q4)*(1+Q5)*(1+Q6)*(1+Q7)*(1+Q8)*(1+Q9)*(1+Q10)*(1+Q11)*(1+Q12)*(1+Q13)*(1+Q14)*(1+Q15)*(1+Q16))^(1/15)-1","v":0.18701525271469444},null,null,{"$f":"IRR(T2:T17)","v":0.18701525271469446}]
[]
[null,null,{"$f":"AVERAGE(C2:C16)","v":0.20000000000000004},null,{"$f":"D2*(1+20%)^15","v":184884.25889503639},null,null,null,null,{"$f":"AVERAGE(J2:J16)","v":0.27170679999999997},null,null,null,null,null,{"$f":"P17-B17","v":-27838.671309158148},{"$f":"AVERAGE(Q2:Q16)","v":0.25745084033333332}]
[null,null,{"$f":"STDEV(C2:C16)","v":2.872975021810196E-17},null,null,null,null,null,null,{"$f":"STDEV(J2:J16)","v":0.4747794062893389},null,null,null,null,null,null,{"$f":"STDEV(Q2:Q16)","v":0.47083772869162788}]
[]
[null,null,{"$f":"((1+C21)^2-C22^2)^0.5-1","v":0.19999999999999996},null,null,null,null,null,null,{"$f":"((1+J21)^2-J22^2)^0.5-1","v":0.17975535622000161},null,null,null,null,null,null,{"$f":"((1+Q21)^2-Q22^2)^0.5-1","v":0.16597360565988595}]
[null,null,null,null,{"$f":"F19-C24","v":0},null,null,null,null,null,null,{"$f":"M19-J24","v":2.0244623684755964E-2},null,null,null,null,null,null,{"$f":"T19-Q24","v":2.1041647054808515E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(((1+Q21)^2-Q22^2)-1)/2","v":0.1797472245477576},null,{"$f":"S25/2","v":1.0520823527404258E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q19+S26","v":0.19753607624209868}]
[]
[]
[]
[12000,2002]
[100000,2015,{"$f":"(A32/A31)^(1/(B32-B31))-1","v":0.17715109743802482}]

{"sheet":"SIP","index":1,"n_rows":28,"n_cols":28,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
["Year","year start","Return","investment","year end","Inputs for IRR",null,null,null,"Year","year start","Return","investment","year end","Inputs for IRR",null,null,"Year","year start","Return","investment","year end","Inputs for IRR"]
[0,0,0.2,12000,{"$f":"D2*(1+C2)","v":14400},{"$f":"-D2","v":-12000},null,{"$f":"(1+C2)","v":1.2},null,0,0,0.2,12000,{"$f":"M2*(1+L2)","v":14400},{"$f":"-M2","v":-12000},null,null,0,0,0.2,12000,{"$f":"U2*(1+T2)","v":14400},{"$f":"-U2","v":-12000},null,{"$f":"(1+T2)","v":1.2},null,{"$f":"(1+T2)","v":1.2}]
[{"$f":"A2+1","v":1},{"$f":"E2","v":14400},0.2,{"$f":"D2","v":12000},{"$f":"(D3+E2)*(1+C3)","v":31680},{"$f":"-D3","v":-12000},null,{"$f":"(1+C3)*(1+H2)","v":2.64},null,{"$f":"J2+1","v":1},{"$f":"N2","v":14400},-0.2,{"$f":"M2","v":12000},{"$f":"(M3+N2)*(1+L3)","v":21120},{"$f":"-M3","v":-12000},null,null,{"$f":"R2+1","v":1},{"$f":"V2","v":14400},-0.2,{"$f":"U2","v":12000},{"$f":"(U3+V2)*(1+T3)","v":21120},{"$f":"-U3","v":-12000},null,{"$f":"(1+T3)*(1+Y2)","v":1.7600000000000002},null,{"$f":"(1+T3)","v":0.8}]
[{"$f":"A3+1","v":2},{"$f":"E3","v":31680},0.2,{"$f":"D3","v":12000},{"$f":"(D4+E3)*(1+C4)","v":52416},-12000,null,{"$f":"(1+C4)*(1+H3)","v":4.3680000000000003},null,{"$f":"J3+1","v":2},{"$f":"N3","v":21120},1.2250000000000001,{"$f":"M3","v":12000},{"$f":"(M4+N3)*(1+L4)","v":73692},-12000,null,null,{"$f":"R3+1","v":2},{"$f":"V3","v":21120},1.2250000000000001,{"$f":"U3","v":12000},{"$f":"(U4+V3)*(1+T4)","v":73692},-12000,null,{"$f":"(1+T4)*(1+Y3)","v":6.1410000000000009},null,2.2250000000000001]
[3,52416,0.2,12000,77299.199999999997,-12000,null,{"$f":"(1+C5)*(1+H4)","v":6.4416000000000002},null,3,73692,-0.1,12000,77122.8,-12000,null,null,3,73692,-0.1,12000,77122.8,-12000,null,{"$f":"(1+T5)*(1+Y4)","v":6.4269000000000007},null,0.9]
[4,77299.199999999997,0.2,12000,107159.03999999999,-12000,null,8.9299199999999992,null,4,77122.8,5.0602000000000001E-2,12000,93632.591925600005,-12000,null,null,4,77122.8,5.0602000000000001E-2,12000,93632.591925600005,-12000,null,7.8027159938000006,null,1.050602]
[5,107159.03999999999,0.2,12000,142990.848,-12000,null,11.915903999999999,null,5,93632.591925600005,0.1,12000,116195.85111816002,-12000,null,null,5,93632.591925600005,0.1,12000,116195.85111816002,-12000,null,9.68298759318,null,1.1000000000000001]
[6,142990.848,0.2,12000,185989.01759999999,-12000,null,15.499084799999999,null,6,116195.85111816002,-0.15,12000,108966.47345043601,-12000,null,null,6,116195.85111816002,-0.15,12000,108966.47345043601,-12000,null,9.0805394542030005,null,0.85]
[7,185989.01759999999,0.2,12000,237586.82111999998,-12000,null,19.798901759999996,null,7,108966.47345043601,0.15,12000,139111.4444680014,-12000,null,null,7,108966.47345043601,0.15,12000,139111.4444680014,-12000,null,11.59262037233345,null,1.1499999999999999]
[8,237586.82111999998,0.2,12000,299504.18534399994,-12000,null,24.958682111999995,null,8,139111.4444680014,1.25,12000,340000.75005300314,-12000,null,null,8,139111.4444680014,1.25,12000,340000.75005300314,-12000,null,28.33339583775026,null,2.25]
[9,299504.18534399994,0.2,12000,373805.02241279994,-12000,null,31.150418534399993,null,9,340000.75005300314,0.3,12000,457600.97506890411,-12000,null,null,9,340000.75005300314,0.3,12000,457600.97506890411,-12000,null,38.133414589075336,null,1.3]
[10,373805.02241279994,0.2,12000,462966.02689535992,-12000,null,38.580502241279987,null,10,457600.97506890411,0.4,12000,657441.36509646568,-12000,null,null,10,457600.97506890411,0.4,12000,657441.36509646568,-12000,null,54.786780424705469,null,1.4]
[11,462966.02689535992,0.2,12000,569959.23227443185,-12000,null,47.496602689535983,null,11,657441.36509646568,-0.3,12000,468608.95556752593,-12000,null,null,11,657441.36509646568,-0.3,12000,468608.95556752593,-12000,null,39.050746297293827,null,0.7]
[12,569959.23227443185,0.2,12000,698351.07872931822,-12000,null,58.195923227443174,null,12,468608.95556752593,0.8,12000,865096.12002154673,-12000,null,null,12,468608.95556752593,0.706160605,12000,819996.06639950816,-12000,null,68.333005533292351,null,1.706160605]
[13,698351.07872931822,0.2,12000,852421.29447518184,-12000,null,71.035107872931803,null,13,865096.12002154673,0.25,12000,1096370.1500269333,-12000,null,null,13,819996.06639950816,0.22,12000,1015035.2010073999,-12000,null,84.586266750616673,null,1.22]
[14,852421.29447518184,0.2,12000,1037305.5533702181,-12000,null,86.442129447518155,null,14,1096370.1500269333,0.1,12000,1219207.1650296268,-12000,null,null,14,1015035.2010073999,0.01,12000,1037305.5530174739,-12000,null,86.442129418122846,null,1.01]
[15,1037305.5533702181,null,null,null,{"$f":"E16","v":1037305.5533702181},null,null,null,15,1219207.1650296268,null,null,null,{"$f":"N16","v":1219207.1650296268},null,null,15,1037305.5530174739,null,null,null,{"$f":"V16","v":1037305.5530174739}]
[]
[null,"CAGR",{"$f":"((1+C2)*(1+C3)*(1+C4)*(1+C5)*(1+C6)*(1+C7)*(1+C8)*(1+C9)*(1+C10)*(1+C11)*(1+C12)*(1+C13)*(1+C14)*(1+C15)*(1+C16))^(1/15)-1","v":0.19999999999999996},null,"IRR",{"$f":"IRR(F2:F17)","v":0.19999999999999338},null,{"$f":"H16*D16","v":1037305.5533702179},null,null,"CAGR",{"$f":"((1+L2)*(1+L3)*(1+L4)*(1+L5)*(1+L6)*(1+L7)*(1+L8)*(1+L9)*(1+L10)*(1+L11)*(1+L12)*(1+L13)*(1+L14)*(1+L15)*(1+L16))^(1/15)-1","v":0.1999999799047576},null,"IRR",{"$f":"IRR(O2:O17)","v":0.21753783514224659},null,null,null,"CAGR",{"$f":"((1+T2)*(1+T3)*(1+T4)*(1+T5)*(1+T6)*(1+T7)*(1+T8)*(1+T9)*(1+T10)*(1+T11)*(1+T12)*(1+T13)*(1+T14)*(1+T15)*(1+T16))^(1/15)-1","v":0.18701525271469444},null,"IRR",{"$f":"IRR(W2:W17)","v":0.19999999996303441},null,{"$f":"Y16*U16","v":1037305.5530174741},null,{"$f":"PRODUCT(AA2:AA16)-1","v":12.087132298823184}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(1+T24)*AA19/T24","v":{"$error":"#DIV/0!"}}]
[null,null,{"$f":"AVERAGE(C2:C16)","v":0.20000000000000004}]
[null,null,{"$f":"STDEV(C2:C16)","v":2.872975021810196E-17},null,null,null,null,{"$f":"(K17-H19)/H19","v":0.17535972025639737}]
[]
[null,null,{"$f":"((1+C21)^2-C22^2)^0.5-1","v":0.19999999999999996},null,null,null,{"$f":"(1+20%)*12000*((1+20%)^15-1)/20%","v":1037305.5533702183}]
[null,null,null,null,{"$f":"F19-C24","v":-6.5780714209040525E-15}]
[]
[]
[null,null,null,null,{"$f":"C27/D16","v":0}]