The Art of Calculating the Purchase Price in NPL

In the secondary debt market in Spain, success is not determined during the recovery phase, but at the time of purchase . Acquiring a Non-Performing Loan (NPL) requires a precise balance between two fundamental metrics: the LTV (Loan-to-Value) and the Haircut .

Below, we break down how to use these indicators to protect your profitability.

1. The LTV (Loan-to-Value): The Safety Net

LTV relates the loan amount to the market value of the asset that guarantees it (the collateral).At NPL, we don't look at the LTV at the time of concession, but at the current LTV .

$$LTV_{actual} = \frac{\text{Outstanding Debt (Principal + Interest)}}{\text{Current Market Value (CMV)}} \times 100$$

Why LTV is misleading in NPL

A 100% LTV on a non-performing loan is a red flag. For a distressed debt investor, the goal is for the Entry LTV (purchase LTV) to be low enough to absorb:

• Legal and management expenses.
• Maintenance and community costs (property tax, outstanding fees).
• The time factor (the opportunity cost of capital).

2. The Haircut: Your Margin of Maneuver

A debt reduction is the discount applied to the face value of the debt . In Spain, depending on whether the loan is secured (with real estate collateral) or unsecured (without collateral), debt reductions can range from 30% to 90% .

To ensure profitability, the write-off must cover the risk that the collateral depreciates or that the legal process takes longer than expected (current average in Spain: 18-36 months).

3. Roadmap: Calculating the Bid Price

To arrive at the ideal purchase price, we don't subtract a random percentage. We follow an inverted discounted cash flow model :

Step A: Determine the Net Liquidation Value (NLV)

Calculate how much "clean" money you would get if you sold the property today after a foreclosure.

1. Quick Sale Value (VVR): It is usually 15-20% lower than the market value.
2. Acquisition and Sale Expenses: (ITP, notary, registration, real estate commission).
3. Possession expenses: Unpaid property tax, community fees, insurance.

Step B: Apply the Discount Rate (Target IRR)

If you expect the process to take 2 years and are looking for an annual return (IRR) of 15%, you must discount those cash flows.

The Simplified Purchase Price Formula:

$$Price = \frac{VNL}{(1 + r)^n}$$

Where r is your desired return and n is the estimated number of years for recovery.

4. Corrective Factors in the Spanish Market

Not all 60% LTVs are created equal. In your analysis, you must apply penalties based on:

• Occupancy Status: An asset with "squatters" or rent-controlled tenants requires an additional reduction of between 20% and 40% on the value of the collateral.
• Location: In Madrid or Barcelona, ​​liquidity is high (lower risk, lower haircut). In rural areas, the risk of illiquidity requires a much larger discount.
• Priority Charges: In Spain, community fees and property tax (IBI) from current and previous years take precedence over the mortgage. Always subtract these from the asking price.

Conclusion

Calculating the purchase price of an NPL isn't just about applying a discount to the principal. It's a forecasting exercise where the LTV tells you how much risk you're taking and the haircut defines how much money you'll make.Profitability is ensured when the purchase price allows for a profitable exit even in the worst legal scenario.