(215) 813-6811 info@DealChase.ai Sign In

General process guidance only. Deal Chase does not provide legal, tax, accounting, investment or valuation advice.

Your actual borrowing capacity is set by the lender's own review and underwriting.

What BorrowingBasePQ does

BorrowingBasePQ estimates how much a business could borrow against its assets. You enter your figures, and it applies the kinds of calculations asset-based lenders use to each class of asset: accounts receivable, inventory, machinery and equipment, and real estate. The result is a Borrowing Base report you can keep, update and share with prospective lenders.

The calculator runs through nine screens: Overview, Income & Expense, Assets & Liabilities, Debt Schedule, Accounts Receivable, Inventory, Machinery & Equipment, Real Estate, and Complete. Where a percentage is needed, the tool starts with a figure commonly used in asset-based lending. Lenders set their own rates, so treat the result as an estimate.

Before you start

Have these at hand:

  • Your most recent income statement and balance sheet

  • A schedule of current business debts

  • An accounts receivable aging report, by customer

  • An inventory listing with quantities, costs and values

  • A list of machinery and equipment with service dates and current values

  • Details of any real estate the business owns

Income & Expense

Enter profit before tax, owner or director compensation, interest expense, non-cash expenses (usually depreciation and amortization), and any one-time or non-operating expenses and revenues, for the current year and, if you have them, projections.

Assets & Liabilities

Enter book values from your balance sheet: accounts receivable, other current and non-current assets, fixed assets and intangible assets; then accounts payable, other current and non-current liabilities, long-term debt and contingent liabilities.

Debt Schedule

List each current obligation, including lines of credit, mortgages, installment debt, capital leases and shareholder loans, with the lender, original amount and date, interest rate, maturity, monthly payment and current balance. The schedule should match your most recent balance sheet.

Accounts Receivable

List receivables by customer and age: 1 to 30, 31 to 60, 61 to 90, and over 90 days. Receivables over 90 days are excluded. You then deduct offsets and ineligible accounts, allow for dilution (credits, returns and allowances that reduce what you actually collect), and apply an advance rate. The tool starts at 85%.

Inventory

List items with quantity, cost and value. The tool offers two approaches:

  • Book value method: applies an advance rate to inventory value, with a lower rate on excess inventory and a cap on how much inventory can count toward the borrowing base

  • Net orderly liquidation value (NOLV) method: starts from what the inventory would fetch in an orderly sale, often around half of book value, then applies an advance rate and a cap

Machinery & Equipment

List each item with its serial or asset number, date in service, remaining useful life, original value and current fair market value. The borrowing base is calculated from orderly liquidation value.

Real Estate

List each property with its type, year acquired, present fair market value, liens and mortgages, rental income and expenses. Non-owner-occupied property is excluded by default.

Complete: your Borrowing Base report

The final screen shows a Base Borrowing Capacity Summary: for each asset class, the gross value, the amount available and the borrowing base, alongside your current total loan balance. You can view and download the full report, and re-run it whenever your business changes.

Using the report

Take the report to asset-based lenders as part of a loan request. BorrowPQ walks you through the full borrowing process, from preparing the application to closing, and lets you search lenders on Deal Chase by loan amount, type and purpose. The Deal Chase Community lists CPAs and appraisers if you need independent valuations of receivables, inventory, equipment or real estate.

Ready to start with BorrowingBasePQ?

Registration is free. Prepare at your own pace, and ask Chase, our AI guide, whenever you have a question.

Get started

← All Insights

Ask Chase