I am trying to calculate the total money that can be made from dollar cost averaging every year using Google Sheets. For example: how would I evaluate this?
If I remember my highschool days, your expression reads :
Sum of the
1000*1.07^1 + 1000*1.07^2 + 1000*1.07^3 + ...
Here's a way to do it :