Loading...
HomeMy WebLinkAbout1997/06/30 Comprehensive Annual Financial Report a� 4 1 City of Rancho Cucamonga, California COMPREHENSIVE ANNUAL FINANCIAL REPORT Year Ended June 30. 1997 1 ' CITY OF RANCHO CUCAMONGA, CALIFORNIA Comprehensive Annual Financial Report ' Fiscal Year Ended June 30, 1997 Prepared by ' Finance Department 1 ' Lawrence I. Temple Administrative Services Director i 1 1 1 1 This page intentionally left blank. ' 1 1 ' City of Rancho Cucamonga ' Table of Contents Page Number ' INTRODUCTORY SECTION Letter of Transmittal i ' City Officials xxvi Organizational Chart xxvii Geographic Location Diagram xxviii Certificate of Achievement for Excellence in Financial Reporting xxix ' Certificate of Award for Outstanding Financial Reporting xxx FINANCIAL SECTION ' INDEPENDENT AUDITOR'S REPORT 1 ' FINANCIAL STATEMENTS ' The notes to the financial statements are an integral part of the component unit financial statements ' Exhibit A - Combined Balance Sheet-All Fund Types and Account Groups 2 Exhibit B - Combined Statement of Revenues, Expenditures and Changes in ' Fund Balances - All Governmental Fund Types 3 Exhibit C - Combined Statement of Revenues, Expenditures and Changes in Fund ' Balances - Budget and Actual (Budgetary Basis) - All Governmental Fund Types 5 ' Exhibit D - Statement of Revenues, Expenses and Changes in Retained Earnings - Proprietary Fund Type - Enterprise and Internal Service Funds 9 ' Exhibit E - Combined Statement of Cash Flows - All Proprietary Fund Types 10 1 City of Rancho Cucamonga ' Table of Contents ' NOTES TO FINANCIAL STATEMENTS 11 ' SUPPLEMENTARY SCHEDULES ' Schedule I - Balance Sheet- General Fund 52 ' Schedule 2 - Statement of Revenues, Expenditures and Changes in Fund Balances - General Fund 53 ' Schedule 3 - Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual (Budgetary Basis) - General Fund 54 ' Schedule 4 - Combining Balance Sheet-All Special Revenue Funds 58 Schedule 5 - Combining Statement of Revenues, Expenditures and Changes in ' Fund Balances-All Special Revenue Funds 62 Schedule 6 - Combining Schedule of Revenues, Expenditures and Changes in ' Fund Balances - Budget and Actual (Budgetary Basis) -All ' Special Revenue Funds 66 Schedule 7 - Combining Balance Sheet-All Debt Service Funds 76 ' Schedule 8 - Combining Statement of Revenues, Expenditures and Changes in Fund Balances - All Debt Service Funds 77 ' Schedule 9 - Combining Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual -All Debt Service Funds 78 ' Schedule 10 - Combining Balance Sheet -All Capital Projects Funds 79 Schedule 11 - Combining Statement of Revenues, Expenditures and Changes in ' Fund Balances - All Capital Projects Funds 80 , Schedule 12 - Combining Schedule of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual (Budgetary Basis) - All Capital ' Projects Funds 81 Schedule 13 - Combining Balance Sheet- Internal Service Funds 84 ' ' City of Rancho Cucamonga ' Table of Contents ' Schedule 14 - Combining Statement of Revenues, Expenses and Changes in Retained Earnings - Internal Service Funds 85 ' Schedule 15 - Combining Statement of Cash Flows-Internal Service Funds 86 ' Schedule 16 - Combining Balance Sheet-All Agency Funds 87 ' Schedule 17 - Combining Statement of Changes in Assets and Liabilities - All Agency Funds 89 ' Schedule 18 - Schedule of General Fixed Assets - By Sources 93 Schedule 19 - Schedule of General Fixed Assets by Function and Activity 94 Schedule 20 - Schedule of Changes in General Fixed Assets by Function ' and Activity 95 ' STATISTICAL SECTION Exhibit 1 - General Governmental Expenditures by Function 96 ' Exhibit 2 - General Government Revenue by Source 97 ' Exhibit 3 - Assessed Valuation of All City Property 98 Exhibit 4 - Property Tax Levies and Collections 99 Exhibit 5 - Direct and Overlapping Property Tax Rate 100 ' Exhibit 6 - Special Assessment Collections 101 Exhibit 7 - Direct and Overlapping Bonded Debt 103 ' Exhibit 8 - Legal Debt Margin (General Obligation Bonds) 104 ' Exhibit 9 - Number of Permits 105 ' Exhibit 10 - Construction Activity - Building Permit Valuation 107 City of Rancho Cucamonga ' Table of Contents t Exhibit 11 - Demographic Statistics 109 ' Exhibit 12 - Principal Taxpayers 111 Exhibit 13 - Purchased Insurance Policies 112 ' Exhibit 14 - Miscellaneous Statistical Information 113 ' 1 z y 7d O d C A O 7d ■G A H INTRODUCTORY SECTION z z 0 F U W a 0 F U r� A O a F z This page intentionally left blank. T H E C I T Y O F ISA NC KO C UC A MONG1� December 26, 1997 The Honorable Mayor and Members of the City Council City of Rancho Cucamonga Rancho Cucamonga, CA 91730 Council members: ' Submitted for your information and consideration is the Annual Financial Report for the year ended June 30, 1997. This is a combined report of the City of Rancho Cucamonga, Rancho Cucamonga Redevelopment Agency, Rancho Cucamonga Public Improvement Corporation and the Rancho Cucamonga Fire Protection District. The goal of the City of Rancho Cucamongas financial staff is to strive for excellence in the performance of the financial functions and reporting. The Government Finance Officers Association of the United States and Canada (GFOA) awarded a Certificate to the City of Rancho Cucamonga for its comprehensive annual financial report for the fiscal year ended June 30, 1996. The Certificate of Achievement is the highest form of recognition for excellence in state and local government financial reporting. In order to be awarded a Certificate of Achievement, a government unit must publish an easily readable and efficiently organized Comprehensive Annual Financial Report (CAFR), whose contents conform to program standards. Such CAFR must satisfy both generally accepted accounting principles and applicable legal requirements. The Certificate of Achievement is valid for a period of one year only. The City of Rancho Cucamonga has received a Certificate of Achievement for the last nine consecutive years ' (June 30, 1988 through June 30, 1996). We believe our current report continues to conform to the Certificate of Achievement program requirements, and we are submitting it to GFOA. i Mayor William J.Alexander Councilmember Paul Biane Mayor Pro Tem Diane Williams - Councilmember Rex Gutierrez Jack Lam,AICP,City Manager Councilmember James V. Curatalo ' 10500 Civic Center Drive • P.O. Box 807 • Rancho Cucamonga,CA 91729 • (909)477-2700 e FAX (909)477-2849 -r I. BACKGROUND INFORMATION r GENERAL INFORMATION ' The City of Rancho Cucamonga currently has an estimated population of 115,900 and encompasses approximately 37.5 square miles. It is located between the City of Upland to the West, Ontario to the South, Fontana to the East, and is in the Western section of San Bernardino County which is in the southern part of the State of California. The local economy is primarily based on retail commercial business and light manufacturing, which ' emphasizes the City's efforts at retaining sales tax generating businesses to help stabilize the City's financial base. REPORTING ENTITY AND ITS SERVICES The reporting entity is comprised of the City government, Rancho Cucamonga Redevelopment Agency, Rancho Cucamonga Public Improvement Corporation, and the ' Rancho Cucamonga Fire Protection District. The City provides accounting services to all these agencies. ' The Rancho Cucamonga Redevelopment Agency is shown in the financial statements in two combined groups, namely: the Redevelopment Funds are included in the Capital Projects r Fund whereas the Tax Increment Funds are included in the Debt Service Fund. The Rancho Cucamonga Public Improvement Corporation is shown in the Capital Projects Fund and Debt Service Fund. The Rancho Cucamonga Fire Protection District is reflected in the Special Revenue Fund. The City of Rancho Cucamonga is a general law city governed by the State of California ' Government Code and local ordinances and provides quality service by blending the talents of City staff and utilizing other agencies. Certain services necessary to continue the high , quality of life in Rancho Cucamonga such as water, sanitation (i.e. sewage), and police are furnished by the County of San Bernardino and other specialized agencies. The City provides building safety regulation and inspection, street lighting and beautification, land use r planning and zoning, housing and community development services, maintenance and improvement of streets and related structures, traffic safety maintenance and improvement, , and a full range of recreational and cultural programs for citizen participation. The Redevelopment Agency provides the services associated with selling the City as an optimum location for companies to establish their operations. The City's location and local labor , market are just two optimum items available as a selling tool. The primary focus of the ii 1 ' Redevelopment Agency is on the long-term economic development of the City of Rancho ' Cucamonga. The Rancho Cucamonga Public Improvement Corporation is a nonprofit corporation which was established to assist the City by financing, acquiring, constructing, improving and leasing public improvements for the benefits of residents of the City. Fire ' protection for the City and its sphere of influence is provided by the Rancho Cucamonga Fire Protection District. ' FINANCIAL ADMINISTRATION ' The Finance Department is structured under the Administrative Services Department with the Director of Administrative Services having responsibility for Personnel, Risk Management, Purchasing, Licensing, Resource Services, Geographical Information Services, Management Information Services, and the City, Redevelopment Agency, and Fire District Treasury functions. ' The Finance Officer is responsible for directing the accounting, financial planning and reporting, payroll, budget analysis, budget preparation, budget implementation and management, and cash management functions for the City, Redevelopment Agency and Fire District. 1 GOVERNMENT The City of Rancho Cucamonga was incorporated in 1977 as a general law city under the provisions of the Government Code of the State of California, and operates under the Council-Manager form of city government. The City officials elected at large include a ' Mayor and four City Council members, City Clerk, and City Treasurer. The Mayor and Council members are elected on a staggered basis for a term of four years. There is no limit on the number of terms an individual can serve as Mayor or as Council members. The IMayor and City Council appoint the City Manager. REPORTING STANDARDS ' The financial report has been prepared in conformance with the generally accepted ' accounting principles as set forth by the Governmental Accounting Standards Board (GASB), applicable pronouncements of the American Institute of Certified Public Accountants, and the full financial disclosure guidelines of the Governmental Finance Officers Association of ' the United States and Canada. The implementation of GASB pronouncements has resulted in the preparation of this financial report which blends the financial data of the City and all of its related entities. iii FINANCIAL STATEMENT FORMAT , In accordance with the above mentioned guidelines, the report is divided into the following , three sections: 1. INTRODUCTORY SECTION: Contains the principal officers, City organization , chart, and the letter of transmittal. 2. FINANCIAL SECTION: Contains the auditor's opinion, combined financial statement, and combining financial statements by fund type and individual funds. ' 3. STATISTICAL SECTION: Contains relevant financial and non-financial data presenting historical trends and other information about the City. ' NOTES TO THE FINANCIAL STATEMENTS The Notes to the Financial Statements, which are part of the General Purpose Financial ' Statements within the Financial Section, are an integral part of the financial report and are essential to the fair presentation and adequate disclosure of the financial position of the City, Redevelopment Agency, Corporation, and Fire District. The notes should be read along with the financial statements to gain a fuller understanding of the information contained within this report. Your attention is specifically directed to the presentation of the City's significant accounting policies. RESPONSIBILM The responsibility for the accuracy of the data presented, the completeness and fairness of , its presentation, including all disclosures, rests with the City. The data, as reported, is believed to be accurate in all material respects; and was designed in a manner to present , fairly the financial position of the City, Redevelopment Agency, Corporation, and Fire District at June 30, 1997, and the results of its operations and changes in financial position. ' All disclosures necessary for the reader to gain a ma)dmum understanding of the City's financial affairs have been included. FUND DESCRIPTIONS ' Definitions of the various funds and account groups of the reporting entity are included as , supplementary information within the various divisions of the Financial Section of this report. iv ' ACCOUNTING SYSTEM AND BUDGETARY CONTROL ' The City's accounting records are maintained on the accrual basis to the extent practicable for the independent certified public accountants who audit the accounting records of the City. ' This system has been designed to provide reasonable, but not absolutely guaranteed, assurance that: ' 1. Assets have been protected from losses arising from unauthorized use or disposition. ' 2. Financial records can be relied upon for preparing adequate financial statements and for maintaining accountability for assets. II. HIGHLIGHTS OF FISCAL YEAR 1996-97 ' REDEVELOPMENT AGENCY A. Economic Development/Marketing The Agency continues to focus on business attraction, retention and expansion. An aggressive ' marketing plan was implemented based on recommendations provided by PHH Fantus, a national site selection consultant. The Agency's activities have resulted in a variety of new companies locating to the community including, Bradshaw International, Bell Industries, and Heritage Bag ' Company. Retention/Expansion - The business visitations and tri-annual business receptions continued to be ' a focus of the Redevelopment Agency. Over six hundred new businesses located to Rancho Cucamonga and were contacted by the Agency. Many of those companies attended the business receptions and were presented with a welcoming packet with referral information and services ' provided within the City. Participants included Agency and City staff, Mayor and Council members, as well as representatives from the Rancho Cucamonga Chamber of Commerce, Chaffey College, Small Business Development Center and the Inland Empire Economic Partnership. The ' Agency's Third Party Electrical Certification Program provided assistance to four businesses to bring their machinery into electrical code compliance. The Agency implemented the City's second annual Business Appreciation Week in May. 1 Marketing/Attraction - The Agency implemented a successful advertising campaign with 1 placements in a variety of state and national publications. A total of 295 leads were generated as a result of the advertising campaign. Strategic relationships were strengthened with Inland Empire Economic Partnership and the California Trade and Commerce Agency to work cooperatively in ' business attraction efforts. The Fax on Demand Program continued to be successful providing commercial/industrial real estate information to over 500 inquiries. Potential new relocating ' v companies and local business received promotional skybox tickets to Quakes' baseball games ' providing them with an opportunity to experience the sport/entertainment contribution to the City's , total quality of life. The annual Visions Newsletter and the Business Visions publications were mailed throughout the community and were included in all public relations and business attraction packets. Capital Improvements - Significant completion of the upgraded FoothilUInterstate 15 on and off ramps was completed during the year. The completion of this project will greatly improve , circulation along Foothill Boulevard In advance of the proposed regional shopping center. The Agency contributed $4.5 million to the project, which is scheduled for completion in December 1997. , B. ,Affordable Housing Rental Housing - Northtown Housing Development Corporation NHDC) constructed a 14-unit apartment complex called Las Casitas. The Agency funded the project in furtherance of the goal to provide housing to smaller families with low and very low incomes. The Las Casitas project received a Vintage Award from the Inland Empire Section of the American Planning Association. The NHDC received an honorable mention from the Maxwell Award from Fannie Mae for another , housing project, Villa del Norte. This prestigious award was the fourth received by NHDC for that project. Senior Housing - Prairie Pacific Development Corporation and the Agency entered into a DDA , to construct 159 senior apartment units adjacent to the City's library. The Agency issued Housing Revenue Bonds which were sold to the Bank of America, which finalized the project's financing. ' Construction began in May 1997 and the complex is scheduled to open in 1998. Home Ownership - The Agency has an agreement with Neighborhood Housing Services to , implement a First-Time Homebuyer Program. Sixteen families were assisted through the program in this fiscal year which provides a silent second mortgage to home buyers in lieu of a traditional down payment. , ENGINEERING Transformation of the Old County Library building into the new Lions East Community Center ' began in Fiscal Year 1996-97. This facility, located at 9191 Base Line Road adjacent to the existing Lions Community Center, will provide an additional 11,000 sq. ft. which will be used for ' youth programs. Renovation improvements included: ADA modifications, lighting rehabilitation, new HVAC (Heating, Ventilation and Air Conditioning) installation, plumbing upgrades, interior , modifications, exterior painting, redesign of the existing landscape and irrigation system, and minor parking lot improvements. It is anticipated that these improvements will be completed in FY 1997- 98. , vi ' ' Renovation plans for the ADA improvements at Lions West Community Center, located at 9161 Base Line Road, were completed. Plans for this facility include modifications to provide accessibility, including the addition of a lobby and entry corridor, restroom improvements, kitchen modifications, and relocation of classroom, office and storage space as well as full parking lot ' improvements. Construction of this facility is scheduled to commence upon completion of the Lions East Project in Fiscal Year 1997-98, and will require approximately 5 months to complete. ' Improvements to the second floor of the Rancho Cucamonga Public Library, which were completed in June, added office space and study areas to accommodate the new Library Literacy Program. Improvements included HVAC, lighting and electrical modifications, and the addition ' of temporary walls and doors. Transformation of a vacant retail building into the new Rancho Cucamonga Family Sports Center ' began in the Spring of 1997. Located at 9059 San Bernardino Road, this approximately 36,000 sq. ft. facility will provide indoor recreational amenities including a gymnasium for basketball, volleyball and soccer, racquetball courts, locker rooms with showers, snack bar/pro-shop, meeting rooms and office space. Improvements are scheduled for completion in the Fall of 1997. The Rancho Cucamonga Senior Center, located at 9791 Arrow Highway, saw the continuation of improvements this year. Security Cameras were installed in the north and south parking lots in June, and plans were prepared for the expansion of the existing parking lot onto an adjacent lot to the east. Construction of the parking lot expansion is expected to be completed in Fiscal Year 1997-98. ' Construction of Phase I of Etiwanda Creek Park was completed in September 1996, and provides 12 acres of additional parkland for the residents of the City. Improvements at the park include 2 football fields with soccer overlays, picnicking amenities, a play area/tot lot, a restroom building ' and parking. Fiscal Year 1996-97 also saw the addition of a ramp to be used for mounting horses by physically ' challenged individuals at the Heritage Park Equestrian Unit, located at 5546 Beryl Street. The most significant design project for Fiscal Year 1996-97 was for Day Creek Boulevard ' between Base Line Road and the Highland Avenue The street design was coordinated with and will be constructed in conjunction with the future Route 30 Freeway project. The construction of Day Creek Boulevard is scheduled to commence March, 1998. 1 The most significant construction project was the widening of Haven Avenue between Deer Creek ' Channel and Base Line Road.. The project widened the southbound roadway to three lanes between that reach by replacing the open channel on the west side of Haven Avenue with a pipe. The project also improved the Haven Avenue intersections at Church Street and Base Line Road. This is the first phase of replacing the open channel that extends to north of Highland Avenue and thereby allowing for the widening of the west side of the Haven Avenue roadway. vii Arrow Route at the railroad spur west of Milliken Avenue was improved by widening the crossing ' at the spur and improving the north side of Arrow Route between the spur and Milliken Avenue ' This project eliminated the final bottleneck in Arrow Route from Haven Avenue to Milliken Avenue. Rochester Avenue at the SCRRA (Southern California Regional Rail Authority) railroad tracks ' was designed with construction pending final approval by SCRRA. The project will widen the crossing as well as improve the street from north of the tracks to south of 8th Street. ' Archibald Avenue at 4th Street improvements were designed with construction pending final coordination with utility companies. The project will widen 4th Street to provide a right tum lane ' and widen Archibald Avenue to the north of 4th Street to provide a bus bay and acceleration lane. Construction is anticipated to commence in Fiscal Year 1997-98. The Almond Street and Henry Street drainage and street improvement project was designed and ' constructed during Fiscal Year 1996-97. This project will alleviate drainage problems at the , intersection as well as reconstruct the failed portion of the streets due to those drainage issues. Bike Routes were designed and signed on Etiwanda Avenue from Foothill Boulevard to Base Line , Road., and on 11iillside Road, Haven Ave., and Wilson Ave. between Cucamonga Creek to Deer Creek Channels. Traffic Signals at Church Street and Milliken Ave., Terra Vista Parkway and Milliken Ave., 19th , Street at Hermosa Ave., and Victoria Park Lane at Milliken Ave. were designed and installed. In addition, a traffic signal at 4th Street and lvfrlliken Ave. was installed in conjunction with the City ' of Ontario. A traffic signal for Foothill Boulevard at Baker Ave. was designed to be installed in coordination with Caltrans. Installation is scheduled for Fiscal Year 1997-98. Jersey Boulevard between Haven Ave. and the railroad spur west of Milliken Ave. was improved. , The project reconstructed and widened the pavement within that reach and also installed drainage improvements thereby protected the street from flooding. The pavement on Hermosa Ave. ' between 4th Street and Foothill Boulevard was also reconstructed. A street rehabilitation project improved various local streets throughout the City. This project extends the life of the pavement on those streets while improving the streets ride and appearance. , PLANNING A. Current Planning During the 1996-97 fiscal year, the current Planning section processed a number of major , development projects, permit entitlements, and special projects as summarized below: Staff processed a total of 672 applications of all types, ranging from Home Occupation Permits , viii ' ' to Tentative Tract Maps. Major development projects which were processed included Kaiser, San Carmela by Mark Taylor, and Auto Nation. ' Major projects that went through plan check and/or were under construction included Masi Plaza Cucamonga Comerpointe by Griffin, Kaiser, Villa Pacifica, and Foothill Meadows by Diversified ' Pacific. The Current Planning section was involved with many special projects including: updating the ' Development Code, Industrial Area Specific Plan, and other regulatory documents; Route 30 Freeway Task Force; Signage Task Force, Foothill Boulevard Task Force, and Economic Development Task Force. ' B. Advance Planning A City-initiated multi-family housing study was undertaken and completed. The study was intended to revisit a previous three-year old study in the City and what would be a healthy balance of residential land use opportunities. In addition, staff processed six specific/community plan amendments, one Development District Amendment, and six General Plan Amendments. ' Five new County and eight new governmental referrals were received and reviewed. Three of the county and two of the government referrals required responses. ' The County referrals requiring a response included the following: ♦ Mid Valley Sanitary Landfill Permit Revision ♦ Lin Yen Temple - Religious Retreat ' ♦ Milliken Land Fill Permit Revision The governmental referrals requiring a response included the following: ' ♦ City of Fontana EIR Review Mixed Use Development Project ♦ SCE Public Utilities Divestiture Historic Preservation accomplishments included the following: ♦ Designated one residence (Nesbit-McCorkle) as a Landmark, and one site as a Points of Historic Interest (North Town Theater). ' ix ♦ During this period, one Mills Act Property Tax Reduction Agreement was entered ' into by land marked property owners to reduce property taxes and secure on-going , maintenance for the Nesbit-McCorkle Residence. C. Community Development Block Grant Administration , This year saw the completion of several capital and facility improvements, including: the , completion of the 95th Street construction project for 9th Street from Grove Avenue to Edwin Street and the design of improvements for Tapia Via Drive from Grove Avenue to Rancheria Drive and Rancheria Drive from Grove Avenue to Tapia Via Drive. In order to ' accormnodate handicapped persons, the City installed 80 square feet of handicapped curbing. Interior improvements to the City's Senior Center are approximately 60 percent complete and include new acoustical tiles, chair rails, corner guards, and ADA improvements. Finally, , the installation of handicap improvements to the Lion's East facility is approximately 90 percent complete. Design plans for Lions's west have been completed and the project has , gone to bid. The City-run Home Improvement Program offers eligible residents grants or deferred ' payment loans to complete needed repairs to their homes. A total of 35 lower income households were assisted through this program, with a total of 1 loan, 11 grants, and 23 emergency grants. In addition, another 54 households were assisted with minor home repairs. , A range of public service activities are funded through the City Community Development ' Block Grant Program including youth programs, graffiti removal, and food and shelter assistance. A total of 49 at-risk youth were provided after school activity and guidance, approximately 10,430 square feet of graffiti was removed from target neighborhoods, and the ' City continued to fund landlord/tenant and fair housing activities to approximately 266 households. Additionally, public services were provided to assist 65 homeless or near homeless households through HOPE, 7 families with transitional shelter and assistance , toward obtaining permanent housing through Foothill Family Shelter, and 8 battered spouse households were provided shelter at the House of Ruth. In addition, 18,285 meals were , provided to 1,219 persons in need. The 1997-98 Consolidated Annual Plan and the 1995-96 Annual Performance Report were ' both completed during the 1996-97 fiscal year. BUILDING AND SAFETY Building activity for Fiscal Year 1996-97 exceeded one hundred and thirty eight million dollars. Single Family Residential construction contributed to a third consecutive year of sustained activity. Lewis Homes and Centex Homes were leaders in the upsurge in residential x ' 1 ' construction activity. ' The Building and Safety Division provides plan checking and inspection activities for compliance with Uniform Building and Fire Codes and Code Enforcement of Municipal Code Property Maintenance Standards in a coordinated environment. COMMUNITY SERVICES ' The Community Services Department continued to devote its energy during Fiscal Year ' 1996/97 to the provision of quality cultural, recreational, senior and human services programs as well as providing administrative support to the events held at the Epicenter. Demand for community services to address the needs of the residents and their families remained high. ' Fiscal Year 1996-97 found the Community Services Department reassessing and improving existing programs/services. The following major activities were accomplished: ' A. Youth Programs and Activities The very popular Playschool program (operated September - June) for youngsters from one ' to five years old continued to provide classes to more than 450 children, enhancing their social skills while creating a fun environment in which to learn. Play Camp, which operates ' in July and August serves up to an additional 250 children. The Contract Classes Program continued to be a successful part of the Community Services Department. In Fiscal Year 1996-97, we offered more than 1,000 classes throughout the year and provided leisure activities to more than 8,000 individuals. ' Annual events continuing to garner the enthusiasm and participation of the community included: ' ♦ The annual Breakfast with Santa was offered and saw more than 2,000 children and parents celebrate the holidays, make a craft, sing songs and dine with Santa Breakfast was provided as a community service project by the Rancho Grande Kiwanis Club. ♦ A new program, the Spring Children's Concert featuring the "Happy Crowd" was held in March at the Epicenter. Over 1,600 attended two performances. ' Other activities included a nine-week Summer Day Camp, and the Kid Explorers Summer Program. xi B. Family Program/Activities ' Family oriented programs and activities also offered during Fiscal Year 1996-97 included: ' ♦ The 4th of July Celebration at Red Hill Community Park where over 7,000 residents ' enjoyed a fun-filled day in the park. ♦ The 12th annual season of Concerts in the Park presented six concerts offering a , variety of music which approximately 10,800 residents enjoyed evenings of music under the stars. ' ♦ Art in the Park provided a day of cultural arts and crafts, dancing, music, magic, puppets, and more representing various cultures of our community to approximately ' 6,000 community members. ♦ Over 18,000 residents celebrated our City's 19th anniversary of city hood by , attending the Founder's Day Parade and Celebration held on the second Saturday of November with a theme of "Champions in the Making". ' ♦ Movies in the Park provided approximately 12,000 residents with six weeks of family movies on Tuesdays and Fridays. Special theme contests were offered to enhance , the program. ♦ The community usage of the four reservable parks in the City of Rancho , Cucamonga (Heritage, Red Hill, Coyote Canyon and Hermosa) had an estimated attendance of 51,479. , ♦ The following facilities were also utilized by community residents during Fiscal Year 1996-97; Equestrian Center (3,650), Amphitheatre (8,820) and Civic Center , Courtyard (1,385). C. Teen Programs and Activities ' Teen Recreation Activity Club (TRAC) meets monthly during the school year to plan ' activities and discuss future programs. They also sponsor an annual Christmas Party and End of the Year Party and recognized for their service each May at the Park and Recreation Commission meeting. TRAC members also receive a monthly newsletter, the TRAC Tattler , with information about upcoming activities and volunteer opportunities. Thanks to the active participation of young adults in the TRAC, many programs and activities were supported through their volunteer efforts. ' xii , ' ♦ Teen Snack Bars operated various community and special events throughout the ' year helping to raise funds for teen activities. ♦ Night on the Town is a teen operated babysitting service through which 50 youth ' volunteered their services bi-monthly to help parents get a little 'R & R" while at the same time providing entertaining and enriching activities for youngsters. ' ♦ Our third annual Teen Job Fair and Job Skills Workshop was held in April and attracted over 200 teens. The Job Fair featured educational sessions and a local ' business vendor fair. ♦ The Teen Learning Center had a successful summer. Fifty (50) teens volunteered over 3,000 hours of community service during the ten weeks of summer. ♦ Teen Trips to the amusement parks and beaches continued to be popular. ' D. Sports ♦ The City continued its third year of Youth Roller Hockey at the expanded parking lot on Rochester across the Epicenter. Over 1,900 boys and girls participated. ' Portable rinks were used and games/practices were scheduled around the Quakes baseball season and special events to ensure multiple use of the parking lot. This three season program ranked third highest participation in California among roller ' hockey programs and first highest in the state amongst cities. ' ♦ Summer swim lessons attracted over 3,400 participants. This is the largest summer swim lesson program in the County of San Bernardino and over 6,200 children participated in the afternoon recreational open swim program. . ' ♦ Pee Wee Soccer attracted 760 participants (3-5 year olds) this last year, and Pee Wee Baseball attracted 755 three to five year olds to learn the basic fundamentals of baseball. We now have two seasons of soccer, Spring/Fall. ' ♦ This was the third year of use at Rancho Cucamonga High School for the youth basketball program (805 boys and girls participated.) This was due to our joint use agreement which allowed gym use in exchange for allowing the high school to use ' the Epicenter for their graduation ceremonies. The youth basketball program currently utilizes facilities at all three high schools and three intermediate/middle schools. ♦ Youth Basketball and Youth Roller Hockey Programs continue to fund raise by ' xiii 1 recruiting sponsors. Over $47,000 was raised this year in sponsorships. The Youth ' Sports programs this utilized 1,165 volunteers as coaches, assistant coaches and , team moms. ♦ The City's Adult Softball Program increased to 465 teams (7,709 participants) this , year. E. Senior Programs/Activities ' Senior Center.special events included six (6) holiday related major events. Five of which are ' cosponsored by the Rancho Cucamonga V.I.P. Club. In addition, there are six (6) mini-events that are organized entirely by center staff. These events take place throughout the year which averages out to one event per month. ' City-wide senior related special events include the annual Senior Citizens Fine Art Show, Senior Pool Tournament, and the newly added Step Out For Seniors Centers event. These , affairs attract senior participants from throughout the west-end, and are looked forward to with high anticipation every year. , Among the numerous activities and classes that already exist at the Center we've added an Intermediate Exercise Class, Beginning Chess Class, a revamped Walking Class, and an , additional Arthritis Class. Due to the increased participation in fitness classes we've added an annual Health and Fitness Seminar to promote the benefits of good nutrition, health and fitness. Also, we now provide musical entertainment every Wednesday, during the nutrition ' program thanks to our very talented volunteers. The Old-Timers Foundation continues to provide meals for our daily nutrition program. In , addition to providing meals for walk-ins, they also deliver meals to seniors who are homebound. Also, our end of the month birthdays for seniors are co-sponsored by the ' Old-Timers Foundation. F. Human Services Programs/Activities , Annual city-wide events include the Senior Health Fair & Flu Shot Clinic, Step Out for ' Senior Centers Health Fair, and the upcoming Volunteer Fair. Evening presentations related to health and fitness are also provided for the community on a registration basis with no fees required. ' "The Doctor is In" lecture series, presented monthly at the Senior Center, continues to be a program favorite. Among the many health related topics covered are Diabetes, Breast ' Cancer, Depression, and Thyroid Disorders. New programs include Elder Law which deals xiv , ' with issues such as Medicare, Medicaid, long-term care, living trusts, estate planning, wills, and more. Furthermore, this program offers private counseling sessions on an appointment basis. The Well Baby Clinic and Health Screening program, co-sponsored by the County of San Bernardino, provide's physical examinations for infants through 5 years of age and for seniors 60 years and older. Also, an Immunization Clinic provides immunizations for children ages ' 2 months through 18 years of age and senior citizens. ' In addition, numerous information and referral publications have been updated to assist the community including: a comprehensive community resource directory; senior housing directory; a child care directory; adult day care resource list; and an emergency services ' resource list. G. Epicenter Events and Rentals ' Twenty (20) special event and rental bookings took place during Fiscal Year 1996-97 at the ' Rancho Cucamonga Epicenter. Events included such activities as the San Diego Padres Exhibition and Game, First Baptist Church Easter Services, the Silver Bullets Celebrity Tournament, ACE Youth Softball Tournament, The Daily Bulletin High School All-Star ' Game, the City Spring Children's Concert, the Founder's Day Celebration, the Fire Department Holiday in July Toy Drive, Boy Scouts Scout-o-Rama, and the DARE Soccer Tournament. Commercial filming was popular at the Epicenter Stadium with six (6) ' television and advertisement film shoots such as two commercials with Mike Piazza, a Nike commercial with Hideo Nomo, an American Heart Association commercial with Tommy ' Lasorda, and a commercial with Chung Ho Park just to name a few. H. Other Highlights ' The City's quarterly newsletter, The Grapevine, serves as a strong link in uniting the three founding communities of Alta Loma, Cucamonga and Etiwanda. In addition, the quarterly newsletter informs the City's rapidly growing population of new policies, development, activities and recreational opportunities taking place in the community. ' Other activities included a nine-week Summer Day Camp, the Kid Explorers Summer Program, and the "Just for Kids" workshops offered to the youth in our community. POLICE DEPARTMENT ' The City of Rancho Cucamonga continues to be rated as one of the safest cities with a population over one hundred thousand. The Police Department, with the on-going support xv of its citizens and elected officials, plan on continuing this trend. The past year saw the ' increase of the patrol force by five (5) officers through the receipt of a Federal Grant. The ' continued recruitment of Citizen Volunteers and Reserve Officers also provides the city with over eighty personnel to supplement the regular staffing. A primary focus of the upcoming year will be upon the Police Department's continued commitment to increased , visibility/availability to its citizens. Highlights for Fiscal Year 1996-97 include: , ♦ Receipt of a Federal Grant which will provide funding for equipment and materials ' for the opening of six (6) neighborhood satellite police offices. ♦ The purchase of a Mobile Field Office to allow community policing and crime ' prevention officers to take their message directly into neighborhoods and shopping centers. LIBRARY , ♦ Voted in the Inland Valley Daily Bulletin in 1997 as the 'Best Iabrary in the Valley", ' statistics from the State Library show the Rancho Cucamonga Public Library as the busiest library per hour in the state of California, with an average daily traffic count , of over 1,200 visitors and nearly 2,000 items borrowed each day. ♦ The Ubrary Telethon broadcast over Marks Cablevision in April of 1996 netted the , Library $41,000. The funds were used to open a new Technology Center in the area designated for lifelong learning. Consisting of 6 pentium computers, the Center , offers full Internet access and many PC and CD Rom programs to enhance job search skills and other vital adult learning skills. ♦ Friends of the Rancho Cucamonga Public Library received the 1996 CALTAC (California Association of Library Trustees and Commissioners) Award in recognition of the 50 individuals who have volunteered over 10,000 hours of their ' time managing a retail bookstore in the public library and donating over $100,000. ♦ Thanks to grants awarded by the State in Fiscal Year 1996-97, a volunteer ' tutor-based adult literacy program continues to flourish, along with a family literacy program, a multi-generational storytelling program and a project to develop a ' planned giving program for the library's Foundation. xvi ' ' CASH MANAGEMENT ' Cash not immediately needed to finance City operations during the year was invested in short-term money market instruments in accordance with State laws governing deposit of public funds. The ' City invests in time deposits from 14 to 720 days maturity, issues of federal agencies, bankers acceptances, mortgage securities and the State of California's, Local Agency Investment Fund (LAIF). It is the objective of staff to attain a greater percentage of invested funds, while ' maintaining the necessary reserves needed to fund City services. DEBT ADMINISTRATION ' The City of Rancho Cucamonga, as a general law city, is restricted from incurring general ' obligation bonded indebtedness which would exceed 3.75% of the total assessed valuation of all real and personal property. The City of Rancho Cucamonga does not have any general obligation debt; however, the City and its component units do have various bond and ' certificates of participation issues. Note 11 of the Notes to the Financial Statements of this report presents more detailed information about these issues. ' On September 1, 1996 the Rancho Cucamonga Redevelopment Agency issued 1996 Housing Set-Aside Tax Allocation Bonds in the amount of$37,665,000 in order (I) to repay the note issued by the Agency to Sanwa Bank in the remaining principal amount of$20,783,487; (ii) to pay off the non-taxable term loan to Sanwa Bank in the principal amount of$5,841,301 plus prepayment penalties; (iii) to complete the projects for which the loans were originated, ' namely Mountainsides Monterey Village and Sycamore Springs; and (iv) to make grants to the Southern California Housing Development Corporation and to the Northtown Housing Development Corporation. The issue consists of $8,970,000 Serial Bonds with maturities ' beginning September 1, 1997 through September 1, 2008 and $28,695,000 term bonds maturing thereafter. Interest is payable semi-annually on March 1, and September 1 of each ' year commencing March 1, 1997. RISK MANAGEMENT ' During Fiscal Year 1996-97, the City of Rancho Cucamonga continued its commitment to risk management programs for safety, general liability and workers' compensation. Aggressive ' claims handling and a strong litigation stand have assisted in maintaining an appropriate reserve for current and future claims payments. In addition, various risk control techniques, ' including employee accident prevention training, loss control techniques, loss control through safety programs and employee hazardous identification programs have been implemented to minimize accident-related losses and exposure by the public. The City of Rancho Cucamonga is self-funded for the first $100,000 of loss for general xvii liability claims and purchases coverage from $100,000 to $10.0 million dollars in loss. The ' City of Rancho Cucamonga utilizes a self-funded workers' compensation program. There will ' be an on-going commitment to risk management programs to ensure the safety of the public and city employees and to reduce the financial exposures from catastrophic losses within the City's boundaries. , III. PROSPECTS FOR THE FUTURE General Fund revenues, such as sales tax, permit and development fees, franchise fees, and , motor vehicle license fees are growth related and reflect a continued positive growth in the , economy in general. The result is greater stability; however, it is also accompanied by a greater demand for services from police to maintenance. Twenty-Five percent of the General Fund's proposed budget for Fiscal Year 1997-98 is attributable to increased police ' costs alone.. Growth continues to increase and becomes a significant factor in the provision of services. Our assessment districts currently remain stable at level A service level. The continued , installation of the moisture sensor program and continued wet seasons help to keep costs , stable even in the face of inflation. The successful retention of PD-85 through the property owner election has preserved the maintenance budget for Red Hill and Heritage Park. The biggest challenges continue to be costs imposed by other agencies that may not be easily ' passed on because of Proposition 218 constraints. Cucamonga County Water district has already informed the City informally that planned rate realignments will increase the City's ' water rates over a multi-year period of time. When implemented, such increases will increase the cost of the City's maintenance budgets, but these increases may not be translated into increased assessments without a property owner election. The result will be ' more costs that will be difficult, at best, to recover. Library services were fully implemented in Fiscal Year 1994-95 with the transfer of the San , Bernardino County Library Tax revenue to the City and the opening of the new library. The transition between County and the City has been tremendously successful with a much higher , level of service and exceptional community support. Through recent public surveys, the City will be addressing the need for greater noise and congestion control through the continuation of the Library monitor program and the addition of a full time Library Clerk to help reduce , long lines at the Circulation Desk. Additionally, all library computers are to be upgraded. Finally, the additional part time staffing is being obtained to provide full Internet access to the public from '"The Technology Center". , The Citys law enforcement contract with San Bernardino County Sheriffs Department ' continues to rise in cost with an eight point four percent (8.4%) increase. This increase xviii , incorporates a full year of the five new police officers added in April 1997. The Department will acquire two additional motorcycles for the Traffic Division to be utilized for enforcement duties designed to reduce traffic collisions. During Fiscal Year 1997-98, the Department will implement the mobile substation/command center that will increase the level of crime prevention and community interaction in our law enforcement program. The Redevelopment Agency continues to be aggressive in the area of local economic ' development. The Agency will continue its business outreach programs and local networking to insure that existing businesses continue to find success in the City. In Fiscal Year 1997-98, the Agency will be expanding its support of local business opportunities by development a local business assistance center where local companies can meet with consultants, free of charge, and receive information that will aid them in marketing, business plans, loan ' presentations, and other types of business assistance requests. The Capital Improvement Program for Fiscal Year 1997-98 contains nearly 70 projects with ' a budget of nearly $14,000,000. Major projects include: ' ♦ Design and construction of Day Creek Boulevard from Base Line Road to Highland Avenue which is coordinated with the Route 30 Freeway construction. ♦ Construction of Foothill Boulevard median between Hellman Avenue and Archibald Avenue. This project would be phased in three parts (multi-year). ' ♦ Rehabilitation of various local streets. ' Effective August 1996, City Council applied an accelerated version of the previously approved Utility Tax reduction formula. City Council has always maintained that if greater reductions could be accomplished beyond the formula, such would be directed. It is ' anticipated that during Fiscal Year 1997-97 the utility tax rate will reduce from 4.21% to 3.91%. The challenge continues to be sustaining services for a growing population as well as providing some tax relief while at the same time addressing increased costs with limited resources. Even as the economy in Southern California comes to life, additional imposed costs will continue as well as limitations on revenues. Our City must remain vigilant in its legislative efforts to protect its revenues and its ability to provide the needed services which ' residents and businesses demand and have come to expect here in Rancho Cucamonga. IV. FINANCIAL STATEMENT ANALYSIS ' The fiscal operations of the City are primarily accounted for in the Governmental Funds xix which include the General, Special Revenue, Debt Service and Capital Project funds. The ' total fund equity (aggregate fund balances) in these funds of $181.3 million reflects an ' increase of$9.7 million over the previous fiscal year. REVENUE ANALYSIS ' During Fiscal Year 1996-97, revenue and other sources amounted to approximately $152.5 , million which reflects an increase of$24.7 million when compared to the previous fiscal year. The following is a recap of Fiscal Year 1996-97 fiscal year general governmental fund type ' revenues by major source. Also presented is the percentage each source represents of total revenues, and the increase or (decrease) over the prior year. REVENUE BY SOURCE ' (amounts in thousands) Increase (Decrease) ' Revenue and Other Current Percent From Financing Sources Revenue of Total Prior Year , Taxes $ 58,718 38.5% $ 1,180 Licenses and permits 1,795 1.2% 202 Fines and forfeits 226 0.1% (65) , Use of money and property 8,966 5.9% 493 Intergovernmental 11,596 7.6% 417 Charges for services 2,976 2.0% 230 ' Development fees 3,604 2.4% 890 Other 3,370 2.2% 652 Total Operating Revenue: $ 91,251 59.8% $ 3,998 ' Debt proceeds 43,866 28.8% 16,749 Transfer from bond trustee - 0.0% (19) ' Operating transfers in 17,411 11.4% 3,923 TOTAL FINANCE SOURCES: $ 152,529 100.0% $ 24,652. ' As the City still continues to see a rise in retail and commercial facilities both expanding and ' relocating into our community we also obtained a $1.2 million increase in tax revenue. This is related primarily to increased sale and use tax and utility user tax in the General Fund of $434,498 and $385,420, respectively along with increases in property taxes of the , Redevelopment Agency and the Fire District of $139,630 and $173,932, respectively. Licenses and permits increased 201,649 primarily as a result of building permits increasing , $158,518 and business licenses increasing by 43,178. Again, this is due to businesses and xx ' ' commercial facilities expanding and relocating into our community. ' The Use of Money and Property increased $492,749 over the prior year due almost entirely to increased income from investments. Income from investments was able to increase over ' the prior year for the third time in approximately seven years due to a more stable cash flow and an increase in funds available to invest. ' Intergovernmental revenues increased $417,003 over the prior year because, in the General Fund, Motor Vehicle In-Lieu Fees increased $255,378 while state grant reimbursements and ' program grants in the prior year did not continue causing a reduction of ($199,339). Additionally, in Special Revenue Funds, various federal and state grants overall increased $361,137. An increase of $230,092 in developer activity is seen via the rise in revenues from Charges For Services, specifically related to Planning and Engineering fees. Also relating to ' developer activities is the increase of$890,250 in Development Fees. These are spread over several of our Special Revenue Funds with the most notable increases being in the System ' Development Fund and the Drainage Facilities Fund and amounting to $509,843 and $231,038, respectively. The increase in debt proceeds is due to the Redevelopment Agencys issuance of Housing ' Set-Aside Tax Allocation Bonds, 1996 Issue (Bonds) in the amount of$37.7 million and loans between the City and Redevelopment Agency in the amount of $6.2 million as compared to ' the previous years amount of 27.1 million. The Bonds were sold to the Bank of America which finalized the financing of the Senior Housing - Prairie Pacific Development Corporation. This project is to construct 159 senior apartment units adjacent to the City's library. The Loans ' represent financing to the Redevelopment Agency to accomplish its projects. ' EXPENDITURE ANALYSIS During Fiscal Year 1996-97, expenditures and other uses amounted to approximately $139.4 million which reflects an increase of $27.9 million when compared to that of the previous ' fiscal year. ' The following is a recap of the current year expenditures and other uses by major function, including the percentage each function represents of the total, along with the increase or (decrease) over the prior year. xxi 1 1 1 1 EXPENDITURES BY FUNCTION (amounts in thousands) ' Increase (Decrease) Expenditures and Other Current Percent From ' Fmanc' Uses Fxpenditures of Total Prior Year General government $ 12,247 8.8% $ 3,546 Public safety 15,444 11.1% 6,027 ' Public safety -fire protection 9,096 6.5% 145 Engineering and public works 8,593 6.2% (388) Community development 7,439 5.3% 950 Community services 3,010 2.2% (715) ' Capital outlay 16,978 12.2% (14,190) Debt service 45,208 32.4% 25,576 ' TotalGovemmentFacpenditures: $ 118,016 84.7% $ 20,950 Other 1,023 0.7% 972 ' Operating transfers out 20,319 14.6% 5,964 TOTAL FINANCING USES: $ 139,358 100.0% $ 27,887 ' The City's portion of the General government expenditure increase of $1.1 million is caused ' by various general administrative cost increases totaling 472,641 coupled with an increase of $586,068 and corresponding reduction in Engineering and public works costs due to the t reclassification between the current and prior year of expenditures in the System Development Fund. The remaining 2.4 million of the increase in General government expenditures was attributable to the Redevelopment Agency's increased activity in affordable ' housing projects. The General Fund's portion of the Public safety increase was $865,916. Approximately , $250,000 of this was due to the opening of the Animal Shelter. The remainder related to , the addition of five (5) police officers and cost of living adjustments on the County Sheriff contract. The remaining $5.2 million of the increase is again due to the Redevelopment Agency's increased activity in affordable housing projects. Here increases of $2.3 million and , $2.9 million occurred for project acquisition and subsidies to low and moderate income households, respectively. xxii , 1 ' For Engineering and public works overall there was a reduction of $388,124. This was ' primarily caused by the reclassification mentioned above, a reduction of$149,179 in the Gas Tax and other Special Revenue Funds along with increases of $347,123 in general projects. ' Community development increased $950,019 as a result of instituting Landscape District projects which were not present in the prior year and performing retrofits on various parks to comply with the American Disabilities Act. ' Community services decreased $715,052 as a result of a litigation settlement stemming from a 1989 park site condemnation purchase. This was settled in Fiscal Year 1995-96 with the ' expenditure being recorded then. ' The Capital outlay decrease was composed of two changes. First, capital outlay increased $3.2 million overall for the City with street, park and building improvement performed. ' These are described in the sections above. The majority of the funding for these projects was made from the Measure I Fund which had $2,846,863 of this increase. The second change is accounted for by the Redevelopment Agency's decreasing its capital outlay by $17,430,130 as a result of completing project/commitments during the prior year. The Debt service increase, of 25.6 million is related to the Redevelopment Agency's retirement of a loan from Sanwa Bank. This loan was the initial funding of the Senior Housing Project - Prairie Pacific Development Corporation which was done during Fiscal Year 1995-96. ' PROPRIETARY FUND TYPES A. Internal Service Fund ' The City maintains internal service funds for Vehicle Replacement and Data Processing Equipment/Technology Replacement. These fund are supported by user charges to ' customers; however, the Data Processing Equipment/Technology Replacement Fund was established during the current year by contributions from other funds and user charges to customers will not start until next year. Internal service funds account for services to the various departments within the City. The following represents activity during the current (1996-97) and the previous (1995-96) fiscal years: t ' xxiii 1 1 (amounts in thousands) t 1995-96 1996-97 , Operating Revenues $ 327 $ 195 ' Non-Operating Revenues 414 507 Operating Transfers In 500 2,671 Total Financing Sources 1,240 3,372 ' LESS: Operating Expenses 76 1,051 ' NET INCOME/ (LOSS) $ 1,165 $ 2,321 The Fleet Maintenance Fund increased its retained earnings by approximately $2.3 million. ' The fees to this Internal Service Fund are a combination of direct transfers of monies approved during the budgetary process and a formula to recapture vehicle and equipment , costs. A. Enterprise Fund , This enterprise fund was established for the Rancho Cucamonga Sports Complex, more ' commonly known as the Epicenter. This fund is supported by charges to customers, rental fees, and an admission tax. This fund accounts for personnel and operating costs directly associated with the operations of this facility. The following represents activity during the , current (1996-97) and the previous (1995-96) fiscal years: (amounts in thousands) , 1995-96 1996-97 Operating Revenues $ 1,053 $ 961 ' Non-Operating Revenues 207 148 t Operating Transfers In 366 237 Total Financing Sources 1,626 1,347 LESS: Operating Fxpenses 2,108 1,851 ' NET INCOME/ (LOSS) (482) (504) ' PLUS: Add Back Depreciation Related To Contnbuted Capital 419 430 CHANGE IN RETAINED EARNINGS $ (63) $ (74) ' xxiv , 1 ' The Enterprise Fund had a net reduction in retained earnings of $74,037 during Fiscal Year ' 1996-97. V. GENERAL FIXED ASSETS ' General fixed assets of the City are those fixed assets used in the performance of general governmental functions and exclude the fixed assets of Proprietary Funds. As of June 30, 1997 the general fixed assets of the City amounted to $114,062,622. This amount represents the original cost of the assets, net of additions and deductions from July 1, 1996 to June 30, 1997 and is considerably less than their present value. The system of accounting presently ' recommended by the Governmental Accounting Standards Board (GASB) does not allow for the recording of depreciation of general fixed assets as an expense of governmental funds. ' VI. INDEPENDENT AUDIT The required audit of the books of accounting and financial records, and transactions of all departments of the reporting entity was conducted by independent certified public accountants selected by the City Council. The auditors opinion has been included in the Financial Section of this report. VIL ACKNOWLEDGMENTS The cover photograph on this Fiscal Year 1996-97 Comprehensive Annual Financial Report was taken by David A. Gautreau. ' The preparation of this report on a timely basis could not have been accomplished without ' the efficient and dedicated services of the entire staff of the Finance Department and the administration staff of the Administrative Services Department. We appreciate and would like to commend all the City departments who assisted and contributed material. We also ' recognize and would like to acknowledge the Mayor and members of the City Council for their interest, dedication, and constant support in planning and conducting the financial operations of the City in a responsible and progressive manner. Respectfully Submitted, a�� Jack Lam, AI Lawrence I. Temple City Manager Administrative Services Director xxv 1 This page intentionally left blank. ' 1 1 1 1 CITY OF RANCHO CUCAMONGA, CALIFORNIA CITY OFFICIALS JUNE 30, 1997 ' CITY COUNCIL Name Term Expires William J. Alexander Mayor 1998 ' Rex Gutierrez Mayor Pro Tem 2000 ' Paul Biane Councilmember 2000 ' James V. Curatalo Councilmember 1998 Diane Williams Councilmember 1998 ADMINISTRATION AND DEPARTMENT HEADS City Manager and Executive Director of the Rancho Cucamonga Redevelopment Agency Jack Lam ' Deputy City Manager Jerry Fulwood ' City and Redevelopment Agency Attorney James L. Markman Treasurer(term expires 2000) James Frost ' City Clerk (term expires 2000) Debra Adams ' Redevelopment Agency Manager Linda Daniels Administrative Services Director Lawrence I. Temple Finance Officer Susan Stark ' City Planner Brad Buller Building Official Bill Makshanoff 1 City Engineer Joe O'Neil tCommunity Service Manager Suzanne Ota Library Manager Debra Clark ' xxvi The Rancho Cucamonga Team CITY COUNCIL (RDABOARD) ___ CITY CLERK _ CITYTREASURER (FIRE BOARD) PARK&RECREATION BOARDOFLIBRARY PLANNING/ I_______________ COMMISSION TRUSTEES Fly ST.PRESERVATION ------------- I COMMISSION I I 1 I I I 1 1 1 I I 1 j CrrY ATTORNEY CITY MANAGER I 1 I (contract) --- (RDAEXEC.DIR.) 1 1 1 1 X 1 1 I k 1 I 1 F,. I 1 I I I I ADMIMSTRATION I I 1 j I I I I 1 I 1 1 I 1 COMMUNITY j DEVELOPMENT DEPT. I I I I COMM. LAW FIRE ADMIN. LBIRARY BLDG& ENG/PW& SERVICES FETY ENFORCEMENT DISTRICT SERVICES SERVICES SAMMrr PLANNWC >r Ali r MMIM _I sdverwaad S4N `ix �Lde Lake Anodw+od 1 Ftp u5 Son Gabvoi s 1 RANCHO 41M,yb. 0 oar's j�' ryT/,CUC�AMONCA 6 �4 f Cie Pasadena �Aasmvor �4' r v k210 /� No s� � Pastan RL 66 Sm 8emkfio AhmAra Rdboome Fp QRes ' 1-10 Lhtma Calm Ream 60 —L Sm_BmamQro_ 0460 '� RbMou ds 18eas�e �. �CoLrl➢ .—.—. R kz Los C� •• i — sous we r Orange •� 1 Hwy.60 (ewers de Dowley ~ 91 ' Pak lm Placenta `� 1 + 'C Lakewood Lake watuns l�Lake • A,ddelh Perry Long imdel CloveBeach ' Santa� Am 4%. �6 Rservm 1 ABOUT RANCHO CUCAMONGA Rancho Cucamonga is situated in the southwest corner of San Bernardino County, 37 miles east of downtown Los Angeles and 15 miles west of downtown San Bernardino. The San Gabriel Mountains rise majestically to the north and the communities of Upland, Ontario and Fontana surround the City on the west, south and east respectively. In a region known as the West Valley, Rancho Cucamonga is strategically located at the hub on an extensive transportation network and within short commute distances of major employment centers in southern California. The city encompasses the 37.5 square miles which originally made up the communities of Cucamonga,Alta Loma and Etiwanda, becoming the incorporated City of Rancho Cucamonga in 1977. . 1 Certificate of 1 Achievement for Excellence 1 in Financial 1 Reporting Presented to City of Rancho Cucamonga, California fi For its Comprehensive Annual 1 Financial Report for the Fiscal Year Ended June 30, 1996 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 1 standards in government accounting and financial reporting. mom mFp I W U'M 1110 a cm r President >� ssn, gS666 V '� w . Oy � ill 7(V�"/eZc�of/tfiyve(✓Dire(c/toAr�//'L/ 1 xxix 1 M M M M M M M M M M Mae MM MMM M i r/00�j California Society of Municipal Finance Officers Certificate of Award Outstanding Financial Reporting 1995-96 Presented to the x City of Rancho Cucamonga Thtr cerrJ?cate is irsued in recognition of meeting professional standards and criteria/n reporring which reflect a high level of quality in the annual financial statements and/n the underlying accounting system from which the reporb wen prepared February 24, 1997 air.Pr ulonl&Technical Sundudr Commince President CSMFO 86 Dedicated to Excellence in Municipal Financial Management X This page intentionally left blank. ' r t FINANCIAL SECTION z 0 H U W a U z 44 z w This page intentionally left blank. z 0 F U W a U z z w Burr \r (714) orth Brea Boulevard Brendon.P rker 8 ISLLance Donaltl L.Parker I &. e 203 Michael K.Chu haea, CA 92821-4056 David E.Hale ' 9 672-0022 A � Fax(714)672-0331 Robert C.Lance CERTIFIED PUBLIC ACCOUNTANTS 'd Richarrd C.C.Shc Fred J.Lun®hard,Jr. City COUnCII City of Rancho Cucamonga Rancho Cucamonga, CA 91730 INDEPENDENT AUDITORS' REPORT ' We have audited the general purpose financial statements of the City of ' Rancho Cucamonga, as of and for the year ended June 30, 1997 as listed in the accompanying table of contents. These general purpose financial statements are the responsibility of the City's management. Our responsibility is to express an opinion on these general purpose financial statements based on our audit. We conducted our audit in accordance with generally accepted auditing standards. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the general purpose financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the general purpose financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall general purpose financial statement presentation. We believe that our audit provides a reasonable basis for our opinion. In our opinion, the general purpose financial statements referred to above present fairly, in all material respects, the financial position of the City of Rancho Cucamonga, at June 30, 1997, and the results of its operations and the cash flows of its proprietary fund types for the year then ended in conformity with generally accepted accounting principles. ' Our audit was made for the purpose of forming an opinion on the general purpose financial statements taken as a whole. The supplemental schedules listed in the accompanying table of contents are presented for purposes of additional analysis and are not a required part of the general purpose financial statements of the City of Rancho Cucamonga. Such information has been subjected to the auditing procedures applied in ' the audit of the general purpose financial statements and, in our opinion, is fairly presented in all material respects in relation to the general purpose financial statements taken as a whole. ' September 18, 1997 MEMBER CALIFORNIA SOCIETY OF CERTIFIED PUBLIC ACCOUNTANTS AMERICAN INSTITUTE OF CERTIFIED PUBLIC ACCOUNTANTS 1 This page intentionally left blank. UOmm — ZWp cnI— QF- W � WZHcn 1 1 1 1 This page intentionally left blank. 1 1 1 1 . 1 1 1 1 1 1 1 1 i 1 CITY OF RANCHO CUCAMONGA Exhibit A COMBINED BALANCE SHEET-ALL FUND TYPES AND ACCOUNT GROUPS JUNE 30, 1997 FIDUCIARY GOVERNMENTAL FUND TYPES PROPRIETARY FUND TYPES FUND TYPE ACCOUNT GROUPS General General TOTALS Special Debt Capital Internal Fixed Long-Term (Memorandum Only) ASSETS AND OTHER DEBITS General Revenue Service Projects Enterprise Service Agency Assets Debt 1997 1996 Cash and investments(Notes 1 and 3) $ 28,472,513 E 26,467,844 $15,691,734 S 70,766,118 $ 159,344 E 13,566,343 $ 10.597,613 $ - S $ 165,721,509 $ 148,546,666 Cash and investments with fiscal agent(Note 3) - - 5,452,184 - - - 5,422,471 - - 10,874,655 10,363,567 Restricted cash(Note 3) - - - 790,000 - - 7,663,968 - - 8,453,960 7,421,981 Investment-land held for resale(Notal) - - - 8,501,294 - - - - - 8,501,294 10,778,871 Receivables(net of uncollectibles) 2,554,509 2,181,252 188,585 12,527,526 99,609 - 125,149 - - 17,676,630 15,546,545 Due from other funds(Note 13) 2,321,381 18,094 397,659 3,152,119 - - - - - 5,889,453 1,659,972 Deposits - - - 430,500 - - - - - 430,500 541,241 Prepaid PERS costs(Note 4) 1,412,421 - - - - - - - - 1,412,421 1,096,403 Advances to other funds(Note 13) 16,176,627 - - 4,290,000 - - - - - 20,466,627 19,062,211 Fixed assets-net book value(Notes 7 and 8) - - - - 20,131,772 1,216,168 - 114,062,622 - 135,410,562 132,698,653 Amount available in debt service funds - - - - - - - - 20,482,453 20,482,453 19,519,025 Amount to be provided for retirement of general long-term debt - - - 167,363,013 167,363,013 159,341,866 Total Assets and Other Debits $ 50,937,451 E 287667,190 $21,730,362 E 100,457,557 $ 20,390,725 § 14,782,511 $ 23,809,201 $ 114,062,622 $187,845,466 $ 562,683,085 $ 526,577,001 LIABILITIES,FUND EQUITY AND OTHER CREDITS Liabilities: Accounts payable $ 792,492 $ 1,207,725 $ 1,232,148 E 267,282 $ 96,410 S 329,141 $ 168,145 $ - $ - $ 4,093,343 $ 2,861,785 Accrued payroll payable 133,180 317,069 - - 13,294 - 5,651 - - 469,194 490,202 Accrued employee benefits (Note 11) 1,465,608 625,991 - - - - - - 1,722,677 3,814,276 3,345,778 Deposits - - - 3,864 - - 7,614,669 - - 7,618,533 7,413,901 Due to other funds(Note 13) 363,209 2,242,141 15,150 3,267,099 - - 1,854 - - 5,889.453 1,659,972 Due to other governments - 268,372 611 - - - - - - 268,983 217,455 Deferred revenue(Notes 6) 7,860,760 172,400 - - - - - - - 8,033,160 6,534,015 Deferred compensation payable(Note 16) - - - - - - 5,422,471 - - 5,422,471 4,541,108 Obligation under capital leases(Note 11) - - - - - - - - 627,148 627,148 875,340 Bond indenture reserve requirements - - - - - - 1,457,580 - - 1,457,580 1,457,580 Payable to trustee - - - - 9,138,831 - - 9,138,831 8,758,555 Advances from other funds(Note 11 and 13) - 300,000 - - - - - - 20,166,627 20,466,627 19,062,211 Bonds and notes payable(Note 11) - - - - - - - - 148,465,000 148,465,000 113,360,000 Developer loans payable(Note 11) - - 16,864,014 16,864,014 44,464,414 Total Liabilities 10,615,249 5,133,698 1,247,909 3,538,245 109.704 329,141 23,809,201 187,845,466 232,628,613 215,042,316 Fund Equity and Other Credits: Contributed capital - - - - 20,072,998 3,750,000 - - - 23,822,998 20,540,307 Investment in general fixed assets - - - - - - - 114,062,622 - 114,062,622 111,622,070 RetainedRrued(Note 10,703,370 - - - 10,703,370 7,565,268 Reserved(Note 14) - - - - 208,023 - - - - 208,023 219,603 Unreserved - - - Fund balances: Reserved(Note 14) 10,914,978 9,263,879 20,886 28,847,370 - - - - - 49,047,113 46,336,457 Unreserved: Designated(Note 14) 29.407,224 5,394,760 20,461,567 66,901,008 - - - - - 122,164,559 117,717,185 Undesignated 8,874,853 - 1,170,934 - 10,045,787 7,533,795 Total Fund Equity and Other Credits 40,322,202 23,533,492 20,482,453 9Q919,312 20,281,021 14,453,370 - 114,062,622 330,054,472 311,534,685 Total Liabilities,Fund Equity and Other Credits § 50,937,451 S 28,667,190 $21,730,362 $100,457,557 $ 20,390,725 $ 14,782,511 $ 23,809,201 $ 114,062,622 $187,845,466 $ 562,683,085 $ 526,577,001 See Notes to Financial Statements 2 CITY OF RANCHO CUCAMONGA Exhibit B COMBINED STATEMENT OF REVENUES, Pagel c12 EXPENDITURES AND CHANGES IN FUND BALANCES ALL GOVERNMENTAL FUND TYPES FOR THE FISCAL YEAR ENDED JUNE 30, 1997 GOVERNMENTAL FUND TYPES TOTALS Special Debt Capital (Memorandum Only) General Revenue Service Projects 1 9 9 7 1 9 9 6 Revenues: Taxes $ 21,862,262 $ 14,077,707 $ 17,562,306 $ 5,215,670 $ 58,717,945 Licenses and permits 1.795.225 $ 57,537,967 Fines and forfeits 208,675 16,853 1,795,225 1,593,576 Y Use of mons and - 225,728 291,189 Intergovernmental property rtY 2,411,805 1,099,656 524,759 4,929,527 8,965,747 8,472,995 5,439,152 6,157,258 Charges for services - 11,596,410 11,179,404 1,084,568 Development fees 1,891,515 3 604 000 - 2,976,083 2,745,991 Other - 3,604,000 2,713,750 3,008,235 362,103 3,370,338 2,718,267 Total Revenues 36,615,069 26,404,145 18,087,065 10,145,197 91,251,476 87,253,139 Expenditures: Current: General government 5,365,830 2,249,055 776,206 3,855,740 12,246,831 Public safety 10,282,929 - 8,700,927 - 5,161,220 15,444,149 9,417,013 Public safety-fire protection 9,096,377 - 9,096,377 8,951,549 Engineering and public works 6,495,631 1,910,593 166,619 8,592,843 8,980,967 Community development 2,928,892 4,509,988 7,438,880 6,488,858 Community services 1,124,226 1,885,977 Capital outlay - 3,010,203 3,725,252 Debt service: 7,372,232 125,911 9,479,676 16,977,819 31,168,055 Principal 102,502 193,612 8,981,695 25,778,705 35,056,514 9,586,760 Interest and fiscal charges 17,715 106,699 6,668,262 3,359,230 10,151,906 10,046,013 Total Expenditures 26,317,725 27,324,533 16,552,074 47,821,190 118,015,522 97,065,394 Excess of Revenues over (under) Expenditures 10,297,344 (920,388) 1,534,991 (37,675,993) (26,764,046) (9,812,255) See Notes to Financial Statements 3 CITY OF RANCHO CUCAMONGA Exhibit B Page 2 of 2 COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES ALL GOVERNMENTAL FUND TYPES FOR THE FISCAL YEAR ENDED JUNE 30,1997 GOVERNMENTAL FUND TYPES TOTALS Special Debt Capital (Memorandum Only) General Revenue Service Projects 1997 1996 Other Financing Sources(Uses): Operating transfers in $ - $ 1,128,635 $ 8,719,932 $ 7,562,485 $ 17,411,052 $ 13,488,182 Operating transfers out (4,425,400) - (8,703,503) (7,190,090) (20,318,993) (14,354,541) Debt proceeds 97,081 - - 43,769,415 43,866,496 27,117,351 Transfer from bond trustee - - - - - 18,730 Other 492,722 (587,992) (928,009) (1,023,279) (50,781) Total Other Financing Sources(Uses) (4,328,319) 1,621,357 (571,563) 43,213,801 39,935,276 26,218,941 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses $ 5,969,025 $ 700,969 $ 963,428 $ 5,537,808 $ 13,171,230 $ 16,406,686 Fund Balances: Beginning of Fiscal Year-as previously reported $ 37,998,324 $ 22,748,884 $ 19,519,025 $ 91,321,204 $ 171,587,437 $155,180,751 Restatements(Note 14) 104,853 83,639 - 60,300 248,792 Beginning of Fiscal Year-as restated 38,103,177 22,832,523 19,519,025 91,381,504 171,836,229 155,180,751 Excess of Revenues and Other Sources over(under) Expenditures and Other Us3s 5,969,025 700,969 963,428 5,537,808 13,171,230 16,406,686 Residual Equity Transfer(Note 14) (3,750,000) (3,750,000) End of Fiscal Year(Exhibit A) $ 40,322,202 $ 23,533,492 $ 20,482,453 $ 96,919,312 $ 181,257,459 $171,587,437 See Notes to Financial Statements 4 CITY OF RANCHO CUCAMONGA Exhibit C COMBINED STATEMENT OF REVENUES, EXPENDITURES Page 1 of 4 AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL(BUDGETARY BASIS) ALL GOVERNMENTAL FUND TYPES FOR THE FISCAL YEAR ENDED JUNE 30,1997 GENERAL FUND SPECIAL REVENUE FUNDS DEBT SERVICE FUNDS Variance- Variance- Varlanee- Favorable Favorable Favorable Revenues: Budget Actual Unfavorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) Taxes $20,947,500 $21,862,262 $ 914,762 $ 13,391,436 $ 14,077,707 $ 686,271 $ 17,291,405 $ 17,562,306 $ 270,901 Licenses and permits 1,572,300 1,795,225 222,925 Fines and forfeits 266,900 206,875 (60,025) 83,620 18,853 (64,767)Use of money and property 1,760,000 2,411,805 651,805 719,119 1,099,656 380,537 Intergovernmental 4,656,850 5,439,152 782,302 8,021,510 6,157,256 510,422 510,422 Charges for services (1,864,252) - - Development fees 1,777,400 1,891,515 114,115 1,040,790 1,084,568 43,778 - 2,463,700 3,575,197 1,111,497 _ Other 2,905,480 3,008,235 102,775 333,870 362,103 28,233 Total Revenues 33,886,410 36,615,069 2,728,659 26,054,045 26,375,342 321,297 17,291,405 18,072,728 781,323 Expenditures: Current: General government 8,482,156 5,783,982 2,698,174 2,362,030 2,260,626 101,404 1,306,790 779, Public safety 10,865,318 10,289,005 576,313 417 527,373 _ _ Public salary•fire protection - - 9,213,160 9,096,377 116,783 _ Engineering and public works 7,005,384 6,680,707 324,677 2,093,023 1,919,780 173,243 _ Community development 3,087,040 2,975,855 111,185 5,153,123 4,566,129 586,994 _ Community services 1,215,262 1,124,290 90,972 2,194,989 1,948,733 246,256 Capital outlay - - - 9,285,035 8,108,604 1,176,431 150,000 143,586 6,414 Debt service: Principal - 102,502 (102,502) 25,000 193,612 (168,612) 18,695,860 6,651,695 10,044,165 Interest and fiscal charges 17,715 (17,715) 99,062 106,699 (7,637) 8,439,072 6,602,059 1,837,013 Total Expenditures 30,655,160 26,974,056 3,681,104 30,425,422 28,200,560 2,224,862 28,591,722 16,176,757 12,414,965 Excess of Revenues over (under)Expenditures $ 3,231,250 $ 9,641,013 $ 6,409,763 It (4,371,377) $ (1,825,218) $ 2,546,159 $(11,300,317) $ 1,895,971 $ 13,196,288 See Notes to Financial Statements 5 CITY OF RANCHO CUCAMONGA Exhibit C Page 2 of 4 COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL(BUDGETARY BASIS) ALL GOVERNMENTAL FUND TYPES FOR THE FISCAL YEAR ENDED JUNE 30, 1997 GENERAL FUND SPECIAL REVENUE FUNDS DEBT SERVICE FUNDS Variance- Variance- Variance- Favorable Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) Budget Actual (Unfavorable) Other Financing Sources(Uses): Operating transfers in $ - $ - $ - $ 1,323,490 $ 1,128,635 $ (194,855) $ 8,331,110 $ 8,331,108 $ (2) Operating transfers out (1,190,551) (4,425,400) (3,234,849) - - - (8,525,435) (8,703,503) (178,068) Debt proceeds - 97,081 97,081 - - - Other - - 492,722 492,722 (3,273,590) (587,992) 2,685,598 Transfer from bond trustee - - - - - - - Contribution to Fire District - - - - - - - - - Contribution to Agency Fund - Total Other Financing Sources(Uses) (1,190,551) (4,328,319) (3,137,768) 1,323,490 1,621,357 297,867 (3,467,915) (960,387) 2,507,528 Excess of Revenues and Other Sources over(under) Expenditures and Other Uses(Budgetary Basis) 2,040,699 5,312,694 3,271,995 (3,047,887) (203,861) 2,844,026 (14,768,232) 935,584 15,703,816 Adjustments: To adjust for encumbrances(Note 1) 656,331 656,331 876,027 876,027 20,886 20,886 Excess of Revenues and Other Sources over(under) Expenditures and Other Uses (GAAP Basis).Budgetary Classifications 2,040,699 5,969,025 3,928,326 (3,047,887) 672,166 3,720,053 (14,768,232) - 956,470 15,724,702 Other Adjustments: To record excess of Revenues and Other Sources over(under) Expenditures and Other Uses for nonbudgeted funds(Note 1) 28,803 28,803 6,958 6,958 Excess of Revenues and Other Sources over (under) Expenditures and Other Uses(GAAP Basis) It 2,040,699 $ 5,969,025 $ 3,928,326 1 (3,047,887) $ 700,969 $ 3,748,856 1(14,768,232) $ 963,428 $ 15,731,660 Fund Balances: Beginning of Fiscal Year-as previously reported $37,998,324 $ 37,998,324 $ - $ 22,748,884 $22,748,884 $ - $ 19,519,025 $ 19,519,025 $ - Restatements(Note 14) 104,853 104,853 83,639 83,639 Beginning of Fiscal Year-as restated 37,998,324 38,103,177 104,853 22,748,884 22,832,523 83,639 19,519,025 19,519,025 - Excess of Revenues and Other Sources over(under) Expenditures and Other Uses (GAAP Basis) 2,040,699 5,969,025 3,928,326 (3,047,887) 700,969 3,748,856 (14,768,232) 963,428 15,731,660 Residual Equity Transfer(Note 14) (3,250,000) (3,750,000) (500,000) - End of Fiscal Year(Exhibit A) $36,789,023 L40,322,202 $ 3,533,179 $ 19,700,997 $ 23,533,492 $ 3,832,495 $ 4,750,793 $ 20,482,453 $ 15,731,660 See Notes to Financial Statements 6 CITY OF RANCHO CUCAMONGA Exhlb)i C COMBINED STATEMENT OF REVENUES,EXPENDITURES Page 3 Of 4 AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL(BUDGETARY BASIS) ALL GOVERNMENTAL FUND TYPES FOR THE FISCAL YEAR ENDED JUNE 30,1997 TOTALS(MEMORANDUM ONLY) CAPITAL PROJECTS FUNDS 1997 1 8 8 6 Varlance- Variance- BudgetFavorable Favorable Actual (Unfavorable) Budget Actual (Unfavorable) Actual Revenues: Taxes $ 8,456,020 $ 5,215,670 $ (3,240,350) $ 60,086,361 $ 58,717,945 $ (1,368,416) $ 57,537,967 Licenses andpermits - - - 1,572,300 1,795,225 222,925 1,593,576 Fines end forfeits 350,520 225,728 (124,792) 291,189 Use of money and property 68,490 4,929,527 4,861,037 2,547,609 8,951,410 6,403,801 Intergovernmental 8,456,84212,678,360 11,596,410 (1 '15 ) 11.179,404 Development fees Charges for Development services - - - 2,818,190 2,976,083 7,8932,745,991 Other - 2,463,700 3,575,197 1,111,497 2,685,361 3,239,330 3,370,338 131,008 2,718,267 Total Revenues 8,524,510 10,145,197 1,620,687 85,756,370 91,208,336 5,451,966 87,208,597 Expenditures: Current: General government 1,518,950 3,923,188 (2,404,238) 13,669,926 12,747,213 922,713 8,758,173 Public safety - 10,865,318 10,289,005 576,313 9,473,750 Public safety-fire protection - 9,213,160 9,096,377 116,783 8,951,549 Engineering and public works 493,300 186,619 306,681 9,591,707 8,787,106 804,601 9,262,954 Community development 2,307,577 5,161,220 10,547,740 12,703,204 (2155,464) 6,569,471 Community services - 3,410,251 3,073,023 337,228 3,735,476 Capital outlay 13,444,019 13,983,253 (539,234) 22,879,054 22,235,443 643,611 35,672,033 Debt service: Principal 30,784,562 25,778,705 5,005,857 49,505,422 34,726,514 14,778,908 9,276,760 Interest and fiscal charges 2,715,339 3,359,230 (643,891) 11,253,473 10,085,703 1,167,770 9,957,163 Total Expenditures 51,263,747 52,392,215 1,725,175 140,936,051 123,743,588 17,192,463 101,657,329 Excess of Revenues over (under)Expenditures $ (42,739,237) $(42,247,018) $ 492,219 $ (55,179,681) $ (32,535,252) $ 22,644,429 $ (14,448,732) See Was to Financial Statements 7 CITY OF RANCHO CUCAMONGA Exhibit C Page 4 of 4 COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL(BUDGETARY BASIS) ALL GOVERNMENTAL FUND TYPES FOR THE FISCAL YEAR ENDED JUNE 30, 1997 TOTALS(MEMORANDUM ONLY) CAPITAL PROJECTS FUNDS 1997 1996 Variance- Variance- Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) Actual Other Financing Sources(Uses): - Operatingtransfersin $ 6,478,845 $ 7,562,485 $ 1,083,640 $ 16,133,445 $ 17,022,228 $ 888,783 $ 13,132,197 Operating transfers out (7,190,990) (7,190,090) 900 (16,906,976) (20,318,993) (3,412,017) (14,354,541) Debt proceeds 41,713,905 43,769,415 2,055,510 41,713,905 43,866,496 2,152,591 27,117,351 Other (2,963,993) (928,009) 2,035,984 (6,237,583) (1,023,279) 5,214,304 (50,781) Transfer from bond trustee - - - - - - - Contribution to Fire District - - - - - - Contribution to Agency Fund Total Other Financing Sources(Uses) 38,037,767 43,213,801 5,176,034 34,702,791 39,546,452 4,843,661 25,844,226 Excess of Revenues and Other Sources over(under) Expenditures and Other Uses(Budgetary Basis) (4,701,470) 966,783 5,668,253 (20,476,890) 7,011,200 27,488,090 11,395,494 Adjustments: To adjustfor encumbrances(Note 1) 4,571,025 4,571,025 6,124,269 6,124,269 4,990,785 Excess of Revenues and Other Sources over(under) Expenditures and Other Uses (GAAP Basis)-Budgetary Classifications (4,701,470) 5,537,808 10,239,278 (20,476,890) 13,135,469 33,612,359 16,386,279 Other Adjustments: To record excess of Revenues and Other Sources over(under) Expenditures and Other Uses for nonbudgeted funds(Note 1) 35,761 35,761 20,407 Excess of Revenues and Other Sources over (under) Expenditures and Other Uses(GAAP Basis) - $ (4,701,470) $ 5,537,808 $ 10,239,278 1_@2.476,890 $ 13,171,230 $ 33,648,120 $ 16,406,686 Fund Balances: Beginning of Fiscal Year-as previously reports $ 91,321,204 $ 91,321,204 $ - $171,587,437 $ 171,587,437 $ - $ 155,180,751 Restatements(Note 14) 60,300 60,300 248,792 248,792 Beginning of Fiscal Year-as restated 91,321,204 91,381,504 60,300 171,587,437 171,836,229 248,792 155,180,751 Excess of Revenues and Other Sources over(under) Expenditures and Other Uses (GAAP Basis) (4,701,470) 5,537,808 10,239,278 (20,476,890) 13,171,230 33,648,120 16,406,686 Residual Equity Transfer(Note 14) (3,250,000) (3,750,000) (500,000) End of Fiscal Year(Exhibit A) $ 86,619,734 $ 96,919,312 $ 10,299,578 $147,860,547 $ 181,257,459 $ 33,396,912 $ 171,587,437 See Notes to Financial Statements 8 CITY OF RANCHO CUCAMONGA Exhibit D COMBINED STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS ALL PROPRIETARY FUND TYPES FOR THE FISCAL YEAR ENDED JUNE 30,1997 TOTALS(Memorandum Only) Enterprise Internal Year ended June 30, Operating Revenues: Sports Complex Service 1997 1996 Charges for services $ 600,491 $ 194,530 $ 795,021 $ 933,790 Rents 360,734 - 360,734 445,489 Total Operating Revenues 961,225 194,530 1,155,755 1,379,279 Operating Expenses: Salaries and benefits 618,754 - 618,754 766,149 Administrative costs 1,967 Maintenance and operations 442,676 - 442,676 543,689 Contractual services 348, - 348,249 371,602 Vehicle and equipment maintenance - 921,194 921,194 5,413 Depreciation 441,121 129,714 570,835 495,133 Total Operating Expenses 1,850,800 1,050,908 2,901,708 2,183,953 Operating Income(Loss) (889,575) (856,378) (1,745,953) (804,674) Nonoperating Revenues: Taxes 143,556 - 143,556 413,869 Interest income 506,805 506,805 202,733 Miscellaneous 4,672 4,672 4,415 Total Nonoperating Revenues 148,228 506,805 655,033 621,017 Net Income(Loss) Before Operating Transfers (741,347) (349,573) (1,090,920) (183,657) Operating transfers in 237,320 2,670,621 2,907,941 866,359 Net Income(Loss) (504,027) 2,321,048 1,617,021 682,702 Add back depreciation related to contributed capital 429,990 429.990 419,079 Increase(Decrease)in Retained Earnings $ (74,037) $ 2,321,048 $ 2,247,011 $ 1,101,781 Retained Earnings: Beginning of Fiscal Year-as previously reported $ 219,603 $ 7,565,268 $ 7,784,871 $ 6,683,090 Restatements(Note 16) 62,457 817,054 879,511 Beginning of Fiscal Year-as restated 282,060 8,382,322 8,664,382 6,683,090 Increase(Decrease)In Retained Earnings (74,037) 2,321,048 2,247,011 1,101,781 End of Fiscal Year $ 208,023 $ 10,703,370 $ 10,911,393 $ 7,784,871 See Notes to Financial Statements 9 CITY OF RANCHO CUCAMONGA Exhibit E COMBINED STATEMENT OF CASH FLOWS ALL PROPRIETARY FUND TYPES FOR THE FISCAL YEAR ENDED JUNE 30, 1997 TOTALS(Memorandum Only) Enterprise Internal Year ended June 30, Sports Complex Service 1997 1 9 9 6 Cash Flows from Operating Activities: Operating Income $ (889,575) $ (856,378) $ (1,745,953) $ (804,674) Adjustment to reconcile Operating Income to Net Cash: Depreciation 441,121 129,714 570,835 495,133 Miscellaneous income 4,672 - 4,672 4,415 Adjustment to beginning retained earnings - 817,054 817,054 - Changes in Assets and Liabilities: (Increase)decrease in taxes receivable - - - - (Increase)decrease In accounts receivable 20,923 - 20,923 (21,472) (Increase)decrease in due from Redevelopment Agency - - - - (Increase)decrease in due from other funds - - - 15,000 Increase(decrease) in accounts payable (17,337) 179,982 162,645 17,689 Increase(decrease)in accrued payroll payable (3,773) - (3,773) 153,835 Increase(decrease)in due to other funds (66,783) (66,783) 66,783 Total Adjustments 378,823 1,126,750 1,505,573 731,383 Net Cash Provided(Used)by Operating Activities (510,752) 270,372 (240,380) (73,291) Cash Flows from Noncapital Financing Activities: Taxes 143,556 - 143,556 202,733 Operating transfers in 237,320 2,670,621 2,907,941 866,359 Contirbuted capital(Note 18) 3,750,000 3,750,000 Net Cash Provided(Used) by Noncapital Financing Activities 380,676 6,420,621 6,801,497 1,069,092 Cash Flows from Capital and Related Financing Activities: Principal payments on capital leases - - - Acquisition of fixed assets (817,054) (817,054) (323,759) Net Cash Provided(Used)by Capital and Related Financing Activities (817,054) (817,054) (323,759) Cash Flows from Investing Activities: Interest on investments 506,805 506,805 413,869 Net Cash Provided(Used) by Investing Activities 506,805 506,805 413,869 Net Increase(Decrease) in Cash and Investments (129,876) 6,380,744 6,250,868 1,085,911 Cash and Investments at Beginning of Year 289,220 7,185,599 7,474,819 6,388,908 Cash and Investments at End of Year $ 159,344 $13,566,343 $ 13,725,687 $ 7,474,819 SCHEDULE OF NONCASH TRANSACTIONS There were no non-cash transections during the fiscal year. See Notes to Financial Statements 10 CITY OF RANCHO CUCAMONGA NOTES TO FINANCIAL STATEMENTS JUNE 30, 1997 I. SIGNIFICANT ACCOUNTING POLICIES Note 1: Organization and Summary of Significant Accounting Policies a. Description of the Reporting Entity The City of Rancho Cucamonga was incorporated on November 30, 1977 under the laws of the State of California and enjoys all the rights and privileges applicable to a General Law City. it is governed by an elected five-member board. As required by generally accepted accounting principles, these financial statements present the City of Rancho Cucamonga (the primary government) and its component units. The component units discussed below are included in the reporting entity because they have the same governing body as that of the primary government and because of their operational financial relationship with the City of Rancho Cucamonga. Blended component units: The Rancho Cucamonga Redevelopment Agency was established on May 20, 1981 pursuant to the State of California Health and Safety Code, Section 33000. Its purpose is to prepare and carry out plans for the improvement, rehabilitation and development of blighted areas within the territorial limits of the City of Rancho Cucamonga. Separate financial statements may be obtained from the Agency. The Rancho Cucamonga Public Improvement Corporation was incorporated on November 14, 1988 under the Non-Profit Public Benefit Corporation Law of the State of California. The Corporation was established for charitable purposes including rendering financial assistance to the City by financing, acquiring, constructing, improving and leasing public improvements for the benefit of residents of the City and the surrounding area. Separate financial statements are not available for the Corporation. The Rancho Cucamonga Fire Protection District (formerly, Foothill Fire Protection District) was a special district formed by the County of San Bernardino for the purpose of fire suppression within its boundaries. Effective July 1, 1989, operations of this district were taken over by the City of Rancho Cucamonga. The district still operates as a separate special district; however, now it is under the control of the City of Rancho Cucamonga instead of the County of San Bernardino. Separate financial statements are available for the District. The Rancho Cucamonga Library was part of the San Bernardino County Library System in which the City of Rancho Cucamonga participated. Effective July 1, 1994 and pursuant to California Code Section 19104, the City withdrew from the County Library System. 11 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 1: Organization and Summary of Significant Accounting Policies (Continued) As of this date, the library operates as a separate entity under the control of the City of Rancho Cucamonga. Separate financial statements are not available for the library. b. Description of Funds Fund Accounting Systems Governmental accounting systems are organized and operated on a fund basis. A fund is defined as an independent fiscal and accounting entity with a self-balancing set of accounts recording cash and other financial resources, together with all related liabilities and residual equities or balances, and changes therein, which are segregated for the purpose of carrying on specific activities or attaining certain objectives in accordance with special regulations, restrictions, or limitations. Types of Funds Governmental Fund Types General Fund -to account for all unrestricted resources except those required to be accounted for in another fund. Special Revenue Funds - to account for the proceeds of specific revenue sources (other than major capital projects) that are restricted by law or administrative action to expenditures for specified purposes. Debt Service Funds -to account for the accumulation of resources for, and payment of, interest and principal on general long- term debt. Capital Projects Funds - to account for financial resources segregated for the acquisition of major capital facilities (other than those financed by Proprietary Funds). Proprietary Fund Types Enterprise Funds-to account for operations in a manner similar to private business enterprises where the intent is that the costs (expenses, including depreciation) of providing goods or services to the general public on a continuing basis is to be financed or recovered primarily through user charges. Internal Service Funds - to account for the financing of goods or services provided by one department or agency to other departments or agencies of the City or to other governmental units, on a cost-reimbursement basis. 12 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 1: Organization and Summary of Significant Accounting Policies (Continued) Eiduciary Fund Tynes Agency Funds - to account for assets held by the City as trustee or agent for individuals, private organizations, or other governmental units, and/or other funds. Account Groups Fixed Assets and Long-Term Liabilities The accounting and reporting treatment applied to the fixed assets and long-term liabilities associated with a fund are determined by its measurement focus. All governmental funds are accounted for on a spending or 'financial flow* measurement focus. This means that only current assets and current liabilities are generally included in their balance sheets. Their reported fund balance (net current assets) is considered a measure of 'available spendable resources'. Governmental fund operating statements present increases (revenues and other financing sources) and decreases (expenditures and other financing uses) in net current assets. Accordingly, they are said to present a summary of sources and uses of 'available spendable resources' during a period. Fixed assets used in governmental fund type operations (general fixed assets) are accounted for in the General Fixed Assets Account Group, rather than in governmental funds. Public domain ('infrastructure') general fixed assets consisting of roads, bridges, curbs and gutters, streets and sidewalks, drainage systems, and lighting systems, are not capitalized. No depreciation has been provided on general 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 market value on the date donated. Fixed assets acquired under lease/purchase contracts are recorded in the Internal Service Fund and the General Fixed Assets Account Group. The corresponding liabilities are recorded in the Internal Service Fund and the General Long-Term Debt Account Group. Interest accrued during construction (if any) of fixed assets is capitalized as a part of the asset cost. All proprietary funds are accounted for on a cost of services or 'capital maintenance' measurement focus. This means that all assets and all liabilities (whether current or noncurrent) associated with their activity are included on their balance sheets. Their reported fund equity (net total assets) is segregated into contributed capital and retained earnings components. Proprietary fund type operating statements present increases (revenues) and decreases (expenses) in net total assets. 13 M M M M M M M City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 1: Organization and Summary of Significant Accounting Policies (Continued) Depreciation of all exhaustible fixed assets used by Proprietary Funds is charged as an expense against their operations. Proprietary fund fixed assets are reported net of accumulated depreciation on their balance sheets. Depreciation has been provided over the estimated useful lives using the straight line method for all classes of fixed assets. The estimated useful lives are as follows: Automotive Equipment 5 years Other Equipment 5.10 years Long-term liabilities expected to be financed from governmental funds are accounted for in the General Long-Term Debt Account Group, not in the governmental funds. Noncurrent portions of long-term receivables due to governmental funds are reported on their balance sheets, in spite of their spending measurement focus. Special reporting treatments are used to indicate, however, that they should not be considered 'available spendable resources', since they do not represent net current assets. Recognition of governmental fund type revenues represented by noncurrent receivables is deferred until they become current receivables. Noncurrent portions of long-term loans receivable are offset by fund balance reserve accounts. Special reporting treatments are also applied to governmental fund inventories (I any) to indicate that they do not represent 'available spendable resources', even though they are a component of net current assets. Such amounts are generally offset by fund balance reserve accounts. Because of their spending measurement focus, expenditure recognition for governmental fund types does not include amounts represented by noncurrent liabilities. Since they do not affect net current assets, such long-term amounts are not recognized as governmental fund type expenditures or fund liabilities. They are instead reported as liabilities in the General Long-Term Debt Account Group. c. Functional Classifications Expenditures of the City are classified by function. Functional classifications are defined as follows: General Government includes legislative activity, City Clerk, City Attorney, City Manager as well as management or supportive services across more than one functional area. Public Safety includes those activities which involve the protection of people and property. Public Safety - Fire Protection includes activities of the fire protection district involved in the protection of people and property from fire. 14 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 1: Organization and Summary of Significant Accounting Policies (Continued) mineedng and Public Works includes all maintenance, engineering and capital improvements which relate to streets, sewers, parks, flood control and other public facilities. Community Development includes those activities which involve planning and redevelopment as well as building and safety. Community Services includes those activities which involve the providing of recreational, cultural and educational services. d. Basis of Accounting Basis of accounting refers to when revenues and expenditures or expenses are recognized in the accounts and reported in the financial statements. Specifically, it relates to the timing of the measurements made regardless of the nature of the measurement. All governmental funds and Agency funds are accounted for using the modified accrual basis of accounting. Their revenues are recognized when they become measurable and available as net current assets. Revenues considered susceptible to accrual in those funds wherein revenue is recognized on a modified accrual basis is as follows: property and sales taxes, revenue from the use of money and property, intertund transfers, unbilled service receivables and intergovernmental revenue are all considered measurable and are recognized as revenue on a modified accrual basis; licenses, permits, fines and forfeitures and similar items are, for the most part, not susceptible to accrual and consequently are not recorded until received. Agency funds are purely custodial (assets equal liabilities) and thus do not involve measurement of results of operations. The assets and liabilities are accounted for on a modified accrual basis with the exception of the City's Deferred Compensation Plan which is accounted for on a market value basis in accordance with Statement No. 2 of the Governmental Accounting Standards Board (GASB). Property tax revenue is recognized on the basis of NCGA Interpretation No. 3; (adopted by GASB) that is, in the fiscal year for which the taxes have been levied providing they become available. Available means then due, or past due and receivable within the current period and collected within the current period or expected to be collected soon enough thereafter (not to exceed 60 days) to be used to pay liabilities of the current period. The County of San Bernardino collects property taxes for the City. Tax liens attach annually as of 12:01 A.M. on the first day in March preceding the fiscal year for which the taxes are levied. The tax levy is made July 1 and covers the fiscal period July 1st to June 30th. All secured personal property taxes and one-half of the taxes on real property are due November 1st; the second installment is due February 1st. All taxes are delinquent, N unpaid, on December 10th and April 10th respectively. Unsecured personal property taxes become due on the first of March each year and are delinquent, if unpaid, on August 31st. Grants, entitlements, or shared revenues recorded in governmental funds are recognized as revenue in the accounting period when they become susceptible to accrual, i.e., both measurable and available (modified accrual basis). Grants received before the revenue recognition criteria has been met are reported as deferred revenue, a liability account. Such resources not received are reported as a receivable if the revenue recognition criteria has been met. 15 M M M Mill City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 1: Organization and Summary of Significant Accounting Policies (Continued) Expenditures are generally recognized under the modified accrual basis of accounting when the related fund liability is incurred; principal and interest on general long-term debt is recognized when due. All proprietary funds are accounted for using the accrual basis of accounting. Their revenues are recognized when they are earned and become measurable, expenses are recognized when they are incurred I measurable. All proprietary funds appy all authoritative body pronouncements issued prior to November 30, 1989 and thereafter all FASB pronouncements except those which conflict with or contradict GASB pronouncements. e. Budgetary Data General Budget Policies The City Council approves each year's budget submitted by the City Manager prior to the beginning of the new fiscal year. Public hearings are conducted prior to its adoption by the Council. Supplemental appropriations, where required during the period, are also approved by the Council. There were several supplemental appropriations required during the year. A detailed mid-year review was conducted at which time a revised budget was adopted. There were no significant non-budgeted financial activities during the year. The City Council may transfer funds between funds or activities set forth in the budget. The City Manager may transfer funds between appropriations within an appropriation as set forth in the budget and may transfer appropriations between activities within any fund. Budget data presented in the financial statements are the final adjusted amount. At fiscal year-end all operating budget appropriations lapse. Encumbrances Encumbrances are estimations of costs related to unperformed contracts for goods and services. These commitments are recorded for budgetary control purposes in the General, Special Revenue, and similar governmental funds. Encumbrances outstanding at year- end are reported as a reservation of fund balance. They represent the estimated amount of the expenditure ultimately to result if unperformed contracts in-process at year-end are completed. They do not constitute expenditures or estimated liabilities. Budget Basis of Accounting Budgets for governmental funds are adopted on a basis consistent with generally accepted accounting principles (GAAP) except that for budgeting purposes only encumbrances are treated as expenditures. The Combined Statement of Revenues, Expenditures and Changes in Fund Balances - Budget and Actual - All Governmental Funds presents comparisons of the legally adopted budget with actual data on the budgetary basis. The difference between the budgetary basis and GAAP are also presented and reconciled on this statement. This reconciliation included the following unbudgeted funds: 16 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 1: Organization and Summary of Significant Accounting Policies (Continued) Excess of Revenues and Other Sources over (under) al2endltures and Other Uses Special Revenue Fund Type: San Sevaine/Etiwanda Drainage $ 28,803 Debt Service Fund Type: Public Improvement Corporation 6,958 Total $ a§ 61 f. Other Accounting Policies Total Columns on Combined Statements 'Memorandum Only' captions on combined statements - total columns mean that totals are presented for overview informational purposes only and that they do not fairly present financial position or results of operations for the governmental unit as a whole in conformity with generally accepted accounting principles. Interfund eliminations have not been made in the aggregation of these totals. Investments Investments are stated at cost. At June 30, 1997, the City's investment in land held for resale is stated at cost as the Agency expects to sell this land with no decline in value. Claims and Judgments and Compensated Absences Claims and Judgments Only the short-term liability is reflected as a current liability in all applicable governmental fund types, the remainder of the liability is repni!:,cl in the General Long-Term Debt Account Group. The short-term liability which will be liquidated with expendable available financial resources is the amount of settlement reached, but unpaid, related to claims and judgments entered. At June 30, 1997, there are no material long-term judgments and claims against the City and no liability is reported in the General Long- Term Debt Account Group. In addition, the City has determined that at June 30, 1997, there are no material incurred but unreported claims against the City. 17 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 1: Organization and Summary of Significant Accounting Policies (Continued) Compensated Absences The City utilizes the General Fund and Special Revenue - Fire District Fund to account for its compensated absences. The short- term portion is determined to be the amount due to employees for future absences which is attributable to services already rendered and which is expected to be paid during the next fiscal year. The total amount of liability for compensated absences is segregated between short-term and long-term as indicated above and are accordingly reflected in the General Fund, Fire District Special Revenue Fund and General Long-Term Debt Account Group. Vacation pay is payable to employees at the time a vacation is taken or upon termination of employment. Normally, an employee can not accrue more than one and one-half times his regular annual entitlement. Sick leave is payable when an employee is unable to work because of illness. For City employees, those who terminate their employment after five years of continuous service and have at least 50% of five years sick leave accrued on the books upon termination may be paid for 120 hours of the accrued leave. For Fire District employees, sick leave may be accumulated indefinitely or an employee with ten or more years of service shall be eligible to convert unused sick leave to vacation in accordance with the following with any remainder of hours to still remain used sick time. Employee Accumulated Balance Vacation Type Prior Calendar Year Conversion Rate Shift 108 hr -144 hr one - half Shift 72 hr -108 hr one - fourth. 40 hour 72 hr - 96 hr one - half 40 hour 48 hr - 72 hr one - fourth Upon service retirement of a public safety employee the option exists to sell back up to one-half of total accumulated sick time or have the time credited toward service in accordance with the Public Retirement Law. All unused sick leave is forfeited upon termination, other than for normal retirement. Post-Employment Benefits The City and Redevelopment Agency do not provide post-employment benefits; however, medical coverage is provided to Fire District personnel and their dependents upon retirement. The District recognizes the cost of providing these benefits by recording the insurance premiums as expenditures. The cost for thirteen retirees was $55,099 for fiscal year 1996-97. 18 City of Rancho Cucamonga Notes to Financial Statements (Continued) It. STEWARDSHIP Note 2: Stew: '-hip, Compliance and Accountability a. The following fund contained a deficit fund balance as of June 30, 1997: Special Revenue Fund: Measure 1 $ 628,797 b. Excess of expenditures over appropriations in individual funds at the departmental level are as follows: Expenditures Appropriations Excess General Fund: General government: Engineering and Public Works Purchasing $ 158,514 $ 158,155 $ 359 Debt Service Principal 102,502 102,502 Interest and fiscal charges 17,715 17,715 Special Revenue Funds: Gas Tax Principal 68,612 68,612 Interest and fiscal charges 7,637 - 7,637 Beautification Engineering and public works 146,547 146,390 157 Air Quality Improvement Capital outlay 57,774 55,774 2,000 Library Services Principal 100,000 100,000 Capital Projects Funds: Redevelopment Agency General government 3,923,188 1,518,950 2,404,238 Public safety 5,161,220 2,307,577 2,853,643 Capital outlay 13,983,253 13,444,019 539,234 Interest and fiscal charges 3,359,229 2,715,339 643,890 19 City of Rancho Cucamonga Notes to Financial Statements (Continued) III. DETAIL NOTES ON FUNDS AND ACCOUNT GROUPS (Notes 3-14) Note 3: Cash and Investments Cash and investments at June 30 consisted of the following: Cash on hand $ 5,300 Pooled Cash and Deposits 28,477,355 Pooled Investments 115,399,351 Investment in State Treasury's Investment Pool 34,530,713 Investment with Trustee - Money Market 5,538,676 Deferred Compensation - Unclassified 1.098.789 Total Cash and Investments $ 185.050.184 The City follows the practice of pooling cash and investments of all funds except for funds required to be held by outside fiscal agents under the provisions of bond indentures and funds in its deferred compensation plan. All investments held are in compliance with the City's investment policy. Interest income earned on pooled cash and investments is allocated to the various funds based on the cash balances. Interest income from cash and investment with fiscal agent and in the deferred compensation plan is credited directly to the related fund. Pooled Cash and Non-Negotiable Certificates of Deposit All pooled cash and non-negotiable certificates of deposit are entirely insured or collateralized. The California Government Code requires California banks and savings and loan associations to secure a City's deposits by pledging government securities as collateral. The market value of pledged securities must equal at least 110% of a City's deposits. California law also allows financial institutions to secure City deposits by pledging first trust deed mortgage notes having a value of 150% of a City's total deposits. The City may waive collateral requirements for deposits which are fully insured up to $100,000 by the Federal Deposit Insurance Corporation (FDIC). 20 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 3: Cash P- ! Investments (Continued) Cash and Investments with Fiscal Agent The City has monies held by a trustee pledged to the payment or security of certain bonds, certificates of participation and lease obligations. The California Government Code provides that these monies, in the absence of specific statutory provisions governing the issuance of these bonds, certificates, or leases, may be invested in accordance with the ordinance, resolutions or indentures specifying the types of investments its fiscal agent may make. These ordinances, resolutions, and indentures are generally more restrictive than the City's general investment policy. In no instance have additional types of investments, not permitted by the City's general investment policy, been authorized. Cash and Investments - Deferred Compensation Plan The City offers its employees a deferred compensation plan created in accordance with Internal Revenue Code Section 457. The market value of the plan assets at June 30, 1997 is $5,422,471. The City has two plans. One plan is held in savings accounts where each participant is insured up to $100,000. The other pian is held as an unclassified investment. See Note 16 for additional information about this plan. Credit Risk, Carrying Amount, and Market Value of Deposits Cash and deposits of the City are summarized below. The deposits are classified as to credit risk by three categories as follows: Category 1 includes deposits that are insured or collateralized, with the securities held by the City or its agent in the City's name; Category 2 includes deposits which are uninsured but which are collateralized with the securities held by the pledging financial institution's trust department in the City's name; Category 3 includes deposits which are uninsured and uncollateralized, or collateralized with securities held by the pledging financial institutions, or by its trust department or agent but not in the City's name. Category Bank Carrying 1 2 3 Balance Amount Cash in Bank and Petty Cash $ 305,500 $ 11,325,270 $ - $ 11,630,770 $ 10,833,441 Deferred Compensation 4,072,779 250,903 - 4,323,682 4,323,682 Certificates of Deposit 200.000 13.125.532 - 13.325.532 13.325.532 Totals $ 4.578.279 $ 24.701.705 $ _ $ 29.279.984 $28.482.655 21 i M i i City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 3: Cash and Investments (Continued) Pooled Investments Authorized Investments Under provisions of the City's Investment Policy, and in accordance with Section 53601 of the California Government Code, the City may invest in the following types of investments: Securities of the U.S. Government, or its agencies Small Business Administration Loans Certificates of Deposit Bankers Acceptance Commercial Paper Local Agency Investment Fund (State Pool) Deposits Passbook Savings Account Demand Deposits Repurchase Agreements Reverse Purchase Agreements Credit Risk, Carrying Amount and Market Value of Investments Investments of the City are summarized below. The investments that are represented by specific identifiable investment securities are classified as to credit risk by three categories as follows: Category 1 includes investments that are insured or registered for which securities are held by the City or its agent in the City's name; Category 2 includes uninsured and unregistered investments for which the securities are held by the brokers or dealer's agent in the City's name; Category 3 includes uninsured and unregistered investments for which the securities are held by the broker or dealer, or by its agent, but not in the City's name. Cateaory Carrying Market 1 2 3 Amount Value City Investments: U.S. Government Securities $115.399.351 $ _ $ _ $ 115.399.351 $114.852.392 Total City Investments $115.399.351 $ - $ - $ 115.399.351 $114.852.392 Investment in State Treasury's Investment Pool Investment in State Treasury's cannot be assigned a credit risk category because the City does not own specific securities. However, the fund's investment policies and practices with regard to the credit and market risks have been determined acceptable to the City's investment policies. 22 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 3: Cash and Investments (Continued) Carrying Market Amount Value Investment in State Treasury's Investment Pool $ 34.530.713 $ 34.679.195 Investment with Trustee Amounts invested with Trustee in money market cannot be assigned a credit risk category because the City does not own specific securities. However, the fund's investment policies and practices with regard to the credit and market risks have been determined acceptable to the City's investment policies. Carrying Market Amount Value Investments with Trustee - Money Market $ 5.538.676 $ 5.538.676 Deferred Compensation Plan A portion of the City's deferred compensation plan is held in unclassified investments and therefore cannot be assigned a credit risk cat-jory. The remainder is held in deposits and is classified above. In accordance with GASB pronouncements these have been recorded at market value. Deferred Compensation $ 098 89 Note 4: Prepaid PERS costs The City has prepaid contributions with PERS in the amount of $1,412,421. This amount can be utilized to offset employer contributions in fiscal year 1997-98. 23 Ir l� M M 1=11 IIIIIIIIIN w w w w w w �w w r w w w �w w w ■w ■� w w City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 5: Unearned Grants Because various federal and state subventions and grants have not been received nor the revenue recognition criteria met, the following awards are not reflected in the financial statements: Fund Amount Community Development Block Grant $ 821,331 U.S. Department of Justice 73,087 California Integrated Waste Management Board 60.679 Total $ 955.097 Note 6: Advances to Redevelopment Agency During the current and prior fiscal years, the City of Rancho Cucamonga has loaned the Rancho Cucamonga Redevelopment Agency funds for use in financing various projects. The loans which amount to $8,021,228 as of June 30, 1997 bear interest at a rate of 12% per annum and are payable as funds become available to the Agency. As of June 30, a total of $7,855,398 matured interest due on these loans has been added to principal. As this interest is not payable currently, the City has recognized deferred revenue in this amount. Note 7: Changes in General Fixed Assets A summary of changes in general fixed assets follows: Restated Balance Balance Balance June 30, 1996 Restatement June 30, 1996 Additions Deletions June 30, 1997 Purchased/Contributed Assets: Land $ 35,315,539 $ - $ 35,315,539 $ - $ $ 35,315,539 Building improvements 54,948,871 356,737 55,305,608 1,476,020 56,781,628 Improvements other than buildings 55,711 - 55,711 - 55,711 Equipment and vehicles 14,389,335 14,389,335 983,206 63,985 15,308,556 Furniture and fixtures 3,368,576 - 3,368,576 45,311 - 3,413,887 Construction-in-progress 3.544.038 (356,737 3.187.301 - 3.187 301 Total $ 111.622.070 $ $ 111.622.070 $2.504.537 $ 63.985 $ 114.062.622 24 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 8: Proprietary Fund Fixed Assets A summary of proprietary fund type property, plant and equipment is presented below: Allowance Estimated Fixed for Net Useful Life Assets Depreciation Book Value Enterprise - Sports Complex Purchased/Contributed assets: Land $ 4,351,015 $ $ 4,351,015 Building improvements 30 years 17,216,152 1,479,113 15,737,039 Automotive equipment 5 years 35,429 12,219 23,210 Other equipment 5-10 years 31.650 11.142 20.508 Total $ 21.634.246 $ 1.502.474 $ 20.131.772 Internal Service: Purchased assets: Automotive equipment 5 years $ 1,876,255 $ 849,806 $ 1,026,449 Other equipment 5-10 years 279,735 118,733 161,002 Assets acquired through capital leases - equipment 5-10 years 294.745 266.028 28.717 Total $ 2.450.735 $ 1.234.567 $ 1.216.168 Note 9: Pension Plan Obligations a. Plan Description The City and Fire District contributes to the California Public Employees Retirement System (PERS), an agent multiple-employer public employee retirement system that ads as a common investment and administrative agent for participating public entities within the State of California. Separate plans are maintained for each of these entities. Total payroll and the payroll for employees covered by the system for the year ended June 30, 1997 were as follows: City Fire District Total !31 Payroll $ 12,600,225 $ 5,878,086 $ 18,478,311 Covered Payroll 11,103,182 4,621,712 15,724,894 25 1=1 Mi� City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 9: Pension Plan Obligations (Continued) City Plan All full-time and part-time City employees who are eligible may participate in the system. To be eligible for service retirement an employee must be at least age 50 and have 5 years of PERS-credited service. For non-safety employees the benefits are payable monthly for fife, in an amount that varies from 1.426 percent at age 50 to 2.418 percent at age 63 (for each year of credited service) of their final compensation. PERS also provides death and survivor's benefits; all benefit provisions and all other requirements are established by State statute and City ordinance. Fire District Plan All full-time employees who are eligible may participate in the system. To be eligible for service retirement an employee must be at least age 50 for safety and at least 60 for non-safety employees and have 5 years of PERS-credited service. For public safety employees, the benefits are payable monthly for life, in an amount that varies from 2 percent at age 50 to 2.7 percent at age 60 (for each year of credited service) of their final compensation. For non-safety employees the benefits are payable monthly for life, in an amount that varies from 1.092 percent at age 50 to 2.418 percent at age 63 (for each year of credited service) of their final compensation. PERS also provides death and survivor's benefits; all benefit provisions and all other requirements are established by State statute. 'Final Compensation' under both plans is the average monthly pay rate for the last consecutive 36 months (or any other 36 month period if higher); however, with respect to public safety employees only the average monthly pay rate for the last consecutive 12 months (or another 12 consecutive months if higher) may be used if the entity's contract with PERS provides for one year final compensation. b. Employee and Employer Contribution Obligations The City and District makes the contributions required of its employees on their behalf and for their account. The rates are set by statute and therefore remain unchanged from year to year. The present rates are: Member Rates as a Catecory Percentage of Wages Local miscellaneous members 7 % Local safety members with benefits under Article 21252.01 9 % Local safety members with benefits under Article 21252.6 7 % 26 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 9: Pension Plan Obligations (Continued) The City and District are required to contribute the remaining amounts necessary to fund the benefits for its members, using the actuarial basis recommended by the PERS actuaries and actuarial consultants and adopted by the board of administration. c. Funding Status and Progress The amount shown below as the 'pension benefit obligation' is a standardized disclosure measure of the present value of pension benefits, adjusted for the effects of projected salary increases and step-rate benefits, estimated to be payable in the future as a result of employee service to date. The measure is intended to help assess the funding status of the system on a going-concern basis, assess progress made in accumulating sufficient assets to pay benefits when due, and make comparisons among employers. The measure is the actuarial present value of credited projected benefits and is independent of the funding method used to determine contributions to the system. The pension benefit obligation was computed as part of an actuarial valuation performed as of June 30, 1995. Significant actuarial assumptions used in the valuation include (a) a rate of return on the investment of present and future assets of 8.50 percent a year compounded annually, (b) projected salary increases of 4.5 percent a year compounded annually, attributable to inflation, (c) no additional projected salary increases attributable to seniority/merit, and (d) no post retirement increases. The pension benefit obligation (latest available) was computed as part of an actuarial valuation performed as of June 30, 1995, but reflects all plan amendments adopted through June 30, 1996. For the amounts which follow, prior to 1994, assets were shown at book value. The 1994 and subsequent years assets are shown at actuarial value (smooth market value) which may make them not comparable for trend purposes. The total assets in excess of pension benefit obligation applicable to the employees at June 30, 1996 (latest information available) were as follows: City Fire District Total Pension Benefit Obligation: Retirees and beneficiaries currently receiving benefits and terminated employees not yet receiving benefits $ 2,035,032 $ 3,594,657 $ 5,629,689 Current employees: Accumulated employee ontributions including allocated investment earnings 7,521,870 4,692,342 12,214,212 27 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 9: Pension Plan Obligations (Continued) City Fire District Total Employer-financed vested $ 4,499,905 $ 5,608,154 $ 10,108,059 Employer-financed nonvested91 0.062 138.334 328.396 Total Pension Benefit Obligation $ 14,246,869 $ 14,033,487 $ 28,280,356 Net assets available for benefits at cost Market Value Market Value Market Value $ 21.665.797 20.381.747 $ 18.604.658 17.502.030 $ 40,270,455 37.883.777 Assets in Excess of Pension Benefit Obligation $ 6.134.878 $ 3.468.543 $ 9.603.421 d. Contributions Required and Contributions Made PERS uses the Entry Age Normal Actuarial Cost Method which is a projected benefit cost method. That is, it takes into account those benefits that are expected to be earned in the future as well as those already accrued. According to this cost method, the normal cost for an employee is the level amount which would fund the projected benefit if it were paid annually from date of employment until retirement. PERS uses a modification of the Entry Age Cost Method in which the employer's total normal cost is expressed as a level percentage of payroll. PERS also uses the level percentage of payroll method to amortize any unfunded actuarial liabilities. The amortization period of the unfunded actuarial liability ends in the year 2000. The significant actuarial assumptions used to compute the actuarially determined contribution requirement are the same as those used to compute the pension benefit obligation, as previously described. The contributions to the system for the year ended June 30, 1997 were made in accordance with actuarially determined requirements computed through an actuarial valuation performed as of June 30, 1996. The contribution consisted of the following: 28 City of Rancho Cucamonga Notes to Financial State- Js (Continued) Note 9: Pension Plan Obligations (Continued) Fire District City Safety Employees _Non-Safety Employees Total Percent of Percent of Percent of Percent of Current Current Current Current Covered Covered Covered Covered Contribution Pgyroll Contribution Payroll Contribution Payroll Contribution Payroll Normal Cost $1,547,652 14.27 % $ 853,950 21.99 % $ 45,196 12.77 % $ 2,446,798 14.82 % Amortization of the unfunded actuarial accrued liabilities (62.2 MM L47,13 (1,961 MM (111,351 JQ.6 Total $1.485.398 13.69 % $ 806.814 20.78 % $ 43.235 12.22 % $ 335 44 14.15 % The City and Fire District contributed $1,247,525 (7.56 percent of current total covered payroll); both entities also contributed on behalf of the employees required contribution $1,087,921 (6.59 percent of current total covered payroll). e. Trend Information Trend information gives an indication of the progress made in accumulating sufficient assets to pay benefits when due. See comments above relating to change in valuation of assets. Nine-year trend information for the City and the Fire District were as follows: 29 M M M City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 9: Pension Plan Obligation (Continued) (Amounts In thousands) 1986-87 1987-88 1988-89 1989-90 1990-91 1991-92 1992-93 1993-94 1994-95 Net assets available for benefits City $ 3,629.3 $ 4,289.8 $ 5,2132 $ 7,056.2 $ 8,838.4 $ 11,102.9 $ 13,371.7 $ 17,748.1 $ 20,381.7 Fire District 4,465.2 5,115.9 6,230.4 7,548.1 8,832.0 10,407.8 11,983.7 15,519.3 17,502.0 Total $ 8,094.5 $ 9,405.7 $ 11,443.6 $ 14,604.3 $ 17,670.4 $ 21,510.7 $ 25,355.4 $ 33,267.4 $ 37,883.7 Pension benefit obligation City $ 2,636.0 $ 3,454.9 $ 4,609.8 $ 6,387.8 $ 8,160.2 $ 9,844.2 $ 11,246.5 $ 11,730.1 $ 14,246.9 Fire District 4,182.9 4,936.7 6,099.5 7,510.9 9,386.0 10,366.3 10,936.3 11,297.3 14,033.5 Total $ 6,818.9 $ 8,391.6 $ 10,709.3 $ 13,898.7 $ 17,546.2 S 20,210.5 $ 22,182.8 $ 23,027.4 $ 28,280.4 Net assets available for benefits expressed as a percentage of the pension benefit obligation City 137.7% 124.2% 113.1 % 110.5% 108.3% 112.8% 118.9% 151.3% 143.1 % Fire District 106.7% 103.6% 102.1 % 100.5% 94.1 % 100.4% 109.6% 137.4% 124.7% Combined 118.7% 112.1 % 106.9% 105.1 % 100.7% 106.4% 114.3% 144.5% 134.0% Assets In excess of(unfunded)pension benefit obligation City $ 993.3 $ 834.9 $ 603.4 $ 668.4 $ 898.0 $ 1,258.7 $ 2,125.2 $ 6,018.1 $ 6,134.9 Fire District 282.3 179.2 130.9 37.2 (554.0) 46.7 1,047.4 4,221.9 3,468.5 Total $ 1,275.6 $ 1,014.1 $ 734.3 $ 705.6 $ 344.0 $ 1,305.4 $ 3,172.6 $ 10,240.0 $ 9,603.4 Annual covered payroll City $ 3,892.1 $ 5,318.0 $ 7,037.8 $ 8,515.4 $ 10,546.3 $ 10,507.8 $ 9,935.4 $ 10,415.5 $ 10,845.6 Fire District 1,841.9 2,119.8 2,499.5 2,953.3 3,681.5 4,065.4 4,062.7 4,413.7 4,236.7 Total $ 5,734.0 $ 7,437.8 $ 9,537.3 $ 11,468.7 $ 14,227.8 $ 14,573.2 $ 13,998.1 $ 14,829.2 $ 15,082.3 Assets In excess of pension benefit expressed as a percentage of annual covered payroll City 25.5% 15.7% 8.6% 7.8% 8.5% 12.0% 21.4% 57.8% 56.6% Fire District 15.3% 8.5% 5.2% 1.3% (15.0)% 1.1 % 25.8% 95.7% 81.9% Combined 22.2% 13.6% 7.7% 6.2% 2.4% 9.0% 22.7% 69.1 % 63.7% Employer contributions. These contributions were made In accordance with actuarially determined requirements City $ 308.9 $ 349.4 $ 476.9 $ 596.1 $ 728.5 $ 811.8 $ 673.7 $ 683.5 $ 773.6 Fire District Not Available Not Available Not Available Not Available Not Available Not Available Not Available 492.4 473.9 Total Not Available Not Available Not Available Not Available Not Available Not Available Not Available $ 1,175.9 $ 1,247.5 Employer contributions expressed as a percentage as a percentage of annual covered payroll City 7.9% 6.6% 6.8% 7.0% 6.9% 7.7% 6.8% 6.6% 7.1 % Fire District Not Available Not Available Not Available Not Available Not Available Not Available Not Available 11.2% 11.2% Combined Not Available Not Available Not Available Not Available Not Available Not Available Not Available 7.9% 8.3% 30 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 9: Pension Plan Obligations (Continued) For the fiscal year 1994-95, the net assets available for benefits expressed as a percentage of the pension benefit obligation and the unfunded (assets in excess of) pension benefit obligation, expressed as a percentage of annual covered payroll are not presented as the pension benefit obligation for the current year has not yet been computed. Note 10: Deferred Revenue Deferred revenue as of June 30, 1997 consists of the following: General Fund - interest accrued on advances to Rancho Cucamonga Redevelopment Agency which is measurable but not available (See Note 6) plus other revenues received of $5,363 which have not yet been earned $ 7,860,760 Special Revenue Funds - revenue collected in advance for Fuel Efficient Traffic Management 154 Special Revenue Funds - private contributions to the Library to be spent as requested by the Friends of the Library 10,000 Special Revenue Funds - grant revenue received in excess of grant expenditures for California Literacy Campaign 2,557 Special Revenue Funds - grant revenue in excess of grant expenditure for Major Urban Resource Library Grant 2,103 Special Revenue Funds - grant revenue in excess of grant expenditure for Local Law Enforcement Block Grant 73,087 Special Revenue Finds - grant revenue in excess of grant expenditure for Grandparents and Books Grant 2,538 Special Revenue Funds - grant revenue in excess of grant expenditure for California State Literacy Foundation Grant 8,640 Special Revenue Funds - development fees collected in advance from various developers for future improvement projects. They are reported as follows: Beautification $ 69,528 Drainage Facilities 3.793 73.321 Total $ 8.033.160 31 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 11: Long-Term Debt a. A description of individual components of long-term debt outstanding as of June 30, 1997 follows: Certificates of Participation: $2,875,000 Certificates of Participation, Rancho Cucamonga Public Improvement Corporation - On December 29, 1988, the Rancho Cucamonga Public Improvement Corporation issued$2,875,000 in Certificates of Participation with an average interest rate of 7.03%, to render financial assistance to the City by financing, acquiring, constructing, improving and leasing public improvements for its Northeast Community Park Project. With the proceeds of the Certificates, the City will acquire approximately 38 acres of land which the City intends to develop as the Community Park. The City has covenanted in its lease agreement with the Corporation to budget for, appropriate and make the lease payments to the Corporation each year during which it has use and possession of the Park. The Corporation has assigned lease payments to the Trustee. The Trustee may hold the City liable for all lease payments on an annual basis should the City default on its obligation to make lease payments. Debt service payments began June 1, 1989 and continue through December 1, 1998. The Corporation is treated as a component unit of the reporting entity and is reported as a debt service fund. Tax Allocation Bonds: 1. Rancho Cucamonga Redevelopment Agency, Rancho Redevelopment Project, 1990 Tax Allocation Bonds, $107,780,000 - These bonds are dated March 1, 1990 and were issued to provide for the advance refunding of $31,215,000 Rancho Cucamonga Redevelopment Agency, Rancho Redevelopment Project Tax Allocation Bonds, 1986 Series A, advance refunding of $9,300,000 Rancho Cucamonga Redevelopment Agency, Rancho Redevelopment Project Refunding Tax Allocation Bonds, 1987 Series A, and the advance refunding of $9,500,000 City of Rancho Cucamonga Certificates of Participation (Fire Facilities Project). Interest is payable semi-annually on March 1 and September 1 of each year commencing September 1, 1990. The bonds mature on the dates in amounts and bear interest as follows: Maturity Date Principal Interest Maturity Date Principal Interest September 1 Amount Rate Member 1 Amount Rate 1994 $ 1,855,000 6.100 % 2001 $ 1,865,000 6.800 % 1995 1,965,000 6.200 2002 1,990,000 6.850 1996 2,090,000 6.300 2003 2,130,000 6.900 1997 2,220,000 6.400 2004 2,275,000 6.950 1998 2,360,000 6.550 2005 2,435,000 7.000 1999 2,520,000 6.650 2006 3,230,000 7.050 2000 2,685,000 6.750 2019 53,990,000 7.125 2020 24,170,000 6.750 32 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 11: Long-Term Debt (Continued) The Bonds maturing on or before September 1, 1999, are not subject to call and redemption prior to their stated maturities. Bonds maturing on or after September 1, 2000, are subject, at the option of the Agency, to redemption, in whole or in part, prior to their stated maturities on any date, commencing September 1, 1999. The bonds maturing September 1, 2019 and September 1, 2020 are subject to mandatory redemption in part from sinking account installments on September 1, 2007, and on each September 1 thereafter up to and including September 1, 2020. Bonds from this issue amounting to $54,905,000 were defeased during fiscal year 1993-94. See Note 11b for additional information. 2. Rancho Cucamonga Redevelopment Agency, Rancho Redevelopment Project, 1994 Tax Allocation Refunding Bonds $64,460,000. These bonds are dated February 1, 1994 and were issued in order to advance refund $54,905,000 of the 1990 Tax Allocation Bonds. Interest is payable semi-annualty on March 1 and September 1 of each year commencing September 1, 1994. The bonds mature on the dates in amounts and bearing interest as follows: Maturity Maturity Date Principal Interest Date Principal Interest September 1 Amount Rate September 1 Amount Rate 1994 $ 2,645,000 3.00 % 2002 $ 855,000 4.40 % 1995 1,070,000 3.00 2003 905,000 4.50 1996 1,100,000 3.30 2004 940,000 4.60 1997 1,140,000 3.70 2005 980,000 4.70 1998 1,180,000 3.90 2006 1,350,000 4.80 1999 1,230,000 4.00 2007 1,410,000 5.00 2000 1,285,000 4.20 2008 1,475,000 5.00 2001 825,000 4.30 2015 12,670,000 5.00 2023 33,400,000 5.00 1994 Bonds maturing before September 1, 2004, are not subject to call and redemption prior to their stated maturities. 1994 Bonds maturing on or after September 1, 2004 are subject at the option of the Agency to redemption. 3. Rancho Cucamonga Redevelopment Agency, Rancho Redevelopment Project, 1996 Housing Set-Aside Tax Allocation Bonds, $37,665,000. These bonds are dated September 1, 1996 and were issued in order (i) to repay the note issued by the Agency to Sanwa Bank in the remaining principal amount of$20,783,487; (ii) to pay off the non-taxable term loan to Sanwa Bank in the principal amount of $5,841,301 plus prepayment penalties; (iii) to complete the projects for which the loans were originated, namely Mountainsides Monterey Village and Sycamore Springs; and (iv) to make grants to the Southern California Housing Development Corporation and to the Northtown Housing Development Corporation. The issue consists of $8,970,000 Serial Bonds with maturities beginning September 1, 1997 through September 1, 2008 and $28,695,000 term bonds maturing thereafter. Interest is payable semi- 33 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 11: Long-Term Debt (Continued) annually on march 1, and September 1 of each year commencing March 1, 1997. The bonds mature on the dates, in amounts and bearing interest as follows: Maturity Date Principal Interest Maturity Date Principal Interest September 1 Amount Rate September 1 Amount Rate 1997 $ 585,000 4.50 % 2012 $ 1,160,000 5.00 % 1998 610,000 3.90 2013 1,220,000 5.00 1999 635,000 4.12 2014 1,285,000 5.00 2000 660,000 4.25 2015 1,355,000 5.00 2001 685,000 4.40 2016 1,425,000 5.25 2002 715,000 4.60 2017 1,500,000 5.25 2003 750,000 4.70 2018 1,580,000 5.25 2004 785,000 4.75 2019 1,660,000 5.25 2005 825,000 4.90 2020 1,750,000 5.25 2006 865,000 5.00 2021 1,840,000 5.25 2007 905,000 5.10 2022 1,935,000 5.25 2008 950,000 5.25 2023 2,040,000 5.25 2009 1,050,000 5.00 2024 2,145,000 5.25 2010 1,055,000 5.00 2025 2,260,000 5.25 2011 1,105,000 5.00 2026 2,375,000 5.25 The bonds maturing on or before September 1, 2006 are not subject to call and redemption prior to their stated maturities. Bonds maturing on or after September 1, 2007, are subject, at the option of the Agency, to redemption in whole or in part, prior to their stated maturities on any date, commencing September 1, 2006. The bonds maturing September 1, 2011, September 1, 2016, September 1, 2021 and September 1, 2026 are subject to mandatory redemption in part from sinking account installments on September 1, 2009 and on each September 1 thereafter up to and including September 1, 2026. Tax Revenues, except as provided below, are pledged in their entirety to the payment of principal of, and interest on and redemption premium, if any, on the bonds listed above and are referred to in the applicable series resolutions, as 'Pledged Tax Revenues'. Pledged Tax Revenues do not include that portion of Tax Revenues derived from the Project Area which are required by Section 33334.2 of the Redevelopment Law to be set aside by the Agency in a separate low and moderate income housing fund and be used for the purpose of increasing and improving the community's supply of low and moderate income housing. Pledged Tax Revenues also do not include that portion of Tax Revenues derived from the Project Area which are required to be used by the Agency in accordance with the provisions of certain agreements entered into by the Agency. The Agency has entered into cooperative agreements with taxing agencies affected by the Redevelopment Project. Such agreements have been entered into with (i) the Chino Basin Municipal Water District, (i) the County of San Bernardino on behalf of the County Free Library and the San Bernardino County 34 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 11: Long-Term Debt (Continued) Flood Control District, (ii) the Cucamonga County Water District, Qv) the Foothill Fire Protection District and (v) various school districts located within the project area Under the terms of these agreements, the Agency has agreed that certain Tax Revenues attributable to those areas and which are allocated to the Agency pursuant to Section 33670(b), shall be pledged by the Agency to make certain cash payments or in lieu of contributions to each affected taxing agency. Such payments are to be made from Tax Revenues allocated to the Agency. Pledged Tax Revenues also do not include interest income on the various funds and accounts created by the series resolutions. Any such investment income is available to the Agency to meet debt service payments on the bonds but is not specifically pledged therefore. In addition to providing for the pass-through of Tax Revenue to the County Free Library and the San Bernardino County Flood Control District, the agreement between the Agency and the County of San Bernardino also provides that Tax Revenues which would have been allocated to the County had not the Redevelopment Plan been adopted will be fully allocated to the Agency until fiscal year 1998-99. The agreement, however, further provides that the Agency must use such Tax Revenues for the development of certain regional facilities, as agreed to between the County and the Agency. The Agency anticipates satisfying this regional facilities requirement with certain previously received bond proceeds. Developer Loans Payable 1. During fiscal year 1988-89, the Agency obtained a loan from the Federal Bureau of Reclamation in connection with the Day Creek Water Project. The original debt amounted to $13,400,000 and in accordance with the terms of the agreement, annual payments of$672,815 have been made to the County of San Bernardino (acting as lead agency for the Federal Government). Five payments have been made as of June 30,1997 and there is no interest due on this loan. 2. On November 15, 1991, the Agency executed a five year note in the amount of $1,500,000. The proceeds of the note, together with a $450,000 cash deposit, were used to acquire approximately 7.78 acres of land. The note bears interest at the rate of 9% per annum, payable in interest only installments, on the first day of each calendar month, beginning on January 1, 1992, and continuing until December 1, 2002 at which time the entire principal balance together with interest due thereon shall become due and payable. 3. In December of 1990 the Rancho Cucamonga Redevelopment Agency entered into a Disposition and Development Agreement with The Price Company (Developer). In accordance with this agreement the Agency executed a 23 year note in the amount of $3,756,615. The note was issued to provide financing of certain redevelopment activities which included the acquisition of approximately 13 acres of land. The note bears interest of 9% per annum. The Agency shall pay the Developer quarterly payments amounting to 50% of taxes derived from the imposition of the Bradley Burns Uniform Local Sales and Use Tax Law commencing with Section 7200 of the revenue and Taxation Code of the State of California, as amended, arising from all businesses and activities conducted on the Price Parcel. In the event that the debt service payments are insufficient to fully discharge the principal and interest on this note with the 23 note years, then, in such event, the unpaid balance of principal and accrued interest, if any, shall be deemed forgiven. Therefore, accrued interest is not reported on the financial statements. 35 Ml = = M City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 11: Long-Term Debt (Continued) 4. On September 14, 1994 the Agency executed two term loans with Sanwa Bank. A non-taxable portion of $6,394,000 and a taxable portion of$2,300,000. The proceeds of the loans are to be used to fund the construction of the Archibald storm drain and to make housing grants to the Southern California Housing Development Corporation. Initially, the interest rate is variable, but may be fixed, in whole or in part, at the discretion of the Agency. Principal and interest accruing on the loans shall be payable semi-annually beginning March 1, 1995 and semi-annually thereafter until paid. The final maturity date is March 1, 2005 with respect to the taxable loans and September 1, 2006 with respect to the non-taxable loan. S. On August 17, 1995, the Agency executed a three year term loan with Sanwa Bank in the amount of $21,000,000. The proceeds of the loan are to fund the Mountainside, Monterey village and Sycamore Springs Projects in conjunction with the Southern California Housing Corporation. Interest is tied to the Libor rate plus 2.25 basis points. Principal and accrued interest are payable semi- annually commencing on March 1, 1996 and thereafter until paid. The loan was repaid with bond proceeds which were issued September 1, 1996. Advances from Redevelopment Agency On September 16, 1987, the Rancho Cucamonga Redevelopment Agency loaned the City $4,290,000 for use in financing various public safety and parking structures and offsite improvements. This loan was made to the General Fund and it is interest free. This loan is payable in 20 equal annual installment payments due on the last day of each fiscal year commencing with the first fiscal year during which the facility is fully occupied. As this loan was made to a City Capital Project Fund while the loans from the City to the Agency are carried by the General Fund, the accounting for these transactions are recorded each individually rather than offsetting this loan against amounts advanced from the City. The facility was fully occupied in fiscal year 1990-91. The City has not repaid any part of this loan. Capital Lease Obligatlon 1. The City entered into equipment lease purchase agreements with various vendors. The following is a schedule by years of future minimum lease payments as of June 30, 1997. Long-Term Debt Fiscal Year Account Group 1997-98 $ 150,650 1998-99 79,143 1999-2000 45,382 2000-01 34.558 Total Minimum Lease Payments $ 309,733 Less: Amount Representing Interest 22.585 Present Value of Net Minimum Lease Payments $ 287.148 36 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 11: Long-Term Debt (Continued) 2. The City and the District entered into a lease agreement with West End Communications Financing Authority for the lease purchase of 800 MHZ communications equipment. The following is a schedule by years of future minimum lease payments as of June 30, 1997: Fiscal Year Ch Fire District Total 1997-98 $ 65,715 $ 33,578 $ 99,293 1998-99 67,215 36,828 104,043 1999-2000 63,310 34,698 98,008 2000-01 64.350 37.53 101,888 Total Minimum Lease Payments $ 260,590 $ 142,642 $ 403,232 Less: Amount Representing Interest 40.590 22.642 63.232 Present Value of Net Minimum Lease Payments $ 0 000 $ 20 000 $ 340.000 Note Payable 1. The City has entered into an agreement with San Bernardino County for withdrawal from the County Library System. The City has agreed to reimburse the County for ongoing costs associated with the withdrawal in the amount of $750,000 to be paid over ten years. b. Defeasance of Bonds In prior years, the Rancho Cucamonga Redevelopment Agency defeased the following bond issues by placing the proceeds of new bonds in an irrevocable trust to provide for all future debt service payments on the old bonds. Accordingly, the trust account assets and the liability for the defeased bonds are not included in the Agency's financial statements. 1984 Tax Allocation Bonds $ 7,405,000 1986 Tax Allocation Bonds, Series A 31,215,000 1987 Tax Allocation Refunding Bonds, Series A 9,100,000 1990 Tax Allocation Bonds (portion defeased) 54,905,000 Certificates of Participation - Fire Facility 9.400.000 Total Defeased $ 112.025.000 37 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 11: Long-Term Debt (Continued) C. The following is a schedule of changes in long-term debt of the City for the fiscal year ended June 30, 1997: Outstanding Outstanding July 1. 1996 _Additions Repayments June 30. 1997 Certificates of Participation: Public Improvement Corporation $ 1.070.000 $ $ 330.000 $ 740.000 Bonds: Tax Allocation Bonds - 1990 Issue $ 50,995,000 $ $ 1,030,000 $ 49,965,000 Tax Allocation Bonds - 1994 Issue 60,745,000 - 1,100,000 59,645,000 Housing Set-Aside Tax Allocation Bonds - 1996 Issue 37.665,000 37.665.000 Total Bonds $ 111.740.000 $ 37.665.000 $ 2.130.000 $ 147.275.000 Developer Loans $ 44.464.414 $ $ 27.600.400 $ 16.864.014 Advances from Other Funds: City of Rancho Cucamonga $ 4,290,000 $ - $ - $ 4,290,000 Rancho Cucamonga Redevelopment Agency 14.472.211 6.104.416 4.700.000 15.876.627 Total Advances to Other Funds $ 18.762.211 $ 6.104.416 $ 4.700.000 $ 20.166.627 Obligation Under Capital Leases $ 726.181 $ 97.081 $ 196.114 $ 627.148 Note Payable - County Agreement $ 550.000 $ $ 100.000 $ 450.000 Accrued Employee Benefits $ 1.548.085 $ 174.592 $ $ 1.722.677 Total Long-Term Debt Account Group $ 178.860.891 $ 44.041.089 $ 35.056.514 $ 187.845.466 The adjustments above related to recording the Federal Bureau of Reclamation Loan which was previously omitted. 38 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 11: Long-Term Debt (Continued) d. The following schedule illustrates the debt service requirements to maturity for bonds, notes and advances outstanding as of June 30, 1997: Developer Loans and City Fiscal Yea Bonds Notes Loans Total 1997-98 $ 11,611,986 $ 2,905,428 $ 20,166,627 $ 34,684,041 1998-99 11,612,652 1,337,928 12,950,580 1999-2000 11,211,688 1,287,928 12,499,616 2000-01 11,202,371 1,287,928 12,490,299 2001-02 10,218,062 1,287,928 11,505,990 Later Years 291.149.340 10.165.446 301.314.786 Total Debt Service $ 347,006,099 $ 18,272,586 $ 20,166,627 $385,445,312 Total interest 198.991.099 958.572 199.949.671 Total Principal $ 148.015.000 $ 17.314.014 $ 20.166.627 $ 185,495,641 Other Debt: Accrued employee benefits 1,722,677 Obligations under capital leases 627.148 Total Long-Term Debt Principal $ 187.845.466 City Loans outstanding do not have fixed amortization as funds will be repaid when available. Amounts above for these represent the loan balance as of June 30, 1997 plus matured interest due at that date. Other developer loans do not have a fixed amortization as debt service payments are based on tax revenue collections. Foi these, debt service has been spread equally over the term of the debt. Note 12: Other Special Obligations The following issues of Residential Mortgage Revenue Bonds, Certificates of Participation and Special Assessment Bonds are not reflected in the Long-Term Debt Account Group because these are special obligations payable solely from and secured by specific revenue sources described in the resolutions and official statements of the respective issues. Neither the faith and credit nor the taxing power of the City, the Redevelopment Agency, the State of California or any political subdivision thereof, is pledged for the payment of these bonds: 39 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 12: Other Special Obligations (Continued) Original Amount Rancho Cucamonga-Palmdale-Porterville-Conon Housing Finance Agency, Single Family Mortgage Revenue Bonds, Series 1986 $ 17,505,000 City of Rancho Cucamonga: Improvement Bonds, Improvement District 85-PD 5,915,000 Improvement Bonds, Assessment District No. 82-1R 5,961,249 Community Facilities District No. 84-1, 1992 Refunding Special Tax Bonds 16,530,000 Improvement Bonds, Assessment District 84-2 1,716,794 Improvement Bonds, Assessment District 86-2 2,059,352 Improvement Bonds, Assessment District 89-1 4,780,673 Community Facilities District 93-3 4,625,000 Community Facilities District 88-2 2,920,000 Rancho Cucamonga Redevelopment Agency: Multi-Family Housing Revenue Bond Series 1997A 5,912,500 Series 19978 841.500 Total $68.967.068 Note 13: Interfund Receivables and Payables The individual fund interfund receivable and payable balances at June 30, 1997 are as follows: Interfund Interfund Due from/to other funds: Receivables Payables General Fund $ 2,321,381 $ 363,209 Special Revenue Funds: Park Bond Act - 556,720 Community Development Block Grant - 233,431 SB 140 - 471,034 Measure I - 727,682 Used Oil Recycling Grant - 12,245 Adult Education Act Grant - 3,682 Fire District 18,094 237,347 40 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 13: Interfund Receivables and Payables (Continued) Interfund Interfund Due from/to other funds: (Continued) Receivables Payables Debt Service Funds: Redevelopment Agency $ 397,859 $ 15,150 Capital Projects Funds: Redevelopment Agency 3,152,119 3,267,099 Agency Funds: Special Deposits 1.8 Total $ 5.889.453 $ 5,889.453 Advances from/to other funds: General Fund $ 16,176,627 $ - Special Revenue Fund: Park Development 300,000 Capital Projects Fund: Rancho Cucamonga Redevelopment Agency 4,290,000 Long-Term Debt Account Group: Rancho Cucamonga Redevelopment Agency 20.166.627 Total $ 20.466.627 $ 20.466.627 41 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 14: Fund Equity a. Reservation of Fund Balance/Retained Earnings The City has established certain fund balance/retained earnings reserve accounts to report the amounts in the following funds which represent amounts restricted for a specified purpose or fund balances which are not available for appropriation in future periods. 1. Reserved for Advances to Other Funds: General Fund $ 8,321,226 Capital Projects Funds: Redevelopment Agency 4.290.000 Total Reserve for Advances to Other Funds $ 12.611.226 2. Reserved for Encumbrances: General Fund $ 656.331 Special Revenue Funds: Gas Tax $ 15,247 SB 325 83,217 Recreation 59,176 Park Development 40,733 Beautification 84,580 Lighting District 75 Landscape Maintenance District 162,567 System Development 135,225 Community Development Block Grant 35,615 Assessment Administration 10,944 SB 140 15,684 Air Quality Improvement 2,400 Measure 1 194,826 Library Services 1,289 California Literacy Campaign 828 Major Urban Resource Library Grant 2,374 Local Law Enforcement Block Grant 28,897 Grandparents and Books Grant 2.350 Total Special Revenue Funds $ 876.027 42 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 14: Fund Equity (Continued) Debt Service Funds: Redevelopment Agency $ 20.886 Capital Projects Funds: Redevelopment Agency $ 4.571.025 Total Reserve for Encumbrances $ 6.124.269 3. Reserve for Land Held for Resale: Capital Projects Funds: Redevelopment Agency $ 8.501.294 4. Reserved for Future Fire Station: Special Revenue Funds: Fire District $ 1.988.944 5. Reserved for Capital Projects: Special Revenue Funds: Landscape Maintenance District $ 3,795,515 Lighting Maintenance District 611.877 Total Reserve for Capital Projects $ 4.407.392 6. Reserved for Long-Term Loans Receivable Capital Projects Funds: Redevelopment Agency $ 11.485.051 7. Reserved for Vehicle and Equipment Replacement: Special Revenue Funds: Gas Tax $ 257,980 Fire District 1,733.536 $ 1,991,516 Internal Service Funds Vehicle Replacement 10.703.370 Total Reserved for Vehicle and Equipment Replacement $ 12.694.886 43 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 14: Fund Equity (Continued) 8. Prepaid PERS Costs: General Fund $ 1.412.421 9. Prepaid PERS Rate Adjustment $ 525.000 Total Reserved $ 59.750.483 Description of Reserves: 1. Reserve for Advances to Other Funds This reserve is used to indicate that the long-term portion of Advances to other funds do not represent available, spendable resources even though they are a component of total assets. 2. Reserve for Encumbrances Amounts reserved for encumbrances are commitments for materials and services or purchase orders and contracts which are unperformed. 3. Reserve for Land Held for Resale This reserve is used to indicate that land held for resale does not represent available spendable resources even though they are a component of total assets. 4. Reserve for Future Fire Station This reserve represents amounts segregated by the Fire District for use in constructing a fire station. 5. Reserve for Capital Projects This reserve represents projects legally approved by governing boards which have not been started as of the date of this report. 6. Reserve for Long-Term Loans Receivable This reserve represents deferred rehabilitation loans made by the Redevelopment Agency which do not represent available spendable resources even though they are a component of total assets. 44 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 14: Fund Equity (Continued) 7. Reserve for Vehicle and Equipment Replacement This reserve represents amounts segregated by the Fire District for use in future vehicle and equipment replacement. 8. Reserve for Prepaid PERS Costs This reserve is used to indicate that prepaid costs do not represent available spendable resources even though they are a component of total assets 9. Reserve for PERS Rate Adjustment This reserve represents amounts legally segregated for use in future PERS rate adjustments. b. Unreserved - Designations The City has established certain designations to indicate tentative managerial plans or intent. Designated for Self-Insurance General Fund $ 5,714,630 Designated for Changes in Economic Circumstances General Fund 11,901,861 Designation for Working Capital General Fund $ 1,411,831 Special Revenue Funds: Lighting Districts 652,849 Landscape Maintenance Districts 3,377,776 Library Services 63,375 Fire District 1.300.760 6,806,591 Designated for Continuing Projects Capital Projects Funds: Redevelopment Agency 66,701,008 45 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 14: Fund Equity (Continued) Designation for Equipment and Vehicles Capital Projects Funds: Redevelopment Agency $ 200,000 Designation for Long-Term Employee Leave Pay Outs General Fund 1,960,950 Designation for Integrated Waste Management General Fund 504,707 Designation for Booking Fees General Fund 723,000 Designation for City Facilities Capital Repairs General Fund 4,664,645 Designation for Law Enforcement General Fund 1,490,000 Designation for County Library Agreement General Fund 200,000 Designation for Lions Center Renovation General Fund 835,600 Designated for Debt Service Debt Service Funds: Public Improvement Corporation $ 295,709 Redevelopment Agency 20.165,858 Total Designated for Debt Service 20.461.567 Total $ 122.164.559 46 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 14: Fund Equity (Continued) c. Opening Fund Balance Retained Earnings Adjustments Beginning fund balances/retained earnings in the prior year column have been restated as follows: General Fund: Restate Public Improvement Corporation Fund as a result of arbitrage calculation $ 104 853 Special Revenue Funds: Gas Tax Fund: Transfer prior year expenditure for maintenance of vehicles that should have been expensed out of the Vehicle Replacement Fund where vehicles will be replaced $ 96,050 Restate lien receivable to proper amount (2,461) Systems Development: Transfer prior year expenditure for Capital Improvement Project that should have been expensed out of SB 140 Fund 56,662 Federal AID Urban: Restate prior year grant receivable (77,904) SB 140: Transfer prior year expenditure for capital improvement that should have been expensed in SB 140 Fund and restate prior year grant receivable (80,436) Measure I: Transfer prior year expenditure for capital improvement that should have been expensed out of SB 140 Fund 91,728 Total Special Revenue Fund $ 83,639 47 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 14: Fund Equity (Continued) Capital Project Funds: Redevelopment Agency Restate fund balance for interest income under reported in prior year $ 60.300 Enterprise Fund: Sports Complex Restate contributed capital for fixed assets contributed in in prior year $ 62.457 Internal Service Funds: Vehicle Replacement Fund: Restate prior year fixed asset balance $ 817.054 d. Residual Equity Transfers During 1996-97 the General Fund made a residual equity transfer to create the Data Processing Equipment and Replacement Fund as a new Internal Service Fund. IV. OTHER DISCLOSURES Note 15: Summary Disclosure of Self-Insurance Contingencies The City is self-insured for the first $100,000 on each general liability claim. The insurance coverage in excess of the self-insured amount is provided by the Public Agency Risk Sharing Authority of California (PARSAC) UP TO A LIMIT OF $10,000,000. Also, the City is self-insured through PARSAC for workers' compensation. The coverage is for $10,000,000 with no retention amount. Claims expenditures and liabilities are reported when it is probable that a loss has occurred and the amount of that toss can be reasonably estimated. These losses include an estimate of claims that have been incurred but not reported. The City funds all claims payable, including those incurred but not reported, in the yearly deposit it pays to PARSAC. Therefore, no liability is shown on the City's financial statements. Effective June 1, 1986 the City became a member of the PARSAC, a public entity risk pool currently operating as a common risk management and insurance program for 32 California cities. The City pays an annual premium to the pool for its excess general liability insurance coverage. The agreement for information of the PARSAC provides that the pool will be self-sustaining through member premiums. The City 48 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 15: Summary of Self-Insurance Contingencies (Continued) continues to carry commercial companies for all other risks of loss, including property insurance, earthquake and flood, auto physical damage insurance and tulip/special events insurance. The PARSAC will publish its own financial report for the year ended June 30, 1997, which can be obtained from Public Agency Risk Sharing Authority of California, Sacramento, California. There have been no significant changes in insurance coverage from the prior year. During the past four fiscal years, the amount of settlements has not exceeded the amount of insurance coverage. The City is involved in litigation arising in the normal course of business. Although the legal responsibility and financial impact with respect to such litigation cannot be presently ascertained, based on information from the service agent and others involved with the administration of the programs, the City believes that the self-insurance designation of $5,064,630 is adequate to cover such losses. Note 16: Deferred Compensation Plan The City maintains a deferred compensation plan under Section 457 of the Internal Revenue Code for the benefit of its employees. The plan allows the employees to defer or postpone receipt of income. Such income deferral provides tax advantages and a savings plan for the employees. At June 30, 1997, assets of the plan totaled $5,422,471. With the enactment of (H.R. 3448) on August 20, 1996, effective January 1, 1997 employers must establish a trust arrangement or similar vehicle to ensure assets for 457 deferred compensation plans are protected and used exclusively for plan participants and beneficiaries. For 457 plans in existence on the date of enactment, a trust will not need to be established until January 1, 1999. For 457 plans established after the date of enactment, the provision takes effect immediately. As of this report date, the City has established a trust arrangement for its Section 457 plan with ICMA and is in the process of doing the same with its plan with Great Western. The City has a fiduciary responsibility to safeguard the assets of the program and to ensure that the plan is properly maintained by the plan administrator. Generally, assets are available to participants only upon termination of employment with the City, retirement, death or disability. Note 17: West End Communications Financing Authority The West End Communications Financing Authority was formed by a joint exercise of powers agreement dated February 21, 1990 and amended February 7, 1991 pursuant to the Joint Exercise of Powers Law of the State of California. It was established for the purpose of financing public improvements through the acquisition, construction and improvement thereof by the Authority. Separate financial statements may be obtained from the Authority. The Authority's membership consists of the City of Chino, the City of Ontario, the City of Rancho Cucamonga, the City of Montclair, the City of Upland, the Chino Valley Fire District, the Cucamonga County Water District, Ontario International Airport and the Rancho Cucamonga 49 M M M M M M M City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 17: West End Communications Financing Authority (Continued) Fire Protection District. The City of Rancho Cucamonga's share of participation is 9.48%. The Board of Directors is comprised of the Chief Executive Officer and Finance Director of each member agency. Each Director has one vote over budgeting and financial matters, except for the Cucamonga County Water District and Ontario International Airport, who have chosen not to participate on the Board of Directors. The Authority is a public entity separate from the agencies, and is not included in the financial statements of those entities. The Authority issued two sets of 1991 Revenue Bonds on August 9, 1991 and in order to purchase 800MHZ Communications Equipment which is, in turn, to be leased to the agencies. Series A was issued for $4,050,000 and the equipment acquired will be leased to the City of Chino. Series B was issued for$5,620,000 and the equipment acquired will be leased to the Cities of Ontario and Rancho Cucamonga. Lease payments made by the member agencies are security for the debt and will be used to retire the debt. V. SEGMENT INFORMATION Note 18: Segment Information - Enterprise Fund a. The following schedule presents segment information for the Enterprise Fund maintained by the City. Sports Complex Operating revenues $ 961,225 Depreciation 441,121 Operating income (loss) (889,575) Operating transfers in 237,320 Tax revenues 143,556 Net income (loss) (504,027) Contributed capital 20,072,998 Net working capital 149,249 Total assets 20,390,725 Total equity 20,281,021 50 City of Rancho Cucamonga Notes to Financial Statements (Continued) Note 18: Segment Information -Enterprise Fund (Continued) b. Reconciliation of Contributed Capital Sports Complex Beginning balance $ 20,540,307 Adjustment for fixed assets contributed in prior year (37,319) Depreciation related to contributed capital (429.99 Ending Balance $ 20.072.998 VI. SIGNIFICANT EFFECTS OF SUBSEQUENT EVENTS Note 19: Bonds Repayment by Redevelopment Agency On August 25, 1997, the Agency made a lump sum payment of$8,750,000 to First Trust of California (the Trustee') as a prepayment of debt on its 1990 tax allocation bonds. Note 20: Recent Legislation During 1995, the California Supreme Court issued a decision which reinstated Cafrfornia's Proposition 62's voter - approval requirement for general taxes. As a result of this ruling, questions have arisen regarding the ability of general law cities to continue to assess utility user and other form of taxes which were not approved by the voters. Also, recently the voters approved proposition 218 which required that certain forms of taxes to be approved by the voters. As of the date of this report a determination of whether future collection of this tax can continue can not be determined. 51 (� WZW � Q _I L.L =) ZD 1 This page intentionally left blank. ' 1 1 CITY OF RANCHO CUCAMONGA Schedule 1 BALANCE SHEET GENERALFUND JUNE 30, 1997 TOTALS June 30, 1997 1996 A S S E T S Cash and investments $ 28,472,513 $ 26,481,796 Receivables(net of allowance for uncollectibles): Taxes 1,692,661 1,490,583 Accounts 632,536 887,709 Interest 229,312 250,142 Due from other funds 2,321,381 1,415,494 PERS surplus 1,412,421 1,096,403 Advances to other funds 16,176,627 14,772,211 Deposits 8,991 Total Assets $ 50,937,451 $ 46,403,329 LIABILITIES AND FUND BALANCES Liabilities: Accounts payable $ 792,492 $ 491,264 Accrued payroll payable 133,180 162,802 Accrued employee benefits payable-current 1,465,608 1,230,843 Due to other funds 363,209 66,160 Deterred revenue 7,860,760 6,453,936 Total Liabilities 10,615,249 8,405,005 Fund Balances: - Reserves: Reserved for encumbrances 656,331 469,002 Reserved for prepaid PERS costs 1,412,421 1,096,403 Reserved for prepaid PERS rate adjustment 525,000 - Reservedforadvancestootherfunds 8,321,226 8,321,226 Unreserved: Designated for self-insurance 5,714,630 5,064,630 Designated for long-term employee leave pay outs 1,960,950 1,824,140 Designated for future computer equipment - 3,250,000 Designated for County Library agreement 200,000 300,000 Designated for Lions Center renovation 835,600 835,600 Designated for integrated waste management 504,707 534,078 Designated for booking fees 723,000 600,000 Designated for City facilities'capital repairs 4,664,645 4,264,645 Designated for changes in economic circumstances 11,901,861 9,D86,100 Designated for law enforcement 1,490,000 1,000,000 Designated for working capital 1,411,831 1,352,500 Undesignated Total Fund Balances 40,322,202 37,998,324 Total Liabilities and Fund Balances $ 50,937,451 $ 46,403,329 52 CITY OF RANCHO CUCAMONGA Schedule 2 STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES GENERALFUND FOR THE FISCAL YEAR ENDED JUNE 30, 1997 TOTALS June 30, Revenues: 1997 1996 Taxes Licenses and permits $ 21,662,262 $ 21,104,640 Fines and forfeits 1,795,225 1,593,576 Use of money and property 206,875 207,188 Intergovernmental 2,411,805 2,294,809 Charges for services 5,439,152 5,383,283 Other 1,891,515 1,875,752 Total Revenues 3,008,235 2,602,148 Expenditures: 36,615,069 35,061,396 Current: General government Public safety 5,365,830 4,893,189 Engineering and public works 10282,929 9,417,013 Community development 6,495,631 6,306,375 Community services 2,928,892 2,964,885 Debt service: 1,124,226 1,092,758 Principal Interest and fiscal charges 102,502 254,933 Total Expenditures 17,715 38,596 26,317,725 24,967,779 Excess of Revenues over(under)Expenditures 10,297,344 10,093,617 Other Financing Sources(Uses): Operating transfers In Operating transfers out - 267,559 Debt proceeds (4,425,400) (1,644,636) Transfer from bond trustee 97,081 - 18,730 Total Other Financing Sources(Uses) (4,328,319) (1,358,347) Excess of Revenues and Other Sources over (under)Expenditures and Other Uses $ 5,969,025 $ 8,735,270 Fund Balances: Beginning of Fiscal Year -as previously reported Restatement $ 37,998,324 $ 29,263,312 Beginning of Fiscal Year-as restated 104,85338,103,177 29,263,312 Excess of Revenues and Other Sources over (under) Expenditures and Other Uses 5,969,025 8,735,270 Residual Equity Transfer (3,750,000) (258) End of Fiscal Year $ 40,322,202 $ 37,998,324 53 CITY OF RANCHO CUCAMONGA Schedule 3 Page 1 of 4 SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES-BUDGET AND ACTUAL(BUDGETARY BASIS) GENERALFUND FOR THE FISCAL YEAR ENDED JUNE 30,1997 T O T A L S.Year Ended June 30, 1997 1996 ar ance- Favorable Budget Actual (Unfavorable) Actual Revenues: Property taxes $ 1,653,000 $ 1,655,554 $ 2,554 $ 1,772,721 Other taxes: Property transfer tax 225,000 250,766 25,766 231,025 Transient occupancy tax 120,000 169,934 49,934 120,124 Sales and use taxes 9,364,000 10,025,134 661,134 9,590,636 Admission tax - - - 5,030 Franchise taxes 3,585,500 2,953,581 (631,919) 2,963,231 Utility users tax 6,000,000 6,807,293 807,293 6,421,873 Total Taxes 20,947,500 21,862,262 914,762 21,104,640 Licenses and permits: Building permits 725,000 866,596 141,596 708,078 Business licenses 840,000 920,884 80,884 877,706 Other permits 7,300 7,745 445 7,792 Total Licenses and Permits 1,572,300 1,795,225 222,925 1,593,576 Fines,forfeits and penalties: Court fines 180,400 119,329 (61,071) 128,095 Parking tickets and other 86,500 87,546 1,046 79,093 Total Fines and Forfeits 266,900 206,875 (60,025) 207,188 Use of money and property: Interest income 1,760,000 2,411,805 651,805 2,294,809 Total Use of Money and Property 1,760,000 2,411,805 651,805 2,294,809 Intergovernmental: Motor vehicle in lieu 4,600,000 4,788,074 188,074 4,532,696 Homeowners exemption and other subvention 55,000 61,229 6,229 60,596 Youth program reimbursements - - - 100,905 State grant reimbursements - - 98,434 FEMA claims - - 267 Waste management fees - 587,997 587,997 588,518 OB-highway motor vehicle 1,850 1,852 2 1,867 Total Intergovernmental 4,656,850 5,439,152 782,302 5,383,283 54 CITY OF RANCHO CUCAMONGA Schedule 3 SCHEDULE OF REVENUES, EXPENDITURES AND Page 2 of 4 CHANGES IN FUND BALANCES-BUDGET AND ACTUAL(BUDGETARY BASIS) GENERALFUND FOR THE FISCAL YEAR ENDED JUNE 30,1997 T O T A L S-Year Ended June 30, 1997 1996 arance Favorable Chargee for services: Budget Actual (Unfavorable) Actual Plan check fees Planningfees $ 400,000 $ 408,551 $ 8,551 $ 333,491 Engineering fees 444,000 339,701 (104,299) 417,135 Sale of materials 565,000 837,848 272,848 524,062 Other charges for services 71,600 75,475 3,875 75,485296,800 229,940 (66,860) 525,579 Total Charges for Services 1,777,400 1,891,515 114,115 1,875,752 Other: Cost reimbursements Sale of fixed assets 2,900,710 2,982,650 81,940 2,578,903 500 492 Miscellaneous revenue 4,250 25,093 20,843) 21,244 Total Other 2,905,460 3,008,235 102,775 2,602,148 Total Revenue 33,886,410 36,615,069 2,728,659 35,061,396 Expenditures: General government: City council City manager 87.920 64,058 3,862 62,200 440,620 434,459 6,161 421,418 City clerk 369,810 365,188 4,622 307,382 Personnel overhead 584,574 (591,890) 1,176,464 General overhead 1,613,810 946,726 667,084 (869,546) Treasurer 3,670 2,753 917 2 984 Administrative services 1,508,569 1,251,594 256,975 1,121,583 Finance 514,047 490,580 23,467 455,519 Business licenses 128,430 127,152 1,278 122,023 Personnel 199,058 191,945 7,113 192,526 Purchasing 158,155 158,514 359 ) 1 Risk management 99,740 75,606 24,13475,930 Redevelopment Agency administration 615,110 563,925 51,185 579,339 Fire District administration 97,130 90,569 6,561 88,828 City facilities 2,081,513 1,612,803 468,710 1,502,347 Total General Government 8,482,156 5,783,982 2,698,174 5,002,867 55 CITY OF RANCHO CUCAMONGA Schedule 3 SCHEDULE OF REVENUES,EXPENDITURES AND Page 3 of 4 CHANGES IN FUND BALANCES•BUDGET AND ACTUAL(BUDGETARY BASIS) GENERALFUND FOR THE FISCAL YEAR ENDED JUNE 30, 1997 T O T A L S-Year Ended June 30, 1997 1996 Variance- Favorable Budget Actual (Unfavorable) Actual Public safety: Police: Sheriff contract services $ 10,296,160 $ 9,803,541 $ 492,619 $ 9,127,503 Emergency preparedness 209,530 174,117 35,413 213,891 Animal control 359,628 311,347 48,281 76,651 Total Public Safety 10,865,318 10,289,005 576,313 9,418,045 Engineering and public works: Engineering administration 711,240 660,216 51,024 872,484 Development management 751,970 749,088 2,882 693,848 Traffic management 249,140 210,036 39,104 251,967 Project management 115,680 115,182 498 389,940 Construction management 324,300 323,996 304 393,453 Waste management 889,420 843,940 45,480 476,554 Street and park maintenance 3,343,030 3,182,949 160,081 2,945,444 Vehicle maintenance 620,604 595,300 25,304 564,672 Total Engineering and Public Works 7,005,384 6,680,707 324,677 6,588,362 Community development: Planning commission 7,050 7,003 47 42,964 Administration 190,090 187,809 2,281 139,905 Planning 1,057,150 997,672 59,478 1,057,871 Building and safety 1,832,750 1,783,371 49,379 1,799,292 Total Community Development 3,087,040 2,975,855 111,185 3,040,032 Community services: Community services 1,213,720 1,123,644 90,076 1,092,924 Park and recreation commission 1,542 646 896 1,022 Total Community Services 1,215,262 1,124,290 90,972 1,093,946 Debt service: Principal 102,502 (102,502) 254,933 Interest and fiscal charges 17,715 (17,715) 38,596 Total Debt Service 120,217 (120,217) 293,529 Total Expenditures 30,655,160 26,974,056 3,681,104 25,436,781 Excess of Revenues over(under)Expenditures 3,231,250 9,641,013 6,409,763 9,624,615 56 CITY OF RANCHO CUCAMONGA Schedule 3 SCHEDULE OF REVENUES, EXPENDITURES AND Page 4 of 4 CHANGES IN FUND BALANCES-BUDGET AND ACTUAL(BUDGETARY BASIS) GENERALFUND FOR THE FISCAL YEAR ENDED JUNE 30, 1997 T O T A L S-Year Ended June 30, 1997 1996 ar anee- Favorable Other Financing Sources(Uses): Budget Actual (Unfavorable) Actual Operating transfer in $ $ - $ $ 267,559 Operating transfer out (1,190,551) (4,425,400 Debt proceeds ) (3,234,848) (1,644,636) • 081081 97, Transfer from bond trustee 97, - 18,730 Total Other Financing Sources(Uses) (1,190,551) (4,328,319) (3,137,768) (1,358,347) Excess of Revenues and Other Sources over(under) Expenditures and Other Uses(Budgetray Basis) 2,040,699 5,312,694 3,271,995 8,266,268 Adjustments: To adjust for encumbrances 656,331 656,331 469,002 Excess of Revenues and Other Sources over(under) Expenditures and Other Uses(GAAP Basis) $ 2,040,699 $ 5,969,025 $ 3,928,326 $ 8,735,270 Fund Balances: Beginning of Fiscal Year -as previously reported $ 37,998,324 $ 37,998,324 $ - $29,263,312 Restatement 104,853 104,853 Beginning of Year•as restated 37,998,324 38,103,177 104,853 29,263,312 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) 2,040,699 5,969,025 3,928,326 8,735,270 Residual Equity Transfer (3,250,000) (3,750,000) (500,000) (258) End of Fiscal Year $ 36,789,023 $ 40,322,202 $ 3,533,179 $37,998,324 57 Lcf) oz (-- -n mczm < mx r D - C� m -vcn This page intentionally left blank. ' I 1 ' SPECIAL REVENUE FUNDS Gas Tax Fund ' Establish to account for the revenue and disbursement of funds used for road construction and maintenance of the City network system. The City's share of state gasoline taxes provided the ' financing. SB325 Fund ' Establish to account for the revenue and disbursement of funds received by extending the statewide sales tax of 1/4 of 1 cent to motor vehicle fuel under the Transportation Development Act. Recreation Fund ' Established to account for the wide variety of classes, special events, and activities sponsored by the Community Services Department. ' Park Development Fund ' Established to account for the residential park development fees charged subdividers upon issuance of a building permit for development of future park or recreational sites. ' Beautification Fund Established to account for fees collected to provide proper landscaping and irrigation systems after parkway and median improvements are made. ' SB300 Fund Established to account for the revenue and disbursement of state general funds monies for the reconstruction of existing roadways when the widening brings the road up to generally acceptable safety standards.. Lighting Districts Fund Established to account for the costs associated with providing street lights. Financing is provided ' by special assessments levied against the benefitting property owners. Landscape Maintenance Fund Established to account for the costs associated with providing landscape maintenance. Financing ' is provided by special assessments levied against the benefitting property owners. Systems Development Fund ' Established to account for fees charged a subdivider for the construction and expansion of City ' streets and highways which provide additional capacity and safety. Park Bond Act 1980 and 1984 Funds , Established to account for the revenue and disbursement of funds received from the State of , California for construction of parks and recreational facilities. Drainage Facilities Fund ' Established to account for fees charged developers for purposes of defraying the actual or estimated ' costs of constructing planned drainage or sewer facilities that are in the subdivision. Pedestrian Grants Fund ' Established to account for the revenue and disbursement of funds received for the construction of facilities provided for the exclusive use of pedestrians and bicycles. ' Federal Aid Urban Fund Established to account for the revenue and disbursement of Federal funding for the construction of the City roadway system. Community Development Block Grant Fund ' Established to account for grants received from the Department of Housing and Urban Development. ' These revenues must be expended to accomplish one of the following objectives: elimination of slum or blight, or benefit to low and moderate income persons by providing loans and grants to , owner-occupants and rental property owners to rehabilitate residential properties. Assessment Administration Fund ' Established to account for the revenue and disbursement of administration of assessment districts. San Sevaine/Etiwanda Drainage ' Established to account for Development Impact fees collected in the San Sevaine/Etiwanda Drainage , Assessment District for the construction of regional and mainline flood control projects in that district. 1 ' SB 140 Established to account for the revenue and disbursement of State matching funds for the construction of eligible street construction projects. ' Air Quality Improvement Fund ' Established to account for the revenue and disbursement of funds received as a result of Assembly Bill 2766 which imposed an additional registration fee on motor vehicles. These revenues are to be used to reduce air pollution from motor vehicles and for related planning, monitoring, enforcement, ' and technical studies (Vehicle Code Section 9250.17 and Health & Safety Code Chapter 7, Part 5 of Division 26, commencing with Section 44220). ' 800 MHZ Fund ' Established to account for the revenue and disbursement of funds received as a result of the formation of the West End Communications Financing Authority which issued bonds to provide funds for the acquisition of certain capital equipment by the cities of Chino, Ontario, and Rancho ' Cucamonga, California. Fuel Efficient Traffic Signal Management Grant Fund (FETSIM) ' Established to account for grants received from the California Department of Transportation. These revenues are to be used on the retiming of signalized intersections. SBA Tree Grant Established to account for expenses and reimbursements associated with the U.S. Small Business Administration's discretionary grant program for the planting of trees by certified small businesses. ' South Etiwanda Drainage ' Established to account for monies deposited by property owners for initial consulting costs related to a possible formation of an assessment district for master planned drainage facilities. ' Masi Commerce Center Established to account for monies deposited by developers for initial consulting and administrative ' costs and expenses related to a proposed public financing district. Measure I ' Established to account for the revenue and disbursement of county/local gasoline tax funds for the construction and maintenance of eligible street projects. Library Services Established to account for services provided by the City of Rancho Cucamonga Library. Funding for this service is made possible through a transfer of San Bernardino County library tax revenues ' to the City of Rancho Cucamonga for library purposes. Some start-up costs were incurred during 1993/94;however, full implementation of City library services did not begin until September 1994. Metrolink ' Established to account for the commuter rail project(Metrolink Station)being funded by a combined , source of State Proposition 108 (Passenger Rail& Clean Air Bond Act of 1990)and San Bernardino County Measure I revenues allotted to the City through an agreement with San Bernardino , Associated Governments (SANBAG). California Literacy Campaign Grant ' The California Literacy Campaign Grant is administered by the State Library of California for the purpose of promoting literacy. ' Weingart Foundation Grant The Weingart Grant Fund is administered by a private foundation (Weingart Foundation) which , awarded this one time grant to the City of Rancho Cucamonga's Library. These funds are to be used ' specifically for the establishment of an electronic learning library meant to provide students (kindergarten through twelfth grade) with home work assistance. MURLS Grant , Awarded each year by the California State Library this Grant program is titled Major Urban ' Resource Libraries Services Grant and is funded through the Federal Library Services and Construction Act. Awarded on application to public libraries serving a population in excess of 100,000, the funds must be used to purchase business reference resources. ' Used Oil Recycling Grant In 1991,the Legislature passed AB 2076, the California Oil Recovery Enhancement Act. The Act ' requires oil manufacturers to pay $0.04 to the California Integrated Waste Management Board for each quart of lubricating oil sold in the State of California. These grant funds are available to , governmental agencies, based on population, for the purpose of establishing and administering used oil collection programs. These funds must be used expressly for oil recycling collection and ' educational programs. Fire District ' Established to account for the revenue and disbursement of funds received by Rancho Cucamonga Fire Protection District in the course of that agency's fire protection services. ' 1 CITY OF RANCHO CUCAMONGA Schedule 4 Page 1 of 4 COMBINING BALANCE SHEET ALL SPECIAL REVENUE FUNDS JUNE 30, 1997 Landscape Park Lighting Maintenance Systems Park Bond SSGas Tex SB 325 Recreation Development Beautification Districts Districts Development Act AET S Cash and investments $ 2,613,234 $ 402,456 $ 390,332 $1,097,775 $ 511,538 $ 1,273,911 $ 7,855,573 $ 3,041,951 $ - Receivables(net of allowance for uncollectibles): Taxes - - - - 18,968 82,462 - . Accounts - - - 3,794 - - Accrued Interest - Deferred loans - - - - - - - - - Liens - - - _ - - 1,274 - Grants - - _ _ - - 556,720 Due from other funds Total Assets $ 2,613,234 $ 402,456 $ 390,332 $1,097,775 $ 511,538 $ 1,292,879 $ 7,941,829 $ 3,043,225 $ 556,720 LIABILITIES AND FUND BALANCES Liabilities: Accounts payable $ 117,444 $ 6,300 $ 25,264 $ 1,181 $ 45,648 $ 27,693 $ 585,109 $ 6,168 $ - Accrued payroll payable 19,303 247 11,553 - 2,010 385 20,862 8,844 - Employees benefits payable - - - - - - - - Due toother funds - - - - - - - 556,720 Due to other governments - - - - - - _ - Deferred revenue - - - - 69,528 - - - Advances from other funds 300,000 Total Liabilities 136,747 6,547 36,817 301,181 117,186 28,078 605,971 15,012 556,720 Fund Balances: Reserved for encumbrances 15,247 83,217 59,176 40,733 84,580 75 162,567 135,225 - Reserved for capital projects - - - - 611,877 3,795,515 - - Reserved for future fire station - - - - - - Reserved for land acquisition - - - - - - Reserved for employee leave pay outs - - - - - - - - Reserved for radio system acquisition - - - - - Reserved for vehicle and equipment replacement 257,980 - - - - - - - - Unreserved: Designated for working capital - - - 652,849 3,377,776 - Undesignated 2,203,260 312,692 294,339 755,861 309,772 2,892,988 Total Fund Balances 2,476,487 395,909 353,515 796,594 394,352 1,264,801 7,335,858 3,028,213 Total Liabilities and Fund Balances $ 2,613,234 $ 402,456 $ 390,332 $1,097,775 $ 511,538 $ 1,292,879 $ 7,941,829 $ 3,043,225 $ 556,720 58 CITY OF RANCHO CUCAMONGA Schedule 4 COMBINING BALANCE SHEET Page 2 of 4 ALL SPECIAL REVENUE FUNDS JUNE 30, 1997 Community San Sevalne/ Air South Drainage Pedestrian Federal Development Assessment Etiwanda Quality FETSIM Ettwanda ASSET S Facilities Grants Aid Urban Block Grant Administration Drainage SB 140 Improvement Grant Drainage Cash and investments $ 748,780 $ 6,694 $ 175,338 $ $ 362,935 $ 874,272 $ - $ 119,747 $ 154 $ 11,423 Receivables jnet of allowance for uncollectibles): Taxes Accounts - - Accrued Interest - _ 210 29,400 Deferred loans - _ - 247,917 Liens - Grants - 588 79,861 245,750 - _ 471034 - Due from other funds - Total Assets $ 748,780 $ 7,282 $ 255,199 $ 493,667 S 363,145 $ 874,272 1 471,034 $ 149,147 $ 154 $ 11,423 LIABILITIES AND FUND BALANCES Liabilities: Accounts payable $ - $ - $ - $ 8,656 $ 4,759 $ $ - $ 4,213 $ $ Accrued payroll payable - - - 3,663 5,318 - _ 334 Employees benefits payable - - - Due to other funds - 233,431 - - 471,034 Due to other governments - - 20,455 247,917 - _ Deferred revenue 3,793 - - - _ - - 154 Advances from other funds - Total Liabilities 3,793 20,455 493,667 10,077 471,034 4,547 154 Fund Balances: Reserved for encumbrances - - 35,615 10,944 - 15,684 2,400 Reserved for capital projects _ - _ _ - " Reserved for future fire station Reserved for land acquisition Reserved for employee leave pay outs Reserved for radio system acquisition Reserved for vehicle and " equipment replacement Unreserved: - Designated for working capital - - _ - _ _ Undesignated 744,987 7,282 234,744 (35,615) 342,124 874,272 (15,684) 142,200 11,423 Total Fund Balances 744,987 7,282 234,744 353,068 874,272 144,600 11,423 Total Liabilities and Fund Balances $ 748,780 $ 7,282 $ 255,199 $ 493,667 $ 363,145 $ 874,272 $ 471,034 $ 149,147 $ 154 $ 11,423 59 CITY OF RANCHO CUCAMONGA Schedule 4 Page 3 of 4 COMBINING BALANCE SHEET ALL SPECIAL REVENUE FUNDS JUNE 30, 1997 Masi California Major Urban Used Oil Local Law COP'S Commerce Library Literacy Resource Recycling Enforcement Program Center Measure I services Metrolink Campaign Library Grant Grant Block Grant Gram A S S E T S Cash and investments $ 3,679 $ 18,875 $ 438,273 $ 32,740 $ 8,122 $ 3,197 $ - $ 81,140 $ 285,428 Receivables(net of allowance for uncollectibles): Taxes - 129,009 12,304 - - - - - Accounts - 7,617 - - - - Accrued Interest - - - - - - - Deferred loans - - - - - - - Liens - - - - - - - Grants - - - - 14,176 -Due from other funds Total Assets $ 3,679 $ 147,884 $ 458,194 $ 32,740 $ 8,122 $ 3,197 $ 14,176 $ 81,140 $ 285,428 LIABILITIES AND FUND BALANCES Liabilities: Accounts payable $ 178 $ 48,234 $ 33,073 $ - $ 5,042 $ 1,094 $ 1,931 $ 8,053 $ - Accrued payroll payable - 765 13,846 - 523 - - - - Employees benefits payable - - - - - - Due to other funds - 727,682 - - - - 12,245 - - Due to other governments - - - - - - - - Deferred revenue - 10,000 - 2,557 2,103 - 73,087 - Advances from other funds Total Liabilities 178 776,681 56,919 8,122 3,197 14,176 81,140 Fund Balances: Reserved for encumbrances 194,826 1,289 828 2,374 - 28,897 - Reserved for capital projects - - - - - - - - Reserved for future fire station - - - - - - - Reserved for land acquisition - - - - - - - - Reserved for employee leave pay outs - - - - - - - - Reserved for radio system acquisition - - - Reserved for vehicle and equipment replacement - - - - - - - Unreserved: Designated for working capital - - 63,375 - - - - - - Undesignated 3,501 (823,623) 336,611 32,740828 2,374 2( 8,897) 285,428 Total Fund Balances 3,501 (628,797) 401,275 32,740 285,428 Total Liabilities and Fund Balances $ 3,679 $ 147,884 $ 458,194 $ 32,740 $ 8,122 $ 3,197 $ 14,176 $ 81,140 $ 285,428 60 CITY OF RANCHO CUCAMONGA Schedule 4 COMBINING BALANCE SHEET Page 4 of 4 ALL SPECIAL REVENUE FUNDS JUNE 30, 1997 California Adult Grandparents State Literacy TOTALS Education Act 6 Boob Foundation Fire ASSET S June 30 Grant Grant Grant District 1 9 9 7 , 1 9 9 6 Cash and investments $ $ 2,661 $ $ 8,107,616 $ 28,467,844 Receivables(net of allowance for uncollectibles): $ 24,187,846 Taxes Accounts - - 157,041 399,784 770,675 Accrued Interest - - 9,915 50,936 56 181 Deferred loans _ - 100,890 100,690 95,124 Liens - 247,917 196,389 Grants 3682 1,274 3,840 Due from other funds 8,640 - 1,380,451 1,085,282 18,094 18,094 102,751 Total Assets $ 3,682 $ 2,661 It 8,640 $ 6.393,556 $ 28,667,190 $ 26,498,058 LIABILITIES AND FUND BALANCES Liabilities: Accounts payable $ - $ 123 $ - $ 277,562 Accrued payroll payable $ 1,207,725 $ 979,480 Employees benefits payable 229,416 317,069 305,410 Due to other funds 3682 625,991 625,991 566,850 , Due to other governments - 237,347 2,242,141 1,300,511 Deferred revenue 25388,640 - 268,372 216,844 Advances from other funds _ _ 172,400 80,079 300,000 300,000 Total Liabilities 3,682 2,661 8,640 1,370,316 5,133,698 3,749,174 Fund Balances: Reserved for encumbrances 2,350 876,027 4,368,846 Reserved for capital projects - 4,407,392 4,034,698 Reserved for future fire station - Reserved for land acquisition - 1,988,944 1,988,944 1,692,910 _ Reserved for employee leave pay outs - 300,000 Reserved for radio system acquisition _ 288,160 Reserved for vehicle and - - 50,000 equipment replacement _ -Unreserved: - 1,733,536 1,991,516 1,110,971 Designated for working capital 1,300,760 Undesignated - 2350 5,394,760 4,721,2098,874,853 6,182,090 Total Fund Balances 5,023,240 23,533,492 22,748,884 Total Liabilities and Fund Balances $ 3,682 $ 2,661 $ 8,640 $ 6,393,556 $ 28,667,190 $ 26,498,058 61 CITY OF RANCHO CUCAMONGA Schedule 5 COMBINING STATEMENT OF REVENUES,EXPENDITURES Page 1 of 4 AND CHANGES IN FUND BALANCES ALL SPECIAL REVENUE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1997 Landscape Park Lighting Maintenance Systems Park Bond Gas Tax S8325 Recreation Developmem Beautification Districts Districts Development Act Revenues: Taxes $ - $ - $ - $ $ - $ 1,178,101 $ 5,042,049 $ - $ Fines and forfeits _Use of money and property 141,459 28,OD6 - 29,296 - 57,560 400,958 Intergovernmental 2,103,991 - - - 282,146 Charges for services 782,606 Development tees - 799,638 276,956 9,488 1,659,976 Other 216 37,324 Total Revenues 2,245,450 28,006 782,608 829,150 276,956 1,245,149 5,480,331 1,659,976 282,146 Expenditures: Current: General government - - - - 1,023,686 - 586,068 Public safety-fire protection - 47 _ Engineering and public works 1,457,618 22,194 - - 146,5 Community development - 4,382,147 - Community services 744,912 4,061 - - Ceplialoutlay 890,667 267,524 162 700,870 494,544 - 731,3411 264,680 282,146 Debt service: Principal 68,612 - - - Interest and fiscal charges 7,637 - Total Expenditures 2,424,534 289,718 745,074 704,931 641,091 1,023,686 5,113,495 850,748 282,146 Excess of Revenues over (under) Expenditures (179,084) (261,712) 37,534 124,219 (364,135) 221,463 366,836 809,228 Other Financing Sources (Uses): Operating transfers in - - 96,480 378,420 Operating transfers out - - _ - Miscellaneous - - Total Other Financing Sources(Uses) 96,480 378,420 Excess of Revenues and Other Sources over(under) Expendi- tures and Other Uses $ (179,084) $ (261,712) $ 134,014 $ 502,639 $ (364,135) $ 221,463 $ 366,836 $ 809,228 $ Fund Balances: Beginning of Fiscal Year-as previously reported $ 2,561,982 $ 657,621 $ 219,501 $ 293,955 $ 758,487 $ 1,043,338 $ 6,969,022 $ 2,162,323 $ Restatement 93,589 ___ . ___ - ____ - ____- - 56,662 Beginning of Fiscal Year-as restated 2,655,571 657,621 219,501 , 5 1 , 2,218,985 - Excess of Revenues and Other Sources over(under) Expendi- tures and Other Uses (179,084) (261,712) 134,014 502,639 (364,135) 221,463 366,836 809,228 - Residual Equity Transfer End of Fiscal Year(Schedule 4) $ 2,476,487 $ 395,909 $ 353,515 $ 796,594 $ 394,352 $ 1,264,801 $ 7,335,858 $ 3,028,213 $ 62 CITY OF RANCHO CUCAMONGA Schedule 5 COMBINING STATEMENT OF REVENUES,EXPENDITURES Page 2 of 4 AND CHANGES IN FUND BALANCES ALL SPECIAL REVENUE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1997 Community San Sevalnet Air South Drainage Pedestrian Federal Development Assessment Etiwanda Quality FETSIM Etiwanda Facilities Grants Aid Urban Block Grant Administration Drainage S8140 Improvement Grant Drainage Revenues: Taxes Fines and forfeits $ $ _ $ $ _ $ - $ $ $ $ $ Use of money and property 2,910 421 - 27,212 - - 5,603 Intergovernmental - 588 - 721,672 - 230,560 121,813 Charges for services _ _ Development fees 375,965 - - - 436,373 28,803 Other 3,580 - Total Revenues 378,875 1,009 725,252 463,585 28,803 230,560 127,416 Expenditures: Current: General government - - 401,476 - 224,525 Public safety-fire protection - - - - _ Engineering and public works 36,024 - - - Community development - - - 127841 - - - - - Community services _ - - - Capital outlay 587 597,411 3,056 230,560 55,374 Debt service: ' Principal - - _ - - Interest and fiscal charges " Total Expenditures 36,024 587 725,252 404,532 230,560 279,899 Excess of Revenues over (under) Expenditures 342,851 422 - 59,053 28,803 152,483 Other Financing Sources (Uses): Operating transfers in - - - - - - 98,590 - Operating transfers out - Miscellaneous _ - Total Other Financing Sources(Uses) 98,590 Excess of Revenues and Other Sources over(under) Expendi- tures and Other Uses $ 342,851 $ 422 $ $ $ 59,053 $' 28,803 $ $ 5( 3,893) $ $ Fund Balances: Beginning of Fiscal Year-as previously reported $ 402,136 $ 6,860 $ 312,648 $ $ 294,015 $ 845,469 $ 80,436 $ 198,493 $ - $ 11,423 Restatement (77,904) - (80,436) Beginning of Fiscal Year-as restated 402,136 6,860 234,744 294,015 845,469 - 198,493 - 11,423 Excess of Revenues and Other Sources over(under)Expendi- tures and Other Uses 342,851 422 - - 59,053 28,803 - (53,893) - - Residual Equity Transfer End of Fiscal Year(Schedule 4) $ 744,987 $ 7,282 $ 234,744 $ - 1_353 068 $ 874,272 $ $ 144,600 $ $ 11,423 63 CITY OF RANCHO CUCAMONGA Schedule 5 Page 3 of 4 COMBINING STATEMENT OF REVENUES,EXPENDITURES AND CHANGES IN FUND BALANCES ALL SPECIAL REVENUE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1997 Masi California Major Urban Used Oil Local Law COP'S Commerce Library Literacy Resource - Recycling Enforcement Program Center Measure I Services Metrolink Campaign Library Grant Grant Block Grant Grant Revenues: Taxes $ - $ - $ 895,479 $ - $ - $ - $ - $ - $ Fines and forfeits - Use of money and property - 4,112 3,960 727 - - - - 15,646 Intergovernmental - 995,016 - 31,463 99,833 10,611 27,502 14,012 269,782 Charges for services - 196,850 - Development fees 16,801 Other 91,634 Total Revenues 16,801 999,128 1,187,923 32,190 99,833 10,611 27,502 14,012 285,428 Expenditures: Current: General government 13,300 - - - - - - - - Public safety-fire protection - - - _ _ - - - Engineering and public works - 209,004 - 11,704 - - 27,502 - - Community development - - - - - - - Community services - 1,008,708 - 98,278 10,611 - 13,263 - Cappital outlay - 2,846,863 - 4,136 1,555 - 749 - Debt service: Principal - - 100,000 - - - - - - Interest and fiscal charges Total Expenditures 13,300 3,055,867 1,108,708 15,840 99,833 10,611 27,502 14,012 Excess of Revenues over (under)Expenditures 3,501 (2,056,739) 79,215 16,350 285,428 Other Financing Sources (Uses): Operating transfers in - - 100,000 - - - - - Operating transfers out - - - - - - - - Miscellaneous Total Other Financing Sources(Uses) 100,000 Excess of Revenues and Other Sources over(under) Expendi- tures and Other Uses $ 3,501 $ (2,056,739) $ 179,215 $ 16,350 $ $ $ $ $ 285,428 Fund Balances: Beginning of Fiscal Year-as previously reported $ $ 1,336,214 $ 222,060 $ 16,390 $ $ - $ - $ - $ _ Restatement 91,728 Beginning of Fiscal Year-as restated 1,427,942 222,060 16,390 - - - - - Excess of Revenues and Other Sources over(under) Expendi- tures and Other Uses 3,501 (2,056,739) 179,215 16,350 - - - - 285,428 Residual Equity Transfer End of Fiscal Year(Schedule 4) $ 3,501 $ (628,797) L 401,275 $ 32,740 $ $ $ $ $ 285,428 64 CITY OF RANCHO CUCAMONGA Schedule 5 COMBINING STATEMENT OF REVENUES, EXPENDITURES Page 4 of 4 AND CHANGES IN FUND BALANCES ALL SPECIAL REVENUE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1997 California Adult Grandparents State Literacy TOTALS Education Act 6 Books Foundation Fire Year ended June 30. Grant Grant Grant District 1997 1996 Revenues: Taxes $ - $ $ - $ 6,962,078 77,707 Fines and forfeits - 18,853 $ 14018,853 $ 13,784,001 981 Use of money and properly 381,786 1,099,656 1,147,899 Intergovernmental 3,682 2,462 1,242,125 6,157,258 5,796,121 Charges for services _ - Developmentfees _ - 105,110 1,084,568 870,239 Other 2,713,750 229,349 3362,03 2116,119 Total Revenues 3,682 2,462 8,939,301 26,404,145 24,523,110 Expenditures: Current: General government - - - 2,249,055 1,631,363 Public safety-fire protection - - - 9,096,377 9,096,377 8,951,549 Engineering and public works - - 1,910,593 2,645,840 Community development 4,509,988 3,523,973 Community services 3,682 2,462 1,885,977 2,632,464 De I s outlayervice: - 7,372,232 4,132,338 Debs Principal - - - 25,000 193,612 161,146 Interest and fiscal charges - 99,062 106,699 10,186 Total Expenditures 3,682 2,462 9,220,439 27,324,533 23,688,859 Excess of Revenues over (under)Expenditures (281,138) (920,388) 834,251 Other Financing Sources (Uses): Operating transfers In - - - 455,145 1,128,635 1,006,881 Operating transfers out 374,715 Miscellaneous 492722 492772 ( 10141) Total Other Financing Sources(Uses) 947,867 1,621,357 642,307 Excess of Revenues and Other Sources over(under)Expendi- tures and Other Uses $ $ $ $ 666,729 $ 700,969 $ 1,476,558 Fund Balances: Beginning of Fiscal Year•as previously reported $ - $ - $ - $ 4,356,511 $ 22,748,884 $ 21,272,068 Restatement - 83,639 Beginning of Fiscal Year-as restated - - 4,356,511 22,832,523 21,272,068 Excess of Revenues and Other Sources over(under) Expendi- tures and Other Uses - - - 666,729 700,969 1,476,558 Residual Equity Transfer - 258 End of Fiscal Year(Schedule 4) $ $ $ $ 5,023,240 $ 23,533,492 $ 22,748,884 65 _ CI OF RANCHO CUCAMONGA Schedule COMBINING SCHEDULE OF REVENUES, Page 1 of 10 EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL(BUDGETARY BASIS) ALL SPECIAL REVENUE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1997 OAS TAX SB 325 RECREATION Variance- Variance- variance. Favorable Favorable Favorable Revenues: Budget Actual (Unfavorable) Budget Actual (Unfavorable) Budget Actual (Unfavorable) Texas $ E - E - $ - $ - $ - $ $ $ Fines and forfeits - - Use of money and property 31,000 141,459 110,459 6,000 28,006 22,006 - - - intergovernmental 1,860,000 2,103,991 243,991 - Charges for services - - - - - - 772,020 782,608 10,588 Development fees - - - - - Other Total Revenues 1,891,000 2,245,450 354,450 6,000 28,006 22,006 772,020 782,608 10,588 Expenditures: Current: General government - - - - - - Public safety-fire protection - - - - Engineeringandpublicworks 1,599,980 1,466,005 133,175 23,980 22,194 1,786 - - - Community development - - - - - Community services - - 823,365 793,456 29,909 Capital outlay 1,053,424 896,727 156,697 375,946 350,741 25,205 20,900 10,794 10,106 Debt service: Principal - 68,612 (68,612) - - - - - Interest and fiscal charges - 7,637 (7,637) - Total Expenditures 2,653,404 2,439,781 213,623 399,926 372,935 26,991 844,265 804,250 40,015 Excess of Revenues over (under)Expenditures (762,404) (194,331) 5680073 (393,926) 344,929 48,997 �� (72.245) 21,642 50,603 Other Financing Sources(Uses): Operating transfers in - - - - - 96,480 96,480 - Operating transfers out - - - - - Other Total Other Financing Sources(Uses) - - - 96,480 96,480 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(Budgetary Basis) (762,404) (194,331) 568,073 (393,926) (344,929) 48,997 24,235 74,838 50,603 Adjustments: To adjust for encumbrances 15,247 15,247 - 83,217 83,217 59,176 59,176 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) E (762,404) S (179,084) S 583,320 E (393,926) E (261,712) $ 132,214 $ 24,235 It 134,014 $ 109,779 Fund Balances: Beginning of Fiscal Year-as previously reported $ 2,561,982 52,561,982 $ - $ 657,621 $ 657,621 $ - S 219,501 $ 219,501 S - Restatement 93,589 93,589 Beginning of Fiscal Year-as restated 2,561,982 7655,571 93,589 657,621 657,621 - 219,501 219,501 - Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) (762,404) (179,084) 5831320 (393,926) (261,712) 132,214 24,235 134,014 109,779 End of Fiscal Year $ 1,799,578 $2,476,487 $ 676,909 $ 263,695 $ 395,909 $ 132,214 $ 243,736 $ 353,515 E 109,779 66 CITY OF RANCHO CUCAMONGA Schedule 6 COMBINING SCHEDULE OF REVENUES, Page 2 of 10 EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL(BUDGETARY BASIS) ALL SPECIAL REVENUE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1997 PARK DEVELOPMENT Varfance- Varfance- BEAUTIFICATION LIGHTING DISTRICTS Vadance- Favorable Favorable Favorable Revenues: Budget Actual (Unfavorable) Budget Actual (Unlavorable) Budget Actual (Unfavorable) Taxes E - E - E - $ - S - $ - $ 874,950 E 1,178,101 $ 303,151 Fines and forfeits Use of money and property 7,000 29.296 22,296 Intergovernmental - 27,320 57,560 30,240 Charges for services Development fees 750,000 799,638 49,638 264,500 276,956 (7,544) 6,890 9,488 2,598 Other 300 216 (84) Expenditures: Total Revenues 757,300 829,150 71,85 09 0 284,500 276,956 (7,544) 9 ,160 1,245,149 335,989 Current: General government - - - - - - 1,062,790 1,023,761 39,029 Public safety-fire protection _ Engineering and public works - - - 146,390 146,547 (157) - Community development _ - - Community services 4,780 4,780 - - _ Capital outlay 756,620 740,884 15,736 687,501 579,124 108,377 - Debt service: - Principal _ Interest and fiscal charges Total Expenditures 761,400 745,664 15,736 833,891 725,671 108,220 1,062,790 1,023,761 39,029 Excess of Revenues over (under)Expenditures (4,100) 83,486 871586 (549,391) (448,715) 100,676 (153,630) 221,388 375,018 Other Financing Sources(Uses): Operating transfers in 378,420 378,420 Operating transfers out _ _ _ _ - Other Total Other Financing Sources(Uses) 378,420 378,420 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(Budgetary Basis) 374,320 461,906 87,586 (549,391) (448,715) 100,676 (153,630) 221,388 375,018 Adjustments: To adjust for encumbrances 40,733 40,733 84,580 84,580 75 75 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) $ 374,320 S 502,639 $ 128,319 S (549,391) $ (364,135) S 185,256 E (153,630) E 221,463 $ 375,093 Fund Balances: Beginning of Fiscal Year-as previously reported $ 293,955 $ 293,955 $ - $ 758,487 E 758,487 $ - $1,043,338 $ 1,043,338 $ - Restatement Beginning of Fiscal Year-as restated ------- 293,955 293,955 758,487 758,487 - 1,043,338 1,043,338 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) 374,320 502,639 128,319 (549,391) (364,135) 1851256 (153,630) 221,463 375,093 End of Fiscal Year $ 668,275 $ 796,594 $ 128,319 S 209,096 S 394,352 E 185,256 $ 889,708 $ 1,264,801 $ 375,093 67 CITY OF RANCHO CUCAMONGA Schedule 6 COMBINING SCHEDULE OF REVENUES Page 3 of 10 EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL(BUDGETARY BASIS) ALL SPECIAL REVENUE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1997 LANDSCAPE MAINTENANCE DISTRICTS SYSTEMS DEVELOPMENT PARK BOND ACT Variance- Variance- Variance- Favorable Favorable Favorable Revenues: Budget Actual (Unfavorable) Budget Actual (Unfavorable) Budget Actual (Unfavorable) Taxes $ 4,800,700 E 5,042,049 $ 241,349 $ - E - E - $ - E - $ Fines and forfeits - - - - - - - Use of money and property 262,060 400,958 138,898 - - - - Intergovernmental - - - - - 167,710 282,146 114,436 Charges for services - - - - - Development fees - - - 895,000 1,659,976 764,976 - - - Other 6,000 37,324 31,329 Total Revenues 5,068,760 5,480,331 411,571 895,000 1,659,976 764,976 167,710 282,146 114,436 Expenditures: Current: General government - - - 626,570 590,896 35,674 - - - Public safety-fire protection - - - - - Engineering and public works - - - - - Community development 5,022,693 4,435,699 586,994 - - - - Community services - - - - 53 - - - Capital outlay 936,751 840,363 96,388 720, 0 395,077 325,453 282,160 282,146 14 Debt service: Principal - - - - - Interest and fiscal charges Total Expenditures 5,959,444 5,276,062 683,382 1,347,100 985,973 361,127 282,160 282,146 14 Excess of Revenues over (under)Expenditures (890,684) 204,269 1,094,953 (452,100) 674,003 1,126,103 (114,450) 114,450 Other Financing Sources(Uses): Operating transfers in - - - - - - - - Operating transfers out - - - - - - - Other Total Other Financing Sources(Uses) Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(Budgetary Basis) (890,684) 204,269 1,094,953 (452,100) 674,003 1,126,103 (114,450) - 114,450 Adjustments: To adjust for encumbrances 162,567 162,567 135,225 135,225 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) $ (890,684) $ 366,836 S 1,257,520S (452,100) $ 809,228 $ 1,261,328 E (114,450) $ E 114,450 Fund Balances: Beginning of Fiscal Year-as previously reported $ 6,969,022 $ 6,969,022 $ - $ 2,162,323 $2,162,323 $ - $ - $ - $ - Restatement 56,662 56,662 Beginning of Fiscal Year-as restated 6,969,022 6.969,022 - 2,162,323 2,218,985 56,662 - - - Excess ofRevenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) (890,684) 366,836 1,257,520 (452,100) 809,228 1,261,328 (114,450) 114,450 End of Fiscal Year $ 6,078,338 $ 7,335,858 $ 1,257,520 S 1,710,223 $3,028,213 $ 1,317,990 L(114.450) $ S 114,450 68 CITY OF RANCHO CUCAMONGA Schedule 6 COMBINING SCHEDULE OF REVENUES, Page 4 of 10 EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL(BUDGETARY BASIS) ALL SPECIAL REVENUE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30,1997 DRAINAGE FACILITIES PEDESTRIAN GRANTS FEDERAL AID URBAN Vedanta• Vadanrx- Vedance- Favorable Favorable Favorable Revenues: Budget Actual (Unfavorable) Budaat Actual (Unfavorable) Budget Actual (Unfavorable) Taxes Fines and forfeits § _ E _ s $ - § § - E - § - § Use of money and property 1,100 2,910 1,810 100 421 321 Intergovernmental - - - 4,000 508 (3,412) Charges for services _ - - - _ _ Development fees 80,000 375,965 295,965 - Other - - TRevenues Expenditures:es: 81,100 378,875 297,775 4,100 1,009 (3,091) _ Current: General government Public safety-fire protection Engineering and public works 38,580 36,024 2,556 - - Community development _ - - Community servicesCapital outlay 41,000 - 150 21,150 41,000 4,000 587 3,413 21, Debt service: - Principal interest and fiscal charges Total Expenditures 79,580 36,024 43,558 4,000 587 3,413 21,150 21,150 Excess of Revenues over (under)Expenditures 1,520 342,851 341,331 100 422 322 (21.150) 21,150 Other Financing Sources(Uses): Operating transfers in Operating transfers out Other Total Other Financing Sources(Uses) Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(Budgetary Basis) 1,520 342,851 341,331 100 422 322 (21,150) - 21,150 Adjustments: To adjust for encumbrances Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) E 1,520 E 342,851 § 341,331 § 100 § 422 E 322 § 1,150 E E 21,150 Fund Balances: Beginning of Fiscal Year-as previously reported § 402,136 E 402,136 E - E 6,860 E 8,860 E - $ 312,648 E 312,648 E - Restatement - - - - - - 7,904 (77,904) Beginning of Fiscal Year-as restated 402,136 402,136 - 6,860 6,860 - 312,648 234,744 (77,904) Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) 1,520 342,851 341,331 100 422 322 21,150 21.150 End of Fiscal Year E 403,656 $ 744,987 § 341,331 s 6,960 $ 7,282 E 322 E 291,498 E 234,744 E 56,754 69 M CI IM MCHO CUCW NGA� � i � dm MIM i Schedule 6 COMBINING SCHEDULE OF REVENUES, Page 5 of 10 EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL(BUDGETARY BASIS) ALL SPECIAL REVENUE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1997 COMMUNITY DEVELOPMENT BLOCK GRANT ASSESSMENT ADMINISTRATION 89140 Varlanc Varlance- Variance- Favorable Favorable Favorable Revenues: Budget Actual (Unfavorable) Budget Actual (Unfavorable) Budget Actual (Unfavorable) Taxes E S - $ - E - $ - $ - $ - E Fines and forfeits - _Use of money and property - 25,000 27,212 2,212 - - - intergovernmental 841,540 721,672 (119,868) - - - 385,550 230,560 Charges for services _ - (154.990) Development lees - - Other 427,310 436,373 9,063 - 3,580 3,580 Expenditures:Total Revenues 841,540 725,252 (116,288) 452,310 463,585 11,275 385,550 230,560 (154,990) Current: General government - - - 422,930 408,144 14,786 Public safety-fire protection _ _ _ - Engineering and public works - Community development 130,430 130,430 - Community servicesCapital outlay 774,414 630,437 143,977 10,590 7,332 3,258 385,650 246,244 139,406 Debt service: Principal - - Interest and fiscal charges - Total Expenditures 904,844760,867 143,977 433,520 415,476 18.044 385,650 246,244 139,406 Excess of Revenues over (under)Expenditures (63,304) (35,615) 271689 18,780 48,109 29,319 (100) (15,684) (15,584) Other Financing Sources(Uses): Operating transfers in - - - - Operating transfers out - Other - Total Other Financing Sources(Uses) Excess of Revenues and Other Sources over(under) Expenditures and Other Uses(Budgetary Basis) (63,304) (35,615) 27,689 18,790 48,109 29,319 (100) (15,684) (15,584) Adjustments: To adjust for encumbrances - 35,615 35,615 10,944 10,944 15,684 15,684 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) S (63,304) S - E 63,304 S 18,790 E 59,053 S 40,263 S (100) E E 100 Fund Balances: Beginning of Fiscal Year-as previously reported S - E - E - E 294,015 E 294,015 s - E 80,436 E 80,436 E Restatement - - - - (80,436) (80,436) Beginning of Fiscal Year-as restated - - - 294,015 294,015 - 80,436 - (80,436) Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) (63,304) 63,304 18,790 59,053 40,263 (100) 108 End of Fiscal Year !-&3_,304L S E 63,304 $312,805 S 353.068 E 40,263 E 80,336 E 1_L80 336L 70 CITY OF RANCHO CUCAMONGA Schedule 6 COMBINING SCHEDULE OF REVENUES, Page 6 of 10 EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL(BUDGETARY BASIS) ALL SPECIAL REVENUE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1997 AIR OUAUTY IMPROVEMENT MASI COMMERCE CENTER MEASUREI Variance- Verfanca- Verlence- Favorable Favorable Favorable Revenues: Budget Actual (Unfavorable) Budget Actual (Unfavorable) Budget Actual (Unfavorable) Taxes Fines end forfeits $ _ $ _ S $ - S - $ - S - S - S Use of money and property 5,050 5,603 553 4,112 Intergovernmental 126,100 121,813 (4,287) - - - 3,150,000 995,016 4 112 Charges for services _ _ (2.154,984) Development fees 20000 16801 - - - Other - - (3,199) - - Total Revenues 131,150 Expenditures: 127,418 (3,734) 20,000 161801 (3,199) 3,15%000 999,128 (2,150,872) Current: General government 229,740 224,525 5,215 20,000 13,300 6,700 Public safety-fire protection - - - - Engineering and public corks - - - - - - 243,050 209,004 34,046 Community development Community services - Capital outlay 55,774 57,774 (2,000) - - - 3,086,650 3,041,689 44,961 Debt service: Principal Interest and fiscal charges - Total Expenditures 285,514 282,299 3,216 20,000 13,300 6,700 3,329,700 3,250,693 79,007 Excess of Revenues over (under)Expenditures (154,364) (154,883) (519) 3,501 3,501 (179,700) (2,251,565) (2,071,865) Other Financing Sources(Uses): Operating transfers in 98,590 98,590 - - _ Operating transfers out Other _ Total Other Financing Sources(Uses) 98,590 98,590 _ Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(Budgetary Basis) (55,774) (56,293) (519) - 3,501 3,501 (179,700) (2,251,565) (2,071,865) Adjustments: To adjust for encumbrances 2,400 2,400 194,826 194,826 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) S (55,774) S (53,893) $ 1,881 $ 5 3,501 S 3,501S (179,700) S (2,056,739) E (1,877,039) Fund Balances: Beginning of Fiscal Year-as previously reported $ 198,493 $ 198,493 S - $ - $ - $ - S 1,336,214 $ 1,336,214 $ Restatement - - - 91,728 91,728 Beginning of Fiscal Year-as restated 198,493 198,493 - - - - 1,336,214 1,427,942 91,728 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) (55,774) (53,893) 1,881 - 3,501 3,501 (179,700) (2,056,739) (1,877,039) End of Fiscal Year $ 142,719 S 144,600 $ 1,881 $ S 3,501 $ 3,501 11,156,514 $ (628,797) S (1,785,311) 71 CITY OF RANCHO CUCAMONGA Schedule 6 COMBINING SCHEDULE OF REVENUES, Page 7 of 10 EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL(BUDGETARY BASIS) ALL SPECIAL REVENUE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30,1997 LIBRARY SERVICES METROLINK CALIFORNIA LITERACY CAMPAIGN Vadance- Variance- Vadance- Favorable Favorable Favorable Revenues: Budget Actual (Unfavorable) Budget Actual (Unfavorable) Budget Actual (Unfavorable Taxes $ 878,920 S 895,479 S 16,559 E - E - E - E - S - $ Fines and forfeits _ - _ Use of money and property _ 3.960 3,9w - 727 727 ' intergovernmental - - 13,560 31,463 17,90.3 90,430 99,833 9,403 Charges for services 178,400 196,850 18,450 - Development fees - Other 99,570 91,634 (7,936) - - - - Total Revenues 1,156,890 1,187,92331,033 13,560 32,190 18,630 90,430 99,833 9,403 Expenditures: Current: General government Public safety-fire protection Engineering and public works - - - 12,613 11,704 909 - Community development - _ -Community services 1,210,846 1,009,997 200,849 - - - 101,428 99,106 2,322 Capital outlay 3,000 - 3,000 4,140 4,136 4 1,555 1,555 - Debt service: Principal - /00,000 (100,000) Interest and fiscal charges Total Expenditures 1,213,846 1,109,997 103,849 16,753 15,840 913 102,983 100,661 2,322 Excess of Revenues over (under)Expenditures (56,956) 77,926 134,882 (3,193) 16,350 19,543 (12,553) (828) 11,725 Other Financing Sources(Uses): Operating transfers in 100,000 100,000 - - _ Operating transfers out _ - - Other Total Other Financing Sources(Uses) 100,000 100,000 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(Budgetary Basis) 43,044 177,926 134,882 (3,193) 16,350 19,543 (12,553) (828) 11,725 Adjustments: To adjust for encumbrances 1,289 1,289 828 828 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) $ 43,044 E 179,215 E 136,171 E (31193) $ 16,350 S 19,543 S (12,553) $ $ 12,553 Fund Balances: Beginning of Fiscal Year-as previously reported E 222,060 $ 222,060 $ - E 16,390 E 16,390 S - E - E - $ - Restatement Beginning of Fiscal Year-as restated --------222,060 222,060 - 16,390 16,390 - - - Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) 43,044 179,215 136,171 (3,193) 16,350 19,543 (12,553) 12,553 End of Fiscal Year S 265,104 S 401,275 S 136,171 E 13,197 $ 32,740 S 19,543 S (12,553) S E 12,553 72 CITY OF RANCHO CUCAMONGA Schedule 6 COMBINING SCHEDULE OF REVENUES, Page B of 10 EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL(BUDGETARY BASIS) ALL SPECIAL REVENUE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30,1997 MAJOR URBAN LOCAL LAW ENFORCEMENT RESOURCE LIBRARY GRANT USED OIL RECYCLING GRANT BLOCK GRANT Varlance- Varlencs Vadance- Favorable Favorable Favorable Revenues: Budget Actual (Unfavorable) Budget Actual (Unfavorable) Budget Actual (Unfavorable) Taxes E - E - E - E - E - S - E - E - E Fines and forfeits Use of money and property Intergovernmental 13,000 10,611 (2,389) 26,310 27,502 1,192 87,100 14,012 (73,088) Charges for services - _ _ Development fees Other Total Revenues13,000 10611 (2389) 26,310 27,502 1,192 87,100 14,012 Expenditures: , , (73,0ee) Current: General government - Public safety-fire protection Engineering and public works - - 28 430 27 502 928 - - - Community development - _ _ - Community services 13,000 12,985 15 - - - 29,190 19,915 9,275 Capital outlay - - - - - - 63,280 22,994 40,286 Debt service: Principal Interest and fiscal charges " Total Expenditures 13,000 12.985 15 28,430 27,502 928 92,470 42,909 49,561 Excess of Revenues over (under)Expenditures (2,374) (2,374) (2,120) 2,120 (5,370) (20,897) (23,527) Other Financing Sources(Uses): Operating transfers in Operating transfers out Other Total Other Financing Sources(Uses) Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(Budgetary Basis) - (2,374) (2,374) (2,120) - 2,120 (5,370) (28,897) (23,527) Adjustments: To adjust for encumbrances 2,374 2,374 - 28,897 28,897 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) $ E E S (2,120) S S 2,120 S (5,370) E E 5,370 Fund Balances: Beginning of Fiscal Year-as previously reported S - $ - E - E - E - $ - E - E - E - Restatement Beginning of Fiscal Year-as restated - - - - Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) - (2,120) 2,120 (5,370) 5,370 End of Fiscal Year $ $ - E E (2,120) L-- S 2,120 S (5,37o) § E 5,370 73 _ mom ad � vw _ CITMRA CUPAM-6NGAa go ' � Schle 6 COMBINING SCHEDULE OF REVENUES, Page 9 of 10 EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL(BUDGETARY BASIS) ALL SPECIAL REVENUE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1997 COP'S PROGRAM GRANT ADULT EDUCATION ACT GRANT GRANDPARENTS b BOOKS GRANT Variance- Variance• Vada;;;- Favorable Favorable Favorable Revenues: Budget Actual (Unfavorable) Budget Actual (Unfavorable) Budget Actual (Unfavorable) Taxes E - E - E - E - E - E - E - E - E - Fines and forfeits Use of money and property - 15,646 15,646 - - - Intergovernmental - 269,782 269,782 3,690 3,682 (8) 5,000 2,462 (2,538) Charges for services - _ - Development fees Other Total Revenues 285,428 285,428 3,690 3,682 (8) 5,000 2,462 (2,538) Expenditures: Current: General government Public safety-fire protection Engineering and public works - Community development - Community services 3,690 - 3,690 3,690 3,682 8 5,000 4,812 188 Capital outlay - - - - _ _ Debt service: Principal tnterest and fiscal charges Total Expenditures 3,690 - 3,690 3,690 3,682 8 5,000 4,812 188 Excess of Revenues over (under)Expenditures (3,690) 285,428 289,118 - - (2,350) (2,350) Other Financing Sources(Uses): Operating transfers in - - - - - - Operating transfers out Other Total Other Financing Sources(Uses) Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(Budgetary Basis) (3,690) 285,428 289,118 - - - - (2,350) (2,350) Adjustments: To adjust for encumbrances - 2,350 2,350 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) $ (3,690) E 285,428 E 289,118 E $ E $ E E Fund Balances: Beginning of Fiscal Year-as previously reported E - E - E - E - E - E - E - E - E - Restatement Beginning of Fiscal Year-as restated - - - - - - - - Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) (3,690) 285,428 289,118 End of Fiscal Year S (3,690) $ 285.128 E 289,118 E E E - E E E 74 CITY OF RANCHO CUCAMONGA Schedule 6 COMBINING SCHEDULE OF REVENUES, Page 10 of 10 EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL(BUDGETARY BASIS) ALL SPECIAL REVENUE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30,1997 T O T A L S-Year Ended June 30, FIRE DISTRICT 1997 1996 Varfance• Vedanee• Favorable Favorable Revenues: Budget Actual (Unfavorable) Budget Actual (Unfavorable) Actual Taxes E 8,836,866 E 6,962,078 E 125,212 E 13,391,436 E 14,077,707 E 686,271 E 13,794,981 Fines and forfeits 83,620 18,853 (64,767) 83,620 18,853 (64,767) 84,001 Use of money and property 354,489 381,786 27,297 719,119 1,099,656 380,537 1,147,899 Intergovernmental 1,247,520 1,242,125 (5,395) 8,021,510 6,157,250 Charges for services (1,864,252) 5,796,121 9 90,370 105,110 14,740 1,040,790 1,084,568 43,778 870,239 Development fees - - 2,483,700 3,575,197 1,111,497 2,685,361 Other 228,000 229,349 1,349 333,870 362,103 28,233 116,119 Total Revenues 8,840,865 8,939,30198,436 26,054,045 26,375,342 321,297 24,494,721 Expenditures: Current: General government - - - 2,362,030 2,260,626 101,404 1,634,636 Public safety-fire protection 9,213,160 9,096,377 116,783 9,213,160 9,096,377 116,783 8,951,549 Engineering and public works - - - 2,093,023 1,919,780 173,243 2,645,840 Community development - - - 5,153,123 4,566,129 586,994 3,529,439 Community services - - - 2,194,989 1,948,733 246,256 2,641,530 Capital outlay - - - 9,285,035 8,100,604 1,176,431 8,483,379 Debt service: Principal 25,000 25,000 - 25,000 193,612 (168,612) 161,146 Interest and fiscal charges 99,062 99,062 99,062 106,699 (7,637) 10,186 Total Expenditures 9,337,222 9,220,439 116,783 30,425,422 28,200,500 2,224,862 28,057,705 Excess of Revenues over (under)Expenditures (496,357) (281,138) 215,219 (4,371,377) (1,825,218) 2,546,159 (3,562,984) Other Financing Sources(Uses): Operating transfers in 650,000 455,145 (194,055) 1,323,490 1,128,635 (194,855) 1,006,881 Operating transfers out - - - (374,715) Other 534,200 492,722 (41,478) 534,200 492,722 (41,478) 10,141 Total Other Financing Sources(Uses) 1,184,200 947,867 (236,333) 1,857,690 1,621,357 (236,333) 842,307 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(Budgetary Basis) 687,843 666,729 (21,114) (2,513,687) (203,861) 2,309,826 (2,920,677) Adjustments: To adjust for encumbrances - 876,027 676,027 4,368,846 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) E 687,843 E 666,729 E (21,114) E (2,513,687) E 672,166 E 3,185,853 E 1,448,169 Fund Balances: Beginning of Fiscal Year-as previously reported E 4,356,511 E 4,356,511 $ - E 21,903,415 E 21,903,415 E - E 20,455,246 Restatement - - - 83,639 83,639 Beginning of Fiscal Year-as restated 4,39,511 7356511 - 21,903,415 21,987,054 83,639 20,455,246 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) 687,843 666,729 (21,114) (2,513,687) 672,166 3,185,853 1,448,169 End of Fiscal Year E 5,044,354 E 5,023,240 1_&I.I 14L E 19,389,728 E 22.659,220 E 3,269,492 E 21,903,415 75 puwooF— Cnwcr- > — UW LL :Dz0 r � r► r r r w� r r r r � s ils e r r .rs r 1 1 1 This page intentionally left blank. DEBT SERVICE FUNDS Public Improvement Corporation Fund The Rancho Cucamonga Public Improvement Corporation was incorporated on November 14, 1988 under the Non-Profit Public Benefit Corporation Law of the State of California. The Corporation L was established for charitable purposes including rendering financial assistance to the City by financing, acquiring, constructing, improving and leasing public improvements for the benefit of residents of the City and the surrounding area. Redevelopment Agency Fund A This fund is established to accumulate monies for the payment of loans from the City of Rancho Cucamonga (payable as funds become available to the Agency), and payment of specific Tax ' Allocation Bonds due in annual installments. All tax increment monies received,placed in this fund, and used to retire debt are done so in accordance with the Health and Safety Code. This page intentionally left blank. = rM m CITY OF RANCHO CUCAMONGA Schedule 7 COMBINING BALANCE SHEET ALL DEBT SERVICE FUNDS JUNE 30, 1997 Public TOTALS Improvement Redevelopment June 30, A S S E T S Corporation Agency 1 9 9 7 1996 Cash and investments $ - $ 15,691,734 $ 15,691,734 $ 14,261,260 Cash and investments with fiscal agent 295,709 5,156,475 5,452,184 5,822,459 Receivables(net of allowance for uncollectibles): Taxes 188,585 188,585 605,602 Due from other funds 397,859 397,859 97,859 Total Assets $ 295,709 $ 21,434,653 $ 21,730,362 $ 20,787,180 LIABILITIES AND FUND BALANCES Liabilities: Accounts payable $ - $ 1,232,148 $ 1,232,148 $ 1,169,551 Due to other funds - 15,150 15,150 97,993 Due to other governments 611 611 611 Total Liabilities 1,247,909 1,247,909 1,268,155 Fund Balances: Reserved for encumbrances - 20,886 20,886 85,067 Unreserved: Designated for debt service 295,709 20,165,858 20,461,567 19,433,958 Total Fund Balances 295,709 20,186,744 20,482,453 19,519,025 Total Liabilities and Fund Balances $ 295,709 $ 21,434,653 $ 21,730,362 $ 20,787,180 76 CITY OF RANCHO CUCAMONGA Schedule 8 COMBINING STATEMENT OF REVENUES,EXPENDITURES AND CHANGES IN FUND BALANCES ALL DEBT SERVICE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1997 Public - TOTALS Improvement Redevelopment Year Ended June 30 Revenues: Corporation Agency 1997 1998 Taxes Use of money and property $ - $ 17,562,306 $ 17,562,306 $ 17,721,077 14,337 510,422 524,759 518,052 Expenditures:Total Revenues 14,337 18,072,728 18,087,065 18,239,129 Current: General government Capital Outlay _ 776,206 776,206 283,140 Debt Service: 125,911— 125,911 445,858 Principal 330,000 8,651,695 Interest and fiscal charges 8,981,695 8,452,442 , 6,602,059 �/ 6,668,262 6,787,158 Total Expenditures 66,266,2D3 Excess of Revenues over 396,203 16,155,871 16,552,074 15,968,598 (under) Expenditures (381,866) 1,916,857 1,534,991 2,270,531 Other Financing Sources (Uses): Operating transfers in 388,824 8,331,108 Operating transfers out 8,719,932 9,108,334 (8,703,503 Miscellaneous ) (8,703,503) (11,180,810) Total Other Financing (587,992) (587,992) (588,O Sources(Uses) 388,824 Excess of Revenues and Other (960,387) (571,563) (2,660,476) Sources over(under) Expendi- tures and Other Uses 6,958 956,470 963,428 Fund Balances: (389,945) Beginning of Fiscal Year 288,751 19,230,274 19,519,025 19,908,970 End of Fiscal Year $ 295,709 $ 20,186,744 $ 20,482,453 $ 19,519,025 77 m m �w Mm w � ` i r Men = s r r M MM a a� r r r �r ai■� a �rr r r r r r r r � r CITY OF RANCHO CUCAMONGA Schedule 9_ COMBINING SCHEDULE OF REVENUES,EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL ALL DEBT SERVICE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30,1997 T O T A L S-Year Ended June 30, REDEVELOPMENT AGENCY 1997 1996 Variance- Variance- Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) Actual Revenues: Taxes $ 17,291,405 $ 17,562,306 $ 270,901 $ 17,291,405 $ 17,562,306 $ 270,901 $ 17,721,077 Use of money and property 510,422 510,422 510,422 510,422 501,899 Total Revenues 17,291,405 18,072,728 781,323 17,291,405 18,072,728 781,323 18,222,976 Expenditures: Current: General government 1,306,790 779,417 527,373 1,306,790 779,417 527,373 283,140 Capital outlay 150,000 143,586 6,414 150,000 143,586 6,414 530,925 Debt service: Principal 18,695,860 8,651,695 10,044,165 18,695,860 8,651,695 10,044,165 8,142,442 Interest and fiscal charges 8,439,072 6,602,059 1,837,013 8,439,072 6,602,059 1,837,013 6,698,308 Total Expenditures 28,591,722 16,176,757 12,414,965 28,591,722 16,176,757 12,414,965 15,654,815 Excess of Revenues over (under) Expenditures (11,300,317) 1,895,971 13,196,288 (11,300,317) 1,695,971 13,196,288 2,568,161 Other Financing Sources(Uses): Operating transfers in 8,331,110 8,331,108 (2) 8,331,110 8,331,108 (2) 8,733,619 Operating transfers out (8,525,435) (8,703,503) (178,068) (8,525,435) (8,703,503) (178,068) (11,180,810) Miscellaneous (3,273,590) (587,992) 2,685,598 (3,273,590) (587,992) 2,6851598 (588,000) Total Other Financing Sources(Uses) (3,467,915) (960,387) 2,507,528 (3,467,915) (960,387) 2,5071528 (3,035,191) Excess of Revenues and Other Sources over(under) Expenditures and Other Uses(Budgetary Basis) (14,768,232) 935,584 15,703,816 (14,768,232) 935,584 15,703,816 (467,030) Adjustments: To adjust for encumbrances 20,886 20,886 20,886 20,886 85,067 Excess fo Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP Basis) (14,768,232) 956,470 15,724,702 (14,768,232) 956,470 15,724,702 (381,963) Fund Balances: Beginning of Fiscal Year 19,230,274 19,230,274 19,230,274 19,230,274 19,612,237 End of Fiscal Year $ 4,462,042 $ 20,186,744 $ 15,724,702 $ 4,462,042 $ 20,186,744 $ 15,724,702 $ 19,230,274 78 . I 1 This page intentionally left blank. r . r r r r. r r r r r r +� a� � � � r +� a � � ar r r �r s � � w � Cn � ZCm cn —� C� m �- O � � � D —I - -vDC� This page intentionally left blank. r ' CAPITAL PROJECTS FUNDS Assessment District 82-IR Fund Established to account for the receipt and disbursement of funds used in the construction of streets, storm drainage and utility improvements within the project area. Financing was provided by the sale of bonds under the Refunding Act of 1984 for 1915 Improvement Act Bonds. ' Assessment District 84-1 Fund Established to account for the receipt and disbursement of funds used in the construction and ' installation of public capital drainage facilities, together with appurtenant work and incidental expenses,to serve and provide drainage protection to property located within Community Facilities District No. 84-1 (Day Creek Drainage System). Financing was provided by the sale of bonds under 1 the Mello-Roos Community Facilities Act of 1982. ' Assessment District 84-2 Fund Established to account for the receipt and disbursement of funds used in the construction of certain public works of improvement, together with appurtenances and appurtenant work, including acquisition where appropriate, in Special Assessment District No. 84-2 (Alta Loma Channel Improvement). Financing was provided by sale of bonds under the Improvement Bond Act of 1915. 1 Assessment District 86-2 Fund Established to account for the receipt and disbursement of funds used in construction and acquisition of drainage improvements together with appurtenances and appurtenant work, acquisition of real property, if necessary, and incidental expenses within the Assessment District No. 86-2. Financing was provided by the sale of limited obligation bonds under the Improvement Bond Act of 1915 Assessment District 89-1 Fund Established to account for the receipt and disbursement of funds used in the construction within the 1 Assessment District 89-1. Redevelopment Agency Fund Established to account for financial resources to be used for acquisition or construction of major capital facilities within the Rancho Cucamonga Redevelopment Project Area. Financing is to be ' provided by the Rancho Cucamonga Redevelopment Agency. 1 This page intentionally left blank. 1 CITY OF RANCHO CUCAMONGA Schedule 10 COMBINING BALANCE SHEET ALL CAPITAL PROJECTS FUNDS JUNE 30, 1997 TOTALS Assessment Districts Redevelopment June 30, A S S E T S 82-1 R 84-1 842 86-2 Agency 1 9 9 7 1996 Cash and investments $ 48,625 $ 759,123 $ 33,319 $ 333,731 $ 69,591,320 $ 70,766,118 $ 65,963,881 Investment-lend held for resale - - 8,501,294 8,501,294 10,778,871 Receivables(net of allowance for uncollectible): Taxes - - - - 47,146 47,146 151,401 Accounts - - - 3,872 3,872 324 Interest - - 388,285 388,285 266,615 Loan - - - 12,088,223 12,088,223 9,467,500 Due from other funds - - 3,152,119 3,152,119 43,868 Deposits - - - - 430,500 430,500 532,250 Restricted Cash - - - 790,000 790,000 - Advances to other funds 4,290,000 4,290,000 4,290,000 Total Assets $ 48,625 $ 759,123 $ 33,319 $ 333,731 $ 99,282,759 $100,457,557 $ 91,494,710 LIABILITIES AND FUND BALANCES Liabilities: Accounts payable $ - $ - $ - $ - $ 267,282 $ 267,282 $ 41,117 Deposits - - 3,864 - - 3,864 3,864 Due to other funds 3,267,099 3,267,099 128,525 Total Liabilities 3,864 3,534,381 3,538,245 173,506 Fund Balances: Reserved for encumbrances - - - 4,571,025 4,571,025 67,670 Reserved for advances to other funds - - - - 4,290,000 4,290,000 4,290,000 Reserved for long-term loans - - - 11,485,051 11,485,051 9,467,500 Reserved for land held for resale - - 8,501,294 8,501,294 10,778,871 Unreserved: Designated for continuing projects - - - - 66,701,008 66,701,008 65,450,325 Designated for equipment and vehicles - - - - 200,000 200,000 Undesignated 48,625 759,123 29,455 333,731 1,170,934 1,266,638 Total Fund Balances 48,625 759,123 29,455 333,731 95,748,378 96,919,312 91,321,204 Total Liabilities and Fund Balances $ 48,625 $ 759,123 $ 33,319 $ 333,731 $ 99,282,759 $ 100,457,557 $ 91,494,710 79 CITY OF RANCHO CUCAMONGA Schedule 11 COMBINING STATEMENT OF REVENUES,EXPENDITURES AND CHANGES IN FUND BALANCES ALL CAPITAL PROJECTS FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1997 TOTALS Assessment Districts Redevelopment Year Ended June 30, Revenues: 82-1 R 84-1 84-2 86-2 Agency 1997 1996 Taxes $ - $ $ $ - $ 5,215,670 $ 5,215,670 $ 4,917,269 Use of money and property 5,118 63,937 1,984 19,876 4,838,612 4,929,527 4,512,235 Total Revenues 5,118 63,937 1,984 19,876 10,054,282 10,145,197 9,429,504 Expenditures: Current: General governement - - - 3,855,740 3,855,740 1,893,235 Engineering and public works 184,049 - 2,570 - 186,619 28,752 Public safety - - - 5,161,220 5,161,220 - Capital outlay - - - - 9,479,676 9,479,676 26,589,859 Debt service: Principal - - - 25,778,705 25,778,705 718,239 Interest and fiscal charges 3,359,230 3,359,230 3,210,073 Total Expenditures 184,049 2,570 47,634,571 47,821,190 32,440,158 Excess of Revenues over (under) Expenditures (178,931) 63,937 1,984 17,306 (37,580,289) (37,675,993) (23,010,654) Other Financing Sources(Uses): Operating transfers In - - - 7,562,35 7,562,485 3,105,408 Operating transfers out - - - - Debt proceeds - - - 3,79,415 ) 3,7995 0 ,41 27,117,351) Miscellaneous (928,009) (928,009) 527,078 Total Other Financing Sources(Uses) 43,213,801 43,213,801 29,595,457 Excess of Revenues and Other Sources over(under)Expendi- tures and Other Uses $ (178,931) $ 63,937 $ 1,984 $ 17,306 $ 5,633,512 $ 5,537,808 $ 6,584,803 Fund Balances: Beginning of Fiscal Year $ 227,556 $ 695,186 $ 27,471 $ 316,425 $ 90,054,566 $ 91,321,204 $ 84,736,401 Restatements 60,300 60,300 Beginning of Fiscal Year-as restated 227,556 695,186 27,471 316,425 90,114,866 91,381,504 84,736,401 Excess of Revenues over (under)Expenditures (178,931) 63,937 1,984 17,306 5,633,512 5,537,808 6,584,803 End of Fiscal Year(Schedule 10) $ 48,625 $ 759,123 $ 29,455 $ 3331731 $ 95,748,378 $ 96,919,312 $ 91,321,204 80 _ :- M CITY OF RANCHO CUCAMONGA Schedule 12 Page 1 of 3 COMBINING SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL (BUDGETARY BASIS) ALL CAPITAL PROJECTS FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1997 ASSESSMENT DISTRICT 92-1 R ASSESSMENT DISTRICT 84-1 ASSESSMENT DISTRICT 94.2 Variance- Variance- Variance- Favorable Favorable Favorable Budget Actual (Unfavorable) Budget Actual (Unfavorable) Budget Actual (Unfavorable) Revenues: Taxes $ - $ - $ $ $ - a - s - a a Use of money and property- 6,520 5,118 (1,402) 45,000 63,937 18,937 1,540 1,984 444 Total Revenues 6,520 5,118 (1,402) 45,000 63,937 18,937 1,540 1,984 444 Expenditures: Current: General government - - - - - - - - Engineering and public works 233,730 184,049 49,681 - - - - - Public safety - - - - - - - - Capital outlay - - - - - - - - Debt service: Principal - - - - - - - - - Interest and fiscal charges - - - Total Expenditures 233,730 184,049 49,681 - - Excess of Revenues over (under)Expenditures (227,210) (178,931) 48,279 45,000 63,937 18,937 1,540 1,984 444 Other Financing Sources(Uses): Operating transfers in - - - - - - - - Operating transfers out - - - - - - - - Debt proceeds - - - - - - - - Miscellaneous Total Other Financing Sources(Uses) - - Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(Budgetary Basis) (227,210) (178,931) 48,279 45,000 63,937 18,937 1,540 1,984 444 Adjustments: To adjust for encumbrances - - - - Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP basis) S (227,210) S (178,931) $ 48,279 $ 45,000 $ 63,937 $ 18,937 $ 1,540 $ 1,984 $ 444 Fund Balances: Beginning of Fiscal Year $ 227,556 S 227,556 4 - $ 695,186 $ 695,186 $ - $ 27,471 $ 27,471 $ - Restatements - - - - Beginning of Fiscal Year-as restated 227,556 227,556 695,188 695,186 - 27,471 27,471 End of Fiscal Year $ 346 S 48,625 S 48,279 $ 740,186 $ 759,123 $ 18,937 $ 29,011 S 29,455 $ 444 81 CITY OF RANCHO CUCAMONGA Schedule 12 COMBINING SCHEDULE OF REVENUES, Page 2 013 EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL (BUDGETARY BASIS) ALL CAPITAL PROJECTS FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1997 ASSESSMENT DISTRICT 86-2 REDEVELOPMENT AGENCY Variance- Variance- Favorable Favorable Revenues: Budget Actual (Unfavorable) Budget Actual (Unfavorable) - Taxes § - E § § 8,456,020 S 5,215,670 E (3,240,350) Use of money and property 15,430 19,876 4,446 - 4,838,612 4,838,612 Total Revenues 15,430 19,876 4,446 8,456,020 10,054,282 1,598,262 Expenditures: Current: General government _ _ Engineeringand public works 1,518,950 3,923,188 (2,404,238) P 259,570 2,570 257,000 _ Public safely 2,307,577 5,161,220 Capital outlay 13,444,019 13,983,253 (2,853,843) Debt service: (539,234) Principal - - - 30,784,562 25,778,705 5,005,857 Interest and fiscal charges - 2,715,339 3,359,230 (643,891) Total Expenditures 259,570 2,570 257,000 50,770,447 52,205,596 (1,435,149) Excess of Revenues over (under)Expenditures (244,140) 17,306 261,446 (42,314,427) (42,151,314) 163,113 Other Financing Sources(Uses): Operating transfers in - - - 6,478,845 7,562,485 1,083,640 Operating transfers out - - (7190990) (7190090) 900 Debt proceeds - - - 41,713,905 43,769,415 2,055,510 Miscellaneous - (2,963,993) (928,009) 2,035,984 Total Other Financing Sources(Uses) - 38,037,76743,213,801 5,176,034 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(Budgetary Basis) (244,140) 17,306 261,446 (4,276,660) 1,062,487 5,339,147 Adjustments: To adjust for encumbrances 4,571,025 4,571,025 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP basis) E (244,140) E 17,306 § 261,446 E (4,276,660) § 5,633,512 E 9,910,172 Fund Balances: Beginning of Fiscal Year E 316,425 E 316,425 E - E 90,054,566 E 90,054,568 S Restatements - - 60,300 60.300 Beginning of Fiscal Year-as restated 316,425 316,425 90,054,566 90114 866 60,300 End of Fiscal Year § 72,285 E 333,731 § 261,446 § 85,777,906 E 95,748,378 E 9,970,472 82 r r r � r � � r r r r � r �r is r r ■r r� CITY OF RANCHO CUCAMONGA Schedule 12 Page 3 of 3 COMBINING SCHEDULE OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET AND ACTUAL(BUDGETARY BASIS) ALL CAPITAL PROJECTS FUNDS FOR THE FISCAL YEAR ENDED JUNE 30,1997 T O T A L S-Year Ended June 30, 1997 1996 Variance- Favorable Budget Actual (Unfavorable) Actual Revenues: Taxes $ 8,456,020 $ 5,215,670 $ (3,240,350) $ 4,917,269 Use of money and property 68,490 4,929,527 4,061,037 4,512,235 Total Revenues 8,524,510 10,145,197 1,620,687 9,429,504 Expenditures: Current: General government 1,518,950 3,923,188 (2,404,238) 1,837,530 Engineering and public works 493,300 186,619 306,681 28,752 Public safety 2,307,577 5,161,220 (2,853,643) 55,705 Capital outlay 13,444,019 13,903,253 (539,234) 26.657,729 Debt service: Principal 30,784,562 25,778,705 5,005,857 718,239 Interest and fiscal charges 2,715,339 3,359,230 (643,891) 3,210,073 Total Expenditures 51,263,747 52,392,215 (1,128,468) 32,508,028 Excess of Revenues over (under)Expenditures (42,739,237) (42,247,018) 492,219 (23,078,524) Other Financing Sources(Uses): Operating transfers in 6,478.845 7,562,485 1,083,640 3,105,408 Operating transfers out (7.190,990) (7,190,090) 900 (1.154.380) Debt proceeds 41,713,905 43,769,415 2,055,510 27,117,351 Miscellaneous (2,963,993) (928,009) 2,035,984 527,078 Total Other Financing Sources(Uses) 38,037,767 43,213,801 5,176,034 29.595,457 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(Budgetary Basis) (4,701,470) 966,783 5,668,253 6,516,933 Adjustments: To adjust for encumbrances 4,571,025 4,571,025 67,870 Excess of Revenues and Other Sources over(under)Expenditures and Other Uses(GAAP basis) $ (4,701,470) S 5,537,808 S 10,239,278 $ 6,584,803 Fund Balances: Beginning of Fiscal Year $ 91,321,204 $ 91,321,204 S - $ 84,736,401 Restatements - 60,300 60,300 - Beginning of Fiscal Year-as restated 91,321,204 91,381,504 60,300 1,234,222 End of Fiscal Year S 86,619,734 $ 96,919,312 S 10,299,578 $ 91,321,204 83 1 This page intentionally left blank. , _ zt- w � zQ � crawly > - Uw U- z0U) This page intentionally left blank. , CITY OF RANCHO CUCAMONGA Schedule 13 COMBINED BALANCE SHEET INTERNAL SERVICE FUNDS JUNE 30, 1997 Data Processing TOTALS Vehicle Equip./Technology June 30, A S S E T S Replacement Replacement 1997 1996 Cash and investments $ 9,816,343 $ 3,750,000 $ 13,566,343 $ 7,185,599 Fixed assets-net book value 1,216,168 1,216,168 528,828 Total Assets $ 11,032,511 $ 3,750,000 $ 14,782,511 $ 7,714,427 LIABILITIES AND FUND EQUITY Liabilities: Accounts payable $ 329,141 $ $ 329,141 $ 149,159 Total Liabilities 329,141 329,141 149,159 Fund Equity: Contributed capital - 3,750,000 3,750,000 - Reteined earnings: Reserved for vehicle replacement 10,703,370 10,703,370 7,565,268 Unreserved Total Fund Equity 10,703,370 3,750,000 14,453,370 7,565,268 Total Liabilities and Fund Equity $ 11,032,511 $ 3,750,000 $ 14,782,511 $ 7,714,427 84 CITY OF RANCHO CUCAMONGA Schedule 14 COMBINING STATEMENT OF REVENUES,EXPENSES AND CHANGES IN RETAINED EARNINGS INTERNAL SERVICE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1997 Data Processing TOTALS Vehicle Equip./Technology Year ended June 30 Operating Revenues: Replacement Replacement 1 9 9 7 1996 Charges for services $ 194,530 Charges for services $ $ 194,530 $ 326,620 Total Operating Revenues 194,530 194,530 326,620 Operating Expenses: Vehicle and equipment maintenance 921,194 - 921,194 5,413 Depreciation 129,714 129,714 70,471 Total Operating Expenses 1,050,908 1,050,908 75.884 Operating Income(Loss) (856,378) (856,378) 250,736 Nonoperating Revenues: Interest income 506,805 506,805 413,833 Total Nonoperating Revenues 506,805 506,605 413,833 Net Income(Loss)Before Operating Transfers (349,573) (349,573) 664,569 Operating transfers In 2,670,621 2,670,621 Net Income(Loss) $ 2,321,048 $ $ 2,321,048 $ 664,569 Retained Earnings: Beginning of Fiscal Year•as previously reported $ 7,565,268 $ - $ 7,565,268 $ 6,400,699 Restatement for increase in fixed assets valuation 817,054 817,054 Beginning of Fiscal Year-as restated 8,382,322 - 8,382,322 6,400,699 Net Income 2,321,048 2,321,048 664,569 End of Fiscal Year $10,703,370 $ $ 10,703,370 $ 7,065,268 85 CITY OF RANCHO CUCAMONGA Schedule 15 COMBINING STATEMENT OF CASH FLOWS INTERNAL SERVICE FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1997 Data processing TOTALS Vehicle Equip./Technology Year ended June 30, Replacement Replacement 1997 1 9 9 6 Cash Flows from Operating Activitles: Operating Income $ (856,378) $ $ (856,378) $ 250,736 Adjustment to reconcile Operating Income to Net Cash: Depreciation 129,714 - 129,714 70,471 Adjustment to beginning retained earnings 817,054 - 817,054 - Changes in Assets and Liabilities: (Increase)decrease in due from other funds - - - 15,000 Increase(decrease) in accounts payable 179,982 179,982 149,159 Total Adjustments 1,126,750 1,126,750 234,630 Net Cash Provided(Used)by Operating Activities 270,372 270,372 485,366 Cash Flows from Noncapltal Financing Activities: Operating transfers in 2,670,621 - 2,670,621 500,000 Contirbuted capital 3,750,000 3,750,000 Net Cash Provided(Used) by Noncaphal Financing Activities 2,670,621 3,750,000 6,420,621 500,000 Cash Flows from Capital and Related Financing Activities: Acquisition of fixed assets (817,054) (817,054) (295,718) Net Cash Provided(Used)by Capital and Related Financing Activities (817,054) (817,054) (295,718) Cash Flows from Investing Activities: Interest on investments 506,805 506,805 413,833 Net Cash Provided(Used) by Investing Activities 506,805 506,805 413,833 Net increase(Decrease) in Cash and Investments 2,630,744 3,750,000 6,380,744 1,103,481 Cash and Investments at Beginning of Year 7,185,599 7,185,599 6,082,118 Cash and Investments at End of Year $ 9,816,343 $ 3,750,000 $ 13,566,343 $ 7,185,599 SCHEDULE OF NONCASH TRANSACTIONS There were no non-cash transactions during the fiscal year. 86 . 1 1 i 1 This page intentionally left blank. ' 1 1 1 1 1 1 IL :DZM This page intentionally left blank. , AGENCY FUNDS Special Deposits Fund Established to account for all deposits held by the City in its fiduciary capacity. ' Deferred Compensation Fund Established to account for employee-deferred earnings restricted to be paid at a later date to said ' employee upon termination or retirement from the City of Rancho Cucamonga. Assessment District 82-1R Fund ' Established to account for assessments received under the Refunding Act of 1984 for 1915 ' Improvement Act Bonds. Assessments received are restricted for payment of principal, interest,and penalties thereon, upon presentation of proper coupons. Community Facilities District 84-111 Fund Established to account for assessments received under the Mello-Roos Community Facilities Act ' of 1982. Assessments received are restricted for payment of principal, interest, and penalties thereon, upon presentation of proper coupons. ' Assessment District 84-2 Fund Established to account for assessments received under the Improvement Bond Act of 1915. ' Assessments received are restricted for payment of principal, interest, and penalties thereon, upon presentation of proper coupons. Assessment District 86-2 Fund ' Established to account for assessments received under the Improvement Bond Act of 1915. Assessments received are restricted for payment of principal, interest, and penalties thereon, upon presentation of proper coupons. Assessment District 85-PDR Fund ' Established to account for assessments received under the Refunding Act of 1984 for 1915 Improvement Act Bonds and Landscape/Lighting Act of 1972. Assessments received are restricted for payment of principal, interest, and penalties thereon, upon presentation of proper coupons. Community Facilities District No. 88-2 Fund , Established to account for assessments received under the Mello-Roos Community Facilities Act ' of 1982. Assessments received are restricted for payment of principal, interest and penalties thereon, upon presentation of proper coupons. , Assessment District 89-1 Fund Established to account for assessment received under the Improvement Bond Act of 1915. ' Assessments received are restricted for payment of principal, interest, and penalties thereon, upon presentation of proper coupons. ' Community Facilities District No. 93-3 Fund Established to account for assessments received under the Mello-Roos Community Facilities Act ' of 1982. Assessments received are restricted for payment of principal,interest and penalties thereon, ' upon presentation of proper coupons. 1 CITY OF RANCHO CUCAMONGA Schedule 16 Pagel of 2 COMBINING BALANCE SHEET ALL AGENCY FUNDS JUNE 30, 1997 Assessment Assessment Assessment Assessment Assessment Assessment Assessment Special Deferred District District District District District District District A S S E T S Deposits Compensallon 82-1 R 84.1 84-2 86-2 85-PD 88-2 89.1 Cash and investments $ - $ - $ 1,719,513 $ 932,040 $ 314,090 $ 574,434 $ 2,450,939 $ 3,167,319 $ 1,058,092 Cash and Investments with trustee - 5,422,471 - - - - - - Restricted cash 7,663,968 - _ - _ Receivables(net of allowance for uncollectibles): Accounts 20,365, - - - - 8,034 - - Interest - _ _ _ _ - 16,851 Taxes 8,759 3,406 20,378 45,367 1,665 Total Assets $ 7,684,333 $ 5,422,471 $ 1,719,513 $ 940,799 $ 317,496 $ 594,812 $ 2,504,340 $ 3,166,984 $ 1,074,943 LIABILITIES AND FUND BALANCES Liabilities: Accounts payable $ 67,810 $ - $ - $ - $ $ - $ 97,335 $ $ 3,000 Accrued payroll payable - - - - - - 5,651 - - Deposits 7,614,669 Due to Redevelopment Agency 1,854 Deferred compensation payable - 5,422,471 Bond indenture reserve requirements - - 476,900 - 171,679 205,934 125,000 - 478,067 Payable to trustee 1,242,613 940,799 145,817 388,878 2,276,354 3,168,984 593,676 Total Liabilities $ 7,684,333 $ 5,422,471 $ 1,719,513 $ 940,799 $ 317,496 $ 594,812 $ 2,504,340 $ 3,168,984 $ 1,074,943 87 CITY OF RANCHO CUCAMONGA Schedule 16 COMBINING BALANCE SHEET Page 2 of 2 ALL AGENCY FUNDS JUNE 30, 1997 Assessment Assessment TOTALS District District June 30, A S S E T S 91-2 93.3 1997 1996 Cash and investments $ 25,787 $ 355,399 $ 10,597,613 $ 10,177,064 Cash and investments with trustee - - 5,422,471 4,541,108 Restricted cash - - 7,663,968 7,421,981 Receivables(net of allowance for uncollectibles): Accounts - - 28,399 28,865 Interest - 16,851 22,595 Taxes 324 79,899 47,216 Total Assets $ 26,111 $ 355,399 $ 23,809,201 $ 22,238,829 LIABILITIES AND FUND BALANCES Llabillties: Accounts payable $ - $ - $ 168,145 $ 66,626 Accrued payroll payable - - 5,651 4,923 Deposits - 7,614,669 7,410,037 Due to Redevelopment Agency - 1,854 Deferred compensation payable - - 5,422,471 4,541,108 Bond Indenture reserve requirements - - 1,457,580 1,457,580 Payable to trustee 26,111 355,399 9,138,831 8,758,555 Total Liabilities $ 26,111 $ 355,399 $ 23,809,201 $ 22,238,829 88 CITY OF RANCHO CUCAMONGA Schedule 17 Page 1 of 4 COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES ALL AGENCY FUNDS FOR THE FISCAL YEAR ENDED JUNE 30,1997 Balance Balance July 1,1996 Additions Deletions June 30,1997 SPECIAL DEPOSITS Assets: Restricted cash $ 7,421,981 $ 1,080,371 $ 838,384 $ 7,663,968 Accounts receivable 20,356 20,365 20,356 20,365 Total Assets $ 7,442,337 $ 1,100,736 $ 858,740 $ 7,684,333 Liabilities: Accounts payable $ 32,300 $ 67,810 $ 32,300 $ 67,810 Deposits 7,410,037 1,032,926 826,440 7,616,523 Total Liabilities $ 7,442,337 $ 1,100,736 $ 858,740 $ 7,684,333 DEFERRED COMPENSATION Assets: Cash and investments $ 4,541,108 $ 1,286,646 $ 405,283 $ 5,422,471 Liabilities: Deterred compensation payable $ 4,541,108 $ 1,286,646 $ 405,283 $ 5,422,471 ASSESSMENT DISTRICT 82-1 R Assets: Cash and investments $ 2,159,543 $ 147,315 $ 587,345 $ 1,719,513 Taxes receivable 2,796 2,796 Total Assets $ 2,162,339 $ 147,315 $ 590,141 $ 1,719,513 Liabilities: Bond indenture reserve requirement $ 476,900 $ $ - $ 476,900 Payable to trustee 1,685,439 147,315 590,141 1,242,613 Total Liabilities $ 2,162,339 $ 147,315 $ 590,141 $ 1,719,513 ASSESSMENT DISTRICT 84-1 Assets: Cash and Investments $ 758,963 $ 1,937,963 $ 1,764,886 $ 932,040 Taxes receivable 4,065 8,759 4,065 8,759 Total Assets $ 763,028 $ 1,946,722 $ 1,768,951 $ 940,799 Liabilities: Payable to trustee $ 763,028 $ 1,946,722 $ 1,768,951 $ 940,799 Total Liabilities $ 763,028 $ 1,946,722 $ 1,768,951 $ 940,799 89 CITY OF RANCHO CUCAMONGA Schedule 17 COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES Page 2 of 4 ALL AGENCY FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1997 Balance Balance July 1,1996 Additions Deletions June 30,1997 ASSESSMENT DISTRICT 84-2 Assets: Cash and investments $ 335,116 $ 200,411 $ 221,437 $ 314,090 Taxes receivable 531 3,406 531 3,406 Total Assets $ 335,647 $ 203,817 $ 221,968 $ 317,496 Liabilities: Bond indenture reserve requirements $ 171,679 $ - $ $ 171,679 Payable to trustee 163,968 203,817 221,968 145,817 Total Liabilities $ 335,647 $ 203,817 $ 221,968 $ 317,496 ASSESSMENT DISTRICT 86-2 Assets: Cash and investments $ 534,683 $ 227,068 $ 187,317 $ 574,434 Taxes receivable 2,221 20,378 2,221 20,378 Total Assets $ 536,904 $ 247,446 $ 189,538 $ 594,812 Liabilities: Bond indenture reserve requirements $ 205,934 $ $ - $ 205,934 Payable to trustee 330,970 247,446 189,538 388,878 Total Liabilities $ 536,904 $ 247,446 $ 189,538 $ 594,812 ASSESSMENT DISTRICT 85-PD Assets: Cash and investments $ 2,132,268 $ 1,990,792 $ 1,672,121 $ 2,450,939 Accounts receivable 8,509 8,034 8,509 8,034 Taxes receivable 36,544 45,367 36,544 45,367 Total Assets $ 2,177,321 $ 2,044,193 $ 1,717,174 $ 2,504,340 Liabilities: Accounts payable $ 34,326 $ 97,335 $ 34,326 $ 97,335 Accrued payroll payable 4,923 5,651 4,923 5,651 Bond indenture reserve requirement 125,000 - - 125,000 Payable to trustee 2,013,072 1,941,207 1,677,925 2,276,354 Total Liabilities $ 2,177,321 $ 2,044,193 $ 1,717,174 $ 2,504,340 90 CITY OF RANCHO CUCAMONGA Schedule 17 COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES Page 3 0}4 ALL AGENCY FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1997 Balance Balance ASSESSMENT DISTRICT 88-2 July 1,1996 Additions Deletions June 30,1997 Assets: Cash and investments $ 2,860,250 $ 620,826 $ 313,757 $ 3,167,319 Interest receivable 6,919 - 6,919 - Taxes receivable 1,059 1,665 1,059 1,665 Total Assets $ 2,868,228 $ 622,491 $ 321,735 $ 3,168,984 Liabilities: Payable to trustee $ 2,868,228 $ 622,491 $ 321,735 $ 3,168,984 $ 2,868,228 $ 622,491 $ 321,735 $ 3,168,984 ASSESSMENT DISTRICT 89-1 Assets: Cash and investments $ 1,066,702 $ 598,993 $ 607,603 $ 1,058,092 Interest receivable 15,676 16,651 15,676 16,851 Total Assets $ 1,082,378 $ 615,844 $ 623,279 $ 1,074,943 Liabilities: Accounts payable $ - $ 3,000 $ - $ 3,000 Bond indenture reserve requirement 478,067 - - 478,067 Payable to trustee 604,311 495,316 505,751 593,876 - Total Liabilities $ 1,082,378 $ 498,316 $ 505,751 $ 1,074,943 ASSESSMENT DISTRICT 91-2 Assets: Cash and investments $ - $ 36,547 $ 10,760 $ 25,787 Taxes receivable 324 324 Total Assets $ $ 36,871 $ 10,760 $ 26,111 Liabilities: Payable to trustee 28,931 2,820 26,111 Total Liabilities $ $ 28,931 $ 2,820 $ 26,111 91 CITY OF RANCHO CUCAMONGA Schedule 17 COMBINING STATEMENT OF CHANGES IN ASSETS AND LIABILITIES Page 4 of 4 ALL AGENCY FUNDS FOR THE FISCAL YEAR ENDED JUNE 30, 1997 Balance Balance ASSESSMENT DISTRICT 93-3 July 1,1996 Additions Deletions June 30,1997 Assets: Cash and investments $ 329,539 $ 445,027 $ 419,167 $ 355,399 Liabilities: Total Assets $ 329,539 $ 445,027 $ 419,167 $ 355,399 Bond indenture reserve requirement $ - $ $ $ Payable to trustee 329,539 445,027 419,167 355,399 Total Liabilities $ 329,539 $ 445,027 $ 419,167 $ 355,399 TOTALS-ALL AGENCY FUNDS Assets: Cash and investments $ 14,718,172 $ 7,491,588 $ 6,189,676 $ 16,020,084 Restricted cash 7,421,981 1 080 371 &38,384 7,663,968 Accounts receivable 28,865 28,399 28,865 28,399 Interest receivable 22,595 16,851 22,595 16,851 Taxes receivable 47,216 79,899 47,216 79,899 Total Assets $ 22,238,829 $ 8,697,108 L_7,126,736 $ 23,809,201 Liabilities: Accounts payable $ 66,626 $ 168,145 $ 66,626 $ 168,145 Accrued payroll payable 4,923 5,651 4,923 5,651 Deposits 7,410,037 1,032,926 826,440 7,616,523 Deferred compensation payable 4,541,108 1,286,646 405,283 5,422,471 Bond indenture reserve requirements 1,945,418 - 1,945,418 Payable to trustee 8,270,717 6,078,272 5,697,996 8,650,993 Total Liabilities $ 22,238,829 $ 8,571,640 $ 7,001,268 $ 23,809,201 92 un � mcncn > Omx - -n rD7DmZm � This page intentionally left blank. , CITY OF RANCHO CUCAMONGA Schedule 18 SCHEDULE OF GENERAL FIXED ASSETS-BY SOURCES JUNE 30, 1997 TOTALS 1997 1996 General Fixed Assets: Land $ 35,315,539 $ 35,315,539 Building improvements 56,424,691 54,948,871 Improvements other than buildings 55,711 55,711 Equipment and vehicles 15,308,556 14,389,335 Furniture and fixtures 3,413,887 3,368,576 Construction in progress 3,544,038 3,544,038 Total General Fixed Assets $114,062,622 $ 111,622,070 Investment in General Fixed Assets Purchased priorto 7/1/95-unclassified $ 64,444,358 $ 64,444,358 General Fund revenues 1,513,680 840,001 Special Revenue Fund revenues 1,573,766 674,195 Capital Project Fund 41,986,894 41,484,713 Fire District 3,988,234 3,886,141 Federal grants 158,408 4,769 State grants 328,543 268,600 Asset Seizure Funds:State/Federal 68,739 19,293 Investment in General Fixed Assets $114,062,622 $ 111,622,070 Note:Information is not available on the funding sources for fixed assets acquired prior to July 1,1995 93 CITY OF RANCHO CUCAMONGA Schedule 19 SCHEDULE OF GENERAL FIXED ASSETS BY FUNCTION AND ACTIVITY JUNE 30, 1997 Improvements Equipment Furniture Building other than and and Function and Activity Land Improvements Buildings Vehicles Fixtures Total General Government: City manager $ $ - $ - $ 19,551 $ 619 $ 20,170 Personnel - - 7,601 2,214 9,815 City clerk - - - 130,504 9,098 139,602 Administrative services 106,000 5,861,243 - 362,715 7,999 6,337,957 Planning - 152,537 Building and safety - 175,990 5,987 334,514 - 151,219 4,266 155,485 General city facilities 2,396,152 18,930,714 - 1,037,083 110,328 22,474,277 Assessment administration 80,879 - 776,343 5,608 862,830 Total 2,502,152 25,025,373 2,661,006 146,119 30,334,650 Public Safety 534,997 37,381 572,378 Engineering and Public Works 460,972 1,472,787 3,533,130 11,273 5,478,162 Community Services 22,137,440 8,310,796 227,526 294,800 30,970,562 Community Redevelopment 10,199,463 20,692,114 55,711 5,302,906 2,924,314 39,174,508 Fire Protection 15,512 923,821 3,048,991 3,988,324 Total General Fixed Assets Allocated to Function $ 35,315,539 $ 56,424,891 $ 55,711 $ 15,308,556 $ 3,413,887 110,518,584 Construction In Progress 3,544,038 Total $ 114,062,622 94 CITY OF RANCHO CUCAMONGA Schedule 20 SCHEDULE OF CHANGES IN GENERAL FIXED ASSETS BY FUNCTION AND ACTIVITY FOR THE FISCAL YEAR ENDED JUNE 30, 1997 Restated Balance Balance Balance Function and ActivityJuly 1,1996 Restatements July 1,1996 Additions Deletions June 30,1997 General Government: City Manager $ 20,170 $ - $ 20,170 $ - $ - $ 20,170 Personnel 9,520 - 9,520 295 9,815 City Clerk 124,722 - 124,722 14,880 - 139,602 Admininstrative Services 6,266,488 6,266,488 71,469 - 6,337,957 Planning 181,977 181,977 152,537 334,514 Building and Safety 149,776 - 149,776 5,709 - 155,485 General City Facilities 22,351,723 - 22,351,723 122,554 22,474,277 Assessment Administration 576,681 576,681 286,149 862,830 Total General Government 29,681,057 - 29,681,057 653,593 - 30,334,650 Public Safety 456,452 456,452 115,926 572,378 Engineering and Public Works 4,721,673 4,721,673 756,489 5,478,162 Community Services 30,660,292 30,660,292 310,270 30,970,562 Community Redevelopment 38,672,417 356,737 39,029,154 502,091 39,174,508 Fire protection 3,886,141 3,886,141 166,168 63,985 3,988,324 Total General Fixed Assets 108,078,032 356,737 108,434,769 2,504,537 63,985 110,518,584 Allocated to Functions Construction In Progress 3,544,038 (356,737) 3,187,301 356,737 356,737 3,544,038 Total $111,622,070 $ $111,622,070 $ 2,861,274 $ 420,722 $114,062,622 95 • ' I 1 This page intentionally left blank. ' 1 1 1 1 1 .1 1 STATISTICAL SECTION y i y f� r A y rr O z This page intentionally left blank. z 0 F U W a U rr F r., Fd' F EXHIBIT I CITY OF RANCHO CUCAMONGA GENERAL GOVERNMENTAL EXPENDITURES BY FUNCTION(1) Last Ten Fiscal Years Fiscal General Public Engineering Community Community Public Safety Debt Capital Year Government Safety Public Works Development Services Fire Protection Service Outlay Total 1987-88 5,496,299 6,855,023 3,988,871 (3) 5,609,291 1,473,798 - 8,545,419 29,425,814 61,394,934 1988-89 (2) 8,531,326 6,117,980 7,769,525 3,717,641 1,228,413 4,763,673 14,566,918 30,394,512 77,089,988 1989-90 11,890,911 6,933,276 7,329,039 6,882,083 1,436,387 5,306,337 60,497,913 28,608,963 128,884,909 1990-91 15,881,940 7,311,306 8,523,472 4,607,309 2,808,115 7,002,548 17,863,697 30,825,105 94,823,492 1991-92 _ 10,973,782 7,401,199 12,556,739 6,903,264 2,322,517 7,462,224 21,407,802 22,177,981 91,205,508 1992-93 12,944,510 7,615,332 7,789,364 6,159,850 1,702,270 7,839,084 15,203,408 24,188,791 83,442,609 1993-94 14,115,388 8,335,701 8,091,353 6,492,001 1,762,601 8,309,526 15,874,075 15,216,092 78,196,737 1994-95 12,374,623 9,053,236 9,076,883 7,165,128 2,700,897 9,080,935 14,117,871 26,231,344 89,800,917 1995-96 8,700,927 9,417,013 8,980,967 6,488,858 3,725,252 8,951,549 19,632,773 31,168,055 97,065,394 1996-97 12,246,831 15,444,149 8,592,843 7,438,880 3,010,203 9,096,377 45,208,420 16,977,819 118,015,522 (1)Includes all governmental fund types-General, Special Revenue, Debt Service and Capital Projects (2) The data presented represents all City activities for which the City Council has oversight responsibilities with the exception of the Rancho Cucamonga Fire District which became a component unit July 1, 1989, and for which only 1988-89 and the subsequent year's data was available. (3) Expenditures for the fiscal year 1987-88 and prior are functionally classified as presented in the financial statements for those years. Expenditures for fiscal year 1987-88 and later are classified differently to show more details as presented in the financial statements. Source: Annual Audit Report 96 EXHIBIT 2 CITY OF RANCHO CUCAMONGA GENERAL GOVERNMENT REVENUE BY SOURCE Last Ten Fiscal Years Fiscal Taxes & Licenses & Inter- Charges for Use of Money Fines & Development Year Assessments Permits governmental Services and Property Forfeitures Fees Other Total 1987-88 21,503,933 2,548,542 5,336,914 3,656,466 5,845,097 256,861 9,245,745 4,210,878 52,604,436 1988-89 27,187,188 2,902,943 8,453,551 4,601,110 8,593,643 264,831 8,828,353 2,413,640 63,245,259 1989-90 33,133,576 1,996,471 10,697,053 4,234,198 8,974,131 308,389 3,922,496 520,326 63,786,640 1990-91 42,126,174 1,628,195 8,293,751 2,197,625 11,237,248 251,271 3,303,543 6,315,718 75,353,525 1991-92 44,534,803 1,357,877 10,087,260 2,292,045 9,214,401 226,686 3,604,792 8,033,974 79,351,838 1992-93 48,385,478 1,455,537 11,041,157 2,066,010 6,899,587 391,130 2,016,608 7,434,652 79,690,159 1993-94 56,651,916 1,586,247 9,629,421 2,067,524 4,883,780 384,110 3,617,971 4,177,113 82,998,082 1994-95 53,359,823 1,613,580 13,662,447 2,123,670 6,847,563 415,196 2,797,661 3,478,201 84,298,141 1995-96 57,537,967 1,593,576 11,179,404 2,745,991 8,472,995 291,189 2,713,750 2,718,267 87,253,139 1996-97 58,717,945 1,795,225 11,596,410 2,976,083 8,965,747 225,728 3,604,000 3,370,338 91,251,476 (1) Includes all governmental fund types-General, Special Revenue, Debt Service and Capital Projects Funds. (2) The data presented above represents all City activities for which the City Council has oversight responsibilities. Source: Annual Audit Report � � � � �■ r � � � til ■� � r � � � � � � EXHIBIT 3 CITY OF RANCHO CUCAMONGA ASSESSED VALUATION OF ALL CITY PROPERTY Last Ten Fiscal Years Fiscal Secured Public Total Unsecured Full Cash Homeowners Net Taxable Year Property Utility Secured Property Total Value Exemption Value 1987-88 3,276,453,488 311,545,190 3,587,998,678 175,043,138 3,763,041,816 3,763,041,816 102,509,009 3,660,532,807 1988-89 3,842,089,811 6,603,300 3,848,693,111 212,624,063 4,061,317,174 4,061,317,174 113,470,203 3,947,846,971 1989-90 4,663,645,245 6,744,546 4,670,389,791 251,517,317 4,921,907,108 4,921,907,108 119,705,841 4,802,201,267 1990-91 5,577,509,385 15,093,655 5,592,603,040 303,321,685 5,895,924,725 5,895,924,725 125,618,428 5,770,306,297 1991-92 6,179,613,149 145,432,065 6,325,045,214 340,718,049 6,665,763,263 6,534,863,263 129,211,480 6,405,651,783 1992-93 6,484,960,928 14,386,749 6,499,347,677 367,738,678 6,867,086,355 6,867,086,355 137,890,350 6,729,196,005 1993-94 6,632,696,532 13,427,461 6,646,123,993 427,437,186 7,073,561,179 7,073,561,179 135,308,108 6,938,253,071 1994-95 6,307,539,741 10,342,631 6,317,882,372 400,383,268 6,718,265,640 6,718,265,640 136,491,999 6,581,773,641 1995-96 6,283,443,239 10,381,440 6,293,824,679 447,181,856 6,741,006,535 6,741,006,535 139,734,804 6,601,271,731 1996-97 6,341,840,800 9,202,780 6,351,043,580 547,386,007 6,898,429,587 6,898,429,587 138,742,488 6,759,687,099 Note: Assessed valuation is based on 100 percent of full market value. New report format for the county of San Bernardino precludes property exemptions category. Source: County of San Bernardino Auditor-Controller 98 EXHIBIT 4 CITY OF RANCHO CUCAMONGA PROPERTY TAX LEVIES AND COLLECTIONS Fiscal Total Tax Total Tax Percent of Levy Year Levy Collection Collected 1987-88 1,280,269 1,383,181 108 1988-89 1,333,498 1,399,699 105 1989-90 1,944,806 2,052,267 106 1990-91 2,282,179 2,446,699 107 1991-92 2,640,644 2,634,740 99 1992-93 2,404,766 2,395,951 99 1993-94 1,779,421 1,860,297 105 1994-95 2,365,012 1,727,482 73 1995-96 2,347,820 1,772,721 76 1996-97 2,356,069 1,655,554 70 Note: The County of San Bernardino does not provide sufficient information to determine what portion of total collections represent delinquent taxes and interest and penalties on those delinquencies. Source: Finance Department, County of San Bernardino - Auditor Controller EXHIBIT 5 CITY OF RANCHO CUCAMONGA DIRECT AND OVERLAPPING PROPERTY TAX RATE J Last Ten Fiscal Years Chino Basin City of Rancho Fiscal Schools County Cucamonga Metropolitan Municipal WD Cucamonga Total Year Tax Rate Tax Rate County W.D. Water Dist. Tax Rate Tax Rate Tax Rate 1987-88 0.0471 1.000 0.0145 0.0164 0.0066 0.0493 1.1339 1988-89 0.0407 1.000 0.0141 0.0110 0.0046 0.0493 1.1197 1989-90 0.0435 1.000 0.0164 0.0121 0.0038 0.0493 1.1251 1990-91 0.0566 1.000 0.0156 0.0097 0.0033 0.0493 1.1345 1991-92 0.0454 1.000 0.0168 0.0089 0.0030 0.0493 1.1234 1992-93 0.0352 1.000 0.0168 0.0089 0.0028 0.0403 1.1040 1993-94 0.0404 1.000 0.0215 0.0089 0.0024 0.0283 1.1015 1994-95 0.0340 1.000 0.0219 0.0089 0.0024 0.0389 1.1061 1995-96 0.0471 1.000 0.0098 0.0089 0.0000 0.0383 1.1041 1996-97 0.0416 1.000 0.0115 0.0089 0.0000 0.0383 1.1003 Assessed valuation of property is stated at 100% of market value. Source: County of San Bernardino Auditor-Controller 100 EXHIBIT 6 CITY OF RANCHO CUCAMONGA SPECIAL ASSESSMENT COLLECTIONS Ratios of Total Outstanding Fiscal Current & Prior Assessments Collections to Current and Year Assessments Due Collected Amount Due Delinquent Assmts 1987-88 3,575,299 3,451,700 96.54 123,599 1988-89 3,304,823 3,216,001 97.31 88,822 1989-90 3,619,774 3,599,088 99.43 20,686 1990-91 3,565,936 3,520,912 98.74 45,024 1991-92 4,341,957 4,270,529 98.35 71,428 1992-93 4,293,316 4,237,963 98.71 55,353 1993-94 5,983,111 5,881,485 98.30 101,626 1994-95 5,938,191 5,884,908 99.10 53,283 1995-96 5,301,182 5,253,966 99.11 47,216 1996-97 5,718,659 5,638,760 98.60 79,899 Source: Finance Division, Resource Center CITY OF RANCHO CUCAMONGA Special Assessment Collections Assmts. Total Collected Assessments 98.6% Assmts. $5,718,659 Outstanding 1.4% FISCAL YEAR 1996/97 r ] 102 EXHIBIT 7 ✓ CITY OF RANCHO CUCAMONGA DIRECT AND OVERLAPPING BONDED DEBT 1296-97 Assessed V lua ion 6,898,429,E DIRECT AND OVERLAPPING BONDED DEBT- % Applicable Debt 6/30/97 San Bernardino Co. General Fund &Pension Obligations 7.495 % $110,701,978 Metropolitan Water District 0.544 3,161,646 Chaffey Community College Dist. Certs. of Participation 18.065 1,394,618 Direct Debt 0.01% Chaffey Jr. Union H.S. Dist.-Certs of Participation 37.802 2,124,472 Alta Loma School District 98.511 7,757,741 Total Gross Debt 5.05% Central School District&Certs. of Participation 96.811 23,273,364 Total Net 5.04% Cucamonga School District-Certs of Participation 38.943 5,960,226 Cucamonga County Water District 88.603 310,111 Cucamonga County Water District, I.D. #5 95.223 1,604,508 Rancho Cucamonga Redevelopment Agency 100.000 147,275,000 Etiwanda School Dist. Community Facilities Dist. #1,#2,#3 100.000 17,175,000 City of Rancho Cucamonga-Certs. of Participation 100.000 740,000 City of Rancho Cucamonga Cmnty. Fac. Dist. #84-1 100.000 19,480,000 City of Rancho Cucamonga 1915 Act Bonds 100.000 7,245,000 Fontana Unified School District & C.O.P. 0.450 374,045 STATE SCHOOL BUILDING AID Upland Unified School District C.O.P. 0.209 18,392 REPAYABLE AS OF 6/30/97 $2,920,965 TOTAL DIRECT&OVERLAPPING BONDED DEBT $348,596,101 Source: California Municipal Statistics, Inc. EXHIBIT 8 CITY OF RANCHO CUCAMONGA Legal Debt Margin (General Obligation Bonds) June 30, 1997 Assessed valuation $6,898,429,587 Debt limit - 15% of assessed valuation $1,034,764,438 Amount of debt applicable to debt limit: Total bonded debt $0 Other debt $0 Less assets in Debt Service Fund available for payment of principal $0 $0 Legal debt margin $1,034,764,438 Source: Finance Department Note: The City has no general bonds outstanding, however, revenue bond indebtedness has been issued by the Rancho Cucamonga Redevelopment Agency. See Direct & Overlapping Bonded Debt for information on these bonds. 104 EXHIBIT 9 CITY OF RANCHO CUCAMONGA BUILDING PERMITS Number Of Permits Issued 1987-88 1988-89 1989-90 1990-91 1991-92 1992-93 1993-94 1994-95 1995-96 1996-97 July 1,425 1,232 428 418 278 326 238 300 237 249 August 1,769 1,751 459 327 262 230 344 288 232 198 September 1,547 1,373 351 192 248 245 305 242 225 245 October 1,084 1,941 512 328 284 268 222 191 321 226 November 837 1,470 358 274 200 255 283 270 191 218 December 848 1,068 268 303 195 223 237 170 158 215 January 973 1,448 337 228 171 182 264 131 249 327 February 1,246 1,167 359 317 243 149 281 257 185 341 March 1,820 1,689 410 257 295 298 442 196 209 363 April 1,225 1,649 396 335 231 315 201 214 226 431 May 1,708 1,927 372 313 274 262 307 307 250 256 June 1,981 1,964 408 312 365 385 348 280 218 267 TOTAL 16,463 18,679 4,658 3,604 3,046 3,138 3,472 2,846 2,701 3,336 CITY OF RANCHO CUCAMONGA Building Permits Thousands 20 - 15 - 10 - 5 - 0 ---- - -r 1 T---__-- 1987-88 88-89 89-90 90-91 91-92 92-93 93-94 94-95 95-96 1996-97 Fiscal Year No.Of Permits Issuedl 106 EXHIBIT 10 CITY OF RANCHO CUCAMONGA CONSTRUCTION ACTIVITY BUILDING PERMIT VALUATION 1987-88 1988-89 1989-90 1990-91 1991-92 1992-93 1993-94 1994-95 1995-% 1996-97 July $26,616,322 $19,353,555 $10,089,602 $23,599,548 $2,918,819 $11,119,619 $2,309,314 $9,862,766 $12,331,995 10,582,570 August 42,574,167 30,200,101 23,460,230 14,593,530 2,505,876 3,640,314 6,934,763 10,295,238 8,658,100 8,625,913 September 31,918,086 24,268,160 22,479,041 2,350,284 4,577,135 5,611,615 6,012,384 10,610,641 7,539,020 22,895,860 October 20,870,494 48,782,828 23,647,235 7,727,450 6,382,558 3,630,620 4,005,140 14,552,820 10,501,190 6,482,329 November 24,547,794 17,614,217 11,332,216 5,654,369 2,436,103 7,572,750 7,615,600 15,978,747 - 3,606,830 9,254,752 December 12,117,584 16,056,186 10,147,202 23,805,734 7,140,379 2,843,800 2,346,730 7,157,443 6,256,792 8,554,638 January 17,568,702 24,774,598 15,816,216 10,283,180 8,374,060 8,407,509 12,343,088 1,717,165 15,045,410 14,583,794 February 31,608,519 38,792,235 23,738,389 7,041,748 5,401,851 1,899,579 12,671,962 17,497,339 11,201,194 17,929,883 March 43,663,631 47,229,360 16,484,505 13,445,250 5,561,660 8,499,799 14,063,158 2,101,199 11,932,433 3,779,101 April 10,056,772 35,861,166 9,156,809 6,593,123 4,686,138 11,459,265 5,158,210 8,054,910 11,378,975 9,841,932 May 32,375,301 34,206,959 9,498,383 3,910,268 5,137,236 5,231,474 17,243,990 9,403,612 15,468,092 8,397,938 June 56,408,374 60,298,893 22,989,440 7,689,607 18,714,994 15,177,110 12,007,333 10,546,284 6,074,237 17,116,665 TOTAL 350,325,746 397,438,258 198,839,268 126,694,091 73,836,809 85,093,454 102,711,672 117,778,164 119,994,268 138,045,375 Source: Building and Safety Division CITY OF RANCHO CUCAMONGA Construction Activity Millions $500 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $400 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - $300 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- 11 - - - - - - - - - - - - - - - - - - - $200 $100 $0 1987-88 88-89 89-90 90-91 91-92 92-93 93-94 94-95 95-96 1996-97 Fiscal Year Lin iV—al u—e0 fPermits 108 EXHIBIT 11 CITY OF RANCHO CUCAMONGA DEMOGRAPHIC STATISTICS Average Annual San Bernardino City Population City Population County as Percent Year Population Percent Changes Population of County 1988 94,614 17.9% 1,202,695 7.9% 1989 104,727 10.7% 1,286,210 8.1% 1990 104,887 (1) 0.2% 1,423,800 7.4% 1991 105,100 (2) 0.2% 1,464,700 7.2% 1992 109,800 4.5% 1,508,700 7.3% 1993 111,500 1.5% 1,539,600 7.2% 1994 112,700 1.1% 1,559,100 7.2% 1995 114,600 1.7% 1,572,700 7.3% 1996 115,900 1.1% 1,589,500 7.3% 1997 116,045 0.1% 1,587,387 7.3% Source: (1) U.s. Bureau of Census, California Department of Finance (2) In May, 1996 the California State Controller's Office (Demographic Research Unit) recalibrated the population count statewide retroactive to April 1990. That recalibrated count is reflected above. DEMOGRAPHIC STATISTICS DEMOGRAPHIC STATISTICS City Of Rancho Cucamonga County Of San Bernardino Thoumntls Thousands 410 1510 310 1010 210 510 110 -sp 10 1—r 10 r—r —f- 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 ®CIN POPULATION OCOUNTV POPULATION 110 EXHIBIT 12 CITY OF RANCHO CUCAMONGA PRINCIPAL TAXPAYERS-(1) June 30, 1997 TOP 25 PRODUCERS Albertsons Ameron Astro Office Products Best Buy Chilis Grill & Bar Circle K Circuit City Claim Jumper Home Depot Mervyns Mobil Oil Montgomery Ward Office Depot Price Company Proficient Food Company RecotInc S W School Supply Sehulster Tunnels Pre Con Service Merchandise Stater Bros. Tamco Target United Industries Inc Vons Wal Mart (1) Based on sales tax revenues, listed alphabetically. Source: State Board of Equalization EXHIBIT 13 CITY OF RANCHO CUCAMONGA PURCHASED INSURANCE POLICIES Coverage Maximum Coverage Comvanv Remarks Auto Insurance $250,000 PARSAC One year policy - Expires 5/98 SFC 008585 $29,249 annual premium Boiler& Machinery Policy $9,500,000 Hartford Steam Boiler One year policy - Expires 10/26/97 BMI-LA-9934845 $9,071 annual premium Crime Policy $100,000 Hartford Fire Insurance One year policy - Expires 7/1/97 Employee Surety PEB AO3609 $2,027 annual premium Equipment Insurance $250,000 PARSAC One year policy - Expires 5/98 premium included in auto coverage Liability Insurance $5,000,000 PARSAC One year policy - Expires 7/1/97 $354,862 annual premium Notary Bond $10,000 Western Surety Company Effective 12/17/93 $50.00 annual premium Excess Liability $5,000,000 PARSAC One year policy - Expires 7/1/97 $46,569 annual premium Property Insurance $250,000 PARSAC One year policy - Expires 5/98 premium included in auto coverage Special Events $2,000,000 CNA Insurance Company One year policy $1,000 one time premium Workers Compensation $10,000,000 PARSAC One year policy - Expires 7/1/97 $91,682 annual premium Excess Workers' Comp $10,000,000 PARSAC One year policy - Expires 7/1/97 $109,155 annual premium Source: Risk Management Division 112 EXHIBIT 14 CITY OF RANCHO CUCAMONGA MISCELLANEOUS STATISTICAL INFORMATION Date of Incorporation Nov. 22, 1977 Type of City General Law Form of Government Council Manager Area 37.5 Square Miles Population 116,045 Number of Street Lights 9,378 Miles of Streets 486 Number of Signals 110 Fire Protection: Rancho Cucamonga Fire District Number of Stations 5 Number of Firefighters &Officers 67 Police Protection: Contracted with San Bernardino Co. Number of Stations I Number of Sworn Officers 86 Recreation and Culture: Number of Parks 20 with 236 acres Source: City Of Rancho Cucamonga - Various Departments ■� M M �■ viii �■ �■