How to Calculate Standard Deviation of Cash Flows in Excel. When reviewing cash flow data for your small business, knowing the standard deviation can help you determine if the numbers are out of ...

1. Convert metrics data to percentages. Start by converting your variance data to percentage calculations to better fit your bull’s-eye chart, as follows. Divide the budget variance by the total ...