Free Excel templates

A free section 1033 replacement calculator in Excel

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.

Get the workbook

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 book behind this workbook

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

What is in the file

Six tabs. Blue cells are inputs; every result is a formula, and every tab after 1 Inputs ends with check rows.

Calculator
One conversion, one replacement: date of the event, kind of conversion (casualty or theft, condemned business or investment real property, main home in a federally declared disaster), year the gain is first realized, money received, expenses of obtaining it, adjusted basis and planned replacement cost; then the amount realized, the gain realized, recognized and postponed, the basis of the replacement, the cost that postpones all the gain and the end of the period.
1 Inputs
The book's case: the condemned strip, the severance damages, the fees, the replacement lot, the destroyed shed, the two insurance payments and the plan dates.
2 Condemnation
Table 1-3 of Publication 544 (2025), lines 1 to 24, with the same numbers, and the basis of the lot and its improvements.
3 Casualty
The fire: amount received net of the adjuster's fees, gain, first year of gain under the cash method, recognized and postponed gain, basis of the rebuilt shed.
4 Deadlines
Start and end of each replacement period, each replacement against its deadline, and the $100,000 related-person test of section 1033(i).
5 Variants
A late insurance check, a smaller rebuild, nothing replaced, a related seller, and a main home destroyed in a federally declared disaster with the section 121 exclusion.

Three things to try

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.

Questions

What does the calculator return for the example?

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.

Does it say whether my replacement qualifies?

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.

Does it compute the tax?

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.

Related reading