Question
This part of my question goes off the previous tottenham question that I had if you could answer this as part two of the question
This part of my question goes off the previous tottenham question that I had if you could answer this as part two of the question that would be very helpful.
For the new striker scenario, the problem indicates that the striker would be responsible for an increase in 12 goals per season, but how does this translate into new revenue? As this calculation is a little beyond the scope of this course, I am providing the attached calculation of incremental player revenue that you can use. It uses base line revenue to calculate striker incremental revenue.
It assumes that those 12 goals translate into a 25% increase in revenue, but that 25% is limited by the 20% that the new striker is expected to be injured and is limited by the 25% of the revenue that can be leveraged in the old stadium. Accordingly, you may use the following numbers from the attached spreadsheet for the new striker incremental revenue. Year 1-4.04 2-4.40 3-4.80 4-5.23 5-5.70 6-6.21 7-6.77 8-7.38 9-8.05 10-8.77 You will have to adjust this spreadsheet to calculate the incremental revenue in the striker and stadium scenario to reflect the fact that the strikers value can be fully leveraged in a new stadium.
Year | ||||||||||||
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | |||
Base revenue | 80.77 | 88.04 | 95.95 | 104.59 | 114.01 | 124.27 | 135.46 | 147.65 | 160.93 | 175.42 | ||
Player's time | 80% | 80% | 80% | 80% | 80% | 80% | 80% | 80% | 80% | 80% | ||
Revenue Increase | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | ||
Max benefit old stadium | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | 25% | ||
Factor | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | ||
Increase Revenue | 4.04 | 4.40 | 4.80 | 5.23 | 5.70 | 6.21 | 6.77 | 7.38 | 8.05 | 8.77 | ||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started