{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Estimated Tax","Calculaton"],"not_rendered":{"images":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Estimated Tax","index":0,"n_rows":21,"n_cols":9,"rows_kept":21,"merged":[[0,0,0,7],[2,2,2,5],[3,2,3,5],[8,1,8,3],[8,5,8,6],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[12,5,12,6],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2]]}
["Estimated Tax Calculator In One Minute",{"$nulls":7},"Old"]
[]
[null,null,"March Basic",{"$nulls":5},{"$f":"IFERROR(IF(D19>500000,250000,0)*5%+IF(D19>1000000,500000,IF(D19>500000,D19-500000,0))*20%+IF(D19>1000000,(D19-1000000),0)*30%,\"\")","v":0}]
[null,null,45100]
[]
[null,"DA Rate","HRA Rate","Total rate","DA Areear","Surrender","Bonus",null,{"$f":"IFERROR(ROUND(I3*0.04,-1),\"\")","v":0}]
[null,{"v":0.17,"d":"17%"},{"v":0.08,"d":"8%"},{"$f":"SUM(B7:C7)","v":{"v":0.25,"d":"25%"}},0,0,0]
[]
[null,"Auto Calculation",{"$nulls":3},"Tax as per new Regime"]
[null,"March Basic",null,{"$f":"C4","v":45100},null,"Total",{"$f":"D20","v":32812}]
[null,"March Gross Salary",null,{"$f":"ROUND(D10*D7+D10,0)","v":56375},null,"Monthly",{"$f":"ROUND(G10/12,0)","v":2734}]
[null,"July Basic",null,{"$f":"MROUND(D10*1.03,100)","v":46500}]
[null,"July Gross Salary",null,{"$f":"ROUND(D12*D7+D12,0)","v":58125},null,"Tax as per old Regime"]
[null,"Home Loan Interest",{"$nulls":3},"Total",{"$f":"D21","v":0}]
[null,"Annual Income",null,{"$f":"IFERROR(ROUND(D11*4+D13*8+E7+F7+G7-D14,0),\"\")","v":690500},null,"Monthly",{"$f":"ROUND(G14/12,0)","v":0}]
[null,"Satandard Deduction",null,50000]
[null,"Deduction Under 80C",null,150000]
[null,"Deduction Above 150000"]
[null,"Net Taxable Income",null,{"$f":"IFERROR(ROUND(D15-D16-D17-D18,-1),\"\")","v":490500}]
[null,"Tax as per new Regime",null,{"$f":"IFERROR(ROUND(Calculaton!E30,-1)*1.04,\"\")","v":32812}]
[null,"Tax as per old Regime",null,{"$f":"IFERROR(SUM(I3:I6),\"\")","v":0}]

{"sheet":"Calculaton","index":1,"n_rows":40,"n_cols":22,"rows_kept":40,"hidden":true,"merged":[[2,1,2,4],[3,2,3,3],[4,1,4,4],[15,2,15,3],[30,1,30,4]]}
[{"$nulls":8},{"$f":"Calculaton!L12","v":31550}]
[]
[{"$nulls":6},"Senior Citizen (60 Yrs or more)"]
[{"$nulls":4},"Senior Citizen (60 Yrs or more)",null,"Senior Citizen (80 Yrs or more)"]
[{"$nulls":6},"Other"]
[null,"A","Enter your Gross Income without any deduction/exemption",null,{"$f":"'Estimated Tax'!D15","v":{"v":690500,"d":"690,500"}}]
[null,"B","Less: Select Allowances/Exemptions/Deductions/Set Off you are normally entitled to",null,"Fill estimated amount hereunder",{"$nulls":3},"Txable Income old",{"$f":"E27","v":690500},{"$nulls":6},"Old Scheme","Rebate","Net Tax","New Scheme","Rebate","Net Tax"]
[null,1,{"$nulls":6},"Taxable income new",{"$f":"E6-(E11+E17)","v":{"v":690500,"d":"690,500"}},{"$nulls":3},"Senior Citizen (60 Yrs or more)",null,null,{"$f":"J11","v":48100},{"$f":"IF($J$7>500000,0,Q8)","v":0},{"$f":"Q8-R8","v":48100},{"$f":"J12","v":31550},{"$f":"IF($J$8>500000,0,T8)","v":0},{"$f":"T8-U8","v":31550}]
[null,2,{"$nulls":11},"Senior Citizen (80 Yrs or more)",null,null,{"$f":"K11","v":38100},0,38100,{"$f":"K12","v":31550},0,31550]
[null,3,{"$nulls":7},"Senior Citizen","Super Senior","Others",null,"Other",null,null,{"$f":"L11","v":50600},0,50600,{"$f":"L12","v":31550},0,31550]
[null,{"$f":"B10+1","v":4},{"$nulls":6},"Tax as per old scheme",{"$f":"SUMPRODUCT(--(J7>(J30:J32)), (J7-(J30:J32)), (L31:L33))","v":48100},{"$f":"SUMPRODUCT(--(J7>(J38:J39)), (J7-(J38:J39)), (L39:L40))","v":38100},{"$f":"SUMPRODUCT(--(J7>(J20:J22)), (J7-(J20:J22)), (L21:L23))","v":50600}]
[null,5,{"$nulls":6},"Tax as per new scheme",{"$f":"SUMPRODUCT(--(J8>(O20:O25)), (J8-(O20:O25)), (Q21:Q26))","v":31550},{"$f":"SUMPRODUCT(--(J8>(O20:O25)), (J8-(O20:O25)), (Q21:Q26))","v":31550},{"$f":"SUMPRODUCT(--(J8>(O20:O25)), (J8-(O20:O25)), (Q21:Q26))","v":31550},null,"Final Tax based on category Selection",null,null,"Old Scheme","New Scheme"]
[null,6,{"$nulls":11},{"$f":"E4","v":"Senior Citizen (60 Yrs or more)"},null,null,{"$f":"VLOOKUP(E4,N8:S10,6,0)","v":48100},{"$f":"VLOOKUP(E4,N8:V10,9,0)","v":31550}]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11,{"$nulls":6},"Income tax slab old",{"$nulls":4},"Income tax slab new"]
[null,12,{"$nulls":6},"From","To","Income Tax Rate","Differential Rate",null,"From","To","Income Tax Rate","Differential Rate"]
[null,13,{"$nulls":6},0,250000,{"v":0,"d":"0.00"},null,null,0,250000,{"v":0,"d":"0.00"}]
[null,14,{"$nulls":6},250001,500000,0.05,{"$f":"K21-K20","v":0.05},null,250001,500000,0.05,{"$f":"P21-P20","v":0.05}]
[null,15,{"$nulls":6},500001,1000000,{"v":0.2,"d":"0.20"},{"v":0.15000000000000002,"d":"0.15"},null,500001,750000,{"v":0.1,"d":"0.10"},0.05]
[null,16,{"$nulls":6},"above 1000000/-",null,{"v":0.30000000000000004,"d":"0.30"},{"v":0.10000000000000003,"d":"0.10"},null,750001,1000000,0.15,{"v":0.04999999999999999,"d":"0.05"}]
[null,17,{"$nulls":11},1000001,1250000,{"v":0.2,"d":"0.20"},{"v":0.05000000000000002,"d":"0.05"}]
[null,18,{"$nulls":11},1250001,1500000,0.25,{"v":0.04999999999999999,"d":"0.05"}]
[null,19,{"$nulls":6},"Income Tax Slab for Senior Citizens AY 2016-17 and AY 2015-16",{"$nulls":4},"1500001 and above",null,{"v":0.30000000000000004,"d":"0.30"},{"v":0.050000000000000044,"d":"0.05"}]
[null,"C","Total Income (A-B)",null,{"$f":"E6-SUM(E8:E26)","v":{"v":690500,"d":"690,500"}},{"$nulls":3},"From","To","Income Tax Rate","Differential Rate"]
[]
[null,null,"Tax under Old Regime (after Section 87A rebate)",null,{"$f":"Q13","v":{"v":48100,"d":"48,100"}}]
[null,null,"Tax under New Optinal Regime (after Section 87A rebate)",null,{"$f":"R13","v":{"v":31550,"d":"31,550"}},{"$nulls":3},0,300000,{"v":0,"d":"0.00"}]
[null,"# only following allowances are exempt to the Individual or HUF exercising Option of New Simplified Personal Income Tax Regime:\n(a) Transport Allowance granted to a divyang employee to meet expenditure for the purpose of commuting between place of residence and place of duty\n(b) Conveyance Allowance granted to meet the expenditure on conveyance in performance of duties of an office;\n(c) Any Allowance granted to meet the cost of travel on tour or on transfer;\n(d) Daily Allowance to meet the ordinary daily charges incurred by employee for absence from his normal place of duty",{"$nulls":6},300001,500000,0.05,{"$f":"K31-K30","v":0.05}]
[{"$nulls":8},500001,1000000,{"v":0.2,"d":"0.20"},{"v":0.15000000000000002,"d":"0.15"}]
[{"$nulls":8},"above 1000000/-",null,{"v":0.30000000000000004,"d":"0.30"},{"v":0.10000000000000003,"d":"0.10"}]
[]
[]
[{"$nulls":8},"Income Tax Slab for Senior Citizens AY 2016-17 and AY 2015-16"]
[{"$nulls":8},"From","To","Income Tax Rate","Differential Rate"]
[{"$nulls":8},0,500000,{"v":0,"d":"0.00"}]
[{"$nulls":8},500001,1000000,{"v":0.2,"d":"0.20"},{"$f":"K39-K38","v":{"v":0.2,"d":"0.20"}}]
[{"$nulls":8},"above 1000000/-",null,{"v":0.30000000000000004,"d":"0.30"},{"v":0.10000000000000003,"d":"0.10"}]