# The Funeral Home Owner: companion files

Julian R. Sterling

## What is here

- **FuneralHome_1_Arrangement_Statement.xlsx** (Chapter 5; Workbook 1 of Appendix A): tabs Inputs, Statement, Checks. The statement the family receives at the end of the arrangement conference: services, merchandise, cash advance items kept apart, the deposit and the balance (an FY2026 traditional burial: goods and services $10,405, total $12,655, balance $7,452).
- **FuneralHome_2_Mix_and_Average_Revenue.xlsx** (Chapter 2; Workbook 2): tabs Inputs, Mix, Checks. The mix of at-need calls by type and the average revenue per at-need call (FY2026: 251 at-need calls, $6,363 each on average).
- **FuneralHome_3_Preneed_Price_Gap.xlsx** (Chapter 7; Workbook 3): tabs Inputs, Gap, Checks. The price gap of one guaranteed preneed contract and the position of the trust against the contracts it funds (a gap of $1,319 on one contract; trust surplus $95,548).
- **FuneralHome_4_Director_Capacity.xlsx** (Chapter 9; Workbook 4): tabs Inputs, Capacity, Checks. One week's calls turned into director hours, set against the hours the directors can give (week 67: 220 hours needed for 180, $2,400 of contract director hours).
- **FuneralHome_5_Crematory_Own_or_Outsource.xlsx** (Chapter 12; Workbook 5): tabs Inputs, Crematory, Checks. The cost of cremating in-house beside the crematory's fee for the same year (FY2026: in-house $64,569, outsourced $72,775).
- **FuneralHome_6_Receivables_and_the_Line.xlsx** (Chapter 14; Workbook 6): tabs Inputs, Line, Checks. Receivables by age, the borrowing base, availability on the line and interest (27 September 2026: base $111,431, availability $31,431).
- **FuneralHome_7_Sale_Price.xlsx** (Chapter 16; Workbook 7): tabs Inputs, Price, Checks. The letter of intent's price, from EBITDA to the amount paid at closing (enterprise value $3,835,134; paid at closing $2,878,836 before taxes and fees).
- **Funeral_Home_Owner_Toolkit.docx**: the 8 check-lists of Appendix B, editable, with a box to tick before each item (Price list review (chapters 3 and 4); The arrangement statement before the family leaves (chapter 5); Cash advance items (chapter 5); Preneed sales and the trust (chapters 6 and 7); Weekly receivables review (chapters 8 and 14); Director capacity and on-call (chapter 9); The embalming room under the formaldehyde standard (chapter 10); Before answering a letter of intent (chapters 15 and 16)).

## How to use the workbooks

Every workbook opens on its Inputs tab: blue type on a light blue background is an input, and nothing else is typed by hand. The subject tab is read top to bottom, one result per line. Black type is a formula, green type a figure read from another tab of the same workbook. The Checks tab holds the checks of Appendix A: each one is an IF test on your own inputs that shows OK or CHECK, and a last line shows OK only when every check above it does. A comparison between two results (in-house against outsourced, hours needed against capacity) is a result, never a check.

The arithmetic is plain: the only functions are SUM, ROUND, MIN, MAX, IF and AND. No date is used anywhere: a week, a fiscal year or an aging bucket is a label. Shares and rates are typed in percent (50, not 0.5), and every division by an input that can be zero is wrapped in IF and shows 0 instead of an error. An empty input reads as zero in a sum, a product or a comparison, but a MIN over a range skips it: the "no negative" checks therefore pass on an empty cell. The last section of Appendix A lists, workbook by workbook, what the checks do not catch.

To use a workbook on your own home, start with a copy, replace every blue input from the record that owns each figure (the General Price List, the arrangement statements, the trust schedule, the payroll and the schedule of directors, the crematory's quote and invoices, the aging and the signed line agreement, the letter of intent), keep every check at OK, and compare a result only with the same home's own earlier weeks and years. Never edit a formula to turn a CHECK into OK.

The workbooks are separate files with no link between them: a figure two workbooks share (the price gap of the open trust contracts, a result of workbook 3 and an input of workbook 7) is typed again where it is used.

## A word of caution

Orlanmere Funeral Home, Inc., the town of Tessendry, Pendrilow Life, Fenwarrow Crematory, Hesterlyn Community Bank and every party in the case are fictional. Prices, costs, counts, hours, wages, trust and policy figures, payment terms, line terms and multiples are teaching assumptions, not market norms or recommendations, and not a statement of any rule or law. What the Funeral Rule requires is for its current text; what a state allows for preneed, licensing and permits is for counsel in the home's state and the state board; taxes are for the outside CPA. The files are provided as they are, without warranty of any kind.
