Collin_College_Fund_Line-up_for_403b_10-2024.xlsx
XLSX spreadsheet 26 KB Posted
- Attached to
- 403(b) Record Keeper RFP
- Solicitation number
- FY2025-RFP-007
- Issued by
- Collin County, Texas
About this file
The document is an Excel spreadsheet detailing the current mutual fund lineup for Collin College's 403(b) retirement plan, associated with a Request for Proposal (RFP) for 403(b) recordkeeping services in Texas. The RFP seeks a sole recordkeeper for the Collin Invests Enhanced Retirement Savings Plan, with a planned implementation in the second half of 2025. The current fund lineup includes 47 different investment options across asset classes such as fixed income, large cap, mid cap, small cap, hybrid, global and international equity, and specialty funds, with a total portfolio value of approximately $47.8 million.
Collin College offers this voluntary 403(b) plan alongside state-sponsored retirement options like the Teacher Retirement System (TRS) and Optional Retirement Program (ORP), with a notable feature of a 100% match on the first 4% of employee contributions for full-time employees. The spreadsheet provides detailed information on each fund, including ticker symbols, fund codes, fund names, asset classes, units/shares, unit/share values, and end values. The plan appears to be primarily composed of Vanguard index funds, target-date retirement funds, and a mix of equity and fixed-income investments, reflecting a diversified approach to employee retirement savings.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| 403(b)_Record_Keeper_RFP.pdf | ||
| Procurement_Planning.pdf | ||
| OpenGov_Procurement_Guide_-_Requester_04022024.pdf | ||
| Yearly_Purchasing_Training_December_2022.pptx | PPTX presentation | |
| Review_and_Signatory_Authority_01262024.pdf | ||
| Collin_College_Recordkeeper_RFP_Background_and_Plan_Data_11-2024.docx | DOCX document | |
| Collin_College_Recordkeeper_RFP_Questionnaire_11-2024.docx | DOCX document | |
| Legal_Review_of_Contracts.docx | DOCX document | |
| Standard_Addendum_to_Agreement.docx | DOCX document |
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
All
| PLAN | TICKER SYMBOL | FUND CODE | FUND NAME | ASSET CLASS | UNITS/SHARES | UNIT/SHARE VALUES | END VALUE |
| 001 | FB001 | FIXED ACCOUNT PLUS | FIXED INCOME | 0.000000 | $1,127,034.22 | ||
| 001 | FB125 | FIXED INTEREST OPTION | FIXED INCOME | 0.000000 | $1,619,464.07 | ||
| 001 | FP002 | SHORT TERM FIXED ACCOUNT | FIXED INCOME | 0.000000 | $507,502.63 | ||
| 001 | L997E | LOAN ESCROW FUND | $160.64 | ||||
| 001 | L997L | LOAN COLLATERAL FUND | $3,991.48 | ||||
| 001 | L997P | PLAN LOAN | $321,769.07 | ||||
| 001 | VBTLX | M4922 | VANGUARD TL BD MK IDX ADM | FIXED INCOME | 174,379.869482 | $9.87 | $1,721,129.24 |
| 001 | VFIAX | M4931 | VANGUARD 500 IDX ADM | LARGE CAP | 6,736.274553 | $531.71 | $3,581,744.33 |
| 001 | VIMAX | M4940 | VAN MID CAP INDEX ADM | MID CAP | 2,449.279062 | $326.75 | $800,301.99 |
| 001 | VMFXX | M4947 | VANGUARD FED MONEY MARKET INV | FIXED INCOME | 862,541.782818 | $1.00 | $862,541.77 |
| 001 | VSMAX | M4958 | VANGUARD SM CP IDX ADM | SMALL CAP | 14,035.182324 | $113.70 | $1,595,800.34 |
| 001 | VTINX | M4961 | VANGUARD TGT RTMT INC | HYBRID | 38,511.853333 | $13.83 | $532,618.90 |
| 001 | VTIVX | M4962 | VANGUARD TGT RTMT 2045 | HYBRID | 80,952.929372 | $30.82 | $2,494,969.29 |
| 001 | VTTHX | M4966 | VANGUARD TGT RTMT 2035 | HYBRID | 184,219.623864 | $25.13 | $4,629,439.11 |
| 001 | VTTVX | M4967 | VANGUARD TGT RTMT 2025 | HYBRID | 126,767.555361 | $20.45 | $2,592,396.50 |
| 001 | VAIPX | M5130 | VANGUARD INF PRO SEC ADML | FIXED INCOME | 19,991.329895 | $23.62 | $472,195.22 |
| 001 | VFIFX | M5231 | VANGUARD TGT RTMT 2050 | HYBRID | 34,725.348419 | $51.71 | $1,795,647.76 |
| 001 | VFORX | M5232 | VANGUARD TGT RTMT 2040 | HYBRID | 106,305.790564 | $45.04 | $4,788,012.75 |
| 001 | VTHRX | M5233 | VANGUARD TGT RTMT 2030 | HYBRID | 114,051.531208 | $39.93 | $4,554,077.70 |
| 001 | VTWNX | M5234 | VANGUARD TGT RTMT 2020 | HYBRID | 40,349.637156 | $29.42 | $1,187,086.34 |
| 001 | RERGX | M5585 | AMERICAN EUROPACIFIC GROWTH R6 | GLOBAL & INTL EQUITY | 4,241.719457 | $60.36 | $256,030.22 |
| 001 | VFFVX | M5824 | VANGUARD TGT RTMT 2055 | HYBRID | 13,833.894647 | $57.71 | $798,353.99 |
| 001 | RNPGX | M5923 | AMERICAN NEW PERSPECTIVE R6 | GLOBAL & INTL EQUITY | 27,219.432241 | $66.10 | $1,799,204.45 |
| 001 | PRILX | M6013 | PARNASSUS CORE EQUITY INSTL | LARGE CAP | 7,359.548007 | $65.16 | $479,548.17 |
| 001 | VTTSX | M6047 | VANGUARD TGT RTMT 2060 | HYBRID | 3,412.360068 | $53.17 | $181,435.23 |
| 001 | PFORX | M6364 | PIMCO INTL BOND FD INST | FIXED INCOME | 30,668.541588 | $10.00 | $306,685.32 |
| 001 | PIMIX | M6379 | PIMCO INCOME INSTL | FIXED INCOME | 37,525.968876 | $10.79 | $404,905.20 |
| 001 | HLMEX | M6382 | HARDING LOEVNER INST EMRG MKTS | GLOBAL & INTL EQUITY | 20,907.402493 | $20.55 | $429,646.97 |
| 001 | VTIAX | M6407 | VANGUARD TOT INTL STCK IDX ADM | GLOBAL & INTL EQUITY | 56,650.534958 | $34.81 | $1,972,005.10 |
| 001 | JGMNX | M6626 | JANUS HENDERSON TRITON N | SMALL CAP | 9,072.671868 | $29.79 | $270,274.90 |
| 001 | WFPRX | M6627 | ALLSPRING SP MD CP VAL FUND R6 | MID CAP | 2,907.958667 | $53.55 | $155,721.19 |
| 001 | TSBIX | M6971 | TIAA-CREF SOC CHOICE BND INSTL | FIXED INCOME | 11,008.418454 | $9.21 | $101,387.53 |
| 001 | MFEKX | M6991 | MFS GROWTH R6 | LARGE CAP | 4,828.020575 | $217.75 | $1,051,301.51 |
| 001 | PEQSX | M6993 | PUTNAM LARGE CAP VALUE FUND R6 | LARGE CAP | 45,343.504171 | $37.27 | $1,689,952.26 |
| 001 | VLXVX | M7150 | VANGUARD TARGET RETIRE 2065 | HYBRID | 3,422.727156 | $34.86 | $119,316.29 |
| 001 | DVZRX | M7153 | DELAWARE SMALL CAP VALUE R6 | SMALL CAP | 304.962543 | $78.22 | $23,854.17 |
| 001 | BAGIX | M7257 | BAIRD AGGREGATE BOND INST | FIXED INCOME | 12,996.540720 | $10.07 | $130,875.13 |
| 001 | PFRSX | M7282 | PRINCIPAL REAL ESTATE SEC R6 | SPECIALTY | 17,261.329093 | $30.93 | $533,892.88 |
| 001 | BMGKX | M7513 | BLACKROCK MID CAP GRWTH EQ K | MID CAP | 17,267.377446 | $41.71 | $720,222.34 |
| 001 | VA004 | MID CAP INDEX FUND | MID CAP | 1,707.540898 | $41.09 | $70,158.02 | |
| 001 | VA008 | GOVERNMENT SECURITIES FUND | FIXED INCOME | 2,491.146252 | $3.62 | $9,006.63 | |
| 001 | VA010 | STOCK INDEX FUND | LARGE CAP | 6,842.271535 | $25.56 | $174,859.29 | |
| 001 | VA011 | INTERNATL EQUITIES INDEX FUND | GLOBAL & INTL EQUITY | 11,131.505879 | $2.90 | $32,332.19 | |
| 001 | VA012 | INTL SOCIALLY RESPONSIBLE FUND | GLOBAL & INTL EQUITY | 590.493342 | $10.39 | $6,133.15 | |
| 001 | VA013 | INTERNATIONAL GOVERNMENT BOND | FIXED INCOME | 5,539.970141 | $3.00 | $16,635.23 | |
| 001 | VA014 | SMALL CAP INDEX FUND | SMALL CAP | 3,223.434631 | $11.31 | $36,471.47 | |
| 001 | VA016 | SYSTEMATIC CORE FUND | LARGE CAP | 5,056.613123 | $9.91 | $50,099.42 | |
| 001 | VA017 | SCIENCE & TECHNOLOGY FUND | SPECIALTY | 6,538.299592 | $19.97 | $130,568.99 | |
| 001 | VA020 | INTERNATIONAL GROWTH FUND | GLOBAL & INTL EQUITY | 544.242933 | $5.01 | $2,727.93 | |
| 001 | VA021 | DIVIDEND VALUE | LARGE CAP | 248.434841 | $5.55 | $1,379.33 | |
| 001 | VA022 | VANGUARD LT INV-GRADE FUND | FIXED INCOME | 4,726.814052 | $3.80 | $17,946.52 | |
| 001 | VA023 | VANGUARD LONG-TERM TREASURY | FIXED INCOME | 414.136900 | $3.07 | $1,273.22 | |
| 001 | VA024 | VANGUARD WINDSOR II | LARGE CAP | 9,109.678207 | $9.01 | $82,098.97 | |
| 001 | VA025 | VANGUARD WELLINGTON FUND INC | HYBRID | 987.853957 | $7.68 | $7,590.78 | |
| 001 | VB046 | NASDAQ-100(R) INDEX FUND | LARGE CAP | 7,851.290630 | $5.17 | $40,584.87 | |
| 001 | VB052 | VANGUARD LIFESTRATEGY GROWTH | HYBRID | 10,439.759532 | $4.16 | $43,387.50 | |
| 001 | VB053 | VANGUARD LIFESTRATEGY MODERA | HYBRID | 306.442564 | $3.54 | $1,083.94 | |
| 001 | VB054 | VANGUARD LIFESTRATEGY CONSER | HYBRID | 156.506421 | $2.85 | $445.51 | |
| 001 | VB068 | ARIEL FUND | SMALL CAP | 3,712.646348 | $6.21 | $23,042.33 | |
| 001 | VB069 | ARIEL APPRECIATION FUND | MID CAP | 1,270.624233 | $5.37 | $6,817.81 | |
| 001 | VB072 | SYSTEMATIC GROWTH FUND | LARGE CAP | 7,214.789392 | $5.44 | $39,241.71 | |
| 001 | VB075 | SYSTEMATIC VALUE | LARGE CAP | 737.305747 | $3.56 | $2,623.65 | |
| 001 | VB077 | INFLATION PROTECTED FUND | FIXED INCOME | 10,316.944575 | $1.48 | $15,228.65 | |
| 001 | VB078 | GROWTH FUND | LARGE CAP | 6,369.151078 | $5.57 | $35,506.07 | |
| 001 | VB079 | LARGE CAPITAL GROWTH | LARGE CAP | 5,756.412980 | $5.38 | $30,956.03 | |
| 001 | VB083 | MID CAP STRATEGIC GWTH | MID CAP | 6,038.844451 | $5.50 | $33,196.14 | |
| 001 | VB084 | SMALL CAP SPECIAL VALUE FUND | SMALL CAP | 83.088014 | $3.26 | $270.93 | |
| 001 | VB087 | EMERGING ECONOMIES | GLOBAL & INTL EQUITY | 20,822.305531 | $1.26 | $26,233.12 | |
| 001 | VB088 | GLOBAL STRATEGY | GLOBAL & INTL EQUITY | 4,363.245079 | $2.46 | $10,739.04 | |
| 001 | VB089 | INTERNATIONAL VALUE FUND | GLOBAL & INTL EQUITY | 10,857.185297 | $1.77 | $19,197.25 | |
| 001 | VB101 | GLOBAL REAL ESTATE FUND | SPECIALTY | 4,625.216304 | $1.73 | $8,023.40 | |
| 001 | VB102 | INVESCO BAL RISK COMMOD STR R5 | SPECIALTY | 8,834.001782 | $0.83 | $7,362.96 | |
| 001 | VB107 | T ROWE PRICE RETIRMNT 2030 ADV | HYBRID | 9,560.963739 | $1.86 | $17,815.15 | |
| 001 | VB108 | T ROWE PRICE RETIRMNT 2035 ADV | HYBRID | 9,294.252804 | $1.97 | $18,292.50 | |
| 001 | VB110 | T ROWE PRICE RETIRMNT 2045 ADV | HYBRID | 211.107098 | $2.12 | $447.95 | |
| 001 | VB133 | INTL OPPORTUNITIES | GLOBAL & INTL EQUITY | 4,076.101237 | $3.45 | $14,069.17 | |
| 001 | VB135 | SMALL CAP GROWTH FUND | SMALL CAP | 1,124.347021 | $6.28 | $7,062.15 | |
| 001 | VB136 | SMALL CAP VALUE FUND | SMALL CAP | 924.811367 | $6.41 | $5,924.65 | |
| 001 | VB138 | MID CAP VALUE FUND | MID CAP | 1,078.194733 | $11.04 | $11,905.71 | |
| 001 | VB139 | VC I CAPITAL APPRECIATION | LARGE CAP | 1,073.817894 | $5.41 | $5,808.33 | |
| 001 | VB141 | US SOCIALLY RESPONSIBLE FUND | LARGE CAP | 4,883.802937 | $6.81 | $33,256.45 | |
| 001 | VB148 | AGGRESSIVE GROWTH LIFESTYLE | HYBRID | 5,805.944838 | $5.37 | $31,192.13 | |
| 001 | VB150 | VC I CONSERV GROWTH LIFESTYLE | HYBRID | 6,540.130558 | $3.87 | $25,325.73 | |
| 001 | VB158 | CORE BOND FUND | FIXED INCOME | 27,939.301043 | $2.20 | $61,395.95 | |
| 001 | VB160 | HIGH YIELD BOND FUND | FIXED INCOME | 4,889.172469 | $3.60 | $17,615.13 | |
| 001 | VB161 | GS VIT GOV MONEY MKT FD INST | FIXED INCOME | 685.599421 | $2.11 | $1,448.70 | |
| Total | 2,379,246.643839 | $47,847,277.95 | |||||
| Applied filters: |
GROUP_NUMBER is 40521 PLAN_NUMBER is 001 BEGIN_DATE is 09/01/2024 END_DATE is 09/30/2024 SECURITY_GROUP_NUMBER is 40521 SECURITY_PLAN_NUMBER is 001
Current MF line-up
| PLAN | TICKER SYMBOL | FUND CODE | FUND NAME | ASSET CLASS | UNITS/SHARES | UNIT/SHARE VALUES | END VALUE |
| 001 | FB001 | FIXED ACCOUNT PLUS | FIXED INCOME | 0 | $1,127,034.22 | ||
| 001 | L997P | PLAN LOAN | $321,769.07 | ||||
| 001 | VBTLX | M4922 | VANGUARD TL BD MK IDX ADM | FIXED INCOME | 174379.869482 | 9.87 | $1,721,129.24 |
| 001 | VFIAX | M4931 | VANGUARD 500 IDX ADM | LARGE CAP | 6736.274553 | 531.71 | $3,581,744.33 |
| 001 | VIMAX | M4940 | VAN MID CAP INDEX ADM | MID CAP | 2449.279062 | 326.75 | $800,301.99 |
| 001 | VMFXX | M4947 | VANGUARD FED MONEY MARKET INV | FIXED INCOME | 862541.782818 | 1 | $862,541.77 |
| 001 | VSMAX | M4958 | VANGUARD SM CP IDX ADM | SMALL CAP | 14035.182324 | 113.7 | $1,595,800.34 |
| 001 | VTINX | M4961 | VANGUARD TGT RTMT INC | HYBRID | 38511.853333 | 13.83 | $532,618.90 |
| 001 | VTIVX | M4962 | VANGUARD TGT RTMT 2045 | HYBRID | 80952.929372 | 30.82 | $2,494,969.29 |
| 001 | VTTHX | M4966 | VANGUARD TGT RTMT 2035 | HYBRID | 184219.623864 | 25.13 | $4,629,439.11 |
| 001 | VTTVX | M4967 | VANGUARD TGT RTMT 2025 | HYBRID | 126767.555361 | 20.45 | $2,592,396.50 |
| 001 | VAIPX | M5130 | VANGUARD INF PRO SEC ADML | FIXED INCOME | 19991.329895 | 23.62 | $472,195.22 |
| 001 | VFIFX | M5231 | VANGUARD TGT RTMT 2050 | HYBRID | 34725.348419 | 51.71 | $1,795,647.76 |
| 001 | VFORX | M5232 | VANGUARD TGT RTMT 2040 | HYBRID | 106305.790564 | 45.04 | $4,788,012.75 |
| 001 | VTHRX | M5233 | VANGUARD TGT RTMT 2030 | HYBRID | 114051.531208 | 39.93 | $4,554,077.70 |
| 001 | VTWNX | M5234 | VANGUARD TGT RTMT 2020 | HYBRID | 40349.637156 | 29.42 | $1,187,086.34 |
| 001 | RERGX | M5585 | AMERICAN EUROPACIFIC GROWTH R6 | GLOBAL & INTL EQUITY | 4241.719457 | 60.36 | $256,030.22 |
| 001 | VFFVX | M5824 | VANGUARD TGT RTMT 2055 | HYBRID | 13833.894647 | 57.71 | $798,353.99 |
| 001 | RNPGX | M5923 | AMERICAN NEW PERSPECTIVE R6 | GLOBAL & INTL EQUITY | 27219.432241 | 66.1 | $1,799,204.45 |
| 001 | PRILX | M6013 | PARNASSUS CORE EQUITY INSTL | LARGE CAP | 7359.548007 | 65.16 | $479,548.17 |
| 001 | VTTSX | M6047 | VANGUARD TGT RTMT 2060 | HYBRID | 3412.360068 | 53.17 | $181,435.23 |
| 001 | PFORX | M6364 | PIMCO INTL BOND FD INST | FIXED INCOME | 30668.541588 | 10 | $306,685.32 |
| 001 | PIMIX | M6379 | PIMCO INCOME INSTL | FIXED INCOME | 37525.968876 | 10.79 | $404,905.20 |
| 001 | HLMEX | M6382 | HARDING LOEVNER INST EMRG MKTS | GLOBAL & INTL EQUITY | 20907.402493 | 20.55 | $429,646.97 |
| 001 | VTIAX | M6407 | VANGUARD TOT INTL STCK IDX ADM | GLOBAL & INTL EQUITY | 56650.534958 | 34.81 | $1,972,005.10 |
| 001 | JGMNX | M6626 | JANUS HENDERSON TRITON N | SMALL CAP | 9072.671868 | 29.79 | $270,274.90 |
| 001 | WFPRX | M6627 | ALLSPRING SP MD CP VAL FUND R6 | MID CAP | 2907.958667 | 53.55 | $155,721.19 |
| 001 | TSBIX | M6971 | TIAA-CREF SOC CHOICE BND INSTL | FIXED INCOME | 11008.418454 | 9.21 | $101,387.53 |
| 001 | MFEKX | M6991 | MFS GROWTH R6 | LARGE CAP | 4828.020575 | 217.75 | $1,051,301.51 |
| 001 | PEQSX | M6993 | PUTNAM LARGE CAP VALUE FUND R6 | LARGE CAP | 45343.504171 | 37.27 | $1,689,952.26 |
| 001 | VLXVX | M7150 | VANGUARD TARGET RETIRE 2065 | HYBRID | 3422.727156 | 34.86 | $119,316.29 |
| 001 | DVZRX | M7153 | DELAWARE SMALL CAP VALUE R6 | SMALL CAP | 304.962543 | 78.22 | $23,854.17 |
| 001 | BAGIX | M7257 | BAIRD AGGREGATE BOND INST | FIXED INCOME | 12996.54072 | 10.07 | $130,875.13 |
| 001 | PFRSX | M7282 | PRINCIPAL REAL ESTATE SEC R6 | SPECIALTY | 17261.329093 | 30.93 | $533,892.88 |
| 001 | BMGKX | M7513 | BLACKROCK MID CAP GRWTH EQ K | MID CAP | 17267.377446 | 41.71 | $720,222.34 |
| $44,481,377.38 | |||||||
| Total | 2379246.643839 | $47,847,277.95 | |||||
| Applied filters: |
GROUP_NUMBER is 40521 PLAN_NUMBER is 001 BEGIN_DATE is 09/01/2024 END_DATE is 09/30/2024 SECURITY_GROUP_NUMBER is 40521 SECURITY_PLAN_NUMBER is 001
Fund List no assets
| TICKER SYMBOL | FUND NAME | ASSET CLASS |
| Your Fixed / Guaranteed Account | Guaranteed / Stable Value | |
| WFMIX | Allspring Special Mid Cap Value Inst | MID CAP VALUE |
| RERGX | AMERICAN EUROPACIFIC GROWTH R6 | GLOBAL EQUITY |
| RNPGX | AMERICAN NEW PERSPECTIVE R6 | Foreign Large EQUITY |
| BAGIX | BAIRD AGGREGATE BOND INST | Intermediate Core Bond |
| CMGIX | BlackRock Mid-Cap Growth Equity Inst. | MID CAP GROWTH |
| DEVIX | Delaware Small Cap Value Instl. | SMALL CAP VALUE |
| FPADX | Fidelity Emerging markets Equity Index | Diversified Emerging Mkts Eq. |
| JGMNX | JANUS HENDERSON TRITON N | SMALL CAP GROWTH |
| MFEHX | MFS Growth R3 | LARGE CAP GROWTH |
| PRILX | PARNASSUS CORE EQUITY INSTL | LARGE Blend |
| PIMIX | PIMCO INCOME INSTL | Multisector Bond |
| PFORX | PIMCO INTL BOND (USD-Hdg) FD INST | Global Bond - USD Hedged |
| PIREX | Principal Real Estate Securities Inst | Real Estate |
| PEIYX | Putnam Large Cap Value Y | LARGE CAP VALUE |
| TSBIX | Nuveen Core Impact Bond R6 | Intermediate Core Bond |
| VIMAX | VAN MID CAP INDEX ADM | MID CAP Blend |
| VFIAX | VANGUARD 500 IDX ADM | LARGE Blend |
| VMRXX | Vanguard Cash Reserve Fed MM Admin | Taxable Money Market |
| VAIPX | VANGUARD INF PRO SEC ADML | Inflation-Protected Bond |
| VSMAX | VANGUARD SM CP IDX ADM | SMALL Blend |
| VLXVX | VANGUARD TARGET RETIRE 2065 | Target Date |
| VTWNX | VANGUARD TGT RTMT 2020 | Target Date |
| VTTVX | VANGUARD TGT RTMT 2025 | Target Date |
| VTHRX | VANGUARD TGT RTMT 2030 | Target Date |
| VTTHX | VANGUARD TGT RTMT 2035 | Target Date |
| VFORX | VANGUARD TGT RTMT 2040 | Target Date |
| VTIVX | VANGUARD TGT RTMT 2045 | Target Date |
| VFIFX | VANGUARD TGT RTMT 2050 | Target Date |
| VFFVX | VANGUARD TGT RTMT 2055 | Target Date |
| VTTSX | VANGUARD TGT RTMT 2060 | Target Date |
| VTINX | VANGUARD TGT RTMT INC | Target Date |
| VBTLX | VANGUARD TL BD MK IDX ADM | Intermediate Core Bond |
| VTIAX | VANGUARD TOT INTL STCK IDX ADM | Foreign Large EQUITY |
File details come from the government source that posted it. Updated .