Attachment 8 - Data Table Templates (Final).xls

About this file

View the file

Other files

Work with this file

Text version

XLS spreadsheet 244 KB Posted Dec 8, 2025

Attached to: Fixed Income Investment Services (Amendment 2)
Solicitation number: 16PBGC25R0062
Issued by: Pension Benefit Guaranty Corporation

Written by GovTribe AI · Dec 8, 2025

Attachment 8 is a comprehensive Excel data table template for financial services providers, specifically designed for fixed income investment firms to report detailed performance and organizational metrics. The template contains 15 distinct tables covering a range of data points including firm performance, assets under management, employee information, portfolio characteristics, returns, risk statistics, and client details. Each table is structured to capture multi-year data from 6/30/20 to 6/30/25, with columns for tracking various financial and operational metrics such as total assets, investment staff composition, portfolio returns, benchmark comparisons, risk assessments, and client account information.

The template aligns with the related federal contract opportunity (Solicitation Number 16PBGC25R0062) issued by the Pension Benefit Guaranty Corporation (PBGC) for fixed income investment services. The solicitation is a two-phase competitive procurement seeking investment firms capable of delivering portfolio returns that exceed benchmark performance over a full market cycle. Key requirements include full SAM registration, comprehensive performance reporting, and the ability to demonstrate investment expertise across multiple dimensions of fixed income portfolio management. Offerors who successfully pass Phase 1 will be invited to proceed to Phase 2 of the evaluation process.

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

Show all 21

On GovTribe

Download the original file
Contacts named in this file
Similar government files
Ask GovTribe AI about this file

Try for free Login

Firm Name:

Product Name:

Benchmark Name:

Monthly Returns

Rolling 60 month periods

Rolling period #

IR for Rolling 60 month period

Geometric Excess Return

Average IR

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

Table 1

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

Table 2

Firm Name:
Product Name:
	6/30/25	6/30/24	6/30/23	6/30/22	6/30/21	6/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:
Employees	6/30/25	6/30/24	6/30/23	6/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:
Location	Function Performed at Location	# of Employees	# Investment Professionals
City, State, Country

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

Table 5

Firm Name:
Product Name:
	6/30/25	6/30/24	6/30/23	6/30/22	6/30/21	6/30/20	Left 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:
Name	Role	Total Years of Experience	Years With Firm	Years With Subject Product	Education2/Degree/Year	School	Professional 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 Duration

Effective Convexity

Option Adjusted Spread

Yield to Maturity

Average Coupon

Average Quality (Moody’s)

Number of Holdings

Key Rate Duration 0-2 yrs

Key Rate Duration 3yr

Key Rate Duration 5yr

Key Rate Duration 10yr

Key Rate Duration 20yr

Key Rate Duration 30yr

Portfolio

Benchmark

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

Table 8

Firm Name:

Product Name:

Benchmark Name:

Date (Quarter End)

Treasuries

Govt Related - Agencies

Govt Related - Local Auth

Govt Related -Sovereign

Govt Related – Supranational

Corporate – Industrial

Corporate – Utility

Corporate – Financial

Securitized - CMBS

Securitized – ABS

Securitized – Covered

Securitized – US MBS

Other

State 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
Month	Portfolio	Benchmark	Alpha

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

Table 10

Firm Name:
Product Name:
Benchmark Name:
	Country	Quarter End
Portfolio	Country 1
	Country 2
	Country 3
	Region 1
	…..
	Country 4
	Country 5
	Country 6
	Region 2
	….
	Total
Benchmark	Country 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:
Calendar Year	Date (Quarter End)	Calendar Year Return (Net of Fee)(in %)	Product Benchmark Calendar Year Return (in%)	Number of Portfolios	Tracking Error (%)	Total Composite Assets ($Millions)	Total Firm Assets ($Millions)
(Since Inception)
YTD
2024
2023
2022
2021
2020
2019
2018
2017
2016
2015
2014

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

Table 12

Firm Name:
Product Name:
Annualized Returns	Date (Quarter End)	2024	2023	2022	2021	2020	2019	2018	2017	2016	2015
High
Low
Difference

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

Table 13

Firm Name:
Product Name:
Benchmark Name:
Risk Statistics	3 Years Ended 6/30/2025	5 Years Ended 6/30/2025	10 Years Ended 6/30/2025	Since 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/25	12/31/24	12/31/23	12/31/22	12/31/21	12/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 Name	Client Type	Tax-exempt (Y/N)	Date of Inception	Market Value (06/30/2025)

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

File details come from the government source that posted it. Updated Dec 8, 2025.