Please help!! I'm having trouble automating a calculation for the sum of rents, when factoring in annual rent increases/decreases. For example, what would the formula be to calculate the sum of rents given the following variables:

Year 1 rent - $1,000 per month
Annual Rent growth rate - 3%
Number of years - 5

Is there a formula that will spit out the total projected gross rent after 5 years?

Thanks!!