Free Excel templates

A free section 108 COD income calculator in Excel

One discharge: the amount owed and what the debtor gives, the liabilities and assets immediately before, the attributes left after the tax of the year and the bases and liabilities after. The exclusion and the reduction, statutory order and election side by side, every step shown.

A corporation owes $800,000 and its lender takes a new note with an issue price of $500,000. Immediately before, it is insolvent by $150,000, so it excludes $150,000 and pays tax on $150,000. The excluded amount then wipes out its net operating loss, its credit and its capital loss and still takes $43,000 off its basis. Under the section 108(b)(5) election, the same $150,000 would come off its depreciable property instead and every attribute would be kept. The calculator lays out both, ready for your own figures.

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.

Section_108_COD_Income_Calculator.xlsx (9 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 calculator is a simplified version of the companion workbook of The Section 108 Handbook, which follows one lender and three debtors through 2026 and to 2030: a new note and a related party purchase, an insolvency worksheet, the reduction vintage by vintage, the basis cut of section 1017 and its recapture, the election, partners and an S corporation, Forms 982 and 1099-C, and a multi-year model.

Paperback PDF edition, $19.99

What is in the file

Three tabs. Inputs are blue; everything else is a formula; the Checks tab counts the residues that are not zero.

1. Read me
What the calculator does, how to fill it, and what it leaves out.
2. Calculator
The amount owed, what the debtor gives, liabilities and assets immediately before the discharge, the attributes left after the tax of the year, the bases and liabilities after the discharge and the depreciable property; below them, the cancellation of debt income, the exclusion, the liability floor, and the reduction in the statutory order and under the election, attribute by attribute.
3. Checks
Excluded plus taxable against the income, and the amounts applied plus the unused amount against the exclusion, for both columns.

What the worked example returns

MeasureStatutory orderElection
Cancellation of debt income$300,000$300,000
Insolvency$150,000$150,000
Excluded under insolvency$150,000$150,000
Taxable$150,000$150,000
Depreciable property first (line 5)$0$150,000
Net operating loss$60,000$0
General business credit reduced by$9,000$0
Net capital loss$20,000$0
Basis (within the liability floor)$43,000$0
Unused$0$0

The example corporation is fictional: liabilities of $1,400,000 and assets of $1,250,000 immediately before the discharge; a net operating loss of $60,000, a general business credit of $9,000 and a net capital loss of $20,000 left after the tax of the year; bases and money of $1,180,000 and liabilities of $1,100,000 after the discharge; depreciable property of $700,000. Every input is a teaching assumption, separate from the book's case.

How to use it on your own file

  1. Measure the income first: principal and accrued interest already deducted, against what the debtor gives, a new note at its issue price.
  2. Date the balance sheet immediately before the discharge and enter every asset at fair market value and every liability.
  3. Compute the tax of the year of the discharge before the reduction, and enter the attributes that remain after it.
  4. Read the Checks tab before any figure: a count above zero means a cell to fix.

Rules described as read in November 2026 (26 U.S.C. 61(a)(11), 108 and 1017, Treas. Reg. 1.108-7 and 1.1017-1). Education only, not tax advice: the facts of your own return govern, and your tax adviser decides.

Questions people ask

What does the COD income calculator do?

For one discharge it computes the cancellation of debt income, the insolvency, the amount excluded under insolvency and the amount taxable, then the reduction of tax attributes in the order of section 108(b)(2), credits at 33 1/3 cents per dollar and basis within the liability floor of section 1017(b)(2), and the same reduction under the section 108(b)(5) election.

Which rules does it apply?

As read in November 2026: sections 61(a)(11), 108(a)(1)(B), 108(a)(3), 108(b), 108(d)(3) and 1017(b)(2), with the order of Treas. Reg. 1.108-7.

What does it leave out?

A title 11 case, the qualified real property business, farm, principal residence and student loan exclusions, vintages of losses, the classes of basis reduction, recapture, partnerships and S corporations. The book's workbook covers them on one case.

Can I rely on it for a filing?

No. It is built for a first pass and for learning the mechanics. Form 982 needs your own records, and the conclusions belong to your tax adviser.

Is this calculator really free?

Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.

Go further

The free workbook of The Section 108 Handbook goes further: NOLs by vintage, the tax of the year before the reduction, the liability floor read two ways, the classes of basis reduction, a forecast to a sale with recapture, an election scenario, three partners and an S corporation, on one case.

See the book and its free files →

Related reading