Learn
A little clarity for your next decision.
Loading your learning library…
Investor WorkspaceWelcome, there!Log Out
Investor WorkspaceA little clarity for your next decision.
By Jerry Baker
A 1031 exchange plan needs to track the value of the property sold, the equity being reinvested, and the debt paid off. Reinvesting all the cash may still leave a shortfall if the replacement does not address the old debt. This guide shows how to build a clear funding worksheet and compare direct-property and DST allocations.
The cash held by your qualified intermediary is easy to see. It is also only part of the picture. A property sale may use a large share of the price to pay off a loan before the balance reaches the exchange account.
That loan payoff still matters. The exchange rules consider liabilities from which you are relieved, along with cash and other property received. New liabilities and added cash may offset debt relief under the applicable rules. [1] [2]
For planning, create columns for value, equity, and debt. Show the old property on one side and each proposed replacement on the other. Put costs and other adjustments on separate lines so nobody assumes that a rough subtotal is the final tax target.
I use this as a way to make the conversation clear. It is a planning worksheet, not a substitute for the CPA's Form 8824 calculation. The final result depends on the complete transaction.
Equity is the value left for the owner after debt, before or after costs depending on the context. Tax basis is a separate measure used to calculate gain. Basis may reflect the purchase cost, improvements, depreciation, and earlier transactions. [1]
Two owners can each have $600,000 of equity and very different taxable gains. One may have recently bought the property. The other may have owned it for decades and claimed depreciation. The cash balance alone cannot tell you the tax bill.
A loan payoff also does not become a deduction from gain simply because it reduces the cash you receive. Ask your CPA to calculate gain from the proper amount realized and adjusted basis. Keep that calculation separate from the cash available for the next investment.
Label numbers clearly. “Equity after estimated closing costs” is more useful than “net.” A single word such as net can mean different things to a lender, broker, QI, and tax preparer.
Begin with the contract price and the current loan payoff estimate. Then add the expected settlement charges, credits, and other adjustments. Ask the closing team when the payoff expires and whether daily interest changes the figure.
Have the CPA identify which expenses affect the exchange calculation. Some costs may qualify as exchange expenses, while other closing items have different treatment. Do not subtract every settlement charge from the tax replacement target just because it reduces available cash. [1]
For a simple example, assume a $2 million sale and $800,000 of debt, with no costs or other adjustments. The equity is $1.2 million. The basic funding plan needs to address both the $1.2 million of equity and the $800,000 of debt relief.
Keep an estimate column and a final column. Update the worksheet when the sale price, payoff, credit, or closing date changes. The difference between the two columns tells the team what needs a second look.
Using the same simplified sale, suppose the replacement costs $2 million. You use all $1.2 million of exchange equity and obtain $800,000 of replacement debt. The value, equity, and debt match in this basic illustration.
That does not prove that every tax requirement is met. The property must qualify, the taxpayer and structure must be appropriate, and the exchange must meet timing and receipt rules. Special recapture or other issues may also need review. [2] [3]
Think of the worksheet as one test within the larger process. Passing it is useful. It does not excuse a missed identification, an unsuitable investment, or incomplete loan documents.
The replacement loan also needs its own review. Compare payments, maturity, fixed or floating rates, reserves, and any guarantees. A tax match can coexist with financing terms you would prefer not to accept.
You do not always need to borrow the entire old loan amount again. Added cash can address debt relief in the basic exchange calculation. This gives you a way to use less debt if you have funds outside the exchange. [1]
Suppose you want only $500,000 of new debt on the $2 million replacement. You could use $1.2 million of exchange equity, $300,000 of personal cash, and the $500,000 loan. The total is still $2 million.
The reduction from $800,000 to $500,000 of debt is $300,000. The added cash covers that amount in this simplified example. If you instead wanted a debt-free purchase, you would need $800,000 of added cash under the same assumptions.
Then consider your remaining reserves. Reducing debt can lower one kind of risk while using cash that was available for emergencies. Compare the position after closing, including the funds you may need for living costs or other investments.
Assume you reinvest the $1.2 million of equity in a property worth $1.7 million with a $500,000 loan. You used all the visible cash, but the replacement value and new debt are each $300,000 below the old figures.
That difference can create taxable debt boot under the basic calculation. The recognized gain depends on actual gain, expenses, recapture, and other facts. The shortfall is not automatically the tax bill. [1] [2]
The owner has several possible choices: add cash to acquire enough value, consider different financing, choose another replacement, or knowingly accept a partial exchange. None should be chosen from a tax worksheet alone.
A smaller purchase may be the better investment even with a tax cost. Ask the CPA for the estimate, then compare it with the cost and risk of changing the plan. Full deferral should not force an investment that does not fit.
Buying more expensive property is not a complete full-deferral test. If you receive cash, a larger new loan does not simply cancel that cash in the exchange calculation. Cash received and liability offsets follow different rules. [2]
This can surprise an owner who trades up in price while keeping part of the sale proceeds. The new property may exceed the old value, yet the cash taken out can still cause recognized gain.
Show every expected payment to you on the worksheet. Include returned balances, credits, and planned withdrawals. Then ask the adviser to explain the cash side and debt side separately.
If you need money outside the exchange, plan for the tax and the release timing. A deliberate partial exchange can be easier to manage than trying to make an unsuitable loan solve two different problems.
Loan-to-value, or LTV, compares debt with value. If debt is $400,000 and the relevant value is $1 million, LTV is 40%. The denominator matters: an appraisal, purchase price, and investor offering value can differ.
For an exchange allocation, ask which value and debt amounts are credited to the investor. Do not automatically use a lender's ratio shown on a property brochure. Fees and the offering structure can change the relationship between investor cash and property value.
If the correct investor-level LTV is known, a simplified value calculation is equity divided by one minus LTV. Debt is then value minus equity. This works only when the equity, value, and debt are measured on the same basis and the other assumptions are appropriate.
For example, $300,000 of equity at 50% investor LTV represents $600,000 of value and $300,000 of debt. At 40% LTV, the same equity represents $500,000 of value and $200,000 of debt. The cash amount is identical; the replacement-value contribution is not.
A properly structured DST can be treated as holding qualifying real estate under the framework in Revenue Ruling 2004-86. Investors may receive a share of the property's debt for exchange purposes, subject to the structure and facts. The offering documents and tax analysis need to support the figures used. [4]
Request the written value and debt allocation for the amount you propose to invest. Check whether the quoted ratio uses the investor offering price. Confirm the minimum investment, capacity, acceptance steps, and funding date.
Do not assume all DST debt has identical terms. Read the loan documents and disclosures for maturity, payment obligations, reserves, and remedies. Nonrecourse financing does not remove the risk that a property loses value or cannot repay its loan.
A DST is also a private investment with limits on control and liquidity. Debt matching is one reason to consider an allocation, not a reason to skip the property and sponsor review. Private offerings can involve substantial losses and may be hard to sell. [5]
Suppose you divide $600,000 of equity among three hypothetical investments. Each receives $200,000. The first has 50% investor LTV, the second has 40%, and the third has no debt. Ignore fees and other adjustments for the illustration.
| Investment | Equity | Value | Debt | LTV |
|---|---|---|---|---|
| A | $200,000 | $400,000 | $200,000 | 50% |
| B | $200,000 | $333,333.33 | $133,333.33 | 40% |
| C | $200,000 | $200,000 | $0 | 0% |
| Total | $600,000 | $933,333.33 | $333,333.33 | 35.71% |
The portfolio LTV is total debt divided by total value: about $333,333.33 divided by $933,333.33, or 35.71%. It is not the simple average of 50%, 40%, and 0%, which would be 30%.
The difference occurs because equal equity checks do not create equal property values. The more leveraged investment represents more value for the same cash. Use the dollar totals before calculating the portfolio ratio.
If the sale-side target were $1 million of value and $400,000 of debt with $600,000 of equity, this portfolio would be short by about $66,666.67 under the simplified assumptions. The allocation would need review; a 35.71% ratio alone would not reveal the exact dollar gap.
A portfolio plan is only as reliable as its parts. Confirm that each offering is available and accepts the proposed amount. An allocation below the minimum or above remaining capacity may not be workable even when the spreadsheet balances.
Use clear labels for items still under review. A warning status is not necessarily a permanent rejection, but it should not be mistaken for final approval. Track what needs to be resolved and who will confirm it.
Then review identification. Several investments and multi-property offerings can affect the property count and applicable identification test. The QI should review the actual interests before the 45-day period ends. [3]
Do not fill a gap with an investment you do not understand. Consider a different allocation, more cash, different financing, or a planned taxable amount. The fact that a number fits is only one part of suitability.
A portfolio can satisfy an exchange target and still fall short of the cash flow you want. Estimate income separately. For each investment, show the cash allocated, the stated cash-flow assumption, and the source and date of that assumption.
If $200,000 is allocated to a hypothetical 5% annual cash-flow rate, the illustration is $10,000 a year. That does not establish a guaranteed payment or total return. Distributions can change, and property value can fall.
For a blended cash-flow rate, divide the sum of the illustrated annual cash payments by total equity. Do not use property value as the denominator if the rate is intended to describe cash flow on investor equity.
Keep the income calculation separate from portfolio LTV. One compares payments with equity. The other compares debt with value. Using the same label or denominator for both can produce a result that looks precise and means very little.
Ask what happens if income declines or expenses rise. Does cash still cover debt service? Are reserves available for repairs? When does the loan mature, and what assumptions support a sale or refinance by then?
A fixed interest rate can help with payment planning, but it does not guarantee a favorable exit or eliminate refinancing risk. A floating-rate loan needs its own review of caps, terms, and exposure. Read the specific documents rather than treating a label as a full risk assessment.
Also consider how a decline in value affects equity. If a hypothetical $1 million property has $500,000 of debt and falls to $900,000, equity falls from $500,000 to $400,000 before sale costs. A 10% property decline has produced a 20% equity decline in that simple example.
That is why I would not increase debt merely to maximize a replacement-value number. Leverage changes the range of outcomes. It should fit your ability and willingness to bear loss.
The usual delayed-exchange periods remain 45 days for identification and the earlier of 180 days or the relevant federal return due date, including extensions, for receipt. Both run from the transfer of the relinquished property. [3]
Work backward from those dates. Allow time for loan approval, title work, subscription review, document corrections, and wires. Confirm business-hour cutoffs and time zones. A theoretical ability to close is not the same as an accepted and funded purchase.
Keep a backup plan that you would actually accept. If one investment becomes unavailable, know which figures would change and whether another choice still meets the identification rules. Do not assume that any new name can be substituted after day 45.
Update the allocation sheet when the facts change. An old screenshot of a balanced plan should not become the basis for a final wire after capacity or debt figures have changed.
Give the CPA a clean set of final sale and purchase statements, loan amounts, investor allocations, exchange records, and any cash returned. Include the explanation for unusual credits or expenses. The preparer should not need to guess why the final amounts differ from the plan.
Ask for the recognized-gain, deferred-gain, and replacement-basis calculations to be kept with your records. Form 8824 is part of that reporting. If several properties are acquired, the allocation among them also needs to be clear. [2]
Save a plain-English summary of the final portfolio. List the cash invested, debt allocated, property value used, expected hold, and main risks. That helps you and your family understand the ownership after the exchange paperwork is finished.
The aim is not to make three columns match at any cost. It is to create a plan that meets the exchange rules while giving you a sensible mix of property, financing, cash flow, and access to money.
Keep enough precision in the working numbers. A ratio rounded for a brochure may be fine for a quick overview and too rough for a final allocation. Ask for the actual dollar figures or the precise investor ratio used by the offering.
For example, $300,000 of equity at exactly 50% LTV represents $600,000 of value and $300,000 of debt. At 49.5% LTV, it represents about $594,059.41 of value and $294,059.41 of debt. Rounding 49.5% to 50% would overstate both by about $5,940.59.
That difference may be important when the planned exchange has little room for error. It is also a reason to avoid copying a website display into final tax documents. Confirm whether the displayed percentage is rounded and whether fees or allocations have changed since it was posted.
Check units as well. If an offering sells interests in fixed increments, the desired dollar amount may need adjustment. Confirm the accepted amount before assuming all of the exchange cash will be used. The same applies to minimums and the capacity still open for investment.
On the final worksheet, preserve the underlying amounts and show rounded totals only for readability. Then reconcile those amounts to the signed subscription, closing confirmation, and tax allocation. Small differences are easier to resolve before funds move than after everyone has filed a different version of the numbers.
Not always. Debt relief and total replacement value also matter, along with expenses and other tax rules. A plan can use every dollar of equity and still leave a debt-related shortfall. Have the CPA review the complete exchange calculation. [1]
No. Added cash can address a reduction in debt in the basic exchange calculation. You must still acquire sufficient qualifying value and meet the other rules. Review how much cash remains available after choosing the lower-debt option. [1]
A simple average can be misleading. Calculate each investment's debt and value using consistent investor-level figures, then divide total debt by total value. Equal equity allocations do not necessarily represent equal property values.
Not automatically. Cash received and liability offsets are handled separately under Form 8824. A larger purchase or loan does not by itself remove cash boot. Ask the CPA to show both calculations. [2]
Use the written debt and replacement-value allocation applicable to your investment, as confirmed by the offering and your tax advisers. Check whether the quoted ratio uses investor offering value, purchase price, or appraised value. They may differ.
No. Property debt can affect distributions, equity value, and the timing or result of a sale. Limited personal liability does not mean the investment cannot lose money. Review the actual financing and private-offering risks. [4] [5]
Ask the advisers to quantify the shortfall and resulting tax, if any. Then compare changes to the allocation, added cash, financing, or a deliberate partial exchange. Do not accept a weak investment just to make a small difference disappear.
Educational information, not an offer or a personal tax, legal, or investment recommendation. Examples are hypothetical and omit stated adjustments. Tax treatment depends on your facts and current law. Review your transaction with your CPA, attorney, and qualified intermediary. Real estate investments can lose value and may be illiquid.
Enter your approved email to explore investments, save your shortlist, and keep learning.