Learn how to calculate Weighted Average in Excel with percentages using the SUM function and the SUMPRODUCT function.

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.

If your business makes investments in equipment and employee benefit contributions, you may need to track the average annual rate of return over a span of time for financial reporting obligations.