# The UBTI Handbook: companion files

Julian R. Sterling, julianrsterling.com/ubti

## What is here

- **UBTI_Workbook.xlsx**: the workbook behind every figure of the book (appendix A). The case is fictional: Halsworn Museum of Craft and Design, a section 501(c)(3) organization formed as a nonprofit corporation, with a shop, a cafe, a resale corner, a magazine that sells advertising, an evening parking lot, a hall leased with its furniture, an office building bought with a mortgage loan, a partnership interest reported on a K-1 and a design studio company it owns. Two scenarios sit apart: the same building without debt, and an individual's IRA. Every amount, key, date and rate is a teaching assumption, never a market figure.

## The twelve tabs, in the order to read them

1. **Inputs**: every declared amount: receipts, costs, keys, the monthly principal of the loan, the K-1 line, the carried losses and the scenario inputs.
2. **Activities**: each unrelated activity from its receipts to its result, with its direct costs and its share of the common charges.
3. **Charges**: the building costs and the shared team split by their keys, to the dollar, with the shares that are never deducted.
4. **Building**: the office building: the principal on the first day of each month, the average acquisition indebtedness, the adjusted basis, the debt/basis percentage and the income included.
5. **K-1**: the museum's share of the partnership's unrelated business taxable income, with its debt-financed part.
6. **Silos**: six silos, each with its code, and the sum of the positive silos.
7. **Losses**: the pre-2018 net operating loss, the post-2017 losses silo by silo within the 80 percent limit, and the specific deduction.
8. **Tax**: the tax at the corporate rate.
9. **Form 990-T**: Part I and Part II, and one Schedule A per silo with its Part V for the debt-financed building.
10. **Scenarios**: the same building without debt, a sale at year end, and an individual's IRA taxed at the trust rates, kept apart from the case.
11. **Sensitivities**: one declared input moved at a time.
12. **Controls**: checks that parts add up to their totals and that the tabs agree; every line must read zero.

## How to use it

Change one input at a time on Inputs, read the silos, the debt/basis percentage and the tax again, and look at Controls before reading any figure. File nothing while the Controls count is above zero.

The workbook needs a spreadsheet program that recalculates formulas when the file opens (Excel or LibreOffice).

Rules are described as read in November 2026. This is education, not tax advice: the facts of your own organization or account govern, and your own tax adviser decides what applies to it.
