Loading...
HomeMy WebLinkAboutACFR 1987 MOORPARK et*,"4; ANNUAL FINANCIAL REPORT Year Ended June 30, 1987 MOORPARK ANNUAL FINANCIAL REPORT June 30, 1987 TABLE OF CONTENTS Page Report of Certified Public Accountants 1 General Purpose Financial Statements at June 30, 1987 and for the year then ended: Combined Balance Sheet - All Fund Types and Account Group 2 Combined Statement of Revenues, Expenditures and Changee in Fund Balances - All Governmental Fund Types 3 Combined Statement of Revenues and Expenditures - Budget and Actual - General and Special Revenue Funds 4 Notes to Combined Financial Statement• 5 Schedule Additional Financial Information at June 30, 1987 and for the year then ended: Special Revenue Funds: Combining Balance Sheet 1 10 Combining Statement of Revenues, Expenditures and Changes in Fund Balances 2 13 Combining Statement of Revenues and Expenditures - Budget and Actual 3 16 General Property and Equipment Account Group: Statement of General Property and Equipment Account Group 4 22 A MEMBER OF ARTHUR YOUNG INTERNATIONAL 515 South Flower Street Arthur Young Los Angeles,California 90071 Telephone:(213)977-3200 Honorable City Council Moorpark, California No have examined the combined financial statements of Moorpark at June 30, 1987 and for the year then ended, as listed in the accompanying table of contents. Our examination was made in accordance with generally accepted auditing standards and, accordingly, included such tests of the accounting records and such other auditing procedures as we considered necessary in the circumstances. Moorpark has not obtained appraised values for certain real property and park land transferred from the County of Ventura and received from developers. Accordingly, such property has not been recorded in the General Property and Equipment Account Group in the accompanying combined balance sheet. This departure from generally accepted accounting principles does not have a material effect on the results of operations of Moorpark for the year ended June 30, 1987. In our opinion, the combined statements mentioned above present fairly the combined results of operations of Moorpark for the year ended June 30, 1987 and, except for the effects on the combined balance sheet of not recording certain real property as discussed in the preceding paragraph, the combined financial position of Moorpark at June 30, 1987, in conformity with generally accepted accounting principles applied on a basis consistent with that of the preceding year. Our examination was made for the purpose of forming an opinion on the basic combined financial statements taken as a whole. The combining and individual fund and account group financial statements listed as additional financial information in the table of contents are presented for purposes of additional analysis and are not a required part of the basic combined financial statements of Moorpark. Such additional financial information has been subjected to the auditing procedures applied in our examination of the combined financial statements and, in our opinion, except for the effects of not recording certain real property as discussed in the second preceding paragraph, is fairly stated in all material respects in relation to the combined financial statements taken as a whole. 4"7214.1°).1"r--4ekr March 25, 1988 1. • MOORPARK COMBINED BALANCE SHEET ALL FUND TYPES AND ACCOUNT GROUP June 30, 1987 Fiduciary Governmental Fund Types Fund Type Capital project funds General Special City Hall Equipment Property and General revenue Building Replacement Equipment Totals (memorandum only) ASSETS Fund funds Fund Fund Agency Fund Account Group June 30, 1987 June 30, 1986 Cash, including short-term interest- bearing investments of $16,731,141 ($9,953,541 at June 30, 1986) (Note 3) $1,534,023 $13,841,762 $516,388 $ 20,000 $1,910,099 $ - $17,822,272 $10,000,685 Accounts and interest receivable 173,177 210,983 4,102 - - - 388,262 533,417 Property and equipment (Note 5)s Community center building - - - - - 690,000 690,000 690,000 Office furniture and equipment - - - - - 106,464 106,464 39,745 Other equipment - - - - - 14,364 14,364 - $1.707.200 $14,052.745 $520,490 $ 20,000 $1,910,099 $810,828 $19,021,362 $11,263,847 LIABILITIES AND FUND EQUITIES Liabilities: Accounts payable and accrued liabilities $ 327,638 $ 958,536 $ 1,454 $ - $ - $ - $ 1,287,628 $ 651,141 Deposits, principally from developers - - - - 1,910,099 - 1,910,099 1,881,519 Deferred revenue - - - - - - - 370,000 Commitments and contingencies (Note 7) Fund equities: Investment in general property and equipment 810,828 810,828 729,745 Fund balances unreserved 1,379,562 13,094,209 519,036 20,000 - - 15,012,807 7,631,442 Total fund balances/equities 1,379,562 13,094,209 519,036 20,000 - 810,828 15,823,635 8,361,187 61.707.200 $14,052,745 $520,490 $ 20,000 $1,910,099 $810.828 $19,021,362 $11,263,847 See accompanying notes to combined financial statements. 2. MOORPARK COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES ALL GOVERNMENTAL FUND TYPES Year ended June 30, 1987 Governmental Fund Types Totals (memorandum only) Capital project funds Special City Hall Equipment General revenue Building Replacement Year ended Year ended Fund funds Fund Fund June 30, 1987 June 30, 1986 Revenues: Property taxes $ 724,220 $ 10,759 $ - $ - $ 734,979 $ 562,664 Sales taxes 489,991 - - - 489,991 391,643 Other taxes 34,728 255,731 - - 290,459 316,778 Motor vehicle license fees 519,512 - - - 519,512 401,690 Utility franchise fees 115,390 - - - 115,390 131,600 Street improvement fees - 4,035,054 - - 4,035,054 543,925 Building and safety fees 1,516,844 - - - 1,516,844 634,009 Planning and public works fees 62,792 - - - 62,792 239,305 Subventions and grants 2,445 781,244 - - 783,689 433,142 Benefit assessments - 236,475 - - 236,475 302,732 Park development fees - 1,903,821 - - 1,903,821 - Charges for current services 9,084 93,906 - - 102,990 199,220 Fines and forfeitures 26,219 96,130 - - 122,349 97,092 Interest 189,200 709,441 40,283 - 938,924 649,486 Miscellaneous - 27,759 - - 27,759 - Total revenues 3,690,425 8,150,320 40,283 - 11,881,028 4,903,286 Expenditures: General government 576,704 17,588 36,167 - 630,459 338,684 Public safety 803,130 52,547 - - 855,677 646,701 Public services 842,200 1,797,970 - - 2,640,170 1,303,243 Parks and recreation 71,157 302,200 - - 373,357 170,470 Total expenditures 2,293,191 2,170,305 36,167 - 4,499,663 2,459,098 Excess of revenues over expenditures 1,397,234 5,980,015 4,116 - 7,381,365 2,444,188 Operating transfers from (to) other funds (1,238,680) 1,151,680 67,000 20,000 - - Excess of revenues and net operating transfers over expenditures 158,554 7,131,695 71,116 20,000 7,381,365 2,444,188 Fund balances, beginning of year 1,221,008 5,962,514 447,920 - 7,631,442 5,187,254 Fund balances, end of year $ 1.379.562 $13,094.209 $519,036 $ 20,000 $15,012,807 $7,631,442 See accompanying notes to combined financial statements. 3. MOORPARK COMBINED STATEMENT OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL (NOTE 2) GENERAL AND SPECIAL REVENUE FUNDS • Year ended June 30, 1987 General Fund Special revenue funds Totals (memorandum only) Variance- Variance- Variance- favorable favorable favorable (unfavor- (unfavor- (unfavor- Budget Actual able) Budget Actual able) Budget Actual able) Revenues: Property taxes $ 472,800 $ 724,220 $ 251,420 $ 2,600 $ 10,759 $ 8,159 $ 475,400 $ 734,979 $ 259,579 Sales taxes 370,000 489,991 119,991 - - - 370,000 489,991 119,991 Other taxes 33,090 34,728 1,638 231,000 255,731 24,731 264,090 290,459 26,369 Motor vehicle license fees 407,400 519,512 112,112 - - - 407,400 519,512 112,112 Utility franchise fees 144,800 115,390 ( 29,410) - - - 144,800 115,390 ( 29,410) Street improvement fees - - - 1,465,500 4,035,054 2,569,554 1,465,500 4,035,054 2,569,554 Building and safety fees 419,400 1,516,844 1,097,444 - - - 419,400 1,516,844 1,097,444 Planning and public works fees 506,500 62,792 (443,708) - - - 506,500 62,792 ( 443,708) Subventions and grants - 2,445 2,445 1,177,388 781,244 ( 396,144) 1,177,388 783,689 ( 393,699) Benefit assessments - - - 245,166 236,475 ( 8,691) 245,166 236,475 ( 8,691) Park development fee• - - 971,500 1,903,821 932,321 971,500 1,903,821 932,321 Charges for current services B00 9,084 8,284 117,900 93,906 ( 23,994) 118,700 102,990 ( 15,710) Fines and forfeitures 2,500 26,219 23,719 58,000 96,130 38,130 60,500 122,349 61,849 Interest 65,000 189,200 124,200 279,500 709,441 429,941 344,500 898,641 554,141 Miscellaneous 200 - ( 200) 13,226 27,759 14,533 13,426 27,759 14,333 Total revenues 2,422,490 3,690,425 1,267,935 4,561,780 8,150,320 3,588,540 6,984,270 11,840,745 4,856,475 Expenditures: General government 547,369 576,704 ( 29,335) 38,000 17,588 20,412 585,369 594,292 ( 8,923) Public safety' 869,607 803,130 66,477 33,900 52,547 ( 18,647) 903,507 855,677 47,830 Public services 938,934 842,200 96,734 2,589,548 1,797,970 791,578 3,528,482 2,640,170 888,312 Park and recreation 65,981 71,157 ( 5,176) 881,775 302,200 579,575 947,756 373,357 574,399 Total expenditures 2,421,891 2,293,191 128,700 3,543,223 2,170,305 1,372,918 5,965,114 4,463,496 1,501,618 Excess of revenues over expenditures 599 1,397,234 1,396,635 1,018,557 5,980,015 4,961,458 1,019,156 7,377,249 6,358,093 Operating transfers from (to) other funds (1,260,723) (1,238,680) 22,043 1,141,117 1,151,680 10,563 ( 119,606) ( 87,000) 32,606 Excess of revenues and net operating transfers over expenditures $(1,260,124) $ 158,554 S 1,418.678 $ 2,159,674 1_1L131,695 $4,972,021 S 899,550 1_2,2224212 j 6,390,699 See accompanying notes to combined financial statements. 4. MOORPARK NOTES TO COMBINED FINANCIAL STATEMENTS June 30, 1987 1. Summary of significant accounting policies Basis of accounting Moorpark (the City) accounts for its financial position and Governmental fund types use a modified accrual basis of operations in accordance with generally accepted accounting prin- accounting. Revenues are recognized when available and measur- ciples applicable to governmental units. Accordingly, the City able. Revenues which are accrued include property taxes, sales uses several funds and an account group described below. taxes collected by the State on behalf of the City prior to year end, interest and certain other taxes. Revenues which are not Fund types and account group considered susceptible to accrual include motor vehicle license A fund or account group is an accounting entity with a self- fees, certain other licenses and fees, fines, forfeitures and balancing set of accounts established to record the financial penalties. Expenditures are recorded when the liability is position and results of operations of a specific governmental incurred. activity. The City maintains the following fund types and account Interfund transactions group: In the course of normal operations, transactions occur among Governmental fund types, which include the General Fund, various City funds. Operating transfers (recurring) are recorded special revenue funds and capital projects funds, are used by the receiving fund as transfers-in and as an addition to fund to record the general operations of the City. balance. Such transfers are recorded by the disbursing fund as Fiduciary fund type (Agency Fund), which is used to account transfers-out and a reduction of fund balance. for assets held by the City as an agent for individuals, organizations and other funds. The Agency fund is custodial Operating transfers during the year ended June 30, 1987 in nature (assets equal liabilities) and does not involve include the following: measurement of operations. Operating transfers to (frau) Special Capital Totals General Property and Equipment Account Group, which is used Gemmel Revenue P uects (ltmno Fund Only ) Fund Funds Gemmel lum to account for property and equipment purchased or received by the governmental fund types. Operating transfers (to) from: The combined financial statements include total columns General fund $ - $1,173,680 S65,000 $ 1,238,680 E0ecial revenue funds (1,173,680) - 22,000 (1,151,680) which aggregate the financial statements of the various fund types Capital projects fund ( 65,000) (22,000) - ( 87,000) and account group. The columns are designated 'memorandum only" $(1,238,680) $1,151,680 $87,000 �_4..M- because the totals are not comparable to a consolidation in that Operating transfers from the General Fund to the special interfund transactions are not eliminated. revenue funds include $1,195,723 to create a community development fund. 5. MOORPARK NOTES TO COMBINED FINANCIAL STATEMENTS June 30, 1987 1. Summary of significant accounting policies (Cont'd.) capitalized as such assets are immovable and generally of value Property taxes only to the City. No depreciation is provided for assets capitalized in the General Property and Equipment Account Group. The duties of ing and collecting property taxes are performed by the Ventura County Assessor and Tax Collector. The During the year ended June 30, 1984, the County of Ventura City receives an allocation of property taxes collected by the transferred certain real property to the City. In addition, the County with respect to property located within the City limits. City has received park land from the County of Ventura and from Tax levies cover the period from July 1 to June 30 of each year. developers. The City has not obtained appraised values for the All tax liens attach annually on the first day in March preceding land element of this real property or the park land; accordingly, the fiscal year for which the taxes are levied. Taxes are levied it has not been recorded in the General Property and Equipment on both real and personal property as it exists on that date. Account Group. It is the City's intent to obtain appraisals for the land received, as of the transfer dates, and record such Secured property taxes are levied against real property and property in the General Property and Equipment Account Group are due and payable in two equal installments. The first during the year ending June 30, 1988. installment is due on November 1 and becomes delinquent if not paid by December 10. The second installment is due on February 1 Deposits and becomes delinquent if not paid by April 10. Unsecured Deposits principally consist of amounts collected from personal property taxes are due on July 1 each year. These taxes developers for services to be rendered by the City, including become delinquent if not paid by August 31. engineering plan checks and inspections and planning review The City records property tax revenues in the fiscal year to services. The City will recognize the appropriate amounts as which they relate rather than at the related lien date. Delin- revenue when the services are performed and the corresponding quent property taxes at year end (June 30) are reserved to the expenditures are incurred. extent they are deemed to be uncollectible within 60 days thereafter, if any. 2. Budgetary information Property and equipment The City Council adopts a formal budget at the beginning of the City's fiscal year providing for operations and capital Acquisitions of property and equipment are recorded as expenditures of the City's General Fund and special revenue expenditures in governmental fund types at the time of purchase. funds. Budgetary controls and the levying of taxes are set by the These assets, when over S500 each, are capitalized at coat in the City Council within state limitations. The legally adopted budget General Property and Equipment Account Group. Expenditures for requires that expenditures not exceed appropriations in total for infrastructure (roads, curbs, sidewalks, etc.) normally are not each fund. The budgetary basis of accounting is consistent with 6. MOORPARK NOTES TO COMBINED FINANCIAL STATEMENTS June 30, 1987 2. Budgetary information (Cont'd.) 3. Cash and investments (Cont'd.) generally accepted accounting principles applicable to the City's Investments policy financial statements. The City invests its temporary pooled idle cash and The Council is authorized to make and has made appropriation investments in instruments which are allowable under current adjustments to the budget during the year as deemed necessary. legislation of the State of California (Government Code Section Such adjustments are included in the budget amounts in the accom- 53600 et seq.). panying combined financial statements. Appropriations lapse at The State Code permits investments in the following year end. instruments: For the year ended June 30, 1987 actual expenditures o Securities of the U.B. Government or its agencies exceeded budgeted amounts for the following funds: o Small business administration loans Fund Amount o Certificates of deposit (or time deposits) placed with Local transportation - Streets $154,798 (j./}S /7#1l commercial banks and/or savings and loan companies Local transportation - Transit 19,544G.Ai >�x 4 ° Negotiable certificates of deposit Tierra Rejada/Moorpark Road AOC 128,646JNAMS o Bankers' acceptances Office of Traffic Safety 19,407 A7in/in% C-AAarAP/IWJR.° Commercial paper o Local Agency Investment Fund (State pool) 3. Cash and investments Repurchase agreements Cash and investments of the City are pooled for deposit and o Passbook savings accounts investment purposes. Interest earned on pooled investments is o Reverse repurchase agreements credited to the funds based on each funds' average deposit bal- ance. At June 30, 1987, the total cash and investments balance 4. Retirement plan comprised the followings Substantially all City employees are members of the Public Carrying amount Employees' Retirement System (PERS), a multiemployer retirement Cash in banks - insured by FDIC $ 1,302,040 plan administered by the State of California. Contributions are Cash in Danks - uncollaterallzed (including made to PERS by both the City and its employees. The City's gross $10,200,000 collateralized with securities contribution to PERS for the year ended June 30, 1987 was $21,405 held by an agent but not in the City's name) 11,520,232 ($31,235 in 1986) and was based upon 6.30% (8.68% in 1986) of Investments in State Treasurer's Local Agency Investment Fund 5,000,000 regular base payroll of covered employees, as specified by PERS. $17.822,272 7. MOORPARK NOTES TO COMBINED FINANCIAL STATEMENTS June 30, 1987 4. Retirement plan (Cont'd.) 6. Deficit fund balances It is the City's policy to fund current retirement costs as The following special revenue funds have deficit equity accrued. Based on current contribution rates, all unfunded balances at June 30, 1987 in the amounts indicated: actuarial liabilities will be funded by 2011. PERS does not com- , Park Maintenance Fund $1,967ClEttc2 Ly pute separate values of vested and nonvested benefits. Therefore, Transportation Development Act (Article 3) Fund 7,623)e/; ;1g./ the accumulated plan benefit information presented includes both The deficits are expected to be eliminated in the following the vested and nonveated portions. A comparison of the City's year through operating transfers and funds to be received from approximate portion of accumulated plan benefits and plan net State sources. assets based on the most current information provided by PERS (July 1, 1986) is presented below (unaudited): 7. Commitments and contingencies Actuarial liability for accumulated Commitments plan benefits $371,124 Net assets available for benefits $ 70.545 The City has contracted with the County of Ventura for The assumed rate of return used in determining the actuarial various services, principally law enforcement. These contracts present value of accumulated plan benefits was 8.5% for the July are cancellable by the City or the County on May 31 of each year 1, 1986 valuation. after thirty days' notice has been given, and are renegotiated annually. The aggregate contractual commitments total 5. General property and equipment approximately $1,042,000 for the year ending June 30, 1988. A summary of changes in the General Property and Equipment Contingencies Account Group for the year ended June 30, 1987 follows: There are certain legal actions pending against the City Balance, Balance, which management considers incident to normal operations, some of June 30, June 30, which seek substantial monetary damages. In the opinion of 1986 Additions Disposals 1987 management, after consultation with counsel, the ultimate Community center resolution of such actions is not expected to have a significant building $690,000 $ - $ - $690,000 effect on the financial position or the results of operations of Office furniture the City. and equipment 39,745 66,719 - 106,464 Other equipment - 14,364 - 14,364 $729.745 $ I1.083 $ - $810,828 8. MOORPARK NOTES TO COMBINED FINANCIAL STATEMENTS June 30, 1987 8. Single family residential mortgage revenue bond program National Bank. Dal Ichi Kangyo Bank of California serves as the The City sponsored a revenue bond program during the year Trustee for these bonds. ended June 30, 1985 under which $20,000,000 of Single Family The bonds described above are not indebtedness of the City, Residential Mortgage Revenue Bonds were issued. The single family and there exists no legal or moral obligation on the part of the mortgage program ie designed to provide funds to acquire mortgage City to make payments on such bonds from any source other than the loans on single family residences located in the City. These revenues and assets pledged therefor. The programs are completely bonds are secured by a pledge of all loans receivable advanced administered by the Trustees without any involvement by the from the bond proceeds by the Trustee, First Interstate Bank of City. Accordingly, these programs and the bonds issued thereunder California, and are serviced from payments on the loans to the have been excluded from the accompanying combined financial Trustee. statements. The City sponsored a revenue bond program during the year ended June 30, 1986, under which $22,600,000 of Multi-Family 9. Subsequent event Housing Revenue Bonds were issued. The program is designed to The City signed a contract with an independent party for the assist in making low and moderate coat rental housing available in construction of a City Hall in December 1987. The amount of the the City. The City is guaranteed that 100 of the units of the contract is $463,625. project financed with the bonds are made available to persons and families with incomes not exceeding 80% of the County median income and another 10% of the units for persons and families with income not exceeding 50% of the County median income. The units are available under this program for a thirty-year period. These bonds are secured by a letter of credit issued by Citibank, N.A., dated December 23, 1985. The program is administered by the Trustee, Security Pacific National Bank. The City Council, serving as the Industrial Development Authority of the City of Moorpark, issued $9,300,000 of Industrial Revenue Bonds during the year ended June 30, 1986. The bonds were issued to finance the development and construction of manufactur- ing facilities for the Kavlico Corporation. These bonds are secured by a stand-by letter of credit issued by Security Pacific 9. ADDITIONAL INFORMATION Schedule 1 Page 1 of 3 MOORPARK COMBINING BALANCE SHEET ALL SPECIAL REVENUE FUNDS June 30, 1987 Federal Local State Transportation Local Traffic Revenue Park Transportation - Transit Development Transportation Safety State Gas Sharing Development Streets Assistance Act (Article 3) Transit Fund Tax Fund Fund Fund Fund Fund Fund Fund ASSETS Cash in City treasury $229,265 $792.261 $ - $3,020,173 $( 591) $59,410 $(7,623) $ 24,967 Accounts and interest receivable 7,232 26,568 - 17,146 591 253 - 119 $236.497 $818.829 $ - $3.037.321 1-----_ $59,663 $(7,623) $ 25.086 LIABILITIES AND FUND BALANCES Liabilities, Accounts payable and accrued liabilities $ 19,664 $156,078 $ - S 26,432 $ - $ 6,391 $ - $ 7,223 Deferred revenues - - - - - - - - Total current liabilities 19,664 156,078 - 26,432 - 6,391 - 7,223 Fund balances (deficit) unreserved 216,833 662,751 - 3,010,889 - 53,272 (7,623) 17,863 $236.497 $818,829 $ - $3.037.321 1------= $59.663 $(7,623) $ 25.086 10. Schedule 1 Page 2 of 3 MOORPARK COMBINING BALANCE SHEET ALL SPECIAL REVENUE FUNDS June 30, 1987 Community Tierra Police Development Rejada/ Los Casey/ and Fire Block Grants Street Park Moorpark Angeles Gabbert Facili- to Small Lighting Mainte- Road Avenue Road ties Fee Cities Fund Fund nance Fund AOC Fund AOC Fund AOC Fund Fund A S SET S Cash in City treasury $ 13,151 $220,809 $18,927 $3,175,039 $4,130,198 $ 1,811 $637,457 Accounts and interest receivable 88,149 - - 18,756 27,157 158 - $101,300 $220,809 $18.927 $3,193,795 $4,157,355 $ 1,969 $637,457 LIABILITIES AND FUND BALANCES Liabilities, Accounts payable and accrued liabilities $ 6,231 $ 26,774 $20,894 $ 1,990 $ 17,322 $ - $637,457 Deferred revenues - - - - - - - Total liabilities 6,231 26,774 20,894 1,990 17,322 - 637,457 Fund balances (deficit) unreserved 95,069 194,035 (1,967) 3,191,805 4,140,033 1,969 - $101.300 $220.809 $18,927 $3,193,795 $4,157,3551-Lail635 7,457 11. Schedule 1 Page 3 of 3 MOORPARK COMBINING BALANCE SHEET ALL SPECIAL REVENUE FUNDS June 30, 1987 LOS Totals Angeles Office of Senior Year Year Avenue Community Traffic and Center ended ended Alternate Development Recreation Safety Bond June 30, June 30, Route Fund Fund Fund Grant Fund Act Fund 1987 1986 ASSETS Cash in City treasury $321,936 $1,195,723 $16,984 $(18,135) $10,000 $13,841,762 $6,274,006 Accounts and interest receivable 1,373 - 72 19,407 4,000 210,983 407,094 $323,309 $1.195.723 $17,056, $ 1.272 ;14.000 $14,052,745 $6,681.100 LIABILITIES AND FUND BALANCES Liabilities: Accounts payable and accrued liabilities $ 14,088 $ - $ 4,152 $ 1,272 $12,568 $ 958,536 $ 348,586 Deferred revenues - - - - - - 370,000 Total liabilities 14,088 - 4,152 1,272 12,568 958,536 718,586 Fund balances (deficit) unreserved 309,221 1,195,723 12,904 - 1,432 13,094,209 5,962,511 $323,309 $1.195.723 $17,056 $ 1,272 $14,000 $14,052,745 $6,681,100 12. Schedule 2 Page 1 or-3 MOORPARK COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES ALL SPECIAL REVENUE FUNDS Year ended June 30, 1987 Federal Local State Transportation Local Traffic Revenue Park Transportation - Transit Development Transportation Safety State Gas Sharing Development Streets Assistance Act (Article 3) Transit Fund Tax Fund Fund Fund Fund Fund Fund Fund Revenues, Property taxes $ - $ - $ - $ - $ - 8 - $ - $ - Taxes other than property taxes - 255,731 - - - - - Street improvement fees - - - - - - - - Benefit assessments - - Subventione and grants - - 10,441 - 184,596 - - 60,000 Park development fees - - - 1,903,821 - - - - Charges for current services - - - 13,395 - - - - Fines and forfeitures 96,130 - - - - - - Interest 14,673 59,000 1,757 167,695 3,587 2,666 - 1,248 Miscellaneous - 4,100 - - - - - - Total revenues 110,803 318,831 12,198 2,084,911 188,183 2,666 - 61,248 Expenditures, General government - - 17,588 - - - - - Public safety 32,948 - - - 192 - - - Public services 817 233,953 - - 624,063 6,391 7,623 19,544 Parks and recreation - - - 81,940 - - - - Total expenditures 33,765 233,953 17,588 81,940 624,255 6,391 7,623 19,544 Excess (deficiency) of revenues over expenditures 77,038 84,878 ( 5,390) 2,002,971 (436,072) (3,725) (7,623) 41,704 Operating transfer from (to) other funds - ( 49,659) (50,243) - 73,500 - - (23,841) Excess (deficiency) of revenues and net operating transfers over expenditures 77,038 35,219 (55,633) 2,002,971 (362,572) (3,725) (7,623) 17,863 Fund balances, beginning of year 139,795 627,532 55,633 1,007,918 362,572 56,997 - - Fund balances (deficit), end of year 8216.833 ; 662,751 $ - 83,010,889 3 - ;53,272 8(7,623) $ 17,863 13. Schedule 2 Page 2 of 3 MOORPARK COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES ALL SPECIAL REVENUE FUNDS Year ended June 30, 1987 Community Tierra Development Rejada/ Los Casey/ Block Grants Street Park Moorpark Angeles Gabbert to Small Lighting Maintenance Road Avenue Road Cities Fund Fund Fund AOC Fund AOC Fund AOC Fund Revenues: Property taxes $ - $ 7,951 $ 2,808 $ - $ - $ - Taxes other than property taxes - - - - - - Street improvement fees - - - 1,935,525 1,789,837 - Benefit assessments - 166,181 70,294 - - - Subventions and grants 487,800 - - - - - Park development fees - - - - - - Charges for current services - - 12,527 - - - Fines and forfeitures - - - - - - Interest 152 - - 183,788 258,451 1,217 Miscellaneous - 20,875 1,312 - - - Total revenues 487,952 195,007 86,941 2,119,313 2,048,288 1,217 Expenditures: General government - - - - - - Public safety - - - - - - Public services 392,883 138,616 - 160,846 162,350 34,846 Parka and recreation - - 140,300 - - - Total expenditures 392,883 138,616 140,300 160,846 162,350 34,846 Excess (deficiency) of revenues over expenditures 95,069 56,391 (53,359) 1,958,467 1,885,938 (33,629) Operating transfers from (to) other funds - - - - - - Excess (deficiency) of revenues and net operating transfers over expenditures 95,069 56,391 (53,359) 1,958,467 1,885,938 (33,629) Fund balances, beginning of year - 137,644 51,392 1,233,338 2,254,095 35,598 Fund balances (deficit), end of year $ 95.069 $194.035 $( 1.967) $3.191,805 $4.1401033 $ 1,969 14. Schedule 2 Page 3 of 3 MOORPARK COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES ALL SPECIAL REVENUE FUNDS Year ended June 30, 1987 Los Totals Angeles Office of Senior Year Year Avenue Community Traffic Center ended ended Alternate Development Recreation Safety Bond June 30, June 30, Route Fund Fund Fund Fund Act Fund 1987 1986 Revenues! Property taxes $ - $ - $ - $ - $ - $ 10,759 $ - Taxes other than property taxes - - - - - 255,731 286,611 Street improvement fees 309,692 - - - - 4,035,054 543,925 Benefit assessments - - - - - 236,475 302,732 Subventions and grants - - - 19,407 19,000 781,244 433,142 Park development fees - - - - - 1,903,821 - Charges for current services - - 67,984 - - 93,906 29,405 Fines and forfeitures - - - - - 96,130 90,156 Interest 14,445 - 762 - - 709,441 380,185 Miscellaneous 1,122 - 350 - - 27,759 - Total revenues 325,259 - 69,096 19,407 19,000 8,150,320 2,066,156 Expenditures! General government - - - - - 17,588 - Public safety - - • - 19,407 - 52,547 - Public services 16,038 - - 17,568 1,797,970 471,731 Parks and recreation - - 62,392 - - 302,200 113,226 Total expenditures 16,038 - 62,392 19,407 17,568 2,170,305 584,957 Excess (deficiency) of revenues over expenditures 309,221 - 6,704 - 1,432 5,980,015 1,481,199 Operating transfers from (to) other funds - 1,195,723 6,200 - - 1,151,680 ( 36,000) Excess (deficiency) of revenues and net operating transfers over expenditures 309,221 1,195,723 12,904 - 1,432 7,131,695 1,445,199 Fund balances, beginning of year - - - - - 5,962,514 4,517,315 Fund balances (deficit), end of year $309,221 $1,195,723 $ 12.904 1--_ $ 1,432 $13,094,209 $ 5,962,514 15. Schedule 3 Page 1 of 6 MOORPARK COMBINING STATEMENT OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL ALL SPECIAL REVENUE FUNDS Year ended June 30, 1987 Traffic Safety Fund State Gas Tax Fund Federal Revenue Sharing Fund Park Development Fund Variance- Variance- Variance- Variance- favorable favorable favorable favorable (unfavor- (unfavor- (unfavor- (unfavor- Budget Actual able) Budget Actual able) Budget Actual able) Budget Actual able) Revenues' Property taxes $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Taxes other than property taxes - - - 231,000 255,731 24,731 - - - - - - Street improvement fees - - - - - - - - - - - - Benefit assessments - - - - - - - - - - - - Subventions and grants - - - - - - 25,000 10,441 (14,559) - - - Park Development fees - - - - - - - - - 971,500 1,903,821 932,321 Charges for current services - - - - - - - - - - 13,395 13,395 Fines and forfeitures 58,000 96,130 38,130 - - - - - - - - - Interest 3,000 14,673 11,673 21,000 59,000 38,000 2,500 1,757 ( 743) 70,000 167,695 97,695 Miscellaneous - - - 5,436 4,100 ( 1,336) - - - - - - Total revenues 61,000 110,803 49,803 257,436 318,831 61,395 27,500 12,198 (15,302) 1,041,500 2,084,911 1,043,411 Expenditures' General government - - - - - - 38,000 17,588 20,412 - - - Public safety 33,900 32,948 952 - - - - - - - - - Public services 23,500 817 22,683 278,941 233,953 44,988 - - - - - - Parks and recreation - - - - - - - - - 461,575 81,940 379,635 Total expendi- tures 57,400 33,765 23,635 278,941 233,953 44,988 38,000 17,508 20,412 461,575 81,940 379,635 Excess (deficiency) of revenues over expendi- tures 3,600 77,038 73,438 (21,505) 84,878 106,383 (10,500) ( 5,390) 5,110 579,925 2,002,971 1,423,046 Operating transfers from (to) other funds - - - - (49,659) (49,659) (50,000) (50,243) ( 243) - - - Excess (deficiency) of revenues and net operating transfers over expenditures $ 1'600 $77.038 $73.438 $(21,505) $ 35.219 $ 56,724 $(60,500) $(55,633) I 4.112 $ 579,925 $2,002,971 $1,423,046 16. Schedule 3 Page 2 of 6 MOORPARK COMBINING STATEMENT OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL ALL SPECIAL REVENUE FUNDS Year ended June 30, 1987 Local Transportation Local Transportation Community Center Fund - Streets Fund - Transit Fund State Transit Assistance Fund Variance- Variance- Variance- Variance- favorable favorable favorable favorable (unfavor- (unfavor- (unfavor- (unfavor- Budget Actual able) Budget Actual able) Budget Actual able) Budget Actual able) Revenues: Property taxes $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Taxes other than property taxes - - - - - - - - - - - - Street improvement fees - - - - - - - - - - - - Benefit assessments - - - - - - - - - - - - Subventions and grants - - - 238,200 184,596 ( 53,604) 26,106 60,000 33,894 24,900 - (24,900) Park Development fees - - - - - - - - - - - - Charges for current services 21,500 - (21,500) - - - - - - - - - Fines and forfeitures - - - - - - - - - - - - Interest - - - 9,000 3,587 ( 5,413) - 1,248 1,248 - 2,666 2,666 Miscellaneous - - - - - - - - - - - - Total revenues 21,500 - (21,500) 247,200 188,183 ( 59,017) 26,106 61,248 35,142 24,900 2,666 (22,234) Expendituresi General government - - - - - - - - - - - - Public safety - - - - 192 ( 192) - - - - - - Public services - - - 469,457 624,063 (154,606) - 19,544 (19,544) 28,600 6,391 22,209 Parks and recreation 21,500 - 21,500 - - - - - - - - - Total expen- ditures 21,500 - 21,500 469,457 624,255 (154,798) - 19,544 (19,544) 28,600 6,391 22,209 Excess (deficiency) of revenues over expenditures - - - (222,257) (436,072) (213,815) 26,106 41,704 15,598 ( 3,700) (3,725) ( 25) Operating transfers from (to) other funds - - - - 73,500 73,500 (26,106) (23,841) 2,265 - - - Excess (deficiency) of revenues and net operating transfers over expenditures 2-----= $ - $ - $(222.257) $(362.572) ((140,315) $ - $ 17.863 $ 17.863 $( 3,700) 5(3.725) $( 25) 17. Schedule 3 Page 3 of 6 MOORPARK COMBINING STATEMENT OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL ALL SPECIAL REVENUE FUNDS Year ended June 30, 1987 Community Development Community Development Transportation Development Block Grants to Block Grant - Act (Article 3) Fund Small Cities Fund Entitlement Fund Variance Variance- Variance- favorable favorable favorable (unfavor- (unfavor- (unfavor- Budget Actual able) Budget Actual able) Budget Actual able) Revenues: Property taxes $ - $ - $ - $ - $ - $ - $ - $ - $ - Taxes other than property taxes - - - - - - - - - Street improvement fees - - - - - - - - - Benefit assessments - - - - - - - - - Subventions and grants 20,877 - (20,877) 581,400 487,800 (93,600) 110,905 - (110,905) Park Development fees - - - - - - - - - Charges for current services - - - - - - - - - Fines and forfeitures - - - - - - - - - Interest - - - - 152 152 - - - Miscellaneous - - - - - - - - - Total revenues 20,877 - (20,877) 581,400 487,952 (93,448) 110,905 - (110,905) Expenditures: General government - - - - - - _ _ Public safety - - - - - - - - _ Public services 20,877 7,623 13,254 581,400 392,883 188,517 110,905 - 110,905 Parks and recreation - - - - - - - - - Total expenditures 20,877 7,623 13,254 581,400 392,883 188,517 110,905 - 110,905 Excess (deficiency) of revenues over expenditures - (7,623) ( 7,623) - 95,069 ' 95,069 - - - Operating transfers from (to) other funds - - - - - - - - - Excess (deficiency) of revenues and net operating transfers over expenditures $ - $(7.623) $( 7.623) $ - $ 95,069 $ 95,069 1---,..-: §-----7. f_-___.= 18. Schedule 3 Page 4 of 6 MOORPARK COMBINING STATEMENT OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL ALL SPECIAL REVENUE FUNDS Year ended June 30, 1987 Tierra Rejada/Moorpark Street Lighting Fund Park Maintenance Fund Road AOC Fund Los Angeles Avenue AOC Fund Variance- Variance- Variance- Variance- favorable favorable favorable favorable (unfavor- (unfavor- (unfavor- (unfavor- Budget Actual able) Budget Actual able) Budget Actual able) Budget Actual able) Revenues: Property taxes $ 1,500 $ 7,951 $ 6,451 $ 1,100 $ 2,808 $ 1,708 $ - $ - $ - $ - $ - $ - Taxes other than property taxes - Street improvement fees - - - - - - 675,500 1,935,525 1,260,025 440,000 1,789,837 1,349,837 Benefit assessments 163,366 166,181 2,815 81,800 70,294 (11,506) - - - - - - Subventions and grants - - - - - - - - - - - - Park development fees - - - - - - - - - - - - Charges for current services - - - - 12,527 12,527 - - - - - - Fines and forfeitures - - - - - - - - - - - - Interest - - - - - - 84,000 183,788 99,788 90,000 258,451 168,451 Miscellaneous 7,790 20,875 13,085 - 1,312 1,312 - - - - - - Total revenues 172,656 195,007 22,351 82,900 86,941 4,041 759,500 2,119,313 1,359,813 530,000 2,048,288 1,518,288 Expenditures: General government - - - - - - - - - - - - Public safety - - - - - - - - - - - - Public services 298,240 138,616 159,624 - - - 32,200 160,846 (128,646) 658,828 162,350 496,478 Parka and recreation - - - 146,100 140,300 5,800 - - - - - - Total expendi- tures 298,240 138,616 159,624 146,100 140,300 5,800 32,200 160,846 (128,646) 658,828 162,350 496,478 Excess (deficiency) of revenues over expendi- tures (125,584) 56,391 181,975 ( 63,200) (53,359) 9,841 727,300 1,958,467 1,231,167 (128,828) 1,885,938 2,014,766 Operating transfers from (to) other funds - - - 21,500 - (21,500) - - - - - - Excess (deficiency) of revenues and net operating transfers over expenditures $(125.584) $ 56.391 $ 181,975 $( 41.700) $(53.359) $(11,659) $727,300 $1,958,467 $1,231,167 5(128,828)51,885.938 $2,014,766 19. Schedule 3 Page 5 of 6 MOORPARK COMBINING STATEMENT OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL ALL SPECIAL REVENUE FUNDS Year ended June 30, 1987 Casey/Gabbert Road AOC Fund Los Angeles Avenue Alternate Route Fund Community Development Fund Variance- Variance- Variance- favorable favorable favorable (unfavor- (unfavor- (unfavor- Budget Actual able) Budget Actual able) Budget Actual able) Revenues: Property taxes $ - $ - $ - $ - $ - $ - $ - $ - $ - Taxes other than property taxes - - - - - - - - Street improvement fees - - - 350,000 309,692 ( 40,308) - - - Benefit assessments - - - - _ _ - _ Subventions and grants - - - - - _ - - Park development fees - - - - - - _ - - Charges for current services - - - - - - - - Fines and forfeitures - - - - - - _- Interest - 1,217 1,217 - 14,445 14,445 - - - Miscellaneous - - - - 1,122 1,122 - - - Total revenues - 1,217 1,217 350,000 325,259 ( 24,741) - - - Expendituresi General government - - - - - - _ - - Public safety - - - - - _ Public services 62,600 34,846 27,754 24,000 16,038 7,962 - - - Parks and recreation - - - - - - - - - Total expenditures 62,600 34,846 27,754 24,000 16,038 7,962 - - - Excess (deficiency) of revenues over expenditures (62,600) (33,629) 28,971 326,000 309,221 (16,779) - - - Operating transfers from (to) other funds - - - - - 1,195,723 1,195,723 - Excess (deficiency) of revenues and net operating transfers over expenditures $(62,600) $(33.629) $28,971 $326,000 $309,221 $( 16.779) $1,195,723 $1,195.723 L_____ 20. Schedule 3 Page 6 of 6 MOORPARK COMBINING STATEMENT OF REVENUES AND EXPENDITURES - BUDGET AND ACTUAL ALL SPECIAL REVENUE FUNDS Year ended June 30, 1987 Senior Center Recreation Fund Office of Traffic Safety Fund Bond Act Fund Totals Variance- Var ance- Variance- Variance- favorable favorable favorable favorable (unfavor- (unfavor- (unfavor- (unfavor- Budget Actual able) Budget Actual able) Budget Actual able) Budget Actual able) Revenues: Property taxes $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 2,600 $ 10,759 $ 8,159 Taxes other than property taxes - - - - - - - - - 231,000 255,731 24,731 Street improvement fees - - - - - - - - - 1,465,500 4,035,054 2,569,554 Benefit assessments - - - - - - - - - 245,166 236,475 ( 8.691) Subventions and grants - - - - 19,407 19,407 150,000 19,000 (131,000) 1,177,388 781,244 ( 396,144) Park development fees - - - - - - - - - 971,500 1,903,821 932,321 Charges for current services 96,400 67,984 (28,416) - - - - - - 117,900 93,906 ( 23,994) Pines and forfeitures - - - - - - - - - 58,000 96,130 38,130 Interest - 762 762 - - - - - - 279,500 709,441 429,941 Miscellaneous - 350 350 - - - - - - 13,226 27,759 14,533 Total revenues 96,400 69,096 (27,304) - 19,407 19,407 150,000 19,000 (131,000) 4,561,780 8,150,320 3,588,540 Expenditures: General government - - - - - - - - - 38,000 17,588 20,412 Public safety - - - - 19,407 (19,407) - - - 33,900 52,547 ( 18,647) Public services - - - - - - - - - 2,589,548 1,797,970 791,578 Parks and recreation 102,600 62,392 40,208 - - - 150,000 17,568 132,432 881,775 302,200 519,575 Total expendi- tures 102,600 62,392 40,208 - 19,407 (19,407) 150,000 17,568 132,432 3,543,223 2,170,305 1,372,918 Excess (deficiency) of revenues over expendi- tures ( 6,200) 6,704 12,904 - - - - 1,432 1,432 1,018,557 5,980,015 4,961,458 Operating transfers from (to) other funds - 6,200 6,200 - - - - - - 1,141,117 1,151,680 10,563 Excess (deficiency) of revenues and net operating transfers over expenditures $( 6,200) $ 12.904, $ 19,104 $ - $ - $ - $ - $ 1,432 $ 1,432 $ 2,159,674 $7,131,695 $4,972,021 21. • Schedule 4 MOORPARK STATEMENT OF GENERAL PROPERTY AND EQUIPMENT ACCOUNT GROUP June 30, 1987 Office Total Community furniture property center and Other and building equipment equipment equipment General government $ - $106,464 $ 14,364 $120,828 Cultural and recreation (resulting from transfer of property by the County of Ventura) 690,000 - - 690,000 $690.000 $106,464 $ 14.364 $810,828 22.