Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Part II : Calculations Question ] You need to use the ' TIFUL KM_ data. XIs' file to answer this question . The file lists

image text in transcribed
image text in transcribed
Part II : Calculations Question ] You need to use the ' TIFUL KM_ data. XIs' file to answer this question . The file lists the monthly prices and dividends of the Standard & Poor's 500 Depository Receipts ( SPY ). Tiffany , and Lockheed Martin . The file also includes the yields of Treasury bills . Compute the alpha and the beta coefficients of Tiffany and Lockheed Martin over the whole sample period . Interpret your results . Which stock has more systematic risk ? Note : I have computed for you the monthly return of the S&P , Tiffany and Lockheed . You need to compute excess returns for these assets to answer the question . Hint : You can use Google Sheets instead of Microsoft Excel to answer this question . Sheets have two built-in functions to estimate an alpha and a beta of a univariate regression : INTERCEPT and SLOPE , respectively . Alternatively , you can click on Add ons - > Manage Add-ons in the menu and install the XIMiner Analysis ToolPak , which replicates the Data Analysis Add- on in Excel . Use the " Linear Regression" tab and input the X range ( SPY ) , the * range ( Tiffany or Lockheed ) , and the output range ( click on a cell where you want the output to be written )

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Personal Financial Planning

Authors: Randy Billingsley, Lawrence J. Gitman, Michael D. Joehnk

14th edition

978-1305887725, 1305887727, 1305636619, 978-1305636613

More Books

Students also viewed these Finance questions

Question

List and briefly define the four main elements of a computer

Answered: 1 week ago