Loading...
HomeMy WebLinkAbout1990 CAFR ~ I }, , I JI Ir CITY OF ANDOVER II FinanCial Report . Year Ended December 31, 1990 - I'i ' .. - - m It I I I I I - I I I I I I I I , 'I i I I I I I I I I I D CITY OF ANDOVER Financial Report Table of Contents Elected and Appointed Officials Financial Section Independent Auditor's Report General Purpose Financial Statements Combined Balance Sheet - All Fund Types and Account Groups Combined Statement of Revenue, Expenditures, and Changes in Fund Balance _ All Governmental Fund Types and Expendable Trust Fund Combined Statement of Revenue and Expenditures - Budget and Actual - General and Debt Service Funds Combined Statement of Revenue, Expenses, and Changes in Retained Earnings - Proprietary Fund Type Combined Statement of Cash Flows - Proprietary Fund Type Notes to Financial Statements Combining and Individual Fund Statements General Fund Comparative Balance Sheet Statement of Revenue, Expenditures, and Changes in Fund Balance - Budget and Actual Special Revenue Funds Combining Balance Sheet Combining Statement of Revenue, Expenditures, and Changes in Fund Balance Debt Service Funds Combining Balance Sheet Combining Statement of Revenue, Expenditures, and Changes in Fund Balance Certificates of Indebtedness Debt Service Fund Statement of Revenue, Expenditures, and Changes in Fund Balance - Budget and Actual State-Aid Bonds Debt Service Fund Balance Sheet Statement of Revenue, Expenditures, and Changes in Fund Balance Tax Increment Bonds Debt Service Fund Balance Sheet Statement of Revenue, Expenditures, and Changes in Fund Balance Special Assessment Bonds Debt Service Fund Balance Sheet Statement of Revenue, Expenditures, and Changes in Fund Balance Page 1 2-3 4-5 6 7 8 9 10 - 31 32 33 - 41 42 43 44 45 46 47 48 49 50 51 - 53 54 - 56 ~ I r'! ~ c c c c c ~ ! ~ ~ ~ ~ ; E I I I I E . I----- -==-~~i- I CITY OF ANDOVER, MINNESOTA I Financial Report Table of Contents (continued) I Page I Combining and Individual Fund and Account Group Statements (continued) Capital Project Funds I Combining Balance Sheet 57 Combining Statement of Revenue, Expenditures, and Changes in Fund Balance 58 I State-Aid Capital Project Fund Balance Sheet 59 Statement of Revenue, Expenditures, and Changes in Fund Balance 60 I Tax Increment Capital Project Fund Balance Sheet 61 Statement of Revenue, Expenditures, and Changes in Fund Balance 62 I Special Assessment Capital Project Fund Balance Sheet 63 Statement of Revenue, Expenditures, and Changes in Fund Balance 64 Proprietary Fund Type I Combining Balance Sheet 65 Combining Statement of Revenue, Expenses, and Changes in Retained Earnings 66 I Combining Statement of Cash Flows 67 Water Fund Comparative Balance Sheet 68 I Statement of Revenue, Expenses, and Changes in Retained Earnings 69 Statement of Cash Flows 70 I Sewer Fund Comparative Balance Sheet 71 Statement of Revenue, Expenses, - and Changes in Retained Earnings 72 - I Statement of Cash Flows 73 Fiduciary Funds I Combining Balance Sheet 74 Expendable Trust Fund Administrative Trust Fund I Statement of Revenue, Expenditures, and Changes in Fund Balance 75 Escrow Fund I Statement of Changes in Assets and Liabilities 76 I I I ... =-....- ~... ~- m ~ ~ c ~ c ~ c ~ E ~ ~ ~! ! II I ~ E C E t--- ~ I I I I I I I I I I I I -I I I I I I I I ... CITY OF ANDOVER, MINNESOTA Financial Report Table of Contents (continued) Statistical Section (Unaudited) General Fund Revenue by Source General Fund Expenditures by Function Tax Levies and Collections Special Assessment Levies and Collections Computation of Legal Debt Margin Schedule of Sources and Uses of Public Funds for Tax Increment Financing District No. 1-1 Schedule of Sources and Uses of Public Funds for Tax Increment Financing District No. 1-2 Single Audit and Other Required Reports Independent Auditor's Report on Schedule of Federal Financial Assistance Schedule of Federal Financial Assistance Independent Auditor's Single Audit Combined Report on Internal Control Structure Independent Auditor's Compliance Report Based on an Audit of the General Purpose Financial Statements Performed in Accordance With Government Auditing Standards Independent Auditor's Single Audit Report on Compliance With the General Requirements Applicable to Federal Financial Assistance Programs Independent Auditor's Report on Compliance With Specific Requirements Applicable to Nonmajor Related Federal Financial Assistance Program Transactions Independent Auditor's Report on Compliance With Minnesota State Laws and Regulations Schedule of Findings Page 77 78 79 79 80 - 81 82 83 84 85 86 - 88 89 90 91 92 93 ~ D D C C C C t C E m " Ii I ml ;1 I E E I ~ . '----l- I I I I I I I I I I I I I I I I I I I CITY OF ANDOVER, MINNESOTA Elected and Appointed Officials December 31, 1990 Term of Office Expires First Business Day of J anuarv Elected Mayor J ames Elling 1991 Council Michael Knight Marjorie Perry Donald Jacobson Kenneth Orttel 1991 1991 1993 1993 Appointed James E. Schrantz - Administrator Shirley Clinton - Treasurer Victoria Volk - Clerk Howard Koolick - Finance Director -1- , ... C D C ~ D ~ m m, ~ E II ! II ~ E I I E E I -- ~ -_.-:==- - ~.---- I I I I I I I l I 1 I ~I I ;1 II il il ,I I I I I FINANCIAL SECTION i -- c C D E C ~ ~ m E ~ I E 11 I I E E ~ E - -- ~- --~--=--. I I I I I I I I I I I I I I I I I I I - PANNELL KERR FORSTER Certified Public Accountants 400 Park National Bank Building 5353 Wayzata Boulevard Minneapolis. MN 55416 Telephone (612) 545-0421 Telefax 612-545-0569 INDEPENDENT AUDITOR'S REPORT City Council and Residents City of Andover Andover, Minnesota We have audited the general purpose financial statements of the City of Andover, Minnesota, as of and for the year ended December 31, 1990, as listed in the table of contents. These general purpose financial statements are the responsibility of the City's management. Our responsibility is to express an opinion on these general purpose financial statements based on our audit. Except as discussed in the following paragraphs, we conducted our audit in accordance with generally accepted auditing standards. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the general purpose financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the general purpose financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall general purpose financial statement presentation. We believe that our audit provides a reasonable basis for our opinion. The general purpose financial statements include the financial activities and balances of the City's General Fixed Assets Account Group, all of which are unaudited. We were unable to audit the General Fixed Assets Account Group because the City has not maintained detailed accounting records of its general fixed assets. As discussed in Note 15 to the financial statements, certain of the City's general obligation bond issues are subject to federal "arbitrage" laws, which may result in the City having to rebate estimated "arbitrage earnings" back to the U.S. Treasury. As the City has not made the calculations necessary to estimate this potential liability, no liability has been recorded. In our opinion, except for the effects of such adjustments, if any, as might have been determined to be necessary had we been able to audit general fixed assets and the potential arbitrage rebate liability, the general purpose financial statements referred to above present fairly, in all material respects, the financial position of the City of Andover, Minnesota, at December 31, 1990, and the results of its operations, changes in fund balance, and cash flows of the Proprietary Fund Type for the year then ended, in conformity with generally accepted accounting principles. (continued) -2- --~- D D C C C Ci ~ ~ m m Ii I ml I ~I I EI ~ E ~ ; ~ ~ . - ~ I 'I I I I I I I I I I I I I I I I I I , -- As discussed in Note 1 to the fmancial statements, the City adopted the Governmental Accounting Standards Board Statement on Reporting Cash Flows of Proprietary Funds for 1990. Our audit was made for the purpose of forming an opinion on the general purpose financial statements taken as a whole. The combining and individual fund statements as listed in the table of contents are presented for purposes of additional analysis 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 our opinion, is fairly stated in all material respects in relation to the general purpose financial statements taken as a whole. The statistical information as listed in the table of contents is not necessary for a fair presentation of the general purpose financial statements, but is presented as additional analytical data. This information is unaudited and we do not express an opinion on it. 9~ ~ \::-~ March 22, 1991 -3- -- ~ c ~ D ~ C ~ ! EI E " ~I I II ! EI E I E I ~ I I ~I I I I I I I ] I I- II il 11 jl :1 'I I I g GENERAL PURPOSE FINANCIAL STATEMENTS '-=- '" p.. " ~ i:i " o C) < M .... -g " .. ~ -S ~ a'S 0\ 8 ~ Q.,- 4) ;;> ;.. '0 O~~!.+-I 0"'" .... 0 Z '" " '" <&:-S: ~-"'3 0:;( g 0 >< ' 0 Eo-< b"'''O~ t.> ~ <'~ " l;; C) S' ~ 0 ttl U "'" -5 ~ o~ :E ........ S o U ~ co '" - .-....iiiiiii i:-~ .~ ~ ::S." ." " ii:;~ i:-~ ~ .C f-< 2"] ~'" _ E fi " - <<)~~ fi ~o eOj o ~ ~ " :l ." 0_ M It) <~<:a g"3 ~ o >< l<: .!! .J:> " ~ 1! 2 "f-< t -~ .~ ~ I;- Og U~ " " f-< ." " Ii: 1 " S e " ~ o " ~ .g 2l ~ en :3 g g ~ ~~ a- GO ~ o a- a- - O~!l ~ l'l e " " " o .. :0 " Cl IS 8 '8 .. :l " " < ,.. GO .... 6 8 .c - _\OO~_V')IO ~~o~~~ ~ ~ti:ta"~~ V; _('I") ('I'\M- ~-: ... .... '" '" ..; GO .... ..; - ~~c::t~8~~~ "I:tOO'lO_MOCO('t\ ":~o"icCoo\V) :2~OON~~~ 00": ... ... .. '8 " ~ .~ i:- II " E' .s ~ -g~ " > ii '8 .. " ..UI"i ;> .. .( ... '" ,.. ,.. ,..: GO .... ... a- 8 '" GO ,.. ... ~ GO .., ,.. ... '" ... 8 "'. '" '" - 6 - ... ... '" ... .... '" ... .... GO .... .c '" '" ... . '" , - '" -<5 ~g:; .... GO r:f'i :l '" .... 0 "',...... ,..,..'" ~o ,.. '" ~ ....- '" ...'" .... _.... a- ............ "":M'''': .... '" I _\CO_V")_ I o\O~O\oc"" C"'lvV')oor-o t--" U"'l" v""; "":0\ V)vO\OC"lt'N _ _O\_M 1"'-.....: , 00 I 'd" ... ,.. a- '" .... '" _ a- '" .... a-- ~.v; ,.. .... '00 "'.... .... '" 6 GO ~ .i .. '811 is E " " ~~ :l 'S = ~ - ~~~ ~ ; ~ as = ~ t :3~ ~g. ~8.!t'3 sli'3,g~ = c ~ 0 "'0 " "'" s e g.g.~.g.g :a:Ec.2oo 2l2l2l~lS '" GO .... '" 8 i e g 0. ".= 'S .! go!! ." 0. " " ..." i] .!!.s 0.= i:- . e g~B " " u " 0. .. .s~"O -4- - a- a- '" a- '<t '" - .... "'~ a- '" '" 0 ~o GO .... .... a- "'''' -- '" :l '8 a- :6 GO _~ a- '" - a- .c", GO a- .... '" 6.... - - GO _~ a- '" - a- oC'" GO a- .... '" s:"~ .... '" '" t '" '" .... '" '" ~ .... ..... :l ~~ " ~, Of ~ ".sa en .. ~r.S 2l1l .5 ~ .!! g .J:> 0. ..!! " 0; "g ;: g Zlc= - 5 5 ~~~ .. " ,g o ~~ ~ ~ ~ ~ ~ ~ ~ re ,.. .... o .... ~ ~ ~ :;- " E .~ o ~ :l i ." .. " ~ '8 .. i .. .. ~ .- ~ c c ~ ~ ~ ~ E ~ ~ ~ E ~ ~ I '" <: " J '" ~ 'g .. '" l;; B '" E g " " tI.l ~ ; ~ I --'" I I I I I I I- 1 I ~ ] I '" "0 " ,s i:i o ~ '" g- o k o '" 0\ 00 0\ - ~ ~ 6 t go {; ~<~~ ~]-~ 0","':-0 "'........ S G.> ~ 0 :< :;:2 ~ ... El '" "'0 do)] s::: ~ 0 &0... .... " o .e: '" 1;; <: k " '" " 0- "" Ei <Il 0 " U g oS ~ ! lJ:I "0 " l::l :E Ei o u ~I ~ o >< t::- u<: , I I I I I I I I D - e-~ .~ ~ "'" :E a ~~ e-~ ~ '1:: .... 000'" B " ll<1f - e ~ ~ .e rn ~ ~~ et:l,3 t:l "S 5 s~ ~ _ t) "0 -< ~~,;..~ fi -g _ t:l " u; ~ ~~ ~" ~n~ u~ .. " .... ." " If 'S " e E " ~ t:l " .&J .2 " e Q " '" " "; e '3 " 000;; "'~ '" 00 2: o '" 2: " :0 .. ~ 1l 2 ".... ~ e " " " t:l , ~~~~~~!~~ ~~O\S~r-~~ ...; QO M"' - .... ..- ... ~ ~ :g ~ ~ !;;: ~ ~~~ O\OOMO\ONMCS('f"l _"' N"_"' \O"'r-: ~"t--" _ N"' ('f"l~\O:::"""I.I'l::::~8 S~~ ... IVU":l"'lt'\01 r-O\V')N Mv\t")t-- o\o\''':r-i '" '" .... , 8~; - ..- ..- 00 "'0:. '" '" .... .... ... ... ::l' ~ i '" ... , '" ..- '" ~ '" 00 00 _ ......- o\~ ... ~~~8~ N...... 00 M_ ~~....:...; NOOV'l_ o , 00 '" '" o '" o 0\ 00 ..- '" ..... ... ..- 00 ..... ..- '" '" 00"'; - ..- c: ... o '" ":. o '" "," ... ..- , ..- .... .... ... 00 00 ":. ;:: ....- '" '" 00 '" 0\ 00" ....'" . '" o "l. '" '" ... II :0 e u ~ " 6 II 'e " .. ;g ~ ~ ~ 'S f,) u ~ ~ u 4) ~ !!5~:g~.!! .~ ~ ~ ~ ~ ~ e ~ ~~o"'Oo~"'O!. "06eeB'~trn ~ ~ 0 c 0 u Oot~] u<8<QQd~ :E .. ;:l ." " .. ~ '5 $ ,; ~ :E .. ;.::l , 0 ~ i '" '8 '" .,.; 2: '" ..... ....0 '" '" \rj....,;- '" ..- ..- .... f"'t"'ti 00 ..... '" M ~ :;l8 '" ..... ...co"' '" 00 '" .... M~ - ..- '" '" ~ '" , '" '" .,; '" '" M '" '" '" M ..- ~ 6 00 "!. '" - ..- '" '" 6 !;;: '" I;! "," .... '" '" II ~ 8 ~ 'E ~ II <= ~ 0; O'~ lo.:. '0 "'0 .~ 8:3 rtJ t+= ~ "0 u.... 04"g.,gc2 eo.og..5e;-"'d o.50E1AUU tt:]5e~t ~e.E-g:5]~ "0 ~ 'B.5 c u c::.s "'8 ~ ~ 0 U r;:' t-....u~ .... '5 $ -5- .... ..... - ~ ..... !::l" , ~ ' ~!;;:~ ..... "'''' \Co. _ QO .... ..-.... ..- - .... ... '" '" ~ ~ ~ .~ ~ '~~ ~ .~ ~ ~ :e .... ..... o '" 1~ ~ . ~j~j j ';j ~ .... 00 '" .,.; '" '" ~ oo_"'~"'~ \ONOOr-M r-V)O\ooo t--"'ON"MN :o~~~8 ..; 0 '" _ '" ~oo~ NOOr-N \I") 0\ 0 v g~8~ ("")-N('I"l f'l"l"' _ N .... 00 '" .,.; '" M ~ 00 :e ,..: - '" II :0 ;;; II e .~ 0 0 0. U t e .~ -= oS bIJ Q., U 0 ~ s & "8 c:'s..'S to ~::g' t- 10( ...... '0 <ScScS"i3'" ]]]!'S ~ ~ ~ .- ~ "'3 .~.~.~.g t :i .ii ~ t: llQ~Q::> ~ ::> ~ '5 '" " II " ,~ .~ e .'";; () := '-I .c " ~~ !i 2J l::l " S ~ '" "'iil .0 l::l '" l::l ..: B '" " o l::l " " <Il ~ ~ o o z < u.. o >- ..... o g CI:l <a III ] &:] =u.. ....c.... ,.-..l .,., M ~~ ] CI:lo 8 ..s::::::-OQ) u~O\o ~O\ 0 ]=-0 CI:l 8-.-g .,;,~ M ~ 0-.... = E]2~ :QCI:l8; =.,00 000>- c.. ?<~ >< ~.... ~.....~.s 0] -8 .!:'3 e ;:i,~~ ou..- 0 >- ......... ~E~ ~ .... 0......,0 08 e C5-c cd 00 ~ 815 0 ~" u ~- .;:j tI) ::( ._ ] ~ ~ o U --- c o .!!lE ,s-6 0= E-<f: ~ " ::E m e;> _ '~E-c <<I ~ g"", = 2 "'" = E-< .~:> ~ It. It. s: 00 0\ - '" 00 '" - OOO'\MO""l:l.~ ~:n; ~ ~ ~ ~~ \0 cO 1.O"M'r;..QC(;.,..:- \OV"l\Clt"l~"IV'l t--MO\NM C""l" ~ .... o '" '" - N8OOMNNO -.:t MO\M\C)V') 0\ \0["'--0\\0 ....;~oo...t'f~V)~ g:~~-,::;~l'- '" .... I I , I I I I .... I 1\0 'N I I '" ~ 00 '" 00'" 0'" t"- '" ~ - .... t"-~'" 00"'''' "'ot"- 00\0\ oo~~. '" I 00 I I Vl o >D N '" .... 11M I I I I .... 0; ... " C " ~ Vl . ~. - - '" I MNl......O O\N10V"l r-- 1:"--,,, \0 c-r v51n \0'" __I...."!:t N'" .... OO"'Vl"'f6~ to~OO~N o. a7: ..: r:i - . \0 MM "I::tN rot . - Vl~Vlo_~ o t"'lOO"lt "1.. ...t--...-.::t...M-... \0\1")\00000 _ -MN "l. . - 'r r~' 'f Vl - '" . Vl I I 1 !;;:. 00 '" N' t"- r-:. Vl , 00' 000 00 ~ . "'r 'o"'~ 00 '" "I::t...v.... 00 '" '" 02' !;;:~ Nv)'" ~ - t"-' ~ - 00 N !l '" i 1" ~ e:> .50 8:> Ii = ...~ e s.~ fj -B ~re eIl- a ",Ii 5~t~ E-g'~-g 8~ e _ E "'" "..!l 5..'~" = S5~"'OeUll-c _-130= ..ElI)cc....~ ~~"'C"'O:::::I :> "'....0 1:0 =8 "'0 e ~ (I) t)~] o~~~ fn . t)...-I lI) ~ Go) = '€: = = U'''''' t3.s.~ a l:II;l~fI.l l-c_U)t:l-.~:a t))<)<Ro.>to:soU = = = ~.~ C ..c: .S = liE-< E-<cn....:l...... U It. 0 ~ ~ ~~~!~~ . ~~~f~ ~ ~~~-NN O\~~ gg NN t::~~~!~~~~~~~ ~ M";o\o\"';o\~o\"';- ....... O'\V')ON\oM-N-M - V"lt--M N __\I"l \0 ci- r: - ~ I I . I I I I I I I I gg8~~ ~ Vl 00 Vl o""I::t"r;- t"-"'OO _Vl Vl ~-=-- '" '" M'~~ t"-oooo ~"'oo ~~g~ ~-- ~ 00 '" ."', ~;;:: a7:N -00 -- " , " " l~ I " ~ , , , , , , , , '~! ;i~1 " .. ..~ ~ T~ '~i lfj I If"'- I ~ Vl N ~::!;~~~~~~I f"'-O\O<o"""l"l:tV'lC'tV'l M" ..,; r-: 0\" ..: 0\" ..,; 0\" 0\ \rl 0 N \0 ('~"i'-" N V'l("'-otf') N ?""'t i! .;! -g ~ I) 11 ~ g Ii e .... o i! ~ .~ .g "'" 0 = ~ 1: t ~ = s ~ 0; ~ i ';g< ~] E I: "il !l ~ .... ",,",'" II ~ II ~:t~ I: ""'lr8'.~ ~c.;;o="'Ob.O~"'p..~ !'10; '" ~.s iUra !l_ I) t;~()Q~ QOO,gCfJ :::s u;.=.;.:::.-sJ2 ~c;::::l........ :a1i.g.g;t;;1l8~~il ~~~~cn~~Ill:::>U~ III -6- ~ :> o '" co .50 o ; .g ";' _t M =-5 E. .5 ~ 0 !'1 e rlS o ~~ 0 ~VJVJVJf-04 5l]~~ ~gb.OCI:I ...... e = g p..''c';j ~gii ...lQOO ~ o ~ '" " '" 2. '" CO" = '" .~ :> gco ~.5 ~g .... ll.g - 011 ""'.c ;0 """, :>= c .. ~i! '- ..s 0"'" ~~ Ii" 't) 1-4 '-fi~ .,,0 ~~ :le ":> ~o lI.l'" ,.,. 8 ~ ..: 8 .; 0' , '" 00 ~ '" - 6' Vl 00 o' ie. ~ ION~~ "''''''' N"'''' ~oo "'-- NIOIO r-:..:-- - ~ ~ ~ - ~ t"- ' , t"- '" .; - ~ 6' 00 t"-. Vl t"- - :::. 00, OON'" "'t"-~ v;MO C;C;.f6~ '" @' N ..: o "', ci "'t"-,~ "'o~ Vl"'~ o\..co 00"'''' "''''''' N - g, o .,; '" ' , 00 '" o' '" ~ o. 00 ~ <'lVl' 00 "'''' ";0 -- '" "'''' ...... ..a~ "'''' == kf:f: 5-- ~.e-~ ~'5'= ~ifif 8's,,;~ cc== =.S:;:!:2 c; b.O Vol CI) ,J:) 11) U U "",lQ~~ = &: ~ .5..9.. -- ~j ~ ~ ~~ ~ '" N "" ~ ~ ~ ~ ~ E ~ ~ E ~ !I mi Ei I Ei I EI ~ ~ I ... 5 '" .... o "'" = III E e ~ ~ ., <a '0 = gj 0.;:: 9 ., $:l 8 o o tI) E D ~ ~ I I I I I I "<'l B -< ] 0::1 ~ eJ) "0 ::l ::0 1 "'0 "'''00\ <1.lr::0\ B&:- 0:::._ " ~"O<1.l_ > as.~("l Oo..i::~ o ~ <1.l.o z~ene <].:08 ~o;j<1.l<1.l 0<1.l00 ::l"O"O ><r::r::d> E- <1.l 0::1"0 - ~"<'l r:: uO:::..~ ""'~~ 0<1.l<1.l c:Cl>< <1.l e <1.l !S en as r:: ~ o U I I I I JI , 11 I I I I I I D ~ 't:'t) ~<1.l ?]"O o8~ ,.....,..... ('l-('l -000 -O\l/') 00"("l" ec!:: " - {h '" ] &: <1.l u .E <1.l en ~ o "<'l B < t-80\ 00 ("l 1,0 ..q- o o\"l/')" oo~lQ ('l" io'} o\l/')t- 0\1,Ol/') t-O\OO 0" O\*' .-4" --00 -l/')Ir). - ~ "0 ::l ::0 io'} ,.....~ L.4~Q) ~]"O o8~ ,..... t- 1 . 0\ t-" - '-" io'} "0 r:: &: "<'l ~ r:: <1.l Cl l/') , l/') ('l" - - 0\ "<'l B < {h ~ ('l , ~ ("l - 0\ io'} "00 1 l/') t- ..; t- - "00 , :g 1,0" ('l ("l '8 ' ("l" - l/') - ,..... ,..... t-00('l0 0('l1,Ol/') oo('ll/')("l ~"('l"~8 '-" '-" 1 ("l('l('l0 0\('l1,Ol/') t-t-O\I,O ('l"I,O" vi 1,0" --t"'-'V ('l 1,0 '80\88 1,O..q-..q-0 ...; ..q-"..ot-" l/')-I,Ol/') ('l 1,0 ~8" ("ll/') o ('l "t-O t-o 00 t-" ("l0\ ('l t- ..q-" - ~~ ..q-"l/')" ("l t- , t- 00 lXi~ ("l..q-" ('l t- ("l ..q-" t- 1 ('l 00 0" t"l l/') 1 00 ..q- t- ..q-" 0\ 00 ('l ,..... ("l l/') 00 101~ 001,00 t"l0\1,O S'\.~~" '-" - - '-" :i 1 ~Sj~" 00 t"l t"l M C"l ~ - 00 N 8 0" ..q- "88~ -"..q-o" ool/')oo N t- 0\" - i 5 e 5 ~ 5 ~ ~ <!.l .- ::l 8 r:: "8 <!.l s.~ ~ o.(i) ~ e 5 8 CiJ.~ 5 as .. ~.:: <!.l e <!.l c: i::.- r:: "0 "0 0 '" !5E"'o..<!.l~~ ~f;if;i<1.l0 !~I~~.s~ ~~.g~E- 0::1 g "<'l ~ ~ ~ f;i 11 ~ ~ .1!l '" ._._ r:: eJ) eJ) '" .. r::._.v """ <1.l <!.l g <1.l ~ ~ <!.l <!.l- v.... """ 8 ~ ~ o...~ c:..r:: .S -fi <1.lE-E-en...:i_U~O ~ cz:: 1 , 1 00 00 0\ 0\ 0\ 0\ 00 00 00 ..q-..q- -- . I I' I 0\ 0\ 00 00 ..q-..q- t"lC"l -- ..q-v -- -- "_- 0\ 0\ VV ..q- v 88 00 -- ...-.......-......-. .-....-.... t"looooN("lt"lC"ll/') ..q-1,O-t-01,Ot-1,O l/')l/')l/')000\0-C"l ~ "':-O('l"N"l/')"t"l"O\" ('f1 \0 ...........M '-"''-'l''''-- '-""-" oo..q-I,OOOO\t-O\0\ t--..q-l,Ovl,Ooooo t-O\O-vl/')Nl/') ...;..q-"r-:~ -"~..q-"~ O\l/')ONI,OC"l-N l/')t-C"l N - l/')N..q-OI,OON..q- t"lool,O..q-Vt"lI,ON N..q-l/')Ol/')l,OvN ..q-"I,O" r-: N" 00" ..q-" t-" 0 ooool,O("lC"lV-l/') l/')t-("l ('l c: r:: <1.l ~ 0 e ~ .,0 0.. El gs 0 "<'l e .... 1E 0 ~>'x.i! g <!.l <!.lE- o t) ~ ~ "CJ~.u '" eJ)~ 0 g "0 ~.~ 'li1 E ~ "<'l '" ~.- f;i.- e u <!.l ~L.400~ uOOVl ~ Q,)'-'- ....., tfj >.. d :;a .....,. :g as:g:g'~ ~ g 8 r:: i5 <1.lClil<il<enil<O:::W;::JO ~ W -7- , ~j '~ 1 t"l 00 - - ('l - N ~ .. .8 :g <!.l ~ C"l ..q- - '-" ~ .. .8 ] ~ ~ > o <!.l 8 <!.l ~ .. ""' o ,..... >. u 5 .- u t;:: <1.l ~ '" ~ u ~ ~ ('l o t- o t- ,..... I,Ol,Ovoo t-OC"lV -t'.....c["-- \f')" -:- V') - t-l/')C"l0\ O\t- 1,0 ...; v ,..... - ;; 0\" C"l q C ,..... C"l ..q- t-" g - c ,..... - N N" C"l !!:?. '- 00 - t-" ..q- ,..... 00 l/') C"l ..0 0\ - '-" 1 00 - t"l 00 00 - t=:' t"l - It"-It'-- t"l C"l - - - ..q- - ~ .0 !a r:: oP+: ::l.. r::0<1.l .- '-"-fi ~ "''''0 u .... .. ~~"<'l ~~ijij~ bJ)(i)J::J:: .s g eJ) eJ) u..r::r:: ~ Cc"';:: '.0 r:: "0 l:! l:! t;::"I<1.l<1.l ~ ~ 8'8' 8 ,..... ~ '" e o l/') ..q- N 1,0 t- V " j ~ ~ 1 00 - C"l 00 00 - - ..q- - ,..... ~ '" e eJ)~ r:: '" 'u = r:: eJ) 0::1 r:: ~ "g :u ~ -fit;:: o ~ ]-fi 0::1 0 <1.l"O 8 !a ~ ~ <1.l .. ".8 ""' .- 0"0 ->;5 ~ ~ 'u ~ t;:: ~ <1.l > ~o '" ~ ~ ~ u ::l ~ 0 ~ '" '" J 'li1 ..... '" "<'l .0 f;i r:: t;:: B ~ u .. ::l o '" 1($ ..... o r:: <1.l <1.l en CITY OF ANDOVER ~ Combined Statement of Revenue, Expenses, and Changes in Retained Earnings D Proprietary Fund Type Years Ended December 31, 1990 and 1989 Enterprise Funds C 1990 1989 Operating revenue & User charges $ 508,933 $ 374,008 Meters 26,185 29,710 Permit fees 10,750 12,800 ~ Penalties 12,445 13,601 Other 1.737 268 Total operating revenue 560,050 430,387 ~ Operating expenses Personal services 95,838 82,941 Supplies 25,080 21,763 C Meters, etc. 21,662 25,164 Other services and charges 28,112 40,861 Disposal charges 212,665 180,181 I Total operating expenses 383,357 350,910 Operating income before depreciation 176,693 79,477 Depreciation 324,588 312,792 E Operating loss (147,895) (233,315) tl Other income (expense) Interest income 18,054 9,721 Interest expense (748) E Total other :income (expense) 17,306 9,721 Net loss (130,589) (223,594) I Other financing sources (USI~S) Operating transfers in ~ Debt Service Funds 30,500 Operating transfers (out) Debt Service Funds (7 ,246) ~ Total other financing sources (uses) 30,500 (7,246) Add credit for depreciation on contributed assets 317,905 309,893 E , Income closed to retained earnings 217,816 79,053 Retained earnings ~ Beginning of year 252,578 173 ,525 End of year $ 470,394 $ 252,578 ~ See notes to financial statements ~ -8- I -- -l-- ;;;.....;;.......~- I I I I I I I I I ;1 il I I I I I I g I CITY OF ANDOVER Combined Statement of Cash Flows Proprietary Fund Type Year Ended December 31, 1990 Cash flows from operating activities Operating loss Adjustments to reconcile operating loss to net cash provided by operating activities Depreciation Change in assets and liabilities Receivables Accounts Delinquent special assessments Deferred special assessments Due from other governmental units Inventory Accounts payable Accrued expenses Due to other governmental units Net cash provided by operating activities Cash flows from capital and related financing activities Acquisition of capital assets Cash flows from investing activities Interest income Cash flows from noncapital financing activities Operating transfer from Debt Service Funds Net increase in cash and temporary investments/cash equivalents Cash and temporary investments/cash equivalents Beginning of year End of year Supplemental schedule of noncash investing, capital, and financing activities Assets contributed by other funds See notes to financial statements -9- Enterprise Funds $ (147,895) 324,588 (17,010) (2,265) (20,223) (630) 75 11,831 (321) (20,668) 127,482 (53,402) 17,318 30.500 121,898 163,171 $ 285,069 $ 353,704 .... c c C E ~ ~ I I i Ii I ~I i ~I II ! Ei ~ I I ~ ~ ~ - .~;;;;;;::;: --==~Oo--'-" _ ~~ I I I I I I J I J ) I . ] I ~I I I I I I I I I I .!! CITY OF ANDOVER Notes to Financial Statements December 31, 1990 NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES A. Organization The City operates under "Optional Plan A" form of government as defined in the State of Minnesota Statutes. The City Council, composed of an elected mayor and four elected trustees or councilmembers, exercises legislative authority and determines all matters of policy. B. Reporting Entity The City's financial statements include all funds, account groups, departments, agencies, boards, commissions, and other organizations over which the City's officials exercise oversight responsibility. Oversight responsibility includes such aspects as appointment of governing body members, budget review, approval of property tax levies and special assessments, outstanding debt secured by the City's full faith and credit or revenue, and responsibility for funding deficits. The Fire Relief Association is excluded from the City's financial statements because of the lack of oversight responsibility. C. Basis of Statement Presentation The accounts of the City are organized on the basis of funds and account groups, each of which is accounted for as an independent entity. A description of the fund types and account groups included in the report are as follows: 1) Governmental Fund Types a) General Fund - The General Fund is used to account for all financial resources except those required to be accounted for in another fund. b) Special Revenue Funds - The Special Revenue Funds are used to account for the proceeds of certain specific revenue sources (other than expendable trusts or major capital projects) that are legally restricted to expenditures for specified purposes. c) Debt Service Funds - The Debt Service Funds are used to account for the accumulation of resources for, and payment of principal, interest, and related costs of general long-term debt obligations. d) Capital Project Funds - The Capital Project Funds are used to account for financial resources to be used for the acquisition or construction of major capital facilities (other than those financed by Proprietary Funds and Trust Funds). -10- CITY OF ANDOVER Notes to Financial Statements December 31, 1990 NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (CONTINUED) 2) Proprietary Fund Type a) Enterprise Funds - The Enterprise Funds are used to account for operations that are financed and operated in a manner similar to private business enterprises - where the intent of the governing body Is that the costs of providing goods or services to the general public on a continuing basis be financed or recovered primarily through user charges. 3) Fiduciary Fund Typt~ a) Trust and Agency Funds - The Trust and Agency Funds are used to account for assets held by the City in thl~ capacity of trustee or agent. Agency Funds are custodial in nature (assets equal liabilities) and do not involve measurement of results of operations. 4) Account Groups a) General Fixed Assets (Unaudited) - This group of accounts contains the fixed assets of the Governmental Fund Types. b) General Long-TI~rm Debt - This group of accounts contains the long-term obligations of the City other than those liabilities included in the Proprietary Funds. Total columns on the combined statements are captioned "Memorandum Only" to indicate that they are presented only to facilitate financial analysis. Data in these columns does not present financial position, results of operations, or cash flows in conformity with generally accepted accounting principles. Interfund eliminations have not been made in the aggregation of this data. D. Basis of Accounting 1) Modified Accrual - The Governmental and Fiduciary Fund Types are accounted for using the modified accrual balds of accounting. Their revenue is recognized when it becomes measurable and available as net current assets. "Measurable" means the amount of the transaction can be determined and "available" means collectible within the current period or soon enough thereafter to be used to pay liabilities of the current period. Property tax and special assessment revenue is generally conside:red as available if collected within 60 days after year-end. State revenue is recognized in the Yt~ar to which it applies according to Minnesota Statutes. Their expenditures are generally recognized when the related fund liability is incurred. Interest and principal expenditures in the Debt Service Funds are recognized on the due dates. Major revenues sus(:eptible to accrual are property taxes, special assessments, intergovernmental revenues, charges for services, and interest earned on investments. Licenses, permits, fines, forfeits, and other miscellaneous revenues are not susceptible to accrual as they are generally not measurable until re<:eived in cash. -11- ~~I ~ c c c c ~ c ~ ~ E ~ ~ ~ C ~ ~ ~ ~ ~ ~ I I I I I I , I ; I I j I I I I I I I I I I I CITY OF ANDOVER Notes to Financial Statements December 31, 1990 NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (CONTINUED) 2) Accrual - Proprietary Funds are accounted for using the accrual basis of accounting. Their revenue is recorded when earned and expenses are recognized when they are incurred. E. Budget The amounts shown on the financial statements as "Budget" represent the revised budget amounts based on the modified accrual basis of accounting. Budgets are adopted annually by the Council for the General, Debt Service, and Enterprise Funds. Neither Minnesota Statutes nor City Code establish a legal level of control for the budgets presented. The 1990 budget was amended at the departmental level. The City made no significant amendments to the appropriations budgeted for 1990. The "Combined Statement of Revenue and Expenditures - Budget and Actual" reflects all budgetary to actual comparisons for Governmental Funds budgeted by the City. Encumbrance accounting is not used and expenditure appropriations lapse at year-end. F. Cash and Investments Cash balances from all funds are combined and invested to the extent available in various securities as authorized by State law. Earnings from the pooled investments are allocated to the respective funds on the basis of applicable cash balance participation by each fund. Investments are stated at cost, which approximates market value. G. Property Taxes Property tax levies are set by the City Council each year and are certified to Anoka County for collection in the following year. In Minnesota, counties act as collection agents for all property taxes. The County spreads all levies over taxable property. Such taxes become a lien on January 1 and are recorded as receivables by the City on that date. Revenue is accrued and recognized in the year collectible. Taxes which remain unpaid at December 31 are classified as delinquent taxes receivable. Revenue from property taxes which is not collected within 60 days of year-end is deferred since it is not available to meet obligations of the current year. Real property taxes may be paid by taxpayers in two equal installments on May 15 and October 15. Personal property taxes may be paid on February 28 and June 30. The County provides tax settlements to cities and other taxing districts four times a year. A portion of the property taxes levied is paid by the State of Minnesota through Homestead and Agricultural Credit Aid (HACA) and Equalization Aid which are included in intergovernmental revenue in the financial statements. -12- CITY OF ANDOVER Notes to Financial Statements December 31, 1990 NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (CONTINUED) H. Special Assessments Special assessments represent the financing for public improvements paid for by benefitting property owners. These assessments are recorded as receivables upon certification by the City Council. The corresponding revenue from delinquent (unremitted) and deferred (certified but not yet levied) special assessments receivable are deferred until the year in which they become available. I. Inventory The inventory held by the Proprietary Funds is stated at cost on the first-in, first-out basis. The cost of inventory is recognized as expense at the time the items are sold or used. J. Property, Plant, and Equipment 1) General Fixed Assets Account Group (Unaudited) - The City does not maintain records which provide complete detailed accounting control over quantities and original costs of assets in this account group. Fixed assets are valued at historical cost or estimated historical cost. No depreciation has beEm provided on general fixed assets. The costs of property, plant, and equipment are accounted for as current expenditures of the Governmental Fund Types in the year purchased. The City elected not to record infrastructure fixed assets in its accounting records. 2) Proprietary Fund Type - Fixed assets of the Proprietary Funds are stated at cost, estimated cost, or, in the case of contributions, at fair market value at the time received. Depreciation has been provided using the straight-line method over the estimated useful lives of the assets, as follows: Collection and distribution systems Machinery Furniture and equipment 50 years 20 years 3-15 years Depreciation on contributed assets charged to operations is closed to the Contributed Equity Account. K. Compensated Absences City employees earn vacation and sick pay accruing each payroll period. Unused vacation can be accrued by the employees up to a maximum of 160 hours as of the anniversary date of the individual's employment with the City. In the Governmental Fund Types, vacation pay is expensed as paid, and the liability for unused vacation is recorded in the General Long-Term Debt Account Group. Proprietary Fund Types expense vacation pay as it accrues, with the liability being recorded in the respective fund. -13- - m c c ~ ~ ! I I Ii I I I I I I I I E I ---=-- I I I I I I I I I I -I I I I I I I I I CITY OF ANDOVER Notes to Financial Statements December 31, 1990 NOTE 1 - SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES (CONTINUED) Employees can also accrue an unlimited amount of unused sick leave. Employees with two or more years of service are entitled to receive severance pay equal to a percentage of unused sick pay ranging from 20-50% based on years of service, up to a maximum of 400 hours. The liability for severance pay is accounted for the same as accrued vacation pay. L. Comparative Data Comparative total data for the prior year has been presented in the accompanying financial statements in order to provide an understanding of changes in the City's financial position and operations. However, comparative data has not been presented in all statements because its inclusion would make certain statements unduly complex and difficult to understand. M. Statement of Cash Flows During 1989, the Governmental Accounting Standards Board adopted a new pronouncement which replaces the Statement of Changes in Financial Position with the Statement of Cash Flows for Proprietary Funds for fiscal years beginning after December 15, 1989. For purposes of the Statement of Cash Flows, the City considers all highly liquid debt instruments with a maturity of three months or less to be cash equivalents. The Proprietary Funds' equity in the City-wide cash and investment management pool is considered to be cash equivalent. NOTE 2 - CASH AND TEMPORARY INVESTMENTS Cash balances of the City's funds are combined (pooled) and invested to the extent available in various investments authorized by Minnesota State Statutes. Each fund's portion of this pool (or pools) is displayed on the financial statements as "cash and temporary investments." For purposes of identifying the risk of investing public funds, the balances are categorized as follows: A. Security of Deposits Deposits consist of checking accounts, savings accounts, and certificates of deposit held in a bank or savings institution. At year-end, the carrying amount of the City's deposits was $2,433,930, while the balance on the bank records was $2,515,288. All deposits were insured or covered by collateral (with market value exceeding 110% of deposits) held by the City or its agent in the City's name. -14- CITY OF ANDOVER Notes to Financial Statements December 31, 1990 NOTE 2 - CASH AND TEMPORARY INVESTMENTS (CONTINUED) B. Security of Investments Minnesota State Statutes authorize the City to invest in obligations of the U.S. Treasury, agencies, and instrumentalities, shares of iinvestment companies whose only investments are in the aforementioned securities, obligations of the State of Minnesota or its municipalities, bankers' acceptances, future contracts, repurchase or reverse repurchase agreements, and commercial paper of the highest quality with a maturity of no longer than 270 days. The City's investments are categorized on the following page to give an indication of the level of risk assumed at year-end. Category 1 includes investments that are insured or registered or for which the securities are held by the City or its agent in the City's name. Category 2 includes uninsured and unregistered investments for which the securities are held by the counterparty's trust department or agent in the City's name. Category 3 includes uninsured and unregistered investments for which the securities are held by the counterparty or by its trust department or agent but not in the City's name. Credit Risk Category Carrying Market 1 2 3 Value Value U.S. Government Securities $ 2,200,705 $ - $ - $ 2,200,705 $ 2,260,737 Commercial paper 7,299,272 1.165,708 8,464,980 8,593.445 $ 9,499,977 $ - $ 1.165,708 10,665,685 10,854,182 Investment pool U.S. Government Securities 1.252.380 1.252.380 $ 11,918.065 $ 12,106.562 C. Cash on Hand Cash in the possession of the City, consisting of petty cash and change funds, totaled $650 at December 31, 1990. NOTE 3 - DuE FROM DEVELOPER As part of a development agreement the City entered into with a private developer in May 1989, the City received a promissory note for $243,520 from the developer. The note is to reimburse the City for the fiscal disparities' contributions the City lost due to the establishment of a Tax Increment Financing District for the development project. The note bears an interest rate of 5.50% and calls for 180 equal monthly payments to be made to the City through August 2003. -15- .... ~ ~ ~ ~ E m E I I I I I I I I I ~ I I ~ I I I I I I I I I I ~ I i -I I I I I I I I CITY OF ANDOVER Notes to Financial Statements December 31, 1990 NOTE 4 - DUE FROM OTHER GOVERNMENTAL UNITS The amounts due from other governmental units at December 31, 1990 are composed of the following: Due from Anoka County Delinquent taxes collected within 60 days of year-end Delinquent special assessments collected within 60 days of year-end Reimbursement of Community Development Block Grant expenditures County share of various improvement project costs County share of various other projects Court fmes Total due from Anoka County $ 22,575 95,002 45,611 1,048,092 16,324 2.680 1,230,284 594 $ 1.230.878 Due from Metropolitan Waste Control Commission Total from all sources NOTE 5 - PROPERTY AND EQUIPMENT A. Proprietary Fund Type Property and Equipment A summary of Proprietary Fund Type property, equipment, and accumulated depreciation follows: Water Sewer Total Furniture and equipment $ 57,126 $ 18,385 $ 75,511 Machinery 524,515 524,515 Collection and distribution systems 5.253.191 9.517.723 14.770.914 5,834,832 9,536,108 15,370,940 Less accumulated depreciation (615.027) (1.416.330) (2.031.357) $ 5.219.805 $ 8.119.778 $ 13.339.583 B. Changes in General Fixed Assets A schedule of changes in general fixed assets (unaudited) by major asset type follows: Balance Balance Beginning End of of Year Additions Deletions Year Land and improvements $ 687,779 $ 22,123 $ - $ 709,902 Buildings and improvements 622,145 10,397 632,542 Furniture and equipment 112,828 40,046 152,874 Machinery and automotive equipment 1.013.174 58.061 1.071.235 $ 2.435.926 $ 130.627 $ - $ 2.566.553 -16- CITY OF ANDOVER Notes to Financial Statements December 31, 1990 NOTE 6 - WNG-TERM DEBT A. Summary of Changes in Long-Term Debt The following is a summary of changes in long-term debt of the City for the year ended December 31, 1990: Balance Balance Beginning New Debt Debt End of of Year Issues Retired Year Generallong-tenn debt General Obligation Bonds $ 28,720,400 $ 4,050,000 $ 9,304,400 $ 23 ,466,000 Certificates of Indebtedness 270,000 95,000 175,000 Assessments on City property 252,951 29,603 13,180 269,374 Capital lease obligations 15,267 5,772 9,495 Due to Metropolitan Waste Control Commission (MWCC) 6,668 3,942 2,726 Compensated absences payable 54.363 7.191(1) 61.554 Total generallong-tenn debt $ 29.319.649 $ 4.086.794 $ 9.422.294 $ 23.984.149 (1) This represents the net change in compensated absences payable during 1990. B. Components of Long-Term Debt Final Balance Original Interest Issue Maturity at Issue Rate Date Date Year-End General Long-Term Debt General Obligation Bonds Special Assessment Bonds Improvement Bonds of Series 1977 A $ 1,215,000 5.00% 3-01-77 1-01-06 $ 865,000 Improvement Bonds of 1978 $ 270,000 5.25-6.00% 11-01-78 2-01-99 155,000 Improvement Bonds of 1979 $ 270,000 6.50% 10-01-79 2-01-95 120,000 Improvement Bonds of Series 1980A $ 430,000 6.10-6.90% 6-01-80 2-01-91 65,000 Improvement Bonds of Series 1985A $ 300,000 8.25-9.60% 3-01-85 2,01-00 225,000 Improvement Bonds of Series 1985B $ 2,350,000 6.00-9.00% 8-01-85 8-01-00 1,795,000 Improvement Bonds "f Series 1986A $ 1,795,000 5.00-7.90% 7-01-86 8-01-01 1,445,000 Improvement Bonds of Series 1986B $ 2,600,000 4.75-6.30% 10-01-86 10-01-96 1,715,000 Refunding Bonds of Series 1986A $ 180,000 6.25-7.25% 8-01-86 8,01-91 36,000 Refunding Bonds of Series 1986C $ 2,485,000 6.00-7.40% 8-01-86 8-01-02 2,485,000 Tel1'Porary Improvement Bonds of Series 1988A $ 5,800,000 6.00% 8-01-88 .8-01-91 5,800,000 Improvement Bonds of Series 1989A $ 3,200,000 6.10-6.80% 7-01-89 8-01-01 3,050,000 Temporary Improvement Bonds of Series 1990A $ 2,500,000 6.25% 7-01-90 7-01-93 2,500,000 Temporary Improvement Bonds of Series 1990B $ 1,550,000 5.90% 12-01-90 12-01-93 1,550,000 (continued) -17- -- ~ m .~ E ~ ~ ~ ~, I ~ I I I I I E E E I I I I I I I ~ I i I J - I - I I I I I I I I I I CITY OF ANDOVER Notes to Financial Statements December 31, 1990 NOTE 6 - LONG-TERM DEBT (CONTINUED) Final Balance Original Interest Issue Maturity at Issue Rate Date Date Year-End General Long-Term Debt (continued) General Obligation Bonds (continued) Tax Increment Bonds G.O. Tax Increment Bonds- Series 1987 A $ 1,065,000 8.25-9.90% 5-01-87 2-01-05 1,050,000 G.O. State-Aid Street Bonds 1984 $ 510,000 6.75-9.00% 9-01-84 9-01-94 210,000 1988 $ 500,000 5.60-6.80% 8-01-88 8-01-98 400,000 Total General Obligation Bonds 23,466,000 Certificates of Indebtedness 1986 Certificates of Indebtedness $ 95,000 6.80-7.60% 6-01-86 6-01-91 19,000 1987 Certificates of Indebtedness $ 170,000 5.75-6.20% 2-01-87 2-01-92 68,000 1989 Certificates of Indebtedness $ 110,000 6.25-6.35% 12-01-89 12-01-94 88,000 Total Certificates of Indebtedness 175,000 Assessments on City property $ 338,174 6,25-10.70% N/A 2001 269,374 Capital lease obligationa Ricoh Fr5000 copier $ 5,523 13.90% 5-23-88 3-01-92 2,034 Ricoh F1'5560 copier $ 8,797 12.87% 10-23-87 8-01-91 1,768 AT&T phone system $ 10,267 11.50% 5-10-88 5-10-93 5,693 Total capital lease obligationa 9,495 Due to Metropolitan Waste Control Commission $ 71,672 5.37% 1975 1990 2,726 Compensated absences payable N/A N/A N/A N/A 61,554 Total General Long-Term Debt $ 23,984,149 C. Minimum Debt Payments Minimum annual principal and interest payments required to retire long-term debt, excluding assessments on City property and compensated absences payable: -18- CITY OF ANDOVER Notes to Financial Statements December 31, 1990 NOTE 6 - LONG-TERM DEBT (CONTINUED) General Certificates Capital Year Ending Obligation of Lease Due to December 31 Bonds Indebtedness Obligations MWCC Total 1991 $ 8,572,712 $ 84,389 $ 6,346 $ 2,872 $ 8,666,319 1992 2,321,536 61,212 3,155 2,385,903 1993 6,359,744 24,783 1,129 6,385,656 1994 2,115,840 48,180 2,164,020 1995 2,014,315 2,014,315 Thereafter 9.019.2.78 9.019.278 30,403,425 218,564 10,630 2,872 30,635,491 Less amount representing interest (6.937 A~ll (43.564) (1.135) (146) (6.982.270) $ 23.466.000 $ 175.000 $ 9.495 $ 2.726 $ 23.653.221 D. Descriptions and Restr'ictions of Long-Term Debt General Obligation Bonds classified by major source of repayment are as follows: o Tax Increment Levies - These bonds were issued for redevelopment projects. The additional tax revenue resulting from increased taxable valuation of the redeveloped properties is used to retire the related debt. o Special Assessment Revenue - These bonds were issued to finance various improvements and will be repaid primarily from special assessments levied on the properties benefitting from the improvements. Some issues, however, are partly financed by ad valorem levies. o State-Aid _ These bonds were issued to fmance the construction, improvement, or repair on State- aid streets within th(~ City. The issues will be repaid from allocations made to the City's accounts in the Municipal State-Aid Street Fund. Other types of long-term debt are as follows: o Certificates of Indebtedness - These certificates were issued to finance the purchase of equipment. They will be retired from ad valorem levies and transfers from other funds. o Assessments on City Property - These are special assessments for improvement projects which benefitted specific parcels of land owned by the City. -19- - 1-- -- ~ ~ C C C ; c m m ~l ~ I I I I ~ E I ~ -:---_ -=-.-.a~ I I I ] I J I ] I II - - ~ I J .1 I I I I I I I I I I CITY OF ANDOVER Notes to Financial Statements December 31, 1990 NOTE 6 - WNG-TERM DEBT (CONTINUED) o Capital Lease Obligations - The City is currently leasing two copiers and a phone system under agreements classified as capital leases that bear interest rates varying from 11.5% to 13.9%. o Due to Metropolitan Waste Control Commission (MWCC) - This represents the amount payable to MWCC with interest at 5.37%. o Compensated Absences Payable - This liability represents vested vacation and severance benefits earned by employees through the end of the year which will be paid or used in future periods. All long-term debt is backed by the full faith and credit of the City. E. Resources to Meet Future Debt Requirements o Amounts Available for Long-Term Debt - The Fund balance available in the Debt Service Funds for repayment oflong-term debt at December 31, 1990 is $10,388,198. o Amounts to be Provided for Long-Term Debt - This amount represents future revenue to be generated for debt payments, generally including deferred tax levies, special assessments, tax increments, fund transfers, and interest earnings. Deferred tax levies scheduled to be placed on the tax rolls, as needed, total $467,050 at December 31, 1990. NOTE 7 - PROPRIETARY FUNDS CONTRIBUTED CAPITAL This balance represents the cost of property contributed to the Proprietary Funds by the City, less depreciation thereon charged to the respective funds' operations. Changes occurring in the account during 1990 were as follows: Water Fund Sewer Fund Total Balance - beginning of year $ 5,142,509 $ 8,102,398 $ 13,244,907 Capital contributed 159,517 194,187 353,704 Less current year's depreciation on contributed assets (129.492) (188.413) (317.905) Balance - end of year $ 5.172.534 $ 8.108.172 $ 13,280,706 -20- CITY OF ANDOVER Notes to Financial Statements December 31, 1990 ~ ~ c ~ ~ m m I II II ! II I I I E ~ ~ I E NOTE 8 - SEGMENT INFORMATION FOR ENTERPRISE FUNDS The City provides services which are accounted for in the Enterprise Funds. The segment information for these funds for the year ended December 31, 1990 is as follows: Water Fund Sewer Fund Total Operating revenue $ 226,444 $ 333,606 $ 560,050 Operating expenses $ 127,262 $ 256,095 $ 383,357 Depreciation expense $ 134,582 $ 190,006 $ 324,588 Operating loss $ (35,400) $ (112,495) $ (147,895) Net loss $ (17 ,346) $ (113,243) $ (130,589) Operating transfers in $ - $ 30,500 $ 30,500 Current capital contributed $ 159,517 $ 194,187 $ 353,704 Property and equipmllDt additions $ 201,726 $ 205,380 $ 407,106 Net working capital $ 267,223 $ 144,294 $ 411,517 Total assets $ 5,496,177 $ 8,297,576 $ 13,793,753 Total equity $ 5,487,028 $ 8,264,072 $ 13,751,100 -21- -- --- I I I I J I ) I - I I I I I I I I I I I I I CITY OF ANDOVER Notes to Financial Statements December 31, 1990 NOTE 9 - TRANSFERS The following transfers were made during the year ended December 31, 1990: A. Operating Transfers Transferred To Transferred From Amount Description General Fund Tax Increment Capita! Project $ 6,000 To reimburse administrative costs Fund - TIP Project 1-2 Account related to tax increments. General Fund Administrative Trust Fund 182,318 To fund administrative costs. Drainage and Mapping Special Assessment Capital 502 To transfer amounts assessed for Special Revenue Fund Project Fund - Improvement mapping costs. Bonds Series 1989B Construc- tion Account Drainage and Mapping Special Assessment Capital 1,299 To transfer amounts assessed for Special Revenue Fund Project Fund - U nfinanced mapping costs. Improvement Account State-Aid Bonds Debt Service State-Aid Capital Project Fund - 1,060 To fund debt service costs. Fund - State-Aid Bonds of State-Aid Project Account 1984 Account State-Aid Bonds Debt Service State-Aid Capital Project Fund - 646 To fund debt service costs. Fund - State-Aid Bonds of State-Aid Project Account 1988 Account Special Assessment Bonds Debt Special Assessment Bonds 359,400 To reimburse bond accounts for Service Fund - Improvement Debt Service Fund - Water projects assessed in other Bonds Series 1987A Account Trunk Account accounts. Special Assessment Bonds Debt Special Assessment Bonds 390,600 To reimburse bond accounts for Service Fund - Improvement Debt Service Fund - Sewer projects assessed in other Bonds Series 1987 A Account Trunk Account accounts. Special Assessment Bonds Special Assessment Bonds Debt 28,710 To transfer amounts assessed for Debt Service Fund - Water Service Fund - Improvement water trunk projects in other Trunk Account Bonds of 1989 Account accounts. Special Assessment Bonds Special Assessment Capita! 42,166 To transfer amounts assessed for Debt Service Fund - Water Project Fund - Unfinanced water trunk projects in other Trunk Account Improvement Account accounts . Special Assessment Bonds Special Assessment Bonds Debt 6,424 To transfer amounts assessed for Debt Service Fund - Sewer Service Fund - Improvement sewer trunk projects in other Trunk Account Bonds of 1989 Account accounts. Special Assessment Bonds Special Assessment Capital 31,212 To transfer amounts assessed for Debt Service Fund - Sewer Project Fund - Un financed sewer trunk projects in other Trunk Account Improvement Account accounts. Sewer Enterprise Fund Special Assessment Bonds 30,500 To reimburse lost revenue from Debt Service Fund - Sewer lower rates due to excess trunk Trunk Account charges in prior years. Administrative Trust Fund Special Assessment Capital 4,627 To transfer amounts assessed for Project Fund - Improvement administrative costs. Bonds Series 1989B Construc- tion Account Administrative Trust Fund Special Assessment Capita! To transfer amounts assessed for Project Fund - Unfinanced administrative costs. Improvement Account 14,419 Total $ 1.099.883 -22- CITY OF ANDOVER Notes to Financial Statements December 31, 1990 NOTE 9 - TRANSFERS (CONTINUED) B. Residual Equity Transfers Transferred To Transferred From Amount Description General Fund Equipment Capital Project Fund $ 10,501 To close Equipment Capital Project Fund. General Fund 1987 Equipment Capital 404 To close 1987 Equipment Project Fund Capital Project Fund. Special Assessment Bonds Debt Special Assessment Capital 660,204 To close Improvement Bonds Service Fund - Improvement Project Fund - Improvement Series 1987 A Construction Bonds Series 1987 A Account Bonds Series 1987 A Construe- Account. tion Account Special Assessment Bonds Debt Special Assessment Capital 216,520 To close Improvement Bonds Service Fund - Improvement Project Fund - Improvement Series 1987B Construction Bonds Series 1987B Account Bonds Series 1987B Construe- Account. tion Account Special Assessment Bonds Debt Special Assessment Bonds Debt 18,325 To close Improvement Bonds Service Fund - Improvement Service Fund - Improvement Series 1987B Debt Service Bonds Series 1987B Account Bonds Series 1990B Account Account. Special Assessment Bonds Debt Special Assessment Bonds Debt 101,258 To close Improvement Bonds Service Fund - Improvement Service Fund - Improvement Series 1987 A Debt Service Bonds Series 1990A Account Bonds Series 1987 A Account Account. State-Aid Capital Project State-Aid Capital Project Fund - 32,863 To close State-Aid Project Fund - State-Aid Project State-Aid Project Account No. 87-9 Account. No. 87-9 Account Permanent Improvement Revolv- 1978 G.O. Bonds Debt 120,163 To close 1978 G.O. Bonds ing Capital Project Fund Service Fund Debt Service Fund. Permanent Improvement Revolv- Special Assessment Bonds Debt 300,591 To close Improvement Bonds of ing Capital Project Fund Service Fund - Improvement 1976 Debt Service Account. Bonds of 1976 Account Permanent Improvement Revolv- Special Assessment Bonds Debt 133,740 To close Improvement Bonds ing Capital Project Fund Service Fund - Improvement Series 1977B Debt Service Bonds Series 1977B Account Account. Permanent Improvement Revolv- Special Assessment Bonds Debt To close Improvement Bonds ing Capital Project Fund Service Fund - Improvement Series 1980B Debt Service Bonds Series 1980B Account 16 .363 Account. Total $ 1.610.932 -23- - ~~ ~ ~ c E E E Ii II I E I I I I E E I ; E I ~~ I I I ~ I ; I i I I I I I I I I I I I I I I CITY OF ANDOVER Notes to Financial Statements December 31, 1990 NOTE 10 - INDIVIDUAL FUND DlSCWSURES The following funds had deficits as of December 31, 1990: Fund Deficit Debt Service Fund Certificates of Indebtedness Capital Project Funds 1990 Equipment Fire Station Construction $ 7,784 $ 34,595 $ 53,995 The deficit in the Debt Service Fund will be financed through future years' tax levies. The deficits in the Capital Project Funds will be financed through General Obligation Bonds to be issued in 1991. For various reasons, certain funds have a portion of their fund equity designated for specific purposes. A discussion of each such item as it appears on the Combined Balance Sheet follows: o Reserved for Debt Service - These amounts represent fund balances which are presently committed to provide fmancial resources to pay principal and interest on the City's General Obligation Bonds and Certificates of Indebtedness. o Designated for Working Capital - This amount represents funds set aside by the City to provide positive cash flow for the next fiscal year. o Designated for Capital Projects - These amounts represent assets which are presently committed to construct various capital projects or acquire major capital items. o Designated for Equipment - This amount represents assets which are presently committed for the purchase of equipment. NOTE 11 - DEFINED BENEFIT PENSION PLANS - STATEWIDE A. Plan Description All full-time and certain part-time employees of the City of Andover are covered by defined benefit pension plans administered by the Public Employees' Retirement Association of Minnesota (PERA). PERA administers the Public Employees' Retirement Fund (pERF) and the Public Employees' Police and Fire Fund (PEPFF) which are cost-sharing, multiple-employer retirement plans. PERF members belong to either the Coordinated Plan or the Basic Plan. Coordinated members are covered by Social Security and Basic members are not. All new members must participate in the Coordinated Plan. All police officers, fire fighters, and peace officers who qualify for membership by Statute are covered by the PEPFF. The payroll for employees covered by PERF for the year ended December 31, 1990 was $642,860. The City has no employees covered by PEPFF. The City's total payroll was $736,164. -24- CITY OF ANDOVER Notes to Financial Statements December 31, 1990 NOTE 11 _ DEFINED BENEFIT PENSION PLANS - STATEWIDE (CONTINUED) PERA provides retirement benefits as well as disability benefits to members, and benefits to survivors upon the death of eligible ml~mbers. Benefits are established by State Statute, and vest after three years of credited service. The defined retirement benefits are based on a member's average salary for any five successive years of allowable service, age, and years of credit at termination of service. Two methods are used to compute benefits for Coordinated and Basic members. The retiring member receives the higher of step-rate benefit accrual formula (Method 1) or a level accrual formula (Method 2). Under Method 1, the annuity accrual rate for a Basic member is 2 % of the average salary for each of the first ten years of service and 2.5% for each remaining year. For a Coordinated member, the annuity accrual . rate is 1 % of the average sal ary for each of the first ten years and 1.5 % for each remaining year. Using Method 2, the annuity accrual rate is 2.5% of the average salary for Basic members and 1.5% for Coordinated members. For PEPFF members, the annuity accrual rate is 2.5% for each year of service. For PERF members whose annuity is calculated using Method 1, and for all PEPFF members, a full annuity is available when age plus years of service equal 90. There are different types of annuities available to members upon retirement. A normal annuity is a lifetime annuity that ceases upon the death of the retiree. No survivor annuity is payable. There are also various types of joint and survivor annuity options available which will reduce the monthly normal annuity amount, because the annuity is payable over joint lives. Members may also leave their contributions in the fund upon termination of public service, in order to qualify for a deferred annuity at retirement age. Refunds of contributions are available at any time to members who leave public service, but before retiremEmt benefits begin. B. Contributions Requirf~d and Contributions Made Minnesota Statutes Chapter 353 sets the rates for employer and employee contributions. The City makes annual contributions to the pension plans equal to the amount required by State Statutes. According to Minnesota Statutes Chapter 356.215, Subdivision 4(g), the date of full funding required for the PERF and PEPFF is the year 2020. As part of the annual actuarial valuation, PERA's actuary determines the sufficiency of the statutory contribution rates towards meeting the required full funding deadline. The actuary compares the actual contribution rate to a "required" contribution rate. Current combined statutory contribution rate>i and actuarially required contribution rates for the plans are as follows: Statutory Rates Emolovees Emolover Required Rates PERF (Basic and Coordinated Plans) PEPFF 4.47% 8.00% 4.82% 12.00% 8.83% 16.21 % -25- r- - - E C C E I I I I m I E I E I I I ~ = I ~ .. ~."", ~ I I I Ja -I ~ I I I I I I I I I I I I I CITY OF ANDOVER Notes to Financial Statements Pecember 31, 1990 NOTE 11 - DEFINED BENEFIT PENSION PLANS - STATEWIDE (CONTINUED) Total contributions made by the City during fiscal year 1990 were: Amounts Emplovees Emplover Percentage of Covered Payroll Emplovees Emplover PERF $ 27.193 $ 28.800 4.23% 4.48% The City's contribution for the year ended December 31, 1990 to the PERF represented .02% of total contributions required of all participating entities. C. Funding Status and Progress 1. Pension Benefit Obligation The "pension benefit obligation" is a standardized disclosure measure of the present value of pension benefits, adjusted for the effects of projected salary increases and step-rate benefits, estimated to be payable in the future as a result of employee service to date. The measure, which is the actuarial present value of credited projected benefits, is intended to help users assess PERA's funding status on a going-concern basis, assess progress made in accumulating sufficient assets to pay benefits when due, and make comparisons among Public Employees' Retirement Systems and among employers. PERA does not make separate measurements of assets and pension benefit obligation for individual employers. The pension benefit obligations as of June 30, 1990 are shown below: PERF PEPFF (In Thousands) Total pension benefit obligation $ 4,089,960 $ 657,453 Net assets available for benefits, at cost (market values for PERF = $3,547,243; PEPFF = $803,320) 3.250.157 739.068 Unfunded (assets in excess of) pension benefit obligation ii i $ 839.803 $ (81.615) The measurement of the pension benefit obligation is based on an actuarial valuation as of June 30, 1990. Net assets available to pay pension benefits were valued as of June 30, 1990. -26- CITY OF ANDOVER Notes to Financial Statements December 31, 1990 NOTE 11 _ DEFINED BENEFIT PENSION PLANS - STATEWIDE (CONTINUED) 2. Changes in Actuarial Methods and Benefit Provisions For the fiscal year 1990 actuarial valuation, the PERA Board of Trustees approved the use of new withdrawal rates. The change was made to reduce, if not eliminate, the series of large, annually recurring, actuarial losses in the last few years due to lower than expected terminations. With the adoption of new withdrawal rates, the pension benefit obligation increased $59,942,000 in the PERF and $6,978,000 in the PEPFF. D. Ten-Year Historical TJrend Information Ten-year historical trend information is presented in PERA's Comprehensive Annual Financial Report for the year ended June 30, 1990. This information is useful in assessing the pension plan's accumulation of sufficient assets to pay pension benefits as they become due. E. Related Party Investments As of June 30, 1990, and for the fiscal year then ended, PERA held no securities issued by the City or other related parties. NOTE 12 _ DEFINED CONTRIBUTION PLAN - FIRE FIGHTERS' RELIEF ASSOCIATION A. Plan Description Members of the City's volunteer fire department are members of the Andover Fire Fighters' Relief Association. The Association is a single-employer defined contribution plan that was established in 1979, and operates under the provisions of Minnesota Statutes Sections 69 and 424A, as amended. It is governed by a Board consisting of six officers and trustees elected by the members of the Association for three-year terms. The City Mayor, City Clerk, and Fire Chief are ex-officio members of the Board of Trustees. The payroll for City employees who are members of the Association for the year ended December 31, 1990 was $57,464. The City's total payroll was $736,164. For financial reporting purposes, the Association's financial statements are not included in the City of Andover's financial statements because the Association is not a component unit of the City. B. Pension Benefits Minnesota State Statutes Chapters 424 and 424A authorize pension benefits for volunteer fire relief associations. A fire fighter who completes at least 20 years as an active member of the municipal fire department to which the Association is associated, and has been a member of the Relief Association for at least 10 years prior to retirement after age 50, is entitled to a service pension upon retirement. -27- - c' c C E E II I ~ I E E ~ I E E I II' ... . . .. ~ .. i' I I J I I I I I I I I I I I I I I I I . . CITY OF ANDOVER Notes to Financial Statements December 31, 1990 NOTE 12 - DEFINED CONTRIBUTION PLAN - FIRE FIGHTERS' RELIEF ASSOCIATION (CONTINUED) The service pension prescribed by the Association's by-laws is a lump sum settlement equal to the amount in the individual member's account at the time of retirement. The individual member accounts are credited with an equal share of: any fire State-aid received by the Association, any municipal contributions to the Association, and any other assets of the Association's Special Pension Fund. The by-laws of the Association also provide for a reduced service pension for a retiring member who has completed fewer than 20 years of service. The reduced pension, available to members with 10 years of service, shall be equal to 60% of the pension as prescribed by the by-laws. This percentage increases 4% per year so that at 20 years of service, the full amount prescribed is paid. A member of the Association who has completed 20 or more years of active service with the fire department prior to reaching age 50, has the right to retire from the department without forfeiting the right to a service pension. The member shall be placed on the deferred pension roll. Upon reaching age 50, the member may apply for the standard service pension as described above. The Association shall pay interest on the deferred service pension during the period of deferral. The interest rate will be compounded annually, at the rate actually earned on the assets of the Pension Fund, not to exceed 5% per year. An active member of the Association who becomes disabled to the extent that a physician shall certify that such disability will permanently prevent the member from performing his duties in the Andover Fire Department, is entitled to a disability pension equal to the balance in the member's account after 100 days of disability. If a member who has received such a disability pension should subsequently recover and return to active duty in the Andover Fire Department, any amount paid to him as a disability pension shall be deducted from his service pension accrued at the time of such disability. Upon the death of any member of the Association who is in good standing at the time of his death, the Association shall pay the member's spouse, children, or estate the balance of the member's account at the date of payment. The City of Andover has the power to levy property taxes at the direction and for the benefit of the Association, and passes through State aids allocated to the plan, in accordance with enabling State Statutes. c. Contributions Required and Contributions Made The City's contributions under the plan, determined by the Association's Board of Trustees and ratified by the City Council in accordance with enabling State Statutes, is $250 per member per year. In 1990, the City contributed $29,119 to the Association, consisting of $21,619 State aid and $7,500 fulfilling the City's $250 per member contribution obligation for the year ended December 31, 1990. The City's contribution represents 13.05% of covered payroll. . ! . -28- Bonds Outstanding - End of Year Tax Increment Tax Increment District - District - Development Development District No. 1-1 District No. 1-2 Redevelopment Redevelopment 472 472 1986 1986 2012 2012 $ 41,396 $ 28,929 $ 339,636 $ 237,397 $ 298,240 $ 208,468 $ 205,000 $ 1,065,000 205.000 15.000 $ $ 1.050,000 E m E I E I I I I I I I E I I CITY OF ANDOVER Notes to Financial Statements December 31, 1990 .NOTE 13 - TAX INCREMENT FINANCING DISTRICTS The City is the administering authority for the following tax increment financing districts within their respective Development Districts: Type of District Chapter Year Established Final year of District Original Tax Capacity Current Tax Capacity Qr-or Taxes Collectible in 1990) Captured Tax Capacity Retained by Authority Total Tax Increment Bonds Issued Amounts Redeemed NOTE 14 _ STATEMENT OF REVENUE AND EXPENDITURES - BUDGET AND ACTUAL The City did not adopt budgets for all Debt Service Funds (or accounts). Accordingly, the applicable columns of the Combined Statement of Revenue and Expenditures - Budget and Actual includes actual revenues, expenditures, and other financing sources and uses for only budgeted Debt Service Funds (or accounts). A reconciliation of the amounts to the total for all Debt Service Fund is as follows: ~ Iii .. - !!IE - -29- ... '" ~ .. ~~ ,. ) I 1 I -I I I I I I I I I I I I I I I I CITY OF ANDOVER Notes to Financial Statements December 31, 1990 NOTE 14 - STATEMENT OF REVENUE AND EXPENDITURES - BUDGET AND ACTUAL (CONTINUED) Other Financing Revenues Expenditures Sources (Uses) Debt Service Funds Budgeted funds and accounts $ 4,374,448 $ 11,413,489 $ 4,691,748 Unbudgeted funds and accounts 1978 G.O. Bonds Fund 8,805 Special Assessment Bonds Fund Improvement Bonds Series 1990A Account 512,004 97,870 37,500 Improvement Bonds Series 1990B Account 48,949 19,849 18,800 Water Trunk Account 113,406 (288,524) Sewer Trunk Account 90.274 (383.464) $ 5.147.886 $ 11531.208 $ 4.076.060 NOTE 15 - COMMITMENTS AND CONTINGENCIES A. Commitments Cor Construction At December 31, 1990, the City is committed to a number of contracts for various construction projects that were not completed by year-end. The City's remaining commitment under such contracts is approximately $861,000. B. Federal Revenue Amounts received or receivable from federal agencies are subject to agency audit and adjustment. Any disallowed claims, including amounts already collected, may constitute a liability of the applicable funds. The amount, if any, of funds which may be disallowed by the agencies cannot be determined at this time, although the City expects such amounts, if any, to be immaterial. C. Arbitrage Rebate Liability In fiscal years 1987 and 1988, the City issued more than $5,000,000 in General Obligation Bonds each year. Under federal law, the City may be liable to rebate estimated "arbitrage earnings" back to the U.S. Treasury. The amount, if any, of such earnings that the City may be required to rebate has not been determined at this time. Consequently, the City has recorded no "arbitrage rebate liability" at December 31, 1990. . i -30- CITY OF ANDOVER el ~ ; I E I ~ I I E ~ E m I I I Notes to Financial Statements December 31, 1990 NOTE 16 - SUBSEQUENT EVENTS In January 1991, the City issued $252,000 Certificates of Indebtedness. The Certificates bear interest rates varying from 6.30% to 6.70% and are to be paid off in varying amounts annually through January 1, 1996. !!C iii II: ~ -31- 5 ., ~ - ----"- ] I I I II I D ; I ~I il ;1 I I I I I I I I I I I COMBINING AND INDIVIDUAL FUND STATEMENTS 0' C D i E I m ~ I E ~ I E E I I E E ~ -- I CITY OF ANDOVER I General Fund Comparative Balance Sheet 11 As of December 31, 1990 and 1989 ~ J 1 1990 1989 J I Assets - .. I Cash and temporary investments $ 668,387 $ 699,361 ~ Receivables - Accounts 23,715 16,622 . I . Accrued interest 4,997 5,507 ~ Delinquent taxes 35,155 35,251 Deferred special assessments 350 - I Due from other governmental units 80,670 40.421 Total assets $ 813,274 $ 797,162 I Liabilities and Fund Balance I Liabilities Accounts payable $ 71,788 $ 59,274 Accrued expenses 29,852 27,962 I Due to other governmental units 58,361 59,772 Deferred revenue 35505 35,251 Total liabilities 195,506 182,259 I Fund balance Unreserved I Designated for working capital 617,768 Undesignated 614,903 Total fund balance 617.768 614,903 I Total liabilities and fund balance $ 813.274 $ 797.162 I I I I I I -32- c c c ; E I, , III 1.11 I I ~I ~ I E I I I I E ~ ~ I - . - .------- ~ ... I CITY OF ANDOVER I General Fund Statement of Revenue, Expenditures, and Changes in Fund Balance - Budget and Actual Year Ended December 31, 1990 I (with Comparative Actual Amounts for Year Ended December 31, 1989) I 1990 1989 ~ Over i I (Under) ~ ~ Budget Actual Budget Actual = ~ D Revenue Taxes ad valorem $ 913,052 $ 911,255 $ (1,797) $ 712,017 = - I Licenses and permits 253,600 212,793 (40,807) 259,083 . ~ Intergovernmental revenue I Federal CDBG 66,919 66,919 16,441 State I Local government aid 125,173 102,657 (22,516) 350,045 HACA and other tax credits 371,091 335,007 (36,084) 228,414 Street maintenance 22,600 22,600 22,260 Fire department aid 21,000 21,619 619 22,692 I Other 74.630 67 .920 (6.710) 19.478 Total intergovern- mental revenue 614,494 616,722 2,228 659,330 I Charges for services General government 20,400 18,186 (2,214) 20,808 I Street lights 41,000 54,521 13,521 33,971 Utility Funds 5.000 3.255 (1.745) 3.975 Total charges for services 66,400 75,962 9,562 58,754 I Fines and forfeits 57,000 46,650 (10,350) 51,614 I Other revenue Interest earned on investments 40,000 28,147 (11,853) 30,016 Refunds and reimbursements 28,100 38,480 10,380 40,049 I Miscellaneous 5.400 3.433 (1.967) 3.844 Total other revenue 73 .500 70.060 (3.440) 73.909 I Total revenue 1,978,046 1,933,442 (44,604) 1,814,707 I (continued) I I -33- CITY OF ANDOVER ~I General Fund (continued) C Statement of Revenue, Expenditures, and Changes in Fund Balance - Budget and Actual Year Ended December 31, 1990 (with Comparative Actual Amounts for Year Ended December 31, 1989) ~ 1990 1989 ~ Over (Under) Budget Actual Budget Actual ~ Expenditures General government ~ Council Personal services 20,752 14,675 (6,077) 24,410 ! Supplies 400 99 (301) 743 Ci Other services and charges 7.906 12.839 4,933 5.548 Total council 29,058 27,613 (1,445) 30,701 I Mayor ~I Personal services 4,200 4,200 4,200 ~i Supplies 32 32 Total mayor 4,200 4,232 32 4,200 Committees ~ Operating expenses 61 Elections ~ Personal services 7,715 9,095 1,380 Supplies 550 726 176 Other services and charges 150 296 146 6 Total elections 8,415 10,117 1,702 6 I Newsletter Personal services 750 454 (296) 935 ~ Other services and charges 3.309 5.522 2.213 7,975 Total newsletter 4,059 5,976 1,917 8,910 ~ Administration Personal services 100,969 96,059 (4,910) 74,716 Supplies 2,150 1,292 (858) 2,553 I Other services and charges 4,100 5,537 1,437 5,941 Capital outlay 3.753 Total administration 107,219 102,888 (4,331) 86,963 I ~ (continued) ~ -34- E - f I I .!i 1 I i 0 i D I I I I I I I I I I I I I I CITY OF ANDOVER General Fund (continued) Statement of Revenue, Expenditures, and Changes in Fund Balance - Budget and Actual Year Ended December 31, 1990 (with Comparative Actual Amounts for Year Ended December 31, 1989) 1990 1989 Over (Under) Budget Actual Budget Actual Expenditures (continued) General government (continued) Financial administration Personal services 100,972 95,994 (4,978) 96,627 Supplies 1,800 2,742 942 2,771 Other services and charges 1,270 1,728 458 3,521 Capital outlay 110 110 1.158 Total financial administration 104,042 100,574 (3,468) 104,077 Assessing Other services and charges 26,500 28,707 2,207 25,465 Consulting staff Auditing 12,500 12,185 (315) 12,392 Legal 55,341 60,184 4,843 84,320 Total consulting staff 67,841 72,369 4,528 96,712 Planning and zoning Personal services 45,731 46,458 727 60,241 Supplies 1,700 1,616 (84) 3,355 Other services and charges 2,500 7,325 4,825 3,995 Capital outlay 2,951 Total planning and zoning 49,931 55,399 5,468 70,542 Data processing Supplies 8,307 9,737 1,430 Capital outlay 10.773 8,819 (1.954) Total data processing 19,080 18,556 (524) (continued) -35- CITY OF ANDOVER C General Fund (continued) ~ Statement of Revenu,~, Expenditures, and Changes in Fund Balance - Budget and Actual Year Ended December 31, 1990 (with Comparative Actual Amounts for Year Ended December 31, 1989) E 1990 1989 ; Over (Under) I Budget Actual Budget Actual Expenditures (continued) I General government (continued) Buildings Administration building II Personal services 4,534 6,842 2,308 4,237 I Supplies 5,675 2,542 (3,133) 5,432 i Other services and charges 17,700 22,434 4,734 27,827 I Capital outlay 1.600 896 (704) 34.822 Total administra- tion building 29,509 32,714 3,205 72,318 I Fire department building Personal services 450 678 228 Supplies 3,330 781 (2,549) 2,324 ; Other services and charges 10,030 9,884 (146) 9,876 Capital outlay 1.121 Total fire depart- ~ ment building 13,810 11,343 (2,467) 13,321 Public works building I Personal servic,:s 5,243 5,243 6,145 Supplies 5,367 2,844 (2,523) 2,838 Other services and charges 15,542 17,203 1,661 11,623 I Capital outlay 15.000 15.017 17 8.677 Total public works building 35,909 40,307 4,398 29,283 Senior citizen center ~ Personal servicm; 2,028 1,080 (948) 1,788 Supplies 1,725 63 (1,662) 402 I Other services ~md charges 6.026 5.833 (193) 5.007 Total senior citizen center 9,779 6,976 (2,803) 7,197 II I (continued) I -36- I -.... ~ =--...~ ~ 11 CITY OF ANDOVER j I General Fund (continued) ~ Statement of Revenue, Expenditures, and Changes in Fund Balance - Budget and Actual - Year Ended December 31, 1990 j I (with Comparative Actual Amounts for Year Ended December 31, 1989) J I 1990 1989 Over - I (Under) ~ Budget Actual Budget Actual - ~ I Expenditures (continued) ~ General government (continued) Buildings (continued) - I Storage building - Supplies 1,304 158 (1,146) Other services and charges 985 1,929 944 183 I Capital outlay 2.700 2.952 252 7.704 Total storage building 4.989 5.039 50 7.887 I Total buildings 93,996 96,379 2,383 130,006 Engineering Personal services 59,914 56,165 (3,749) 73,506 I Supplies 3,100 3,064 (36) 4,103 Other services and charges 6,880 11,739 4,859 8,105 Capital outlay 2.164 I Total engineering 69.894 70.968 1.074 87.878 Total general government 584,235 593,778 9,543 645,521 I Public safety Police protection I Supplies 38 38 Other services and charges 395.401 394.730 (671) 365.609 Total police protection 395,401 394,768 (633) 365,609 I Fire protection Personal services 92,171 71 ,409 (20,762) 65,769 I Supplies 40,100 28,838 (11,262) 10,360 Other services and charges 55,850 66,954 11,104 43,976 Relief Association 31,850 29,119 (2,731) 30,192 I Capital outlay 1.560 1.560 20.524 Total fire protection 219,971 197,880 (22,091) 170,821 I I (continued) I -37- CITY OF ANDOVER General Fund (continued) Statement of Revenue, Expenditures, and Changes in Fund Balance - Budget and Actual Year Ended December 31, 1990 (with Comparative Actual Amounts for Year Ended December 31, 1989) 1990 1989 Over (Under) Budget Actual Budget Actual Expenditures (continued) Public safety (continued) Rescue service Personal services 14,986 16,536 1,550 13,932 Supplies 4,320 3,025 (1,295) 1,718 Other services and charges 17.072 9 .549 (7 .523) 7.813 Total rescue service 36,378 29,110 (7,268) 23,463 Protective inspection Personal services 111,395 111,757 362 107,463 Supplies 6,000 6,926 926 6,529 Other services and charges 4,098 3,283 (815) 3,210 Capital outlay 582 582 15,310 Other 74 74 977 Total protective inspection 121,493 122,622 1,129 133,489 Civil defense Supplies 1,250 (1,250) Other services and c:harges 1.000 543 (457) 2.082 Total civil defense 2,250 543 (1,707) 2,082 Animal control Personal services 111 111 212 Supplies 150 150 173 Other services and charges 10.989 9.730 (1.259) 9.566 Total animal control 10.989 9.991 (998) 9.951 Total public safety 786,482 754,914 (31,568) 705,415 (continued) -38- ...~ tl ~I Ci II II II i I; I II II I; I~ II II IE il E I I I - - - I 1 ,j! CITY OF ANDOVER ~ ~ I 'jj General Fund (continued) J Statement of Revenue, Expenditures, and Changes in Fund Balance - Budget and Actual Year Ended December 31, 1990 - I (with Comparative Actual Amounts for Year Ended December 31, 1989) ~ - - I > ~ 1990 1989 - Over - I (Under) - Budget Actual Budget Actual I Expenditures (continued) Public works - Streets and highways -I Personal services 76,563 77,069 506 61,988 Supplies 22,025 18,476 (3,549) 14,119 Other services and charges 34,447 25,696 (8,751) 23,133 I Capital outlay 38.265 23.326 (14.939) 31,108 Total streets and highways 171,300 144,567 (26,733) 130,348 Snow and ice removal I Personal services 61,830 32,355 (29,475) 41,471 Supplies 36,967 33,550 (3,417) 37,233 Other services and charges 19,778 12,227 (7,551) 16,376 I Capital outlay 283 283 1.333 Total snow and ice removal 118,575 78,415 (40,160) 96,413 I Street lighting Other services and charges City 17,500 13,445 (4,055) 20,340 I Billable 38.240 37.069 (1,171) 24.570 Total street lighting 55,740 50,514 (5,226) 44,910 I Street signs/signals Personal services 17,501 22,609 5,108 15,203 Supplies 3,853 5,025 1,172 5,105 I Other services and charges 595 3,368 2,773 2,999 Capital outlay 2.548 2.548 1.297 Total street signs/signals 21.949 33.550 11.601 24.604 I Total public works 367,564 307,046 (60,518) 296,275 I I I (continued) I -39- CITY OF ANDOVER Dr General Fund (continued) I Statement of Revenm~, Expenditures, and Changes in Fund Balance - Budget and Actual E' Year Ended December 31, 1990 (with Comparative Actual Amounts for Year Ended December 31, 1989) I 1990 1989 E Over (Under) m Budget Actual Budget Actual Expenditures (continued) Sanitation II Storm sewers Personal services 18,649 17,185 (1,464) 13,666 Supplies 2,912 1,957 (955) 896 E Other services and charges 2,018 255 (1,763) 429 Capital outlay 283 283 200 Total storm sewers 23,579 19,680 (3,899) 15,191 E Trees and weed control Personal services 4,592 9,186 4,594 2,252 I Supplies 490 106 (384) 239 Other services and charges 3.379 196 (3.183) 976 Total trees and weed control 8.461 9.488 1.027 3.467 ~ Total sanitation 32,040 29,168 (2,872) 18,658 Parks and recreation I Personal services 85,429 82,917 (2,512) 82,658 Supplies 18,622 18,367 (255) 21,895 I Other services and charges 13,188 23,298 10,110 12,756 Community education programs 39,658 39,658 35,663 Assessments 12,854 21,388 8,534 17,792 ~ Capital outlay 68.795 75.821 7.026 47.807 Total parks and recreation 238,546 261,449 22,903 218,571 Recycling ~ Personal services 11 ,287 10,581 (706) 7,947 Supplies 850 1,358 508 1,411 Other services and charges 8,475 7,164 (1,311) 3,638 ~ Capital outlay 24.018 20.464 (3.554) 7.116 Total recycling 44,630 39,567 (5,063) 20,112 ~ I (continued) I -40- I --- )1 CITY OF ANDOVER ] I General Fund (continued) Statement of Revenue, Expenditures, and Changes in Fund Balance - Budget and Actual " Year Ended December 31, 1990 '" '" I (with Comparative Actual Amounts for Year Ended December 31, 1989) ~ ] ! " I 'i ;l 1990 1989 :lI Over - I (Under) ~ ~ Budget Actual Budget Actual Expenditures (continued) - I Economic development - - Personal services 15,762 14,056 (1,706) Supplies 400 140 (260) -I Other services and charges 1.300 93 (1.207) Total economic development 17,462 14,289 (3,173) I Unallocated CDBG 71,832 71,832 45,540 Metropolitan Waste Control Commission 4,300 4,300 4,300 I Insurance 18,661 26,602 7,941 31,959 LRRWMO 1,900 2,019 119 1,788 Improvement projects 3,838 I Site Q 1,610 19,786 18,176 8,501 Crooked Lake cleanup 190 190 Miscellaneous 650 4,860 4,210 1,871 I Contingency 23.103 (23.103) Total unallocated 50.224 129.589 79.365 97.797 I Total expenditures 2.121.183 2.129.800 8.617 2.002.349 Excess (deficiency) of I revenue over expenditures (143,137) (196,358) (53,221) (187,642) Other financing sources I Operating transfers in Capital Project Funds 6,000 6,000 Administrative Trust Fund 135.137 182.318 47.181 70.545 I Total other financing sources 141.137 188.318 47.181 70.545 Excess (deficiency) of revenue I and other financing sources over expenditures $ (2.000) (8,040) $ (6.040) (117,097) I Fund balance Beginning of year 614,903 732,000 Residual equity transfers in 10.905 I End of year $ 617.768 $ 614.903 I -41- CITY OF ANDOVER Special Revenue Funds Combining Balance Sheet As of December 31, 1990 (with Comparative Totals as of December 31, 1989) Drainage and LRRWMO Mapping Asset~ Cash and temporary investments Receivables Accrued interest Delinquent special assessments $ 4,808 72 Total assets $ 4.880 Liabilities and Fund Balance Liabilities Deferred revenue $ Fund balance Unreserved Undesignated 4.880 Totalliabilitil~ and fund balance $ 4.880 -42- - Totals 1990 1989 $ 59,656 $ 64,464 $ 59,441 876 24 948 24 942 $ 60.556 $ 65.436 $ 60.383 $ 60.532 24 $ 65.412 24 $ 60.383 $ 60.556 $ 65.436 $ 60.383 cl ~ C ~ E m E I II ~ ~ ~ I E C ; I I I E ~ " i I j JI J I J I ! I -I -I I I I I I I I I I I I I CITY OF ANDOVER Special Revenue Funds Combining Statement of Revenue, Expenditures, and Changes in Fund Balance Year Ended December 31, 1990 (with Comparative Totals for Year Ended December 31, 1989) Totals Drainage and LRRWMO Mapping 1990 1989 Revenue Special assessments $ $ 3 $ 3 $ 4 Other revenue Interest earned on investments 419 5.353 5.772 3.969 Total revenue 419 5,356 5,775 3,973 Expenditures Public works Other services and charges 66 2.481 2.547 9.470 Excess (deficiency) of revenue over expenditures 353 2,875 3,228 (5,497) Other financing sources Operating transfer in Capital Project Funds 1.801 1.801 10.575 Excess of revenue and other financing sources over expenditures 353 4,676 5,029 5,078 Fund balance Beginning of year 4.527 55.856 60.383 55.305 End of year $ 4.880 $ 60.532 $ 65.412 $ 60.383 -43- ~ ~ > o Cl z <: u.. o >< f-< U ..... '" .... ~olla 33'" '" ..cI "'..... 8 "0", ., S.,~Cl u..g"'..... l1) Cod .... 0 u"; Q) t.n .. IXl -S '" ~ tJl) Cll ~ en = a3 s ~'8 '"' ~ .rJ .""" ~ ['""""""" ., .ria..... Cll Cl 0 > o rn o.:;j U<:e '" 8' 8 .;l ! - '" 00 '" ..... '" '3 o f-< o '" '" ..... = ";;l "a '" '. "0 & '" = "'~~ <: c;- oo '" ..... Cl '" ~ ~ "0 ~ e 6 ]1Xl B~~ S .~ = "'.....~ '" '" .2l gj ~.....~ ...... 0 J$ i ., U "8 - 00 . '" r--o"8 '" . 0 .....tllXl (f~ -< r-- V-l ...1" -< ~; -< ~7 '" ~ '" '" -< ("f")0\\r)....-4..::t" I O\tn\ONtn \Ot-N\ON -" 0 M N" t-" .....c("f")O\,O.....c N MN- o......c... - 8 1,,, 1/" I/~ ~~ c; ~~ ......c\OO,....cV')......-I o\O","O\ootn M","tnoot-O r-: vi ","0 "'"" t-" 0\ tn","O\OO","N ......-I .-to\........N r---'" -: io'7 co t, .to t," Cl'\ 'to C; V"lIOlnOOI tn "'"Nt- ......c V)t-'1""""4 ~ .,;.,;..: ~ 0\-"," ......c ...-l 0\ ......c r-: ....-4... il7 .... I- N ;t t-oo 00 M 0\ "'" r:---........:- "'" I ~ ~;;:;~ __0 oviO\ t- N N ;,/7 .... In 00 ..... ,... 0\ ' tn .... .0'7 I 00 I N o ","0 I "'" I 0\ "'" .... .017 017 ~ .- d ::l ~ '::l ~ ~~~ ii3 8 ii3 ~ 5 ~ ~ ~ ~ ~ ~ ~ ~ .5 ~ ~ 0 p.. >. ...."'._~bJlo ~ ~~1rl....~0) ... ~~!E'1rl.s~ & =~~~o"O 8 .- ii3 ii3 8 8 ~ ~as g..g..] 0 0 "'d-8dd....~~ c: ~ u'-:'= ~ <D d> <1l>uO)d)d)::l::l .d 'Q) -< ~ ~ ~ ~ ~ ~ 1rl UP:: tn o M .... t- o "'" N (017 "'" M \0 "'" .... 0\ 0\ .... \0 t- o t- 0\ 00 00 .... (017 ~ ~ j J ~ '" ~ ~ -44- I \0 M ~ t- '\ON t- - t- t-" M- t- 00 \0 \0" -- -- (017 ","00"'"0\0 t-"'"tn\OM \OO\Ot-"," 00'" -: v'" ....... ...0 .... ON tn tn O\~ (017 1000t-tn "'"tnt-t- 0\","0"," ..: M t- N" .... tnt- -- O\~ (017 (017 I tn~ tn tn tn \0 \0 ~~ MM (017 ~ I C!; ~~8 _ \OOM 00 "'" M - (017 (017 d) ~ ~ P=i "8 ~ 1 .~ .... .... - ~ ::3 .~ .... .- - ~ .- ~~d):;a ,.0"'8.... o:l ii3 d) 0 .... ~p.,>E-< '0 p., ~ e !+:: '" d)'Elasas '" "'d ::l ::l ... .~.d 8 h ~ .-::: ~ U U d) :-;::U-<-<~ ~ ::3 N t- .... t- N t- N - N 00 0\0 tn 0\ M o - - ~ .,; N t-" 0\ ,_ ~ "'" N t- 0\ .... t- M" t- :a '~ , ~j o - o .,; - D tn o M ~ - b "'" N (017 ~ "'" M \0 "'" - 0\ 0\ - ~ (017 E E III III ! ; i II ! \O~ 81 00 0\ 0\ (017 ~ I ~ 99 j '0' .0 !+:: d) S d) o 1a d) ~ U ,.0 .~ "8 '" .E 'Z"..... ~ .0 is <l) ~ ti:"O ~o d)... dE-< S<2 as .~ gas ~~ ~~~::> ,.o~c:; "'dP::::> d ~ ~ I (017 c c d) U ~ 1a '';: ca :=.D ~"8 :=.E ~"'d .... 1:1 o o:l E-< ; m I E ~ -- J I .;;; - I - = I -I -I 1 I I I I I I I I I I I I I <> o = '" c;j ~ -g &: .5 ~ ~ > o o z < l.t.. o >- E-< o ..... a'5 .... bJl ~ ij .0 ..c::oEi uO'I<> '1:l0'l g ij-~O r.I'J ,,~"'t:J -g[l....~ &:B]~ ~:a Ei.... "_ d ~ ~ e g.g>- <> ~O.... en~ 0 ... ~~"" i3 <>'1:l '" OS =c;j <>~o ~aE-< ~<><> ....>-.~ o ~ ) I !3 U en oS gp~ .S ~ o U ---. 0'1 00 0'1 ..... 0'1 00 0'1 ..... ....Otn 88;~ ..0 \C~..... tn tn \C ....0'1. .... ~ o 0'1 0'1 ..... r-80'1 00 0'1 \C r- o 0'1. ~ oo~~ .... ~ = c;j<>", .- Ei'1:l g"'= 0..a'50 en~~ < , I 0'\ 0'\ r-. 0'\ \C ..... ~ ... = <>'" ~Ei"'O "'<>= E-<....O g~ - '8' ~ ~ I I I -S-o..ti ;s.- = cn<& ~ '" '" <> a'5 ~ = ~....~ ._ o,:Q 1:: <> <> '1:l U = - r- I I 00 \C. o 00 ~ I I I 00 .'" r-O'1:l 0'\ .= .....,,& ~ tnO' ('I 00 00. r-. .....tn r-r- ..... r-....OO .....('1..... \C......... O.\C.~ r-('I('I ('I r- '00 \C ..... ('I. ....~ ..... 0'\ ('I ('I ..... .... I 0'\ I \C 00 0" tn ..... ~ ..... 'V I tn ('I. tn ('I , I I ..... ..... .... o. ..... ~8~' ('1000 ~"'tri('f") ... tn ('I 0' ..... ..... ..... I I tn . o 00 00 '" s ~ ~ s ....s [I <> 0= > S ~ <> .=_ <> <>;SEi S ~ ....<> = ~ s.... <>~ 0 <> =_ oS;:l ~ '" .... 5 <>;S 0'8 ='1:l;:lc;j ~ ~ ~ ~{j le @ ~3 ~~ > s ~ s";< Od> if'S~ '1:l ~ '" ~ <>U S ~ .... <> 0 '" gc;j 0 ~< 0 .... 2c;j.ra [1.-.- ~::t:u .....sen::;!; <>~~o~ <> ;:l od '" g.... oS aiE-<E-<en.s 0 ~ ~ ,'I> .....- 0$0 ~-~ ..; ..; r- 00....0 0'\ \C.... . . 00_ i~~~ '~ ~~~~ 'F ~~~fj 'r I I I I a'5 .... E ~;a ---.ai a'5 >>0.. ....g~ ..e.~ ~ '1:l.:l <> = ai1S ~ ~ ~<> 0::; <>"'S - ....,[1<> "4) ~o> .... O~<> <>c;j E-<~ .... .~~~ >.- <>.... ~~g:uC1) 1-of ~.- ~-5 E...~.so ;;~ aiCl ~ ~ -45- 0'\ V o 0'\ V Vl. ('I 8 00 v. ('I r-('I\C tn\Cv \C-('I ~('I.r-. tn..... ('I N' ('I .... .... 00 .... B \C r- v~ ..... .... o ..; vv' ....00 .....0 tn. tn. oor- r- ---. v 00 .... .... r- tn B \C ~. ..... .... o v~ VOO' ....r- ......... v-il"'i oor- r- \C to o 0'\ ..... I . I ---. tn .... \C~ ..... ....... I \C I o r-. ..... ~ 00 r- t:: I I I tn o 00 00 I I I I , I "rJ I I I I I I a'5 o .... ;:l o '" gp .~ ---. '" = a'5 '1:l ---. q::: r.I'J flfJt= ~tI.) .;:l, '1:l_ ;:l'1:l !:'i! _ ==- 0= ~ ._;:ll.t.. "''-';:l "'oS a'5 "'l.t.. ... -g "'l.t.. -g 0 ~ ~ dl~~ <>,~-;;:j ;:l ",OO~VJO..-..t.;:s o U'J QO_ "- d) t::r- Q) 0 "'~ ~ ~Q.,.ra ~ ~.raE-< bOd) ~CI)- I-l......CI) t-l .5 g bJl... ;S fr bJl... fr u ~ = _'- Cl) C _ Q,) - _._~ Q.c~._~ ~ c;; _.,j,.o\1,U ~="""I.U = ='1:l ~clU~ ~cl~ q:::=<> <> ~&8' 8' <5 r- tn ('I. .... 0'\ tn ('I. \C . . .... .... \C~ 0'\ r- ~ ---. ('I \C ('I r-~ o .... ci .... 0'\ tn 0'\ 00 .... ('I ..... ~ s .... o ~ ~ ci \C to o 0'\ ..... tn I , 0'\ \C ~. ..... r- 0'\ . I .... 0'\. .... ..... ---. v 00 r- t:: I I I tn o 00 00 '1:l~ !a ~a'5 <><>", S~;:l <>>bJl ~ 0.5 ....a'5~ 't~= ",-...,=f+:= ;:",of-j 'Z" Url'JQ) = ai~ =0 '0.50 --'-' t;:: g"tj ~ f: <>",= ~~ "'deed V)r.I'J .......q::: = = "'....~~....~~ a'5 <> ::l'- "'...... ~oS.<;3~ ~,e..e- ~O"'d(1)'+-o:'-'- SOg.& <> bJl <> g.5 c;j c;j ode;:l;:l ~._:g:s! .0 ~[I [I '1:l~~~ = ;:l l.t.. ---. a'5 '" .e ~ j ~ J ~ >> .... o '1:l = ~ 1990 1989 Over (Under) Budget Actual Budget Actual Revenue Taxes ad valorem $ 110,799 $ 80,687 $ (30,112) $ 53,527 Intergovernmental revenue HACA and other tax credits 25,254 25,254 25,222 Total revenUl~ 110,799 105,941 (4,858) 78,749 Expenditures Debt service Principal retirement 95,000 95,000 73,000 Interest 15,799 14,974 (825) 12,995 Other 3,751 3.751 Total expenditures 110.799 113.725 2,926 85.995 Excess (defidency) of revenue over expenditures (7,784) (7,784) (7,246) Other financing sources Operating transfer in Enterprise Funds 7,246 Excess (deficiency) of revenue and other financing sources over expenditures $ (7,784) $ (7,784) Fund balance (deficit) Beginning of year End of year $ (7.784) $ El I E I II ; II I , i II I E E E I E I I I I I I CITY OF ANDOVER Certificates of Indebtedness Debt Service Fund Statement of Revenue, Expenditures, and Changes in Fund Balance - Budget and Actual Year Ended December 31, 1990 (with Comparative Actual Amounts for Year Ended December 31, 1989) -46- - ... )1 !! i i I i I ~ I ~ "I I I I I I I I I I I I I I I CITY OF ANDOVER State-Aid Bonds Debt Service Fund Balance Sheet As of December 31, 1990 (with Comparative Totals as of December 31, 1989) State-Aid Bonds of 1984 Account State-Aid Bonds of 1988 Account Totals 1990 1989 Assets Cash and temporary investments Receivables Accrued interest $ 346 $ 13,505 $ 13,851 $ 13,939 58 101 159 Total assets $ 404 $ 13.606 $ 14.010 $ 13.939 Fund Balance Fund balance (deficit) Reserved for debt service Unreserved Undesignated $ 404 $ 13,606 $ 14,010 $ 14,350 (411) $ 404 $ 13.606 $ 14.010 $ 13.939 Total fund balance -47- D I I E E : II I EI ! E ; E ; E E E E I E E E - - ~ 1 ;0 I ~ - I -I I I I I I I I I I I I I I I I ,..... 0\ 00 0\ ..... t:l:: ~ ;.- o o z < tl:. o >< E-< tl 0.> o = '" '" ..... ~ M .... 11 0.> :; '5 tl:. 0.> ",=,.S ~ ="'00 :; ~O\ "'=' tl:.=0\<> 0.>"'.....11 o.c:: . 'T' .- U..... """" 1: "'=' M ~ .~ = ~ 0.> -, '" ~ ...... ..... ,Dr is ",. E .... 0~8..s ,8 0.> '" .@:a0i:: = ="'C:l :; o 0.> <> 0 ~ ~"'=' E :s!~&5< -;: a) ~ '" 0.> :; 0.> ,8 ~="""o .....o.>r< tI:l~ t:l:: ~ .- ..... ~ ~ ~ 5 E' E 0 ,S u ~ ..s tI:l ._ ~ 0\ 00 0\ ..... '" fl < ,.....~ $-l ~ a.> ~"'='",=, 0=:; 8~ '" ..... o E-< :g~OOt: ",-;:"'='~:; 0,8's s..... 8 O\o"'~.......;l ~< ~ 0...... :9r.f.)-.::te: <",=,00:; , = 0\ 0 20..... u "'~""'..;l ~ 0...... ~ In 'In N N 00 00 ..... ..... t- t- ..... ..... ~ ,..... o In 0). ..... '-"' O~S ..... v ..... 00 '-"' ..... ~ o In <'1. 0\ v ..... =1 ~. .....0 In ..... ~ o In N t-. t- ~ 10 10 Oln t- 0\. t- t- 8 ..... vv 00 vV'l. N t- N t- ~ 8 <">. ..... In ..... , 0 o <"> ~ ~ S 0.> ~ ~ .s ~ e s ~ '" 13.... ..... ='" as '-'ot ~ E.@g~~ S -c; as ~ 0.> " > 0.> > ~ t1> ~ 0~....,S ~CI'} :u J:l 0.> 0.> ~:s <5 ~ t:l:: ~~~~~ 0""'"'\,0..... o t-. 00 Oln In ..... ..... 8. ~. ~~ g~ OO.....N Oln In ..... ..... 8.g.~*1 000 0\ inN t- 80O\O\~ ovv .....1Ot- ON. N inN t- ..... In ..... OOOO~ 0000 Oooln<"> 0.0. ..... Oln In ..... ..... ) .!:: 0) .... 8 ca ..... '> .S< ~ .... gs ~ g ~ Q) 4-4 ~.C -a oS g.....Q.._O :.ciS 50 & -48- 'Inln 0\ 0\ t-t- ~ .... ,8 .- "'=' 5 ~ ~ '" ~ v 00 10. M ..... ,..... In M 10. ..... '-"' ~ <"> 10. ..... '-"' S 0\ M ..... '-"' ~ v C:!.- ~ .... ,8 1 ft 0.> ~ ~ 0.> S 0.> ~ .... ..... o ~ 5 .- o ~ :9, '" ~ o ~ ~ '" 11 = :; .- tl:. ~ '" ~ o .... .....,S :; ",'0' 0=.... "'~Q.. l>J).....'" .5 bO...... u = .- =.- ~ '" ..... '" =~u I;::: 0.> ~8' <5 ~j J 1 ~ 1 ~ ..s o ~ "'=' .... =,8 "'.- 0.>11 S 0.> 0.> ~ ~ ~ .... .... ..... 0.> o > ,.....0 g8 0.> .... .- :; ~ ~ 0.> l>J) :9,= r.f.)"u ~ !a o Q ~I;::: ~ v 00 10. M ..... In In N ~ ..... t- ; j ~j ~ ; ~ ~ C In ..... 00 J 'Z'!:l .u Q) 1;:::>- 0.>..... :9,0 0.> gp 0._ !a 2 ~ .- ,D~ "'='~ Q & ~ >- ..... o "'=' = ~ I C! ~ ~ m m E E I ~ ~ E E C E ; E E E ~ -- ~ - - - ...-.... h J I J I j i I .. I ~ -I -I I I I I I I I I I I I I CITY OF ANDOVER Tax Increment Bonds Debt Service Fund Balance Sheet As of December 31, 1990 (with Comparative Totals as of December 31, 1989) TIP Project 1-1 Account TIP Project 1-2 Account Totals 1990 1989 Assets Cash and temporary investments Receivables Accrued interest Delinquent taxes Deferred special assessments Due from other governmental units Due from developer $ 357,412 $ 286,859 $ 644,271 $ 448,996 3,928 4,059 7,987 5,426 41,438 41,438 30,759 70,166 70,166 5,113 5,113 12,273 229.051 229.051 $ 478.057 $ 519.969 $ 998.026 $ 497 .454 Total assets Liabilities and Fund Balance Liabilities Deferred revenue $ 111,604 $ 229,051 $ 340,655 $ 30,759 Fund balance Reserved for debt service 366.453 290.918 657.371 466.695 Total liabilities and fund balance $ 478.057 $ 519.969 $ 998.026 $ 497.454 -49- ~I ~ I ~, ml ~, ~\ ,... ! I E1 I ! II ~ E ~ C I I I E ~ E - ----=----- - ------ . - t J I 1 I I I I I . I ~I I I I I I I I I I I I I I ,..... 0\ 00 0\ ..... ~ u:i :> o o z < \l.. o >- E-< - U II) <.l r:: '" ';;J III 'g :I ~\l.. r:: r:: <.l =...-l co \l..~00 II) bIlO\~ <.l r:: 0\ <D .~ Cd......-t "t:S ~ O.....&l tIl~M~ ~ = l-l co 15"'$>- o . e .... ",~II)..s ~ <.l =.E<Utr./ 0;00= 1Ilr::~:I ~ (I.) d) 0 r:: ~.." e Su:i&l< II) . = ';;J t> ~ os Z r:: r::...... <.l -11)""'< ~ 6l II) E-< ~ .~ .... ~ o ~ = ~ II) a ~ 0 .... u lS -5 tIl ._ ~ ..... M 1;) ~ ~ 0\ 00 0\ ..... 'i:' .....~ 1;) II) ?'g.." o8~ - ..... ..... O"'\l..~ 5 0\ Z - '0' <';l 8 e:<E-<t:\::.....< t) 'S \l.. 11)..... :I """",,.~ I 0 E-< 8..... <.l ~ < ';;J Z <.l < o r- o. 100 I/") M ~ 000\ r-r- OM 0\0\ ..... M 00 I/") "l o I/") ,..... ..... o 0\. o C 0\ 100 00 o 8 r-~V1 v r-..... 0\ ooN V'I/")'M...o M N....... ~ ';;J ~ 8. 0\ ~ o 0 r-~o vor-l/") NOooO ...... 1/")' M 0 I/") NM I/") 0\ 100 00 ~ r- v <'l 0\ 00 ..... ..... I r-~I/") 00 r-o 100. 00 0\. 100 MO\ N NM N ~ r- ..... r-. 0\ I/") N 0\ 100 00 ~8 1/")0 V'I/")' N I I/") V ..... o' 0\ N ~ ~ I/") 100 0'). 0\ ..... I/") ~ 0' o M. 100 ..... I I/") 100 N 100' M I/") '" tI} 5 ~ s co t; a'S 5 ~.s g ;:;.... = II) .... II) 0 6l 'El-g l~~i ~~]~~]~~ er::......=.........- 1I)!:'<i.....1I)>~0Q) ....~u"'.... <.l <.l >...... ~ II) II) '" =o......",.~~ca.- ._ bIl..... .... r::._ ..,.. CD ~ "'"""" co Joooot _.J ~ :I~~ -5 aiE-<.E 0 6l ~ -50- , I/") 00 o .n ~ , 1/")..... 1oO~ MOO..... Nr-O 0\ 0 ..... N ..... ..... I Nr-O\~ .....1/")100 vr-..... 00 0\ 8r-r-'<l"~ .....I/")r- IoOr-M o 00' 0\ N..... M N..... M 81oOr-M~ I/") 1/")..... I/")r-M 1/")' 0 100 .....0 ..... ..... ..... ~~' ~j ~r~ I .i .... 8';;J ..... .- ~ '" >.- II) .... ~ .... <.l .... II) ~ ~.s ~ .fj z.....~_o .- ~ ~ II) aio ~ u:i ~ .... Z :g II) ~ ';;J ..... ~ ~ .... Z .... .- 0] ~II) <.l ~ ai II) .- .... ~ II) II) ~ SII) ~ ~ <.l 6l ~ .... 0\ 8 ':i M ~j ! ~ 100 r- 100 o 0\ ..... ~ ~ ~ ~ ~j ~ N 0\ I/") M N ..... '<l" 00 o r-" 100 ~ ~ >> .... o II) gf <.l ._ ~ :3 C;.Q ~ II) ~1Il = ~ ~ >> .... o ~ -g &: " <J '> ... I>'iJl ~:c o Q) Q) 001l ~1~ ~CQg <<l o=~ ><"CQ l:: ~ u ~ '" ..( 01 .0 " "" <I) c ~ 4).... _ e ~ ~ ; U {I] V) 0 2 ~ ~ 8 ]'~-< ~i.<= e ~'~::J 8 0..=,4)0\0 .s u{l)-o(, e ~_mCD~~ eE"'8'~oo8 ~e~~~~: boo. j:Q 1:: ei-g.g~~: le~~~~~ .. b"'8.<l: e~.~gg u....... () ~Cl'll~u ~ e ce ~ 0\ 00 0\ - ~_<c;0\,: e ~ ~ I:' 15 0.. e c 0\ '-'> oS ,il-;c - '" ... " 0':> 0\ S 0\ " _ <J " ...;0 '" '- ... 0 1l ~ S '" 83 " 0 Or-< ~ ~ Vol ",;j -< ~ "" S o U oS !, ~_'Ooo:g e 5 ~ t"'- 8 o..~CO\u ..s "~-.( b ~ ;: > 6 .. = '" e j:Q .g I=: 8 ~c ~ ~.~ .... ~ c :: ~'5 < c u CI) f"'-. 5 e~S:u Q..c-.( ..s~ 'i! ~ <c; c ~ ~ ~ g e g ~ 8 ]'= < ~-..I V> '" ... ~ "-' - M 0 00 "'~ o "l!'('t'l \I") \I') M 0\ V') ~..c~_ --... '" ... 00 .... Mo - M M ........'" '" OV> M"'''' ~...;o V> ... - - '" ,; ....' ... - ... ... 00 M 00 N '" 8~~~ \0 CIC V M ~oC ... 00 M '" cO ::: 8 "'- - ... o .... """ - ... - ~ "'. - ... ... - V> ...- - ~ V> M~. V>~ ~~N~ ~"':'"I:t'..._ - .... M ... ... i -< .. 'i! ~ " .5 i:- f o 0.. e s ~ -g:g " > .c "i) :; il UIS:: :l 'S '" t a ~~ w ! i CD " II " = = ~ <;; .~ - .. e il.~ II " Iil' il -s 'S-i'O .~" e 1l g.1.g ~ :E r.2 4) ~~~15 e!; M ... ... 8~ M - .,; '" ~ ~ ~ J ~ ~ ~ J ~ J i .. " ! -51- , ~~~ 00 cO V> V> '" '" ... ... "'~'" '" '" V> V> MN V> V> ... ... , ~~~ -- ... , e!;je!; MM ...... ... ... ... ~~~ "'I'" ... ... , ~~~ '" '" ~~ ... ... " l! " -; = 1! ~ .., " " .. .2 ~ ;:s .. ~ ~ ~ ..!! ~ 4) ... .0 l!! i! ~ u 4) " :l' ~ 0.." .. a1l1 m~fir.2 ;g~~~ ~ ;.::l M V> "'- :;t M. - '~ ~ ~ ~ '~j ~ ~ s .~ o ,S, cl m V> .... .... .,; M M E .. V> o <5 - E ... I ~ !.! ii~ I II I II '" M 00 ..; '" , "'~ M~ ~ S M M '" 00 ... '~ ~ '~1 ~ E - M - ~ - ?l ":. ~ I ... ~ - - 00 ..; ~ '; ~ J E I ~ I " l! " 0; .0 1! ,a ~! c-.g ~ .() "0 C r.=... .~ !cS"g.g " 1l ~ " "~llP 3 II ~ .!~P .., " ~ " " .. " ",!! .= lIS :::.c ~-g =,a ~-g f-< " I " " .~ I E ~ ~ I j ~ ! I j I ; I ; I I I ] .s ;:; o ~ "" " & e>:: 1l ~ .f> :> ... o " OCll ZoO <: " ~O O~ >< 8 t:t:!:l U ;:; " s '" '" " '" -< Ol .0 " "" CIl I I I I I I I I I I I I c ~ e'5 ~ = C) fI) 0 6 e~e:~ "" c .... ..5i~ !!"8 == e~.~g8 ~~~~< e . " m efl-g ""e~ ..5i '2 ~~5 o ~ 8 < I> m efi] !e~ 00'2 ~CI06 o ~ to) .( ~ 00 Q\ - m 1"0 -= ~5:~=o w~.t:oou ~=~~< - E - "" ... " 0.0 Q\ S Q\ " - <.) " Q) ...:- 0 """'+-0 .c: ... 0 CIl " '" " .0 '" g S '" '" 1l] -a 4) 0 t:!:lOE-< '0 ~ rJ'.l '.;j <: e '" S- o U oS ~ /) -< == e~].~~5 !e~Jl~~ ~~::u~ c c'c ~ 8: ca~~~o ~ < ~ G'J om 0( = ] '"8 .~ ~ 6 t2~~~~ ~ ~ b = c: e=~~\C6 0. ~ ] 'C ~ g ..5i ~ < d :: e '5 -< c ~ (I) ~ g 8 ~ ~ g "" c < ..5i~ m ~ .;;: '" r:: "i , _.......~ 0"'0- ... '" '" c<i'M"'V') '" '" ... N ... !:l '" N !;j: N_ON~ ..."'....0 Ot"")O'I~ Nr:~"OO -NO~ N ... oo - - - .... ... o-"'o-"'j Nt'OON _f't'-\O oo"'~"r--"'- -- .... ... .... '" 0- r-: '" .... ...... "'-~ "tt"_ON 'o:t'"_OOt:""l ~~~~ N .... N ... ... ... ~ '" ",' o "l. - ~ ~ -ON (6l N'" '" '-C}....'<If'..-.:it:""l N\O~ - ... '" '" "'- r:: \rj 00 __ v 0-....0-'" Ot:-I:"--O\ .-:..~~ N ... oo '" '" 'Ii 00 ~~le~j Mt:""l\O'V MN"'~V') ~ ... - '" '" M '" ":. - t""l"'ltOO"'lt 0-"'0- '" '" '" <"'1"('4"0 N '" ... m '2 ~ m " .5 to e o E' ~ :.: ",:0 c " " ,. .;j 'Q " 3 U~ :!I 'c m " I~~ M ~ ~ m " " c : ~ :3 0; Cl4 1;; (,) <<II ... e ~.- u t) ~ ~ -S '2 ~ '"" 0 .- ii e "0 = "0 8 i! go ~ "" o ;.: c2 C) I:) u.2 ::s <Q,:lQ ~~ j ~ :!:l .... ... '" N ~ ~ '" M - ~: ;! '" J J ~ le E '" ~ ~ ~ .... '" N ~ i m .. ! -52- 3~~~~ _ N", .... .... ... , ~~~ ~1S NN ... ... N~N '" '" '" '" ~~ .... .... ... oo~ oo '" '" N N ....r-: oo oo 0- 0- NN ... ... ... -~- '" '" "'''' oo 00' ~ ~- - - ... o-~ 0- '" '" "'''1. '" '" '" '" , ~1~ ........ - - ... , :g~~ '" '" '" '" ... " g ~ .. 1'<\ 'E ~ '" c .. m ~ :;; .. ::J s o ~ ~ u E-04 _ 11) e " c " ,., " ,. a.~e ~'ll] 11) 8 ~ ~ ;g<<~ ~ ::J .. ~ ~ " g .. ;; .0 '" C .,e "'! ci ~ ~~ 01) -8 ~ "'g 'fi ';"'llt'E g t l! P -! ~ ~ .o~P 'E ~ ~ '" ~ N 0- oo N '" '" ~ ~~ NI j ; ~ 'ij ~ " ~ J ~ '" " a '€ o "'" ~ oo o 0- ... o ":. - le ... s - '" '" 0-, - '~ ~ ~j ~ ; ~ '~j ~ :!; .... M .... o ~ ",' 0- oo ~ 'Ii oo ":. - " o .~ " m g ;g] :0"'0 .. c :=.,e '3] ~ .. ~ El .~ o ~ ] &: i><: 1l >LI's: ~ ~ II ~CIl-= ~CIl oil o 1l J.I.c U,I ; 0]-.; >OOl!! t;::l!! Uc; " S '" '" 1;l '" <( -.; Og e. CIl s:- 00 0\ ..... ..... '" .... " 0'8 g:: " ..... g ":0 '" .... .... 0 2 ~ s '" 8] ~~ .... " o .e; <~ S- o U ofl 'fi ..... - m ~ .. .....:.c J: u ~ g ~ 2 g CIl .... .( t 11 'g <<i 2 8 ~.... .~ c, ~, ~~ <, <^ c, ., "" ~ ,., .... "1. - - OOVl__~ ~ \0 N "co N~\OO\ i8sf~ NMN- 6- - ..., 00 !;j: ...: ~ '" ~ ~1!l ~\ _V'l..... - ~...E..;- ~O\_. __0\_ ...:- ..., - - "" ~ 00 Vl NNV')ClO O'I._MN .....- .... ~ - - ..., Vl ,., 00 ~ '" "" '" 00 .... oC r::: Vl ,.,; - ..., ~ -< l! I " .~ e- II o e s ~ -g:g .. > .c 00 :; II Ull:i :I 'S " :Ie - m Se e C ~ I i .; = ~ 1;; ,~ - co " ll.!l l:l t ~g-= c-i"o ~ ilJ 5;: ~ 0 '<ACl~ i 5 ~ ~ ~ i .. .. ~ .... -53- ~' ~~~ .. Vl '" "'. -- -- ..., ; ~ ~~~ _ Vl.... - - ""'" ..., ~~ -1- " . ~j5 ..., " <> e .. -;; I"l "" e Ii: 11 .. .. ~ ~ ;:l .. ~ ~ ~ ~ ~ 4) ~ -;, c: e >.. u ~ !.~2 l!1l"2 g 2 f: en u (,) ~ ;g.<.<Cl :;; .. ;:l " l! .. -;; .0 " 11 <> .a '~ S - ]~ o is: , '0 "0 6b '-;:S w "'0 ~"'3 0: ~"" i:'l! eOgp c i: e .!! l! c .z~p 'l! Ii: c~ cl I I I "" ~ ..' ,., - ... - ~~ ~ '-~ ~ ::6 S .. .... ... "" .... 00 "" 00 - ~j ~ .~ ~ ml I - o '" i .... '" I - ,., ... '" "" Vl I 8 .. ,.; 00 "" I E I E E " <> .. c .~ -a ;.::.&J ~~ =.a s-g {3. .. I I E E E ~ ] 1 ~ II ) I - 1 j I -I -I ., ~ ~ txl "" = - '"8&: '2 '" = ., ~." 'S 8 a30 Q,) "E ~~ ~ Q,)Cl:I-Q lil~O"':-1l >i~M~ oCl&lllJj ~j Ml~ ~txl'"CI .... o=]~tS b ~l~3 u IZI~~ 0 ~ .....E-< IZI 0 C';1 Q,) ::; ~>:.:: "'> OJ ." :a al~ ~ ~""' e CIle e ti u ., .;3 e .~ ~ :> S '-" CIl 1 I I I I 1 I 1 I 1 1 1 ~ e ~ 1;; ~ c ~ is E ,5 " " c > ~ 0 _ se .E .,,~s liS 5 ei5~ & B"'d 'e G) ~ ~ iEl";~E1;;~ ",~L~5~*g ~~soe"C:i "~f.4C1lt) t~ ,,".!l ,s e~..s 0 ! =:: e'C "C uU<;::l >CIlV"lO e~~ g l~-< , - ~-..a~U3 o c c.~6 0 " "Q ~oo " c..S~~~L< s:: 00 a- - .. a ..( ~ ~ c ~ ~5.g~ 8 ..s ~-..( o a- a- ~...'1;00= E ~~r"'-- 6 c..s c::a.. (,) ..s ~-..( .. 1"0 = ~ g "'~;::l e~"gF-: 8 c..... vo\ (,) 85f1l...-t< -5 ~1~~~ 8lQ'cr-- 8 c..~ va.. (,) c~"'-< .:le "C ".... - 5 0-0 C U "'t-- 6 ~]a.. (,) c;;, 0- (,) llQ < ~ C; ""- ~ ~ &l - ... ~ r--. - '" ~ 'r ~~~rj V"I V"I_N N _N_ ~~~ ::g 'r 8~C';r~ - ooOM_ oc"~_ '" ~ 'r ~~~rj ~ 'r i~rj ~ 'r ~~rj 81 'r' ~~~rj - ON_C'I') -0_ ..,. rr ~rrj ~ 'r 8~~r~ ''It" \ONV"I ~... o\o\M r--M GO l:; '~ 8:;;~~~ V'l t---M_ ~.... ~tfa.. '" r---o ... r:-: ... ... ... o 00 "l. '" "" ... l'l ""- "" - ... ..,. '" r-- ~ ... ... M r-- a- ~- ... ... " i! ~ "C e .~ i! ul~ "~:o e ~ t.e .!l,s e~~..so a.E .~ " ]Q " Q, &j i! 2 ] " ~ -S ~ o '" o ~' ~ "" - "l. <; !j. <i' a- "" - ~ ~ ~ .,; !j. ~ '" o '" -e ~ 00 .,; ~ '" ..,. "" - r-- ::!, r-- GO ~ - M s ..,. a- a ~ ~ "" o 00, ~ "" c i! 2 .....~ 0] '>:" g~ "2 I.l ~~ " 0 ::::." =5 8> &je ~ .8 !-;;- -=11] "0 ta. -;- ..a c::_..a -5", ~ c3~~3..a'::e z, .- lJ;.: ... -lJ;.: c:: .s =' ~ t 8"~ 5 8 ~ ~ i e .. ~'E 8 ~'E II] ;::l"O c:: u~ c:: U"C:: ig!!"'-S!!"'e- ~ g CIj.E)"o. CIj:5 .9 '0 c.."B~u'E~~ c." I: I: 1! c" " :~8" 8" ~ -54- " is . t " "-" e ~ '5 ....i] o .. .. ~c'" 0"0 e c c 2 .2 1! .~ ~ ~~]= ~ t g.,~ ~ ~ ~"o .. ... c 8"0 U ! &1~~~ o :g ~. is'' 'Ii a- M <i' a- "" - ~ ~'" ~ "" ~ :g o - r4J ~ ~ ~~ ~ qJ ~ r~J :;;- ., .s ti e ~ ~ "" - "l. g -. , r-- "", - - M ~ ..,. .,; !j. - - "" .... a- ~ :g '" -e -0 , , "" -0 ",' - - ~ GO .,; ..,., , b ",' "" - ~ ~ "" r: ::!, r-- GO -0_ - M ..,. ~ .... g ~ a- ..,. a- .,; o ~ ~ .s! ~ ~ ~r.! .. .. c c ....1: I: -:1...... .-a >.~~ ~ '0 "g."g. :s. c.o IU U u.~ <<i c; gc::.g..g .! "SiJ'g;.g; ~.l!~~ ] &; Ii ... 'g ! .. ~ ~ ---Ol 00 ll~ ~ .9"8 ~ -=&: .... 8 ~ lU '-'..... S "C ~o 4) = bljO\ g ~~~Cl ~ .~ e ;ill ~ojl]~ - ",8 t;l ~Q)Q,)CI) ~El:l>< t.1.cUJ....cQ Iool O]].",.E ~oQ,)Q,)rI.l t::~.!t]] U=....~ 0 .. . t;l f-< 88.... ~ ~~.:: 0- ~ gj~ t;l <~ "" Ol~ 8 .~ 0 3= u ",," ofl fJl ~ 'Ii S '-' fJl -- ~.....a::<~ 2 li~'c~ 0 c..e ~~Q\ g ~._< o 'C = eCi~~6 flo "e10\ (,) oS l8-< ~...'Coo= e c .00 6 ~ "eil'" 0 oS l8-< .. ,o,il .. <<l C! U.l!l;06 ~~c uo\ g ~uc;n-< e .. ~~ -<== 2 l8.l!l;O 6 i5~~~ e 00; "'a "'0 -<: f:' ~ ._ llI':I -'U c: "'8 ].~~ 8 ~~~~~ Ill\ f:' ~ :.a~~<5 c: C:'C~ 0 tS~~~g ,;! <: .. ~"'8 _=c 2l8.l!~ 6 J~~~~ e c~ ~'5<c uu)\o 6 e~~ g c..C::-< .s~ c~ s't ~ 1: ~U)~ 8 e~O\ g J~-<: M ." '" .,; ... '" ... ... '" ~ ~ ... ... ~ "" ." 0_ - ... '" ." o .0 '" ... '" ." ." .,f' '" '" ... '" '" '" "" :::; ... .. ~ ti ... 0" - '" 1ti" ~'F "rj ~ Or ~~';f~ ~ ~~- _M ~'~ '~rj 'r ~~~ 'r 'r '~rj rf ~~l rr ~?1 rr ~~~ ~ '~ ir~ ... i!l. a ~. ~ ~r~ ~M"" "'- M- .,; , '0 .... '" r: ." - 8 '" ... ~ ... ; ti ... ... ... "'. '" ::l ... ~ " .. ~ " u = ~ ~ E ~ .~ e ~ c 0 - sl! il il"~ lis e e ~E-< 5~"'d'eu~; i ~ '; ~ e ~ ~ u~a~~~ ....:l 0 I! -.- 3 ~"'() ....s~ ,,38 .s e~~ 0 " ~ C! ~ .~ 4>1~ .2'0 e t e;.~ 805 e~~~O ali :g~ " & .... '" - .,f' - ... 8 ." r: '" ; ~ .... ." ." ~ ... ~O ~ .,; c. - ." '" ~ .. f<:' '" - e~ - ~ o :::; ti "l. - eo ~ g ~ 8 '" "" ~ ... ~' o ." ... '" '" '" r: '" M , 0 ~ '" .... '" e ~ '" '" ~ ~ ~ '" ... ... \Co 00 '" .. "'. - M e .....~ oil . -;;:;u I! ol'l' .e Ho :g ;g~ 4) 4> ~ .... ~o ~ - = e " " ~e III ! ~ .~ l!-;;- "'ll ~ ~a. 'C' i3Silll':l~ri ! .=~~~a;-g'3 ~ ;'j 5 8.~ 5 8 ~ ~ i e "'.- 2"'.- " :;l~ a t~ a t.r: i~~U)'3~(J)e- ~ e bIl:O'o. bQ~ S '0 Q:EQu'Eo~ ~] 5 5 "'~8' 8' t ~ -55- ~~ i!l ." - ~ " e IQ "'" "" " e~~ 'O~-g .... ~C:OQ l!.u I! t)C:a_ .- l!.- II ~t::]:s ~t&.~ "-So ~'o .. ~ c ~"g ~ m f.a CI;I ot:: ... '" ~ - ~ ~ ~1 j :1 j J ~~~ J "'MM ~..o.._ ""'0 ("1.,\0- - ~ '1 j j ~ ~ '.. 0 ~ c: - o t;! t "'. 0 ~ t - ." '" o - .. ~ 0' 0 ." <'l ~ ":!:. So. '" ." ~ ..." 0 -.... '" .. r-:~ tj,::l e ." ." !i """ :::. '" '" '" ~ - 0 ... ... .,; '" ~ - ~ ~ ." e G" '" ~ ." o tj. ~ l!! ... \Co '" 00 "l. - M ~ .5~ ee t.2c.2 llll ...l!l! -:1-- .~ >.,e;.~ ~~'5'5 <:!...ll'll' ,,-- C)'a co <<I 5.5~~ _ t)(l0 It) ~~,;!,;! ." C Ii: '" ~ ... .. '" 0 , ." .. 8 '" - 0 . '" .. "" '" "l. - ....0 '" - ~ "'. - i .... o ~ i i3 .~ ~ ~I I I c E ; I E I ~ E I E I I m I E E .I 1 I 11 I ] I '" i I J ! ] I ~I " g " :;-"; ,,1Il "''tl .S ~ ~ Q~ ~ 8 Q Q) '-'._ .,D 'tl "'0 S = ~O\ ~ ,0' ='" " - ~ ..-.q:~ ~ ,,-" "'tl p:;j.~UM <L> >>""d ""d 8~~]~ ~~ ~!~ I.Lc r.l:I'~.o ~ O'tl'g'tl<E ~ S g,~ ~ t:1Il><=s u=~~o Q,) "1-cf--4 "'''''" ~ 6 do) > rJ) <L>~'~ ~ ~ e <~ [ -..... e .$ 0 0 .3= u 0." .;:; CIl S ._ $ ~ S '-' CIl CI I I I I I I I I I 1 1 6\' 00 '" - '" 00 '" ~ ~ ...of,) r-: ~~; ~ oe.l'l - ... o '" '" '"'~= "" :> .. e 0 !Of.-, 8 "'~< 0; :> ~ '" o - '" ~~ 3 '=28 ~f-<.:.! =~ e'fi~ c ~~~ 8 8-00\ Co) 6'5-< _l'l 0; a .:.! ~ ... ... - o "'!. '" ... ... "" ~ ... '0 "l. ... ... '" ~ ",' ~ ... ... S "l. - .....00 '0- C"ier'l... -'" ~... SV;p 8~~r~ O\v t--t--t""li _"'00 ... oO~\CI 00 \ON__ r--.. O\"l - gg;;::~ 8 ~8~~ t"-O\ t"-Q\_ \0"'... ""0\""00 ;::.. ~..~~- - ~;;::r 8:1;~~l ('0")0\ v-v -"'... orEv"'r-- M OO('f"jON o O\\OM .... 00_" --r ...... ...'" r-: . 00 ~'f r r "Tj .....00 '0- ...... ~~ ...... - , . m " 02 ~ 10 'E! u e " "e .~ II) is 4) c: e ~ e 0 _ ~i ~ 18~ s c:: ";) "Go) O'.l 0'"0 ~ iO U g O'J e.- >..::::1...._ ~E:c~e8 ; ~ :; is e .9 .~ :; ~fI)U ...~::s u~8 .s e~~ 0 " t ~. " ~ e .':: e ol~ .~'o e ~ e~~~B a.<: .- " -go " ~ i! a '0:.0 ~ll i! ~:t .a ~u :g ~~ " "0 ~ ~o - :e s 8~ ~ &1e ..... '0 '" .. ~ ... 8 00 ..;- ... '" :; ...' tt '0 "'00 ..... ........ v... -('1"1 - v;'M" ... 00..... o ..... ..;- q> 00 "l ... ..... "" B '0 !;;:. - a ..;- ~ <5 '" ~ ... - - 8 - 0:: ... ~ .. - ~j ~~ ~~ 12~ V'lO <o:t \0 00..... _ t:. 0 .. ... ... ... ~, ...~ ~V") ~ ""0 ... 00'" ..... t:. 0 ... ~i ~ 00 ... "'... 00 ~ ... ~ ; ........ "''0 '0- o\~ ""- ... t:=:'. "" '0 0:: "" ~ "'00 ........ -... ""I'M 00..... ..... ...... ...- ...... ...0_" ... 0'0 -'0 .....- oON"' ...... 8" ... ",' '" ~ ~ "g 1!-;;- ....21 '"0 te. ~ ~c_~.s. M c::::l~CO'.lOU a. .e~~e~"'8'3 ~ m r::"llr::,,:>Oi u c2'~'~'='>t.2.~ ~~ em me; 0e;2I ='"OCG) C::U'C ill~"'s~"'e- ~ e gp:O'o.~:O 2 ." ",.':: ~ a.,:: ~ &l "." e e 1!"" " :~8" 8" " (5 -56- " e ~ "" " " " > e oS ~6~ o ~ ;I ~cO'} g'g ~ .~ ~ :6 ; tl:tl:c= ~~&~ ';" -5 ~'o fIQ 0 "" c ~"'g ~ ! ~ co 0 It::: '" ... '" ~ ... ~ ~ e a 0:: ~ ci -....., 00..... '0...... t--"~"o "''''..... t--..O\\,t"') - - ~~ ~ '" ~ ~ ',) s- '" - ... ~ ~ ... '" .. ;;;;- - - ",,' ; .... ... "" .. ~ - 8 '" ri -g- " 0 ._~ r::r:: roe roe m m " " ..ee ~~-- .;; ....~~ t;::"....;.; !~g'g' ,,-- g'g.g .g .! '6b';;';; Cl:lVVU .cl'l~~ ." " ~ ! '- o -g l>l ~ '" "" ~ fl1 8 z < P- o >< t: U - '" II ~Oe l') ~ ~ 8 -gV)-~ ~8~e g] ~ ~ .~~ e : ~ ~~'3 ~:5 A ~ ~~'O ~ u 0 0';:j u..( e " ~ o U -5 ! ~ '" "" ~ .. ~ I-< o '" '" 0: Ii ~ ~ ~ ~ C g ~ " Clo" Clo.5I>( 0: ;; " .~ ~ Clo" '" .. .( ~ ~ 0: " ~ ~ ~ oS s'" ~< " o c:: '= .g.g 2 ~~~ '" " o U ~~ I" ~ .~ - " II ~ :I l! .( S -c ~ 0). '" ... "" - "'" ~ .... M ... o "" - ..c -c -c ... -c -c V'> ,.: .... ":. - ... ~ -c .;; - ... 8S -- ,.: -c V'> .... -c "'~ o-~O\ _l:"'lr----l:' r:...:f'i'- -c .... "" , V'> .... "" "'I 8-M- '" "" V'> ~"':r:f- '" ~ "'. - V'> - - '" o ~ ~ 'I ~ '" -c '" o M ... '\ ~ V'> .... -c ?; ~ M ... o "" M , -c "" q V'> ... 'I J ... 'I J ... 'I J ... '\ J :I 'a " .. 0: ~ 'iiil " .~ i::- f! o Q, e s " -g~ " > ..c .~ .. " .. " UI>( .. C fIJ ~ e C ... ~ ~ ~ = M U ~ fI'.l ~ 'ii CIll 00 -'- - (D U a:J ... e 4) .- lI) " '"" g -5 C ... 0. 0 1fI'- C fIJ e 0: 1l "'" " " & g .g 8~:at2u o 0 () lI) ::s <<000 g ~::; b '" ~ ; ~~I ~ i .. .. ~ I-< \0\01 N "" .... '" ....0 "" M v; 0/".)" V'>M .... - - ... .... 0 - 8 '" 01"" oo:t\OloO MV'l(""l Mt'--OO(""l_O(""l ('l')"'~-:-: 0 ~ NOO\n- OO~ "".... ... ... , "'l'" '" '" -- ~~ '" '" 100_0\\0 M \0 V"l_ "" "" -c ~-:oO -V'> -IV'> -.... "'M 0';- V'> M M'" ... ... l , 00 I 't"-- '" 0 - - 'Ig ... ~ .... .;- -c , "" V'> M , '" M o ,.: ... (".1("')10 - '" V'> .... V'> "":f'i M'" ... (".1ClO 1V"l I "'V'> "" .... "';ri '" ... ... ... " g .. j 1l ~ 1l .. .. ;g ~ ;.:l .:la :l ::s ~ ~ ~ ~ ] uu~..~o['""'" :c: :0 0 a co <<:l 5 C/l) ... ~ ~ ~ 0.. lo-l ~ ;g o.~~~ e u~o"Oo~ "O::seeSE ~ij8coo~ ~tl<8<8Q ~ ;.:l -57- ""'~Oi I _ ("') ClC - l:' r--- 0.. 00 ...c 0 \t"') ~ ~ ~ GO ~ ..; (""l ("') c ~ _V'>, M"".... V'> '" 0 ~li8 ",_M .., - ""~ ~ ~ ~ ~ f:! '" 0 M '" ~ '" "" _ "" ....'" f"'l" (",i"' 0.... V'> - ~j ~ I ~'~ M ~ I ~ I ~ ~ ' 'I ~ - !1 ~ ~ I' I EI ;1 ~'~ ~i ~I ~'~ ~i ~ ~ 'I~ .~ ~ JI E 'I~ '~~ J I ~ l 'I '\ J ; l 'I 'I J I i g '2' c ~ ~ e ~ :l Clo '" 's..'; a a- CCI C" ~'o ~~ i~ t.ScS~OS "<;I_:ll-< g ~~m J! !!!! .~ -8 "'3 .~ .~ .g i~~~:5 ~ ~ J::> '" " ~ ~ ~ .! .; :.:::.CI :g-g :=,a ~1l I-< .. I I ~ ~ )1 .. i I 11 j 1 i " 11 ~ I I I I I 1 I I I I 1 1 1 I .. 8 .. -; t:<l 1! If .S fl1 > o o z -< 11. o >- E:: u - '" ~ ~ .. .0 tio~ "'O~~ ,,-0 ~ ~...:~ cenM"O ,? e "" c -B"1ll t>:oe .... ,g.,fi u :i ~ Q.,~> .c::; XCI "" -~"'OcE ,~u""g en g<acs u t)~ 0 t ""E-c ~~~ cc;>'= ~ f " .. S e- 8 0 S U Ul .;; .. .- " II 'S ~ ~ o U 'i!~ 'i!" u e,5 ""> :!>- C 2 ~ .. 0... "".si>:i fi; 00 '" - :5 c':;: e.52 2 ~St;i Ul" o U w '3 o f-< 'i! -.. .! E g ::l o.:l Ulw -< -t: d: = .. " E ~e " ..s 8", ~< )" oS ~.- -" J" ...... ~.: -" 11 } .. i! .. > :I e ,,- ~~ =e:2 lic" =~3 "ii Ocn '02fJ ....8 e~~ .. > ~ - '" '" 00 .c .... . - '" .... .... ",' '" - - 8 ... 00 '" - - - - - - - - ~ . ~ '" . 0"''''1''' eh_\OOO \OClCehoo 'Oft'.....:C1C'Oft'... 00'" '" '" 00 '" . '" o' 2: -\nI'Oft' .'" '" "'.... '" .,..;~ r: "'- '" '" o. - '" , ~ ~ o .... q c: '" ~ ::j;:! 0...... "''''''' '" '" ... '" "''''~I 0"'0 \O..t--v "'...- "'....- o - ",- 'I~ ~ 'fJ ,- '" - ",' 00 '" 00 0100ij "'...'" "'000 ~Mt-- "''''... ...._ 00 - - ~~ '~ ~ '~1 ~ "p fFi '" ... '" o 2: '" ... '" ..; '" ., l '.... .... 00 ~ '" "''''~'''ij -"'.... "''''- NOM "''''00 ~ g:F1 "tMO'> '" '" '" '" "l ~"'Fi , ''1' ~ "F a .. ~ .. ~ " .- .. ".,!l 0" _ "S,9;g ~ E~oE-c u ~:a ~ 5~-8~ ~ ~~ ~ e c ~,- ...-"";:;; g ......F~ "''''''' '" ... ..; ... '" "'''''....ij "''''.... '" '" ~ ~ .. i! ~ e i! B :;; " .. ~ ;., ~ ~ ro ~ 6 .g.,s~ 2.- e 0. 0... e'SU.s z"6. :ga .. t '>: g ~ .2 > ~~e ""B ~fi:o " > " neu ~~ ~ III I'>' '" 00 ~ '" .... - ~ !@ ~ 2: - '<r;-R1'>'09 ....'" - \t")--\n O"C"'i"'r;\n --'" ~~- - ~ 00 00 .... .,.; ... - '" fi; ... 00_ ~ q - ~ ~1'Oft'_~ \0: ~~~ - t;, ~- ~ .. .,.; ::: " "'I " f:' '" '" ... :e - ~ ~~~ I I;~~ "'-'" t;, ~- S' ~ e; , ""I " ~ '" ",' Cj, ~' -e ./ ~ ~ ":. - ... - I I~ ":. - ~ ~ '" '" '" ",- ~ " "" 'I ~ '" '" '" ..; l:> " '''I 'I &0- '" ... ..; Cj, , ""I 'I ~ ~ g " '''I '1 ~ '11 " wg~.... """ Ii ~ ] ~r:~.e. .... 3,? ~i32-g:: Ii ,,11. 0 .. ,,11.f-<_ e ..2- .--- :s~... uS:s " f g f'" li .. g.~ 0 i e ~"2'~ 5 t.~.2';;E-c =.oc:.o..cc~~t:p;:;il i 3 ~s b e]~3:a .. \I "".- ",," " ~.- e .S l:: c ~c:: 5 u~ i'-o 8:'Eu'Et.:l~ou< l!c:u u ""~8' 8' ... " .;; o -58- ~ ~ ~ ~ c!: ;., "... .~-g ~~.s o Cl:I'- ... 0 ; ~ u g ~] ::s ~5!O<<l~ ut;: ti Iif.l'- ~t""eeg U~U:s::S<<l ~......;; 0.':: " ~ 0 0 1ib"'Ott:: ~ ,.: .. "1- - ~' ~ S' 00 .... l!i' - :::. oo~ i ooNeh N O\t--~ 'Oft' vi~o M _ON N 00\00<\ M ..; '" - ... .. ~ - '~'I ~ M" '" - .c '" <"t - ~ n~ S' ~ e; ~"I ~ ~ ... .c Cj, ~"I ~ '" '" '" ~ ::: "'...~ ; -\0\0 - 00 00 00 00 OO"N"N 00 "'''' ~ ~ '" '" '" .., ~ , '" ;1 ~ '" '" '" ..; l:> 'II ~ .. '" . ~ ~'~ J ~.. 1 ~ M q ::: ~ ~'~ J E .5S f C ~~ " " " " ... f f :l~~ >.~~ ~'_.- 0"" ..gogo ~ ,50;-; oC:::s:s ~.~~~ Cl:I u u u ,Ot:<li>:ii>:i '" " If l ..... o J ~! ('I '" . ~ \Or-- . '" ~-~, ~ '" ('I 00 Irl V "l \0. \0 \0 '" E 0\ 00 \0 .nO' '4 ('1"'00 00 '" V ('1('10\ 0\ .... ",('I .... '" ~ ~ ] I 0 V \00 ~ ~ 'T -91 ~ f-< r-- 00 00 00('1 v"'.... V 0('1 ~ 1rl0 "lr--oo 0 ~ .n ..; ('Ir-:' 0\000 0\ 00 Irl '" (:!i 0\ "'....('1 E .... ~ ~ g ~ ~ 'T '~~ ~ I V 00 00 "d .~ .' .... Irllrl <O\u l'i ;0. 00 ('IC'i .b 00 e e, V ..... 0'\..... C.) .... .5'-': tI.I Co) """' CI) fS <It!: EI u ~ ~ g "d .~ .. r-- Irl . ~ , , . , ('I '1 ~ II <oou <: '" .... Irl ~ ~ --. =, ('I 00 0 0\ ~~.s8 r-:' cO 00 00 00 19 .-l ~ t~ 0\ 0\ 0\ 0\ 0\ .... <J'l 0.... ~ ~ ~ .... u '" -g ~ "d .. .... ....0 ~ '" . . '" 0\ '1 ~ o~ 00 r--oo V V 00 ::l < ... ~: "'. ('1('1 V V v. ~ :' ~ l.I.. 0\ <Il ~ ocr 8 .... ..; ..; ..; .... E III ... 0\ ~ 0\ ~ ~ ~ ~ > ~ .... 19 0: ~~ ('I 0 '0' 1l ...: Cl '" ' ~ ~ ... "'..... Cl Po...c::: .... 0 ~ .... '" <Il ~ J , , J D ,S <Il.t> ooool u e en "t:J 0\..... l.I.. ~1ii<ll] <1l~!3 0 u..~o b "':) 00 c) >< "dCQClf-< ..... e . () ,S Po. 0 CJ f-< < ..... <Il '" Z ~c ~ .... o > ~ ~ U I tf.lo-t .s <:e ,S .o '" p.. 6 0 I u .fl ! ~ ; .;:; l.l:: <Il ~ 13 <Il ] ~ E ~ ~ ] "d ;g ] '" Zl ~ ~ ~ I ~ .~ "d <Il 1 '" .~ <: i !il ~ '" ~ ~ p.. ~ ... .. ~ ~ .~ '3 .~ ''::: ... .t> ... i .~ .~ I .~ .... .~ .... .... .~ -g ... :E ~ ~ ~ ~ <Il gj .o .~ ..e ~ ~ ;.:l .... .... .... .!l.!l~'3 .... .... '3 .~ ,S ~ ..s"'B's i:' ~~ ~ ~~~~ .~ 0 o "'B'" 0 I l.l:: .of-< f-< e ~~g, <Il 1;; fo o ... 0 8' .S 6 p.. p.. 0< ~"'B fo'~ Zl '" <Il 13 ~.~ i <Il ","'B 0 "'"'B -..2e4:: ~ ! ~ e ]~Cl::> I 1 ~ 8 g :-3 g 8 .o l3 .~ <: Cl :=<:u<: .t>::> .;;J g ~ 1 a~ ;.:l l.I.. -59- ~ -- )1 I ~ I ] I ~ , ~ I ~ j I =1 I I I 1 I I 1 I I 1 1 I '" 3 ~ 13 "'I::S ._... :.(O\tis il~.E8 S - '" 0 <I) 8< ~ ~ ;;- o CI ~ ~ o >- t-< ..... U ~ s:- o; 00 t:Q ~ ] ~ ~ .... ';; ~ ..,.,0., = 01) 0\ ~ :l!il~CI ~.<:l . -U-13 ~ "'.., 'e'l J &i ~ . s .... 3 i'J ., ~ k~~::: u]13"s ""d ~ ""d 00 :.( l< = 3 , ~ ~ 0 .B .. ~ ~ s !l ~ ., tIJ 5 >c.~ ~ e ~ os ... S- o 0 -= u ., .<:l e .~ E ~ S ....... <I) ~-ct'Cl oq;lll'--:l ~ .~ 00 0 ... E: . () s ~ 0 0 <I) z< ~ ""d ._-= ~gg~5 ,;::0\_0 s......c fIJ t) <I) 13 < u "tl _ :.(~s I '':'"10 ~ e 0 ,;j~< 0\ 00 0\ - o 0\ 0\ - ., E! ., i; .... 3 5 ~~ ., E 15 s ~<I) ., ., ~:5 i; ~ I/') - "'" ~ .., "'" I/') I/')jl/') -100\ 00\.., ('r')"NV')" .., I'-- "'" ~ ~ .., o 0\ - 1/')'1'-- .., I'-- III 00 "'" .;- .., N N ~ o I/') .., vi' 00 , '0 I/') .., vi' 00 ~ "'" I'-- 0\ o 10 ~ 0\ ' .., N 0 .., .., "",' 1/')- 10 - o - ~ ~'b " "l o' I'-- .., I/') ~ I'-- - 0\ ..c - 'I'-- - 0\. 10 - ~ -E 8 ~ .s ~ ., g ., e 1~3 ., ~ as ~ E!-~ ., 18- i; .... 8 '" ., '" l):5:i .,:l o I/') , I/')~ ~ ~ ~ ~ I'-- I'-- 10 IO~ N1 -I/')I'-- 101/')- NO~ IONoo N 0\1-~ 1'--0010 qO\o NIOO\ ""'-I/') f4 .., . ..,~ - - N N .;- "'" '11 ~ .. ';l 5 ~ 3- .e.~ e :.a l:>. ., [ c:l :5 l< ~ -60- ~ :.a [ ~ 3 ~ ,..., o - q - E. I/') o t-;, - "'" - 0\ 00 N ~ N I'-- Ol. 00 "'" "'" ~ .., I/') o I/') "'. .., - ~ :.a i l) 15 G) E! ., i; .... "0 ~ 5 .~ o tl:: ., S- '" ~ l< ~ ~'" ::s-g -3-::s "'~ l) ., ~ ~.~ '" !il 1: ::s .... ., 01)-<1) .S gf:o ~ '':= Q) JjeCl ....8- ., .,:l o , ~ 18 .... '" ., ::s 15 01) ., .S ~ ~ e~ "'j 0_ ~o o"tl 5 fil ;g e .gB ';;1 ~ l< ~ ., s - q - E. N' N 00 ~ .., 0\ 0\ 0\ ~ .., - N"'~ ~\O\O 00 00 00 oOc-SN 0\ .., .., 0\ 00 N ~ ,..., 0\ , - o r: I'-- - ....... N I'-- 0\ 00 "'" r ~ 00 00 .., """~ ~ 10 10 00 0\ 00 "'" N N - I'-- .., 0\ N N - I/') o I/') .., .., - ,..., ..,.." J - 10 Noo ~. ~. ....... ~ 5 .S ....... '" '" .... .... ~~ '" '" ,...,....~~ ... ~ .... ... ;g ~oo Q) () '5 '5 S-OI)lii 8 .13 ] ] ] .8 :g :g .2 ~ i'J i'J "tlt:Q~~ 5 ~ J ~ ~ .... ~ ~ ... o -g ~ 203 472 675 1,204 ~ ~ c C E I E ~ I ~ ~ E ~ ~ I ~ ! ~ ~ CITY OF ANDOVER Tax Increment Capital Project Fund Balance Sheet As of December 31,1990 (with Comparative Totals as of December 31, 1989) TIP Project 1-1 Account TIP Project 1-2 Account Totals 1990 1989 As:lets Cash and temporary investments (deficit) Receivables Accrued interest $ (3,334) $ 24,303 $ 20,969 $ 48,444 Total assets $ (3,131) $ 24,775 $ 21,644 $ 49,648 Liabilities and Fund Balance Liabilities Accounts payable Due to other gove=ental units Total liabilities $ 198 $ 107 305 - $ 198 $ 107 305 Fund balance (deficit) Unreserved Designated for capital projects Undesignated Total fund balance (deficit) Total liabilities and fund balance (deficit) 24,775 24,775 49,648 (3 ,436) (3 ,436) (3 ,436) 24,775 21,339 49,648 $ (3,131) $ 24,775 $ 21,644 $ 49,648 -61- - - ) I ~ j I ! I - I = I =1 -I I I I I I I I I I I I I CITY OF ANDOVER Tax Increment Capital Project Fund Statement of Revenue, Expenditures, and Changes in Fund Balance Year Ended December 31, 1990 (with Comparative Totals for Year Ended December 31, 1989) TIF TIF Project Proj ect 1-1 1-2 Totals Account Account 1990 1989 Revenue Other revenue Interest earned on investments $ 1,006 $ 2,587 $ 3,593 $ 2,031 Expenditures Capital outlay 23,477 2.425 25,902 57 , 822 Excess (deficiency) of revenue over expenditures (22,471) 162 (22,309) (55,791) Other financing uses Operating transfers (out) General Fund (6,000) (6,000) Excess (deficiency) of revenue over expenditures and other financing uses (22,471) (5,838) (28,309) (55,791) Fund balance (deficit) Beginning of year 19,035 30,613 49,648 105.439 End of year $ (3,436) $ 24,775 $ 21,339 $ 49,648 -62- ~ ~ > o o ~ ~ o >< !:: U ~ 0\ 00 0\ - ." <= :s ~ - '" '" ti ~1 'e' 0\ 9< ~ -ill -4$"':0 sO)"'.... .s....s::: \-I 0 t":S CI:l (1) {/l U Q;).oe .. -gO,)~ 5~ ~ s gj&lo~ lfj .... Q;) '" 0 > rJJ tf.)...... < <e .. 8' 8 '" Og P.. CI) 0;9 ! - '" ] o E-< ]Id 2 Q;) g <= > ..:88 :3 8'< ..... d ~g ~oooo'.:j= ~g~~ ~ p..~'o <=< e Q;) 0 ..... Cl)U d < g Q;)e gg.......- ooO\ud ~"8-eg i~ .~ 1 ~ ..... ~u = ~ <= Q;) t- 0 elrnOO'.z=-= ~"8~2g e~ a'5 ~ g 8' 00 g < ..... ~u <= < <= Q;) t- 0 8ooOO''=C:= ~"8~2g ~~ o~ ~ ~ e Q;) UO ..... CI) d ~ g 8 fI:I 00''::: = ~"8~2g 8~lfjt\8 p.. 00 <=< e Q;) 0 ..... Cl)U 0\ 00 0\ - o 0\ 0\ - '" Q) ., '" "l' , 10 ~ N 10 10. '" ~ 88' -'<I" r-: '" 10 10 '" r-: ~. - , O\_~ -- 0\0\ "':0 "'~ ~ ~ '" '" ~ '" 0\ 00 ...... .., ~ t- ~ ..; t- q. - , t- ' 10 "l - <'1 ~ '" o C'i t- - - - , 00 I '" 10 ~ ~ , , . ~ , , , ~ - '" 10. - 00 - , '<I" ' 0\ 10 N ~ C' o~ u ..: ~ '" d ~ ~ '" Q;) ~ o~ 2 ~ ~~ ~ t- - ~ ~ J J ~ J!l 1Il ~ ] {:. 8~ -10 cOo '<1"00 I I I V"'l '<I" t-. 00 <'1 - ~ 00_0\1O.-~'" C"-l\OV"'l,...c,...ct- 000010 0\<'1 r-S":oO 0'; -'" ~~ ~ t--O\ 1010'" "''''10 ...:...: 00" -'<I" I -100 -0\ 0\'<1" ON Irl - <'1'" ~ \08 <'11rl "':0 - '10 - . t- t- ~ - - ~ I I I I I I ~ I I I I I I ~ , I I I I I ~ I I I I I I ~ ~ '" ~ "8 &: ] '" Q;) .~ ~ o~ - i ;:l J!l 'g lfj ~ ~ Q;)~ ~ .~ - ..!a:E~~8~ ~~5b05E-< ~~~~() p.. p.. ~.<:l '" '" '" - d~1l01l ",g",,,.91:: o~ u d !:l II) <2l :~oOO=Q) :;::<U<OCl ~ ;:l -63- 5;.~ 00 t- t-OO 0\'" '" "'~ ~~ "'t- -Irl '<1"0\ N t-' ~ ..; 00 o - - , 10 00 ..; '<I" - - J!l g '[ j ] .0 'a 1 ~ ..e S' '" u ~ t.E]i'ti ;B ]~~s Q;) .. bO s1l ~O~ II) ~ o~ .rl ~ Q;) lfj = _lfjCl;:::J ,!l3 .,,;:::J & , , , , ~' '" ..; 00 - ;1 ~ ~ ~ D ~ I m I II I II ;j ~ !j ~ J I I I J I I ~j ~ I I C' ]~ lfj...... OJ:! 1l ;::::2 ~(U ~.,J:) ]] I I I I I 1 I 1 ~r -~r G' 00 '" ~=, '" '" .' ~ --'" '" 00 0 t'\Oo_ '" - ~ 00 00. "'-. '" l'-:. -> In'f'!''l_\I') '" 0 -- \t"l"vO\ ,.: ~ '" c"'~"'o\V"l r-- o. - ~ '" .'<1" ~,"'~ '" '" --0\('11 00 '" :B, 00 '" - - - ~~- 0 "', ) '" - - - '" - - '" - I - ~ ~ ., .... '3 FJ; - ~r -1 r:::- ~'~, ; N' " ~ '!! I :g ~;;1;g 'D '" "'''' 1 0-:. "', - or-- ... -'" MM[' :a - "'''' 00' -''D I 0 00 000 "'''''<I" ~ r--_ '" ",r-- ~ ~ '" '" "''D l'-:. 00 - ~ (''- "1.00 '" - - - - - '" .... ~ ~ - I . ... .. S - -, , G' 8' ~ - 'r -0 - 0\1000\ - :g .... 00 N '" r--_ - ]L "'.00 r-- r-- N "'. 00 '" ~ I ... 00'" '" 0 -:" C"'I"v $' ,.: "53 00 0'" 'D 00 ~ t- oo .. " > 8 '" 00 00 :::t- ~ C .se~ "0. ;:>5 ... I ... ~r '~ N' ~' 1 ~ 00 , ~ - '" '1 - c ~ 5 ;;!i '" '" ~ 00 '" - Ol- ~ 0 "', efn~'i$c N . .... - . S .... ~-g-28 - .... 0 '" I 8 - '" 00 00 "'!. eOIP~o ~ ~ .... " ~ o.r:r>.,.: ,,< ~ '" 5 ,,0 00 '" ... ."u .... r:r>. .... "" - I " ~r ""'" ~ , , , , ~ N' ~ '" '" 5 :;s -- 00 00 ~ "O~ t) "'''' 0 0 .... - "" .0 EUJOO'.zj!: :g; ... '" i i 0 ::s..... e """", g '" ... '<I" 00 ~ ~o 3 > ,,- 8 -- 0, 00 ., - OIl'" l;,r:r>.'8 ,,< .... I ~ .~;~o 5 ,,0 e..c:: '''S ... ."U .... JJ.l o.u- ;> _-c~] 0 .~ ;~tIJ ~r -, - 'D , , , , 'D ~, J 0 c fE s ... '<I" 00 00 "'''' 0. . 5 .... 00 "', '" 'D 'D 00'" I ~ ~e811 h~'~1 'D . '" '" ... ... "'-'D - .... - ....- 1I.. _ '" :>- NN fi::50l-l eo~~ 0 5""S,s o.r:r>.,.: ,,< ~ ~ 8."" ., 5 ,,0 ... ."u I ... .,~ c'3 .... u ., JJ.l 0 < .....1-< -gl1" .~ 5>'~ c <= ~r 0 'i ~ , , , . ~ ~~ J &li ! 00 ~~~~'g '" N Ol-'" I .,,~ it .; 'Ii 'D. ~~ .... 5 >c::...... 0 - '" '" o 0 e 0 ll~ g 5 U o.r:r>...: ,,< -5 5 ,,0 I ! ... ."u .... 1 ." c ~6 T 00 r 00 , , , , 00 1" ~ 0 ~ N $ I h~'~1 '" 'D .n- ",. 00' .... .... 'D eOll~ .... o.r:r>.,.: ,,< 5 ,,0 ... ... ."u I ........ .... "" ~ OIl o >-5 I e >; .S _"",00 0 ~"ll"" S 0.... """ .~~ s : ~ ..e " " ""~ Co " > .,,, 'l) 0 e fn ~tS ~ ::l " ::l "" ..s oS 5 " ll:i" 1;1') '"'0 U) CfJ t:::]~e~ ~ "::l '" -;- ]z-5 fn] ~ ~e is) CIS bJ)::l boO rl se :s.5~ ~ ::s:::,(,L."'O::se.;CI.l ~f.) 5'~ S 1 2. ,S 1I.. ..s" 3 1I.. I-< 0 ~ gfloo-g'o o!l ~eC: ., II "S'S 'S " 8. +-> ::s~-o- ; 8.; " " ~t; ~ ., rlllrl5 ll>!l::l l<e.s:i.s ....~ " EiFJ; FJ; e ~.~~ > g'~';:J 0 0 ~,,11 JJ.l ::s CfJ (/J ~ U) f.) 'E J: e ~ GQ JJ.l :;"~:... ~ O]""~ - ~~.~ I ll"'- 1;1') f_ ~_ O_'~ ".... ::l l .,511 ';:I OIl -!l -,~ ." !l,S ~~lf ., > .... '" S e OIl,~ 0Il&-'~ 5 "1:" .,0 '0 ~'.E ~'.a -3~"'O 8.S";/ "; c I:'S :i " c '" .... .- ""''''"'' ;""e;Ue;"'OU< <<s.5~ 0 " &" ::s..... .... .~ Potu .sSg, 8. Oi ~ll "" '" -5 "" ,,- ~ I 5VJO cu" ....r:r>.o 0 .or:r>.~ 8. ... " "" ~ ..c:: " ~ 0 ::l 1I.. -64- CITY OF ANDOVER C Proprietary Fund Type ~ Combining Balance Sheet I As of December 31,1990 (with Comparative Totals as of December 31, 1989) I Totals I Water Sewer 1990 1989 Assets I Current assets ~ Cash and temporary investments $ 227,005 $ 58,064 $ 285,069 $ 163,171 Receivables I i Accounts 41,093 96,616 137,709 120,699 i Accrued interest 2,889 2,889 2,841 Delinquent special assessments 2,265 2,265 I I Deferred ,special assessments 20,223 20,223 , ii ! Due from other governmental units 630 630 Inventory 5.385 5.385 5.460 I Total current assets 276,372 177,798 454,170 292,171 Property and equipment Furniture and equipment 57,126 18,385 75,511 22,110 I Machinery 524,515 524,515 524,515 Collection and distribution systems 5.253.191 9.517,723 14.770.914 14.417.209 5,834,832 9,536,108 15,370,940 14,963,834 I Less accumulated depreciation (615.027) 0.416,330) (2.031.357) 0.706.769) Net property and equipment 5.219.805 8.119,778 13.339.583 13.257.065 Total assets $ 5.496.177 $ 8.297 .576 $ 13.793.753 $ 13.549.236 I Liabilities and Fund Equity Current liabilities I Accounts payable $ 3,250 $ 13,699 $ 16,949 $ 5,119 Accrued expenses 5,622 3,664 9,286 9,546 I Due to other governmental units 277 16.141 16.418 37 .086 Total current liabilities 9,149 33,504 42,653 51,751 Fund equity I Contributed capital 5,172,534 8,108,172 13,280,706 13,244,907 Retained earnings Unreserved 314.494 155.900 470.394 252.578 I Total fund equity 5.487.028 8.264,072 13.751.100 13.497.485 Total liabilities and fund equity $ 5.496.177 $ 8.297.576 $ 13.793.753 $ 13.549.236 I I I -65- I -- =------ j I CITY OF ANDOVER I ; Proprietary Fund Type ~ I i ~ Combining Statement of Revenue, Expenses, and Changes in Retained Earnings Year Ended December 31, 1990 (with Comparative Totals for Year Ended December 31, 1989) ~ I 'i ! Totals Water Sewer 1990 1989 I Operating revenue - User charges $ 182,691 $ 326,242 $ 508,933 $ 374,008 Meters 26,185 26,185 29,710 - Permit fees 10,750 10,750 12,800 - I Penalties 5,081 7,364 12,445 13,601 - Other 1,737 1,737 268 Total operating revenue 226,444 333,606 560,050 430,387 - I - Operating expenses Personal services 64,948 30,890 95,838 82,941 Supplies 20,237 4,843 25,080 21,763 I Meters, etc. 21,662 21,662 25,164 Other services and charges 20,415 7,697 28,112 40,861 Disposal charges 212,665 212.665 180,181 I Total operating expenses 127 ,262 256,095 383,357 350,910 Operating income before depreciation 99,182 77,511 176,693 79,477 1 Depreciation 134,582 190,006 324,588 312,792 Operating loss (35,400) (112,495) (147,895) (233,315) I Other income (expense) Interest income 18,054 18,054 9,721 Interest expense (748) (748) Total other income (expense) 18,054 (748) 17,306 9,721 I Net loss (17,346) (113,243) (130,589) (223,594) I Other financing sources (uses) Operating transfers in Debt Service Funds 30,500 30,500 Operating transfers (out) I Debt Service Funds (7.246) Total other financing sources (uses) 30,500 30,500 (7,246) Add credit for depreciation on contributed assets 129.492 188.413 317.905 309.893 I Income closed to retained earnings 112,146 105,670 217,816 79,053 Retained earnings I Beginning of year 202,348 50,230 252.578 173,525 End of year $ 314.494 $ 155,900 $ 470,394 $ 252,578 I I I I -66- CITY OF ANDOVER Proprietary Fund Type Combining Statement of Cash Flows Year Ended December 31, 1990 Water Sewer Total Cash flows from operating a.ctivities Operating loss $ (35,400) $ (112,495) $ (147,895) Adjustments to reconcilE: operating loss to net cash provided by operating activities Depreciation 134,582 190,006 324,588 Change in assets and liabilities Receivables Accounts 7,208 (24,218) (17,010) Delinquent special assessments (2,265) (2,265) Deferred special assessments (20,223) (20,223) Due from olher governmental units (630) (630) Inventory 75 75 Accounts payable (354) 12,185 11,831 Accrued expenses (559) 238 (321) Due to other governmental units (607) (20.061) (20.668) Net cash provided by operating activities 104,945 22,537 127,482 Cash flows from capital and related financing activities Acquisition of capitall18sets (42,209) (11,193) (53,402) Cash flows from investing activities Interest income (expense) 17,616 (298) 17,318 Cash flows from noncapital financing activities Operating transfer from Debt Service Funds 30.500 30.500 Net increase in cash and temporary investments/cash equivalents 80,352 41,546 121,898 Cash and temporary investments/cash equivalents Beginning of year 146.653 16.518 163.171 End of year $ 227.005 $ 58.064 $ 285.069 Supplemental schedule of noncash investing, capital, and financing activities Assets contributed by other funds $ 159.517 $ 194.487 $ 353.704 -67- -- D I ~ I I I I I I I I I I I I I I I I ~ J I I J I i I i I ~ : 1 -I -I I I I I 1 1 1 I I I I 1 CITY OF ANDOVER Water Fund Comparative Balance Sheet As of December 31, 1990 and 1989 Assets Current assets Cash and temporary investments Receivables Accounts Accrued interest Inventory Total current assets Property and equipment Furniture and equipment Machinery Distribution system Less accumulated depreciation Net property and equipment Total assets Liabilities and Fund Equity Current liabilities Accounts payable Accrued expenses Due to other governmental units Total current liabilities Fund equity Contributed capital Retained earnings Unreserved Total fund equity Total liabilities and fund equity -68- 1990 $ 227,005 $ 41,093 2,889 5.385 276,372 $ 57,126 524,515 5.253.191 5,834,832 (615.027) 5.219.805 5.496.177 $ $ 3,250 $ 5,622 277 9,149 5,172,534 314.494 5.487 .028 $ 5.496.177 $ 1989 146,653 48,301 2,451 5.460 202,865 14,918 524,515 5.093.673 5,633,106 (480.445) 5.152.661 5.355.526 3,604 6,181 884 10,669 5,142,509 202.348 5.344.857 5.355.526 CITY OF ANDOVER Dr ~I Water Fund Statement of Revenue, Expenses, and Changes in Retained Earnings Years Ended December 31, 1990 and 1989 E 1990 1989 I Amount Percent Amount Percent Operating revenue I User charges $ 182,691 80.7 % $ 185,382 79.0 % Meters 26,185 11.6 29,710 12.7 Permit fees 10,750 4.7 12,800 5.5 E Penalties 5,081 2.2 6,454 2.7 Other 1,737 ~ 268 --:l Total operating revenue 226,444 100.0 234,614 100.0 I Operating expenses Personal services 64,948 28.7 53,318 22.7 Supplies 20,237 8.9 17,943 7.7 E Meters, etc. 21,662 9.6 25,164 10.7 Other services and charges 20,415 --2..,Q 35,713 15.2 Total operating expenses 127 ,262 56.2 132.138 56.3 I Operating income before depredation 99,182 43.8 102,476 43.7 m Depreciation 134,582 59.4 127 ,456 54.3 Operating loss (35,400) (15.6) (24,980) (10.6) E Other income I Interest income 18,054 ---2}l 8.447 ~ Net loss (17,346) -.i1J) % (16,533) -IT:Q) % m Other financing uses Operating transfer (out) I Debt Service Funds (3,393) Add credit for depreciation on contributed assets 129 ,492 125,599 I Income closed to retained earnings 112,146 105,673 Retained earnings I Beginning of year 202,348 96.675 End of year $ 314,494 $ 202,348 I E -69- I -.... ,..- '" 11 i 1 ; I ~ ~ I ~ I I -I 1 I I I I I 1 I I 1 I 1 CITY OF ANDOVER Water Fund Statement of Cash Flows Year Ended December 31, 1990 Cash flows from operating activities Operating loss Adjustments to reconcile operating loss to net cash provided by operating activities Depreciation Change in assets and liabilities Receivables Accounts Inventory Accounts payable Accrued expenses Due to other governmental units Net cash provided by operating activities Cash flows from capital and related financing activities Acquisition of capital assets Cash flows from investing activities Interest income Net increase in cash and temporary investments/cash equivalents Cash and temporary investments/cash equivalents Beginning of year End of year Supplemental schedule of noncash investing, capital, and financing activities Assets contributed by other funds -70- $ (35,400) 134,582 7,208 75 (354) (559) (607) 104,945 (42.209) 17.616 80,352 146.653 $ 227.005 $ 159.517 CITY OF ANDOVER ~l Sewer Fund ml Comparative Balance Sheet As of December 31, 1990 and 1989 ~! 1990 1989 Assets B Current assets I Cash and temporary investments $ 58,064 $ 16,518 Receivables Accounts 96,616 72,398 I Accrued interest 390 Delinquent special assessments 2,265 i Deferred special assessments 20,223 II Due from other governmental units 630 Total current assets 177,798 89,306 Property and equipment E Furniture and equipment 18,385 7,192 Collection system 9.517.723 9.323.536 I 9,536,108 9,330,728 Less accumulated depreciation (1.416.330) (1.226.324) Net property and equipment 8.119.778 8.104.404 ~ Total assets $ 8.297.576 $ 8.193.710 Liabilities and Fund Equity I Current liabilities Accounts payable $ 13,699 $ 1,514 I Accrued expenses 3,664 3,366 Due to other governmental units 16.141 36.202 Total current liabilities 33,504 41,082 E Fund equity Contributed capital 8,108,172 8,102,398 I Retained earnings Unreserved 155.900 50.230 Total fund equity 8.264.072 8.152.628 I Totalliabillties and fund equity $ 8.297.576 $ 8.193.710 I I m -71- E .... ~-~ - 'I CITY OF ANDOVER Sewer Fund J 1 Statement of Revenue, Expenses, and Changes in Retained Earnings Years Ended December 31, 1990 and 1989 'i 1 'I i II 1990 1989 - 1 Amount Percent Amount Percent Operating revenue User charges $ 326,242 97.8 % $ 188,626 96.3 % - Penalties 7,364 ---.U 7,147 3.7 - 1 Total operating revenue 333,606 100.0 195,773 100.0 - I Operating expenses Personal services 30,890 9.3 29,623 15.1 - Supplies 4,843 1.5 3,820 2.0 Other services and charges 7,697 2.3 5,148 2.6 -I Disposal charges 212,665 63.7 180,181 92.0 Total operating expenses 256,095 76.8 218,772 111.7 I Operating income (loss) before depreciation 77,511 23.2 (22,999) (11. 7) I Depreciation 190,006 56.9 185,336 94.7 Operating loss (112,495) (33.7) (208,335) (106.4) 1 Other income (expense) Interest income 1,274 .6 I Interest expense (748) ---il) Total other income (expense) (748) ---il) 1.274 .6 I Net loss (113,243) .ill.:.2) % (207,061) (105.8)% Other financing sources (uses) I Operating transfer in Debt Service Funds 30,500 Operating transfer (out) I Debt Service Funds (3,853) Total other financing sources (uses) 30,500 (3,853) I Add credit for depreciation on contributed assets 188,413 184,294 Income (loss) closed 1 to retained earnings 105,670 (26,620) Retained earnings 1 Beginning of year 50,230 76,850 End of year $ 155,900 $ 50.230 I 1 -72- CITY OF ANDOVER Sewer Fund Statement of Cash Flows Year Ended December 31, 1990 Cash flows from operating activities Operating loss Adjustments to reconcile operating loss to net cash provided by operating activities Depreciation Change in assets and liabilities Receivables Accounts Delinquent special assessments Deferred spl~ial assessments Due from other governmental units Accounts payable Accrued expensl~ Due to other governmental units Net cash provided by operating activities Cash flows from capital and related financing activities Acquisition of capital assets Cash flows from investing activities Interest expense Cash flows from noncapital financing activities Operating transfer from Debt Service Funds Net increase in cash and temporary investments/cash equivalents Cash and temporary investments/cash equivalents Beginning of year End of year Supplemental schedule of noncash investing, capital, and fmancing activities Assets contributed by other funds -73- - D ~ E $ (112,495) E 190,006 E (24,218) m! (2,265) i , (20,223) II (630) 12,185 I 238 II (20.061) 22,537 (11.193) I (298) ; 30.500 E 41,546 I 16.518 I $ 58.064 I $ 194,187 I I I E I ~ )1 J 1 I I ~ I ~ 1 -I 1 I 1 1 I 1 I I I I I I I CITY OF ANDOVER Fiduciary Funds Combining Balance Sheet As of December 31, 1990 (with Comparative Totals as of December 31, 1989) Expendable Agency Trust Fund Fund Totals Administrative Escrow Trust Fund Fund .1990 1989 Assets Cash and temporary investments $ 282,965 $ 504,260 $ 787,225 $ 1,065,093 Receivables Accrued interest 6,615 6,615 25,844 Total assets $ 289 .580 $ 504,260 $ 793,840 $ 1.090,937 Liabilities and Fund Balance Liabilities Accounts payable $ $ 13 $ 13 $ 296 Deposits payable 504,247 504,247 676.264 Total liabilities 504,260 504,260 676,560 Fund balance Unreserved Undesignated 289 .580 289,580 414,377 Total liabilities and fund balance $ 289 .580 $ 504,260 $ 793.840 $ 1,090,937 -74- CITY OF ANDOVER Expendable Trust Fund Administrative Trust Fund Statement of Revenue, Expenditures, and Changes in Fund Balance Years Ended December 31, 1990 and 1989 1990 Revenue Other revenue Interest earned on investments $ 38,475 $ Other financing sources (uses) Operating transfers in Capital Project Funds Operating transfers (out) General Fund Total other financing sources (uses) 19,046 (182.318) (163.272) Excess (d(:ficiency) of revenue and other financing sources over expen- ditures arld other financing uses (124,797) Fund balance Beginning of year 414.377 $ 289 .580 $ End of year -75- --... 1989 I ~! E1 E E E e~ if~ II ! ; E m E ; I I I I E I E I 33,495 35,512 (70.545) (35.033) (1,538) 415.915 414.377 ) 1 ,! ~ 1 I 1 i 1 -I =1 -I I 1 1 I I 1 I I 1 1 I I CITY OF ANDOVER, MINNESOTA Expendable Trust Fund Escrow Fund Statement of Changes in Assets and Liabilities Year Ended December 31, 1990 Balance J anuarv 1 Additions Deductions Assets Cash and temporary investments Receivables Accrued interest $ 659,173 $ 222,056 17.387 $ 676,560 $ 222,056 Total assets Liabilities Accounts payable Deposits payable $ 296 $ 676.264 13 222.043 Total liabilities $ 676,560 $ 222.056 -76- $ 376,969 17.387 $ 394.356 $ 296 394,060 $ 394,356 Balance December 31 $ 504,260 $ 504,260 $ 13 504.247 $ 504.260 cl ~I E E I , E ' EI ! EI Ii D ; I E E I I I E I '11'"-""" IT A il ! .. J I ill 'I J 1 ! 1 i 1 ~I ;1 :1 1 I I I I 1 1 I I I STATISTICAL SECTION (UNAUDITED) fil tj Cl Z < 1:; >< t: u cl) u .... is rI) :>-. !Xl cl) 8 cl) ~ ~ "8 &: t;! ~ 5 o ...-..... cl) ~ 8 8~ ~ "O~ ia .- "'~ cl) .... = 0 ~~ ~ ~ b.O "'-4 .~ t<l.s:: t: ..<:: cl) U rI) t;! j cl) = 8 ~ cl) > ~ ~~ ~ 1:1 ..... ~ ~ VJ "'d .- 5 ia E .~ d) ...:l p... t;!:>-' ~t~ = c:>..t..... cl)8'-' Op... t;! t<l ~ cl) ~>< t;! .... o Eo< <"l V'l - o r- \O~ - ~ o 00 \0 ~ 00 ~ 0\ "<t o vi "<t ~ ~ "<t~ - <"l ~ \0 "<t C'l~ 0\ V'l V'l ~ V'l V'l V'l Ili <"l C'l ~ 0\ l'- V'l _ - V'l C'l~ 0 C'l~ ('t') oN ~ - - - r- r- 0\ ~ 00 0\ 0 00 00 0\ 0\ 0\ 0\ - - - ~- D ; r--. C'l ~~ ~~ 'o:I~ <"l _. <"l 0/:) 0\.... -. - E, I II I 0' C) o~ <'~ 1"'- o ~ o r- E~ E~ I I E' "'~ ~. \l~~ ~. 111 o V'l \0 t ~t" II') t-. 00 II') C'l \0 ~ V'l r- E c::> c'l c,:- ", If) 10 C'l C'l r- \O~ - \0 ~ ~ I ,.... 1>0 I=>. '" In N <"l 0\ r- C'l~ - C'l E I I I ~ E -77- I - - I J \0 0\ 8 ~ r- "<t C'l~ <'l 00 .. I t;! - g 0\ - .... "<t C'l ~ ~ r-. o~ ..... - C'l C'l I ~ - ~ as g r- 0\ I 0\ 00 - 'c;j C'l r- V'> . u \0. r-~ 0\ - .9 <"l 0\ C'l t;! - - = I 0 ~ - I .... .~ 5 0\ 00 = = C'l 8 0 "<t~ Sa> - I ~ ~ ~ Cl I = C'l ~ .9 om - ..... "1. ~ "0 0 0\ = 1cl C'l <"l &: I ~ ~ fil :>-. .0 > ~ 0 "0 = "<t - 0\ .... r- r- ~. I Cl .a ; .g V'> "1. Z ] ~~ o~ 00 - < "<t ..... \0 ~ ~ t<l u C'l C'l C'l 0 ~ p...~ ~ I ~ 11 u &: = 0 00 00 0 <"l V'> \0 t;! .~ 0 \O~ ..... I ~ .... N 00 O\~ .~ - ..... C'l Co:) rI) ~ I 00 V'> \0 r- r- "<t u '" ~ C'l 0 .- ~ \0. r: ..... .... <"l ~~ <"l 0\ 0 <"l C'l <"l I ~ 0 V'> "<t I - - - "~ r- "<t 0\ Ili g "<t~ :O~ 0\ V'> ~ci3 "<t r- r- I ~ ~ V'> ..... 00 r- C'l r- I t;! r-~ V'> r-~ ~ ~ - V'>~ <"l C'l $ 0\ 5 ~ V'> V'> Co:)~ I Co:) ~ t;! t<ll 00 0\ 0 u cl) 00 00 0\ I J:>< 0\ 0\ 0\ - - - -78- CITY OF ANDOVER f. Tax Levies and Collections Percentage O Collection Percentage Collection of Total . Current of Levy of Prior Total Collections Year Total Lew ear's Levy Collected Years' Levy Collections to Lew 1983 $ 570,009 $ 548,667 96.26 $ 18,286 $ 566,953 99.46 1984 645,466 621,184 96.23 16,627 637,811 98.81 1985 689,698 671,021 97.29 11,222 682,243 98.92 I 1986 802,877 784,514 97.71 18,558 803,072 100.02 1987 880,048 862,018 97.95 19,185 881,203 100.13 1988 995,590 978,595 98.29 16,832 995,427 99.98 1989 1,006,409 987,289 98.10 13,439 1,000,728 99.44 1990 993,164 967,055 97.37 22,178 989,233 99.60 Special Assessment Levies and Collections Percentage Collection Percentage Collection of Total of Current of Levy of Prior Total Collections Year Total Lew ' Fear's Levy Collected Years' Levy Collections to Lew 1983 $ 724,655 $ 634,003 87.49 $ 77,505 $ 711,508 98.19 1984 673,732 583,244 86.57 60,445 643,689 95.54 1985 725,828 660,741 91.03 70,394 731,135 100.73 1986 700,636 662,322 94.53 84,548 746,870 106.60 I { 1987 989,102 903,856 91.38 28,728 932,584 94.29 1988 1,205,379 1,091,675 90.57 83,419 1,175,094 97.49 1989 1,178,982 1,097,880 93.12 57,987 1,155,867 98.04 1990 1,620,500 1,509,902 93.18 210,132 1,720,034 106.14 -79- "" II I ! I i I : I -I -I I I I I I I I I I I I I CITY OF ANDOVER Computation of Legal Debt Margin December 31, 1990 Market value of taxable property Debt limit (2.00% of market value) Amount of debt applicable to debt limit Total bonded debt Less Special Assessment Improvement Bonds Tax Increment Bonds State-Aid Street Bonds Net Debt Applicable to Debt Limit Legal Debt Margin -80- $ 23,466,000 21,806,000 1,050,000 610.000 $ 407,805.500 8,156,110 $ 8,156,110 CITY OF ANDOVER Computation of Legal Debt Margin (continued) December 31, 1990 Limit on Net Debt M.S.A. Section 475.53 "Subdivision 1. Generally. Except as otherwise provided in Section 475.51 no municipality, except a school district or a city of first class, shall incur or be subject to a net debt in excess of 2.00% of the taxable market value. " Definitions M.S.A. Section 475.51 "Subdivision 4. 'Net Debt' means the amount remaining after deducting from its gross debt the amount of current revenues which are applicable within the current fiscal year to the payment of any debt, and the aggregate of the principal of the following: (1) Obligations issued for improvements which are payable wholly or partly from the proceeds of special assessments levied upon property specially benefitted thereby, including those which are general obligations of the municipality issuing them, if the municipality is entitled to reimbursement in whole or in part from the proceeds of the special assessments. (2) Warrants or orders having no definite or fixed maturity. (3) Obligations payable wholly from the income from revenue-producing conveniences. (4) Obligations issued to create or maintain a Permanent Improvement Revolving Fund. (5) Obligations issued for the acquisition and betterment of public water-works systems, and public lighting, heating or power systems, and of any combination thereof or for any other public convenience from which a revenue is or may be derived. (6) Not applicable. (7) Amount of all money and the face value of all securities held as a sinking fund for the extinguishment of obligations other than those deductible under this subdivision. (8) All other obligations which under the provision of the law authorizing their issuance are not to be included in computing the net debt of the municipality. " -81- -~ C I ~ I I ~ ~.I ill I EI , ; ;! ~ I I I I i I ~ ~ I I m I E I E ~ II 1 I i I ~ I -I I I I I I I I I I I I I I I CITY OF ANDOVER Schedule of Sources and Uses of Public Funds For Tax Increment Financing District No. 1-1 Inception to December 31, 1990 Accounted Original for in Current Amount Budget Prior Years Year Remaining Sources of funds Tax increments $ 8,064,943 $ 218,838 $ 259,717 $ 7,586,388 State credits 56,397 869 (57,266) Bond proceeds 4,715,000 205,000 4,510,000 Land sales 101,501 5,000 (106,501) Interest 97.470 19,056 25 .565 52,849 Total sources of funds 12,877 ,413 600,792 291,151 11,985,470 Uses of funds Capital outlay 5,200,000 229,639 23,477 4,946,884 Administrative costs and other 264,000 11,101 252,899 Debt service Principal 4,810,000 205,000 4,605,000 Interest and other costs 3,640,686 41,648 18,061 3.580,977 Total uses of funds 13,914,686 282.388 246.538 13,385.760 District balance (deficit) $ (1.037 ,273) $ 318.404 $ 44.613 $ (1.400,290) SUPPLEMENTAL INFORMATION Name of District Tax Increment District - Development District No. 1-1 Type of District and Authorizing Statutes Redevelopment District established in 1986 under Section 472 of Minnesota Statutes for a duration of 25 years from receipt of first increment. Financing Total bonds issued General Obligation Tax Increment Bonds Series 1987B $ 205,000 Outstanding Bonds at December 31, 1990 $ -82- CITY OF ANDOVER Schedule of Sources and Uses of Public Funds For Tax Increment Financing District No. 1-2 Inception to December 31, 1990 Accounted Original for in Current Amount Budget Prior Years Year Remaining Sources of funds Tax increments $ 2,200,361 $ 188,833 $ 189,347 $ 1,822,181 Bond proceeds 1,004,500 1,044,126 (39,626) Land sales 7,959 (7,959) Interest 4,500 34,146 29,268 (58,914) Miscellaneous 23 , 877 (23,877) Total sources of funds 3,209,361 1,275,064 242,492 1,691,805 Uses of funds Capital outlay 1,010,375 814,479 2,425 193,471 Administrative costs and other 95,905 29,822 66,083 Debt service Principal 1,025,000 15,000 1,010,000 Interest and other costs 1,029,018 232,824 101,313 694,881 Total uses of funds 3,160.298 1,077,125 118,738 1,964.435 District balance 49,063 197,939 123,754 (272,630) Transfers to other funds (6,000) 6,000 Remaining funds $ 49,063 $ 197 ,939 $ 117,754 $ (266,630) SUPPLEMENTAL INFORMATION Name of District Tax Increment District - Development District No. 1-2 Type of District and Authorizing Statutes Redevelopment District established in 1986 under Section 472 of Minnesota Statutes for a duration of 25 years from receipt of first increment. Financing Total bonds issued General Obligation Tax Increment Bonds Series 1987 A $ 1,065,000 Outstanding Bonds at December 31, 1990 $ 1,050,000 -83- ~aiII~ ~ ~ E I It II ! E ~ ; D C E I I I E I ~ I ! I I I i I I I i I il ~I ;1 ,I 'I I I I I I I I I I SINGLE AUDIT AND OTHER REOUIRED REPORTS C I ~! I I I ~I ~I ~I I II ~ D I ~ E I I I I I - " J I I I I I j J I jj I ~ i I -I I I I I I I I I I I I I PANNELL KERR FORSTER Certified Public Accountants INDEPENDENT AUDITOR'S REPORT 400 Park National Bank Building 5353 Wayzata Boulevard Minneapolis, MN 55416 Telephone (612) 545-0421 Telefax 612-545-0569 ON SCHEDULE OF FEDERAL FINANCIAL ASSISTANCE City Council and Residents City of Andover Andover, Minnesota We have audited the general purpose financial statements of the City of Andover, Minnesota, for the year ended December 31, 1990, and have issued our report thereon dated March 22, 1991. These general purpose financial statements are the responsibility of the City's management. Our responsibility is to express an opinion on these general purpose financial statements based on our audit. We conducted our audit in accordance with generally accepted auditing standards and Government Auditing Standards, issued by the Comptroller General of the Untied States. Those standards require that we plan and perform the audit to obtain reasonable assurance about whether the general purpose financial statements are free of material misstatement. An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the general purpose financial statements. An audit also includes assessing the accounting principles used and significant estimates made by management, as well as evaluating the overall general purpose financial statement presentation. We believe that our audit provides a reasonable basis for our opinion. Our audit was made for the purpose of forming an opinion on the general purpose financial statements taken as a whole. The accompanying Schedule of Federal Financial Assistance is presented for purposes of additional analysis and is not a required part of the general purpose financial statements of the City of Andover. The information in this schedule has been subjected to the auditing procedures applied in the audit of the general purpose financial statements and, in our opinion, is fairly stated in all material respects in relation to the general purpose financial statements taken as a whole. o~ ~ k~i:0 March 22, 1991 -84- I C E ~. ~ ~ ~ II ~I I II ! ~ ~ I ~ I I I I I I ~~-..t ~~ -' ~ I - - I = I - I -I -I I I I I I I I I I I I I I CITY OF ANDOVER Schedule of Federal Financial Assistance Year Ended December 31, 1990 Federal CFDA Federal GrantorlPass-Through GrantorlProgram Title Number U.S. Department of Housing and Urban Development Passed through Anoka County Community Development Block Grant 14.218 Federal Grant Amount Current Year Activity Revenue State and Federal Local Expenditures $ 104,341 $ 61,096 $ 204 $ 61,300 Note 1: Federal grant amount includes any carryover from previous grant year entitlements as well as any program revenue earned that increases the funds available. Note 2: Community Development Block Grant revenues and expenditures on the City's financial statements reflect the effects of adjustments to prior years' accruals. -85- C E I I I I II ! EI II ~ I I E I I I I E E - ~ ] I j I ! I . I - I -I -I I I I I I I I I I I I I PANNELL KERR FORSTER Certified Public Accountants 400 Park National Bank Building 5353 Wayzata Boulevard Minneapolis. MN 55416 Telephone (612) 545-0421 Telefax 612-545-0569 INDEPENDENT AUDITOR'S SINGLE AUDIT COMBINED REPORT ON INTERNAL CONTROL STRUCTURE City Council and Residents City of Andover Andover, Minnesota We have audited the general purpose financial statements of the City of Andover, Minnesota, as of and for the year ended December 31, 1990, and have issued our report thereon dated March 22, 1991. We conducted our audit in accordance with generally accepted auditing standards; Government Auditing Standards, issued by the Comptroller General of the United States; and Office of Management and Budget (OMB) Circular A-128, Audits of State and Local Governments. Those standards and OMB Circular A-128 require that we plan and perform the audit to obtain reasonable assurance about whether the general purpose financial statements are free of material misstatement. In planning and performing our audit for the year ended December 31, 1990, we considered the City of Andover's internal control structure in order to determine our auditing procedures for the purpose of expressing our opinion on the general purpose financial statements and not to provide assurance on the internal control structure. The management of the City of Andover is responsible for establishing and maintaining an internal control structure. In fulfilling this responsibility, estimates and judgements by management are required to assess the expected benefits and related costs of internal control structure policies and procedures. The objectives of an internal control structure are to provide management with reasonable, but not absolute, assurance that assets are safeguarded against loss from unauthorized use or disposition, and that transactions are executed in accordance with management's authorization and recorded properly to permit the preparation of general purpose financial statements in accordance with generally accepted accounting principles, and that federal financial assistance programs are managed in compliance with applicable laws and regulations. Because of inherent limitations in any internal control structure, errors, irregularities, or instances of noncompliance may nevertheless occur and not be detected. Also, projection of any evaluation of the structure to future periods is subject to the risk that procedures may become inadequate because of changes in conditions or that the effectiveness of the design and operation of policies and procedures may deteriorate. (continued) -86- C' E ~ I I I II I ml II E E I E I I I I I E -==- -.. 1 I ~ I . I = I I I I I I I I I I I I I I I I For the purpose of this report, we have classified the significant internal control structure policies and procedures in the following categories: cash receipts/revenue, cash disbursements/expenditures, payroll, external financial reporting, and grant administration. For all of the internal control structure categories listed above, we obtained an understanding of the design of relevant policies and procedures and determined whether they have been placed in operation, and we assessed control risk. During the year ended December 31, 1990, the City of Andover had no major federal financial assistance programs and expended 100% of its total federal financial assistance under the following nonmajor federal financial assistance program; Community Development Block Grant. We performed tests of controls, as required by OMB Circular A-128, to evaluate the effectiveness of the design and operation of internal control structure policies and procedures that we have considered relevant to preventing or detecting material noncompliance with specific requirements, general requirements, and requirements governing claims for advances or reimbursements and amounts claimed or used for matching that are applicable to the aforementioned nonmajor programs. Our procedures were less in scope than would be necessary to render an opinion on these internal control structure policies and procedures. Accordingly, we do not express such an opinion. We noted certain matters involving the internal control structure and its operation that we consider to be reportable conditions under standards established by the American Institute of Certified Public Accountants. Reportable conditions involve matters coming to our attention relating to significant deficiencies in the design or operation of the internal control structure that, in our judgement, could adversely affect the City of Andover's ability to record, process, summarize, and report financial data consistent with the assertions of management in the general purpose financial statements or to administer federal financial assistance programs in accordance with applicable laws and regulations. Because of the limited size of your office staff, your organization has limited segregation of duties. A good system of internal accounting control contemplates an adequate segregation of duties so that no one individual handles a transaction from inception to completion. While we recognize that your organization is not large enough to permit an adequate segregation of duties in all respects, it is important that you be aware of this condition. A material weakness is a reportable condition in which the design or operation of one or more of the internal control structure elements does not reduce to a relatively low level the risk that errors or irregularities in amounts that would be material in relation to the general purpose financial statements being audited or that noncompliance with laws and regulations that would be material to a federal financial assistance program may occur and not be detected within a timely period by employees in the normal course of performing their assigned functions. Our consideration of the internal control structure would not necessarily disclose all matters in the internal control structure that might be reportable conditions and, accordingly, would not necessarily disclose all reportable conditions that are also considered to be material weaknesses as defined above. However, we believe that the reportable condition described above is a material weakness. This condition was considered in determining the nature, timing, and extent of the procedures to be performed in our audit of the City of Andover's general purpose financial statements and of its compliance with requirements applicable to its federal financial assistance programs for the year ended December 31, 1990, and this report does not affect our reports thereon dated March 22, 1991. (continued) -87- C f Ii ~ E E I I I I E I I I I I I I I I -- ~ 1 I - I ~ I = I -I I I I I I I I I I I I I I I In our letter to the City Council, issued in connection with our audit of the City's general purpose financial statements, we have separately communicated our observations and recommendations regarding other matters. This report is intended solely for the use of the City Council and management of the City of Andover, the cognizant audit agency, and other federal agencies and should not be used for any other purpose. This restriction is not intended to limit the distribution of this report which, upon acceptance by the City Council, is a matter of public record. Oo.-.ll ~ ~-t:> March 22, 1991 -88- c ml I E Ei II I II I ~1 I I ; I I I I I I I I - -- - I -I - I ~I -I I I I I I I I I I I I I I I PANNELL KERR FORSTER INDEPENDENT AUDITOR'S COMPLIANCE REPORT Certified Public Accountants BASED ON AN AUDIT OF THE GENERAL PURPOSE 400 Park National Bank Building 5353 Wayzata Boulevard Minneapolis, MN 55416 Telephone (612) 545-0421 Telefax 612-545-0569 FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS City Council and Residents City of Andover Andover, Minnesota We have audited the general purpose fmancial statements of the City of Andover, Minnesota, for the year ended December 31, 1990, and have issued our report thereon dated March 22, 1991. We conducted our audit in accordance with generally accepted auditing standards and 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 general purpose financial statements are free of material misstatement. Compliance with laws, regulations, contracts, and grants applicable to the City of Andover is the responsibility of the City's management. As part of obtaining reasonable assurance about whether the general purpose financial statements are free of material misstatement, we performed tests of the City's compliance with certain provisions of laws, regulations, contracts, and grants. However, our objective was not to provide an opinion on overall compliance with such provisions. The results of our tests indicate that, with respect to the items tested, the City of Andover complied, in all material respects, with the provisions referred to in the preceding paragraph. With respect to items not tested, nothing came to our attention that caused us to believe that the City had not complied, in all material respects, with those provisions. This report is intended solely for the use of the City Council and management of the City of Andover, the cognizant audit agency, and other federal agencies and should not be used for any other purpose. This restriction is not intended to limit the distribution of this report which, upon acceptance by the City Council, is a matter of public record. .p~ ~ ~~ March 22, 1991 -89- II I I II I I~ , I II ! II ! I! I I I I I I I I I I .... - --- - -~=--- _._~ -= - = . I . J - - I ~ - - - I = - I I - I I I I I I I I I I I I I I PANNELL KERR FORSTER Certified Public Accountants INDEPENDENT AUDITOR'S SINGLE AUDIT 400 Park National Bank Building 5353 Wayzata Boulevard Minneapolis. MN 55416 Telephone (612) 545-0421 Telefax 612-545-0569 REPORT ON COMPLIANCE WITH THE GENERAL REOUIREMENTS APPLICABLE TO FEDERAL FINANCIAL ASSISTANCE PROGRAMS City Council and Residents City of Andover Andover, Minnesota We have applied procedures to test the City of Andover, Minnesota's, compliance with the following requirements applicable to each of its federal financial assistance programs, which are identified in the Schedule of Federal Financial Assistance, for the year ended December 31, 1990: civil rights, cash management, real property management, and Drug-Free Workplace Act. Our procedures were limited to the applicable procedures described in the Office of Management and Budget's, Comoliance Suoolement for Single Audits of State and Local Governments. Our procedures were substantially less in scope than an audit, the objective of which is the expression of an opinion on the City of Andover's compliance with the requirements listed in the preceding paragraph. Accordingly, we do not express such an opinion. With respect to the items tested, the results of those procedures disclosed no material instances of noncompliance with the requirements listed in the first paragraph of this report, except as listed in the Schedule of Findings. With respect to items not tested, nothing came to our attention that caused us to believe that the City of Andover had not complied, in all material respects, with those requirements. This report is intended solely for the use of the City Council and management of the City of Andover, the cognizant audit agency, and other federal agencies and should not be used for any other purpose. This restriction is not intended to limit the distribution of this report which, upon acceptance by the City Council, is a matter of public record. O--.u. ~ k~ March 22, 1991 -90- C I ; I I I II I _I Ii E I I I I I I I I I ~-...,;I----.:1 - - - _._~= ~ I I -I -I I I I I I I I I I I I I I I I PANNELL KERR FORSTER Certified Public Accountants INDEPENDENT AUDITOR'S REPORT ON 400 Park National Bank Buildin9 5353 Wayzata Boulevard Minneapolis, MN 55416 Telephone (612) 545-0421 Telefax 612-545-0569 COMPLIANCE WITH SPECIFIC REOUIREMENTS APPLICABLE TO NONMAJOR RELATED FEDERAL FINANCIAL ASSISTANCE PROGRAM TRANSACTIONS City Council and Residents City of Andover Andover, Minnesota In connection with our audit of the general purpose financial statements of the City of Andover, Minnesota, and with our study and evaluation of the internal control systems used to administer federal financial assistance programs, as required by OMB Circular A-128, Audits of State and Local Governments, we selected certain transactions applicable to certain nonmajor federal financial assistance programs for the year ended December 31, 1990. As required by OMB Circular A-128, we have performed auditing procedures to test compliance with the requirements governing types of services allowed or unallowed, eligibility, and any other procedures that are applicable to those transactions. Our procedures were substantially less in scope than an audit, the objective of which is the expression of an opinion on the City's compliance with these requirements. Accordingly, we do not express such an opinion. With respect to the items tested, the results of those procedures disclosed no material instances of noncompliance with the requirements listed in the preceding paragraph. With respect to items not tested, nothing came to our attention that caused us to believe that the City had not complied, in all material respects, with those requirements. This report is intended solely for the use of the City Council and management of the City of Andover, the cognizant audit agency, and other federal agencies and should not be used for any other purpose. This restriction is not intended to limit the distribution of this report which, upon acceptance by the City Council, is a matter of public record. {Ja-Jt 4 ~~ March 22, 1991 -91- Ii Ii i &1, ~ I II I . i II ;1 I II E I I ; ~ I I E E E ; E v-_ - I - I -I 01 -I I I I I I I I I I I I I I I PANNELL KERR FORSTER Certified Public Accountants INDEPENDENT AUDITOR'S 400 Park National Bank Building 5353 Wayzata Boulevard Minneapolis. MN 55416 Telephone (612) 545-0421 Telefax 612-545-0569 REPORT ON COMPLIANCE WITH MINNESOTA STATE LAWS AND REGULATIONS City Council and Residents City of Andover Andover, Minnesota We have audited the general purpose financial statements of the City of Andover, Minnesota, for the year ended December 31, 1990, and have issued our report thereon dated March 22, 1991. Our audit was made in accordance with generally accepted auditing standards and the provisions of the Legal Compliance Audit Guide promulgated by the Legal Compliance Task Force pursuant to Minnesota Statutes Section 6.65. Accordingly, the audit included such tests of the accounting records and such other auditing procedures as we considered necessary in the circumstances. The Legal ComDliance Audit Guide covers five main categories of compliance to be tested: contracting and bidding, deposits and investments, conflicts of interest, public indebtedness, and claims and disbursements. Our study included all of the listed categories. The results of our tests indicate that for the items tested the City of Andover complied with the material terms and conditions of applicable legal provisions. Further, for the items not tested, based on our audit and the procedures referred to above, nothing came to our attention to indicate that the City had not complied with such legal provisions. This report is intended solely for the use of the City Council and management of the City of Andover, the cognizant audit agency, and other federal agencies and should not be used for any other purpose, This restriction is not intended to limit the distribution of this report which, upon acceptance by the City Council, is a matter of public record. p~~ ~~ March 22, 1991 -92- I Ci I ~' I Ii E I' I' , I I ml II i i ~I ; E ~ ~ ~ ~ I I E E E E ...~ - - I I ~ I I -I I I I I I I I I I I I I I I CITY OF ANDOVER Schedule of Findings Year Ended December 31, 1990 Program Current Year Findings Community Development Block Grant As of December 31, 1990, the City has not published a policy notifying employees that the City will provide a drug-free workplace. Further, the City has not established an ongoing drug-free awareness program for its employees. -93- Amount of Ouestioned Costs None I, ml I: Ii I E I ml i ~I I I EI I EI ~ ~ C ~ ~ ~ C C C ~ ....~ -