Original cost, rate card, realization, time utilization, costs and the note in; rental revenue, dollar utilization, contribution, profit, cash after note payments and the break-even time utilization out. No macros.
The file comes prefilled with one boom lift of Fenwright Equipment Rental, the fictional company of the book: an original cost of $90,000, a book monthly rate of $3,600 on a 28-day month, 90.0 percent realization and a note of $81,000 at 8.1 percent over 60 months, paid at $1,646 a month. At 40 percent time utilization the lift bills $16,894 a year and ends the year $4,006 short after its note; at 70 percent it bills $29,565 and keeps $7,805. It covers its own note from 51 percent.
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other free models.
Equipment_Rental_Unit_Return_Calculator.xlsx (18 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 one-unit summary of The Equipment Rental Company Owner. The book explains every line: why the fleet is counted at original cost, how on-rent days are weighted, what realization hides, why a unit bought before its jobs arrive is a payment without revenue, and how the year is planned to the bank covenant.
DRM-free PDF, $19.99 → · Paperback, $32.99, shipped worldwide
Four sheets. Blue type is an input; black type is a formula.
Put realization back to 92 percent. Change one cell and watch rental revenue, contribution and the break-even utilization move without a single extra day on rent.
Finance less. Lower the financed share and see the note payment fall while the unit's earnings stay the same.
Replace the case. Type your own unit, rates and costs over the blue cells. If a line does not make sense, the definition beside it says what it measures.