Attachment 8 - DRAFT Data Table Templates.xls

About this file

View the file

Other files

Work with this file

Text version

XLS spreadsheet 271 KB Posted Sep 4, 2025

Attached to: Fixed Income Investment Services (Draft Solicitation)
Solicitation number: DRAFT25R0062
Issued by: Pension Benefit Guaranty Corporation

Written by GovTribe AI · Sep 4, 2025

This file is an Excel template containing 15 draft data tables for a fixed income investment services solicitation from the Pension Benefit Guaranty Corporation (PBGC). The tables are designed to collect comprehensive data about an investment firm's performance, including portfolio metrics, returns, risk statistics, assets under management, employee information, and historical performance across multiple years and quarters. Key data points include total assets under management, investment professional details, portfolio composition, returns relative to benchmarks, geographic allocations, risk measurements like alpha, beta, and tracking error, and client account information.

The related federal contract opportunity is a pre-solicitation draft for fixed income investment services, emphasizing that potential offerors should use this draft to evaluate their competitive viability and prepare proposal materials. A critical requirement is SAM.gov registration, with specific guidance provided about entity registration processes, NAICS code (523940 - Portfolio Management), and the importance of obtaining a Unique Entity ID. The solicitation invites prospective vendors to review the draft, prepare materials, and provide questions and recommendations to PBGC before a formal solicitation is issued.

File	Type	Posted
Industry Feedback Form with PBGC Responses - Draft Solicitation - Public.xlsx	XLSX spreadsheet	Oct 10, 2025
Industry Feedback Form - Draft Solicitation.xlsx	XLSX spreadsheet	Sep 17, 2025
Attachment 6 - DRAFT Solicitation Phase 1 Forms_Amendment 1.docx	DOCX document	Sep 15, 2025
Industry Feedback Form - Draft Solicitation.xlsx	XLSX spreadsheet	Sep 4, 2025
Attachment 1 - DRAFT Instructions to Offerors.pdf	PDF	Sep 4, 2025
Attachment 5 - DRAFT Clauses and Provisions.pdf	PDF	Sep 4, 2025
Attachment 6 - DRAFT Solicitation Phase 1 Forms.docx	DOCX document	Sep 4, 2025
Attachment 7 - DRAFT Solicitation Phase 2 Forms.docx	DOCX document	Sep 4, 2025
Attachment 2 - DRAFT Evaluation Criteria.pdf	PDF	Sep 4, 2025
Attachment 3 - DRAFT Statement of Work.pdf	PDF	Sep 4, 2025
Attachment 4 - DRAFT Fixed Income Pricing Template.xlsx	XLSX spreadsheet	Sep 4, 2025

Show all 11

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

Average IR

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

Table 1

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 2

Key Rate Duration 3

Key Rate Duration 5

Key Rate Duration 10

Key Rate Duration 20

Portfolio

Benchmark

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

Table 2

Firm Name:

Product 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 3

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

Table 4

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 5

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 6

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

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

Table 7

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 8

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 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
			0.0%
			0.0%
			0.0%
			0.0%
			0.0%
			0.0%
			0.0%
			0.0%
			0.0%
			0.0%
			0.0%
			0.0%
			0.0%
			0.0%
			0.0%
			0.0%
			0.0%

&L&F &A&R&T &D Sample Only Enter all values in Excel File

Table10

Firm Name:
Product Name:
	Date (Quarter End)	Sep-09	Jun-09	Mar-09	Dec-08	Sep-08	Jun-08	Mar-08	Dec-07	Sep-07	Jun-07	Mar-07	Dec-06	Sep-06	State the name of the largest component of 'Other'	Mar-06	Dec-05	Sep-05	Jun-05	Mar-05	Dec-04
Portfolio
			0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%		0.0%	0.0%	0.0%	0.0%	0.0%
			0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%		0.0%	0.0%	0.0%	0.0%	0.0%
			0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%		0.0%	0.0%	0.0%	0.0%	0.0%
			0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%		0.0%	0.0%	0.0%	0.0%	0.0%
Benchmark
			0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%		0.0%	0.0%	0.0%	0.0%	0.0%
			0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%		0.0%	0.0%	0.0%	0.0%	0.0%
			0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%		0.0%	0.0%	0.0%	0.0%	0.0%
			0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%	0.0%		0.0%	0.0%	0.0%	0.0%	0.0%

&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:
U.S. Tax-exempt Clients	Insurance Clients	Other Clients	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 Sep 4, 2025.