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 Capital Gain Calculator requires the latest Adobe Acrobat Reader to analyze and model the impact of your 1031 exchange. The Calculator requires Acrobat Reader 4.0 or higher. Please upgrade your Acrobat Reader for free using this link.
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.
Example and Explanation of the Like-Kind Exchange Analysis
The Like-Kind Exchange Analysis is used to determine the tax impact if a property is sold and not exchanged.
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.
|A||Potential Taxable Gain when the Property Sells|
|2||Less: Selling Costs (see Note 1)||-$40,000|
|3||Equals: Adjusted Selling Price||$460,000|
|4||Original Cost Basis||$150,000|
|6||Equals: Adjusted Cost Basis||$150,000|
|7||Less: All Depreciation Taken (see Note 2)||-$45,000|
|8||Equals: Tax Basis||-$105,000|
|9||Total: Taxable Gain or Loss if the property sold||$355,000|
|B||Tax on the Gain if the Property Sells|
|10A||Recapture of all Section 1250 depreciation allowed
(see Note 4)
|$45,000 x 25%||$11,250|
|10B||Capital Gain on Profit (SEE NOTE #5)
(Adj Selling Price less Adj Cost Basis)
|$310,000 x 15%||+$46,500|
|11||Total: Federal Tax if the property sold||$57,750|
|C||Before and After-Tax Proceeds|
|12||Selling Price (line 1)||$500,000|
|13||Less: Balance Due on all Loans||-$100,000|
|15||Less: Selling Costs (Line 2)||-$40,000|
|16||Proceeds Before Tax (cash to Escrow in an Exchange)||$360,000|
|17||Less: Total Tax Due (line 11)||-$57,750|
|18||Net Sale Proceeds After Tax if the property sold||$302,250|
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 16).
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.)
- To estimate selling costs use 8 to 10% considering points paid or allowances given by the seller.
- To estimate residential depreciation taken multiply the original purchase price by 3%, times the number of years the property has been owned.
- Total taxable gain is the profit plus all the depreciation taken.
- Section 1250 property is all real estate rental property.
- For 2018, Capital Gains contributing to total income above $479,000 (MFJ or surviving spouse) or $425,000 (single) are taxed at 20%. If total income is below $77,200 (MFJ) the capital gains tax is Zero %. These threshold amounts will be adjusted for inflation after 2018.