Book · Julian R. Sterling
An Advisor's Guide to Charitable Remainder Trusts, Donor-Advised Funds, Private Foundations, QCDs and Gifts of Appreciated and Business Assets
March 2026. Two founders preparing the sale of their engineering company tell their adviser they want part of the proceeds to go to charity. Two months earlier, a widow of seventy-six asked the same practice whether she should keep writing checks to her three charities. This book follows both files from the first meeting to the return, and shows the arithmetic and the paperwork behind every decision.
The Charitable Planning Handbook is a guide to the adviser's work in charitable planning for wealthy clients: the deduction rules by donee, property and percentage limit, with the five-year carryforward; the rules of the 2025 law in force from 2026, the 0.5 percent floor and the section 68 reduction among them; gifts of appreciated shares and of private company stock before a sale, and their calendar; the qualified appraisal and Form 8283; donor-advised funds and private foundations; charitable remainder unitrusts and annuity trusts on a term of years, and lead trusts; gift annuities in principle; qualified charitable distributions and bunching; and the year-end file. Every number comes from one model, and the rules are dated as read in 2026.
What the files show: why shares are given before any binding agreement, never after; why the appraisal window and Form 8283 come before the deduction; why a unitrust of fifteen years passes the 10 percent test where an annuity trust at the same rate fails; why the deduction of a large gift spreads over two years, and what the floor takes in each; why the same gift to charity leaves the family more when the shares go before the sale than when the cash goes after it; why a donor-advised fund was chosen over a family foundation; and why a qualified charitable distribution leaves a retiree who does not itemize a lower taxable income than cash or shares.
The model is supplied, not described: five companion workbooks rebuild the case by live formula, each with a Checks tab.
What you will be able to do:
Sixteen chapters in four parts and four appendices: a guide to the five workbooks with their worked examples, eight working check-lists, seventy-five questions for the client meeting and the file review, and a glossary of fifty-one terms.
Written for wealth advisers and financial planners, CPAs who prepare their clients' returns and deduction schedules, estate planning attorneys who need the figures, family office staff, planned giving officers and advisers to owners selling a business. Nothing here decides what a particular donor may deduct, which vehicle to use, or what an appraiser or the Internal Revenue Service will conclude. The case, its practice, its clients and its places are fictional, and its figures are teaching assumptions, not norms of the trade. This book is for education only. It is not legal or tax advice. Part of The Private Markets Career Guides.
How this book was made: written with the help of artificial intelligence tools, under the author's direction; every figure was computed by a model and every rule was checked against its source.
Five workbooks follow the two fictional files of the case: Graham and Elise Ormsley, who give shares of their company to a donor-advised fund and to a 15-year unitrust before its sale, and Constance Linwell, a widow who gives to three charities each year from her retirement account. Each keeps the case’s figures in blue input cells on an Inputs tab that you overwrite with your own, with the rules read in November 2026 dated beside them, returns 0 for any ratio or factor whose divisor is 0, and ends with a Checks tab. A toolkit holds the check-lists of Appendix B in editable form.
The archive holds the five workbooks, the toolkit and 00_START_HERE.md. No macros, no circular references, no external links, no password. The workbooks recalculate in any spreadsheet program that reads .xlsx files.
Chapters 3 and 4
The deduction rules applied year by year: the percentage limits by class of gift, the 0.5 percent floor charged in the statute’s order, the section 68 reduction and the five-year carryforward, with a check line that ties allowed, lost and carried back to the gifts. Tabs: Inputs, Limits, Floor, Section 68, Carryforward. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 119 KBChapters 9 and 10
A term unitrust designed step by step: the adjusted payout rate, the remainder factor and the 10 percent test, the deduction, a grid of other designs, the payments projected at an assumed return, and a term annuity trust beside it. Tabs: Inputs, Design, Design Grid, Payments, Annuity Trust. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 221 KBChapter 8
Three routes for the same shares at equal base, two years each: sell and keep, sell then give cash, give shares before the sale. Family, charity and tax caused add up to the value of the shares in every row. Tabs: Inputs, Tax, Split. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 322 KBChapters 12 and 13
The same plan with a private foundation in place of the donor-advised fund, on the same rows, then what the case can price of running a foundation: the excise tax, the minimum investment return and the running cost. Tabs: Inputs, Variant, Running, Comparison. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 422 KBChapters 4, 12 and 14
A retiree’s two years by route: cash, a qualified charitable distribution, a mix, appreciated shares and bunching on a donor-advised fund, with the taxable income of each and a rule cell that keeps the distribution away from a donor-advised fund. Tabs: Inputs, Cash, Distribution, Comparison. A Checks tab puts the figures printed in the book beside the cells that compute them.
Download workbook 519 KBAppendix B
First meeting and philanthropic goals; Choosing the asset to give; Gift of private shares: qualified appraisal, Form 8283, donee acceptance; Calendar of a gift before a sale; Setting up a charitable remainder trust; Opening and bunching on a donor-advised fund; Private foundation decision; Qualified charitable distributions and year-end papers.
Download the toolkit42 KBRead first
What each file holds, which workbook answers which chapter, and the two inputs to change first.
Download the read-me6 KBA simplified copy of the second workbook: a charitable remainder unitrust on a term of 1 to 20 years, the Section 7520 rate of the month and the Table F factor as dated inputs, the remainder factor and the 10 percent test, the deduction under a percentage limit of the contribution base with the floor and the carryforward, the payments projected at an assumed return, and a comparison at the gift date with a sale of the same shares without a gift, with a Checks tab. Get the charitable remainder trust calculator.
| The remainder | $1,800,000 x 0.260753 = $469,355: the remainder deduction of the 15-year unitrust at 9.0 percent, which passes the 10 percent test |
| The floor | $2,000,000 x 30 percent - $10,000 = $590,000 allowed in 2026, and $589,355 + $10,000 = $599,355 carried to 2027 |
| The split | $13,573,944 + $1,189,355 + $3,236,701 = $18,000,000: family, charity and tax caused when the shares are given before the sale |
The files are provided as they are, without warranty of any kind. The model is illustrative: Quintavell Wealth Advisors, LLC, its clients and their people are fictional; the values, returns, costs, dates and outcomes are the book’s assumptions, not norms of the trade or the record of any real donor. The workbooks compute; they decide nothing about what a donor may deduct or how a trust is drafted, and they promise no result. Not legal or tax advice.
To read: What changed for charitable deductions in 2026?
To read: Qualified charitable distributions in 2026: limits, rules and when a QCD beats giving stock
To read: Donating shares before selling a business: timing, appraisal and the charitable remainder trust