Forum Discussion

touzels's avatar
touzels
Copper Contributor
Jan 16, 2020

Calculate rate interest average

Hi,   Here's the problem   A (different funds)                    B (interest this year) 1000$                                          5% 2000$                                          10% 50...
excel
Formulas and Functions
PReagan's avatar
PReagan
Bronze Contributor
Jan 16, 2020

Hello touzels,

 

What you are calculating is a weighted average interest rate. The following formula would calculate the weighted average of the three portfolios that you provided:

  • Gianluca Principato's avatar
    Gianluca Principato
    Brass Contributor
    Jan 16, 2020
    Or: =SUMPRODUCT(C2:C4,B2:B4)/SUM(B2:B4)

Resources