| Cell A (Item) | Cell B (Your Input ₹) | Formula/Magic | | :--- | :--- | :--- | | | 12,00,000 | Manual Entry | | HRA Received | 1,20,000 | Manual Entry | | Less: HRA Exemption (Calc below) | 72,000 | =MIN(Actual HRA, 50% of Basic, Rent - 10% of Salary) | | Standard Deduction | 50,000 | Automatic (Default ₹50k) | | Section 80C (Max 1.5L) | 1,50,000 | Manual Entry (Sum of LIC/PPF/ELSS) | | Section 80D (Medical Insurance) | 25,000 | Manual Entry | | Home Loan Interest (24b) | 2,00,000 | Manual Entry | | Total Deductions | 4,25,000 | =SUM(HRA Exempt + Std Ded + 80C + 80D + 24b) |
Submit your provisional declaration in April to avoid heavy TDS deductions early in the fiscal year. Xxcxx Declaration Impots Calculator India Excel Pdf
Use this sheet to calculate your final tax liability under both regimes. | Cell A (Item) | Cell B (Your
Fields for rent paid and landlord's PAN. Section 24(b): Interest payable on a home loan. Section 80G: Donations to charitable funds. How to Convert Your Declaration to PDF Section 24(b): Interest payable on a home loan
Capped at ₹1,500,000 (PPF, EPF, ELSS, NPS, Principal Home Loan repayment).