Private Equity Insider is no longer being published.

Subscribers to Private Equity Insider now have full access to HFAlert.com. They can sign in with their username and password from PEInsider.com to search the archives of both Private Equity Insider and Hedge Fund Alert.

About the Re-REMIC Database

The Re-REMIC Database captures the initial terms of all rated resecuritizations of CMBS. It excludes deals structured as collateralized debt obligations, which are detailed in the Real Estate CDO Database, a online compilation also maintained by Commercial Mortgage Alert.

Criteria for the Re-REMIC Database

Rated by at least one major agency.

Under the control of a trustee.

 

Creremic.xls Data Fields

CODE: The code is a unique, eight-digit number that can be used to link the different modules of the Re-REMIC Database. The first four digits represent the year and the next four represent a unique number (for example: 20010108).

ISSUER: The name of the issuing entity, exactly as it is shown on the prospectus.

SERIES: The series name of the offering, exactly as it is shown on the prospectus.

AMOUNT: The sum of the original face amount of all classes (in millions of dollars). For issues that aren't denominated in U.S. dollars, the amount shown is the dollar equivalent.

CLOSING: The closing date. This is usually the settlement date of the issue.

PRICING: The date when final pricing for all or most of the entire issue was completed.

SELLER: The party deemed to be the primary beneficiary of the transaction.

SBT: Seller/borrower type. A code that describes the party that was deemed to be the primary beneficiary of the transaction:

B

Bank/thrift

D

Developer/real estate firm

E

Investment group

F

Finance/mortgage company

G

Government entity

I

Insurer

P

Pension fund

R

RTC/FDIC

S

Securitization program

T

REIT

W

Investment bank

Y

Retailer

Z

Other

BOOKRNR1/BOOKRNR2: The broker-dealer that ran the books and coordinated distribution of the securities. If there are two joint bookrunners on a deal, the BOOKRNR2 field is also used. For two bookrunners to be listed, the prospectus cover must clearly state that specific underwriters are "joint bookrunners" or "co-bookrunners." If three or more firms are identified as bookrunners, only the first two firms will appear in the BOOKRNR1 and BOOKRNR2 fields.

TRUSTEE: The trustee hired to hold the bond collateral for the benefit of investors.

CERTADMIN: The certificate administrator.

COUNSELUW: The underwriter counsel.

COUNSELISS: The issuer counsel.

RM/RS/RF/RD/RO: An "x" in one of these fields indicates that some or all of the deal's classes were rated by Moody's, S&P, Fitch, DBRS/Duff or another agency.

OFF: Offering type, that is, the method of securities distribution:

A

Rule 144A

I

Outside U.S.

P

Private placement

S

SEC-registered

DENT: Country of denomination (blank if U.S.)

DENT/AMT: Amount in denomination (blank if U.S. dollars)

DIS: Region where distributed:

A

Asia (except Japan)

C

Canada

E

Europe

F

Africa

J

Japan

K

Australia

L

Latin America

M

Mideast

U

U.S.

FRQ: The frequency of interest and/or principal payments:

M

Monthly

Q

Quarterly

S

Semi-annual

#CERT: Total number of CMBS certificates in the collateral pool.

#DEAL: Total number of unique CMBS transactions represented in the collateral pool.

CRATE: The rate type of the collateral certificates:

A

Floating-rate

F

Fixed-rate

X

Mixed

NRATE: The rate type of the notes:

A

Floating-rate

F

Fixed-rate

X

Mixed

LOCATION: Identifies states/countries with at least 10% of the underlying real estate collateral.

REGION/COL: Region of collateral:

A

Asia (except Japan)

C

Canada

E

Europe

F

Africa

J

Japan

K

Australia

L

Latin America

M

Mideast

U

U.S.

COUNTRY/COL: Country where collateral is located.

CreremicCol.xls Data Fields

CODE: The code is a unique, eight-digit number that can be used to link together the different modules of the Re-REMIC Database. The first four digits represent the year and the next four represent a unique number (for example: 20010108).

PRICING: The date when final pricing for all or most of the entire issue was completed.

ISSUER: The name of the issuing entity, exactly as it is shown on the prospectus.

SERIES: The series name of the offering, exactly as it is shown on the prospectus.

AMOUNT: The sum of the original face amount of all classes (in millions of dollars). For issues that aren't denominated in U.S. dollars, the amount shown is the dollar equivalent.

COL_DEAL: CMBS offering included in the collateral pool.

COL_CLASS: Tranches contributed to the collateral pool.

COL_AMT: Portion of the tranche contributed to the collateral pool, in US dollars.

COL_CODE: The collateral's CMA Code.

 

CreremicPrice.xls Data Fields

CODE: The code is a unique, eight-digit number that can be used to link together the different modules of the Re-REMIC Database. The first four digits represent the year and the next four represent a unique number (for example: 20010108).

CLASS: The tranche identifier.

AMOUNT: The original face amount of the class (in millions of dollars). For classes that aren't denominated in U.S. dollars, the amount shown is the dollar equivalent.

NOTAMT: The notional amount of the class (in millions of dollars). For classes that aren't denominated in U.S. dollars, the amount shown is the dollar equivalent.

DEN: Country of denomination (blank if U.S.).

DEN/AMT: Amount in denomination (blank if U.S. dollars).

RATINGM: Initial rating assigned by Moody's.

RATINGS: Initial rating assigned by S&P.

RATINGF: Initial rating assigned by Fitch.

RATINGD: Initial rating assigned by DBRS.

SUB%: Percent subordination.

COUPON: Coupon rate -- the initial annual pay rate. For fixed-rate classes, the coupon is stated as a percentage. For floating-rate classes, it is the stated margin in basis points over a certain benchmark rate.

PRICE: Initial price per $100 of bonds.

CBE: Corporate bond equivalent yield, which allows investors to compare all fixed-income securities to corporate bonds, which pay interest semi-annually and are based on a 360-day year.

MATURE: The final rated maturity date for the class.

LIFE: The weighted average expected retirement date of each class of securities (in years).

SPREAD: The difference, in basis points, between the initial yield and a benchmark rate, usually Treasury securities or Libor.

BENCH: The benchmark rate used to price the notes.

RATE: Coupon rate structure on the securities:

A

Floating-rate

F

Fixed-rate

 

About the CMBS Database

The CMBS Database captures the initial terms of all rated securities collateralized by commercial and multi-family properties. It covers issues from the inception of the CMBS market in the mid-1980s through the end of the last week.

Click here to read more.