Weighted Average in excel is calculated when we assign each data set with some kind of weights like weightage in statistics or portfolios we use weighted average to calculate more robust and impact observations and calculations the formula for weighted average is very simple which is w1x1w2x2wnxn w1w2wn where w is the weight assigned to the x value and we use sumproduct function to calculate the weighted average. 20 years x 2 4 weighted years. Divide the weighted total by the bond face value to get the WAL.
The weighted average is 828.
The weighted average is 828. The weighted average is 828. Using the normal average where we calculate the sum and divide it by the number of variables the average score would be 76. The average amount of time remaining before maturity in the mortgages underlying a mortgage-backed security weighted by the percentage of the MBS that each mortgage constitutesFor example suppose a mortgage-backed security contains two mortgages one worth 10000 and one worth 20000 for a total of 30000.
