Borrowings entry - [Repayment] tab

The "Borrowings entry" screen consists of the [Borrowing] tab, the [Repayment] tab and the [A/C // Payment method] tab. 
This section explains the items on the [Repayment] tab. 
 → To Operation Procedure

Screen Transition

[Borrowings control module]
  ↓
[Entry]
  ↓
[Borrowings entry]
  ↓
[Borrowings entry] screen - [Borrowing] tab
[Borrowings entry] screen - [Repayment] tab
    "Save" button →  [Transfer voucher] screen
[Borrowings entry] screen - [A/C/Payment method] tab

Item Setup - [Repayment] tab

[Borrowings condition]

• Repayment method
  Select the repayment method for the borrowings from "Principal-equal," "Equal payment" or "Others."
  The default displays "Principal-equal."  When "Borrow by notes" or "CP" is selected in "Borrowings type" of the [Borrowing] tab, the item doesn't appear.  

  Principal-equal repayment method	Equal payment method
  A method that principal is repaid with a series of regularly scheduled payment.  Total payment amount is calculated by principal adding to interest.	A repayment method that payment amount is of equal size for each installment.  Principal repayment amount is calculated by the payment amount subtracted by interest.  In the first years of repayment, principal repayment amount accounts for a small percentage of payment amount.  As time passes, principal repayment amount increases.

• T/F date (in case of closure)
  Select "Previous business day" or "Next business day" for T/F date, in case that scheduled repayment date falls on closure of the financial institution (holiday in [Register calendar]). 
• Payment count
  Enter the total payment count for the period until the borrowings repayment is completed. 
  Note that the payment count does not include payment interest incurred when "Prepaid" is selected for "Coupon payment" in the [Borrowing] tab.  When "Others" is selected in "Repayment method," the item does not appear. 
• Interest
  Select the interest calculation method from "Daily pay" or "Monthly pay." 
• Even if "Monthly pay" is selected, you can select the calculation method for the first repayment from "Monthly pay" or "Daily pay."  Selecting "Monthly pay" and clicking the "Execute" button at the bottom of [Repayment schedule], the [First payment interest calculation] screen appear so that you can select the calculation method from "Daily pay" or "Monthly pay." 
• Fraction adjustment (interest)
  Select the fraction adjustment method for interest calculation from "Revaluate," "Omit" or "Round OFF." 
• Daily repayment days (in case of closure)
  Select "Contract date" or "T/F date" to count daily repayment days in case that scheduled repayment date falls on closure of the financial institution. 
• Daily repayment days
  Select the count method of daily repayment days for interest calculation from "Excluding the date of front end," "Excluding the date of rear end" or "Including both days." 
• Annual days
  Enter the number of days of which one year consists for interest calculation.  The default displays 365 days.  "0" cannot be entered. 

[Borrowings condition] - the items shown when "Principal-equal" or "Equal payment" is selected in "Repayment method" 

• First installment payment
  Enter the first repayment amount. 
• Installment
  Enter the repayment amount for each installment.  Repayment for each installment means repayment excluding the first and last installments.  When single or two installments is selected in "Payment count," the item is not displayed.   
• Last payment of installment
  Enter the last repayment amount. 
  When single payment is selected in "Payment count," the item is not displayed. 
• First repayment date
  Enter the first repayment date.   
• Repayment date
  Enter the repayment date for every month or term from "1" – "31."  When the repayment is made on closing date, enter "31." 
• Repayment interval
  Enter the repayment interval from "1" – "12" indicating every how many months the repayment is made.  

[Borrowings condition] - the items shown when "Others" is selected in "Repayment method"

• First principal repayment date
  Enter the first repayment date for borrowing principal.  When the first principal repayment has been already done, the item cannot be changed. 
• Principal repayment date
  Enter the principal repayment date from "1" – "31."  When the principal repayment is made on closing date, enter "31."  
• Principal repayment interval
  Enter the principal repayment interval from "1" – "12" indicating every how many months  the repayment is made. 
• First coupon payment date
  Enter the first payment date for interests. 
• Coupon payment date
  Enter the coupon payment date from "1" – "31."  When the coupon payment is made on closing date, enter "31."
• Coupon payment interval
  Enter the coupon payment interval from "1" – "12" indicating each how many months the coupon payment is made.  

Spread in [Borrowings condition]

• Interest change date
  Interest change date on the first row is the same date as "Borrowings date."  No change can be made. 
• Interest type
  Select the interest type from "Floating rate" or "Fixed rate." 
• Interest rate
  Enter the yearly interest rate. 
• Memo
  Use the space for memo.  The maximum entry is 50 one-byte characters in text format. 
• Use
  When the repayment data is already committed with calculated payment interest, using the specified interest (in [Repayment commit entry]), the checkbox is ON.  On the items of which checkboxes are ON, none of the fields can be changed except the memo. 

Spread on top of [Repayment schedule]

Clicking the "Execute" button executes auto-calculation of repayment schedule data for the period until the repayment is completed, displaying the calculation results on the spread. 
When "Others" is selected in "Repayment method," interest calculation is not performed. 

• Borrowings date
  The borrowings date entered on the [Borrowing] tab is displayed.  The entry data cannot be changed.   
• Currency
  The currency of borrowings entered on the [Borrowing] tab is displayed.  The entry data cannot be changed.    
• Borrowings Amt
  The borrowings amount entered on the [Borrowing] tab is displayed.  The entry data cannot be changed.   
• Borrowings balance
• The current borrowings balance is displayed. 
  The entry data cannot be changed.
• Expiration date
  The expiration date entered on the [Borrowing] tab is displayed.  The entry data cannot be changed.   

Spread at the bottom of [Repayment schedule]

• Recalculation
  The item recalculates value of the row selected with the cursor.   
• Scheduled repayment date
  Scheduled repayment date that is based on the entry items in [Borrowings condition] of the [Repayment] tab is displayed.  The entry data can be changed. 
• T/F date
  Enter the T/F date of payment amount. 
• The entry data can be changed. 
• Payment Amt
  Total amount of principal repayment Amt with payment interest is displayed. 
  The entry data cannot be changed. 
• Principal repayment Amt
  Principal repayment amount is displayed. 
  The entry data can be changed. 
• Payment interest
  Payment interest is displayed. 
  The entry data can be changed.   
• Borrowings balance
  The amount of the borrowings balance on the previous repayment subtracted by "Principal repayment Amt" on this payment. 
• The entry data cannot be changed.   
• Daily/Monthly payment
  Select "Daily pay" or "Monthly pay." 
• Days/Months
  When "Daily/Monthly payment" is set to "Daily pay" and "Monthly pay," the number of days and months is displayed, respectively. 
  The entry data can be changed. 
• Repaid
  A checkbox of the row (repayment data) for which payment has been made in [Debts control module] is ON. 
  The entry data cannot be changed. 
  When "Prepaid" is selected in "Coupon payment" on the [Borrowing] tab, a checkbox on the row of the first installment will be ON upon saving.   

[Buttons]

• Add row ("Borrowings condition")
• Del row ("Borrowings condition")
• Bulk Recalc ("Repayment schedule")
  Clicking this button recalculates in batch values on each row in the spread at the bottom of [Repayment schedule]. 
• Execute ("Repayment schedule")
  Clicking this button after entering [Main item], repayment schedule data will automatically be calculated for the period until the repayment is completed, displaying the calculation results on the spread of [Repayment schedule].  If you click "Execute" button once repayment schedule is created, the [Refresh repayment schedule] screen will appear. 
• Add row ("Repayment schedule")
• Clear ("Repayment schedule")
• Del row ("Repayment schedule")
• Copy
• Read pattern
• Register pattern
  Specific items can be patternized: 

  Tab	Patternized items
  [Borrowing] tab	The items except "Borrowings date," "Internal No," "Borrowings No.," "Receipt date," "Expiration date," "Notes No." and "Flexible date 1, 2" are patternized.
  [Repayment] tab	The items except "Interest type," "Interest rate," "Memo," "First repayment date" and [Repayment schedule] are patternized.
  [A/C // Payment method] tab	All items are patternized.

• Save
  Click the "Save" button, and you return to the [Transfer voucher] screen.  Click the "Save" button on the displayed screen to close the screen, and you can return to the original screen. 
• Clear
• Delete
• Exit