As you know, PwC marched out a new compensation structure earlier this month and it’s been the subject of much interpretation, gnashing of teeth and even a fair amount of rejoicing. Of course, a complete analysis of this new structure would not be complete without the magic of Excel and lucky for you, a reader has taken the time to put some spreadsheet wizardy on it.

Here’s our tipster:

[Here] is an analysis of the new PwC compensation structure. It shows that the firm expects an approximate average raise of 8% per year and 16% per promotion year. The analysis also includes an approximate total compensation for each year of career progression.

I had to break up the image into two pieces so they could be readable. They appear on the next two pages.

Don’t forget that in Year 7, the bonus for promotion to manager is being phased in over three years, so that younger managers do not jump their more experienced colleagues in overall comp.

Obviously results will vary but this gives a pretty good picture of what your compensation will look like over the years at P. Dubs. If you’re busting, still not satisfied or have your own variables to add to the analysis provided, do share.