Borrowing base certificate template excel 2025

1. Click ‘Get Form’ to open the borrowing base certificate template in the editor.
2. Begin by entering the Borrower’s name and the date at the top of the form. Ensure this information is accurate as it sets the context for your certificate.
3. Navigate to the Accounts Receivable Aging Summary section. Input the date of your most recent report and total accounts receivable amount. This data should be sourced from your latest financial reports.
4. Deduct any ineligible amounts, including those over 90 days and balances exceeding concentration limits. Fill these fields carefully to ensure compliance with lending requirements.
5. Calculate and enter the Total Eligible Receivables, Advance Rate, and Total Margined Receivables Amount based on your inputs from previous sections.
6. Proceed to the Inventory Summary section. Again, input the date of valuation and total inventory amount, followed by any ineligible inventory deductions.
7. Finally, calculate your Available Borrowing Base and current loan balance before certifying that all information provided is true by signing at the bottom of the form.

Start using our platform today for free to streamline your document editing and completion process!