Depreciation Chart as per Income Tax Act

๐Ÿ“‹ Sheet 1 โ€” Depreciation Rate Chart Complete statutory rate table covering all 28 asset items across Part A (Tangible) and Part B (Intangible), with columns for: Block of Asset, Depreciation Rate, Half-Year Rate (< 180 days) Additional Depreciation eligibility & rate Remarks/Provisos 10 important statutory notes at the bottom ๐Ÿงฎ Sheet 2 โ€” WDV […]

๐Ÿ”„ Published Jul 2026

Trusted by 6,00,000+ CA professionals across India

โฌ‡ Available Downloads

Excel Format (Editable) ๐Ÿ”’

XLSX Pro 22 KB โœ๏ธ Editable

๐Ÿ“‹ Sheet 1 โ€” Depreciation Rate Chart Complete statutory rate table covering all 28 asset items across Part A (Tangible) and Part B (Intangible), with columns for:

  • Block of Asset, Depreciation Rate, Half-Year Rate (< 180 days)
  • Additional Depreciation eligibility & rate
  • Remarks/Provisos
  • 10 important statutory notes at the bottom

๐Ÿงฎ Sheet 2 โ€” WDV Calculator Block-wise live calculator โ€” enter Opening WDV, additions, and sales; it auto-computes:

  • Net WDV, Normal Depreciation (with 180-day rule), Additional Depreciation, Closing WDV

๐Ÿ“Š Sheet 3 โ€” Block-wise WDV Tracker Multi-year WDV tracker across AY 2022-23 to AY 2026-27 for all blocks

โž• Sheet 4 โ€” Additional Depreciation Workings Dedicated working paper for Section 32(1)(iia) โ€” enters asset-wise actual cost & days in use, auto-flags Full/Half year and computes 20% or 10% accordingly

โšก Sheet 5 โ€” Quick Reference Card At-a-glance rate card colour-coded by rate band (Low / Medium / High / 100%) with eligibility summary


Color convention: Blue text = input cells | Black = formulas | Rate cells color-coded (green = low, amber = medium, red = high/100%)

Get Unlimited Access with Pro Membership

Download unlimited formats, get editable files, and access premium CA resources.

  • Unlimited downloads
  • Editable Word / Excel formats
  • Premium CA toolkit access
  • GST / ROC / Audit templates
  • Priority format updates
  • AI drafting tools (coming soon)
โ‚น99
per month
โ‚น1,499
lifetime
๐Ÿ‘‘ Upgrade to Pro

What is Included in This Format?

This format includes a professionally structured template ready for immediate use. Fields are clearly labeled for easy customization.

Disclaimer: This format is provided for general information only. Please review applicable laws and professional requirements before use.