Court trial assistant’s principal and interest calculator

Features of the Court Trial Assistant’s Principal Interest Calculator Software

1. Rich and convenient auxiliary tools

The calculation area integrates LPR data reading, interest rate type conversion, target date calculation and other fast auxiliary tools. Without leaving the calculation area, you can obtain the relevant data required for calculation through a simple click or input, improving the user experience; the software also It provides separate functional modules such as calculation cycle, interest rate conversion, litigation costs, rule detection, and compound interest calculation.

2. Allow custom interest calculation rules

Interest should be calculated using the interest calculation formula of principal × interest rate × interest calculation period. However, there are no unified provisions on the determination of daily interest rates and interest calculation periods in laws, regulations or other normative documents, resulting in the calculation method of interest in judicial practice. There are also differences. As a calculation tool, this software provides the function of customizing interest calculation rules and provides detailed explanations of each calculation method to meet user needs as much as possible.

3. LPR data update prompts and automatic updates

After the implementation of the Civil Code and related norms, the interest rate standards are closely related to LPR data, and the software has also enhanced related functions. When the software LPR data is not updated in time, the main interface will prompt in red font, otherwise it will display the latest updated date and corresponding LPR data. In the Internet state, the software can be automatically updated at startup; for intranet users such as court systems, the software provides an LPR data release function (which can realize centralized release and automatic update of intranet LPR data), and allows users to add and edit by themselves. LPR data.

4. Batch real-time editing of calculation results

The results of each calculation will be added to the results list, and data such as principal, interest, litigation expenses, etc. will be automatically calculated. The software allows users to edit calculation results through the toolbar and right-click menu. After modifying a single or multiple payments, the software will automatically recalculate all data to achieve Excel-style batch and real-time editing.

5. Diversified data input and output functions

The software supports three data input methods, direct data entry, loading and saving data, and intelligent text recognition of external data: copying irregular text content such as principal, interest rate, interest accrual date, etc. from other office software such as Word, Excel, or WPS. Or tabular data content, paste it into the "Data Import" form, and the software will automatically identify the data and import it. In terms of data output, the software can export calculation data to Excel files for further editing, or it can be printed directly. Users can also export calculation data to bxs files (custom file format) and share them with other users. Other users can double-click the file. Receive and use it to achieve team collaboration.

6. Proactive reminder and correction of over-limit interest rates

Around August 20, 2020, the upper limit of judicial protection for private lending interest rates has changed. The software will automatically detect whether the interest rate used exceeds the upper limit of judicial protection during the interest calculation period and give corresponding suggestions. After adopting the suggestions, it will automatically correct and calculate interest in stages. , so that the interest rate standards before and after August 20, 2020 are calculated within the scope of interest protection. When the benchmark interest rate for similar loans is calculated in stages during the same period, users can choose based on the automatic prompt whether the interest after August 20, 2019 should be based on the fixed interest rate corresponding to the last period (October 24, 2015) of the RMB loan benchmark interest rate, or the Calculate the float in segments based on LPR data.

Remarks: The software requires the .net4.0 framework and office data access components to run. If the installation fails or an error occurs after installation, please manually install the other two files in the compressed package.

Court Trial Assistant’s Principal and Interest Calculator Update Log

Updated date: May 2, 2022

​ ​ 1. If an error message appears after starting, please try right-clicking and selecting to start as administrator, or install the program on a non-system disk (generally the system disk is C drive);

​ ​ 2. This software is free software. If you need a registration code, you can obtain it from the author for free (no additional conditions);

3. This version mainly adds the repayment offset function. After inputting the loan and repayment data, the results can be obtained automatically (the interest calculation rules, principal and interest priority, debt priority and other settings can be modified during the calculation process) to realize multiple borrowing and repayment. The payment is recorded first with interest then principal or first with principal then interest, etc.;

​ 4. Fixed some BUGs in the previous version;

5. Optimized the program interface.

​ ​ Updated date: June 8, 2021

​ ​ 1. Please pay attention to the following during installation:

​ ​ 1. If you have installed an old version of the principal and interest calculator before, please uninstall it from the control panel first. Before uninstalling, you can copy BXData.mdb and LPR.mdb in the program installation directory to other folders, and then copy them back to the updated program installation directory after reinstalling.

​ ​ 2. During the installation process of this version, you need to install the Microsoft data access component first, and then proceed to the installation of this software. Please note that after installing the data access component, operate in the principal and interest calculator installation interface that automatically pops up;

​ 3. If you have installed the data access component before, please select Repair "Reinstall or repair Microsoft Access database engine2010(Chinese (simplified)), leave it in its original state" and select "Detect and repair my Microsoft Access database engine2010(Chinese (simplified)) error during installation" until the installation is complete.

​ ​ 2. This update of 5.0.1:

​ ​ 1. Fix the bug of reading the LPR interest rate in the first line when using "Same Period Base Rate LPR Segmented Interest Calculation"

​ ​ 2. Fix the bug that causes an error if the starting date and the repayment date are the same day when using the "same period base rate LPR segmented interest calculation"

3. Fix the bug that double-clicking the "Interest Rate" column in the calculation result cannot modify the interest rate in real time

​​ 4.Fix the bug where the system date format contains an incorrect display when the day of the week is included

​​ 5. The "deadline" in the calculation interface is changed to "repayment date". Note: The software uses "counting the beginning but not the end". The deadline indicates that interest still needs to be calculated, but no interest will be calculated on the repayment date.