Articles

How do you calculate a discounted payoff price on a defaulted loan?

The enforcement recovery a discounted payoff has to beat, built from forced-sale discount, costs, time and income, and the grid that sets the negotiating range.

The lowest discounted payoff a lender should accept is the present value of what enforcement would actually recover: the forced-sale price less costs, plus the net income collected along the way, discounted over the enforcement timetable. On an illustrative €40.0M loan secured on a building worth €34.0M, that is €26,062,214, or 65.2 cents on the euro. Adding up the same recoveries without discounting gives 73.9 cents, and quoting market value gives 85.0.

Worked in full in The Real Estate Workout by Julian R. Sterling, with every figure reproduced in a free workbook.See the book on Amazon →

The case

An office loan of €40.0M is in payment default. The building is valued at €34.0M. The borrower proposes a discounted payoff funded by a new loan and fresh equity, and the lender's workout team needs the price at which accepting it is no worse than enforcing. All figures are illustrative, and the enforcement assumptions are for one jurisdiction and one asset; they are the inputs to argue about.

Inputs
InputValue
Outstanding loan€40,000,000
Market value today€34,000,000
Forced-sale discount to market value15%
Time from default to sale proceeds18 months
Legal, receiver and sale costs4% of sale price
Net income collected by the receiver€1,200,000 a year
Lender's discount rate9%

The calculation, step by step

Sale proceeds. A sale out of enforcement achieves €34.0M less 15 per cent, €28,900,000. Costs of 4 per cent take €1,156,000, leaving €27,744,000 at month 18.

Income meanwhile. The receiver collects €1,200,000 a year of net income, €1,800,000 over 18 months, paid monthly to the lender.

Discount both. At 9 per cent a year, compounded monthly, the 18-month discount factor is 0.8787. The sale proceeds are worth €24,379,755 today and the income stream €1,682,459.

DPO floor = Net sale / (1 + r)T + PV(net income over T)

= 24,379,755 + 1,682,459 = €26,062,214 = 65.2 cents

Excel: =27744000/(1+9%)^(18/12)+PV((1+9%)^(1/12)-1,18,-100000)

Any payoff above €26,062,214 leaves the lender better off than enforcing; any below it, worse. The lender's loss against par is €13,937,786 either way. A DPO does not create that loss, it crystallises it.

Where the value goes

From market value to the enforcement recovery, €
StepAmount
Market value34,000,000
Forced-sale discount−5,100,000
Enforcement and sale costs−1,156,000
Eighteen months of discounting−3,364,245
Net income collected, present value1,682,459
Present value of enforcement26,062,214

The forced-sale discount is the largest single item, but time costs more than twice the legal and sale fees. Undiscounted, the recovery would be €29,544,000, 73.9 cents, and a lender who used that number would reject offers in the high 60s that are in fact better than enforcing.

The borrower's side explains why it is offering. At 60 per cent loan to value the building supports a new loan of €20,400,000, so the payoff at the lender's floor needs €5,662,214 of new equity, and the sponsor ends up holding a building worth €7,937,786 more than the price it paid to settle the loan, instead of losing it.

What if the assumptions change?

The two assumptions that carry the answer are the forced-sale discount and the enforcement timetable, and neither can be observed in advance. A grid replaces the argument about one base case with a range:

Indifference price, cents on the euro, by forced-sale discount and months to proceeds
Forced-sale discount12 months18 months24 months36 months
10%70.268.767.364.6
15%66.565.263.961.5
20%62.861.660.458.3
30%55.354.453.652.0

Five points of forced-sale discount move the price by about 3.6 cents; six extra months move it by about 1.3. The discount rate matters less than people expect: 67.9 cents at 6 per cent, 62.6 cents at 12 per cent. In negotiation that means the lender should spend its effort on evidence for the forced-sale discount, and the borrower on evidence that enforcement would be slow. The timetable matters less here partly because the receiver collects €1,200,000 a year, which offsets part of the cost of waiting; on a building that costs money to hold, delay becomes the larger lever, as what a month of delay costs in an enforcement shows on a loan where holding the building has a carrying cost.

Three offers against the 65.2 cent floor, €
OfferPaymentGain or loss against enforcing
60 cents24,000,000−2,062,214
65 cents26,000,000−62,214
70 cents28,000,0001,937,786

The common mistake

The most common mistake is anchoring on market value. A loan that is 85.0 cents covered by valuation is not 85.0 cents recoverable, and a credit committee that sees "offer at 70 against value at 85" will refuse a deal that beats its own alternative by almost €2.0M. The second mistake is comparing a DPO paid today with enforcement proceeds that arrive in 18 months without discounting them. The third is forgetting the cap: a lender cannot recover more than it is owed, so on a well-covered loan the enforcement value is capped at par, and the rest belongs to the borrower. The DPO is one of four exits from a broken loan; the restructuring alternative is in how to size the A note in an A/B note split.

Takeaway

The book prices four ways out of one broken loan, each discounted to today over its own timetable, and the free workbook for this case computes the payoff price that matches enforcement and how it moves with the forced-sale discount.

Questions readers ask

What is a discounted payoff in commercial real estate?

A discounted payoff (DPO) is an agreement under which the lender accepts less than the outstanding balance in full settlement of a loan, usually funded by a refinancing or a sale. The lender accepts it when the payment exceeds the present value of enforcement. Here that threshold is €26,062,214 on a €40.0M loan, 65.2 cents.

Why would a lender accept less than the property's market value?

Because the lender cannot realise market value. Enforcement brings a forced-sale discount, legal and sale costs and a delay that has to be discounted. On a building worth €34.0M, 85.0 cents of the loan, those three take the lender's realistic recovery down to 65.2 cents, so a payoff below market value can still be the better outcome.

How does a borrower fund a discounted payoff?

Usually with new senior debt plus fresh equity. At 60 per cent loan to value on €34.0M the new loan is €20,400,000, so a payoff of €26,062,214 needs €5,662,214 of equity. The borrower then keeps a building worth €7,937,786 more than the payoff price, which is why sponsors pursue DPOs.

Read the whole case

This article is one calculation from The Real Estate Workout. The book takes the same case from first principles to the decision, chapter by chapter, and every figure it prints is a live formula in the free companion workbooks.

Get the book on Amazon →Free companion files

Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada

Also on this site

Reading guide: real estate investing, finance and fund management → · All 453 articles →

If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.