Loading...
HomeMy WebLinkAboutItem 8.4 Final FY98-99 & Audit 4 r" I CITY CLERK File # rn[ZIZ2J-8fQ] AGENDA STATEMENT CITY COUNCIL MEETING DATE: (December 21, 1999) SUBJECT: Final Financial Report For Fiscal Year 1998/1999 and Annual Audit Report :x:: r-f'\ Report Prepared by: Fred Marsh, Finance Manager -- .'\; EXHIBITS ATTACHED: 1. Comprehensive Annual Financial Report, dated June 30, 1999 2. Financial Report (Final), June 30, 1999 3. Independent Auditor's Report On Compliance With The Proposition 111 1998-99 Appropriations Limit Increment. RECOMMENDATION: 1. 2. ~ Receive the Reports Confirm the designations of Fund Balances for the Non Residential Recycling Program and Authorized Expenditures for Fiscal Year 1998-99. Designate $2.4 million of the General Fund fund balance as part of the budget for Fiscal. Year 2000-2001 to cover the unfunded liability for Post Retirement Medical Cost.s See Staff Report. 3. ("FINANCIAL STATEMENT: DESCRIPTION: . The City of Dublin has compiled and published its Comprehensive .Annual Financial Report.(CAFR) (Attachmentl),for the fiscal year ending June 30, 1999~ This report includes financial statements prepared by Vavrinek, Trine, Day, & Co., (VTD)the independent auditors selected by the City Council. This is the fourth year in which the firm conducted the audit. The financial section of the report incllldes.an unqlla1ified opinion issued by VTD. The Audit was also reviewed onDecember 14, 1999 by the City Council Finance and Audit subcommittee. The Committee met with the auditors to review the information and discuss the report. Overall, the Auditors noted no matters involving the City'sintemal controls over its financial reporting and operations that the auditors considered to be a material wealmess reqUiring disclosure in a management letter. The transmittal letter, contained on pages viii - xiv of the CAFR, provides a good overview of the financial activities oLthe City. This letter focuses on significant trends as well as major changes associated with the General Fund. The General Fund represents the largest portion of the City's revenues and expenditures and.therefore is. of primary importance in. evaluating the City's fiscal condition. The statistical section in the CAFR (Attachment 2 pages 95,.108) includes graphs of relevant historical data~ The visual presentation can be helpful in identifying trends and/or the timing of key changes which have impacted .the City's financial condition. (' , ---------------...-------------------------------...------.......-------------- COPIES TO: Kevin Pulliam, VTD..M- .. . Gail Smith, VTD . ITEM NO.. . G:\AUDIl\98-99 audit\cafr\agenda statement for final audit reportdoc In the past, the City has submitted its Annual Financial Report to State and National organizations, whK:h review it for conformance with desired reporting standards. For the past nine years the City has received awards from both organizations, and the format of this report was intended to continue to qualify the City for this recognition. The organizations typically do not announce the results until later in the year. " ...,,/' The monthly in-house Financial Report for June 30, 1999 is submitted in its "final" form. (Attachment 2) This report reflects various adjustments required in closing the books and preparing the CAFR. All budgetary modifications have been previously adopted by the City Council. The remainder of this report will highlight areas of significance in the current report. Detailed Presentation of General Fund Budget To Actual Variances Pages 47 and 48 of Attachment 2 contain a line by line comparison 'Of the adopted budget estimate of General Fund Revenues for Fiscal Year 1998-99 and the final year end result. Comparative information is also provided for General Fund Expenditures by activity on pages 49 and 50. This detail supports the general highlights discussed below regarding the year end results in the General Fund. The total change in the General Fund Balance was a decrease of$9.1 million. Excluding the one time transfer of$12.1 for the early retirement of the 1993 COPS, the net operating change in the General Fund Balance was an increase of$3.0 million. A combination of increased revenues, expenditure savings and delays in capital projects affected the change in Fund Balance. Significant General Fund Revenue Variances In Fiscal Year 1998/99 the actual revenues in the General Fund exceeded the budget estimate by $1.2 million. This difference represents approximately 5% of the total General Fund Revenues. The following revenues contributed significantly to the final outcome: ."""" Sales Taxes ($487.000 over budgeted proiection) As reported throughout the fiscal year the local economy had another positive surge in retail sales. The increase was affected primarily by continued strong sales in the Autos and Transportation, and General Consumer Categories. The City also benefited from the fact that businesses that had plans to relocate did not leave the City during the sales tax reporting period. The City also continued to benefit from a change in the law two years ago which allocates sales tax on auto leases to the City where the lease/purchase transaction takes place (typically the auto dealer). Building Permit Revenue ($576.000 over budgeted projection) The activity related to both residential and commercial construction occurred at a faster pace than was originally anticipated due to anticipated increases in development fees and implementation of the building code. Due to the nature of this revenue the expenses for inspections may actually be recognized in a future year. For example, a Building Permit may be obtained in Mayor June and the majority of inspection cost is incurred in the following year. Investment income and interest ($141.000 over budgeted projection) Interest earnings were higher than originally anticipated as additional funds were made available for investment due to the expenditure savings and delays in Capital Projects noted below, and higher than anticipated revenues in the General Fund, as discussed in this section of the report. ..,,; Zoning and Subdivision Fees ($231.000 over budgeted proiection) This revenue category exceeded its adopted budget due to additional fees generated from the increase in both residential and commercial' construction noted above. These fees typically. have -= ~-- '*' corresponding expenditures related to Staff and/or consultant time associated with project processing, and resulted in additional expenditures for the Planning division, as noted below. r' \, Significant General Fund Operating Expenditure Variances The City's General Fund "operating expenses" were approximately $906,000 less than the amount budgeted. The following breakdown examines major areas of savings by Program: General Government {$247.000 under budgeted proiection) This category includes the lease payment for the Civic Center Debt Service, which is budgeted at the gross amount. The acttialamount paid was $105,000 less than the budget due to the difference being paid from interest earnings on reserve fund investments. The other operating divisions in this category had cumulative expenditure savings of $142,000. Factors which contributed to these savings included a.) staffing vacancies for part of the Fiscal Year in the Administrative Services division; b.) Lower than anticipated expenditures for insurance claims; and c) approximately $37,000 budgeted as part of the contingent reserve which was not expended. Public Safety ($183.000 under budgeted proiection) The budget savings in this . category resulted primarily from reduced expenditures for animal control shelter and field services as a lower than anticipated percentage of the animal shelter total costs (based upon each member's usage) was allocated to the City of Dublin. Fire service costs were lower due to lower: than expected worker compensation costs related to retired employees ( formerly employed by DRF A. , Highways and Streets ($35.000 under budgetedproiection) The budget savings in this category resulted primarily from some of the street repair and striping expenditure:s being funded > from additional SB300Special Revenues instead of in the City's General Fund, where these expenditures were originally budgeted to take place. Community Development ($90.000 under budgeted projection) The budget savings in this category resulted primarily from staffing vacancies. These savings were offset somewhat by higher than expected consultant costs in Planning for the review of new development projects. The City was reimbursed for these costs through deposits collected from developers, which resulted in the positive budget variance for zoning and subdivision revenues noted above. Culture and Leisure ($348.000 under budgeted proiection) The budget savings in this category resulted primarily from a) lower than expected utility and contract maintenance expenditures in, the Park Maintenance activity b) lower than expected participation in the Adult and Youth Sports Programs, thereby reducing the expenditures made for contract instructors and/or excursions for these programs c) due toa delay in the implementation of the ,reorganization of the Parks and. Community Services department and d) a delay in the opening of the Dublin Swim Center due to the renovation. rieneral Fund Capital Project Expenditure Variances The City also expended less in Capital.Expenditures than originally budgeted. This variance primarily represents a timing difference in the completion of these projects, several of which have been carried over to Fiscal Year 1999/2000. In addition, expenditures for the Dougherty Hills Park Slope Repair and the -~- Eastern Dublin Financing Study, both completed during Fiscal Year 1998/99, were lower than anticipated. The following projects were carried over for completion into Fiscal Year 1999/2000: ProjectName Fire Apparatus Automated Document Storage and Retrieval System Civic Center Renovation / Exp~sion Project Central Data Processing System Upgrade Development Services Data Processing Communications System Upgrade Dublin Elementary Sports Field Dublin Swim Center Deck Replacement Total General Fund Capital Projects Budget Carryovers for Fiscal Year 1998/99 $683,000 $39,000 , .." $236,000 $38,000 $27,000 $l5,000 $18,000 $42,000 $1,098,000 DESIGNATIONS OF FUND BALANCES A. For Non Residential Recycling Program - Measure D Recycling Fund During the last three Fiscal Years the City received $99,265 in Mitigation Funds from County Waste Management Authority (WMA), which were to be utilized solely for Non-Residential Recycling. All of these funds have been accounted for in the Measure D Recycling Fund. As of June 30, 1999 the City had ...,; only used $19,378 on the Pilot Small Generator Commercial Recycling Program. Therefore, the City will have $79,887 available to carryover to Fiscal Year 1999/2000. These funds have been shown as a separate restricted fund balance, in order to segregate them from the remainder of the Measure D Funds, as they will be a source of funding for an enhanced commercial recycling program. The City Council is requested to confirm this designation, as part of accepting this report. B. For Authorized Expenditures This designation is established to allow the City Council to carryover any unused funds as of June 30, 1999 to fund future year operations and projects for each those funds with a positive fund balance. The City Council is requested to confIrm this designation, as part of accepting this report for all funds with a positive fund balance as of June 30, 1999. C. Post RetirementMedical Costs The City recently had an actuarial valuation performed by William M. Mercer Inc. on the future costs of providing medical benefits to CounciImembers and employees eligible for retirement under CalPERS. The actuarial.valuation also covered the City's portion of medical costs for the sixteen retired employees who .were previously employed by the Dougherty Regional Fire Authority (DRP A). Based upon this study, the consultant determined that the City had a current unfunded liability for these post retirement , , J medical costs of approximately $2.4 million. This amount did not assume any adjustments for future ...., inflation in medical, costs or any increases in the City's current staffing level. The Audit Committee -1-- discussed this issue and recommended that Council designate $2.4 million of the General Fund fund balance as part of the budget for Fiscal Year 2000-2001 to cover this unfunded liability. ~ANAGEMENTLETTER . , ",'he Auditors explained to Staff and the Subcommittee that they noted no material wealmesses in the City's financial reporting and operating system during the performance of their audit for Fiscal Year 1999- 2000. Thus no managementIetter was issued by the auditors for Fiscal Year 1998-99. COMPLIANCE REPORT FOR THE 1998/99 APPROPRIATIONS LIMIT CALCULATION As part of their engagement the Auditors are required to review compliance with laws related to the calculation of the annual Appropriations Limit. As required by State Law, the City Council annually adopts an Appropriations Limit in conjunction with the annual Budget. Attachment 3 contains the Auditor's report related to this item. Although this does not represent a formal audit, the report states that there was nothing found to indicate that the calculation was not in conformance with the required laws. CONCLUSION Staff recommends that the City Council receive and file the reports and confirm the designation of Fund Balances as presented. In the event that there are specific questions the members of the City Council Subcommittee or Staff will be available. r \ r -:-5-- ~. ,.,.,.-.... CITY OF DUBLIN'S FINANCIAL STATEMENTS FOR THE FISCAL YEAR ENDED 6/30/1999 (Final Report) Prepared by The Finance Department December 14, 1999 ~' / ~ J:3 ATTACHMENT 2 ;< ~. /:'3 . CITY OF DUBLIN BALANCE SHEET FOR THE PERIOD ENDING 30Jun1999 ......" GENERAL SPECIAL SPECIAL CAP IT AL TRUST/ TOTALS REVENUE REVENUE ASSESSMENT IMPROVEMENT AGENCY ---MEMORANDUM ONLY--- FUNDS FUNDS FUNDS FUND FUND CURRENT ASSETS CASH (15.503.698) 1. 785.636 331.846 14.123.343 191. 483 928.610 CASH WITH FISCAL AGENT 149.763 149.763 UNA~ORTIZED BOND DISCOUNT INVESTMENTS AT COST 34.556.969 34.556.969 ~ECEIVABLES: TAXES ACCOUNTS (NE 1. 262.992 133.870 2.287 440 1. 399 . 589 INTEREST 502.727 502.727 ASSESSMENTS JUE FROM OTHERS 134.849 78.048 212.897 INVENTORY AT COST JREPAID ITEMS 7.027 7.027 ~IXED ASSETS ~~OUNT TO BE PROVIDED 1. 860 .500 1.860.500 TOTAL ASSETS 20.960.866 1. 997 . 554 334.133 14.123.343 2.202.187 39.618.083 LIAL/FND BAL/RETND ERNGS '....I lEPOSITS FOR PRIVATE DEVEL (498.812) (498.812) lEPOSITS FOR AB1600 FEES (13.338.261) (13.338.261 ) lEPOSITS OTHERS (468.866) (468.866) 'AYABLES: ACCOUNTS (2.444.126) (325.028) (25.329) (336.924) (3.131. 407) INTEREST PAYROLL (309.574) (309.574) JUE TO OTHERS (21. 963) (129.000) (150.963) HERRED REVENUE (149.497) (5.849) (155.346) 'EBT INSTRUMENTS PAYABLE (1. 978.000) (1. 978.000) TOTAL LIABILITIES (3.892.838) (454.028) (25.329) (13.681. 033) (1.978.000) (20.031.228) UND BALANCES (17.068.029) (1.543.526) (308.804) (442.309) (224,187) (19.586.855) TOTAL FUND E (17.068.029) (1.543.526) (308.804) (442.309) (224.187) (19.586.855) OTAL LIAB. FND BAL. RETD (20.960.866) (1.997 .554) (334.133) (14.123.343) (2.202.187) (39. 6}8. 083) ."""'" 3 ~ JS CITY OF DUBLIN BALANCE SHEET ,.,--. FOR THE PERIOD ENDING 30Jun1999 INTERNAL ENTERPRISE FIXED ASSETS GENERAL LONG TOT A L S SERVICE FUNDS GROUP OF TERM DEBT -- -MEMORANDUM--- FUNDS ACCOUNTS ACCOUNT GROUP CURRENT ASSETS ::ASH 1. 023.507 1. 023.507 :ASH WITH FISCAL AGENT . JNAMORTIZED BOND DISCOUNT INVESTMENTS AT COST i.ECEIVASLES: TAXES ACCOUNTS (NE INTEREST ASSESSMENTS JUE FROM OTHERS iNVENTORY AT COST )REPAID ITEMS cIXED ASSETS 19.491. 955 6.388.993 25.880.948 \~OUNT TO BE PROVIDED 29.519.398 29.519.398 TOTAL ASSETS 20.515.462 6.388.993 29.519.398 56.423.853 ,.r--- LIAL/FND BAL/RETND ERNGS JEPOSITS FOR PRIVATE DEVEL lEPOSITS FOR AB1600 FEES lEPOSITS OTHERS 'AYABLES: ACCOUNTS (20.806) (20.806) INTEREST PAYROLL ,UE TO OTHERS EFERRED REVENUE EBT INSTRUMENTS PAYABLE (29.519.398) (29.519.398) TOTAL lIABILITIES (20.806) (29.519.398) (29.540.205) UND BALANCES (20.494.655) (6.388.993) (26.883.649) TOTAL FUND E (20.494.655) (6.388.993) (26.883.649) OTAl LIAB. FND BAL. RETD (20.515.462) (6.388.993) (29.519.398) (56.423.853) THE CITY OF DUBLIN STATEMENT SHOWING 1/ 1 /:3. REVENUES VERSUS EXPENDITURES FOR THE PERIOD 01Jul1998HROUGH 30Jun1999 G ENE R A L REV E N U E FUN D ....", CURRENT CURRENT BUDGET ACTUAL VARIANCE ~REVENUESA^AAAAA PROPERTY TAXES 4.856.100,00 4.866.093,29 (9.993,29) SALES TAX 8.200.000.00 8.687.090,90 (487.090.90) REAL PROPERTY TRANSFER TAX 235.000.00 282.732,72 (47.732.72) HOTEL TRANSIENT OCCUPANCY TAX 337.000,00 389.663.83 (52.663,83) FRANCHISE TAXES 815.000.00 849.959,28 (34.959.28) LICENSES & PERMITS 1.876.755.00 2.472.217,26 (595.462,26) FINES & FORFEITURES 45.950,00 60.875.88 04.925,88) USE/MONEY & PROP-INTEREST 1.121.000,00 1.262.400,02 041.400.02) USE/MONEY & PROP-RENTALS 104.530.00 90.539 A8 13.990,52 INTERGOVERNMENTAL FROM STATE 1. 308.420.00 1. 356.234,32 (47.814.32) CHARGES FOR SERVICES 3.343.378.00 3 .482 . 982 . 60 039.604.60) OTHER SOURCES OF REVENUE 637.745.00 250.889.12 386.855,88 )T AL REVENUE 22.880.878,00 24.051.678.70 0.170.800.70) ~EXPENDITURESAAAAA^A :NERAL GOVERNMENT ACTIVITIES: CITY COUNCIL 153.177,10 145.936.01 7.241.09 ..."", CITY MANAGER 350.365.00 331. 437.26 18.927.74 CENTRAL SERVICES CITY ATTORNEY 310.800.00 310.557,97 242,03 ADMIN SERVICES 743.465.00 687.654,23 55.810.77 BUILDING MANAGEMENT 537.270,00 531.817,85 5.452,15 FACILITY RENTAL 1.719.374.00 1. 614.407.09 104.966.91 INSURANCE COST CENTER 143.047,00 125.621.86 17.425.14 ELECTIONS COST CENTER 6.415.00 6.335,24 79.76 NON-DEPARTMENTAL 37.195.90 377.71 36.818,19 ACTIVITY TOTAL 4.001.109.00 3.754.145.22 246.963,78 BLIC SAFETY POLI CE 4.505.863.00 4.505.598.49 264.51 CROSSING GUARDS 52.887.00 51. 696,91 1.190,09 6.NIMAL CONTROL 180.700.00 104.136.76 76.563,24 JISASTER PREPAREDNESS 38.544,00 35.021,96 3.522.04 =IRE SERVICES 4.210.354,00 4.109.003.33 101. 350.67 ACTIVITY TOTAL 8.988.348.00 8.805.457.45 182.890.55 ;NSPORTATION JUBLIC WORKS 393.130.00 389.594.78 3.535.22 STREET MAINTENANCE 141.720.00 112.085.18 29.634.82 STREET SWEEPING STREET TREE MAINTENANCE 49.990,00 49.394.83 595,17 STREET LANDSCAPING MAINTENAN 226.600,00 225.854.52 745A8 ACTIVITY TOTAL 811.440,00 776.929.31 34.510.69 ;LTH & WELFARE '-..."I 4ASTE MANAGEMENT 6.160,00 4.968.90 1.191.10 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 01Ju11998HROUGH 30Jun1999 G EN ERA L REV E N U E FUN D CURRENT CURRENT BUDGET ACTUAL VARIANCE CHILD CARE 12.000,00 12.000,00 ACTIVITY TOTAL 18.160.00 16.968.90 1.191.10 JL TURE & LEISURE SERVICES. LIBRARY SERVICES 258.848.00 255.689.00 3.159.00 CULTURAL ACTIVITIES 20.000.00 20.000,00 HERITAGE CENTER 55.272.00 43.003,52 12 . 268 .48 DUBLIN CEMETERY 21. 624.00 15.010.17 6.613.83 PARK MAINTENANCE 619.429.00 533.104.94 86.324,06 COMMUNITY TV 71.141. 00 58,046,52 13.094.48 RECREATION ADMIN 290.509,00 264.381. 74 26.127.26 PLAYGROUNDS 137.665.00 137.577.04 87.96 SHANNON CENTER 153.998.00 164.547.25 (10.549,25) PRESCHOOL 56.878,00 49.314,09 7.563.91 TEENS PROGRAM 52.778.00 44.993.27 7.784,73 ADULT SPORTS 84.219,00 60.291.18 23.927.82 YOUTH SPORTS 99.301.00 63.730.01 35.570,99 COMMUNITY GYM SP'- ,_ EVENTS 145.976.00 105.169,65 40.806,35 -~ .. CENTER 124.910.00 99.728.89 25.181.11 ::,~,. ~ECREATION INSTRUCTION 122.588.00 115.191.14 7.396.86 6.QUATICS 255.751,00 218.801.73 36.949,27 ~ARKS/FACILITIES MANAGEMENT 26.259.00 26.259,00 ACTIVITY TOTAL 2.597.146.00 2.248.580,14 348.565.86 ~MUNITY DEVELOPMENT ~LANNING 944.988.00 1. 010.015,03 (65.027.03) 3UILDING SAFETY 880.947.00 795.024,53 85.922.47 ::NGINEERING 1. 686 .161. 00 1.685.599.49 561.51 ::CONOMIC DEVELOPMENT 184.031.00 115.762.34 68.268.66 ACTIVITY TOTAL 3.696.127,00 3.606.401.39 89.725,61 JITAL IMPROVEMENT PROJECTS ;ENERAL CIP PROJECTS 1. 330.861. 76 252.012,63 1.078.849.13 :OMMUNITY IMPROVEMENTS 72.994.00 63 .272 .48 9.721.52 'ARKS 1. 261. 760.00 1.110.303,64 151.456.36 ;TREET CONSTRC/IMPROVEMENTS 368.062,00 353.570.03 14.491. 97 ACTIVITY TOTAL 3.033.677.76 1.779.158.78 1.254.518,98 AL EXPENDITURES 23.146.007,75 20.987.641.19 2.158.366.57 ESS REVENUE (EXPENDITURES) (265.129.76) 3.064.037.51 (3.329.167,27) NSFERS IN FROM OTHER FUNDS 39.874.17 (39.874,17) NSFERS OUT FROM OTHER FUNDS (2.531.00)(12.219.722.58) 12.217.191,58 ENUES OVER(UNDER) EXPENDITURES (267.660.76) (9.115.810,90) 8.848.150.14 ,r- 5 &( /3 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 01Jul1998HROUGH 30Jun1999 b1iY SPECIAL CURRENT BUDGET ~REVENUES******** JPERTY TAXES _ES TAX/OTHER TAXES ~ES & FORFEITURES :S/MONEY & PROPERTY ~ERGOVERNMENTAL FROM STATE iERGOVERNMENTAL FROM COUNTY iERGOVERNMENTAL FROM FEDERAL ~RGES FOR SERVICES 1ER SOURCES OF REVENUE TOTAL REVENUE 76.680.00 175.500.00 42.400.00 68.255.00 1.500.397.00 145.065,00 330.495 AD 698.080,00 2.000.00 3.038.872AO CURRENT ACTUAL 76.684.53 172.561. 75 65.857.76 93.371.12 753.103.27 149.244.00 374A49.92 706.992,33 22A39.87 2.414.704,55 REV E N U E "wJI FUN D VARIANCE (4.53) 2.938.25 (23.457.76) (25.116.12) 747.293.73 (4.179.00) (43.954,52) (8.912,33) (20.439.87) 624.167,85 ~EXPENDITURESAAAAAAA III C SAFETY: 'OLl CE 79.444,00 78.444.67 999.33 'RAFFIC SIGNALS & STREET LTG 104.750.00 72.476,39 32.273,61 'IRE SERVICES 81. 745.00 81. 444,13 300,87 ....I ACTIVITY TOTAL 265.939,00 232.365,19 33.573,81 ,NSPORT A TI ON : ,TREET MAINTENANCE 273.624,15 265.920.49 7.703,66 ;TREET SWEEPING 90.070.00 81. 727,11 8.342.89 ACTIVITY TOTAL 363.694,15 347.647,60 16.046.55 UH & WELFARE: ASTE MANAGEMENT 865.499.00 827.685.54 37.813A6 ENIOR SUPPORT CARE 7.044.00 7.044.00 ACTI V ITY TOTAL 872.543.00 834.729.54 37.813.46 MUNITY DEVELOPMENT: NGINEERING 44.400.00 44.166.79 233.21 ACTIVITY TOTAL 44.400,00 44.166.79 233.21 ITAL IMPROVEMENT PROJECTS: ENERAL CIP PROJECTS JMMUNITY PROJECTS 60.749AO 56.548.31 4.201.09 lI.RKS 59.403,00 51. 300 , 97 8.102.03 TREET CONSTRUCTION/IMPROVEMENT 1.415.327.00 674.931. 01 740.395,99 ACTIVITY TOTAL 1. 535 .479 AO 782.780,29 752.699.11 TAL EXPENDITURES 3.082.055,55 2.241. 689 Al 840.366.14 ~SS <REVENUE>EXPENDITURE 43.183.15 (173.015.14) 216.198.29 ~SFER IN FROM OTHER FUNDS (130.265.91 ) 130.265,91 ~SFERS OUT TO OTHER FUNDS 62.370,78 (62.370.78) ~SS <REVENUE> EXPENDITURE 43.183.15 (240.910.27) 284.093,42 ....", !-- THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 01Jul1998THROUGH 30Jun1999 I rf /:;; CAP I TAL IMP R 0 V E M EN T FUN D CURRENT BUDGET CURRENT ACTUAL VARIANCE ~REVENUEAAAAAAA~ ;ES/MONEY & PROP-INTEREST "HER SOURCES OF REVENUE TOTAL REVENUE: 29.075.00 11.496.335.00 11.525.410.00 2.257.954.64 2.257.954,64 29.075.00 9.238.380.36 9.267.455.36 *****EXPENDITURESAAAAAAA NERAL GOVERNMENT ACTIVITIES: ACTIVITY TOTAL SLIC SAFETY: ANSPORT A TI ON: ALTH & WELFARE: LTURE & LEISURE SERVICES: ~ECREATION ADMINISTRATION 17.000,00 16.915,01 84,99 ACTIVITY TOTAL 17.000,00 16.915.01 84,99 ~MUNITY DEVELOPMENT ~J~ING 16.226.00 145.14 16.080,86 ACTIVITY TOTAL 16.226.00 145,14 16.080,86 ~ITAL IMPROVEMENT PROJECTS ;ENERAL CIP PROJECTS 987.484.00 124.753.27 862.730.73 :OMMUNITY IMPROVEMENTS 94.024.00 94.024.00 )ARKS 2.970.379.00 1.180.149,86 1.790.229.14 ;TREET CONSTRUCTION/IMPROVEMENT 7.492.347,00 744.202.34 6.748.144.66 ACTIVITY TOTAL 11. 544.234,00 2.049.105.47 9.495.128.53 ) TAL EXPENDITURES 11.577 .460.00 2.066.165,62 9.511.294.38 :ESS <REVENUE>EXPENDITURE 52.050.00 091.789,02) 243.839.02 INSFER IN FROM OTHER FUNDS ,NSFERS OUT TO OTHER FUNDS 17.586.84 (17.586.84) ISS <REVENUE>EXPENDITURE 52.050.00 (174.202,18) 226.252,18 /--. *******REVENUESAA~AAAAA SPECIAL ASSESSMENTS USES/MONEY & PROP-INTEREST TOTAL REVENUE ******EXPENDITURES******* ENERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL ACTIVITY TOTAL UBLIC SAFETY: KANSPORT A TI ON : ::ALTH & WELFARE: JLTURE & LEISURE SERVICES: JMMUNITY DEVELOPMENT: ~PITAL IMPROVEMENT PROJECTS o TAL EXPENDITURES XCESS <REVENUE>EXPENDITURE (CESS <REVENUE>EXPENDITURE CURRENT BUDGET r1 J . I? '"P tz> / ../ THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 01Jul1998THROUGH 30Jun1999 T R U S T / AGE N C Y FUN D ,.."", CURRENT ACTUAL 235.672.36 12.637.55 248.309.91 231. 864,50 231.864.50 VARIANCE (235.672.36) (12.637.55) (248.309.91) (231.864.50) (231.864,50) 231.864,50 (231.864,50) (16.445.41) 16.445,41 06.445.41) ~ 16.445.41 ....,,' *******REVENUESAAAAAAAA USES/MONEY & PROP-INTEREST TOTAL REVENUE *******EXPENDITURESAAAAAAA ~NERAL GOVERNMENT ACTIVITIES: NON-DEPARTMENTAL FI NANCE ACTIVITY TOTAL JBLIC SAFETY: ::ALTH & WELFARE: JLTURE & LEISURE SERVICES JMMUNITY DEVELOPMENT: \PITAL IMPROVEMENT PROJECTS: 9~~ L EXPENDITURES , <REVENUE>EXPENDITURE ~~FERS IN FROM OTHER FUNDS ~NSFERS OUT TO OTHER FUNDS CESS <REVENUE>EXPENDITURE ~/'-~ CURRENT BUDGET 1.827.244.00 1.827.244.00 1.719.394,00 3.435.00 1. 722 . 829 . 00 THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 01Ju11998THROUGH 30Jun1999 q ,/ /!J / () E N T E R P R I S E FUN 0 CURRENT ACTUAL VARIANCE 1.671.632.89 1. 671. 632 . 89 155.611.11 155.611.11 935.724.30 500.00 936.224,30 783.669.70 2.935,00 786.604.70 1.722.829,00 936.224.30 786.604.70 (104.415.00) (735.408,59) 630.993.59 (12.134.212.45) 12.134.212.45 13.587.133.27 (13.587.133.27) (104.415,00) 717.512.23 (821.927.23) THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD olJu11998THROUGH 3oJun1999 / j) :5/~ /3 Iv !) S P E C I A LAS S E SSM E N T FUN D -..."" CURRENT BUDGET CURRENT ACTUAL VARIANCE ******REVENUESAA^AAAA^ SPECIAL BENEFITS ASSESSMENTS. USES/MONEY & PROP-INTEREST JTHER SOURCES OF REVENUE TOTAL REVENUE 254.580.00 10.300.00 2.000.00 266.880,00 253.175 AO 16.381-44 2.736,05 272.292,89 1.404.60 (6.081-44) (736.05) (5.412,89) ~EXPENDITURES******* 3U C SAFETY: TRAFFIC SIGNALS & STREET LIG 131.987.00 107.525.57 24.461-43 ACTIVITY TOTAL 131.987.00 107.525.57 24.461-43 ~NSPORTATION JUBU C WORKS 4.729.00 2.246,99 2.482.01 ;TREET TREE MAINTENANCE 10.100.00 7.694.38 2.405,62 ;TREET LANDSCAPE MAINTENANCE 128.770,00 105.652,77 23.117,23 ACTIVITY TOTAL 143.599,00 115,594,14 28.004,86 \L TH & WELFARE: :NGINEERING 4.480,00 3.084,88 1-395.12 ....,I ACTIVITY TOTAL 4.480.00 3.084,88 1-395.12 )ITAL IMPROVEMENT PROJECTS: :OMMUNITY IMPROVEMENTS ;TREET CONSTRUCTION/IMPRVMNT ACTIVITY TOTAL 1 TAL EXPENDITURES 280.066,00 226.204.59 53.861-41 :ESS <REVENUE>EXPENDITURE 13.186.00 (46.088.30) 59.274.30 :ESS <REVENUE>EXPENDITURE 13.186.00 (46.088.30) 59.274,30 '..."I ,~' ~REVENUES~AAAAAAA USES/MONEY & PROP-INTEREST CHARGES FOR SERVICES OTHER SOURCES OF REVENUE TOTAL REVENUE *****EXPENDITURES~AAAAAA NERAL GOVERNMENT ACTIVITIES NON-DEPARTMENTAL ACTIVITY TOTAL 3LIC SAFETY: ~SPORT A TI ON: -XL TH & WELFARE: _TURE & LEISURE SERVICES 1MUNITY DEVELOPMENT: JI~IMPROVEMENT PROJECTS: ) TAL EXPENDITURES :ESS <REVENUE>EXPENDITURE \NSFER IN FROM OTHER FUNDS \NSFERS OUT TO OTHER FUNDS :ESS <REVENUE>EXPENDITURE THE CITY OF DUBLIN STATEMENT SHOWING REVENUES VERSUS EXPENDITURES FOR THE PERIOD 01Jul1998THROUGH 30Jun1999 II 1 /3 I N T ERN A L S E R V ICE FUN D CURRENT BUDGET 39.604.00 737.923.00 30.000.00 807.527.00 728.134,00 728.134.00 CURRENT ACTUAL 40.084.94 726.998.50 17 .455 . 06 784.538,50 794.802,16 794.802.16 VARIANCE (480,94) 10.924.50 12.544,94 22.98B.50 (66.668,16) (66.668.16) 728.134,00 794.802,16 (66.668,16) (79.393,00) 10.263.66 (89.656.66) 13.582.460,94 (13.582.460.94) (79.393,00)(13.572.197.28) 13.492.804.28 Certifled Public :,\ccol..lntants / j :;;:/ / !!; j,'" 1'\_ j .. Mall hew 5. ~lillec (;.1'..,,>. F1ay C. Cowles. 'c.p.,,>. David L. DClyton. CPA Ken E, Johnson, C.P.A. i\. J. MCljOC c.P..". . Terri ,.... MOl1lgomery. C.P..">. Leonard P. Danna. C.P.A. . 'o.c. ,~ JRmes Balsallo; PrinCipRI ..... JoSeph M. .'\guilar, Principal Bonnita L. Ruesch. Principal Caroline ^' Larson, Principal Charles H. Gielow, JL. Consultant I Gary T. CiclwllR. c.P....: I Donalej ,..... Dnllm.cr. C.PA Gregory P. Cook. C.P..">. Dennis /\. pringle. CPA . Ron S. \\'hl1(', CP..... Jeffrey A, Caner. CP...... Karen Comer. C.P.A. LindR S. Todd. c.P...... he\'!n T. Plllliam~ CP.A. Heidi E. Ross, CPA Tllomas .'\. Brewer, C.P.A. Vavrinek, Trine, Day & Co., LLP Memllers: . American Institllle of Cenifil;>o Public ACCOUnl<lI1lS . . SEC Pr<lctiCI;> Sl;>nion . Californi<l Society Of Cenified Public Accountants ,. \Vestern AssocicHion or /\ccounting FHms INDEPENDENT AUDITORS' REPORT ON COMPLIANCE WITH THE PROPOSITION III 1998-99 APPROPRIATION LIMIT INCREMENT To the Mayor and Members of the City Council City of Dublin, California We have applied the procedures below to the Budget Appropriations Limit Worksheet (Worksheet) for the City of Dublin for the year ended June 30, 2000. These procedures, which were suggested by the League of California Cities and presented in their Article XIIIB Appropriations Limitation Uniform Guidelines (Guidelines) were performed solely to assist you in meeting the requirements of Section 1,5 of Article XIIIB of the California Constitution. This report is intended for the information of manag:ement and the Citv Council; however, this . -. restriction is not intended to limit the distribution of this report. which is a matter of public record. At your request. based on the League of California Cities' interpretation of Article XIIIB of the California Constitution, the scope of our work excluded any tests or other procedures regarding the accuracy of the 1978-79 or 1986-87 "base year" appropriations limit calculations. ""'" The procedures you requested us to perform and our findings \vere as follows: A. We obtained the Worksheet and determined that the limit and annual adjustment factors \Vere adopted by resolution of the City Council. We also determined that the population and inflation options were selected by a recorded vote of the City Council. B. For the Worksheet, we computed the 1999-2000 Appropriations Limit by multiplying the Adopted (Revised) 1998-99 Appropriations Limit by the Total Grovvth Factor. C. For the Worksheet. we agreed the Per Capita Income, County and City Population Factors to California State Department of Finance Worksheets. We agreed the Nonresidential Assessed Valuation Factor to a City of Dublin Finance Department Worksheet. D. We agreed the 1999-2000 Appropriations Limit to a resolution of the City Council. These agreed-upon procedures are substantially less in scope than an audit, the objective of\vhich is the expression of an opinion on the Worksheet. Accordingly, we do not express such and opinion. 5000 Hopyard Rd" Suite 335 Pleasant on. CA 9458&3351 (9251734-6600. FAX (925) 734-66J I Pleasantonlnfo@vtdcpa.com With Offices Located: Rancho Cucamonga '...", Fresno Laguna Hills San Jose Carmichael Attachment 3 "" !/i J I~ C-!) i /J: .. / , '-" Based on the application of the procedures referred to above, nothing came to our attention which caused us to believe that the Worksheet was not computed in accordance with Article XIIIB of the California Constitution, as interpreted in the California League of Cities Article XIIIB Appropriations Limit Uniform Guidelines. Had we performed additional procedures or had we made an audit of the Worksheet and the other completed worksheets described above, matters might have come to our attention which would have been reponed to you. V:1.U~k.. ,T ~ . 0'0 ' a ~ u... P Octo ber 1, 1999 PJeasanron. California ,....- r~"""""", CITY OF DUBLIN DUBLIN, CALIFORNIA COMPREHENSIVE ANNUAL FINANCIAL REPORT ---..;... FOR THE YEAR ENDED JUNE 30, 1999 ,_:::" Prepared By: Finance Department \I 'I I ~ . . This page left blank intentionally. . . . .. . '. . . . . CITY OF DUBLIN ,- COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE YEAR ENDED JUNE 30, 1999 TABLE OF CONTENTS r- Pa2e INTRODUCTORY SECTION Table of Contents ............................................,.................................................... ..... Elected Officials and Administration Personnel .. ...... ... ,....... ... .,., ,........ ... ...... ... ... ... ..... ........ IV Organizational Chart .... ...... ... .... ,........ ...,..... .... .... ..,.... ......... ... ... ... ........ ... ... ...... .... ...... V GFOA Certificate of Achievement for Excellence in Financial Reporting ......,............................. VI CSMFO Certificate of Award for Outstanding Financial Reporting ...,...................................... VlI Letter of Transmittal .................................................................................................. VlIl FINANCIAL SECTION Independent Auditor's Report ........................................................................................... 1 General Purpose Financial Statements Combined Balance Sheets - All Fund Types and Account Groups 4 Combined Statement of Revenues, Expenditures and Changes in Fund Balances- All Governmental Fund Types ................................................................................. 7 Combined Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual- All Governmental Fund Types . ....... ......... ..... ................ ... ...... ...... .... 8 Combined Statement of Revenues, Expenses and Changes in Retained Earnings - All Proprietary Fund Types ............................................................ 11 Combined Statement of Cash Flows - All Proprietary Fund Types ........................................... 13 Notes To General Purpose Financial Statements .................................................................. 14 CITY OF DUBLIN COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE YEAR ENDED JUNE 30, 1999 TABLE OF CONTENTS (Continued) COMBINING FUND STATEMENTS AND SCHEDULES Pa!!e General Fund 1 Comparative Balance Sheets 45 Combining Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual ........................................,. . . . . . . . . . .. . .. . . . . .. . . . . . .. . . . . . . . . . . . . . .. . . . . . .. 46 I Schedule of Budget Versus Actual Revenues by Source ...."................,............................ 4 7 . Schedule of Budget Versus Actual Departmental Expenditures 49 Special Revenue Funds . Combining Balance Sheet 54 . Combining Statement of Revenues, Expenditures and Changes in Fund Balance ..................... 58 Combining Statement of Revenues, Expenditures and Changes in Fund Balance - . Budget and Actual .......................................................................................... 62 Capital Projects Funds . Combining Balance Sheet 74 . Combining Statement of Revenues, Expenditures and Changes in Fund Balance ...................... 76 Combining Statement of Revenues, Expenditures and Changes in Fund Balance- Budget and Actual ....................,..................................................................... 78 . Internal Service Funds .. Combining Balance Sheet 83 Combining Statement of Revenues, Expenses and Changes in Retained Earnings ..................... 84 . Combining Statement of Cash Flows 85 . Agency Funds Combining Statement of Changes in Assets and Liabilities 89 . . 11 . CITY OF DUBLIN COMPREHENSIVE ANNUAL FINANCIAL REPORT FOR THE YEAR ENDED JUNE 30, 1999 --- TABLE OF CONTENTS (Continued) Pa2;e YEAR 2000 ISSUES (Unaudited) ................ .... ..... ......... ... ............. .............., ,.. ........... .... 91 STATISTICAL SECTION Governmental Expenditures by Function - All Governmental Fund Types - Last Ten Fiscal Years ..................... . .. . . .. . . . .. . .. . .. . . . . . . . . . . . . . . .. . .. . .. . . .. .. . . . . . . . .. .. .. .. . .... . . 95 General Governmental Revenues by Source - All Governmental Fund Types - Last Ten Fiscal Years ..". .... ... .... ." ,.... ....... ,...... ....... .... '" ..., ..... .... ......... ..... ...... .... 96 -..\ Assessed Value of Taxable Property - Last Ten Fiscal Years ................................................ 97 Property Tax Rates - All Direct and Overlapping Governments - Last Ten Fiscal Years ................ 98 Computation of Legal Debt Margin .................................,............................................ 99 Computation of Direct and Overlapping Debt ....... ...... ............................................. ........ 100 Demographic Statistics - Last Ten Fiscal Years . ... ,............ ... ...... ........ .... ........ .... .......... ... 101 Property Value, Construction, and Bank Deposits - Last Ten Fiscal Years ................................ 102 Schedule of 1993 Certificates of Participation Coverage - Fiscal Years 1994-1999 .............. ........ 103 California Public Employees Retirement System Funding Analysis - Fiscal Years 1989-1998 ......... 104 Property Tax Levies and Collections -Last Ten Fiscal Years ............. .......... .................. ........ 105 Principal Property Taxpayers ..................................................................................... 106 Top 25 Sales Tax Producers ....................... .............. ............................ .................. .... 107 Miscellaneous Statistical Data ......................................... .......... .......................... ....... 108 r->. ,-. ll1 CITY OF DUBLIN ELECTED OFFICIALS June 30, 1999 Mayor Guy S. Houston Vice Mayor Janet Lockhart Councilmember Claudia McCormick ADMINISTRATION PERSONNEL City Manager Interim Administrative Services Director City Attorney City Clerk Chief of Police Public Works Director Community Development Director Chief Building Official Parks & Community Services Director Fire Chief IV . . . I Councilmember Lisbeth Howard . Councilmember George Zika . . . Richard C. Ambrose Joe Aguilar Elizabeth Silver Kay Keck Gary Thuman Lee Thompson Eddie Peabody Ken Petersen Diane Lowart Bill McCammon . . . . . . .. -,..:;.;:.-. -, , ;- r-- .... 0::: <( :E: (.) ...I <( Z o ~ - z <( C) 0::: o z :::i m ;:, c LL o > .... - (.) .= :a ::l C 'too o .! c CI) "C "Ci) ;;. .0 C :J o o ~ <3 - e: (I) En Ul a.~gJc~C -",(/)OUUal!:al Ul Q;e:(j).~5E~~ "E (3,8 6; (I) g ~lii ell-> ~ ;>,UOU)al(\lC-(\l C) _(I) _o::!:~!ijal i3W.2 e! !:~a.~:O ~ E _ Ill.:::.... 1Il'- Oe:E'><:$$t.)~ e:~::l.!!!UlUl 0 8 J: 0:: .m ~ u UJ 0 >> >,Q) ..... C .- .... 0.9 <( C o>.Q .E ~ C.- c E ~E ~o () .... Q) 0> ctl C ctl :2 ~ <3 >,C :!: .0 C en :J (f) E .- E E o E 08 ~(f) (f) ~ ~ .- m c:: ~Q) (j) ........ ~$ .220== e: (f)'- a> a5 0- E (/)U~E <(0 U a> .c ~2 -SO:!::: 0.!!2 E >-~E <(0 U &...~$ ro20== :!::: c:: (/)'E Ci> a> 'S; E ::cU~o U v (f) Q) ~.2 U::C:: Q) (j) ~ .... ~ .2 .0 :J ~ ~ :+::(f) ~ Q) .....t.) (f)"- 'c c:: .- Q) E(j) "0 <( (f) ~ "~ ~Q) (f)OO ~>, ........ cc.- ~5 E E o o .... ~c "- Q) C E :Je. E 0 E- O ~ OQ) o (f) ~ "2: Q) 00 Q) .2 (5 ~ - e: (I) (I) g$o>go> 0> ttl .e: ttl .~ ttl a,f 53 16- C.- 0> - Q) ~ U) ::J"~ 3: 0>~Q5~~ e:ttll!:!-Q) :g'=Ci5~l!:! -- ~...... ~ Ci5U) - C _ "(6 Q) .~::;E U t'tl e: ::;E~ttlO> (I) rs 53'2 l!:!(/)"E:Q) I- "0 '(6 ~ Q5 15:2'6> ~=-cJj U)(I)ttl l!:!o.. Ci5 -- m E Q) Q) .... iii ;>, ul!:!;>'O> e:::lU).f! ~gJe:g '_ Q) .Q .c: u.~......,(J I-ttlQ) EI- .E .E - e: (/) m E (1)....>.0> e: ~ ;; .$ ~- "" 0'-"- e: Q)":: ;; t::'~ Q) Q5 (/) - EQ) Q)ttl U)Q) <(u () ;; .... Q)Q)= ~ ~ (ij 0> () 'u a:: e! :; ~ .~ ~ :33~:g~ () om -c ttl a.. :z.. ~ ttlo> U)e: ~'c o>e: e:~ :go.. '5 (D e - e: o () (ij E 'c <( 0> ~ -.- -- (D Certificate of Achievement for Excellence in Financial Reporting 4 I Presented to . City of Dublin, California I . For its Comprehensive Annual Financial Report for the Fiscal Year Ended June 30, 1998 A Certificate of Achievement for Excellence in Financial Reporting is presented by the Government Finance Officers Association of the United States and Canada to government units and public employee retirement systems whose comprehensive annual financial reports (CAFRs) achieve the highest standards in government accounting and financial reporting, . . . . . !J ;(~ ~ President Jl#;r/~ . Executive Director . . . . V1 . Vj ~ ~ ~ L ~~ I I OIL, J 0' ~~ !' .~ ~ ~ ~ o ~ VJ ~ tS ,-.- ,- ~ ..}. ~ .~ .~ .~ ~ ~ "C - = ~ ~ Q ~ .- = I:J = .- .- - ~ U 00 0\ tZ 0\ 0\ ~ ~ eN t Q & ~ ~ e~ ~ ~ .~ e~ ~ ~ e~ ~ ~ ~ ~ ~ o ~ ..= ... o ... "0 ~ ... = ~ fI.l ~ ;... ~ .~ --~ ~ ~ ~ ~ .~ U .~ .5 1:: ~ ~ .. .is ~ II::: ~ .;:: !>> II::: ~~~ 1:~" ~ 15 c::.. ~ ~ ~ 5 ~ ~ "" "'l ;: ~-"'" ...s1: .g ~ ~ := i ~ II::: := .. 1;j~~ ~~~ :=:::.::: .!: := ~ "'l:='::: tl II::: ;: ~~~ i: OS ii; c::..:=i: ~......-;;. ~ .5S~ '--' ~1i- ~ ::: ~ ~ l:::\'< "'l ~~.~ =:........::: ~ ~ ~ .1:: ~ ~ s:o.::: ~ <:l.~1I::: ~.::: ~ ~1I:::.iS .5 t: ~ ~~~ ~ '1:':> "l:: ::: ~ := ~ ... ::: _.....~ ~ .~ .:: -.:::"'" ~ ;: := a ~ .s. i 1: ~ ~ ~ ~ Q\ ~ ~ ~ ~ .. ~ Os 5. Q U ~ 5 5 ~ ::: ~ ..... .~ o ~ .5 ~ ..... ~ .~ .~ ~ ~ .5 ~ 5 ::::: ~ ~ ~ -S ~ ~ a .... ~ ~ ~ VII ~~, /~'\./A~~\ 11/;// ~~ \:,.~}:~ \1'-l\~ ~j02J CITY OF DUBLIN -'\~J po. Box 2340, Dublin, California 94568 ~ December 8, 1999 . City Offices, 100 Civic Plaza, Dublin, California 94568 Honorable Mayor and Members of the City Council Presented with this transmittal is the City of Dublin Comprehensive Annual Financial Report, for the year ended June 30, 1999. The responsibility for the accuracy and fairness of this report rests with the City. REPORT FORMAT The Comprehensive Annual Financial Report contains information which has been divided into the following three main sections: . Introductory Section: This consists of: the table of contents; directory of elected officials and staff; city organization chart;' GFOA and CSMFO awards; and a letter of transmittal. This section is intended to assist the reader and provide a narrative overview of the entire report. . Financial Section: This consists of: the independent auditor's report; general purpose financial statements and notes; and combining statements by fund type. In its entirety this section comprises the annual financial audit prepared by the City's Certified Public Accountants. I . Statistical Section: This section includes both financial and non-financial data about the City and its operations. The information provides historical comparisons of key factors. The information in this Comprehensive Annual Financial Report is prepared in accordance with Generally Accepted Accounting Principles (GAAP) as promulgated by the Governmental Accounting Standards Board (GASB) and includes the report prepared by City's independent certified public accountants, Vavrinek, Trine, Day & Co., of Pleasanton, California. , . REPORTING ENTITY This report reflects reporting as a single entity for all operations directly associated and controlled by the City. In addition to reporting directly for the City operations, Dublin Information Inc. (DIl), a separate legal entity, has been included in the primary reporting entity. This is a non profit corporation originally formed by the City to address the distribution of public information. The functions were expanded in 1985 to include financing for the construction of a new Civic Center. The project was completed and occupied in 1989. Pursuant to the financing arrangements with Dublin Information Inc., the Civic Center project was leased :from the corporation, with the (:ity making annual payments :from its General Fund. These annual payments were used by Dublin Information, Inc. to make principal and interest payments to the holders of the Certificates of Participation. During Fiscal Year 1998-99 the remaining amount of the bonds outstanding were retired, and ownership of the Civic Center assets was transferred :fro~ DIl to the City. 11 . . SUMMARY OF THE LOCAL ECONOMY The City of Dublin is located at the intersection of Interstates 580 and 680 approximately 35 miles east of San Francisco. The City has a wide range of housing types available to meet the demands of various employers throughout the region. The City has a large retail base which serves local residents as well as those in surrounding communities. The largest employers include: public agencies such as; County of Alameda and United States Department of Justice Correctional Facilities, and the Dublin Unified School District; corporate offices such as Micro Dental Laboratories and Humphrey . .. 'II Administration (925) 833-6650 . City Council (925) 833-6605 . Finance (925) 833-6640 . Building Inspection (925) 833-6620 Code Enforcement (925) 833-6620 . Engineering (925) 833-6630 . Parks & Community Services (925) 833-6645 Economic Development (925) 833-6650 . Polic,~, (925) 833-6670 . Public Works (925) 833-6630 Community Development (925) 833-66'{~P. Fire Prevention Bureau (925) 833-6606 . ,.-.. Instruments, and retailers such as; Montgomery Wards, Toys R Us, Target Stores, Good Guys, Circuit City, Mervyns and Best Buy, which recently opened at the new Hacienda Crossings shopping center. Economic conditions throughout the State improved during Fiscal Year 1998/99. Retail Sales are an obvious indicator of the general economic climate. The General Fund Sales Tax in 1998-99 increased by 8% over the amount attributable to the prior year ($8.7 million in FY 98/99 vs. $8.0 million in FY 97/98). A significant amount ofthe City's retail sales are attributable to the sales of new and used automobiles which continued for the fourth year in a row with improved sales. The future economic outlook for the City is geared towards enhancing the City's existing economic base, while looking towards opportunities for expansion and adding diversity to the current retail base, There is the ability to accommodate significant new development projects in the City's Eastern Dublin Specific Plan Area, as evidenced by several development agreements entered into with the Alameda County Surplus Property Authority (Authority) during the past two fiscal years. The Authority is negotiating with private development firms as partners in the actual construction and development of these projects. MAJOR INITIATIVES The City of Dublin is an active and vibrant community which requires that the municipal government be prepared to respond to changes which are occurring. Each year the City Council adopts Goals and Objectives to be pursued in the upcoming year and evaluates the progress achieved towards the goals previously established. The clear provision of identified goals becomes an outline for the major initiatives undertaken. In Fiscal Year 1998-1999 the City completed construction associated with the Dougherty Road Widening project. This was a project designed to improve the traffic flow in the central area of the City. In addition, the City also began design work for arterial street and freeway interchange improvements in the Eastern Dublin Specific Plan area, completed a slope stabilization project on San Ramon Road, and obtained grant funds to fund the installation of three stop lights near the high school and the next phase of the Dublin Boulevard Widening project from Village Parkway to Sierra Court. .-- The market for new housing of all types remained strong during Fiscal Year 1998-99, as the Community Development Department experienced a large increase in the number of building permits issued. During Fiscal Year 1998-99, permits were issued for 771 new residential units, including 329 homes and 442 apartments. The valuation of these new residential units was estimated to be $130 million, adding to the City's taxable assessed value for Fiscal Year 1999-2000. '-'"' Non residential activity also increased significantly during Fiscal Year 1998-99, as building permits were issued for an Amerisuites hotel, the first stage of the Emerald Point business park, and two new car dealerships. In addition, permits were pulled for several stor~s and restaurants at the new Hacienda Crossings retail complex, including a new 21 screen Regal lMAX Theater, Barnes and Noble, Best Buy, Old Navy, Macaroni Grill, Black Angus and Mimi's Grill. Plans have also been approved for a GM AutoMall, another hotel and the completion of three new office complexes. ACCOUNTING SYSTEM AND BUDGETARY CONTROL Note 2 in the General Purpose Financial Statements provides a detailed explanation of the significant accounting policies. For all City Governmental funds the revenues and expenditures are based on a modified accrual basis of accounting. This means that revenues are recorded when measurable and available rather than when they are received. Expenditures are recorded when the liability is incurred rather than when it is paid. In the case of proprietary funds, such as the Dn Enterprise Fund and Internal Service Funds for building and equipment replacement, expenditures are accounted for using the accrual basis of accounting. In developing and evaluating the City's accounting system, consideration is given to the adequacy of controls. Internal accounting controls are designed to provide reasonable assurance regarding: safeguarding of assets against loss, accuracy and reliability of accounting data, and adherence to prescribed policies. The concept of reasonable assurance recognizes ~ ix that the cost of a control should not exceed benefits likely to be derived; and that the evaluation of costs and benefits require estimates and judgments by management. Annually the City Manager develops and presents a budget for approval by the City Council. The Budget includes appropriations for both operating programs and capital improvement projects. The Budget is approved on a departmental basis based upon the identified funding sources. The adopted accounting procedures authorize the City Manager to transfer budget amounts between line items within the same Department. Expenditures may not exceed budgeted appropriations at the departmental level without City Council approval. FINANCIAL IDGHLIGHTS OF FISCAL YEAR 1998 - 1999 The financial reports identify that among all of the Governmental Fund Types, the General Fund represents approximately 83% of both the Revenue and Expenditures. Although the financial activities within all funds are detailed in the Financial Section of the report, it is clear that the activity within the General Fund is of primary importance when evaluating the City's fiscal condition. Therefore, this discussion will focus on the General Fund. The following analysis shows changes in major General Fund Revenue Types as compared to the previous Fiscal Year: GENERAL FUND REVENUES AMOUNT COLLECTED % OF TOTAL DOLLAR CHANGE % CHANGE FROM . REVENUE TYPE 1998/1999 CURRENT YEAR FROM PRIOR YEAR PRIOR YEAR PROPERTY TAXES $ 4,866,093 20% $ 514,235 12% TAXES OTHER THAN . PROPERTY $ 10,209,447 42% $ 886,548 10% LICENSES / PERMITS $ 2,472,217 10% $ 1,073,540 77% . rnTERGOVERNMENTAL $ 1,356,234 6% $ 122,422 10% CHARGES FOR SERVICES $ 3,482,983 14% $ 999,122 40% . rnTEREST $ 1,262,400 5% $ (223,320) (15%) USE OF PROPERTY $ 90,539 <1% $ 20,078 28% . FINES & FORFEITIJRES $ 60,876 <1% $ 20,455 51% OTHER $ 250.889 3% $ (256.163) (51%) 'I TOTAL $ 24.051.678 100% $ 3.156.917 15% The following sections describe changes in Fiscal Year 1998/99 within each of the major revenue categories: I Property Tax related revenues showed an increase due to new residential and commercial units (mostly in Eastern Dublin) constructed in Fiscal Year 1997-98 being included for the first time on the 1998-99 tax roll. In addition, there _ was a general overall increase in property values in the City due to an active housing market and strong demand for office and retail space. The City's taxable assessed value increased from $1.7 billion in Fiscal Year 1997-98 to $1.9 billion in Fiscal Year 1998-99, a 12% increase over the prior Fiscal Year. The taxable assessed value on the property in _ Eastern Dublin will continue to increase as the county sells more of its parcels to private developers and as new residential and commercial units are constructed by the developers. .. The increase in Taxes Other Than Property category is primarily related to sales taxes. The City experienced an 8% increase in sales taxes over the prior year due to continued strong auto sales. Other factors contributing to the increase in .. x . this tax category included the collection of increased refuse franchise fees from the new residential units, higher Transient Occupancy Taxes due to the addition of two new hotels within the City and higher room rates at the City's other existing hotel, and higher Property Transfer Taxes due an increase in the number of property sales within the City. ,- The increase in Licenses and Permits category is primarily related to building permits. As previously noted the development sector continued to show an increase in activity in terms of projects actually under construction. The valuation of the additions and improvements covered by these new building permits increased from approximately $112 million in Fiscal Year 1997/98 to approximately $228 million in Fiscal Year 1998/99. Even though permits may have been obtained in Fiscal Year 1998-99, the City will continue to incur inspection related costs in Fiscal Year 1999-2000 for those buildings not completed as of June 30, 1999. The increase in Charges For Services primarily represents the undertaking of large Planning related studies as well as processing related to the proposed projects. The Engineering Department also had increased activity with plan checking related to development projects. - The Interest category decreased from the prior year due to the use of fund balance reserves to payoff the remaining balance of the Civic Center Certificates of Participation. The Cash Management section in the Transmittal Letter discusses this area in more detail. The Use of Property category relates to the rental of City buildings and fields. This revenue category increased over the prior year due to the increased use of the City's sports facilities for new recreation programs added during the year. The Fine and Forfeiture category showed an increase primarily attributable to an increase in the amount of fines collected by the municipal court being allocated to the City. This category represents a very small fraction of the Total General Fund Revenues. The Other Revenue category showed an decrease over the previous year. Since this category is utilized for miscellaneous one-time events it is typical to observe fluctuations between different Fiscal Years. The large decrease from the prior year was due to proceeds received in the prior year from the sale of City owned property for several new commercial properties, including the Holiday Inn Express, near the corner of Dublin Boulevard and Dougherty Road. The following Chart compares changes in General Fund Expenditures to the previous Fiscal Year: ,..... GENERAL FUND EXPENDITURES TOTAL EXPENDED % OF TOTAL $ CHANGE FROM % CHANGE FROM TYPE 1998/99 CURRENT YEAR PRIOR YEAR PRIOR YEAR GENERAL GOVERNMENT $ 2,139,738 10% $ 378,095 21% CNIC CENTER DEBT SERVICE $ 1,614,407 * 8%* $ 121,059* 8%* PUBLIC SAFETY $ 8,805,457 42% $ 600,912 7% HIGHWAYS & STREETS $ 776,930 4% $ 126,222 19% HEALTH & WELFARE $ 16,969 < 1% $ (70) <1% CULTURE & LEISURE $ 2,248,581 11% $ 79,588 4% COMMUNITY DEVELOPMENT $ 3,606,401 17% $ 845,269 31% CAPITAL OUTLAY $ 1.779.158 8% $ 791.958 16% TOTAL $20.987 .641 100% $2.943.033 16% r- Xl * The amount indicated as "Civic Center Debt Service" represents the annual lease payment made to the DIl Enterprise Fund for Fiscal Year 1998-99 to pay for debt service on the bonds. In addition, there was a transfer of $12,217,192 from the General Fund to the DIl enterprise fund to partially fund the early retirement of the 1993 COPS (the balance being paid with the remaining debt service reserves in the DIl enterprise fund). The following sections describe changes in Fiscal Year 1998/99 within each of the major expenditure categories: General Government expenditures increased over the prior year due to the following: additional charges from the City's Internal Service Funds to fund replacement of City owned buildings, increased legal costs related to development related legal review, and the addition of a new Finance Technician in the Finance Department. The development related costs are reimbursed by the project applicant and offset by revenue. Civic Center Debt Service expenditures increased over the prior year as additional expenditures were incurred for the early retirement of the Civic Center Certificates of Participation. Public Safety costs increased over the prior year due to increased Police expenditures resulting from increased fees for bookings at the County Jail, higher fees for dispatch services and a cost of living adjustment from Alameda County for contract Police personnel. Fire expenditures also increased due to a cost of living adjustment from the Alameda County Fire Department for contract fire personnel and additional charges from the City's Internal Service Funds to fund replacement of a City owned fire station and fire equipment. . Highways and Streets expenditure increased in comparison to the prior year due to an higher amount funded by the General Fund for Street Maintenance and Street Landscape Maintenance. . Culture and Leisure Services expenditures increased over the prior year due to the funding of additional hours of operation for the library and additional expenditures incurred for other special events, including the annual St. Patrick's Day celebration and the 1999 Pasta Festival. . Community Development expenditures increased over the prior year due to additional time spent by consultants on various development projects, primarily in the Eastern Dublin Specific Plan area. . Capital Outlay expenditures were $541,000 more in Fiscal Year 1998/99 than the previous year, Due to the one-time nature of capital projects fluctuations from year to year are common. Approximately 63% of General Fund spending on Capital Projects in Fiscal Year 1998/99 was related to the following five projects: . · Improvements to the Swim Center Pool . Improvements to the Dublin Elementary Sports Field · Phase II of the Dougherty Hills Slope Repair Project · Civic Center Roof Replacement . San Ramon Slope Stablization . . The Debt Service category represents the first of four annual debt payments due to the Dublin Unified School District for _ costs incurred in the construction of a new gymnasium. DEBT ADMINISTRATION . The City has no outstanding General Obligation debt. However DIl did have one outstanding bond issue, the 1993 Certificates of Participation, which was issued to refinance the 1988 Certificates of Participation. This bond issue was retired during Fiscal Year 1998-99, with the City using current revenues and existing reserves in the General Fund to pay _ off the remaining $14.77 million of bonds outstanding. . xii . In addition, the City does administer funds for debt issued pursuant to the 1915 Improvement Act for the Dublin Boulevard Extension Assessment District. The total amount of assessment debt outstanding at June 30, 1999 is $1,978,000. This amount is repayable from property assessments levied on properties benefiting from the improvements. Revenues collected were sufficient to finance all required debt service expenditures for the year ending June 30, 1999. There were no material delinquent assessment revenues at year end. RISK MANAGEMENT The City of Dublin is a member of ABAG PLAN Corporation. This is a public agency pool providing liability insurance coverage to 29 Bay Area cities. The coverage limit for Fiscal Year 1998-99 was $7 million per occurrence, which does not cover damage resulting from an earthquake. The City of Dublin has selected a $50,000 deductible. The pool also provides property insurance coverage with a $5,000 deductible except for vehicle losses, which carry a $10,000 deductible. The pool purchases required employee bonds from a commercial surety company. In accordance with GASB 10, the City established a liability of $137,210 for claim deductibles. This includes a provision for losses which may be "incurred but not reported" (IBNR). The actual liability claims cost paid by the City for Fiscal Year 1998-99 was $4,004. CASH MANAGEMENT Cash which is temporarily idle during the year was invested in accordance with adopted investment policies. The amount of interest earned on all Governmental and Proprietary Fund Types was $1.5 million. The 1998/99 annual yield was 5.40%, based upon average monthly balances. The City had lower balances invested due to the early retirement of the 1993 Civic Center COPS, in comparison to the prior Fiscal Year. At June 30, 1999 the City's portfolio of investments had an average weighted maturity of 1.13 years. Of the $34.4 million of investments, approximately $10 million were in United States Treasury and Agency Notes and $23 million in LAIF. The City has positioned its cash needs to allow it to hold all securities to maturity. On a quarterly basis the City Council is provided with a report on investment activity. The investment strategy emphasizes the safety of the portfolio and liquidity to match anticipated cash flow needs. The portion of the portfolio containing U.S. Notes and Agency Obligations does not include any repurchase agreements. INDEPENDENT AUDIT Each year the City of Dublin obtains an independent annual audit of the City's financial records. The information presented includes a review of the results of operations and changes in financial position. The report is presented to the City Council at a public meeting. This report includes the Auditor's opinion on the City's combined financial statements. AWARDS The Government Finance Officer's Association (GFOA) and the California Society of Municipal Finance Officer's (CSMFO) have both recognized the City of Dublin for its Comprehensive Annual Financial Report covering the period ending June 30, 1998. Copies of the awards from these entities are included in this report. This represented the ninth consecutive year that the City report was recognized by the GFOA. In order to be recognized, the City was required to produce an easily readable and efficiently organized report. The report must also meet the requirements for generally accepted accounting principles and legal requirements. The Certificate of Achievement is valid for a period of one year. We believe that our current report continues to meet the Certificate of Achievement program requirements. It is our intent to submit this report to GFOA and CSMFO to determine its eligibility for their certificates. ACKNOWLEDGMENTS Among the responsibilities assigned to the Administrative Services Department are the functions associated with Finance. The staffing for these activities are very small given the scope of the City financial operations as presented. It is especially appropriate to recognize the efforts of Finance Technicians Lynn Harrington, Katie Mooney and Teresa Ninman, and Office Assistant Wanda Oppenheim, Office Assistant, in preparing this report. ,-. xiii The City is fortunate to have these dedicated members willing to meet the extensive requirements of preparing a comprehensive report. The City has had its financial reports recognized by GFOA and CSFMO for several years, which is a significant accomplishment often undertaken only by larger organizations. Staff also appreciates the time and effort expended by the independent auditors ofVavrinek, Trine, Day & Co. LLP in the preparation of the financial statements. The City Council must also be recognized for their continued support of excellence in financial reporting to the public. Staff intends for the report to be a sense of pride and accomplishment, which is a high priority in the provision of all services identified by the City Council. Sincerely, rC )- ~ If\r~,_.i'--- Fred Marsh Finance Manager XIV r-- ,..- FINANCIAL SECTION ,.- . . . . . This page left blank intentionally. . . . . . . . - . . r-- ,~ ,-'. "'- ~ .-- GaryT. Cichella, CPA Donald A. Driftmieccp,A, Gregory P. CoOk, CPA. Dennis A. Pringle, CPA Ron S.White,cP.A. Jeffrey A. carler.,c.PA Karen Comer, CPA. Linda S. Todd, CP.A. '. Kevin T, Pulliam,cP."', Heidi E. ROSs, C.P.A.' Thomas A. Brewer, C.P.A. Matthew S. Miller, CPA, Ray C. CowleS, C.P.A. David L. Qayton, CPA Ken E. Johnson, CPA. A. J.Major, CP.;" . TerriA. Montgomery, CPA Leonard P. Danna, CP.A., James Balsano, principal Joseph M. Aguilar, Principal Bonnila L; Ruesch, PrinCipal Caroline, A. 'Larson, Principal charlesl;l.Gielow, Jr, Cons.ultant vavrinek, 'Trine,.Day &Co.,'LLP Certified Public Accountants Members: . American tnstitute of Certified Public Accountants . SEC practice Section . California Society of certified Public Accountants . \-vestern-Associationof Accounting Firms INDEPENDENT AUDITOR'S REPORT To the City Council City of Dublin, California We have audited the general-purpose financial statements ofthe City of Dublin as of and for the year ended June . 30, 1999, as listed in, the Table ()fContents. These financial statements are the responsibility of the City's' management. Our responsibility is to express,an opinion on these financial statements based on our audits. We conducted our audit inacc()rdance with generally accepted auditing standards and th~standards for finaIlcial ' . audits contained in Government Auditing Standards issued by the Comptroller General of the, United States. Those standards require that we plan. and perform the audits to obtainreasonable assurance as to whether the ,financial statements are free of material misstatement. An audit includes examining on a test basis evidence supporting the amounts and disclosures in thefinaIlcial ~tatements., An audit 'also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall financial statement presentation., We believe our audits provide a reasonable basis for our opinion. ' . ill our opinion, such generakpurpose financial statements present fairly in all material respects the financial position of the City of Dublin at June 30, 1999, and the results of its operations and ,cash flows of its proprietary fundtypesfor the years then ended, in conformity with generally accepted accounting principles; In accordance with Government Auditing Standards, we have also issued arepoq dated Octoberl, 1999, on our consideration of the' City's internal control. over financial reporting and our tests of its compliance with certain provisions of laws, regulations, contracts and grants. Our audits were. made for the pUrpose of forming an opinion on the general..purpose financial statements taken as awhole. . The combining fund statemeritsand schedules listed in the Table of Contents are presented for the purpose of additional analysis and are not a required Part of the general-purpose financial statements. . These combining fund statements and schedules have been 'subjected to the auditing procedures applied in the audits of the general purpose financial statements, and in 'our opinion are fairly stated in all material respects when considered in re'Iationto the general purpose financial statements taken as a whole. The Statistical Section listed in the, Table of Contents was not examinedby~s and we do not express an opinion on this information. 5000 Hopyard Rd., Suite 335 Pleasanton, CA 94588-335 I .' (925) 734~6600 . FAX (925). 734-661 I PleasantOnh::~fo@\rtdcpa .com With Offices Located: Rancho Cucamonga . Fresno Laguna Hills San Jose . Carmichael. -1- , , ,~ Theyear20QO~supplementary illforma:tion is nota required part ofthe basic tinancialstatements but is supplementary information required by the Governmel1tal Accounting Standards Board.. '. W ehaveapplied certain linrited procedures, whichconsisted principally of inquiries of management regarding the methods of . measurement andpresent~ti9n of the supplementary information. fIowever? We did nO,t audit the informationand d. Q II... Q.t.exp.r. e.ssan oP. in. Ion.. on..l..t..In.. ad.dition.,..w. edo.'. n. Qtpro.v. ide.'. ass.. uran.... ceth. e.'.C. ity. of D.. ubI. in. .'is orw..l.'ll......b.ec.o. me year 2000 compliant, that the City of DUQlin's year 2000 remediation effortswillbesuccessful in whole orin part, or that parties withwhicht~eCity of Dublin does business are orwill become year 2000 compliant. V~,T~J.~ ~ C;;.,.&P Pleasanton, California, October 1,1999 --- .,..... -2- CITY OF DUBLIN r- GENERAL PURPOSE FINANCIAL STATEMENTS These statements provide an overview of the combined financial position and the operating results of all fund types and account groups. Individual funds and account groups utilized by the City are grouped in these statements as follows: ~ GOVERNMENTAL FUND TYPES These funds include general, special revenue and capital projects funds, through which governmental functions are typically funded, with the emphasis on sources and uses of resources. PROPRIETARY FUND TYPES These funds include enterprise and internal service funds, which are used to account for activities similar to private industry, with emphasis on net income determination and cost recovery. FIDUCIARY FUND TYPES r- These agency funds are used to account for assets held by the City as an agent. ACCOUNT GROUPS The account groups are used to establish accounting control over the City's general fixed assets and general long- term obligations. These assets and liabilities are not spendable resources and do not require current appropriation. They are accounted for separately from governmental fund types. -3- CITY OF DUBLIN COMBINED BALANCE SHEETS ALL FUND TYPES AND ACCOUNT GROUPS JUNE 30, 1999 (With Comparative Amounts for June 30, 1998) See accompanying notes to financial statements. . . -4- . FIDUCIARY TOTALS FUND TYPE ACCOUNT GROUPS (Memorandum Only) General General-Long Agency Fixed Assets Term Debt 1999 1998 $ 191,482 $ 36,509,085 $ 37,020,104 149,763 149,763 1,862,519 440 1,399,589 1,232,067 502,727 515,875 78,048 199,775 134,849 254,418 248,048 7,027 8,262 $ 6,388,993 25,880,948 26,717,558 $ 7,102,249 7, 102,249 7,013,716 $ 341,685 $ 6,388,993 $ 7,102,249 $ 71,764,285 $ 75,072,342 3,023,912 2,074,078 98,535 67,915 202,131 197,958 967,678 636,431 137,210 137,210 13,487,758 7,047,437 134,849 254,418 21,963 248,048 r- 341,685 341,685 325,241 331,872 7,102,249 7,102,249 7,013,716 14,298,915 341,685 7,102,249 25,517,970 32,633,239 6,388,993 6,388,993 7,700,694 19,597,040 5,598,745 717,512 897,616 404,876 7,027 8,262 248,048 79,887 55,940 60,000 60,000 1,369,133 1,369,133 17,852,672 26,523,941 (6,053) (248,048) 6,388,993 46,246,315 42,439,103 $ 341,685 $ 6,388,993 $ 7,102,249 $ 71,764,285 $ 75,072,342 -5- . I This page left blank intentionally. . I . . . . . . . -6- . CITY OF DUBLIN COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES ALL GOVERNMENTAL FUND TYPES FOR THE FISCAL YEAR ENDED JUNE 30, 1999 (With Comparative Amounts for the Fiscal Year Ended June 30,1998) TOTALS GOVERNMENTAL FUND TYPES (Memorandum Only) General Special Capital Fund Revenue Projects 1999 1998 REVENUES Property taxes $ 4,866,093 $ 4,866,093 $ 4,351,858 Taxes other than property 10,209,447 $ 249,246 10,458,693 9,563,695 Licenses and permits 2,472,217 2,472,217 1,398,677 Intergovernmental 1,356,234 1,276,801 2,633,035 2,159,609 Charges for services 3,482,983 706,990 4,189,973 3,199,115 Interest 1,262,400 109,752 1,372,152 1,600,414 Use of property 90,539 90,539 70,461 Fines and forfeitures 60,876 65,858 126,734 71,017 Developer fees $ 2,257,955 2,257,955 845,948 Other revenue 250,889 25,176 276,065 527,960 Special assessments 253,175 253,175 276,346 Total Revenues 24,051,678 2,686,998 2,257,955 28,996,631 24,065,100 ~ EXPENDITIJRES Current: General government 3,754,145 3,754,145 3,254,991 Public safety 8,805,457 339,889 9,145,346 8,566,630 Highways and streets 776,930 463,241 1,240,171 1,090,290 Health and welfare 16,969 834,730 851,699 764,979 Community development 3,606,401 57,479 145 3,664,025 2,824,242 Culture and leisure 2,248,581 2,248,581 2,172,597 Capital outlay 1,528,154 772,555 2,066,020 4,366,729 2,219,989 Debt Service Principal 251,004 251,004 Total Expenditures 20,987,641 2,467,894 2,066,165 25,521,700 20,893,718 REVENUES OVER (UNDER) EXPENDITIJRES 3,064,037 219,104 191,790 3,474,931 3,171,382 OTHER FINANCING SOURCES (USES) Operating transfers in 39,873 130,266 516,154 686,293 52,102 Operating transfers out (12,219,722) (578,525) (17,587) (12,815,834) (60,487) Total Other Financing Sources (Uses) (12,179,849) (448,259) 498,567 (12,129,541) (8,385) REVENUES AND OTHER FINANCING SOURCES OVER EXPENDITIJRES AND OTHER FINANCING USES (9,115,812) (229,155) 690,357 (8,654,610) 3,162,997 Fund Balance, Beginning of Year 26,183,839 2,081,485 (248,048) 28,017,276 24,772,142 Prior Period Adjustment 82,137 Fund Balance, End of Year $ 17,068,027 $ 1,852,330 $ 442,309 $ 19,362,666 $ 28,017,276 See accompanying notes to fmancial statements. -7- CITY OF DUBLIN COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL ALL GOVERNMENTAL FUND TYPES FOR THE FISCAL YEAR ENDED JUNE 30, 1999 See accompanying notes to financial statements. II -8- . SPECIAL REVENUE CAPITAL PROJECT Variance Variance Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) ~ $ 252,180 $ 249,246 $ (2,934) 1,975,957 1,276,801 (699,156) 698,080 706,990 8,910 78,555 109,752 31,197 $ 29,075 $ (29,075) 42,400 65,858 23,458 11,496,335 $ 2,257,955 (9,238,380) 4,000 25,176 21,176 254,580 253,175 (1,405) 3,305,752 2,686,998 (618,754) 11,525,410 2,257,955 (9,167 ,455) ~ 397,926 339,889 58,037 507,293 463,241 44,052 872,543 834,730 37,813 59,558 57,479 2,079 16,226 145 16,081 1,524,801 772,555 752,246 11,561,234 2,066,020 9,495,214 3,362,121 2,467,894 894,227 11,577,460 2,066,165 9,511295 (56,369) 219,104 275,473 (52,050) 191,790 243,840 130,266 130,266 516,154 516,154 (578,525) (578,525) (17,587) (17,587) (448,259) (448,259) 498,567 498,567 $ (56,369) (229,155) $ 172,786 $ (52,050) 690,357 $ 742,407 2,081,485 (248,Q48) $ 1,852,330 $ 442,309 -9- . . . This page left blank intentionally. . . . . . . . . . -10- . CITY OF DUBLIN COMBINED STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS ,.-. ALL PROPRIETARY FUND TYPES FOR THE FISCAL YEAR ENDED JUNE 30, 1999 (With Comparative Amounts for the Fiscal Year Ended June 30,1998) Dublin Information TOTALS Inc. (Memorandum Only) Internal Enterprise Service Funds Fund 1999 1998 REVENUES Facilities rents $ 1,614,406 $ 1,614,406 $ 1,480,577 Charges for services $ 726,998 726,998 241,988 Miscellaneous 17,455 17,455 6,783 Total Revenues 744,453 1,614,406 2,358,859 1,729,348 EXPENSES Depreciation 686,787 686,787 568,495 Services and supplies 108,015 518 108,533 87,470 Total Expenses 794,802 518 795,320 655,965 Operating Income (Loss) (50,349) 1,613,888 1,563,539 1,073,383 NONOPERATING INCOME (EXPENSES) Interest Income 40,085 57,227 97,312 135,774 Interest Expense and bond discount amortization (935,707) (935,707) (856,351 ) Nonoperating Income (Loss) 40,085 (878,480) (838,395) (720,577) Income Before Operating Transfers (10,264) 735,408 725,144 352,806 OTHER FINANCING SOURSES (USES) Operating transfers in 12,134,212 12,134,212 8,385 Operating transfers out (4,671 ) (4,671 ) Total Other Financing Sources 12,129,541 12,129,541 8,385 Net Income (10,264) 12,864,949 12,854,685 361,191 Charge to contributed capital for depreciation on fixed assets acquired with contributions 503,004 503,004 Retained Earnings, Beginning of year 404,876 717,512 1,122,388 761,197 Retained earnings adjustment (Note 12) (13,582,461) (13,582,461) Retained Earnings, End of year $ 897,616 $ $ 897,616 $ 1,122,388 See accompanying notes to financial statements. -11- . . This page left blank intentionally. I . . . . . . . . -12- . CITY OF DUBLIN COMBINED STATEMENT OF CASH FLOWS ALL PROPRIETARY FUND TYPES FOR THE FISCAL YEAR ENDED JUNE 30, 1999 (With Comparative Amounts for the Fiscal Year Ended June 30,1998) Dublin Information TOTALS Inc. (Memorandum Only) Internal Enterprise Service Funds Fund 1999 1998 CASH FLOWS FROM OPERATING ACTIVITIES Operating income (loss) $ (50,349) $ 1,613,888 $ 1,563,539 $ 1,073,383 Adjustments to reconcile operating income to cash flows from operating activities: Depreciation 686,787 686,787 568,495 Net effect of changes in Accounts payable 18,770 18,770 273 Cash Flows from Operating Activities 655,208 1,613,888 2,269,096 1,642,151 CASH FLOWS FROM INVESTING ACTIVITIES Decrease in restricted investments 1,718,942 1,718,942 4,326 Interest received 40,085 57,227 97,312 135,774 Cash Flows from Investing Activities 40,085 1,776,169 1,8 16,254 140,100 CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES Contributed capital 99,686 Fixed asset purchases (243,040) (243,040) (130,870) Certificates of Participation. principal payment (14,770,000) (14,770,000) (765,000) Interest paid (749,598) (749,598) (829,388) Cash Flows from Capital and Related Financing Activities (243,040) (15,519,598) (15,762,638) (1,625,572) CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES Operating Transfers In 12,134,212 12,134,212 8,385 Operating Transfers Out (4,671) (4,671) Cash Flows from Noncapital Financing Activities 12,129,541 12,129,541 8,385 Net Cash Flows 452,253 452,253 165,064 Cash and investments, Beginning of Year 571 ,254 571,254 406,190 Cash and investments, End of Year $ 1,023,507 $ $ 1,023,507 $ 571,254 Non-cash investing, capital and financing activities: Contributed fixed assets $ 19,611,189 Write off of bond discount costs $ 471,086 Transfer of fixed assets related to contributed capital $ (5,109,890) Transfer of fixed assets related to retained earnings $ (13,582,46 I) See accompanying notes to financial statements. -13- CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS NOTE #1 - GENERAL The City of Dublin is a residential community with a significant regional commercial base, located in the Tri- Valley area of Alameda County at the crossroads of Interstate Freeways 580 and 680. The City was incorporated as a municipal corporation February 1, 1982; population at January 1, 1999, was 28,707, including prisoners housed at the Alameda County Sheriffs Department Santa Rita Jail and the Federal Correctional Institute. The City operates under the Council-Manager form of government, with five elected Council members served by a full-time City Manager and staff. At June 30, 1999, the City's staff comprised 50 full-time employees who were responsible for City-provided services. In addition, the City employs approximately 30-50 seasonal recreation personnel. The City provides many traditional municipal services through contracts with both public and private entities. Approximately 91 contract employees provide a variety of municipal services from City facilities. I NOTE #2 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES . The following is a summary of significant accounting policies of the City, which conform with generally accepted accounting principles applicable to governments. . A. Reporting Entity . The general-purpose financial statements of the City of Dublin include the financial activities of the City as well as Dublin Information, Inc. (DIT). DIT is a separate legal entity, which assists in providing financing to the City. DIT is governed by the same governing board as the City plus the City Manager and Assistant City Manager and is dependent on the City for its cash flows. The financial activities ofDIT have been aggregated and merged (termed 'blended') with those ofthe City in the Dublin Information, Inc. Enterprise Fund. Since DII's sole business was facilities rental, it accounts for rents as operating revenues. The ownership of assets previously owned by DII was transferred to the City as of February 1, 1999 in conjunction with the early retirement of the 1993 COPs. . . B. Fund Accounting . The accounts of the City are organized on the basis of funds and account groups, each of which is considered a separate accounting entity. The operations of each fund are accounted for with a separate set of self- balancing accounts that comprise its assets, liabilities, fund equity, revenues, and expenditures, or expenses, as appropriate. Government resources are allocated to and accounted for in individual funds based upon the purposes for which they are to be spent and the means by which spending activities are controlled. The various funds are grouped in the general-purpose financial statements as follows: . . . . -14- . CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS NOTE 2 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) . General Fund is the general operating fund of the City. It is used to account for all financial resources except those required to be accounted for in another fund. . Special Revenue Funds are used to account for the proceeds of specific revenue sources (other than major capital projects) that are legally restricted to expenditures for specific purposes. r-- . Capital Projects Funds are used to account for financial resources to be used for the acquisition or construction of maj or capital, facilities (other than those financed by proprietary funds). PROPRIETARY FUND TYPES . Internal Service Funds are used to account for the financing of goods provided by one department or agency to other departments or agencies of the City on a cost-reimbursement basis. . Enterprise Fund is used to account for operations which are financed and operated in a manner similar to private business enterprises where the intent of the governing body is that the costs and expenses, including depreciation, of providing goods or services to the general public on a continuing basis be financed or recovered primarily through user charges; or where the governing body has decided that periodic determination of revenues earned, expenses incurred, and/or net income is appropriate for capital maintenance, public policy, management control, accountability or other purposes. FIDUCIARY FUND TYPE . Agency Funds are used to account for assets held by the City as an agent for individuals, private organizations, other governments and/or other funds, in accordance with the conditions of the agreements. Ag~ncy funds are purely custodial and thus do not involve measurement of results of operations. C. Measurement Focus r-- All governmental funds are accounted for on a spending or financial flow measurement focus, which means that only current assets and current liabilities are generally included on their balance sheets. Their reported fund balance is their net current assets, which is considered only to be a measure of available spendable resources. Governmental fund operating statements present a summary of sources and uses of available spendable resources during a period by presenting increases and decreases in net current assets. ,~ Because of their spending measurement focus, governmental funds exclude fixed assets and non-current liabilities. Instead, these assets and liabilities are reported in the General Fixed Assets Account Group and the General Long-Term Obligations Account Group. These account groups measure only financial position; they are not funds and they do not measure results of operations. They maintain accounting control over the City's governmental fund fixed assets and City debt, which will be repaid by governmental funds. -15- CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS NOTE #2 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) In those cases when a governmental fund records a long-term receivable or other non-current asset, an offsetting credit is made to deferred revenue, or undesignated fund balance is reduced to reflect the fact that this amount is not yet available, Proprietary funds are accounted for on a cost of services or capital maintenance measurement focus, which means that all assets and all liabilities associated with their activity are included on their balance sheets. Their reported fund equity is segregated into contributed capital and retained earnings components, Proprietary fund type operating statements present increases (revenues) and decreases (expenses) in total assets. . In accordance with GASB Statement No, 20, for proprietary fund accounting, the City applies all applicable GASB pronouncements and all applicable F ASB Statements and Interpretations, Accounting Principles Board (APB) Opinions and Accounting Research Bulletins (ARB) issued on or before November 30, 1989, unless those pronouncements conflict with or contradict GASB pronouncements. The City also applies all FASB Statements and Interpretations issued after November 30, 1989, except for those that conflict with or contradict GASB pronouncements. . . D. Fixed Assets. Depreciation. and Long-Term Liabilities . The General Fixed Assets Account Group provides accounting control over the cost of fixed assets used by the City's governmental funds. The General Fixed Assets Account Group is not a fund and its balances are not fmancial resources available for expenditure. Rather, they provide an historical accounting record of resources expended on general fixed assets. Public domain (infrastructure) general fixed assets, which include roads, bridges, curbs and gutters, streets and sidewalks, drainage systems, park land, and lighting systems, have not been capitalized because these assets are immovable and of value only to the public. No depreciation has been provided on general fixed assets. . . . Proprietary fund fixed assets are recorded at cost and depreciated over their estimated useful lives. The purpose of depreciation is to spread the cost of proprietary fund fixed assets over the useful life of these assets. The amount charged to depreciation expense each year represents that year's pro rata share of the cost of proprietary fund fixed assets. . All fixed assets are valued at historical cost or estimated historical cost if actual historical cost is not available. Donated fixed assets are valued at their estimated fair market value on the date donated. . Depreciation of all proprietary fund fixed assets is charged as an expense against operations each year and the total amount of depreciation taken over the years, called accumulated depreciation, is reported on the proprietary funds' balance sheet as a reduction in the book value of the fixed assets. . . . -16- . CITY OF DUBLIN ,-' NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS NOTE #2 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) Depreciation of fixed assets in service is provided using the straight line method which means the cost of the asset is divided by its expected useful life in years and the result is charged to expense each year until the asset is fully depreciated. The City has assigned the useful lives listed below to proprietary fund fixed assets. ,- Buildings Machinery & equipment 37.5 Years 3-15 Years The General Long Term Debt Account Group provides accounting control over the unmatured principal of the City's general long-term debt. This debt will be repaid out of governmental funds but is not accounted for in these funds because this part of the debt does not require an appropriation or expenditure in this accounting period. The two account groups are not funds. They are concerned only with the measurement of financial position. They are not involved with measurement of results of operations. E. Contributeil Capital in Provrietarv Fund Types ,- Contributed capital in proprietary funds represents contributed fixed assets. Contributed capital in the Internal Service Fund increased by $19,108,185 during the year ended June 30, 1999. Enterprise fund contributed capital decreased by $5,109,890 as a result of assets transferred to other funds. F. Basis of Accounting Basis of accounting refers to when revenues and expenditures or expenses are recognized in the accounts and reported in the general-purpose financial statements. Basis of accounting relates to the timing of the measurements made, regardless of the measurement focus applied. All governmental and agency fund types are accounted for using the modified accrual basis of accounting. Their revenues are recognized when they become measurable and available as net current assets. Those revenues susceptible to accrual are property taxes, sales taxes, transient occupancy taxes, interest revenues, and charges for services. Fines, licenses, use of property and permit revenues are not susceptible to accrual because they generally are not measurable until received in cash. -17- CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS NOTE #2 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) Expenditures are generally recognized under the modified accrual basis of accounting when the related fund liability is incurred, except for principal and interest on general long term obligations which is recognized when due. Because of their current financial resources focus, expenditure recognition for governmental fund types excludes amounts represented by non-current liabilities, Since they do not affect net current assets, such long-term amounts are not recognized as governmental fund expenditures or fund liabilities. All proprietary fund types are accounted for using the accrual basis of accounting. Their revenues are recognized when they are earned, and their expenses are recognized when they are incurred. G. Budgets and Budgetarv Accounting The City follows these procedures in establishing the budgetary data reflected in the general-purpose financial statements: . 1. Prior to June 30 the City Manager submits to the City Council a proposed operating budget for the fiscal year commencing the following July 1. The operating budget includes proposed expenditures and the means of financing them. . II 2. The public is given an opportunity to comment on budget at a noticed City Council meeting. 3. Prior to July 1, the budget is legally enacted through passage ofa resolution. . 4. The City Manager is authorized to transfer ,budgeted amounts between line items within any department. Any revisions, which alter total departmental expenditures of the City must be approved by City Council except as follows: The City Manager will be allowed to transfer funds from the contingent reserve to operating departments salary related and health and welfare accounts when required due to employee turnover or change in status, City Council approved funding for increases in employees salaries and benefits, and City Council approved funding for increases in contract or labor rates. Expenditures may not exceed budgeted appropriations at the departmental level without City Council approval. lJ . 5. Formal budgetary integration is employed as a management control device during the year for the general fund, special revenue funds and capital projects funds. . 6. Budgets for the general, special revenue and capital projects funds are adopted on a basis consistent with generally accepted accounting principles. .. 7. All unexpended appropriations lapse at the end of the fiscal year. . 8. Budgeted amounts presented in the [mancial statements are as originally adopted, or as amended by the City Council. Individual amendments were not material in relation to original appropriations. . . -18- . CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS NOTE #2 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) H. Cash Flows Proprietary fund type cash and investments are used in the preparation of the statement of cash flows as investments are not allocated to specific funds. Each of these funds' allocation of pooled cash and investments is considered cash and cash equivalents. I. Deferred Compensation Plan r-..' City employees may defer a portion of their compensation under a City sponsored deferred compensation plan created in accordance with Internal Revenue Code Section 457. Under this plan, participants are not taxed on the deferred portion of their compensation until it is distributed to them; distributions may be made only at termination of employment, retirement, death, or in an emergency as defined by the Plan. In accordance with GASB 32, the City revised the plan to no longer make the funds available to the City's general creditors and accordingly, the City does not report the assets in the financial statements. J. Proverty Tax Alameda County assesses properties and bills, collects, and distributes property taxes to the City. The County remits the entire amount paid and handles all delinquencies. The City receives proportionate shares of prior year collections including retaining interest and penalties. Secured and unsecured property taxes are levied on January 1 of the preceding fiscal year. Secured property tax is due in two installments, on November 1 and March 1, and becomes a lien on those dates. It becomes delinquent on December 10 and April 10, respectively. Unsecured property tax is due on July 1, and becomes delinquent on August 31. The term 'unsecured' refers to taxes on personal property other than real estate, land and buildings. These taxes are secured by liens on the property being taxed. Property tax revenues are recognized by the City in the fiscal year they are assessed provided they become available within 60 days of year-end. K. Accumulated Unpaid General Leave N The City accounts for 100 percent of the liability for accumulated unpaid general leave in the General Fund since the City's policy is to liquidate any unpaid general leave from currently available expendable resources rather than future resources. The City offers its employees general leave benefits, which are composed of time off for illnesses and vacations. Employees receive benefits in the form of time off or in cash if employment with the City ceases. ~ ~ -19- CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS NOTE #2 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (Continued) 1. Post Emplovment Health Care Benefits The City provides certain health care benefits for five retirees as required under a contract signed with PERS. All former employees who retire with the City under PERS are eligible for these benefits. The cost of retiree health care benefits is recognized as an expenditure as premiums are paid. For the year ended June 30, 1999 those costs totaled $16,829. M Total Columns on Combined Financial Statements Although each of the City's funds is a separate accounting entity, the Combined Financial Statements also include total colunms, which are captioned Memorandum Only to indicate that they are presented only to facilitate financial analysis. Data in these columns do not present financial position, results of operations, or !I changes in cash flow in conformity with generally accepted accounting principles. Neither is such data comparable to a consolidation, since no interfund eliminations have been made in the aggregation of this ~L ~ . NOTE #3 - CASH AND INVESTMENTS The City pools cash from all sources and all funds except that held by fiscal agents under debt indentures so that it can be safely invested at maximum yields, consistent with safety and liquidity, while individual funds can make expenditures at any time. . Cash and Investment Summary lIJ! Cash Investments $ 1,952,116 34,706,732 . Total $ 36,658,848 '\ . . IJ!II . . -20- .. CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS (';;.. NOTE #3 - CASH AND INVESTMENTS (Continued) /,"- A. Cash Deoosits and Collateral BANK BALANCE CATEGORY CARRYING 1 2 3 TOTAL AMOUNT Categorized -'- Cash on hand and in banks $101,015 $ 2,602,410 $ 2,703,425 $ 1,757,391 Certificates of Deposit 194,000 194,000 194,000 -.... Total Deposits $295,015 $ $ 2,602,410 $ 2,897,425 1,951,391 . Uncategorized: Petty cash 725 Total Cash $ 1,952,116 California law requires banks and savings and loan institutions to pledge government securities with a market value of 110 percent of the deposit or first trust deed mortgage notes with a value of 150 percent of the deposit, as collateral for all municipal deposits. This collateral places the City ahead of general creditors of the institution. The City has waived collateral requirements for the portion of deposits covered by federal deposit insurance. These categories are as follows: Category 1: Cash on hand or insured by the Federal Deposit msurance Corporation or collateralized with securities held by the City or by its agent in the City's name. Category 2: Collateralized with securities held by the pledging financial institution's trust department or agent in the City's name. Category 3: Uncollateralized - (This includes any bank balance that is collateralized with securities held by the pledging financial institution or by its trust department or agent but not in the City's name). ,;.:~ -21- CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS NOTE #3 - CASH AND INVESTMENTS (Continued) B. Categorization of Credit Risk of Securities Instruments The Governmental Accounting Standards Board (GASB) has issued Statement 31, "Accounting and Financial Reporting for Certain Investments and for External Investment Pools," effective for periods beginning after June 15, 1997. The statement generally applies to investments in external investment pools (State of California LAIF & county treasury investment pools), investments purchased with maturities greater than one year, mutual funds, and certain investment agreements. Generally, governmental entities need to report the "fair value" changes for these investments at year-end and records these gains or losses on their income statement. ~ Methods and assumptions used to estimate fair value: The City maintains investment accounting records on amortized cost and adjusts those records to 'fair value' on an annual basis. The City's investment custodian provides market values on each investment instrument on a monthly basis. The investments held by the City are widely traded in the financial markets and trading values are readily available from numerous published sources. Unrealized gains and losses are recorded on an annual basis and the carrying value of its investments is considered 'fair value'. . . State of California State Treasurer's Local Agency Investment Fund ('LAlF'): The City holds an investment in LAIF that is subject to being adjusted to "fair value". The City is required to disclose its methods and assumptions used to estimate the fair value of its holdings in LAIF. The City relied upon information provided by the State Treasurer in estimating the City's fair value position of its holdings in LAIF. The City had a contractual withdrawal value of $23,098,000 whose pro-rata share of fair value was estimated by the State Treasurer to be $23,067,919. The fair value change in this investment for the year came to an amount that was not material for presentation in the financial statements. . . .. The State Treasurer's Local Agency Investment Fund ("LAIF") is a governmental investment pool managed and directed by the California State Treasurer and is not registered with the Securities and Exchange Commission. An oversight committee, comprised of California State officials and various participants, provide oversight to the management of the fund. The daily operations and responsibilities of LAIF fall under the auspices of the State Treasurer's office. The City is a voluntary participant in the investment pool. . .. . . - - -22- . CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS .l.:.:.>~ NOTE #3 - CASH AND INVESTMENTS (Continued) CATEGORY 2 3 Investments: Categorized US. Government Agency Securities Total Categorized Investments $ REPORTED FAIR AMOUNT VALUE $ 9,868,440 $ 9,868,440 9,868,440 9,868,440 23,098,000 23,098,000 1,585,529 1,585,529 5,000 5,000 149,763 149,763 24,838,292 24,838,292 $ 34,706,732 $ 34,706,732 $ 9,868,440 $ 9,868,440 $ Uncategorized: Local Agency Investment Fund (LAIF) (1) Morgan StanleylDean Witter US, Government Securities Mutual Fund (2) Nations Bank Government Reserves Capital Fund (2) Money Market Fund (2) Total Uncategorized Investments -,"" Grand Total Investments As of June 30, 1999, all investments held by the City are carried at fair value. (1) The management of the State of California Pooled Money Investment Account (generally referred to as LAIF) has indicated to the City that as of June 30, 1999, the carrying amount of the pool was $36,849,505,673 and the fair value for the pool (including accrued interest) was $36,801,515. Included in LAIF's investment portfolio are certain derivative securities or similar products in the form of structured notes, totaling $1.524,350,000 and asset-backed securities, totaling $351,942,000. LAIF's (and the City's) exposure to risk (credit, market or legal) is not currently available. {.:-" The City categorizes its individual securities instruments in ascending order to reflect the relative risk of loss of these instruments. This risk is called Credit Risk, the lower the number, the lower the risk. The three levels of risk prescribed by generally accepted accounting principles are described below: Category 1: Insured or registered for which securities are held by the City or its agent in the City's name. Category 2: Uninsured and unregistered for which securities are held by the counterparty's trust department or agent in the City's name. Category 3: Uninsured and unregistered for which securities are held by the counterparty's trust or its trust department or agent but not in the City's name. (2) Pooled Investments - Pooled investments are not categorized because of their pooled, rather than individual, nature. -23- CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS NOTE #3 - CASH AND INVESTMENTS (Continued) C Authorized Investments The City's investment policy and the California Government Code allow the City to invest in the following types of investments, subject to certain limitations as described in the City's investment policy: Securities ofthe U.S. Government, or its agencies Certificates of Deposit Bankers Acceptances Local Agency Investment Fund (State Pool) Deposits Repurchase Agreements Commercial Paper Mutual Funds "I . D. Market Risk and Investment Maturities t!! The City limits market risk by limiting the types and maturities of its investments and by not borrowing against its investments. Investment yield is ranked after safety and liquidity in making investment decisions. All investments are held to maturity and maturities are matched to the City's projected cash flow needs. - Investments matured as follows at June 30: Available immediately Maturities of one to five years 1999 $ 24,838,292 9,868,440 '. . $ 34,706,732 Total .. E. Return on Investments The City's return on investments comprises only interest income; there were no gains or losses on sales of securities since all were held to maturity. This income is allocated among funds on the basis oftheir average month-end cash and investment balances. . .. . . . -24- . CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS NOTE #4 - INTERFUND TRANSACTIONS r:;;- A, lnterfund Balances During the normal course of business, individual funds may receive or pay amounts for other funds, giving rise to interfund receivables or payables, which are liquidated shortly after year-end. These interfund balances comprised the following at June 30, 1999: Special Revenue Funds: State Transportation Improvement Community Development Block Grant Intermodal Surface Transportation Act $ 1,000 50,000 78,000 129,000 ,..<::"" Capital Project Funds: Traffic Impact fees 5,849 Total $ 134,849 The amounts owed represent General Fund advances for expenditures chargeable to these funds, and will be repaid in the normal course of business in fiscal year 1999. ,I.:';"" -25- CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS NOTE #4 - INTERFUND TRANSACTIONS (Continued) B, Operating Transfers With Council approval, resources may be transferred from one City fund to another. The purpose of the majority of transfers, called operating transfers, is to reimburse a fund, which has made an expenditure on behalf of another fund. Less often, a residual equity transfer may be made to open or close a fund. Operating transfers between individual funds during the fiscal year ended June 30, 1999 are presented below. Most of these transfers were reimbursements of administrative costs or impact fee studies incurred on behalf of the fund making the transfer, The transfer from the General Fund to the Dublin Information Corporation Fund represents the remaining funds needed for the early retirement of the 1993 COPs. The transfer between the . two Park Dedication Funds represents the City's reclassification of the Park Deduction Fund from a Special Revenue Fund to a Capital Projects Fund. Fund Making Transfer General Fund General Fund General Fund Vehicle Abatement Community Development Block Grant Intermodal Surface Transportation Act Housing and Noise Mitigation FEMA Dublin Information Corporation Park Dedication (Special Revenue) Total . Fund Receiving Transfer Amount Dublin Information Corporation Transportation Development Act Storm Water Runoff General Fund General Fund Gas Tax General Fund General Fund General Fund Park Dedication Fees (Capital Projects) $ fI 12,134,212 2,531 82,979 8,315 5,433 44,756 17,587 3,867 4,671 516,154 III r. . $ 12,820,505 .. . . . . '. -26- . CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS -- NOTE #5 - FIXED ASSETS The City makes capital outlays for general fixed assets and for infrastructure. General fixed assets include land, buildings and equipment used in City operations. Depreciation is not provided on general fixed assets since the cost of these assets is accounted for as an expenditure, reducing fund balance in the year they are acquired. Infrastructure includes roads, bridges, curbs, sidewalks, drainage systems, street and traffic lights and other improvements used by all citizens. Expenditures for infrastructure are not capitalized. - Fixed assets balances and activity were as follows: Balance Balance July 1, 1998 Additions Disposals Transfers June 30, 1999 General Fixed Assets Land $ 212,565 $ 212,565 ,...:.. Equipment 1,555,371 $ 8,854 $ (1,320,555) 243,670 Buildings & Improvements 5,932,758 5,932,758 Total $ 7,700,694 $ 8,854 $ $ (1,320,555) $ 6,388,993 Enterprise Fund Civic Center Land $ 6,842,037 $ (6,842,037) Civic Center Building 15,453,847 (15,453,847) Machinery & equipment 422,510 (422,510) Total 22,718,394 (22,718,394) Less accumulated depreciation (4,026,043) 4,026,043 ~ Net Enterprise Fund $ 18,692,351 $ $ $ (18,692,351) $ Internal Service Fund Land $ 6,842,037 $ 6,842,037 Buildings & Improvements 15,453,847 15,453,847 Machinery & equipment $ 866,292 $ 317,298 $ 296,512 1,743,065 2,630,143 Total 866,292 317,298 296,512 24,038,949 24,926,027 Less accumulated depreciation (541,779) (686,787) (296,512) (4,502,018) (5,434,072) Net Internal Service Fund $ 324,513 $ (369,489) $ $ 19,536,931 $ 19,491,955 r ,- -27- CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS NOTE #6 - LONG TERM OBLIGATIONS The City generally incurs long-term debt to fmance projects or purchase assets, which will have useful lives equal to or greater than the related debt. The City's debt issues and transactions are summarized below and discussed in detail subsequently. A. General Long-Term Debt Account Group . Balance Balance July 1, 1998 Additions Retirements June 30, 1999 Bart Long Term Advance $ 1,542,989 $ 90,508 $ 1,633,497 City of Pleasant on 2,683,476 156,122 2,839,598 Alameda County Surplus Property Authority 1,783,235 92,907 1,876,142 Dublin Unified School District 1,004,016 $ 251,004 753,012 Total $ 7,013,716 $ 339,537 $ 251,004 $ 7,102,249 I 'I . BART AlZreement . In 1990, the City and Bay Area Rapid Transit District (BART) entered into a Settlement Agreement regarding the City's extension of Dublin Boulevard to the extension of Hacienda Drive. BART advanced the City $2,285,000 to purchase land and construct the road extensions. The advance was structured with two components; a Short Term and a Long Term Advance. These projects are now complete. .~ . Short Term Advance: The amount provided as a "Short-Term Advance" came due on December 31, 1995. In accordance with a separate agreement, the amount was repaid by the Alameda County Surplus Property Authority. See the related note on the Almeda County Surplus Property Authority long-term debt below. . . Long Term Advance: BART's long term advance to the City, including accrued interest as of June 30, 1999 is $1,633,497, which has no specific due date. Under the City's Agreement with BART, interest on the advance accrues at a rate based on BART's average rate of return on its investments. During the year ended June 30, 1999 unpaid interest incurred was added to the balance owed in the amount of $90,508. The City expects to repay principal and interest on BART's advance out of developer fees, charges and other non-tax revenues generated by future development in the area of the BART station. The agreement states that in no event is the advance to be repaid from the City's General fund or from general revenues. The Agreement provides for the forgiveness by BART of any principal or interest still outstanding on March 27,2010. . . . . -28- . CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS ,-.:;. NOTE #6 - LONG TERM OBLIGATIONS (Continued) City of Pleasanton The City has entered into an agreement with the City of Pleasanton for the reimbursement of the cost of construction of a two-lane access road and the extension of Hacienda Drive. The advance as of June 30, 1999 is $2,839,598, which includes $156,122 interest for the current year. mterest accrues on the reimbursement at 7.48 percent per year. The reimbursement is to be repaid from proceeds of assessments, special taxes or fees imposed on the property east of Dougherty Road with no specific due date. The City's General Fund shall not be obligated to repay this obligation. Alameda County Surplus Property Authority -c.. The City entered into an agreement with Alameda County Surplus Property Authority for the repayment of the City's Short Term BART Advance by the Authority. Under the terms of the agreement with the Authority, interest on the advance shall accrue at a rate based on the Alameda County Treasurers return on investments. As of June 30, 1999 the advance including accrued interest is $1,876,142. The advance is to be repaid from developer fees, charges, and other non-tax revenues from the benefiting area and has no specific due date. The City's General Fund shall not be obligated to repay this obligation. The City has recorded the BART, Alameda County Surplus Authority and the City of Pleasant on advances as general long-term debt at June 30, 1999 because, despite the Agreements' forgiveness clauses, the City is confident there will be sufficient City revenues generated from traffic impact fees levied on new development in the Eastern Dublin Specific Plan Area to repay these advances. Dublin Unified School District The City has entered into an agreement with the Dublin Unified School District to provide construction and annual funding assistance with the maintenance costs of a gymnasium. The City will reimburse the District for part of the cost ofthe construction of the gym in the amount of$I,004,016 in four equal annual payments beginning in Fiscal Year 1998-99. During the year ended June 30, 1999 the first payment of $251 ,004 was made. The reimbursement was repaid out of the General Fund. The remaining balance at June 20, 1999 is $753,012. -29- CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS NOTE #6 - LONG TERM OBLIGATIONS (Continued) B, Enterprise Long- Term Debt 1993 Certificates of Participation Balance Balance July 1, 1998 Additions Retirements June 30, 1999 1993 Certificate of Participation (COP) $14,770,000 $14,770,000 Cost ofIssuance 1993 COP (471,085) (471,085) Total $14,298,915 $ $14,298,915 $ The City leased the Dublin Civic Center building under a lease that could not be cancelled as long as the Certificates of Participation were outstanding. The lease is automatically canceled once all outstanding payments have been made. Under this lease, the City made semi-annual payments, which were sufficient to pay the principal and interest on the 1993 Certificates of Participation. Ownership of the building reverted to the City at the end of the lease. The cost of the building and the balance of the debt evidenced by the 1993 Certificates of Participation had been included in the City's financial statements as this lease was in essence a financing arrangement, with ownership of the financed assets reverting to the City at its conclusion, and was payable from general government resources. The 1993 COPs beared interest at rates of2.8 percent to 5.8 percent, through February 2010, required annual principal payments on February 1 and semi-annual interest payments on February 1 and August I. The COPs could be prepaid without penalty commencing February 1, 1999. During the year ended June 30, 1999, the City elected to repay all the outstanding debt of $14,770,000 on the COPs. Debt service on the COPs were repaid from Dublin Information, Inc, Enterprise Fund revenues. Enterprise fund revenues were comprised primarily oflease payments and transfers from general government resources and interest earnings on the debt service reserve funds held by the trustee. . . , -30- 1 CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS r- NOTE #6 - LONG TERM OBLIGATIONS (Continued) C. Combining Maturitv Schedule - (General Long-Term Debt Account Group and Enterprise DebtJ-' Annual debt service requirements for long term debt are as follows: Alameda County For the Year City of BART Surplus Dublin Unified -- Ending June 30, Pleasanton Agreement Property School District Total 2000 $ 251,004 $ 251,004 2001 251,004 251,004 2002 251,004 251,004 2003 2004 - $ 2,839,598 Thereafter $ 1,633,497 $ 1,876,142 6,349,237 $ 2,839,598 $ 1,633,497 $ 1,876,142 $ 753,012 $ 7,102,249 ,-- D. Special Assessment District Debt The Dublin Boulevard Extension Special Assessment District, formed within City limits, had outstanding debt with a balance of $1 ,978,000 at June 30, 1999. Proceeds of the debt were used to finance improvements within District boundaries. The City has no legal, contingent or moral obligation for the repayment of this debt and acts solely as the collecting and paying agent for the District and activities of the District are reported in the Dublin Boulevard Extension Assessment District Agency Fund. ~ -31- CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS NOTE #7 - FUND BALANCES A. Deficits J The following funds had deficit balances at June 30, 1999: Special Revenue Funds: . Storm Water Runoff $ 76 Dublin Street Light Assessment $ 128 II Capital Projects Funds: Traffic Impact Fee Fund $ 5,849 . The deficit for these funds will be eliminated through future revenues, B. Reserves and Designations . Fund equitJ: consists of reserved and unreserved amounts. Reserved fund equity represents that portion of a fimd balance or retained earnings, which has been appropriated for expenditure or is legally segregated for a specific future use. The remaining portion is unreserved. . A portion of unreserved fund balance may be designated to indicate plans for financial resource use in a future period, such as for general contingencies or capital projects. . Fund balances are reserved as follows: 11 . ReserVe for prepaids is the portion of fund balance set aside to indicate that these items do not represent available, spendable resources even though they are a component of assets. - . Reserve for Non Residential Recycling Programs is the portion of the fund balances set aside for revenue received from the Alameda County Waste Management Authority to be used solely for non residential. recycling. .. . .. . -32- . CITY OF DUBLIN ~ NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS NOTE #7 - FUND BALANCES (Continued) Fund balances designated by City Council are as follows: ,-- · Designated for cemetery endowment is the portion of fund balance to be retained. This represents funds transferred by the Dublin Cemetery Association, when the City acquired the cemetery, Interest on this amount is to be used for maintaining the Dublin Cemetery. In the fiscal year ended June 30, 1999 interest earnings on the endowment funds totaled $3,207. Related cemetery maintenance expenditures net of fees collected were $13,735. Designated for economic uncertainty is the portion of fund balance to be used in the event of economic uncertainty , Designated for authorized expenditures is the portion of fund balance to be used for expenditures approved by Council. NOTE #8 - JOINT POWERS AGREEMENTS r- The City participates in joint ventures with other municipal entities through Joint Powers Agreements (JP As) established under the Joint Exercise of Powers Act of the State of California. Joint Ventures The Cities of Dublin, Pleasanton, and Livermore and the County of Alameda have entered a joint powers agreement, dated September 15, 1992, under which Alameda County constructed an animal shelter facility on county property. Certificates of Participation were issued to construct the facility. Under the agreement the entities will share in the debt service costs of the project based upon their use of the animal shelter. The original total principal portion ofthe scheduled debt is $4,523,877. Dublin's share for the 1998-99 fiscal year, based upon the statistics oflive animals handled in the shelter in calendar year 1996 and 1997, was $25,770 representing 10.55% of the debt service requirements. In addition, $68,701 was paid for the City's share of operating expenses. The City has not recorded an equity interest for the animal shelter agreement. As noted above the ongoing financial interest is limited to the statistics of live animals handled in the appropriate fiscal year. -33- . CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINA..l'lCIAL STATEMENTS . . NOTE #9 - RISK MANAGEMENT . A. Risk Pool The City participates in the ABAG PLAN Corporation, which covers general liability claims in an amount up to $7,000,000 and property insurance coverage to $100,000,000. The City has a deductible or uninsured liability for general liability of up to $50,000 per claim. The deductible for property claims is $5,000 per occurrence, excluding auto claims which have a $10,000 deductible. Once the City's deductible is met ABAG PLAN becomes responsible for payment of all claims up to the limit. During the fiscal year ended June 30, 1999 the City contributed $79,031 current year coverage and received a refund of $37,061 of prior years excess contributions. . . . ABAG PLAN is governed by a board consisting of representatives from member municipalities. The board controls the operations of ABAG PLAN including selection of management and approval of operating budgets, independent of any influence by member municipalities beyond their representation on the Board. .. The City's contributions to ABAG PLAN for liability coverage is based on a formula which considers the ratio of the City's payroll to the total payrolls of all entities participating in the same layer of each program, in each program year's loss history and population. Actual surpluses or losses are shared according to a formula developed from overall loss costs and spread to member entities on a percentage basis after a retrospective rating. . .. There have been no significant reductions in any of the City's insurance coverage and no settlement amounts have exceeded coverage. . Audited financial information for ABAG PLAN can be obtained from ABAG PLAN, P.O. Box 2050, Oakland, CA 94604-2050. . B. Liability for Uninsured Claims-Adoption of GASB 10 . The Governmental Accounting Standards Board (GASB) requires municipalities to record their liability for uninsured claims and to reflect the current portion of this liability as an expenditure in their financial statements. As discussed, above, the City has coverage for such claims, but it has retained the risk for the deductible, or uninsured portion of these claims in the ABAG PLAN. GASB Statement 10, "Financial Reporting for Risk Financing and Related Insurance Issues" require that this amount be separately identified and recorded as a liability. .. . . . . -34- .. CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS NOTE #9 - RISK MANAGEMENT (Continued) The City's liability for uninsured claims, limited to general liability claims as discussed above, includes a provision for IBNR losses. This amount was estimated based on claims experience. Since incorporation in 1982, the City has never had a loss, which exceeded the amount of insurance coverage. The claim liability for the current and prior year are as follows: r--" Beginning balance Provision for claims Claims paid Ending balance June 30, 1999 $ 137,210 4,004 (4,004) $ 137,210 June 30, 1998 $ 137,210 34,828 (34,828) $ 137,210 The City has obtained a workers' compensation insurance policy from the State Compensation Insurance Fund which has no deductible. NOTE #10 - PENSION PLAN A. PERS ,.- Plan Description. The City of Dublin's defined benefit pension plan, (Miscellaneous Plan), provides retirement and disability benefits, annual cost-of-living adjustments, and death benefits to plan members and beneficiaries. The Miscellaneous Plan is part of the Public Agency portion of the California Public Employees Retirement System (CalPERS), an agent multiple-employer plan administered by CalPERS, which acts as a common investment and administrative agent for participating public employers within the State of California. A menu of benefit provisions as well as other requirements are established by State statutes within the Public Employees' Retirement Law. The City of Dublin selects optional benefit provisions from the benefit menu by contract with CalPERS and adopts those benefits through local ordinance or resolution. CalPERS issues a separate comprehensive annual financial report. Copies of the CalPERS's annual financial report may be obtained from the CalPERS Executive Office - 400 P Street - Sacramento, California, 95814. Funding Policy. Active plan members in the Miscellaneous Plan are required to contribute 7 percent of their annual covered salary of which the City pays on behalf of the employees. The City of Dublin is required to contribute the actuarially determined remaining amounts necessary to fund the benefits for its members. The actuarial methods and assumptions used are those adopted by the CalPERS Board of Administration. The required employer contribution rate for Fiscal Year 1998-99 was 4.214 percent for miscellaneous employees. (Dublin has only miscellaneous employees.) The contribution requirements ofthe plan members are established by State statute and the employer contribution rate is established and may be amended by CaIPERS. -35- . CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS . . NOTE #10 - PENSION PLAN (Continued) . Annual Pension Cost. For Fiscal Year 1998-99, the City of Dublin's annual pension cost was $272,816 and was equal to the City's required and actual contributions. The required contribution for Fiscal Year 1998-99 was determined as part of the June 30, 1997, actuarial valuation using the entry age normal actuarial cost method with the contributions determined as a percent of pay. The actuarial assumptions included (a) 8.5 percent investment rate of return (net of administrative expenses); (b) projected salary increases that vary by duration of service ranging from 4.5 percent to 14,95 percent for miscellaneous members; and (c) zero percent cost-of-living adjustment. Both (a) and (b) include an inflation component of 45 percent. The actuarial value of Miscellaneous Plan's assets was determined using a technique that smoothes the effect of short-term volatility in the market value of investments over a two to five year period depending on the size of investment gains and! or losses. Miscellaneous Plan's unfunded actuarial accrued liability (or excess assets) is being amortized as a level percentage of projected payroll on a closed basis. The remaining amortization period ends June 30, 2011. . . . . Three-year Trend Information for Miscellaneous Plan . Fiscal Year Ending 6/30/97 6/30/98 6/30/99 Annual Pension Cost (APe) $149,335 $284,240 $272,816 Percentage of APC Contributed 100% 100% 100% Net Pension Obligation $0 $0 $0 . II Funded Status of Plan Entry Age Actuarial Unfunded Annual Valuation Normal Accrued Value of ( Overfunded) Funded Covered UAALAsa % Date Liability Assets Liability Ratio Payroll of Payroll 6/30/95 $2,097,646 $2,237,209 $(139,563) 106.7% $1,835,767 (7.602)% 6/30/96 $2,421,672 $2,806,415 $(384,743) 115.9% $1,975,983 (19.471)% 6/30/97 $2,808,416 $3,545,415 $(736,999) 126.2% $2,107,245 (34.975)% 6/30/98 $3,305,559 $4,557,898 $(1,252,339) 137.9% $2,444,573 (51.229)% B, Social Security . . ':I " The Onmibus Budget Reconciliation Act of 1990 (OBRA) mandates that public sector employees who are not members of their employer's existing retirement system as of January 1, 1992 be covered by either Social Security or an alternative plan, The City's part-time, seasonal and temporary employees are covered under Social Security, which requires these employees and the City to each contribute 6.2 percent of the employees' pay. . . . .. -36- I CITY OF DUBLIN - NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS r---' I'"- NOTE #11 - COMMITMENT AND CONTINGENT LIABILITIES A. Grant Programs r- The City participates in several Federal and State grant programs. No cost disallowances were proposed as a result the City's financial audit; however, these programs are still subject to further examination by the grantors and the amount, if any, of expenditures which may be disallowed by the granting agencies cannot be determined at this time. The City expects such amounts, if any, to be immaterial. -'- B. Litigation The City is subject to litigation arising in the normal course of business. In the opinion of the City Attorney there is no pending litigation, which is likely to have a material adverse effect on the financial position of the city. C. Developer Agreements Freeway Improve11]ent Agreement >- In 1991, the City of Dublin, the City of Pleasant on and the Alameda County Surplus Property Authority entered into an agreement for the installation of certain off-ramp improvements adjacent to Interstate 580. The improvements to be installed have been completed. The City of Dublin agreed to provide future credits towards development impact fees to the Authority for certain costs related to the installation of the improvements. These costs include the value of right of way needed to install the improvements, the construction cost of the improvements as agreed to in the agreement, and accrued interest on the two aforementioned items. The potential credits are payable from future development impact fees to be collected by the City and amount to $4,428,787, including interest of which the Authority used a total of $1,637,022 generated by this agreement leaving an unused balance of$2,791,765 as of June 30, 1999. The amount due is not recorded as indebtedness since the payment is contingent upon the collection of future development impact fees from development growth, which has not yet occurred. -37- . CITY OF DUBLIN NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS . . NOTE #11 - COMMITMENT AND CONTINGENT LIABILITIES (Continued) . Alameda County Surplus Property Authority Development Agreement In January 1995, the City of Dublin entered into an agreement separate from the agreement discussed in Note 6 of long-term obligations with the Alameda County Surplus Property Authority. The agreement requires the Authority to install certain oversized improvements adjacent to the commercial center project, In exchange for the improvements, the City agreed to provide future credits towards development impact fees to be collected from the Authority. . . The estimated value of the improvements to be installed by the Authority total $3,646,411 of which the Authority used a total of $3,579,284 generated by this agreement leaving an unused balance of $67,127 as ofJune 30, 1999. The amounts due to the County Surplus Property Authority are only payable from the collection of future development impact fees. The amounts due are not recorded as indebtedness since the payments are contingent upon the collection of development impact fees from development growth which has not yet occurred. . . Santa Rita Business Center Agreement '. The Alameda County Surplus Property Authority entered into an agreement with Opus Southwest to develop a 400,000 square foot office/industrial project on approximately 25 acres in the City of Dublin. As required by the Eastern Dublin Specific Plan a development agreement was entered into with the City of Dublin. The City agreed to grant to the Surplus Property Authority Traffic Impact Fee credits in the event that certain road improvements, which the developer would not otherwise have to build, were constructed. The agreement provides that the value of the credits shall not increase for inflation nor shall interest accrue on the amount of the credit. Further limitations were placed on the County as to the amount of credits, which can be applied towards this specific project. The credits may only be applied towards Category 1 portion of the Traffic Improvement Fee. Any unused credits may be used by the Authority on future projects located elsewhere on their property. The valueofthe credits as of June 30, 1999 is $3,581,961 after a total of$105,582 were used as credits during Fiscal Year 1998/99, The accounting for amounts due are not recorded as indebtedness since the payments are contingent upon the collection of the development fees from development growth which has not yet occurred. .. II . . " I . . 't -38- CITY OF DUBLIN - NOTES TO GENERAL PURPOSE FINANCIAL STATEMENTS NOTE #11 - COMMITMENT AND CONTINGENT LIABILITIES (Continued) ~ Reimbursement to City of Pleasanton for Freeway Interchange Work On January 23, 1996, the City of Dublin adopted a fee for the purpose of reimbursing the City of Pleasant on for the costs of making improvements to the interchanges on Interstate 580 at Hacienda Drive and Tassajara Road/Santa Rita Road that benefit development in both Pleasanton and future development in Eastern Dublin. This reimbursement will occur through the assessment of fees on future development projects in the City of Dublin. The Cities entered into an agreement on November 3, 1998 to allow for an automatic annual escalator factor in the amount of the fee assessed to developers based upon the LAIF interest rate and to repay the City of Pleasanton. The amount of the contingent liability outstanding at June 30, 1999 was $6,960,099, which is net of the $811,636 in payments made by the City of Dublin to reduce this contingent liability during the year. The accounting for the amount due is not recorded as indebtedness since future payments are contingent upon the future collection of development fees assessed for reimbursement of these improvements. Other Development Agreements The City of Dublin entered into several agreements with various developers and merchant builders who are developing numerous residential and commercial projects throughout the City. The City agreed to grant the developers impact fee credits since the developers constructed certain improvements beyond what was needed to serve their specific projects. The value of credits do not increase for inflation nor do they accrue interest. Any r- unused credits may be used by the developers on other projects located elsewhere in the City. The value of the credits as ofJune 30, 1999, was $9,082,873 after a total of$962,265 was used as credits during fiscal year 1998- 99. The accounting for the amounts due are not recorded as indebtedness since the payments (use of the credits) are contingent upon the collection of development fees from building growth that has not yet occurred. NOTE #12 - RETAINED EARNINGS ADJUSTMENT During the year ended June 30, 1999, the Dublin Information, Inc. Enterprise Fund contributed $18,692,351 of assets to the Building Replacement Internal Service Fund. The contribution resulted in an adjustment to retained earnings of $13,582,461. -39- . . . . . . . . . This page left blank intentionally. . . . I I .. . I 1 -40- ,..... ,.-. COMBINING FUND STATEMENTS AND SCHEDULES ,- -41- . . . . . . . . . ill This page left blank intentionally. . . . . . , . -42- r-- r- r- CITY OF DUBLIN GENERAL FUND The General Fund is used to account for all financial resources except those required to be accounted for in another fund. -43- . . . . . I!l . I I This page left blank intentionally. . . I . . . , I -44- CITY OF DUBLIN COMPARATIVE BALANCE SHEETS GENERAL FUND .,..- JUNE 30, 1999 (With Comparative Amounts for June 30, 1998) r- 1999 1998 ASSET Cash and investments $ 19,053,270 $ 27,168,133 Receivable: Accounts 1,262,993 822,946 Accrued interest 502,727 468,979 Due from other governments 54,497 Due from other funds 134,849 254,418 Advances to other funds 248,048 r- Prepaids 7,027 8,262 Total Assets $ 20,960,866 $ 29,025,283 LIABILITIES Accounts payable 2,315,825 1,636,429 Accrued wages 98,535 67,915 r- Accumulated unpaid general leave 202,131 197,958 Deposits payable 967,678 636,431 Liability insurance claims payable 137,210 137,210 r- Deferred revenues 149,497 165,501 Due to other governments 21,963 Total Liabilities 3,892,839 2,841,444 - FUND BALANCE Reserved for: Prepaids 7,027 8,262 Advances to other funds 248,048 Unreserved Designated for: r- Cemetery endowment 60,000 60,000 Economic uncertainty 1,369,133 1,369,133 Authorized expenditures 15,631,867 24,498,396 - Total Fund Balance 17,068,027 26,183,839 Total Liabilities and Fund Balance $ 20,960,866 $ 29,025,283 ! r- -45- . CITY OF DUBLIN COMBINING STATEMENT OF REVENUES, EXPENDITURES AND . CHANGES IN FUND BALANCES-BUDGET AND ACTUAL GENERAL FUND FOR THE FISCAL YEAR ENDED JUNE 30, 1999 . (With Comparative Amounts for the Fiscal Year Ended June 30, 1998) 1999 1998 . Variance Favorable Budget Actual (Unfavorable) Actual REVENUES . Property taxes $ 4,856,100 $ 4,866,093 $ 9,993 $ 4,351,858 Taxes other than property 9,587,000 10,209,447 622,447 9,322,899 Licenses and permits 1,876,755 2,472,217 595,462 1,398,677 . Intergovernmental 1,308,420 1,356,234 47,814 1,233,812 Charges for services 3,343,378 3,482,983 139,605 2,483,861 Interest 1,121,000 1,262,400 141,400 1,485,720 . Use of property 104,530 90,539 (13,991) 70,461 Fines and forfeitures 45,950 60,876 14,926 40,421 Other revenue 637,745 250,889 (386,856) 507,052 . Total Revenues 22,880,878 24,051,678 1,170,800 20,894,761 EXPENDITURES WI Current: General government 4,001,109 3,754,145 246,964 3,254,991 Public safety 8,988,348 8,805,457 182,891 8,204,545 Highways and streets 811,440 34,510 . 776,930 650,708 Health and welfare 18,160 16,969 1,191 17,039 Community development 3,696,127 3,606,401 89,726 2,761,132 Culture and leisure 2,597,146 2,248,581 348,565 2,168,993 .. Capital outlay 2,782,674 1,528,154 1,254,520 987,200 Debt Service Principal 251,004 251,004 . Total Expenditures 23,146,008 20,987,641 2,158,367 18,044,608 REVENUES OVER (UNDER) EXPENDITURES (265,130) 3,064,037 3,329,167 2,850,153 . OTHER FINANCING SOURCES (USES) Operating transfers in 39,873 39,873 24,137 . Operating transfers out (12,135,312) (12,219,722) (84,410) (8,385) Total Other Financing Sources (Uses) (12,135,312) (12,179,849) (44,537) 15,752 . REVENUES AND OTHER FINANCING SOURCES OVER EXPENDITURES AND OTHER FINANCING USES $ (12,400,442) (9,115,812) $ 3,284,630 2,865,905 . Fund Balance, Beginning of Year 26,183,839 23,235,797 Prior Period Adjustment 82,137 . Fund Balance, End of Year $ 17,Q68,027 $ 26,183,839 -46- CITY OF DUBLIN SCHEDULE OF BUDGET VERSUS ACTUAL REVENUES BY SOURCE GENERAL FUND FOR THE FISCAL YEAR ENDED JUNE 30, 1999 (With Comparative Amounts for the Fiscal Year Ended June 30, 1998) 1999 1998 Variance Favorable Budget Actual (Unfavorable) Actual Property Taxes Current Year Secured $ 4, II 0,000 $ 4,098,695 $ (11,305) $ 3,649,894 Current Year Unsecured 382,000 418,539 36,539 379,061 Prior Year Secured 120,000 79,062 (40,938) 104,645 Prior Year Unsecured 19,100 13,295 (5,805) 18,708 Supplemental Property Tax 137,000 176,741 39,741 106,111 Pilot Tax 44,000 49,454 5,454 42,649 Property Tax Penalties 44,000 30,307 (13,693) 50,790 Sub-Total 4,856,100 4,866,093 9,993 4,351,858 Taxes Other Than Property Sales & Use Tax 8,200,000 8,687,091 487,091 8,025,447 ;-- Real Property Transfer Tax 235,000 282,733 47,733 231,331 Hotel Transient Occupancy Tax 337,000 389,664 52,664 306,318 Franchise Taxes 815,000 849,959 34,959 759,803 Sub-Total 9,587,000 10,209,447 622,447 9,322,899 Licenxe and Permits Building Permits 1,719,155 2,295,325 576,170 1,259,145 Fire Permits 30,000 20,523 (9,477) 19,645 Animal Licenses 4,600 4,423 (177) 4,599 Encroachment Permits 42,000 57,332 15,332 33,561 Business License 81,000 94,614 13,614 81,727 Suh- Total 1,876,755 2,472,217 595,462 1,398,677 Fines and Forfeitures Parking Fines 30,000 26,651 (3,349) 26,518 Other Court Fines 14,000 31,060 17,060 11,924 Other Fines & Penalties 1,950 3,165 1,215 1,979 - Sub-Total 45,950 60,876 14,926 40,421 Revenue From Use of Money and Property Interest 1,121,000 1,262,400 141,400 1,485,720 Rents & Concession: Sports F aciliti es 42,660 32,751 (9,909) 12,940 Building 47,350 51,920 4,570 45,514 Pool 7,740 1,248 (6,492) 8,547 Heritage Center 6,780 4,620 (2,160) 3,460 Sub-Total 1,225,530 1,352,939 127,409 1,556,181 -47- . CITY OF DUBLIN SCHEDULE OF BUDGET VERSUS ACTUAL . REVENUES BY SOURCE GENERAL FUND FOR THE FISCAL YEAR ENDED JUNE 30, 1999 . (With Comparative Amounts for the Fiscal Year Ended June 30,1998) 1999 1998 . Variance Favorable Budget Actual (Unfavorable) Actual Intergovernmental Revenues - State . Motor Vehicle In-Lieu Tax 1,222,000 1,268,550 46,550 1,150,380 Off Highway Vehicle In-Lieu Fee 420 444 24 415 Homeowner's Property Tax Relief 86,000 87,240 1,240 83,017 . Sub-Total 1,308,420 1,356,234 47,814 1,233,812 Charges for Services . Zoning & Subdivision Fees 672,050 902,600 230,550 477,987 Plan Check & Inspection Fees 1,536,250 1,629,716 93,466 1,116,682 Fire Plan Chk & Insp Fees 102,000 97,886 (4,114) 18,435 Sale of Maps & Documents 11,000 15,633 4,633 10,173 . Special Police Services 17,700 20,246 2,546 17,739 Fire Service Charges 177,325 214,664 37,339 151,112 Park & Recreation Fees: Recreation Instruction 125,500 80,467 (45,033) 151,722 . Preschool 55,200 50,999 (4,201) 48,045 Special Events 89,800 25,596 (64,204) 46,242 Playgrounds 110,800 114,597 3,797 90,130 .. Teens 13,360 6,998 (6,362) 6,687 Adult Sports 57,240 42,120 (15,120) 49,604 Aquatics 103,200 107,242 4,042 97,135 1 Seniors 39,980 24,699 (15,281) 24,200 Youth Sports 49,600 51,096 1,496 36,145 Heritage Center 1,200 35 (1,165) 1,339 Building Use Insurance 4,108 4,093 (15) 3,853 . Zone 7 Drainage Fees 9,400 8,490 (910) 2,873 DUI Program 2,000 3,890 1,890 483 Booking Fees Recovery 6,125 5,331 (794) 5,777 Solid Waste Fee 64,500 70,809 6,309 62,152 Internment Fees 5,540 1,275 (4,265) 4,155 Annexation Services 89,500 4,501 (84,999) 61,191 Sub-Total 3,343,378 3,482,983 139,605 2,483,861 Other Revenues Sale of Real & Personal Property 412,300 14,805 (397,495) 276,098 Contributions 23,020 8,227 (14,793) 16,742 t Miscellaneous 43,600 65,879 22,279 139,854 Reimbursement 152,825 160,305 7,480 68,779 Reimbursement-Public Damage 6,000 1,673 (4,327) 5,579 Sub-Total 637,745 250,889 (386,856) 507,052 Total Revenues By Source $ 22,880,878 $ 24,051,678 $ 1,170,800 $ 20,894,761 -48- CITY OF DUBLIN SCHEDULE OF BUDGET VERSUS ACTUAL DEPARTMENTAL EXPENDITURES GENERAL FUND FOR THE FISCAL YEAR ENDED JUNE 30, 1999 (With Comparative Amounts for the Fiscal Year Ended June 30,1998) 1999 1998 Variance Favorable Budget Actual (Unfavorable ) Actual General government City Council $ 153,]77 $ 145,936 $ 7,241 $ 120,445 City Manager 350,365 331,437 18,928 316,767 City Attorney 310,800 310,558 242 220,439 Administrative Services 743,465 687,654 55,811 623,479 Building management 537,270 531,818 5,452 315,482 Insurance cost center 143,047 125,622 17,425 164,080 Elections cost center 6,415 6,335 80 650 Nondepartmental 37,196 378 36,818 301 Civic Center Debt Service 1,719,374 1,614,407 104,967 1,493,348 Total General Governmental 4,001,109 3,754,145 246,964 3,254,991 Public safety Police 4,505,863 4,505,598 265 4,313,328 Crossing guards 52,887 51,697 1,190 48,728 Animal control 180,700 104,137 76,563 191,931 Disaster preparedness 38,544 35,022 3,522 22,300 Fire Services JP A 4,210,354 4,109,003 101,351 3,628,258 Total Public Safety 8,988,348 8,805,457 182,891 8,204,545 Highways and streets Public works administration 393,130 389,595 3,535 355,586 Street maintenance 141,720 112,085 29,635 55,741 Street tree maintenance 49,990 49,395 595 43,164 Street landscape maintenance 226,600 225,855 745 196,217 Total Highways and Streets 811,440 776,930 34,510 650,708 Health and welfare Child care 12,000 12,000 5,039 Waste management 6,160 4,969 1,191 12,000 ,- Total Health and Welfare 18,160 16,969 1,191 17,039 -49- c- . I . I -50- . CITY OF DUBLIN ,--- SPECIAL REVENUE FUNDS Special Criminal Activity Fund - Established to account for receipt of funds derived from asset forfeitures. Vehicle Abatement Fund - Established to account for the use of funds received from vehicle registration of Dublin residents for the towing of abandoned vehicles in city limits. Supplemental Law Enforcement - Established to account for police expenditures funded by a State grant. Federal Police Grant - Established to account for police expenditures funded by a Federal grant. Traffic Safety Fund - Established to account for the receipt of traffic fines and traffic safety expenditures. State Gas Tax Fund - Established to account for receipt of state gasoline taxes and expenditures, Community Development Block Grant Fund - Used to account for grants and expenditures related to the community development block grants. Intermodal Surface Transportation Efficiency Act Fund - Established to account for receipt of Federal Aid Urban Highway grants. Transportation Development Act Fund - Established to account for Transportation Development Act grant receipts and constructions expenditures for bike paths and access ramps for the handicapped. FEMA Fund - Established to account for expenditures funded with FEMA grants. Park Dedication Fund - Established to account for park dedication fees received in lieu of property from developers pursuant to the Quimby Act. ,- Sales Tax Measure B Fund - Established to account for an Alameda County voter approved increase in sales tax used for improvements on streets and roads. - State Transportation Improvement - Established to account for grant receipts from the state used for capital improvements on local streets. SB300 Grant Fund - Established to account for grant receipts from the State used for capital improvements on local streets. Measure D Recycling Fund - Established to account for the use of funds received which are levied by the County pursuant to a charter amendment and are provided for recycling and related activities. Garbage Service Fund - Established to account for the use of funds received which are levied by the county for garbage pick-up and removal and recycling services. -51- . CITY OF DUBLIN SPECIAL REVENUE FUNDS (Continued) . . Storm Water Runoff Fund - Established to account for the use of funds received from fees collected to mitigate pollution within the City without specific sources and to comply with Federal requirements for National Pollution Discharge Elimination System (NPDES). . EMS Tax Fund - Established to account for excise taxes received to fund the costs of providing Emergency Medical Services. . Maintenance Districts - Established to account for revenue and related expenditures of lighting and landscape activities. . . . . . . . . . . . I . -52- This page left blank intentionally. ,- -53- . CITY OF DUBLIN COMBINING BALANCE SHEET SPECIAL REVENUE FUNDS JUNE 30, 1999 (With Comparative Amounts for June 30, 1998) . . II Special Supplemental Federal Criminal Vehicle Law Police Traffic Activity Abatement Enforcement Grant Safety . ASSET . Cash and investments $ 7,498 $ 54,743 $ 19,520 $ 41 $ 35,448 Receivable: Accounts 5,746 . Due from other governments Total Assets $ 7,498 $ 54,743 $ 19,520 $ 41 $ 41,194 . LIABILITIES 1 Accounts payable 18,111 1,778 Deferred revenues .. Due to other funds . Total Liabilities 18,111 1,778 FUND BALANCE . Reserved for non-residential programs Unreserved . Designated for: Authorized expenditures 7,498 54,743 1 ,409 41 39,416 Undesignated . Total Fund Balance 7,498 54,743 1 ,409 41 39,416 . Total Liabilities and Fund Balance $ 7,498 $ 54,743 $ 19,520 $ 41 $ 41,194 -54- State Gas Tax $ 1,268,387 $ $ 1,268,387 160,128 160,128 1,108,259 I, I 08,259 $ 1,268,387 $ Community Development Block Grant 51,690 $ 51,734 $ 1,734 50,000 51,734 51,734 $ 44 $ Intennodal Surface Transportation Efficiency Act 77,381 78,000 $ 78,000 78,000 78,000 $ Transportation Development Act 619 -55- FEMA $ $ $ Park Dedication 667 667 $ 667 667 667 $ Sales Tax Measure B $ 72,649 $ 72,649 47,934 47,934 24,715 24,715 $ 72,649 State Transportation Improvement $ 689 311 $ 1,000 1,000 1,000 $ 1,000 (Continued) CITY OF DUBLIN COMBINING BALANCE SHEET (Continued) SPECIAL REVENUE FUNDS JUNE 30, 1999 (With Comparative Amounts for June 30, 1998) . . . -56- ,- San Ramon Road Specific Plan $ $ Street Lighting $ 154,954 $ 1,549 $ 156,503 10,424 10,424 146,079 146,079 $ 156,503 MAINTENANCE DISTRICTS Dougherty Landscape & Lighting Stagecoach Landscape 62,463 $ $ 62,875 $ 6,796 6,796 56,079 56,079 $ 62,875 $ 86,689 $ 412 87,015 $ 7,340 7,340 79,675 79,675 87,015 $ 326 Santa Rita Assessment District 97-1 27,740 27,740 $ 27,099 27,099 27,740 $ -57- Dublin Street Light Assessment 641 $ 641 (128) (128) TOTALS 1999 1998 $ 2,117,483 136,156 78,048 $ $ 2,272,085 161,073 145,278 2,331,687 $ 2,578,436 128 350,357 129,000 128 479,357 79,887 1,772,647 (204) 1,852,330 $ 238,985 3,548 254,418 496,951 55,940 2,025,545 2,081,485 2,331,687 $ 2,578,436 . CITY OF DUBLIN COMBINING STATEMENT OF REVENUES, EXPENDITURES AND . CHANGES IN FUND BALANCE SPECIAL REVENUE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1999 . (With Comparative Amounts for the Fiscal Year Ended June 30, 1998) Special Supplemental Federal . Criminal Vehicle Law Police Traffic Activity Abatement Enforcement Grant Safety REVENUES . Taxes other than property Intergovernmental $ 21,429 $ 62,569 Charges for services Interest $ 200 2,606 2,205 $ 200 $ 1,002 Fines and forfeitures 65,858 . Developer fees Other revenue 4,722 Special assessments . Total Revenues 4,922 24,035 64,774 200 66,860 EXPENDITURES Current: Public safety . Police 63,761 14,684 Emergency medical Traffic signals and street lights 31,890 Highways and streets . Public works administration Street tree maintenance Street sweeping. Street landscaping maintenance . Street maintenance Health and welfare Waste management Senior Support . Culture and leisure - Park Maintenance Community development - Engineering Capital outlay Community Improvement . Parks Street Projects Total Expenditures 63,761 14,684 31,890 . REVENUES OVER (UNDER) EXPENDITURES 4.922 24,035 1.013 (14,484) 34,970 OTHER FINANCING SOURCES (USES) Operating transfers in Operating transfers out (8,315) Total Other Financing Sources (Uses) (8,315) REVENUES AND OTHER FINANCING SOURCES OVER EXPENDITURES AND . OTHER FINANCING USES 4,922 15,720 1,013 (14,484) 34,970 Fund Balance, Beginning of Year 2,576 39,023 396 14.525 4,446 Fund Balance, End of Year $ 7,498 $ 54,743 $ 1,409 $ 41 $ 39,416 -58- Community Intermodal Surface Transportation Sales Tax State State Development Transportation Development Park Measure Transportation Gas Tax Block Grant Efficiency Act Act FEMA Dedication B Improvement $ 172,561 $ 526,536 $ 68,859 $ 301,058 $ 37,323 $ 4,534 $ 311 55,317 7,015 .- 581 ,853 68,859 301.058 37,323 4,534 179,576 311 40,586 262,130 ~ 7,044 16,227 168 56,382 39,854 52,400 256,302 250,755 311 371,511 63,426 256,302 39,854 250,755 311 210,342 5.433 44,756 (2,531) 4,534 (71,179) 44,756 2,531 (5,433) (44,756) (3,867) (516,154) 44,756 (5,433) (44,756) 2,531 (3,867) (516,154) 255,098 667 (516,154) (71,179) 853,161 516,154 95,894 $ 1,108,259 $ $ $ $ 667 $ $ 24,715 $ (Continued) -59- . CITY OF DUBLIN COMBINING STATEMENT OF REVENUES, EXPENDITURES AND . CHANGES IN FUND BALANCE (Continued) SPECIAL REVENUE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1999 II (With Comparative Amounts for the Fiscal Year Ended June 30, 1998) Storm II SB 300 Measure D Garbage Water Grant Recycling Service Runoff EMS REVENUES Taxes other than property $ 76,685 . Intergovernmental $ 104,936 $ 144,008 5,238 Charges for services $ 705,227 $ 1,763 Interest 14,831 9,092 493 409 . Fines and forfeitures Developer fees Other revenue 17,718 Special assessments .. Total Revenues 104,936 176,557 714,319 2,256 82,332 EXPENDITURES Current: Public safety . Police Emergency medical 81,444 Traffic signals and street lights Highways and streets . Public works administration Street tree maintenance Street sweeping 81,727 Street landscaping maintenance . Street maintenance 3,791 Health and welfare Waste management 109,236 718,450 Senior Support . Culture and leisure - Park Maintenance Community development - Engineering 38,167 Capital outlay Community Improvement . Parks 11,447 Street Projects 104,936 Total Expenditures 104,936 120,683 718,450 123,685 81,444 REVENUES OVER (UNDER) EXPENDITURES 55,874 (4,131) (121,429) 888 OTHER FINANCING SOURCES (USES) Operating transfers in 82,979 Operating transfers out Total Other Financing Sources (Uses) 82,979 REVENUES AND OTHER FINANCING SOURCES OVER EXPENDITURES AND OTHER FINANCING USES 55,874 (4,131) (38,450) 888 Fund Balance, Beginning of Year 233,328 20,895 38,374 Fund Balance, End of Year $ $ 289,202 $ 16,764 $ (76) $ 888 -60- MAINTENANCE DISTRICTS San Ramon Dougherty Santa Rita Dublin Street TOTALS Road Specific Street Stagecoach Landscape Assessment Light Plan Lighting Landscape & Lighting District 97-1 Assessment 1999 1998 $ 249,246 $ 240,796 1,276,80] 925,797 706,990 7]5,254 $ 7,37] $ 2,899 $ 4,70] $ ],41] 109,752 1]4,694 65,858 30,596 230,620 2,736 25,176 20,908 ]42,183 54,832 56,095 65 253,175 276,346 ]52,290 57,73] 60,796 ].476 2,686,998 2,555,0] ] 78,445 87,354 81,444 79,808 $ 939 106,585 180,000 194,923 ],922 72 71 ]82 2,247 3,579 ],938 5,756 7,694 4,085 81,727 78,540 4],855 63,]56 64] 105,652 103,583 265,921 249,795 827,686 740,896 7,044 7,044 3,604 1,813 533 536 75 128 57,479 59,862 56,550 252,912 51,301 95,433 664,704 343,692 939 110,320 44,398 69,519 898 ]28 2,467,894 2,305,110 (939) 41,970 13,333 (8,723) 578 (128) 219,104 249,901 130,266 (578,525) (9,468) (448,259) (9 ,468) (939) 41,970 13,333 (8,723) 578 (128) (229,]55) 240,433 939 ]04,]09 42,746 88,398 26,52] 2,08] ,485 1,841,052 $ $ 146,079 $ 56,079 $ 79,675 $ 27,099 $ (128) $ 1,852,330 $ 2,081,485 -61- . CITY OF DUBLIN COMBINING STATEMENT OF REVENUES, EXPENDITURES AND . CHANGES IN FUND BALANCE - BUDGET AND ACTUAL BUDGETED SPECIAL REVENUE FUNDS FOR TIlE FISCAL YEAR ENDED JUNE 30, 1999 . Special . Criminal Vehicle Activity Abatement Variance Variance Favorab]e Favorable . Budget Actual (Unfavorable ) Budget Actual (Unfavorable) REVENUES Taxes other than property Intergovernmental $ 1],000 $ 21,429 $ 10,429 . Charges for services Interest $ 200 $ 200 2,200 2,606 406 Fines and forfeitures Other revenue $ 2,000 4,722 2,722 . Special assessments Total Revenues 2,000 4,922 2,922 13,200 24,035 10,835 EXPENDITURES . Current: Public safety Police 768 768 Emergency medical . Traffic signals and street lights Highways and streets Public works administration Street tree maintenance . Street sweeping Street landscaping maintenance Street maintenance Health and welfare . Waste management Senior Support Community development - Engineering Capital outlay . Community Improvement Parks Street Projects . Total Expenditures 768 768 REVENUES OVER (UNDER) EXPENDITURES 1,232 4,922 3,690 13,200 24,035 10,835 OTHER FINANCING SOURCES (USES) . Operating transfers in Operating transfers out (8,315) (8,315) Total Other Financing Sources (Uses) (8,315) (8,315) . REVENUES AND OTHER FINANCING SOURCES OVER EXPENDITURES AND OTHER FINANCING USES $ 1,232 4,922 $ 3,690 $ 13,200 15,720 $ 2,520 Fund Balance, Beginning of Year 2,576 39,023 . Fund Balance, End of Year $ 7,498 $ 54,743 . . -62- . Supplemental Federal Law Police Traffic Enforcement Grant Safety Variance Variance Variance Favorable Favorable Favorable Budget Actual (Unfavorable ) Budget Actual (Unfavorable ) Budget Actual (Unfavorable ) $ 61,394 $ 62,569 $ 1,175 2,205 2,205 $ 200 $ 200 $ 1,002 $ 1,002 $ 42,400 65,858 23,458 42,400 66,860 24,460 61,394 64,774 3,380 200 200 63,820 63,761 59 $ 14,856 14,684 172 40,450 31,890 8,560 63,820 (2,426) 63,761 1,013 59 3,439 14,856 (14,856) 14,684 (14,484) 172 372 40,450 1,950 31,890 34,970 8,560 33,020 $ 1,950 34,970 4,446 $ 39,416 $ 33,020 $ 3,439 $ (14,856) (14,484) $ 14,525 372 $ (2,426) ],013 396 1,409 $ $ 41 (Continued) -63- . CITY OF DUBLIN COMBINING STATEMENT OF REVENUES, EXPENDITURES AND . CHANGES IN FUND BALANCE - BUDGET AND ACTUAL (Continued) BUDGETED SPECIAL REVENUE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1999 . Community . State Development Gas Tax Block Grant Variance Variance Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) . REVENUES Taxes other than property Intergovernmental $ 514,200 $ 526,536 $ 12,336 $ 74,193 $ 68,859 $ (5,334) Charges for services . Interest 53,575 55,317 1,742 Fines and forfeitures Other revenue Special assessments . Total Revenues 567,775 581,853 14,078 74,193 68,859 (5,334) EXPENDITURES . Current: Public safety Police Emergency medical . Traffic signals and street lights 64,300 40,586 23,714 Highways and streets Public works administration Street tree maintenance . Street sweeping Street landscaping maintenance Street maintenance 268,524 262,130 6,394 Health and welfare . Waste management Senior Support 7,044 7,044 Community development - Engineering 16,678 16,227 451 Capital outlay II Community Improvement 200 168 32 60,549 56,382 4,167 Parks Street Projects 52,498 52,400 98 I Total Expenditures 402,200 371,511 30,689 67,593 63,426 4,167 REVENUES OVER (UNDER) EXPENDITURES 165.575 210,342 44,767 6,600 5,433 (1,167) OTHER FINANCING SOURCES (USES) . Operating transfers in 44,756 44,756 Operating transfers out (5,433) (5,433) Total Other Financing Sources (Uses) 44,756 44,756 (5,433) (5,433) . REVENUES AND OTHER FINANCING SOURCES OVER EXPENDITURES AND OTHER FINANCING USES $ 165,575 255,098 $ 89,523 $ 6,600 $ (6,600) Fund Balance, Beginning of Year 853,161 . Fund Balance, End of Year $ 1,108,259 $ I I -64- I Intermodal Surface Transportation Transportation Development Efficiency Act Act FEMA Variance Variance Variance Favorable Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable ) Budget Actual (Unfavorable ) $ 256,302 $ 301,058 $ 44,756 $ 68,867 $ 37,323 $ (31,544) $ 4,534 $ 4,534 ~ 256,302 301.058 44,756 68,867 37,323 (31,544) 4,534 4,534 ...- "'- ,..>",,"- 47,000 39,854 7,146 .-, 256,302 256,302 256,302 256,302 47,000 39,854 7,146 44,756 44,756 21,867 (2,531) (24,398) 4,534 4,534 2,531 2,531 , ' (44,756) (44,756) (3,867) (3,867) (44,756) (44,756) 2,531 2,531 (3,867) (3,867) $ $ $ 21,867 $ (21,867) $ 667 $ 667 $ $ $ 667 .---. (Continued) -65- . CITY OF DUBLIN COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL (Continued) BUDGETED SPECIAL REVENUE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1999 . - Sales Tax . Park Measure Dedication B Variance Variance Favorable Favorable . Budget Actual (Unfavorable) Budget Actual (Unfavorable) REVENUES Taxes other than property $ 175,500 $ 172,561 $ (2,939) Intergovernmental . Charges for services Interest 7,015 7,015 Fines and forfeitures Other revenue . Special assessments Total Revenues 175,500 179,576 4,076 EXPENDITURES .- Current: Public safety Police Emergency medical . Traffic signals and street lights Highways and streets Public works administration Street tree maintenance 1.'1 Street sweeping Street landscaping maintenance Street maintenance '\ Health and welfare l!!lIl Waste management Senior Support Community development - Engineering Capital outlay . Community Improvement Parks Street Projects 250,913 250,755 158 . Total Expenditures 250,913 250,755 158 REVENUES OVER (UNDER) EXPENDITURES (75,413) (71,179) 4,234 OTHER FINANCING SOURCES (USES) . Operating transfers in Operating transfers out (516,154) (516,154) Total Other Financing Sources (Uses) (516,154) (516,154) . REVENUES AND OTHER FINANCING SOURCES OVER EXPENDITURES AND OTHER FINANCING USES $ (516,154) $ (516,154) $ (75,413) (71,179) $ 4,234 Fund Balance, Beginning of Year 516,154 95,894 21 Fund Balance, End of Year $ $ 24,715 .. . -66- . State Transportation SB 300 Measure D Improvement Grant Recycling ..-- Variance Variance Variance Favorable Favorable Favorable Budget Actual (Unfavorable ) Budget Actual (Unfavorable) Budget Actual (Unfavorable ) ~:: $ 740,000 $ 31 I $ (739,689) $ 104,936 $ 104,936 $ 140,000 $ 144,008 $ 4,008 11 ,880 14,831 2,951 17,718 17,7]8 ....j, 740,000 311 (739,689) 104,936 104,936 151,880 176,557 24,677 ~. 1""";";;' 146,835 109,236 37,599 ~ 12,403 11,447 956 740,000 311 739,689 104,936 104,936 740,000 311 739,689 104,936 104,936 159,238 (7,358) 120,683 55,874 38,555 63,232 $ (7,358) 55,874 233,328 $ 289,202 $ 63,232 $ $ $ $ $ $ (Continued) ,.~.- '-' -67- . CITY OF DUBLIN COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL (Continued) BUDGETED SPECIAL REVENUE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1999 .. . . -68- 11II San Ramon Road Speci tic Street EMS Plan Lightin,; Variance Variance Variance Favorable Favorable Favorable Bud,;et Actual (Unfavorable) Bud,;et Actual (Unfavorable ) Budget Actual (Unfavorable) ..., "<1 $ 76,680 $ 76,685 $ 5 5,065 5,238 173 409 409 $ 5,500 $ 7,371 $ 1,871 r- 2,000 2,736 736 145,800 142,183 (3,617) 81,745 82,332 587 ] 53,300 ]52,290 (1,010) 81,745 81,444 301 $ 1,000 $ 939 $ 61 130,987 106,585 24,402 /~ 3,914 1,922 1,992 ~ 2,110 1,813 297 81,444 888 301 888 1,000 (1,000) 939 (939) 61 61 137,011 16,289 11 0,320 41,970 26,691 25,681 81,745 /-'--- (939) $ 939 61 $ 16,289 41,970 104,109 $ 146,079 $ 25,681 $ 888 $ 888 $ (1,000) .--_'1... $ 888 $ (Continued) --'" -69- . CITY OF DUBLIN COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL (Continued) BUDGETED SPECIAL REVENUE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1999 . . Dougherty . Stagecoach Landscape Landscape & LiJ;btin,; Variance Variance Favorable Favorable . Bud,;et Actual (Unfavorable) Budget Actual (Unfavorable) REVENUES Taxes other than property Intergovernmental . Charges for services Interest $ 1,600 $ 2,899 $ 1,299 $ 3,200 $ 4,701 $ 1,501 Fines and forfeitures Other revenue -YI!' Special assessments 54,640 54,832 192 54,140 56,095 1,955 Total Revenues 56,240 57,731 l,491 57,340 60,796 3,456 EXPENDITURES . Current: Public safety Police Emergency medical . Traffic signals and street lights Highways and streets Public works ad'!linistration 105 72 33 105 71 34 Street tree maintenance 2,160 1,938 222 6,020 5,756 264 . Street sweeping Street landscaping maintenance 51,520 41,855 9,665 64,250 63,156 1,094 Street maintenance Health and welfare ~ Waste management Senior Support .-*"'~ Community development - Engineering 660 533 127 770 536 234 Capital outlay .. Community Improvement Parks Street Projects .. Total Expenditures 54,445 44,398 10,047 71,145 69,519 1.626 REVENUES OVER (UNDER) EXPENDITURES 1,795 13,333 11,538 (13,805) (8,723) 5.082 OTHER FINANCING SOURCES (USES) 'If Operating transfers in Operating transfers out ;#' Total Other Financing Sources (Uses) . REVENUES AND OTHER FINANCING SOURCES OVER EXPENDITURES AND OTHER FINANCING USES $ 1,795 13,333 $ 11,538 $ (13,805) (8,723) $ 5,082 . Fund Balance, Beginning of Year 42,746 88,398 Fund Balance, End of Year $ 56,079 $ 79,675 . . -70- . Budget Actual Variance Favorable (Unfavorable) Budget Dublin Street Light Assessment Total Variance Variance Favorable Favorable Actual (Unfavorable ) Budget Actual (Unfavorable ) $ 252, 180 $ 249,246 $ (2,934) 1,975,957 1,276,801 (699,156) 698,080 706,990 8,910 78,555 109,752 31,197 42,400 65,858 23,458 4,000 25,176 21,176 254,580 253,175 (1,405) 3,305,752 2,686,998 (618,754) ':"'... Santa Rita Assessment District 97-1 $ 1,411 $ 1,411 65 65 1,476 1,476 79,444 78,445 999 81,745 81,444 301 236,737 180,000 56,737 605 182 423 4,729 2,247 2,482 1,920 1,920 10,100 7,694 2,406 90,070 81,727 8,343 .- 13,000 641 12,359 128,770 105,652 23,118 273,624 265,921 7,703 865,499 827,686 37,813 c..~,;> 7,044 7,044 440 75 365 500 128 372 59,558 57,479 2,079 60,749 56,550 4,199 59,403 51,301 8,102 1,404,649 664,704 739,945 15,965 898 15,067 500 128 372 3,362,121 2,467,894 894,227 (15,965) 578 16,543 (500) (128) 372 (56,369 ) 219,104 275,473 130,266 130,266 ~... (578,525) (578,525) (448,259) (448,259) $ (15,965) 578 $ 16,543 $ (500) (128) $ 372 $ (56,369) (229,155) $ ( I 72,786) 26,52 I 2,081,485 "'-" $ 27,099 $ (128) $ 1,852,330 -71- . , . II .. . '~ . . This page left blank intentionally. .. . . . I[Il . .. .. .. -72- . CITY OF DUBLIN CAPITAL PROJECTS FUNDS Traffic Impact Fees Fund - To account for impact fees received from developers of properties, which can only be used for the design, development, and construction of street projects within the City. Public Facilities Fees Fund - To account for impact fees received from developers of properties, which can only be used for the design, development, and construction of new public facilities within the City. Park Dedication Fees Fund - To account for park dedication fees received in lieu of property from developers pursuant to the Quimby Act. Fire Impact Fees Fund - To account for impact fees received from developers of properties, which can only be used for the design, development and construction of fire capital expansion projects within the City. Housing and Noise Mitigation Fees Fund - To account for impact fees received from developers of properties, which only can be used for the design, development, and construction of citywide affordable housing projects and noise mitigation projects in Eastern Dublin. L' ~'" -73- CITY OF DUBLIN COMBINING BALANCE SHEET CAPITAL PROJECTS FUNDS JUNE 30, 1999 (With Comparative Amounts for June 30, 1998) -74- . , . '~ . . . . .. )---- ~ Housing and Noise Totals (- Mitigation 1999 1998 ,~ $ 1,948,613 $ 14,123,343 $ 6,826,968 248,048 r'-"" $ 1,948,613 $ 14,123,343 $ 7,075,016 ---' 336,924 196,628 1,948,613 13,338,261 6,878,388 5,849 248,048 - I 1,948,613 13,681,034 7,323,064 ~ 448,158 (5,849) (248,048) 442,309 (248,048) $ 1,948,613 $ 14,123,343 $ 7,075,016 ;--.~ r- -75- '" all . -76- . Housing and TOTALS Noise Mitigation 1999 1998 $ 17,732 $ 2,257,955 $ 615,328 17,732 2,257,955 615,328 690,357 56,659 (248,048) (304,707) $ $ 442,309 $ (248,048) -. -77- . CITY OF DUBLIN COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL BUDGETED CAPITAL PROJECTS FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1999 . . . -78- , Park Fire Housing and Dedication Impact Noise r;.c... Fees Fees Mitigation Variance Variance Variance Favorable Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) Budget Actual (Unfavorable) $ 29,075 137,810 $ (29,075) (56,154) $ 123,719 $ 17,732 $ (105,987) $ 81,656 ,- (105,987) 166,885 81,656 (85,229) 123,719 17,732 16,226 145 16,081 94,024 94,024 195,904 149,652 46,252 r- 195,904 149,652 46,252 110,250 145 110,105 (29,019) (67,996) (38,977) 13,469 17,587 4,118 516,154 516,154 (17,587) (17,587) 516,154 516,154 (17,587) (17,587) $ (29,019) 448,158 $ 477,177 $ $ $ 13,469 $ (13,469) ,- $ 448,158 $ $ (Continued) -79- . CITY OF DUBLIN COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE - BUDGET AND ACTUAL (Continued) BUDGETED CAPITAL PROJECTS FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1999 . . . -80- . ~ r- ~ ,..- r- ,-= CITY OF DUBLIN INTERNAL SERVICE FUNDS Internal Service funds are used to account for the financing of goods or services provided by one department or agency to other departments or agencies of the City on a cost reimbursement basis. The City has established three of these types of funds: Equipment Replacement, Building Replacement, and Fire Equipment and Building Replacement. -81- . . . . . . .. . . This page left blank intentionally. . . . .. If . . . .. -82- . CITY OF DUBLIN COMBINING BALANCE SHEET INTERNAL SERVICE FUNDS JUNE 30, 1999 (With Comparative Amounts for June 30, 1998) Fire Equipment Equipment and Station Building Totals Replacement Replacernent Replacement 1999 1998 ASSET Cash and investments $ 544,282 $ 283,005 $ 196,220 $ 1,023,507 $ 571,254 Fixed Assets 458,027 753,680 18,280,248 19,491,955 324,513 Total Assets $ 1,002,309 $ l,036,685 $ 18,476,468 $ 20,515,462 $ 895,767 LIABILITIES Accounts payable 20,806 20,806 2,036 Total Liabilities 20,806 20,806 2,036 FUND EQUITY Contributed capital 563,112 753,680 18,280,248 19,597,040 488,855 Retained earnings Reserved for equipment replacement 418,391 283,005 196,220 897,616 404,876 Total Fund Equity 981,503 1,036,685 18,476,468 20,494,656 893,73l r- Total Liabilities and Fund Equity $ 1,002,309 $ 1,036,685 $ 18,476,468 $ 20,515,462 $ 895,767 ,.-. ..- ,....,. -83- . I . I I -84- , CITY OF DUBLIN COMBINING STATEMENT OF CASH FLOWS INTERNAL SERVICE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1999 (With Comparative Amounts for the Fiscal Year Ended June 30, 1998) TOTALS Fire Equipment (Memorandum Only) Equiprnent and Station Building Replacement Replacement Replacement 1999 1998 CASH FLOWS FROM OPERATING ACTIVITIES Operating income (Joss) $ (14,344) $ 185,690 $ (221,695) $ (50,349) $ 13,294 Adjustments to reconcile operating income to cash flows from operating activities: Depreciation l83,783 90,901 412,103 686,787 156,392 Net effect of changes in Accounts payable 18,770 18,770 273 ~ Cash Flows from Operating Activities 188,209 276,591 190,408 655,208 169,959 CASH FLOWS FROM INVESTING ACTMTIES Interest received 27,859 6,414 5,812 40,085 26,289 Cash Flows from Investing Activities 27,859 6,414 5,812 40,085 26,289 CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES Contributed capital 99,686 Fixed asset purchases (243,040) (243,040) (130,870) r- Cash Flows from Capital and Related Financing Activities (243,040) (243,040) (31,184) Net Cash Flows (26,972) 283,005 196,220 452,253 165,064 Cash and investments at Beginning of Year 571,254 571 ,254 406,190 Cash and investments at End of Year $ 544,282 $ 283,005 $ 196,220 $ 1,023,507 $ 571,254 Non-cash investing, capital and financing activities: Contributed fixed assets $ 74,258 $ 844,580 $ 18,692,351 $ 19,611,189 ~. .-- -85- . 11) . . . . . . . This page left blank intentionally. . . . , ill . . .. -86- CITY OF DUBLIN AGENCY FUND Agency funds are used to account for assets held by the City in a fiduciary capacity for individuals, governmental entities and others. These funds carry out the specifications of trust indentures, ordinance or other regulations. Dublin Boulevard Extension Assessment District Fund - To account for the special assessment established to fund the improvements to Dublin Boulevard. r= ,..- -87- . . . . . . . . . This page left blank intentionally. . . . . . . . . . -88- . CITY OF DUBLIN COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES AGENCY FUND FOR THE FISCAL YEAR ENDED JUNE 30, 1999 Balance Balance June 30, 1998 Additions Reductions June 30, 1999 Dublin Boulevard Extension Assessment District ASSET ,- Cash and Investments $ 181,664 $ 241,683 $ 231 ,865 $ 191,482 Restricted cash and investments 143,577 6,186 149,763 Accounts Receivable 440 440 Total Assets $ 325,241 $ 248,309 $ 231,865 $ 341,685 LIABILITY ;;,..-- Due to bondholders $ 325,241 $ 248,309 $ 231,865 $ 341,685 .- -89- . . . . . . . . . This page left blank intentionally. . .. . tI .. . . . . -90- I CITY OF DUBLIN YEAR 2000 ISSUES (Unaudited) JUNE 30, 1999 ,- The year 2000 issue is the result of shortcomings in many electronic data-processing and other equipment that may adversely affect the operation of such systems and equipment in the year 1999 and beyond, The issue arises due to many programs' inability to distinguish between the year 1900 and the year 2000, as many programmers eliminated the first two digits from a year when writing programs. Issues affecting a wide range of activities could result if computers and other equipment that are dependent upon date-sensitive coding are not corrected The City has completed an inventory of computer systems and other electronic equipment that may be affected by the year 2000 issue and that are necessary to conduct City operations: r- The financial system/payroll system/general ledger the City uses from ACS is off the shelf software that was purchased from an outside vendor. The City has received a letter from the vendor that the financial system appears to be year 2000 compliant. Validation and testing of this system has been completed by ACS. The City uses a server/network for managing most of the City's software applications. The City's MIS manager has reviewed all of the components of the network, received letters of year 2000 compliance from the hardware and software vendors and has determined that the system appears to be year 2000 compliant. Validation and testing for these systems have been completed by the vendors providing the software that resides on the server. Various revenues such as sales tax, motor vehicle fees, etc. are collected by the State of California. The State is responsible for remediating their collective system, and is solely responsible for assuring that their collection system is 2000 compliant. ,"- The City has deposits with Union Bank, the Local Agency Investment Fund (LAlF), and Bank of America. These institutions provide banking/investment services for the City and are solely responsible for assuring that their systems are year 2000 compliant. The City has attempted to take precautions in order to ensure that police, fire, transportation and other essential programs and services 'Yill continue to operate smoothly when the new millennium is ushered in. As part of this effort, the City has developed contingency plans, is engaged in an active public information program, and has taken steps to obtain information to determine whether other service providers, such as Pacific Gas and Electric and Pacific Telephone and Dublin, San Ramon Services District (which provides water and sewer services to all City homes and businesses) are year 2000 compliant. ,-. Because of the unprecedented nature of the Year 2000 issue, its effects and the success of related remediation efforts will not be fully determinable until the Year 2000 and thereafter. There can be no assurance that the systems or products of other companies or agencies upon which the City's systems rely will be converted timely .- or that any such failure to convert by a vendor, customer or another agency would not have an adverse impact on the City's systems or operations. -91- . II . . . . . II!! .. This page left blank intentionally. . . . . . . . . . -92- . r- ,- STATISTICAL SECTION ,"- ~ -93- .. . . . . . . . . This page left blank intentionally. . . . . . . . . . -94- . CITY OF DUBLIN GOVERNMENTAL EXPENDITURES BY FUNCTION ALL GOVERNMENTAL FUND TYPES LAST TEN FISCAL YEARS Fiscal General Facilities Health and Highways and Community Culture and Capital Year Govemment Rents Public Safety Welfare Streets Development Leisure Outlay Total 1989-1990 $ 509,596 $ 1,537,910 $ 4,672,847 $ 24,580 $ 1,021,641 $ 1,583,504 $ 1,274,861 $ 2,652,683 $13,277,622 ,- 1990-1991 1,873,661 1,719,820 5,068,755 26,277 1,041,627 1,827,354 1,459,419 3,403,128 16,420,041 1991-1992 1,618,391 1,720,670 5,654,056 29,526 1,025,265 1,541,207 1,682,262 5,273,041 18,544,418 1992-1993 1,347,055 1,718,970 6,014,989 76,729 998,843 1,409,594 1,733,786 2,697.724 15,997,690 1993-1994 1,389.537 1,532,816 6,001,166 542,698 830,936 1,107,770 1.709,218 1,118.384 14,232,525 1994-1995 1,488,844 1,553,744 6.325,219 696,817 944,564 1,354,796 1,765,990 1,370,902 15,500,876 1995-1996 1,392,265 1,604,480 6,986,737 1,183,933 1,043,009 1,832.754 1,847.110 3,338.607 19,228,895 1996-1997 1,691,724 1,496,816 6,968,912 734,423 1.059,275 1,930,723 2,007.715 2,552,912 18,442,500 1997-1998 1,761,818 1,493,348 8.566,630 764,979 1.090,290 2,824.242 2,172,422 2,219,989 20,893,718 1998-1999 2,139,738 1,614,407 9,145,346 851,699 1.240,171 3,664,025 2,248,581 4,617,733 25,521,700 Source: City of Dublin Annual Financial Report Total Governmental Expenditures ;-- 30000000 25000000 20000000 l!! .!! 0 15000000 I c ;;; (; i I- 1 0000000 : , ! ---I 0 0 a; Sl '" ... ." 0> 0> 0> 0> ~ 0> ~ ~ ~ 0> m 6 a; ~ M ~ CD 0> 0> 0> ~ ~ ~ ~ ~ ~ Fiscal VealS "- 0> 0> rb 0> 0> 0> 0> 0> rb 0> ~ -95- . CITY OF DUBLIN GENERAL GOVERNMENTAL REVENUES BY SOURCE ALL GOVERNMENTAL FUND TYPES LAST TEN FISCAL YEARS . Property Taxes Fiscal I Special Licenses and Inter- Charges for Use of Money Fines I Other . Year Assessments Sales Taxes Other Taxes Permits Governmental Services and Property Revenue Total 1989-1990 $ 3,740,780 $ 5,662,949 $ 652,752 $ 315,010 $ 1,667,801 $ 1,090,386 $ 1,405,882 $ 1,000,005 $ 15,535,565 . 1990-1991 4,072,039 5,839,089 682,508 248,116 2,564,553 1,196,484 1,388,351 465,790 16,456,930 1991-1992 4,083,141 5,293,709 704,774 246,459 2,489,765 1,085,251 1,125,154 1,110,126 16,138,379 1992-1993 3,951,806 5,484,502 842,460 281,921 2,810,875 1,171,564 951,267 175,273 15,669,668 . 1993-1994 4,149,388 5,969,342 752,363 340,995 1,798,037 1,323,196 1,008,044 422,785 15,764,150 1994-1995 4,307,753 6,470,287 772,630 337,551 2,375,377 1,798,343 1,210,885 648,497 17,921,323 . 1995-1996 4,185,731 6,760,413 1,006,729 466,199 3,674,119 3,596,000 1,376,647 180,130 21,245,968 1996-1997 4,164,884 7,108,598 1,280,578 1,092,183 2,091,210 2,789,236 1,505,788 309,361 20,341,838 . 1997-1998. 4,628,201 8,025,448 1,538,247 1,398,677 2,159,609 4,045,063 1,670,875 598,977 24,065,097 1998-1999 5,119,268 8,687,091 1,771,602 2,472,217 2,633,035 6,447,928 1,462,691 402,799 28,996,631 . Source: City of Dublin Annual Financial Report . 35000000 I 30000000 25000000 ! ] 20000000 i I 15000000 I I 10000000 : 5000000 I I I o I o Ol ~ 0, <Xl Ol Total Governmental Revenues . . . . 0> ~ 6 0> ~ '" '" ... "' '" Ol Ol Ol Ol Ol Ol ~ ~ Ol ~ a; '" d, ... ,;, 0> Ol Ol 0> ~ ~ ~ ~ ~ Fiscal Years . <Xl Ol ~ ,.:. Ol ~ . . . ... -96- . CITY OF DUBLIN ASSESSED VALUE OF TAXABLE PROPERTY LAST TEN FISCAL YEARS ,- Utility State Board Unsecured Fiscal Year Secured Property Roll Property Total 1989-1990 $1,086,479,184 $ 1,812,200 $ 94,717,004 $ 1,183,008,388 1990-1991 1,195,196,327 4,536,700 90,697,434 1,290,430,461 1991-1992 1,285,655,755 4,536,700 92,379,123 1,382,571,578 1992-1993 1,344,318,745 4,536,700 92,379,123 1,441,234,568 1993-1994 1 ,400,427,455 4,536,700 97,399,163 1,502,363,318 1994-1995 1,426,206,284 4,497,120 97,359,845 1,528,063,249 1995-1996 1,434,712,474 4,024,540 94,522,217 1,533,259,231 1996-1997 .. 1,519,119,484 4,028,118 115,801,947 1,638,949,549 1997-1998 1,565,651,517 2,395,606 114,868,090 1,682,915,213 1998-1999 1,782,911,790 2,395,606 115,129,665 1,900,437,061 Source: Alameda County Office of the Auditor-Controller (All figures shown are net of exemptions.) .. The City annexed approximately 1,530 acres in the eastern part of Dublin in Fiscal Year 1996-1997. Total Assessed Value of Taxable Property $2.00 $1.80 Cii' $1.60 c: ~ $1.40 iii $1.20 g I!! $1.00 .!!! $0.80 '0 c $0.60 ~ 0 $0.40 ... c-- $0.20 $0.00 - I I I I i I I T A I I I I I I I I I I I I ---l ..- ----"j 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 a> 0 . a> Ol 0; N '<t .... a> Cl Ol <') ~ ~ Ol Ol Ol a> LO co Cl co <h ell ~ ~ Ol a> Ol Cl Cl 0 , ~ Ol C>> ~ a> co 0; ~ c:, ~ C>> cb Cl a> ~ C>> N ..\- ~ ~ ~ ~ ~ Ol a> ob C>> ,.:. a> Ol Ol Cl ~ Ol C>> ~ C>> ~ ~ Cl Cl Fiscal Years ~ ~ .- -97- . CITY OF DUBLIN . PROPERTY TAX RATES ALL DIRECT AND OVERLAPPING GOVERNMENTS LAST TEN FISCAL YEARS . . Dublin Basic San County Bay Area East Bay Ramon Alameda Total Rate . Fiscal Wide Levy School Flood Zone Rapid Parks Services County Per $1000 Year ($1/$100) Districts State Bonds Transit Bond District Library Valuation . 1989-1990 1.0000 0.0701 0.0198 0.0319 0.0047 0,0020 0.0019 1.1304 1990-1991 1.0000 0.1003 0.0142 0.0250 0.0032 0,0007 0.0013 1.1447 . 1991-1992 1.0000 0.0935 0.0133 0.0251 0.0028 0.0010 0,0058 1.1415 1992-1993 1.0000 0.0878 0.0132 0,0258 0.0074 .. 0.0061 1.1403 . 1993-1994 1.0000 0.0717 0.0182 0.0240 0.0069 * 0.0060 1.1268 . 1994-1995 1.0000 0.0799 0.0166 0.0235 0.0066 * 0.0057 1.1323 1995-1996 1.0000 0,0648 0.0191 0.0230 0.0094 * 0.0057 1 .1220 . 1996-1997 1.0000 0.0858 0.0187 0.0225 0,0080 * 0.0056 1.1406 . 1997-1998 1.0000 0.0831 0.0178 0.0220 0.0081 * 0.0049 1,1359 1998-1999 1.0000 0.0727 0.0163 0.0167 0.0092 .. 0.0057 1.1206 . Source: Alameda County Office of The Auditor-Controller Rates Shown for Tax Code Area 26-001 which in Fiscal Year 1998/99 represents approximately 75% . of total assessed value citywide. 'ONo longer assessed, bonded debt fully repaid. . . . . . -98- . r- ,- CITY OF DUBLIN COMPUTATION OF LEGAL DEBT MARGIN June 30,1999 ,- Assessed valuation: Assessed value Add back exempt real property $ 1,900,437,061 $ 63,706,453 $ 1,964,143,514 Total Assessed Value Legal debt margin: Debt limitation - 15 percent of total assessed value $ 294,621,527 Percent of debt limit authorized and issued 0.00% Source: City of Dublin Finance Department r- Excludes Certificates of Participation and 1915 Act Bonds since they are not General Obligation Debt of the City of Dublin, ,.- r- -99- . CITY OF DUBLIN COMPUTATION OF DIRECT AND OVERLAPPING DEBT June 30, 1999 . . Percentage Applicable to City of Dublin Net Debt Outstanding Applicable to City of Dublin . Jurisdiction . OVERLAPPING TAX AND ASSESSMENT DEBT: East Bay Regional Park District 12.172% $ 3,043 99.435% $ 37,197,150 99.435% $ 8,174 1.340% $ 2,494,008 100.000% $ 1,978,000 $ 41,680,375 . Alameda County Flood Control District, Zone #7 Dublin Joint Unified School District Murray School District . City of Dublin 1915 Act Bonds TOTAL OVERLAPPING TAX AND ASSESSMENT DEBT . Chabot-Las Positas Com'ty College District Certificates of Participation . 2.262% $ 14,317,316 . 2.262% $ 12,322,204 2.262% $ 173,156 . 5.133% $ 313,370 99.435% $ 477,288 $ 27,603,334 . $ 69,283,709 (1 ) . 2.16% 4.30% . DIRECT AND OVERLAPPING GENERAL FUND OBLIGATION DEBT: Alameda County General Fund Obligations Alameda County Pension Obligations Alameda County Superintendent of Schools Certificates of Participation Dublin Joint Unified School District Certificates of Participation TOTAL DIRECT AND OVERLAPPING GENERAL FUND OBLIGATION DEBT COMBINED TOTAL DEBT Ratios to Assessed Valuation: Total Overlapping Tax and Assessment Debt. Combined Total Debt STATE SCHOOL BUILDING AID REPAYABLE AS OF 6/30/99: $0 . (1) Excludes tax and revenue anticipation notes; revenue, mortgage revenue and tax allocation bonds, and non- bonded capital lease obligations. . Souce: Califomia Municipal Statistics, Inc. . . -100- . CITY OF DUBLIN DEMOGRAPHIC STATISTICS LAST TEN FISCAL YEARS City Rank in Alameda Population Size of Fiscal City County %of California Year Population Population County Cities 1989-1990 23,550 1,252,600 1.88% 220 1990-1991 23,500 1,293,000 1.82% 230 1991-1992 25,162 1,313,300 1.92% 222 1992-1993 25,853 1,337,126 1.93% 224 1993-1994 26,270 1,347,930 1.95% 225 1994-1995 26,581 1,362,893 1 .95% 228 1995-1996 26,267 1,356,102 1.94% 226 1996-1997 25,544 1,371,793 1.86% 225 1997-1998 26,725 1,401 ,227 1.91% 224 1998-1999 28,707 1,433,309 2.00% 222 Source: State of California Department of Finance - Population Research Unit City Population 25000 CI> N US 20000 c ~ to :; 15000 c. 0 1I. 10000 5000 0 35000 I t t 30000 t t I I I I I I I ... I I .-I I ..l. ,__ I I t I I , I I , I I ! I I I I t I I I I I ! I I I ! I I ! I I I I I I I t I ! I t I t I I I I I I I I I 0 0; N co> ~ '" <0 .... <0 0> (J) (J) (J) (J) 0> (J) 0> (J) 0> (J) 0> (J) (J) (J) (J) 0> 0> (J) ~ ~ ~ ~ ~ ~ ~ ~ a, 0, 0 . N d, .t .;, a, ,.:. <0 0> 0; 0> (J) (J) OJ OJ 0> OJ ~ 0> 0> 0> 0> 0> OJ ~ (J) 0> ~ ~ ~ ~ ~ ~ ~ ~ Fiscal Years -101- . . CITY OF DUBLIN PROPERTY VALUE, CONSTRUCTION AND BANK DEPOSITS LAST TEN FISCAL YEARS . Total Number of Commercial Residential Fiscal Permits Construction Construction Year Issued Value Value Bank Deposits * 1989-1990 910 $ 6,367,726 $ 30,536,676 $ 439,781,000 1990-1991 752 7,604,547 8,074,458 450,215,000 1991-1992 798 9,759,533 5,005,547 517,540,000 1992-1993 828 5,477,619 7,732,367 533,885,000 1993-1994 721 8,162,579 3,490,667 555,554,000 1994-1995 739 6,718,045 2,368,943 549,989,000 1995-1996 814 4,927,911 15,638,274 545,407,000 1996-1997 790 6,855,980 64,610,527 611,507,000 1997-1998 1020 29,159,270 83,205,153 641,921,000 1998-1999 1552 93,428,185 135,438,240 Not Available . . . . . .. Source: Findley Reports, Inc. and City of Dublin Building Department Status Reports * Bank Deposits represents the amount of cash deposits held by financial institutions within the City of Dublin. . - - . - - Commercial Construction Value . ---.-- Residential Construction Value . 160,000,000 c;; o '" , , !, , ,., I <'> '<t LO <D t"- co '" '" '" ~ ~ '" '" ~ N M LO <0 ;:: co '" '" '" '" '" '" '" . 140,000,000 120,000,000 ! In i C 100,000,000 ' ::s o E < . ... 80,000,000 I .!!! o 60,000,000 I Q 4O,000.000! 20,000,000 I 011I------- . . o '" a; co N ~ c;; . . -102- CITY OF DUBLIN SCHEDULE OF 1993 CERTIFICATES OF PARTICIPATION COVERAGE FISCAL YEARS ENDED 1994-1999 Debt Service Reauirement Direct Operating Net Revenue Fiscal Gross Expenses Available for Year Revenue (1) (2) Debt Service Principal Interest (3) Total Coverage 1993-1994 $ 1,564,715 $ 12,874 $ 1,551,841 $ 910,000 $ 622,816 $ 1,532,816 101.24% 1994-1995 1,565,843 18,821 1,547,022 645,000 908,744 1,553,744 99.57% 1995-1996 1,594,060 18,518 1,575,542 705,000 916,027 1,621,027 99.70% 1996-1997 1,592,322 4,211 1,588,111 730,000 887,518 1,617,518 98.18% 1997-1998 1,598,447 8,385 1,590,062 765,000 856,351 1,621,351 98.07% 1998-1999 1,671,633 518 1,671,115 920,000 935,707 1,855,707 90.05% (1) Gross Revenue includes Facilities Rent and Interest Income. (2) Direct Operating Expenses excludes Interest and Depreciation. r- (3) Excludes Amortization of Bond Discount. Source: City of Dublin Annual Financial Report Note: Available reserves from the General Fund were used to retire the remaining $13,850,000 outstanding on this bond issue on February 1,1999. The amount shown above for Fiscal Year 1998-99 represent the normal annual payments made for principal and interest. -103- . . CITY OF DUBLIN CALIFORNIA PUBLIC EMPLOYEES RETIREMENT SYSTEM FUNDING ANALYSIS . FISCAL YEARS 1989-1998 Percent of . Overfunded Pension Benefit . Overfunded Obligation to Net Assets Pension Pension Annual Annual Fiscal Available for Benefit Percent Benefit Covered Covered . Year Benefits Obligation Funded Obligation Payroll Payroll 1988-1989 485,870 433,477 112.09% 32,393 1,034,010 5.07% . 1989-1990 673,728 582,374 115.69% 91,354 1 ,241 ,152 7.36% . 1990-1991 871,272 718,724 121.22% 152,548 1,507,749 10.12% 1991-1992 1 ,132,606 1,016,722 111.40% 115,884 1,529,925 7,57% . 1992-1993 1 ,413,587 1,253,650 112.76% 159,937 1 ,487,441 10.75% . 1993-1994 1 ,942,820 1 ,423,400 136.49% 519,420 1,590,481 32.50% 1994-1995 2,333,930 1,771,930 131.72% 562,010 1 ,853,180 30.50% . 1995-1996 2,911,120 2,107,420 138.14% 803,700 1,853,180 43.37% . 1996-1997 3,545,415 2,808,416 126.24% 736,999 2,107,245 34,97% 1997-1998 4,557,898 3,305,559 137.89% 1,252,339 2,444,573 51.23% . The above information represents the ten years of data available at the time this report was prepared. Prior to 1994, Assets were shown at book value. Beginning in 1994, the assets are shown at actuarial value (smoothed market value) . . Source: California Public Employees Retirement System. (PERS) . . -104- ,-. CITY OF DUBLIN PROPERTY TAX LEVIES AND COLLECTIONS LAST TEN FISCAL YEARS Percent of Total Total Tax Fiscal Property Tax Property Tax Collected to Year Levied Collected Tax Levied 1989-1990 $3,286,145 $3,149,417 95.84% 1990-1991 3,570,018 3,399,795 95.23% 1991-1992 3,860,349 3,611,824 93.56% 1992-1993(1) 3,597,733 3,432,895 95.42% 1993-1994 3,735,4 72 3,632,944 97.26% r-- 1994-1995 3,836,151 3,614,558 94,22% 1995-1996 3,833,915 3,614,671 94.28% 1996-1997 3,921,703 3,713,665 94.70% - 1997-1998 4,184,413 4,074,407 97.37% 1998-1999 4,798,501 4,517,234 94.14% (1) In Fiscal Year 1992/93, state law was enacted which permanently reduced the City's share of the property tax levy and shifted it to the schools. Amount levied for all subsequent years is net of property tax shift to schools. Source: Alameda County Office of the Auditor-Controller -105- CITY OF DUBLIN PRINCIPAL PROPERTY TAXPAYERS (Based on Secured 1998/99 Tax Roll) JUNE 30, 1999 Taxpayer 1. Lucky Stores Inc. 2. Rafanelli & Nahas 3. Bay Apartment Communities Inc. 4. Northwestern Mutual Life Insurance Company 5, Chang S. Lin 6. Phoenix Mutual Life Insurance Company 7. Brett G. & Lisa Jensen 8. Warmington Hansen Associates Limited Partnership 9. Pacific Gulf Properties Inc. 10. Amador lakes Associates 11. Dublin Spring Inc, . 12. Valley Christian Center of Dublin 13, First Security Bank National Assoc. 14. St. Michael Investments 15. PFRS Dublin Corporation 16. Opus Southwest Corporation 17. Montgomery Ward Development Corporation 18. Revocable Genirberg Trust, Et. AI. 19. Dublin Properties Inc. 20. Security Capital Pacific Trust 21. Chevron USA Inc. 22. Hexcel Corporation 23. Cranbrook Realty Investment Fund Limited Partnersh 24. Sleepy Hollow Investment Company NO.2 25. Dublin Hotel Venture Limited. Total Source: County of Alameda -1 06- Secured Assessed Value $32,268,462 29,421,759 23,302,375 20,271,732 18,007,556 16,110,339 15,217,385 14,914,500 14,014,872 12,790,928 12,721,280 12,022,622 11 ,996,220 11 ,646,207 10,344,098 10,185,840 9,984,823 9,143,575 8,957,844 8,950,000 8,472,980 8,441,288 8,400,000 8,102,034 8,030,360 $ 282,028,858 . .. . Percent of Total Secured Assessed Value . . 1.64% 1.50% 1.19% 1.03% 0,92% 0,82% 0.77% 0.76% 0.71% 0.65% 0,65% 0.61% 0.61% 0.59% 0,53% 0.52% 0.51% 0.47% 0.46% 0.46% 0.43% 0.43% 0.43% 0.41% 0.41% . . . . . . . . 14.3700% . . . . . . CITY OF DUBLIN TOP 25 SALES TAX PRODUCERS 1998-1999 BUSINESS NAME Advanced Micronet Solutions Alameda County Auction Automatic Rain Co. Circuit City Crown Chevrolet Dublin Honda Dublin Nissan Dublin Toyota General Pool & Spa Supply Good Guys Kassabian Motors Mervyn's Micro Porcelain Dentl Lab Montgomery Ward Office Club Orchard Supply Hardware Ross Santa Rita Jail Food Service Shamrock Ford Sprinkler Irrigation Specialists Strouds T J Maxx Target Toys R Us Viking Dist Construction Tools Percent of Total City Sales Tax Paid By Top 25 Accounts = 46% Firms Listed Alphabetically Period: April 98 thru March 99 BUSINESS CATEGORY Repair Shops Used Automotive Dealers Light Industrial/Printers Radio/Appliance Stores New Motor Vehicle Dealers New Motor Vehicle Dealers New Motor Vehicle Dealers New Motor Vehicle Dealers Light Industrial/Printers Radio/Appliance Stores Used Automotive Dealers Department Stores Health Services Department Stores Office Supplies/Furniture Hardware Stores Family Apparel Fast Food New Motor Vehicle Dealers Lumber/Building Materials Home Furnishings Family Apparel Discount Department Stores Specialty Stores Light Industrial/Printers Source: Hinderliter, de Llamas & Associates, State Board of Equalization -107- Date of Incorporation Form of Government Employees (City and Contract) Population Area Miles of Streets Miles of Curbs Signalized Intersections Number of Street Lights Average Daily Trips on 1-680 Average Daily Trips on 1-580 PARKS AND RECREATION: Parks Acres in Parks Number of Registered Voters (As of November 1998)_ EDUCATION: I. Public Elementary Schools Middle School High School Continuation II. Public School enrollment: September 1989 September 1990 September 1991 September 1992 September 1993 September 1994 September 1995 September 1996 September 1997 September 1998 September 1999 CITY OF DUBLIN MISCELLANEOUS STATISTICAL DATA JUNE 30, 1999 February 1982 CouncillManager 131 28,707 12.20 Sq. Miles 59.71 164.1 30 1,987 131,000 177,000 9 147 13,967 3,135 3,150 3,173 3,379 3,511 3,550 3,580 3,715 3,794 3,881 3,892 FIRE PROTECTION: Alameda County Fire Department Number of Stations Number of Fire Personnel POLICE PROTECTION: Number of Stations Number of Sworn Police Officers Number of Civilian Support Personnel COMMUNITY FACILITIES: Dublin Civic Center Dublin Senior Center Shannon Community Center Dublin Swim Center Dublin Sports Grounds Heritage Center 4 1 1 1 III. Private Schools Enrollment as of September 1999: Valley Christian: Elementary Junior High High School St. Philip Luthem Elementary (K - 8th) St. Raymonds Catholic School (K - 8th) Montessori Fountainhead (Preschool- K) Total Private School Enrollment Source: City of Dublin and Dublin Unified School District Records -108- . . . 2 . 29.25 . . 1 36 6 . . . . . 743 161 253 203 310 165 1835 . . . . . .