|
Featured Tutorial
Featured Macro
Excel Finance Class 104: Expected Return & Standard Deviation For 1 Stock -- Estimating Future
Download Excel workbook http://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to calculate an estimate of future returns by calculating Expected Returns. See how to do this long hand and with a single cell formula using SUMPRODUCT function. See how to calculate Standard Deviation based on the Expected Value and the estimated returns for the stock given various probabilities of states of economy.
See how to calculate an estimate of future returns by calculating Expected Returns. See how to do this long hand and with a single cell formula using SUMPRODUCT function. See how to calculate Standard Deviation based on the Expected Value and the estimated returns for the stock given various probabilities of states of economy.