How to model in annual wage increases when modeling monthly payroll breakdown
Currently, I am using a formula that pulls that monthly salary amount based on hire and end date into future projections. I also want to show wage increases annually based on a different percentage for every division using index match for cases every year.
Anyone have a simple way to do this without complicating the formulas