STATE OF GEORGIA DEPARTMENT OF AUDITS AND ACCOUNTS MANAGEMENT REPORT MACON STATE COLLEGE MACON, GEORGIA AN ORGANIZATIONAL UNIT OF THE STATE OF GEORGIA YEAR ENDED JUNE 30, 2005 Russell W. Hinton State Auditor MACON STATE COLLEGE - TABLE OF CONTENTS - SECTION I FINANCIAL LETTER OF TRANSMITTAL SELECTED FINANCIAL INFORMATION EXHIBITS A BALANCE SHEET-(STATUTORY BASIS) "A" RESIDENT INSTRUCTION 3 B ANALYSIS OF CHANGES IN FUND BALANCE - (STATUTORY BASIS) "A" RESIDENT INSTRUCTION 4 C STATEMENT OF REVENUES AND EXPENDITURES COMPARED TO BUDGET - (STATUTORY BASIS) "A" RESIDENT INSTRUCTION 5 D RECONCILIATION OF SALARIES AND TRAVEL 7 SECTION II FINDINGS AND QUESTIONED COSTS SCHEDULE OF FINDINGS AND QUESTIONED COSTS SECTION I FINANCIAL Russell W. Hinton STATE AUDITOR (404) 656-2174 DEPARTMENT OF AUDITS AND ACCOUNTS 270 Washington Street, S.W., Suite 1-156 Atlanta, Georgia 30334-8400 September 12, 2005 Honorable Sonny Perdue, Governor Members of the General Assembly of Georgia Members of the State Board of Regents of the University System of Georgia and Honorable David Bell, President Macon State College Ladies and Gentlemen: As part ofour audit ofthe statutory basis financial statements ofthe State ofGeorgia presented in the State ofGeorgia Report ofthe State Auditor, the basic financial statements ofthe State of Georgia presented in the State ofGeorgia Comprehensive Annual Financial Report, and the issuance of a State ofGeorgia Single Audit Report pursuant to the Single Audit Act Amendments, as ofand for the year ended June 30, 2005, we have performed certain audit procedures at Macon State College. Accordingly, the financial statements and compliance activities of Macon State College were examined to the extent considered necessary in order to express an opinion as to the fair presentation ofthe financial statements contained in the foregoing documents and to issue reports on compliance and internal control as required by the Single Audit Act Amendments of 1996. This Management Report contains information pertinent to the financial and compliance activities of Macon State College as ofand for the year ended June 30, 2005. Information contained in this report is a by-product ofour engagement that is the representation ofmanagement, and accordingly, we do not express an opinion or any other form of assurance on it. The particular information provided is enumerated in the Table of Contents. This report is intended solely for the information and use of the management of Macon State College, and members of the Board of Regents of the University System of Georgia and is not intended to be and should not be used by anyone other than these specified parties. Respectfully submitted, RWH:gp State Auditor SELECTED FINANCIAL INFORMATION - 1- MACON STATE COLLEGE BALANCE SHEET (STATUTORY BASIS) "A" RESIDENT INSTRUCTION JUNE 30, 2005 ASSETS Cash and Cash Equivalents Investments Accounts Receivable Federal Financial Assistance Other Prepaid Expenditures Total Assets LIABILITIES AND FUND EQUITY Liabilities Accrued Payroll Accounts Payable Deferred Revenue Other Liabilities Total Liabilities Fund Balances Reserved Capital Outlay Continuing Education Indirect Cost Recoveries Technology Fees Restricted Funds Unreserved Undesignated Surplus Regular Total Fund Balances Total Liabilities and Fund Balances EXHIBIT"A" $ 2,182,529.45 375,748.99 288,972.52 3,539,866.33 4 538.44 $ 6,391 ,655. 73 $ 83,313.05 1,558,061.44 4,018,212.34 26,429.41 $ 5,686,016.24 $ 53,430.60 161,878.00 103,819.40 25,848.39 347,783.93 12,879.17 $ 705,639.49 $ 6,391,655.73 Statutory Basis financial information was prepared on a prescribed basis of accounting that demonstrates compliance with budgetary statutes and regulations of the State of Georgia, which is a comprehensive basis of accounting other than generally accepted accounting principles. -3- MACON STATE COLLEGE ANALYSIS OF CHANGES IN FUND BALANCE - (STATUTORY BASIS) "A" RESIDENT INSTRUCTION YEAR ENDED JUNE 30. 2005 EXHIBIT "B" FUND BALANCE - JULY 1. 2004 Reserved Surplus ADDITIONS Adjustments to Prior Year's Expenditures/Payables Excess of Funds Available over Expenditures Exhibit "C" DEDUCTIONS Unreserved Fund Balance (Surplus) Returned to Board of Regents - Administrative Central Office Year Ended June 30, 2004 Adjustments to Prior Year's Revenues/Receivables FUND BALANCE - JUNE 30, 2005 $ 498,813.13 19,313.19 $ 518,126.32 $ 1,710.41 243,563.50 $ 245,273.91 $ 19,313.19 38 447.55 $ 57,760.74 $ 705,639.49 Statutory Basis financial information was prepared on a prescribed basis of accounting that demonstrates compliance with budgetary statutes and regulations of the State of Georgia, which is a comprehensive basis of accounting other than generally accepted accounting principles. -4 - MACON STATE COLLEGE STATEMENT OF REVENUES AND EXPENDITURES COMPARED TO BUDGET- (STATUTORY BASIS) "A" RESIDENT INSTRUCTION YEAR ENDED JUNE 30. 2005 EXHIBIT"C" REVENUES State Appropriations Other Revenues Retained BUDGET ACTUAL VARIANCE FAVORABLE (UNFAVORABLE) $ 16.152,544.00 $ 16,152,544.00 $ 19,385,797.00 18,019,165.97 0.00 -1,366,631.03 $ 35,538,341.00 $ 34,171,709.97 $ _ _-~1,_36_6~,6_3_1_.0_3 EXPENDITURES Personal Services: Education, General and Departmental Services Sponsored Operations Operating Expenses: Education, General and Departmental Services Sponsored Operations Capital Outlay Special Funding Initiative $ 19,660,570.00 $ 19,567,284.88 $ 1,319,266.00 1,231,011.57 5,642,914.00 7,401,455.00 1,289,375.00 224,761.00 4,992,031.14 7,161,615.25 751,442.63 224,761.00 93,285.12 88,254.43 650,882.86 239,839.75 537,932.37 0.00 $ 35.538,341.00 $ 33,928,146.47 $ _ _1~,6_10~,_19_4_.5_3 Excess of Revenues over Expenditures $ 243,563.50 $ ===24=3=,5=6=3=5.=0 Statutory Basis financial information was prepared on a prescribed basis of accounting that demonstrates compliance with budgetary statutes and regulations of the State of Georgia, which is a comprehensive basis of accounting other than generally accepted accounting principles. -5- MACON STATE COLLEGE RECONCILIATION OF SALARIES AND TRAVEL YEAR ENDED JUNE 30, 2005 EXHIBIT"D" Totals per Annual Supplement Accruals June 30, 2005 June 30, 2004 Compensated Absences June 30, 2005 June 30, 2004 Adjustments Agency Funds Totals per GAAP Basis as Reported in the Consolidated Annual Financial Report SALARIES $ 17,218,850.51 $ TRAVEL 181,872.72 85,572.03 -73, 199.80 753,568.73 -721,275.35 -17,689.02 $ 17,245,827.10 $ ==1=8=1"'=,8=72=.7=2= -7- SECTION II FINDINGS AND QUESTIONED COSTS MACON STATE COLLEGE SCHEDULE OF FINDINGS AND QUESTIONED COSTS YEAR ENDED JUNE 30, 2005 FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS No matters were reported. FEDERAL AWARD FINDINGS AND QUESTIONED COSTS No matters were reported.