Executive Volume Report · Interactive Scenario Model

Kansas City Advanced Imaging

Volume and patient utilization analysis with a live, volume-driven scenario model. Every table and figure in the source report is rebuilt here, recomputed from the underlying daily data, and extended into a forward projection with debt service coverage for lender review.

  • 629 net imaging exams
  • 483 unique patients
  • 120 active service days
  • Sep 19, 2025 to Jul 24, 2026
  • Prepared by Kelly Emrick

Section 1

Executive Summary and Volume Reconciliation

After removing the duplicate professional component and isolating diagnostic imaging services, Kansas City Advanced Imaging recorded 629 net imaging examinations for 483 identified patients across 120 active service days. The resulting utilization rate was 1.30 examinations per patient.

629Final imaging examsCPT 70000 to 79999, signed units
483Unique patientsComposite MRN and account key
1.30Exams per patient629 divided by 483
131Patients with 2 or more exams27.1% of identified patients
208PC rows removed206 net units, one row is a reversal
100%Patient identificationNo exam row left unidentified

Answer-first findings

  • Professional component removal is fully supported. The workbook contains 208 modifier 26 rows, and all 208 match technical-component records at the account, date-of-service, and CPT level. The signed-volume impact is 206 net units because one PC row is a reversal.
  • 2026 year-to-date activity accounts for 627 of 629 exams. The only 2025 activity is two exams for one patient on September 19, 2025.
  • June was the highest-volume month with 140 exams and 120 unique patients. July reached 134 exams through July 24 and carried the highest run rate at 7.44 exams per active day, slightly above June at 7.37.
  • Multiple procedures are material: 131 patients, or 27.1%, had two or more exams. Most of that intensity was same-day activity, with 112 patients having multiple exams on at least one date; 27 patients returned on multiple service dates.
  • Patient identification coverage is 100% at the exam-row level. Facility MRN supports 375 patients; 108 patients require the fully populated Account field because Facility MRN is missing or represented by the export placeholder 37.

Why this matters for the lending decision

Volume is the only input this operation fully controls, and it has more than tripled its run rate since January. The credit question is not whether demand exists but how many examinations per active service day are required to service the debt.

The scenario model in section 5 converts that question into a single number the operation can manage against, and section 6 stress tests it.

Volume reconciliation

The source is a charge-level export. The following controlled adjustments convert charge activity into reportable imaging examinations while preserving signed reversals.

Model verification against the published report

Every figure this model displays is recomputed from the 120 daily service-date records rather than carried across as text. The table below compares the recomputed values against the figures published in the source report.

One rounding variance. The source report shows January exams per patient as 1.56. Thirty-six exams divided by 23 patients is 1.5652, which rounds to 1.57. This model displays the computed value. No other published figure varies.

Section 2

Monthly Volume

The 2026 operating trend strengthened sharply in the second quarter. June established the highest monthly count, while partial July volume sustained the highest exams-per-active-day rate of the period.

Reading note. September 2025 is an isolated historical service date and should not be read as a full historical month. July 2026 is partial through July 24. Monthly unique-patient counts are not additive across months, so the source-period patient total of 483 is lower than the sum of the monthly columns.

The growth rate that drives the model

Examinations per active service day is the operating rate the scenario model projects forward. Raw monthly counts mix true demand growth with the number of days the scanner was open, so the model compounds the daily rate and applies active days separately.

Conservatism check. The observed compound growth in examinations per active day from January to July was well above the growth rate used in any of the three scenarios. The base case deliberately projects a small fraction of the observed trend.

Section 3

Daily Volume and Operating Pattern

Daily capacity increased materially from the first quarter into June and July. The moving-average view separates the underlying rise from day-to-day patient mix.

Operating pattern by day of week

Tuesday carried the highest average exam load at 5.52 examinations per active day. Thursday carried the highest average patient load at 4.52 patients per active day. The spread across weekdays is narrow, which means there is no single weak day to fill; incremental volume has to come from added slots or added days rather than from redistributing the existing week.

Appendix A. Daily volume by date of service

Active service dates carrying at least one net diagnostic imaging examination after professional component exclusion. Unique patients are counted within each date.

Section 4

Patient Utilization and Multiple Procedures

Most patients had one examination, but more than one-quarter had multiple procedures. This distinction matters for scheduling because exam load grows faster than patient arrivals when multi-exam visits increase.

Multiple-procedure structure

Operating consequence. Roughly 23.2% of patients had multiple same-day examinations. Same-day multi-exam blocks lengthen table utilization and raise protocol complexity, so the scenario model treats examinations per patient as a separate input from volume: the same number of patients can produce materially different exam counts.

Section 5. Patient identification quality

The composite key identifies every reportable exam row, but account fallback is less durable than a facility MRN. If a patient receives a new account number on a future visit and still lacks an MRN, that patient may be counted twice across periods. This affects the unique-patient count and the exams-per-patient ratio, not the examination count itself, so projected volume and projected revenue are unaffected.

Restricted appendix withheld. The source report carries a restricted patient-level roster listing all 483 identifiers. That roster is deliberately excluded from this model and from every export it produces, because the model is built for external lender review. The de-identified distribution above carries the same analytical content.

Section 6

Interactive Scenario Model

The model projects examinations forward from the observed operating rate and converts that volume into revenue, contribution, EBITDA, and debt service coverage. Change any input below and every figure, table, and readout on this page recalculates.

Read this before presenting. The source report is a volume and patient utilization analysis. It contains no revenue, cost, or debt data. Every financial input below is a placeholder set to an illustrative value and is marked as an assumption. Replace each one with the actual figure before this model goes to a lender. The volume inputs, by contrast, are taken directly from the source report and are marked as such.

Volume drivers

These inputs describe how many examinations the operation performs. They come from the source report or from the operating schedule.

July 2026 ran 134 exams across 18 active days, a rate of 7.44.

Percent per month, compounded. Enter 1.5 for one and a half percent.

The source period ran 18 to 21 active days in each full 2026 month.

July was 1.24. The full source period was 1.30.

Drives the capacity ceiling used in the projection.

Derived capacity: 12.00 exams per active day

Financial assumptions

None of these values appear in the source report. Each one is a placeholder. Replace it with the actual figure before external use.

Net collected, not gross charges.

Contrast, supplies, per-exam reading fee.

Staffing, rent, equipment, utilities, administration.

Contribution margin: $590 per exam

The facility amount under discussion.

Percent per year. Enter 7.5 for seven and a half percent.

Years. Monthly principal and interest: $29,559.65 per month

Selected scenario at a glance

Monthly projection

Annual summary

Scenario comparison

Section 7

Lender Package

This section restates the model in the terms a credit committee works in: what is assumed, what the debt costs, how many examinations cover it, and what happens when the assumptions move against the borrower.

Assumptions register

Every input the model uses, with its current value and its basis. Inputs marked as an assumption are not observed in the source data and are the borrower’s representations.

Debt service

The monthly payment is the standard level-payment amortization: the principal multiplied by the monthly periodic rate, divided by one minus the compounding factor raised to the negative number of payments.

Breakeven expressed in examinations

Coverage tests are usually written in dollars, but the operation manages examinations. These rows translate each threshold into the operating unit the schedule actually controls.

The single number to manage against

Full breakeven including debt service, expressed as examinations per active service day, is the operating threshold. Everything above it is coverage; everything below it draws on reserves.

Compare it against the most recent observed rate of 7.44 examinations per active day and against the observed daily ceiling of 11.

Sensitivity: year one coverage

Downside stress tests

Interpretation. Coverage below 1.00x means operations do not fully fund principal and interest in that period. Coverage of 1.25x is the level most commercial lenders write as a covenant. Read the stress table alongside the sensitivity grid: volume and net revenue per examination move coverage far more than the interest rate does, because debt service is a fixed charge and contribution margin is not.

Sections 8 to 10

Definitions, Controls, Limitations, and Exports

Metric definitions

Patient matching logic

  • Facility MRN is the preferred patient identifier when it contains a valid value.
  • The export value 37 is treated as a missing MRN. When MRN is unavailable, the Account field provides the patient-level fallback.
  • If one account is associated with multiple real MRNs, the records remain separate at the MRN level. Two account-to-MRN conflicts were handled this way.
  • All 635 signed imaging-exam rows received a patient key.

Recommended controls and operating actions

  • Make modifier 26 exclusion a permanent refresh rule. Retain a visible reconciliation showing rows removed and net units removed so billing corrections remain auditable.
  • Maintain separate measures for charge-line procedures and diagnostic imaging exams. Exclude contrast supply CPT A9577 and zero-unit administrative or miscellaneous lines from the exam KPI.
  • Improve Facility MRN capture for the 108 account-fallback patients. A stable MRN will reduce the risk of overstating unique patients when repeat visits create new accounts.
  • Use June and July operating levels for near-term capacity planning. Recent demand is approximately 7.4 exams per active day, with observed peaks of 11 exams.
  • Monitor multi-exam blocks separately from simple patient arrivals. Approximately 23.2% of patients had multiple same-day exams, which can create longer table utilization and protocol complexity.

Limitations

  • The source does not contain patient names or dates of birth. Identification relies on Facility MRN and Account only.
  • The September 2025 record is isolated from the main 2026 operating period and should not be interpreted as a full historical month.
  • July 2026 is incomplete through July 24. Monthly totals should be compared using active-day rates as well as raw counts.
  • Signed procedure units are used so reversals reduce volume. A different operational definition, such as one exam per accession, would produce a different count and should be separately specified.
  • The scenario model projects a single blended examination. It does not model modality mix, payer mix, or the timing difference between service date and cash collection. A model presented for credit should be paired with an accounts receivable and collection-lag schedule.
  • Every financial input is an assumption entered into this model, not a figure observed in the source report.

Exports

Each table carries its own CSV button and each figure carries its own PNG button. The buttons below export the whole model.

How printing works here. The print button does not print this web page. It builds a clean, self-contained document with every section included and every figure converted to an image, then prints that document. This avoids the blank-page problem that page builders and theme wrappers cause. To produce a PDF, choose “Save as PDF” as the destination in the print dialog.

Kansas City Advanced Imaging · Volume and Scenario Model

Built from the Executive Volume Report covering service dates September 19, 2025 through July 24, 2026, primary operating view January 1 through July 24, 2026. Volume figures are recomputed from 120 daily service-date records. Financial inputs are assumptions entered into this model and are not observed in the source data.

Prepared by Kelly Emrick, DHSc, PhD, MBA, BSRT(ARRT)R. Confidential. No patient identifiers appear in this model or in any file it exports.