Free Excel templates

A free equipment rental unit return calculator in Excel

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.

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.

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.

The book behind this calculator

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

What is in the file

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

Inputs
Original cost per unit and number of units; book monthly rate as a share of cost; days billed per rental month; realization; time utilization; delivery revenue, damage waiver fee and take rate; repairs, delivery cost and damage repair shares; depreciation; financed share, note rate and term; an optional resale value after a holding period.
Calculator
Yield per on-rent day at book and realized; rental revenue; dollar utilization; ancillary revenue and variable costs; contribution; depreciation and first-year interest; profit; the note payment and the cash left after it; the break-even time utilization; the same outputs from 30 to 80 percent utilization. Each line has a one-line definition beside it.
Read Me
How to replace the case with your own unit, and which inputs to check with your advisers.
Checks
The calculator compared with the figures printed in the book for the case.

Three things to try

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.

Related reading