What's included
Three thematic Excel workbooks, forty-five tabs in total, each formatted to a practitioner-grade convention: blue for inputs, black for calculations, green for cross-sheet links, red for check figures, gold-shaded for key outputs. Every tab is print-ready with landscape page setup on wide tables, print titles that repeat headers, freeze panes, and a Baratelli brand strip footer.
Workbook 1 · Financials 13 tabs
Tab 01
Assumptions
Global rate deck — Section 7520, AFR (short/mid/long), state estate thresholds, portfolio return assumptions. All formulas flow from here.
Tab 02
Prior Period BS
Opening balance sheet baseline for roll-forward. Entity-by-entity and consolidated columns.
Tab 03
Balance Sheet
Consolidated across operating entities, trusts, foundations, and DAF. Intercompany column reconciles.
Tab 04
Income Statement
Investment income, K-1 pass-through, trust income, deductions. Full-year and quarterly views.
Tab 05
Cash Flow
Indirect method reconciling to bank. Operating / investing / financing split. Cash tie check figure.
Tab 06
Intercompany
Elimination worksheet for entity-to-entity flows. Sums to zero after elimination — check figure highlighted.
Tab 07
Household Budget
Principal residence, second homes, staff payroll, travel, education, philanthropy commitments.
Tab 08
Wire Log
All wires in/out with counterparty, entity, purpose, authorization trail. Filter-ready.
Tab 09
Gift Log
Annual exclusion, lifetime exemption, Crummey letters, 529 contributions. Rolls to 709 preparation.
Tab 10
Manager Scorecard
Investment manager rankings on returns, drawdown, fees, tax efficiency, service. Quarterly rolls.
Tab 11
IPS Test
Investment Policy Statement compliance test: allocation bands, liquidity floor, concentration limits.
Tab 12
Foundation Compliance
Private foundation 5% MDP calc, self-dealing register, excess business holdings screen.
Tab 13
DAF Register
Donor-advised fund grants log, sponsor account balances, grant recommendations pending.
Workbook 2 · Trust & Estate 15 tabs
Tab 01
Cover & TOC
Section-organized hyperlinked table of contents; style guide legend.
Tab 02
Assumptions
Section 7520 rate, AFR, mortality assumptions, term inputs. All calcs link here.
Tab 03
GRAT Calculator
Zeroed-out grantor retained annuity trust. Annuity stream, remainder, Walton mechanics, rolling-GRAT ladder.
Tab 04
ILIT Premium Schedule
Irrevocable life insurance trust: premium calendar, Crummey notice log, gift-tax exclusion tracking.
Tab 05
IDGT Installment Sale
Intentionally defective grantor trust sale-to-trust: seed gift, note terms, amortization, grantor income tax burn.
Tab 06
Dynasty Trust GST
Generation-skipping mechanics, GST exemption allocation, inclusion ratio, multi-generation NPV.
Tab 07
QPRT Calculator
Qualified personal residence trust: term, retained interest, gift value, mortality-adjusted outcomes.
Tab 08
CRT / CLT Calculator
Charitable remainder and lead trusts. CRAT / CRUT / CLAT / CLUT variants with income and remainder splits.
Tab 09
Estate Tax Projection
19-state map: state estate/inheritance thresholds, cliff vs. exemption structure, portability model.
Tab 10
Estate Checklist
Death-day-forward: 706 timing, alternate valuation, portability election, disclaimers, 6166 election screen.
Tab 11
K-1 Tracker
Per-entity K-1 basis, at-risk, and PAL suspended loss tracking. Multi-year roll with reconciliation to 1040.
Tab 12
Regulatory Calendar
27 filings: 1040, 1041, 1065, 1120S, 706, 709, 5227, 990-PF, FBAR, 8938, 5471, 5472, CTA BOI, states. Monthly calendar view.
Tab 13
Multi-Class Voting
Class A / Class B voting power model. Dilution, protective provisions, family control preservation.
Tab 14
Style Guide
Color code, number format reference, page setup conventions.
Tab 15
Sources
IRS, Treasury regs, state statutes, and Baratelli case-study anchors cited for every calculation.
Workbook 3 · Governance & Assets 17 tabs
Tab 01
AI Readiness
Family-office AI adoption scorecard: data hygiene, use cases, controls, staff training.
Tab 02
FO Assessment
Single-family vs. multi-family vs. embedded assessment across 40 dimensions.
Tab 03
Vendor Scorecard
Attorney, CPA, IB, custodian, trust company scorecard. Weighted by service, price, responsiveness, risk.
Tab 04
Staff Inventory
Roles, comp bands, cross-training coverage, succession risk. Whole-office roster view.
Tab 05
Cyber Readiness
NIST-anchored family-office cyber checklist: identity, endpoint, wire fraud controls, incident response.
Tab 06
Next-Gen Tracker
Family member roster with education, engagement, seat readiness, mentoring assignments.
Tab 07
Real Estate Register
Every property: address, entity, mortgage, appraisal, insurance, tax cost, current FMV.
Tab 08
Art Register
Artist, work, provenance, appraisal date, insurer, location, entity holder, disposition intent.
Tab 09
Jewelry Register
Piece, appraisal, insurance schedule, storage, heir intent.
Tab 10
Wine Register
Cellar inventory: producer, vintage, quantity, storage, cellar tracker link, insured value.
Tab 11
Watches Register
Reference, serial, papers, service history, appraisal, insurance, heir intent.
Tab 12
Automobiles Register
VIN, title entity, registration, storage, market value, insurance carrier.
Tab 13
Aircraft Register
Tail number, ownership entity, hours, maintenance schedule, part 91 vs. 135 status, insurance.
Tab 14
Insurance Register
Every policy: carrier, coverage, premium, renewal, ownership entity, beneficiary.
Tab 15
Other Assets
Instruments, firearms, sports memorabilia, digital assets, crypto wallets, custody notes.
Tab 16
Dashboard
One-page family-office dashboard: net worth roll-up, liquidity, upcoming filings, cash calls, alerts.
Tab 17
Instructions
How to use each register, refresh cadence, permissioning, retention.
And an 85-page methodology PDF
The companion methodology document walks through the calculations tab-by-tab across 15 chapters — what each model is for, the line-by-line mechanics, common pitfalls, and the family-office context (who signs, who reviews, how it hits the K-1). Case-anchored to the Baratelli Institute's Belron, Comcast, LVMH, and Samsung case studies where relevant.
The Baratelli difference
Practitioner Tips — senior-partner-to-analyst voice
Every one of the 15 methodology chapters closes with a Practitioner Tip callout — senior-partner-to-analyst voice, teaching what to do with the model's output, not just how to build it.
Any planning book will teach you how to construct a GRAT, an ILIT, an IDGT sale. Almost none teach you what happens next — what a senior partner asks in the annual review, which assumptions actually move the transfer-tax answer, how to communicate to a founder or a next-gen board, when to trust the output and when to override it. That interpretation layer is the difference between a technician who can populate cells and a practitioner who can advise.
GRAT
You got a zeroed-out gift with a $12M projected remainder. Compare to rolling-GRAT ladder alternative. Which assumption moves the answer most (asset return above 7520 rate). When to trust it, when to stack multiple short-term GRATs instead.
IDGT Installment Sale
You got a $40M transfer at 9% AFR. What the "grantor tax burn" really costs on cash flow. When the sale beats a straight GRAT. How to explain the seed-gift ratio to a founder who's never heard of it.
Dynasty Trust GST
You allocated $14M GST exemption for a projected multi-generation NPV. Which states allow perpetuities. When to layer in decanting flexibility. What a next-gen review committee will actually ask.
Estate Tax Projection (19-state)
You showed $8M projected state estate tax in Massachusetts. Cliff vs. exemption structures matter. When domicile change actually saves the money. How to model portability for the surviving spouse.
K-1 Tracker
You caught a $2.3M PAL suspended loss the prior CPA missed. Why basis and at-risk are different and when it matters. How to communicate to the family that a "loss" on the K-1 may be usable this year.
Every chapter
All 15 chapters — from GRAT and ILIT through K-1, regulatory calendar, and governance — carry a Practitioner Tip. Interpretation, communication, senior-partner catches, common committee questions.
The Practitioner Tips are the feature that turns the Toolkit from a template package into a decision-support reference. They're the reason to buy this over any collection of trust calculators you could assemble yourself.
The floor and the sheet
The Toolkit and the Family Office Reference Guide are designed to work together. Buy the Toolkit if you need working templates today. Buy the Guide if you need the practitioner reference behind them. Buy both if you're running a real seat.
The floor · $99
Family Office Toolkit
45 working Excel tabs plus 85-page methodology PDF. What you do.
- Six trust calculators (GRAT / ILIT / IDGT / Dynasty / QPRT / CRT-CLT)
- Consolidated 3-statement across entities
- K-1 basis / at-risk / PAL tracker
- 27-filing regulatory calendar
- 10-register asset tracker
- Governance templates (AI, cyber, vendor, staff)
- Practitioner Tip in every methodology chapter
The sheet · $449
Family Office Reference Guide
What the Guide adds on top of the Toolkit. What you know.
- Case law: Wandry, Petter, Powell, Estate of Levine, Cavallaro
- Specimen trust language: Crummey notice, defined-value clause, decanting provisions
- Deeper QPRT mechanics: renting-back structure, mortality risk mitigation
- Deeper ILIT mechanics: split-dollar, ITR, premium financing
- Post-mortem planning: 6166 election, alternate valuation, disclaimers, portability late-election reg
- Partner tax deep dives: 754 elections, hot assets, disguised sale, mixing bowl
- Governance narrative: family constitution, IPS drafting, next-gen education
See the Guide at /guide-fo ($449). Toolkit + Guide bundle discount available at checkout.
Pricing — Personal and Enterprise
The Toolkit is available under four licenses. Every tier includes the full 45-tab bundle across three workbooks and the 85-page methodology PDF. Enterprise SKUs (10-seat and above) add quarterly rate updates and priority support.
| Tier |
Price |
Best for |
Includes |
| Personal |
$99 |
Solo practitioner, one-family office |
Full toolkit, personal use license |
| Firm 10-seat |
$299 |
Small CPA / law firm, boutique RIA |
10 named users, quarterly update rights |
| Firm 25-seat |
$599 |
Mid-size firm, growing MFO |
25 named users, quarterly updates, priority email support |
| Firm Unlimited |
$1,499 |
Large firm / enterprise |
Unlimited users at one firm, quarterly updates, priority support, white-label rights |
Enterprise SKUs include quarterly rate updates (§7520, AFR, state estate tax thresholds) and are licensed per-firm. Contact philbaratelli@gmail.com for enterprise onboarding.
Who this toolkit is for
USE 1
Family Office CFO
Running the CFO seat — consolidated financials, K-1 season, trust-funding decisions, regulatory calendar. This is your working desk.
USE 2
Trust & Estate Attorney
Modeling client scenarios before drafting: GRAT ladder vs. IDGT sale, Dynasty allocation, QPRT term selection, CRT/CLT variants.
USE 3
CPA with UHNW Clients
K-1 basis and PAL tracking that Lacerte/ProConnect don't roll cleanly; state estate projection; 706/709/5227/990-PF calendar view.
USE 4
RIA Building an MFO Practice
Standing up multi-family office capabilities: IPS testing, manager scorecard, foundation compliance, DAF register, asset registers.
USE 5
Single-Family Office Principal
One-page dashboard on net worth, liquidity, filings due, cash calls, and asset inventory across all vehicles — the seat you actually need.
Companion pillar
The Toolkit is what you do. The Guide is what you know.
The Family Office Reference Guide is the deeper practitioner methodology behind the Toolkit — case law, specimen trust language, deeper mechanics on QPRT / ILIT / post-mortem planning, and partner-tax deep dives. Practitioners who bought the Toolkit tend to add the Guide after their first live season.
Family Office Reference Guide — $449 →
How the models are anchored
The methodology PDF references the Baratelli Institute's own family-office case studies as worked examples. If you already own the case files, the templates plug directly into those scenarios. If you don't, the case studies are freely available on the site.
Related guides
The Toolkit is a working set of templates. If you want the underlying practitioner narrative — the checklist for the trust funding, the K-1 review discipline, the fractional-family-office setup — these guides carry the framework.
Baratelli Family Office Toolkit
$99
Personal license · 45-tab three-workbook Excel bundle + 85-page methodology PDF · Compatible with Excel, Google Sheets, Numbers
- Workbook 1 — Financials (13 tabs): consolidated 3-statement, intercompany, household budget, wire/gift logs, IPS test, foundation compliance, DAF register
- Workbook 2 — Trust & Estate (15 tabs): GRAT, ILIT, IDGT, Dynasty (GST), QPRT, CRT/CLT calculators; 19-state estate projection; K-1 tracker; 27-filing regulatory calendar; multi-class voting
- Workbook 3 — Governance & Assets (17 tabs): AI readiness, FO assessment, vendor scorecard, staff inventory, cyber readiness, next-gen tracker; 10 asset registers (real estate, art, jewelry, wine, watches, automobiles, aircraft, insurance, other); dashboard
- 85-page methodology PDF with 15 chapters, each closing with a Practitioner Tip callout in senior-partner-to-analyst voice
- Color-coded to convention, print-ready formatting, freeze panes on every tab
- Free updates to future editions on the Personal tier; quarterly rate updates on Enterprise tiers
- Companion to the $449 Family Office Reference Guide — the Toolkit is what you do; the Guide is what you know
Buy on Gumroad →
See enterprise tiers →
About the author
PB
Philip A. Baratelli, CPA, MBA — Founder, Baratelli Institute. Ponte Vedra Beach, Florida.
Three decades in operating finance, M&A, and family-office CFO work (CPA since 1995, MBA). Sat in the family-office CFO seat on live trust funding, K-1 season, and multi-entity consolidation across single-family and multi-family structures. The Toolkit is the mentoring at scale — the trust calculator, the K-1 tracker, the regulatory calendar, the asset register — that used to happen in person with an analyst next to the model. The Reference Guide is the underlying narrative: what the senior partner tells the analyst before the call with the founder.
Educational references and tools — not legal, tax, accounting, or investment advice, and not a recommendation to buy or sell any security. The Baratelli Institute operates under the Lowe v. SEC publisher exception (472 U.S. 181, 1985). Consult a qualified professional about your specific situation.
