Tax Liability - Xls Download

Can someone tell me the tax liability for the year 2008-09 for the following salary structure:
CTC: 750000
Basic : 375000 pa
HRA : 150000 pa
Conveyance : 9600 pa
LTA : 37500 pa
Medical Allowance : 15000 pa
Special Allowance : 153540 pa
Employer's Contribution to PF : 9360 pa
Total CTC : 750000 pa
I want to know how much savings (and what type of savings) can be done to be exempted from TDS.
I need it soon please....

Hi!
Ur tax would be approx of 7500/- pm. You can do savings of 1 lac under section 80c. Apart from that you can show your house rent receipt and medical bills and get an exemption on that also. If you are paying your's, ur parents medical insurance premium and any housing loan taken you can even get exemption on that also. If your company give you petrol allowance and vehicle maintainces then you can product those bills and can get exemption on that.
Chitra

Hi Samantraj,
Kindly note the below mentioned calculation of Income Tax as per my knowledge.
SALARY HEADS MONTHLY YEARLY
BASIC 31250 375000
HRA 12500 150000
CON 800 9600
LTA 3125 37500
MED. ALL 1250 15000
SPE. ALL 12795 153540
PF 780 9360
CTC 62500 750000
CALCULATION DETAILS
TOTAL EARNINGS 60940 731280
EXEMPTION - HRA 12500 150000
EXEMPTION - CON 800 9600
TAXABLE SALARY 47640 571680
SAVINGS 8333 100000
TAXABLE SALARY 39306 471680
INCOME TAX 4234 50816
Apart from above i am trying to attach a tax calculator, but i am unable to attach, please provide me your email id so that i can provide you the tax calculator.
Hope this will help you.
Regards
Prem Singh Rawat

Hi Prem:
ThanQ for the breakup but could u tell me please how did u get the 60940 - Total earnings per month, rest everything is okay

Hello Prem:
A small clarification needed. I could figure out from your calculation that u deducted PF contribution of 780 pm twice from the monthly sal. Why did u do so........
Explanations invited from all....

Hi Samantraj,
I believe PF is divided in two parts ( Employee's + Employer's Part).
You have mentioned Rs. 9360 PA as Employer part of PF. While calculating the Net Salary both the Employee's as well as Employer's part is deducted from the CTC.
Total Earnings = Basic Pay + HRA + Conv + LTA + Medical + Special Allowances - Employee's PF - Employer's PF.
I Hope both of your queries are resolved now, i am attaching the tax calculator for your reference.
Regards
Prem Singh Rawat
The Department of Human Resources

As per my knowledge employee pf is deducted Rs 780 per month and from employer side it is Rs 885 per month.
Hi Prem
How did u bring this calculation INCOME TAX 4234 50816 ?

hello,
I have a point to raise here..As i was going thru the post, I found out that the HRA was not 50% of the basic!
In a metro city, HRA should be always 50% of the basic, while it should be always 40% of the basic in case of a non metro city.
Thanks and regards,
Ayona

Well Buddy how much you save still you would end up paying tax a little more or little less which would depend upon the saving you would in the whole year…Try to reduce the liability by doing more investments

With the cap for investments pegged at 1 lac, we are left with no chance to minimize our tax liability no....