{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":[" Rendement global ","Tableau rendement brut"],"read":"whole","date_system":"1900"}

{"sheet":" Rendement global ","index":0,"n_rows":51,"n_cols":15,"rows_kept":51,"merged":[[1,1,1,5],[3,3,3,5],[4,3,4,4],[6,3,6,5],[7,3,7,4],[9,3,9,5],[10,3,10,4],[21,3,21,4],[29,1,29,5],[31,3,31,5],[32,3,32,4],[35,3,35,5],[36,3,36,4],[38,3,38,5],[39,3,39,4],[50,3,50,4]]}
[]
[null,"Taux de rendement global d'une obligation"]
[]
[null,"Généralité","Valeur nominale",{"v":100,"d":"100.00"},{"$nulls":9},{"$f":"D4*D5/100","v":{"v":7,"d":"7.00"}}]
[null,null,"Taux d'intérêt",{"v":7,"d":"7.00"},null,"%"]
[]
[null,"Achat","Capital engagé",{"v":1991.8,"d":"1,991.80"},{"$nulls":9},{"$f":"D7/D8","v":99.59},"prix d'achat par titre"]
[null,null,"Nb de titres achetés",20]
[]
[null,"Vente","Capital récupéré",{"v":2102.95,"d":"2,102.95"},{"$nulls":9},{"$f":"D10/D11","v":{"v":105.1475,"d":"105.15"}},"prix de vente par titre"]
[null,null,"Nb de titres vendus",20,{"$nulls":9},{"$f":"N10-N7","v":{"v":5.55749999999999,"d":"5.56"}},"gain ou perte à la vente"]
[]
[null,"Renseignements","Nb de coupons encaissés",3,{"$nulls":9},{"$f":"N4*D13","v":{"v":21,"d":"21.00"}},"intérêt total"]
[{"$nulls":13},{"$f":"N11+N13","v":{"v":26.55749999999999,"d":"26.56"}},"gain total par obligation"]
[{"$nulls":3},"jour","mois","année","j.","m.","bissextile",null,"calculs"]
[null,null,"Date de l'achat",29,2,1996,{"$f":"IF(E16=2,IF(I16=1,IF(D16=29,30,D16),IF(D16=28,30,D16)),IF(D16=31,30,D16))","v":30},{"$f":"E16","v":2},{"$f":"IF(F16/100=INT(F16/100),IF(F16/400=INT(F16/400),1,0),IF(F16/4=INT(F16/4),1,0))","v":1}]
[null,null,"Date de la vente",28,2,2000,{"$f":"IF(E17=2,IF(I17=1,IF(D17=29,30,D17),IF(D17=28,30,D17)),IF(D17=31,30,D17))","v":28},{"$f":"IF(F17-F16>0,E17+12,E17)","v":14},{"$f":"IF(F17/100=INT(F17/100),IF(F17/400=INT(F17/400),1,0),IF(F17/4=INT(F17/4),1,0))","v":1},null,"nb j.",{"$f":"30-G16+G17","v":28}]
[{"$nulls":10},"nb m.",{"$f":"(H17-H16-1)*30","v":330}]
[{"$nulls":10},"nb a.",{"$f":"IF(F17-F16>1,(F17-F16-1)*360,0)","v":1080}]
[null,null,"Durée du placement",{"$f":"L20","v":1438},"jours",{"$nulls":3},"total :",null,null,{"$f":"SUM(L17:L19)","v":1438}]
[]
[null,"Taux de rendement brut",null,{"$f":"(N14*36000)/(N7*D20)","v":{"v":6.675980700287029,"d":"6.676"}},null,"%"]
[]
[]
[null,"*  Capital engagé  compte tenu de l'intérêt couru et des frais"]
[]
[]
[]
[]
[null,"Taux de rendement global d'une action"]
[]
[null,"Généralité","Valeur nominale ",{"v":500,"d":"500.00"}]
[null,null,"Total des dividendes encaissés",{"v":145,"d":"145.00"},null,"Fr.",{"$nulls":7},{"$f":"D33","v":{"v":145,"d":"145.00"}},"dividendes"]
[null,null,"                                     par action"]
[]
[null,"Achat","Capital engagé",{"v":23164.45,"d":"23,164.45"},{"$nulls":9},{"$f":"D36/D37","v":{"v":926.578,"d":"926.58"}},"prix d'achat par titre"]
[null,null,"Nb de titres achetés",25]
[]
[null,"Vente","Capital récupéré",{"v":28296.1,"d":"28,296.10"},{"$nulls":9},{"$f":"D39/D40","v":{"v":1131.844,"d":"1131.84"}},"prix de vente par titre"]
[null,null,"Nb de titres vendus",25,{"$nulls":9},{"$f":"N39-N36","v":{"v":205.26600000000008,"d":"205.27"}},"gain ou perte à la vente"]
[]
[{"$nulls":3},3]
[]
[null,"Renseignements",null,"jour","mois","année","j.","m.","bissextile",null,"calculs",null,null,{"$f":"N40+N33","v":{"v":350.2660000000001,"d":"350.27"}},"Résultat"]
[null,null,"Date de l'achat",1,2,1991,{"$f":"IF(E45=2,IF(I45=1,IF(D45=29,30,D45),IF(D45=28,30,D45)),IF(D45=31,30,D45))","v":1},{"$f":"E45","v":2},{"$f":"IF(F45/100=INT(F45/100),IF(F45/400=INT(F45/400),0,1),IF(F45/4=INT(F45/4),1,0))","v":0}]
[null,null,"Date de la vente",1,6,1993,{"$f":"IF(E46=2,IF(I46=1,IF(D46=29,30,D46),IF(D46=28,30,D46)),IF(D46=31,30,D46))","v":1},{"$f":"IF(F46-F45>0,E46+12,E46)","v":18},{"$f":"IF(F46/100=INT(F46/100),IF(F46/400=INT(F46/400),0,1),IF(F46/4=INT(F46/4),1,0))","v":0},null,"nb j.",{"$f":"30-G45+G46","v":30}]
[{"$nulls":10},"nb m.",{"$f":"(H46-H45-1)*30","v":450}]
[{"$nulls":10},"nb a.",{"$f":"IF(F46-F45>1,(F46-F45-1)*360,0)","v":360}]
[null,null,"Durée du placement",{"$f":"L49","v":840},"jours",{"$nulls":3},"total :",null,null,{"$f":"SUM(L46:L48)","v":840}]
[]
[null,"Taux de rendement brut",null,{"$f":"(N44*36000)/(N36*D49)","v":{"v":16.200902676299243,"d":"16.201"}},null,"%"]

{"sheet":"Tableau rendement brut","index":1,"n_rows":26,"n_cols":12,"rows_kept":26,"merged":[[1,2,1,11]]}
["Borboën E10 p. 105"]
[null,null,"Tableau de rendement brut des obligations"]
[]
[null," cours \\ taux",4,4.5,5,5.5,6,6.5,7,7.5,8,8.5]
[null,95,{"$f":"C$4/$B5*100","v":{"v":4.2105263157894735,"d":"4.21"}},{"v":4.736842105263158,"d":"4.74"},{"v":5.263157894736842,"d":"5.26"},{"v":5.7894736842105265,"d":"5.79"},{"v":6.315789473684211,"d":"6.32"},{"v":6.842105263157896,"d":"6.84"},{"v":7.368421052631578,"d":"7.37"},{"v":7.894736842105263,"d":"7.89"},{"v":8.421052631578947,"d":"8.42"},{"v":8.947368421052632,"d":"8.95"}]
[null,96,{"v":4.166666666666666,"d":"4.17"},{"v":4.6875,"d":"4.69"},{"v":5.208333333333334,"d":"5.21"},{"v":5.729166666666666,"d":"5.73"},6.25,{"v":6.770833333333333,"d":"6.77"},{"v":7.291666666666667,"d":"7.29"},{"v":7.8125,"d":"7.81"},{"v":8.333333333333332,"d":"8.33"},{"v":8.854166666666668,"d":"8.85"}]
[null,97,{"v":4.123711340206185,"d":"4.12"},{"v":4.639175257731959,"d":"4.64"},{"v":5.154639175257731,"d":"5.15"},{"v":5.670103092783505,"d":"5.67"},{"v":6.185567010309279,"d":"6.19"},{"v":6.701030927835052,"d":"6.70"},{"v":7.216494845360824,"d":"7.22"},{"v":7.731958762886598,"d":"7.73"},{"v":8.24742268041237,"d":"8.25"},{"v":8.762886597938143,"d":"8.76"}]
[null,98,{"v":4.081632653061225,"d":"4.08"},{"v":4.591836734693878,"d":"4.59"},{"v":5.1020408163265305,"d":"5.10"},{"v":5.612244897959184,"d":"5.61"},{"v":6.122448979591836,"d":"6.12"},{"v":6.63265306122449,"d":"6.63"},{"v":7.142857142857142,"d":"7.14"},{"v":7.653061224489796,"d":"7.65"},{"v":8.16326530612245,"d":"8.16"},{"v":8.673469387755102,"d":"8.67"}]
[null,99,{"v":4.040404040404041,"d":"4.04"},{"v":4.545454545454546,"d":"4.55"},{"v":5.05050505050505,"d":"5.05"},{"v":5.555555555555555,"d":"5.56"},{"v":6.0606060606060606,"d":"6.06"},{"v":6.565656565656567,"d":"6.57"},{"v":7.07070707070707,"d":"7.07"},{"v":7.575757575757576,"d":"7.58"},{"v":8.080808080808081,"d":"8.08"},{"v":8.585858585858585,"d":"8.59"}]
[null,100,{"v":4,"d":"4.00"},{"v":4.5,"d":"4.50"},{"v":5,"d":"5.00"},{"v":5.5,"d":"5.50"},{"v":6,"d":"6.00"},{"v":6.5,"d":"6.50"},{"v":7.000000000000001,"d":"7.00"},{"v":7.5,"d":"7.50"},{"v":8,"d":"8.00"},{"v":8.5,"d":"8.50"}]
[null,101,{"v":3.9603960396039604,"d":"3.96"},{"v":4.455445544554455,"d":"4.46"},{"v":4.9504950495049505,"d":"4.95"},{"v":5.445544554455446,"d":"5.45"},{"v":5.9405940594059405,"d":"5.94"},{"v":6.435643564356436,"d":"6.44"},{"v":6.9306930693069315,"d":"6.93"},{"v":7.425742574257425,"d":"7.43"},{"v":7.920792079207921,"d":"7.92"},{"v":8.415841584158416,"d":"8.42"}]
[null,102,{"v":3.9215686274509802,"d":"3.92"},{"v":4.411764705882353,"d":"4.41"},{"v":4.901960784313726,"d":"4.90"},{"v":5.392156862745098,"d":"5.39"},{"v":5.88235294117647,"d":"5.88"},{"v":6.372549019607843,"d":"6.37"},{"v":6.862745098039216,"d":"6.86"},{"v":7.352941176470589,"d":"7.35"},{"v":7.8431372549019605,"d":"7.84"},{"v":8.333333333333332,"d":"8.33"}]
[null,103,{"v":3.8834951456310676,"d":"3.88"},{"v":4.368932038834951,"d":"4.37"},{"v":4.854368932038835,"d":"4.85"},{"v":5.339805825242718,"d":"5.34"},{"v":5.825242718446602,"d":"5.83"},{"v":6.310679611650485,"d":"6.31"},{"v":6.796116504854369,"d":"6.80"},{"v":7.281553398058252,"d":"7.28"},{"v":7.766990291262135,"d":"7.77"},{"v":8.25242718446602,"d":"8.25"}]
[null,104,{"v":3.8461538461538463,"d":"3.85"},{"v":4.326923076923077,"d":"4.33"},{"v":4.807692307692308,"d":"4.81"},{"v":5.288461538461538,"d":"5.29"},{"v":5.769230769230769,"d":"5.77"},6.25,{"v":6.730769230769231,"d":"6.73"},{"v":7.211538461538461,"d":"7.21"},{"v":7.6923076923076925,"d":"7.69"},{"v":8.173076923076923,"d":"8.17"}]
[null,105,{"v":3.8095238095238098,"d":"3.81"},{"v":4.285714285714286,"d":"4.29"},{"v":4.761904761904762,"d":"4.76"},{"v":5.238095238095238,"d":"5.24"},{"v":5.714285714285714,"d":"5.71"},{"v":6.190476190476191,"d":"6.19"},{"v":6.666666666666667,"d":"6.67"},{"v":7.142857142857142,"d":"7.14"},{"v":7.6190476190476195,"d":"7.62"},{"v":8.095238095238095,"d":"8.10"}]
[null,106,{"v":3.7735849056603774,"d":"3.77"},{"v":4.245283018867925,"d":"4.25"},{"v":4.716981132075472,"d":"4.72"},{"v":5.188679245283019,"d":"5.19"},{"v":5.660377358490567,"d":"5.66"},{"v":6.132075471698113,"d":"6.13"},{"v":6.60377358490566,"d":"6.60"},{"v":7.0754716981132075,"d":"7.08"},{"v":7.547169811320755,"d":"7.55"},{"v":8.018867924528301,"d":"8.02"}]
[null,107,{"v":3.7383177570093453,"d":"3.74"},{"v":4.205607476635514,"d":"4.21"},{"v":4.672897196261682,"d":"4.67"},{"v":5.14018691588785,"d":"5.14"},{"v":5.607476635514018,"d":"5.61"},{"v":6.074766355140187,"d":"6.07"},{"v":6.5420560747663545,"d":"6.54"},{"v":7.009345794392523,"d":"7.01"},{"v":7.476635514018691,"d":"7.48"},{"v":7.943925233644859,"d":"7.94"}]
[null,108,{"v":3.7037037037037033,"d":"3.70"},{"v":4.166666666666666,"d":"4.17"},{"v":4.62962962962963,"d":"4.63"},{"v":5.092592592592593,"d":"5.09"},{"v":5.555555555555555,"d":"5.56"},{"v":6.018518518518518,"d":"6.02"},{"v":6.481481481481481,"d":"6.48"},{"v":6.944444444444445,"d":"6.94"},{"v":7.4074074074074066,"d":"7.41"},{"v":7.87037037037037,"d":"7.87"}]
[null,109,{"v":3.669724770642202,"d":"3.67"},{"v":4.128440366972478,"d":"4.13"},{"v":4.587155963302752,"d":"4.59"},{"v":5.045871559633028,"d":"5.05"},{"v":5.5045871559633035,"d":"5.50"},{"v":5.963302752293578,"d":"5.96"},{"v":6.422018348623854,"d":"6.42"},{"v":6.8807339449541285,"d":"6.88"},{"v":7.339449541284404,"d":"7.34"},{"v":7.79816513761468,"d":"7.80"}]
[null,110,{"v":3.6363636363636362,"d":"3.64"},{"v":4.090909090909091,"d":"4.09"},{"v":4.545454545454546,"d":"4.55"},{"v":5,"d":"5.00"},{"v":5.454545454545454,"d":"5.45"},{"v":5.909090909090909,"d":"5.91"},{"v":6.363636363636363,"d":"6.36"},{"v":6.8181818181818175,"d":"6.82"},{"v":7.2727272727272725,"d":"7.27"},{"v":7.727272727272727,"d":"7.73"}]
[]
[null,"Autres données :"]
[]
[null,"cours en % :",75]
[null,"taux   en % :",3]
[null,"Rendement :",{"$f":"C25*100/C24","v":{"v":4,"d":"4.00"}},"%"]