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.
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.
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.
Three tabs. Inputs are blue; everything else is a formula; the Checks tab counts the residues that are not zero.
| Measure | Statutory order | Election |
|---|---|---|
| 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.
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.
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.
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.
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.
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.
Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.
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.