Tax Calculator 2011

Document Sample
Tax Calculator 2011 Powered By Docstoc
					                                                              Income Tax Calculator
                                                                   Version 13.0
                                                          © 1997-2011, Nithyanand Yeswanth
                                          Available for free download at: http://taxcalc.ynithya.com/
                                                           email: taxcalc@ynithya.com

     PLEASE ENTER YOUR NAME HERE

                                                                   DISCLAIMER

  This tax calculator can be used to calculate the approximate tax payable by salaried individuals. This should NOT be used to
compute the actual taxes to be paid to the Government. The author is not resposible for any inaccuracies in the tax computed by
               this calculator. If you find any inconsistency, please let me know and I will try to fix it at the earliest


                                PLEASE READ THESE INSTRUCTIONS CAREFULLY

 1   This sheet can be used to compute the tax for salaried individuals only
 2   Enter the numbers only in the yellow-colored cells. You will not be able to enter data in other cells
 3   Do not leave any yellow cell (that expects numbers) blank. This may lead to incorrect calculation. Instead, enter 0
 4   The darker yellow colored cells (with green text) constitute the setup parameters, which you may have to set only once. Ensure that all setup parameters in
     cells C4 to C20 and AA51 to AA73 are setup prior to using the calculator
 5   Depending on your company policy, change cells C4 to C20 to select elements of your salary that count towards calculation of PF
 6   If you are in Delhi, Mumbai, Kolkata or Chennai, change the location to Metro in Cell AA51. If you have moved from a metro to non-metro or vice-versa
     during the year, change the cells D47 to O47
 7   Enter the PF deduction percentage in cell AA54 depending on your company policy. In addition, if your company limits the PF to a certain amount, enter that
     amount in cell AA55. If there is no PF deduction, enter 0% in cell AA54. If the PF percentage changes during the year (due to change in employer or
     otherwise), change cells D48 to O48
 8   If you have opted for VPF (Voluntary Provident Fund), change cell AA58 depending on whether the deduction is done as a percentage of salary or as a fixed
     amount. If percentage, enter percentage in cell AA56. This will apply same percentage throughout the year. If percentage changes month to month, enter
     the percentage for each month in cells D43 to O43 (If you leave any of these cells at 0, the default percentage from cell AA56 will be taken for that month).
     If the deduction is a fixed amount, enter the amount for each month in cells D43 to O43
 9   If the interest rate on PF is other than 8.5%, change the value in cell AA57
10   If you are claiming exemption on housing loan interest, remember to update cells AA60 and AA61 (see below for the rules)
11   If you are claiming exemption for medical insurance that includes premium for a dependent over 65 years, change cell AA63
12   If you are claiming exemption for medical treatment for specific diseases for a dependent over 65 years, change cell AA64
13   If any of your dependents have severe (>80%) permanent physical disability, change cell AA65
14   If you have a permanent physical disability, change cell AA66 and AA67
15   If you are above 65 years of age, change cell AA68. You will get additional exemption
16   If you are a woman, remember to change cell AA69. You will get additional exemption
17   If you live in company-provided house, change cell AA70 and AA71; 15% of salary will be added as perks for cities with more than 25 lacs population (as per
     2001 census), 10% for cities with population of 15 lacs to 25 lacs, and 7.5% for other cities. If rent has been paid (cells D26 to O26), the same will be
     deducted from this perks amount
18   If you are using company provided car for both official and personal use, update cells D44 to O44. If the company also provides driver, update cells D45 to
     O45. If company bears the running and maintenance expenses for the car, update cell AA72. Also update the size of the car in cell AA73 (in terms of engine
     cubic capacity)
19   If you have been out of India during the year, update cells D46 to O46 so that conveyance exemption is computed correctly
20   If you have taken company loans at discounted interest rates, please enter the details in the sheet "Perquisites"
21   You can enter the opening balance in your PF account as at the beginning of the year in cell D40 and PF loans/withdrawals in cells D39 to O39 to calculate
     the closing balance (including employer's contribution) in your account at the end of the year
22   Update the earnings (cells D3 to O20) with expected earnings during the year. On the deductions side, enter the expected rent payment, Profession Tax and
     Life Insurance Salary deduction details for all months.
23   Enter expected bonus in Cell R21, if bonus for the year has not been paid yet. If paid, enter the actual amount
24   Enter any other earnings related to salary in cell S21
25   If tax has been deducted outside salary (such as TDS for bank deposit, etc.), enter the amount so deducted in cell G76
26   Enter any capital gains that are taxable at nominal tax rate (Stocks sold outside of registered stock exchanges, for example) in cell G58
27   Enter the remaining months in current financial year in Cell G79, to figure out the tax per month
28   You can change the headings for the 10 "Misc" earnings and the 9 "Oth Ded" deductions columns to suit your salary structure
29   Rent can be entered in cells D26 to O26, if deducted through salary; Otherwise enter annual figure in Q26 to S26. If you enter rent amount in any cell
     between D26 to O26, do not enter any amount in cells Q26 to S26 and vice-versa
30   Enter expected investments/savings/expenses information in cells N53 to N82
31   Other exemptions entered in cell N53 is not validated. So, please be sure about the amount entered

                                                                      Page 1 of 11
                                                             Income Tax Calculator
                                                                   Version 13.0
                                                          © 1997-2011, Nithyanand Yeswanth
                                          Available for free download at: http://taxcalc.ynithya.com/
                                                           email: taxcalc@ynithya.com

32   Enter non-salary related other income (such as from interest) in cell N62
33   You can enter the details of NSC's purchased during the last 5 years in the "NSC Accrued Interest" sheet to calculate the accrued interest automatically.
     This interest is exempt under sec 80C. This interest is also taxable either on accrual basis every year or when received
34   You can enter details of Stocks sold during the year in the "Capital Gains" sheet to calculate the tax applicable
35   HRA exemption is calculated on monthly basis and added up, which may not always be correct if your HRA, Rent or Basic+DA change month on month. In
     such cases, and if you have not moved from a metro to non-metro or vice-versa in the middle of the year, enter the rent details only in cells Q26 to S26 and
     NOT in cells D26 to O26. This will calculate the exemption on the total basis instead of monthly basis




                                                                      Page 2 of 11
                                                               Income Tax Calculator
                                                                    Version 13.0
                                                           © 1997-2011, Nithyanand Yeswanth
                                           Available for free download at: http://taxcalc.ynithya.com/
                                                            email: taxcalc@ynithya.com


                                     TAX RULES & OTHER USEFUL INFORMATION

 1   HRA exemption = minimum of (40% (50% for metros) of Basic+DA or HRA or rent paid - 10% of Basic+DA)
 2   Transport allowance is exempt upto Rs.800/- per month provided the person is in India during the month. For people having permanent physical disability,
     the exemption is Rs.1,600/- per month
 3   Medical bills are exempt for self and dependent family, upto Rs.15,000/- per annum
 4   LTA is exempt to the tune of ecomony class airfare for the family to any destination in India, by the shortest route.
     LTA can be claimed twice in a block of 4 calendar years. The current block is from Jan 2010 to Dec 2013
 5   Uniform allowance is exempt to the extent of bills produced for purchase of uniforms
 6   Gratuity, VRS and some such amounts are exempt upto certain limits. If you get any such payment, please find out the exact limit for you from a tax
     consultant and enter in cell N53
 7   Children's Education allowance is exempt upto Rs.100/- per child per month plus Rs.300/- per child per month for hostel expenses (max of 2 children only)

 8   There is an exemption for interest on housing loan. If the loan was taken before Apr 1, 1999 exemption is limited to Rs.30,000/- per year. If the loan was
     taken after Apr 1, 1999 exemption is limited to Rs.1,50,000/- per year if the house is self-occupied; there is no limit if the house is rented out.
     This exemption is available on accrual basis, which means if interest has accrued, you can claim exemption, irrespective of whether you've paid it or not. If
     the loan is taken jointly by two individuals both can claim this exemption

 9   If you have rented out your house, enter the total rent income/loss from the house (after deducting property tax and 30% of rent as standard maintenance
     expenses) in cell N60
10   Medical Insurance (such as Mediclaim) premium is exempt upto Rs.15,000/- per year for self, spouse & dependent children. An additional Rs.15,000/- is
     exempt towards premium for parents (even if they are not dependent). If the parent(s) are above 65 years of age, an extra Rs.5,000/- can be claimed

11   Deduction in respect of medical treatment of handicapped dependents is limited to Rs.50,000/- per year if the disability is less than 80% and Rs.1,00,000/-
     per year if the disability is more than 80%
12   Deduction in respect of medical treatment for specified ailments or diseases for the assesse or dependent can be claimed upto Rs.40,000/- per year. If the
     person being treated is a senior citizen, the exemption can go up to Rs.60,000/-
13   Interest repayment on education loan (taken for higher education from a university for self, spouse & children) is tax exempt from the 1st year of repayment
     up to a maximum of 8 years. There is no exemption for Principal payment
14   Donations given for certain charities are tax exempt. Some are exempt to the tune of 50%, whereas others are 100%. Please enter the actual amount
     exempt, in cell N69
15   If you do not get HRA, but have rented a house, an exemption is available. This will be calculated as minimum of (25% of total income or rent paid - 10% of
     total income or Rs.24,000/- per year)
16   Donations for certain scientific research and rural development are exempt. Please enter the actual amount exempt in cell N72
17   Interest earned from all sources is to be included in cell N62. All interest income (including Savings bank intererst) is fully taxable
18   If you have a permanent physical disability (including blindness), you can take an exemption of up to Rs.75,000/- per year
19   Investments up to 1 lac in PF, VFP, PPF, Insurance Premium, Housing loan principal repayment, NSC, ELSS, long term bank Fixed Deposit, Post Office Term
     Deposit, etc. are deductible from the taxable income under sec 80C. There is no limit on individual items, so all 1 lac can be invested in NSC, for example.
     The only exception is PPF where the maximum investment is limited to Rs.70,000/-. An additional Rs.20,000/- can be invested in long-term infrastructure
     bonds, taking total investment exemption to 1.2 lacs
20   As per clarification from IT department, all perquisites such as rent-free accommodation, company provided car, free or concessional education facilities,
     employee stock option plan, free club membership, company provided credit card, gift vouchers, meal coupons, hotel stay beyond 15 days, are fully taxable.
     This tax calculator calculates the tax incidence for accommodation and car. If you receive any other perquisite, please include the value of such perquisite
     in cell S21
21   For the current year, Govt. prescribed rate of interest for PF is 8.5%. If the employer pays interest higher than this, the differential interest earned is treated
     as perquisites
22   Residents of Sikkim are exempt from Income Tax




                                                                        Page 3 of 11
                                                                 Income Tax Calculator
                                                                       Version 13.0
                                                              © 1997-2011, Nithyanand Yeswanth
                                              Available for free download at: http://taxcalc.ynithya.com/
                                                               email: taxcalc@ynithya.com

                                            HOW TO GET AN UPDATE / CONTACT ME

    1    This tax calculator constantly gets updated to fix errors found as well as to add new features
    2    This may also be changed when there are changes in tax rules that affect income tax computation
    3    The latest version of this tool is available for free download from the Internet at http://taxcalc.ynithya.com/
    4    Please check back frequently (at least once every 2 months) to see that you have the latest version. You can compare the version number at the top of this
         instructions page. However, if you have subscribed, you will automatically receive updates
    5    You can also send a blank e-mail to taxcalc@ynithya.com with only the subject line as "SEND TAXCALC" and the latest version of tax calculator will be e-
         mailed to you within a day or two
    6    If you want me to send you a new version whenever I update, please send a blank e-mail to taxcalc@ynithya.com with only the subject as "SUBSCRIBE".
         There are no charges for subscription
    7    If you find any inaccuracy in the calculation or want clarification on some aspect of the tax calculator, please send an e-mail to taxcalc@ynithya.com with
         subject as "CLARIFICATION" and I will try to reply within a week
    8    If you are already on my list and no longer want to get updates, send a blank e-mail to taxcalc@ynithya.com with only the subject as "UNSUBSCRIBE"

    9    While sending e-mail, please ensure that the subject line is exactly as given here (without the quotes), because the processing is done automatically. Other
         mails will be deleted automatically
   10    Since I am not a chartered accountant or a tax consultant, I am not in a position to answer specfic queries related to taxation. You will have to contact
         a tax consultant for your specific queries



                                                         Click here to go to the tax calculation sheet


                                                                REVISION HISTORY

Version 13.0; Release date: April 20, 2010
         Updated for FY 2010-11 based on budget proposals
Version 12.0; Release date: August 02, 2009
         Updated for FY 2009-10 based on budget proposals. Fixed some errors
Version 11.0; Release date: April 14, 2008
         Updated for FY 2008-09
Version 10.1; Release date: April 11, 2007
         Fixed some errors in PF calculation and perquisites valuation, added Capital Gains Tax calculation
Version 10.0; Release date: March 25, 2007
         Updated for FY 2007-08. Reformatted to include more heads for income & deductions
Version 9.1; Release date: July 29, 2005
         Updated to include the budget revisions, NSC interest calculation error corrected, Surcharge calculation fixed
Version 9.0; Release date: May 01, 2005
         Updated for financial year 2005-06, corrections and enhancements incorporated
Version 8.2; Release date: January 14, 2005
         Fixed some errors in calculation of HRA exemption, surcharge, section 88D rebate, etc.
Version 8.1; Release date: September 18, 2004
         Updated to include the budget revisions
Version 8.0; Release date: May 10, 2004
         Updated for financial year 2004-05, corrections and enhancements incorporated
Version 7.1; Release date: May 08, 2003
         Updated to correct mistakes in: perquisites calculation, children's education rebate under section 88 and inclusion of interest income in gross income

Version 7.0; Release date: April 18, 2003
         Updated to include the new budget proposals for financial year 2003-04
Version 6.5; Release date: March 03, 2003
         Corrections: Housing loan interest and House/property income/loss was not being accounted correctly. Next year's (Financial year 2003-04) version 7.0
         should be out sometime in late April or early May 2003
Version 6.4; Release date: February 25, 2003
         Corrections: Std. deduction calculation, housing interest accounting, LIC SSS accounting, Perks calculation (different interest rates for the 2 loans)



                                                                          Page 4 of 11
                                                                  Income Tax Calculator
                                                                       Version 13.0
                                                              © 1997-2011, Nithyanand Yeswanth
                                              Available for free download at: http://taxcalc.ynithya.com/
                                                               email: taxcalc@ynithya.com

Version 6.3; Release date: January 09, 2003
         Corrections: Problem in tax rebate calculation when the salary is between 1 lac and 2 lacs; Housing loan interest calculation
Version 6.2; Release date: January 07, 2003
         Updated to fix some errors in calculation of Std. deduction, Tax rebate, Vehicle maintenance exemption, Perquisites, etc.
Version 6.1; Release date: May 15, 2002
         Updated to include the changes as passed in the finance bill; Fixed some minor defects
Version 6.0; Release date: April 10, 2002
         Updated to include the new budget proposals for financial year 2002-03




                                                                          Page 5 of 11
                4/8/2012                                                                                                                      Income Tax Projections for Financial Year 2010-11                                                                                                             Page 6 of 11


                                                                                                           PLEASE ENTER YOUR NAME HERE

                                  Incl PF?        Apr         May        Jun        Jul        Aug          Sep           Oct         Nov           Dec           Jan           Feb          Mar   Total   Perks   Bonus   Others   Gross
                        Basic         Y            0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                           DA         Y            0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                       Convey        N             0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                          HRA        N             0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                    Ch. Educ         N             0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                      Medical        N             0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                          LTA        N             0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                 Uniform All.        N             0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                         Misc        N             0            0          0         0           0            0            0            0             0            0              0            0      0                                0
 Earnings




                         Misc        N             0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                         Misc        N             0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                         Misc        N             0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                         Misc        N             0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                         Misc        N             0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                         Misc        N             0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                         Misc        N             0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                         Misc        N             0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                         Misc        N             0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                         Total                     0            0          0         0           0            0            0            0             0            0              0            0      0       0       0        0       0
                      Prof tax                     0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                            PF                     0            0          0         0           0            0            0            0             0            0              0            0      0               0                0
                          VPF                      0            0          0         0           0            0            0            0             0            0              0            0      0               0                0
                             IT                    0            0          0         0           0            0            0            0             0            0              0            0      0       0       0        0       0
                         Rent                      0            0          0         0           0            0            0            0             0            0              0            0      0       0       0        0       0
                   Life Insur.                     0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                     Oth Ded                       0            0          0         0           0            0            0            0             0            0              0            0      0                                0
 Deductions




                     Oth Ded                       0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                     Oth Ded                       0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                     Oth Ded                       0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                     Oth Ded                       0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                     Oth Ded                       0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                     Oth Ded                       0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                     Oth Ded                       0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                     Oth Ded                       0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                      Tot Ded                      0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                           Net                     0            0          0         0           0            0            0            0             0            0              0            0      0                                0
                  Loan/Wdwl                        0            0          0         0           0            0            0            0             0            0              0            0
                           OB                      0            0          0         0           0            0            0            0             0            0              0            0     0
 PF




                            Int                    0            0          0         0           0            0            0            0             0            0              0            0     0
                           CB                      0            0          0         0           0            0            0            0             0            0              0            0     0
                        VPF %                 0.00        0.00       0.00       0.00       0.00         0.00         0.00         0.00          0.00           0.00         0.00         0.00
               Co. Car used?                    N           N          N          N          N            N            N            N             N              N            N            N
              Co. Car driver?                   N           N          N          N          N            N            N            N             N              N            N            N
                    In India?                   Y           Y          Y          Y          Y            Y            Y            Y             Y              Y            Y            Y
                 Metro/non?                     N           N          N          N          N            N            N            N             N              N            N            N
                          PF%                12.00%      12.00%     12.00%     12.00%     12.00%       12.00%       12.00%       12.00%        12.00%         12.00%       12.00%       12.00%

Tax Computation                                                                                      Exemptions under section 10 & 17                                      Produced      Limited                                            SETUP PARAMETERS
Gross Salary                                                                        0                HRA Exemption (Sec 10 (13A))                                                0            0                                               Metro/Non-metro (M or N)                                                      N
Profession Tax                                                                      0                Transport Exemption (Sec 10(14))                                                         0                                               HRA Exempt limit (of Basic+DA)                                               40%
Exemptions under section 10 & 17                                                    0                Other exemptions under Sec 10 (10) (gratuity, etc.)                           0          0                                             PF/VPF deductions
Gross Salary after Section 10 & 17 exemptions                                       0                Medical Bills Exemption (Sec 17(2))                                           0          0                                               PF as a percentage of "Salary"                                           12.00%
Accommodation & Car Perquisites                                                     0                Children's Education Allowance Exemption (sec 10 (14))                        0          0                                               PF limited to Rs. (if there is a max. limit for deduction)                   0
Income chargeable under head 'Salaries'                                             0                LTA exemption (Sec 10(5))                                                     0          0                                               VPF as a percentage of "Salary"                                           0.00%
Income chargeable under head 'House/Property'                                       0                Uniform expenses (Sec 10(14))                                                 0          0                                               Interest rate on PF/VPF                                                    8.5%
Income chargeable under head 'Capital Gains' at nominal rate                        0                Total Exempted Allowances                                                                0                                               VPF as "Percentage of salary" or "Fixed amount"? (P or F)                    P
Income chargeable under head 'Other Sources'                                        0                Other income                                                          Produced      Limited                                            For Housing Loan
Gross Total Income                                                                  0                House/property income or loss (enter loss as negative)                      0            0                                               House self-occupied? (Y or N)                                                 Y
Deductions under chapter VI-A                                                       0                Interest on housing loan (for tax exemption)                                0            0                                               Loan taken after Apr 1, 1999?                                                 Y
Deductions under sec 80C                                                            0                Other income (interest, etc.)                                               0            0                                             Miscellaneous
Net taxable income                                                                  0                Deductions under Chapter VI-A                                         Produced      Limited                                              Sr. citizen included in medical insurance premium? (Y or N)                N
                                                                                                     Medical Insurance Premium (sec 80D)                                         0            0                                               Sr. citizen included in medical treatment u/s 80DDB? (Y or N)              N
Tax Slabs                                     Tax rate   Appl Amt    Balance       Tax               Medical Insurance Premium for parents (sec 80D)                             0            0                                               Dependents have permanent physical disability (>80%)? (Y or N)             N
00000 - 160000                                     0%          0          0         0                Medical for handicapped dependents (Sec 80DD)                               0            0                                               Have permanent physical disability? (Y or N)                               N
160001 - 500000                                   10%          0          0         0                Medical for specified diseases (Sec 80DDB)                                  0            0                                                  Is the permanent physical disability severe (>80%)? (Y or N)            N
500001 - 800000                                   20%          0          0         0                Higher Education Loan Interest Repayment (Sec 80E)                          0            0                                               Are you a senior citizen (age above 65 years)? (Y or N)                    N
> 800000                                          30%          0                    0                Donation to approved fund and charities (sec 80G)                           0            0                                               Male or Female                                                             M
Tax on Income                                                                       0                Rent deduction (sec 80GG) only if HRA not received                          0            0                                               Do you live in Company provided accommodation? (Y or N)                    N
Capital Gains Tax (from Stocks)                                                     0                Deduction for permanent disability (80U)                                                 0                                                  If living in Co. acco, population of your city                        <15lacs
Education Cess                                                                      0                Any other deductions                                                          0          0                                               Does company bear running/maint expenses for car? (Y or N)                 N



                Free Download from http://taxcalc.ynithya.com/                                                                                                         (Version 13.0)                                                                           © 1997-2011, Nithyanand Yeswanth (taxcalc@ynithya.com)
           4/8/2012                                                                                        Income Tax Projections for Financial Year 2010-11                                                           Page 7 of 11


                                                                       PLEASE ENTER YOUR NAME HERE

Total Tax Liability                                          0   Total Deductibles                                                                 0           Vehicle cubic capacity > 1600cc? (Y or N)                                N
                                                                 Deductions under Chapter VI (sec 80C)                           Produced     Limited
Total Income tax paid from salary                            0   Pension scheme (sec 80C)                                              0           0
Tax paid outside of salary                                   0   NSC (sec 80C)                                                         0           0
Income tax due                                               0   Public Provident Fund (sec 80C)                                       0           0
                                                                 Employees Provident Fund & Voluntary PF (sec 80C)                     0           0
Remaining months in year                                    12   Children's Education Tuition Fees (sec 80C)                           0           0
                                                                 Housing loan principal repayment (sec 80C)                            0           0
                                                                 Insurance premium & others (MF, ULIP, FD, etc.) (sec 80C)             0           0
Balance Tax payable                                         0
                                                                 Long-term Infrastructure Bonds (sec 80CCF)                            0           0
© 1997-2011, Nithyanand Yeswanth (taxcalc@ynithya.com)           Total Investments                                                                 0




           Free Download from http://taxcalc.ynithya.com/                                                                    (Version 13.0)                                    © 1997-2011, Nithyanand Yeswanth (taxcalc@ynithya.com)
4/8/2012                                                                   Perquisites Valuation for Income Tax Projections                                                                              Page 8 of 11




                                                                                        PLEASE ENTER YOUR NAME HERE


                                                                          Perquisites Value of Loans Taken from the Company

                                                                                   PC             Soft         Salary      Education                       Marriage            Other           Other           Other
                                         Housing Loan    Vehicle Loan                                                                    Phone Loan
                                                                                 Loan            Loan           Loan           Loan                           Loan             Loan            Loan            Loan
    Original Loan Amount                             0               0              0               0              0               0               0              0                0               0               0
    Loan Taken In Month/Year
    Loan Closed Month/Year
    No. of instalments                             100             50               36             36             10              36             15              36              50              36              50
    Co. interest rate                           0.00%          4.00%            0.00%           4.00%          0.00%           0.00%          0.00%           0.00%           0.00%           4.00%           0.00%
    EMI                                             0               0               0               0              0               0              0               0               0               0               0
    Second Loan Details (if loan of same type is taken again during the year) -- see Instructions below
    Original Loan Amount                             0               0                0              0               0              0              0               0               0               0               0
    Loan Taken In Month/Year
    Loan Closed Month/Year
    No. of instalments                             100             50               36             36             10              36             15              36              50              36              50
    Co. interest rate                           0.00%          4.00%            0.00%           4.00%          0.00%           0.00%          0.00%           0.00%           0.00%           4.00%           0.00%
    EMI                                             0               0               0               0              0               0              0               0               0               0               0

    Prescribed interest rate                   10.00%          10.00%         12.00%          12.00%          12.00%         12.00%          12.00%         12.00%          12.00%          12.00%           12.00%


    Total value of Perquisites for the year                                                                                                                                                                       0
                                                                                                                                                               © 2001-2011, Nithyanand Yeswanth (taxcalc@ynithya.com)

    Instructions:
        1. Enter the original loan amount, the month in which the loan was taken (e.g., DEC-2005), number of instalments and company interest rate in rows 5, 6, 10 and 11 respectively
        2. If the loan was pre-closed, enter the month in which it was pre-closed (e.g., AUG-2008) in row 7. Otherwise leave blank
        3. If you have taken another loan of same type, enter similar details in rows 14 through 20. For example, a Soft Loan taken in JUL-2005 may have
            completed its term (or pre-closed) in JUN-2008. These details can be entered in rows 5 through 11. Suppose another Soft Loan is taken in SEP-2008, those details
            may be entered in rows 14 through 20
        4. You can change the headings of the loans, if required. However, remember to change the corresponding "prescribed interest rate" in Row 23 as well




Free Download from http://taxcalc.ynithya.com/                                                      (Version 13.0)                                         © 1997-2011, Nithyanand Yeswanth (taxcalc@ynithya.com)
4/8/2012                                                      Accrued Interest for NSC                                                              Page 9 of 11

                                                               PLEASE ENTER YOUR NAME HERE


                                                              NSC Accrued Interest Calculation

                      Certificate No.                      Date of Purchase                     Amount invested                Accrued Interest
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00
                                                                                                              0                           0.00


                      Total Accrued Interest                                                                                              0.00
                                                                                           © 2001-2011, Nithyanand Yeswanth (taxcalc@ynithya.com)


                      Instructions:
                          1. Enter details of all NSCs purchased between 1-Apr-2004 and 31-Mar-2010
                          2. NSCs purchased before or after this date do not accrue interest for this financial year
                          3. Entry of certificate number is optional




Free Download from http://taxcalc.ynithya.com/                          (Version 13.0)                                     © 1997-2011, Nithyanand Yeswanth
4/8/2012                                               Capital Gains Tax Calculation                                      Page 10 of 12


                                                       PLEASE ENTER YOUR NAME HERE


                                                       Capital Gains Tax Calculation
                                (Only for Stocks bought/sold through a Stock Exchange and where STT is paid)

                                                                Purchase                        Selling                             LT/
Scrip Name                                       Nos                                                                        Gains
                                                              Price             Date        Price              Date                 ST
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0


Free Download from http://taxcalc.ynithya.com/                 (Version 13.0)                             © 1997-2011, Nithyanand Yeswanth
4/8/2012                                               Capital Gains Tax Calculation                                      Page 11 of 12


                                                       PLEASE ENTER YOUR NAME HERE


                                                       Capital Gains Tax Calculation
                                (Only for Stocks bought/sold through a Stock Exchange and where STT is paid)

                                                                Purchase                        Selling                             LT/
Scrip Name                                       Nos                                                                        Gains
                                                              Price             Date        Price              Date                 ST
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0
                                                                                                                                0

Total Short Term Gains                                                                                                                    0
Total Long Term Gains                                                                                                                     0
Total Capital Gains                                                                                                                       0


Free Download from http://taxcalc.ynithya.com/                 (Version 13.0)                             © 1997-2011, Nithyanand Yeswanth
4/8/2012                                               Capital Gains Tax Calculation                                            Page 12 of 12


                                                       PLEASE ENTER YOUR NAME HERE


                                                       Capital Gains Tax Calculation
                                 (Only for Stocks bought/sold through a Stock Exchange and where STT is paid)

                                                                 Purchase                          Selling                                  LT/
Scrip Name                                       Nos                                                                               Gains
                                                               Price              Date         Price             Date                       ST


Total Capital Gains Tax                                                                                                                           0
                                                                                             © 2001-2011, Nithyanand Yeswanth (taxcalc@ynithya.com)


Instructions:
    1. Enter details of all stocks sold during the current financial year
    2. Only stocks sold through a recognized stock exchange where the Securities Transaction Tax (STT) is paid should be entered




Free Download from http://taxcalc.ynithya.com/                   (Version 13.0)                              © 1997-2011, Nithyanand Yeswanth

				
DOCUMENT INFO
Categories:
Stats:
views:11
posted:4/8/2012
language:English
pages:12
Maneesh Choudhury Maneesh Choudhury Projects http://www.bellenokia.tk
About I AM A OPEN BOOK....READ ME........... I am invisible like air--- I am as important as oxygen--- I am living in the world of my dreamz I am always there to help otherz--- I am busy but never ignore any one I am the one who carez--- I---AM----MANEESH