Modeling both sides of a medical-travel marketplace
A medical-travel platform model had to connect patients choosing among treatment categories with healthcare providers joining in several operating segments. The business combined a share of treatment value with recurring provider subscriptions, so demand and network monetization could not remain one revenue line.
Patient demand and provider participation entered the model on separate launch schedules.
Patient allocation and treatment value determined the platform revenue earned per case.
Provider additions accumulated into segment-level recurring revenue.
Launch activity was calculated monthly before statements and decision outputs were summarized.
WHY THIS WASN’T A TEMPLATE EXERCISE
The model had to respect
how the business actually moved.
The workbook follows monthly patient demand into treatment mix and transactional revenue, rolls provider additions into active subscription balances, then connects both streams to expenses, statements, cash, break-even, funding and valuation.
The two sides of the marketplace started at different times
Patients and provider segments had their own launch gates and growth assumptions. Combining them in one top-line percentage would hide whether demand and network participation were developing together.
A patient count did not determine platform revenue
Each patient first flowed into a treatment category. Treatment value and the platform share then determined revenue per patient, so a change in mix could matter even when total demand stayed constant.
The second revenue stream followed a different operating logic
Provider subscriptions depended on active providers by segment and the monthly fee for each group. They could diversify revenue, but only after the relevant provider cohort joined the network.
Provider counts were not the same as clinical capacity
The workbook tracked provider participation separately from treatment volume. It made both sides visible, but specialty fit, appointment availability and treatment capacity remained an additional diligence question.
MODEL ARCHITECTURE
From operating activity
to a decision-ready view.
Each layer has one job. Together they keep the commercial story, unit economics and cash consequences on the same timeline.
Timeline and launch gates
A monthly calendar controls when patient demand and each provider segment begin contributing to the forecast.
Patient demand
Annual patient assumptions convert into monthly activity after the platform launch.
Treatment mix
Patients are allocated across treatment categories so volume can be tested independently from case value.
Transactional revenue
Average treatment value and the platform share convert category-level patient activity into revenue.
Provider participation
New providers enter by segment and accumulate into active-provider balances after their launch dates.
Subscription revenue
Active providers generate a separate recurring revenue stream using segment-level monthly fees.
Cost and operating plan
Cost of sales, variable and fixed expenses, people and development spending follow the combined operating case.
Cash and decision outputs
Statements, funding, debt, break-even, dashboard and valuation views summarize the consequences of the operating assumptions.
WHAT THE ANALYSIS SURFACED
Useful answers,
without exposing client data.
The takeaways are intentionally qualitative. Exact assumptions, calculations and outputs remain inside the confidential client model.
Treatment mix could change revenue without changing demand
Two periods with the same patient count could produce different platform revenue if patients selected different categories or the economics of those categories changed.
A second revenue stream did not guarantee diversification
In the supplied illustrative inputs, treatment-related revenue remained dominant while provider subscriptions entered later. Keeping the streams separate exposed that concentration instead of disguising it inside total revenue.
Network size still needed a capacity test
Counting active providers measured participation and subscription revenue, but it did not prove that the right specialties and appointment capacity existed for the modeled treatment demand.
Valuation inherited every operating assumption
A polished discounted-cash-flow output remained a scenario result. Patient volume, mix, platform share, provider uptake, costs, financing and the terminal assumption all had to remain visible upstream.
MODELING APPROACH
The working system
behind the answer.
- Monthly operating forecast with annual reporting views
- Patient launch and demand schedule
- Treatment allocation and value assumptions
- Platform-share revenue by treatment category
- Provider rollout and active-provider schedules by segment
- Recurring provider-subscription revenue model
- Cost of sales, operating-expense, people and development schedules
- Integrated income statement, cash flow and balance sheet
- Funding, debt, capitalization, break-even, KPI, dashboard and valuation views
CASE CONFIDENTIALITY
This anonymized case explains the patient, treatment, provider-subscription, operating-cost, funding and valuation logic without naming any client, author, template owner, healthcare provider, market or date. Exact patient and provider counts, treatment inputs, prices, platform shares, subscription rates, launch timing, costs, staffing, financing, forecasts, benchmarks and valuation outputs remain private because client work can be confidential or NDA-protected. No workbook screenshot, chart, formula, logo or source file is reproduced. The illustration is an original fictional coordination network rather than a real patient journey, clinic, hospital, platform, trip or operating result.