Equipment leasing financial model in Excel

An equipment leasing financial model in Excel should connect rented equipment-days and daily rates to rental billings, maintenance costs and customer receipts. Keep the operating forecast separate from lease-accounting judgments, and show how receivables turn billings into cash. The layout below is for a US equipment lessor planning its rental operations.

Start with the operating records

Use an asset register, dated rental activity, the billing register, maintenance expenses and customer receipts. Give each asset and contract a stable identifier. Rental activity supplies the days; the billing register supplies the charges; receipts tell you when customers paid.

Choose one definition of capacity. This workbook counts all calendar days for the fleet, including maintenance downtime. That makes the denominator stable and shows downtime through fewer rented days. If you use available-for-rent days instead, label that measure and keep a separate downtime reconciliation.

Work by equipment class when rates or operating costs differ. Aggregate only after calculating each class. Rental fleet planning differs from subscription planning; the SaaS financial workbook uses a different operating driver. Do not borrow its customer-count logic for physical equipment.

Lay out the assumptions and monthly formulas

Put row labels in A and January through March 2027 in B:D. The example company has 20 equivalent units throughout the quarter. Purchases replace equipment without changing fleet count; there are no disposal receipts. All billings are USD, with no discounts, taxes or ancillary charges in this example.

Keep input cells distinct from formulas. The purchase row is a cash outflow, separate from monthly maintenance. For this simplified forecast, maintenance and payroll are paid in the month incurred, and there are no other cash flows. Add financing, taxes and other payments as separate rows when applying the layout to your business.

Enter these calculations in B, then copy across:

Operating surplus here is before depreciation, financing and taxes. It is a planning subtotal under the stated assumptions, not a complete income statement. Utilization is displayed to one decimal place; calculations use unrounded values.

Quarterly rented days are 450 + 420 + 480 = 1,350. Fleet-days are 620 + 560 + 620 = 1,800, so quarterly utilization is 75.0%. Quarterly rental billings are $162,000, maintenance is $35,700, and payroll and administration are $54,000. The resulting operating surplus is $72,300.

For rows representing several equipment classes, Microsoft's SUMPRODUCT function multiplies corresponding values and sums the products. Use it to total rented days times rates by class, rather than multiplying total days by an unweighted average rate.

Connect billings to receivables and cash

Assume customers pay 80% of current-month billings in the current month and the remaining 20% in the following month. Opening January receivables are $18,000 and are collected in January. Opening cash is $100,000. There are no bad debts, credit adjustments or older overdue balances in this example.

Put the 80% collection assumption in B15, C15 and D15. Use the following rows:

In C16 use =B18, and in C19 use =B21; copy these links into March. January receipts are $54,000 × 80% + $18,000 = $61,200. Collecting opening receivables explains why receipts can exceed that month's billings.

Receipts total $168,480. Check the quarter's receivables identity: $18,000 + $162,000 - $168,480 = $11,520. Cash also reconciles: $100,000 + $168,480 - $35,700 - $54,000 - $50,000 = $128,780.

The $28,780 increase in cash differs from the $72,300 operating surplus because receivables release $6,480 and equipment purchases use $50,000. The check is $72,300 + $6,480 - $50,000 = $28,780. The cash flow forecast guide covers the broader schedule when your receipts and payments need more detail.

Test one operating change and compare actuals

Change March rented days from 480 to 450, holding every other input fixed. Utilization falls to 72.6%. Billings decline by $3,600, variable maintenance falls by $360, and operating surplus falls by $3,240 to $24,100. Current-month receipts fall by $2,880, closing receivables fall by $720, and closing cash becomes $126,260.

This separates utilization from pricing and payment timing. Change those inputs in separate scenarios so the reason for a cash movement stays visible.

For actuals, retain month and equipment class on each billing and maintenance row. Microsoft documents SUMIFS for summing values that meet several criteria. If Actuals contains month in A, class in B and rental billings in C, a monthly class total is:

=SUMIFS(Actuals!$C$2:$C$5000,
        Actuals!$A$2:$A$5000,B$1,
        Actuals!$B$2:$B$5000,$A2)

Use real month-start dates consistently in both places. Keep the approved plan intact and calculate actual minus plan separately. The budget versus forecast guide explains how those versions serve different decisions.

Where it goes wrong

• Mixing capacity definitions. Owned fleet-days and available-for-rent days produce different utilization rates. Show the denominator and reconcile changes in fleet.
• Treating billings as collections. Receivables and payment timing belong in their own roll-forward; overdue balances need explicit assumptions.
• Charging purchases as maintenance. Separate cash asset purchases from recurring operating costs and from accounting depreciation.
• Using a blended rate without weights. Calculate each class first when equipment types have different day rates or costs.
• Calling the forecast accounting compliance. Contract terms, recognized revenue and lease classification need separate accounting review. This worksheet does not determine them.

Covirage is not affiliated with Microsoft.

Compare your equipment operating workbook in Covirage

Upload your rental activity, maintenance and receipt workbook, or a Google Sheet; Covirage maps the columns, and its tools compute and check the figures. The external AI model explains the results with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data; creating the account takes about a minute.

See Covirage for FP&A reporting for the supporting workflow.