Gettingbetter15
New Member
- Joined
- Oct 20, 2016
- Messages
- 20
Hi Everyone!
Recently I received some very great assistance in realizing I was trying to calculate the compounded annual growth rate (CAGR) of two values. What I'd appreciate help with now is...how do you calculate CAGR without counting deposits? This is what I mean:
Month #1 : starting bal is deposited (this earned some interest)
Month #2 : made a deposit (month 1 & 2 total is earning some interest)
Month #3 : another deposit (months 1-3 total are now earning interest)
Month #4 : another deposit (months 1-4 total are now earning interest)
I want to calculate the growth in interest...but the CAGR formula requires a beginning and ending value, which it then calculates as gains to the initial amount. I see why, but the ending value isn't the growth only of the initial amount due to the deposits. Any suggestions? Thank you!
Recently I received some very great assistance in realizing I was trying to calculate the compounded annual growth rate (CAGR) of two values. What I'd appreciate help with now is...how do you calculate CAGR without counting deposits? This is what I mean:
Month #1 : starting bal is deposited (this earned some interest)
Month #2 : made a deposit (month 1 & 2 total is earning some interest)
Month #3 : another deposit (months 1-3 total are now earning interest)
Month #4 : another deposit (months 1-4 total are now earning interest)
I want to calculate the growth in interest...but the CAGR formula requires a beginning and ending value, which it then calculates as gains to the initial amount. I see why, but the ending value isn't the growth only of the initial amount due to the deposits. Any suggestions? Thank you!