Budget Template/Form

 

 

 

 

 

---

New Degree or Certificate Proposal Template: Pro Forma Budget

• Download the excel version (updated 4/26/19)

 

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

 

* note that this program does not have a college "home," and program fee will vary by focus area and accrue to the appropriate college.  Thus, to simplify and keep the budget conserverative, the fee has been set to $0 for the pro forma