{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["tax-calculator","Macro-disabled"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"defined_names":1,"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-calculator","index":0,"n_rows":40,"n_cols":22,"rows_kept":40,"cut":false,"hidden":true,"merged":[[30,1,30,4],[15,2,15,3],[4,1,4,4],[2,1,2,4],[3,2,3,3]]}
[]
[]
[null,"New Simplified Personal Income Tax Regime u/s 115BAC AY 2024-25",null,null,null,null,"Senior Citizen (60 Yrs or more)"]
[null,null,"Select your Category",null,"Other",null,"Senior Citizen (80 Yrs or more)"]
[null,null,null,null,null,null,"Other"]
[null,"A","Enter your Gross Income without any deduction/exemption",null,700000]
[null,"B","Less: Select Allowances/Exemptions/Deductions/Set Off you are normally entitled to",null,"Fill estimated amount hereunder",null,null,null,"Txable Income old",{"$f":"E27","v":700000},null,null,null,null,null,null,"Old Scheme","Rebate","Net Tax","New Scheme","Rebate","Net Tax"]
[null,1,"Leave Travel Concession",null,null,null,null,null,"Taxable income new",{"$f":"E6-(E11+E17)","v":700000},null,null,null,"Senior Citizen (60 Yrs or more)",null,null,{"$f":"J11","v":50000},{"$f":"IF($J$7>500000,0,Q8)","v":0},{"$f":"Q8-R8","v":50000},{"$f":"J12","v":25000},{"$f":"IF($J$8>700000,0,T8)","v":25000},{"$f":"T8-U8","v":0}]
[null,2,"House Rent Allowance",null,null,null,null,null,null,null,null,null,null,"Senior Citizen (80 Yrs or more)",null,null,{"$f":"K11","v":40000},{"$f":"IF($J$7>500000,0,Q9)","v":0},{"$f":"Q9-R9","v":40000},{"$f":"K12","v":25000},{"$f":"IF($J$8>700000,0,T9)","v":25000},{"$f":"T9-U9","v":0}]
[null,3,"Any Exempt Allowance other than mentioned at 4",null,null,null,null,null,null,"Senior Citizen","Super Senior","Others",null,"Other",null,null,{"$f":"L11","v":52500},0,52500,{"$f":"L12","v":25000},{"$f":"IF($J$8>700000,0,T10)","v":25000},0]
[null,{"$f":"B10+1","v":4},"Allowances mentioned at footnote #",null,null,null,null,null,"Tax as per old scheme",{"$f":"SUMPRODUCT(--(J7>(J30:J32)), (J7-(J30:J32)), (L31:L33))","v":50000},{"$f":"SUMPRODUCT(--(J7>(J38:J39)), (J7-(J38:J39)), (L39:L40))","v":40000},{"$f":"SUMPRODUCT(--(J7>(J20:J22)), (J7-(J20:J22)), (L21:L23))","v":52500}]
[null,{"$f":"B11+1","v":5},"Standard Deduction on Salaries",null,null,null,null,null,"Tax as per new scheme",{"$f":"SUMPRODUCT(--(J8>(O20:O24)), (J8-(O20:O24)), (Q21:Q25))","v":25000},{"$f":"SUMPRODUCT(--(J8>(O20:O25)), (J8-(O20:O25)), (Q21:Q26))","v":25000},{"$f":"SUMPRODUCT(--(J8>(O20:O25)), (J8-(O20:O25)), (Q21:Q26))","v":25000},null,"Final Tax based on category Selection",null,null,"Old Scheme","New Scheme"]
[null,6,"Housing Loan Interest on self Occupied/Vacant House",null,null,null,null,null,null,null,null,null,null,{"$f":"E4","v":"Other"},null,null,{"$f":"VLOOKUP(E4,N8:S10,6,FALSE)","v":52500},{"$f":"VLOOKUP(E4,N8:V10,9,FALSE)","v":0}]
[null,7,"Family Pension Deduction"]
[null,8,"MP/MLA Allowance"]
[null,9,"Any deduction under chapter VIA ((like section 80C, 80CCC, 80CCD, 80D, 80DD, 80DDB, 80E, 80EE, 80EEA, 80EEB, 80G, 80GG, 80GGA, 80GGC, 80IA, 80-IAB, 80-IAC, 80-IB, 80-IBA, etc)"]
[null,10,"Deductions for Pension Scheme u/s 80CCD and 80JJAA for new employment"]
[null,11,"SEZ Exemption",null,null,null,null,null,"Income tax slab old",null,null,null,null,"Income tax slab new"]
[null,12,"Entertainment Allowance",null,null,null,null,null,"From","To","Income Tax Rate","Differential Rate",null,"From","To","Income Tax Rate","Differential Rate"]
[null,13,"Employment/Professional Tax",null,null,null,null,null,0,250000,0,null,null,0,300000,0]
[null,14,"Losses from House Property for rented property",null,null,null,null,null,250001,500000,0.05,{"$f":"K21-K20","v":0.05},null,300001,600000,0.05,{"$f":"P21-P20","v":0.05}]
[null,15,"Higher/AdditionalDepreciation",null,null,null,null,null,500001,1000000,0.2,{"$f":"K22-K21","v":0.15000000000000002},null,600001,900000,0.1,{"$f":"P22-P21","v":0.05}]
[null,16,"Deductions u/s 32AD, 33AB, 33AB",null,null,null,null,null,"above 1000000/-",null,0.3,{"$f":"K23-K22","v":9.9999999999999978E-2},null,900001,1200000,0.15,{"$f":"P23-P22","v":4.9999999999999989E-2}]
[null,17,"Expenditure on scientific research ",null,null,null,null,null,null,null,null,null,null,1200001,1500000,0.2,{"$f":"P24-P23","v":5.0000000000000017E-2}]
[null,18,"Deduction u/s 35AD or 35CCC",null,null,null,null,null,null,null,null,null,null,"1500001 and above",null,0.3,{"$f":"P25-P24","v":9.9999999999999978E-2}]
[null,19,"Any other exemption/Deduction",null,null,null,null,null,"Income Tax Slab for Senior Citizens AY 2016-17 and AY 2015-16"]
[null,"C","Total Income (A-B)",null,{"$f":"E6-SUM(E8:E26)","v":700000},null,null,null,"From","To","Income Tax Rate","Differential Rate"]
[]
[null,null,"Tax under Old Regime (after Section 87A rebate)",null,{"$f":"Q13","v":52500}]
[null,null,"Tax under New Optional Regime (after Section 87A rebate)",null,{"$f":"R13","v":0},null,null,null,0,300000,0]
[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",null,null,null,null,null,null,300001,500000,0.05,{"$f":"K31-K30","v":0.05}]
[null,null,null,null,null,null,null,null,500001,1000000,0.2,{"$f":"K32-K31","v":0.15000000000000002}]
[null,null,null,null,null,null,null,null,"above 1000000/-",null,0.3,{"$f":"K33-K32","v":9.9999999999999978E-2}]
[]
[]
[null,null,null,null,null,null,null,null,"Income Tax Slab for Senior Citizens AY 2016-17 and AY 2015-16"]
[null,null,null,null,null,null,null,null,"From","To","Income Tax Rate","Differential Rate"]
[null,null,null,null,null,null,null,null,0,500000,0]
[null,null,null,null,null,null,null,null,500001,1000000,0.2,{"$f":"K39-K38","v":0.2}]
[null,null,null,null,null,null,null,null,"above 1000000/-",null,0.3,{"$f":"K40-K39","v":9.9999999999999978E-2}]

{"sheet":"Macro-disabled","index":1,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Macros must be enabled to use this utility"]
[]
[null,null,null,null,null,null,null,"Download help file on how to enable macros"]
[null,null,null,null,null,null,null,"http://abcaus.in/macros.pdf"]