Free Excel templates

A free DME rental start calculator in Excel

Purchase price, continuation, payer mix, denials, setup, service and pickup costs, unit and refurbishment costs in; the net revenue, direct costs, contribution and payback month of one capped rental start out. No macros.

A capped rental item pays 10 percent of its purchase price in each of the first three months and 7.5 percent in months 4 to 13, then passes to the patient. In the worked case of the book, one capped rental start brings $867.16 of net revenue and $571.57 of contribution over its life: on a new unit costing $803.40 it loses $231.83; on a refurbished unit it contributes $447.37. The calculator builds that arithmetic for your own item.

Get the calculator

One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.

DME_Rental_Start_Calculator.xlsx (16 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 calculator

This file is the one-page summary of The DME Business Owner. The book explains every line: how Medicare pays for capped rental items and oxygen, why a unit earns its keep only when it is reused, how denials take money from every start, why growth spends cash and covenant room before it earns them, and how the year is planned to the bank covenant.

DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide

What is in the file

Four sheets. Blue type is an input; black type is a formula.

Inputs
The purchase price recognized; the rental shares of months 1 to 3 and 4 to 13; the share of patients still on service each next month; four payers with their share of patients, allowed amount relative to Medicare and patient share; patient collection; first-pass denials and the share recovered; setup, service, pickup, intake and claims costs; the new unit and refurbishment costs.
Calculator
A 13-month table: patients still on service, rental, allowed amount, gross revenue, write-offs, bad debt, net revenue, direct costs and cumulative contribution on a new and on a refurbished unit; the totals and the payback month with each. Each line has a one-line definition beside it.
Read Me
How to replace the case with your own figures, and why the result is an estimate, not billing or legal advice.
Checks
The calculator compared with the figures printed in the book.

Three things to try

Change the stay. The file opens on the book's capped rental case at 2025 rates: a purchase price of $1,484.80, 90.0 percent of patients still on service each next month, 7.46 expected months. Raise or lower the continuation share and watch the contribution on a new unit.

Change the denials. In the case, first-pass denials rose from 6.0 to 13.0 percent in 2025, and 60.0 percent of denied claims were never recovered. Type your own rate and read what it takes from one start.

Replace the case. Type your own allowed amounts, payer mix and costs over the blue cells. If a line does not make sense, the definition beside it says what it measures.

Related reading