Interactive financial model

Pro Forma — build the numbers yourself

A living model of Redlands Health's economics across the at-risk plan and every ancillary service line. Every white field is editable — change any input and the outputs and 5-year projection recalculate instantly. Defaults are illustrative planning placeholders, not forecasts.

How to use Edit any number below. Everything updates live. Nothing is saved between visits — when you land on a good scenario, note the inputs (or tell me and I'll set them as the new defaults).

1The at-risk health plan (covered lives)

Three payer segments — edit lives, per-member-per-month (PMPM) premium, and medical loss ratio (MLR) for each.

Commercial

Medicare Advantage

Medi-Cal (managed)

Plan contribution = premium − care cost (MLR) − admin. Year-1 plan revenue: · contribution:

2Service lines (ancillary & cash revenue)

Each line: volume × unit economics × contribution margin. This is where labs, RPM, personal medicine, surgery, retail and gyms drive the model.

Outpatient surgery center

Remote Patient Monitoring (RPM)

Personal / precision medicine (cash-pay biohacking)

In-house lab

Supplements & retail (B12, methylation-driven, etc.)

Wellness gym network

Year-1 service revenue: · service contribution:

3Fixed cost & org overlay

The human-capital + infrastructure base (ties to the FTE ranges on Definitions).

Year-1 fixed overhead:

4Year-1 summary

Total revenue
Total cost
Operating income
Operating margin
Revenue mix (Year 1)

55-year projection

Plan lives and service volumes grow at the annual growth rate; fixed overhead held flat (edit it per year mentally, or raise the growth driver). The J-curve from start-up loss to operating leverage is the story to watch.

YearCovered livesPlan revService revTotal revTotal costOperating incomeMargin

All figures illustrative and fully editable. Not actuarial, accounting, or investment advice — pressure-test with a healthcare actuary and CFO before any decision.