From the course: Excel for Investment Professionals
Unlock the full course today
Join today to access over 23,400 courses taught by industry experts.
Computing beta of an asset - Microsoft Excel Tutorial
From the course: Excel for Investment Professionals
Computing beta of an asset
- [Instructor] Often times, when you're evaluating a portfolio, you may need to go through and determine what the beta is on a particular asset within that portfolio. Beta helps us to determine how risky a particular stock is in relation to the market overall, which in turn helps us determine whether or not that stock belongs in our portfolio. It's a good alternative method versus correlation or covariance, which can be computationally intensive. Let me show you how to determine your beta in Excel and I'm actually going to show you two different methods. I'm in the zero, three, zero, seven begin Excel file. Now what we've got here are two different assets and their respective returns for a year on a month-by-month basis. We've also got returns for the market overall. So the first I'm going to need to do in order to calculate my beta is to go through and determine the variance of the market overall. So I'm going to use the VAR dot S formula and now I need to determine the covariance…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
Computing expected returns on a stock2m 55s
-
(Locked)
Using probability to calculate stock returns3m 35s
-
(Locked)
Computing arithmetic and geometric returns in a portfolio3m 19s
-
(Locked)
Computing standard deviation and variance of an asset4m 41s
-
(Locked)
Finding covariances and correlations5m 6s
-
(Locked)
Computing standard deviation and variance of a portfolio3m 12s
-
(Locked)
Computing beta of an asset4m 33s
-
(Locked)
Computing risk for a portfolio with many stocks3m 33s
-
-
-
-