Work out the Capital Gains Tax before you sell — not after.
YOU ENTER
• Sale price and selling costs
• Purchase price, purchase costs and capital improvements
• Your share of the property
• Total months owned, and months it was your main residence
• Your total annual income
IT WORKS OUT
• Gross gain on your share
• Private Residence Relief — main-home months, plus the final 9
• The annual exempt amount you use
• Taxable gain
• The slice taxed at 18%, and the slice taxed at 24%
• CGT payable
• Net proceeds after tax
• Your effective tax rate on the gain
The annual exempt amount, the higher-rate threshold and both CGT rates are
editable, so it stays right when the rules move.
Worth knowing: residential property gains must be reported and paid within
60 days of completion. That deadline catches people out — and it starts
whether or not you've worked out the number.
Excel (.xlsx). Works in Microsoft Excel and Google Sheets. Instant download.
Educational tool only. Not tax advice. CGT is fact-specific — take proper
advice before you sell. Correct as of July 2026.
Work out the Capital Gains Tax before you sell — not after.
YOU ENTER
• Sale price and selling costs
• Purchase price, purchase costs and capital improvements
• Your share of the property
• Total months owned, and months it was your main residence
• Your total annual income
IT WORKS OUT
• Gross gain on your share
• Private Residence Relief — main-home months, plus the final 9
• The annual exempt amount you use
• Taxable gain
• The slice taxed at 18%, and the slice taxed at 24%
• CGT payable
• Net proceeds after tax
• Your effective tax rate on the gain
The annual exempt amount, the higher-rate threshold and both CGT rates are
editable, so it stays right when the rules move.
Worth knowing: residential property gains must be reported and paid within
60 days of completion. That deadline catches people out — and it starts
whether or not you've worked out the number.
Excel (.xlsx). Works in Microsoft Excel and Google Sheets. Instant download.
Educational tool only. Not tax advice. CGT is fact-specific — take proper
advice before you sell. Correct as of July 2026.
