Free Excel templates

A free UBTI calculator in Excel

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.

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.

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.

The book behind this calculator

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.

Paperback PDF edition, $19.99

What is in the file

Inputs are in blue; everything else is a formula; the checks count the failures. Unused rows stay empty and change nothing.

1. Start here
What the calculator does, the rules it applies with the date they were read, what it leaves out, and a note that every example figure is a teaching assumption, not a market figure.
2. Inputs
The organization's form (corporation or trust) and the rates as declared hypotheses; each activity with its receipts, cost of goods sold, direct costs, share of common costs by key, and the two-digit code of its silo; the K-1 amounts; one building financed by debt, with the debt and the adjusted basis at the start and the end of the year, its gross income and its deductions; and the losses carried in each silo.
3. Calculator
The result of each activity, the debt/basis percentage and the debt-financed income, the silos with any negative silo at zero, the carried losses within 80 percent of each silo, the specific deduction, the unrelated business taxable income, the tax at the corporate rate or the trust schedule, and the filing test on gross income.
4. Checks
The controls of the calculator, each showing a gap that must read 0, and a count of the failures.

What the worked example returns

MeasureValue
Average acquisition indebtedness (start and end of year)$625,000
Average adjusted basis$1,135,000
Debt/basis percentage55.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 blockEvery 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.

How to use it on your own organization

  1. Enter one row per unrelated activity, with its gross receipts, its cost of goods sold and its other direct costs.
  2. Give each activity the two-digit industry code that best describes it, so that each silo is used once.
  3. Enter the building's debt and adjusted basis from the loan statement and the fixed asset register, with straight-line depreciation.
  4. Enter only the amount each K-1 reports as unrelated business taxable income, and the losses carried in each silo with the year they arose.
  5. 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. 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.

Questions people ask

What does the UBTI calculator do?

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.

Which rules does it apply?

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.

How does it average the debt?

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.

What does it leave out?

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.

Can I rely on it to fill Form 990-T?

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.

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 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.

See the book and its free files →

Related reading