🏠 Home

CRCO Loan Terms Analysis Tool

Instructions:

This tool is created by Partners and Article Assistants of XYZ and it processes loan data and calculates additional metrics based on the loan terms. Please follow these steps:

This tool is being shared on the request received from participants of the webinar and is for demonstration purposes only and is tested on particular format of data provided by the bank. This tool is neither endorsed by ICAI nor the creators of this demo tool. Not for commercial use, reproduction, or sale. No liability for functionality or misuse. No support provided. The name or the logo of the creators is displayed only to take the ownership of this tool as part of being a “responsible creator” and not for any purposes and can not be considered as a solicitation.

  1. Prepare an Excel file with the following columns: BRANCH_CODE, ACCOUNT, CUSTOMER_ID, FULL_NAME, Loan_Amount, DRAWING_POWER, INTEREST_RATE, NPA_DT, INST_PERIOD, Total_Instalments, EMI_Amount, SANC_DT, EMI_Start_Dt, OVERDUE_AMOUNT, GROSS_OS, NET_OS, Outstanding_Balance
  2. Set the audit date (default is March 31 of the current year)
  3. Click "Choose File" to upload your data file
  4. Click "Process Data" to generate the calculations
  5. Once processing is complete, click "Download Results" to get the processed data

Note: All calculations are performed in your browser. No data is sent to any server.

Audit Date:

Upload your file

No file selected

Processing data...

Processing: 0%

Data Preview