Free Excel templates

A free imaging center financial model in Excel, with a full worked case

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.

Get the template

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.

The book behind this model

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

What is in the file

Eleven tabs. Blue cells are inputs; every other cell is a formula.

Inputs
Rooms, days, hours, slot length and fill by modality; Medicare-equivalent allowed amounts, payer mix, payer multiples and patient shares; supplies, read fees, service contracts, staff and wages; fixed costs; the MRI loan, the plan, the second MRI quote and the two offers.
Capacity
Available slots, completed exams (35,208 in the case) and exams per day by modality.
Payers
Expected net collection per exam by payer and blended, net revenue by modality and by payer, and the test of one more authorization employee.
Contribution
Contribution per exam and per scheduled room hour by modality, the Saturday CT test and the self-pay MRI package.
P&L
Direct costs, gross profit, overhead, EBITDA, the MRI loan and depreciation, adjusted EBITDA and SDE ($1,272,192).
BreakEven
Variable and fixed costs, the contribution margin, break-even revenue and exams, and the MRI’s own break-even (6.4 exams a day).
Cash
Quarterly net revenue, receivables, the biweekly payroll, the cash floor and loan coverage.
BuyLease
The present cost of buying or leasing a second MRI over five years, before tax.
Plan
2027 to 2029: exams, net revenue, costs, EBITDA, margin and coverage of both MRI loans.
Value
A platform’s offer on adjusted EBITDA with rollover and escrow, an operator’s offer on SDE with an SBA loan and a seller note, cash at closing before and after the MRI loan is repaid, and the buyer’s coverage test.
Checks
Internal checks (mixes, quarters, gross profit, SDE, break-even, offer layers) and a comparison with the figures printed in the book.

Three things to try

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).

Questions

Can it value an MRI slot?

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.

Does it use macros?

No macros and no circular reference. It recalculates in Excel, LibreOffice or Google Sheets.

Can I use it for my own imaging center?

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.

Related reading