Question

In: Finance

You are working for the CFO of AT&T. You collect stock return data from 1995 to...

You are working for the CFO of AT&T. You collect stock return data from 1995 to 2016 (23 years of data): average return: 9.9%; standard deviation: 23.1%; market average excess return: 8.5%; market SD: 14.5%; average risk-free rate: 2.3%.

1. What was AT&T’s Sharpe ratio (the ratio of average excess return to standard deviation) over the period? What was the market’s Sharpe ratio?

2. What is the standard error of the sample average AT&T return? Provide a 95% and 99% confidence interval.

3. You also look at the AT&T beta which is 0.4. Is AT&T’s beta above or below average?

4. If, over the next week, the market goes up by 2%, what do you expect the AT&T stock return to be?

Solutions

Expert Solution

Answer to Question 1 :

AT&T's Sharpe ratio over the period is 32.9%

Market's Sharpe ratio - 42.76%

Answer to Question 2 :

Standard error of sample average - 4.8167

Answer to Question 3 :

AT&T's Beta is 0.4 is above the average Beta

Answer to Question 4 :

Expected stock return is 12.386%


Related Solutions

Suppose that you collect the following data from the imaginary country of Econoland. There is a...
Suppose that you collect the following data from the imaginary country of Econoland. There is a total population of 10,000. 3,000 are children under the age of 16, 1,000 people in the military, and no people in prison due to a recent reform of the criminal justice system. Of the remaining 6,000 people, 3,000 currently have a job, 1,000 are actively looking for a job, 1,000 would like a job but have given up looking, and 1,000 are retired and...
The company that you are working for as a CFO is experiencing poor profitability. This was...
The company that you are working for as a CFO is experiencing poor profitability. This was evident in the Rate of Return on Assets, which was only 4% compared to the average industry of 15%. What reasons that may stand behind this relatively low rate on Assets? And what Course of Action that you may suggest to the Board of Directors to improve this rate? In your opinion, how would this low income or return would affect the liquidity of...
You are studying the market value of homes in Katy. You collect data from the recent...
You are studying the market value of homes in Katy. You collect data from the recent sale of 30 single-family homes. The dataset includes the fair market value (in $ thousands), land area of the property (in acres), and age (in years) of the 30 homes. Develop a multilinear regression model to predict the fair market value based on land area of the property (in acres) and age, (in years). State the multiple regression equation. Interpret the meaning of the...
You are studying the market value of home in Houston. You collect data from the recent...
You are studying the market value of home in Houston. You collect data from the recent sale of 30 single family homes. The data is organized and stored in an Excel file. The dataset includes the fair market value (in $thousands), land area of the property in acres, and age, in years of the 30 homes. Develop a multilinear regression model to predict the fair market value based on land area of the property (in acres) and age, in years....
You are studying the market value of home in Houston. You collect data from the recent...
You are studying the market value of home in Houston. You collect data from the recent sale of 30 single family homes. The data is organized and stored in an Excel file. The dataset includes the fair market value (in $thousands), land area of the property in acres, and age, in years of the 30 homes. Develop a multilinear regression model to predict the fair market value based on land area of the property (in acres) and age, in years....
Using the data in the​ table, calculate the return for investing in the stock from January...
Using the data in the​ table, calculate the return for investing in the stock from January 1 to December 31. Prices are after the dividend has been paid. Date Price Dividend   Jan 1 $ 34.96 minus Feb 5 $ 30.19 $ 0.21 May 14 $ 28.61 $ 0.19 Aug 13 $ 32.06 $ 0.21 Nov 12 $ 37.48 $ 0.18 Dec 31 $ 42.57 minus Return for the entire period is nothing​%. ​(Round to two decimal​ places.
You are a lending officer working with a financial institution in Dubai. The CFO of a...
You are a lending officer working with a financial institution in Dubai. The CFO of a company, which manufactures custom car parts in Jebel Ali Industrial area, submits to you a loan application. The company, which started as a local car shop in Sharjah, has evolved into a regional product provider. The company is rated CCC and its bonds are trading at 9 per cent (the comparable government bond rate is equal to 4%). These rates are for a 1-year...
In this project, you will collect data from real world to construct a multiple regression model....
In this project, you will collect data from real world to construct a multiple regression model. The resulting model will be used for a prediction purpose. For example, suppose you are interested in “sales price of houses”. In a multiple regression model, this is called a “response variable”. There are many important factors that affect the prices of houses. Those factors include size (square feet), number of bedrooms, number of baths, age of the house, distance to a major grocery...
You are working for the CFO of a small manufacturing company and are thinking about investing...
You are working for the CFO of a small manufacturing company and are thinking about investing in new equipment. The cost of the project is 9,500 today and it pays of 15,000 in ten years. Your beta is 0.2 and the market risk premium is 5%. 1. What is the NPV of the project if the 10-year Treasury (risk-free) rate is 2.6%? 2. What is the NPV if the 10-year Treasury rate is 3.1%?
Suppose that you are the manager of a casino and you collect data on one of...
Suppose that you are the manager of a casino and you collect data on one of your roulette tables. You find that among the last 10,000 bets, there were only 350 bets for which a red or black number did not win. On average, you expect the proportion of winning bets for black or red to equal p=18/19. a) Compute a 95% confidence interval for the proportion of winning black or red bets. b) Conduct a two-sided hypothesis test (α=0.05)for...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT