Attachment 8 - Data Table Templates (Amendment 1).xls

245 KB Posted

Attached to
Fixed Income Investment Services (Amendment 2)
Solicitation number
16PBGC25R0062
Issued by

About this file

Written by GovTribe AI ·

Attachment 8 is a comprehensive Excel data table template for a fixed income investment services solicitation by the Pension Benefit Guaranty Corporation (PBGC). The template consists of 15 detailed tables designed to capture extensive investment performance, organizational, and financial information from potential investment service providers. The tables request data across multiple years (from 6/30/20 to 6/30/25) on key metrics including monthly returns, total assets under management, employee demographics, investment staff composition, portfolio characteristics, returns, risk statistics, and client account details.

The solicitation (16PBGC25R0062) is a two-phase Request for Proposals (RFP) seeking fixed income investment services that can deliver total returns exceeding benchmark portfolios over a full market cycle. Offerors must be fully registered in the System for Award Management (SAM) and will be evaluated in Phase 1, with successful candidates invited to proceed to Phase 2. The RFP is open to all capable firms registered to do business with the U.S. Government, with the goal of selecting investment service providers who can demonstrate consistent performance, robust organizational structure, and the ability to manage fixed income portfolios effectively.

View the file

Other files

File Type Posted
Attachment 6 - Solicitation Phase 1 Forms (Amendment 2 Version).docx DOCX document
Attachment 8 - Data Table Templates (Amendment 1 Version_Changes Accepted).xls XLS spreadsheet
Attachment 1 - Instructions to Offerors (Amendment 2 Version).pdf PDF
Attachment 7 - Solicitation Phase 2 Forms (Amendment 1 Version_Changes Accepted).docx DOCX document
Attachment 2 - Evaluation Criteria (Amendment 2 Version).pdf PDF
Attachment 5 - Clauses and Provisions (Amendment 1 Version_Changes Accepted).pdf PDF
Attachment 6 - Solicitation Phase 1 Forms (Amendment 1).docx DOCX document
Attachment 7 - Solicitation Phase 2 Forms (Amendment 1).docx DOCX document
Attachment 5 - Clauses and Provisions (Amendment 1).pdf PDF
Attachment 11 - PBGC Responses to Industry Feedback - OFFICIAL SOLICITATION.xlsx XLSX spreadsheet
Attachment 8 - Data Table Templates (Final).xls XLS spreadsheet
Attachment 5 - Clauses and Provisions (Final).pdf PDF
Attachment 9 - Mercer NDA Form (Final).docx DOCX document
Attachment 2 - Evaluation Criteria (Final).pdf PDF
Attachment 1 - Instructions to Offerors (Final).pdf PDF
Attachment 4 - Fixed Income Pricing Template (Final).xlsx XLSX spreadsheet
Attachment 11 - Industry Feedback Form - Official Solicitation.xlsx XLSX spreadsheet
Attachment 3 - Statement of Work (Final).pdf PDF
Attachment 7 - Solicitation Phase 2 Forms (Final).docx DOCX document
Attachment 6 - Solicitation Phase 1 Forms (Final).docx DOCX document
Attachment 10 - PBGC Responses to Industry Feedback - Draft Solicitation.xlsx XLSX spreadsheet
Show all 21

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file
Try for free Login

Text version

The file's text, extracted by GovTribe without its formatting.

Table 1

Firm Name:
Product Name:
Benchmark Name:
Round to two decimal points.
Monthly Returns (%)Rolling 60 month periodsRolling period #IR for Rolling 60 month period
MonthPortfolioBenchmarkGeometric Excess Return (%)
Average IR

&L&F &A&R&T &D

Table 2

Firm Name:
Product Name:
6/30/256/30/246/30/236/30/226/30/216/30/20
Total assets under management (U.S. $ in mils.)
Total Fixed Income AUM, U.S. ($ in mils.)
Total Fixed Income US Public Pensions AUM (all Fixed Income products, U.S. $ in mils.)
Total Fixed Income US Corporate Pensions AUM (all Fixed Income products, U.S. $ in mils.)
Total Fixed Income AUM in separate accounts that are $50M or greater in size (all Fixed Income products, U.S. $ in mils.)
Average Fixed Income Account Size
# FI Accounts gained
$ FI Gained
# FI Accounts lost
$ FI Lost

&L&F &A&R&T &D

Table 3

Firm Name:
Product Name:
Employees6/30/256/30/246/30/236/30/22# Left in the past 3 years
Executive Mgmt. (non-invest. staff)
Investment Professionals
Operational Risk Assessment Staff
Marketing/Client Service
Back Office
IT
Administrative
Other: Specify
TOTAL EMPLOYEES

&L&F &A&R&T &D

Table 4

Firm Name:
Product Name:
LocationFunction Performed at Location# of Employees# Investment Professionals
City, State, Country

&L&F &A&R&T &D

Table 5

Firm Name:
Product Name:
6/30/256/30/246/30/236/30/226/30/216/30/20Left Past 3 Yrs.
Portfolio Managers
Research Staff/Analysts
Total Investment Staff
Total Fixed Income Employees

&L&F &A&R&T &D

Table 6

Firm Name:
Product Name:
NameRoleTotal Years of ExperienceYears With FirmYears With Subject ProductEducation2/Degree/YearSchoolProfessional Designation
Note 1: Indicate whether individual has responsibilities for products other than the subject products.
Note 2: Most advanced degree only.

&L&F &A&R&T &D

Table 7

Firm Name:
Product Name:
Benchmark Name:
Date (Quarter End)Effective DurationEffective ConvexityOption Adjusted SpreadYield to MaturityAverage CouponAverage Quality (Moody’s)Number of HoldingsKey Rate Duration 0-2 yrsKey Rate Duration 3yrKey Rate Duration 5yrKey Rate Duration 10yrKey Rate Duration 20yrKey Rate Duration 30yr
Portfolio
Benchmark

&L&F &A&R&T &D

Table 8

Firm Name:
Product Name:
Benchmark Name:
Date (Quarter End)TreasuriesGovt Related - AgenciesGovt Related - Local AuthGovt Related -SovereignGovt Related – SupranationalCorporate – IndustrialCorporate – UtilityCorporate – FinancialSecuritized - CMBSSecuritized – ABSSecuritized – CoveredSecuritized – US MBSOtherState the name of the largest component of 'Other'Total
Portfolio
Benchmark

&L&F &A&R&T &D

Table 9

Firm Name:
Product Name:
Benchmark Name:
Quarterly Returns
Quarter endPortfolioBenchmarkAlpha

&L&F &A&R&T &D

Table 10

Firm Name:
Product Name:
Benchmark Name:
Country6/30/256/30/246/30/23…..…..…..…..…..…..…..
PortfolioCountry 1
Country 2
Country 3
Region 1
…..
Country 4
Country 5
Country 6
Region 2
….
Total
BenchmarkCountry 1
Country 2
Country 3
Region 1
…..
Country 4
Country 5
Country 6
Region 2
….
Total

&L&F &A&R&T &D

Table 11

Firm Name:
Product Name:
PeriodGross Return (%)Net Return (%)Benchmark Return (%)Number of PortfoliosTracking Error (%)Total Composite Assets ($ Millions)Total Firm Assets ($ Millions)
Since Inception
YTD (as of 6/30/2025)
2024
2023
2022
2021
2020
2019
2018
2017
2016
2015
2014

&L&F &A&R&T &D

Table 12

Firm Name:
Product Name:
Calendar years
Annualized ReturnsYear-to-Date (6/30/2025)2024202320222021202020192018201720162015
High
Low
Difference

&L&F &A&R&T &D

Table 13

Firm Name:
Product Name:
Benchmark Name:
Risk Statistics3 Years Ended 6/30/20255 Years Ended 6/30/202510 Years Ended 6/30/2025Since Inception
Portfolio Return (Gross of fees)
Benchmark Return
Alpha
Beta
R2
Up-Market Capture
Down-Market Capture
Standard Deviation
Tracking Error
Information Ratio

&L&F &A&R&T &D

Table 14

Firm Name:
Product Name:
6/30/2512/31/2412/31/2312/31/2212/31/2112/31/20
(a) Total assets managed in the subject product (U.S.$ in mils.)
Total # of Accounts
Average Account Size
Assets of the largest separate accounts (U.S.$ in mils.)
Assets of all separate accounts > $50M (U.S. $ in mils.)
# Accounts gained
$ Gained
# Accounts lost
$ Lost
(b) Total assets managed in the subject product for U.S. tax-exempt clients ($ in mils.)
Total # of Accounts
Average Account Size
# Accounts gained
$ Gained
# Accounts lost
$ Lost

&L&F &A&R&T &D

Table 15

Firm Name:
Product Name:
Client NameClient TypeTax-exempt (Y/N)Date of InceptionMarket Value (06/30/2025)

&L&F &A&R&T &D

File details come from the government source that posted it. Updated .