{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["FD days"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":54,"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":"FD days","index":0,"n_rows":19,"n_cols":16,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,1,1],[0,56,0,57],[4,3,4,8],[8,3,8,8],[3,0,3,1],[18,1,18,6],[36,0,36,1],[5,3,5,8],[6,3,6,8],[9,3,9,8],[7,3,7,8],[21,6,21,8],[11,1,11,3],[15,0,15,7],[16,0,16,7],[17,0,17,5]]}
["Fixed Deposit Calculator",null,null,"Note: interest from FD is taxable on accrural basis. ",null,null,null,null,null,null,null,null,{"$f":"IF(term=\"Quarterly\",4,IF(term=\"Half-yearly\",2,IF(term=\"Yearly\",1,IF(term=\"Monthly\",12))))","v":1},null,0]
[null,null,null," Tax has to be paid as per slab each financial year",null,null,null,null,null,null,null,null,{"$f":"IF(term=\"Quarterly\",3,IF(term=\"Half-yearly\",6,IF(term=\"Yearly\",12,IF(term=\"Monthly\",1))))","v":12},null,0.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.2]
["Fill only the cells with green background",null,null,"Bank will deduct 10.3% tax. Rest has to be paid by you",null,null,null,null,null,null,null,363.92731518445498,1.0679009137720767,{"$f":"raterd/M4","v":9.3641646626910852E-2},0.3,12.164936994325123]
["Interest Rate",0.1,null,null,null,null,null,null,null,null,null,{"$f":"(1+raterd)^(1/L4)-1","v":2.6192774620792392E-4}]
["Investment",400000,null,null,null,null,null,null,null,null,null,null,null,"Quarterly"]
["Type of Compounding","Yearly",null,"Most banks use quarterly compounding for FDs and RDs",null,null,null,null,null,null,null,null,null,"Half-yearly"]
["Date when FD was opened","2011-11-28",null,null,null,null,null,null,null,null,null,null,null,"Yearly"]
["Date of maturity","2014-08-28",null,null,null,null,null,null,null,null,null,null,null,"Monthly"]
["Applicable tax slab ",0]
[]
["Duration in days",{"$f":"DATEDIF(B8,B9,\"d\")","v":1004},null,null,"Pre-tax Corpus",null,"Post-tax Coprus"]
["If no of days in a year is taken as 365, the maturity value is",null,null,null,{"$f":"fdamt*(1+raterd/factor1)^(factor1*DATEDIF(B8,B9,\"d\")/365)","v":519898.09567491914},null,{"$f":"fdamt+(E13-fdamt)*(1-IF(taxrd=10%,10.3%,IF(taxrd=20%,20.6%,IF(taxrd=30%,30.9%))))","v":519898.09567491914},null,null,null,null,{"$f":"fdamt*(1+L5)^(365*DATEDIF(B8,B9,\"d\")/365)","v":520300.00090160116},{"$f":"fdamt*(1+raterd/M4)^(M4*DATEDIF(B8,B9,\"d\")/365)","v":520299.9999995465},null,null,{"$f":"fdamt*(1+raterd/P4)^(P4*DATEDIF(B8,B9,\"d\")/365)","v":526056.49870224833}]
["If no of days in a year is taken as 360, the maturity value is",null,null,null,{"$f":"fdamt*(1+raterd/factor1)^(factor1*DATEDIF(B8,B9,\"d\")/360)","v":521794.61289136775},null,{"$f":"fdamt+(E14-fdamt)*(1-IF(taxrd=10%,10.3%,IF(taxrd=20%,20.6%,IF(taxrd=30%,30.9%))))","v":521794.61289136775}]
[]
["if both the above corpus values do not match with your bank statement, you could find out the 'effective'"]
["number of days in a year you bank has used to calculate the maturity value",null,null,null,null,null,null,null,null,null,null,{"$f":"fdamt*(1+L5)^#REF!","v":{"$error":"#REF!"}}]
["To do this enter the exact maturity value as per bank statement",null,null,null,null,null,520300,null,null,null,null,null,{"$f":"fdamt*(1+raterd/factor1)^(factor1*DATEDIF(B8,B9,\"d\")/H19)","v":520300.00000001059}]
[null,"The 'effective' number of days in a year used is",null,null,null,null,null,363.92731758281292]