Example: Interest Calculation 

Prerequisites

In your enterprise, payroll takes place on a monthly basis. You have created a loan for an employee with the following data:

Loan type

Building loan with payment by installments

Loan amount paid out

10,000 euro

Loan payment

January 10 of the current year

Repayment start date

May 01 of the current year

Repayment installment

300 euro each month

The following values are stored in Customizing for the loan type Building loan with repayment installment:

Debit interest

5 %

Interest calculation frequency

First period: 03

 

Interval: 03

Repayment frequency

First period: 03

 

Interval: 03

The interest for this loan is thus due in the months of March, June, September, and December.

The repayment installment for the loan type Building loan with installment repayment is also due in the months of March, June, September and December. However, the employee must only pay the first repayment installment for the loan on hand in June, as you specified May 01 as the start of repayment date. June is the first month, in which a repayment installment is due for the repayment pattern for this loan type after the start of repayment date on May 01.

Interest Calculation

Interest is calculated for each payroll period and stored in the Interest for current period wage type (/LIM). If interest is not due in the previous payroll period, it is cumulated in the Cumulated interest wage type (/LIC) until the next due date. When the interest is due, the Cumulated interest wage type (/LIC) is converted to the Interest due wage type (/LID).

In the example, the loan is paid out on January 10 of the current year. This means that only 21 days of interest accrue in this month. For the first payroll period, interest of 10,000 x 0.05 x 21 / 360 = 29.17 euro accrues (10,000 euro balance, 5% interest, 21 days interest, 360 days per year).

For the remaining periods up to the first repayment, interest of 10,000 x 0.05 x 30 / 360 = 41.67 euro accrues (10,000 euro balance, 5% interest, 30 days interest, 360 days per year).

The interest per payroll period is cumulated and due at an interval of 3 periods.

Wage Types

The following loan wage types arise for the first six payroll periods:

Period

Wage type

Wage type text

Amount

Explanation

Period 01

/LIC

Cumulated interest

29.17

 

(January)

/LIM

Interest for current period

29.17

21 days

 

/LLB

Loan balance

10,000

 
 

/LOE

External loan payment

10,000

 

Period 02

/LIC

Cumulated interest

70.84

 

(February)

/LIM

Interest for current period

41.67

 
 

/LLB

Loan balance

10,000

 

Period 03

/LID

Interest due

112.51

 

(March)

/LIM

Interest for current period

41.67

 
 

/LLB

Loan balance

10,000

 

Period 04

/LIC

Cumulated interest

41.67

 

(April)

/LIM

Interest for current period

41.67

 
 

/LLB

Loan balance

10,000

 

Period 05

/LIC

Cumulated interest

84.34

 

(May)

/LIM

Interest for current period

41.67

 
 

/LLB

Loan balance

10,000

 

Period 06

/LID

Interest due

125.01

 

(June)

/LIM

Interest for current period

41.67

 
 

/LLB

Loan balance

9,700

 
 

/LRP

Regular repayment

300