Compound Interest with Annual Investment

I know how the basic formula works, but the formula isn't working for me when applying to a balance that changes every year because of annual contributions.

Please, please see the attached Excel file for complete details. I really need to figure out how to get the Total Investment Balance calculated correctly.

I believe I have everything setup correctly, but my results in years 3-12 aren't matching 2 online (assumed to be reliable) investment calculators.

Thanks in advance for the assistance!!!

Originally Posted by kmham

I know how the basic formula works, but the formula isn't working for me when applying to a balance that changes every year because of annual contributions.

Please, please see the attached Excel file for complete details. I really need to figure out how to get the Total Investment Balance calculated correctly.

I believe I have everything setup correctly, but my results in years 3-12 aren't matching 2 online (assumed to be reliable) investment calculators.

Thanks in advance for the assistance!!!

Don't believe sales brochures, and there is no reason to double post.

This question was answered in one of your other posts.

---