Business Finance - Economics Final Project Milestone Three: Presentation Draft Assignment

profilecoachmac5#
AdelphiUniversitybudgetspeadsheet.xlsx

Sheet1

Budget
Category Millions ($)
Revenue $33,890,080
Direct Costs $6,893,424
Gross Profit $26,996,656
Game Expenses (schedule 1) $1,409,410
Team Expenses (schedule 2) $9,265,335
Administrative Expenses (Schedule 3) $12,595,025
Debt Service (Schedule 4) $352,746
Total Expenses: $23,622,516
Operating Income: $3,374,140 (Gross Profit minus Total Expenses)
Sources of Revenue:
Ticket Revenue $9,500,362
Media Rights $359,212
Student Fees $4,168,990
Direct Institutional Support $3,139,280
Indirect Institutional Support $1,253,210
Guarantees $27,699
Contributions $9,497,166
NCAA Distributions $495,235
Conference Distributions $193,070
Program, Novelty, Parking and Concession Sales $817,619
Royalties, Licensing ,Advertisement and Sponsorships $2,422,996
Athletics Restricted Endowment and Investments Income $367,826
Other Operating Revenue $1,647,415
Assets $1 ,404,068
Direct Costs:
Fund Raising, Marketing and Promotion $2,741,149 $2,741,149
Indirect organizataion Support $1,253,208 $1,253,208
Other Operating Expenses $2,612,441 $2,612,441
Spirit Groups $286,626 $286,626
Schedule 1: Game Expenses:
Game related Expenses $450,515 $450,515
Athletic Facilities Debt Service $352,745 $352,745
Guarantees $606,150 $606,150
Total Game Expenses: $1,409,410
Schedule 2: Team Expenses:
Traveling expencess $3,611,050 $3,611,050
Medical Insurance and Expenses $119,554 $119,554
Athletic Student Aid $3,958,885 $3,958,885
Recruiting of players and staff $496,296 $496,296
Sports Equipment and Supplies $1,079,550 $1,079,550
Total Team Expenses: $9,265,335
Schedule 3: Administrative Expenses:
Direct Overhead/Adminstrative Expenses $883,877 $883,877
Memberships and Dues for different sport organizataion and bodies $95,063 $95,063
Salaries, Benefits and Bonuses for the staff $7,699,171 $7,699,171
Support Staff Compensation $3,602,914 $3,602,914
Severance Payments $314,000 $314,000
Total Admin. Expenses: $12,595,025
Schedule 4: Debt Service:
Debt Service, Proncipal and Interest $352,746
Total Debt Service: $352,746 $0