Reference no: EM131430896
Valuation Assignment - Introduction to the Company
A local Private Equity firm based in based in Amsterdam would like to make a move and acquire a significant stake in Walmart. Wal-Mart Stores, Inc. operates retail stores in various formats worldwide. It operates through three segments: Walmart U.S., Walmart International, and Sam's Club. It has come to the knowledge of management of the private equity firm that Walmart is in need of urgent capital to expand its line of products to meet increasing demand over the next decade.
Stock price performance for this company can be downloaded using Yahoo! Finance for free, so it is not provided on Blackboard. It is recommended that the student selects a relevant benchmark within the firm's home market with justification. However, you are free to choose among many available benchmark indices (S&P 500, Russel 3000, MSCI Index, etc.) but make sure you provide information used and your reasoning behind the choice.
- Show full spreadsheet computed regression output of company Beta as a measure of Market Risk
- Give full explanation of the source and justification of your assumed Risk-free rate used in CAPM or any other model chosen to compute the cost of Equity.
- In case you prefer to lever and re-lever the Beta of the company, show full calculation in your Notes within the Excel Sheet and details on comparable firms.
- Make sure you accurately and correctly compute your own WACC (Weighted Average Cost of Capital); no element of WACC estimation should be copied from the internet.
Attachment:- Assignment Files.rar
|
How many customers would be waiting in line
: You are planning employees for a bank. You plan for 5 tellers. Tellers take 8 minutes per customer with a standard deviation of 5 minutes. Customers will arrive one every 2 minutes according to an exponential distribution. On average, how many custom..
|
|
Write a solution trail for given problem
: Find a 99% confidence interval for the mean amount of time a grocery-store ham is smoked. Write a Solution Trail for this problem.
|
|
The theory of corporate social responsibility concerns
: The theory of corporate social responsibility concerns
|
|
Percentage of individuals
: Two heterozygote tongue rollers (dominant trait) have a child. What percentage of individuals would be predicted to be heterozygotes, homozygous dominant and homozygous recessive?
|
|
Compute your own weighted average cost of capital
: FIN-8 Valuation Assignment 2016-2017 - Introduction to the Company. Make sure you accurately and correctly compute your own WACC (Weighted Average Cost of Capital); no element of WACC estimation should be copied from the internet
|
|
Find a confidence interval for the mean amount of time
: Find a 95% confidence interval for the mean amount of time on this ride.- Find a 99% confidence interval for the mean amount of time on this ride.
|
|
Process of semi-conservative replication
: One strand of a single DNA helix is labeled red while the other strand of the same DNA helix is labeled blue. This double helix DNA is replicated through the process of semi-conservative replication.
|
|
What was the economic impact of subprime crisis
: What was the economic impact of Subprime crisis? What was the plan of Alan Greenspan,Chairman,Federal Reserve?Why he proposed it? Do you think the plan led to the Housing Crisis.
|
|
What is an anthropological concept
: The goal of this exercise is to observe a 'cultural scene' as an anthropologist would (i.e. based on everything you have learned in the course to-date). The student will analyze their observations in terms of themes from the subfield of cultural a..
|