For a condemnation, a casualty or a theft: the gain realized, the part recognized and the part postponed by the replacement, the basis of what you buy and the date the replacement period ends. With the full case workbook of the book behind it.
The example is a warehouse destroyed by a storm on October 6, 2026. The insurer paid $450,000 in 2026 against an adjusted basis of $200,000, a gain of $250,000. A replacement warehouse costing $400,000 leaves $50,000 of the insurance unspent: that much gain is recognized, $200,000 is postponed, and the new warehouse takes a basis of $200,000. The replacement period ends on December 31, 2028. Replace the inputs with your own figures.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
Section_1033_Replacement_Calculator.xlsx (20 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
The five case tabs are the model of The Involuntary Conversion Handbook. The book follows one owner through a partial condemnation with severance damages and a fire paid for over two years: the Publication 544 worksheet line by line, the year of each gain, the like-kind and similar-use tests, the related-person limit, the basis of the replacements and the election.
DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide
Six tabs. Blue cells are inputs; every result is a formula, and every tab after 1 Inputs ends with check rows.
Lower the replacement cost. Every dollar of the amount realized not reinvested is a dollar of recognized gain, up to the gain itself. Raise the cost until the recognized gain reaches zero: that is the budget that postpones all of it, here $450,000.
Change the kind of conversion. As a condemnation of business real property replaced by like-kind real property, the same dates give a period ending on December 31, 2029, a year later.
Move the year of the gain. If the insurer had paid in January of the next year, the gain would be realized a year later and the period would end a year later. The period counts from the close of the first year in which any gain is realized, not from the date of the event.
A gain realized of $250,000, a recognized gain of $50,000, a postponed gain of $200,000, a basis of $200,000 for the replacement, and a period ending on December 31, 2028.
No. Whether the replacement is similar or related in service or use, like-kind real property, or bought from a related person is a reading of the facts that belongs to a CPA. The workbook prices the result once that reading is made.
The calculator stops at the recognized gain and the basis. The case tabs apply assumed flat rates to show the order of size; the rate on a real gain depends on its character and on the owner's other gains and losses.