How to Calculate the Average Return for the Share of Stock in Excel Credit: Next, I need to fill in all the other cash flows I've received from my Microsoft investment.

How to Calculate the Decline in Sales by Percent for the Number of Years in Excel. When calculating a declining sales figure spanning multiple years, you need to calculate two percentages.

The following article will show you, step-by-step, how to calculate the historical variance of stock returns with a detailed example.