Mobile Diagnostic Unit Financial Model
Description
This model is built for a mobile diagnostic service operating a single or small fleet of advanced imaging units (MRI, CT, X-ray, ultrasound) that travel to hospitals, clinics, and remote sites on fixed weekly routes. It captures the full operational cycle: route planning with drive times, modality-specific scan durations, patient scheduling windows, and the interplay between no-shows and fill rates.
Revenue is built from the ground up — hourly throughput per modality, daily stop capacity, payor-specific reimbursement (commercial, Medicare, Medicaid, self-pay), collection lags, and contractual adjustments. The model incorporates seasonal demand curves and the long-term shift in payor mix, allowing realistic projections without overstating achievable scan volumes.
On the cost side, the model distinguishes between the motor coach (tractor/trailer) and medical equipment, handling lease-vs-buy decisions, service contract structures (typically 6–10% of equipment cost annually), planned downtime for preventive maintenance, and variable costs like fuel, driver & technologist hours, and state license renewals. The capital investment section gives a clear order-of-magnitude view of required startup capital, not a final estimate.
Modeling specifics
- Route-based utilization engine simulates daily stop sequences, travel times, and modality-specific scan slots to generate realistic patient throughput per coach.
- Modular payor mix modeling with separate reimbursement rates, collection lags, denial rates, and contractual allowances for commercial, Medicare, Medicaid, and self-pay.
- Downtime calendar accounts for planned preventive maintenance, unplanned breakdowns based on equipment age, and mandatory recertification windows, directly reducing available scan days.
- Flexible capital structure allows mixing equity, term loans, and fair market value leases for both the motor coach and medical equipment, with balloon payments and buyout options.
- State-specific licensing and permit fees are modeled as recurring annual expenses, with automatic escalation and renewal timing tied to unit registration.
- Staffing module links technologist and driver schedules to operating hours, route length, and modality workload, including overtime premiums.
- Fuel and vehicle maintenance costs are driven by mileage, fuel price forecast, and coach class, not just a fixed percentage of revenue.
What's included in the base version
- Revenue projection by modality and payer type with hourly throughput assumptions
- Direct operating expenses: technologist wages, driver costs, fuel, maintenance, OEM service contracts
- Capital expenditure schedule for coach acquisition, medical equipment, IT, and initial setup
- Loan and lease financing schedules with interest, amortization, and balloon payments
- Integrated financial statements: Profit & Loss, Cash Flow, Balance Sheet over 7–10 years
- Key investment metrics: NPV, IRR, payback period, and debt service coverage ratio
- One-dimensional sensitivity analysis on utilization rate and average reimbursement
Common modeling mistakes
- Ignoring travel time between remote sites — daily scan capacity overstated by 20–30%.
- Assuming 100% collection of charges without payor-specific contractual adjustments — revenue per scan exaggerated by 15–25%.
- Applying uniform utilization across all modalities without considering slower MRI vs. X-ray — total throughput inflated by 10–15%.
- Neglecting mandatory preventive maintenance downtime (e.g., 2–3 weeks/year per OEM contract) — overstates annual procedure volume by 5–10%.
- Omitting annual license and vehicle permit renewal fees — understates fixed operating expenses by 3–5%.
- Treating the coach and medical equipment as a single asset with linear depreciation — distorts residual value and terminal cash flow.
