Question: I only need help to Estimate the equity beta only ! You don't need to compute any other things else. 2.1. Using monthly data for

I only need help to Estimate the equity beta only ! You don't need to compute any other things else.

2.1. Using monthly data for the period from 1/1/2013 to 1/1/2020, estimate equity beta for Facebook. Compare your estimate of Facebook's equity beta with the Facebook's beta provided by Yahoo Finance and comment on any differences. Guidelines: Go to Yahoo Finance (finance.yahoo.com/), under the "Markets Tab", you will find US Treasury Bonds Rates, then look for Treasury Yield 10 Years (listed symbol "TNX"). Then click on TNX/"Historical Data" and get monthly data (AdjClose) of TNX for the period from 1/1/2013 to 1/1/2020. Use this data series as the risk-free rate for this period. Go to Yahoo Finance (finance.yahoo.com/), then enter search term "Facebook" or symbol "FB", then click on "Historical Data" and get monthly prices (AdjClose) of Facebook for the period from 1/1/2013 to 1/1/2020. Then calculate Facebook's monthly return for this period. Go to Yahoo Finance (finance.yahoo.com/), then enter search term "S&P500", then click on "Historical Data" and get monthly data (AdjClose) of S&P for the period from 1/1/2013 to 1/1/2020. Please use this as the market index and then calculate monthly market return for this period. Use Excel to estimate Facebook's equity beta. You will need to report the summary output of the regression in the report

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

2.1 Using monthly data for the period from 1/1/2013 to 1/1/2020, estimate equity beta for Facebook. Compare your estimate of Facebooks equity beta with the Facebooks beta provided by Yahoo Finance...

Need help with this question . Question 2 2.1. Using monthly data for Meta since its IPO date to 31/12/2019, estimate equity beta for Meta. Compare your estimate of Meta's equity beta with ...

Case Questions: Recall from class that components (in the WACC formula) are based on the (long-term) target debt-equity ratio. Assumptions: The beta of debt (for both Midland and its divisions) is...

Informationsaboutpuma company Question 1: A: Voting Structure: calssesof shares Situation previous to the triggering transaction number of voting rights 466,125 ,Resulting situation after the...

Objective Estimate the risk parameters for your company and use these parameters to estimate costs of equity and capital for the firm. Key Steps 1. Looking at the stock price history of your company,...

the name of company is QUDS Phase II: Risk and Return (14 marks) Objective Estimate the risk parameters for your company and use these parameters to estimate costs of equity and capital for the firm....

Now you need to estimate FVW s cost of equity. Once again, the problem is that it is a private company, so its equity returns are not directly observable. This means that you cannot use OLS...

hapter 12 Estimating the Cost of Capital MISTAKE Changing the Index to Improve the Fit use regression analysis to estimate beta, it is assumed that a higher goodness of fit will lead se results. This...

For the purposes of this question, you should make the following assumptions (except where noted in the questions below): all tables provided D = 0.2 (both for Media General and the media companies...

The Healthy Food Company has been in business over several years. The company bought a building and, because only half of it was needed for operations, the remaining space was rented to another...

explain what type of monetary policy you would prefer in today's Turkish economy. Why? Evaluate the potential scenarios with reference to the last two decades of Turkish economy (including 2002)....

3. When I realized that I didn't have enough money for holiday gifts, I decided to overcome the ___ by taking an extra part-time job in December. a. charisma b. perception c. dissent d. deficit

Have you experienced Disney in some way such as TV programming, movies, parks and resorts, merchandise, or video games? How did this shape your view of Disney? Explain how you think Disney does in...

4. Give an example of how the consistency principle can be used to influence others.

6. Give an example of how the liking principle can be used to influence others.

5. Give an example of how the consensus principle can be used to influence others.