Commercial Property Sale and Depreciation Recapture Calculator for Texas Owners

The number on a commercial property offer is not the same as the owner’s cash after closing. Selling costs, debt payoff, adjusted tax basis, accumulated depreciation, class-level allocation, gain character, potential depreciation recapture, entity facts, and transaction structure can materially change the result.

Those issues are easiest to address before a purchase and sale agreement locks in price allocation, timing, or closing terms. The 7 Streams Property Sale and Depreciation Recapture Planning Calculator helps an owner assemble the right facts, estimate a planning range, and see which questions should be resolved before execution.

The workbook is not a tax return calculator and does not determine the tax treatment of a sale. It is an owner decision tool. Its purpose is to make the next conversation with your real estate, tax, and legal advisors more productive.

Download the 7 Streams Property Sale and Depreciation Recapture Planning Calculator. The Excel workbook includes protected formulas, class-level basis and sale allocation, gain-category screening, after-tax proceeds, sale-price scenarios, owner readiness gates, and formula checks.

Why sale price alone is a poor decision metric

Owners often begin with a simple equation: sale price less debt equals cash. That shortcut omits several major items.

The calculator separates:

• gross sale price;
• selling costs;
• net amount realized for the simplified model;
• debt payoff at closing;
• adjusted tax basis by property class;
• class-level gain or loss;
• potential section 1245 ordinary-income recapture;
• potential unrecaptured section 1250 gain;
• residual section 1231 or capital gain;
• owner-entered effective tax rates;
• estimated after-tax net proceeds.

The distinction between taxable gain and closing cash is especially important. Debt payoff reduces cash available to the owner, but it generally does not simply reduce taxable gain in the way many first-time sellers expect. Transaction-specific debt relief and entity rules require professional review.

What depreciation recapture means for a commercial property owner

Depreciation reduces adjusted basis over the ownership period. When depreciated property is sold at a gain, federal rules may characterize part of that gain differently from the remaining gain.

A commercial property can contain more than one tax asset. Land, shorter-life personal property, land improvements, and long-life building components may have different adjusted bases and different gain-character rules. The IRS notes that when multiple assets are sold in one transaction, gain generally must be determined separately by allocating the selling price among the assets.

This is one reason an old cost segregation study can become important during a sale. The study may have accelerated depreciation into shorter-life classes, and the disposition analysis needs a reliable class-level ledger and a supportable sale allocation. The original study benefit should not be evaluated separately from the future sale consequences.

What the calculator does

Organizes transaction inputs

The owner enters proposed sale price, selling costs, debt payoff, holding-period assumption, a planning structure label, and effective rate assumptions.

Reconstructs class-level adjusted basis

For land, 5-year property, 7-year property, 15-year property, and the 39-year building, the owner enters original tax basis and accumulated depreciation. The workbook calculates adjusted basis.

Allocates net proceeds

The owner enters a supportable sale allocation percentage for each class. The workbook verifies that the percentages total 100 percent and calculates allocated proceeds and gain or loss by class.

Screens possible gain categories

The model estimates potential section 1245 ordinary recapture for shorter-life property, potential unrecaptured section 1250 gain for the building, and a residual category. These are preliminary planning categories, not a return position.

Estimates tax and after-tax cash

Owner-entered effective rates are applied to the preliminary categories. The model then bridges gross price to estimated after-tax net proceeds after selling costs, debt payoff, and the planning tax estimate.

Compares sale-price scenarios

The workbook shows downside, base, and upside price cases so the owner can see whether a higher price produces the expected increase in after-tax proceeds.

Screens structure questions

Simple 1031 exchange and installment-sale rows help the owner identify questions. They do not qualify, implement, or recommend a structure.

Records to collect before using the calculator

The quality of the output depends on the owner records. Gather:

• original closing statement and purchase agreement;
• original appraisal and any purchase-price allocation;
• fixed-asset ledger;
• depreciation schedules and prior returns;
• cost segregation study and implementation records;
• capital improvement and renovation ledgers;
• records of partial dispositions, insurance events, or casualty adjustments;
• tenant improvement ownership records;
• debt payoff or defeasance estimate;
• proposed letter of intent or purchase and sale agreement;
• broker opinion of value or pricing analysis;
• current title, survey, and material closing-cost estimates;
• any exchange or installment-sale planning already discussed.

If these records do not reconcile, that is a useful finding. The owner should resolve the gap before relying on a net-proceeds estimate.

Adjusted basis: the number owners should not guess

Adjusted basis is not necessarily the original purchase price minus a rough depreciation estimate. It may reflect land, capitalized acquisition costs, improvements, cost segregation, depreciation allowed or allowable, partial dispositions, credits, casualty items, and other adjustments.

The workbook lets the owner enter original basis and accumulated depreciation by class because class-level analysis may matter. Those inputs should come from the actual ledger and tax records. A tax advisor should reconcile them before contract allocations or final tax estimates are approved.

Sale allocation: why the percentages matter

When a transaction includes multiple assets, the sale price must be allocated. An allocation based only on original cost may not reflect relative fair value at sale. An appraisal, negotiated contract schedule, or other support may be needed.

The allocation can change how much gain appears in each class and therefore how the preliminary recapture categories look. Owners should address allocation early enough for real estate, valuation, tax, and legal advice to inform the agreement.

Questions to ask include:

• Does the draft agreement allocate value among land, building, and personal property?
• Is the allocation consistent with appraisal evidence and the buyer’s expected treatment?
• Does a prior cost segregation study identify assets that still exist?
• Were any shorter-life assets removed, replaced, or previously disposed of?
• Will the buyer and seller report consistently where required?
• Which allocation decisions must be made before signing rather than at tax-return time?

How the calculator screens depreciation recapture

For the shorter-life categories, the workbook caps potential section 1245 ordinary recapture at the lesser of class gain or accumulated depreciation. For the 39-year building, it uses a simplified proxy for potential unrecaptured section 1250 gain and assigns remaining positive gain to a residual section 1231 or capital category.

The model intentionally does not resolve every rule. It does not determine section 1250 additional depreciation, section 1231 netting or five-year lookback, partnership hot-asset consequences, suspended passive losses, related-party issues, state residence effects, net investment income tax, or entity-specific reporting.

A simple model is still valuable if the owner uses it correctly. It reveals which inputs drive the range and where a professional answer is needed.

How cost segregation can affect the sale analysis

A cost segregation study can accelerate deductions during ownership, but shorter-life property may create potential section 1245 recapture when sold at a gain. This does not automatically mean the study was a poor decision. The complete evaluation should consider:

• the timing and usability of accelerated deductions;
• the owner’s rates when deductions were taken;
• the owner’s rates at sale;
• present value during the holding period;
• the actual sale allocation and gain by class;
• whether assets were disposed of before sale;
• transaction structure and timing;
• the study and implementation cost.

Use the companion Cost Segregation Savings Estimator to review the ownership-period timing benefit and this calculator to screen the disposition side.

Taxable sale, 1031 exchange, installment sale, or hold

The right transaction path cannot be selected from a spreadsheet. Each option has business, timing, control, financing, market, and tax tradeoffs.

Taxable sale

A taxable sale may provide clean liquidity and flexibility, but the owner should understand the estimated tax and cash bridge before setting a minimum acceptable price.

Like-kind exchange screening

Section 1031 generally applies to qualifying exchanges of real property held for business or investment, subject to detailed taxpayer, property, timing, identification, intermediary, debt, boot, related-party, and structure rules. Cost segregated personal property may require separate analysis. Engage qualified exchange and tax advisors before the transaction is committed.

Installment sale screening

An installment arrangement may spread recognition of some gain, but depreciation recapture can have different timing. The IRS explains that depreciation recapture under sections 1245 or 1250 is generally reported in the year of sale even when the installment method applies. Credit risk, security, interest, related-party rules, and section 453A may also matter.

Hold or refinance

Holding or refinancing avoids a current sale in the simplified model but introduces financing terms, market risk, operating risk, and debt tax issues not modeled here. Compare business economics, not only taxes.

How to use the workbook before a sale

Step 1: Build the base case

Use the most supportable current price and closing-cost information. Do not reduce taxable gain by debt payoff. Enter debt separately in the proceeds bridge.

Step 2: Reconcile basis and depreciation

Enter class-level amounts from owner records. If the total does not match the fixed-asset and tax schedules, stop and resolve the discrepancy.

Step 3: Enter a provisional sale allocation

Use the best available evidence, then mark the allocation as pending until the appropriate advisors review it.

Step 4: Obtain planning tax rates

Ask for owner-specific rates or a range. Avoid using published maximums as if they were a personalized estimate.

Step 5: Review the after-tax proceeds bridge

Compare gross price, selling costs, debt, estimated tax, and net proceeds. This can inform pricing thresholds and negotiation strategy.

Step 6: Test downside and upside cases

If a small price change materially changes owner proceeds or tax reserves, the owner may need a tighter minimum price or a different transaction timeline.

Step 7: Resolve readiness gates

The dashboard identifies missing owner records, allocation status, holding-period assumptions, rate questions, structure questions, and Texas entity issues. Clear these gates before relying on the estimate.

Texas considerations for a commercial property sale

Texas does not impose an individual state income tax, but that fact alone does not answer the state and entity analysis. The ownership entity, owners’ residences, Texas franchise tax, multistate activity, local property tax, and transaction-specific reporting can still matter.

Closing practices, title costs, transfer-related charges, tax prorations, municipal requirements, and property records vary across Texas. Use transaction-specific estimates from the applicable market and verify local requirements rather than applying an Austin, Dallas-Fort Worth, Houston, or San Antonio assumption to every property.

Common owner mistakes

Subtracting debt from gain

Debt payoff affects cash. It does not generally function as a simple deduction from taxable gain.

Using original cost as adjusted basis

Depreciation and other adjustments can materially reduce basis.

Ignoring the old cost segregation study

Class-level basis and depreciation may be critical to the sale analysis.

Waiting until after the contract to discuss structure

Exchange, installment, allocation, and closing-timeline issues may require action before signing or before specific deadlines begin.

Using one tax rate for every category

Potential ordinary recapture, unrecaptured section 1250 gain, residual gain, and owner-level taxes may not share one effective rate.

Treating the spreadsheet as a return calculation

The workbook is a preliminary planning screen. It cannot determine the owner’s final tax character or reporting.

Plan the sale around owner outcomes

Download the calculator and use it before the proposed transaction becomes difficult to change. A completed workbook can help you define a minimum acceptable net result, identify missing records, ask better allocation and structure questions, and coordinate your commercial real estate strategy with qualified tax and legal advice.

7 Streams Commercial Group www.7s.life info@7s.life 512-655-3754

Editorial source notes

• IRS Publication 544, Sales and Other Dispositions of Assets
• IRS Instructions for Form 4797
• IRS Publication 946, How To Depreciate Property
• IRS Instructions for Form 8824
• IRS Like-Kind Exchanges: Real Estate Tax Tips
• Texas Comptroller Franchise Tax Overview

Internal linking recommendations

• Link to the Commercial Cost Segregation Savings Estimator.
• Link to the Cost Segregation Owner Guide.
• Link to the Commercial Property Basis Worksheet.
• Link to the 1031 exchange planning resource, if included in the library.
• Link to a 7 Streams seller representation or investment disposition advisory page.