Companion files · The Private Markets Career Guides
Funeral Home Business by the Numbers: Calls and the Cremation Mix, the General Price List and the Funeral Rule, Preneed Trusts and Policies, Directors, Cash and What It Is Worth.
These are the companion files of the book. Seven workbooks follow Orlanmere Funeral Home, the fictional funeral home of the case, across two fiscal years: the arrangement statement, the mix and average revenue, the preneed price gap, director capacity, the crematory own or outsource choice, receivables and the line of credit, and the sale price. A toolkit holds the check-lists of Appendix B in editable form.
The archive holds the seven workbooks, the toolkit and 00_START_HERE.md. No macros, no date functions, no links between files, no password; the only functions are SUM, ROUND, MIN, MAX, IF and AND. The workbooks recalculate in Excel, LibreOffice or Google Sheets.
Chapter 5
The statement the family receives at the end of the arrangement conference: services, merchandise, cash advance items kept apart, the deposit and the balance. Tabs: Inputs, Statement, Checks. An Inputs tab holds every number; a Checks tab holds the checks of Appendix A.
Download workbook 111 KBChapter 2
The mix of at-need calls by type, the cremation share of at-need calls and the average revenue per at-need call. Tabs: Inputs, Mix, Checks. An Inputs tab holds every number; a Checks tab holds the checks of Appendix A.
Download workbook 211 KBChapter 7
The price gap of one guaranteed preneed contract, the trust surplus and the price gap of the open contracts. Tabs: Inputs, Gap, Checks. An Inputs tab holds every number; a Checks tab holds the checks of Appendix A.
Download workbook 311 KBChapter 9
One week’s calls turned into director hours, set against capacity, and the cost of a contract director for the hours above it. Tabs: Inputs, Capacity, Checks. An Inputs tab holds every number; a Checks tab holds the checks of Appendix A.
Download workbook 411 KBChapter 12
The cost of cremating in-house beside the crematory’s fee for the same year, and the break-even. Tabs: Inputs, Crematory, Checks. An Inputs tab holds every number; a Checks tab holds the checks of Appendix A.
Download workbook 511 KBChapter 14
Receivables by age, the borrowing base, availability on the line of credit and interest. Tabs: Inputs, Line, Checks. An Inputs tab holds every number; a Checks tab holds the checks of Appendix A.
Download workbook 611 KBChapter 16
A letter of intent’s price: adjusted EBITDA, enterprise value, the preneed deduction, the holdback, the working capital peg and the amount paid at closing. Tabs: Inputs, Price, Checks. An Inputs tab holds every number; a Checks tab holds the checks of Appendix A.
Download workbook 711 KBAppendix B
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).
Download the toolkit43 KBRead first
What each file holds, which workbook answers which chapter, and how to use the workbooks on your own business.
Download the read-me5 KB| The statement | An FY2026 traditional burial: goods and services $10,405, cash advance items $2,250, deposit $5,203, balance $7,452 |
| The mix | FY2026: 251 at-need calls, 60.2 percent cremations among them, average revenue per at-need call $6,363 |
| The sale price | Adjusted EBITDA $697,297 x 5.5 = $3,835,134; paid at closing $2,878,836, before taxes and fees |
The files are provided as they are, without warranty of any kind. The model is illustrative: Orlanmere Funeral Home, Tessendry and every party are fictional, and the prices, costs, counts, hours, trust and policy figures, payment terms, line terms and multiples are the book’s assumptions, not market terms or the practice of any real home, crematory, insurer, trustee, bank or buyer. Rules change: check the current texts, counsel in the home’s state, the state board, the outside CPA and the insurance agent before relying on any of them.