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 |