Go Back   The Finance Forums > Finance forums > Business Finance

Business Finance Discussions about business finance, such as accounts and accounting, business loans, taxes, and related business issues.

Thread Tools
Old 12-01-2015, 04:50 AM
Dawid.szutowski Dawid.szutowski is offline
Junior Member
Join Date: Dec 2015
Posts: 1
Default CAPM problem


I work on the daily data for public companies. I need to calculate daily expected returns for a company. For this purpose I use CAPM model.

The CAPM has such form: Ri - Rf = beta*(Rm-Rf)

Ri - return for a company (in my case the daily change of stock price)
Rf - risk free rate of return (in my case the return on 52 week t-bills divided by 365)
Rm - return of the market (in my case the daily change of the value of the main index)

I use 250 days estimation period. Therefore, I have all the data and need only to calculate the "beta".

I run the regression and I receive terrible R-square equalling 0,02.

Is there something I did wrong? Did you face similar problems? Should I apply any other model (I tried Fama and French 3 factor model and the results were similar)? Any suggestions?

Any help would be appreciated!
Reply With Quote

Old Sponsors
Old 12-25-2015, 09:58 PM
optionwarriors's Avatar
optionwarriors optionwarriors is offline
Junior Member
Join Date: Dec 2015
Posts: 3
Default Re: CAPM problem

Are you calculating the beta in excel? If so, are you running the regression for the individual stock versus the benchmark (S&P500)? (percent change versus percent change for 250 days)
Reply With Quote


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

» Boards

All times are GMT -4. The time now is 04:30 AM.

Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.