| This template is intended to be used as a basic guide to generate a projection of
additional expenses and revenues at the University. |
| Cells in orange are variables which can be updated as needed. Please enter information
in numerical tab order. |
|
|
|
|
| Cells in gray calculate automatically |
|
| |
Fiscal Year |
| |
1 |
2 |
3 |
4 |
| Revenue |
|
|
|
|
| Cummulative Total NEW headcount enrollment |
0 |
0 |
0 |
0 |
| NEW Resident enrollment (# of new students entering the program each year) |
|
|
|
|
| NEW Non Resident Enrollment (# of new students entering the program each year) |
|
|
|
|
| Resident (credit hours delivered outside of NEW Program) |
0 |
0 |
0 |
0 |
| Resident (credit hours delivered in NEW Program) |
0 |
0 |
0 |
0 |
| Non Resident (credit hours delivered outside of NEW Program) |
0 |
0 |
0 |
0 |
| Non Resident (credit hours delivered in NEW Program) |
0 |
0 |
0 |
0 |
| Total Resident credit hours generated** |
0 |
0 |
0 |
0 |
| Total Non Resident credit hours generated** |
0 |
0 |
0 |
0 |
| |
|
|
|
|
| Per Credit Tuition* |
|
|
|
|
| Resident (Posted Tuition Rate) |
$134 |
$139 |
$145 |
$151 |
| Nonresident (Posted Tuition Rate) |
$537 |
$558 |
$581 |
$604 |
| Prior Year's Non Resident Discount Rate (updated annually by the budget office) |
30% |
30% |
30% |
30% |
| Estimated Actual Non Resident Per Credit Tuition |
$376 |
$391 |
$407 |
$423 |
| Total Resident Tuition generated outside of NEW Program |
$0 |
$0 |
$0 |
$0 |
| Total Resident Tuition in NEW Program |
$0 |
$0 |
$0 |
$0 |
| Total Non Resident Tuition outside of NEW Program |
$0 |
$0 |
$0 |
$0 |
| Total Non Resident Tuition in NEW Program |
$0 |
$0 |
$0 |
$0 |
| |
|
|
|
|
| Total Tuition from NEW Enrollment |
$0 |
$0 |
$0 |
$0 |
| |
|
|
|
|
| Fees |
|
|
|
|
| Program Per Credit Hour |
$0 |
$0 |
$0 |
$0 |
| Program Fee Revenue |
$0 |
$0 |
$0 |
$0 |
| Advising Fee Per Credit Hour |
$6.00 |
$6.00 |
$6.00 |
$6.00 |
| Advising Fee Revenue |
$0 |
$0 |
$0 |
$0 |
| Mandatory Fee (Per Full Time Student) |
$690.00 |
$690.00 |
$690.00 |
$690.00 |
| Mandatory Fee Revenue |
$0 |
$0 |
$0 |
$0 |
| |
|
|
|
|
| Total New Revenue Generated Within New Program |
$0 |
$0 |
$0 |
$0 |
| Total New Revenue Generated Outside of the Program |
$0 |
$0 |
$0 |
$0 |
| Total New Revenue Generated |
$0 |
$0 |
$0 |
$0 |
| |
|
|
|
|
| New Program Expense Assumptions |
|
|
|
|
| Compensation and benefits |
|
|
|
|
| Faculty |
$15,000 |
$10,000 |
$10,000 |
$10,000 |
| Other administrative staff |
|
|
|
|
| Graduate Assistants |
|
|
|
|
| Supplies |
|
|
|
|
| Travel |
|
|
|
|
| Marketing |
$50,000 |
$5,000 |
$5,000 |
$5,000 |
| Capital expense |
0 |
0 |
0 |
0 |
| Other (specify) |
0 |
0 |
0 |
0 |
| |
|
|
|
|
| Projected Financial Results for New Program |
FY1 |
FY2 |
FY3 |
FY4 |
| Total Expenses |
$65,000 |
$15,000 |
$15,000 |
$15,000 |
| Total New Revenues Remaining with Program |
$0 |
$0 |
$0 |
$0 |
| New Program's Total Surplus or Deficit |
-$65,000 |
-$15,000 |
-$15,000 |
-$15,000 |
| Operating margin (surplus or deficit / revenues) |
No Value |
No Value |
No Value |
No Value |
