Enter a monthly financial statement and the assets, and the file computes the monthly disposable income, net realizable equity at quick sale value, the reasonable collection potential of a lump-sum and of a periodic payment offer, and prices four routes on the same balance: a full-pay installment agreement, a partial payment agreement, the offer, and currently not collectible. Eight tabs, no macros.
The example is the book’s fictional client, Silas Wrenfield, a self-employed finish carpenter with a household of two and four years of unpaid tax. After a first-time abatement he owes $70,823 at 15 August 2026. His disposable income is $442 a month and his net realizable equity $13,850, so the lump-sum potential is $13,850 + $442 x 12 = $19,154 and the periodic payment potential $13,850 + $442 x 24 = $24,458, both below the balance. The Checks tab confirms every figure against the book.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
TRP_Offer_in_Compromise_Calculator.xlsx (312 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
This file is a simplified copy of the third of the four workbooks of The Tax Resolution Professional, for one file and with no links to the other workbooks. The book follows two fictional files from the engagement letter to the closing memo: the carpenter’s four years of balances, notices, lien and levy, abatement and offer, and a small company’s two unpaid payroll quarters, its levied bank account and the trust fund recovery penalty.
DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide
Eight tabs. Blue cells on a light blue fill are inputs; black cells are formulas.
| Step (fictional client) | Value |
|---|---|
| National standards: food, clothing and other items, two persons | $1,558 |
| Out-of-pocket health care, two persons under 65 at $90 each | $180 |
| Housing and utilities: rent and utilities actually paid | $1,850 |
| Vehicle ownership: the truck loan payment | $520 |
| Vehicle operating costs | $300 |
| Health insurance premiums | $410 |
| Current estimated tax payments for 2026 | $640 |
| Total allowable monthly expenses | $5,458 |
| Monthly net business income | $5,900 |
| Monthly disposable income | $442 |
| Asset | Fair market value | Quick sale value | Equity |
|---|---|---|---|
| Cash in the bank account | $2,300 | $2,300 | $2,300 |
| Truck (loan $9,800, vehicle allowance $3,450) | $18,000 | $14,400 | $1,150 |
| Tools and equipment (no exemption taken in the case) | $6,000 | $4,800 | $4,800 |
| Retirement account (30 percent case assumption for tax and early withdrawal costs) | $8,000 | - | $5,600 |
| Net realizable equity | $13,850 |
| Option, priced from the same balance of $70,823 | Total paid, fees included | Payments | Left unpaid |
|---|---|---|---|
| (a) Installment agreement, full balance in 72 months | $93,469 | 71 of $1,297, last $1,275 | $0 |
| (b) Partial payment installment agreement | $51,379 | 116 of $442 | $70,172 |
| (c) Lump-sum offer in compromise | $19,359 | $3,831 with the application, $15,323 after acceptance | $0 |
| (d) Periodic payment offer | $24,663 | 23 of $1,019, last $1,021 | $0 |
The full-pay plan needs $1,297 a month against a disposable income of $442: not affordable. The partial payment plan runs 116 months at $442. The periodic offer needs $1,019 a month, which the client cannot pay without outside money. Currently not collectible is not available while disposable income is positive, and one year of waiting with no payment would take the balance from $70,823 to $78,954: $8,131 more, because interest and the failure-to-pay penalty keep running. In the book, the client funds the lump-sum offer from his savings, his retirement account and a loan from his brother.
Every rule the calculator reads is an input with the date it was read, so that you can replace it when it changes. As read in November 2026: the national standards for a household of two, $1,558 a month, and out-of-pocket health care of $90 per person under 65, both from the Collection Financial Standards effective 29 June 2026; quick sale value at 80 percent of fair market value and a vehicle allowance of $3,450, from IRM 5.8.5 effective 23 April 2026; 12 months of future income for a lump-sum offer and 24 for a periodic payment offer, unless fewer months remain on the collection statute; a $205 application fee and 20 percent of a lump-sum offer sent with the application; a $107 installment agreement setup fee by direct debit arranged by phone, mail or in person. Housing, utilities and vehicle costs are case figures assumed below the local standards, which were not read. The interest rate is a teaching assumption of 7 percent compounded monthly; the real rate is set each quarter and interest is compounded daily. Check every figure on irs.gov before using the file.
An educational tool, not advice. The calculator computes; it does not decide what a taxpayer owes, which option to choose, or whether an offer would be accepted, and it promises no result. The client and the figures are fictional teaching assumptions. For a real file, consult a qualified tax professional.
Yes. It is a companion file of a book. You enter an email address, the download opens at once, and you can leave the reader list in one click.
No. It computes the reasonable collection potential the way the Internal Revenue Manual builds it, as read in November 2026, from the figures you enter. Whether an offer fits a taxpayer, and whether it would be accepted, are questions for a qualified tax professional with the full file.
The national standards, the out-of-pocket health care amount, the quick sale percentage, the vehicle allowance, the months of future income and the fees are inputs, each labelled with the date it was read. They change: check each one on irs.gov before you use the file, and overwrite it if it moved.
No macros and no circular reference. Inputs are blue cells; everything else is a formula, every ratio and month count returns 0 while its divisor is 0, and a Checks tab compares the outputs with the figures printed in the book.