As highlighted in On Demand Credit Facility Overview and Process, there are three main steps in onboarding a facility with our Managed Credit Facility Offering. While the interface allows for a user to onboard fully self sufficiently, dv01 is happy to help with the onboarding:


  1. Runs and Create Borrowing Base
    1. Access different runs (scenarios) and create a borrowing base.
    2. Linking and configuring the datasets that dv01 has ingested as well as mapping the fields needed for each dataset.
  2. Templates and Defining Variables - Borrowing Base Generation
    1. Creating or using a template.
    2. Defining eligibility restrictions, advance rates, excess concentrations, leverage reduction amounts (reserve accounts), manual inputs, and aggregations.
  3. Generate a Borrowing Base
    1. Automation of the borrowing base output.
    2. View the output via our front end and download the excel report highlighting the loan tape, borrowing base specific output, and custom aggregations.


In this section, we will run through the basics of what you need prior to generating a borrowing base.  This includes

  • Runs - different scenarios that one has run. This could include different datasets, vehicles and terms used.
  • Create Borrowing Base - this will take us to where we can configure and map fields to the borrowing base.


Runs


This is where we can view and access multiple runs we have created and helps us navigate to:

  • Viewing the report of a particular run.
  • Edit a scenario that we had built for a borrowing base.
  • Download the output in excel format.
  • Create a borrowing base.


Create Borrowing Base and Data Configuration


You can create a new borrowing base from the Runs page on the top right of the page. 


Before we build out the borrowing base, we need to access the Datasets and Tables we want to use. For some datasets, if you want to access a particular date you can fill in the "Where" column of the Datasets table. 


 


Users can add multiple datasets if they are aggregating across different daily files or asset types. We also need to map certain data fields like:

  • Loan ID - this is the loan identifier field from table like loan_id_reported or UUID.
  • UPB (unpaid principal balance) - used for weighing in the table like loan_balance_current.
  • As Of Date - activity date field.
  • Platform - used for denoting distinct collateral types/originators within the same facility.
  • Account Name - used to denote vehicle allocation and determinizing immovability. 
  • Transaction Costs (not required) - could be exit fees if loans move outside a vehicle. 


Additionally, we need to configure the facility that we want to create the borrowing base from. This includes:

  • We can name a facility however you want.
  • Define the advance rate limit in dollar form and/or percentage.
  • Use Platform Name as it appears in the dataset table that the facility pertains too (i.e. XYZ Lender).
  • Designate an Account Name and it will be immovable.
  • Filter can be used if you want to use a particular dataset if you have multiple in the Datasets table.


Users can also access prior runs with the cog wheel icon labeled Load. This allows you to replicate the format, defined variables, and datasets that has been run in your environment.