Revised Loan Repayment Calculator for PLI

Loan Repayment calculator using Excel

Note:

1. After migration to McCamish, old NIC software is disabled and it is not possible to calculate the pending loan and interest amount.  Further loan payments cannot be updated in McCamish through CSV uploading.  To calculate the pending loan principle and interest, this tool will be useful.  After getting the entire pending loan amount with interest credited in Point Of Sale, loan data in McCamish is to be updated by issue of Push back Sanction.

If the downloaded excel document is not working, reason is that macros are disabled.  Follow the given procedure to enable macros:

Open the excel file

Click the office button

Click the "Excel Options"

Click "Trust Center"

Click "Trust Center Settings"

Click "Macro Settings"

Click "Enable all macros"

Click "OK"

1. Download Excel Sheet from PoTools.
2. Enable Macro for Calculate loan repayment amount in PLI/RPLI

Download Excel Calculator