Excel Forum

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.

Got a Question? Ask it Here in the Forum.