Formula to calculate pay rate based on years of service

I am looking for an efficient formula to calculate pay rates based on years of service for 1500 records.
I have current pay rate and want to calculate projected pay rate for 2016, 2017, 2018, 2019 and 2020 using the following:
no pay rate increase for the first 4 years of service
6% pay rate increase at 5 years, 11 years, 16 years and 21 years
I calculate years of service based on hire date

My current formula =if(and($n2>=5, $n2<=10),($t2*.06)+$t2,0)
n2 = years of service
t2 = pay rate

One of my challenges is how to modify the formula to increase years of service by 1 for; 2016, 2017, 2018, 2019, 2020

Thanks for any and all suggestions

1. The years can be calculated by calculating the difference between the reporting year and the previous one and adding the result to the previous number of years
2. Line 2 $600 uses the table to the left to source out the increase
3. Line 3 uses an AND clause to add the 0.06 to the previous salary amount.