NEW PROGRAM BUDGET WORKSHEET Leave cells blank if the information is not applicable to your new program proposal Please add comments and justifications to the right of year 5 Cells in grey are formulas that calculate long term enrollments, FTEs, salary/benefits. These cells should not be used to enter data. Data entry should occur in the green cells only.
I. PLANNED STUDENT ENROLLMENT (click here for retention rates)
Year 1
Year 2
Year 3
Year 4
Year 5
PLANNED
PLANNED
PLANNED
PLANNED
PLANNED
FTE 1.
FTE 1.
FTE 1.
FTE 1.
FTE 1.
A. New Enrollments
Undergrad students …………………… Graduate students (General MBA)……………
18
60
24
30
45
CoB Graduate students…………….. B. Prior Year's Enrollments Adjusted for Retention Undergrad students ………………..
0 0 0
0 0 0
0 0 0
0
Graduate students………………...… CoB Graduate students……………..
24
0
C. Total Headcounts
Undergrad students ……………………………….. Graduate students………………...……………….
0
0
0
0
0
18
24
30
45
84
CoB Graduate students……………..
0
0
0
0
0
Enrollment Notes: For this worksheet Planned FTE and Headcount is assumed to be equal. Cells in grey are formulas for student retention calculations. Enter FTE expected in each year under A. New Enrollments. II. REVENUE On-going One-time Year 1
Year 2
Year 3
Year 4
Year 5
On-going
One-time
On-going
One-time
On-going
One-time
On-going
One-time
1 New Appropriated Funding Request ……….... 2 Institutional Funds …………...………..……………. 3 Federal e.g. grant funds……………………....…. 4 Est. tuition generated by program's college 2 7 Other fees (course fees, etc.) ………………… 8 Other (e.g Kobata, VFF grants TOTAL REVENUE 6 Student Mandatory fees
304,538 52,456
0 0 0 0
406,051 69,942
0 0 0 0
507,564 87,427
0 0 0 0
761,346 131,141
0 0 1,421,179
0 0
244,796
356,995
0
475,993
0
594,991
0
892,487
0
1,665,975
0
Revenue notes:
Enrollments are assumed to be full time; therefore FTE=headcount Tuition and Mandatory Fees are published on the Financial Aid website. Updates are needed each academic year Do not change values in grey. Those are calculated on annual tuition rates * # of FTE above Annual Tuition and Fees Per Credit Tuition Tuition Mandatory Fees Resident Undergraduate 241.03 $7,230 $2,186 Resident Graduate 367.80 $11,034 $2,914 Resident COB Graduate 551.70 $16,551 $2,186
III. EXPENDITURES
Year 1
Year 2
Year 3
Year 4
Year 5
Made with FlippingBook - professional solution for displaying marketing and sales documents online