{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Interest Free Loan"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Interest Free Loan","index":0,"n_rows":70,"n_cols":5,"rows_kept":70,"cut":false,"hidden":false,"merged":[]}
["Loan amount:",50000]
["Total Months:",48,"Max 60"]
["Interest free periods:",12]
["Interest rate p.a.",0.05]
["Estimated monthy repayment",null,"Goal seek"]
["Closing Loan Balance",null,null,{"$f":"IF(ABS(E6)<=1,\"\",IF(E6<0,\"OverPaid\",\"UnderPaid\"))","v":"UnderPaid"},{"$f":"INDEX(E10:E70,B2+1)","v":58073.611566673419}]
[]
["Totals",{"$f":"SUM(B10:B703)","v":0},{"$f":"SUM(C10:C703)","v":-8073.6115666734149},8073.6115666734149]
["Years","Repayment","Interest","Principal","Balance"]
[{"$f":"_xlfn.SEQUENCE(B2+1,1,0)","v":0},{"$f":"IF(_xlfn.ANCHORARRAY(A10)=0,0,$B$5)","v":0},{"$f":"IF(A10<=$B$3,0,-E9*$B$4/12)","v":0},{"$f":"B10-C10","v":0},{"$f":"IF(A10=\"\",0,IF(A10=0,$B$1,E9+D10))","v":50000}]
[1,0,{"$f":"IF(A11<=$B$3,0,-E10*$B$4/12)","v":0},{"$f":"B11-C11","v":0},{"$f":"IF(A11=\"\",0,IF(A11=0,$B$1,E10+D11))","v":50000}]
[2,0,0,0,50000]
[3,0,0,0,50000]
[4,0,0,0,50000]
[5,0,0,0,50000]
[6,0,0,0,50000]
[7,0,0,0,50000]
[8,0,0,0,50000]
[9,0,0,0,50000]
[10,0,0,0,50000]
[11,0,0,0,50000]
[12,0,0,0,50000]
[13,0,-208.33333333333334,208.33333333333334,50208.333333333336]
[14,0,-209.20138888888891,209.20138888888891,50417.534722222226]
[15,0,-210.07306134259261,210.07306134259261,50627.607783564818]
[16,0,-210.94836576485341,210.94836576485341,50838.55614932967]
[17,0,-211.82731728887362,211.82731728887362,51050.383466618543]
[18,0,-212.70993111091062,212.70993111091062,51263.093397729455]
[19,0,-213.59622249053942,213.59622249053942,51476.689620219993]
[20,0,-214.48620675091664,214.48620675091664,51691.17582697091]
[21,0,-215.37989927904547,215.37989927904547,51906.555726249957]
[22,0,-216.27731552604152,216.27731552604152,52122.833041776001]
[23,0,-217.17847100740002,217.17847100740002,52340.0115127834]
[24,0,-218.08338130326419,218.08338130326419,52558.094894086666]
[25,0,-218.99206205869447,218.99206205869447,52777.086956145358]
[26,0,-219.904528983939,219.904528983939,52996.9914851293]
[27,0,-220.82079785470543,220.82079785470543,53217.812282984007]
[28,0,-221.74088451243338,221.74088451243338,53439.553167496437]
[29,0,-222.66480486456851,222.66480486456851,53662.217972361002]
[30,0,-223.59257488483752,223.59257488483752,53885.810547245841]
[31,0,-224.52421061352436,224.52421061352436,54110.334757859368]
[32,0,-225.45972815774738,225.45972815774738,54335.794486017112]
[33,0,-226.39914369173798,226.39914369173798,54562.193629708847]
[34,0,-227.34247345712024,227.34247345712024,54789.53610316597]
[35,0,-228.28973376319155,228.28973376319155,55017.825836929165]
[36,0,-229.24094098720488,229.24094098720488,55247.06677791637]
[37,0,-230.19611157465155,230.19611157465155,55477.262889491023]
[38,0,-231.15526203954596,231.15526203954596,55708.418151530568]
[39,0,-232.11840896471071,232.11840896471071,55940.536560495282]
[40,0,-233.08556900206369,233.08556900206369,56173.622129497344]
[41,0,-234.05675887290559,234.05675887290559,56407.678888370247]
[42,0,-235.03199536820935,235.03199536820935,56642.710883738459]
[43,0,-236.01129534891027,236.01129534891027,56878.722179087366]
[44,0,-236.99467574619737,236.99467574619737,57115.716854833561]
[45,0,-237.98215356180651,237.98215356180651,57353.699008395364]
[46,0,-238.97374586831404,238.97374586831404,57592.67275426368]
[47,0,-239.96946980943201,239.96946980943201,57832.642224073112]
[48,0,-240.96934260030466,240.96934260030466,58073.611566673419]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]
[null,null,0,0,0]