Perform a sensitivity analysis. (in excel please) Here is the information you will need for your analysis:
2016 Average attendance: 16,500
2016 Average ticket prices: $56
2016 Average spending per fan per game: $25
Home games per year : 41
The attendance will decline to an average of 15,000 per year, and ticket prices as well as fan spending are expected to remain the stagnant at the 2016 average. The discount during this time period is 7%. Additionally, the expenses per home game are expected to be $1,170,000 and increase by 0.25% each year.