{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Prévision de trésorerie","Graphique Trésorerie"],"not_rendered":{"charts":1,"images":2,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"Prévision de trésorerie","index":0,"n_rows":64,"n_cols":16,"rows_kept":64,"merged":[[4,14,5,14]]}
[{"$nulls":15}," "]
[]
[null,"Trésorerie disponible de départ",{"v":10000,"d":"10,000.00 €"},null,"Date de début",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)","v":"2019-11-01"},null,"Alerte de solde de trésorerie minimal",null,{"v":2000,"d":"2,000.00 €"}]
[]
[null,null,{"$f":"IF(Date_Début=\"\",\"\",Date_Début)","v":"2019-11-01"},{"$f":"IF(C5=\"\",\"\",DATE(YEAR(C5),MONTH(C5)+1,1))","v":"2019-12-01"},{"$f":"IF(D5=\"\",\"\",DATE(YEAR(D5),MONTH(D5)+1,1))","v":"2020-01-01"},"2020-02-01","2020-03-01","2020-04-01","2020-05-01","2020-06-01","2020-07-01","2020-08-01","2020-09-01","2020-10-01","Total"]
[null,"Trésorerie disponible (début du mois)",{"$f":"C3","v":{"v":10000,"d":"10,000.00 €"}},{"$f":"C55","v":{"v":8050,"d":"8,050.00 €"}},{"v":9350,"d":"9,350.00 €"},{"v":890,"d":"890.00 €"},{"v":2190,"d":"2,190.00 €"},{"v":13590,"d":"13,590.00 €"},{"v":13790,"d":"13,790.00 €"},{"v":15290,"d":"15,290.00 €"},{"v":16410,"d":"16,410.00 €"},{"v":14360,"d":"14,360.00 €"},{"v":16560,"d":"16,560.00 €"},{"v":18780,"d":"18,780.00 €"}]
[]
[null,"Encaissements"]
[]
[null,"Ventes au comptant",{"v":2500,"d":"2,500.00 €"},{"v":3000,"d":"3,000.00 €"},{"v":3600,"d":"3,600.00 €"},{"v":3000,"d":"3,000.00 €"},{"v":14000,"d":"14,000.00 €"},{"v":6000,"d":"6,000.00 €"},{"v":3000,"d":"3,000.00 €"},{"v":2800,"d":"2,800.00 €"},{"v":3500,"d":"3,500.00 €"},{"v":4000,"d":"4,000.00 €"},{"v":3800,"d":"3,800.00 €"},{"v":4200,"d":"4,200.00 €"},{"$f":"SUM(C10:N10)","v":{"v":53400,"d":"53,400.00 €"}}]
[null,"Rendements et provisions",null,null,{"v":200,"d":"200.00 €"},{"$nulls":9},{"v":200,"d":"200.00 €"}]
[null,"Collections sur compte débiteurs",{"$nulls":12},0]
[null,"Intérêt, autres revenus",{"$nulls":12},0]
[null,"Produits du prêt",{"$nulls":12},0]
[null,"Contributions du propriétaire",{"$nulls":12},0]
[null,"Autres encaissements",{"$nulls":12},0]
[null,"Total des encaissements",{"$f":"SUM(C10,C12:C16,(C11*-1))","v":{"v":2500,"d":"2,500.00 €"}},{"$f":"SUM(D10,D12:D16,(D11*-1))","v":{"v":3000,"d":"3,000.00 €"}},{"v":3400,"d":"3,400.00 €"},{"v":3000,"d":"3,000.00 €"},{"v":14000,"d":"14,000.00 €"},{"v":6000,"d":"6,000.00 €"},{"v":3000,"d":"3,000.00 €"},{"v":2800,"d":"2,800.00 €"},{"v":3500,"d":"3,500.00 €"},{"v":4000,"d":"4,000.00 €"},{"v":3800,"d":"3,800.00 €"},{"v":4200,"d":"4,200.00 €"},{"$f":"SUM(O10:O16)","v":{"v":53600,"d":"53,600.00 €"}}]
[null,"Trésorerie totale disponible",{"$f":"(C6+C17)","v":{"v":12500,"d":"12,500.00 €"}},{"v":11050,"d":"11,050.00 €"},{"v":12750,"d":"12,750.00 €"},{"v":3890,"d":"3,890.00 €"},{"v":16190,"d":"16,190.00 €"},{"v":19590,"d":"19,590.00 €"},{"v":16790,"d":"16,790.00 €"},{"v":18090,"d":"18,090.00 €"},{"v":19910,"d":"19,910.00 €"},{"v":18360,"d":"18,360.00 €"},{"v":20360,"d":"20,360.00 €"},{"v":22980,"d":"22,980.00 €"}]
[]
[null,"Décaissements"]
[]
[null,"Publicité",{"v":3000,"d":"3,000.00 €"},{"$nulls":11},{"$f":"SUM(C22:N22)","v":{"v":3000,"d":"3,000.00 €"}}]
[null,"Commissions et frais",{"v":250,"d":"250.00 €"},{"v":300,"d":"300.00 €"},{"v":360,"d":"360.00 €"},{"v":300,"d":"300.00 €"},{"v":1400,"d":"1,400.00 €"},{"v":400,"d":"400.00 €"},{"v":300,"d":"300.00 €"},{"v":280,"d":"280.00 €"},{"v":350,"d":"350.00 €"},{"v":400,"d":"400.00 €"},{"v":380,"d":"380.00 €"},{"v":420,"d":"420.00 €"},{"v":5140,"d":"5,140.00 €"}]
[null,"Main-d’œuvre contractuelle",null,{"v":200,"d":"200.00 €"},null,{"v":200,"d":"200.00 €"},null,{"v":200,"d":"200.00 €"},null,{"v":200,"d":"200.00 €"},null,{"v":200,"d":"200.00 €"},null,{"v":200,"d":"200.00 €"},{"v":1200,"d":"1,200.00 €"}]
[null,"Régimes d’avantages sociaux",{"$nulls":12},0]
[null,"Assurance (autres que la santé)",null,null,{"v":4000,"d":"4,000.00 €"},null,null,{"v":4000,"d":"4,000.00 €"},null,null,{"v":4000,"d":"4,000.00 €"},null,null,{"v":4000,"d":"4,000.00 €"},{"v":16000,"d":"16,000.00 €"}]
[null,"Dépenses intérêt",{"$nulls":12},0]
[null,"Ressources et fournitures (en variation stock)",{"v":1200,"d":"1,200.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":7500,"d":"7,500.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":20700,"d":"20,700.00 €"}]
[null,"Repas et loisirs",{"$nulls":12},0]
[null,"Intérêt d’emprunt immobilier",{"$nulls":12},0]
[null,"Frais de bureau",{"$nulls":12},0]
[null,"Autres dépenses intérêt",{"$nulls":12},0]
[null,"Plan retraite et partage de profit",{"$nulls":12},0]
[null,"Achats pour la revente",{"$nulls":12},0]
[null,"Loyer ou location",{"$nulls":12},0]
[null,"Loyer ou location: véhicules, équipements",{"$nulls":12},0]
[null,"Réparations et entretien",{"$nulls":12},0]
[null,"Fournitures (et non dans val)",{"$nulls":12},0]
[null,"Taxes et licences",{"$nulls":12},0]
[null,"Déplacements",{"$nulls":12},0]
[null,"Eau, électricité et gaz",{"$nulls":12},0]
[null,"Salaires (moins crédits emp.)",{"$nulls":12},0]
[null,"Autres frais",{"$nulls":12},0]
[null,"Autres frais",{"$nulls":12},0]
[null,"Autres frais",{"$nulls":12},0]
[null,"Divers",{"$nulls":12},0]
[null,"Sous-total",{"$f":"SUM(C22:C46)","v":{"v":4450,"d":"4,450.00 €"}},{"v":1700,"d":"1,700.00 €"},{"v":11860,"d":"11,860.00 €"},{"v":1700,"d":"1,700.00 €"},{"v":2600,"d":"2,600.00 €"},{"v":5800,"d":"5,800.00 €"},{"v":1500,"d":"1,500.00 €"},{"v":1680,"d":"1,680.00 €"},{"v":5550,"d":"5,550.00 €"},{"v":1800,"d":"1,800.00 €"},{"v":1580,"d":"1,580.00 €"},{"v":5820,"d":"5,820.00 €"},{"v":46040,"d":"46,040.00 €"}]
[]
[null,"Remboursement du capital d’un prêt",{"$nulls":12},0]
[null,"Achats en capitaux",{"$nulls":12},0]
[null,"Autres frais d’établissement",{"$nulls":12},0]
[null,"Compte sous séquestre",{"$nulls":12},0]
[null,"Retrait personnel du propriétaire",{"$nulls":12},0]
[null,"Total des décaissements",{"$f":"C47-SUM(C49:C53)","v":{"v":4450,"d":"4,450.00 €"}},{"$f":"D47-SUM(D49:D53)","v":{"v":1700,"d":"1,700.00 €"}},{"v":11860,"d":"11,860.00 €"},{"v":1700,"d":"1,700.00 €"},{"v":2600,"d":"2,600.00 €"},{"v":5800,"d":"5,800.00 €"},{"v":1500,"d":"1,500.00 €"},{"v":1680,"d":"1,680.00 €"},{"v":5550,"d":"5,550.00 €"},{"v":1800,"d":"1,800.00 €"},{"v":1580,"d":"1,580.00 €"},{"v":5820,"d":"5,820.00 €"},{"$f":"SUM(O47,O49:O53)","v":{"v":46040,"d":"46,040.00 €"}}]
[null,"Trésorerie disponible (fin de mois)",{"$f":"(C18-C54)","v":{"v":8050,"d":"8,050.00 €"}},{"v":9350,"d":"9,350.00 €"},{"v":890,"d":"890.00 €"},{"v":2190,"d":"2,190.00 €"},{"v":13590,"d":"13,590.00 €"},{"v":13790,"d":"13,790.00 €"},{"v":15290,"d":"15,290.00 €"},{"v":16410,"d":"16,410.00 €"},{"v":14360,"d":"14,360.00 €"},{"v":16560,"d":"16,560.00 €"},{"v":18780,"d":"18,780.00 €"},{"v":17160,"d":"17,160.00 €"}]
[]
[null,"Autres données d’exploitation"]
[]
[null,"Volume des ventes (dollars)"]
[null,"Solde comptes clients"]
[null,"Solde de mauvaises créances"]
[null,"Inventaire disponible"]
[null,"Comptes fournisseurs"]
[null,"Amortissement"]

{"sheet":"Graphique Trésorerie","index":1,"n_rows":15,"n_cols":15,"rows_kept":15}
[{"$nulls":11}," "]
[]
[null,"Mois","Encaisse",{"$nulls":9},{"$f":"B3","v":"Mois"},"Non inférieure au minimum","Inférieure au minimum"]
[null,{"$f":"'Prévision de trésorerie'!C5","v":"2019-11-01"},{"$f":"'Prévision de trésorerie'!C6","v":{"v":10000,"d":"10,000.00 €"}},{"$nulls":9},{"$f":"B4","v":"2019-11-01"},{"$f":"IF(C4<Minimum_trésorerie,0,C4)","v":{"v":10000,"d":"10,000.00 €"}},{"$f":"IF(C4<Minimum_trésorerie,C4,0)","v":0}]
[null,{"$f":"'Prévision de trésorerie'!D5","v":"2019-12-01"},{"$f":"'Prévision de trésorerie'!D6","v":{"v":8050,"d":"8,050.00 €"}},{"$nulls":9},"2019-12-01",{"v":8050,"d":"8,050.00 €"},0]
[null,{"$f":"'Prévision de trésorerie'!E5","v":"2020-01-01"},{"$f":"'Prévision de trésorerie'!E6","v":{"v":9350,"d":"9,350.00 €"}},{"$nulls":9},"2020-01-01",{"v":9350,"d":"9,350.00 €"},0]
[null,{"$f":"'Prévision de trésorerie'!F5","v":"2020-02-01"},{"$f":"'Prévision de trésorerie'!F6","v":{"v":890,"d":"890.00 €"}},{"$nulls":9},"2020-02-01",0,{"v":890,"d":"890.00 €"}]
[null,{"$f":"'Prévision de trésorerie'!G5","v":"2020-03-01"},{"$f":"'Prévision de trésorerie'!G6","v":{"v":2190,"d":"2,190.00 €"}},{"$nulls":9},"2020-03-01",{"v":2190,"d":"2,190.00 €"},0]
[null,{"$f":"'Prévision de trésorerie'!H5","v":"2020-04-01"},{"$f":"'Prévision de trésorerie'!H6","v":{"v":13590,"d":"13,590.00 €"}},{"$nulls":9},"2020-04-01",{"v":13590,"d":"13,590.00 €"},0]
[null,{"$f":"'Prévision de trésorerie'!I5","v":"2020-05-01"},{"$f":"'Prévision de trésorerie'!I6","v":{"v":13790,"d":"13,790.00 €"}},{"$nulls":9},"2020-05-01",{"v":13790,"d":"13,790.00 €"},0]
[null,{"$f":"'Prévision de trésorerie'!J5","v":"2020-06-01"},{"$f":"'Prévision de trésorerie'!J6","v":{"v":15290,"d":"15,290.00 €"}},{"$nulls":9},"2020-06-01",{"v":15290,"d":"15,290.00 €"},0]
[null,{"$f":"'Prévision de trésorerie'!K5","v":"2020-07-01"},{"$f":"'Prévision de trésorerie'!K6","v":{"v":16410,"d":"16,410.00 €"}},{"$nulls":9},"2020-07-01",{"v":16410,"d":"16,410.00 €"},0]
[null,{"$f":"'Prévision de trésorerie'!L5","v":"2020-08-01"},{"$f":"'Prévision de trésorerie'!L6","v":{"v":14360,"d":"14,360.00 €"}},{"$nulls":9},"2020-08-01",{"v":14360,"d":"14,360.00 €"},0]
[null,{"$f":"'Prévision de trésorerie'!M5","v":"2020-09-01"},{"$f":"'Prévision de trésorerie'!M6","v":{"v":16560,"d":"16,560.00 €"}},{"$nulls":9},"2020-09-01",{"v":16560,"d":"16,560.00 €"},0]
[null,{"$f":"'Prévision de trésorerie'!N5","v":"2020-10-01"},{"$f":"'Prévision de trésorerie'!N6","v":{"v":18780,"d":"18,780.00 €"}},{"$nulls":9},"2020-10-01",{"v":18780,"d":"18,780.00 €"},0]