GA -' Al?>oo 'RI ,5(, 7 ;l.oo/-:1.oo:<. -. _STATE OF G-EORGIA ' ' DEPARTMENT OF: AUDITS AND,ACCOUNTS ' \ . j \ ' '' \ ' J r . , ' ' , ' 'I ' ' \ ' i I . ' J ' ) SOUTHER"! POLYTECHNIC .STATE UNIVERSITY , MARIEITA, GEORGIA \ ' : REPORT ON REVIEW OF THE FINANCIAL STATEMENTS , FORTHE FISCAL YEAR ENDED JUNE' 30, 2' 002 \ ~ I ,.J r V Russell W. Hinton State Auditor ' '- ) , SOUTHERN POLYTECHNTC STATE UNNERSITY -TABLE OF CONTENTS- SECTION I FINANCIAL INDEPENDENT ACCOUNTANTS COMBINED REPORT ON REVIEW OF BASIC FINANCIAL STATEMENTS AND SUPPLEMENTARY INFORMATION REQUIRED SUPPLEMENTARY INFORMATION MANAGEMENTS DISCUSSION AND ANALYSIS 2 BASIC FINANCIAL STATEMENTS EXHIBITS A STATEMENT OF NET ASSETS 11 B STATEMENT OF REVENUES, EXPENSES AND CHANGES IN NET ASSETS 12 C STATEMENTOFCASHFLOWS 13 D NOTESTOTHEFINANCIALSTATEMENTS 14 SUPPLEMENTARY INFORMATION SCHEDULES SCHEDULES OF REVENUES AND EXPENDITURES COMPARED TO BUDGET - (NON-GAAP BASIS) I RESIDENT INSTRUCTION 31 2 LOTTERY FOR EDUCATION 32 3 RECONCILIATION OF SALARIES AND TRAVEL 33 SECTION II AUDITEE'S RESPONSE TO PRIOR YEAR FINDINGS AND QUESTIONED COSTS SUMMARY SCHEDULE OF PRIOR YEAR FINDINGS AND QUESTIONED COSTS SOUTHERN POLYfECHNIC STATE UNIVERSITY - TABLE OF CONTENTS SECTION III CURRENT YEAR FINDINGS AND QUESTIONED COSTS SCHEDULE OF FINDINGS AND QUESTIONED COSTS I SECTION! FINANCIAL .. Rt1,Sl:.LI \\'. Hll'l,T()"II STATE AUC'ITQR cCMl 6~217 DEPARTl\.1ENT OF AUDITS AND ACCOUNTS 254 \\'J..,hmgron Street S W Suue 214 Atlanta, Georg1J 30334-8400 December 27, 2002 Honorable Sonny Perdue, Governor Members of the General Assembly of Georgia Members of the Board of Regents of the Umvers1ty System of Georgia and Honorable Lisa A Rossbacher, President Southern Polytechmc State Umversny INDEPENDENT ACCOUNTANT'S COMBINED REPORT ON REVIEW OF BASIC FINANCIAL STATEMENTS AND SUPPLEMENTARY INFORMATION Ladies and Gentlemen We have reviewed the accompanying basic financial statements (Exh1b1ts A through D) ofSouthern Polytechmc State Umvers1ty, an orgaruzatlonal urut of the State of Georgia, as of and for the year ended June 30, 2002, in accordance with Statements on Standards for Accounting and ReVJew Services issued by the Amencan lns!Jtute ofCernfied Pubhc Accountants All mformat1on included in these financial statements 1s the representation ofthe management ofSouthern Polytechmc State Umvers1ty A review consists pnnc1pally ofinqumes ofUmvers1ty personnel and analytical procedures apphed to financial data It 1s substantially less in scope than an audit in accordance with auditing standards generally accepted in the Uruted States of Amenca, the obJechve ofwh1ch 1s the expression of an op1ruon regarding the financial statements taken as a whole Accordingly, we do not express such an op1mon Based on our review, we are not aware of any matmal mod1ficauons that should be made to the accompanying financial statements in order for them to be in conformity with accounting pnnc1ples generally accepted in the Umted States of Ammca As descnbed in Note \, the Umvers1ty adopted the prov1s1ons of Governmental Accounting Standards Board (GASB) Statement No 35, Baszc Fznanczal Statements - and Management's Dzscusszon and Ana(vs1s -for Public Colleges and Umversllles, as amended by GASB Statement No 37, Basic Financial Statements - and Management's Discusszon and Ana(vsis -for State and Local Governments, and GASB Statement No 38, Certain Fznanc1al Statements Note Disclosures, as of July I. 2001, to implement a new financial reporting model 02ARL-66 Management's D1scuss10n and Analysts 1s not a requtred part of the baste financial statements but 1s supplementary mformatton required by the GASB We have apphed ccrtam hm1ted procedures, which consisted pnnc1pally of mqumes of management regardmg the methods ofmeasurement and presentation of this supplementary mformatton, and we are not aware of any matenal mod1ficat1ons that should be made thereto Our review was made for the purpose of expressmg hm1ted assurance that there are no matenal mod1ficat1ons that should be made to the financial statements m order for them to be m conformity with accountmg pnnc1ples generally accepted m the Uruted States ofAmenca The accompanymg supplementary mformat10n (Schedules I through 3) 1s presented for add1t1onal analysis purposes. Such mformatlon has been subjected to the mqwnes and analytical procedures applted m the reVIew ofthe financial statements, and we are not aware of any matenal mod1ficattons that should be made to such data Respectfully submllted, ~ w.11od (Used) by Noncapillll Fnnang Actrvrtloo CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTMTIES Purcha9ea of Caprtal Aooelo CASH FLOWS FROM INVESTING ACTMTIES lnteres1 on Investments Pun:hase of Investments Net Cash PnMded (Uaed) by Investing Acovlbeo Ne\ lncreasel(Decrease) in Cash Cash and C.ah Equrvlanta - Ji.ne 30 2001 Leaa Short-Tenn tnvestmenta Cash end Cash Ecvments - Beg1nrv:ng of Year Cash and Cash Equvalents - End of Year I RECONCILIATION OF OPERATING LOSS TO NET CASH PROVIDED (USED) BY OPERATING ACTMTIES 0peraong lnccme (Loss) AdJUStments to Reconc:de Net lnc:ome (Loss) to Net Cash Prcvoded (Used) by Operatmg AdMbeo Depreaat,on Change In Auets and Liabtlrtles Accounts Rec:eMllbla Net ~eo Payable Payroll Wrthholdlngs Deferred Ravenue Other" l.JabtlrtJes Compensaled Aboenca Net Cash Provided (Uaed) by Operaong - - = - Sae lndepet .dent Accountanf, Report on R - ol BaalC Frnanaal Statements and Supplementary lnfol 2az ~Q s~ 1~1 J74~D s ~W~l~B6 s ~721 ~441 s ~ JJ] 27 20 S ]2~9~1791 -27 - SUPPLEMENTARY INFORMATION .. -29- SOUTHERN POLYTECHNIC STATE UNIVERSITY SCHEDULE Of REVENUES AND EXPENDITURES COMPARED TO BUDGET - INON-GAAP BASIS! RESIDENT INSTRUCTION YEAR ENDED JUNE 30 2002 SCHEDULE "1" REVENUES State Appropnabons Other Revenues Retained BUDGET ACTUAL (11 VARIANCEFAVORABLE (UNFAVORABLE) $ 21,808,11000 $ 19 452 913 00 21,808,110 00 $ 17,728,325 33 000 -1 724 587 67 $ 41,261,02300 $ 39,536,435 33 $ _ _--"1'c..;72a.-4'-C5CC8'-7.c.67'-- EXPENDITURES Personal Services EducatJon, General and Depar1mental Serv1ces Sponsored Operabons Qperabng Expenses Educabon, General and Departmental Services Sponsored Operations Cap:tal Outlay Speaal Fund:ng lnrtJatlve Research Consortium s 23,159,998 00 $ 1,494,976 00 5,668,026 00 8,654,689 00 1,161,526 00 298,92900 822,87900 23,002,426 08 $ 1,015,929 75 5,370,970 26 6,847 449 77 1,234,996 94 276,019 74 822 894 87 157,571 92 479,046 25 297,055 74 1,807 239 23 -7347094 22,909 26 -15 87 Excess of Revenues over Expendrtures $ 41,261,02300 $ 38,570,687 41 $ _ _~2.c.690=,335=~59'-- -------- S 1 965 747 92 $ 965 747 92 (1) Actual amourns wera preparnd on a prescnbed baSls of accounlmg lhal demonstra19s compl:ance wllh budgetary statu1es and regulabons of the Sta18 of Georg:a, wh:ch rs a comprehensive baSls of accounbng other than generally accepted accounbng pnncoples See accompanying no1es and Independent Accountant's Comb:ned Report on Rev:ew of Basic Flnancoal Statements and Supplementary Information 31 - SOUTHERN POLYTECHNIC STATE UNIVERSITY SCHEDULE OF REVENUES AND EXPENDITURES COMPARED TO BUDGET - CNON-GAAP BASIS) WTTERY FOR EDUCATION YEAR ENDED JUNE 30. 2002 SCHEDULE "2" REVENUES State Appropnat,ons BUDGET ACTUAL (1) VARIANCEFAVORABLE (UNFAVORABLE) $ 266 644 00 $ 266,644 00 $ _ _ _ _ _0"'-'-00"- EXPENDITURES Equipment, Technology and Construcllon Trust Fund Special Funding lnrt1at1ves $ 167,612 00 $ 167,612 00 $ 000 99 032 00 99,032 00 000 $ 266 644 00 $ 266,644 oo s ____......:o..;o=o Excess of Revenues over Expenditures $ 0 00 $ ~---~0~0:::,0 (1) Actual amounts were prepared on a prescnbed basis of accourmng that demonstrates compliance with budgetary statutes and regulations of the Sta1e of Georgia, which 1s a comprehensive basis of accounhng other than generally accepted accounhng prinaples I See accompanying notes and lndependerrt Accourrtanfs Combined Report on ReVJew of Basic Financial Statemerrts and Supplemerrtary lnforma11on - 32 - SOUTHERN POLYTECHNIC STATE UNIVERSITY RECONCILIATION OF SALARIES AND TRAVEL YEAR ENDED JUNE 30. 2002 SCHEDULE "3" Totals per Annual Supplement Prepaid Salanes June 30, 2002 June 30, 2001 Accruals June 30, 2002 June 30, 2001 Compensated Absences June 30, 2002 June 30, 2001 AdJustments Barnes, Wilson Hanratty, Nicholas TIiiman, Richard Shared SeMces on Jointly Staffed Personnel Kennesaw State Un1versrty Dennison, Wayne McDonald, Shelly Unidentified Vanance SALARIES $ 20,955,269 44 $ TRAVEL 242,275 46 -688,612 54 723,251 19 75.282 n -66,624 38 628,666 99 -610,330 17 1,400 00 -217 00 -23 40 16,147 50 -64,004 09 -7 459 81 $ 201961,586 oo s ___24_3_._43_5...,oo._ 1 .. See accompanying notes and Independent Accountant's Combined Report on Review of Basic Financial Sta1emen1s and Supplementary lnfonna11on - 33 - SECTION II AUDITEE'S RESPONSE TO PRIOR YEAR FINDINGS AND QUESTIONED COSTS : SOUTHERNPOLYTECHNICSTATEUNNERSITY AUDITEE'S RESPONSE SUMMARY SCHEDULE OF PRIOR YEAR FINDINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30, 2002 PRIOR YEAR FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS FINDING CONTROL NUMBER AND STATUS FS-550-00-01 FS-550-00-03 FS-550-01-01 FS-550-01-02 Prev10usly Reported Correcllve Acllon Implemented Prev10usly Reported Correcllve Acllon Implemented Previously Reported Correcllve Acllon Implemented PreV!ously Reported Correcllve Act10n Implemented PRIOR YEAR FEDERAL AWARD FINDINGS AND QUESTIONED COSTS FINDING CONTROL NUMBER AND STATUS FA-550-00-04 Partially Resolved - See Corrective Acllon/Responses CORRECTIVE ACTION/RESPONSES SPECIAL TESTS AND PROVISIONS Failure to Reconcile Program Reports Wilham D. Ford Federal Direct Loan Program (CFDA 84 286) Fmdmg Control Number: FA-550-00-04 The Uruvers1ty has reconciled the open prograin years for the Wilham D Ford Federal Direct Loan Program as follows: 1997-98 1998-99 1999-2000 2000-2001 Closed by the LOC (Loan Origmat1on Center) $26,189 44, remammg loans to be booked'by the LOC $110,329.75, remairung loans to be booked by the LOC $23,323.00, remairung loans to be booked by the LOC All borrower's add111ons, adJustments and/or correcllons have been 1den1Ified and reported to the Loan OngmatJon Center (LOC) smce February 2002, therefore there 1s no further acllon to be taken by the Umvers1ty at this llme In June 2002, the Department ofEducallon suspended electromc transfer ofdata forpnor years, thus requmng the LOC to manually process each borrower's records. Tlus manual process 1s both labor mtens1ve and llme consummg Once all transacllons have been recorded by the LOC, the Umvers1ty will then receive perm1ss1on from the Department of EducatJon to request re!Illbursement m the amount of$159,842.19 as noted above SECTION ID CURRENT YEAR FINDINGS AND QUESTIONED COSTS t SOUTHERN POLYTECHNIC STATE UNIVERSITY SCHEDULE OF FINDINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30. 2002 FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS ACCOUNTING CONTROLS (OVERALL) Inadequate General Controls Fmdmg Control Number FS-550-02-01 Dunng Fiscal Year 2002, the Board ofRegents ofthe Uruvers1ty System ofGeorgia converted umts ofthe Umvers1ty System from the College Uruvers1ty Fmanc1al Accountmg (CUFA) legacy system to the new GeorgiaF/RSTSystem (Fmanc1al, Informatmn and Reporting Systems for Tomorrow). In March of2002, Southern Polytechruc State Uruvers1ty placed this accountmg system mto productJon. The management of Southern Polytechruc State Uruvers1ty is responsible for 1mplementmg procedures to establish and mamtam adequate control over the operatJon, utJlizaUon and mtegnty of their data processed with the GeorgiaF/RSTSystem We encountered problems with the financial data presented by the Umvers1ty The Uruvers1ty"s failure to establish and adhere to a final closmg for the year ended June 30, 2002, created a s1tuat1on where data presented for review was mcomplete Extensive review procedures were necessary to determme the vahd1ty of the mformatlon provided To reduce the nsk ofreportmg mcomplete mformatJon, the University should work with the Board of Regents Central Office to develop procedures that will result m complete reportmg of all financial data m a more efficient and tJmely manner GENERAL LEDGER Inadequacies m Control Over Subs1d1ary Ledgers Fmdmg Control Number FS-550-02-02 t Our exammallon mcluded a review of the procedures utilized by the Uruvers1ty m recordmg transactions to the vanous modules compnsmg the GeorgiaF/RST accountmg system Our testmg revealed that, at June 30, 2002, the Umvers1ty"s general ledger module chd not balance with the subs1chary modules Tlus conchnon was pnmanly due to errors m posting subs1chary records dunng the conversion from the old College Uruvers1ty Fmanc1al AccountJng (CUFA) legacy accountmg system to the new GeorgiaF/RST accountmg system and due to transactions bemg posted to the general ledger module rather than m the appropnate subsidiary modules The Uruvers1ty chd not provtde a reconc1liat1on of the general ledger balances to the subs1chary records which resulted m extensive work required by the auditors to identify reconclimg items at June 30, 2002 Our testmg also revealed that certam general ledger balance sheet accounts for deferred revenues and accounts receivable, which are supported by mformatlon proVJded from the Uruvers1ty"s Banner Student Registration System, mcluded numerous errors These errors were the result of mcorrect postmgs between the Banner Student RegistratJon System module and the Uruvers1ty"s GeorgiaF/RSTaccountmg system Extensive procedures were reqwred to produce an accurate detail for these accounts. Net adJustmg entnes of $171,895 79 were made to accounts receivable and deferred revenues, respectively -I- SOUTHERN POLYTECHNIC STATE UNIVERSITY SCHEDULE OF FINDINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30, 2002 FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS GENERAL LEDGER Inadequacies m Control Over Subs1d1ary Ledgers Fmdmg Control Number FS-550-02-02 Management's failure to ensure that subs1d1ary records are accurate and properly support general ledger balances causes mternal reports to management, generated from these subs1d1ary records, to be maccurate and m1sleadmg This condltlon can lead to erroneous dec1s1ons by the Uruvers1ty's management and result m maccurate reportmg of financial mformanon To ensure accurate and nmely reporting of financial mformat1on from the subs1d1ary records, the Uruvers1ty should post transactions correctly to the appropnate subs1d1ary ledgers which support financial data reported m the general ledger. The Uruvers1tyshould develop appropnate controls and procedures to ensure that reconc1hat1ons of subsidiary ledgers and the general ledger are performed on a regular basis. -2-