Calculation in detail
This chapter describes the process of calculation creation in detail, for general overview and short process please follow
How to create calculation in general
Calculation creation
To create new Loans you can use 3 possibilities :
Main Action menu - menu New - Create New Loan
Financing List - menu Process - Create New Loan
Customer menu - from Customes Card - menu Process - Create New Loan
Calculation creation wizard
The system opens wizard with 4 steps:
Step choose:
Legal Form - Defines customers legal form (entrepreneur, non-entrepreneur, legal entity)
Customer - Select from activated customers
Sales Person - Used for person created the Loan
Maximal Principal - Maximam pre-approved Loan Amount Click to the button Next
Step choose:
Financing Product Code - Loan type with predefined default Financing paramaters as Validation, Series No, Calculation parameters(Calendar Month, Calculation method, Financing period, Rates, Fees) or Invoicing (Posting Groups, Payment Terms). For more information please see How To Create Financing Product.
Payment Due Date
Part Payment Period - Finnancing period - Month, Quarter, Half Year, Year
Principal Amount
Initial Fees - Fees for Issuying the Loan - separate invoice is automatically issued after the loan is approved
Service per Financing Period - Service amount is calculated in Payment Calendar
Insurance per Financing Period - Insurance amount is calculated in Payment Calendar
Step:
Verify or adjust Financing Rates and continue to the button Next for the next step.
Step:
The system sumarize the rates and anuits. Continue to the button Finish to complete the wizard.
Calculation parameteres
After the completing wizard system will create Financing Card with status Calculation.
Section General
Check the Financing product and Dates - Offer Creation Date, Offer Validity Date, Calculation Starting Date, Expected Termination Date.
The Financing Product has impact to the calculation method:
Interest- Customer reguraly repays interest and the principal amount in the last installment
Annuit- Customer reguraly repays interest and the principal amount in all installments
Section Calculation
Calendar Month - Possibility of Aliquot payment - if the Calculation Starting Date is not in the beggining of the month, the system splits the first payment for two payments - First payment from the Calculation Starting day to the end of the month and the last payment from the beggining of last month to the Expected Termination Date. It means the regular payments respect calendar month in Payment Calendar.
Daily Interest - It is possible to turn on only with calculation model INTEREST. If turned on, the system calculates interest exactly according to the number of days in a payment period under the same conditions (principal, interest rate) Formula: "Principal balance" * Rate / 365 (366) / 100 * Days.
Financing Periods (in Months) - although the repayment period is different from the Month always input in months
Principal Amount, Maximal Principal Amount, Interest Rates (Cost, Margin, Total) Fees nad Insurance.
Section Invoicing
Gen. Bus. Posting Group and Gen. Prod. Posting Group - the system post regular invoices according to these selected posting groups.
After changes, click in menu Home for Complete Calculation to display the changes.
Complete Calculation button
Complete Calculation button saves changes which were done within Financing Card, recalculates the Calculator, brings changes to the Payment Calendar and recalculates the Payment Calendar.
The Complete Calculation button is available on the Financing List and Financing Card. After pressing Complete Calculation, system perform a control whether there exist updated Abs/Rel values on the contract (in Calculator Lines).
If there exist explicitly added value of rel and abs values, the message is displayed:
“The Calculation function cannot be used because there are absolute or relative parts in the calculation lines. Recalculate the Contract via Calculation Lines.” This prevents absolute and relative values from being resete to default and keeps setup of Abs and Rel values.
If the Abs and Rel values in the calculator lines have not been changed in the contract, system continues to check the status of the contract:
If contract status >= Active, the message is displayed: "The detailed status of contract ... is ... Calculation update cannot be carried out." If Status < Active, the contract is recalculated. If user wants to recalculate active contract, it is possible through Calculator Lines > Finish.
Changes in Calculator Lines
You can modify calculated payment amounts manually via calculation lines (click in menu Home for Calculation Lines ). Please note that after the changes there, you need to click on Update to recalculate the lines so you can see the effect of your changes. This button only display changes in calculation lines so you can use it as a playground and simulation.
If you want to display changes performed in Calculation Lines to the Payment Calendar, click on Finish.
Follow up:
How to create calculation in general
How to create financing product
How to work with approval process