Management report, Columbus Technical College, Columbus, Georgia, an organizational unit of the state of Georgia, year ended June 30, 2004

STATE OF GEORGIA DEPARTMENT OF AUDITS AND ACCOUNTS
MANAGEMENT REPORT COLUMBUS TECHNICAL COLLEGE
COLUMBUS; GEORGIA
AN ORGANIZATIONAL UNIT OF THE STATE OF GEORGIA YEAR ENDED JUNE 30; 2004 Russell W. Hinton State Auditor

COLUMBUS TECHNICAL COLLEGE - TABLE OF CONTENTS -

SECTION I

FINANCIAL

LETTER OF TRANSMITTAL

SELECTED FINANCIAL INFORMATION

EXHIBITS

A STATEMENT OF NET ASSETS - (GAAP BASIS)

3

B STATEMENT OF REVENUES, EXPENSES AND CHANGES IN NET ASSETS -

(GAAP BASIS)

4

C STATEMENT OF CASH FLOWS - (GAAP BASIS)

5

D SELECTED FINANCIAL NOTES

6

SUPPLEMENTARY INFORMATION

SCHEDULES

1 BALANCE SHEET-(STATUTORY BASIS)- BUDGET FUND

"A" DEPARTMENT OF TECHNICAL AND ADULT EDUCATION

17

2 ANALYSIS OF CHANGES IN FUND BALANCE - (STATUTORY BASIS)

BUDGET FUND

"A" DEPARTMENT OF TECHNICAL AND ADULT EDUCATION

18

3 SCHEDULE OF FUNDS AVAILABLE AND EXPENDITURES

COMPARED TO BUDGET-(STATUTORY BASIS)

BUDGET FUND

"A" DEPARTMENT OF TECHNICAL AND ADULT EDUCATION 19

4 RECONCILIATION OF SALARIES AND TRAVEL

20

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
254 Washington Street, S.W., Suite 214 Atlanta, Georgia 30334-8400
September 7, 2004

Honorable Sonny Perdue, Governor Members of the General Assembly of Georgia Members of the State Board of Technical and Adult Education Members of the Local Board of Directors
and Honorable J. Robert Jones, President Columbus Technical 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 of the 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, 2004, we have performed certain audit procedures at Columbus Technical College. Accordingly, the financial statements and compliance activities of Columbus Technical College 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 Columbus Technical College as ofand for the year ended June 30, 2004. The particular information provided is enumerated in the Table of Contents.
This report is intended solely for the information and use ofmanagement and members ofthe Local Board of Directors of Columbus Technical College 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 -I-

COLUMBUS TECHNICAL COLLEGE STATEMENT OF NET ASSETS - (GMP BASIS)
JUNE 30. 2004
ASSETS
Current Assets Cash and Cash Equivalents Accounts Receivable. Net Federal Financial Assistance Other Prepaid Items
Total Current Assets
Noncurrent Assets Capital Assets, Net
Total Assets
LIABILITIES
Current Liabilities Accounts Payable Salaries Payable Deferred Revenue Funds Held for Others Capital Leases Compensated Absences
Total Current Liabilities
Noncurrent Liabilities Capital Leases Compensated Absences
Total Noncurrent Liabilities
Total Liabilities
NET ASSETS
Invested in Capital Assets, Net of Related Debt Unrestricted
Total Net Assets

EXHIBIT"A"

$

309,732.92

75,861.54 709,537.23
10,665.00

$ 1,105,796.69

14,557,565.64 $ 15,663,362.33

$

279,353.18

50,477.60

44,482.50

273,453.76

53,194.78

361,429.20

$ 1,062,391.02

$

111,736.67

325,608.56

$

437,345.23

$ 1,499,736.25

$ 14,392,634.19 -229,008.11

$ 14,163,626.08

-3-

COLUMBUS TECHNICAL COLLEGE

EXHIBIT "B"

STATEMENT OF REVENUES, EXPENSES AND CHANGES IN NET ASSETS - (GAAP BASIS)

YEAR ENDED JUNE 30, 2004

OPERATING REVENUES
Student Tuition and Fees Less: Scholarship Allowances
Grants and Contracts Federal
Rents and Royalties Sales and Services Other Operating Revenues
Total Operating Revenues
OPERATING EXPENSES
Salaries Benefits 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 Gifts Interest and Other Investment Income Interest Expense (Capital Assets)
Net Nonoperating Revenues
Income (Loss) Before Other Revenues, Expenses, Gains or Losses
Capital Grants and Gifts State
Increase (Decrease) in Net Assets
Net Assets - Beginning of Year
Net Assets - End of Year

$

4,207,780.49

-287,346.39

3,089,640.00 144,846.37
1,128,138.53 18 109.54

$ _ _8~,3_0_1,~1_68~.-'--54_

$

9,998,776.76

1,890,132.82

61,793.79

2,802,293.61

526,894.58

3,091,355.56

793 683.61

$ 19,164,930.73

$ -10,863,762.19

$

8,797,609.00

1,358,011.67 368,415.63 9,539.67 -10861.34

$ 10,522,714.63

$

-341,047.56

27,022.00 $ _ _--"-3-'--14'-'-,0'-"2"'-5'-".5~6 $ 14 477,651.64

$ 14,163,626.08

-4 -

COLUMBUS TECHNICAL COLLEGE STATEMENT OF CASH FLOWS - (GAAP BASIS)
YEAR ENDED JUNE 30. 2004
CASH FLOWS FROM OPERATING ACTIVITIES Tuition and Fees Grants and Contracts Sales and Services Payments to Scholarships and Fellowships Payments to Suppliers Payments to Employees 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 Grants and Gifts Received Purchases of Capital Assets Principal Paid on Capital Debt Interest Paid on Capital Debt
Net Cash Provided (Used) by Capital and Related Financing Activities
CASH FLOWS FROM INVESTING ACTIVITIES Interest on Investments
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 Expense Change in Assets and Liabilities: Receivables, Net Prepaid Items Salaries Payable Accounts Payable Deferred Revenue Compensated Absences
Net Cash Provided (Used) by Operating Activities
-5-

EXHIBIT "C"

$

4,009,874.00

3,089,640.00

842,445.22

-2,802,293.61

-5,629,320.23

-9,963,424.59

77,706.20

$ -10,375,373.01

$

8,797,609.00

252,926.87

1,943,911.59

$ 10,994,447.46

$

27,022.00

-295,472.25

-67,717.90

-10 861.34

$

-347,029.49

$

9,539.67

$

281,584.63

28 148.29

$ ===3=09=,7=3=2=.9=2

$ -10,863,762.19
793,683.61 -278,451.12
6,934.27 -36,961.97 -66,077.75
-3,052.00 72,314.14
$ -10,375,373.01

COLUMBUS TECHNICAL COLLEGE SELECTED FINANCIAL NOTES JUNE 30, 2004

EXHIBIT "D"

NOTE 1: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES
REPORTING ENTITY Columbus Technical College is one of thirty-three (33) State supported member colleges of postsecondary education in Georgia which comprise the Georgia Department ofTechnical and Adult Education, an organizational unit of the State of Georgia. The accompanying financial statements reflect the operations of Columbus Technical College as a separate reporting entity.
The Technical College's Local Board of Directors is composed of nine (9) members serving staggered three-year terms who are appointed by the State Board ofTechnical and Adult Education. Appropriation of State funds is made to the Georgia Department of Technical and Adult Education by the General Assembly of Georgia. The Department's Administrative Central Office determines the amount of State appropriations to be received by Columbus Technical College. The Technical College does not have authority to retain unexpended State appropriations (surplus) for any given fiscal year. Accordingly, Columbus Technical College is considered an organizational unit of the Georgia Department of Technical and Adult Education for financial reporting purposes because of the significance of its legal, operational, and financial relationships as defined in Section 2100 ofthe Governmental Accounting Standards Board (GASB) Codification ofGovernmental Accounting and Financial Reporting Standards.
NOTE 2: CASH AND CASH EQUIVALENTS AND OTHER DEPOSITS
STATE OF GEORGIA COLLATERALIZATION STATUTES AND POLICIES Funds belonging to Columbus Technical College (and thus the State of Georgia) 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, bill, certificates ofindebtedness, notes, or other direct obligations ofthe United States or of the State of Georgia.
2. Bonds, bills, certificates of indebtedness, notes, 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.
4. Industrial revenue bonds and bonds of development authorities created by the laws of the State of Georgia.

-6-

COLUMBUS TECHNICAL COLLEGE SELECTED FINANCIAL NOTES JUNE 30, 2004

EXHIBIT "D"

NOTE 2: CASH AND CASH EQUIVALENTS AND OTHER DEPOSITS

STATE OF GEORGIA COLLATERALIZATION STATUTES AND POLICIES 5. Bonds, bills, certificates of indebtedness, notes, or other obligations of a subsidiary corporation ofthe United States government, which are fully guaranteed by the United States government both as to principal and interest, or 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.

As authorized in the Official Code of Georgia Annotated Section 50-17-53, the State Depository Board has adopted policies, which allow agencies of the State of Georgia (and thus Columbus Technical College), the option of exempting demand deposits from the collateral requirements.

CATEGORIZATION OF DEPOSITS The Technical College's cash deposits are categorized by risk as follows:

Category 1 - Amounts covered by depository insurance or collateralized with securities (at fair value) held by the Technical College or by its agent in the Technical College's name.

Category 2 - Amounts collateralized with securities (at fair value) held by the pledging financial institution's trust department or agent in the Technical College's name.

Category 3 - Amounts collateralized with securities (at fair value) held by the pledging financial institution, or by its trust department or agent but not in the Technical College's name, and amounts uncollateralized.

At June 30, 2004, the Technical College's cash deposits were as follows:

Cash Deposits

Carrying Amount

Bank Balances

Risk Categories

2

3

$ 307,607.92 $ 1 126,121.ss $ 172,673.88 $ 954,047.97 $~~~o==.o==o

NOTE 3: ACCOUNTS RECEIVABLE

Accounts receivable at June 30, 2004, consists of the following:

-7-

COLUMBUS TECHNICAL COLLEGE SELECTED FINANCIAL NOTES JUNE 30, 2004

EXHIBIT "D"

NOTE 3: ACCOUNTS RECEIVABLE

Student Tuition and Fees Federal, State and Private Funds Other

$ 185,582.81 75,861.54
533,204.42

$ 794,648.77

Less: Allowance for Doubtful Accounts

9,250.00

Net Accounts Receivable

$ 785~398.77

NOTE 4: CAPITAL ASSETS

Following are the changes in capital assets for the year ended June 30, 2004:

Balance July 1, 2003

Additions

Reductions

Balance June 30, 2004

Capital Assets, Not Being Depreciated:

Land and Land Improvements

$ 2,482,905.00

$ 2,482,905.00

Capital Assets, Being Depreciated: Building and Building Improvements Improvements Other Than Buildings Equipment Library Collections

$ 17,223,361.00 679,060.00
3,506,498.42 $ 800,928.15

165,955.20 $ 129,517.05

$ 17,223,361.00

679,060.00

164,994.68 3,507,458.94

73,981.38

856,463.82

$ 22,209,847.57 $ 295,472.25 $ 238,976.06 $ 22,266,343.76

Less: Accumulated Depreciation: Buildings and Building Improvements $ Improvements Other Than Buildings Equipment Library Collections

5,918,079.82 $ 679,060.00
2,637,292.00 402,543.75

417,329.44
284,746.26 $ 91 607.91

$
164,994.68 73,981.38

6,335,409.26 679,060.00
2,757,043.58 420,170.28

$ 9,636,975.57 $ 793,683.61 $ 238,976.06 $ 10,191,683.12

Total Capital Assets, Being Depreciated,

Net

$ 12,572,872.00 $ -498,211.36 $

0.00 $ 12,074,660.64

Capital Assets, Net

$ 15 055.777.00 $ -498 21 I 36 $

0.00 $ 14,557.565 64

NOTE 5: DEFERRED REVENUE

Deferred revenue at June 30, 2004, consists of the following:

Prepaid Tuition and Fees

$ 44,482.50

-8-

COLUMBUS TECHNICAL COLLEGE SELECTED FINANCIAL NOTES JUNE 30, 2004

EXHIBIT "D"

NOTE 6: LONG-TERM LIABILITIES

Long-term liability activity for the year ended June 30, 2004 was as follows:

Leases Lease Obligations
Other Liabilities Compensated Absences
Total Long-Term Liabilities

Balance Julx 1, 2003

Additions

Reductions

Balance June 30, 2004

Current Portion

$ 232,649.35 $

0.00 $ 67,717.90 $ 164,931.45 $ 53,194.78

614,723.62

592,605.69

520,291.55

687 037.76

361,429.20

$ 847 372 97 $ 592 605.69 $ 588,009.45 $ 851,969.21 $ 414,623.98

NOTE 7: NET ASSETS

Changes in Net Asset activity for the year ended June 30, 2004 was as follows:

Invested in Capital Assets Net of Related Debt
Unrestricted Net Assets
Total Net Assets

Balance Julx I, 2003

Additions

Reductions

Balance June 30, 2004

$14,823,127.65 $ -498,211.36 $ -67,717.90 $14,392,634.19

-345 476.01 18,823,883.17 18,707,415.27

-229,008.11

$14,417 651.64 $ 18 325 671.81 $ 18 639 697.37 $ 14,163,626.08

NOTE 8: LEASE OBLIGATIONS

CAPITAL LEASES Columbus Technical College acquires certain equipment through multi-year capital leases with varying terms and options. These agreements contain fiscal funding clauses in accordance with Official Code of Georgia Annotated Section 50-5-64 which prohibits the creation of a debt to the State of Georgia for the payment of any sums under such agreements beyond the fiscal year of execution if appropriated funds are not available. If renewal of such agreements is reasonably assured, however, capital leases requiring appropriation by the General Assembly of Georgia are considered noncancellable for financial reporting purposes.

OPERATING LEASES Columbus Technical College has entered into certain agreements to lease land and equipment which are classified as operating leases (leases on assets not recorded on the balance sheet). These leases generally contain provisions that, at the expiration date of the original term of the lease, the Technical College has the option of renewing the lease on a year-to-year basis. Amounts are included only for multi-year leases and for cancelable leases for which an option to renew for the subsequent fiscal year has been exercised.

-9-

COLUMBUS TECHNICAL COLLEGE SELECTED FINANCIAL NOTES JUNE 30, 2004

EXHIBIT "D"

NOTE 8: LEASE OBLIGATIONS

OPERATING LEASES Expenses for rental ofland and equipment under operating leases for the year ended June 30, 2004, totaled $134,002.99.

SUMMARY OF LEASE OBLIGATIONS Future commitments for capital leases (which here and on the Statement ofNet Assets include other installment purchase agreements) and for noncancellable operating leases having remaining terms in excess of one year as of June 30, 2004, were as follows:

Capital Leases

Operating Leases

Year Ending June 30: 2005 2006 2007 2008

$ 60,706.35 $ 24,500.00

47,940.00

24,500.00

47,940.00

23,970.00

Total Minimum Lease Payments

$ 180,556.35 $ 49,000.00

Less: Interest Principal Outstanding

15,624.90 $ 164,931.45

NOTE 9: RETIREMENT PLANS

TEACHERS RETIREMENT SYSTEM OF GEORGIA

Plan Description Columbus Technical College participates in the Teachers Retirement System of Georgia (TRS), a cost-sharing multiple-employer defined benefit pension plan established by the General Assembly of Georgia for the purpose of providing retirement allowances and other benefits for teachers of the State of Georgia. TRS provides service retirement, disability retirement, and survivor's benefits for its members in accordance with State statute. The Teachers Retirement System of Georgia issues a separate stand alone financial audit report and a copy can be obtained from the Georgia Department of Audits and Accounts.

Funding Policy Employees ofColumbus Technical College who are covered by TRS are required by State statute to contribute 5% of their gross earnings to TRS. Columbus Technical College makes monthly employer contributions to TRS at rates adopted by the TRS Board of Trustees in accordance with

- 10 -

COLUMBUS TECHNICAL COLLEGE SELECTED FINANCIAL NOTES JUNE 30, 2004

EXHIBIT "D"

NOTE 9: RETIREMENT PLANS

TEACHERS RETIREMENT SYSTEM OF GEORGIA

Funding Policy State statute and as advised by their independent actuary. For fiscal year 2004, the employer contribution rate was 9.24% for covered employees. Employer contributions for the current fiscal year and the preceding two fiscal years are as follows:

Fiscal Year

Percentage Contributed

Required Contribution

2004 2003 2002

100% 100% 100%

$ 563,010.24 $ 546,222.71 $ 505,365.80

EMPLOYEES' RETIREMENT SYSTEM OF GEORGIA

Plan Description Columbus Technical College participates in the Employees' Retirement System ofGeorgia (ERS), a single-employer defined benefit pension plan established by the General Assembly ofGeorgia for the purpose of providing retirement allowances for employees of the State of Georgia.

Retirement benefits paid to members are based upon a formula which considers the monthly average of the member's highest twenty-four consecutive calendar months of salary, the number of years of creditable service, and the member's age at retirement. Postretirement cost-of-living adjustments are also made to member's benefits. The normal retirement pension is payable monthly for life; however, options are available for distribution ofthe 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.

In addition, the ERS Board of Trustees created the Supplemental Retirement Benefit Plan (SRBP) effective January 1, 1998. The SRBP was established as a qualified governmental excess benefit plan in accordance with Section 415 of the Internal Revenue Code (IRC) as a portion ofERS. The purpose ofSRBP is to provide retirement benefits to employees covered by ERS whose benefits are otherwise limited by IRC 415.

Funding Policy As established by State statute, all full-time employees of the State of Georgia and its political subdivisions, who are not members of other state retirement systems, are eligible to participate in the ERS. Both employer and employee contributions are established by State statute. The Technical College's payroll for the year ended June 30, 2004, for employees covered by ERS was $1,134,978.51. The Technical College's total payroll for all employees was $9,998,776.76.

- 11 -

COLUMBUS TECHNICAL COLLEGE SELECTED FINANCIAL NOTES JUNE 30, 2004

EXHIBIT "D"

NOTE 9: RETIREMENT PLANS
EMPLOYEES' RETIREMENT SYSTEM OF GEORGIA
Funding Policy Under the old plan, member contributions consist of 7.41 % of annual compensation. Of these member contributions, the employee pays the first 1.5% and the Technical College pays the remainder on behalf of the employee. Under the new plan, member contributions consist solely of 1.5% of annual compensation paid by employee. The Technical College also is required to contribute at a specified percentage of active member payroll determined annually by actuarial valuation. For the year ended June 30, 2004, the ERS employer contribution rate for the Technical College amounted to 10.15% ofcovered payroll. Employer contributions are also made on amounts paid for accumulated leave to retiring employees.
Total contributions to the plan made during fiscal year 2004 amounted to $129,394.91, of which $115,204.00 was made by the Technical College and $14,190.91 was made by employees. These contributions met the requirements of the plan.
GEORGIA DEFINED CONTRIBUTION PLAN
Plan Description Columbus Technical College participates in the Georgia Defined Contribution Plan (GDCP) which is a single-employer defined contribution plan established by the General Assembly ofGeorgia for the purpose ofproviding retirement coverage for State employees who are temporary, seasonal, and parttime 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 ofage 65. The payment will be based upon mortality tables and interest assumptions to be adopted by the Board ofTrustees. Ifa member has less than$ 3,500.00 credited to his/her account, the Board ofTrustees has the option ofrequiring a lump sum distribution to the member in lieu ofmaking periodic payments. Upon the death ofa 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.
The Employees' Retirement System of Georgia issues a financial report each fiscal year which may be obtained through ERS.
Contributions and Vesting Member contributions are seven and one-halfpercent (7.5%) ofgross 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. The
- 12 -

COLUMBUS TECHNICAL COLLEGE SELECTED FINANCIAL NOTES JUNE 30, 2004

EXHIBIT "D"

NOTE 9: RETIREMENT PLANS
GEORGIA DEFINED CONTRIBUTION PLAN
Contributions and Vesting Technical College's payroll for the year ended June 30, 2004, for employees covered by GDCP was $1,871,221.64. The Technical College's total payroll for all employees was $9,998,776.76.
Total contributions made by employees during fiscal year 2004 amounted to $140,296.10 which represents 7.5% of covered payroll. These contributions met the requirements of the plan.
NOTE 10: 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 expenses which are disallowed under grant terms. The amount of expenses which may be disallowed by the grantor cannot be determined at this time although Columbus Technical College expects such amounts, if any, to be immaterial to its overall financial position.
Litigation, claims and assessments filed against Columbus Technical College (an organizational unit of the Department of Technical and Adult Education), 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, 2004.
NOTE 11: RELATED ORGANIZATION DISCLOSURE
The financial statements of Columbus Technical College Foundation (foundation), which is a potential component unit of Columbus Technical College, are not included in these financial statements. Copies of Columbus Technical College Foundation's financial statements may be obtained from Columbus Technical College.

- 13 -

SUPPLEMENTARY INFORMATION - 15 -

COLUMBUS TECHNICAL COLLEGE BALANCE SHEET - (STATUTORY BASIS}
BUDGET FUND "A" DEPARTMENT OF TECHNICAL AND ADULT EDUCATION
JUNE 30, 2004

SCHEDULE "1"

ASSETS
Accounts Receivable Federal Financial Assistance Other
Prepaid Expenditures
Total Assets
LIABILITIES AND FUND EQUITY
Liabilities Cash Overdraft Accrued Payroll Accounts Payable Deferred Revenue
Total Liabilities
Fund Balances Reserved Federal Financial Assistance Live Work Projects Prior Year Local Funds Private Grant Uncollectible Accounts Unreserved Undesignated Surplus/Deficit Regular
Total Fund Equity
Total Liabilities and Fund Equity

$

88,612.25

701,142.66

10,665.00

$ =====8=00=-'=41=9=.9=1=

$

6,996.71

50,477.60

547,868.59

44,482.50

$

649,825.40

$

783.16

43,978.34

5,078.58

71,467.43

9,250.00

20,037.00

$

150,594.51

$ =~8;;,;0=0,l,:,4=1=9.;,;;9~1

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.
- 17 -

COLUMBUS TECHNICAL COLLEGE ANALYSIS OF CHANGES IN FUND BALANCE - (STATUTORY BASIS)
BUDGET FUND "A" DEPARTMENT OF TECHNICAL AND ADULT EDUCATION
YEAR ENDED JUNE 30. 2004

SCHEDULE "2"

FUND BALANCE - JULY 1. 2003 Reserved
ADDITIONS Adjustments to Prior Year's Contracts and Accounts Payable Excess of Funds Available over Expenditures Schedule "3"
DEDUCTIONS Adjustments to Prior Year's Accounts Receivable Reserved Fund Balance Carried Over from Prior Year as Funds Available
FUND BALANCE - JUNE 30. 2004

$

138,445.80

$

22,939.72

120,010.45

$

142,950.17

$

1,897.19

128,904.27

$

130,801.46

$ ===~15;;,;0;,.;,5;;;9~4;;:;.5~1

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.
- 18 -

COLUMBUS TECHNICAL COLLEGE SCHEDULE OF FUNDS AVAILABLE AND EXPENDITURES
COMPARED TO BUDGET- (STATUTORY BASIS) BUDGET FUND
"A" DEPARTMENT OF TECHNICAL AND ADULT EDUCATION YEAR ENDED JUNE 30. 2004

SCHEDULE "3"

FUNDS AVAILABLE REVENUES
State Appropriation Federal Revenues Other Revenues Retained
CARRY-OVER FROM PRIOR YEAR Transfer from Reserved Fund Balance

BUDGET

ACTUAL

VARIANCEFAVORABLE (UNFAVORABLE)

$

8,797,609.00 $

8,797,609.00 $

1,601,269.00

1,255,030.97

6,116,015.96

5,829,923.81

$

16,514,893.96 $

15,882,563.78 $

0.00 -346,238.03 -286,092.15
-632,330.18

0.00

128,904.27

128,904.27

$

16,514,893.96 $

16,011,468.05 $ _ _ _-_50_3-'-,4_2_5_.9_1

EXPENDITURES
Personal Services - Institutions Operating Expenses - Institutions

$

11,894,189.36 $

11,812,180.19 $

4,620,704.60

4,079,277.41

82,009.17 541,427.19

$

16,514,893.96 $

15,891,457.60 $ _ _ _6_2_3.:....,4_3_6._3_6

Excess of Funds Available over Expenditures

$

120,010.45 $ ==~1~20~,0~1~0,;,,;.4~5

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.
- 19 -

COLUMBUS TECHNICAL COLLEGE RECONCILIATION OF SALARIES AND TRAVEL
YEAR ENDED JUNE 30, 2004

SCHEDULE "4"

Totals per Annual Supplement
Accruals June 30, 2003 June 30, 2004
Compensated Absences June 30, 2003 June 30, 2004
Lag Salaries June 30, 2003 June 30, 2004
Agency Funds

SALARIES

TRAVEL

$

9,994,187.05 $

64,270.79

-87,439.57 50,477.60

-599,407.92 638,214.36

48,108.39 -45,363.15

-2,477.00

$

9,998,776.76 $ ==6=1=,7=9=3=7.=9

- 20-

SECTION II FINDINGS AND QUESTIONED COSTS

COLUMBUS TECHNICAL COLLEGE SCHEDULE OF FINDINGS AND QUESTIONED COSTS
YEAR ENDED JUNE 30, 2004 FINANCIAL STATEMENT FINDINGS AND QUESTIONED COSTS No matters were reported. FEDERAL AWARD FINDINGS AND QUESTIONED COSTS No matters were reported.
- 1-