please I need Tutor specialist in businees finance that can help me to solve my case study

1- Evaluate the economics of university athletics programs in general and that of sdsu (as discussed in the case)

2- Identify the revenue source to pay  for the costs of each component of the sdsu mission Valley Project. will they be sufficient to service the cost of each component of the Project?there is a two link that need to answer for each question and explain it one page for each question.  also, i send the pdg for the whole case study. I dont want any solution from course here please neither from google.

0.50
0.70
0.80
0.90
0.50
0.70
0.80
0.90
0.50
0.70
0.80
0.90
1.4
1.25
1.1
1.4
1.25
1.1
1.4
1.25
1.1
Row denotes Operating Margin (OM)
Column denotes Debt Service Multiple (DSM); Debt Payments= PP + Interest; DSM = Operating Income (OI)/Debt Payments
Operating Income, OI = DSMx$30m; $30m is annual debt service cost for Total Project.
Revenue = (DSMx30)/OM; cell entries are annual revenues in mill.
Excess/Profit = OMxRevenue – $30m; cell entries are annual excess/profit in mill.
Cell entries are estimated annual Ground Lease Revenues per unit (annual revenues/4600) based on
construction of 4600 units per plan.
e (OI)/Debt Payments
2010
Sum of Excess Transfers Back
Sum of Other Expenses
Sum of Medical
Sum of Competition Guarantees
Sum of Recruiting
Sum of Game Expenses and Travel
Sum of Coaches Compensation
Sum of Facilities and Equipment
Sum of Support and Admin Compensation w/Severance
Sum of Athletic Student Aid
Sum of Total Expenses
$
$
$
$
$
$
$
$
$
$
$
5,635,826
424,232
594,240
531,034
3,818,260
6,614,688
2,524,946
6,928,255
5,558,171
32,629,652
Sum of Other Revenue
Sum of Corporate Sponsorship, Advertising, Licensing
Sum of Donor Contributions
Sum of Competition Guarantees2
Sum of NCAA/Conference Distributions, Media Rights, and Post-Season Football
Sum of Ticket Sales
Sum of Institutional/Government Support
Sum of Student Fees
Sum of Total Revenues
$
$
$
$
$
$
$
$
$
1,023,453
4,219,691
3,233,772
384,803
3,711,758
3,042,365
6,745,994
10,220,740
32,582,576
Source: http://cafidatabase.knightcommission.org/, Knight Commission for InterCollegiate
Athleics
Operating Income
Operating Margin (%)
Donor Contributions/Sum of Total Revenues (%)
Sum of Institutional/Government Support/Sum of Total Revenues (%)
Student Fee Contribution = (Sum of Student Fees)/Sum of Total Revenues (%)
Expense and Revenue Data for San Diego State University Athletics, 2010 – 2019
2011
2012
2013
2014
2015
2016
$
$
$
$
$
$
$
$
$
$
$
5,693,859
691,551
757,666
419,641
3,715,485
7,860,939
4,862,762
6,559,722
5,492,606
36,054,231
$
$
$
$
$
$
$
$
$
$
$
5,897,007
827,171
1,100,097
459,622
4,839,865
8,421,907
4,504,544
6,724,043
6,242,998
39,017,254
$
$ 6,321,595
$
944,559
$ 1,173,118
$
536,224
$ 5,493,016
$ 9,175,084
$ 5,265,594
$ 7,172,794
$ 6,767,339
$ 42,849,323
$
$
$
$
$
$
$
$
$
$
$
6,816,853
813,274
856,233
525,717
5,344,048
9,307,221
5,892,886
8,202,022
7,305,139
45,063,393
$
$
$
$
$
$
$
$
$
$
$
6,494,761
929,767
1,257,733
596,500
5,078,781
9,766,098
12,748,151
8,996,712
7,739,406
53,607,909
$
$
$
$
$
$
$
$
$
$
$
7,716,121
844,421
987,944
579,815
6,628,660
9,868,942
11,277,022
9,254,442
8,128,168
55,285,535
$
$
$
$
$
$
$
$
$
2,043,532
4,053,464
11,089,506
1,106,773
4,826,895
3,941,409
8,410,650
9,729,474
45,201,703
$
$
$
$
$
$
$
$
$
1,703,384
4,217,893
3,923,059
1,440,300
4,884,353
4,955,141
7,256,395
9,622,766
38,003,291
$ 1,197,034
$ 4,654,625
$ 5,643,426
$
982,649
$ 3,803,828
$ 5,350,541
$ 7,860,022
$ 9,719,702
$ 39,211,827
$
$
$
$
$
$
$
$
$
1,320,373
4,152,595
9,581,991
1,414,200
5,236,740
6,768,575
8,507,764
9,995,951
46,978,189
$
$
$
$
$
$
$
$
$
1,435,826
4,282,598
8,071,494
1,246,000
5,207,163
4,793,777
13,818,160
10,156,727
49,011,745
$
$
$
$
$
$
$
$
$
1,741,802
4,405,285
10,388,209
1,423,000
6,459,217
5,850,716
15,647,711
10,635,088
56,551,028
letics, 2010 – 2019
2017
2018
2019
$
$
$
$
$
$
$
$
$
$
$
7,068,736
819,877
886,076
596,713
5,611,579
10,600,147
7,707,772
9,704,639
8,574,313
51,569,852
$
$
$
$
$
$
$
$
$
$
$
7,390,927
867,023
955,316
684,266
7,222,844
10,478,285
7,851,373
10,674,786
8,808,212
54,933,032
$
$
$
$
$
$
$
$
$
$
$
7,581,502
575,548
1,606,836
675,789
6,372,252
7,121,121
11,066,930
11,201,033
9,178,163
55,379,174
$
$
$
$
$
$
$
$
$
1,710,334
5,422,091
8,826,053
651,500
5,712,785
5,809,058
13,238,377
11,084,589
52,454,787
$
$
$
$
$
$
$
$
$
1,709,211
5,134,850
8,589,327
456,500
5,630,354
9,149,380
13,734,946
11,282,616
55,687,184
$
$
$
$
$
$
$
$
$
1,334,993
5,190,276
6,673,651
5,000
5,709,359
6,596,027
17,517,951
11,704,147
54,731,404
Average 2010- 2019