Articles

How long does an equipment facility take to repay once the revolving period ends?

The run-off of a revolving pool is the sum of vintages of every age, so the facility repays faster than the contract tenor suggests, and the age mix decides how much faster.

A revolving equipment pool holds contracts of every age, so once new advances stop, a pool of 36-month level-pay contracts is at 58.0% of its peak nine months later, not the 77.5% that one freshly originated cohort would show. The facility is down to half of peak by month 12 and to a quarter by month 19; if every collection goes to the lender it is fully repaid in month 25, 11 months before the last contract matures.

The question comes up as soon as a revolving facility is documented: when the revolving period ends, an early amortisation trigger trips or the lender declines to extend, how quickly does the loan come back? The answer is not the contract tenor. It depends on what is in the pool, and a pool that has been revolving for years is a stack of vintages at every stage of repayment.

The assumptions

One illustrative equipment pool, per 1 of principal originated each month
ItemValue
Contract typeLevel-pay (annuity), no balloon
Contract rate9.00%, monthly
Tenor tested24, 36 and 48 months
Originations during the revolving periodEqual every month, so the pool holds one vintage of each age from 0 to T − 1 months
Advance rate88%, so the facility is 88% of the pool at peak
After the revolving periodNo new contracts; no losses, no extensions, no prepayments (tested separately below)

Step 1: the balance of one contract

A level-pay contract of 1 at monthly rate i over T months pays PMT = i / (1 − (1 + i)−T) each month. After k payments the balance left is b(k). At 9.00% over 36 months the monthly payment is 0.031800 per 1 of principal.

b(k) = (1 + i)k − PMT × ((1 + i)k − 1) / i

Excel: =-FV(rate/12,k,-PMT(rate/12,T,-1),1)

For a 36-month contract b(9) = 0.7746, b(18) = 0.5336 and b(27) = 0.2758. Principal is repaid slowly at first because the early payments are mostly interest.

Step 2: the pool is the sum of the vintages

At the end of the revolving period the pool holds T vintages, aged 0 to T − 1 months, each originated at the same size. Its balance is b(0) + b(1) + … + b(T − 1). Stop originating, and after m months each vintage is m months older, so the pool is the sum of b(m) to b(T − 1): the oldest vintages simply drop out of the sum.

Pool after m months as a share of peak = SUM(b(m) : b(T − 1)) / SUM(b(0) : b(T − 1))

Excel: =SUM(C{m}:C{T-1})/SUM(C0:C{T-1}), with b(k) in column C

For T = 36 the peak pool is 19.3054 times one month’s originations. At month nine the sum of b(9) to b(35) is 11.1957, which is 58.0% of the peak.

Step 3: the run-off by tenor

If collections are shared between the lender and the originator in proportion to the pool, the facility is the same share of its peak as the pool is of its own.

Facility balance as a share of peak, pro rata run-off
TenorMonth 3Month 6Month 9Month 12Month 18Month 24
24 months77.6%57.8%40.9%26.8%7.3%0.0%
36 months84.8%70.8%58.0%46.4%26.8%12.4%
48 months88.6%77.9%67.7%58.3%41.3%27.0%

Longer tenor means a slower run-off, but not in proportion: doubling the tenor from 24 to 48 months moves the month in which the pool is at half of peak from 8 to 15. The facility is not repaid at month T. Under a pro rata run-off it is still 12.4% of peak at month 24 on a 36-month pool, and the last cents of the pool take until month 35.

Step 4: if every collection goes to the lender

Most facilities do not run off pro rata after an early amortisation event. They apply all principal collections to the lender until it is repaid. The facility is then the pool balance minus the originator’s share of the peak pool, 1 − 88% = 12%:

Facility share of peak = (pool share − 12%) / 88%, floored at zero

Repaid when the pool share falls to 12%

On the 36-month pool the pool is at 12.4% of peak in month 24 and 10.5% in month 25, so the facility is repaid in month 25. The other tenors give month 17 for 24 months and month 33 for 48 months.

36-month pool, facility as a share of peak under three assumptions
MonthPro rata, mixed poolFull turbo, mixed poolPro rata, one new cohort
384.8%82.8%92.7%
670.8%66.8%85.1%
958.0%52.3%77.5%
1246.4%39.0%69.6%
1826.8%16.8%53.4%
2412.4%0.5%36.4%

At month nine the facility is 52.3% of peak under a full turbo against 58.0% pro rata. The cohort column is the run-off of a single pool of brand new contracts, which is how a quick calculation is often set up: it overstates what is still outstanding at month nine by 19.5 points.

What if: the contracts prepay at 10 per cent a year

A constant prepayment rate of 10 per cent a year (a monthly rate of 0.874%) speeds the run-off a little, because every vintage shrinks faster. On the 36-month pool the facility is halved by month 11 instead of 12, and the full-turbo repayment is in month 24 instead of 25. In this illustration prepayments shift the timing by about a month, so the age mix matters more than the speed.

The common mistakes

Takeaway

Questions readers ask

How long does a revolving equipment facility take to repay after the revolving period?

It depends on the age mix of the pool, not the contract tenor. For a pool of 36-month level-pay contracts at 9 per cent the facility is at 58.0% of peak after nine months and 46.4% after twelve if it runs off pro rata; with a full turbo it is repaid in month 25.

Why is the run-off faster than the contract tenor suggests?

Because a revolving pool holds contracts of every age. At the end of the revolving period a pool of 24-month contracts has an average remaining life of 8.8 months, against 12.9 months for one new contract.

What is the difference between a pro rata run-off and a full turbo?

Pro rata, the facility is the same share of its peak as the pool. With a full turbo the lender takes all principal collections and is repaid when the pool falls to the originator's share of the peak, 12 per cent at an 88 per cent advance rate. On the 36-month pool that is month 25.

The workbooks behind this article

The Meridian transaction in the free companion files for The Asset-Based Finance Handbook models the run-off of the facility in detail, beside the borrowing base, the triggers and the stressed case. Each workbook ends with a checks sheet setting the printed figure beside the computed one. The tables in this article are a separate illustration on level-pay contracts and are not in those workbooks. No account and no email address.

Open the companion files →

Not on Amazon: 11 paperbacks by Julian R. Sterling on banking, credit and payments, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

Reading guide: credit, private credit and distressed debt → · All 1908 articles →