Calculating S&P 500 Returns, Bond Returns, and Treasury Bill Returns 1928-2019 in Excel
2.2 هزار بار بازدید -
4 سال پیش
-
S&P 500 Returns, Bond Returns,
S&P 500 Returns, Bond Returns, and Treasury Bill Returns 1928-2019
This video has a dataset of the S&P 500 historical annual returns from 1928-2019. It also includes the 10 year treasury bonds and treasury bills. We take the data set and show the growth of $1,000 for the 92 year period.
We calculate the average return using the AVERAGE and AVERAGEIFS functions. We also calculate the compound average growth rate (CAGR) for all the years using the RATE function. Risk is defined as the standard deviation of the annual returns and we use the STDEV.P function.
See the Excel Basics playlist: Data Analysis with Excel
Finally Learn
https://finallylearn.com
Subscribe to Finally Learn
@finallylearn
#jeffmankin #excelbasics #stockreturns
This video has a dataset of the S&P 500 historical annual returns from 1928-2019. It also includes the 10 year treasury bonds and treasury bills. We take the data set and show the growth of $1,000 for the 92 year period.
We calculate the average return using the AVERAGE and AVERAGEIFS functions. We also calculate the compound average growth rate (CAGR) for all the years using the RATE function. Risk is defined as the standard deviation of the annual returns and we use the STDEV.P function.
See the Excel Basics playlist: Data Analysis with Excel
Finally Learn
https://finallylearn.com
Subscribe to Finally Learn
@finallylearn
#jeffmankin #excelbasics #stockreturns
4 سال پیش
در تاریخ 1399/06/10 منتشر شده
است.
2,242
بـار بازدید شده