1] Using Data Analysis Tool Pack In this method, we will use the Data Analysis Tool Pack in Excel to calculate the moving average. MS Excel comes with a tool to calculate simple moving averages ...

In Excel, there are two ways of calculating the weighted average with percentages: using the SUM function and using the SUMPRODUCT function. Let us have a look at these 2 methods in detail.

To calculate this weighted average, first input the two values for the number of shares outstanding into adjacent cells. In our example, during January, there were 150,000 shares, so this value is ...

For aggregation, use SUM for rolling totals or replace it with AVERAGE for moving averages. This flexibility ensures that the function can be tailored to a wide range of analytical needs.

The concept of using a moving average is designed to give more weight for newer data points and less for older ones. The weights decline exponentially as the data points get older.

Here’s the formula to calculate cost of equity using this method: For example, if each share of Company X trades for $50 and produces a $1 annual dividend, it has a dividend yield of 2%.