The URL can be used to link to this page

Home My WebLink AboutFY 2012 Annual Investment ReportAnnual Investment Report Fiscal Year Ending September 30, 2012 201 N. Ector Drive Euless, TX 76039 www.eulesstx.gov INVESTMENT COMMITTEE MEETING 01/17/13 *Annual Review, FY 12 Introduction Investment Strategy Compliance I. Portfolio Summary II. Performance Summary III. Interest Income Summary IV. Collateral Review V. Broker Selection Process VI. Summary *Appendices Appendix A - Changes in Portfolio Values by Asset Appendix B - Investment Portfolio by Type of Asset Appendix C - Investment Portfolio by Fund Appendix D - Investment Purchases Appendix E - Investment Maturities Appendix F - Investment Maturities by Fund at September 30, 2012. *Economic News *Investment Policy *General Discussion and Questions INTRODUCTION This report is written and submitted in accordance with Chapter 2256 of the Texas Government Code - entitled the "Public Funds Investment Act," which states that "at least once each year, the investment officer of a state agency or political subdivision shall prepare a written report concerning the agency's or subdivision's local funds investment transactions for the preceding year and describing in detail the investment position of the agency or subdivision as of the date of the report. The City's investment policy designates the Investment Officers as the responsible managers for the City's investment program. The daily investment procedures are monitored by the City's Finance department and reviewed by the investment officers. This report has been signed by each investment officer as required by the Public Funds Investment Act and the City's investment policy. In compliance with the City's investment policy, the Finance department fulfills four main objectives: compliance, safety, liquidity, and yield, in that order. Compliance is maintained through regular reporting - to City management on a monthly, quarterly and annual basis. Safety is insured by 1) investing only in securities allowed by Chapter 2256 of the Texas Government Code entitled the "Public Funds Investment Act"; 2) using delivery vs. payment for all purchases; 3) protecting all non-government securities (cash - and bank certificates of deposit) with collateral in the form of government securities which are pledged to the City of Euless and safekept by the Federal Reserve Bank; and 4) diversifying investment purchases into different security markets to minimize individual market risk. Liquidity is met by matching investment terms to future operating cash needs such as payroll, accounts payable, debt service, and capital improvement disbursements. The City also utilizes money market funds and local government investment pools to provide daily liquidity needs. The yield or rate of return which the City receives is measured against the 90 -day treasury bill yield as set by the investment policy. The information contained in this report will quantitatively and graphically demonstrate the achievement of these City objectives for Fiscal Year 2011-12. Investment Strategy Compliance The strategy for all pooled funds is to assure that cash flows are matched with projected needs and assume adequate liquidity and safety. This may be accomplished by purchasing high quality securities in a laddered structure or utilizing an investment pool (See Appendix E). Furthermore the following purposes are also considered when investing. T -Operating Funds will be structured in such a way as to minimize volatility during economic cycles. This may be accomplished by purchasing high quality short-term securities. The weighted average maturity on these funds will remain within the 6 to 9 month range. These funds include' 101 General Fund 201 Hotel -Motel Tax Fund 202 Juvenile Case Fund 210 1/2 Cent Sales Tax -Operations 220 Crime Control & Prevention District 230 Police Drug - DEA Awards 231 Police Drug - State Awards 240 Car Rental Tax Fund 245 Glade Parks PID 250 Glade Parks TIRZ 501 Water & Wastewater Fund 510 Drainage Utility 520 Recreation Classes Fund 521 Arbor Daze Fund 530 Softball World -Operations 540 Golf Course Operations 550 Athletic Complex Operations 601 Equipment Replacement Fund 610 Health Insurance Fund 615 Risk Management Fund -Funds for Capital Improvement Projects(CIP) and Special Purposes may purchase securities which allow for flexibility and unanticipated project outlays by having a portion of their investments in highly liquid securities (See Appendix E)_ The stated final maturity dates of securities held should not exceed the estimated project completion date. These funds include: 301 Developers Escrow Fund 305 Streets CIP 310 1/2 Cent Sales Tax-CIP 320 General Capital Projects Fund 321 Redevelopment CIP Fund 325 Police Facility Construction Fund 330 Car Rental CIP 502 Water & Wastewater-CIP 505 Water Impact Fees Fund 508 Wastewater Impact Fees Fund 511 Drainage ClP 552 Athletic Complex CIP-Phase II 720 Glade Parks Escrow -Debt Service Funds should assure adequate liquidity to cover the debt service obligation on the required payment date. These funds include: 401 Debt ServicelGeneral Obligation 402 Star Center Debt Service 403 Glade Parks Debt Service 410 1/2 Cent Sales Tax -Debt. Service 506 Water/Wastewater Debt Service 531 Softball World Debt Service 541 Golf Course Debt Service -Emergency, Contingency, Operating and Debt Service Reserve funds will have the ability to generate a dependable revenue stream to the appropriate fund from securities with a low degree of volatility. Such securities will tend to hold their value during economic cycles. The stated final maturity dates of securities held should not exceed five years (see Appendix E). These funds include: 102 General Fund -Emergency 103 General Fund -Contingency 211 1/2 Cent Sales Tax -Bond Reserve 240 Car Rental Tax Fund (2,000,000 Reserve) 503 Water & Wastewater Bond Reserve 507 Water & Wastewater -Emergency Fund 509 Rate Stabilization Reserve 532 TSSC Reserve 542 TSGC Reserve 705 Star Center Bond Reserve Based on the above strategies, the investment portfolio reported herein is in compliance with the city's adopted investment policy. (\cAL,cu-,<) Vicki Rodriquez Director of Finance Jackie Theriot Assistant Director of Finance I. PORTFOLIO SUMMARY The City's investment portfolio at the end of the fiscal year, September 30, 2012, is summarized by instrument as shown below. Distribution by Instrument Weighted % of Average Avg. Yield Instrument $ Cost Portfolio Yield Prior Qtr Agencies 32,938,736 51.51% 0.18% 0.23% Investment Pools 31,005,850 48.49% 0.07% 0.06% 61944L586 190 00% The Distribution by Instrument table shows that the majority of City funds, approximately 52% are invested in government agencies, while the remaining 48% is invested in local government investment pools. As of the date of this report, the weighted average yield on the portfolio was .25%. When compared to prior quarter levels, the yield on the portfolio has remained relatively stable. The portfolio composition below demonstrates the diversity within the portfolio. Portfolio Composition as of September 30, 2012 FHLMC 10% FAMCA FNMA 2% FHLB 28% 596 FFCB 7% Texpool 25% Texstar 23°I0 I. PORTFOLIO SUMMARY (CONTINUED) The City's investment portfolio at the end of the fiscal year, September 30, 2012, is summarized by maturity as shown below. # of months Overnight up to 6 mos 6 to 9 mos 9to12mos 12 to 18 mos 18 to 24 mos > 24 mos Distribution by Maturity $ Cost $31,561,900 $ 1,001,655 $ 7,999,375 $ 10,026,646 $12,455,010 $ 900,000 $63944,586 % of Portfolio 49.4% 1.6% 12.5% 15.7% 19.5% 0.0% 1.4% 100.0010 The Distribution by Maturity table reflects the degree of liquidity in the City's portfolio. Currently, access to 49% of the portfolio is available within 24 hours, with an additional 2% available within 6 months. This liquidity strategy was followed to meet cash flow requirements for construction projects, payroll, debt service, and other operating expenses. An additional 28% of the portfolio matures within one year. Currently, the city has 20% of the portfolio invested between 12-18 months, with an additional 1% beyond 24 months to take advantage of yields in this area of the curve. The weighted average maturity on the portfolio is currently 185.71 days. > 24 mos 18 to 24 mos 12 to 18 mos 9 to 12 mos 6 to 9 mos up to 6 mos Overnight Investment Maturity Distribution as of September 30, 2012 $0.0 $5.0 1111 $10.0 $15.0 $20.0 $25.0 $30.0 I. PORTFOLIO SUMMARY (CONTINUED) The City's investment portfolio at the end of the fiscal year, September 30, 2012, is summarized by institution as shown below. Institution Cantor Fitzgerald Coastal Securities Duncan Williams First Southwest Mutual Securities Samco Capital Vining Sparks Texpool TexStar B of TX Logic Distribution by Institution $ Cost % of Portfolio 4,500,100 7.0% 5,999,125 9,4% 2,181,000 3.4% 6,999,466 10.9%© 4,997,950 7.8% 4,559,515 7.1% 2,801,580 4.4% 16, 312, 680 25.5% 14,677,059 23.0% 916,041 1.4% 70 0.0% $ 63.944,586 100.0% The City strives to not only diversify the portfolio by the type of instruments that are -No more than 10% in repurchase agreements - No more than 33% in investment pools with any single institution _ -No more than 33% in money market mutual funds - No more than 33% by individual brokerage firms The chart below demonstrates the City's compliance with the above guidelines. Logic BofTX Texstar Texpool Vining Samco Mutual FSW Duncan Coastal Cantor Investments by Institution as of September 30, 2012 Logic, $0.0 B of TX, $0.9 Texstar, $14.7 Vining, $2.8 Samco, $4.6 Mutual, $5.0 FSW, $7,0 Duncan, $2.2 Coastal, $6.0 Cantor, $4.5 Texpool, $16,3 $0.0 $4.0 $8.0 $12.0 $16.0 $20.0 • City of Euless Pooled Portfolio Summary for Quarter Ending September 30, 2012 Cost Book Market Princioai only Value Value Investments at June 30, 2012 $64,543,409.27 $64,532,277.43 $64,554,254.76 investment PurchaseslDividends 15,2944,080.91 Investment Maturities (15,892,903.98) Investments at September 30, 2012 $63,944,586.20 $63,925,363.90 $63,954,544.24 Vicki Rodriquez Director of Finance Jackie Theriot Assistant Director of Finance Summary of Investments by Fund The following is a summary of cash and investments held by each fund at June 30, 2012 and September 30, 2012. The changes include all investment purchases, maturities, revenues, expenses, and transfers that occurred during the fourth quarter of FY2012. 101 General Fund 102 General Fund Emergency 103 General Fund Contingency - 201 Hotel -Motel Tax Fund 202 Juvenile Case Fund 210 1/2 Cent Operations Fund 211 1/2 Cent Debt Reserve 220 CCPD 230 Police Drug DEA Awards 231 Police Drug State Awards - 240 Car Rental Tax Fund 245 Glade Parks PID 250 Glade Parks TIRZ #3 260 Cable PEG Fund - 301 Developer's Escrow Fund 305 Streets CIP 310 1/2 Cent Sales Tax CIP 320 General CIP Fund - 321 Redevelopment CIP Fund 325 Police Facility CIP 330 Car Rental CIP Fund 401 Debt Service/General - 402 Star Center Debt Service 501 Water & Wastewater Fund 502 Water & Wastewater-CIP - 503 Water & Wastewater Bond Res€ 504 Service Center Fund 505 Water Impact Fees 506 Water & Wastewater -Debt Servi 507 Water & Wastewater -Emergency 508 Wastewater Impact Fees 509 VV/WW Rate Stabilization 510 Drainage Utility - 511 Drainage CIP 512 Drainage Reserve 520 Recreation Classes Fund 521 Arbor Daze Fund - 530 Softball World Operations 531 TSSC Debt 532 TSSC Debt Reserve 540 TSGC Operations 541 TSGC Debt 542 TSGC Debt Reserve 550 Parks © Texas Star - 552 Parks © Texas Star CIP 601 Equipment Replacement 610 Health Insurance Fund 615 Risk Management Fund - 705 Star Center Escrow 720 Glade Park Phase II Escrow TOTAL Cash & Investment at Market Value 6/30/2012 Cash & Investment at Market Value 9/30/2012 9,892,351.58 8,485,382.00 500,585.00 500.205.00 500,120.00 500,705.00 105,372.99 115,471.76 104, 343.32 109, 767.84 1,175,516.78 1,316,716.56 920,483.08 918,631.69 166,993.85 222,720.46 13,341.38 24,764.76 157, 273.95 139,7 58.12 9,736,148.89 8,553,959.44 250.000.00 159,825.16 0.00 126, 203.12 1,428,874.85 1,428,741.87 2,605,778.17 1, 958, 398.56 1, 587, 894.44 1,411, 376.28 1,876,005.54 1,848,054.57 280, 454.21 280, 547.66 108,588.41 108,624.88 1,019,388.06 4,994,405.89 1,011,144.27 656,407.67 563,407.03 151,881.75 5,548,564.30 6,907,599.03 2,702,351.74 2,289;148.48 304,670.92 304.774.21 (137,067.70) 8,986.06 1,970,474.62 1,879,891.51 14,264.43 4,821.04 500,000.00 500,000.00 573,697.43 521,645.24 2,127,039.06 2,059,695.02 411,195.19 434,701.12 1,003,187.43 1, 003, 521.29 0.00 484, 561.99 410,154.62 33,656.42 33,343.49 (110,579.59) (149,339.71) (27, 774.32) 2,364.68 718,330.89 747,077.82 (38,043.73) 108,383.63 24,855.86 41,464.25 1,790,079.23 1,571,692.19 209,450.46 234,961.12 751,906.24 752,150.93 2,651,942.43 2,829,295.50 4,013,741.77 3,290,983.99 1,173,625.96 1, 657, 043.73 1,420,990.06 1,421,048.08 1,287,090.01 513,369.60 63,406,276 90 8 Increase/ Decrease In Fund (1,406,969.58) Operating expenses (380.00) 585.00 10,098.77 5,424.52 141,199.78 Operating Revenues (1,851.39) 55,726.61 Operating Revenues 11, 423.38 (17.515.83) (1,182,189.45) Transfer to CIP (90,174.84) Transfer to Debt 126,203.12 (132.98) (647,379.61) (176,518.16) (27, 950.97) 93.45 36.47 3.975,017.83 (354,736.60) (411,525.28) 1,359,034.73 (413,203.26) 103.29 146,053.76 (90,583.11) (9,443.39) Cable Franchise PEG Fees Capital outlay Capital outlay Capital outlay Transfer from Car Rental Debt service payments Debt service payments Operating revenue Capital outlay Transfer from W/ WW operations TRA water payment (52,052.19) TRA wastewater payment (67,344.04) Transfer to W/WW operations 23,505.93 Operating revenue 333.86 (74,407.37) Operating expenses (312.93) (38,760.12) Operating expenses 30,139.00 Transfer from operating 28,746.93 Gas royalty payments 146,427.36 Transfer from reserve 16,608.39 (218,387.04) Transfer to operations 25,510.66 Operating revenue 244.69 177,353.07 Transfer from other funds (722,757.78) Insurance claims 483,417.77 Transfer from other funds 58.02 (773,720.41) Capital outlay 63,391,326.96 (14,949.94) II. PERFORMANCE SUMMARY Cash and Investments Balances -Full utilization of funds and minimization of idle cash is necessary to pursue additional interest income revenues for the City. The average percent of invested funds is 100% for FY12. The monthly data below shows the continued utilization of City funds through investments. October -10 November -10 December -10 January -11 February -11 ® March -11 April -11 May -11 June -11 July -11 August -11 September -11 Average October -11 November -11 December -11 January -12 February -12 March -12 April -12 May -12 June -12 July -12 August -12 September -12 Average This graph shows 100%. Consolidated Cash $720,692 1,037,140 1,009,135 299,305 356,827 259,585 640441 56,902 349,918 64,761 149,064 237,871 431,803 Consolidated Cash $265,985 694,788 629 083 338,039 (509,448) 338,093 1,092, 608 524,952 79,152 909,414 (540,941) (12,726) 317,417 Invested Percentage Balance Invested $53,271,146 99% 54,542,964 98% 57, 082, 861 98% 61, 544,220 100% 65,779,236 100% 56,637,776 100% 56, 393,124 99% 59, 358, 323 100% 60,022,093 100% 59,200,277 100% 59,400,946 100% 58,261,993 100% 58,457,913 100% Invested Percentage Balance Invested $59,418,980 100% 60,880,529 99% 67,925,028 99% 71, 715, 207 100% 72, 727,026 101% 62,841,299 100% 62, 815, 926 98% 64, 044, 594 99% 64, 557, 278 100% 63,948,675 99% 64,415,816 101% 63.958,495 100% 64,937,404 100% how a greater portion of the City's funds continue to be invested, always in pursuit of Percent invested 105.00% 100.00% 95.00% 90.00% 85.00% 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 Fiscal Year 9 Cash management performance - effectiveness of the cash management program has been measured utilizing actual figures for FY12 as shown below: Average City's Number Estimated 90 day Invested Days in Interest Month TBilI Yield Balance Month Earnings - October -11 0.02% $59,418,980 31 $1,009 November -11 0.01% $60,880,529 30 $500 December -11 0.01% $67,925,028 31 $577 -; January -12 0.03% $71,715,207 31 $1,827 February -12 0.09% $72,727,026 28 $5,021 March -12 0.09% $62,841,299 31 $4,803 - April -12 0.10% $62,815,926 30 $5,163 May -12 0.07% $64,044,594 31 $3,808 June -12 0.09% $64,557,278 30 $4,775 - July -12 0.1 1 % $63,948,675 31 $5,974 August -12 0.09% $64,415,816 31 $4,924 September -12 0.10% $63,958,495 30 $5,257 --- Average 0.07% $64,937,404 33,637 Estimated earnings at benchmark yields: 143,640 Actual FY12 interest income (un -audited) $193,366 - Earnings over benchmark: $149,727 Key rate comparisons - an objective of the investment policy is for the City's average rate of return to consistently exceed that of the three month U.S. Treasury Bill, as stated before. Therefore, they have been presented for comparative purposes below. Benchmark 90 -day City's Avg. Month T-bill yield Portfolio Yld Difference October -11 0.02% 0.52% 0.50% November -11 0.01% 0.50% 0.49% _ December -11 0.01% 0.48% 0.47% January -12 0.03% 0.44% 0.41% February -12 0.09% 0.42% 0.33% _ March -12 0.09% 0.39% 0.30% April -12 0.10% 0.39% 0.29% May -12 0.07% 0.38% 0.31% June -12 0.09% 0.28% 0.19% July -12 0.11% 0.36% 0.25%© August -12 0.09% 0.35% 0.26% _ September -12 0.10% 0.35% 0.25% Average 0.07% 0.41% 0.34%© During FY12, the Federal Reserve left rates unchanged. The Federal Open Market Committee had kept the target fed funds rate between 0.00% and 0.25% throughout the year and currently anticipates economic conditions are likely to warrant exceptionally low levels for the fed funds rate at least through mid -2015. The average yield on the city's portfolio has dropped slightly from month-to-month throughout the year. However, the city's - portfolio continues to surpass the benchmark 90 -day T-bill rate by an average of 34 basis points for the year. 10 III. INTEREST INCOME SUMMARY FYO8 Audit FY09 Audit FY10 Audit FY11 Audit FY12 Un -audited FY12 Budgeted $2,453,928 $1,117,296 $380,555 $235,087 $193,366 $230,253 $3,000,000 $2,500,000 $2,000,000 w $1,500,000 0, $1,000,000 $500,000 $0 Interest Income Summary FY08 Audit FY09 Audit FY10 Audit FY11 Audit FY12 Un -audited Interest income did not meet the budgeted level for fiscal year 2012. When compared to prior year, interest earnings have decreased. This decrease can be attributed to the reinvestment of proceeds from maturing securities into lower yield investments. 11 Interest Income By Fund For Fiscal Year Ending September 2012 # Fund FY 11 FY 11 Actual FY 12 FY 12 Actual Diff FY11 Budget Audited Budget (Unaudited) Bud. -Act. 101 General $125,000 $47,407 $80,000 $47,169 ($32,831) 201 Hotel/Motel 500 136 150 118 ($32) 202 Juvenile Case Fund 0 76 0 87 $87 210 Half Cent Sales Tax -Operations 1,000 2,780 1,500 1,089 i$411) 211 Half Cent Sales Tax -Reserve 500 7,241 500 6,298 $5,798 220 Crime Control Prevention District_.; 500 153 350 148 ($202) 230 Euless DEA Fund 3,000 50 500 24 ($476) 231 Police DEA State Awards 1,000 218 500 166 ($334) 240 Car Rental 60,000 42,047 35,000 28,376 ($6,624) 245 Glade Parks PID 0 0 0 61 - $61 250 Glade Parks TIRZ 0 0 0 0 $0 260 Cable PEG Fund 0 0 0 0 $0 301 Developer's Escrow 2,500 4,196 1,000 1,784 $784 305 Streets CIP 14,297 16,649 4,203 9,147 $4,944 310 Half Cent Sales Tax- CIP 2,500 7,670 2,500 3,600 $1,100 320 G.O. CIP 15,000 12,455 6,000 6,427 $427 321 Redevelopment CIP Fund 3,829 376 500 319 ($181) 325 Police Facility CIP 293 136 0 119 $119 330 Car Rental CIP 2,500 264 350 1,165 $815 401 GO Debt Service 2,500 1,290 1,500 699 k$801) )$151) ($32,913) 402 Star Centre Debt 1,000 434 550 399 501 Water and Wastewater 60,000 30,686 60,000 27,087 502 Water and Wastewater CIP 7,500 11,276 5,600 8,289 $2,689 503 Water and Wastewater Reserve 0 590 0 442 $442 504 Service Center Fund 0 0 0 0 $0 505 Water Impact Fees 1,500 8,763 5,000 6,802 $1,802 508 Wastewater Impact Fees 1,000 828 1,000 653 _$347) 509 WANW Rate Stabilization 0 3,267 0 7,686 $7,686 510 Drainage 1,500 331 500 391 ($1091 511 Drainage CIP 6,500 4,627 2,100 1,300 ($800) 520 Recreation Classes 1,000 461 500 447 ($53) 521 Arbor Daze 0 16 0 24 $24 530 Softball World 1,000 0 0 0 $0 531 Softball World Debt 0 0 0 0 $0 532 TSSC Reserve 0 457 0 721 $721 540 Golf Course 0 65 0 1 $1 541 Golf Course Debt 0 117 0 44 $44 542 Golf Course Reserve 5,000 3,623 5,000 5,867 $867 550 Parks At Texas Star 500 237 250 192 ($58) 552 Athletic Complex - CIP 5,000 816 1,000 813 ($187) 601 Equipment Replacement 2,500 9,715 3,000 12,827 $9,827 610 Health Insurance 20,000 14,543 10,000 11,373 $1,373 615 Risk MgmtlWorker's Comp 17,000 1,091 1,200 1,212 $12 Total $365,919 $235,087 $230,253 $193,366 ($36,887) Note that interest earnings are being earned on all investable City funds and great efforts are pursued to meet budgeted levels. This report points out that the un -audited interest earnings for the end of the fiscal year did not meet budgeted expectations due to unprecedented market lows. Several Funds were budgeted conservatively or not at all due to the volatility of revenues and expenditures. However, these funds are used for investment purposes when available. These funds include Capital Improvement Projects, DEA Funds, Grant Funds, and Debt Service Funds_ IV. COLLATERAL REVIEW The first and most important objective of investing public funds is safety. One way to insure the City's assets is to have them fully secured with "collateral." Acceptable collateral is defined in the City's investment policy, but generally consists of types of securities in which the City would invest. Bank balances are monitored daily to assure full coverage. The amount of collateral required by the depository bank varies with the expected level of deposits (typically correlates with large receipts such as property taxes, franchise taxes and investment maturities). City of Euless Collateral Analysis for Cash & C.D. Investments as of 09130112 Pledging Safekeeping Pledged Sec. Security Market Value Inv. Value Difference Institution Location Description Par Value (w/FDIC Ins.7 Mat'y (P & I) Over/(Under) Frost Bank Federal Reserve $1,741,600 $1,905,868 $722,832 $1,183,036 Bank FHLMC Payroll $20,298 4/1/2018 $1,741,600 Operating $381,638 Insurance $320,896 Produced By: Director of Finance Reviewed by: Assistant Director of Finance r\ -011,c24?,,, �L+,abvL1/tva4at This review is practiced on a regular basis assuring coverage_ Another regular practice is reviewing each individual instrument purchased. This assures compliance with the investment policy and consideration of the underlying security. This separate but thorough practice has protected the City's portfolio against derivative products. 13 V. BROKER SELECTION PROCESS This section of the report is to provide a brief explanation of the process undertaken to select brokers with which the City invests. The broker/dealer list is reviewed annually, _ and additions/deletions are made as necessary. The city currently maintains a list of seven broker/dealers. The process is outlined below: 1. Brokers express an interest in doing business with the City's investment portfolio. 2. A questionnaire is sent to the broker which requests the necessary information for management to review including references, capital adequacy ratios, etc. 3. The Finance Department reviews all received questionnaires, summarizes the — information and recommends the desired list of brokers with explanatory notes in conjunction with the first quarter investment report. 4. The list is presented to the investment committee annually for their approval. 5. All brokers are notified after the selection is complete. VI. SUMMARY The primary objectives of compliance, safety, liquidity and yield have been achieved for the reporting period as evidenced by this report. These objectives will continue to be pursued for the City of Euless as provided by the investment policy. This year proved to be another successful year for the investment program. The City of Euless, like all other local governments, is faced with the challenge of meeting benchmark levels triggered by the Fed's actions and meeting additional reporting requirements as stated by new legislation. Therefore, the City's investment program will continue to seek new techniques, instruments, etc. to enhance the return on the City's funds, as well as the return of all City funds. The investment committee will meet on January 17, 2013 to discuss the Annual Investment Report. Once the annual report is approved by the committee, it will be _ forwarded to the City Council Vicki Rodriquez Jackie Theriot Director of Finance Assistant Director of Finance CERTIFICATION This report has been examined and approved by the Investment Officers of the City of Euless. Information presented in this report to the Investment Committee and City Council represents — an accurate description of the City's investment activity for the fiscal year ending September 30, 2012. This report meets all requirements specified by the Public Funds Investment Act and the Policy of the City of Euless. Investment Officers Vicki Rodriquez Director of Finance 4a_0ezioliAl.nt Jackie Theriot Assistant Director of Finance Diana L Ayala Accountant 11 15 Members: Minutes - 09128112 Investment Committee Meeting Gary McKamie, City Manager Loretta Getchell, Deputy City Manager Vicki Rodriquez, Director of Finance Mary Lib Saleh, Mayor Committee members present included, Mayor Saleh, Gary McKamie. Loretta Getchell, and Vicki Rodriquez. Other attendees included Assistant City Manager, Chris Barker. Vicki Rodriquez presented the third quarter investment in accordance with Chapter 2256 of the PFIA. The committee reviewed the report. Vicki reported that the city's investment portfolio was in compliance with the city's investment policy and had been reviewed by each investment officer. At the end of June 42% of the city's portfolio was invested in local government investment pools, providing the city with the liquidity they need to meet cash flow requirements, with the remaining 58% invested in government agencies. These securities are invested using a laddered investment structure which provides additional cash flow on a monthly basis. Vicki also reported that approximately 48% of the portfolio was available within one month, with an additional 4% available within 6 months and an additional 12% available within one year. The city also maintained 25% of the portfolio between 12 and 18 months. The remainder of the portfolio was invested out to a maximum maturity of 24 months, with the exception of the EDC bond reserve which is invested out to March 2016 at the direction of the investment committee. This strategy provides the city with the liquidity needed to meet cash flow requirements for operating expenses, and allows for re- investment opportunities should the market shift. The weighted average maturity at the end of June was 231.66 days and the weighted average yield was.29%. Vicki also reported that the city not only diversifies by the type of investment and maturity date, but also by institution. At the end of June, the city's portfolio was well within the stated guidelines, with no more than 33% invested in any one institution. At the end of the third quarter, the investment portfolio -- had increased approximately $1.7 million dollars, and held a market value of $64,554,255 which exceeded the book value of $64,532,277 for an unrealized market gain of $21,978. Vicki also presented a review of the projected interests earnings for the fiscal year. Based on the expected rate of return and the reinvested balances for the remainder of the fiscal year, interest earnings were projected to fall short of budget by approximately $22,000. Interest earnings were budgeted at a 1% rate of return, as reported the actual weighted rate of return was a 0.29% at the end of the third quarter. The minutes from the June 14, 2012 meeting were presented for approval. Loretta Getchell motioned to approve the minutes. Mayor Saleh seconded. The minutes were approved. Mayor Saleh motioned to approve the third quarter investment report as presented. Loretta Getchell seconded. The motion passed. Gary McKamie motioned to adjourned the committee meeting. Loretta Getchell seconded. Meeting was adjourned. 16 APPENDIX ! j City of Euless Change in Portfolio Values by Asset and Investment Fund For the Quarter Ending September 30, 2012 1 Inv, Type CUSIP Number Maturity/ Call [late Par Value Markel Value 09/30/2012 Market Value 06/30/2012 Change in Market Value Bonk Value 09/30/200 Book Value 06/30/2012 Change in Rook Value [OPERATING FUNDS: FHLB 3133XXLX3 10/26/2012 550,000 550,457 552,041 (1,584) 550,000 550,908 (908) FNMA 3135G0GF4-2 12/06/2013 500,000 500,195 500,875 (680) 500,000 500,000 IFHLB 313370'12 06/19/2013 1,000,000 1,001,070 1,001,080 (10) 1,000,000 1,000,000 - FHLB 313376MG7 06/28/2013 1,000,000 1,000,350 1,000,080 270 999,500 999,500 - FFCB 31331K3X6 06/20/2013 500,000 500,005 500,020 (15) 499,875 499,875 - I- FHLB 313376EB7 05/23/2013 1,000,000 1,000,280 1,000,540 (260) 1,000,000 1,000,000 - FNMA 31398A2M3 09/30/2013 1,000,000 1,009,110 1,009,920 (810) 1,007,733 1,009,842 (2,109) FFCB 3133EAAP3 01/27/2014 1,000,000 1,000,010 1,000,050 (40) 999,750 999,750 - FFCB 3133EAAY4 07/26/2013 1,000,000 1,000,000 1,000,020 (20) 999,500 999,500 FHLB 313376582 07/30/2013 1,000,000 1,000,390 999,747 643 1,000,100 1,000,100 - - FHLB 313376UY9 08/05/2013 1,000,000 1,000,420 999,397 1,023 1,000,000 1,000,000 FFCB 3133EABV9 02/03/2014 1,000,000 1,000,010 1,000,050 (40) 999,500 999,500 - FNMA 31398A3A8 09/03/2013 1,000,000 1,006,620 1,008,560 (1,940) 1,007,248 1,009,225 (1,977) - FFCB 3133EABX5 11/01/2013 1,000,000 1,000,010 1,000,030 (20) 999,750 999,750 - FHLMC 313463MH0 02/21/2014 1,000,000 1,001,080 1,001,160 (80) 1,000,000 1,000,000 - FHLB 3133781.187 02/28/2014 500,000 500,455 500,150 305 500,000 500,000 - FHLB 313378E1)9 09/09/2013 1,000,000 1,001,000 999,904 1,096 1,000,000 1,000,000 - FHLMC 3134G3LA6 02/27/2014 775,000 776,434 774,922 1,512 775,000 775,000 - FFILB 313378W49 04/12/2013 1,000,000 1,000,300 999,820 480 1,000,000 1,000,000 - FHLB 313378X30 04/16/2013 500,000 500,170 499,942 228 500,000 500,000 FHLB 313378U25 10/18/2013 1,000,000 1,001,680 1,000,550 1,130 1,000,000 1,000,000 FHLB 3133797L7 07/15/2013 1,000,000 1.000,320 999,402 918 999,900 999,900 FHLB 313379A66 05/03/2013 1,000,000 1,000,120 999,576 544 1,000,000 1,000,000 - FHLB 313379GH6 06/21/2013 1,000,000 1,000,140 999,625 515 1,000,000 1,000,000 - - FHLB 313379Y78 06/28/2013 1,000,000 1,000,300 999,492 808 1,000,000 1,000,000 - Purchases FHLB 313379ZH5 07/05/2013 1,000,000 1,000,380 - 1,000,380 1,000,000 - 1,000,000 _ FHL11 313376WS0 08/15/2013 1,000,000 1,000,700 - 1,000,700 1,000,566 1,000,566 Maturities FFCB 31331J7A5 07/10/2012 1,000,000 - 1,000,090 (1,000,090) - 1,000,000 (1,000,000) - FFCB 31331 KANO 07(25/2012 1,000,000 - 1,000,260 (1,000,260) - 1,000,000 (1,000,000) TVAS 88059EMF8 07/15/2012 915,000 - 914,735 (914,735) - 905,973 (905,973) FHLB 313374Z37 07/25/2012 500,000 - 500,020 (500,020) - 499,979 (499,979) - FHLB 313375AA5 08/08/2012 1,000,000 - 1,000,050 (1,000,050) - 1,000,510 (1,000,510) Paz total docs not Total Operating: include maturities $ 24,325,000 $ 24,352,005 $ 26,762,107 $ (2,410,102) $ 24,338,422 $ 26,749,311 $ (2,410,888) 1 City of Euless Change in Portfolio Values by Asset and Investment Fund For the Quarter Ending September 30, 2012 1 Inv. 'Type CUSIP Number Maturit/ Call Date Par Value Market Value 09/30/2012 Market Value 06/30/2012 Change in Market Value Book Value 09/30!2012 Book Value 06/30/2012 Change in Book Value IP FUNDS FHLMC 3134G1LD4 12/27/2012 500,000 501,120 502,125 (I,005) 500,230 500,575 (345) FHLMC 3134G1 WT7 11/26/2012 500,000 500,270 500,605 (335) 499,954 499,816 138 1 FHLMC FHLMC 3134G33R2 3134G3NS5 01/09/2014 03/21/2014 1,000,000 1,000,000 1,002,760 1,001,350 1,001,320 998,456 1,440 2,894 1,001,131 998,776 1,001,358 1,001,440 (226) (2,664) FFCB 31331K4D9 12/27/2013 181,000 181,107 181,293 (186) 181,000 181,000 - 'FAMCA 31315PXW4 12/06/2013 1,000,000 1.000,320 1,000,000 320 1,000,000 1,000,000 Purchases FHLB 313380LS4 08/28/2013 1,000,000 1,000,270 - 1,000,270 1,000,000 - 1,000,000 •1'laturities FHLMC 3134G2SL7 08/08/2013 1,000,000 - 1,000,390 (1,000,390) - 1,000,000 (1,000,000) Pad total does not Total CIF inc6ide maturities $ 5,181,000 $ 5,187,197 $ 5,184,189 $ 3,008 $ 5,181,091 $ 5,184,188 $ (3,097: 1 2ESERVE FUNDS: FNMA 313560GF4 12/06/2013 500,000 500,195 500,875 (680) 500,000 500,000 - ' FHLMC 31340260 I 11/2912013 500.000 500,205 500,585 (380) 500,000 500,000 FHLMC 313403RK8 03/14/2016 900,000 907,497 907,551 (54) 900,000 900,000 - - FHLB 313378YX3 10/15/2013 500,000 500,705 500,120 585 500,000 500.000 - F11LB 313379FK0 11/15/2013 1,000.000 1,000,890 999,414 1,476 1,000,000 1,000,000 'urchases None 'Maturities FHLMC 3134G2VN9 08/22/2013 1,000,000 - 1,000,210 (1,000,210) - 1,000,000 (1,000,000) FNMA 3135GOCQ4 09/06/2013 925,000 925,426 (925,426) 925,000 (925,000) Par total does not Total Reserve: tncludc rnaturmes S 3,400,000 $ 3,409,492 $ 1,334,181 $ 947 5 3,400,000 $ 5,325,000 $ - -.)VERN1GHT INVESTMENTS: Beginning Bal Ending Bal -expool Balance 14,319,329 16,312,680 16,312,680 14,319,329 1,993,351 16,312,680 14,319,329 1,993,351 - Purchases 6,683,794_ - Maturities 4,690,443_ .. 'exstar Balance 12,942,838 14,677,059 14,677,059 12,942,838 1,734,221 14,677,059 12,942,838 1,734,221 -- Purchases 5,605,221 - - Maturities 3,871,000 - ' AGIC Balance 71 71 71 71 0 7 i 71 `.i Purchases 0 - - - Maturities - - - B of Balance 11,541 16,041 16,041 11,541 4,500 16,041 11,541 4,500 Purchases 4,500 Maturities - - TotalOvemight: $ 31,005,850 $ 31,005,850 8 27,273,778 5 3,732,072 $ 31,005,850 $ 27,273,778 $ 3,732,072 Par total does not Total Portfolio include maturities $ 63,911,850 S 63,954,544 $ 64,554,255 5 1,325,925 5 63,925,364 5 64,532,277 5 1,318,086 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Investment Type LOGIC Local Gov't Pool Te%slar 10081 GOY) P301 Texp0ol Local Gov't Pool FGIC Money Market Fuad FNMA Fed. Nat'l ldorl. ASso0. FFCB Fed. Farm Credit Bank FHLB Fed. Horne Loan Bank Inv. CUS IP 01170.9 a Maturity ,(PS. Number Q6fe pate V.S. Government Agencies Agency Discounts FHLMC Fed. Horne Loan Mort. Cory CD Certificates of Deposit TRILL Treasury Bill City 0f Euless Investment 06/59119 September 39. 2012 Vining Vining Sparks Coastal Coastal Securities SBrr1CO Samco Capital Mutual Mulual Se0u Mies Call Term Tenn Days Price Par Pnnci pal Neal Int D�1e i0 iL21 Elams1 Accrued Ex.= Value Invested Pavmenl Institution Interest Yield To Coupon Seller Accrued Mal until 821i Inst. LOGIC Local Gov't Investment Coop. FSW First Southwest Tevslar TesSTAR Cantor Cantor Fitzgerald Tempo) TE%POOL Duncan Duncan Williams FG IC Federated Investors Trust Llnamorllzed Discount Premium Prem11015c) Book ygie Market ValOe Agency Coupon Notes FHLB 3133%311.313 02+15/11 10024112 WC 34 585 8 105,1000 550,000 00 556.050.00 714 24 169.06 0:7261. 1.375% Saint° 6,550 50 550.000 00 550456.50 FHLMC 31340115/77 34104/1 t 11126112 N/C 150 536 124 99 8250 500.00000 499.125.55 1.287 50 866.94 0.02% 0.515% Santee 675.00 149.05) 499.553 95 500,270.00 FHLMC 3134G1LD4 32/15/11 12/27012 N/C 150 585 03 100.5060 500,000.00 502,53090 2.750.00 1,420.63 053% 1.120% 5am00 2.53000 23000 500233.00 501.120.00 FHLB 313371W49 04/13/12 04/12113 WC 160 187 187 100,0000 1.000.00000 1.000:000.00 1.200.00 1.113.33 0.245, 0.240% Cantor 1.000.000.00 1.000,309.00 FHLB 3133793130 04/15712 04718013 WC 150 164 164 1009000 500000.00 500.000.00 625.00 569.44 0.25% 0.25055 Cantor 500,000.00 505,17000 FHLB 313375066 05/03712 05+03/13 NDC 360 147 147 130.0000 1.000,050.05 1,000,000.00 2,200.00 598.33 022% 0.220% Mutual 1,000000.00 1,000.120.50 FHLB 313376EB7 11)23011 05/2313 11123/12 180 307 127 100.0000 1,000,000.00 1000,00000 1,750.00 1.234.72 0.35% 0.350% Samar 1,000,000.00 1,000.280.00 FHLB 313376/3/2 12/19111 06019713 WC 100 281 101 100.0000 1.000,005.00 1,000,600.00 2.000.00 1,122.22 0.4034 04005, Duncan 1,000,200.00 1001,070.00 FFCB 3133103%6 12/30/11 06120/13 03)29/12 180 270 100 699750 500,000.00 199.675.03 700.00 386.69 0,30% 0.280% Coastal 125.00 (125.50) 499.575.00 500.03590 FHLB 3133790/18 05/21712 06121/13 11/21/12 160 129 1.29 100.3000 1,000,60000 1.000,200.00 1.25000 995:53 0 25% 0.25046 FSW 1.500900.03 1,000.140.05 FHLB 313379MG7 12/29/11 56029)13 12128112 150 271 92 99.9500 1,000,000.00 999,500.00 1,50000 76687 5.33% 0.300% FSW 500.50 (500.00) 995,500,00 1,000.350,30 FHLB 3133793/78 06/28112 05/28/13 1417 180 92 22 100.0000 1,900.300.00 1,000,000.00 1200.00 613,33 0.24% 024061 Coastal 1.000,000.00 1.000.300 00 FHLB 3133792145 07/09/12 07/05/13 14/0 180 61 85 1000000 1.000,00000 1,000,00000 1,250.00 596,25 0.25% 0.250% FSW 1,000,000.00 1,000.38000 FHLB 3133797L7 04725/12 07/15/13 Nit 180 155 75 99.9900 1,000,000.00 999.900.00 1,200.00 500.00 0.2534 0.240% FSW 100.00 4100.00) 599.900.00 1905,32090 FFCB 3133EAAY4 01030/12 07728/13 0426112 180 240 84 99.9500 1,000000:00 999.500.00 1,100.00 391,11 5,35% 0.22061 Coastal 500:00 (500.007 999,500.00 1,000.900.00 FHLB 313376562 01/30012 07130113 N/C 180 240 60 100.5100 1,000,090.00 1.500.100.00 1,40000 466,67 0.275, 0,250% Cantor +00.00 100.00 1,000,103.00 1,000,390.00 FHLB 313376L1Y9 02703/2 08/05/13 NAC 480 237 55 100.0000 1,000.090.00 1,000,000.00 1.25900 381.94 0.25% 0.25055 Mutual 1,030,000.05 1,000.420.00 FHLB 313376M/50 06/17112 06/15113 54/0 160 43 45 100.0569 1,000,000,00 1,000,556.00 1,453.00 350.00 0.22% 0.260% FSW 586.00 506.00 1,000.566.00 1.009.700.00 FHLB 313380601 08/28/12 05128/13 WC 180 32 32 100,0000 1,000,000.00 1,000,000.00 1.150.00 294.44 0.23% 0.23096 790101 1,000,000,00 1000.270.00 FNMA 31507A3118 92008712 09/03/13 NDC 185 232 27 101.2520 1,000,000.00 1,012,520,00 6250.00 757,50 0.25% 1.050% Vining 12,520.00 7,248.45 1,007.248.45 1,006.920.00 FHL6 313378E09 03/09/12 09109/13 4147 180 201 21 100.0000 1,000,000.00 1,000.000.00 1,550.00 180.63 0.31% 0.310% Duncan 1,000,000.00 1,301,00000 FNMA 3136642M3 01/19/12 09/381/3 WC 160 251 180 101.4560 1,000. 000 .00 1,014,060.00 5.625.00 5,625.00 0.29% 1.12544 Vining 14,060.00 7733.03 1.007733.00 1,009.110.90 FHLB 3133784313 04716712 10/15713 WC 179 164 164 100,0000 500.000.00 500900.00 873.14 79722 5.36% 0.350% Mutual 500,000.00 500,705.05 91445 31337)4/25 04/18012 10/11013 NAC 180 762 162 100.00(10 6.000.000.00 1,000,000.00 1,875.00 1,557.50 0.385, 0.375% Coastal 1900,000.00 1,001,680.00 FFCB 3133EA6315 32/06/12 11101013 05)01/12 180 232 149 99.9750 1,000,000.00 999,750.00 1,250.09 1.034.72 0.25% 0.250% Mutual 250.00 4250.001 999,750.00 1,000,010.00 FHLB 313379FK0 05/45/12 11715/13 WC 180 135 135 100,0000 1,00000000 1,000.000.00 1,500.00 1,125.00 0.3061 0.300% 887970 1,000,000.00 1,350,590,00 FHLMC 313402601 11/29111 11/29773 11/29712 180 301 121 1000000 500.000.00 500,000.00 1,250.00 540.28 0.50% 0.500% FSW 500,000.00 500,205.00 FNMA 30351201G94 12106/11 12/06/13 12/06/12 150 254 114 100.0000 500.090.00 500000.00 1,562.50 999.59 0.63% 0.62596 FSW 500,000.00 500,195.00 FNMA 313570GF4.2 12406/11 12176013 12104/12 190 294 114 100.0000 500,000.00 503,000.00 1,582.50 969.56 0.635, 0.62599 Mutual 500,000.00 500,19500 FAMCA 31315P7(W4 0506/12 12106/13 12406/13 180 114 114 100.0000 1,000,000.00 1.000.000.00 1.675.03 1,187.50 0.365, 0.375% Coastal 1,000,000.00 1,000,320.00 9908 313310409 05/11/12 12127/13 12/27/12 180 139 53 100.0000 181.000.00 191.500.00 425.35 219.78 0.47% 0.47054 Duncan 161,000.00 161.106.79 FHLMC 313403.82 01/12/12 01/09/14 WC 180 259 81 100.1910 1.000.000.00 1,001,810.00 2.250.00 1,012.50 9.385, 0.450% Samco 1,610.00 1,131.30 1,001,131.30 1,002,780.00 FFCB 5133E618P3 01/27112 91/24/14 94127)12 180 243 63 99.6750 1,000000.00 998,75090 1,750.00 612.50 0.36% 0,35055 Coastal 250.00 (250.00) 999,750.00 1,500,010.00 9976 3)33E1169/5 32/07/12 02/03)14 06103/12 180 233 57 99.9500 1.000,000.00 999,500.00 1,850.00 522,50 0.3696 0.330% 9570 520.00 4600.004 999.550.00 1,000,01000 FHLMC 313465319140 0221/12 02/21/14 02121113 180 219 39 1000000 1,000,000.00 1,005.000.00 2,250.00 487.50 0454E 0.45054 Cantor 1,000.000.00 1,001,08050 FHLMC 313403706 04/05/12 02127/14 WC 180 175 33 100.0000 775,000.00 775,000,00 1,153.13 266.41 0.3761 037544 Vining 775,000.00 776,433 74 914,6 3133781487 02/25/12 02128/14 02/21113 190 212 32 100.0000 500.00099 500.00000 1,000.00 177.78 0.40% 0.40096 Coastal 500.000.00 500.455.00 FHLMC 3134133N95 02127/12 03121/14 N/C 180 213 9 99.8200 1,000,000.00 998,200.09 5,500.00 75.00 0.39% 0.30055 Mutual 1,800.00 (1224.00) 998.776.00 1,001.350.00 FHLMC 313403RI(8 03/14/12 03/14/18 63/14/14 150 198 16 100.0000 906,000.00 900,000.00 4,500.00 400.00 1.06% 1.000% 5 of T 900000.00 907,497.00 TOTAL: 32,906,000.00 32.938,739.90 56,378,36 31.981,73 0.362161 4,900.00 37,438.00 13,513.70 32.919,513.70 32.948,694.04 Investment Pools LOGIC WA Texslar WA. WA WA N0A WA WA WA WA NIA 100.0000 70.81 70.61 NFA WA 0.1964% LOGIC 100.0000 14,677,058,70 14,577,056.70 NIA WA 0.1574% 7400191 70:61 70.81 14.677,058,70 14.677.058.70 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 Inv *hnrant Typo LOGIC Lural Gov't Pod FNMA Fed. Nati Mori, ASSOC, TerStar Local Govt Pool FFCB Fed. Farm Credit Bank Texpool Lode Gov't Pool FHLB Fed. Home Loan Bank FGIC Money Market Fuad Inv. CUSIP Perchose Maturity Cas Term Term Days Price Type t call4 ate pgl4 On dey51 Fiances ACCr8ed P0) $10p FFILMC Fad. Horne Loan Mort. Corp CD Certificates of Deposit TRILL Treasury Bill Texpool NIA 1414 04 1NA WA 400.0000 FGIC N/A NIA fdrA NIA Nth 100.0000 B Of T NIA NIA NIA NIA NIA 100.0000 TOTAL: TOTAL PORTFOLIO Cily of Euleks investment Portfolio September 30. 2012 Institution Vining Vining Sparks COSStat Coastal SeCVrities Samco Sam0o Capital Mutual Mutual Securities Par Principal Next It Interest Yield TO Vatue Inv Paymenl gsrygtE Maturity 16.312 630 00 (0 00) 16.040.90 31,005,850.20 18.312,660.00 (0 00) 16,010.90 31.065,850.20 NIA NPA 01313% N/A NIA 0.00005 NIA NIA 0.0100% 0.1717% 63,911,050.20 63,944,586.20 01,075.35 31.961.73 LOGIC Local Gov't Investment Coop FSW First Southwest Te $tar ToaSTAR Cantor Cantor Fitzgerald Texpoel TEXPOOL Duncan Duncan Williams FG IC Federated Investors Trust Coupon Seller Unomdrtiied Book Markel Rate 1o1 Dis tau. Premium Preml)Oi1C3 Value Value Texpool 16.312.680:00 16.312,680.00 FG1C (0 00) (0 00) 13 of T 16.040 00 16,040 00 0.00 0.00 0.00 31,005,650.20 31,005,050.20 4,900.00 37,636.00 13,513.70 63.926.363,90 63,854,544.24 Irlve8dnerrt Type LOGIC Local Gov, Pool FNMA Fed. Nett Mort. Assoc. Texs6sr LOcaI G0v1 POW FFCB Fed. Farm Credit Bank TexpOol Local Gov't Pool FHLB Fed. Home Loan Bank FG15 Money Markel Fund 1 1 1 1 1 ! 1 1 1 1 1 1 FHLMC Fed Home Loan Mort. Corp CD Certificates Of Deposit TRILL Treasury Bill City 0f EuteSe trruestment Portfolio June 30. 2012 Vining Vining Sparks 505/181 Coastal Seco/MOS Samoa Samoo Capital Mutual Mutual Securities Institution Inn. CUSIP Purchase MaLinty 5011 Term Term Days Price Par Principal Neal Int Interest Ylekl To COup09 Seller 1st Nurnber Mt Dge 50 } QM= Abe-oad Per 5100 Value 10703550 Pavmenl Accrued M91uri1V Beg In51. B.S. Govenwnent Agencies Agency AisoOlants Agency Coupon NOW; FFCB 31331J7A5 01110/11 07/10/12 1410 180 530 170 100.0000 1,000,000.00 1.00090000 2,500.00 2,361 11 0.50% 0.500% TVAS 86059EMF8 01105/11 07/15112 90/0 550 535 535 69.0134 915 000.00 905,972.61 9.037 40 0,781.19 0.5550 0945% F958 213311/740 01/25/11 07125112 WC 180 515 155 100.0000 1,000,00000 1,000,00000 2,500.00 2,152.78 0.5014 0.500% FHLB 313374037 07426/11 07/25/12 WC 180 334 155 99.9957 500,000.00 499.978,50 625.00 536.19 0.25% 3.25034 FHLB 313375005 08/08/11 08105/12 N1C 350 322 322 100.0510 1.000.000.00 1,000,510,00 2.500.00 2.236.11 0.15% 0.250% FHLB 3133XXLX3 62115/11 10126/12 WC 180 495 98 101,100D 554000.00 55605000 3,781.25 2.058.66 072% 1375% FHLMC 3134121VT7 04/04111 11/26712 N1C 180 446 34 99,0250 50400000 499,125.00 1,287.50 243.19 0.62% 0515% FHLMC 3134611574 02/15/11 12/27/12 64/0 180 495 3 100.5060 500,500.00 502,53090 2750.00 45.83 0.8314 1.100% FHLB 3133780449 54/13/12 04/12/13 NIC 180 77 77 100.0000 1,000.900,00 1,000.000.00 1.200.00 513.33 0.2414 0.24014 FHLB 313375530 04/16/12 04/16/13 WC 180 74 74 100.0000 500,090.00 505000.00 625.00 256.94 0.2514 0.25044 FHLB 313379066 05/03/12 05/03/13 N/C 360 67 57 100.0000 1,000.000.00 1,000.000.00 2,200.03 346.33 0.22% 0.220% FHLB 313378667 11/23411 05,23113 11123/12 180 217 37 100.0000 1.000,000.00 1.000.000.00 1,750.00 359.72 0.35% 0 350% FHLB 313376153 12/19111 06/19/13 WC 160 191 11 1000000 1,000,000.00 1,000,600.10 2,000.00 122.22 0.40% 0,400% FFCB 31331K3X6 12/30/11 06120,13 03120/12 160 180 10 99.9750 500,000:00 499.075.00 700.00 3989 0.30% 0.25056 FHLB 31337912F4e 05/21/12 06/2/113 11421/12 180 39 39 100.0000 1,000,000.00 1000.000.00 1,250.00 270.83 0.2514 0250% FHLB 3133761407 1229/11 0628/13 12/26112 180 1e1 2 99.9500 1,000.000.00 195,500.00 1.500.00 16.67 0.33% 0.300% FHLB 313379Y75 06/28/12 06/28/13 NIC 180 2 2 100.0000 1,000.500.00 1,000,000.00 1,200.00 1.3.33 0.2414 0.240% FHLB 3133717L7 04125/12 57415/13 91/0 60 85 65 99.9900 1,000,000.00 999.900.00 533.33 433.33 0.35% 0.240% FFCB 31336AA54 01/30/12 07/26/13 04/24712 180 150 154 99,9500 1,000,000.00 999,500.00 1.100.00 94111 025% 0.22045 FHLB 313376562 01130/12 07/30/13 WC 186 150 150 100.0100 1,000000.00 1.000.100.00 1,400.00 1.166.67 027% 0.280% FHLB 313370U59 52/03/12 00405/13 9010 182 147 147 100.0000 1,000,000.00 1,000,500.00 1,253.99 5,020.83 0.25% 0.25015 FHLMC 513402917 08/08411 08/08113 94408/12 180 322 142 100.0000 1,000,009 50 1.300,000.05 3.125.00 2,465.28 0.6314 0.625% FHLMC 3134402V919 09/22111 08/22/13 06/22/12 180 308 128 100.0000 1,000,000,00 1.000,000.50 2,750.00 1,555.56 0.55% 0.550% FNMA 31398A3A6 02108/12 09/03113 9010 180 142 117 161.2520 1,000,000.00 5,012,520.00 5,250.00 3,412.50 0.25% 1,050% FNMA 513500004 06106/11 09/05113 09108/12 160 294 114 100.0000 925,000.00 925,000.00 2,061,25 1,318.13 0.455/ 0.45056 F1110 313376E579 03109/12 09100443 51/0 180 111 111 100.0000 1,000.000.00 1,000000.00 1550.00 955.83 0.31% 0.310%. FNMA 3139642113 01/19/12 0630113 14/5 180 161 80 101.4060 1.000.000.00 1,014,055.00 5.625,00 2,812.50 0.2915 1.125% FHLB 313376YX3 04/16112 13/15/13 6410 179 74 74 100.3000 500.000.00 500000.00 870.14 399.72 0 35% 0.350% FHLB 313375U25 0418/12 10/18/13 WC 150 72 72 100.0000 1.006000 .00 1,000,000.00 1,575.00 750.00 0.38% 0375% FFC6 3133EA555 02108/12 11701/55 06101112 180 142 59 99.9750 1,000,000.00 999,750.00 4,25000 409.72 0.265/ 0.250% FHLB 3/3375F00 05/15/12 11/15/13 WC 160 45 45 150.0000 1,000,000,00 1,000,000,00 5,500.00 37590 0.30% 0.30014 FHLMC 313412281.61 11/29111 1112615 11129/12 180 211 35 100.0000 500,000.00 500,000.00 1,250.50 215.25 0.50% 0.5005/ FNMA 3135G012F4 12106/11 12/06/13 12406112 180 204 24 100.00100 500,000.00 550,000.00 1,562.50 200.33 0.63% 0.62546 FNMA 313500094-2 12746/11 12/06/13 12/06112 180 204 24 190.0000 500.000.00 500000.00 1,562,50 208.33 0.63% 0.62516 FAMCA 31315PXW4 06/06/12 12/08/13 62/06/12 180 24 24 100.0000 1,004000.05 1,000,000.03 1,875.00 250.00 538% 5.375% FFCB 31331K4D9 05/11/12 12/27113 12/27112 180 49 3 100.0000 191,000.00 151,000,00 425.35 7,09 0.47% 047514 FHLMC 2134123J82 01/12/12 01/09114 N/C 100 166 171 100.1610 1,000,000.00 1,001,610,00 2,250.00 2,137.,50 0.36% 0.45096 9956 3133EAAP3 01127712 01/24114 04127112 180 153 153 99.9750 1,000,000.30 999,750.00 1750.00 1,407,50 4.3614 0.350% FF56 31336A0V9 52/07412 02/03/14 06(03712 162 143 149 99.9500 1,050,000.00 999500.00 1,688.33 1,360.53 0,36% 0.330% FHLMC 3134433MH0 02121/12 02/21/14 02/25713 180 129 129 100.0000 1000,000.00 1,000,500.00 2.25000 1,612.50 0.45% 4.45056 FHLMC 313403LA6 04/05/12 02/27/14 90/5 214 85 157 100.0000 775.005.00 775,000.00 1,727.60 1,267.45 0.37% 0.375% FHLB 3133764487 02/28/12 02/28/14 02/28113 180 122 122 100.0090 500.000.00 500,000.00 1,500,00 977.78 0.40% 0.400% FSW Duncan Duncan FSW FSW Samco Samoa Samoa Cantor Cantor Mutual Samco Duncan Coastal F5W FSW Coastal FSW Coastal Cantor Mutual FSW Coastal Vining Vining Duncan Vining Mutual Coastal Murual Samos FSW FSW 4,lutual Coastal Duncan 5amo0 Cea51a1 FSW Ca nick Yining Coastal LOGIC Local Gov't Investmeto Coop. FSW /451. S0ulhwest Texster TesSTAR Cantor Cantor Fitzgerald Texpaol TEXPOOL Duncan Duncan Williams /GIC Federated Investors Trust Unamortized Book Market Discount Premium PremllDisc) slue +Lalu9 1,000,000.00 905, 972.61 1605600.00 21,50 (21.50) 499,978.50 510 00 510.00 1,000,510.00 5,050.00 007.50 550,907.50 875.00 1184.20) 499 815,80 2,533.00 575.00 900.575 00 1,000,000.00 500000.00 1_000,000.00 1,050,000.00. 1,000.000.00 125.00 4125.00) 499.975.00 1,000.000.00 500.00 (500.00) 999,50000 1,030,000:00 100.00 (100.004 999,900.00 500.00 (500 00) 999,500.00 100.00 100.00 1,000,10090 1.000.000.00 1.000.000.00 1,000,000.00 12520.00 9,225,30 1.009,225.30 925.000.00 1.000.000.00 14.495.00 9,842.00 1.009,842.60 500,000.00 1,000.00090 250.00 5250.004 999,750.00 1.000.00000 500,000.00 500,000.00 500,000.00 1,000,000.00 191.000,05 1,810.00 1,357.56 1.001,357.56 250.00 (250.00) 999,750.00 500,00 (500.00) 999600.00 1000,000.00 775,000.00 590,000.00 1.000,090 50 914,734.65 1,000,260.00 500.020.00 1,000.05900 552,040.50 500.605,00 502,125 00 999.820.00 499 942.00 999.578 00 1,000.540,00 1,001 090, OD 500,025 00 999.625.00 1,000060 00 999 492.00 999.402 00 1.000.020.00 999.747.00 999,397.50 1.000,390.00 1,000,210.00 1,008,55000 925 425.50 999, 904.00 1,004.920.60 500.120.05 1.000,550.00 1000,030.00 999.414 00 500.585.00 500.675.00 500.875.00 1.030.500 00 191,293.22 1001, 320.00 1,000,050 00 1,000,050.00 1,001.160.00 774,921 73 500,150.05 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 City of Euyss Investment Portfolio June 30, 2012 Investment Type Institution LOGIC Leal Gov't Pool FNMA. Fed. Nat'l Llan. Assoc. FHLMC Fed. Home Loan Mors, Corp Vining Vining Sparks LOGIC Local Govt Investment Coop. FSW First Southwest Texdar Local Gov't Fo01 FFCB Fed. Farm Credit Batik CO Ce9iflt31e3 of 0ego5il Coastal Coastal Securities Texstar TexSTAR Cantor Caldor Fitzgerald Texpool L0061 Govt Pool FHLB Fed. Horne Loan Bank TRILL Treasury BILI Samoa SamC0 Capital 7expool TEXPOOL Duncan Duncan Williams FGIC Money Markel! Fund Mutual Muluel Securities FGIC Federated Investors Trust Inv. CUSIP Purchase Maturity Call Term Tenn Gays POW Par Principal Next int Interest Yield To Coup00 Setter Unamorlized Book Markel Torre Num08r Dale Q4.4¢ Q{1g lindaysl Elapsed Accrued Per im ydlue InYs P_Ltraltat ACcrs5 Munt Rate WI, Discount ergritium PremlfDisc) ale Vaiue FIELMC 31341331455 02127112 03/21/14 NIC 180 123 99 99.8200 1,000.000,05 998,200.00 1,500.00 825.00 0.39% 0.30094 Mutual 1.600.00 1,440.09 1.901.440.00 998.456.00 FHLMC 3134123649 03/14112 03/14/16 03114114 180 106 106 150,0000 900.006.00 900.000.00 36.000.00 936,090.00 1 0015 1.00034 B of T 900,000.00 907.551.00 TOTAL: 37,246900.00 37,269,631.11 122,391,05 964,996.15 0.406215 4,921.50 37,680.00 21,526.66 37,256,499.27 37,280,476.60 Investment Pools LOGIC NIA WA NIA NIA NIA 100.0000 70.80 T0.60 ISA NIA 0.2514°5 LOGIC 70,60 70.60 Texstar N/A ISA NIA NIA NIA 100.9900 12942637.75 12.942,837.75 NIA NIA 0.137596 Texstar 12.942,837 75 12.942.537.75 Texpool ISA I414 WA NIA NIA 100.0600 14,319.329.20 14.319,629.20 NIA NIA 0.13959E Teo5Ool 14,315,329.29 14.319,329 20 FGIC ISA NIA NIA NIA NIA 100.0000 (0.06) {0.001 NIA NIA 90000% FDIC (5.00} 0,001 B of NIA NIA NIA NIA NIA 100.0000 11.540,62 11,540.82 NIA NIA 0.0100% 6o1T 11,540.62 11.540,62 70145.; 27,273,778.16 27,273,776.14 0.106315 0.00 0.00 0.09 27,273,779.16 27,273,176.16 TOTAL PORTFOLIO 64,519,778.15 64,643,409.27 122.391.06 9E4,996.19 4,921.50 37,500.00 21,626.66 64,532,277,43 64,554,264.76 f 1 f f 1 1 1 1 1 Investment Type LOGIC Local Gov't Pool Tessler Local Gov't Pool Texpool Local Gov't Pool FGIC Money Market Fund I 1 City of Euless Investment by Fund September 30. 2012 Institution FNMA Fed. Nat'l Mort. Assoc. FHLMC Fed. Home Loan Mort. Corp Vining Vining Sparks FSW First Southwest LOGIC Local Gov't Investment Coop. FFCB Fed. Fann Credit Bank CD Certificates of Deposit Coastal Coastal Securities Cantor Cantor Fitzgerald Texstar TexSTAR FHLB Fed. Home Loan Bank TBILL Treasury Bill Samna Samno Capital Duncan Duncan Williams Texpool TEXPOOL Mutual Mutual Securities FGIC Federated investors Trust Accrued Total P • 4 ig tnv. CUSIP Purchase Matudry Call Term Days Price Par Cost Interest Total Prin. • Yield To Coupon interest Maty Nei of Total Cost Market % 0f Number Date Date ate fin days). remaining Per 100 Value (Pr/nflow! mat'. Int 34 Maly Maturi Rate Purchased Discount Premium Fund Prem & Int Pur of Investment Value Portfolio WAN.' Fund 101 -General Fund FGIC 4JA 100.0000 0.00 0.00 0.00 0.00% 101 0.00 0.00 0.00% 0 00 Texpool NO. 100.0000 517,123.16 517,12316 517,12316 0.13% 101 517,123.16 517,123.16 517.123.16 0.61% 000 Texstar NIA 100.0000 1,513,930.69 1,513,930.69 1,513.930.69 0.1695 101 1.513,930.69 1.513,930,69 151303009 2.37% 000 FHLB 313376,IY2 12/19/11 08119/13 NIC 540 259 100.0000 1.000,000.00 1.000.000.00 6,000.00 1,008,000,00 0.40% 0.40045 101 1,006,000.00 1.000,000,00 1.001.070 00 1.56% 4 05 FHLB 313376562 01/30/12 07130113 NIC 540 300 100.0100 1,000,000.00 1,000,100.00 4,200.00 1,004,200.00 0.2705 0.280% 100.00 101 1,004.100.00 1,000,10000 1,000,390.00 1.56% 4.69 FHLB 313376UY9 02/03112 00/05/13 NIC 542 305 100,0000 1,000,000.00 1.000,000.00 3.763.09 1,003,78389 0.25% 0.250% 101 1.003,763.69 1,000,000.00 1,000,420.00 1 5695 477 FHLB 3133750560 08117/12 06/15/13 NIC 358 315 100.0566 1,000,000.00 1.000,566.00 2600.00 1,002,600.00 0.22% 0.280% 15.56 566.00 101 1,002,216.44 1,000,501.56 1,000,70000 1.56% 493 FNMA 31398A2M3 01/19/12 09/30/13 NCC 611 360 101.4060 1,000,000.00 1,014.060.00 22.500.00 1.022,500.00 0.29% 1.12591 3,406.25 14060,00 101 1,005.033.75 1,017,466.25 1,009.110.00 1.5955 5.73 FFCB 3133EA0X5 02/00/12 11/01113 05101/12 623 391 99.9750 1.000000.00 999,753.00 4,37500 1.004,375.00 0.26% 0.250%4861 250.00 101 1,004.326.39 999,796.61 1.000.010,00 156% 6.11 FNMA 3135000F4.2 12106/11 12/06/13 12/06/12 720 425 100:0000 500,000.00 500,000.00 6.250.00 506,250.00 0.8305 0,625% 101 508,250.00 500,000.00 5.00,195 DO 0.76% 3.33 FHLMC 3134G3MH0 02,21112 02/21114 02)21/13 720 501 100.0000 1,000,000.00 1.000,000.00 9,000.00 1,009,000.00 0.45% 0.450% 101 1,009,000.00 1,000,000.00 1,001,080.00 1 5695 7.03 Subtotal 9,531,053.66 9,545,529.86 58,808.89 9,589,942.75 3,470.42 250.00 14,726.00 subtotal 9,571,746.33 9,549,000.26 9,544,026.66 14.93% 41.44 Fund 102 -General Fund Emergency FHLMC 313402601 11/29111 11/29113 11/29112 720 419 100.0000 500,000.00 500,000.00 5,000.00 505,000.00 0.50% 0.50005 102 505,000,00 500,000.00 500.20500 0.78% 3.28 Fund 103 -General Fund Contingency Texpool N/A 100.0000 0.00 0.00 0.00 0.13% 103 0.00 0.00 0.00% 0.00 Texstar 1.4/4 100.0000 0.00 000 0.00 0.16% 103 - 0.00 0.00 0.00% 0 00 FHLB 313378/X.3 04/16/12 10/15113 N/C 539 375 100.0000 500,000.00 500,000.00 2,620.15 502,620.15 0.3505 0.35041 103 502,620.15 500,000.00 500,705.00 0.76% 2.93 subtotal 500,000.00 500,000.00 2,620.15 502.620,15 0.00 0.00 0.00 502620.15 500,000.00 500.705.00 0.7605 2:93 Fund 201-Hotel/Hotel FGIC 1.1/4 100.0000 0.00 0.00 0.00 0.0095 201 • 0.00 0.00 0.0095 0.00 Texpool N/A 100.0000 100,297.49 100,297.49 100,297,49 0.13% 201 100,297.49 100,297.49 100,297.48 0.16% 0.00 Texstar N/A 100.0000 15,144.59 15,144.59 15,144.59 0.16% 201 15,144.59 15,144.59 15,144.59 002% 0.00 subtotal 115,442.09 115,442.09 0.00 115.442.09 0.00 0.00 0.00 subtotal 115,442.09 115.442 09 115,442.09 0.1895 0.00 Fund 252-JuvenhM Case Texpool NIA 100.0000 75,172.45 75,172.45 75,172.45 0.13% 202 75.172 45 75,172.45 75172.45 0.1205 0.00 subtotal 75,172.45 75,172.45 0.00 75,172.45 0.00 000 0.00 subtotal 75,172.45 75,172.45 75.172.45 0.12% 0.00 Fund 210 -Half Cent Operations Texpool N/A 100,0690 616,129.09 616,129.09 0.00 616,129.09 0.1391 210 816,129.09 616,129.09 616,129.09 0.96% 0.00 FG€C N/A 100.0000 (0.00) (0.00) 0.00 (0.00) 0.00% 210 (0.00) (0 00) (0.00) 0.00% 0.00 Texstar N/A 100.0000 676,549,77 676,549.77 576,549.77 0.1655 210 676,549,77 676,549.77 676,549.77 1.06% 0.00 Subtotal 1,292,670.86 1,292,676.66 0.00 1,292.67886 0.00 0.00 0.00 subtotal 1,292,678.86 1,292,678.86 1,292,678.86 2.02% 0.00 Fund 211 -Half Cent Reserve Texpool N/A 100.0000 0.00 0.00 0.00 0.00 0.13% 211 0.00 0.00 0.00 0.00% 0.00 BofT N/A 100.0000 16,040.90 15,040.80 0.00 16,040.90 0.13% 211 16,040.90 15,040.90 15,040.90 0.03% 0.00 FHLMC 313403RK8 03/14/12 03/14/16 03114114 1440 1244 100.0000 900,000.00 900,000.00 39,000.00 936,000.00 1.0005 1.000% 211 936,000.00 900,000.00 907,49700 1.41% 17.5' Subtotal 916,040.90 916.040.90 36,000.00 9.52,040.90 0.00 0.00 0.00 952.040.90 916,040.90 923.53790 143% 17.51 Fund 220 -Crime Control and Prevention FGIC N/A 100.0000 0.00 0.00 0.00 0.00 0.0005 220 0.00 D.00 0.00% 0.00 Texpool NIA 100.0000 100,855.07 100,855.07 0.00 100,055.07 0.13% 220 100,855.07 109,855.07 100,655.07 0.189E 0.00 Texstar N/A 100.0000 55,139.52 55,139.52 55,139.52 0.16% 220 55,139.52 55,139.52 55,139.52 0.09% 0.00 Subtotal 155,994.59 155,994.59 000 155,994.59 0.00 0.00 0.00 subtotal 155.994.59 155,994.59 155,994.59 0.24% 0.00 Fund 230 -Police 06A {Federal) FGIC 1/4 100.0000 0.00 0.00 0.00 0.0005 230 • 0.90 0.00 0.00% 0.00 Texpool N/A 100.0000 556.90 556.90 0.00 556.90 013% 230 558.90 556.90 556.90 0.00% 0,00 Texstar N/A 100.0000 10,505.93 10,505.93 10,505.93 0.16% 230 10,505.93 10,505.93 10,505.93 0.02% 0,00 Subtotal 11,062.62 11,062.82 0.00 11,062.82 0.00 0.00 0.00 subtotal 11,052.82 11,062.02 11,062.82 0.02% 0.00 Fund 231 -Police DEA {State) FGIC ISA 100.0000 0.00 0.00 0.00 0.00% 231 - 0.00 0.00 0.00% 0.00 Texpooi NIA 100,0000 100,730,37 100,730,37 0.00 100,730.37 0,1391 231 100,730.37 100,730.37 100,73037 0.16% 0.00 1 1 1 1 1 1 1 1 1 Investment Type LOGIC Local Gov't Pod Texstar Local Gov't Pool Texpool Local Gov't Pool FGIC Money Market Fund 1 1 City of Euless Investment by Fund September 30, 2012 Institution FNMA Fed, Nat'l Mort. Assoc. FHLMC Fed. Home Loan Mom. Corp Vining Vining Sparks FSW First Southwest LOGIC Local Gov't Investment Coop FFCB Fed. Farm Credit Bank CD Certificates of Deposit 0009(8l Coastal Securities Cantor Cantor Fitzgerald Tessier TexSTAR FHLB Fed. Home Loan Bank TRILL Treasury Bill Samco Samco Capital Duncan Duncan Williams TexpoOI TEXPOQL Mutual Mutual Securities FGIC Federated Investors Trust Accrued Total P 0 t iAD Inv. CUSP Purchase Maturity Call Term Days Price Par Cosl interest Total Prin. + Yield To Coupon Interest Mary Net of Total Cost Market % of -11m Number Q jg Date Date ;in days] remaining r 5100 Value {Prin. Qnly]maP • Int. Cf0 Maty Maturity Rate Purchased lacp.int. Premium Fund Prem & Int Ptlr of Investment Value Portfolio WAM Texstar Subtotal N/A 100.0000 30.195.66 30.195.66 30.195,66 0.16% 130, 926.03 130.926.03 000 130,926.03 231 30,195.86 30,195.86 30,195.86 0 05% 0 00 0.00 0.00 0.00 subtotal 130,926.03 130,928.03 130,926.03 0.20% 0.00 Fund 240 -Car Rental Fund FG1C NIA 100.0000 0.00 0.00 0.00 0.00% 240 - 0.00 0 00 0.00% 0.00 Texpool NIA 100.0000 648,312.41 645,312.41 648.31241 0.1315 240 648,31241 648,312.41 648,31241 1.01% 000 Texstar WA 100.0000 1,037,210.08 1.037,210.08 1,037,210.08 0.16% 240 1.037,210.08 1.037,210.08 1,037.210.08 1.62% 000 FHLB 313378W49 04/13/12 04/12/13 N/C 360 192 100.0000 1,009000.00 1.000,00000 2,400.00 1,002400.00 0.24% 0.240% 240 1,002,400.00 1,000,000.00 1.000,300.00 1.55% 3.00 FHLB 313378X30 04116/12 04/16/13 N/C 360 196 100.0000 500,000.00 500,000.00 1250.00 501,25000 0.25% 0.250% 240 501,250.00 500,000.00 500.170.00 0.7838 1.53 FFCB 31331K305 12/30/11 06/20/13 03/20112 530 260 99.9750 500,000.00 499,875.00 2,100.00 502,100.00 0.30% 0,280% 38,89 125.00 240 502,081.11 499,913.89 500,005.00 0 78% 2 C3 FHLB 313379GH6 05/21/12 06/21/13 11/21112 390 261 100.0000 1,000.000.00 1,000,000.00 2,70833 1.002.708 33 0.25% 0250% 240 1,002,708.33 1.000,000,00 1.000,140.00 1 5815 408 FMLO 313379178 06+28/12 06729/13 N/C 380 268 100.0000 1,000,000.00 1,000,000.00 2,400.00 1,002.400.00 0.24% 0.240% 240 1,002,40000 1.009000,00 1,000,300.00 1 56% 4.19 FHLB 313378E09 03/09/12 09/09/13 NMC 540 339 100.0000 1,000,000.00 1,000,000.00 4,650.00 1,004,650.00 0.31% 0..31015 240 1,004,650.00 1,000,000.00 1,001,00000 1 56% 5.30 FHLB 313378025 04/18/12 10/1813 WC 540 378 100.0000 1,000,000.00 1,000,000.00 5,625.00 1,005,62.5.00 0.3895 0.375% 240 1,005,625,00 1,000.000.00 1,001,880.00 1.56% 591 FFCB 3133EABV9 02/07/12 02/03/14 06/03112 716 483 99.9500 1,000,000.00 999,500.00 6,618.33 1..006.818.33 0.3815 0.330% 55.00 50000 240 1.008.583.33 999.555.00 1.000.010.00 1.5845 7.55 Subtotal 8.685,522.49 8,884.897.49 27,751.67 8,713,274.15 93.89 625.00 0.00 subtotal 8,713,180.25 8,694,991.38 8,689.12749 13.58% 33.60 Fund 245-G1ade Parks PIO Texpool NIA 100.0000 150,061.39 150,061.39 150,061.39 0.1346 245 150,061.39 150,061.39 150.061.39 0.23% 000 Fund 250 -Glade Parks TIRZ 13 Texpool N/A 100.0000 0 00 0.00 0.00 0.13% 250 - 0.00 0 00 0.00% 0 00 Fund 301 -Developer's Escrow FGIC NIA 100.0000 0.00 0.00 0.00 0.00% 301 . 0.00 0.00 0.00% 0.00 Texpool N/A 100.0000 722,938.07 722,938.07 722,936.07 013% 301 722,936.07 722,936.07 722,938.07 1.13% 0.00 Texstar NIA 100,0000 503,457.54 503.457.54 503,457.54 0.16% 301 503 457.54 503,457.54 503.457.54 0.79% 0.00 FFCB 31331K4D9 05/11/12 12/27/13 12127/12 586 447 100.0000 181,000,00 181,000.00 1,701.40 182,701.40 0.47% 0.470% 916.55 301 162,384.75 181,315.65 181,106.79 0.28% 1.27 Subtotal 1,407.393.61 1,407.393.61 1,701.40 1409,09501 316.55 0.00 0.00 subtotal 1,408.778.36 1.407,710.26 1407.500.40 2.20% 1.27 Fund 305 -Streets CIP FGIC N/A 100.0000 0.00 0.00 0.00 0.00 0.00% 305 . 0.00 0.00 0.00% 0.00 Texpool N/A 100.0000 353,472.21 353.472.21 0.00 353,472.21 0.1315 305 353,472.21 353,472.21 353.472.21 0.55% 0.00 Texstar NIA 100.0000 1,051,168.03 1,051,168.03 0.00 1,051.166.03 0.16% 305 1,051,166.03 1,051,166.03 1,051,166.03 1.8496 0.00 FHLMC 313431LD4 02/15111 12+27112 111C 672 87 100.5060 500,000.00 502,530.00 11,000.00 511,000.00 0.83% 1.100% 73333 2530.00 305 507,736.67 503,263.33 501,120.90 0.79% 068 Subtotal 1,904,838.24 1,907,158.24 11,000.00 1,915.638.24 733.33 0.00 2,530.00 subtotal 1,912,374.91 1.907,901,57 1,905,75824 2.98% 0.68 Fund 310 -Half Cent CIP FGIC N/A 100.0000 0.00 0.00 0.00 0.00 0.00% 310 . 0.00 0,00 0.00% 0.00 Texpool NIA 100.0000 101,196.40 101,198.40 101,196.40 0,13% 310 101.198.40 101.196.40 101,195.40 0.16% 0.00 Texstar NIA 100.0000 277,829,35 277,829.35 277,829.35 0.16% 310 277,829.35 277,829.35 277,829.35 0.43% 0.00 FHLMC 313403N65 02/27/12 03(21114 NM 744 531 99.8200 1,000,000.00 998,200.00 7,500.00 1907,500,00 039% 0.30096 175.00 1.800.00 310 1,007,325.00 998,375.00 1.001,350.00 1.56% 8.29 Subtotal 1,379.025.75 1,377,225.75 7,500.00 1,386,52575 175,00 1800.00 0.00 subtotal 1,386,350.75 1,377,400.75 1.380,375.75 215% 8.29 Fuad 320 -General CIP 1'exp004 N/A 100.0000 550,999.29 550,999.29 550.999.29 0.13% 320 550,999.29 550,999.29 550,999,29 0.86% 0.00 Texstar N/A 100.0000 265,024.68 265,624.88 265,524.88 0.1546 320 265,824,88 285,624.88 285,624.88 0,42% 0.00 FHLB 313380L34 08+28/12 08/28/13 1/0 360 328 100.0000 1,000.000.00 1,000,000.00 2,300.00 1.002,300.00 0.23% 0.230% 320 1,002,300,00 1,000,000.00 1.000,270.00 1.5695 5.13 Subtotal 1,816,624.17 1,816,624.17 2,300.00 1.818,924.17 0.00 0.00 0.00 subtotal 1.818.924.17 1.816.624.17 1,818,894.17 2.84% 5.13 Fund 321 -Redevelopment CIP Texpool N/A 100.0000 275,746.97 275,746.97 275,746.97 0.13% 321 275,746.97 275,748.97 275,746.97 0.43% 0.00 Subtotal 275,748.97 275,746.97 0.00 275,746.97 0.00 0.00 0.00 subtotal 275,748.97 275,745.97 275,746.97 0.43% 0.00 Fuld 325 -Police Facility CIP FGIC N/A 100.0000 0.00 0.00 0.00 0,00 0.00% 325 0.00 0.00 0.00% 0.00 Texstar N/A 100.0000 100,652.21 100,652.21 0.00 100,852.21 0.18% 325 100,652.21 100,652.21 100,652.21 0.1645 0.00 Subtotal 100,652.21 100,652.21 0.00 100,852.21 0.00 0.00 0.00 subtotal 100,652.21 100,652.21 100,652.21 0.1646 0.00 Fund 330 -Gar Rental CIP I 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 City of Euless Investment by Fund September 30.2012 Imeatment Type Institution LOGIC Local Gov't Pool FNMA Fed. Ner1 Mort. Assoc. FHLMC Fed. Home Loan Mort Corp Vining Vining Sparks FSW First Southwest LOGIC Local Gov't Investment Coop. Texstar Local Gov't Pool FFC9 Fed. Farm Credit Bank CP Certificates of Deposit Coastal Coastal Securities Cantor Cantor Fitzgerald Texstar TexSTAR Texpool Local Gov't Pool FHLB Fed. Home Loan Bank TSILL Treasury gill Sarum Samoa Capital Duncan Duncan Williams Tex pool TEXPOOL FGIC M0n89 Market Fund Mutual Mutual Securities FGIC Federated Investors Trust Accrued Total P + I a Imv. CUSIP Purchase Maturity Call Term Days Price Par Cost Interest Total Prin, . Yield To Coupon 15t6rest Mary Net OF Total OOst Market % of LI' Number Date Date Date in days) remaining Per $100 Value /Pun. Only) mat' Int. 102 Maty Maturity Rate Purchased Discount Premium Fund Prem & Int Pur. 0f Investment Value PortfDlio AM FGIC NIA 100,0000 0.00 0.00 0.00 0.00% 330 • 0.00 0.00 0.00% 0.00 Texpool NIA 100.0000 2,793,078.78 2,793,078.78 2,793,078.78 0.13% 330 2,793,078.78 2.793,078.78 2,793.078.78 4.37% 0.00 Texstar 509 100.0000 2,195,875.48 2,195.875.48 2,195,875.48 0.1646 330 2,195.875.48 2.195,87548 2,195,875,48 3.43% 0.00 Subtotal 4,988,954.26 4,988,954.26 0.00 4,988,954.28 0.00 0.00 0.00 su510191 4,988,954.26 4.988,954.26 4,988.954.26 7.80% 0.00 Fund 401 -Debt Servide Texpoot NIA 100.0000 557,250.21 557 250 21 557,250.21 0.13% 401 557,250.21 557.250,21 557.250 21 0.87% 0.00 FGIC NIA 100.0000 0.00 0.00 0 00 0.00% 401 0.00 0.00 0.00% 0.00 Texstar NIA 100.0000 0,00 0,00 0 00 0 16% 401 0.00 0.00 0.00% 0.00 Subtotal 557.250,21 557.250.21 0.00 557,250.21 0.00 000 0.00 subtotal 557250.21 557,250.21 557.250.21 0.87% 000 Fund 402 -Star Center Debt Service Texpoot NIA 100.0000 147366.69 147,266,69 147.266.69 0.13% 402 147,26669 147.266.69 147,266.69 0.23% 0.00 Texstar NIA 100.0000 0.00 0.00 0.00 0.16% 402 0.00 0.00 0.0036 0.00 Subtotal 147.26669 147,266.69 0.00 147,266.69 0.00 0.00 0.00 subtotal 147,266.69 147,266.69 147.266,69 0.23% 0.00 Fund 501 -Water and Wasterwater LOGIC NIA 100.0000 70.61 70.61 70.61 0.20% 501 70.61 70.61 70.61 0.00% 0.00 FGIC NIA 100.0000 0.00 0.00 0.00 0.00% 501 - 0,00 0.00 0.0015 0.00 Texpool 14I5 100.0000 1,052,940.50 1,052,940.50 1,052,940.50 0.13% 501 1,052,940.50 1,052,940.50 1,052,940.50 1.65% 0.00 Texstar NIA 100.0000 889,756.26 889,756.26 889,756.26 0.16% 501 889,756.28 889,756.26 889,75626 1,39% 000 FHLB 313379566 05/03712 05103/13 NIC 360 213 100.0000 1,000,000.00 1.000,000.00 2,200.00 1,002,200.00 0.22% 0.220% 501 1,002,200.00 1,000,000.00 1,000,120.00 1.56% 3.33 FHLB 313376E87 11)23/11 05/23/13 11/23/12 540 233 100.0000 1,000,000.00 1.000,000.00 5,250.00 1,005,250.00 0.35% 0.350% 501 1,005,250.00 1,000,000.00 1,000,280.00 1.56% 3.64 FHLB 3133792H5 07/09/12 07+05113 N40 356 275 100.0000 1000.000.00 1.000,000.00 2,500.00 1,002,500.00 0.25% 0.250% 27.78 501 1,002,472.22 1,000,027.76 1,000,360.00 1.5546 4.30 FNMA 313985358 02708712 0903/13 NIC 565 333 101.2520 1,000,000.00 1,012,520.00 21,000.00 1,021,000.00 0.25% 1.050% 4,520.83 12520.00 501 1.003,959.17 1,017,040.93 1,006,520.00 1.59% 5.30 FFCB 3133EAAP3 01/27)12 01124/14 04/27712 720 474 99.9750 1,000,000.00 999,750.00 7,000.00 1,007000.00 0.36% 0,35015 250.00 501 1,007,000.00 999,750.00 1,000,010.00 1.59% 7.41 FHLMC 3134G3LA5 04/05/12 02127/14 NIC 882 507 100.0000 775,000.00 775,000.00 6,086.95 781,066.98 0.37% 0.375% 581 25 501 780,505.73 775,581.25 776,433.75 1.21% 8.15 Subtotal 7,717,767,37 7,730,037.37 44,036.95 7,761.804.35 5,129.86 250.00 12,520.00 subtotal 7.744,154.49 7.755,167.23 7,726,611 12 1209% 30.13 Fund 502 -Water &Wastewater CIP FGIC NIA 100.0000 0.00 0.00 0.00 0.00% 502 - 0.00 0.00 00015. 000 Texpool 14/5 100.0000 616,587.42 616,587.42 618687.42 0.13% 502 616,587.42 616,587.42 616,587.42 0.9646 0.00 Texstar N/A 100.0000 157,781.03 157.781.03 157,76103 0.18% 502 157,781.03 157,761 03 157.751.03 0.25% 0.00 FHLMC 3134G1WT7 04104111 11/28/12 NTC 592 56 99.8250 500,000.00 499,125.00 5,150.00 505,150.00 0.8215 0.515% 91558 875.00 502 504,234.44 500,040.55 500,270.00 0.7815 044 FHLMC 3134133JR2 01/12/12 01,/0'9/14 N1C 717 459 100.1810 1,000.000.00 1,001.810.[ 9,000.00 1,009,000.00 0.3694 0.450°5 37.50 1510.00 502 1,007.152.50 1,001,847.50 1,002,760.00 1.57% 7.19 Subtotal 2,274,348.45 2,275,283.45 14,150.00 2,288,498.45 953.06 875.00 1,810.00 subtotal 2,285.735.39 2,276,236.51 2,277,378.45 3.56% 7.63 Fund 503-W&WW Debt Reserve Texpool NIA 100.0000 304,774.21 304,774.21 0.00 304,774,21 0.13% 503 304.774.21 304,774.21 304,774.21 0.48% 000 Texstar NIA 100.0000 0.00 0.00 0.00 0.16% 503 - 0.00 0,00 0.0015 0.00 Subtotal 304,774.21 304,774,21 0.00 304,774,21 0.00 0.00 0.60 subtotal 304,774.21 304,774.21 304,774.21 0.48% 0.00 Fund 504 -Service Center Texpool N/A 100,0000 000 0.00 0 00 0 00 0.13% 504 - 0.00 0.00 000% 0.00 Texstar N/A 100.0000 0.00 0.00 0.00 0.16% 504 000 0.00 0.0056 0.00 Subtotal 0.00 0.00 0 00 0 00 0.00 0.00 0.00 subtotal 0.00 0.00 0.00 0.00% 0.00 Fund 505 -Water Impact Fees Texpool N/5 100.0000 855,967.93 855,987.93 0.00 855.967.93 0,1315 505 555,967,93 855,967,93 855,967.93 1.3414. 0.00 FGIC N/A 100.0000 0.00 0.00 0.00 0.00 0.00% 505 0,00 0.00 0.00% 0.00 Texstar N/A 100.0000 5859.64 5,859.64 5,859.64 0.18% 505 5,859.84 5.859.84 5,859.64 0.019E 0.00 FAMCA 31315PXW4 08/08/12 12/08/13 12106/12 540 426 100.0000 1,000,000.00 1,000,000.00 5,625.00 1,005,825.00 0.38% 0.375% 505 1005,625.00 1,000.000.00 1,000,320,00 1.56% 6.66 Subtotal 1,861,827.57 1,861,827.57 5,625.00 1,857.452.57 0.00 0.00 0.00 subtotal 1.867,452.57 1,861.827.57 1,882,147.57 2.91% 6.66 Fund 507•W&W W Emergency Fund Texpool NIA 100.0000 500,000.00 500,000.00 0.00 500000.00 0.13% 507 500,000.00 500,000,00 500,000.00 0.78% 0.00 Texstar NSA 100.0000 0.00 0.00 0.00 0.16% 507 • 0.00 0.00 0.00% 0.00 Subtotal 500000.00 500,000.00 0.00 500,000.00 0.00 0.00 0.00 subtotal 500,000.00 500,000.00 500,000.00 0.78% 0.00 Fund 508 -Wastewater Impact Fees 1 1 1 1 1 1 1 1 1 1 City of Euless Investment by Fund September 30 2012 I I I Investment Type Institution LOGIC Local Gov't Pool FNMA Fed. Nat'l Mort. Assoc. FHLMC Fed. Home Lean Mort. Corp Vining Vining Sparks FSW First Southwest LOGIC Local Gov't Investment Coop. Texstar Local Gov't P001 FFCB Fed. Farm Credit Bank CD CertifiCatas of Deposit Coastal Coastal Secvnties Cantor Cantor Fitzgerald Texstar TexSTAR Texpool Local Gov't Pool FHLB Fed. Home Loan Bank TBILL Treasury Bill Samco Samoa Capital Duncan Duncan Williams Texpool TEXPOOL FGIC Money Mance! Fund Mutual Mutual Securities FGIC Federated Investors Trust 1 1 i Accrued Total P + I rt Inv. CUSIP Purchase Maturity Call Term Days Price Par Cost interest Total Pun. + Yield To Coupon Interest Mary Net of Total Cost Market % of TyCB N gag Oats Date (in days) remaining Per 9100 Vslue (Pim.. Onlii)mar Int. ;8 Mat'y Maturity Rate Purchased Discount Premium Fund Prem & Int Pur. of Investment Value Portfolio WAM FGIC N/A 100.0000 0.00 0.00 0.00 0.0015 508 • 0.00 0.00 0.00% 0.00 Texpool N1A 100.0000 57,549.26 57,549.28 57,549.28 0.13% 508 57.54528 57,549.28 57,549.28 0.09% 0.00 Texstar 111A 100.0000 452,942.68 452.942.88 452942.68 0.16% 508 452,942.68 452,942.68 452,942.68 0.71% 0.00 Subtotal 510,491,96 510,491.96 000 510.491.96 0.00 0.00 0.00 subtotal 510,491.96 510,491.96 510.491 .96 0.80% 0 00 Fund 50941/5W W Rata Stabilization Texstar N!A 100.0000 411,078.73 411678.73 411,676.73 0.16% Texpool NIA 100.0000 127,352.28 127.352.28 127,352.28 0.13% FHLB 313379FK0 05115/12 11/15/13 NIC 540 405 100.0000 1.000,000.00 1.000.000,00 4,500.00 1,004,500.00 0.30% 0.300% FNMA 3135GOGF4 12/06/11 12/06/13 12/06/12 720 426 100.0000 500,000.00 500.000.00 6,250.00 506,250.00 0.63% 0.625% Subtotal 2,035,031.01 2,039.031 01 10,750.00 2,049,781.01 509 411,678.73 411,678.73 411,678.73 0.64% 0.00 509 127,352.28 127, 352.28 127, 352.28 0..2015 0.00 509 1,004.500.00 1,000,000.00 1.000,590.00 1.5615 6.33 509 506,250.00 500,000.00 500.195.00 0.78% 3.33 0 00 0.00 0 00 subtotal 2.049,781.01 2.039.031.01 2.040.116.01 3.15/4 9.66 Fund 510-Dralnage /0E0 N/A 100.0000 0.00 0.00 0.00 0.00% 510 • 000 0.00 0,0035 000 Texpool N/A 100.0000 165,465,74 168.465,74 165 465,74 0.13% 510 168,465.74 168,465 74 168,465.74 0.26% 0 00 Twists( NIA 100.0000 186,291.34 186,291.34 186.291.34 0.18% 510 156,291.34 186,251.34 186.291,34 0.2995 6.00 Subtotal 354,757.08 354.757,06 0,00 354,757 08 0 00 0.00 0.00 subtotal 354,757.08 354,757.08 354.757 08 0 55% 0.00 Fund 511 -Drainage CIF FGIC NIA 100.0000 0.00 0.00 0.00 0.00 0.0095 511 0.00 0.00 0.00% 0.00 Texpool ISA 100.0000 604,767.56 604.767.56 804,797.55 0.13% 511 604,787.56 604,767.56 604,767.56 0.95% 000 Texstar N1A 100.0000 355,679.57 355,679.57 355,679.57 0.16% 511 355,679,57 355,679.57 355,679.57 0.56% 0.00 Subtotal 960.447,13 960,447.13 0.00 960,447.13 000 0.00 0.00 subtotal 960,447.13 960,44713 96044713 150% 000 Fund 512 -Drainage Reserve Texpool N/A 100.0000 (0.00) (0.00) 0.00 (0.00) 0.13 % 512 (0.00) (0.00) (0.00) 0.00% 0 00 Texstar N49 100.0000 0.00 0.00 0.00 0.15% 512 0.00 0.00 0.00% 0.00 Subtotal (0.00) (0.00) 0.00 (0.00) 0.00 0.00 0.00 subtotal (0.00) (0.00) (0.00) 0.00% 0.00 Fund 520 -Recreation Classes /010 N.1A 100.0000 0.00 0.00 0 00 0.00 0.00% 520 • 0.00 0 00 0.0015 0 00 Texpool NIA 100.0000 216,661.65 216,661.65 216,661.65 0.1390 520 216,661,65 216.661.65 216,661.65 0.34% 0.00 Texstar 439 100.0000 201,184.02 201,18.4,02 201,184.02 0.16% 520 201,184.02 201.184.02 201,184.02 0.31% 0.90 Subtotal 417,945.67 417,845.67 0.00 417,845.67 0.00 0.00 0.00 subtotal 417,645,67 417,845.67 417,845.67 065% 0.00 Fund 521 -arbor Dau FG10 N/A 100.0000 0.00 0.00 0.00 0.00 0.00% 521 - 0.00 0.00 0 00% 0.00 T88po01 NSA 100.0090 20,830.82 20.830 82 0.00 20.830.82 0.13% 521 20,830.82 20.830.82 20.830.62 0.03% 0.00 Texstar NIA 100.0000 19.08 19,06 19.08 0.16% 521 19.08 19,08 19.08 000% 0.00 Subtotal 20,649.80 20,849.90 0,00 20,849.90 0.00 0.00 000 subtotal 20,849.90 20,849.90 20.849.90 0.03% 0.00 Fund 530 -Softball World Operations FGIC N/A 1000000 0.00 000 0.00 0.00 0.00% 530 0.06 0.00 0.00% 0.00 Texpool WA 100.0000 62.06 62.06 0.00 62.05 0.13% 530 62.06 82.06 62.06 0.00% 0.00 Texstar N/A 100.0000 0.00 0.00 0.00 0.16% 530 - 0.00 0.00 0.00% 0.00 Subtotal 62.08 82.06 0.00 62.06 9 00 0.00 0.00 subtotal 62.06 62.06 62.06 0.00% 0 00 Fund 531-TSSC Debt Service FGIC N+9 100.0000 0.00 0.00 0.00 0.00 0.00% 531 - 0.00 0.00 0.00% 0.00 1945001 WA 100.0000 0.00 0.00 0.00 0.00 0.1315 531 0.00 0,00 0.00 0.00% 0.00 Texstar NIA 100.0000 0.00 0.00 0.00 0.16% 531 - 0.00 0.00 0.00% 0.00 Subtotal 0.00 0.00 0.00 0.00 0.00 0.00 0.00 subtotal 0.00 0 00 0.00 0.00% 0.00 Fund 532-TSSC Debt Reserve Texpool NIA 100,0000 100,033.90 100,033.90 0.00 100,033.90 0.13% 532 100,033,90 100,033.90 100,033.90 0.16% 0.00 Tessler WA 100,0000 501,177.59 601,177.99 601,177.99 0.00% 532 601,177.99 601,177.99 601,177.99 0.9446 0.00 Subtotal 701,211.89 701,211,89 0.00 701.211.89 0.00 0,00 0.00 subtotal 701,211.89 701,211.89 701,211.89 1.10% 0.00 Fund 540 -Tran Star Golf Course 1945001 ISA 100.0000 917.26 917.26 917.26 0.13% FGIC NSA 100.0000 0.00 0.00 0.00 0.00% Texstar NSA 100.0000 196.89 196.89 196.89 0.16% Subtotal 1,114.15 1.114.15 0.00 1,114.15 Fund 541-16GC Debt Service Texpool NIA 100.0000 128.69 128.69 000 128.69 0.13% 0.00 0.00 540 917,20 917.26 917.28 0.00% 0.00 540 - 0.00 0.00 0,00% 0.00 540 198.89 196.89 196.89 0.00% 0.00 0,00 subtotal 1,114,15 1,114.15 1,114.15 0.00% 0.00 541 12669 12569 128.69 0.96% 0.00 1 1 1 Investment Type LOGIC Local Gov't Pool Texatar Local Gov't Pool Texpool Local Gov't Pool FGIC Money Market Fund Inv. lea Texstar Subtotal FNMA Fed. Nat'l Mort. Assoc, FFCB Fed. Fan Credit Bank FHLB Fed, Home Loan Bank CUSIP Purchase Maturity Number Date QMg N/A Fund 542•T$GC Debt Reser Tessier NIA Texstar NIA Subtotal Fund 550 -Parks at Texas Star Operations FGIC NIA Texpool N/A Texstar NIA Subtotal Fund 552-TSSC CIP FGIC N/A Texpool NIA Texstar N/A Subtotal Fund 601 -Equipment Replacement FGIC N/A Texpool NIA Toaster NIA PHLS 3133XXLX3 02115/11 10/226/12 FHLB 313376MG7 12/29/11 06/26/13 Subtotal Fund 610 -Insurance FGIC N/A Texpool N/A Texstar N/A FHLB 31337971-7 04/25/12 FFCB 3133EAAY4 01130/12 FHLB 313376H87 02/25112 subtotal Fund 615•Risk Management FGIC N.+A Texpool NIA Texstar WA. Subtotal 07(15/13 07/28/13 02/28/14 Fund 705 -Dallas Stars Escrow Reserve Texpool NIA Fund 720 -Glade Park Phase II Escrow Texstar N/A FHLMC CD TBILL Fed, Home Loan Mort. Com Certificates of Deposit Treasury Bill Vining Coastal Samoa Mutual 1 I City of Euless Investment by Fund September 30, 2012 Institution Vining Sparks Coastal Securities Samoa Capital Mutual Securities 1 1 1 1 1 1 1 1 FSW First Southwest Cantor Cantor Fitgerald Duncan Duncan Williams Accrued Call Term Days Price Par Cost Interest Total Prin..- Yield To Coupon Interest wig tin days), ratmainin9 Per5100 V ue /Prin. Only!mat' Int. ($i Maly Maturity Rate Purolias0d PisCount 100.0000 32.46 32.46 32.46 0.1815 161.14 161.14 0.00 161.14 0.00 0.00 N/C 511 20 100.0000 251,789.80 251,789.80 251.789.60 0 00% 100.0000 1,086,568.03 1,086,588.03 1,086,568.03 0.00% 1,338,357.83 1,338,357.83 0.00 1,338,357.83 0.00 0.00 100.0000 100.0000 100.0000 100.0000 100.0000 100.0000 0.00 186,058.07 0.00 168,056.07 0.00 315,022.42 380,591.96 595,614.38 100.0000 0.00 100.0000 507,791.77 100.0000 679,585.99 101.1000 550.000.00 12/28/12 539 268 99.9500 1,000,000.00 NIC 04/28112 02/28/13 440 536 720 255 296 508 2,737.377.76 0.00 0.00 0.00 0.16% 185,056.07 0.00 106,056.07 0.13% 0.00 0.00 0.1646 166,056.07 0.00 156.056.07 0.00 0.00 0.00 0.00% 315,022.42 315,022 42 0.13% 380,591.95 380,591,96 0.1e% 695,614.35 0.00 695,814.38 0.00 0.00 507,791.77 507,791.77 679,585.99 679,585,99 555,050.00 15,839.24 565.839.24 999.500.00 4,500.00 1.004,500.00 2,742,927.76 20,339.24 2,757,716.99 0.00% 0.13% 0.16% 0.72% 1.375% 3,003.99 6050.00 601 556.785.25 559,053.99 550.455,50 0.87% 0.23 0.33% 0.300% 0.00 0.00 0.00 0 00 LOGIC Texstar Texpool FGIC Local Gov't Investment Coop. TexSTAR TEXPOOL Federated Investors Trust Total P + I ig Mat'y Net of Total COSI. Market % of Premium Fund Pram & Int Pur. of Inv@Stm6nt Value Portfolio WPM 541 0.00 subtotal 32.48 32.46 32.48 0.00% 0 00 151.14 181.14 161.14 0.0015 0.00 542 251,789.80 251,789,80 251,789.80 0.3915 542 1,036,568.03 1,086,568.03 1,088,568.03 1 70% 0.00 subtotal 1,338,357,83 1,338,357.83 1,335,357 83 2.09% 550 550 550 0.00 subtotal 552 552 552 0.00 subtotal 0.00 168,058.07 165.,056.07 0.00 166,056.07 156,056.07 0.00 315,022.42 315,022.42 380,591,96 380,591.96 895,814.38 695,514.38 601 - 0.00 601 507,791.77 507.791.77 601 679.585.99 679,585.99 0.00 166,056.07 0.00 166,056.07 0.00 315,022.42 380,591.96 695,614.38 0.00% 0.25% 0.00% 0 26% 0.00% 0.49% 0.60% 1.09% 0.00 0.00 0.00 0.00 0.00 0 00 0 00 0.00 0.00 0.00 0.00 0.00 0.00% 0.00 507,791,77 0.79% 0.00 679,565.99 1.0615 0.00 8.33 500.00 801 1,004,491.67 ' 999,508.33 1.000,350.00 11.5515 4.19 3,01232 500.00 8,050 00 Subtotal 2,748,554.87 2,745,940.05 2,738,184.26 4.29% 4.42 100.0000 0.00 0,00 0.00 0.00% 100.0000 585,408.68 585,408.88 555,408.68 0.13% 100.0000 179,455.69 175,455.69 179,455.69 0.16% 99.9900 1,000,00000 999,900.00 2,933.33 1,002,933.33 0.25% 0.24015 100.00 99.9500 1,000,000,00 100,0000 500,000.00 3.284.854 37 100 0000 100.0000 100.0000 999,500.00 3,300.00 1,003.300.00 0.25% 0.220% 24.44 500 00 600,000.00 4,000.00 504,000.00 0.40% 0.400% 3,264,284.37 10,233.33 3,275,097 71 24.44 600 00 0.00 0.00 827.338.92 627.338 92 843,589.72 843.589.72 1471,028.64 1,471,025 64 100.0000 1,421,048.08 1,421,048.08 100.0000 511,305.59 511.305.89 0.00 0.00% 627,338,92 0.13% 843,689.72 0.16% 0.00 1,471,028.64 83,911,850.20 63,944,588.20 257,898.65 1,421,048,08 0.13% 511,305..89 0.00% 64,169,746.65 0.00 0 00 610 610 510 0.00 585,408.68 585,408.68 179,455,69 179,455.69 0.00 555,405.68 179,455.69 0.0096 0.92% 0.28% 0,00 0.00 0.00 510 1,002,933.33 999,900.00 1.000,320.00 15615 4.46 610 1,003,275.56 999,524.44 1,000,000.00 1.5815 4.63 610 504,000.00 500,000.00 500,455.00 0.7815 3.97 0,00 subtotal 3,275,073.27 3,254,268.51 3,265.639,37 5.10% 13,05 615 615 615 0.00 subtotal • 0.00 827,338.92 627,338.92 843,689..72 843,889.72 1,471,028 64 1,471,028.64 0.00 627,336.92 843,689.72 1,471,028.64 0.00% 0.98% 1.32% 2.30% 0.00 0.00 0.00 0.00 705 1,421,045.08 1,421,045.08 1,421,048.06 2.22% 0.00 720 511,305.59 511.305.89 511,305.89 0.50% 0.00 13,908.97 4,900.00 37,636.00 64,:118,201.88 63,958,495.17 63,954.544,24 100.0015 185:66 1 1 1 1 1 1 1 1 } 1 1 1 1 1 1 1 1 1 I City of Euless Irateetmenl by Fund June 30 2012 hneatatnient Type Institution LOGIC L0001 GOA Pool FNMA Fed. Nati Mort. Assoc. FHLMC Fed Home Loan Mort. Corp Vining Vining Spancs FUN First Southwest LOGIC Local Govt Investment Coop TOt4tar Local 0151 Pool FFCB Fe4. Farm Crede Bane CO Certificates of Deposit Cantos Coastal Sesurifies Can10r Career Fiugeral0 Texslar TexSTAR ¶010001 Local Gov't Pool FHLB Fed. Nome Loan Bank TRILL Treasury Bill 50rotet Same* Capital Duncan Duncan Williams 190500! TESPOOL FG10 Money Market Fund Mutual Mulual Securities FGIC Federated Investors Trust Accrued Total P * I Inv, CUSIP Purchase Maturity 0011 Term Days Arne Par Coat Inter/MI Total Pon • %eek! To Coupon Interest Seller Miley Net Or Total Cnsl Market %af jyg Number DAL QB5G Wm fin Carel remaining Pe131150 Value (Ann Ontyl & mat'v IrilLtga0 901.6rt0.0 Haig Rurol ed L5L Dismal Premrum Fund Prem 81n1 Pur 0". In•en01norlt Value p? WAM Fund 10103eoere1 Fund 95172 N/A 100 0000 0.00 0 00 000 0 0008 072C05 101 - 000 0 00 00038 0 00 Texpool 94/33 100 0000 16,947.91 16,947.91 16947.91 014% Texpool 101 16.947.91 18,94791 10.947.91 003% 000 1690103 /4/A 1000000 13,439.56 13,43556 13,43958 0 14% 8e4303 101 13,43556 11429.58 13.43959 002% 008 FFCB 313312705 01114'11 0711002 NIC 540 10 1000050 1,000,000.00 1,000,00000 7,50000 1,007,500:00 05056 0500% FSW 101 1,007,50001 1,000.000.00 1,000,090.00 1.55% 015 1VA5 03059E4399 01/05111 07115112 NIC 550 15 99.0134 915,000.00 905;57361 9,02739 924,027.39 065% Duncan 101 924.02739 905,972.61 914,73465 140% 0.21 FFCB 313310740 0102601 97125112 NFC 540 25 1000000 tows= .00 1,000,000.00 7,50000 1.007,500 OD 0.50%. 0500% Duncan 101 5001,50000 1,000,000.00 1,00028000 15S% 039 9341.8 3/3375005 0610601 0508012 NIC 360 36 100.0510 1,000,000.00 1;500.510.00 2.50050 1002,50000 015% '0250% FSW 510 38 101 1.001990 00 1,000,51050 100605000 155% 059 51-9.5 313378J42 1211901 0649113 NIC 540 349 100.0300 1,000,000.00 9,000.00050 6.000.00 100600090 04008 0400% Duncan 101 1,006.000.00 1000.00009 1,001.000.00 155% 541 FHLB 313370952 0100/12 07130113 NIC 540 390 1000100 1,000,00000 1,000100.00 4.20000 1,004.20000 027% 0.280% Cantor 1000D 101 1,004,100.00 1,000,10000 999,747.00 155% 8.04 FHLB 3133761/49 02/037/2 00109113 NAC 542 395 100.0000 1,009,000.00 1,000000.00 3.763.89 1,003.763.69 0.25% 0.250% Mutual 101 9003,783.85 1,000,00000 999,39700 1.55% 6.12 FNMA 313500004 0940611 05/06/13 09109112 720 428 100.0000 925,00500 925.00000 532500 033.32500 0451' 9450% V,nm4 101 FNMA 3130802413 01719112 09030113 NAC 811 450 101 4060 1.300,00000 1014,06000 22.500.50 1,02250000 029% 1.125% 3.406.25 43,3305 14069.40 101 933.32000 925,00500 925.42550 14396 610 1,005033 75 11,017,468 25 1.009.92000 158% 7.09 FFCB 3133E+6%5 02/98012 11001/13 05/01112 823 491 09.0750 1,000,00000 999.75000 4,37500 1,004,37500 026% 025095 4981 Mutual 25000 101 1,004,326 39 990,70581 1500,030.00 155% 745 FNMA 31350200F4-2 92096111 12076/13 12+06/12 720 516 1000000 600,00000 500,05000 8,25000 506,250.00 063% 0625% 50u104li 101 506250.510 500,00000 500.87500 077% 400 941540 313409350340 0221312 02121/14 02721713 729 591 1000000 1,000,000.00 1,000,00000 9,00000 1.009.000.00 045% 0.450% 020100, 101 1,009.00000 1:000,00000 9,001,16005 155% 915 Subtotal 11,370,38749 1,375,750 10 90,941.28 11.461,326.77 3,454 86 250.00 14.67000 subtotal 11,443.203.91 11.37923486 11,383,15884 1763% 5270 Fond 10243ansral Fund Emifgarncy FHLMC 313402601 11/29311 11/29/13 11129/12 720 509 1000000 500,000.00 500000.00 5,00000 585.000.00 D50% 05001' FSW 102 50500000 500,00000 500,585.00 077% 394 Fond T03-G0Mral Fund Con0ngency Texpool N/A 100.0000 0.00 000 0.00 014% Texpool 103 - 000 0.00 0:00% 0.00 T518tar N/33 100:0000 0.00 0.00 000 014% Tesorur 103 - 000 000 000% 000 FHLB subtotal 3133701101 0411512 10/15713 34/C 539 485 100.0000 500.000.00 500:00050 2,620.15 502,620.15 0.35% 0.35096 Mutual 103 500000.00 500,000 00 2,620 15 502,820.15 0 00 0 00 0,00 502.629.15 500000.00 500.12000 0.77% 3.60 502,620.15 500000 00 500,120 00 0 77% 3 60 Fund 2014401Nt1801'4 F0/C WA 1000000 000 0.00 000 0.00% FGIC 201 - 0.130 000 0.00% 0.00 Texpool 10133 1000000 79,258.79 75,256.79 75 255 79 0.14% 1e05951 201 75,299 79 75,250 79 75250 79 01246 000 Texwr NFA 1000000 15,190 31 15,139.11 15 139 11 0.1408 Texstar 201 15.,139.11 15.139.11 15,13911 002% 0,00 subtotal 90397.90 90,397.90 0.00 90.307 00 0'.00 0.00 0 00 105t591 93,397.90 50397 90 90,397 90 0.14% 030 Fund 202-J enn4I o Case T9po35 WA 100.0000 75,148.97 75,14897 75,146.97 0.14% Texpool 202 75,14597 75,146.97 75.146.97 012% 0.00 (1,010451 75,148.97 75,146.97 000 75,146.97 0.00 000 0.00 5051030) 75.14697 75,14697 75,146.97 012% 0.00 FOrld 210 -Half Cant Operatic/0S Tet®ool 04/0 FGIC WA Te1{61a1 9/0 Subtotal 100.0000 515,912020 515,920.29 0.00 515.920.29 014% Texpool 210 515,92079 515,920.29 515,92029 0.80% 000 100.0000 (0 001 (a Da) 000 10.001 000% 5GIC 210 1000) (0.00) (0.00) 000% 000 1000000 578,316.09 576,316.09 576,356.09 01458 Tekatar 210 576,315.09 576,316.09 576.31609 0.89% 0.00 1092.236.30 1,092.238.38 005 1.092.236 30 000 005 0.00 subtotal 1.092.236.38 1.092,23838 1,092,230.38 1.69% 0,00 Fund 211+411 Cent Ra8(TVe T305003 NMA 100.0000 0.00 0.00 0.00 000 010% 1e55941 211 000 0.00 0.00 0.00% 0.00 6031 WR 100.0000 11,540.82 11,54062 000 11.54592 0.14% 7e0705l 211 11,540.62 11.540.82 111,540.62 0.02% 000 FHLMC 313403100 0304112 03114/16 03314014 1440 1334 1000000 90000000 900000.00 39.000.00 936.00000 100% 1,00038. 8037 211 936.00000 900.000.00 957,551.00 1.39% 18.80 51,0100) 511640.52 911,540.62 36,000.00 947,54062 0.00 0.00 0.00 947.540.62 911540.82 919591.82 141% 18.60 Fund 220 -Crim e Control and Pre on 410372 N/A 100.0009 0 OD 0 00 100 0.00 00096 FOC 220 • 0.00 000 000% 050 Texpool 91/33 100.0200 50,32565 50,925.85 500 50825.65 0.34% 1909501 220 50,525.85 50,925.85 50,825.85 0.08% 0D0 Texatal N/A 100.0900 56.119.53 55119.53 55.119.53 014% 7e0030, 225 55,11953 55,119.53 55,119.53 0.09% 0.00 505{0(x1 105,945.35 195,945.39 9.0D 105,545.38 000 000 000 subtotal 105,945.38 105.945.39 105,94536 0.16% 000 Fund 2304103ce DEA (Fedefal l FOC WA 100.0000 0.00 000 1000 0,0048 FDIC 230 - 0.00 '0.00 0.00% 0,130 Texpool NIA 100.0000 55671 55671 0.00 556.71 014% Texpoel 230 558.71 556.71 556.71 00018 0.00 Texslar N/A 100.0000 10,502 12 10.502.12 10,502 12 0.14% Tuna,' 230 10,502.12'. 10602 12 10,502.12 0,02% 000 Subtotal 11,058.83 11,056.53 000 11.059.03 0.00 0.00 0.05 5000181 11,00083 11,056.83 11,058,83 002% 000 Fund 231-Po6ca DEA 951tar3 96(72 WA Texpool WA 730038 N/A Subk441 100.0000 0.00 0.00 000 0 0154 FGIC 231 - 0'90 500 000% 0110 1000000 114,893.84 114,653.84 000 114,693,84 0.14% Texpoot 231 114,693.64 114,693.04 114.893.84 0.18% 0.00 100.0000 30,184.72 36194.72 30,164.72 014% Texstar 231 30,18472 30,164.72 30,184.72 5.05% 000 144.878.58 144,678.56 0 CO 144578.58 000 0 00 3 00 subtotal 144.078.56 144,678.56 144,870.58 0.221' 0.00 Fund 240090 'Benin Fund FOC 5133 100.0000 0.50 0.00 0.00 5.00% 950 240 - 050 5.00 5.0018 000 Tespool I41A 100.0500 583,466.14 583,466.14 583,46814 0.14% Texpool 240 563,486.14 563,496..14 563.465 14 0.90% 0.0D 'roster NIA 100.0000 2,558,399.90 2.056,399.90 2,055,399.90 0.14% Tekatar 240 2,058,399.90 2958,399.90 2,055399.90 319%. 0,00 I I I I I 1 I I 1 1 1 1 1 1 1 1 City a1 Euless Investment try Fused June 30. 2012 teaeattnen1 TYPO institution LOGIC Local G0/1 Pod FNMA Fed. Nat1 Mor. Amsoc. FHLMC Fed Home Loan Moll Corp 51ning Vinmq Sparks FSW Fast Southwest LOGIC Lotat Gan InveAnent Coop Tenter Local OW! Pool /FCB Fed. Farm Croda Banti 017 Cerle48tes 5/ Deposit Coastal Coasta15ecuratea Cantor Cantor Fragerald Tesla: TeaSTAR Teopoo1 LaoalGo✓t Pool FHLB Fed Hance Loan Bank TBILL Treasury 8111 5anteo Samco Caplan Duncan Duncan W Ikons Texpo0t 7E0000L FGIC Money Market Fund Mutua! Mutual Seounlies FGIC Fedetaled investors Trull Accrued T01aI P o 16 For CUSIP Purth30! Maturity Call Term Days Poce Par Coal Interest Total Prin -. Yield To Coupon Interest Seiler Maly Net of Total Coat Market %o1 IygE 1490150! WI. EaUs Nut+4. riL_41yyy, rernainirq pee 0100 Y�iy,; Won. Onlv1uo0I !Mit 3/81'14051 y EirloI Purchased DAL DIaruanl Prempro Fund P. I Pur. 01 InvestmentrL5 P., VaLtz 0AM FHLB 313378W49 04113112 04/12113 WC 360 282 1000000 1,000,00000 1.000.00000 2.40000 1:002,40000 0.24% 0.240% Cantor 240 1,002.40050 1,003,000.50 990820.00 155% 4.37 79115 3133787(30 04/16/12 0411.6113 WC 360 288 150:0000 500,000.00 500.00000 1,25000 501,25000 025% 0250% Cantor 240 501.25000 500:000.00 499.942.00 077% 222 F008. 313310306 12/30111 0872013 03/10112 530 350 99.9750 500000.00 499.875.00 2,100.00 502,10000 0.30% 0.280% 38.89 Coastal `2500 240 502,06115 499.913.69 500,02000 077% 2.71 FHLB 3133790916 05121112 06111713 11121412 390 351 1000000 1,000,000:00 1000.000.00 2.708.33 1,00270633 0.25% 0.250% FSW 240 1,002,708.33 5,000.00000 999.62500 15546 544 FHL8 313379978 06128/12 06125/13 190 360 356 1.00.0000 1,000,000.00 5,000,00090 2,40050 1,002.40000 024% 0.240% Coastal 240 1.002.400.00 1,000,000.00 999,492.00 155% 555 FH8.6 313375E09 03/09/12 09/197/3 N/C 540 429 1000000 1,000,900.00 1,000,000.00 4.85000 1.004.650.00 031% 0350% Ducean. 240 1004550.00 1,000.00000 999,90400 155% 665 FHLB 3133784/25 04/18/12 10118713 51/0 540 466 100.0000 1,000.000.00 1,000,000 00 5,62503 1005,825.00 038% 0375%. 00a154,1 240 1,005,62500 1000,00000 1.009.55000 155% 725 /PCB 2133E965/9 02/07/12 02103/14 09103712 716 573 99.9500 1,000,00000 599,50030 6.61833 1,006.516.33 036% 0330% 5500 FSW 50000 240 1.006,58333 999,555,00 1000,05000 155% 867 Subtotal 9.841,86605 9,641.24105 27.75167 5,669.61771 93.89 62500 0.00 subtotal 9,869,52382 9,601,33494 9,641.26905 1493% 43.04 Fund 301 -Developers Escrow FGIC WA 1000000 0,00 0.00 000 000% FGIC 391 - 0.00 0.00 0.00% 000 Telmool 004 100.0000 672,591.07 672.695.07 672591.07 0.14% Texpool 301 672,60107 672,69107 672,691:07 104% 000 Texans/ WA 1000000 503,275.08 503.275.06. 503,275.08 014% Tooter 301 503,275.08 503.27008 503,27506 078% 000 FFCB 313310409 05/1112 12/27713 12/27/12 586 537 100.0000 10100000 581,000.00 1,701.40 182,701.40 047% 0470% 316.65 00ncart. 301 102.39.475 161358.05 161,293.22 0.28% 1.51 Subtotal 1,356.56615 1,356.986.15 1.70140 1,358,68755 315.05 000 0.00 subtotal 5,358,350.90 1,357,202.60 1,357,255.37 250% 151 Fund 358.68aatl CLP FGIC NSA Te10004 14/0 Tenter N/A 100.0000 0,00 000 000 000 0.50%. FGIC 305 - 0 00 000 00091 000 100.0000 1,033,305.84 1,033.30584 000 1,033,305.84 0.14% TEXPOOL 305 1,033,305,84 1.033,305 84 1,033,305.84 15074 500 100 0000. 1,050,76824 1,05078824 0.00 1,050.788.24 014% 748star 305 1,050,788.24 1,050788.24 1.050,766.24 16366. 000 FHLMC 3134014.04 02/15/11 12/27112 1440 672 177 100.5060 500,000.00 502.530.00 11,00000 515,00000 083% 110591 .733.33 Ssmco Subtotal 2.584,094 09 2.586.624.08 11.00000 2.555,094 08 73333 253000 305 507,736.67 503,263.33 502,125 00 0 7891. 5 30 000 2,530.00 subtotal 2.59583075 2,567.35741 2.586,219.06 4.01% 136 Fund 310-14701 Cant CIP FGIC WA 100:0000 000 0.00 0.00 0.00 000%. FGIC 310 - 0.00 000 000% 030 Tee¢Dd NIA 100.0300 301,142.29 391,542.29 391,14220 014% Texpool 310 304.14229 301,14229 301.14229 '047% 030 Tex4tar 54/4 100.0000 277.72856 277,728.66 27772666 014% 1e5a181 310 277.72856 277.7206'6 27772866 043% 000 FHLMC 3134034455 02/27/12 03%21144 WC 744 621 99.5200 1.000000 OD 998,200.00 750000 1,007.500.00 0.399% 0300% 175.00 Mutual 1,900-00 310 1,007,325.00 996,37500 996.45500 155% 960 Subtotal 1,575,870.95 1,577,07095 7.500.00 1,558,37095 17500 1,00000 0.00 subtotal 1,508,19595 1,577.245,95 4577,325.95 2.44% 960 Fund 32043enaral CIF 7e15101 WA 1000000 550,812 55 550.812.55 550,85255 014% Teapaol 320 550.812.55 550,812 55 550,912.55 085% 0 00 Tee:star N/4 100.0000 265,528.81 265.525.61 265.525,61 0.14% Tooter 320 285,528.61 285,528.51 265,528.61 041% 000 FHLMC 31340254.7 08108/11 05406/13 05/08012 720 398 100 0000 1.000000.00 1,000,00000 12,50000 1,012,50000 X063% 0.525% 009,/ 320 1,012,50000 1,000.00000 1,000.39000 155% 617 Subtotal 1.816,341 17 1,816,341.17 52,500.00 1828:64157 009 000 000 subtotal 1,420,641 17 1 616,341 17 1,816,73117 281% 617 Fund 321-RadWNOPment CIP 7399004 WA 100.0000 275,553.52 275.95352 275,653.52 0.14% 1ekpoe1 321 275.553.52 275.653.52 275,65352 043% 000 Subtotal 275,553.52 275,653.52 0.00 275,853.52 000 000 000 subtotal 27555352 275,653,52 275,653 52 04374 000 Fund 326.Pellce Faculty GIP FGIC N/A 100.000 0.00 000 0.00 000 000% 0G10 325 - 0.00 000 0.00% 000 Imam WA 1000000 100,615.74 100,61574 0.00 100,61574 014% Teoarar 325 100.615...74 100,61574 100.65574 0.1614 000 Subtotal 100,615.74 100,615.74 000 100.61574 000 0.00 000 Subtotal 100,61574 100,61574 100,61574 016% 000 Fund 330 -Car Renal CIF FGIC NIA TexpooI ISA Te>aW NSA uSubtaK1 Fund 401438Dt S400iu Terpool Ilii/ FGIC N/A Teletae N/A Subtotal Furl 402 -Star Center Debt Smlce Terpool Toaster Nit Subtotal 100 0003 0.00 0.00 0 00 0.0051 FGIC 330 - 000 0 00 0 00% 0.00 100.0000 292,879.45 292,97945 292,97945 014% 7ex904/ 330 292,97945 29797945 252,97945 045% 000 100.0000 710,62157 710,52157 71062157 014% 1500584 330 710,621.57 710,62157 710,621.57 1.1091 0.00 1,003,601.02 1,003,601.02 0.00 1,003,601 02 0 00 0.00 0.00 subtotal 1.003,601.02 1,003501 02 1003,601 02 1.5591 0.00 100.0000 557,07127 557,071.27 557,07127 014% Smoot 401 557071.27 55707127 557.071 27 0.6691 000 100.0000 000 0 00 000 0:00% /040 401 - 0.00 0.00 0.0014 0.00 10000M 0.00 '0.00 0.00 014% Te15t4r 40/ - 0.00 0.00 000% 0.00 557,071,27 557,071.27 000 557,07127 000 0.00 000 845.40411 557,071.27 557.07127 557,071.27 0.88% 000 100.D000 558.505.72 555.905.72 558,905.72 0.14% Tenpaol 402 555,50572 558,905.72 558,905.72 0.8791 0.00 100.0000 0 D 000 0.00 0.14% Teestar 402 0.00 000 0,00% 090 558,9(572 555,005.72 000 558.905:72 000 000 000 500l0/14 558,905.72 558,905.72 556.90572 0,6791 000 Fund 0014+1x141 and Wasterwetee LOGIC N/A 100.0000 70.60 70,50 70.60 025% 100/0 501 70.60 70.60 70.60 0.00% 0.00 0050 N/A 100.0000 0.00 0.00 0:00 0.0094 FGIC 501 - 0.90 0.00 0.00% 0.00 TM41001 WA 100.0000 1.052,414.20 1.052,414.20 1,052,414 20 0.14% TE%000L 501 1,052,414.20 1.052.414.20 1,052,414.20 1.5391 0.00 Tonto 14/A 100.0000 959,514.00 988.514,00 565,514,00 0.14% Texslor 501 989,514.00 909,514.00 989,514.00 1.53% 000 7114.E 313374237 0745/11 07/25112 NIC 360 25 99.9957 500,00000 499,078.50 1,25900 501.250.00 0.2691 0.25014 3.47 FSW 21.50 501 501,248-53 499.55197 500,220.09 0.77% 019 FI4L8 313.379.466 05103112 05/03113 4645 360 303 100.0000 1,000.000.00 1,000,000.00 2.20000 1,002.200.00 0.2296 0.220% Mutual 501 1,002,200.03 1,000.000.00 995,576.00 1.55% 469 01400 313370E137 1123111 95723/13 11723112 540 323 100.0000 1,000000.00 1,000000.00 5,250.00 1,005,250.00 0.35% 0.35096 580140 501 1,005,250.00 1,080.000.00 1.000540.00 1.55% 5.00 FNMA 313980344 02/03/12 09/03113 NIC 565 123 101.2520 1,000,000.00 1.012,520,00 21,000.00 1,021,000.00' 0.25% 1.050% 4,520.33 Vinrp 12520.00 505 1,003,959.17 1,017.040.83 1,000,560,00 1,58% 6.66 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 I City of Euless Investment by Fund June 30. 2012 Inlruan.nt Typo Institution LOGIC Local GOYt Pod FNMA Fed. Nat'l Mon Assoc FHGMC Fed Homo Loan Mart Corp Vining Vining Sparks FSW First Southwest LOGIC Local 040 Investment Coop 1.0691 Local 0811 Pool FFCB Fed Farm Credit Bank CD Certificates of Deposit Coastal Coastal Secontee Cantor Cantor F11agerald Texal9r 770010/ Texpool Local Gov't Pool FHLB Fed Home Loan Bank TBILL Treasury 9II Sanwa Samco Capital Duncan Duncan Williams 770900'. TE%POOL FGIC Money Markel Fund Mutual Mutual Securities FGIC Federated Investors Trust Accrued Total P a I a Ins CLISIP Purchase Maturity 12401 Term Deno Price Par Cost Interest Total Pim. * YIMd To Coupon Interest Seller Mary Net 81 Total Cost Markel % FLmear /Adam/ remelt Pet 510Q V41ue lPrin OnFvl @Mario 50,,96M5jr.Aly Malteds, lagg1 Purchased ezil. DIscaunlP�amium Fryrl@ Pawn B. IM Pur. OTlneellmenl Value Portloyo 0901 FFCO 3133EAAP3 01027/12 0124/14 04/17012 720 564 99,9750 1,000,000 50 999,750.00 7,000.00 1,007,000 00 036% 0.35094 Coastal 250 00 591 1.007,000:00 999,750.00 1.000,050 00 1.55% 6 73 FFIL*40 3134G3L06 04705912 02127114 NIC 682 597 1000000 775.000.00 775.000.00 6086.98 781,086 AR 037% 9.37655. 50125 Vining 501 780,50573 775.581 25 774,921 73 120% 7.17 0488160 7.316.96$.80 7,329,24730 42,768.98 7,358,78578 5,105.55 27150 1252000 suet0€81 7.342,160 23 7,334,35205 7.325.666.53 1136% 3245 Fund 50248atar EWas0.water CIP FGIC 14/4 1000000 0.00 000 000 000% FGIC 502 • 0.00 000 000% 0.00 1'eipoo1 8/4 100.0000 971,317.86 974.317.65 971,31766 014% Texp001 502 971.31766 971,31746 971317.66 150% 000 Texstar NIA 100.0000 157,703.86 157,70386 157,70306 014% remota, 542 157.703.66 157,703.06 157 703.86 024% 000 711LMC 3134011917 04404911 11/26/12 NIC 592 140 99.0250 500,000.00 499.12500 5,150.00 505,15000 0.62%. 0.515% 915.56 597000 87500 502 504 234.44 500,04056 500,605.00 077% 113 FHLMC 3134103202 01112/12 01/18/14 6/12 717 549 1031810 1.000,00000 1,001 810 00 9,00000 1009,00000 03056 0450% 3750 Samco 1819,00 502 1,007.152.50 1,001,847.5°3 1,001,320.00 155% 852 Subtotal 2,829,02152 2.628.95652 14'150.00 2,443,17152 95906 07500 781000 subtotal 2.640,40546 2,630,909.58 2.630.94652 406% 9.65 Fund 503•WEY4W Met Rasa we Texpool 14/4 100.0000 304,670.92 304,670.92 000 304.67092 0.14% TeopoO, 503 304,670.92 304570.92 304,670.82 0.4715 000 Texalar N/A 1000000 000 0.00 0D0 0.14% Texatar 503 - 000 0.00 000% 000 Subtotal 304,67092 304,670.92 0.00 304,670.92 000 0.00 000 5501008/ 304,670.82 304.67092 304.670.92 047% 000 Fund 904•$enrlee Cerdef Texp004 NO, 100.0000 000 000 0.00 000 004% Te8p001 504 - 0.00 000 0.00% 009 7.08(40 04/4 100,0000 000' 0.00 000 014% Taxsrar 504 000 000 0.00% 0.00 Subtotal 0.00 0100 0.00 000 0:00 000 000 subtotal 0.00 0.00 0.00 000% 000 Fund 585-Wwr Impact Fans Te1p001 NIA 100.0000 705,65615 705.65615 000 705,654.15 0.14% Texpool 005 705.05615 705,650.15 705,856.15 169% 00D FGIC N/4 100 0000 000 0OD 0.01 0,00 000% FGIC 505 - 0.00 090 0.00% 000 Ts001 0414 1000000 5.857.52 5857.52 5,857.52 014% 770,400r 535 5.65752 5,85752 5,857.52 001% 000 FAMCA 01315P0084 96/06/12 12706113 12706112 540 516 900.0000 1,060,000 OD 1,000,000.00 5,625.00 1,005,62500 03015 0.375% Comm' 505 1,005,825.00 1,003.00000 1,000,00000 1.55% 7.99 5u000081 :711,51366 1,711.513 66 5.62500 1,717,13B:66 000 000 000 subtotal 1.71713068 1,711 513 66 1,711,51368 265% 799 Fund $07-WEVY14 Emreg.ncy Fund Taxpoel 14/4 100.0000 500.07000 55000000 0.00 500.000.00 014% Texpool 507 500000.03 500,00000 500.000.00 0.7754 0.00 T69514r 7414 100.0000 0.0D 0.00 0:00 014% 7e510e' 507 - 000 0.50 000% 000 Subtotal 500,00000 500,003.00 000 500,00000 000 000 000 subtotal 503.00000 504000.00 500,00000 0.77% 0.00 F1810 508 -Wastewater Impel Fees FGIC NA 1000100 000 000 0.00 0.00% FG1C 506 - 0(10 500 0.0096 000 Texpool NIA 108 0000 57,528 78 57,529.78 57.529.78 0.14% Texpaol 505 57.529.7e 57.529 78 57,529.78 0.09% 000 Te8518; 8414 100.0000 502,767.06 502.76708 502,767.06 X014% 1e70001 506 502,767.06 502,78706 502,767.06 078% 000 Subtotal 560,28684 560,296.84 0.00 580,296.84 0.00 000 000 subtotal 560.29584 560.396.84 560,29884 067%. 0!00 Fund 009.06845/8 Rata $5061114901441 7e00er WA 100.0000 461,51806 487,518.06 451.518.06 0.1d% Texalar 500 461,516.06 861,510.06 460,518.06 071% 000 Texpool NPA 1050000 127,300.12 127.308 12 127.309.12 014% Texpool 509 127,309.12 127.300 12 127.309.12 02014 000 FHLB 313379960 05915112' /1115113 NIC 540 496 100.0009 1.500:000:00 1000,000 00 4,500.00 1,004,500.00 030% 0.300% Sameo 509 1,004,500.00 1,000000.00 999,414.00 1,5544 767 FNMA 3135G0GF4 12/5911 12708/13 12400r12 720 515 100.0000 500,000.00 500,000.00 6,250.00 506,25000 0.83% 0.82555 FSW 509 508,250.00 500,900.00 508075.00 07755 4.00 5,0104.? 2,006.627.10 2.008,827.18 10,750.00 2,098577 113 000 000 000 16018101 2.099.57716 2,088,62718 2,089.116.10 3.24% 11.66 Fund 810-Dr.InaOe F080 WA 105.0000 0.00 000 000 0.00% 0010 510 . 000 000 0.0096 000 Taxpool 44/4 100,0000 116,455.64 115,408.64 118.40664 0.14% Texpool 510 118,408.64 118408.64 118,408.84 0.10% 000 Texstar NIA 1000800 106,223.83 486,223.43 106.223.83 014% Texstar 510 166,223:93 188223.03 186,22383 0.29% 000 Subtotal 504.63247 304,63247 000 304,632.47 0OD 0.00 0.00 subtotal 304.452.47 304,63247 304632.47 0,47% 0.00 Fund 511-01.I0g• CIP FGIC t414 100,0000 0.00 0.00 000 500 005% F010 511 - 0.00 0.0D 0.00% 000 Tel9801 44/0 100 0000 504.562.50 504,562.60 504,562.60 0.1456 7407001 511 504.582.60 504562.60 504.562':60 0.78%. 000 Tew,elar N/A 1000000 355,55067 355,55067 355.550.67 0.14% Tamar 511 355,550.67 355,55007 355450.67 0,55% 0.00 Subtotal 800,11327 060,113.27 0.00 860,113.27 0.00 000 000 subtotal 880,113:27 660,113.27 86011327 1.33% 000 Fund 512 -Drainage Reserve 74x7091 0414 100.0000 7000) 10.004 0.00 (0.00) 014% Texpool 512 (0.004 (0.00) 10.001 000% 0.00 Terme WA 100.0000 0.00 0.00 0.00 0.14% Texstar 512 0.90 000 0.00% 0,00 Subtotal (0.001 40,007 000 (0004 000 000 0.00 su640001 1000) (0004 10.004 0.00% 0.00 Fuad 520-Retre.8on Classes FG1C NIA 1000000 0.00 00D 0.00 0:00 000% F000 520 - 0.00 000 00055 0,00 TElpod NIA 100 0000 166,58822 166,588.22 165,588.22 0.14% Tarpon; 520 156,588.22 168,586.22 166,588.22 0.24% 000 TaxaTar WA 1000000 201,111.11 201,111.11 201,111 41 014% Texstar 520 201.111.11 201,111.11 201,11111 031% 5:00 Subtotal 367,699,33 367,699.33 0.00 367,69933 0.00 0.00 0001 subtalar 30.7.699.23 387,09033 367699,32 057% 0.00 Fund 501 -Arbor Dare FGI0 WA 1000000 0.00 0.00 0.00 000 000% FG1C 521 0.00 0.00 0.00% 0.00 7419001 WA 100.0000 20,523.70 20,823,78 0.00 20.82376 0.14% Texpool 521 20.623.76 20,523.76 20,823.76 0,03% 0.00 Testator WA 100.00(0 19.07 19.07 1.9.07 0.14% Texstar 521 18.07 19.07 18.07 00046 '000 Subtotal 20.642.83 20,642.83 0.00 20,842.53 0,50 0.00 0.00 1461088 20,84283 20642.83 20,842.83 0.0396 000 1 I I I 1 I I 1 I 1 1 1 1 1 1 I 1 I 1 City or Euless Investment by Fund June 30, 2012 Investment Type lostlhdlo6 LOGIC Laced Govt Pmol FNMA Fed. Haft Mart Assoc, FHLMC Fed Home Loan Mon. Corp Vining Vlnrrp Sparks FSW First Southwest LOGIC Lota1 Gov't Investment 0080 Tenter Local Govt Pool FFCB Fed. Farm Croon Hank CD Ceti -mates of Oepos4 Coastal Coastal Setur,tiea Carter Cantor Fi¢g81ald Texatar TexS7AR Texpool local Gov't Pool FHLB Fed Home Loan Bank TBILL Treasury 5dl 5amem SamoO Capital Duncan Duncan 05511404 Terpoo1 TEXPOOL FGIC Money Market Fund Mutual Mutual Securities FGIC 1reoerated Investors Trust Accrued Total 0 41 Irw, CU510 Purchase Maturity 044 Term Days Pnce Par Cost Interest TotaI. Pnn . Yield To Coupon Interest Seller Maty Net of Total Cost Market % of 73071 Number. Q635 QBIe. Q63t fin days] 7EI116jf590 ter $160 ...sue LP99 0nh/1 malty wit @p Mary Matunls MI Puroha5al Inst, Discount Premium Fu,, Pram 5101 Pur o1' Investment Value POdfo1W WAM Fund 530So(Eall Wedel Operations FGIC 1VA 160.0000 000 000 Texpool 1./4 1000000 6204 62.04 Texst81 N14 1.00.0000 006 0:00 Subtotal 6204 6204 Fund 631-7550 Dern 5414104 FG1C NSA 1000000 0.00 000 Texpo0l NIA 100 0000 000 0 00 Te0lar N/A 100.0000 0.00 0.00 Subtotal 0.00 000 0600 0 00 0 00% FGIC 530 - 0 00 9 05 003% 0 D 5.00 62,04 0.14% TexpOOl 530 62 Oa 6204 6204 0.00% 000 0 00 0 14% T905110 530 000 0.00 0.0014 0 00 000 6204 000 000 000 au0651. 62.04 6204 62.04 000% 000 0.00 0.00 0.00% FGIC 531 000 0.00 000% 0D0 0.00 000 0 14% Texpool 531 0 00 000 0Oft 0.00% 0 CO 0.00 0 14% 1e9s181 531 000 0.00 0 00% 0 50 0 00 0 00 0 O0 '000 D.OD subtotal 0.00 0 00 000 0.00% 0.03 Fund 532.1555 Debt Reserve Te0501 NSA 100.0000 600,960.12 600.960.12 600.96012 0.00% Texstar 532 600,960.12 600,96012 60090012 0,93% 000 Subtotal 60096012 000.96012 000 600.96012 000 509 000 14240181 600.960.12 600,960.52 600.95012 0:9354 000 Fund 540 -Texas Star Golf Course 7e69001 NSA 100 0000 916.95 916 95 916 95 0 1414 GI FC WA 100.0000 0,00 0.00 000 0.00% Teotar NSA 100.0000 196.82 196.82 196.82 014% Subtotal 1.113 76 1.113.76 0.00 1.013 76 Fund 541-7SGC Deter Senior 1199005 NSA 100 0000 123 59 123.69 T600t81 004 100 0000 3246 32.45 Subtotal 156 44 155 14 0.00 000 123:69 0 14% 3245 014% 156 14 1605891 540 916.95 9,6 95 916 95 0.00% 0 00 FDIC 540 - 000 0.00 0,00% 000 Texatar 540 196.82 19602 196.82 0.00%. 00D 0 00 000 000 subtotal 1.113 70 1 113 76 1 "13 75 0.00% 000 000 Texpoy 541 123.69 123.89 123.69 000% 0.00 Texslar 545 3245 3245 3245 000% 0:00 000 000 90519101 15554 158.14 156.14 000% 000 Fund 542.7805 Dept Reserve. Tenni. 1454 100.0000 251,704.47 25170447 251,704 47 0.0096 Texpool 542 251.70447 251,704.47 251.704.47 0.39% 0.00 Tenter hyo 100.0060 511.24043 511,24043 511 240 43 00014 Texstar 542 511240.43 511.240.43 61124043 0.79%. 000 FHLMC 30340257.19 09722111 08/12113 0522512 725 412 1000900 1,000,000.00 1,000,04000 11,000.00 1.011.00000 055% 0.550% 0481141 542 1.011.000:00 1,500.000.00 1,000,210 00 1.55% 536 Subtotal 1.762,944 00 1,762,94490 11,00000 1 773.944 90 0.00 000 0.00 subtotal 1,773,944.90 1,762,94490 1,763,154 90 273% 6.38 Fund 550.Parks at Taws Star Operations FDIC NWA 100 0000 0 CO 0:50 0:00 0' 03 0 14% Texpool NIA 100.0000 165,999 60 165,999 60 0 00 105,599 60 0 14% 1e8685 NSA 160.0000 0.00 000 500 0.14% Subtotal 165.599 80 165.999 80 0 00 195 999.80 Fund 592.7550 CIP FGIC 1000000 000 0.00 000 000 0.00% Texpool IWA WA 790.0000 314,915.00 314,95566 314,945.46 3 14% Tenter hyo 100.0000 300,464.03 300,454:03 300.454 03 0 14% Subtotal 695,36069 095,359.69 0,00 555.36969 FGIC 550 Texpool 550 Tesstar 550 000 000 000 subtotal 003 195,999.80 '65 999 80 000 0.00 000% 000 155,999.00 165,999.80 0.26% 0 00, 0.00 0 00 0 0054 0.00 165 999.60 155.999 00 0 2654 0.00 F010 552 - 005 0.00 000% 0 D Texpool 552 314.915 66 314,91556 314,95566 C 49% 0 00 Texslar 552 360454.03 353,45403 360.454.03 0.59% 000 300 0.00 subtotal 695,36969 695,36969 695,36969 1,08% 000 Fuld 601.E9Wpmen1 Replacement FGIC NA 100.0000 0.00 0.00 000 000% Oslo 531. 000 000 000% 0.00 1e09005 WA 100 0000 497,620.67 497,620.67 497620.67 0.14% Texpool 601 497.620.07 497,62067 497.6X167 0.77% 000 Telalar 7114 100.0000 539,355.62 539.355 82 539,355 82 0.14% 1906(95 604 539,365.62 539.355 62 539.355 02 0 64% 0 00 FHL6 3133704.1.553 02/15111 10/26152 11105 811 116 1051060 550,000 00 556,050. CO 15,039 24 5E5,839 24 072% 1.37596 3:00399 Sa mem 605000 601 555.785 25 559.053.99 552,04050 087% 1 CO 091.5 3133761467 12/29111 05/25113 12728/12 539 358 99.9500 1,000,000 00 999,50060 4.50000 1,004,50000 033%. 0.30055 033 FSW 500:00 601 1,004491.67 999.50833 1,000,080.00 5.55% 554 54610191 2,586,976.40 2.592 526 48 20.339.24 2,607.315.72 3.01232 500 00 6,050 00 50510(1 i 2 596 253 40 2, 595, 538.00 2 590,096 98 4.02% 6 55 Fund 610 -Insurance FGIC 14/p 1000000 0.00 0.00 000 0.00% FGIC 610 005 000 0.00% 0.55 0 00 : TexINpw7l 0414 100 0000 605,270 29 695.270 29 665,210.24 0 14% Te3pb0l 610 685,210 29 885,210 29 005,210.29 1.37% Tanta' N/A 100.0000 554.291.75 554,281.75 554.261.75 014% 1685141 610 554,28175 554.20175 554,201.75 068% 0.00 FHLB 31337971.7 04/25/12 07/15513 14/5 440 375 99,9900 1903,500 DO 999,900.00 293333 1F102,93333 025% 02401% 0555 10000 610 1.002,933.33 995900 DO 999,40200 155% 561 pFCB 3533E4474 01)30112 07126115 04426/12 536 386 999500 1.000.000 OD 999.500,05 3,30000 1.003.30000 025% 0220% 24.44 Coastal 50000 61D 1,003.27556 99952444 100©,020.00 155% 596 FHLB 3133765167 02/28/12 02/26114 02/26113 720 569. 100 0000 500,000.00 500,000.00 4,00000 504,000.00 0.40% 0400% Coasts. 610 504,00000 500.001000 500,150.03 0.7754 4.63 subtotal 3,939,492 04 3,930,092 04 10,233 33 3,949.725 3.5 2444 60000 0.00 6051010' 3949,70094 3935,916.46 3,939,054 04 6.1054 1542 Fuad 61641116 Management 5 00% 000 FGIC 1114 1000000 0.00 0.00 0.00 500% FGIC 615 000 0.00 Tngnd pyo 100 0000 577-126.32 577.12532 577.126.32 014% Texpool 615 577,126,32 577,126.32 577,126 32 069% 000 7e80181 WR 100.0000 543,41649 543,416,49 543,41849 0 14% Tenter 615 543,418.49 543,41049 543,418.49 004% 000 Subtotal 1,120,544.60 1.120,544 HO 0.00 1.120,544 SO 0.00 000 0:00 5020101 1,120,544.90 1,120,54480 1,120.544. BU 174% 0.00 Fund 705.0.11.0 Star. Eames R.o.rv. Taxpool N/A 1000000 1420,990.06 1420,99006 1420,990,06 0.14% Texpool 705 1420,990.06 1,420,990.06 1420,99006 220% 000 Fund 720 -Glade Park Phu. 11 Escrow Thr NSA 100.0000 1.284973.70 1,264,973.70 1.204973.70 0.00% 64,019.77836 64,543.409.27 309699.04 64,629,677.20 lento/ 13,669.10 4,921.50 37.56000 720 1 284 973.70 1,264 973 70 1.284,973.70 199% 000 44,776,228.10 54,557.278.37 64554,254,79 100.00% 231.86 I I City of Euless Schedule of Purchases July 2012 1 1 1 1 1 1 1 1 1 Insraeteserxt Type method.. LOGIC Loch Gov`! Pool FNMA Fed, Nall Mort. Assoc. FHLMC Fed. Home Loan Mort. Corp Vining Vining Sparks FSW First Southwest LOGIC Local Gov't Investment Coop. Tonle( Local Gov't Pool FECES Fest. Farm Credal Bank CD Cerlificetes of Deposit Coo alai Coastal Securities CanWM Cantor Fitzgerald Testator TexSTAR Texpool Local Gov't Pool FHLB Fed, Home Loan Bank TRILL Treasury 6111 Samos" Somco Securities Duncan Duncan Wrlliams Tex of TEXPOOL FDIC Marley Markel Farad Muluat Mutual Securities /GIC Federated Invasion Trust crue si Inv. CUSP Purchase Maturity Call Term Price Par Book9Value Interest Total Yreld To Coupon merest Seller .T'j+4N.umOer Date Dig pate On deal) Per 9150 Value }Prin. Only] ai at' Prim . int May Rate Purchased Inst. 12,moit Premium Texpool 07/02/12 100.0000 59.564.42 59,564.42 5.00 59554,42 0.1695 Texpool FHLB 3133792H5 07/09/12 07/05/13 NMC 356 1000000 100000000 1.000.000,00 2,500.00 1,002507.00 0.2546 0.25095 2775 FSW Texatar 07/14+12 100,0000 1,000,000.00 1.000000.00 0.00 1,000,000.00 0.134E Tessier Texpool 07/13/12 1000000 1.000,000.00 1.000.00000 0.00 1.000,000.00 01390 7000001 Texpool 07/25/12 100.0000 1,500000.00 1.500.00000 000 1500,000.00 0.14% Texpool TOTALS. 4459,564.42 4,559.56442 2,500.00 4.552.064.42 0.16% 2778 000 000 LOGIC DIVIDENDS REINVESTED 0,01 0.01 TEXSTAR DIVIDENDS REINVESTED 1.570,30 1.57030 TEXPOOL DrVIDENDS REINVESTED 1.631,52 1,631 52 FDIC DIVIDENDS REINVESTED 000 0.00 5 of TX DIVIDENDS REINVESTED 0.09 0.09 TOTAL INCLUDING DIVIDENDS: 4,582,766,34 4,562,766,34 TotuI P+16 Maty Net of Tolal Cost Fund Prem Disc es Int Pi of Investme nl Various 59.564.42 59,564.42 501 1,002,4 72.22 1,000.027.78 Various 1.900.000 00 1000,000.00 Various 1,000,000.00 1.000,000.00 VanDus 1,500,000 00 1.600000 00 4,562,036.84 4,559,592.20 0,01 0.01 1,570.30 1,570,30 1,631,52 1.631 52 0.00 000 0.09 0.09 2,500.00 4562,064 42 27.79 0.00 0.00 4,565,235.56 4,562794.112 I I I I 1 I I I I 1 1 1 1 1 1 1 1 1 1 City et Euless Schedule of Purchases August 2010 Invs60nsrrr Type InrtnrM4rr LOGIC Local Govt Pool FNMA Fed, Nall Moet. Asset. FHLWC Fed. Nome Lean MDA. Carp Vining Vining Sparks FSW First Southwest LOGIC Local Gov't Investment Coop. Tooter Local Govt Pool FFCB Fad. Farm Credit Bank CD Ceiriflcates of Deposit Coastal Coastal Securities CBMor Cantor Fitzgerald Texster TexSTAR Texpool Local Gov't Pool FHLB Fed. Home Loan Sank TRILL Treasury Bill Sarno Samco Securities Duncan Duncan WI91ama Texpool TEXPOOL FDIC Manny Market Fund Mutual Mutual Securities FGIC Federated Investors Trust Cost Accrued Total P 4 10 Inv. CUSIP Purchase Maturity Call Tem, Price Par Book Value Interest Total Yield To. Coupon Interest SellerTIM Maly Net Intl Total Cast Number pate �S -in n r 190 Value [Prig. 01401 ma!'v Prin+int �IaluMv Rale Purchased hast Discount Premium Fund Prem, Disc& lm Pi or Investment Texstar 08/02112 100.0009 600,000.00 500,000.00 0.00 600.00000 0.14% Tekstar Vandus 699,900.00 600.000.00 Texpool 06103112 100.0000 59,564.42 58.564,42 0.00 55,564.42 0.14% 75x5001 Various 59,564.42 59,564.42 Texatar 08107112 100.0000 2.000:000.00 2,000,000.00 0.00 2.000,000.00 0.1295 Texslar Various 2,090.000.00 2.000,000.00 Texpool 0610/12 100,0000 2,000.000.00 2,000,000.00 0 00 2,000.000.00 0.1355 Texpool Various 2.000.000.09 2.000.000 00 FHLB 3133760050 08/17112 08115113 5110 358 100,0566 1,000.000.00 1,000,586.00 2.840.00 1,002.800.00 0.2296 0.280% 1556 5544 566.00 101 1,002.215.44 1,000,561.56 Texstar 09121/12 100.0000 1,000,000.00 1,000.000.00 0.00 1,000,00000 0.1246. Tsxstar Various 1,000.000.00 1,000.000.00 Texpool 0623112 100,0000 500,000.00 500.000 00 0.00 500,000.00 0.7346 Texpool Various 500,000.00 500,009.00 FHLB 313380LS4 38/28112 05/26113 5410 360 1000000 1.000.000.00 1,000,000.00 2,300.00 1,.502,000.04 02350 0.23095Cantor 320 7,002000.00 1.000.000.00 6,159,564.42 8,160.130.42 6100.00 9,164664.42 0.16% 15.56 0.00 56500 8.164,062.86 8,160.145.98 LOGIC DIVIDENDS REINVESTED 990 0.00 0.00 1.702.57 0.00 YEXSTAR DIVIDENDS REINVSSTEO 1,702.57 1,702.57 1 702.57 TEAPOOL DIVIDENDS REINVESTED 1,992-25 1,802 25 1,80225 1,802.25 5610 DIVIDENDS REINVESTED 0.00 0.00 0.00 0.00 B of TX DIVIDENDS REINVESTED 0.09 0.09 0.09 0.09 TOTAL INCLUDING DIVIDENDS: 8,183,069.33 5,163,635.33 5,100.00 5,164,564.42 15.56 0.00 566.09 8,167.587.77 8,163,650.89 I I 1 I I I I I I 1 1 1 1 1 1 1 1 1 1 City of Euless Schedule of Purchases SePhmber 2012 Investinera Type institution LOGIC Lotal Geort Pohl FNMA Fed. Nall Mort. Assoc. FHLMC Fed. Home Loan Mort. Corp Vining Vining Sparks FSW First Southwest LOGIC Local Gov/ Investment Coop. Texster Local GOv't Pool FFCB Fed. Farm Credit Bank CD Certificates of Deposit Coastal Coastal Securities Cantor Cantor Fitzgerald Teaater TexSTAR Tezpool Loeal Gov't Pool FHLB Fed. Home Loan Bank TRILL Treasury Bill Samoa Samco Securities Duncan Duncan Williams Tezpool TEXPOOL FGIC Money Market Fund Mutual Mutual Securities FGIC Federated Inveslors Trust Cost Accrued Total P . la Inv. CLISIP Purchase Maturity Cell Term Price Per Book Value Interest Total Yield To Coupon Interest Seller Maty Net or Total Cost Tree NumDa! Odle ataEMLe (in daysj per 9100 Value (Prin Onlv)mat NO 4 lnl Maturity Rate Purchased Inst. Discount Premium Fund Prem Disc 8 IMP, of Investment Tezpool 09105/12 100.0000 55,136.17 59,138.17 000 59,13817 0.1595 Texpool Various 59,138.117 59,13617 Tezpool 09/06112 100.0000 1.000,000.00 1.000.000.00 0.00 7 ©00,000.00 0.16% Tezpool Various 9.000,000.00 1.000,000.00 Toaster 09/07112 100.0000 1,000,008.00 1,000,00000 0.00 1,000,000.00 0.16% TO*Slat Various 1,000,000.00 1.000.000.00 Tezpool 09/14/12 100.0000 500.000.00 500,000.00 0.00 500.000 00 0.17% Texpoal Various 500,000.04 500,000.00 TOTALS: 2,559,138.17 2,559,138.17 000 2,559.135 17 0,16% 004 0:00 5,04 2,559,130.17 2.559.138.17 LOGIC DIVIDENDS REINVESTED 0.00 0.00 TEXSTAR DIVIDENDS REINVESTED 1,9,18.08 1,948.08 TEXPOOL DIVIDENDS REINVESTED 2.092.89 2,092.89 FGIC DIVIDENDS REINVESTED 0.00 0.00 B of TX DIVIDENDS REINVESTED 4.500.10 4,500.10 TOTAL INCLUDING DIVIDENDS: 2,567,679.24 2,567.679.24 0.00 2,559,138.17 0.00 0.00 1,948.09 1,948.06 2,092.39 2.092:89 0.00 0.00 4,500.10 4.500.10 000 000 0,00 2,567,679.24 2,567,679.24 J � I City of Euless Schedule of Maturities July 2512 investment. Type InetitutIon LOGIC Local Gov't Pool FNMA Fed, Nall Mort. Assoc, FHLMC Fed. Home Loan Mort. Corp Vining Vining Sparks FSW First Southwest LOGIC Local Govt Investment Coop. Texstar Local Govt Pool FFCB Fed. Farre Credit Bank CD Certificates of Deposit Coastal Coastal Securities Cantor Cantor Fitzgerald Texstar TexSTAR Texpool Local Gov' Pool FHLB Fed. Home Loan Bank 1BILL Treasury Bill Samco Samco Capital Duncan Duncan Williams Texpool TFXPOOL FGIC Money Markel Fund Mutual Mutual Securities FGIC Federated Investors Trust Term to Term to Cost Accrued Total P + 1 Inv. CUSIP Purchase Maturity Call Maly Call Price Par Book Value Interest Total Prin. + Yield To Coupon Interest Seller Maty or cull Net of Total Cosi Lot Number Da1e Date Date (in 4SYS,I i0 Per 5100Value ( Prin. Only) A mafx/Ca11 Int. U18Yy Solari Rale Pureeatod Ins . piswunl Pfemium Fund Prem & Int Per. of Investment Texpool 07/03/12 100.0000 700000,00 700.000.00 - 700.000.00 0.18% Texpool Various 700.000.00 700,000.00 FFCB 31331J745 01/10/11 07/10112 NC 540 -20 100.0000 1000,000.00 1,000,000.00 7,500.00 1,007,500,00 0.50% 0.500% FS1A, 5101 1,007.500.00 1.000,000.00 Texpool 07/13112 100.0000 442.87 442.87 442,87 0.13% Texpool Various 442.87 442.87 TVAS 88059EMF8 01105111 07115112 MIC 550 -15 99.0134 915,000.00 905,972,51 9027.39 924,027.39 0.65% 0.6505 Duncan 101 924,027.39 905,972.61 FFCB 31331KAN0 01125/11 0725112 NMC 540 -5 100.0000 1,000,000.00 1,000,000.00 7,50090 1,007,500.05 5.50% 0.500% Duncan 101 1,507,500.00 1,000,000.00 FHLB 313374237 07126/11 07/25112 NUC 380 -5 99.9957 500,000.00 499,978.50 1,250,00 501,250.00 0.25% 0.250% 3.47 FSW 21.50 501 501.240,53 499,981.97 Tessler 07131/12 100.0000 300,000.00 300,000.00 300;000.00 0.14% Texstar Various 300000.00 303,000.00 Texstar 07/31112 100.0000 175,000.00 175,000.00 - 175,000.00 0.14% Texstar Various 175.500..00 175.050,00 Texpool 07/31/12 100.0000 590,000.00 590,000.05 590,000.00 0.14% Texpool Various 590,000.00 590,000.00 TOTAL 5,150,442.87 5,171,393.95 25,277.39 5205,720.26 0.29% 3.47 21.50 0,00 5,205.718,79 5,171.397.45 1 1 Ciy of Euless Schedula of Maturities August 2012 Investment TypeInstitution LOGIC Local Gov't Pool FNMA Fed. NaCl Man. Assoc, FHLMC Fed. Home Loan Mart. Corp ming Vining Sparks PSI First Southwest LOGIC Local Gov't Investment Coop Texslar Local Gov't Pool ('FCB Fed. Farm Credit Bank CD Certificates of Deposit Coastal Coastal Securities Cantor Cantor Fitzgerald Texsfar TexSTAR Texpool Local Gov't Pool FHLB Fed. Home Loan Bank TBILL Treasury Bill Samos Samco Capital Duncan Duncan Williams Texpool TEXPOOL Mutual Mulusi Securities FGIC Federated investors Trust FGIC Money Markel Fund Term to Term to Cast Accrued Total P 4 I 0 Coil Maty Call PriceMat Par Book Value Interest Total Prin. + Yield To Coupon Interest Seiler Y or call Net of Total Cost attne /in dips] {in dapst Per 100 Value Pri i3Onl�i 0 maty+0 ll Int. � Malo Biu Rate Pufolase Inst Discount Premium Fund Pram & Int Pur. of Investment NIC 360 -22 100.0510 1,000,000.00 1.000,51000 2.500.00 1,002 500.00 0.1545 0.250% FSW 510,00 101 1001,99000. 1.000.510.00 06/08/12 720 338 100.0000 1,000,000.00 1,000000.00 6,250.00 1,006,250.00 0.53% 0.52595 FSW 520 1005,25000 0000.000.00 100.0000 1000000.00 1,000,000.00 1,000000.00 014%. Texslar Various 1;00000000 1,000,000.00 100.0000 1.000,000.00 1.000,000.00 - 1000000.00 0,1295 Texpool Various 1,003000.00 1,000,000.00 100.0000 1,000,000.0 1.000,00000 - 1000000.00 0.13% Texpool Various 1,000,000.00 1.000.000.00 06722/12 720 352 100.0000 1,000,000.00 1,000.000,00 5500,00 1.005.500,00 0.55% 0.55055 Coastal 542 1.005,500.00 1.000,000.00 1000000 1,097,00000 1,097,000,00 - 1.097,000.00 0.14% Tesstar Various 1,097,00000 t 097,000.00 100,0000 403000.00 403000.00 403,000,00 0.14% Tessler Various 403.000,00 403,000.00 100.0000 196,000.00 196,000.00 196,003.00 0.15% Texstar Various 198000.00 196.000.00 7696.000.00 7,590,510.00 14,250.00 7,710,250.00 0.2496 0.00 0.00 510.00 7.709,740.00 7,696,510.00 Inv. CUSIP Purdmase Malunty am Number Dale Date FHLB 3133750.45 06108!11 00/08112 FHLMC 3134G2SL7 05/05/11 06/08/13 Texsfar 08113/12 Texpool 08714/12 Tespool 08/17112 FHLMC 313402VN9 08722711 08/22/13 Texsfar 08727712 Texstar 06!27112 Texslar 08731712 TOTAL 1 1 City of Euless Schedule of Maturales September 2012 1 1 1 1 1 1 1 1 Investment Type Institution LOGIC Loeal Gott Pool FNMA Fed Nal! Mor. Assoc. FHLMC Fed. Home Loan Mort. Corp Vining Vining Sparks FSW Firs! Southwest LOGIC Local Gov't Inas anent Coop. Tessier Local Gov't Pool FFCB Fed Farm Credit Bank CO Certificates of Deposit Coastal Coastal Securities Cantor Cantor Fitzgerald Tattler Te:STAR TexpoaI Local Govt Pool FHLB Fed Home Loan Bank TRILL Treasury Bill Samcn Samna Capital Duncan Duncan Williams Texpoo! TEXPOOL FGIC Money Market fund Mutual Mutual Securities FGIC Federated Investors Trust Tenn to Term to Cosi Accrued Total P + 1 0 Inv. CUSIP Purcttaae Mab+nty Cail Maty Gall Price Par Book Value Interest Total Prin. + Yard To Coupon Interest Seller Maty or call Net of Total Coat Tyra Number arta Qite Ill fin Oayst in Per 1 Value (Pnn. OrLtl. el mare/Call Int. A Maty Matwrty Rate Purchased In$l, ¢i;oount Premium Fund Prem 6 Int Pur. of Investment Texpool 09/04112 100.0000 800000.00 900,000.00 - 800.000.00 0.15% Texpael Various 800,000.00 600.00000 FNMA 3135GOCO4 09/06111 09106113 09109112 720 336 100.0000 925,000.00 925000.00 4,15250 929,192,50 0.45% 0.450% Vining 101 929,152.50 925,00000 Texpool 09/11112 100.0000 600,000.00 600,000.00 - 600,000.00 0.17% Texpool Venous 800,00000 600,000.00 Texstar 09126712 100.0000 400,000.00 400,000.00 400,000.00 0.17% Tessler Various 400,00000 400.000.00 Tenter 09/27712 100.0000 300000.00 300,000.00 - 300,000.00 0.1602 Tessler Various 300000.00 300000.00 TOTAL 3025,000.00 3,025,000.00 4,162.50, 3,029.162.50 0222 0.00 0.00 0.00 3,029,162.50 3,025.000.00 Fund tt LOGIC TEXPOOL TEX5TAR 6 ut T 101 0.00 517,123.16 1,513.930.09 102 3.00 0.00 0.00 103 0 00 0.00 0.00 201 0.00 100,297_49 15 ,144.55 202 0.00 75.172.45 0.00 210 0.00 616,129.09 575.549.77 211 0.00 0.90 0.00 220 0.00 100,855.07 55.139.52 230 0.00 556 90 10,505.93 231 0.00 100, 730.37 30,195 66 240 0,00 648,312.41 1,037,210.08 245 0.00 150,061.39 0.00 250 0.00 0.00 0.00 301 3.00 722,936.07 503.457 54 305 0.00 353,472.21 1,562,471.92 310 0.00 101,196.40 277,029.35 320 0,00 550,999.29 265,624 88 321 0 00 275.746 97 0 00 325 0.00 0.00 100 652.21 330 000 2,793,07676 2,155,675.48 401 0.00 557,250.21 0.00 402 0.00 147,266.69 0.05 410 0.00 0.00 0.00 501 70 61 1.052.940.50 859, 756.25 502 0.00 016,587.42 157,761.03 503 0.00 304,774.21 0.00 504 0.00 0.00 0.00 505 0.00 855,967.93 5,855.64 506 0,00 0.00 0.00 507 0-00 500,000.00 0.00 508 0.00 57.545.28 452.942.68 509 0.00 127,352,28 411,678.73 519 0.00 168,485,74 186,29134 511 0.00 604,767.56 355,679.57 512 0.03 (0.00) 0.00 520 0.00 216,661.65 201,164.02 521 0.00 20.830.82 19.08 530 0.00 62.00 0.00 531 0.00 0.00 0.00 532 0.00 100,033.90 601,177.99 540 0.00 917.26 196.89 541 0.00 128.69 32.46 542 0.00 251,789.80 1,086,56803 550 0.00 166656.07 0.00 552 0A0 315,022,42 380,591.96 601 000 507,791.77 679,585.99 610 0.00 585,408.68 179,455.69 515 0.00 627,338.92 843,689.72 705 0.00 1,421,048.06 0.00 710 0.00 0.00 0.00 Oct -12 N0v-12 Dec -12 0.00 0.00 0.00 0,00 0_00 0.00 0.00 16,040.90 0.00 000 0.00 000 0.00 0.00 300 000 0 00 0.00 0.03 000 0.00 0.00 0.00 0,00 000 0.00 000 0.00 500,040.55 0.00 0.00 0.00 0.00 0,00 0,00 0.00 0.00 0.00 0.00 0.00 000 0,00 0,00 0,00 0.00 0.00 0.00 0 00 0,00 000 559,053.99 0 00 0.00 0.00 0.00 0.00 503,253 33 Total 70.61 16,312580,00 14,677,05870 16,040.90 559,053.99 500,040.56 503,263,33 Inv{ latunlEel September -12 1 1 1 1 1 I 1 1 I 1 Jan -13 Feb -13 Mar -13 Apr -13 Mav"13 Jan -13 Jules -13.13 A1713 Sep -13 Oct -13 Nov -13 Dec -13 Jan -14 Feb -44 Mar -14 Mar -16 Total 0.00 0.00 0,00 1.005.000.00 1,000,100.00. 2,000,581 50 1,017.46625 999,798.61 500,00000 1,000,000.00 9.549,000.25 500.000.00 500,000.00 0.00 500,000_00 500,090.00 115.442.09 75,172.45 1,292 678,06 0.00 900.000.00 916,040.90 155,994.59 11.062.52 130,926.03 000 0.00 1,500,000.00 0.00 1,499,913,89 1,000.000.00 1,000,000.00 999,555.00 7.684,991.36 150,061.39 0.00 101,316 65 1,407,710.26 0.00 0.00 2,419,207.46 0.06 1,000,000,00 $96.375.00 1,377,400.75 275,746.97 100,652.21 4,988,954 26 557,250.21 147,266.69 0 00 0.00 0.00 0 00 2,300,000.00 0.00 1,000,027.76 1,017,040.83 999,750 00 775,591 25 7,735,167.23 1,0016147 50 2,276,236.51 304,774_21 0.00 0.00 0:00 1.006000.00 0.00 1.000.000.00 2,861,827.57 0.00 500.000.00 6.10,49196 0.00 1000,000.00 600000,00 2,039,031.01 354,757.08 960,447.13 (0.001 417,545.67 20.849.90 62.06 0.00 701, 211.89 1,114-15 161.14 0.00 1,338,357_83 166,056.07 0.00 999,508 33 695,614.38 2,745,940.08 0.00 0.00 1, 999, 424,44 500,000.00 3.264.258_81 1,471,028.64 1,421,046.08 0.00 0.00 0.00 0.00 0.00 1,500,000.00 2.000,000.00 4,499.422.22 3,999,552.22 3,000,581.56 3.034,507 08 1.500,000,00 2,499,798.61 2,161,316 65 2.001.597.50 3,275,136,25 998,375.00 900,000.00 63,958,495.17 Economic News Vicki Rodriquez From: Sent: To: Subject: Linda Callaway <Linda.Callaway-Gusnowski@firstsw.Com> Tuesday, January 08, 2013 1:25 PM Linda Callaway Bloomberg Reports State and Local Governments are Poised for Growth in 2013 FirstSoutt kwest AO. T� esday, January 8, 2013 A FORECAST FOR BETTER DAYS AHEAD Over the past five years, state and local governments have tightened their belts and shed calf a million workers. Now, with revenues increasing, job growth is apparently set to resume. Bloomberg News reported this morning that state and local governments, which account for 12% of the U.S. economy, will not restrain GDP growth for — the first time since 2009. Mark Zandi, the Chief Economist at Moody's, believes state an i local governments are in their best financial shape since 2007 and predicted that by the fourth quarter, payrc lls will be 220,000 higher than in the same period in 2012. According to the National Governors Association , state revenue will increase by 3.9% for the 2012-2013 budget year, exceeding the peak established before t le recession began. Last week's fiscal cliff "resolution" appeared positive for municipals in that the tax-exen pt status of municipal debt was unaffected at the same time marginal tax rates for wealthy individuals increases . A higher tax rate enhances the value of tax-exempt securities. However, some investors, including PIMCC 's Bill Gross, are taking a cautious approach to the municipal market given that Congress and the administ,ation will be making some extremely difficult decisions on Federal spending cuts in the coming weeks. Austei ity at the national level could mean less dollars allocated to the states, which according to the Rockefeller Institut of Government, currently receive one-third of their revenue from Washington. Stocks are off in early trading after a down day on Monday, while Treasury bond yields re slightly lower on the long end of the curve, MARKET INDICATIONS AS OF 9:55 A.M. CENTRAL TIME DOW NASDAQ — S&P 500 1 -Yr T-bill 2 -Yr T -note 5 -Yr T -note 10 -Yr T -note 30 -Yr T-bond CONTACT US Greg Warner, CTP 512.481.2012 DOWN 62 to 13,322 DOWN 8 to 1,447 DOWN 15 to 3,084 current yield 0.13%; opening yield 0.13% current yield 0.26%; opening yield 0.26% current yield 0.79%; opening yield 0.81% current yield 1.87%; opening yield 1.90% current yield 3.07%; opening yield 3.10% Scott McIntyre, CFA 512.481.2009 Vicki Rodriquez - From: Linda Callaway Linda.Callaway-Gusnowski@firstsw.com> Sent: Wednesday, January 02, 2013 11:15 AM To: Linda Callaway - Subject: Fiscal Cliff Bridge Averts Fall, But... FirstSouthwest ` Wednesday, January 2, 2013 CLIFF RESOLUTION IS HARDLY CAUSE FOR CELEBRATION The "Fiscal Cliff" was averted in a last-minute compromise that many consider a win for the Democrats. Unfortunately, the really hard decisions were not made, only postponed for another two months. Another potentially ugly debt ceiling debate will take place over the next 60 days and critical Icing -term spending cuts have yet to be addressed. The important issues that were resolved (for the time being) are: Federal long-term unemployment benefits were extended for another year. • The Bush tax cuts were extended permanently for individuals earning less than $ I00,000 and families earning less than $450,000. Those earning above these thresholds will see incremental tax rates revert back from 35% to 39.6%. • The payroll tax, which funds social security, will revert back from the "tax holid ry" rate of 4.2% to 6.2%. This means that everyone will resume paying at least 2% more in 2013. • The dividend and capital gains tax rates will increase from 15% to 20% for individuals earning above $400,000 and families above $450,000. • The estate tax will permanently increase from 35% to 40%. Individual estates wi it be tax-exempt on the first $5 million, while farnily estates will not be taxed on the first $10 million. • Certain individual tax breaks, including child tax credits, will be extended for anther five years. • Certain business tax credits will be extended for another year. • The alternative minimum tax will now be permanently indexed to inflation instea ! of being "patched" annually. This will prevent an estimated 30 million middle- and upper-class taxpryers from being hit with an average increase of $3,000. The "sequestration" or sequester cuts, which are what we are now calling the $1.2 trill on in across-the-board spending cuts that were scheduled to begin this year after the "Super Committee" failed to reach an agreement i in November 2011, were postponed. The Congressional Budget Office (CBO) reported on Tuesday that the new fiscal comr romise would increase the deficit by $3.9 trillion over the next 10 years. There is no word from Moody's on the possibility ofa U.S. ratings downgrade as a result of Congress failing to address the long-term deficit problem. The equity markets are in the midst of a celebratory rally, while intermediate and long be nd yields have risen. For anyone who hasn't experienced enough frustration over the Federal budget proeel s, considering reading "The Price of Politics" by Bob Woodward. This remarkably dull book provides an insibler view on the budget ceiling negotiations from July and August 2010, which ultimately resolved nothing and resulted in S&P lowering the United States credit rating from AAA to AA+. MARKET INDICATIONS AS OF 10:40 A.M. CENTRAL TIME DOW UP 223 to 13,327 ._ NASDAQ UP 68 to 3,087 S&P 500 UP 26 to 1,446 1 -Yr T-bill current yield 0.14%; opening yield 0.14% 2 -Yr T -note current yield 0.25%; opening yield 0.25% 5 -Yr T -note current yield 0.76%; opening yield 0.72% 10 -Yr T -note current yield 1.83%; opening yield 1.76% 30 -Yr T-bond current yield 3.04%; opening yield 2.95% CONTACT US Greg Warner, CTP 512.481.2012 800.575.3792 greg.warner®firstsw.com Scott McIntyre, CFA 512.481.2009 806.575.3792 SCOU.MCintvre@firstsw.com This gaper was provided to you at your request and is intended for receipt only and not for further distribution without the consent of FirstSouthwest Asset Management. If you would like to be removed from this distribution list please reply with the word REMOVE in thi subject line. The paper was prepared by FirstSouthwest Asset Management and is intended for educational and informational purposes only and does not constitute legal or investment advice, nor is it an offer or a solicitation of an offer to buy or sell any investment or other specific pros uct Information provided in this paper was obtained from sources that are believed to be reliable; however, it is not guaranteed to be correct, complete, or current, and is not intended to imply or establish standards of care applicable to any attorney or advisor in any particular circumstances. The statement t within constitute the views of FirstSouthwest Asset Management as of the date of the report and may differ from the views of other divisionsldepartmen s of First Southwest Company. In addition, the views are subject to change without notice. This paper represents historical information only and is not an ndication of future performance. FirstSouthwest Asset Management is an SEC -registered investment advisor. Scott McIntyre Senior Vice President FirstSouthwest Asset Management, Inc. -- direct 512.481.2009 fax 512.481.2020 300 W. Sixth Street, Suite 1940, Austin, TX 78701 Patterson & Associates ECONOMIC UPDATE Market Snapshot at 15:24 Dec. 14, 2012 3 ,ratT-Bill 6 rr=nth T -Bill 12 rrnmh T -Bili 2 year Trarsury Ncee 5 Treasury Nate 10 yr Treasury Nate 30 year Treasury Bch 0.03 0.09 0.13 0.23 0.69 1.70 2.86 Upcoming Economic Data Monda y -Dec. 17 Empire Manufacturing Foreign Purchases of US Secu- rities Tuesday -Dec. 18 NAHB Home Builders Index Wednesday -Dec. 19 Weekly Crude Oil & Gasoline Inventories Housing Starts &Permits Thursday—Dec. 20 Weekly Unemployment Claims Weekly Natural Gas Inventories Q3 GDP Philadelphia Fed Index Existing Home Sales Leading Economic Indicators Friday .Dec. 21 Personal. Income &Spending PCS Inflation Durable Goods Orders U of Miich. Confidence Survey .-r !". T 1 T 1 The New Magical Mystery Tour The roller coaster rise we talked about last week went off on a new direction on Wednesday. In the post -meeting statement, the FOMC announced that for the first time they would target specific economic reports as primary determining factors in their mone- tary policy decisions. Specifically, they chose employment and consumer level infla- tion. While not "carved in stone" the FOMC established that current monetary policy would remain in place (or even broaden) as long as US total Unemployment remained at or above 6.6%. A second factor will be consumer inflation as defined by the Personal Consumption Expenditures (PCE) component released both monthly and quar- terly as part of GDP. The annualized rate that will be considered "actionable" is 2.5% . By now using both of these new reference points the Fed will remove the prior language which had stated "rates will remain exceptionally low through 2015". Neither of the new monetary "benchmarks" are even close to the levels designated by the Fed. PCE is currently reported at 1.1% for Q3 2012 and with the recent drop in en- ergy costs will likely decline further. Employment is much more of a subjective report considering how the Bureau of Labor Statistics calculates the report. We have recently seen significant declines in the unemployment percentage rate as the "unemployed workers" (the nu- merator in the fraction) declined at a much faster rate than the "total work force" (the denominator in the fraction). However, the accuracy of these calculations has often been questioned because of factors such as "unemployed workers" can also decline because long term unemployment benefits have run out and not because the person found a job. There will be much head scratching about how the Fed sees a decline in the unemploy- ment rate if the long term unemployment numbers remain at current record levels. The FOMC also announced they will in- crease the size of asset purchases they will be mak- ing (US Treasuries and federal MBS). If they DO maintain the projected purchases through 2013 it is likely the Fed balance sheet and portfolio will in- crease by $1 Trillion dollars. In summary, QE3 is now QEI or Quanti- tative Easing Infinity. Although initially seen as a big negative to the Treasury market we are finishing the week only marginally higher on both the long end and the short end yields. No real progress announced out of Wash- ington on the fiscal cliff debates. Rumors fly about "under the table" proposals from both parties go- ing back and forth but until something emerges into the light of day, all we can do is wait and watch. Have a nice weekend. Regards TRIVIA OF THE DAY Q: What event, on Dec. 17, 1903 marked the beginning of one of the greatest changes in our society? A: The Wright Brnthers flew for the first time. QUOTE OF THE DAY The best scientist is open to experience and begins with romance- the idea that anything is possible. Ray Bradbury FirstSouthwest TIP Asset Management Economic Summary — 3rd Quark r 20 2 The National Oceanic and Atmospheric Administration (NOAA) reported the month of July was the hottest month in US. history since - recordkeeping began 118 years ago. Compounding the discomfort is a nationwide drought that's slowly burning a wide swatch of American farmland. The stifling heat might not have anything to do with the lackluster economic growth, but it feels that way. The U.S. economy - limped along at a revised 1.3% annualized rate in the second quarter of 2012, less than half the historical GDP average over the past 20 years. Although the initial third quarter GDP report won't be released until - late October, the expected improvement will still fall well below the pace needed to generate sufficient jobs. And, although the recently completed quarter brought with it a tremendous amount of news, job creation is still the chief concern and a rallying point of the November elections. There were pockets of good news reported during the quarter, much of it related to housing. Fannie Mae and Freddie Mac announced in July they'd both earned fairly significant second quarter profits. This welcome news was a contributing factor in the Treasury Department's decision to modify its Preferred Stock Purchase Agreements, replacing Fannie and Freddie's required 10% dividend payment with a complete sweep of any and all — future profits directly into the Treasury, This symbolically ended any chance that the mortgage giants could eventually stockpile enough cash to resurrect themselves. The Treasury also announced that their retained - mortgage portfolios would now be required to shrink by 15% per year instead of the previous 10% pace. The takeaway here is that there will be less and less new agency debt to purchase. Global economic problems garnered their share of headlines. As much of Europe sank into recession under the weight of harsh austerity measures, Spanish and Greek rioters took to the streets in protest, and _ interest rates in struggling countries shot higher, compounding the underlying debt problems. The European Central Bank responded by announcing a program to purchase short-term sovereign debt on the open market. Chinas economy, the global engine of growth for many - years, has shifted into a lower gear, prompting accommodation from its own central bank. Even the Japanese central bank announced a huge asset purchase program in hopes of stoking the fire that hasn't produced any significant heat in two decades. The decrease in global demand is beginning to have a negative effect on the factory sector as export growth slows. The US. ISM factory index fell - from 49.8 to 49.6 in August. It was the third straight month below the 50 mark (indicating contraction) and the longest such string since mid -2009. Although the Eurozone Purchasing Managers' Index (PMI) climbed from 45.1 to 46.1, September still marked the 14th straight month of contraction in the European manufacturing sector. China's factory sector is also in contraction territory, as its official PMI rose from 49.2 to 49.8 in September. August had been the lowest reading of the year. EMPLOYMENT Job growth, or the lack thereof, has been a hot election topic all year. Fortunately for the current administration, the woeful second quarter job gains improved somewhat in the third quarter, but not enough to suggest a strengthening economy. Nonfarm payrolls increased by just 96k 9s 90 8.8 8.6 8.7 82 80 Unemployment Rate !Left Hand Scalel Change in Non -Fenn Payrolls tiRight Hand Sealey 78 7.6 I so c a rsm 3 a c c c T N N N N N 1 UnemplaYment Fate 11= Change in 0onlarm Payrolls 300 250 200 150 100 60 0 EMPLOYMENT Change in Non -Farm Payrolls in August, well short of the median forecast for a gain of 130k. Revisions to the two previous months subtracted 41k jobs from the previous count, leaving July at 141k and June at a mere 45k. According to analysts, the level of job gains needed to legitimately chip away at the unemployment rate would be above 250k per month. Having said that, the unemployment rate fell from 8.3% to 8.196 in August, but the primary contributor was a 368k drop in the labor force, which took the participation rate down to 63.5%, the lowest in 33 years. The unemployment rate has been above 896 since February 2009, the longest such streak since 1948. Frankly, if the seven million people no longer looking for work are included in the calculation, unemployment climbs above 1196. Job conditions in Europe are at least as bad, if not worse. The Washington Post reported that the combined official unemployment rate for the 17 European countries that share a common currency remained at a record high 11.4% in August, the highest level since the euro was created in 1999. For the 27 -country European Union, unemployment was a bit lower at 10.5%. The bottom line on employment is that governments across the globe realize the importance of a gainfully employed population, and will likely keep providing monetary stimulus in hopes of achieving this. CONSUMER SPENDING Apparently, American consumers are beginning to feel better, although it isrit really dear why. The September University of Michigan confidence index jumped from 74.3 to 79.2, the second highest survey reading since before the recession began. And, the Conference Board's consumer confidence index unexpectedly jumped 9 points in September to 70.3, the highest level in seven months. The present situation index increased by 3.7 points to 50.2, the highest since April, while the future expectations index surged by a whopping 12.6 points to 83.7. Interestingly, the present situation index was bolstered by improvement in perceived employment conditions. Second quarter retail sales were all negative, but the third quarter has been quite a bit better. The retail sales report showed an increase of 0.9% in August, topping the revised 0.6% July increase. Unfortunately, the majority of the August increase resulted from higher gasoline station sales, which reflected the jump in gas prices. September vehide sales exceeded forecasts rising to a 14.9 million unit annualized pace, the highest level FirstSouthwest Asset Management since March 2008, just four months after the recession officially began. Auto industry experts speculate that low cost financing has provided a - boost. Bankrate.com reported the average rate on a 48 -month new car loan was 3.1996 in September, down from 4.3996 a year earlier. HOUSING 850 750 650 Te 550 • 450 2 350 250 r Existing Home Sales MN* New Home Sales x -9 a 2 2 S IO m S O o 0 z " 3 n 2 m g> O y .K K .. M M M 6.0 7.5 7.0 m 6.5 I 4.5 3.5 2.5 U 1.5 0.5 • 0.5 -1.5 1111111111MliiiiiiM E '�'!:IiilI IIII1IIIIII1FII 1■11111111111111111111111 6.6 3 m o a m k s 3 c c c m 0 o n 5,5 • o e o 5.0 4.5 4.0 3.5 NEW AND EXISTING HOME SALES Annualized by Month The housing market has bounced off historically low levels to become one of few bright spots in an otherwise anemic recovery. Unfortunately, its - overall contribution to GDP growth going forward is likely to be relatively small. Nevertheless, recent reports have been encouraging. Buying a home has become 4596 cheaper than renting, according to an analysis done by web- based home listing service Trulia, and buyers are beginning to see - the value. Existing home sales rose by 7.8% in August, the biggest jump in a year, to a 4.8 million unit annualized pace, the highest since May 2010. The median sales price for an existing home rose 9596 year -over -year to - $187,400. It was the biggest annual price increase since January 2006. New home sales in July reached an annualized pace of 374k, the highest in two years. Sales in August were up 28% year -over -year. According to the National Association of Realtors, 2012 overall home sales are now on track - to reach a five-year high. With the increase in buyer demand, and scarce inventory, prices on new homes soared. In fact, the median price for a new home jumped over 1196 in August to $256,900, the largest single month - increase in history and 1796 above the same period a year ago. With so few new homes available, builders are incentivized. The National Association of Home Builders (NAHB) Housing Market Index for September rose to its highest level in six years. Freddie Mac's 30 -yr fixed rate mortgage index - matched a record low of 3.4096 at the end of September, and the Mortgage Bankers Association applications index quickly responded by surging to a three-year high. INFLATION Inflation hasn't been a concern when the measuring stick is the consumer - price index (CPI). Although. CPI rose 0.686 in August, it was the first increase in six months. On a year -over -year basis, CPI is rising at a benign 1.796 pace, up from 1.496 in July. Eighty -percent of the August increase was energy-related as energy costs jumped by 5.696, the most in over three "- years. With a majority of developed nations either in recession or on the edge, it wasn't an increase in global demand for oil that drove crude prices higher, so much as continued geopolitical uncertainty in the Middle East. r CPI 4r Core a M 4 M N 4.5 3.5 2.5 1.5 ci, 4 05 0.5 1.5 CONSUMER PRICE INDEX: Core Rate (Excluding Food & Energy), Year -Over -Year Nevertheless, the average price for gasoline nationwide had climbed more than $0.50 per gallon by mid-September before settling down at quarter - end. Food prices also edged higher as Americas farmland continued to wither under the oppressive heat According to the U.S. Department of Agriculture (USDA), about 80% of farm land is in the midst of drought conditions, making the 2012 drought the worst since the 1950s. The USDA estimated that 2012 corn production per acre would hit a 17 -year low, while soybean yield per acre would approach a 10 -year low. The lack of rain is also expected to have an impact on beef and dairy prices as more than 7096 of the cattle herds are located in states where grazing conditions are rated poor to very poor. Corn futures have jumped around 5096 since mid-June, reaching a record high in August, while wheat and soy prices also spiked. So far, the impact hasn't shown up in grocery store prices, but it will. Fortunately, the percentage of total food purchase price attributed to agricultural input is less than 1595, so with the exception of raw vegetables, overall food prices aren't expected to skyrocket. When the volatile food and energy prices are stripped out of the index, core CPI rose by just 0.196 in August, and on a year -over -year basis dropped to 1.996, the lowest level in over a year. THE FED Even though the amount of Fed accommodation thus fax has been unprecedented, the markets damored for more. For a majority of economists and traders, it was simply a matter of time before the FOMC announced its latest round of bond purchases. Despite the dubious success of the prior quantitative easing programs, the Federal Open Market Committee announced on September 13, `...that without further policy accommodation, economic growth might not be strong enough to generate sustained improvement in labor market conditions." Fed officials were also concerned about the downside risks associated with the global financial markets. So, to address these concerns, the FOMC committed to purchase an additional $40 billion per month in agency mortgage- backed securities with no set date for purchases to end. In fact, the official statement went on to say, "If the outlook for the labor market does not improve substantially, the Committee will continue its purchases of agency mortgage-backed securities, undertake additional asset purchases, and employ its other policy tools as appropriate..." The FOMC also reiterated that it would continue longer-term asset purchases under the existing "Operation Twist" program until the end of the year, while reinvesting all principal payments from its portfolio of agency debt and mortgage- backed securities back into mortgage-backed securities. These combined — future purchases will increase longer-term security holdings in the Fed's already massive portfolio by approximately $85 billion per month through the remainder of the year. And perhaps even more important to investors on the short end of the curve, the FOMC also announced an extension to — the likely target date for the first rate increase by another six months until "at least mid -2015: - EQUITY MARKETS The anticipation and ultimate announcement of additional Fed easing seemed to have a positive impact on U.S. equity markets, with the broad market S&P 500 closing the quarter less than 8% away from its pre- _ recession all-time high. Nine hundred billion dollars flowed into US. stock markets during the third quarter despite generally disappointing second quarter corporate profits and the prospect for lower profits later - in the year. To some degree, stocks have benefited from a lack of viable investment alternatives, but even now, history makes a compelling ECONOMIC AND INTEREST RATE OUTLOOK It seems like forever; but it was just 1999 when the Congressional Budget Office (CBO) projected that the US. national debt would tum to a $5.6 billion surplus by 2010. With that thought in mind, it only made sense for Congress to vote the American taxpayer a refund and in 2001 and 2003 significant tax reductions were put in place. Since the CBO warned these cuts would turn the projected surpluses into significant deficits, the reductions were scheduled to sunset at the end of2010. But when 2010 rolled around the economy was still struggling mightily, so the cuts were extended — for another two years. In fact, the economy was doing so poorly, that an additional payroll tax cut was granted and subsequently extended Now, unless a sharply divided Congress decides to kick the can further down the road, as much as $600 billion of expiring income tax cuts and capital gains reductions, tax credits and special exemptions, long-term unemployment benefits, a few new taxes and across-the-board spending cuts will all take effect in mass at the beginning of 2013. The nonpartisan Tax Policy Center - concluded that Federal taxes would increase by $536 billion or $3,500 per household next year alone. The impact could drop as much as 4%-5% from GDP Since GDP is estimated to end the year somewhere in the vicinity of 2%, the threat of recession looms. The November elections are expected to - shape how and when the "fiscal cliff" issue is resolved. On the monetary side, the Fed is doing all it can. The tried and true fed f- unds rate cut method has been completely ineffective. Short-term rates have hovered near zero since December 2008, but a collective deleveraging strategy by both households and businesses, combined with tighter credit standards have Largely nullified any positive effect from lower borrowing - costs. No one wants to borrow. But, the Fed has nevertheless pushed out the extended period" during which it expects to hold the overnight funds rate at exceptionally low levels "until at least mid -20157 Fed officials have also launched another round of quantitative easing, but this one doesn't actually have an ending date. Although pundits and politicians have weighed in on the best solution, be it purely fiscal or monetary, or a combination, urrseetainty rules the day. We've never been here before. Ditilas Ped Chairman Richard Fisher gave a speech on monetary policy in lain September. His words, although sobering, were refreshingly honest. argument for equities. In the past 10 years (induding the first three quarters of 2012), the S&P has only suffered a single calendar year of negative returns. Granted, it was a huge 37% loss in 2008 ...but still. 6/30/12 S&P DOW 500 NASDAQ 12,880 1,362 9/30/12 13,437y% % Change for Q3=2012 -f4.3 1,441 +5.8% 2,935 3,1e16 +6+6.2% High 6/30/12 Fed 3 mo 6 mo 2 yr 5 yr 10 yr Funds T-bill T-bill T -note T -note T -note 0.00% 0.08% 0.15% 0.30% 072% 1.65% 0 00% 0.11 % 0.15% 0, 30% 0.82% 1.87% Low End 9/30/12 0.00% 0.07% 0.12% 0.20% 0.54% 1.39% 0.00% 0.09% 0.13% 0.23% 0.63% 1.63% He said, "I believe that with each program we undertake to venture further in that direction, we are sailing deeper into uncharted waters. The troth, however, is that nobody on the committee, nor on our staffs at the Board of Governors and the 12 Banks, really knows what is holding bark the economy. Nobody really knows what will work to get the economy back on course. And nobody, in fact, no central bank anywhere on the planet has the experience of successfully navigating a return home from the place in which we now find ourselves" One virtual certainty (for the next couple of years anyway) is that the US. economy will struggle mightily, regardlesssofwho is elected in November. There is actually a lot less certainty on the interest rate front. With the Fed creating money to fund its asset purchases, which have now swelled to over $2.8 trillion, common sense suggests that market interest rates are poised to rise, but the more likely scenario maybe foryieidstocreep lower still Money market funds and public funds investment pools could see balances soar at year-end when the Dodd -Frank Deposit lnsurance Provision expires. This provision, which provides a full -faith -and -credit government guarantee on non-interest bearing bank deposits, was originally put in place in2608, after the failure of Lehman Brothers. Since this "non-interest bearing rate' doesn't preclude fee credits for compensating balances, and with money market funds yielding next to nothing, many depositors have elected to take advantage of the risk free government guarantee. These accounts have attracted deposits estimated at $1.6 trillion, much of which may be looking for a new home in the short fixed income market Bank of America/ Merrill Lynch thought the massive inflows could push Treasury-billytelds bade'; into negative territory. But, as Federated lua► is CTO Deborah Cunningham told the Wall Street Journal, From a fund -management pens[ ect •e, there are very few options... so there's no real preparations 'But just:ab>out says it all. And finally, Bill Gross of P1IVTCO recently wrote `i don't believe in the imminent demise of the US. economy and its financial markets. Bust;' he adds, I'm afraid for them" Buckle up. The ride may get a little:burrnpy. Scott McIntyre, CFA Senior Portfolio Manager October 5, 2012