{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Synthèse","Portefeuille actions"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":2,"comments":0,"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":"Synthèse","index":0,"n_rows":37,"n_cols":9,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,"SYNTHESE DE SITUATION"]
[null,null,null,null,null,null,null,"Revenu"]
[null,null,"Montant ","Virement mensuel",null,"Répartition",null,null,"Montant"]
[]
[null,"Compte chèque",1500,"-",null,{"$f":"C6/C21","v":4.2737477918969743E-2},null,"Salaire fixe brut annuel",55000]
[null,null,null,null,null,null,null,"Variable brut annuel",11000]
[null,"Epargne",null,null,null,null,null,"indemnité véhicule (net)",6000]
[null,"CEL",4000,75,null,{"$f":"C9/C21","v":0.11396660778391932}]
[null,"Livret dév durable",1307,null,null,{"$f":"C10/C21","v":3.7238589093395634E-2},null,"Total net annuel",{"$f":"((I6+I7)*0.75)+I8","v":55500}]
[null,"PEL",1134,50,null,{"$f":"C11/C21","v":3.2309533306741127E-2},null,"Total net mensuel moyen",{"$f":"I10/12","v":4625}]
[]
[null,"Titres",null,null,null,null,null,"Revenu total 2008 (hors indemnité véhicule)",66217]
[null,"PEA titres",6930,200,null,{"$f":"C14/C21","v":0.1974471479856402}]
[null,"CIF",18588,null,null,{"$f":"C15/C21","v":0.52960282637187306},null,"Projet parking"]
[]
[null,"Assurances vie",null,null,null,null,null,"Prêt immobilier en cours"]
[null,"Multihorizons",864,30,null,{"$f":"C18/C21","v":2.4616787281326571E-2},null,"Achat de 5 parking en co propriété"]
[null,"Multiplacement 2",775,30,null,{"$f":"C19/C21","v":2.2081030258134366E-2}]
[null,null,null,null,null,null,null,"Montant du prêt ",105000]
[null,"TOTAL ACTIFS",{"$f":"SUM(C6:C19)","v":35098},{"$f":"SUM(D9:D19)","v":385},null,{"$f":"SUM(F6:F19)","v":1},null,"Durée totale du prêt","180 mois"]
[null,null,null,null,null,null,null,"1ère échéance ","2007-08-13"]
[null,null,null,null,null,null,null,"Montant mensuel à remb",853.56]
[null,null,null,null,null,null,null,"Taux ",4.7500000000000001E-2]
[null,"Principaux FLUX ENTRANTS/SORTANTS"]
[]
[null,"Mensuel","Flux entrants","Flux sortants"]
[null,"Salaire ",{"$f":"+I11","v":4625}]
[null,"Loyers parking",300]
[]
[null,"Loyer habitation ppale",null,950]
[null,"Impot revenu",null,{"$f":"7000/12","v":583.33333333333337}]
[null,"loyer véhicule",null,500]
[null,"remboursement prêt parking",null,425]
[null,"assurance véhicule",null,120]
[]
[null,"TOTAL",{"$f":"SUM(C28:C35)","v":4925},{"$f":"SUM(D28:D35)","v":2578.3333333333335}]

{"sheet":"Portefeuille actions","index":1,"n_rows":17,"n_cols":8,"rows_kept":17,"cut":false,"hidden":false,"merged":[[1,1,1,9],[2,4,2,6],[3,4,3,6],[5,1,5,7],[12,4,12,6],[14,1,14,7],[6,4,6,6],[8,1,8,7],[9,4,9,6],[11,1,11,7]]}
[null,"CIF au 13/09/2009"]
[null,"ACTIONS FRANCAISES"]
[null,"Libellé",null,"Qté","Cours",null,null,"Valorisation"]
[null,"FAURECIA",null,1400,12.21,null,null,"17.094,00"]
[null,"FR0000121147","pamp et +/- values potentielles",null,7.1505999999999998,null,0.70750000000000002,"+7.083,15 "]
[]
[null,"SANOFI AVENTIS",null,15,48.094999999999999,null,null,721.43]
[null,"FR0000120578","pamp et +/- values potentielles",null,56.0747,null,-0.14230000000000001,-119.7]
[]
[null,"RENAULT",null,12,33.305,null,null,399.66]
[null,"FR0000131906","pamp et +/- values potentielles",null,46.6175,null,-0.28549999999999998,-159.75]
[]
[null,"CARREFOUR",null,12,31.105,null,null,373.26]
[null,"FR0000120172","pamp et +/- values potentielles",null,46.4375,null,-0.3301,-183.99]
[]
[]
[null,null,null,null,null,null,null,18588]