Example: Repayment Plan 

Prerequisites

In the SAP system, the following values are stored for an employee’s loan:

Personnel number

123456

Loan type

Building loan with annuity payment (0200)

Sequential number

06

Legacy data transfer

7,700 euro on June 01 1998

Special repayment

1,000 euro on December 24 1998

Annuity installment

450 euro monthly

Repayment start date

June 01 1998

Result

Using this information, the system creates the following repayment plan:

Repayment plan for

Personnel number 123456

Loan ID

0200 06 (Building loan with annuity repayment)

Currency

euro

Year

Period

Balance

Repayment

Interest

1998

06

7,282.08

417.92

32.08

1998

07

6,862.42

419.66

30.34

1998

08

6,441.01

421.41

28.59

1998

09

6,017.85

423.16

26.84

1998

10

5,592.92

424.93

25.07

1998

11

5,166.22

426.70

23.30

1998

12

3,737.75

428.47

21.53

1999

01

3,303.32

434.43

15.57

1999

02

2,867.08

436.08

13.76

1999

03

2,429.03

438.05

11.95

1999

04

1,989.15

439.88

10.12

1999

05

1,547.44

441.71

8.29

1999

06

1,103.89

443.55

6.45

1999

07

658.49

445.40

4.60

1999

08

211.23

447.26

2.74

1999

09

0.00

211.23

0.88

     

7,700

262.11