Borrowing base certificate · Loan documents

Advance against the borrowing base after it has been recalculated.

Ineligibles are caught at the borrowing base certificate, before the next advance. Every figure the borrower reports is recomputed from the aging and inventory report behind it, under your eligibility rules and advance rates, and each difference from the borrower's number is explained. Your team advances on availability it has checked, period after period.

BORROWING BASE CERTIFICATE · ILLUSTRATIVE$1.5M REVOLVING LINE
The certificate as the borrower signed it
BORROWING BASE CERTIFICATE · SAMPLE FABRICATION, INC. · FISCAL YEAR END · PAGE 1
LINEAMOUNT
RECEIVABLES
1Gross receivables, per aging1,600,000
Less over 90 days(112,000)
Eligible receivables1,488,000
At 80%1,190,400
INVENTORY
2Gross inventory1,400,000
Less work in process(300,000)
Less slow-moving(100,000)
Eligible inventory1,000,000
At 50%, capped at 500,000500,000
AVAILABILITY
3Borrowing base1,690,400
Commitment1,500,000
4Loans outstanding(900,000)
Availability600,000
READ FROM THIS DOCUMENT, EACH FIGURE CITED
1Gross receivables$1,600,000BBC, p. 1 · Aging, p. 3
2Gross inventory$1,400,000BBC, p. 1 · Inventory report
3Borrowing base, as certified$1,690,400BBC, p. 1
4Loans outstanding$900,000BBC, p. 1
Ineligibles the certificate left in$188,000
Recalculated from the aging: cross-aging $20,000, concentration above 25% $120,000 and contra $48,000. The borrowing base falls to $1,540,000. Availability stays $600,000 under the commitment, but the cushion above it shrinks from $190,400 to $40,000.
Aging, pp. 1 to 3Loan agreement
What a credit officer checks on a certificate

Every ineligible, recomputed from the aging behind it.

Each check sets the certificate beside the agings, the inventory report or the balance sheet. The results come from the illustrative Sample Fabrication revolver.

THE CHECKON THE SAMPLE FILE · ILLUSTRATIVE
Totals against the balance sheet
Gross receivables and inventory should match the agings and the balance sheet for the same date.
TIES OUT
$1,600,000 and $1,400,000 on the certificate, the aging, the inventory report and the balance sheet.
BBC, p. 1Balance sheet
Past-due receivables
Balances more than 90 days from invoice are ineligible.
TIES OUT
$112,000 over 90 days, taken on the certificate. Over 60 days: $256,000, 16.0% of receivables.
Aging, p. 3
Cross-aging
When more than half a customer's balance is over 90 days, the rest of that balance goes too.
FLAGGED
Customer 7 owes $60,000, $40,000 of it over 90 days (66.7%). The other $20,000 is ineligible; the certificate counted it.
Aging, p. 2
Concentration
A single customer above 25% of receivables is ineligible above the limit.
FLAGGED
Customer 1 owes $520,000, 32.5% of receivables. The $120,000 above the $400,000 limit is ineligible; the certificate left it in.
Aging, p. 1
Contra accounts
A customer that is also a supplier can offset what it owes.
FLAGGED
Customer 4 owes $90,000 and is owed $48,000 as a supplier. The $48,000 is ineligible and was not taken.
Aging, p. 2Payables aging
Inventory and the sublimit
Work in process and slow-moving stock are ineligible, and the inventory advance is capped.
TIES OUT
$400,000 ineligible. $1,000,000 eligible at 50% is $500,000, exactly at the cap.
Inventory reportBBC, p. 1
What LenderBox returns

A $1,540,000 borrowing base, recalculated against $1,690,400 certified.

Each certificate comes back recalculated, with every difference from the borrower's figures explained.

RECALCULATEDEach certificate is recalculated from the agings and inventory reports behind it, under your eligibility rules and advance rates.
CITED TO THE AGINGEvery ineligible and every exception is cited to the aging and the policy section.
YOUR FIGURE AND THEIRSWhere your figure and the borrower's differ, you see why, customer by customer.
EVERY PERIODCertificates, covenants and key dates stay in view each period, and anything outside your credit box is flagged.
See covenant monitoring across the book →
WHERE THE FIGURES GO · ILLUSTRATIVESAME SAMPLE FILE
Base, availability and cushion
BORROWING BASE$1,540,000 recalculated, against $1,690,400 certified
Aging, pp. 1 to 3
AVAILABILITY$600,000 under the $1,500,000 commitment
BBC, p. 1
UTILIZATION60.0% of the commitment drawn
COVENANT MONITORINGCushion above the commitment down to $40,000, on the record

The reserve call your team makes before the next advance.

Reading the certificate
LENDERBOX DOESReads the certificate, the receivables and payables agings and the inventory report.
STAYS WITH YOUR TEAMWhich reports the borrower must deliver, and how often.
Eligibility
LENDERBOX DOESApplies your eligibility rules and advance rates to every customer and every stock category.
STAYS WITH YOUR TEAMThe rules and rates themselves, and any waiver.
Differences
LENDERBOX DOESShows each difference from the certified figure, with the aging page behind it.
STAYS WITH YOUR TEAMWhether to advance, add a reserve or call the borrower.
Each period
LENDERBOX DOESKeeps every period's certificate in view beside your covenants and key dates.
STAYS WITH YOUR TEAMWhen a field examination is due.
The record
LENDERBOX DOESKeeps the recalculation and every exception on the record for the annual review.
STAYS WITH YOUR TEAMThe renewal decision.

Underwritten once, recalculated for the life of the line.

01 · FIRST LOOKThe latest certificate with the request shows how much of the line the collateral really supports.
02 · UNDERWRITINGAdvance rates, sublimits and eligibility rules are tested against your credit box before you commit.
03 · CREDIT DECISIONCommittee sees availability as recalculated, with each ineligible cited.
04 · CLOSINGCertificate timing is fixed in the loan agreement.
05 · LIFE OF THE LOAN · THIS DOCUMENTEach certificate is recalculated from the agings as it arrives, with covenant monitoring on the line.

For the asset-based lending desk, answered

Does LenderBox recalculate the borrowing base?

Yes. Each certificate is recalculated from the agings and inventory reports behind it, under your eligibility rules and advance rates.

Does inventory have ineligibles too?

Yes. Work-in-process and slow-moving inventory come out alongside receivables over 90 days, cross-aging, concentration above 25% of receivables and contra accounts, each cited to the page it came from.

What happens when our figure and the borrower's differ?

You see both, and why. On the sample, the certificate shows a $1,690,400 borrowing base. Recalculated, it is $1,540,000, with the $188,000 of ineligibles the certificate left in listed by customer.

How often are certificates reviewed?

As often as the loan agreement requires them. Certificates, covenants and key dates stay in view each period, and anything outside your credit box is flagged.

Does it track utilization of the line?

Yes, with each certificate. On the sample, the line is 60% used, and the cushion falls to $40,000 once recalculated.

Recalculate a real certificate from its agings.

The demo can run on your own deal documents: a real certificate, recalculated from its agings, with every ineligible cited.

See it in action
30 MINUTES. NO COMMITMENT. 90-DAY MONEY-BACK GUARANTEE.
Not ready to talk? See pricing