Loading...
FY2000 Audit Report CityCITY OF BLAIR, NEBRASKA SEPTEMBER 30, 2000 EDWARD W. SCHROEDER CERTIFIED PUBLIC ACCOUNTANT 1904 SOUTH STREET BOX 486 BLAIR, NEBRASKA 68008 Honorable Mayor and Members of the City Council City of Blair, Nebraska Gentlemen: January 4, 2001 "Independent Auditor's Report" RESIDENCE: (402) 468-5253 OFFICE: (402) 426-4080 I have audited the accompanying general-purpose financial statements and the combining, individual fund, and account group statements of the City of Blair, Nebraska as of and for the years ended September 30, 1999 and 2000, as listed in the table of contents. These financial l statements are the responsibility of the City of Blair's management. My responsibility is to express an opinion on these financial statements based on my audit. I conducted my audit in accordance with generally accepted auditing standards and the standards applicable to financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall financial statement presentation. I believe that my audit provides a reasonable basis for my opinion. In my opinion, the general-purpose financial statements referred to above present fairly, in all material respects, the financial position of the City of Blair, Nebraska as of September 30, 1999 and 2000, and the results of its operations and the cash flows of its proprietary fund types and nonexpendable trust funds for the years then ended in conformity with generally accepted accounting principles. Also, in my opinion, the combining, individual:fund, and account group financial statements referred to above present fairly, in all material respects, the financial position of each of the individual funds and account groups of the City of Blair, Nebraska, at September 30, 1999 and September 30, 2000, and the results of operations of such funds and the changes in cash flow of the individual proprietary funds for the years then ended, in conformity with generally accepted accounting principles. In accordance with Government Auditing Standards, I have also issued my report dated January 4, 2001 on my consideration of the City of Blair's internal control over financial reporting and my tests of its compliance with certain provisions of laws, regulations, contracts and grants. Mayor and Members of the City Council January 4, 2001 Page 2 My audit was performed for the purpose of forming an opinion on the general-purpose financial statements of City of Blair, Nebraska, taken as a whole and the combining, individual fund, and account group statements. The accompanying supplemental schedules and schedule of expenditures of federal awards listed in the forgoing table of contents are presented for the purpose of additional analysis as required by the U.S. Office of Management and Budget Circular A-133, Audits of States, Local Governments and Non -Profit Organizations and are not a required part of the general-purpose financial statements. Such information has been subjected to the auditing procedures applied in the audit of the general-purpose financial statements and, in my opinion, is fairly stated, in all material respects, in relation to the general-purpose financial statements taken as a whole. Edward W. Schroeder Certified Public Accountant CITY OF BLAIR, NEBRASKA TABLE OF CONTENTS Page INDEPENDENT AUDITORS' REPORT 1-2 COMBINED STATEMENTS: Combined Balance Sheet - All Fund Types and Account Groups 3-4 Combined Statement of Revenue, Expenditures and Changes in Fund Balance - All Government Fund Types 5-6 Combined Statement of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual - General Fund 7 Combined Statement of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual - Debt Service Fund 8 Combined Statement of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual - Special Revenue Fund 9 Combined Statement of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual - Capital Improvement Fund 10 Combined Statement of Revenues, Expenses and Changes in Retained Earnings/Fund Balance - Budget and Actual - AII Proprietary Fund Types and Similar Trust Funds 11 General Fixed Assets Account Group: Statement of General Fixed Assets 12 Statement of Changes in General Fixed Assets 13 General Long -Term Debt Account Group: Statement of General Obligation Bonds Principal and Interest Requirements by Year of Maturity 14 Statement of Changes in General Long -Term Debt 15 Combined Statement of Cash Flow - All Proprietary Fund Types and Similar Trust Funds 16 Comparative Combined Balance Sheets - General and Special Revenue Funds 17 Comparative Combined Balance Sheets - Debt Service and Capital Improvement Funds 18 Comparative Combined Balance Sheets - Enterprise and General Insurance Funds 19 Comparative Combined Balance Sheets - General Fixed Assets and General Long -Term Debt 20 Comparative Combined Statement of Revenues, Expenditures And Changes in Fund Balances - General and Special Revenue Funds 21 CITY OF BLAIR, NEBRASKA TABLE OF CONTENTS Page Comparative Combined Statement of Revenues, Expenditures And Changes in Fund Balances - Debt Services and Capital Improvements Funds 22 Comparative Combined Statement of Revenues, Expenditures And Changes in Retained Eamings/Fund Balances - Enterprise and Insurance Funds 23 NOTES TO FINANCIAL STATEMENTS 24-32 SPECIAL REVENUE FUNDS: Combining Balance Sheet 33 Combining Schedule of Revenues, Expenditures and Changes in Fund Balances - Special Revenue Funds 34-35 Individual Statement of Gross Proceeds Distribution ' and Changes in Fund Balance - Budget and Actual - Special Revenue Funds - Keno Fund 36 Individual Statement of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual - Street Fund 37 Individual Statement of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual - M.I.R.F Fund 38 Individual Statement of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual - Sales Tax Fund 39 Individual Statement of Revenues, Expenditures and Changes in Fund Balance - Budget and Actual - Revolving Loan Fund 40 ENTERPRISE FUNDS: Combining Balance Sheet 41-42 Combining Statement of Revenues, Expenses, and Changes in Retained Earnings 43 Combining Statement of Cash Flow 44-45 Individual Statement of Revenues and Expenses - Budget and Actual - Water 46-47 Individual Statement of Revenues and Expenses - Budget and Actual - Sewer 48 SUPPORTING SCHEDULES: Schedule of General Fund Revenues - Budget i and Actual 49 Schedule of General Fund Expenditures - Budget and Actual - Administration Department 50 Schedule of General Fund Expenditures - Budget and Actual - Contingency Allowance 51 CITY OF BLAIR, NEBRASKA TABLE OF CONTENTS Paqe Schedule of General Fund Expenditures - Budget and Actual - Police Department 52 Schedule of General Fund Expenditures - Budget and Actual - Cemetery 53 Schedule of General Fund Expenditures - Budget and Actual - Fire Department 54 Schedule of General Fund Expenditures - Budget and Actual - Park Department 55 Schedule of General Fund Expenditures - Budget and Actual - Library 56 Schedule of General Fund Expenditures - Budget and Actual - Supervised Recreation 57 Schedule of General Fund Expenditures - Budget and Actual - Swimming Pool 58 Schedule of General Fund Expenditures - Budget and Actual - Zoning 59 Schedule of General Fund Expenditures - Budget and Actual - Animal Control 60 Schedule of General Fund Expenditures - Budget and Actual - Donated Funds 61 Schedule of Transfers 62 Compliance and Internal Control over Financial Reporting 63-64 Internal Control over Compliance For Major Programs 65-66 Schedule of Federal Awards 67-68 Schedule of Findings and Questioned Costs 69-70 Data Collection Form 71-73 a - D U z O U U Q Z Q CO �W-- ON �- Z 0 oM Z CC cc Z) W LL Co J � m Q LL IL 0 I— W } w U) U T- U) Cn W U z Q co 0 W z :Eco G O U O 0 0 0 0 0 0 0 O O C7 r 0 d' +J N 0~0 O U) a � 000 r- 00 J N CO r r r Co K} H3 15 3 O 0 0 0 0 0 0 0 O O O 00 O O " "Q N CO CO V C X U) M C7 LL Q O O O O 0 0 0 0 0 0 0 It O O 001- t� C3 C a � C2 CCa a LL a) N 0 co U- U C 69- ta N rM- a) 0 It O L LO O M O 00 Q0 Q cn co N co LO ca to It CO LLLO Ln d' LO T O0 LL IL r r d H} r 64 a) O o T 0 0 0 0 O O O O� C E O co d T CL 0 (0 to M 0 a T r� am Co Co E N Q T oMor�r�oo 0 0 0 00 00 s 0 0 (0 O N N a)co LO co M N co C Ca) O r CO U- N N M 6 c o 0 0 0 a) 0 0 Il- O o 00 E a)aa) ca •� i 1_ O w 0 Ln co T 60- In O o o O N 0 0 O o O O O I� I" O O W a) Na) dT d0 Q U 64 69- a) � U ++ fif Q a)o CL V p U E a) L Oi W C a) U U a) C) ° a� CD a) CU) a) O -Q O Q S> J a i W a 0 N o � a) O� a) Q O Q tZ C .tZ CO *r -Q i U cn CL - E0 0> o� W . o uc+o C) cc 0SCLaC CL Q Q U c O E c c co LL O (n a) 0 z a) a) U) CO CL D O rr 0 I— z D O U U Q q O Y z Q Q O >- ri: CLN W ~ O z Q M Z) W U- m m —� W LL Q h - O 1- w W U = W U z g Q m W z_ m G O U It O O O O O d' O tet O 0 0 0 0 0 0 +- O O O CO CZ C a) + O ti O T (D T O T O 0 J M M M j0 0 0 0 0 0 0 0 O O O O O O O MO O t`6 O M co M Q C X N M M M LL Q O O O � h � �} EF? co 0 0 0 0 0 0 O O O O T[Y O It lT U)r t CM CCl CO D) U Q O r r r- 00 LL. N M Cl) Cl) LL i3 C= Eg 16p, O (D �- N 0 00 OO co d' O O O 00 M (D CD O M O O O d' M O Co N N h It� I" tl) 0) LO M co M N C O O- '_ r- N(6 r M V U) M LC) r- O(6 i 1� CL L*- L LCL ( M CD N LO Cl)t LO t- CF) N co M V+ 00 T T r r W Cn to N CO CL 61} O0 0 0 0 0 0 0 0 O 000000 OM ..ee V E co T T T c� o rn U Q rn rn M M M 6{} Ica N Q O r 0 0 d O O lf) O COOMOM Co U 0) co O N N N 0 m r- r It co co � It Cn N N Co LL Cf) T T T T N m 60. ia N dT O O O O O O O 0 0 0 (D 0 _ d M Co CO co Cfl i O> M M_ M N M C(D co M It �> T T L7 W 0 O N O O O O O O N N al r 0 C CMS f-- O 00 r l7 Cl O O N 00 Cl) W CD CD O m M M T O M COo It a cu z 6a U a� a� w a o z > a� C:>, � a U) a�`CL LDC: �C: L_ O c N CL 0) a = J co ° °- a ai ai Q c a � c 0 a a *N-' N Q� O 0 a J 0 0 N+ In C� N C G D v C) Q- CD C > N O O N C O> Nx C += G) 4J S O F- Z O Z) U U U Q Q Q o w m 0C 0E oC CC U- U- �— u. It CITY OF BLAIR, NEBRASKA COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE ALL GOVERNMENT FUND TYPES FOR THE TWELVE MONTHS ENDED SEPTEMBER 30. 2000 Debt Special General Service Revenue REVENUES: Taxes Street revenues Keno proceeds M.I.R.F. revenues Charges for services Special assessment interest Interest income Grants Other revenues Total revenues EXPENDITURES: Administration Contingency allowance Police Department Cemetery Fire Department Parks Department Library Supervised recreation Swimming pool Zoning Animal control Donated funds Keno expense M.I.R.F. fund expenses Collection fees Street expense Cargill - City share Street improvement Fire station Debt service: Bonding costs Redemption of bonds Bond interest Warrant interest Total expenditures REVENUES OVER (UNDER) EXPENDITURES -continued- $ 1,092,678 $ 61,576 0 0 0 0 0 0 270,745 0 0 53,037 19,204 30,915 0 0 648,637 0 2,031,264 145,528 0 835,475 1,231 15,646 0 756,117 0 154,040 0 470,615 0 169,908 0 175,306 0 62,108 0 332,491 0 70,929 0 46,133 0 11,246 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 393,663 0 156,294 0 70,363 3,100,014 621,551 $ 926,213 851,056 81,709 76,519 0 0 50,622 76,272 Capital Improvement Fund $ 0 0 0 0 0 0 345,848 0 0 345,848 2,100 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 100,000 0 0 0 0 0 0 166,694 0 0 0 28,585 0 796,496 0 20,000 0 3,261 0 632,261 0 0 0 0 0 0 0 0 0 0 0 1,649,397 100,000 $ (1,068,750) $ (476,023) $ 412,994 $ 245,848 See Notes to Financial Statements 5 CITY OF BLAIR, NEBRASKA COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE ALL GOVERNMENT FUND TYPES FOR THE TWELVE MONTHS ENDED SEPTEMBER 30. 2000 -continued- REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES): Street district construction Bond proceeds Operating transfers - in Operating transfers - out REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES FUND BALANCE September 30, 1999 FUND BALANCE September 30, 2000 Debt Special Capital General Service Revenue Improvement Fund Fund Fund Fund $ (1,068,750) $ (476,023) $ 412,994 $ 245,848 0 0 (96,841) 0 0 0 0 0 1,237,611 0 114,888 0 (307,389) (330,525) (285,685) (481,814) (138,528) (806,548) 495,452 2,095,771 145,356 (235,966) 988,510 4,173,146 $ 356,924 $ 1,289,223 $ 1,133,866 $ 3,937,180 See Notes to Financial Statements 6 CITY OF BLAIR, NEBRASKA COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL GENERAL FUND FOR THE TWELVE MONTHS ENDED SEPTEMBER 30-2000 See Notes to Financial Statements 7 Variance Favorable (Unfavorable) $ 56,678 55,955 (17,596) (2,007,792) (1,912,755) 916,261 9,354 132,720 22,528 612,150 35,925 5,340 1,468 (24,956) 20,571 8,694 14,317 1,754,372 $ (158,383) 695,797 (307,389) $ 230,025 Budget Actual REVENUES: Taxes $ 1,036,000 $ 1,092,678 Charges for services 214,790 270,745 Interest income 36,800 19,204 Other revenues 2,656,429 648,637 Total revenues 3,944,019 2,031,264 EXPENDITURES: Administration 1,751,736 835,475 Contingency allowance 25,000 15,646 Police Department 888,837 756,117 Cemetery 176,568 154,040 Fire Department 1,082,765 470,615 Parks Department 205,833 169,908 Library 180,646 175,306 Supervised recreation 63,576 62,108 Swimming pool 307,535 332,491 Zoning 91,500 70,929 F Animal control 54,827 46,133 r' Donated funds 25,563 11,246 Total expenditures 4,854,386 3,100,014 REVENUES OVER (UNDER) EXPENDITURES $ (910,367) $ (1,068,750) OTHER FINANCING SOURCES (USES): r Operating transfers - in 541,814 1,237,611 Operating transfers - out 0 (307,389) REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER SOURCES (368,553) (138,528) FUND BALANCE - September 30, 1999 495,452 495,452 FUND BALANCE - September 30, 2000 $ 126,899 $ 356,924 See Notes to Financial Statements 7 Variance Favorable (Unfavorable) $ 56,678 55,955 (17,596) (2,007,792) (1,912,755) 916,261 9,354 132,720 22,528 612,150 35,925 5,340 1,468 (24,956) 20,571 8,694 14,317 1,754,372 $ (158,383) 695,797 (307,389) $ 230,025 CITY OF BLAIR, NEBRASKA COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL DEBT SERVICE FUND FOR THE TWELVE MONTHS ENDED SEPTEMBER 30.2000 See Notes to Financial Statements Variance Favorable (Unfavorable) $ 2,760 0 11,537 0 15,915 0 (720) 0 (38,663) (4,745) (70,363) (114,491) $ (84,279) 0 0 (330,525) $ (414,804) Budget Actual REVENUES: Taxes $ 58,816 $ 61,576 Special assessments 0 0 Special assessment interest 41,500 53,037 Developers down payment 0 0 Interest income 15,000 30,915 Other revenues 0 0 Total revenues 115,316 145,528 EXPENDITURES: Administration 511 1,231 Bonding costs 0 0 Redemption of bonds 355,000 393,663 Bond interest 151,549 156,294 Warrant interest 0 70,363 Total expenditures 507,060 621,551 REVENUES OVER (UNDER) EXPENDITURES $ (391,744) $ (476,023) OTHER FINANCING SOURCES (USES): Bond proceeds 0 0 Operating transfers - in 0 0 Operating transfers - out 0 (330,525) REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER SOURCES (391,744) (806,548) FUND BALANCE - September 30, 1999 2,095,771 2,095,771 FUND BALANCE - September 30, 2000 $ 1,704,027 $ 1,289,223 See Notes to Financial Statements Variance Favorable (Unfavorable) $ 2,760 0 11,537 0 15,915 0 (720) 0 (38,663) (4,745) (70,363) (114,491) $ (84,279) 0 0 (330,525) $ (414,804) CITY OF BLAIR, NEBRASKA COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL SPECIAL REVENUE FUND FOR THE TWELVE MONTHS ENDED SEPTEMBER 30. 2000 OTHER FINANCING SOURCES (USES): Street district construction Budget Actual REVENUES: 700,000 114,888 Sales and occupation tax $ 791,998 $ 926,213 Keno net proceeds 65,000 81,709 MIRF revenues 70,386 76,519 Street revenues 797,540 851,056 Grants 90,000 76,272 Interest income 39,360 50,622 Total revenues 1,854,284 2,062,391 EXPENDITURES: Keno expense 239,153 166,694 Collection fees and refunds 25,200 30,685 Cargill - City share 105,000 20,000 Community betterment 16,000 0 Street expenses 1,048,388 799,757 Downtown project 98,000 0 Fire Station 600,000 632,261 Total expenditures 2,131,741 1,649,397 REVENUES OVER (UNDER) EXPENDITURES $ (277,457) $ 412,994 OTHER FINANCING SOURCES (USES): Street district construction (700,000) (96,841) Operating transfers - in 700,000 114,888 Operating transfers - out (200,000) (285,685) REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER SOURCES (477,457) 145,356 FUND BALANCE - September 30, 1999 988,510 988,510 FUND BALANCE - September 30, 2000 $ 511,053 1,133,866 See Notes to Financial Statements E Variance Favorable (Unfavorable) $ 134,215 16,709 6,133 53,516 (13,728) 11,262 208,107 72,459 (5,485) 85,000 16,000 248,631 98,000 (32,261) 482,344 $ 690,451 603,159 (585,112) (85, 685) $ 622,813 CITY OF BLAIR, NEBRASKA COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL CAPITAL IMPROVEMENT FUND FOR THE TWELVE MONTHS ENDED SEPTEMBER 30. 2000 See Notes to Financial Statements 10 Variance Favorable Budget Actual (Unfavorable) REVENUES: Interest income $ 482,914 $ 345,848 $ (137,066) EXPENDITURES: Cemetery mower 2,700 0 2,700 Cemetery paving 4,000 0 4,000 Park equipment 3,500 0 3,500 Bath house 100,000 100,000 0 Pool painting 0 0 0 Total expenditures 110,200 100,000 10,200 REVENUES OVER (UNDER) EXPENDITURES $ 372,714 $ 245,848 $ (126,866) OTHER FINANCING SOURCES (USES): Operating transfers - in 0 0 0 Operating transfers - out (481,814) (481,814) 0 REVENUES AND OTHER FINANCING SOURCES OVER (UNDER) EXPENDITURES AND OTHER SOURCES (109,100) (235,966) $ (126,866) FUND BALANCE - September 30, 1999 4,173,146 4,173,146 FUND BALANCE - September 30, 2000 $ 4,064,046 $ 3,937,180 See Notes to Financial Statements 10 W J U Q Q Z O Q LLL N Q Z U M QQDti W F- m Q W W 2 75 Y W � — W NaCID 20- Q W W(n U) CC U (6 Z z Lu < o c W m W W Q�Qa() m rr : H LL W LLL Q Z °�D7 CJ WZcrJ W Q H � W� W U) W d = W Q rr rr CD � Cl- W Z Q O — U N C n LL (1) �L D U Q rn o O O to W-1. • • w I O (O m ( OD lI00-0 CD O 7 Q Efl OD ( 0 O 0 It O r- Oo It co LO 6a Cl) O O (O () � N to O N r• r h N N 69. c0O (o Lo N Cl) O CV N 0000000 O Cl) Cl) o O O O 0) of v" 0 0 0 0 0 O �t 0 0 o U Cr) (o r O CO 0000000 N0) O O N � N O O O Cf) m r O O �t r co to F d' o l od m Or 00(00(0 It r - N0) (O O N � N 0 6a N N to r � � f Or 00(00(0 It r - N0) (O O N � N 00U) 0) Cl)It 0 6a — (D LD r• d C7 �t N U LOO OOD - � o Cl) I � (Dcl) r• r O )) CO It r, O O O (C) (O LO tf) It N N 0000001 O (p (O N r N dt M N O 0 6a 0000001 co*) o co 000000 0 N 0 r ui to h r O ( CD It 0 Cl) rn r- T L N 0) N I O .�- � LO N OcoO O o 0 0 It 0-0 o (O O Ch r• O N O O (O (O It r N LO r• C7 00c�cOoNrno N r N dt M N O 0 �� LO 2 to O N to h r O ( CD It 0 Cl) rn r- T L N 0) N I O .�- � LO N OcoO O o 0 0 It 0-0 o (O O Ch r• O N O O (O (O It r N LO r• C7 U U Z Z g � m m o W D D W c N a� J d .4 X c o LL (n u\ m Z � �.Q W (0 U) (n O rn (Do jcn � U cn a N o O U W c a) °-) °) U) �n UJ 0 Z_ a) Z Z_ N Z Lu c c CL c Z D O a) Z U E rn c m t2 o W o tz U' a) v a) �- N N a 0 o U > .L C) Q o W co LU co Z �i v o W N aXi Z � •� m O D n 1= a) 4-- c O L F- O .� cu U a) N t- Q b i) i) c N cu Z E Z () E Z a) Q a) LS a) a) � z W i N E a) E a >l iu cc LY > W= a) a� c (D Q CL Q a W ro N �0 d a� (L0:ECC a a) a) (u W m0 2 r= c 5 c o n. Q a) m O�� ~O --m00 Z Wm am CITY OF BLAIR, NEBRASKA STATEMENT OF GENERAL FIXED ASSETS SEPTEMBER 30, 2000 Land Buildings Vehicles Equipment GENERAL FUND: Total Administration $ 65,000 $ 936,683 $ 10,450 $ 150,137 $ 1,162,270 Police 0 0 117,432 84,941 202,373 Cemetery 115,000 89,606 14,553 29,698 248,857 Fire 0 1,334,257 642,487 72,663 2,049,407 Park 97,952 481,002 27,951 315,357 922,262 Library 22,500 116,600 0 67,002 206,102 Supervised recreation 0 11,343 13,385 15,940 40,668 Swimming pool 100,000 808,305 0 164,538 1,072,843 Animal control 0 9,936 13,450 2,566 25,952 0 SPECIAL REVENUE 0 FUNDS - Street 10,000 213,878 293,808 361,985 879,671 0 CAPITALIZED LEASE - 0 Library 0 203,404 0 0 203,404 TOTALS $ 410,452 $ 4,205,014 $ 1,133,516 $ 1,264,827 $ 7,013,809 See Notes to Financial Statements 12 CITY OF BLAIR, NEBRASKA STATEMENT OF CHANGES IN GENERAL FIXED ASSETS FOR THE YEAR ENDED SEPTEMBER 30, 2000 Balance Balance Sept. 30 Sept. 30 1999 Additions Dispositions 2000 GENERAL FUND: Administration $ 1,150,972 $ 11,298 $ 0 $ 1,162,270 Police 182,350 20,023 0 202,373 Cemetery 188,045 60,812 0 248,857 Fire 1,005,493 1,043,914 0 2,049,407 Park 864,421 57,841 0 922,262 Library 199,871 6,231 0 206,102 Supervised Recreation 26,023 14,645 0 40,668 Swimming pool 565,910 506,933 0 1,072,843 Animal control 25,952 0 0 25,952 SPECIALIZED REVENUE FUNDS - Street 879,671 0 0 879,671 CAPITALIZED LEASE - Library 203,404 0 0 203,404 TOTALS $ 5,292,112 $ 1,721,697 $ 0 $ 7,013,809 See Notes to Financial Statements 13 CITY OF BLAIR, NEBRASKA STATEMENT OF GENERAL OBLIGATION BONDS PRINCIPAL AND INTEREST REQUIREMENTS BY YEAR OF MATURITY SEPTEMBER 30, 2000 Year Ending Principal Interest September 30. Requirements Requirements Total 2001 $ 385,829 $ 140,835 $ 526,664 2002 381,265 123,990 505,255 2003 375,000 107,780 482,780 2004 395,000 91,103 486,103 2005 390,000 73,115 463,115 2006 365,000 55,005 420,005 2007 290,000 40,663 330,663 2008 255,000 27,461 282,461 2009 220,000 15,962 235,962 2010 35,000 5,997 40,997 2011 35,000 4,107 39,107 2012 40,000 2,200 42,200 T3,167,094 $ 688,218 $ 3,855,312 See Notes to Financial Statements 14 CITY OF BLAIR, NEBRASKA STATEMENT OF CHANGES IN GENERAL LONG-TERM DEBT FOR THE YEAR ENDED SEPTEMBER 30, 2000 Balance Balance Interest Sept 30, Sept 30, Dated Description Rate 1999 Additions Deductions 2000 z 10/15/91 Fire Department r bonds 5.00-6.20% $ 25,000 $ 0 $ 25,000 $ 0 02/15/94 Various purpose 3.00-4.70% 105,000 0 20,000 85,000 03/01/95 Various purpose 5.10-5.95% 175,000 0 25,000 150,000 r, 01/15/96 Various purpose 5.90-4.80% 580,000 0 70,000 510,000 06/15/97 Various purpose 4.45-5.50% 650,000 0 50,000 600,000 06/01/98 Various purpose 4.10-4.85% 345,000 0 30,000 315,000 04/15/99 Various purpose 3.50-4.40% 1,580,000 0 135,000 1,445,000 05/28/99 Rescue Unit 5.60% 100,757 0 38,663 62,094 } TOTAL $ 3,560,757 $ 0 $ 393,663 $ 3,167,094 r F See Notes to Financial Statements r 15 n CITY OF BLAIR, NEBRASKA COMBINED STATEMENT OF CASH FLOW ALL PROPRIETARY FUND TYPES AND SIMILAR TRUST FUNDS FOR THE TWELVE MONTHS ENDED SEPTEMBER 30. 2000 General Enterprise Insurance Funds Funds CASH FLOW FROM OPERATIONS: Net operating income (Loss) Adjustment to reconcile net income to net cash from operations: Depreciation Decrease (Increase) in accounts receivable -user fees Decrease (Increase) in accounts receivable -other Decrease (Increase) in inventory Decrease (Increase) in prepaid expenses Increase (Decrease) in accounts payable Decrease in accrued expenses Increase (Decrease) in deposits payable Net cash provided (used) by operations CASH-FLOW FROM NON -CAPITAL FINANCING: Transfers - in Transfers - out Cash flow used by non -capital financing CASH FLOW FROM CAPITAL AND RELATED FINANCING: Proceeds from long-term debt Payment of long-term debt Decrease (increase) in restricted assets Interest expense Bonding costs Increase (decrease) in accrued interest payable Cash from (used in) financing CASH FLOW FROM INVESTING: Purchase of property Utility district construction Interest income Decrease (increase) in accrued interest receivable Cash from (used by) investing NET INCREASE (DECREASE) IN CASH CASH AND CASH EQUIVALENTS - Beginning of the period $ 414,394 $ 441,196 (63,287) (45,174) (6,138) (230) 470,997 2,320 0 1,214,078 52,914 0 52,914 4,258,408 (3,960,000) 454,355 (212,611) (98,331) (54,395) 387,426 (2,296,638) (111,485) 155,857 20,155 (2,232,111) (577, 693) 2,110,006 8,836 L N 0 0 0 (1,687) 0 0 7,149 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 7,149 31,845 CASH AND CASH EQUIVALENTS - End of the period $ 1,532,313 $ 38,994 INTEREST PAID $ 267,007 $ 0 See Notes to Financial Statements, 16 CITY OF BLAIR, NEBRASKA COMPARATIVE COMBINED BALANCE SHEET GENERAL AND SPECIAL REVENUE FUND AS OF SEPTEMBER 30, 1999 AND SEPTEMBER 30. 2000 Accounts payable Accrued expenses Deposit payable Revenue bonds payable Total Liabilities FUND EQUITY Fund balance - reserved Fund balance - unreserved Total Fund Equity TOTAL LIABILITIES AND FUND EQUITY $ 80,482 26,471 13,600 $ 51,411 32,922 18,800 $ 512,562 3,832 0 $ 328,414 3,394 0 120,553 103,133 516,394 331,808 0 0 495,452 356,924 495,452 356,924 988,510 1,133,866 988,510 1,133,866 $ 616,005 $ 460,057 1 1,504,904 $ 1,465,674 See Notes to Financial Statements 17 SPECIAL GENERAL REVENUE FUNDS FUNDS 1999 2000 1999 2000 ASSETS Cash and equivalents $ 557,459 $ 419,445 Receivables; Billed user fees 0 0 Accrued interest 559 0 $ 1,169 Other 0 0 725,641 $ 576,991 Due from County Treasurer 57,987 40,612 21,570 10,899 Restricted assets - cash and investment - at cost 0 0 756,524 877,784 TOTAL ASSETS $ 616,005 $ 460,057 $ 1,504,904 $ 1,465,674 LIABILITIES Accounts payable Accrued expenses Deposit payable Revenue bonds payable Total Liabilities FUND EQUITY Fund balance - reserved Fund balance - unreserved Total Fund Equity TOTAL LIABILITIES AND FUND EQUITY $ 80,482 26,471 13,600 $ 51,411 32,922 18,800 $ 512,562 3,832 0 $ 328,414 3,394 0 120,553 103,133 516,394 331,808 0 0 495,452 356,924 495,452 356,924 988,510 1,133,866 988,510 1,133,866 $ 616,005 $ 460,057 1 1,504,904 $ 1,465,674 See Notes to Financial Statements 17 CITY OF BLAIR, NEBRASKA COMPARATIVE COMBINED BALANCE SHEET DEBT SERVICE AND CAPITAL IMPROVEMENT FUNDS AS OF SEPTEMBER 30.1999 AND SEPTEMBER 30. 2000 See Notes to Financial Statements 18 DEBT CAPITAL SERVICE IMPROVEMENT FUNDS FUNDS 1999 2000 1999 2000 ASSETS Cash and equivalents $ 526,560 $ 618,401 $ 114,591 $ 16,879 Receivables: Special assessments 2,678,380 2,185,623 0 0 Accrued interest 0 0 174,795 168,817 Other 50,379 31,047 0 0 Due from County Treasurer 3,690 2,227 0 0 Contract receivable - OPPD 0 0 3,883,760 3,751,484 TOTAL ASSETS $ 3,259,009 $ 2,837,298 $ 4,173,146 $ 3,937,180 LIABILITIES Accounts payable 0 0 Accrued interest $ 11,730 $ 73,991 0 0 Registered warrants 1,151,508 1,474,084 0 0 Total Liabilities 1,163,238 1,548,075 0 0 FUND EQUITY Fund balance - reserved 2,095,771 1,289,223 0 0 Fund balance - unreserved 0 0 $ 4,173,146 $ 3,937,180 Total Fund Equity 2,095,771 1,289,223 4,173,146 3,937,180 TOTAL LIABILITIES AND FUND EQUITY $ 3,259,009 $ 2,837,298 $ 4,173,146 $ 3,937,180 See Notes to Financial Statements 18 CITY OF BLAIR, NEBRASKA COMPARATIVE COMBINED BALANCE SHEET ENTERPRISE AND GENERAL INSURANCE FUNDS AS OF SEPTEMBER 30 1999 AND SEPTEMBER 30 2000 ENTERPRISE FUNDS 1999 2000 GENERAL INSURANCE FUNDS 1999 2000 ASSETS Cash and equivalents $ 2,110,006 $ 1,532,313 Receivables: Billed user fees 476,012 539,299 Accrued interest 24,029 3,874 Other 6,367 51,541 Inventory 24,515 311414 Prepaid expenses 1,525 994 Restricted assets - cash and investment - at cost 893,855 439,500 $ 31,845 $ 38,994 Property - net of accumulated depreciation, where applicable 9,661,989 11,517,431 0 0 TOTAL ASSETS $ 13,198,298 $ 14,116,366 $ 31,845 $ 38,994 LIABILITIES Accounts payable $ 60,299 $ 531,296 $ 2,840 $ 1,153 Accrued interest 117,132 62,737 0 0 Accrued expenses 24,082 26,402 0 0 Deposits payable 1,700 1,700 0 0 Revenue bonds payable 5,055,000 5,353,408 0 0 Total Liabilities 5,258,213 5,975,543 2,840 1,153 FUND EQUITY Contributed capital 4,825,934 4,825,934 0 0 Retained earnings - reserved 893,855 439,500 0 0 Retained earnings - unreserved 2,220,296 2,875,389 0 0 Fund balance - reserved 0 0 29,005 37,841 Total Fund Equity 7,940,085 8,140,823 29,005 37,841 TOTAL LIABILITIES AND FUND EQUITY $ 13,198,298 $ 14,116,366 $ 31,845 $ 38,994 See Notes to Financial Statements 19 CITY OF BLAIR, NEBRASKA COMPARATIVE COMBINED BALANCE SHEET GENERAL FIXED ASSETS AND GENERAL LONG-TERM DEBT AS OF SEPTEMBER 30 1999 AND SEPTEMBER 30. 2000 See Notes to Financial Statements 20 GENERAL GENERAL FIXED LONG-TERM ASSETS DEBT 1999 2000 1999 2000 ASSETS Property - net of accumulated depreciation, where applicable $ 5,292,112 $ 7,013,809 Amount available in Debt Service for general long-term debt retirement 0 0 $ 2,095,771 $ 1,289,223 Amount to be provided for retirement for general long-term debt 0 0 1,464,986 1,877,871 TOTAL ASSETS $ 5,292,112 $ 7,013,809 $ 3,560,757 $ 3,167,094 LIABILITIES Bonds payable 0 0 $ 3,560,757 $ 3,167,094 Total Liabilities 0 0 3,560,757 3,167,094 FUND EQUITY Investment in general fixed assets $ 5,292,112 $ 7,013,809 0 0 TOTAL LIABILITIES AND FUND EQUITY $ 5,292,112 $ 7,013,809 $ 3,560,757 $ 3,167,094 See Notes to Financial Statements 20 CITY OF BLAIR, NEBRASKA COMPARATIVE COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE GENERAL AND SPECIAL REVENUE FUNDS FOR THE TWELVE MONTHS ENDED SEPTEMBER 30 2000 GENERAL FUNDS REVENUES: 1999 Taxes $ 1,067,661 Keno net proceeds 0 Street revenues 0 M.I.R.F. revenues 0 Charges for services 207,972 Interest income 23,542 Grants 0 Other revenues 202,139 Total revenues 1.501.314 EXPENDITURES: Administration Contingency allowance Police Department Cemetery Fire Department Parks Department Library Supervised recreation Swimming pool Zoning Landfill Animal control Donated funds Keno expense Fire Station Development Street Cargill - City share Total expenditures REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES) Street District construction Operating transfers - in Operating transfers - out 305,479 10,558 751,745 95,235 169,564 136,286 155,777 45,118 83,685 85,423 0 46,376 6,697 0 0 0 0 0 1,891,943 (390, 629) ��� $ 1,092,678 0 0 0 270,745 19,204 0 648.637 1,U31 ,2b4 835,475 15,646 756,117 154,040 470,615 169,908 175,306 62,108 332,491 70,929 0 46,133 11,246 0 0 0 0 0 (1,068,750) SPECIAL REVENUE FUNDS 1999 2000 $ 1,192,557 $ 926,213 50,503 81,709 507,726 851,056 16,998 76,519 0 0 51,158 50,622 462,720 76,272 0 0 2,281,662 2,062,391 26,223 30,685 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 16,156 166,694 254,279 632,261 0 0 2,848,261 799,757 0 20,000 3,144,919 1,649,397 (863,257) 412,994 0 0 (695,757) (96,841) 370,711 1,237,611 1,423,818 114,888 (100,000) (307,389) (140,259) (285,685) REVENUES AND OTHER FINANCIAL SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES (119,918) (138,528) (275,455) 145,356 FUND BALANCE - BEGINNING 615,370 495,452 1,263,965 988,510 FUND BALANCE - ENDING $ 495,452 $ 356,924 $ 988,510 $ 1,133,866 See Notes to Financial Statements 21 CITY OF BLAIR, NEBRASKA COMPARATIVE COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE DEBT SERVICE AND CAPITAL IMPROVEMENTS FUNDS FOR THE TWELVE MONTHS ENDED SEPTEMBER 30 2000 DEBT CAPITAL SERVICE IMPROVEMENT FUNDS FUNDS REVENUES: Taxes and special assessments Interest income Other revenues Total revenues EXPENDITURES: Administration Pool painting Bath house Heavy equipment Debt service: Bonding costs Redemption of bonds Bond interest Total expenditures REVENUES OVER (UNDER) EXPENDITURES OTHER FINANCING SOURCES (USES): Bond proceeds Operating transfers - in Operating transfers - out REVENUES AND OTHER FINANCIAL SOURCES OVER (UNDER) EXPENDITURES AND OTHER USES FUND BALANCE - BEGINNING FUND BALANCE - ENDING 1999 2000 1999 2000 $ 949,544 $ 61,576 32,640 30,915 $ 356,396 $ 345,848 0 53,037 0 0 982,184 145,528 356,396 345,848 1,315 1,231 0 0 0 0 7,000 0 0 0 0 100,000 0 0 0 0 23,700 393,663 0 0 1,580,601 156,294 0 0 147,190 70,363 0 0 1,752,806 621,551 7,000 100,000 (770,622) (476,023) 349,396 245,848 1,700,950 0 0 0 47,367 0 100,000 0 (1,605,027) (330,525) (481,815) (481,814) (627,332) (806,548) (32,419) (235,966) 2,723,103 2,095,771 4,205,565 4,173,146 $ 2,095,771 $ 1,289,223 $ 4,173,146 $ 3,937,180 See Notes to Financial Statements 22 CITY OF BLAIR, NEBRASKA COMPARATIVE COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN RETAINED EARNINGS/FUND BALANCE ENTERPRISE AND INSURANCE FUNDS FOR THE TWELVE MONTHS ENDED SEPTEMBER 30 2000 ENTERPRISE INSURANCE FUNDS FUNDS OPERATING REVENUES: User fees Sale of merchandise Insurance contributions Other Total EXPENSES: Personal services Operating expenses Materials and supplies Rental expense Depreciation Payments of insurance benefits Total 1999 2000 $ 2,502,561 19,392 0 28,282 2,550,235 610,623 546,063 392,664 2,230 422,809 1,974,389 $ 2,706,463 20,780 0 2,745,519 648,010 515,287 723,499 3,133 441,196 0 2,331,125 OPERATING INCOME (LOSS) 575,846 414,394 OTHER REVENUE (EXPENSES): 0 0 Utility district construction (161,111) (111,485) Interest income 115,692 155,857 Interest expense (263,051) (212,611) Bonding costs (48,413) (98,331) Operating transfers - in 395,119 52,914 Operating transfers - out (9,913) 0 NET INCOME (LOSS) 604,169 200,738 RETAINED EARNINGS/FUND BALANCE Beginning 2,509,982 3,114,151 RETAINED EARNINGS/FUND BALANCE Ending $ 3,114,151 $ 3,314,889 See Notes to Financial Statements 23 1999 2000 $ 87,328 $ 90,696 0 0 0 0 0 0 0 0 0 0 83,597 83,670 83,597 83,670 3,731 7,026 0 0 1,423 1,810 0 0 0 0 0 0 0 0 5,154 8,836 23,851 29,005 $ 29,005 $ 37,841 CITY OF BLAIR, NEBRASKA NOTES TO FINANCIAL STATEMENTS SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES A. Introduction: The City of Blair (City) complies with Generally Accepted Accounting Principles, (GAAP). The City's reporting entity applies relevant Governmental Accounting Standards Board (GASB) pronouncements. Proprietary funds and similar component units apply FINANCIAL ACCOUNTING STANDARDS BOARD (FASB) pronouncements and ACCOUNTING PRINCIPLES BOARD (APB) opinions issued on or before November 30, 1989 unless those pronouncements conflict with or contradict GASB pronouncements, in which case, GASB prevails. Implementation of any accounting and reporting standards are included in this report where applicable, Comparability with previous years financial reports is not affected. The accounting and reporting framework and the more significant accounting principles and practices are discussed in subsequent sections of this note. The remainder of the notes are organized to provide explanations including required disclosures of the City's financial activities for the fiscal year ended September 30, 2000. B. Reporting Entity: All significant activities and organizations in which the City exercises oversight responsibility have been included in the City's general purpose financial statements for the year ended September 30, 2000. The following criteria regarding manifestation of oversight were considered by the City in its evaluation of City organizations and activities: Financial interdependency: The City is responsible for its debts and is entitled to surpluses. No separate agency receives a financial benefit nor imposes a financial burden on the City. Election of the government authority: The locally elected City Council is exclusively responsible for all public decisions and accountable for the decisions it makes. C. Fund Types and Account Groups: Governmental fund types: Governmental funds use the current financial resources measurement focus. Only current assets and current liabilities are generally included on their balance sheets. Their operating statements present sources and uses of available resources during a given period. 24 CITY OF BLAIR, NEBRASKA NOTES TO FINANCIAL STATEMENTS 1. SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES C. Fund Types and Account Groups: (continued) Proprietary fund types: Proprietary funds use the economic resources measurement focus. The accounting objectives are determinations of net income, financial position and cash flows. All assets and liabilities associated with a proprietary funds activities are included on its balance sheet. Proprietary fund equity is segregated into contributed capital and retained earnings. Fiduciary fund types: (trust and insurance funds), that are used to account for assets held by the City as an agent for private individuals or organizations or in trust Account groups: The account groups are used to account for fixed assets and long- term liabilities which are not reported in the respective governmental funds. D. Basis of Accounting: All Governmental Funds are accounted for using the modified accrual basis of accounting. Their revenues are recognized when earned and expenditures are recognized when incurred except that property taxes are not recorded until collected as they are not practicably measurable and interest on general obligation bonds is not recorded until coupons mature. The Proprietary and Fiduciary Funds accounted for using the accrual basis where revenues are recognized when earned and expenses are recognized when incurred. The City does not apply encumbrance accounting in any of its funds. E. Debt Service Fund: The Debt Service Fund is used to account for the payment of principal and interest on general long-term debt. The primary sources of revenue are property taxes and special assessments. F. Inventory: Inventory is stated at the lower of cost (first -in, first -out) or market value. The consumption method is used in regard to inventory expenditure recognition. 25 CITY OF BLAIR, NEBRASKA NOTES TO FINANCIAL STATEMENTS SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (continued) G. Budgetary Basis: The City's legally adopted budget is not in conformity with generally accepted accounting principles. The budget is prepared and adopted using the cash basis of accounting whereby revenues budgeted are expected to be received rather than earned and expenditures budgeted are expected to be disbursed rather than incurred. There are no significant differences between the budgeted basis of accounting and the generally accepted basis. The City Council sets the property tax levy needed to support the coming years budget in August of each year and submits its budget as required by State Statute. H. Budgetary Control: Each funds appropriated budget is prepared on a detailed line item basis. Revenues are budgeted by source. Expenditures are budgeted by department. This constitutes the legal level of control. Expenditures may not exceed appropriations at this level. All budget revisions at this level are subject to final review by the City Council. On September 14, 1999, the City Council amended the fiscal year September 30, 1999, budget increasing both sewer revenue and sewer disbursements for bond refinancing in the amount of $1,095,000. The process was done according to state law. There were no budget amendments for the year ended September 30, 2000. Cash and Cash Equivalents: For the purposes of the Statement of Cash Flows the City considers all short-term debt instruments purchases with a maturity of three months or less to be cash equivalents. Short-term investments are recorded at cost. J. Fixed Assets: All fixed assets are recorded at cost or estimated cost if actual cost not available. The Proprietary and Fiduciary Fund assets are presently on the respective balance sheets except for the cost of any underground water and sewer lines which are not included in the assets. Depreciation of the assets is computed on the straight-line method over the estimated useful lives of the assets as follows: Plant and buildings 25-40 years Equipment 5-10 years Assets in all other funds are recorded as expenditures at the time of purchase with the accumulated cost being presented in the general fixed asset group of accounts for measurement purposes only. Certain improvements such as roads, bridges, curbs and gutters, streets and sidewalks, drainage systems, and lighting systems are not capitalized. No depreciation is provided for assets in the general fixed asset group of accounts. 26 CITY OF BLAIR, NEBRASKA NOTES TO FINANCIAL STATEMENTS K. Compensated Absences: The City of Blair does not accrue compensated absences because the amount cannot be reasonably estimated. L. Deposits and Investments: Investments consist of Certificates of Deposit or U.S. Government Securities with current maturities. These investments have no restrictions. The deposits are entirely Category 1 which means that the investments are insured or collateralized with securities held by the entity's agent. Investments are stated at cost which approximates market value. Investments allowed are generally U.S. Government Securities, FDIC insured deposits and others provided by State Statute. Total deposits at September 30, 2000 were $3,943,316. 2. PROPERTY TAX CALENDAR The City's December 31, 1999 valuation was $295,822,825. The levy for the City for the year ending September 30, 2000 was .3483 per $100 of value. The total tax levy was $1,030,316, Property taxes are due December 31 of each year and delinquent in halves at May 1 and September 1, of the following year. The property taxes are collected and remitted to the City by the County. 3. RESTRICTED ASSETS Restricted assets consist of cash, certificates of deposit, and government securities. The total Debt Service fund balance is reserved for debt service. The other assets are restricted as follows: 2000 27 Special Enterprise Insurance Revenue Fund Funds Funds Keno funds $ 120,606 $ 0 $ 0 Street funds 339,656 0 0 M.I.R.F. funds 107,816 0 0 Sales tax funds 143,544 0 0 Revolving loan fund 166,162 0 0 Bond and Interest sinking fund 0 439,500 0 Reserve for insurance claims 0 0 38,944 Total restricted assets $877784 439 500 1-18_994 27 CITY OF BLAIR, NEBRASKA NOTES TO FINANCIAL STATEMENTS 3. RESTRICTED ASSETS (continued) Keno funds Street funds M.I.R.F. funds Sales tax funds Revolving loan fund Bond and Interest sinking fund Reserve for insurance claims Total restricted assets 4. LONG-TERM DEBT Water debt: Special Enterprise Insurance Revenue Fund Funds Funds $ 197,418 $ 0 $ 0 247,691 0 0 28,333 0 0 149,871 0 0 133,211 0 0 0 893,855 0 0 0 31,845 $ 756,524 $ 893,855 $ 31 845 Date Rate Total Department of Environmental Quality Bonds 8-09-00 4.03% $ 863,408 Water Revenue Bonds 6-15-00 4.70-5.55% $3,395,000 Annual Principal Requirements For Water Bonds Year Ending September 30, 2001 $ 170,000 2002 400,000 2003 447,500 2004 467,500 2005-2016 2,773,408 TOTAL $4258,408 28 CITY OF BLAIR, NEBRASKA NOTES TO FINANCIAL STATEMENTS 4. LONG-TERM DEBT (continued) Sewer debt: Date Rate Total Sewer Revenue Bonds 10-1-98 4.10-5.30% $1,095,000 Annual Principal Requirements For Sewer Bonds Year Ending September 30, 2001 $ 40,000 2002 40,000 2003 45,000 2004 45,000 4 2005-2014 925,000 TOTAL$1 095,000 F The City of Blair established a defeasance escrow on June 15, 2000 to provide for the redemption of the Series 1996 and 1999 water bonds at the earliest permissible redemption date. Proceeds from the June 15, 2000 Water Bond issue were put into the trust in an amount sufficient for this purpose. All bonding costs were expensed in the current period and no gain or loss was realized on the refunding. All non - refunded water debt is secured by an minimum water usage contract with Cargill, Inc. dated June 27, 2000. The total financing for water plant construction available from the Department of Environmental Quality loan dated August 9, 2000 is $6,815,700. The City had drawn $863,408 on the loan at September 30, 2000. There was no interest capitalized during 1999 or 2000. Sinking fund requirements for Water and Sewer debt were a reserve of $439,500 at September 30, 2000 and monthly sinking fund deposits based on the next principle and interest payment. Net working capital of the Enterprise Funds is $1,327,300 at September 30, 2000. 29 CITY OF BLAIR, NEBRASKA NOTES TO FINANCIAL STATEMENTS 5, PENSION PLANS (continued) The City has two pension plans covering substantially all of its employees. Employees other than policemen are covered by a defined contribution plan. All contributions up to 5% of gross wage in employee contributions and 5% of gross wage in contributions from the City are invested with an investment manager. The employees must have accumulated six months of service, be at least age 21, and work 40 hours per week to participate in the plan. Employees are 100% vested in employer contributions after seven years of service. The plan is a single employer plan with the City maintaining fiduciary responsibility for it. Contributions for the periods ended September 31, 1999 and September 30, 2000, were $75,948 and $79,376 respectively. Contributions are expected to remain relatively level from year to year. The 2000 covered payroll and total payroll were $793,760 and $1,038,555 respectfully. The policemen are covered under a defined benefit plan established by the statutes of the State of Nebraska. Policemen terminating before retirement age receive payment for their contributions to date of termination plus interest accrued and the vested portion of the City's contributions based on the statutes of the State of Nebraska. The City has fiduciary responsibility for the plan and it is a single employer plan only. Contributions of $55,786 for 1999 and $53,140 for 2000, were 12% of gross wages which compiles with statutory requirements. The City contributed 6 percent of gross wages and the policemen contributed 6 percent. The City has no material pension benefit obligations as of September 30, 2000. The City does expect contributions to remain relatively level from year to year. The contributions are not actuarially determined. All qualifying police payroll f was covered in 1999 and 2000. C. During the year ended September 30, 1984, the City transferred police pension funds to an independent trustee for investment. The trustee will maintain the fund according to state law. Contributions to the trustee were reported as an expenditure. 6. OTHER ASSET - ELECTRIC PLANT CONTRACT In April 1984, the City of Blair contracted to sell its electrical transmission and distribution generating facilities to the Omaha Public Power District. The terms of the agreement were as follows: Omaha Public Power District agreed to buy the City of Blair facilities for the sum of $5,950,000. The terms of payment shall be $1,000,000 payable at the date of the contract and the balance of $4,950,000 amortized over thirty years at nine percent interest per annum, with annual payments of $481,815 commencing in April 1985. This contract is unsecured. This contract also provided for the Omaha Public Power District to supply electrical service directly to the City and its residents. The transfer of electrical services was completed on September 30, 1984. 30 CITY OF BLAIR, NEBRASKA NOTES TO FINANCIAL STATEMENTS 7. LANDFILL CLOSURE The City of Blair has closed its landfill operations. All material closing and monitoring costs were accrued over the remaining life of the landfill. The Landfill closed October 31, 1993 and any remaining monitoring costs will be paid from City funds but are not anticipated to be material to the financial statements. 8. ACCOUNTS RECEIVABLE - SPECIAL ASSESSMENTS The City of Blair's special assessments outstanding as of September 30, 1999 and September 30, 2000, are composed of the following: 1999 2000 Special assessment principle $ 956,663 $2,185,623 Special assessments available not levied 1,721,717 0 Total Special Assessments Receivable $2,678,380 2 185 623 The delinquent special assessments at September 30, 2000 are 12% of those outstanding. 9. INSURANCE FUND 1 The City of Blair self -insures certain dental and eye benefits for its employees. Funds were contributed from various funds into the insurance fund for proper allocation. The contributions into the fund for September 31, 1999 and September 30, 2000, were $79,117 and $90,696 respectively. Dental and vision benefits are limited and do not create significant risk for the City. 10. CONCENTRATION OF CREDIT RISK All of the receivables of the City of Blair proprietary funds and special assessments in the debt service fund are from the local Blair area therefore creating a concentration of credit risk. If the Blair area economy was depressed this could have an adverse effect on the collection of the outstanding accounts receivable. There were no material doubtful accounts at September 30, 1999 or 2000, Cargill, Inc, is a major water customer for the City. Cargill, Inc. represented 56% of water sales for the year ended September 30, 2000. 11. DEFICIT FUND BALANCE The City of Blair sewer fund had a deficit fund balance of $1,071,970 as of September 30, 2000. The deficit is the result of depreciation in excess of revenues. The General Fund, Debt Service Fund and Capital Outlay Fund had excess expenses over revenues for September 30, 2000. 31 CITY OF BLAIR, NEBRASKA NOTES TO FINANCIAL STATEMENTS 12. REGISTERED WARRANTS The City of Blair has $1,474,084 of outstanding registered warrants at September 30, 2000. The warrants are due currently and bear an average interest rate of 4.73%. The accrued interest at September 30, 2000, was $73,991. 13. SUBSEQUENT EVENT — VARIOUS PURPOSE BONDS The City of Blair issued $930,000 of various purpose bonds on October 15, 2000. The bonds are due from October 15, 2001 to October 15, 2015 with interest of 4.65% to 5.50%. Bond proceeds were to retire outstanding Registered Warrants. 32 - CITY OF BLAIR, NEBRASKA COMBINING BALANCE SHEET - SPECIAL REVENUE FUNDS SEPTEMBER 30, 2000 y k : ASSETS C k Keno Street M.I.R.F. Sales Tax Revolving Fund Fund Fund Fund Loan Fund Total CASH AND EQUIVALENTS $ 120,606 $ 339,656 $ 107,816 $ 143,544 $ 166,162 $ 877,784 DUE FROM COUNTY 0 10,899 0 0 0 10,899 REVOLVING LOAN/ OTHER RECEIVABLES 4,077 0 0 148,986 423,928 576,991 ACCRUEDINTEREST RECEIVABLE 0 0 0 0 0 0 TOTAL $ 124,683 $ 350,555 $ 107,816 $ 292,530 $ 590,090 $ 1,465,674 E LIABILITIES AND FUND EQUITY STATE TAX PAYABLE $ 3,394 0 0 0 0 $ 3,394 r ACCOUNTS PAYABLE 0 $ 31,997 0 $ 102,977 $ 193,440 328,414 FUND BALANCE 121,289 318,558 $ 107,816 189,553 396,650 1,133,866 i, TOTAL $ 124,683 $ 350,555 $ 107,816 $ 292,530 $ 590,090 $ 1,465,674 r.° i r G I 33 0 (D O N m N o W N r� r O 0 M w d' 0 0 (O (o (O m r- O O�t O m d' CO r-- Co M M M O O (O O r r` O r 1, r m r- d' M (O O to Lo M N Mo (D Q M o (O r r O � O r•OMMNNm aDtOd'COCOLOmTCO.-OOrNODrr•(DN(OmNCY)NLO(OO NmCl) O (6 O 1- (0 0 (1 (O N C6 r_ rl .- N m r Co N r� CV (O r� r r co Ng N N (oN N Cn% N — F- co U) r-LON r- Co O (.C) O Cpr Cl) m r T' r r (mO CCIO N 69 O_0 o 0 0 m o o m 0000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o 000 O O > LLO C ch N p N (1) J U3 W (7 = x O O O r• m N N o 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 o N� 0 o 0o 0 0 ~O LO U O (13 F-70 0N(�dor m N N N N r N N C m N (Nf» N r N co (D C\j � N ad LL Fz O O QZCl) U) LL � W m Y o Wa o o O� o o OD m 000000000000000000000000000 000 m m aWW W o (rOrn W ((0)N XW M W J W W W Q ZU) V 0 m oC�aW 6 m LU I U 0(oom00m t(o It ( OWMt000(oLOmrOo�trn-Or (Or000momwo 00)(D (pOr rOnrrmrd-ropo0((Or m(o000 oO Cl)OWO (O mOm CoN C�Nd LO rd CCL 000((OrOorNMr m 0�WN �V �O N � t- f,- r Ch r- aD N � N — CO � CV r � � 1. W<>�u l;r m co OO ((' r mr D m W Q 0 69 U � W Z_P (`3 W OooOoom 00000000000000000001,4-0000000 oolt (o Z O ZLL � r It - (D �It O m C Y� r d' 0c) (O co (p 0 (O 0 m r O 69U U) W W F- Z W d X W U) E x WQ N�c C C N N p O V .p.. a) p N Z p N c C 'V 'o p ` 'a W N I N CL CCL L C a l L C o> W > i N c v o C: - W a N o cn a W c c °> a� cv cox O > p CL a)o o� �, as p •� ~ o 0 0 ai U p E E W o W m o o� o o a>axi o rno c o ro p a� o 0.5 Q�•c o X o `mro- � ��Fo- z C- W Y Z 0 a��i� d� Q o Q ;_ o> ._ a) ui c- n a) W c a� ]a�b �� .2 .6 c c- c 0- Ea�cE5r-c ro��w�Y0 (1) (1)M(o aa�(ocow Cn > o WZ(n��uo)o XC LLd:WJWWQOo�F-F-F--2(nUUYC)mw(3�WUU U1 W W W 073co - 2 7 $ 7 m o== r G c / 9 � Q CO � OD� a a e o00o 0 2 C LOU) / 2 0 o w e o= % � $m m Cl) 15 a a ) $ 000OD - ? / R= 2 G o n m e 2 \ r 00 6* ® 2 w 2 ƒ 3 @ @ r0000 r r e = It m Cl) 00 \ \ / 5 \ \ @ e 0\$0 - $ $ 2 R =m \ e m \\ Q Q / e @ 0000 7 N k e= ƒ/ \ & k e a \ \ R ,. @ � Z co \ a o % w § \ \ u w / E ¢ / z 0 \// z k k k k I u / 0 0c ± ± g ® gm a Z )*6 O O 0 O z z \ b ® S k E 2 / _ _ & / _ = 2 < < \ \/\CL� \ \ in / / / i- i i PRIZE RESERVE FUND RECONCILIATION FOR THE REPORTING PERIOD Beginning fund Balance $ 4,608 Increase to Fund 0 Withdrawals from Fund (4,649) Ending Fund Balance (deficit) $ (41) CITY OF BLAIR, NEBRASKA INDIVIDUAL STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL SPECIAL REVENUE FUNDS - KENO FUND FOR THE TWELVE MONTHS ENDED SEPTEMBER 30 2000 Budget Actual Variance GROSS PROCEEDS $ 0 $ 885,340 $ 0 PRIZES: Declared Prizes 0 686,362 0 Unclaimed Wins 0 2,030 0 Net Prizes Paid 0 684,332 NET HOLD 0 201,008 0 ALLOWABLE EXPENSES PAID: Lottery Operator's Commission 0 123,948 0 NET KENO PROCEEDS $ 65,000 $ 77,060 $ 12,060 EXPENSES PAID BY CITY: State Taxes 13,000 17,707 (4,707) Other Expenses 2,900 2,850 50 TOTAL EXPENSES PAID 15,900 20,557 (4,657) PROCEEDS AVAILABLE FOR DISTRIBUTION 49,100 56,503 7,403 TRANSFER FROM PRIZE RESERVES 0 4,649 4,649 COMMUNITY BETTERMENT (223,253) (146,137) 77,116 NET AFTER TRANSFERS (174,153) (84,985) 89,168 Beginning Keno Account Fund Balance 201,785 201,785 0 Interest 2,500 4,489 1,989 KENO ACCOUNT FUND BALANCE $ 30,132 $ 121,289 $ 91,157 PRIZE RESERVE FUND RECONCILIATION FOR THE REPORTING PERIOD Beginning fund Balance $ 4,608 Increase to Fund 0 Withdrawals from Fund (4,649) Ending Fund Balance (deficit) $ (41) CITY OF BLAIR, NEBRASKA INDIVIDUAL STATEMENT OF REVENUES EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL SPECIAL REVENUE FUNDS - STREET FUND FOR THE TWELVE MONTHS ENDED SEPTEMBER 30.2000 Var. Favorable REVENUES: Budget Actual (Unfavorable) Highway allocation $ 430,000 $ 479,649 $ 49,649 I Property taxes 252,500 243,126 (9,374) Other taxes 53,100 68,354 15,254 Incentive payment 3,000 3,000 0 State maintenance agreement 13,640 13,633 (7) In -Lieu of tax 12,000 10,720 (1,280) Homestead exemption 0 7,147 7,147 State grant 50,000 23,940 (26,060) Interest on investments 14,500 17,363 2,863 Other income 33,300 25,427 (7,873) Total revenues 862,040 892,359 30,319 EXPENDITURES: Salaries 228,994 181,860 47,134 FICA 17,900 13,508 4,392 x Retirement 9,000 7,478 1,522 Employee insurance 35,854 37,874 (2,020) Legal 1,800 1,800 0 Engineering 215,000 32,510 182,490 Employee appreciation 400 376 24 Auditing 2,000 1,576 424 Office expense 540 1,635 (1,095) Dues 200 173 27 Utilities 4,800 3,947 853 Telephone 1,000 1,019 (19) Travel 200 180 20 Training 300 264 36 Insurance 11,400 8,801 2,599 Maintenance 22,900 12,151 10,749 Street lighting 105,000 117,719 (12,719) County fees 2,500 2,655 (155) Car expense 1,200 271 929 Sand, gravel, and rock 10,000 11,333 (1,333) Gas, diesel, and oil 10,000 8,260 1,740 Materials and supplies 7,200 9,409 (2,209) Rental 3,000 2,588 412 Capital outlay: 0 Equipment 22,000 0 22,000 Street improvements 335,200 339,109 (3,909) Total expenditures 1,048,388 796,496 251,892 REVENUES OVER (UNDER) EXPENDITURES (186,348) 95,863 282,211 OTHER FINANCING SOURCES (USES): Bond proceeds 700,000 0 (700,000) Street district construction (700,000) (96,841) 603,159 Operating transfers - in 0 114,888 114,888 i Operating transfers - out 0 0 0 REVENUES OVER (UNDER) EXPENDITURES (186,348) 113,910 $ 300,258 r. FUND BALANCE - September 30, 1999 204,648 204,648 FUND BALANCE - September 30, 2000 18,300 318,558 37 CITY OF BLAIR, NEBRASKA INDIVIDUAL STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL SPECIAL REVENUE FUNDS - M.I.R.F. FUND FOR THE TWELVE MONTHS ENDED SEPTEMBER 30.2000 Variance Favorable Budget Actual (Unfavorable) REVENUES: M.I.R.F. revenues $ 70,386 $ 76,519 $ 6,133 Interest income 500 2,964 2,464 Total revenues 70,886 79,483 8,597 EXPENDITURES: Downtown project (98,000) 0 (98,000) REVENUES OVER (UNDER) EXPENDITURES BEFORE TRANSFERS (27,114) 79,483 106,597 TRANSFER OUT 0 0 0 REVENUES OVER (UNDER) EXPENDITURES (27,114) 79,483 $ 106,597 FUND BALANCE - Sept 30, 1999 28,333 28,333 FUND BALANCE - Sept 30, 2000 $ 1,219 $ 107,816 38 CITY OF BLAIR, NEBRASKA COMBINED STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL SPECIAL REVENUE FUNDS - SALES TAX FUND FOR THE TWELVE MONTHS ENDED SEPTEMBER 30 2000 REVENUES: Sales tax Use tax Occupation tax Federal T21 Fund Interest income Total revenue EXPENDITURES: Community betterment State collection fees Refunds 4th of July banners Street improvements Fire station - direct Fire station - transfers Total expenditures REVENUES OVER (UNDER) EXPENDITURES FUND BALANCE - September 30, 1999 FUND BALANCE - September 30, 2000 Budget Actual $ 751,877 $ 890,168 27,721 21,689 12,400 14,356 40,000 52,332 5,900 8,857 837,898 987,402 16,000 0 23,200 27,328 2,000 1,257 0 2,100 0 3,261 800,000 632,261 841,200 951,892 (3,302) 154,043 $ 150,741 39 35,510 $ 189,553 Variance Favorable (Unfavorable) $ 138,291 (6,032) 1,956 12,332 2,957 149,504 16,000 (4,128) 743 (2,100) (3,261) 167,739 (285,685) (110,692) $ 38,812 CITY OF BLAIR, NEBRASKA INDIVIDUAL STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCE BUDGET AND ACTUAL SPECIAL REVENUE FUNDS - REVOLVING LOAN FUND FOR THE TWELVE MONTHS ENDED SEPTEMBER 30 2000 :W Variance Favorable Budget Actual (Unfavorable) REVENUES: Interest income $ 15,960 $ 16,949 $ 989 Total revenue 15,960 16,949 989 EXPENDITURES: Cargill - City share 105,000 20,000 85,000 Total expenditures 105,000 20,000 85,000 REVENUES OVER (UNDER) EXPENDITURES BEFORE TRANSFERS (89,040) (3,051) 85,989 TRANSFERS -IN 0 0 0 REVENUES OVER (UNDER) EXPENDITURES (89,040) (3,051) $ 85,989 FUND BALANCE - September 30, 1999 399,701 399,701 FUND BALANCE - September 30, 2000 $ 310,661 $ 396,650 :W CURRENT ASSETS: Cash Accounts receivable - userfees Accounts receivable - other Accrued interest receivable Inventory Prepaid expenses Total current assets RESTRICTED ASSETS: Bond and interest sinking fund cash and investments PROPERTY: Plant in service Accumulated depreciation Property - net TOTAL ASSETS CITY OF BLAIR, NEBRASKA COMBINING BALANCE SHEET - ENTERPRISE FUNDS SEPTEMBER 30, 2000 ASSETS Water $ 950,577 431,015 51,541 2,432 30,653 Sewer $ 581,736 108,284 0 1,442 761 339,500 100,000 13,840,583 (4,467,809) 9,372,774 $ 11,179,486 41 4,606,537 (2,461,880) 2,144,657 $ 2,936,880 Total $ 1,532,313 539,299 51,541 3,874 31,414 18, 447,120 (6,929,689) 11,517,431 $ 14,116,366 CITY OF BLAIR, NEBRASKA COMBINING BALANCE SHEET - ENTERPRISE FUNDS SEPTEMBER 30, 2000 LIABILITIES AND FUND BALANCE 42 Water Sewer Total CURRENT LIABILITIES: Current portion of long-term debt $ 170,000 $ 40,000 $ 210,000 Accounts payable 520,644 10,652 531,296 Accrued interest 35,935 26,802 62,737 Accrued expenses 20,840 5,562 26,402 Total current liabilities 747,419 83,016 830,435 DEPOSITS PAYABLE 1,700 0 1,700 LONG-TERM DEBT: Revenue bonds payable -unmatured 4,258,408 1,095,000 5,353,408 Less current portion above (170,000) (40,000) (210,000) Long-term debt -net 4,088,408 1,055,000 5,143,408 Total liabilities 4,837,527 1,138,016 5,975,543 FUND EQUITY: Contributed capital 2,055,100 2,770,834 4,825,934 Retained earnings: Reserved 339,500 100,000 439,500 Unreserved 3,947,359 (1,071,970) 2,875,389 Total fund equity 6,341,959 1,798,864 8,140,823 TOTAL LIABILITIES AND FUND EQUITY $ 11,179,486 $ 2,936,880 $ 14,116,366 42 CITY OF BLAIR, NEBRASKA COMBINING STATEMENT OF REVENUES, EXPENSES AND CHANGES IN RETAINED EARNINGS ENTERPRISE FUNDS FOR THE TWELVE MONTHS ENDED SEPTEMBER 30.2000 OPERATING REVENUES: User fees Sale of merchandise Other Total EXPENSES: Personal services Operating expenses Materials and supplies Rental expense Depreciation Total liabilities OPERATING INCOME (LOSS) OTHER REVENUE (EXPENSE): Utility district construction Interest income Interest expense Bonding costs Operating transfers - in Operating transfers - out NET INCOME (LOSS) RETAINED EARNINGS (DEFICIT) Sept 30, 1999 RETAINED EARNINGS (DEFICIT) Sept 30, 2000 $ 2,133,586 $ 572,877 20,780 0 $ 2,706,463 20,780 18,276 2,745,519 448,404 199,606 648,010 362,754 152,533 515,287 664,494 59,005 723,499 1,945 1,188 3,133 334,293 106,903 441,196 1,811,890 519,235 2,331,125 360,752 53,642 414,394 (110,786) (699) (111,485) 123,606 32,251 155,857 (159,008) (53,603) (212,611) (98,331) 0 (98,331) 46,214 6,700 52,914 0 0 0 162,447 38,291 200,738 4,124,412 (1,010,261) 3,114,151 $ 4,286,859 $ (971,970) $ 3,314,889 43 CITY OF BLAIR, NEBRASKA COMBINING STATEMENT OF CASH FLOW ENTERPRISE FUNDS FOR THE TWELVE MONTHS ENDED SEPTEMBER 30 2000 Water Sewer Total CASH FLOW FROM OPERATIONS: Net operating income (loss) $ 360,752 $ 53,642 $ 414,394 Adjustment to reconcile net income to net cash from operations: Depreciation 334,293 106,903 441,196 Decrease (increase) in accounts receivable - user fees (57,499) (5,788) (63,287) Decrease (increase) in accounts receivable - other (45,174) 0 (45,174) Decrease (increase) in inventory (6,138) 0 (6,138) Decrease (increase) in prepaid expenses (129) (101) (230) Increase (decrease) in accounts payable 473,869 (2,872) 470,997 Increase (decrease) in accrued expenses 2,591 (271) 2,320 Net cash provided (used) by operations 1,062,565 151,513 1,214,078 CASH FLOW FROM NON -CAPITAL FINANCING Transfers - in 46,214 6,700 52,914 Transfers - out 0 0 0 Cash flow from (used by) non -capital financing 46,214 6,700 52,914 CASH FLOW FROM CAPITAL AND RELATED FINANCING: Proceeds from long-term debt 4,258,408 0 4,258,408 Payment of long-term debt (3,960,000) 0 (3,960,000) Decrease (increase) in restricted assets 400,755 53,600 454,355 Interest expense (159,008) (53,603) (212,611) Bonding costs (98,331) 0 (98,331) Increase (decrease) in accrued interest payable (27,595) (26,800) (54,395) Cash flow from (used in) financing 414,229 (26,803) 387,426 continued - 44 CITY OF BLAIR, NEBRASKA COMBINING STATEMENT OF CASH FLOW ENTERPRISE FUNDS FOR THE TWELVE MONTHS ENDED SEPTEMBER 30 2000 (continued) CASH FLOW FROM INVESTING: Purchase of property Utility district construction Interest income Decrease (increase) in accrued interest receivable Cash flow from (used in ) investing NET INCREASE (DECREASE) IN CASH CASH AND CASH EQUIVALENTS Beginning of the period CASH AND CASH EQUIVALENTS End of the period INTEREST PAID $ (2,271,981) (110,786) 123,606 15,466 (2,243,695) (720, 687) $ (24,657) (699) 32,251 4,689 11,584 142,994 438,742 Total $ (2,296,638) (111,485) 155,857 20,155 (2,232,111) (577, 693) $ 950,577 $ 581,736 / $ 1,532,313 $ 186,603 $ 80,404 $ 267,007 45 continued - 46 CITY OF BLAIR, NEBRASKA INDIVIDUAL STATEMENT OF REVENUES AND EXPENSES BUDGET AND ACTUAL - ENTERPRISE FUND - WATER FOR THE TWELVE MONTHS ENDED SEPTEMBER 30.2000 Variance Favorable Budget Actual (Unfavorable) OPERATING REVENUES: Userfees $ 2,100,500 $ 2,133,586 $ 33,086 Sale of merchandise 12,000 20,780 8,780 Forfeited discounts 11,000 12,654 1,654 Other 1,873 5,622 3,749 Total revenues 2,125,373 2,172,642 47,269 EXPENSES: Personal services: Salaries 368,466 341,316 27,150 FICA 27,423 25,158 2,265 Workman's compensation 6,000 6,766 (766) HAL insurance 52,043 58,327 (6,284) Retirement (city share) 16,500 14,482 2,018 Unemployment and disability 2,236 2,355 (119) Total 472,668 448,404 24,264 Operating expenses: Legal fees 9,600 7,844 1,756 Auditing 2,600 2,224 376 Consultants 28,000 14,216 13,784 Employee appreciation 600 172 428 Postage 5,500 6,421 (921) Printing and publications 300 1,276 (976) Computer programming 4,000 3,173 827 Schools, travel, and training 2,400 3,858 (1,458) Dues 1,800 1,277 523 Utilities 250,000 226,526 23,474 Telephone 2,200 2,760 (560) Vehicle insurance 600 163 437 Liability insurance 1,400 1,394 6 Buildings and contents insurance 4,000 3,798 202 Employee bonds 200 0 200 Radio maintenance 600 125 475 Office equipment maintenance 1,000 639 361 Motorized equipment maintenance 4,000 4,334 (334) Building maintenance 25,000 25,669 (669) Major maintenance 25,000 36,218 (11,218) Contingent reserve 6,000 0 6,000 Electronic maintenance 6,000 960 5,040 Car expense 900 144 756 Gateway development 20,000 15,000 5,000 Bad accounts 2,500 4,563 (2,063) Total 404,200 362,754 41,446 continued - 46 CITY OF BLAIR, NEBRASKA INDIVIDUAL STATEMENT OF REVENUES AND EXPENSES BUDGET AND ACTUAL - ENTERPRISE FUND - WATER ENTERPRISE FUND - WATER FOR THE TWELVE MONTHS ENDED SEPTEMBER 30.2000 continued - Variance Favorable Budget Actual (Unfavorable) EXPENSES: Materials and supplies: Office supplies $ 4,500 $ 3,805 $ 695 Janitorial supplies 400 598 (198) Shop supplies 2,300 2,730 (430) Chemicals 235,000 280,939 (45,939) Meters 12,000 15,678 (3,678) Water lines 265,000 342,216 (77,216) Supplies for inventory 1,000 3,446 (2,446) Gas, oil and diesel 2,500 3,760 (1,260) Uniforms 900 523 377 Small tools 1,400 4,418 (3,018) Payment to OPPD 1,173 3,910 (2,737) E Other materials and supplies 2,500 2,471 29 Total l 528,673 664,494 (135,821) Rental expense - Office equipment 1,000 1,945 (945) Total expenses 1,406,541 1,477,597 (71,056) OPERATING INCOME (LOSS) BEFORE i DEPRECIATION 718,832 695,045 (23,787) DEPRECIATION (400,000) (334,293) 65,707 OPERATING INCOME (LOSS) 318,832 360,752 41,920 OTHER REVENUES (EXPENSES): Water district construction (100,000) (110,786) (10,786) Interest income 94,000 123,606 29,606 Interest expense (186,603) (159,008) 27,595 Bonding costs 0 (98,331) (98,331) Operating transfers - in 0 46,214 46,214 Operating transfers - out (60,000) 0 60,000 NET INCOME (LOSS) $ 66,229 $ 162,447 $ 96,218 47 48 CITY OF BLAIR, NEBRASKA INDIVIDUAL STATEMENT OF REVENUES AND EXPENSES BUDGET AND ACTUAL - ENTERPRISE FUND - SEWER FOR THE TWELVE MONTHS ENDED SEPTEMBER 30. 2000 Var. Favorable Budget Actual (Unfavorable) OPERATING REVENUES: User fees $ 565,000 $ 572,877 $ 7,877 Other revenue 300 0 (300) Total revenues 565,300 572,877 7,577 EXPENSES: Personal services: Salaries 168,245 153,040 15,205 FICA 12,600 11,366 1,234 Workman's compensation 3,500 4,111 (611) HAL insurance 21,188 23,139 (1,951) Retirement (city share) 7,300 6,862 438 Unemployment and disability 1,050 1,088 (38) Total 213,883 199,606 14,277 Operating expenses: Legal 1,800 1,800 0 Auditing 2,600 4,315 (1,715) Consultants/engineering 41,000 29,693 11,307 Employee appreciation 400 167 233 Postage 2,800 3,761 (961) Printing and publication 100 170 (70) Computer programming 1,200 587 613 School, travel, and training 1,500 1,374 126 Dues 500 578 (78) Utilities 42,000 41,113 887 Telephone 700 871 (171) Insurance 5,800 4,841 959 Maintenance 33,350 46,104 (12,754) Car expense 900 81 819 Sewer lines 105,000 17,078 87,922 Total 239,650 152,533 87,117 Materials and supplies 48,500 59,005 (10,505) Rental expense 750 1,188 (438) Total expenses 502,783 412,332 90,451 OPERATING INCOME (LOSS) BEFORE DEPRECIATION 62,517 160,545 98,028 DEPRECIATION (100,000) (106,903) (6,903) OPERATING INCOME (LOSS) (37,483) 53,642 91,125 OTHER REVENUE (EXPENSE): Sewer district 0 (699) (699) Bond costs 0 0 0 Interest income 9,118 32,251 23,133 Interest expense (80,404) (53,603) 26,801 Transfers - in 0 6,700 6,700 NET INCOME (LOSS) $ (108,769) $ 38,291 $ 147,060 48 CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND REVENUES BUDGET AND ACTUAL FOR THE TWELVE MONTHS ENDED SEPTEMBER 30 2000 49 Variance Favorable Budget Actual (Unfavorable) REVENUES: Taxes: Property taxes $ 705,200 $ 690,245 $ (14,955) Motor vehicle taxes 80,000 90,908 10,908 Interest on taxes 4,000 2,711 (1,289) Insurance tax 0 0 0 Receipts in lieu of taxes 38,000 47,499 9,499 State aid 99,800 97,214 (2,586) Carline and vehicle prorate 5,500 5,846 346 Homestead relief 0 29,986 29,986 Franchise tax 103,500 128,269 24,769 Total 1,036,000 1,092,678 56,678 Charges for services: Business licenses and permits 110,390 179,348 68,958 Library 11,500 11,532 32 Equipment rental 1,000 3,997 2,997 Cemetery lots 17,000 22,450 5,450 Grave openings 25,000 22,800 (2,200) Swimming pool fees 24,500 0 (24,500) Other fees and charges 4,300 3,861 (439) Sales of fireworks 17,000 22,600 5,600 RV park 4,100 4,157 57 Total 214,790 270,745 55,955 INTEREST INCOME 36,800 19,204 (17,596) OTHER REVENUES: State aid -library 2,440 4,749 2,309 State grants 20,000 22,049 2,049 Federal grants 1,471,639 579,642 (891,997) Gifts 7,700 16,201 8,501 Bond process 1,000,000 0 (1,000,000) Reimbursement 98,100 6,973 (91,127) Sale of assets 15,000 5,000 (10,000) County inspector payments 38,500 13,526 (24,974) Other miscellaneous revenue 3,050 497 (2,553) Total 2,656,429 648,637 (2,007,792) TOTAL REVENUES $ 3,944,019 $ 2,031,264 $ (1,912,755) 49 CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET AND ACTUAL - ADMINISTRATION DEPARTMENT FOR THE TWELVE MONTHS ENDED SEPTEMBER 30, 2000 Variance Favorable Budget Actual (Unfavorable) PERSONAL SERVICES: Salaries $ 82,367 $ 74,387 $ 7,980 Social Security 6,200 5,308 892 Employee's insurance 54,630 57,378 (2,748) Retirement 4,500 1,821 2,679 OPERATING EXPENSES: Legal 21,600 17,330 4,270 Auditing 1,300 1,078 222 Civil defense 2,400 0 2,400 Consulting 37,000 25,520 11,480 Custodial services 4,000 4,120 (120) Employee appreciation 1,200 227 973 Postage 3,500 2,056 1,444 Printing and publications 8,000 8,267 (267) Training 6,000 6,118 (118) Dues 8,500 11,171 (2,671) Election expenses 800 0 800 Programming 5,100 6,444 (1,344) City utilities 4,500 4,424 76 Telephone 5,000 5,597 (597) Travel expense 5,000 6,068 (1,068) Insurance and bonds 4,200 2,358 1,842 Newsletter 4,500 1,210 3,290 Maintenance 5,500 6,490 (990) Tree removal 18,000 19,766 (1,766) City cleanup 14,000 8,969 5,031 Chamber of Commerce 1,500 1,500 0 Car expense 3,720 3,971 (251) County Treasurer's fees 6,980 7,403 (423) Disaster expenses 0 23,052 In Lieu of taxes 10,500 14,202 (3,702) Miscellaneous 1,200 1,813 (613) CDBG Grant 1,403,639 484,941 918,698 SUPPLIES 15,500 15,295 205 RENTAL EXPENSES: Office equipment 900 2,197 (1,297) CAPITAL OUTLAY: Motorized equipment 0 0 0 Office equipment 0 3,894 (3,894) TOTALS $ 1,751,736 $ 834,375 $ 940,413 50 CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET AND ACTUAL CONTINGENCY ALLOWANCE FOR THE TWELVE MONTHS ENDED SEPTEMBER 30.2000 51 Budget CONTINGENT RESERVE: Favorable Banners and flags $ 0 50% Police video display 0 Tennis ball machine for YMCA 0 TOTAL 25,000 CAPITAL OUTLAY: 16,758 Council audio system 0 TOTAL $ 25,000 51 Variance Favorable Actual (Unfavorable) $ 5,795 $ (5,795) 1,246 (1,246) 1,201 (1,201) 8,242 16,758 7,404 (7,404) $ 15,646 $ 9,354 52 CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET AND ACTUAL POLICE DEPARTMENT FOR THE TWELVE MONTHS ENDED SEPTEMBER 30 2000 Variance Favorable Budget Actual (Unfavorable) PERSONAL SERVICES: Salaries $ 544,145 $ 466,374 $ 77,771 Social Security 40,100 34,460 5,640 Employee's insurance 104,542 88,507 16,035 Retirement 33,300 26,570 6,730 OPERATING EXPENSES: Legal 4,000 5,857 (1,857) Auditing 850 747 103 Consultants 0 8,684 Employee appreciation 1,000 87 913 Postage 800 497 303 Printing and publications 400 622 (222) Programming 900 750 Drug task force 7,000 6,346 654 Training 2,000 2,620 (620) Telephone 3,500 2,465 1,035 Travel 1,200 1,780 (580) Utilities 2,400 0 2,400 Dues 600 428 172 Insurance 7,900 5,955 1,945 MAPA testing 1,300 1,309 (9) Maintenance 26,800 21,846 4,954 Medical exams 1,000 3,117 (2,117) Car expense 1,500 1,463 37 Wellness program 1,000 900 100 Miscellaneous 500 749 (249) SUPPLIES: Supplies 9,900 9,902 (2) Gas and oil 9,500 11,999 (2,499) Uniforms 12,000 11,241 759 Ammunition and range 1,500 1,486 14 Safety Equipment/Training 2,500 3,436 (936) Supplies - DARE 1,200 0 1,200 Supplies - GREAT 0 0 0 Supplies - GRANT 0 600 (600) RENTAL EXPENSES - 29,500 15,297 14,203 CAPITAL OUTLAY: Office equipment 11,500 500 11,000 Motor vehicles 18,500 19,523 (1,023) Radio/Camera/Video 6,000 0 6,000 TOTALS $ 888,837 $ 756,117 $ 141,254 52 PERSONAL SERVICES; Salaries Social Security Employee's insurance Retirement OPERATING EXPENSES; Legal Auditing Engineering Employee appreciation Printing and publications Programming Training Travel Dues Utilities Telephone Insurance Maintenance Miscellaneous SUPPLIES Operating supplies Gas and oil Uniforms Small tools Sand, gravel and rock RENTAL EXPENSES - CAPITAL OUTLAY Equipment Building TOTALS CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET AND ACTUAL CEMETERY FOR THE TWELVE MONTHS ENDED SEPTEMBER 30 2000 Budget $ 71,210 5,300 10,578 1,400 625 100 300 120 250 0 200 100 60 2,500 750 1,100 6,700 400 725 2,000 200 250 600 15,000 3,800 54,593 4,037 9,862 1,269 600 83 0 0 400 2,680 90 0 50 1,606 992 1,050 5,861 0 1,769 1,655 220 1,626 1,185 13,600 1,584 $ 176,568 $ 154,040 53 Variance Favorable (Unfavorable) $ 16,617 1,263 716 131 25 17 300 120 (150) (2,680) 110 100 10 894 (242) 50 839 400 (1,044) 345 (20) (1,376) (585) 1,400 2,216 $ 22,528 CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET AND ACTUAL FIRE DEPARTMENT FOR THE TWELVE MONTHS ENDED SEPTEMBER 30 2000 54 $ 600 165 478 2,759 7,998 10,725 11,399 0 2,489 0 7,635 818 13,897 0 0 $ 470,615 Variance Favorable (Unfavorable) $ 0 335 (363) 741 4,502 975 1 40 (489) 0 (935) 682 (3,397) 0 21,710 588,348 $ 612,150 Budget OPERATING EXPENSES Legal $ 600 Auditing 500 Printing and publications 115 Telephone 3,500 Utilities 12,500 Insurance 11,700 Maintenance 11,400 Travel 40 Training 2,000 Miscellaneous 0 SUPPLIES Operating supplies 6,700 Gas and oil 1,500 Safety equipment 10,500 Miscellaneous 0 CAPITAL OUTLAY Equipment 21,710 Building 1,000,000 TOTALS $ 1,082,765 54 $ 600 165 478 2,759 7,998 10,725 11,399 0 2,489 0 7,635 818 13,897 0 0 $ 470,615 Variance Favorable (Unfavorable) $ 0 335 (363) 741 4,502 975 1 40 (489) 0 (935) 682 (3,397) 0 21,710 588,348 $ 612,150 PERSONAL SERVICES: Salaries Social Security Employee's insurance Retirement OPERATING EXPENSES: Legal Auditing Printing and publications Training Dues Travel Utilities Telephone Insurance Maintenance Miscellaneous SUPPLIES Operating supplies Gas and oil Small tools Playground equipment Miscellaneous CAPITAL OUTLAY Building Equipment TOTALS CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET AND ACTUAL PARK DEPARTMENT FOR THE TWELVE MONTHS ENDED SEPTEMBER 30. 2000 60,000 7,000 $ 205,833 55 37,227 $ 169,908 22,773 1,386 $ 35,665 Variance Favorable Budget Actual (Unfavorable) $ 81,405 $ 70,712 $ 10,693 6,200 5,265 935 10,188 11,121 (933) 1,400 1,269 131 600 600 0 100 83 17 420 305 115 420 245 175 150 380 (230) 200 45 155 4,500 3,875 625 700 710 (10) 1,500 702 798 20,075 20,167 (92) 100 100 0 2,475 2,413 62 2,000 2,901 (901) 400 434 (34) 6,000 5,740 0 0 0 60,000 7,000 $ 205,833 55 37,227 $ 169,908 22,773 1,386 $ 35,665 CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET AND ACTUAL LIBRARY FOR THE TWELVE MONTHS ENDED SEPTEMBER 30 2000 56 Variance Favorable Budget Actual (Unfavorable) PERSONAL SERVICES: Salaries $ 93,240 $ 89,445 $ 3,795 Social Security 7,200 6,835 365 Employee's insurance 9,706 10,228 (522) Retirement 4,600 4,016 584 OPERATING EXPENSES: Legal 600 600 0 Auditing 300 249 51 Employee appreciation 600 0 600 Postage 500 575 (75) Dues 300 135 165 Printing and publications 300 1,901 (1,601) Utilities 9,000 7,659 1,341 Telephone 4,000 1,776 2,224 Travel 200 24 176 Training 200 10 190 Insurance 1,100 957 143 Maintenance 6,900 6,121 779 Custodial services 2,300 2,160 140 SUPPLIES Supplies 2,700 2,489 211 Library materials 33,400 33,895 (495) CAPITAL OUTLAY Office equipment 3,500 6,231 (2,731) TOTALS $ 180,646 $ 175,306 $ 5,340 56 PERSONAL SERVICES: Salaries Social Security Employee's insurance OPERATING EXPENSES: Auditing Dues and training Professional fees Printing and publications Utilities Telephone Insurance Maintenance Recreational support Fireworks SUPPLIES Gas and oil Recreation supplies Other supplies CAPITAL OUTLAY Equipment Vehicles TOTALS CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET AND ACTUAL SUPERVISED RECREATION FOR THE TWELVE MONTHS ENDED SEPTEMBER 30, 2000 300 1,700 400 2,000 14,700 $ 63,576 57 346 3,147 779 1,260 13,385 $ 62,108 (46) (1,447) (379) 740 1,315 $ 1,468 Variance Favorable Budget Actual (Unfavorable) $ 8,700 $ 8,657 $ 43 666 637 29 410 476 (66) 100 83 17 0 60 (60) 0 0 0 200 124 76 4,700 4,765 (65) 100 353 (253) 1,300 1,084 216 12,800 11,847 953 10,500 10,500 0 5,000 4,605 395 300 1,700 400 2,000 14,700 $ 63,576 57 346 3,147 779 1,260 13,385 $ 62,108 (46) (1,447) (379) 740 1,315 $ 1,468 PERSONAL SERVICES: Salaries Social Security Employee's insurance OPERATING EXPENSES: Auditing Printing and publications Utilities and telephone Insurance Maintenance State sales tax Miscellaneous SUPPLIES Chemicals Miscellaneous CAPITAL OUTLAY Bath house TOTALS CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET AND ACTUAL SWIMMING POOL FOR THE TWELVE MONTHS ENDED SEPTEMBER 30. 2000 4, 000 2,725 260,000 $ 307,535 58 8,314 1,723 306,932 $ 332,491 (4,314) 1,002 (46,932) $ (24,956) Variance Favorable Budget Actual (Unfavorable) $ 28,000 0 $ 28,000 2,000 0 2,000 110 0 110 200 $ 166 34 500 351 149 4,100 5,011 (911) 700 661 39 4,000 8,834 (4,834) 1,200 0 1,200 0 499 (499) 4, 000 2,725 260,000 $ 307,535 58 8,314 1,723 306,932 $ 332,491 (4,314) 1,002 (46,932) $ (24,956) CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET AND ACTUAL ANIMAL CONTROL FOR THE TWELVE MONTHS ENDED SEPTEMBER 30 2000 Variance Favorable Budget Actual (Unfavorable) PERSONAL SERVICES: Salaries $ 31,155 $ 25,739 $ 5,416 Social Security 2,300 1,740 560 Employee's insurance 6,722 7,581 (859) Retirement 1,100 1,162 (62) OPERATING EXPENSES: Legal 1,200 600 600 Auditing 100 83 17 Printing and publications 290 269 21 Travel 250 104 146 Training 250 0 250 Veterinary expense 1,500 934 566 Utilities 3,000 2,680 320 Telephone 450 688 (238) Insurance 410 312 98 Maintenance 2,950 1,511 1,439 Miscellaneous 150 0 150 SUPPLIES Gas and oil 1,000 522 478 Supplies 1,300 1,589 (289) Uniforms 700 619 81 Miscellaneous 0 0 0 CAPITAL OUTLAY Equipment 0 0 0 TOTALS $ 54,827 $ 46,133 $ 8,694 CITY OF BLAIR, NEBRASKA SCHEDULE OF GENERAL FUND EXPENDITURES BUDGET AND ACTUAL DONATED FUNDS FOR THE TWELVE MONTHS ENDED SEPTEMBER 30 2000 Budget Park $ 5,000 Police - DARE 1,685 Employee appreciation 2,000 Bike patrol program 0 Animal control 16,878 Tennis court repair 0 TOTAL $ 25,563 61 Variance Favorable Actual (Unfavorable) 0 $ 5,000 0 1,685 $ 2,090 (90) 500 (500) 0 16,878 8,656 (8,656) $ 11,246 $ 14,317 CC u Q U- a cc N Z ¢ z Li t— u cc LL C g 0 u m Jc e U. L o LUU U ch O I— z rr w LL U) z 60- 1 6c.� 0 000000 0 o U ce) w O 0 W Ln Q cc W O ~r LO m L6 tc S z Ir O T W It O T CO N LL (D CY) N 0) N m m i N 60- 1 6c.� 0 W 0 NO 00 0 O X) 00 o U ce) w O w Ln Q cc W O ~r LO m L6 tc S z Ir O T W It O T CO N LL (D CY) N F— N 6c.� 1 6-j- W 0 0 0 0 0 O o U ce) 00 w Ln Q cc W t0 O LO m L6 tc U) z Ir L6 W It 00 It CO N LL (D CY) N F— N m m i N L U. 0O J < 6c.� 1 6-j- 69- 1 6- W m O O O O o c0 O o U ce) 00 cc rn Q cc W t0 O N W tc U) z Ir W It 00 It CO N LL (D CY) N 0 cc m m i 69- 1 6- "t Ln 000 V/ O Qr cc r W CO O CO W z Ir W It 00 It CO N LL (D CY) N 0 cc m m i r 69- 1 6- N V/ w LL OM z Ir LL cc m m i F- L U. 0O J < z N 0 a� O F— N EDWARD W. SCHROEDER CERTIFIED PUBLIC ACCOUNTANT 1904 SOUTH STREET BOX 486 BLAIR, NEBRASKA 68008 RESIDENCE: (402) 468-5253 OFFICE: (402) 426-4080 January 4, 2001 Honorable Mayor and Members of the City Council City of Blair, Nebraska "Compliance and Internal Control over financial reporting" Dear Gentlemen: I have audited the financial statements of the City of Blair, Nebraska, as of and for the years ended September 30, 1999 and 2000, and have issued my report thereon dated January 4, 2001. 1 conducted my audit in accordance with generally accepted auditing standards and the standards applicable to financial audits contained in Government Auditing Standards, issued by i the Comptroller General of the United States. Compliance As part of obtaining reasonable assurance about whether City of Blair's financial statements are free of material misstatement, I performed tests of its compliance with certain provisions of laws, regulations, contracts and grants, noncompliance with which could have a direct and material effect on the determination of financial statement amounts. However, providing an opinion on compliance with those provisions was not an objective of my audit and, accordingly, I do not express such an opinion. The results of my tests disclosed no instances of noncompliance that are required to be reported under Government Auditing Standards. Internal Control Over Financial Reporting In planning and performing my audit, I considered City of Blair's internal control over financial reporting in order to determine my auditing procedures for the purpose of expressing my opinion on the financial statements and not to provide assurance on the internal control over financial reporting. However, I noted certain matters involving the internal control over financial reporting and its operation that I consider to be reportable conditions. Reportable conditions involve matters coming to my attention relating to significant deficiencies in the design or operation of the internal control over financial reporting that, in my judgment, could adversely affect the City of Blair's ability to record, process, summarize and report financial data consistent with the assertions of management in the financial statements. The City of Blair does not have adequate separation of duties. 63 Honorable Mayor and Members of the City Council Page 2 A material weakness is a condition in which the design or operation of one or more of the internal control components does not reduce to a relatively low level the risk that misstatements in amounts that would be material in relation to the general purpose financial statements being audited may occur and not be detected within a timely period by employees in the normal course of performing their assigned functions. My consideration of the internal control over financial reporting would not necessarily disclose all matters in the internal control that might be reportable conditions and, accordingly, would not necessarily disclose all reportable conditions that are also considered to be material weaknesses. However, the reportable conditions described above I consider to be material weaknesses. The condition, criteria, effect and cause is the lack of separation of duties due to the small size of the entity. This report is intended solely for the information and the use of the audit committee, management, others within the organization, City Council, and federal awarding agencies and pass-through entities and is not intended to be and should not be used by anyone other than these specified parties. Edward W. Schroeder Certified Public Accountant 64 EDWARD W.SCHROEDER CERTIFIED PUBLIC ACCOUNTANT 1904 SOUTH STREET BOX 486 BLAIR, NEBRASKA 68008 January 4, 2001 Honorable Mayor and Members the City Council City of Blair, Nebraska "Internal Control over Compliance for Major Programs" Gentlemen: RESIDENCE: (402) 468-5253 OFFICE: (402) 426-4080 I have audited the compliance of the City of Blair with the types of compliance requirements described in the U.S. Office of Management and Budget (OMB) CircularA-133 Compliance Supplement that are applicable to each of its major federal programs for the year ended September 30, 2000. The City of Blair's major federal programs are identified in the summary of auditor's results section of the accompanying schedule of findings and questioned costs. Compliance with the requirements of laws, regulations, contracts and grants applicable to each of its major federal programs is the responsibility of the City of Blair's management. My responsibility is to express an opinion on City of Blair's compliance based on my audit. I conducted my audit of compliance in accordance with generally accepted auditing standards the standards applicable to financial audits contained in Government Auditing Standards, issued by Comptroller General of the United States and OMB Circular A-133, Audits of States and Local Governments and Non -Profit Organizations." Those standards and OMB Circular A-133 require that I plan and perform the audit to obtain reasonable assurance about whether noncompliance with the types of compliance requirements referred to above that could have a direct and material effect on a major federal program occurred. An audit includes examining, on a test basis, evidence about city of Blair's compliance with those requirements and performing such other procedures as I considered necessary in the circumstances. I believe that my audit provides a reasonable basis for my opinion. My audit does not provide a legal determination on the City of Blair's compliance with those requirements. In my opinion, the City of Blair complied, in all material respects, with the requirements referred to above that are applicable to each of its major federal programs for the year ended September 30, 2000. Internal Control Over Compliance The management of the City of Blair is responsible for establishing and maintaining effective internal control over compliance with requirements of laws, regulations, contracts and grants applicable to federal programs. In planning and performing my audit, I considered the City of Blair's internal control over compliance with requirements that could have a direct and material effect on a major federal program in order to determine our auditing procedures for the purpose of expressing our opinion on compliance and to test and report on internal control over compliance in accordance with OMB Circular A-133. 65 r Honorable Mayor and Members the City Council Page 2 I noted certain matters involving the internal control over compliance and its operation that I consider to be reportable conditions. Reportable conditions involve matters coming to my attention relating to significant deficiencies in the design or operation of the internal control over compliance that, in my judgment, could adversely affect the City of Blair's ability to administer a major federal program in accordance with applicable requirements of laws, regulations, contracts and grants. Reportable conditions are described in the accompanying schedule of findings and questioned costs as item # 1. A material weakness is a condition in which the design or operation of one or more of the internal control components does not reduce to a relatively low level the risk that noncompliance with applicable requirements of laws, regulations, contracts and grants that would be material in relation to a major federal program being audited may occur and not be detected within a timely period by employees in the normal course of performing their assigned functions. My consideration of the internal control over compliance would not necessarily disclose all matters in the internal control that might be reportable conditions and, accordingly, would not necessarily disclose all reportable conditions that are also considered to be material weaknesses. However, the reportable conditions described above I consider to be material weaknesses. The condition, criteria, effect and cause is the lack of separation of duties due to the small size of the entity. This report is intended for the information of the audit committee, management and federal awarding agencies and pass-through entities. However, this report is a matter of public record and its distribution is not limited. Edward W. Schroeder Certified Public Accountant co M r [r O O C) rn rn � r J W MM T c r Q z d p CL ►- X W r' 2 W Z Ln N � T (j M p CO Cl) M Ln p CO o o N w rn T (o X t° M z 2 p p rn m r2 N LON o Qz r- 0")O N N T LL N CD U) 01) a) W Q U D N Q U LL w rn Q p n- LL N M Q '� Q m m�W ' Q uj Z W Q T- W M co O O O to I• O N CC0 CO CC Q W N N0 O O O d' N O LU n w p m N N O M M Uf M � Ln LL W 0 LL" �t d• O O O O M (O (O Q p W U D T T N N N N MLL z r T mow L- Z OW Er }} C) C)w _ w = U = ~ z U CC p O Q o � ro r _ U)U Z Z E W CC J Q U Q W e o W p W m Q cr 2` a) LL U 2 �"- 0 0 > Q v H oC p O U v D U) o o U L E z U w - Z W m m LL. >' 0) C j o Q o z° 2 .. c ,� g o a c C7 F- z E E a I- > U W - � J Z o o (o >- E = Q 3 Z o O C'3 Q T > > c (n a� C'3 Z aa) p 0 � a) N p 0o U z W v U LL Q c c a> - a: cQ W cn DC Q o c c > a Q Q LL c a a� p E E o Q a� o Q Q ,v IL cn W o c (n w CL o o ~ O o m ~ W W O m ~ o Z) U U f- CL w OC p LL p IL U J v O Q W W 2 Z W LL. D k co It M a7 LO O L N C\ftto r It t It 69- 6ct 63 69- 63 r' 2 W Z Ln N � T (j M p CO Cl) M Ln p CO o o N w rn T (o X t° M z 2 p p rn m r2 N LON o Qz r- 0")O N N T LL N CD U) 01) a) W Q U D N Q U LL w rn Q p n- LL N M Q '� Q m m�W ' Q uj Z W Q T- W M co O O O to I• O N CC0 CO CC Q W N N0 O O O d' N O LU n w p m N N O M M Uf M � Ln LL W 0 LL" �t d• O O O O M (O (O Q p W U D T T N N N N MLL z r T mow L- Z OW Er }} C) C)w _ w = U = ~ z U CC p O Q o � ro r _ U)U Z Z E W CC J Q U Q W e o W p W m Q cr 2` a) LL U 2 �"- 0 0 > Q v H oC p O U v D U) o o U L E z U w - Z W m m LL. >' 0) C j o Q o z° 2 .. c ,� g o a c C7 F- z E E a I- > U W - � J Z o o (o >- E = Q 3 Z o O C'3 Q T > > c (n a� C'3 Z aa) p 0 � a) N p 0o U z W v U LL Q c c a> - a: cQ W cn DC Q o c c > a Q Q LL c a a� p E E o Q a� o Q Q ,v IL cn W o c (n w CL o o ~ O o m ~ W W O m ~ o Z) U U f- CL w OC p LL p IL U J v O Q W W 2 Z W LL. D k Y rr V / Q Q m Q UJ rr Z W E w gLL LL m O OJ D F� w _ W V U U) v Om 0 W o LL MM ' W r Z O W jr Z rn Q LL c E (1) �U C ca c 4— (1) U) O Q 7 Q (i5 L c .N c O U N .c U Q a`> LL. 0 � r U O N N c 3 o 3 O M U L l� O U O Q U O IL M +-� ❑ O WN N c U = c W Q cNc F- O c O U O cn C y_ O W F- Z 4c 4c 4c O(A Z City of Blair, Nebraska Schedule of Findings and Questioned Costs Year ended September 30, 2000 FINANCIAL STATEMENTS: Type of auditor's report issued — Unqualified. INSTANCES OF NON-COMPLIANCE: No matters were noted. REPORTABLE CONDITIONS: Segregation of Duties — One important aspect of internal control is the segregation of duties among employees to prevent an individual employee from handling duties which are incompatible. The investing, bank deposits and the posting of the cash receipts to the cash receipts journal are all done by the same person. Recommendation - We realize that with a limited number of office employees, segregation of duties is difficult. However, the City should review its control procedures to obtain the maximum internal control possible under the circumstances. Response — We will consider this. Conclusion — Response acknowledged. The City could segregate duties to the extent possible with existing personnel and utilize the council to provide additional control through review of financial transactions and reports. - continued - City of Blair, Nebraska Schedule of Findings and Questioned Costs Year ended September 30, 2000 - continued - FEDERAL AWARDS: Type of auditor's report issued — Qualified. INSTANCES OF NON-COMPLIANCE: No matters were noted.. REPORTABLE CONDITIONS: Segregation_ of Duties — One important aspect of internal control is the segregation of duties among employees to prevent an individual employee from handling duties which are incompatible. The investing, bank deposits and the posting of the cash receipts to the cash receipts journal are all done by the same person. Recommendation - We realize that with a limited number of office employees, segregation of duties is difficult. However, the City should review its control procedures to obtain the maximum internal control possible under the circumstances. Response — We will consider this. Conclusion — Response acknowledged. The City could segregate duties to the extent possible with existing personnel and utilize the council to provide additional control through review of financial transactions and reports. IDENTIFICATION OF MAJOR PROGRAMS: CFDA# NAME 14.228 Community Development Block Grant DOLLAR THRESHOLD: $300,000 AUDITEE WAS NOT A LOW-RISK AUDITEE. 70 zT � te0` �z cma) �O co a•, Z U U U U U U U U U a� ❑ ❑ ❑® ❑ ❑ ❑ �� o L M co M M MM M U W +1o0' — am am am El El am ❑❑ am ❑❑ aoo ❑❑ am ❑❑ am ❑❑ aoo El El am ❑❑ oo U) �«_ ®a ❑❑ m U) C W p o O _ Q � Q C�•N o OO w c0� JO @ OO aW a) �a Z O +, y U O " ro m ro ro = m O 13 c t— v LL E to a Q O O O S~ OW OO c w � 6 �s � ka � 1.0 V) L. L. c1.Qa W O O .Y U @ W (D L o ,_ c o N Qv QC, o� a"i w Z C N O E tr to zo o c O o o 0 O Q~ > o m Ci ` �Q � a) o O Y 0 N 0 o N a) 0 !A O f4 y 0 fq O N y O N O N a) O Ey y 'O L p Q L y E "a 0 Z 0 } Z a� }' Z } Z } Z } Z } Z } Z \�_ /- Z } Z Q a> Q) '� r fl. r N r N N r N r N N N r N r N r N •p v-- O 1'_'' C O O +_ O _ ro a fn y y NU N M C L LL C O a) .coCD .. U d C ri N a �co Em,N 0 Z U = 0> C OU co C C v O O �f m 00 d M d rt Ln O l0 c co N c 4> U E' 0 0 [ [3l y a E Q a X m - N N Q0 rl o cp c N E L 'y i O 6 Q co vNU O CO Ln d +, U U �— Q0a L O p m O > f0 d9 E1? Efl (�? EA (f? EA 69 d9 46q E!i «+ 4 a G_ 0.. pC Q 0 T O �= .L '6 6= N _ CO W CO aci m 44z LL a � co W 0 L n3 0 O V M o a c @ U C J, m aai rr C1 LL I C7 x U 44 �, ro W Co m o +' m E k m N Z LL co ° N ) o a O o n E-1-1 4J O y W c 'c o CC p a> a E > -4 a) O Q aci y c a n 0 o m 0 p Z Q 3 ro O N ro � 3 a) o Q aa) U ani a Z is E W i.� U � O �.L ��E< z c c J „ W J tL +� is H o s, E 0 o a) c m Q a— L> a1 0 0 3 `° x LU I O x r i r ro I ro ro W 4-4 a+ O CC c a) c cU0 C a� a- `a m a> c Lu U) -i w W a1 m c" =ccooE —E v L •> > 4J ro v ro ro m a4 .� •Q• >` co 0 (n Co LU 2 LU LL Q O ro N O ro tZ a LL c a0=mm_� c 0 E <<uoww "C v z rZ4 w U y OU QmCioWl.i •= Q a L J !.. 0 O O CC a a) co O O N Ol tCl 0 O n fl - w o .0 c N l0 Ln L(1 l� t11 O ` ? h> O F- Lo LL E • LLL U O d . O O . N M C ri N N co ri ri N Cfl Page 3 FORM SF -SAC 18.971 'U.S.GPO:1997.54"78180114