Hospice Care Startup Financial Model Template

Five-year projections. Three scenarios. Every statement. One Excel file.
Hospice Care Financial Model overview showing the model’s key sections and purpose: summarizes KPIs, cash runway, staffing and cost drivers, and helps plan funding and operational forecasts.
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Hospice Care Financial Model overview showing the model’s key sections and purpose: summarizes KPIs, cash runway, staffing and cost drivers, and helps plan funding and operational forecasts.
Industry Benchmarks
Projected balance sheet
Capital expenditure plan
Capitalization table
Cash flow forecast
Financial charts
COGS & Operating expense forecast
Financial model dashboard
DuPont analysis
Projected income statement
Payroll forecast
Financial ratio analysis
Return on invested capital analysis
Revenue forecast
Financial scenario analysis
Sources and uses of funds
Financial model summary
Top expense analysis
Top revenue streams
Business valuation analysis
Fully Editable
Instant Download
Professional Design
Pre-Built
No Expertise Is Needed
Hospice Care Bundle
See included products:
Financial Model iHospice Care Bundle Financial Model template included in this product.
$149 $109
ADD TO YOUR ORDER
Business Plan iHospice Care Bundle Business Plan template included in this product.
$79 $59
Pitch Deck iHospice Care Bundle Pitch Deck template included in this product.
$49 $29
YOU SAVE $0 TODAY
30-Day Money-Back Guarantee
Created by a Former CFO
Updated for 2026
One-Time Purchase
Description

The Hospice Care Financial Model is an Excel template for planning an independent US home hospice. It connects staffed census capacity, utilization, care mix and estimated net daily rates with staffing and operating costs to build financial projections for 2026–2030.

The illustrated case assumes existing Medicare enrollment and certification, a leased 2,000-square-foot administrative office and contracted inpatient and respite beds. All selected assumptions and results describe an estimated planning case; the documented operating forecast ends at EBITDA.

Forecast
5years
Care categories
5exclusive day types
Receivables
45days assumed
WORKBOOK CONTENTS

Editable Inputs Connect Census to Financial Reports

The workbook connects hospice operating assumptions with monthly calculations, financial statements and management reports.

Revenue & Calc

Edit staffed daily places, utilization, care-level mix, net rates and launch timing; Revenue and Calc translate these inputs into monthly patient days and revenue across 60 forecast months.

COGS & OPEX and Payroll

Plan medicines, equipment, contracted care, field travel and salaried roles separately, then assess how changes in clinical coverage, expense rates and fixed overhead affect operating earnings.

Dashboard and Scenarios

Set Low, Base and High multipliers for revenue, COGS, variable expenses, fixed expenses and payroll on Dashboard; Scenarios compares operating margins and EBITDA under those selections.

Statements and Review Reports

IS, CF and BS provide financial statement views, while Summary combines them for review; Checks tests reconciliations and input consistency without guaranteeing that assumptions will be achieved.

REVENUE FORECAST

Revenue Comes From One Patient-Day Pool

Staffed places, utilization and the exclusive care mix determine the hospice revenue forecast.

Monthly patient days equal staffed daily places × 365/12 planning days × utilization. Allocate that pool once across five categories, then multiply each allocation by its selected net daily rate; this avoids counting the same capacity more than once.

Staffed places increase from 30 in 2026 to 90 in 2030, while utilization rises from 50% to 80%, producing average daily census of 15 and 72. Utilization is an input, with no separate demand limit or patient-cohort progression schedule.

Revenue Forecast

The Revenue Forecast shows operating drivers, patient-day volumes and revenue by care category. Changing capacity, utilization, mix or price helps evaluate how much revenue the staffing plan must support.

hospice care financial model revenue fml30
Estimated care mix and net daily rates throughout 2026–2030
Care category Share of days Net rate per day
Routine care, days 1–60 40% $225
Routine care, day 61 onward 57.5% $178
Continuous home care 1% $820
Inpatient respite care 0.5% $522
General inpatient care 1% $1,176

The mix totals 100% and yields an estimated blended rate of $214.92 per patient day; these selections are planning assumptions, not verified reimbursement quotes.

2026 illustrative annual revenue

30 staffed places × 365 planning days × 50% utilization × $214.92 blended daily rate = $1,176,687.

The January 31, 2026 launch input receives full January activity under the model’s timing convention, with zero revenue in earlier months. Calculations use 365/12 days per month; the displayed 30.42 is rounded.

COSTS AND STAFFING

Care Costs and Staffing Determine EBITDA

The operating forecast deducts direct care costs, variable expenses, fixed overhead and payroll from revenue.

COGS and Operating Expenses

The COGS & Operating Expense Forecast separates direct care costs, variable spending and fixed overhead. Estimated direct costs total 23% of revenue, including medicines, consumables, equipment, purchased beds, crisis nursing, therapies, transport and diagnostics.

hospice care financial model cogs opex fml30

Variable expenses total 6.2% of revenue: field travel at 3.5%, outreach materials at 1.5% and billing services at 1.2%. Fixed expenses remain $189,600 annually, including a $3,500 monthly office lease plus insurance, software, medical direction and administrative support.

Payroll Forecast by Staff Role

The Payroll Forecast calculates personnel costs from role-level FTE, compensation and employment dates. The case increases RN case managers from 2 to 7.2 annual-average FTE and field aides from 2 to 7.5 FTE between 2026 and 2030.

hospice care financial model payroll fml30

Annual payroll rises from $737,000 to $1,969,000 and includes the paid working administrator. Employer taxes and benefits are excluded from this case; direct labor already included in COGS is not counted again in payroll.

OPENING INVESTMENT

Opening Funding Covers Assets and Operating Reserves

The estimated $609,058 owner contribution covers opening investment and reserves separately from annual operating expenses.

Capital Expenditure Plan

The Capital Expenditure Plan schedules asset purchases and depreciation. Listed startup assets total $70,000: secure technology at $28,000, furniture at $12,000, qualifying office improvements at $18,000 and durable clinical assessment kits at $12,000.

hospice care financial model capex fml30

Separate opening cash items include the refundable deposit, software implementation, contracting, prelaunch onboarding, occupancy and outreach. Working-capital inputs are 45 receivable days, 10 payable days and 2 inventory days, allowing collection and payment timing to be evaluated separately from EBITDA.

Sources and Uses of Funds

The Sources and Uses of Funds report reconciles funding and cash allocation over a selected period. The owner-funding estimate includes assets, separate prelaunch cash, opening working capital and a three-month recurring-cost reserve; it is not a tested peak-funding requirement.

hospice care financial model sources uses fml30
ILLUSTRATIVE PROJECTIONS

The Case Shows Annual EBITDA Turning Positive

The supplied scenario moves from a 2026 EBITDA loss to positive annual EBITDA beginning in 2027.

Illustrative annual hospice forecast, USD
Year Revenue Operating Expenses EBITDA
2026 $1,176,687 $1,270,193 -$93,506
2027 $2,196,482 $1,813,473 $383,010
2028 $3,294,724 $2,416,159 $878,564
2029 $4,549,856 $3,131,658 $1,418,198
2030 $5,648,098 $3,807,845 $1,840,253

Illustrative projections, not historical results or industry averages; amounts are rounded independently to whole dollars, so displayed subtraction can differ by one dollar.

Capacity and utilization drive revenue growth while selected daily rates and care mix remain constant. Payroll increases with planned staffing, while fixed overhead stays unchanged; the resulting EBITDA excludes depreciation, interest and taxes and does not establish net profit or investment recovery.

Cash Flow Forecast

The Cash Flow Forecast separates operating, investing and financing cash movements and reconciles opening to closing cash. Use it to assess collection delays, asset purchases and funding timing; the supplied EBITDA figures do not establish cash sufficiency.

hospice care financial model cf fml30
FUNDING AND RETURNS

Evaluate Break-Even, Payback and Returns Separately

The Returns report distinguishes operating cost coverage, cash timing, investment recovery and annual capital returns.

Break-Even, Payback and ROIC

The Return on Invested Capital Analysis combines sales break-even, cash break-even timing, investment payback and annual ROIC. Review these measures against the hospice’s staffing commitments and opening investment after updating the operating and financing assumptions.

hospice care financial model returns fml30

Sales break-even assesses revenue needed to cover operating costs; cash break-even assesses cash timing. Investment payback evaluates recovery of invested funds, while annual ROIC measures returns on invested capital; no case-specific payback date or ROIC result is supplied.

Dashboard debt controls support four financing facilities, with amounts, dates, terms, rates and repayment types feeding Debt schedules. These tools can test borrowing assumptions, but the supplied funding amount represents owner capital and establishes no loan terms or borrowing eligibility.

MODEL FIT

Designed for an Established Home Hospice

This case fits an already enrolled freestanding hospice planning census growth and contracted acute-care coverage.

The scenario uses a generic mid-cost US market, wage-index 1 planning context and a pass-through LLC. It assumes no acquisition purchase, new certification forecast, owned inpatient facility or skilled-nursing room-and-board business, and excludes personal taxes.

COMMON QUESTIONS

Hospice Care Financial Model Questions

Use these answers to check the template’s assumptions and scope before adapting the case.

Can I change census capacity and care mix?

Yes, edit staffed places, utilization, the five exclusive care-day shares and net daily rates to recalculate patient-day volumes and revenue.

Does the model track patients between routine-care tiers?

No, routine-care tiers use selected shares of one patient-day pool; the documented revenue engine has no patient-cohort progression schedule.

Are the selected daily rates verified reimbursement amounts?

No, the selected net rates are estimated planning assumptions and should be reviewed for the operation being modeled.

Does payroll include the owner’s working role?

Yes, the case includes a paid working hospice administrator at $110,000 annually; employer taxes and benefits are excluded from the supplied payroll scope.

Does positive EBITDA prove payback or adequate cash?

No, evaluate cash flow, investment payback and annual ROIC separately; the supplied annual EBITDA results do not establish those outcomes.

Is this a forecast for a newly certified hospice?

No, existing Medicare enrollment and certification are prerequisites; the illustrated case does not forecast new certification or an owned inpatient facility.

What Does the Hospice Care Financial Model Contain?

hospice care financial model dashboard fml30

Financial Dashboard

KPIs, forecasts, and cash flow at a glance.

hospice care financial model revenue fml30

Revenue Engine

Key assumptions and calculations driving revenue forecasts.

hospice care financial model sources uses fml30

Sources & Uses

Funding sources, spending, and closing cash.

hospice care financial model returns fml30

Returns & Break-Even

Cash break-even, payback, and ROIC.

hospice care financial model valuation fml30

Business Valuation

DCF valuation and sensitivity analysis.

hospice care financial model top expenses fml30

Expense Breakdown

Largest costs and spending trends.

hospice care financial model summary fml30

Financial Summary

Annual and monthly financial performance.

hospice care financial model benchmarks fml30

KPI Benchmarks

Compare margins and returns to benchmarks.

Trusted by 25,000+ startup founders, investors and CPAs

Clearer Modeling Fast

Megan Hart, TX

4 star rating

I’m not a finance person, so the built-in structure made the Hospice Care model much easier to follow. I got my assumptions entered in under an hour and could finally explain the numbers without getting lost in formulas.

Hours Saved Right Away

Daniel Reed, FL

5 star rating

Building projections from scratch was taking me forever. This template cut my prep time by two days and gave me a clean first draft I could send to the team the same afternoon.

Everything In One Place

Lauren Patel, CA

5 star rating

I used to have statements in one file and charts in another, which was a mess. With this model, everything sat together and I had a board-ready packet ready in one place.