Tottenham Hotspur plc Case
.pdf
keyboard_arrow_up
School
Brigham Young University *
*We aren’t endorsed by this school
Course
401
Subject
Finance
Date
Jan 9, 2024
Type
Pages
5
Uploaded by SuperHumanGiraffe808
1
Advanced Financial Management
Professor Chris Hair
13 December 2023
Tottenham Hotspur Case
1. Calculate the enterprise value and corresponding stock price of Tottenham using the method of
multiples. Use an EV/Revenue multiple and at least one other multiple. Be creative.
Using the method of multiples, we derived an
Enterprise Value of £129.11
and a
stock price of £12.16
.
Although we have seven given teams to use as comparables, we selected Newcastle United, Everton, and
Aston Villa considering their teams’ similarities in revenue and average points to Tottenham.
Additionally, these three teams were a part of the bottom three teams, which were “relegated” or sent to a
lower division, indicating far lower revenues than their competitors.
Using the provided information, we calculated the respective EV/Rev and EV/Avg Points multiples for
each comparable team because enterprise value tends to vary more with changes in revenue and average
points. We then took the average of all the EV/Rev and EV/Avg Points multiples to find those multiples
for Tottenham. EV/Rev was 1.9, and EV/Avg Points was 2.34. Using these multiples, we took the product
of EV/Rev and Tottenham’s revenue to get an enterprise value of £138.4 (1.9*74.7), as well as the product
of EV/Avg Points and Tottenham’s average points to get an enterprise value of £119.9 (2.34*50.9). We
then average these two enterprise values to get a singular
Enterprise Value of £129.11M.
To calculate the stock price, we used the formula EV = Equity + Debt - Excess Cash and the values of
2007 debt (£43.1) and excess cash of £26.9 to back out equity.
Equity = £112.93M
(129.11-43.1+26.9).
We divided the outstanding shares by 9.29 to arrive at a
stock price of £12.16
.
2. Calculate the enterprise value and corresponding stock price of Tottenham using a DCF
approach.
Leveraging Table A's financial data, we computed Tottenham Hotspur plc's WACC. The Asset Beta (Ba)
was determined as 1.072 using the equation
Ba = Be*(E/V) + Bd(D/V)
. Applying the cost of capital
equation
Ra = Rf + Ba(MRP
), we arrived at a
WACC of 9.54%
, where Ra is the required rate of return.
For NOPAT, we utilized the equation
EBIT * (1 - Tax Rate)
. Starting at £2.2M in 2007, depreciation
grew at 4% annually. Capital Expenditure (CAPEX) for 2007 stood at £3.3M, with an expected 4%
growth rate. Predicting Net Working Capital (NWC) using the percentage of sales method, we found the
initial NWC to be -£1.53M in year 0, factoring in a 9% revenue growth rate.
Investment in working capital (
△
NWC) was calculated through the formula
NWC(year t-1) -
NWC(year t)
for 2007-2020. Free Cash Flows for 2007-2020 were computed as
Net Profit +
Depreciation – CAPEX –
△
NWC
. Terminal Value in 2020, with a 4% growth rate, was calculated using
the equation
[Cash Flows (year 2020) * (1 + Terminal Growth Rate)] / (WACC - Terminal Growth
Rate)
to obtain £204.94M.
The Present Value (PV) of Free Cash Flows and Terminal Value was determined using the formula
Cash
Flows / (1 + WACC)^year
, resulting in an
Enterprise Value of £111.5M
. Adjusting for Debt and Excess
Cash,
Equity Value was £95.3M.
Dividing by the 9.29M outstanding shares, we obtained a
stock price
of £10.26
(£16.41).
3. Calculate the enterprise value and corresponding stock price of Tottenham with the new stadium.
Should they build the new stadium?
Assumptions:
▪
Attendance revenue experiences a 40% increase starting in year 3
▪
Sponsorship increases by 20% starting year 3
▪
Stadium operating expenses increases by 14% starting year 3
The CAPEX outlay for the new stadium totals £125M over the initial two years. We have retained the
initial maintenance CAPEX from the original DCF in our financial considerations. Commencing in the
third year, a
£25M depreciation expense
on the stadium contract is incurred, following a 10-year
straight-line depreciation schedule. The Free Cash Flow (FCF) computation involves aggregating the
original depreciation on maintenance CAPEX and the new depreciation related to the stadium. NWC
changes specific to the new stadium have been factored in, utilizing a methodology aligned with the
original DCF but adjusted to accommodate the anticipated revenue surge.
The Terminal Value, estimated at
£686.6M,
using the above formula mentioned in Question 2. The
present value of the Terminal Value was determined using the same methodology applied to other cash
flows.
The
Enterprise value stands at £150.85M
, translating to a revised
equity value of £134.66M
and,
consequently, a recalibrated
stock price of £14.50
. This marks a substantial increase of £4.24, attributed
to the enhanced seating capacity of the new stadium leading to augmented attendance and sponsorship
revenues. Constructing the new stadium emerges as a strategic move to optimize shareholder profit, and
we strongly recommend Daniel Levy to approve this project.
4. Calculate the enterprise value and corresponding stock price of Tottenham if they sign the new
player. Should Tottenham sign the new player?
Assumptions:
▪
Revenue growth attributable to a new player of 5.59%
until the player contract ended in 2018
▪
A player transfer fee of £20M
▪
Player salary was 2.6M in 2008 and grew by 10%
until 2018
▪
Used the same method to adjust NWC as described in question 2, but used new forecasted
revenue values
To derive a revenue growth projection contingent on Tottenham's acquisition of a new player, we
conducted a regression analysis correlating average net goals with average net points. Emphasizing
prudence, we utilized the more conservative 95th percentile values, yielding the equation y = 0.63x +
50.54. This choice was motivated by a comprehensive evaluation of Tottenham's recent performance
relative to competitors. Moreover, a cautious approach was taken due to a perceived optimism bias in
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Questions
Using the free cash flow valuation model to price an IPO Personal Finance Problem Assume that you have an opportunity to buy the stock of CoolTech, Inc., an IPO being offered for $22.92 per share. Although you are very much interested in owning
the company, you are concerned about whether it is fairly priced. To determine the value of the shares, you have decided to apply the free cash flow valuation model to the firm's financial data that you've accumulated from a variety of data sources. The
key values you have compiled are summarized in the following table, E
a. Use the free cash flow valuation model to estimate CoolTech's common stock value per share.
b. Judging by your finding in part a and the stock's offering price, should you buy the stock?
c. On further analysis, you find that the growth rate in FCF beyond 2023 will be 7% rather than 6%. What effect would this finding have on your responses in parts a and b?
a. The value of CoolTech's entire company is $|
(Round to the nearest…
arrow_forward
Using the free cash flow valuation model to price an IPO Personal Finance Problem Assume that you have an opportunity to buy the stock of CoolTech, Inc., an IPO being offered for
$7.41 per share. Although you are very much interested in owning the company, you are concerned about whether it is fairly priced. To determine the value of the shares, you have decided
to apply the free cash flow valuation model to the firm's financial data that you've accumulated from a variety of data sources. The key values you have compiled are summarized in the
following table, E
a. Use the free cash flow valuation model to estimate CoolTech's common stock value per share.
b. Judging by your finding in part a and the stock's offering price, should you buy the stock?
c. On further analysis, you find that the growth rate in FCF beyond year 4 will be 4% rather than 3%. What effect would this finding have on your responses in parts a and b?
a. The value of CoolTech's entire company is $. (Round to the…
arrow_forward
Using the free cash flow valuation model to price an IPO Personal Finance Problem Assume that you have an opportunity to buy the stock of CoolTech, Inc., an IPO being offered
for $4.61 per share. Although you are very much interested in owning the company, you are concerned about whether it is fairly priced. To determine the value of the shares, you have
decided to apply the free cash flow valuation model to the firm's financial data that you've accumulated from a variety of data sources. The key values you have compiled are
summarized in the following table,
a. Use the free cash flow valuation model to estimate CoolTech's common stock value per share.
b. Judging by your finding in part a and the stock's offering price, should you buy the stock?
c. On further analysis, you find that the growth rate in FCF beyond year 4 will be 3% rather than 2%. What effect would this finding have on your responses in parts a and b?
a. The value of CoolTech's entire company is $
Data table
(Click on…
arrow_forward
Looking for Solution for Question 8:
Your are a finance executive given the job of discussing attractiveness of two acquisition targets. Pick Microsoft and Verizon.
Below are the hypothetical average percentage returns for the two companies- Microsoft and Verizon
MSFT: 4,2,4,6,2,6,4,7,4,1,4,2,6 Verizon: 5,3,3,7,1,8,2,9,1,6,6,3,8
Market: 4,6,3,7,2,9,4,7,1,3,2,8,2
2. Find the standard deviation of the returns for the two companies.
3. Find the standard deviation for the portfolio of the two companies. (With stocks weights being: 70% msft and 30 % Verizon)
4. Calculate Beta for the two companies. (As demonstrated in the class: Run a regression or use the formula using covariance of each stock with the market divided by the variance of market).
5. Which of the companies is more risky in terms of Beta.
6. Which of the companies is more risky in terms of standard deviation?
7. Does portfolio of the two companies show lower standard deviation than individual stock company standard…
arrow_forward
QUESTION 3
Warwickshire plc is appraising a new project in a different line of business to its core operations. It has identified a suitable company,
Nottingham plc, to use as a proxy. Details are as follows:
Equity beta of Nottingham 1.250
Market value of Nottingham's debt: £39m
Market value of Nottingham's equity: £45m
Corporation Tax rate (both companies): 30%
If Warwickshire is finance by £188m of equity and £95m of debt what would a suitable proxy equity beta for Warwickshire plc to use in the
appraisal process?
OA. 1.053
О в. 1.182
O.0.778
OD.1.486
O E. 1.504
arrow_forward
a. Based on the information in the picture, calculate, using market values, Globex PLC weighted average cost of capital. Please show workings
b. Criticallly discuss any two assumptions underpinning the post tax version of Modigliani & Miller model of the relationship between WACC and gearing
arrow_forward
Please show the solution in excel format :) thank you
arrow_forward
ABC
2. You examine information from the following firms
Firm
Net Income
Sales
Assets
Equity
I
A9
9
110
98
50
B
58
642
660
322
C
137
1210
1408
761
Use the DuPont Method to answer the following questions.
• Which firm is the most profitable?
•
Which firm is the most efficient?
Which firm uses the most leverage?
Which firm has the safest ROE?
D
358
3698
4002
1989
I
arrow_forward
Solve every question
arrow_forward
THIS is my assignment
arrow_forward
Peddai MALING
Heading 2
Subtitle Su
According to the theories, companies opt their capital structures to maximize the value of firm.
Discuss on the different capital structure theories that will enable the optimal capital in a business.
20°C Mostly sunny
C
F
arrow_forward
Please try to solve it in 30 minute
arrow_forward
Q4b
Please assist to answer Q4b
arrow_forward
Problem 1
It is now 2024. You have been assigned as a financial advisor of a Philippine start-up company They assigned you to value its
existing business had they exited the market 6 years ago, meaning in 2018. Details of the company are as follows:
Futher assume that the company will nat exist beyond 2023, meaning the going concem principle will not apply.
Also assume that the client wants you to use the dividend discount model for this project.
2018
6,458,000.0
2019
7,412,000.0
2020
8,126,000.0
2022
8,941,000.0 9.457.000.0
42.0%
28.0%
30.0%
2021
2023
Sales
Variable expenses
Fixed expenses
Tax Rate
10,025,000.0
40.0%
30.0%
44.0%
30.0%
30.0%
38.0%
40.0%
41.0%
30.0%
29.0%
21.0%
31.0%
25.0%
24.0%
25.0%
After conducting a financial due diligence, you found that:
1.) 2019 sales are inclusive of a 250.000 sales invoice that were in transit as of EOY 2019, thus delivered to the client on 2020, with terms of FOB Shipping Point.
2.) 2020 sales excluded a contract signed for senvices worth…
arrow_forward
A
Beta 1.10
Market Capitalization = 122.548B
Book Value of Debt = 93.21B
Bond Price = 103.10
Interest Rate = 2.75%
Maturity = 20 years
Therefore - PV = -1,031.00; FV = 1,000; PMT = 27.50; N = 20; CPT I = 2.55%
Tax rate 21%
Current One Year Treasury Bill Rate (Risk-free Rate) = 5%
Market Return: Estimated at 8%
Step 1
Calculate the WACC for Deere and Company (DE) given:
Step 2
Step 3
Step 4
Search
What are the weightings for Equity and Debt?
What is the Cost of Equity?
What is the After-Tax Cost of Debt?
What is the WACC?
arrow_forward
Need help with this question
arrow_forward
Solve and show solution. Do not use excel cell in the solution
arrow_forward
What's the equation in excel and answer?
arrow_forward
Need correct answer the question
arrow_forward
Please send complete handwritten solution for Q7
only handwritten solution accepted
arrow_forward
Full detailed solution
arrow_forward
Question 2
Expansion Sdn Bhd is considering launching a new product to boost its performance in the coming
year. You are given the following data:
Without new product line
With new product line
Current earnings per share (EPS)
EPS growth
Dividend payout ratio
Cost of equity
RM3
RM3
6%
70%
8%
30%
10%
Required:
Should Expansion Introduce the new product? Support your answer by computing the share price of
Expansion before and after introducing the new product.
arrow_forward
Return on Investment for Innovative Companies The Boston Consulting Group identifiedthe world’s 50 most innovative companies. The rankings are based on a survey of senior executives,as well as financial metrics such as total shareholder return (a measure that incorporates stock pricechange and dividends). The top five companies in the most recent rankings were Apple, Google,Tesla, Microsoft, and Amazon.Required What are the issues to consider in calculating the return on investment (ROI), residual income(RI), and economic value added (EVA®) for a highly innovative company?
arrow_forward
Provide Correct Solution please
arrow_forward
Answer of the question immediately
arrow_forward
Briefly describe your perception of Apple's liquidity and profitability based on your calculations and review of these ratios and results.
arrow_forward
Question 4An investor is considering providing Howard with $50,000 as an initial investment.a. Explain five (5) risks associated with making such an investment for the Investor.b. Explain five (5) risks associated with taking such an investment for Howard.c. Do you believe that Howard’s business has high growth potential? Provide a detailed justification for your answer.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781285867977
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Related Questions
- Using the free cash flow valuation model to price an IPO Personal Finance Problem Assume that you have an opportunity to buy the stock of CoolTech, Inc., an IPO being offered for $22.92 per share. Although you are very much interested in owning the company, you are concerned about whether it is fairly priced. To determine the value of the shares, you have decided to apply the free cash flow valuation model to the firm's financial data that you've accumulated from a variety of data sources. The key values you have compiled are summarized in the following table, E a. Use the free cash flow valuation model to estimate CoolTech's common stock value per share. b. Judging by your finding in part a and the stock's offering price, should you buy the stock? c. On further analysis, you find that the growth rate in FCF beyond 2023 will be 7% rather than 6%. What effect would this finding have on your responses in parts a and b? a. The value of CoolTech's entire company is $| (Round to the nearest…arrow_forwardUsing the free cash flow valuation model to price an IPO Personal Finance Problem Assume that you have an opportunity to buy the stock of CoolTech, Inc., an IPO being offered for $7.41 per share. Although you are very much interested in owning the company, you are concerned about whether it is fairly priced. To determine the value of the shares, you have decided to apply the free cash flow valuation model to the firm's financial data that you've accumulated from a variety of data sources. The key values you have compiled are summarized in the following table, E a. Use the free cash flow valuation model to estimate CoolTech's common stock value per share. b. Judging by your finding in part a and the stock's offering price, should you buy the stock? c. On further analysis, you find that the growth rate in FCF beyond year 4 will be 4% rather than 3%. What effect would this finding have on your responses in parts a and b? a. The value of CoolTech's entire company is $. (Round to the…arrow_forwardUsing the free cash flow valuation model to price an IPO Personal Finance Problem Assume that you have an opportunity to buy the stock of CoolTech, Inc., an IPO being offered for $4.61 per share. Although you are very much interested in owning the company, you are concerned about whether it is fairly priced. To determine the value of the shares, you have decided to apply the free cash flow valuation model to the firm's financial data that you've accumulated from a variety of data sources. The key values you have compiled are summarized in the following table, a. Use the free cash flow valuation model to estimate CoolTech's common stock value per share. b. Judging by your finding in part a and the stock's offering price, should you buy the stock? c. On further analysis, you find that the growth rate in FCF beyond year 4 will be 3% rather than 2%. What effect would this finding have on your responses in parts a and b? a. The value of CoolTech's entire company is $ Data table (Click on…arrow_forward
- Looking for Solution for Question 8: Your are a finance executive given the job of discussing attractiveness of two acquisition targets. Pick Microsoft and Verizon. Below are the hypothetical average percentage returns for the two companies- Microsoft and Verizon MSFT: 4,2,4,6,2,6,4,7,4,1,4,2,6 Verizon: 5,3,3,7,1,8,2,9,1,6,6,3,8 Market: 4,6,3,7,2,9,4,7,1,3,2,8,2 2. Find the standard deviation of the returns for the two companies. 3. Find the standard deviation for the portfolio of the two companies. (With stocks weights being: 70% msft and 30 % Verizon) 4. Calculate Beta for the two companies. (As demonstrated in the class: Run a regression or use the formula using covariance of each stock with the market divided by the variance of market). 5. Which of the companies is more risky in terms of Beta. 6. Which of the companies is more risky in terms of standard deviation? 7. Does portfolio of the two companies show lower standard deviation than individual stock company standard…arrow_forwardQUESTION 3 Warwickshire plc is appraising a new project in a different line of business to its core operations. It has identified a suitable company, Nottingham plc, to use as a proxy. Details are as follows: Equity beta of Nottingham 1.250 Market value of Nottingham's debt: £39m Market value of Nottingham's equity: £45m Corporation Tax rate (both companies): 30% If Warwickshire is finance by £188m of equity and £95m of debt what would a suitable proxy equity beta for Warwickshire plc to use in the appraisal process? OA. 1.053 О в. 1.182 O.0.778 OD.1.486 O E. 1.504arrow_forwarda. Based on the information in the picture, calculate, using market values, Globex PLC weighted average cost of capital. Please show workings b. Criticallly discuss any two assumptions underpinning the post tax version of Modigliani & Miller model of the relationship between WACC and gearingarrow_forward
- Please show the solution in excel format :) thank youarrow_forwardABC 2. You examine information from the following firms Firm Net Income Sales Assets Equity I A9 9 110 98 50 B 58 642 660 322 C 137 1210 1408 761 Use the DuPont Method to answer the following questions. • Which firm is the most profitable? • Which firm is the most efficient? Which firm uses the most leverage? Which firm has the safest ROE? D 358 3698 4002 1989 Iarrow_forwardSolve every questionarrow_forward
- THIS is my assignmentarrow_forwardPeddai MALING Heading 2 Subtitle Su According to the theories, companies opt their capital structures to maximize the value of firm. Discuss on the different capital structure theories that will enable the optimal capital in a business. 20°C Mostly sunny C Farrow_forwardPlease try to solve it in 30 minutearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781285867977Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage Learning
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781285867977
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning