Modeling the economics of an industrial rental business

My client in this project was the supplier. The company was evaluating coated-pipe rental as a new direction of business and needed to understand how it could work financially over many years before quoting a customer.

The first task was to establish the supplier’s viable price. The lower boundary had to cover pipe purchases, coating, inspection, repair, replacement, operating costs and the cost of external financing required to build the rental fleet. The model also had to show cash recovery and how sensitive the result was to demand, utilization and lifecycle assumptions.

The second task was commercial. A technically viable rental price still had to be attractive compared with the customer buying and maintaining the pipes. I therefore connected the supplier economics and the customer ownership comparison in one model. Together they show the pricing space available to the supplier: what the business needs to charge and what the customer can reasonably be offered.

The same logic then became part of the sales process. Alongside the full internal model, I created customer-facing interfaces in Google Sheets and on the web so the supplier could explain the economics of rental, compare it with ownership and use the analysis in B2B sales conversations.

The demand plan is variable across the full forecast horizon. This matters because the supplier must have enough serviceable units available when the customer needs them, not simply enough purchases in total.

After a pipe enters service, the model applies annual lifecycle flows. A share returns for inspection, a share requires repair, serviceable units go back into the rental pool, and units that can no longer be reused are replaced. The timing of those movements determines purchases, repair workload, utilization and cash needs.

For the supplier, the customer’s total cost of ownership provides the commercial reference point for pricing. The relevant alternative includes the initial purchase price, inspection, repair, administration, replacement and the cost of holding enough inventory through changing demand.

The model builds rental and ownership from the same demand and lifecycle assumptions and compares their annual and cumulative cost. This shows how far the supplier can move above the minimum viable price while keeping rental attractive to the customer.

I also translated this comparison into simpler customer-facing Google Sheets and web-calculator interfaces. They let the supplier adjust the assumptions relevant to a specific customer and explain where the economic value of rental comes from without exposing the full internal financial model.

Rental creates recurring revenue, but the supplier must purchase and coat the pipe fleet before the corresponding cash is earned. External financing is therefore part of the product economics, not a separate corporate assumption.

I separated operating cash, fleet investment and financing so the model shows the maximum funding requirement, interest cost and the point at which cumulative cash recovers. A proposed rental price can then be tested against the supplier’s full cost base rather than only against operating expenses.

This supplier view is deliberately separate from the customer-facing comparison. It focuses on the internal economics of the new business line: rental revenue, operating cash, fleet investment, financing, profit and cumulative cash recovery.

The completed internal model calculates the economics of the entire project by linking the project quote, long-term demand, customer comparison, supplier economics, external financing and physical pipe lifecycle. A change in a commercial or operating assumption flows through the connected views.

The supplier can use it to set the initial price for the new business line, test the variables that matter most, plan the required fleet and financing, and see how each change affects customer savings, project cash and investment recovery.

The customer-facing Google Sheets and web interfaces use the same core comparison in a simpler form. They turn the analysis into a B2B sales tool: the supplier can demonstrate the customer’s own rent-versus-purchase economics while keeping the detailed internal model private.

Financial models contain sensitive information beyond the figures themselves. The structure, assumptions, calculation logic and commercial relationships can reveal how a client plans to operate and compete.

For that reason, I use separate demonstrations for public case studies. The video and screenshots on this page show the key modeling approaches in a deliberately simplified example built with entirely synthetic data. They do not reproduce the client’s numbers or the full logic of the original model.