๐ 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%)