PORTFOLIO MANAGEMENT SOFTWARE: SYMPRO

1
PORTFOLIO MANAGEMENT SOFTWARE SYMPRO

• SEAN POLLAND
• TREASURY MANAGER
• ORANGE COUNTY COMPTROLLERS OFFICE

2
Agenda

• SymPro Portfolio Management Software
• Investment Software Benefits
• SymPro Background
• Modules
• Orange Countys SymPro Structure
• Portfolio Setup
• Select Investment Types
• Investment Entry
• Treasury Bond
• Posting interest
• Maturity or sale
• Discount Note
• Managed Pool
• Transaction entries for pools
• Market Pricing
• Fiscal Year-End Close
• Reports
• Report Sets
• Earnings Allocation

3
Investment Software Benefits

• Reduce errors
• More efficient use of time
• Verification of dealer quotes and transaction
  proceeds
• Improves transparency and oversight

4
SymPro Background

• Subsidiary of JPMorgan Chase
• Orange County has been a client since 1995
• 90 of clients are local or state governments
• Portfolio sizes range from 50 million to more
  than 2 billion

5
SymPro Modules

• Fixed Income
• Debt
• Cash Flow
• Market Pricing
• GL Interface
• Earnings Allocation
• Financial Services

6
Orange Countys Structure

• Two portfolios utilized for portfolio management
• Board (ORNG)
• Comptroller (COMP)
• Approximately 12 portfolios maintained for
  accountants. These accounts are used to allocate
  earnings. Examples
• Capital Improvement Bonds AIM (CIBS)
• Convention Center SBA (CCSB)
• Water Utilities SBA (WWSB)
• Solid Waste SBA (RRSB)

7
Portfolio Setup
8
Select Investment Types
9
Investment Entry Treasury Bond
10
Posting Interest
11
Maturity or Sale
12
Investment Entry Discount Note
13
Investment Entry Managed Pool
14
Transaction Entries for Pools
15
Market Pricing

• Automated pricing available
• Orange County enters prices manually
• Download prices from custodian
• Update prices on last day of each month
• Historical prices maintained in SymPro

16
Fiscal Year-End Close

• Post interest due
• Review reports and make corrections
• Backup database in case an error occurs
• Reindex files
• Archive, or copy, portfolio to be closed
• Close Portfolio

17
Reports

• Portfolio management report
• Six sub-reports that provide a complete analysis
  of the portfolio on a monthly basis
• Total Return
• Maturing Investments
• Investment Listings
• Investment by Classification
• Various Interest Reports
• Compliance Reporting
• Many additional reports available

18
Report Sets

• Allows creation of batch reports
• You can also run reports by
• Funds
• A list of funds
• Range of funds
• Diminished use since Orange County pooled
  enterprise funds

19
Earnings Allocation

• Orange County allocates pool earnings in its
  accounting system
• All other funds have interest allocated in
  SymPro, and manually entered into the accounting
  system
• SymPro allocates earnings on managed pools and
  money market mutual funds
• SymPro distributes earnings based on average
  daily balance

20
Allocation Entry Screen
21
Competing Product

• Tracker C2 Investment Group
• Web-based portfolio management system

22

• Sean Polland, Treasury Manager
• Orange County Comptrollers Office
• 201 S. Rosalind Avenue, 4th Floor
• Orlando, Florida 32801
• Phone [phone]
• Fax [phone]
• E-mail sean.polland_at_occompt.com