Calcule De La Convexite.xlsx

periode

3,63% 7A 100K ATW CF ACTUALISE T^2+t (t = periode) cf * t 1 4020 3865.282894668 2 7730.5657893359 2 4020 3716.5203621425 6 22299.1221728549 3 4020 3573.4832297201 12 42881.7987566405 4 4020 3435.9511448308 20 68719.0228966156 5 4020 3303.7122355794 30 99111.3670673824 6 4020 3176.5627843509 42 133415.636942735 7 4020 3054.3069139777 56 171041.187182749 8 4020 2936.7562859861 72 211446.452590996 9 4020 2823.7298104554 90 254135.682940982 10 104020 70253.6943382893 110 7727906.37721183 somme pm convexite

CF

8738687.21355212 108317.124830155 80.6768756764

3,69% 7A 100K ATW

3,57% 7A 100K ATW 3,32% 7A 100K ATW 3,44% 7A 100K ATW 3690 3570 3320 3440 3690 3570 3320 3440 3690 3570 3320 3440 3690 3570 3320 3440 3690 3570 3320 3440 3690 3570 3320 3440 103690 103570 103320 103440

pm 100990 100650 100290 99670 100050 98860 101060 100350 101290 100640 100140 100290 98860 101540

3,74% 10A 100K BC 4,11% 7A 100K CAM 4,10% 10A 100K CAM 4,22% 10A 100K CAM 3740 4110 4100 4220 3740 4110 4100 4220 3740 4110 4100 4220 3740 4110 4100 4220 3740 4110 4100 4220 3740 4110 4100 4220 3740 104110 4100 4220 3740 4100 4220 3740 4100 4220 103740 104100 104220

TRI 0.0347 0.0358 0.0352 0.0337 0.0343 0.0388 0.0398 0.0406 0.0406 0.0397 0.0400 0.0396 0.0388 0.0424

TIR+1 1.0347 1.0358 1.0352 1.0337 1.0343 1.0388 1.0398 1.0406 1.0406 1.0397 1.0400 1.0396 1.0388 1.0424

4,05% 10A 100K CDM 4,02% 10A 100K CIH 4,00% 10A 100K SOG 3,74% 10A 100K ATW 4050 4020 4000 3740 4050 4020 4000 3740 4050 4020 4000 3740 4050 4020 4000 3740 4050 4020 4000 3740 4050 4020 4000 3740 4050 4020 4000 3740 4050 4020 4000 3740 4050 4020 4000 3740 104050 104020 104000 103740

4,43% 10A 100K CAM 4430 4430 4430 4430 4430 4430 4430 4430 4430 104430