RFP_Attachment_13%20GASB_Investment-Option%20Monthly%20Reporting%20Template.xlsx
XLSX spreadsheet 16 KB Posted
- Solicitation number
- RFP 30901-65526
- Issued by
- Davidson County, Tennessee
About this file
This is a GASB Investment-Option Monthly Reporting Template for the State of Tennessee's Optional Retirement Program and Public Higher Education 403(b) Plans recordkeeping and administration services. The template is designed to track consolidated monthly activity across retirement plan accounts, including beginning and ending balances of plan assets and participant accounts. The reporting framework captures contributions from multiple sources (participant/employee, employer, and loan contributions), transfers (rollover contributions, provider transfers, and interfund transfers), withdrawals and deductions (normal distributions, retirement, severance of employment, qualified domestic relation orders, and annuity settlements), investment income from interest, dividends, and changes in value, and administration costs reflected as fees. The template also includes detailed loan activity tracking (short-term and long-term balances, interest assessed, loan payments, and distributed loans) and forfeiture/asset holding activity with corresponding beginning and ending balances.
The Investment Summary Report section of the template provides detailed investment performance metrics for each investment option offered within the plans, including GAAP hierarchy classifications, average credit ratings, average effective maturity, effective duration, and fixed income percentages. Investment options tracked include equity, blended, fixed income, self-directed brokerage, and money market funds, each identified by ticker symbol or identifier with corresponding beginning balances, contributions, transfers, fees, withdrawals, and ending balances. The template concludes with participant count summaries categorizing currently employed participants with ending account balances, terminated employees with remaining balances, and participants with zero ending account balances, providing comprehensive visibility into plan membership and account status.
View the file
Other files
Show all 27
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
Monthly Activity Report
| Consolidated Monthly Activity Report |
| Vendor Name: Plan Name |
| Beginning of Month Date to End of Month Date |
Beginning Balance of Plan Assets: $ XXX,XXX,XXX
Beginning Participant Balance: XXX,XXX, XXX
| Contributions/Deposits: | ||
| Participant/Employee Contributions | XXX,XXX | |
| Employer Contributions | XXX,XXX | |
| Loan Contributions | XXX,XXX | |
| Additional Deposits: | XX | |
| XXX,XXX |
| Transfers: | ||
| Rollover Contributions | XXX,XXX | |
| Provider Transfer in | XXX,XXX | |
| Provider Transfer out | (XXX,XXX) | |
| Interfund Transfer In | XXX,XXX | |
| Interfund Transfer Out | (XXX,XXX) | |
| XXX,XXX |
| Withdrawals/Deductions: | ||
| Normal Distributions | (XXX,XXX) | |
| Withdrawals | (XXX,XXX) | |
| Retirement | (XXX,XXX) | |
| Severence of Employment | (XXX,XXX) | |
| Qualified Domestic Relation Orders: | (XXX,XXX) | |
| Annuity Settlement Option | (XXX,XXX) | |
| Other Deductions | (XXX,XXX) | |
| (XXX,XXX) |
| Investment Income: | ||
| Interest and Dividends | XX | |
| Change in Value | XXX,XXX | |
| XXX,XXX |
Administration Cost:
| Fees | (XX) | |
| XX | ||
| Ending Participant Balance as of End Date: | XXX,XXX, XXX |
| Unallocated Contributions: | XX | ||||
| XX | |||||
| Loan Activity: | |||||
| Beginning Short-term Balance: | XXX | ||||
| Beginning Long-term Balance: | XXX | ||||
| (Refinanced)/Loans Issued | XXX | ||||
| Interest Assessed | XXX | ||||
| Loan Payments | (XXX) | ||||
| Distributed Loans | (XXX) | ||||
| Ending Short-term Balance: | XXX | ||||
| Ending Long-term Balance: | XXX |
| Forfeiture/Asset Holding: | |||||
| Beginning Balance: | XXX | ||||
| Contributions: | XXX | ||||
| Forfeitures | XXX | ||||
| Plan Servicing Credit | XX | ||||
| Transfer in | XXX | ||||
| Transfer Out | (XXX) | ||||
| Interest/Dividend | XXX | ||||
| Change in Value | XXX | ||||
| Ending Balance: | XXX |
Ending Balance of Plan Assets: $ XXX,XXX,XXX
Investment Summary Report
| Investment Summary Report |
| Vendor Name: Plan Name |
| As of Date |
| Investment Option: | Beginning Balance: | Contributions/Deposits: | Additional Deposits: | Transfers In: | Interest/Dividends: | Change in Value: | Transfers Out: | Fees: | Withdrawals: | Ending Balance: | Investment Type: | GAAP Hierarchy | Average Credit Rating: | Average Effective Maturity: | Effective Duration: | % of Fixed Income |
| TICKER/Identifier | XXX,XXX | XXX,XXX | XXX,XXX | XX | (XXX) | (XXX,XXX) | (XX) | (XXX,XXX) | XXX,XXX | Equity | Level 1 | |||||
| TICKER/Identifier | XXX,XXX | XXX,XXX | XXX,XXX | XX | (XXX,XXX) | (XX) | (XXX,XXX) | XXX,XXX | Blended | Level 1 | 92.51% B or Better | 9.96 | 6.98 | 14.72% | ||
| TICKER/Identifier | XXX,XXX | XXX,XXX | XXX,XXX | XXX,XXX | XX | (XXX) | (XXX,XXX) | (XX) | (XXX,XXX) | XXX,XXX | Fixed Income | Level 2 | 97.92% A or Better | 8.72 | 6.91 | 100.00% |
| TICKER/Identifier | XX | XXX,XXX | XXX,XXX | XX | (XXX,XXX) | (XX) | (XXX,XXX) | XX | Self-Directed Brokerage | Level 1 | ||||||
| TICKER/Identifier | XXX,XXX | XXX,XXX | XXX,XXX | (XX) | (XX) | (XXX,XXX) | (XX) | (XXX,XXX) | XXX,XXX | Money Market | ||||||
| Totals: | XXX,XXX | XXX,XXX | XXX,XXX | XXX,XXX | XX | (XXX) | (XXX,XXX) | (XX) | (XXX,XXX) | XXX,XXX | ||||||
| Legend of Investment Option | ||||||||||||||||
| TICKER/Identifier | Investment Name | |||||||||||||||
| TICKER/Identifier | Investment Name | |||||||||||||||
| TICKER/Identifier | Investment Name | |||||||||||||||
| Participant Counts | ||||||||||||||||
| Currently Employed and have Ending Account Balance: | XXXXX | |||||||||||||||
| Terminated Employment and have Ending Account Balance: | XXXXX | |||||||||||||||
| Participants with a Zero Ending Account Balance: | XXXXX |
File details come from the government source that posted it. Updated .