Covered Compensation Add-in
cc.xla is an Excel '97 add-in containing a function called CC() that calculates Covered
Compensation under chosen assumptions. Download the zipped file AddIns.zip.
The function has three arguments =cc(yob,yoc,rnd)
- yob = year of birth, for example born July 5, 1942, enter just 1942
- yoc = year of calculation, to get cc for 1999, enter 1999
- rnd = rounding, to round down to $12, enter 12
If you want to do calculations after 1999, you have to update the addin. Open the Excel
VB editor, and find cc.xla. In the Modules folder, find Module1 and open it. There
is a subroutine called Initialize. In it, change the line
ReDim wb(1951 To 1999)
to (for example)
ReDim wb(1951 To 2000)
then farther down, add the line
wb(2000) = 75000 (or whatever the wage base in 2000 is)
Then save it (from the VB editor). It too confusing, find an Excel geek to help,
or check back here later.
The program has been checked against other programs, but you are encouraged to check it
yourself before relying on it. It is complimentary from us, Dean & Company, to anyone
interested.
