How to Read a Non-Performing Mortgage Loan Data Tape

The Data Tape Is Where Every Deal Starts

In the secondary mortgage market, the data tape is the document a seller provides to prospective buyers listing every loan available for purchase along with its loan-level details. The name dates back to when this information was literally encoded on magnetic tape. Today it arrives as an Excel spreadsheet — but the term stuck.

There is no industry standard format. Every seller uses their own column headers, abbreviations, and internal asset codes. A top-20 bank selling non-performing loans as a loss mitigation exercise produces a very different tape than a secondary market intermediary, and both look nothing like a retail marketplace listing. Understanding what to look for — and what to do when information is missing — is fundamental to the due diligence process.

This guide classifies data tape columns into two tiers: need-to-have fields required for pricing and nice-to-have fields that accelerate research but can be gathered independently. It then compares three real tape formats so you can recognize the patterns regardless of the source.

Need-to-Have Fields

These are the columns without which you cannot price a loan or proceed with due diligence. If any of these are missing from a tape, you either need to request the data from the seller or gather it yourself before submitting an offer.

If you receive a tape with all seven of these fields populated, you have enough to begin preliminary pricing. Everything else either accelerates the process or refines your numbers.

Nice-to-Have Fields

These fields save you research time and money, but you can obtain them independently through your own vendor relationships and tools if the seller does not provide them.

Comparing Three Real Tape Formats

Not all tapes are created equal. The amount and quality of data you receive depends entirely on who is selling and why. Here is what to expect from three common seller types.

The Bank Tape

When a large bank sells non-performing loans, it is typically executing a loss mitigation strategy — not running a loan sales business. The tape you receive is often a raw export from the bank's internal loan management platform, full of internal codes and abbreviations that mean nothing to an outside buyer.

What you will see:

• Internal fields like "investor ID" or "LOB" (line of business) that serve the bank's organization but provide no value to a buyer
• Codes from third-party scrub services (e.g., "PROLI results") indicating whether a loan passed a secured-status check — useful data buried under an opaque label
• The UPB labeled in non-standard ways. A common example: a tape of second liens where the bank labels the column "First Principal Balance" because that is how their system categorizes all loans. Without talking to the seller, you might misinterpret the lien position.
• Annual interest rates with some zeros — usually indicating adjustable-rate loans where the current rate is not populated
• Charge-off balances and dates showing when the bank wrote the loan off its books
• Borrower names crammed into a single field — requiring you to split first, middle, and last names before uploading to credit bureaus or vendor platforms
• Scattered occupancy data, undated FICO scores, and internal status codes you will need the bank to define

What you will not see: property values, BPO data, senior lien balances, tax balances, or clean vendor-ready borrower data.

Key takeaway: Bank tapes require the most cleanup. Ask the bank for a data dictionary — many provide one as a second tab in the spreadsheet. But pick your questions carefully: sellers at large institutions appreciate buyers who figure out the obvious on their own and only escalate genuine ambiguities.

The Secondary Market Tape

When a secondary market participant — a fund, aggregator, or experienced trader — sells loans, the tape is typically far more polished. These sellers know what buyers need because they have been buyers themselves. The data is cleaner, more complete, and often segmented into logical subsets.

What you will see:

• Multiple loan identifiers (asset ID, bank loan number, servicer loan number) for cross-referencing
• Color-coded or segmented portfolios — junior liens separated from senior liens, each labeled as a distinct pool
• Updated credit data with dates, so you know how fresh the FICO scores are
• Senior lien status (current, 30-day late, 120-day late, unknown) — critical for pricing junior liens
• Both the principal balance and the payoff balance (UPB plus accumulated arrears)
• Fair market value from at least one source, sometimes supplemented by a Zestimate and a rent estimate for REO exit modeling
• Borrower names already split into first, middle, and last — vendor-ready
• Borrower mailing address in addition to the property address
• Tax balance with links to county tax records
• Full origination details: date, amount, first payment date, interest rate, monthly payment, maturity date, and original term
• Charge-off amount, last payment date, next due date, and charge-off date

What you will not see (but should still verify): Even the cleanest secondary market tape comes with a disclaimer: "Information deemed accurate but not guaranteed." Trust the data as a starting point, but verify every material figure before you fund.

Key takeaway: Secondary market tapes are designed to close deals faster. Your job shifts from data gathering to data verification — confirming that the BPO is recent, the credit data is current, the tax balance has not grown, and the senior lien status has not changed since the tape was generated.

The Retail Marketplace Listing

Platforms that sell individual loans present data in a completely different format — a single-screen summary rather than a spreadsheet row. Instead of scrolling through columns, you see a card with all the relevant fields for one asset.

What you will see:

• Performance status (non-performing), lien position, and UPB prominently displayed
• A narrative blurb describing the asset's situation — borrower history, notable circumstances, and seller context
• LTV already calculated for you
• Payment history showing whether the loan was ever performing and when it stopped
• Total payoff amount (UPB plus arrears), showing the gap between the principal balance and what the borrower actually owes
• Monthly payment amount and remaining payment count, so you can see the full amortization picture
• Maturity date, origination date, and interest rate

What you will not see:

• Bulk data. These are one-off listings, not spreadsheets. If you are buying volume, this format does not scale.

Key takeaway: Retail listings are the most accessible entry point for newer investors. The data is curated, the format is readable, and you can evaluate one deal at a time. But pay attention to pricing guidance — individual sellers sometimes anchor to their original purchase price rather than current market value, especially if they bought the loan as a performer and it has since defaulted. The markup on convenience is real.

Red Flags to Watch for on Any Tape

Regardless of the tape format, certain patterns should trigger deeper investigation or outright skepticism. Flag these before you spend money on due diligence.

Building Your Analysis Workflow

Reading the tape is step one. Turning it into actionable pricing requires a systematic workflow that layers additional data on top of what the seller provides.

1. Confirm the need-to-have fields. Verify that every loan has a loan number, lien position, borrower name, UPB, property address, last payment date, and payment terms. Flag gaps immediately.
2. Classify each loan. Sort by lien position. First liens and second liens require different pricing frameworks. If the tape contains both, split them into separate working tabs.
3. Calculate equity coverage. For first liens, subtract property taxes from the fair market value. For second liens, subtract the senior lien payoff balance and taxes from FMV. The remainder is what secures your position.
4. Assess statute of limitations risk. Using the last payment date and the property state, determine whether each loan is within the statute of limitations for collections.
5. Flag red-flag loans. Apply the red flag checklist above. Some loans will be eliminated; others will need additional research that factors into your pricing.
6. Enrich missing data. Determine which nice-to-have fields you need before submitting your initial offer versus which can wait until the exclusive due diligence period after your letter of intent is accepted.
7. Price and submit. Apply your preferred valuation methodology — bucket pricing, outcome-based pricing, or a hybrid approach. For detailed pricing methods, see How to Value NPLs to Make an Offer.

What the Tape Does Not Tell You

No matter how complete a data tape appears, certain critical factors never show up in a spreadsheet:

• The borrower's current situation. A tape says the loan is non-performing. It does not say why. The answers come from direct outreach through your loan servicer, not from a column header.
• Title condition. A secured status scrub is not the same as clean title. Intervening liens, judgments, or a broken chain of title only surface in a full title search or O&E report.
• Property condition. You will see an address and maybe a property type. You will not see whether the roof leaks or the property has been stripped. Physical condition directly impacts collateral value and your exit strategy.
• Local market dynamics. A property value on a tape is a snapshot. It does not tell you whether the market is appreciating or declining.

The tape gives you enough to decide whether a loan is worth investigating. It does not give you enough to fund a purchase.

Key Takeaways

The data tape is a starting point, not a finish line. Treat it as the first filter in a multi-stage due diligence process:

• Demand the seven need-to-have fields before spending time or money on analysis. Without a loan number, lien position, borrower name, UPB, property address, last payment date, and payment terms, you do not have enough to work with.
• Expect variation. Bank tapes are raw and coded. Secondary market tapes are enriched and segmented. Retail listings are curated but limited. Adjust your workflow to the format.
• Use red flags as filters, not deal-killers. A missing field does not automatically disqualify a loan — but it changes your pricing and risk assessment.
• Verify everything. The best tapes still carry a disclaimer that the data is not guaranteed. Your independent due diligence is what protects your capital.