Copy_of_MultipleMandateProdLvlTechEvalQstnrTable.xlsx

XLSX spreadsheet 83 KB Posted

Attached to
Fixed Income Legacy Investment Management Services
Solicitation number
PBGC01-RP-15-0008
Issued by

About this file

From the source

Copy of MultipleMandateProdLvlTechEvalQstnrTable

View the file

Other files

File Type Posted
Fixed_Income_FBO_Post_Award_Notice_July.pdf PDF
Fixed_Income_Questions_Q A_6_(2-24-15).pdf PDF
Fixed_Income_Questions_5_(2-19-15).pdf PDF
Fixed_Income_Questions_QA_4_(2-2-15).doc DOC document
Questions_-_Fixed_Income_3A_1-16-15_Post.doc DOC document
Amendment_04_Fixed_Income.pdf PDF
RFP_Questions_Set_2__FID_response.doc DOC document
Amendment_03_-_Fixed_Income.pdf PDF
Questions_and_Answers__-_FID_response_2.doc DOC document
Questions_and_Answers_1_-_Fixed_Income.doc DOC document
Amentment_02_Fixed_Income.pdf PDF
Amendment_01_-_Fixed_Income.pdf PDF
GlobalEMDFirmLvlTechEvalQstnrTable.xlsx XLSX spreadsheet
Copy_of_MultipleMandateFirmLvlTechEvalQstnrTable.xlsx XLSX spreadsheet
RFP_-_Fixed_Income_12-3-14_rev_6_Post.pdf PDF
Copy_of_GlobalEMDProdLvlTechEvalQstnrTable.xlsx XLSX spreadsheet
Show all 16

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.

&F &A &12Attachment 8 Tables &T &D

Table5

Enter Firm Name in Cell B1
Enter Product Name in Cell B2
Fixed Income EmployeesTargetCurrent20132012201120102009200820072006Left 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

&F &A &12Attachment 8 Tables &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-140.00%0.00%0.00%Sep-140.00%0.00%0.00%
Aug-140.00%0.00%0.00%Jun-140.00%0.00%0.00%
Jul-140.00%0.00%0.00%Mar-140.00%0.00%0.00%
Jun-140.00%0.00%0.00%Dec-130.00%0.00%0.00%
May-140.00%0.00%0.00%Sep-130.00%0.00%0.00%
Apr-140.00%0.00%0.00%Jun-130.00%0.00%0.00%
Mar-140.00%0.00%0.00%Mar-130.00%0.00%0.00%
Feb-140.00%0.00%0.00%Dec-120.00%0.00%0.00%
Jan-140.00%0.00%0.00%Sep-120.00%0.00%0.00%
Dec-130.00%0.00%0.00%Jun-120.00%0.00%0.00%
Nov-130.00%0.00%0.00%Mar-120.00%0.00%0.00%
Oct-130.00%0.00%0.00%Dec-110.00%0.00%0.00%
Sep-130.00%0.00%0.00%Sep-110.00%0.00%0.00%
Aug-130.00%0.00%0.00%Jun-110.00%0.00%0.00%
Jul-130.00%0.00%0.00%Mar-110.00%0.00%0.00%
Jun-130.00%0.00%0.00%Dec-100.00%0.00%0.00%
May-130.00%0.00%0.00%Sep-100.00%0.00%0.00%
Apr-130.00%0.00%0.00%Jun-100.00%0.00%0.00%
Mar-130.00%0.00%0.00%Mar-100.00%0.00%0.00%
Feb-130.00%0.00%0.00%Dec-090.00%0.00%0.00%
Jan-130.00%0.00%0.00%Sep-090.00%0.00%0.00%
Dec-120.00%0.00%0.00%Jun-090.00%0.00%0.00%
Nov-120.00%0.00%0.00%Mar-090.00%0.00%0.00%
Oct-120.00%0.00%0.00%Dec-080.00%0.00%0.00%
Sep-120.00%0.00%0.00%Sep-080.00%0.00%0.00%
Aug-120.00%0.00%0.00%Jun-080.00%0.00%0.00%
Jul-120.00%0.00%0.00%Mar-080.00%0.00%0.00%
Jun-120.00%0.00%0.00%Dec-070.00%0.00%0.00%
May-120.00%0.00%0.00%Sep-070.00%0.00%0.00%
Apr-120.00%0.00%0.00%Jun-070.00%0.00%0.00%
Mar-120.00%0.00%0.00%Mar-070.00%0.00%0.00%
Feb-120.00%0.00%0.00%Dec-060.00%0.00%0.00%
Jan-120.00%0.00%0.00%Sep-060.00%0.00%0.00%
Dec-110.00%0.00%0.00%Jun-060.00%0.00%0.00%
Nov-110.00%0.00%0.00%Mar-060.00%0.00%0.00%
Oct-110.00%0.00%0.00%Dec-050.00%0.00%0.00%
Sep-110.00%0.00%0.00%Sep-050.00%0.00%0.00%
Aug-110.00%0.00%0.00%Jun-050.00%0.00%0.00%
Jul-110.00%0.00%0.00%Mar-050.00%0.00%0.00%
Jun-110.00%0.00%0.00%Dec-040.00%0.00%0.00%
May-110.00%0.00%0.00%Sep-040.00%0.00%0.00%
Apr-110.00%0.00%0.00%
Mar-110.00%0.00%0.00%
Feb-110.00%0.00%0.00%
Jan-110.00%0.00%0.00%
Dec-100.00%0.00%0.00%
Nov-100.00%0.00%0.00%
Oct-100.00%0.00%0.00%
Sep-100.00%0.00%0.00%
Aug-100.00%0.00%0.00%
Jul-100.00%0.00%0.00%
Jun-100.00%0.00%0.00%
May-100.00%0.00%0.00%
Apr-100.00%0.00%0.00%
Mar-100.00%0.00%0.00%
Feb-100.00%0.00%0.00%
Jan-100.00%0.00%0.00%
Dec-090.00%0.00%0.00%
Nov-090.00%0.00%0.00%
Oct-090.00%0.00%0.00%
Sep-090.00%0.00%0.00%
Aug-090.00%0.00%0.00%
Jul-090.00%0.00%0.00%
Jun-090.00%0.00%0.00%
May-090.00%0.00%0.00%
Apr-090.00%0.00%0.00%
Mar-090.00%0.00%0.00%
Feb-090.00%0.00%0.00%
Jan-090.00%0.00%0.00%
Dec-080.00%0.00%0.00%
Nov-080.00%0.00%0.00%
Oct-080.00%0.00%0.00%
Sep-080.00%0.00%0.00%
Aug-080.00%0.00%0.00%
Jul-080.00%0.00%0.00%
Jun-080.00%0.00%0.00%
May-080.00%0.00%0.00%
Apr-080.00%0.00%0.00%
Mar-080.00%0.00%0.00%
Feb-080.00%0.00%0.00%
Jan-080.00%0.00%0.00%
Dec-070.00%0.00%0.00%
Nov-070.00%0.00%0.00%
Oct-070.00%0.00%0.00%
Sep-070.00%0.00%0.00%
Aug-070.00%0.00%0.00%
Jul-070.00%0.00%0.00%
Jun-070.00%0.00%0.00%
May-070.00%0.00%0.00%
Apr-070.00%0.00%0.00%
Mar-070.00%0.00%0.00%
Feb-070.00%0.00%0.00%
Jan-070.00%0.00%0.00%
Dec-060.00%0.00%0.00%
Nov-060.00%0.00%0.00%
Oct-060.00%0.00%0.00%
Sep-060.00%0.00%0.00%
Aug-060.00%0.00%0.00%
Jul-060.00%0.00%0.00%
Jun-060.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%

&F &A &12Attachment 8 Tables &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-14
Jun-14
Mar-14
Dec-13
Sep-13
Jun-13
Mar-13
Dec-12
Sep-12
Jun-12
Mar-12
Dec-11
Sep-11
Jun-11
Mar-11
Dec-10
Sep-10
Jun-10
Mar-10
Dec-09
BenchmarkSep-14
Jun-14
Mar-14
Dec-13
Sep-13
Jun-13
Mar-13
Dec-12
Sep-12
Jun-12
Mar-12
Dec-11
Sep-11
Jun-11
Mar-11
Dec-10
Sep-10
Jun-10
Mar-10
Dec-09

&F &A &12Attachment 8 Tables &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-140.0%
Jun-140.0%
Mar-140.0%
Dec-130.0%
Sep-130.0%
Jun-130.0%
Mar-130.0%
Dec-120.0%
Sep-120.0%
Jun-120.0%
Mar-120.0%
Dec-110.0%
Sep-110.0%
Jun-110.0%
Mar-110.0%
Dec-100.0%
Sep-100.0%
Jun-100.0%
Mar-100.0%
Dec-090.0%
BenchmarkSep-140.0%
Jun-140.0%
Mar-140.0%
Dec-130.0%
Sep-130.0%
Jun-130.0%
Mar-130.0%
Dec-120.0%
Sep-120.0%
Jun-120.0%
Mar-120.0%
Dec-110.0%
Sep-110.0%
Jun-110.0%
Mar-110.0%
Dec-100.0%
Sep-100.0%
Jun-100.0%
Mar-100.0%
Dec-090.0%

&F &A &12Attachment 8 Tables &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-140.0%
Jun-140.0%
Mar-140.0%
Dec-130.0%
Sep-130.0%
Jun-130.0%
Mar-130.0%
Dec-120.0%
Sep-120.0%
Jun-120.0%
Mar-120.0%
Dec-110.0%
Sep-110.0%
Jun-110.0%
Mar-110.0%
Dec-100.0%
Sep-100.0%
Jun-100.0%
Mar-100.0%
Dec-090.0%
BenchmarkSep-140.0%
Jun-140.0%
Mar-140.0%
Dec-130.0%
Sep-130.0%
Jun-130.0%
Mar-130.0%
Dec-120.0%
Sep-120.0%
Jun-120.0%
Mar-120.0%
Dec-110.0%
Sep-110.0%
Jun-110.0%
Mar-110.0%
Dec-100.0%
Sep-100.0%
Jun-100.0%
Mar-100.0%
Dec-09

&F &A &12Attachment 8 Tables &T &D

Table10

Enter Firm Name in Cell B1
Enter Product Name in Cell B2
CountrySep-14Jun-14Mar-14Dec-13Sep-13Jun-13Mar-13Dec-12Sep-12Jun-12Mar-12Dec-11Sep-11Jun-11Mar-11Dec-10Sep-10Jun-10Mar-10Dec-09
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%

&F &A &12Attachment 8 Tables &T &D

Table11

Enter Firm Name in Cell B1
Enter Product Name in Cell B2
QualitySep-14Jun-14Mar-14Dec-13Sep-13Jun-13Mar-13Dec-12Sep-12Jun-12Mar-12Dec-11Sep-11Jun-11Mar-11Dec-10Sep-10Jun-10Mar-10Dec-09
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%

&F &A &12Attachment 8 Tables &T &D

Table12

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

&F &A &12Attachment 8 Tables &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

&F &A &12Attachment 8 Tables &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/14
2013
2012
2011
2010
2009
2008
2007
2006
2005
2004

&F &A &12Attachment 8 Tables &T &D

Table15

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

&F &A &12Attachment 8 Tables &T &D

Table16

Enter Firm Name in Cell B1
Enter Product Name in Cell B2
Risk Statistics3 Years Ended 9/30/145 Years Ended 9/30/1410 Years Ended 9/30/14Since 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"

&F &A &12Attachment 8 Tables &T &D

Table17

Enter Firm Name in Cell B1
Enter Product Name in Cell B2
9/30/1412/31/1312/31/1212/31/1112/31/1012/31/09
(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

&F &A &12Attachment 8 Tables &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/14)

&F &A &12Attachment 8 Tables &T &D

Sheet1

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