Wieghted average rate

  • Thread starter Thread starter ash
  • Start date Start date
A

ash

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%
......
 
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
 
Thanks Bernard
--
ash


Bernard Liengme said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Repaymen of loan excel sheet with grace period etc... 14
How do I create the formula for this calculation? 1
calculation for bank interest chargeable 2
Growth Rate for number series 1
Weighted Average Calc for duplicated values only 0
Weighted Average Life 1
Calculating an average 1
AOR to APR - Truth in Lending 2

Back
Top