Hanratty Inc's stock and the stock market have generated the following returns over the past five years: Year 1: Hanratty 13% ; Market (rm) 9% /// Year 2: Hanratty 18% ; Market (rm) 15% /// Year 3: Hanratty -5%; Market (rm) -2% /// Year 4: Hanratty 23% ; Market (rm) 19% /// Year 5: Hanratty 6% ; Market (rm) 12%
Hello again :)
The problem is incomplete, is the question asking about the estimated Beta?
If yes, is it ok to answer in excel?
Yes, Excel is fine.
The question is: What is the estimated beta of Hanratty's stock?