Illustrative modelHealthcare unit economics · Relevant to FP&A, Corporate development

Cash economics per patient and per client

Unit economics ask whether one more patient, or one more client, pays for itself and how fast. This build uses an invented care company. Move the collection delay, the device cost, the nurse time and the share of routine contacts handled by software, and watch the payback month.

What this shows

  • Month-by-month cash for one patient in each program, with the payback month
  • Device cost paid in instalments, plus the labor and software behind each patient
  • An automation slider showing payback and 12-month cash with and without it
  • The same view for a whole medical group, with its ramp, churn and sales cost

How I use it

  • Deciding how much to spend to win a new client
  • Seeing which cost line is worth automating first
  • Explaining why cash lags profit in a growing service business

Explore the model below. It uses an invented company and invented numbers.

Explore the model

Illustrative model · Synthetic data

Wide tables scroll sideways: swipe inside a table to see every column.

Sample build: unit economics of an invented care company

Alder Quay Care is an invented company that runs remote monitoring and chronic care programs for medical groups. The build follows the cash from one patient and then from one medical group, month by month: what is billed, when the money arrives, what the device, the nurses and the software cost, and the month the cash pays back.

Synthetic inputs for illustration. Not data from any employer.

What to try

  • Raise the collection delay from 70 to 110 days and watch the payback month move out. Nothing about the care changes, only when the cash arrives.
  • Move the monitoring nurse minutes from 20 to 30, then to 40. Ten extra minutes with no new billing step lose money, and the next step arrives at 40.
  • Slide routine contacts handled by software up to 100 percent, then open the Automation tab to compare payback with and without it.
  • Open One client and raise the share of patients leaving each month. Every patient who leaves has to be replaced, and a replacement costs a device and an intake call.
  • Press Costly device and compare the lowest point with the cash after 12 months. Six payments ease the dip, but the dearer device still leaves less cash in the end.
Scenario

Insurers pay in about 70 days, nine in ten billed dollars are collected, and half of routine contacts are handled by software.

Controls for every tab
Program
70 days
$120
20 minutes
30 minutes
50%

Patient cash payback

Month 9

One monitoring patient. Profit breaks even in month 4

Patient cash at 12 months

$158

Lowest point -$243 in month 3

Client cash payback

Month 17

A group building to 300 active patients

Cash the client needs

$87,184

Lowest point is in month 8

Cash payback

Month 9

First month the running cash total is at or above zero

Profit break-even

Month 4

Profit counts care when it is delivered, not when it is paid for

Lowest point

-$243

Cash to fund per patient, reached in month 3

Steady cash a month

$43.90

Cash added in month 24, after the one-time costs are behind the patient

Cash and profit for one monitoring patient

-$333-$6$321$648$975147101316192224
Cumulative cashCumulative profit

Profit counts the share of billing that is ever collected in the month the care is delivered, and counts each cost when it is paid. Cash counts billing only when it arrives. The gap between the two lines is money earned and not yet received. The month-by-month table further down carries every point on this chart.

The three programs side by side

One patient in each program, all other inputs held
ProgramCash paybackProfit break-evenLowest pointCash at 12 monthsCash at 24 months
MonitoringMonth 9Month 4-$243$158$685
Chronic careMonth 16Month 5-$147-$44$93
BothMonth 8Month 2-$297$320$1,135

The highlighted row is the program picked above. Monitoring carries a device. Chronic care carries no device, and its margin depends on nurse minutes. Both shares the intake, outreach and software costs across two revenue streams.

Cash after 12 months

$158Monitoring-$44Chronic care$320Both

What gets billed

Billing for one patient, before any is lost to non-payment
Billing lineMonth 1Later monthsFirst 12 months
Setup and patient education, once$20$0$20
Device supply, each month$45$45$540
Monitoring management, each month$50$50$600
Chronic care management, each month$0$0$0
All billing$115$95$1,160

Setup is billed once. Device supply is billed monthly and depends on days of readings. Management is billed monthly and depends on nurse minutes. Illustrative rates, not the fee schedule.

What sits behind one patient

Cost for one patient over the first 12 months, largest first
Cost lineWhen it is paidFirst 12 monthsShare
Nurse timeEvery month the patient is active$240.0035%
Device, paid in instalmentsEqual monthly payments from month 1, owed even if the patient leaves$120.0017%
Monthly data chargeEvery month the patient is active$108.0016%
Adherence outreachEvery month the patient is active$79.2012%
Software per patientEvery month the patient is active$72.0010%
Intake laborOnce, in month 1$40.006%
Enrollment laborOnce, in month 1$15.002%
Shipping the deviceOnce, in month 1$12.002%
All costs$686.20

The device is bought up front and paid for in equal monthly instalments. The instalments are owed even if the patient leaves, so in the client view they do not shrink when patients leave.

Open one month

Click a month in the table below. Lines at zero are left out.

Billed in month 4
LineAmount
Device supply, each month$45.00
Monitoring management, each month$50.00
Billed in the month$95.00
Expected to be collected (90%)$85.50
Paid in month 4
LineAmount
Monthly data charge$9.00
Nurse time$20.00
Adherence outreach$6.60
Software per patient$6.00
Paid in the month$41.60

Cash in comes from care billed in month 2 (67% of what is expected to be collected) and month 1 (33% of what is expected to be collected). Cash in is $91.50, cash out is $41.60, so the month adds $49.90 and the running cash total is -$192.90.

Month by month

One patient, whole dollars. Cash in is what arrives that month. Cash out is what is paid that month.
MonthBilledCash inCash outCashCumulative cashCumulative profit
$115$0$149-$149-$149-$45
$95$0$82-$82-$230-$41
$95$69$82-$13-$243-$37
$95$92$42$50-$193$7
$95$86$42$44-$149$51
$95$86$42$44-$105$94
$95$86$42$44-$61$138
$95$86$42$44-$17$182
$95$86$42$44$27$226
$95$86$42$44$71$270
$95$86$42$44$114$314
$95$86$42$44$158$358
$95$86$42$44$202$402
$95$86$42$44$246$446
$95$86$42$44$290$489
$95$86$42$44$334$533
$95$86$42$44$378$577
$95$86$42$44$422$621
$95$86$42$44$466$665
$95$86$42$44$509$709
$95$86$42$44$553$753
$95$86$42$44$597$797
$95$86$42$44$641$841
$95$86$42$44$685$885

Reading the patient view

Cash only starts to arrive once the collection delay has passed, while the device, the shipping and the intake call are paid at the start. That is why the cash line dips before it climbs, and why profit turns positive no later than cash does.

Checks on the patient numbers

  • Cumulative cash equals the running sum of monthly cashPassesEvery month ties
  • Monthly cash equals cash in less cash outPassesEvery month ties
  • Cost lines and billing lines add to their totalsPassesEvery month ties
  • Totals match the monthsPassesCash in and cash out tie
  • Collectible billing equals cash received plus cash still duePassesNo money is lost in the delay
  • Profit less cash equals the cash still duePassesThe gap is the money waiting to arrive
  • Payback is the first month at or above zeroPassesSearch finds month 9

One monitoring patient pays back in month 9 and its running cash total is $158 after 12 months. Software handling routine contacts brings payback forward by 1 month. A medical group building to 300 active patients pays back in month 17 after needing up to $87,184 of cash.