C,A, . A~oo- ,I -'RI, { ,, E::l(, I- I,,,)~ - ' ,I, J ; -, '"'. ' ' " ' ,,, -' -..' , ' ' ,;,, ' . ~-?- '' _, -STATE OfGEORGIA - : ' ; 'DEPARTM. E..NT ,OFA,UDITS~ ' AND'ACCOUNTS . , " , ' ...'., , ' \ ' " ', ', ... '' ) ' ~ ,, .; ,, ' ~ ~ J .,..;: l -f . .- '' ,, , ' ' ' ' , -, ' ' ' ' ,, .. ' ,. ,_' , ' . ., ,, . ...' . ... ,{ ~ ~ WALT.ON COUNTY BOARD' OF. EDUCATION : ', ". ,. ~(_' "'MONROE; GEORGIA" ' . - . - - 'r ' ,, I , ! ,~ ,.,. 4 ,1- ,_ :!-'..REPORTON AUDIT. , ,, ' ' :. OF THE FINANCIAL STATEMENTS ,. FOR ~ THE ' FISC-- ,AL Y.EA. R ENDE'o~- iiiNE.30, 2002 ' , , . '' . ;.. 1 ..,,' . ', . ,' .. , ,. ' ' . Russell w;Hintori State Auditor , , ' -., ., ' " C ,_, ' ,' .,' " '' .,,, ' . I .' WALTON COUNTY BOARD OF EDUCATION -TABLE OF CONTENTS - SECTION I FINANCIAL INDEPENDENT AUDITOR'S COMBINED REPORT ON GENERAL-PURPOSE FINANCIAL STATEMENTS AND SUPPLEMENTARY INFORMATION SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS EXHIBITS GENERAL-PURPOSE FINANCIAL STATEMENTS COMBINED STATEMENTS - OVERVIEW A COMBINED BALANCE SHEET ALL FUND TYPES AND ACCOUNT GROUP 2 B COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES ALL GOVERNMENTAL FUND TYPES 4 C COMBINED STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES - BUDGET AND ACTUAL (NON-GAAP BASIS) GENERAL AND SPECIAL REVENUE FUNDS 6 D NOTES TO THE GENERAL-PURPOSE FINANCIAL STAT[MENTS 7 ADDffiONAL FINANCIAL INFORMATION COMBINING AND INDIVIDUAL FUND STATEMENTS SPECIAL REVENUE FUND lo COMBINING BALANCE SHEEI 18 F COMBINING STATEMENT OF REVENUES, EXPENDITURES AND CHANGES IN FUND BALANCES 20 CAPITAL PROJECTS FUND G COMBINING BALANCE SHEET 22 H COMBINING Sl ATEMENT OF REVENUES EXPENDITURES AND CHANGES IN FUND BALANCES 24 FIDUCIARY FUND TYPE STATEMENT OF CHANGES IN ASSETS AND LIABILITIES AGENCY FUND 26 SCHEDULES SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS 27 2 SCHEDULE OF STATE REVENUE 29 3 SCHEDULE OF APPROVED LOCAL OPTION SALES TAX PROJECTS 31 WALTON COUNTY DOARD OF EDUCATION -TABLE OF CONTENTS- SECTION I FINANCIAL ADDillONAL FINANCIAL INFORMATION SCHEDULES ALLOTMENTS AND EXPENDITURES GENERAL FUND - QUALITY BASIC EDUCATION PROGRAMS (QBE) 4 BY PROGRAM 5 BY SITE Page 32 33 SECTION II COMPLIANCE AND INTERNAL CONTROL REPORTS REPORT ON COMPLIANCE AND ON INTERNAL CONTROL OVER FINANCIAL REPORTING DASED ON AN AUDIT OF FINANCIAL STATEMENTS PERFORMED IN ACCORDANCE WITH GOVERNMENT AUDITING STANDARDS REPORT ON COMPLIANCE WITH REQUIREMENTS APPLICABLE TO EACH MAJOR PROGRAM AND ON INTERNAL CONTROL OVER COMPLIANCE IN ACCORD,\NCE WITH OMD CIRCULAR A-133 SECTION ITT AUDITEE'S RESPONSE TO PRIOR YEAR FINDINGS AND QUESTIOJ\'ED COSTS SUMMARY SCHEDULE OF PRIOR YEAR FINDINGS AND QUESTIONED COSTS SECTION IV FINDINGS AND QUESTIONED COSTS SCHEDULE OF FINDINGS AND QUESTIONbD COSTS SECTION I FINANCIAL tis.,H I W. II I', roN '-,!ATE AUDITOn (40.:) 65G ~1/J DEPARTMENT OF AUDITS AND ACCOUNTS ~~4 WJ~hrngton .;;1rcct ~ W ~ullc 214 AIIJnla Gcorg1J 11l334-84(MI Apnl 30, 2003 Honorable Sonny Perdue, Governor Members of the General Assembly Members of the State Board of Education and Supenntendent and Members of the Walton County Board of Education INDEPENDENT AUDITOR'S COMBINED REPORT ON GENERAI.-PURPOSr: FINANCIAL STATEMENTS AND SUPPLEMENTARY INFORMATION SCHEDULE OF EXPENDITURES OF fEDERAL AWARDS Ladies and Gentlemen We have audited the accompanymg general-purpose financial statements of the Walton County Board of Education, as of and for the year ended June 30, 2002, a~ listed m the table of contents These general-purpose financial statements are the respons1b1lity of the Walton County Board of Education's management Our respons1b1lity 1s to express an opm1on on these general-purpose financial statements based on our audit We conducted our audit in accordance with auditing standards generally accepted in the Llmted States of Amenca and the standards applicable to linanc1al audits contained in Government Auditing Standards, issued by the Comptroller General of the Umted States Those standards require that we plan and perfonn the audit to obtain re.isonable assurance about whether the financial statements are free of material misstatement An audit includes examming, on a test basis, evidence supporting the amounts and disclosures in the financial statements An audit also mcludes assessing the accounting pnnc1ples used and significant estimates made by management, as well as evaluating the overall linancial statement presentation We believe that our audit provides a reasonable b~1s for our opinion As described m the notes to the general-purpose financial statements. the Board of Educatwn's financial statements have been prepared using certain accounting practices and pohc1es which, m our opm1on, vary in some respects from generally accepted accounting principles This variance 1s described as follows 2002ARL-14 I he general-purpose financial statement, of the Board of Educallon did not contain a General I- l',ed Assets Account Group to account tor proper!} and equipment owned by the Board of Education which should be included to conform to generally accepted accounting pnnc1ple, 1 he aggregate effect on the general-purpose tinanc1al ,tatcmenb ofth1, vanance or om1s,1on ha, not been determined. but 1s believed to be material In our op1mon. except for the effects on the general-purpo,c financial ,tatemcnts ot the matter reterred to in the preceding paragraph. the general-purpose financial statement, referred to ahove present tairly. in all material re,pect,. the financial pos1t10n of the Walton County Board of I duLat10n a, ofJune 30. 2002. and the re,ults ol 1h operations lor the year then ended. in conformity w 1th aLcounllng pnnc1plcs generally accepted in the Umted States of Amcnca A, d1,cussed m l\"ote I to the general-purpose tinancial ,tatemcnts. dunng fiscal year 2002. the Board otTducallon wnsohdated its ind1v1dual school act1v1ty accounts for inclusion in the generalpurpose financial ,tatements 1 h1, change 1, in accordance with accounting principle, generally accepted m the Umted States of Amcnca In accordance with Government Audning Standards. \\e hme abo 1,sued our report dated Apnl 30. 2003. on our com1dcrat1on of the Walton County Board ofEducat10n's internal control over financial reporting and our te,l'i of Its comphancl' v.nh certain prons1on, oflaw,. regulations. contract, and grant, That report 1s an integral part of an audit perlormed in accordance with Government Auditing 'itandard, and ,hould he read in conJuncllon \\ 1th th1, report in cons1denng the result, of our audit Our audit was performed for the purpo,e ot forming an opm1on on the gcneral-purpo,c financial statement, of the Walton County Board ot l-ducat1on tal-cn a, a whole 1 he accompanying comb1mng and mdl\'ldual fund statement, (rxh1b11, r, through I) and the financial ,chedules (Schedule, I through 5), which include, the Schedule ofI:: xpendnure, ofrcderal Awards a, required h~ U ', Otficc of :Vfanagemcnt and Budget Circular A-133. foda, of Stt1te.,. [()ea/ (,()vernment1 w1d N()n-l'rofit Orgam=atum, arc pre,ented for purpo~, of additional analys1, and are not a required pan ot the general-purpose financial statement, Such intorniat1on has bccn suhJccted 10 the auditing procedure, applied in the audit of the general-purpose financial statements and m our opinion. c,cept tor the ctlect, ot the matter rctcrred to in the third paragraph. such mtormat1on 1s fairly stated. in all material respects. m relation to the general-purpose financial statements tal-en as a \,hole 2002ARI -14 A copy ofth1s report has been filed as a permanent record m the office of the State Auditor and made available to the press of the State, as provided for by Official Code of Georgia Annotated Section 506-24 Respectfully submitted, Ul.4J~ RWHas 2002ARL-14 State Auditor wALTON COUNTY BOARD or EDUCATION WALTON COUNTY BOARD OF EDUCATION COMBINED BALANCE SHEET ALL FUND TYPES AND ACCOUNT GROUP JUNE 30 2002 ~ Cash and Cash EQ"Urvalents Investments Accoonts Recesvable lnventones Food Donated Commochties Purchased Food Amount Available u, Debt Servtee Fund Amount to be Provided in Future Years For Payment of Bond Debt Total Assets GENERAL FUND GOVERNMENTAL FUND TYPES SPECIAL CAPITAL REVENUE PROJECTS FUND FUND $ 16 567 852 02 $ 360 518 51 $ 14 234 758 72 6 234 593 84 974 386 84 915 423 07 36 056 30 36,309 43 s $ 22 802 445 86 1 409 273 08 $ 15 150 181 79 LIABILITIES AND FUND EQUITY LIABILITIES Cash Oven::lraft Aa:ounls Payable Selanes Payable Explt'9CI Grant Balances Payable Contracts Payable Reta1nages Payable Funds Held for Others General Obllgat10n Bonds Payable Total L1ab1lrt1es f..U,,10.fll.VITY Fund Balances Reserved For Debt Service For Encumbrances For Expired Grant Batances/Oues!Joned Costs For lnvenlones Food Donated Commod111es Purchased Food For Purpose of Bond ls&Ue For SPLOST ProJl!cis For Stalo Capital Outlay Pr0:1ects Unreserved Designated for Self Insurance Oes,gnated tor Land Purchases Undes1gnated Total Fund Equity $ 5 255 439 26 $ 5 874 066 48 12 774 98 399 895 28 s 600 726 50 304 88 464 969 03 662 345 32 403 348 94 s 1114228072 $ 1 000 926 66 $ 1 530 663 29 $ $ 1,000 000 00 10 660 165 14 $ 11.660 165 14 s 38 058 30 36 309 43 $ 73 315 00 9 417 282 30 164 445 59 333 978 69 3 964 475 61 408 346 42 $ 13 619 518 50 Total l.JabUlt1es and Fund Equity s s 22 802 445 86 $ 1 409 273 08 15 150 181 79 The notes to the general-purposo financial statements ere an integral part of th1s statement . 2. EXHIBrT ~A' DEBT SERVICE FUND FIDUCIARY FUND TYPE AGENCY FUND $ 499 578 08 $ 256 073 63 53,130 79 ACCOUNT GROUP GENERAL LONG-TERM DEBT TOTALS (Memorandum Onty) JUNE 30 2002 JUNE 30 2001 s 31 918 780 96 $ 7 928 441 36 23 000 000 00 8 1n 534 54 7 91141665 $ 552 708 87 10 062 291 13 38,058 30 36,309 43 552 708 87 1006229113 44,963 01 26,13741 435 519 59 11 044 480 41 $ 552 708 87 $ s 256 073 63 $ 10 615 000 00 s soi755 683 23 5013901958 43 $ 40 844 78 $ 1106481 $ 6 131 368 38 5 012 583 40 6 -174 792 98 5 670 263 59 13 079 86 824 38 662 345 32 842 362 00 403 348 94 371 899 66 245 008 82 245 008 82 $ 10 615 000 00 10 615 000 00 11 480 000 00 $ 256 073 63 $ 10 615 000 00 $ 24 544 944 30 $ 23 418 777 81 $ 552 708 87 0 00 $ 552 708 87 s 552 708 87 $ 435 519 59 8 524 939 82 31 328 57 38 058 30 36 309 43 73 315 00 9 417 262 30 164 445 59 44 963 01 2613741 2 563 519 78 407 310 00 1 000 000 00 14 958 619 44 100 000 00 6 745 152 00 8.093 310 44 $ 26 240 738 93 $ 26 972 180 62 $ 552 708 87 $ s 256 073 63 $ 10 615 000 00 $ 50 785 683 23 50 390 958 43 - 3- WALTON COUNTY BOARD OF EDUCATION COMBINED STATEMENT OF REVENUES EXPENDITURES AND CHANGES IN FUND BALANCES ALL GOVERNMENTAL FUND TYPES YEAR ENDED JUNE 30 2002 REVENUES State Funds Federal Funds Taxes Other Funds Total Revenues EXPENDITURES Current Instruction Support Services Pupil Services Improvement of Instructional SeMceS Educattonal Media Services General Admmtstratlon School At:Jmlmstrallon Busmess Admm1stratlon Maintenance and Operation or Plant Student Transportation Services Central Support SeMces Other Support SelVlces Food Services Oporat1on Enterpnse Operations Community Services Operations Capital Outlay Debt Service Pnncipal Interest Paying Agent Fees Total Expenchtures Excess of Revenues over (under) Expenditures OTHER FINANCING SOUR\;;ES (USES! Operating Transfers In Operatmg Transfers Out Total Other Financing Sources (Uses) Excess of Revenues and Other Financing Sources over (under) Expenditures and Other Financing Uses FUND BALANCE JULY 1 Food Inventory - Net Change m Penod Donated Commodities Purchased Food GENERAL FUND SPECIAL REVENUE FUND $ 38 896 082 81 $ 62,547 31 26110 143 60 1 420 894 38 $ 66 489 668 10 $ 1 540 662 20 4 766,260 28 1.490 020 74 7.796 943 22 s $ 43 655 477 01 2 029 954 22 1 097 728 49 1 375 912 16 1,426,094 35 4,031,795 72 586 395 93 4 997 357 92 2 65107518 394 202 31 603 851 33 732 627 49 3,945,290 92 143 617 83 259 143 23 122 850 51 113 00 120 00 23,391 41 3 558 765 86 s $ 63,582,472 11 s 2.907 195 99 $ 8 053 292 76 -256 349 54 s $ -6 153 566 80 $ -6, 153,566 80 $ 485 971 45 485 971 45 $ -3 246,370 81 $ 14 906 535 95 229 621 91 175 457 20 -6,904 71 10.172 02 FUND BALANCE JUNE 30 $ 11 660 165 14 $ _ _;4;::0:,8;.:3a:4~6.;:4:;,2. The notes to the general-purpose financial statements are an integral pan of this statement -4- EXHIBIT "8" CAPITAL PROJECTS FUND DEBT SERVICE FUND TOTALS (Memorandum Only) YEAR ENDED JUNE 30. 2002 JUNE 30. 2001 $ 3 299 213 70 $ 43,735,958 71 s 42,319 106 50 4 828,807 59 4 516 797 73 5,702 448 60 s 1 542 759 25 33,355,351 45 29 628 758 87 375 663 86 1260918 3,299.188 16 3 328 982 85 s 9 377 326 16 s 1,555,368 43 s 85,219,305 91 s 79 793 645 95 s 12,983,801 45 s s 12 983 801 45 s s -3.606.475 29 s s 47 600 767 93 s 42 599 741 83 2,173 572 05 1 356,871 72 1 375 912 16 1 548 944 86 4 031 795 72 586 395 93 4,997,470 92 2 651 075 18 394 322 31 627 242 74 3,558 765 86 732,627 49 12 983 801 45 1,904,409 82 1,414 640 73 1 169 357 77 1 532 105 04 3411,863 90 483,498 26 4,897,083 79 2,609,420 62 364,414 25 895 073 21 3 205 767 25 250 00 9 197,265 66 865 000 00 572,377 50 801 65 865,000 00 572,377 50 801 65 81500000 609 770 00 797 40 1438.17915 s 86 057 745 47 s 75 110 459 53 11718928 s -838,439 56 s 4 683 186 42 s 5 667,595 35 s 5,667.595 35 s 6,153,566 80 s 1,019,162 98 -6.153,566 80 -1 019162 98 s 0 00 s 000 s s 2,061,12006 11 558,398 44 11718928 s -838 439 56 s 4 683,186 42 435 519 59 2707591118 22 289 040 43 -6,904 71 10 172 02 5 204 23 -5 250 46 S 13 619,518 50 S 552.708 87 S 26 240 738 93 S 26,972,180 62 - 5- WALTON COUNTY BQARP OF EDUCATION COMBINED STATEMENT OF REVENUES EXPENDITURES AND CHANGES IN FUND BALANCES BUDGET ANO ACTUAL - l 1CATIO!'{ EXI 11131T "D" NO I ES 10 fHE GLNl:.RAL-PURPOSE rINANCIAL STAJEMENTS JUNE JO, 2002 '\Jote 1 ~L'M\1 \RY Or SIGNII !CAN r ACCOUNTING POI ICIES directly rece1\'Jng (or giving) equal value in e,-change. include property taxes. local option ,ales l. collection and remits the balance of taxes collected to the School D1stnct Property tax revenues dunng the fiscal year ended June 30, 2002 for mamtenance and operallons amounted to $24,928,165 14 and for school bonds amounted to $1,485,841 20 Tax millage rates levied for the 2001 tax year (calendar year) for the Walton County Board of Educat10n were as follows (a mill equals $1 per thousand dollars of assessed value) School Operations School Bonds 16 94 mills 0 96 mills .lL2Q mIIIs - 10 - WALTON COUNTY BOARD OF EDUCATION EXHIBIT "D" NOTES TO TI-IE GENERAL-PURPOSE FINANCIAL STATEMENTS nJNE Jo. 2002 Note I SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES SALES TAXES Special Purpose Local Option Sales Tax revenue dunng the year amounted to S5,702,448 60 and 1s to be used for capital oullay for educational purposes or debt service This sales tax was authonzed by local referendum and the sales tax must be re-authonzcd at least every five years INVENTORIES FOOD INVENTORIES Inventories of donated food commod1t1es used m the preparat10n of meals are reported on the Combmed Balance Sheet at their Federally assigned value Purchased foods mventones arc reported on the Comb med Balance Sheet at cost (first-m, first-out) Donated food commod1t1es are recorded as revenues and expenditures at the time commod1ty items are received Purchased foods mventones are recorded as expenditures at the time of purchase The mventones reported on the balance sheet for donated food commod11Ies and for purchased foods arc equally offset by reservations of fund balance winch md1catcs that these amounts do not constitute "available spendable resources" even though they are a component of net current assets COMPENSATED ABSENCES Compensated absences represent obligations of the School D1stnct relatmg to employees' nghts to receive compensation for future absences based upon service already rendered This obligation relates only to vestmg accumulatmg leave m which payment 1s probable and can be reasonably estimated No hab1hty has been recorded m the md1v1dual funds for the current portion of this obhgallon as this amount 1s deemed 1mmatenal to the general-purpose financial statements Additionally, the dollar value of accumulated compensated absences at June 30, which will be payable from future resources has not been recorded m the General Long-Term Debt Account Group as tins hab1hty 1s also deemed to be 1mmatenal to the fair presentation of these financial statements GENERAL OBLIGATION BONDS The School D1stnct issues general obligation bonds lo provide funds for the acqu1s1t1on and construction ofmaJor capital fac1hhes Bond premiums and discounts, as well as issuance costs, are recogrnzed m the financial statements dunng the year bonds arc issued General obhgauon bonds are direct obligations and pledge the full faith and credit ofthe government The outstandmg amount of these bonds 1s recorded m the General Long-Term Debt Account Group INTERFUND TRANSACTIONS The School D1stnct has the followmg types ofmterfund transactions - 11 - WALTON COUNfY BOARD OF EDUCATION EXHIBIT "D" NOTES TO THE GENERAL-PURPOSE FINANCIAL STATEMENTS JUNE 30, 2002 Note I SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES Reimbursements of expenditures 1ru!Jally made fi-om a fund that are properly applicable to another fund are recorded as expendnures m the re1mbursmg fund and as reductions of expenditures m the fund that 1s reimbursed Operating transfers are recorded for all mtcrfund transactions other than reimbursements MEMORANDUM ONLY - TOTAL COLUMNS Total columns on the general-purpose financial statements are capt10ned "Memorandum Only" to md1catc that they arc presented only to fac1htate financial analysis Data m these columns do not present financial pos1tJon or results of operatJons m conformity with generally accepted accounting pnnc1ples Neither arc such data comparable to a consohdatJon Interfund ehminatlons have not been made m the aggrega!Jon oftlus data Note 2 DEPOSITS COLLATERALIZATION OF DEPOSITS Official Code of Georgia Annotated (OCGA) Section 45-8-12 provides that there shall not be on deposit at any tJme many depository for a llme longer than ten days a sum of money which has not been secured by surely bond, by guarantee of msurancc, or by collateral The aggregate of the face value of such surety bond and the market value of secunlles pledged shall be equal to not less than 110 percent of the pubhc funds bemg secured after the deducllon ofthe amount ofdeposit insurance If a depository elects the pooled method (OCGA 45-8-13 I) the aggregate of the market value ofthe secuntJes pledged to secure a pool ofpubhc funds shall be not less than 110 percent ofthe daily pool balance OCGA Sect10n 45-8-11 (b) provides an officer holdmg pubhc funds may, m his d1screuon, waive the requ1rement for secunty m the case of opcratmg funds placed m demand deposit chcckmg accounts Acceptable secunty for deposits consists of any one of or any combmal!on of the followmg (I) Surety bond signed by a surety company duly quahfied and authonzed to transact business within the State of Georgia, (2) Insurance on accounts provided by the Federal Deposit Insurance Corporation, (3) Bonds, bills, notes, certificates of indebtedness or other d1rec1 ohhgahons of the United Stales or of the State of Georgia, (4) Bonds, bills, notes, certificates of indebtedness or other obhgat1ons of the counties or mumc1paht1es of the State of Georgia, (5) Bonds of any pubhc authonty created by the laws of the State of Georgia, providing that the statute that created the authority authonzcd the use of the bonds for this purpose, - 12 - WALTON COUNTY BOARD OF EDUCATION EXHIBIT "D" NOTES TO THE GENERAL-PURPOSE FINANCIAL STATEMENTS JUNE 30. 2002 Note 2 DEPOSITS (6) Industnal revenue bonds and bonds of development authont1es created by the laws of the State of Georgia, and (7) Bonds, bills, notes, certificates of mdcbtedness, or other obhgat10ns of a subs1d1ary corporation of the Umted States government, which arc fully guaranteed by the Umted States government both as to pnnc1pal and mterest or debt obligations issued by the Federal Land Bank, the Federal Home Loan B.mk, the Federal Intermediate Credit Bank, the Central Bank for Cooperatives, the Farm Credit Banks, the Federal Home Loan Mortgage Association, and the Federal National Mortgage Association CATEGORIZATION OF DEPOSITS At June 30, 2002, the bank balances were $15,136,589 20 The amounts of the total bank balances are classified mto three categones of credit nsk Category 1 Cash that 1s msured (e g., Federal depository msurance) or collaterahzed with secuntles held by the School D1stnct or by the School D1stnct's agent m the School D1stnct's name Category 2. Cash collaterahzed with secunt1es held by the plcdgmg financial mstltullon's trust department or agent m the School D1stnct's name Category 3 Uncollaterahzed deposits (This includes any bank balance that 1s collatcrahzed with secun!Ies held by the plcdgmg financial mst1tut1on, or by its trust department or agent but not m the School D1stnct's name ) The School D1stnct's deposits are classified by nsk category at June 30, 2002, as follows Risk Category Bank Balance 1 $ 1,013,270 43 2 13,888,381 43 3 234 937 34 Total $ J5. !36.589,20 Note 3 NON-MONETARY TRANSACTIONS The School D1stnct receives food commod11Ics from the Umted States Department of Agnculture (USDA) for school breakfast and lunch programs These commod11Ies arc recorded at thelT Federally assigned value See Note l Inventories 13 - - - - - - - - - - - - - - --- WALTON COUN1Y ROARD OF EDUCATION EXHIBIT "D" NO1ES TO TIIE GENERAL-PURPOSE FINANCIAL S1ATEMENTS JUNE 30. 2002 Note 4 RISK MANAGEMENT The School D1stnct 1s exposed to vanous nsks of loss related to torts, theft of, damage to. and destrucl!on of assets. errors or om1ss1ons,Job related illness or mJunes to employees, acts of God and unemployment compensal!on The School D1stnct has obtamed commercial msurance for nsk of loss associated with torts, assets, errors or om1ss10ns,Job related illness or mJunes to employees and acts of God The School D1stnct has neither s1gmficantly reduced coverage for these nsks nor mcurred losses (settlements) which exceeded the School D1stnct's msurance coverage m any of the past three years The School District 1s self-msured with regard to unemployment compensahon claims The School D1stnct accounts for claims w1thm the General Fund with expenditure and hab1hty bemg reported when 111s probable that a loss has occurred, and the amount ofthat loss can be reasonably estimated Changes m the unemployment compensahon claims hab1hty dunng the last two fiscal years are as follows Hegmmng of Year L1ab1hty Claims and Chdnges m Estimates Claims Paid [nd of Year L iab1hty 2001 2002 $ 0 00 $ 16 483 58 $ 16 483 58 $ 0 00 $ 0 00 $ 1943692 s 19 436 92 s 000 The School D1stncl has purchased surety bonds to provide add1t1onal msurance coverage as follows Pos1t1on Covered Amount Superintendent All Other Employees $ 100.000 00 S 100,000 00 Note 5 GENERAL LONG-TERM DEBT GENERAL OBLIGATION DEBT OUTSTANDING General Obhgal!on Bonds currently outstandmg are as follows Purpose Interest Rates Amount General Government - Senes 1995 4 20%- 6 00% $1Q.6 l5.000,00 The changes m General Long-Term Debt dunng the fiscal year ended June 30, 2002, were as follows - 14 - WALTON COUNTY BOARD OF EDUCATION EXHIBIT "D" NOTES TO THE GENERAL-PURPOSE FINANCIAL STATEMEN1 S JUNE 30, 2002 Note 5 GENERAL LONG-TERM DEBT General Obhgat1on Bonds Balance July I, 2001 $11,480,000 00 Deduclions Debt Rclired 865,000 00 Balance June 30, 2002 SIO..6..) 5..O__QQ,_QQ At June 30, 2002, payments due by fiscal year which mcludes pnnc1pal and mterest for these items are as follows Fiscal Year Ended June 30 General Obligat1on Bonds 2003 2004 2005 2006 2007 2008 - 2011 Total Pnnc1pal and Interest $ 1,191,457 50 1,478,080 00 1,485,550 00 1,489,050 00 1,493,650 00 6,159,000 00 sI3,296.78.7 .5..0 Note 6 ON-BEHALF PAYMENTS The School D1stnct has recogmzed revenues and expenditures m the amount of $655,453 73 for health insurance and relirement contnbut1ons paid on the School D1stnct's behalf by the followmg State Agencies Georgia Department of Educalion Paid to the Georgia Department of Community Health For Health Insurance ofNon-Cert1fic\ND MADF-. Lmployces ol the School D1stnct who arl' covered by TRS arc required hy State ,tatute to contnhutc 5% of their gro,, earning, to TRS nie School D1,tnct makes month I) employer contnhut1ons to rRS at rate, adopted hy the I RS Board ofTru,tcc, in accordance with State statute and a, adv"ed h) their independent actuary The required employer contnbutmn rate 1s CJ 24% ,md employer contnhuuon, for the current fiscal year and the preceding two fi,cal ~ear, are a, follows 1-Jsc.il 'r car Percentage Contnhuted Required Contnbut1on 2002 200 I 2000 100% 100% 100% $3.642.76138 $ 3.915.583 57 $ 3.614,934 50 - 17 - WALTON COUN1Y BOARD OF EDUCATION COMBINING BALANCE SHEET SPECIAL REVENUE FUND JUNE 30 2002 ASSETS Cash and Cash Equivalents Accounts Receivable lnventones Food Donated Commod1bes Purchased Food SCHOOL FOOD SERVICES FUND LOTTERY PROGRAMS $ 583,735 45 $ 157,380 75 25,863 03 17,207 42 38,058 30 36 309 43 Total Assets $ 683,966 21 $ ___11_4_5_0aa0..1_1_ LIABILITIES AND FUND EQUITY LIABILITIES Cash Overdraft Accounts Payable Salanes Payable Expired Grant Balances Payable Total L1ab1ht1es FUND EQUITY Fund Balances Reserved For Encumbrances For lnventones Food Donated Commod1ties Purchased Food Unreserved Un designated Total Fund Equity Total L1ab1ht1es and Fund Equity $ 62,401 50 $ 39,371 83 213,218 29 135,216 34 $ 275 619 79 $ 174 588 17 $ 38,058 30 36,309 43 333 978 69 $ 000 $ 408 346 42 $ 0 00 $ 683,966 21 $ _ _1_7_.4_,5.,88=-1=7= See notes to the general-purpose financial statements - 18 - EXHIBIT"E" FEDERAL PROGRAMS TOTALS JUNE 30, 2002 JUNE 30, 2001 $ 741,11620 $ 484,255 91 $ 931,316 39 974,386 84 977,737 15 38,058 30 36 309 43 44,963 01 26 137 41 $ 931 316 39 $ 1789870 77 $ 1533093 48 $ 380,597 69 s 380,597 69 $ 525,100 69 298,121 95 399,895 28 312,593 64 252,291 87 600,726 50 519,941 95 304 88 30488 $ 931 316 39 $ 1,381,524 35 $ 1 357 636 28 $ 1,254 67 $ 38,058 30 36,309 43 44,963 01 26,13741 333 978 69 10310211 $ 000 $ 408 346 42 $ _ _1~7=5-~45=7~2=0~ s 931 316 39 $ 1 789 870 77 $ 1.533.093 48 - 19 - WALTON COUNTY BOARD OF EDUCATION COMBINING STATEMENT OF REVENUES. EXPENDITURES AND CHANGES IN FUND BALANCES SPECIAL REVENUE FUND YEAR ENDED JUNE 30, 2002 REVENUES State Funds Federal Funds Other Funds Total Revenues EXPENDITURES Current Instruction Support Services Pupil Services Improvement of lnstruc:tJonal Services General Admm1strat1on School Admm1strat1on Maintenance and Operation of Plant Student Transportation Services Central Support Services Other Support Services Food Services Operation Total Expenditures Excess of Revenues over (under) Expenditures OTHER FINANCING SOURCES Operating Transfers In Excess of Revenues and Other Fmancmg Sources over (under) Expenditures FUND BALANCE JULY 1 Food Inventory - Net Change In Pertod Donated Commod1lles Purchased Food FUND BALANCE JUNE 30 SCHOOL FOOD SERVICES FUND LOTTERY PROGRAMS $ 235.676 00 $ 1.304.986 20 1.649.857 70 1,490,020 74 $ 3 375 554 44 $ 1304986 20 $ 1.243.877 31 116.023 68 1.633 12 193 59 113 00 $ 3,558,765 86 $ 3,558,765 86 $ 1.361 840 70 $ -183.211 42 $ -56,854 50 414 088 00 $ 230.876 58 $ 174,202 53 -6,904 71 10 172 02 56 854 50 000 000 $ 408 346 42 $ _____o_o_o_ See notes to the general-purpose financ,al statements - 20 - EXHIBIT "F" FEDERAL PROGRAMS TOTALS YEAR ENDED JUNE 30, 2002 JUNE 30, 2001 $ 1,540,662 20 $ 1,397,189 67 $ 3,116,402 58 4,766,260 28 4,465,619 99 1490020 74 141123986 $ 311640258 $ 7,796,943 22 $ 7 274 049 52 $ 2,701,413 61 $ 3,945,290 92 $ 3,508,338 10 27,594 15 257,51011 122,656 92 120 00 23,391 41 143,617 83 259,143 23 - 122,850 51 113 00 120 00 23,391 41 3 558 765 86 189,081 51 358,942 02 83,653 04 9,234 30 1,239 89 1,367 25 93,712 23 3,205,767 25 s 3,132,686 20 $ 8,053,292 76 $ 7 451 335 59 $ -16,283 62 $ s -256,349 54 -177,286 07 15 028 95 485 971 45 146 175 67 $ -1,254 67 S 229,621 91 $ -31,11040 1,254 67 175,457 20 206,613 83 -6,904 71 1017202 5,204 23 -5 250 46 s 0 00 $ 408 346 42 $=~1.1..5...,45_1..,2""0'= - 21 - WALTON COUNTY BOARD OF EDUCATION COMBINING BALANCE SHEET CAPITAL PROJECTS FUND JUNE 30. 2002 ASSETS Cash and Cash Equivalents Investments Accounts Receivable REGULAR BOND PROCEEDS GEORGIA STATE FINANCING AND INVESTMENT COMMISSION $ 4.003,809 35 $ 73,31500 $ 123,714 89 Total Assets $ 410031809 35 $ 73 315 00 $ -=~12;;;3~7~1;;;4~8;,;;9;,. LIABILITIES AND FUND EQUITY LIABILITIES Accounts Payable Contracts Payable Retamages Payable Total l.Jab1ht1es FUND EQUITY Fund Balances Reseived For Encumbrances For Purposes of Bond Issue For SPLOST Projects For State Capital Outlay Projects Unreserved Undes1gnated Total Fund Equity $ 39,333 74 $ 39 333 74 $ $ 3 964 475 61 $ 3 964 475 61 $ 73,315 00 $ 0 00 73 315 00 $ 123 714 89 000 123 714 89 Total L1ab1lrt1es and Fund Equity $ 4 003 809 35 $ 73 315 00 $-=~12a;,3~7~1;;,4~89~ See notes to the general-purpose financ,al statements - 22 - EXHIBIT "G" SPECIAL PURPOSE LOCAL OPTION SALES TAX $ 9,993,188 78 $ 915 423 07 LOTTERY PROJECT TOTALS JUNE 30, 2002 JUNE 30, 2001 s 40,730 70 $ 14,234,758 72 3,191,08347 9,000,000 00 915 423 07 887 038 57 4073070 $ 15150181 79 $ 13 078 122 04 $ 464,969 03 623,011 58 403 348 94 $ 1 491 329 55 $ 464,969 03 $ 305,461 94 662,345 32 842,362 00 403 348 94 371 899 66 $ 1,530,663 29 $ 151972360 $ 9,417,282 30 $ 0 00 $ 9 417 282 30 $ $ 40,730 70 s 73,315 00 9,417,282 30 164,445 59 8,442,516 31 2,563,519 78 407,310 00 0 00 3 964 475 61 145 052 35 40 730 70 $ 13,619,518 50 s 11 558 398 44 $ 10,908,611 85 $ 40.73070 $ 1515018179 $ 13 078 122 04 - 23 - WALTON COUNTY BOARD OF EDUCATION COMBINING STATEMENT OF REVENUES. EXPENDITURES AND CHANGES IN FUND BALANCES CAPITAL PROJECTS FUND YEAR ENDED JUNE 30, 2002 REVENUES REGULAR BOND PROCEEDS GEORGIA STATE FINANCING AND INVESTMENT COMMISSION State Funds Taxes Other Funds $ 0 00 $ 000 $ 000 Total Revenues EXPENDITURES $ 0 00 $ 000 $ 000 Capital Outlay Land and Land Improvements $ 1,750.418 09 $ 000 Building and Bu1ld1ng Improvements 97,754 00 $ 44,700 00 Equipment Total Expenditures $ 1848172 09 $ 44 700 00 $ 000 Excess of Revenues over (under) Expenditures $ -1,848, 172 09 $ -44 700 00 $ 000 OTHER FINANCING SOURCES (USES) Operating Transfers In Operating Transfers Out $ 5.667.595 35 $ 11801500 Total Other Financing Sources (Uses) $ 5,667,595 35 $ 11801500 Excess of Revenues and Other Financmg Sources over (under) Expenditures and Other Financing Uses $ FUND BALANCE JULY 1 3,819,423 26 $ 145 052 35 73.315 00 $ 000 000 123 714 89 FUND BALANCE JUNE 30 $ 3 964 475 61 S 73 315 00 $==1=2,_3_7_14_8_,9'= See notes to the genera~purpose financ,al statements - 24 - EXHIBIT "H" SPECIAL PURPOSE LOCAL OPTION SALES TAX LOTTERY PROJECT TOTALS YEAR ENDED JUNE 30, 2002 JUNE 30, 2001 $ 3,299,213 70 $ 3,299,213 70 $ 3,410,272 59 $ 5,702,448 60 5,702,448 60 5,358,530 65 375 663 86 375 663 86 654 097 89 $ 6078,11246 $ 3,299,21370 $ 9,377,32616 $ 9,422,90113 s 2,182,663 93 4,824,076 56 $ 418 395 87 $ 7,425,136 36 $ $ -134702390 $ $ 3,665,793 00 3,933,082 02 $ 8,632,323 56 418 395 87 3,665,793 00 $ 12,983,801 45 $ -366 579 30 $ -3,606,475 29 $ 848,571 50 8 274,872 76 73 821 40 9,197,265 66 225 635 47 $ -118 015 00 $ -118 015 00 $ 5 785,610 35 $ 2,535,801 70 -118 015 00 -1,662,814 39 $ 5,667,595 35 $ 872 987 31 $ -1,465,03890 $ 10,882,321 20 -366,57930 $ 2,061,12006 $ 1,098,62278 407 310 00 11 558 398 44 10 459 775 66 $ 9417,28230 $ 40,73070 $ 13,619,51850 $ 1155839844 - 25 - WALTON COUNTY BOARD OF EDUCATION STATEMENT OF CHANGES IN ASSETS AND LIABILITIES FIDUCIARY FUND TYPE -AGENCY FUND YEAR ENDED JUNE 30 2002 EXHIBIT"!" SCHOOL ACTIVITY ACCOUNTS ASSETS Cash and Cash Equivalents LIABILITIES Accounts Payable Funds Held for Others BALANCE JULY 1, 2001 ADDITIONS DEDUCTIONS BALANCE JUNE 30, 2002 s $ 20353994 $ 124386910 119153541 $ _ _2_5_6._0.1..3_6_3_ $ 11,064 81 $ $ 20383994 1,232,80429 $ 119163541 11,06481 245,008 82 $ 203.839 94 $ 1 243 869 1o s 1 191 635 41 s__2_5_6._0._73._6_3_ See notes to the general-purpose finanoal statements - 26 - WALTON COUNTY BOARD QF EDUCATION ~ L E OF EXPENPITURES OF FEDERAL AWARDS YEAR ENDER JUNE 30 2002 SCHEDULE 1 FUNDING AGENCY PRQGRAMIGRANT Agnculture U S Department of Child Nutnl1on Cluster Pass-Through From Georgia Department of Fducat:on Food ar.cl Nutnhan Program Food Services School Breakfast Program Nat10nal School Lundi Program Pass-Through From Office of School Readiness Food and Nutnlton Program Food Services Summer Food Servic:e Program for Children Tcl.al Child NulnlIon Cttr..ter Other Programs Pass-Thrcugh From Georgia Department of Educat10n Food end Nutnllon Program Fooo Services Food D1str1but1on Program (1) Total U S Department of Agriculture Educalton U S Department of Speaal Educabon Cluster Pass-Through From Georgia Department of Education Individuals with Dtsab111!1es Education Act Part B - Special Education Flow Through Capacity Building lmprovoment Preschool Total Special Educabon Cluster Other Programs Pass-Through From Georgia Department of Educahon Comprehensive Scilool Reform DemonstraltO'l PrQfect Elementary and Secondary Educa110n Act TIiie I Axoun1ab1llty Grants Grants to Local Educaltonal Ageooes T1tlo II Eisenhower Profess,onal Development Title VJ Innovative Education Program Strategies Class Sizo Reduction Safe and Drug Free SchOOls and Commun1trcs Vocabonal Education - Basic Gmnts to States High ~hool Program Basic Grant Total U S Departmont of Education Defense U S Department or Direct Department ol the Air Forco R O T C Program CFDA NUMBER PASSTHROUGH ENTITY ID NUMBER FEDERAL REVENUE IN PERIOD EXPENDITURES IN PERIOD 10 553 10 555 NIA $ 3;;?981851 (2) NIA 1 144 426 19 s 3 401,909 50 (3) 10 559 NIA 18 75664 2 1 493 001 34 3 401 909 50 10 550 NIA 156 856 36 156 856 36 s 1 649 857 70 s 3 558 765 86 84 027 84 027 84 173 NIA s 1 001 211 39 s 1 002 137 92 (3) NIA 3 487 94 3 487 94 NIA 38 787 00 38 787 00 s 1 043 486 33 s 1 044 412 86 84 332 84 348 84 010 84 281 84 298 84 340 84 186 84 048 NIA 49,695 12 49 695 12 NIA 50 1.44 09 50 144 09 NIA 1 472 484 22 1 472 484 22 NIA 60 457 92 62 766 19 [3) NIA 56 559 75 56 559 75 NIA 262 755 00 27511311 (3) NIA 40,432 15 40 432 15 NIA BO 388 00 81 078 71 [3) s 311640258 s 3 132 686 20 62 547 31 (4) Tolal Fodcral Financial Assistance NIA= Not Available - 27 - s 4 828 807 59 s 6 691 452 06 WALTON COUNTY BOARD OF EDUCATION SCHEDULE QF EXPENDITURES Of FEDERAL AWARDS YEAR ENDED JUNE 30 2002 SCHEDULE 1 Note:, to the Schedule of [xpendrtures of Federal Awards (1) The amounts shown for the Food D1stnbut1on Program represents the Federally assigned value of nonmonetary assistance for donated commod1t1es received end/or consumed by the syslem dunng the current fiscal year (2) Expenditures for the School Breakfasl Program and the Summer Food Service Program for Children were not maintained separalely and are induded m the 2002 Nat1011al School Lunch Program (3) Expenditures f0< this program mdude State and/or Other Funds Expenditures are not mamta1ned by fund source (4) Expend1tues on lh1s program were not ma1nta1ned by fund source Maier Programs are 1dent1fl8d by an astensk I') m from of the CFDA number The School D1stnct did not prOVlde Federal Assistance to any SJbrec,p1ent Tho accompanying schedulo of expenditures of Federal awards mdudes the Federal grant act1111ty of the Walton County Board of Educa11on and LS presented on the mod1f1ed accrual basis of accountrng wtuch rs lhe baSJs of accounting used m the presentatlOfl of !ho general-purpose financial statements See notes to the genera1-purpose l1nar.c1al statements 28 - WALTON COUNTY BOARD OF EDUCATION SCHEDULE OE STATE REVENUE YEAR ENDED JUNE 30 2002 SCHEDULE "2" AGENCY/FUNDING GOVERNMENTAL FUND TYPES SPECIAL CAPITAL GENERAL REVENUE PROJECTS FUND FUND FUND TOTAL GRANTS Educabon Georgia Department of Ouahty Basx: Educabon Direct Instructional Cost Kmdergarten Program s Kindergarten Program - Early lntervenbon Program Pnmsry Grades (1-3) Program Pnmery Grades - Earty ln1ervent1on {1-3) Program Upper Elementary Grades (4-5) Program Upper Elementary Grades Eerty lntervenbon Mlddle School (6-8) Program High School General Education (9-12) Program Vocational Laboratory (9-12) Program Students wrth Dlsabllrues Category I Category II Category Ill Category IV Category V Grfted Student - Category VI RemedLSI Education Program Altematrve Education Program EnghSh Speakers of Other Languages (ESOL) Mech Center Program 20 Days Additional lnstruc:b01'1 Staff end ProfesslOllal Development Indirect Cost Categoncel Grants Pup1I T rensportatJon Regular Bus Replacement Nursing SeMCes PrlncipalSupplements Vocat1011al Supervisors Deferred Summer Salanea (Pnor Year) Deferred Summer Salanes (Current Year) Educ:a1ron Equalizabon Funding Grant Fo