The URL can be used to link to this page

Home My WebLink AboutQuarterlyReport_2013-06-30 Financial Report and Investment Report for Quarter Ended June 30, 2013 Executive Summary Quarter ended June 30, 2013 I. Quarterly Financial Analysis General Fund Revenues: General Fund revenues collected during the third quarter of fiscal year 2013 continues to be stronger than prior year with an 8.6% increase. The total revenue collected for the General fund year to date is $31,883,731, or 73.6% of projected year end actuals. Property tax revenues are typically received during the first two quarters of the fiscal year. The amount of revenue is based on the assessed value and is estimated using the County Assessor’s data. Any deviations from estimates in this revenue stream are typically related to new construction and delinquency rates. Property tax revenues are up 10.04% compared to this same time last year. Our collection rate as of April was 96.17% compared to 94.55% last April. Sales tax revenues continue to be higher than projected. General Fund sales tax revenue for the third quarter of fiscal year 2013 is 10.45% higher than prior year for sales during this time frame. This results in an additional $560,000 in the General Fund. Sales tax collections total $6,355,539, representing approximately 69.3% of current year projected year-end balances. The economic recovery is real and ongoing as collections throughout the region are higher than expected. The City collects a 4 – 5% franchise fee on electrical, natural gas, cable, and non-cellular telephone revenues provided by entities other than the City. To date, the City has collected $1,536,889 or 113.4% of current year budget for the third quarter of 2012/13 compared to 94.3% of budget collected this time last year. The City also collects a 3% franchise fee and a 7% return on investment (ROI) fee from the City owned utilities which totaled $1,430,725 and $3,556,565 respectively, for the third quarter, or 64.4% of budget. Franchise fee and ROI collections are up 5.09% compared to prior year, due to increased water revenues; a result of the continued drought. Beginning in 2012/13, the City’s ROI and franchise fee on electric is based on kWh sold instead of revenues generated. Therefore, lower power rates passed through to Georgetown’s electric customers have not adversely impacted revenues in the General Fund. Environmental services revenues are up over 13% from the third quarter of the prior year. This increase is due in part to new rates that went into effect November 1st for commercial customers and December 1st for residential customers. Development related revenue is up 21.39% over the prior year’s third quarter. The prior year’s third quarter residential permits issued year-to-date (YTD) totaled 461 in comparison to 609 for the current year. Court fines are up 4.93% through the third quarter with 5,619 cases processed compared to 5,490 for the same time last year. This increase is due in part to the additional tickets being issued under the STEP grant that began this year. The STEP grant is a traffic enforcement grant through TxDOT that reimburses the City for hours worked for the grant. 1 Overall, General Fund revenues are well ahead of last year’s revenues. YTD revenues are up 8.55% over last year’s third quarter. Staff will continue to monitor revenues as the fiscal year draws to a close. These revenues contribute to the City Manager’s proposed budget for fiscal year 2013/14. General Fund Expenditures: General Fund operating expenditures for the third quarter of 2013 are 7.14% higher than prior year but within budget. General Fund spending for the third quarter shows the City’s continued efforts to manage expenses. The General Fund is projected to have higher expenditures than the prior year due to Public Safety operations, Transportation projects, and the implementation of the compensation study adjusting salaries to market. Total salaries and benefit expenditures through the third quarter were $17.4 million, or 69.9% of projections. An additional $12.7 million, or 75.5% of projections, was spent on operations. Overall, YTD expenditures are 72.2% of projections. The Downtown and Community Services Division provides resources for developing downtown, as well as Parks and Recreation, CVB, and the Library. Year to date expenditures are 71.4% of projections. The Finance and Administration Division includes Municipal Court. Expenditures for the quarter were up 3% compared to the same time period last year. While a frozen customer service representative position was lost through the 2012/13 budget process, salaries were adjusted to market based on the compensation study. Expenditures for Public Safety through the end of June 2013 are 10.8% higher when compared to June 2012, primarily due to the restructured Step Pay increases and nine firefighters that were granted funded for half of last fiscal year. Management Services includes City Management, City Council, Public Information, Planning and social service funding. Total expenditures for the quarter are $3.8 million and are 5.8% lower than prior year. This decrease is due to a position being moved to Downtown and Community Services and due to savings in administrative allocations which reflects an overall decrease in operational expenditures of the Joint Service Fund departments. The Transportation Division includes Transportation Administration and Streets. The expenditures for the division are 10.1% higher than prior year. This increase is due to street maintenance and three positions being unfrozen this year. The Georgetown Utility System division includes Environmental Services and Inspections. Environmental Services manages the contract for solid waste collections. Total expenditures for the quarter were 7.48% higher than prior year due in part to salary adjustments to market. Utility Revenues: Electric revenue through the third quarter of 2013 is down 11.19% compared to prior year. Year to date collections total $34.8 million, or 60.7% of current year projections, compared to $39.2 million received in the prior year. The long standing contract with LCRA for purchased power was terminated in September 2012, resulting in lower power supply costs. The lower cost has been passed through to the customers through the power cost adjustment (PCA). The PCA is changed as needed for fluctuations in fuel and transmission costs. This fiscal year we are billing a negative $0.003/kWh PCA. Year to date, the balance in the rate stabilization fund is $900,089. Water revenue is up from prior year by 11.77%. This year has been a dryer year than this same time last year. Central Texas was still experiencing a drought. As with wastewater, tap revenue and impact fee revenue for water is also up due to increases in development. Tap revenue, which is at 103.3% of budget, is up 82.7% compared to the same period last year. Wastewater revenue is up 7.48% compared to last year. Tap revenue and impact fee revenue are driven by the type of development the City is experiencing. Residential and commercial development has increased for the third quarter of 2013 over the prior year. Tap revenue, which is at 175% of budget, is up 66.3% compared to the same time last year. Utility revenues are significantly impacted by growth and weather conditions. The slight upturn in the economy and housing market continue to impact future growth-related revenues. Staff will monitor these trends over the upcoming months to identify areas that may impact the 2013/14 budget. 2 Other Revenues: Hotel Occupancy Tax revenue is 10.3% higher than prior year due to the opening of the new Holiday Inn Express and Candlewood Suites. Airport revenue has decreased 4.12% compared to prior year due to loss of fuel customers and falling fuel margins. II. Investments Compliance Statement: The investment activity and strategies described in this report are in compliance with the Public Funds Investment Act, City’s investment policy, and generally accepted accounting principles. This report includes the investment position of the City at the end of the third fiscal quarter 2013. Activity for the quarter primarily related to the maturity of higher yielding financial institution deposits (CDs). During the third fiscal quarter of 2013, the City purchased three new financial institution deposits. During the third quarter, the City replaced its $1 million deposit required for power trades at ERCOT with a 1-year renewable Letter of Credit (LOC) issued by Comerica. The LOC provides a more secure holding for the City due to unclear collateralization requirements on funds held by ERCOT. The Investment Report for the Quarter Ended June 30, 2013 and the supporting schedules are attached. A summary of the investment balances at June 30, 2013 compared to the prior quarter is shown below for the City and both component units. CITY GTEC GEDCO 3/31/13 6/30/13 3/31/13 6/30/13 3/31/13 6/30/13 Total cash and security investments $94,533,100 $106,888,428 $10,818,814 $11,875,982 $4,106,308 $4,336,876 Unrealized gain $2,317 $2,055 $726 $327 $391 $257 Realized gain (loss) for quarter $0 $0 $0 $0 $0 $0 The City’s strategy will continue to be to match maturities with cash flow needs, focusing on the investment policy’s long range goals. The Federal Reserve disappointed investors with hints of scaling back asset pruchases. The Federal Open Market Committee (FOMC) revealed at it’s June meeting the beginnings of Fed discussions on how and when to scale back its monthly quantitative-easing (QE) purchases. The FOMC admitted the Fed might start tapering purchses in its “next few meetings” if improvements in economic growth seemed sustainable. Current Government investment pools rates remained between 0.04% and 0.07% for June while deposit rates ranged between 0.30% and 0.40%. CDs still represent the best value for public fund investors. U.S. Agency offerings are coming closer to competing with CDs, but the strategy for public funds should continue to favor CDs. 9/30/12 12/31/12 3/31/13 6/30/13 Managed portfolio yield 0.53% 0.44% 0.40% 0.50% The City’s investment strategy is to “ladder” or stagger maturities, thus minimizing erratic interest rate fluctuations. The current slight unrealized gain in the portfolio is due to higher yielding CDs purchased before market interest rates continued to fall. The interest income from these CDs diversifies and enhances the yields from shorter-term deposits and investments. 3 Total managed portfolio yield was 0.50% on an annualized basis. The overall yield is higher than the yield trend for the 3-month Treasury bill and the local government pools which are currently at 0.05% and 0.08% respectively, as of June 30, 2013. City portfolio balances have increased in the last few years in direct correlation to the increase in contingency reserves and debt proceeds issued for capital improvement projects. The City’s investment portfolio includes bank deposits, local government investment pool balances, money market accounts and financial institution deposits. All of these investments carry insurance or an implied backing from the Federal Government. The collateral on all City investments is monitored at least monthly to ensure the financial institutions carry minimum collateral of 102% of market value of the City’s investments. Currently the City does not own any securities due to the market conditions of these types of investments. Once the City begins purchasing securities, the investment officers will obtain from a reliable source the current credit rating for each held investment that has a PFIA-required minimum rating. All securities held by financial institutions as collateral on behalf of the City were reviewed and met PFIA-minimum rating criteria. The latest strategy to be implemented in the City’s investment program is to retain higher daily balances at the City’s depository bank. These balances earn credit against the fees charged by the bank versus earning interest on these balances. An analysis has been performed verifying that this method is maximizing earnings by negating fees. The City's investment program is conducted to accomplish the following objectives of safety, liquidity, public trust, and yield. It is also the objective of the City to diversify its investments to eliminate the risk of loss resulting from over concentration of assets in a specific maturity, a specific issuer or a specific class of investments. It is the intent of the City to invest its funds to maturity. Lisa Haines, Controller Susan Morgan, Finance Director Micki Rundell, Chief Financial Officer 4 III. Internal Control Internal Control Program: Internal controls are the practices performed by departments to provide management with reasonable assurance that assets are safeguarded and transactions are authorized, valid, complete, and accurate. Elements of a good internal control system include 1) separation of duties; 2) authorization; 3) documentation; and 4) reconciliation. During the 3rd quarter of the fiscal year several audits were performed and reported. These internal audits validate the accuracy and validity of the City’s financial records by detail testing on individual transactions and ensuring compliance with City’s financial and administrative policies. Areas reviewed include:  A travel audit was performed by reviewing individual expense reports and evaluating receipts to ensure compliance with current travel policies.  A credit card audit was done to ensure compliance with current purchasing policies.  Fuel usage was audited comparing gallons purchased with monthly usage to verify amounts.  Petty cash and cash drawer audits were performed at various locations to verify cash on hand.  No material weaknesses or issues were discovered. All identified items have been or are being addressed by each department. IV. Capital Projects Capital Improvement Program: The projects in the Capital Improvement Program (CIP) generally consists of infrastructure and related construction and do not include small capital items such as furniture, equipment, and vehicle maintenance. Maintenance type projects are not capitalized as a fixed asset and are always cash-funded, therefore, are considered operational in nature and are included in the departmental operating budget. A year to date budget status, as well as, project to date information on the approved capital improvement projects is included in the quarterly report showing the current financial report. 5 GENERAL FUND REVENUE & EXPENSE COMPARISON 2012/2013 For the Quarter Ended June 30, 2013 2012-2013 3rd QUARTER PRIOR YEAR 3rd QUARTER TOTAL PRELIMINARY 06/30/13 % ACTUAL 06/30/12 %YTD % BUDGET PROJECTIONS YTD PROJ TOTAL YTD ACTUAL ACTUAL ACTUAL REVENUES: Property Taxes 9,980,000 9,980,000 9,928,516 99.5% 9,053,640 9,022,757 99.7%905,759 10.04% Sales Tax 7,820,000 8,305,000 5,614,549 67.6% 7,802,777 5,043,174 64.6%571,375 11.33% Sales Tax (1/8 cent) 1,043,750 1,043,750 740,990 71.0% 1,034,688 670,929 64.8%70,061 10.44% Franchise Fee/ROI 9,780,502 10,123,793 6,524,180 64.4% 9,829,422 6,207,910 63.2%316,270 5.09% Development & Inspections 955,500 1,224,625 976,577 79.7% 1,236,478 804,475 65.1%172,102 21.39% Court Fines 876,500 721,500 503,775 69.8% 616,815 480,083 77.8%23,692 4.93% Parks & Recreation 2,283,420 2,181,920 1,629,442 74.7% 2,052,750 1,686,684 82.2%-57,242 -3.39% Other 3,273,683 3,467,861 1,907,538 55.0% 3,013,523 1,885,777 62.6%21,761 1.15% REVENUE WITHOUT ENVIRON. SVCS 36,013,355 37,048,449 27,825,567 75.1% 34,640,093 25,801,789 74.5%2,023,778 7.84% Environmental Services 6,826,000 6,289,173 4,058,164 64.5% 5,141,546 3,571,494 69.5%486,670 13.63% TOTAL REVENUES (1)42,839,355 43,337,622 31,883,731 73.6% 39,781,639 29,373,283 73.8%2,510,448 8.55% (1) excludes transfers EXPENSES: DOWNTOWN & COMMUNITY SVCS Personnel 4,590,647 4,578,051 3,039,633 66.4% 3,884,677 2,635,185 67.8%404,448 15.35% Operations 3,328,022 3,328,022 2,608,083 78.4% 3,200,267 2,642,512 82.6%-34,429 -1.30% TOTAL DTOWN & COMM SVCS 7,918,669 7,906,073 5,647,716 71.4% 7,084,944 5,277,697 74.5%370,019 7.01% FINANCE & ADMINISTRATION Personnel 434,148 398,051 280,507 70.5% 370,084 268,875 72.7%11,632 4.33% Operations 117,850 107,280 81,498 76.0% 105,297 82,483 78.3%-985 -1.19% TOTAL FINANCE & ADMIN 551,998 505,331 362,005 71.6% 475,381 351,358 73.9%10,647 3.03% FIRE Personnel 7,386,376 7,417,468 5,260,032 70.9% 5,905,460 4,202,833 71.2%1,057,199 25.15% Operations 1,268,655 1,259,762 1,132,809 89.9% 1,209,184 1,099,298 90.9%33,511 3.05% TOTAL FIRE 8,655,031 8,677,230 6,392,841 73.7% 7,114,644 5,302,131 74.5%1,090,710 20.57% MANAGEMENT SERVICES Personnel 1,501,637 1,585,676 1,123,857 70.9% 1,637,786 1,184,247 72.3%-60,390 -5.10% Operations 3,657,650 3,517,543 2,681,681 76.2% 3,378,767 2,855,482 84.5%-173,801 -6.09% TOTAL MANAGEMENT SVCS 5,159,287 5,103,219 3,805,538 74.6% 5,016,553 4,039,729 80.5%-234,191 -5.80% POLICE Personnel 8,878,207 8,945,271 6,301,895 70.4% 8,378,847 6,148,629 73.4%153,266 2.49% Operations 2,112,337 2,045,378 1,928,712 94.3% 2,013,244 1,747,984 86.8%180,728 10.34% TOTAL POLICE 10,990,544 10,990,649 8,230,607 74.9% 10,392,091 7,896,613 76.0%333,994 4.23% TRANSPORTATION Personnel 1,280,960 1,227,862 864,709 70.4% 1,039,451 765,983 73.7%98,726 12.89% Operations 1,207,079 1,195,879 956,033 79.9% 1,133,069 888,353 78.4%67,680 7.62% TOTAL TRANSPORTATION 2,488,039 2,423,741 1,820,742 75.1% 2,172,520 1,654,336 76.1%166,406 10.06% OPERATING EXP WITHOUT ENVIRON. SVCS. Personnel 24,071,975 24,152,379 16,870,633 69.9% 21,216,305 15,205,752 71.7%1,664,881 10.95% Operations 11,691,593 11,453,864 9,388,816 82.0% 11,039,828 9,316,112 84.4%72,704 0.78% OPERATING EXPENSES 35,763,568 35,606,243 26,259,449 73.7% 32,256,133 24,521,864 76.0%1,737,585 7.09% GUS Personnel 767,790 758,019 536,099 70.7% 642,529 447,353 69.6%88,746 19.84% Operations 6,329,219 5,327,732 3,289,653 61.7% 4,801,484 3,112,262 64.8%177,391 5.70% TOTAL GUS 7,097,009 6,085,751 3,825,752 62.9% 5,444,013 3,559,615 65.4%266,137 7.48% TOTAL OPERATING EXPENSES Personnel 24,839,765 24,910,398 17,406,732 69.9% 21,858,834 15,653,105 71.6%1,753,627 11.20% Operations 18,020,812 16,781,596 12,678,469 75.5% 15,841,312 12,428,374 78.5%250,095 2.01% TOTAL OPERATING EXPENSES (2) 42,860,577 41,691,994 30,085,201 72.2% 37,700,146 28,081,479 74.5%2,003,722 7.14% (2) excludes capital related expenditures VARIANCE 6 MAJOR FUND REVENUE COMPARISON 2012/2013 For the Quarter Ended June 30, 2013 Other Major Funds: 2012/2013 3rd QUARTER PRIOR YEAR 3rd QUARTER TOTAL PRELIMINARY 6/30/13 % ACTUAL 6/30/12 %YTD % REVENUES:BUDGET PROJECTIONS YTD PROJ TOTAL YTD ACTUAL ACTUAL ACTUAL Utility Fund Revenues: ELECTRIC Electric revenue 57,777,014 54,851,106 33,141,270 60.4% 58,403,735 36,836,105 63.1%-3,694,835 -10.03% Electric tap revenue 200,000 245,000 199,709 81.5% 231,163 204,013 88.3%-4,304 -2.11% Electric other revenue 1,960,793 2,261,995 1,495,794 66.1% 2,897,583 2,186,782 75.5%-690,988 -31.60% TOTAL ELECTRIC REVENUE 59,937,807 57,358,101 34,836,773 60.7% 61,532,481 39,226,900 63.7%-4,390,127 -11.19% WATER Water revenue 14,674,689 16,240,000 10,289,636 63.4% 16,432,979 9,720,479 59.2%569,157 5.86% Water tap revenue 280,000 525,000 513,470 97.8% 425,280 281,117 66.1%232,353 82.65% Water other revenue 1,528,650 2,195,053 1,851,041 84.3% 1,786,310 1,319,656 73.9%531,385 40.27% TOTAL WATER REVENUE 16,483,339 18,960,053 12,654,147 66.7% 18,644,569 11,321,252 60.7%1,332,895 11.77% WASTEWATER Wastewater revenue 8,737,623 8,840,683 5,851,690 66.2% 8,593,622 5,696,203 66.3%155,487 2.73% Wastewater tap revenue 180,000 360,000 314,353 87.3% 267,133 189,025 70.8%125,328 66.30% Wastewater other revenue 629,200 1,084,200 970,844 89.5% 973,315 755,138 77.6%215,706 28.57% TOTAL WASTEWATER REVENUE 9,546,823 10,284,883 7,136,887 69.4% 9,834,070 6,640,366 67.5%496,521 7.48% Other Fund Revenues: CVB HOT tax 435,000 477,000 342,865 71.9% 454,531 303,244 66.7%39,621 13.07% Other Revenue 99,370 118,893 114,858 96.6% 86,742 111,688 128.8%3,170 2.84% TOTAL CVB REVENUE 534,370 595,893 457,723 76.8% 541,273 414,932 76.7%42,791 10.31% AIRPORT Fuel revenue 3,026,916 2,421,492 1,677,891 69.3% 2,341,998 1,786,214 76.3%-108,323 -6.06% Leases and Rents 556,100 556,100 409,227 73.6% 522,605 393,664 75.3%15,563 3.95% Other revenue 55,780 64,414 18,839 29.2% 196,342 16,656 8.5%2,183 13.11% TOTAL AIRPORT REVENUE 3,638,796 3,042,006 2,105,957 69.2% 3,060,945 2,196,534 71.8%-90,577 -4.12% TOTAL MAJOR FUND REVENUES 90,141,135 90,240,936 57,191,487 63.4% 93,613,338 59,799,984 63.9%-2,608,497 -4.36% * Does not include transfers VARIANCE 7 CITY BALANCE COMPARISON BY QUARTER - June 30, 2013 Balance Balance Balance Balance INVESTMENT BALANCES BY TYPE 9/30/12 12/31/12 3/31/13 6/30/13 TEXPOOL 94,850 17,804,936 5,112,496 6,974,723 TEXSTAR 12,429,700 11,922,069 14,738,885 23,965,807 JPMORGAN CHASE - Local Depository 7,193,771 5,599,359 5,102,019 6,853,181 ERCOT DEPOSIT - 1,000,000 1,000,000 - VIEWPOINT BANK - Money Market 162,275 162,357 162,410 162,491 COMERICA BANK - Money Market 4,810,282 6,953,104 6,955,352 6,577,846 SOUTHSIDE BANK - Money Market 10,012,256 10,021,325 10,025,506 10,031,126 BBVA COMPASS BANK - Money Market - - 18,000,000 18,006,570 CERTIFICATES OF DEPOSIT - CENTRAL NAT'L BANK 2,005,063 2,008,925 2,011,947 2,013,103 CERTIFICATES OF DEPOSIT - RBANK 10,145,863 10,177,730 7,173,129 7,196,352 CERTIFICATES OF DEPOSIT - COMERICA BANK 21,129,690 18,086,257 18,115,359 12,107,229 CERTIFICATES OF DEPOSIT - SOUTHSIDE BANK - - - 5,000,000 CERTIFICATES OF DEPOSIT - INDEPENDENT BANK - - - 8,000,000 CERTIFICATES OF DEPOSIT - JPMORGAN CHASE 6,102,321 6,120,094 6,135,997 - TOTAL CASH AND INVESTMENTS 74,086,071 89,856,156 94,533,100 106,888,428 Note: Balances shown are at book value. City Investment Balances 6/30/2013 City Types of Investments 6/30/2013 8 PORTFOLIO SUMMARY - By Maturity 11/12 12/13 12/13 12/13 Maturity Time Frame 4th Quarter 1st Quarter 2nd Quarter 3rd Quarter 0-6 Months 42,799,178 70,641,017 77,809,874 81,164,910 6-12 Months 16,640,801 6,549,911 10,689,563 19,723,518 12-18 Months 8,632,437 12,665,228 6,033,663 6,000,000 18-36 Months 6,013,655 - - - 74,086,071 89,856,156 94,533,100 106,888,428 11/12 12/13 12/13 12/13 Liquidity Indicators 4th Quarter 1st Quarter 2nd Quarter 3rd Quarter Weighted Average Maturity 168 102 69 83 Maturities < 12 months 80.23%85.75%93.55%94.40% Long term investments, securities with a 12 month or greater maturity, decreased to 6% for this quarter ended June 30, 2013. Maturities are matched with projected disbursement requirements, such as capital improvement projects and debt service payments, thus maintaining a staggered maturity schedule that hedges the portfolio from market volatility is recommended. Seventy six percent of the portfolio will mature within the next six months, with another 18% maturing within 12 months. These maturities match buildout and funding of current projects, as well as, debt service payments due in February and August. 9 TRANSACTION LISTING - SECURITIES - June 30, 2013 Purchase Maturity / Discount / Par Investment Date Description Call Coupon Value Yield Comments PURCHASES: 5/13/13 Southside Bank - CD 5/13/14 n/a $5,000,000 0.27% Ongoing staggered maturity Source: Operating / Reserves investment strategy 5/15/13 Independent Bank - CD 5/15/15 n/a $2,000,000 0.56% Ongoing staggered maturity Source: Operating / Reserves investment strategy 5/15/13 Independent Bank - CD 8/15/14 n/a $6,000,000 0.46% Ongoing staggered maturity Source: Operating / Reserves investment strategy MATURITIES: 01/17/12 Comerica Bank - CD 4/17/13 n/a $2,000,000 0.63% Ongoing staggered maturity Source: 2010A GO Bond Proceeds investment strategy 06/11/12 Comerica Bank - CD 6/11/13 n/a $4,000,000 0.50% Ongoing staggered maturity Source: 2012 GO Bond Proceeds investment strategy ALL SECURITIES REDEEMED AT MATURITY, THEREFORE NO GAIN OR LOSS WAS REALIZED. 10 3/31/13 Purchase Invest Par Coupon Book Market Book Investment Market Unrealized Date Description Number Maturity Value Yield Value Value Value Yield Value Gain/Loss CERTIFICATES OF DEPOSIT 5/15/13 Independent Bank 220001525 5/15/15 2,000,000 0.56% ------------ ------------2,000,000 2,000,000 Source: Operating / Reserves 5/15/13 Independent Bank 20001523 8/15/14 6,000,000 0.46% ------------ ------------6,000,000 6,000,000 Source: Operating / Reserves 6/21/12 Comerica Bank 3851-1120255-7 6/23/14 0.64% Source: Operating / Reserves 1,500,000 1,507,196 1,507,196 1,509,628 1,509,628 Source: 2012 GO Bonds 1,500,000 1,507,195 1,507,195 1,509,628 1,509,628 5/13/13 Southside Bank 230145 5/13/14 5,000,000 0.27% ------------ ------------5,000,000 5,000,000 Source: Operating / Reserves 10/18/10 Comerica Bank 3851-1063742-3 4/18/14 3,000,000 0.70% 3,019,272 3,019,272 3,024,603 3,024,603 Source: Operating / Reserves 3/24/10 Rbank 10206 3/24/14 2,000,000 1.31% 2,108,972 2,108,972 2,115,894 2,115,894 Source: Operating / Reserves 3/1/12 R Bank 10633 3/1/14 2,500,000 1.31% 2,532,712 2,532,712 2,541,024 2,541,024 Source: Operating / Reserves 1/17/12 Comerica Bank 3851-11120144-3 1/17/14 2,000,000 0.80% 2,018,669 2,018,669 2,022,742 2,022,742 Source: Operating / Reserves 1/17/12 Comerica Bank 3851-11120143-5 10/17/13 0.74% Source: Operating / Reserves 1,500,000 1,512,947 1,512,947 1,515,771 1,515,771 Source: 2011 CO Bonds 500,000 504,316 504,316 505,257 505,257 1/3/13 Central National Bank 2826834 10/3/13 2,000,000 0.60% 2,011,947 2,011,947 2,013,103 2,013,103 Source: Operating / Reserves 3/1/12 R Bank 10632 9/1/13 2,500,000 1.26% 2,531,445 2,531,445 2,539,434 2,539,434 Source: Operating / Reserves 1/17/12 Comerica Bank 3851-1120142-7 7/17/13 2,000,000 0.69% 2,016,092 2,016,092 2,019,601 2,019,601 Source: 2011 CO Bonds 6/11/12 Comerica Bank 3851-1120250-8 6/11/13 4,000,000 0.50% 4,014,984 4,014,984 Matured ------------ Source: 2012 GO Bonds 1/17/12 Comerica Bank 3851-1120141-9 4/17/13 2,000,000 0.63% 2,014,688 2,014,688 Matured ------------ Source: 2010A Bonds 3/31/11 JPMorgan Chase Bank 0100073269258 3/31/13 2,000,000 1.11% 2,045,332 2,045,332 Matured ------------ Source: Operating / Reserves 3/31/11 JPMorgan Chase Bank 0100073269256 3/31/13 4,000,000 1.11% 4,090,665 4,090,665 Matured ------------ Source: 2010A Bonds TOTAL INVESTMENT SECURITIES 33,436,432 33,436,432 34,316,684 34,316,684 TexPool 5,112,496 5,112,956 6,974,723 6,974,932 209 TexSTAR 14,738,885 14,740,742 23,965,807 23,967,653 1,846 TOTAL INVESTMENT BALANCES 53,287,813 53,290,130 65,257,214 65,259,269 2,055 CITY DEPOSITORY JPMorgan Chase**5,102,019 5,102,019 6,853,181 6,853,181 ViewPoint Bank - Money Market 0.20% 162,410 162,410 162,491 0.20% 162,491 Comerica - Money Market 0.20% 6,955,352 6,955,352 6,577,846 0.20% 6,577,846 Southside Bank - Money Market 0.25% 10,025,506 10,025,506 10,031,126 0.25% 10,031,126 BBVA Compass Bank - Money Market 0.30% 18,000,000 18,000,000 18,006,570 0.30% 18,006,570 TOTAL CASH AND INVESTMENT BALANCES 93,533,100 93,535,417 106,888,428 106,890,483 2,055 Balances as of 6/30/13. **Funding of outstanding checks presented for payment, interest earned netted against bank service changes. 6/30/13 INVESTMENTS OUTSTANDING - June 30, 2013 11 TRANSACTION LISTING - INVESTMENT POOLS - June 30, 2013 11/12 12/13 12/13 12/13 4th Quarter 1st Quarter 2nd Quarter 3rd Quarter Balance Market Value Balance Market Value Balance Market Value Balance Market Value Description 9/30/12 9/30/12 12/31/12 12/31/12 3/31/13 3/31/13 6/30/13 6/30/13 Comments TexPool 94,850 94,857 17,804,936 17,806,538 5,112,496 5,112,956 6,974,723 6,974,932 AAA Rated Pool - $1 per $1 value Current value: $1.00003 per $1 TexSTAR 12,429,700 12,431,341 11,922,069 11,923,535 14,738,885 14,740,742 23,965,807 23,967,653 AAA Rated Pool - $1 per $1 value Current value: $1.000077 per $1 (Any changes in market value during quarter were within minimum guidelines unless noted.) 12 Balance Balance Balance Balance INVESTMENT BALANCES BY TYPE 9/30/12 12/31/12 3/31/13 6/30/13 TEXPOOL 6,004,983 7,020,029 7,114,565 9,204,796 TEXSTAR 3,423,330 1,724,052 679,826 668,399 COMERICA BANK - Money Market - 2,001,110 2,001,757 2,002,787 CERTIFICATES OF DEPOSIT - CENTRAL NATIONAL BANK 2,004,219 - - - CERTIFICATES OF DEPOSIT - JPMORGAN CHASE BANK 1,017,053 1,020,016 1,022,666 - TOTAL CASH AND INVESTMENTS 12,449,585 11,765,207 10,818,814 11,875,981 Note: Balances shown are at book value. Liquidity Indicator / Weighted Average to Maturity 16411 Balance Balance Balance Balance INVESTMENT BALANCES BY TYPE 9/30/12 12/31/12 3/31/13 6/30/13 TEXSTAR 2,566,916 2,818,490 3,105,430 3,335,483 COMERICA BANK - Money Market - 1,000,555 1,000,878 1,001,393 CERTIFICATES OF DEPOSIT - CENTRAL NATIONAL BANK 1,002,110 - - - TOTAL CASH AND INVESTMENTS 3,569,026 3,819,045 4,106,308 4,336,876 Note: Balances shown are at book value. Liquidity Indicator / Weighted Average to Maturity 2111 GEDCO Investments GEDCO Weighted Average to Maturity Georgetown Transportation Enhancement Corporation For the Quarter Ended June 30, 2013 Georgetown Economic Development Corporation For the Quarter Ended June 30, 2013 GTEC Investments GTEC Weighted Average to Maturity 13 Georgetown Transportation Enhancement Corporation Investment Report For the Quarter Ended June 30, 2013 Compliance Statement The investment activity and strategies described in this report are in compliance with GTEC’s investment policy and state law. The Investment Report for the Quarter Ended June 30, 2013 and the supporting schedules are attached. Portfolio balances increased 9.8% during the quarter. Due to the decline in market yields, the City has invested in bank deposits outside of the City’s regular depository. Market conditions have created value in these non-depository bank deposits. These deposits are insured or collateralized as required by Policy and state law. Securities purchased in prior quarters have higher yields and thus, contribute to the unrealized market gain in the portfolio. Our investment strategy is to “ladder” or stagger maturities, thus minimizing interest rate risk in the long-term. A summary of the investment balances at June 30, 2013, compared to the prior quarter, is shown below. GTEC 3/31/13 6/30/13 Total cash and security investments $10,818,814 $11,875,982 Unrealized gain $726 $327 Realized gain or loss for quarter $0 $0 Lisa Haines, Controller Susan Morgan, Finance Director Micki Rundell, Chief Financial Officer 14 GTEC BALANCE COMPARISON BY QUARTER - June 30, 2013 Balance INVESTMENT BALANCES BY TYPE 6/30/13 TEXPOOL 9,204,796 TEXSTAR 668,399 COMERICA BANK - Money Market 2,002,787 CERTIFICATES OF DEPOSIT - JPMORGAN CHASE - CERTIFICATES OF DEPOSIT - CENTRAL NATIONAL BANK - TOTAL CASH AND INVESTMENTS 11,875,982 Note: Balances shown are at book value. 12/13 Maturity Time Frame 3rd Quarter 0 - 6 months 11,875,982 6 - 12 months - 11,875,982 Liquidity Indicator Weighted Average Maturity 16 4 1 GTEC TRANSACTION LISTING - SECURITIES - June 30, 2013 Description Comments PURCHASES: There were no purchases this quarter. MATURITIES: There were no maturities this quarter. Balance Balance - 11/12 4th Quarter 11,432,532 1st Quarter 2,004,219 3/31/13 7,114,565 679,826 1,022,666 2,001,757 11,765,207 Coupon Par Investment - 2nd Quarter 10,818,814 Types of Investments Discount / Balance 9/30/12 6,004,983 1,724,0523,423,330 12/31/12 as of 6/30/13 Purchase Maturity / 11,765,207 10,818,814 1 1,017,053 12,449,585 12,449,585 11,765,207 - GTEC Weighted Average to Maturity 2,001,110 - 1,020,016 10,818,814 12/13 12/13 Date Call YieldValue 7,020,029 1,017,053 - 15 GTEC INVESTMENTS OUTSTANDING - June 30, 2013 6/30/13 Purchase Invest Par Coupon Book Market Book Investment Market Unrealized Date Description Number Maturity Value Yield Value Value Value Yield Value Gain/Loss CERTIFICATES OF DEPOSIT 3/31/11 JPMorgan Chase Bank 0100073269257 3/31/13 1,000,000 1.11% 1,022,666 1,022,666 Matured -------------- Source: Operating / Reserves TOTAL INVESTMENT SECURITIES 1,022,666 1,022,666 0 0 TexPool 7,114,565 7,115,205 9,204,796 9,205,072 276 TexSTAR 679,826 679,912 668,399 668,450 51 Comerica - Money Market 0.20% 2,001,757 2,001,757 2,002,787 0.20% 2,002,787 TOTAL INVESTMENT BALANCES 10,818,814 10,819,540 11,875,982 11,876,309 327 Balances as of 6/30/2013. 3/31/13 16 GTEC TRANSACTION LISTING - INVESTMENT POOLS - June 30, 2013 11/12 12/13 12/13 12/13 4th Quarter 1st Quarter 2nd Quarter 3rd Quarter Balance Market Value Balance Market Value Balance Market Value Balance Market Value Description 9/30/12 9/30/12 12/31/12 12/31/12 3/31/13 3/31/13 6/30/13 6/30/13 Comments TexPool 6,004,983 6,005,403 7,020,029 7,020,661 7,114,565 7,115,205 9,204,796 9,205,072 AAA Rated Pool - $1 per $1 value Current value: $1.00003 per $1 TexSTAR 3,423,330 3,423,782 1,724,052 1,724,264 679,826 679,912 668,399 668,450 AAA Rated Pool - $1 per $1 value Current value: $1.000077 per $1 (Any changes in market value during quarter were within minimum guidelines unless noted.) 17 Georgetown Economic Development Corporation Investment Report For the Quarter Ended June 30, 2013 Compliance Statement The investment activity and strategies described in this report are in compliance with GEDCO’s investment policy and state law. The Investment Report for the Quarter ended June 30, 2013, and the supporting schedules are attached. Portfolio balances increased 5.6% during the quarter. Due to the decline in market yields, the City has invested in bank deposits outside of the City’s regular depository. Market conditions have created value in these non-depository bank deposits. These deposits are insured or collateralized as required by Policy and state law. Our investment strategy is to “ladder” or stagger maturities, thus minimizing interest rate risk in the long-term. A summary of the investment balances at June 30, 2013, compared to the prior quarter, is shown below. Lisa Haines, Controller Susan Morgan, Finance Director Micki Rundell, Chief Financial Officer GEDCO 3/31/13 6/30/13 Total cash and security investments $4,106,308 $4,336,876 Unrealized gain $391 $257 Realized gain or loss for quarter $0 $0 18 GEDCO BALANCE COMPARISON BY QUARTER - June 30, 2013 Balance INVESTMENT BALANCES BY TYPE 6/30/13 TEXSTAR 3,335,483 COMERICA BANK - Money Market - 1,001,393 CERTIFICATES OF DEPOSIT - CENTRAL NATIONAL BANK - TOTAL CASH AND INVESTMENTS 4,336,876 Note: Balances shown are at book value. 12/13 Maturity Time Frame 3rd Quarter 0 - 6 months 4,336,876 4,336,876 Liquidity Indicator Weighted Average Maturity 21 1 1 GEDCO TRANSACTION LISTING - SECURITIES - June 30, 2013 Description Comments PURCHASES: There were no purchases this quarter. MATURITIES: There were no maturities this quarter. 1,000,878 11/12 3,569,026 3,819,045 4,106,308 1,000,555 Types of Investments as of 6/30/13 Date Purchase Yield 4th Quarter GEDCO Weighted Average to Maturity 3,819,045 3,569,026 4,106,308 3,569,026 Call Value InvestmentParMaturity / Discount / Coupon 1,002,110 1st Quarter - 4,106,308 12/13 3,819,045 12/13 - 2nd Quarter 12/31/12 Balance 9/30/12 2,818,4902,566,916 3,105,430 Balance 3/31/13 Balance 19 GEDCO INVESTMENTS OUTSTANDING - June 30, 2013 6/30/13 Purchase Invest Par Coupon Book Market Book Investment Market Unrealized Date Description Number Maturity Value Yield Value Value Value Yield Value Gain/Loss CERTIFICATES OF DEPOSIT No current Certificates of Deposit - - - - TOTAL INVESTMENT SECURITIES -- - - TexSTAR 3,105,430 3,105,821 3,335,483 3,335,740 257 Comerica - Money Market 0.20% 1,000,878 1,000,878 1,001,393 0.20% 1,001,393 TOTAL INVESTMENT BALANCES 4,106,308 4,106,699 4,336,876 4,337,133 257 Balances as of 6/30/13. 3/31/13 20 GEDCO TRANSACTION LISTING - INVESTMENT POOLS - June 30, 2013 11/12 12/13 12/13 12/13 4th Quarter 1st Quarter 2nd Quarter 3rd Quarter Balance Market Value Balance Market Value Balance Market Value Balance Market Value Description 9/30/12 9/30/12 12/31/12 12/31/12 3/31/13 3/31/13 6/30/13 6/30/13 Comments TexSTAR 2,566,916 2,567,255 2,818,490 2,818,837 3,105,430 3,105,821 3,335,483 3,335,740 AAA Rated Pool - $1 per $1 value Current value: $1.000077 per $1 (Any changes in market value during quarter were within minimum guidelines unless noted.) 21 Audit Type Total Exceptions Petty Cash Audits Cash boxes audited 1 - N/A Total cash amount 500.00$ Violations - Cash Drawer Audits Drawers audited 7 - N/A Total cash amount 4,176.59$ Violations - Payroll Audits Payrolls audited 1 - N/A Employee pay rates audited 37 Violations - Stipend Audits Payrolls audited 1 - N/A Employee stipends audited 37 Violations - Procurement Card Audits Expense Reports generated 496 One report was missing a receipt. Total dollars spent 268,586.04$ Reports audited 13 Violations 1 Internal Control Summary For the Third Fiscal Quarter 2012/13 22 Grant Description Grantor Grant Amount Match Status Fire Scholarship Grant Texas A&M Forest Service 4,760$ 120$ Pending Library Year 3 Bookmobile funding Texas State Library 75,000$ 5,000$ Received Planning & Development CDBG 2012 University Sidewalks Willamson County 78,900$ -$ Pending Police Bulletproof Vest Partnership (BVP) Office of Justice Program 3,630$ 3,630$ Pending Transportation Ramp Grant TxDOT 50,000$ 50,000$ Pending City of Georgetown Grant Applications as of June 30, 2013 23 BID COUNCIL AMOUNT BID NO. BID NAME DATE APPROVAL AWARDED VENDOR 201310 Design of Data Center at Public Safety Facility 2/8/2013 4/9/2013 $54,600.00 Nexus Data Systems 201311 Concessions for Parks Dept.3/4/2013 N/A A percentage of sales is paid to the City Marie's Concessionaire 201314 Project Manager for Art Center 4/29/2013 N/A $30,000.00 Hughes Amalgamated 201315 Swimming Pool Chemicals 3/15/2013 N/A $35,500.00 Pool Sure 201316 Fire Dept. Program & Service Audit 3/8/2013 N/A $40,309.00 ESCI 201318 2011/12 Streets & Drainage CIP (Reconstruction & Rehabilitation) 4/8/2013 4/23/2013 $567,111.15 Smith Contracting 201320 Downtown Master Plan 4/18/2013 6/11/2013 $75,000.00 Winter & Co. 201324 Project Manager for Art Center 4/18/2013 N/A $30,000.00 Hughes Amalgamated 201325 Tools for Bucket Truck 5/6/2013 N/A $37,299.00 Techline $2,576.00 Altec $7,293.00 TMD City of Georgetown Bids Awarded During 3rd Quarter 2012/13 24 CI T Y O F G E O R G E T O W N CO N T R A C T A C T I V I T Y fo r t h e 3 r d Q u a r t e r 2 0 1 2 / 1 3 EN G I N E E R , A R C H I T E C T , CO N S U L T A N T N A M E FY 2 0 1 3 FI R S T Q U A R T E R EX P E N D I T U R E FY 2 0 1 3 GT E C FIR S T Q U A R T E R EX P E N D I T U R E FY 2 0 1 3 GE D C O FIR S T Q U A R T E R EX P E N D I T U R E F Y 2 0 1 3 SE C O N D Q U A R T E R EX P E N D I T U R E FY 2 0 1 3 GT E C SE C O N D Q U A R T E R EX P E N D I T U R E FY 2 0 1 3 GE D C O SE C O N D Q U A R T E R EX P E N D I T U R E FY 2 0 1 3 TH I R D Q U A R T E R EX P E N D I T U R E FY 2 0 1 3 GT E C TH I R D Q U A R T E R EX P E N D I T U R E FY 2013 GEDCO THIRD QUARTER EXPENDITURE Ar c h i t e c t s D e s i g n G r o u p Wi n t e r P a r k , F l o r i d a $ 1 9 9 , 5 8 7 . 0 7 35 5 , 2 6 4 . 0 4 $ 26 9 , 6 0 4 . 5 1 $ Ag u i r r e & F i e l d s , L P Ro u n d R o c k , T e x a s Al e x a n d e r U t i l i t y E n g i n e e r i n g , I n c . Sa n A n t o n i o , T e x a s 16 , 3 0 0 . 0 0 75 0 . 0 0 Ba k e r - A c i k l e n & A s s o c i a t e s Ro u n d R o c k , T e x a s 11 , 7 9 5 . 5 0 9,9 0 7 . 4 9 20 , 4 4 5 . 0 0 Br i n k l e y S a r g e n t A r c h i t e c t Au s t i n , T e x a s Br o w n & G a y Au s t i n , T e x a s 19 , 4 3 8 . 5 6 17 0 , 2 1 5 . 4 8 12 2 , 0 7 0 . 1 7 Ca m p D r e s s e r a n d M c K e e , I n c . Au s t i n , T e x a s 38 3 , 7 9 5 . 1 5 12 7 , 0 0 1 . 1 0 58 , 8 4 4 . 5 0 Ch a n & P a r t n e r s A u s t i n , Te x a s 3,0 7 5 . 0 0 Di a m o n d S u r v e y i n g Ge o r g eto w n , T e x a s 6,8 0 0 . 0 0 Du n h a m E n g i n e e r i n g Co l l e g e S t a t i o n , T e x a s 15 , 0 0 0 . 0 0 Ga r v e r Fr i s c o , T e x a s Ha y n i e C o n s u l t i n g , I n c . Ro u n d R o c k , T e x a s 50 0 . 0 0 Ha l f f A s s o c i a t e s , I n c . Au s t i n , T e x a s 15 8 , 1 3 4 . 0 3 HD R E n g i n e e r i n g , I n c . Au s t i n , T e x a s 12 , 5 6 3 . 8 3 9,4 1 7 . 5 5 33 , 3 2 0 . 4 4 Hu g g i n s / S e i l e r & A s s o c i a t e s , L P Ro u n d R o c k , T e x a s Hu i t t - Z o l l a r s Au s t i n , T e x a s 4 9 5 . 0 0 21 , 1 5 1 . 8 0 In l a n d G e o d e t i c s Ro u n d R o c k , T e x a s Ka s b e r g , P a t r i c k & A s s o c . , L P Ge o r g eto w n , T e x a s 11 6 , 1 7 0 . 0 0 2 3 , 1 0 0 . 0 0 $ 1 1 2 , 0 1 5 . 3 7 4 3 , 2 6 0 . 0 0 $ 2 1 6 , 5 9 9 . 7 4 3 , 4 7 0 . 0 0 $ Ke n n e d y C o n s u l t i n g Ge o r g e t o w n , T e x a s 1 , 5 7 4 . 0 0 12 , 9 7 3 . 5 0 10 6 , 8 6 6 . 9 0 Ki m l e y - H o r n A u s t i n , Te x a s 2 5 , 0 2 9 . 0 1 16 , 8 7 2 . 6 4 Kl o t z A s s o c i a t e s Au s t i n , T e x a s 1,8 5 6 . 8 5 2 0 , 3 9 8 . 1 5 3 2 , 3 4 0 . 9 9 2 9 , 4 1 0 . 5 5 LU C K D e s i g n T e a m Au s t i n , T e x a s Mc C o r d E n g i n e e r i n g , I n c . Co l l e g e S t a t i o n , T e x a s 15 3 , 6 6 4 . 2 8 19 6 , 5 1 6 . 5 9 M & S E n g i n e e r i n g S p rin g B r a n c h , T e x a s 16 , 2 7 6 . 3 7 42 , 7 3 6 . 2 5 Pr i m e C o n t r o l s , L P Le w i s v i l l e , T X 12 , 7 5 0 . 0 0 Sc h n e i d e r E n g i n e e r i n g , L t d . Bo e r n e , T e x a s 1,1 9 0 . 0 0 St e g e r & B i z z e l l , E n g . G e o r g e t o w n , Te x a s 2 2 , 1 0 4 . 1 5 41 , 9 5 3 . 2 9 41 , 0 7 9 . 7 3 Te r r a c o n Au s t i n , T e x a s 2 3 , 0 6 8 . 0 0 28 , 7 3 0 . 1 8 1 2 , 3 5 4 . 8 2 4 , 8 1 9 . 5 0 We s t i n E n g i n e e r i n g Da l l a s , T e x a s 82 , 7 9 5 . 9 9 14 , 9 5 0 . 9 8 30 , 3 3 5 . 1 0 V all e y V i e w C o n s u l t i n g Hu d d l e s t o n , V A 3,4 0 0 . 0 0 1,4 0 0 . 0 0 Sp e c i a l i z e d P u b l i c F i n a n c e , I n c . Au s t i n , T e x a s Wa n g A r c h i t e c t s Ge o r g e t o w n , T e x a s 1 3 , 7 9 7 . 6 9 6,7 2 1 . 3 5 TR C E n g i n e e r s , I n c . P h i l a d e l p h i a , PA 1 , 9 4 3 . 7 3 6,6 2 5 . 0 0 5,8 0 5 . 0 0 Wa t e r R e s o u r c e s M a n a g e m e n t Au s t i n , T e x a s TO T A L $ 9 3 0 , 4 5 7 . 6 8 $ 2 4 , 9 5 6 . 8 5 $ - $ 1 , 1 3 2 , 5 1 1 . 7 7 $ 8 7 , 9 5 5 . 8 1 $ - $ 1 , 3 7 3 , 0 7 9 . 8 1 $ 3 , 4 7 0 . 0 0 $ - Fi r s t Q u a r t e r T o t a l 9 5 5 , 4 1 4 . 5 3 $ S e c o n d Q u a r t e r T o t a l 1 , 2 2 0 , 4 6 7 . 5 8 $ T h i r d Q u a r t e r T o t a l 1 , 3 7 6 , 5 4 9 . 8 1 $ 25 Outside Legal Firms -Actual Expenses Paid Vendor Fund - Dept Description 1st Qtr 2013 2nd Qtr 2013 3rd Qtr 2013 Total Brown & Hofmeister. LLP Eco Devo - OPS Legal Fees for GEDCO 1,211.67$ 580.00$ 3,147.01$ 4,938.68$ Carls, McDonald & Dalrymp General - Planning Professional Services 29,327.90 17,615.40 8,985.75 55,929.05 Law offices of Kent Sick GTEC - CIP Year end PO SE1 40,749.40 7,586.30 48,335.70 Lloyd, Gosselink, Rachelle Electric- Admin LCRA Dispute 17,326.80 50,929.67 25,534.34 93,790.81 Lucas C Wilson Joint Svcs- In House Legal services Sept.11,250.00 11,250.00 7,500.00 30,000.00 Lynn Ross Smith & Gannaway Joint Svcs- HR HR Legal 270.00 765.00 755.00 1,790.00 McCall, Parkhurst, Horton GCP - Bond Expense General Bonds - 550.73 900.00 1,450.73 Russell & Rodriguez, LLP Water - Admin CTSUD Work 10,576.25 18,438.75 30,582.62 59,597.62 Hurst Savage & Vanderburg Joint Svcs- In House R/E -McKamy property - 2,025.00 287.00 2,312.00 Total 110,712.02$ 109,740.85$ 77,691.72$ 298,144.59$ Amount Amount Amount Vendor Project Billed Received Paid Outstanding Laredo WO Water Oaks Subdivision 2,517.00$ (2,517.00)$ 12/26/2012 - Laredo WO Water Oaks Subdivision 1,375.20 (1,375.20) 12/26/2012 - Laredo WO Water Oaks Subdivision 1,215.00 (1,215.00) 12/26/2012 - Total 5,107.20 (5,107.20) - Texas Engineering Solutions Cimarron Hills 2,168.25 - 2,168.25$ Texas Engineering Solutions Cimarron Hills 585.00 - 585.00$ Texas Engineering Solutions Cimarron Hills 2,455.00 - 2,455.00$ Texas Engineering Solutions Cimarron Hills 20,793.70 (20,793.70) 11/9/2012 - Texas Engineering Solutions Cimarron Hills 6,345.00 (6,344.60) 12/27/2012 0.40 Texas Engineering Solutions Cimarron Hills 13,575.20 (13,575.20) 11/9/2012 - Total 45,922.15 (40,713.50) 5,208.65 Novak Brothers Rivery Park TIRZ 6,210.00 (6,210.00) 6/12/2013 - Novak Brothers Rivery Park TIRZ 2,009.75 (2,009.75) 6/12/2013 - Novak Brothers Rivery Park TIRZ 2,306.75 (2,306.75) 6/12/2013 - Novak Brothers Rivery Park TIRZ 3,937.50 (3,937.50) 6/12/2013 - Novak Brothers Rivery Park TIRZ 8,865.40 (8,865.40) 6/12/2013 - Novak Brothers Rivery Park TIRZ 4,500.00 (4,500.00) 6/12/2013 - Novak Brothers Rivery Park TIRZ 5,805.00 - 5,805.00 Total 33,634.40 (27,829.40) 5,805.00 Total 84,663.75$ (73,650.10)$ 11,013.65$ Legal Expense Analysis - 2012/13 As of June 30, 2013 Reimbursable Legal - 2012/13 As of June 30, 2013 26 2012/13 Capital Improvement Projects  Public Safety/Training Facility o Design documents for construction have been completed. o All plans have been sent to the Planning Department for review and comment. o The bidding process was closed on June 26th and was tabulated. o Bartlett Cocke is finalizing the GMP (Guaranteed Maximum Price).  A preliminary draft was completed and sent for review by the City on July 2nd. o Alternates and value engineering items have been discussed and selections are being determined with the assistance of architects, engineers, and City departments. o Final draft of the GMP, with selected alternates and value added items, will be received from Bartlett Cocke on July 9th. o A final review by the City will be on July 10th. o Presentations of the GMP will be presented to GGAF on July 15th. o A presentation on the progress of the Public Safety Facility will be presented to at the City Council Workshop on July 23rd. Presentation will include:  A complete project review  Progress to date  Projected schedule for beginning construction  A presentation of the GMP  Art Center o Framing and plumbing are nearing completion and plaster is going in the building. o Paint samples are currently being tested. o The outside curb will soon be cut for the ‘saw-tooth’ store front. o The store front is scheduled to be completed within the next few weeks. o Splash pad installation is slated to begin the week of July 15th and should take six weeks to complete. 27 Capital Improvement Projects For the Quarter Ended June 30, 2013 Division Projected Total PTD Project Budget Exp. Enc. Balance Budget Costs Balance Status General Government CIP 6CE Fire Station $0 $83 ($53) ($30)$8,187 $6,378 1,809 Design 6CI Remodel Fire # 2 0 1,455 (1,382)(73)3,361 2,272 1,088 Design 6CM Amp/Fest area SG Park 0 169 (160)(9)2,923 316 2,607 Design 2BW Westside Service Facility 4,000 0 0 0 4,000 0 4,000 Design 6CR Public Safety Training 12,500 1,014 (788)227 15,000 2,229 12,771 In-Process 6BU Old Library Renovations 300 0 0 0 300 0 300 Design 6CN River Trail Expansion 0 10 (10)0000Design 6DA Facility Master Plan 20 0 0 0 20 0 20 Design Parks CIP Bonds 2,404 1,646 (124)1,523 4,544 1,910 2,634 Parks CIP 538 93 11 104 Total General Government CIP $19,762 $4,470 ($2,505)$1,742 $43,308 $16,857 $26,451 Streets / Transportation 1BL NE Inner Loop/ FM971 $0 $464 ($464)$0 $1,328 $1,337 ($9)In-Process 1BM 2010 Street Rehab/Maintenance 875 1 (1)875 3,444 1,219 2,225 Construction 1BP SE 1- Maple to SW Blvd 17 29 (12)(0)1,732 644 1,088 In-Process 1BZ 971 @ Austin Ave 0 30 356 (386)500 653 (153)Pending 1CB SE1/130 Connection 239 960 (184) (538)8,640 2,619 6,021 In-Process 1CC FM 1460 0 456 (476)20 2,500 2,490 10 Complete 1CE Street Maintenance 647 1,196 (873)324 2,866 2,105 761 In-Process 1CF Street Overlay/Microsurfacing 403 1 (1)403 902 80 822 In-Process 1CN Rejuvenate 897 6 (6)897 1,398 501 897 Design 1CO Microsurface 122 152 (152)122 522 921 (399)In-Process 1CP 2012 Street Rehab 0 0 567 (567)0 567 (567)In-Process 1CH Shell Rd intersection imp 0 12 (12)0 156 156 (0)Pending 1CI DB Wood Rd improvement 0 109 21 (131)418 524 (106)Pending 1CQ SE I/L Schemetic Design 0 211 (211)0 0 706 (706)Pending 1CR SW Bypass 29 to Leander 1 1 0 0 1 3 (3)Pending 1CU Cutler Process 131 0 0 131 131 0 131 Design 3BP Forest St WW (5th-7th)0 3 (3)0 70 63 7 Pending 5QB WR Infrastructure 0 1 0 (1)01 (1)In-Process Total Streets $3,562 $3,647 ($1,425)$1,340 $51,361 $30,205 $21,156 Stormwater 5AU Stormwater Inventory $144 $20 $33 $91 $144 $53 $91 In-Process 5AM Curb & Sidewalks 317 208 (208)317 1,565 1,186 379 In-Process 5AF Northwest @ IH35 285 0 0 285 902 45 857 In-Process 5AN Eubank Drainage Improvements 0 1 (1)0 300 216 84 Pending 5AO Stormwater Infrastructure 50 38 (38)50 1,689 249 1,440 Pending 5AT Smith Branch 552 15 10 527 552 25 527 Design 5AP John Thomas & Gabriel View 1 315 (314)0 271 347 (75)Construction 1CJ Austin Ave Sidewalks 96 96 0 0 96 96 0 Construction Total Stormwater $1,446 $706 ($531)$1,270 $9,653 $3,625 $6,027 Wastewater 39A WW Interceptors $2,053 $749 $331 $972 $7,889 $6,094 $1,795 Construction 3BQ San Gab WWTP Generator 801 32 (13)782 1,828 1,046 782 In-Process 3CB Dove Spring Property 0 81 3 (83)083 (83)Purchased 3BR Northern Lands WWTP 0 2 0 (2)02 (2)In-Process 3CA Pecan Branch WWTP 310 407 (407)310 1,578 958 620 Design 3CF Wolf Ranch FM Relocate 0 0 19 (19)019 (19)In-Process 3BX Sun City Ls 4th Pump 140 83 (72)129 903 719 184 Construction 3CD Stonehedge LS & FM 150 0 0 150 150 0 150 Design 3CE Westinghouse LS & FM 196 0 0 196 196 0 196 Design 3CC Lift Station Upgrades 250 0 135 115 1,222 158 1,064 Construction Total Wastewater $3,900 $1,354 ($4)$2,550 $17,267 $10,858 $6,409 Y-T-D 2012/13 (000s)Project to Date (000s) 28 Capital Improvement Projects For the Quarter Ended June 30, 2013 Division Projected Total PTD Project Budget Exp. Enc. Balance Budget Costs Balance Status Y-T-D 2012/13 (000s)Project to Date (000s) Water 1AT 2005 Street Rehab $0 $96 $0 ($96)$103 $207 ($104)Construction 2BB Master Plan Updates 76 36 (36)76 0 0 0 In-Process 2BM LWTP Expansion 0 (351)0 351 * 16,391 9,095 7,296 In-Process 2BV Sun City Pump Upgrade 0 2 (2)(0)26 29 (3)Pending 2BR LWTP Expansion Phase III 0 524 (524)02323(0)In-Process 2BT S.Austin Ave Water lines 465 12 (10)464 1,260 287 974 Complete 2BW Westside Facility 0 805 339 (1,144)73 1,216 (1,143)Purchased 2BU Water- Street Rehab 173 50 0 123 312 56 256 Pending 2BY N. Side Old Town 0 30 (53)23 0 132 (132)Pending 2BZ West Loop (H-1b) ph 1 408 0 0 408 751 0 751 Pending 2CB CTSUD Acquistion 0 3 0 (3)03 (3)In-Process 2CC Park Clear well 100 0 0 100 100 0 100 Design 2CD Sun City EST 2,500 0 0 2,500 2,500 0 2,500 Design 2CE Rabbit Hill EST 75 0 0 75 75 0 75 Design 2CF James Street EST 440 0 60 380 440 60 380 Design 2BX Paige Street 132 0 0 132 132 0 132 Design 42G AMI/CIS Upgrade 0 5 0 (5)05 (5)Complete Total Water $4,369 $1,212 ($227)$3,384 $37,900 $21,602 $16,298 AMI/CIS-Water 42G AMI/CIS Upgrade 0 1,057 (1,057)0 0 0 0 In-Process 2CG Asset Management 1,000 8 0 992 1,000 8 992 In-Process Total Water/AMI/CIS $5,369 $2,276 ($1,284)$4,376 $38,900 $21,610 $17,290 29 Capital Improvement Projects For the Quarter Ended June 30, 2013 Division Projected Total PTD Project Budget Exp. Enc. Balance Budget Costs Balance Status Electric 5-0523-52-301 Mapping $53 $53 ($51)$50 $155 $55 $100 5-0523-52-901 Capacitor Additions 80 155 (49) (25)159 169 (10) 5-0523-52-902 Sectionalizing Equipment 50 78 0 (28)93 164 (72) 5-0523-52-903 Consultant Engineering 200 37 0 163 1,215 1,146 69 5-0523-52-904 Poles, Towers & Fixtures 200 101 0 99 650 450 200 5-0523-52-905 Developer projects 750 864 (25) (89)1,390 2,833 (1,443) 5-0523-52-906 Developer projects reimb (338) (779)0 441 (626) (796)170 5-0523-52-915 Park & Neigh lighting 88 28 0 60 367 370 (3) 9-0580-90-011 OH Conductors & Devices 0 0 0 (0)8,416 6,924 1,492 9-0580-90-012 Underground C&D 0 15 0 (15)11,648 10,795 853 9-0580-90-129 Fire Station #1 split serv 0 33 (10) (23)0 112 (112) 9-0580-90-250 Sun City Fuel Spill 0 23 (15) (8)0 228 (228) 9-0580-90-300 Electrical System Improv 2,570 1,329 (702)1,943 3,850 2,779 1,071 9-0580-90-400 Electrical System Expans 0 0 0 0 960 32 928 9-0582-90-003 Electric Substations 118 24 6 88 2,476 3,321 (845) 9-0582-90-021 Communication Equipment 295 185 (7)117 1,829 2,849 (1,020) 9-0582-90-022 General Engineering 100 74 (47)72 250 172 78 Total Electric $4,166 $2,220 ($900)$2,845 $33,152 $31,839 $1,313 9-0580-91-102 AMI / CIS $0 $906 ($897) ($9)$7,592 $8,252 ($661) 9-0580-91-103 FIS/Asset Mgmt Sys 0 3 (3)0 463 463 0 $0 $908 ($899) ($9)$8,055 $8,716 ($661) Project to Date (000s) Y-T-D 2012/13 (000s) 30 Capital Improvement Projects For the Quarter Ended June 30, 2013 Division Projected Total PTD Project Budget Exp. Enc. Balance Budget Costs Balance Status GTEC 51A Economic Development Projects $1,013 $0 $0 $1,013 $1,954 $0 $1,954 3BP Forest St WW (5th-7th) 0 12 (12)0000Complete 5QB WR Infrastructure 0 324 0 (324)683 1,007 (324)Design 5QC Southwest Bypass 3,059 2 (2)3,059 11,545 3,218 8,327 Design 5QG Arterial SE1: Inner Loop / SH 130 319 55 (55)319 319 0 319 Construction 5QW Wolf Ranch Pkwy Ext 240 6 15 218 1,809 1,111 698 Design 5QX NW Blvd Bridge 0 67 (65) (2)65 26 39 Design 5RC Williams Drive Geteway 3 54 (54)3362(58)Design 5QY NB Front Rd (2338 to Lakeway) 19 0 0 19 269 231 38 Design 5RB ROW - FM 1460 1,500 971 28 501 3,000 1,000 2,000 Purchased 5RE FM 971/Washam 100 0 0 100 100 0 100 Design 5RF Rivery Road 750 21 10 719 750 31 719 Design Total GTEC $7,002 $1,512 ($135)$5,626 $24,743 $10,529 $14,214 Y-T-D 2012/13 (000s)Project to Date (000s) 31