Realty Exchange Corporation has created this simple Capital Gain Analysis Form and Calculator to determine the tax impact if a property is sold and not exchanged, and to determine the reinvestment requirements for a tax-free exchange. See below for an example and explanation.

The purpose of this form is to estimate the tax impact if a property is sold but not exchanged and to determine the reinvestment requirements for a tax-free exchange.

A. Taxable Gain if property is sold:
1. SELLING PRICE
2. Subtract Selling Costs +
3. ADJUSTED SELLING PRICE =
4. ORIGINAL COST BASIS
5. Add Improvements
6. COST BASIS + IMPROVEMENTS
7. Subtract All Depreciation Authorized/Taken
8. ADJUSTED BASIS (subtract from Line 3) =
9. TOTAL TAXABLE CAPITAL GAIN if property is sold (or deferred if property is exchanged) =
B. Tax on Gain: (Note 3)
10a. Capital Gain Tax on Profit (Line 3 less Line 6 × 15%)
10b. Recapture Section 1250 Depreciation (Line 7 × 25%) + 1250
11. Your State Income Tax Rate (Note 5)
12. ESTIMATED TAX due if property is sold (or amount deferred if exchanged) (Note 6) =
C. Before and After Tax Proceeds
13. SELLING PRICE (Line 1)
14. Subtract Balance Due on All Loans -
15. EQUITY -
16. Subtract Selling Costs (Line 2) -
17. Proceeds Before Tax (cash to escrow in an exchange) =
18. Subtract Total Tax Due (Line 12) (Note 6) -
19. Net Sale Proceeds After Tax if property is sold =
D. Exchange Reinvestment Requirements
For deferral of all gain, the replacement propertiy(ies) must cost at least (Line 3):
The amount of cash that you must reinvest must be at least (Line 17):
The balance of funds needed to purchase the new property(ies) may be borrowed or new cash.

Notes:

(1) To estimate selling costs use 8 to 10% considering discounts or allowances given by seller.
(2) To estimate residential depreciation taken multiply purchase price of property being sold by 3%, times the number of years the property has been rented.
(3) Total taxable gain is the Profit (Line 10a) plus all the Depreciation taken (Line 10b).
(4) Section 1250 property is basically all real estate rental property.
(5) Your state taxes will vary depending on the state. We recommend checking state tax authority websites or consulting a local tax attorney or tax accountant to get an accurate number.
(6) Caution: Your recognized gain may push income above tax thresholds. Capital gain is X 20% if your taxable income is above ($425,800 S/$479,000 MFJ) and you may have to add and pay 3.8% Medicare Tax. (As of 7/2019)

Example and Explanation of the Like-Kind Exchange Analysis:

A rental property has a selling price of $500,000 and will have selling costs of $40,000. The property cost $150,000 when purchased ten years ago. No depreciable improvements have been made. The estimated depreciation taken is $45,000.



D. Exchange Reinvestment Requirements

For deferral of all gains the replacement property(ies) must cost at least $460,000 (line 3) and the amount of cash reinvested must be at least $360,000.00 (line 17).
The balance of funds needed to purchase the new property(ies) may be borrowed and/or be new cash.
If the new property(ies) cost less than line 3 or the cash reinvested is less than line 16, then the capital gain will be recognized and be taxed on whichever amount of difference is larger (The recaptured Section 1250 depreciation will be taxed first.)

A PDF version of our calculator is available below if you would like to have something that you can use offline. The Calculator requires Acrobat Reader 4.0 or higher. Please upgrade your Acrobat Reader for free using this link.
Open the Gain Calculator as a PDF

After opening the PDF Exchange Analysis form – fill in six shaded lines. Other lines are computed automatically for you. You do not have to put in $ signs.