Enter the value funded, the unitrust percentage, the term, the Section 7520 rate of the gift month and its Table F factor, and the file computes the adjusted payout rate, the remainder factor and the 10 percent test, the deduction for the remainder under a percentage limit of the contribution base with the 0.5 percent floor and the five-year carryforward, the payments projected at an assumed return, and a comparison at the gift date with selling the same shares without a gift. Seven tabs, no macros.
The example is the book’s fictional sale file. On 15 June 2026, Graham and Elise Ormsley give 100,000 shares of their company, worth $1,800,000, to a charitable remainder unitrust that pays them 9.0 percent of its value each year for 15 years. At the June 2026 Section 7520 rate of 5.0 percent, the remainder factor is 0.260753, the 10 percent test passes, and the deduction for the remainder is $1,800,000 x 0.260753 = $469,355. The Checks tab confirms every figure against the book.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
CPH_Charitable_Remainder_Trust_Calculator.xlsx (21 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 file is a simplified copy of the second of the five workbooks of The Charitable Planning Handbook, for one trust and with no links to the other workbooks. The book follows two fictional files from the first meeting to the return: a founding couple who give shares of their engineering company to a donor-advised fund and to this unitrust before the company is sold, and a widow who gives to three charities each year from her IRA.
DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide
Seven tabs. Blue cells on a light blue fill are inputs; black cells are formulas.
| Step (fictional gift of 15 June 2026) | Value |
|---|---|
| Value funded: 100,000 shares at $18.00 | $1,800,000 |
| Unitrust percentage, term, payments | 9.0 percent, 15 years, one payment a year |
| Section 7520 rate of June 2026, as read | 5.0 percent |
| Table F(5.0) factor, annual payout, first payout 12 months after funding | 0.952381 |
| Adjusted payout rate: 9.0 percent x 0.952381 | 8.5714 percent |
| Remainder factor: (1 - 8.5714 percent) to the power 15 | 0.260753 |
| 10 percent test | passed (0.260753 is at least 0.100000) |
| Deduction for the remainder | $1,800,000 x 0.260753 = $469,355 |
| Donors’ unitrust interest at the gift date | $1,800,000 - $469,355 = $1,330,645 |
| Year | Counted | Limit (30 percent of the base) | Floor (0.5 percent) | Allowed |
|---|---|---|---|---|
| 2026 | $720,000 + $469,355 = $1,189,355 | $600,000 | $10,000 | $590,000 |
| 2027 | carryover $599,355 | 30 percent of $17,222,000 | $86,110 | $513,245 |
The $720,000 in the first row is the same couple’s gift of 40,000 shares to a donor-advised fund on the same day: both gifts are capital gain property given to public charities, so they share the 30 percent limit. Over the two years the couple deducts $590,000 + $513,245 = $1,103,245, and $86,110 is lost to the floor.
At the case’s assumed return of 6.0 percent a year, a teaching assumption and not a forecast, the first payment on 15 June 2027 is $162,000, the fifteenth on 15 June 2041 is $105,759, the payments total $1,980,441 before income tax, and $1,139,852 is left for charity at the end of the term.
The Comparison tab shows why the order matters, and what it leaves for later. Sold without a gift, the shares would carry a gain of $1,770,000 and, at the case’s rates of 20 percent plus 3.8 percent, $421,260 of tax. Given to the trust, there is no tax at funding: the trust itself is not subject to income tax, as section 664(c)(1) reads in November 2026. The gain does not disappear. The trust realizes it when it sells the shares, and it reaches the donors in the capital gain tier of their payments over the 15 years. The tab, like the book’s scenario table, counts the unitrust interest before that tax, which flatters the trust column; the $421,260 is an order of magnitude, undiscounted, if the whole gain reached the donors.
Every rule the calculator reads is an input with the date it was read, so that you can replace it when it changes. As read in November 2026: a unitrust pays a fixed percentage, not less than 5 percent nor more than 50 percent, of the net fair market value of its assets valued each year, for a term of not more than 20 years, and for each contribution the remainder must be at least 10 percent of the value of the property on the date of the contribution (26 U.S.C. 664(d)). The adjusted payout rate is the percentage times the Table F factor for the Section 7520 rate and the months to the first payout, and the remainder of a term unitrust is valued from it (26 CFR 1.664-4). The Section 7520 rate is set each month: 5.0 percent for June 2026 and 6.2 percent for November 2026, on the IRS page updated 23 October 2026. A gift of capital gain property to a public charity is deducted within 30 percent of the contribution base (section 170(b)(1)(C)); from 2026 a floor of 0.5 percent of the contribution base applies (section 170(b)(1)(I)); an excess is carried forward five years. The comparison uses a 20 percent long-term capital gain rate and the 3.8 percent net investment income tax, assumed to apply in full. Check every figure on irs.gov before using the file.
An educational tool, not advice. The calculator computes; it does not decide what a donor may deduct, which design to choose or how a trust is drafted, and it promises no result. It handles a term of years only. The donors and the figures are fictional teaching assumptions. For a real gift, consult a qualified tax professional and the donor’s attorney.
Yes. It is a companion file of a book. You enter an email address, the download opens at once, and you can leave the reader list in one click.
No. It handles a unitrust on a term of 1 to 20 years only. A trust that pays for one or two lives needs the actuarial tables of the Internal Revenue Service, which this file does not hold.
The rate of the gift month and the Table F factor are inputs, each labelled with the month it applies to and the date it was read. The rate changes every month: retype it from irs.gov for the month of the gift, with the Table F factor that matches it and the payment frequency.
No. It computes the remainder, the test, the deduction and a projection from the figures you enter. Whether a trust suits a donor, and how it is drafted, are questions for a qualified tax professional and the donor's attorney.