Unrelated activities placed in their silos, the debt/basis percentage of a building bought with a loan, a K-1, carried losses within the 80 percent limit, the $1,000 specific deduction, the tax at the corporate or trust rates, and the Form 990-T filing test on gross income.
A charity organized as a corporation runs a bookstore line, event catering and program advertising, owns a building financed by a loan and receives one K-1. The building's debt averages $625,000 against $1,135,000 of basis, so 55.07 percent of its rents and deductions enter UBTI. Four silos, one of them a loss counted as zero, add up to $47,403; after the specific deduction, UBTI is $46,403 and the tax $9,745. The calculator lays the chain out for one organization, 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.
UBTI_Calculator.xlsx (15 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 UBTI Handbook, which follows one museum through a full return: the section 513 tests activity by activity, exceptions and a sponsorship, a mixed lease, rent from a controlled company, shared costs split by key, a building whose debt is averaged month by month, a K-1, six silos, losses before and after 2018, and Form 990-T schedule by schedule, with an IRA beside it.
Inputs are in blue; everything else is a formula; the checks count the failures. Unused rows stay empty and change nothing.
| Measure | Value |
|---|---|
| Average acquisition indebtedness (start and end of year) | $625,000 |
| Average adjusted basis | $1,135,000 |
| Debt/basis percentage | 55.07 percent |
| Rents included / deductions allowed | $64,983 / $47,580 |
| Silo 45, bookstore, after its carried loss | $19,100 |
| Silo 72, event catering | $3,600 |
| Silo 51, program advertising (a loss, counted as zero) | $0 |
| Silo 901101, investment activities (building and K-1) | $24,703 |
| Sum of the silos | $47,403 |
| Specific deduction | $1,000 |
| Unrelated business taxable income | $46,403 |
| Tax at 21 percent | $9,745 |
| Gross income of the activities (receipts less cost of goods sold) | $80,800: Form 990-T required |
| Control block | Every check at 0 |
The example organization is fictional and every input is a teaching assumption: a section 501(c)(3) corporation with a bookstore line (code 45) of $58,300 of receipts, $24,900 of cost of goods sold and $9,100 of costs; event catering (code 72) with $34,800 of receipts and $31,200 of costs; program advertising (code 51) with $12,600 of receipts and $15,900 of costs; a building with debt of $640,000 at the start and $610,000 at the end of the year, adjusted basis of $1,150,000 and $1,120,000, rents of $118,000 and deductions of $86,400; one K-1 of $7,300; and a loss of $5,200 carried in the bookstore silo. Every check of the control block reads 0. The calculator is separate from the book's case: read its figures against each other, not against the book's museum.
Rules described as read in November 2026 (26 U.S.C. 511, 512, 514 as applied by the IRS Instructions for Form 990-T (2025), and the 2026 trust rate schedule of Rev. Proc. 2025-32). Education only, not tax advice: the facts of your own organization govern, and your tax adviser decides.
For one exempt organization, it takes a few unrelated activities with their receipts and costs, one building financed by debt, a K-1 and the carried losses, puts each activity in its silo, computes the debt/basis percentage and the debt-financed income, applies the carried losses within each silo and the specific deduction, and returns the tax and the Form 990-T filing test on gross income.
As read in November 2026: separate silos under section 512(a)(6) with no silo below zero, the debt/basis percentage of section 514, post-2017 losses limited to 80 percent inside their silo, one specific deduction of $1,000, the 21 percent corporate rate or the 2026 trust schedule, and the $1,000 gross income filing test. The organization's form and the rates are entered as declared assumptions.
To keep the inputs short, it averages the debt at the start and the end of the year. The instructions for Form 990-T use the principal on the first day of each month held; for a loan that amortizes evenly the two come close, and the book's workbook uses the monthly method.
The section 513 tests themselves, exceptions and sponsorships, mixed leases, payments from controlled entities, losses from before 2018, estimated tax and state rules. The book's full workbook covers most of them on one case.
No. It is built for a first pass and for learning the mechanics. The return needs its own figures and documents, 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 UBTI Handbook goes further: activities tested one by one, shared building and team costs split by key, the debt averaged on the first day of each month, a K-1 with its debt-financed part, six silos, losses from before and after 2018 in their order, Form 990-T with its Schedules A, a scenario without debt, an IRA and sensitivities.