Inputs to organize
- Amount realized
- Adjusted basis
- Exchange expenses
- Money and non-like-kind property received
- Liability inputs
What the calculator shows
- Estimated realized gain
- Estimated recognized gain
- Estimated deferred gain
- Replacement basis checkpoint
How the worksheet moves from facts to an estimate
Estimate realized gain from amount realized less adjusted basis and entered exchange expenses as classified for the model.
Import potential boot from the cash, non-like-kind property, and liability worksheet.
Estimate recognized gain subject to the realized-gain ceiling and any professional adjustments.
Estimate deferred gain as realized gain less recognized gain.
Display a replacement-basis checkpoint without presenting it as a filed-tax-return number.
Begin with the economic gain before estimating tax
The first calculation is not the tax bill. It is the gain created by the disposition. Amount realized can include cash, property received, and liabilities handled through the transaction. Adjusted basis begins with cost and changes over the ownership period. Entered exchange expenses may reduce the modeled gain, but every closing cost must be classified before it is treated that way. A settlement statement, depreciation schedule, and basis ledger are more reliable than memory.
Realized gain and recognized gain answer different questions. Realized gain measures the economic result. Recognized gain estimates the portion included currently when money or other non-like-kind value is received. Deferred gain is the remainder carried into the replacement-property basis. Keeping those numbers separate prevents a common mistake: treating deferral as forgiveness or treating every dollar of sale proceeds as taxable gain.
Separate gain amount from gain character
A single realized-gain number can contain components taxed differently. Land, building depreciation, cost-segregation assets, qualified improvement property, and prior deductions may require separate treatment. Unrecaptured Section 1250 gain, ordinary recapture, long-term capital gain, state tax, and possible net investment income tax cannot be determined from sale price alone. The editable rates on the homepage are an illustration of magnitude, not a substitute for the taxpayer's return.
Character also affects what happens when part of the gain is recognized. A proportional estimate can be useful for early planning, but the actual allocation may depend on the assets transferred, depreciation history, cash received, liabilities, and Form 8824 reporting. Bring the depreciation schedule and any cost-segregation study into the review before relying on a tax estimate.
Reconcile the amount realized to the closing documents
The contract price is only the beginning of the reconciliation. Credits, prorations, seller financing, assumed liabilities, deposits, and non-like-kind property can affect the amount realized or the way proceeds are reported. Compare the calculator entry with the draft closing statement and the qualified intermediary's exchange statement. If those documents do not reach the same number, the difference needs a name before it enters the model.
Exchange expenses deserve the same discipline. Brokerage commissions and certain transfer costs may affect the exchange calculation, while financing costs, reserves, repairs, and other charges may receive different treatment. The calculator leaves the expense input visible so the adviser can decide what belongs there instead of hiding the classification inside a black-box result.
Test replacement value and equity beside the gain
A large deferred-gain estimate does not prove that the contemplated replacement plan will support full deferral. Compare the net relinquished value with the replacement purchase price, then compare net exchange equity with replacement equity. A value shortfall and an equity shortfall can describe the same economic gap, which is why the homepage checkpoint uses the larger shortfall rather than adding overlapping deficits twice.
Debt is part of that comparison, but debt replacement is not a stand-alone rule that should be read without the cash contribution. Lower replacement debt may be offset by additional cash, while higher debt does not cure cash taken from the exchange. Model the complete sources and uses of funds and reconcile them to the lender term sheet and closing instructions.
Use the result to prepare a useful adviser conversation
A strong review package includes the taxpayer name and entity, property use, expected transfer date, contract price, debt payoff, basis support, depreciation, selling costs, proposed replacement value, replacement debt, and any cash expected outside the exchange. Add the qualified intermediary's name if one has been selected. Missing facts should remain visibly marked as open rather than replaced with guesses.
Call before closing when possible. Once proceeds reach the seller, ownership changes, or the relinquished property transfers without the required structure, a calculator cannot repair the sequence. Early review also gives the replacement-property search a realistic value and equity target instead of a vague instruction to buy something more expensive.
Read the estimate as a range, not a promise
Run more than one scenario. Use the expected contract, a lower net sale result, a higher debt payoff, and two replacement budgets. Change the tax-rate assumptions to reflect the taxpayer's actual planning range. If a small change produces a large shift in estimated recognition, that input belongs at the top of the professional-review list.
The most useful output is not the largest potential deferral number. It is a transparent bridge from source documents to a decision that can still be changed. Save the inputs, note the date of the estimate, and update the worksheet when the closing statement, depreciation schedule, lender terms, or replacement-property plan changes.
A transparent estimate is stronger than a confident guess.
Keep the source for every input beside the calculation. Use the current contract, draft settlement statement, payoff, basis records, depreciation schedule, replacement-property facts, lender terms, and qualified-intermediary information. Mark incomplete numbers as estimates and update them when documents change. A calculator cannot see title, taxpayer identity, property use, related parties, funds flow, mixed use, asset character, disaster relief, or a closing instruction that changes the result.
Run a conservative scenario as well as the expected case. Lower sale proceeds, higher expenses, a different debt payoff, or a delayed replacement closing can expose a weak point before it becomes irreversible. Save the date and assumptions with the output. If the result changes materially from one reasonable scenario to another, move that fact to the top of the CPA, attorney, qualified intermediary, lender, broker, or licensed securities professional review.
The initial calculation review is free and can begin before listing, while under contract, during the identification period, or while comparing replacement options. The objective is to organize a clear exchange brief and route regulated work to the appropriate professional. The worksheet remains educational and should not be copied into a filed return or closing instruction without transaction-specific review.
Create a file another professional can audit.
Begin the handoff with the taxpayer name, relinquished property, qualifying use, anticipated closing date, exchange status, and the decision the calculation is meant to support. Separate facts already supported by a document from assumptions that still need confirmation. A one-page summary should tell a CPA, attorney, qualified intermediary, lender, broker, or licensed securities professional what is happening without forcing that person to reconstruct the transaction from scattered emails.
Label the source and date for every important number. Contract price, selling expenses, original cost, capital improvements, depreciation, debt payoff, exchange expenses, replacement price, new financing, and cash outside the exchange can change at different points. Keep the earlier worksheet instead of overwriting it. A visible version history makes it easier to explain why projected gain, boot, required equity, or estimated tax changed between listing, contract, identification, and closing.
Maintain a short decision log beside the numbers. Record open title questions, taxpayer-identity issues, related-party facts, mixed personal and investment use, lender constraints, identification choices, backup properties, and unresolved tax-character questions. Assign each issue to the professional responsible for answering it and include a due date tied to the actual transaction calendar. That turns the calculator from an isolated estimate into a working exchange checklist.
Before closing, reconcile the latest worksheet to the draft settlement statement, loan documents, qualified-intermediary instructions, title vesting, and replacement-property contract. After closing, preserve the final calculation, signed agreements, identification notice, settlement statements, depreciation records, and professional advice with the tax file. Organized support does not guarantee exchange treatment, but it reduces avoidable confusion when the return is prepared or the transaction is later reviewed.
Checks before relying on the output
- Require a completed adjusted-basis input.
- Prevent recognized gain from exceeding realized gain.
- Warn when exchange expenses or liability entries are unclassified.
- Separate amount of gain from tax rate and tax character.
The implementation must be validated against Form 8824 examples and cannot estimate final tax without rate and character analysis.
Common questions
What is realized gain?
It is the economic gain calculated from amount realized, adjusted basis, and applicable exchange expenses before determining how much must be recognized currently.
What is deferred gain?
For the worksheet, it is realized gain not included in the estimated recognized amount. It is generally reflected in replacement-property basis rather than erased.
Does recognized gain equal the tax bill?
No. Tax depends on character, depreciation, holding period, federal and state rates, other income, and the filed return.
Why show a replacement-basis checkpoint?
Deferred gain affects basis in the replacement property. The checkpoint helps identify an input mismatch before the calculation is used for planning.
Can the result be used on Form 8824?
It can organize inputs, but the filed form and supporting schedules should be prepared or reviewed by the responsible tax professional.
