--- OCR page 1 of 77 --- OTTAWA COUNTY 2021-2022 ESTIMATE OF NEEDS AND FINANCIAL STATEMENT OF THE FISCAL YEAR 2020-2021 FILE, BOARD OF COUNTY COMMISSIONERS OF NOV Uy 20 THE COUNTY OF OTTAWA Stat 21 -_ STATE OF OKLAHOMA © Auditor &| iN, Sbector Two copies of this Financial Statement and Estimate of Needs should be filed with the County Clerk not later than August 17 for all Counties. After approval by the Excise Board and the levies are made, both statements should be signed by the appropriate Board Members. One complete signed copy must be sent to the State Auditor and Inspector, 2300 N. Lincoln Blvd., State Capital, Room 123, Oklahoma City, OK 73105. If publication may not be had by date required for filing, affidavit and proof of publication are required to be attached within five days after date of filing, THE 2021/2022 ESTIMATE OF NEEDS AND FINANCIAL STATEMENT OF THE, J FISCAL YEAR 2020-2021 PREPARED BY TURNER & ASSOCIATES, PLC ~ SUBMITTED TO THE OTTAWA COUNTY EXCISE BOARD THIS34\“*- DAY OF Os Nye 2021 0. OF COUNTY COMMISSIONERS Chairman L County Clerk 7 Wi Pree Ah ‘s y \t Commissioner _/4 ommissioner_ by ke Ly WV _ Z ZL a Oo Lede yD) . 7 . . Treasurer Otay Dbeces V) Assessor (RCIA Sap wet J 0 a ECE -n- \ SIVED Court Clerk| IV J) 4} Sherif! Zee Pat NOV 0.4 ayy ra ve S.A, and I. Form 2631R01 Entity: Ottawa County, 58 | Octaber OA, 2021 8nd Ing ; : lspectag S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 202 vA --- OCR page 2 of 77 --- Index Page Exhibit A County General 1 ' Exhibit B County Building 15 Exhibit D County Highway Unrestricted 23 Exhibit E Health 31 Total Exhibit G's 39 G-3001 County Sinking Fund 45 Total Exhibit I's 47 11103 County Bridge and Road Improvement 48 1-1204 Assessor Revolving Fee 49 1-1208 County Clerk Lien Fee 50 1-1209 County Clerk Records Management and Preservation SI 17-1212 Emergency Management $2 1-1218 Local Emergency Planning Committee 33 11220 Resale Property 54 1-1221 Reward Fund 55 1-1223 Sheriff Commissary 56 1-1225 Sheriff Forfeiture 57 11226 Sheriff Service Fee 58 1-1230 Treasurer Mortgage Certification 59 1-1235 County Donations 60 11401 Convenience Center Grant 61 1-1456 Bureau of Indian Affairs Stateline Road 62 1-1565 COVID Aid Relief 63 11566 American Rescue Plan Act 2021 64 Total Exhibit LLST's 65 L.ST-1305 Courthouse Improvement Sales Tax 66 L.ST-1313 Road and Bridges Sales Tax 67 LST-1321 Rural Fire Sales Tax 68 Total Exhibit M's 69 M-7201 Court Clerk Revolving 70 M-7202 Child Abuse (Multidisciplinary) Prevention 71 M-7205 Law Library 72 M-7206 Drug Court 7 M-7210 Court Clerk Preservation 74 M-7401 Individual Redemption 75 M-7408 Tax Refunds 76 M-7506 Emergency Transportation Revolving 11 M-7508 Change Fund 78 M-7605 Educational Trust 79 M-7702 Independent School Remit 80 M-7703 Municipal-City-Town Remit 81 M-7704 Emergency Medical Service District (EMS-522) Remit 82 M-7706 Career Tech Remit 83 Exhibit W 85 Exhibit X 87 Exhibit Y 89 Exhibit Z 93 Salary Calculations 95 S.A. and 1. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 3 of 77 --- OTTAWA COUNTY 2021-2022 — ESTIMATE OF NEEDS AND FINANCIAL STATEMENT OF THE, FISCAL YEAR 2020-2021 ~ OTTAWA COUNTY, STATE OF OKLAHOMA - [To the County Excise Board of said County and State, Greeting:- [Pursuant to the requirements of 68 O.S. 1991 Section 3002, we submit herewith for your consideration, the within statement of the fiscal condition of the County of Ottawa, State of Oklahoma, for the fiscal year r beginning July 1, 2020 and ending June 30, 2021, together with an itemized statement of the estimated needs |thereof for the fiscal year beginning July 1, 2021 and ending June 30, 2022. The same have been prepared in conformity to Statute, in relation to which be it further noted that: 11. We, the members of the Board of County Commissioners of said County and State, do hereby certify that the jstatements herein submitted show the true and correct conditions of the fiscal affairs of said County for the ~ fiscal year ending June 30, 2021, that said statements comprise a "full and accurate statement of the assessments, receipts and expenditures of the preceding year, made out in detail under separate heads" as required by 19 O.S. 1991 Section 345; that said preparation was had at an official session of said Board, begun eal Jon the first Monday in July, 2021 pursuant to the provisions of 68 O.S. 1991 Section 3002. 2. And we further certify that the estimates of the several amounts necessary for current expenses for the fiscal = lyear beginning July 1, 2021 and ending June 30, 2022 as shown under "Schedule 8" were prepared and filed with the Board of County Commissioners as of the first Monday in July 2021, that the same have been correctly entered, and that all estimates made are entered as certified by Department Heads for the respective purposes ee herein set out. We further certify that the sums requested for salaries of county officers and the deputies are jcalculated and based upon authority of salary statutes currently effective and applicable in this county. |3. We further certify that the estimated income from sources other than ad valorem tax, shown on "Schedule 4", ~ may reasonably be expected to be collected as a revenue during the ensuing fiscal year, and is-ngtin.excess of [the 90% of the amounts collected for the same sources during the fiscal year ending June, PEN ] 62) : > [Dated at the office of the County Clerk, at Miami, Oklahoma, if ) OUNTY)E brig day of -p-Latsee 2021. Hy) yu AS “sh 7 ~ ws Lan Tb on Midi sh 73 », Zz ounty Clerl 1 . Mihi —S ares Uti (dle Sfe_ W Ominisgioner— ‘ommissione| 5a AME fe) N\Ktetuy Orel Pocky > Seti = hae |) Assessor ourtClerk YO ‘a eri ta - | = U i Filed this 95 day of > cboyer 2021 Secretary and Clerk of Excise Board, Ottawa County, Oklahoma. " S.A. and I. Form 2631ROI Entity: Ottawa County, 58 October 04, 2021 aa | S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 4 of 77 --- eet - = Independent Accountant's Compilation Report a = Honorable Board of County Commissioners _ Ottawa County, Oklahoma Management is responsible for the accompanying 2020-2021 prescribed financial statements as of and for — the fiscal year ended June 30, 2021, and the 2021-2022 Estimate of Needs (SA&I form 2631R97) and the Publication Sheet (SA&I form 2631R97) for Ottawa County, included in accompanying prescribed form. We have performed a compilation engagement in accordance with Statements on Standards for - Accounting and Review Services promulgated by the Accounting and Review Services Committee of the AICPA. We did not audit or review the prescribed financial statements, estimate of needs and publication sheet nor were we required to perform any procedures to verify the accuracy or completeness of the = information provided by management. Accordingly, we do not express an opinion, a conclusion, nor provide any form of assurance on these prescribed financial statements. _ The prescribed financial statements, estimate of needs and publication sheets forms are presented in accordance with the requirements prescribed by the Office of the Oklahoma State Auditor and Inspector _— per 68 OS § 3003.B as defined by 68 OS § 3004-3011 and are not intended to be a complete presentation of the County's assets and liabilities. I This report is intended solely for the information and use of management of Ottawa County, Oklahoma, | -_ the Excise Board of Ottawa County Oklahoma and for filing with the State Auditor and Inspector and is not intended to be and should not be used by anyone other than these specific parties. | = = “THners Aseociates, PLE - - = | = — - - S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 \ - S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 5 of 77 --- = ————— AFFIDAVIT OF PUBLICATION STATE OF OKLAHOMA, COUNTY OF OTTAWA. Persgnally appeared before me, the w dersigned Notary Public, Lol C 4h. i d he he f County Clerk of the County and State aforesaid, who being first duly sworn according to law, deposes and says: That he/she complied with the law by having the financial statement for the fiscal year ending June 30, 2021, and the estimated needs and the estimated income from sources other than ad valorem taxes, for the fiscal year beginning July 1, 2021 and ending June 30, 2022 published in one issue of the Miami News Record a legally-qualified newspaper published - of general circulation, in said county (strike inapplicable phrase) a copy of which together with proof of a publication is herewith attached marked Exhibit "Z" and made a part of hereof. eal ¢ County Clerk fpur— r ' Subscribed and sworn to before me this_| ~ day or Novem) _. 2021. = ~ aul, Ol f AN) / 20 a Y¥ (otary Public tp P Ted, MyKCommistion Expires Sahar nisey, _ SIO MES SAY s2000888 YZ E = i Exp 01-20-2024; = ey , IN ae i = ~ *Rroroaties Gira OSE SS “TR ONS _ = S.A. and I. Form 2631ROI Entity: Ottawa County, 58 October 04, 2021 auf S.A. and I. Form 2631R01 Entity: Ottawa County, $8 October 04, 2021 --- OCR page 6 of 77 --- PUBLICATION SHEET - OTTAWA COUNTY, OKLAHOMA. * FINANCIAL STATEMENT OF THE VARIUS FUNDS "Oi THTVFISCAL YEAR ENDING JUNE 30, 2021, AND ESTIMATE OF NEEDS FOR THE FISCAL YEAR EN!)ING JUNE 30, 2022, OF THE GOVERNING BOARD OF OTEAWA COUNTY, OKLAHOMA. Exhibit "2" — Page $5 EEA lea Wen (OE Std (A a " sores | : ee 2 aE | REE So ei a [Tota SES —— res eS - RUNS TT I Sie RRO A A Ts | ans [sas] E A a EE (TOTAL LIABILITIES AND RESERVES —[s____797058.16 9000S S| | CASH FUND BALANCE (Detiety JUNES0, 2051] SS ssas7a08] Sagano $d - MASE GMT | fer} fFonmicarvexceoncounesz | | [POR FISCAL YEAR ENDING JUNE30,2022___ | i | | Reserves for inereston Warranis & Revahaon $= - [Total Required SOS SET EL SG 782 Bk NS EET RESET | TR anes ee $e ey el [Strath s_ era [——“Aialance to Ralve from Ad Valorem Tax [S98 15088) $ aos SY) - CERTIFICATE - GOVERNING BOARD STATE OF OKLAHOMA, COUNTY OF OTTAWA, ss: ‘We, the undersigned duly elected, qualified Governing Officers of Ottawa County, Oklahoma, do hereby certify that at's meeting ‘of the Governing Body of the said County, begun at the time provided by sw for Counties and pursuant to the provisions of - ‘68 O.S, 1991 Sec. 3002, the foregoing statement was prepared and is true and correct condition of the Financial Affairs of said ‘County 4s reflected by the record of the County Clerk and Treasurer, We frther certify that the forgoing estimate for cupgsGe Se ree subg 1.29) nnd 30,20, hom wer eye era. ‘conduct of the affir ofthe said County, thet the Estimate Incometo be derive fiom sources athe that ea valorein Mason Qh." sees nut scsi auhoried rato athe event derived fom the same sources ring te preceding SV Coun a Pe VERY) Thien tot Ppa Ws hal) _ Cone Sbseibed end sor s before me this 9 as ™ we Detelec an. a van ? OFFICIAL SEAL ANS, ~ ae iS MBE. (Published in Miami News Record October 29, 2021) £ tert LPXLE : ne * i i Ss eam _ S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 a --- OCR page 7 of 77 --- = COUNTY GENERAL COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 1 ESTIMATE OF NEEDS FOR 2021-2022 EXHIBIT A ro a | | [ASSETS EY |_tnvestments dS ™ [_TOTAL ASSETS dt 28956782 | |_ Reserve forlnterestonWanranis SS OOCOCCOCSCSCSdYS ™ ™ a | ™ REVENUE: ~ [TOTAL REVENUE dS 6706 835.99 | = | interest Paidon Warrants dS | Reserve for Interest on Warrants 0s ™ ™ [ADDITIONS ~— [Warrants Estopped, Cancelled or Converted C'S 6244'S TS 1,624.94 |Ad Valorem Tax Collections in Excess of Estimate 'S167,124.83 || T'S 167,124.83 | ~= [DEDUCTIONS Oe es re an — vm - = S.A. and L Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 r= --- OCR page 8 of 77 --- m Page 2 COUNTY GENERAL COVERING THE PERIOD 7/1/2020 TO 6/30/2021 = ESTIMATE OF NEEDS FOR 2021-2022 EXHIBIT A ES Schedule 4:Revenue | [2020-2021 Account Actually Amount Actually - a a [s = Ts 1, 695,091.05 [Ss 1.787,358.74S 92,267.69 | = [ss 3371.93 Ts 43,371.93 | [So 31,485.21 S31, 485.21 | —_ [ss secs 68.64] [ss 48,006.96 [Ss 13,742.69 S34 264.27) [S__ = WS 48,006.96 TS 1381133 S_(34,195.63)] PH00, Local Revenues [ss 5 803s9Ts6254.63]8 451.04 [sss soos 5.00 js _ js [sss 00.00 $100.00] | —s ee ee eee - [sss 25s.c0[s 255.00] [s_____-_]s__19978791| s__179,787.89 18.09} p20, State Revenues C™SC™S*dS — [sn [ss | - [ 9220 07C-UseTax ss ang 146.35 [8 661,112.50 § 242,966.15 | = [ss eases [s.299.94[s _ (125.74) [ss sets 7.61] [ss sigs 1.17782 [ss ~ |__ Total for StateRevenues Sid SCS~CSS*d [S__ 533,423.99 [$785,243.12 [$251,819.13 | [ss 20s20Ts soos 8.80] [9317 CARES Act dS ss ais z.01 [8 a3 701] -~ [SS 205 20S SSO S 4,445.81 | 9406Recoveries SC CdS SSCSCSCS~=*dCS Sas [8 saz | js = [sss sais 25.41 | [s_ = S20 161.00 TS 203,293.97 |S (7,867.03) a [ss js EE a |__ Total Miscellaneous CountyGeneral______——=«i«tS-_—=SsSsC~CS~SSC~*d J [ss [s_=_S3,923,046.82[$ _4,701,740.25 [8 778,693.43 | - S.A. and I. Form 2631R01 Entity: Ottawa County, 58 ‘October 04, 2021 --- OCR page 9 of 77 --- : COUNTY GENERAL COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 3 ‘iad ESTIMATE OF NEEDS FOR 2021-2022 EXHIBIT A Basis & Limit a Estimate Governing Board Excise Board [9001 Curent Tax S—~*d o> a ee eS S| | ~ |_Total for Interest, MortgageTax SS CdCCC~*d ™ [s__ ss be HES = [9123 Rebates 0003s ° [9127 Treasurer Fees ones [9129 Visual Inspection as) |__Total for Local Revenues dd i) [s_o3i3.9i fs 40:313.91 | 922007C-UseTax [s_isas[s 15.85] is_ fg 7 Ld [| __90.00e['s"is2.60[s 192.60] a a | [ts 192.60 TS 192.60| [ o.oofts ss = 7 a | [ds 21,161.00 [s_ 211,161.00] ™ rs — | ™ Sea haloes | ——_?} 4 = . - S.A. and I, Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 . --- OCR page 10 of 77 --- = COUNTY GENERAL COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 5 ESTIMATE OF NEEDS FOR 2021-2022 EXHIBIT A _ fessh Balance Reported to Excise Board June 30,2020 TS = YS _(1,244,556.36] | Cash Fund Balance TransferedQut ISS ™ [_Cash Fund Balance TransfemedIn CdS Ci. — |Ad Valorem Tax Apportioned CS i tzasce = [Miscellaneous Revenue (Schedule 4) C*dS 2, 839,52437 8 Sd [Cash Fund Balance Forward From Preceding Year C*dS sd 72S SY [Prior Expenditures Recovered 0 C*dS CSS Cid [OTALRECEIPTS CCS ag SIZES > linerestPaidThereon CISC CdS CCS ™ [Reserve for Warrants Outstanding SOG IGROSTS [Reserve forlntereston Warrants SSC ~ [Reserves FromSchedule8 CS 0S FTOTALLIABILITESANDRESERVE S07 098.6 1S a | SP | = [Warrants Outstanding June 30 of YearinCaption IS dS 60,75080][8 60,750.80] = (POTAL id 3,973,329.80|[ 8 103,608.22 [8 4,076,938.02 | |Warrants Converted toBondsorJudgements C'S SC Sd ™ [Warrants Cancelled dS «CdS Coals 0.62098 | [Warrants Estopped byStatute SC CdS Cs — [TOTAL WARRANTS OUTSTANDING JUNE 30,2021 IS 96,168.05 IS dS 96,168.05 [Schedule 7: 2020 Ad Valorem Tax Account id [2020 Net Valuation Cer. To County Excise Board S$ _162,089,858.00_———«*10240 Mills. | Amount | ~ [Tota Proceeds ofLevyasCertified SC 868,600.15]] [Additions: fs Deductions: iS = fReserveforProtestPending 0 J — [Net Balance 2020 Tax in Process of Collection TTS Cid / ‘Net Appropriations ‘Warrants Approved (i100 Total Salaries YS 2,953,353.00][§ 2.909.032.2718 «dS _—3,372,712.62] = [i200 Fringe Benefits S's SC CdS Cd [1300 TravelRelated S53, 6086e ls aa zsssiis——-~<is—s2.727.80] - S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 os --- OCR page 11 of 77 --- Page 6 COUNTY GENERAL COVERING THE PERIOD 7/1/2020 TO 6/30/2021 - ESTIMATE OF NEEDS FOR 2021-2022 EXHIBIT A - " JUNE, 30 2021 IDEPARTMENTS OF GOVERNMENT RGIS Warrants Balance a APPROPRIATED ACCOUNTS 6-30-2020 Since Lapsed Issued Appropriations Appropriations _ [si Se Se [S [sts [ssa [s Ss a CSS re SS ag SS a a eS | p30 vel SS Sd - Hos for Tressuree Sg [ss EN - [s—_-_[s fs a ee CT rr a - [istotravel fs sas sa fs [SSeS rae | Sia. a Ds wl sek ne er [S___"“iee[s aaa ts 300] 3 i el ee Ei | | aT « Se a oT [s___ ara ts so ss] - [tio Funtime salaries SS a ie eee EC ae ey eT SCY ES A Fe [ste [3 —__—as— J | tito Funtime salwies YS wi a ea ET a [Swot] en [3i0Tavel SY ae ee ee ee | [Ss [ssa ts 03 | - S.A. and |. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 12 of 77 --- COUNTY GENERAL COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 7 ES - r extern a STIMATE OF NEEDS FOR 2021-2022 r |______SCAL YEAR ENDING JUNE30, 2001] Hstan ¥eapoarooa Supplemental nee Anount Warrants a Bei pe Approved by aoa Appropriations ‘ssued nee Goveming | pscceBead Unencumbered Board r js Ts eo o0000 Ts aonooo Ts Js 7 [s_ = s 5,000.00 Ts 4,680.23 18 319.03 [$s 078] r \ ————}} co P | ES CS | r [ssi s 153280298 —‘s asa] [ss 5459.00 [$6459.08 ds [s__ = S160,236.01[S_158,78329 [8 _[s_19272| r [s__ 166.32 [$s 15640683 TS 15640683 [8 _—- ~‘[8 000 | [s_ = Ts 2,00000[s = ss 2.00000] r [ss 10,406.55 [8 ase [SS 5,842.83 | f [S_____ 166.32 [$168,813.38 [S 16097055[S____- 1S 7,842.83] [ss 00000 TS sass ~dYS 18. 40585 | r [s_ sg 15.000.00[s4.7a3.s8[s =~ 1021642] [s_ = s 12,840.00 [5 ss7878 [sere [$384.49] [ss 2,646.00 $2,645.08 8 = TS «(| [SS B00 66,90TST TS 6576-731 S 29,007.70 | r [s____5,000.00)] $ 28120112 Ts 269976388 «TS (1122474 [ss 6 as.00[s easnoofs- ~[s | js__1s,o00.00[ssias3.is[s4sa77a3[s5.i3000[seas.7al[s 3645315 [$36,453.15 | r [ss 564.00 [$420.00 Ss 144.00 [SS 339,677.27 |S SBS 5130.00 |S 12,214.46 | r js TS arasaaé[s 46791069 Ts TS _7,03047] [sg ss js ss 6459.00 [s 6aspoo[s Ss | [S277 [gs 5277s 292.03 [$1235.14 | cr [s_ae7.t7 [s 482927338 aa 6oL2 [SS (8,265.61 | [s___ 2,909.66 [sg 7s9ns2TS rises [s sd [s_oenasfs fs ss ss [ js sr rs0o[s77soso[s sis 775080|s 7.750.80]} [ss 3,020.00 [51,692.74 [$$ 132726 [S2.280.00 |S 2,280.00 | [sans [s 82168332 [S$ 8083606[S dS idg27 26 [5 13352023 |S 133,520.23] r [s_ 2,917.00) $ 17135228 [S$ as2ze[s SY [s_uizents 38703 138703[s Is .00 [s___ 23,793.53 [$48,793.53 [$s 3e,6i.o0[s toiesats | id [sg gs [sess 586.44 | $ sesaa [ss [s_____ 3,600.00 [$222,119.28 [$211,936.75 [S$ 1018253|S OOS 248,141.16 ]$ 248,141.16] r S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 16, 2021 r --- OCR page 13 of 77 --- Page 8 COUNTY GENERAL COVERING THE PERIOD 7/1/2020 TO 6/30/2021 7 ESTIMATE OF NEEDS FOR 2021-2022 EXHIBIT A — “| JUNE, 30 2021 \ DEPARTMENTS OF GOVERNMENT Reserves Balance at APPROPRIATED ACCOUNTS perets Lapsed Original Appropriations Appropriations 7 ‘S.A. and. Form 2631R01 Entity: Otawa County, 58 October 16, 2021 Page 10 COUNTY GENERAL COVERING THE PERIOD 7/1/2020 TO 6/30/2021 ESTIMATE OF NEEDS FOR 2021-2022 EXHIBITA 1 : JUNE, 30 2021 IDEPARTMENTS OF GOVERNMENT — Warrants Balance = 7 APPROPRIATED ACCOUNTS ae Since Lapsed Issued Appropriations Appropriations 7 [ss a ee | [210s Maintenance & Operation | [s___ 7072's asesas[s_ 2,081.97] RE aS es es [S___ 4,750.00 [$4750.00 [st Dept 2100, Excise Equalization . eS CC CS (A) [sss " [sss | 310 Cd [sss |s_3as.o0['s6s.00 [8 20,00] [s_ ts 7 ES Ce | | [s__385.00[S «S00 S 320.00 ° Ss sh hh [sss 7 a CS | | | 130Travet Sd [s_ a7 [ss a's 2991-73] |S @2323[sas6sats 36624] ES Ce | 7 [sist sas Ts rast stat sso] egg jept: 3600, E-91L Pn Pal tie satis ss [ss a i a EE Cs [Total for County Audit Budget] [{;-———-} 5 [S_____ 69,229.87] | 600, County Cemetery [ss 7 E1000 CS [See soe accouer Saas aS ae ee] | --- OCR page 14 of 77 --- COUNTY GENERAL COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 9 r ESTIMATE OF NEEDS FOR 2021-2022 EXHIBIT A r ot = y — : Adjustments at Issued Known to be Governin a r Appropriations Unencumbered Boerd 8 Excise Board | SA-andl Form 2631R01 Entity: Otawa County, 58 Saba 6 Ta COUNTY GENERAL COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 11 ESTIMATE OF NEEDS FOR 2021-2022 r EXHIBIT A |___ FISCAL YEAR 2021-2022 | Lapsed Needs r Supplemental Net Amount Warrants R Balance Estimated by | APProved by Adjustments ciao Issued eserves Known to be Governing County os Unencumbered Board Et [s___asoso[se7e76ai[s 87876318. [3 —~+ [sss 29oizsg ts 248020818 -_[ss,07080] r a a CS a [$__2,614,332.37 | $ 2,481,392.37 | r a ES £22) ESA d [s____ srs _18a786ts _—-_~—S 9984] [s__ 2307.66 [$ 14836647. 8 1ag3ena7[S SSC —*d r [s__o7sgfsgo234fs 1.792615 - _|s 19310] [Ts 200.00 's 109.328 dts ~~ | js @300.00[s 14,880.00[stoe7ists_—- ~[s 4207.85] [ss soooofs Ts ts 500.00 C [Sst t00.00 [$0048 Ts dS 95.72 | [s_= S 166,946.81 S 161,929.46 1S ~_|S 501735] r |S___ 50,000.00 $50,000.00 $2,494.46 TS S000 TS 47,455.54] [s___ 50,000.00 [$_50,000.00S 2,49446[S __50.00|S 47,455.54] [s 856433 [$129,064.52 S$ i290es2TS SC Cid r js sg 3000s Ts SSCs sd CY [ss 2973s soos dS 2941.73 | [ss 13,760.00[s 7937.13 [s_ 992348 4,830.53] [ss 4.000.005 1,800.00 ss 2,200.00] [SS r Ss [ss 22987 TS 18208 9BTS CdS 02089] [SS 229.87 TS 18.2088 TS = ~—«déS ~~, 020.89 | 7 [ss 0000 SSS 40000] cr [ss 9500.00 Saas [SS SC ee [s___ = Ss 950000 TS 9aasaaTSs~=«diSSC*~“‘*‘éa‘ S| = r --- OCR page 15 of 77 --- | a Fe [YS 32,017.64 28598 TS SAIS __3,234,825:72 | - [Schedule 8A: Report OfPrior Years Sales Tax Cd | S.A. and L Form 2631R01 Entity: Ottawa County, 58 October 16, 2021 Page 12 COUNTY GENERAL COVERING THE PERIOD 7/1/2020 TO 6/30/2021 ESTIMATE OF NEEDS FOR 2021-2022 7 EXHIBIT A al ot [DEPARTMENTS OF GOVERNMENT . ‘oi = Total Warrants Since inal Supplemental PPROPRIATED ACCOUNTS Sales | Reserve Teued | Lapsed Batancel Peron Tax ‘ . IMENTS of [ome er men 7 Sales Issued Appropriation | Adjustments Tax - | 1110 Ful time salaries ones ss | dows = [sts i [1310 Travel onoed ss Ts gon . |_o.covd| s 19,525.85 |s 9.39825 [s 10,127.60] [s__ 173,906.87 | $_(151,564.12)| 7 | 0.00% 610.09 |S 18659 |S 423.50 4 [Sub Tom ofexpenditures (000% [S 2S TES TOS ES | OC --- OCR page 16 of 77 --- rp m= COUNTY GENERAL COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 11 ESTIMATE OF NEEDS FOR 2021-2022 EXHIBITA : 7 sed Supplemental anaes Warrants = fees et Approved by ‘Adjustments or Issued oe Known to be Governing ee ~ Unencumbered Board [sano [sarees 8787631[8_ - [8 -_] a |s = s 29.s12.e8 Ts 24,992.08[s |S 5,020.80] [s— ss ss ™ [ss 193770 S 3786S S88 [S__ dS 193770 TS 3786S CdS C«8 BA ™ |s___ 2,397.66 [$ aaseaa7 [Ss aaeseaa7[s TS «SYS _—ts2,3t062 |S 152,310.62] |s_ 97.66) $902.34 [$7243 S80 | [gs 00.00 s 0932s S808 | ™ [s__(2,300.00)] $_t4.8e0.00[s to6721s[s «tS «4,207.85 | [s_ Os s00.00 [sss 500.00 | . [ss ri.00 [sa fs so] — [s__ = dS 166,946.81 516192946 TS dS 5017.35 [s_ 50,000.00 [$50,000.00 TS 2,494.46 [S$ 5000S 47,455.54] [s____50,000.00]$ 50,000.00 [S$ 2,4044e TS 50.00[S 47,455.54] = [s 8,564.33 ['s_129,06452[s t29,06852[$ TS [ss z0000 fs ts sono fs [ss zoos s000[s TS 2:941.73| ™ [sg 13,760.00 [37,937.13 [$992.34 [3 4,830.53 | [ss 4,000.00 [$1,800.00 [$= TS 2,200.00 = so oo a Ee = [ss 62,229.87 [518,208.98 TSS 44,020.89] [SS 62,229.87 [S$ 18,208.98] SS 44,020.89 | [8 og rr] a [SSS SC CS COO [ss 950000 TS 9.435425 SCS [sto TS 9a ts «dS CSB ~ — js Ss SSS dSC“‘C;SWCSSCUOCOC‘“CS‘SC”U' [S__ 886,783.82 [S$ 4,11,60954[S _2,306,688.57[S 34,438.22 |S _1,780,487.75)|S _ 5,228,022.88 = —S = SA and Form 2631R01 Entity: Ottawa County, 58 7 Cetober 04, 1031 = — --- OCR page 17 of 77 --- am — Page 12 "COUNTY GENERAL COVERING THE PERIOD 7/1/2020 TO 68072021 _ ESTIMATE OF NEEDS FOR 2021-2022 EXHIBIT A_ ‘ Schedule 8A: Report Of Prior Years SalesTa FISCAL YEAR ENDING JUNE 30, 2020 FY ENDING 302021 - hot DEPARTMENTS OF GOVERNMENT . se " Total Warrants Since Original ‘Supplemental APPROPRIATED ACCOUNTS Seles Reserve Issued _| Lapsed Balance Appropriation | Adjustments - «Tax FISCAL YEAR ENDING JUNE 30, 2020, FY ENDING JUNE, 30 2021 Kot DEPARTMENTS OF GOVERNMENT Total Warrants Since Original ‘Supplemental = APPROPRIATED ACCOUNTS Seles Issued | L*PS* Balance| criation Adjustments - . | Tax __| Dept: 8004, Sheriff-ST_ [| 110Bull time salaries antes ss see Ts 47,583.68 -_ | 1130ParcTime salaries “"ocoed's = Ts [ss _s.aesa7 | 1310Travel Sd | ooow[s = [sss Ts 4.80808 2005 Maintenance & Operation |_o.00%l[s 19,525.85 |'$ 9398.25 |$ 10,127.60||$ 298,191.62 |S 17458272 = 2020 Professional Services | ooomfs fs ts $_(23,018.60) | 4110Capital Outlay 00x s enon 00 1s aera. ['s 2,126.33 |[s "173,906.87 | $ (151,564.12 [_ £130 LesseRentals Icons si10.09 1s 14639 $91,890.66 |S" (26,831.01) [S_26,935.94 | $14,258.51 [$12,677.43 | $ 1,813,073.08 15 24,655.28 | - COUNTY GENERAL FUND SALES TAX ACCOUNT Sub-Total of Expenditures [0.00% JS 26,935.94 S_12,677.43 || $_1,813,073.08 $_ 24,655.28 | . = : = po ~« - -_ - —_ . — ~ = . — --- OCR page 18 of 77 --- iad | COUNTY GENERAL COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Pagel3 = ESTIMATE OF NEEDS FOR 2021-2022 EXHIBIT A . ———— ee eee ‘Schedule 8A: Report Of Prior Year's Sales Tax a FISCAL YEAR ENDING JUNE 30, 2021 FISCAL YEAR 2021-2022 Excess/Shortfall Total sant Warrants Collections over | Sales tax Interest || Estimated ST from Appropriations as Ne et Appropriations} issued Reserves | Lapsed Balance] p imate Schedule} Schedule 4 Schedule 4 “Approved by io 2 4 Excise Board FISCAL YEAR ENDING JUNE 30, 2021 | FISCAL YEAR 2021-2022] Excess/Shortfall Total i Warrants Collections over | Sales tax Interest ||Estimated ST from} Appropriations as ‘Net Ay ™ Ppropriations| Issued Reserves | Lapsed Balance] pnate Schedule| Schedule 4 Schedule 4 ‘Approved by __ 4 Excise Board [Dept: 8004, Sheriff ST S__1,082,050.66 | $1,081,42743[$" = [s623.23[$ «dS ~SSOSCSCSCS:~«*ziSS SSS~S*dzS _1,219,083.30 ~ |s__so.e7320|'s_sog7320[s [sts sds SS dis Ps $0,000.00 $ 4,898.08} _4s9g0g{s [ss [ss dS CCS $_325,22009|$ 143,589.83 |5 396442 Ts ss 200,000.00] ™ "|/S__139.729.68[$ 139,m9.68[s = [sss Ss ~«d 140,000.00 |s__-2zsea7s[s" is maams[s ts ss COC SS ZY S__ 65,099.65 |$_stsns |" ssoai[s 759 [$s dS dS © [S_1:837,728-36 | $ 1,666,641.23 [S_ 166,491.89 [S"459824[$ TS sd SCS ~—«dS —,675,904.73 ™ COUNTY GENERAL FUND SALES TAX ACCOUNT . S__1837,728.36 | $1,666,641.23 [$166,491.89 | $_459524[$ TS CdS CC ~S«d*S OTS BOLT | As837,728:36 | $1,666,641.23 | $166,491.89 |$_459524[$ [$=] = ESTIMATE OF NEEDS FOR THE 2021-2022 FISCAL YEAR Estimate of ‘Approved by ‘Needs by ‘County PURPOSE: _ _ 7 Govenring Board || _Excise Board Total of Unrestricted Expenses for the County General, Schedule 8 : hen Total of Restricted Sales Tax Expenses for the County General, Schedule 8A. | Pro rata share of County Assessor's Budget as determined by County Excise Board ‘GRAND TOTAL - County General Fund = = ~ = = =~ ~= ~= = --- OCR page 19 of 77 --- COUNTY HIGHWAY UNRESTRICTED COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 15 Pp ESTIMATE OF NEEDS FOR 2021-2022 EXHIBIT D. chedule 1, Current Balance Sheet - June 30, 2021 _ a | Cash Balance June 30, 2021 js rm [_TOTAL ASSETS STS [LIABILITIES AND RESERVES: $ 155,998.09 Reserve for Interest on Warrants is CY ™ Reserves From Schedule 8 TOTAL LIABILITIES AND RESERVES 3 211,885.59 ‘CASH FUND BALANCE JUNE 30, 2021 = TOTAL LIABILITIES, RESERVES AND CASH FUND BALANCE [Schedule 2, Revenue and Requirements for 2020-2021 = a | seu | ‘Adjusted Cash Balance June 30, 2020 $_1,661,312.66 | Cash Fund Balance Transferred From Prior Years $ 8,830.45 | S____2,476,116.66 | ™ OR ence |S cd) 146,259.17 REQUIREMENTS eee S$ 2,717,523;33 _ Reserves From Schedule 8 [ss {ss al ‘ADD: CASH FUND BALANCE AS PER BALANCE SHEET JUNE 30, 2021 S_1,372,848.94 TOTAL REQUIREMENTS AND CASH FUND BALANCE = = 7 = = = aa S.A. and I, Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 o= --- OCR page 20 of 77 --- ™ Page 16 COUNTY HIGHWAY UNRESTRICTED COVERING THE PERIOD 7/1/2020 TO 6/30/2021 — ESTIMATE OF NEEDS FOR 2021-2022 EXHIBIT D Actually Amount Actually = [_9007 Interest Certificates of Deposits SYS dS CIS. TS 1,819.85] = [ss SS «BIS TS 1,819.85] ES [ES TT [ss ssa Ts 146.81 | = [s_ ss 783,723.20 Ts 743,723.20 | [sg ss 432,913.53 [432,913.53 [sss 73s 97.83 | [sss 2070.38 [s _248,07038] a [ss ss 154,868.25 [8 154,868.25 | [Ss Ss 221,37634 [8 421,376.34 [so SS 23252,681.79 TS 2,252,681.79 | - [Ss 185,085.69 TS 185,085.05 | [ss TS 185,085.69 TS 185,085.69] ~ [s__ STs seas Ts 5,109.85 | [sss 7580.68 [3 47,580.68 [sss 3,028.80 Ts 3,028.80] [s_0 [ss 250.00 Ts 250.00] bos | 9415 Miscellaneous dS CCS” [s_ fs 500.00 [$500.00] [ss S86 5293318 5652933 [sss 2,476, 116.66 [8 2,476 116.66 | ” js is SY [ss Os [SS TS 2g ee TS 776 116 = [Grand Total of AN Revenues [ss | 8 2a7enieas Ts 2a7e16.66] = = = _ _ = - S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 October 04, 2021 ~ --- OCR page 21 of 77 --- = COUNTY HIGHWAY UNRESTRICTED COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 17 Pp ESTIMATE OF NEEDS FOR 2021-2022 EXHIBIT D Basis & Limit i Estimate Governing Board Excise Board L000] ss [ss Ne a es a | js [ss > [__ 0.00% ss | o.0or ss [0.003 ES sk sa [s_ ss GL Le eee ~ [ss | o.oo s Ss [ss > | 000s fs a a bal [| o.oordfs ts js ss |___o.0orgfs ts Po SS = [Grand Total of AN Revenues 0S . . . . . - - | S.A. and L. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 - --- OCR page 22 of 77 --- l _ COUNTY HIGHWAY UNRESTRICTED COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 19 | ESTIMATE OF NEEDS FOR 2021-2022 EXHIBIT D i (Cash Balance Reported to Excise Board June 30,2020 YS “dS *1568-258.10] |_Cash Fund Balance Transferred Out CdS 700345 7 [Cash Fund Balance Transferred In dS 0,803.92 8 Sources ofRevenue [9100fLocal Revenues IS SC > [9200]State Revenues SSCSCSC~«*idiS SCT SC |9300]Federal Revenues S085. 's | 9400[MiscellaneousRevenues IS 8620318 ™ | 9500 |Special Assessments CS SC WAll Other Revenues (Schedule) Sages [Cash Fund Balance Forward From Preceding Year TS 8804S IS [Prior Expenditures Recovered SC ™ [TOTALRECEIPTS CdS asa ~ linterest Paid Thereon [Reserve for Warrants Outstanding SIRO a RReserve forInterestonWarants SS FReserves From Schedule 5.80750] | [POTALLIABILITES ANDRESERVE S'S 2 885.59 PDEFICTS ol = [Warrants Outstanding June 30 of YearinCaption dS YS 322.9 34,252.94 POTAL WIS 2,717 523.33 [65,248.63 |[S____2,782,771.96| = [Warrants Converted to Bonds orJudgements SS [Warrants Cancelled 0 gs [Warrants Estoppedby Statute S'S 30.00[s 30.00] = [TOTAL WARRANTS OUTSTANDINGJUNE30,2021 SS 1S5.998.09][S «(IS _—_—*155,998.09 | nn = o— ‘Net wriations: ‘Warrants roved by [it00 Total Salaries YSN SOLISE IIS La7,2697]18 CdS —28,729.19| = [i200 Fringe Benefits tS Cd's is Sd [1300 Travel Related T'S 36,168.76 |S 31,551.82 [s 78s 3,895.86] my _-_ (#100 Toul Machinary & Equipment, Capital Outlay |[$___$67,543.32|[$____275,961.67|/$__—— iS 291,581.65] S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 23 of 77 --- = Page 20 COUNTY HIGHWAY UNRESTRICTED COVERING THE PERIOD 7/1/2020 TO 6/30/2021 +I ESTIMATE OF NEEDS FOR 2021-2022 i EXHIBIT D — ” DEPARTMENTS OF GOVERNMENT Reserves Warrants Balance peat PPROPRIATED ACCOUNTS. 6-30-2020 Since Lapsed Issued Appropriations Appropriations = Cr [astotravet SS = [s__ 24780|s __2arsots————id | 4110 Capital Quay i's 12,900.00 Ts 1390000] | a | [sao 1s 1070s] = a Cs [PrstoTeavet sas sas - |s_ 4aes0[s ausao[s———-—+t a Ce ee [S____4mars 1s asus Ts] es a Ce | [1310Tevet T's ano 's 28's sora Ts se | - ss Oe ss Falr eran >» [Ss] ~ sss oo HE sss ei EE a a | aa [_ Total Provision for Interest on Warrants YS §_— J [YS 84S 3095.69 [5 a] - = = = - S.A. and I Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 ~ --- OCR page 24 of 77 --- = nm COUNTY HIGHWAY UNRESTRICTED COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 21 ESTIMATE OF NEEDS FOR 2021-2022 EXHIBITD m sed Needs as Supplemental Lees Warrants Baas Estimated by | Approved by Adjustments on Issued Known to be Govemi County z Appropriations a1 Excise Board ™ Unencumbered Board |s_ 427.1742 [s_ 472,833.68 [$4403.51 [$ —- —~(S 8,730.17 5 [s__13,s00.00[$ 13,83187[s1i,saar[s |S 2,267.46] |s__ 125,000.00 [$s aaesrz ts ts «LS 144,837.72 [s__ 14,000.00 [$35,355.53 [8 2737896|$ SS - —|S__7,97657] aay [S___G17,151.05[S_1,348,420.44 [S$ 858,35620[S __19094|$ 489,873.30] [s__ 473,259.01 [$515,045.04 s 502,60557[$ —- —<( $8 1234947] a [s__ 10,217.32 [$ 100,000.00[$ siieaso[s sd 18,836.41] [S__ 65,957.35 [$68,954.72 [$67,329.48 [$ «dS _—*1625.24| = [S__728,839.18[$"1,171,82696]|$ 89212493 [S$ ___26,461.87|$ 253,240.16] [S___a68.eas2s[s sis2774[s505,62789[$ - —*(S 7,649.55] [s___t0,t30.74 [$11,707.33 [$10,675.15 1s 7608 $ 956.10 | ~ [s_ 3.21374, aseazsots [$s -S 85,848.52] |S____ 104,366.86 [$132,546.83 [$100,089.64 [$_- —<dLS 32,457.19 [s__ 311,905.49 [$311,905.49 | ~ [S_ 136,604.85 [$136,604.85 [$6807 I9 TS dS «8587S ™ [S__ 136,604.86 [$136,604.86 |S 60,624.89 |$ 24,000.00 § 81,979.97 - : HES LS EH eo Ee - ESTIMATE OF NEEDS FOR THE 2021-2022 FISCAL YEAR Estimate of || Approved by a a a — PURPOSE: Govenring Board ||__ Excise Board EE _ = o S.A. and I. Form 2631RO1 Entity: Ottawa County, $8 October 04, 2021 a --- OCR page 25 of 77 --- HEALTH COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 23 iad ESTIMATE OF NEEDS FOR 2021-2022 EXHIBIT E ichedule 1, Current Balance Sheet - June 30, 2021 Cash Balance June 30, 2021 $ 395,305.84 ad [_TOTAL ASSETS CdS 395,305.84 BILITIES AND RESERVES: $ 19,278.85 [ss ™ 3 29,365.46 TOTAL LIABILITIES AND RESERVES $ 48,644.31 = TOTAL LIABILITIES, RESERVES AND CASH FUND BALANCE $ 395,305.84 ichedule 2, Revenue and Requirements for 2020-2021 a | soa) PREVENT _] ‘Adjusted Cash Balance June 30, 2020 ‘All Ad Valorem Tax Apportioned a |__TOTAL REVENUE CC*dCS S83 = Claims Paid by Warrants Issued. [$155,312.86 | $ 29,365.46 js | [fs seal ADD: CASH FUND BALANCE AS PER BALANCE SHEET JUNE 30, 2021 $ 346,661.53 TOTAL REQUIREMENTS AND CASH FUND BALANCE. [s 531,339.85 | = Schedule 3, Cash Fund Balance Analysis - June 30, 2021 __ ADT ONS Eee $ 8,798.70 = $ 906.66 ” $ 280,059.68 = $ 607,028.53 [DEDUCTIONS eee” $ 5,391.20 [ss eal 'OTAL DEDUCTIONS. hh Fund Balance as per Balance Sheet June 30, 2021 3 601,637.33 = y, ~_ ~ S.A. and L Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 > --- OCR page 26 of 77 --- om Page 24 HEALTH COVERING THE PERIOD 7/1/2020 TO 6/30/2021 ~ ESTIMATE OF NEEDS FOR 2021-2022 EXHIBIT E hedule 4: Revenue 2019-2020 Account 72020-2021 Account ‘Actually ‘Amount ‘Actually Over Sa SOURCE Collected Estimated Collected (Under) 9001 Current Tax: [ss TS 268,801.92 [$268,801.92 = 9002 Prior Year [ss 6,522.76 |$ 6,522.76 9003 Beck Year Se 3 4,735.00 |'$ 4,735.00 Ad Valorem Tax Total es es 280,059.68 |$__ 280,059.68 (9100, Local Revenues om 9110 Donations [ss TS 32.50|$ 32.50 9115 Health Fees es | a 6 5,358.70 [$ 5,358.70 9120 5-yr Manufacturing Exemption Reimbursement ee es 2,548.71 [$ 2,548.71 Total for Local Revenues |S dS CCSC~=C*dC'S 7,939.51 |S 7,939.91 on 9200, State Revenues 9221 Payment In lieu of Taxes a 195.50[$____195.50] 9224 State Land Reimbursement [Ss 26s Ts 265 | "Total for State Revenues [Is . is ~|s 198.15 |S 198.15 = [2400, Miscellaneous Revenues 9407 Reimbursements of Expenditures [s- SSC™C~“C*‘™SCS CTS: 660.64 | $ 660.64 Total for Miscellaneous Revenues sy 660.64 |S 660.64 = ‘TOTAL REVENUES FOR THE HEALTH FUND Total Unrestricted Revenue eS | 8,798.70 | S 8,798.70 9216 OTC - Sales Tax [s_ sss Restricted - Sales Tax Interest a | aad “Total Miscellaneous Health [sd 8,798.70 |S 8,798.70 ‘Ad Valorem Tax eS | Ey 280,059.68 | $ 280,059.68 ‘Grand Total of All Revenues eS a 3 288,858.38 |S 288,858.38 - a = - - ~ Fe = _ S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 ~ --- OCR page 27 of 77 --- HEALTH COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 25 r ESTIMATE OF NEEDS FOR 2021-2022 EXHIBIT E (Schedule 4: Revenve Basis @ Limit | 2001000 Accomm r Estimate Governing Board Excise Board t [s_ Rp [J | ee | [sd [___sa.oord[s 2995 r [___90.00%[s gazes fC . [S__ 2,293.84 | |[_Total for Local Revenues SCSCSCSdYSCSCSCSCSCSCS*@Y [s__ 744592 [Sd r [s_as9s[ [S239 ES | RS 071 P [s_ 594 sa [sass Cd r | o.oofs noises [sd 2 a [90.00%] [sess id rs [s__ 791883 [$d [S— 601,637.33 |S 601,637] r r S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 Pr it --- OCR page 28 of 77 --- HEALTH COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 27 r ESTIMATE OF NEEDS FOR 2021-2022 t EXHIBIT E [Schedule 5: Health Fund Balance Sheet of Current and AllPrior Years 20 r [Cash Balance Reported to Excise Board June 30,2020 "dS STO] tl |_Cash Fund Balance Transfered Out SS dS [_CashFund Balance Transfenredin 0S 8 r Jad Valorem Tax Apportioned Sidi i c0sp.s 9 [Miscellaneous Revenue (Schedule) dS «298.708 [eash Fund Balance Forward From Preceding Year SSSSS*dS cr. 7 8 Prior Expenditures Recovered CdS Ss OTAL RECEIPTS dS 28925 TS om TOTALRECEIPTS ANDBALANCE «dS 531,339.85 8 019. r Warrants of Yearin Caption 0 *diS 136,038,018 a. 46 08 L [terest Paid Thereon dS Sd r [Reserve for Warrants Outstanding dS ngs is Reserve forIntereston Warrants dS Reserves FromSchedule8_ TT SSSSC*dS ~—i SAIS r HOTALLIABILITESANDRESERVE SSS a tas t's BFC Ss . r [Warrants Quistanding June 30 of YearinCaption YS dS SSIS TS _13,550.15] r OTAL dS 155,312,868 42,653.10] § 197,965.96 | [Warrants Converted to Bonds orJudgements SC SSC CS CS [Warrants Cancelled 0S CdS CdS r [Warrants Estopped by Stamte SC dS —( mes 906.6 . [TOTAL WARRANTS OUTSTANDING JUNE 30,2021 [S278 518-8 19.2785] r r [additions: Ts [Deduetions: Td (Gross Balance Tax *didiS 2a 38] RReserveforProtestPending dS SY r [Net Balance 2020 Tax in Process ofCollestion SS OOOOSCSCSCSCSdS SY Ll r ‘Net Appropriations ‘Warrants Approved by [ (" — fizooFringe Benefits ss is CCS” | [4100 Total Mechinary & Equipment, Capital Outlay —|[$____243,495.76][$___1,191.00/]$___—- ‘(IS 357,160.78] r S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 P l --- OCR page 29 of 77 --- Page 28 HEALTH COVERING THE PERIOD 7/1/2020 TO 6/30/2021 ESTIMATE OF NEEDS FOR 2021-2022 al EXHIBIT E ___. DEPARTMENTS OF GOVERNMENT Warrants Balance 302021 7 PPROPRIATED ACCOUNTS 6-30-2020 Since Lapsed Issued ‘Appropriations ‘Appropriations 7 | 1310Travel CdS 0S OTS CS 7 [sss 4 , [se SS SC‘ *S [YS TITS 29,100.95 TS —_— AGHA S.A. and I, Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 7 --- OCR page 30 of 77 --- HEALTH COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 29 r ESTIMATE OF NEEDS FOR 2021-2022 i EXHIBIT E _ ee sed Needs as r Supplemental aa Warrants Baas Estimated by | Approved by Adjustments Gg Issued bo] Known to be Govern County ¥ Appropriations a z Pad Excise Board Unencumbered Board r [s = P [s_ 5391.20 [sts279.84 | $93,180.00] 6,971.66 |$ 19,128.18 | { [$5,000,009] $243,495.76 [$191.00 [$ =| $242,304.76 [$_5,39120[$ 493,775.60 [$155,312.86 |S 29,365.46] $ 309,097.28 | r [iS__s SSCS CSS CSCS CY cr [$s 15531286[$ 29,36546]S 309,097.28 |S 600,000.00] S 607,160.78 ESTIMATE OF NEEDS FOR THE 2021-2022 FISCAL YEAR Estimate of [| Approved by —————= PURPOSE: Govenring Board || _Excise Board js = is r C r r S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 31 of 77 --- - Page 34 SINKING FOND ACCOUNTS COVERING THE PERIOD TULY 1, 2000, 6 JUNE30, DT 1 ESTIMATE OF NEEDS FOR. 2021-2022 EXHIBIT "G" [Schedule 4, Sink Se nd Cash Statement = 1 aviator SRS rr es ns ce ca aS ee a ) es ee ae 7 a | Sees ae ae |_TOTAL RECEIPTS AND BALA NCE PS Ty Se = —— 7 rr ee es ae Hee Se rae eg es Ce ae SS == es eee ae al ee {es ae \ ee a ae -—1OTAL DISBURSEMENTS = RSEMI SE NS 3 ee _ xd Sinking d Ba SSS = alinsaeis Feely Maing LO ee Reem By Pax Ly 3 ——} DE Ue ASSETS (a xeasion oh] a) PEDUCT MATURED INDEBTEDNESS! ) Fast Due Coupons Ptr Acerved Thee - gest Due Bonds 7 eee Theron After Las Coupon) : Heal Agenoy Commission on Above} f Seerenis nd Interest Levied fr Bu Unpaid} | " Beran tems & Though £ (To Extension Cohama] =} BALANCE OF ASSETS SUBJECT TO ACCRUALS = 6 oo f Eemed Unnatued ees 0 7 fAgsna on Fan Coupons F,pceued on amatured Bonds ERC ae cuuau (lo Besta ohm] 8 SS A es S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 7 --- OCR page 32 of 77 --- — SINKING FUND ACCOUNTS COVERING THE PERIOD JULY 1, 2020, to JUNE 30, 2021 Page 35 r ESTIMATE OF NEEDS FOR 2021-2022 EXHIBIT "G" = Schedule 6, Estimate of Siking Fund Nees a rp [SINKING FOND J r Computed By Provided By 7 Governing Board || Excise Board [interest Bamnings On Bonds [s | [ss [sts [ss a r PRaaual Acerual From Exhibit RR Ss r t= Sinking Fads _ Net Value_$ 0.00 0.00 Mills Amount ime, r [s_] [st [st P [ss Reserve for Prost Pending 00 [st Pediet 2000 Tex Apportoned 4 fe [| [s— Bchedule Sinking Fund Investnenis fe Tavestments [ TIOUIDATIONS I Baned Tavestments —_ INVESTED IN on Hand Since By Collections Amortized by on Hand June 30, 2020 Purchased of Cost. Premium Court Order June 30, 2020 : : 'BESS== r [ss ss dS oh [$s ss ss [sos ss oh [ss ss os [so [ss sss oh a ES [s_| [ss ss oh r a EE | [$s Ss Ss ES EE r S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 p L --- OCR page 33 of 77 --- TOTAL OF SPECIAL REVENUE FUNDS COVERING THE PERIOD JULY 1, 2020 TO JUNE 30, 2021 Page 39 ESTIMATE OF NEEDS FOR 2021-2022 Pr EXHIBIT "I" TOTALS r { Eee IROTAL ASSETS TOE ee r [Warrants Outstanding TS or [Reserve for Intereston Warrants r i r CURRENT AND ALL PRIOR YEARS PRETO [Cash Balance Reported to Excise Board June 30,2020 dS dS 1.332, 20. r |_Cash Fund Balance Transferred Qut dS 801152238 [_ Cash Fund Balance Transfeed In «dS 28,800.95 [Adjusted Cash Balance dS 319,412.57 SSS] |Ad Valorem Tax Apportioned To YearInCaption SS SSSSSS*diS 7.250.008 YJ r [Sources of Revenue [9100fLocal Revenues id 881,320.79 r 19200|State Revenues «dS 309,560.88 TS L |9300[Federal Revenues id 3,975,778. 08 |S |9400[Miscellaneous Revenues dS «866337 |9500|Special Assessments dS 2849.02 r |9600[Other Revenues dS |9700|School Revenues dS dS JAM Other Non-TexRevemues YS P [Sales Tax and Sales Tax Interest dS] | [Cash Fund Balance Forward From Preceding Year SSSSSCS—~diS_ 37,2009 SY . [Prior Expenditures Recovered CdS CdS [FOTAL RECEIPTS YS TTS] r t ESA | cee | ace [TOTAL DISBURSEMENTS dS 8097S STOR TTT | r t [Reserve for Warrants Outstanding dS CL SBSIT'S SY Reserve for Interest on Warrants dS dS P Reserves From Schedule 8 sass r TOTAL LIABILITES ANDRESERVE Sd 180,525.70] a |S | | r Net Appropriations Warrants ‘Approved by [1200 Fringe Benefits SS SCO [1300 Travel Related |S 16,079.53 [$5 058BE |S Sa SBOT| P r [4110 Machinary & Equipment, Capital Outlay |[$__35,86772's- =<S ~~‘ 3586772 r S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 L --- OCR page 34 of 77 --- 7 Page 40 COUNTY BRIDGE AND ROAD IMPROVEMENT COVERING THE PERIOD 7/1/2020 TO 6/30/2021 m ESTIMATE OF NEEDS FOR 2021-2022 al 11103 COUNTY BRIDGE AND ROAD IMPROVEMENT 4 [Investments [TOTAL ASSETS *dS SST] [Warrants Outstanding SYS [Reserve for Interest on Warrants dS ' 7 TOTAE LABS VE ORANGE ————————— fr " 7 | Cash Fund Balance Transferred Out SC*dCSSCC C*dSCC SY [Cash Fund Balance TransferedIn «dS 27,5545 |__| JAd Valorem Tax Apportioned To YearInCaption SSCS SCC ~C«*dSSOC Sd 7 [Sources of Revenue [9000ftaterest, Mortgage Tax CdS CCS Sd |9100[Local Revenues Sd Sd ial [9200[State Revenues «dS tO IT'S SCS | [9300]Federal Revenues SCCSCSdYS CdS SY |9400[Miscellaneous Revenues YS dS [9500[Special Assessments SYS SY " |9600[Other Revenues SiS ! |9700|School Revenues YS iS JAll Other Non-Tax Revenues YS SY - [Sales Tax and Sales TaxInterest YS SY 7 [Cash Fund Balance Forward From Preceding Year SSSSSSC*dSS CSCS SSS [Prior Expenditures Recovered CSCS «dS [OTALRECEPTS dS 208,870.88 IPS 7 limterest Paid hereon CdS OS [Reserve for Warrants Outstanding dS SY [Reserve for Interest on Warrants dS Reserves FromSchedule8 SS SCSCSCSCSCS—*dS 26 S00. SY 4 TOTAL LIABILITES ANDRESERVE SSCS S46 500.00] ee SS S| 7 Net Appropriations ‘Warrants ‘Approved by 1 [1200 Fringe Benefits 8 8 [1300 Travel Releted SS 7 [4100 Total Machinary & Equipment, Capital Oulay|| $= $8 : S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 ‘October 04, 2021 7 --- OCR page 35 of 77 --- ASSESSOR REVOLVING FEE COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 41 ESTIMATE OF NEEDS FOR 2021-2022 r 11204 _ ASSESSOR REVOLVING FEE. r 5 Hovestments TT — [OTAL ASSETS ee n Params Oustanding L [Reserve forintereston Warrants [Reserves From Schedule 3S (TOTAL LIABILITIES AND RESERVES [TOTAL LIABILITIES, RESERVES AND CASH FUND BALAI NCE SY IIS 16,926.16]| r |CORRENT AND ALL PRIOR YEARS 00 RE PF ess Fund Balance Transfered 03 et L [Cash Fund Balance Transferred In 8 [Ad Valorem Tax Apportioned To Year In Caption CdS SY r [Souroes of Revenue [9100|Local Revenues dS 9S [s200|State Revenues dS [9300}Federal Revenues Sg [2400|Miscellaneous Revenues YS [9500|Special Assessments TS r [9600] Other Revenues dS |9700|School Revenues TS JAI Other Non-Tax Revenues SSS [Sales Tax and Sales Tax Interest dS r [Cash Fund Balance Forward From Preceding Year SSSS*dS 200,00 8} [Prior Expenditures Recovered —~dS SY [TOTALRECEPTS SS TTS [Warrants of Year in Caption CSCS 22S —*' [interest Paid Thereon dS TOTAL DISBURSEMENTS TS a's P [Reserve for Warrants Outstanding [Reserve for Interest on Warrants SYS F [Reserves From Schedule dS] r (TOTAL LIABILITES ANDRESERVE SYS SY a | r ‘Net Appropriations Warrants ‘Approved by [ [1200 Fringe Benefits SSCS [1300 Travel Related TS 8S [2000 Total Maintenance & Operations dS 16.945.48 [$303.28 '$_______- [816 536.16] P [4100 Total Machinary & Equipment, Capital Outlay|[$ = —([S—S «ds ZY JAI Other Expenses TS OS ss oh [TOTAL EXPENDITURES 2020-21 FISCAL YEAR|[S _16,94544[S 203288 - [S$ 16976116] r S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 [ --- OCR page 36 of 77 --- a Page 42 COUNTY CLERK LIEN FEE COVERING THE PERIOD 7/1/2020 TO 6/30/2021 2 ESTIMATE OF NEEDS FOR 2021-2022 7 1-1208 COUNTY CLERK LIEN FEE al [Investments eee SO [TOTAL ASSETS dS 8 [Warrants Outstanding CdS 8628 | | [Reserve forIntereston Warrants C~dYSCC Cid [Reserves From Schedule3_0 S28 [TOTAL LIABILITIES AND RESERVES _——SSS—SCSCSCSCSCSCSCSCSCSCSCSCSCSCSCSCSCSCSCSCSCSCS*dCS CN 355.28 7) 7 [CURRENT AND ALL PRIORYEARS 2000-2 PRE-2020 | | CashFund Balance TransferedOut_ CdS CdS CO 7 |_Cash Fund Balance Transferredin eT CSdSSC“‘C$SSS*SCSSC“‘(#NSN’NSCNC@dS [Adjusted Cash Balance eT ST |Ad Valorem Tax Apportioned To Year In Caption CS OSC Cd ) [Sources of Revenue [9000finterest, MortgageTax CSCC CdS SC Cd [9100[Local Revenues SMO CS c [9200|State Revenues COCCI TCC CdS Sd 7 |9300[Federal Revenues SC CdS Sd [9400[Miscellaneous Revenues CdS COC «WSC C*@d [9500|Special Assessments CdS COC CSCS «C*d [9600[Other Revenues CdS CC «CdS CC =*d al [9700|School Revenues CSC™C™~—~dYSCC COSC‘ SC* [All Other Non-Tax Revenues dS CdS [Sales Tax and Sales Tax Interest CdS «CdS ~C*d al )Cash Fund Balance Forward From Preceding Year CdS OSC Cid [Prior Expenditures Recovered CdS COC CdS C~=*d [TOTAL RECEIPTS fs 80s fs - [TOTALRECEIPTSANDBALANCE TT SSSSCSCSC~*drCS Cis OATS Cd 7 |Warrants of YearinCaption 0 SCSCSCS~SC~dYSS CdS Cid [interest Paid hereon CCSC™C™COCSYS CC CdS CC*@Y [TOTAL DISBURSEMENTS C~*dYCS CYS [CASH BALANCE JUNE 30,2021 CSC*dCS SC*t8287.OHCC—*d 7 [Reserve for Warrants Outstanding SBS CY [Reserve forlntereston Warrants COSC CdS CCS” [Reserves FromSchedule8 SS CSCSC*«diCSSCSCSCSC*SCOOIT SS CCCC* al (TOTAL LIABILITES ANDRESERVE OT C*d'S SSCS OBITS } [ERIC dS OS [CASH BALANCE FORWARD TONEXTYEAR SSCS Ci CCCSC~=*d ] Net Appropriations Warrants Approved by || Petts or | eet) ome Load ]1200 Fringe Benefits SS [1300 Travel Related Ss 575037 IS _2,087.70[8_____-_[s__ 427021 | [2000 Total Maintenance & Operations __*i[$__10,006.60/$___—-~—+|[ $39.00] 9,967.60] 7 [6100 Total Machinary & Equipment, Capital Outlay $2,569.05 ____- [8 -_| $2,569.05] i S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 7 --- OCR page 37 of 77 --- COUNTY CLERK RECORDS MANAGEMENT AND PRESERVATION COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 43 ESTIMATE OF NEEDS FOR 2021-2022 r 41-1209 COUNTY CLERK RECORDS MANAGEMENT AND PRESERVATION Lea r ——————— | Havestments ee TOTAL ASSETS re] r Warrants Outsinding FZ Reserve for Interest on Warranis Tf Reserves From Schedule 3 r ITOTAL LIABILITIES AND RESERVES BS FOND BALANCE JUNE 30, 20 [s—_106335.17] | TOTAL BLISS DOT AE’ an r [CURRENT AND ALL PRIOR YEARS OT r | “Cash Fund Balance Transferred Out \ [ Cosh Fund Balance Transfered In] $3 J [Adjusted Cash Balance dS eas Js [Ad Valorem Tex Apportioned To Vearin Capon Yt r Sources ofRevene [9000finterest, Mortgage Tx Sf [et00|Local Revenues Sa 00s [* |200}state Revenues EE { [s300}Federal Revenues J [2400}Miscellaneous Revenues |9500|Special Assessments Os I PBsoofoter Revenses [9700|Sehool Revenues fs [AM Other Non-Tex Revenues pr |Sales Tax and Sales Tax interest | __ |fastFund Balance Forward From Preseding Year 3 J [Por Expenditures Recovered dS HOTALRECEIPTS 00 [° POTAL RECEIPTS AND BALANOE ss ioas fs [Warrants of Yearin Caption dS 28 881.28 8 | [lotrest Paid Thereon Sg ja__([FOTAL DISBURSEMENTS 8s ag p28 | (CASH BALANCE JUNE 30,2001 5 06,399.17 |S * (Reserve for Warrants Outstanding Reserve forIntereston Warrants dS FP |Reserves From Schedule 8 r TOTAL LIABILITES ANDRESERVE 3 PDERICT, S — [CASH BALANCE FORWARD TONEXT YEAR 7s ——— c ‘Net Appropriations ‘Warrants ‘Approved by ere re Me ee [i200 Fringe Benefits SS i [1300 Travel Related 8 [* fpROOTTowal Maintenance & Operations |S 10e 452 $36 283s ease] | |100°Fotal Machinary & Equipment, Capital Outay[$_— “YS ___—_-_[s—-_]s | Jal Other Expenses SS ts [TOTAL EXPENDITURES 2020-21 FISCAL YEAR||$S ___128,520.45][S____26,881.281$____- |S 106,309.17] r S.A. and I, Form 2631R01 Entity: Ottawa County, 58 ‘October 04, 2021 r l --- OCR page 38 of 77 --- Page 44 EMERGENCY MANAGEMENT COVERING THE PERIOD 7/1/2020 TO 6/30/2021 = ESTIMATE OF NEEDS FOR 2021-2022 11212 EMERGENCY MANAGEMENT SS go a - SSNS ee ee | [POTAL ASSETS SSS | | [Warrants Outstanding ae [Reser Fem Schedule 3s = (Siew | Ls 5 (Cash Fund Balance Transferred In] - es [ss [9100[LocalRevenues COSC Cdr 7 [9200|StateRevenues COSC CdrY [so [9400|Miscellaneous Revenues OS SCS [9500|Special Assessments SC OS 7 [9600[OtherRevenues CdS [9700[School Revenues SS JAM OtherNon-Tax Revenues SC OSC «Sd ~ [Sales Tax and SalesTaxInterest SO OSC CS EE | a a [sn = ™ [s =| bet hr [Reserve for Warranis Outstanding SC dS —*d [Reserve for Interest on Warrants SS ~ JReserves FromSchedule8 CdS COC CdS TC ~=S@Y ffOTAL LIABILITES ANDRESERVE OT SCSC~*dYiSS SCC CCCS@Y es a, | ee | 7 ‘Net Appropriations Warrants ‘Approved by 7 [i200 Fringe Benefits SS Ss as a = |S 35,521.77 S 4,020.02 | ss 3075] DE! Le [All Other Expenses zee 7 S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 39 of 77 --- LOCAL EMERGENCY PLANNING COMMITTEE COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 45 ESTIMATE OF NEEDS FOR 2021-2022 r 11218 LOCAL EMERGENCY PLANNING COMMITTEE Ss ; r ee <<< sh ON SS a Se r [Marans Qustanding TT smX— Reserve for Interest on Warrants Reserves From Schedule $e a HOTAL LIABILITIES AND RESERVES r [Schedule 5: Local Emergency Planning Committee Fund Balance Sheet of Curent and All Por Yeas [Cash Balance Reported to Excise Board Tune 30, 2020 r |_-Gesh Fund Balance Transfered Out Tg Sg |_Cash Fund Balance Transferred In 7S [Adjusted Cash Balance YS 00S [Ad Valorem Tax Apportioned To Year In Caption tg r Sources of Revenue Tp op [2t00fLocal Revenues Ys apn cs [9200|State Revenues ts tg [2300{Federal Revenues [2400[Miscellaneous Revenues 0S [2300|Special Assessments OS r [9600[Other Revenues Ts [2700|School Revenues OS [All Other Non-Tax Revenues 0S ti Bales Tax and Sales Tax Interest TTS fs r [Cash Fund Balance Forward From Preceding Year YS Prior Expenditures Recovered Sg FOTAL RECEIPTS Sa. F's f [TOTAL RECEIPTS AND BALANCE dS 6,000,005 J |Warrants of Year in Caption CdS 180,00 T'S [interest Paid Thereon SS - [fOTAL DISBURSEMENTS SS r ICASH BALANCE JUNE 30, 2027S 5,890.00 § J Reserve for Warrants Outstanding 0S Reserve for Interest on Warrants SS ja [Reserves From Schedule 8S r [FOTAL LIABILITES AND RESERVE dS a | | [CASH BALANCE FORWARD TONEXT YEAR SSCS—SdS 88'S] a c Net Appropriations Warrants ‘Approved by r [so Sd [1200 Fringe Benefits IS SS dS [1300 Travel Related 7 Ss Ss F [2000 Total Maintenance & Operations __*i[$_ 600000118 ___180.00]/s_____—- r [£100 Total Machinary & Equipment, Capital Outlay|[$ = SSS ZF JAU Other Expenses SS ts dS [fOTAL EXPENDITURES 2020-21 FISCAL YEAR|$ 6,000.00 /[$___180.00|'$__- 's 3,830.00] r S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 40 of 77 --- a Page 46 RESALE PROPERTY COVERING THE PERIOD 7/1/2020 TO 6/30/2021 ESTIMATE OF NEEDS FOR 2021-2022 7 41-1220 RESALE PROPERTY ; al [Investments eee EEE 7 [Reserve for Intereston Warrants CS [Reserves From Schedule 307d 7 / [CURRENT AND ALL PRIOR YEARS 0200-22020 | Cash Fund Balance Transferred Out S295 57S 7 [Cash Fund Balance Transferred In SOO [Ad Valorem Tax Apportioned To YearIn Caption TS OS 7 [Sources of Revenue [9000]interest, MorigageTax CSOT |9100|Local Revenues 0 C*ddS BS TID.BBTS CS [9200[State Revenues 7 |9300}Federal Revenues gs [9400 [Miscellaneous Revenues 0S 2,890.00 $= |9500|Special Assessments CS 289.02 Sd [9600|OtherRevenues OT CdSCCCC*diCSC Cd 7 |9700[Schoo! Revenues 0ST JAll Other Non-Tax Revenues ST [Sales Tax and Sales Tax Interest ST [Cash Fund Balance Forward From Preceding Year C'S SSCS CCS [Prior Expenditures Recovered SS SC CS [TOTALRECEIPTS CCS STIS CY al linterest Paid Thereon CdS CC Cd 7) [Reserve for Warrants Outstanding SOIT [Reserve forlIntereston Warrants CSC~dYSSCNC“‘(#STS#&@dCSS CSCC C=C*@* [POTALLIABILITES ANDRESERVE SC*d'S SSC BOTT Cid [ERIC TTS [CASH BALANCE FORWARD TONEXTYEAR «dS _530,730.20|'$ 0.00] fet Appropriations Warrants ‘Approved by pect ee | ee | [1200 Fringe Benefits SS SC CSC sSYd [1300 Travel Related |S 758402 |S TSS SSC «dS —* 79.8 | [2000 Total Maintenance & Operations “($455,057.87 |S 91,567.47|$______- $410,742.23 | q [4100 Total Machinary & Equipment Capital Outlay|[$_ 33,298.67 —s[S_——SS dS 233,298.67 (TOTAL EXPENDITURES 2020-21 FISCAL VEAR||S 644587438 184734988 _- [8 330,730.20] - S.A. and I. Form 2631R01 Entity: Ottawa County, 58 ‘October 04, 2021 7 --- OCR page 41 of 77 --- REWARD FUND COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 47 ESTIMATE OF NEEDS FOR 2021-2022 r 1-1221 REWARD FUND: P | a] L [ss HOTAL ASSETS a [CIABILITIES AND RI SSE ES NT r [Warrants Outstanding WS [Reserve for Interest on Warrants Reserves From Schedule 3S [OTAL LIABILITIES AND RESERVES TS r r r | Cash Fund Balance Transferred Out id SY t [_Cash Fund Balance Transferred in «dS [Adjusted Cash Balance SYS OSES F |Ad Valorem Tax Apportioned To Yearin Caption CYS SS t [Sources of Revenue TT |9100[Local Revenues iS r |9200|State Revenues OS { [9300|Federal Revenues dS [2400|Miscellaneous Revenues dS = [2500|Special Assessments SS r |3600|Other Revenues SB |9700|School Revenues dS [AU Other Non-Tax Revenues YS [Sales Tax and Sales Tax Interest YS r [Cash Fund Balance Forward From Preceding Vear dS dS [Prior Expenditures Recovered YS POTAL RECEIPTS dS r [TOTAL RECEIPTS ANDBALANCE CdS 8,397.96] L [Warrants of Year inCaption ISS limerest Paid Thereon dS r |CASHBALANCE JUNE 30,202) dS ES [Reserve for Warrants Outstanding YS ST [Reserve for Interest on Warrants SY [Reserves From Schedule 8 SY r [TOTAL LIABILITES AND RESERVE dS] PRCT TSS [CASH BALANCE FORWARD TONEXT YEAR S*dS 77,96 S t ‘Net Appropriations ‘Warrants “Approved by SS a [1200 Fringe Benefits sts [1300 Travel Related 78s [2000 Total Maintenance & Operations $377.96 —id'S SS (dS 1.37798 r [4100 Total Machinary & Equipment, Capital Outlay|[$_ = TS dS SY JAN Other Expenses 7s Ss oh > (ROTAL EXPENDITURES 2020-21 FISCAL YEAR||$____1.377.56|$______-_ [8-8 137756] r ‘S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 42 of 77 --- Page 48 SHERIFF COMMISSARY COVERING THE PERIOD 7/1/2020 TO 6/30/2021 ESTIMATE OF NEEDS FOR 2021-2022 7 11223 SHERIFF COMMISSARY [investments ES [TOTAL ASSETS «dS 2671055 | fReserve for Interest on Warrants COCOCOCOCCCSdYCS Cd [Reserves From Schedule 30S 7 1 |_Cash Fund Balance Transferred Out ST OSC Cd |_Cash Fund Balance Transfeed In CdS CC CdS Cd [Adjusted Cash Balance Sess 2 319.39] [Ad Valorem Tax Apportioned To YearInCaption SS SSSCSCSCSC~*iYSCSC“‘“‘(SNSCTS«CSCSSCSCSC~‘“C‘CS=C@d 7 [Sources of Revenue Odd |[2000fInterest, Mortgage Tax CSCC STC C*Y |9100[Local Revenues CSCSCSCS~CSCSC~dYCSS =i, S——SC—~* [9200]State Revenues dS SSC Sd . [9300 [Federal Revenues CCSCSCSC*dCS ~C~*«i« SOLO S————SC~S—=* [9400 [Miscellaneous Revenues CC*dSC CdSCCC~*Y [9500 |Special Assessments CdS dS 7 [9600[Other Revenues C*dS SCS |9700|School Revenues SS [All Other Non-Tax Revenues Sd CS SY [Sales Tax and Sales Tax Interest CdS CdS CCS” "1 [Cash Fund Balance Forward From Preceding Year SSSSCSCSC~*dCSSSCSSCSCC*dCSNCSC~CSCSY [Prior Expenditures Recovered CdS dS CS” FPOTAL RECEIPTS Sidi 0 TOTS 7 [interest Paid Thereon TT COC—~dYS CS CCS Reserve for Warrants Outstanding 0S TS [Reserve for Intereston Warrants CdS Cd iY - [Reserves From Schedule 8 OS SY 7 (POTAL LIABILITES AND RESERVE SSCS 73.28 T'S] a Kk Sk Net Appropriations ‘Warrants ‘Approved by fettetoee | ee | em eee] [2200 Fringe Benefits SS [1300 Travel Related WTS ts 000 Total Maintenance & Operations __[$_87,365.[S #2037458 $23,987.31] ) [2100 Total Machinary & Equipment, Capital Outlay||$— [S's Is (TOTAL EXPENDITURES 2020-21 FISCAL YEARS 87300 OS __ 0751's —_- [sae S.A. and I. Form 2631R01 Entity: Ottawa County, 58 ‘October 04, 2021 7 --- OCR page 43 of 77 --- SHERIFF FORFEITURE COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 49 ESTIMATE OF NEEDS FOR 2021-2022 r 11225 SHERIFF FORFEITURE r Pnvestmen Sh YF [WOTAL ASSETS [LIABILITIES AND RES SS r [Warrants Outstanding [Reserve for Interest on Warrants [Reserves From Schedule 3 | r (CURRENT AND ALL PRIOR YEARS dC 2000 REO tr [_ Cash Fund Balance Transferred Outi SY [Cash Fund Balance TransferedIn dS tS fAdjusted Cash Balance dS 8559S 98S jAd Valorem Tax Apportioned To Year In Caption C«dSSCSSC=C*dSSCSCS SY tr [Sources of Revenue [9100|Local Revenues WS r [9200]State Revenues Sd |9300[Federal Revenues dS |9400fMiscellaneous Revenues dS dS |9500|Special Assessments dS r |9600[Other Revenues SS |9700|School Revenues dS JAI Other Non-Tax Revenues dS BS [Sales Tax and Sales Tax Interest dS dS r [Gash Fund Balance Forward From Preceding Year S—~*dY S$ 28.09 SJ [Prior Expenditures Recovered dS «CdS SCY PPOTAL RECEIPTS dS 2805 Ss [TOTAL RECEIPTS AND BALANCE SSSCSCSS*dS 8382.08] S_065.99 | linterest Paid Thereon SS CdS” r [Reserve for Warrants Outstanding 0S SY [Reserve for Interest on Warrants dS dS [Reserves From Schedule 8 «dS 0S r [TOTAL LIABILITES ANDRESERVE SC*dS 550.00] 1] PDB RICSS t ‘Net Appropriations Warrants ‘Approved by [1200 Fringe Benefits SS dS tg [1300 Travel Related TSS ts Pr [4100 Total Machinary & Equipment, Capital Outlay[$ = S'S SCS [TOTAL EXPENDITURES 2020-21 FISCAL YEAR|S____3,382.08 [8 190.00 |S 350.008 3,042.08 | r S.A. and L Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 44 of 77 --- Page 50 SHERIFF SERVICE FEE COVERING THE PERIOD 7/1/2020 TO 6/30/2021 = ESTIMATE OF NEEDS FOR 2021-2022 " 1-1226 SHERIFF SERVICE FEE —————————— [$153,376.32 | 7 [investments TOTAL ASSETS dS S| | }Reserve for Interest on Warrants COCCI CY [TOTAL LIABILITIES AND RESERVES SSC Y's 60,455.99] 7 [TOTAL LIABILITIES, RESERVES AND CASHFUND BALANCE «dS 153,376.32] [Schedule 5: Sheriff Service Fee Fund Balance Sheet of Current and AN Prior Years id a [Cash Balance Reported to Excise Board June 30,2020 TS SCID BL es 0 | Cash Fund Balance Transferred Out SC«dS CC COSC CS [_ Cash Fund Balance TransferedIn SSCS YS dS? [Ad Valorem Tax Apportioned To YearIn Caption S500 7 [Sources of Revenue CSdCCSsdYSCNCSd [9000fInterest, Mortgage Tax CSC CdS C=S@d [9100 [Local Revenues 7 SSC*ddS =i Cid [9200|State Revenues SSC™~CSYS Cid GTS 7 [9300 [Federal Revenues CdS TC CdS Cd [9400[Miscellaneous Revenues CdS CCC STOOPS SCC id [2500|Special Assessments CdS CSCS —Cd [9600[Other Revenues CdS CC CdS CCC*d 7 [9700[School Revenues CdS TC CS —i*d JAM Other Non-Tax Revenues CSS CTC CdSC~CSC~=*d [Sales Tax and SalesTaxInterest_ SC SC ~*d 7 [Cash Fund Balance Forward From Preceding Year CdS SC TTBBI'S Cd [Prior Expenditures Recovered“ C*dS COC SCS CCC*d [TOTALRECEIPTS CSS 85ST Cd - 7 [Warrants of YearinCaption C*dS 255,226.46 || $ 32,321.39] linterest Paid Thereon TT COC™~™COCCSYS CC CdS Cd . [Reserve for Warrants Outstanding YS GINS Sd [Reserve for Intereston Warrants CSC OSC —*Y = [Reserves From Schedule SCC*dCS CSS SD.TIT'S CC —~*d 7 [fOTAL LIABILITES ANDRESERVE OO SSCSCSCSC*diS CC~*i ASS. TS SCC —*d 2 S| | ‘Net Appropriations: Warrants ‘Approved by [1200 Fringe Benefits SS Cd [1300 Travel Related TSS 7 [4100 Total Machinary & Equipment Capital Outlay[$— = SSS =SS SSC «CdS (ROTAL EXPENDITURES 2020-21 FISCAL YEAR| $___359,947.25||8 262,000.67 8 53,659.18 |S 92,50033 | -] S.A. and I, Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 7 --- OCR page 45 of 77 --- TREASURER MORTGAGE CERTIFICATION COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 51 Fr ESTIMATE OF NEEDS FOR 2021-2022 | 1.1230 _ - _ TREASURER MORTGAGE CERTIFICATION ‘ r 3855 35 favesments [Waranis Oustanding irr] r [TOTAL LIABILITIES AND RESERVES 3 00 r [CASH FOND BALANCE JONE 30,202) (fOTAL LIABILITIES, RESERVES AND CASH FUND BALANCE 5 4,945.38 [TOTAL LIABILITIES, RESERVES AND CASH FOND BALANCE 5 r (CURRENT AND ALL PRIOR YEARS EO [° | cash Fund Beane Tanstered Oot 8 [Cash Fund Balanoe Transfered In s+ [Adjusied Cash Balance [Ad Valorem Tex Apportoned To Year in Caption r [Soures ofRevenue [So00[interest. Morgage Tax BS aS [p100[Local Revenues 8 5.00 J [9200|Suae Revenues J [ps00[Federal Revenues [2t00[Miseelaneous Revenues J [9500|Special Assessments [°Besoloter Retenwes ss [2700|Schoot Revenues 3 All Other Non-Tax Revenves Sales Tax and Sales Tax Interest P| ash Find Baines Forward Front Feng Yee ———.-—-—} PPiorExpendimesRecovered $8 POTALRECEPTS S580 TS TOTAL RECEIPTS AND BALANCE Sait fs] [Warrants of Yearin Caption dS 6.17250 J nterestPaid Thereon i TOTAL DISBURSEMENTS 2S [ fegSBakaNce aN 0 sas fs Reserve for Warrants Outstanding SS Reserve for interest on Warrants dS RReseres From Schedule 0S [ ffotatcasmres anpREsERVE rs J DEFICITS Sg [CASH BALANCE FORWARD TO NEXT YEAR_——______ sag 38 [s-_— r ‘Net Appropriations Warrants ‘Approved by ° Es eee ee [200Fringe Benefits i$ fi300‘Travel Related ‘$3,745.00 [$250.00 |S ___-_|s_ 2.9500 [ |itoorearactioay & Equipment Ca Caley ps [AOtherBxperses Sg i i r S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 46 of 77 --- Page 52 ‘COUNTY DONATIONS COVERING THE PERIOD 7/1/2020 TO 6/30/2021 ESTIMATE OF NEEDS FOR 2021-2022 7 1.1235 COUNTY DONATIONS [Schedule T: Current Balance Sheet -June 30,0021 7 | JET] MOTALASSEIS dS 12659 | 7 [Reserve for Intereston Warrants dS [TOTAL LIABILITIES AND RESERVES S55 33030] 7 [TOTAL LIABILITIES, RESERVES AND CASHFUND BALANCES 126,266.59] 7 7 | Cash Fund Balance TransferredQut_ 7S Se al [Cash Fund Balance TransferedIn CSS TCC CSC‘ S*@S [Adjusted CashBalance CS TODABITS 3,010.63 [Ad Valorem Tax Apportioned To YearIn Caption SC OS 7 [Sources ofRevenue OCC TTTTCdCCS~C*Y [9000] Interest, Mortgage Tax SC CdS [9100fLocal Revenues SC~CSCSYS CBS CY |9200]State Revenues dS ‘ |9300[Federal Revenues TCC*dSS CCC CSC *d |9400|Miscellaneous Revenues CSCC CdS CC CS* |9500|Special Assessments COSC CdS CCS” [9600[Other Revenues CdS COC OS CY 7 [9700[School Revenues CdS SY JAN Other Non-Tax Revenues CSS ~C*dS CCS [Sales Tax and Sales Taxnterest_ SC CdS Cd by [Cash Fund Balance Forward From Preceding Year SSSCSCSC*~*~‘*iC‘SCONC*C*‘wd«S ANTS SCC~*d [Prior Expenditures Recovered CCCSCS~diYSS SSC CdS CCSCS*Y [ROTAL RECEIPTS CS 2 6 7 [Warrants of Year in Caption SSCS 82,776.30 S 1,614.01 | [interest Paid Thereon Cid COSY 7 Reserve for Warrants Quistanding dS 7.00000 [Reserve for Interest on Warrants CdS C'S [Reserves From Schedule SSSCSCSC~*dS SHOOTS "| [TOTAL LIABILITES ANDRESERVE SSCS YS 35,330.30 I i 2 ES ’ || Net Appropriations farrants ‘Approved by Peter | ee ee Lee [1200 Fringe Benefits TSS [1300 Travel Related dS CdS Cd a | 7 [£100 Total Mackinary & Equipment, Capital Outlay [$= IS sd CY JAll Other Expenses saa s_____-_|s__-_s1400 (TOTAL EXPENDITURES 2020-21 FISCAL YEAR|[$ 154,917.53 |S 4,776.30 || 783303018 70.9369] S.A. and I, Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 a --- OCR page 47 of 77 --- CONVENIENCE CENTER GRANT COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 53 ESTIMATE OF NEEDS FOR 2021-2022 1.1401 CONVENIENCE CENTER GRANT r HOTAL ASSETS ere [LIABILITIES AND 2 RESERVES! ey r Reserve for Interest on Warrants tg [Reserves From Schedule 3 Wo r [ees Balance Reported to Excise Board June 30, 2000 ST F i | Cash Fund Balance Transferred Out 0S dS t [Cash Fund Balance Transferred [7S a bE ‘s [Ad Valorem Tax Apportoned To Year In Caption TS r Rlourees of Revenue fp [2100{Local Revenues ss r [2200]State Revenues ts ts [2300[Federal Revenues tg [2400/Miscellaneous Revenues OUST = [2500|Special Assessments 0S f° olosterRevenes |2700|School Revenves Sg JAll Other Non-Tax Revenues YS Ses Tax and Sales Tax Interest Wg r [Cash Fund Balance Forward From Preseding Year 0S dS Prior Expenditures Recovered Sg OTAL RECEIPTS ners r TOTAL RECEIPTS ANDBALANCE dS 992.018 [Warrants of Year in Caption dS a's [interest Paid Thereon tg m [POTAL DISBURSEMENTS Saas r [CASH BALANCE JUNE 30,30) tn fReserve for Warrants Outstanding 00S 0a [Reserve for Interest on Warrants S'S f" _|Reserves From Schedule 8 ss r OTAL LIABILITES AND RESERVE Sas] PERC SS [CASH BALANCE FORWARD TO NEXT YEARS TS] r ‘Net Appropriations ‘Warrants: ‘Approved by [ [1200 Fringe Benefits 00's gs [1300 Travel Related Css ss 2000 Total Maintenance & Operations ___[ $9,992.01 [$7oarao ss 29483] c [2100 Total Machinary & Equipment, Capital Outlay[$ S$ 'S SC TOTAL EXPENDITURES 2020-71 FISCAL YEAR|[$ 9,952 01|[S__70a7@9 Ss 3.94419] r S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 48 of 77 --- Page 54 BUREAU OF INDIAN AFFAIRS STATELINE ROAD COVERING THE PERIOD 7/1/2020 TO 6/30/2021 ESTIMATE OF NEEDS FOR 2021-2022 "7 11456 BUREAU OF INDIAN AFFAIRS STATELINE ROAD ’ yCash Balances OCOCSCSCSdYdCS «SSS 7 [lavestments 9 (TOTAL ASSETS | [Warrants Outstanding CCS id [Reserve for Intereston Warrants CCCC*dS Cd [Reserves From Schedule 30S [TOTAL LIABILITIES AND RESERVES COCOCSCSCSCSCSCSCSCSCSC“‘;é‘“C;CS*dCSN'SCSCSC~C‘“‘*C*™S*C~*d 7 (Schedule 5: Bureau Of Indian Affairs Stateline Road Fund Balance Sheet of Current and AllPrior Years id 7 7 | Cash Fund Balance Transferred Out CCCCC*dS CC CdS TC «Sd [_Cash Fund Balance Transferred In CSC*dS CSCS CS~*d fAdiusted Cash Balance Sts [Ad Valorem Tax Apportioned To YearIn Caption SC*dS CSCS CCC —i*Y 7 [Sources of Revenue [9100 [Local Revenues C*dYS dS iY [9200|State Revenues CdS dS / [9300[Federal Revenues SSC*didUS SC=C* OTST SCSCSC=* [2400[Miscellaneous Revenues CCC~*dS CCS CCS [9500|Special Assessments CdS CdS [9600fOther Revenues C*diS dS |9700[School Revenues CdS CS Sd JAM Other Non-Tax Revenues CdS CdS CSS [Seles Tax and Sales TaxInterest SS id 7 [Cash Fund Balance Forward FromPreceding Year SSCS SCC CdS CY [Prior Expenditures Recovered CdS dS POTALRECEIPTS CSCS SYS Sd (TOTAL RECEIPTS AND BALANCE SSCSC~C~‘“~*~SC*dYCSS C*“Cd BSS SSS 7 [Warrants of Year in Caption CCSCSCSCSCSC~SYCS C~=iG BB'S Sd [interest Paid Thereon CSS OS CSS [POTAL DISBURSEMENTS CdS TI'S id ICASH BALANCE JUNE 30,2021 SCS _ 505.59 7 [Reserve for Warrants Outstanding "dS SY [Reserve for Interest on Warrants YS = [Reserves From Schedule CdS SCS " [TOTAL LIABILITES ANDRESERVE Sd Cd a SE SO [CASH BALANCE FORWARD TONEXT'YEAR SSCS __1, 545.59 § ——] 7 Net Appropriations. Warrants ‘Approved by 1 [1200 Fringe Benefits “TS SS dS CC dS Sr [1300 Travel Related TS [2000 Total Maintenance & Operations ____[S_ SI, 8456 |S 7563RT'$___- |S 1,545.35] 7 [2100 Total Mackinary & Equipment, Capital Outlay|[$ = SSS dS [TOTAL EXPENDITURES 2020-21 FISCAL YEAR||$___31,184.36|$ __ 29,63897||8__ [3130539 ¥ S.A. and I. Form 2631RO01 Entity: Ottawa County, 58 ‘October 04, 2021 7 --- OCR page 49 of 77 --- r COVID AID RELIEF COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 55 r ESTIMATE OF NEEDS FOR 2021-2022 | 11565 COVID AID RELIEF 7 2 ee r ae $s HOTAL ASSES ASSETS _ = [s_ Pr PWamants Outstanding ss— L Reserve for Interest on Wamrants TT eserves From Schedule 3 POTAL LIABILITIES AND RESERVES TF r CASH UND BALANCE JONE 30,202) Te [ROTAL LIABILITIES, RESERVES AND CASH FUND BALANCE J —————— r [Cesk Balance Reported to Excise Board June 30,2000 eg | Opening Balance fom Prior Year 7g r | Gash Fund Balance Transferred Out 7s ges {Cash Fund Balance Transfered fn 77S [Asiusted Cash Balance SS [J [Aa Valorem Tax Apportioned To Year In Caption gs i Rowse: of Revenue pe [p00oftnterest, Mortgage Tax hs [2200{Local Revenues Os oh r [2200|State Revenues hs [9300]Federal Revenues orga |3400[Miscellaneous Revenues TT Eg [2500{Special Assessments 0 oh Pr Ea] CS | Ee] [9700|Sehool Revenues ps Jal Other Non-Tax Revenues ales Tax and Sales Tex Interest TVs r [Cash Fund Balance Forward From Preceding Year YS Prior Expenditures Recovered Tg FOTAL RECEIPTS OS ores Ss r POTAL RECEIPTS ANDBALANCE iS SS [Warrants of Year in Caption Sg Interest Paid Thereon Sg [FOTAL DISBURSEMENTS Ss r ICASH BALANCE JUNE 30,2021 dS [Reserve for Warrants Outstanding 07S [Reserve for Interest on Warramts YS [Reserves From Schedule 8 iS r [FOTAL LIABILITES ANDRESERVE dS cc | Sa | [CASH BALANCE FORWARD TONEXT YEAR id $ J ‘Net Appropriations ‘Warrants ‘Approved by Pr [1100"Total Salaries "SS E [1200 Fringe Benefits SS (dS [1300 Travel Related TSS Sts [2000 Total Maintenance & Operations [S$ SS dS SSC «CdS r [4100 Total Machinary & Equipment, Capital Qutlayl[$" = Sd SS (TOTAL EXPENDITURES 2020-21 FISCAL YEAR| $= SS —idS dS Fr S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 t --- OCR page 50 of 77 --- Page 56 AMERICAN RESCUE PLAN ACT 2021 COVERING THE PERIOD 7/1/2020 TO 6/30/2021 - ESTIMATE OF NEEDS FOR 2021-2022 1-1566 AMERICAN RESCUE PLAN ACT 2021 7 [Cash Balanees Sa [Investments [TOTALASSETS TT OCOCCC*dCS _ 3,023, 087.50| be [Warrants Outsanding Reserve for Interest on Warrnis a [Siete es ict} Le Le [-] 4 b= [Same = Sf a se | es es [see | [2100[Local Revenues 7 [9200] State Revenues [see | [9800]Federal Revenues [9500] Special Assessments 5 [9600|Other Revenues Y's [2700)Schoot Revenues SJ [All Other Non-Tax Revemses_—— . [Sales Tax and Sales Tax nerest [Cash Fund Balance Forward From Preceding Yet YS [Por ExpendituresRecovered di [seine a == | " aa see S| 7 Sa aS ES . POTAL LIABILITES AND RESERVE J J DERI oe [Sie or] " ‘Net Appropriations Warrants “Approved by - [1100 Total Salary SS SS Eee Ee | [300 Travel Related Sg - Ee] [2100"Total Machinary & Equipment, Copia OWay $= _[$_-] isan | [AU Cher Expenses i [s__—] 5 S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 51 of 77 --- TOTAL OF SALES TAX REVENUE FUNDS COVERING THE PERIOD JULY 1, 2020 TO JUNE 30, 2021 Page 57 ESTIMATE OF NEEDS FOR 2021-2022 r EXHIBIT "I.ST" TOTALS P | Hess HOTAL ASSETS TF rrr r [Warrants Outstanding oes ee] Reserve for Interest on Warrants pg pr (ESTAL LIABILITIES AND RESERVES irri I [CASH FUND BALANCE JONE 30, 203] TS SS ORT : [TOTAL LIABILITIES, RESERVES AND CASH FUND BALANCE 15 Sen 0557] r [Cash Balance Reported to Excise Board June 30,2090 SS ES] r | Cash Fund Balance Transfered Out Sg [Cash Fund Balance Transferred ns [” [Ad Valorem Tax Apportioned To VearIn Capon r [Sources ofRevenue 0 op [2o0ofimteres, Mortgage Tax Ts es [s100fLocal Revenues Og Eg PP |s200}state Revenues { fp00[Rederal Revenues Tg as ft [9400[Miscellancous Revenues dS 6g 8 [2500|Special Assessments tg r [p600]Other Revenues Tg [pt0o|sehool Revenues [All Other Non-Tex Revenves TS pr (Bales Tax and Sales Tex Imerest S'S sg 58.8 SJ r [Cash Fund Balance Forward From Preceding Year SSCS a3 38'S] Prior Expenditures Recovered Sg POTAL RECEIPTS SS T'S r fntrest Paid Thereon SF r [Reserve for Warrants Outstanding TS 8S TRS [Reserve for Intereston Warrants YS SS pe Reserves From Schedule 8 rts r TOTAL LIABILITES ANDRESERVE SYS 294,522.29 8 [DBRT 8 ts c let Appropriations ‘Warrants ‘Approved b - [f200 Fringe Benefits 8 8S ts [1300 Travel Related SS fs ‘ r [110 Machinary & Equipment, Capital Outlay [$$ Ss Pr S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 October 04, 2021 l --- OCR page 52 of 77 --- Page 58 COURTHOUSE IMPROVEMENT SALES TAX COVERING THE PERIOD 7/1/2020 TO 6/30/2021 = ESTIMATE OF NEEDS FOR 2021-2022 7 LST-1305 COURTHOUSE IMPROVEMENT SALES TAX ] SSS 7 [Investments eS [ROTAL ASSETS S99] [Reserve forInterestonWarranfs CdS CY [Reserves From Schedule 307d 7 7 [CORRENTAND ALLPRIORYEARS Cd 00-2 —«d«zSCéPREDOD_| 7 | Cash Fund Balance Transferred Out "CdS CdS sd [_Cash Fund Balance TransferredIn SC CdS CS [Ad Valorem Tax Apportioned To YearInCaption dS CdS "7 [Sources of Revemue } [9100fLocal Revenues CdS CC CdS Cs |9200|State Revenues COC~dYSSCCCTC CdS CC ~*d 7 [9300 [Federal Revenues SC~*UCSC NTC «CSW SCC ~=*d |9400[Miscellaneous Revenues SC CdS Sd |9500|Special Assessments CdS CC CSC CS” = {9600]Other Revenues CdS TC CdS 7 [9700]School Revenues CSdSCCC«C*dSSCC~=*d JAN Other Non-Tax Revenues CdS CTC CdYSCC*d : [Sales Tax and Sales TaxInterest_ ——SSSSC~C~—CSCSCSCCSC‘C~C~C~;7<;7<S;<S;«dmSsék sd "| [Cash Fund Balance Forward From Preceding Year TS CS 6BOSZS Cd [Prior Expenditures Recovered SSCS SC «dS CCS [TOTAL RECEIPTS SCS aT BAT O'S 7 interest Paid Thereon CCS CSCS al [Reserve for Warrants Outstanding YS 12S CY [Reserve for ntereston Warrants SCS CdS C~SCS@Y [Reserves From Schedule CC~*dS CCS CCS” 7 [OTALLIABILITES ANDRESERVE SSCS CCS TTS SCS a SF 1 Net Appropriations ‘Warrants ‘Approved by fetta | ee | ee P1100 Total Salaries SS” [i200 Fringe Benefits SS dS [1300 Travel Related 7S ss : P200"Total Maintenance & Operations Sasa. |$ SS AIST §____- ssa. 588 1 7 [£100 Total Machinary & Equipment, Capital Outlay|[$ SSS SS dd [OTAL EXPENDITURES 2020-21 FISCAL YEAR|[$___1,452,728.63 8 S35,41391|8___- [$923,588.14 S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 7 --- OCR page 53 of 77 --- ROAD AND BRIDGES SALES TAX COVERING THE. PERIOD 7/1/2020 TO 6/30/2021 Page 59 ESTIMATE OF NEEDS FOR 2021-2022 r LST-1313 = mi 5 ROAD AND BRIDGES SALES TAX [Cash Balanees 7 as] r pavestmentS eee — oe r Reserve for Interest on Warrants rg Reserves From Schedule $s a] - I . (FOTAL LIABILITIES, RESERVES AND CASH FUND BALANCE] 59503 3018] L LIABILITIES, RESERVES AND CASH FUND BALANCE] r mm r | Gash Fund Balance Transferred Out SS ST |_Cash Fund Balance TransfemedIn dS [Adjusted Cash Balance dS 299 SS |S OTT] [Ad Valorem Tax Apportioned To YearIn Capon CS SY r [Sources of Revenue Tp [2100[Local Revenues YS [9200[State Revenues SS r |9300[Federal Revenues dS [9400[Miscellaneous Revenues id = 08SO S| |2500|Special Assessments SSS r |2600[Other Revenues dS [2700|School Revenues Ts JAI Other Non-Tax Revenues dS [Sales Tex and Sales Tax Interest SCC*dS 1,876, 8069 || SJ] r [Cash Fund Balance Forward From Preceding Year SSSSC*dSCSC=«CSBT-TS CY [Prior ExpendituresRecovered CdS CC CdS SSC~SCSY [OTALRECEIPTS 0 CCSC~*~—CSCSCSYS BG TORT TS SCSCSC*d r linterest Paid Thereon OF TCCC~C~dSS CC Cd SY r [Reserve for Warrants Outstanding YS 6068. 7SS Sd [Reserve forntereston Warrants CdS Sd CCS [Reserves From Schedule CdS CC«*8 SOLS C Sd r [TOTAL LIABILITES ANDRESERVE OU C«dS —i70,2068.31 19 ‘| 5 a SO ‘Net Appropriations, ‘Warrants ‘Approved by r [1100Total Salaries SS ee [1300 Travel Related 0S ss P #100 Total Machinary & Equipment, Capital Qutlay|[$" TS SSCS r S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 54 of 77 --- Page 60 RURAL FIRE SALES TAX COVERING THE PERIOD 7/1/2020 TO 6/30/2021 ESTIMATE OF NEEDS FOR 2021-2022 7 LST-1321 RURAL FIRE SALES TAX. 7 [investments EEE OO [Reserve for Interest on Warrants Ci” 7 al 1 | Cash Fund Balance Transferred Qut CSC OS i [Cash Fund Balance Transferred In dS dS id [Adjusted Cash Balance dS 30672170 TS 7,489.16 : |Ad Valorem Tax Apportioned To Yearin Caption CSC OSC Cd 4 [Sources of Revenue [9000]interest, Mortgage Tax CdS CBBC Cd |9100[Local Revenues CSS TC CS SC~=* [9200]State Revenues CCCCCC~*dS CdS” 7 [9300[Federal Revenues SCSC~*~‘iYS SCCSC*«i STIS CCSC—~* [2400 [Miscellaneous Revenues SCSC*dS CSCI SCS |9500|Special Assessments CSCS CdS CCSCC*@Y [9600|Other Revenues dS CdS [9700] School Revenues SS JAM! Other Non-Tax Revenues SS [Sales Tax and Sales Taxinterest TT C*dS aI Sd 7 (Cash Fund Balance Forward From Preceding Year SSSSSCS™S~C~SCSS~=C«S SSS J [Prior Expenditures Recovered OCS CSS [OTALRECEPTS SSS 0a 3 ‘ Hinterest Paid hereon dS ST (CASH BALANCE JUNE 30,2020 SSC iS 406,692 [TS 5309S] 7 [Reserve for Warrants Outstanding “dS SS [Reserve for Interest on Warrants dS [Reserves From Schedule 8 id S00 ITS 7 [fOTAL LIABILITES ANDRESERVE dS 2. 20.08 8 PEE T S [CASH BALANCE FORWARD TONEXT YEAR dS aon cs ge I'S 535 | ‘Net Appropriations ‘Warrants ‘Approved b fateiee | ee | ee ee [100 "Total Salaries SS ee 7 [1200 Fringe Benefits Ts fs [300 Travel Related Ss pS ot 7 100 Total Machinery & Equipment, Cepital Outlay[$ = SS JAN Other Expenses SS hs sh OTAL EXPENDITORES 2020-21 FISCAL YEARS 569,768.45 $197 01S 301181500 |S 704,503.58 | S.A. and I, Form 2631R01 Entity: Ottawa County, 58. ‘October 04, 2021 7 --- OCR page 55 of 77 --- TOTAL OF EXPENDABLE TRUST FUNDS COVERING THE PERIOD JULY 1, 2020 TO JUNE 30, 2021 Page 61 7 ESTIMATE OF NEEDS FOR 2021-2022 r EXHIBIT “M" TOTALS re ; [s— [° [Baran Ousteding 7, — rd Reserve for Interest om Warrants OTAL LIABILITIES AND RESERVES ri] r L [Cash Balance Reported fo Excise Board Tune 30,2020 SS 108 025] [° |Fessi Fund Balanes transfered Gs [Cash Fund Belance Transfered Jy S97 J fA Valorem Tex Apportioned To Year In Caption 8 as. 005 | [Sources of Revenue ER [povo]interest, Morgage Tax ase [9100{Loeal Revenues Is ino ™ 9 200fState Revenues Sar 8's r [9300}Federal Revenues dS 35,675.00 J [9400] Miscellaneous Revenues dS 23,695.00 |9300|Special Assessments d's 59.0 [° stolons Revenws gE [p700|School Revenues 3 [all Other Non-Tax Revenues i Sales Tax and Soles Tax Interest dS [°[Gscbfind Baars Forward From Peseding Yar} zr $$ ——] Pion ExpendituesRecovered iS OTALRECEPTS dS DTS eres Paid Thereon SY r [Reserve for Warrants Outstanding Sg Reserve for interest on Warranis dS Reserves From Schedule 8 —*d ST S O'S [ foraccasiires ap RESERVE sas perio ss ‘Net Appropriations farranis ‘Approved by [i200 Fringe Benefits SS SS SY ys00Travel Related dS eS Ss rr] [° fitoMastinay# asimen Cate Only —[S—"aosotor sg gs r S.A. and I. Form 2631R01 Entity: Ottawa County, 58 ‘October 04, 2021 --- OCR page 56 of 77 --- 5 | Page 62 COURT CLERK REVOLVING COVERING THE PERIOD 7/1/2020 TO 6/30/2021 - ESTIMATE OF NEEDS FOR 2021-2022 7 COURT CLERK REVOLVING M-7201 _ 7 favestments df [Reserve for interest on Warrants dS [Reserves From Schedule 0S 7 ] 7 | Cash Fund Balance Transferred Out dS ora [Cash Fund Balance Transferedin 22717 8 [Ad Valorem Tax Apportioned To Yearin Capon CS «dS Cd 1 [Sources of Revenue [s200|State Revenues ‘ [p300}Federal Revenwes dS [3400}Miscellaneous Revenues dS [9500] Special Assessments Js - [9600] Other Revenues gs | [2700|School Revenues dS [Al Other Non-Tax Revenues dS Sales Tex and Sales Tax Imerest tg ts 7 [Gash Fund Balance Forward From Preceding Year dS ' | [rior Expenditures Recovered POTAL RECEIPTS Ts ra ts] 7 [everest Paid Thereon Tg POTAL DISBURSEMENTS fs as rr] [CASH BALANCE JUNE 30,201 8 a 85 00) 1 [Reserve for Warrants Outstanding “SS Reserve for Interest on Warrants dS Reserves From Schedule 88 . [FOTAL LIABILITES AND RESERVE dS 1.1018 PERT SS ar (CASH BALANCE FORWARD TONEXT YEAR 8 aS J ; ‘Net Appropriations ‘Warrants “Approved by 200 Fringe Benefits Ts sr [1300 Travel Related SS 80's sa 000 Total Maintenance & Operations [$338,191.82 $_ 2030986] s | s——sao1771] 7 F100 Total Machinary & Equipment Capital Outlay|[$ 22,801.77 8 | $ [sor 7| JAN Other Expenses SS Ss oh [TOTAL EXPENDITORES 2020-21 FISCAL VEAR|S 4008508 ESTES —_—__-}s aaa] S.A. and I, Form 2631R01 Entity: ‘Ottawa County, 58 ‘October 04, 2021 a --- OCR page 57 of 77 --- CHILD ABUSE (MULTIDISCIPLINARY) PREVENTION COVERING THE PERIOD 7/2020 TO 6/30/2021 Page 63 f= ESTIMATE OF NEEDS FOR 2021-2022 r M-7202 CHILD ABUSE (MULTIDISCIPLINARY) PREVENTION (Schedule 1: Curent Balance Sheet - Tune 30, 202) r Pest se A [$7,452.89] i fananss Qustendigg L Reserve for Interest on Wamants Th Reserves From Schedule 3s ROTAL LIABILITIES AND RESERVES SE SE EREANR CASH FUND BALANCE Se r |_ Opening Balance fom Prior Year's aes. 09.18] r [eit rat ae Teste 2 of 7a l [_ Cash Fund Balance Transfered In 78 3.5 ——— PAsiusted Cash Balance SS JAd Valorem Tax Apportioned To Year In Caption Eg r Poourees of Revenue pr [2icofLoeal Revenues fs ig [9200)Stwte Revenues Os ss c [9300[Federal Revenues ts p2io0f Miscellaneous Revenwes ss J [2500] Special Assessments Os op r [ps00}Other Revenues 0s os [9700] School Revenues ss fall Other Non-Tax Revenues fs Beles Tex and Seles Tex Interests I r [Cash Fund Balance Forward From Preceding Year : rior Expenditwes Recovered Vf POTAL RECEIPTS ls a fs P® /POTAL RECEIPTS AND BALANCE Ts nas r [Warrants of Year in Caption 0g Eg Hoterest Peid Thereon gs [FOTAL DISBURSEMENTS fs r (CASH BALANCE JUNE 30, 2021 dS TS Reserve for Warrants Outstanding SQ Reserve for Interest on Warrants 0g a aes a Sec 2 |S Cie S =m r [FOTAL LIABILITES AND RESERVE fg > a ES (CASH BALANCE FORWARD TONEXT YEAR =i T'S ‘Net Appropriations: ‘Warrants Approved by r 200 Fringe Benefits sss gs [300 Travel Related ss 2000 Total Maintenance & Operations §_7as0aa [$= S's | r £100 Total Machinary & Equipment, Capital Outlay|[$ = S$ SY [TOTAL EXPENDITURES 2000-21 FISCAL YEAR||$ 745044 $$. |s_7.52.35] Pr S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 58 of 77 --- Page 64 ‘LAW LIBRARY COVERING THE PERIOD 7/1/2020 TO 6/30/2021 ESTIMATE OF NEEDS FOR 2021-2022 7 M-7205 LAW LIBRARY ASSETS 2 a [TOTAL ASSETS dS] [Warrants Outstanding dS 7 [Reserve for Interest on Warrants SOS SS [Reserves From Schedule 3S , [OTAL LIABILITIES AND RESERVES SSCS 4 7 |_Cash Fund Balance Transferred Out CSCS CdS CCS [_Cash Fund Balance TransfemedIn dS CdS [Adjusted Cash Balance dS TTS : |Ad Valorem Tax Apportioned To YearInCaption SSCS SC*dSCCSCSCSS*d 7 Sources of Revenue |9100[Local Revenues id a T'S - [9200[State Revenues SOS 7 [9300}Federal Revenues Sd CdS |2400[Miscellaneous Revenues YS [9500[Special Assessments SS 7 [9600[Other Revenues SS | |9700|School Revenues SS JAN Other Non-Tax Revenues YS SY [Sales Tax and Sales TaxInterest SS 7 [Gash Fund Balance Forward From Preceding Year SYS Sidi [Prior Expenditures Recovered dS FOTALRECEPTS SiS ac [TOTAL RECEIPTS AND BALANCE SSS 226.18 T'S 7 |Warrants of Yearin Caption CdS 13,787.52 8] interest Paid Thereon SS [TOTAL DISBURSEMENTS SSS ra [CASH BALANCE JUNE 30, 2021 iS aS 7 Reserve for Warrants Outstanding “IS SY : [Reserve for Interest on Warrants dS SY HOTAL LIABILITES ANDRESERVE Cid SZ PDB So [CASH BALANCE FORWARD TONEXT YEAR SSS 7.6] = Net Appropriations Warrants ‘Approved by a Baie [1200 Fringe Benefits T's ts [2300 Travel Related St tg oo 2000 Total Maintenance & Operations "|| $__ 21,358.17 |[$___13,78730 8. $a a7a.06] al [100 Total Machinary & Equipment, Capital Outly]$— = $$ TOTAL EXPENDITURES 2020-21 FISCAL YEAR|[$____ 2135917 ]18 13, 78730 8 1s 3 770] S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 al --- OCR page 59 of 77 --- DRUG COURT COVERING THE PERIOD 7/1/2020 ‘TO 6/30/2021 Page 65 r ESTIMATE OF NEEDS FOR 2021-2022 M-7206 a ce r r TS Reserve for Interest on Wamants TT F | Cash Fund Balance Transferred Out Cid r [_Cash Fund Balance Transfeme@In dS [Adjusted Cash Balance «dS BTS 1500] |Ad Valorem Tax Apportioned To Year In Caption SiS SY r [Sourees of Revenue |9100[Local Revenues CdS IS r [9200|State Revenues CdS CSCS |9300|Federal Revenues dS TS OOS Cid [2400[Miscellaneous Revenues CdS =i 625.00 SSC —=* [2500|Special Assessments SC SOS CCC*d [9600[Other Revenues OSC CdS [ |9700[School Revenues SS JAll Other Non-Tax Revenues dS dS (Sales Tax and Sales Tax Interest CSCC OdSSCSC~CCSC*@*d c [Cash Fund Balance Forward From Preceding Year SSIS CY [Prior Expenditures Recovered dS COSY [POTAL RECEIPTS STS TS CS [TOTALRECEIPTSAND BALANCE dS 7,088.16 [8 150.00 r [Warrants of YearinCaption S25 072.408 [interest Paid Thereon SS [TOTAL DISBURSEMENTS 25,072.40 r [Reserve for Warrants Outstanding SS [Reserve forIntereston Warrants WS OSC Cd [Reserves FromSchedule8 SCOTS CC r [TOTAL LIABILITESANDRESERVE SOS CS 2 | | | P ‘Net Appropriations ‘Warrants ‘Approved by r [100 Total Salaries SS [1200 Fringe Benefits Sg [1300 Travel Related SS ss r [4100 Total Machinary & Equipment, Capital Outlay[$ SS r S.A. and L Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 60 of 77 --- Page 66 COURT CLERK PRESERVATION COVERING THE PERIOD 7/1/2020 TO 6/30/2021 7 SSTIMATE OF NEEDS FOR 2021-2022 M-7210 a COURT CLERK PRESERVATION hedule I: Current Balance Sheet - June 30,2021 SST [S_ 23,072.35 | al [Investments OTs a STS [$23,072.35] [s [Reserve for Interest on Warrants [$= Reserves From Schedule 3 [se : (OTAL LIABILITIES AND RESERVES [sd 7 (CASH FOND BALANCE JUNE 30,2021 CS B0235 7 [CURRENTANDALLPRIORYEARS 20 «zt Opening Balance from Prior Year $ 8,964.50 |[$ 8,964.50 7 Cash Fund Balance Transferred Out [ss Cash Fund Balance Transferred In [se S Adjusted Cash Balance. [S_ 8,964.50 ][$ = — [Ad Valorem Tax Apportioned To Year In Caption Cs 4 a 9000]Interest, Mortgage Tax as |9100[Local Revenues CSCS. 14,107.85 [$= | |9200|State Revenues CdS OS 1 [9300[Federal Revenues CdS CC CdS CY Miscellaneous Revenues Ee | ee | 9500 a [ss [School Revenues a es All Other Non-Tax Revenues a Sales Tax and Sales Tax Interest [ss : (Cash Fund Balance Forward From Preceding Year a a [Prior Expenditures Recovered [ss ‘OTAL RECEIPTS $ 14107.85//$ SS -_—*d OTAL RECEIPTS AND BALANCE. $ 23,07235[$ iS 7 a es (OTAL DISBURSEMENTS a es [CASH BALANCE JUNE 30, 2031 5 20358 —~id 7 [Reserve for Warrants Outstanding [ssid [ss Reserves From Schedule 8 es “OTAL LIABILITES AND RESERVE es PERC es ASH BALANCE FORWARD TO NEXT YEAR [S$ 23,07235/8 id ‘Net Appropriations Tarrants ‘Approved by ‘otal for Ex; or Expenses July 1, 2021 Issued a EC 1200 Fringe Benefits a Se 1300 Travel Related eS ES Ce [2000 Total Maintenance & Operations $ 2196133[$__—-~‘|s_-]s 23,072.35 al 100 Total Machinary & Equipment, Capital Oullay[$ = _([$_____-_|s-] Li OTAL EXPENDITURES 2020-21 FISCAL YEAR| S 21961353 ‘isd 23,072.35 S.A. and I. Form 2631R01 Entity: Ottawa County, $8 ‘October 04, 2021 1 --- OCR page 61 of 77 --- INDIVIDUAL REDEMPTION COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 67 Pr rem ESTIMATE OF NEEDS FOR 2021-2022 | —————— 0 r s—_ [s—— Reserves From Schedule 3 eeshsXx¥ r S| (CASH FUND BALANCE JUNE 3 0202) r [ss 3557) [s—__133.37] r [ss t Ss es [s_ss7s id r [Ad Valorem Tax Apportioned To Year In Caption SYS] r a | a | | [ss r [9200]State Revenues dS dS [9300|Federal Revenues YS [ss [9500|Special Assessments dS dS r [ss ee ee [So ™ [SoS r [So [ss es | r [s__ 133.57 [sO es [ss [ss [s—_—— r [CASHBALANCEJUNE30,2021—C—“CS™C™C™CCCCCCCé«dCLC«SS’=s“(‘”tsSs~—C(‘iS C™~—“—~SC=C*@YdY [ss [sos [ss cr [se = [sos [S| t [Schedule 5: Individual Redemption Fund Summary of Expenses id ‘Net Aj ypriations ‘Warrants Approved by }} es ere ee ed ee [ a |e ee ee | Ss Ce r SS CC | Es es r S.A. and I Form 2631R01 Entity: Ottawa County, 58 ‘October 04, 2021 --- OCR page 62 of 77 --- Page 68 TAX REFUNDS COVERING THE PERIOD 7/1/2020 TO 6/30/2021 7 ESTIMATE OF NEEDS FOR 2021-2022 Ax M-7408 | [sh Balenoes ee POTAL ASSETS [Warrants Outstanding [Reserve for Interest on Warrants [Reserves From Schedule 30s [TOTAL LIABILITIES AND RESERVES dS 7 [CASH FOND BALANCE JONE 30,202] 7S [TOTAL LIABILITIES, RESERVES AND CASH FUND BALANCE 7S 7 [Cash Balance Reported to Excise Board June 30, 2020 SS | Opening Balance fomPriorYear IS SY al |_Cash Fund Balance Transferred Out ST 894s fs J | “Cash Fund Balance Transferred In S208 SS [Adjusted Cash Balance 005,854.90 ffs - [Ad Valorem Tax Apporioned To YearInCapton SS | 7 Sources of Revenue 00 |9000]interest, Mortgage Tax 0 |9100[Local Revenues Ss |9200{State Revenues ss [9300]Federal Revenues IS [2400 [Miscellaneous Revenues SS 12500|Special Assessments SS 7 [2600{Other Revenues Ts ts [9700] School Revenues ss JAll Other Non-Tax Revenues TS [Sales Tax and Sales Tax Interest SS 7 [Cash Fund Balance Forward From Preceding Year SY Prior Expenditures Recovered SS Sd OTAL RECEIPTS fs ts fOTAL RECEIPTS AND BALANCE «dS 858.903 1 [Warrants of Yearin Caption 00 «dS 8858.90] interest Paid Thereon Ss [fOTAL DISBURSEMENTS fs 5850s 7 [CASH BALANCE JUNE 30,2001 SS 7 Reserve for Warrants Outstanding IS Reserve for Interest on Warrants fs = [Reserves From Schedule 8 SYS 7 [FOTAL LIABILITES AND RESERVE gg > PRET SS [CASH BALANCE FORWARD TO NEXT YEAR 8 _ _ 7 let Appropriations ‘Warrants ‘Approved by }200 Fringe Benefits $s [$300 Travel Related ss ss 2000 Total Maintenance & Operations [$15 85490|[$_ 15, 85890$____- [3] 7 [2100 Total Machinary & Equipment, Capital Oullay|[$ = SS [Al Other Expenses Ss ts [TOTAL EXPENDITURES 2020-21 FISCAL YEAR] $__15,85450/[8 15,8490]. [s-_] S.A. and I, Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 7 --- OCR page 63 of 77 --- EMERGENCY TRANSPORTATION REVOLVING COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 69 ESTIMATE OF NEEDS FOR 2021-2022 r M-7506 _ EMERGENCY TRANSPORTATION REVOLVING Gash Balances ae r bees re r Warrants Qustnding os? Reserve for Interest on Warants r [Pest Balance Reported to Excise Board June 30, 2030S 300 00000] r [Cash Fund Balance Trnsfened Out Tg ners { |_ Cash Fund Balance Transfered Ia 0S PAdjusted Cash Balance YS SETS SETS] . [Ad Valorem Tex Apportioned To Year In Caption St r fSourees of Revenne Op [9100{Loeal Revenues 0s hs [2200{State Revenues dS 995 000-0 TS |9300[Rederal Revenues tg [peop bisellaneous Revenues 8 ts |2500[Special Assessments TS [° [soolouer Revewes pg |9700|Schoot Revenues dS [All Other Non-Tex Revenues 00s ps Stes Tax and Sales Tax Interest Ss r [Gash Fund Balance Forward From Preceding Year SYS © [tion Expenditures Recovered 0 sg OTAL RECEIPTS Os 795 p00.00 8] linterest Paid Thereon Sg r [CASH BALANCE JUNE 30,2021 dS 99, =| [Reserve for Warrants Outstanding 00000 [Reserve for Interest on Warrants S'S pi Reserves From Schedule 8s eran 50 [ss c [TOTAL LIABILITES AND RESERVE 0's 8.721.903 [DERI TS Ss [CASH BALANCE FORWARD TONEXT YEARS BOSSCATIIS Cd r Net Appropriations Warrants ‘Approved b: a a Bil r [F100 "Total Salaries [1200 Fringe Benefits 0 Ss [1300 Travel Related Ss ss ‘ c [2100 Total Machinary & Equipment, Capital Oulay[ $= SS Jal Other Expenses Os Ss Ss r SA. and I. Form 2631ROI Entity: Ottawa County, 58 ‘October 04, 2021 --- OCR page 64 of 77 --- Page 70 CHANGE FUND COVERING THE PERIOD 7/1/2020 TO 6/30/2021 ESTIMATE OF NEEDS FOR 2021-2022 7 M-7508 CHANGE FUND al [investments ———_——_—_—_—_—_—_—_—<—<—< —— [Warrants Outstanding [Reserve forlntereston Warrants [Reserves From Schedule 30s [TOTAL LIABILITIES AND RESERVES dS dt 7 7 [Cash Balance Reported to Excise Board Tune 30, 2020 Ss 10000 || Opening Balance fromPriorYear ss CCSC*C“‘CS*CSS:~SC*C*‘#dUOOWOCOTYUS—=i00.00} 7 | Cash Fund Balance Transferred Out ST [_Cash Fund Balance Transferred In SS [Adjusted Cash Balance 0 100.00 = [Ad Valorem Tax Apportioned To YearIn Caption TS Sid 7 [Sources ofRevenue |9000finterest, Mortgage Tax TS CdS [9100[Local Revenues ST [9200|State Revenues Sg 1 [9300[Federal Revenues CISC CdS CC Cdr |2400[Miscelianeous Revenues IS SCS [9500|Special Assessments TS CSS [9600]Other Revenues IS Sd 1 |9700|School Revenues IS CSC Cd” [All Other Non-Tax Revenues SC CdS CC ~=*@d [Sales Tax and SalesTaxInterest SC SCC” 7 (Cash Fund Balance Forward From Preceding Year SCC CdS CSCS [Prior Expenditures Recovered IS Sid [OTAL RECEIPTS IS [fOTAL RECEIPTS ANDBALANCE CdS tS id 7 |Warrants of YearinCeption CSS CdS limerest Paid Thereon_— dS FPOTAL DISBURSEMENTS dS ICASH BALANCE JUNE 30,2027 dS 10000] 7 [Reserve for Warrants Outstanding SC CdS : [Reserve for Interest on Warrants dS dS [Reserves From Schedule8 OCS SS 7 [OTAL LIABILITES ANDRESERVE CSS CC CdS CY a E(k | (CASH BALANCE FORWARD TONEXTYEAR SSS 100008 J] 7 a bee ay Bee Be —— re 1, 2021 Issued [__Reseres [cunt Beste Pua [1200 Fringe Benefits "SS dS SC CdS [1300 Travel Related TS SS fs [2000 Total Maintenance & Operations [$100.00 [sis is 1900.00 al [£100 Total Mackhinary & Equipment, Capital Oulay[$ = (i$ - _|'s___-|s_-_] JAl Other Expenses SS oo [POTAL EXPENDITURES 2020-21 FISCAL YEAR||$_____100.00[$__-_|s___-_[$ 10000 $.A. and I. Form 2631R01 Entity: Ottawa County, 58 ‘October 04, 2021 7 --- OCR page 65 of 77 --- EDUCATIONAL TRUST COVERING THE PERIOD 7/' 1/2020 TO 6/30/2021 Page 71 r ree ESTIMATE OF NEEDS FOR 2021-2022 SSS Pr r [Warants Outstanding smh Reserve for Interest on Warrants Reserves From Schedule $e TOTAL LIABILITIES AND RESERVES VES AND CASH FUND BALANCE r [Cash Balance Reported to Excise Board June 30, 2090 YS | Opening Balance fiom Prior Year Sg r | Cash Fund Balance Transferred Out IS |_Cash Fund Balance Transferred In dS JAdjusted Cash Balance IS jAd Valorem Tax Apportioned To Year InCaption dS ~C*dS r [Sources of Revenue Ep [9100fLocal Revenues dS 07 150.0 SY r |9200|State Revenues dS [9300[Federal Revenues dS d's |2400[Miscellaneous Revenues CdS dS = [9500|Special Assessments CdS CSCSC*@Y r [9600]Other Revenues SSS [9700|School Revenues SC dS JAll Other Non-Tax Revenues dS CC CdS [Sales Tax and Sales Tax Interest CdS CCC CdS CC*@Y r [Cash Fund Balance Forward From Preceding Year SC SCC Cd [Prior Expenditures Recovered SCC CdS TC C*d FPOTALRECEIPTS 7150.00 s—— [TOTAL RECEIPTS ANDBALANCE TS 17,150,008 Sd |Warrants of YearinCaption CdS 00S linterest Paid Thereon [TOTAL DISBURSEMENTS CdS SCOTTY Cid r [CASH BALANCE JUNE 30,2021 dS SOS di [Reserve for Warrants Outstanding SOS [Reserve forIntereston Warrants 0S SSC Sd pr [Reserves From Schedule @ dS r [POTALLIABILITESANDRESERVE ST SC «Sd 5 | | [CASH BALANCE FORWARD TONEXT YEARS ISOS | t ‘Net Appropriations farrants ‘Approved b: [ 200 age Bese; |, ———, ——_,, ——J [1300 TravelRelated SS SC TY [ [2000 Total Maintenance & Operations _i|S_ 17,150.00 /[$ 6,000.00 $= S11, 150.00| r Fg Tot Machinary & Bauipinent, Cepial Owlay[$ = Ss JA Other Expenses 0 Ss [TOTAL EXPENDITURES 2020-21 FISCAL YEAR|[$ ___17,150.00][$____6,00000|/S =~ ~'i[S 11,130.00] r S.A. and L. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 66 of 77 --- Page 72 INDEPENDENT SCHOOL REMIT COVERING THE PERIOD 7/1/2020 TO 6/30/2021 7 ESTIMATE OF NEEDS FOR 2021-2022 INDEPENDENT SCHOOL REMIT M7702 _ (asbBalmees a | [Warrants Outstanding OCS CS [Reserve forlntereston Warrants C*dYS TC *C*d [Reserves From Schedule 30d (ROTAL LIABILITIES AND RESERVES SCSCSCSCSCSCSCSC“‘dCSC“SCSC~C*~=*@ds 7 7 (CURRENT AND ALL PRIORYEARS dT —s«SPREDODO_|| 7 | Cash Fund Balance Transferred Out CdS CdS CY [Cash Fund Balance Transferred In S—~didS dS [Adjusted Cash Balance dS SYS Sd |Ad Valorem Tax Apportioned To YearIn Caption CdS 10,852,228 YTS id | [Sources of Revenue |9000}interest, Mortgage Tax SSCSCSCSC*dS a a8 |S |9100[Local Revenues TSS SSIS |9200|State Revenues SSCS aS 7 [2300 [Federal Revenues dS Sd [2400[Miscellaneous Revenues dS [2500|Special Assessments S'S [2s00fOther Revenues St [2700[Sehoo! Revenues ts [All Other Non-Tax Revenues Ts os [Sales Tax and Sales TaxInterest SSCS Tax and Sales Tax Interest [sCsCd [ssid 7 [Cash Fond Balance Forward From Preceding Year [Prior Expenditures Recovered dS (OTAL RECEIPTS 0S rs. TS fOTAL RECEIPTS AND BALANCE S$ 1.198,096554 |] " [Warrants of Year in Caption 00s rsa zg t's] [interest Paid Thereon Sg OTAL DISBURSEMENTS ~~ osc CASH BALANCE TONE 30, 2001 8 08 006.08 FS | 7 [Reserve for Warrants Outstanding "TT Reserve for Interest on Warrants tg Reserves From Schedule 8 I 4 [TOTAL LIABILITES AND RESERVE tJ J i [DEPICT es [CASH BALANCE FORWARD TONEXT YEAR [8 105,006.08 3 ——— - ehedule 9: Independent School Remit Fund Summary of Expenses ] Net Appropriations Warrants: ‘Approved b: i [200 Fringe Benefits ss tf oh [300 Travel Related 8s 200 Total Maintenance & Operations TS § 7 100 Total Machinery & Equipment Cepial Outlay $$ 3} ——_ ROTAL EXPENDITURES 2000-21 FISCAL YEAR| $ 11,198,496.54 |S —11,093,450.46| 8 s-_—10 0608] S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 7 --- OCR page 67 of 77 --- MUNICIPAL-CITY-TOWN REMIT COVERING THE PERIOD 7/1 1/2020 TO 6/30/2021 Page 73 Pr ESTIMATE OF NEEDS FOR 2021-2022 M-7703 MUNICIPAL-CITY-TOWN REMIT G r oo ———— Pavesi [S514 92 r [Warrants Outstanding oS rer] Reserve for Interest on Warrants Reserves From Schedule $d [FOTAL LIABILITIES AND RESERVES TS rer] r [CASH FUND BALANCE JUNE 30,2021 ig a a] r r | Gash Fund Balance Transferred Out TS [_ Cash Fund Balance Transferred In 7S J [Ad Valorem Tax Apportioned To Year InCaption YS P Bourees of Revenue fp [2100 [Local Revenues fs hs cr [2200|State Revenues dS p05 |S [2300}Federal Revenues fs [2400)Miseellaneous Revenues dS |2500[Special Assessments dS LOS r [2600}Other Revenues SS [2700|School Revenues SS JAll Other Non-Tax Revenues 0S SS) | RN] | TE r [Cash Fund Balance Forward From Preceding Year S178 [Prior Expenditures Recovered dS [TOTAL RECEIPTS dS 598058 .— |ibterest Paid hereon SF r [CASHBALANCEJUNE 30,2000 SCOC~CSCSCSCSCSCCSCSCSCSCSCSY BALANCE JUNE 30, 2021 [S$ S1AIL92$ _—_—+176.67| [Reserve for Warrants Outstanding 0S CSS [Reserve for Intereston Warrants dS S'S P JReserves From Schedule $d Cid SY r [POTAL LIABILITES ANDRESERVE SSSSCSCSCSCS~*dYCS SCS TTS 5 FE | c Net Appropriations Warrants ‘Approved by - r [1100 otal Salaries SS [1200 Fringe Benefits SS gs [1300 Travel Related SSS 2000 Total Maintenance & Operations [$= SS SCC CdS c [4100 Total Machinary & Equipment, Capital Qutlay[$ = S'S «dS CSC ~—<idZS [TOTAL EXPENDITURES 2020-21 FISCAL YEARS 411,142.83 [5 360,124.29 - 8 31.411.92| P ‘S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 68 of 77 --- "| Page 74 EMERGENCY MEDICAL SERVICE DISTRICT (EMS-522) REMIT COVERING THE PERIOD 7/1/2020 TO 6/30/2021 tl ESTIMATE OF NEEDS FOR 2021-2022 ' M-7704 EMERGENCY MEDICAL SERVICE DISTRICT 3-522) REMIT :) ASSETS) eee [investments [TOTAL ASSETS dS | [LIABILITIES AND RESERVES: C—S—C—SY 4 [Warrants Quistanding 0 CSCSdSS CY J [Reserve for Interest on Warrants SYS Reserves From Schedule 30S [TOTAL LIABILITIES AND RESERVES CSCC Cid 7 ” 7 |_Cash Fund Balance Transferred Out CdS CdS C*' [_Cash Fund Balance Transferred In dS TC CdS ~=*d [Adjusted Cash Balance dS YS id : JAd Valorem Tax Apportioned To YearInCaption SC«*dCS 558,287.68 $id | [Sources of Revenue CS [9100[Local Revenues 0 SCSC~*dC‘S C~C*«tS«OSL ITS SSCS [9200|State Revenues CSCSC~*UYSSS CBS CS al [9300[Federal Revenues CC~*dS NCCC CCC—C*d [9400[Miscellaneous Revenues C«dS CCC CCS [9500|Special Assessments C*ddS CTC C*dS CY 7 [9600[Other Revenues C*dS CC CdS Sd [9700]School Revenues CdS dS” JAI Other Non-Tax Revenues CdS CdS C*d [Sales Tax and Sales Tax Interest CdS CCS CC*@Y 7 (Cash Fund Balance Forward From Preceding Year SSSCSCSCSC~dSSSSCSCSCidS CSCC SY [Prior ExpendituresRecovered TT CCCSC*dYS‘S SSCS CdS CCS~*Y (OTAL RECEIPTS C*diS 58S T'S [TOTAL RECEIPTS ANDBALANCE TT SSSSSCSC~*dSS 567,606.60 " [Warrants of Year inCaption TT SSC*dS i 0. interest Paid Thereon Sg [POTAL DISBURSEMENTS YS 50 T_T |S ICASH BALANCE JUNE 30,202) SSCS «T'S 1 [Reserve for Warrants Outstanding dS FReserve for Interest on Warrants SYS [Reserves From Schedule 8 CSS 7 [TOTAL LIABILITES ANDRESERVE SSCS a EE |E [CASH BALANCE FORWARD TONEXTYEAR CSCS T'S 7 ‘Net Appropriations Warrants ‘Approved by feats | ee ee 1 [1200 Fringe Benefits SS [1300 Travel Related SS [2000 Total Maintenance & Operations 8S dS SC YY 7 [2100 Total Machinary & Equipment, Copital Outlay|[$______-_[$_____-_]s_-]s__-_] [TOTAL EXPENDITURES 2020-21 FISCAL YEAR| $567,606.60 [$ 363,423.07 8 [84.183 33 5 S.A. and I. Form 2631R01 Entity: Ottawa. County, 58 October 04, 2021 } --- OCR page 69 of 77 --- CAREER TECH REMIT COVERING THE PERIOD 7/1/2020 TO 6/30/2021 Page 75 r rey ESTIMATE OF NEEDS FOR 2021-2022 r paves —_————— 0 r [Warrants Outstanding [Reserve for Interest on Warrants IR [Reserves From Schedule 3 (TOTAL LIABILITIES AND RESERVES dS r F r | Cash Fund Balance Transferred Qut CdS CC CSC Cd |_Cash Fund Balance Transferred In dS CCS CCCS~=*d JAdjusted Cash Balance CdS SBS Sd r [Ad Valorem Tax Apportioned To YearInCaption 7 SC*dS CRD TS CC —=*d [Sources of Revenue |9000}interest, Mortgage Tax CSC CdS CSdr [9100[Local Revenues dS RSIS id r [9200[State Revenues 0s 80.60 [8 |9300]Federal Revenues SC CS CC Cid |9400|Miscellaneous Revenues 0S [9500|Special Assessments r |9600]Other Revenues dS «Sd [9700|School Revenues Ss JAN Other Non-Tax Revenues YS Pr [Sales Tax and Sales Tax Interest Ss r [Cash Fund Balance Forward From Preceding Year SS [Prior Expenditures Recovered 0S [TOTAL RECEIPTS 2,044, 847.60 [ST r [TOTAL RECEIPTS AND BALANCES 2, 060,864.46 [$= [Warrants of Year in Caption NS, 045, 599.86 [$= interest Paid Thereon Ss TOTAL DISBURSEMENTS aes r ICASH BALANCE JUNE 30,2021 CS 1526S id [Reserve for Warrants Outstanding 00 [Reserve forIntereston Warrants [Reserves From Schedule $s r [TOTAL LIABILITES ANDRESERVE ST 5 | | [CASH BALANCE FORWARD TONEXT YEARS 15,264.60 [S| c | [1100 Total Salaries SS ‘ [1200 Fringe Benefits Sg [1300 Travel Related 0S Ss [2000 Total Maintenance & Operations SSS r |4100 Total Machinary & Equipment, Capital Outlay $7; Ss Ss [All Other Expenses dS 2,060, 864.46 |S 2,045,599.86 [SS 15,264.60 | [TOTAL EXPENDITURES 2020-21 FISCAL YEARI[$_2,060,864.46[$_2,045,599.86|[$ = TS _*15,264.60] r S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 \ --- OCR page 70 of 77 --- Page 77 r Statement of Receipts, Disbursements, and Changes in Cash Balances Exhibit W r ~ ‘Beginning Ca Receipts 7 Ending Cash County Funds | “Balance uly 1_||_Apportionea | Tass n | Transfers Out - [Exhibit A WS 1,244,556.36 [8 4,701,740.25 | $ 862,522.70 [$0.04 [$3,979,145.03 |S 2,829,674.24 | r Exnibit soos” ooofs 0.00/18 000s 000s 0.00] [ExhibitD iS ___1,568,258.16 || $_2,476,116.66 || $170,803.92 |S 3,700.34 $_2,626,743.87 [Exhibit ___ fs 24,227.91 [$288,858.38 [$s 0.00|$ 0.00 || § _177,780.45 1S 395,305.84 f otal BxnibitG’s [§ aal[s 0.00 [8 o.00ffsaaiis 0001s 0.00] $ ooolfs 000s coos ons 0.00] : $_1,332,722.64 $28,800.95 || $ 910,115.23 ‘otal Exhibit ST's |[$ _3,159,478.89 [s_ 0.00 [s 0.00 |[ $_1,730,032.40[$ _3,960,469.91 r |s_ ooo l[s" oo [s 000s o.00]'s soos o.oo $ o.00l's 000 |[s 0.00 [$0.00 ffs o.00/$____0.00] [s____o.oolfs_o.00[s 000s 0.00] [s__ 0.00] r $___1,086,025.79 |[ $ 15,007,056.92 $ 150,929.59 |[ $ 15,074,826.90 P S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 t --- OCR page 71 of 77 --- Page 79 ee r Calculation of the Maximum Budget available using the Estimated Valuations, Miscellaneous Revenues, and Carryover r Exhibit X [General Fund Mill Ley 0 JO [Total Estimated Assessed Valuation $___186,070,893.00 [7 $ 1,905,365.94 [OV Reserve for Delinquency Reserve Percentage] 10%| $ 173,215.09 [dS INet Ad Valorem Tax 3 1,732,150.85 [TS 1,732,15085 | a Cash fund balance. June 30 $ 2,210,999.98|$ 321,576.10 | $ 2,532,576.08 r $ 2,639,200.68[$ 0.00 $ 2,639,200.68 a [Total Available for Appropriations "TS 6,582,351.518 32,576.10 5 6,503,927.61 P S.A. and I Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 72 of 77 --- Exhibit “Y” Page 81 r CERTIFICATE OF EXCISE BOARD r ESTIMATE OF NEEDS FOR 2021-2022 STATE OF OKLAHOMA, COUNTY OF OTTAWA. r We, the members of the Excise Board of said County and State, do hereby certify that we have examined the foregoing lestimates of proposed current expenses for the ensuing fiscal year as filed with the Board of ‘County Commissioners, and those directly under, or in contractual relationship with, the Board of County Commissioners; we have ascertained from the Financial r [Statements submitted therewith the amount of Surplus Balances of Cash on Hand; we have considered the uncollected ad ivalorem taxes of the previous year or years; and we have ascertained that the probable Income estimated to be collected from all| lsources other than ad valorem taxation may reasonably be expected as a revenue for the ensuing fiscal year, and that the same r \does not exceed 90% of the actual collection from such sources for the previous fiscal year. r lin so doing, we have diligently performed the duties imposed upon the Excise Board by 68 O.S. 1991 Section 3007, (1) jascertaining that the financial statements, as to statistics therein contained reflect the true fiscal condition at the close of the fiscal year, or caused the same to be corrected so to show; (2) struck from the estimate of needs so submitted any items not r lauthorized by law and reduced to the sum authorized by law any items restricted by statute as to the amount lawfully lexpendable therefore; (3) supplemented such estimate, after proper publication, by an estimate of needs prepared by this Excise |Board to make provision for mandatory governmental functions where the estimate submitted wholly failed or was deemed Pr jinadequate to fulfill the mandate of the Constitutions or of the Legislature; (4) computed the total means available to each fund lin the manner provided; and (5) then and only thereafter. |Accordingly, we have and do hereby appropriate the Surplus Balances of Cash on Hand, and the Revenues and Levies lhereinafter set forth for each Fund to the several and specific purposes named in such estimates, by each, to the intent and r Ipurpose that CONSTITUTIONAL GOVERNMENTAL FUNCTIONS shall be first assured and provided for, and subsequently 0 provide for Legislative Governmental Functions insofar as to the available Surpluses, Revenues and Levies will permit; and lwe have provided also that the Levies are in excess of the amount appropriated to needs after deducting the surplus cash r jbalance on hand, and Estimated Revenues other than tax, by the percentage and amount or reserve for delinquent tax as lhereinafter set forth, which we have determined in the manner provided by law. [ |We further certify that we have examined the within statements of account and estimated needs or requirements of the Governing Board of Ottawa County, in relation to the Sinking Fund or Funds thereof, r land after finding the same correct or having caused the same to be corrected pursuant to 68 O. S. 1991 Section 3009, have lapproved the requirements therefor to fulfill the conditions of Section 26 and 28 of Article 10, Oklahoma Constitution, and lhave made and certified a tax levy therefor to the extent of the excess of said total requirements over any other legal deduction, r lincluding a reserve of caused the same to be corrected pursuant to 68 O. S. 1991 Section 3009, have approved the requirements ierefor to fulfill the conditions of Section 26 and 28 of Article 10, Oklahoma Constitution, and have made and certified a tax llevy therefor to the extent of the excess of said total requirements over any other legal deduction, including a reserve for r delinquent taxes. r S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 73 of 77 --- CERTIFICATE OF EXCISE BOARD "= ESTIMATE OF NEEDS FOR 2021-2022 . (County Excise Board's Appropriation General Pad basimen | cos, Honeexsy [so ao = [so [ss [Shi Sar Se es lige 7 eS ES | ise eae iiss [sos _ (ss aa [Sse = We further certify that the net assessed valuation of the Property, subject to ad valorem taxes, after the amount of all Homestead Exemptions have been deducted in the said County as finally equalized and certified by the State Board of Equalization for the current year . 2021-202 is as follows: Ec a - and that the assessed valuations herein certified have been used in computing the rates of mill levies and the proceeds thereof appropriated as aforesaid; and that having ascertained as aforesaid, the aggregate amount to be raised by ad valorem taxation, we thereupon made the levies _ therefor as provided by law as follows: = eee Free Fair Budget Account (Levy Per Applicable Statute) 0.00 Mills; Free Fair Improvement Budget Account (Net Proceeds of 1.00 Mill) 0.00 Mills; Free Fair Additional Improvement Budget Account (Net Proceeds of 1.00 Mill) 0.00 Mills; . Library Budget Account (Net Proceeds of 1/2 of 1.00 Mill) 0.00 Mills; Cooperative County/City-County Library Budget Account (1.00 to 4.00 Mills) 0.00 Mills; County Cemetery (Prior To Aug. 15, 1933) Budget Account (Net Proceeds of 1/5 of 1.00 Mill) 0.00 Mills; Public Buildings Budget Account (Not To Exceed 5.00 Mills) 0.00 Mills; 7 Emergency Medical Service ( Not To Exceed 3.00 Mills) 3.07 Mills; Total County Levies 14.85 Mills; County Wide Levy For Schools (4.00 Mills) 4.10 Mills; ~ Total County Wide Levy 18.95 Mills; | $$ eee and we do hereby order the above levies to be certified forthwith by the Secretary of this Board to the County Assessor of said County, in order that the County Assessor may immediately extend said levies upon the Tax Rolls for the year 2022 without regard to any protest that 7 may be filed against any levies, as required by 68 O. S. 1991, Section 2869, eae 2 cith, ‘ Dated at__YQ\ a eos, Oklahoma, this 9°" Yay of ( Yo}-olber 2021, Excise Board Mgfyber ( : 4 iS Board Chairmen KR F as Blouin Mikhst Excise Board Membér i Ken A Excise Board Secretary our - S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 cy “) October 04, 2021 Na . S.A. and I. Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 74 of 77 --- Page 83 r Ottawa County, 58 Statistical Data 2020-2021 Total Gross Valuation Real Property $ 135,124,444.00. r {Total Homestead nption $ 8, 128,343.00 (Total Personal Property $ 26,349,791.00 [Total Public Service Prop $ 32,725,001.00 [Total Valuation of Property S$ _____186,070,893.00 r S.A. and I, Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 75 of 77 --- PUBLICATION SHEET - OTTAWA COUNTY, OKLAHOMA FINANCIAL STATEMENT OF THE VARIUS FUNDS FOR THE FISCAL YEAR ENDING JUNE 30, 2021, AND ESTIMATE OF NEEDS FOR THE FISCAL YEAR ENDING JUNE 30, 2022, OF THE GOVERNING BOARD OF OTTAWA COUNTY, OKLAHOMA Exhibit *Z” Page 85 STATEMENT OF FINANCIAL CONDITION General Health Fair Board AS OF JUNE 30, 2021 Fund Fund [ ASSETS) Cash Balance June 30, 2021 s 2,829,674.24 |S 395,305.84 [$s |_Investments Ss [___TOTALASSETS SSCSC~—SCSCSCSLS 2,829,674.24 || S 395,305.84[S SC —=s«d LIABILITIES AND RESERVES: Se REE ee $ 96,168.05 || '$ 19,278.85 [ss [so Reserves from Schedule 8 3 200,930.11 || $ 29,743.40 TOTAL LIABILITIES AND RESERVES |S 297,098.16 |S 0225S SC —*d CASH FUND BALANCE (Deficit) JUNE 30, 2021|[ S 2,532,576.08 || $ 346,283.59$ Cid a PA A /ESTIMATE OF NEEDS FOR FISCAL YEAR ENDING JUNE 30, 2022 Grand Total Current Expense Needs 3 6,903,927.61 || $ 606,782.84]S CSCS Reserves for Interest on Warrants & Revaluation Ss s 6,903.927.61 |[$ 606,782.84 [S| [FINANCE Cash Fund Balance $ 2,532,576.08 || S 346,283.59 Revenues Approved by Excise Board 3 2,639 200.68 Total Deductions 3 3,171,776.76 |S 346,283.59 [__Balance to Raise from Ad Valorem Tax [S$ L732,130.85][S_ 260,099.25] CERTIFICATE - GOVERNING BOARD STATE OF OKLAHOMA, COUNTY OF OTTAWA, ss: We, the undersigned duly elected, qualified Governing Officers of Ottawa County, Oklahoma, do hereby certify that at a meeting of the Governing Body of the said County, begun at the time provided by law for Counties and pursuant to the provisions of 68 O.S. 1991 Sec. 3002, the foregoing statement was prepared and is true and correct condition of the Financial Affairs of said County as reflected by the record of the County Clerk and Treasurer. We further certify that the forgoing estimate for oun a expenses for the fiscal year beginning July 1, 2021, and ending June 30, 2022, as shown are reasonably necessary for sie rope hig conduct of the affairs of the said County, that the Estimate Incometo be derived from sources other thatn ad valorem faXation~ 35 8 does not exceed the lawfully authorixed ration of the revenue derived from the same sources during the preceeding fied! Vea} oy Nye ‘A I We awy: : SS Wy _ oe, e ss Chairman of Board Covhty Cle Seal Lge Subscribed and swom as before me this ‘onffmissioner th, a ~~ D5 ~ aay of NC ol yee » 2021 / ( ib c- b » t, fAr~ | r_S Le~_ Be a = cs 7 ‘Notary Public im = mene to ; CAL. ct ; ‘OFFICIAL SEAL Cane L. MAYS Sate: NATASHA Lots NOTARY PUBLIC OKLAHOMA oat ‘OTTAWA COUNTY S.A. and I. Form 2631RO1 Entity: Ottawa County, 58 ‘ COMM. NO. 1 --- OCR page 76 of 77 --- FF PUBLICATION SHEET - OTTAWA COUNTY, OKLAHOMA FINANCIAL STATEMENT OF THE VARIUS FUNDS FOR THE FISCAL YEAR ENDING JUNE 30, 2021, AND ESTIMATE OF NEEDS FOR THE FISCAL YEAR ENDING JUNE 30, 2022, OF THE GOVERNING BOARD OF = OTTAWA COUNTY, OKLAHOMA Exhibit “Z” Page 85 STATEMENT OF FINANCIAL CONDITION General Health Fair Board IAS OF JUNE 30, 2021 Fund Fund Eg | ASSETS: Cash Balance June 30, 2021 $ 2,829,674.24 |S. 395,305.84 | Tavestments ST [se . [___TOTAL ASSETS «dS 2,829,674.24 |S 395,305.84 LIABILITIES AND RESERVES: S| | $ 96,168.05 || $ 19,278.85 [$= [so - Reserves from Schedule 8 3 200,930.11 || $ DABS Cid TOTAL LIABILITIES AND RESERVES |S 297,098.16 || S ,02.25|8 SSS —*d CASH FUND BALANCE (Deficit) JUNE 30, 2021][ $ 2,532,576.08 || S 346,283.59 RE Es ee ee al ESTIMATE OF NEEDS IFOR FISCAL YEAR ENDING JUNE 30, 2022 Grand Total Current Expense Needs $ 6,903,927.61 || $ 606782845 Cd = Reserves for Interest on Warrants & Revaluation. [so Total Required 3 6,903,927.61 || S 606,782.84 S ——S—~*d JEINANCED = ‘Cash Fund Balance Ss 2,532,576.08 || $ 346,283.59/1$ CS a Revenues Approved by Excise Board 5 2,639,200.68[S_ _—- | Ss 3,171,776.16 || S 346,285.59, CERTIFICATE - GOVERNING BOARD STATE OF OKLAHOMA, COUNTY OF OTTAWA, ss: FE We, the undersigned duly elected, qualified Governing Officers of Ottawa County, Oklahoma, do hereby certify that at a meeting of the Governing Body of the said County, begun at the time provided by law for Counties and pursuant to the provisions of = 68 O.S. 1991 Sec. 3002, the foregoing statement was prepared and is true and correct condition of the Financial Affairs of said Z0° = = County as reflected by the record of the County Clerk and Treasurer. We further certify thatthe forgoing estimate for current/</” S expenses for the fiscal year beginning July 1, 2021, and ending June 30, 2022, as shown are reasonably necessary for the progigr % conduct of the affairs of the said County, that the Estimate Incometo be derived from sources other thatn ad valorem taxatio} WA * B does not exceed the lawfully authorixed ration of the revenue derived from the same sources during the preceeding fiscal yea," ] \907 y; _ * » Wie ¢ \ r Chairman of Board 5 CountyClerk Seal Ec : Subscribed and sworn as before me this Céminigsionei ie a OS tay of C Soteloe yo, 2021. 1 - buy MASste— 2u. Cor pisos 7 ( Notary Public p We@th feAUC Ee = S.A. and I, Form 2631R01 Entity: Ottawa County, 58 October 04, 2021 --- OCR page 77 of 77 --- m a Page 87 Calculation of Annual County Officer Salary " Personal property and livestock are exempt from property tax. ‘a OS 19 §§ 180.71 - 180.83 [CountyName: Ottawa 30,935 m Taxable Value: $ 186,070,893.00 Double Homestead Value (s Total dS 186,070,893.00 [County MillRates 102 ” |Service-abilty: SS 1,905,365.94 $ 24,500.00 AY 44,500.00 id pT Base Salary as set by Board of County Commissioners: = [Allowed increase of basic salary based on | ¢ 9,800.00 valuation: - Required increase based on population: _| © 387.50 [Salary forFY: dS 10,187.50 " Po ‘Total salary at minimum base: $ 34,687.50 ; [Total salary at maximum base: $s 54,687.50 m pT ; 'Service-ablilty = Total amount of revenue collected by multiplying imillate rate (County part) by the taxable valuation. a ‘a m - r S.A. and I, Form 2631R01 Entity: Ottawa County, 58 October 04, 2021