Capital Gains Calculator for Property

Capital Gains Calculator for Property

Capital Gains Calculator for Property

We have compiled an Excel based Capital gains calculator for Property. It calculates both Long Term and Short Term capital gains and associated taxes. You need to feed your property sale & purchase date along with values. There is option to include cost of repairs/improvement that you might have incurred during the holding period.

Before you start using the calculator here are some things you must know:

Short Term Vs Long Term Capital Gains:

If the property is sold after 3 years of purchase the corresponding gains or losses is called LONG Term Capital Gains (or Loss). If sold within 3 years its SHORT Term Capital gains (or loss).

Long Term capital gains from property is taxed at flat rate of 20% after taking indexation in account. There is education cess of 3% effectively taking tax to 20.6%.

Short Term Capital Gains from property is added to income and taxed at your income tax slab rates.

Download: Income Tax Calculator for FY 2016-17 [AY 2017-18]

How to Calculate Capital Gains?

1. Take Full value of consideration (sale price)

2. Subtract the following from above:

  • Purchase cost
  • Any cost related to purchase of property like stamp duty, registration cost, brokerage, traveling cost related to purchase, etc
  • Cost of major repairs, improvement or renovation during the holding life of the property
  • In case of inherited property you can consider cost related to inheritance paper work.

3. The resultant amount is Capital Gains.

For long term capital gains all the deductions are indexed using CII (Cost Inflation Index) published annually by Government of India.

Also Read: 25 Tax Free Incomes & Investments in India

Some Points:

1. In case the property has been purchased before April 1981, you will need to get its fair valuation done by income tax approved valuers as of April 1981. This is because CII for indexation started getting published from FY 1981-82 with value of 100.

2. Cost on improvements made before April 1, 1981 cannot be consideration.

3. To calculated capital gains for inherited property, the purchase cost and time of the original buyer is taken into consideration.

Also Read: How are your Investments Taxed?

Download Calculator:

Download the excel based Capital gains calculator for Property from the link below:

Save Capital Gains Tax:

There are two ways you can save Long Term Capital Gains from sale of property.

  1. Reinvest the amount to buy one new residential property (NO land or commercial property) in India within 2 years of selling or construct a house within 3 years. If you already have bought a house within 1 year before selling the property you get tax exemption.
  2. Invest in REC or NHAI Capital Gains Bond up to Rs 50 Lakhs under Section 54EC. The bonds mature in 3 years and offer interest of 5.25% payable annually. The interest received is fully taxable.

Also Read: Best Tax Saving Investments

In case you are not able to invest full capital gains as above, you will get tax exemption only on invested amount. The remaining amount would be taxed as per rules.

The sale proceeds should be deposited in Capital Gains Account scheme with banks if the gains have not been utilized for buying property or bonds before filing income tax returns. We will do a detailed post on – How to save capital gains on property soon.

8 thoughts on “Capital Gains Calculator for Property

  1. I have purchased a old house for 2Crore. I have paid fully with my saving and retirement benefits.
    Later after 6 months I sold my 30×40 site for 75 Lakh. And I sold my flat for 50Lakh
    Captital gain from these property can be adjusted with the purchased of house which happed 6 months earlier.

  2. Dear Sir

    I notice from your website that the XL sheet for Capital Gain calculation is based on the base year of 1981. I shall appreciate if you can mail me OR mail me the link where I can get the XL sheet with the new base year of 2001.

    Thank you.

  3. Sir I am going to purchase a plot in Noida . Which circle rate is 72000 / meter and deal value is 55000/ meter. I am salaried person my salary is 51 lac. Plz calculate how much tax I have to paid tax according this capital gain . By buyer


    I want to sell my house bought in Aug 1991 now at a price of Rs.80 lacs what capital gain tax I have to pay now I bought for Rs.2.50lacs at that time pl reply me

  5. Sanjay kumar - Practicing Cost & Management Accountant says:

    simply one of the best sites for taxation matter

Leave a Reply

Your email address will not be published. Required fields are marked *