Required returns on exxon and american express

Reference no: EM13737174

It contains the (actual) monthly returns on EXXON and American Express over the past 5 years (2010-2014). It also has the corresponding returns on the S&P500 and the monthly risk-free rates. (Assume throughout that the S&P500 is the appropriate market index.) Also, note that the risk-free rate is listed in the month for which it is relevant. In other words, in the row Jan-10 are the returns for January 2010 and the risk-free rate that was known at the beginning of that month.

a. Estimate the betas of EXXON and American Express using the 5 years of monthly data (60 observations). (The easiest way is to use the =SLOPE function. This function returns the slope coefficient from a linear regression. Alternatively you can use the regression 3 package in the data analysis tool kit. Under the "Data" tab see Data Analysis/Regression.) Why are the numbers (slightly) different from those reported in Lecture 9?

b. Calculate the monthly returns of a portfolio constructed to have a beta = 1.0 from the returns on EXXON and American Express. Calculate the beta and alpha of this portfolio. To what extent does this represent a profit opportunity? (The easiest way is to use the =SLOPE and =INTERCEPT function. The INTERCEPT function returns the constant coefficient, i.e., intercept, from a linear regression. If you used the regression package, it returns the slope, intercept, and many other outputs.)

c. Based on the 5 years of data, what percentage of the (monthly) variance of EXXOM, American Express and the beta=1 portfolio is systematic? What percentage is idiosyncratic? (If you use the regression package, the output, specifically the R-squared of the regression, might be useful for answering this question. Otherwise you will need to calculate these quantities directly.)

d. Assuming the CAPM holds, using the beta estimates from above, and assuming an annual risk-free rate of 2% (rf = 2%), and an annual market risk premium of 8% (E[rM]- rf = 8%), what are the annual expected/required returns on EXXON and American Express?

Reference no: EM13737174

Questions Cloud

Emerging trends and information technology tools : There are many emerging trends and information technology (IT) tools used in health care, such as e-mail between the patient and provider, e-prescribing, and computerized physician order entry (CPOE). Complete the following for this Discussion Boa..

Compose descriptions of two fictional public organizations : Public organizations can be categorized into two basic categories: open and closed models of organization. Compose descriptions of two fictional public organizations that are structured around one being open and the other being closed. Briefly des..

Maximum price you can anticipate receiving for sale of bond : On Feb. 12, 2015, you buy a bond that pays a semi-annual coupon of $100 on Feb. 12 (including today) and Aug. 12 until the final coupon payment on Feb. 12, 2018. In addition, the bond will pay $10,000 on Feb. 12, 2018. What is the maximum price you c..

Evaluate the new employee training program : You were recently appointed as Training Director of your organization and have been instructed to review and evaluate the new employee training program for both virtual employees and those on location.

Required returns on exxon and american express : What are the annual expected/required returns on EXXON and American Express

Career development activities : Post your ideas for the top 3 career development activities that you think organizations should provide for their employees and address the following questions:

Effective supply chain design : Draft a memo explaining to your warehouse managers how effective supply chain design could help to enhance profitability and stakeholder value for the company, including the following

Find out concerning marketing of their products : If Exavier Candy Company were to go global what would they need to find out concerning marketing of their products

What is the real annual rate of return : Assume that a bundle of goods deemed representative of the cost of living as of Jan. 1, 1965 is valued as $100. Assume that a similar bundle of goods deemed representative of the cost of living as of Jan. 1, 2015 is $525. Using these bundles of goods..

User Account

All Pages