Calculate the weighted average of interest rates in Microsoft Excel to compute the most accurate average interest rate among a group of lenders who received different rates.

How to Do Averages With Percentages in Excel. Averages are typically computed as the sum of values divided by the number of data points. However, averages are also calculable from percentages.

Weighted average is a powerful tool for an investor. It can be used to evaluate the performance of a portfolio. It can help us better understand how.

With this weighted average, we can now calculate a different and more accurate EPS of $0.80 per share. Bear in mind that this is a simplified example, and a company's number of outstanding shares ...

Weighted average life is the average number of years for which each dollar of unpaid principal on a loan or mortgage remains outstanding.

By calculating a company's weighted average number of outstanding shares, we can get a more accurate picture of its earnings.