Capacity, fill and exams by modality, net collection by payer, contribution per exam and per scanner hour, a P&L with adjusted EBITDA and SDE, break-even, quarters and the cash floor, buying or leasing a second MRI, a three-year plan and two offers for the center.
The file follows Corvallen Imaging, a fictional independent imaging center with an MRI, a CT, ultrasound, x-ray and mammography over two sites. It completes 35,208 exams a year for net revenue of $5,184,799 and EBITDA of $1,075,952 (20.8%), and breaks even at 76.1% of its revenue. Every figure in the book comes from this model; replace the inputs with yours and the whole case recalculates.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
Imaging_Center_Model_Corvallen.xlsx (36 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
This file is the worked case of The Diagnostic Imaging Center Owner. The book explains every assumption and every tab: why the scanner hour is the unit that matters, how payer contracts and patient balances turn an allowed amount into cash, why an authorization comes before the scan, what a second MRI costs to buy or lease, why January is the tightest month, and how two buyers would value the center.
DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide
Eleven tabs. Blue cells are inputs; every other cell is a formula.
Lift MRI fill. Change the MRI fill from 84% and watch the contribution per room hour, EBITDA and break-even move together.
Cut commercial rates 10%. Lower the commercial multiple by a tenth: in the book’s test the center loses $276,478 of EBITDA, more than three times the cost of a 5% Medicare cut.
Requote the second MRI. Enter a new lease payment or resale value in the inputs; the BuyLease tab shows whether buying still costs less than leasing ($255,994 in the case).
Yes. In the case, an MRI exam contributes $318 after supplies, per-exam IT and the average self-pay read fee, and a scheduled MRI room hour $356 at 84% fill.
No macros and no circular reference. It recalculates in Excel, LibreOffice or Google Sheets.
Yes: replace every blue input, starting with your schedule template, your fill and the allowed amounts your billing office builds from your own remittances. Corvallen and every figure in it are fictional case assumptions, not market data or fee schedule figures.