EveryCalc

Finance category

Mortgage, loan, investing, tax, and money calculators.

Browse finance

Loan Sale Execution Gap Calculator

Loan sales often leave a writeoff gap.

$
$
$
%

Writeoff vs book

$499,500

Net proceeds

$1,600,500

Recovery % of UPB

0.5%

How the math works

Net = sale − broker fee. Writeoff = book − net (if positive). Recovery = net / UPB.

$1.65M × 97% = $1.6M net. $2.1M book − $1.6M = $500k writeoff. 53% UPB recovery — typical NPL execution.

How to Use

  1. Enter UPB.
  2. Enter book value.
  3. Enter sale price.
  4. Enter broker fee %.
  5. Read sale gap and writeoff.

Frequently Asked Questions

Why sell NPL?

Capital recovery. Balance sheet clean-up. Avoiding servicing cost. Regulatory ratios (non-accrual limits). Focus on new origination. Banks regularly sell non-core or troubled portfolios to specialized NPL buyers.

Typical executions?

Residential 1st-lien NPL: 50-65% of UPB. Commercial small-balance NPL: 40-55%. Specialty finance NPL: 30-45%. Junior NPL: 15-30%. Sale usually 5-15% below book (which was likely already reserved).

Process?

Broker engaged. Loan file prep (2-4 weeks). Due diligence period (2-3 weeks). Bids received. Best/final and award. Closing 30-60 days. Discount requires buyer rebates for file defects, missing docs, etc. Seller often funds reserve account.

When does a lender negotiate vs foreclose?

Lenders calculate their net recovery from foreclosure (asset value minus legal, time, and sale costs) and compare to any workout proposal. If your offer nets the lender more than foreclosure, and you present it with clear sources of capital, most lenders will engage. Bring a credible sponsor, documented sources, and a timeline — vague asks get declined. Build the relationship before distress, not after.

Related Calculators

More Finance Calculators

Browse all finance

Keep exploring

Next steps in Finance

View finance hub →