ExcelBanter - Wieghted average rate

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Wieghted average rate (https://www.excelbanter.com/excel-worksheet-functions/226739-wieghted-average-rate.html)

ash

Wieghted average rate

I need your help to calculate the weighted average for the loans expenses
(transfer pricing).
Sample:
# Of month outstanding loans TP rate
1 100,000 1.50%
2 98,000 1.54%
3 97,000 1.60%
......

--
ash

Bernard Liengme[_2_]

Wieghted average rate

Let's say the loans are in B2:B20 and the percentages in C2:C20
Use =SUMPRODUCT(B2:B2,C2:C20)/SUM(B2:B20)
best wishes
--
www.stfx.ca/people/bliengme

"ash" wrote:

I need your help to calculate the weighted average for the loans expenses
(transfer pricing).
Sample:
# Of month outstanding loans TP rate
1 100,000 1.50%
2 98,000 1.54%
3 97,000 1.60%
.....

--
ash

ash

Wieghted average rate

Thanks Bernard
--
ash

"Bernard Liengme" wrote:

Let's say the loans are in B2:B20 and the percentages in C2:C20
Use =SUMPRODUCT(B2:B2,C2:C20)/SUM(B2:B20)
best wishes
--
www.stfx.ca/people/bliengme

"ash" wrote:

I need your help to calculate the weighted average for the loans expenses
(transfer pricing).
Sample:
# Of month outstanding loans TP rate
1 100,000 1.50%
2 98,000 1.54%
3 97,000 1.60%
.....

--
ash

All times are GMT +1. The time now is 06:55 AM.