CLARION UNIVERSITY COUNCIL OF TRUSTEES BUDGET UPDATE SEPTEMBER 21, 2017 TABLE OF CONTENTS E&G Surplus/(Deficit) Bar Graph Page 1 E&G Total Compensation Graph Page 2 E&G Prior Year-FY 2016/17 Summary Page 3 E&G Budget: Current Year-FY 2017/18 & Request Year-FY 2018/19 Page 4 Total Funds Budget: Current Year-FY 2017/18 & Request Year-FY 2018/19 Sources Less Uses Page 5 Appendix E&G Revenue Sources Graph Page 6 Clarion FY 2017 SRECNA Page 7 Clarion FY 2017 Cash Flow Page 8 Total Funds Budget: Current Year-FY 2017/18 & Request Year-FY 2018/19 Current Expenditures as % of Revenue Page 9 Student Profile: Prior Year-FY 2016/17, Current Year-FY2017/18 & Request Year-FY 2018/19 Page 10 CLARION E&G SURPLUS/DEFICIT 4,000,000 2,000,000 - Fiscal Year 2009 Fiscal Year 2010 Fiscal Year 2011 Fiscal Year 2012 Fiscal Year 2013 Fiscal Year 2014 Fiscal Year 2015 Fiscal Year 2016 Fiscal Year 2017BUD Fiscal Year 2017 (2,000,000) (4,000,000) (6,000,000) (8,000,000) Surplus Deficit Graph - PAGE 1 CLARION E&G TOTAL COMPENSATION Salaries and Wages Benefits 63,000,000 58,000,000 53,000,000 48,000,000 43,000,000 38,000,000 33,000,000 28,000,000 23,000,000 18,000,000 FY 2014/15 FY 2015/16 FY 2016/17 FY 2017/18-BUD FY 2018/19-BUD Total Compensation Graph-PAGE 2 E&G Prior Year - FY 2016/17 Summary Clarion University of Pennsylvania Educational and General Budget Actual Revenue/Sources Tuition Fees State Appropriation All Other Revenue Planned Use of Carryforward Total Revenue/Sources Budget Actual FY 2015/16 $37,050,276 12,201,288 24,056,297 5,256,199 0 $78,564,060 FY 2016/17 $37,378,542 12,554,211 24,862,718 4,629,706 2,200,000 $81,625,177 FY 2016/17 $37,928,848 12,575,155 24,982,987 6,160,919 0 $81,647,909 Expenditures and Transfers Compensation Summary: Salaries and Wages Benefits Subtotal, Compensation Student Financial Aid Utilities Other Services and Supplies Subtotal, All Services and Supplies Capital Expenditures and Transfers Total Expenditures and Transfers $41,095,675 20,633,888 $61,729,563 1,767,994 1,820,237 15,371,625 $18,959,856 2,655,641 $83,345,060 $39,654,674 20,638,049 $60,292,723 2,231,595 1,837,800 15,179,901 $19,249,296 2,083,158 $81,625,177 $41,011,733 19,993,947 $61,005,680 2,508,861 2,148,805 13,275,306 $17,932,972 2,019,894 $80,958,546 Revenue/Sources Less Expenditures/Transfers ($4,781,000) $0 $689,363 Actual FY 2015/16 3,829.60 314.93 402.71 136.06 4,683.30 Budget FY 2016/17 3,583.51 301.45 458.30 126.96 4,470.22 Actual FY 2015/16 260.67 171.87 76.31 29.72 37.93 576.50 Budget FY 2016/17 256.83 165.75 78.22 30.70 38.55 570.05 Annualized FTE Enrollment In-State Undergraduate Out-of-State Undergraduate In-State Graduate Out-of-State Graduate Total FTE Enrollment E&G FTE of Budgeted Positions Faculty AFSCME Nonrepresented SCUPA All Other Total FTE of Budgeted Positions Act/Act Bud/Act Percent Percent Change Change 2.4% 1.5% 3.1% 0.2% 3.9% 0.5% 17.2% 33.1% n/a -100.0% 3.9% 0.0% -0.2% -3.1% -1.2% 41.9% 18.1% -13.6% -5.4% -23.9% -2.9% 3.4% -3.1% 1.2% 12.4% 16.9% -12.5% -6.8% -3.0% -0.8% Actual FY 2016/17 3,701.23 304.50 458.50 147.33 4,611.56 Change -3.4% -3.3% 13.9% 8.3% -1.5% Change 3.3% 1.0% 0.0% 16.0% 3.2% Actual FY 2016/17 250.94 155.74 75.69 26.32 36.03 544.72 Change -3.7% -9.4% -0.8% -11.4% -5.0% -5.5% Change -2.3% -6.0% -3.2% -14.3% -6.5% -4.4% E&G FY17 SUMMARY - PAGE 3 E&G FY 2017/18 AND FY 2018/19 BUDGET Clarion University of Pennsylvania Educational and General Budget Actual Actual Budget Budget FY 2015/16 $37,050,276 12,201,288 24,056,297 5,256,199 0 $78,564,060 FY 2016/17 $37,928,848 12,575,155 24,982,987 6,160,919 0 $81,647,909 FY 2017/18 $39,209,679 12,610,608 24,942,137 5,086,730 1,090,000 $82,939,154 Percent Change 3.4% 0.3% -0.2% -17.4% #DIV/0! 1.6% FY 2018/19 $39,209,679 12,610,608 24,942,137 5,086,730 0 $81,849,154 Expenditures and Transfers Compensation Summary: Salaries and Wages Benefits Subtotal, Compensation Student Financial Aid Utilities Other Services and Supplies Subtotal, All Services and Supplies Capital Expenditures and Transfers Total Expenditures and Transfers $41,095,675 20,633,888 $61,729,563 1,767,994 1,820,237 15,371,625 $18,959,856 2,655,641 $83,345,060 $41,011,733 19,993,947 $61,005,680 2,508,861 2,148,805 13,275,306 $17,932,972 2,019,894 $80,958,546 $40,444,393 20,452,453 $60,896,846 2,961,520 2,060,120 15,380,348 $20,401,988 1,640,320 $82,939,154 -1.4% 2.3% -0.2% 18.0% -4.1% 15.9% 13.8% -18.8% 2.4% $40,929,509 20,878,676 $61,808,185 3,500,000 2,125,000 15,801,000 $21,426,000 1,430,320 $84,664,505 Revenue/Sources Less Expenditures/Transfers ($4,781,000) $689,363 $0 n/a Actual FY 2015/16 3,829.60 314.93 402.71 136.06 4,683.30 Actual FY 2016/17 3,701.23 304.50 458.50 147.33 4,611.56 Budget FY 2017/18 3,679.33 297.87 474.88 146.92 4,599.00 Change -0.6% -2.2% 3.6% -0.3% -0.3% Budget FY 2018/19 3,680.33 297.87 474.88 146.92 4,600.00 Change 0.0% 0.0% 0.0% 0.0% 0.0% Actual FY 2015/16 260.67 171.87 76.31 29.72 37.93 576.50 Actual FY 2016/17 250.94 155.74 75.69 26.32 36.03 544.72 Budget FY 2017/18 250.85 164.06 76.67 31.89 37.58 561.05 Change 0.0% 5.3% 1.3% 21.2% 4.3% 3.0% Budget FY 2018/19 254.85 162.74 76.65 30.89 37.56 562.69 Change 1.6% -0.8% 0.0% -3.1% -0.1% 0.3% Revenue/Sources Tuition Fees State Appropriation All Other Revenue Planned Use of Carryforward Total Revenue/Sources Annualized FTE Enrollment In-State Undergraduate Out-of-State Undergraduate In-State Graduate Out-of-State Graduate Total FTE Enrollment E&G FTE of Budgeted Positions Faculty AFSCME Nonrepresented SCUPA All Other Total FTE of Budgeted Positions Percent Change 0.0% 0.0% 0.0% 0.0% -100.0% -1.3% 1.2% 2.1% 1.5% 18.2% 3.1% 2.7% -12.8% 2.1% ($2,815,351) E&G BUDGET FY18 & FY19 - PAGE 4 FY 2017/18 & 2018/19 BUDGET - Total Funds Clarion University of Pennsylvania FY 2016/17 ACT Prior Year EDUCATIONAL & GENERAL Current Sources Tuition & Fees Appropriation Other Revenue Planned Use of Carry Forward* Total Sources Personnel Services/Supplies Capital Transfers Total Uses Sources Less Uses FY 2017/18 Current Year Variance: Prior/Current Amount % FY 2018/19 Request Year Variance: Request/Current Amount % $50,504,003 24,982,987 6,160,919 $81,647,909 $51,820,287 24,942,137 5,086,730 1,090,000 $82,939,154 $1,316,284 (40,850) (1,074,189) 1,090,000 $1,291,245 2.6% -0.2% -17.4% n/a 1.6% $51,820,287 24,942,137 5,086,730 $81,849,154 $0 (1,090,000) ($1,090,000) 0.0% 0.0% 0.0% -100.0% -1.3% $61,005,680 17,932,972 642,314 1,377,580 $80,958,546 $689,363 $60,896,846 20,401,988 913,800 726,520 $82,939,154 $0 ($108,834) 2,469,016 271,486 (651,060) $1,980,608 n/a -0.2% 13.8% 42.3% -47.3% 2.4% n/a $61,808,185 21,426,000 703,800 726,520 $84,664,505 ($2,815,351) $911,339 1,024,012 (210,000) $1,725,351 n/a 1.5% 5.0% -23.0% 0.0% 2.1% n/a $5,951,067 (26) 5,089,097 $11,040,138 $5,849,847 5,595,419 $11,445,266 ($101,220) 26 506,322 $405,128 -1.7% -100.0% 9.9% n/a 3.7% $6,075,000 5,794,000 $11,869,000 $225,153 198,581 $423,734 3.8% n/a 3.5% n/a 3.7% $3,636,525 5,928,714 13,676 1,314,237 $10,893,152 $146,986 $4,185,535 6,399,149 65,000 795,582 $11,445,266 $0 $549,010 470,435 51,324 (518,655) $552,114 n/a 15.1% 7.9% 375.3% -39.5% 5.1% n/a $4,282,626 6,725,792 65,000 795,582 $11,869,000 $0 $97,091 326,643 $423,734 n/a 2.3% 5.1% 0.0% 0.0% 3.7% n/a $17,970,650 2,672,634 $20,643,284 $18,010,000 2,649,000 $20,659,000 $39,350 (23,634) $15,716 0.2% -0.9% 0.1% $18,070,000 2,649,000 $20,719,000 $60,000 $60,000 0.3% 0.0% 0.3% $3,823,232 16,584,406 86,345 (21,365) $20,472,618 $170,666 $3,836,239 16,822,761 $20,659,000 $0 $13,007 238,355 (86,345) 21,365 $186,382 n/a 0.3% 1.4% -100.0% -100.0% 0.9% n/a $3,934,237 16,784,763 $20,719,000 $0 $97,998 (37,998) $60,000 n/a 2.6% -0.2% n/a n/a 0.3% n/a $50,504,003 24,982,987 37,844,341 $113,331,331 $51,820,287 24,942,137 37,190,996 1,090,000 $115,043,420 $1,316,284 (40,850) (653,345) 1,090,000 $1,712,089 2.6% -0.2% -1.7% n/a 1.5% $51,820,287 24,942,137 37,674,730 $114,437,154 $0 483,734 (1,090,000) ($606,266) 0.0% 0.0% 1.3% -100.0% -0.5% $68,465,437 40,446,092 742,335 2,670,452 $112,324,316 $1,007,015 $68,918,620 43,623,898 978,800 1,522,102 $115,043,420 $0 $453,183 3,177,806 236,465 (1,148,350) $2,719,104 n/a 0.7% 7.9% 31.9% -43.0% 2.4% n/a $70,025,048 44,936,555 768,800 1,522,102 $117,252,505 ($2,815,351) $1,106,428 1,312,657 (210,000) $2,209,085 n/a 1.6% 3.0% -21.5% 0.0% 1.9% n/a AUXILIARY Current Sources Food Service Housing Other Revenue Planned Use of Carry Forward* Total Sources Current Uses Personnel Services/Supplies Capital Transfers Total Uses Sources Less Uses RESTRICTED Current Sources Govt. Contracts/Grants Other Revenue Total Sources Current Uses Personnel Services/Supplies Capital Transfers Total Uses Sources Less Uses TOTAL Current Sources Tuition & Fees Appropriation Other Revenue Planned Use of Carry Forward* Total Sources Current Uses Personnel Services/Supplies Capital Transfers Total Uses Sources Less Uses *Planned Use of Carry Forward should reflect the planned usage of any unrestricted net assets. Total Funds Budget - PAGE 5 APPENDIX Clarion E&G Revenue Sources in Support of E&G Expenses 90,000,000 78,074,403 80,718,643 80,000,000 84,456,312 82,462,788 85,664,505 83,345,060 80,958,546 80,439,266 79,522,499 82,939,154 77,245,101 70,000,000 23,362,309 60,000,000 26,269,435 22,596,328 25,187,058 22,261,739 23,235,384 24,056,297 12,077,062 12,170,378 12,201,288 40,079,103 38,472,573 37,676,176 37,050,276 Fiscal Year 2013 Fiscal Year 2014 Fiscal Year 2015 Fiscal Year 2016 24,942,137 12,610,608 12,610,608 37,928,848 39,209,679 39,209,679 Fiscal Year 2017 Fiscal Year 2018BUD Fiscal Year 2019BUD 27,972,185 50,000,000 12,462,450 12,436,492 9,137,935 8,575,779 40,000,000 24,942,137 24,982,987 12,575,155 7,822,756 30,000,000 20,000,000 36,775,290 42,361,263 39,729,920 41,235,453 Fiscal Year 2010 Fiscal Year 2011 10,000,000 - Fiscal Year 2009 Net Tuition Fees Fiscal Year 2012 State Appropriation Federal Appropriation Other Revenue Total E&G Expenditures and Transfers, excluding pay as you go E&G Revenue Sources - PAGE 6 Clarion University Statement of Revenues, Expenses, and Change in Net Position FY 2016/17 Revenues Operating Revenues: Tuition and fees less discounts and allowances Net tuition and fees Governmental grants and contracts: Federal State Local Nongovernmental grants and contracts Sales and services Auxiliary enterprises, net of discounts of Other revenues, net Total Operating Revenues 50,504,004 (12,348,025) (175,244) Expenses Operating Expenses: Instruction Research Public Service Academic Support Student Services Institutional Support Operations and Maintenance of Plant Depreciation Student Aid Auxiliary Enterprises Total Operating Expenses Net Operating Revenues (Expenses) Nonoperating Revenues (Expenses) State appropriations, general and restricted Commonwealth on-behalf contributions to PSERS Pell grants Investment income, net of related investment expense of Unrealized gain (loss) on investments Gifts for other than capital purposes Interest expense on capital asset-related debt Gain (loss) on disposal of assets Gain (loss) on acquisition of assets Other nonoperating revenue Net Nonoperating Revenues (Expenses) FY 2015/16 (5,261) 49,251,564 (12,430,066) 38,155,979 36,821,498 4,799,538 6,040,157 0 517,256 5,652,942 10,844,129 573,103 66,583,104 4,082,670 6,378,807 0 250,221 5,277,345 10,983,329 128,008 63,921,878 (407,784) 37,178,030 84,319 8,221,509 8,697,899 12,805,474 12,383,338 8,111,744 5,346,690 4,733,596 8,896,911 106,459,510 37,577,370 262,560 7,692,398 8,823,673 12,611,624 13,096,158 7,421,983 4,982,603 4,637,162 9,475,680 106,581,211 (39,876,406) (42,659,333) 24,982,987 241,697 7,437,203 403,916 0 1,462,371 (354,282) 1,850 0 224,915 34,400,657 24,056,297 202,568 7,500,991 363,416 0 1,423,907 (321,448) 20,184 0 62,038 33,307,953 (5,688) Income (Loss) before other revenues, expenses, gains, or losses (5,475,749) (9,351,380) State appropriations, capital Capital gifts and grants Additions to permanent endowments Total Other Revenues 917,998 256,951 0 1,174,949 881,704 257,107 0 1,138,811 (4,300,800) (8,212,569) Net Position Net position-beginning of year (55,669,428) (47,456,859) Net position-end of year (59,970,228) (55,669,428) Increase (Decrease) in Net Position FY17 SRECNA - PAGE 7 Clarion University Statement of Cash Flows FY 2016/17 FY 2015/16 Cash Flows from Operating Activities A1 Tuition and fees A2 Grants and contracts A3 Payments to suppliers for goods and services A4 Payments to or on behalf of employees A5 Loans issued to students A6 Loans collected from students A7 Student Aid A8 Auxiliary enterprise charges A9 Sales and services A10 Other receipts (payments) Net cash provided by (used in) operating activities 38,175,856 11,827,079 (24,996,120) (68,373,714) (81,862) 101,207 (4,823,845) 10,843,885 5,737,974 (399,818) (31,989,358) 37,796,036 11,010,275 (23,167,641) (68,006,895) (78,560) 188,214 (4,738,244) 11,178,528 5,287,042 863,794 (29,667,451) Cash Flows from Noncapital Financing Activities B1 State appropriations B2 Gifts and nonoperating grants for other than capital purposes B3 PLUS, Stafford, and other loans receipts (non-Perkins) B4 PLUS, Stafford, and other loans disbursements (non-Perkins) B5 Agency transactions, net B6 Other Net cash provided by (used in) noncapital financing activities 24,982,987 8,899,574 46,974,716 (46,974,716) 0 224,915 34,107,476 24,056,297 8,924,898 46,160,394 (46,160,394) 0 62,038 33,043,233 0 917,998 256,951 1,850 (3,335,659) (2,020,053) (442,053) (4,620,966) 1,994,527 881,704 257,107 20,184 (12,304,810) (4,081,234) (489,990) (13,722,512) Cash Flows from Capital Financing Activities C1 Proceeds from capital debt and leases C2 Capital appropriations C3 Capital grants and gifts received C4 Proceeds from sales of capital assets C5 Purchases of capital assets C6 Principal paid on capital debt and leases C7 Interest paid on capital debt and leases Net cash provided by (used in) capital financing activities Cash Flows from Investing Activities D1 Proceeds from sales and maturities of investments D2 Interest on investments D3 Purchase of investments Net cash provided by (used in) investing activities 0 402,960 0 402,960 0 370,780 0 370,780 Net Increase (Decrease) in cash Cash--beginning of year (2,099,888) 21,734,006 (9,975,950) 31,709,956 Cash--end of year 19,634,118 21,734,006 FY17 Cash Flow - PAGE 8 FY 2017/18 & 2018/19 BUDGET - Total Funds Clarion University of Pennsylvania Current Expenditures as % of Revenue EDUCATIONAL & GENERAL Personnel Services/Supplies Capital Transfers Total Expenditures & Transfers FY 2016/17 Prior Year FY 2017/18 FY 2018/19 Current Year Request Year 74.7% 22.0% 0.8% 1.7% 99.2% 73.4% 24.6% 1.1% 0.9% 100.0% 75.5% 26.2% 0.9% 0.9% 103.4% Personnel Services/Supplies Capital Transfers Total Expenditures & Transfers 32.9% 53.7% 0.1% 11.9% 98.7% 36.6% 55.9% 0.6% 7.0% 100.0% 36.1% 56.7% 0.5% 6.7% 100.0% Personnel Services/Supplies Capital Transfers Total Expenditures & Transfers 18.5% 80.3% 0.4% -0.1% 99.2% 18.6% 81.4% 0.0% 0.0% 100.0% 19.0% 81.0% 0.0% 0.0% 100.0% Personnel Services/Supplies Capital Transfers Total Expenditures & Transfers 60.4% 35.7% 0.7% 2.4% 99.1% 59.9% 37.9% 0.9% 1.3% 100.0% 61.2% 39.3% 0.7% 1.3% 102.5% AUXILIARY RESTRICTED TOTAL Exp as a % of Rev - PAGE 9 FY 2017/18 & FY 2018/19 BUDGET REPORT (BUDRPT) Clarion University of Pennsylvania Student Profile Note: Fall Headcount Data must match Program Budget enrollment submissions being completed by the Institutional Research Office. FY 2016/17 Prior Year Fall Headcount (should be whole numbers) Undergraduate In-State Out-of-State Domestic Subtotal, Out-of-State Total Undergraduate Graduate In-State Out-of-State Domestic Foreign Subtotal, Out-of-State Total Graduate Total In-State Headcount Total Out-of-State Headcount Total Fall Headcount Annualized FTE Undergraduate In-State Out-of-State Domestic Foreign Subtotal, Out-of-State Total Undergraduate Graduate In-State Out-of-State Domestic Foreign Subtotal, Out-of-State Total Graduate Total In-State FTE Total Out-of-State FTE Total Annualized FTE FY 2017/18 Current Year FY 2018/19 Request Year 3,963.00 3,929.00 3,930.00 (34.00) -0.9% 1.00 0.0% 346.00 21.00 346.00 4,309.00 345.00 11.00 345.00 4,274.00 345.00 11.00 345.00 4,275.00 (1.00) -0.3% 0.00 0.0% (1.00) (35.00) -0.3% -0.8% 0.00 1.00 0.0% 0.0% 661.00 683.00 683.00 22.00 3.3% 0.00 0.0% 226.00 7.00 233.00 894.00 4,624.00 579.00 5,203.00 228.00 3.00 231.00 914.00 4,612.00 576.00 5,188.00 228.00 3.00 231.00 914.00 4,613.00 576.00 5,189.00 2.00 (4.00) (2.00) 20.00 (12.00) (3.00) (15.00) 0.9% -57.1% -0.9% 2.2% -0.3% -0.5% -0.3% 0.00 0.00 0.00 0.00 1.00 0.00 1.00 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 3,701.23 3,679.33 3,680.33 (21.90) -0.6% 1.00 285.33 19.17 304.50 4,005.73 285.27 12.60 297.87 3,977.20 285.27 12.60 297.87 3,978.20 (0.06) (6.57) (6.63) (28.53) 0.0% -34.3% -2.2% -0.7% 0.00 0.00 0.00 1.00 0.0% n/a 0.0% 0.0% 0.0% 0.0% 458.50 474.88 474.88 3.6% 0.00 0.0% 143.33 4.00 147.33 605.83 4,159.73 451.83 4,611.56 144.92 2.00 146.92 621.80 4,154.21 444.79 4,599.00 144.92 2.00 146.92 621.80 4,155.21 444.79 4,600.00 1.1% -50.0% -0.3% 2.6% -0.1% -1.6% -0.3% 0.00 0.00 0.00 0.00 1.00 0.00 1.00 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% Prior Year Amount % of CIP FTE Total (Undergraduate & Graduate) Annualized FTE Calculated Revenue FTE Fall Headcount 4,611.56 4,668.71 5,224.00 101.2% 113.3% Variance: Prior to Current Amount % 16.38 1.59 (2.00) (0.41) 15.97 (5.52) (7.04) (12.56) Current Year Amount % of CIP FTE 4,599.00 4,655.72 5,199.00 101.2% 113.0% Variance: Current to Request Amount % Request Year Amount % of CIP FTE 4,600.00 4,655.72 5,200.00 101.2% 113.0% STUDENT PROFILE - PAGE 10