If I am buying Parts and the supplier gives me 3% reduction of that part each year for the next three years.
part initial price is $100

Also what if some parts get 1.5% reduction
Also what is some parts get a reduction for 4 years instead of 3.

Question: Is there a formula that i could drag down to find out the final price of each part.

Part A $100 3% 3% 3%
Part B $100 1.5% 1.5% 1.5% 1.5%