Zukunftsvorsorge

Jahr

Guthaben

Rate:

Zinssatz:

Jährliche Rate:

Zinssatz (%):

A2 = 1
D1 = 300 (slider from 0 to 500, step 50)
D2 = 2.5 (slider from 0 to 5, step 0.1)
B2: D1 * (1.0 + D2 / 100.0)
A3: A2 + 1.0
B3: (B2 + $D$1) * (1.0 + $D$2 / 100.0)
A4: A3 + 1.0
B4: (B3 + $D$1) * (1.0 + $D$2 / 100.0)
A5: A4 + 1.0
B5: (B4 + $D$1) * (1.0 + $D$2 / 100.0)
A6: A5 + 1.0
B6: (B5 + $D$1) * (1.0 + $D$2 / 100.0)
A7: A6 + 1.0
B7: (B6 + $D$1) * (1.0 + $D$2 / 100.0)
A8: A7 + 1.0
B8: (B7 + $D$1) * (1.0 + $D$2 / 100.0)
A9: A8 + 1.0
B9: (B8 + $D$1) * (1.0 + $D$2 / 100.0)
A10: A9 + 1.0
B10: (B9 + $D$1) * (1.0 + $D$2 / 100.0)
A11: A10 + 1.0
B11: (B10 + $D$1) * (1.0 + $D$2 / 100.0)
A12: A11 + 1.0
B12: (B11 + $D$1) * (1.0 + $D$2 / 100.0)
A13: A12 + 1.0
B13: (B12 + $D$1) * (1.0 + $D$2 / 100.0)
A14: A13 + 1.0
B14: (B13 + $D$1) * (1.0 + $D$2 / 100.0)
A15: A14 + 1.0
B15: (B14 + $D$1) * (1.0 + $D$2 / 100.0)
A16: A15 + 1.0
B16: (B15 + $D$1) * (1.0 + $D$2 / 100.0)
A17: A16 + 1.0
B17: (B16 + $D$1) * (1.0 + $D$2 / 100.0)
A18: A17 + 1.0
B18: (B17 + $D$1) * (1.0 + $D$2 / 100.0)
A19: A18 + 1.0
B19: (B18 + $D$1) * (1.0 + $D$2 / 100.0)
A20: A19 + 1.0
B20: (B19 + $D$1) * (1.0 + $D$2 / 100.0)
A21: A20 + 1.0
B21: (B20 + $D$1) * (1.0 + $D$2 / 100.0)
A22: A21 + 1.0
B22: (B21 + $D$1) * (1.0 + $D$2 / 100.0)
A23: A22 + 1.0
B23: (B22 + $D$1) * (1.0 + $D$2 / 100.0)
A24: A23 + 1.0
B24: (B23 + $D$1) * (1.0 + $D$2 / 100.0)
A25: A24 + 1.0
B25: (B24 + $D$1) * (1.0 + $D$2 / 100.0)
A26: A25 + 1.0
B26: (B25 + $D$1) * (1.0 + $D$2 / 100.0)
A27: A26 + 1.0
B27: (B26 + $D$1) * (1.0 + $D$2 / 100.0)
A28: A27 + 1.0
B28: (B27 + $D$1) * (1.0 + $D$2 / 100.0)
A29: A28 + 1.0
B29: (B28 + $D$1) * (1.0 + $D$2 / 100.0)
A30: A29 + 1.0
B30: (B29 + $D$1) * (1.0 + $D$2 / 100.0)
A31: A30 + 1.0
B31: (B30 + $D$1) * (1.0 + $D$2 / 100.0)
A32: A31 + 1.0
B32: (B31 + $D$1) * (1.0 + $D$2 / 100.0)
A33: A32 + 1.0
B33: (B32 + $D$1) * (1.0 + $D$2 / 100.0)
A34: A33 + 1.0
B34: (B33 + $D$1) * (1.0 + $D$2 / 100.0)
A35: A34 + 1.0
B35: (B34 + $D$1) * (1.0 + $D$2 / 100.0)
A36: A35 + 1.0
B36: (B35 + $D$1) * (1.0 + $D$2 / 100.0)
A37: A36 + 1.0
B37: (B36 + $D$1) * (1.0 + $D$2 / 100.0)
A38: A37 + 1.0
B38: (B37 + $D$1) * (1.0 + $D$2 / 100.0)
A39: A38 + 1.0
B39: (B38 + $D$1) * (1.0 + $D$2 / 100.0)
A40: A39 + 1.0
B40: (B39 + $D$1) * (1.0 + $D$2 / 100.0)
A41: A40 + 1.0
B41: (B40 + $D$1) * (1.0 + $D$2 / 100.0)
A42: A41 + 1.0
B42: (B41 + $D$1) * (1.0 + $D$2 / 100.0)
A43: A42 + 1.0
B43: (B42 + $D$1) * (1.0 + $D$2 / 100.0)
A44: A43 + 1.0
B44: (B43 + $D$1) * (1.0 + $D$2 / 100.0)
A45: A44 + 1.0
B45: (B44 + $D$1) * (1.0 + $D$2 / 100.0)
A46: A45 + 1.0
B46: (B45 + $D$1) * (1.0 + $D$2 / 100.0)
A47: A46 + 1.0
B47: (B46 + $D$1) * (1.0 + $D$2 / 100.0)
A48: A47 + 1.0
B48: (B47 + $D$1) * (1.0 + $D$2 / 100.0)
A49: A48 + 1.0
B49: (B48 + $D$1) * (1.0 + $D$2 / 100.0)
A50: A49 + 1.0
B50: (B49 + $D$1) * (1.0 + $D$2 / 100.0)
A51: A50 + 1.0
B51: (B50 + $D$1) * (1.0 + $D$2 / 100.0)
P_1: (A2, B2)
P_2: (A3, B3)
P_3: (A4, B4)
P_4: (A5, B5)
P_5: (A6, B6)
P_6: (A7, B7)
P_7: (A8, B8)
P_8: (A9, B9)
P_9: (A10, B10)
P_{10}: (A11, B11)
P_{11}: (A12, B12)
P_{12}: (A13, B13)
P_{13}: (A14, B14)
P_{14}: (A15, B15)
P_{15}: (A16, B16)
P_{16}: (A17, B17)
P_{17}: (A18, B18)
P_{18}: (A19, B19)
P_{19}: (A20, B20)
P_{20}: (A21, B21)
P_{21}: (A22, B22)
P_{22}: (A23, B23)
P_{23}: (A24, B24)
P_{24}: (A25, B25)
P_{25}: (A26, B26)
P_{26}: (A27, B27)
P_{27}: (A28, B28)
P_{28}: (A29, B29)
P_{29}: (A30, B30)
P_{30}: (A31, B31)
P_{31}: (A32, B32)
P_{32}: (A33, B33)
P_{33}: (A34, B34)
P_{34}: (A35, B35)
P_{35}: (A36, B36)
P_{36}: (A37, B37)
P_{37}: (A38, B38)
P_{38}: (A39, B39)
P_{39}: (A40, B40)
P_{40}: (A41, B41)
P_{41}: (A42, B42)
P_{42}: (A43, B43)
P_{43}: (A44, B44)
P_{44}: (A45, B45)
P_{45}: (A46, B46)
P_{46}: (A47, B47)
P_{47}: (A48, B48)
P_{48}: (A49, B49)
P_{49}: (A50, B50)
P_{50}: (A51, B51)
Liste1: {P_1, P_2, P_3, P_4, P_5, P_6, P_7, P_8, P_9, P_{10}, P_{11}, P_{12}, P_{13}, P_{14}, P_{15}, P_{16}, P_{17}, P_{18}, P_{19}, P_{20}, P_{21}, P_{22}, P_{23}, P_{24}, P_{25}, P_{26}, P_{27}, P_{28}, P_{29}, P_{30}, P_{31}, P_{32}, P_{33}, P_{34}, P_{35}, P_{36}, P_{37}, P_{38}, P_{39}, P_{40}, P_{41}, P_{42}, P_{43}, P_{44}, P_{45}, P_{46}, P_{47}, P_{48}, P_{49}, P_{50}}
Text3: "Ertrag: " + B51 + " €"
Text4: "Summe der Einzahlungen: " + (50.0 * D1) + " €"