finance

mt19941i24

budget.xlsx

Home >Business & Finance homework help >finance

2012-2016 -History

RUTGERS, THE STATE UNIVERSITY OF NEW JERSEY
Division 1- New Brunswick Intercollegiate Athletics Programs
Schedule of Revenues and Expenditures
Years ended June 30, 2011 - 2016
								Actual
			2006	2007	2008	2009	2010	2011	2012	2013	2014	2015	2016
Revenues:
	Ticket sales		$ 3,845,565	$ 4,549,838	$ 8,353,115	$ 9,780,816	$ 12,390,580	$ 9,329,987	$ 10,044,989	$ 8,782,103 Lisa Kaplowitz: Lisa Kaplowitz: 1 less home game during season so tix sales were reduced vs other years (~$1.8m)	$ 10,466,489	$ 13,845,553	$ 13,757,852
	Student fees		5,807,996	6,447,790	6,980,728	7,794,629	8,441,092	9,032,350	9,518,734	9,877,989	10,323,090	10,863,906	11,421,897
	Guarantees ($ RU Receives for playing other teams away)		807,000	949,500	734,000	804,000	825,000	3,585,078 Lisa Kaplowitz: Lisa Kaplowitz: Non-recurr: Football vs. Army at Metlife Stadium. Metlife paid $3m gaurantee	900,000	950,000	275,000	462,000	218,500
	Contributions		4,863,963	5,803,105	7,554,789	7,951,689	9,198,611	7,657,866	9,013,610	6,131,982 Lisa Kaplowitz: Lisa Kaplowitz: Contributions decreased due to uncertainty with coaching/admin	8,113,992	8,860,303	8,950,781
	In kind							incl above	incl above	incl above	incl above	1,025,721	953,946
	Direct state or other governmental support		18,245	19,796	17,804	20,054	14,792	13,225	15,299	12,601	16,228	13,184	29,163 Justin Dipoto: Justin Dipoto: Federal work study program
	Direct institutional support(3)		14,366,058	13,829,470	15,238,749	17,917,867	18,411,794	19,429,948	18,462,023	37,106,107 Lisa Kaplowitz: Lisa Kaplowitz: 1 less home game during season so tix sales were reduced vs other years + + One-Time events: -$5m Big East exit fee -$7m Nelligan sports term fee ->$2.3m payout to Mike Rice (basketball) and Tim Pernetti (AD)	26,001,347	12,926,813	17,159,613 Justin Dipoto: Justin Dipoto: Includes tuition credit for out of state student aid
	NCAA/conference distributions incl. all tournament revenues		6,234,164	7,470,416	7,904,157	7,998,219	9,156,101	6,354,691	9,773,663	9,511,703	9,269,466	11,262,350	11,483,214 Lisa Kaplowitz: Lisa Kaplowitz: Will essentially be flat until 2021
	Program sales, concessions, novelty sales and parking		638,939	785,072	1,420,128	1,455,278	1,451,293	1,353,718	1,462,123	1,914,766	1,903,917	2,616,188	2,307,854
	Royalties, advertisements and sponsorships		1,168,352	1,055,719	1,021,608	1,600,759	1,545,527	1,067,969	2,660,407	2,046,662	7,678,049 Lisa Kaplowitz: Lisa Kaplowitz: New IMG contract replaced Nelligan and includes signing bonuses	6,390,207	6,279,407
	Endowment and investment income		2,334,561	1,618,498	851,265	1,014,229	1,012,130	588,237	876,852	900,900	976,638	934,620	877,429
	Other revenues		263,758	172,024	304,965	413,997	272,648	581,706	325,520	633,780	663,833	388,794	9,495,912 Justin Dipoto: Justin Dipoto: Includes loan from University central bank. Not payable to Univ until 2021
		Total revenues	40,348,601	42,701,228	50,381,308	56,751,537	62,719,568	58,994,775	63,053,220	77,868,593	75,688,049	69,589,639	82,935,568
Expenditures:
	Athletic student aid		6,598,167	6,935,471	7,693,148	8,434,254	8,953,847	9,558,152	10,296,880	10,402,285	10,623,500	11,314,062	12,898,975
	Guarantees		1,213,284	1,543,122	1,708,226	2,043,571	2,224,950	2,578,000	2,135,000	2,192,943	1,868,000	1,625,745	1,217,000
	Coaching salaries, benefits and bonuses paid by the Univ.		7,790,539	8,294,060	9,914,810	10,521,559	11,226,905	10,942,832	10,754,898	10,391,331	10,435,941	10,945,515	13,985,250 Lisa Kaplowitz: Lisa Kaplowitz: Add'l pay for Ash- Football; Pikiell - Basketball + related staff
	Support staff/admin salaries and benefits paid by the Univ.		7,148,242	7,391,241	8,267,912	9,285,406	9,174,857	8,052,532	8,986,735	9,428,243	10,132,550	9,173,985	8,795,921 Lisa Kaplowitz: Lisa Kaplowitz: Foundation and trainer support was misclassed as Other. Reclass back to original method going forward
	Severance payments		-	-	-	547,087	833,125	-	409,489	2,266,716	-	-	3,663,380 Justin Dipoto: Justin Dipoto: MBB-Jordan, FB-Flood, AD-Herman
	Recruiting		619,391	604,174	697,539	772,380	699,737	718,843	724,732	858,692	969,251	1,265,686	1,268,907
	Team travel		3,818,302	4,355,456	4,617,910	4,594,105	4,298,505	3,382,065	4,427,141	5,191,974	5,812,441	5,729,096	6,056,800
	Equipment, uniforms and supplies		2,179,216	2,083,737	1,831,738	1,719,385	1,387,924	1,379,293	1,301,299	1,555,793	1,537,376	2,367,424	2,924,290 Lisa Kaplowitz: Lisa Kaplowitz: Increase due to new Nike football uniforms. 2017-18 will see increase with adidas transition.
	Game expenditures		1,722,300	2,002,462	2,981,994	3,169,842	3,599,746	3,350,125	3,920,419	3,516,414	4,134,986	3,711,061	4,216,834
	Fundraising, marketing and promotion		2,040,314	2,066,369	2,562,342	3,014,615	2,344,882	1,773,817	1,205,099	8,392,233 Lisa Kaplowitz: Lisa Kaplowitz: Non-Recurr: Nelligan sports contract termination fee of $7mm			Lisa Kaplowitz: Lisa Kaplowitz: Increase due to new Nike football uniforms. 2017-18 will see increase with adidas transition.	2,513,547	2,524,155	3,069,173
	Direct facilities, maintenance and rental		1,837,123	1,942,991	1,995,898	4,541,325	9,896,588	11,029,885	11,212,005	9,810,788	10,973,173	10,715,886	13,256,017 Lisa Kaplowitz: Lisa Kaplowitz: New admin priorities. Will increase going forward.
	Spirit groups		732,799	698,873	638,368	744,703	807,051	554,674	569,469	558,083	633,404	631,399	632,445
	Medical expenditures and medical insurance		1,661,280	2,005,130	1,886,691	1,669,145	2,079,817	1,906,788	2,052,695	2,088,704	2,482,998	2,553,927	2,628,232
	Membership dues		30,419	31,248	27,687	38,978	33,663	28,878	29,411	5,030,149 Lisa Kaplowitz: Lisa Kaplowitz: $11.5m cash settlement to Exit Big East. $5m expensed in 2013 and accrued $6.5m to be expensed in 2014	6,536,330 Lisa Kaplowitz: Lisa Kaplowitz: Settlement to Exit Big East. $6.5m expensed in 2014	364,401	118,070
	Other expenditures		3,612,150	3,687,622	5,310,287	5,509,568	5,157,971	3,738,891	5,027,948	6,184,245	7,034,552	6,667,297	8,204,274 Justin Dipoto: Justin Dipoto: New NCAA (EADA) format includes further breakout for student athlete meals (non-travel). Also student athlete meals (in add't to aid now reported separately)
										Lisa Kaplowitz: Lisa Kaplowitz: 1 less home game during season so tix sales were reduced vs other years (~$1.8m)	Lisa Kaplowitz: Lisa Kaplowitz: Non-recurr: Football vs. Army at Metlife Stadium. Metlife paid $3m gaurantee		Lisa Kaplowitz: Lisa Kaplowitz: Contributions decreased due to uncertainty with coaching/admin	Lisa Kaplowitz: Lisa Kaplowitz: 1 less home game during season so tix sales were reduced vs other years + + One-Time events: -$5m Big East exit fee -$7m Nelligan sports term fee ->$2.3m payout to Mike Rice (basketball) and Tim Pernetti (AD)			Justin Dipoto: Justin Dipoto: Federal work study program	Total expenditures	41,003,526	43,641,956	50,134,550	56,605,923	62,719,568	58,994,775	63,053,220	77,868,593	75,688,049	69,589,639	82,935,568
		Excess of revenues over expenditures	$ (654,925)	$ (940,728)	$ 246,758	$ 145,614	$ -	$ -	$ -	$ -	$ -	$ -	$ -
Source: NCAA Agreed Upon Procedure reports, excluding third party compensation/benefits
(1) Removed compensation and benefits provided by and paid by third party (both rev and exp)
(2) Removed sports camp (both rev and exp) - if exp was not included, reduced "other expenditures"
(3) Normalized level is approx $11m, pre-B1G 10

&8&Z&F/&A &8&D &T

15-'19 - Sect 2 - HW

($ in thousands)			Actual			Forecast		% Growth				% of Total Revenues
			2015	2016	2017	2018E	2019E	'15-16	'16-17	'17-18E	'18E-19E	'15	'16	'17	'18E	'19E	Comments/Rationale
Revenues:
	Ticket sales		$ 13,846	$ 13,758	$ 14,038	$ 13,336		-0.64%	2.04%	-5.00%		19.90%	16.59%	15.93%	14.69%
	Student fees		10,864	11,422	11,767	12,120		5.14%	3.02%	3.00%		15.61%	13.77%	13.36%	13.35%
	Contributions		8,860	8,951	8,966	10,939		1.03%	0.17%	22.00%		12.73%	10.79%	10.18%	12.05%
	Direct institutional support(a)		12,927	17,160	11,236	11,798		32.75%	-34.52%	5.00%		18.58%	20.69%	12.75%	13.00%
	Loan proceeds against Big10 Future earn				11,971	-		n/a	n/a	-100.00%		0.00%	0.00%	13.59%	0.00%
	NCAA/BIG 10 conf. distributions(b)		11,262	11,483	14,367	22,987		1.96%	25.12%	60.00%		16.18%	13.85%	16.31%	25.33%
	Other		11,831	20,161	15,755	19,580		70.41%	-21.85%	24.28%		17.00%	24.31%	17.88%	21.57%
		Total revenues	69,590	82,935	88,100	90,760		19.18%	6.23%	3.02%		100.00%	100.00%	100.00%	100.00%
Expenditures:
	Student aid		11,314	12,899	14,007	15,248		14.01%	8.59%	8.86%		16.26%	15.55%	15.90%	16.80%
	Salaries & fringe benefits		20,120	22,781	34,678	35,578		13.23%	52.22%	2.60%		28.91%	27.47%	39.36%	39.20%
	Sport & game day expenses		13,073	14,467	15,034	14,975		10.66%	3.92%	-0.39%		18.79%	17.44%	17.06%	16.50%
	Debt service (Internal + external)		-	-	6,352	6,353		n/a	n/a	0.02%		0.00%	0.00%	7.21%	7.00%
	Other		25,083	32,788	18,029	18,606		30.72%	-45.01%	3.20%		36.04%	39.53%	20.46%	20.50%
		Total expenditures	69,590	82,935	88,100	90,760		19.18%	6.23%	3.02%		100.00%	100.00%	100.00%	100.00%
		Net operating revenue (deficit)	$ -	$ -	$ -	$ -		n/a	n/a	n/a		0.00%	0.00%	0.00%	0.00%
(a) Normalized level is approx $11m, pre-B1G 10
(b) NCAA/conference distributions incl. all tournament revenues

&"Arial,Bold"&12RUTGERS, THE STATE UNIVERSITY OF NEW JERSEY Division 1 - NB Intercollegiate Athletic Programs Schedule of Revenues & Expenditures Years ended June 30, 2015-2019

&8&Z&F/&A &8&D &T

15-'19 - Calcs

($ in thousands)			Actual			Forecast		% Growth				% of Total Revenues
			2015	2016	2017	2018E	2019E	'15-16	'16-17	'17-18E	'18E-19E	'15	'16	'17	'18E	'19E	Comments/Rationale
Revenues:
	Ticket sales		$ 13,846	$ 13,758	$ 14,038			-1%	2%			20%	17%	16%
	Student fees		10,864	11,422	11,767			5%	3%			16%	14%	13%
	Contributions		8,860	8,951	8,966			1%	0%			13%	11%	10%
	Direct institutional support(a)		12,927	17,160	11,236			33%	-35%			19%	21%	13%
	Loan proceeds against Big10 Future earn				11,971			nm	nm			0%	0%	14%
	NCAA/BIG 10 conf. distributions(b)		11,262	11,483	14,367			2%	25%			16%	14%	16%
	Other		11,831	20,161	15,755			70%	-22%			17%	24%	18%
		Total revenues	69,590	82,935	88,100			19%	6%			100%	100%	100%
Expenditures:
	Student aid		11,314	12,899	14,007			14%	9%			16%	16%	16%
	Salaries & fringe benefits		20,120	22,781	34,678			13%	52%			29%	27%	39%
	Sport & game day expenses		13,073	14,467	15,034			11%	4%			19%	17%	17%
	Debt service (Internal + external)		-	-	6,352			nm	nm			0%	0%	7%
	Other		25,083	32,788	18,029			31%	-45%			36%	40%	20%
		Total expenditures	69,590	82,935	88,100			19%	6%			100%	100%	100%
		Net operating revenue (deficit)	$ -	$ -	$ -			nm	nm			0%	0%	0%
Source: Rutgers Athletic Department
(a) Normalized level is approx $11m, pre-B1G 10
(b) NCAA/conference distributions incl. all tournament revenues

&"Arial,Bold"&12RUTGERS, THE STATE UNIVERSITY OF NEW JERSEY Division 1 - NB Intercollegiate Athletic Programs Schedule of Revenues & Expenditures Years ended June 30, 2015-2019

&8&Z&F/&A &8&D &T

15-'17 -In Class

PRINT FOR CLASS HANDOUT
($ in thousands)												Actual			Forecast			% Growth				% of Total Revenues
			2006	2007	2008	2009	2010	2011	2012	2013	2014	2015	2016	2017	2018E	2019E		'15-16	'16-17	'17-18E	'18E-19E	'15	'16	'17	'18E	'19E	Comments/Rationale
Revenues:
	Ticket sales		$ 3,845,565	$ 4,549,838	$ 8,353,115	$ 9,780,816	$ 12,390,580	$ 9,329,987	$ 10,045	$ 8,782 Lisa Kaplowitz: Lisa Kaplowitz: 1 less home game during season so tix sales were reduced vs other years (~$1.8m)	$ 10,466	$ 13,846	$ 13,758	$ 14,038
	Student fees		5,807,996	6,447,790	6,980,728	7,794,629	8,441,092	9,032,350	9,519	9,878	10,323	10,864	11,422	11,767
	Guarantees (a)		807,000	949,500	734,000	804,000	825,000	3,585,078 Lisa Kaplowitz: Lisa Kaplowitz: Non-recurr: Football vs. Army at Metlife Stadium. Metlife paid $3m gaurantee	900	950	275	462	218
	Contributions		4,863,963	5,803,105	7,554,789	7,951,689	9,198,611	7,657,866	9,014	6,132 Lisa Kaplowitz: Lisa Kaplowitz: Contributions decreased due to uncertainty with coaching/admin	8,114	8,860	8,951	8,966
	In kind							incl above	Inc. Above	Inc. Above	Inc. Above	1,026	954
	Direct state or other governmental support		18,245	19,796	17,804	20,054	14,792	13,225	15	13	16	13	29 Justin Dipoto: Justin Dipoto: Federal work study program
	Direct institutional support(b)		14,366,058	13,829,470	15,238,749	17,917,867	18,411,794	19,429,948	18,462	37,106 Lisa Kaplowitz: Lisa Kaplowitz: 1 less home game during season so tix sales were reduced vs other years + + One-Time events: -$5m Big East exit fee -$7m Nelligan sports term fee ->$2.3m payout to Mike Rice (basketball) and Tim Pernetti (AD)	26,001	12,927	17,160	11,236
	NCAA/conference distributions(c)		6,234,164	7,470,416	7,904,157	7,998,219	9,156,101	6,354,691	9,774	9,512	9,269	11,262	11,483	14,367
	Program sales, concess., novelty & parking		638,939	785,072	1,420,128	1,455,278	1,451,293	1,353,718	1,462	1,915	1,904	2,616	2,308
	Royalties, advertisements and sponsorships		1,168,352	1,055,719	1,021,608	1,600,759	1,545,527	1,067,969	2,660	2,047	7,678 Lisa Kaplowitz: Lisa Kaplowitz: New IMG contract replaced Nelligan and includes signing bonuses	6,390	6,279
	Endowment and investment income		2,334,561	1,618,498	851,265	1,014,229	1,012,130	588,237	877	901	977	935	877
	Loan proceeds against BIG 10 future earnings													11,971
	Other revenues		263,758	172,024	304,965	413,997	272,648	581,706	326	634	664	389	9,496 Justin Dipoto: Justin Dipoto: Includes loan from University central bank. Not payable to Univ until 2021	15,755
		Total revenues	40,348,601	42,701,228	50,381,308	56,751,537	62,719,568	58,994,775	63,054	77,870	75,687	69,590	82,935	88,100
Expenditures:
	Athletic student aid		6,598,167	6,935,471	7,693,148	8,434,254	8,953,847	9,558,152	10,297	10,402	10,624	11,314	12,899	14,007
	Guarantees		1,213,284	1,543,122	1,708,226	2,043,571	2,224,950	2,578,000	2,135	2,193	1,868	1,626	1,217
	Coaching salaries, benefits and bonuses		7,790,539	8,294,060	9,914,810	10,521,559	11,226,905	10,942,832	10,755	10,391	10,436	10,946	13,985 Lisa Kaplowitz: Lisa Kaplowitz: Add'l pay for Ash- Football; Pikiell - Basketball + related staff	34,678
	Support staff/admin salaries and benefits		7,148,242	7,391,241	8,267,912	9,285,406	9,174,857	8,052,532	8,987	9,428	10,133	9,174	8,796 Lisa Kaplowitz: Lisa Kaplowitz: Foundation and trainer support was misclassed as Other. Reclass back to original method going forward
	Severance payments		-	-	-	547,087	833,125	-	409	2,267	-	-	3,663 Justin Dipoto: Justin Dipoto: MBB-Jordan, FB-Flood, AD-Herman
	Recruiting		619,391	604,174	697,539	772,380	699,737	718,843	725	859	969	1,266	1,269
	Team travel		3,818,302	4,355,456	4,617,910	4,594,105	4,298,505	3,382,065	4,427	5,192	5,812	5,729	6,057
	Equipment, uniforms and supplies		2,179,216	2,083,737	1,831,738	1,719,385	1,387,924	1,379,293	1,301	1,556	1,537	2,367	2,924 Lisa Kaplowitz: Lisa Kaplowitz: Increase due to new Nike football uniforms. 2017-18 will see increase with adidas transition.
	Sport & game day expenses		1,722,300	2,002,462	2,981,994	3,169,842	3,599,746	3,350,125	3,920	3,516	4,135	3,711	4,217	15,034
	Fundraising, marketing and promotion		2,040,314	2,066,369	2,562,342	3,014,615	2,344,882	1,773,817	1,205	8,392 Lisa Kaplowitz: Lisa Kaplowitz: Non-Recurr: Nelligan sports contract termination fee of $7mm			Lisa Kaplowitz: Lisa Kaplowitz: Increase due to new Nike football uniforms. 2017-18 will see increase with adidas transition.	2,514	2,524	3,069
	Direct facilities, maintenance and rental		1,837,123	1,942,991	1,995,898	4,541,325	9,896,588	11,029,885	11,212	9,811	10,973	10,716	13,256 Lisa Kaplowitz: Lisa Kaplowitz: New admin priorities. Will increase going forward.
	Spirit groups		732,799	698,873	638,368	744,703	807,051	554,674	569	558	633	631	633
	Medical expenditures and medical insurance		1,661,280	2,005,130	1,886,691	1,669,145	2,079,817	1,906,788	2,053	2,089	2,483	2,554	2,628
	Membership dues		30,419	31,248	27,687	38,978	33,663	28,878	29	5,030 Lisa Kaplowitz: Lisa Kaplowitz: $11.5m cash settlement to Exit Big East. $5m expensed in 2013 and accrued $6.5m to be expensed in 2014	6,536 Lisa Kaplowitz: Lisa Kaplowitz: Settlement to Exit Big East. $6.5m expensed in 2014	Lisa Kaplowitz: Lisa Kaplowitz: 1 less home game during season so tix sales were reduced vs other years (~$1.8m)	Lisa Kaplowitz: Lisa Kaplowitz: Non-recurr: Football vs. Army at Metlife Stadium. Metlife paid $3m gaurantee				364	118
	Debt service (Internal + external)													6,352
	Other expenditures		3,612,150	3,687,622	5,310,287	5,509,568	5,157,971	3,738,891	5,028	6,184	7,035	6,668	8,204 Justin Dipoto: Justin Dipoto: New NCAA (EADA) format includes further breakout for student athlete meals (non-travel). Also student athlete meals (in add't to aid now reported separately)	Lisa Kaplowitz: Lisa Kaplowitz: Contributions decreased due to uncertainty with coaching/admin	Lisa Kaplowitz: Lisa Kaplowitz: 1 less home game during season so tix sales were reduced vs other years + + One-Time events: -$5m Big East exit fee -$7m Nelligan sports term fee ->$2.3m payout to Mike Rice (basketball) and Tim Pernetti (AD)				18,029
		Total expenditures	41,003,526	43,641,956	50,134,550	56,605,923	62,719,568	58,994,775	63,052	77,868	75,688	69,590	82,935	88,100
		Excess of revenues over expenditures	$ (654,925)	$ (940,728)	$ 246,758	$ 145,614	$ -	$ -	$ (2)	$ (2)	$ 1	$ -	$ -	$ -
Source: Rutgers Athletic Department
(a) Monies RU receives for playing other teams away
(b) Normalized level is approx $11m, pre-B1G 10
(c) NCAA/conference distributions incl. all tournament revenues

&"Arial,Bold"&12RUTGERS, THE STATE UNIVERSITY OF NEW JERSEY Division 1 - NB Intercollegiate Athletic Programs Schedule of Revenues & Expenditures Years ended June 30, 2015-2019

&8&Z&F/&A &8&D &T