From the course: Excel for Investment Professionals
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Computing standard deviation and variance of a portfolio - Microsoft Excel Tutorial
From the course: Excel for Investment Professionals
Computing standard deviation and variance of a portfolio
- [Instructor] We've already seen how to calculate variance and standard deviation on a single asset, but most of the time we're interested in calculating variance and standard deviation on multiple assets, meaning on a portfolio that we're investing in. How do we do that? Let me show you. I'm in the zero three zero six begin Excel file. Now, in this case we've gone through and computed our covariances and our correlation for these two stocks, asset number one and asset number two, which have the returns that we see here. In order to get our portfolio variance though, we need to take into account the benefits that the diversification factor between these two stocks provides. So I'm going to need to go through and compute a few more things. I need to determine the arithmetic mean of each of these stocks. We've got it as 1.32 for asset number one. We are going to compute it briefly for asset number two. And that'll ensure that we have the correct covariance between our two assets. Now I…
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
-
-
-
-