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

{"sheet":"Flux de trésorerie","index":0,"n_rows":61,"n_cols":16,"rows_kept":61,"merged":[[0,1,0,15],[1,1,1,15]]}
[null,"Projection de flux de trésorerie de petite entreprise"]
[null,"Nom de la société"]
[null,"Date de début",{"$f":"TODAY()","v":"2019-05-03"}]
[null,"Alerte minimum solde trésorerie",null,{"$f":"Minimum_trésorerie","v":0},{"$f":"Minimum_trésorerie","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Début","janv.-18","févr.-18","mars-18","avr.-18","mai-18","juin-18","juil.-18","août-18","sept.-18","oct.-18","nov.-18","déc.-18","Total"]
[null,"Trésorerie disponible (début du mois)",null,{"$f":"C53","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"ENCAISSEMENTS"," ","janv.-18","févr.-18","mars-18","avr.-18","mai-18","juin-18","juil.-18","août-18","sept.-18","oct.-18","nov.-18","déc.-18","Total"]
[null,"Ventes au comptant",{"$nulls":13},{"$f":"SUM(D10:O10)","v":0}]
[null,"Rendements et provisions",{"$nulls":13},0]
[null,"Collections sur compte débiteurs",{"$nulls":13},0]
[null,"Intérêt, autres revenus",{"$nulls":13},0]
[null,"Produits du prêt",{"$nulls":13},0]
[null,"Contributions propriétaire",{"$nulls":13},0]
[null,"TOTAL ENCAISSEMENTS",null,{"$f":"SUM(D10,D12:D15,(D11*-1))","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUBTOTAL(109,Encaissements[Total])","v":0}]
[null,"Trésorerie totale disponible",{"$f":"(C7+Encaissements[[#Totals],[ ]])","v":0},{"$f":"(D7+Encaissements[[#Totals],[janv.-18]])","v":0},{"$f":"(E7+Encaissements[[#Totals],[févr.-18]])","v":0},{"$f":"(F7+Encaissements[[#Totals],[mars-18]])","v":0},{"$f":"(G7+Encaissements[[#Totals],[avr.-18]])","v":0},{"$f":"(H7+Encaissements[[#Totals],[mai-18]])","v":0},{"$f":"(I7+Encaissements[[#Totals],[juin-18]])","v":0},{"$f":"(J7+Encaissements[[#Totals],[juil.-18]])","v":0},{"$f":"(K7+Encaissements[[#Totals],[août-18]])","v":0},{"$f":"(L7+Encaissements[[#Totals],[sept.-18]])","v":0},{"$f":"(M7+Encaissements[[#Totals],[oct.-18]])","v":0},{"$f":"(N7+Encaissements[[#Totals],[nov.-18]])","v":0},{"$f":"(O7+Encaissements[[#Totals],[déc.-18]])","v":0}]
[]
[null,"Décaissements"," ","janv.-18","févr.-18","mars-18","avr.-18","mai-18","juin-18","juil.-18","août-18","sept.-18","oct.-18","nov.-18","déc.-18","Total"]
[null,"Publicité",{"$nulls":13},{"$f":"SUM(D20:O20)","v":0}]
[null,"Commissions et frais",{"$nulls":13},0]
[null,"Main-d’œuvre contractuelle",{"$nulls":13},0]
[null,"Régimes d’avantages sociaux",{"$nulls":13},0]
[null,"Assurance (autres que la santé)",{"$nulls":13},0]
[null,"Dépenses intérêt",{"$nulls":13},0]
[null,"Ressources et fournitures (en variation stock)",{"$nulls":13},0]
[null,"Repas et loisirs",{"$nulls":13},0]
[null,"Intérêt d’emprunt immobilier",{"$nulls":13},0]
[null,"Frais de bureau",{"$nulls":13},0]
[null,"Autres dépenses intérêt",{"$nulls":13},0]
[null,"Plan retraite et partage de profit",{"$nulls":13},0]
[null,"Achats pour la revente",{"$nulls":13},0]
[null,"Loyer ou location",{"$nulls":13},0]
[null,"Loyer ou location: véhicules, équipements",{"$nulls":13},0]
[null,"Réparations et entretien",{"$nulls":13},0]
[null,"Fournitures (et non dans val)",{"$nulls":13},0]
[null,"Taxes et licences",{"$nulls":13},0]
[null,"Déplacements",{"$nulls":13},0]
[null,"Eau, électricité et gaz",{"$nulls":13},0]
[null,"Salaires (moins crédits emp.)",{"$nulls":13},0]
[null,"Autres frais",{"$nulls":13},0]
[null,"Autres frais",{"$nulls":13},0]
[null,"Autres frais",{"$nulls":13},0]
[null,"Divers",{"$nulls":13},0]
[null,"SOUS-TOTAL",null,{"$f":"SUBTOTAL(109,Dépenses[janv.-18])","v":0},{"$f":"SUBTOTAL(109,Dépenses[févr.-18])","v":0},{"$f":"SUBTOTAL(109,Dépenses[mars-18])","v":0},{"$f":"SUBTOTAL(109,Dépenses[avr.-18])","v":0},{"$f":"SUBTOTAL(109,Dépenses[mai-18])","v":0},{"$f":"SUBTOTAL(109,Dépenses[juin-18])","v":0},{"$f":"SUBTOTAL(109,Dépenses[juil.-18])","v":0},{"$f":"SUBTOTAL(109,Dépenses[août-18])","v":0},{"$f":"SUBTOTAL(109,Dépenses[sept.-18])","v":0},{"$f":"SUBTOTAL(109,Dépenses[oct.-18])","v":0},{"$f":"SUBTOTAL(109,Dépenses[nov.-18])","v":0},{"$f":"SUBTOTAL(109,Dépenses[déc.-18])","v":0},{"$f":"SUBTOTAL(109,Dépenses[Total])","v":0}]
[null,"Décaissements"," ","janv.-18","févr.-18","mars-18","avr.-18","mai-18","juin-18","juil.-18","août-18","sept.-18","oct.-18","nov.-18","déc.-18","Total"]
[null,"Remboursement du capital d’un prêt",{"$nulls":13},{"$f":"SUM(D47:O47)","v":0}]
[null,"Achats en capitaux",{"$nulls":13},0]
[null,"Autres frais d’établissement",{"$nulls":13},0]
[null,"Compte sous séquestre",{"$nulls":13},0]
[null,"Retrait personnel du propriétaire",{"$nulls":13},0]
[null,"TOTAL DÉCAISSEMENTS",null,{"$f":"Dépenses[[#Totals],[janv.-18]]+SUBTOTAL(109,Décaissements[janv.-18])","v":0},{"$f":"Dépenses[[#Totals],[févr.-18]]+SUBTOTAL(109,Décaissements[févr.-18])","v":0},{"$f":"Dépenses[[#Totals],[mars-18]]+SUBTOTAL(109,Décaissements[mars-18])","v":0},{"$f":"Dépenses[[#Totals],[avr.-18]]+SUBTOTAL(109,Décaissements[avr.-18])","v":0},{"$f":"Dépenses[[#Totals],[mai-18]]+SUBTOTAL(109,Décaissements[mai-18])","v":0},{"$f":"Dépenses[[#Totals],[juin-18]]+SUBTOTAL(109,Décaissements[juin-18])","v":0},{"$f":"Dépenses[[#Totals],[juil.-18]]+SUBTOTAL(109,Décaissements[juil.-18])","v":0},{"$f":"Dépenses[[#Totals],[août-18]]+SUBTOTAL(109,Décaissements[août-18])","v":0},{"$f":"Dépenses[[#Totals],[sept.-18]]+SUBTOTAL(109,Décaissements[sept.-18])","v":0},{"$f":"Dépenses[[#Totals],[oct.-18]]+SUBTOTAL(109,Décaissements[oct.-18])","v":0},{"$f":"Dépenses[[#Totals],[nov.-18]]+SUBTOTAL(109,Décaissements[nov.-18])","v":0},{"$f":"Dépenses[[#Totals],[déc.-18]]+SUBTOTAL(109,Décaissements[déc.-18])","v":0},0]
[null,"Trésorerie disponible (fin de mois)",{"$f":"C17","v":0},{"$f":"D17-Décaissements[[#Totals],[janv.-18]]","v":0},{"$f":"E17-Décaissements[[#Totals],[févr.-18]]","v":0},{"$f":"F17-Décaissements[[#Totals],[mars-18]]","v":0},{"$f":"G17-Décaissements[[#Totals],[avr.-18]]","v":0},{"$f":"H17-Décaissements[[#Totals],[mai-18]]","v":0},{"$f":"I17-Décaissements[[#Totals],[juin-18]]","v":0},{"$f":"J17-Décaissements[[#Totals],[juil.-18]]","v":0},{"$f":"K17-Décaissements[[#Totals],[août-18]]","v":0},{"$f":"L17-Décaissements[[#Totals],[sept.-18]]","v":0},{"$f":"M17-Décaissements[[#Totals],[oct.-18]]","v":0},{"$f":"N17-Décaissements[[#Totals],[nov.-18]]","v":0},{"$f":"O17-Décaissements[[#Totals],[déc.-18]]","v":0}]
[]
[null,"AUTRES DONNÉES D’EXPLOITATION"," ","janv.-18","févr.-18","mars-18","avr.-18","mai-18","juin-18","juil.-18","août-18","sept.-18","oct.-18","nov.-18","déc.-18","Total"]
[null,"Volume des ventes (dollars)",{"$nulls":13},{"$f":"SUM(AutresDonnéesOpérationnelles[[#This Row],[janv.-18]:[déc.-18]])","v":0}]
[null,"Solde comptes clients",{"$nulls":13},{"$f":"SUM(AutresDonnéesOpérationnelles[[#This Row],[janv.-18]:[déc.-18]])","v":0}]
[null,"Solde de mauvaises créances",{"$nulls":13},{"$f":"SUM(AutresDonnéesOpérationnelles[[#This Row],[janv.-18]:[déc.-18]])","v":0}]
[null,"Inventaire disponible",{"$nulls":13},{"$f":"SUM(AutresDonnéesOpérationnelles[[#This Row],[janv.-18]:[déc.-18]])","v":0}]
[null,"Comptes fournisseurs",{"$nulls":13},{"$f":"SUM(AutresDonnéesOpérationnelles[[#This Row],[janv.-18]:[déc.-18]])","v":0}]
[null,"Amortissement",{"$nulls":13},{"$f":"SUM(AutresDonnéesOpérationnelles[[#This Row],[janv.-18]:[déc.-18]])","v":0}]

{"sheet":"Graphique Trésorerie ","index":1,"n_rows":37,"n_cols":4,"rows_kept":37,"merged":[[1,1,34,16],[36,1,36,2]]}
[]
[null,"La combinaison graphique montrant l’Alerte minimale de trésorerie disponible et de Projection de flux de trésorerie se trouve dans cette cellule."]
{"$rows_empty":34}
[null,"Alerte minimum solde trésorerie",null,{"$f":"[0]!Minimum_trésorerie","v":{"v":0,"d":"0 $"}}]