Updated Proof of Claim Calculation Spreadsheet

I’ve been working on refinements to the Proof of Claim Calculation Spreadsheet and I wanted to explain some of the additions, corrections and refinements:

Employee Number: added a line to enter your Heller Ehrman employee number.  This will help the bankruptcy court to have a reference number and verify that you were a Heller Ehrman employee.

Sabbatical:  for those who had reached their sabbatical anniversary, you should enter the number of hours of sabbatical to which you were entitled.

Health Benefits:  if you had to pay health insurance coverage due to termination prior to the Dissolution Date (11/28/2008), enter the amount.

Profit Sharing: Heller’s profit sharing program made deposits each January to your 401k account based on your years of service with the firm.  This was not a merit or discretionary payment – it was mandated in the firm’s benefits materials.

WARN Act Accrued Profit Sharing: the amount of profit sharing you would have accrued had you not been terminated and were able to work until the Dissolution Date.

Associate Bonus: if as an associate you achieved the billable hours goal, enter the bonus amount to which you were entitled.

Health Costs:  if you did not have health insurance coverage costs but had to pay out-of-pocket medical expenses, enter them here.

Penalty for Seattle, WA and Washington, DC Employees: expanded to include DC employees – they are entitled to add liquidated damages of one times the amount not paid.

Prejudgment Interest: 10% per annum from Termination Date to Proof of Claim Deadline Date

Attorneys Fees and Costs To Be Determined: this is a placeholder for this expense which has yet to be determined.

Unsecured Claim and Priority Claim: the amounts are now broken out separately.

Again, here is the link to the spreadsheet: Proof of Claim Calculation Worksheet


6 Responses to “Updated Proof of Claim Calculation Spreadsheet”

  1. 1 Anon2 18 April 2009 at 5:02 pm

    HD, I am having problems uploading or downloading – whatever – this link It pops up a link called QuattroPro 12. i can’t open it.

  2. 2 Thomas MacEntee 18 April 2009 at 5:33 pm

    This is an Excel spreadsheet in XLS form (meaning it is Excel 2003/2007 compatible).

    Can you right-click over the link and select Save?


  3. 3 Mr. Jones 20 April 2009 at 1:04 pm


    Thanks for revising this! I am definitely submitting a revised claim as the amount with penalties, health care costs, etc. is MUCH larger.

    However, I did notice a few calculation errors:

    First, for the calculation of Hourly Wage in B13, the actual Number of Hours will only be half the calculated value if you were fired on 10/10. This is perhaps not an error per se, since you do say “two week period” in A12, but perhaps you might add a note in the explanation in D12 to “Enter TWICE gross pay from last pay stub if you were fired on 10/10/08.” Or perhaps the Hourly Wage shouldn’t be a calculated field at all, but should just be pulled from the earnings statement.

    Second, the Profit Sharing Rate in B41 was calculating as 500%, not 5%, which, uh, overstates the profit sharing amount by quite a bit.

    Third, in the formula for the Amount of Priority Claim there is a misplaced parenthesis; It reads:

    “=IF(B44>10950,10950,B44)+B36+B38+B42” instead of

    which gives a priority amount greater than $10,950 (at least in my case).

    Anyway, thanks again!

  4. 4 Thomas MacEntee 20 April 2009 at 1:33 pm

    Thanks for catching these – here are my comments:

    1. I’ve changed the note to simply say “Gross Pay for two week period” – I’m pretty sure people would notice an hourly wage that was 1/2 of what they expected.

    2. Yes, I will update the error – it should be .05 in the formula and not 5!

    3. The formula is correct and it is difficult to explain without revealing strategy and bankruptcy law as interpreted by Blum Collins. Putting it simply (and perhaps someone will want to research the concept of priority claim in bankruptcy), technically a priority claim can be greater than $10,950.

  5. 5 Thomas MacEntee 21 April 2009 at 12:31 pm

    The short explanation for why the priority claim is greater than $10,950 is: Former employees may have a priority claim for contributions to employee benefit plans (11 USC § 507(a)(5)) in addition to priority claim for wages (11 USC § 507(a)(4)).


  6. 6 Anon3 22 April 2009 at 3:00 pm

    I don’t believe associates were able to participate in profit-sharing plans, correct?

Comments are currently closed.

Life preserver.jpg
Remember the words of Rev. Frank Scott (Gene Hackman in The Poseidon Adventure):

". . . sitting on our butts is not going to help us either. Maybe by climbing out of here, we can save ourselves. If you've got any sense, you'll come along with us."

Contact Us!

Send us your information as to job leads, networking, or just plain vent!
Go ahead, say it!
Add to Technorati Favorites
Bloggers' Rights at EFF


This blog has been created by Thomas MacEntee.

Recent Comments

Terms of Service

Heller Highwater (hellerdrone.wordpress.com)
Last Modified: September 14, 2008

- Don't be a dill weed.

- Treat other people the way you want to be treated.

- Ladies and children first.

- This is a rescue, not a bitch session.

- Help don't harm.

- Save the snarks for the attorneys and Above The Law.

Heller Highwater is not:

- a place to practice viscious and vindictive "whisper down the lane" rumour-mongering;

- a place to bad mouth co-workers;

- a place for diatribes against specific people or specific incidents;

- a place to heap pity on poor Heller Ehrman staff by outsiders;

- a place that discriminates or sets margins noting who is outside and who is inside - we even welcome supportive Heller Ehrman attorneys!;

- meant to further the demise of Heller Ehrman, LLP.

Heller Highwater is:

- a place for support, a place of empowerment, a place of passion;

- a place to learn about job leads, resume preparation, skill building, training, new opportunities, and how to succeed in a new workplace;

- a place to keep up on the latest news as to how Heller Ehrman management intends to treat its support staff as it winds down its operations - will it be every woman for herself? or will it be "let me hold the door for you and is there anything else I can do for you"?

- a place of refuge.

Note: in no way, shape or form is Heller Highwater sanctioned, supported or even recognized, (but it is very likely monitored) by the management of Heller Erhman, LLP. The opinions represented here and on each and every page of Heller Highwater do not constitute the opinions of Heller Ehrman, LLP or its shareholders or its management. In addition, the comments left by visitors do not reflect the opinions of Heller Highwater.

%d bloggers like this: