Hello, this is very explanative. Thanks. Can you also make a video on computing up capture and down capture vs benchmark for this fund over the same time horizon?
Hi Ric - when calculating the beta, why aren’t you using the excess returns above the risk-free rate for the portfolio and the benchmark as your inputs? Is it okay to just use the returns of those inputs without first calculating the excess returns?
Hi, the stock's beta is first estimated using the market index model, which simply regresses the stock return (or asset return) against the market index. It is true that the CAPM subtracts the risk free rate from the market expected return, then multiplies this by beta and adds in the risk free rate. However, the beta itself is estimated by directly regressing the asset return against the market return. Even if you did subtract the risk free rate, you'd get a similar beta estimate, however. I hope this helps. Thank you.
@@ricthomas6436Thanks Ric! So when calculating beta, I would regress the asset itself against the market return. Although not covered in this video, when calculating alpha, would I use the CAPM method of subtracting the risk-free rate from the market return and benchmark return before regressing the market return against the benchmark return? I’m struggling to distinguish when to subtract the risk-free rate from the market return and benchmark return and when not to. I’ve seen videos where they subtract the risk-free rate to calculate both beta and alpha other videos where they don’t. Thanks again for the help!
Ric, many thanks for the detailed explanations. I am trying to measure performance of my accounts as if they were hedge funds. I would love to have a copy of your spreadsheet to use your data sets in my spreadsheet to assure the numbers tie out. I'll send you a copy of my spreadsheet report format when done. (Sort of like turning in my homework.) Any chance I could download a copy?
Hello, why do you calculate the performance ratio with the portfolio return of the last month instead to use the mean of each month of the portfolio return? i saw 2 manners to calculate the performance ratio but the result is not the same... i don't really get it
Are you sure your calculating the column E correctly? If the portfolio is negative you just use this number rather than (Rp- MAR)? Say the portfolio was negative but the SP400 was positive wouldnt you do for example -2-5 = -7 ?
Ric please please please start a course in Udemy that summarizes all of your videos and starts from scratch. there are no videos on Udemy on Portfolio analysis like this. If anyone knows any course that does this in Excel please let me know.
Mr Thomas, I cannot thank you enough for this free content!
You're helping a lot of students and early professionals globally!
Thank you
Thank you so much Mr Thomas, can't express how useful your practical examples were for me !! Keep going, God Bless You
super Thomas
This is a great video thank you!
This was good. Thank you
Hello, this is very explanative. Thanks. Can you also make a video on computing up capture and down capture vs benchmark for this fund over the same time horizon?
Hi Ric - when calculating the beta, why aren’t you using the excess returns above the risk-free rate for the portfolio and the benchmark as your inputs? Is it okay to just use the returns of those inputs without first calculating the excess returns?
Hi, the stock's beta is first estimated using the market index model, which simply regresses the stock return (or asset return) against the market index. It is true that the CAPM subtracts the risk free rate from the market expected return, then multiplies this by beta and adds in the risk free rate. However, the beta itself is estimated by directly regressing the asset return against the market return. Even if you did subtract the risk free rate, you'd get a similar beta estimate, however. I hope this helps. Thank you.
@@ricthomas6436Thanks Ric! So when calculating beta, I would regress the asset itself against the market return. Although not covered in this video, when calculating alpha, would I use the CAPM method of subtracting the risk-free rate from the market return and benchmark return before regressing the market return against the benchmark return? I’m struggling to distinguish when to subtract the risk-free rate from the market return and benchmark return and when not to. I’ve seen videos where they subtract the risk-free rate to calculate both beta and alpha other videos where they don’t. Thanks again for the help!
Ric, many thanks for the detailed explanations. I am trying to measure performance of my accounts as if they were hedge funds. I would love to have a copy of your spreadsheet to use your data sets in my spreadsheet to assure the numbers tie out. I'll send you a copy of my spreadsheet report format when done. (Sort of like turning in my homework.) Any chance I could download a copy?
Pls share this excel sheet in description for better understanding.
Hello,
why do you calculate the performance ratio with the portfolio return of the last month instead to use the mean of each month of the portfolio return? i saw 2 manners to calculate the performance ratio but the result is not the same... i don't really get it
Are you sure your calculating the column E correctly? If the portfolio is negative you just use this number rather than (Rp- MAR)? Say the portfolio was negative but the SP400 was positive wouldnt you do for example -2-5 = -7 ?
Yes, that is correct. Column E is simply how much you outperformed or underperformed for the month.
Ric please please please start a course in Udemy that summarizes all of your videos and starts from scratch. there are no videos on Udemy on Portfolio analysis like this. If anyone knows any course that does this in Excel please let me know.
Thank you, I can look into that. Regards, RT