Inputs to organize
- Sale price
- Selling costs
- Debt payoff
- Cash received
- Replacement price
- Replacement debt
- Additional cash
What the calculator shows
- Net equity
- Value replacement comparison
- Debt comparison
- Potential cash or liability shortfall
How the worksheet moves from facts to an estimate
Estimate net exchange equity from sale price less debt payoff and eligible selling costs, while keeping non-exchange cash movements visible.
Compare total replacement-property value with the relinquished-property value entered by the user.
Compare exchange equity reinvested with estimated net exchange equity.
Compare liabilities relieved with replacement liabilities plus additional cash contributed where relevant.
Report shortfalls separately; do not combine value, equity, and debt differences into one unexplained number.
Test replacement value and exchange equity separately
Full-deferral planning usually examines whether replacement real estate is acquired at an equal or greater value and whether the available exchange equity is reinvested. Those are related but different tests. A replacement can satisfy the value target while leaving cash outside the exchange, or reinvest substantial equity while still falling short on value.
Enter the expected net relinquished value, debt payoff, and selling costs, then compare them with replacement price and replacement debt. Use realistic closing numbers. A target based only on the contract price can fail when credits, expenses, or financing change.
Understand how cash can replace reduced debt
The replacement loan does not always have to match the old loan dollar for dollar. Additional cash can offset a reduction in debt when the complete value and equity requirements are satisfied. The calculator therefore shows replacement equity instead of treating every debt decrease as automatic boot.
Cash contributed from outside the exchange should be identified separately from exchange proceeds. Confirm lender seasoning, reserve, and source-of-funds requirements early. A plan that depends on last-minute cash may not survive underwriting or the exchange deadline.
Use qualifying expenses carefully
Brokerage commissions and certain transaction costs may affect the amount that must be reinvested, but not every charge on a settlement statement receives identical treatment. Loan fees, tax prorations, rent adjustments, reserves, repairs, and operating items may need separate funding or classification. Model the conservative case until the tax adviser confirms the treatment.
Ask the qualified intermediary and closing agent to review the expected flow of funds before closing. The reinvestment worksheet should agree with their statements and the lender's sources-and-uses schedule.
Combine more than one replacement path
Replacement value and equity can be spread across multiple qualifying properties when the identification and closing requirements are met. A direct property, net-lease asset, or DST interest may play different roles in the same plan. The value, debt, timing, control, management, liquidity, and diligence burden should be compared across the complete allocation.
Do not use a passive option solely to fill a mathematical gap. Current availability, sponsor quality, fees, leverage, property risk, investor eligibility, and suitability still control the decision. Keep primary and backup candidates aligned with the same reinvestment target.
Stress-test the replacement budget
Run the worksheet with the expected sale price, a lower net-proceeds case, and a higher payoff or expense case. Then test the leading replacement property at its expected purchase price and a financing contingency. The gap between scenarios is the contingency the search and lender plan must absorb.
If the exchange is already under contract, share the range with the broker and qualified intermediary. Identification is more useful when each candidate has a realistic equity requirement and closing path rather than only an asking price.
Turn the target into closing instructions
Before replacement closing, reconcile the identified property, final price, credits, lender proceeds, exchange funds, outside cash, deposits, and reserves. Confirm the acquiring taxpayer and title structure. A calculator result that does not match the closing statement should be updated before funds are released.
Bring the sale and replacement statements, loan documents, intermediary ledger, and any proposed allocation to the calculation review. The objective is a clean value and equity bridge that every professional on the file can understand.
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 nonnegative sale, debt, and replacement amounts.
- Warn when selling costs exceed sale price.
- Warn when replacement debt and additional cash do not reconcile with purchase value and equity.
- Do not label a shortfall as taxable boot without the complete gain calculation.
The result is an educational transaction estimate and cannot determine recognized gain without complete tax facts.
Common questions
What does the estimator mean by exchange equity?
It is an organizing estimate of sale proceeds remaining after entered debt payoff and eligible costs. The qualified intermediary's actual balance and closing statements control.
Must replacement debt equal the old loan?
Debt is one part of the comparison. Additional cash may affect the liability analysis, but the complete transaction and gain calculation determine the tax result.
Can several purchases satisfy the replacement-value comparison?
Yes. The tool can aggregate multiple replacement properties while preserving each property's price, debt, equity, and closing status.
Why are value and equity shown separately?
A purchase can meet one comparison and miss another. Showing them separately prevents a large loan or cash contribution from concealing an unreinvested amount.
Is the shortfall the same as recognized gain?
No. It is a planning flag. Recognized gain depends on realized gain, money or other property received, liabilities, costs, basis, and other facts.
