{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Salary CTC","Allowances"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Salary CTC","index":0,"n_rows":25,"n_cols":13,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,2,1,8],[24,1,24,6]]}
["CTC (Cost to Company annum)",750000,"Please note that the excel file is made for educational purpose. Users are not adviced to take any decision based on this file. Consult a professional as tax impact and treatment differes from situation to situation. ",{"$nulls":9},"Select Your City"]
[{"$nulls":12},"Metro"]
[{"$nulls":12},"Non-Metro"]
["Particulars","Amount (Monthly)","Taxable(Monthly)","Amount (Annual)","Taxable(Annual)"]
["Basic Salary",{"$f":"(B1/12)*50%","v":31250},{"$f":"B5","v":31250},{"$f":"B5*12","v":375000},{"$f":"C5*12","v":375000}]
["Dearness Allowance",{"$f":"B5*41%","v":12812.5},{"$f":"B6","v":12812.5},{"$f":"B6*12","v":153750},{"$f":"C6*12","v":153750},null,null,null,"House Rent Allowance (HRA)"]
["Alowances:",null,null,0,0]
["House Rent Allowances",9641.7000000000007,null,115700.40000000001,0,null,null,null,"Discription","Amount"]
["Less: Exempted",{"$f":"-'Salary CTC'!J13","v":-8093.75},{"$f":"SUM(B8:B9)","v":1547.9500000000007},null,18575.400000000009,null,null,null,"HRA",{"$f":"'Salary CTC'!B8","v":9641.7000000000007}]
["Conveyance Allowance",800,0,{"$f":"B10*12","v":9600},0,null,null,null,"Actual Rent",12500]
["Children Education Allowance",200,0,2400,0,null,null,null,"Rent in excess of 10% of Salary",{"$f":"J10-(SUM('Salary CTC'!$C$5:$C$6)*10%)","v":8093.75}]
["Hostel Expenditure",600,0,7200,0,null,null,null,"Metro",{"$f":"IF($I$12=\"Metro\",SUM('Salary CTC'!$C$5:$C$6)*50%,SUM('Salary CTC'!$C$5:$C$6)*40%)","v":22031.25}]
["Medical reimbursement",1250,0,15000,0,null,null,null,"Exempted HRA",{"$f":"MIN(J9,J11,J12)","v":8093.75}]
[]
["Total",{"$f":"SUM(B5:B13)","v":48460.45},{"$f":"SUM(C5:C14)","v":45610.45},{"$f":"SUM(D5:D13)","v":678650.4},547325.4]
["Less: Profession Tax",-200,-200,{"$f":"B16*12","v":-2400},{"$f":"C16*12","v":-2400}]
["Net Salary",{"$f":"SUM(B15:B16)","v":48260.45},45410.45,{"$f":"SUM(D15:D16)","v":676250.4},{"$f":"SUM(E15:E16)","v":544925.4}]
[]
["Tax",{"$f":"B17*20%","v":9652.09},{"$f":"C17*20%","v":9082.09},135250.08000000002,108985.08000000002]
[]
[]
[null,"1. Please note that all allowances are explained in the article from where this file is originaly downloaded."]
[null,"2. Please seek the professional help before coming to any decision."]
[null,"3. The tax rate is not as specified under income tax act and is taken only to compare the tax impact."]
[null,"4. The above work is under no circumstances guaranteed to provide optimum structure as every individual operates in a different enviroment attracting different rules under which salary can be structured."]

{"sheet":"Allowances","index":1,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Allowances Calculation"]