Hi there, I'm working on updating a spreadsheet that illustrates a rolling vesting schedule. Assuming the contribution is fully vested after 4 years and a new contribution is made each year. The original spreadsheet has a manual calculation over 20 years time and I'd like to have a formula that does the same thing.

I'm very new using formulas in excel so any help is greatly appreciated!

This is what I have to work with:
EOY Base
Age Salary Base fv base Match(1)

44 210,000 21,000 21,000 5,250 26,250 26,250 6,563
45 210,000 21,000 43,367 5,250 26,250 52,500 6,563 6,563
46 210,000 21,000 67,190 5,250 26,250 78,750 6,563 6,563 6,563
47 210,000 21,000 92,564 5,250 26,250 105,000 6,563 6,563 6,563
48 210,000 21,000 119,590 5,250 26,250 131,250 6,563 6,563
49 210,000 21,000 148,376 5,250 26,250 157,500 6,563
50 210,000 21,000 179,035 5,250 26,250 183,750