PLEASE-PLEASE calculating tax

[zohar]

Respected Sir,
I am trying to calculate how much a person has to pay taxes on his/her
income on basis of his/her income and tax deductible due to paying of
insurance(life,medical,and non-life), and other government schemes. on
basis of his bracket of income(>150000 yearly for male(>18) in india
has to pay 10 % income tax, and greater that that upto 250000 yearly
has to pay 20% while greater than that is 30% while that for females
is 180000,300000 and 400000 while it is more liberal for senior
citizens(>65)
Also that person is investing his savings in Stock Markets and also
short term capital gain tax has to be considered.
So the tax calculation has to be done for all individuals earning on
the basis of his/her tax-deducable incomes and also that has to be
further calculated so that investments in equity can be distributed
among them so that least tax has to be paid.


PLEASE PLEASE Please mail me a test mail with a subject add-rev-6jun
so that I can sent you the updated xls sheet that I have prepared for
that.

PLEASE PLEASE Please answer me also on this email as I might not get
the correct link to access your answer on group.
PLEASE PLEASE help me as
(e-mail address removed)

 

[MartinW]

Hi Zohar,

Take a look at John McGimpsey's site here
http://www.mcgimpsey.com/excel/variablerate.html

HTH
Martin