{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Feuil1","index":0,"n_rows":30,"n_cols":14,"rows_kept":30,"merged":[[1,1,1,8],[1,10,1,13],[3,3,3,4],[5,1,5,2],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,8,5],[7,6,8,6],[7,7,7,8],[7,10,8,10],[7,11,8,11],[7,12,7,13]]}
[]
[null,"1. Financement par emprunt",{"$nulls":8},"2. Financement par crédit-bail"]
[]
[null,"Capital",null,"Durée de l'emprunt",{"$nulls":3}," Taux d'intérêt",null,null,"Capital",{"$f":"capital","v":{"v":0,"d":"0.00"}},"Durée"]
[{"$nulls":13},3]
[null,"Taux d'actualisation",{"$nulls":3},"Taux d'IS",{"$nulls":6},"Taux"]
[]
[null,"An","Annuités","Capital amorti","Intérêts","Dotation\naux amort.","Économie \nd'IS","Décaissements",null,null,"Redevances crédit-bail","Économie \nd'IS","Décaissements"]
[{"$nulls":7},"nets","actualisés",{"$nulls":3},"nets","actualisés"]
[null,1,{"$f":"IF(B10>durée_emprunt,0,-PMT(Taux_emprunt,durée_emprunt,capital))","v":{"v":0,"d":"0.00 "}},{"$f":"C10-E10","v":{"v":0,"d":"0.00 "}},{"$f":"C10*(1-(1/(1+Taux_emprunt)^(durée_emprunt-B10+1)))","v":{"v":0,"d":"0.00 "}},{"$f":"IF(B10>$F$4,0,$C$4/$F$4)","v":{"v":0,"d":"0.00 "}},{"$f":"(F10+E10)*Tx_IS","v":{"v":0,"d":"0.00 "}},{"$f":"C10-G10","v":{"v":0,"d":"0.00 "}},{"$f":"H10/((1+Tx_actualisation)^B10)","v":{"v":0,"d":"0.00 "}},null,{"$f":"ROUND(IF(ISERROR(PMT(Taux_creditbail,durée_créditbail,-capital,0)),0,PMT(Taux_creditbail,durée_créditbail,-capital,0)),2)","v":{"v":0,"d":"0.00 "}},{"$f":"K10*(Tx_IS)","v":{"v":0,"d":"0.00 "}},{"$f":"K10-L10","v":{"v":0,"d":"0.00 "}},{"$f":"M10/((1+Tx_actualisation)^B10)","v":{"v":0,"d":"0.00 "}}]
[null,2,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"$f":"ROUND(IF(B11>durée_créditbail,0,K10),2)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"$f":"K11-L11","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "}]
[null,3,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,4,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,5,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,6,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,7,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,8,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,9,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,10,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,11,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"$f":"K20*(Tx_IS)","v":{"v":0,"d":"0.00 "}},{"$f":"K20-L20","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "}]
[null,12,{"v":0,"d":"0.00 "},{"$f":"C21-E21","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,13,{"v":0,"d":"0.00 "},{"$f":"C22-E22","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,14,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,15,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,16,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,17,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,18,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,19,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,20,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},null,{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "}]
[null,"Total",{"$f":"SUM(C10:C29)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(D10:D29)","v":{"v":0,"d":"0.00 "}},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"v":0,"d":"0.00 "},{"$f":"SUM(H10:H29)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(I10:I29)","v":{"v":0,"d":"0.00 "}},null,{"$f":"SUM(K10:K29)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(L10:L29)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(M10:M29)","v":{"v":0,"d":"0.00 "}},{"$f":"SUM(N10:N29)","v":{"v":0,"d":"0.00 "}}]