{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Tax Formulas - IPTM.ORG.IN","Income Slabs"],"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":"Tax Formulas - IPTM.ORG.IN","index":0,"n_rows":4,"n_cols":11,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Code","Tax Regime","Status","Taxable Income","Income Tax","Rebate","Balance Tax","Surcharge","Total Tax","Cess","Net Tax"]
[null,"New Regime","G",710000,{"$f":"ROUND(IF(B2=\"Old Regime\",IF(C2=\"S\",IF(D2<=300000,0,IF(D2<=500000,(D2-300000)*5%,IF(D2<=1000000,(D2-500000)*20%+10000,(D2-1000000)*30%+110000))),IF(D2<=250000,0,IF(D2<=500000,(D2-250000)*5%,IF(D2<=1000000,(D2-500000)*20%+12500,(D2-1000000)*30%+112500)))),IF(D2<=300000,0,IF(D2<=600000,(D2-300000)*5%,IF(D2<=900000,(D2-600000)*10%+15000,IF(D2<=1200000,(D2-900000)*15%+15000+30000,IF(D2<=1500000,(D2-1200000)*20%+15000+30000+45000,(D2-1500000)*30%+15000+30000+45000+60000)))))),0)","v":26000},{"$f":"IF(B2=\"Old Regime\",IF(D2>500000,0,IF(C2=\"G\",MIN(E2,12500),MIN(E2,10000))),IF(AND(D2>700000,D2<=727778),E2-(D2-700000),IF(D2>700000,0,MIN(E2,25000))))","v":16000},{"$f":"E2-F2","v":10000},{"$f":"ROUND(IF(B2=\"Old Regime\",IF(C2=\"S\",IF(D2<=5000000,0,IF(D2<=5195530,(D2-5000000)*70%,IF(D2<=10000000,G2*10%,IF(D2<=10214510,(D2-10000000)*70%+281000,IF(D2<=20000000,G2*15%,IF(D2<=20929600,(D2-20000000)*70%+871500,IF(D2<=50000000,G2*25%,IF(D2<=53017320,(D2-50000000)*70%+3702500,G2*37%)))))))),IF(D2<=5000000,0,IF(D2<=5195890,(D2-5000000)*70%,IF(D2<=10000000,G2*10%,IF(D2<=10214700,(D2-10000000)*70%+281250,IF(D2<=20000000,G2*15%,IF(D2<=20930000,(D2-20000000)*70%+871875,IF(D2<=50000000,G2*25%,IF(D2<=53017830,(D2-50000000)*70%+3703125,G2*37%))))))))),IF(D2<=5000000,0,IF(D2<=5179105,(D2-5000000)*70%,IF(D2<=10000000,G2*10%,IF(D2<=10206107,(D2-10000000)*70%+270000,IF(D2<=20000000,G2*15%,IF(D2<=20912000,(D2-20000000)*70%+855000,G2*25%))))))),0)","v":0},{"$f":"G2+H2","v":10000},{"$f":"ROUND(I2*4%,0)","v":400},{"$f":"SUM(I2:J2)","v":10400}]
[null,"Old Regime","G",0,{"$f":"ROUND(IF(B3=\"Old Regime\",IF(C3=\"S\",IF(D3<=300000,0,IF(D3<=500000,(D3-300000)*5%,IF(D3<=1000000,(D3-500000)*20%+10000,(D3-1000000)*30%+110000))),IF(D3<=250000,0,IF(D3<=500000,(D3-250000)*5%,IF(D3<=1000000,(D3-500000)*20%+12500,(D3-1000000)*30%+112500)))),IF(D3<=300000,0,IF(D3<=600000,(D3-300000)*5%,IF(D3<=900000,(D3-600000)*10%+15000,IF(D3<=1200000,(D3-900000)*15%+15000+30000,IF(D3<=1500000,(D3-1200000)*20%+15000+30000+45000,(D3-1500000)*30%+15000+30000+45000+60000)))))),0)","v":0},{"$f":"IF(B3=\"Old Regime\",IF(D3>500000,0,IF(C3=\"G\",MIN(E3,12500),MIN(E3,10000))),IF(AND(D3>700000,D3<=727778),E3-(D3-700000),IF(D3>700000,0,MIN(E3,25000))))","v":0},{"$f":"E3-F3","v":0},{"$f":"ROUND(IF(B3=\"Old Regime\",IF(C3=\"S\",IF(D3<=5000000,0,IF(D3<=5195530,(D3-5000000)*70%,IF(D3<=10000000,G3*10%,IF(D3<=10214510,(D3-10000000)*70%+281000,IF(D3<=20000000,G3*15%,IF(D3<=20929600,(D3-20000000)*70%+871500,IF(D3<=50000000,G3*25%,IF(D3<=53017320,(D3-50000000)*70%+3702500,G3*37%)))))))),IF(D3<=5000000,0,IF(D3<=5195890,(D3-5000000)*70%,IF(D3<=10000000,G3*10%,IF(D3<=10214700,(D3-10000000)*70%+281250,IF(D3<=20000000,G3*15%,IF(D3<=20930000,(D3-20000000)*70%+871875,IF(D3<=50000000,G3*25%,IF(D3<=53017830,(D3-50000000)*70%+3703125,G3*37%))))))))),IF(D3<=5000000,0,IF(D3<=5179105,(D3-5000000)*70%,IF(D3<=10000000,G3*10%,IF(D3<=10206107,(D3-10000000)*70%+270000,IF(D3<=20000000,G3*15%,IF(D3<=20912000,(D3-20000000)*70%+855000,G3*25%))))))),0)","v":0},{"$f":"G3+H3","v":0},{"$f":"ROUND(I3*4%,0)","v":0},{"$f":"SUM(I3:J3)","v":0}]
[null,"Old Regime","S",0,{"$f":"ROUND(IF(B4=\"Old Regime\",IF(C4=\"S\",IF(D4<=300000,0,IF(D4<=500000,(D4-300000)*5%,IF(D4<=1000000,(D4-500000)*20%+10000,(D4-1000000)*30%+110000))),IF(D4<=250000,0,IF(D4<=500000,(D4-250000)*5%,IF(D4<=1000000,(D4-500000)*20%+12500,(D4-1000000)*30%+112500)))),IF(D4<=300000,0,IF(D4<=600000,(D4-300000)*5%,IF(D4<=900000,(D4-600000)*10%+15000,IF(D4<=1200000,(D4-900000)*15%+15000+30000,IF(D4<=1500000,(D4-1200000)*20%+15000+30000+45000,(D4-1500000)*30%+15000+30000+45000+60000)))))),0)","v":0},0,{"$f":"E4-F4","v":0},{"$f":"ROUND(IF(B4=\"Old Regime\",IF(C4=\"S\",IF(D4<=5000000,0,IF(D4<=5195530,(D4-5000000)*70%,IF(D4<=10000000,G4*10%,IF(D4<=10214510,(D4-10000000)*70%+281000,IF(D4<=20000000,G4*15%,IF(D4<=20929600,(D4-20000000)*70%+871500,IF(D4<=50000000,G4*25%,IF(D4<=53017320,(D4-50000000)*70%+3702500,G4*37%)))))))),IF(D4<=5000000,0,IF(D4<=5195890,(D4-5000000)*70%,IF(D4<=10000000,G4*10%,IF(D4<=10214700,(D4-10000000)*70%+281250,IF(D4<=20000000,G4*15%,IF(D4<=20930000,(D4-20000000)*70%+871875,IF(D4<=50000000,G4*25%,IF(D4<=53017830,(D4-50000000)*70%+3703125,G4*37%))))))))),IF(D4<=5000000,0,IF(D4<=5179105,(D4-5000000)*70%,IF(D4<=10000000,G4*10%,IF(D4<=10206107,(D4-10000000)*70%+270000,IF(D4<=20000000,G4*15%,IF(D4<=20912000,(D4-20000000)*70%+855000,G4*25%))))))),0)","v":0},{"$f":"G4+H4","v":0},{"$f":"ROUND(I4*4%,0)","v":0},{"$f":"SUM(I4:J4)","v":0}]

{"sheet":"Income Slabs","index":1,"n_rows":51,"n_cols":15,"rows_kept":51,"cut":false,"hidden":false,"merged":[[40,2,40,7],[14,2,14,7],[1,1,1,4],[28,1,28,4]]}
[]
[null,">>>> Old Tax Slabs"]
[null,null,"SLAB","STATUS","Income From","Income Up to","Tax Rate","Tax Amount",null,"SLAB","STATUS","Income From","Income Up to","Surcharge","Tax Amount"]
[null,null,"OLD SLAB","General",0,250000,0,0,null,"Old Slab","General",0,5000000,0,0]
[null,null,"OLD SLAB","General",{"$f":"F4+1","v":250001},500000,5,{"$f":"ROUND((F5-E5)*G5%,0)","v":12500},null,"Old Slab","General",{"$f":"+M4+1","v":5000001},5195890,"Marginal",0]
[null,null,"OLD SLAB","General",{"$f":"F5+1","v":500001},1000000,20,{"$f":"ROUND((F6-E6)*G6%,0)","v":100000},null,"Old Slab","General",5195891,10000000,10,0]
[null,null,"OLD SLAB","General",{"$f":"F6+1","v":1000001},">",30,{"$f":"H6+H5","v":112500},null,"Old Slab","General",10000001,10214700,"Marginal",281250]
[null,null,null,null,null,null,null,null,null,"Old Slab","General",10214701,20000000,15,0]
[null,null,"OLD SLAB","Senior Citizen",0,300000,0,0,null,"Old Slab","General",20000001,20930000,"Marginal",871875]
[null,null,"OLD SLAB","Senior Citizen",{"$f":"F9+1","v":300001},500000,5,{"$f":"ROUND((F10-E10)*G10%,0)","v":10000},null,"Old Slab","General",20930001,50000000,25,0]
[null,null,"OLD SLAB","Senior Citizen",{"$f":"F10+1","v":500001},1000000,20,{"$f":"ROUND((F11-E11)*G11%,0)","v":100000},null,"Old Slab","General",50000001,53017830,"Marginal",3703125]
[null,null,"OLD SLAB","Senior Citizen",{"$f":"F11+1","v":1000001},">",30,{"$f":"H11+H10","v":110000},null,"Old Slab","General",53017831,">",37,0]
[]
[]
[null,null,"Additional Tax Slab",null,null,null,null,null,null,"SLAB","STATUS","Income From","Income Up to","Surcharge","Tax Amount"]
[null,null,"SLAB","Income Up to","Tax","Surcharge","Cess","Add Tax",null,"Old Slab","Senior Citizen",0,5000000,0,0]
[null,null,"Old Slab",250000,0,{"$f":"E17*0%","v":0},{"$f":"(E17+F17)*4%","v":0},{"$f":"G17+F17+E17","v":0},null,"Old Slab","Senior Citizen",{"$f":"+M16+1","v":5000001},5195530,"Marginal",0]
[null,null,"Old Slab",500000,5,{"$f":"E18*0%","v":0},0.2,5.2,null,"Old Slab","Senior Citizen",5195531,10000000,10,0]
[null,null,"Old Slab",1000000,20,{"$f":"E19*0%","v":0},0.8,20.8,null,"Old Slab","Senior Citizen",10000001,10214510,"Marginal",281000]
[null,null,"Old Slab",5000000,30,{"$f":"E20*0%","v":0},1.2,31.2,null,"Old Slab","Senior Citizen",10214511,20000000,15,0]
[null,null,"Old Slab",10000000,30,{"$f":"E21*10%","v":3},1.32,34.32,null,"Old Slab","Senior Citizen",20000001,20929600,"Marginal",871500]
[null,null,"Old Slab",20000000,30,{"$f":"E22*15%","v":4.5},1.3800000000000001,35.880000000000003,null,"Old Slab","Senior Citizen",20929601,50000000,25,0]
[null,null,"Old Slab",50000000,30,{"$f":"E23*25%","v":7.5},1.5,39,null,"Old Slab","Senior Citizen",50000001,53017320,"Marginal",3702500]
[null,null,"Old Slab","> 50000000",30,{"$f":"E24*37%","v":11.1},1.6440000000000001,42.744,null,"Old Slab","Senior Citizen",53017321,">",37,0]
[]
[]
[]
[]
[null,">>>> New Tax Slabs"]
[null,null,"SLAB","STATUS","Income From","Income Up to","Tax Rate","Tax Amount",null,"SLAB","STATUS","Income From","Income Up to","Surcharge","Tax Amount"]
[null,null,"New Slab","General",0,300000,0,0,null,"New Slab","All",0,5000000,0,0]
[null,null,"New Slab","General",{"$f":"F31+1","v":300001},{"$f":"F31+300000","v":600000},5,{"$f":"ROUND((F32-E32)*G32%,0)","v":15000},null,"New Slab","All",{"$f":"+M31+1","v":5000001},5179105,"Marginal",0]
[null,null,"New Slab","General",600001,{"$f":"F32+300000","v":900000},10,{"$f":"ROUND((F33-E33)*G33%,0)","v":30000},null,"New Slab","All",5179106,10000000,10,0]
[null,null,"New Slab","General",900001,{"$f":"F33+300000","v":1200000},15,{"$f":"ROUND((F34-E34)*G34%,0)","v":45000},null,"New Slab","All",10000001,10206107,"Marginal",270000]
[null,null,"New Slab","General",1200001,{"$f":"F34+300000","v":1500000},20,{"$f":"ROUND((F35-E35)*G35%,0)","v":60000},null,"New Slab","All",10206108,20000000,15,0]
[null,null,"New Slab","General",1500001,">",30,{"$f":"SUM(H32:H35)","v":150000},null,"New Slab","All",20000001,20912000,"Marginal",855000]
[null,null,null,null,null,null,null,null,null,"New Slab","All",20912001,">",25,0]
[]
[]
[]
[null,null,"Additional Tax Slab"]
[null,null,"SLAB","Income Up to","Tax","Surcharge","Cess","Add Tax"]
[null,null,"New Slab",300000,0,{"$f":"E43*0%","v":0},{"$f":"(E43+F43)*4%","v":0},{"$f":"G43+F43+E43","v":0}]
[null,null,"New Slab",{"$f":"D43+300000","v":600000},5,0,0.2,5.2]
[null,null,"New Slab",{"$f":"D44+300000","v":900000},10,0,0.4,10.4]
[null,null,"New Slab",{"$f":"D45+300000","v":1200000},15,0,0.6,15.6]
[null,null,"New Slab",{"$f":"D46+300000","v":1500000},20,0,0.8,20.8]
[null,null,"New Slab",5000000,30,0,1.2,31.2]
[null,null,"New Slab",10000000,30,{"$f":"E49*10%","v":3},{"$f":"(E49+F49)*4%","v":1.32},34.32]
[null,null,"New Slab",20000000,30,{"$f":"E50*15%","v":4.5},{"$f":"(E50+F50)*4%","v":1.3800000000000001},{"$f":"G50+F50+E50","v":35.880000000000003}]
[null,null,"New Slab","> 20000000",30,{"$f":"E51*25%","v":7.5},{"$f":"(E51+F51)*4%","v":1.5},{"$f":"G51+F51+E51","v":39}]