Spreadsheet: john_lavorato__16618__bonus
Sheet: Sheet1

Employee | Job Group | HIRE_DATE | Trader/ Originator | 2001 MidYr Rating | Annual Salary (USD) | Yr End 00 Bonus | Yr End 00 Equity | P & L (000) | CASH BONUS |  | PERCENT | Total  = $24,500,000 | Total = $2,315,0000
[NAME], JOHN D | VP | 1995-05-30 00:00:00 | T | 1 | 160000 | 650000 | 850043.87 |  |  |  |  |  | 5000000 |  |  | [NAME] needs to re-do the orig and grant himself some of the money
SWERZBIN, [NAME] | VP | 2000-01-01 00:00:00 | T | 1 | 200000.04 | 2000000 | 2000097.68 | 188853 |  |  |  |  | 2000000
BELDEN, TIMOTHY N | MD | 2000-01-01 00:00:00 | T | 1 | 200012 | 2750000 | 2750124.93 |  |  |  |  |  | 1500000 | added 75 million to p/l for group contributions
MOTLEY, MATTHEW H | DIR | 2000-03-13 00:00:00 | T | 1 | 120000 | 400000 |  |  |  |  | 0.015 |  | 1200000 | lowered due to tenor
STURM, FLETCHER J | VP | 1997-10-06 00:00:00 | T | 1 | 170000.04 | 1000000 | 1000086.37 |  |  |  |  |  | 1200000 | added 25 million to p/l for group contributions
PRESTO, KEVIN M | VP | 1994-09-06 00:00:00 | T | 1 | 185004 | 500000 | 500043.18 |  |  |  |  |  | 1200000 | added 75 million to p/l for group contributions
ZUFFERLI, [NAME] | VP | 2000-12-16 00:00:00 | T | 2 | 155808 | 325000 | 325159.27 | 100000 |  |  |  |  | 1000000 | set p/l subjectively
RICHTER, JEFFREY S | DIR | 1997-03-20 00:00:00 | T | 1 | 115000 | 450000 |  | 100000 |  |  |  |  | 1000000 | added 25 million due to ees - could be much more
DAVIS JR, MARK D | VP | 1996-09-30 00:00:00 | T | 1 | 150000 | 400000 | 400144.43 |  |  |  |  |  | 1000000 | added 25 million to p/l for group contributions
SHIVELY, HUNTER | VP | 1993-01-04 00:00:00 | T | 1 | 170000 | 1250000 | 1250070.43 |  |  |  |  |  | 1000000 | added 75[NAME] due to leadership and other duties
BENSON, [NAME] | DIR | 1996-07-01 00:00:00 | T | 1 | 115000 | 150000 | 50025 | 98000 |  |  |  |  | 1000000
BADEER, [NAME] | DIR | 1997-07-07 00:00:00 | T | 1 | 125000 | 120000 | 50025 | 126000 |  |  | 0.01 |  | 500000 | lowered percentage due to lack of tenor
MARTIN, THOMAS A | VP | 1986-04-21 00:00:00 | T | 2 | 180000 | 500000 | 500043.18 | 59000 |  |  |  |  | 500000
MAGGI, [NAME] | DIR | 2000-03-07 00:00:00 | T | 2 | 125004 | 175000 | 125050 |  |  |  |  | done | done | ADDED 15 FROM ARNOLD
CALGER, [NAME] | MD | 1993-08-02 00:00:00 | O | 2 | 200000 | 350000 | 350075.75 |  |  |  |  |  | 500000
HERNDON, ROGERS | VP |  | T | 2 | 150000 | 600000 |  |  | 1000000 |  |  |  | 500000
ERMIS, FRANK J | DIR | 1994-08-29 00:00:00 | T | 1 | 115000 | 400000 |  | 60000 |  |  | 0.015 |  | 500000 | lowed due to group's performance and tenor
LEWIS, ANDREW H | DIR | 1995-01-01 00:00:00 | T | 1 | 115000 | 200000 |  | 44242 |  |  |  |  | 500000
SCHWIEGER, [NAME] | VP | 1987-01-31 00:00:00 | T | 3 | 160000 | 500000 | 500043.18 | 44000 |  |  | 0.02 |  | 500000
MAY, [NAME] | DIR | 2000-03-27 00:00:00 | T | 1 | 125004 | 200000 |  | 50000 |  |  | 0.015 |  | 350000 | lower for tenor
BLACK,DON | VP |  | T | 1 | 175000 | $ |  |  | 750000 |  |  |  | 350000
MILNTHORP, PHILLIP ROBSON | MD | 1995-08-01 00:00:00 | O | 2 | 191591.955936 | 450000 | 450092.37 |  | 750000 |  |  |  | 350000 | hard coded
TYCHOLIZ, BARRY L | VP | 2000-12-01 00:00:00 | O | 2 | 150000 | 175000 | 150157.5 | 22032 |  |  |  |  | 350000
STOREY, GEOFFREY C | DIR | 1995-09-25 00:00:00 | T | 1 | 115000 | 150000 | 100050 | 29000 |  |  |  |  | 300000 | added 50k to bonus due to systems project
DAVIES, DEREK J | VP | 1995-06-12 00:00:00 | O | 2 | 146070 | 280000 | 225103.68 | 20000 |  |  |  |  | 300000 | set p/l subjectively due to ppa contribution
BRAWNER, SANDRA F | DIR | 1984-06-28 00:00:00 | T | 1 | 124999.92 | 200000 | 100050 | 29227 |  |  |  |  | 300000
ARORA, HARPREET S | VP | 1995-06-06 00:00:00 | T | 2 | 160000 | 350000 | 325120.31 | 18900 |  |  | 0.025 |  | 250000 | increased due to group building