Free Excel templates

A free offer in compromise calculator in Excel, with a worked case

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.

Get the calculator

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.

The book behind this calculator

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

What is in the file

Eight tabs. Blue cells on a light blue fill are inputs; black cells are formulas.

Read me
What the file does, how to replace the example with a real statement, where the IRS figures come from and when they were read, and what the file does not decide.
Inputs
Household size, monthly income and each allowable expense; the assets with their fair market values, loans and allowances; the months of future income, the fees and the payment on a lump-sum application; the balance of each tax year with its collection statute expiration date, for the projections.
Income and Expenses
Monthly income less the allowable expenses, line by line with the source of each: the monthly disposable income on which the offers and the plans are priced.
Assets
One row per asset, never deleted to make the total smaller: fair market value, quick sale value, loans and allowances, and the equity of each, adding up to net realizable equity.
Potentials
Net realizable equity plus 12 months of disposable income for a lump-sum offer and 24 months for a periodic payment offer, a check that enough months remain before the shortest collection statute date, and a comparison of the balance with both potentials.
Options
Four routes priced from the same balance: total paid including fees, number and amount of payments, end date, amount left unpaid, main risk; then the cost of waiting in currently not collectible.
Projections
Three month-by-month projections from the balance date, with interest and the failure-to-pay penalty running on each year: the full-pay plan, the partial payment plan, and no payment at all.
Checks
Each output set against the figure printed in the book, then structural checks. The option table goes to a client only when the tab reads ALL CHECKS OK.

What the worked case shows

Silas Wrenfield’s monthly statement. The IRS standards are those read for the revision effective 29 June 2026; the other lines are case figures.
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
Quick sale value at 80 percent of fair market value, as read in the Internal Revenue Manual in November 2026.
AssetFair market valueQuick sale valueEquity
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
Fictional case. The amount left unpaid in (b) is what the projection shows when the collection statute dates pass; it is never an aim of the file.
Option, priced from the same balance of $70,823Total paid, fees includedPaymentsLeft unpaid
(a) Installment agreement, full balance in 72 months$93,46971 of $1,297, last $1,275$0
(b) Partial payment installment agreement$51,379116 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,66323 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.

The IRS assumptions, and their dates

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.

How to use it on a real statement

  1. On Inputs, overwrite the household, the monthly income and each expense with the figures of the statement, keeping the standard where the rules allow the standard and the actual amount where they allow the lesser of the two.
  2. List every asset, even the ones with little equity, with its fair market value, its loan and any allowance. Never delete a row to make the total smaller.
  3. Type the balance, the penalties and interest left, and the collection statute date of each year from the account transcripts, then read Potentials and Options.
  4. Keep the Checks tab: once you change an input the comparison with the book stops matching, which is expected; the structural checks still have to pass.

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.

Questions people ask about it

Is this offer in compromise calculator really free?

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.

Does it tell me what to offer the IRS?

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.

Are the IRS amounts up to date?

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.

Does it use macros?

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.

Related reading