CAFR FY 1986-87
I
I ..
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
.
Comprehensive
Annual Financial Report
For The Fiscal Year Ended
September 30, 1987
Schertz, Texas
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
COMPREHENSIVE ANNUAL FINANCIAL REPORT
FISCAL YEAR ENDED SEPTEMBER 30, 1987
Prepared by the
Finance Department
D. Williams
Finance Director
i
MAYOR
Earl W. Sawyer
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
COMPREHENSIVE ANNUAL FINANCIAL REPORT
FISCAL YEAR ENDED SEPTEMBER 30, 1987
CITY OFFICIALS
CITY COUNCIL
Raymond Stanhope, Mayor Pro-Tem
Adolph Aguilar
Harold D. Baldwin
Kenneth Greenwald
Charles B. Sharpe
CITY MANAGER
Jimmy Gilmore
AUDITORS
Melick, Thorpe & Armstrong, P.C.
OFFICIAL ISSUING REPORT
Jimmy Gilmore
City Manager
11
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
COMPREHENSIVE ANNUAL FINANCIAL REPORT
FOR THE YEAR ENDED SEPTEMBER 30, 1987
TABLE OF CONTENTS
PAGE
TITLE PAGE i
CITY OFFICIALS ii
TABLE OF CONTENTS iii-vi
INTRODUCTORY SECTION
LETTER OF TRANSMITTAL vii-xii
ORGANIZATION CHART xiii
FINANCIAL SECTION
BASIC STATEMENTS
REPORT OF CERTIFIED PUBLIC ACCOUNTANTS 1
COMBINED STATEMENTS - OVERVIEW 2
GENERAL PURPOSE FINANCIAL STATEMENTS
Combined Balance Sheet - All Fund Types and Account Groups 3
Combined Statement of Revenues, Expenditures and Changes in
Fund Balances - All Governmental Fund Types and
Expendable Trust Funds 7
Combined Statement of Revenues, Expenditures and Changes
in Fund Balances - Budget and Actual - General and
Special Revenue Fund Types 9
Combined Statement of Revenues, Expenses, and Changes in
Retained Earnings - All Proprietary Fund Types 11
Combined Statement of Changes in Financial Position -
All Proprietary Fund Types 13
Notes to Financial Statements 15
Hi
CITY OF SCHERTZ, TEXAS
COMPREHENSIVE ANNUAL FINANCIAL REPORT
FOR THE YEAR ENDED SEPTEMBER 30, 1987
TABLE OF CONTENTS
(CONTINUED)
FINANCIAL SECTION
(CONTINUED)
COMBINING AND INDIVIDUAL FUND STATEMENTS AND ACCOUNT GROUPS
GOVERNMENTAL FUND TYPES
General Fund
Comparative Balance Sheet
Statement of Revenues - Budget and Actual
Statement of Expenditures - Budget and Actual
Special Revenue Fund
Comparative Balance Sheet
Statement of Revenues and Uses - Budget and Actual
Debt Service Fund
Comparative Balance Sheet
Comparative Statement of Revenues, Expenditures, and Changes
in Fund Balance
PROPRIETARY FUND TYPES
Enterprise Funds
Combining Balance Sheet
Combining Statement of Revenues, Expenses, and Changes
in Retained Earnings
Combining Statement of Changes in Financial Position
FIDUCIARY FUND TYPES
Trust and Agency Funds
Combining Balance Sheet
Expendable Trust Funds - Combining Statement of Revenues,
and Changes in Fund Balances
Combining Statement of Changes in Assets and Liabilities _
All Agency Funds
iv
I
I
PAGE
I
I
I
I
30
SUPPLEMENTAL T"
STATEMENTS/SCHEDU~
32
33
34
I
I
I
I
I
I
I
I
I
I
I
I
36
37
39
40
42
44
46
49
50
51
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
COMPREHENSIVE ANNUAL FINANCIAL REPORT
FOR THE YEAR ENDED SEPTEMBER 30, 1987
TABLE OF CONTENTS
(CONTINUED)
FINANCIAL SECTION
(CONTINUED)
ACCOUNT GROUPS
General Fixed Assets
Comparative Schedule of General Fixed Assets
Schedule of General Fixed Assets Changes -
by Function and Activity
STATISTICAL SECTION
General Government Expenditures by Function - Last Ten
Fiscal Years
General Revenues by Source - Last Ten Fiscal Years
Property Tax Levies and Collections - Last Ten Fiscal Years
I
I
Assessed and Estimated Actual Value of Taxable Property -
Last Ten Fiscal Years
Property Tax Rates - All Overlapping Governments - Last Ten
Fiscal Years
I
I
I
I
I
Ratio of Net General Bonded Debt to Assessed Value and Net
General Bonded Debt Per Capita - Last Ten Fiscal Years
Overlapping Debt
Legal Debt Margin
General Bonded Debt Summary of Debt Service Requirements
- Fiscal Years 1987-2002
Utility System Junior Lien Revenue Certificates of Obligation
Debt Service Requirements - Fiscal Years 1987-2001
Utility System Revenue Bonds Summary of Debt Service
Requirements - Fiscal Years 1987-2007
Public Facility Loan H.U.D. Summary of Debt Service
Requirements Fiscal Years 1987-2010
I
I
I
v
TABLE P~E
54
55
1 57
2 58
3 59
4 60
5 61
6 62
7 63
8 64
8-1 65
8-2 66
8-3 67
8-4 68
CITY OF SCHERTZ. TEXAS
I
I
COMPREHENSIVE ANNUAL FINANCIAL REPORT
TABLE PAGE
I
I
I
I
I
FOR THE YEAR ENDED SEPTEMBER 30, 1987
TABLE OF CONTENTS
(CONTINUED)
STATISTICAL SECTION
( CONTINUED)
Ratio of Annual Debt Service Expenditures for General
Bonded Debt to Total General Expenditures - Last Ten Fiscal Years 9 69
Revenue Bond Coverage
Water and Sewer Fund Schedule of Total Operating
Expenses Before Depreciation and Debt Service
Requirements - Last Ten Fiscal Years 10-1 70
Waterworks and Sewer System Fund Revenue Bond
Requirements and Restricted Funds 10-2 72
I
I
I
I
I
I
I
I
I
I
Insurance and Bond Coverage 11 74
Demographic Statistics - Last Ten Fiscal Years 12 75
Property Value, Construction, and Bank Deposits -
Last Ten Fiscal Years 13 76
Principal Taxpayers 14 78
Miscellaneous Statistics 15 79
vi
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
INTRODUCTORY SECTION
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
~ fI JJi' iJ.!:lJJ.EJJJ1
~ 1400 LIVE OAK ROAD
P.O. DRAWER I
SCHERTZ, TEXAS 78154
AC (512) 658.7477
.
011 tile G.o-
JIMMY G. GILMORE
CITY MANAGER
February 29, 1988
Honorable Mayor and City Council Members
City of Schertz
Texas
The comprehensive annual financial report of the City of Schertz, Texas, as of
September 3D, 1987, and for the fiscal year then ended is submitted herewith.
Responsibility for both the accuracy of the presented data and the
completeness and fairness of the presentation including all disclosures rests
with the City. The data, as presented, is accurate in all material aspects.
It is presented in a manner designed to set forth the financial position and
results of operations of the City as measured by the financial activity of its
various funds. All disclosures necessary to enable the reader to gain the
maximum understanding of the City's financial activity have been included.
The accompanying report consists of three major sections:
Introduction: Includes this letter of transmittal and reproduction of the
Government Finance Officers Association of the United States and Canada (GFOA)
Certificate of Conformance in Financial Reporting received for the fiscal year
ended September 30, 1987.
Financial: Begins with the independent auditor's opinion and contains combined
financial statements that present an overview of all financial operations of
the City, along with notes to the financial statements and more detailed
combining statements.
Statistical: Consists of unaudited tables that reflect both
non-financial data for the purpose of presenting social
information, financial trends and fiscal capacity of the City.
financial and
and economic
AccountinE Svstem and BudEetarv Control
..
The City's accounting records for general governmental operations are
maintained on a modified accrual basis, with revenues being recognized when
they become both measurable and available, and expenditures being recognized
when the services or goods are received and the liabilities are incurred.
Accounting records for the City's utilities and other enterprises are
maintained on the accrual basis.
vii
I
Page 2 - 1tr to Mayor and City Council, dated December 31, 1987
I
In developing and altering the City's accounting system, consideration has
been given to the adequacy of internal accounting controls. Internal
accounting controls have been designed to provide reasonable assurance
regarding:
I
The safeguarding of assets against
disposition and
loss from unauthorized use or
I
The reliability of financial records for preparing financial statements
and maintaining accountability for assets.
I
I
The concept of reasonable assurance recognizes that:
and
The cost of a control should not exceed the benefits likely to be derived,
I
The evaluation of costs and benefits requires estimates and judgments by
management.
All internal control
internal accounting
reasonable assurance
evaluations occur within the above framework. The City's
controls adequately safeguard assets and provide
of proper recording of financial transactions.
I
I
Budgetary control is maintained by the use of
require encumbrance of the estimated purchase
purchase orders to vendors. Open encumbrances
fund balance at September 30, 1987.
purchase order procedures that
amounts prior to the release of
are reported as reservations of
I
The Reporting Entitv and Its Services
I
The City has reviewed its reporting entity definition in light of NCGA
Statement 3, DefininE the Governmental ReportinE Entity. The entities
included in the City's report are all those which are controlled by or
dependent on the City. Control by or dependence on the City was determined on
the basis of budget adoption, taxing authority, outstanding debt secured by
revenues or general obligations of the City, obligation of the City to finance
any deficits that may occur, or receipt of significant subsidies from the
City. The City provides the full range of municipal services contemplated by
statute or charter. This included police and fire, health, public
improvements, water and sewer utility, planning and zoning and general
administrative services.
I
I
I
General Governmental Functions
I
Revenues:
Revenues which include General. Special Revenue, and Debt Service for general
governmental functions totaled $1,647,375 in 1987. an increase of 5% from
1986. Taxes produced 69.9% of general revenues compared to 67.8% last year.
This eligible increase in tax revenues more than offset the loss of revenue
sharing funds. The amount of revenues from various sources and the
increase/decrease from last year are shown in the following tabulation:
viii
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Page 3 - ltr to Mayor and City Council, dated December 31, 1987
Amount
Percent
Of
Total
Increase
(Decrease)
From 1987
Taxes (Property, Sales,
etc. )
Licenses and Permits
Intergovernmental
Revenues
Charges for Services
Fines and Forfeits
Other Revenues
$ 1,l52,l08
76,82l
69.9%
4.7%
$
83,803
(40,864)
(30,l8l)
l,742
38,229
19, l21
6,601
32,459
l59,283
220,103
.4%
2.0%
9.6%
13.4%
$ 1,647,375
100.0%
$
71,850
Expenditures:
Expenditures for general governmental purposes totaled $1,766,347, an
increase of 37% from 1986. This large increase is due mainly to
increased expenditures in general government and streets and parks
operations. Increases in levels of expenditures for major functions of
the City over the preceding year are shown in the following
tabulation:
Function
Percent Increase
Of (Decrease)
Amount Total From 1987
$ 715,242 40.5% $ 148,752
488,536 27.7% 135,513
318,719 18.0% 145,468
55,657 3.2% 10,581
73,587 4.2% 19,968
26,546 1.5% (19,605)
76,644 4.3% 27,766
11,4l6 .6% 11,4l6
----------- ----------- ------------
$ 1,766,347 100.0% $ 479,859
Debt Administration
General Government
Public Safety
Streets and Parks
Health Services
Recreation
Capital Outlay
Debt Service
Bond Expenses
The ratio of net bonded debt to assessed valuation and the amount of bonded
debt per capita are useful indicators of the City's debt position to municipal
management, citizens, and investors. These data for the City of Schertz at
the end of 1987 fiscal year were as follows:
ix
Page 4, Itr to Mayor and City Council, dated December 31, 1987
I
I
Amount
Ratio of Debt
To Assessed
Value (100%)
Of Present
Market
I
General Obligation bonds
Revenue bonds
Baa
Baa-l
I
I
I
I
I
Debt Per
Capita
Net Bonded Debt
$
757,798
.52%
$ 30.27
The City's bond rating are as shown:
Moody's
Investors
Service
Property Taxes
Current tax collections are 97.0% of the tax levy. This is the thirteenth
consecutive year in which current property tax collections have exceeded 96%.
The ratio of total collections (current and delinquent) to the current tax
levy was 100.3%. Allocations of property tax levy by purpose for 1987 and the
preceding two fiscal years are as follows (amounts per $100 assessed value):
I
Purpose
1987
1986
1985
I
I
General Fund
General Obligation Debt
.338
.075
.355
.08l
.350
.090
I
I
I
.413 .436 .440
Cash ManaEement
Cash temporarily idle during the year was invested in 3D-day time deposits.
The interest earned on such deposits during the year was $164,314, an increase
of $5,905 over interest earned on temporary investments during 1986. The
increase is attributable to the availability of more funds for temporary
investments.
I
I
x
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Page 5, ltr to Mayor and City Council, dated December 31, 1987
General Fixed Assets
The general fixed assets of the City are those fixed assets used in the
performance of general governmental functions and exclude the fixed assets of
Enterprise Funds. As of September 30, 1987, the general fixed assets of the
City amounted to $4,619,181. This amount represents the original cost, or an
estimate of the original cost of the assets. Depreciation of general fixed
assets is not recognized in the City's accounting system. Refer to note A(4)
to the financial statements.
Water and Sewer System
During the fiscal year ended September 30, 1987, net revenues in the water
sewer system increased. The coverage ratio of 2.08 still meets the revenue
bond debenture agreement requirement that net revenues be at least 1.5 times
the average annual debt requirement. Net revenues, as used here, is an amount
derived in accordance with the bond indenture agreement. Comparative data for
the past two fiscal years is presented below:
Total operating revenue
Operating income (gross revenues
less operating expenses)
Net revenues (operating income plus
depreciation less solid waste revenues)
Average annual debt requirements
Coverage ratio
1987 1986
$ 1,339,06l $ 1,309,269
155,6l6 197,075
408,9l6 459,592
196,269 101,832
2.08 4.51
During the year, $45,000 of regularly maturing revenue bonds and $40,000 in
certificates of obligation were retired in the Water and Sewer Fund.
Schertz Area Facilitv for Emergency Services (SAFES)
During the fiscal year ended September 30, 1987, SAFES increased its revenue
6% and increased operating expenses by 13%. SAFES is fully dependent on
income fees generated f~om services rendered and the cities' support to cover
all operations costs. In this fourth year of self-supporting operation, SAFES
had an operating income of $19,697. County contingency funding and other
miscellaneous revenue offset depreciation expense resulting in a net income of
$3,l99.
Trust and AEencv Funds
Trust and Agency Funds are established to account for assets held by the
governmental unit in a trustee capacity or as an agent for individuals,
private organizations, and other governmental units, and/or other funds. The
City has two trust funds, Self Insurance and Equipment Replacement, with total
assets of $116,582. The City has three agency funds which are Payroll,
Library and State Fines. These funds have assets of $36,979 and serve various
purposes in the best interest of the City.
xi
I
Page 6, Itr to Mayor and City Council, dated December 31, 1987
I
I
Independent Audit
The City Charter requires an annual audit of the books of account, financial
records and transactions of all administrative departments of the City by
independent certified public accountants selected by the City Council. This
requirement has been complied with and the auditor's report has been included
in this report.
I
During the coming year, the City will continue its progressive
seeking industrial and commercial development. This plan
extension of the City's utility systems through acquisition
systems and installation of new ones.
attitude in
includes the
of existing
I
I
Future Prospects
I
Acknowled~ements
I
I extend my
interest and
the City in a
thanks to the Mayor and members of the City Council for their
support in planning and conducting the financial operations of
responsible and progressive manner.
I
Respectfully Submitted,
/~~
I
I
I
I
I
I
I
I
xii
I
I
HO'f!J.?~~7S~:I~
. . .~.. 0"' ...
".-:" -"
llOSI^H3dns
r
tiOSIM:I:ldns
T
~"'1d
~301:1:JO
'1f~
~.11
~
.~ ,I.::lN3Dy;JW3
V:l31.H..~.3HI:I
.- -
, .
~".
1::13DVNVW AJ.I::l .und3a
"~_ A~)J'
... ,
~Q
I
1 l::l NnOO
I
OO1.'tllJ.SINIWOY
vgr
:I:lVI~::l- :I::ll~?"
pr'.
li. -.
....
....
....
)(
-------------------
This page intentionally left blank.
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FINANCIAL SECTION
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
MELICK, THORPE & ARMSTRONG, P.C.
CERTIFIED PUBLIC ACCOUNTANTS
433 KlllY HAWK, SUITE 113
UNIVERSAL CITY, TEXAS 78148
TELEPHONE (512) 658-€229
REPORT OF CERTIFIED PUBLIC ACCOUNTANTS
The Honorable Mayor and
City Council
City of Schertz, Texas
We have examined the combined financial statements as listed in the contents
herein, of the City of Schertz, Texas, at September 30, 1987 and for the year
then ended. Our examination was made in accordance with generally accepted
auditing standards and, accordingly, included such tests of the accounting
records and such other auditing procedures as we considered necessary in the
circumstances.
In our opinion, the combined statements referred to above present fairly the
financial position of the City of Schertz, Texas, as of September 3D, 1987,
and the results of operations of such funds and the changes in financial
position of the Proprietary Fund Types for the year then ended, in conformity
with generally accepted accounting principles applied on a basis consistent
with that of the preceding year.
Our examination has been made primarily for the purpose of expressing an
opinion on the combined financial statements as a whole. The additional
.combining and individual fund and account group statements as listed in the
contents herein, are presented for analysis purposes and are not a required
part of the combined financial statements of the City of Schertz. The
additional information has been subjected to auditing procedures applied in
the examination of the combined financial statements and, in our opinion, is
fairly stated in all respects material in relation to the financial statements
each taken as a whole. The statistical data listed in the contents herein,
was not audited by us and, accordingly, we do not express an opinion
thereon.
In connection with our examination, we also (1) performed tests of compliance
with the Revenue Sharing and Antirecession Acts and Regulations as required by
Sections II.C.3., and III.C.3. of the Audit Guide and Standards for Revenue
Sharing and Antirecession Fiscal Assistance Fund Recipients (guide) issued by
the Office of Revenue Sharing, U.S. Department of the Treasury, and (2)
compared the data on Bureau of Census Form RS-9 with the audited records of
the City of Schertz, Texas, as required by Section II.C.4. of the RGuideR.
Based on these procedures, we noted no instance of noncompliance
regulations and no differences between the data on Bureau of Census
and the records of the City of Schertz, Texas, for the year ended
30, 1987.
?/tLI~+~)!(.
December 31, 1987
wi th the
Form RS-9
September
1
This page intentionally left blank.
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
COMPREHENSIVE ANNUAL FINANCIAL REPORT
YEAR ENDED SEPTEMBER 30, 1987
COMBINED STATEMENTS - OVERVIEW
GENERAL PURPOSE FINANCIAL STATEMENTS
2
CITY OF SCHERTZ, TEXAS
COMBINED BALANCE SHEET - ALL FUND TYPES AND ACCOUNT GROUPS
SEPTEMBER 30, 1987
ASSETS
Governmental Fund
Special
Revenue
(Revenue
General Sharing)
Cash
Certificates of Deposit
Receivables (Net Of
Allowances) :
Taxes
Accounts
Due From Other Funds
Inventory of Supplies, at Cost
Prepaid Expenses
Restricted Assets:
Cash
Investments, at Cost
Fixed Assets
Accumulated Depreciation
Organization Costs
Accumulated Amortization
Amount Available in Debt
Service Funds
Amount to be Provided For
Retirement of General Long
Term Debt
Amount to be Provided For
Employee Long Term
Compensated Absences
$
2,443
458,345
$
33,686
29,594
l,021
6,8l5
Total Assets
$
498,218
$
33,686
The accompanying notes are an integral part of these statements.
3
I
I
Tvpes
I
I
I
I
I
I
I
I
I
Debt
Service
$ 551
l29,65l
5,695
$ 135,897
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Proprietary
Fund Types
Enterprise
$ 25,239
130,939
Fiduciary
Fund TyPe s
Trust
and
AQ:encv
$ 5,100
148,46l
Account Groups
General General
Fixed Long-Term
Assets Debt
Totals
(Memorandum Only)
September September
30, 30,
1987 1986
$
$
89,997
595,759
33,333 $
90l,082
$
35,289 23,507
196,374 196,374 145,513
45,000 46,021 9,Ol5
48,154 54,969 60,659
8,235 8,235 6,309
2,345,728 2,345,728 l,282,550
6, 771 , 112 4,6l9,l81 11,390,293 11,096,663
(2,l28,845) (2,128,845) . (1,859,984)
l,900 l,900 1,900
(80l) (801) (753)
130,202 130,202 l25,649
757,798 757,798 324,351
7,443,035
$ 153,561
46,292
46,292 42,066
$ 4,6l9,181 $
934,292
$ l3,817,870 $ ll,943,201
4
CITY OF SCHERTZ, TEXAS
COMBINED BALANCE SHEET - ALL FUND TYPES AND ACCOUNT GROUPS
SEPTEMBER 30, 1987
LIABILITIES
Governmental Fund Tvpes
Special
Revenue
(Revenue
General Sharing)
Vouchers Payable
Payable from Restricted Assets:
Deposits
Revenue Bonds
Certificates of Obligation
Due to Other Funds
Accrued Vacation and Sick Leave
Deferred Revenue
General Obligation Bonds Payable
Revenue Bonds Payable
Certificates of Obligation Payable
Public Facility BUD Loan
Long Term Liability for Employee
Compensated Advances
$
26,364
$
45,000
921
29,594
Total Liabilities
100,958
921
FUND EQUITY
Contributed Capital
Investment in General Fixed Assets
Retained Earnings:
Reserved for Revenue Bond Retirement
Reserved for Equipment Replacement
Unreserved
Fund Balances:
Reserved for Prepaid Expenses
Reserved for Inventory of Supplies 6,815
Reserved for Debt Service
Reserved for STEP Expenditures lO,359
Unreserved:
Designated for Equipment Replacement
Designated for Self Insurance
Undesignated 380,086
Total Retained Earnings/Fund ----________
Balances 397,260
32,765
32,765
Total Fund Equity 397,260
32,765
Total Liabilities and
Fund Equity
$
498,2l8
$
33,686
The accompanying notes are an integral part of these statements.
5
I
I
I
I
Debt
Service
I
I
I
$
5,695
I
5,695
I
I
I
130,202
I
I
I
I
I
130,202
130,202
$
I
I
135,897
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Proprietary Fiduciary Totals
Fund Types Fund Types Account Groups (Memorandum Only)
Trust General General September September
and Fixed Long-Term 30, 30,
Enterprise AEency Assets Debt 1987 1986
220,003 $ 28,545 $ $ $ 274,9l2 $ l66,911
l02,055 l02,055 92,025
65,000 65,000 45,000
40,000 40,000 40,000
lOO 36,979 83,000 9,Ol5
13,513 13,513 l2,088
35,289 23,507
888,000 888,000 450,000
2,045,000 2,045,000 l,090,000
l,220,000 l,220,000 l,260,000
11l,OOO 111,000 114,000
46,292 46,292 42,066
---------- ----------- ----------- ------------ ------------ ------------
3,8l6,671 65,524 934,292 4,924,06l 3,344,612
---------- ----------- ----------- ------------ ------------ ------------
2,665,l83 2,665,183 2,661,2l6
4,6l9,l8l 4,619,18l 4,40l,655
204,346 204,346 l74,826
335,428 335,428 328,765
42l,407 421,407 518,392
6,8l5 9,l40
130,202 l25,649
lO,359 4,339
60,005 60,005 226,873
28,032 28,032 24,305
412,85l l23,429
---------- ----------- ----------- ------------ ------------ ------------
961,l8l 88,037 0 0 l,609,445 1,535,718
---------- ----------- ----------- ------------ ------------ ------------
961,l8l 88,037 0 0 8,893,809 8,598,589
---------- ----------- ----------- ------------ ------------ ------------
4,777,852 $ 153,56l $ 0 $ 934,292 $ 13,817,870 $ 11,943,201
6
CITY OF SCHERTZ, TEXAS
I
I
COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES
ALL GOVERNMENTAL FUND TYPES AND EXPENDABLE TRUST FUNDS
FOR THE YEAR ENDED SEPTEMBER 3D, 1987
6,601
I
I
I
I
I
Governmental Fund
Tvoes
Revenues:
Special
Revenue
(Revenue
Sharing)
General
Taxes
Licenses and Permits
Intergovernmental Revenues
Charges for Services
Fines and Forfeits
Other Sources
$ l,152,108
76,821
$
32,459
159,283
203,837
2,946
Total Revenues
1,624,508
9,547
I
Current:
General Government
Public Safety
Streets and Parks
Health
Recreation
Capital Outlay
Bond Expenses
Debt Service:
Principal Retirement
Interest and Fiscal Charges
EX1?enditures:
715,242
488,536
318,719
55,657
73,587
26,546'="
11,416
I
I
I
Total Expenditures
1,689,703
I
I
Excess of Revenues Over (Under)
Expenditures
(65,l95) 9,547
Other Financial Sources (Uses);
Operating Transfers In
Operating Transfers (Out)
Bond Proceeds
37,617
(llO,314) (37,617)
460,000
I
I
Total Other Financial Sources (Uses)
387,303
(37,617)
Excess of Revenues and Other Sources
322,108
(28,070)
I
Fund Balances - October 1
75,l52
6l,756
I
Fund Balances - September 30
$ 397,260
$ 33,686
The accompanying notes are an integral part of these statements.
I
7
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Fiduciary
Fund TyPe
Debt Expendable
Service Trust
Totals
(Memorandum Only)
1987 1986
$ $
$ 1,152,108
76,821
6,601
32,459
159,283
240,482
$ l,068,305
117,685
36,782
30,717
l21,054
223,643
l3,320 20,379
l3,320 20,379
l,667,754
l,598,l86
715,242 620,680
488,536 4l6,578
318,719 202,929
55,657 43,929
73,587 62,362
185,956 212,502 134,046
11,416
22,000 22,000 21,000
54,644 54,644 63,938
---------- ----------- ----------- ------------
76,644 l85,956 1,952,303 l,565,462
---------- ----------- ----------- ------------
(63,324) . (l65,577) (284,549) 32,724
---------- ..---------- ----------- ------------
l07,878 2,436 l47,93l 2l5,586
(40,000) (187,93l) (233,689)
460,000
---------- ----------- ----------- ---....-------
67,878 2,436 420,000 (18,103)
---------- ----------- ----------- ----.....--.....--
4,554 (l63,14l) 135,451 14,62l
125,648 25l,l78 513,734 499,113
---------- --...-------- ----------- ------------
130,202 $ 88,037 $ 649,185 $ 513,734
8
General Fund
Variance
Favorable
Budget Actual (Unfavorable)
$ 1,141,500 $ 1,152,108 $ 10,608
77,878 76,821 (1,057)
37,350 32,459 (4,891)
145,200 l59,283 14,083
206,248 203,837 (2,411)
------------ ------------ ---------........
1,608,176 l,624,508 16,332
------------ ------------ ------------
706,654 717,678 (11,024)
517,413 488,536 28,877
321,111 318,719 2,392
55,407 55,657 (250)
71,937 73,587 (1,650)
27,215 26,546 669
11,416 (11,416)
------------ ------------ ---------........
1,699,737 l,692,139 7,598
------------ ------------ ------------
(9l,561) (67,63l) 23,930
--..--------- ------------ ------------
44,000 37,617 (6,383)
(108,455) (l07,878) 577
460,000 460,000
------------ ------------ ------------
(64,455) 389,739 454,l94
------------ ------------ ------------
(156,016) 322,108 478,124
75,152 75,152
------...._--- ------------ ------------
$ (80,864) $ 397,260 $ 478,124
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND
BALANCES - BUDGET AND ACTUAL GENERAL AND SPECIAL REVENUE FUND TYPES
FOR THE YEAR ENDED SEPTEMBER 30, 1987
Revenues:
Taxes
Licenses and Permits
Inter-Governmental Revenue
Charges for Services
Fines and Forfeits
Other Sources
Total Revenues
Expenditures:
Current:
General Government
Public Safety
Streets and Parks
Health
Recreation
Capital Outlay
Bond Expenses
Total Expenditures
Excess of Revenues Over
(Under) Expenditure
Other FinancinE Sources (Uses):
Operating Transfers In
Operating Transfers (Out)
Bond Proceeds
Total Other Financial
Sources (Uses)
Excess of Revenues Over (Under)
Expenditures and Other Uses
Fund Balances - October 1, 1986
Fund Balances - September 30, 1987
The accompanying notes are an integral part of these statements.
9
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Special Revenue Fund
(Revenue Sharin~ Fund)
Variance
Favorable
Bud~et Actual (Unfavorable) Budget
Totals
(Memorandum Onlv)
Variance
Favorable
Actual (Unfavorable)
$ $ $
$ 1,14l,500 $ l,l52,108 $ lO,608
77,878 76,821 (l,057)
6,601 6,60l
37,350 32,459 (4,891)
145,200 l59,283 14,083
206,248 206,783 535
------------ ------------ ------------
l,608,176 l,634,055 25,879
------------ ------------ ------------
6,601 6,60l
2,946 2,946
9,547 9,547
706,654 717,678 (11,024)
5l7,413 .488,536 28,877
32l,11l 318,7l9 2,392
55,407 55,657 (250)
71,937 73,587 (1,650)
27,215 26,546 669
11 ,416 (11,416)
...--------- ----------- ----------- ------------ ------------ ------------
1,699,737 1,692,139 7,598
---------- ----------- ----------- ---------...-... ------------ ------------
9,547 9,547 (91,561) (58,084) 33,477
---------- ----------- ----------- ------------ ------------ ------------
(44,000) (37,617) 6,383 44,000 37,617 (6,383)
(152,455) (145,495) 6,960
460,000 460,000
---------- ----------- ----------- ------------ ------------ ------------
(44,000) (37,617) 6,383 (108,455) 352,122 460,577
---------- ----------- ----------- -----------.. ------------ ------------
(44,000) (28,070) 15,930 (200,Ol6) 294,038 494,054
61,756 6l,756 136,908 136,908
---------- --------...-- ----------- -..._--------- ----..------- -..-.._-------
$ l7,756 $ 33,686 $ 15,930 $ (63,108) $ 430,946 $ 494,054
10
CITY OF SCHERTZ, TEXAS
COMBINED STATEMENT OF REVENUES, EXPENSES, AND CHANGES
IN RETAINED EARNINGS - ALL PROPRIETARY FUND TYPES
FOR THE YEARS ENDED SEPTEMBER 30, 1987 AND 1986
Totals
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
1987
Operating Revenue:
Fees Charged to Users
$ 1,529,211
Total Operating
Revenue
l,529,211
Operating Expenses Before Depreciation:
Personal Services
Sewage Treatment
Reimbursement of General and Administrative
Expenses
Contractual Services
Supplies
Bad Debts
253,485
327,752
l57,944
219,835
81,317
19,036
Total Operating Expenses Before
Depreciation
1,059,369
Operating Income Before Depreciation
469,842
Depreciation
(335,164)
Operating Income
134,678
The accompanying notes are an integral part of these statements.
11
1986
$ 1,525,190
1,525,190
213,827
357,772
l04,800
86,943
221,641
15,919
1,000,902
524,288
(338,106)
186,182
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
COMBINED STATEMENT OF REVENUES, EXPENSES, AND CHANGES
IN RETAINED EARNINGS - ALL PROPRIETARY FUND TYPES (CONTINUED)
FOR THE YEARS ENDED SEPTEMBER 30, 1987 AND 1986
Totals
Other Income (Expense):
Interest Income
Interest Expense
Amortization
Bond Expenses
County Contingency Funding
Loss on Trade or Sale of Assets
Lawsuit Legal Fees
1987 1986
$ 120,868 $ 92,3l4
(l78,248) (l8l,l40)
(48) (48)
(59,910)
22,667 8,875
(2,335) (13,002)
(138,474) (85,849)
------------ --------....--
(235,480) (178,850)
------------ ------------
(100,802) 7,332
40,000 18,103
------------ ------------
(60,802) 25,435
l,021,983 996,548
------------ -----..------
$ 961,181 $ 1,02l,983
Total Other Income (Expenses)
Net Income Before Operating Interfund
Transfers
Operating Transfers In
Net Income/(Loss)
Retained Earnings - October 1
Retained Earnings - September 30
12
Operations:
Net Income (Loss)
Items Not Requiring Working Capital:
Depreciation
Amortization
(Gain) Loss on Disposal of Assets
$
(60,802) $
25,435
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
COMBINED STATEMENT OF CHANGES IN FINANCIAL POSITION -
ALL PROPRIETARY FUND TYPES
FOR THE YEARS ENDED SEPTEMBER 30, 1987 AND 1986
Totals
1987
1986
Sources of Working
Capital:
Total Sources of Working Capital
335,l64 338,l06
48 48
2,335 13,002
------------ ------------
276,745 376,591
1,020,000
13,138
12,724
10,030 17,370
3,967 428
------------ ------------
1,323,466 407,527
Sale of Revenue Bonds
Reduction in Notes Receivable
Reduction in Restricted Assets
Increase in Customer Deposits
Contributions Received
The accompanying notes are an integral part of these statements.
13
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
COMBINED STATEMENT OF CHANGES IN FINANCIAL POSITION _
ALL PROPRIETARY FUND TYPES (CONTINUED)
FOR THE YEARS ENDED SEPTEMBER 30, 1987 AND 1986
Totals
Uses of WorkinE
Capital:
1987
Acquisition of Property, Plant and Equipment
Reduction in Long-Term Debt
Increase in Restricted Assets
$ l44,743
88,000
1,077 ,828
Total Uses of Working Capital
l,310,571
Net Increase in Working
Capital
$
l2,895
Elements of Net Increase (Decrease)
in Workin~ Capital:
Cash
Investments At Cost
Accounts Receivable
Due from Other Funds
Inventories
Vouchers Payable
Due to Other Funds
Accrued Vacation and Sick Leave
$
(15,540) $
66,487
43,678
45,000
(3,365)
(122,244)
304
(1,425)
Net Increase in Working
Capital
$
12,895
14
1986
$
118,l53
83,000
183,l77
384,330
$
23,l97
13,377
lO,824
5,696
(l,564)
(l,650)
643
(4,129)
$
23,197
~.~.
This page intentionally left blank.
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
NOTES TO FINANCIAL STATEMENTS
I
I
The notes to the financial statements contain
accounting policies and other notes considered
understanding of the financial statements.
I
I
I
I
I
I
I
I
I
I
15
I
a summary
necessary
of significant
for a clear
CITY OF SCHERTZ. TEXAS
NOTES TO FINANCIAL STATEMENTS
SEPTEMBER 30, 1987
Note A: Summarv of SiEnificant AccountinE Policies
I
I
I
A summary of the City's significant accounting policies applied in the preparation I
of the accompanying financial statements follows:
l. Descriotion of Funds
The City operates under a Council-Manager form of government and has
established a number of funds, in conformity with generally accepted
accounting principles and with the recommendations of the National Council
on Governmental Accounting, for the purpose of accounting for transactions
in compliance with legal requirements.
The following types of funds and groups of accounts are used by the City in
accounting for its financial activities:
Governmental Funds
General Fund - to account for all financial resources except those required
to be accounted for in another fund or account group.
Special Revenue Fund - to account for the proceeds of a specific revenue
source that is legally restricted to expenditures for specified purposes.
Debt Service Fund - to account for the accumulation of resources for, and
the payment of, general long-term debt principal and interest.
Proprietarv Funds
Enterprise Funds to account for
maintenance of governmental facilities
charges to the public.
the
and
acquisition, operation,
services supported by
and
user
Fiduciarv Funds
Trust and AEency Funds - to account for
in a trustee capacity or as an
organizations, other governmental units
assets held by a governmental unit
agent for individuals, private
and/or other funds.
Account Grouos
General Fixed Assets
equipment, including
acquired and accounted
Account Grouos to account
construction work in progress,
for through the Enterprise Fund.
for property
other than
and
that
General Lon~-Term Debt Account Grouo - to account for the
outstanding bonds and general notes, except those secured by
the Enterprise Fund, which are reported therein.
principal of
revenues of
l6
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
NOTES TO FINANCIAL STATEMENTS (CONTINUED)
SEPTEMBER 30, 1987
I
Note A: Summary of Significant AccountinE Policies (continued)
2. Basis of Accounting
I
The accompanying financial statements have been prepared in accordance with
generally accepted accounting principles as set forth by the National
Council on Governmental Accounting's Statement 1 entitled "Governmental
Accounting and Financial Reporting Principles."
I
I
The City employs the modified accrual basis of accounting in all funds
except the Enterprise Funds. The modified accrual basis recognizes
revenues that are susceptible to accrual when measurable and available and
recognizes expenditures as incurred except for unmatured interest on
general long-term debt. All revenues of the City are considered
susceptible to accrual with the exception of delinquent taxes. Budgets
follow the same basis of accounting as the funds for which they were
established. The Enterprise Funds use the full accrual basis of accounting
recognizing revenues when earned and expenses when incurred.
I
I
I
Unbilled services receivables have been accrued in the Proprietary Funds.
I 3. Investments
The City pools idle cash from all funds for the purpose of increasing
income through investment activities. Earnings from these investments are
allocated monthly to each fund based on the amount invested. Investments
are carried at cost which approximates market value.
I
4. General Fixed Assets
I
General fixed assets are recorded as expenditures in the General Fund at
the time of purchase and are capitalized in the General Fixed Assets
Account Group at cost. Donated general fixed assets are stated at their
fair market values at the date of donation. The General Fixed Assets
Account Group includes public domain or "infrastructure" general fixed
assets titled "Improvements other than buildings" which includes roads,
bridges, curbs and gutters, streets and sidewalks, and similar assets.
Depreciation is not recorded for general fixed assets.
I
I
5. Budgets
I
The original budget is adopted by the City Council prior
of the fiscal year through passage of an ordinance. The
proposed expenditures and the means of financing them.
to the beginning
budget includes
I
I
I
17
I
I
CITY OF SCHERTZ, TEXAS
NOTES TO FINANCIAL STATEMENTS
SEPTEMBER 30, 1987
(CONTINUED)
I
I
Note A: Summa~ of Significant Accounting Policies (continued)
5. Bud~ets (continued)
I
The City Manager
within any fund;
of any fund must
is authorized to exceed budgeted amounts in
however, any revisions that alter the total
be approved by the City Council.
a department
expenditures
I
Total expenditures for all departments taken as a whole may not
exceed budget appropriations. The City has complied with all
requirements for the year ended September 30, 1987. The final
budget is used in this report. Unencumbered appropriations lapse
end of each year.
legally
budget
amended
at the
I
I
Budgets for the General and Special Revenue Funds are adopted on a basis
consistent with generally accepted accounting principles (GAAP). Budgets II
are not legally required or prepared for the other funds.
All revenue sharing funds are transferred to the general fund where they I
are expended. Accordingly only total transfers to the general fund are
budgeted within the revenue sharing fund.
6. Property. Plant and Equipment
I
Depreciation is recorded only in the Proprietary (Water/Sewer System and
the Schertz Area Facility for Emergency Services) Funds. Exhaustible fixed
assets having a cost in excess of $150 and a useful life longer than one
year are capitalized and charged as an expense over their estimated useful
lives.
I
Depreciation is recorded
Proprietary Funds using
estimated useful lives:
on each class of depreciable property in the
the straight-line method over the following
I
I
Improvements
Buildings
Machinery and Equipment
lO-50 years
20 years
5-10 years
I
7. Interfund Transactions
During the course of normal operations, the City has numerous transactions
between funds including expenditures and transfers of resources to provide I
services, construct assets and service debt. Transfers are recorded in the
following manner:
I
a. Ouasi-External Transactions and Reimbursements
I
The following
transfers but
types of interfund
are accounted for as
transactions do not constitute
fund revenues, expenditures or
I
18
I
I
I
CITY OF SCHERTZ, TEXAS
NOTES TO FINANCIAL STATEMENTS
SEPTEMBER 30, 1987
(CONTINUED)
I
Note A: Summary of SiEnificant AccountinE Policies (continued)
II 7a. Interfund Transactions (continued)
I
expenses (as appropriate), or adjustments thereto, in the manner
specified.
I
(l) Quasi-External Transactions Transactions that would be treated as
revenues, expenditures, or expenses if they involved organizations
external to the governmental unit; e.g., payments in lieu of taxes
from an Enterprise Fund to the General Fund; routine employer
contributions from the General Fund to a Pension Trust Fund; and
routine service charges for inspection, engineering, utilities, or
similar services provided by a department financed from one fund to
a department financed from another fund - are accounted for as
revenues, expenditures, or expenses in the funds involved.
I
I
I
(2) Reimbursements (a) Transactions which constitute reimbursements of a
fund for expenditures or (b) expenditures or expenses initially made
from one fund which are properly applicable to another fund e.g., an
expenditure properly chargeable to a Special Revenue Fund was
initially made from the General Fund, which is subsequently
reimbursed are recorded as expenditures or expenses (as
appropriate) in the reimbursing fund and as reductions of the
expenditure or expense in the fund that is reimbursed.
I
I
b. Transfers
I
All interfund transactions except loans or advances, quasi- external
transactions, and reimbursements are transfers. The two major categories
of interfund transfers are:
I
(I) Residual Eauitv Transfers Nonrecurring or nonroutine transfers of
equity between funds; e.g., contribution of Enterprise Fund capital
by the General Fund, subsequent return of all or part of such
contribution to the General Fund, and transfers of residual balance
of discontinued funds to the General Fund or a Debt Service Fund.
I
I
(2) OperatinE Transfers All other interfund transfers e.g., legally
authorized transfers from a fund receiving revenue to the fund
through which the resources are to be expended, transfers of tax
revenues from a Special Revenue Fund to a Debt Service Fund,
transfers from the General Fund to a Special Revenue operating
subsidy,' transfers from the General or a Special Revenue Fund to an
Enterprise Fund, and transfers from an Enterprise Fund other than
payments in lieu of taxes and similar items to finance General Fund
expenditures.
I
I
I
19
II
CITY OF SCHERTZ, TEXAS
NOTES TO FINANCIAL STATEMENTS
SEPTEMBER 30, 1987
(CONTINUED)
Note A: Summa~ of SiEnificant Accounting Policies (continued)
8. Vacation and Sick Leave
I
I
I
I
Employees earn vacation leave at varying rates depending on length of I
services as follows: 1 day per month for the first 5 years, 1.25 days per
month for years 6 through lO, and 1.66 days per month for 11 or more years
service. A maximum of 2 years leave can be carried as of September 30th of
each year and no vacation leave is allowed for the first year. At I
termination, employees are paid for any accumulated vacation leave up to 2
years. The liability for accumulated vacation leave at September 30, 1987,
is $59,804 as reported in the Proprietary Funds and the General Long-Term I
Liabilities Account Group (for Governmental Fund Types).
Employees earn sick leave at the rate of 1 day per month starting on date I
of employment. A maximum of 120 days of sick leave can be accrued. No
sick leave is paid upon termination of employees.
9. Inventorv
Inventory is valued at the lower of cost or market on the first-in,
first-out basis.
10. Reporting Entitv
The City's combined financial statements include the accounts of all City
operations. The City's major operations include police and fire
protection, streets, parks and recreation, and general administrative
services. In addition, the City owns and operates two major enterprise
activities, a water/sewer system and the Schertz Area Facility for
Emergency Services. The following organizations are not a part of the City
of Schertz and are excluded from the accompanying financial statements:
Schertz Library Board -- This board, appointed by the City Council, works
to obtain private and other public funding to enhance the library
operation. Once appointed, the board works independently of any City
influence. The City has no management control over the library operation
or direct influence over operations. All funds obtained by the board are
used as the board sees fit with the City having no authority,
responsibility or obligations. This funding is in addition to budgeted
general fund support of the library. The library could not operate without
this budgeted funding which is approved and controlled by the City.
Schertz Volunteer Fire Department Board -- This board of local citizens
works to provide private additional funding for fire equipment. This board
is made up of private citizens not appointed by the City Council and has nq
management control or direct influence over operations of the Schertz Vol.
Fire Department. All funds obtained by the board are used as the board
sees fit with the City having no authority, responsibility or obligation.
20
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
NOTES TO FINANCIAL STATEMENTS
SEPTEMBER 30, 1987
(CONTINUED)
I
Note A:
Summary of SiEnificant Accounting Policies (continued)
I
11.
Financial Presentation
I
I
Total columns on the combined statements are captioned Memorandum Only to
indicate that they are presented only to facilitate financial analysis.
Data in these columns does not present financial position, results of
operations, or changes in financial position in conformity with generally
accepted accounting principles. Neither is such data comparable to a
consolidation. Interfund eliminations have not been made in the
aggregation of this data.
I
Note B: Pension Plan
I
Substantially all employees of the City are covered by a defined
contribution pension trust. Under this single employer plan, the City's
only responsibility is to contribute 4% of each employee's salary on a
monthly basis to the insurance company having complete fiduciary
responsibility. The City's contribution for employees vests as follows:
I
I
Less than Five Years
Five Years
Six to Ten Years
Eleven to Fifteen Years
-0-
25%
5% per year
10% per year
I
An employee who quits before the five year initial vesting period is
entitled only to his own contributions. Nonvested amounts contributed by
the City are used to offset future payments. Contributions for the year
ended September 30, 1987 were $31,054 with $6,908 and $24,146 charged to
the Enterprise Funds and General Fund, respectively. One payment was
made to a beneficiary on a death loss in the amount of $5,196.
I Note C: Prooertv Taxes
I
I
Taxes were levied on and payable as of January 1. The City bills and
collects its own taxes. Actual tax bills are mailed October l. Current
year taxes become delinquent February I. Current year delinquent taxes
not paid by July 1 are turned over to attorneys for collection action.
I
For fiscal year 1987, the assessed tax rate for the City
100 on an assessed valuation of $144,701,694. This is
$.345 per 100 for general operations and $.078 per
retirement. Total tax levy for 1987 is $597,328.
is $.4128 per
broken out as
100 for debt
I
I
I
I
21
Note D: Investments
CITY OF SCHERTZ, TEXAS
NOTES TO FINANCIAL STATEMENTS
SEPTEMBER 30, 1987
(CONTINUED)
Total
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Investments owned by various City funds are summarized as follows:
NBC Bank - Randolph
Savings Account
Schertz Bank and Trust
Certificates of Deposit:
30 day maturity
First International
Bank of San Antonio
AIM Treasury Fund
Principal Cash
Note E: Long-Term Debt
Interest
Rates
Restricted
Unrestricted
$
52,793
2,989,671
200,647
3,699
$ 3,246,8l0
At September 30, 1987, the City's long-term debt consisted of the
following:
General Obligation
Bonds
Water and Sewer:
Revenue
Certificates of
Obligation
Public Facility
Loan HUD
5.5%
$
52,793
$
5.98%
2,088,589
901,082
variable
variable
200,647
3,699
$ 2,345,728
$
901,082
Range of
Interest
Rates
Unpaid
Principal
Current
Maturities
3 3/8%-8.3% $ 888,000 $ 24,000
4%-lO% 2,110,000 65,000
9.3%-lO% 1,260,000 40,000
5% 111,000 3,000
------------ ------------
$ 4,369,000 $ 132,000
22
Long-Term
Maturities
$ 864,000
2,045,000
1,220,000
108,000
$ 4,237,000
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
NOTES TO FINANCIAL STATEMENTS
SEPTEMBER 30, 1987
(CONTINUED)
Note E: LonE-Term Debt (continued)
The annual requirements to amortize all debt outstanding as of September
30, 1987, including interest payments, are as follows:
Year
Ending
Sept. 30
Water and Sewer
Certificates
Of Public Facility
Revenue Bonds Obli~ation Loan HUD
General
Obligation
Bonds
1988 $ 96,900 $ 22l,197 $ 155,257 $ 8,550
1989 93,758 221,285 15l,258 8,400
1990-l994 480,008 1,09l,745 788,740 4l,700
1995-1999 478,993 1,043,183 8l2,l82 41,000
Thereafter 252,405 1,347,976 435,500 88,400
----------- ----------- ------....._--- ------------
$ 1,402,064 $ 3,925,386 $ 2,342,937 $ 188,050
Principal $ 888,000 $ 2,110,000 $ 1,260,000 $ 110,000
Interest 514,064 1,815,386 1,082,937 77,050
----------- ----------- ------------ ------------
$ 1,402,064 $ 3,925,386 $ 2,342,937 $ 187,050
Balance Balance
Outstanding Outstanding
Original Interest October 1, September 30,
Amount Rates 1986 Retirements 1987
General
Obligation
1962 Series $ 30l,000 3 3/8%-3 5/8% l65,000 $ 9,000 $ 156,000
1972 Series 150,000 4 l/2%-6.3% 95,000 8,000 87,000
1975 Series 235,000 6.2%-7.2% 190,000 5,000 185,000
1987 Series 460,000 6.3%-8.3% 460,000
---..-------- ------------ ------------
Totals $ 450,000 $ 22,000 $ 888,000
23
CITY OF SCHERTZ, TEXAS
NOTES TO FINANCIAL STATEMENTS
SEPTEMBER 30, 1987
(CONTINUED)
Note
E: LonE-Term Debt (continued)
Original
Amount
Revenue Bonds:
1968 Series $ 579,000
1973 Series l65,000
1975 Series 325,000
1981 Series 475,000
1987 Series l020000
Certificates of
Obligation:
1981 Series 150,000
1983 Series 1,250,OOO
Public Facility
Loan HUD l42,000
Totals
Interest
Rates
Balance
Outstanding
October 1,
.l.2li.
Retirements
Balance
Outstanding
September 30,
1987
4.00%-5.75% $ 275,000 $
5.75%-6.l0% l65,000
7.00%-7.75% 285,000
9.00%-10.00% 410,000
6.30%-8.30%
25,000
$ 250,000
165,000
5,000
280,000
15,000
395,000
1,020,000
9.30%-10.00%
130,000
5,000
35,000
l25,000
8.20%-10.00%
l,170,000
1,135,000
5.00%
114,000
3,000
111,000
$ 2,549,000
$
88,000
$ 3,481,000
Bonded debt of the City consists of various series of General Obligation
Bonds, Revenue Bonds, Certificates of Obligation and Public Facility Loan
H.U.D.. General Obligation Bonds are direct obligations of the City for
which its full faith and credit are pledged, and are payable from taxes
levied on all taxable property located within the City. Revenue bonds
are generally payable from pledged revenues generated by the Water and
Sewer Fund. The debenture agreement for Water and Sewer Revenue Bonds
require funds be available for l/l2th the principal and l/6th the
interest requirements of the next fiscal year. Certificates of
Obligation are payable from a levy of ad valorem taxes upon all taxable
property within the City, and are further payable from certain net
revenues derived from the operation of the City's combined Water and
Sewer systems after payments of first lien revenue bonds. The Public
Facility Loan is payable from gross revenue derived from operations of
the Water and Sewer Systems and has equal status with first lien revenue
bonds.
24
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
NOTES TO FINANCIAL STATEMENTS
SEPTEMBER 3D, 1987
(CONTINUED)
Note E:
Long-Term Debt (continued)
During the fiscal year ended September 30, 1987 both tax Revenues and
Water and Sewer system revenues were used to pay these certificates of
obligation, as follows:
Water/Sewer Revenues
Principal Interest Total
$ 0 $ 90,385 $ 90,385
40,000 28,873 68,873
...----------- ------------ ------------
$ 40,000 $ 119,258 $ l59,258
Tax Revenues
The City of Schertz has provided for and maintained the various debt
service and reserve funds as required under the City's Revenue Bonds and
Certificates of Obligation ordinances.
Note F: General Fixed Assets
The following is a summary of changes in general fixed assets.
Balances Balances
At At
October 1, September 30,
1986 Additions Deductions 1987
Land $ 240,210 $ $ $ 240,210
Buildings 937,278 l,462 966,740
Improvements
Other than
Buildings 2,428,602 94,786 2,540,670
Vehicles 34l,059 65,390 18,487 398,024
Equipment 379,654 84,771 lO,936 473,537
----------- ----------- ------------ ------------
$ 4,326,803 $ 246,409 $ 29,423 $ 4,6l9,l81
The sources of general fixed assets acquired follow:
General Fund
Capital Projects
General Obligation Bonds
Time Warrants
Contributed
$ 1,482,607
300,000
47,169
2,789,405
$ 4,619,l8l
25
CITY OF SCHERTZ, TEXAS
I
I
NOTES TO FINANCIAL STATEMENTS
SEPTEMBER 30, 1987
( CONTINUED)
Enterprise Funds
Water/Sewer SAFES
Total
I
I
I
I
I
I
Note H: Property. Plant. and Equipment:
The following is a summary of the property, plant, and equipment of the
Proprietary Funds at September 30, 1987.
Buildings
Improvements Other than Buildings
Machinery and Equipment
Land
$ 73,054 $ 26,656 $ 99,710
6,080,914 6,080,914
283,392 230,834 5l4,226
------------ ------------ ------------
6,437,360 257,490 6,694,850
(2,025,713) (103,132) (2,128,845)
------------ ------------ ------------
4,411,647 154,358 4,566,005
76,262 76,262
------------ ------------ ------------
$ 4,487,909 $ 154,358 $ 4,642,267
I
Accumulated Depreciation
I
Note I: Funds Reserved for STEP Expenditures
This is a reserve for the remaining balance of earned STEP (Selective
Traffic Enforcement Program) revenues to be expended in fiscal year
1987-1988. Under this program, City policemen volunteer to patrol high
traffic areas after normal duty hours. Revenues from tickets they issue
are used for special police equipment not included in the City's budget.
I
I
I
I
I
I
I
I
26
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
NOTES TO FINANCIAL STATEMENTS
SEPTEMBER 30, 1987
(CONTINUED)
Note J: Interfund Receivables and Payables
The following is a summary of amounts due from and due to other funds as
of September 30, 1987.
I
I
I
I
Due From
Due To
General Fund:
Special Revenue Fund
Enterprise Funds
$
92l
100
$
45,000
Total General Fund
1,02l
45,000
Special Revenue Fund
General Fund
921
I
I
Enterprise Funds
General Fund
Trust and Agency Funds
45,000
lOO
Total All Funds
$ 46,021
$ 46,021
I
I
I
I
I
I
I
I
27
I
Note K:
CITY OF SCHERTZ, TEXAS
\.. '
NOTES TO FINANCIAL STATEMENTS
SEPTEMBER 30, 1987
(CONTINUED)
Interfund Transfers
Transfers
Out
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
The following is a summary of amounts transferred in and out of Funds
for the year ended September 30, 1987.
General Fund:
Special Revenue Fund
Debt Service Fund
Total General Fund
Special Revenue Fund:
General Fund
Debt Service Fund
General Fund
Trust & Agency Funds
General Fund
Total All Funds
28
Transfers
In -
$
37,6l7
37,6l7
l07,878
2,436
$
147,931
$
2,436
107,878
110,314
37,617
$
147,931
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
NOTES TO FINANCIAL STATEMENTS
SEPTEMBER 30, 1987
( CONTINUED)
NoteL: Se~ment Information for Enterprise Funds
The City has two enterprise
emergency ambulance services.
period ended September 30, 1987
operations which provide
Segment information for
is as follows:
water/sewer and
the twelve month
Water/Sewer
SAFES
Operating Revenues
$ 1,339,061
$
190,l50
Operating Expenses, Exclusive Of
Depreciation
888,916
170,453
Depreciation
294,529
40,635
Operating Income (Loss)
155,616
(20,938)
Other Income (Expenses)
(259,617)
24, 13 7
Operating Transfers In (Out)
40,000
Net Income (Loss)
(64,001)
3,199
Total Assets
7,185,407
257,628
215,703
Total Equity
3,410,661
(30,396)
35,431
Working Capital
Additions to Fixed Assets
3,376,000
83,807
o
Outstanding Long-Term Debt
2,464,000
Note M: Commitments to Contin~encies
As of September 30, 1987, the City of Schertz, Texas, had
commitments or contingent liabilities.
no material
29
u
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
.h-..,. This page intentionally left blank.
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
COMBINING AND INDIVIDUAL FUND STATEMENTS
AND ACCOUNT GROUPS
SUPPLEMENTAL STATEMENTS
30
~.~.
This page intentionally left blank.
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
GENERAL FUND
I
The General Fund accounts for the resources used to finance
operations of the City. It is the basic fund of the City
activities for which a separate fund has not been established.
I
I
I
I
I
I
I
I
I
I
I
31
I
the fundamental
and covers all
..~,... This page intentionally left blank.
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
GENERAL FUND
COMPARATIVE BALANCE SHEET
SEPTEMBER 30, 1987 AND 1986
ASSETS
Cash
Certificates of Deposit
Delinquent Taxes Receivable
Due From Other Funds
Inventory of Supplies, At Cost
LIABILITIES AND FUND BALANCE
Liabilities:
Vouchers Payable
Deferred Revenue
Due to Other Funds
Total Liabilities
Fund Balance:
Reserved for Inventory of Supplies
Reserved for STEP Expenditures
Undesignated
Total Fund Balance
Total Liabilities and Fund Balance
32
September 30,
1987
$ 2,443
458,345
29,594
1,021
6,8l5
$ 498,218
$ 26,364
29,594
45,000
100,958
6,815
10,359
380,086
397,260
$ 498,2l8
September 30,
1986
$ 36,508
50,526
19,523
484
9,140
$ 116,181
$ 2l,506
19,523
41,029
9,140
4,339
62,673
76,152
$ 117,l81
CITY OF SCHERTZ, TEXAS
GENERAL FUND
STATEMENT OF REVENUES - BUDGET AND ACTUAL
FOR THE YEAR ENDED SEPTEMBER 3t1, 1987
WITH COMPARATIVE ACTUAL AMOUNTS FOR THE YEAR ENDED SEPTEMBER 30,
Taxes:
Ad Valorem
Tax Penalty
City Sales Tax
Utility Franchise
Other
1987
BudEet
$
604,028 $
4,100
402,072
125,100
6,200
Total Taxes
1,141,500
Licenses and Permits
77,878
Charges for services:
Swimming Pool
Animal Shelter
Other
23,200
5,850
8,300
Total Charges For
Services
37,350
Fines and Forfeitures
l45,200
Other Sources:
Building Rental
Miscellaneous
SAFES - Municipal Support
Retirement Reversion
Cibolo Creek Municipal
Authority
Interest
Indirect Cost Reimbursement:
Water and Sewer Fund
Discounts
Emergency Management
Coordinator
2,600
9,500
4,800
5,000
6,200
l8,000
151,048
lOO
9,000
Total Other
Sources
206,248
1987
Actual
599,374
4,951
423,721
121,277
2,785
1,152,l08
76,821
17,646
6,763
8,050
32,459
159,283
2,298
l2,632
4,800
2,102
6,254
14,735
153,144
57
7,815
203,837
Variance
Favorable
(Unfavorable)
$
(4,654)
851
21,649
(3,823)
(3,415)
10,608
(1,057)
(5,554)
913
(250)
(4,89l)
14,083
(302)
3,132
o
(2,898)
54
(3,265)
2,096
(43)
(l,185)
(2,411)
Total Revenues $ 1,608,176 $ 1,624,508 $
33
16,332
1986
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
1986
Actual
$ 538,224
5,297
395,544
l23,704
5,536
l,068,305
117,685
23,689
8,122
7,028
38,839
l21,054
2,750
16,809
4,800
10,893
5,962
19,696
100,000
139
4,723
l65,772
$ 1,511,655
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
General Government:
City Council
City Manager
Finance
Tax
Planning and Zoning
Legal
Municipal Court
Municipal Building
General Administrative
Total General
Government
Public Safety:
Police Department
Fire Department
Inspection
Total Public Safety
Streets and Parks:
Engineering
Streets
Parks
Total Streets and
Parks
Health:
Animal Control
Total Health
Other:
Recreation
Swimming Pool
Library
Capital Outlay
Bond Expenses
Total Other
CITY OF SCHERTZ, TEXAS
1986
Actual
$ 22,426 $ 22,787 $ (361) $
l48,698 148,654 44
13,750 13 , 341 409
33,868 33,956 (88)
l,8l5 1,666 149
22,lOO 34,717 (12,6l7)
8,400 8,452 (52)
137,075 135,093 1,982
318,522 316,576 1,946
706,654
340,258
128,406
48,749
517 ,413
42,200
216,895
62,016
321,111
55,407
55,407
37,650
34,287
27,215
99,152
Total Expenditures $ 1,699,737
GENERAL FUND
STATEMENT OF EXPENDITURES - BUDGET AND ACTUAL
FOR THE YEAR ENDED SEPTEMBER 30, 1987
WITH COMPARATIVE ACTUAL AMOUNTS FOR THE YEAR ENDED SEPTEMBER 30, 1986
Variance
1987 1987 Favorable
BudEet Actual (Unfavorable)
13,452
123,127
12,9l6
39,361
1,636
13,989
8,906
134,948
272,345
----------- ...----------- ------------
715,242 (8,588) 620,680
----------- ------------ ------------
323,855 l6,403 295,911
116,261 12,145 82,623
48,420 329 38,043
----------- ------------ -----------..
488,536 28,877 4l6,577
----------- ------------ ---------..--
40,522 l,678 35,488
217,270 (375) 167,441
60,927 1,089
----------- ------------ ..-------....--
318,719 2,392 202,929
----------- ------------ ------------
55,657 (250) 43,929
----------- ------------ ------------
55,657 (250) 43,929
----------- ------------ -.._---------
39,406 (1,756) 32,435
34,181 106 29,927
26,546 669 35,439
11 ,416 (11,4l6)
----------- ------------ ..-----------
111,549 (l2,397) 97,801
----------- ------------ ------------
$ l,689,703 $ 10,034 $ l,381,916
34
This page intentionally left blank.
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
SPECIAL REVENUE FUND
I
Special Revenue Funds are used to account for the proceeds of special revenue
sources that are legally restricted to expenditures for specific purposes.
The revenue sharing fund was established to account for the receipt and
disbursement of Federal Reserve Sharing Funds.
I
I
I
I
I
I
I
I
I
I
I
35
I
Cash
Certificates of Deposit
Total Assets
Liabilities:
Due to General Fund
Fund Balance:
Undesignated
Total Fund Balance
CITY OF SCHERTZ. TEXAS
SPECIAL REVENUE FUND
COMPARATIVE BALANCE SHEET
SEPTEMBER 30, 1987 AND 1986
ASSETS
LIABILITIES AND FUND BALANCE
36
1987
$
33,686
$ 33,686
$ 921
32,765
$ 33,686
1986
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
$
61,826
$ 6l,826
$ 70
6l,756
$ 61,826
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
SPECIAL REVENUE FUND
STATEMENT OF REVENUE & USES - BUDGET AND ACTUAL
FOR THE YEAR ENDED SEPTEMBER 30, 1987
WITH COMPARATIVE ACTUAL AMOUNTS FOR THE YEAR ENDED SEPTEMBER 30,
1986
1987
Budget
Variance
Favorable
(Unfavorable)
1987
Actual
1986
Actual
Revenues:
Intergovernmental Revenues $
$
6,601 $
(6,601)
(2,946)
$ 36,782
Other Sources
2,946
3,505
Total Revenue $ 0 $ 9,547 $ (9,547) $ 40,287
Other FinancinE (Uses):
Operating Transfers (Out) $ (44,000) $ (37,617) $ (8l,6l7) $ (25,46l)
Transfers Due (Out) (92I) (921)
----------- ----------- ------------ ------------
Total Other Financial
(Uses) $ (44,000) $ (38,538) $ (82,538) $ (25,461)
37
This page intentionally left blank.
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
This fund
payment of
the City.
I
I
I
I
I
I
I
I
I
I
I
DEBT SERVICE FUND
is used to account for the accumulation of resources for and the
principal, interest, and related costs on general long-term debt of
38
Cash
Certificates of Deposit
Delinquent Taxes Receivable
Total Assets
CITY OF SCHERTZ, TEXAS
DEBT SERVICE FUND
COMPARATIVE BALANCE SHEET
SEPTEMBER 30, 1987 AND 1986
ASSETS
DEFERRED REVENUE AND FUND BALANCE
Deferred Revenue:
Ad Valorem Taxes
Fund Balance - Reserved
for Debt Service
Total Deferred Revenue
and Fund Balance
39
1987
$
551
129,651
5,695
$ l35 , 897
$ 5,695
130,202
$ 135,897
1986
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
$
125,649
3,984
$ 129,633
$ 3,984
l25,649
$ l29,633
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
DEBT SERVICE FUND
COMPARATIVE STATEMENT OF REVENUES, EXPENDITURES,
FOR THE YEARS ENDED SEPTEMBER 30,
Revenues:
Interest Income
Total Revenues
Expenditures:
Bond Principal
Bond Interest
Agent Fees
Total Expenditures
Excess of Expenditures Over Revenues
Other Financing Sources:
Operating Transfers In
Operating Transfers Out
Excess of Revenues Over (Under)
Expenditures
Fund Balance - October 1
Fund Balance - September 30
40
AND CHANGES IN FUND BALANCE
1987 AND 1986
1987
1986
$
$
13,3l9
4,359
l3,3l9 4,359
22,000 21,000
54,042 63,327
602 6ll
76,644 84,938
(63,325) (80,579)
107,878 83,l25
(40,000)
4,553 2,546
125,649 123,103
$
130,202
$
125,649
This page intentionally left blank.
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
PROPRIETARY FUND TYPES
ENTERPRISE FUNDS
Enterprise Funds are established to account
to be self-supporting through user charges.
Water/Sewer System and the Schertz Area
(SAFES) on this basis.
I
I
I
I
I
I
I
I
I
I
I
I
I
I
for operations which are intended
The City of Schertz operates the
Facility for Emergency Services
41
CITY OF SCHERTZ, TEXAS
ENTERPRISE FUNDS
COMBINING BALANCE SHEET
SEPTEMBER 30, 1987
WITH COMPARATIVE TOTALS FOR THE YEAR ENDED SEPTEMBER 30, 1986
ASSETS
Current Assets
Cash
Certificates of
Deposit
Due from Other Funds
Accounts Receivable
(Net)
Inventory of Supplies,
At Cost
Total Current Assets
Restricted Assets
Cash
Investment At Cost
Land and Improvements
Buildings
Improvements Other Than
Buildings
Machinery and Equipment
Accumulated Depreciation
Organization Costs
Accumulated Amortization
Total Assets
Water/Sewer
System
$
11,877 $
104,986
116,863
45,000
175,428
3l,059
368,350
4,576
2,323,473
76,262
73,054
6,080,914
283,392
(2,025,713)
1,900
(801)
$ 7,185,407 $
SAFES
13,362 $
25,953
39,315
20,946
l7,095
77,356
3,659
22,255
26,656
230,834
(103,132)
40,779
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Totals
September 30, September 30,
1987 1986
25,239 $
130,939
156,l78
45,000
196,374
48,l54
445,706
8,235
2,345,728
76,262
99,710
6,080,914
514,226
(2,128,845)
1,900
(80l)
257,628 $ 7,443,035
42
64,452
105,231
152,696
5l,519
309,446
6,309
1,282,550
65,894
95,2l0
6,079,678
454,226
(1,859,984)
1,900
(753)
$ 6,434,476
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
ENTERPRISE FUNDS
COMBINING BALANCE SHEET (CONTINUED)
SEPTEMBER 30, 1987
WITH COMPARATIVE TOTALS FOR THE YEAR ENDED SEPTEMBER 30, 1986
$ 184,306 $ 35,697 $ 220,003 $ 97,759
100 100 404
7,285 6,228 13,513 l2,088
------------ --------...-- ------------ --..--....-----
191,691 41,925 233,616 110,251
LIABILITIES AND FUND
EQUITY
Current Liabilities
(Payable from
Current Assets):
Vouchers Payable
Due To Other ~~nds
Accrued Vacation and
Sick Leave
(Payable From Restricted
Assets):
Deposits
Revenue Bonds
Cert. of Obligation
Total Current
Liabilities
Revenue Bonds Payable,
Less Current Maturities
Cert. of Obli, payable
Less Current Maturities
Public Facility Loan BUD
Total Liabilities
Fund Equity
Contributed Capital
Retained Earnings:
Reserved for Revenue
Bond Retirement
Reserved for Equipment
Replacement and
Capital Improvements
Unreserved
Total Fund Equity
Water/Sewer
System
SAFES
102,055
65,000
40,000
398,746
4l,925
2,045,000
1,220,000
111,000
3,774,746
41,925
2,504,485
160,698
204,346
335,428
366,402
55,005
3,410,661
215,703
Total Liabilities
and Fund Equity $ 7,185,407
Totals
September 30, September 30,
1987 1986
102,055 92,025
65,000 45,000
40,000 40,000
------------ ------------
440,671 287,276
------------ ------------
2,045,000 1,090,000
1,220,000 l,260,000
11l,OOO 114,000
------------ -----------..
3,816,671 2,751,276
------------ ------------
2,665,183 2,661,216
204,346 l74,826
335,428
421,407
328,765
518,392
3,626,364
3,683,199
$ 257,628 $ 7,443,035 $ 6,434,475
43
CITY OF SCHERTZ, TEXAS
COMBINING STATEMENT OF REVENUES, EXPENSES, AND CHANGES
IN RETAINED EARNINGS - ALL PROPRIETARY FUND TYPES
FOR THE YEAR ENDED SEPTEMBER 30, 1987
WITH COMPARATIVE TOTALS FOR THE YEAR ENDED SEPTEMBER 30, 1986
Enterprise Funds
Water/Sewer
System SAFES
Totals
September 30, September 30,
1987 1986
Operating Revenue:
Fees Charged To Users $ l,339,061 $
190,150 $ 1,529,2l1
$ l,525,190
Total Operating
Revenue
1,339,06l
190,l50
1,529,211
1,525,190
Operating Expenses Before.
Depreciation:
Personal Services
Sewage Treatment
Reimbursement of General
and Administrative
Expenses
Contractual Services
Supplies
Bad Debts
192,804
327,752
60,68l 253,485 213,827
327,752 357,772
4,800 157,944 104,800
64,722 219,835 86,943
22,895 81,3l7 221,64l
17,355 19,036 l5,919
------------ ------------ ------------
153,144
155,113
58,422
1,681
Total Operating Ex-
penses Before
Depreciation
888,916 170,453 1,059,369 1,000,902
------------ ------------ ------------ ------------
450,l45 19,697 469,842 524,288
------------ ------------ ------------ ------------
294,529 40,635 335,164 338,l06
155,616 (20,938) 134,678 186,182
------------ ----------- ------------ -----------..
Operating Income
Before Depreciation
Depreciation
Operating Income (Loss)
44
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
COMBINING STATEMENT OF REVENUES, EXPENSES, AND CHANGES
IN RETAINED EARNINGS - ALL PROPRIETARY FUND TYPES (CONTINUED)
FOR THE YEAR ENDED SEPTEMBER 30, 1987
WITH COMPARATIVE TOTALS FOR THE YEAR ENDED SEPTEMBER 30, 1986
Other Income (Expense):
Interest Income
Interest Expense
Amortization
Bond Expenses
County Contingency
Loss on Trade or Sale
of Assets
Lawsuit Legal Fees
Total Other Income
(Expenses)
Net Income (Loss) Before
Operating Interfund .
Transfers
Operating Transfers In
Net Income (Loss)
Retained Earnings -
October 1
Retained Earnings -
September 30
Enterprise Funds
Water/Sewer
System SAFES
Totals
September 3D, September 30,
1987 1986
$ 117,063 $ 3,805 $ 120,868 $ 92,3l4
(178,248) (178,248) (181,l40)
(48) (48) (48)
(59,910) (59,910)
22,667 22,667 8,875
(2,335) (2,335) (13,002)
(138,474) (138,474) (85,849)
....---------- -------......_- ------------ ------------
(259,617) 24,137 (235,480) (178,850)
------------ ----------- ---------......- -----------...
(104,001) 3,199 (100,802) 7,332
40,000 40,000 18,103
------------ -..-......_---- ------------ -------...----
(64,00l) 3,l99 (60,802) 25,435
970,177 5l,806 1,02l,983 996,548
------------ ...---------- ------------ ------------
$ 906,176 $ 55,005 $ 96l,l81 $ l,021,983
45
CITY OF SCHERTZ, TEXAS
COMBINING STATEMENT OF CHANGES IN FINANCIAL POSITION _
ALL PROPRIETARY FUND TYPES
FOR THE YEARS ENDED SEPTEMBER 30, 1987
WITH COMPARATIVE TOTALS FOR THE YEAR ENDED SEPTEMBER 30, 1986
Sources of Workin~
Capital:
Operations:
Net Income (Loss) $
Items Not Requiring
Working Capital:
Depreciation
Amortization
Loss on Disposal
of Assets
.Sale of Revenue Bonds
Reduction in Notes
Receivable
Reduction in Restricted
Assets
Increase in Customer
Deposits
Contributions Received
Total Sources of
Working Capital
Entervrise Funds
Water/Sewer
System SAFES
(64,OOI) $
3,l99
294,529
48
40,635
2,335
230,576
46,169
l,020,000
l2,724
10,030
3,967
$ 1,260,606
$
62,860
46
25,435
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
September
1987
Totals
30, September 30,
1986
$
(60,802) $
335,l64
48
2,335
276,745
1,020,000
12,724
lO,030
3,967
$ 1,323,466
338,106
48
13 , 002
376,591
13,138
17,370
428
$
407,527
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
COMBINING STATEMENT OF CHANGES IN FINANCIAL POSITION _
ALL PROPRIETARY FUND TYPES (CONTINUED)
FOR THE YEAR ENDED SEPTEMBER 30, 1987
WITH COMPARATIVE TOTALS FOR THE YEAR ENDED SEPTEMBER 30, 1986
Acquisition of Property,
Plant and Equipment $ 60,936 $
Reduction In Long-Term
Debt 88,000
Retirement of Property,
Plant and Equipment
Increase In Restricted
Assets l,077,828
Net Increase (Decrease)
In Working
Capital $ 33,842 $
Uses of Working
Capital:
Total Uses Of
Working Capital
Elements Of Net
Increase (Decrease)
in WorkinE Capital:
Cash
Investments At Cost
Accounts Receivable
Inventories
Due from Other Funds
Vouchers Payable
Due to Other Funds
Accrued Vacation and
Sick Leave
Net Increase
(Decrease) In
Working Capital $
Enterprise Funds
Water/Sewer
System SAFES
Totals
30, September
1986
September
1987
30,
83,807
$ l44,743
$
118,153
88,000
83,000
1,077,828
l83, l77
1,226,764
83,807
l,310,571
384,330
(20,947) $
12,895
$
23,197
$ (5,509) $ (10,031) $ (l5,540) $ 13,377
48,985 17,502 66,487 lO,824
37,059 6,619 43,678 5,696
(5,883) 2,518 (3,365) (l,564)
45,000 45,000
(86,547) (35,697) (l22,244) (1,650)
(100) 404 304 643
837 (2,262) (1,425) (4,129)
-----------.. ----------- ------------ ------------
33,842 $
(20,947) $
12,895 $
23,197
47
This page intentionally left blank.
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
FIDUCIARY FUND TYPES
TRUST AND AGENCY FUNDS
Expendable Trust Funds
Self Insurance Fund - to account for the receipt of other funds' contributions
to defray uninsured losses.
Equipment Replacement Fund - to account for contributions for the replacement
of major equipment items as they are retired from service.
AEenCy Funds
Payroll Fund - to account for the collection and payment of salaries,
insurance and pension premiums, and federal taxes for each City employee.
Library Fund - to account for the funds provided by the City for support of
the community library.
State Fines Funds - to account for the collection and payment to the state,
the state's portion of traffic fines.
48
CITY OF SCHERTZ, TEXAS
TRUST AND AGENCY FUNDS
COMBINING BALANCE SHEET
FOR THE YEAR ENDED SEPTEMBER 30, 1987
WITH COMPARATIVE TOTALS FOR THE YEAR ENDED SEPTEMBER 30, 1986
Expendable
Trus t Funds
Self Equipment
Insurance Replacement
Totals
September 30, September 30,
1987 1986
Agency
Funds
Assets:
Cash $
Certificates
Of Deposit
$
2 $
5,098 $
5,lOO $
12,710
28,032
88,548
3l,88l
l48,46l
293,306
$
28,032
$
88,550 $
36,979
$
l53,56l $
306,Ol6
Liabilities and Fund Balances:
Vouchers
Payable $
Due To General
Fund
Due to Water/
Sewer
$
28,545
$
$
28,545 $
26,739
36,979
36,979
2l,569
6,530
o
Total
Liabilities
28,545
36,979
65,524
54,838
Fund Balance
28,032
60,005
88,037
25l,l78
$
28,032
$
88,550 $
36,979
$
l53,561
$
306,016
49
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
EXPENDABLE TRUST FUNDS
COMBINING STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES
FOR THE YEAR ENDED SEPTEMBER 30, 1987
WITH COMPARATIVE TOTALS FOR THE YEAR ENDED SEPTEMBER 30, 1986
Self
Insurance
Plan
Equipment
Replacement
Fund
Totals
September 30, September 30,
1987 1986
Revenues:
Interest
$
l,291
$
1l,l55
$
12,446
$
30,783
Donations
7,933
7,933
11,102
l,291
19,088
20,379
41,885
Expenditures:
Capital Outlay
185,956
185,956
98,607
Excess Of Revenues Over
Expenditures
l,291
(166,868)
(165,577)
(56,722)
Other FinancinE Sources
(Uses):
Operating Transfers In
Operating Transfers Out
2,436
2,436
o
107,000
(4,430)
Total Other Financing
Sources (Uses):
2,436
o
2,436
l02,570
Excess (Deficiency) Of
Revenue and Other Fi-
nancial Sources Over
(Under) Expenditures and
Other Financial Sources
(Uses)
3,727
(166,868)
226,873
(163,141)
45,848
Fund Balance - October l,
24,305
25l,178
205,330
Fund Balance - Sept. 30, $
$
28,032
60,005
$
88,037
$
251,178
50
8,579
24,95l
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES _
ALL AGENCY FUNDS
FOR THE FISCAL YEAR ENDING SEPTEMBER 30, 1987
AEency
Balance Balance
October 1, September 3D,
1986 Additions Deductions 1987
Payroll Fund:
Assets:
Cash $ $ 1,132,662 $ 1,132,662 $
------------ ----------- ------------ ------------
$ $ 1,132,662 $ l,132,662 $
Liabilities:
Due To General Fund
$
$ 1,132,662 $ 1,132,662
$
------------ ----------- ------------
$ $ 1,132,662 $ 1,132,662
$
Librarv Fund:
Assets:
Cash
Certificates Of
Deposit
$
4,534 $
l6,372
33,052 $
33,829
$ 3,757
$
20,906 $
4l,63l $
33,829
$ 28,708
Liabilities:
Vouchers Payable
Due To General Fund
Due to Library
$
$
$
$
20,906
33,052
25,250
28,708
$
20,906 $
33,052 $
25,250
$ 28,708
51
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES _
ALL AGENCY FUNDS
FOR THE FISCAL YEAR ENDING SEPTEMBER 30, 1986
(CONTINUED)
AEency
Balance
October l,
1986
State Fines
Fund:
Assets
Cash $
Certificates of Deposit
8,173
$
8,173
Liabilities
Due to General Fund
8,173
$
8,l73
Totals - All Agency Funds
Assets:
Cub $
Certificates of Deposit
l2,707
l6,372
Additions
Deductions
$
34,513 $
6,930
41,345
$
4l,443
$
4l,345
34,513
34,4l5
$
34,513 $
34,415
$ 1,200,227
15,509
$ 1,207,836
$ 29,079 $ 1,215,736 $ 1,207,836
Liabilities:
Due To General Fund
29,079
l,200,227
1,192,327
$ 29,079 $ 1,200,227 $ 1,192,327
52
Balance
September 30,
1987
$ l,341
6,930
$ 8,271
8,271
$ 8,271
$ 5,098
31,881
$ 36,979
36,979
$ 36,979
This page intentionally left blank.
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
GENERAL FIXED ASSETS
I
This account group is established to account f~r the fixed assets
City exclusive of those relating to Proprietary Fund operations.
transactions to acquire general fixed assets occur in the General
I
I
I
I
I
I
I
I
I
I
I
53
I
owned by the
Expenditure
Fund.
This page intentionally left blank.
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
SCHEDULE OF GENERAL FIXED ASSETS
SEPTEMBER 30, 1987 AND 1986
ASSETS
General Fixed Assets:
Land
Buildings
Improvements Other Than Buildings
Vehicles
Equipment
54
September 30,
1987
September 3D,
1986
$ 240,2l0 $ 240,210
966,740 965,278
2,540,670 2,445,884
398,024 35l,121
473,537 399,162
------------ ------------
$ 4,619,181 $ 4,401,655
General Government
Public Safety:
Police
Fire
Inspection
Street and Parks
Health:
Animal Control
Library
CITY OF SCHERTZ, TEXAS
SCHEDULE OF GENERAL FIXED ASSETS CHANGES
BY FUNCTION AND ACTIVITY
FOR THE YEAR ENDED SEPTEMBER 30, 1987
Balance
October I,
1986 Additions
$
704,927
$
5,784 $
l42,560
417 , 711
18,330
37,056
54,l91
4,000
136,268
2,909,319
34,819
3,238
5,872
i73,989
$ 4,40l,655
$ 246,409
$
28,883
55
Deductions
l4,621
8,695
5,567
Balance
September 30,
1987
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
$ 710,711
l64,995
463,207
22,330
3,040,020
38,057
l79,861
$ 4,6l9,l81
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Land
$ 19,349
12,000
l82,662
3,168
23,03l
$ 240,2l0
Components of General Fixed Assets
Improvements
Other Than
Buildings Buildings Vehicles
$ 623,236
$
$
9,648
47,000
56,667
274,071
14,833
36,077
193,137
2,529,670
5,284
11,000
6,728
98,083
$ 966,740 $ 2,540,670 $ 398,024
56
Equipment
$ 58,478
108,328
130,l36
7,497
98,474
11,877
58,747
$ 473,537
This page intentionally left blank.
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
STATISTICAL SECTION
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
GENERAL GOVERNMENTAL EXPENDITURES BY FUNCTION
LAST TEN FISCAL YEARS
TABLE 1
Total
Fiscal General Public Streets Expen-
Year Government Safety And Parks Health Other ditures
1978 138,277 197,550 122,9l0 28,287 2l,28l 508,305
1979 283,l92 188,457 l22,995 59,282 l7,75l 671,677
1980 254,297 202,l83 87,2l7 41,098 397,749 982,544
1981 295,402 231,046 98,5l8 44,812 105,667 775,445
1982 330,999 233,828 116,694 6l,683 l42,322 885,706
1983 402,757 245,926 132,088 26,786 105.525 913,082
1984 486,l78 3l0,000 167,002 30,885 105,455 l,099,520
1985 566,490 353,023 173,251 45,076 99,770 1,237,610
1986 620,680 416,578 202,929 43,929 97,80l 1,38l,917
1987 715,242 488,536 3l8,719 55,657 111,549 1,689,703
Source: Prior year's audited financial statements.
57
CITY OF SCHERTZ, TEXAS
GENERAL REVENUES BY SOURCE
LAST TEN FISCAL YEARS
TABLE 2
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Licenses Charges
Fiscal And For Fines And Total
Year Taxes Permits Services Forfeitures Other Revenue
1978 318,586 11,938 46,911 30,l57 144,136 551,728
1979 404,384 11,364 48,311 39,447 202,Ol8 705,524
1980 439,424 6,494 55,663 58,055 200,158 759,794
1981 545,308 12,014 59,599 49,694 199,359 865,974
1982 6l0,30l 19,054 71,096 74,136 283,650 1,058,237
1983 688,169 31,434 29,691 60,581 221,900 1,011,775
1984 799,876 76,5l7 33,959 78,149 228,838 1,l97,339
1985 926,883 73,521 30,440 92,437 200,701 1,323,982
1986 1,068,305 117,685 30,717 121,054 173,894 l,511,655
1987 l,l52,108 76,821 32,459 l59,837 203,837 l,624,508
58
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS TABLE 3
PROPERTY TAX LEVIES AND COLLECTIONS
LAST TEN FISCAL YEARS
Per-
Percent cent
Of Of
Total Out Delin-
Tax stand- quent
Percent Delin- Total Collec- ing Taxes
Of Levy quent Tax tions Delin- To
Fiscal Collect- Collec- Collec- To quent Tax
Year Tax Levy Collections ed tions tions Tax Levy Taxes ka
1978 229,872 228,366 99.3% 4,728 233,094 lOI.4% 2,748 1.2%
1979 244,187 243,45l 99.7% 2,057 245,508 lOO.5% 1,427 .6%
1980 255,l25 252,928 99.1% 1,069 253,997 99.6% 2,384 .9%
1981 353,056 341,102 96.6% 700 34l,802 100.2% 11,711 3.3%
1982 367,928 366,344 99.6% 12,120 378,464 102.9% 2,551 .7%
1983 420,897 4l4,34l 98.4% l,379 415 , 720 98.8% 7,8l0 1.9%
1984 448,860 443,070 98.7% 10,977 454,047 101.l% 9,497 2.1%
1985 486,515 481,502 98.9% 2,629 484,l31 99.5% 14,165 2.9%
1986 545,93l 532,537 97.5% 4,193 536,730 98.3% 19,523 3.6%
1987 610,784 592,29l 97.0% 7,083 599,374 100.3% 29,594 4.8%
59
CITY OF SCHERTZ, TEXAS
ASSESSED AND ESTIMATED ACTUAL VALUE OF TAXABLE PROPERTY
LAST TEN FISCAL YEARS
TABLE 4
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Fiscal Estimated
Levy Year Actual Assessment Assessed Tax
Year Ended Values Percentalie Valuations Rate Tax Levy
1978 9-30-78 45,974,450 50% 22,987,225 1.00 229,872
1979 9-30-79 48,837,400 50% 24,418,700 1.00 244,187
1980 9-30-80 5l,025,000 50% 25,512,500 1.00 255,125
1981 9-30-81 54,316,242 65% 35,305,557 1.00 353,056
1982 9-30-82 57,488,887 100% 57,488,887 .64 367,928
1983 9-30-83 95,658,409 100% 95,658,409 .44 420,897
1984 9-30-84 111,263,473 100% 106,871,357 .42 448,860
1985 9-30-85 l22,4l4,IOl lOO% 11l,586,009 .436 481,5l5
1986 9-30-86 132,968,586 lOO% 125,018,837 .436 545,931
1987 9-30-87 153,457,116 100% 147,961,601 .4128 610,784
60
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS TABLE 5
PROPERTY TAX RATES - ALL OVERLAPPING GOVERNMENTS
LAST TEN FISCAL YEARS
County
Year*** City School County State Road
50% 50% 25% 25% 25%
Assessment Assessment Assessment Assessment Assessment
Rate* Rate* Rate Rate Rate
1978 1.00 1.30 .80 .10 .30
1979 1.00 1.30 .80 .lO .30
1980 1.00 1.37 .80 .30 .30
1981 1.00 1.37 .80 .30
1982 .64** .8l** .28** .06**
1983 .44** .78** .25** 0
1984 .42** .74** .24** 0 .04**
1985 .440** .97** .2457** 0 .04**
1986 .436** 1.11 .3450 0 .0425
1987 .4128** 1.14 .3875 0 .04
* All rates shown are per $100 assessed valuation.
** All taxing authorities adopted a 100% assessment for 1982 and after.
*** Year shown is the fiscal year of collection.
previous .calendar year.
Taxes were levied
the
6l
CITY OF SCHERTZ, TEXAS TABLE 6
RATIO OF NET GENERAL BONDED DEBT TO ASSESSED VALUE
AND NET GENERAL BONDED DEBT PER CAPITA
LAST TEN FISCAL YEARS
Ratio
Of Net General
Fiscal Bonded Debt Bonded
Year Estimated Assessed Net General To Assessed Debt Per
Ended Population Value Bonded Debt Value Capita
9-30-78 6,620 22,987,225 563,023 2.45% 85.05
9-30-79 6,874 24,4l8,700 543,366 2.23% 79.04
9-30-80 7,260 25,5l2,500 522,925 2.05% 72.03
9-30-8l 7,672 35,305,557 649,975 1.84% 84.94
9-30-82 9,l80 57,488,887 508,655 .88% 55.41
9-30-83 9,250 95,658,409 493,450 .52% 53.35
9-30-84 9,600 106,871,357 423,009 .40% 44.06
9-30-85 11,400 111,586,009 345,035 .31% 30.27
9-30-86 l2,500 125,213,487 324,351 .26% 25.92
9-30-87 l2,500 147,96l,60l 757,798 .5l% 60.62
62
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
OVERLAPPING DEBT
FOR THE YEAR ENDED SEPTEMBER 30,
Taxing Body
Net Debt
Amount As Of
* Cibolo Creek Municipal
Authority
-0- l2-31-85
* Comal County
10,655,247 Ol-01-87
* Comal County Flood
Control Bonds
217,479 12-31-85
* Comal Independent School
District
25,698,767 8-31-86
3,000,000 12-0l-86
* Guadalupe County
* Schertz-Cibolo-Universal
City Independent School
District 3,707,529
8-31-86
Total Net Overlapping Debt
City of Schertz
757,798
9-30-87
Total Direct and Overlap-
ping debt
(l.72% of Assessed Value-
$203.35 Per Capita)
TABLE 7
1987
Percent Amount
Over- Over-
Lapping LappinE
45.000% -0-
.59% 62,866
.59% 1,283
.73% 187,601
8.85% 265,500
34.17%
1,266,863
l,784,113
lOO.OO%
757,798
$ 2,541,911
* Source of Data - Texas Municipal Reports, City of Schertz, Sept. 15,
1986 compiled and published by Municipal Advisory Council of Texas.
63
CITY OF SCHERTZ, TEXAS
LEGAL DEBT MARGIN
FOR THE YEAR ENDED SEPTEMBER 30, 1987
TABLE 8
I
I
I
September 30, 1986 Texas municipalities are not bound by any direct
constitutional or statutory maximums as to the amount of general obligation
I
I
I
I
bonds which may be issued; however, all local bonds must be submitted to and
approved by the State Attorney General. It is the established practice of the
Attorney General not to approve a prospective bond issue if it will result in
the levy of a tax for bonded debt of over $l.OO for cities under 5,000
I
I
population or $l.50 for cities over 5,000 population.
I
I
I
I
I
I
I
I
I
64
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
Fiscal
Year
EndinE
9-30-87
9-30-88
9-30-89
9-30-90
9-30-91
9-30-92
9-30-93
9-30-94
9-30-95
9-30-96
9-30-97
9-30-98
9-30-99
9-30-00
9-30-0l
9-30-02
Totals
CITY OF SCHERTZ, TEXAS
GENERAL BONDED DEBT
SUMMARY OF DEBT SERVICE REQUIREMENTS
FISCAL YEARS 1987-2002
Outstanding
Cash Requirements Principal
Principal Interest Total Balance
$ 888,000
$ 24,000 $ 72 , 900 $ 96,900 864,000
39,000 54,758 93,758 825,000
45,000 52,049 97,049 780,000
45,000 49,067 94,067 735,000
46,000 46,084 92,084 689,000
57,000 42,832 99,832 632,000
58,000 38,976 96,976 574,000
60,000 35,l28 95,128 514,000
67,000 3l,115 98,115 447,000
67,000 27,049 94,049 380,000
73,000 22,726 95,726 307,000
78,000 17,975 95,975 229,000
79,000 13,082 92,082 150,000
85,000 8,211 93,211 65,000
65000 2112 67112 0
------...---- ------------ -----------
$ 888,000 $ 5l4,064 $ 1,402,064
65
TABLE 8-1
Fiscal
Year
Ending
9-30-87
9-30-88
9-30-89
9-30-90
9-30-91
9-30-92
9-30-93
9-30-94
9-30-95
9-30-96
9-30-97
9-30-98
9-30-99
9-30-00
9-30-01
Totals
CITY OF SCHERTZ, TEXAS
UTILITY SYSTEM JUNIOR LIEN REVENUE
CERTIFICATES OF OBLIGATION
DEBT SERVICE REQUIREMENTS
FISCAL YEARS 1987-2001
Cash Reauirements
Principal Interest
Total
Outstanding
Principal
Balance
$ 1,260,000
$ 40,000 $ 115,257 $ 155,257 1,220,000
40,000 11l,258 151,258 l,l80,000
50,000 107,007 157,007 1,130,000
55,000 102,008 157,008 1,075,000
65,000 97,075 162,075 1,010,000
65,000 91,605 156,605 945,000
70,000 86,045 156,045 875,000
75,000 79,925 154,925 800,000
90,000 72 , 977 162,977 710,000
105,000 64,560 l69,560 605,000
120,000 54, 910 174,910 485,000
105,000 44,810 149,810 380,000
160,000 35,150 195,150 220,000
220,000 20,350 240,350 0
----------- ------------ -----------
$ l,260,OOO $ l,082,937 $ 2.342,937
66
TABLE 8-2
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS TABLE 8-3
UTILITY SYSTEM REVENUE BONDS
SUMMARY OF DEBT SERVICE REQUIREMENTS
FISCALS YEAR 1987 - 2007
Fiscal Outstanding
Year Cash Reauirements Principal
Ending Principal Interest Total Balance
9-30-87 $ 2,110,000
9-30-88 $ 65,000 $ l56,197 $ 22l,l97 2,045,000
9-30-89 70,000 151,285 22l,285 1,975,000
9-30-90 75,000 146,023 221,023 l,900,000
9-30-9l 80,000 140,472 220,472 1,820,000
9-30-92 80,000 134,473 2l4,473 l,740,000
9-30-93 90,000 l28,672 218,672 1,650,000
9-30-94 95,000 l22,105 217,l05 1,555,000
9-30-95 lOO,OOO 115,028 2l5,028 1,455,000
9-30-96 lOO,OOO 107,587 207,587 1,355,000
9-30-97 l05,000 99,938 204,938 l,250,000
9-30-98 105,000 91,832 196,832 1,145,000
9-30-99 135,000 83,798 2l8,798 1,OlO,000
9-30-00 lOO,OOO 73,475 l73,475 910,000
9-30-01 60,000 65,000 l25,000 850,000
9-30-02 150,000 60,525 210,525 700,000
9-30-03 150,000 48,050 198,050 550,000
9-30-04 150,000 37,763 187,763 400,000
9-30-05 150,000 27,475 177,475 250,000
9-30-06 125,000 17,125 142,125 125,000
9-30-07 l25,000 8,563 133,563 0
------------ ------------ -----------
Totals $ 2,110,000 $ 1,8l5,386 $ 3,925,386
Average annual requirement
$ 196,269
67
-0
-.j
-.j
0
VI
0
0\ -0
CO
....
CO
CO
0
VI
0
-
-
-
-
-
-
-
>-,)
o
rt
II>
....
Ol
~~~~~~~~~~~~~~~~~~~~~~~~
I I I I f I I I I I I I I I I I I I I I I I I I
WWWWWWWWWWWWWWWWWWWWWWWW
000000000000000000000000
I I I I I I I I I I I I I I I I I I I I I I I I
....OOOOOOOOOO~~~~~~~~~~COCOCO
O~CO-.jO\Vl~W~""O~CO-.jO\VI~W~""O~CO-.j
-0
-0
....
....
....
o
o
o
-.j-.j-.j-.jO\O\O\O\VlVlV1V1~~~~~~WWWWW
~ ~ ~ _ . _ _ _ _ _ _ _ _ _ _ _ . _ w _ _ w .
00000000000000000000000
00000000000000000000000
00000000000000000000000
<J>
............~~~~WWWW~~~~~~VlVlVlVl
- - - . . . - - - - - - - - - - - - - - -
W-.jO~-.jOWO\CO""WO\COO~~O\CO~""~~VI
VlOVlOOOOOVlOVlOOOOOOOVlOVlOVl
00000000000000000000000
<J>
-.j-.j COCO-.j CO CO CO-.j COCO CO-.j CO CO CO CO CO-.j CO CO CO CO
- - - - - - - - - - - - - - - - - - - - - - -
W-.jO~-.jOWO\CO""WO\COO~~O\CO~""~~Vl
VlOVlOOOOOVlOVlOOOOOOOVlOVlOVl
00000000000000000000000
................
....~~W~~VlVlO\O\~~COCOCO~~~OOO....
-.j~....CO~Oo\~-.j~-.j~O\O~CO~O\~~VlCO....
- - - - - - - - - - - - - - - - - - - - - - -
00000000000000000000000
00000000000000000000000
000000000000000000000000
-
-
-
-
-
-
-
f><":l
::l (I) .....
Poll>Ol
.....1iC'l
::l ll>
....
1:1
~
.....
ll>
C'l
ll>
Ol
::r
I;<l
[
::l
rt
Ol
~
<J>
ill> ::?~
.....rt
ll> ::l Ol
C'l rt
....ll>
'tl ::l
ll> Po
........
~
-
-
tIl
":l~~
H t'"
tt10H
C'l":lC'l
:>
t"'t::l":l
~tH:;
>-,)H
t'"
tIlH
tt1~~
....<:
\OHt'"
COC'lO
-.j~!l;
'~=
~.o'
odd
....H.
ol;<lt::l
&1'
~
tIl
-
C'l
H
~
o
":l
ttI
C'l
=
~
N
o-'l
~
ttI
~
-
-
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS TABLE 9
RATIO OF ANNUAL DEBT SERVICE EXPENDITURES
FOR GENERAL BONDED DEBT TO TOTAL GENERAL EXPENDITURES
LAST TEN FISCAL YEARS
Ratio
Of Debt
Debt Service Service To
Fiscal Total General
Year Principal Interest Debt Expenditures* Expenditures
1978 l8,000 33,717 51,717 508,305 10.2%
1979 17,000 32,827 49,827 671,677 7.4%
1980 l8,000 3l,953 49,953 717,65l 7.0%
1981 l8,000 31,035 49,035 775,445 6.3%
1982 l8,000 30,131 48,131 885,568 5.4%
1983 19,000 29,227 48,227 913,082 5.3%
1984 20,000 28,577 48,577 1,099,520 4.4%
1985 21,000 27,878 48,878 1,237,610 3.9%
1986 2l,000 26,233 47,233 1,466,855 3.2%
1987 22,000 25,169 47,169 1,766,347 2.7%
* Includes General, Special Revenue, and Debt Service Funds.
69
CITY OF SCHERTZ, TEXAS
WATER AND SEWER FUND
SCHEDULE OF TOTAL OPERATING EXPENSES BEFORE DEPRECIATION
AND DEBT SERVICE REQUIREMENTS
LAST TEN FISCAL YEARS
Total
Operating Operating
Expenses Income
Fiscal Operating Before Before
Year Revenues Deureciation Deureciation
1978 436,557 299,119 137,438
1979 460,283 331,060 129,223
1980 570,084 369,545 200,539
1981 579,530 413,616 165,914
1982 710,818 475,356 235,462
1983 793,279 493,880 299,399
1984 997,997 607,424 390,573
1985 1,172,755 815,805 356,950
1986 1,309,269 849,677 459,592
1987 1,339,061 888,916 450,145
70
TABLE 10-1
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
TABLE 10-1
Debt Service Requirements Number of Customers
Principal Interest Total Coverage Water Sewer
20,000 57,405 77 ,405 1. 78: 1 2,134 2,046
20,000 56,480 76,480 1. 68 : 1 2,146 2,041
25,000 55,417 80,417 2.50:1 2,203 2,201
25,000 81,098 106,098 1. 56: 1 2,207 2,060
35,000 99,073 134,073 1. 76: 1 2,214 2,151
40,000 111,360 151,360 1. 98 : 1 2,246 2,055
70,000 274,977 344,977 1.13:1 2,785 2,133
75,000 224,036 299,036 1.19:1 2,877 2,231
83,000 217,379 300,379 1. 53 : 1 3,208 2,333
105,000 271,454 376,454 1. 20 : 1 3,498 2,639
71
CITY OF SCHERTZ, TEXAS
WATERWORKS AND SEWER SYSTEM FUND
REQUIREMENTS AND RESTRICTED FUNDS
FOR THE YEAR ENDED SEPTEMBER 30, 1987
Armua1
Principal/
Semi-Annual
Interest
Interest and Sinking Fund Requirement
Utility System Revenue Bonds,
Series 1968:
Principal Payment, Due 9-1-88
Interest Payment, Due 3-1-88
$
25,000
7,188
Utility System Revenue Bonds,
Series 1973:
Principal Payment, Due 9-1-88
Interest Payment, Due 3-1-88
4,884
Utility System Revenue Bonds,
Series 1975:
Principal Payment, Due 9-1-88
Interest Payment, Due 3-1-88
5,000
10,225
Utility System Revenue Bonds,
Series 1981:
Principal Payment, Due 9-1-88
Interest Payment, Due 3-1-88
20,000
19,115
Utility System Revenue Bonds,
Series 1987:
Principal Payment, Due 9-1-88
Interest Payment, Due 3-1-88
15,000
36,688
TOTAL REQUIREMENTS
Investment in Certificate of Deposit in Schertz
Bank 30 Day Maturity
Funds Available Over Requirement
72
Basis
1/12th
1/6th
1/6th
1/6th
1/12th
1/6th
1/12th
1/6th
1/12th
1/6th
TABLE 10-2
$
2,083
1,198
814
417
1,704
1,667
3,186
1,250
6,115
18,434
60,710
$
42,276
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
TABLE 10-2
WATERWORKS AND SEWER SYSTEM FUND
REVENUE BOND REQUIREMENTS AND RESTRICTED FUNDS
FOR THE YEAR ENDED SEPTEMBER 30, 1987
Reserve Fund Requirement
1 1/2 Times Average Annual Principal and Interest
Requirement $196,269
$ 294,404
Investments (At Cost) Held By First International
Bank of San Antonio
AIM Treasury Fund
Principal Cash
200,647
3,699
204,346
Funds Available Over (Under) Requirement
$ (90,058)
REVENUE BOND COVERAGE
Deduct
Year Operating Add Solid Waste "Net Bonded Debt Coverage
Ended Income Depreciation Revenue Revenues" Requirement Ratio
1986 $
1987 155,616 294,529 41,229 408,916 408,916 2.08
73
Policy:
Coverage:
Term:
Policy:
Coverage:
Term:
Policy:
Coverage:
Term:
Policy:
Coverage:
Term:
Policy:
Coverage:
Term:
Policy:
Coverage:
Term:
Policy:
Coverage:
Term:
Policy:
Coverage:
Term:
Policy:
Coverage:
Term:
Policy:
Coverage:
Term:
CITY OF SCHERTZ, TEXAS
INSURANCE AND BOND COVERAGE
FOR THE YEAR ENDED SEPTEMBER 30, 1987
TX Municipal League, Policy Nr. 420-TML-1043700-87
Comprehensive Automobile liability, $500/1,000,000 Bodily
$1,000,000 Property Damage, Comprehensive, Fire, and Theft
listed
October 1, 1987 to October 1, 1988
Texas Municipal League Policy No. A043700
Workmen's Compensation
October 1, 1987 to October 1, 1988
TABLE 11
I
I
Injury,
Coverage
I
I
I
I
I
The Niagara Fire Ins. Co. of N.Y., Policy Nr. M-F9-66-87-19
Fire and Extended Coverage, $2,171,000, and 80% Co-insurance general
liability $500,000 combined single unit, where applicable, on City
Hall, Fire Station, and Police Station (including contents), Metal
Buildings, Lift Stations, Water Tanks, Recreational Building, Council
Chambers, Comfort Station, etc.
December 3, 1987 to December 3, 1988.
Fidelity and Deposit Company of Maryland, Bond No. 9214888
Public Official Bond, City Manager and Treasurer, $25,000
September 10, 1979 - Indefinitely
Fidelity and Deposit Company of Maryland, Bond No. 9407227
Public Official Bond, Tax Assessor-Collector, $25,000
April 10, 1977 - Indefinitely
I
I
I
I
I
I
I
Fidelity and Deposit Company of Maryland, Bond No. 8943258
Public Official Bond, City Secretary/Assistant Treasurer/Assistant
City Manager $10,000
December 18, 1976 - Indefinitely
Fidelity and Deposit Company of Maryland, Bond No. 9991578-T
Public Official, Water & Water Dept $25,000
April l5, 1986 - Indefinitely
Ohio Casualty Ins. Co. Policy Nr. 58709l
Volunteer Firemen Accident-$25,000 loss of life, sight, speech
hearing
October 29, 1987 - October 29, 1988
Continental Ins. Policy Nr. 486334
Comprehensive Fire Trucks & Ambulances
January 20, 1987 to January 20, 1988
Fidelity & Deposit Co. of Maryland, Bond No. 985-6224-T
Public Official, Finance Officer $50,000
March 1, 1985 - Indefinitely
74
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS TABLE 12
DEMOGRAPHIC STATISTICS
LAST TEN FISCAL YEARS
Level In
Years Of
Per Formal School
Fiscal Capita Median Education Enrollment Unemployment
Year Population Income (2) Age (3) ill ill Rate (3)
1978 6,620 6,511 42 12 1,109 6.3
1979 6,874 41 12 1,118 5.7
1980 7,260 6,714 41 l2 1,182 6.6
1981 7,672 40 12 1,193 5.7
1982 9,180 est. 7,145 40 12 2,047 7.0
1983 9,250 est. 40 12 2,092 6.7
1984 9,600 est. 7,240 40 12 2,049 5.7
1985 11 , 400 est. 40 12 2,064 5.4
1986 12,500 est. 7,400 41 12 2,154 6.3
1987 12,500 est. 7,400 41 12 2,306 5.7
Sources:
(1) 1970 and 1980 Bureau of the Census
Department of Planning, University of Texas
(2) Department of Economics, University of Texas
U.S. Department of Labor (Information not available for odd years)
(3) Texas Employment Commission
(4) Schertz-Cibo1o-Universa1 City Independent School District
75
CITY OF SCHERTZ, TEXAS
PROPERTY VALUE, CONSTRUCTION, AND BANK DEPOSITS
LAST TEN FISCAL YEARS
Fiscal
Year
Commercial
Construction
Number
Of Units Value
Residential
Construction
Number
Of Units Value
1978 6 658,025 26 1,157,700
1979 25 536,023 19 1,318,651
1980 13 338,730 15 212,845
1981 18 542,300 36 448,287
1982 28 788,6l6 13 785,000
1983 56 1,283,600 24 1,655,000
1984 37 6,213,816 330 8,004,622
1985 64 2,779,063 132 7,918,922
1986 15 1,600,154 229 14,590,154
1987 16 1,056,074 132 7,834,243
76
TABLE 13
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
TABLE 13
Total
Bank Deposits
Pronertv Va1ue*
Residential
Commercial
Nontaxable
lO,805,000 6,410,141 43,845,145 3,410,500
11,934,000 6,633,643 46,019,088 3,485,200
14,642,000 7,061,640 48,148,602 3,505,100
19,047,000 11,139,943 48,800,602 3,710,200
26,664,000 12,050,973 49,708,602 3,770,200
29,743,000 13,249,751 50,960,220 4,120,300
31,842,000 14,285,782 91,817,653 10,457,515
34,089,000 15,006,912 91,817,653 10,828,092
40,357,000 15,205,126 95,683.981 10,828,092
56,924,876 15,348,150 102,787,953 10,828,092
Sources: City Building Inspection Records
City Tax Records
S. W. T. Research Center
* Estimated Actual Value
77
Taxnayer
Monotech Corporation
Riedels, Inc.
Garden Ridge Pottery
Houston Chemical
Val Verde Apartments
Negley Paints
Southwest Precast
G.V.E.C.
Southwestern Bell
CITY OF SCHERTZ, TEXAS
1985
Assessed
Valuation
I
TABLE 14 I
I
Percentage
of Total I
Assessed
Valuation
.050% I
.021%
.017% I
.011% I
.009%
.008% I
.006%
.006% I
.006% I
--------
.148%
I
I
I
I
I
I
I
I
I
PRINCIPAL TAXPAYERS
FOR THE YEAR ENDED SEPTEMBER 30, 1987
TYPe of Business
Steel Fabrication
Commercial
Wholesale and Retail
Wood Treatment
Apartments
Paint Manufacture
Concrete trusses, etc.
Electric utility
Telephone utility
78
7,629,669
3,237,607
2,611,870
1,696,312
1,376,245
1,198,900
960,346
937,671
922,110
$22,700,617
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
TABLE 15
MISCELLANEOUS STATISTICS
FOR THE YEAR ENDED SEPTEMBER 30, 1987
Date of Incorporation:
December 1958
April 1974
Amended April 19
Council-Manager
22.38
21. 32
13.1425
12.8196
10.53
9.90
8.99
0.80
0.80
85 miles
17 miles
11. 6 miles
3.8 miles
1 . 2 miles
35 miles
Value
of Buildings
$ 9,725,569
16,349,884
10,697,985
14,218,408
5,411,680
2,470,000
1,444,500
725,977
2,057,214
2,164,972
3,385,380
1
10
40
Date First Charter Adopted:
Date Present Charter Adopted:
Form of Government:
Area - Square Miles:
1987
1986
1985
1984
1983
1980
1970
1960
1950
Miles of Streets and Alleys:
Streets, paved
Streets, unpaved
Alleys
Sidewalks
Miles of Sewer:
Storm
Sanitary
Building Permits:
Permits Issued
1987
1986
1985
1984
1983
1982
1981
1980
1979
1978
1977
430
270
378
367
400
375
186
181
173
204
205
Fire Protection:
Number of stations
Number of employees
Number of volunteers
79
CITY OF SCHERTZ, TEXAS
MISCELLANEOUS STATISTICS
YEAR ENDED SEPTEMBER 30, 1987
(CONTINUED)
Police Protection:
Number of employees
Number of law violations
Traffic
Other
4,400
1,151
Jail
Vehicular patrol units
Recreation:
Parks
Number of acres of parks
Playgrounds
Swimming pools
Other recreational facilities:
Baseball fields
Large pavilion
Small pavilion
Picnic tables:
Covered
Uncovered
Rest rooms:
Male
Female
Concession stands
Community center
4
10,000 sq. ft. covered
600 sq. ft. covered
Source: City of Schertz records
Education:
Number of schools
Samuel Clemens High School
Administrative personnel
Teachers
Students
Average daily attendance
Corbett Junior High School
Administrative personnel
Teachers
Students
Average daily attendance
Schertz Elementary School
Administrative personnel
Teachers
Students
Average daily attendance
Source: Schertz-Cibo1o-Universa1 City Independent School District
80
I
I
18
I
I
352
14
I
I
I
I
4
64
1
1
I
10
28
I
6
6
1
1
I
3
I
I
I
I
9
79
1174
1113
3
40
582
560
I
2
31
550
484
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
CITY OF SCHERTZ, TEXAS
TABLE 15
MISCELLANEOUS STATISTICS
FOR THE YEAR ENDED SEPTEMBER 30,
(CONTINUED)
1987
City Employees:
30 September 1987
76
Elections:
Number of registered voters
Number of votes in:
Last municipal election
Percentage of registered voters voting in:
Last municipal election
3,920
768
19%
Source: Municipal election records
Population:
Census population count
1980
1970
1960
1950
1940
1930
Age distribution:
7,260
4,061
2,281
1,200
600
350
1970 1960 1950
10.3 12.2 12.8
24.0 26.3 26.7
18.0 19.1 20.9
27.4 25.0 25.3
11.6 9.3 7.1
8.6 8.1 7.2
1980
Under 5
5-14
15-24
25-44
45-60
60 +
8.4
21.4
17.3
29.1
15.3
9.5
Source: 1980 Census and Economic Research Associates
Current population estimate
12,500
Source: Texas Industrial Commission
81
CITY OF SCHERTZ, TEXAS
TABLE 15
MISCELLANEOUS STATISTICS
FOR THE YEAR ENDED SEPTEMBER 30, 1987
(CONTINUED)
Retail Sales:
1986
1985
1984
1983
1982
1981
1980
1979
1978
1977
30,510,100
23,867,300
20,742,300
18,635,100
16,057,717
13,295,400
12,622,600
10,790,600
9,368,000
7,378,700
Source: State Comptroller
Per Capita Income:
1987
1986
1985
1984
$ 7,400
7,400
7,240
7,240
Source: U.S. Bureau of Economic Analysis
Texas Employment Commission
82
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I
I