Docstoc

IT Calculator (Excel)

Document Sample
IT Calculator (Excel) Powered By Docstoc
					               Select Category--------->> Super-SCZ -for Sr. Citizen above 80
               years / SCZ-for Sr. Citizen/ M for Male-Other than Sr. Citizen /                         Super SCZ
               F for Female-Other than Sr. Citizen------->>
                                                         Select Financial Year-------->>                FY-2011-12
               Gross Salary                                                                                   952500.00
               Exemption U/S 10
               Balance                                                                                        952500.00

    Fill all   Home Loan Int. /Hs. Rent Benefit….if any
information in
               Gross Total Income                                                                             952500.00
 White color
  Cells only Savings under 80 CC i.e. LIC, GPF, PPF, Children Edu (Tuition Fee) etc.                          100000.00

               Saving in Infra Structure Bonds                                                                 20000.00
               Total Income                                                                                   832500.00

               Tax on Total Income                                                                             69750.00

               Surcharge (Education Cess-@ 3 %) on Total Income                                                 2092.00

               Total Tax i/c Cess                                                                              71842.00

    Upto                                                                                500000.00                     nil
Balance, If any 10% Tax on Range [from 500000.00 upto 500000.00] i.e. on Balance Amount 0.00
                                                                                                                     0.00

Balance, If any 20% Tax on Range [from 500001.00 upto 800000.00] i.e. on Balance Amount 300000.00
                                                                                                               60000.00

Balance, If any 30% Tax on Range [from 800001.00 above]. i.e. on Balance Amount 32,500.00
                                                                                                                9750.00

                                                                                                         Design by:
                                                                                                    vk.nagpal@ndpl.com

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:5/7/2012
language:English
pages:1