In: Finance
Returns for a firm’s stock and the S&P 500 index for the last four years are given in the table below. Estimate the firm’s equity beta coefficient. Please show work.
First row is individual stock returns
second row is SP500 returns
|
|||||||||||||
SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE
I HAVE TRIED TO PRESENT IT IN SIMPLE MANNER. DID NOT USE EXCEL FUNCTION IN FIRST IMAGE.
SECOND IMAGE USES STATISTICAL EXCEL FUNCTION FOR BETA