Loan Prospect

A loan prospect is essentially a potential borrower who has been identified as a suitable candidate for a loan. The loan prospect process involves identifying, assessing, and nurturing these potential customers to convert them into actual borrowers.

Loan Process

The "Add New" feature under the "Loan Prospect" module allows users to create a new loan prospect record within the system.

To facilitate the creation of a loan prospect, the system provides search functionalities based on the following customer identifiers.
- - - Customer ID: A unique numerical or alphanumeric code assigned to each customer.
    - Family book No: The identification number of an individual or a corporate entity.
    - Phone No: The customer's contact phone number.
    - Customer Name: The name of the customer.

The "Add Prospect Form" functionality appears to be a digital form within your system used to capture information about potential loan customers (prospects). The form is designed to be adaptable based on the type of loan or contract being considered.

There are Six(6) Contract types.
1. 1. SME Car - Add Penalty Method field(Old Formula or New Formula)
  2. SME Bike
  3. Car Leasing - Add Shop Name field
  4. Bike Leasing - Add Shop Name field
  5. Real Estate
  6. Trade Finance

The fields displayed on the form will change based on the selected contract type. This ensures that only relevant information is collected for each loan type.

Specific Field Requirements: Certain contract types have additional field requirements:
- SME Car: Includes a "Penalty Method" field with options for "Old Formula" or "New Formula".
- Car Leasing and Bike Leasing: Requires a "Shop Name" field.

The form is divided into eleven sections, likely covering details such as:
- - Case
  - Loan
  - Document
  - Collection Schedule
  - CIB
  - History
  - Loan Form
  - Location
  - Black List
  - Relationship History
  - Document List

Basic Customer Information - Common fields for all contract types (e.g., name, address, contact details, ID number)

Contract Type - Dropdown menu with the six contract types

Contract Specific Details - Fields displayed based on the selected contract type (e.g., car model, loan amount, shop name, property details)

1. Case Section

The Case Section appears to be a critical component of the "Add Prospect Form" where detailed information about the potential customer and their financial situation is collected. It also involves capturing information about the sales process and any guarantors involved.

Sales and Customer Information

Sales Team: Fields to capture details about the sales personnel involved (Contract Salesperson, Sales Assistant, Call Center Salesperson, Double Count Person, Customer Introduction).

Call Approach: Depending on whether the customer was approached through a call or a broker, specific fields are displayed.
- Call Approach: If selected, an "Approach List" field is added for detailing the approach method.
- Broker Approach: If selected, "From which Broker" and "Approach List" fields are added.

Financial Assessment: Fields to capture customer's monthly income, expenditure, and automatically calculate the monthly profit.

Guarantor Information

Flexibility: Allows for adding multiple guarantors.

Two Methods: Offers two ways to add guarantor information:
- Add New Guarantor: Manually input guarantor details, starting with the phone number.
- Add Existing Guarantor: Select a guarantor from an existing list based on their phone number.

Asset Valuation

Shows the latest asset valuation record for the current month.

Allows for selecting one or more valuation records for the prospect process.

2. Loan Details Section

The Loan Details section appears to be a crucial part of the prospect form, providing comprehensive information about the proposed loan. It includes details about the Loan Amount, fees, and other financial terms.

Payment Schedule Type: Defines the repayment structure (e.g., upfront, installment).

Initial Date: Automatically set as the prospect creation date.

Trading Currency: Allows selecting the loan currency (USD, THB, LAK).

First Payment Date: Typically set for the 5th of the month.

Number of Payments: Defines the total number of repayments.

Monthly Interest: Specifies the interest rate.

Last Payment Date: Calculated based on the First Payment Date and Number of Payments.

Loan Amount and Fees:

Loan Amount: The total amount to be borrowed.

Approval Fee Amount: A fixed or percentage-based fee for loan approval.

Approval Fee: Calculated based on Loan Amount and a predefined percentage.

Other Cost: Additional charges (e.g., processing fees).

Advance: Any advance payments made by the customer.

Net Amount Customer Receives: Calculated as Loan Amount minus Approval Fee Amount.

Early Repayment:
- Allows selecting whether early repayment is allowed.
- If selected, a "Min Repayment Period" field is displayed.

Broker Information:
- Details about the broker involved in the loan process.

3. Document Section

The Document Section appears to be a critical part of the loan application process, where required documentation is listed and likely tracked for completion.

Mandatory Documents:

Customer Family Book

Guarantor Family Book

Village Head File

Questionnaire Form

Real Estate Documents of Customer

Optional Documents:

Customer ID Card

Guarantor ID Card

Accounts Receivable Documents For Customer

Accounts Receivable Documents For Guarantor

Real Estate Documents Of Guarantor

Other (Picture of appearance of home or shop)

Other (Bank passbook copy etc.)

CIB Document

4. Collection Schedule Section

The Collection Schedule section appears to outline the calculation methodology for loan repayments, including principal, interest, and balance updates.

Payment Amount: The total amount to be paid on each installment, comprising both principal and interest.

First Interest: Calculates the interest accrued from the Initial Date (loan disbursement date) to the First Payment Date. It's based on a daily interest rate applied to the loan amount.
- - First Interest - ((Loan Amount * interest)/30) * (First Payment Date - Initial Date)

Other Interest: Calculates the interest for subsequent payments, typically based on the remaining principal balance multiplied by the monthly interest rate.
- - Other interest - Loan Amount * Interest

Ending Balance: The remaining principal amount after each payment, calculated by subtracting the principal portion of the payment from the beginning balance.
- - Ending Balance = Beginning Amount - principal Amount

The Collection Schedule provides a basic framework for calculating loan repayments. However, it could be enhanced with more complex interest calculations, detailed amortization schedules, and flexibility to handle various loan scenarios.

5. CIB Section

The CIB (Credit Information Bureau) section is designed to capture and record a customer's credit history information. It appears to be a crucial component in assessing the creditworthiness of a loan applicant.

Customer CIB Details: This section is dedicated to inputting specific details about the customer's credit history.

CIB of Customers: A dropdown field likely populated with existing customer CIB records.

CIB Result: A binary field indicating whether a CIB report exists for the customer.

Financial Institute: The name of the financial institution that provided the credit information.

Contract Date: The date of the credit contract.

Due Date: The original due date for the credit obligation.

Amount: The original loan amount or credit limit.

Currency: The currency of the loan or credit.

Remaining Amount: The outstanding balance on the credit account.

Delay Days: The number of days the customer is overdue on the payment.

Rank: A classification of the credit risk, possibly based on the delay days or other factors.

Collateral Type: The type of collateral associated with the credit, if any.

Note: Corporate & Investment Banking (CIB or BBVA CIB) includes the Group's wholesale businesses, i.e. investment banking, global markets, global loans and transactional services for international corporate customers and institutional investors across its global footprint.

6. History Section

The History section appears to tracking customer interactions, activities, and status changes over time. By capturing detailed information about each interaction, it provides valuable insights for decision-making and analysis.