Funeral Home Model

Operating Businesses Financial Model (Free Excel Download)

Plan funeral-home economics through service volume, average revenue, merchandise mix, staffing, facility costs, pre-need contracts, acquisitions, and operating cash flow.

Loading...

Used by professionals from

KPMG logoWharton logoColumbia logoESSEC logoPwC logoHEC logo

About this model

This model helps you understand a funeral home across traditional services, cremations, memorials, merchandise, and pre-need arrangements. It connects case volumes and family choices to the staff, facilities, vehicles, and service costs required to provide care.

Use it to assess an acquisition, an expansion, or a change in service mix. Test local demand, pricing, pre-need sales, and operating costs to understand the effect on cash flow and value.

What every model includes

Live formulas, no hardcoded values

Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.

All assumptions in one tab

Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.

Statements always balancing

For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.

Distinct schedules for clarity

Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.

No hidden macros or external links

There are no unexplained external workbook links or macros to undermine auditability or portability.

Changes flow through the model

Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.

What's inside the Funeral Home Model

  • Network inputs: Year-1 locations, new locations per year, calls per location, directors per location, average case fee
  • Disposition mix: traditional-burial, cremation-with-service, direct-cremation, and memorial-other shares of funeral cases
  • Fee indices and gross margins: per-segment fee index off the average case fee and a gross margin (the merchandise spread)
  • Cemetery and pre-need: interments per location, average interment price, pre-need trust income per case, price escalation
  • Cost structure: director comp, support per location and wage, benefits, wage growth; facilities and fleet, marketing, technology, and corporate SG&A as % of gross profit; depreciation (% of revenue); tax
  • Capital and working capital: maintenance capex %, acquisition cost per location, NWC % of revenue growth, base-year revenue
  • Valuation: WACC, terminal growth, net debt, shares outstanding
  • Dashboard with KPI cards, a seven-year operating summary, trend charts, a revenue-to-net-income waterfall, and key location, case, margin, valuation, and revenue-mix metrics

What the Funeral Home Financial Model Shows About Volume, Mix and Value

This funeral home financial model translates location growth, case volumes and service mix into revenue, profit and value. It captures how acquired homes integrate slowly, how cremation shifts reduce average revenue per case, and how pre-need income and cemetery property contribute.

Use it to assess acquisitions or service-mix changes.

Operating drivers: locations, cases and utilisation

The estate grows by acquiring a set number of locations each year, so closing locations equal opening locations plus new additions. Each location serves a mature number of calls, or cases, based on local demand and market position.

  • Calls per location are calls per location multiplied by an effective utilisation factor. Total funeral cases then equal closing locations times calls per location.
  • The seasoned utilisation curve starts at a Year 1 input and ramps annually to a practical ceiling, representing improved systems and marketing reach. Newly acquired homes run at a reduced first-year productivity share of the seasoned rate, because integration takes time.

Revenue build: disposition mix, cemetery and pre-need

Funeral service revenue is built segment by segment: total funeral cases times each disposition share times the average case fee times that segment's fee index, escalated by price. Disposition shares cover traditional burial, cremation with service, direct cremation and memorial or other services.

  • A traditional burial carries a fee index above one, while direct cremation sits far below, so the blended revenue per case depends on the mix. Cemetery property adds closing locations times interments per location times average interment price.
  • Pre-need trust and insurance income is modelled as a flat per-case fee, layered on top.

Cost stack and margin dynamics

Merchandise and direct service cost is calculated per funeral segment as segment revenue times one minus the segment gross margin. Caskets, vaults and urns carry real product cost, while services are higher margin.

  • Funeral director and support labour are headcount-driven: full-time equivalents per location times wage, loaded for benefits and escalated by wage growth. Facilities and fleet, marketing, technology and corporate SG&A are set as percentages of gross profit, not revenue, because death care is a high-gross-margin business.
  • As utilisation and price escalation lift gross profit while labour grows only with headcount and wage inflation, the EBITDA margin expands modestly.

Free cash flow, valuation and dashboard outputs

Unlevered free cash flow is NOPAT plus depreciation, less maintenance capex and acquisition capex, less the change in working capital. Acquisition capex is the dominant call on cash because the location pipeline is bought rather than built, and working capital is a light drag since families pay quickly.

  • The DCF discounts explicit free cash flows at WACC and adds a Gordon-growth terminal value to get enterprise value. Net debt is subtracted for equity value and value per share.
  • A dashboard summarises locations, funeral cases, utilisation, revenue, EBITDA, enterprise value and value per share.
income_statement.xlsx
Income statement, brown brand palette
income_statement.xlsx
Income statement, green brand palette
income_statement.xlsx
Income statement, red brand palette

Formatted to IB standards

Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.

Alex Tapio, ex-Deloitte financial modelling expert

Created by ex-finance professionals

Hey, I’m Alex and I created Finamodel.

Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.

Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.

I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.

Having a template library on hand cuts a first build from hours to minutes.

Need help finding your model? You’ll find me in the Finamodel app!

Frequently asked

What is a funeral-home model?+

A funeral-home model captures the seven-year operating economics and intrinsic value of a multi-location death-care operator (funeral homes plus cemetery and pre-need). It rolls a location count forward, seasons newly acquired homes with a case-volume utilisation ramp, splits funeral cases across a traditional-burial, cremation-with-service, direct-cremation, and memorial mix priced off a blended average case fee and a per-segment fee index, layers cemetery property and pre-need trust income, nets merchandise cost into gross profit, runs the cost stack to EBITDA, and discounts an unlevered free-cash-flow stream to enterprise value, equity value, and value per share.

Why does the disposition mix matter so much?+

The disposition mix is the split of funeral cases across traditional casketed burial, cremation with a service, direct cremation, and memorial-other. Each has a different fee index and gross margin. As lower-priced direct cremation takes share from traditional burial, revenue per case can fall even when case volumes grow. The model keeps segment fee indices and gross margins explicit so changes in mix flow through revenue, gross profit, and EBITDA margin.

How is funeral-home revenue built?+

Revenue starts with volume: total funeral cases equal closing locations times calls per location, where calls per location equal mature calls times a utilisation factor that ramps over time. Funeral service revenue is then the sum across dispositions of funeral cases times each segment share times the average case fee times its fee index, escalated at a step-up rate. Cemetery property and merchandise and per-case pre-need trust and insurance income layer on top to total revenue.

Why an unlevered DCF for a funeral-home operator?+

Death care is a defensive, low-beta, recession-resilient business, but the bulk of estate growth is bought rather than built, so acquisition capex is the dominant call on cash and EBITDA overstates free cash flow in expansion years. The model bridges to unlevered free cash flow, NOPAT plus depreciation, less maintenance and acquisition capex, less the change in working capital, and discounts it at a low WACC with a Gordon-growth terminal value. The implied EV/EBITDA falls out as a sanity check rather than as the valuation input.

Can I model a single funeral home or a cemetery-only operator?+

Yes. For a single home, set the estate to one location and size the calls per location, disposition mix, and headcount to that market; for a cemetery-led operator, lift the interments per location and average interment price and let the funeral case lines run light. The net-debt line already bridges enterprise value to equity value, so a financing layer slots in cleanly.

How is the utilisation ramp modelled?+

Utilisation starts at the Y1 input and steps up by a fixed number of percentage points each year, capped at a practical ceiling. Newly acquired homes integrate slowly and no estate realises full mature volume immediately. Closing locations times calls per location times utilisation gives total funeral cases, which is the primary volume driver in the model.

Why is overhead expressed as a percentage of gross profit rather than revenue?+

Death care runs high gross margins (around 74% in the defaults), so the cost of operating chapels, preparation rooms, and a vehicle fleet scales with gross profit, not top-line revenue. Using gross profit as the base correctly weights overhead against operating capacity, and means EBITDA margin expands as the utilisation ramp lifts gross profit faster than per-location headcount.

What drives acquisition capex and how is it treated in the DCF?+

Acquisition capex equals new locations per year multiplied by the acquisition cost per location. It is separated from maintenance capex (a percent of revenue) in the FCF bridge so the cash drag of the roll-up programme is explicit. Both reduce UFCF before discounting, and the low WACC reflects the defensive, recession-resilient demand profile of death-care services.

What are the headline outputs from the default assumptions?+

With the default inputs the model runs from 49 to 73 locations and approximately 14,065 to 22,320 funeral cases over 7 years. Y1 revenue is approximately $119.5M growing to approximately $217.2M by Y7. Blended gross margin runs approximately 74%, EBITDA margin approximately 24.5%, enterprise value approximately $350.7M, and value per share approximately $17.38 at an implied EV/EBITDA of approximately 12.0x.

Have more financial modelling questions? Contact us

Go further

Build the financial model you need with Fina

Browse templates, examples, and downloadable Excel models for the analysis you are trying to build. If you can't find your model, ask Fina to build a model for your specific needs.

Start for free
Excel financial model spreadsheet preview showing Customer Rollforward
Fina interactive chat interface preview