Equipment Rental Fleet Addition Impact Test

Test whether a proposed fleet purchase clears operating, capital and financing thresholds before cash is committed.

About this analysis

The analysis evaluates one proposed fleet addition using owned-equipment rental revenue, acquisition OEC, operating cash contribution, deployment timing and financing. It solves the operating boundaries at which the purchase stops clearing the selected capital hurdle. For more information, visit our Equipment Rental FP&A practice.

↖ Enter the proposed purchase, then edit financing, hurdle and downside assumptions

Capital & downside assumptions

The primary hurdle is applied to steady-state operating cash contribution before financing. Financing is tested separately against cash available after scheduled debt service.

Assumption
Value
Basis
Hurdle type
User policy
Maximum unlevered payback (months)
User policy
Down payment (%)
Financing
APR (%)
Financing
Financing term (months)
Financing
Downside rate change (%)
User scenario
Downside billed-days change (%)
User scenario

Capital hurdle

—

—

Projected dollar utilization

—

Owned rental revenue ÷ acquisition OEC

Operating cash contribution

—

—

First constraint

—

—

Expected, downside and required economics

The required case is the minimum steady-state contribution needed to clear the selected capital hurdle. It is not a forecast.

Expected
Downside
Required
Rental revenue
—
—
—
Dollar utilization
—
—
—
Operating contribution
—
—
—
Hurdle gap
—
—
$0

Decision boundaries

Each boundary changes one assumption at a time while holding the others constant. Headroom measures the percentage change from the expected input to the failure point.

Maximum acquisition cost / unit
—
—
Minimum realized rental rate / day
—
—
Minimum billed rental days / unit
—
—
Maximum variable cash cost / billed day
—
—
Maximum APR before annual cash turns negative
—
—

Deployment and financing cash effect

Year one reflects only the months from the selected deployment month through December. The financing schedule begins in the deployment month for this planning view.

Acquisition OEC—
Initial cash at closing—
Scheduled annual debt service—
Steady-state cash after debt service—
Year-one months in service—
Year-one net cash after down payment and scheduled debt service—

What the analysis shows

—

—

CITY SHIFT FINANCE

Create your account

Continue your analyses, email calculation records, and return to your work from one account.

Have an account?

Contact us

Contact us

Contact

Topics of Interest:

Sign up to download