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.

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

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 ...

To understand how it can do all these things, we need to know how to calculate a weighted average. So let's start with the nuts and bolts of the calculation and how you can use this metric in your ...

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.

Why it's useful Knowing the weighted average price you paid for each share of stock can help you determine how your investment is performing as a whole, relative to the current share price.

Here are the steps to calculate a weighted average trade price: List the various prices at which you bought the stock, along with the number of shares you acquired in each transaction.

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.