ProdLvlTechEvalQstnrTable 12-17.xls

XLS spreadsheet 239 KB Posted

Attached to
PBGC intends to increase the Fixed income Investment Managers from its current level to provde more manager diversificatgion. PBGC anticipates hiring multiple managers capable of managing fixed income assets in two or more fixed income strategies.
Solicitation number
PBGC01-RP-10--0003
Issued by

About this file

From the source

Tabe 4 thru 18

View the file

Other files

File Type Posted
PM_05_6.pdf PDF
PM_05_6.pdf PDF
Questions and Answers.doc DOC document
FI RFP 12-18-09 Final CID.doc DOC document
FirmjLvlTechEvalQstnrTable - 12-16-09.xls XLS spreadsheet
FI RFP 12-17-09 Final CID.doc DOC document
SF1449- RFP.pdf PDF
ProdLvlTechEvalQstnrTable - 12-16-09.xls XLS spreadsheet

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.

Table4

Enter Firm Name in Cell B1
Enter Product Name in Cell B2
NameTitle Responsibilities1Total 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&C&12Attachment 8 Tables&R&T &D

Table5

Enter Firm Name in Cell B1
Enter Product Name in Cell B2
Fixed Income EmployeesTargetCurrent20082007200620052004200320022001Left Past 3 Yrs.
Portfolio Managers
Research Staff/Analysts
Total Investment Staff
Operational Risk Assessment Staff
Executive Mgmt. (non-invest. staff)
Marketing/Client Service
Total Fixed Income Employees

&L&F &A&C&12Attachment 8 Tables&R&T &D

Table6

Enter Firm Name in Cell B1
Enter Product Name in Cell B2
Monthly ReturnsQuarterly Returns
MonthPortfolio (gross of fees)BenchmarkAlphaMonthPortfolio (gross of fees)BenchmarkAlpha
Sep-090.00%0.00%0.00%Sep-090.00%0.00%0.00%
Aug-090.00%0.00%0.00%Jun-090.00%0.00%0.00%
Jul-090.00%0.00%0.00%Mar-090.00%0.00%0.00%
Jun-090.00%0.00%0.00%Dec-080.00%0.00%0.00%
May-090.00%0.00%0.00%Sep-080.00%0.00%0.00%
Apr-090.00%0.00%0.00%Jun-080.00%0.00%0.00%
Mar-090.00%0.00%0.00%Mar-080.00%0.00%0.00%
Feb-090.00%0.00%0.00%Dec-070.00%0.00%0.00%
Jan-090.00%0.00%0.00%Sep-070.00%0.00%0.00%
Dec-080.00%0.00%0.00%Jun-070.00%0.00%0.00%
Nov-080.00%0.00%0.00%Mar-070.00%0.00%0.00%
Oct-080.00%0.00%0.00%Dec-060.00%0.00%0.00%
Sep-080.00%0.00%0.00%Sep-060.00%0.00%0.00%
Aug-080.00%0.00%0.00%Jun-060.00%0.00%0.00%
Jul-080.00%0.00%0.00%Mar-060.00%0.00%0.00%
Jun-080.00%0.00%0.00%Dec-050.00%0.00%0.00%
May-080.00%0.00%0.00%Sep-050.00%0.00%0.00%
Apr-080.00%0.00%0.00%Jun-050.00%0.00%0.00%
Mar-080.00%0.00%0.00%Mar-050.00%0.00%0.00%
Feb-080.00%0.00%0.00%Dec-040.00%0.00%0.00%
Jan-080.00%0.00%0.00%Sep-040.00%0.00%0.00%
Dec-070.00%0.00%0.00%Jun-040.00%0.00%0.00%
Nov-070.00%0.00%0.00%Mar-040.00%0.00%0.00%
Oct-070.00%0.00%0.00%Dec-030.00%0.00%0.00%
Sep-070.00%0.00%0.00%Sep-030.00%0.00%0.00%
Aug-070.00%0.00%0.00%Jun-030.00%0.00%0.00%
Jul-070.00%0.00%0.00%Mar-030.00%0.00%0.00%
Jun-070.00%0.00%0.00%Dec-020.00%0.00%0.00%
May-070.00%0.00%0.00%Sep-020.00%0.00%0.00%
Apr-070.00%0.00%0.00%Jun-020.00%0.00%0.00%
Mar-070.00%0.00%0.00%Mar-020.00%0.00%0.00%
Feb-070.00%0.00%0.00%Dec-010.00%0.00%0.00%
Jan-070.00%0.00%0.00%Sep-010.00%0.00%0.00%
Dec-060.00%0.00%0.00%Jun-010.00%0.00%0.00%
Nov-060.00%0.00%0.00%Mar-010.00%0.00%0.00%
Oct-060.00%0.00%0.00%Dec-000.00%0.00%0.00%
Sep-060.00%0.00%0.00%Sep-000.00%0.00%0.00%
Aug-060.00%0.00%0.00%Jun-000.00%0.00%0.00%
Jul-060.00%0.00%0.00%Mar-000.00%0.00%0.00%
Jun-060.00%0.00%0.00%Dec-990.00%0.00%0.00%
May-060.00%0.00%0.00%
Apr-060.00%0.00%0.00%
Mar-060.00%0.00%0.00%
Feb-060.00%0.00%0.00%
Jan-060.00%0.00%0.00%
Dec-050.00%0.00%0.00%
Nov-050.00%0.00%0.00%
Oct-050.00%0.00%0.00%
Sep-050.00%0.00%0.00%
Aug-050.00%0.00%0.00%
Jul-050.00%0.00%0.00%
Jun-050.00%0.00%0.00%
May-050.00%0.00%0.00%
Apr-050.00%0.00%0.00%
Mar-050.00%0.00%0.00%
Feb-050.00%0.00%0.00%
Jan-050.00%0.00%0.00%
Dec-040.00%0.00%0.00%
Nov-040.00%0.00%0.00%
Oct-040.00%0.00%0.00%
Sep-040.00%0.00%0.00%
Aug-040.00%0.00%0.00%
Jul-040.00%0.00%0.00%
Jun-040.00%0.00%0.00%
May-040.00%0.00%0.00%
Apr-040.00%0.00%0.00%
Mar-040.00%0.00%0.00%
Feb-040.00%0.00%0.00%
Jan-040.00%0.00%0.00%
Dec-030.00%0.00%0.00%
Nov-030.00%0.00%0.00%
Oct-030.00%0.00%0.00%
Sep-030.00%0.00%0.00%
Aug-030.00%0.00%0.00%
Jul-030.00%0.00%0.00%
Jun-030.00%0.00%0.00%
May-030.00%0.00%0.00%
Apr-030.00%0.00%0.00%
Mar-030.00%0.00%0.00%
Feb-030.00%0.00%0.00%
Jan-030.00%0.00%0.00%
Dec-020.00%0.00%0.00%
Nov-020.00%0.00%0.00%
Oct-020.00%0.00%0.00%
Sep-020.00%0.00%0.00%
Aug-020.00%0.00%0.00%
Jul-020.00%0.00%0.00%
Jun-020.00%0.00%0.00%
May-020.00%0.00%0.00%
Apr-020.00%0.00%0.00%
Mar-020.00%0.00%0.00%
Feb-020.00%0.00%0.00%
Jan-020.00%0.00%0.00%
Dec-010.00%0.00%0.00%
Nov-010.00%0.00%0.00%
Oct-010.00%0.00%0.00%
Sep-010.00%0.00%0.00%
Aug-010.00%0.00%0.00%
Jul-010.00%0.00%0.00%
Jun-010.00%0.00%0.00%
May-010.00%0.00%0.00%
Apr-010.00%0.00%0.00%
Mar-010.00%0.00%0.00%
Feb-010.00%0.00%0.00%
Jan-010.00%0.00%0.00%
Dec-000.00%0.00%0.00%
Nov-000.00%0.00%0.00%
Oct-000.00%0.00%0.00%
Sep-000.00%0.00%0.00%
Aug-000.00%0.00%0.00%
Jul-000.00%0.00%0.00%
Jun-000.00%0.00%0.00%
May-000.00%0.00%0.00%
Apr-000.00%0.00%0.00%
Mar-000.00%0.00%0.00%
Feb-000.00%0.00%0.00%
Jan-000.00%0.00%0.00%
Dec-990.00%0.00%0.00%
Nov-990.00%0.00%0.00%
Oct-990.00%0.00%0.00%

&L&F &A&C&12Attachment 8 Tables&R&T &D

Table7

Enter Firm Name in Cell B1
Enter Product Name in Cell B2
Effective DurationEffective ConvexityOption Adjusted SpreadYield to MaturityAverage CouponAverage Quality (Moody’s)Number of HoldingsKey Rate Duration 2Key Rate Duration 3Key Rate Duration 5Key Rate Duration 10Key Rate Duration 20
PortfolioSep-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
Jun-06
Mar-06
Dec-05
Sep-05
Jun-05
Mar-05
Dec-04
BenchmarkSep-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
Jun-06
Mar-06
Dec-05
Sep-05
Jun-05
Mar-05
Dec-04

&L&F &A&C&12Attachment 8 Tables&R&T &D

Table8

Enter Firm Name in Cell B1
Enter Product Name in Cell B2
SectorTreasuriesGovt Related - AgenciesGovt Related - Local AuthGovt Related -SovereignGovt Related – SupranationalCorporate – IndustrialCorporate – UtilityCorporate – FinancialSecuritized - CMBSSecuritized – ABSSecuritized – CoveredSecuritized – US MBSOtherState the name of the largest component of otherTotal
PortfolioSep-090.0%
Jun-090.0%
Mar-090.0%
Dec-080.0%
Sep-080.0%
Jun-080.0%
Mar-080.0%
Dec-070.0%
Sep-070.0%
Jun-070.0%
Mar-070.0%
Dec-060.0%
Sep-060.0%
Jun-060.0%
Mar-060.0%
Dec-050.0%
Sep-050.0%
Jun-050.0%
Mar-050.0%
Dec-040.0%
BenchmarkSep-090.0%
Jun-090.0%
Mar-090.0%
Dec-080.0%
Sep-080.0%
Jun-080.0%
Mar-080.0%
Dec-070.0%
Sep-070.0%
Jun-070.0%
Mar-070.0%
Dec-060.0%
Sep-060.0%
Jun-060.0%
Mar-060.0%
Dec-050.0%
Sep-050.0%
Jun-050.0%
Mar-050.0%
Dec-040.0%

&L&F &A&C&12Attachment 8 Tables&R&T &D

Table9

Enter Firm Name in Cell B1
Enter Product Name in Cell B2
SectorCorporate – Industrial – Basic IndustryCorporate – Industrial – Capital GoodsCorporate – Industrial – Consumer CyclicalCorporate – Industrial – Consumer Non-CyclicalCorporate – Industrial – EnergyCorporate – Industrial – TechnologyCorporate – Industrial – TransportationCorporate – Industrial – TelecommunicationsCorporate – Industrial – Other IndustrialCorporate – Utility – ElectricCorporate – Utility – Natural GasCorporate – Financial - BankingCorporate – Financial - BrokerageCorporate – Finance CompaniesCorporate – Financial - InsuranceCorporate – Financial - REITSCorporate – Financial – Other FinancialCorporate – Gaming, Leisure, etc.OtherState the name of the largest component of otherTotal
PortfolioSep-090.0%
Jun-090.0%
Mar-090.0%
Dec-080.0%
Sep-080.0%
Jun-080.0%
Mar-080.0%
Dec-070.0%
Sep-070.0%
Jun-070.0%
Mar-070.0%
Dec-060.0%
Sep-060.0%
Jun-060.0%
Mar-060.0%
Dec-050.0%
Sep-050.0%
Jun-050.0%
Mar-050.0%
Dec-040.0%
BenchmarkSep-090.0%
Jun-090.0%
Mar-090.0%
Dec-080.0%
Sep-080.0%
Jun-080.0%
Mar-080.0%
Dec-070.0%
Sep-070.0%
Jun-070.0%
Mar-070.0%
Dec-060.0%
Sep-060.0%
Jun-060.0%
Mar-060.0%
Dec-050.0%
Sep-050.0%
Jun-050.0%
Mar-050.0%
Dec-04

&L&F &A&C&12Attachment 8 Tables&R&T &D

Table10

Enter Firm Name in Cell B1
Enter Product Name in Cell B2
CountrySep-09Jun-09Mar-09Dec-08Sep-08Jun-08Mar-08Dec-07Sep-07Jun-07Mar-07Dec-06Sep-06Jun-06Mar-06Dec-05Sep-05Jun-05Mar-05Dec-04
PortfolioCountry 1
Country 2
Country 3
Region 10.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%
…..
Country 4
Country 5
Country 6
Region 20.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%
….
Country 7
Country 8
Country 9
Region 30.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%
Total0.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%
BenchmarkCountry 1
Country 2
Country 3
Region 10.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%
…..
Country 4
Country 5
Country 6
Region 20.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%
….
Country 7
Country 8
Country 9
Region 30.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%
Total0.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&C&12Attachment 8 Tables&R&T &D

Table11

Enter Firm Name in Cell B1
Enter Product Name in Cell B2
QualitySep-09Jun-09Mar-09Dec-08Sep-08Jun-08Mar-08Dec-07Sep-07Jun-07Mar-07Dec-06Sep-06Jun-06Mar-06Dec-05Sep-05Jun-05Mar-05Dec-04
PortfolioCash and Cash Equivalents
Aaa/AAA/AAA
Aa1/AA+/AA+
Aa2/AA/AA
Aa3/AA-/AA-
A1/A+/A+
A2/A/A
A3/A-/A-
Baa1/BBB+/BBB+
Baa2/BBB/BBB
Baa3/BBB-/BBB-
Ba1/BB+/BB+
Ba2/BB/BB
Ba3/BB-/BB-
B1/B+/B+
B2/B/B
B3/B-/B-
Caa1/CCC+/CCC+
Caa2/CCC/CCC
Caa3/CCC-/CCC-
Ca/CC/CC
Unrated
Totals
BenchmarkCash and Cash Equivalents
Aaa/AAA/AAA
Aa1/AA+/AA+
Aa2/AA/AA
Aa3/AA-/AA-
A1/A+/A+
A2/A/A
A3/A-/A-
Baa1/BBB+/BBB+
Baa2/BBB/BBB
Baa3/BBB-/BBB-
Ba1/BB+/BB+
Ba2/BB/BB
Ba3/BB-/BB-
B1/B+/B+
B2/B/B
B3/B-/B-
Caa1/CCC+/CCC+
Caa2/CCC/CCC
Caa3/CCC-/CCC-
Ca/CC/CC
Unrated
Totals0.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&C&12Attachment 8 Tables&R&T &D

Table12

Enter Firm Name in Cell B1
Enter Product Name in Cell B2
2009 to 09/30/0920082007200620052004200320022001
Defaults in High Yield Representative Account (% of Market Value)
Moody’s High Yield Default Rate (percentage of principal outstanding basis)

&L&F &A&C&12Attachment 8 Tables&R&T &D

Table13

Enter Firm Name in Cell B1
Enter Product Name in Cell B2
Security NameTicker/CUSIP#ParTotal Cost U.S.$Total Market Value U.S.$Percentage of Total PortfolioBenchmark Weight

&L&F &A&C&12Attachment 8 Tables&R&T &D

Table14

Enter Firm Name in Cell B1
Enter Product Name in Cell B2
Calendar YearCalendar Year Return (Gross of Fee) (in %)Calendar Year Return (Net of Fee)(in %)Product Benchmark Calendar Year Return (in%)Number of PortfoliosTracking Error (%)Total Composite Assets ($Millions)Total Firm Assets ($Millions)
(Since Inception)
YTD 9/30/09
2008
2007
2006
2005
2004
2003
2002
2001
2000
1999

&L&F &A&C&12Attachment 8 Tables&R&T &D

Table15

Enter Firm Name in Cell B1
Enter Product Name in Cell B2
Annualized Returns9/30/09200820072006200520042003200220012000
High
Low
Difference0.0%

&L&F &A&C&12Attachment 8 Tables&R&T &D

Table16

Enter Firm Name in Cell B1
Enter Product Name in Cell B2
Risk Statistics3 Years Ended 9/30/095 Years Ended 9/30/0910 Years Ended 9/30/09Since Inception
Portfolio Return (Gross of fees)
Benchmark Return
Alpha
Beta
R2
Up-Market Capture
Down-Market Capture
Standard Deviation
Tracking Error
Information Ratio
Sharpe Ratio
Sortino Ratio
"Batting Average"

&L&F &A&C&12Attachment 8 Tables&R&T &D

Table17

Enter Firm Name in Cell B1
Enter Product Name in Cell B2
9/30/0912/31/0812/31/0712/31/0612/31/0512/31/04
(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&C&12Attachment 8 Tables&R&T &D

Table18

Enter Firm Name in Cell B1
Enter Product Name in Cell B2
U.S. Tax-exempt ClientsInsurance ClientsOther ClientsDate of InceptionMarket Value (9/30/09)

&L&F &A&C&12Attachment 8 Tables&R&T &D

Sheet1

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