Resources / Glossary / Data tape

Data tape.

Aka. Loan tape · portfolio tape · the tape

What is a data tape?

A data tape is a single, granular data file in which every individual asset in a portfolio occupies one row, with columns capturing the attributes a buyer needs to value it. In a loan portfolio sale, each row is a loan — its balance, rate, term, borrower characteristics, payment history, and delinquency status. In other contexts the rows might be individual accounts, leases, or customers.

The name is a holdover from when such data was delivered on magnetic tape. Today it is a spreadsheet or database extract, but the concept is unchanged: the tape is the loan-level or account-level ground truth, the raw material a buyer's analysts build their valuation model on.

Where summary financials tell a buyer what a portfolio earns in aggregate, the data tape lets the buyer interrogate it at the individual-asset level — stratifying by risk, vintage, geography, or any other dimension to find the concentrations and the soft spots the averages hide.

How a data tape is used

For any portfolio transaction — loan books, lease portfolios, receivables, or large customer bases — the tape is the central analytical artifact.

  1. Delivery. The seller provides the tape, ideally with a data dictionary defining every field, so the buyer can interpret each column correctly.
  2. Cleaning. The buyer validates the file — checking for missing values, duplicate rows, and fields that don't reconcile to the reported totals.
  3. Stratification. The buyer slices the portfolio by vintage, credit grade, geography, balance band, and delinquency to understand its composition and concentrations.
  4. Modeling. Cash flows, loss assumptions, and pricing are built bottom-up from the tape, then aggregated to a portfolio value and bid.

The integrity of the tape is everything. A tape with inconsistent definitions, stale fields, or rows that don't sum to the reported totals forces the buyer to discount for uncertainty — or to widen the price to cover the risk that the data is hiding something.

Frequently asked.

5 questions
01 What's the difference between a data tape and financial statements?

Financial statements present a portfolio in aggregate — total balances, total income, total reserves. A data tape presents it at the individual-asset level, one row per loan or account, with the granular attributes behind those totals.

The two should reconcile: the tape's rows, summed, should match the reported figures. The tape's value is that it lets a buyer go beneath the averages to see concentrations, vintages, and risk distributions that aggregate statements conceal, which is essential for pricing a portfolio accurately.

02 Why is data tape quality so important?

Because the buyer's entire valuation is built bottom-up from the tape. If fields are inconsistently defined, values are missing, or the rows don't reconcile to reported totals, the model rests on a shaky foundation and the buyer must either discount the price for the uncertainty or walk away.

A clean, well-documented tape with a clear data dictionary signals a well-run seller and supports a tighter, more confident bid. A messy tape introduces risk that almost always costs the seller in price.

03 What does a buyer do with a data tape?

The buyer cleans and validates it, then stratifies the portfolio along every dimension that matters — vintage, credit grade, geography, balance size, delinquency — to understand its composition and concentrations. From there it builds a cash-flow and loss model at the asset level and rolls it up to a portfolio value.

This bottom-up approach is what lets the buyer price risk precisely rather than relying on the seller's blended averages. The tape is the input to nearly every analytical decision in a portfolio deal.

04 Why is it called a tape?

The term dates to when large datasets were physically delivered on magnetic tape reels. The medium is long obsolete, but the name stuck and now refers to the file itself regardless of format — a spreadsheet, a CSV, or a database extract.

"Loan tape" is the most common variant, reflecting how central these files are to loan and credit portfolio sales, but "data tape" applies equally to leases, receivables, and other granular asset pools.

05 How does a data tape stay useful after acquisition?

The tape captured the exact composition of the portfolio at the moment of purchase — the baseline the deal was priced against. After close, the buyer needs to track how the actual portfolio performs against that baseline to know whether the underwriting held up.

Keeping the original tape queryable alongside ongoing performance data lets the buyer compare assumptions to outcomes loan by loan, rather than losing the acquisition snapshot in a static file. The tape stops being a one-time pricing input and becomes the reference point for monitoring the asset.

Related terms

VectorShift for deal teams

Put VectorShift to work on every deal.

VectorShift reads the documents your team actually works on — CIMs, management decks, filings, expert calls, portfolio reports — and returns structured, sourced analysis in minutes, not weeks.

Request a demo