SBA & EIDL
Treasury Collection Cost Scenario Worksheet
Reconcile a Treasury collection scenario using charges from the actual notice.
How to use this calculator
- Gather referred balance; documented collection fee; interest; proposed payments. Use documents covering the same date or period.
- Replace the example values with your own figures. Change one assumption at a time to compare scenarios.
- Review balance growth; payment scenarios; charges breakdown. Open the breakdown and export a copy for discussion.
How the calculation works
Projected balance adds principal, accrued interest, documented costs and entered future charges, then subtracts credited payments. No default collection fee percentage or interest allocation is assumed.
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.
- Projected remaining balance
- $111,000.00
- Total entered charges
- $23,000.00
- Credited payments
- $12,000.00
- Starting total notice balance
- $120,000.00
Questions about the results
What does this tool include?
Reconcile a Treasury collection scenario using charges from the actual notice. Projected balance adds principal, accrued interest, documented costs and entered future charges, then subtracts credited payments. No default collection fee percentage or interest allocation is assumed.
What should I verify before relying on the result?
Use the notice and agency statement to verify each charge and credited payment. This is a sources-and-uses reconciliation, not an official payoff or negotiated arrangement.
What this result does and does not tell you
Use the notice and agency statement to verify each charge and credited payment. This is a sources-and-uses reconciliation, not an official payoff or negotiated arrangement.
Sources and reference material
Sources checked 2026-10-09. Verify rules and program terms for your actual transaction date.