Book · Julian R. Sterling

The Charitable Planning Handbook

An Advisor's Guide to Charitable Remainder Trusts, Donor-Advised Funds, Private Foundations, QCDs and Gifts of Appreciated and Business Assets

About the book

Cover of The Charitable Planning Handbook

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.

What is inside

The companion files

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 five workbooks, the toolkit and the read-me, in one archive141 KB

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.

Free calculator

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

Three numbers to reproduce first

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.

Read first

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

Also by Julian R. Sterling