Scenario Planning Tool
			Budget 2020
Operating,Alloc,FY18 Budget
	Academic	Auxiliary	Total
Undergraduate Net Tuition & Fees Total	140,000,000	0	140,000,000
Graduate Net Tuition & Fees Total	50,000,000	0	50,000,000
Other Tuition	0	0	-
Non-Credit Net Tuition & Fees Total	0	0	-
Tuition Revenue Total	190,000,000	0	190,000,000
Food Service Revenue	0	9,000,000	9,000,000
General Sales & Service Revenue		10,000,000	10,000,000
Room Revenue		18,000,000	18,000,000
General Sales & Service Revenue Total		37,000,000	37,000,000
Gifts	2,000,000	0	2,000,000
Government Grants-Fed	100,000	0	100,000
Government Grants-MN	0	0	-
Grants & Contracts Total	100,000	0	100,000
Investment Income	0	0	-
Investment Earnings Total	0	0	-
Seminar, Workshop, Other Educl Fees	7,000,000	0	7,000,000
Indirect Cost Recovery & Matching		0
Internal Revenue & Reclasses
Other Revenue
Rentals		2,000,000	2,000,000
Revenue-Perkins Loan Fund Only	0	0	-
Other Revenue Total
Non-Tuition Revenue Total	9,100,000	39,000,000	48,100,000
Total Revenues	199,100,000	39,000,000	238,100,000
Total Taxable Revenue	199,100,000	39,000,000	238,100,000
Margin	94,900,000	20,220,000	115,120,000
Margin %	47.66%	51.85%	48.35%
Executive VP and Provost	100,000	0	100,000
Faculty Affairs		0	-
Global & Local Engagement	3,600,000	0	3,600,000
Planning and Decision Support	0	0	-
Undergraduate Studies	2,800,000	0	2,800,000
Academic Affairs		0	-
Business Office	400,000	0	400,000
Controller's Office	6,200,000	500,000	6,700,000
Financial Planning & Budget	500,000	60,000	560,000
Purchasing Services	1,600,000	150,000	1,750,000
Treasury Office	10,000	0	10,000
VP Business Affairs	1,200,000	100,000	1,300,000
Campus Mail Services	400,000	30,000	430,000
Center for Ministry	100,000	100,000	200,000
Institutional Diversity	300,000	50,000	350,000
Mission	60,000	50,000	110,000
President	1,900,000	10,000	1,910,000
VP Government Relations and Special Projects	300,000	30,000	330,000
General Counsel	800,000	100,000	900,000
General & Administration			-
Debt Service (Principal & Interest)	7,700,000	600,000	8,300,000
Non-Operating G&A			-
Enrollment Services	9,300,000	0	9,300,000
Human Resources	5,000,000	600,000	5,600,000
Information Resources & Technology	9,800,000	8,600,000	18,400,000
University Development & Alumni Relations	10,000,000	0	10,000,000
Libraries	6,800,000	0	6,800,000
Marketing	4,200,000	350,000	4,550,000
Cost of Space Consumed	6,400,000	7,300,000	13,700,000
Physical Plant	700,000	750,000	1,450,000
Parking and Public Safety	2,200,000	2,500,000	4,700,000
Undergraduate Co-Curricular	12,300,000	0	12,300,000
Total Indirect Expenditures	94,670,000	21,880,000	116,550,000
Margin Post Indirect Expenditures ($)	230,000	-1,660,000	(1,430,000)
Margin Post Indirect Expenditures as a % of Revenues (%)	0.12%	-4.26%	-0.60%

Question: What is the forecast for year 2020 and 2021 based on the information provided? Need to do only figures over 1M. Just not sure how to get started. thx