### Perform multiple regression with real financial data

Assignment Help Financial Management
##### Reference no: EM13544493

The objectives of this exercise:

1. To perform multiple regression with real financial data.

2. To estimate the Fama - French 3-factor model for a list of twenty stocks and interpret the regression output.

3. To discern whether individual stocks are small, mid or large cap and value, neutral or growth.

Learning Outcomes:

Students should be able to:

1. Perform Ordinary Least Squares regression to estimate the Fama - French 3-factor model.

2. Perform proper inference with correct interpretation of t-statistics.

3. Discern whether a stock return significantly loads on one or more of the three factors.

4. Tabulate regression results and discuss empirical findings.

Guidelines:

1. You will be assigned twenty (20) stocks from the current S&P 500 index. You must use the same 20 stocks (or, more precisely, the ticker symbols) you used for Project 1. The last month of return data should be September 2014.You must use end-of-month data!

2. You must estimate the Fama and French 3-factor model. Thirty-six months of the three factors along with the risk-free-rate in decimal form will be provided in the accompanying Excel spreadsheet. Use these factors and the risk-free rate provided to you. The factors are MRP (BKM call this RM), SMB and HML. Note, you need excess returns for your stocks. Estimating the Fama and French 3-factor model requires the use of regression software. Answer the following question:

a.How, exactly, do Fama and French construct their SMB and HML factors?

3. For each firm, perform a multiple regression to estimate the parameters in equation (10.11) of BKM 9thed. Then complete a Table:

Note that t(Alpha) above means the t-statistic for the alpha estimate and that t(Beta-MRP) means the t-statistic for the beta coefficient estimated for the MRP factor, etc.

4. Then, using the results from your multiple regressions, identify the "style" for each of your 20 firms. In your write-up, be sure to explain how you identified the various styles. Styles include Large-Neutral, Large-Value, Large-Growth, Mid-Neutral, Mid -Value, Mid-Growth, Small-Neutral, Small-Value, Small-Growth:

Output:

You must submit a brief write-up of your results. Your paper should be detailed enough so that someone else could pick up your paper and replicate your results. So, you will need a brief introduction describing your data sources, how you manipulated the data, how you calculated the Fama-French betas, 2 Tables, and a brief summary and discussion of your findings. In total, you must submit:

1. Your write-up as a Word file.

2. An Excel spreadsheet (one sheet) containing the two Tables detailed above.

3. Another Excel spreadsheet detailing how, exactly, you calculated the results in your Table (i.e., replicate the detailed findings for your stocks). Note that the Excel spreadsheets in points 2 and 3 should be in one file with two different labeled worksheet tabs. Alternatively, you may use 20 Excel sheets named with the ticker symbol if you wish to combine the date, ticker symbol, adjusted closing prices, and calculations and/or regressions separately for each of your 20 companies.

#### Questions Cloud

 Licensing patented technology to a foreign competitor : "Licensing patented technology to a foreign competitor is likely to reduce or eliminate the firm's competitive advantage." True or false? Write a paragraph discussing this statement. Determine the minimum distance from the diversion that a : A temporary diversion has been constructed on a highway of +4 percent gradient due to major repairs that are being undertaken on a bridge. The maximum speed allowed on the diversion is 10 mph Compute the true static height : A Kennedy half dollar has a mass of 1.150 X 10-2 Kg. The coins is a mixture of silver and cooper, and in water weights 0.1011 N. What is the mass of the silver? What is the concentration of bod in the jackson river before : The James Rives flows in from the East at 320 m^3/min and joins the Jackson River flowing at 605 m^3/min just outside the town of Charlotte, NC. The concentration of BOD in the James River is 14 mg/L Perform multiple regression with real financial data : Perform multiple regression with real financial data - estimate the Fama - French 3-factor model for a list of twenty stocks and interpret the regression output. Determine the magnitude direction and location on the beam : A first order reaction occurs in a PFR at the rate of 2.1 hr^-1. The reactor volume is 1400L and flow is 15 gpm. If the influent concentration is 200 mg/L, then what is the effluent concentration? Calculate the mass of the green house gas and ozone : Calculate the mass of the green house gas and ozone depleting substance CFC-11 (chemical Formula = CCl3F) in the atmosphere. Use units of GtC (giga tonnes carbon). Production of this substance is now banned and mixing ratios are slowly decreasing wit.. Determine if the as-drawn wire will break during the process : A 0.02wt% C steel is to be carburized at 1200°C in 4 hrs with a point 0.6mm beneath the surface reaching 0.45wt%C. calculate the carbon content required at the surface of the steel. Downstream response to imposed flow transformation : Write a paragraph ( 1 paragraph for i, ii, iii, & iv together) summarizing the following Holistic Methodologies Methods used to analyze environmental flow requirements.)

### Write a Review

#### Research evaluate and discuss the similarities and

transformational versus transactional leadershipresearch evaluate and discuss the similarities and differences between

#### Find an existing budget from a published source

Using the existing budget, create a new budget for the next fiscal year. Set out the details of all the assumptions you needed in order to build this budget.

#### Calculate the annualized forward premium

Calculate the annualized forward premium or discount on six-month forward yen and calculate the profitability of each of BLP's five subsidiaries.

#### Portfolio comprising of a \$3 million

Consider a portfolio comprising of a \$3 million investment in Ariel Ltd and a \$5 million investment in in Snowy Ltd. Assume that the standard deviations of the returns for the shares are 0.4 and 0.25 respectively

#### State what will be the dollar value of the management team''s

What will be the dollar value of the management team's original \$2 million equity investment at the time of the liquidity event?

#### Stock analysis - calculate the required rate of return

The purpose of this project is to familiarize you with the stock market - calculate the required rate of return on your stock using CAPM:BAD 350- Managerial Finance

#### Explain what was the original annual rate of return

What was the original annual rate of return needed to reach your goal when you started the fund two years ago? With only \$140,000 in the fund and 10 years remaining until your first child starts college, what annual rate of return would the fund ha..

#### Top gun records and several movie studios have decided to

top gun records and several movie studios have decided to sign a revenue-sharing contract for dvds. each dvd costs the

#### The discussion board db is part of the core of online

the discussion board db is part of the core of online learning. classroom discussion in an online environment requires

#### You have been provided with the accounts of tulip

your organization has a canteen tulip refractory serving hot meals snacks and refreshments during the working day. at

#### Question 1a- wildcat company stock is trading for 80 per

question 1a- wildcat company stock is trading for 80 per share. the stock is expected to have a year end dividend of 4

#### What break-even resale price in three years

What break-even resale price in three years will make you indifferent between buying and leasing?