The URL can be used to link to this page

Home My Public Portal About05 May 21, 2012 Budget & Implementation" " " TIME: DATE: LOCATION: RIVERSIDE COUNTY TRANSPORTATION COMMISSION BUDGET AND IMPLEMENTATION COMMITTEE MEETING AGENDA 9:30a.m. Monday, May 21, 2012 RECORDS CONFERENCE ROOM A -PLEASE NOTE LOCATION CHANGE County of Riverside Administrative Center 4080 Lemon Street, Third Floor, Riverside '8'-COMMITTEE MEMBERS ~ Rick Gibbs, Chair/ Kelly Bennett, City of Murrieta Ella Zanowic Vice Chair I Jeff Hewitt, City of Calimesa Roger Berg I Jeff Fox, City of Beaumont Mary Craton I Barry Talbot, City of Canyon Lake Greg Pettis I Kathleen DeRosa, City of Cathedral City Steven Hernandez I Eduardo Garcia, City of Coachella Scott Matas, I Yvonne Parks, City of Desert Hot Springs Larry Smith I Robert Youssef, City of Hemet Douglas Hanson I Patrick Mullany, City of Indian Wells Bob Magee I Melissa Melendez, City of Lake Elsinore Steve Adams I Andy Melendrez, City of Riverside Ron Roberts I Jeff Comerchero, City of Temecula John F. Tavaglione, County of Riverside, District II Jeff Stone, County of Riverside, District Ill '�'-STAFF~ Anne Mayer, Executive Director Theresia Trevino, Chief Financial Officer '�'-AREAS OF RESPONSIBILITY ~ Annual Budget Development and Oversight Competitive Federal and State Grant Programs Countywide Communications and Outreach Programs Countywide Strategic Plan Legislation Public Communications and Outreach Programs Short Range Transit Plans Comments are welcomed by the Committee. If you wish to provide comments to the Committee, please complete and submit a Speaker Card to the Clerk of the Board. " " " Tara Byerly From: Sent: To: Subject: Importance: Tara Byerly Wednesday, May 16, 2012 12:08 PM Tara Byerly RCTC May Budget and Implementation Committee Agenda for lpad Users High Good Afternoon Budget and Implementation Committee Members: Attached below is the link to the Budget and Implementation Committee agenda for the meeting scheduled@ 9:30a.m. on Monday, May 21 in Conference Room A on the 3'd Floor. Please let me know if you have any questions or concerns. http://www. rete .erg/uploads/media items/budget-and-implementation-march-26-201 2 -ipad-compatible- agenda .original. pdf Respectfully, TaraS. Byerly Senior Administrative Assistant 4080 Lemon Street, 3rd Floor Riverside, CA 92501 (951) 787-7141 1 Tara Byerly From: Sent: To: Cc: Subject: Attachments: Importance: Tara Byerly Wednesday, May 16, 2012 3:57PM Tara Byerly Jennifer Harmon IMPORTANT-Conflict of Interest Memo for the Budget and Implementation Committee-May 21,2012 Conflict of Interest Memo. pdf; Conflict of Interest Form.pdf High Good Afternoon Budget and Implementation Committee Members: Attached above is a conflict of interest memo for your review and the conflict of interest form for the meeting scheduled on Monday, May 21 @ 9:30a.m. in Conference Room A on the 3'd Floor. Please let me know if you have any questions or concerns. Respectfully, Tara$. Byerly Senior Administrative Assistant 4080 Lemon Street, 3rd Floor Riverside, CA 92501 (951) 787-7141 1 Riverside County Transportation Commission TO: Riverside County Transportation Commission FROM: Jennifer Harmon, Office and Board Services Manager DATE: May 16, 2012 SUBJECT: Possible Conflicts of Interest Issues -Budget and Implementation Committee Agenda of May 21, 2012 The May 21, 2012 agenda of the Budget and Implementation Committee includes items which may raise possible conflicts of interest. A RCTC member may not participate in any discussion or action concerning a contract or amendment if a campaign contribution of more than $250 is received in the past 12 months or 3 months following the conclusion from any entity or individual listed. Agenda Item No.9-Recurring Contracts for Fiscal Year 2012/13 Consultant(s): Fieldman, Rolapp & Associates Daniel Wiles, Principal 19900 MacArthur Boulevard, Suite 110 Irvine, CA 92612 Agenda Item No. 10 -Agreement with PlanetBids for Online Vendor and Bid Management System PlanetBids, Inc. Alan Zavian, President and CEO 5850 Canoga A venue, Suite 301 Woodland Hills, CA 91367 " " " RIVERSIDE COUNTY TRANSPORTATION COMMISSION BUDGET AND IMPLEMENTATION COMMITTEE www.rctc.org AGENDA* *Actions may be taken on any item listed on the agenda 9:30a.m. Monday, May 21, 2012 PLEASE NOTE fHEJJ/JEETING :/:DCA TION CONFERENCE ROOM A County Administrative Center 4080 Lemon Street, :rd Floor Riverside, California In compliance with the Brown Act and Government Code Section 54957.5, agenda materials distributed 72 hours prior to the meeting, which are public records relating to open session agenda items, will be available for inspection by members of the public prior to the meeting at the Commission office, 4080 Lemon Street, Third Floor, Riverside, CA, and on the Commission's website, www.rctc.org. In compliance with the Americans with Disabilities Act and Government Code Section 54954.2, if you need special assistance to participate in a Committee meeting, please contact the Clerk of the Board at (951) 787-7141. Notification of at least 48 hours prior to meeting time will assist staff in assuring that reasonable arrangements can be made to provide accessibility at the meeting. 1 . CALL TO ORDER 2. PLEDGE OF ALLEGIANCE 3. ROLL CALL 4. PUBLIC COMMENTS -Each individual speaker is limited to speak three (3) continuous minutes or less. The Committee may, either at the direction of the Chair or by majority vote of the Committee, . waive this three minute time limitation. Depending on the number of items on the Agenda and the number of speakers, the Chair. may, at his/her discretion, reduce the time of each speaker to two (2) continuous minutes. Also, the Committee may terminate public comments if such comments become repetitious. In addition, the maximum time for public comment for any individual item or topic is thirty (30) minutes. Speakers may not yield their time to others without the consent of the Chair. Any written documents to be distributed or presented to the Committee shall be submitted to the Clerk of the Board. This policy applies to Public Comments and comments on Agenda Items. Budget and Implementation Committee May 21, 2012 · Page 2 Under the Brown Act, the Board should not take action on or discuss matters raised during public comment portion of the agenda which are not listed on the agenda. Board members may refer such matters to staff for factual information or to be placed on the subsequent agenda for consideration. 5. APPROVAL OF MINUTES-APRIL 23, 2012 6. ADDITIONS/REVISIONS (The. Committee may add an item to the Agenda after making a finding that there is a need to take immediate action on the item and that the item came to the attention of the Committee subsequent to the posting of the agenda. An action adding an item to the agenda requires 2/3 vote of the Committee. If there are less than 2/3 of the Committee members present, adding an item to the agenda requires a unanimous vote. Added items will be placed for discussion at the end of the agenda.) 7 · CONSENT CALENDAR -All matters on the Consent Calendar will be approved in a single motion unless a Commissioner(s) requests separate action on specific item(s). Items pulled from the Consent Calendar will be placed for discussion at the end of the agenda. • 7 A. QUARTERLY SALES TAX ANALYSIS Page 1 • Overview This item is for the Committee to: 1 )· Receive and file the sales tax analysis for Quarter 4 (04) 2011; and 2) Forward to the Commission for final action. 7B. APPROPRIATIONS LIMIT FOR FISCAL YEAR 2012/13 Page9 Overview This item is for the Committee to: 1) Approve Resolution No. 12-017, "Resolution of the Riverside County Transportation Commission Establishing the Commission's Appropriations Limit for Fiscal Year 2012/13"; and 2) Forward to the Commission for final action. • " " " Budget and Implementation Committee May21,2012 Page 3 7C. ANNUAL INVESTMENT POLICY REVIEW Page 16 Overview This item is for the Committee to: 1) Adopt Resolution No. 12-0161 "Resolution of the Riverside County Transporta"tion Commission Regarding the Revised Investment Policy"; 2) Adopt the Annual Investment Policy; and 3) Forward to the Commission for final action. 7D. QUARTERLY INVESTMENT REPORT Page 32 Overview This item is for the Committee to: 1 ) Receive and file the Quarterly Investment Report for the quarter ended March 31 I 201 2; and 2) Forward to the Commission for final action. 8. PROPOSED BUDGET FOR FISCAL YEAR 2012113 � Page 51 Overview This item is for the Committee to: 1) Receive input on the proposed Budget for FY 2012/13; 2) Forward to the Commission to close the public hearing to receive input on the proposed Budget for FY 2012113; and 3) Adopt the proposed Budget for FY 2012/13. 9. RECURRING CONTRACTS FOR FISCAL YEAR 2012/13 Overview Page 55 This item is for the Committee to: 1) Approve the recurring contracts for FY 2012/13; 2) Authorize the Chair I pursuant to legal counsel review I to execute the agreements on behalf of the Commission; and 3) Forward to the Commission for final action. Budget and Implementation Committee May 21, 2012 Page 4 10. AGREEMENT WITH PLANETBIDS FOR ONLINE VENDOR AND BID • MANAGEMENT SYSTEM Page 62 Overview This item is for the Committee to: 1) Approve Agreement No. 12-19-091-00 with PlanetBids, Inc. (PianetBids) for the use of the PlanetBids BidsOnline vendor and bid management system software for a three-year term, and two one-y~ar . options to extend the agreement, in an amount not to exceed $65,000; 2) Authorize the Chair, pursuant to legal counsel review, to execute the agreement on behalf of the Commission; and 3) Forward to the Commission for final action. 11. FISCAL YEAR 2012/13 SB 821 BICYCLE AND PEDESTRIAN FACILITIES PROGRAM FUNDING RECOMMENDATIONS Page 73 Overview This item is for the Committee to: 1) Approve the FY 201 2/13 SB 821 Bicycle and Pedestrian Facilities Program (SB 821 program) recommended funding; and 2) Forward to the Commission for final action. 12. ITEM(S) PULLED FROM THE CONSENT CALENDAR 13. COMMISSIONERS I STAFF REPORT Overview This item provides the opportunity for the Commissioners and staff to report on attended and upcoming meeting/conferences and issues related to Commission activities. 14. ADJOURNMENT AND NEXT MEETING The next budget and Implementation Committee meeting is scheduled to be held at 9:30 a.m., Monday, June 25, 2012, Board Chambers, First Floor, County Administrative Center, 4080 lemon Street, Riverside. • • RIVERSIDE COUNTY TRANSPORTATION COMMISSION BUDGET AND IMPLEMENTATION COMMITTEE ROLL CALL MAY 21, 2012 · County of Riverside, District II County of Riverside, District Ill City of Beaumont . City of Calimesa City of Canyon lake City of Cathedral City City of Coachella City of Desert Hot Springs City of Hemet City of Indian Wells City of lake Elsinore City of Murrieta City of Riverside City of Temecula Present Absent ·n ;zf (] D t:1 ;t [] D j;r' D LJ D ;:r D RIVERSIDE COUNTY TRANSPORTATION COMMISSION BUDGET AND IMPLEMENTATION COMMITTEE SIGN-IN SHEET MAY 21, 2012 NAME AGENCY E MAIL ADDRESS R f cv( (-;; $~~ /1 vi /J-k(~CZ.:/r) , &~A 2 £>.-.. " ~'-<..?' ~ /l ' ~i-~-s~ RoN c~~~ -; &Ml<JL-1 YJo,J!Jff_ £/-If2/CS. lJu~t..er-~ s~~1!l6-~ d,;::? b ~-Y\~ A.o.t--1. />~A v ;:rJ ~1/1 l ) ~ VVA \ C1.f J-4 J-L::?\.Y't( Gv" Tn ,..,j,·/. __., \1\{oJ C r14 l!u. ~-._) 1111 CtC. f () ~;/:f __&(S:V7~ JIL./~ ~~~ ~~n v I~ ·-:::r~~...J \)'~ l..\.0~ ~\JC..C1'X... 5.,. •• w., ....... ~ ... ~...,.. ........... ~ " AGENDA ITEM 5 " MINUTES " " " " " " RIVERSIDE COUNTY TRANSPORTATION COMMISSION BUDGET AND IMPLEMENTATION COMMITTEE Monday, April 23, 2012 MINUTES 1. CALL TO ORDER The meeting of the � Budget and Implementation Committee was called to order by Chair Rick Gibbs at 9:30a.m., in the Board Room at the County of Riverside Administrative Center, 4080 Lemon Street, First Floor, Riverside, California, 92501. 2. PLEDGE OF ALLEGIANCE 3. 4. At this time, Commissioner Ella Zanowic led the Budget and Implementation Committee in a flag salute . ROLL CALL Members/ Alternates Present Roger Berg* Mary Craton Rick Gibbs Douglas Hanson Steven Hernandez* Bob Magee* Scott Matas Greg Pettis Ron Roberts Larry Smith Jeff Stone* John Tavaglione Ella Zanowic Members Absent . Steve Adams *Arrived after the meeting was called to order PUBLIC COMMENTS There were no requests to speak from the public . RCTC Budget and Implementation Committee Minutes April 23, 201 2 Page 2 5. APPROVAL OF MINUTES -FEBRUARY 27, 2012 M/S/C (Zanowic/Craton) to approve the minutes of February 27, 2012 meeting as submitted. 6. ADDITIONS I REVISIONS There are no additions/revisions to the agenda. 7. CONSENT CALENDAR -All matters on the Consent Calendar will be approved in a single motion unless a Commissioner(s) requests separate action on specific item(s). Items pulled from the Consent Calendar will be placed for discussion at the end of the agenda. M/S/C (Craton/Matas) to approve the following Consent Calendar item(s): 7 A. SINGLE SIGNATURE AUTHORITY REPORT 1) 2) Receive and file the Single Signature Authority report for the third quarter ended March 31, 2012; and Forward to the Commission for final action. At this time, Commissioners Roger Berg, Bob Magee, and Jeff Stone arrived at the meeting. 8. PROPOSED BUDGET FOR FISCAL YEAR 2012/13 Michele Cisneros, Accounting and Human Resources Manager, presented the proposed Budget for FY 2012/13, and discussed the following areas: • Budget process; • FY 2012/13 budget considerations; • Budget summary; • Sources by breakdown and comparison; • Expenditures by department, expenditure breakdown by department; and comparison; • Capital department expenditure highlights; • Function expenditures breakdown and comparison; and • Next steps. • •• • " " " RCTC Budget and Implementation Committee Minutes April 23, 2012 Page 3 In response to Commissioner Mary Craton's question regarding investment income, Michele Cisneros replied the investment income is high due to the State Route 91 Corridor Improvement Project (SR-91 CIP), which includes the toll revenue bonds, sales bonds, and the Transportation Infrastructure Finance and Innovation Act (TIFIA) program loan, however, interest rates are projected to remain flat. Commissioner Zanowic expressed apprec1at1on to Michele Cisneros for her excellent presentation of the proposed FY 2012/13 Budget. Chair Gibbs noted the budget includes a cost of living and merit-based increase for staff. He stated it is important to note staff has extremely specialized knowledge and after three years without any type of increase, it is an extremely prudent action for the Commission to take. M/S/C (Stone/Craton) to: 1) 2) Discuss, review, and provide guidance on the proposed FY 2012/13 Budget; and Open the public hearing in order to receive input and comments on the proposed FY 2012/13 Budget on May 9 and on June 7, 2012, and thereafter close the public hearing. 9. AMENDMENT TO RIVERSIDE TRANSIT AGENCY AND SUNLINE TRANSIT AGENCY'S FISCAL YEAR 2011/2012 SHORT RANGE TRANSIT PLANS Fina Clemente,� Transit Manager, presented the amendments to the Riverside Transit Agency's (RTA) and Sunline Transit Agency's (Sunline) FY 2011/12 Short Range Transit Plans (SRTPs). At this time, Commissioner Steven Hernandez arrived at the meeting. In response to Commissioner Douglas Hanson's concern regarding Sunline's farebox revenue compared to its ridership, Fina Clemente explained Sunline hired a new planner, who discovered the prior planner estimated Sunline's farebox revenue to include Measure A funds. Sunline's new planner separated the difference to only represent the farebox revenue amount. At Commissioner Hanson's request, Fina Clemente provided an overview of Section 5307 funding and how it applies to Sunline . RCTC Budget and Implementation Committee Minutes April 23, 2012 Page 4 Theresia Trevino, Chief Financial Officer, then provided additional information regarding Measure A funds allocated to Sunline, related to its farebox recovery ratio. Commissioner Hanson requested justification for the additional Air Quality Management District (AOMD) grant funds to SunLine for the special transit services for Coachella and Stagecoach Festivals. Anne Mayer replied the funds came through the Mobile Source Air Pollution Reduction Review Committee (MSRC) and referred to Tanya Love, Goods Movement Manager. Tanya Love explained the MSRC budget and funding allocation process as well as Sunline's original and revised funding requests. Commissioner Greg Pettis added MSRC will receive a ridership report from SunLine on the number of passengers that utilized Sunline's expanded service. He then asked with the additional grants and reconfiguring the allocation if it results in any reduction of funds from the Commission to Sunline. Fina Clemente replied these funds are federal funds. Therefore, this does not impact the Commission's budget for this year and the Commission's direct subsidy to Sunlihe remains the same. Commissioner Hanson . discussed his concerns regarding Sunline's profitability and that Sunline would be subsidized for the additional service. Commissioner Pettis explained the festival promoters chartered every available private bus operator from Riverside and San Bernardino Counties, and Phoenix, Arizona. Commissioner Pettis discussed Sunline's service and the attempts to provide special trains from Los Angeles into the Coachella Valley for the festivals. Anne Mayer stated the goal of the AOMD grant program is to reduce single occupancy vehicles for special events, and the results will be in the validation of the ridership numbers submitted to MSRC. Commissioner Roger Berg asked why SunLine's grant fund request was done after the special events occurred and expressed there are other operators that could use the grant funds for special events. • • • " " " " RCTC Budget and Implementation Committee Minutes April 23, 2012 Page 5 Anne Mayer replied the Commission is only amending the SRTP after the MSRC competitive process for the special events. Tanya Love replied the MSRC competitive process is an open call for projects, which will remain open until the funds are exhausted. She also discussed Sunline's timeline and process for the funding request. Commissioner Pettis stated MSRC hopes the city of Hemet will apply for its festivals as there is $210,000 remaining set aside for Riverside County and none of the cities are requesting these funds. Chair Gibbs requested a report is brought forward to the Commission with an update on the MSRC call for projects once the ridership numbers come in. Anne Mayer stated staff can communicate the opportunities to each of the jurisdictions about MSRC's open call for projects. She stated in terms of a process if any of the Commission's agencies obtain a grant outside the normal funding source from another entity, the Commission's only role is to amend the operator's SRTP to include this funding source, evaluate the impact on its overall program, and ensure operator compliance . M/S/C (Pettis/Matas) to: 1) Approve modification to Riverside Transit Agency's (RTA) FY 2011 I 12 capital improvement program to reflect an additional $2.065 million in Section 5309 State of Good Repair (SGR) program funds and $5,889,196 in FY 2010/11 Proposition 1 B Capital and Security grant funding; 2) Allocate $1.305 million in Transportation Development Act (TDA) Local Transportation Fund (l TF) funds to provide capital matching funds for the FY 20 11 I 12 Section 5309 program funds awarded to RT A for its paratransit revenue vehicle purchase and facility rehabilitation projects; 3) Approve modification to RT A's FY 2011 I 12 operating assistance funding by allocating up to $19,000 in 1989 Measure A Western Riverside County Highway funds to implement a temporary shuttle service Route 54 to support the State Route 91 high occupancy vehicle (HOV) lanes 4) construction project; Approve modification to Sunline Transit Agency's (Sunline) FY 2011 I 12 operating assistance funding by reflecting a net increase of $83,698 resulting from an increase in federal Section 5307 funds ( + $1 ,026,623), reduction in projected RCTC Budget and Implementation Committee Minutes A~ril 23, 2012 Page 6 farebox revenues (-$834, 774), a decrease in fuel rebates (-$150,000), and additional Air Quality Management District (AQMD) grant funds ( + $41 ,849) for the special transit services for Coachella and Stagecoach Festivals; 5) Approve modification to Sunline's FY 2011/12 capital assistance funding by reflecting an additional $4,917,876 in federal Section 5308 Transit Investments for Greenhouse Gas and Energy Reduction (TIGGER) funds for fuel cell bus purchases and an additional $546,430 in Section 5307 funds for paratransit buses and facility improvement in lieu of TDA State Transit Assistance (STA) funds; 6) Allocate $546,430 in STA funds to provide capital matching funds for the FY 2011/12 Section 5308 program funds awarded to Sunline for the fuel cell buses; 7) Approve amendments to RTA and Sunline's Short Range Transit Plans (SRTP) to reflect the changes outlined above; and 8) Forward to the Commission for final action. 10. CITY OF RIVERSIDE'S AMENDED BICYCLE TRANSPORTATION PlAN · Jillian Edmiston, Staff Analyst, presented the city of Riverside's amended Bicycle Transportation Plan .. M/S/C (Stone/Craton) to: 1) Approve the city of Riverside's (Riverside) amended Bicycle· Transportation Plan (BTP) as submitted; and 2) Forward to the Commission for final action. 11. UPDATE ON STATE AND FEDERAl lEGISlATION Aaron Hake, Government Relations Manager, presented the bill positions and an overview of federal and state legislative activities. MlS/C (Tavaglione/Matas) to: 1) 2) 3) Receive and file an update on the state and federal legislation; Adopt the following bill positions: a) AB 2405 (Biumenfield) -Oppose; b) AB 1780 (Bonilla) -Support; c) AB 2498 (Gordon) -Support In Concept; d) SB 1549 (Vargas) -Support In Concept; and Forward to the Com'mission for final action. • • • " " " RCTC Budget and Implementation Committee Minutes April 23, 2012 Page 7 12. ITEM(S) PUllED FROM CONSENT CALENDAR AGENDA There were no items pulled from the Consent Calendar. 13. COMMISSIONERS I EXECUTIVE DIRECTOR REPORT 14. 13A. Anne Mayer announced: " Due to the Memorial Day holiday, the May Committees are scheduled for May 21, 2012, in RCTC Conference Room A on the Third Floor; and " Due to the Board of Supervisors' Budget hearing, the June Commission meeting is scheduled for Thursday, June 7, 2012. ADJOURNMENT AND NEXT MEETING There being no further business for consideration by the Budget and Implementation Committee, the meeting was adjourned at 10:21 a.m. The next meeting of the Budget and Implementation Committee is scheduled for May 21, 2012 at 9:30 a.m . Respectfully submitted, Jennifer Harmon Clerk of the Board " " " " AGENDA ITEM 7A " " " " " " " " RIVERSIDE COUNTY TRANSPORTATION COMMISSION DATE: May 21, 2012 TO: Budget and Implementation Committee FROM: Theresia Trevino, Chief Financial Officer THROUGH: John Standiford, Deputy Executive Director SUBJECT: Quarterly Sales Tax Analysis STAFF RECOMMENDATION: This item is for the Committee to: 1) Receive and file the sales tax analysis for Quarter 4 (Q4) 2011; and 2) Forward to the Commission for final action. BACKGROUND JNFORMA TION: At its December 2007 meeting, the Commission awarded an agreement to MuniServices, LLC (MuniServices) for quarterly sales tax reporting services plus additional fees contingent on additional sales tax revenue generated from the transactions and use tax (sales tax) audit services. The services performed under this agreement pertain to only the Measure A sales tax revenues. Since the commencement of these services, MuniServices submitted an audit update, which reported findings that have been generated and submitted to the State Board of Equalization (SBOE) for review and determination of errors in sales tax reporting related to 222 businesses. Through Q4 2011 for October through December 2011, the SBOE has approved corrections for 156 of these accounts for a total sales tax revenue recovery of $2,016,315. If. the SBOE concurs with the error(s) for the remaining claims, the Commission would receive additional revenues; however, the magnitude of the value of the remaining findings was not available. It is important to note that while the recoveries of additional revenues will be tangible, it will not be sufficient to alter the overall trend of sales tax revenues. Additionally, MuniServices provided the Commission with the quarterly sales tax summary report for the fourth quarter of calendar year 2012 for October through December 2011 (Q4 2011 ). Most of the Q4 2011 Measure A sales tax revenues was received by the Commission in the first quarter of calendar 2012, during January through March 2012, due to a lag in the sales tax calendar. The summary section of the Q4 2011 report is attached and includes an overview of California Agenda Item 7 A 1 . sales tax receipts, local results, historical cash collections analysis, summary of the top 25 sales tax contributors, historical sales tax amounts, sales tax by business category, economic trends for significant business category (general retail), and results. The following observations were noted in the Q4 2011 report: • Sales tax receipts for Riverside County were 1 0 percent higher compared to the Q4 2010, and slightly higher than the state. This supports the previous quarterly reports' analyses that an economic recovery statewide and locally is underway; however, the Commission should continue to be· cautious as service stations is one of the top three economic segments throughout the state leading this recovery. A significant portion of this growth is attributable to the high fuel prices. • Taxable transactions for the top 25 tax contributors in Riverside County, which generated 23 percent of the taxable sales for the year ended Q4 2011, were comparable to the year ended Q4 2010. The top 100 tax contributors generated 37 percent of the taxable sales in Q4 2011 and 04 2010. • For the fourth consecutive period, all economic categories experienced increases in the Q4 2011 benchmark year comparison to Q4 2010. Transportation had the largest increase at 19 percent, which was primarily related to the service station segment increase. Construction had the next highest increase at 9.9 percent, which was primarily related to a new business in the building materials-wholesale segment. The remaining four economic categories had increases ranging from 2.8 percent to 6.8 percent. General Retail: Apparel Stores, Department Stores, Furniture/Appliances, Drug Stor.es, Recreation Products, Florist/Nursery, and Misc. Retail Food Products: Restaurants, Food Markets, Liquor Stores, and Food Processing Equipment Construction: Building Materials Retail and Building Materials Wholesale Transportation: Auto Parts/Repair, Auto Sales-New, Auto Sales-Used, Service Stations, and Misc. Vehicle Sales Business to Business: Office Equip., Electronic Equip., Business Services, Energy Sales, Chemical Products, Heavy Industry, light Industry, and leasing Miscellaneous: Health & Government. Miscellaneous Other, and Closed Account Adjustments • Eight of the top 1 0 segments (service stations, department stores, restaurants, auto sales-new, miscellaneous retail, building materials- wholesale, apparel stores, and food markets) sales reached a new high point during Q4 2011. Agenda Item 7 A 2 • • • " " " " Service stations, department stores, and restaurants continue to represent the three largest economic segments for Riverside County, or 35 percent of total sales taxes. Auto sales-new represents the fourth largest economic segment at 9.1 percent of total sales taxes. Service Department Department Service Service Largest Segment Restaurants Restaurants Restaurants Restaurants Stations Stores Stores Stations Stations % ofT otal I% Change. 12.9 I 22.1 13.0 I 5.7 13.8 I 6.9 12.8 I 2.5 14.8 I 3.1 13.9 I 5.9 12.9 I 21.1 14.4 I 16.5 19.9 I 4.0 2nd Largest Segment Department Department Department Service Service Service Department Department Service Stores Stores Stores Stations Stations Stations Stores Stores Stations % ofTotal I% Change . 11.8 I 3.3 10.8 I 3.8 9.7 I 4.3 10.9 I 18.1 12.4 I 25.6 10.8 I 21.9 11.2 I 2.2 12.5 I 1.8 10.1 I 22.1 3rd Largest Segment Restaurants Service Stations Service Stations Restaurants Restaurants Department Stores Restaurants Restaurants Mise Retail % ofTotal I% Change 10.3 I 5.3 10.8 I 22.2 9.3 I 23.6 10.4 I 1.0 96 I 4.0 1o.s I 4.2 10.6 I 4.8 9.7 I 2.0 10.1 I -0.9 During the review of the 04 2011 detailed report with MuniServices, information regarding sales tax comparisons by city and change by economic category from 04 2010 to 04 2011 was provided, and is attached. Newly incorporated cities such as Eastvale and Jurupa Valley will be listed when sufficient comparative information is available. Staff continues to monitor monthly sales tax receipts and other available economic data to determine the need for any adjustment to the revenue projections. Staff will utilize the forecast scenarios included. with the complete report and recent trends in assessing such projections. Attachments: 1) Sales Tax Analysis 04 2011 2) Sales Tax Comparison by City for 04 2010 to 04 2011 Agenda Item 7 A 3 " " " " " " Riverside County Transportation Commission Sales Tax Digest Summary Collections through March 2012 Sales through December 2011 (2011Q4) CALIFORNIA'S ECONOMIC OUTLOOK For the 4th Quarter of 2011, overall California sales tax receipts increased by 8.0% over the same quarter from the previous year, with Northern California reporting an 8.4% increase compared to 7.7% for Southern California. Receipts for the RCTC changed by 10.0% over the same periods. The state appears to be in a midst of a modest, drawn-out recovery. New-car dealerships sold 1.29 million new cars and trucks in 2011 -a 9.9% improvement over 2010. They should see an additional 8.5% growth in 2012. Though the construction, agriculture and food services industries have barely kept pace with inflation, high-technology industries, the professional services sector and a robust global demand for California's exports are prim!)rily responsible for an economic growth rate that is now keeping pace with the national rate. Senior Economist, Jerry Nickelsburg from UCLA predicts that California's employment growth will be 1.4% for 2012 and 2.1% for 2013. The state labor market should continue to improve, with a projected payroll growth of 1.2% for 2012 and 2.0% for 2013. Existing home sales were up in 2011 compared to 2010; but at the expense of falling prices. Though the state housing market is still struggling to regain price stability, foreclosure rates for the 4th Quarter of 2011 dropped to the second-lowest level in more than four years. The worst may be over for California. We can expect slow and steady growth as we rebuild a healthy, well-balanced economy. LOCAL RESULTS Net Cash Receipts Analysis local Collections Share of County Pool 0.0% Share of State Pool 0.0% SBE Net Collections less: Amount Due County 0.0% less: Cost of Administration Net 4Q2011 Receipts Net 4Q2010 Receipts Actual Percentage Change Business Activity Performance Analysis local Collections less: Payments for Prior Periods www.MuniServices.com (BOO) 800-8181 4 $35,727,662 0 0 35,727,662 .00 (329,200) 35,398,462 32,194,968 10.0% $35,727,662 (1,927,672) Pagel Riverside County Transportation Commission Preliminary 4Q2011 Collections Projected 4Q2011 Late Payments Projected 4Q2011 Final Results Actual 4Q2010 Results Projected Percentage Change HISTORICAL CASH COLLECTIONS ANALYSIS BY QUARTER " $25,000 " " = $20,000 ~ $15,000 $10,000 ss,ooo. $0 (in tbousands of$) 33,799,990 735,180 34,535,170 31,996,447 7.9% 3Q2009 4Q2009 1Q2010 2Q2010 3Q2010 4Q2010 1Q2011 2Q2011 3Q2011 4Q2011 L~Net Receipts ---sBOE Admio Fees D~ TOP 25 SALES/USE TAX CONTRIBUTORS $350 S300 $250 "" " S200 ·-a ... $150 < Sl 00. $50 so The following list identifies RCTC's Top 25 Sales/Use Tax contributors. The list is in alphabetical order and represents sales from. The Top 25 Sales/Use Tax contributors generate 22.8% of RCTC's total sales and use tax revenue. BEST BUY STORES CARMAX THE AUTO SUPERSTORE CHEVRON SERVICE STATIONS CIRCLE K FOOD STORES COSTCO WHOLESALE DEPT OF MOTOR VEHICLES DESERT SUNLIGHT HOME DEPOT K MART STORES KOHL'S DEPARTMENT STORES LOWE'S HOME IMPROVEMENT MACY'S DEPARTMENT STORE MOBIL SERVICE STATIONS www.MuniServices.com RALPH'S GROCERY COMPANY RITE AID DRUG STORES ROSS STORES SAM'S CLUB SEARS ROEBUCK & COMPANY SHELL SERVICE STATIONS STATER BROS MARKETS TARGET STORES VERIZON WIRELESS W.W. GRAINGER WAL MART STORES WALGREEN'S DRUG STORES (BOO) 800-8181 5 Page2 • • • " " " Riverside County Transportation Commission HISTORICAL SALES TAX AMOUNTS The following chart shows the sales tax level from sales through December 2011, the highs, and the lows for each segment over the last two years. $18,000 $16,000 $14,000 $12,000 s1 o;ooo $8,000 $6,000 $4,000 $2,000 $0 (in thousands of$) ... ~ ~~~.� \.r ~~.,� ot." .. ~ ~"' o"' ~<, ' ~" "'"' ~"' " " ..... ~ .. ~~.o ~ "'' "'"' ~ .. .... ~ \.0 .. ~ <:{~ ~ ~-~ '!-~ "'"' .... ~ '!- ~ ..... ~ ANNUAL SALES TAX BY BUSINESS CATEGORY 4 Q 2 0 II 3Q2011 2Q2011 I Q 2 0 II 4Q2010 3Q2810 2Q2010 I Q 2 81 0 3Q2009 s 0 s 2 0 ,o 0 0 (in thousands of$) $40,000 $60,000 s 8 0,0 0 0 v ..... > ... ~ ~"' ~"' ~"' .... ~ '.:::-'" ~~ ...,_<> ~" ~1'-.. 00 v'~ ... ~ ~ $1 0 0 ,o 0 0 $120,000 $ 1 4 0 ,o 0 0 !" General Retail " Food Pr.oducts CJTraasportation " coa!ltructioo " BusioessTo Busioe.u " Misc:ellaneou.! J www.MuniServices.com (800) 800-8181 Page3 6 Riverside County Transportation Commission FIVE-YEAR ECONOMIC TREND: General Retail .--------------------------------------------------------------------------~ $12,000 Sl 0,000 s 8,00 0 s 6,00 0 $4,00 0 s 2,00 0 so FINAL RESULTS: July-September 2011 Sales local Net Cash Collections less: Pool Amounts less: Prior Quarter Payments Add: late Payments (in thousands of S) local Net Economic Collections after Adjustments Percent Change from July-September 2010 Sales MUNISERVICES' ON-GOING AUDIT RESULTS This Quarter $157,479 Total to Date $1,557,126 www.MuniServices.com (800) 800-8181 7 $30,820,537 ($-329,200) ($1,482,078) $1,683,442 $31,351,101 UP BY8.8% Page4 • • • ATTACHMENT MuniServices, LLC 8 " " " " AGENDA ITEM 78 " " " " " " " " RIVERSIDE COUNTY TRANSPORTATION COMMISSION DATE: May 21, 2012 11---------+- TO: Budget and Implementation Committee u-------+-- FROM: Michele Cisneros, Accounting and Human Resources Manager 11---------+- THROUGH: Theresia Trevino, Chief Financial Officer 11---------+- SUBJECT: Appropriations Limit for Fiscal Year 2012/13 !!::::===== STAFF RECOMMENDATION: This item is for the Committee to: 1) Approve Resolution No. 12-017, "Resolution of the Riverside County Transportation Commission Establishing the Commission's Appropriations, Limit for Fiscal Year 2012/13"; and 2) Forward to the Commission for final action. BACKGROUND INFORMATION: Section 7910 of the California Government Code implements Article XIIIB of the California Constitution by requiring each local jurisdiction to establish, by resolution, its appropriations limit for each fiscal year and to make documentation used to determine the appropriations limit available to the public 1 5 days prior to adoption of the resolution establishing the appropriations limit. Staff has performed the calculations necessary to determine the limit. The resolution and documents supporting the calculation are attached. The Commission chose to use the percentage change in the California per capital personal income and the population change within Riverside County as the factors m determining the appropriations limit. As required, the adoption of the Commission's FY 2012/13 Appropriations Limit was posted in the local newspaper. Attachments: 1) Resolution No. 12-017 2) California Per Capital Income and Population, Riverside County -California Department of Finance Agenda Item 7B 9 " " " " " " RESOLUTION NO. 12-017 RESOLUTION OF THE RIVERSIDE COUNTY TRANSPORTATION COMMISSION ESTABLISHING THE ANNUAL APPROPRIATIONS LIMIT For FY 2012/13 WHEREAS, Article XIIIB of the California Constitution places an annual limitation upon appropriations from proceeds of taxes by each local government of the State of California; and WHEREAS, in 1988, pursuant to Article XIIIB, section 4 of the California Constitution, the Riverside County Transportation Commission established its appropriations limit at $75 million for FY 1988/89 under ordinance No. 88-1; and WHEREAS, Section 791 0 of the California Government Code implements Article XIIIB of the California Constitution by requiring each local jurisdiction to establish, by resolution, its appropriations limit for each fiscal year and to make the documentation used in determining the appropriations limit available to the public 15 days _prior to adoption of the resolution establishing the appropriations limit; and WHEREAS, in accordance with Senate Constitutional Amendment No. 1 approved by the voters of the state effective June 6, 1990, beginning with FY 1990/91 and for each fiscal year thereafter, the Commission's Board of Commissioners is required to select either the percentage change in California per capita personal income or the percentage change in the local assessment roll due to the addition of local non-residential construction, and either the population change within the Commission or the population change within Riverside County, as the two factors to be applied in calculating the appropriations limit for each fiscal year; and WHEREAS, this Board wishes to select, as factors in determining the Commission's appropriation limit for FY 2012/13 the percentage change in California per capita personal income and also the population change within Riverside County; and WHEREAS, this Commission has documented its calculations of the Commission's appropriations limit for FY 2012/13 and said calculations have been made available to the public at least 15 days prior to the adoption of this resolution . 10 NOW, THEREFORE, BE IT RESOLVED by the Board of Commissioners of the Riverside County Transportation Commission as follows: 1. For FY 2012/13, appropriations limit are (a) the personal income, and (b) the Riverside. the factors selected for calculating the percentage change in California per capita population change within the County of 2. The appropriations limit applicable to this agency pursuant to Article XIIIB of the California Constitution for FY 2012/13 are hereby established and determined to be $348,861,382. 3. A copy of the documentation used in the determination of the appropriations limit for FY 2012/13 shall be affixed hereto and shall be available for public inspection. 4. Pursuant to Section 791 0 of the California Government Code, any judicial action or proceeding to attack, review, set aside, void, or annul the establishment of the appropriations limit. as set forth herein must be commenced within forty-five days of the adoption of this resolution. ADOPTED this 7th day of June, 2012 .. John J. Benoit, Chair Riverside County Transportation Commission ATTEST: Jennifer Harmon, Clerk of the Board Riverside County Transportation Commission 11 • • • " " " RIVERSIDE COUNTY TRANSPORTATION COMMISSION 2012-2013 APPROPRIATIONS LIMIT 2011-2012 Appropriations Limit .................... $ 332,891,501 2012-2013 adjustment: Change in California per capita personal income = 3.77% Change in Population, Riverside County 0.99% Per Capital Cost of Living converted to a ratio: 3.77 + 100 ......................... . 1.0377 100 Population converted to a ratio: 0.99 + 100 ............... . 1.0099 100 Calculation of factor for FY 2011-2012: 1.0377 X 1.0099 = 1.04 797323 $ 332,891,501 X 1.04797323 = $ 348,861,382 2012-2013 Appropriations Limit .................... $ 348,861,382 Source: California per capita income -California Department of Finance Population, Riverside County -California Department of Finance 12 " " " " " " " May 2012 Dear Fiscal Officer: Subject: Price and Population Information Appropriations Limit The California Revenue and Taxation Code, Section 2227, mandates the Department of Finance (Finance) to transmit an estimate of the percentage change in population to local governments. Each local jurisdiction must use their percentage change in population factor for January 1, 2012, in conjunction with a change in the cost of living, or price factor, to calculate their appropriations limit for fiscal year 2012-2013. Enclosure I provides the change in California's per capita personal income and an example for utilizing the price factor and population percentage change factor to calculate the 2012-2013 appropriations limit. Enclosure II provides city and unincorporated county population percentage changes, and Enclosure IIA provides county and incorporated areas' summed population percentage change. The population percentage change data excludes federal and state institutionali.zed populations and military populations. Population Percent Change for Special Districts Some special districts must establish an annual appropriations limit. Consult the Revenue and Taxation Code, Section 2228 for further information regarding the appropriations limit. You can access the Code from the following website: "http://wwwleginfo.ca.gov/calaw.htmr check box: "Revenue and Taxation Code" and enter 2228 for the search term to learn more about the various population change factors available to special districts to calculate their appropriations limit Article XIII B, Section 9(C), of the State Constitution exempts certain special districts from the appropriations limit calculation mar:1date. Consult the following website: "htlp://www.feglnfo.ca:gov/.consti.artic!e 138" for additional information. Special districts required by law to calculate their appropriations limit must present the calculation as part of their annual audit. Any questions special districts have on this issue should be referred to their respective county for clarification, or to their legal representation, or to the law itself. No State agency reviews the local appropriations limits. Population Certification The population certification program applies only to cities and counties. Revenue and Taxation Code Section 11005.6 mandates Finance to automatically certify any population estimate that exceeds the current certified population with the State Controller's Office. Finance will certify the higher estimate to the State Controller by June 1, 2012. Please Note: Prior year's city population estimates may be revised. If you have any questions regarding this data, please contact the Demographic Research Unit at {916) 323-4086. ANAJ.MATOSANTOS Director By: .....---.. ~~ MICHAEL COHEN Chief Deputy Director Enclosures 13 Fiscal Year 2012-2013 May 2012 Enclosure I A. Price Factor: Article XIII B specifies that local jurisdictions select their cost-of-living factor to compute their appropriation limit by a vote of their governing body. The cost-of-living factor provided here is per capita personal income. If the percentage change in per capita personal income is selected, the percentage change to be used B. in setting the 2012-2013 appropriation limit is: · Per Capita Personal Income Fiscal Year (FY) Percentage change over prior year 2012-2013 3.77 Following is an example using sample population change and the change in California per·capita personal income as growth factors in computing a 2012-2013 appropriation limit. 2012-2013: Per Capita Cost of Living Change= 3.77 percent Population Change = 0.68 percent Per Capita Cost of Living converted to a ratio: Population converted to a ratio: Calculation of factor for FY 2012-2013: 14 3.77+100 =1.0377 100 0.68 + 100 = 1.0068 100 1.0377 X 1.0068 = 1.0448 • • • " " " Fiscal Year 2012-2013 Enclosure II Annual Percent Change in Population Minus Exclusions January 1, 2011 to January 1, 2012 and Total Population, January 1, 2012 Total County Percent Change ---Po11ulatiQn Minus Exclusions -Po11ulation City 2011-2012 1-1-11 1-1-12 1-1-2012 Riverside Banning 0.81 . 29,723 29,965 29,965 Beaumont 2.15 38,034 38,851 38,851 Blythe 0.98 13,201 13,330 20,400 Calimesa 1.11 7,910 7,998 7.998 Canyon Lake 0.78 10,606 10,689 10,689 Cathedral City 1.07 51,353 51,901 51,952 Coachella 1.37 41,339 41,904 41,904 Corona 0.96 153,047 154,520 154,520 Desert Hot Springs 1.32 27,277 27,638 27,638 East vale 2.80 54,090 55,602 55,602 Hemet 0.98 79,309 80,089 80,089 Indian Wells 0.90 4,990 5,035 5,035 Indio 1.62 76,817 78,065 78,065 lake Elsinore 1.40 52,149 52,879 53,024 La Quinta 1.03 37,688 38,075 38,075 Menifee 1.83 79,139 80,589 80,589 Moreno Valley 1.05 194,451 196,495 196,495 Murrieta 0.90 104,051 104,985 104,985 Norco 0.78 22,837 23,015 27,053 Palm Desert 1.13 48,920 49,471 49,471 Palm Springs 1.00 44,829 45,279 45,279 Perris 0.97 69,506 70,180 70,180 Rancho Mirage 0.60 17,399 17,504 17,504 Riverside 0.80 306,010 308,452 308,511 San Jacinto 0.86 44,421 44,803 44,803 Temecula 1.81 101,255 103,092 103,092 Wildomar 0.94 32,414 32,719 32,719 Unincorporated 3.05 451,347 452,725 453,089 County Total 0.99 2,194,112 2,215,850 2,227,577 (*) Exclusions include residents on federal military installations and group quarters residents in state mental institutions, state and federal correctional institutions and veteran homes . Page 1 15 " " " " AGENDA ITEM 7C " " " " " " RIVERSIDE COUNTY TRANSPORTATION COMMISSION DATE: May 21, 2012 TO: Budget and Implementation Committee FROM: Theresia Trevino, Chief Financial Officer THROUGH: John Standiford, Deputy Executive Director SUBJECT: Annual Investment Policy Review STAFF RECOMMENDATION: This item is for the Committee to: 1) Adopt Resolution No. 12-016, "Resolution of the Riverside County Transportation Commission Regarding the Revised Investment Policy"; 2) Adopt the Annual Investment Policy; and 3) Forward to the Commission for final action. BACKGROUND INFORMATION: " Section XIV of the Investment Policy requires an annual investment policy review and specifically states that the "Chief Financial Officer shall annually render to the Board a statement of investment policy, which the Board must consider at a public meeting. Any changes to the policy shall also be considered by the Board at a public meeting. " " Based on a review of the Investment Policy approved by the Commission on May 11, 2011, and consideration of changes to the California Government Code as of January 1, 2012, staff in consultation with the County Treasurer's Office staff has determined that changes should be made to: 1) Define basis of percentage limitations applicable to an investment; 2) Provide flexibility for the Chief Financial Officer to act immediately regarding 3) 4) 5) a security if a rating change brings it below a minimum specified rating requirement; Specify a maximum maturity for municipal bonds; Delete adjustable municipal notes and bonds which are generally covered by existing descriptions, as focus on long-term rates of issuer is similar to investor view of security; Limit repurchase agreements to tri-party agreements for safety purposes and to minimize counterparty risk; 16 Agenda Item 7C 6) 7) Revise policy for time deposits in genenc terms due to other available products; and Delete reference to use of performance benchmark as Commission currently invests most of its cash with the Riverside County Investment Pool Fund due to low interest rate environment. Attachments: 1) Resolution No. 12-016 2) Draft Investment Policy 17 Agenda Item 7C • • • " " " RESOlUTION NO. 12-016 RESOlUTION OF THE RIVERSIDE COUNTY TRANSPORTATION COMMISSION REGARDING THE REVISED INVESTMENT POliCY WHEREAS, the Riverside County Transportation Commission (the "Commission") currently retains the authority to add, delete or otherwise modify the Commission's policies and procedures. NOW, THEREFORE, the Riverside County Transportation Commission does hereby resolve as follows: Section 1. The Riverside County Transportation Commission hereby adopts the Investment Policy, as revised on June 7, 2012, and attached as Exhibit A . APPROVED AND ADOPTED this 7th day of June, 2012. ATTEST: Jennifer Harmon � Oerk of the Board John J. Benoit, Chair Riverside County Transportation Commission 18 " " " " " " " Ri'lersid~ County Tron~portnrioo (nmmissirm INVESTMENT POLICY I. Introduction The purpose of this document is to identify policies and procedures that enhance opportunities for a prudent investment program and to organize and formalize investment-related activities. II. Scope Ill. It is intended that this Policy cover all funds (except retirement funds) and investment activities under the direction of the Commission. Delegation of Authority Pursuant to the Commission's Administrative Code, the Board's management responsibility for the investment program is hereby delegated for a one-year period to the Executive Director who shall monitor and review all investments for consistency with this investment policy. Subject to review, the Board may renew the delegation of authority pursuant to this section each year. The Executive Director may delegate these duties to his designee ("Chief Financial Officer"). The Commission may delegate its investment decision making and execution authority to an investment advisor. The advisor shall follow this Policy and such other written instructions as are provided. IV. Prudence All persons authorized to make investment decisions on behalf of the Commission are subject to the prudent investor standard. Investments shall be made with care, skill, prudence and diligence under circumstances then prevailing, including, but not limited to, the general economic conditions and the anticipated needs of the Commission that a prudent person acting in a like capacity and familiarity with those matters would use in the conduct of funds of a like character and with like aims, to safeguard the principal and maintain the liquidity needs of the Commission . I Revised May 11,?011June7,2012 19 Authorized individuals acting in accordance with this Policy and written procedures and exercising due diligence shall be relieved of personal responsibility for an individual security's credit risk or market price changes, provided deviations from expectations are reported in a timely fashion. V. Objective The Commission's primary investment objectives, in priority order, shall be: 1. Safety. Safety of principal is the foremost objective of the investment program. Investments of the Commission shall be undertaken in a manner that seeks to ensure preservation of capital in the portfolio. 2. Liquidity. The investment portfolio of the Commission will remain sufficiently liquid to enable the Commission to meet its cash flow requirements. 3. Return on Investment. The investment portfolio of the Commission shall be designed with the objective of maximizing return on its investments, but only after ensuring safety and liquidity. The Commission may from time to time sell securities that it owns in order to better reposition its portfolio assets in accordance with updated cash flow schedules, yield opportunities existing between market sectors, or simply market timing. VI. Investments California Government Code Section 53601 governs the investments permitted for purchase by the Commission. Within the investments permitted by Code, the Commission seeks to further restrict eligible investments to the investments listed in Section VI. 1 below. Percentage limitations applicable to. an investment, where indicated, apply a twill be based on the market values of investments as of the time of each purchase. Percentage holdings with any one non-U.S. Government issuer or non- Federal Agency issuer are further restricted to a maximum of 1 0% (direct and indirect commitments). Rating requirements where indicated, apply at the time of purchase. In the event a security held by the Commission is subject to a rating change that brings it below the minimum specified rating requirement, the Chief Financial Officer shall be authorized to act immediately and to notify the Board of the changeany actions taken in regards to the security. The Chief Financial Officer's course of action te--be I Revised May 11, 2011June 7, 2012 20 • • • " " " follo�Ned will then be decidedvary on a case-by-case basis, considering depending on such factors as the reason for the rate drop, prognosis for recovery or further rate drops, and the market price of the security. 1 . Eligible Investments A. U.S. Government Issues. United States Treasury notes, bonds, bills, or certificates of indebtedness, or those for which the faith and credit of the United States are pledged for the payment of principal and interest. B. Federal Agency Securities. Federal agency or United States government-sponsored enterprise obligations, participations, or other instruments, including those issued by or fully guaranteed as to principal and interest by federal agencies or United States government-sponsored enterprises. c. Municipal Bonds. Registered treasury notes or bonds of any of the other 49 United States, in addition to California, payable solely out of the . revenues from a revenue-producing property owned, controlled, or operated by a state or by a department, board, agency or authority of any of the other 49 United States, in addition to California. Such securities must have a maximum maturity of five (5) years and ratings from at least two of three ratings as follows: "Aa3" by Moody's Investors Service, or "AA-" by Standard & Poor's, or "AA-" by Fitch_Ratings; or as otherwise approved by the Commission. Registered general obligation treasury notes or bonds of any of the 50 United States. Such securities must have a maximum maturity of five (5) years and ratings from two of three ratings as follows: at least "Aa3" by Moody's Investors Service, or "AA-" by Standard & Poor's, or "AA-" by Fitch_Ratings; or as otherwise approved by the Commission. Adjustable rate �registered treasury notes or bonds of any of the 50 United States, including bonds payable solely out of the revenues from a revenue producing property O'lNned, controlled, or operated by a state or by a department, board, agency or authority of any of the other 4 9 United States, in addition to California. Such securities must have ratings from at least tvvo of three ratings as follows: "P 1" by Moody's Investors Service, I Revised May 11, ?011June 7, 2012 21 I or II A l 1 " by Standard & Poor's, or IIF 1 1 " by Fitch Ratings; or as othen<vise approved by the Commission. Adjustable rate notes or bonds warrants, or other evidences of indebtedness of any local agency within the State of California \'l>'ith a minimum rating of either ~~p 1" by. Moody's Investors Service, or II A 1 1 " by Standard & Poor's, or 11 F 1 1 " by FitchRatings, including bonds,· notes, warrants, or other evidences. of indebtedness payable solely out of the revenues from a revenue producing property ovmed, controlled, or operated by either the local agency, a department, board; agency, or authority of the local agency, or of any local agency within this state. Taxable or tax-exempt bonds, notes, warrants, or other evidences of indebtedness of any local agency within the State of California with a maximum maturity of five (5) years and minimum rating of either II Aa3" by Moody's Investors Service, or IIAA-" by Standard & Poor's, or IIAA-" by Fitch_Ratings (the minimum rating shall apply to the local agency, irrespective of any credit enhancement), including bonds, notes, warrants, or other evidences of indebtedness payable solely out of the revenues from a revenue-producing property owned, controlled, or operated by either the local agency, a department, board, agency, or authority of the local agency, or of any local agency within this state. Investments in municipal bonds are further limited to 15% of surplus funds. D. Tri-Party Repurchase Agreements. Tri-party Rrepurchase agreements are to be used solely as short-term investments not to exceed 30 days. The Commission may enter into tri-party repurchase agreements with primary government securities dealers rated II A" or better by two nationally recognized rating services. Counterparties should also have (i) a short-term credit rating of at least A-1 /P-1; (ii) minimum assets and capital size of $25 billion in assets and $350 million in capital; (iii) five years of acceptable audited financial results; and (iv_) _}-a strong reputation among market participants. The following collateral restrictions will be observed: Only U.S. Treasury securities or Federal Agency securities, as described in V .1 A and B, will be acceptable collateral. All securities Revised May 11, 2011June 7. 2012 22 • • • " " " E. F. underlying trl-party repurchase agreements must be delivered to the Commission's custodian or fiscal agent bank versus payment or be handled under a properly executed tri-party repurchase agreement. The total market value of all collateral for each tri-party repurchase agreement must equal or exceed 102 percent of the total dollar value of the money invested by the Commission for the term of the investment. For any tri- party repurchase agreement with a term of more than one day, the value of the underlying securities must be reviewed on an on-going basis according to market conditions. Market value must be calculated each time there is a substitution of collateral. The Commission.!.--&~' its trustee, or designated custodian shall have a perfected first security interest under the Uniform Commercial Code in all securities subject to tri-party repurchase agreement. The Commission shall have properly executed a PSA agreement (or a similar agreement as may be determined by the Commission) with each counterparty with which it enters into a tri-party repurchase agreements . U.S. Corporate Debt. Medium-term notes, defined as all corporate and depository institution securities with a maximum remaining maturity of five years or less, issued by corporations organized and operating within the United States or depository institutions licensed by the United States or any state and operating within the United States. Eligible investment shall be rated "AA" or better by one or more nationally recognized rating service. Investments in U.S. Corporate Debt �are further limited to 20% of surplus funds Commercial Paper. Commercial paper rated in the highest category by one or more nationally recognized statistical rating organization (NRSRO). The entity that issues the commercial paper shall meet all of the following conditions in either paragraph ( 1) or paragraph (2): ( 1) The entity meets the following criteria: (A) Is organized and operating in the United States as a general corporation. (8) Has total assets in excess of five hundred million dollars ($500,000,000). (C) Has debt other than commercial paper, if any, that is rated "A" or higher by a NRSRO. � (2) The entity meets the following criteria: (A) Is organized within the United States as a speCial purpose corporation, I Revised May 11, ?OllJune 7, 2012 23 trust, or limited liability company. (8) Has program-wide • G. H. credit enhancements, including, but not limited to, over collateralization, letters of credit, or surety bond. (C) Has commercial paper that is rated "A-1" or higher, or the equivalent, by a NRSRO. Purchases of eligible commercial paper may not exceed 270 days maturity nor represent more than 1 0 percent of the outstanding paper of an issuing corporation. Investments in commercial paper are limited to a maximum of 30% of surplus funds. Banker's Acceptances. Banker's acceptances issued by domestic or foreign banks, which are eligible for purchase by the Federal Reserve System. Purchases of banker's acceptances may not exceed 180 days maturity. Eligible banker's acceptances are restricted to issuing financial institutions with short-term paper rated in the highest category by one or more nationally recognized rating service. Investments in banker's acceptances are further limited to 40% of surplus funds with no more than 30% of surplus invested in the banker's acceptances of any one commercial bank. Money Market Mutual Funds. Shares of beneficial interest issued by diversified management companies that are money market funds registered with the Securities and Exchange Commission under the Investment Company Act of 1940 (15 U.S.C. Sec. 80a-1, et seq.) and that invest solely in· U.S. treasuries, obligations of the U.S. Treasury, and repurchase agreements relating to such treasury obligations. The Commission may invest in shares of beneficial interest issued by accompany shall have met either of the following criteria: ( 1) Attained the highest ranking or the highest letter and numerical rating provided by not less than two nationally recognized rating services. (2) Retained an investment adviser registered or exempt from registration with the Securities and Exchange Commission with not less than five years' experience managing money market mutual funds with assets under management 1n excess of five hundred million dollars ($500,000,000). The purchase price of shares of beneficial interest purchased pursuant to this subdivision shall not include any commission I Revised May 11, 2011.June 7, 2012 24 • • " " " I. that the companies may charge. Investments in Money Market Mutual Funds are further limited to 20% of surplus funds. Riverside County Pooled Investment Fund ("RCPIF"). The Commission may invest in the Riverside County Pooled Investment Fund. As on-going due diligence, the Chief Financial Officer shall obtain the information listed below: A description of eligible investment securities and a written statement of investment policy. A description of the interest calculation, the frequency of interest distributions, and the treatment of gains and losses in the portfolio. " A description of how often the securities are priced, how the securities are safeguarded, and the audit arrangements. " A description of who may invest in the program, how often they may invest, and what size deposits and withdrawals are allowed. " A schedule for receiving statements and portfolio listings. " A fee schedule, and when and how fees are assessed . " The composition of the investment fund for each reporting period. J. State of California Local Agency Investment Fund ("LAIF"). The Commission may invest in LAIF. As on-going due diligence, the Chief Financial Officer shall obtain the information listed below: " A description of eligible investment securities and a written statement of investment policy. A description of the interest calculation, the frequency of interest distributions, and the treatment of gains and losses in the portfolio. " A description of how often the securities are priced, how the securities are safeguarded, and the audit arrangements. A description of who may invest in the program, how often they may invest, and what size deposits and withdrawals are allowed. A schedule for receiving statements and portfolio listings. A fee schedule, and when and how fees are assessed. The composition of the investment fund for each reporting period . I Revised lVJay 11, 2011June 7, 2012 25 K. Certificates of Deposit. Negotiable Certificates of Deposit (NCD' s.): NCDs are money market instruments issued by a bank. They specify that a sum .of money has been deposited, payable with interest to the bearer of the certificates on a certain date. NCDs are issued by nationally or state chartered bank or state or federal savings and loan association. All purchases must be from institutions rated by a nationally recognized rating organization, as designated by the U.S. Securities and Exchange Commission. The maturity of NCDs shall not exceed 180 days to maturity, and purchases of NCDs 'shall not exceed fifteen percent (15%) of the Commission's investment portfolio. NCDs shall be evaluated in terms of the credit worthiness of the issuing institution, as these deposits are uninsured and uncollateralized promissory notes. FDIC-insured Certificates of Deposit: The principal amount of the investment must be federally insured through the Federal Deposit Insurance Corporation (FDIC). No more than the prevailing FDIC insured coverage amount may be invested with • any one deposit. Certificates of Deposit placed through the • Certificate of Deposit Account Registry Service (CDARS) shall be considered fully insured, assuming that the total amount invested with any participating bank is limited to the prevailing FDIC insured coverage amount. Interest on the principal must be paid to the Commission at least annually. The placement of Certificates of Deposit with local banks that qualify in accordance with Government Code section 53601 (h) is encouraged. The Commission, at its discretion, may invest a portion of its surplus funds in certificates of deposit at a commercial bank, savings bank, savings and loan association, or credit union using a private sector entity to assist in the placement of such certificates, provided that it complies with Government Code Section 53601.8. Such investments may not exceed in total twenty percent (20%) of the Commission's funds invested pursuant to Government Code Sections 53601.8, 53635.8 and 53601, and shall have a maximum maturity of one year from the date of the deposit. Collateralized Certificates of Deposit: For investments exceeding $100,000, there will be a waiver of collateral for the first $100,000 deposited and protected by FDIC insurance. The remainder of the deposit shall be fully collateralized by U.S . I Revised May I L 2011June 7, 2012 26 • " " " 2. L. Treasury and Federal Agency secunt1es having matunt1es less than five years. The District must receive written confirmation that these securities have been pledged in repayment of the time deposit. The securities pledged as collateral must have a current market value greater than the dollar amount of the deposit in keeping with the ratio requirements specified in Section 53652 of the Government Code. Additionally, a statement of the collateral shall be provided to the Commission on a monthly basis. Such investments may not exceed in total fifteen percent (15%) of the Commission's funds invested pursuant to Government Code Sections 53601.8, 53635.8 and 53601, and shall have a maximum maturity of one year from the date of the deposit. Time Deposits. Federal Deposit Insurance Corporation insured money market savings accounts or time deposits which are deposited through depository institutions with each depository institution holding no more than the maximum amount of principal qualifying for deposit insurance\Nhich are participants of the Money Market Insured Deposit Account Service ("MMIDAS"} . Eligible Investments for Bond Proceeds Bond proceeds shall be invested in secur1t1es permitted by the applicable bond documents. If the bond documents are silent as to permitted investments, bond proceeds will be invested in securities permitted by this Policy. With respect to maximum maturities, the Policy authorizes investing bond reserve fund proceeds beyond the five years if prudent in the opinion of the Chief Financial Officer. 3. Ineligible Investments As provided in California Government Code Section 53601 .6, the Commission shall not invest any funds in inverse floaters, range notes, mortgage derived interest-only strips or in any security that could result in zero interest accrual if held to maturity. The purchase of any security not listed in Section Vl.1 above, but permitted by the California Government Code, is prohibited unless the Board approves the investment either specifically or as a part of an investment program approved by the Board . I RevisedMay 11,2011June7,2012 27 VII. Maximum Maturities Maturities of investments will be selected to provide necessary liquidity, minimize interest rate risk, and maximize earnings. Current and expected yield curve analysis will be monitored and the portfolio will be invested accordingly. Because of inherent difficulties in accurately forecasting cash flow requirements, a portion of the portfolio should be continuously invested in readily available funds. Where this Policy does not specify a maximum rema1n1ng maturity at the time of the investment, no investment shall be made in any security, other than a security underlying a repurchase or reverse repurchase agreement authorized by this section, that at the time of the investment has a term remaining to maturity in excess of five years, unless the Board has granted express authority to make that investment either specifically or as a part of an investment program approved by the Board no less than three months prior to the investment. VIII. Performance Standards • The Chief Financial Officer shall continually monitor and evaluate the • portfolio's performance. A eomparison of the portfolio's performanee against a performanee benehmark shall be ineluded in the Chief Finaneial Offieer' s quarterly report. The Chief Finaneial Offieer shall seleet an appropriate, readily available market index to use as . a performanee benehmark. IX. Reporting The Chief Financial Officer shall prepare and provide to the Board and the Executive Director, within 30 days following the end of the quarter, a portfolio report, which includes the following information: • Type of investment Name of issuer Date of maturity • Date of purchase Par value • Original purchase cost • Call date {if applicable) • Current market value of securities • Unrealized market value gain/loss Coupon rate, if applicable I Revised May 11, 2011June 7, 2012 28 • " " " X. XI. Yield to maturity Credit quality, as determined by one or more nationally recognized credit rating services, of each investment Average duration of portfolio Listing of all investment transactions during the quarter A statement that the portfolio complies with the investment policy, or the manner in which the portfolio is not in compliance A statement denoting the ability of the Commission to meet its liquidity requirements for the next six months, or provide an explanation as to why sufficient money shall, or may not be, available. Investment Procedures The Chief Financial Officer, as the Board's designee, is responsible for ensuring compliance with the Commission's investment policies and establishing written procedures and internal controls for the operation of the investment program. No person may engage in investment transactions except as provided under the terms of this Policy and the written procedures established by the Chief Financial � Officer. The written procedures should address: delegation of authority to subordinate staff members, control of collusion, separation of transaction authority from accounting and record keeping, written confirmations of transactions, reconciliation of custody statements, and wire transfer procedures and agreements. An independent analysis by an external auditor shall be conducted annually to review internal control, account activity, and compliance with policies and procedures. Authorized Broker Dealers and Financial Institutions The Chief Financial Officer shall maintain a list of authorized broker/dealers and financial institutions which are approved for investment purposes. It shall be the Commission's policy to purchase securities only from those authorized institutions and firms. Separate lists shall be maintained for broker/dealers and financial institutions approved for repurchase. agreements and those approved for the purchase of other securities. If an investment advisor is used, they may use their own list of approved broker/dealers and financial institutions for investment purposes. To be eligible, a firm must meet the following m1mmum criteria: (i) an institution licensed by the state as a broker-dealer, or from a member of a federally regulated securities exchange, from a national or state-chartered bank, from a federal or state association or from a brokerage firm designated as a primary government dealer by the Federal Reserve bank; and (ii) all broker/dealer firms and individuals must be properly registered with the I Revised May 11, 2011June 7, 2012 29 NASD and/or SEC to transact business in the relevant geographic locations and product sectors. In addition, counterparties for Repurchase Agreements shall be limited to primary government securities dealers rated "A" or better by two nationally recognized rating services. Counterparties shall also have (i) a short-term credit rating of at least A-1 /P-1; (ii) minimum assets and capital size of $25 billion in assets and $350 million in capital; (iii) five years of acceptable audited financial results; and (iv) a strong reputation among market participants. The Chief Financial Officer shall select broker/dealers and other financial institutions on the basis of the firm's expertise and credit worthiness. The Commission shall annually send a copy of the current investment policy to all dealers approved to do business with the Commission. Each broker dealer or financial institution that has been authorized by the Commission shall be required to submit and annually update a Broker/Dealer Questionnaire which includes the firm's most recent financial statements. The Chief Financial Officer shall maintain a file for each firm approved for investment purposes, which includes the most recent Broker/Dealer Questionnaire. XII. Safekeeping and Custody • To protect the Commission's assets, all securities owned by the Commission • shall be held in safekeeping in the Commission's name by a third party bank trust department, acting as agent for the Commission under the terms of a custody agreement executed by the bank and the Commission. All securities will be received and delivered using standard delivery versus payment (DVP) procedures; the Commission's safekeeping agent will only release payment for a security after the security has been properly delivered. Physical delivery securities shall be avoided whenever possible, as book entry securities are much easier to transfer and account for since actual delivery of a document never takes place. In addition, delivered securities must be properly safeguarded against loss or destruction. The potential for fraud and loss increases with physically delivered securities. XIII. Ethics and Conflicts of Interest The Commission adopts the following policy concerning conflicts of interest: 1 . Officers and employees involved in the investment process shall refrain from personal business activity that could conflict with proper execution of the investment program or which could impair their ability to make impartial investment decisions. Revised May 11, ?OlJJune 7, 7012 30 • " " " " 2. 3. Officers and employees involved in the investment process shall disclose any material financial interest in any financial institution that conducts business with the Commission, and they shall further disclose any large personal financial/investment positions that could be related to the performance of the Commission's portfolio. Officers shall refrain from undertaking. personal transactions with the same individual with whom conducted on behalf of the Commission. investmeflt business is XIV. Investment Policy Review The Chief Financial Officer shall annually render to the Board a statement of investment policy, which the Board must consider at a public meeting. Any changes to the policy shall also be considered by the Board at a public meeting . I Revised May ll, ?OllJune 7, ?012 31 " " " " AGENDA ITEM 70 " " " " " " " " " RSIDE COUNTY TRANSPORTATION COMMISSION RIVE DATE: May 21, 2012 TO: Budget and Implementation Committee FROM: Anne Hallberg, Accounting Supervisor THROUGH: Theresia Trevino, Chief Financial Officer SUBJECT: Quarterly Investment Report STAFF REG OMMENDA TION: This item is for the Committee to: 1) Recei ve and file the Quarterly Investment Report for the quarter ended h31,2012;and Marc 2) Forw ard to the Commission for final action. BACKGROU IVD INFORMATION: Attached ar law and Co month ende Attachment e the quarterly investment and cash flow reports as required by state mmission policy. The county of Riverside's Investment Report for the d March 31, 2012, is also attached for review. s: 1) Quart erly Investment Report for the quarter ended March 31, 2012 2) Coun ty of Riverside Investment Report for the month ended March 31, 2012 Agenda Item 70 32 " " " " RIVIHSide County Transportation CommiSSion lnvestme11t Portfolio Report PenodEnded Marcll31, 2012 OPERATING FUNDS Cjty National Bank DepositS County Treasurer's Pooled Investment Fund Local Agency Investment Fund (LAIF) AgencyfTreasury Securities: Subtotal Operating Funds FUNDS HELD IN TRUST County Treasurer's Pooled Investment Fund: Local Transportation Fund Subtotal Funds Held in Trust COMMISSION BOND PROJECT FUNDS/DEBT RESERVE US Bank Money Markel Investment Agreements County of Riverside Pool investment Frrst American Government Obligation Fund F1rst Amer1can Treasury Obligations Fund� Held 1n Trust Subtotal Bond Project Funds!Debt Reserve TOTAL All Cash and Investments FAIR VALUE RATING MOODYS/FITCH S&P 1,469 558 A3/888+ 424,112.849 Aaa/MR11AAAIV1 3,603.059 Not Rated 429,185.466 71,030.462 Aaa.MR11AAAJV1 71.030,462 Aaa/AAAm Aaa/MR1/AAAA/1 _____ _;;15"'8'-~:::~~~ 158 500,216,086 Investment Transactions for the Quarter Ended March 31,2012 Purchases: None Maturities: Par Value at Matur1ty Matur1tyOale None COUPON RATE NIA NIA NIA NIA NIA N/A� NIA NIA NIA NIA NIA Coupon Rate PAR VALUE " 33 PURCHASE DATE NIA NIA NIA Banks County Pool County Pool Investment LA IF Mutual Funds CNICharter US Bank Money Market MATURITY DATE NIA NIA NIA First Amencan Government Obl1gat1on Fund Sub. Total Mutual Funds Federal Agency secunt1es Certificates ol Deposit U.S. Treasury securities Corporate Note/Commercial Paper Investment Agreements YIELD TO MATURITY NIA 0.49% NIA 0.4S% 0 49% NIA PURCHASE COST SUMMARIZED INVESTMENT TYPE TOTAL MARKET VALUE __ 1_58_ UNREALIZED GAIN (LOSS) 1,469 558 tl95 143 311 3 603.059 158 s 500,216,086 " " " " " " " County Pool/Cash 95.90% Statement of Compliance f { Nature of Investments Debt Reserve 1.50% Trust Funds 13.72% Portfolio_M_a_t_u_ri_tY __ 0 to 90 Days 100% Portfolio Investment Type ________ Mutual Funds 1.84% County Pool/1 nvestment 1.56% All of the above investments and any investment decisions made for the quarter ended March 31, 2012 were in full compliance with the Commission's investment policy as adopted on May 1 1, 201 1. The Commission has adequate cash flows for six months of operations. Signedby:~~ ChiefFinancial Officer 34 " " " " 2012 County of Riverside March Trea_surer's Pooled Invest1nent Fund "Mixed March" Well, here we are at the end of the 151 quarter, and it seems there is no clear direction for the economy as some of the indicators continue to be mixed, partially re- lated to a much warmer winter across the U.S. Our stock market, on the other hand, has seen its best returns for the f1rst three months since the late 1990's. The Fed met at its regularly sched- uled meeting of March 13th and said nothing we were not expecting to hear. They stated, "The unemployment rate has declined nota- bly in recent months but remains elevated. Household spending and business fixed in- vestment have continued to advance. The housing sector remains depressed. Inflation has been subdued in recent months, al- though prices of crude oil and gasoline have increased lately. The recent increase in oil and gasoline prices will push up inflation tem- porarily." The economy is slowly moving in the right direction but if you read the tea leaves in the Fed's statements, there is much room for downside risk, and, the massive budget deficit and national debt still needs to be addressed. Most of the recent euphoria is due to positive unemployment numbers, however, if they falter, it could de- rail the momentum in the stock market and cause a flight to safety in bonds. This has happened in the last few days, thus further raising the possibility of further stimulus by the Fed, only to place our economy back on life support. In addition, let's not forget, Europe remains unsettled. The last action they took, Operation Twist, is set to expire in June. The latest news we have been reading suggests that market watchers are looking for another ren- dition in an effort to keep rates lower longer, and to continue to push investors into the "risk on" trade. Let's face it, Americans tend to feel better if they have a job, their 401 k or retirement plan statements don't show implo- sion, and they can continue to finance pur- chases of real estate at historic lows. It's all related and feeds into our confidence as con- sumers and psyche as to how we feel about the economy as a whole. We will continue to read the eco- nomic tea leaves and watch closely as the next few months worth of economic data will be very telling of whether we see the green shoots of a lasting spring or crab grass grow- ing in the garden. Our hope is for a modest and sustainable recovery so that markets can react reasonably and so we can invest our depositors' funds accordingly. Don Kent Treasurer-Tax Collector Capital Markets Team Treasurer-Tax Collector Don Kent Asst. Treasurer-Tax Collector Jon Christensen Investment Manager Giovane Pizano Asst. Investment Manager Angela Tressler Investment Objectives The primanJ objective of the treasurer shall be to safe- guard the principal of the funds under the treasurer's control, meet the li- quidity needs of the depositor, and achieve a return on the funds under his or her control. RIVERSIDE COUNTY TREASURER'S POOLED INVESTMENT FUND IS CURRENTLY RATED: Aaa-bf/MR1 BY MOODY'S INVESTOR'S SERVICE AND AAA/V1 BY HTCH RATINGS The. Treasurer's Pooled Investment Fund is comprised of the CounhJ, Schools, Special Districts, and other Discretionary Depositors. 35 Current Market Date Economic Indicators Released on: Indicator Definition Consensus Actual 4/6/2012 4/6/2012 3/28/2012 Stock Indices Nonfarm Payrolls- M/Mchange Unemployment Rate Counts the number of paid employees working part-time or full-time in the nation's business and government establishments. Measures the number of unemployed as a percentage of the labor force. Durable Goods Orders-Reflects the new orders placed with domestic M/M change manufacturers for immediate and future c:Idlv~ry Real Gross Domestic Product-QJQ change of fattory hard goods. '< ·· ·• The broadest measure of aggregate economic activity and encompasses every sector of the economy. GOP is the cow1try's most Value Chan e Dow Jones (Dfli}.) S&P 500 Index ~.i\SDAQ . 13,212(0tl,~'k~¥i 259.94 1,408.47 42.79 .:$)091.57 124!68 Commodities 1,668.35 c '" RIVERSIDE COUNTY TREASURER-TAX COLLECTOR 36 201,000 120,000 8.3% 2 • • " TIMMI Fidelity Prime Institutional MMF Federated Prime Obligations Fund 'Wells Fargo Advantage Heritage. Morgan Stanley Institutional Prime Liquidity Fund BlackRock Prime Cash Fund 1.00% 0.80% 0.60% 0.40% 0.20% FIPXX POIXX WF]XX MPFXX BPIXX 0.20% 0.19% 0.08% 0.17% 0.21% The Treasurer's Institutional Money Market Index (TIMMI) is compiled and reported by the Riverside County Treasurer's Capital Markets division. It is a composite index derived from five AAA rated prime institutional money market funds. Similar to the Treasurer's Office, prime money market funds invest in a diversified portfolio of U.S. dollar denominated money market instruments including U.S. Treasuries, government agencies, commercial paper, certificates of deposits, repurchase agreements, etc. TIMMI is currently comprised of the five multi billion dollar funds listed to the left. -Pool Yield TIMMI 0.00% ;---------~----------~---------r----------r----------r--------~r-----.L_ ________ M_M_-_1_1 _____ M __ ay_-_1._1 _____ J_u_l-_1_1 ______ s_e_p-_1_1 ______ N_o_~_1_1 ______ Jan __ -1_2 ______ M_M __ -1_2 __ _J Cash Flows Required Actual Available to Monthly Monthly Matured Investments Invest> 1 Month Receipts Disbursements Difference Investments Balance Maturing Year 04;!2012 04/2012 05/2012. 06/2012 07/2012 08/2012 09/2012 10/2012 11/2012 12/2012 01/2013 02/2013 03/2013 1,404.16 746'.26 884.08 841.95 518.23 649.54 669.49 832.3:{ 1,500.00 629.05 460.00 873.33 733.64 1,035.89 1,220.61 826.31 711.33 750.00 826.92 ;:;1)7tt.fl5 800.00 ~,264.44 930.00 800,00 670.52 (289.63) (336.53) 15.64 (193.10) (100.46) (157.43) 155,88 700.00 (635.39) (470.00) 73.33 234.45 406.05 1,076.57 786.94 450.41 466.05 272.95 172.49 15.06 170.94 870.94 235.55 0.00 73.33 389.00 318.66 294.50 238.69 225.72 148.04 192.80 139.12 105.00 508.11 179.90 65.00 TOTALS 10,008.42 10,575.59 (567.17) 234.45 2,804.54 4,763.00 4.69% 56.12% 95.31% * All values re:ported in million,;;($) . " The Pooled Investment Fund cash flow requirements are based upon a 12 month historical cash flow model. Based � upon projected cash receipts and maturing investments, there are sufficient funds to meet future cash flow disburse- ments over the next 12 months. RIVERSIDE COUNTY TREASURER-TAX COLLECTOR 3 37 Asset Allocation ....... Ill 0 0 0 ....., 2,000,000.00 1,000,000.00 o.oo 1-::.: ::i: ::i: :h -~ · .. "" Scheduled Par 35,000.00 54,000.00 50,000.00 200,000.00 560.00 50,000.00 100,000.00 20,000.00 643,641.00 100,000.00 898,850.00 145,000.00 1,953,180.00 82,000.00 263,705.00 123,000.00 37,500.00 88,735.00 n c c ~ C1 ~ II) z z co ~ c li.. li.. II) ...1 z co .... t; 1-II) co 0 g! < 0 co c. >-II) ::::> -u < II) n:: z w < 1-..... g C1 n:: w ...J >-c < 1-n:: < u u ...1 II) 1-C1 < ::::> II) < u ::::> • ...J 0 < ...1 u 0 ...1 S<;i1eduled Book ~"·"·''--'' ~:.\ ~~·" • :,c~~~~"',s.;,,i<( 35,000.00 54,000.00 50,000.00 200,000.00 560.00 49,915.47 100,318.55 19,971.40 643,825.62 99,866.03 899,788.64 144,752.28 1,954,615.24 81,861.43 264,019.44 122,751.08 37,502.38 88,970.55 II II) II) II) II) II) II) ILl c w c ILl 0 1-z 1-z 1-z c 0 0 0 0 0 z co z CO. z U1 u u u < u co 1/) % lll % lll ...1 .... 0 0 c ...1 z ;I; u. ;I; li.. u u.. < lXI % % ...1 ...J z ::t: ;I; u.. u.. LL. Scheduled Book Ia Market RIVERSIDE COUNTY TREASURER-TAX COLLECTOR Scheduled :,, . ; .. Matke'f\!ylt''$;;\Mkf/ Sch Book Yield ,, .•.• ,,.._,,;..<"A•<'<'<'<~-"'<'.,..'.'>.Y•»"••'·"""·""'"""'<:'N• <'• ·'~"''-"''"'"-~'">'~·"->-·-· 35,000.00 100.00% 54,000.00 100.00% 0.42% 50,000.00 100.00% 0.38% .003 200,000.00 100.00% 0.09% .003 560.00 100.00% 0.99% 8.214 49,930.22 100.03% 0.19% .858 100,283.00 99.96% 0.22% .782 20,000.00 100.14% 0.16% .302 644,678.10 100.13% 0.76% 1.230 99,906.25 100.04% 0.14% .676 901,614.08 100.20% 0.84% .854 144,921.96 100.12% 0.17% .535 1,955,197.79 100.03% 0.37% .773 81,906.25 100.05% 0.19% .762 264,382.22 100.14% 0.62% .915 123,000.00 100.20% 0.21% .217 37,589.06 100.23% 0.61% 1.093 88,970.55 100.00% 0.45% .381 I II) II) II) u II) n:: ILl c ILl < 0 w 1-z 1-% z c. 0 0 0 0 < SCHEDULED PAR % z U1 z n:: U1 c. u co u ~ u lll -c li.. c u. U1 u u < u. E u.. u. 38 w % ..... % z % ~ ::;) 0 % u.. u MMKT-1°/o CALTRUST FND -1% L AGCY INVST FHD • 1 OJI> PASSBK-4% LOC AGCY OBUG -Oo/o US TREAS BILLS· 1% US TREAS BONDS-2% FHLMC DISC NOTES· 0% FHLMC BONDS -13% FNMA DISC NOTES· 2o/o -fNMA BONDS • lBo/o -FHLB DISC NOTES-.3o/o ..,. FHlB BONDS -39o/o l!l!2 FFCB DISC NOTES • 20fo r= FFCB BONDS· 5% = FMAC DISC NOTES -20Jo ..,. FARMER MAC -1 "A> -MUNI BONDS-2% ..,. COMM PAPER-3% • .003 .003 .003 8.214 .858 .782 .302 2.253 .676 2.366 .535 .965 • • 4 Maturity Distribution ·MMKT 35,000.00 CAL TRUST FND 54,000.00 LOCAL AGCY INVST 50,000.00 FND DDA/PASSBK 200,000.00 LOCAL AGCY OBLIG US TREAS BONDS 50,0QO.OO FHLMC DISC NOTES 90,000.00 10,000.00 FHLMCBONDS 20,000.00 DISC NOTES 89,121.00 226,000.00 BONDS 100,000.00 10,000.00 10,000.00 95,000.00 340,000.00 145,000.00 5,000.00 323,810.00 940,295.00 532,585.00 7,000.00 75,000.00 71,500.00 74,205.00 FARMER MAC 45,000.00 78,000.00 MUNIBONDS COMMPAPER 55,745.00 5,140.00 • YI!AR IN MATURITY -·······-··-··-··-···-------------------·------ RIVERSIDE COUNTY TREASURER-TAX COLLECTOR 39 35,000.00 54,000.00 50,000.00 200,000.00 560.00 560.00 50,000.00 100,000.00 20,000.00 216,500.00 112,020.00 643,641.00 100,000.00 260,000.00 183,850.00 898,850.00 145,000.00 85,990.00 65,500.00 1,953,180.00 82,000.00 10,000.00 263,705.00 123,000.00 37,500,00 88,735.00 -MMI<T • Scheduled Par -CALTRUST FND ·Scheduled Par -LOCAL AGCY INIIST FND ·Scheduled Par ODA/PASSBK-Schedu!li!d Par ._ LOCAL AGCY OBUG • Scheduled Par US TREAS lliUS ·Scheduled Par -US TREAS BONDS· Scheduled Par -FHLMC DISC NOTES ·Scheduled Par -FHUK BONDS· Scheduled Par -FNMA DISC NOTES · Scheduled Par FNMA BONDS· Sche~"!ed Par -FlllB DlSC NOT£S • Scheduled Par FHLB BONOS· Scheduled Par -FFCB OlSC NOT£S • Scheduled Par -FFCB BONDS· Scheduled Par -FMAC DISC NOTES· Scheduled P.,r -FARMER MAC-Scb.,duled Par -MUNI BONDS • Scheduled Par -COMM PAPER· Scheduled Par 5 Credit Quality Aaa Aal Aa2 Aa3 4,412,491.00 8,580.00 138,040.00 25,000.00 4,414,999.91 8,580.27 137,829.42 25,225.75 4,418,857.39 8,580:27 137,999.26 25,225.75 100.09% 0.51% 100.00% 0.93% 100.12% 0.41% 100.00% 0.25% NR 411,060.00 410,813.46 411,149.06 100.08% 0.21% MOODY'S 1!111!!1 Aaa -SSo/o 1!111!!1 Aa3 • 1 o/o -Aal· OOfo 111111111 NR • 80fo I!III!!IJ\a2·3o/o 3,197,205.00 24,480.00 25,000.00 3,196,439.71 24,480.27 25,225.75 410,813.47 RIVERSIDE COUNTY TREASURER-TAX COLLECTOR 40 S&P 111111111.1\AA· 27% I:!!EIM· -1% IIIIIIIIM+·64o/o Ei!!IIINR·S% IIRM-0% 3,197,730.26 100.04% 24,480.27 100.00% 25,225.75 100.00% 411,149.07 100.08% 0.46% 0.68% 0.25% 0.21% • • • 6 Month End Portfolio Holdings Maturity Maturity Par Book Market Market Unrealized Modified Years To CUSIP Description Date Coupon To Mat Value Value Price Value Gain/Loss Duration Maturity • KT XX XX XX FIPXX GO lXX ~IVRXX FEDERATED PRI~·IE IV ELLS FARGO HERITAGE BLACK ROCK FIDELITY M~IF FEDERATEDCOV ~!ORGAN STANLEY GOV CALTRUST FND CLTR CAL TRUST SHT TERIVI FUND DDA/PASSBK CASH UBOC ~IANACED RATE LOCAL AGCY OBLIG LAO US DIST COURTHOUS US TREAS BILI.S 9127955ZO US. TREASURY BILL us TREAS BONDS 912828PH7 U.S TREASURY BOND 912828NX4 U.S. TREASURY BOND 912828PR5 U.S. TREASURY BOND 912828QZ6 U.S. TREASURY BOND 912828QK9 U.S. TREASURY BOND FHLMC DISC NOTES 313396ZQ9 FH LMC DISC NOTE 313396ZN6 FHLMC BONDS .... 3137EACC2 FH LMC 3134C1CQ1 3134G1GQ1 3134C1GQ1 • 1GQ! ACLl 15CO 1WT7 3134G1XG4 FHLMC FHLMC FHLMC FHUv!C FHLMC FHLMC 3.5YrNc6Mo FHLMC FH LMC 2YrNc6Mo 3J37EACK3 FH LMC 2.2Yr 3J37EACR8 FHLMC 3Yr 3137EACR8 FHLMC3Yr 3134G1VG6 3134G2CL4 3J37EACP2 3J37EACL1 3134G2FT4 3l34G2UP5 3134G2YK2 3134G2YK2 3134G2Z)4 3134G2ZN5 3137EACK3 3134G2Y)5 3134G2N81 3134G2N81 3134G2YJ5 3134G2T28 3134G2Q62 3134G2U91 3134G2T69 3134G2U42 3134G2W40 3134G2W40 3134G2W40 3134G2W40 3134G2W40 3137EACY3 3137EACY3 3134G2W99 3134G2W73 3134G2Y89 3134G2Y55 3134G22H4 3134G22H4 3134G22H4 3134G23J9 23M2 3M2 ACZO G3BQ2 3134G3BF6 FHLMC2Yr FHLMC3Yr FHLMC2Yr FHLMC3Yr FHLMC2.25Yr FHLMC 5YrNc1 YrB FH LMC 2YrNcl YrE FH LMC 2YrNc1 YrE FH LMC 5YrNc3MoB FH LMC 5YrNc3MoB FHLMC 11Mo FHLMC3Yr FH LMC 5YrNc61vloB FHLMC 5YrNc6MoB FHLMC 3Yr FH LMC 3YrNc6MoB FH LMC 2YrNc6MoB FH LMC 5YrNc6MoB FH LMC 5YrNc6MoB FHLMC2Yr FHLMC 3YrNc6MoB FHLMC 3YrNc6MoB FHLMC 3YrNc6MoB FH LMC 3YrNc6MoB FH LMC 3YrNc6MoB FHLMC3Yr FHLMC 3Yr FH LMC 5YrNc6MoB FH LMC 2YrNc1 YrE FHLMC 3.5YrNc1YrB FHLMC 2YrNc6MoB FHLMC 2YrNc6MoB FHLMC 2YrNc6MoB FH LMC 2Y rNc6MoB FHLMC 2YrNc6MoB FHLMC 2YrNc6MoB FHLMC 2YrNc6MoB FHLMC2Yr · FHLMC 5YrNc1YrB FHLMC2Yr 04/01/2012 04/01/2012 04/01/2012 04/01/2012 04/01/2012 04/01/2012 04/01/2012 ~(01/2012 097 .108 .149 !51 .010 .047 .424 .381 04/01/2012 .092 06(15/2020 .993 ".99~ 02{07 /2013 185 .185/h .097 108 .149 .151 .010 .047 .. ~1 .424 . •.424 .381 ,381 092 .993 .185 000 000 0.00 0.00 5,000,000.00 30,000,000 00 3S,ll00,000.00 54,000,000 00 •" 54,000,000.00 000 0.00 0.00 000 5,000,000.00 30,000,000.00 .000000 000000 000000 .000000 0.00 0.00 0.00 0.00 100.000000 5,000;000.00 100.000000 30,000,000.00 54,000,000.00 100.000000 54,000,000.00 50,000,000.00 50,000,000.00 100.000000 50,000,000.00 200,000,000.00 200,000,000.00 100.000000 200,000,000.00 560,000.00 560,000.00 100.000000 560,000.00 000 0.00 000 0.00 0.00 0.00 .000 .003 .000 .003 .000 .003 .000 .003 .003 .003 .OQ1 .003 0.00 .003 .003 0.00 .003 .003 0.00 .003 .003 0.00 4.221 8.214 50,000,000.00 49,915,465.28 99.860447 49,930,223.64 ]4,758.36 .855 .858 08/31/2012 .375 342 15,000,00000 15,006,44531 100090000 15,013,500.00 7,054.69 .418 .419 .501 .838 09/30/2012 375 .327 10,000.00000 10,006,640.63 100.110000 10,011,000.00 4,359.37 .500 01/31/2013 .625 151 10,000,00000 10,047,265.63 100.350000 10,035,000.00 -12,265.63 .831 05/31/2013 .500 :181 10,000,000.00 10,042,187.50 100.290000 10,029,000.00 -13,187.50 1.162 02/28/2013 .625 .176 10,000,000.00 10,047,265 63 100.370000 10,037,000.00 -10,265.63 .914 2013 .625 .199 45 000 000.00 45168 750.00 100.350000 45157 0.00 .Jl 250.00 .831 07/20/2012 01/09/2013 08/28/2012 08/28/2012 08/28/2012 08/28/2012 10/28/2013 03/03/2014 11/26/2012 10/29/2012 07/27/2012 02/25/2014 02/25/2014 10/30/2012 04/29/2014 11/30/2012 10/28/2013 08/13/2013 08/22/2016 09/06/2013 . 09/06/2013 09/06/2016 09/06/2016 07/27/2012 09/19/2014 09/29/2016 09/29/2016 09/19/2014 10/17/2014 10{03/2013 10/13/2016 10/13/2016 10/15/2013 '10/24/2014 10/24/2014 10/24/2014 10/24/2014 10/24/2014 11/25/2014 11/25/2014 10/13/2016 10/18/2013 04/24/2015 10/25/2013 11/04/2013 11/04/2013 11/04/2013 11/15/2013 11/08/2013 11/08/2013 11/27/2013 11/28/2016 12/23/2013 .160 1.375 1.000 1.000 1.000 1.000 .875 1.250 .515 .500 1.125 1.375 1.375 .625 1.350 .375 .875 .875 1.750 .450 .450 1.000 1.125 1.125 500 1.250 1.250 .500 .750 .500 1.000 1.125 .375 800 .800 .800 .800 .800 .750 .750 1.250 .500 1.000 .550 .700 .700 .700 .600 .630 .630 .375 1.375 .625 .160 1.407 .709 .694 .732 .699 .937 1.250 .470 .500 .514 1.375 1.465 .650 1.160 .385 .790 .611 1.750 .450 .450 1.000 1.125 .203 .500 1.250 1.250 .599 .750 .520 1.010 1.156 .483 .. 800 .800 .800 .800 .808 .755 .761 1.250 .516 1.007 .550 .700 .700 .700 .600 .630 .630 .580 1.375 .626 10,000,000.00 9,985,066 67 10 000 000.00 9 986 33.33 10,000,000.00 5,000,000.00 10,000,000.00 10,000,000.00 5,000,000.00 5,ooo.ooo.ob 5,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 5,000,000.00 10,000,000.00 5,000,00000 5,000,000 00 14,121,000.00 11,000,000.00 5,000,000.00 10,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 7,020,000.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 15,000,00000 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 10,000,000.00 5.000,000.00 10,000,000.00 5,000,000.00 10,000,000.00 9, 990,300.00 5,029,450.00 10,061,850.00 10,054,100.00 5,030,400.00 4,990,300.00 5,000,000.00 5,004,700.00 5,000,000.00 10,102,700.00 5,000,000.00 9,973,100.00 4,998,000.00 5,027,800.00 14,118,881.85 11,022;330.00 5,028,n5.oo 10,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 10,086,400.00 10,000,000.00 10,000,000.00 7,020,000.00 9,970,700.00 5,000,000 00 4,998,000.00 4,997,500.00 4,992,500.00 14,967,300.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 9,997,500.00 9,998,467.22 4,998,300.00 5,000,000.00 4,998,437.50 4,998,750.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 ](),000,000.00 10,000,000.00 5,000,000.00 9,958,700.00 5,000,000.00 9,999,800.00 100.000000 100.000000 100.875000 100.343750 100.343750 100.343750 100.343750 100.812500 101.343750 100.218750 100.031250 100.312500 102.125000 102.125000 100.250000 101.906250 100.156250 100.812500 100.656250 100593750 100000000 100.000000 100.093750 100.125000 100.312500 99.937500 100.187500 100.187500 99.937500 100.031250 100.000000 100.031250 100.031250 100.031250 99.625000 99.625000 99.625000 99.625000 99.625000 100.500000 100.500000 100.Q11250 100.031250 100.187500 100.031250 100.031250 100.031250 100.031250 100.031250 100.031250 100.031250 100.031250 100.437500 100.375000 ](),000,000.00 14,933.33 ]() 000 000.00 13 666.67 10,087,500.00 5,017,187.50 10,034,375.00 10,034,375.00 5,017,187.50 5,040,625.00 5,067,187.50 5,010,937.50 5,001,562.50 10,031,250.00 5,106,250.00 10,212,500.00 5,012,500.00 5,095,312.50 14,143,064.06 11,089,375.00 5,032,812.50 10,059,375.00 10,000,000.00 5,000,000.00 5,004,687.50 10,012,500 00 10,031,250.00 9,993,750.00 10,018,750.00 7,033,162.50 9,993,750.00 5,001,562.50 5,000,000.00 5,001,562.50 5,001,562.50 15,004,687.50 9,%2,500.00 4,981,250.00 4,981,250.00 4,981,250.00 9,962,500.00 10,050,000.00 5,025,000.00 5,001,562.50 5,001,562.50 5,009,375.00 5,001,562.50 5,001,562.50 5,001,562.50 5,001,562.50 10,003,125.00 10,003,125.00 5,001,562.50 10,003,125.00 5,021,875.00 10,037,500.00 97,200.00 -12,262.50 -27,475.00 -19,725.00 -13,212.50 50,325.00 67,187.50 6,237.50 1,562.50 -71,450.00 106,250.00 239,400.00 14,500.00 67,512.50 24,182.21 67,045.00 4,037.50 59,375.00 0.00 0.00 4,687.50 12,500.00 -55,150.00 -6,250.00 18,750.00 13,162.50 23,050.00 1,562.50 2,00000 4,062.50 9,062.50 37,387.50 -37,500.00 -18,750.00 -18,750.00 -18,750.00 -35,000.00 51,532.78 26,700.00 1,562.50 3,125.00 10,625.00 1,562.50 1,562.50 1,562.50 1,562.50 3,125.00 3,125.00 1,562.50 44,425.00 21,875.00 37,700.00 .303 .763 .409 .409 .409 .409 1.555 1.892 .650 .575 .322 1.867 1.866 .580 2.033 .664 1.556 1.356 4.202 1.424 1.424 4.320 4.307 .323 2.448 4.357 4.357 2.447 2.507 1.494 4.401 4.384 1.530 2.524 2.524 2.524 2.524 2.524 2.612 2.612 4.369 1.536 2.997 1.554 1.576 1.576 1.576 1.608 1.588 1.588 1.650 4.4n 1.713 1.167 .915 .838 .304 .n8 .411 .411 .411 .411 1.578 1.923 .658 .581 .323 1.907 1.907 .584 2.079 .668 1.578 1.370 4.397 1.436 1.436 4.438 4.438 .323 2.471 4.501 4.501 2.471 2.548 1.510 4.540 4.540 1.542 2.567. 2.567 2.567 2.567 2.567 2.655 2.655 4.540 1.551 3.066 1.570 1.597 1.597 1.597 1.627 1.608 1.608 1.660 4.666 1.732 RIVERISJDE COUNTY TREASURER-TAX COLLECfOR 7 41 Month End Portfolio Holdings Maturity Maturity Par Book Market 1\farket Unrealized Modified Years To CUSIP Description Date Coupon To Mat Value Value Price Value Gain/Loss Duration Maturity 3134G3BSS FHLMC 2YcNc1YcE 3134G3BSS FHL~IC 2YcNciYcE 3134G3BL3 FHLMC 3YcNcl\cB 3134G3BL3 FHL~IC 3YcNc1\cB 3134G3BL3 FHL~TC WcN<"JYcB 3134G3BL3 FHLMC 3YcN<"1YcB 3134G3BL3 FHUvlC 3YcNc1YcB 3134G3BA7 FHUvlC 2YrNc1YrB 3134G3BL3 FHLMC 3YcNc1YcB 3134G3CVO FHL~TC 3YcN<"l YcB 3134G3DJ>2 FHLMC 3.5\"cNciYcB 3134G3EB2 FHLMC 3.5YcNc2YcE 3134G3DY3 FHLI\-JC 3YcN<"lhB 3134G3EN6 FHLMC 3.5YcNf2YcE 3134G2U42 FHLMC 1.5Yc 3134G3GG9 FHL~TC 3YcNc1YcB 3134G3GZ7 FHLMC 2YcNc1\cE 3134G3HD5 FHLMC 2YcNc1YrB 3134G3HD5 FHLMC 2YrNflYrB 3134G3HD5 FHUv!C 2YrNflYrB 3134G3HA1 FHLMC 3YrNc1YrB 3134G3HA1 FHLMC 3YrNc1YrB 3134G3HA 1 FHLI\-IC 3YrNc1 YrB 3134G3HA1 FHLMC 3YrNclYrB 3134G3MM9 FHLMC 2YrNc1YrE 3134G31v!M9 FHLMC 2YrNc1YrE 3134G3LA6 FHUviC 2Yr 3134G3LZ1 FHLMC 2YrNc1YrB 3134G3MY3 FHUv!C 3.5YrNc2YrE 3134G3MY3 FHLMC 3.5YrNc2YrE 3134G3NCO FHLMC 3YrNflYrB 3134G3NLO FHUv!C 3YrNr2YrE 3134G3PD6 FHLMC 3YrNc2YrE 3134G3NS5 FHLMC 2Yr 3134G3QW3 FHLMC 3YrNr2YrE 3134G3QW3 F-HLMC 3YrNc2YrE 3134G3RJ>7 FHLMC 3YrNc2YrE 3134G3SH4 FHLMC 5YrNc1YrB 3134G3550 FHLMC 2.5YrNrlYrE 3134G3QW3 FHLMC 3YrNc2YrE 3134G3SB7 FHLMC 2Yr 3134G2U42 FHLMC 19lvlo 3137EADD8 FHLMC 3Yr 31398AV90 FNMA 3YrNc2Yr 31398A3NO FNMA 31398A3A8 FNMA 3136FPEL7 FNiv!A 3YrNc6Mo 3136FPEL7 FNMA 3YrNc6Mo 3136FPEL7 FNMA 3YrNc6Mo 3136FPEL7 FNMA 3YcNc61v!o 3136FPEL7 FNMA 3YrNc6Mo 3J398A3NO FN lv!A 31398A3L4 FNMA 3YrNc6Mo 31398A3L4 FNMA 3YrNc6Mo 31398A3L4 FNMA 3YrNc6Mo 31 398A3L4 FNMA 3YrNc6Mo 3J398A3L4 FNMA 3YrNc6Mo 3136FPGA9 FNMA 3YrNc2Mo 3136FPEX1 FNMA 3.25YrNc6Mo 3J398A3R1 FNMA 3.5YrNc6Mo 31398AH54 FNMA 31398A4H2 FNMA 3YrNc6Mo 31398A4H2 FNMA 3YrNc6Mo 3J398A4H2 FNMA 3YrNc6Mo 31398AP71 FNMA 2.2Yr 3J398AT77 FNMA 2.2Yr 3J398AT77 FNMA 2.2Yr 3J398A5Z1 FNMA 3YrNc6Mo 31398A5Z1 FNiv!A 3YrNc6Mo 3l36FPXXO FNMA 4Yr 3136FPZD2 FNMA 4YrNc2Mo 3136FP6XO FNMA 5Yr 3136FPUC9 FNMA 2Yr 3J36FPUC9 FNMA 2Yr 3J398A3K6 FNMA 4Yr 3J36FRGK3 FNMA 3.25YrNc1 YrE 31398A5W8 FNMA 3Yr 3136FPUC9 FNMA 2Yr 31398AVZ2 FNMA 5Yr 3136FRKivl4 FNiv!A4.25YrNc1YrE 3J39SA5Z1 FNiv!A 3Yr 31398A6f4 FNMA 1.75 Yr 12/06/2013 12/06/2013 12/05/2014 12/05/2014 12/05/2014 12/05/2014 12/05/2014 12/05/2013 12/05/2014 12/19/2014 06/19/2015 06/30/2015 12/19/2014 06/30/2015 10/15/2013 01/09/2015 01/03/2014 01/24/2014 01/24/2014 01/24/2014 01/23/2015 01/23/2015 01/23/2015 01/23/2015 02/27/2014 02/27/2014 02/27/2014 02/21/2014 08/28/2015 08/28/2015 02/27/2015 02/24/2015 02/27/2015 03/21/2014 03/06/2015 03/06/2015 03/12/2015 03/28/2017 09/22/2014 03/06/2015 04/28/2014 10/15/2013 04/17/2015 04/28/2014 07/16/2013 09/24/2012 09/03/2013 09/09/2013 09/09/2013 09/09/2013 09/09/2013 09/09/2013 09/24/2012 09/17/2013 09/17/2013 09/17/2013 09/17/2013 09/17/2013 09/20/2013 12/17/2013 03/21/2014 04/04/2012 10/08/2013 10/08/2013 10/08/2013 06/22/201z" 07/30/2012 07/30/2012 11/19/2013 11/19/2013 11/26/2014 12/03/2014 02/04/2016 10/30/2012 10/30/2012 03/14/2014 07/25/2014 12/18/2013 10/30/2012 03/13/2014 08/24/2015 11/19/2013 12/28/2012 .700 700 1.000 1.000 1.000 1.000 1.000 .700 1000 1.000 1.020 1000 875 1.000 375 .850 .500 .600 .600 .600 .875 .875 .875 .875 .400 .400 .375 .500 .650 .650 .550 .500 .550 .300 .625 .625 .650 1.050 .540 .625 .375 .375 .500 .700 .700 1000 1.000 1.000 1.000 1000 .700 1.000 1.000 1.020 1.000 .875 1.000 .400 850 .500 .600 .600 .600 .875 .875 .875 .875 400 .400 .394 .500 .650 .650 .567 .581 .594 .378 .625 .625 .650 1.050 .540 .628 .427 .323 .6]] 5,000,000.00 5,000,000.00 5,000,000 00 5,000,000.00 5,000,000.00 5,000,00000 5,000,000.00 5,000,000.00 10,000,000.00 5,000,000 00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 6,500,000.00 5,000,000.00 5,000,000.00 I 0,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 5,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 4,997,700.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 6,500,000.00 5,000,000.00 5,000,000.00 9,996,000.00 5,000,000.00 5,000,000.00 5,000,000.00 4,997,500.00 4,988,000.00 4,993,500.00 9,984,000.00 5,000,000.00 5,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 100.031250 100.031250 100.156250 100.156250 100156250 100,156250 100.156250 100.093750 100.156250 100.062500 100.156250 100.125000 100093750 100.062500 100.031250 100.125000 100.125000 100.125000 100.125000 100.125000 100.000000 100.000000 100.000000 100.000000 100.000000 100.000000 99.968750 100.000000 99.593750 99.593750 99.718750 99.593750 99.875000 99.875000 99.906250 99.906250 99.968750 99.843750 99.906250 99.906250 99.875000 100.031250 99.593750 5,001,562.50 5,001,562.50 5,007,812.50 5,007,812.50 5,007,812.50 5,007,812.50 5,007,812.50 5,004,687.50 10,015,625.00 5,003,125.00 10,015,625.00 5,006,250.00 5,004,687.50 5,003,125.00 5,001,562.50 10,012,500.00 5,006,250.00 5,006,250.00 5,006,250.00 5,006,250.00 5,000,000.00 5,000,000.00 5,000,000.00 6,500,000.00 5,000,000.00 5,000,000.00 9,996,875.00 5,000,000.00 4,979,687.50 4,979,687.50 4,985,937.50 4,979,687.50 4,993,750.00 9, 987,500.00 4,995,312.50 4,995,312.50 9,996,875.00 4,992,187.50 4,995,312.50 4,995,312.50 4;993,750.00 5,001,562.50 9,959,375.00 4,993,750.00 .140 .140 50,000,000.00 49,935,444.44 99.937500 49,968,750.00 .140 .140 50 000 000.00 49 930 583.33 99.875000 49 937 500.00 ·~~J!&~IF¥~ .1®' .. 't'if'. ?~llllM!».OOJ.¥~~~~!%.-::~~'"lfi~;t:;~ . 1.300 .625 1.050 1.050 1050 1.050 1.050 1.050 .625 1.125 1.125 1.125 U25 ·1.125 1000 1.125 1.350 1.000 1.125 1.125 1.125 ·1.250 L125 L125 .800 .800 1.050 1.125 .561 .500 .500 1.250 1.700 .750 .500 2.750 2.000 .800 .375 1.317 700 1.058 1.050 1.050 1.050 1.084 1.050 .704 U32 1.125 1.125 1.125 1.125 1017 1.141 1.350 .410 J.J25 1.125 1.125 .348 .403 .458 .800 .800 1.050 1.125 .586 .550 .557 1.278 1.700 1.194 .473 1.128 2.000 .870 .349 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 5,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 15,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 5,000,000 00 5,000,000.00 5,000,000.00 4,997,500.00 4,992,300.00- 4,998,750.00 5,000,000.00 5,000,000.00 5,000,000.00 4,995,000.00 5,000,000.00 4,992,000.00 4,999,000.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 4,997,500.00 4, 997,500.00 5,000,000.00 10,088,900.00 5,000,000.00 5,000,000.00 5,000,000.00 10,145,800.00 10,124,000.00 10,114,300.00 10,000,000.00 5,000,000.00 10,000,000.00 10,000,000.00 9,990,000.00 14,988,000.00 9,991,000.00 4, 996,000.00 5,000,000.00 4,941,950.00 5,002,000.00 10,454,500.00 5,000,000.00 4,991,250.00 5,002,000.00 100.281250 100.250000 100.843750 100.812500 100.812500 100.812500 100.812500 100.812500 100.250000 101.031250 101.031250 101.031250 101.031250 101.031250 100.062500 10L125000 101.468750 100.000000 10J.J87500 101.187500 10l.l87500 100.250000 100.312500 100.312500 100.531250 100.531250 100.500000 100.500000 100.312500 100.125000 100.125000 101.625000 100.093750 100.687500 100.125000 104.781250 100.218750 100.531250 100.156250 5,014,062.50 5,012,500.00 5,042,187.50 5,040,625.00 5,040,625.00 5,040,625.00 5,040,625.00 5,040,625.00 5,012,500.00 5,051,562.50 10,103,125.00 5,051,562.50 5,051,562.50 5,051,562.50 5,003,125.00 5,056,250.00 5,073,437.50 10,000,000.00 5,059,375.00 5,059,375.00 5,059,375.00 10,025,000.00 10,031,250.00 10,031,250.00 10,053,125.00 5,026,562.50 10,050,000.00 10,050,000.00 10,031,250.00 15,018,750.00 10,012,500.00 5,081,250.00 5,004,687.50 5,034,375.00 5,006,250.00 10,478,125.00 5,010,937.50 5,026,562.50 5,007,812.50 RIVERISIDE COUNTY TREASURER-TAX COLLECTOR 42 1,562.50 1,562.50 7,812.50 7,812.50 7,812.50 7,812.50 7,812.50 4,687.50 15,625.00 3,125.00 15,625.00 6,250.00 4,687.50 3,125.00 3,862.50 12,500.00 6,250.00 6,250.00 6,250.00 6,250.00 0.00 0.00 0.00 0.00 0.00 0.00 875.00 0.00 -20,312.50 -20;312.50 -11,562.50 -8,312.50 250.00 3,500.00 -4,687.50 -4,687.50 -3,125.00 -7,812.50 -4,687.50 -4,187.50 -650.00 33,305.56 6916.67 16,562.50 20,200.00 43,437.50 40,625.00 40,625.00 40,625.00 45,625.00 40,625.00 20,500.00 52,562.50 103,125.00 5],562.50 51,562.50 51,562.50 5,625.00 58,750.00 73,437.50 -88,900.00 59,375.00 59,375.00 59,375.00 -120,800.00 -92,750.00 -83,050.00 53,125.00 26,562.50 50,000.00 50,000.00 41,250.00 30,750.00 21,500.00 85,250.00 4,687.50 92,425.00 4,250.00 23,625.00 10,937.50 35,312.50 5,812.50 1.664 1.664 2.628 2 628 2.628 2.628 2.628 1.662 2.628 2.666 3.148 3.197 2.672 3.197 1.530 2.729 1.744 1.800 1.800 1.800 2.767 2.767 2.767 2.767 1.896 1.896 1.895 1.877 3.373 3.373 2.877 2.870 2.877 1.964 2.898 2.898 2.914 4.850 2.455 2.898 2.058 1.531 3.027 .588 .760 1.274 .483 1.407 1.424 1.424 1.424 1.423 1.424 .483 1.445 1.445 1.445 1.445 1.445 1.455 1.685 1.939 .011 1.494 1.494 1.494 .227 .331 .331 1.615 1.615 2.600 2.616 3.810 .580 .580 1.922 2.256 1.693- .581 1.900 3.262 1.614 .739 1.685 • 2.682 2.682 2.682 1.682 2.682 2.721 3.219 3.249 2.721 3.249 1.542 2.778 1.762 1.819 1819 1.819 2.816 2.816 2.816 2 816 1.912 1.912 1.912 1.896 3.411 3.4ll 2.912 2.904 2.912 1.973 2.932 2.932 2.948 4.995 2.479 2.932 2.077 1.542 3.047 .589 .762 1.293 .485 1.427 1.444 1.444 1.444 1.444 1.444 .485 1.466 1.466 1.466 1.466 1.466 1.474 1.715 1.973 .011 1.523 1.523 1.523 .227 .332 .332 1.638 1.638 2.658 2.677 3.849 584 .584 1.953 2.318 1.718 .745 8 Month End Portfolio Holdings Maturity Maturity Par Book Market Market Unrealized Modified Years To CUSlP Description Date Coupon ToMat Value Value Price Value GainfLoss Duration Maturity • 5COBN2 5COBR3 COBR3 FRZX4 31398AT77 3136FRC84 3136FRK44 31398A5W8 3135COCQ4 3135COCU5 3135COCU5 3135COCNI 3136FR\V66 3135CODA8 3136FR546 31398AT77 3136FRW66 3136FRV59 3136FR546 3136FR2AO 3135COCN1 3136FR4EO 3135CODT7 3135CODT7 31398A4T6 3135COCN1 3135CODR1 3135CODR1 3135CODV2 3136FR4EO 3136FR4EO 3136FR4EO 3136FrCX5 3136FTDJ5 3136FTFT1 3135COEM1 3135COEQ2 3135GOET6 3135GOFA6 3135GOFF5 3135GOFF5 3135GOFA6 3135COFA6 • COFA6 GOFS7 GOFW8 3135GOFW8 FNMA 3\'rNclYrE FNMA 2.25Yr FNMA 2Yr FNI'v1A 3YrNc1YrE FNMA IYr FNMA 3YrNc1YrE FNMA 3.5YrNc1YrB FNMA 3Yr FNMA 2YrNc1YrE FNMA 3YrNc2YrE FNMA 3YrNc2YrE FNMA 3YrNc1YrE FNMA 5YrNc1YrB FNMA 3YrNc1YrE FNMA 5YrNc1YrB FNMA 11Mo FNMA 5YrNc1YrB FNMA 5YrNc1YrB FNMA 5YrNc1 YrB FNMA 5YrNc1YrB FNMA 3YrNc1YrE FNMA 5YrNc6MoB FNMA 3YrNc6MoB FNMA 3YrNc6MoB FNMA 2Yr FNMA 3YrNc1YrE FNMA 2YrNc6MoB FNMA 2YrNc6MoB FNMA 2YrNc6MoB FNMA 5YrNc6MoB FNMA 5YrNc6MoB FNMA 5YrNc6MoB FNMA 5YrNc1YrB FNMA 5YrNc1YrB FNMA 5YrNc1YrB FNMA 3YrNc1YrB FNMA 3YrNc3MoB FNMA 3YrNc1YrE FNMA 2YrNc6MoB FNMA 3YrNc1YrB FNMA 3YrNc1YrB FNMA 2YrNc6MoB FNMA 2YrNc6MoB FNMA 2YrNc6MoB FNMA 2YrNc1YrB FNMA 2YrNc6MoB FNMA 2YrNc6MoB 3135COFW8 FNMA 2YrNc6MoB 3135GOFY4 FNMA 3Yr 3135GOFZ1 FNMA 3YrNc6MoB 3136FTQJ1 FNMA 5YrNc1YrB 3135GOGA5 FNMA 2YrNc6MoE 3135GOGA5 FNMA 2YrNc6MoE 3135COGA5 FNMA 2YrNc6MoE 3135GOGA5 FNMA 2YrNc6MoE 3135GOGA5 FNMA 2YrNc6MoE 3135GOGA5 FNMA 2YrNc6MoE 3136FTMT3 FNMA 5YrNc1YrB 3136FTMP1 FNMA 5YrNc1YrB 3135COFZ1 FNMA 3YrNc6MoB 3135COGC1 FNMA 3YrNc2YrE 3135COFZ1 FNMA 3YrNc6MoB 3135COGE7 FNMA 3YrNc6MoB 3135COGE7 FNMA 3YrN,·6MoB 3135COFZ1 FNMA 3YrNc6MoB 3135COGC2 FNMA 2YrNc6MoB 3135GOGG2 FNMA 2YrNc6MoB 3135COGG2 FNMA 2YrNc6MoB 3135COGC2 FNMA 2YrNc6MoB 3136FTSB6 FNMA 5YrNc1YrB 3136FTSH3 FNMA 5YrNc1YrB 3136FTTQ2 FNMA 5YrNc1YrB 3135GOGM9 FNMA 3YrNc2YrE 3135COGM9 FNMA 3YrNc2YrE 3136FTUE7 FNMA 3YrNc6MoB 3136FTUE7 FNMA 3YrNc6MoB 3135COGR8 FNMA 2YrNc6MoB 3135COGR8 FNMA 2YrNc6MoB 3136FTUE7 FNMA 3YrNc6MoB 3136FTVW6 FNMA 5YrNc1YrB 3136FTYTO 3136FTZT9 3136FTZP7 3136FTB65 3136FTL23 •~~V~2 FT2DO FT2K4 3135COHX4 FN MA 3YrNc6MoB FNMA 3YrNc6MoB FNMA 5YrNc1YrB FNMA 5YrNc1YrB FNMA 3YrNc1YrE FNMA 3YrNc6MoB FNMA 5YrNc1YrB FNMA SYrNclYrB FNMA 5YrNc1YrB FNMA 3YrNc6MoB 06/27/2014 08/09/2013 08/09/2013 07/18/20"14 07/30/2012 07/25/2014 02/23/2015 12/18/2013 09/06/2013 09/12/2014 09/12/2014 08/28/2014 09/21/2016 09/12/2014 09/14/2016 07/30/2012 09/21/2016 09/14/2016 09/14/2016 09/21/2016 08/28/2014 09/28/2016 10/17/2014 10/17/2014 10/30/2012 08/28/2014 10/03/2013 10/03/2013 10/18/2013 09/28/2016 09/28/2016 09/28/2016 10/26/2016 10/26/2016 ll/09/2016 ll/07/2014 11/07/2014 11/07/2014 ll/14/2013 11/14/2014 ll/14/2014 11/14/2013 ll/14/2013 11/14/2013 ]] /21/2013 11/25/2013 11/25/2013 11/25/2013 12/19/2014 12/05/2014 11/21/2016 ll/29/2013 ll/29/2013 ]] /29/2013 11/29/2013 11/29/2013 11/29/2013 ll/21/2016 ll/23/2016 12/05/2014 12/05/2014 12/05/2014 12/05/2014 12/05/2014 12/05/2014 12/06/2013 12/06/2013 12/06/2013 12/06/2013 12/07/2016 12/20/2016 12/28/2016 12/23/2014 12/23/2014 12/29/2014 12/29/2014 12/27/2013 12/27/2013 12/29/2014 12/28/2016 OJ /30/2015 01/30/2015 01/30/2017 01/30/2017 DZ/13/2015 03/13/2015 03/08/2017 03/22/2017 03/20/2017 03/13/2015 1.000 500 500 1.200 1.125 1.020 1.000 750 450. .625 .625 650 1.000 .750 1.125 1.125 1.000 1.050 1.125 1.000 .650 1.250 .700 .700 500 .650 .500 .500 .550 1.250 1.250 1250 1250 1.000 1.500 1.000 1.000 .900 .640 1.000 1.000 .640 .640 .640 .600 .625 .625 .625 .750 1.000 1.625 .650' .650 .650 .650 .650 .650 1.125 U25 1.000 .850 1.000 1.000 1.000 1.000 .750 .750 .750 .750 1.000 1.250 1.500 .825 .825 .900 .900 .550 .550 .900 1.125 .500 .375 1.000 1.000 .300 .600 1.000 1.000 1.100 .700 RIVERJSIDE COUNTY TREASURER-TAX COLLECTOR 1.000 .580 .600 1.200 264 1.020 1000 .480 .450 625 625 650 1.000 .750 1.140 .183 1.021 1.071 1.146 1.000 650 1.260 700 700 228 650 .500 .500 . .550 1.250 1.255 1.250 1.250 1.006 1.500 1.000 1.000 .900 .640 1.000 1.000 .640 .640 .640 .600 .625 .625 .625 .728 1.000 1.625 650 .650 .650 .650 .650 .650 1.125 1.125 1.000 .850 1.000 1.000 1.000 1.000 750 .750 .750 .750 1.000 1250 1.500 .825 .825 .900 .900 .550 .550 .900 1.125 .500 .375 1.000 1.000 .300 .600 1.000 1.000 l.lOO .700 5,000.000 00 10,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5.000,000 00 10,000,000 00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5.000,000 00 5,000,000.00 5,000,000.00 4,000,000.00 5,000,000.00 5,000,000.00 . 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000 00 20,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 10,000,000 00 5,000,000.00 12,685,000.00 10,000,000.00 10,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000 00 5,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 5,000,000.00 15,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000 00 12,000,000.00 10,000,000.00 5,000,000 00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,00000 20,000,000 00 5,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000 00 5,000,000.00 5,000,000.00 10,000,000.00 5,000,000.00 10,000,000.00 5,000,000 00 4,740,000.00 5,425,000 00 10,000,000 00 5,000,000.00 5,000,000.00 5,000,000.00 5,600,000.00 5,000,000 00 43 5,000,000.00 9, 983,000.00 9, 979,200.00 5,000,000.00 5,045.700.00 5,000,000.00 5,000,000.00 10,063,305.58 10,000,00000 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000 00 5,000,000.00 4, 996,250.00 5,043,785.00 4,995,000.00 3,996,000.00 4,995,000.00 5,000,000.00 5,000,000.00 4,997,500.00 5,000,000.00 5,000,000.00 20,059,800.00 5,000,000.00 5,000,000 00 5,000,000.00 10,000,000.00 10,000,000 00 4,998,750.00 5,000,000.00 10,000,000.00 4,998,500.00 12,685,000.00 10,000,000.00 10,000,000.00 10,000,000.00 5,000,000.00 5,000,000 00 10,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 10,006,700.00 5,000,00000 5,000,000.00 10,000,000.00 5,000,000.00 15,000,000 00 10,000,00000 5,000,000.00 5,000,000.00 5,000,000.00 12,000,000.00 10,000,000 00 5,000,000.00 5,000,000 00 5,000,000 00 5,000,000.00 5,000,000.00 5,000,000.00 20,000,000.00 5,000,000 00 5,000,000.00 5,000,000.00 10,000,000.00 10,000,000 00 5,000,000.00 5,000,000 00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,00000 10,000,000.00 5,000,000.00 10,000,000 00 5,000,000.00 4,740,000.00 5,425,000.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000 00 5,600,000.00 5,000,000.00 100 156250 100.250000 100.250000 100.218750 100.312500 100.187500 100.218750 100.687500 100.031250 100062500 100.062500 100.062500 100.281250 100.187500 100.312500 100.312500 100.281250 100.281250 100.312500 100.375000 100.062500 100.187500 99.812500 99.812500 100.187500 100.062500 100.000000 100.000000 100.000000 100.187500 100.187500 100.187500 100.250000 100.156250 100.562500 100.250000 100.250000 100.218750 100031250 100.218750 100.218750 100.031250 100.031250 100.031250 100.000000 100.031250 100.031250 100.031250 100.437500 100.062500 100.343750 100.093750 100.093750 100.093750 100.093750 100.093750 100.093750 100.062500 100.250000 100 062500 100.156250 100.062500 100.062500 100.062500 100.062500 100.031250 100.031250 100 031250 100.031250 100.125000 100.281250 100.281250 100.062500 100.062500 100.093750 100.093750 99.937500 99.937500 100.093750 100.250000 100.031250 100 000000 100.187500 100.093750 99937500 100031250 99.781250 99.937500 100062500 100.093750 5,007,812.50 10,025,000.00 10,025,000.00 5,010,937.50 5,015,625.00 5,009,375.00 5,010,937.50 10,068,750.00 10,003,125.00 5,003,125.00 5,003,125.00 5,003,125.00 5,014,062.50 5,009,375.00 5,015,625.00 5,015,625.00 5,014,062.50 4,011,250.00 5,015,625.00 5,018,750.00 5,003,125.00 5,009,375.00 4,990,625.00 4, 990,625.00 20,037,500.00 5,003,125.00 5,000,000.00 5,000,000.00 10,000,000.00 10,018,750.00 5,009,375.00 5,009,375.00 10,025,000.00 5,007,812.50 12,756,353.13 10,025,000.00 10,025,000.00 10,021,875.00 5,001,562.50 5,010,937.50 10,021,875.00 10,003,125.00 5,001,562.50 5,001,562.50 5,000,000.00 5,001,562.50 5,001,562.50 5,001,562.50 10,043,750.00 5,003,125.00 5,017,187.50 10,009,375.00 5,004,687.50 15,014,062.50 10,009,375.00 5,004,687.50 5,004,687.50 5,003,125.00 12,030,000.00 10,006,250.00 5,007,812.50 5,003,125.00 5,003,125.00 5,003,12500 5,003,125.00 5,001,562.50 20,006,250.00 5,001,562.50 5,001,562.50 5,006,250.00 10,028,125.00 10,028,125.00 5,003,125.00 5,003,125.00 5,004,687.50 5,004,687.50 4,996,875.00 4,996,875.00 10,009,375.00 5,012,500.00 10,003,125.00 5,000,000.00 4,748,887.50 5,430,085.94 9, 993,750.00 5,001,562.50 4,989,062.50 4,996,875.00 5,603,500.00 5,004,687.50 7,812.50 42,000.00 45,800 00 10,937.50 -30,075.00 9,37500 10,937.50 5,444.42 3,125.00 3,125.00 3,125.00 3,125.00 14,0o2.50 9,375.00 19,375.00 -28,160.00 19,062.50 15,250.00 20,625.00 18,750.00 3,125.00 11,875.00 -9,375.00 -9,375.00 ·22,300.00 3,125.00 0.00 0.00 0.00 18,750.00 10,625.00 9,375.00 25,000.00 9,312.50 71,353.13 25,000.00 25,000.00 21,875.00 1,562.50 10,937.50 21,875.00 3,125.00 1,562.50 1,562.50 0.00 1,562.50 1,562.50 1,562.50 37,050.00 3,125.00 17,187.50 9,375.00 4,687.50 14,062.50 9,375.00 4,687.50 4,687.50 3,125.00 30,000.00 6,250.00 7,812.50 3,125.00 3,125.00 3,125.00 3,125.00 1,562.50 6,250.00 1,562.50 1,562.50 6,250.00 28,125.00 28,125.00 3,125.00 3,125.00 4,687.50 4,687.50 -3,125.00 -3,125.00 9,375.00 12,500.00 3,125.00 0.00 8,887.50 5,085.94 -6,250.00 1,562.50 -10,937.50 -3,125.00 3,500.00 4,687.50 2.203 1.348 I 348 2254 331 2.280 2.843 1.699 1 424 2.424 2.424 2.384 4 362 2.420 4.329 .331 4.361 4.337 4.329 4.362 2 385 4 354 2.510 2.510 581 2.385 1.494 1.494 1.535 4.354 4.354 4.354 4.404 4.437 4.408 2.550 2.550 2.555 1.605 2.570 2.570 1.605 1.605 1.605 1.625 1.636 1.636 1.636 2.679 2.628 4.425 1.646 1.646 1.646 1.646 1.646 1.646 4.490 4.495 2.628 2.635 2.628 2.628 2.628 2.628 1663 1.663 1.663 1.663 4.550 4.554 4.543 2.686 2.686 2.699 2.699 1.726 1726 2.699 4.592 2.805 2.811 4.697 4697 2.851 2.919 4.802 4.840 4.822 2.914 2.241 1.359 1.359 2.299 .332 2.318 2901 1.718 1.436 2 452 2.452 2.411 4A79 2.452 4.460 .332 4.479 4.460 4 460 4.479 2.411 4 499 2.548 2.548 .584 2.411 1.510 1.510 1.551 4.499 4.499 4.499 4 575 4.575 4.614 2.605 2.605 2.605 1.625 2.625 2.625 1.625 1.625 1.625 1.644 1.655 1.655 1.655 2.721 2.682 4.647 1.666 1.666 1.666 1.666 1.666 1.666 4.647 4.652 2.682 2.682 2.682 2.682 2.682 2.682 1.685 1.685 1.685 1.685 4.690 4.726 4.748 2.732 2732 2.748 2.748 1.742 1.742 2.748 4.748 2.836 2.836 4.838 4.838 2.874 2.951 4.940 4.978 4.973 2.951 9 Month End Portfolio Holdings Maturity Maturity Par Book Market Market Unrealized Modified Years To CUSIP Description Date Coupon To Mat Value Value Price Value Gain/Loss Duration Maturity 3136FT2K4 3136FT2K4 3135COJBO 3135COHC1 3135COBR3 3135CO!I3 FNtvlA 5YrNdYrB FNI'vlA 5YrNl1YrB FNI'vlA 3YrNc1Yr6 FN1v1A 3Yr FNt\l.A 1.4Yr FNMA 3YrNc1YrB FHLB DISC NOTES 313384ZN2 FHLB DISC NOTE 313384CSO FH LB DISC NOTE 313384D71 FHLB DISC NOTE 313384F61 FHLB DISC NOTE 3133841vl71 FHLB DISC NOTE 313385BD7 FHLB DISC NOTE FHLB BONDS 3133XVNT4 FHLB 3Yr 3133XWKU2 FHLB 2.5Yr 3133XXTU1 FH LB 2.25Yr 3133XYHDO FHLB 3133702E7 FH LB 313370TA6 FHLB3Yr 313370TB4 FH LB 3Yr 3133XWKU2 FHLB2Yr 3133XXPV3 FHLB 2.2Yr 3133XXPV3 FHLB 2.2Yr 3133XWKU2 FHLB 2Yr 3133XXPV3 FHLB 2.2Yr 313371PM2 FHLB 2.6Yr 3133XXPV3 FHLB 2.2Yr 313371UC8 FHLB 3.2Yr 3133XXPV3 FHLB 2.2Yr 3133721<E3 FHLB 4Yr 3133XYVC6 FHLB 5Yr 3133XWKVO FHLB 3Yr 3133736HO FHLB 2.5Yr 313373AS1 FHLB 3Yr 3133XWBW8 FHLB 2.5Yr 313373CZ3 FHLB 3Yr 313373F98 FHLB 2.25Yr 313373JR4 FHLB 3Yr 313373RC8 FHLB 3.25Yr 313373Y22 FHLB 1Yr 313373Y22 FHLB 1Yr 313374285 FHLB 1Yr 313373537 FHLB 2.25Yr 313373Y22 FH LB 1 Yr 313373Y22 FHLB 1Yr 3133XXPV3 FHLB 1Yr 313374EY2 FHLB 1Yr 313374EY2 FHLB 1Yr 313374EY2 FHLB !Yr 313374EY2 FHLB 1Yr 313374EY2 FHLB 1Yr 3133747C8 FHLB 3YrNc1YrE 313374EV8 FHLB 2YrNc1YrB 313374FU9 FH LB 3Yr 313374KV1 FHLB 1YrNc3MoB 313374N63 FH LB 2Yr 313374L81 FHLB 1Yr 313374L81 FHLB 1Yr 3133XXPV3 FHLB 1Yr 3133XXPV3 FHLB 1Yr 313374SV3 FHLB 1Yr 313374SU5 FHLB 1YrNc3MoB 3133745\'3 FHLB 1Yr 3133745\'3 FHLB 1Yr 3133745U5 FHLB 1YrNc3MoB 313374SU5 FHLB 1Y.rNc3MoB 313374YBO FHLB 1Yr 313374Y61 FHLB 2Yr 3133XYWB7 FHLB 1.75Yr 3133755FO FHLB 1Yr 3133756E2 FHLB 1Yr 3133756£2 FHLB 1Yr 313375AHO FHLB 1Yr 313375 BC1 FH LB 9Mo 313375BN6 FHLB 1Yr 313374UA6 FHLB 11 Mo 313375C62 FHLB 9Mo 313375FN2 FHLB 1Yr 313375EU7 FHLB 10Mo 313375KR7 FH LB 9Mo 313374VY3 FHLB 1.5Yr 313375KR7 FHLB9Mo 313375C70 FHLB 1Yr 313375M53 FHLB 1.5YrNc3MoB 313375RP4 FHLB 1Yr 313375UB1 FHLB 1YrNc3MoB 313374VY3 FHLB 1.2Yr 03/20/2017 03/20/2017 03/13/2015 03/16/2015 08/09/2013 03/26/2015 07/18/2012 08/21/2012 08/28/2012 09/12/2012 10/31/2012 01_(28/2013 12/14/2012 06/08/2012 07/12/2012 06/14/2013 04/02/2012 08/28/2013 07/29/2013 06/08/2012 05/18/2012 05/18/2012 06/08/2012 . 05/18/2012 06/26/2013 05/18/2012 12/27/2013 05/18/2012 02/04/2015 06/18/2015 03/]4/2014 09/26/2013 04/29/2014 05/15/2012 05/27/2014 08/15/2013 05/28/2014 07/30/2014 05/23/2012 05/23/2012 05/29/2012 08/28/2013 05/23/2012 05/23/2012 05/18/2012 06/20/2012 06/20';2012 06/20/2012 06/20/2012 06/20/2012 06/20/2014 06/28/2013 07/07/2014 07/25/2012 05/30/2013 07/06/2012 07/06/2012 05/18/2012 05/18/2012 07/30/2012 08/10/2012 07/30/2012 07/30/2012 08/10/2012 08/10/2012 07/25/2012 08/28/2013 08/22/2012 07/30/2012 08/24/2012 08/24/2012 08/08/2012 05/11/2012 08/16/2012 07/16/2012 05/15/2012 09/14/2012 '06/07/2012 06/07/2012 01/29/2013 06/07/2012 08/22/2012 03/27/2013 09/19/2012 10/19/2012 01/29/2013 1.100 1100 .700 .375 500 .700 .160 .200 .170 .170 170 .140 . '170' 1.750 1.375 1.260 L625 .750 875 .850 1.375 1.125 1125 1 375 1.125 .500 1.125 .875 1.125 .471 .974 2.375 1.000 1.350 1.210 1.500 1.000 1.375 1.250 .250 .250 230 750 .250 .250 1.125 .250 .250 .250 .250 .250 1.000 600 .910 .350 .500 .270 .270 1.125 1.125 .250 .350 250 .250 .350 350 .250 500 .875 250 .310 .310 .125 200 .200 260 130 240 .160 .150 .375 .150 .160 .375 .125 .340 .375 RIVERISIDE COUNlY TREASURER-TAX COLLECTOR 1.104 1.100 .700 550 .330 725 160 200 .170 .170 170 .140 1.612 1.212 1.260 1.198 .750 .851 .840 642 459 .453 .370 .342 .590 .445 934 .485 .471 .408 1.404 1.000 1.350 .422 1.500 1.000 1.419 1.250 .250 .230 .230 .671 .234 .203 .213 .250 .250 .250 .250 .250 1.000 .600 .910 .360 .500 .270 .270 .223 .214 .255 .350 .250 .264 .350 .350 .274 .567 .311 .304 .310 .259 .241 .223 .200 .183 .172 .240 .203 .188 .250 .193 .203 .392 .215 .340 .315 5,000,000.00 4,400,000 00 5,000,000.00 5,000,000 00 5,000,000.00 5,000,000 00 10,000,000.00 30,000,000 00 20,000,000 00 10,000,000.00 50,000,000.00 25,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 15,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 10,000,000 00 10,000,000.00 10,000,000.00 5,000,000.00 10,000,000.00 10,000,000.00 20,000,000.00 10,000,000.00 10,000,000.00 15,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 7,500,000.00 10,000,000.00 5,000,000.00 35,000,000.00 10,000,000.00 20,000,000.00 5,000,000.00 5,000,000.00 13,810,000.00 7,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 5,990,000.00 5,000,000.00 10,000,000.00 5,000,000.00 10,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 5,000,000.00 1,875,000.00 10,000,000.00 5,000,000.00 625,000.00 1,250,000.00 10,000,000.00 10,000,000.00 10,000,000.00 20,000,000.00 20,000,000.00 16,700,000.00 9,000,000.00 15,000,000.00 10,000,000.00 5,040,000.00 25,000,000.00 30,000,000.00 28,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 5,000,000.00 25,000,000.00 20,000,000.00 44 4,999,000.00 4,400,000 00 5,000,000 00 4, 973,800 00 5,011,850.00 4, 996,250.00 9, 985,155.56 29,939,500.00 1 g_965,716.66 9,982,811.11 49,914,291 67 24,964,805.56 14{752,280.5& 5,020,050.00 5,017,100 00 5,000,000.00 15,185,10000 5,000,000.00 5,003,500.00 5,001,442.61 10,126,900.00 10,108,600.00 10,109,600.00 5,081,600.00 10,119,200 00 9,976,500.00 20,206,000.00 9, 982,000.00 10,095,500.00 15,000,000.00 5,091,325.00 5,140,200.00 5,000,000.00 10,000,000.00 5,044,075.00 5,000,000.00 7,500,000.00 9,986,700.00 5,000,000.00 35,000,000.00 10,001,985.40 20,000,000.00 5,008,850.00 5,000,800.00 13,816,076.40 7,058,783.69 10,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 5,990,000.00 5,000,000.00 10,000,000.00 4,999,500.00 10,000,000.00 10,000,000.00 5,000,000.00 5,038,900.00 10,078,600.00 4,999,750.00 1,875,000.00 10,000,000.00 4,999,274.10 625,000.00 1,250,000.00 9,997,573.00 9,986,100.00 10,059,900.00 19,989,319.60 20,000,000.00 16,708,491.95 8,989,650.00 14,997,396.00 10,000,000.00 5,043,528.00 24,992,250.00 30,000,000.00 27,990,480.00 4,998,586.70 5,008,800.00 9, 996,800.00 9,995,800.00 9, 997,500.00 4,995,500.00 25,000,000.00 20,015,866.20 100.062500 100.062500 100.093750 99.250000 100.250000 100.375000 100.307513. 99.985000 99.976333 99.975167 99.963556 99 940833 99.875000 99.946176 101.062500 100.218750 100.312500 101.625000 100000000 100.781250 100.718750 100.218750 100.125000 100.125000 100.218750 100125000 100.250000 100.125000 '101.093750 100.125000 100.312500 101.593750 103.843750 100.968750 101.875000 100.125000 102.218750 100.937500 102.125000 101.687500 100.000000 100.000000 100.000000 100.593750 100.000000 100.000000 100.125000 100.031250 100.031250 100.031250 100.031250 100.031250 100.125000 100.062500 100.937500 100.000000 100.250000 100.031250 100.031250 100.125000 100.125000 100.031250 100.031250 100.031250 100.031250 100.031250 100.031250 100.031250 100.250000 100:281250 100.031250 100.062500 100.062500 100.000000 100.000000 100.031250 100.031250 100.000000 100.031250 100.000000 100.000000 100.125000 100.000000 100.000000 100.000000 100.000000 100.000000 100.125000 5,003,125.00 4,40F5000 5,004,687 50 4, 962,500.00 5,012,500.00 5,018,750.00 ' ''91!1,614,07657 9, 998,500.00 29,992,900 00 19,995,033.33 9,996,355.56 49,970,416.67 24,968,750.00 5,053,125 00 5,010,937.50 5,01 5,625.00 15,243,750.00 5,000,000.00 5,039,062.50 5,035,937.50 10,021,875.00 10,012,500.00 10,012,500.00 5,010,937.50 10,012,500.00 10,025,000.00 20,025,000.00 10,109,375.00 10,012,500.00 15,046,875.00 5,079,687.50 5,192,187.50 5,048,437.50 10,187,500.00 5,006,250.00 5,110,937.50 7,570,312.50 10,212,500.00 5,084,375.00 35,000,000.00 10,000,000.00 20,000,000,00 5,029,687.50 5,000,000.00 13,810,000.00 7,008,750.00 10,003,125.00 10,003,125.00 10,003,125.00 10,003,125.00 10,003,125.00 5,997,487.50 5,003,125.00 10,093,750.00 5,000,000.00 10,025,000.00 10,003,125.00 5,001,562.50 5,006,250.00 10,012,500.00 5,001,562.50 1,875,585.94 10,003,125.00 5,001,562.50 625,195.31 1,250,390.63 10,003,125.00 10,025,000.00 10,028,125.00 20,006,250.00 20,012,500.00 16,710,437.50 9,000,000.00 15,000,000.00 10,003,125.00 5,041,575.00 25,000,000.00 30,009,375.00 28,000,000.00 5,000,000.00 5,006,250.00 10,000,000.00 10,000,000.00 10,000,000.00 5,000,000.00 25,000,000.00 20,025,000.00 4,125.00 2,750.00 4,687.50 -11,30000 650.00 22,500.00 13,344.44 53,400.00 29,316.67 13,544.45 56,125.00 3,944.44 33,07500 -6,162.50 15,625 00 58,650.00 0.00 35,562.50 34,494.89 -105,025.00 -96,100.00 -97,100.00 -70,662.50 -106,700.00 48,500.00 -181,000.00 127,375.00 -83,000.00 46,875.00 -11,637.50 51,987.50 48,437.50 187,500.00 -37,825.00 110,937.50 70,312.50 225,800.00 84,375.00 0.00 -1,985.40 0.00 20,837.50 -800.00 -6,076.40 -50;033.69 3,125.00 3,125.00 3,125.00 3,125.00 3,125.00 7,487.50 3,125.00 93,750.00 500.00 25,000.00 3,125.00 1,562.50 -32,650.00 -66,100.00 1,812.50 585.94 3,125.00 2,288.40 195.31 391!.63 5,552.00 38,900.00 -31,775.00 16,930.40 12,50000 1,945.55 10,350.00 2,604.00 3,12500 -1,953.00 7,750.00 9,375.00 9,520.00 1,413.30 -2,550.00 3,200.00 4,200.00 2,500.00 4,500.00 0.00 9,133.80 4.822 4 822 2 914 2.936 1350 2.949 4.973 ~-1!1' 2.986 298 .299 391 .392 .410 411 451 .452 .585 .586 .828 .830 .693 .188 .280 1.184 .005 1.396 1.316 .188 131 .131 .189 .131 1.229 .131 1.718 .131 2.828 3.172 1.91!5 1.471 2031 .123 2.103 1.358 2.109 2.285 .145 .145 .161 1.398 .145 .145 .131 .221 .221 .221 .221 .221 2.184 1.233 2.234 .317 1.158 .265 .265 131 .131 .331 .361 .331 .331 .361 .361 .317 1.401 394 .331 .399 .399 .355 .112 .377 .293 .123 .457 .186 .186 .826 .186 .394 .986 .470 .548 .826 707 .189 .282 1.205 005 1.411 1.329 .189 .132 .132 .189 .132 1.238 .132 1.742 .132 2.849 3.216 1.953 1.490 2.079 .123 2.156 1.375 2.159 2.332 .145 1-, .145 .132 .222 .222 .222 .222 .222 2.222 1.244 2.268 .318 1.164 .266 .266 .132 .132 .332 .362 .332 .332 .362 .362 .318 1.411 .395 .332 .400 .400 .356 .112 .378 .293 .123 .458 .186 .186 .833 .186 .833 10 Month End Portfolio Holdings Maturity Maturity Par Book Market Market Unrealized Modified Years To CUSIP Description Date Coupon fo Mat Value Value Price Value Gain/Loss Duration hfaturity • 74VY3 75U\\'5 75XR3 75XH5 313374VY3 313375XR3 313375X51 313375R-33 3133764H5 3133767(3 313376A70 313376A47 313376AR6 313376BU8 313376CC7 313376C\V3 313376(\\'3 313376E03 313376CW3 3133760\V2 313376CW3 313376CW3 313376CW3 3133760E2 313376G33 313376G33 313376085 313376G33 313376GK5 313376HOO 313376(86 313376jE6 313376]08 313376]55 313376jY2 313376]55 313376]08 313376Kj3 313376]08 313376]08 313376Kj3 313376GT6 76GT6 76]08 76]08 76Kj3 313376]08 313376Kj3 313376LR4 313376G58 313376G66 313374VY3 313376GT6 313376LW3 313375QX8 313376BE4 313376KL8 313376ML6 313376MAO 313375Fj1 313375Fj1 313376MP7 313376036 313376ML6 313376MP7 313376ML6 313376MP7 313376P58 313376MZ5 313376PL3 313376]55 313376PL3 313376A% 313376PA7 313376QN8 313376QN8 313376QU2 313376RHO 313376UFO 313376VB8 313376UY9 313376VS1 313376U78 FHLB 1.2\'c FH LB 5YrNc3MoB FHLB 1YrNr6t\.loB FHLB1Yr FH LB !.2Yr FHLB 1YrNc6MoB FHLB lYr FHLB 1YrN\3MoE FHLB 1YrNc6MoE FHLB 1Yr FHLB 1YrNl6MoB FHLB 2Yr FHLB 1YrNc6MoB FHLB 1Yr FH LB 1.25YrNc6MoB FHLB 1.5Yr FHLB1.5Yr FHLB 1YrNc6MoB FHLB 1.5Yr FHLBlYr FHLB 1.5Yr FHLB 1.5Yr FHLB1.5Yr FHLB 1.5Yr FH LB 13MoNc6MoB FH LB 13Mo6MoNcB FHLB 18Mo FHLB 13MoNc6MoB FHLB 1.5Yr FHLB 1YrNc6MoB FHLB 1.5Yr FHLB 1.5Yr FHLB 1Yr FHLB 1.5Yr FHLB l.5Yr FHLB l.5Yr FHLB1Yr FHLB 18Mo FHL81Yr FHLB 1Yr FHLB 18Mo FHLB 1.5Yr FHLB 1.5Yr FHLB 1Yr FHLB1Yr FHLB 1.5Yr FHLB 1Yr FHLB 1.5Yr FHLB 1Yr FHLB 1Yr FHLB 13Mo FHLB 13Mo FHLB1.5Yr FHLB 1Yr FHLB9Mo FHLB9Mo FHLB 1.5Yr FHLB 1YrNc6MoB FH LB 13MoNc9MoE FHLB8Mo FHLB8Mo FHLB lYr FHLB l.SYr FHLB 1 YrNc6MoB FHLB lYr FH LB 1YrNc6MoB FHLB 1Yr FHLB1.5Yr FHLB 1Yr FHLB 1YrNc3MoB FHLB 1.5Yr FHLB 1YrNc3MoB FHLB 1.5Yr FHLB 1.5YrNc3MoB FHLB 1YrNc9MoE FHLB 1YrNc9MoE FHLB 1.5YrNc3MoB FHLB1.25Yr FHLB 2Yr. FHLB 2Yr FHLB 1.5Yr FH LB 13MoNc9MoE FHLB 1Yr 313376TQ8 FHLB JYr 313376WM3 FHLB 1Yr • 6VB8 6WM3 6550 33 6XA8 313376UY9 FHLB 1.5Yr FHLB 1Yr FHLB 1.75YrNc9MoB FHLB 1Yr FHLB 1.5Yr 01/29/2013 10/20/2016 10/25/2012 10/24/2012 01/29/2013 10/25/2012 10/24/2012 10/03/2012 ll/16/2012 ll/07/2012 11/23/2012 11/29/2013 11/23/2012 ll/15/2012 01/17/2013 05/21/2013 05/21/2013 12/07/2012 05/21/2013 11/29/2012 05/21/2013 05/21/2013 05/21/2013 05/28/2013 01/07/2013 01/07/2013 05/16/2013 Ol/07/2013 06/03/2013 12/17/2012 05/07/2013 05/30/2013 01/11/2013 07/09/2013 06/19/2013 07/09/2013 01/11/2013 06/21/2013 01/11/2013 Ol/11/2013 06/21/2013 05/30/2013 05/30/2013 Ol/ll/2013 Ol/ll/2013 06/21/2013 01/11/2013 06/21/2013 12/13/2012 12/28/2012 12/21/2012 01/29/2013 05/30/2013 01/04/2013 09/26/2012 09/10/2012 06/21/2013 12/28/2012 01/08/2013 08/24/2012 08/24/2012 01/03/2013 05/16/2013 12/28/2012 Ol/03/2013 12/28/2012 01/03/2013 06/28/2013 01/18/2013 01/15/2013 07/09/2013 Ol/15/2013 05/03/2013 07/12/2013 OJ /i8/2013 OJ /18/2013 07/12/2013 04/12/2013 01/29/2014 07/30/2013 08/05/2013 02/20/2013 02/01/2013 02/06/2013 02/08/2013 07/30/2013 02/08/2013 10/25/2013 02/15/2013 08/05/2013 .375 1.000 .330 .230 .375 .330 .220 .350 .350 .200 320 .450 .320 .200 .300 .340 .340 .300 .340 .200 .340 340 .340 .310 .325 •.325 .340 .325 .320 .300 . 300 .375 .210 .375 .400 .375 .210 .400 .210 .210 .400 .350 .350 .210 .210 .400 .210 .400 .200 .200 .190 .375 .350 .200 .240 .140 .400 .250 .250 .220 .220 .210 .300 250 .210 .250 .210 .350 .200 .300 .375 .300 .370 .420 .300 .300 .400 .240 .375 .250 .250 .200 .180 .170 .170 .250 .170 .550 .170 .250 RJVERISIDE COUNTY TREASURER-TAX COLLECTOR .310 1.010 .330 .259 .315 335 .220 .350 .350 .203 .320 470 .320 .213 .300 .343 .343 .300 .340 .203 .340 .340 .340 .310 .325 .325 .340 .325 .320 .300 .340 .375 .249 .375 .400 ·.375 .244 .400 .239 .214 .380 .344 .344 .229 .210 .348 .215 .371 .208 .203 .198 .203 .330 .200 .153 .143 .361 .250 .250 .147 .147 .210 .290 .250 .204 .250 .204 .350 .203 .300 .350 .300 .293 .420 .300 .300 .400 .243 .375 .268 .250 .200 .180 .183 .183 .288 .165 .508 .173 .285 7,750,000.00 5,000,000.00 10,000,000.00 20,000,000.00 10,000,000.00 10,000,000.00 15,000,000.00 2,800,000.00 15,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 20,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 15,000,000.00 5,000,000.00 15,000,000.00 10,000,000.00 5,000,000.00 15,000,000.00 10,000,000.00 15,000,000.00 15,000,000.00 10,000,000.00 15,000,000.00 10,000,000.00 10,000,000.00 15,000,000.00 25,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 5,000,000.00 10,000,000.00 15,000,000.00 15,000,000.00 10,000,000.00 10,000,000.00 15,000,000.00 15,000,000.00 8,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 10,355,000.00 5,000,000.00 25,000,000.00 18,000,000.00 7,000,000.00 10,000,000.00 10,000,000.00 15,000,000.00 10,000,000.00 15,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 5,000,000.00 10,000,000.00 5,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 10,085,000.00 5,000,000.00 10,000,000.00 5,000,000.00 10,000,00000 10,000,000.00 10,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000 00 5,000,000.00 5,000,000.00 2,000,000.00 10,000,000.00 5,000,000.00 45 7,756,634.00 4,997,500.00 10,000,000.00 19,994,200.00 10,007,870.00 9,999,500.00 15,000,000.00 2,800,000.00 15,000,000.00 4,999,830.00 5,000,000.00 4,997,944.55 5,000,000.00 19,997,400.00 10,000,000.00 9,999,500.00 9,999,500.00 10,000,000.00 15,000,000.00 4,999,850.00 15,000,000.00 10,000,000.00 5,000,000.00 15,000,000.00 10,000,000 00 15,000,000.00 15,000,000.00 10,000,000.00 15,000,000.00 10,000,000.00 9,994,300.00 . 15,000,000.00 24,989,425.00 10,000,000.00 10,000,000.00 10,000,000.00 9,996,359.34 10,000,000.00 9,996,900.00 4,999,800.00 10,002,988.60 15,001,381.80 15,001,350.00 9,998,000.00 10,000,000.00 15,011,550.00 14,999,250.00 8,003,520.00 9,999,200.00 9, 999,700.00 9,999,168.10 10,375,399.35 5,001,450.00 25,000,000.00 18,012,582.00 6, 999,839.00 10,005,900.00 10,000,000.00 15,000,000.00 10,005,140.00 15,007,710.00 10,000,000.00 10,001,400.00 10,000,000.00 5,000,330.00 10,000,000.00 5,000,330.00 10,000,000.00 9, 999,670.00 10,000,000.00 10,088,810.82 5,000,000.00 10,010,200.00 5,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 9,999,629.90 5,000,000.00 4,998,690.00 5,000,000.00 5,000,000.00 5,000,000.00 4,999,350.00 4,999,355.00 4,997,191.10 5,000,250.00 2,001,460.00 9,999;700.00 4,997,372.74 100.125000 100.031250 100.000000 100.031250 100.125000 100.000000 100.031250 100.093750 100.031250 10Q.OOOOOO 100031250 100.125000 100.031250 100.000000 100.031250 100.093750 100.093750 100.031250 100.093750 100.000000 100.093750 100.093750 100.093750 100.031250 100.031250 100.031250 100.093750 100.031250 100.062500 100.031250 100.031250 100.125000 100.000000 100.093750 100.093750 100.093750 100.000000 100.093750 100.000000 100.000000 100.093750 100.093750 100.093750 100.000000 100.000000 100.093750 100.000000 100.093750 100.000000 100.(]()()()Qo 100.000000 100.125000 100.093750 100.000000 100.031250 100.000000 100.125000 100.031250 100.031250 100.031250 100.031250 100.000000 100.031250 100.031250 100.000000 100.031250 100.000000 100.093750 100.000000 100.000000 100.093750 100.000000 100.125000 100.000000 100.062500 100.062500 100.000000 100.000000 99.968750 99.937500 99.906250 99.968750 99.968750 99.968750 99.968750 99.937500 99.968750 100.093750 99.937500 99.906250 7,759,687.50 5.001,562 50 10,000,000.00 20,006,250.00 10,012,500 00 10,000,000.00 15,004,687.50 2,802,625.00 15,004,687.50 5,000,000.00 5,001.562.50 5,006,250.00 5,001,562.50 20,000,000 00 10,003,125.00 10,009,375.00 10,009,375.00 10,003,125.00 15,014,062.50 5,000,000.00 15,014,062.50 10,009,375.00 5,004,687.50 15,004,687.50 10,003,125.00 15,004,687.50 15,014,062.50 10,003,125.00 15,009,375.00 10,003,125.00 10,003,125.00 15,018,750.00 25,000,000.00 10,009,375.00 10,009,375.00 10,009,375.00 10,000,000.00 10,009,375.00 10,000,000.00 5,000,000.00 10,009,375.00 I 5,014,062.50 15,014,062.50 10,000,000.00 10,000,000.00 15,014,0&2.50 15,000,000.00 8,007,500.00 10,000,000.00 10,000,000.00 10,000,000.00 10,367,943.75 5,004,687.50 25,000,000.00 18,005,625.00 7,000,000.00 10,012,500 00 10,003,125.00 15,004,687.50 10,003,125.00 15,004,687.50 10,000,000.00 10,003,125.00 10,003,125.00 5,000,000.00 10,003,125 00 s,ooo,ooo·.oo 10,009,375.00 10,000,000.00 10,000,000 00 10,094,454.69 5,000,000.00 1 0,012,500 00 5,000,000.00 10,006,250.00 10,006,250.00 10,000,000.00 10,000,000.00 4,998,437.50 4,996,875.00 4,995,312.50 4,998,437.50 4,998,437.50 4,998,437 50 4,998,_437.50 4,996,875.00 4,998,437.50 2,001,875 00 9,993,750.00 4,995,312.50 3,053.50 4,062 50 0.00 12,050.00 4,630.00 500.00 4,687.50 2,625.00 4,687.50 170.00 1,562.50 8,305.45 1,562.50 2,600.00 3,125.00 9,875.00 9,875.00 3,125.00 14,062.50 150.00 14,062.50 9,37500 4,687.50 4,687.50 3,125.00 4,687.50 14,062.50 3,125.00 9,375.00 3,125.00 8,825.00 18,750.00 10,575.00 9,375.00 9,375.00 9,375.00 3,640.66 9,375.00 3,100.00 200.00 6,386.40 12,680.70 12,712.50 2,000.00 0.00 2,512.50 750.00 3,980.00 800.00 300.00 831.90 -7,455.60 3,237.50 0.00 -6,957.00 161.00. 6,600.00 3,125.00 4,687.50 -2,01500 -3,022.50 0.00 1,725.00 .3,125.00 -330.00 3,125.00 -330.00 9,375.00 330.00 0.00 5,643.87 0.00 2,300.00 000 6,250.00 6,250.00 0.00 370.10 -1,562.50 -1,815.00 4,687.50 -1,562.50 -1,56250 -912.50 -917.50 -316.10 -1,812.50 415.00 -5,950.00 -2,060.24 826 4.420 .565 .563 .826 565 .563 .504 .623 .599 643 1.651 643 621 .793 1.134 1.134 682 1.134 .660 1.134 1.134 1.134 1.154 .765 .765 1.121 .765 1.170 .709 1.096 1.159 .776 1.269 1.211 1.269 .776 1.217 .776 .776 1.217 1.159 1.159 776 .776 1.217 .776 1.217 .699 .740 .721 .826 1.159 .757 .490 .446 1.217 .740 .768 .399 .399 .754 1.121 .740 .754 .740 .754 1.237 .7% .787 1.269 .787 1.085 1.275 .795 .795 1.275 1.028 1.819 1.327 1.342 .885 .832 .846 .852 1.327 852 1.555 •. 871 1.342 833 4.559 .570 .567 833 .570 .567 .510 630 .605 .649 1.666 .649 627 800 1.140 1.140 .688 1.140 666 1.140 1.140 1.140 1.159 .773 773 1.126 .773 1.175 .715 1.101 1.164 .784 1.274 1.219 1 274 .784 1.225 .784 .784 1.225 1.164 1.1.64 .784 .784 1.225 .784 1.225 .704 .745 .726 .833 1.164 .764 .490 .447 1.225 .745 .775 400 .400 .762 1.126 745 .762 .745 .762 1.244 .803 .795 1274 .795 1.090 1282 803 .803 1.282 1.033 1.833 1.332 1.348 893 .841 .855 .860 1.332 .860 1570 .879 1.348 11 Month End Portfolio Holdings 1\faturity Maturity Par Book Market Market Unrealized l\fodified Years To CUSIP Description Date Coupon To Mat Value Value Price Value Gain/Loss Duration Maturity 313378484 FHLB 1Yr 3133784A6 FH LB 3YrNd MoB 313376UY9 FHLB 1.5Yr 3133784F5 FHLB 5YrNc1MoB 3133784F5 FHLB 5YrNd MoB 3J33784T5 FHLB 1.5Yr 3J3376VB8 FHLB 1.5Yr 3133784N8 FHLB 1.5YrNc3MoB 3133764MO FHLB 1.5YrNc1MoB 313378457 FHLB 1Yr 313376YP4 FHLB 5YrNc1MoB 3133764Y4 FH LB 5YrNc1MoB 313378AC5 FHLB 3Yr 313378A50 FHLB 5YrNc1MoB 313378CE9 FHLB 1.2Yr 313378859 FHLB 1Yr 313378BT7 FHLB 1Yr 313378CP4 FHLB 1YrNc6MoE 313378CP4 FHLB 1YrNc6MoE 313378DG3 FHLB 13Mo3MoB 313378D84 FH LB 2YrNc1 MoE 313378ED9 FHLB 1.5Yr 313378DG3 FHLB 1YrNc3MoB 313378EN7 FHLB 5YrNc3MoB 3133783D1 FHLB 2YrNc 313378H79 FHLB 1.5Yr 313376ZQ1 FHLB 3Yr 313378)51 FHLB 2YrNc6MB 313378K U4 FH LB 2.5YrNc6MoB 313378K U4 FH LB 2.5YrNc6MoB 313378ED9 FHLB 1.5Yr 313378L25 FHLB 5YrNc3MoB 313378JN2 FH~B 1Yr 313378JN2 FHLB 1Yr 313376ZQ1 FHLB 3Yr 313378P8B FHLB 13MoNc1MoB 313376YC3 FHLB 1Yr 313378LW9 FHLB L5Yr 313378QE4 FHLB 2YrNc1YrA 313376TZ8 FHLB 1Yr 313378BF7 FHLB 1Yr 313378JN2 FHLB 1Yr 313378577 FH LB 5YrNc1 MoB 02/08/2013 02/27/2015 08/05/2013 02/28/2017 02/28/2017 08/09/2013 07/30/2013 03/08/2013 03/08/2013 02/11/2013 02/27/2017 02/28/2017 05/22/2015 02/28/2017 05/07/2013 02/28/2013 02/15/2013 02/28/2013 02/28/2013 03/19/2013 03/12/2014 09/09/2013 03/19/2013 03/15/2017 02/13/2014 09/09/2013 03/13/2015 03/05/2014 09/12/2014 09/12/2014 09/09/2013 03/29/2017 03/05/2013 03/05/2013 03/13/2015 04/15/2013 02/06/2013 09/]2/2013 03/28/2014 02/27/2013 02/28/2013 03/05/2013 03/27/2017 .170 .600 .250 1.000 1.000 250 .250 .200 .210 .170 1.000 1.000 500 1.000 .260 .190 .190 .250 .250 .270 .500 .310 .270 1.000 .300 .300 .375 .430 .500 .500 .310 1.050 .125 .125 .375 .300 .150 .260 .500 .170 .lBO .125 1.250 170 600 .250 1.000 1.000 .250 266 .200 .210 .170 1.000 1.000 .500 1.000 .260 .219 219 .250 .250 .270 .500 .310 270 1.000 .379 .300 .551 .430 .500 .500 .291 1.050 .228 .213 .689 .300 .250 .348 .500 .2~0 .240 .254 1.271 5,000,000.00 5,000,000.00 5,000,000 00 3,500,000.00 6,500,000.00 5,000,000 00 5,000,000 00 5,000,000.00 5,000,00000 5,000,000.00 5,500,000.00 5,000,000.00 5,000,000.00 10,000,000.00 15,000,000.00 5,000,000.00 5,000,000.00 15,000,000.00 20,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 5,000,000.00 10,000,000.00 10,000,000.00 5,000,000.00 5,000,000.00 9,900,000.00 10,000,000.00 5,000,000.00 5,000,000.00 313312WG1 FFCB DISC NOTE 05/01/2012 .240 .241 7,000,000.00 313313609 FFCB DISC NOTE 01/28/2013 .140 .140 25,000,000.00 3133J3BA5 FFCB DISC NOTE 01/25/2013 .200 .200 50,000,000.00 '.-•:Yiff;i1·U~.f[,:::I~'1\i£'if£:'\\ll1;$fl#;l~\i'£}?~)jjjJt~l/il~·';J:i?-¥4iJf%1~~~\)9,1lpjl,OO' FFCB BONDS 31331GNQ8 FFCB 31331GYP8 FFCB 3Yr 31331GYP8 31331GYP8 31331)QUO 31331)Y56 31331)6A& 31331)6A6 31331)7A5 31331)7A5 31331)6A6 31331KET3 FFCB3Yr FFCB3Yr FFCB3Yr FFCB2Yr FFCB3Yr FFCB3Yr FFCB 1.5Yr FFCB1.5Yr FFCB3Yr FFCB2.5Yr 31331KGN4 FFCB3Yr 31331 KHV5 FFCB 5Yr 31331 KKT6 FFCB 1Yr 31331 KEV8 FFCB 1Yr 31331KNH9 FFCB1Yr 31331 KPCS FFCB 2.2Yr 31331 KQU7 FFCB L5Yr 31331 KPD6 FFCB 2.5Yr 31331KML1 FFCB 1Yr 31331 KMM9 FFCB L5Yr 31331 KMM9 FFCB L5Yr 31331 KUW8 FFCB 2.25YrNc3MoA 31331 KZJ2 FFCB 2Yr 31331 KB82 FFCB 2Yr 31331KZK9 FFCB l.25Yr 31331KK74 FFCB3YrNc1YrA 31331 KK74 FFCB 3YrNc1YrA 31331K5K2 FFCB2Yr 3133EAC)5 FFCB 1.5YrNc3MoE 3133EADY1 FFCB2YrNc1YrA 31331KZFO FFCB21MoNc1MoA 3133EAHP6 FFCB3Yr 0 ~ ,· :~\1{4\~Jtfft~Y~>:~;~ N ,~/' FMAC DISC NOTES 31315KWW6 FMAC DISC NOTE 31315KXU9 FMAC DISC NOTE 3131 5KYT1 FMAC DISC NOTE 04/24/2012 06/18/2012 06/18/2012 06/18/2012 06/03/2013 11/02/2012 12/23/2013 12/23/2013 07/10/2012 07/10/2012 12/23/2013 09/23/2013 2.250 2.125 2.125 2.125 1.600 .400 1.300 1.300 .500 .500 1.300 .960 04/07/2014 1.400 04/20/2016 .312 05/16/2012 .210 06/22/2012 .290 06/13/2012 .240 08/20/2012 .250 01/07/2013 .400 11/20/2013 .625 06/01/2012 .210 12/03/2012 .350 12/03/2012 .350 11/18/2013 .500 09/23/2013 .350 10/03/2013 .350 11/23/2012 .240 11/07/2014 .850 11/07/2014 850 01/03/2014 .400 08/07/2013 .180 02/21/2014 .330 12/23/2013 .470 03/16/2015 .520 05/15/2012 .210 06/06/2012 .210 06/29/2012 .220 RlVERISIDE COUNTY TREASURER-TAX COLLECTOR 1.762 2.210 5,000,000.00 5,000,000.00 2.210 3,000,000.00 1 .37 4 8,500,000.00 .752 10,000,000.00 540 10,000,000.00 1.300 5,000,000.00 1.300 5,000,000.00 .500 10,000,000.00 .500 9,205,000.00 1.184 5,000,000.00 1.029 10,000,000.00 1.400 10,000,000.00 .324 10,000,000.00 .224 25,000,000.00 .244 5,000,000.00 .240 20,000,000.00 .250 20,000,000.00 .400 5,000,000.00 .700 5,000,000.00 .213 5,000,000.00 .376 10,000,000.00 .340 5,000,000.00 .522 5,000,000.00 .400 10,000,000.00 .400 5,000,000.00 .254 5,000,000.00 .850 5,000,000.00 .850 5,000,000.00 .420 6,000,000.00 .240 5,000,000.00 .38P 5,000,000.00 .471 2,000,000.00 .598 5,000,000.00 .210 .210 .220 25,000,000.00 20,000,000.00 20,000,000.00 46 5,000,000.00 5,000,000.00 5,000,000.00 3,500,000.00 6,500,000.00 5,000,000.00 4,998,800.00 5,000,000.00 5,000,000.00 5,000,000.00 5,500,000.00 5,000,000.00 5,000,000.00 10,000,000.00 15,000,000.00 4,998,550.00 4, 998,550.00 15,000,000.00 20,000,00000 10,000,000.00 10,000,000.00 10,000,000.00 10,000,000.00 5,000,000.00 4, 992,300.00 5,000,000.00 4,973,550.00 5,000,000.00 5,000,000.00 5,000,000.00 5,001,450.00 10,000,000.00 4,994,955.00 4,995,700.00 4,953,525.00 10,000,000.00 9,991,100.00 4,994,950.00 5,000,000.00 9,893,565.00 9,994,400.00 4,993,850.00 4,995,000.00 99.968750 99.812500 99.906250 99.593750 99.593750 99.906250 99.937500 99.968750 99968750 99.937500 99.281250 99.531250 99.343750 99.468750 100.000000 99.968750 99.968750 100.031250 100.031250 100.031250 100.000000 99.968750 100.031250 99.750000 99.843750 99.968750 99.187500 99.937500 99.843750 99.843750 99.968750 99.906250 99.906250 99.906250 99.187500 100.000000 99.937500 99.937500 100.187500 99.937500 99.968750 99.906250 100.062500 4,998,437.50 4,990,625.00 4,995,312 50 3,485,781 25 6,473,593.75 4,995,312.50 4,996,875.00 4,998,437.50 4,998,437.50 4,996,875.00 5,460,468.75 4,976,562.50 4,967;187.50 9,946,875.00 15,000,000.00 4,998,437.50 4,998,437:50 15,004,687.50 20,006,250.00 10,003,125.00 10,000,000.00 9,996,875.00 10,003,12500 4,987,50000 4,992,187.50 4,998,437.50 4,959,37500 4,996,875.00 4,992,187.50 4,992,187.50 4, 998,437.50 9,990,625.00 4,995,312.50 4,995,312.50 4,959,375.00 10,000,000.00 9,993,750.00 4,996,875.00 5,009,375.00 9,893,812.50 9,996,875.00 4,995,312.50 5,003,125.00 -1,5h2 50 -9,375.00 -4,687 50 -14,218.75 -26,406 25 -4,687.50 -1,92500 -1,562.50 -1,562.50 -3,125.00 -39,531.25 -23,437.50 -32,812.50 -53,125 00 0.00 -112.50 -112.50 4,687.50 6,250.00 3,125.00 0.00 -3,125.00 3,12500 -12,500 00 -112.50 -1,562.50 -14,175.00 -3,125.00 -7,812.50 -7,812.50 -3,012.50 -9,375.00 357.50 -387.50 5,850.00 0.00 2,650.00 1,925.00 9,375.00 247.50 2,475.00 1,462.50 8,125.00 852 2.8/5 1.342 4.782 4.782 1.352 1.327 .935 .935 .860 4 771 4.782 3.108 4.782 1.097 .915 .871 .915 .915 .965 1.935 1.434 . 965 4 821 1.859 1.434 2.925 ·1.917 2.429 2.429 L434 4.853 .926 .926 2.923 1.035 .846 1.443 1.979 .904 .915 .926 4.821 6,983,013.33 100.000000 7,000,000.00 16,986.67 24,964,805.56 99.875000 24,968,750.00 3,944 44 .828 49,913,61 ]_] 1 99.875000 49,937,500.00 23,888.89 .820 5,066,900.00 4,988,000.00 2, 992,800.00 8,637,785.00 10,211,890.00 9,972,900.00 5,000,000.00 5,000,000 00 10,000,000.00 9,205,000.00 5,015,550.00 9,988,000.00 10,000,000.00 9,995,000.00 24,996,600.00 5,002,450.00 20,000,000.00 20,000,000.00 5,000,000.00 4,991,100.00 4,999,850.00 9, 996,600.00 5,000,650.00 4,997,500.00 9,990,100.00 4,995,050.00 4,999,200.00 5,000,000.00 5,000,000.00 5, 997,600.00 4,995,500.00 4,995,000.00 1,999,980.00 4,988,430.00 24,946,770.83 19,957,416.67 19,955,511.11 100.125000 100.406250 100.406250 100406250 101.531250 100.125000 101.375000 101.375000 100.093750 100093750 101.375000 100.843750 101.593750 100.125000 100.000000 100.031250 100.031250 100.031250 100.125000 5,006,250.00 5,020,312.50 3,012,187.50 8,534,531.25 10,153,125.00 10,012,500.00 5,068,750.00 5,068,750.00 10,009,375.00 9,213,629.69 5,068,750.00 10,084,375.00 10,159,375.00 10,012,500 00 25,000,000.00 5,001,562.50 20,006,250.00 20,006,250 00 5,006,250.00 -60,650.00 32,312.50 19,387.50 -103,253.75 -58,765.00 39,600.00 68,750.00 68,750.00 9,375.00 8,629.69 53,200.00 96,375.00 .065 .214 .214 .215 1.156 584 1.697 1.697 .276 .276 1.698 1.463 159,375.00 1.968 17,500.00 4.028 3,400.00 .126 -887.50 227 6,250.00 .202 6,250.00 .388 6,250.00 .764 100.250000 5,012,500.00 21,400.00 1.621 100.000000 5,000,00000 150.00 .170 100.093750 10,009,375.00 12,775.00 .670 100.093750 5,004,687.50 4,037.50 .670 99.906250 4,995.312.50 -2,187.50 1.619 99.906250 9,990,625.00 525.00 1.472 99.906250 4,995,312.50 262.50 1.497 100.031250 5,001,562.50 2,362.50 .643 100.156250 5,007,812.50 7,812.50 2.558 100.156250 5,007,812.50 7,812.50 2.558 99.812500 5,988,750.00 -8,850.00 1.746 99.750000 4,987,500.00 -8,000.00 1.348 99.562500 4,978,125.00 -16,875.00 1.860 99.781250 1,995,625.00 -4,35500 1.717 99.250000 4,962,500.00 -25,930.00 2.930 100.000000 100.000000 100.000000 25,000,000.00 20,000,000.00 20,000,000.00 53,229.17 .123 42,583.33 .183 44,488.89 .246 .860 ~.9 4. 49 1.359 1.332 .937 937 .868 4.915 4.918 3.142 4.918 U01 915 .879 .915 .915 967 1.948 1.444 .967 4.959 1.874 1.444 2.951 1.929 2.452 2.452 1.444 4.997 .929 .929 2.951 1.041 .855 1.452 1.992 .912 .915 .929 4.992 .830 .822 .066 .216 .216 .216 U75 592 1.732 1.732 277 277 1.732 1.482 2.019 4058 126 .227 .203 .389 .773 1.641 .170 .677 .677 1.636 1.482 1.510 .649 2.605 2.605 1.762 1353 1.896 1.732 2.959 .247 12 Month End Portfolio Holdings Maturity Maturity Par Book Market Market Unrealized Modified Years To CUSIP Description Date Coupon ToMat Value Value Price Value GainfLoss Duration ~faturity 31315PVUO FARMER MAC GTD 31315PVUO FARMER MACGTD 31315PVUO FARMER MAC GTD 31315PSH3 FARMER MAC GTD MUNI BONDS 20775BND4 CT HFA 041042RKO ARKANSAS ST 649791 EB2 801320AV4 677521 LG9 677521 LH7 880541QG5 646039TR8 STATE OF NEW YORK COUNTY OF SANTA BARBARA OHIOSTATEGO OHIOSTATEGO STATE OF TENNESSEE NEW JERSEY ST TRAN COMMPAPER 36959HD46 GE CAPITAL CORP 36959HEFO GE CAPITAL CORP 36959HFD4 GE CAPITAL CORP 36959Hj57 GE CAPITAL CORP • • 05/10/2013 05/10/2013 05/10/2013 04/25/2013 05/15/2012 07/01/2012 09/01/2012 06/29/2012 05/01/2013 05/01/2014 08/01/2012 06/21/2012 .760 .760 760 .400 . 616.;: .. 2.180 1.250 650 .270 .740 1.190 .500 2.000 .760 .700 750 .400 : . 613 2.180 1 240 .650 270 .740 1.190 .301 .250 ,, :'-:,·, :.})~,,\1Xdt'tt\~~41 04/04/2012 .350 .351 05/15/2012 .380 .381 06/13/2012 .330 .330 09/05/2012 .330 .331 :~::('~,','~,' ·,':(3$1 . i~?i"'·.· RIVERISIDE COUNTY TREASURER-TAX COLLECTOR 5,000,000.00 5,000,00000 100.312500 5,015,625.00 15,625 00 1.098 1.110 5,000,000.00 5,000,000.00 100.312500 5,015,625.00 15,625.00 1.098 1.ll0 12,500,000.00 12,502,375.00 100.312500 12,539,062.50 36,687.50 1.099 1.i10 15,000,000.00 15,000,000.00 100.125000 15,018,750.00 18 750.00 1.063 1.068 . 37,50Qj)OO,OQ . 37 ,502,37.$.00 / . 100.231?@ . v '37,5$9,1)62.50 C\{htitf~iP.!!Jt. .· s1£1;0(1t \ ··~i[<,\1;093: 850,00000 850,00000 100.000000 850,000.00 0.00 .122 .123 1,440,000.00 1;W0,273 &0 100.019000 1,440,273.60 0.00 .250 .252 23,040,000.00 23,040,000 00 100.000000 23,040,000.00 0.00 .420 .422 25,000,000 00 25,000,000.00 100.000000 25,000,000.00 0.00 .244 .247 5,140,000.00 5,140,000.00 100.000000 5,140,000.00 0.00 1.075 1.085 2,000,000.00 2,000,000.00 100.000000 2,000,000.00 0.00 2.045 2.085 6,265,000.00 6,274,522.80 100.152000 6.274,522.80 0.00 .336 .337 25,000,000.00 25,225,750.00 100.903000 25,225,750.00 0.00 .222 .225 ,,~;~t;:·~:$8!735.~~llfJAlt:t~:'' S8;i)70~~i~l~!i l''ti\11~~1l'li~~·\!tM"1tt :k!h'~l4lfkiLt-k·s4Q?i!t~ '"' Z"\1~1!:1: 30,000,000.00 29,946,625.00 99.997917 29,999,375.00 52,750.00 .011 .Oll 50,000,000.00 49,894,444.44 99.969444 49,984,722.22 90,277.78 .123 .123 35,000,000.00 34,948,345.83 99.929028 34,975,159.72 26,813.89 .202 .203 34,941,287.50 99.751417 34,912,995.83 -28,291.67 .431 .433 . }141!;730,702.77:l-0'fitf\'f9!t914835 • 13 47 Full Compliance The Treasurer's Pooled Investment Fund was rn FULL COMPLIANCE with the Treasurer's Statement of Investment Policy. The County's Investment Policy is more restrictive than the California Government Code. This policy is reviewed a1mually by the County's Investment Oversight Committee and approved by the County Board of Supervisors. Inveshnent Category MUNICIPAL BONDS (MUNI) U.S. TREASURIES 5 YEARS NO LIMIT LOCALAGENCY . 5 YEARS OBLIGATIONS (LAO) FEDERAL AGENCIES 5 YEARS NO LIMIT COMMERCIAL · 270 DAYS 4(/~:\ PAPER.(CP}. ' ','' ', CERTIFICATE & TIME 5 YEARS 30% DEPOSITS (NCD & TCD) .Ri~P;URCHASE Ad~E€~NTS ·(REI'o{ Y1: • REVERSEREPOS MEDIUM TERM NG'I$$(MTNO}' CAL TRUST SHORT TERM FUND 92 DAYS 20% 5YEARS NA NA 1.0% NA MONEY MARKET MUTUAL FUNDS. (MMF) · 60 DAYS{l) 20%.' · . >2o%;:it '.;A;J\Aby 2 · .. · ;dt3. LOCAL AGENCY INVESTMENT FUND (LA IF) NA CA$l-I.(J2EPOSIT NA ACCOUNT NA NA DAILY LIQUIDITY Max $50 million 1 Mutual Funds maturihJ may be interpreted ns ·weighted average maturity not exceeding 60 days. RATINGS NA 2 Or must have an investment advisor with not less than 5 years e::rperience and with assets under management of$500,000,000. THIS COMPLETES THE REPORT REQUIREMENTS OF CALIFORNIA GOVERNMENT CODE 53646 RIVERSIDE COUNTY TREASURER-TAX COLLECTOR 48 • • • 14 " AGENDA ITEM 8 " " " " " " " " " RIVERSIDE COUNTY TRANSPORTATION COMMISSION DATE: May 21, 2012 TO: Budget and Implementation Committee FROM: Michele Cisneros, Accounting and Human Resources Manager THROUGH: Theresia Trevino, Chief Financial Officer SUBJECT: Proposed Budget for Fiscal Year 2012/13 This item is for the Committee to: 1) Receive input on the proposed Budget for FY 2012!13; 2) Forward to the Commission to close the public hearing to receive input on the proposed Budget for FY 2012113; and 3) Adopt the proposed Budget for FY 2012113. BACKGROUND INFORMA T/ON: The annual fiscal budget is the result of staff determining the operating and capital needs for FY 201 211 3 and identifying the resources to fund those needs. The budget process began in December 2011. The goals and objectives approved by the Commission on March 14 were the basis of this budget. The goals and objectives considered during the preparation of the budget relate to mobility 1n1t1atJves, goods movement, improved system efficiencies, environmental stewardship, economic development, intermodalism and accessibility, and public and agency communications, and financial and administrative policies. On May 9, staff presented the proposed budget to the Commission. Subsequent to that presentation, staff updated the document as a result of the following changes, resulting in a net increase of $9,162,400 to the projected ending fund balance: Adjustments to Fiscal Year 2011/12 Projected Amounts " Net increases in Measure A and L TF sales tax revenues, reimbursements and operating transfers in of $4,000,000, $2,000,000, $94,100, respectively, less net decrease of $3,674,500 in projects and operations expenditures after further review and analysis of department worksheets . 51 Agenda Item 8 Adjustments to Fiscal Year 2012/13 Budgeted Amounts • An increase in Measure A and Local Transportation Fund (L TF) sales tax revenues of $8,000,000 and $4,000,000 respectively, due to encouraging recent trends and stabilization of sales tax revenues; • A net decrease of $4,451 ,000 in federal and state reimbursements on the Perris Valley Line project as a result of the recent update to project funding; • A $240,300 increase in federal reimbursements on the Interstate 215/Biaine Street project due to a change in the engineer's cost estimate; • A $450,000 increase in federal reimbursements in rail operations for reprogrammed federal grant funding; • A $42,500 increase in federal reimbursements for administration of the Measure A Western County Specialized Transit program; • A net decrease of $218,000 in operating transfers in related to revised Short Range Transit Plans (SRTP) submissions; • A $44,200 increase in investment income as a result of a net increase in revenues; • A $193,800 increase in personnel salary and benefits due to filling the capital projects contract and claims manager position; • A $470,000 increase in professional services related to disclosure counsel services for the issuances of toll and sales tax revenue bonds, financial advisory services, various procurement services, and graphic design and printing services; • • • • • A net increase of $19,700 in support services related to Commission-owned station ground maintenance needs and travel costs related to the issuance of toll and sales tax revenue bonds after further review and analysis; A $19,200 decrease in program management expenditures for Bechtel Infrastructure (Bechtel) services based on a reconciliation to the proposed Bechtel contract amount; A $777,600 increase in construction costs on the Perris Multimodal facility after further review of claims pending settlement; A $920,000 increase in construction and construction management costs on the State Route 74 curve realignment project related to a change in the engineer's cost estimate; A $240,300 increase in construction and construction management costs on the 1-215/Biaine Street project due to a change in the engineer's cost estimate; • A $2,500,000 increase in construction costs on the Corona Foothill Parkway project after further review and analysis; • An increase of $163,000 in Measure A specialized transit expenditures based on review and analysis of the SRTP submissions; • A net increase of $1,513,000 in LTF expenditures bas~d on review and analysis of the SRTP submissions; 52 Agenda Item 8 • • • " " " " " " " A net decrease of $325,000 in State Transit Assistance expenditures based on review and analysis of the SRTP submissions; An increase of $2,464,000 in local streets and roads expenditures due to the related increase in Measure A sales tax revenues; A $15,000 increase in capital outlay expenditures for information technology equipment upgrades; A net decrease of $218,000 in operating transfers out related to revised SRTP submissions. A public hearing to allow for public comment on the proposed budget, as revised, is required prior to the adoption of the proposed budget. The. public hearing was opened at the May 9 Commission meeting. After the public hearing is closed on June 7, adoption of the proposed budget for FY 2012/13 will follow. In accordance with the Commission's fiscal policies, the budget must be adopted no later than June 15 of each year. Attached is the proposed budget for FY 2012/13. This document contains the executive summary, as revised, that was presented at the May 9 Commission meeting; the Gann Appropriations Limit; the guiding policies related to the preparation of the budget; a summary of the budget process; fund budgets; details of program revenues and other sources; debt; department budgets; a community profile; and appendices including a glossary of acronyms, funding definitions, and program/general terms. A summary of the proposed Budget for FY 2012/13 is as follows: Revenues and other financing sources: Sales taxes-Measure A, L TF, and ST A Reimbursements (federal, state, and other) TUMF Other revenues Interest on investments Debt proceeds Transfers in Total revenues and other financing sources Expenditures and other financing uses: Personnel salary and fringe benefits Professional services Support services Projects and operations Capital outlay Debt service (principal, interest and costs of issuance) 53 Agenda Item 8 FY 2012/13 Budget $ 211,212,500 93,758,400 5,257,300 882,800 7,365,900 1 ,240,172,000 326,095,700 1 ,884, 744,600 6,971 '1 00 14,361,200 5,346,300 464,246,800 447,700 143,413,000 Transfers out Total expenditures and other financing uses Excess of revenues and other financing sources over expenditures and other financing uses Beginning fund balance Ending fund balance 326,095,700 960,881,800 923,862,800 556,693,300 $ 1 ,480,556, 100 Attachment: FY 2012/13 Proposed Budget -Posted on the Commission Website 54 Agenda Item 8 • • • M +-' ~ GJ ... ~ tU) N -c ~ ::J 0 co N -c '-ta GJ ~ Cl) 0 c. ta 0 u '-Cl) D. ·-LL FY 2012/13 Ending Fund Balance {as reported 4/23/12) Projected FY 2012 Adjustments: Increase in sales tax and reimbursements Decrease in project operations Budget FY 2013 Adjustments: Increase in Measure A sales tax revenues Increase in LTF sales tax revenues Decrease in federal and state reimbursements Decrease in operating transfers in Increase in investment income Increase in salaries and benefits Increase in professional costs Increase in support services Decrease in program management costs Increase in construction costs Increase in transit operating & capital distributions Increase in local streets & roads distributions Increase in capital outlay Decrease in operating transfers out FV 2012/13 Ending Fund Balance (per final budget 5/21/12) $ $ Fund Balance 1,471,393, 700 6,094,100 3,674,500 8,000,000 4,000,000 ( 3, 718,200) (218,000) 44,200 (193,800) (470,000) (19,700) 19,200 ( 4,437,900) ( 1,351,000) (2,464,000) (15,000) 218,000 1,480,556,100 " Revenues $318,476,900 " Debt Proceeds $1,240,172,000 " Transfers In $326,095,700 " Expenditures $491,373,100 " Debt Service . $143,413,000 " Transfers Out $326,095,700 009`tte1788`Z $ 00L`560`9ZE 000`ZLZ`Otti 006`59CL 008`Z88 00CLSZ`S OOL`889`Z 008`LI6`LI 006`ZSZ`8L 00S`ZItti 000`000`59 000`000`ZEZ $ La saDmos/sanuanab le�ol u ! sa ads u eal spaaaoid lgaa sapanoS � �D awoDu! luawlsanui sanuanaa aaypp d iAl ni sluawasancimaa lexo] sluawasangwp.1 awls squawas.mgwp.1 l eaapad xel sales V1S xel sales xel sales y aanseavg sanuanaH C CD "T1 rD p IV o rD Actual Budget Projected Budget Measure A Sales Tax $123,439,800 $ 124,000,000 $ 128,000,000 $ 132,000,000 6% LTF Sales Tax 60,772,800 61,000,000 63,000,000 65,000,000 7% STA Sales Tax -9,537,000 14,073,600 14,212,500 49% Federal reimbursements 17,735,600 23,650,700 24,393,600 73,151,900 209% State reimbursements 17,811,800 23,935,100 23,250,200 17,917,800 -25% Local reimbursements 5,021,600 1,081,800 2,932,200 2,688,700 149% TUMF 9,157,900 6,784,300 6,397,400 5,257,300 -23% Other revenues 2,321,800 592,400 450,800 882,800 49% Investment income 4,524,200 1,824,000 3,391,100 7,365,900 304% Total Revenues 240,785,500 252,405,300 265,888,900 318,476,900 26% Debt proceeds 170,000,000 38,000,000 60,000,000 1,240,172,000 3164% Transfers in 185,354,800 169,739,100 166,343,400 326,095,700 92% Total Revenues/Sources $596,140,300 $460,144,400 $ 492,232,300 $ 1,884~ 744,600 310% Management Services Expenditures $7,909,200 Debt Service Expenditures $143,413,000 Regional Programs Expenditures $112,648,600 Transfers Out Uses $326,095,700 Capital Project Development and Delivery Expenditures $370,815,300 Management Services Expenditures/Uses -· Executive Management $ Administration Legislative Affairs and Communications Finance Debt Service Total Expenditures Transfers Out Total Management Services $ Executive Manaaement Administration 4% 17% Actual 626,200 1,085,100 851,600 5,831,100 25,300 8,419,300 -8,419,300 Budget Projected Budget $ 244,300 $ 185,700 $ 283,200 1,235,200 1,064,500 1,355,400 1,297,000 958,100 1,270,500 5,473,000 5,355,800 5,000,100 8,249,500 7,564,100 7,909,200 5,000,000 10,000,000 5, 0001 ()()() $ 13,249,500 $ 17,564,100 $ 12,909,200 Finance . 63% Regional Programs Expenditures/Uses FY2010/11 FY2011/12 FY2011/12 Actual Budget Projected Budget Planning and Programming Services $ 4,564,600 $ 7,450,300 $ 4,065,300 $ 4,522,600 Rail Maintenance and Operations 12,865,700 21,498,600 21,012,900 14,553,300 Public and Specialized Transit 46,749,900 87,042,800 57,515,800 84,685,900 Commuter Assistance 2,831,900 4,226,400 4,231,400 4,038,800 Motorist Assistance 3,530,700 5,263,300 5,286,600 4,848,000 Total Expenditures 70,542,800 125,481,400 92,112,000 112,648,600 Transfers Out 18,505,700 25,090,200 17,317,800 20,082,300 Total Regional Programs $ 89,048,500 $ 150,571,600 $ 109,429,800 $ 132,730,900 Capital Program Expenditures/Uses Actual -Budget Projected~ Budget Salaries and benefits $ 2,308,900 $ 2,795,000 $ 3,026,500 $ 3,113,100 Professional costs 5,450,000 9,601,500 6,202,200 7,500,600 Support costs 309,200 813,000 459,200 587,000 Projects and operations: Program operations 4,608,700 9,259,000 6,398,100 9,538,300 Engineering 27,545,300 41,568,800 27,796,100 24,312,600 Construction 23,914,800 41,777,600 30,670,100 126,964,800 Design build 16,272,900 14,438,000 11,000,000 29,050,000 Right of way and land 44,663,000 76,127,000 54,535,100 109,476,500 Local streets and roads 36,857,·000 36,025,000 38,166,600 39,357,000 Regional arterials 8,638,600 16,262,000 17,409,200 20,400,400 Other 119,500 256,000 257,000 515,000 Debt service 123,338,800 62,995,000 62,964,000 143,413,000 Total Expenditures 294,026,700 311,917,900 258,884,100 514,228,300 Transfers out 166,849,100 139,639,700 139,025,600 301,013,400 Total Capital Project Development & Delivery $460,875,800 $451,557,600 $397,909,700 $ 815,241,700 Transfers out 37% Professional costs 1% Projects and Operations 44% Salaries and benefits 0% Desi&n build 4" Right of way and land 13% rrilletpialui Stai7L pine anno tiL a2uetp.ialu1 StZ/t6/09 ol. hags swept/sauel AOH t6-11S war) uogopodsutui AWIq) 7pRliAla aanwuadx3 13@fom iel!cleD Personnel Professional Support Projects and operations Capital outlay Debt service Total Expenditures Transfers out Total Expenditures/Uses Personnel, Professional, Support, and Capital Outlay EXDenditures $27,126,300 Actual $ 5,868,500 12,115,400 3,571,400 227,922,100 147,300 122,396,600 372,021,300 185,354,800 $557,376,100 ---. ._-~ Projects & Operations Expenditures $464,246,800 Budget Projected $ 6,576,900 $ 6,505,300 17,149,100 13,034,800 5,068,900 4,607,000 353,342,700 271,108,400 516,200 340,700 62,995,000 62,964,000 445,648,800 358,560,200 169,739,100 166,343,400 $ 615,387,900 $524,903,600 Budget $ 6,971,100 14,361,200 5,346,300 464,246,800 447,700 143,413,000 634,786,100 326,095,700 $ 960,881,800 Transfers Out Uses $326,095,700 ...g_ b \f\. V) +-' ~ V) 0 u Q) .2: +-' ro ~ +-' ...g_ b .!!! o. c ~ E "'0 <( V) +-' -.::: ...g_ OQ Q) c o. Q) co ~ "'0 c ro V) -~ ~ ~ ro ...g_ OQ V'l \f\. 0 Measure A administrative management services salaries and benefits Funding needs for projects and transit operators Sales tax and TUMF revenue trends Timeliness of federal and state reimbursements Receive input for the proposed budget and continue the public hearing " AGENDA ITEM 9 " " " " " " " " RIVERSIDE COUNTY TRANSPORTATION COMMISSION DATE: May 21, 2012 TO: Budget and Implementation Committee FROM: Marla Modell, Procurement Administrator Matt Wallace, Procurement Manager THROUGH: Theresia Trevino, Chief Financial Officer SUBJECT: Recurring Contracts for Fiscal Year 2012!13 STAFF RECOMMENDATION: This item is for the Committee to: 1) Approve the recurring contracts for FY 2012/13; 2) Authorize the Chair, pursuant to legal counsel review, to execute the agreements on behalf of the Commission; and 3) Forward to the Commission for final action. BACKGROUND /NFORMA TION: As in previous years, the Commission annually evaluates ex1stmg contracts for professional services that are due to expire within the next fiscal year. These contracts may be placed on the calendar for a new procurement solicitation, allowed to expire because they are no longer required, or included in the annual recurring contracts list that is subject to Commission approval. Most contracts for professional services are subject to a competitive process. This year's list of recurring contracts includes consultants that are providing unique or specialized services and working closely with staff on long-term projects. Staff desires to retain a limited. number of consultants on the recurring contracts list because of their historical knowledge, unique experience, and understanding of the Commission and specific Commission projects. Under limited circumstances, staff believes it is more efficient and cost effective to retain the consultants on the recurring contracts list rather than rebidding the services at this particular time. Approval of the recurring contracts list will allow the Commission to continue work on existing projects without interruptions and maintain consistency. The list of proposed recurring contracts for FY 2012/13, followed by a summary for each consultant supporting its inclusion on the recurring contracts list is as follows: Agenda Item 9 55 I Dollar Change Consultant Budget Budget FY 12- Name Description of Services FY 11/12 FY 12/13 FY 13 AMMA Consultant support for Transit administration of Specialized Transit Planning Program under Measure A and (AMMA) federal programs $100,000 $100,000 $0 Bechtel Capital project program management Infrastructure (Bechtel) services 6,444,000 7,442,800 998,800 Best, Best & Krieger LLP General legal services (BB&K) 2,325,000 2,258,100 (66,900) Case Systems, Call box maintenance Inc. (Case) 250,000 250,000 0 Epic Land Support services for property Solutions, management of Commission-owned Inc. (Epic) properties and related contracts 440,000 684,000 244,000 Field man Rolapp & Financial advisory services Associates (Fieldman) 180,000 650,000 470,000 Fulbright & Jaworski LLP Disclosure counsel services (Fulbright) 60,000 165,000 105,000 GCAP Disadvantaged Business Enterprise Services, Inc. (DBE) support services 20,000 75,000 55,000 Geographies Graphic design and web services for Multimodal Services Department 750,000 1,229,500 479,500 Orrick, Herrington & Bond Counsel Services Sutcliffe LLP (Orrick) 190,000 550,000 360,000 Trapeze Regional rideshare software 60,000 45,000 (15,000) McGiadrey & Pullen, LLP Annual audit services (McGiadrey) 136,000 144,200 8,200 Total $10,955,000 $13,593,600 $2,638,600 Budget Budget 5-Year FY 11/12 FY 12/13 Contract Freeway Service Patrol and Bernard J. Arroyo Call Box system consultant (Bernard Arroyo)l services $ 25,000 ·$25,000 $125,000 Paladin Investigative Services (Paladin)1 Call box recovery service 7,000 7,000 35,000 Total $32,000 $32,000 $160,000 .. 1 These are contracts wtth consultants provtdtng spectaltzed servtces on long-term projects at a f1xed price. These contracts do not need to be negotiated annually as service level and pricing is not expected to change during the period of performance. Staff desires to enter into a five-year agreement with each of these consultants for the aggregate amount shown in the Budget FY 2012/13 area above. Agenda Item 9 56 • •• • AMMA • In February 2007, AMMA was selected under a compet1t1ve procurement process to provide consulting services for the development and implementation of the Coordinated Public Transit-Human Services Transportation Plan (Coordinated Plan), as well as the nexus of the Coordinated Plan to the receipt of federal Jobs Access Reverse Commute and New Freedom grant funds. AMMA also guides staff regarding the grant application process for the Federal Transit Administration Section 5310 Elderly and Disabled Specialized Transit program. Additionally, AMMA advises staff regarding the management of operator reporting for the current Specialized Transit Universal Call for Projects and ass.ists in the development of the application and eligibility guidelines for the Specialized Transit Universal Call for Projects pertaining to the next two-year funding cycle. • • Bechtel The Bechtel contract for FY 2012/13 reflects a 15 percent increase over last year, due to increases in staffing. Several of the Commission's projects, including the State Route 91 Corridor Improvement Project (SR-91 CIP), Perris Valley Line (PVL), and widening projects on the Interstate 21 5 are entering the more labor-intensive design-build or construction phases, necessitating an increase in staffing to support this work. Bechtel is continuing program management and construction management activities of highway and rail projects for the 2009 Measure A program, as well as the wrap-up of delivery for the remaining projects for the 1989 Measure A program. Bechtel possesses the knowledge and background history of the Commission's capital projects, which is necessary to deliver the Commission's Measure A projects. The flexibility of obtaining additional support from Bechtel as needed for specific project requirements is also important and avoids the need to increase Commission staff. BB&K The BB&K contract for FY 2012/13 reflects a decrease of 3% in legal costs. A high level of general legal services is generally required for capital project activities, including right of way, and Transportation Uniform Mitigation Fee (TUMF) regional arterial projects. The decrease is primarily attributable to the wrap-up and delivery of 1989 Measure A highway and commuter rail projects. In recent years, the Commission has engaged other legal firms for specific matters. involving potential conflicts of interest as well as specialized legal services. Case Case (formerly Comarco Wireless Technologies) provides for routine corrective and preventive maintenance of call boxes, including knockdowns and vandalism. Case was selected as a result of a competitive procurement in 2001, in which it was the only responsive bidder. In addition, Case provided these services since the inception of the call box program. A competitive procurement is anticipated in FY 2012/13. Agenda Item 9 57 Epic was selected through a compet1t1ve procurement process for property management services, including reviewing the ownership of all Commission-owned properties; identifying, inventorying, and cataloging leases, licenses, easements, and encroachments on Commission-owned property; evaluating fair market value of the uses of Commission-owned property; establishing and maintaining a database to capture all of the Commission's property and contract information; marketing and selling excess land; and resolving complex title issues. Due to its accumulated knowledge and development of various property management projects, resources, and databases associated with the multitude of Commission-owned properties, including but not limited to those along the San Jacinto Branch Line (SJBL), staff ·determined that Epic can most efficiently and cost effectively provide the services . described above. The contract amount is anticipated to increase by $244,000, as some of the support activities that Epic is performing are related to the PVL project, which has critical timeframes in FY 2012/13. Specific examples of PVL support act1v1t1es include providing utility information for utility relocation efforts, researching street crossing rights, street vacations, and perfecting and correcting title issues such as Burlington Northern Santa Fe Railway easement to fee conversions and land rights swaps with Caltrans. In addition to an expedited schedule for PVL activities, the number of leases, licenses, easements, and encroachments on the SJBL has been found to be 1,030 instead of the 600 originally anticipated. The work on the SJBL tenant contracts will be expedited in order to more quickly reduce Commission liability and increase licensing revenues . In FY 2012/13, Epic will continue to evaluate excess Commission properties for sales opportunities. Field man Fieldman was selected as the Commission's financial advisor in late 2003, following a procurement process, and has provided financial advisory services on general finance matters and specific financing transactions related to the 2009 Measure A program. Fieldman is significantly involved in the toll financing activities related to the SR-91 CIP that are expected to occur in FY 2012/13; these activities include the issuance of sales tax revenue and toll revenue bonds and the federal Transportation Infrastructure Finance and Innovation Act (TIFIA) loan. Based on current financing activities in progress, as well as Fieldman's knowledge and understanding of the Commission, staff determined it would be more efficient and cost-effective for. continuity purposes to retain Fieldman. Staff intends to solicit new proposals for financial advisory services following the conclusion of the SR-91 CIP financing transactions. Fulbright In July 2009, the Commission awarded a professional services agreement to Fulbright for disclosure counsel services in connection with the Commission's 2009 • • bond issuance. The · agreement has been periodically amended for the • Commission's subsequent debt transactions. Staff has been satisfied with Agenda Item 9 58 " " " Fulbright's high level of service and recommends that Fulbright's agreement be amended to include disclosure counsel services related to the issuance of sales tax revenue bonds and toll revenue bonds in connection with the SR-91 CIP financial close. GCAP GCAP provides DBE program consulting and compliance services, including goal calculations, program development, and outreach to small and disadvantaged businesses. Since October 2011, GCAP has been assisting the Commission in the DBE calculation of contract goals and the development of its Small Business Enterprise (SBE) program to meet state and federal requirements. GCAP's level of effort is expected to increase in FY 2012/13 due to essential outreach services for the PVL project, the Commission's triennial DBE goal calculation, and the continued development and implementation of the Commission's SBE program. Geographies Upon the completion of a competitive procurement process in December 2006, Geographies was� awarded a professional services agreement to support the Commission with the provision of graphic design and communications services, including but not limited to advertising design and production, website development, collateral and publication design, and media buys. These services are especially critical as it relates to multimodal services programs (commuter assistance, motorist assistance, rail, and transit) that account for a majority of the Commission's outreach. In addition, three mission critical projects are currently underway: " Transition of many aspects of the Commuter Assistance Program to an interactive, web-based environment hosted through the Inland Empire 511 (IE511) website; " Increasing deployment of IE511 as the Commission's public face for multimodal services; and � " Deployment of brand new region wide average vehicle ridership (AVR) calculation and commuter survey software for which Geographies provides programming and technical support. As architect of the IE511 system, a technologically advanced and complex web environment, Geographies is uniquely able to advance the Commission's goals for this program. Additionally, as the Commission's consultant for the transition of the AVR and survey process from end of life software and hardware to a cloud-based environment with a cost-effective future, Geographies' advice is critical to the program's success. Based on these required services, Geographies' contract for FY 2012/13 reflects an increase of $479,500. Since the Commission manages both the Riverside County and San Bernardino County Commuter Assistance and Agenda Item 9 59 IE511 programs, San Bernardino Associated Governments will reimburse approximately 50 percent of the total Geographies contract cost for the related services that are provided to or otherwise benefit the San Bernardino County programs. Orrick Orrick was selected as bond counsel in late 2004, following a compet1t1ve procurement process and has provided bond counsel services in connection with the financings and other matters related to the 2009 Measure A program, including the SR-91 CIP. Orrick has a high level understanding of the Commission's 2009 Measure A program and related financings and has significant experience with other transportation agencies, especially self-help counties. Accordingly, staff determined that it would be more efficient and cost-effective to continue to retain Orrick in order to complete the SR-91 CIP financing activities. Staff intends to solicit proposals for bond counsel services following the completion of the SR-91 CIP financing activities. Trapeze An agreement for a ridematching software program for the Inland Empire was awarded to Trapeze in 2002 following a competitive procurement process. Subsequently, the software/license agreement was expanded to include Orange, Los Angeles, and Ventura Counties functionality. The software has been • customized over the past years in response to the unique regional air quality • requirements. As a result of a recent procurement for a new regional rideshare software, this contract has been included in the recurring contracts for software maintenance services for a six-month period to facilitate a seamless transition due to the existing system's customization for the regional partnership. McGiadrey In March 2008 following a procurement process, McGiadrey was awarded a professional services agreement to perform the Commission's annual audits for a five-year period concludes with the completion of the FY 2011/12 audit in November 2012. Due to the significant increase in finance activities in FY 2012/13 as a result of involvement in the SR-91 CIP design-build procurement and financing efforts, management determined that conducting a procurement for audit services during that period would create a significant strain on available resources. Additionally, the. Commission's current debt indentures require the Commission to obtain a report and opinion of a nationally recognized public accounting firm, such as McGiadrey. Based on McGiadrey's knowledge and understanding of the Commission's operations and programs, it will be important to retain the firm as a result of these significant transactions. Agenda Item 9 60 • " " " Specialized Services on long-Term Projects for Multiple Year Contracts Bernard Arroyo The Commission has maintained an agreement with Bernard Arroyo since 2005, for various services relating to the motorist assistance programs. The contractor provides support for the Freeway Service Patrol (FSP) electronic data collection system, including device-level user support; SQL database management; receiving, processing, and tracking assist data; providing the assist data in monthly and quarterly operational reports; running data analyses on FSP beat efficiency; and running data analyses on call box productivity and effectiveness among other services. Bernard Arroyo has historical and relevant experience working on Commission projects. Staff recommends that the current contract be extended for � a five-year period for a total not to exceed amount of $125,000, which reflects no change in the annual cost. Accordingly, the FY 2012/13 budget is $25,000 with $100,000 for similar services in the subsequent four-year period. Paladin An important component of administering the call box program in Riverside County is the ability to recover costs for loss and damage, when possible. The Commission has maintained a~ professional services agreement with Paladin since 2009. Paladin renders cost recovery services resulting from damages caused by motorists and others to the Commission's call box system. There is no cost to engage in a contract with Paladin other than to pay 33 percent of any costs recovered. Staff recommends that the current contract be extended for a five-year period for a total not to exceed amount of $35,000, which reflects no change in the annual cost. Accordingly, the FY 2012/13 budget is $7,000 with $28,000 for similar services in the subsequent four-year period. I Financial Information I In Fiscal Year Budget: I Yes IYear: I FY 2012/13 Amount: I $13,625,600 Measure A, TDA, TUMF, FSP, SAFE Source of Funds: Fees, Interest, and Other Budget Adjustment: N/A Reimbursements GLA No.: I Various Fiscal Procedures Approved: I ~~ J Date: I 05/14/12 Agenda Item 9 61 " " " " AGENDA ITEM 1 0 " " " " " " " " RIVERSIDE COUNTY TRANSPORTATION COMMISSION DATE: May 21, 2012 TO: Budget and Implementation Committee FROM: Marla Modell, Procurement Administrator Matt Wallace, Procurement Manager THROUGH: Theresia Trevino, Chief Financial Officer SUBJECT: Agreement with PlanetBids for Online Vendor and Bid Management System STAFF RECOMMENDATION: This item is for the Committee to: 1) 2) 3) Approve Agreement No. 12-19-091-00 with PlanetBids, Inc. (PianetBids) for the use of the PlanetBids BidsOnline vendor and bid management system software for a three-year term, and two one-year options to extend the agreement, in an amount not to exceed $65,000; Authorize the Chair, pursuant to legal counsel review, to execute the agreement on behalf of the Commission; and Forward to the Commission for final action. BACKGROUND INFORMATION: Vendor and bid management system software, most often a web-based e-procurement application, became more prevalent in the late-1990s. These web-based applications streamline the complete bidding process and further enable the collection, analysis, and leverage of all aspects of vendor data, purchasing activities, and corresponding history. The Commission currently does not have a vendor and bid management system. DISCUSSION: Procurement staff currently relies on the Commission's website, project managers, and local print advertisement when soliciting requests for proposal (RFP), requests for qualifications (RFQ), and invitations for bids (IFB). As part of the Commission's efforts to administer and manage an efficient procurements process and conduct outreach to small businesses and disadvantaged business enterprises (DBE) for future Commission projects and programs, an off-the-shelf vendor and bid management system is anticipated to be a cost-effective solution . Agenda Item 10 62 Staff researched available e-procurement solutions during the past few months by investigating what local cities and other transportation agencies are currently utilizing.. Staff evaluated multiple software options and took part in demonstrations with BIDSYNC, eBid Systems, and PlanetBids. Staff also considered a bid and quote module available through EDEN, the Commission's financial management system. After evaluating the three demonstrations and comparing the EDEN module's available features against the minimum requirements available through the other three options, staff determined that PlanetBids provides a superior vendor and bid management system that meets the Commission's needs at a r.easonable cost. Established in 1998 PlanetBids is a privately held company based in Woodland Hills, California. PlanetBids developed its product to help customers better connect with its current and potential vendors and conduct competitive purchases of goods and services efficiently and cost effectively. It provides a modular suite of leading web-based e-procurement solutions to state and local government agencies, educational institutions and private corporations. The following governmental agencies in Southern California currently use PlanetBids: • • • California State University Office of the Chancellor and campuses at Channel Islands, Northridge, and San Marcos; Cities of Anaheim, Burbank, Chula Vista, El Cajon, Fontana, Garden Grove, Irvine, Lake Elsinore, La Mesa, Long Beach, Ontario, Pasadena, Rancho Cucamonga, San Bernardino, Santa Monica, and Temecula; Coachella Valley Water District; • Metropolitan Water District of Southern California; • Orange County Fire Authority; • Orange Unified School District; • San Diego Association of Governments; • San Diego Metropolitan Transit System; • San Diego Regional Airport Authority; • San Diego Unified Port District; • Santa Monica College; • Southern California Association of Governments; and • Southern California Regional Rail Authority. The expected efficiency gains from PlanetBids BidsOnline include: • Vendor registration and profile management; • Greater outreach to vendors; • Bid document distribution, including automatic addendum notification and acknowledgments; • Custom email notifications; • • • Online question and answer management; Secure e-bidding, including line itemization, calculation with net terms, etc.; Robust reporting, analysis, charts, and audit trails; Agenda Item 1 0 63 • • • " " " " Sealed bids/lock box; " Bid specification library; and " RFP/RFO/IFB evaluation tools. Based on the information provided, staff recommends that the Commission approve Agreement No. 12-19-091-00 with PlanetBids for a three-year term, and two one- year options to extend the agreement, in the amount of $56,263, plus extra work to be identified through future task orders in the amount of $8,737, for a total amount not to exceed $65,000. Upon approval of the agreement with PlanetBids, estimated implementation is scheduled for the beginning of FY 2012/13. Financial Information In Fiscal Year Budget: I Yes I I FY 2012/13 Amount: I $15,875 N/A Year: FY 2013!14 + $49,125 s f F d I Measure A, TDA, TUMF, FSP, SAFE Budget Adjustment: I No ource o un s: N/A Fees, and Interest GLA No.: 1001001 65520 00000 0001 101 19 65520 Fiscal Procedures Approved: I ~~ I Date: I 05/10/12 Attachments: Draft Support Service Agreement Agenda Item 1 0 64 " " " " " " Lt~:a<...1irrg e-Procl..Jren�reiJt 5<....-,JtJtiorrs Cc'>r1nect.in�g Buyers & St.spf:>liers ETficierrt.Jy! & 8 5~~-;' A v e n u e o S u i t e l 0 1 " W o o dl ;-;;-;j'~~S7 " 8 1 II -9 9 2 -1 7 1 1 BIDSONLINE"! SUPPORT SERVICES AGREEMENT This SERVICE SUPPORT AGREEMENT, which describes the terms and conditions applicable to your use of the PlanetBids Online Support Services, is made. and entered as of into the 7th day of June, 2012, by and between PLANETBIDS, INC., a California corporation, ("PianetBids") . and the following customer ("Customer") for the period from July 1, 2012 to June 30, 2015 plus two additional one-year option periods: Customer Name: Riverside County Transportation Commission Street Address 4080 Lemon Street -3'ct floor City, State ZIP Riverside, CA 92.501 Department: Fini:m9.e/Procurement. Principal Contact: Title: Procurement Administrator Term of Payment: Net 30 Days THEREFORE, PlanetBids and the Customer agree as follows: 1. PlanetBids Services. Upon acceptance of this Agreement, PlanetBids shall provide the following Support Services to'Customer, subject to the terms and conditions of this Agreement a) "Services" shall include the following: 1) use of the PlanetBids "BidsOnline "!" Vendor and Bid management system for the purpose of vendor registration, posting and tracking Bid Requests and other information on Customer's website or private internet network, 2) up to two (2) licensed user access to and use of the Bid sOn line TM system by the Customer Procurement Department 3) Customer has option, to processing and distributing Bid Requests to additionally available PlanetBids suppliers within their selected categories at no additional cost. b) PlanetBids shall have access and the right to market or otherwise promote any or all of its services to any vendor or supplier of Customer that registers with BidsOnline rM via Customer's website. Planetbids will not sell vendor data to any third parties without a written consent from Customer. c) Internet related equipment by its nature, is not fault tolerant, but PlanetBids will use reasonable efforts to make the Services available 24 hours per day, 7 days per week, except for downtime for scheduled and unscheduled maintenance, and will promptly investigate any technical problems that Customer reports. PlanetBids cannot, however, guarantee continuous service, service at any particular time or the integrity of data transmitted via 65 �2000-2012 PlanetBids, Inc (818) 992-1771 Confidential & Proprietary, R 15914-12 the Internet. Further, PlanetBids shall not be responsible for the inadvertent disclosure, corruption or erasure of data transmitted, received qr sorted on the BidsOnline rM system. • d) PlanetBids may make improvements and/or amendments to the BidsOnline rM system at any time, and may provide other optional services, including enhanced versions of standard features or functions, for an additional fee as agreed in advance by the Customer. Any and all relevant portions of these terms and conditions will automatically apply to all improvements, amendments and/or optional services as they appear. PlanetBids does not guarantee that use of the Services will produce any quotes, business opportunities or other information helpful to the business of Customer, nor does it guarantee that any contact provided will be adequate or best suited for any transaction. 2. Fees and Payments. a) Support Fees. Customer agrees to pay to PlanetBids a total amount of $35,477.18 for a period of three (3) years and an optional total amount of $20,785.95 for (two) 2 additional years thereafter, as outlined per Table (A), for a total not-to-exce/7" rnount of $56,263.13, which fees shall be due and payable 30 day,s from'the time of ex btion of this Agreement or upon renewal: .. · 1) Set-Up Fee. Customer shall pay aon~:-time set-up fee of $6,500.00 (discounted from $7 ,500.00) for the ihstaHation, configt)r:c:~tion and testing of the BidsOnline ™ system link to CustQI)ler's website, plus administrator set-up and a one- time online usertraining up to two'(!?) users. further details are available in Statement of Work (Exhibil'"A"). ····· 2) Service Fee Payment. Customer agrees to pay a service fee of $5,875.00 for the period of this Agreement, for the use of the BidsOnline rM system. A three. (3) percent increase pef;y~arapplies on the Service Fee upon renewal. ·· 3) Additional Add-on/~~dule. Customer agrees to pay a special service fee of$3,500.00 for the RFP Evq~tJation add:.:bn module for the period of this Agreement. A onetime setup fee of $750.00'll:;)Vaived. A three (3) percent increase per year applies onto the Services Fee upon renewal. Table (A) SETUP YEAR1 YEAR2 YEAR3 YEAR4 YEARS _(Optional) (Optional) . $6,500.00 $ 5,875.00 $ 6,051.25 $6,232.78 $6,419.77 $ 6,612.36 $0.00 $ 3,500.00 $3,605.00 $ 3,713.15 $3,824.54 $3,929.28 ;c;. • ··· <.' · Sub -Tolar $6,500.00 $9,375.00 $9,656.25 $9,945.93 $ 10,244.31 $10,541.64 $ 15,875.00 $9,656.25 $9,945.93 $10,244.31 $10,541.64 Additional Services; Fees. If requested by Customer, PlanetBids will provide any or all of the following additional services: · 1) Special customization work -up shall be provided at Planet Bids' current standard rates pursuant to an estimate provided by PlanetBids. 2) Training to Customer's designated users, in addition to that provided pursuantto Section 2(a)(1 }, is available as of today at the rate of $500.00 for up to 3 hours online, or $1,475.00 for up to 3 hours per class plus 2 66 ©2000-2012 PlanetBids, Inc (818) 992-1771 Confidential & Proprietary, R15914-12 • • " " " 3) 4) reasonable travel, living and parking expenses of the instructor, as applicable. PlanetBids will record at no cost a back-up copy of all data appearing on Customer's website on a daily basis. Services related to the retrieval or restoration of any of Customer's data from such back-up files are available at PlanetBids current standard rates, which will vary depending on the level of services required, but not less than $125.00 per hour. A late fee of 3% per month will be charged on the total amount due if payment is not received within the terms of this agreement. 3. Use of Services. a) PlanetBids is not responsible for the content and/or transactions on Customer's website. Notwithstanding the foregoing, PlanetBids reserves the right to monitor content that uses the Services and to remove content which PlanetBids determines to be offensive, harmful or otherwise in violation of its operating policies and terminate this Agreement. 1) PlanetBids shall have the right to impose reasonable wles and regulations from time to time regarding the use of the Services. Customer agrees to comply with all such rules a~d .. regulations and Vl(ith applicable laws, ordin.<.mces and regulations related to the us~?of 8~rvices and not make any unauthorized' commercial use of the Services or of the P.lanetl?ids name, marks or logos. Further, Customer agrees to not use the PlanetBids websites.to (1) post information anonymously or under a false name; (2) post any unlawf\JJ,threatening, abusiv~. hara�ssing, libelous, defamatory, obscene; pqrnographic, profane orotl;lerwise.objectionable information of any kind, such ~$)ndt1cert;Jents to cohduct,that wol:tld constitute a criminal offense or give rise to ch11for other lf~bility . 2) lf;Customer;;uses standard identification codes, PlanetBids shall have the right t():Jeq~@St for ir\spectidnan original copy of such codes and any necessary al!lhof:izatio~~�for use.~~tf such identification codes are proprietary codes of third parties, .~uY::h as NIGP:�st~� or CSI, it,shall be the responsibility of Customer to obtain the HEicessary licens~s and Customer indemn'ifies and holds harmless PlanetBids from the unaul�borized use or ~ublication'bf any such identification codes with respect to the Servi~$~ 3) Customer represents and warrants (a) the information provided is current, complete and accurate,{b) that the person signing this Agreement is authorized to bind Customer, (c) Customer will update the information (including credit card information, if applicable) as required to keep such information current, complete and accurate. PlanetBids may, in its sole discretion, cancel or terminate this Agreement if Customer has willfully violated its obligations hereunder. 4) In addition, Customer agrees to use information obtained through the Services only as necessary to the transaction of Customer and shall not use the Services for the benefit of any third party. 5) Upon request, provide PlanetBids with a record of all transactions and payments related to Bid Requests made through the use of the Services . 3 67 �2000-2012 PlanetBids, Inc (818) 992-1771 Confidential & Proprietary, R15914-12 6) It shall be the responsibility of Customer to collect and pay any taxes, duties, imposts or tariffs that are applicable to sales via the Services. b) THE SERVICES ARE PROVIDED "AS IS." PLANETBIDS MAKES NO WARRANTIES, EXPRESS OR IMPLIED, INCLUDING WITHOUT LIMITATION, IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NONINFRINGEMENT OF INTELLECTUAL PROPERTY OR OTHER VIOLATION OF RIGHTS, EVEN IF PLANETBIDS HAS BEEN MADE AWARE IN ADVANCE OF SUCH POTENTIAL RISK. FURTHER, PLANETBIDS DOES NOT WARRANT OR MAKE ANY REPRESENTATIONS REGARD!NG THE ACCURACY, LIKELY RESULTS, OR RELIABILITY OF THE USE OF THE SERVICES OR SITES LINKED THERETO. c) PlanetBids does not at any time come into possession of the products or services acquired through the Services and is not aware of the specific use to which those items will be put. In using the Services, Customer hereby releases, indemnifies. and holds harmless PlanetBids and its agents, employees, and affiliates harmless from all claims, demands, costs and damages (actual and consequential) of every kind and nature arising out of, or in any way connected with, Bid Requests and uncompleted .or completed transactions related to the Services. 4. Confidentiality. PlanetBids wHUake reasonable measures not to disclose website communications or information about its Custqmers, except to the extent that PlanetBids believes in good faith that such action is withil'llhe scope of the Services or reasonably necessary to (a) comply with the law or'the directives of courts or governmental agencies; (b) enforce this Agreement; {c)J~~pond to claims of any third:party; or (d) protect the legitimate interests of PlarretBids oiits'cu$tomers. NotWithstanding the foregoing, all communications • directed to PlanetBids via the website such as questions, comments, inquiries, shall be deemed • to be not confidential, unless specifically agreed ·otherwise in advance by PlanetBids. Further, PlanetBids will have the right to use any Customer's name in connection with the advertising or promotion ofth~ ,Services. · , .. · "" . ''C: 5. Copyright P~~t~&tion. The BidsOnlinen.-1 sy~tem and all materials appearing on the PlanetBictswebsite are pfotected by worldwide copyright laws and related international treaties. None of the materials may be copied, reproduced, modified, published, uploaded, posted, transmitted, or distributed in any form or by any means other than as described herein. All rights not expressly granted herein are reserved. Any unauthorized use of the materials appearing on PlanetBids website may violate copyright, trademark and other applicable laws and could result in criminal or civil penalties. " "} a) Customer shall not reproduce, duplicate, copy, sell, resell or exploit for any commercial purpose the Services, website content, the Bid sOn line TM system or any other PlanetBids tools. Customer shall not reverse engineer, decompile, or otherwise attempt to derive source code from any software or tools accessible or available through the Services. b) Special use requests should be sent to customerservice@PianetBids.com. Permission to use shall be granted in the sole discretion of PlanetBids. 6. Security. . (a) The PlanetBids ordering and posting processes are protected by the Secure Sockets Layer (SSL) protocol, which encrypts your information and confirms the identity of the PlanetBids server before allowing a transaction to be completed. Firefox 3.5+ (or better) and 4 68 ©2000-2012 PlanetBids, Inc (818) 992-1771 Confidential & Proprietary, R 15914-12 • " " " Internet Explorer 8.0+ (or better) support the SSL protocol are acceptable, but we recommend that you use the latest browsers to ensure that you are protected by advances in security technology. For more detailed information, please refer to the PlanetBids Privacy Policy. (b) Password-protection techniques will be provided to restrict access under Customer's account to authorized individuals. REGISTRANT ACKNOWLEDGES, HOWEVER, THAT ACCESS RESTRICTIONS, BY THEIR NATURE, ARE CAPABLE OF BYPASS AND PLANETBIDS DOES NOT GUARANTEE THAT THE SERVICES CANNOT BE ACCESSEDBY UNAUTHORIZED PERSONS. Customer shall at all times maintain as confidential its user names and passwords. If Customer is a corporation or other business entity, then it may allow employees to use its user name and password, but the Customer shall be responsible for all activity and charges incurred by such employees. Permittiog"thifd parties to use the Services is prohibited and a violation of this Agreement. � "� � (c) If a security breach occurs with respect to any account, the Customer must immediately change its password and notify PlanetBids at customerservice@PianetBids.com. Customer shall be liable. for any unauthorized use of the Services until� PlanetBids is notified of the security breach. ..� �� 7. Other Provisions. a) Notices. PlanetBids s~~ltlm>vide notice to6:stomer via email, or (at its � discretion) via certified U.S. Mail, to theictddre:ss provided on fb~ membership registration or such other address provided by Customer to Planet~tgs. Custf>J;tter shall provide notice to PlanetBids via email to customerservice@PianetBidS}~om,withacopy sent via certified U.S. Mail to the address on theVmemo,~rship regis~ration:"'NBtice's;will be effective 6 hours after sending if sent via email (unless tHe sender receives' a respori$19 indicating that the message was undelivered) or 3 business days after the 'n]ailing date, whether or not received. 'c>' b) Assignment ... Customershall not assjgn this Agreement or any of its rights or obligations without th.~ prior written consentoJPianefBids, and any such attempted assignment will be void. Subject totbe above�, this Agreerhentwill be binding upon the parties' respective successors and permitted assigns. �� c) No Waiver. Thefailure of PlanetBids to exercise or enforce any right or provision under thisAgreementwill not constitute a waiver of such right or provision. If any provision of this Agreement is found by a court of competent jurisdiction to be invalid, the parties nevertheless agree that the court should endeavor to give effect to the parties' intentions as reflected in the provision, �and the other provisions of the these terms and conditions shall remain in full force and effect d) Governing Law. The interpretation and enforcement of this Agreement shall be governed by laws of the United States of America and the State of California, excluding its choice of law rules and subject to the exclusive jurisdiction of the court located in Los Angeles, California. e) Force Majeure. PlanetBids will not be liable in any amount for failure to perform any obligation under this Agreement if such failure is caused by Internet outages or delays, unauthorized access (hacking), earthquakes, communications outages, fire, flood, war, an act of God, or the occurrence of any other unforeseen contingency beyond the reasonable control of Planet Bids . 5 69 �2000-2012 PlanetBids, Inc (818) 992-1771 Confidential & Proprietary, R 15914-12 AGREED effective as of the date first written above. PLANETBIDS, INC. CUSTOMER: By: __ =----:-~-------::---- Aian Zavian, President & CEO ___________ (Date) 6 70 By: __________ _ John J. Benoit Chair ---=--------(Date) ©2000-2012 PlanetBids, Inc (818) 992-1771 Confidential & Proprietary, R 15914-12 • • • " " " EXHIBIT"A" STATEMENT OF WORK FOR SETUP, IMPLEMENTATION AND TRAINING 1. BidsOnline"! Vendor and Bid Management Access Services: PlanetBids rate for maintaining the BidsOnline vendor and bid management system is based upon an unlimited number of monthly transactions (Bids) and up to two (2) registered users. BidsOnline Access Services include the following: " System Administration -PlanetBids will be responsible for system and data back-ups, disaster recovery, system reliability, availability, privacy, and security " Hosting Infrastructure-PlanetBids will be responsible for hosting BidsOnline, maintaining the network, hardware and software infrastructure " Customer Service-"Level2" customer service is available from 8:00a.m. to 5:00p.m. PST, Monday through Friday (see Help Desk definition below) " Account Management -PlanetBids will provide a dedicated Account Manager for post- sales support, BidsOnline system questions. ..... � . " System requirement -Adobe Flash Player 11.0+ is;required and available for free at www.adobe.com . � 2. BidsOnline Set~up, hj'Jplementation and Training~ " PlanetBids will initially load up to two (2)users, for Customer " PlanetBids will provide online training for BidsOnlirie user administration BidsOnl!pe;set-up, implementation and training is further defined below: A. ,Anitial program definition The PlanetBids implementation manager will work with one (1) designated Customer project manager to develop a roadmap for system implementation. The implementation manager will define and present a project management schedule to the Customer project manager. Customer will be required to submit information according with the project management schedule. Upon completion an,d review of the BidsOnline system by Customer, PlanetBids will train all assigned users on-site at the Customer's training facility. B. System implementation and administration PlanetBids will enter and configure Customer requirements into BidsOnline for up to two (2) users for Customer. � The following implementation services will be provided: a. Setup PlanetBids portal and provide links for Customer to activate from its website . b. Online configured vendor registration form and ability to have vendors maintain their profiles. c. Complete management tools access to all users (i.e. buyers, project managers ... ). d. Customer specific database. e. Complete bid management from bid submission to awarding . 7 71 �2000-2012 PlanetBids, Inc (818) 992-1771 Confidential & Proprietary, R15914-12 f. Electronic bidding -Vendors submit bid quotes/responses online; Buyers analyze bid responses and award. • g. Daily backups. h. BidsOnline rM users and vendor support for the duration of the contract. 3. Professional Services PlanetBids will provide consulting services for custom reports or BidsOnline customizations, specific to Customer, not covered by this Statement of Work at an additional charge. Additional consulting services requested in writing by Customer will be billed at a rate of $125/hour, billed in 1 hour increments. No work will begin on professional services before a mutually agreed- upon statement of work is completed. All on-site travel expenses will be passed-through to Customer. No travel will be expensed without the prior approval of Customer's management. 4. Help Desk The PlanetBids Help Desk is available for "Level 2'''support (a~defined below} via our toll-free telephone number from 8:00am to 5:00pm PST, Monday throllgh Friday. Email Support, support@PianetBids.com as well as on-line help services are also available. Customer will be responsible for all "Level 1" support: • A level1 support rep(esentativewill attempt to. answer mo~t or all questions, including help to vendo.r.s with ~lmple problems (edit profile, etc.} or general "how-to" questions (search functionality, bidding, etc.). More complex, technical questions should be directed to a PlanetBids level2 support representative. A PlanetBidsrepresentative will be responsible for "Level 2" support: • ;~Level 2 supportis more technical in nature. Level 2 questions may, for example, deal With Customer users (i.e. BidsQnline system administrative users including buyers, project administrators, etc.) or with password issues requiring special assistance, or with possible product bugs or failures. In this case, some research and investigation may be required. 5. Additional Module(s): The same terms and conditions outlined in this Exhibit A shall also apply to the RFP Evaluation Add-on module. · 8 72 ©2000-2012 PlanetBids, Inc (818) 992-1771 Confidential & Proprietary, R 15914-12 • • " AGENDA ITEM 1�1 " " " " " REVISED AGENDA ITEM 11 RIVERSIDE COUNTY TRANSPORTATION COMMISSION DATE: May 21,2012 TO: Budget and Implementation Committee FROM: Jillian Edmiston, Staff Analyst Brian Cunanan, Commuter Assistance Manager THROUGH: Robert Yates, Multimodal Services Director SUBJECT: Fiscal Year 201 2/1 3 SB 821 Bicycle and Pedestrian Facilities Program Funding Recommendations STAFF RECOMMENDATION: This item is for the Committee to: 1) Approve the Fiscal Year (FY) 2012/13 SB 821 Bicycle and Pedestrian Facilities Program recommended funding of $1 ,379,433; and 2) Forward to the Commission for final action. BACKGROUND INFORMATION: Each year, 2% of the Local Transportation Fund (l TF) revenue is made available for use on bicycle and pedestrian facility projects through the Commission's SB 821 Program. This is a discretionary program administered by the Commission. There are three steps to carry out the program: 1 . All cities and the County are notified of the SB 821 program estimate of available funding and are requested to submit project proposals. The Commission's SB 821 program policies, project application, and selection criteria are also provided with the notification. 2. The Commission's SB 821 Evaluation Committee, comprised of members of the Commission's Technical and Citizens Advisory Committees (3 each), meets to review and rank the project applications using the evaluation criteria adopted by the Commission. The applicants are invited to give a presentation of their proposals and to answer questions from the committee members. The evaluation committee recommends projects and funding amounts to the Commission for approval. 3. The Commission reviews the Committee's . recommendations and approves a program of bicycle and pedestrian projects for funding. Upon receiving a funding allocation, agencies then have twenty-four months to complete the projects. DISCUSSION: In March 2012, staff notified the cities and the county that an estimated $1,160,010 would be available for programming in FY 2012/13 through the SB 821 Bicycle and Pedestrian Facilities program, which is included in the FY 2012/13 Commission budget. Proposals were due on May 8. The Commission received 30 project proposals, totaling $3,366,724 in SB 821 funding requests as attached. A diverse evaluation committee comprised of two members from the Commission's Citizens Advisory Committee (CAC) and three members from the Technical Advisory Committee reviewed the proposals on May 1 5. Based upon the Commission's adopted scoring criteria, which is attached, the proposals were evaluated and ranked by members of the evaluation committee. Fourteen projects totaling $1 ,379,433 are recommended for funding as indicated in the attachment. The difference between the estimated funding available and the amount recommended for funding this year is due to the availability of an additional $219,423 achieved through cost savings on previously claimed projects. These cost savings have enabled the Commission to fund 14 projects instead of 12. Moving forward, additional project cost savings and returned allocations will be used to supplement the funding available for the FY 2013/14 call for projects. Staff concurs with the evaluation committee's recommendation. Financial Information In Fiscal Year Budget: I Yes I Year: I FY 2012/13 Amount: I $1,379,433 Source of Funds: ILTF Budget Adjustment: I No GL/Project Accounting No.: 601 62 86106 Fiscal Procedures Approved: ~~ I Date: I 05/17/12 Attachments: 1) SB 821 FY 2012/13 Recommended Funding 2) SB 821 Evaluation Criteria Agenda Item 11 Rank Agency 1 Eastvale 2 Perris 3 Riverside 4 Hemet 5 San Jacinto 6 Riverside 7 Wildomar 8 Indio 9 Beaumont 10 Lake Elsinore 11 Riverside County 12 Moreno Valley 13 Riverside County 14 Banning 16 Riverside County 16 Lake Elsinore 17 Banning 18 Desert Hot Springs 19 Coachella 21 Lake Elsinore 21 Riverside 22 Lake Elsinore 23 San Jacinto 24 Perris 25 Palm Springs 26 Coachella RIVERSIDE COUNTY TRANSPORTATION COMMISSION SB 821 BICYCLE AND PEDESTRIAN FACILITIES PROGRAM FY 2012/13 RECOMMENDED FUNDING Total SB 821 Funds Recommended Project Description Costs Requested Allocation Orange Street Sidewalk Safety Improvements $160,300 $80,150 $80,150 Nuevo Road Pedestrian Bridge and Sidewalk 220,000 110,000 110,000 University at 1-215 Bike Lane Project 108,000 70,000 70,000 2013 Missing Links Project 119,580 59t790 59,790 San Jacinto Avenue/Ramona Expressway S/W 80,000 40,000 40,000 Canyon Crest Separated Bikeway Project 40,000 20,000 20,000 Almond Street Sidewalk Route Improvements 243,700 158,400 158,400 Monroe Street Sidwalk and Bike Lanes 168,000 84,000 84,000 Cherry Avenue Sidewalk and Ped Bridge 301,685 150,843 150,843 Heald Avenue 87,500 43,750 43,750 Grant Street 254,000 154,000 154,000 Citywide Sidewalks and Access Ramps 150,000 150,000 150,000 Avenida Florencita 285,000 153,500 153,500 San Gorgonio Avenue from Wilson to Roosevelt 140,000 105,000 105,000 King Avenue 249,000 136,500 0 Mill Street 88,316 44,158 0 Roberge Avenue from Ramsey to Nicolet 100,000 75,000 0 Mesquite and Desert View Bicycle & Sidewalk 99,996 99,996 0 ADA Rehab Project 467,525 383,526 0 Campus Way 60,704 30,352 0 Wheelchair Ramp Construction 250,000 125,000 0 Sumner Avenue 45,780 22,890 0 Chase Street/Ramona Expressway Sidewalk 100,000 50,000 0 Downtown PedestrianS/Wand Access Ramps 200,000 100,000 0 Baristo Road Bike Lane Project 157,500 94,500 0 Bike Lanes Project 523,658 393,658 0 ATTACHMENT 1 Cummulative Average Funds Allocated Score $80,150 89.0 190,150 88.1 260,150 83.7 319,940 83.4 359,940 82.2 379,940 82.0 538,340 81.6 622,340 80.6 773,183 79.2 816,933 78.0 970,933 77.2 1,120,933 76.8 1,274,433 75.6 1,379,433 75.4 0 74.8 0 74.8 0 74.6 0 74.2 0 73.6 0 73.4 0 73.4 0 72.6 0 70.6 0 68.8 0 68.2 0 66.8 Rank Agency 27 Rancho Mirage 28 Corona 29 Murrieta 30 Coachella Totals JLE: 5/17/2012 RIVERSIDE COUNTY TRANSPORTATION COMMISSION SB 821 BICYCLE AND PEDESTRIAN FACILITIES PROGRAM FY 2012/13 RECOMMENDED FUNDING Total SB 821 Funds Recommended Project Description Costs Reguested Allocation Highway 111 Sidewalk Construction Various 116,734 99,224 0 Magnolia and E. Sixth Street Sidewalks 65,450 49,088 0 Citywide Bicycle Loop Installations 99,800 79,840 0 Sidewalks Project 271,559 203,559 0 55.253.787 53.366.724 ATTACHMENT 1 Cummulative Average Funds Allocated Score 0 64.0 0 61.4 0 60.1 0 58.6 51.379.433 RIVERSIDE COUNTY TRANSPORTATION COMMISSION SB 821 EVALUATION CRITERIA FACTOR 1. USE The extent of potential use of a bicycle or pedestrian facility is the most important factor. Emphasis of this factor helps ensure the greatest benefits will be derived from the expenditure of SB 821 funds. Relative usage is to be derived from analysis of trip generators and attractors adjacent to the project. 2. SAFETY Points are awarded on the basis of a project's potential to correct current safety problems. 3. IMPORTANCE AS A TRANSPORTATION ALTERNATIVE Points are awarded on the basis of a project's potential to attract users who would otherwise use an automobile. 4. MISSING LINK, EXTENSION, OR CONNECTIVITY Points are awarded to projects that link, are extensions of, or potentially connect to existing facilities. 5. MATCHING FUNDS This factor is used to help ensure that there is local funding participation in the project -not just an application for "free" money. One point would be awarded for each 5% of total project cost that is financed by the local agency. 6. POPULATION EQUITY The purpose of this factor is to help ensure that one agency does not receive all the funds. The applicant receives the maximum 10 points if the amount of funds requested does not exceed what the applicant would receive if the funds were allocated by population. Year to year totals are recorded so that an applicant could build up a "credit". (Calculated by RCTC) 7. PHYSICAL ACCESSIBILITY ENHANCEMENT The purpose of this factor is to enhance the physical accessibility of existing pedestrian projects. Applicant agencies may receive up to 10 "bonus" points for their project proposals which improve the physical access to existing facilities. RCTC: 04/12/1995 MAXIMUM POINTS 25 20 20 15 10 10 10 BONUS " " " RIVERSIDE COUNTY TRANSPORTATION COMMISSION DATE: May 21, 2012 TO: Budget and Implementation Committee Jillian Edmiston, Staff Analyst FROM: Brian Cunanan, Commuter and Motorist Assistance Manager THROUGH: Robert Yates, Multimodal Services Director SUBJECT: Fiscal Year 2012/13 SB 821 Bicycle and Pedestrian Facilities Program Funding Recommendations STAFF RECOMMENDATION: This item is for the Committee to: 1) Approve the FY 2012/13 SB 821 Bicycle and Pedestrian Facilities Program (SB 821 program) recommended funding; and 2) Forward to the Commission for final action. BACKGROUND INFORMATION: Each year, 2 percent of the Local Transportation Fund (L TF) revenue is made available for use on bicycle and pedestrian facility projects through the Commission's SB 821 program. This is a discretionary program administered by the Commission. There are three steps to carry out the program: 1) All cities and the county are notified of the SB 821 program estimate of available funding and are requested to submit � project proposals. The Commission's SB 821 program policies, project application, and selection criteria are also provided with the notification. 2) The Commission's SB 821 evaluation committee, comprised of three members from the Commission's Technical and Citizens Advisory Committees, meets to review and rank the project applications using the evaluation criteria adopted by the Commission. The applicants are invited to give a presentation of their proposals and to answer questions from the committee members. The evaluation committee recommends projects and funding amounts to the Commission for approval. 3) The Commission reviews the Committee's recommendations and approves a program of bicycle and pedestrian projects for funding . Agenda Item 11 73 Upon receiving a funding allocation, agencies then have 24 months to complete the • projects. DISCUSSION: In March 2012, staff notified the cities and the county that an estimated $1,160,010 would be available for programming in FY 2012/13 through the SB 821 program, which is included in the FY 2012/13 Commission budget. Proposals were due on May 8. The Commission received 30 project proposals, totaling $3,366,724 in SB 821 program funding requests as attached. A diverse evaluation committee comprised of three members from the Commission's Citizens Advisory Committee and three members from the Technical Advisory Committee reviewed the proposals on May 15. Based upon the Commission's adopted scoring criteria, the proposals were evaluated and ranked by members of the evaluation committee. Typically, the call for projects schedule is built around taking the funding recommendation to the May Committee, then June Commission. However, the rescheduling of the May Committee meeting to May 21 did not leave enough time for the evaluation committee's recommendations to be included in this report. An updated report reflecting the evaluation committee's recommendations will be • provided at the Committee presentation. Financial Information In Fiscal Year Budget: I Yes I Year: I FY 2012/13 Amount: I TBD Source of Funds: ILTF Budget Adjustment: I No GL!Project Accounting No.: 6016286106 Fiscal Procedures Approved: ~~ .I Date: I 05/10/12 Attachment: SB 821 Evaluation Criteria • Agenda Item 11 74 " " " " RIVERSIDE COUNTY TRANSPORTATION COMMISSION SB 821 EVALUATION CRITERIA FACTOR 1. USE The extent of potential use of a bicycle or pedestrian facility is the most important factor. Emphasis of this factor helps ensure the greatest benefits will be derived from the expenditure of SB 821 funds. Relative usage is to be derived from analysis of trip generators and attractors adjacent to the project. 2. SAFETY Points are awarded on the basis of a project's potential to correct current safety problems. 3. IMPORTANCE AS A TRANSPORTATION ALTERNATIVE 4 . 5. 6. Points are awarded on the basis of a project's potential to attract users who would otherwise use an automobile. MISSING LINK, EXTENSION, OR CONNECTIVITY Points are awarded to projects that link, are extensions of, or potentially connect to existing facilities. MATCHING FUNDS This factor is used to help ensure that there is local funding �participation in the project -not just an application for "free" money. One point would be awarded for each 5% of total project cost that is financed by the local agency. POPULATION EQUITY The purpose of this factor is to help ensure that one agency does not receive all the funds. The applicant receives the maximum 1 0 points if the amount of funds requested does not exceed what the applicant would receive if the funds were allocated by population. Year to year totals are recorded so that an applicant could build up a "credit". (Calculated by RCTC) 7. PHYSICAL ACCESSIBILITY ENHANCEMENT The purpose of this factor is to enhance the physical accessibility of existing pedestrian projects. Applicant agencies may receive up to 1 0 "bonus" points for their project proposals which improve the physical access to existing facilities . RCTC: 04/12/1995 75 MAXIMUM POINTS 25 20 20 15 10 10 10 BONUS " " "