Transcript Slide 1

UW-Platteville Financial Overview
November 2012
Robert Cramer - Vice Chancellor
Cathy Riedl-Farrey - Director, Financial
Services
1
• Summary of Funding Sources
• UW-Platteville Financial Update
– 2011-12 Closing Balances (June 30, 2012)
– Utilities
– 2012-13 All Funds Budget
– Tuition and enrollment
– Budget Forecast model
– TSI Detail
– Debt Service Detail
2
• General Purpose Revenue (GPR) – includes general funding,
specific purpose funding, and earmarked funding from the
state, primarily from state sales and income taxes
• Program Revenue (PR) – includes tuition, auxiliaries, and
segregated fees, as revenues received for services or from
users
• Federal Revenue (PR-F) – includes federal grants, financial aid,
direct loans, as revenues from a federal agency
• Segregated Funds (SEG) – includes transportation fund and
other separate state accounts, credited by law to a specific
state fund
• Gifts and Grants – includes revenues from the Foundation,
non federal grants
3
UW-Platteville Financial Update
4
FY2011-12 Closing Balances
All Funds Summary (Cash Basis)
• Beginning Cash
$ 23,128,452 (7/01/2011 rev)
• Total Revenue
$128,276,751
• Total Expenses
$126,913,276
• Net Income
$ 1,363,475
– Excluding direct student loan amounts
• Closing Balance
$ 24,491,927
(6/30/2012)
5
Select Fund Balances
• Fund 102
$4,721,950
(General operations, tuition revenue, base of $47 million)
• Fund 123
• Fund 128
$4,001,400 (Debt service, $4 M base)
$4,096,650
(Dining, housing, parking, base of $25 million)
• Fund 131
$8,474,838
(DLC, School of Ed Cost Recovery, TSI, base of $15 million)
• Fund 136
$1,693,089
(Similar to 128, HTCP, camps & conferences, base of $3.7
million)
6
Carry Over Balances by
College/Division
Chancellor & Diversity
Provost
Administrative Services
Graduate Studies & Library
Student Affairs
Advancement/Development
Admissions & Enrollment Services
LAE
BILSA
EMS
Budget Lapse
Grand Total Carryover***
74,763.00
110,340.00
383,480.00
40,518.00
39,840.00
222,100.00
48,262.00
52,212.00
171,683.00
700,654.00
312,841.00
2,156,693.00
***Excludes accounts that automatically carryover (i.e. Fund 128, 136, some 131)
7
Utility Update
1,800,000
1,600,000
1,400,000
1,200,000
1,000,000
FY11 Actual
800,000
FY12 Actual
600,000
400,000
200,000
Electricity
•
•
•
•
Gas
Coal
FY12 – PLT under budget by $911,000; System wide - $7.6 million
Highest savings in the UW System
Savings was kept centrally by UW System
Future savings distribution still being discussed
8
2001-02 Budget
Final 2001-2002 UW-Platteville Budget
$73.6 Million
Tuition
$16,185,195
22%
Auxiliary Enterprises
$20,714,713
29%
Specific Purpose Tax
Dollars
$5,868,019
8%
State
funding
of 40%
Gifts and Grants
$839,192
1%
Federal
$5,454,833
7%
General Purpose Tax
Dollars
$23,786,913
32%
Extension
$795,229
1%
9
2012-13 Budget
Final 2012-2013 UW-Platteville Budget
$172.6 Million (all funds)
State Funding
of 17%
Auxiliary
Enterprises
40,242,335
32%
Final 2012-2013 UW-Platteville Budget
$126.1 Million (excluding federal aid)
Extension
616,185
1%
State
Funding
General
Purpose Tax of 22%
Dollars
17,004,951
13%
Gifts and
Grants
1,314,900
1%
Federal
1,646,700
1%
Specific
Purpose Tax
Dollars
11,452,271
9%
Tuition
53,804,157
43%
10
Financial Forecast Assumptions
• Revenue modeling to project available funds from the state, TSI,
and tuition (traditional undergrads and grads)
• Key variables are tuition, enrollment and state support
• Assumes 3.0% increases in tuition annually
• Assumes flat enrollment at Fall 2012 levels except for TSI
• Assumes TSI growth to 1705 in FY2016-17
• Assumes TSI faculty & staff growth maintaining the current
faculty/staff to student ratio of TSI
• Assumes flat general purpose revenue excluding lapse
• Assumes lapses of $174 million in 2011-13 and $300 million 201315 statewide with allocation as proposed in 2011-13
• Assumes 2% pay plan for TSI expenditures for 13-14 forward;
Assumes GPR pay plan funded by state so no cost factors included
• Assumes TSI incentive grant will be for new students only starting in
Fall 2013. No continuing student grants.
11
Tuition Revenue
Tuition Target for Pooled Revenue=$33,435,359
Variance
Original Estimate 5.2012
$35,218,000
$1,783,000
Fall 2012
$36,536,000
$3,100,000
TSI Estimate 5.2012
$13,405,000
-
Fall 2012
$14,400,000
$995,000
Spring 2013
Spring 2013
Note – these figures exclude distance learning, study
abroad, and school of education cost recovery students
12
Enrollment
Original
Fall Billing
FTE
Fall 2012
Billing FTE
Original
Spring Billing
FTE [90%]
5,375
5,514
4,837
Undergrad NonRes
118
180
106
Graduate Resident
116
95
104
Graduate NonRes
23
26
21
Subtotal Pooled Enrollment
5,632
5,815
5,068
TSI Enrollment
1,370
1,472
1,233
Total Pooled & TSI Enrollment
7,002
7,287
6,301
Undergrad Resident
Spring 2013
Billing FTE
13
Budget Forecast Model
Projected Closing Balances
FY2013
FY2014
FY2015
FY2016
FY2017
With $300M Lapse
and $1.6M plan
[June 15, 2012]
4,272,630
479,169
(2,181,148)
(5,499,997)
(8,885,092)
With $174M Lapse
and $1.6M plan
8,372,476
6,735,993
6,128,601
5,445,374
4,692,248
12,236,000
14,244,000
13,090,000
14,9367,000
15,260,000
Additional
Requests
14
TSI Budget Detail
2011-12
Count
Revenue
2012-13
Actual
Count
2013-14
Projected
Count
Projected
1,301
12,602,713
1,472 13,401,000
1,580 15,760,000
159
8,751,138
164 10,863,265
179 12,383,000
Supplies
576,216
798,008
760,000
Debt
Incentive
Grants
2,070,000
2,070,000
2,070,000
824,338
895,000
500,000
555,377
273,169
12,777,069
14,899,442
Expenses:
Salary & Fringe
Carryover
Total Expenses:
Note: 34 positions were formerly GPR funded
15,713,000
15
Unclassified FTE by division (all funds)
Division
Allocated
FY13
Filled as of 10.22.12
Chancellor
25.07
24.37
Provost
58.67
49.39
Assoc Vice Chancellor
17.83
16.83
Administrative Services
43.55
37.30
Admissions
22.00
19.50
Diversity
16.75
14.80
Student Affairs
30.21
30.00
University Advancement
15.00
14.00
BILSA
94.27
96.02
LAE
164.32
164.58
EMS
143.23
141.07
Total
630.90
607.86 16
Classified FTE by division (all funds)
Division
Chancellor
Allocated
FY13
Filled as of 10.22.12
5.00
5.00
Provost
20.32
20.32
Assoc Vice Chancellor
14.50
14.50
188.68
182.68
Admissions
9.50
9.50
Diversity
4.00
4.00
Student Affairs
26.00
26.00
University Advancement
11.00
10.00
8.50
8.50
LAE
14.00
14.00
EMS
11.75
11.75
Total
313.25
306.25 17
Administrative Services
BILSA
Debt Service
• UW-Platteville has two types of debt service
on facilities
– General Fund Borrowing is funded through state
appropriations of general purpose revenue
– Program Revenue Borrowing is funded through
University revenues including TSI
• Debt is issued centrally by the State
• 20 year bonds are typical
18
Debt Service Detail
Description
General Fund
Fund
110
FY2011
Budgeted
5,462,888
Parking
PAC
Fieldhouse Addition
Children's Center
Pioneer Student Center
Residence Halls
Stadium
Food Service/Union
Chancellor's Residence
Subtotal
123
123
123
123
123
123
123
123
123
123
227,300
12,726
319,294
35,842
919,251
1,913,710
154,771
428,239
15,241
4,026,374
204,400
12,716
430,704
36,092
926,966
1,919,439
155,808
441,453
15,360
4,142,938
265.200
380,807
35,854
934,511
2,160,374
156,287
439,809
15,289
4,388,131
FY2030
FY2012
FY2031
FY2020
FY2021
FY2032
FY2025
FY2031
FY2019
TSI
194
2,070,000
2,070,000
2,070,000
FY2031
11,559,262
11,675,826
13,921,919
Grand Total Debt Service
FY2012
Budgeted
3,590,333
FY2013
Bond End
Budgeted
Date
7,463,788
19
Questions and Next Steps
• Proceed with Strategic Planning
• Research and develop different budget
process
• Budget request form
http://www.uwplatt.edu/business/forms.html
• Budget submissions are due December 15th
through your division leader
20