Excel formula for sum of income over multiple years adjusted for inflation

I have the income X, and the number of years in the future Y, and the inflation Z. I can calculate the compound interest simply by CI(Y) = X*(1+Z)^Y for any given year, but how can I construct a formula that adds each years income together for a total sum?

Ex)

X = 1000 Y = 3 Z = 5% CI(0) = $1000 CI(1) = $1050 CI(2) = $1102,5 CompoundInterestSum(3) = $3152,5 

I could do this in code recursively, but I'd like to know the cleaner formula that I can use in Excel. Thanks!

1 Answer

=-FV(z,y,x) or =FV(z,y,-x)

This calculates the Future Value of a stream of amounts based on the interest rate per period, the number of periods, and the amount added each period.