UWPlatteville Financial Overview January 2018 Todd Carothers Assistant

UW-Platteville Financial Overview January 2018 Todd Carothers- Assistant Chancellor 1

Agenda • Fund Types • Financial Background – 2016 -17 Closing Balances (June 30, 2017) – 2017 -18 All Funds Budget • Projections – Enrollment Projections – Budget Forecast model (Fund 102 & TSI) – Residence Life, Dining & Segregated Fee Budgets – Debt Service • Management Actions & Next Steps 2

Fund Types • General Purpose Revenue (GPR) – includes general funding, specific purpose funding, and earmarked funding from the state, primarily from state sales and income taxes [Funds 102, 104, 109, 110, 402, 403, 406] • Program Revenue (PR) – includes tuition, auxiliaries, and segregated fees, as revenues received for services or from users [Funds 123, 128, 131, 132, 136, 189] • NOTE: Segregated fees are charges assessed to students including textbook rental, health services, student center operations, athletics, intramural sports, parking, student activities (allocable), municipal services, children’s center and ID systems. • Federal Revenue (PR-F) – includes federal grants, financial aid, direct loans, as revenues from a federal agency [Funds 144 – 150] • Gifts and Grants – includes revenues from the Foundation, non federal grants [Funds 133, 134, 184, 233] 3

UW-Platteville Financial Background 4

FY 2016 -17 Closing Balances Program Revenue Balances (per million) and Balance as % of Expeditures 2014 -15 2015 -16 2016 -17 $ 32, 31$ 32, 21 $ 25, 64 [VALUE] 18. 4% [VALUE] 15. 7% 13. 9% Tuition [VALUE] 29. 6% 32. 7% 19. 9% Auxiliary Operations [VALUE][VALUE] 9. 0% 6. 3% 11. 7% General Operations [VALUE] 126. 2% 112. 7% 103. 9% Other Unrestricted Program Revenue [VALUE] 217% 277. 6% 287. 9% Federal Indirect Cost Reimbursement GRAND TOTAL Unrestricted Program Revenue 5

2017 -18 Budget Final 2017 -18 UW-Platteville Budget $193. 3 Million (all funds) Other 1 537 575 1% General Extension Purpose Tax 985 343 Dollars 1% 14 311 518 7% Total State Support - 12% Specific Total State Support - 17% Purpose Tax Dollars 10 441 058 5% Auxiliary Enterprises 48 653 750 25% Gifts and Grants 2 194 908 1% Final 2017 -18 UW-Platteville Budget $141. 7 Million (excluding federal aid) Other 1 537 575 1% Extension 985 343 1% Auxiliary Enterprises 48 653 750 34% Tuition 61 107 851 32% Federal 54 145 256 28% Specific Purpose Tax Dollars Tuition Federal Gifts and Grants Auxiliary Enterprises Other Extension Specific Purpose Tax Dollars 10 441 058 7% Tuition 61 107 851 43% Gifts and Grants 2 194 908 2% General Purpose Tax Dollars 14 311 518 10% Federal 2 455 946 2% General Purpose Tax Dollars Specific Purpose Tax Dollars Tuition Federal Gifts and Grants Auxiliary Enterprises Other Extension 6

Categories of Expenditures Uses Special Purpose/Debt FY 2017 -18 (all funds) Service 14 544 249 8% Unclassified Salary 43 773 125 23% Financial Aid 60 312 213 31% University Staff Salary 12 017 595 6% LTE 486 662 0% Student Help 4 552 867 2% Fringes 23 366 579 12% Capital 6 382 354 3% Unclassified Salary Supplies & Expenses 27 941 615 14% University Staff Salary LTE Student Help Fringes Supplies & Expenses Capital Financial Aid Special Purpose/Debt Service 7

Projections 8

Enrollment Projections (ADS/Study Abroad excluded) 9

Budget Forecast Model (Fund 102 + TSI)_ $0 FY 2017 -18 FY 2018 -19 FY 2019 -20 FY 2020 -21 FY 2021 -22 FY 2022 -23 -$10 000 -$20 000 -$30 000 -$40 000 -$50 000 -$60 000 Net Operating Projected Cumulative Closing Balance as of 10. 23. 2015 -Assumes 100% expenditure of budgets. -Excludes a $3. 0 million reserve. 10

Residence Life 5 -Year Budget Projection Housing - 11. 16. 17 10 000 8 000 6 000 4 000 000 2016 -17 2017 -18 2018 -19 2019 -20 2020 -21 2021 -22 2022 -23 (2 000) (4 000) Revenue Expenses 128 Fund Balance 11

Dining Services 5 -Year Budget Projection Dining - 11. 16. 17 14 000 12 000 10 000 8 000 6 000 4 000 000 2016 -17 2017 -18 2018 -19 2019 -20 2020 -21 2021 -22 2022 -23 (2 000) (4 000) (6 000) Revenue Expenses 128 Fund Balance 12

Segregated Fees 5 -Year Budget Projection Segregated Fees - 11. 16. 17 (Excluding debt svc fees) 10 000 8 000 6 000 4 000 000 2016 -17 2017 -18 2018 -19 2019 -20 2020 -21 2021 -22 2022 -23 (2 000) Revenue Expenses 128 Fund Balance 13

Debt Service Budget Detail 10 000 9 000 8 000 7 000 6 000 General Fund 5 000 Auxiliary TSI 4 000 3 000 2 000 1 000 FY 2013 FY 2014 FY 2015 FY 2016 FY 2017 FY 2018 14

Management Actions What actions can we take to mitigate? • • Leverage existing balances Reduce expenditures Raise auxiliary rates A major focus on revenue producing investments and investments to increase enrollment. 15

Next Steps • Training opportunities – Group sessions have been offered (WISDM, Travel, Excel) – Individual or specialized training for a specific group – Online “on-demand” trainings will be available within the next year • Seek help/consult as needed to support decisions 16