Givet

Rente %

Indbetaling

Antal år

Indtast

Indtast

Start beløb

Rente

Indsat

Slut beløb

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