Kreditbetrag

Zinssatz in %

Annuität

n

Zinsanteil

Tilgungsanteil

Annuität

Restschuld

B3: 8000
B1: 50000
E6: $B$1
B2: 10
D7 = If(E6 < $B$3, (E6 * (1 + B$2 / 100)), B$3)
B7: (E6 * $B$2 / 100)
C7: D7 - B7
E7: E6 - C7
B8: (E7 * $B$2 / 100)
D8 = If(E7 < $B$3, (E7 * (1 + B$2 / 100)), B$3)
C8: D8 - B8
E8: E7 - C8
D9 = If(E8 < $B$3, (E8 * (1 + B$2 / 100)), B$3)
B9: (E8 * $B$2 / 100)
C9: D9 - B9
E9: E8 - C9
B10: (E9 * $B$2 / 100)
D10 = If(E9 < $B$3, (E9 * (1 + B$2 / 100)), B$3)
C10: D10 - B10
E10: E9 - C10
D11 = If(E10 < $B$3, (E10 * (1 + B$2 / 100)), B$3)
B11: (E10 * $B$2 / 100)
C11: D11 - B11
E11: E10 - C11
B12: (E11 * $B$2 / 100)
D12 = If(E11 < $B$3, (E11 * (1 + B$2 / 100)), B$3)
C12: D12 - B12
E12: E11 - C12
D13 = If(E12 < $B$3, (E12 * (1 + B$2 / 100)), B$3)
B13: (E12 * $B$2 / 100)
C13: D13 - B13
E13: E12 - C13
B14: (E13 * $B$2 / 100)
D14 = If(E13 < $B$3, (E13 * (1 + B$2 / 100)), B$3)
C14: D14 - B14
E14: E13 - C14
D15 = If(E14 < $B$3, (E14 * (1 + B$2 / 100)), B$3)
B15: (E14 * $B$2 / 100)
C15: D15 - B15
E15: E14 - C15
B16: (E15 * $B$2 / 100)
D16 = If(E15 < $B$3, (E15 * (1 + B$2 / 100)), B$3)
C16: D16 - B16
E16: E15 - C16
B17: (E16 * $B$2 / 100)
D17 = If(E16 < $B$3, (E16 * (1 + B$2 / 100)), B$3)
C17: D17 - B17
E17: E16 - C17
D18 = If(E17 < $B$3, (E17 * (1 + B$2 / 100)), B$3)
B18: (E17 * $B$2 / 100)
C18: D18 - B18
E18: E17 - C18
B19: (E18 * $B$2 / 100)
D19 = If(E18 < $B$3, (E18 * (1 + B$2 / 100)), B$3)
C19: D19 - B19
E19: E18 - C19
D20 = If(E19 < $B$3, (E19 * (1 + B$2 / 100)), B$3)
B20: (E19 * $B$2 / 100)
C20: D20 - B20
E20: E19 - C20
D21 = If(E20 < $B$3, (E20 * (1 + B$2 / 100)), B$3)
B21: (E20 * $B$2 / 100)
C21: D21 - B21
E21: E20 - C21
B22: (E21 * $B$2 / 100)
D22 = If(E21 < $B$3, (E21 * (1 + B$2 / 100)), B$3)
C22: D22 - B22
E22: E21 - C22
D23 = If(E22 < $B$3, (E22 * (1 + B$2 / 100)), B$3)
B23: (E22 * $B$2 / 100)
C23: D23 - B23
E23: E22 - C23
B24: (E23 * $B$2 / 100)
D24 = If(E23 < $B$3, (E23 * (1 + B$2 / 100)), B$3)
C24: D24 - B24
E24: E23 - C24
D25 = If(E24 < $B$3, (E24 * (1 + B$2 / 100)), B$3)
B25: (E24 * $B$2 / 100)
C25: D25 - B25
E25: E24 - C25
B26: (E25 * $B$2 / 100)
A7 = 1
A8 = 2
A9: (2 * A8) - A7
A10: (2 * A9) - A8
A11: (2 * A10) - A9
A12: (2 * A11) - A10
A13: (2 * A12) - A11
A14: (2 * A13) - A12
A15: (2 * A14) - A13
A16: (2 * A15) - A14
A17: (2 * A16) - A15
A18: (2 * A17) - A16
A19: (2 * A18) - A17
A20: (2 * A19) - A18
A21: (2 * A20) - A19
A22: (2 * A21) - A20
A23: (2 * A22) - A21
A24: (2 * A23) - A22
A25: (2 * A24) - A23
D26 = If(E25 < $B$3, (E25 * (1 + B$2 / 100)), B$3)
C26: D26 - B26
A26: (2 * A25) - A24
A6: 0
Summe[D6:D25] = If(B26 + C26 < $B$3, B26 + C26, $B$3)
Balkendiagramm = BarChart(A6:A26, E6:E26)
E26: E25 - C26