AUSTIN COMMUNITY COLLEGE DISTRICT FINANCIAL STATEMENTS
December 2015
By Austin Community College Business Services Neil Vickers, EVP, Finance & Administration
Austin Community College 5930 Middle Fiskville Road Austin, Texas 78752
EVP, FINANCE AND ADMINISTRATION
TO:
Dr. Richard Rhodes
FROM:
Neil Vickers
DATE:
1/26/16
RE:
FY 2016 – December Financial Statements
Attached are the December 2015 financial statements. Items to note in the November Statements: Based on current information, the College’s budget is on track and projecting a positive $9.3 million in Net Revenues & Expenses, and a $13.7 million increase in Net Assets.
Year to date, student headcount is up about 1%. However, due to required reductions in instructional time for certain courses (especially foreign languages), credit hours are flat to slightly down. As such, enrolments are below budgeted projections of 2% growth. Travis County appraisals came in higher than originally estimated, and therefore property tax revenues are above budget. Salary expenses are under budget due to lapsed salaries (vacancies) and enrollments being slightly under budget.
Summary In summary, adjusting revenues up by $3.2 million and expenses down by $6.1 million, Net Revenues over Expenses project a budget surplus of about $9.3 million and an increase in Net Assets of about $13.7 million. Cash and Investments are in line at approximately $264 million, including $165 million in bond proceeds. Please let me know if I can provide you with additional information.
AUSTIN COMMUNITY COLLEGE DISTRICT Revenue Summary For the Period of 9/1/15 to 12/31/15
1
2
3
4
REVENUES OPERATING REVENUES Credit Tuition Out-of-District Fee General Fee Student Activities Fee Sustainability Fee Course Fees Exemptions/Waivers State Appropriations - Contact Hours State Appropriations - HEGI State Appropriations - TRS State Appropriations - VCT State Appropriations - ACE Property Taxes - M&O Property Taxes - I&S Indirect Cost Recovery Interest Income Other Revenue Continuing Education Sales & Services Auxiliary - Other TOTAL OPERATING REVENUES:
FY2016 Budget
$
Received YTD
58,302,438 23,454,882 11,405,936 1,520,791 760,396 4,000,000 (14,000,000) 43,791,542 9,147,910 4,250,000 481,250 2,500,000 136,743,248 16,722,843 500,000 300,000 3,750,000 5,750,000 2,500,000 900,000 312,781,236 $
44,953,097 18,650,102 8,689,269 1,158,561 579,281 2,966,321 (12,042,203) 18,818,381 3,049,303 1,468,040 206,938 2,150,000 36,528,627 16,722,843 196,662 151,118 1,174,921 3,536,116 754,386 405,942 150,117,705 $
Projected 8/31/16
Projected vs. Budget
57,301,681 22,686,027 11,174,078 1,485,774 742,888 3,734,126 (16,272,814) 43,779,560 9,147,910 4,301,373 481,251 2,500,000 143,145,997 16,722,843 513,374 366,741 3,520,875 6,749,832 2,283,958 1,614,899 315,980,372 $
(1,000,757) (768,855) (231,858) (35,017) (17,508) (265,874) (2,272,814) (11,982) 51,373 1
Projected 8/31/16
Projected vs. Budget
6,402,749 13,374 66,741 (229,125) 999,832 (216,042) 714,899 3,199,136
% Variance of Budget
Comments SCH Enrollments up 0% compared to projected growth of 2% SCH Enrollments down 1% compared to projected growth of 2% SCH Enrollments up 0% compared to projected growth of 2% SCH Enrollments up 0% compared to projected growth of 2% SCH Enrollments up 0% compared to projected growth of 2% SCH Enrollments up 0% compared to projected growth of 2% Dual/ECHS enrollment up about 10%
Final Travis County appraisals came in above initial estimates
Golf Course Operations 1.02%
REVENUE FOOTNOTES: 1
FY2016 Budget
Details of Credit Tuition:
Received YTD
42,328,634
31,883,954
41,126,735
(1,201,899)
SCH Enrollments down 1% compared to projected growth of 2%
Out-of-District Tuition
7,078,726
5,629,354
6,866,364
(212,362)
SCH Enrollments down 1% compared to projected growth of 2%
Out-of-State Tuition
8,270,078
6,983,107
8,683,582
413,504
625,000 58,302,438
456,682 44,953,097
625,000 57,301,681
In-District Tuition
Repeated Course Tuition Total Credit Tuition
$
$
$
$
(1,000,757)
1
SCH Enrollments up 5% compared to projected growth of 2%
AUSTIN COMMUNITY COLLEGE DISTRICT Revenue Summary For the Period of 9/1/15 to 12/31/15
2
Details of Exemptions/Waivers
In-District
Teaching/Research Assistants (waived OOD Fee) Adopted Students Visually/Hearing Impaired Students Children of Disabled/Deceased Police/Fire Officers Dependents of Deceased Public Servants Children of Prisoners of War or Person MIA Children of Professional Nursing Program Fac/Staff Fire Fighter Exemption Criminal Justice Foster Care Students Hazelwood Act-Veteran's Program (Credit) Hazelwood Act-Veteran's Program (Non-Credit) Fully Funded - City of Austin Fire Department Fully Funded - City of Austin Police Department Fully Funded - Travis County Sheriff Cadets Fully Funded - Hays County Sheriff Cadets Fully Funded - Oak Hill Fire Department Highest Ranking High School Graduate-Valedictorian Senior Citizens (65 or Older) Ad Valorem (Waived OOD Fee) Dual Credit Early College High School PACE/Pathways OOD Waivers
74,207 188,059 5,492
Total Exemptions/Waivers 3
4
$
Details of Other Revenue Insurance Fee Child Lab Tuition International Student Fee ECS Out-of-District Fee Parking Fees Installment Fees Transcripts Property Rental Testing Fees Library Fees Purchasing Card Rebates Other Total Other Revenue
Details of Auxiliary Revenues ACC Bookstores Vending Machines Cafes Cell Tower Leases Other Total Auxiliary Revenues
Out-Of-District
$ FY2016 Budget 700,000 125,000 50,000 20,000 5,000 900,000
Out-of-State
113,147 147,214
3,837
871 804 9,909 94,940 739,697 61,875
201 1,005 59,072 1,398,859 12,442
4,962 -
3,283 7,566
3,757 10,095
1,319
2,492,143 433,331
5,395,655 246,726 522,655
4,112,178
$
7,910,827
9,080
$
19,198
Total 187,354 339,110 5,492 871 1,005 10,914 154,012 2,143,518 74,317 7,040 18,980 7,896,878 680,057 522,655
State mandated State mandated State mandated State mandated State mandated State mandated State mandated State mandated State mandated State mandated State mandated State mandated College Waived College Waived College Waived College Waived College Waived College Waived College Waived College Waived College Waived College Waived College Waived
$ 12,042,203
Received YTD 226,933 55,738 13,200 103,350 195,200 130,980 10,975 281,235 87,462 14,322 55,526 1,174,921
Received YTD 322,131 43,540 2,275 24,936 13,060 405,942
Projected 8/31/16 700,000 162,245 50,000 25,000 677,654 1,614,899
Projected vs. Budget 37,245 5,000 672,654 714,899
2
Golf Course Revenue
AUSTIN COMMUNITY COLLEGE DISTRICT Expenditures and Transfers Summary For the Period of 9/1/15 to 12/31/15
1
2
OPERATING EXPENSES SALARIES: Full-Time Faculty Salaries Adjunct Faculty Salaries Full-Time Faculty Overload N-T Faculty Salaries Hourly Faculty Salaries AE Instructional Salaries Stipends/Temporary Assignment Pay Administrative Salaries Prof-Tech Salaries Classified Salaries Hourly Wages Overtime Wages Employee Benefits TOTAL SALARIES:
FY2016 Budget
$
45,033,558 29,018,196 7,287,578 6,379,233 142,920 419,518 964,015 6,219,246 29,074,154 41,031,526 9,886,447 250,281 33,759,000 209,465,672
CONSUMABLE SUPPLIES
$
TRAVEL
Projected 8/31/16
Expended YTD
$
14,038,872 12,268,511 2,451,726 2,041,124 41,124 102,615 355,750 2,084,384 8,697,309 12,131,112 3,111,463 130,228 11,371,654 68,825,872
6,266,762
$
$
1,239,156
OPERATING EXPENSES
$
UTILITIES EQUIPMENT, FURNITURE, BOOKS
Projected vs. Budget
Comments Vacancies
$
41,979,611 29,456,572 7,354,759 6,132,948 142,926 298,319 1,063,195 6,609,416 26,061,461 38,020,648 9,538,736 291,930 33,759,000 200,709,522
$
1,208,776
$
6,266,762
$
-
0.00%
$
353,213
$
1,239,156
$
-
0.00%
21,621,979
$
8,732,640
$
22,313,037
$
691,058
3.20%
$
5,210,000
$
1,321,192
$
5,333,794
$
123,794
2.38%
$
6,539,270
$
1,800,205
$
6,539,270
$
-
0.00%
3
(3,053,947) 438,376 67,181 (246,285) 6 (121,199) 99,180 390,170 (3,012,693) (3,010,878) (347,711) 41,649 (8,756,150)
% Variance of Budget
Vacancies Vacancies Vacancies Vacancies
-4.18%
OPERATING EXPENSES TRANSFERS: To Plant To Debt Service (Revenue Bonds) To Debt Service (G.O. Tax Bonds) To Debt Service (PFC Bonds) Matching Funds (e.g. FSEOG) Tx. Public Ed. Grant (TPEG) Institutional Advancement TOTAL TRANSFERS:
FY2016 Budget
$
4,760,396 11,674,742 16,722,843 11,600,391 350,000 2,942,535 3,000,000 51,050,907
VIRTUAL COLLEGE OF TEXAS
$
ADULT CAREER EDUCATION
Projected 8/31/16
Expended YTD
$
-
$
4,760,396 11,674,742 16,722,843 11,600,391 350,000 2,942,535 3,000,000 51,050,907
481,250
$
101,615
$
$
2,300,000
$
1,156,075
CONTINUING EDUCATION
$
5,750,000
$
SALES & SERVICES
$
2,500,000
AUXILIARY
$
TOTAL OPERATING EXPENSES:
NET REVENUES - EXPENSES
Projected vs. Budget
% Variance of Budget
$
-
0.00%
481,250
$
-
0.00%
$
2,300,000
$
-
0.00%
2,968,250
$
6,805,657
$
1,055,657
18.36%
$
677,475
$
2,244,238
$
356,240
$
1,221,066
$
1,437,076
$
1,080,836
$
312,781,236
$
88,366,379
$
306,720,669
$
(6,060,567)
$
-
$
61,751,326
$
9,259,703
$
9,259,703
$ $ $ $ $ $ $ $ $ $ $ $
9,259,703 3,000,000 2,000,000 500,000 13,151,421 (750,000) (13,500,000) 13,661,124
CHANGE IN TOTAL NET ASSETS Net Revenues - Expenses Institutional Advancement Capital Equipment Capital Facilities Improvements Facilities Improvements in Progress Principal on Debt Service Payment Interest Earned on Bond Proceeds Bond Accruals Unrealized Gain/(Loss) Non-Cap Expenses with Bond Proceeds Depreciation PROJECTED CHANGE IN TOTAL NET ASSETS
(255,762)
Comments
-10.23% 303.40% Golf Course Operations -1.94%
2.96% Additional amount available for Institutional Advancement.
AUSTIN COMMUNITY COLLEGE DISTRICT Expenditures and Transfers Summary For the Period of 9/1/15 to 12/31/15
FY2016 Budget
OPERATING EXPENSES
1
2
Expenditures Footnotes: Employee Benefit Details: Work Comp/Unemploy. Ins Annual Leave Medicare Match Retirement Match Health Insurance Premiums - Active Health Insurance Premiums - Retiree Dental Insurance - Active Dental Insurance - Retiree Life/Disability/AD&D Insurance Employee Assistance Program Employee Tuition Vouchers/Reimburse Total Benefits Operating Expense Details: Legal Auditing Tax Appraisal/Collection Fees Bank/Credit Card Fees Consultants/Honoraria/Professional Serv. Property/Liability Insurance Advertising Leases & Rentals Software and Software Licenses Printing Postage Telecommunications Repair & Maintenance Other Operating Expenses Total Operating Expense
$
699,000 300,000 2,000,000 10,005,000 16,100,000 2,500,000 550,000 400,000 870,000 85,000 250,000 33,759,000
$
317,300 275,000 1,250,000 800,100 1,355,748 832,392 1,183,538 1,803,688 2,905,458 930,857 430,071 904,509 5,931,324 2,701,994 21,621,979
Projected 8/31/16
Expended YTD
$
258,949 758,919 3,070,610 5,368,394 807,262 162,285 318,382 30,428 156,594 10,931,823
$
99,360 147,688 877,288 109,634 329,326 548,185 220,876 694,840 1,917,620 71,138 9,810 428,434 1,998,352 1,280,089 8,732,640
$
699,000 300,000 2,000,000 10,005,000 16,100,000 2,500,000 550,000 400,000 870,000 85,000 250,000 33,759,000
$
317,300 275,000 1,250,000 800,100 1,355,748 832,392 1,183,538 1,803,688 2,905,458 930,857 430,071 904,509 5,931,324 3,393,052 22,313,037
5
Projected vs. Budget
% Variance of Budget
$
-
0.00%
$
691,058 691,058
3.20%
Comments
Year-End Entry
Year-End Entry
Bad Debt Allowance
AUSTIN COMMUNITY COLLEGE DISTRICT FY2016 MONTHLY BUDGET PROJECTIONS BY OBJECT CATEGORY UNRESTRICTED FUNDS ONLY
REVENUES TUITION OUT-OF-DISTRICT FEE GENERAL FEE STUDENT ACTIVITIES FEE SUSTAINABILITY FEE COURSE FEES EXEMPT TUITION FEES STATE APPROPRIATIONS STATE APPROPRIATIONS-HEGI STATE APPROPRIATIONS-TRS STATE APPROPRIATIONS-VCT STATE APPROPRIATIONS-ACE PROPERTY TAXES - M&O PROPERTY TAXES - I&S INDIRECT COST RECOVERY INVESTMENT INCOME OTHER SOURCES CONTINUING EDUCATION SALES & SERVICES AUXILIARY SERVICES
EXPENDITURES F-T FACULTY SALARIES ADJUNCT FACULTY SALARIES F-T FACULTY OVERLOAD N-T FACULTY SALARIES HOURLY FACULTY SALARIES ABE INSTRUCTIONAL SALARIES STIPENDS ADMINISTRATIVE SALARIES PROF-TECH SALARIES CLASSIFIED SALARIES HOURLY WAGES OVERTIME WAGES BENEFITS CONSUMABLE SUPPLIES PROF. DEV./MILEAGE OPERATING EXPENSES UTILITIES EQUIPMENT TRANSFERS VIRTUAL COLLEGE OF TEXAS ADULT CAREER EDUCATION CONTINUING EDUCATION SALES & SERVICES AUXILIARY EXPENSES
NET REVENUE/EXPENSE
Actual Sep-15
Actual Oct-15
Actual Nov-15
Actual Dec-15
Projected Jan-16
Projected Feb-16
Projected Mar-16
Projected Apr-16
Projected May-16
Projected Jun-16
Projected Jul-16
Projected Aug-16
Total
Variance
2016 BUDGET 9/1/2015
24,620,831 10,241,080 4,760,849 634,779 317,390 1,592,696 (6,463,903) 5,254,985 762,326 354,167 57,750 300,000 53,371 0 38,331 537 472,599 1,824,370 262,564 17,801 45,102,523
3,519,525 976,299 722,631 96,344 48,171 377,343 (376,960) 5,254,985 762,326 354,167 57,750 300,000 393,911 0 96,923 44,875 297,077 737,118 386,414 48,798 14,097,697
12,744,144 5,487,499 2,417,276 322,303 161,152 760,800 (3,383,794) 4,160,198 762,326 303,854 45,719 237,500 2,556,273 0 65,993 34,862 235,628 460,405 12,219 330,734 27,715,090
4,068,597 1,945,224 788,513 105,135 52,568 235,482 (1,817,546) 4,148,213 762,326 455,853 45,719 1,312,500 33,525,072 16,722,843 (4,585) 70,844 169,617 514,223 93,189 8,609 63,202,396
2,709,414 789,505 530,936 67,445 33,723 161,522 (458,474) 0 762,326 354,167 0 0 79,703,765 0 14,636 5,023 168,877 577,317 58,895 223,093 85,702,167
(100,946) (85,649) (20,086) (2,681) (1,343) (6,799) (264,012) 0 762,326 354,167 0 0 23,248,193 0 32,994 31,565 400,603 305,106 41,121 106,175 24,800,733
(91,828) (39,917) (14,135) (1,890) (945) 1,518 (155,119) 4,160,196 762,326 354,167 45,719 237,500 1,201,509 0 53,895 22,726 276,424 243,526 279,883 107,533 7,443,087
6,276,625 1,950,457 1,274,592 169,485 84,744 453,994 (1,113,710) 4,160,196 762,326 354,167 45,719 112,500 833,396 0 18,396 59,047 299,074 438,016 579,849 123,638 16,882,512
3,639,715 1,443,639 724,389 96,317 48,159 165,115 (2,101,072) 4,160,196 762,326 354,167 45,719 0 413,216 0 37,082 29,216 212,981 527,632 92,372 161,684 10,812,854
118,107 77,930 30,360 4,033 2,016 681 (183,543) 4,160,196 762,326 354,167 45,719 0 322,811 0 17,674 4,999 249,758 452,553 238,232 347,569 7,005,588
(189,249) (93,068) (38,934) (5,178) (2,589) (7,256) 43,118 4,160,196 762,326 354,167 45,719 0 269,256 0 19,375 24,672 236,979 264,380 71,374 52,578 5,967,865
(13,253) (6,972) (2,313) (317) (159) (969) 2,200 4,160,196 762,326 354,167 45,719 0 625,224 0 122,659 38,376 501,258 405,185 167,847 86,687 7,247,861
57,301,681 22,686,027 11,174,078 1,485,774 742,888 3,734,126 (16,272,814) 43,779,560 9,147,910 4,301,373 481,251 2,500,000 143,145,997 16,722,843 513,374 366,741 3,520,875 6,749,832 2,283,958 1,614,899 315,980,372
(1,000,757) (768,855) (231,858) (35,017) (17,508) (265,874) (2,272,814) (11,982) 0 51,373 1 0 6,402,749 0 13,374 66,741 (229,125) 999,832 (216,042) 714,899 3,199,136
58,302,438 23,454,882 11,405,936 1,520,791 760,396 4,000,000 (14,000,000) 43,791,542 9,147,910 4,250,000 481,250 2,500,000 136,743,248 16,722,843 500,000 300,000 3,750,000 5,750,000 2,500,000 900,000 312,781,236
3,494,787 2,854,984 473,264 508,455 7,339 26,051 83,209 500,641 2,180,630 2,505,877 162,160 35,588 2,553,686 58,663 26,663 1,410,321 11,641 355,579 0 57,750 0 246,768 220,791 85,246 17,860,093
3,500,492 3,231,867 652,565 505,617 13,829 26,050 102,645 510,625 2,195,318 3,434,620 1,303,367 30,665 3,101,136 361,831 109,137 3,123,556 552,590 754,723 0 6,091 0 625,429 476,991 83,265 24,702,409
3,504,745 3,099,989 670,229 515,574 14,448 26,051 88,738 507,489 2,150,842 3,068,173 889,857 28,687 2,885,223 428,127 139,518 1,569,053 404,136 489,351 0 19,462 0 1,224,678 (161,757) 333,933 21,896,546
3,538,848 3,081,671 655,668 511,478 5,508 24,463 81,158 565,629 2,170,519 3,122,442 756,079 35,288 2,831,609 360,155 77,895 2,629,710 352,825 200,552 0 18,312 1,156,075 871,375 141,450 718,622 23,907,331
3,538,848 2,156,437 363,425 511,478 8,832 24,463 65,040 565,629 2,170,519 3,122,442 177,298 16,632 2,643,996 517,587 81,071 1,696,652 585,992 478,781 0 105,323 0 545,930 72,370 13,762 19,462,509
3,538,848 2,401,099 514,355 511,478 7,487 24,463 65,743 565,629 2,170,519 3,122,442 733,029 14,859 2,784,045 360,219 90,491 1,385,395 315,733 274,774 26,024,436 0 568,925 413,012 116,337 35,629 46,038,948
3,538,848 2,379,143 515,713 511,478 13,318 24,463 60,276 565,629 2,170,519 3,122,442 925,891 10,572 2,755,351 435,759 118,306 1,162,718 321,772 282,502 0 45,719 0 452,445 72,695 5,313 19,490,871
3,538,848 2,422,778 608,551 511,478 10,568 24,463 64,461 565,629 2,170,519 3,122,442 700,430 19,632 2,813,017 378,174 126,080 1,560,901 420,205 360,937 0 45,719 0 445,497 847,703 74,373 20,832,403
3,538,848 2,405,000 624,360 511,478 12,814 24,463 86,509 565,629 2,170,519 3,472,442 1,359,226 19,917 2,853,982 425,020 144,185 949,790 315,490 458,633 (0) 45,719 0 510,975 108,169 7,634 20,610,802
3,454,898 1,724,873 749,302 511,478 15,112 24,463 95,741 565,629 2,170,519 3,122,442 571,523 30,442 2,716,429 405,803 60,132 1,538,741 652,192 250,355 0 45,719 575,000 544,400 186,366 17,322 20,028,881
3,419,771 2,282,842 975,967 511,478 20,548 24,463 133,848 565,629 2,170,519 3,122,442 727,785 20,975 2,727,309 510,076 104,713 1,603,490 514,072 355,198 0 45,719 0 516,366 82,528 8,219 20,443,958
3,371,831 1,415,890 551,360 511,478 13,122 24,463 135,827 565,629 2,170,519 3,682,442 1,232,092 28,674 3,093,217 2,025,348 160,966 3,682,710 887,144 2,277,885 25,026,471 45,719 0 408,781 80,594 53,758 51,445,919
41,979,611 29,456,572 7,354,759 6,132,948 142,926 298,319 1,063,195 6,609,416 26,061,461 38,020,648 9,538,736 291,930 33,759,000 6,266,762 1,239,156 22,313,037 5,333,794 6,539,270 51,050,907 481,251 2,300,000 6,805,657 2,244,238 1,437,076 306,720,669
(3,053,947) 438,376 67,181 (246,285) 6 (121,199) 99,180 390,170 (3,012,693) (3,010,878) (347,711) 41,649 0 0 0 691,058 123,794 0 0 1 0 1,055,657 (255,762) 1,080,836 (6,060,567)
45,033,558 29,018,196 7,287,578 6,379,233 142,920 419,518 964,015 6,219,246 29,074,154 41,031,526 9,886,447 250,281 33,759,000 6,266,762 1,239,156 21,621,979 5,210,000 6,539,270 51,050,907 481,250 2,300,000 5,750,000 2,500,000 356,240 312,781,236
27,242,430
(10,604,712)
5,818,544
39,295,065
66,239,659
(21,238,215)
(12,047,785)
(3,949,891)
(9,797,948)
(13,023,292)
(14,476,093)
(44,198,058)
9,259,703
9,259,703
-
GRANTS AND CONTRACTS AUSTIN COMMUNITY COLLEGE AS OF DECEMBER 31, 2015
Grant Name Agency FEDERAL GRANTS AARP BACK TO WORK 50+ WESI Corporation for National an DHHS EAST TEXAS AHEC FY16 DHHS AE FED 2015 DOE AE FED PERFORMANCE BASED FUNDING YRDOE AE TANF -FED 15-16 DOE TCALL TAMU DOE AE DISTANCE LEARNING DOE AE ENG LIT/CIVICS 2015 DOE AE PD 15-16 DOE AE FED PERFORMANCE BASED FUNDING YRDOE DOE TITLE III DOE AECAD-PERKINS DOE ASL/IPP - PERKINS DOE DENTAL HYGIENE - PERKINS DOE ELECTRONICS - PERKINS DOE HEALTH SCI/PTA - PERKINS DOE GIS-PERKINS DOE GAME DESIGN - PERKINS DOE MUSIC BPT - PERKINS DOE VIS COMM - PERKINS DOE NURSING - PERKINS DOE Perkins Leadership Grant FY16 DOE DOE IIAAFM DOE 21st CENTURY DOE ACCAMPIS DOE COLLEGE WORK STUDY DOE SPECIAL POPS-PERKINS DOE SUPPPORT CENTER - PERKINS DOE PELL 16 DOE SEOG 16 DOE TAACCT - SINCLAIR DOL TAACCT - NOVA DOL TAACCT - FORSYTH DOL WORKFORCE DOL-ACE DOL TWC WAGNER PEYSER DOL SJCCD NASA SPACE NASA NSF COLLABORATIVE RESEARCH NFS NSF ADVANCED TECHNOLOGICAL NSF NSF BIOLINK 2016 NSF DEAFTEC NSF TX STATE SAFE US Department of TOTAL FEDERAL GRANTS STATE GRANTS LAW ENFORCEMENT ED NSRP-OVER 70 FY14 IRW THECB NURSING NSRP - OVER 70 FY 15 T - STEM FY16 NSRP-REGULAR FY 2016 WORK-STUDY STUDENT MENTORSHIP AE-TANF-State 15-16 AE-STATE 15 TWC SKILLS FOR SMALL BUSINESS 15-16 TWC SDHC TX EMERGING TECHNOLOGY FUND TWC VETERANS SDF IT TWC VISA PHASE II ADVANCED TECHONLOGY/MANUFACTING TWC ACC DUAL CREDIT PROGRAM TWC EPIC PIPING LLC TOTAL STATE GRANTS
IC and AA Report as 12-31-15
Texas Comptroller of Publi THECB THECB THECB THECB THECB THECB THECB TWC TWC TWC TWC TWC TWC TWC TWC TWC TWC
IDC or AA Type
START
END
IDC AA IDC IDC N/A IDC N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A IDC N/A N/A IDC IDC N/A IDC AA AA IDC IDC IDC N/A IDC N/A IDC IDC IDC IDC N/A
03/01/15 09/01/15 07/01/14 07/01/14 07/01/14 06/01/14 07/01/15 07/01/14 07/01/14 07/01/14 10/01/15 09/01/15 09/01/15 09/01/15 09/01/15 09/01/15 09/01/15 09/01/15 09/01/15 09/01/15 09/01/15 09/01/15 09/01/14 08/01/15 12/04/14 9/1/2015 09/01/15 9/1/2015 9/1/2015 9/1/2015 10/01/12 10/01/12 10/01/12 02/01/13 02/01/15 09/19/14 09/15/11 09/01/15 09/01/15 08/01/12 09/01/14
02/28/16 08/30/16 06/30/16 06/30/16 06/30/16 05/31/16 06/30/16 06/30/16 06/30/16 06/30/16 09/01/16 08/31/16 08/31/16 08/31/16 08/31/16 08/31/16 08/31/16 08/31/16 08/31/16 08/31/16 08/31/16 08/31/16 10/30/15 07/31/16 09/30/18 08/31/16 08/31/16 08/31/16 08/31/16 08/31/16 12/30/16 09/30/16 09/30/16 10/31/15 05/31/16 09/19/16 08/31/16 12/31/19 08/31/16 07/31/16 08/31/18
N/A N/A N/A N/A N/A N/A N/A N/A N/A IDC IDC IDC IDC IDC IDC IDC AA AA
01/01/96 04/08/14 08/15/13 01/01/15 09/01/14 09/01/15 10/15/15 09/01/15 07/01/14 07/01/14 08/01/15 12/05/14 01/09/15 08/29/14 06/09/15 08/29/14 07/01/15 08/17/15
Ongoing Ongoing 08/31/16 12/31/16 Ongoing 08/31/16 Ongoing 08/31/17 06/30/16 06/30/16 07/31/16 06/30/16 12/31/19 12/31/15 11/30/16 02/25/16 06/30/16 02/28/17
Total Grant Award
Grantor Allowed FY 16 Actual FY 16 Grant Admin/IC % Budget Admin/IC Budget
113,074 92,500 2,683,143 69,920 334,239 102,676 46,096 521,530 112,397 43,785 1,744,310 40,600 30,800 6,240 10,000 38,500 10,800 36,370 48,774 26,560 36,267 144,394 59,827 66,392 519,004
101,808 92,500 1,235,794 69,920 190,962 30,068 46,096 265,565 51,182 33,785 317,204 40,600 30,800 6,240 10,000 38,500 10,800 36,370 48,774 26,560 36,267 144,394 0 61,198 129,751
53,700 $531,837
53,700 $531,837
30% 8% 8% 0% 0% 8% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 5% 0% 0% 49% 10% 0% 5%
2,155,499 2,000,120 446,685 386,361 649,994 33,332 69,148 2,999,962 281,937 187,730 23,750 $16,758,253
401,875 526,247 99,500 7,788 403,234 33,332 9,578 1,023,941 101,317 70,393 11,750 $6,329,629
10% 49% 10% 0% 10% 0% 50% 49% 15% 8% 0% 8.3%
58,671 2,108 340,000 198,723 175,000 40,894 150,000 24,879 500,000 500,000 460,500 423,000 197,717 197,717 100,000 100,000 81,269 18,019 646,857 302,467 20,000 20,000 1,005,983 615,019 4,900,000 4,309,828 1,097,208 558,597 324,192 318,019 1,486,405 753,844 224,178 224,178 1,715,434 1,715,434 $13,483,414 $10,322,725
0% 0% 0% 0% 0% 0% 0% 0% 0% 8% 5% 15% 9% 10% 10% 15% 0% 0% 4.0%
1
FY 16 Actual Budget % of Total Grant
FY 16 Actual YTD Total IDC/AA Admin % Allowed FY 16 Total Actual Expenditures VsTaken in Grant Expenditures
$
1,072 7,392 85,399 2,227 6,876 6,570 $40,114 22,388 6,614 9,048 37,232 305,243 13,215 3,318 546,709
0.0% 8.0% 3.2% 0.0% 0.0% 2.2% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 4.8% 0.0% 0.0% 1.3% $0.00 0.0% $0.08 $0.00 $0.00 1.0% 0.3% 2.0% 0.0% 0.0% 0.0% 10.9% 10.2% 4.7% 1.8% 0.0% 1.4% Average
0.0% 0.0% 6.9% 0.0% 0.0% 7.4% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 4.8% 0.0% 0.0% 5.1% 0.0% 0.0% 7.5% 0.0% 0.0% 5.6% 1.3% 9.1% 0.0% 0.0% 0.0% 21.5% 29.8% 13.0% 4.7% 0.0% 2.8% Average
$
709 1,000 80,220 334,722 50,781 28,911 84,146 20,379 155,949 756,816
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.1% 5.0% 8.0% 6.8% 4.6% 8.9% 5.7% 10.0% 15.0% 3.6% Average
0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.2% 5.0% 13.0% 7.8% 9.1% 9.1% 11.2% 0.0% 0.0% 3.1% Average
$
16,800 33,061 546,555 37,579 41,199 17,597 60,390 11,832 12,115 187 4,663 2,163 6,406 44,831 2,356 16,308 17,742 23,249 5,987 326,952 97,807 14,871,535 286,392 164,449 293,646 28,918 7,788 289,071 2,498 4,897 56,036 14,674 11,746 3,000 17,360,429
$
940 134,075 11,544 95,699 4,513 86,180 263 61,106 255,227 124,053 83,535 49,835 233,586 1,140,556
YTD Admin/IDC Collected
2,751 37,570 516,468 37,370 16,897 3,960 140,942 149,499 13,498 26,321 262,791 27,262 12,760 10,876 $ 1,258,966
$
825 3,006 41,317 2,990 845 1,940 7,047 14,950 6,614 2,632 26,279 13,358 1,914 870 124,588
-
-
250 53,135
$
112,775 72,639 45,305 203,118 487,223
$
13 7,970 (62) 11,278 10,896 4,530 30,468 65,093
1/26/2016 5:08 PM
Grant Name LOCAL GOV'T GRANTS CITY TT FY15 CITY TT FY16 COUNTY TCHR TRAC 2015 COUNTY TCHR TRAC 2016 WORKFORCE TEACHER TRAC WERC ACCD 14-15 WORKFORCE TEACHER TRAC TOTAL LOCAL GOV'T GRANTS PRIVATE GRANTS CAP IDEA-COLL PREP 16 CARNEGIE E3 ALLIANCE EDCAUSE-NGLC - BMI GALLAUDET UNIVERSITY YR 5 GALLAUDET UNIVERSITY YR 6 STRENGTHENINIG PATHWAYS FY15-16 THE LINKS FOUNDATION SETON ST DAVIDS TG-UT CONSORTIUM TG FIRST YEAR EAST TEXAS AHEC UT WFS ACAN/AOYC TOTAL PRIVATE GRANTS
Agency
IDC or AA Type
START
END
CITY OF AUSTIN CITY OF AUSTIN TRAVIS COUNTY TRAVIS COUNTY WORKFORCE SOLUTION WORKFORCE SOLUTION WORKFORCE SOLUTION
AA AA AA AA N/A N/A N/A
10/01/14 10/01/15 10/01/14 10/01/15 12/01/14 10/01/14 12/01/15
09/30/15 09/30/16 09/30/15 09/30/16 09/30/15 09/30/15 09/30/16
Total Grant Award
N/A N/A AA IDC N/A N/A N/A N/A N/A N/A N/A AA N/A
09/01/15 07/10/10 09/01/15 05/01/14 10/01/14 10/01/15 07/01/15 09/30/12 09/01/14 09/01/13 08/01/13 09/01/15 09/15/15
08/31/16 06/30/16 08/31/16 12/31/15 09/30/15 09/30/16 06/30/16 08/31/16 08/31/17 08/01/16 07/31/16 08/31/16 07/31/17
FY 16 Actual Budget % of Total Grant
FY 16 Actual YTD Total IDC/AA Admin % Allowed FY 16 Total Actual Expenditures VsTaken in Grant Expenditures
46,000 46,000 52,000 52,000 120,000 14,504 100,000 430,504 $
5,724 46,000 25,763 52,000 45,655 2,401 100,000 277,544
0% 0% 8% 8% 0% 0% 0% 2.3%
315 3,780 347 4,160 $8,602
0.7% 8.2% 0.7% 8.0% 0.0% 0.0% 0.0% 2.5% Average
5.5% 8.2% 1.3% 8.0% 0.0% 0.0% 0.0% 3.3% Average
50,840 95,000 0 50,000 103,000 117,500 8,150 7,000 157,917 10,000 316,658 110,000 51,987 $ 1,078,052 $
50,840 19,699 0 23,210 8,313 117,500 7,325 2,913 52,632 8,388 145,573 110,000 25,605 571,998
0% 0% 0% 10% 0% 0% 0% 0% 0% 0% 0% 8% 0% 2.7%
$
2,565 8,185 10,750
0.0% 0.0% 0.0% 12.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.9%
0.0% 0.0% 0.0% 11.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.8%
8.0% 0.0%
8.0% 0.0%
$
400,000 1,722,876
8.4%
10.1%
$ CAPITAL IDEA CARNEGIE FOUNDATION E3 EDUCAUSE GALLAUDET UNIVERSITY GALLAUDET UNIVERSITY JACK KENT COOKE FOU LINKS FOUNDATION SETON ST DAVIDS TEXAS GUARANTEED TEXAS GUARANTEED UTMB WORKFORCE SOLUTION
Grantor Allowed FY 16 Actual FY 16 Grant Admin/IC % Budget Admin/IC Budget
2,539 7,617 19,465 34,072 1,248 $
64,940
$
20,124 268,750 23,377 6,709 22,395 1,605 2,513 17,819 130 33,168 36,214 3,267 436,071
$
-
YTD Admin/IDC Collected 315 945 347 $
1,607
$
2,090 3,284 5,374
-
$
20,902 41,049 61,951
Other Adult Career Education (ACE) THECB COLLEGE CAREER PREPARATORY PROGRAMS TOTAL OTHER
IDC N/A
9/1/2015 9/1/2006
08/31/17 08/31/13
$5,000,000 943,398 $32,693,621
$5,000,000 943,398 $18,445,294
8% 17.3%
-
$
1,156,075 288,587
-
19,290,583
$ 1,808,140
$
196,661
Administrative and Indirect Costs Survey Federal Allowed Collin Austin Dallas Del Mar
IC and AA Report as 12-31-15
2
52% 50% 50% 51%
Actual Receive 5-8% Receive 5-8% Receive 5-8% Receive 5-8%
1/26/2016 5:08 PM
Austin Community College District Portfolio Holdings - by Portfolio and Transaction Report Format: By Transaction Group By: Portfolio Name Portfolio/Report Group: All Portfolios As of 12/31/2015
Description
CUSIP/Ticker
Face Amount/Shares
Settlement Date
Maturity Date
Market Value
Cost Value
Book Value
YTM @ Days To % of Cost Maturity Portfolio
Accrued Interest
Security Type
Issuer
2010 Projects Fund First American Government 31846V401 Obligations MM
2,394,631.29
6/30/2012
N/A
2,394,631.29
2,394,631.29
2,394,631.29
2,394,631.29
0.010
1
0.91
2,394,631.29
2,394,631.29
2,394,631.29
0.010
1
0.91
2,377,619.11
2,377,619.11
2,377,619.11
0.010
1
0.90
2,377,619.11
2,377,619.11
2,377,619.11
0.010
1
0.90
First American Money Government Market Obligations 0.00
2012 Projects Fund (Hays) First American Government 31846V401 Obligations MM
2,377,619.11
5/31/2012
N/A
2,377,619.11
First American Money Government Market Obligations 0.00
Auxiliary Funds BBVA COMPASS Cash
DDA6809
2,100,448.60
1/31/2013
N/A
2,100,448.60
2,100,448.60
2,100,448.60
0.000
1
0.80
Comerica Bank 0.77 7/27/2017
CD8392R2
3,058,930.68
7/27/2015
7/27/2017
3,058,930.68
3,058,930.68
3,058,930.68
0.770
574
1.16
258.12
5,159,379.28
5,159,379.28
5,159,379.28
0.457
341
1.96
258.12
5,159,379.28
Cash
BBVA COMPASS
Compound Comerica CD Bank
GO Bonds Series 2015 Local Government TexPool Investment Pool
TexPool LGIP
TEXPOOL
5,279,763.63
6/30/2015
N/A
5,279,763.63
5,279,763.63
5,279,763.63
0.186
1
2.00
FHLMC 0 1/5/2016
313396RK1
4,000,000.00
8/24/2015
1/5/2016
3,999,920.00
3,996,873.33
3,999,883.33
0.213
5
1.52
0.00
FHLMC Bond FHLMC
FHLMC 0 2/1/2016
313396SN4
4,000,000.00
8/24/2015
2/1/2016
3,999,080.00
3,995,885.56
3,999,182.22
0.233
32
1.52
0.00
FHLMC Bond FHLMC
FHLMC 0 3/2/2016
313396TU7
4,000,000.00
8/24/2015
3/2/2016
3,997,520.00
3,994,588.33
3,998,243.33
0.260
62
1.52
0.00
FHLMC Bond FHLMC
FHLMC 0 5/2/2016
313396WH2
4,000,000.00
8/24/2015
5/2/2016
3,993,200.00
3,991,600.00
3,995,900.00
0.306
123
1.52
0.00
FHLMC Bond FHLMC
FHLMC 0 6/1/2016
313396XP3
4,000,000.00
8/24/2015
6/1/2016
3,991,640.00
3,989,660.00
3,994,390.00
0.336
153
1.52
0.00
FHLMC Bond FHLMC
Description
CUSIP/Ticker
Face Amount/Shares
Settlement Date
FHLMC 5.5 7/18/2016
3137EAAG4
10,880,000.00
Southside Bank 0.51 10/10/2016
CD4041
6,000,000.00
Southside Bank 0.5 11/1/2016
CD3619
2,002,520.55
8/4/2015
Southside Bank 0.52 12/1/2016
CD3621
4,005,242.74
FHLB 1.625 12/9/2016
313371PV2
Southside Bank 0.55 1/3/2017
8/3/2015
Maturity Date
Market Value
Cost Value
Book Value
YTM @ Days To % of Cost Maturity Portfolio
Accrued Interest
Security Type
Issuer
7/18/2016
11,162,771.20
11,411,912.32
11,183,949.90
0.384
200
4.13
270,942.22
FHLMC Bond FHLMC
10/9/2015 10/10/2016
6,000,000.00
6,000,000.00
6,000,000.00
0.510
284
2.28
6,958.36
Compound Southside CD Bank
11/1/2016
2,002,520.55
2,002,520.55
2,002,520.55
0.500
306
0.76
1,563.61
Compound Southside CD Bank
8/4/2015
12/1/2016
4,005,242.74
4,005,242.74
4,005,242.74
0.520
336
1.52
3,252.48
Compound Southside CD Bank
5,000,000.00
12/4/2015
12/9/2016
5,039,350.00
5,043,597.63
5,040,424.76
0.760
344
1.90
4,965.28
FHLB Bond FHLB
CD3622
4,005,545.21
8/4/2015
1/3/2017
4,005,545.21
4,005,545.21
4,005,545.21
0.550
369
1.52
3,440.38
Compound Southside CD Bank
Southside Bank 0.56 1/9/2017
CD4042
5,500,000.00
10/9/2015
1/9/2017
5,500,000.00
5,500,000.00
5,500,000.00
0.560
375
2.09
7,003.84
Compound Southside CD Bank
BTH Bank 0.75 1/12/2017
CDARS2569
2,504,010.05
10/14/2015
1/12/2017
2,504,010.05
2,504,010.05
2,504,010.05
0.750
378
0.95
0.00
Compound BTH Bank CD
FHLB 0.625 4/20/2017
3130A4ZF2
9,000,000.00
8/3/2015
4/20/2017
8,959,500.00
8,995,050.00
8,996,236.10
0.657
476
3.42
11,093.75
FHLB Bond FHLB
FHLB 0.625 4/20/2017
3130A4ZF2
2,500,000.00
8/3/2015
4/20/2017
2,488,750.00
2,498,325.00
2,498,726.36
0.664
476
0.95
3,081.60
FHLB Bond FHLB
FHLB 0.8 7/27/2017
3130A5ZU6
11,490,000.00
8/3/2015
7/27/2017
11,437,146.00
11,496,319.50
11,495,010.21
0.772
574
4.36
39,321.33
FHLB Bond FHLB
BTH Bank 1 10/12/2017
CDARS2542
6,012,835.30
10/14/2015 10/12/2017
6,012,835.30
6,012,835.30
6,012,835.30
1.000
651
2.28
0.00
FHLB 0.9 10/27/2017
3130A5L56
6,050,000.00
8/3/2015 10/27/2017
6,020,960.00
6,055,566.00
6,054,542.84
0.861
666
2.30
605.00
FHLMC 0.75 1/12/2018
3137EADN6
11,535,000.00
8/3/2015
1/12/2018
11,443,066.05
11,492,880.55
11,499,955.49
0.902
743
4.38
40,612.81
Southside Bank 1.14 4/2/2018
CD3624
4,011,493.70
8/4/2015
4/2/2018
4,011,493.70
4,011,493.70
4,011,493.70
1.140
823
1.52
7,141.56
Compound Southside CD Bank
Southside Bank 1.19 5/1/2018
CD3625
4,011,896.99
8/4/2015
5/1/2018
4,011,896.99
4,011,896.99
4,011,896.99
1.190
852
1.52
7,455.53
Compound Southside CD Bank
Southside Bank 1.24 6/1/2018
CD3626
4,012,401.10
8/4/2015
6/1/2018
4,012,401.10
4,012,401.10
4,012,401.10
1.240
883
1.52
7,769.76
Compound Southside CD Bank
Southside Bank 1.28
CD3627
4,012,804.38
8/4/2015
7/1/2018
4,012,804.38
4,012,804.38
4,012,804.38
1.280
913
1.52
8,021.21
Compound Southside CD Bank
Compound BTH Bank CD FHLB Bond FHLB
FHLMC Bond FHLMC
Description
CUSIP/Ticker
Face Amount/Shares
Settlement Date
Maturity Date
Market Value
Cost Value
Book Value
YTM @ Days To % of Cost Maturity Portfolio
Accrued Interest
Security Type
Issuer
7/1/2018 Southside Bank 1.31 8/1/2018
CD3629
4,013,106.85
8/4/2015
8/1/2018
4,013,106.85
4,013,106.85
4,013,106.85
1.310
944
1.52
8,209.82
Compound Southside CD Bank
Southside Bank 1.34 9/4/2018
CD3630
4,013,409.31
8/4/2015
9/4/2018
4,013,409.31
4,013,409.31
4,013,409.31
1.340
978
1.52
8,398.47
Compound Southside CD Bank
Southside Bank 1.36 10/1/2018
CD3632
4,013,610.96
8/4/2015
10/1/2018
4,013,610.96
4,013,610.96
4,013,610.96
1.360
1005
1.52
8,524.25
Compound Southside CD Bank
Southside Bank 1.39 11/1/2018
CD3634
4,013,913.42
8/4/2015
11/1/2018
4,013,913.42
4,013,913.42
4,013,913.42
1.390
1036
1.52
8,712.94
Compound Southside CD Bank
Southside Bank 1.41 12/1/2018
CD3635
4,014,115.07
8/4/2015
12/1/2018
4,014,115.07
4,014,115.07
4,014,115.07
1.410
1066
1.52
8,838.75
Compound Southside CD Bank
Southside Bank 1.44 1/2/2019
CD3636
4,014,417.53
8/4/2015
1/2/2019
4,014,417.53
4,014,417.53
4,014,417.53
1.440
1098
1.52
9,027.49
Compound Southside CD Bank
151,973,990.04
152,403,345.01
152,197,531.33
0.779
531
57.64
474,940.44
830,668.01
830,668.01
830,668.01
0.382
1
0.32
830,668.01
830,668.01
830,668.01
0.382
1
0.32
2,247,820.61
2,247,820.61
2,247,820.61
0.186
1
0.85
2,247,820.61
2,247,820.61
2,247,820.61
0.186
1
0.85
677,045.86
677,045.86
677,045.86
0.382
1
0.26
677,045.86
677,045.86
677,045.86
0.382
1
0.26
151,896,086.79 GO Interest & Sinking Southside Bank MM
SSB7865
830,668.01
2/28/2015
N/A
830,668.01
Money Southside Market Bank 0.00
HJD Escrow
TexPool LGIP
TEXPOOL
2,247,820.61
7/31/2015
N/A
2,247,820.61
Local Government TexPool Investment Pool 0.00
Interest & Sinking Southside Bank MM
SSB9599
677,045.86
6/22/2012
N/A
677,045.86
Money Southside Market Bank 0.00
Operating Fund Southside Bank MM
SSB9572
805,587.54
6/22/2012
N/A
805,587.54
805,587.54
805,587.54
0.382
1
0.31
BBVA Compass Cash
DDA3504
55,681.79
6/30/2015
N/A
55,681.79
55,681.79
55,681.79
0.000
1
0.02
Money Southside Market Bank
Cash
BBVA Compass
Description
CUSIP/Ticker
Face Amount/Shares
TexPool LGIP
TEXPOOL
36,250,661.22
BBVA COMPASS Cash
DDA7877
BBVA COMPASS Cash
DDA0142
Settlement Date
Maturity Date
Market Value
Cost Value
Book Value
YTM @ Days To % of Cost Maturity Portfolio
Accrued Interest
Security Type
Issuer
Local Government TexPool Investment Pool
8/31/2009
N/A
36,250,661.22
36,250,661.22
36,250,661.22
0.186
1
13.76
7,531,723.80
11/30/2012
N/A
7,531,723.80
7,531,723.80
7,531,723.80
0.000
1
2.86
Cash
BBVA COMPASS
158,370.70
11/30/2012
N/A
158,370.70
158,370.70
158,370.70
0.000
1
0.06
Cash
BBVA COMPASS
2/28/2013
N/A
3,080,092.70
3,080,092.70
3,080,092.70
0.300
1
1.17
BBVA LIBOR-6676 COMPASS MM
3,080,092.70
Southside Bank 0.29 3/2/2016
CD2750
10,021,865.23
3/2/2015
3/2/2016
10,021,865.23
10,021,865.23
10,021,865.23
0.290
62
3.80
2,309.15
Compound Southside CD Bank
BTH Bank 0.95 3/3/2016
CDARS5897
4,792,521.76
3/5/2015
3/3/2016
4,792,521.76
4,792,521.76
4,792,521.76
0.950
63
1.82
0.00
Compound BTH Bank CD
Comerica Bank 0.8 3/2/2017
CD7362
5,030,214.84
3/2/2015
3/2/2017
5,030,214.84
5,030,214.84
5,030,214.84
0.800
427
1.91
3,197.29
Compound Comerica CD Bank
TX A&M UNIV-D-TXBL 4 5/15/2017
88213ACD5
750,000.00
7/23/2015
5/15/2017
777,097.50
790,965.00
781,002.21
0.952
501
0.28
3,833.33
Comerica Bank 1.31 3/2/2018
CD7370
10,100,140.37
3/2/2015
3/2/2018
10,100,140.37
10,100,140.37
10,100,140.37
1.310
792
3.83
10,512.45
Compound Comerica CD Bank
BTH Bank 0.95 6/5/2018
CD2365
246,926.16
3/5/2015
6/5/2018
246,926.16
246,926.16
246,926.16
0.950
887
0.09
0.00
Compound BTH Bank CD
78,850,883.61
78,864,751.11
78,854,788.32
0.427
149
29.91
19,852.22
3.23
3.23
3.23
0.010
1
0.00
3.23
3.23
3.23
0.010
1
0.00
0.22
0.22
0.22
0.010
1
0.00
0.22
0.22
0.22
0.010
1
0.00
78,823,786.11
Money BBVA Market COMPASS
Municipal TX A&M Bond UNIV-D-TXBL
PFC Payment Account First American Government 31846V401 Obligations MM
3.23
1/31/1995
N/A
3.23
First American Money Government Market Obligations 0.00
PFC Project Fund First American Government 31846V401 Obligations MM
0.22
0.22
6/30/2012
N/A
First American Money Government Market Obligations 0.00
Description
CUSIP/Ticker
Face Amount/Shares
Settlement Date
Maturity Date
Market Value
Cost Value
Book Value
YTM @ Days To % of Cost Maturity Portfolio
Accrued Interest
Security Type
Issuer
Reserve Fund Southside Bank MM
SSB9602
325,288.71
6/22/2012
N/A
325,288.71
325,288.71
325,288.71
0.382
1
0.12
Comerica Bank 0.98 7/11/2016
CD6479R
2,091,405.29
7/11/2013
7/11/2016
2,091,405.29
2,091,405.29
2,091,405.29
0.980
193
0.79
1,123.05
Compound Comerica CD Bank
Independent Bank 0.65 7/17/2016
CD6017
5,517,938.57
4/17/2015
7/17/2016
5,517,938.57
5,517,938.57
5,517,938.57
0.650
199
2.09
7,369.84
Compound Independent CD Bank
Independent Bank 0.65 9/22/2016
CD6171
3,641,913.72
6/22/2015
9/22/2016
3,641,913.72
3,641,913.72
3,641,913.72
0.650
266
1.38
583.74
Compound Independent CD Bank
Brownsville ISD 4 8/15/2017
116421C55
500,000.00
6/26/2013
8/15/2017
520,580.00
555,355.00
521,724.36
1.246
593
0.19
7,555.56
12,097,126.29
12,131,901.29
12,098,270.65
0.725
229
4.58
16,632.19
15.91
15.91
15.91
0.010
1
0.00
15.91
15.91
15.91
0.010
1
0.00
992,500.00
992,500.00
992,500.00
0.000
1
0.38
992,500.00
992,500.00
992,500.00
0.000
1
0.38
582,500.00
582,500.00
582,500.00
0.000
1
0.22
582,500.00
582,500.00
582,500.00
0.000
1
0.22
4,647,998.95
4,647,998.95
4,647,998.95
0.382
1
1.76
4,647,998.95
4,647,998.95
4,647,998.95
0.382
1
1.76
12,076,546.29
Money Southside Market Bank
Municipal Brownsville Bond ISD
Rev/Ref Bonds (Round Rock) Series 2015 First American Government 31846V401 Obligations MM
15.91
6/30/2015
N/A
15.91
First American Money Government Market Obligations 0.00
Rev/Ref Bonds 2014A USBank Cash
USBANK-CASH 992,500.00
8/31/2015
N/A
992,500.00
Cash USBank 0.00
Rev/Ref Bonds 2014B USBank Cash
USBANK-CASH 582,500.00
8/31/2015
N/A
582,500.00
Cash USBank 0.00
Revenue Bond 2009 Southside Bank MM
SSB9580
4,647,998.95
6/22/2012
N/A
4,647,998.95
Money Southside Market Bank 0.00
Revenue Bond 2012
TexPool LGIP
TEXPOOL
759,586.10
USBank Cash
USBANK-CASH 75,000.00
12/31/2012
N/A
759,586.10
759,586.10
759,586.10
0.186
1
0.29
Local Government TexPool Investment Pool
8/31/2015
N/A
75,000.00
75,000.00
75,000.00
0.000
1
0.03
Cash USBank
Description
CUSIP/Ticker
Face Amount/Shares 834,586.10
263,541,187.76
Settlement Date
Maturity Date
Market Value 834,586.10
Cost Value 834,586.10
Book Value 834,586.10
YTM @ Days To % of Cost Maturity Portfolio 0.170
1
263,666,768.51 264,144,765.98 263,895,358.87 0.630
368
0.32
Accrued Interest 0.00
100 511,682.97
Security Type
Issuer
Facilities Update Revenue Bond Series 2009 Projects 12/31/2015 Beginning Bond Cash Bond Premium/(Discount) Issuance Costs Reserve and I&S Funds Projected Interest Earnings Expended To Date Unexpended To Date
Projects Available for Land Banking Leander Land Acquisition Bastrop Land Acquisition TxDot Land Acquisition RGC Acquisition - Waterloo PIN Parking Expansion #2 SECO Solar Array Project RVS Building C Renovations DW Campus Master Plan NRG Lab & Make-up Air Men's Dillard's Renovation Highland Faculty Offices Hays Parking Expansion Diallard's Renovation, Phase 1b DW Renovations
Original Projection 28,000,000
2,000,000
30,000,000
Current Projection 519,372 12,506,293 125,629 212,898 2,157,053 497,765 397,338 1,468,882 1,522,752 1,303,415 240,891 1,735,739 1,000,000 1,500,000 4,811,971 30,000,000
Expended To Date 519,372 12,506,293 125,629 212,898 2,157,053 497,765 397,338 1,468,882 1,522,752 1,303,415 240,891 591,865 4,811,971 26,356,126
Rev. Bond Proceeds 31,510,000 189,023 (369,790) (1,329,233) (26,356,126) 3,643,874 Balance to Fund 1,143,874 1,000,000 1,500,000 3,643,874
Status 5-Complete 5-Complete 5-Complete 5-Complete 5-Complete 5-Complete 5-Complete 5-Complete 5-Complete 5-Complete 5-Complete 3-In Progress 3-In Progress 3-In Progress 5-Complete
Comment
Facilities Update Revenue Bond Series 2012 Projects 12/31/2015 Beginning Bond Cash Bond Premium/(Discount) Issuance Costs Reserve and I&S Funds Projected Interest Earnings Expended To Date Unexpended To Date
Projects JC Penney's Renovation Highland Mall Site Development Dillard's Renovation, Phase 1B
Original Projection 60,000,000 10,000,000 70,000,000
Current Projection 57,144,266 10,000,000 2,500,000 69,644,266
Expended To Date 57,144,266 10,000,000 2,129,065 69,273,331
Rev. Bond Proceeds 74,790,000 2,930,867 (691,392) (7,000,000) (69,273,331) 756,145 Balance to Fund 370,935 370,935
Status 3-In Progress Complete 3-In Progress
Comment