Jump to content

Recommended Posts

Posted

See page 5 (table at the bottom) of the Winter 2002 edition of The Enrolled Actuaries Report.

http://www.actuary.org/ear/pdf/winter_2002.pdf

I'm a retirement actuary. Nothing about my comments is intended or should be construed as investment, tax, legal or accounting advice. Occasionally, but not all the time, it might be reasonable to interpret my comments as actuarial or consulting advice.

Posted

a few years ago I got interested in how the silly numbers were calculated, and then someone else I knew took my jumbled logic and tossed it into a spreadsheet. It might not be perfect, but based on the rules it does provide a good estimation of where thing stand (or what they probably will be for 2004)

Each month, around the 20th the govt releases the Consumer Price Index. to determine the indexed figures they take the #s for july/Aug/Sept and divide by whatever was just set by EGTRRA (I don't remember, my mind is mush)

Anyway, obviously we dont know the figures yet, but I have plugged in the figures for the most recent 3 months just to see where things sit. (Of course the deferrals limits are locked in place, but the other stuff is still indexed)

Posted

Tom:

Please tell me that you did this while on the job, and not on your free time.

...but then again, What Do I Know?

Posted

originally it came about because the company I work is also listed under the Q and A columns and the boss wanted an article written to throw on there.

someone else read it and asked me where the heck I pulled the numbers and stuff, and this guy was a wiz with excel and he sent the spreadsheet to me.

I've tried to modify it for the new rules under EGTRRA - I could easily have goofed somewhere, but I think it still works correctly.

Anyway, I call it a 'nifty' spreadsheet (but that is my terminolgy, I suspect the term 'excellent' or 'useful' might be better - the guy who wrote the original sheet is way up there in my book!

Sounds like you might agree!

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

Terms of Use