Finance:Borrowing base

From HandWiki

Borrowing base is an accounting metric used by financial institutions to estimate the available collateral on a borrower's assets in order to evaluate the size of the credit that may be extended.[1] Typically, the calculation of borrowing base is used for revolving loans, and the borrowing base determines the maximum credit line available to the borrower.[2][3] Occasionally, borrowing base is also used to determine the maximum size of a term loan. Depending on the contractual terms of the loan, the assets included in the calculation of the borrowing base may be used as collateral for the loan.[4]

Calculation

For corporations and small businesses

Borrowing base is frequently used for asset-based commercial loans offered by banks to corporations and small businesses.[5] In this case, borrowing base of a business is typically calculated of corporation's accounts receivable and of its inventory.[6] Work in process is excluded from borrowing base.[7] Also excluded are the accounts receivable from bankrupt customers[8] and accounts receivable that are too old[9] – usually over 90 days past due[10] (in some cases over 120 days past due.[11])

Different proportions (or 'advance rates') of accounts receivable and of the inventory are included into borrowing base. Typical industry standards are 75–85% for accounts receivable[1][12] and 25–60% for inventory,[7] and the advance rates can vary dramatically depending on the circumstances.[1]

Lenders' methods of assessment of the inventory value vary. A lender can hire an independent contractor to evaluate borrower's inventory[13] or use averaging, adjusted for a particular industry. For example, Moody's is reportedly applying Monte-Carlo method over inventory price fluctuations within each industry to determine risk free advance rates.[14]

Summary of advance rates in borrowing base calculations
Assets Typical advance rate Factors that increase advance rate Factors that decrease advance rate
Accounts receivable 75–85%[1][12] diversification of accounts receivable[1] errors in borrower's reports;[15] bad credit history of the payees;[6]
Inventory 25–60%[7] (or up to 85% of its net liquidation value.[12]) errors in borrower's reports;[15] inventory aged, out of date, or unpacked[6]
Commodities Up to 90%[1] volatility of the commodity price[16]

Past due accounts payable are typically subtracted from the borrowing base.[17]

In case of revolving loans, lenders demand periodic recalculations of borrowing base and subsequently adjust the credit limit. Traditionally, banks recalculated borrowing base for businesses yearly, biannually, or monthly.[18] In recent years, however, such 'fixed' borrowing base is deemed risky, as company's assets fluctuate in time.[1][19] This consideration and the advancement of computer technology prompted weekly[20] and daily[21] recalculations of borrowing base.[22] Regardless of the need of a loan, recurrent calculations of its own borrowing base is currently one of the accounting best practices.[23]

For financial institutions

Borrowing base of financial institutions who themselves apply for asset-based revolving loans is calculated by summing up all tangible working assets (typically cash, bonds, stocks, etc.) and subtracting from it all senior debt, i.e. all other accumulated debt that does not rank behind other debt for repayment in the event of a liquidation.[24]

For government organizations

Borrowing base of government organizations is calculated similar to that of corporations. However, in many cases there are government restrictions on pledges of some or all of the accounts receivable. Such accounts receivable are excluded from the borrowing base.[6]

Borrowing base certificates

An example of a borrowing base certificate used in asset-based lending

Borrowing base certificate is the official accounting document prepared by the borrower that certifies the size of the borrowing base of an organization with the previously agreed advance rates.[11] Borrowing base certificate includes a summary calculation sheet. In its paper form, a borrowing base certificate is signed by the authorized representative of the organization, typically by the organization's CFO, as errors in the calculation of borrowing base can result in various penalties (loan interest rate increase, demand of early loan repayment, etc.)[25][26]

As lenders demand the submission of borrowing base certificates more frequently (weekly[20] or even daily[21]), software applications become available that can automate these submissions. For example, BBC Easy application automates these submissions for small businesses.[27]

Junior and senior borrowing bases

Junior borrowing base and senior borrowing base are calculated for the financial institutions and large corporations which have structured debt. In these cases, senior borrowing base is associated with senior debt and calculated of all assets. On the other hand, junior borrowing base is associated with junior debt and calculated of assets that are not already pledged for senior debts.[28][29] Thus junior borrowing base is always smaller than senior borrowing base.[30]

See also

References

  1. 1.0 1.1 1.2 1.3 1.4 1.5 1.6 Kazemi, Black & Chambers 2016, p. 825.
  2. Taylor & Sansone 2006, pp. 254–255.
  3. Marks et al. 2005, pp. 170–172.
  4. Koch & MacDonald 2014, p. 569.
  5. Taylor & Sansone 2006, pp. 254, 272.
  6. 6.0 6.1 6.2 6.3 Marks et al. 2005, p. 172.
  7. 7.0 7.1 7.2 Wiersema 2006, p. 29.03.
  8. Bragg 2010, p. 161.
  9. Whitney 1998, p. 60.
  10. Wiersema 2006, p. 29.01.
  11. 11.0 11.1 Marks et al. 2005, p. 203.
  12. 12.0 12.1 12.2 Bagaria 2016, p. 69.
  13. Bagaria 2016, pp. 68–70.
  14. Fabozzi & Choudhry 2004, p. 266.
  15. 15.0 15.1 Bragg 2010, p. 311.
  16. Fabozzi & Choudhry 2004, pp. 266–268.
  17. Wiersema 2006, pp. 29.03–29.04.
  18. Nassberg 1981, pp. 843–845.
  19. Fabozzi & Choudhry 2004, pp. 266–267.
  20. 20.0 20.1 Marks et al. 2005, p. 291.
  21. 21.0 21.1 Schroeder & Tomaine 2007, p. 285.
  22. DeYoung & Hunter 2003, p. 210.
  23. Bragg 2010, p. 107.
  24. Terry 2000, p. 816.
  25. Bragg 2012, pp. 260–264, 364–380.
  26. Milad 2010, p. 14.
  27. Keeton 2013.
  28. Marks et al. 2005, p. 208.
  29. Whitman & Diz 2013, pp. 50–52.
  30. Whitman & Diz 2013, p. 51.

Literature cited

   class="Z3988"
   class="Z3988"
   class="Z3988"
   class="Z3988"
   class="Z3988"
   class="Z3988"
   class="Z3988"
   class="Z3988"
   class="Z3988"
   class="Z3988"
   class="Z3988"
   class="Z3988"
   class="Z3988"
   class="Z3988"
   class="Z3988"
   class="Z3988"
   class="Z3988"
   title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=Accounting+Best+Practices&rft.aulast=Bragg&rft.aufirst=Steven+M.&rft.au=Bragg%2C%26%2332%3BSteven+M.&rft.date=29+January+2010&rft.series=Wiley+Best+Practices&rft.edition=6th&rft.pub=John+Wiley+%26+Sons&rft_id=info:oclcnum/746577431&rft.isbn=978-0470561652&rfr_id=info:sid/en.wikibooks.org:Finance:Borrowing_base"> 
   title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=Accounting+Policies+and+Procedures+Manual%3A+A+Blueprint+for+Running+an+Effective+and+Efficient+Department&rft.aulast=Bragg&rft.aufirst=Steven+M.&rft.au=Bragg%2C%26%2332%3BSteven+M.&rft.date=2012&rft.edition=6th&rft.place=Hoboken%2C+NJ&rft.pub=John+Wiley+%26+Sons&rft_id=info:oclcnum/864912888&rft.isbn=978-1118428665&rfr_id=info:sid/en.wikibooks.org:Finance:Borrowing_base"> 
   title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=Bank+Management&rft.aulast=Koch&rft.aufirst=Timothy+W.&rft.au=Koch%2C%26%2332%3BTimothy+W.&rft.au=MacDonald%2C%26%2332%3BS.+Scott&rft.date=September+11%2C+2014&rft.edition=8th&rft.place=Australia&rft.pub=Cengage+Learning&rft.isbn=978-1133494683&rfr_id=info:sid/en.wikibooks.org:Finance:Borrowing_base"> 
   title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=Business+Management+Handbook+Paperback&rft.aulast=Milad&rft.aufirst=Anis+I.&rft.au=Milad%2C%26%2332%3BAnis+I.&rft.date=February+18%2C+2010&rft.pub=AuthorHouse&rft.isbn=978-1449086602&rfr_id=info:sid/en.wikibooks.org:Finance:Borrowing_base"> 
   title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=CAIA+Level+II%3A+Advanced+Core+Topics+in+Alternative+Investments&rft.aulast=Kazemi&rft.aufirst=Hossein+B.&rft.au=Kazemi%2C%26%2332%3BHossein+B.&rft.au=Black%2C%26%2332%3BKeith+H.&rft.au=Chambers%2C%26%2332%3BDonald+R.&rft.date=October+10%2C+2016&rft.edition=3rd&rft.pub=John+Wiley+%26+Sons&rft_id=info:oclcnum/918590725&rft.isbn=978-1119016397&rfr_id=info:sid/en.wikibooks.org:Finance:Borrowing_base"> 
   title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=High+Yield+Debt%3A+An+Insider%27s+Guide+to+the+Marketplace&rft.aulast=Bagaria&rft.aufirst=Rajay&rft.au=Bagaria%2C%26%2332%3BRajay&rft.date=March+28%2C+2016&rft.series=Wiley+Finance&rft.pub=John+Wiley+%26+Sons&rft_id=info:oclcnum/931227000&rft.isbn=978-1119134435&rfr_id=info:sid/en.wikibooks.org:Finance:Borrowing_base"> 
   title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=Loan+Loss+Coverage+Under+Financial+Institution+Bonds&rft.aulast=Schroeder&rft.aufirst=Gilbert+J.&rft.au=Schroeder%2C%26%2332%3BGilbert+J.&rft.au=Tomaine%2C%26%2332%3BJohn+J.&rft.date=2007&rft.pub=American+Bar+Association&rft_id=info:oclcnum/182518909&rft.isbn=978-1590319437&rfr_id=info:sid/en.wikibooks.org:Finance:Borrowing_base"> 
   title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=Manufacturing%2C+Distribution+and+Retail+Guide&rft.aulast=Wiersema&rft.aufirst=William&rft.au=Wiersema%2C%26%2332%3BWilliam&rft.date=April+14%2C+2006&rft.place=Chicago%2C+IL&rft.pub=CCH&rft_id=info:oclcnum/163811021&rft.isbn=0808090240&rfr_id=info:sid/en.wikibooks.org:Finance:Borrowing_base"> 
   title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=Modern+Security+Analysis%3A+Understanding+Wall+Street+Fundamentals&rft.aulast=Whitman&rft.aufirst=Martin+J.&rft.au=Whitman%2C%26%2332%3BMartin+J.&rft.au=Diz%2C%26%2332%3BFernando&rft.date=May+20%2C+2013&rft.series=Wiley+Finance&rft.edition=1st&rft.pub=John+Wiley+%26+Sons&rft_id=info:oclcnum/824120039&rft.isbn=978-1118390047&rfr_id=info:sid/en.wikibooks.org:Finance:Borrowing_base"> 
   title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=Taking+Charge%3A+Management+Guide+to+Troubled+Companies+and+Turnarounds&rft.aulast=Whitney&rft.aufirst=John+O.&rft.au=Whitney%2C%26%2332%3BJohn+O.&rft.date=January+19%2C+1998&rft.place=Washington+DC&rft.pub=Beard+Books&rft_id=info:oclcnum/642999540&rft.isbn=1893122034&rfr_id=info:sid/en.wikibooks.org:Finance:Borrowing_base"> 
   title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=The+Handbook+of+European+Structured+Financial+Products&rft.aulast=Fabozzi&rft.aufirst=Frank+J.&rft.au=Fabozzi%2C%26%2332%3BFrank+J.&rft.au=Choudhry%2C%26%2332%3BMoorad&rft.date=March+4%2C+2004&rft.series=Frank+J.+Fabozzi&rft.place=Hoboken%2C+NJ&rft.pub=John+Wiley+%26+Sons&rft_id=info:oclcnum/54712778&rft.isbn=0471484156&rfr_id=info:sid/en.wikibooks.org:Finance:Borrowing_base"> 
   title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=The+Handbook+of+Financing+Growth%3A+Strategies+and+Capital+Structure&rft.aulast=Marks&rft.aufirst=Kenneth+H.&rft.au=Marks%2C%26%2332%3BKenneth+H.&rft.au=Robbins%2C%26%2332%3BLarry+E.&rft.au=Fernandez%2C%26%2332%3BGonzalo&rft.au=Funkhouser%2C%26%2332%3BJohn+P.&rft.date=April+1%2C+2005&rft.series=Wiley+Finance&rft.edition=1st&rft.pub=John+Wiley+%26+Sons&rft_id=info:oclcnum/56753022&rft.isbn=0471726311&rfr_id=info:sid/en.wikibooks.org:Finance:Borrowing_base"> 
   title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=The+Handbook+of+Loan+Syndications+and+Trading&rft.aulast=Taylor&rft.aufirst=Allison&rft.au=Taylor%2C%26%2332%3BAllison&rft.au=Sansone%2C%26%2332%3BAlicia&rft.date=August+18%2C+2006&rft.pub=McGraw+Hill+Professional&rft_id=info:oclcnum/64770803&rft.isbn=0071468986&rfr_id=info:sid/en.wikibooks.org:Finance:Borrowing_base"> 
   title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=book&rft.btitle=The+International+Handbook+of+Corporate+Finance&rft.aulast=Terry&rft.aufirst=Brian+J.&rft.au=Terry%2C%26%2332%3BBrian+J.&rft.date=June+1%2C+2000&rft.series=Glenlake+Business+Reference+Books&rft.edition=3rd&rft.pub=Taylor+%26+Francis&rft_id=info:oclcnum/48139916&rft.isbn=188899830X&rfr_id=info:sid/en.wikibooks.org:Finance:Borrowing_base"> 
   title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook&rft.genre=bookitem&rft.btitle=Chapter+10%3A+The+Future+of+Relationship+Lending&rft.atitle=The+Future+of+Banking&rft.aulast=DeYoung&rft.aufirst=Robert&rft.au=DeYoung%2C%26%2332%3BRobert&rft.au=Hunter%2C%26%2332%3BWilliam+C.&rft.date=September+30%2C+2003&rft.pages=pp.%26nbsp%3B203%E2%80%93228&rft.pub=Greenwood+Publishing+Group&rft.isbn=1567204678&rfr_id=info:sid/en.wikibooks.org:Finance:Borrowing_base"> 
   title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=Loan+Documentation%3A+Basic+But+Crucial&rft.jtitle=The+Business+Lawyer%3A+A+Bulletin+of+the+Section+on+Corporation%2C+Banking%2C+and+Mercantile+Law&rft.aulast=Nassberg&rft.aufirst=Richard+T.&rft.au=Nassberg%2C%26%2332%3BRichard+T.&rft.date=1981&rft.volume=36&rft.issue=3&rft.pages=843%E2%80%93934&rft.place=Chicago%2C+IL&rft.pub=%5B%5BOrganization%3AAmerican+Bar+Association%7CAmerican+Bar+Association%5D%5D&rft_id=info:oclcnum/60617274&rft.issn=0007-6899&rfr_id=info:sid/en.wikibooks.org:Finance:Borrowing_base"> 
   title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Ajournal&rft.genre=article&rft.atitle=Numerica+Credit+Union+Adopts+C%26I+Lending+Program&rft.jtitle=Credit+Union+Times&rft.aulast=Keeton&rft.aufirst=Ann&rft.au=Keeton%2C%26%2332%3BAnn&rft.date=April+3%2C+2013&rft_id=info:oclcnum/867675674&rft.issn=1058-7764&rft_id=http%3A%2F%2Fwww.cutimes.com%2F2013%2F04%2F03%2Fnumerica-credit-union-adopts-ci-lending-program&rfr_id=info:sid/en.wikibooks.org:Finance:Borrowing_base"> 
  • <span class="citation Journal"
  • <span class="citation book"
  • <span class="citation book"
  • <span class="citation book"
  • <span class="citation book"
  • <span class="citation book"
  • <span class="citation book"
  • <span class="citation book"
  • <span class="citation book"
  • <span class="citation book"
  • <span class="citation book"
  • <span class="citation book"
  • <span class="citation book"
  • <span class="citation book"
  • <span class="citation book"
  • <span class="citation book"
  • Bagaria, Rajay (March 28, 2016). Buchman, Emil. ed. High Yield Debt: An Insider's Guide to the Marketplace. Wiley Finance. John Wiley & Sons. ISBN 978-1119134435. OCLC 931227000.Bragg, Steven M. (2012). Accounting Policies and Procedures Manual: A Blueprint for Running an Effective and Efficient Department (6th ed.). Hoboken, NJ: John Wiley & Sons. ISBN 978-1118428665. OCLC 864912888.Bragg, Steven M. (29 January 2010). Accounting Best Practices. Wiley Best Practices (6th ed.). John Wiley & Sons. ISBN 978-0470561652. OCLC 746577431.DeYoung, Robert; Hunter, William C. (September 30, 2003). "Chapter 10: The Future of Relationship Lending". in Gup, Benton E.. The Future of Banking. Greenwood Publishing Group. pp. 203–228. ISBN 1567204678.Fabozzi, Frank J.; Choudhry, Moorad (March 4, 2004). The Handbook of European Structured Financial Products. Frank J. Fabozzi. Hoboken, NJ: John Wiley & Sons. ISBN 0471484156. OCLC 54712778.Kazemi, Hossein B.; Black, Keith H.; Chambers, Donald R. (October 10, 2016). CAIA Level II: Advanced Core Topics in Alternative Investments (3rd ed.). John Wiley & Sons. ISBN 978-1119016397. OCLC 918590725.Keeton, Ann (April 3, 2013). "Numerica Credit Union Adopts C&I Lending Program". Credit Union Times. ISSN 1058-7764. OCLC 867675674. http://www.cutimes.com/2013/04/03/numerica-credit-union-adopts-ci-lending-program.Koch, Timothy W.; MacDonald, S. Scott (September 11, 2014). Bank Management (8th ed.). Australia: Cengage Learning. ISBN 978-1133494683.Marks, Kenneth H.; Robbins, Larry E.; Fernandez, Gonzalo; Funkhouser, John P. (April 1, 2005). The Handbook of Financing Growth: Strategies and Capital Structure. Wiley Finance (1st ed.). John Wiley & Sons. ISBN 0471726311. OCLC 56753022.Milad, Anis I. (February 18, 2010). Business Management Handbook Paperback. AuthorHouse. ISBN 978-1449086602.Nassberg, Richard T. (1981). "Loan Documentation: Basic But Crucial". The Business Lawyer: A Bulletin of the Section on Corporation, Banking, and Mercantile Law (Chicago, IL: American Bar Association) 36 (3): 843–934. ISSN 0007-6899. OCLC 60617274.Schroeder, Gilbert J.; Tomaine, John J. (2007). Loan Loss Coverage Under Financial Institution Bonds. American Bar Association. ISBN 978-1590319437. OCLC 182518909.Taylor, Allison; Sansone, Alicia (August 18, 2006). The Handbook of Loan Syndications and Trading. McGraw Hill Professional. ISBN 0071468986. OCLC 64770803.Terry, Brian J. (June 1, 2000). The International Handbook of Corporate Finance. Glenlake Business Reference Books (3rd ed.). Taylor & Francis. ISBN 188899830X. OCLC 48139916.Whitman, Martin J.; Diz, Fernando (May 20, 2013). Modern Security Analysis: Understanding Wall Street Fundamentals. Wiley Finance (1st ed.). John Wiley & Sons. ISBN 978-1118390047. OCLC 824120039.Whitney, John O. (January 19, 1998). Taking Charge: Management Guide to Troubled Companies and Turnarounds. Washington DC: Beard Books. ISBN 1893122034. OCLC 642999540.Wiersema, William (April 14, 2006). Manufacturing, Distribution and Retail Guide. Chicago, IL: CCH. ISBN 0808090240. OCLC 163811021.<span