AUSTIN COMMUNITY COLLEGE DISTRICT FINANCIAL STATEMENTS
July 2016
By Austin Community College 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:
8/30/16
RE:
FY 2016 – July Financial Statements
Attached are the July 2016 financial statements. Items to note in the July Statements: Based on current information, the College’s budget is on track and projecting a positive $9.0 million in Net Revenues & Expenses, and an $11.4 million increase in Net Assets.
Fall enrollment was up 1.3%, Spring was up 0.1%, and Summer was down 3.1%. Year to date, student headcount is about flat. As such, enrollments 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 $5.5 million and expenses down by $3.5 million, Net Revenues over Expenses project a budget surplus of about $9.0 million and an increase in Net Assets of about $11.4 million. Cash and Investments are in line at approximately $261 million, including $151 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 7/31/16
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 $
56,715,286 22,684,399 11,077,966 1,477,050 738,538 3,694,605 (15,250,734) 39,559,442 8,385,584 3,947,830 435,531 4,525,000 142,435,526 16,722,843 823,646 664,557 2,921,294 8,582,738 2,676,526 1,149,261 313,966,888 $
Projected 8/31/16
Projected vs. Budget
56,702,171 22,677,429 11,075,673 1,476,735 738,380 3,693,647 (15,248,673) 43,707,656 9,147,910 4,301,997 481,250 2,500,000 142,760,750 16,722,843 896,305 702,933 3,342,552 8,687,923 2,717,921 1,235,948 318,321,351 $
(1,600,267) (777,453) (330,263) (44,056) (22,016) (306,353) (1,248,673) (83,886) 51,997 6,017,502 396,305 402,933 (407,448) 2,937,923 217,921 335,948 5,540,115
Projected 8/31/16
Projected vs. Budget
% Variance of Budget
Comments SCH Enrollments down 1% compared to projected growth of 2% SCH Enrollments down 1% compared to projected growth of 2% SCH Enrollments down 1% compared to projected growth of 2% SCH Enrollments down 1% compared to projected growth of 2% SCH Enrollments down 1% compared to projected growth of 2% SCH Enrollments down 1% 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.77%
REVENUE FOOTNOTES: 1
FY2016 Budget
Details of Credit Tuition:
Received YTD
42,328,634
41,125,194
41,112,079
(1,216,555)
SCH Enrollments down 2% compared to projected growth of 2%
Out-of-District Tuition
7,078,726
6,846,484
6,846,484
(232,242)
SCH Enrollments down 1% compared to projected growth of 2%
Out-of-State Tuition
8,270,078
8,118,944
8,118,944
(151,134)
SCH Enrollments up 4% compared to projected growth of 2%
625,000 58,302,438
624,665 56,715,286
624,665 56,702,171
(336) (1,600,267)
In-District Tuition
Repeated Course Tuition Total Credit Tuition
$
$
$
$
1
AUSTIN COMMUNITY COLLEGE DISTRICT Revenue Summary For the Period of 9/1/15 to 7/31/16
2
Details of Exemptions/Waivers Adopted Students Visually/Hearing Impaired Students Children of Disabled/Deceased Police/Fire Officers 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) TX Tomorrow Fund Contract Fully Funded - City of Austin Police Department Fully Funded - Travis County Sheriff Cadets Fully Funded - Hays County Sheriff Cadets Highest Ranking High School Graduate-Valedictorian Senior Citizens (65 or Older) Dual Credit Early College High School PACE/Pathways OOD Waivers
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 Golf Course Other Total Auxiliary Revenues
Out-Of-District 132,753 182,337
1,024 1,792
1,844 922 2,766 3,728 30,372 6,311,150 289,884 504,440
$ FY2016 Budget 700,000 125,000 50,000 20,000 5,000 900,000
5,913,564
Out-of-State 2,743
603 1,005 73,042 1,764,286 3,576
2,965 32,179 3,646,266 653,300
Total Exemptions/Waivers 3
In-District 86,169 234,917 4,169 871 804 17,482 117,791 1,018,847 94,988
$
9,302,706
9,703 1,420 3,252
5,397 11,948
$
34,463
Received YTD 291,929 222,868 44,600 171,584 392,370 275,340 30,979 740,930 355,701 40,299 49,917 304,777 2,921,294
Received YTD 604,516 170,991 6,937 43,688 289,860 33,269 1,149,261
Projected 8/31/16 604,516 170,991 50,000 43,688 330,000 36,753 1,235,948
Projected vs. Budget (95,484) 45,991 23,688 330,000 31,753 335,948
2
Total 218,922 419,997 4,169 871 1,407 18,487 190,833 2,792,836 98,564 1,420 6,120 2,714 2,766 6,693 67,947 9,969,364 943,184 504,440 $ 15,250,734
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
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
$
38,765,374 27,793,095 6,680,907 5,643,980 130,197 264,675 1,144,815 5,715,285 24,562,694 34,460,243 7,890,453 363,980 31,263,684 184,679,382
$
42,263,626 29,235,056 7,392,349 6,130,185 143,319 286,525 1,280,642 6,221,573 26,863,715 38,179,720 9,322,545 414,348 34,481,136 202,214,739
6,266,762
$
3,384,695
$
$
1,239,156
$
1,031,494
OPERATING EXPENSES
$
21,621,979
$
UTILITIES
$
5,210,000
EQUIPMENT, FURNITURE, BOOKS
$
6,539,270
Projected vs. Budget
% Variance of Budget
Comments Vacancies
$
(2,769,932) 216,860 104,771 (249,048) 399 (132,993) 316,627 2,327 (2,210,439) (2,851,806) (563,902) 164,067 722,136 (7,250,933)
-3.46%
5,496,384
$
(770,378)
-12.29%
$
1,239,156
$
-
0.00%
18,746,582
$
22,429,293
$
807,314
3.73%
$
4,260,508
$
5,147,652
$
(62,348)
-1.20%
$
5,006,156
$
6,286,682
$
(252,588)
-3.86%
Vacancies Vacancies
Vacancies Vacancies
AUSTIN COMMUNITY COLLEGE DISTRICT Expenditures and Transfers Summary For the Period of 9/1/15 to 7/31/16
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
$
3,140,306 8,438,825 6,310,390 3,339,564 1,980,933 23,210,018
$
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
$
268,268
$
$
2,300,000
$
2,324,563
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,324,563
$
24,563
1.07%
7,877,805
$
8,686,587
$
2,936,587
51.07%
$
1,837,035
$
1,917,629
$
356,240
$
1,948,021
$
2,001,779
$
1,645,539
$
312,781,236
$
254,574,527
$
309,276,621
$
(3,504,615)
$
-
$
59,392,361
$
9,044,730
$
9,044,730
$ $ $ $ $ $ $ $ $ $ $ $
9,044,730 3,000,000 2,000,000 500,000 13,151,421 (750,000) (2,000,000) (13,500,000) 11,446,151
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
4
(582,371)
Comments
-23.29% 461.92% Golf Course Operations -1.12%
2.89% Additional amount available for Institutional Advancement.
Bond Issuance Costs
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 330,857 430,071 904,509 6,531,324 2,701,994 21,621,979
Projected 8/31/16
Expended YTD
$
511,086 2,024,909 8,996,264 14,917,088 2,529,230 450,838 64,533 872,445 85,954 313,846 30,766,193
$
328,867 370,683 1,374,257 649,337 1,133,106 864,142 812,204 1,559,270 3,231,248 208,123 129,637 789,175 5,035,349 2,261,184 18,746,582
$
632,310 300,000 2,208,992 9,814,106 16,523,187 2,759,160 491,823 400,000 951,758.18 85,954 313,846 34,481,136
$
367,300 375,000 1,374,257 800,100 1,355,748 864,142 1,183,538 1,803,688 3,231,248 330,857 280,071 904,509 6,031,324 3,527,511 22,429,293
Projected vs. Budget
$
(66,690) 208,992 (190,894) 423,187 259,160 (58,177) 81,758 954 63,846 722,136
$
50,000 100,000 124,257 31,750 325,790 (150,000) (500,000) 825,517 807,314
% Variance of Budget
Comments
Year-End Entry
Year-End Entry
2.14%
Additional Internal Audits (e.g. ACE Grant)
Bad Debt Allowance 3.73%
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
Actual Jan-16
Actual Feb-16
Actual Mar-16
Actual Apr-16
Actual May-16
Actual Jun-16
Actual 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,662,186 856,032 520,916 69,455 34,727 150,048 (503,101) 0 762,326 352,126 0 0 85,450,395 0 34,614 16,145 243,168 593,474 214,986 124,667 91,582,164
(184,888) (82,739) (25,930) (3,458) (1,729) (11,693) (43,609) 0 762,326 281,217 0 0 17,790,083 0 140,802 55,032 323,971 241,719 105,874 54,451 19,401,429
(279,548) (61,150) (8,997) (1,188) (600) (2,260) (18,692) 4,148,212 762,326 360,806 45,718 475,000 1,219,159 0 101,553 35,553 345,918 285,395 220,917 90,232 7,718,354
4,661,213 1,476,026 915,798 122,106 61,053 325,517 (1,166,515) 4,148,212 762,326 460,734 45,719 475,000 498,652 0 75,522 45,360 197,023 2,220,521 1,131,649 50,214 16,506,130
5,111,376 1,931,608 1,026,131 136,802 68,420 280,265 (1,454,486) 4,148,212 762,326 368,615 45,719 475,000 386,383 0 87,204 154,506 292,300 646,447 44,328 332,241 14,843,397
(207,094) (101,221) (38,163) (5,086) (2,542) (13,765) (29,325) 4,148,213 762,326 282,860 45,719 475,000 332,088 0 57,695 64,709 173,934 392,595 119,018 6,411 6,463,372
(1,056) 15,741 (1,058) (142) (72) 172 7,197 4,148,212 762,326 373,432 45,718 475,000 230,139 0 129,594 142,134 170,059 666,471 85,368 85,103 7,334,338
(13,115) (6,970) (2,293) (315) (158) (958) 2,061 4,148,214 762,326 354,167 45,719 (2,025,000) 325,224 0 72,659 38,376 421,258 105,185 41,395 86,687 4,354,463
56,702,171 22,677,429 11,075,673 1,476,735 738,380 3,693,647 (15,248,673) 43,707,656 9,147,910 4,301,997 481,250 2,500,000 142,760,750 16,722,843 896,305 702,933 3,342,552 8,687,923 2,717,921 1,235,948 318,321,351
(1,600,267) (777,453) (330,263) (44,056) (22,016) (306,353) (1,248,673) (83,886) 0 51,997 0 0 6,017,502 0 396,305 402,933 (407,448) 2,937,923 217,921 335,948 5,540,115
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,319 2,140,315 330,798 521,534 7,178 23,255 140,236 532,151 2,223,952 3,154,357 178,454 32,650 2,788,459 325,386 91,957 1,683,840 166,344 417,325 3,089,455 40,518 15,938 506,221 104,957 78,778 22,132,377
3,545,454 2,397,898 473,966 507,211 5,839 23,255 105,516 513,818 2,222,911 3,100,111 690,502 30,154 2,899,355 310,782 63,472 1,223,331 682,779 246,831 18,441,741 23,446 0 814,451 166,574 78,652 38,568,049
3,611,327 2,448,505 627,894 512,850 13,651 23,255 89,374 511,863 2,209,338 3,116,996 856,037 24,329 2,806,493 304,524 118,804 1,446,286 431,295 275,259 (152,381) 19,508 575,000 846,560 217,734 48,735 20,983,236
3,546,716 2,369,238 559,402 515,121 10,064 23,255 101,544 511,864 2,260,883 3,517,654 1,114,052 31,958 2,760,948 263,451 115,376 1,056,431 428,105 205,399 0 18,085 0 750,248 261,920 85,217 20,506,931
3,577,185 2,370,299 547,528 512,993 14,957 25,816 120,847 485,073 2,293,726 3,149,479 792,260 43,119 3,065,619 348,063 118,936 1,541,665 319,167 420,413 582,546 20,797 0 633,017 114,220 191,248 21,288,973
3,456,146 1,688,895 703,795 503,546 18,317 21,374 82,849 516,173 2,315,528 3,131,057 452,928 44,739 2,736,136 263,074 77,311 1,882,163 417,047 1,070,630 328,271 26,002 577,025 762,958 148,802 93,186 21,317,952
3,451,355 2,109,434 985,798 529,601 19,067 21,850 148,699 559,959 2,339,047 3,159,477 694,757 26,803 2,835,020 360,639 92,425 1,180,226 494,579 570,094 920,386 18,497 525 596,100 145,353 151,139 21,410,830
3,498,252 1,441,961 711,442 486,205 13,122 21,850 135,827 506,288 2,301,021 3,719,477 1,432,092 50,368 3,217,452 2,111,689 207,662 3,682,711 887,144 1,280,526 27,840,889 212,782 0 808,782 80,594 53,758 54,701,895
42,263,626 29,235,056 7,392,349 6,130,185 143,319 286,525 1,280,642 6,221,573 26,863,715 38,179,720 9,322,545 414,348 34,481,136 5,496,384 1,239,156 22,429,293 5,147,652 6,286,682 51,050,907 481,250 2,324,563 8,686,587 1,917,629 2,001,779 309,276,621
(2,769,932) 216,860 104,771 (249,048) 399 (132,993) 316,627 2,327 (2,210,439) (2,851,806) (563,902) 164,067 722,136 (770,378) 0 807,314 (62,348) (252,588) 0 0 24,563 2,936,587 (582,371) 1,645,539 (3,504,615)
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
69,449,787
(19,166,620)
(13,264,882)
(4,000,801)
(6,445,577)
(14,854,580)
(14,076,492)
(50,347,432)
9,044,730
9,044,730
-
GRANTS AND CONTRACTS AUSTIN COMMUNITY COLLEGE AS OF JULY 31, 2016
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 TWC AEL CI AWARD DOE DOE TITLE III DOE TWC CAPACITY BUILDING FOR ABILITY TO DOE TWC SITE-BASED WORKPLACE LITERACY DOE TWC GOVERNOR'S SUMMER MERIT 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 DOE Perkins Leadership Grant FY16 AE FED 2017 DOE AE TANF -FED 17 DOE AE ENG LIT/CIVICS 2017 DOE AE PD 17 DOE DOE IIAAFM DOE DOE 21st CENTURY ACCAMPIS DOE DOE COLLEGE WORK STUDY SPECIAL POPS-PERKINS DOE SUPPPORT CENTER - PERKINS DOE PELL 16 DOE SEOG 16 DOE DOL TAACCT - SINCLAIR DOL TAACCT - NOVA DOL TAACCT - FORSYTH DOL WORKFORCE DOL-ACE TWC WAGNER PEYSER DOL TWC COLLEGE CREDIT FOR HEROES DOL TWC WP BIO MEDICAL GRANT DOL SJCCD NASA SPACE NASA NSF COLLABORATIVE RESEARCH NFS NSF ADVANCED TECHNOLOGICAL NSF NSF GEOPATHS-EXTRA NSF NSF BIOLINK 2016 NSF NSF STEP ST EDWARDS NSF NSF GEOPATHS EXTRA NSF DEAFTEC NSF NSF RIT DEAFTEC NSF TSC-CPP PROJECT TEXAS SUCCESS CENTE TX STATE SAFE US Department of TOTAL FEDERAL GRANTS STATE GRANTS EGDMS GEOSPATIAL ACCURACY PROJECT Texas Commission on Stat LAW ENFORCEMENT ED Texas Comptroller of Publi NSRP-OVER 70 FY14 THECB IRW THECB THECB NURSING THECB NSRP - OVER 70 FY 15 THECB THECB THECB CENTRAL TEXAS PATHWAY T - STEM FY16 THECB NSRP-REGULAR FY 2016 THECB NSRP-OVER 70 FY 2016 THECB WORK-STUDY STUDENT MENTORSHIP THECB AE-TANF-State 15-16 TWC AE-STATE 15 TWC TWC SKILLS FOR SMALL BUSINESS 15-16 TWC TWC SDHC TWC TX EMERGING TECHNOLOGY FUND TWC TWC VETERANS SDF IT TWC TWC VISA PHASE II TWC ADVANCED TECHONLOGY/MANUFACTING TWC TWC ACC DUAL CREDIT PROGRAM TWC TWC EPIC PIPING LLC TWC ADVANCED TECHNOLOGY/MANUFACTURINGTWC AE-STATE 17 TWC TOTAL STATE GRANTS
IC and AA Report as 7-31-16
IDC or AA Type
START
END
IDC AA IDC IDC N/A IDC N/A N/A N/A N/A IDC N/A N/A IDC IDC N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A IDC IDC N/A N/A N/A N/A N/A IDC IDC N/A IDC AA AA IDC IDC IDC N/A IDC AA IDC N/A IDC IDC IDC IDC N/A AA IDC N/A N/A 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 01/01/16 10/01/15 08/11/16 04/15/16 04/01/16 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 07/01/15 07/01/16 07/01/16 07/01/16 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 03/01/16 02/15/16 09/19/14 09/15/11 09/01/15 06/01/16 09/01/15 08/01/15 02/01/16 08/01/12 08/01/16 03/03/16 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/30/16 09/01/16 01/31/18 06/30/17 09/30/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 06/30/17 06/30/17 06/30/17 06/30/17 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 08/31/17 02/14/17 09/19/16 08/31/16 12/31/19 05/31/19 08/31/16 07/31/16 06/30/17 07/31/16 07/31/19 12/31/16 08/31/18
AA N/A N/A 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 AA IDC
01/28/16 01/01/96 04/08/14 08/15/13 01/01/15 09/01/14 01/22/16 09/01/15 10/15/15 06/27/16 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 02/29/16 07/01/16
Total Grant Award
08/31/17 Ongoing Ongoing 08/31/16 12/31/16 Ongoing 08/31/17 08/31/16 Ongoing 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 08/31/17 06/30/17 $
Grantor Allowed FY 16 Actual Budget FY 16 Grant Budget Admin/IC % Admin/IC
162,039 92,500 2,683,143 69,920 334,239 104,625 46,096 521,530 112,397 43,785 35,000 1,744,310 271,881 69,740 21,788 77,712 30,800 66,240 10,000 72,200 10,800 36,370 48,774 26,560 64,219 144,394 1,506,663 187,559 253,837 40,590 59,827 70,778 519,004
203,963 92,500 1,532,913 69,920 190,962 104,625 46,096 265,565 51,182 33,785 35,000 317,204 271,881 69,740 21,788 77,712 30,800 66,240 10,000 72,200 10,800 36,370 48,774 26,560 64,219 144,394 1,506,663 187,559 253,837 40,590 0 65,583 129,751
19,200 $419,500
19,200 $419,500
30% 8% 8% 0% 0% 8% 0% 0% 0% 0% 10% 0% 0% 10% 8% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 5% 8% 0% 0% 0% 0% 0% 49% 10% 0% 5%
2,155,499 2,000,120 446,685 386,361 649,994 82,005 483,201 33,332 69,148 2,999,962 307,242 281,937 8,515 92,428 187,730 152,718 120,000 23,750 $20,458,647
401,875 526,247 87,136 7,788 403,234 82,005 483,202 33,332 9,578 1,023,941 47,654 101,317 8,515 92,428 70,393 152,718 120,000 11,750 $10,180,988
10% 49% 10% 0% 10% 10% 10% 0% 50% 49% 10% 15% 0% 10% 8% 0% 0% 0% 7.4%
50,000 64,918 340,000 175,000 150,000 100,000 40,000 460,500 561,015 400,000 100,000 81,269 646,857 20,000 1,005,983 4,900,000 1,097,208 324,192 1,537,044 224,178 1,715,434 1,319,586 335,283 15,648,467 $
50,000 8,355 198,723 40,894 24,879 100,000 40,000 423,000 561,015 400,000 100,000 18,019 302,467 20,000 615,019 4,309,828 558,597 318,019 703,205 224,178 1,715,434 1,319,586 335,283 12,386,500
15% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 8% 5% 15% 9% 10% 10% 15% 0% 0% 0% 8% 4.1%
1
FY 16 Actual Budget % of Total Grant
FY 16 Actual Admin % Allowed VsTaken in Grant
$
13,694 6,852 84,160 7,750 3,500 5,166 1,038 6,876 93,476 6,570 $42,017 39,479 6,614 9,048 37,232 7,455 43,929 89,572 6,301 13,215 9,243 6,323 539,510
0.0% 7.4% 3.1% 0.0% 0.0% 7.4% 0.0% 0.0% 0.0% 0.0% 10.0% 0.0% 0.0% 7.4% 4.8% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 4.8% 6.2% 0.0% 0.0% 0.0% 0.0% 0.0% 1.3% $0.00 0.0% $0.10 $0.00 $0.00 1.8% 0.3% 2.0% 0.0% 0.0% 0.0% 0.0% 0.0% 10.9% 3.0% 2.1% 4.7% 0.0% 10.0% 3.4% 0.0% 0.0% 0.0% 1.8% Average
0.0% 0.0% 5.5% 0.0% 0.0% 7.4% 0.0% 0.0% 0.0% 0.0% 10.0% 0.0% 0.0% 7.4% 4.8% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 4.8% 6.2% 0.0% 0.0% 0.0% 0.0% 0.0% 5.1% 0.0% 0.0% 10.0% 0.0% 0.0% 9.8% 1.3% 10.4% 0.0% 0.0% 0.0% 0.0% 0.0% 21.5% 8.7% 13.2% 13.0% 0.0% 10.0% 9.0% 0.0% 0.0% 0.0% 2.8% Average
$
5,184 709 1,000 80,220 334,722 50,781 28,911 84,146 20,379 155,949 186,302 948,302
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.1% 5.0% 8.0% 6.8% 4.6% 8.9% 5.5% 10.0% 10.0% 0.0% 0.0% 2.6% Average
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.2% 5.0% 13.0% 7.8% 9.1% 9.1% 12.0% 0.0% 0.0% 0.0% 0.0% 2.4% Average
FY 16 Total Actual Expenditures
$
34,216 85,583 1,466,078 69,089 139,883 103,616 44,912 194,629 51,486 33,778 31,390 59,571 7,450 63,897 18,668 36,695 10,806 54,526 3,782 21,451 46,722 9,422 62,422 76,020 22,023 3,435 64,337 85,015 691,054 3,127 317,256 32,021,298 824,252 314,648 406,580 71,979 7,788 364,116 360 7,130 14,841 8,744 353,311 44,921 8,515 42,450 4,500 38,407,771
$
5,729 2,314 115,955 7,388 24,350 364,304 31,165 298,179 12,334 542,201 1,435,170 504,841 144,872 485,173 128,397 1,260,942 276,506 5,639,819
YTD Total IDC/AA Expenditures
YTD Admin/IDC Collected
7,566 78,745 1,052,000 95,163 27,536 6,773 45,821 20,351 9,829 538,162 286,043 13,498 65,436 331,014 327 9,453 128,255 39,062 39,306 -
$
$
2,794,341
$
2,270 6,300 84,160 7,613 2,754 677 2,291 1,628 4,816 26,908 52,650 28,604 6,614 6,544 33,101 33 945 62,845 5,859 3,144 339,757
4,981 -
747 -
11,747 474,725 1,081,830 458,946 131,702 350,506 116,725 1,146,311
587 71,209 97,365 45,895 13,170 52,576 11,672 114,631 59,080 466,932
3,777,474
$
8/31/2016 12:27 PM
Grant Name LOCAL GOV'T GRANTS CITY TT FY15 CITY TT FY16 COUNTY TCHR TRAC 2015 COUNTY TCHR TRAC 2016 WERC ACCD 14-15 WORKFORCE TEACHER TRAC WORKFORCE TEACHER TRAC TOTAL LOCAL GOV'T GRANTS PRIVATE GRANTS ATD COMMUNITY AUTISM SPEAKS-STEPS CAP IDEA-COLL PREP 16 CARNEGIE E3 ALLIANCE EDCAUSE-NGLC - BMI GALLAUDET UNIVERSITY YR 5 GALLAUDET UNIVERSITY YR 6 GATES IPASS II STRENGTHENINIG PATHWAYS FY15-16 THE LINKS FOUNDATION SETON ST DAVIDS TG-UT CONSORTIUM AARP WALMART MATCH GRANT TG FIRST YEAR MITTE PREPPED FOR SUCCESS 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 10/01/14 12/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
Achieving the Dream AUTISM SPEAKS-STEPS CAPITAL IDEA CARNEGIE FOUNDATION E3 EDUCAUSE GALLAUDET UNIVERSITY GALLAUDET UNIVERSITY GATES FOUNDATION JACK KENT COOKE FOU LINKS FOUNDATION SETON ST DAVIDS TEXAS GUARANTEED TEXAS GUARANTEED TEXAS GUARANTEED The Roy F. & Joann Cole Mitte Foun
UTMB WORKFORCE SOLUTION
N/A N/A N/A N/A AA IDC N/A N/A N/A N/A N/A N/A N/A N/A N/A N/A AA N/A
06/03/16 03/31/16 09/01/15 07/10/10 09/01/15 05/01/14 10/01/14 10/01/15 10/15/15 07/01/15 09/30/12 09/01/14 09/01/13 05/19/16 08/01/13 01/30/16 09/01/15 09/15/15
Total Grant Award
Grantor Allowed FY 16 Actual Budget FY 16 Grant Budget Admin/IC % Admin/IC
FY 16 Actual Budget % of Total Grant
FY 16 Actual Admin % Allowed VsTaken in Grant
$
46,000 48,760 52,000 52,000 14,504 120,000 100,000 433,264 $
5,624 48,760 25,663 52,000 2,401 45,655 100,000 280,104
0% 0% 8% 8% 0% 0% 0% 2.3%
315 3,780 347 4,160 $8,602
0.7% 7.8% 0.7% 8.0% 0.0% 0.0% 0.0% 2.4% Average
5.6% 7.8% 1.4% 8.0% 0.0% 0.0% 0.0% 3.2% Average
$
300,000 15,000 118,070 95,000 0 50,000 103,000 117,500 17,800 8,150 7,000 157,917 10,000 53,190 316,658 10,000 110,000 51,987 1,541,272 $
300,000 15,000 118,070 19,699 0 23,210 8,313 117,500 17,800 7,325 2,913 52,632 8,388 53,190 145,573 10,000 110,000 25,605 1,035,218
0% 0% 0% 0% 0% 10% 0% 0% 0% 0% 0% 0% 0% 0% 0% 0% 8% 0% 2.0%
$
2,090 8,185 10,275
0.0% 0.0% 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.0% 0.0% 0.0% 0.7%
0.0% 0.0% 0.0% 0.0% 0.0% 9.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.5%
$5,000,000 943,398
$5,000,000 943,398
8%
8.0% 0.0%
8.0% 0.0%
$
400,000 1,906,688
7.5%
9.0%
12/31/18 03/30/17 08/31/16 06/30/16 08/31/16 12/31/15 09/30/15 09/30/16 09/07/18 06/30/16 08/31/16 08/31/17 08/01/16 11/30/16 07/31/16 03/31/17 08/31/16 07/31/17
FY 16 Total Actual Expenditures
$
2,539 38,829 19,365 39,458 1,248 34,072 39,146 174,656
$
42,898 847 911,105 23,210 6,709 93,944 5,478 2,513 52,632 1,638 10,611 101,740 4,217 110,000 25,276 1,392,817
YTD Total IDC/AA Expenditures
$
$
YTD Admin/IDC Collected -
315 3,150 347 3,467 $
7,278
-
-
20,902 101,852 122,754
2,090 8,148 10,238
$
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 $
39,025,048
$
24,826,208
15.8%
-
2,324,038 810,957 $
46,426,020
$
6,694,568
Administrative and Indirect Costs Survey Federal Allowed Collin Austin Dallas Del Mar
IC and AA Report as 7-31-16
2
52% 50% 50% 51%
$
824,205
Actual Receive 5-8% Receive 5-8% Receive 5-8% Receive 5-8%
8/31/2016 12:27 PM
Austin Community College District Portfolio Holdings Report Format: By CUSIP Group By: Portfolio Name Portfolio/Report Group: All Portfolios As of 7/31/2016
Issuer
Coupon Rate
Maturity Date
CUSIP/Ticker
Face Amount/Shares
Market Value
Cost Value
Book Value
YTM @ Cost
Days To % of Maturity Portfolio
Accrued Interest
Security Type
Description
2010 Projects Fund First American Government Obligations
0.010
Sub Total / Average
0.010
N/A
31846V401 2,018,756.48
2,018,756.48
2,018,756.48
2,018,756.48
2,018,756.48
2,018,756.48
2,018,756.48
0.010
1
0.77
2,018,756.48 0.010
1
0.77
First American Money Government Market Obligations MM 0.00
2012 Projects Fund (Hays) First American Government Obligations
0.010
Sub Total / Average
0.010
N/A
31846V401 2,494,370.73
2,494,370.73
2,494,370.73
2,494,370.73
2,494,370.73
2,494,370.73
2,494,370.73
0.010
1
0.96
2,494,370.73 0.010
1
0.96
First American Money Government Market Obligations MM 0.00
Auxiliary Funds BBVA Cash COMPASS Cash
BBVA COMPASS
0.517
N/A
DDA6809 2,630,946.46
2,630,946.46
2,630,946.46
2,630,946.46
0.517
1
1.01
Comerica Bank
0.770
7/27/2017
CD8392R2 3,072,702.25
3,072,702.25
3,072,702.25
3,072,702.25
0.770
361
1.18
259.28
Sub Total / Average
0.653
5,703,648.71
5,703,648.71
5,703,648.71 0.653
195
2.18
259.28
5,703,648.71
Comerica Compound Bank 0.77 CD 7/27/2017
GO Bonds Series 2015
TexPool
0.369
N/A
Southside Bank
0.510
10/10/2016
Southside Bank
0.500
11/1/2016
TEXPOOL 20,244,707.64
Local Government TexPool LGIP Investment Pool
20,244,707.64
20,244,707.64
20,244,707.64
0.369
1
7.75
CD4041 6,023,000.29
6,023,000.29
6,023,000.29
6,023,000.29
0.510
71
2.31
1,851.45
Southside Compound Bank 0.51 CD 10/10/2016
CD3619 2,007,516.24
2,007,516.24
2,007,516.24
2,007,516.24
0.500
93
0.77
2,420.02
Southside Compound Bank 0.5 CD 11/1/2016
Maturity Date
Southside Bank
0.520
12/1/2016
CD3621 4,015,634.57
4,015,634.57
4,015,634.57
4,015,634.57
0.520
123
1.54
5,034.39
FHLB
1.625
12/9/2016
313371PV2 5,000,000.00
5,019,050.00
5,043,597.63
5,015,394.31
0.760
131
1.91
11,736.11
Southside Bank
0.550
1/3/2017
CD3622 4,016,537.81
4,016,537.81
4,016,537.81
4,016,537.81
0.550
156
1.54
5,326.03
Southside Compound Bank 0.55 CD 1/3/2017
Southside Bank
0.560
1/9/2017
CD4042 5,523,153.51
5,523,153.51
5,523,153.51
5,523,153.51
0.560
162
2.11
1,864.26
Southside Compound Bank 0.56 CD 1/9/2017
BTH Bank
0.750
1/12/2017
CDARS2569 2,514,993.30
2,514,993.30
2,514,993.30
2,514,993.30
0.750
165
0.96
0.00
FHLB
0.625
4/20/2017
3130A4ZF2 11,500,000.00
11,476,425.00
11,493,375.00
11,497,216.66
0.659
263
4.40
20,164.93
FHLB Bond
FHLB 0.625 4/20/2017
FHLB
0.800
7/27/2017
3130A5ZU6 11,490,000.00
11,501,949.60
11,496,319.50
11,493,151.02
0.772
361
4.40
1,021.33
FHLB Bond
FHLB 0.8 7/27/2017
LegacyTexas 0.800 Bank
8/8/2017
CD0709 5,016,569.87
5,016,569.87
5,016,569.87
5,016,569.87
0.800
373
1.92
2,528.90
LegacyTexas Compound Bank 0.8 CD 8/8/2017 Compound BTH Bank 1 CD 10/12/2017
Issuer
CUSIP/Ticker
Face Amount/Shares
YTM @ Cost
Coupon Rate
Market Value
Cost Value
Book Value
Days To % of Maturity Portfolio
Accrued Interest
Security Type
Description
Southside Compound Bank 0.52 CD 12/1/2016 FHLB Bond
FHLB 1.625 12/9/2016
BTH Bank Compound 0.75 CD 1/12/2017
BTH Bank
1.000
10/12/2017
CDARS2542 6,048,025.70
6,048,025.70
6,048,025.70
6,048,025.70
1.000
438
2.32
0.00
FHLB
0.900
10/27/2017
3130A5L56 6,050,000.00
6,043,466.00
6,055,566.00
6,053,089.95
0.858
453
2.32
14,217.50
FHLMC
0.750
1/12/2018
11,539,267.95
11,492,880.55
11,510,001.89
0.902
530
4.42
4,565.94
Southside Bank
1.140
4/2/2018
CD3624 4,034,328.97
4,034,328.97
4,034,328.97
4,034,328.97
1.140
610
1.54
11,088.32
Southside Compound Bank 1.14 CD 4/2/2018
Southside Bank
1.190
5/1/2018
CD3625 4,035,737.68
4,035,737.68
4,035,737.68
4,035,737.68
1.190
639
1.55
11,578.69
Southside Compound Bank 1.19 CD 5/1/2018
Southside Bank
1.240
6/1/2018
CD3626 4,037,248.18
4,037,248.18
4,037,248.18
4,037,248.18
1.240
670
1.55
12,069.71
Southside Compound Bank 1.24 CD 6/1/2018
Southside Bank
1.280
7/1/2018
CD3627 4,038,456.83
4,038,456.83
4,038,456.83
4,038,456.83
1.280
700
1.55
12,462.78
Southside Compound Bank 1.28 CD 7/1/2018
Southside Bank
1.310
8/1/2018
CD3629 4,039,363.49
4,039,363.49
4,039,363.49
4,039,363.49
1.310
731
1.55
12,757.75
Southside Compound Bank 1.31 CD 8/1/2018
3137EADN6 11,535,000.00
FHLB Bond
FHLB 0.9 10/27/2017
FHLMC FHLMC 0.75 Bond 1/12/2018
Issuer
Coupon Rate
Maturity Date
CUSIP/Ticker
Face Amount/Shares
Market Value
Cost Value
Book Value
YTM @ Cost
Days To % of Maturity Portfolio
Accrued Interest
Security Type
Description
Southside Bank
1.340
9/4/2018
CD3630 4,040,270.27
4,040,270.27
4,040,270.27
4,040,270.27
1.340
765
1.55
13,052.84
Southside Compound Bank 1.34 CD 9/4/2018
Southside Bank
1.360
10/1/2018
CD3632 4,040,874.88
4,040,874.88
4,040,874.88
4,040,874.88
1.360
792
1.55
13,249.64
Southside Compound Bank 1.36 CD 10/1/2018
Southside Bank
1.390
11/1/2018
CD3634 4,041,781.89
4,041,781.89
4,041,781.89
4,041,781.89
1.390
823
1.55
13,544.96
Southside Compound Bank 1.39 CD 11/1/2018
Southside Bank
1.410
12/1/2018
CD3635 4,042,386.64
4,042,386.64
4,042,386.64
4,042,386.64
1.410
853
1.55
13,741.90
Southside Compound Bank 1.41 CD 12/1/2018
Southside Bank
1.440
1/2/2019
CD3636 4,043,293.89
4,043,293.89
4,043,293.89
4,043,293.89
1.440
885
1.55
14,037.43
Southside Compound Bank 1.44 CD 1/2/2019
Sub Total / Average
0.866
141,384,040.20
141,385,620.33
141,372,735.48 0.846
385
54.13
198,314.88
832,981.02
832,981.02
832,981.02
0.528
1
0.32
38,159.96
38,159.96
38,159.96
0.369
1
0.01
871,140.98
871,140.98
871,140.98 0.521
1
0.33
2,252,145.87
2,252,145.87
0.369
1
0.86
2,252,145.87
2,252,145.87
2,252,145.87 0.369
1
0.86
5,221,579.75
5,221,579.75
5,221,579.75
0.369
1
2.00
678,931.10
678,931.10
678,931.10
0.528
1
0.26
141,378,881.65
GO Interest & Sinking Southside Bank
0.528
N/A
SSB7865 832,981.02
TexPool
0.369
N/A
TEXPOOL 38,159.96
Sub Total / Average
0.521
871,140.98
Money Southside Market Bank MM Local Government TexPool LGIP Investment Pool 0.00
HJD Escrow
TexPool
0.369
Sub Total / Average
0.369
N/A
TEXPOOL 2,252,145.87
2,252,145.87
2,252,145.87
Local Government TexPool LGIP Investment Pool 0.00
Interest & Sinking
TexPool
0.369
N/A
TEXPOOL 5,221,579.75
Southside Bank
0.528
N/A
SSB9599 678,931.10
Local Government TexPool LGIP Investment Pool Money Southside Market Bank MM
Issuer Sub Total / Average
Coupon Rate
Maturity Date
0.387
CUSIP/Ticker
Face Amount/Shares
Market Value
Cost Value
Book Value
YTM @ Cost
Days To % of Maturity Portfolio
Accrued Interest
Security Type
Description
5,900,510.85
5,900,510.85
5,900,510.85
5,900,510.85 0.387
1
2.26
0.00
10,857,586.39
10,857,586.39
10,857,586.39
0.528
1
4.16
Money Southside Market Bank MM
58,049.92
58,049.92
58,049.92
0.517
1
0.02
BBVA Cash Compass Cash
Operating Fund Southside Bank
0.528
N/A
SSB9572 10,857,586.39
BBVA Compass
0.517
N/A
DDA3504 58,049.92
TexPool
0.369
N/A
TEXPOOL 17,632,548.43
BBVA COMPASS
0.517
N/A
DDA7877 7,609,074.05
BBVA COMPASS
0.517
N/A
DDA0142 307,259.91
BBVA COMPASS
0.540
N/A
LegacyTexas 0.650 Bank
10/26/2016
Comerica Bank
0.800
3/2/2017
TX A&M 4.000 UNIV-D-TXBL
5/15/2017
17,632,548.43
17,632,548.43
17,632,548.43
0.369
1
6.75
7,609,074.05
7,609,074.05
7,609,074.05
0.517
1
2.91
BBVA Cash COMPASS Cash
307,259.91
307,259.91
307,259.91
0.517
1
0.12
BBVA Cash COMPASS Cash
LIBOR-6676 20,631,286.41
20,631,286.41
20,631,286.41
20,631,286.41
0.540
1
7.90
BBVA Money COMPASS Market MM
CD0671 10,032,184.03
10,032,184.03
10,032,184.03
10,032,184.03
0.650
87
3.84
893.28
5,053,745.39
5,053,745.39
5,053,745.39
0.800
214
1.93
3,212.25
768,510.00
790,965.00
767,821.63
0.952
288
0.29
6,333.33
TX A&M Municipal UNIV-D-TXBL Bond 4 5/15/2017
4,819,163.62
4,819,163.62
4,819,163.62
0.950
307
1.85
0.00
BTH Bank Compound 0.95 CD 6/3/2017-16
10,177,605.89
10,177,605.89
10,177,605.89
1.310
579
3.90
10,593.08
Comerica Compound Bank 1.31 CD 3/2/2018
248,298.33
248,298.33
248,298.33
0.950
674
0.10
0.00
BTH Bank Compound 0.95 CD 6/5/2018
88,195,312.37
88,217,767.37
88,194,624.00 0.646
111
33.76
21,031.94
CD7362 5,053,745.39
88213ACD5 750,000.00
BTH Bank
0.950
6/3/2017 CDARS5897/7072 4,819,163.62
Comerica Bank
1.310
3/2/2018
CD7370 10,177,605.89
BTH Bank
0.950
6/5/2018
CD2365 248,298.33
Sub Total / Average
0.672
PFC Payment Account
Local Government TexPool LGIP Investment Pool
88,176,802.37
LegacyTexas Compound Bank 0.65 CD 10/26/2016 Comerica Compound Bank 0.8 CD 3/2/2017
Issuer
Coupon Rate
First American Government Obligations
0.010
Sub Total / Average
0.010
Maturity Date
N/A
CUSIP/Ticker
Face Amount/Shares
Market Value
Cost Value
Book Value
YTM @ Cost
Days To % of Maturity Portfolio
31846V401 3.23
3.23
3.23
3.23
0.010
1
0.00
3.23
3.23
3.23
3.23 0.010
1
0.00
Accrued Interest
Security Type
Description
First American Money Government Market Obligations MM 0.00
PFC Project Fund First American Government Obligations
0.010
Sub Total / Average
0.010
N/A
First American Money Government Market Obligations MM
31846V401 0.22
0.22
0.22
0.22
0.010
1
0.00
0.22
0.22
0.22
0.22 0.010
1
0.00
326,194.48
326,194.48
326,194.48
0.528
1
0.12
3,653,801.48
3,653,801.48
3,653,801.48
0.650
53
1.40
2,538.47
Independent Compound Bank 0.65 CD 9/22/2016
516,735.00
555,355.00
513,921.18
1.246
380
0.19
9,222.22
Brownsville Municipal ISD 4 Bond 8/15/2017
4,496,730.96
4,535,350.96
4,493,917.14 0.708
86
1.72
11,760.69
0.00
Reserve Fund Southside Bank
0.528
N/A
Independent Bank
0.650
9/22/2016
Brownsville ISD
4.000
8/15/2017
Sub Total / Average
1.015
SSB9602 326,194.48
CD6171 3,653,801.48
116421C55 500,000.00
4,479,995.96
Money Southside Market Bank MM
Rev/Ref Bonds (Round Rock) Series 2015 First American Government Obligations
0.010
Sub Total / Average
0.010
N/A
31846V401 5,264,212.50
5,264,212.50
5,264,212.50
5,264,212.50
5,264,212.50
5,264,212.50
992,500.00
992,500.00
992,500.00
992,500.00
5,264,212.50
0.010
1
2.02
5,264,212.50 0.010
1
2.02
0.000
1
0.38
992,500.00 0.000
1
0.38
First American Money Government Market Obligations MM 0.00
Rev/Ref Bonds 2014A USBank
0.000
Sub Total / Average
0.000
Rev/Ref Bonds 2014B
N/A
USBANK-CASH 992,500.00 992,500.00
992,500.00
Cash USBank Cash 0.00
Issuer
Coupon Rate
USBank
0.000
Sub Total / Average
0.000
Maturity Date N/A
CUSIP/Ticker
Face Amount/Shares
USBANK-CASH 582,500.00 582,500.00
Market Value
Cost Value
Book Value
582,500.00
582,500.00
582,500.00
582,500.00
582,500.00
992,297.77
992,297.77
992,297.77
75,000.00
75,000.00
75,000.00
1,067,297.77
1,067,297.77
YTM @ Cost
Days To % of Maturity Portfolio
Accrued Interest
Security Type
Description
0.000
1
0.22
Cash USBank Cash
582,500.00 0.000
1
0.22
0.369
1
0.38
Local Government TexPool LGIP Investment Pool
0.000
1
0.03
Cash USBank Cash
0.41
0.00
Revenue Bond 2012
TexPool
0.369
N/A
TEXPOOL 992,297.77
USBank
0.000
N/A
Sub Total / Average
0.343
1,067,297.77
1,067,297.77 0.343
1
Total / Average
0.742
261,182,767.32 261,223,170.87 261,285,826.00 261,208,363.96 0.718
252
USBANK-CASH 75,000.00
0.00
100 231,366.79
Facilities Update Revenue Bond Series 2011A Projects 7/31/2016 Beginning Bond Cash Bond Premium/(Discount) Issuance Costs Reserve and I&S Funds Projected Interest Earnings Expended To Date Unexpended To Date
Projects Greyhawke (JC Penney's ) Acquisition Other Land Acquisitions HLC Police Offices HLC Faculty Offices/Elevator
Original Projection 16,000,000 4,000,000
20,000,000
Current Projection 15,936,589 1,956,909 488,795 1,630,180 20,012,473
Expended To Date 15,936,589 1,956,909 488,795 628,812 19,011,106
Rev. Bond Proceeds 20,275,000 (268,417) 5,890 (19,011,106) 1,001,367 Balance to Fund 1,001,367 1,001,367
Status Complete Complete Complete In Progress
Comment
Facilities Update Revenue Bond Series 2012 Projects 7/31/2016 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 HLC Site Development - Phase 1 Hays Parking Expansion HLC Mechanical/Electrical/Security Dillard's Renovation
Original Projection 60,000,000 10,000,000
70,000,000
Current Projection 57,179,245 10,000,500 1,250,000 190,114 1,654,872 70,274,732
Expended To Date 57,179,245 10,000,500 36,643 165,350 1,654,872 69,036,611
Rev. Bond Proceeds 74,790,000 2,930,867 (691,392) (7,000,000) 245,256 (69,036,611) 1,238,120 Balance to Fund 1,213,357 24,764 1,238,120
Status Complete Complete In Progress In Progress Complete
Comment
Facilities Update GO Bond Series 2015 Projects 7/31/2016 Beginning Bond Cash Bond Premium/(Discount) Issuance Costs Reserve and I&S Funds Projected Interest Earnings Expended To Date Unexpended To Date
Projects ACC Highland, Phase 2 Rio Grande Main Building Renovation Campus Renovations District-Wide Safety, Security, Accessability Round Rock Campus, Phase 2 Elgin Campus, Phase 2 Hays Campus, Phase 2 Leander Campus, Phase 1 Land Banking - Southeast Travis County
Original Projection 152,800,000 49,000,000 11,200,000 31,966,950 33,400,000 13,200,000 22,400,000 60,000,000 12,000,000 385,966,950
Current Projection 152,800,000 49,000,000 11,200,000 31,966,950 33,400,000 13,200,000 22,400,000 60,000,000 10,611,086 384,578,036
Expended To Date 10,574,591 189,237 2,318,346 495,987 49,590 1,805,657 10,611,086 26,044,494
Rev. Bond Proceeds 385,966,950 (26,044,494) 359,922,456 Balance to Fund 142,225,409 48,810,763 11,200,000 29,648,604 32,904,013 13,200,000 22,350,410 58,194,343 358,533,542
Status In Progress In Progress In Progress In Progress In Progress In Progress In Progress In Progress Complete
Comment
SUMMARY OF HIGHLAND ACQUISITIONS & CONSTRUCTION
Property Dillard's Macy's Core Mall Land Penney's Core Mall Buildings TxDOT Right of Way
ACQUISITIONS Acres Funding Source 18.5 ac Cash 12.8 ac Revenue Bonds, 2011 32.2 ac Revenue Bonds, 2011 17.3 ac Revenue Bonds, 2011A N/A Revenue Bonds, 2011A 2.6 & 4.0 ac Revenue Bonds, 2009 Acquisition Totals 87.4 ac
Project Highland Phase 1 Renovation - Penney's Building Master Development Phase 1 Highland Phase 2 Abatement - Original Mall Building Renovation - Original Mall Building Master Development Phase 2 Dillard's P3 Abatement Mall 1978 Extension Acessibility Improvements Veteran Affairs Center Police Offices Elevator Faculty Offices Bioscience Incubator Mechanical/Electrical/Security Relocation of RGC Programs Chiller Plant Construction Totals
Option Tract Sale #1
CONSTRUCTION Status Funding Source
Projection
Spent
Contractor
Local
A&E
Local
Complete Complete
Revenue Bonds, 2012 Revenue Bonds, 2012
$57.1 million $10.0 million
$57.1 million $10.0 million
Flintco Flintco
Office Office
BGK Redleaf
HQ HQ
In Progress In Progress In Progress
GO Bonds, 2015 GO Bonds, 2015 GO Bonds, 2015
$12.0 million $123.0 million $17.8 million
$3.8 million $6.7 million
ARC Abatement Flintco Flintco
Office Office Office
Baer BGK Redleaf
HQ HQ HQ
In Progress
Revenue Bonds, 2009
$5.9 million
$5.9 million
ARC Abatement
Office
Baer
HQ
Complete Complete Complete Complete In Progress In Progress In Progress In Progress In Progress
Operating Budget Operating Budget Revenue Bonds, 2011A Revenue Bonds, 2011A Revenue Bonds, 2011A Operating Budget Revenue Bonds, 2012 GO Bonds, 2015 To Be Determined
$0.1 million $0.2 million $0.5 million $0.5 million $1.1 million $3.9 million $0.2 million Evalutating Evalutating $232.3 million
$0.1 million $0.2 million $0.5 million $0.5 million $0.1 million $0.5 million $0.2 million
Alpha Building BryComm Jamail Alpha Building Swinerton JT Vaughn Various TBD TBD
Office HQ Office Office Office Office N/A
N/A N/A CasaBella Lawrence Lawrence Pfluger N/A
OPTION TRACT SALES/REIMBURSEMENT Status Complete
Total Expenditures, Net of Sales
Amount $4.7 million $5.7 million $14.8 million $15.9 million $1.9 million $0.2 million $43.2 million
Amount ($3.8 million) $271.9 million
HQ HQ HQ HQ
2014 BOND PROGRAM SUMMARY OF ARCHITECTS AND CONSTURCTION MANAGERS
Project Highland Campus, Phase 2 Leander Campus, Phase 1 Round Rock Campus, Phase 2 Rio Grande Campus Renovation Elgin Campus, Phase 2 Hays Campus, Phase 2
Board Meeting Jun 2015 Jul 2015 Sep 2015 Nov 2015 Nov 2015 Nov 2015
Architect Selected Barnes Gromatzky Kosarek Architects Pfluger Associates Page Studio 8 O'Connell Robertson Brinkley Sargent Wiginton
Board Meeting Sep 2015 Nov 2015 Dec 2015 Feb 2016 Mar 2016 Mar 2016
Construction Manager Selected Flintco American Constructors SpawGlass Contractors Bartlett Cocke DPR Construction JT Vaughn Construction
Project Budget $123 million $60 million $33 million $49 million $13 million $22 million
* Estimated Completion Dates are preliminary until the construction timetable is finalized by each projects the Construction Manager.
Estimated Completion* Fall 2019 Summer 2018 Summer 2018 Fall 2019 Spring 2018 Spring 2018
