Welcome,to the room of the joke. By Lawyer Goemon aliving in the joke.  

Caution!!
The danger that fault will occur is in your computer.
 
 
 
 
 
 
 
1 At first, it is not a calculation unit period structure but, it is a statement of a lending day standard structure.
2 It is a calculation on the fraction February 29 in the period (abstract) of the Legal Affairs Bureaus adoption thought to be a sooner or later right as the repetition payoff calculation though it is an annual interest calculation.
3 It seemingly becomes the statement of the transformation and the strange appearance from the payoff day the middle payoff day, and the occurrence of the interest money inclusion of the first day by not the interest money inclusion but the first day of the next calculation and becoming, and the first day by the payoff day it on the same day.
4 feature of attached table calculation
The amount of money of the interest until the day before of the payoff day is calculated, and summed up in this statement as for I though usually calculates, and sums up the amount of money of the interest on that day of payoff to the amount of money of generation interest column. when the total of principal and interest money of the day present provinces amount of money is paid off before the day of payoff, principal and interest money becomes 0. Even if the principal and interest total amount of money on the payoff day at the time of which Ha is the last is paid off (Because it is not necessarily the day before of the payoff day last time), the principal and interest total amount of money doesn't become 0. It is natural. However, when the principal and interest total amount of money on the last payoff day is paid off from coming of the day before of the payoff day this time on the payoff day at the time of which it is the last when the payoff day is consecutive, the principal and interest total amount of money becomes 0 as for Ni. When the principal and interest total amount of money displayed in the principal and interest total amount of money column of the Ho payoff day is paid off, interest money equivalent the amount of money for a payoff day of that day becomes it is overHara.  
 
The computer program evolves every day and approaches completion.  

Please input it as follows when you try to conclude the consumption lending and borrowing contract.
1 The statement after it calculates the day before is printed.
2 The remainder principal is input to the amount advanced column.
3 Unpaid interest money is input to the succession interest money column.
4 The day when it tries to conclude the contract is input to the lending day column.
5 new interest rate is input to the interest rate column.  
I hope
you understand the meaning of attached table of enforcement regulations of loan industry method
 
 
 
 
WinXp does the setting that judges the virus the program with the macro, and change the setting, please if you cannot download it.  
 

05/04/23・The distribution was ended.
The explanation book on the loan industry method enforcement rule attached table calculation type is published soon.
The free input version, the interest rate change version, the version of the interest rate counting backward, and the even payoff calculation version are attached as the appendix of the book.

This book will become indispensable for the lawyer and the loan trader who handles the loan event.
050416&ratechangeversion050416
The warning display column has been adjusted.
050415&ratechangeversion050415
The command of changing on a day of the week of next month was set up on Saturday and Sunday.
050413&ratechangeversion050414
The warning display column has been adjusted.
ratechangeversion050413
The command of changing on a day of the week of next month was set up on Saturday and Sunday.
050412&ratechangeversion050412
Interest money on that day of payoff has been fine-tuned. It corrected it.
050411&ratechangeversion050411
The calculation of less than one year has been fine-tuned. It corrected it.
ratechangeversion050410
The interest rate change version was added.It is necessary to search for the place.
050410
The time of the round-down processing has been adjusted.
050404
The command button of an automatic input of 20 years at the date of payoff was set up.
050333
The display at the period of the payoff interval was wrong, when you do a rare input
It corrected it.

050331
The explanation was retouching corrected,though it is the second times
050330
If the interval of two lines is taken, five input on the same day was enabled. It corrected it according to lawyer Miyata's question.
050329
The mistake was found in the calculation of interest money of an additional loan By lawyer Miyata's point.
It corrected it.

050327
The explanation was retouching corrected.
050326
I think that this calculation has been almost completed.