Covered Compensation in a spreadsheet

[Guest MarieH]

Does anyone have, or know where to find, the IRS covered compensation tables in spreadsheet form? I'm looking for as many years as possible. On our pension calculation worksheet (in excel), I'd like to have the tables on a separate tab so we can vlookup the year of birth and year of retirement (which I assume I'll have to manually add in a column).

OR, does anyone know of a better method? Is there a calculation or add-in perhaps?

Thanks.

[Hojo]

http://www.datair.com/rates.htm

click on each year, highlight, copy, paste.

[Guest MarieH]

http://www.datair.com/rates.htm

click on each year, highlight, copy, paste.

I have tried that, but wouldn't it figure that it is the one table on the internet that is not formatted like the others and doesn't simply cut and paste. We use the rounded numbers, so when you pull that from the official IRS bulletins, they don't have each year listed individually so it would not work either. As a side note, they haven't updated the recent tables either.

I'd be fine cutting and pasting from a table if I had to, but it seems like someone would have done that already!

[Tom Poje]

years ago I attempted to create a covered comp calculator

It actually appears to work.

you simply have to enter the new taxable wage base each year (and copy down through all future years)

this one goes back to 2005.

I suppose you could use it to generate prior years by 'eliminating' a prior taxable wage base.

As I recall, I pasted the govt values into the table to compare with what I generated and they did indeed match

there are 2 values that are generated that will never exist which are the years when SSRA switches from 65 to 66 and 67

but its the best I can do.

of course no guarantees.