Please help me built an Income Tax Calculator in MS Excel format. Details of the calculator should be as follows:
DATA TO INPUT MANUALLY:
(a) Total Salary (in a year) = [input manually]
(b) Taxable Salary per Month = [input manually]
(c) Add: Bonus/ Incentives = [input manually]
(d) = (a) + (c) = Total Taxable Income
OUTPUT RESULT:
(a) Total Income Tax for the year
(b) Income Tax per month
TAX SLAB:
MALE:
On first Tk. 3,00,000 = NIL
On next Tk. 1,00,000 = 5%
On next Tk. 3,00,000 = 10%
On next Tk. 4,00,000 = 15%
On next Tk. 5,00,000 = 20%
On the balance of total income = 25%
FEMALE & SENIOR CITIZEN:
On first Tk. 3,50,000 = NIL
On next Tk. 1,00,000 = 5%
On next Tk. 3,00,000 = 10%
On next Tk. 4,00,000 = 15%
On next Tk. 5,00,000 = 20%
On the balance of total income = 25%
From Bangladesh
DATA TO INPUT MANUALLY:
(a) Total Salary (in a year) = [input manually]
(b) Taxable Salary per Month = [input manually]
(c) Add: Bonus/ Incentives = [input manually]
(d) = (a) + (c) = Total Taxable Income
OUTPUT RESULT:
(a) Total Income Tax for the year
(b) Income Tax per month
TAX SLAB:
MALE:
On first Tk. 3,00,000 = NIL
On next Tk. 1,00,000 = 5%
On next Tk. 3,00,000 = 10%
On next Tk. 4,00,000 = 15%
On next Tk. 5,00,000 = 20%
On the balance of total income = 25%
FEMALE & SENIOR CITIZEN:
On first Tk. 3,50,000 = NIL
On next Tk. 1,00,000 = 5%
On next Tk. 3,00,000 = 10%
On next Tk. 4,00,000 = 15%
On next Tk. 5,00,000 = 20%
On the balance of total income = 25%
From Bangladesh
Find answers from people who have previously dealt with business and work issues similar to yours - Please Register and Log In to CiteHR and post your query.