Loan with term vary based on loan cycle

Owned by Sangamesh Nadagoudar
Last updated: Jun 27, 2019 by Massabe Lydiane
7 min read

Loan with term vary based on loan cycle enables defining loan cycle with respect to their terms, interest and principal. This is for those whose business practice is loan amount which is increased for the second loan cycle on completing the first loan cycle on time.  

This is defined in the loan product itself by enabling "Terms with vary based on loan cycle" in Term section.  

On this page:

Beginning at the main screen, select Admin, then Products from the drop-down menu. This will launch the Products menu.

Select Loan Products. 

Create Loan Product 

Details 

Note: All red coloured asterisk mark are mandatory fields. 

Please refer Details - Image, the mentioned Details below are updated with respect to the provided fields numbers.   
  • 1 - Provide Loan Product name (Mandatory). 
  • 2 - Provide Short name (Mandatory).
          3 - Provide description of this product. 
          4 - Select Fund source. Need to have defined required funds: Manage Funds. 
          5 - Provide Loan product Start date.
          6 - Provide Loan product Close date. Note - Loan product cannot be used after this date. 
          7 - On checking the check box, it captures number of loan taken by customer. 

Currency 


  • 9 - Provide Decimal places (Mandatory). 
  • 10 - Provide Currency in multiples of (Mandatory). This is to provide total amount rounding off. For example: 10, so Total amount gets rounded of to 10s. 
  • 11 - Provide Installment in multiples of (Mandatory). This is to provide installment rounding off. For example: 10, so Installment amount gets rounded of to 10s. 

Terms

Follow If your loan product is based on Loan cycle. 
19 - Check the check box to enable "Terms vary based on loan cycle". 
20 - Provide values in principal section. Click on Add button to define Principal by loan cycle.
In the image shown above: 
21 - Equals - Loan cycle as 1 with Principal Default amount of 10000. (If there was one more cycle, it could be defined as Equals - loan cycle as 2 with principal amount). 
22 - Greater than -  Loan cycle as 1 with Principal Default amount of 20000. Greater than should always be used for the last cycle. 
23 - Define Number of repayments by loan cycles in the same way. 
Then continue defining other steps from Section A - 14 to 18. 

Settings

  • 24 - Select Amortization: Depending upon the type of amortization you practice select one.  
                 Equal Installments - All repayment amounts will be equal but the principal and interest amounts will vary with each repayment.
            Or Equal Principal Payments - All principal amounts will be equal but the repayment and interest amounts will vary with each repayment.
  • 25 - Select Interest method: Depending upon the type of interest method you practice, select one.
                Flat, For formula reference - Flat interest calculation  
           Or Declining Balance, For formula reference - Declining Balance Interest Calculation
  • 26 - Select Repayment strategy: The repayment strategy determines the sequence in which each of the components is paid. For more information on Repayment strategies: Loan Product Fields - Repayment strategy. 
  • 27 - Select Interest calculation period: 
               Daily - Will Calculate the interest on DAILY basis. For example: Month of February has 28 days and it will calculate interest for 28 days,  
          Or SAME AS REPAYMENT PERIOD- it calculates for the month, that is, 30 days.
          28 - Provide Moratorium (Optional): 
  • If Principle Payment is '6' and the client's Repayment Frequency is every month, then for the first six months, the client has to pay Interest only and after six months the client starts paying principle amount too.
  • If Interest Payment is '6' and the client's Repayment Frequency is every month, then for the first six months, the client has to pay Principle only and after six months the client starts paying Interest amount too.
          29 - Provide Interest free period (Optional): If the Interest Free Period is '4' and the client's Repayment Frequency is every week, then for the first four weeks the client need not to pay interest, he has to pay principle due for that week only. 
          30 - Provide Arrears tolerance (Optional): With 'Arrears tolerance' you can specify a tolerance amount and if the loan is behind (in arrears), but within the tolerance, it won't be classified as 'in arrears' and part of the portfolio at risk.
  • 31 - Select Days in year: Depending upon your organizations financial days select respectively.
                  Actual - Will consider number of days with respect to actual calendar. Or 360 days Or 364 days Or 365 days.   
  • 32 - Select Days in Months: Depending upon your organizations financial practice select respectively. 
                  Actual - Will consider number of days with respect to actual calendar. Or 30 days. 
          33 - Provide "Allow fixing of installment amount" (Optional): On checking the check box it enables providing the installment amount manually at the loan account level.  
                 Example: If the repayment amount every installment is 107 and you want to give it has 105. On providing 105 amount manually, it automatically adjusts the schedule for all the repayments. 
          34 - Number of days a loan may be overdue before moving into arrears (Optional): Loan Product Fields
          35 - Maximum number of days a loan may be overdue before becoming a NPA - non performing asset (Optional): Loan Product Fields  
          36 - Account moves out of NPA only after all arrears have been cleared?: On checking the check box, Loans which are NPA will only move out of NPA after all arrears have been cleared. 
          37 - Principal Threshold (%) for Last Installment: 

Interest Recalculation (Optional) 

 

38 - On checking the check box for "Recalculate Interest" - It will enable Interest recalculation. For more information on Interest recalculation refer - Interest Amount Recalculation for Loan Accounts. 

Guarantee Requirements (Optional)


39 - Checking the check box will enable "Place Guarantee Funds On-Hold". 
40 - Mandatory Guarantee (%): This is to provide total % of loan amount as mandatory guarantee. 
Example: 20%. 
41 - Minimum Guarantee from Own Funds (%):  
Example: 10% of loan amount from Own funds. 
 42 - Minimum Guarantee from Guarantor Funds (%): 
Example: 10% of loan amount from Guarantor Funds. 


Configurable terms & settings (Optional) 


46 - By default "Allow overriding select terms and settings in loan accounts" is checked (Enabled). 
If you don't want to allow over ridding for the mentioned categories, then you could uncheck the box. 

Charges


In order to use Add charge, you should have already defined it in charges. For more information on charges refer here: Charges

Overdue Charges


In order to use Add overdue charge, you should have already defined it in charges. For more information on charges refer here: Charges

Accounting 

 

By default Accounting will be disabled - None:- Meaning If you are using this product for various transactions like disbursement, repayment, etc. These transactions are not passed in journal entry.  

Enabling accounting for the loan product:-
>> You should have created chart of accounts, for info refer: https://mifosforge.jira.com/wiki/display/docs/Chart+of+Accounts+and+General+Ledger+Setup.
>> To enable Accounting, you need to select either one of the account type below depending upon your organization accounting practice.  
  • Cash 
  • Accrual (periodic) 
  • Accrual (upfront) 

>> Map accounts with respect to the loan product accounts. For information on these accounts refer: A Possible accounting Spec - Accounting rules for loans. 


Advanced Accounting Rule 

Clicking on the show button enables Advanced accounting rule. 


If you click on Add button, it will expand and show up selection drop-downs. 

  • Configure Fund sources for Payment Channels. 
    Example: In the shown image above, Payment type - Cheque is mapped to Fund source - Bank. So whenever payment type is used for transaction, journal entry for Account - Bank will be passed. 
  • Map Fees to Income Accounts. 
  • Map Penalties to Specific Income Accounts.

Click on Submit button to Save/Create loan product.


View Loan Product 

 Go to Admin>>Product>>Loan Products 

The image above shows Loan products list. 

Edit Loan Product

Go to Admin>>Product>>Loan Products>>Select loan product (Example: Agriculture loan) >> then click on Edit button. 


In the image shown above, View - Loan products details as well as you can Edit Loan product.  



Related articles