Understanding STDEV Add together all the cash flows you have put in the spreadsheet to calculate a total. Divide the total by the number of historical entries to calculate the mean average cash flow.

But first, here's a look at the formula for calculating annualized volatility. Annualized volatility = standard deviation (volatility) multiplied by the square root of the periods in the year.