| A | B | C | D | E | F | G | H | 6 | | Kredit | Jahreszins | Monatszins | Tilgung | Sparen | Jahreszins | eff. Zins | 7 | | | | | | | | | 8 | 1. | 40.763,88 | 2.370,83 | 197,57 | 170,56 | 9.626,63 | 216,60 | 18,05 | 9 | 2. | 40.607,66 | 2.361,74 | 196,81 | 171,32 | 10.201,63 | 229,54 | 19,13 | 10 | 3. | 40.436,34 | 2.351,78 | 195,98 | 172,15 | 10.834,01 | 242,47 | 20,21 | 11 | 4. | 40.264,19 | 2.341,77 | 195,15 | 172,98 | 11.351,63 | 283,79 | 23,65 | 12 | 5. | 40.091,21 | 2.331,70 | 194,31 | 173,82 | 11.926,63 | 298,17 | 24,85 | 13 | 6. | 39.915,23 | 2.321,47 | 193,46 | 174,67 | 12.576,17 | 312,54 | 26,05 | 14 | 7. | 39.740,55 | 2.311,31 | 192,61 | 175,52 | 13.076,63 | 326,92 | 27,24 | 15 | 8. | 39.565,03 | 2.301,10 | 191,76 | 176,37 | 13.651,63 | 341,29 | 28,44 | 16 | 9. | 39.388,66 | 2.290,84 | 190,90 | 177,23 | 14.313,73 | 377,01 | 31,42 | 17 | 10. | 39.211,44 | 2.280,54 | 190,04 | 178,09 | 14.801,63 | 392,24 | 32,69 | 18 | 11. | 39.033,35 | 2.270,18 | 189,18 | 178,95 | 15.651,63 | 414,77 | 34,56 | 19 | 12. (Dez. 2006) | 38.486,27 | 2.238,36 | 186,53 | 181,60 | 16.605,32 | 437,29 | 36,44 | 20 | 1. | 30.304,67 | 1.762,52 | 146,88 | 221,25 | 9.651,63 | 255,77 | 21,31 | 21 | 2. | 30.083,42 | 1.749,65 | 145,80 | 222,33 | 10.601,63 | 280,94 | 23,41 | 22 | 3. | 29.861,09 | 1.736,72 | 144,73 | 223,40 | 11.625,24 | 346,55 | 28,88 | 23 | 4. | 29.637,69 | 1.723,73 | 143,64 | 224,49 | 12.501,63 | 375,05 | 31,25 | 24 | 5. | 29.413,20 | 1.710,67 | 142,56 | 225,57 | 13.451,63 | 403,55 | 33,63 | Formeln der Tabelle | C8 : =SUMME(B8)*0,05816
D8 : =SUMME(C8)/12
E8 : =368,13-D8
G8 : =F8*0,0225
H8 : =G8/12
C9 : =SUMME(B9)*0,05816
D9 : =SUMME(C9)/12
E9 : =368,13-D9
F9 : =SUMME($F$8)+575*ZEILE(A1)
G9 : =($F$8+575*ZEILE(A1))*0,0225
H9 : =G9/12
B10 : =SUMME(B9)-E9
C10 : =SUMME(B10)*0,05816
D10 : =SUMME(C10)/12
E10 : =368,13-D10
F10 : =SUMME($F$8)+575*ZEILE(A2)+SUMME(H8:H10)
G10 : =($F$8+575*ZEILE(A2))*0,0225
H10 : =G10/12
B11 : =SUMME(B10)-E10
C11 : =SUMME(B11)*0,05816
D11 : =SUMME(C11)/12
E11 : =368,13-D11
F11 : =SUMME($F$8)+575*ZEILE(A3)
G11 : =($F$8+575*ZEILE(A3))*0,025
H11 : =G11/12
B12 : =SUMME(B11)-E11
C12 : =SUMME(B12)*0,05816
D12 : =SUMME(C12)/12
E12 : =368,13-D12
F12 : =SUMME($F$8)+575*ZEILE(A4)
G12 : =($F$8+575*ZEILE(A4))*0,025
H12 : =G12/12
B13 : =SUMME(B12)-E12-2,16
C13 : =SUMME(B13)*0,05816
D13 : =SUMME(C13)/12
E13 : =368,13-D13
F13 : =SUMME($F$8)+575*ZEILE(A5)+SUMME(H11:H13)
G13 : =($F$8+575*ZEILE(A5))*0,025
H13 : =G13/12
B14 : =SUMME(B13)-E13
C14 : =SUMME(B14)*0,05816
D14 : =SUMME(C14)/12
E14 : =368,13-D14
F14 : =SUMME($F$8)+575*ZEILE(A6)
G14 : =($F$8+575*ZEILE(A6))*0,025
H14 : =G14/12
B15 : =SUMME(B14)-E14
C15 : =SUMME(B15)*0,05816
D15 : =SUMME(C15)/12
E15 : =368,13-D15
F15 : =SUMME($F$8)+575*ZEILE(A7)
G15 : =($F$8+575*ZEILE(A7))*0,025
H15 : =G15/12
B16 : =SUMME(B15)-E15
C16 : =SUMME(B16)*0,05816
D16 : =SUMME(C16)/12
E16 : =368,13-D16
F16 : =SUMME($F$8)+575*ZEILE(A8)+SUMME(H14:H16)
G16 : =($F$8+575*ZEILE(A8))*0,0265
H16 : =G16/12
B17 : =SUMME(B16)-E16
C17 : =SUMME(B17)*0,05816
D17 : =SUMME(C17)/12
E17 : =368,13-D17
F17 : =SUMME($F$8)+575*ZEILE(A9)
G17 : =($F$8+575*ZEILE(A9))*0,0265
H17 : =G17/12
B18 : =SUMME(B17)-E17
C18 : =SUMME(B18)*0,05816
D18 : =SUMME(C18)/12
E18 : =368,13-D18
F18 : =SUMME($F$17)+850*ZEILE(B1)
G18 : =($F$17+850*ZEILE(B1))*0,0265
H18 : =G18/12
B19 : =SUMME(B18)-E18-368,13
C19 : =SUMME(B19)*0,05816
D19 : =SUMME(C19)/12
E19 : =368,13-D19
F19 : =SUMME($F$17)+850*ZEILE(B2)+SUMME(H17:H19)
G19 : =($F$17+850*ZEILE(B2))*0,0265
H19 : =G19/12
B20 : =SUMME(B19)-E19-8000
C20 : =SUMME(B20)*0,05816
D20 : =SUMME(C20)/12
E20 : =368,13-D20
F20 : =SUMME($F$17-8000)+950*ZEILE(B3)
G20 : =($F$17-8000+950*ZEILE(B3))*0,0265
H20 : =G20/12
B21 : =SUMME(B20)-E20
C21 : =SUMME(B21)*0,05816
D21 : =SUMME(C21)/12
E21 : =368,13-D21
F21 : =SUMME($F$17-8000)+950*ZEILE(B4)
G21 : =($F$17-8000+950*ZEILE(B4))*0,0265
H21 : =G21/12
B22 : =SUMME(B21)-E21
C22 : =SUMME(B22)*0,05816
D22 : =SUMME(C22)/12
E22 : =368,13-D22
F22 : =SUMME($F$17-8000)+950*ZEILE(B5)+SUMME(H20:H22)
G22 : =($F$17-8000+950*ZEILE(B5))*0,03
H22 : =G22/12
B23 : =SUMME(B22)-E22
C23 : =SUMME(B23)*0,05816
D23 : =SUMME(C23)/12
E23 : =368,13-D23
F23 : =SUMME($F$17-8000)+950*ZEILE(B6)
G23 : =($F$17-8000+950*ZEILE(B6))*0,03
H23 : =G23/12
B24 : =SUMME(B23)-E23
C24 : =SUMME(B24)*0,05816
D24 : =SUMME(C24)/12
E24 : =368,13-D24
F24 : =SUMME($F$17-8000)+950*ZEILE(B7)
G24 : =($F$17-8000+950*ZEILE(B7))*0,03
H24 : =G24/12
|
|