MICROSOFT INDIA (R&D) PRIVATE LIMITED
Income Tax Calculation for the period 01/04/2021 to 07/07/2021
Employee ID / No. 0006126491 Employee Name Mr. Srinath Reddy Alla Gender Male
Employee DOJ 08/03/2021 Employee PAN ASNPA9532C Tax Slab Category Men - Existing Tax Regime
Existing Regime(INR) New Regime(INR)
Add : Earnings 12,48,665.00 12,48,665.00
Payroll Gross Taxable Amount 12,20,674.00 12,20,674.00
Taxable Perquisites 27,991.00 27,991.00
Add : Amount Earned Outside Payroll 0.00 0.00
Add : Previous Employer Income 0.00 0.00
Add : Previous Employer 17(2)(vii) 0.00 0.00
Less : Benefit u/s 17(2) (vii) 0.00 0.00
Previous Employment Current Employment
Less : Section 10 Exemption
Sec 10(10AA)-Earned leave encashment 0.00 37,367.00 37,367.00 37,367.00
Gross Taxable Amount 12,11,298.00 12,11,298.00
Less : Standard Deduction - 50,000.00 0.00
Less : Section 16 Deductions - 800.00 0.00
Tax on Employment u/s 16(iii) 800.00
Total Income From Salary 11,60,498.00 12,11,298.00
Other Income/Loss
Add : Other Income 0.00 0.00 0.00 0.00
Add : Income from House Property 0.00 0.00 0.00 0.00
Gross Total Income 11,60,498.00 12,11,298.00
This is computer generated computation and does not require a signature . Employee Code: 0006126491
Page 1 of 4
Existing Regime(INR) New Regime(INR)
Less : Section 80 Deduction (Chapter VI A) Previous Employment Current Employment - 81,348.00 0.00
80C Provident Fund through Company 0.00 63,948.00 63,948.00 0.00
80D Parents-Sr. Citizens 0.00 17,400.00 17,400.00 0.00
Net Taxable Income 10,79,150.00 12,11,298.00
Tax Computation
Tax Slab 1 Upto Rs.2,50,000 - No Tax Upto Rs.2,50,000 - No Tax
Tax Slab 2 2,50,001 - 5,00,000 @ 5% 12,500.00 2,50,001 - 5,00,000 @ 5% 12,500.00
Tax Slab 3 5,00,001 - 10,00,000 @ 20% 1,00,000.00 5,00,001 - 7,50,000 @ 10% 25,000.00
Tax Slab 4 Above 10,00,001 @ 30% 23,745.00 7,50,001 - 10,00,000 @ 15% 37,500.00
Tax Slab 5 10,00,001 - 12,50,000 @ 20% 42,259.60
Tax Slab 6 12,50,001 - 15,00,000 @ 25%
Tax Slab 7 Above 15,00,001 @ 30%
Tax on Income 1,36,245.00 1,17,259.60
Surcharge 0.00
Cess @ 4% 5,449.80 4,690.38
Total Tax Including Cess 1,41,695.00 1,21,949.98
Total Tax including Cess as per Employee Regime Option 1,41,695.00
Total Tax deducted 1,83,237.00
Tax Deduction Break Up
Previous Employment Current Employment Outside Payroll
0.00 183,237.00 0.00
Balance Tax to be deducted - 41,542.00
Remaining Number of Month(s)
Average Tax to be deducted through remaining month(s)
This is computer generated computation and does not require a signature . Employee Code: 0006126491
Page 2 of 4
Salary Calculation (Earnings)
Wage Type April May June July August September October November December January February March Grand Total
Basic 165200.00 165200.00 165200.00 37303.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 532903.00
House Rent 82600.00 82600.00 82600.00 18652.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 266452.00
Allowance
Leave 0.00 0.00 0.00 0.00 37367.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 37367.00
Encashment
Special Allowance 82376.00 82376.00 82376.00 18601.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 265729.00
Special Bonus 0.00 0.00 0.00 0.00 109158.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 109158.00
WFH Program 0.00 7749.00 1316.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 9065.00
Gross Up
Gift Perquisite 0.00 0.00 0.00 8000.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 8000.00
WFH Program 0.00 17088.00 2903.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 19991.00
Perquisite
Grand Total 330176.00 355013.00 334395.00 82556.00 146525.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 1248665.00
Other Components
Wage Type April May June July August September October November December January February March Grand Total
Flex - 80D 0.00 0.00 0.00 0.00 17400.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 17400.00
Parents (Sr.)
Income Tax 58057.00 65806.00 59374.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 183237.00
Deduction
Notice Pay 0.00 0.00 0.00 0.00 448767.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 448767.00
Deduction
Profession Tax 200.00 200.00 200.00 200.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 800.00
Provident Fund 19824.00 19824.00 19824.00 4476.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 63948.00
Deduction
Salary Hold 0.00 0.00 0.00 69880.00 -302574.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 -232694.00
Income tax deducted (if any) is shown above upto the current month. Refer previous sheet for tax to be deducted through remaining month(s)
This is computer generated computation and does not require a signature . Employee Code: 0006126491
Page 3 of 4
HRA Exemption (Minimum of (HRA Received, Rent Paid -10% of Salary, 40 or 50% of Salary))
HRA Salary City Classification
Month Actual Rent Paid HRA Received Rent Paid in excess Exemption
40% for NM or (M-Metro,
of 10% of Salary Amount
50% for M NM-Non Metro)
April 2021 0.00 82600.00 0.00 0.00 0.00 NM
May 2021 0.00 82600.00 0.00 0.00 0.00 NM
June 2021 0.00 82600.00 0.00 0.00 0.00 NM
July 2021 0.00 18652.00 0.00 0.00 0.00 NM
August 2021 0.00 0.00 0.00 0.00 0.00
September 2021 0.00 0.00 0.00 0.00 0.00
October 2021 0.00 0.00 0.00 0.00 0.00
November 2021 0.00 0.00 0.00 0.00 0.00
December 2021 0.00 0.00 0.00 0.00 0.00
January 2022 0.00 0.00 0.00 0.00 0.00
February 2022 0.00 0.00 0.00 0.00 0.00
March 2022 0.00 0.00 0.00 0.00 0.00
Grand Total 0.00 266452.00 0.00 0.00 0.00
This is computer generated computation and does not require a signature . Employee Code: 0006126491
Page 4 of 4