1. What is the relationship between the variable "Composite Amount" versus the variable "Amount per Each Use of Proceeds"? Composite Amount is the sum of par amounts of related issues considered a single issue by the issuer, while the Amount per Each Use of Proceeds is the specific amount allocated to each use of proceeds for a particular issue. There are instances wherein a transaction needs to be split into 2 or more different deals due to its allocation of use of proceeds. Each deal will show a different amount that is allocated for its use of proceeds. That amount will be the Par Amount of each deal, and the total of those deals will show as Composite Amount. The Par Amount of a deal can also be seen as the Amount per Each Use of Proceeds.
2. For the variables "Beginning Serial/Term Coupon" and "Beginning Serial/Term Yield", why do we have 0 for some of the entries? Was this meant to say that some bonds actually had 0 coupons and/or 0 yields? For the 0 coupons, there are deals that are categorized as Capital Appreciation Bonds (CABs) wherein we input 0 on the coupon since no interest is paid on such bonds. This may also be the case for Variable rate bonds, wherein we input no amount in the coupon field. As for the 0 yield, it would mean that no yield has been input in the deal. Coupon and Yield fields may be blank for some deals due to source issue, wherein the data is not yet available when the deal was initially created. This will be updated once the data for both fields are available for us.
3. How should we interpret the variables "Final Ending Price/Yield" and "Final Ending Serial Coupon"? The coupon denotes the amount of annual interest payable for the bond due on the maturity date. There are deals that have serial maturities, wherein the issue matures in succession over a period. Please see below description for each variable.
Final Ending Price/Yield - The last yield or price of all serial maturities.
Final Ending Serial Coupon - The last annual interest rate of all serial maturities.
4. There are deals with >1 tranche (as shown by the variable "Number of Tranches in a Deal"). For any given row, is there a way to tell which of the tranches is the data on that row capturing? For example, for rows that denote multiple tranches, would the variable "Sale Date" on those rows always be that of the first tranche? What about information for the second or third tranche? How is their data captured in that given row, if at all?
A deal could have multiple tranches when it has components that have different credit enhancement or is made up of combination of serial and term maturity. Each tranche may have different value on mentioned components, but they have the same data for other variables. With that, the sale date for each tranche will always be the same as the first tranche.
5. For some of the rows, the county of the issuer (variable "County") shows more than one county, see rows 5 and 26 for specific examples. Why is this the case? Is it because the issuer crosses county borders? When creating an issuer in our database, we input the county or counties that were indicated in the initial source, official statements, or any other supporting documents given to us. There are instances wherein there are two (2) or more counties listed in the issuer name of the deal as per its source/s. Hence, we're create the issuer as per the source.
6. Multiple items such as CUSIPs often show up on the same line. How to separate?
Change your settings when you report on the data. For Concatenation, use Line Break where that option is available.
7, Final Maturity Yield is missing Concatenation parameters, but sometimes populates either Tranche or Maturity. To correct this, try re-adding the Final Maturity Yield report item back to the report until the parameter is blank and everything should line up.
