{"text_format":"2","workbook":"xls","n_sheets":1,"sheets":["BLANK CALCU OLD"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"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","formulas":"cached_only"}

{"sheet":"BLANK CALCU OLD","index":0,"n_rows":78,"n_cols":12,"rows_kept":78,"cut":false,"hidden":false,"merged":[[0,1,0,9],[2,1,2,9],[3,2,3,6],[3,8,3,9],[4,1,4,9],[5,1,5,3],[5,4,5,6],[5,8,5,9],[6,1,6,9],[7,2,7,6],[8,1,8,9],[13,8,14,8],[25,1,25,7],[21,9,26,9],[14,1,14,7],[14,9,16,9],[15,1,15,7],[16,1,16,7],[17,1,17,7],[18,1,18,7],[21,1,21,7],[19,1,19,7],[20,1,20,7],[20,8,21,8],[17,8,18,8],[22,1,22,7],[23,1,23,7],[24,1,24,7],[27,1,27,7],[28,1,28,7],[29,1,29,7],[26,1,26,7],[29,9,42,9],[30,1,30,7],[31,1,31,7],[32,1,32,7],[33,1,33,7],[34,1,34,7],[27,8,29,8],[44,1,45,7],[35,1,35,7],[36,1,36,7],[37,1,37,7],[38,1,38,7],[39,1,39,7],[40,1,40,7],[47,1,47,7],[48,1,48,9],[49,1,49,9],[46,8,47,8],[41,1,41,7],[42,1,42,7],[43,1,43,7],[46,1,46,7],[44,9,45,9],[44,8,45,8],[50,1,50,7],[50,8,54,8],[51,1,51,7],[52,1,52,7],[53,1,53,7],[54,1,54,7],[61,8,61,9],[55,1,55,4],[55,5,55,7],[55,8,55,9],[56,1,56,7],[56,8,56,9],[57,1,57,7],[57,8,57,9],[63,8,63,9],[64,1,64,7],[64,8,64,9],[58,1,58,7],[58,8,58,9],[59,1,59,7],[59,8,59,9],[60,1,60,9],[61,1,61,2],[61,3,61,7],[74,1,74,5],[74,6,74,9],[65,1,65,7],[65,8,65,9],[66,1,66,9],[67,1,67,7],[67,8,68,8],[68,1,68,7],[12,1,12,7],[13,1,13,7],[69,1,69,9],[70,1,73,5],[70,6,70,9],[71,6,72,9],[73,6,73,9],[62,1,62,7],[62,8,62,9],[63,1,63,7],[77,6,77,7],[77,8,77,9],[1,1,1,9],[75,1,75,5],[75,6,75,9],[76,1,76,5],[76,6,76,9],[77,1,77,5],[10,1,10,7],[11,1,11,7]],"flags":["formulas_cached_only"]}
[null,"GOVERNMENT MEDICAL COLLEGE, SURAT."]
[null,"ESTIMETED COMPUTATION OF INCOME TAX FOR F.Y.: 2023-24 (A.Y.2024-25)"]
[]
[null,"NAME : ",{"$nulls":5},"DEPARTMENT : "]
[]
[null,"GPF OR C.P.F. A/C No. : ",{"$nulls":5},"I.TAX PAN NO. :"]
[]
[null,"DESIG. :",{"$nulls":5},"BILL NO./SR.NO. :"]
[]
[null,"  1. GROSS SALARY FROM THIS INSTITUTE:-              ",{"$nulls":4},"12 X",null,null,0]
[null,"  1A. GROSS SALARY FORM OTHER INSTITUTE + BANK INTREST :-      ",{"$nulls":6},0]
[null,"  2. TOTAL SALARY IN YEAR (1+1A)",{"$nulls":7},0]
[null,"  3. CPF (Government's Share) :-                   ",{"$nulls":6},0]
[null,"  4. TOTAL (2+3)",{"$nulls":7},0]
[null,"  5.  ALLOWANCE TO THE EXTEND EXEMPTED :-"]
[null,"       (5.A) Professional Tax (U/S.16(ia)",{"$nulls":6},0]
[null,"       (5.B) Standered Deduction U/S 16(i) (Rs.50,000/-)",{"$nulls":6},0]
[null,"  6. Total (5.A+5.B)",{"$nulls":7},0]
[null,"  7.  NET SALARY INCOME (4-6) :-",{"$nulls":7},0]
[null,"  8. CPF (Government's Share) U/S. 80 CCD (2) (Maximum 10% of Basic+DA)",{"$nulls":6},0]
[null,"  9. TOTAL (7-8)",{"$nulls":7},0]
[null,"10. DEDUCTION UNDER CHAPTER – VI-A :-"]
[null,"      (1)    Permanent Disability U/S.80U (Max Rs. 75000/-)",{"$nulls":6},0]
[null,"      (2)    Mediclaim Insurance Premium U/S.80 D (Max Rs. 25000/-)",{"$nulls":6},0]
[null,"      (3)   HBA Interest U/S.24B (i) (iv) (Maxi.2,00,000/-) (on or after 01/04/1999)",{"$nulls":6},0]
[null,"      (4)  Higher Education Loan Interest U/S.80E ",{"$nulls":6},0]
[null,"      (5)  Medical Treatment of Handicapped dependents U/S 80-DD B (Max.Rs.75000/-) ",{"$nulls":6},0]
[null,"11. TOTAL DEDUCTION UNDER CHAPER -VI-A (1 TO 5)",{"$nulls":7},0]
[null,"12. TOTAL INCOME (9-11) :-",{"$nulls":7},0]
[null,"13. DEDUCTION U/S.80-C (Maxi.Rs.150000) (From : 4/2022 TO 3/2023) :-"]
[null,"        (1) G.P.F. ",{"$nulls":6},0]
[null,"        (2) C.P.F. (U/S. 80 CCD (1)) ",{"$nulls":6},0]
[null,"        (3) P.P.F.",{"$nulls":6},0]
[null,"        (4) LIC Premium ",{"$nulls":6},0]
[null,"        (5) N.S.C. Deposit",{"$nulls":6},0]
[null,"        (6) N.S.C. Interest re-ivested",{"$nulls":6},0]
[null,"        (7) Housing Loan Principal Amt. ",{"$nulls":6},0]
[null,"        (8) Depost in 10 Year, 15 Year Account under P.O. Saving Band (CTD)",{"$nulls":6},0]
[null,"        (9) State Group Insurance",{"$nulls":6},0]
[null,"       (10) ULIP / Equity Link Saving Fund",{"$nulls":6},0]
[null,"       (11) Investment in Pension Fund",{"$nulls":6},0]
[null,"       (12) PLI Premium",{"$nulls":6},0]
[null,"       (13) Education Fees (Tution/Education Fee Only/Up to 2 Children)",{"$nulls":6},0]
[null,"14. TOTAL INVEST. U/S.80-C  (MAX RS.1,50,000) {1 to 13} :-",{"$nulls":7},0]
[null,"15. DEDUCTION U/S.80-CCD (1B) (Maxi.Rs.50000) (From:-4/2022 to 3/2023)\n      CPF (Emplyee's Share) OR Investment in NPS individual  :-",{"$nulls":6},0]
[]
[null,"16. TOTAL INVEST. U/S.80-C + CCD (1B) (MAX RS.2,00,000) {14+15} :-",{"$nulls":7},0]
[null,"17. NET TAXABLE INCOME (ROUNDED IN NEAREST OF RS.10) (12-16):-",{"$nulls":7},0]
[null,"GOVERNMENT MEDICAL COLLEGE, SURAT.                                                                     …2…"]
[null,"     …2…"]
[null,"18. TOTAL INCOME TAX ON NET TAXABLE INCOME :-",{"$nulls":7},0]
[null,"19. Less:-12,500/- U/S 87-A (If Net Taxable Income Less than Rs.5,00,001/-):-",{"$nulls":7},0]
[null,"20. NET INCOME TAX  (18-19):-",{"$nulls":7},0]
[null,"21. 4% EDUCATION CESS ON NET INCOME TAX :-",{"$nulls":7},0]
[null,"22. TOTAL INCOME TAX ( 20+21) :-",{"$nulls":7},0]
[null,"       ",null,null,null,"-: FOR MALE & FEMALE :-"]
[null,"(A) As per Col. No.11, If Net Taxable Income upto Rs.2,50,000/-",{"$nulls":6},"Nil"]
[null,"(B) Between Rs.2,50,001/- To Rs.5,00,000/-",{"$nulls":6},0.05]
[null,"(C) Between Rs.5,00,001/- To Rs.10,00,000/-",{"$nulls":6},"20 % + 12500/-"]
[null,"(D) Above Rs.10,00,001/-",{"$nulls":6},"30 % + 112500/-"]
[]
[null,"       ",null,"-: FOR SENIOR CITIZEN :-(Age Morethan 60)"]
[null,"(A) As per Col. No.11, If Net Taxable Income upto Rs.3,00,000/-",{"$nulls":6},"Nil"]
[null,"(B) Between Rs.3,00,001/- To Rs.5,00,000/-",{"$nulls":6},0.05]
[null,"(C) Between Rs.5,00,001/- To Rs.10,00,000/-",{"$nulls":6},"20 % + 10000/-"]
[null,"(D) Above Rs.10,00,001/-",{"$nulls":6},"30 % + 110000/-"]
[]
[null,"23. Income Tax deducte from salary of MARCH/2022 (COL. NO.22/12) :-",{"$nulls":7},0,null,0]
[null,"24. Total Income Tax  :-",{"$nulls":7},0]
[]
[{"$nulls":6},"All above information are true and correct"]
[]
[]
[{"$nulls":6},"(SIGNATURE OF EMPLOYEE)"]
[null,"ACCOUNTS OFFICER  "]
[null,"GOVERNMENT MEDICAL COLLEGE"]
[null,"SURAT"]
[null,"OFFICE TAN NO.:- SRTG01499B",{"$nulls":4},"Mobile No:-"]