NCAA Financials.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Overview
2
General InformationThis workbook is an attempt to compare all 63 institution that sponsored men's or women's ice hockey at the NCAA Division I level between 2009 and 2016. Due to the NCAA changing reporting categories and procedures, public schools changing how they report revenue and expenses, and half the schools being private and thereby having much more limited information available, this is at best an incomplete work.
3
Public InstitutionsFor the 32 public schools their annual NCAA Financial reports were either found online or requested under freedom of information/public record request laws. Of the 32, only 1 declined the FOIA request (due not being a citizen of the state) and 1 is still outstanding.
4
Private InstitutionsFor the 31 private schools (plus Alabama-Huntsville) only the much more limited and less accurate EADA (Equity in Athletics Data Analysis) information is publicly available. To supplement this the average annual tuition from 2009-16 was researched for each private school that offers athletic aid and then was multiplied by the estimated total amount of athletic equivalencies awarded by each school. Total athletic equivalencies awarded was based on the average total athletic equivalencies awarded by the public schools (rounded up to the next half scholarship), or league mandated limits when less, and then reduced as needed to make the minimum amount of other expenses not reported by private schools no less than 5% less than the smallest amount reported by a public school. These estimated amounts were compared to the total athletic aid reported on the EADAs for men's and women's teams for the four DIII schools that play up in hockey. The estimated amounts varied between 8.6% higher to 9.5% lower, with 16 of the 49 compared being within 1%, 24 within 2.5%, and 40 within 5% of the EADA amount. The EADA amounts were then used for the 4 schools, with athletic equivalencies adjusted accordingly. Total head and assistant coaches salaries for all athletics was calculated by multiplying average full-time employee (FTE) salaries for men, women and coed teams by the number of FTE positions reported for each and then adding them together.
5
Sheets
6
OverviewAn overview of the workbook
7
Reporting CategoriesDetails for all NCAA revenue and expense reporting categories used from 2010-16 as well as additional information that is not in the NCAA reports which has been added using information from the reports or added to be used with information in the reports .
8
Averaged HockeyAveraged hockey revenue and expenses for each school for the number of years' worth of information compiled on the Yearly Hockey sheet. Some averages are based on all years, others are averaged for only those years that the NCAA used the categories and some are averaged for only those years the school reported revenue or expenses. This was done to try to most accurately reflect the average amount for each category. Because of this the sum of the individual categories will not always equal the total revenue and total expense categories.
9
Yearly HockeyYearly hockey revenue and expenses reported for each school for each year from NCAA financial reports or EADAs.
10
Averaged Hockey %Revenue and expenses for each category on the Averaged Hockey sheet as a percentage of total hockey revenue and expenses. Because of how the categories have been averaged the sum of the categories will not always equal 100%.
11
Yearly Hockey %Revenue and expenses for each category on the Yearly Hockey sheet as a percentage of total hockey revenue and expenses for each reported year.
12
Averaged OverallAveraged overall revenue and expenses for each school for the number of years' worth of information compiled on the Yearly Overall sheet. Some averages are based on all years reported, others are averaged for only those years that the NCAA used the categories and some are averaged for only those years the school reported revenue or expenses. This was done to try to most accurately reflect the average amount for each category. Because of this the sum of the individual categories will not always equal the total revenue and total expense categories.
13
Yearly OverallYearly overall revenue and expenses for each school for each year's information available from NCAA financial reports or EADAs.
14
Averaged Hockey % of OverallAveraged hockey revenue and expenses for each category as a percentage of total averaged sports revenue and expenses for each category.
15
Yearly Hockey % of OverallYearly hockey revenue and expenses for each category as a percentage of total yearly sports revenue and expenses for each category.
16
Averaged Hockey Women % MenAveraged women's hockey revenue and expenses for each category as a percentage of men's hockey revenue and expenses for each category. Only schools that sponsored both sports between 2009-16 are included.
17
Yearly Hockey Women % MenYearly women's hockey revenue and expenses for each category as a percentage of men's hockey revenue and expenses for each category. Only schools that sponsored both sports between 2009-16 are included.
18
NotesImportant notes
19
Thank You
20
I wish to thank everyone at all the public universities and military academies who received my FOIA/public record requests and worked to fulfill them. This project would not be nearly as complete without their efforts.
21
Feedback/Corrections
22
Every effort has been made to be accurate, but with the amount of transcribing required and the number of formulas used in the workbook it is likely that errors have been made. If you notice any mistakes, or even just think some numbers seem off, please contact me at spickett@buhockeyarchives.com so I can check and make corrections as needed.
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
Overview
Reporting Categories
Averaged Hockey
Yearly Hockey
Averaged Hockey %
Yearly Hockey %
Averaged Overall
Yearly Overall
Averaged Hockey % of Overall
Yearly Hockey % of Overall
Averaged Hockey Women % Men
Yearly Hockey Women % Men
Notes
 
 
Main menu