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 โ