# The Tax Preparation Business Owner: companion files

Julian R. Sterling

## What is here

- **Tax_Preparation_Business_Owner_Model.xlsx**: the workbook that rebuilds the Pellowmere case and reproduces the figures of the book with live formulas. Sheets: Inputs, Clients and Fees, Season, P&L, Pricing, Diligence, Growth, Bookkeeping, Franchise, Book Purchase, Valuation, Checks.
- **Tax_Preparation_Business_Owner_Toolkit.docx**: the 8 checklists of Appendix B (opening an office; pTINs and AFSP for everyone who prepares; the e-file application and its updates; before the first return of the season; the due diligence file for each credit return; the WISP and daily security; refund products, consents and advertising; buying a client list), in editable form.

## Which sheet answers which chapter

- Chapter 5: Clients and Fees (1,445 returns in the 2026 season, preparation fees $432,450, average fee 275.14 dollars an individual return, the contribution of each return type)
- Chapter 6: Pricing (fees up 8 percent, 5 percent of clients lost: owner's earnings $225,766; the rise stops paying beyond 10.6 percent of clients lost)
- Chapter 7: Season (the cash calendar month by month; $36,604 to hold at the end of October)
- Chapter 8: P&L (revenue $511,250, costs $303,461, owner's earnings $207,789, 40.6 percent)
- Chapter 10: Diligence (50 failures cost $32,500 at the amount for returns filed in 2026)
- Chapter 13: Growth (the office carried to 2031, owner's earnings $292,713) and Bookkeeping (twelve more monthly clients add $11,800)
- Chapter 14: Franchise ($159,925 as a franchise against $223,955 independent in 2027)
- Chapter 15: Book Purchase (Corrisdale priced at $110,400, $98,569 paid at 85 percent retention, cash positive in the 2029 season)
- Chapter 16: Valuation ($511,250 at 1.0x revenue, $519,472 at 2.5x owner's earnings, $434,754 received on a retention-based sale)
- Appendix A: 14 exercises, with the answers the workbook returns

## Two inputs to change first

1. On Inputs, lower individual retention from 88 percent to 85 percent: watch 2031 owner's earnings on Growth.
2. On Inputs, lower Corrisdale's retention from 85 percent to 75 percent: watch what is paid to the seller on Book Purchase. Reset the inputs afterwards: the Checks sheet compares the workbook with the figures printed in the book.

Blue type on a light blue background is an input, black type a formula, green type a link to another sheet. Every input is on the Inputs sheet. No macro, no circular reference, no external link. The Checks sheet should read ALL CHECKS OK on the default inputs. Amounts are in US dollars, rounded to the dollar as in the book.

Pellowmere Tax Services, Corrisdale Tax Office and the franchise offer are fictional; fees, return counts, staff costs, retention, franchise terms, multiples and payment terms are teaching assumptions, not market fees, market multiples or market data. PTIN and penalty amounts are the real IRS amounts read in November 2026 and change every year: check the current figures. Provided as is, without warranty. Not legal, tax, accounting or investment advice, and no tax advice on any return.
