DAHLONEGA, GEORGIA
MANAGEMENT REPORT for the FISCAL YEAR
ENDED JUNE 30, 2012
A Member Institution of the University System of Georgia
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY - TABLE OF CONTENTS -
SECTION I
FINANCIAL
LETTER OF TRANSMITTAL
SELECTED FINANCIAL INFORMATION
EXHIBITS
A STATEMENT OF NET ASSETS - (GAAP BASIS)
B STATEMENT OF REVENUES, EXPENSES AND CHANGES IN NET ASSETS (GAAP BASIS)
C STATEMENT OF CASH FLOWS - (GAAP BASIS)
D SELECTED FINANCIAL NOTES
SUPPLEMENTARY INFORMATION
SCHEDULES
1 BALANCE SHEET - (STATUTORY BASIS) BUDGET FUND 2 SUMMARY BUDGET COMPARISON AND SURPLUS ANALYSIS REPORT
(STATUTORY BASIS) BUDGET FUND 3 STATEMENT OF FUNDS AVAILABLE AND EXPENDITURES COMPARED TO BUDGET
BY PROGRAM AND FUNDING SOURCE (STATUTORY BASIS) BUDGET FUND
4 STATEMENT OF CHANGES TO FUND BALANCE BY PROGRAM AND FUNDING SOURCE (STATUTORY BASIS) BUDGET FUND
5 RECONCILIATION OF SALARIES AND TRAVEL
Page
2 3 5 6
24 25 26 28 31
SECTION II FINDINGS, QUESTIONED COSTS AND OTHER ITEMS SCHEDULE OF FINDINGS, QUESTIONED COSTS AND OTHER ITEMS
SECTION I FINANCIAL
Greg S. Griffin
STATE AUDITOR
(404) 656-2174
DEPARTMENT OF AUDITS AND ACCOUNTS
270 Washington Street, S.W., Suite 1-156 Atlanta, Georgia 30334-8400
October 2, 2012
Honorable Nathan Deal, Governor Members of the General Assembly of Georgia Members of the State Board of Regents of the University System of Georgia
and Honorable Bonita Jacobs, President North Georgia College and State University
Ladies and Gentlemen:
As part of our audits of the basic financial statements of the University System of Georgia presented in the Annual Financial Report for the University System of Georgia, the basic financial statements of the State of Georgia presented in the State of Georgia Comprehensive Annual Financial Report and the issuance of a State of Georgia Single Audit Report pursuant to the Single Audit Act Amendments, as of and for the year ended June 30, 2012, we have performed certain audit procedures at North Georgia College and State University. Accordingly, the financial statements and compliance activities of North Georgia College and State University were examined to the extent considered necessary in order to express an opinion as to the fair presentation of the 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 North Georgia College and State University as of and for the year ended June 30, 2012. Information contained in this report is a by-product of our audits of the basic financial statements of the University System of Georgia and the basic financial statements of the State of Georgia and is the representation of management. Accordingly, we do not express an opinion or any other form of assurance on it. The particular information provided which includes a section on findings and other items reported in accordance with Commission on Colleges regulation 2.11.1 is enumerated in the Table of Contents.
This report is intended solely for the information and use of the management of North Georgia College and State University, members of the Board of Regents of the University System of Georgia and the Southern Association of Colleges and Schools - Commission on Colleges and is not intended to be and should not be used by anyone other than these specified parties.
Respectfully,
GSG:as
Greg S. Griffin State Auditor
SELECTED FINANCIAL INFORMATION - 1 -
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY STATEMENT OF NET ASSETS - (GAAP BASIS) JUNE 30, 2012
ASSETS
Current Assets Cash and Cash Equivalents Accounts Receivable, Net (Note 3) Federal Financial Assistance Other Due From Affiliated Organizations Inventories Prepaid Items
Total Current Assets
Noncurrent Assets Noncurrent Cash Investments (Externally Restricted) Notes Receivable Capital Assets, Net (Note 4)
Total Noncurrent Assets
Total Assets
LIABILITIES
Current Liabilities Accounts Payable Salaries Payable Contracts Payable Deposits Deferred Revenue (Note 5) Deposits Held for Other Organizations Lease Purchase Obligations Compensated Absences
Total Current Liabilities
Noncurrent Liabilities Lease Purchase Obligations Compensated Absences
Total Noncurrent Liabilities
Total Liabilities
NET ASSETS
Invested in Capital Assets, Net of Related Debt Restricted for
Nonexpendable Expendable Unrestricted
Total Net Assets
EXHIBIT "A"
$ 13,928,987
521,528 2,415,253
52,925 1,246,356 2,655,526
$ 20,820,575
$
1,064,291
1,547,327
1,317,189
$ 207,741,575
$ 211,670,382
$ 232,490,957
$
418,689
150,703
11,823
2,013,854
3,396,061
349,485
1,698,087
960,202
$
8,998,904
$ 144,681,273 1,122,902
$ 145,804,175
$ 154,803,079
$ 61,362,215
2,742,748 1,957,410 11,625,505
$ 77,687,878
- 2 -
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY STATEMENT OF REVENUES, EXPENSES AND CHANGES IN NET ASSETS - (GAAP BASIS)
YEAR ENDED JUNE 30, 2012
OPERATING REVENUES
Student Tuition and Fees Less: Scholarship Allowances
Grants and Contracts Federal Other
Sales and Services of Educational Departments Auxiliary Enterprises
Residence Halls Bookstore Food Services Parking/Transportation Health Services Intercollegiate Athletics Other Organizations Other Operating Revenues
Total Operating Revenues
OPERATING EXPENSES
Salaries Faculty Staff
Employee Benefits Other Personal Services Travel Scholarships and Fellowships Utilities Supplies and Other Services Depreciation
Total Operating Expenses
Operating Income (Loss)
NONOPERATING REVENUES (EXPENSES)
State Appropriations Grants and Contracts
Federal State Other Gifts Interest and Other Investment Income Interest Expense Other Nonoperating Revenues/Expenses
Net Nonoperating Revenues
Income (Loss) Before Other Revenues, Expenses, Gains, or Losses
Capital Grants and Gifts State Other
Total Other Revenues, Expenses, Gains, or Losses
Decrease in Net Assets
Net Assets - Beginning of Year, Restated
Net Assets - End of Year
- 3 -
EXHIBIT "B"
$
36,498,574
-7,229,115
97,619 1,870
713,203
8,664,419 3,933,773 6,717,245 2,323,664
849,685 2,330,278
69,439 758,991
$
55,729,645
$
19,715,016
19,824,343
12,167,518
148,181
827,741
4,166,405
3,175,547
21,296,192
9,054,698
$
90,375,641
$ -34,645,996
$
20,634,869
11,526,362 39,444
1,546,022 866,020 72,797
-7,235,779 -22,440
$
27,427,295
$
-7,218,701
$
124,112
35,360
$
159,472
$
-7,059,229
84,747,107
$
77,687,878
(This page left intentionally blank)
NORTH GEORGIA COLLGE AND STATE UNIVERSITY STATEMENT OF CASH FLOWS - (GAAP BASIS) YEAR ENDED JUNE 30, 2012
CASH FLOWS FROM OPERATING ACTIVITIES Tuition and Fees Grants and Contracts Sales and Services of Educational Departments Payments to Suppliers Payments to Employees Payments for Scholarships and Fellowships Loans Issued to Students and Employees Collections of Loans to Students and Employees Auxiliary Enterprise Charges: Residence Halls Bookstore Food Services Parking/Transportation Health Services Intercollegiate Athletics Other Organizations Other Receipts (Payments)
Net Cash Provided (Used) by Operating Activities
CASH FLOWS FROM NONCAPITAL FINANCING ACTIVITIES State Appropriations Agency Funds Transactions Gifts and Grants Received for Other than Capital Purposes
Net Cash Flows Provided (Used) by Noncapital Financing Activities
CASH FLOWS FROM CAPITAL AND RELATED FINANCING ACTIVITIES Capital Gifts and Grants Received Proceeds from Sale of Capital Assets Purchases of Capital Assets Interest Paid on Capital Debt and Leases
Net Cash Provided (Used) by Capital and Related Financing Activities
CASH FLOWS FROM INVESTING ACTIVITIES Proceeds from Sale of Maturities of Investments Interest on Investments
Net Cash Provided (Used) by Investing Activities
Net Increase (Decrease) in Cash
Cash and Cash Equivalents - Beginning of Year
Cash and Cash Equivalents - End of Year
RECONCILIATION OF OPERATING LOSS TO NET CASH PROVIDED (USED) BY OPERATING ACTIVITIES:
Operating Income (Loss) Adjustments to Reconcile Operating Income to Net Cash
Provided (Used) by Operating Activities Depreciation Change in Assets and Liabilities: Accounts Receivable Inventories Prepaid Items Notes Receivable Accounts Payable Deferred Revenue Other Liabilities Compensated Absences
Net Cash Provided (Used) by Operating Activities
NONCASH ACTIVITY Fixed Assets Acquired by Incurring Captial Lease Obligations Change in Fair Value of Investments Recognized as a Component of Interest Income Change in Accrued Interest Payable Affecting Interest Paid Gift of Capital Assets Reducing Proceeds of Capital Grants and Gifts
- 5 -
EXHIBIT "C"
$
30,208,978
-4,988
713,203
-37,366,114
-40,741,674
-4,166,404
-318,533
101,197
8,824,074 3,019,176 5,532,130 2,352,440
853,501 2,340,496
65,568 3,177,245
$
-25,409,705
$
20,634,869
-954,280
13,977,849
$
33,658,438
$
124,112
11,581
-1,424,967
-6,951,208
$
-8,240,482
$
21,404
47,509
$
68,913
$
77,164
14,916,114
$
14,993,278
$
-34,645,996
9,054,698
1,533,903 83,468
-1,677,389 -217,336
-1,199,596 1,674,515
-25 -15,947
$
-25,409,705
$
46,246,530
$
25,288
$
-284,571
$
35,360
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY SELECTED FINANCIAL NOTES JUNE 30, 2012
EXHIBIT "D"
NOTE 1: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
REPORTING ENTITY North Georgia College and State University is one of thirty-five (35) State supported member institutions of higher education in Georgia which comprise the University System of Georgia, an organizational unit of the State of Georgia. The accompanying financial statements reflect the operations of North Georgia College and State University as a separate reporting entity.
The Board of Regents has constitutional authority to govern, control and manage the University System of Georgia. This authority includes but is not limited to the power to designate management, the ability to significantly influence operations, the authority to control institutions' budgets, the power to determine allotments of State funds to member institutions and the authority to prescribe accounting systems and administrative policies for member institutions. North Georgia College and State University does not have authority to retain unexpended State appropriations (surplus) for any given fiscal year. Accordingly, North Georgia College and State University is considered an organizational unit of the Board of Regents of the University System of Georgia reporting entity for financial reporting purposes because of the significance of its legal, operational, and financial relationships with the Board of Regents as defined in Section 2100 of the Governmental Accounting Standards Board (GASB) Codification of Governmental Accounting and Financial Reporting Standards.
On January 10, 2012, based on the Chancellor's recommendation, the Board of Regents voted to consolidate certain institutions of the University System of Georgia to enhance and improve educational offerings and student success. All final determinations regarding consolidations will be made by the Board, in consultation with the Chancellor. On January 1, 2013, North Georgia College and State University will merge with Gainesville State College to form the University of North Georgia.
FINANCIAL STATEMENT PREPARATION The financial statements have been prepared in accordance with generally accepted accounting principles (GAAP) as prescribed by the GASB and are presented as required by these standards to provide a comprehensive, entity-wide perspective of the University's assets, liabilities, net assets, revenues, expenses, changes in net assets and cash flows.
BASIC OF ACCOUNTING For financial reporting purposes, the University is considered a special-purpose government engaged only in business-type activities. Accordingly, the University's financial statements have been presented using the economic resources measurement focus and the accrual basis of accounting, except as noted in the preceding paragraph. Under the accrual basis, revenues, are recognized when earned, and expenses are recorded when an obligation has been incurred. All significant intraUniversity transactions have been eliminated.
The University has the option to apply all Financial Accounting Standards Board (FASB) pronouncements issued after November 30, 1989, unless FASB conflicts with GASB. The University has elected to not apply FASB pronouncements issued after the applicable date.
NET ASSETS The University's net assets are classified as follows:
Invested in capital assets, net of related debt: This represents the University's total investment in capital assets, net of outstanding debt obligations related to those capital assets. To the extent debt has been incurred but not yet expended for capital assets, such amounts are not included as a component of invested in capital assets, net of related debt.
- 6 -
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY SELECTED FINANCIAL NOTES JUNE 30, 2012
EXHIBIT "D"
NOTE 1: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
NET ASSETS Restricted net assets - nonexpendable: Nonexpendable restricted net assets consist of endowment and similar type funds in which donors or other outside sources have stipulated, as a condition of the gift instrument, that the principal is to be maintained inviolate and in perpetuity, and invested for the purpose of producing present and future income, which may either be expended or added to principal. The University may accumulate as much of the annual net income of an institutional fund as is prudent under the standard established by Code Section 44-15-7 of Annotated Code of Georgia.
Restricted net assets - expendable: Restricted expendable net assets include resources in which the University is legally or contractually obligated to spend resources in accordance with restrictions imposed by external third parties.
Unrestricted net assets: Unrestricted net assets represent resources derived from student tuition and fees, state appropriations, and sales and services of educational departments and auxiliary enterprises. These resources are used for transactions relating to the educational and general operations of the North Georgia College and State University and may be used at the discretion of the governing board to meet current expenses for those purposes, except for unexpended state appropriations (surplus) of $11,274.82. Unexpended state appropriations must be refunded to the Board of Regents of the University System of Georgia, University System Office for remittance to the Office of State Treasurer. These resources also include auxiliary enterprises, which are substantially self-supporting activities that provide services for students, faculty and staff.
CHANGE IN APPLICATION OF ACCOUNTING PRINCIPLE During fiscal year 2012, North Georgia College and State University changed its method of accounting for summer school revenues and expenses to more accurately reflect periodic results of operations between fiscal years. The effects of the change resulted in a net increase of revenues over expenses of $1,930,451 for prior year activity. Prior period net assets have been restated to properly reflect the effect of this change on beginning balances.
NOTE 2: DEPOSITS AND INVESTMENTS
DEPOSITS The custodial credit risk for deposits is the risk that in the event of a bank failure, the North Georgia College and State University's deposits may not be recovered. Funds belonging to the State of Georgia (and thus the University) cannot be placed in a depository paying interest longer than ten days without the depository providing a surety bond to the State. In lieu of a surety bond, the depository may pledge as collateral any one or more of the following securities as enumerated in the Official Code of Georgia Annotated Section 50-17-59:
1. Bonds, bills, notes, certificates of indebtedness, or other direct obligations of the United States or of the State of Georgia.
2. Bonds, bills, notes, certificates of indebtedness or other obligations of the counties or municipalities of the State of Georgia.
3. Bonds of any public authority created by the laws of the State of Georgia, providing that the statute that created the authority authorized the use of the bonds for this purpose.
- 7 -
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY SELECTED FINANCIAL NOTES JUNE 30, 2012
EXHIBIT "D"
NOTE 2: DEPOSITS AND INVESTMENTS
DEPOSITS 4. Industrial revenue bonds and bonds of development authorities created by the laws of the
State of Georgia.
5. Bonds, bills, certificates of indebtedness, notes or other obligations of a subsidiary corporation of the United States government, which are fully guaranteed by the United States government both as to principal and interest and debt obligations issued by the Federal Land Bank, the Federal Home Loan Bank, 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.
6. Guarantee or insurance of accounts provided by the Federal Deposit Insurance Corporation.
The Treasurer of the Board of Regents is responsible for all details relative to furnishing the required depository protection for all units of the University System of Georgia.
At June 30, 2012, the carrying value of deposits was $14,313,255 and the bank balance was $15,812,692. Of the University's deposits, $15,807,104 were collateralized with securities held by the financial institution, by its trust department or agency, but not in the University's name.
INVESTMENTS North Georgia College and State University maintains an investment policy which fosters sound and prudent judgment in the management of assets to ensure safety of capital consistent with the fiduciary responsibility each institution has to the citizens of Georgia and which conforms to Board of Regents investment policy. All investments are consistent with donor intent, Board of Regents policy, and applicable federal and state laws.
The University's investments as of June 30, 2012, are presented below. All investments are presented by investment type and debt securities are presented by maturity.
Investment Type
Fair Value
Less Than 1 Year
Investment Maturity
1 - 5 Years
6 - 10 years
More than 10 Years
Debt Securities General Obligation Bonds
$
1,112,581 $
30,150 $
212,632 $
492,252 $ 377,547
Other Investments Equity Securities - Domestic Miscellaneous Holdings
431,500 3,246
Investment Pools Board of Regents Short-Term Fund Office of the State Treasurer Georgia Fund 1
524,385 140,457
Total Investments
$
2,212,169
- 8 -
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY SELECTED FINANCIAL NOTES JUNE 30, 2012
EXHIBIT "D"
The Board of Regents Investment Pool is not registered with the Securities and Exchange Commission as an investment company. The fair value of investments is determined daily. The pool does not issue shares. Each participant is allocated a pro rata share of each investment at fair value along with a pro rata share of the interest that it earns. Participation in the Board of Regents Investment Pool is voluntary. The Board of Regents Investment Pool is not rated. Additional information on the Board of Regents Investment Pool is disclosed in the audited Financial Statements of the Board of Regents of the University System of Georgia System Office (oversight unit). This audit can be obtained from the Georgia Department of Audits Education Audit Division or on their web site at http://www.audits.ga.us. The Board of Regents Short-Term Fund is reported as Cash and Cash Equivalents on Exhibit "A" of this report.
The Georgia Fund 1 Investment Pool, managed by the Office of the State Treasurer, is not registered with the Securities and Exchange Commission as an investment company, but does operate in a manner consistent with the SEC's Rule 2a7 of the Investment Company Act of 1940. This investment is valued at the pool's share price, $1 per share. The Georgia Fund 1 Investment Pool is an AAAm rated investment pool by Standard and Poor's. The Weighted Average Maturity of the Fund is 48 days.
Interest Rate Risk Interest rate risk is the risk that changes in interest rates of debt investments will adversely affect the fair value of an investment. The University does not have a formal policy for managing interest rate risk.
Custodial Credit Risk Custodial credit risk for investments is the risk that, in the event of a failure of the counterparty to a transaction, the University will not be able to recover the value of the investment or collateral securities that are in the possession of an outside party. The University does not have a formal policy for managing custodial credit risk for investments.
At June 30, 2012, $1,112,581 of the University's applicable investments were uninsured and held by the investment's counterparty in the University's name.
Credit Quality Risk Credit quality risk is the risk that an issuer or other counterparty to an investment will not fulfill its obligations. The University does not have a formal policy for managing credit quality risk.
The investments subject to credit quality risk are reflected below:
Fair Value
AAA
Restricted Debt Investments General Obligation Bonds
$
1,112,581 $
1,112,581
Concentration of Credit Risk Concentration of credit risk is the risk of loss attributed to the magnitude of a government's investment in a single issuer. The University does not have a formal policy for managing concentration of credit risk.
- 9 -
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY SELECTED FINANCIAL NOTES JUNE 30, 2012
EXHIBIT "D"
Investment:
Total
General Obligation Bonds PrimeVest (Camden County Georgia Public Service Authority) General Obligation Bonds PrimeVest (DeKalb County Building Authority) General Obligation Bonds PrimeVest (Gilmer County Building Authority) General Obligation Bonds PrimeVest (Gwinnett County Water and Sewer) Equity Securities AT&T
6.1% 6.9% 7.2% 6.9% 7.5%
NOTE 3: ACCOUNTS RECEIVABLE
Accounts receivable consisted of the following at June 30, 2012.
Student Tuition and Fees
$
Auxiliary Enterprises and Other Operating Activities
Federal, State and Private Funds
Georgia State Financing and Investment Commission
Due from Affiliated organizations
Other
953,627 442,811 521,528 135,905
52,925 1,310,944
Less Allowance for Doubtful Accounts Net Accounts Receivable
$
3,417,740
428,034
$
2,989,706
- 10 -
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY SELECTED FINANCIAL NOTES JUNE 30, 2012
EXHIBIT "D"
NOTE 4: CAPITAL ASSETS
Following are the changes in the University's capital assets for the year ended June 30, 2012:
Balance
Balance
July 1, 2011
Additions
Reductions
June 30, 2012
Capital Assets, Not Being Depreciated: Land Construction Work-In-Progress
$
4,179,162
0$
$ 135,935
0$
4,179,162
135,935
Total Capital Assets, Not Being Depreciated $
4,179,162 $
135,935 $
0$
4,315,097
Capital Assets, Being Depreciated: Infrastructure Building and Building Improvements Facilities and Other Improvements Equipment Capital Leases Library Collections
$
3,883,833
89,916,929 $
10,904,086
5,656,040
100,773,590
6,481,413
35,360
766,274 $ 46,246,530
534,581
$
475,122 4,654
3,883,833 89,952,289 10,904,086
5,947,192 147,020,120
7,011,340
Total Assets Being Depreciated
Less: Accumulated Depreciation: Infrastructure Building and Building Improvements Facilities and Other Improvements Equipment Capital Leases Library Collections
$
217,615,891 $
47,582,745 $
$
2,487,424 $
29,425,631
3,172,294
4,268,024
8,981,750
4,348,315
50,401 2,240,543
766,948 441,145 $ 5,130,999 424,662
479,776 $
264,718,860
$
441,100 4,654
2,537,825 31,666,174
3,939,242 4,268,069 14,112,749 4,768,323
Total Accumulated Depreciation
$
Total Capital Assets, Being Depreciated, Net $
Capital Assets, Net
$
52,683,438 $ 164,932,453 $ 169,111,615 $
9,054,698 $ 38,528,047 $ 38,663,982 $
445,754 $ 34,022 $ 34,022 $
61,292,382 203,426,478 207,741,575
NOTE 5: DEFERRED REVENUE Deferred revenue consisted of the following at June 30, 2012.
Prepaid Tuition and Fees Other Deferred Revenue
Total Deferred Revenue
$
2,063,249
1,332,812
$
3,396,061
- 11 -
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY SELECTED FINANCIAL NOTES JUNE 30, 2012
EXHIBIT "D"
NOTE 6: LONG-TERM LIABILITIES The University's Long-Term liability activity for the year ended June 30, 2012 was as follows:
Beginning Balance July 1, 2011
Additions
Reductions
Ending Balance June 30, 2012
Current Portion
Leases Lease Obligations
Other Liabilities Compensated Absences
$ 99,848,259 $ 46,531,101
$ 146,379,360 $ 1,698,087
2,099,051
1,417,759 $ 1,433,706
2,083,104
960,202
Total Long-Term Obligations
$ 101,947,310 $ 47,948,860 $ 1,433,706 $ 148,462,464 $ 2,658,289
NOTE 7: NET ASSETS Changes in Net Asset activity for the year ended June 30, 2012 are as follows:
Beginning Balance July 1, 2011 (Restated)
Additions
Reductions
Ending
Balance June 30, 2012
Invested in Capital Assets Net of Related Debt
$
69,263,356 $ 47,718,680 $ 55,619,821 $
61,362,215
Restricted Net Assets
4,569,778
13,209,447
13,079,067
4,700,158
Unrestricted Net Assets
10,913,973
68,017,042
67,305,510
11,625,505
Total Net Assets
$
84,747,107 $ 128,945,169 $ 136,004,398 $
77,687,878
NOTE 8: LEASE OBLIGATIONS
North Georgia College and State University is obligated under various operating leases for the use of real property (land, buildings, and office facilities) and equipment, and also is obligated under capital leases and installment purchase agreements for the acquisition of real property and equipment.
CAPITAL LEASES Capital leases are generally payable in installments ranging from monthly to annually and have terms expiring in various years between 2028 and 2040. Expenses for fiscal year 2012 were $7.2 million which represented interest. Total principal on capital leases increased by $284,571 for capitalized interest and $46,246,530 for new capital leases for the fiscal year ended June 30, 2012. Interest rates range from 4.25 percent to 5.16 percent. The following is a summary of the carrying values of assets held under capital lease at June 30, 2012:
- 12 -
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY SELECTED FINANCIAL NOTES JUNE 30, 2012
EXHIBIT "D"
NOTE 8: LEASE OBLIGATIONS
CAPITAL LEASES
Description Land Infrastructure Buildings
Outstanding
Net Assets Held
Balances
Under Capital
per Lease
Accumulated
Lease at
Schedules at
Gross Amount
Depreciation
June 30, 2012
June 30, 2012
(+)
(-)
(=)
$
815,443
$
815,443
3,890,255 $
-823,819
3,066,436 $
3,401,582
143,129,865
-13,288,930
129,840,935
142,977,778
Total Assets Held Under Capital Lease
at June 30, 2012
$
147,835,563 $ -14,112,749 $ 133,722,814 $ 146,379,360
Certain capital leases provide for renewal and/or purchase options. Generally purchase options at bargain prices of one dollar are exercisable at the expiration of the lease terms.
North Georgia College and State University added three capital leases with the University's Real Estate Foundation, a discretely presented component unit in the current fiscal year. In March 2007, North Georgia College and State University entered into a capital lease of $3,254,259 whereby the University leased land and a building, Downtown Office Building, for a 29.33 year period that began March 2007 and expires June 2036. In March 2007, the University entered into a capital lease of $14,907,726 whereby the University leased a residence hall building for a 20 year period that began in March 2007 and expires 2028. In November 2008, the University entered into a capital lease of $26,001,722 whereby the University leased a Recreation Center/Parking Deck for a 28.17 year period that began November 2008 and expires June 2037. In August 2010, the University entered into a capital lease of $15,252,793 whereby the University leased a military dorm, Patriot Hall, for a 30 year period that began July 2011 and expires June 2040. In August 2010, the University entered into a capital lease of $24,815,545 whereby the University leased a resident hall building, North Georgia Suites, for a 30 year period that began July 2011 and expires June 2040. In August 2010, the University entered into a capital lease of $17,356,988 for a parking deck, Walker Drive Parking Deck, for a 30 year period that began July 2011 and expires June 2040. In July 2011, the University entered into a capital lease of $11,685,115 whereby the University leased a military dorm, Liberty Hall, for a 30 year period that began July 2011 and expires June 2040. In July 2011, the University entered into a capital lease of $23,244,947 whereby the University leased a dining hall for a 30 year period that began July 2011 and expires June 2040. In July 2011, the University entered into a capital lease of $11,316,469 whereby the University leased a multi-use facility, Chestatee Building, for a 30 year period that expires June 2040. The outstanding liability at June 30, 2012 on these capital leases is $146,379,360. The University at its option may terminate the lease for the unamortized principal balance and the payment of $1.
OPERATING LEASES North Georgia College and State University's noncancellable operating leases provide for renewal options for periods from one to three years at their fair rental value at the time of renewal. All agreements are cancelable if the State of Georgia does not provide adequate funding, but that is considered a remote possibility. In the normal course of business, operating leases are generally renewed or replaced by other leases. Operating leases are generally payable on a monthly basis. Examples of property under operating leases are copiers, other small business equipment, and buildings.
- 13 -
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY SELECTED FINANCIAL NOTES JUNE 30, 2012
EXHIBIT "D"
NOTE 8: LEASE OBLIGATIONS
OPERATING LEASES Noncancellable operating lease rental expenses in 2012 were $282,487 for real property and/or equipment.
FUTURE COMMITMENTS Future commitments for capital leases (which here and on the Statement of Net Assets include other installment purchase agreements) and for noncancellable operating leases having remaining terms in excess of one year as of June 30, 2012, were as follows:
Real Property and Equipment
Capital
Operating
Leases
Leases
Year Ending June 30: 2013 2014 2015 2016 2017 2018 - 2022 2023 - 2027 2028 - 2032 2033 - 2037 2038 - 2042
$
8,906,740 $
9,056,345
9,209,140
9,368,536
9,431,492
49,444,101
53,562,790
49,176,416
49,740,827
23,333,148
192,481 81,812 66,988 60,673 58,000
290,000 275,500
Total Minimum Lease Payments
$ 271,229,535 $
1,025,454
Less: Interest
124,850,175
Principal Outstanding
$ 146,379,360
NOTE 9: RETIREMENT PLANS
North Georgia College and State University participates in various retirement plans administered by the State of Georgia under two major retirement systems: Employees' Retirement System of Georgia (ERS System) and Teachers Retirement System of Georgia. These two systems issue separate publicly available financial reports that include the applicable financial statements and required supplementary information. The reports may be obtained from the respective system offices. The significant retirement plans that North Georgia College and State University participates in are described below. More detailed information can be found in the plan agreements and related legislation. Each plan, including benefit and contribution provisions, was established and can be amended by State law.
- 14 -
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY SELECTED FINANCIAL NOTES JUNE 30, 2012
EXHIBIT "D"
NOTE 9: RETIREMENT PLANS
Employees' Retirement System of Georgia The ERS System is comprised of individual retirement systems and plans covering substantially all employees of the State of Georgia except for teachers and other employees covered by the Teachers Retirement System of Georgia. One of the ERS System plans, the Employees' Retirement System of Georgia (ERS), is a cost-sharing multiple-employer defined benefit pension plan that was established by the Georgia General Assembly during the 1949 Legislative Session for the purpose of providing retirement allowances for employees of the State of Georgia and its political subdivisions. ERS is directed by a Board of Trustees and has the powers and privileges of a corporation. ERS acts pursuant to statutory direction and guidelines, which may be amended prospectively for new hires but for existing members and beneficiaries may be amended in some aspects only subject to potential application of certain constitutional restraints against impairment of contract.
On November 20, 1997, the Board created the Supplemental Retirement Benefit Plan (SRBP-ERS) of ERS. SRBP-ERS was established as a qualified governmental excess benefit plan in accordance with Section 415 of the Internal Revenue Code (IRC) as a portion of ERS. The purpose of the SRBP-ERS is to provide retirement benefits to employees covered by ERS whose benefits are otherwise limited by IRC Section 415. Beginning January 1, 1998, all members and retired former members in ERS are eligible to participate in the SRBP-ERS whenever their benefits under ERS exceed the limitation on benefits imposed by IRC Section 415.
The benefit structure of ERS is established by the Board of Trustees under statutory guidelines. Unless the employee elects otherwise, an employee who currently maintains membership with ERS based upon State employment that started prior to July 1, 1982, is an "old plan" member subject to the plan provisions in effect prior to July 1, 1982. Members hired on or after July 1, 1982 but prior to January 1, 2009 are "new plan" members subject to the modified plan provisions. Effective January 1, 2009, newly hired State employees, as well as rehired State employees who did not maintain eligibility for the "old" or "new" plan, are members of the Georgia State Employees' Pension and Savings Plan (GSEPS). ERS members hired prior to January 1, 2009 also have the option to irrevocably change their membership to the GSEPS plan.
Under the old plan, new plan, and GSEPS, a member may retire and receive normal retirement benefits after completion of 10 years of creditable service and attainment of age 60 or 30 years of creditable service regardless of age. Additionally, there are some provisions allowing for early retirement after 25 years of creditable service for members under age 60.
Retirement benefits paid to members are based upon a formula adopted by the Board of Trustees for such purpose. The formula considers the monthly average of the member's highest 24 consecutive calendar months of salary, the number of years of creditable service, and the member's age at retirement. Post-retirement cost-of-living adjustments may be made to members' benefits provided the members were hired prior to July 1, 2009. The normal retirement pension is payable monthly for life; however, options are available for distribution of the member's monthly pension, at reduced rates, to a designated beneficiary upon the member's death. Death and disability benefits are also available through ERS.
- 15 -
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY SELECTED FINANCIAL NOTES JUNE 30, 2012
EXHIBIT "D"
NOTE 9: RETIREMENT PLANS
Employees' Retirement System of Georgia Member contribution rates are set by law. Member contributions under the old plan are 4% of annual compensation up to $4,200 plus 6% of annual compensation in excess of $4,200. Under the old plan, North Georgia College and State University pays member contributions in excess of 1.25% of annual compensation. Under the old plan, these North Georgia College and State University contributions are included in the members' accounts for refund purposes and are used in the computation of the members' earnable compensation for the purpose of computing retirement benefits. Member contributions under the new plan and GSEPS are 1.25% of annual compensation. North Georgia College and State University is required to contribute at a specified percentage of active member payroll established by the Board of Trustees determined annually in accordance with actuarial valuation and minimum funding standards as provided by law. These North Georgia College and State University contributions are not at any time refundable to the member or his/her beneficiary.
Employer contributions required for fiscal year 2012 were based on the June 30, 2009, actuarial valuation as follows:
Old Plan* New Plan GSEPS
11.63% 11.63%
7.42%
* 6.88% exclusive of contributions paid by the employer on behalf of old plan members
Members become vested after 10 years of service. Upon termination of employment, member contributions with accumulated interest are refundable upon request by the member. However, if an otherwise vested member terminates and withdraws his/her member contributions; the member forfeits all rights to retirement benefits.
Teachers Retirement System of Georgia The Teachers Retirement System of Georgia (TRS) is a cost-sharing multiple-employer defined benefit plan created in 1943 by an act of the Georgia General Assembly to provide retirement benefits for qualifying employees in educational service. A Board of Trustees comprised of active and retired members and ex-officio State employees is ultimately responsible for the administration of TRS.
On October 25, 1996, the Board created the Supplemental Retirement Benefit Plan of the Georgia Teachers Retirement System (SRBP-TRS). SRBP-TRS was established as a qualified governmental excess benefit plan in accordance with Section 415 of the Internal Revenue Code (IRC) as a portion of TRS. The purpose of SRBP-TRS is to provide retirement benefits to employees covered by TRS whose benefits are otherwise limited by IRC Section 415. Beginning July 1, 1997, all members and retired former members in TRS are eligible to participate in the SRBP-TRS whenever their benefits under TRS exceed the IRC Section 415 imposed limitation on benefits.
TRS provides service retirement, disability retirement, and survivor's benefits. The benefit structure of TRS is defined and may be amended by State statute. A member is eligible for normal service retirement after 30 years of creditable service, regardless of age, or after 10 years of service and attainment of age 60. A member is eligible for early retirement after 25 years of creditable service.
- 16 -
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY SELECTED FINANCIAL NOTES JUNE 30, 2012
EXHIBIT "D"
NOTE 9: RETIREMENT PLANS
Teachers Retirement System of Georgia Normal retirement (pension) benefits paid to members are equal to 2% of the average of the member's two highest paid consecutive years of service, multiplied by the number of years of creditable service up to 40 years. Early retirement benefits are reduced by the lesser of one-twelfth of 7% for each month the member is below age 60 or by 7% for each year or fraction thereof by which the member has less than 30 years of service. It is also assumed that certain cost-of-living adjustments, based on the Consumer Price Index, will be made in future years. Retirement benefits are payable monthly for life. A member may elect to receive a partial lump-sum distribution in addition to a reduced monthly retirement benefit. Death, disability and spousal benefits are also available.
TRS is funded by member and employer contributions as adopted and amended by the Board of Trustees. Members become fully vested after 10 years of service. If a member terminates with less than 10 years of service, no vesting of employer contributions occurs, but the member's contributions may be refunded with interest. Member contributions are limited by State law to not less than 5% or more than 6% of a member's earnable compensation. Member contributions as adopted by the Board of Trustees for the fiscal year ended June 30, 2012, were 5.53% of annual salary. Employer contributions required for fiscal year 2012 were 10.28% of annual salary as required by the June 30, 2009, actuarial valuation.
The following table summarizes the North Georgia College and State University contributions by defined benefit plan for the years ending June 30, 2012, June 30, 2011, and June 30, 2010 (dollars in thousands):
ERS
TRS
Required
Percentage
Required
Percentage
Fiscal Year
Contribution
Contributed Contribution
Contributed
2012
$
2011
$
2010
$
Regents Retirement Plan
23,968 25,755 20,734
100% 100% 100%
$ 2,271,396 $ 2,078,284 $ 1,789,128
100% 100% 100%
Plan Description The Regents Retirement Plan, a single-employer defined contribution plan, is an optional retirement plan that was created/established by the Georgia General Assembly in O.C.G.A. 47-21-1 et.seq. and administered by the Board of Regents of the University System of Georgia. O.C.G.A. 47-3-68(a) defines who may participate in the Regents Retirement Plan. An "eligible university system employee" is a faculty member or a principal administrator, as designated by the regulations of the Board of Regents. Under the Regents Retirement Plan, a plan participant may purchase annuity contracts from four approved vendors (AIG-VALIC, American Century, Fidelity, and TIAA-CREF) for the purpose of receiving retirement and death benefits. Benefits depend solely on amounts contributed to the plan plus investment earnings. Benefits are payable to participating employees or their beneficiaries in accordance with the terms of the annuity contracts.
Funding Policy North Georgia College and State University makes monthly employer contributions for the Regents Retirement Plan at rates adopted by the Teachers Retirement System of Georgia Board of Trustees in accordance with State statute and as advised by their independent actuary. For fiscal year 2012, the employer contribution was 9.24% for the participating employee's earnable compensation. Employees contribute 5% of their earnable compensation. Amounts attributable to all plan contributions are fully vested and non-forfeitable at all times.
- 17 -
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY SELECTED FINANCIAL NOTES JUNE 30, 2012
EXHIBIT "D"
NOTE 9: RETIREMENT PLANS
Regents Retirement Plan North Georgia College and State University and the covered employees made the required contributions of $1,159,306 (9.24%) and $627,471 (5%), respectively.
AIG-VALIC, American Century, Fidelity, and TIAA-CREF have separately issued financial reports which may be obtained through their respective corporate offices.
Georgia Defined Contribution Plan
Plan Description North Georgia College and State University participates in the Georgia Defined Contribution Plan (GDCP) which is a single-employer defined contribution plan established by the General Assembly of Georgia for the purpose of providing retirement coverage for State employees who are temporary, seasonal, and part-time and are not members of a public retirement or pension system. GDCP is administered by the Board of Trustees of the Employees' Retirement System of Georgia.
Benefits A member may retire and elect to receive periodic payments after attainment of age 65. The payment will be based upon mortality tables and interest assumptions to be adopted by the Board of Trustees. If a member has less than $3,500 credited to his/her account, the Board of Trustees has the option of requiring a lump sum distribution to the member in lieu of making periodic payments. Upon the death of a member, a lump sum distribution equaling the amount credited to his/her account will be paid to the member's designated beneficiary. Benefit provisions are established by State statute.
Contributions Member contributions are seven and one-half percent (7.5%) of gross salary. There are no employer contributions. Contribution rates are established by State statute. Earnings are credited to each member's account in a manner established by the Board of Trustees. Upon termination of employment, the amount of the member's account is refundable upon request by the member.
Total contributions made by employees during fiscal year 2012 amounted to $115,175 which represents 7.5% of covered payroll. These contributions met the requirements of the plan.
The Georgia Defined Contribution Plan issues a financial report each fiscal year, which may be obtained from the ERS offices.
NOTE 10: RISK MANAGEMENT
The University System of Georgia offers its employees and retirees access to three different selfinsured healthcare plan options. Effective January 1, 2012, The Blue Cross Blue Shield of Georgia PPO and HDHP plan names were changed to BCBS Open Access PPO and HAS/HDHP Open Access POS, respectively; both plans use the Blue Cross Blue Shield Open Access POS network. Also effective January 1, 2012, the Consumer Choice Option was eliminated and the Blue Cross Blue Shield of Georgia HMO and the Kaiser Permanente HMO were frozen for new enrollment for active employees only; the Senior Advantage Plan 65+ remained open for new enrollment.
University and participating employees and retirees pay premiums to either of the self-insured healthcare plan options to access benefits coverage. The respective self-insured healthcare plan options are included in the financial statements of the Board of Regents of the University System of Georgia - University System Office. All units of the University System of Georgia share the risk of loss
- 18 -
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY SELECTED FINANCIAL NOTES JUNE 30, 2012
EXHIBIT "D"
NOTE 10: RISK MANAGEMENT
for claims associated with these plans. The reserves for these plans are considered to be a selfsustaining risk fund. The Board of Regents has contracted with Blue Cross Blue Shield of Georgia, a wholly owned subsidiary of WellPoint, to serve as the claims administrator for the self-insured healthcare plan products. In addition to the self-insured healthcare plan options offered to the employees of the University System of Georgia, a fully insured HMO healthcare plan option is also offered to System employees through Kaiser.
The Department of Administrative Services (DOAS) has the responsibility for the State of Georgia of making and carrying out decisions that will minimize the adverse effects of accidental loses that involve State government assets. The State believes it is more economical to manage its risks internally and set aside assets for claim settlement. Accordingly, DOAS processes claims for risk of loss to which the State is exposed, including general liability, property and casualty, workers' compensation, unemployment compensation, and law enforcement officers' indemnification. Limited amounts of commercial insurance are purchased applicable to property, employee and automobile liability, fidelity and certain other risks. College/University, as an organizational unit of the Board of Regents of the University System of Georgia, is part of the State of Georgia reporting entity, and as such, is covered by the State of Georgia risk management program administered by DOAS. Premiums for the risk management program are charged to the various state organizations by DOAS to provide claims servicing and claims payment.
A self-insured program of professional liability for its employees was established by the Board of Regents of the University System of Georgia under powers authorized by the Official Code of Georgia Annotated Section 45-9-1. The program insures the employees to the extent that they are not immune from liability against personal liability for damages arising out of the performance of their duties or in any way connected therewith. The program is administered by DOAS as a Self-Insurance Fund.
NOTE 11: CONTINGENCIES
Amounts received or receivable from grantor agencies are subject to audit and adjustment by grantor agencies. This could result in refunds to the grantor agency for any expenditure disallowed under grant terms. The amount of expenditures which may be disallowed by the grantor cannot be determined at this time although North Georgia College and State University expects such amounts, if any, to be immaterial to its overall financial positions.
Litigation, claims and assessments filed against North Georgia College and State University (an organizational unit of the Board of Regents of the University System of Georgia), if any, are generally considered to be actions against the State of Georgia. Accordingly, significant litigation, claims and assessments pending against the State of Georgia are disclosed in the State of Georgia Comprehensive Annual Financial Report for the fiscal year ended June 30, 2012.
NOTE 12: POST-EMPLOYMENT BENEFITS OTHER THAN PENSION BENEFITS
Pursuant to the general powers conferred by the Official Code of Georgia Annotated Section 20-3-31, the Board of Regents of the University System of Georgia has established group health and life insurance programs for regular employees of the University System of Georgia. It is the policy of the Board of Regents to permit employees of the University System of Georgia eligible for retirement or that become permanently and totally disabled to continue as members of the group health and life insurance programs. The policies of the Board of Regents of the University System of Georgia define and delineate who is eligible for these post-employment health and life insurance benefits.
- 19 -
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY SELECTED FINANCIAL NOTES JUNE 30, 2012
EXHIBIT "D"
NOTE 12: POST-EMPLOYMENT BENEFITS OTHER THAN PENSION BENEFITS
Organizational units of the Board of Regents of the University System of Georgia pay the employer portion for group insurance for affected individuals. With regard to life insurance, the employer covers the total cost for $25,000 of basic life insurance. If an individual elects to have supplemental, and/or, dependent life insurance coverage, such costs are borne entirely by the employee.
The Board of Regents Retiree Health Benefit Plan is a single employer defined benefit plan. Financial statements and required supplementary information for the Plan are included in the publicly available Consolidated Annual Financial Report of the University System of Georgia. The College pays the employer portion of health insurance for its eligible retirees based on rates that are established annually by the Board of Regents for the upcoming plan year. For the 2011 and 2012 plan years, the employer rate was between 70-75% of the total health insurance cost for eligible retirees and the retiree rate was between 25-30%.
As of June 30, 2012, there were 238 employees who had retired or were disabled that were receiving these post-employment health and life insurance benefits. For the year ended June 30, 2012, North Georgia College and State University recognized as incurred $1,196,305 of expenditures, which was net of $484,544 of participant contributions.
NOTE 13: AFFILIATED ORGANIZATIONS
The North Georgia College and State University Foundation, Inc. and North Georgia College and State University Real Estate Foundation, Inc. are legally separate, tax exempt organizations whose activities primarily support North Georgia College and State University. These affiliated organizations are considered potential component units of the State of Georgia in accordance with GASB Statement No. 39, Determining Whether Certain Organizations are Component Units. Therefore, the financial statements of these affiliated organizations are not included in these financial statements. Copies of the financial statements for the affiliated organizations may be obtained from North Georgia College and State University.
North Georgia College and State University Real Estate Foundation, Inc. has been determined significant to the State of Georgia for the year ended June 30, 2012, and as such, is reported as a discretely presented component unit in the Comprehensive Annual Financial Report of the State of Georgia (CAFR). The significant discretely presented component units issue separate audited financial statements that can be obtained from North Georgia College and State University.
NOTE 14: SUPPLEMENTARY INFORMATION
The supplementary information presented on Schedules 1, 2, 3 and 4 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. The information was derived from, and relates directly to, the same information used to prepare the financial statements. However, the budgetary statutes and regulations of the State of Georgia require reporting of certain information that is not in accordance with generally accepted accounting principles.
Presented below is a reconciliation of the fund balance of the Budget Fund, as reported on Schedule 1, to Net Assets of business-type activities, as reported on Exhibit A.
- 20 -
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY SELECTED FINANCIAL NOTES JUNE 30, 2012
EXHIBIT "D"
NOTE 14: SUPPLEMENTARY INFORMATION
Total Fund Balances - Budget Fund - Non-GAAP Basis (Schedule "1")
Amounts reported for Business-Type Activities in the Statement of Net Assets are different because:
Capital Assets used in Business-Type Activities are not reported in the Budget Fund.
Uncollectible accounts receivable are reported as an asset and reserved fund balance in the Budget Fund and as a contra-asset account on the Statement of Net Assets.
Funds placed on deposit with the Georgia State Financing and Investment Commission for use in capital outlay projects are reported as an outlay in the Budget Fund, but are included as a prepaid item on the Statement of Net Assets.
Changes in the Fair Market Value of Investments are recognized on the Statement of Net Assets, but are not reported in the Budget Fund.
Agency Fund activities are not reported as a component of the Budget Fund. Assets Liabilities Total Net Effect of Agency Fund Activity
Auxiliary Enterprises Fund activities are not reported as a component of the Budget Fund. Assets Liabilities Total Net Effect of Auxiliary Enterprises Fund Activity
Endowment Fund activities are not reported as a component of the Budget Fund. Assets Liabilities Total Net Effect of Endowment Fund Activity
Loan Fund activities are not reported as a component of the Budget Fund. Assets Liabilities Total Net Effect of Loan Fund Activity
Student Activities Fund activities are not reported as a component of the Budget Fund. Assets Liabilities Total Net Effect of Student Activity Fund Activity
The budgetary basis of accounting implemented by the State of Georgia recognizes expenditures when encumbered. The following adjustments were made to eliminate this activity for reporting on the Statement of Net Assets. Payables reported in the Budget Fund that are based on encumbrances are eliminated for GAAP reporting. Payables for goods and services provided in the current fiscal year reported in the Budget Fund as encumbrances payable are reported as accounts payable for GAAP reporting. Reimbursement from grantors reported as revenues in the Budget Fund that are for expenditures based on encumbrances are deferred for GAAP reporting. Total Net Effect of Encumbrance Activity
Certain Liabilities are not due and payable in the current period and therefore are not reported as liabilities in the Budget Fund. Capital Leases Payable Compensated Absences Payable Contracts Payable Total Liabilities
Rounding
Net Assets of Business-Type Activities (Exhibit "A")
- 21 -
$
2,029,401.61
$
604,960.41
-604,960.41
$
9,454,694.16
-2,171,477.00
$
2,742,747.98
0.00
$
1,746,266.87
0.00
$
1,817,484.63
-178,185.37
207,741,575.00 -271,885.63
1,277,086.00 -78,271.45 0.00
7,283,217.16 2,742,747.98 1,746,266.87 1,639,299.26
$
2,336,439.56
-77,814.05 -205,897.80
2,052,727.71
-146,379,360.00 -2,083,104.00 -11,823.00
$
-148,474,287.00 0.49
77,687,878.00
(This page left intentionally blank)
SUPPLEMENTARY INFORMATION - 23 -
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY BALANCE SHEET (STATUTORY BASIS) BUDGET FUND JUNE 30, 2012
ASSETS
Cash and Cash Equivalents Accounts Receivable
Federal Financial Assistance Other Prepaid Expenditures Inventories
Total Assets
LIABILITIES AND FUND EQUITY
Liabilities Accrued Payroll Encumbrances Payable Accounts Payable Deferred Revenue
Total Liabilities
Fund Balances Reserved Department Sales and Services Indirect Cost Recoveries Technology Fees Restricted/Sponsored Funds Uncollectible Accounts Receivable Tuition Carry-Over Inventories Unreserved Surplus
Total Fund Balances
Total Liabilities and Fund Balances
SCHEDULE "1"
$
5,416,813.72
521,528.06 1,584,571.82
78,657.70 60,624.15
$
7,662,195.45
$
137,298.80
2,336,439.56
318,046.19
2,841,009.29
$
5,632,793.84
$
258,271.60
113,303.37
142,406.93
289,414.19
271,885.63
882,873.79
59,971.28
11,274.82
$
2,029,401.61
$
7,662,195.45
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.
- 24 -
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY SUMMARY BUDGET COMPARISON AND SURPLUS ANALYSIS REPORT (STATUTORY BASIS)
BUDGET FUND YEAR ENDED JUNE 30, 2012
SCHEDULE "2"
REVENUES
State Appropriation State General Funds
Other Funds
Total Revenues
ADJUSTMENTS AND PROGRAM TRANSFERS
CARRY-OVER FROM PRIOR YEARS
Transfers from Reserved Fund Balance
Total Funds Available
EXPENDITURES
Teaching
Excess of Funds Available over Expenditures
FUND BALANCE JULY 1
Reserved Unreserved
ADJUSTMENTS
Prior Year Payables/Expenditures Unreserved Fund Balance (Surplus) Returned
to Board of Regents - University System Office Year Ended June 30, 2011
Early Return of Surplus in Current Fiscal Year Prior Year Reserved Fund Balance Included in Funds Available
FUND BALANCE JUNE 30
BUDGET
ACTUAL
VARIANCE FAVORABLE (UNFAVORABLE)
$ 20,639,078.00 $ 20,639,078.00 $
53,746,829.00
50,370,852.94
$ 74,385,907.00 $ 71,009,930.94 $
0.00
-1,704.12
0.00 -3,375,976.06
-3,375,976.06
-1,704.12
0.00
1,235,029.28
$ 74,385,907.00 $ 72,243,256.10 $
1,235,029.28 -2,142,650.90
$ 74,385,907.00 $ 70,574,168.40 $
$
0.00 $ 1,669,087.70 $
3,811,738.60 1,669,087.70
1,596,968.65 2,978.42
-395.04
-2,978.42 -1,230.42 -1,235,029.28 $ 2,029,401.61
SUMMARY OF FUND BALANCE
Reserved Department Sales and Services Indirect Cost Recoveries Technology Fees Restricted/Sponsored Funds Uncollectible Accounts Receivable Tuition Carry-Over Inventories
Total Reserved
Unreserved Surplus
$
258,271.60
113,303.37
142,406.93
289,414.19
271,885.63
882,873.79
59,971.28
$ 2,018,126.79
11,274.82
Total Fund Balance
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.
- 25 -
$ 2,029,401.61
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY STATEMENT OF FUNDS AVAILABLE AND EXPENDITURES COMPARED TO BUDGET BY PROGRAM AND FUNDING SOURCE
(STATUTORY BASIS) BUDGET FUND YEAR ENDED JUNE 30, 2012
Teaching State Appropriation State General Funds Other Funds
Total Teaching
Original Appropriation
Amended Appropriation
Final Budget
Current Year Revenues
$
21,060,284.00 $ 21,060,284.00 $ 20,639,078.00 $ 20,639,078.00
44,522,684.00
44,522,684.00
53,746,829.00
50,370,852.94
$
65,582,968.00 $ 65,582,968.00 $ 74,385,907.00 $ 71,009,930.94
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.
- 26 -
SCHEDULE "3"
Funds Available Compared to Budget
Prior Year
Adjustments and
Total
Carry-Over
Program Transfers Funds Available
Variance Positive (Negative)
Expenditures Compared to Budget
Variance
Actual
Positive (Negative)
Excess (Deficiency) of Funds Available
Over/(Under) Expenditures
$
0.00 $
1,235,029.28
0.00 $ 20,639,078.00 $ -1,704.12 51,604,178.10
0.00 $ 20,636,948.93 $ -2,142,650.90 49,937,219.47
2,129.07 $ 3,809,609.53
2,129.07 1,666,958.63
$ 1,235,029.28 $
-1,704.12 $ 72,243,256.10 $
-2,142,650.90 $ 70,574,168.40 $
3,811,738.60 $
1,669,087.70
- 27 -
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY STATEMENT OF CHANGES TO FUND BALANCE BY PROGRAM AND FUNDING SOURCE
(STATUTORY BASIS) BUDGET FUND YEAR ENDED JUNE 30, 2012
Teaching State Appropriation State General Funds Other Funds
Total Teaching
Prior Year Reserves Not Available for Expenditure Inventories Uncollectible Accounts Receivable
Beginning Fund Balance/(Deficit)
July 1
Fund Balance Carried Over from
Prior Period as Funds Available
Return of Fiscal Year 2011
Surplus
Prior Period Adjustments
$
-2,440.81 $
1,240,448.51
$
1,238,007.70 $
66,130.36 295,809.01
0.00 $ -1,235,029.28 -1,235,029.28 $
0.00 0.00
2,440.81 $ -5,419.23
-2,978.42 $
868.64 -1,263.68
-395.04
0.00 0.00
0.00 0.00
Budget Unit Totals
$
1,599,947.07 $
-1,235,029.28 $
-2,978.42 $
-395.04
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.
- 28 -
SCHEDULE "4"
Other Adjustments
Early Return Fiscal Year 2012
Surplus
Excess (Deficiency) of Funds Available
Over/(Under) Expenditures
Ending Fund Balance/(Deficit)
June 30
Analysis of Ending Fund Balance
Reserved
Surplus/(Deficit)
Total
$
1,331.63 $
28,750.83
$
30,082.46 $
-6,159.08 -23,923.38
$
0.00 $
-1,230.42 $ 0.00
-1,230.42 $
2,129.07 $ 1,666,958.63
1,669,087.70 $
3,098.92 $ 1,694,445.78
0.00 $ 1,686,269.88
1,697,544.70 $ 1,686,269.88 $
3,098.92 $ 8,175.90
3,098.92 1,694,445.78
11,274.82 $ 1,697,544.70
0.00 0.00
0.00 0.00
59,971.28 271,885.63
59,971.28 271,885.63
0.00 0.00
59,971.28 271,885.63
-1,230.42 $
1,669,087.70 $
2,029,401.61 $ 2,018,126.79 $
11,274.82 $ 2,029,401.61
Summary of Ending Fund Balance Reserved
Department Sales and Services Indirect Cost Recoveries Technology Fees Restricted/Sponsored Funds Uncollectible Accounts receivable Tuition Carry-Over Inventories Unreserved Surplus
Total Ending Fund Balance - June 30
$
258,271.60
113,303.37
142,406.93
289,414.19
271,885.63
882,873.79
59,971.28
$
$ 2,018,126.79 $
$
258,271.60
113,303.37
142,406.93
289,414.19
271,885.63
882,873.79
59,971.28
11,274.82
11,274.82
11,274.82 $ 2,029,401.61
- 29 -
(This page left intentionally blank)
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY RECONCILIATION OF SALARIES AND TRAVEL YEAR ENDED JUNE 30, 2012
SCHEDULE "5"
Totals per Annual Supplement
Accruals June 30, 2012 June 30, 2011
Prepaids June 30, 2012 June 30, 2011
Compensated Absences June 30, 2012 June 30, 2011
Salary Expense relating to Restatement of Beginning Net Assets
Rounding
SALARIES $ 40,155,792.26 $
TRAVEL 827,741.08
150,702.91 -249,531.81
-20,327.00 798,858.31
1,935,070.17 -1,949,884.36
-1,281,322.06
0.58
-0.08
$ 39,539,359.00 $
827,741.00
- 31 -
SECTION II FINDINGS, QUESTIONED COSTS AND OTHER ITEMS
NORTH GEORGIA COLLEGE AND STATE UNIVERSITY SCHEDULE OF FINDINGS, QUESTIONED COSTS AND OTHER ITEMS
YEAR ENDED JUNE 30, 2012
FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS No matters were reported. FEDERAL AWARD FINDINGS AND QUESTIONED COSTS No matters were reported. OTHER ITEMS (NOTED FOR MANAGEMENT'S CONSIDERATION) No matters were reported.