[Stipe23]

Luda ptica kaže:
Kamata ti je npr. 10%

I onda covjek uzme koliko je sve skupa uplatio (58gx2,000$) i dobije 116,000$. I doda 10% (11,600) i dobije:

127,600%
A do milijuna jos fali...


Mene jedino zanima kako se racuna tocno (postoji ta jedna formula) koliko dodje 2,000$ na tih 50ak godina. Jer ako ides racunati pjeske, mislim moze se, ali imas 50 racunskih operacija!?

! [/B]

Ma to su ti dvije formule u Excelu.
Evo ti cut and paste

1 2.000,00 200,00
2 4.200,00 420,00
3 6.620,00 662,00
4 9.282,00 928,20
5 12.210,20 1.221,02
6 15.431,22 1.543,12
7 18.974,34 1.897,43
8 22.871,78 2.287,18
9 27.158,95 2.715,90
10 31.874,85 3.187,48
11 37.062,33 3.706,23
12 42.768,57 4.276,86
13 49.045,42 4.904,54
14 55.949,97 5.595,00
15 63.544,96 6.354,50
16 71.899,46 7.189,95
17 81.089,41 8.108,94
18 91.198,35 9.119,83
19 102.318,18 10.231,82
20 114.550,00 11.455,00
21 128.005,00 12.800,50
22 142.805,50 14.280,55
23 159.086,05 15.908,60
24 176.994,65 17.699,47
25 196.694,12 19.669,41
26 218.363,53 21.836,35
27 242.199,88 24.219,99
28 268.419,87 26.841,99
29 297.261,86 29.726,19
30 328.988,05 32.898,80
31 363.886,85 36.388,68
32 402.275,53 40.227,55
33 444.503,09 44.450,31
34 490.953,40 49.095,34
35 542.048,74 54.204,87
36 598.253,61 59.825,36
37 660.078,97 66.007,90
38 728.086,87 72.808,69
39 802.895,56 80.289,56
40 885.185,11 88.518,51
41 975.703,62 97.570,36
42 1.075.273,98 107.527,40
43 1.184.801,38 118.480,14
44 1.305.281,52 130.528,15
45 1.437.809,67 143.780,97
46 1.583.590,64 158.359,06
47 1.743.949,71 174.394,97
48 1.920.344,68 192.034,47
49 2.114.379,14 211.437,91
50 2.327.817,06 232.781,71



- Stipe -