Deprecated: The each() function is deprecated. This message will be suppressed on further calls in /home/zhenxiangba/zhenxiangba.com/public_html/phproxy-improved-master/index.php on line 456
JP6943588B2 - Loan management equipment, loan management methods, and loan management programs - Google Patents
[go: Go Back, main page]

JP6943588B2 - Loan management equipment, loan management methods, and loan management programs - Google Patents

Loan management equipment, loan management methods, and loan management programs Download PDF

Info

Publication number
JP6943588B2
JP6943588B2 JP2017061405A JP2017061405A JP6943588B2 JP 6943588 B2 JP6943588 B2 JP 6943588B2 JP 2017061405 A JP2017061405 A JP 2017061405A JP 2017061405 A JP2017061405 A JP 2017061405A JP 6943588 B2 JP6943588 B2 JP 6943588B2
Authority
JP
Japan
Prior art keywords
interest rate
product
balance
days
loan
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
JP2017061405A
Other languages
Japanese (ja)
Other versions
JP2018163584A (en
Inventor
義敦 峯
義敦 峯
邦明 芹澤
邦明 芹澤
Original Assignee
株式会社オービック
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 株式会社オービック filed Critical 株式会社オービック
Priority to JP2017061405A priority Critical patent/JP6943588B2/en
Publication of JP2018163584A publication Critical patent/JP2018163584A/en
Application granted granted Critical
Publication of JP6943588B2 publication Critical patent/JP6943588B2/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Landscapes

  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)

Description

本発明は、融資管理装置、融資管理方法、及び融資管理プログラムに関する。 The present invention relates to a loan management device, a loan management method, and a loan management program.

従来、例えば、繰上弁済(返済)を実行する場合のローン計算を行う装置として特許文献1がある。かかる特許文献1の装置は、ローングラフを表示する表示手段と、ローングラフを表示手段に描画させる描画手段と、繰上弁済を実行する時期を指定する時期指定手段と、繰上金額を入力するための入力手段と、時期指定手段により指定された時期および入力手段により入力された繰上金額に基づく繰上弁済実行後における、所定の返済形式でのローングラフを表示手段に再描画させる再描画手段と、を備えている。 Conventionally, for example, Patent Document 1 is a device that performs loan calculation when executing prepayment (repayment). The device of Patent Document 1 is for inputting a display means for displaying a loan graph, a drawing means for causing the display means to draw a loan graph, a time designation means for designating a time to execute advance payment, and an advance amount. An input means and a redrawing means for causing the display means to redraw the loan graph in a predetermined repayment format after the prepayment is executed based on the time specified by the time designation means and the prepayment amount input by the input means. I have.

特開2003−288486号公報Japanese Unexamined Patent Publication No. 2003-288486

しかしながら、上記特許文献1では、繰上弁済時の更新手数料に関しては特に考慮していない。 However, in Patent Document 1, the renewal fee at the time of prepayment is not particularly considered.

本発明は、上記に鑑みてなされたものであって、融資の契約変更の際の手数料を、上限金利を超えない範囲で高く設定することが可能な融資管理装置、融資管理方法、及び融資管理プログラムを提供することを目的とする。 The present invention has been made in view of the above, and is a loan management device, a loan management method, and a loan management capable of setting a high fee for changing a loan contract within a range not exceeding the maximum interest rate. The purpose is to provide a program.

上述した課題を解決し、目的を達成するために、制御部を備えた融資管理装置であって、前記制御部は、融資の際又は当該融資の契約変更の際に、実質金利を算出する実質金利算出手段と、前記実質金利が上限金利を超えないように、前記融資の契約変更の際の手数料の上限を上限手数料として算出し、算出した上限手数料を表示手段の画面に表示する上限手数料算出手段と、を備えたことを特徴とする。 A loan management device provided with a control unit in order to solve the above-mentioned problems and achieve the purpose, and the control unit calculates the real interest rate at the time of financing or when the contract of the loan is changed. Calculate the upper limit of the interest rate calculation means and the upper limit of the fee when changing the loan contract as the upper limit fee so that the real interest rate does not exceed the upper limit fee, and display the calculated upper limit fee on the screen of the display means. It is characterized by having means and.

また、本発明の好ましい態様によれば、債権番号に関連づけて、返済回毎に、閏年をまたぐ場合に返済回数を2回に分割するための返済回数枝番、積数始期、積数終期、積数日数、一年間日数、残高、残高積数(但し、残高積数=残高×積数日数÷一年間日数)、及びみなし利息を格納する実質金利算出用マスタを備え、前記実質金利算出手段は、対象の債権番号について、返済回毎に、前記返済回数枝番、前記積数始期、前記積数終期、前記積数日数、前記一年間日数、前記残高、前記残高積数、及び前記みなし利息のデータを算出して前記実質金利算出用マスタに登録し、また、前記実質金利を、実質金利=みなし利息の累計÷残高積数の累計で算出し、前記上限定数料算出手段は、前記上限手数料を、上限手数料=上限金利(%)×残高積数の累計−みなし利息の累計で算出することが望ましい。 Further, according to a preferred embodiment of the present invention, the number of repayments branch number, the beginning of the product number, the end of the product number, for dividing the number of repayments into two in the case of crossing the off-year, for each repayment number in relation to the claim number. The real interest rate calculation means is provided with a master for calculating the real interest rate, which stores the number of days of product, the number of days in one year, the balance, the number of balance products (however, the number of balance products = balance x the number of days of products ÷ the number of days in one year), and the deemed interest. For each repayment number, the number of repayments branch number, the beginning of the product number, the end of the product number, the number of days of the product, the number of days in one year, the balance, the balance product number, and the deemed product number. The interest data is calculated and registered in the real interest rate calculation master, and the real interest rate is calculated by multiplying the real interest rate by the cumulative total of deemed interests divided by the cumulative number of balances. It is desirable to calculate the maximum fee by multiplying the maximum fee = maximum interest rate (%) x cumulative number of balance products-cumulative deemed interest.

また、本発明の好ましい態様によれば、前記実質金利算出手段は、算出した実質金利が上限金利を超える場合は、前記実質金利算出用マスタへの算出したデータの登録を禁止することが望ましい。 Further, according to a preferred embodiment of the present invention, it is desirable that the real interest rate calculation means prohibits registration of the calculated data in the real interest rate calculation master when the calculated real interest rate exceeds the upper limit interest rate.

また、本発明の好ましい態様によれば、前記融資の契約の変更は、早期完済であることが望ましい。 Further, according to a preferred embodiment of the present invention, it is desirable that the change in the loan contract be paid off early.

また、上述した課題を解決し、目的を達成するために、本発明は、制御部を備えた情報処理装置で実行される融資管理方法であって、前記制御部で実行される、融資の際又は当該融資の契約変更の際に、実質金利を算出する実質金利算出ステップと、前記実質金利が上限金利を超えないように、前記融資の契約変更の際の手数料の上限を上限手数料として算出し、算出した上限手数料を表示手段の画面に表示する上限手数料算出ステップと、を含むことを特徴とする。 Further, in order to solve the above-mentioned problems and achieve the object, the present invention is a loan management method executed by an information processing apparatus provided with a control unit, and is executed by the control unit at the time of financing. Alternatively, the real interest rate calculation step for calculating the real interest rate when changing the loan contract and the upper limit of the fee for changing the loan contract are calculated as the upper limit fee so that the real interest rate does not exceed the upper limit interest rate. , The upper limit fee calculation step of displaying the calculated upper limit fee on the screen of the display means, and the like.

また、上述した課題を解決し、目的を達成するために、本発明は、制御部を備えた情報処理装置に実行させるための融資管理プログラムであって、前記制御部で実行させるための、融資の際又は当該融資の契約変更の際に、実質金利を算出する実質金利算出ステップと、前記実質金利が上限金利を超えないように、前記融資の契約変更の際の手数料の上限を上限手数料として算出し、算出した上限手数料を表示手段の画面に表示する上限手数料算出ステップと、をコンピュータに実行させることを特徴とする。 Further, in order to solve the above-mentioned problems and achieve the object, the present invention is a loan management program for causing an information processing apparatus provided with a control unit to execute a loan, which is executed by the control unit. At the time of, or when the loan contract is changed, the real interest rate calculation step to calculate the real interest rate and the upper limit of the fee when changing the loan contract are set as the upper limit fee so that the real interest rate does not exceed the upper limit interest rate. It is characterized by having a computer execute a step of calculating a maximum fee and displaying the calculated maximum fee on a screen of a display means.

本発明によれば、融資の契約変更の際の手数料を、上限金利を超えない範囲で高く設定することが可能となるという効果を奏する。 According to the present invention, it is possible to set a high fee for changing a loan contract within a range not exceeding the maximum interest rate.

図1は、実質金利を算出する場合に使用する従来のマスタのデータ構成例を示す図である。FIG. 1 is a diagram showing an example of data configuration of a conventional master used when calculating the real interest rate. 図2は、従来の融資時の実質金利の計算方法を説明するための図である。FIG. 2 is a diagram for explaining a conventional method of calculating the real interest rate at the time of financing. 図3は、従来の契約変更時(早期完済時)の実質金利の計算方法を説明するための図である。FIG. 3 is a diagram for explaining a conventional method of calculating the real interest rate at the time of contract change (at the time of early repayment). 図4は、本実施の形態に係る融資管理装置の構成の一例を示すブロック図である。FIG. 4 is a block diagram showing an example of the configuration of the loan management device according to the present embodiment. 図5は、返済予定マスタ及び実質金利算出用マスタのデータ構成例を示す図である。FIG. 5 is a diagram showing a data configuration example of the repayment schedule master and the real interest rate calculation master. 図6は、融資時(融資申し込み時)の実質金利を算出する場合の表示例を説明するための図である。FIG. 6 is a diagram for explaining a display example when calculating the real interest rate at the time of loan (at the time of loan application). 図7は、本実施の形態の融資時の実質金利算出方法を説明するための図である。FIG. 7 is a diagram for explaining a method of calculating the real interest rate at the time of financing according to the present embodiment. 図8は、早期完済時の実質金利を算出する場合の表示例を説明するための図である。FIG. 8 is a diagram for explaining a display example when calculating the real interest rate at the time of early repayment. 図9は、早期完済時の実質金利を算出する場合の実質金利算出方法を説明するための図である。FIG. 9 is a diagram for explaining a method for calculating the real interest rate when calculating the real interest rate at the time of early repayment. 図10は、早期完済時の変形例を説明するための図である。FIG. 10 is a diagram for explaining a modified example at the time of early payment.

以下に、本発明に係る融資管理装置、融資管理方法、及び融資管理プログラムの実施の形態を、図面に基づいて詳細に説明する。なお、本実施の形態によりこの発明が限定されるものではない。 Hereinafter, the loan management device, the loan management method, and the embodiment of the loan management program according to the present invention will be described in detail with reference to the drawings. The present invention is not limited to the present embodiment.

[1.概要]
個人(事業主を含む)に融資する場合、融資業者は、利息制限法・貸金業法に定められている上限金利を超えないように手数料を設定しなければならない。融資時や契約更新(繰上弁済や早期完済)の事務手数料なども利息とみなされることがあるため、融資業者は、契約利率とは別に実質金利も算出してチェックしている。
[1. Overview]
When lending to individuals (including business owners), the lender must set a fee so as not to exceed the maximum interest rate stipulated in the Interest Rate Restriction Act and Money Lending Business Act. Since the administrative fees for loan and contract renewal (advance payment and early payment) may also be regarded as interest, the lender also calculates and checks the real interest rate in addition to the contract interest rate.

融資業者によっては、通常の返済の利息計算方法と実質金利の計算方法が違う場合ある(閏年を考慮するか、前利方式か後利方式か、月割か日割か等々)。従来の融資管理システムでは、融資時には正確な実質金利を算出していたが、契約更新(繰上弁済や早期完済)時には、最新の返済予定のデータより概算で実質金利を算出していた。このため、繰上弁済などを何度か繰り返した場合には、実質金利の誤差が大きくなっていく。そのため、契約更新時の手数料を低めに設定するしかなかった。そこで、本実施の形態では、上限金利に極めて近い手数料を設定することができるようにした。 Depending on the lender, the interest calculation method for repayment may differ from the real interest rate calculation method (leap year, pre-interest or post-interest method, monthly or daily rate, etc.). In the conventional loan management system, the real interest rate was calculated accurately at the time of loan, but at the time of contract renewal (advance repayment or early repayment), the real interest rate was roughly calculated from the latest repayment schedule data. For this reason, when the prepayment is repeated several times, the error in the real interest rate becomes large. Therefore, there was no choice but to set a low fee when renewing the contract. Therefore, in the present embodiment, it is possible to set a fee that is extremely close to the maximum interest rate.

従来の実質金利の算出方法について説明する。図1は、融資の返済予定の作成に使用する返済予定マスタのデータ構成例を示す図である。図1に示すように、返済予定マスタ106aは、債権No、返済回数、返済日、利息計算起算日、利息計算終了日、利息計算日数、契約利率、返済前元本残高、元本返済額、利息返済額、手数料返済額、及び返済後元本残高等のデータを含むテーブル等である。 The conventional method of calculating the real interest rate will be described. FIG. 1 is a diagram showing an example of data configuration of a repayment schedule master used for creating a loan repayment schedule. As shown in FIG. 1, the repayment schedule master 106a includes the loan number, the number of repayments, the repayment date, the interest calculation start date, the interest calculation end date, the interest calculation days, the contract interest rate, the principal balance before repayment, and the principal repayment amount. A table containing data such as interest repayment amount, fee repayment amount, and principal balance after repayment.

図2は、従来の融資時の実質金利の計算方法を説明するための図である。図3は、従来の契約変更時(早期完済時)の実質金利の計算方法を説明するための図である。従来は、融資時と早期完済時で同じ返済予定マスタ106aを使用して実質金利を計算していた。 FIG. 2 is a diagram for explaining a conventional method of calculating the real interest rate at the time of financing. FIG. 3 is a diagram for explaining a conventional method of calculating the real interest rate at the time of contract change (at the time of early repayment). In the past, the real interest rate was calculated using the same repayment schedule master 106a at the time of loan and at the time of early repayment.

図2は、債権No「1001−1」、融資日「2012/11/1」、融資金額「1,000,000円」、融資利率「12.000000%」、返済回数「20」、返済期間「2012/11/25〜2014/6/25」、事務手数料「10,000円」とした場合の返済予定を示している。システムは、対象の債権NOについて、各返済回の返済日、利息計算起算日、利息計算終了日、利息計算日数、契約利率、返済前元本残高、元本返済額、利息返済額、手数料返済額、及び返済後元本残高のデータを算出して、返済予定マスタ400に登録する。ここで、利息返済額は、利息返済額=返済前元本残高×契約利率×利息計算日数÷365(閏年をまたがる場合は366)で算出する。また、残高積数を返済回毎に毎回算出する。残高積数は、残高積数=返済前元本残高×利息計算日数で算出する。 Figure 2 shows the loan No. “1001-1”, the loan date “2012/11/1”, the loan amount “1,000,000 yen”, the loan interest rate “12,000,000%”, the number of repayments “20”, and the repayment period. It shows the repayment schedule when "2012/11/25 to 2014/6/25" and the administrative fee "10,000 yen". For the target loan NO, the repayment date of each repayment, the interest calculation start date, the interest calculation end date, the interest calculation days, the contract interest rate, the principal balance before repayment, the principal repayment amount, the interest repayment amount, and the fee repayment The amount and the data of the principal balance after repayment are calculated and registered in the repayment schedule master 400. Here, the interest repayment amount is calculated as interest repayment amount = principal balance before repayment x contract interest rate x interest calculation days ÷ 365 (366 in the case of a leap year). In addition, the balance product number is calculated for each repayment. The balance product number is calculated by the balance product number = principal balance before repayment x interest calculation days.

さらに、みなし利息、残高積数合計、実質金利を算出する。みなし利息は、みなし利息=利息返済額の合計+手数料返済額の合計で算出する。残高積数累計は、残高積数累計=残高積数の合計で算出する。一年間日数は、返済期間に閏年が含まれる場合は、366日、そうでない場合は365日とする。実質金利は、実質金利=みなし利息×一年間日数÷残高積数累計で算出する。図2に示す例では、実質金利は13,1941044%となっている。 In addition, the deemed interest rate, total balance product, and real interest rate are calculated. Deemed interest is calculated as deemed interest = total interest repayment amount + total fee repayment amount. The cumulative balance product is calculated by the total balance product = total balance product. The number of days per year shall be 366 days if the repayment period includes a leap year, and 365 days otherwise. The real interest rate is calculated as real interest rate = deemed interest rate x number of days per year / cumulative balance product. In the example shown in FIG. 2, the real interest rate is 13,1941044%.

図3は、図2の返済予定を、早期完済日「2013/4/25」、繰上手数料「10.000円」とした場合の実質金利の計算を説明するための図である。この場合も融資時と同じ返済予定マスタ106aを使用する。この場合は、実質金利は、16,79%となり、上限金利(15%)を越えてしまうため、手数料を減額して調整することになる。従来は、上限金利(15%)を越えないように、概算で手数料を算出していたため、手数料を実質金利の上限まで設定することができなった。本実施の形態では、上限金利に極めて近くなるような上限手数料を算出してユーザに提示することで、ユーザは、融資の契約変更の際の手数料を、上限金利を超えない範囲で高く設定できるようにしている。
以下、具体的な構成および動作について説明する。
FIG. 3 is a diagram for explaining the calculation of the real interest rate when the repayment schedule of FIG. 2 is set to the early repayment date “2013/4/25” and the advance fee “10.000 yen”. In this case as well, the same repayment schedule master 106a as at the time of financing is used. In this case, the real interest rate will be 16,79%, which will exceed the maximum interest rate (15%), so the commission will be reduced and adjusted. In the past, the fee was calculated roughly so as not to exceed the maximum interest rate (15%), so it was not possible to set the fee up to the upper limit of the real interest rate. In the present embodiment, by calculating and presenting the maximum fee that is extremely close to the maximum interest rate to the user, the user can set a high fee for changing the loan contract within a range that does not exceed the maximum interest rate. I am trying to do it.
Hereinafter, a specific configuration and operation will be described.

[2.構成]
本実施形態に係る融資管理装置100の構成について、図4を参照して説明する。図4は、融資管理装置100の構成の一例を示すブロック図である。
[2. composition]
The configuration of the loan management device 100 according to the present embodiment will be described with reference to FIG. FIG. 4 is a block diagram showing an example of the configuration of the loan management device 100.

融資管理装置100は、市販のデスクトップ型パーソナルコンピュータである。なお、融資管理装置100は、デスクトップ型パーソナルコンピュータのような据置型情報処理装置に限らず、市販されているノート型パーソナルコンピュータ、PDA(Personal Digital Assistants)、スマートフォン、タブレット型パーソナルコンピュータなどの携帯型情報処理装置であってもよい。 The loan management device 100 is a commercially available desktop personal computer. The loan management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but is a portable type such as a commercially available notebook personal computer, a PDA (Personal Digital Assistants), a smartphone, or a tablet personal computer. It may be an information processing device.

融資管理装置100は、図2に示すように、制御部102と通信インターフェース部104と記憶部106と入出力インターフェース部108と、を備えている。融資管理装置100が備えている各部は、任意の通信路を介して通信可能に接続されている。 As shown in FIG. 2, the loan management device 100 includes a control unit 102, a communication interface unit 104, a storage unit 106, and an input / output interface unit 108. Each part of the loan management device 100 is communicably connected via an arbitrary communication path.

通信インターフェース部104は、ルータ等の通信装置および専用線等の有線又は無線の通信回線を介して、融資管理装置100をネットワーク300に通信可能に接続する。通信インターフェース部104は、他の装置と通信回線を介してデータを通信する機能を有する。ここで、ネットワーク300は、融資管理装置100とサーバ200とを相互に通信可能に接続する機能を有し、例えばインターネットやLAN(Local Area Network)等である。なお、後述する記憶部106に格納されるデータは、サーバ200に格納されてもよい。 The communication interface unit 104 connects the loan management device 100 to the network 300 so as to be communicable via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with another device via a communication line. Here, the network 300 has a function of connecting the loan management device 100 and the server 200 so as to be able to communicate with each other, and is, for example, the Internet or a LAN (Local Area Network). The data stored in the storage unit 106, which will be described later, may be stored in the server 200.

入出力インターフェース部108には、入力装置112および出力装置114が接続されている。出力装置114には、モニタ(家庭用テレビを含む)の他、スピーカやプリンタを用いることができる。入力装置112には、キーボード、マウス、およびマイクの他、マウスと協働してポインティングデバイス機能を実現するモニタを用いることができる。なお、以下では、出力装置114をモニタ114とし、入力装置112をキーボード112又はマウス112として記載する場合がある。また、ユーザがモニタ114に表示して、入力装置112で操作等をすることを、「UIを介したユーザ操作」と記載する場合がある。 An input device 112 and an output device 114 are connected to the input / output interface unit 108. As the output device 114, a speaker or a printer can be used in addition to a monitor (including a home television). As the input device 112, in addition to a keyboard, a mouse, and a microphone, a monitor that cooperates with the mouse to realize a pointing device function can be used. In the following, the output device 114 may be referred to as a monitor 114, and the input device 112 may be referred to as a keyboard 112 or a mouse 112. Further, displaying on the monitor 114 and performing an operation on the input device 112 may be described as "user operation via UI".

記憶部106には、各種のデータベース、テーブル、およびファイルなどが格納される。記憶部106には、OS(Operating System)と協働してCPU(Central Processing Unit)に命令を与えて各種処理を行うためのコンピュータプログラムが記録される。記憶部106として、例えば、RAM(Random Access Memory)・ROM(Read Only Memory)等のメモリ装置、ハードディスクのような固定ディスク装置、フレキシブルディスク、および光ディスク等を用いることができる。 Various databases, tables, files, and the like are stored in the storage unit 106. In the storage unit 106, a computer program for giving an instruction to a CPU (Central Processing Unit) in cooperation with an OS (Operating System) to perform various processes is recorded. As the storage unit 106, for example, a memory device such as a RAM (Random Access Memory) or a ROM (Read Only Memory), a fixed disk device such as a hard disk, a flexible disk, an optical disk, or the like can be used.

記憶部106は、返済予定マスタ106aと、実質金利算出用マスタ106bと格納する。図5は、返済予定マスタ106a及び実質金利算出用マスタ106bのデータ構成例を示す図である。 The storage unit 106 stores the repayment schedule master 106a and the real interest rate calculation master 106b. FIG. 5 is a diagram showing a data configuration example of the repayment schedule master 106a and the real interest rate calculation master 106b.

返済予定マスタ106aは、返済予定算出部102aが融資の返済予定を算出する場合に使用するマスタである。返済予定マスタ106aは、図5に示すように、債権No、返済回数、返済日、利息計算起算日、利息計算終了日、利息計算日数、契約利率、返済前元本残高、元本返済額、利息返済額、手数料返済額、及び返済後元本残高等のデータを含むテーブル等である。返済予定マスタ106aは、上記図1に示した返済予定マスタ106aと同様な構成である。 The repayment schedule master 106a is a master used when the repayment schedule calculation unit 102a calculates the repayment schedule of the loan. As shown in FIG. 5, the repayment schedule master 106a includes the loan number, the number of repayments, the repayment date, the interest calculation start date, the interest calculation end date, the interest calculation days, the contract interest rate, the principal balance before repayment, and the principal repayment amount. A table containing data such as interest repayment amount, fee repayment amount, and principal balance after repayment. The repayment schedule master 106a has the same configuration as the repayment schedule master 106a shown in FIG.

実質金利算出用マスタ106bは、実質金利算出部102bが、融資の際又は融資の契約変更の際に実質金利を算出する場合に使用するマスタである。実質金利算出用マスタ106bは、図5に示すように、債権No、返済回数、閏年をまたぐ場合に返済回数を2回に分割するための返済回数枝番、積数始期、積数終期、積数日数、一年間日数、残高、残高積数、及びみなし利息額等のデータを含むテーブル等である。 The real interest rate calculation master 106b is a master used by the real interest rate calculation unit 102b to calculate the real interest rate when making a loan or when changing a loan contract. As shown in FIG. 5, the real interest rate calculation master 106b has a claim number, a number of repayments, and a number of repayments for dividing the number of repayments into two when crossing a fallow year. It is a table or the like containing data such as the number of days, the number of days in a year, the balance, the number of products in balance, and the deemed interest amount.

返済回数枝番は、通常は「1(回)」であり、当月の25日を支払日とした場合、通常、積算日数は、積数始期が前月の26日で積数終期が当月の25日となる。本実施の形態では、閏年をまたぐ場合には、積算日数を年度末にリセットして新年度から新たに積算を開始するために、12月26日〜12月31日を返済回数枝番「1」とし、1月1日〜1月25日を返済回数枝番「2」として、一年間日数が正確になるようにして、実質金利を正確に算出できるようにしている。 The number of repayments branch number is usually "1 (times)", and if the 25th of the current month is the payment date, the cumulative number of days is usually the 26th of the previous month and the end of the product is 25 of the current month. It will be a day. In the present embodiment, in the case of crossing a leap year, the number of repayments from December 26 to December 31 is set to "1" in order to reset the accumulated days at the end of the fiscal year and start a new accumulated from the new year. From January 1st to January 25th, the number of repayments is set to "2" so that the number of days in a year is accurate so that the real interest rate can be calculated accurately.

制御部102は、融資管理装置100を統括的に制御するCPU等である。制御部102は、OS等の制御プログラム・各種の処理手順等を規定したプログラム・所要データなどを格納するための内部メモリを有し、格納されているこれらのプログラムに基づいて種々の情報処理を実行する。制御部102は、機能概念的に、返済予定算出部102aと、実質金利算出部102bと、上限手数料算出部102cとを備えている。 The control unit 102 is a CPU or the like that comprehensively controls the loan management device 100. The control unit 102 has an internal memory for storing a control program such as an OS, a program that defines various processing procedures, required data, and the like, and performs various information processing based on these stored programs. Run. The control unit 102 functionally includes a repayment schedule calculation unit 102a, a real interest rate calculation unit 102b, and an upper limit fee calculation unit 102c.

返済予定算出部102aは、返済予定マスタ106aを使用して、返済予定を作成する。返済予定の融資時と契約更新時の返済予定の作成は、上記図1〜図3で説明したのと同様である。 The repayment schedule calculation unit 102a creates a repayment schedule using the repayment schedule master 106a. The preparation of the repayment schedule at the time of loan and contract renewal is the same as described in FIGS. 1 to 3 above.

実質金利算出部102bは、実質金利算出用マスタ106bを使用して、融資の際又は当該融資の契約変更の際に実質金利を算出する。実質金利算出部102bは、対象の融資(債権No)に関して、返済回毎に、返済回数枝番、積数始期、積数終期、積数日数、一年間日数、残高、残高積数、及びみなし利息額を算出して、実質金利算出用マスタ106bに登録し、実質金利を、実質金利=みなし利息÷残高積数累計で算出する。 The real interest rate calculation unit 102b uses the real interest rate calculation master 106b to calculate the real interest rate at the time of financing or when the contract of the financing is changed. The real interest rate calculation unit 102b considers the number of repayments, the number of repayments, the beginning of the product, the end of the product, the number of days of the product, the number of days in a year, the balance, the number of balance products, and the number of balances for each repayment of the target loan (credit No.). The interest amount is calculated and registered in the real interest rate calculation master 106b, and the real interest rate is calculated by the real interest rate = deemed interest ÷ cumulative balance product.

上限手数料算出部102cは、契約変更時の実質金利が上限金利を超えないように、融資の契約変更の際の手数料の上限を上限手数料として算出し、算出した上限手数料をモニタ112の画面に表示する。上限手数料は、上限手数料=上限金利15%÷一年間日数−みなし利息(契約変更の際の手数料を除く)で算出する。 The upper limit fee calculation unit 102c calculates the upper limit of the fee at the time of changing the loan contract as the upper limit fee so that the real interest rate at the time of contract change does not exceed the upper limit interest rate, and displays the calculated upper limit fee on the screen of the monitor 112. do. The maximum fee is calculated as maximum fee = maximum interest rate 15% ÷ number of days per year-deemed interest (excluding fees when changing contracts).

[3.処理の具体例]
本実施の形態に係る融資管理装置100の処理の具体例について、図2〜図10を参照して詳細に説明する。図6〜図10は、本実施の形態に係る融資管理装置100の処理の具体例を説明するための図である。以下の具体例では、融資の契約変更の場合として、「早期完済」を例示して説明する。
[3. Specific example of processing]
A specific example of the processing of the loan management device 100 according to the present embodiment will be described in detail with reference to FIGS. 2 to 10. 6 to 10 are diagrams for explaining a specific example of the processing of the loan management device 100 according to the present embodiment. In the following specific example, "early repayment" will be illustrated and described as a case of changing the loan contract.

図6は、融資時(融資申し込み時)の実質金利を算出する場合の表示例を説明するための図である。図7は、融資時の実質金利の算出を説明するための図である。 FIG. 6 is a diagram for explaining a display example when calculating the real interest rate at the time of loan (at the time of loan application). FIG. 7 is a diagram for explaining the calculation of the real interest rate at the time of financing.

融資時(融資申し込み時)の実質金利を算出する場合は、実質金利算出部102bは、例えば、図6(A)に示す画面をモニタ114に表示する。図6(A)において、ユーザが入力装置112を操作して、債権No、融資日、融資金額、融資利率、返済回数、返済期間、事務手数料を入力して、実行ボタンを押すと、実質金利算出部102bは、当該債権Noについて、入力される、融資日、融資金額、融資利率、返済回数、返済期間、及び事務手数料に基づいて、実質金利を算出する。 When calculating the real interest rate at the time of loan (at the time of loan application), the real interest rate calculation unit 102b displays, for example, the screen shown in FIG. 6A on the monitor 114. In FIG. 6A, when the user operates the input device 112 to input the loan No., the loan date, the loan amount, the loan interest rate, the number of repayments, the repayment period, and the administrative fee, and press the execute button, the real interest rate is reached. The calculation unit 102b calculates the real interest rate for the loan No. based on the loan date, the loan amount, the loan interest rate, the number of repayments, the repayment period, and the administrative fee.

図6(A)に示す例では、債権No「1001−1」、融資日「2012/11/1」、融資金額「1,000,000円」、融資利率「12.000000%」、返済回数「20」、返済期間「2012/11/25〜2014/6/25」、事務手数料「10,000円」が入力されている。 In the example shown in FIG. 6 (A), the loan No. “1001-1”, the loan date “2012/11/1”, the loan amount “1,000,000 yen”, the loan interest rate “12,000,000%”, and the number of repayments "20", repayment period "2012/11/25 to 2014/6/25", and administrative fee "10,000 yen" are entered.

債権No「1001−1」、融資日「2012/11/1」、融資金額「1,000,000円」、融資利率「12.000000%」、返済回数「20」、返済期間「2012/11/25〜2014/6/25」、事務手数料「10,000」の場合の返済回数、返済回数枝番、積数始期、積数終期、積数日数、一年間日数、残高、残高積数、及びみなし利息額の計算例は、図7に示すようになる。 Loan No. "1001-1", loan date "2012/11/1", loan amount "1,000,000 yen", loan interest rate "12,000,000%", number of repayments "20", repayment period "2012/11" / 25-2014 / 6/25 ”, number of repayments in case of administrative fee“ 10,000 ”, number of repayments branch number, start of product number, end of product number, number of product days, number of days per year, balance, balance product number, An example of calculating the deemed interest amount is shown in FIG.

図7において、残高積数は、残高積数=残高×積数日数÷一年間日数で算出する。返済回数枝番は、通常は「1(回)」であり、当月の25日が支払日であるため、積算日数は、積数始期が前月の26日で積数終期が25日となる。本例では、閏年をまたぐため、返済回数3回目の2012/12/26〜2013/1/25日の返済を2回に分割し、2012/12/26(積数始期)〜2012/12/31(積数終期)を返済回数枝番「1」とし、2013/1/1(積数始期)〜2013/1/26(積数終期)を返済回数枝番「2」とし、一年間日数が正確になるようにして、実質金利の誤差が小さくなるようにしている。 In FIG. 7, the balance product number is calculated by the balance product number = balance × product days / one year days. The number of repayments branch number is usually "1 (times)", and the 25th of the current month is the payment date. Therefore, the cumulative number of days is 26 days for the beginning of the product and 25 days for the end of the product. In this example, in order to straddle the off-year, the third repayment on 2012/12/26 to 2013/1/25 is divided into two, and 2012/12/26 (start of product number) to 2012/12 / 31 (end of product number) is set as the number of repayment branch number "1", and 2013/1/1 (start of product number) to 2013/1/26 (end of product number) is set as the number of repayment branch number "2". Is accurate so that the error in the real interest rate is small.

さらに、実質金利算出部102bは、実質金利を、実質金利=みなし利息×残高積数累計で算出する。図7に示す例では、実質金利=13.16439%となり、実質金利算出部102bは、算出した実質金利を図6(B)に示すように表示する。そして、ユーザが登録ボタンを押すと、実質金利算出部102bは、債権NO「1001−1」について、算出した、返済回数、返済回数枝番、積数始期、積数終期、積数日数、一年間日数、残高、残高積数、及びみなし利息額のデータを実質金利算出用マスタ106bに登録する。 Further, the real interest rate calculation unit 102b calculates the real interest rate by multiplying the real interest rate by the deemed interest rate and the cumulative balance product. In the example shown in FIG. 7, the real interest rate is 13.16439%, and the real interest rate calculation unit 102b displays the calculated real interest rate as shown in FIG. 6 (B). Then, when the user presses the registration button, the real interest rate calculation unit 102b calculates the number of repayments, the number of repayments, the branch number, the beginning of the product, the end of the product, the number of days of the product, and one for the claim number "1001-1". The data of the number of days per year, the balance, the product of balances, and the deemed interest amount are registered in the real interest rate calculation master 106b.

図8は、本実施の形態の早期完済時の実質金利を算出する場合のモニタ114の表示例を説明するための図である。図9は、本実施の形態の早期完済時の実質金利の算出を説明するための図である。 FIG. 8 is a diagram for explaining a display example of the monitor 114 when calculating the real interest rate at the time of early repayment according to the present embodiment. FIG. 9 is a diagram for explaining the calculation of the real interest rate at the time of early repayment of the present embodiment.

早期完済時の実質金利を算出する場合には、実質金利算出部102bは、例えば、図8(A)に示す画面をモニタ114に表示する。図8(A)において、ユーザが入力装置112を操作して、債権No、早期完済日、繰上手数料を入力して、実行ボタンを押すと、実質金利算出部102bは、当該債権Noについて、実質金利算出用マスタ106bに既に登録されているデータを参照して、実質金利を算出する。 When calculating the real interest rate at the time of early repayment, the real interest rate calculation unit 102b displays, for example, the screen shown in FIG. 8A on the monitor 114. In FIG. 8A, when the user operates the input device 112 to input the bond No., the early repayment date, and the advance fee and press the execute button, the real interest rate calculation unit 102b actually describes the bond No. The real interest rate is calculated with reference to the data already registered in the interest rate calculation master 106b.

図8(A)に示す例では、債権No「1001−1」、早期完済日「2013/4/25」、繰上手数料「10.000円」が入力されている。 In the example shown in FIG. 8A, the claim No. “1001-1”, the early repayment date “2013/4/25”, and the advance fee “10.000 yen” are input.

実質金利算出部102bは、債権NO「1001−1」、について、実質金利算出用マスタ106bに既に登録されているデータを参照して、返済回数毎に、返済回数枝番、積数始期、積数終期、積数日数、一年間日数、残高、残高積数、及びみなし利息額を算出する。債権No「1001−1」、早期完済日「2013/4/25」、繰上手数料「10.000円」とした場合の返済回数、返済回数枝番、積数始期、積数終期、積数日数、一年間日数、残高、残高積数、及びみなし利息の計算例は、図9に示すようになる。 The real interest rate calculation unit 102b refers to the data already registered in the real interest rate calculation master 106b for the claim NO “1001-1”, and for each repayment number, the repayment number branch number, the product number start, and the product. Calculate the end of the number, the number of days of product, the number of days in one year, the balance, the number of products in balance, and the deemed interest amount. Number of repayments, number of repayments, branch number, start of product number, end of product number, number of days of product when claim No. "1001-1", early repayment date "2013/4/25", advance fee "10.000 yen" An example of calculation of the number of days per year, the balance, the number of products in balance, and the deemed interest is shown in FIG.

図9において、返済回数は6回となっており、返済回数枝番は、図7と同様である。みなし利息には、繰上手数料10,000円も含まれている。 In FIG. 9, the number of repayments is 6, and the number of repayments is the same as in FIG. 7. The deemed interest includes an advance fee of 10,000 yen.

さらに、実質金利算出部102bは、実質金利を、図7と同様に、実質金利=みなし利息×残高積数累計で算出する。図9に示す例では、実質金利=16.76325%(=みなし利息70,377円÷残高積数累計419,829円)となり、実質金利算出部102bは、算出した実質金利を図8(B)に示すように表示する。このように、本例の繰上弁済手数料10,000円では、実質金利が15%を超えてしまう。 Further, the real interest rate calculation unit 102b calculates the real interest rate by multiplying the real interest rate by the deemed interest rate and the cumulative balance product, as in FIG. 7. In the example shown in FIG. 9, the real interest rate = 16.76325% (= deemed interest 70,377 yen ÷ cumulative balance product number 419,829 yen), and the real interest rate calculation unit 102b calculates the real interest rate in FIG. 8 (B). ) Is displayed. In this way, with the prepayment fee of 10,000 yen in this example, the real interest rate exceeds 15%.

他方、上限手数料算出部102cは、上限手数料を、上限手数料=15%×残高積数累計÷一年間日数−みなし利息(繰上手数料を除く)で算出する。図9に示す例では、上限手数料は2,597円(=上限金利15%÷一年間日数366−みなし利息(みなし利息70,377円−繰上手数料10,000円))となり、上限手数料算出部102cは、算出した上限手数料を図8(B)に示すように表示する。 On the other hand, the maximum fee calculation unit 102c calculates the maximum fee by the maximum fee = 15% × cumulative balance product ÷ number of days in one year-deemed interest (excluding advance fee). In the example shown in FIG. 9, the maximum fee is 2,597 yen (= maximum interest rate 15% ÷ number of days per year 366-deemed interest (deemed interest 70,377 yen-advance fee 10,000 yen)), and the maximum fee calculation unit 102c displays the calculated maximum fee as shown in FIG. 8 (B).

この上限手数料は正確な金額であるので、繰上手数料を2,577円とした場合、実質金利は14.999916(=みなし利息(60,377円+2,597円)÷残高積数累計419,829円)となり、上限金利に極めて近い値となるため、上限金利ぎりぎりまで繰上手数料を設定することができる。 Since this maximum fee is an accurate amount, if the advance fee is 2,577 yen, the real interest rate is 14.999916 (= deemed interest (60,377 yen + 2,597 yen) ÷ cumulative balance product number 419,829. Yen), which is extremely close to the maximum interest rate, so it is possible to set an advance fee up to the limit of the maximum interest rate.

実質金利算出部102bは、実質金利が15%を越える場合は、登録ボタンが押されても、例えば、「実質金利が上限金利を超えているので、繰上手数料を再設定(例えば、上限手数料に設定)して再度計算して下さい。」というメッセージを表示して、算出したデータ(返済回数、返済回数枝番、積数始期、積数終期、積数日数、一年間日数、残高、残高積数、及びみなし利息)の実質金利算出用マスタ106bへの登録を禁止してもよい。他方、実質金利算出部102bは、実質金利が15%以下となる場合のみ、算出したデータを実質金利算出用マスタ106bへ登録することにしてもよい。 When the real interest rate exceeds 15%, the real interest rate calculation unit 102b resets the advance fee (for example, to the maximum fee because the real interest rate exceeds the maximum interest rate) even if the registration button is pressed. Please set) and calculate again. ”Is displayed, and the calculated data (repayment count, repayment count branch number, product start, product end, product days, one year days, balance, balance product) The registration of numbers and deemed interest rates in the real interest rate calculation master 106b may be prohibited. On the other hand, the real interest rate calculation unit 102b may register the calculated data in the real interest rate calculation master 106b only when the real interest rate is 15% or less.

ユーザが、図8(B)の画面で繰上手数料を上限手数料に変更して、実行ボタンを押すと、実質金利算出部102bは、繰上手数料を上限手数料とした場合のデータを計算し、登録ボタンが押されると、実質金利算出用マスタ106bにデータを登録する。 When the user changes the advance fee to the upper limit fee on the screen of FIG. 8B and presses the execute button, the real interest rate calculation unit 102b calculates the data when the advance fee is set as the upper limit fee and presses the registration button. When is pressed, the data is registered in the real interest rate calculation master 106b.

図10は、早期返済時の変形例を説明するための図である。繰上手数料を入力(設定)しないで、直接、上限手数料と当該上限手数料を繰上手数料とした場合の実質金利を算出して表示してもよい。実質金利算出部102bは、例えば、図10(A)に示す画面をモニタ114に表示する。図10(A)において、ユーザが入力装置112を操作して、債権No(例えば、1001−1)、早期完済日(例えば、2013/4/25)を入力して、実行ボタンを押す。これに応じて、図10(B)に示すように、当該債権Noについて、上限手数料算出部106cは、図9と同じ方法で、上限手数料を算出して表示し、実質金利算出部102bは、図9と同じ方法で、当該算出した上限手数料を繰上手数料とした場合の実質金利を算出して表示してもよい。登録ボタンが押されると、実質金利算出部102bは、実質金利算出用マスタ106bに算出したデータを登録する。これにより、ユーザは繰上手数料を入力しなくても、上限手数料を設定することができ、ユーザの手間を省くことが可能となる。 FIG. 10 is a diagram for explaining a modified example at the time of early repayment. The real interest rate when the maximum fee and the maximum fee are used as the advance fee may be calculated and displayed directly without inputting (setting) the advance fee. The real interest rate calculation unit 102b displays, for example, the screen shown in FIG. 10A on the monitor 114. In FIG. 10A, the user operates the input device 112 to input the claim No. (for example, 1001-1) and the early repayment date (for example, 2013/4/25), and press the execute button. Correspondingly, as shown in FIG. 10B, the maximum fee calculation unit 106c calculates and displays the maximum fee for the claim No. in the same manner as in FIG. 9, and the real interest rate calculation unit 102b displays it. The real interest rate when the calculated upper limit fee is used as the advance fee may be calculated and displayed by the same method as in FIG. When the registration button is pressed, the real interest rate calculation unit 102b registers the calculated data in the real interest rate calculation master 106b. As a result, the user can set the upper limit fee without inputting the advance fee, and the user's trouble can be saved.

以上説明したように、本実施の形態の融資管理装置100によれば、融資の際又は当該融資の契約変更の際に、実質金利を算出する実質金利算出部102bと、実質金利が上限金利を超えないように、融資の契約変更の際の手数料の上限を上限手数料として算出し、算出した上限手数料をモニタ114の画面に表示する上限手数料算出部102cと、を備えているので、融資の契約変更の際の手数料を上限金利を超えない範囲で高く設定することが可能となる。 As described above, according to the loan management device 100 of the present embodiment, the real interest rate calculation unit 102b that calculates the real interest rate and the real interest rate set the maximum interest rate at the time of financing or when the contract of the loan is changed. Since it is equipped with an upper limit fee calculation unit 102c that calculates the upper limit of the fee when changing the loan contract as the upper limit fee and displays the calculated upper limit fee on the screen of the monitor 114 so as not to exceed the loan contract. It is possible to set the fee for the change high within the range that does not exceed the maximum interest rate.

また、本実施の形態によれば、債権番号に関連づけて、返済回毎に、閏年をまたぐ場合に返済回数を2回に分割するための返済回数枝番、積数始期、積数終期、積数日数、一年間日数、残高、残高積数(但し、残高積数=残高×積数日数÷一年間日数)、及びみなし利息を格納する実質金利算出用マスタ106bを備え、実質金利算出部102bは、対象の債権番号について、返済回毎に、返済回数枝番、積数始期、積数終期、積数日数、一年間日数、残高、残高積数、及びみなし利息のデータを算出して実質金利算出用マスタ106bに登録し、また、実質金利を、実質金利=みなし利息の累計÷残高積数の累計で算出し、上限手数料算出部102cは、上限手数料を、上限手数料=上限金利(%)×残高積数の累計−みなし利息で算出することとしたので、実質金利及び上限手数料を正確に算出することが可能となる。 In addition, according to the present embodiment, the number of repayments branch number, the beginning of the product number, the end of the product number, and the product for dividing the number of repayments into two in the case of crossing the off-year for each repayment number in relation to the claim number. It is equipped with a real interest rate calculation master 106b that stores several days, one year days, balance, balance product number (however, balance product number = balance x product days ÷ one year days), and the real interest rate calculation unit 102b. Calculates the data of the number of repayments, the number of repayments, the beginning of the product, the end of the product, the number of days of the product, the number of days in a year, the balance, the number of balance products, and the deemed interest for each repayment. Registered in the interest rate calculation master 106b, the real interest rate is calculated by the real interest rate = cumulative total of deemed interest ÷ cumulative number of balance products, and the maximum fee calculation unit 102c sets the maximum fee and the maximum fee = maximum interest rate (%). ) × Cumulative balance product-Assumed interest is calculated, so the real interest rate and maximum fee can be calculated accurately.

また、本実施の形態によれば、実質金利算出部102bは、算出した実質金利が上限金利を超える場合は、実質金利算出用マスタ106bへの算出したデータの登録を禁止することとしたので、実質金利算出用マスタ106bに不適切なデータが登録されるのを防止することが可能となる。 Further, according to the present embodiment, the real interest rate calculation unit 102b prohibits the registration of the calculated data in the real interest rate calculation master 106b when the calculated real interest rate exceeds the upper limit interest rate. It is possible to prevent inappropriate data from being registered in the real interest rate calculation master 106b.

なお、上記実施の形態では、融資の契約変更を早期完済とした場合について説明したが、本発明はこれに限られるものではなく、繰上弁済等についても適用可能である。 In the above embodiment, the case where the loan contract change is made early payment has been described, but the present invention is not limited to this, and can be applied to advance payment and the like.

[4.他の実施形態]
本発明は、上述した実施形態以外にも、特許請求の範囲に記載した技術的思想の範囲内において種々の異なる実施形態にて実施されてよいものである。
[4. Other embodiments]
In addition to the above-described embodiments, the present invention may be implemented in various different embodiments within the scope of the technical ideas described in the claims.

例えば、実施形態において説明した各処理のうち、自動的に行われるものとして説明した処理の全部又は一部を手動的に行うこともでき、あるいは、手動的に行われるものとして説明した処理の全部又は一部を公知の方法で自動的に行うこともできる。 For example, of each of the processes described in the embodiments, all or part of the processes described as being automatically performed may be manually performed, or all of the processes described as being performed manually. Alternatively, a part thereof can be automatically performed by a known method.

また、本明細書中や図面中で示した処理手順、制御手順、具体的名称、各処理の登録データや検索条件等のパラメータを含む情報、画面例、データベース構成については、特記する場合を除いて任意に変更することができる。 In addition, the processing procedure, control procedure, specific name, information including parameters such as registration data and search conditions of each processing, screen examples, and database configuration shown in the present specification and drawings are not specified unless otherwise specified. Can be changed arbitrarily.

また、融資管理装置100に関して、図示の各構成要素は機能概念的なものであり、必ずしも物理的に図示の如く構成されていることを要しない。 Further, with respect to the loan management device 100, each component shown in the figure is a functional concept and does not necessarily have to be physically configured as shown in the figure.

例えば、融資管理装置100が備える処理機能、特に制御部102にて行われる各処理機能については、その全部又は任意の一部を、CPUおよび当該CPUにて解釈実行されるプログラムにて実現してもよく、また、ワイヤードロジックによるハードウェアとして実現してもよい。尚、プログラムは、本実施形態で説明した処理を情報処理装置に実行させるためのプログラム化された命令を含む一時的でないコンピュータ読み取り可能な記録媒体に記録されており、必要に応じて融資管理装置100に機械的に読み取られる。すなわち、ROM又はHDD(Hard Disk Drive)などの記憶部などには、OSと協働してCPUに命令を与え、各種処理を行うためのコンピュータプログラムが記録されている。このコンピュータプログラムは、RAMにロードされることによって実行され、CPUと協働して制御部を構成する。 For example, with respect to the processing functions included in the loan management device 100, particularly each processing function performed by the control unit 102, all or any part thereof is realized by the CPU and a program interpreted and executed by the CPU. It may be realized as hardware by wired logic. The program is recorded on a non-temporary computer-readable recording medium including a programmed instruction for causing the information processing apparatus to execute the process described in the present embodiment, and the loan management apparatus is required. Read mechanically to 100. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or an HDD (Hard Disk Drive). This computer program is executed by being loaded into RAM, and cooperates with a CPU to form a control unit.

また、このコンピュータプログラムは、融資管理装置100に対して任意のネットワークを介して接続されたアプリケーションプログラムサーバに記憶されていてもよく、必要に応じてその全部又は一部をダウンロードすることも可能である。 Further, this computer program may be stored in an application program server connected to the loan management device 100 via an arbitrary network, and all or a part thereof can be downloaded as needed. be.

また、本実施形態で説明した処理を実行するためのプログラムを、一時的でないコンピュータ読み取り可能な記録媒体に格納してもよく、また、プログラム製品として構成することもできる。ここで、この「記録媒体」とは、メモリーカード、USB(Universal Serial Bus)メモリ、SD(Secure Digital)カード、フレキシブルディスク、光磁気ディスク、ROM、EPROM(Erasable Programmable Read Only Memory)、EEPROM(登録商標)(Electrically Erasable and Programmable Read Only Memory)、CD−ROM(Compact Disk Read Only Memory)、MO(Magneto−Optical disk)、DVD(Digital Versatile Disk)、および、Blu−ray(登録商標) Disc等の任意の「可搬用の物理媒体」を含むものとする。 Further, the program for executing the process described in the present embodiment may be stored in a non-temporary computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes a memory card, a USB (Universal Serial Bus) memory, an SD (Secure Digital) card, a flexible disk, a magneto-optical disk, a ROM, an EPROM (Erasable Programmable Read Only Memory), and an EEPROM (registration). Trademarks) (Electrically Erasable and Programmable Read Only Memory), CD-ROM (Compact Disk Read Only Memory), MO (Magnet-Optical Disk), MO (Magnet-Optical Disk), MO (Magnet-Optical Disc), DVD (Digital), DVD (Digital) It shall include any "portable physical medium".

また、「プログラム」とは、任意の言語又は記述方法にて記述されたデータ処理方法であり、ソースコード又はバイナリコード等の形式を問わない。なお、「プログラム」は必ずしも単一的に構成されるものに限られず、複数のモジュールやライブラリとして分散構成されるものや、OSに代表される別個のプログラムと協働してその機能を達成するものをも含む。なお、実施形態に示した各装置において記録媒体を読み取るための具体的な構成および読み取り手順ならびに読み取り後のインストール手順等については、周知の構成や手順を用いることができる。 The "program" is a data processing method described in any language or description method, regardless of the format such as source code or binary code. The "program" is not necessarily limited to a single program, but is distributed as a plurality of modules or libraries, or cooperates with a separate program represented by the OS to achieve its function. Including things. A well-known configuration or procedure can be used for a specific configuration and reading procedure for reading the recording medium in each device shown in the embodiment, an installation procedure after reading, and the like.

記憶部106に格納される各種のデータベース等は、RAM、ROM等のメモリ装置、ハードディスク等の固定ディスク装置、フレキシブルディスク、および、光ディスク等のストレージ手段であり、各種処理やウェブサイト提供に用いる各種のプログラム、テーブル、データベース、および、ウェブページ用ファイル等を格納する。 Various databases and the like stored in the storage unit 106 are memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and storage means such as optical disks, and are used for various processes and website provision. Stores programs, tables, databases, files for web pages, etc.

また、融資管理装置100は、既知のパーソナルコンピュータ又はワークステーション等の情報処理装置として構成してもよく、また、任意の周辺装置が接続された当該情報処理装置として構成してもよい。また、融資管理装置100は、当該装置に本実施形態で説明した処理を実現させるソフトウェア(プログラム又はデータ等を含む)を実装することにより実現してもよい。 Further, the loan management device 100 may be configured as an information processing device such as a known personal computer or workstation, or may be configured as the information processing device to which an arbitrary peripheral device is connected. Further, the loan management device 100 may be realized by mounting software (including a program or data) that realizes the processing described in the present embodiment on the device.

更に、装置の分散・統合の具体的形態は図示するものに限られず、その全部又は一部を、各種の付加等に応じて又は機能負荷に応じて、任意の単位で機能的又は物理的に分散・統合して構成することができる。すなわち、上述した実施形態を任意に組み合わせて実施してもよく、実施形態を選択的に実施してもよい。 Further, the specific form of dispersion / integration of the device is not limited to the one shown in the figure, and all or part of the device is functionally or physically in an arbitrary unit according to various additions or functional loads. It can be distributed and integrated. That is, the above-described embodiments may be arbitrarily combined and implemented, or the embodiments may be selectively implemented.

100 融資管理装置
102 制御部
102a 返済予定算出部
102b 実質金利算出部
102c 上限手数料算出部
104 通信インターフェース部
106 記憶部
106a 返済予定マスタ
106b 実質金利算出用マスタ
108 入出力インターフェース部
112 入力装置
114 出力装置
200 サーバ
300 ネットワーク
100 loan management device
102 Control unit
102a Repayment schedule calculation unit
102b Real interest rate calculation unit
102c Maximum fee calculation unit
104 Communication interface section
106 Storage
106a Scheduled repayment master
106b Real interest rate calculation master
108 Input / output interface section
112 Input device
114 Output device 200 Server 300 Network

Claims (6)

記憶部及び制御部を備えた融資管理装置であって、
前記記憶部には、
債権番号に関連づけて、返済回毎に、積数始期、積数終期、積数日数、一年間日数、残高、残高積数(但し、残高積数=残高×積数日数÷一年間日数)、及びみなし利息を格納するための実質金利算出用マスタが格納されており、
前記制御部は、
融資の際又は当該融資の契約変更の際に、対象の債権番号について、返済回毎に、前記積数始期、前記積数終期、前記積数日数、前記一年間日数、前記残高、前記残高積数、及び前記みなし利息のデータを算出して前記実質金利算出用マスタに登録し、前記実質金利算出用マスタに既に登録されているデータを参照して、実質金利を、実質金利=みなし利息÷残高積数の累計で算出する実質金利算出手段と、
前記実質金利が上限金利を超えないように、前記融資の契約変更の際の手数料の上限を上限手数料として、上限手数料=上限金利(%)×残高積数の累計−みなし利息で算出し、算出した上限手数料を表示手段の画面に表示する上限手数料算出手段と、
を備えたことを特徴とする融資管理装置。
A loan management device equipped with a storage unit and a control unit.
In the storage unit
In relation to the credit number, for each repayment, the beginning of the product, the end of the product, the number of days of the product, the number of days in one year, the balance, the number of balance products (however, the number of balance products = balance x the number of days in the product ÷ the number of days in one year), And the master for calculating the real interest rate for storing the deemed interest is stored.
The control unit
At the time of financing or when the contract of the financing is changed, for each repayment, the beginning of the product, the end of the product, the number of days of the product, the number of days in one year, the balance, and the product of the balance. Calculate the number and the deemed interest data and register it in the real interest rate calculation master, and refer to the data already registered in the real interest rate calculation master to set the real interest rate as real interest rate = deemed interest ÷ A real interest rate calculation method that calculates the cumulative number of outstanding balances,
To prevent the real interest rate from exceeding the maximum interest rate, the maximum fee is set as the maximum fee when changing the contract of the loan, and the maximum fee = maximum interest rate (%) x cumulative balance product-deemed interest is calculated and calculated. The upper limit fee calculation means that displays the upper limit fee on the screen of the display means, and
A loan management device characterized by being equipped with.
前記実質金利算出用マスタは、さらに、閏年をまたぐ場合に返済回数を2回に分割するための返済回数枝番を含むことを特徴とする請求項1に記載の融資管理装置。 The loan management device according to claim 1, wherein the real interest rate calculation master further includes a repayment number branch number for dividing the repayment number into two in the case of straddling a leap year. 前記実質金利算出手段は、算出した実質金利が上限金利を超える場合は、前記実質金利算出用マスタへの算出したデータの登録を禁止することを特徴とする請求項1又は請求項2に記載の融資管理装置。 The method according to claim 1 or 2, wherein the real interest rate calculation means prohibits registration of the calculated data in the real interest rate calculation master when the calculated real interest rate exceeds the maximum interest rate. Loan management device. 前記融資の契約の変更は、早期完済であることを特徴とする請求項1〜請求項3のいずれか1つに記載の融資管理装置。 The loan management device according to any one of claims 1 to 3, wherein the change of the loan contract is an early payment. 記憶部及び制御部を備えた情報処理装置で実行される融資管理方法であって、
前記記憶部には、
債権番号に関連づけて、返済回毎に、積数始期、積数終期、積数日数、一年間日数、残高、残高積数(但し、残高積数=残高×積数日数÷一年間日数)、及びみなし利息を格納するための実質金利算出用マスタが格納されており、
前記制御部で実行される、
融資の際又は当該融資の契約変更の際に、対象の債権番号について、返済回毎に、前記積数始期、前記積数終期、前記積数日数、前記一年間日数、前記残高、前記残高積数、及び前記みなし利息のデータを算出して前記実質金利算出用マスタに登録し、前記実質金利算出用マスタに既に登録されているデータを参照して、実質金利を、実質金利=みなし利息÷残高積数の累計で算出する実質金利算出ステップと、
前記実質金利が上限金利を超えないように、前記融資の契約変更の際の手数料の上限を
上限手数料として、上限手数料=上限金利(%)×残高積数の累計−みなし利息で算出し、算出した上限手数料を表示手段の画面に表示する上限手数料算出ステップと、
を含むことを特徴とする融資管理方法。
A loan management method executed by an information processing device equipped with a storage unit and a control unit.
In the storage unit
In relation to the credit number, for each repayment, the beginning of the product, the end of the product, the number of days of the product, the number of days in one year, the balance, the number of balance products (however, the number of balance products = balance x the number of days in the product ÷ the number of days in one year), And the master for calculating the real interest rate for storing the deemed interest is stored.
Executed by the control unit,
At the time of loan or change of contract of the loan, for each repayment, the beginning of the product, the end of the product, the number of days of the product, the number of days in one year, the balance, and the product of the balance. Calculate the number and the deemed interest data and register it in the real interest rate calculation master, and refer to the data already registered in the real interest rate calculation master to set the real interest rate as real interest rate = deemed interest ÷ The real interest rate calculation step calculated by accumulating the balance products and
To prevent the real interest rate from exceeding the maximum interest rate, set the maximum fee for changing the loan contract.
As the maximum fee, the maximum fee is calculated by = maximum interest rate (%) x cumulative balance product-deemed interest, and the calculated maximum fee is displayed on the screen of the display means.
A loan management method characterized by including.
記憶部及び制御部を備えた情報処理装置に実行させるための融資管理プログラムであって、
前記記憶部には、
債権番号に関連づけて、返済回毎に、積数始期、積数終期、積数日数、一年間日数、残高、残高積数(但し、残高積数=残高×積数日数÷一年間日数)、及びみなし利息を格納するための実質金利算出用マスタが格納されており、
前記制御部において、
融資の際又は当該融資の契約変更の際に、対象の債権番号について、返済回毎に、前記積数始期、前記積数終期、前記積数日数、前記一年間日数、前記残高、前記残高積数、及び前記みなし利息のデータを算出して前記実質金利算出用マスタに登録し、前記実質金利算出用マスタに既に登録されているデータを参照して、実質金利を、実質金利=みなし利息÷残高積数の累計で算出する実質金利算出ステップと、
前記実質金利が上限金利を超えないように、前記融資の契約変更の際の手数料の上限を
上限手数料として、上限手数料=上限金利(%)×残高積数の累計−みなし利息で算出し、算出した上限手数料を表示手段の画面に表示する上限手数料算出ステップと、
をコンピュータに実行させるための融資管理プログラム。
It is a loan management program to be executed by an information processing device equipped with a storage unit and a control unit.
In the storage unit
In relation to the credit number, for each repayment, the beginning of the product, the end of the product, the number of days of the product, the number of days in one year, the balance, the number of balance products (however, the number of balance products = balance x the number of days in the product ÷ the number of days in one year), And the master for calculating the real interest rate for storing the deemed interest is stored.
In the control unit,
At the time of loan or change of contract of the loan, for each repayment, the beginning of the product, the end of the product, the number of days of the product, the number of days in one year, the balance, and the product of the balance. Calculate the number and the deemed interest data and register it in the real interest rate calculation master, and refer to the data already registered in the real interest rate calculation master to set the real interest rate as real interest rate = deemed interest ÷ The real interest rate calculation step calculated by accumulating the balance products and
To prevent the real interest rate from exceeding the maximum interest rate, set the maximum fee for changing the loan contract.
As the maximum fee, the maximum fee is calculated by = maximum interest rate (%) x cumulative balance product-deemed interest, and the calculated maximum fee is displayed on the screen of the display means.
A loan management program that lets your computer run.
JP2017061405A 2017-03-27 2017-03-27 Loan management equipment, loan management methods, and loan management programs Active JP6943588B2 (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
JP2017061405A JP6943588B2 (en) 2017-03-27 2017-03-27 Loan management equipment, loan management methods, and loan management programs

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
JP2017061405A JP6943588B2 (en) 2017-03-27 2017-03-27 Loan management equipment, loan management methods, and loan management programs

Publications (2)

Publication Number Publication Date
JP2018163584A JP2018163584A (en) 2018-10-18
JP6943588B2 true JP6943588B2 (en) 2021-10-06

Family

ID=63861098

Family Applications (1)

Application Number Title Priority Date Filing Date
JP2017061405A Active JP6943588B2 (en) 2017-03-27 2017-03-27 Loan management equipment, loan management methods, and loan management programs

Country Status (1)

Country Link
JP (1) JP6943588B2 (en)

Families Citing this family (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP7269022B2 (en) * 2019-02-04 2023-05-08 株式会社オービック Interest calculation device, interest calculation method and interest calculation program
JP7200025B2 (en) * 2019-03-28 2023-01-06 株式会社オービック Claims management device, claims management method, and claims management program
JP7732961B2 (en) * 2022-10-18 2025-09-02 株式会社オービック Guarantee fee revenue forecasting device, guarantee fee revenue forecasting method, and guarantee fee revenue forecasting program
JP7772734B2 (en) * 2023-04-20 2025-11-18 株式会社オービック Billing amount calculation system, billing amount calculation method, and billing amount calculation program

Also Published As

Publication number Publication date
JP2018163584A (en) 2018-10-18

Similar Documents

Publication Publication Date Title
JP6943588B2 (en) Loan management equipment, loan management methods, and loan management programs
JP7079674B2 (en) Money transfer management support device, money transfer management support method and money transfer management support program
JP7269022B2 (en) Interest calculation device, interest calculation method and interest calculation program
JP7397931B2 (en) Construction payment processing device, construction payment processing method, and construction payment processing program
JP7654857B2 (en) Project management device, project management method, and project management program
JP7085304B2 (en) Cost calculator, cost calculation method and cost calculation program
JP6827837B2 (en) Project-specific credit management device, project-specific credit management method, and project-specific credit management program
JP7324162B2 (en) Cost output device, cost output method, and cost output program
JP7644288B2 (en) Apparatus for preventing erroneous payment of rent, etc., method for preventing erroneous payment of rent, etc., and program for preventing erroneous payment of rent, etc.
JP2018156406A (en) Sales data creating apparatus, sales data creating method, and program for creating sales data
JP7212511B2 (en) Loan management device, loan management method, and loan management program
JP7202941B2 (en) CONTRACT MANAGEMENT DEVICE, CONTRACT MANAGEMENT METHOD, AND CONTRACT MANAGEMENT PROGRAM
JP7485751B2 (en) Work-related information management support device, work-related information management support method, and work-related information management support program
JP2022039638A (en) Business support device, business support program, and business support method
JP7623313B2 (en) Payroll calculation device, payroll calculation method, and payroll calculation program
JP6850160B2 (en) Payroll processing device, payroll correction processing method, and payroll correction processing program
JP7431712B2 (en) Income and expenditure management device, income and expenditure management method, and income and expenditure management program
JP2020042622A (en) Payment schedule management device, payment schedule management method, and payment schedule management program
JP2023060041A (en) Device, program, and method for supporting operation
JP7075289B2 (en) Journal creation device, journal creation method and journal creation program
JP6927771B2 (en) Sales management equipment, sales management methods, and sales management programs
JP2022042880A (en) Conversion rate management device, conversion rate management method, and conversion rate management program
JP2022086845A (en) Rent guarantee management device, rent guarantee management method, and rent guarantee management program
JP7670569B2 (en) Daily report processing device, daily report processing method, and daily report processing program
JP2020057260A (en) Intracompany interest rate calculation device, intracompany interest rate calculation method, and intracompany interest rate calculation program

Legal Events

Date Code Title Description
A621 Written request for application examination

Free format text: JAPANESE INTERMEDIATE CODE: A621

Effective date: 20200302

A977 Report on retrieval

Free format text: JAPANESE INTERMEDIATE CODE: A971007

Effective date: 20201225

A131 Notification of reasons for refusal

Free format text: JAPANESE INTERMEDIATE CODE: A131

Effective date: 20210209

A601 Written request for extension of time

Free format text: JAPANESE INTERMEDIATE CODE: A601

Effective date: 20210222

A521 Request for written amendment filed

Free format text: JAPANESE INTERMEDIATE CODE: A523

Effective date: 20210609

TRDD Decision of grant or rejection written
A01 Written decision to grant a patent or to grant a registration (utility model)

Free format text: JAPANESE INTERMEDIATE CODE: A01

Effective date: 20210810

A61 First payment of annual fees (during grant procedure)

Free format text: JAPANESE INTERMEDIATE CODE: A61

Effective date: 20210909

R150 Certificate of patent or registration of utility model

Ref document number: 6943588

Country of ref document: JP

Free format text: JAPANESE INTERMEDIATE CODE: R150

R250 Receipt of annual fees

Free format text: JAPANESE INTERMEDIATE CODE: R250