APR Calculation
- Lango: Language and translation manager
Codeunit 7026398, funkce Calculation APR
The APR is always calculated independently of the type of financing, the person of the contract or other parameters if the Calculate APR = Yes flag is filled in on the contract header.
The principle of the calculation is an iterative calculation of finding the interest rate in %, where the discounted amount of cash flow from the temp table matches the input price according to the formula:
Input Price = SUM(Amount Amount / (1+ (Iterated Interest % / 100))Number of Days/365.25
Where:
Number of Days is (Payment Due Date - Object Handover Date)
Input Price = for Loan Sum(Financed Amount) ( from CI for To Acquisition = Yes, To Calculation = Yes)
For other types of financing, sum(Base amount from CI for To Acquisition = Yes, To Calculation = Yes)
The following are included in the cash flow (note: Leasing with delivery of goods is not applied in OneCore):
Cash Flow Amount | Decisive date | Note |
Line.Amount - Liability Insurance Amount - Crash Insurance Amount - Other Insurance Amount - Amount VAT Insurance | Line.Due Date |
|
Insurance Client Cal.Amount + VAT Amount for policies where InsProduct." Included in APR"=Yes and Include In Payments = Yes and Status <=Active | Line.Due Date
| For Leasing with delivery of goods, the VAT Amount is not added
|
Initial Fee (The initial fee from the ContractHeader." Initial Fee") | Handover Date | VAT is added to the fee (depending on the |
Closing Fee (Fee at the end - from Gen. Terms and Conditions. Contract Finish Cost Amount | ContractHeader." Expected Termination Date" | VAT is added to the fee (depending on the setting)
|
The calculation model is shown here:
