What is the standard deviation of the equally weighted portfolio? (in Excel, Google Sheets)
If Stock Z has a standard deviation of returns of 19% and Stock Y has a standard deviation of returns equal to 15.23% and returns on the stocks are perfectly positively correlated, what is the standard deviation of the equally weighted portfolio?
=0.5*(Z)+0.5*(Y)
Видео What is the standard deviation of the equally weighted portfolio? (in Excel, Google Sheets) канала Booksmart Fin
=0.5*(Z)+0.5*(Y)
Видео What is the standard deviation of the equally weighted portfolio? (in Excel, Google Sheets) канала Booksmart Fin
Показать
Комментарии отсутствуют
Информация о видео
Другие видео канала
Geometric Mean Annual Return Practice Problem with Formula
Clean Coins with Toothpaste? MISTAKE
A company reported the following information… If the cash balance increased… what is the CFO?
What is the price of a 3-year zero-coupon bond with a par value of $1,000? Solution
How many shares must have been held in the fund? Net Asset Value (NAV)
How to find coupon payment amount and current face value of the TIPS bond
Calculating NPV by Hand
Value of a Cash Flow in a Specific Year (with TI BA II Plus)
How to Calculate the Alpha of a Stock
How to Find the Weights in Global Minimum Variance Portfolio (Easy Way)
Calculating Standard Deviations of Stocks on Google Sheets and Excel (Part 2 of 2)
Yield to Maturity Calculator on Google Sheets (Annual)
Easy Shortcut to Find PV of Multiple / Uneven Cash Flows Using NPV
How to Find EPS From EBIT
Annuities vs Perpetuities
Calculating Standard Deviations of Stocks by Hand (Part 1 of 2)
Changing the Number of Decimal Places on the HP 12c Platinum
PV of a Deferred Perpetuity
Compound Interest Formula (FV of a Single Cash Flow)
An Initial Injection of $150m Could Result in a Max Change in Money Supply of…
Finding Covariance from Standard Deviation and Correlation Coefficient