# The NEMT Business Owner: companion files

Julian R. Sterling

## What is here

- **NEMT_1_Cost_per_Trip_and_Vehicle_Hour.xlsx** (Chapters 4 and 5; Workbook 1 of Appendix A): tabs Inputs, Cost, Checks. Busy hours, utilization, the cost per busy vehicle hour and the floor price of a dialysis contract trip (the price build of September 2025: 57.15 dollars a busy vehicle hour, 38.82 dollars a vehicle hour on shift, a floor of 41.48 dollars and a contract rate of $41 a trip).
- **NEMT_2_Trip_Mix_and_Break_Even.xlsx** (Chapter 14; Workbook 2): tabs Inputs, Break-Even, Checks. A closed year's contribution per trip and the break-even in trips a month (FY2026: 1529.4 against an actual 1845.3, a margin of safety of 17.1 percent; FY2025: 676.0 against 824.6).
- **NEMT_3_Driver_Pay.xlsx** (Chapter 9; Workbook 3): tabs Inputs, Pay, Checks. One ambulatory driver's workweek paid by the completed trip: the minimum wage top-up, the regular rate and the overtime premium against the FY2026 hourly wage (week 27: 8.44 dollars an hour, a premium of $22, $402 for the week against $784; the slow week 40 needs a top-up of $14).
- **NEMT_4_The_Dialysis_Contract.xlsx** (Chapter 8; Workbook 4): tabs Inputs, Contract, Checks. The dialysis contract after its miles and after the vehicle hours it uses (FY2026: revenue $230,256, contribution before vehicle hours $211,105, after them $34,580).
- **NEMT_5_Wheelchair_Van_Payback.xlsx** (Chapter 13; Workbook 5): tabs Inputs, Payback, Checks. One wheelchair van's own contribution and the payback of its down payment and of its price (Q4 FY2026: run-rate $63,420, 3.3 months for the down payment, 12.9 months for the price).
- **NEMT_6_Receivables_and_the_Cash_Gap.xlsx** (Chapter 14; Workbook 6): tabs Inputs, Cash Gap, Checks. Receivables at a steady pace of billing and the days of revenue waiting ($87,804, 28.4 days).
- **NEMT_7_Value_and_Offer.xlsx** (Chapter 16; Workbook 7): tabs Inputs, Offer, Checks. The letter of intent from EBITDA to the cash at closing (adjusted EBITDA $138,320, price $449,540, seller note $44,954, cash at closing $169,873).
- **NEMT_Business_Owner_Check_Lists.docx**: the 8 check-lists of Appendix B, editable, with a box to tick before each item (Section 1: Enrollment, licenses and the owner's file (chapter 2); Section 2: The weekly trip and vehicle review (chapters 3 and 4); Section 3: Rates, contracts and the trip mix (chapters 5, 6 and 8); Section 4: Trip records, no-shows and denials (chapter 7); Section 5: Dispatch, will-calls and passenger information (chapter 11); Section 6: Pay, overtime and screening (chapters 9 and 10); Section 7: Vehicles and insurance (chapters 12 and 13); Section 8: Before answering an offer (chapters 15 and 16)).

Every workbook opens pre-filled with the exercise of Appendix A, so you can check each result against the book before typing your own figures.

## How to use the workbooks

Every workbook opens on its Inputs tab: blue type on a light yellow background is an input, and nothing else is typed by hand. The subject tab holds formulas only and is protected against overtyping, with no password. The Checks tab holds the three tests of Appendix A: each one shows OK or CHECK, and the cell All checks shows OK only when every test below it does. A comparison line informs and carries no OK or CHECK.

The arithmetic is plain: the only functions are SUM, ROUND, MIN, MAX, IF and AND. No cell holds a date, and a loan payment is an input copied from the lender's schedule. Percentages are typed as percent (35 percent shows as 35%), and every division by an input that can be zero is wrapped in IF and leaves the line empty instead of an error. An empty input reads as zero in a sum, a product or a comparison, but a MIN or a MAX over a range skips it. The last section of Appendix A lists, workbook by workbook, what the checks do not catch.

To use a workbook on your own company, start with a copy, replace every blue input from the record that owns each figure (the scheduling and billing software's reports, the payroll records, the broker's remittances, the contracts, the statements, the lender's schedule, the letter itself), keep every check at OK, and never edit a formula to turn a CHECK into OK.

The workbooks are separate files with no link between them: a figure two workbooks share is typed again where it is used.

## A word of caution

Calverwyn Medical Transport, Inc., the town of Velmorrow, Thessaby Dialysis Center, Pellidge Properties, Harnsley Community Bank and every party in the case are fictional. Vehicle counts, trip counts, busy hours, miles, broker rates, contract rates, wages, pay a trip, premiums, loan terms, offer terms and multiples are teaching assumptions, not market norms, not a broker's rates, not the rule of any state and not recommendations. Rates, no-show rules and trip records are set by each state's Medicaid program and its broker; what a state requires is for that authority and counsel; billing questions are for the broker and counsel; taxes are for the outside CPA. The files are provided as they are, without warranty of any kind.
