{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Résumé théorie","Schéma coût du leasing","Calcul mensualité"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":0,"defined_names":0,"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":"Résumé théorie","index":0,"n_rows":49,"n_cols":2,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,95]

{"sheet":"Schéma coût du leasing","index":1,"n_rows":33,"n_cols":17,"rows_kept":33,"cut":false,"hidden":false,"merged":[[14,1,15,1],[25,5,27,5],[25,4,26,4],[27,4,28,4],[18,4,24,4],[0,1,0,8],[21,6,24,6],[9,5,9,6],[23,5,24,5],[18,5,22,5],[13,5,15,5]]}
[null,"LEASING"]
[]
[null,null,null,null,null,null,6]
[null,"Prix d'achat brut","CHF",20000,null,null,true]
[null," -  Remise","CHF",null,null,null,3]
[null," + Frais d'achat","CHF",null," Recherche"]
[null," - Acompte","CHF"]
[null,{"$f":"IF(D7=\"\",\"Prix d'achat net\",\"Reliquat d'achat\")","v":"Prix d'achat net"},"CHF",{"$f":"D4-D5+D6-D7","v":20000}]
[]
[null,"Valeur résiduelle","CHF",4000,null,"                          Capital moyen immobilisé (CMI)",null,null,null,null,null,null,null,null,1,"Trouver le prix d'achat du véhicule","Prix d'achat calculé"]
[null,"Taux du leasing","%",5,null,null,12000,null,null,null,null,null,null,null,2,"Trouver la valeur résiduelle","Valeur résiduelle calculée"]
[null,"Nb mensualités","CHF",48,null,null,null,null,null,null,null,null,null,null,3,"Trouver le taux, mensualité connue","Taux et coût du leasing calculés"]
[null,"Coût du leasing","CHF",2400,null,null,null,null,null,null,null,null,null,null,4,"Trouver le nombre de mensualités","Nombre de mensualités trouvé"]
[null,"Mensualité ","CHF",383.33333333333331,null,"Coût du leasing         (CL)",null,null,null,null,null,null,null,null,5,"Trouver le coût du leasing","Coût du leasing calculé"]
[null,{"$f":"VLOOKUP(G3,O10:Q16,G5)","v":"Mensualité calculée"},null,null,null,null,null,null,null,null,null,null,null,null,6,"Trouver la valeur d'une mensualité","Mensualité calculée"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,"Trouver le taux, coût du leasing connu","Taux et mensualité trouvés"]
[null,null,null,null,null,2400,"Total des "]
[null,null,null,null,null,null,48]
[null,null,null,null,"Prix d'achat net          (PAN)","Somme amortie        (SA)","mensualités",null,"Mensualité"]
[null,null,null,null,null,null,null,null,383.33333333333331]
[null,"Marche à suivre :",null,null,null,null,18400]
[null,"1) Choisir l'opération avec les boutons radio"]
[null,"2) Remplir les cases grises"]
[null,"3) Activer le bouton \"Calcul\"",null,null,null,16000]
[]
[null,null,null,null,20000,"Valeur résiduelle     (VR)"]
[]
[]
[null,null,null,null,null,4000]
[]
[]
[]
[" © Yvan Péguiron - HEP Lausanne - janvier 2011"]

{"sheet":"Calcul mensualité","index":2,"n_rows":28,"n_cols":12,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,11],[1,0,1,11],[11,10,11,11]]}
["L e a s i n g"]
["Calcul des mensualités"]
[]
[null,"Prix d'achat brut du véhicule :",null,null,null,null,0,"CHF","(yc TVA)"]
[null,"./. remise",null,null,null,null,0,"CHF",null,{"$f":"G4-G5","v":0},"CHF"]
[null,"Valeur résiduelle :",null,null,null,null,0," %",null,{"$f":"J5*G6/100","v":0},"CHF"]
[]
[null,"Taux d'intérêt :",null,null,null,null,null,null,500,7,"%"]
[null,null,null,null,null,null,null,null,1]
[null,"Acompte initial :",null,null,null,null,null,null,0,{"$f":"I10","v":0},"CHF"]
[]
[null,"Nombre de mensualités :",null,null,null,null,null,null,48,{"$f":"I12","v":48},"mensualités"]
[]
[]
[]
[null,"CMI (Capital moyen immobilisé)",null,null,null,null,{"$f":"(J5-J10+J6)/2","v":0},null,null,{"$f":"J12-1","v":47},"mois",2]
[null,null,null,null,null,null,null,null,null,{"$f":"J12","v":48},"mois"]
[null,"Coût du leasing",null,null,null,null,{"$f":"(G16*J8*(J12+L16-1))/1200","v":0},null,null,{"$f":"J12 +1","v":49},"mois"]
[]
[]
[null,"Mensualités :",null,null,{"$f":"J12","v":48},"x",{"$f":"ROUND((((J5-J6-J10)+G18)/J12)*2,1)/2","v":0},null,null,"Total :",{"$f":"G21*E21","v":0}]
[]
[]
[]
[]
[]
[]
[null,"Y. Péguiron - HEP Lausanne  - 14.07.04 "]