PLI/RPLI loan repayment calculator

Click Here to download the PLI/RPLI loan repayment calculator.

 

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 Pushback 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"