Individual tax Calculation of ASTY Inc.

[Salary Structure] ASTY INC. (Bangladesh Liaison Office) Statement of Salary & Allowances Before Increment Sl.No. | Name | Joining date | Basic Salary | House Rent | Conveyance | Medical Allowance | Special Allowance | Gross Salary | Days of Month | Bonus | Total Payable | Deduction | Net Payable | Remarks Tax | Increment/Adjustment 01 | MD. Jahangir Alam | 80,400 | 40,200 | 5,360 | 8,040 | 134,000 | 31 | 134,000 | - | 134,000 Total | 80,400 | 40,200 | 5,360 | 8,040 | - | 134,000 | 31 | - | 134,000 | - | - | 134,000 July'20 to Feb'21 Name | Basic Salary | House Rent | Conveyance | Medical Allowance Bonus | Total MD. Jahangir Alam | 643,200 | 321,600 | 42,880 | 64,320 | 67,000 | 1,139,000 After Increment (Mar'21 to Jun'21) Sl.No. | Name | Joining date | Basic Salary | House Rent | Conveyance | Medical Allowance | Special Allowance | Gross Salary | Days of Month | Bonus | Total Payable | Deduction | Net Payable | Remarks Tax | Increment/Adjustment 01 | MD. Jahangir Alam | 83,400 | 41,700 | 5,560 | 8,340 | 139,000 | 31 | 139,000 | - | 139,000 Total | 83,400 | 41,700 | 5,560 | 8,340 | - | 139,000 | - | 139,000 | - | - | 139,000 Mar'21 to Jun'21 Name | Joining date | Basic Salary | House Rent | Conveyance | Medical Allowance Bonus | Total MD. Jahangir Alam | 333,600 | 166,800 | 22,240 | 33,360 | 69,500 | 625,500 Yearly Name | Joining date | Basic Salary | House Rent | Conveyance | Medical Allowance Bonus | Total MD. Jahangir Alam | 976,800 | 488,400 | 65,120 | 97,680 | 136,500 | 1,764,500 [Tax Calculation IY20-21] ASTY INC. Computation of Income and Tax Liability Income year 2020-2021 Assessmnet year 2021 - 2022 Name of Employees | MD. Jahangir Alam TIN Number Income from Salary: Basic salary: For the month from July'20 - Jun '21 | 976,800 House rent allowance | 488,400 Less: Exempt (50% of basic) or (Tk. 25,000 per month) whichever is lower | 300,000 188,400 Conveyance allowance | 65,120 Less: Exempt up to Tk. 30,000 (Tk. 2,500 Per Month) | 30,000 35,120 Medical allowance | 97,680 Less: Exempt (10% of basic) or Tk. 120,000 whichever is lower | 97,680 - Festival Bonus | 136,500 Total Taxable Income of Salary | 1,336,820 Taxable? | TRUE Tax Calculation: On 1st | Tk. | 300,000 | @ | Nil | - On next | Tk. | 100,000 | @ | 5% | 5,000 On next | Tk. | 300,000 | @ | 10% | 30,000 On next | Tk. | 400,000 | @ | 15% | 60,000 On next | Tk. | 500,000 | @ | 20% | 47,364 On next | Tk. | Balance Amount | @ | 25% Gross tax liability | 142,364 Rebate on Investment allowance: (25% of total income Tk. | 334,205 or actual investment Tk. | 100% | 334,205 or Tk. 15,000,000 whichever is lower) X (15% unless not exceeding 1.5 Million, otherwise 10% ) | 50,131 Net Tax Liability | 92,233 Unpaid Tax /Due Tax | 92,233 Carry Forwared from previous income year Tax Already Paid (July, 2020 to Jan, 2021) | 51,786 Balance/ (Excess Paid) | 40,447 Summary | MD. Jahangir Alam Without Investment Tax will be | 142,364 | ①年間の個人所得税額 After 100% allowable Investment Tax will be | 92,233 Already Paid (July, 2020 to Jan, 2021) | 51,786 | ②既にお支払いいただいている個人所得税額 Outstanding for ( Feb'21 to June'21)- Rest 5 Months Without Investment Tax will be | 90,578 | お支払いいただく必要のある個人所得税額（①－②） After 100% allowable Investment Tax will be | 40,447 [Tax Calculation Old] ASTY INC. Computation of Income and Tax Liability Income year 2019-2020 Assessmnet year 2020 - 2021 | 1 | 2 | 3 Name of Employees | MD. Jahangir Alam TIN Number | 241957170498 Income from Salary: Basic salary: For the month from July'19 - Jun '20 | 976,800 House rent allowance | 488,400 Less: Exempt (50% of basic) or (Tk. 25,000 per month) whichever is lower | 300,000 188,400 Conveyance allowance | 65,120 Less: Exempt up to Tk. 30,000 (Tk. 2,500 Per Month) | 30,000 35,120 Medical allowance | 97,680 Less: Exempt (10% of basic) or Tk. 120,000 whichever is lower | 97,680 - Special Allowance | 9,596 | 87,045 | 5,000 Festival Bonus | 136,500 Total Taxable Income of Salary | 1,336,820 Taxable? | TRUE Tax Calculation: On 1st | Tk. | 250,000 | @ | Nil | - | - | - On next | Tk. | 400,000 | @ | 10% | 40,000 On next | Tk. | 500,000 | @ | 15% | 75,000 On next | Tk. | 600,000 | @ | 20% | 37,364 On next | Tk. | 3,000,000 | @ | 25% On next | Tk. | Balance Amount | @ | 30% Gross tax liability | 152,364 Rabbet on Investment allowance: (25% of total income Tk. | 334,205 or actual investment Tk. | 100% | 334,205 | - or Tk. 15,000,000 whichever is lower) X (15% unless not exceeding 1.5 Million, otherwise 10% ) | 50,131 | - Net Tax Liability | 102,233 | 5,000 Unpaid Tax /Due Tax | 102,233 | 5,000 Tax Already Paid (July,2019 to Feb,2020) | 3,859 | 40,405 | - Monthly deductible by Company (for Nine Month From Oct 19 to Jun 20) | 12,366 | 1,250.00 [Sheet1] Heemel | Jahangir | Taguma | Sohel Jul | 417 | 28704 Aug | 417 | 24800 Sep | 605 | 8081 | 24800 Oct | 605 | 8081 | 25272 Nov | 605 | 8081 | 25272 Dec | 605 | 8081 | 25272 Jan | 605 | 8081 | 25272 Feb | 1148 | 9328 | 25272 | 1000 Mar | 1148 | 9328 | 25272 | 1000 Apr | 1148 | 9328 | 25272 | 1000 May | 1148 | 9328 | 25272 | 1000 Jun | 1148 | 9328 | 25272 | 1000 Total | 9599 | 87045 | 305752 | 5000