Loading...
HomeMy WebLinkAbout1997 FinancialsMCAG NO. 0292 Exhibit 1 CITY OF PASCO, WASHINGTON COMBINED BALANCE SHEET ALL FUND TYPES AND ACCOUNT GROUPS AS OF DECEMBER 31, 1997 (WITH COMPARATIVE TOTALS FOR 1996) FIDUCIARY ACCOUNT GROUPS TOTALS GOVERNMENTAL FUND TYPES PROPRIETARY FUND TYPES FUND TYPES GENERAL GENERAL (MEMORANDUM ONLY) SPECIAL DEBT CAPITAL INTERNAL TRUST AND FIXED LONG-TERM GENERAL REVENUE SERVICE PROJECTS ENTERPRISE SERVICE AGENCY ASSETS DEBT 1997 1996 ASSETS AND OTHER DEBITS ASSETS: Cash and Imprest Cash $2,235,964 $1,586,876 $2,141,368 $ (1,981,809) $ 6,092,775 $1,533,575 $1,098,704 $ 0 $ 0 $ 12,707,453 $ 16,927,997 Cash with Fiscal Agent 56,068 0 6,725 0 0 0 0 0 0 62,793 8,310 Investments (Note 3) 0 0 0 0 0 0 681,586 0 0 681,586 582,805 Receivables (net): Taxes 412,390 27,884 29,091 0 0 0 0 0 0 469,365 452,770 Accounts 143,856 30,748 0 0 360,261 0 1,433,787 0 0 1,968,652 1,558,316 Special Assessments 0 0 4,319,485 0 0 0 0 0 0 4,319,485 2,912,247 Interest 0 0 0 0 0 0 320,926 0 0 320,926 282,415 Grants 116,667 513,139 0 0 1,585,598 0 82,778 0 0 2,298,182 2,880,322 Loans/Advances Receivable 0 162,693 0 0 0 0 0 0 0 162,693 250,658 lnterfund Loans Receivable (Note 13) 1,095,600 900 0 0 0 0 438,297 0 0 1,534,797 1,406,959 Inventories, at Cost (Note 1) 0 0 0 0 168,978 12,235 0 0 0 181,213 134,261 Prepaid Expenses 0 0 0 0 13,989 (2,570) 0 0 0 11,419 10,326 Restricted Assets: (Note 1) Cash and Investments 0 0 0 0 1,864,281 0 0 0 0 1,864,281 1,585,213 Fixed Assets (Note 6) 0 0 0 0 53,247,370 1,120,647 0 19,554,322 0 73,922,339 62,386,813 OTHER DEBITS: Unamortized Debt Discount 0 0 0 0 130,443 0 0 0 0 130,443 146,195 Amount Avail. in Debt Service Funds 0 0 0 0 0 0 0 0 (17,574) (17,574) (18,125) Amount to be Provided for Retirement of Long-Term Debt 0 0 0 0 0 0 0 0 10,436,755 10,436,755 10,994,544 TOTAL ASSETS $4,060,545 $2,322,240 $6,496,669 $ p,981,809) $ 63,463,695 $2,663,887 $4,056,078 $ 19,554,322 $10,419,181 $ 111,054,808 $102,502,026 FIDUCIARY ACCOUNT GROUPS TOTALS S'20VERNMENT AL FUND TYPES PROPRIETARY FUND TYPES FUND TYPES GENERAL GENERAL !MEMORANDUM ONLY) SPECIAL DEBT CAPITAL INTERNAL TRUST AND FIXED LONG-TERM GENERAL REVENUE SERVICE PROJECTS ENTERPRISE SERVICE AGENCY ASSETS DEBT 1997 1996 LIABILITIES, EQUITY AND OTHER CREDITS LIABILITIES: Outstanding Checks Payable $ 0 $ 0 $ 0 $ 0 $ 0 $ 0 $ 56,545 $ 0 $ 0 $ 56,545 $ 39,735 Accounts Payable 262,732 126,604 0 41,826 1,845,624 39,333 73,965 0 0 2,390,084 1,000,346 Matured Bonds Payable 55,000 0 5,000 0 0 0 0 0 0 60,000 5,000 Matured Interest Payable 1,068 0 1,725 0 0 0 0 0 0 2,793 3,310 Retainage Payable 0 21,385 0 53,365 382,335 0 0 0 0 457,085 45,803 lnter!und Loans Payable (Note 13} 142,292 995,600 65,000 0 0 100,000 0 0 0 1,302,892 1,241,959 Due to Other Governmental Units 42,561 302,159 0 0 105,744 0 30,000 0 0 480,464 374,829 Accrued Interest Payable 0 0 10,127 0 89,034 0 0 0 0 99,161 109,802 Accrued Employee Benefits (Note 1) 0 0 0 0 69,097 14,126 0 0 934,181 1,017,404 932,735 Deposits Payable 46,740 0 0 0 24,138 0 0 0 0 70,878 81,818 G. 0. Bonds Payable (Note 10) 0 0 0 0 0 0 0 0 9,485,000 9,485,000 10,100,000 Revenue Bonds Payable (Note 10) 0 0 0 0 8,930,000 0 0 0 0 8,930,000 9,600,000 Other Long Term Liabilities 0 0 2,376,659 0 21,469,820 0 0 0 0 23,846,479 20,090,979 Deferred Revenue 242,168 19,538 3,796,003 0 386,618 0 65,849 0 0 4,510,176 2,803,543 Deferred Compensation (Note 8) 0 0 0 0 0 0 1,434,159 0 0 1,434,159 1,097,683 Total Liabilities 792,561 1,465,286 6,254,514 95,191 33,302,410 153,459 1,660,518 0 10,419 181 54,143,120 47,527,542 EQUITY AND OTHER CREDITS: Investment in General Fixed Assets 0 0 0 0 0 0 0 19,554,322 0 19,554,322 19,825,411 Contributed Capital (Note 14) 0 0 0 0 11,143,163 0 0 0 0 11,143,163 10,610,824 Retained Earnings: (Note 14) Reserved 0 0 0 0 230,661 2,448,194 2,395,560 0 0 5,074,415 4,644,765 Unreserved 0 0 0 0 18,787,461 62,234 0 0 0 18,849,695 16,527,433 Fund Balances: (Note 14} Reserved 1,107,365 195,903 242,155 (2,077,000) 0 0 0 0 0 (531,577) 1,030,952 Unreserved-Undesignated 2,160,619 661,051 0 0 0 0 0 0 0 2,821,670 2,335,099 Total Equity and Other Credits 3,267,984 856,954 242,155 !2,077,000! 30,161,285 2,510,428 2,395,560 19,554,322 0 56,911,688 54,974,484 TOTAL LIABILITIES, EQUITY AND OTHER CREDITS $4,060,545 $2,322,240 $6,496,669 $ !1,981,809) $ 63,463,695 $2,663,887 $4,056,078 $ 19,554,322 $10,419,181 $ 111,054,808 $102,502,026 See Accompanying Notes to Financial Statements CITY OF PASCO, WASHINGTON COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCES • BUDGET AND ACTUAL GENERAL AND SPECIAL REVENUE FUNDS FOR THE YEAR ENDED DECEMBER 31, 1997 REVENUES Taxes Licenses & Permits lntergovermental Revenue Charges for Services Fines & Forfeitures Interest Miscellaneous Total Revenues EXPENDITURES Current General Government Security of Persons & Property Physical Environment Transportation Economic Environment Mental & Physical Health Culture & Recreation Capital Outlay Debt Service Principal Interest Total Expenditures Excess {Deficiency) of Revenues over Expenditures OTHER FINANCING SOURCES (USES) Disposition of Fixed Assets Operating Transfers/lnterfund Loans -In (Note 13) Operating Transfers/lnterfund Loans • (Out) (Note 13) Total Other Financing Sources (Uses) Excess {Deficiency) of Revenues and Other Financing Sources over Expenditures and Other Financing Uses Fund Balances, January 1 Equity Transfers In Prior period adjustment Fund Balances, December 31 See Accompanying Notes to Financial Statements. BUDGET $ 9,105,000 345,800 1,223,950 1,459,100 390,000 107,000 321,100 12,951,950 2,541,050 7,043,170 682,750 0 287,160 3,950 1,530,445 390,900 145,050 258,550 12,883,025 68,925 35,000 59,000 (163,025) (69,025) (100) 1,633,932 0 0 $ 1,633,832 Exhibit 3 GENERAL FUND VARIANCE Favorable ACTUAL (Unfavorable) $ 9,620,912 $ 515,912 390,445 44,645 1,081,822 (142,128) 1,456,547 (2,553) 450,718 60,718 106,174 (826) 342,983 21,883 13,449,601 497,651 2,410,603 130,447 7,054,178 (11,008) 729,005 (46,255) 0 0 281,633 5,527 4,114 (164) 1,523,834 6,611 309,238 81,662 145,018 32 258,312 238 12,715,935 167,090 733,666 664,741 37,647 2,647 88,500 29,500 {97,759) 65,266 28,388 97,413 762,054 762,154 2,472,040 838,108 46,978 46,978 (13,088) {13,088) $3,267,984 $1,634,152 CITY OF PASCO, WASHINGTON GENERAL FUND BALANCE SHEET AS OF DECEMBER 31, 1997 AND 1996 ASSETS Cash and Imprest Cash Cash with Fiscal Agent Receivables: Taxes: Property Utility and Gambling lnterfund Loans Accounts, net Grants TOTAL ASSETS LIABILITIES & FUND BALANCES LIABILITIES Accounts Payable Matured Bonds and Interest Payable lnterfund Loans Payable Fire Pension Fund Due to Other Governmental Units Trust Deposits Deferred Revenues Total Liabilities FUND BALANCES Reserved for Imprest Funds Reserved for lnterfund Loans Unreserved-Designated for K-9 Unit Unreserved-Undesignated Total Fund Balances TOTAL LIABILITIES & FUND BALANCES See Accompanying Notes to Financial Statements. Exhibit A-1 1997 1996 $ 2,235,964 $ 1,737,925 56,068 910 144,400 130,407 267,990 260,555 1,095,600 920,600 143,856 120,548 116,667 0 $ 4,060,545 $ 3,170,945 $ 262,732 $ 208,796 56,068 910 142,292 164,159 42,561 31,515 46,740 63,900 242,168 229,625 792,561 698,905 11,765 6,750 1,095,600 920,600 0 0 2,160,619 1,544,690 3,267,984 2,472,040 $ 4,060,545 $ 3,170,945 ExhibitA-4 CITY OF PASCO, WASHINGTON GENERAL FUND STATEMENT OF EXPENDITURES-BUDGET AND ACTUAL FOR THE YEARS ENDED DECEMBER 31, 1997 AND 1996 1997 1996 VARIANCE VARIANCE Favorable Favorable BUDGET ACTUAL (Unfavorable) BUDGET ACTUAL (Unfavorable) GENERAL GOVERNMENT Council Personal Services $ 40,600 $ 40,201 $ 399 $ 40,600 $ 38,713 $ 1,887 Personnel Benefits 3,400 3,190 210 3,400 3,084 316 Supplies 600 97 503 600 520 80 Other Services & Charges 21,700 21,738 i38) 20,000 25,781 (5,781) Total Council 66,300 65,226 1,074 64,600 68,098 (3,498) Municipal Court Personal Services 245,190 255,536 (10,346) 236,200 226,630 9,570 Personnel Benefits 73,250 75,145 (1,895) 64,200 65,073 (873) Supplies 9,800 7,809 1,991 6,500 7,466 (966) Other Services & Charges 134,530 135,167 (637) 142,160 135,269 6,891 Total Municipal Court 462,770 473,657 (10,887) 449,060 434,438 14,622 City Manager Personal Services 296,230 300,092 (3,862) 292,100 270,597 21,503 Personnel Benefits 74,350 73,445 905 70,700 65,942 4,758 Supplies 7,700 5,601 2,099 1,500 2,576 (1,076) Other Services & Charges 84,460 75,604 8,856 75,860 70,060 5,800 Total City Manager 462,740 454,742 7,998 440,160 409,175 30,985 City Attorney Personal Services 79,360 80,418 (1,058) 72,750 73,861 (1,111) Personnel Benefits 20,280 22,786 2,506 18,700 18,633 (67) Supplies 9,900 16,404 (6,504) 10,150 16,238 (6,088) Other Services & Charges 130,020 113,185 16,835 127,260 109,496 17,764 Total City Attorney 239,560 232,793 11,779 228,860 218,228 10,498 Finance Personal Services 437,070 430,203 6,867 441,650 435,372 6,278 Personnel Benefits 120,820 117,562 3,258 113,850 112,492 1,358 Supplies 23,150 22,624 526 20,150 21,628 (1,478) Other Services & Charges 166,110 163,944 2,166 181,210 174,677 6,533 Total Finance 747,150 734,333 12,817 756,860 744,169 12,691 Non-Departmental Personal Services 28,100 5,356 22,744 2,900 0 2,900 Personnel Benefits 125,680 108,862 16,818 103,050 101,555 1,495 Supplies 700 5,964 (5,264) 700 6,002 (5,302) Other Services & Charges 386,050 289,930 96,120 293,150 348,578 (55,428) Intergovernmental 22,000 39,740 111,14ol 18,000 19,330 p,330) Total Non-Department 562,530 449,852 112,678 417,800 475,465 (57,665) TOTAL GENERAL GOVERNMENT $ 2,541,050 $ 2,410,603 $ 135,459 $ 2,357,340 $ 2,349,573 $ 7,633 See Accompanying Notes to Financial Statements. CITY OF PASCO, WASHINGTON INTERNAL SERVICE FUNDS COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN FUND EQUITY FOR THE YEAR ENDED DECEMBER 31, 1997 (WITH COMPARATIVE TOTALS FOR 1996) EQUIPMENT EQUIPMENT MEDICAU RENTAL- RENTAL-CENTRAL DENTAL OPERATING REPLACMENT STORES INSURANCE OPERATING REVENUES Charges for Services $ 5,305 $ 39,276 $ 0 $ 26,401 lnterfund Charges 347,107 213,060 18,749 889,031 Total Operating Revenues 352,412 252,336 18,749 915,432 OPERA TING EXPENSES Personal Services 75,075 0 0 764,949 Personnel Benefits 25,006 0 0 0 Supplies 161,629 0 15,551 0 Services and Charges 71,153 0 0 60,939 Depreciation 0 187,665 0 0 Total Operating Expenses 332,863 187,665 15,551 825,888 Net Operating Income (Loss) 19,549 64,671 3,198 89,544 NON-OPERATING REVENUES Gains on Sales 0 (7,481) 0 0 Interest Income 4,182 63,320 0 5,628 Miscellaneous Revenue 0 0 14 100 lnterfund Transfers-ln/(Out) 0 0 0 0 Total Non-Operating Revenues 4,182 55,839 14 5,728 Net Income (Loss) 23,731 120,510 3,212 95,272 Fund Equity, January 1 38,491 2,213,551 9,035 (42,128) Prior Period Corrections 0 17,009 0 13,088 Assets Purchased in Other Funds 0 18,657 0 0 Fund Equity, December 31 $ 62,222 $ 2,369,727 $ 66,232 See Accompanying Notes to Financial Statements. Exhibit F-2 TOTALS 1997 1996 $ 70,982 $ 72,956 1,467,947 1,344,951 1,538,929 1,417,907 840,024 1,015,000 25,006 13,684 177,180 171,748 132,092 174,116 187,665 191,429 1,361,967 1,565,977 176,962 (148,070) (7,481) 3,363 73,130 52,518 114 160 0 70,000 65,763 126,041 242,725 (22,029) 2,218,949 2,158,904 30,097 0 18,657 82,074 $ 2,510,428 $ 2,218,949 ~ ,,-.~-Exhibit F-3 CITY OF PASCO, WASHINGTON INTERNAL SERVICE FUNDS COMBINING STATEMENT OF CASH FLOWS FOR THE YEAR ENDED DECEMBER 31, 1997 (WITH COMPARATIVE TOTALS FOR 1996) EQUIPMENT EQUIPMENT MEDICAU RENTAL-RENTAL-CENTRAL DENTAL OPERATING REPLACEMENT STORES INSURANCE 1997 1996 Cash flows from operating activities: Cash received from users $ 352,412 $ 252,336 $ 18,749 $ 915,432 $ 1,538,929 $ 1,424,259 Cash paid to suppliers (160,103) 0 (18,047) (60,939) (239,089) (212,318) Cash paid to employees (99,974) 0 0 (746,541) (846,515) (1,029,445) Cash paid for other operating expenses (71,153) 0 0 0 (71,153) (126,057) Net cash provided (used) by operating activities 21,182, 252,336 / 702/ 107,952 .. 382,172 56.439 Cash flows from non-capital financing activities: Miscellaneous revenue 0 0 0 100 100 160 lnterfund Loans Received 0 0 0 0 0 100,000 lnterfund Transfers 0 35,666 0 13,088 48,754 70,000 0 35,666 0 13,188 48,854 170,160 Cash flows from capital and related ,.,,, .. financing activities: Sale of fixed assets 0 7,621 0 0 7,621 3,363 Principal payments received 0 85,000 0 0 85,000 120,000 Purchase of fixed assets 0 (186,718) 0 0 (186,718) (224,965) Net Cash used by financing activities: 0 (94,097) 0 0 (94,097) (101,602) Cash flows from investing activities: Interest received 4,182 63,320 0 5,628 73,130 52,518 Net increase (decrease) in cash 25,364 257,225 702 126,768 410,059 177,515 Cash, January 1 69,612 991,860 1,602 57,872 1,120,946 943,431 Cash, December 31 $ 94,976/ $1,249,085 /$ 2,304 / $ 184,640 / $ 1,531,005 $ 1,120,946 RECONCILIATION OF OPERATING INCOME TO NET CASH PROVIDED BY OPERATING ACTIVITIES Operating Income $ 19,549 $ 64,671 $ 3,198 $ 89,544 $ 176,962 $ (148,070) Adjustments to reconcile net income to net cash provided by operating Activities: Depreciation expense 0 187,665 0 0 187,665 191,429 Increase in Accrued Employee Benefits 107 0 0 0 107 (761) (Increase) Decrease in Inventory 0 0 (2,923) 0 (2,923) 6,921 Increase (Decrease) in Accounts Payable 1,526 0 427 18,408 20,361 6,920 Total Adjustments 1,633 187,665 (2,496) 18,408 205,210 204,509 Net Cash Provided by Operating Activities $ 21,182 / $ 252,336• $ 702 • $ 107,952 ✓ $ 382,172 $ 56,439 See Accompanying Notes to Financial Statements. Exhibit H-3 CITY OF PASCO, WASHINGTON SCHEDULE OF CHANGES IN GENERAL FIXED ASSETS -BY FUNCTION AND ACTIVITY AS OF DECEMBER 31, 1997 GENERAL GENERAL FIXED ASSETS FIXED ASSETS FUNCTION AND ACTIVITY January 1, 1997 Additions Deductions December 31, 1997 GENERAL GOVERNMENT: City Manager $ 11,949 $ 0 $ 97 $ 11,852 City Attorney 5,855 0 61 5,794 Finance 27,562 0 286 27,276 Non-Departmental 12,404,576 54,996 48,431 121411,141 Total General Government 12,449,942 54,996 48,875 12,456,063 SECURITY OF PERSONS & PROPERTY: Police 251,371 0 3,192 248,179 Fire 267,455 0 2,852 264,603 Total Public Safety 518,826 0 6044 512,782 PHYSICAL ENVIRONMENT: Engineering 53,454 0 555 52,899 Maintenance 78,042 0 488 77,554 Total Physical Environmental 131,496 0 1,043 130,453 ECONOMIC ENVIRONMENT: Community Development 317,271 0 6,850 310,421 Total Economic Environment 317,271 0 6,850 310,421 CULTURE & RECREATION: Parks & Recreation 6,407,875 0 263,272 6,144,603 Total Culture & Recreation 6,407,875 0 263,272 6,144,603 TOTAL GENERAL FIXED ASSETS $ 19,825,410 $ 54,996 $ 326,084 $ 19,554,322 See Accompanying Notes to Financial Statements. CITY OF PASCO, WASHINGTON SCHEDULE OF LONG-TERM DEBT GENERAL LONG-TERM DEBT ACCOUNT GROUP AS OF DECEMBER 31, 1997 AND 1996 AMOUNT AVAILABLE AND TO BE PROVIDED Amount Available in Debt Service Funds Amount to be Provided for Other Long-Term Liabilities Amount to be Provided for Bond Payments TOTAL AMOUNT AVAILABLE AND TO BE PROVIDED GENERAL LONG-TERM DEBT PAYABLE Accrued Employee Leave Benefits General Obligation Bonds Payable Other Long-Term Liabilities TOTAL GENERAL LONG-TERM DEBT See Accompanying Notes to Financial Statements. 1997 $ (17,574} 9,502,574 934,181 $ 10,419, 181 $ 934,181 9,485,000 0 $ 10,419,181 1996 $ (18,125) 10,118,125 876,419 $ 10,976,419 $ 866,401 10,100,000 10,018 $ 10,976,419 MCAG NO. 0292 CITY OF PASCO, WASHINGTON SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS YEAR ENDED DECEMBER 31, 1997 Federal Assistance Received Directly From A federal Agency Or Indirectly Through A State Agency Or Other Local Government Grantor/ Pass-Through Grantor Proaram Title Department of Justice Police Hiring Supplement Local Law Enforcement Block Grant COPS MORE96 Total Department of Justice Dept. of Comm. Development Narcotics Task Forces Narcotics Task Forces Total Dept of Community Development Economic Development Administration lndustrical WaterWater Treatment Plant Housing & Urban Development Community Development Block Grant Community Development Block Grant Total Housing & Urban Development Federal CFDA Number 16.580 16.592 16.71 16.579 16.579 11.300 14.218 14.218 U.S. Dept of Health & Human Services Indirect Awards Office of Aging & Long-Term Care Other Identification Current Year Number Exoenditures 94-DM-CX-0202 $ 116,667 96-LB-VX-0652 46,114 97-CM-WX-1013 ___ 9~2,_54_3_ F97-374014 1-96-37 4014 07-01-03295 255,324 106,210 159,262 265,472 186 847 B-96-MC-530009 514,956 B-97-MC-560009 ___ 4 .... 9_._, 1_1 .... 4_ 564 070 Foot Care 93.044 96-009-391(PA) 9,025 Franklin County Information & Assistance 93.044 96-009-342(PA) ___ 18_0..._,2 __ 0 __ 5_ Total Dept of Health & Human Services 189,230 TOTAL FEDERAL ASSISTANCE: $ 1,460,943 The accompanying notes to the schedule of expenditures of federal awards are an integral part of this schedule.