{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Kassaflöde","Kassaflödesdiagram"],"not_rendered":{"charts":1,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"Kassaflöde","index":0,"n_rows":61,"n_cols":16,"rows_kept":61,"merged":[[0,1,0,15],[1,1,1,15]]}
[null,"Kassaflödesprognos för småföretag"]
[null,"Företagsnamn"]
[null,"Startdatum",{"$f":"TODAY()","v":"2019-04-23"}]
[null,"Avisering för minsta kassasaldo",null,{"$f":"Kassa_minsta","v":0},{"$f":"Kassa_minsta","v":0},0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"Ingående","Jan-18","Feb-18","Mar-18","Apr-18","Maj-18","Jun-18","Jul-18","Aug-18","Sep-18","Okt-18","Nov-18","Dec-18","Summa"]
[null,"Likvida medel (början av månaden)",null,{"$f":"C53","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"KASSAKVITTON"," ","Jan-18","Feb-18","Mar-18","Apr-18","Maj-18","Jun-18","Jul-18","Aug-18","Sep-18","Okt-18","Nov-18","Dec-18","Summa"]
[null,"Kontantförsäljning",{"$nulls":13},{"$f":"SUM(D10:O10)","v":0}]
[null,"Returer och avdrag",{"$nulls":13},0]
[null,"Inkassering för kundreskontra",{"$nulls":13},0]
[null,"Ränta, övriga intäkter",{"$nulls":13},0]
[null,"Lånebelopp",{"$nulls":13},0]
[null,"Ägartillskott",{"$nulls":13},0]
[null,"SUMMA KASSAKVITTON",null,{"$f":"SUM(D10,D12:D15,(D11*-1))","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUBTOTAL(109,Inbetalningar[Summa])","v":0}]
[null,"Summa tillgängliga kontanter",{"$f":"(C7+Inbetalningar[[#Totals],[ ]])","v":0},{"$f":"(D7+Inbetalningar[[#Totals],[Jan-18]])","v":0},{"$f":"(E7+Inbetalningar[[#Totals],[Feb-18]])","v":0},{"$f":"(F7+Inbetalningar[[#Totals],[Mar-18]])","v":0},{"$f":"(G7+Inbetalningar[[#Totals],[Apr-18]])","v":0},{"$f":"(H7+Inbetalningar[[#Totals],[Maj-18]])","v":0},{"$f":"(I7+Inbetalningar[[#Totals],[Jun-18]])","v":0},{"$f":"(J7+Inbetalningar[[#Totals],[Jul-18]])","v":0},{"$f":"(K7+Inbetalningar[[#Totals],[Aug-18]])","v":0},{"$f":"(L7+Inbetalningar[[#Totals],[Sep-18]])","v":0},{"$f":"(M7+Inbetalningar[[#Totals],[Okt-18]])","v":0},{"$f":"(N7+Inbetalningar[[#Totals],[Nov-18]])","v":0},{"$f":"(O7+Inbetalningar[[#Totals],[Dec-18]])","v":0}]
[]
[null,"PENGAR SOM BETALATS UT"," ","Jan-18","Feb-18","Mar-18","Apr-18","Maj-18","Jun-18","Jul-18","Aug-18","Sep-18","Okt-18","Nov-18","Dec-18","Summa"]
[null,"Annonsering",{"$nulls":13},{"$f":"SUM(D20:O20)","v":0}]
[null,"Provisioner och avgifter",{"$nulls":13},0]
[null,"Kontraktsarbete",{"$nulls":13},0]
[null,"Förmåner för anställda",{"$nulls":13},0]
[null,"Försäkring (annat än sjukförsäkring)",{"$nulls":13},0]
[null,"Ränteutgifter",{"$nulls":13},0]
[null,"Material och tillbehör (i KSV)",{"$nulls":13},0]
[null,"Måltider och nöjen",{"$nulls":13},0]
[null,"Ränta hypotek",{"$nulls":13},0]
[null,"Kontorsutgifter",{"$nulls":13},0]
[null,"Övriga ränteutgifter",{"$nulls":13},0]
[null,"Pension och vinstdelningsplan",{"$nulls":13},0]
[null,"Inköp för återförsäljning",{"$nulls":13},0]
[null,"Hyra eller leasing",{"$nulls":13},0]
[null,"Hyra eller leasing: fordon, utrustning",{"$nulls":13},0]
[null,"Reparationer och underhåll",{"$nulls":13},0]
[null,"Tillbehör (inte i KSV)",{"$nulls":13},0]
[null,"Skatter och licenser",{"$nulls":13},0]
[null,"Resor",{"$nulls":13},0]
[null,"Värme och vatten",{"$nulls":13},0]
[null,"Lön (exkl. anställdas krediter)",{"$nulls":13},0]
[null,"Övriga utgifter",{"$nulls":13},0]
[null,"Övriga utgifter",{"$nulls":13},0]
[null,"Övriga utgifter",{"$nulls":13},0]
[null,"Diverse",{"$nulls":13},0]
[null,"DELSUMMA",null,{"$f":"SUBTOTAL(109,Utgifter[Jan-18])","v":0},{"$f":"SUBTOTAL(109,Utgifter[Feb-18])","v":0},{"$f":"SUBTOTAL(109,Utgifter[Mar-18])","v":0},{"$f":"SUBTOTAL(109,Utgifter[Apr-18])","v":0},{"$f":"SUBTOTAL(109,Utgifter[Maj-18])","v":0},{"$f":"SUBTOTAL(109,Utgifter[Jun-18])","v":0},{"$f":"SUBTOTAL(109,Utgifter[Jul-18])","v":0},{"$f":"SUBTOTAL(109,Utgifter[Aug-18])","v":0},{"$f":"SUBTOTAL(109,Utgifter[Sep-18])","v":0},{"$f":"SUBTOTAL(109,Utgifter[Okt-18])","v":0},{"$f":"SUBTOTAL(109,Utgifter[Nov-18])","v":0},{"$f":"SUBTOTAL(109,Utgifter[Dec-18])","v":0},{"$f":"SUBTOTAL(109,Utgifter[Summa])","v":0}]
[null,"PENGAR SOM BETALATS UT"," ","Jan-18","Feb-18","Mar-18","Apr-18","Maj-18","Jun-18","Jul-18","Aug-18","Sep-18","Okt-18","Nov-18","Dec-18","Summa"]
[null,"Amortering",{"$nulls":13},{"$f":"SUM(D47:O47)","v":0}]
[null,"Kapitalinköp",{"$nulls":13},0]
[null,"Övriga uppstartskostnader",{"$nulls":13},0]
[null,"Reservering och/eller deponering",{"$nulls":13},0]
[null,"Eget uttag",{"$nulls":13},0]
[null,"SUMMA PENGAR SOM BETALATS UT",null,{"$f":"Utgifter[[#Totals],[Jan-18]]+SUBTOTAL(109,Utbetalningar[Jan-18])","v":0},{"$f":"Utgifter[[#Totals],[Feb-18]]+SUBTOTAL(109,Utbetalningar[Feb-18])","v":0},{"$f":"Utgifter[[#Totals],[Mar-18]]+SUBTOTAL(109,Utbetalningar[Mar-18])","v":0},{"$f":"Utgifter[[#Totals],[Apr-18]]+SUBTOTAL(109,Utbetalningar[Apr-18])","v":0},{"$f":"Utgifter[[#Totals],[Maj-18]]+SUBTOTAL(109,Utbetalningar[Maj-18])","v":0},{"$f":"Utgifter[[#Totals],[Jun-18]]+SUBTOTAL(109,Utbetalningar[Jun-18])","v":0},{"$f":"Utgifter[[#Totals],[Jul-18]]+SUBTOTAL(109,Utbetalningar[Jul-18])","v":0},{"$f":"Utgifter[[#Totals],[Aug-18]]+SUBTOTAL(109,Utbetalningar[Aug-18])","v":0},{"$f":"Utgifter[[#Totals],[Sep-18]]+SUBTOTAL(109,Utbetalningar[Sep-18])","v":0},{"$f":"Utgifter[[#Totals],[Okt-18]]+SUBTOTAL(109,Utbetalningar[Okt-18])","v":0},{"$f":"Utgifter[[#Totals],[Nov-18]]+SUBTOTAL(109,Utbetalningar[Nov-18])","v":0},{"$f":"Utgifter[[#Totals],[Dec-18]]+SUBTOTAL(109,Utbetalningar[Dec-18])","v":0},0]
[null,"Likvida medel (slutet av månaden)",{"$f":"C17","v":0},{"$f":"D17-Utbetalningar[[#Totals],[Jan-18]]","v":0},{"$f":"E17-Utbetalningar[[#Totals],[Feb-18]]","v":0},{"$f":"F17-Utbetalningar[[#Totals],[Mar-18]]","v":0},{"$f":"G17-Utbetalningar[[#Totals],[Apr-18]]","v":0},{"$f":"H17-Utbetalningar[[#Totals],[Maj-18]]","v":0},{"$f":"I17-Utbetalningar[[#Totals],[Jun-18]]","v":0},{"$f":"J17-Utbetalningar[[#Totals],[Jul-18]]","v":0},{"$f":"K17-Utbetalningar[[#Totals],[Aug-18]]","v":0},{"$f":"L17-Utbetalningar[[#Totals],[Sep-18]]","v":0},{"$f":"M17-Utbetalningar[[#Totals],[Okt-18]]","v":0},{"$f":"N17-Utbetalningar[[#Totals],[Nov-18]]","v":0},{"$f":"O17-Utbetalningar[[#Totals],[Dec-18]]","v":0}]
[]
[null,"ANDRA VERKSAMHETSDATA"," ","Jan-18","Feb-18","Mar-18","Apr-18","Maj-18","Jun-18","Jul-18","Aug-18","Sep-18","Okt-18","Nov-18","Dec-18","Summa"]
[null,"Försäljningsvolym (kronor)",{"$nulls":13},{"$f":"SUM(ÖvrigaDriftdata[[#This Row],[Jan-18]:[Dec-18]])","v":0}]
[null,"Kundreskontrasaldo",{"$nulls":13},{"$f":"SUM(ÖvrigaDriftdata[[#This Row],[Jan-18]:[Dec-18]])","v":0}]
[null,"Saldo osäker fordran",{"$nulls":13},{"$f":"SUM(ÖvrigaDriftdata[[#This Row],[Jan-18]:[Dec-18]])","v":0}]
[null,"Lagerbehållning",{"$nulls":13},{"$f":"SUM(ÖvrigaDriftdata[[#This Row],[Jan-18]:[Dec-18]])","v":0}]
[null,"Leverantörsreskontrasaldo",{"$nulls":13},{"$f":"SUM(ÖvrigaDriftdata[[#This Row],[Jan-18]:[Dec-18]])","v":0}]
[null,"Avskrivning",{"$nulls":13},{"$f":"SUM(ÖvrigaDriftdata[[#This Row],[Jan-18]:[Dec-18]])","v":0}]

{"sheet":"Kassaflödesdiagram","index":1,"n_rows":37,"n_cols":4,"rows_kept":37,"merged":[[1,1,34,16],[36,1,36,2]]}
[]
[null,"Kombinationsdiagram som visar avisering för minsta likvida medel och kassaflödesprognos finns i den här cellen."]
{"$rows_empty":34}
[null,"Avisering för minsta kassasaldo",null,{"$f":"[0]!Kassa_minsta","v":{"v":0,"d":"0 kr"}}]