22_12_2016_Automatic Income Tax Calculator for Financial Year 2016-17.xlsx
Calculates automatic income tax for the financial year 2016-17 based on various income components. The sheet includes detailed entries for each month, listing pay band, gross pay, allowances like DA, HRA, and TA, along with deductions for GPF, CGEIS, and income tax. Monthly totals are provided, culminating in an annual summary that shows total income, deductions, and net pay. This tool is useful for individuals looking to understand their tax liabilities and net earnings over the specified financial year.
Content article
The spreadsheet details an automatic income tax calculator specifically for the financial year 2016-17, focusing on the income and deductions of Mr. Rakesh Kumar, a lecturer in Physics.
Mr. Kumar's residential address is A-567, Ram Nagar, Delhi, and he can be reached at the mobile number 7323453433. His PAN number is ADDED2323S. The calculation sheet provides a comprehensive breakdown of his monthly income from pay and allowances over the course of the financial year. His pay band starts at ₹19,450 with a grade pay of ₹4,600, and he receives various allowances including Dearness Allowance (DA), House Rent Allowance (HRA), and Transport Allowance (TA).
In March 2016, Mr. Kumar's total income was ₹63,389, which comprised his pay and allowances. This total fluctuated throughout the year, peaking in the months of October, November, and December 2016, where his total income reached ₹77,034 each month. By the end of the financial year, his total income from pay and allowances amounted to ₹514,160, with a grand total of ₹856,376 when including other sources of income and deductions.
The deductions from his income included contributions to the General Provident Fund (GPF) and the Central Government Employees Insurance Scheme (CGEIS), along with income tax and cess, which totaled ₹194,172. After accounting for these deductions, Mr. Kumar's net pay for the year was ₹662,204.
In addition to his salary, Mr. Kumar received several other payments, including a bonus of ₹10,362, a tuition fee of ₹18,000, and arrears amounting to ₹330,820, which contributed to a gross total of ₹976,838. The calculations also included various allowances and exemptions, with a total salary calculated at ₹957,638 after deductions.
The spreadsheet further outlines the income tax rates applicable for the financial year 2016-17. For senior citizens, the tax is structured such that income up to ₹2,50,000 is tax-free, while income between ₹2,50,001 and ₹3,00,000 incurs no tax. For income exceeding ₹3,00,000, the tax rate is 10% on the amount exceeding ₹2,50,000. The tax for income between ₹5,00,001 and ₹10,00,000 is ₹20,000 plus 20% of the income exceeding ₹5,00,000. For income above ₹10,00,000, the tax is ₹1,20,000 plus 30% of the income exceeding ₹10,00,000. Additionally, an educational cess of 3% is levied on the income tax in all cases.
As of December 14, 2016, the official signature on the document confirms the calculations made for Mr. Rakesh Kumar, ensuring accuracy in the assessment of his income and tax obligations for the financial year.