{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Simulateur","Données","Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Simulateur","index":0,"n_rows":28,"n_cols":17,"rows_kept":28,"cut":false,"hidden":false,"merged":[[10,1,14,1],[15,1,25,1],[1,1,1,16]]}
[]
[null,"SIMULATEUR DE TABLEAU D'AMORTISSEMENT"]
[]
[null,null,null,null,null,"Numéro d'échéance","Date","Montant de l'échéance","Montant Amortissement","Montant Intérêts","Intérêts Financiers","Intérêts à différer","Capital restant dû","Stock d'intérêts","Taux d'intérêt","Progression échéances","Taux de construction"]
[null,null,"Livret A (en %)",0.02,null,0]
[null,null,"Inflation (en %)",0.06,null,{"$f":"F5+1","v":1}]
[null,null,null,null,null,{"$f":"F6+1","v":2}]
[null,null,"Montant du prêt (en €)",null,null,3]
[null,null,"Date d'effet",null,null,4]
[null,null,null,null,null,5]
[null,"Phase de préfinancement","Durée de préfinancement (en mois)",null,null,6]
[null,null,"Date de début de préfinancement","-",null,7]
[null,null,"Date de fin de préfinancement","-",null,8]
[null,null,"Montant des intérêts de préfinancement(*) (en €)",0,null,9]
[null,null,"Gestion des intérêts de préfinancement","-",null,10]
[null,"Phase d'amortissement","Durée de la phase d'amortissement (en années)",null,null,11]
[null,null,"Durée du différé d'amortissement (en mois)",null,null,12]
[null,null,"Profil d'amortissement",null,null,13]
[null,null,"Périodicité",null,null,14]
[null,null,"Index",null,null,15]
[null,null,"Marge sur index (en %)",null,null,16]
[null,null,"Taux d'intérêt (en %)",null,null,17]
[null,null,"Taux de construction (en %)",null,null,18]
[null,null,"Modalité de révision",null,null,19]
[null,null,"Taux de progressivité des échéances (en %)",null,null,20]
[null,null,"Taux de progressivité de l'amortissement (en %)",null,null,21]
[null,"(*) calculé sur la base d'un unique versement en date de début de préfinancement ",null,null,null,22]
[null,null,null,null,null,null,"Total",{"$f":"SUM(H5:H27)","v":0},{"$f":"SUM(I5:I27)","v":0},{"$f":"SUM(J5:J27)","v":0},{"$f":"SUM(K5:K27)","v":0},{"$f":"SUM(L5:L27)","v":0}]

{"sheet":"Données","index":1,"n_rows":244,"n_cols":19,"rows_kept":244,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Gestion des intérêts de préfinancement ","Périodicité","Index","Profil d'amortissement","Modalité de révision",null,"Numéro d'échéance","Date","Montant de l'échéance","Montant Amortissement","Montant Intérêts","Intérêts Financiers","Intérêts à différer","Capital restant dû","Stock d'intérêts","Taux d'intérêt","Progression échéances","Taux de construction"]
[null,"-","Trimestrielle","Livret A","Amortissement déduit (intérêts différés)","-",null,0]
[null,"Paiement","Semestrielle","Inflation","Amortissement déduit (intérêts prioritaires)","SR",null,{"$f":"H3+1","v":1}]
[null,"Capitalisation","Annuelle","Taux fixe","Amortissement prioritaire (échéance déduite)","DR",null,{"$f":"H4+1","v":2}]
[null,null,null,null,null,"DL",null,3]
[null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,5]
[null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,7]
[null,null,null,null,null,null,null,8]
[null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,15]
[null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,31]
[null,null,null,null,null,null,null,32]
[null,null,null,null,null,null,null,33]
[null,null,null,null,null,null,null,34]
[null,null,null,null,null,null,null,35]
[null,null,null,null,null,null,null,36]
[null,null,null,null,null,null,null,37]
[null,null,null,null,null,null,null,38]
[null,null,null,null,null,null,null,39]
[null,null,null,null,null,null,null,40]
[null,null,null,null,null,null,null,41]
[null,null,null,null,null,null,null,42]
[null,null,null,null,null,null,null,43]
[null,null,null,null,null,null,null,44]
[null,null,null,null,null,null,null,45]
[null,null,null,null,null,null,null,46]
[null,null,null,null,null,null,null,47]
[null,null,null,null,null,null,null,48]
[null,null,null,null,null,null,null,49]
[null,null,null,null,null,null,null,50]
[null,null,null,null,null,null,null,51]
[null,null,null,null,null,null,null,52]
[null,null,null,null,null,null,null,53]
[null,null,null,null,null,null,null,54]
[null,null,null,null,null,null,null,55]
[null,null,null,null,null,null,null,56]
[null,null,null,null,null,null,null,57]
[null,null,null,null,null,null,null,58]
[null,null,null,null,null,null,null,59]
[null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,61]
[null,null,null,null,null,null,null,62]
[null,null,null,null,null,null,null,63]
[null,null,null,null,null,null,null,64]
[null,null,null,null,null,null,null,65]
[null,null,null,null,null,null,null,{"$f":"H68+1","v":66}]
[null,null,null,null,null,null,null,67]
[null,null,null,null,null,null,null,68]
[null,null,null,null,null,null,null,69]
[null,null,null,null,null,null,null,70]
[null,null,null,null,null,null,null,71]
[null,null,null,null,null,null,null,72]
[null,null,null,null,null,null,null,73]
[null,null,null,null,null,null,null,74]
[null,null,null,null,null,null,null,75]
[null,null,null,null,null,null,null,76]
[null,null,null,null,null,null,null,77]
[null,null,null,null,null,null,null,78]
[null,null,null,null,null,null,null,79]
[null,null,null,null,null,null,null,80]
[null,null,null,null,null,null,null,81]
[null,null,null,null,null,null,null,82]
[null,null,null,null,null,null,null,83]
[null,null,null,null,null,null,null,84]
[null,null,null,null,null,null,null,85]
[null,null,null,null,null,null,null,86]
[null,null,null,null,null,null,null,87]
[null,null,null,null,null,null,null,88]
[null,null,null,null,null,null,null,89]
[null,null,null,null,null,null,null,90]
[null,null,null,null,null,null,null,91]
[null,null,null,null,null,null,null,92]
[null,null,null,null,null,null,null,93]
[null,null,null,null,null,null,null,94]
[null,null,null,null,null,null,null,95]
[null,null,null,null,null,null,null,96]
[null,null,null,null,null,null,null,97]
[null,null,null,null,null,null,null,98]
[null,null,null,null,null,null,null,99]
[null,null,null,null,null,null,null,100]
[null,null,null,null,null,null,null,101]
[null,null,null,null,null,null,null,102]
[null,null,null,null,null,null,null,103]
[null,null,null,null,null,null,null,104]
[null,null,null,null,null,null,null,105]
[null,null,null,null,null,null,null,106]
[null,null,null,null,null,null,null,107]
[null,null,null,null,null,null,null,108]
[null,null,null,null,null,null,null,109]
[null,null,null,null,null,null,null,110]
[null,null,null,null,null,null,null,111]
[null,null,null,null,null,null,null,112]
[null,null,null,null,null,null,null,113]
[null,null,null,null,null,null,null,{"$f":"H116+1","v":114}]
[null,null,null,null,null,null,null,115]
[null,null,null,null,null,null,null,116]
[null,null,null,null,null,null,null,117]
[null,null,null,null,null,null,null,118]
[null,null,null,null,null,null,null,119]
[null,null,null,null,null,null,null,120]
[null,null,null,null,null,null,null,{"$f":"H123+1","v":121}]
[null,null,null,null,null,null,null,122]
[null,null,null,null,null,null,null,123]
[null,null,null,null,null,null,null,124]
[null,null,null,null,null,null,null,125]
[null,null,null,null,null,null,null,126]
[null,null,null,null,null,null,null,127]
[null,null,null,null,null,null,null,128]
[null,null,null,null,null,null,null,129]
[null,null,null,null,null,null,null,{"$f":"H132+1","v":130}]
[null,null,null,null,null,null,null,131]
[null,null,null,null,null,null,null,132]
[null,null,null,null,null,null,null,133]
[null,null,null,null,null,null,null,134]
[null,null,null,null,null,null,null,135]
[null,null,null,null,null,null,null,136]
[null,null,null,null,null,null,null,137]
[null,null,null,null,null,null,null,138]
[null,null,null,null,null,null,null,139]
[null,null,null,null,null,null,null,140]
[null,null,null,null,null,null,null,141]
[null,null,null,null,null,null,null,142]
[null,null,null,null,null,null,null,143]
[null,null,null,null,null,null,null,144]
[null,null,null,null,null,null,null,145]
[null,null,null,null,null,null,null,146]
[null,null,null,null,null,null,null,147]
[null,null,null,null,null,null,null,148]
[null,null,null,null,null,null,null,149]
[null,null,null,null,null,null,null,150]
[null,null,null,null,null,null,null,151]
[null,null,null,null,null,null,null,152]
[null,null,null,null,null,null,null,153]
[null,null,null,null,null,null,null,154]
[null,null,null,null,null,null,null,155]
[null,null,null,null,null,null,null,156]
[null,null,null,null,null,null,null,157]
[null,null,null,null,null,null,null,158]
[null,null,null,null,null,null,null,159]
[null,null,null,null,null,null,null,160]
[null,null,null,null,null,null,null,161]
[null,null,null,null,null,null,null,162]
[null,null,null,null,null,null,null,163]
[null,null,null,null,null,null,null,164]
[null,null,null,null,null,null,null,165]
[null,null,null,null,null,null,null,166]
[null,null,null,null,null,null,null,167]
[null,null,null,null,null,null,null,168]
[null,null,null,null,null,null,null,169]
[null,null,null,null,null,null,null,170]
[null,null,null,null,null,null,null,171]
[null,null,null,null,null,null,null,172]
[null,null,null,null,null,null,null,173]
[null,null,null,null,null,null,null,174]
[null,null,null,null,null,null,null,175]
[null,null,null,null,null,null,null,176]
[null,null,null,null,null,null,null,177]
[null,null,null,null,null,null,null,178]
[null,null,null,null,null,null,null,179]
[null,null,null,null,null,null,null,180]
[null,null,null,null,null,null,null,181]
[null,null,null,null,null,null,null,182]
[null,null,null,null,null,null,null,183]
[null,null,null,null,null,null,null,184]
[null,null,null,null,null,null,null,185]
[null,null,null,null,null,null,null,186]
[null,null,null,null,null,null,null,187]
[null,null,null,null,null,null,null,188]
[null,null,null,null,null,null,null,189]
[null,null,null,null,null,null,null,190]
[null,null,null,null,null,null,null,191]
[null,null,null,null,null,null,null,192]
[null,null,null,null,null,null,null,193]
[null,null,null,null,null,null,null,{"$f":"H196+1","v":194}]
[null,null,null,null,null,null,null,195]
[null,null,null,null,null,null,null,196]
[null,null,null,null,null,null,null,197]
[null,null,null,null,null,null,null,198]
[null,null,null,null,null,null,null,199]
[null,null,null,null,null,null,null,200]
[null,null,null,null,null,null,null,201]
[null,null,null,null,null,null,null,202]
[null,null,null,null,null,null,null,203]
[null,null,null,null,null,null,null,204]
[null,null,null,null,null,null,null,205]
[null,null,null,null,null,null,null,206]
[null,null,null,null,null,null,null,207]
[null,null,null,null,null,null,null,208]
[null,null,null,null,null,null,null,209]
[null,null,null,null,null,null,null,210]
[null,null,null,null,null,null,null,211]
[null,null,null,null,null,null,null,212]
[null,null,null,null,null,null,null,213]
[null,null,null,null,null,null,null,214]
[null,null,null,null,null,null,null,215]
[null,null,null,null,null,null,null,216]
[null,null,null,null,null,null,null,217]
[null,null,null,null,null,null,null,218]
[null,null,null,null,null,null,null,219]
[null,null,null,null,null,null,null,220]
[null,null,null,null,null,null,null,221]
[null,null,null,null,null,null,null,222]
[null,null,null,null,null,null,null,223]
[null,null,null,null,null,null,null,224]
[null,null,null,null,null,null,null,225]
[null,null,null,null,null,null,null,226]
[null,null,null,null,null,null,null,227]
[null,null,null,null,null,null,null,228]
[null,null,null,null,null,null,null,229]
[null,null,null,null,null,null,null,230]
[null,null,null,null,null,null,null,231]
[null,null,null,null,null,null,null,232]
[null,null,null,null,null,null,null,233]
[null,null,null,null,null,null,null,234]
[null,null,null,null,null,null,null,235]
[null,null,null,null,null,null,null,236]
[null,null,null,null,null,null,null,237]
[null,null,null,null,null,null,null,238]
[null,null,null,null,null,null,null,239]
[null,null,null,null,null,null,null,240]
[null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(J3:J243)","v":0},{"$f":"SUM(K3:K243)","v":0},0,0,0]

{"sheet":"Feuil1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}