Settlement planning
Multi-Creditor Offer Allocation Worksheet
Compare individually chosen creditor offers with the cash available to fund them.
How to use this calculator
- Gather creditor balances; user-selected offers; fees; available funds. Use documents covering the same date or period.
- Replace the example values with your own figures. Add or remove rows to match your records. Change one assumption at a time to compare scenarios.
- Review offer totals; funding shortfall; per-creditor comparison. Open the breakdown and export a copy for discussion.
How the calculation works
Each row multiplies its balance by its proposed offer percentage and adds its stated fees. Summing these costs gives the total requirement; subtracting available funds gives the funding shortfall.
Worked example
These results use the editable example values shown in the calculator. They illustrate the method and do not predict an offer or outcome.
- Total offer funding
- $93,500.00
- Funding shortfall
- $0.00
- Remaining available cash
- $6,500.00
- Total claim balances
- $140,000.00
Questions about the results
What does this tool include?
Compare individually chosen creditor offers with the cash available to fund them. Each row multiplies its balance by its proposed offer percentage and adds its stated fees. Summing these costs gives the total requirement; subtracting available funds gives the funding shortfall.
What should I verify before relying on the result?
This worksheet does not recommend creditor priority or determine valid claims. Offer percentages are editable scenarios, not predicted outcomes.
What this result does and does not tell you
This worksheet does not recommend creditor priority or determine valid claims. Offer percentages are editable scenarios, not predicted outcomes.