Excel template · Tax & compliance

Capital Gains Calculator in Excel – Shares, Property, Gold (2026-27)

List every sale in the year – shares, equity and debt mutual funds, property, gold, unlisted shares or bonds. The calculator decides short-term or long-term, applies grandfathering for shares bought before 1 February 2018 and indexation for property bought before 23 July 2024, sets off losses in the right order, applies the ₹1.25 lakh exemption and estimates the tax.

For: Investors, property sellers, salaried people with mutual funds and shares, and accountants and tax preparers who compute capital gains for clients.

Free download · no sign-up · no macros · Excel 2010+, Google Sheets, LibreOffice

Preview of the Capital Gains Calculator Excel template with sample data
Main sheet with sample data

At a glance

What it is
Capital Gains Calculator — an Excel workbook for Indian taxpayers, businesses and tax practitioners
Free edition
4 sheets (Guide, Transactions, Summary, Lists) — free download, no sign-up
Pro edition
6 sheets, adds Exemption Planner and LTCG Harvesting — ₹19 one-time (regular ₹99)
Works in
Microsoft Excel 2010 or later, Google Sheets, LibreOffice Calc — no macros
Checked
Recalculated with zero formula errors; sample data and a Guide sheet included
Made by
Prakash Bagchi, finance professional, PB Lab (Raipur, India)

Free vs Pro: what you get

SheetFreePro
Guide
What it does, how to use it, assumptions and a live status check
Transactions
Up to 200 sales: asset type, dates, sale value, expenses, cost, improvement and FMV, with holding period, term, cost used, gain with and without indexation and tax bucket
Summary
Gains and losses by tax bucket, set-off of short-term and long-term losses, the 112A exemption, tax at each rate, cess and losses to carry forward
Lists
Cost Inflation Index from 2001-02 to 2026-27 and the asset types
Exemption Planner
Reinvestment exemptions under old sections 54, 54EC and 54F: exemption, tax saved, amount to invest and every deadline from the sale date
—
LTCG Harvesting
How many units of each long-term equity holding to sell before 31 March to use the ₹1.25 lakh exemption
—

Pro edition

Get Capital Gains Calculator – Pro

₹19₹9981% OFF

Everything in the free edition, plus:

  • Exemption Planner — Reinvestment exemptions under old sections 54, 54EC and 54F: exemption, tax saved, amount to invest and every deadline from the sale date
  • LTCG Harvesting — How many units of each long-term equity holding to sell before 31 March to use the ₹1.25 lakh exemption
  • One-time payment, instant .xlsx download, free updates
+91

Secure payment by Razorpay · UPI, cards, netbanking & wallets

We use your details only to deliver the file and support your purchase. See our privacy policy and terms.

Need more than one? The Tax & Compliance Kit has all 5 tax & compliance Pro templates, including this one, for ₹74.

How to use it

  1. 1Download the free file and read the Guide sheet.
  2. 2On Transactions, add one row per sale and pick the asset type from the list.
  3. 3Enter purchase and sale dates, sale value, expenses and cost (and FMV for shares bought before 2018).
  4. 4Check each row's term and tax bucket.
  5. 5Open Summary for set-off, the exemption, the tax and any losses to carry forward.

Short-term or long-term?

Listed shares, equity mutual funds and other listed securities become long-term after 12 months. Everything else – property, gold, unlisted shares, debt funds bought before April 2023 – needs more than 24 months. Debt mutual funds bought on or after 1 April 2023 are always treated as short-term and taxed at your slab rate, however long you hold them. The Transactions sheet works out the holding period from the two dates and sets the term automatically.

Tax rates in 2026-27

Short-term gains on listed shares and equity funds (with STT paid) are taxed at 20%. Long-term gains on all assets are taxed at 12.5% without indexation, and the first ₹1.25 lakh of long-term gains on listed equity in a year is exempt (old section 112A). Other short-term gains are added to your income and taxed at slab rates. 4% cess applies on top; surcharge for high incomes is not included.

Grandfathering and indexation

For listed shares and equity funds bought before 1 February 2018, the cost is the higher of the actual cost and the fair market value on 31 January 2018 (capped at the sale value), so gains made before that date stay tax-free. Enter the FMV in its column and the sheet does the rest.

For land or buildings bought before 23 July 2024, resident individuals and HUFs pay the lower of 12.5% on the gain without indexation and 20% on the gain with indexation. The sheet works out both using the Cost Inflation Index – 384 for 2026-27 – and picks the cheaper option. For property bought before 1 April 2001 you can use its fair market value on that date as the cost.

Set-off of losses

Gains and losses are first netted within each tax bucket. A short-term capital loss can then be set off against any capital gain, short or long term; a long-term loss only against long-term gains. The Summary applies short-term losses first to slab-rate gains, then 20% gains, then long-term gains – usually the order that saves most tax. Losses that remain can be carried forward for eight years if you file your return on time.

Free vs Pro

The free edition computes gains, set-off and tax for up to 200 sales. The Pro edition adds an exemption planner for reinvesting in a house or 54EC bonds, with deadlines, and a harvesting planner to use the ₹1.25 lakh exemption on listed equity each year.

Written by Prakash Bagchi, finance professional and founder of PB Lab. Last reviewed .

Frequently asked questions

What is the LTCG tax rate on shares in 2026-27?

12.5% on long-term gains from listed shares and equity mutual funds above ₹1.25 lakh in the year, plus 4% cess. Short-term gains are taxed at 20%.

Is indexation still available on property?

Only for land or buildings bought before 23 July 2024 by resident individuals and HUFs: you pay the lower of 12.5% without indexation and 20% with indexation. The calculator works out both.

What is the Cost Inflation Index for 2026-27?

384, with 2001-02 as the base year (100). The full table is on the Lists sheet; add the next year's figure when CBDT notifies it.

How are debt mutual funds taxed?

Units bought on or after 1 April 2023 are taxed as short-term gains at your slab rate regardless of holding period. Older units held more than 24 months are long-term and taxed at 12.5%.

What is grandfathering for shares?

For listed equity bought before 1 February 2018, the cost is the higher of the actual cost and the 31 January 2018 market value (capped at the sale price), so pre-2018 gains are not taxed.

Can I set off a capital loss against salary?

No. Capital losses can only be set off against capital gains – short-term losses against any gains, long-term losses only against long-term gains – and the rest carried forward for eight years.

How can I save tax on a property sale?

Reinvest in a residential house (old sections 54 and 54F) or buy 54EC bonds within six months, up to ₹50 lakh. The Pro edition's Exemption Planner shows the exemption, tax saved and deadlines.

How much does the Pro edition cost and how do I get it?

The Pro edition is ₹19 (regular price ₹99), a one-time payment through Razorpay by UPI, card, netbanking or wallet. You download the .xlsx file right after paying, and the download page works again later if you bookmark it. Pro adds: Exemption Planner, LTCG Harvesting.

Related free calculators

More Excel templates

See all templates →

Disclaimer: This template is a working aid, not legal, tax or accounting advice. Sample data is fictional. Laws, rates and thresholds change — verify them against the current Act, rules and notifications, or with a qualified professional, before relying on the results. PB Lab is not responsible for decisions made using this file.