Spreadsheet: 596c0c4d-1830-4118-bd6c-706470f64fb8
Sheet: Sheet1

http://www.PankajBatra.com | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
Tax Calculator F.Y. 2009-10
Sex (for male - 1, for female - 0) | 1
Place of Residence(For Metro cities-0,For Non Metro cities-1) | 1
Age | 25
Number of children | 0
[NAME] | Investment & | April | May | June | July | August | September | October | November | December | January | February | March | Total
 | Bills Details
Basic |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
HRA |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Transport Allowance |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Child Education |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Grade/Special/Dearness Allowance |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Arrears |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
LTA |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Leave Encashment |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Performance Incentive |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Medical Reimbursement |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Food Coupons\Periodical Journals |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Telephone Reimbursements |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Car Reimbursement |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Internet Expense |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Driver Salary |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Gifts From Non-Relatives |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Gifts From Relatives |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
TOTAL SALARY |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Less : Exemptions
Actual Rent paid as per rent receipts |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
HRA Exemption |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Child Education Allowance | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Medical Reimbursement | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Transport Allowance | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
LTA |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Food Coupons | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Telephone Reimbursement | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Car Expenses Reimbursement | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Internet expense | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Driver Salary | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Other Reimbursement | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Professional Tax |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Net Taxable Salary |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Loss from House Property (interest component) |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Any other Income | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Gross Total Income |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Deductions under chapter VIA
80C + 80CCC(Pension Fund): | Amt. Invested
[NAME]
Employee's contribution to PF
PPF
ELSS
Others | 0
Tution Fees paid | 0
Housing Loan Principal repayment | 0
Infrastructure Bonds | 0
Fixed Deposit for 5 yrs. or more | 0
Others | 0
Total of Section 80C | 0
Pension Fund (80 CCC)
Total Deduction under Section 80C & 80CCC | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
80D (Medical insurance premium, Self/Family) |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
80D (Medical insurance premium, Parents) |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
80E (Interest on Loan for Higher Education) | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
80U (Handicapped person) | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
80G (100 % deductions) | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
80G (50 % deductions) | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Total Income |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Total Income rounded off |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Tax on Total Income |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Surcharge |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Tax Payable |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Education Cess @ 3% |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Balance |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
TDS |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Net Tax Payable |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Monthly Deductions from salary |  | April | May | June | July | August | September | October | November | December | January | February | March
TDS |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Professional Tax |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Employee's PF Contribution |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Others deductions (transport etc.) |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Employer's PF Contribution |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
In Hand |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ADVANCE TAX SCHEDULE
Total Tax as per Consolidation Sheet: | 0
PARTICULARS | % | PAYABLE | PAID | DIFFERENCE
Payable upto 15th June, 2009 | 0.15 | 0 | 0 | 0
Payable upto 15th September, 2009 | 0.3 | 0 | 0 | 0
Payable upto 15th December, 2009 | 0.6 | 0 | 0 | 0
Payable upto 15th March, 2010 | 1 | 0 | 0 | 0