HomeMy WebLinkAboutFY 16 - 03 QuarterlyReport_RedactedFINANCIAL REPORT AND INVESTMENT REPORT
For the Quarter Ended June 30, 2016
Table of Contents
Executive Summary ........................................................................................................................................... 1-5
General Fund Revenue & Expense Comparison ................................................................................................. 6
Electric & Water Funds Revenue Comparison .................................................................................................... 7
Council Discretionary Fund Schedule .................................................................................................................. 8
Convention & Visitors Bureau Fund Schedule .................................................................................................... 9
Airport Fund Schedule ....................................................................................................................................... 10
Georgetown Transportation Enhancement Corporation Fund Schedule ........................................................ 11
Georgetown Economic Development Corporation Fund Schedule ................................................................. 12
Quarterly Investment Report - City ............................................................................................................. 13-26
Quarterly Investment Report - GTEC .......................................................................................................... 27-32
Quarterly Investment Report - GEDCO ....................................................................................................... 33-38
Grant Applications .............................................................................................................................................. 39
Capital Improvement Projects ..................................................................................................................... 40-44
Long-term Commitments and Other Unfunded Liabilities ......................................................................... 45-48
EXECUTIVE SUMMARY
FOR THE QUARTER ENDED June 30, 2016
I. Quarterly Financial Analysis
General Fund Revenues:
General Fund revenues collected for the third quarter of fiscal year 2016 are stronger than the prior year with a 4.5% increase.
The total revenue collected year to date (YTD) for the General Fund is $38.0 million.
Sales tax revenues continue to be higher than projected.
General Fund sales tax revenues for the third quarter of fiscal
year 2016 are 6.9% ahead of the third quarter of fiscal year
2015. The sales tax collections through May totaled $8.1
million, or 70.1% of budget. The growth in sales tax is primarily
driven by increases in our core sectors of retail trade, food, and
information, which are positively impacted by population
growth. It is currently anticipated that fiscal year 2016 sales tax
will exceed the budgeted amount.
Property tax revenues are typically received during the first two
quarters of the fiscal year, with the majority of the taxes being
received in December and January. 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 for the third quarter of 2016
are up 11.5%, or $1.1 million, from the third quarter of 2015. Our collection rate as of June 2016 is 98.44% compared to
97.69% last June.
The City collects a 4 – 5% franchise fee on electric, natural gas, cable, and non-cellular telephone revenues provided by entities
other than the City. The City has collected $1.3 million through the third quarter of 2016, which is an 8.3% decrease from the
third quarter of 2015. Franchise fees are typically collected on a quarterly basis and the timing of payments can vary. The City
also collects a 3% franchise fee and a 7% return on investment (ROI) fee from City owned utilities, which totaled $1.7 million
and $4.8 million respectively, through the third quarter
of the fiscal year. Franchise fee and ROI collections are
up 6.5% over this time last year. The electric ROI
calculation now includes a base rate component.
Environmental services revenues are up 4.3% from the
third quarter of 2015. This increase is related to the
growth in the customer base.
Development related revenue is up 21.5% over the prior
year, while inspection and permit revenue is down 6.6%.
Year to date development applications are up 14.1% over
last year.
1
Court fine revenues are down by 7.9% from prior year
due to a decrease in the number of court cases by 305
cases or 7.5% from prior year. Park and Recreation
revenues are up 2.5% from the prior year due to
increased Rec Center memberships sold (increased
13.4% from prior year). Other revenues are down
19.9% from the prior year due in part to a change in
methodology for the administrative allocations.
Overall, General Fund revenues are ahead of last
year’s revenues. Revenues will be closely monitored
over the upcoming months.
General Fund Expenditures:
General Fund operating expenditures for the third quarter of fiscal year 2016 are 4.2% higher than prior year, and within
budget. The General Fund is budgeted to have higher expenditures than the prior year due to Public Safety operations,
transportation budgets, new positions, and market and merit increases.
Total salaries and benefit expenditures through the third quarter were $21.5 million or 69.6% of budget. An additional $16.0
million, or 76.2% of budget, was spent on operations. Overall, personnel costs are higher than third quarter 2015 due to the
merit and cost of living adjustment (COLA) increases that went into effect February 2016. Operating expenditures are down
slightly compared to prior year.
Downtown and Community Services provides resources for developing downtown, as well as Parks and Recreation, Convention
and Visitors Bureau (CVB), Library, and Public Communications. Year to date expenditures are up 2.4% over third quarter 2016,
due in part to increases in internal service fees and higher personnel costs.
Finance and Administration in the General Fund consists of Municipal Court. Expenditures for the third quarter are up 4.8%
compared to last year. Personnel costs are up 2.8% due in part to higher wages and increased health insurance costs.
Operating expenditures are up 13.9% due to higher operating and technology costs.
Total expenditures for Public Safety through the third quarter are 75.8% of budget for a total of $19.1 million. Year to date
operating expenditures increased 18.7% over the prior year due in part to increases in salaries, vacant positions in the prior
year, and internal service fees relating to the new Public Safety Facility and technology. The Fire Division is projected to finish
the year $300,000 over budget due to personnel vacancies which is covered by overtime pay.
The Georgetown Utility System Division includes Environmental Services and Inspections. Environmental Services manages
the contract for solid waste collections. Total expenditures through the third quarter were 4.2% lower than the prior year.
Management Services includes City Manager’s Office, City Council, City Secretary, Planning and social service funding. Total
expenditures for the third quarter were $3.9 million and are 7.6% lower than the prior year.
Transportation includes Transportation Administration and Streets. Year to date expenditures have remained relatively flat
from June 2015 to June 2016, with a 1.4% or $29,439 decrease.
Utility Revenues:
2
Electric revenue through the third quarter of 2016 is up 0.4% compared to the prior year’s third quarter. Tap fee revenues are
down 63.1% from the prior year due to two large fees collected last year for Dispersol Technologies and Wesleyan 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 5.2%. Water sales are up 15.1% through the third quarter due an increase in
billed customers (increased by 6.1% from June 2015 to June 2016). Tap revenues are driven by the type of development the
City is experiencing. Other revenue is down 17.5% due to large payments received in the prior year from Newland Communities
and Teravista.
Total wastewater revenue is up 0.2% for fiscal year 2016 compared to last year. Wastewater revenues are up 6.1% due to an
increase in billed customers (increased by 5.8% from June 2015 to June 2016). Tap fees are up 21.6% 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 5.5%. While water revenues are up 24.1% due to an increase in billed customers,
other revenues are down 35.9% due to a settlement received from the City of Leander in the previous year. Tap revenues,
which are driven primarily by development, saw a 192.1% increase from June 2015 to June 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.
Other Revenues:
Hotel Occupancy Tax revenue is up 25.6%, or $150,585 from the prior year. Airport revenue is up 7.9% 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 third quarter of fiscal year 2016 includes
the maturing of six financial institution deposits (CD’s) totaling $18.6M and the purchase of eight new CD’s totaling $23.5M.
The eight new CD’s were purchased with a combination of funds received from the 2016 Spring bond issues as well as proceeds
from CD’s that matured during the quarter.
The Investment Reports for the quarter ended June 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 June 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
3/31/16 6/30/16 3/31/16 6/30/16 3/31/16 6/30/16
Total cash and investments
$115,830,440 $145,542,025 $14,139,315 $26,716,518 $5,783,670 $9,212,429
Average Yield 0.44% 0.51% 0.51% 0.54% 0.37% 0.40%
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 its 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:
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 the grand opening was July 26th. 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 89% of the direct costs associated with the Garage.
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
in the park. The schematic design for phase 1 and 2 was completed in April 2016. Design development and construction plans
for phase 1 will be the focus for the remainder of the year. Funds for Phase 1 design and construction have been budgeted at
$2.7 million. Design development documents are in progress. Construction is expected to begin in early 2017. Phase 1
improvements include spring restoration, pavilions, road realignment, play areas, restroom and parking.
4
Project 6DK Williams Drive Pool: The Williams Drive Pool is a 50 meter public swimming pool that was built in
1978. Improvements to this pool were identified through an Aquatics Master Plan prepared by the Parks and Recreation
Advisory Board and the ADA Transition Plan. The project renovation included public input from the neighborhood and user
groups including swim teams and water aerobics classes. Renovations began in March 2016 and include accessible walkways,
renovated bathhouse, outdoor pavilion, new fencing, and additional parking. The pool was open to the public on May 28,
2016. A grand opening celebration was held on June 18, 2016 with a dive in movie and over 150 attendees.
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. Amenities include an event center, equestrian facility, dog park, camping, trails, a playground, and a splash
pad. Construction plans are currently at 95% with bidding to begin on September 1, 2016. The construction project is
estimated to be $13.5 million.
Southwest Bypass: Southwest Bypass is a $20 million road providing a north-south connection on the west side of Georgetown
from DB Wood Road south to Leander Road. The new road was one of 20 transportation projects approved by Georgetown
voters in the May 2015 bond election. Planning for the project began nearly 30 years ago. Council awarded the Construction
Contract in February 2016. Project is under construction; contractor has cleared the right of way and begun setting subgrade.
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. Work is
expected to take place during November 2016.
5
2016 TOTAL
BUDGET
3RD QUARTER
YEAR TO DATE % BUDGET 2015 ACTUAL 3RD QUARTER
YEAR TO DATE % ACTUAL
VARIANCE YEAR
TO DATE
ACTUAL
VARIANCE
% ACTUAL
REVENUES:
Property Taxes 11,716,698 10,935,328 93.3%10,784,182 9,808,884 91.0%1,126,444 11.5%
Sales Tax 11,587,812 8,119,201 70.1%11,296,645 7,594,926 67.2%524,275 6.9%
Franchise Fee/ROI 12,722,293 7,755,504 61.0%12,358,246 7,279,525 58.9%475,979 6.5%
Development & Inspections 2,140,000 1,413,874 66.1%2,010,379 1,422,317 70.7%-8,443 -0.6%
Court Fines 616,500 362,844 58.9%529,920 393,935 74.3%-31,091 -7.9%
Parks & Recreation 2,203,620 1,833,865 83.2%2,193,506 1,789,940 81.6%43,925 2.5%
Other 4,746,400 2,822,004 59.5%4,565,351 3,523,047 77.2%-701,043 -19.9%
REVENUE WITHOUT ENVIRON. SVCS 45,733,323 33,242,620 72.7%43,738,229 31,812,574 72.7%1,430,046 4.5%
Environmental Services 6,554,000 4,795,839 73.2%6,534,836 4,599,687 70.4%196,152 4.3%
TOTAL REVENUES (1)52,287,323 38,038,459 72.7%50,273,065 36,412,261 72.4%1,626,198 4.5%
EXPENSES:
DOWNTOWN & COMMUNITY SVCS
Personnel 5,915,092 3,762,710 63.6%5,362,645 3,605,399 67.2%157,311 4.4%
Operations 4,171,532 3,503,988 84.0%3,940,906 3,489,111 88.5%14,878 0.4%
TOTAL DTOWN & COMM SVCS 10,086,624 7,266,698 72.0%9,303,551 7,094,510 76.3%172,188 2.4%
FINANCE & ADMINISTRATION
Personnel 457,818 318,877 69.7%214,218 310,082 144.8%8,796 2.8%
Operations 103,621 77,491 74.8%68,708 68,016 99.0%9,475 13.9%
TOTAL FINANCE & ADMIN 561,439 396,368 70.6%282,926 378,098 133.6%18,270 4.8%
FIRE
Personnel 9,283,022 7,025,060 75.7%8,837,801 6,292,359 71.2%732,702 11.6%
Operations 2,002,024 1,856,949 92.8%1,744,326 1,627,602 93.3%229,347 14.1%
TOTAL FIRE 11,285,046 8,882,010 78.7%10,582,127 7,919,961 74.8%962,049 12.1%
MANAGEMENT SERVICES
Personnel 1,825,075 1,313,456 72.0%1,641,961 1,157,698 70.5%155,758 13.5%
Operations 4,127,364 2,541,612 61.6%4,223,872 3,016,382 71.4%-474,770 -15.7%
TOTAL MANAGEMENT SVCS 5,952,439 3,855,068 64.8%5,865,832 4,174,080 71.2%-319,012 -7.6%
POLICE
Personnel 10,749,377 7,402,444 68.9%10,005,386 6,991,969 69.9%410,475 5.9%
Operations 3,251,123 2,887,244 88.8%2,647,146 2,370,562 89.6%516,682 21.8%
TOTAL POLICE 14,000,500 10,289,687 73.5%12,652,532 9,362,531 74.0%927,157 9.9%
TRANSPORTATION
Personnel 1,621,505 1,066,691 65.8%1,459,461 1,032,032 70.7%34,659 3.4%
Operations 1,574,244 1,070,360 68.0%1,607,305 1,134,457 70.6%-64,098 -5.7%
TOTAL TRANSPORTATION 3,195,749 2,137,051 66.9%3,066,766 2,166,490 70.6%-29,439 -1.4%
SUBTOTAL - OPERATING EXP
Personnel 29,851,889 20,889,238 70.0%27,521,472 19,389,538 70.5%1,499,700 7.7%
Operations 15,229,908 11,937,644 78.4%14,232,263 11,706,130 82.3%231,514 2.0%
OPERATING EXPENSES 45,081,797 32,826,882 72.8%41,753,735 31,095,668 74.5%1,731,214 5.6%
GUS - ENVIRONMENTAL SERVICES
Personnel 1,059,853 620,427 58.5%809,629 554,887 68.5%65,540 11.8%
Operations 5,729,376 4,031,901 70.4%5,719,397 4,300,814 75.2%-268,912 -6.3%
TOTAL GUS 6,789,229 4,652,328 68.5%6,529,026 4,855,701 74.4%-203,372 -4.2%
TOTAL OPERATING EXPENSES
Personnel 30,911,742 21,509,665 69.6%28,331,101 19,944,425 70.4%1,565,240 7.8%
Operations 20,959,284 15,969,546 76.2%19,951,660 16,006,944 80.2%-37,398 -0.2%
TOTAL OPERATING EXPENSES (2)51,871,026 37,479,210 72.3%48,282,761 35,951,369 74.5%1,527,842 4.2%
NOTES:
(1) Excludes transfers.
(2) Excludes capital related expenditures.
GENERAL FUND REVENUE & EXPENSE COMPARISON
FOR THE QUARTER ENDING JUNE 30, 2016
6
REVENUES:
2016
TOTAL
BUDGET
3RD QUARTER
YEAR TO DATE
%
BUDGET
2015
ACTUALS
3RD QUARTER
YEAR TO DATE
%
ACTUAL
VARIANCE YEAR
TO DATE
ACTUAL
VARIANCE %
ACTUAL
Electric & Water Fund Revenues:
ELECTRIC
Electric revenue 63,400,000 38,460,467 60.7%60,870,101 38,343,839 63.0%116,628 0.3%
Electric tap revenue 250,000 66,400 26.6%178,494 180,044 100.9%-113,644 -63.1%
Electric other revenue 1,549,775 1,799,835 116.1%2,168,463 1,640,885 75.7%158,950 9.7%
TOTAL ELECTRIC REVENUE 65,199,775 40,326,702 61.9%63,217,059 40,164,768 63.5%161,934 0.4%
WATER
Water revenue 17,000,000 11,542,118 67.9%17,107,087 10,023,822 58.6%1,518,296 15.1%
Water tap revenue 1,186,672 856,866 72.2%1,301,318 1,134,402 87.2%-277,536 -24.5%
Water other revenue 3,687,160 2,425,511 65.8%3,734,065 2,939,523 78.7%-514,012 -17.5%
TOTAL WATER REVENUE 21,873,832 14,824,495 67.8%22,142,470 14,097,747 63.7%726,748 5.2%
WASTEWATER
Wastewater revenue**9,603,822 6,812,103 70.9%9,493,690 6,418,986 67.6%393,117 6.1%
Wastewater tap revenue**575,000 604,038 105.1%647,058 496,685 76.8%107,353 21.6%
Wastewater other revenue **1,848,750 869,501 47.0%1,737,503 1,351,414 77.8%-481,913 -35.7%
TOTAL WASTEWATER REVENUE 12,027,572 8,285,642 68.9%11,878,251 8,267,085 69.6%18,557 0.2%
RURAL WATER
Rural water revenue 5,640,000 4,430,448 78.6%6,291,773 3,571,080 56.8%859,368 24.1%
Rural water tap revenue 413,916 540,650 130.6%385,251 185,101 48.0%355,549 192.1%
Rural water other revenue 2,336,732 1,558,229 66.7%2,899,805 2,431,046 83.8%-872,817 -35.9%
TOTAL RURAL WATER REVENUE 8,390,648 6,529,327 77.8%9,576,830 6,187,227 64.6%342,100 5.5%
TOTAL ELECTRIC & WATER FUND REVENUES 107,491,827 69,966,166 65.1%106,814,610 68,716,827 64.3%1,249,339 1.8%
NOTES:
Does not include transfers or bond proceeds.
**Includes Irrigation revenue
ELECTRIC & WATER FUNDS REVENUE COMPARISON
FOR THE QUARTER ENDING JUNE 30, 2016
7
YEAR-END YEAR-END
APPROVED JUN-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%
REVENUE
Interest 0 0 436 0 0 0.0%
Total Revenue 0 0 436 0 0 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 0 185,481 185,045 0 0.0%
ENDING BALANCE 185,045 185,045 0 0.0%
Council Discretionary Fund
Year End Projection to Approved as of June 2016
8
YEAR-END YEAR-END
APPROVED JUN-16 YEAR TO DATE YEAR-END VARIANCE % VARIANCE
BUDGET W/ENCUMB W/ENCUMB PROJECTION FAV(UNFAV)FAV(UNFAV)
BEGINNING BALANCE 488,178 483,025 (5,153)(1.1%)
REVENUES
Hotel/Motel Occupancy Tax Revenues 860,000 74,462 570,416 930,000 70,000 8.1%
Poppy Festival 125,000 422 157,203 125,000 0 0.0%
Interest 1,500 0 1,016 1,500 0 0.0%
Other 8,000 655 9,391 8,000 0 0.0%
Total Revenues 994,500 75,539 738,026 1,064,500 70,000 7.0%
EXPENDITURES
Personnel 336,778 23,390 221,015 336,778 0 0.0%
Operations 298,612 11,910 259,083 313,006 (14,394)(4.8%)
Capital 100,000 0 25,000 0 100,000 100.0%
Poppy Festival 85,000 470 113,630 103,700 (18,700)(22.0%)
Transfer to General Capital Projects 100,000 25,000 75,000 100,000 0 0.0%
Transfer to General Fund 10,000 2,500 7,500 10,000 0 0.0%
Transfer to Fleet 29,620 6,500 23,120 29,620 0 0.0%
Transfer to Information Technology 27,364 200 27,164 27,364 0 0.0%
Transfer to Facilities 48,751 0 48,751 48,751 0 0.0%
Total Expenditures 1,036,125 69,970 800,263 969,219 66,906 6.5%
EXCESS (DEFICIENCY) OF TOTAL
REVENUE OVER TOTAL
REQUIREMENTS (41,625)5,569 (62,237)95,281 136,906 328.9%
ENDING BALANCE 446,553 578,306 131,753 29.5%
CONTINGENCY 200,000 200,000
Convention & Visitors Bureau Fund
Year End Projection to Approved as of June 2016
9
YEAR-END YEAR-END
APPROVED JUN-16 YEAR TO DATE YEAR-END VARIANCE % VARIANCE
BUDGET W/ENCUMB W/ENCUMB PROJECTION FAV(UNFAV)FAV(UNFAV)
BEGINNING BALANCE 748,167$ 792,318$ 44,151$ 5.9%
OPERATING REVENUE
Fuel and Terminal Sales 2,876,150 203,039 1,487,043 1,988,444 (887,706)(30.9%)
Leases and Rentals 657,400 57,313 509,679 707,049 49,649 7.6%
Interest and Other 67,400 2,245 20,500 63,738 (3,662)(5.4%)
Total Operating Revenue 3,600,950 262,597 2,017,221 2,759,231 (841,719)(23.4%)
OPERATING EXPENDITURES
Personnel 321,471 23,717 213,239 317,632 3,839 1.2%
Operations-Fuel 2,448,882 0 2,547,600 1,549,525 899,357 36.7%
Operations-Non Fuel 644,679 22,309 517,530 661,791 (17,112)(2.7%)
Transfers Out 15,080 3,770 11,310 15,080 0 0.0%
Debt Service 80,222 85 26,595 139,657 (59,435)(74.1%)
Total Operating Expenditures 3,510,334 49,882 3,316,275 2,683,685 826,649 23.5%
TOTAL NET OPERATIONS 90,616 212,715 (1,299,054)75,546 (15,070)(16.6%)
NON-OPERATING REVENUE
Grants 25,000 17,831 37,939 50,000 25,000 100.0%
TxDot Refunds 0 0 39,405 39,405 39,405 NA
Total Non-Operating Revenue 25,000 17,831 77,344 89,405 39,405 157.6%
NON-OPERATING EXPENDITURES
One Time 0 0 6,080 6,080 (6,080) NA
Runway Lights 757,935 0 750,000 757,935 0 0.0%
Fuel Farm 100,000 0 87,705 100,000 0 0.0%
Software 20,000 0 0 10,000 10,000 50.0%
Total Non-Operating Expenditures 877,935 0 843,785 874,015 3,920 0.4%
TOTAL NET NON-OPERATIONS (852,935)17,831 (766,441)(784,610)43,325 5.1%
EXCESS (DEFICIENCY) OF TOTAL
REVENUE OVER TOTAL
REQUIREMENTS (762,319)$ 230,547$ (2,065,495)$ (709,064)$ 53,255$ 7.0%
ENDING BALANCE (14,152)83,254 97,406 688.3%
Airport Operations Fund
Year End Projection to Approved as of June 2016
10
YEAR-END YEAR-END
APPROVED JUN-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 (63,849)(0.7%)
OPERATING REVENUE
Sales Tax 5,381,250 436,692 3,273,914 5,625,000 243,750 4.5%
Public Improve. District Assessments 500,000 0 0 500,000 0 0.0%
Interest 15,000 11,286 46,485 36,000 21,000 140.0%
Reimbursement from TXDOT 450,000 0 77,867 450,000 0 0.0%
Total Operating Revenue 6,346,250 447,978 3,398,266 6,611,000 264,750 4.2%
OPERATING EXPENDITURES
Administrative Support 376,132 (65,867)124,585 124,901 251,231 66.8%
Debt Service 2,572,312 509,314 985,923 2,638,581 (66,269)(2.6%)
Total Operating Expenditures 2,948,444 443,447 1,110,508 2,763,482 184,962 6.3%
TOTAL NET OPERATIONS 3,397,806 4,532 2,287,758 3,847,518 79,788 2.3%
NON-OPERATING REVENUE
Debt Proceeds (FY16)17,500,000 509,167 11,217,429 11,659,167 (5,840,833)(33.4%)
Total Non-Operating Revenue 17,500,000 509,167 11,217,429 11,659,167 (5,840,833)(33.4%)
NON-OPERATING EXPENDITURES
ROW 1460 (FY12)500,000 0 361,130 500,000 0 0.0%
FM 1460 Widening (FY15)61,000 0 3 61,000 0 0.0%
SW Bypass-SH 29 to RM 2243 (FY14)1,332,579 0 1,023,911 1,332,579 0 0.0%
SW Bypass-SW Inner Loop 29 (FY15)0 0 8,585 8,585 (8,585)NA
SW Bypass-2243 to IH35 (FY06)1,121,000 0 9,035 1,121,000 0 0.0%
Arterial SE 1-Inner Loop (FY04)0 0 2,036 2,036 (2,036)NA
FM 971 Northwest-Washam IH35 (FY09)91,590 0 0 91,590 0 0.0%
Wolf Ranch Pkwy Ext - DB Wood (FY10)283,350 0 0 0 283,350 100.0%
Snead Dr (FY11)20,000 0 46 46 19,954 99.8%
Williams Dr Gateway (FY13)794,000 0 215 794,000 0 0.0%
Rivery-Ext Williams Dr to NW Blvd (FY16)1,500,000 0 1,590,966 1,590,966 (90,966)(6.1%)
Rivery-TIA Improvements (FY16)1,400,000 0 0 400,000 1,000,000 71.4%
Rivery-Rivery Rd (FY13)721,000 0 0 721,000 0 0.0%
SH 29 Int.-IH35 to Haven Ln (FY14)650,000 0 0 0 650,000 100.0%
Pecan Center Dr to Airport Rd (FY15)6,364,000 0 0 2,000,000 4,364,000 68.6%
Mays St (FY15)10,150,000 38 2,783 10,150,000 0 0.0%
Available for Projects TBD 1,345,312 0 0 0 1,345,312 100.0%
Total Non-Operating Expenditures 26,333,831 38 2,998,710 18,772,802 7,561,029 28.7%
TOTAL NET NON-OPERATIONS (8,833,831)509,128 8,218,720 (7,113,635)1,720,196 (19.5%)
EXCESS (DEFICIENCY) OF TOTAL
REVENUE OVER TOTAL
REQUIREMENTS (5,436,025)513,660 10,506,477 (3,266,117)2,169,908 (39.9%)
ENDING BALANCE 3,156,091 5,262,150 2,106,059 66.7%
RESERVED ENDING BALANCE 1,474,063
Georgetown Transportation Enhancement Corporation Fund
Year End Projection to Approved as of June 2016
11
YEAR-END YEAR-END
APPROVED JUN-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 8,421 0.2%
OPERATING REVENUES
Sales Tax 1,345,313 104,859 818,478 1,406,750 61,437 4.6%
Interest 7,500 3,042 16,981 12,427 4,927 65.7%
Miscellaneous Revenue 0 9,938 59,958 56,750 56,750 NA
Lease Revenue (Grape Creek)48,000 4,000 36,000 48,000 0 0.0%
Total Operating Revenues 1,400,813 121,839 931,417 1,523,927 123,114 8.8%
OPERATING EXPENDITURES
Debt Service 106,694 0 16,133 106,694 0 0.0%
Bond Issuance Costs 87,500 0 18,224 18,224 69,276 79.2%
Interlocal Agreement 211,200 0 136,611 136,611 74,589 35.3%
Supplies 300 0 2 2 298 99.3%
Special Services 7,500 0 0 0 0 0.0%
Travel & Training 1,500 0 730 730 770 51.3%
Promotional & Marketing Program 81,000 6,000 25,552 25,552 0 0.0%
Miscellaneous Expense 2,500 11,429 11,429 11,429 (8,929)(357.2%)
Total Operating Expenditures 498,194 17,429 208,681 299,242 136,004 27.3%
TOTAL NET OPERATIONS 902,619 104,410 722,736 1,224,685 (12,890)(1.4%)
NON-OPERATING REVENUES
Bond Proceeds 3,100,000 0 2,977,185 2,977,185 (122,815)(4.0%)
Premium on Bond Issuance 0 0 141,562 141,562 141,562 NA
Total Non-Operating Revenues 3,100,000 0 3,118,747 3,118,747 18,747 0.6%
NON-OPERATING EXPENDITURES
Catalyst 71,000 0 0 71,000 0 0.0%
DisperSol 200,000 0 20,000 20,000 180,000 90.0%
Economic Development Projects -Undetermined 3,988,774 0 0 0 3,988,774 100.0%
Georgetown ISD 109,496 0 0 15,649 93,847 85.7%
Rivery 4,500,000 0 0 4,500,000 0 0.0%
Tasus 67,500 0 0 0 67,500 100.0%
Texas Life Sciences 100,000 0 100,000 100,000 0 0.0%
Total Non-Operating Expenditures 9,036,770 0 120,000 4,706,649 4,330,121 47.9%
TOTAL NET NON-OPERATIONS (5,936,770)0 2,998,747 (1,587,902)(4,311,374)72.6%
EXCESS (DEFICIENCY) OF TOTAL
REVENUE OVER TOTAL
REQUIREMENTS (5,034,151)104,410 3,721,483 (363,217)4,670,934 (92.8%)
ENDING BALANCE 336,328 5,015,683 4,679,355 1,391.3%
RESERVED ENDING BALANCE 336,328 351,688
Georgetown Economic Development Corporation Fund
Year End Projection to Approved as of June 2016
12
Summary
Quarter End Results by Investment Category:
Asset Type Ave. Yield Book Value Market Value Book Value Market Value
Demand Accounts 0.29% 18,480,032$ 18,480,032 18,685,856$ 18,685,856$
NOW/MMA 0.54% 19,591,997 19,591,997 5,342,393 5,342,393
Pools 0.39% 37,013,767 37,013,767 76,766,844 76,766,844
Certificates of Deposit 0.80% 40,744,644 40,744,644 44,746,933 44,746,933
Totals 115,830,440$ 115,830,440$ 145,542,025$ 145,542,025$
Quarter End Average Yield (1)Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.51%Total Portfolio 0.45%
Rolling Three Mo. Treas. Yield 0.26%Rolling Three Mo. Treas. Yield 0.23%
Rolling Six Mo. Treas. Yield 0.42%Rolling Six Mo. Treas. Yield 0.35%
Quarterly TexPool Yield 0.29%
12,516$
Interest income provided in separate report.35,448$
March 31, 2016 June 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.
Page 1.14
City - Detail of 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% 07/01/16 06/30/16 18,685,856$ 18,685,856$ 1.00 18,685,856$ 1 0.29%
Southside Bank MMA 0.51% 07/01/16 06/30/16 920,375 920,375 1.00 920,375 1 0.51%
Green Bank MMA 0.55% 07/01/16 06/30/16 4,422,017 4,422,017 1.00 4,422,017 1 0.55%
TexPool AAAm 0.36% 07/01/16 06/30/16 4,478,019 4,478,019 1.00 4,478,019 1 0.36%
TexSTAR AAAm 0.39% 07/01/16 06/30/16 72,288,824 72,288,824 1.00 72,288,824 1 0.39%
BTH Bank CDARS 0.75% 08/04/16 02/05/15 1,515,864 1,515,864 100.00 1,515,864 35 0.75%
BTH Bank CDARS 0.75% 08/18/16 11/20/14 2,530,440 2,530,440 100.00 2,530,440 49 0.75%
Southside Bank CD 0.51% 09/02/16 09/02/15 2,007,667 2,007,667 100.00 2,007,667 64 0.51%
Southside Bank CD 0.51% 09/02/16 09/02/15 2,007,667 2,007,667 100.00 2,007,667 64 0.51%
LegacyTexas Bank CD 0.55% 09/07/16 12/07/15 1,002,754 1,002,754 100.00 1,002,754 69 0.55%
Independent Bank CD 0.65% 09/24/16 12/24/14 3,029,370 3,029,370 100.00 3,029,370 86 0.65%
RBank CD 1.06% 09/29/16 09/29/14 2,037,460 2,037,460 100.00 2,037,460 91 1.06%
BTH Bank CDARS 0.80% 11/03/16 02/05/15 1,516,928 1,516,928 100.00 1,516,928 126 0.80%
BTH Bank CDARS 0.85% 11/17/16 11/20/14 3,041,433 3,041,433 100.00 3,041,433 140 0.85%
LegacyTexas Bank CD 0.60% 12/07/16 12/07/15 5,015,024 5,015,024 100.00 5,015,024 160 0.60%
BTH Bank CDARS 0.90% 02/02/17 02/05/15 1,519,057 1,519,057 100.00 1,519,057 217 0.90%
LegacyTexas Bank CD 0.83% 04/13/17 05/23/16 2,001,410 2,001,410 100.00 2,001,410 287 0.83%
LegacyTexas Bank CD 0.83% 04/13/17 05/23/16 4,002,820 4,002,820 100.00 4,002,820 287 0.83%
Lubbock National Bank CD 0.95% 07/03/17 05/23/16 3,002,421 3,002,421 100.00 3,002,421 368 0.95%
Lubbock National Bank CD 0.95% 07/03/17 05/23/16 2,502,017 2,502,017 100.00 2,502,017 368 0.95%
Lubbock National Bank CD 0.95% 07/03/17 05/23/16 3,002,421 3,002,421 100.00 3,002,421 368 0.95%
LegacyTexas Bank CD 0.95% 08/18/17 06/23/16 3,010,482 3,010,482 100.00 3,010,482 414 0.95%
Lubbock National Bank CD 1.00% 10/02/17 05/23/16 2,001,699 2,001,699 100.00 2,001,699 459 1.00%
145,542,025$ 145,542,025$ 145,542,025$670.51%
(1) (2)
June 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.Page 3.16
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% 07/01/16 18,480,032$ 18,480,032$ 205,823$ –$ 18,685,856$ 18,685,856$
Comerica Bank MMA 0.00% 07/01/16 9,497,368 9,497,368 (9,497,368) – –
Southside Bank MMA 0.51% 07/01/16 10,094,629 10,094,629 (9,174,254) 920,375 920,375
Green Bank MMA 0.55% 07/01/16 – – 4,422,017 4,422,017 4,422,017
TexPool 0.36% 07/01/16 6,571,929 6,571,929 (2,093,910) 4,478,019 4,478,019
TexSTAR 0.39% 07/01/16 30,441,838 30,441,838 41,846,987 72,288,824 72,288,824
BTH Bank CDARS 0.70%05/05/16 1,512,160 1,512,160 (1,512,160)– –
Comerica CD 0.65%05/12/16 3,035,988 3,035,988 (3,035,988)– –
Southside Bank CD 0.38%06/02/16 4,007,583 4,007,583 (4,007,583)– –
LegacyTexas Bank CD 0.50%06/07/16 4,004,978 4,004,978 (4,004,978)– –
LegacyTexas Bank CD 0.70%06/22/16 3,005,168 3,005,168 (3,005,168)– –
BTH Bank CDARS 0.75%08/04/16 1,513,032 1,513,032 2,832 1,515,864 1,515,864
BTH Bank CDARS 0.75%08/18/16 2,525,713 2,525,713 4,727 2,530,440 2,530,440
Southside Bank CD 0.51%09/02/16 2,005,089 2,005,089 2,578 2,007,667 2,007,667
Southside Bank CD 0.51%09/02/16 2,005,089 2,005,089 2,578 2,007,667 2,007,667
LegacyTexas Bank CD 0.55%09/07/16 1,001,369 1,001,369 1,385 1,002,754 1,002,754
Independent Bank CD 0.65%09/24/16 3,024,429 3,024,429 4,942 3,029,370 3,029,370
RBank CD 1.06%09/29/16 2,032,024 2,032,024 5,436 2,037,460 2,037,460
BTH Bank CDARS 0.80%11/03/16 1,513,905 1,513,905 3,023 1,516,928 1,516,928
BTH Bank CDARS 0.85%11/17/16 3,034,994 3,034,994 6,439 3,041,433 3,041,433
LegacyTexas Bank CD 0.60%12/07/16 5,007,468 5,007,468 7,556 5,015,024 5,015,024
BTH Bank CDARS 0.90%02/02/17 1,515,652 1,515,652 3,405 1,519,057 1,519,057
LegacyTexas Bank CD 0.83%04/13/17 – – 2,001,410 2,001,410 2,001,410
LegacyTexas Bank CD 0.83%04/13/17 – – 4,002,820 4,002,820 4,002,820
Lubbock National Bank CD 0.95%07/03/17 – – 3,002,421 3,002,421 3,002,421
Lubbock National Bank CD 0.95%07/03/17 – – 2,502,017 2,502,017 2,502,017
Lubbock National Bank CD 0.95%07/03/17 – – 3,002,421 3,002,421 3,002,421
LegacyTexas Bank CD 0.95%08/18/17 – – 3,010,482 3,010,482 3,010,482
Lubbock National Bank CD 1.00%10/02/17 – – 2,001,699 2,001,699 2,001,699
TOTAL 115,830,440$ 115,830,440$ 66,042,994$ (36,331,409)$ 145,542,025$ 145,542,025$
March 31, 2016 June 30, 2016
Valley View Consulting, L.L.C.Page 5.18
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 Debt Service
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 11,555,064
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$ 11,555,064$
Book and Market Value
June 30, 2016
Valley View Consulting, L.L.C.Page 6.19
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
Book and Market Value
June 30, 2016
(Continued)
Police
Restricted
Seizure
Utility Debt
Service
2015 CO-
Airport
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 CO-Tax
Facilities
2015 CO-
Water
2015 GO-
Roads
2015A GO-
Roads
–$ –$ –$ –$ –$ –$ –$ –$ –$
1,390 67,717 29,638 2,134,355 1,420,408 3,450,350 758,624 4,304,969 4,645,972
5,015,024
1,390$ 67,717$ 29,638$ 2,134,355$ 1,420,408$ 3,450,350$ 758,624$ 4,304,969$ 9,660,996$
Valley View Consulting, L.L.C.Page 7.20
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
Book and Market Value
June 30, 2016
(Continued)
2015A GO-
Parks
2015 Revenue
Electric
2015 Revenue
Water WW
2016 CO-
Rivery TIRZ
2016 CO-
Stormwater
2016 CO-
Streets/
Facilities/
Equip
2016 GO
Bonds
2016 GO-
Parks
2016 GO-
Roads
–$ –$ –$ –$ –$ –$ –$ –$ –$
701,442 5,731,707 1,713,915 250,280 3,252,635 3,004,251 1,010,462
2,007,667
2,007,667
1,002,754
4,002,820
3,002,421
2,001,699
1,704,197$ 2,007,667$ 7,739,374$ 1,713,915$ 250,280$ 3,252,635$ 9,006,939$ 3,004,251$ 1,010,462$
Valley View Consulting, L.L.C.Page 8.21
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
Book and Market Value
June 30, 2016
(Continued)
2016 Revenue
Electric
2016 Revenue
Water/WW
Garey Park
Donation
–$ –$ –$
1,796,026 3,525,716 5,003,375
2,001,410
2,502,017
1,796,026$ 8,029,143$ 5,003,375$
Valley View Consulting, L.L.C.Page 9.22
City - Allocation
Investment Total Consolidated 2013 GO 2013 CO 2014 CO 2014 GO
2014
Revenue
Electric
2014 Revenue
Water WW Debt Service
JPMorgan Chase Cash 18,480,032$ 18,480,032$ –$ –$ –$ –$ –$ –$ –$
Comerica Bank MMA 9,497,368 905,412 1,719,142 409,315 3,474,396
Southside Bank MMA 10,094,629 484,597 5,092,425 682,728
TexPool 6,571,929 6,571,929
TexSTAR 30,441,838 6,798,229 1,791,192 94,537 11,060,031
BTH Bank CDARS 05/05/16 1,512,160 1,512,160
Comerica CD 05/12/16 3,035,988 3,035,988
Southside Bank CD 06/02/16 4,007,583
LegacyTexas Bank CD 06/07/16 4,004,978
LegacyTexas Bank CD 06/22/16 3,005,168 3,005,168
BTH Bank CDARS 08/04/16 1,513,032 1,513,032
BTH Bank CDARS 08/18/16 2,525,713 2,525,713
Southside Bank CD 09/02/16 2,005,089
Southside Bank CD 09/02/16 2,005,089
LegacyTexas Bank CD 09/07/16 1,001,369
Independent Bank CD 09/24/16 3,024,429 3,024,429
RBank CD 09/29/16 2,032,024 2,032,024
BTH Bank CDARS 11/03/16 1,513,905 1,513,905
BTH Bank CDARS 11/17/16 3,034,994 3,034,994
LegacyTexas Bank CD 12/07/16 5,007,468
BTH Bank CDARS 02/02/17 1,515,652 1,515,652
Totals 115,830,440$ 52,928,074$ 5,092,425$ 1,719,142$ 682,728$ 409,315$ 1,791,192$ 6,594,125$ 11,060,031$
March 31, 2016
Book and Market Value
Valley View Consulting, L.L.C.Page 10.23
City - Allocation
JPMorgan Chase Cash
Comerica Bank MMA
Southside Bank MMA
TexPool
TexSTAR
BTH Bank CDARS 05/05/16
Comerica CD 05/12/16
Southside Bank CD 06/02/16
LegacyTexas Bank CD 06/07/16
LegacyTexas Bank CD 06/22/16
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
Totals
March 31, 2016
Book and Market Value
(Continued)
Police
Restricted
Seizure
Utility Debt
Service
2015 CO-
Airport
2015 CO-
Parks/Streets/
Vehicles
2015 CO-
Stormwater
2015 CO-Tax
Facilities
2015 CO-
Water
2015 GO-
Roads
2015A GO-
Roads
–$ –$ –$ –$ –$ –$ –$ –$ –$
2,989,103
1,870,402 757,953 1,206,524
1,389 67,653 859,511 281,328 1,419,077 4,694,260 106,317 837,081
4,004,978
5,007,468
1,389$ 67,653$ 859,511$ 2,151,731$ 1,419,077$ 4,694,260$ 757,953$ 4,301,943$ 9,849,528$
Valley View Consulting, L.L.C.Page 11.24
City - Allocation
JPMorgan Chase Cash
Comerica Bank MMA
Southside Bank MMA
TexPool
TexSTAR
BTH Bank CDARS 05/05/16
Comerica CD 05/12/16
Southside Bank CD 06/02/16
LegacyTexas Bank CD 06/07/16
LegacyTexas Bank CD 06/22/16
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
Totals
March 31, 2016
Book and Market Value
(Continued)
2015A GO-
Parks
2015 Revenue
Electric
2015 Revenue
Water WW
–$ –$ –$
700,785 1,730,448
4,007,583
2,005,089
2,005,089
1,001,369
1,702,154$ 2,005,089$ 7,743,121$
Valley View Consulting, L.L.C.Page 12.25
Summary
Quarter End Results by Investment Category:
Asset Type Ave. Yield Book Value Market Value Book Value Market Value
Pools 0.38% 4,572,756$ 4,572,756$ 16,140,952$ 16,140,952$
Certificates of Deposit 0.79% 9,566,559 9,566,559 10,575,566 10,575,566
Totals 14,139,315$ 14,139,315$ 26,716,518$ 26,716,518$
Quarter End Average Yield (1)Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.54%Total Portfolio 0.51%
Rolling Three Mo. Treas. Yield 0.26%Rolling Three Mo. Treas. Yield 0.23%
Rolling Six Mo. Treas. Yield 0.42%Rolling Six Mo. Treas. Yield 0.35%
Quarterly TexPool Yield 0.29%
Interest data provided in separate report.
March 31, 2016 June 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.
Page 1.28
Detail of 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.36% 07/01/16 06/30/16 5,913,701$ 5,913,701$ 1.00 5,913,701$ 1 0.36%
TexSTAR AAAm 0.39% 07/01/16 06/30/16 10,227,251 10,227,251 1.00 10,227,251 1 0.39%
Comerica Bank CD 0.67% 08/15/16 08/14/14 3,037,088 3,037,088 100.00 3,037,088 46 0.67%
LegacyTexas Bank CD 0.60% 12/07/16 12/07/15 1,504,507 1,504,507 100.00 1,504,507 160 0.60%
RBank CD 0.80% 12/30/16 12/30/15 2,030,743 2,030,743 100.00 2,030,743 183 0.80%
Lubbock National Bank CD 0.95% 07/03/17 05/23/16 4,003,227 4,003,227 100.00 4,003,227 368 0.95%
26,716,518$ 26,716,518$ 26,716,518$ 84 0.54%
(1) (2)
June 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.Page 3.30
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.36% 07/01/16 4,515,893$ 4,515,893$ 1,397,808$ –$ 5,913,701$ 5,913,701$
TexSTAR 0.39% 07/01/16 56,863 56,863 10,170,388 10,227,251 10,227,251
Southside Bank CD 0.38% 06/02/16 3,005,687 3,005,687 (3,005,687)– –
Comerica Bank CD 0.67% 08/15/16 3,031,979 3,031,979 5,109 3,037,088 3,037,088
LegacyTexas Bank CD 0.60% 12/07/16 1,502,241 1,502,241 2,267 1,504,507 1,504,507
RBank CD 0.80% 12/30/16 2,026,652 2,026,652 4,091 2,030,743 2,030,743
Lubbock National Bank CD 0.95% 07/03/17 – – 4,003,227 4,003,227 4,003,227
TOTAL 14,139,315$ 14,139,315$ 15,582,889$ (3,005,687)$ 26,716,518$ 26,716,518$
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.36% 07/01/16 4,515,893$ 4,515,893$ 1,397,808$ 5,913,701$ 5,913,701$
TexSTAR 0.39% 07/01/16 56,863 56,863 10,170,388 10,227,251 10,227,251
Southside Bank CD 0.38% 06/02/16 3,005,687 3,005,687 (3,005,687)– –
Comerica Bank CD 0.67% 08/15/16 3,031,979 3,031,979 5,109 3,037,088 3,037,088
LegacyTexas Bank CD 0.60% 12/07/16 1,502,241 1,502,241 2,267 1,504,507 1,504,507
RBank CD 0.80% 12/30/16 2,026,652 2,026,652 4,091 2,030,743 2,030,743
Lubbock National Bank CD 0.95% 07/03/17 – – 4,003,227 4,003,227 4,003,227
TOTAL 14,139,315$ 14,139,315$ 12,577,202$ 26,716,518$ 26,716,518$
March 31, 2016 June 30, 2016
March 31, 2016 June 30, 2016
Valley View Consulting, L.L.C.Page 5.32
Summary
Quarter End Results by Investment Category:
Asset Type Ave. Yield Book Value Market Value Book Value Market Value
Pools 0.40% 5,783,670$ 5,783,670$ 9,212,429$ 9,212,429$
Certificates of Deposit 0.00%– – – –
5,783,670$ 5,783,670$ 9,212,429$ 9,212,429$
Quarter End Average Yield (1)Fiscal Year-to-Date Average Yield (2)
Total Portfolio 0.40%Total Portfolio 0.36%
Rolling Three Mo. Treas. Yield 0.26%Rolling Three Mo. Treas. Yield 0.23%
Rolling Six Mo. Treas. Yield 0.42%Rolling Six Mo. Treas. Yield 0.35%
Quarterly TexPool Yield 0.29%
Interest income provided in separate report.
March 31, 2016 June 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.
Page 1.34
Detail of Investment Holdings
Coupon/Maturity Settlement Face Amount/Book Market Market Life
Description Ratings Discount Date Date Par Value Value Price Value (Day)Yield
TexasDAILY AAAm 0.44% 07/01/16 06/30/16 2,007,020$ 2,007,020$ 1.00 2,007,020$ 1 0.44%
TexSTAR AAAm 0.39% 07/01/16 06/30/16 7,205,408 7,205,408 1.00 7,205,408 1 0.39%
9,212,429$ 9,212,429$ 9,212,429$ 1 0.40%
(1) (2)
June 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.Page 3.36
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
TexasDAILY 0.44% 07/01/16 2,004,866$ 2,004,866$ 2,154$ –$ 2,007,020$ 2,007,020$
TexSTAR 0.39% 07/01/16 3,778,803 3,778,803 3,426,605 7,205,408 7,205,408
TOTAL 5,783,670$ 5,783,670$ 3,428,759$ –$ 9,212,429$ 9,212,429$
Market Value Comparison Qtr to Qtr
Change
TexasDAILY 0.44% 07/01/16 2,004,866$ 2,004,866$ 2,154$ 2,007,020$ 2,007,020$
TexSTAR 0.39% 07/01/16 3,778,803 3,778,803 3,426,605 7,205,408 7,205,408
TOTAL 5,783,670$ 5,783,670$ 3,428,759$ 9,212,429$ 9,212,429$
March 31, 2016 June 30, 2016
March 31, 2016 June 30, 2016
Valley View Consulting, L.L.C.Page 5.38
Capital Improvement Projects
For the Quarter Ended
June 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 - 335,020 60,977 (395,997) [a]
6DP Fire Station ESD 550,000 - - 550,000
6DQ EOC Siren System 1,000,000 - - 1,000,000
6EW Transfer Station / Landfill 210,000 12,350 12,555 185,095
9BE Preventative Maintenance - - 560,519 (560,519)
Public Safety & Facilities Subtotal 3,660,000 356,124 634,051 2,669,825
Parks CIP Bonds
1AU Street Rehab-West - 3,170 - (3,170) [a]
1BU Streets Rehabilitation - 120,452 (120,452) -
1DN Access to Rtw to Gov Srv - - 9,118 (9,118) [a]
1DP 8th St Church to Myrtle - - 11,923 (11,923) [a]
1DU 8th St Austin to MLK - 1,073 10,850 (11,923) [a]
1DV Church St 8th to 9th - - 11,923 (11,923) [a]
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 246,452 (246,452) 2,049,900
6DB McMaster Park 96,000 2,500 15,368 78,132
6DD New Village Parks - 4,425 15,925 (20,350) [a]
6DE SG Bank Stabilization 416,700 234,863 184,876 (3,039)
6DH Sidewalks 904,900 - 2,715 902,185
6DK Williams Dr. Pool 827,000 849,631 (12,742) (9,889) [a]
6DM VFW Park 1,314,800 134,825 1,180,497 (522)
6DN Historic Park 257,700 - - 257,700
6DO Garey Park 3,000,000 605,472 (597,862) 2,992,390
6DZ ADA Sidewalks Repairs 100,000 - - 100,000
6EA General Repair / Maintenance 132,000 - - 132,000
6EB Red Poppy Canopy 77,500 - - 77,500
6EC Tree Mitigation 44,000 - - 44,000
6ED Grace Heritage Rehab 150,000 10,918 (10,000) 149,082
6EK Former PD Renovation - 3,010 - (3,010) [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 25,043 12,968 204,039
6ET ADA Parks 150,000 - - 150,000
6EV Shotgun House Rehab 18,000 18,000 - -
9AW CDBG-MLK/3rd St - - 10,534 (10,534) [a]
Parks CIP Bonds Subtotal 10,155,549 2,278,083 463,222 7,414,244
Parks CIP
6DB McMaster Park - - 17,868 (17,868) [a]
6DD New Village Parks - 912 (121) (791)
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 - - 70,000
6EU VFW Lighting - - 190,375 (190,375) [a]
Parks CIP Subtotal 157,000 61,656 171,828 (76,484)
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 161,290 13,411 6,530,299
6EM Downtown West - 352,277 (167,250) (185,026) [a]
6EO Downtown Festival Area 460,000 - - 460,000
Downtown & Community Service Subtotal 11,760,000 2,215,108 (163,898) 9,708,789
Total General Government CIP 25,732,549$ 4,910,971$ 1,105,204$ 19,716,374$
NOTES:
[a]Individual projects may go over budget as long as total expenditures
for all CIP projects are within the department's total budget.
40
Capital Improvement Projects
For the Quarter Ended
June 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$ 810,000$ (810,000)$ 623,000$
1BZ 971 @ Austin Ave.- 43,244 (43,244) -
1CA SW Bypass Leander to I35 - 57,606 (5,235) (52,371) [a]
1CC FM 1460 - 100,885 (47,668) (53,217) [a]
1CF Street Overlay/Microsurfacing 300,000 26,765 (26,765) 300,000
1CN Sealant 326,000 70,305 (54,606) 310,301
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 - 6,650 (6,650) -
1CU Cutler Process 1,000,000 27,323 (27,281) 999,958
1DE Williams Dr @ Jimm Hogg Rd - 39,967 178,798 (218,765) [a]
1DG Sheraton Parking Garage - 2,780 (2,780) -
1DI SW Bypass / WR Parkway 20,000,000 1,457,394 16,216,165 2,326,441
1DK Southeast Inner Loop - 1,221,668 (295) (1,221,373) [a]
1DL Austin Avenue Bridge 675,000 408,008 505,670 (238,679) [a]
1DM Street Maintenance 2016 1,500,000 125,540 61,190 1,313,270
1DO Austin Avenue at 5th St Light - - 40,768 (40,768)
1DR PH 1 Signal and Curb Ramps - 1,827 59,076 (60,903)
9AU University Sidewalks - 40 - (40)
Streets / Transportation Subtotal 24,660,000 4,416,509 16,025,116 4,218,374
Stormwater
1BU Streets Rehabilitation - 282,825 (282,825) -
5AM Curb & Sidewalks - 5,700 (5,700) -
5AO Stormwater Infrastructure 950,000 - - 950,000
5AT Smith Branch Buy-Outs - 1,110 - (1,110)
5AW Regional Flood Study - 184,698 500,302 (685,000) [a]
6DE SG Bank Stabilization - - 35,000 (35,000) [a]
Stormwater Subtotal 950,000 474,333 246,777 228,890
Airport
6VB Parallel Taxiway & Runway Lights 757,935 750,000 - 7,935
6VE Fuel Farm 100,000 87,705 - 12,295
Airport Subtotal 857,935 837,705 - 20,230
Total Transportation Services CIP 26,467,935$ 5,728,547$ 16,271,894$ 4,467,494$
NOTES:
[a]Individual projects may go over budget as long as total expenditures
for all CIP projects are within the department's total budget.
41
Capital Improvement Projects
For the Quarter Ended
June 30, 2016
2015/16 Year to Date Year to Date
Project Budget Expenditures Encumbrances Balance
Water Services CIP
Wastewater Line Upgrades:
3BZ Wastewater - Street Rehab 200,000$ -$ -$ 200,000$
3CJ Berry Creek Interceptor 8,333,900 242,730 (242,730) 8,333,900
5QZ Snead Drive 299,200 624,391 (624,366) 299,174
6CR Public Safety Facility 10,000 182,195 (166,528) (5,666) [a]
Wastewater Line Upgrades Subtotal 8,843,100 1,049,316 (1,033,624) 8,827,408
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 536,526 422,948 552,176
3CL EARZ 2015-2016 - 99,772 291,013 (390,785)
WW Edwards Aquifer Compliance Subtotal 3,023,300 796,323 569,816 1,657,161
WW Lift stations & Force Mains
3CC Lift Station Upgrades 419,100 - - 419,100
3CD Stonehedge LS & FM 27,600 - - 27,600
3CE W `3,298,900 13,974 (13,860) 3,298,786
3CI Austin Custom Molds LS Decommission 152,000 - - 152,000
WW Lift stations & Force Mains Subtotal 3,897,600 13,974 (13,860) 3,897,486
WW Treatment Plant
3CA Pecan Branch WWTP 1,957,000 120,755 (75,755) 1,912,000
WW Treatment Plant Subtotal 1,957,000 120,755 (75,755) 1,912,000
Water CIP
1BU Streets Rehab 143,700 363,328 (362,991) 143,363
1DE Williams Dr. @ Jim Hogg Rd - 505,476 - (505,476) [a]
2BR LWTP Expansion Ph. III - 1,655 - 1,655
2BW Westside Facility 505,500 2,965,336 (2,911,486) 451,649
2BZ West Loop (H-1B) Ph. 1 408,000 - - 408,000
2CE Rabbit Hill EST 1,825,800 735,327 1,406,720 (316,246)
2CG Asset Management
2CH Cedar Breaks EST 3,385,000 2,142 - 3,382,858
2CI Shell Road Water Line 6,292,500 229,229 (229,229) 6,292,500
2CJ Meter Issue - 358,198 - (358,198) [a]
2CK Daniels Mountain GST 2,200,000 1,663,559 309,122 227,319
2CL Park WTP Pump Station 335,000 24,450 8,150 302,400
2CM SW Bypass Waterline 1,106,000 - 2,004,820 (898,820)
Water CIP Subtotal 16,201,500 6,848,700 225,106 9,127,694
Rural Water CIP
2CN PRV Improv SH129 & CR245 1,764,666 45,226 4,747 1,714,693
2CO Majestic Oaks Water Lines 1,764,666 13,560 27,419 1,723,687
2JA Hwy 183 & 1869 Waterline 1,764,668 2,945 - 1,761,723
2JE CR 255 (WD 14-2)- 280,999 628,381 (909,380) [a]
2JF Domel Improvements 2,007,000 50,997 271,817 1,684,186
Rural Water CIP Subtotal 7,301,000 393,726 932,365 5,974,909
AMI/CIS-Water
2CG Asset Management 71,000 38,791 (26,493) 58,702
Water/AMI/CIS Subtotal 71,000 38,791 (26,493) 58,702
Total Water Services CIP 41,294,500$ 9,261,585$ 577,556$ 31,455,360$
NOTES:
[a]Individual projects may go over budget as long as total expenditures
for all CIP projects are within the department's total budget.
42
Capital Improvement Projects
For the Quarter Ended
June 30, 2016
2015/16 Year to Date Year to Date
Project Budget Expenditures Encumbrances Balance
Electric CIP
Electric Operations
5-0557-52-905 Developer Projects -$ 90,500$ -$ (90,500)$ [a]
Electric Operations Subtotal - 104,475 - (104,475)
Electric CIP
9-0580-90-129 Downtown URD Projects - 3,082 (3,795) 713
9-0580-90-300 Electrical System Improvements 4,375,000 3,496,624 875,948 2,428
9-0580-90-310 Power Quality Improvements 80,000 20,830 50,000 9,170
9-0580-90-320 Sectionalization Improvements 50,000 - 50,000 -
9-0580-90-330 Pole Improvements 50,000 49 50,000 (49) [a]
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 - 89,421 (52,433) (36,988) [a]
9-0580-90-410 New Development Projects 1,200,000 1,198,426 205,858 (204,285)
9-0580-90-420 Reimbursements New Developments (540,000) 29,946 - (569,946) [a]
9-0580-90-430 Street Lighting 88,000 15,129 47,342 25,529
9-0580-90-500 Consultant Engineering 150,000 122,107 27,893 (0)
9-0580-90-510 System Mapping Support 50,000 58,500 91,500 (100,000)
Electric CIP Subtotal 5,503,000 5,129,241 1,302,448 (928,689)
T&D
9-0585-90-003 Electric Substations 698,000 4,329 (4,329) 698,000
9-0585-90-021 Communication Equipment 507,000 221,830 (91,357) 376,527
T&D Subtotal 1,205,000 226,159 (95,686) 1,074,527
CIS
9-0580-91-105 CIS System 4,350,000 152,612 (14,940) 4,212,328
CIS Subtotal 4,350,000 152,612 (14,940) 4,212,328
Total Electric CIP 11,058,000$ 5,612,488$ 1,191,821$ 4,253,691$
43
Capital Improvement Projects
For the Quarter Ended
June 30, 2016
2015/16 Year to Date Year to Date
Project Budget Expenditures Encumbrances Balance
GTEC CIP
51A Economic Development Projects 1,345,312$ -$ -$ 1,345,312$
5QC Southwest Bypass 1,332,579 1,027,074 (3,163) 308,668
5QG SE1: Inner LP / SH130 - 1,918 118 (2,036) [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 76,920 (76,920) 91,590
5QZ Snead Drive 20,000 981,192 (981,146) 19,954
5RB ROW - FM 1460 500,000 363,165 (2,035) 138,870
5RC Williams Dr. Gateway 794,000 - - 794,000
5RF Rivery Road (Convention Center Prj..)721,000 - - 721,000
5RI Mays Street (S. Georgetown TIRZ)10,150,000 300,716 (297,933) 10,147,217
5RJ IH 35 / Hwy 29 Intersection Improvements 650,000 - - 650,000
5RM Rivery Ext (Williams Dr. - Nwest Blvd.)1,500,000 1,815,844 (224,664) (91,180)
5RN Pecan Center Dr. / Airport Rd.6,364,000 53,171 (53,171) 6,364,000
5RO Southwest Bypass - Laubach 1,121,000 17,359 261 1,103,380
5RP Rivery TIA Improvements 1,400,000 - - 1,400,000
1CC FM 1460 Roadway Improvement 61,000 5,913 (5,910) 60,997
Total GTEC CIP 26,333,831$ 4,648,637$ (1,649,928)$ 23,335,121$
Notes:
[a]Individual projects may go over budget as long as total expenditures
for all CIP projects are within the department's total budget.
44