Capital gain Calculator

Sheet 1 โ€” Capital Gain Calculator with 6 sections: Section What it covers ๐Ÿ“‹ Asset Information Asset name, category, purchase/sale dates, auto-calculated holding period ๐Ÿ’ฐ Purchase Details Purchase price, units, expenses, improvement cost, CII for indexation ๐Ÿ“ˆ Sale Details Sale price, units, brokerage, STT โ€” auto-calculates net proceeds ๐Ÿงฎ Gain Computation Auto-detects LTCG vs STCG, […]

๐Ÿ”„ Published Jul 2026

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

โฌ‡ Available Downloads

Excel Format (Editable) ๐Ÿ”’

XLSX Pro 11 KB โœ๏ธ Editable

Sheet 1 โ€” Capital Gain Calculator with 6 sections:

Section What it covers
๐Ÿ“‹ Asset Information Asset name, category, purchase/sale dates, auto-calculated holding period
๐Ÿ’ฐ Purchase Details Purchase price, units, expenses, improvement cost, CII for indexation
๐Ÿ“ˆ Sale Details Sale price, units, brokerage, STT โ€” auto-calculates net proceeds
๐Ÿงฎ Gain Computation Auto-detects LTCG vs STCG, computes gain with & without indexation, tax + cess
๐Ÿ“Š Summary Dashboard ROI, annualised ROI, net profit after tax, effective tax rate
๐Ÿ“ Notes Key assumptions and usage guidance

Sheet 2 โ€” Tax Rate Reference table covering equity, property, gold, debt MFs, crypto, and more.

Key features:

  • Blue cells = your input fields; all other values calculate automatically
  • Dates auto-compute holding period and classify LTCG vs STCG
  • Indexation benefit formula built in (using Cost Inflation Index)
  • Surcharge + 4% health & education cess factored into final liability
  • Zero formula errors โœ…

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.