Loading...
HomeMy WebLinkAboutFY 16 - 04 QuarterlyReport_RedactedFINANCIAL REPORT AND INVESTMENT REPORT For the Quarter Ended September 30, 2016 Table of Contents Executive Summary .................................................................................................................................... 1-5 General Fund Schedule ................................................................................................................................. 6 Electric Fund Schedule .................................................................................................................................. 7 Water & Rural Water Fund Schedule ............................................................................................................ 8 Council Discretionary Fund Schedule ............................................................................................................ 9 Convention & Visitors Bureau Fund Schedule ............................................................................................. 10 Airport Fund Schedule ................................................................................................................................. 11 Georgetown Transportation Enhancement Corporation Fund Schedule .................................................... 12 Georgetown Economic Development Corporation Fund Schedule ............................................................. 13 Quarterly Investment Report - City ........................................................................................................ 14-29 Quarterly Investment Report - GTEC ...................................................................................................... 30-36 Quarterly Investment Report - GEDCO ................................................................................................... 37-43 Grant Applications ....................................................................................................................................... 44 Capital Improvement Projects ................................................................................................................ 45-49 Long-term Commitments and Other Unfunded Liabilities ..................................................................... 50-53 Independent Living. Other revenues are up from the prior year due to a payment received from the City of Round Rock for $157,500 due to an interlocal agreement for relocation of the utility on University Drive. Total water revenue is up from the prior year by 2.9%. Water sales are up 7.3% through the fourth quarter due an increase in billed customers (increased by 5.8% from September 2015 to September 2016). Tap revenues are driven by the type of development the City is experiencing. Other revenue is down 15.5% due to large payments received in the prior year from Newland Communities and Teravista. Total wastewater revenue is up 3.2% for fiscal year 2016 compared to last year. Wastewater revenues are up 5.1% due to an increase in billed customers (increased by 5.7% from September 2015 to September 2016). Tap fees are up 38.2% due to payments received for the Summit at Rivery Apartment buildings. Other revenues are down from the prior year due to large payments received in the prior year from Newland Communities and Teravista. Water revenues in the Western District are up 14.1%. Water revenues are up 11.9% due to an increase in billed customers. Tap revenues, which are driven primarily by development, saw a 98.7% increase from September 2015 to September 2016. This significant increase is partially due to an accounting change between the water and rural water funds in 2015. Utility revenues are significantly impacted by growth and weather conditions. The improved economic conditions and housing market continue to positively impact growth-related revenues. Staff will monitor these trends over the upcoming months. Utility Expenditures: The Electric Fund experienced higher purchased power costs than projected. Capital improvement projects are also over budget due to a substation project and increased development. The fund is projected to be $6 million over expenditures. Staff are developing a plan to bring the fund into balance and to cover the 75 day contingency reserve. The Water Fund is within budget for 2016. The capital improvement program expenditures of $12.5 million lags significantly behind budget of $41.3 million. Staff are preparing a FY 2017 budget amendment that will reappropriate these funds. Other Revenues: Hotel Occupancy Tax revenue is up 23.7%, or $168,565 from the prior year. Airport revenue is up 10.7% from the prior year, due in part to ramp grants received in December 2015 and February 2016. II. Investments The investment activity and strategies described in this report are in compliance with the Public Funds Investment Act (PFIA), City’s investment policy, and generally accepted accounting principles. Activity for the fourth quarter of fiscal year 2016 includes the maturing of eight financial institution deposits (CD’s) totaling $17.2M and the purchase of one new CD for $3.0M. The Investment Reports for the quarter ended September 30, 2016 and the supporting schedules are attached. Valley View Consulting, L.L.C., has prepared the attached investment reports. A component of our investment advisory services contract includes Valley View preparing the quarterly investment reports on behalf of the City. A summary of the investment balances at September 30, 2016 compared to the prior quarter is shown below for the City as well as Georgetown Transportation Enhancement Corporation (GTEC) and Georgetown Economic Development Corporation (GEDCO). CITY GTEC GEDCO 6/30/16 9/30/16 6/30/16 9/30/16 6/30/16 9/30/16 Total cash and investments $145,542,025 $123,230,402 $26,716,518 $26,395,630 $9,212,429 $9,518,021 Average Yield 0.51% 0.51% 0.54% 0.60% 0.40% 0.46% 3 The City’s strategy continues to be matching maturities with cash flow needs, while focusing on the investment policy’s long range goals. The City’s investment strategy is to “ladder” or stagger maturities, thus minimizing erratic interest rate fluctuations. City portfolio balances have increased in the last few years in direct correlation to the increase in contingency reserves and debt proceeds issued for future 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 for 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 City maintains a $2 million Letter of Credit at the Electric Reliability Council of Texas (ERCOT) in lieu of maintaining an unsecured deposit with that agency to comply with fiscal surety requirements. The City continues it’s banking fee reduction strategy by retaining 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 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. III. Capital Projects The projects in the Capital Improvement Program (CIP) consist 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 usually cash funded. Therefore, they are considered operational in nature and are included in the departmental operating budget. A year-to-date budget status for each of the approved projects is included in the quarterly report, including the following: DOWNTOWN & COMMUNITY SERVICES Project 1DG Rivery Sheraton Garage: The Sheraton at Rivery is the City of Georgetown’s first Hotel/Conference Center. They received their final CO on June 27th and they have been in full operations since late July. The Parking Garage is one component of the project that will add approximately 340 public parking spaces. The City has entered into an agreement with the Developer of the Hotel/Conference Center to reimburse them for the construction of the Parking Garage with ownership transferring to the City upon its completion. To date the City has reimbursed 96% of the direct costs associated with the Garage. Grace Heritage Center Restoration: As the historic downtown continues to grow, Grace Heritage Center is emerging as a key landmark and component of the Downtown District. Since the circa 1881 building was donated to the City of Georgetown in 1995 and moved to its current site, the City has performed preventative maintenance, but has not undertaken a comprehensive approach to the restoration of the structure. City Council has approved contracting with G. Creek Construction, partnering with ARCHITEXAS for a Design/Build contract for the restoration of Grace Heritage Center. The City is currently negotiating the contract with G Creek and plans to kick off design as soon as the contract is finalized. PARKS Project 6CP San Gabriel Park Improvements: A master plan for improvements to San Gabriel Park was completed in 2015. The master plan proposed the improvements be completed in phases due to the high usage and the many events that take place 4 in the park. The schematic design for phase 1 and 2 was completed in April 2016. Funds for Phase 1 construction have been budgeted at $2.7 million. Construction plans for Phase 1 have been submitted for review to the Planning Department. Construction is expected to begin in early 2017. Phase 1 improvements include spring restoration, pavilions, road realignment, play areas, restroom and parking. Project 6DO Garey Park: In 2004, Mr. and Mrs. Jack Garey announced they would donate their 525 acre ranch and $5 million to the City of Georgetown for a public park. In 2008, the citizens passed a parks bond with $10 million dedicated for the construction of Garey Park. A master plan was completed in 2005 that set the stage for how the park would be developed. The project was bid in October 2016 and bids received were excessively over budget. Some amenities in the park will need to be deferred at this time due to available budget. The rebidding of the project will take place in early January with a projected ground breaking in March 2017. The construction project is estimated to be $13.5 million. ELECTRIC With increased growth in Georgetown, new development projects are thriving, causing expenses to exceed budget for the fiscal year. These expenses include new development projects totaling over $800K, as well as an unbudgeted LCRA Substation purchase of over $1M. WATER The Berry Creek Interceptor design is 50% complete and easement acquisition is in progress. Construction is estimated to start in summer 2017. The Stonehedge and Westinghouse lift station project bid will go to the Board and Council in November. Construction estimated to start around January 2017. The Pecan Branch wastewater treatment plant project should be ready to bid in April 2017. The Shell Road and CR 255 water main designs are 50% complete and easement acquisition is in progress. Construction estimated to start summer 2017. The Domel water treatment plant design is 90% complete. Construction is estimated to start April 2017. 5 YEAR-END YEAR-END APPROVED SEPTEMBER-16 YEAR TO DATE YEAR-END VARIANCE % VARIANCE BUDGET W/ENCUMB W/ENCUMB PROJECTION FAV(UNFAV)FAV(UNFAV) BEGINNING BALANCE 9,599,307 10,168,638 10,168,638 569,331 5.9% REVENUES Property Tax 11,636,698 551,582 11,636,698 11,673,060 (36,362)(0.3%) Sales Tax 12,113,449 3,330,299 12,679,188 12,357,361 321,827 2.7% Sanitation Revenue 6,534,000 860,141 6,815,778 6,827,000 (11,222)(0.2%) Transfer In - ROI & Other 8,548,263 1,955,239 8,909,975 8,612,503 297,472 3.5% Franchise Fees 5,129,030 989,732 4,926,316 4,960,206 (33,890)(0.7%) Development and Permit Fees 2,392,400 599,702 2,118,775 2,387,950 (269,175)(11.3%) Parks and Rec Fees 2,112,000 77,978 2,247,735 2,099,553 148,182 7.0% All Other Revenue 3,200,020 471,495 3,348,466 3,308,340 40,126 1.3% Administrative Charges 2,102,100 0 1,722,431 2,102,100 (379,669)(18.1%) Total Revenues 53,767,960 8,836,169 54,405,361 54,328,073 77,287 0.1% EXPENSES Administrative Services 896,542 92,916 892,961 896,542 3,581 0.4% Animal Services 913,111 77,244 863,080 913,111 50,031 5.5% Arts & Culture 74,771 12,034 86,706 74,771 (11,935)(16.0%) City Council 156,641 7,551 156,205 156,641 436 0.3% City Secretary 545,961 61,260 487,058 545,961 58,903 10.8% Code Enforcement 411,753 13,214 367,106 411,753 44,647 10.8% D&CS Admin 637,790 74,238 578,759 637,790 59,031 9.3% Environmental Services 5,624,432 994,381 5,924,615 5,624,432 (300,183)(5.3%) Fire Emergency Services 9,574,123 817,394 9,558,468 9,574,123 15,655 0.2% Fire Support Services 2,236,560 218,066 2,257,043 2,236,560 (20,483)(0.9%) General Gov't Contracts 3,414,415 266,445 3,053,284 3,414,415 361,131 10.6% Inspections 1,169,797 86,421 976,012 1,169,797 193,785 16.6% Library 2,172,357 178,152 2,132,044 2,172,357 40,313 1.9% Municipal Court 561,439 58,074 541,209 561,439 20,230 3.6% Parks 2,287,013 176,653 2,193,266 2,287,013 93,747 4.1% Parks Admin 392,812 33,870 395,264 392,812 (2,452)(0.6%) Planning 938,880 115,739 964,022 938,880 (25,142)(2.7%) Police Admin 2,823,180 98,858 2,750,481 2,823,180 72,699 2.6% Police Operations 9,852,456 978,650 9,572,430 9,852,456 280,026 2.8% Public Communications 427,117 46,085 385,529 427,117 41,588 9.7% Public Works 649,026 78,596 629,068 649,026 19,958 3.1% Rec Programs 1,390,554 89,191 1,279,445 1,390,554 111,109 8.0% Recreation 2,492,049 155,433 2,369,601 2,492,049 122,448 4.9% Streets 3,789,723 311,362 3,603,267 3,789,723 186,456 4.9% Tennis Center 396,954 28,990 380,258 396,954 16,696 4.2% Transfers 1,512,955 107,125 1,531,334 1,512,955 (18,379)(1.2%) Total Non-Operating Expenditures 55,342,411 5,177,942 53,928,514 55,342,411 1,413,897 2.6% EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS (1,574,451)3,658,228 476,847 (1,014,338)1,491,185 (94.7%) ENDING BALANCE 8,024,856 10,645,485 9,154,300 1,491,185 16.3% CONTINGENCY 7,925,000 7,925,000 ECONOMIC STABILITY RESERVE 0 500,000 General Fund Preliminary Actual to Year End Projection as of September 2016 AMENDED YEAR-END YEAR-END APPROVED SEPTEMBER-16 YEAR TO DATE YEAR-END VARIANCE % VARIANCE BUDGET W/ENCUMB W/ENCUMB PROJECTION FAV(UNFAV)FAV(UNFAV) BEGINNING BALANCE 13,415,841 13,415,841 13,415,841 0 0.0% OPERATING REVENUE Electric Revenue 63,400,000 9,835,659 61,570,923 64,110,890 (2,539,967)(4.0%) Other Revenue 1,782,350 1,558,916 3,777,713 1,782,350 1,995,363 112.0% Interest 17,425 4,449 25,079 17,425 7,654 43.9% Total Operating Revenue 65,199,775 11,399,024 65,373,714 65,910,665 (536,951)(0.8%) OPERATING EXPENDITURES Purchased Power 34,000,000 7,401,498 42,622,904 34,000,000 (8,622,904)(25.4%) Georgetown Utility Systems 15,803,180 846,391 14,714,825 15,803,180 1,088,355 6.9% Transfer Out - General Fund 4,945,813 1,096,949 5,004,097 4,945,813 (58,284)(1.2%) Other Transfers Out 353,008 17,277 129,108 353,008 223,900 63.4% Transfer Out - ISF 311,845 77,961 311,845 311,845 0 0.0% Transfer Out - GCP 225,000 56,250 225,000 225,000 0 0.0% CIS Implementation 134,000 2,954 63,632 134,000 70,368 52.5% CRR Credits 0 (89,373)(2,301,821)0 2,301,821 100.0% Total Operating Expenditures 55,772,846 9,409,906 60,769,589 55,772,846 (4,996,743)(9.0%) TOTAL NET OPERATIONS 9,426,929 1,989,118 4,604,125 10,137,819 4,459,792 47.3% NON-OPERATING REVENUE Bond Proceeds 1,500,000 0 1,761,132 1,500,000 261,132 17.4% Total Non-Operating Revenue 1,500,000 0 1,761,132 1,500,000 261,132 17.4% NON-OPERATING EXPENDITURES Operating Capital Improvements 11,058,000 3,167,350 8,596,647 8,883,000 286,353 2.6% Debt Issuance Costs 16,800 0 84,662 16,800 (67,862)(403.9%) Debt Payments 3,470,507 (8,413)3,406,348 3,470,507 64,159 1.8% Total Non-Operating Expenditures 14,545,307 3,158,936 12,087,657 12,370,307 282,650 1.9% TOTAL NET NON-OPERATIONS (13,045,307)(3,158,936)(10,326,525)(10,870,307)(21,518)0.2% EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS (3,618,378)(1,169,819)(5,722,400)(732,488)(4,989,912)137.9% ENDING BALANCE 9,797,463 7,693,441 12,683,353 (4,989,912)(39.3%) RATE STABILIZATION/CREDIT RESERVE 5,000,000 4,775,000 CONTINGENCY 4,775,000 5,000,000 Electric Fund Preliminary Actual to Year End Projection as of September 2016 AMENDED YEAR-END YEAR-END APPROVED SEPTEMBER-16 YEAR TO DATE YEAR-END VARIANCE % VARIANCE BUDGET W/ENCUMB W/ENCUMB PROJECTION FAV(UNFAV)FAV(UNFAV) BEGINNING BALANCE 49,698,815 49,698,815 49,698,815 0 0.0% OPERATING REVENUE Water Utility Revenue 22,500,000 3,280,602 24,942,260 22,500,000 2,442,260 10.9% Wastewater Utility Revenue 9,399,394 1,344,316 9,732,012 9,399,394 332,618 3.5% Capital Recovery Fee 5,945,574 1,272,868 6,313,555 5,945,574 367,981 6.2% Other Revenue 3,341,051 346,066 3,379,146 3,341,051 38,095 1.1% Irrigation Utility Revenue 204,428 63,074 259,810 204,428 55,382 27.1% Interest 119,232 25,074 225,704 119,232 106,472 89.3% Raw Water Revenue 140,000 30,689 186,853 140,000 46,853 33.5% Transfer In, Debt 100,000 0 106,695 100,000 6,695 6.7% Transfer In, Utilities 293,008 17,277 69,108 293,008 (223,900)(76.4%) Total Operating Revenue 42,042,687 6,379,965 45,215,145 42,042,687 3,172,458 7.5% OPERATING EXPENDITURES Water Administration 11,871,918 (1,371,771)11,795,779 12,582,808 787,029 6.6% Rural Water Admin 3,922,196 (582,163)3,026,448 3,922,196 895,748 22.8% Wastewater Plant Management 2,733,106 63,780 2,341,044 2,733,106 392,062 14.3% Water Plant Management 2,632,741 117,259 2,242,418 2,632,741 390,323 14.8% Transfer Out, ROI 2,420,817 677,628 2,704,418 2,420,817 (283,601)(11.7%) Water Distribution 2,267,236 322,344 3,013,380 2,267,236 (746,144)(32.9%) Wastewater Distribution 1,891,090 193,669 1,861,618 1,891,090 29,472 1.6% Rural Water Operations 1,336,848 101,912 1,150,530 1,336,848 186,318 13.9% Transfer Out, ISF 1,167,710 291,928 1,167,710 1,167,710 0 0.0% Transfer Out, General 425,000 106,250 425,000 425,000 0 0.0% Irrigation 308,386 22,223 216,889 308,386 91,497 29.7% Rural Water Systems Engineering 192,700 27,645 277,606 192,700 (84,906)(44.1%) Rural Water Technical Services 158,642 6,586 123,099 158,642 35,543 22.4% Rural Water Customer Care 113,850 162 94,852 113,850 18,998 16.7% Total Operating Expenditures 31,442,240 (22,546)30,440,792 32,153,130 1,712,338 5.4% TOTAL NET OPERATIONS 10,600,447 6,402,512 14,774,353 9,889,557 1,460,119 13.8% NON-OPERATING REVENUE Special Improvement Fees 642,373 79,860 639,248 642,373 (3,125)(0.5%) Bond Proceeds 6,000,000 0 7,858,868 6,000,000 1,858,868 31.0% Total Non-Operating Revenue 6,642,373 79,860 8,498,116 6,642,373 1,855,743 27.9% NON-OPERATING EXPENDITURES CIP 41,294,500 3,257,367 13,491,623 43,469,500 29,977,877 72.6% Debt Service 4,635,034 15,163 4,735,521 4,635,034 (100,487)(2.2%) Total Non-Operating Expenditures 45,929,534 3,272,531 18,227,144 48,104,534 29,877,390 (62.1%) TOTAL NET NON-OPERATIONS (39,287,161)(3,192,671)(9,729,028)(41,462,161)(28,021,648)71.3% EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS (28,686,714)3,209,841 5,045,325 (31,572,604)36,617,929 (127.6%) ENDING BALANCE 21,012,101 54,744,140 18,126,211 36,617,929 202.0% CONTINGENCY 4,565,000 4,565,000 Water & Rural Water Funds Preliminary Actual to Year End Projection as of September 2016 YEAR-END YEAR-END APPROVED SEPTEMBER-16 YEAR TO DATE YEAR-END VARIANCE % VARIANCE BUDGET W/ENCUMB W/ENCUMB PROJECTION FAV(UNFAV)FAV(UNFAV) BEGINNING BALANCE 0 0 0 0 0.0% REVENUE Interest 0 63 649 0 649 0.0% Total Revenue 0 63 649 0 649 0.0% TRANSFERS IN Transfer In, General Fund 1,085,045 0 1,085,045 1,085,045 0 0.0% Total Transfers In 1,085,045 0 1,085,045 1,085,045 0 0.0% TRANSFERS OUT Transfer Out, GCP 150,000 0 150,000 150,000 0 0.0% Transfer Out, Joint Services 250,000 0 250,000 250,000 0 0.0% Transfer Out, General Fund 500,000 0 500,000 500,000 0 0.0% Total Transfers Out 900,000 0 900,000 900,000 0 0.0% EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS 185,045 63 185,694 185,045 649 0.4% ENDING BALANCE 185,045 185,694 185,045 0 0.0% Council Discretionary Fund Preliminary Actual to Year End Projection as of September 2016 9 AMENDED YEAR-END YEAR-END APPROVED SEPTEMBER-16 YEAR TO DATE YEAR-END VARIANCE % VARIANCE BUDGET W/ENCUMB W/ENCUMB PROJECTION FAV(UNFAV)FAV(UNFAV) BEGINNING BALANCE 488,178 488,178 488,178 0 0.0% REVENUES Hotel/Motel Occupancy Tax Revenues 860,000 152,878 884,317 879,628 4,689 0.5% Poppy Festival 125,000 740 145,015 145,015 (0)(0.0%) Interest 1,500 148 1,541 1,500 41 2.7% Other 8,000 766 11,764 8,000 3,764 47.0% Total Revenues 994,500 154,532 1,042,636 1,034,143 8,493 0.9% EXPENDITURES Personnel 336,778 34,185 311,542 336,778 25,236 7.5% Operations 298,612 60,313 370,461 315,432 (55,029)(18.4%) Capital 100,000 0 25,000 100,000 75,000 75.0% Poppy Festival 85,000 452 122,575 122,575 (0)(0.0%) Transfer to General Capital Projects 100,000 25,000 100,000 100,000 0 0.0% Transfer to General Fund 10,000 2,500 10,000 10,000 0 0.0% Transfer to Fleet 29,620 0 26,800 26,800 0 0.0% Transfer to Information Technology 27,364 6,700 26,564 26,564 0 0.0% Transfer to Facilities 48,751 0 48,751 48,751 0 0.0% Total Expenditures 1,036,125 129,151 1,041,694 1,086,900 45,206 4.4% EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS (41,625)25,381 943 (52,757)(53,700)(129.0%) ENDING BALANCE 446,553 489,121 435,421 53,700 12.0% CONTINGENCY 200,000 200,000 Convention & Visitors Bureau Fund Preliminary Actual to Year End Projection as of September 2016 YEAR-END YEAR-END APPROVED SEP-16 YEAR TO DATE YEAR-END VARIANCE % VARIANCE BUDGET W/ENCUMB W/ENCUMB PROJECTION FAV(UNFAV)FAV(UNFAV) BEGINNING BALANCE 748,167$ 792,318$ 792,318$ 44,151$ 5.9% OPERATING REVENUE Fuel and Terminal Sales 2,876,150 192,275 2,040,675 1,988,444 52,231 2.6% Leases and Rentals 657,400 66,222 709,054 707,049 2,005 0.3% Interest and Other 67,400 92,265 117,054 63,738 53,316 83.6% Total Operating Revenue 3,600,950 350,762 2,866,783 2,759,231 107,552 3.9% OPERATING EXPENDITURES Personnel 321,471 30,072 302,418 317,632 15,214 4.8% Operations-Fuel 2,448,882 (1,014,454)1,533,284 1,549,525 16,241 1.0% Operations-Non Fuel 644,679 21,418 584,598 661,791 77,193 11.7% Transfers Out 15,080 3,770 15,080 15,080 0 0.0% Total Operating Expenditures 3,510,334 (959,194)2,435,379 2,544,028 108,649 4.3% TOTAL NET OPERATIONS 90,616 1,309,957 431,403 215,203 216,200 100.5% NON-OPERATING REVENUE Grants 25,000 0 50,000 50,000 0 0.0% TxDot Refunds 0 0 40,229 0 40,229 0.0% Total Non-Operating Revenue 25,000 0 90,229 50,000 40,229 80.5% NON-OPERATING EXPENDITURES One Time 0 0 6,080 6,080 0 0.0% Airport Master Plan 0 21,329 21,329 0 (21,329)#DIV/0! Runway Lights 757,935 0 750,000 757,935 7,935 1.0% Fuel Farm 100,000 0 87,705 100,000 12,295 12.3% Debt Service 80,222 0 139,101 139,657 556 0.4% Software 20,000 0 0 10,000 10,000 100.0% Total Non-Operating Expenditures 958,157 21,329 1,004,215 1,013,672 9,457 0.9% TOTAL NET NON-OPERATIONS (933,157)(21,329)(913,986)(963,672)49,686 5.2% EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS (762,319)$ 1,288,628$ (482,582)$ (748,469)$ 265,887$ 35.5% ENDING BALANCE (14,152)309,736 43,849 265,887 606.4% Airport Operations Fund Preliminary Actual to Year-End Projection as of September 2016 11 YEAR-END YEAR-END APPROVED SEP-16 YEAR TO DATE YEAR-END VARIANCE % VARIANCE BUDGET W/ENCUMB W/ENCUMB PROJECTION FAV(UNFAV)FAV(UNFAV) BEGINNING BALANCE 8,592,116 8,528,267 8,528,267 (63,849)(0.7%) OPERATING REVENUE Sales Tax 5,381,250 983,924 5,317,862 5,625,000 (307,138)(5.5%) Public Improve. District Assessments 500,000 0 0 500,000 (500,000)NA Interest 15,000 9,535 85,388 63,307 22,081 34.9% Reimbursement from TXDOT 450,000 0 97,867 450,000 (352,133)(78.3%) Miscellaneous Revenue 0 2,143 2,143 0 2,143 NA Total Operating Revenue 6,346,250 995,602 5,503,260 6,638,307 (1,135,047)(17.1%) OPERATING EXPENDITURES Administrative Support 376,132 0 124,647 124,901 254 0.2% Debt Service 2,572,312 0 2,578,861 2,638,581 59,720 2.3% Total Operating Expenditures 2,948,444 0 2,703,509 2,763,482 59,973 2.2% TOTAL NET OPERATIONS 3,397,806 995,602 2,799,751 3,874,825 (1,075,074)(27.7%) NON-OPERATING REVENUE Debt Proceeds (FY16)17,500,000 0 11,217,429 11,659,167 (441,738)(3.8%) Total Non-Operating Revenue 17,500,000 0 11,217,429 11,659,167 (441,738)(3.8%) NON-OPERATING EXPENDITURES ROW 1460 (FY12)500,000 0 1,097,378 500,000 (597,378)(119.5%) FM 1460 Widening (FY15)61,000 0 3 61,000 60,997 100.0% SW Bypass-SH 29 to RM 2243 (FY14)1,332,579 2,799 1,796,042 1,332,579 (463,463)(34.8%) SW Bypass-SW Inner Loop 29 (FY15)0 0 8,585 8,585 0 0.0% SW Bypass-2243 to IH35 (FY06)1,121,000 2,272 12,192 1,121,000 1,108,808 98.9% Arterial SE 1-Inner Loop (FY04)0 0 2,183 2,036 (147)(7.2%) FM 971 Northwest-Washam IH35 (FY09)91,590 0 0 91,590 91,590 NA Wolf Ranch Pkwy Ext - DB Wood (FY10)283,350 0 0 0 0 NA Snead Dr (FY11)20,000 0 46 46 0 0.0% Williams Dr Gateway (FY13)794,000 0 215 794,000 793,785 100.0% Rivery-Ext Williams Dr to NW Blvd (FY16)1,500,000 282,619 2,584,092 1,590,966 (993,126)(62.4%) Rivery-TIA Improvements (FY16)1,400,000 0 239,800 239,800 0 0.0% Rivery 721,000 721,000 721,000 721,000 0 0.0% SH 29 Int.-IH35 to Haven Ln (FY14)650,000 0 0 0 0 NA Pecan Center Dr to Airport Rd (FY15)6,364,000 0 0 2,000,000 2,000,000 NA Mays St (FY15)10,150,000 426,013 6,878,735 6,375,089 (503,646)(7.9%) Available for Projects TBD 1,345,312 0 0 0 0 NA Total Non-Operating Expenditures 26,333,831 1,434,704 13,340,270 14,837,691 1,497,421 10.1% TOTAL NET NON-OPERATIONS (8,833,831)(1,434,704)(2,122,841)(3,178,524)1,055,683 (33.2%) EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS (5,436,025)(439,102)676,910 696,301 (19,391)(2.8%) ENDING BALANCE 3,156,091 9,205,177 9,224,568 (19,391)(0.2%) RESERVED ENDING BALANCE 1,474,063 Georgetown Transportation Enhancement Corporation Fund Preliminary Actual to Year-End Projection as of September 2016 YEAR-END YEAR-END APPROVED SEP-16 YEAR TO DATE YEAR-END VARIANCE % VARIANCE BUDGET W/ENCUMB W/ENCUMB PROJECTION FAV(UNFAV)FAV(UNFAV) BEGINNING BALANCE 5,370,479 5,378,900 5,378,900 8,421 0.2% OPERATING REVENUES Sales Tax 1,345,313 374,511 1,464,844 1,406,750 58,094 4.1% Interest 7,500 3,638 27,882 24,244 3,638 15.0% Miscellaneous Revenue 0 10 59,968 59,958 10 0.0% Lease Revenue (Grape Creek)48,000 0 44,000 48,000 (4,000)(8.3%) Total Operating Revenues 1,400,813 378,159 1,596,694 1,538,952 57,742 3.8% OPERATING EXPENDITURES Debt Service 106,694 0 106,695 106,695 0 NA Bond Issuance Costs 87,500 0 18,224 18,224 0 NA Interlocal Agreement 211,200 0 136,611 136,611 0 NA Supplies 300 0 2 2 0 NA Ads, Notices, Recording Fees 0 0 56 56 0 NA Special Services 7,500 0 0 0 0 NA Travel & Training 1,500 0 730 730 0 NA Promotional & Marketing Program 81,000 17,690 63,296 58,406 (4,890)(8.4%) Miscellaneous Expense 2,500 0 11,429 11,429 0 NA Total Operating Expenditures 498,194 17,690 337,043 332,153 (4,890)(1.5%) TOTAL NET OPERATIONS 902,619 360,469 1,259,651 1,206,799 62,632 5.2% NON-OPERATING REVENUES Bond Proceeds 3,100,000 0 2,977,185 2,977,185 0 NA Premium on Bond Issuance 0 0 141,562 141,562 0 NA Total Non-Operating Revenues 3,100,000 0 3,118,747 3,118,747 0 NA NON-OPERATING EXPENDITURES Catalyst 71,000 71,000 71,000 71,000 0 NA DisperSol 200,000 0 20,000 20,000 0 NA Economic Development Projects -Undetermined 3,988,774 0 0 0 0 NA Georgetown ISD 109,496 0 0 15,649 15,649 100.0% Rivery 4,500,000 4,500,000 4,500,000 4,500,000 0 NA Tasus 67,500 0 0 0 0 NA Texas Life Sciences 100,000 0 100,000 100,000 0 NA Total Non-Operating Expenditures 9,036,770 4,571,000 4,691,000 4,706,649 15,649 0.3% TOTAL NET NON-OPERATIONS (5,936,770)(4,571,000)(1,572,253)(1,587,902)(15,649)1.0% EXCESS (DEFICIENCY) OF TOTAL REVENUE OVER TOTAL REQUIREMENTS (5,034,151)(4,210,531)(312,602)(381,103)68,501 (18.0%) ENDING BALANCE 336,328 5,066,298 4,997,797 4,661,469 93.3% RESERVED ENDING BALANCE 336,328 351,688 Georgetown Economic Development Corporation Fund Preliminary Actual to Year-End Projection as of September 2016 FYE Results by Investment Category: Asset Type Ave. Yield Book Value Market Value Ave. Yield Book Value Market Value Demand Accounts 0.29% 18,173,961$ 18,173,961$ 0.30% 17,380,505$ 17,380,505$ NOW/MMA 0.55% 5,349,353 5,349,353 0.19% 19,673,298 19,673,298 Pools 0.41% 69,025,556 69,025,556 0.10% 21,770,979 21,770,979 Certificates of Deposit 0.85% 30,681,533 30,681,533 0.65% 40,317,123 40,317,123 Totals 123,230,402$ 123,230,402$ 99,141,905$ 99,141,905$ 2016 2015 Change Total Portfolio 0.46%0.36%0.10% Rolling Three Mo. Treas. Yield 0.25%0.03%0.22% Rolling Six Mo. Treas. Yield 0.37%0.09%0.28% Quarterly TexPool Yield 0.31%0.06%0.26% (2) Fiscal Year-to-Date Average Yields calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. Annual Comparison of Portfolio Performance September 30, 2016 September 30, 2015 (1) Average Yield calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. Valley View Consulting, L.L.C.15 Summary Quarter End Results by Investment Category: Asset Type Ave. Yield Book Value Market Value Book Value Market Value Demand Accounts 0.29% 18,685,856$ 18,685,856 18,173,961$ 18,173,961$ NOW/MMA 0.55% 5,342,393 5,342,393 5,349,353 5,349,353 Pools 0.41% 76,766,844 76,766,844 69,025,556 69,025,556 CDs/Securities 0.85% 44,746,933 44,746,933 30,681,533 30,681,533 Totals 145,542,025$ 145,542,025$ 123,230,402$ 123,230,402$ Quarter End Average Yield (1)Fiscal Year-to-Date Average Yield (2) Total Portfolio 0.51%Total Portfolio 0.46% Rolling Three Mo. Treas. Yield 0.30%Rolling Three Mo. Treas. Yield 0.25% Rolling Six Mo. Treas. Yield 0.42%Rolling Six Mo. Treas. Yield 0.37% Quarterly TexPool Yield 0.31% 11,966$ Interest income provided in separate report.47,414$ June 30, 2016 September 30, 2016 (1) Average Yield calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. (2) Fiscal Year-to-Date Average Yields calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. Quarterly Bank Fees Offset Year-to-date Bank Fees Offset Valley View Consulting, L.L.C. 16 City - Investment Holdings Coupon/ Maturity Settlement Face Amount/ Book Market Market Life Description Ratings Discount Date Date Par Value Value Price Value (Day) Yield JPMorgan Chase Cash (3)0.29% 10/01/16 09/30/16 18,173,961$ 18,173,961$ 1.00 18,173,961$ 1 0.29% Southside Bank MMA 0.53% 10/01/16 09/30/16 921,588 921,588 1.00 921,588 1 0.53% Green Bank MMA 0.55% 10/01/16 09/30/16 4,427,765 4,427,765 1.00 4,427,765 1 0.55% TexPool AAAm 0.38% 10/01/16 09/30/16 4,341,802 4,341,802 1.00 4,341,802 1 0.38% TexSTAR AAAm 0.41% 10/01/16 09/30/16 64,683,754 64,683,754 1.00 64,683,754 1 0.41% BTH Bank CDARS 0.80% 11/03/16 02/05/15 1,519,989 1,519,989 100.00 1,519,989 34 0.80% BTH Bank CDARS 0.85% 11/17/16 11/20/14 3,047,956 3,047,956 100.00 3,047,956 48 0.85% LegacyTexas Bank CD 0.60% 12/07/16 12/07/15 5,022,592 5,022,592 100.00 5,022,592 68 0.60% BTH Bank CDARS 0.90% 02/02/17 02/05/15 1,522,507 1,522,507 100.00 1,522,507 125 0.90% LegacyTexas Bank CD 0.83% 04/13/17 05/23/16 2,005,600 2,005,600 100.00 2,005,600 195 0.83% LegacyTexas Bank CD 0.83% 04/13/17 05/23/16 4,011,200 4,011,200 100.00 4,011,200 195 0.83% Lubbock National Bank CD 0.95% 07/03/17 05/23/16 3,009,616 3,009,616 100.00 3,009,616 276 0.95% Lubbock National Bank CD 0.95% 07/03/17 05/23/16 2,508,013 2,508,013 100.00 2,508,013 276 0.95% Lubbock National Bank CD 0.95% 07/03/17 05/23/16 3,009,616 3,009,616 100.00 3,009,616 276 0.95% LegacyTexas Bank CD 0.95% 08/18/17 06/23/16 3,017,696 3,017,696 100.00 3,017,696 322 0.95% Lubbock National Bank CD 1.00% 10/02/17 05/23/16 2,006,748 2,006,748 100.00 2,006,748 367 1.00% 123,230,402$ 123,230,402$ 123,230,402$490.51% (1) (2) September 30, 2016 (2) Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank accounts, pools, and money market funds. (1) Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity. (3) Earnings Credit - The City's depository accounts provide an earnings credit on balances which is used to offset bank fees. Valley View Consulting, L.L.C.18 City - Book and Market Value Comparison Coupon/ Maturity Face Amount/Purchases/ Sales/Adjust/ Face Amount/ Description Discount Date Par Value Book Value Adjustments Call/Maturity Par Value Book Value JPMorgan Chase Cash 0.29% 10/01/16 18,685,856$ 18,685,856$ –$ (511,895)$ 18,173,961$ 18,173,961$ Southside Bank MMA 0.53% 10/01/16 920,375 920,375 1,212 921,588 921,588 Green Bank MMA 0.55% 10/01/16 4,422,017 4,422,017 5,747 4,427,765 4,427,765 TexPool 0.38% 10/01/16 4,478,019 4,478,019 (136,218) 4,341,802 4,341,802 TexSTAR 0.41% 10/01/16 72,288,824 72,288,824 (7,605,070) 64,683,754 64,683,754 BTH Bank CDARS 0.75%08/04/16 1,515,864 1,515,864 (1,515,864)– – BTH Bank CDARS 0.75%08/18/16 2,530,440 2,530,440 (2,530,440)– – Southside Bank CD 0.51%09/02/16 2,007,667 2,007,667 (2,007,667)– – Southside Bank CD 0.51%09/02/16 2,007,667 2,007,667 (2,007,667)– – LegacyTexas Bank CD 0.55%09/07/16 1,002,754 1,002,754 (1,002,754)– – Independent Bank CD 0.65%09/24/16 3,029,370 3,029,370 (3,029,370)– – RBank CD 1.06%09/29/16 2,037,460 2,037,460 (2,037,460)– – BTH Bank CDARS 0.80%11/03/16 1,516,928 1,516,928 3,062 1,519,989 1,519,989 BTH Bank CDARS 0.85%11/17/16 3,041,433 3,041,433 6,523 3,047,956 3,047,956 LegacyTexas Bank CD 0.60%12/07/16 5,015,024 5,015,024 7,567 5,022,592 5,022,592 BTH Bank CDARS 0.90%02/02/17 1,519,057 1,519,057 3,450 1,522,507 1,522,507 LegacyTexas Bank CD 0.83%04/13/17 2,001,410 2,001,410 4,190 2,005,600 2,005,600 LegacyTexas Bank CD 0.83%04/13/17 4,002,820 4,002,820 8,380 4,011,200 4,011,200 Lubbock National Bank CD 0.95%07/03/17 3,002,421 3,002,421 7,195 3,009,616 3,009,616 Lubbock National Bank CD 0.95%07/03/17 2,502,017 2,502,017 5,996 2,508,013 2,508,013 Lubbock National Bank CD 0.95%07/03/17 3,002,421 3,002,421 7,195 3,009,616 3,009,616 LegacyTexas Bank CD 0.95%08/18/17 3,010,482 3,010,482 7,214 3,017,696 3,017,696 Lubbock National Bank CD 1.00%10/02/17 2,001,699 2,001,699 5,050 2,006,748 2,006,748 TOTAL 145,542,025$ 145,542,025$ 72,782$ (22,384,405)$ 123,230,402$ 123,230,402$ June 30, 2016 September 30, 2016 Valley View Consulting, L.L.C.19 City - Allocation Investment Total Consolidated 2013 GO- Parks/Public Safety 2013 CO 2014 CO- Downtown Parks 2014 GO 2014 Revenue Electric 2014 Revenue Water WW JPMorgan Chase Cash 18,173,961$ 18,173,961$ –$ –$ –$ –$ –$ –$ Southside Bank MMA 921,588 921,588 Green Bank MMA 4,427,765 4,427,765 TexPool 4,341,802 4,341,802 TexSTAR 64,683,754 6,858,523 3,691,623 548,184 325,766 1,769,391 6,480,246 BTH Bank CDARS 11/03/16 1,519,989 1,519,989 BTH Bank CDARS 11/17/16 3,047,956 3,047,956 LegacyTexas Bank CD 12/07/16 5,022,592 BTH Bank CDARS 02/02/17 1,522,507 1,522,507 LegacyTexas Bank CD 04/13/17 2,005,600 LegacyTexas Bank CD 04/13/17 4,011,200 Lubbock National Bank CD 07/03/17 3,009,616 3,009,616 Lubbock National Bank CD 07/03/17 2,508,013 Lubbock National Bank CD 07/03/17 3,009,616 LegacyTexas Bank CD 08/18/17 3,017,696 3,017,696 Lubbock National Bank CD 10/02/17 2,006,748 Totals 123,230,402$ 46,841,403$ 3,691,623$ –$ 548,184$ 325,766$ 1,769,391$ 6,480,246$ Book and Market Value September 30, 2016 Valley View Consulting, L.L.C.21 City - Allocation JPMorgan Chase Cash Southside Bank MMA Green Bank MMA TexPool TexSTAR BTH Bank CDARS 11/03/16 BTH Bank CDARS 11/17/16 LegacyTexas Bank CD 12/07/16 BTH Bank CDARS 02/02/17 LegacyTexas Bank CD 04/13/17 LegacyTexas Bank CD 04/13/17 Lubbock National Bank CD 07/03/17 Lubbock National Bank CD 07/03/17 Lubbock National Bank CD 07/03/17 LegacyTexas Bank CD 08/18/17 Lubbock National Bank CD 10/02/17 Totals Book and Market Value September 30, 2016 (Continued) Debt Service Police Restricted Seizure Utility Debt Service 2015 CO- Airport 2015 CO- Parks/Streets/ Vehicles 2015 CO- Stormwater 2015 CO-Tax Facilities 2015 CO- Water –$ –$ –$ –$ –$ –$ –$ –$ 2,882,913 1,391 67,785 29,668 1,402,167 1,421,837 3,009,702 13,787 2,882,913$ 1,391$ 67,785$ 29,668$ 1,402,167$ 1,421,837$ 3,009,702$ 13,787$ Valley View Consulting, L.L.C.22 City - Allocation JPMorgan Chase Cash Southside Bank MMA Green Bank MMA TexPool TexSTAR BTH Bank CDARS 11/03/16 BTH Bank CDARS 11/17/16 LegacyTexas Bank CD 12/07/16 BTH Bank CDARS 02/02/17 LegacyTexas Bank CD 04/13/17 LegacyTexas Bank CD 04/13/17 Lubbock National Bank CD 07/03/17 Lubbock National Bank CD 07/03/17 Lubbock National Bank CD 07/03/17 LegacyTexas Bank CD 08/18/17 Lubbock National Bank CD 10/02/17 Totals Book and Market Value September 30, 2016 (Continued) 2015 GO- Roads 2015A GO- Roads 2015A GO- Parks 2015 Revenue Electric 2015 Revenue Water WW 2016 CO- Rivery TIRZ 2016 CO- Stormwater 2016 CO- Streets/ Facilities/ Equip –$ –$ –$ –$ –$ –$ –$ –$ 4,309,300 2,288,599 1,706,564 2,010,907 7,077,152 1,715,640 2,839,203 5,022,592 4,309,300$ 7,311,191$ 1,706,564$ 2,010,907$ 7,077,152$ 1,715,640$ – 2,839,203$ Valley View Consulting, L.L.C.23 City - Allocation JPMorgan Chase Cash Southside Bank MMA Green Bank MMA TexPool TexSTAR BTH Bank CDARS 11/03/16 BTH Bank CDARS 11/17/16 LegacyTexas Bank CD 12/07/16 BTH Bank CDARS 02/02/17 LegacyTexas Bank CD 04/13/17 LegacyTexas Bank CD 04/13/17 Lubbock National Bank CD 07/03/17 Lubbock National Bank CD 07/03/17 Lubbock National Bank CD 07/03/17 LegacyTexas Bank CD 08/18/17 Lubbock National Bank CD 10/02/17 Totals Book and Market Value September 30, 2016 (Continued) 2016 GO Bonds 2016 GO- Parks 2016 GO- Roads 2016 Revenue Electric 2016 Revenue Water/WW Garey Park Donation –$ –$ –$ –$ –$ –$ 3,007,273 1,011,479 1,797,833 3,408,411 5,008,409 2,005,600 4,011,200 2,508,013 3,009,616 2,006,748 9,027,564$ 3,007,273$ 1,011,479$ 1,797,833$ 7,922,024$ 5,008,409$ Valley View Consulting, L.L.C.24 City - Allocation Investment Total Consolidated 2013 GO- Parks/Public Safety 2013 CO 2014 CO- Downtown Parks 2014 GO 2014 Revenue Electric 2014 Revenue Water WW JPMorgan Chase Cash 18,685,856$ 18,685,856$ –$ –$ –$ –$ –$ –$ Southside Bank MMA 920,375 920,375 Green Bank MMA 4,422,017 4,422,017 TexPool 4,478,019 4,478,019 TexSTAR 72,288,824 4,124,476 4,750,311 1,263,130 596,334 402,612 1,767,613 5,026,050 BTH Bank CDARS 08/04/16 1,515,864 1,515,864 BTH Bank CDARS 08/18/16 2,530,440 2,530,440 Southside Bank CD 09/02/16 2,007,667 Southside Bank CD 09/02/16 2,007,667 LegacyTexas Bank CD 09/07/16 1,002,754 Independent Bank CD 09/24/16 3,029,370 3,029,370 RBank CD 09/29/16 2,037,460 2,037,460 BTH Bank CDARS 11/03/16 1,516,928 1,516,928 BTH Bank CDARS 11/17/16 3,041,433 3,041,433 LegacyTexas Bank CD 12/07/16 5,015,024 BTH Bank CDARS 02/02/17 1,519,057 1,519,057 LegacyTexas Bank CD 04/13/17 2,001,410 LegacyTexas Bank CD 04/13/17 4,002,820 Lubbock National Bank CD 07/03/17 3,002,421 3,002,421 Lubbock National Bank CD 07/03/17 2,502,017 Lubbock National Bank CD 07/03/17 3,002,421 LegacyTexas Bank CD 08/18/17 3,010,482 3,010,482 Lubbock National Bank CD 10/02/17 2,001,699 Totals 145,542,025$ 52,318,335$ 4,750,311$ 1,263,130$ 596,334$ 402,612$ 1,767,613$ 6,541,914$ June 30, 2016 Book and Market Value Valley View Consulting, L.L.C.25 City - Allocation JPMorgan Chase Cash Southside Bank MMA Green Bank MMA TexPool TexSTAR BTH Bank CDARS 08/04/16 BTH Bank CDARS 08/18/16 Southside Bank CD 09/02/16 Southside Bank CD 09/02/16 LegacyTexas Bank CD 09/07/16 Independent Bank CD 09/24/16 RBank CD 09/29/16 BTH Bank CDARS 11/03/16 BTH Bank CDARS 11/17/16 LegacyTexas Bank CD 12/07/16 BTH Bank CDARS 02/02/17 LegacyTexas Bank CD 04/13/17 LegacyTexas Bank CD 04/13/17 Lubbock National Bank CD 07/03/17 Lubbock National Bank CD 07/03/17 Lubbock National Bank CD 07/03/17 LegacyTexas Bank CD 08/18/17 Lubbock National Bank CD 10/02/17 Totals June 30, 2016 Book and Market Value (Continued) Debt Service Police Restricted Seizure Utility Debt Service 2015 CO- Airport 2015 CO- Parks/Streets/ Vehicles 2015 CO- Stormwater 2015 CO-Tax Facilities 2015 CO- Water –$ –$ –$ –$ –$ –$ –$ –$ 11,555,064 1,390 67,717 29,638 2,134,355 1,420,408 3,450,350 758,624 11,555,064$ 1,390$ 67,717$ 29,638$ 2,134,355$ 1,420,408$ 3,450,350$ 758,624$ Valley View Consulting, L.L.C.26 City - Allocation JPMorgan Chase Cash Southside Bank MMA Green Bank MMA TexPool TexSTAR BTH Bank CDARS 08/04/16 BTH Bank CDARS 08/18/16 Southside Bank CD 09/02/16 Southside Bank CD 09/02/16 LegacyTexas Bank CD 09/07/16 Independent Bank CD 09/24/16 RBank CD 09/29/16 BTH Bank CDARS 11/03/16 BTH Bank CDARS 11/17/16 LegacyTexas Bank CD 12/07/16 BTH Bank CDARS 02/02/17 LegacyTexas Bank CD 04/13/17 LegacyTexas Bank CD 04/13/17 Lubbock National Bank CD 07/03/17 Lubbock National Bank CD 07/03/17 Lubbock National Bank CD 07/03/17 LegacyTexas Bank CD 08/18/17 Lubbock National Bank CD 10/02/17 Totals June 30, 2016 Book and Market Value (Continued) 2015 GO- Roads 2015A GO- Roads 2015A GO- Parks 2015 Revenue Electric 2015 Revenue Water WW 2016 CO- Rivery TIRZ 2016 CO- Stormwater 2016 CO- Streets/ Facilities/ Equip –$ –$ –$ –$ –$ –$ –$ –$ 4,304,969 4,645,972 701,442 5,731,707 1,713,915 250,280 3,252,635 2,007,667 2,007,667 1,002,754 5,015,024 4,304,969$ 9,660,996$ 1,704,197$ 2,007,667$ 7,739,374$ 1,713,915$ 250,280$ 3,252,635$ Valley View Consulting, L.L.C.27 City - Allocation JPMorgan Chase Cash Southside Bank MMA Green Bank MMA TexPool TexSTAR BTH Bank CDARS 08/04/16 BTH Bank CDARS 08/18/16 Southside Bank CD 09/02/16 Southside Bank CD 09/02/16 LegacyTexas Bank CD 09/07/16 Independent Bank CD 09/24/16 RBank CD 09/29/16 BTH Bank CDARS 11/03/16 BTH Bank CDARS 11/17/16 LegacyTexas Bank CD 12/07/16 BTH Bank CDARS 02/02/17 LegacyTexas Bank CD 04/13/17 LegacyTexas Bank CD 04/13/17 Lubbock National Bank CD 07/03/17 Lubbock National Bank CD 07/03/17 Lubbock National Bank CD 07/03/17 LegacyTexas Bank CD 08/18/17 Lubbock National Bank CD 10/02/17 Totals June 30, 2016 Book and Market Value (Continued) 2016 GO Bonds 2016 GO- Parks 2016 GO- Roads 2016 Revenue Electric 2016 Revenue Water/WW Garey Park Donation –$ –$ –$ –$ –$ –$ 3,004,251 1,010,462 1,796,026 3,525,716 5,003,375 2,001,410 4,002,820 2,502,017 3,002,421 2,001,699 9,006,939$ 3,004,251$ 1,010,462$ 1,796,026$ 8,029,143$ 5,003,375$ Valley View Consulting, L.L.C.28 FYE Results by Investment Category: Asset Type Ave. Yield Book Value Market Value Ave. Yield Book Value Market Value Pools 0.40% 15,794,940$ 15,794,940$ 0.09%4,699,650$ 4,699,650$ Certificates of Deposit 0.90% 10,600,691 10,600,691 0.62%8,039,961 8,039,961 Totals 26,395,630$ 26,395,630$ 12,739,611$ 12,739,611$ 2016 2015 Change Total Portfolio 0.53%0.41%0.13% Rolling Three Mo. Treas. Yield 0.25%0.03%0.22% Rolling Six Mo. Treas. Yield 0.37%0.09%0.28% Quarterly TexPool Yield 0.31%0.06%0.26% (2) Fiscal Year-to-Date Average Yields calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. Annual Comparison of Portfolio Performance September 30, 2016 September 30, 2015 (1) Average Yield calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. Valley View Consulting, L.L.C.31 Summary Quarter End Results by Investment Category: Asset Type Ave. Yield Book Value Market Value Book Value Market Value Pools 0.40% 16,140,952$ 16,140,952$ 15,794,940$ 15,794,940$ CDs/Securities 0.90% 10,575,566 10,575,566 10,600,691 10,600,691 Totals 26,716,518$ 26,716,518$ 26,395,630$ 26,395,630$ Quarter End Average Yield (1)Fiscal Year-to-Date Average Yield (2) Total Portfolio 0.60%Total Portfolio 0.53% Rolling Three Mo. Treas. Yield 0.30%Rolling Three Mo. Treas. Yield 0.25% Rolling Six Mo. Treas. Yield 0.42%Rolling Six Mo. Treas. Yield 0.37% Quarterly TexPool Yield 0.31% Interest data provided in separate report. June 30, 2016 September 30, 2016 (1) Average Yield calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. (2) Fiscal Year-to-Date Average Yields calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. Valley View Consulting, L.L.C. 32 Investment Holdings Coupon/Maturity Settlement Face Amount/Book Market Market Life Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield TexPool AAAm 0.38% 10/01/16 09/30/16 7,461,126$ 7,461,126$ 1.00 7,461,126$ 1 0.38% TexSTAR AAAm 0.41% 10/01/16 09/30/16 8,333,813 8,333,813 1.00 8,333,813 1 0.41% LegacyTexas Bank CD 0.60% 12/07/16 12/07/15 1,506,778 1,506,778 100.00 1,506,778 68 0.60% RBank CD 0.80% 12/30/16 12/30/15 2,034,842 2,034,842 100.00 2,034,842 91 0.80% Lubbock National Bank CD 0.95% 07/03/17 05/23/16 4,012,821 4,012,821 100.00 4,012,821 276 0.95% Lubbock National Bank CD 1.05% 08/18/17 08/18/16 3,046,250 3,046,250 100.00 3,046,250 322 1.05% 26,395,630$ 26,395,630$ 26,395,630$ 91 0.60% (1) (2) September 30, 2016 (1) Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity. (2) Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank accounts, pools, and money market funds. Valley View Consulting, L.L.C.34 Book Value Comparison Coupon/Maturity Face Amount/Purchases/Sales/Adjust/Face Amount/ Description Discount Date Par Value Book Value Adjustments Call/Maturity Par Value Book Value TexPool 0.38% 10/01/16 5,913,701$ 5,913,701$ 1,547,425$ –$ 7,461,126$ 7,461,126$ TexSTAR 0.41% 10/01/16 10,227,251 10,227,251 (1,893,437) 8,333,813 8,333,813 Comerica Bank CD 0.67% 08/15/16 3,037,088 3,037,088 (3,037,088)– – LegacyTexas Bank CD 0.60% 12/07/16 1,504,507 1,504,507 2,270 1,506,778 1,506,778 RBank CD 0.80% 12/30/16 2,030,743 2,030,743 4,099 2,034,842 2,034,842 Lubbock National Bank CD 0.95% 07/03/17 4,003,227 4,003,227 9,593 4,012,821 4,012,821 Lubbock National Bank CD 1.05% 08/18/17 – – 3,046,250 3,046,250 3,046,250 TOTAL 26,716,518$ 26,716,518$ 4,609,638$ (4,930,526)$ 26,395,630$ 26,395,630$ Market Value Comparison Coupon/Maturity Face Amount/Qtr to Qtr Face Amount/ Description Discount Date Par Value Market Value Change Par Value Market Value TexPool 0.38% 10/01/16 5,913,701$ 5,913,701$ 1,547,425$ 7,461,126$ 7,461,126$ TexSTAR 0.41% 10/01/16 10,227,251 10,227,251 (1,893,437) 8,333,813 8,333,813 Comerica Bank CD 0.67% 08/15/16 3,037,088 3,037,088 (3,037,088)– – LegacyTexas Bank CD 0.60% 12/07/16 1,504,507 1,504,507 2,270 1,506,778 1,506,778 RBank CD 0.80% 12/30/16 2,030,743 2,030,743 4,099 2,034,842 2,034,842 Lubbock National Bank CD 0.95% 07/03/17 4,003,227 4,003,227 9,593 4,012,821 4,012,821 Lubbock National Bank CD 1.05% 08/18/17 – – 3,046,250 3,046,250 3,046,250 TOTAL 26,716,518$ 26,716,518$ (320,887)$ 26,395,630$ 26,395,630$ June 30, 2016 September 30, 2016 June 30, 2016 September 30, 2016 Valley View Consulting, L.L.C.36 FYE Results by Investment Category: Asset Type Ave. Yield Book Value Market Value Ave. Yield Book Value Market Value Demand Accounts 0.55% 2,002,599$ 2,002,599$ –$ –$ Pools 0.44% 7,515,422 7,515,422 0.11% 3,906,429 3,906,429 Certificates of Deposit – – 0.55% 1,506,179 1,506,179 Totals 9,518,021$ 9,518,021$ 5,412,608$ 5,412,608$ 2016 2015 Change Total Portfolio 0.38%0.24%0.14% Rolling Three Mo. Treas. Yield 0.25%0.03%0.22% Rolling Six Mo. Treas. Yield 0.37%0.09%0.28% Quarterly TexPool Yield 0.31%0.06%0.26% (2) Fiscal Year-to-Date Average Yields calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. Annual Comparison of Portfolio Performance September 30, 2016 September 30, 2015 (1) Average Yield calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. Valley View Consulting, L.L.C.38 Summary Quarter End Results by Investment Category: Asset Type Ave. Yield Book Value Market Value Book Value Market Value MMA 0.55%–$ –$ 2,002,599$ 2,002,599$ Pools 0.44% 9,212,429 9,212,429 7,515,422 7,515,422 9,212,429$ 9,212,429$ 9,518,021$ 9,518,021$ Quarter End Average Yield (1)Fiscal Year-to-Date Average Yield (2) Total Portfolio 0.46%Total Portfolio 0.38% Rolling Three Mo. Treas. Yield 0.30%Rolling Three Mo. Treas. Yield 0.25% Rolling Six Mo. Treas. Yield 0.42%Rolling Six Mo. Treas. Yield 0.37% Quarterly TexPool Yield 0.31% Interest income provided in separate report. June 30, 2016 September 30, 2016 (1) Average Yield calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. (2) Fiscal Year-to-Date Average Yields calculated using quarter end report yields and adjusted book values and does not reflect a total return analysis or account for advisory fees. Valley View Consulting, L.L.C. 39 Investment Holdings Coupon/Maturity Settlement Face Amount/Book Market Market Life Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield Green Bank MMA 0.55% 10/01/16 09/30/16 2,002,599$ 2,002,599$ 1.00 2,002,599$ 1 0.55% TexasDAILY AAAm 0.50% 10/01/16 09/30/16 2,009,403 2,009,403 1.00 2,009,403 1 0.50% TexSTAR AAAm 0.41% 10/01/16 09/30/16 5,506,019 5,506,019 1.00 5,506,019 1 0.41% 9,518,021$ 9,518,021$ 9,518,021$ 1 0.46% (1) (2) September 30, 2016 (1) Weighted average life - For purposes of calculating weighted average life, bank accounts, pools and money market funds are assumed to have an one day maturity. (2) Weighted average yield to maturity - The weighted average yield to maturity is based on adjusted book value, realized and unrealized gains/losses and investment advisory fees are not considered. The yield for the reporting month is used for bank accounts, pools, and money market funds. Valley View Consulting, L.L.C.41 Book Value Comparison Coupon/Maturity Face Amount/Purchases/Sales/Adjust/Face Amount/ Description Discount Date Par Value Book Value Adjustments Call/Maturity Par Value Book Value Green Bank MMA 0.55% 10/01/16 –$ –$ 2,002,599$ –$ 2,002,599$ 2,002,599$ TexasDAILY 0.50% 10/01/16 2,007,020 2,007,020 2,383 2,009,403 2,009,403 TexSTAR 0.41% 10/01/16 7,205,408 7,205,408 (1,699,389) 5,506,019 5,506,019 TOTAL 9,212,429$ 9,212,429$ 2,004,982$ (1,699,389)$ 9,518,021$ 9,518,021$ Market Value Comparison Qtr to Qtr Change Green Bank MMA 0.55% 10/01/16 –$ –$ 2,002,599$ 2,002,599$ 2,002,599$ TexasDAILY 0.50% 10/01/16 2,007,020 2,007,020 2,383 2,009,403 2,009,403 TexSTAR 0.41% 10/01/16 7,205,408 7,205,408 (1,699,389) 5,506,019 5,506,019 TOTAL 9,212,429$ 9,212,429$ 305,593$ 9,518,021$ 9,518,021$ June 30, 2016 September 30, 2016 June 30, 2016 September 30, 2016 Valley View Consulting, L.L.C.43 Capital Improvement Projects Preliminary Year End September 30, 2016 2015/16 Year to Date Year to Date Project Budget Expenditures Encumbrances Balance General Government CIP Public Safety & Facilities 6CJ GMC Remodel 1,900,000$                     8,754$                              ‐$                                      1,891,246$                        6CR Public Safety Facility ‐                                         465,033                           73,916                             (538,949)                           [a] 6DP Fire Station ESD 550,000                           ‐                                         ‐                                        550,000                              6DQ EOC Siren System 1,000,000                        367,091                           205,379                           427,530                              6EW Transfer Station / Landfill 210,000                           26,600                             42,882                             140,519                              7AD Communications ‐                                         ‐                                         ‐                                        ‐                                           9BE Preventative Maintenance ‐                                        ‐                                       ‐                                       ‐                                          Public Safety & Facilities Subtotal 3,660,000                      867,478                         322,176                        2,470,346                        Parks CIP Bonds 1AU Street Rehab‐West ‐                                         3,170                                 ‐                                        (3,170)                                [a] 1BU Streets Rehabilitation ‐                                         32,796                             (140,856)                         108,060                              1DN Access to Rtw to Gov Srv ‐                                         ‐                                         9,118                               (9,118)                                [a] 1DP 8th St Church to Myrtle 41,382                             11,923                             29,459                             ‐                                           1DU 8th St Austin to MLK 11,923                             11,923                             ‐                                        ‐                                           1DV Church St 8th to 9th 11,923                             11,923                             ‐                                        ‐                                           1DX SH29 to Leander Rd SW 131,800                           17,848                             113,952                           ‐                                           6AR Westside Park ‐                                         18,249                             (15,966)                            (2,283)                                [a] 6CN River Trail Expansion 100,000                           ‐                                         ‐                                        100,000                              6CP San Gabriel Park Improvements 2,049,900                        406,938                           (406,938)                         2,049,900                          6DB McMaster Park 96,000                             12,790                             5,078                               78,132                                6DD New Village Parks ‐                                         6,925                                13,425                             (20,350)                              [a] 6DE SG Bank Stabilization 416,700                           387,422                           (1,075)                              30,353                                6DH Sidewalks 615,538                           ‐                                         ‐                                        615,538                              6DK Williams Dr. Pool 827,000                           849,631                           (12,742)                            (9,889)                                [a] 6DM VFW Park 1,314,800                        434,028                           881,294                           (522)                                   [a] 6DN Historic Park 257,700                           ‐                                         ‐                                        257,700                              6DO Garey Park 3,000,000                        807,249                           (787,667)                         2,980,418                          6DZ ADA Sidewalks Repairs 100,000                           ‐                                         ‐                                        100,000                              6EA General Repair / Maintenance 132,000                           2,715                                ‐                                        129,285                              6EB Red Poppy Canopy 77,500                             ‐                                         ‐                                        77,500                                6EC Tree Mitigation 44,000                             ‐                                         ‐                                        44,000                                6ED Grace Heritage Rehab 150,000                           13,238                             (10,000)                            146,762                              6EK Former PD Renovation ‐                                         375                                   ‐                                        (375)                                   [a] 6EP Electric Projects 185,000                           ‐                                         ‐                                        185,000                              6EQ Street Light Upgrades 40,000                             ‐                                         ‐                                        40,000                                6ER Parking Renovations 50,000                             ‐                                         ‐                                        50,000                                6ES ADA Facilities 242,049                           41,371                             ‐                                        200,678                              6ET ADA Parks 150,000                           ‐                                         ‐                                        150,000                              6EV Shotgun House Rehab 18,000                             18,000                             ‐                                        ‐                                           9AU University Sidewalks 81,800                             ‐                                         81,800                             ‐                                           9AW CDBG‐MLK/3rd St 10,534                             ‐                                         10,534                             ‐                                           Parks CIP Bonds Subtotal 10,155,549                   3,088,513                      (230,583)                       7,297,619                        Parks CIP   6DB McMaster Park ‐                                         2,500                                15,368                             (17,868)                              [a] 6DD New Village Parks ‐                                         912                                   (121)                                 (791)                                   [a] 6DX Emerald Springs Park 15,900                             52,594                             (36,294)                            (400)                                   [a] 6EH Village Park 71,100                             8,150                                ‐                                        62,950                                6EI Founder's Park 70,000                             ‐                                         2,989                               67,011                                6EU VFW Lighting ‐                                         190,375                           ‐                                        (190,375)                           [a] Parks CIP  Subtotal 157,000                         254,531                         (18,058)                         (79,473)                            Downtown & Community Service  1DG Rivery Sheraton Garage 4,008,000                        1,691,483                         ‐                                        2,316,517                          6BU Former Library Renovation 90,500                             ‐                                         ‐                                        90,500                                6EG Municipal Court / CVB Redesign 230,000                           ‐                                         ‐                                        230,000                              6EJ Parking Facility Study / Design 266,500                           10,058                             (10,058)                            266,500                              6EK Former PD Renovation 6,705,000                        169,579                           (33,675)                            6,569,096                          6EM Downtown West ‐                                         352,277                           (336,527)                         (15,750)                              [a] 6EO Downtown Festival Area 460,000                           ‐                                         ‐                                        460,000                              Downtown & Community Service Subtotal 11,760,000                   2,223,397                      (380,260)                       9,916,862                        Total General Government CIP 25,732,549$                 6,433,919$                   (306,724)$                     19,605,354$                    NOTES: [a] Individual projects may go over budget as long as total expenditures    for all CIP projects are within the department's total budget. 45 Capital Improvement Projects Preliminary Year End September 30, 2016 2015/16 Year to Date Year to Date Project Budget Expenditures Encumbrances Balance Transportation Services CIP Streets / Transportation 1BU Streets Rehabilitation 623,000$                      962,261$                      (782,663)$                     443,403$                        1BZ 971 @ Austin Ave.‐                                     59,437                         (59,437)                         ‐                                        1CA SW Bypass Leander to I35 ‐                                     66,051                         (5,235)                           (60,816)                          [a] 1CC FM 1460 ‐                                     111,043                       (57,530)                         (53,512)                          [a] 1CF Street Overlay/Microsurfacing 300,000                        277,685                       22,315                          (0)                                     1CN Sealant 326,000                        142,888                       (120,538)                      303,651                          1CP 2012 Street Rehab 236,000                        6,327                            (6,327)                           236,000                          1CQ SE I/L Schematic Design ‐                                     5,699                            (5,699)                           ‐                                        1CR SW Bypass‐29 to Leander ‐                                     4,480                            ‐                                     (4,480)                             [a] 1CS DB Wood Bridge ‐                                     24,949                         (24,949)                         ‐                                        1CU Cutler Process 1,000,000                     463,882                       408,672                        127,446                          1DE Williams Dr @ Jimm Hogg Rd ‐                                     218,765                       ‐                                     (218,765)                        [a] 1DG Sheraton Parking Garage ‐                                     4,186                            (4,186)                           ‐                                        1DH Cutler Process ‐                                     4,371                            ‐                                     (4,371)                             [a] 1DI SW Bypass / WR Parkway 20,000,000                   3,118,036                    14,557,034                 2,324,931                       1DK Southeast Inner Loop ‐                                     1,247,876                    (295)                              (1,247,581)                     [a] 1DL Austin Avenue Bridge 675,000                        514,916                       427,353                        (267,269)                        [a] 1DM Street Maintenance 2016 1,500,000                     1,482,568                    22,040                          (4,608)                             [a] 1DN Access RTW to GOV SRV ‐                                     ‐                                    40,690                          (40,690)                          [a] 1DO Austin Avenue at 5th St Light ‐                                     24,096                         16,672                          (40,768)                          [a] 1DR PH 1 Signal and Curb Ramps ‐                                     7,734                            53,170                          (60,903)                          [a] 5AL Curb and Gutter ‐                                     ‐                                    874,436                        (874,436)                        [a] 9AU University Sidewalks ‐                                     40                                 ‐                                     (40)                                  [a] Streets / Transportation Subtotal 24,660,000                 8,747,288                  15,355,522                557,190                         Stormwater 1BU Streets Rehabilitation ‐                                     282,825                       (282,825)                       ‐                                        5AL Curb & Gutter ‐                                     16,355                         212,535                        (228,890)                        [a] 5AM Curb & Sidewalks ‐                                     8,569                            (8,569)                            ‐                                        5AO Stormwater Infrastructure ‐                                      ‐                                     ‐                                      ‐                                        5AT Smith Branch Buy‐Outs ‐                                     1,110                             ‐                                     (1,110)                             [a] 5AW Regional Flood Study 950,000                        275,321                       409,679                        265,000                          6DE SG Bank Stabilization ‐                                     35,000                          ‐                                     (35,000)                          [a] Stormwater Subtotal 950,000                      619,180                     330,820                      0                                    Airport 6VA Airport Master Plan ‐                                     21,329                          ‐                                     (21,329)                          [a] 6VB Parallel Taxiway & Runway Lights ‐                                     3,958                            (3,958)                            ‐                                        6VE Fuel Farm 857,935                        837,705                        ‐                                     20,230                             6VF Software Specialized 20,000                          ‐                                    ‐                                     20,000                             Airport Subtotal 877,935                      862,992                     (3,958)                         18,901                           Total Transportation Services CIP 26,487,935$               10,229,460$               15,682,384$               576,091$                       NOTES: [a] Individual projects may go over budget as long as total expenditures    for all CIP projects are within the department's total budget. 46 Capital Improvement Projects Preliminary Year End September 30, 2016 2015/16 Year to Date Year to Date Project Budget Expenditures Encumbrances Balance Water Services CIP Wastewater Line Upgrades: 2CH Cedar Breaks EST ‐$                                   1,400$                           1,100$                           (2,500)$                           [a] 3BZ Wastewater ‐ Street Rehab 200,000$                      ‐$                                   ‐$                                    200,000$                         3CJ Berry Creek Interceptor 8,333,900                     360,956                       (358,456)                       8,331,400                        5QZ Snead Drive 299,200                        625,862                       (625,836)                       299,174                           6CR Public Safety Facility 10,000                           205,770                       (166,528)                       (29,242)                           [a] Wastewater Line Upgrades Subtotal 8,843,100                   1,193,988                  (1,149,720)                 8,798,832                      WW Edwards Aquifer Compliance: 3B0 EARZ Ph. 8 755,825                        15,811                           ‐                                     740,014                           3CG EARZ 2013‐14 755,825                        144,214                       (144,145)                       755,756                           3CK EARZ 2014‐15 1,511,650                     782,405                       177,069                        552,176                           3CL EARZ 2015‐2016 ‐                                     318,445                       72,380                          (390,825)                         [a] WW Edwards Aquifer Compliance Subtotal 3,023,300                   1,260,875                  105,304                      1,657,121                      WW Lift stations & Force Mains 3CC Lift Station Upgrades 419,100                         ‐                                     ‐                                     419,100                           3CD Stonehedge LS & FM 27,600                           14,350                          (14,322)                         27,572                             3CE Westinghouse LS & FM 3,298,900                     13,974                          (11,332)                         3,296,258                        3CI Austin Custom Molds LS Decommission 152,000                        ‐                                    ‐                                     152,000                           WW Lift stations & Force Mains Subtotal 3,897,600                   28,324                        (25,654)                       3,894,930                      WW Treatment Plant 3CA Pecan Branch WWTP 1,957,000                     178,404                       (11,713)                         1,790,309                        WW Treatment Plant Subtotal 1,957,000                   178,404                     (11,713)                       1,790,309                      Water CIP 1BU Streets Rehab 143,700                        363,328                       (362,991)                       143,363                           1DE Williams Dr. @ Jim Hogg Rd ‐                                     519,738                       (11,695)                         (508,043)                         [a] 2BR LWTP Expansion Ph. III ‐                                     1,480                            ‐                                     (1,480)                             [a] 2BW Westside Facility 505,500                        4,859,768                    (4,564,350)                   210,081                           2BZ West Loop (H‐1B) Ph. 1 408,000                        ‐                                    ‐                                     408,000                           2CE Rabbit Hill EST 1,825,800                     1,850,508                    291,713                        (316,421)                         [a] 2CH Cedar Breaks EST 3,385,000                     555,008                       2,321,668                     508,324                           2CI Shell Road Water Line 6,292,500                     233,729                       (233,729)                       6,292,500                        2CJ Meter Issue ‐                                     457,072                       ‐                                     (457,072)                         [a] 2CK Daniels Mountain GST 2,200,000                     1,999,843                    8,578                            191,579                           2CL Park WTP Pump Station 335,000                        30,970                          1,630                            302,400                           2CM SW Bypass Waterline 1,106,000                     ‐                                    1,002,410                     103,590                           Water CIP Subtotal 16,201,500                 10,871,444                (1,546,765)                 6,876,821                      Rural Water CIP 2CN PRV Improv SH129 & CR245 183,881                        182,089                       1,792                            (0)                                      2CO Majestic Oaks Water Lines 289,607                        35,554                          254,053                        ‐                                        2JA Hwy 183 & 1869 Waterline 2,945                             2,945                            ‐                                     ‐                                        2JE CR 255 (WD 14‐2)4,817,567                     437,449                       471,931                        3,908,187                        2JF Domel Improvements 2,007,000                     115,037                       207,777                        1,684,186                        Rural Water CIP Subtotal 7,301,000                   773,074                     935,553                      5,592,373                      AMI/CIS‐Water 2CG Asset Management 71,000                           50,220                          (37,922)                         58,702                             Water/AMI/CIS Subtotal 71,000                         50,220                        (37,922)                       58,702                           Total Water Services CIP 41,294,500$               14,356,329$               (1,730,917)$                28,669,088$                 NOTES: [a] Individual projects may go over budget as long as total expenditures    for all CIP projects are within the department's total budget. 47 Capital Improvement Projects Preliminary Year End September 30, 2016 2015/16 Year to Date Year to Date Project Budget Expenditures Encumbrances Balance GTEC CIP 1CA SW Bypass Leander to I35 ‐$                         1,800$              ‐$                         (1,800)$                [a] 1CC FM 1460 Widening 61,000$               5,913$              (5,910)$                60,997$                51A Economic Development Projects 1,345,312$         ‐$                      ‐$                         1,345,312$          5QC Southwest Bypass 1,332,579$         1,804,446$      (7,204)$                (464,663)$           [a] 5QG SE1: Inner LP / SH130 ‐$                         2,065$              118$                    (2,183)$                [a] 5QW Wolf Ranch Pkwy Extension 283,350$            ‐$                      ‐$                         283,350$             5QY NB Frontage Rd 2338 to Lakeway ‐$                         5,365$              (5,365)$                ‐$                          5QX Northwest Boulevard Bridge 91,590$               91,303$            (91,303)$             91,590$                5QZ Snead Drive 20,000$               992,930$         (992,884)$           19,954$                5RB ROW ‐ FM 1460 500,000$            1,099,413$      (2,035)$                (597,378)$           [a] 5RC Williams Dr. Gateway 794,000$            215$                 ‐$                         793,785$             5RF Rivery Road (Convention Center Prj..)721,000$            ‐$                      ‐$                         721,000$             5RI Mays Street (S. Georgetown TIRZ)10,150,000$       314,605$         6,138,400$        3,696,995$          5RJ IH 35 / Hwy 29 Intersection Improvements 650,000$            ‐$                      ‐$                         650,000$             5RM Rivery Ext (Williams Dr. ‐ Nwest Blvd.)1,500,000$         2,871,839$      (247,599)$           (1,124,240)$        [a] 5RN Pecan Center Dr. / Airport Rd.6,364,000$         53,171$            (53,171)$             6,364,000$          5RO Southwest Bypass ‐ Laubach 1,121,000$         19,340$            261$                    1,101,399$          5RP Rivery TIA Improvements 1,400,000$         ‐$                      239,800$            1,160,200$          5RQ Rabbit Hill ‐$                         29$                   425,700$            (425,729)$           [a] Total GTEC CIP 26,333,831$       7,262,434$      5,398,808$        13,672,589$        Notes: [a] Individual projects may go over budget as long as total expenditures    for all CIP projects are within the department's total budget. 48 Capital Improvement Projects Preliminary Year End September 30, 2016 2015/16 Year to Date Year to Date Project Budget Expenditures Encumbrances Balance Electric CIP Electric CIP 9‐0580‐90‐129 Downtown URD Projects ‐                          3,082                  (3,795)                 713                      9‐0580‐90‐300 Electrical System Improvements 4,375,000          5,344,273          (104,754)             (864,519)            [a] 9‐0580‐90‐310 Power Quality Improvements 80,000                21,133                 ‐                           58,867                 9‐0580‐90‐320 Sectionalization Improvements 50,000                ‐                          ‐                           50,000                 9‐0580‐90‐330 Pole Improvements 50,000                14,025                ‐                           35,975                 9‐0580‐90‐340 Major Device Replacement ‐                          37,596                ‐                           (37,596)              [a] 9‐0580‐90‐350 Relocation Projects Reimbursements ‐                          57,530                (39,865)               (17,665)              [a] 9‐0580‐90‐400 Electrical System Expansion ‐                          189,292              (124,066)             (65,226)              [a] 9‐0580‐90‐410 New Development Projects 1,200,000          2,003,841          35,115                (838,956)            [a] 9‐0580‐90‐420 Reimbursements New Developments (540,000)            29,946                ‐                           (569,946)            [a] 9‐0580‐90‐430 Street Lighting  88,000                24,738                9,931                   53,331                 9‐0580‐90‐500 Consultant Engineering 150,000              202,913              17,531                (70,444)              [a] 9‐0580‐90‐510 System Mapping Support 50,000                71,514                102,972              (124,486)            [a] Electric CIP Subtotal 5,503,000          7,999,882          (106,931)             (2,389,951)          T&D 9‐0585‐90‐003 Electric Substations 698,000              1,044,736          22,446                (369,182)            [a] 9‐0585‐90‐021 Communication Equipment 507,000              399,551              (225,600)             333,050               T&D Subtotal 1,205,000          1,444,287          (203,155)             (36,132)               CIS 9‐0580‐91‐105 CIS System 4,350,000          935,773              2,384,611           1,029,616           CIS Subtotal 4,350,000          935,773             2,384,611           1,029,616           Total Electric CIP 11,058,000$       10,379,942$       2,074,525$          (1,396,467)$        NOTES: [a] Individual projects may go over budget as long as total expenditures    for all CIP projects are within the department's total budget. 49