{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Algus","Ülevaade","Alustamiskulude mall","Alustamiskulude näide","Kasumimall","Kasuminäide"],"not_rendered":{"defined_names":6},"read":"whole","date_system":"1900"}

{"sheet":"Algus","index":0,"n_rows":8,"n_cols":2,"rows_kept":8}
[null,"TEAVE SELLE MALLI KOHTA"]
[null,"Selle malli abil saate luua ettevõtte alustamise finantsplaani. "]
[null,"Finantsplaanist saate ülevaate töölehelt Ülevaade. "]
[null,"Alustamiskulude malli ning kasumi ja kahjumi malli töölehtede abil saate pidada arvestust alustamiskulude ning kasumi ja kahjumi üle. "]
[null,"Alustamiskulude ning kasumi ja kahjumi näidistöölehed sisaldavad tabelites näidisandmeid."]
[null,"Märkus. "]
[null,"Kõigi töölehtede veerus A on toodud lisajuhised. See tekst on tahtlikult peidetud. Teksti eemaldamiseks valige veerg A ja seejärel käsk KUSTUTA. Teksti kuvamiseks valige veerg A ja muutke seejärel fondi värvi."]
[null,"Tabelite kohta lisateabe saamiseks vajutage tabelis tõstuklahvi (SHIFT) ja seejärel klahvi F10, valige suvand TABEL ja seejärel käsk ASETEKST."]

{"sheet":"Ülevaade","index":1,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"ETTEVÕTTE ALUSTAMISE FINANTSPLAAN"]
[null,"Finantsplaani loomine koondab kogu ettevõtte plaanimise. Kui olete välja selgitanud oma toote, sihtturu ja sihtkliendid koos hinnakirjaga, olete valmis alustama kulude, müügi ja kasumi prognoosimist. Need üksused koos teie oletustega aitavad teil müügieelarvet hinnata. Ettevõtte teine pool on see, millised kulud teil tekkida võivad. See on oluline jooksvalt, et näha, millal olete kasumlik. Ettevõtte alustamisel on oluline teada, milliseid kulusid peate enne klientidele müümist või sellest saadava raha laekumist finantseerima. "]
[null,"Prognoositud alustamiskulud: Käivituskulude mall, mille leiate järgmiselt vahekaardilt, sisaldab tühja malli koos alustamisjuhistega.  Järgmisel vahekaardil „Alustamiskulude näide“ on näide jooksvatest ja ühekordsetest kuluartiklitest, mida teil võib ettevõtte alustamiseks vaja minna. Paljusid ettevõtteid rahastatakse aja jooksul krediidist ja neil pole kohe sissetulevat rahavoogu. Oluline on prognoosida, millal hakkab raha ettevõttesse sisse tulema, oletades, mitme kuu jagu korduvaid artikleid tuleb lisaks ühekordsele kulule rahastada säästudest või algsest investeeringust.  "]
[null,"Prognoositava kasumi ja kahjumi mudel: Sellelt vahekaardilt, sildiga „Kasumi ja kahjumi mall“, leiate tühja malli müügiprognoosi ning kasumi ja kahjumi mudeli tegemiseks. Järgmisel vahekaardil („Kasumi ja kahjumi näide“) on toodud näiteks esimest 12 tegevuskuud prognoosiv väikeettevõte. Iga mudeli tabeli ülemine osa näitab prognoositavat müüki ja brutokasumit. See on hea koht müügiprognoosi koostamise alustamiseks. Allpool järgmises jaotises on loetletud korduvad väljaminekud, mida te samade kuude kohta kavandate. Need peaksid olema kooskõlas eelmises jaotises sisestatud hinnanguliste alustamiskuludega. Selle mudeli allservas näete, millal hakkate kasumit teenima ja millised kuluartiklid mõjutavad teie kasumlikkust kõige rohkem. "]
[null,"Jälgige oma oletusi, mille olete teinud tulu ja müüdud kaupade kulu prognoosimisel. Veel mitte käivitunud ettevõtete puhul peaks teil olema ülevaade sellest, kuidas neid oma toote või teenuse jaoks prognoosida.  Mõned prognoosimisjuhised on toodud allpool. "]
[null,"Tulud: Alustuseks määratlege oma sihtturu puhul (potentsiaalsete klientide, ettevõtete või tarbijate rühm), kui suur osa neist oleks sihtturg esimesel aastal. Milline protsent sellest eeldatavasti sulgub? Milline on sihtturu keskmine tehing teie toote või teenuse ostmiseks? Kui palju saate teenida esimesel kuul, teisel kuul jne? Võiksite esimesel kuul alustada arvuga ja edasi suurendada seda teatud protsendi kaupa, näiteks 10%.  Oletame näiteks, et müüte puhastusteenuseid oma linna väikeettevõtetele ja teie arvates on seda teenust vaja 500 ettevõttel. Kui keskmine leping on 250 eurot kuus, peate prognoosima, kui mitme ettevõttega saate sõlmida lepingu esimese aasta igas kuus. "]
[null,"Müüdud kaupade kulu (COGS): Seda tuleks arvutada toodete ja mõne teenuse puhul.  See on toote tootmisega kaasnev kulu.  Näiteks kui müüte riideid, on COGS hind, mille te maksite riiete tootjale.  Kui valmistate need ise, on see materjalide ja nende valmistamiseks tehtud töö maksumus. Teenuste puhul oleks see ühe arveldatava töötunni otsene tööjõukulu.  Kõik, mis asub kasumi ja kahjumi lehel allpool brutokasumit, on üldise äritegevuse fikseeritud või üldkulud (nt rentimine, telefon või isegi turundus). "]

{"sheet":"Alustamiskulude mall","index":2,"n_rows":10,"n_cols":6,"rows_kept":10,"merged":[[1,2,1,5]]}
[null,"ALUSTAMISKULUD"]
[null,"Teie kohvik",{"$f":"TODAY()","v":"2022-01-18"}]
[]
[null,"KULUARTIKLID","KUUD","KULU/KUU","ÜHEKORDNE KULU","KULUD KOKKU"]
[null,"Reklaam/turundus",{"$nulls":3},{"$f":"(C5*D5)+IF(E5>0,E5,0)","v":{"v":0,"d":"0 €"}}]
[null,"Töötajate palgad",{"$nulls":3},{"$f":"(C6*D6)+IF(E6>0,E6,0)","v":{"v":0,"d":"0 €"}}]
[null,"Töötajate palgamaksud ja soodustused",{"$nulls":3},{"v":0,"d":"0 €"}]
[null,"Rendi-/liisingumaksed/kommunaalkulud",{"$nulls":3},{"v":0,"d":"0 €"}]
[null,"Posti-/saatekulud",{"$nulls":3},{"v":0,"d":"0 €"}]
[null,"HINNANGULINE ALUSTAMISEELARVE",{"$nulls":3},{"$f":"SUBTOTAL(109,Alustamine[KULUD KOKKU])","v":0}]

{"sheet":"Alustamiskulude näide","index":3,"n_rows":10,"n_cols":6,"rows_kept":10,"merged":[[1,2,1,5]]}
[null,"ALUSTAMISKULUD"]
[null,{"$f":"'Alustamiskulude mall'!B2","v":"Teie kohvik"},{"$f":"TODAY()","v":"2022-01-18"}]
[]
[null,"KULUARTIKLID","KUUD","KULU/KUU","ÜHEKORDNE KULU","KULUD KOKKU"]
[null,"Reklaam/turundus",3,{"v":300,"d":"300 €"},{"v":2000,"d":"2,000 €"},{"$f":"(C5*D5)+IF(E5>0,E5,0)","v":{"v":2900,"d":"2,900 €"}}]
[null,"Töötajate palgad",4,{"v":3500,"d":"3,500 €"},{"v":2,"d":"2 €"},{"$f":"(C6*D6)+IF(E6>0,E6,0)","v":{"v":14002,"d":"14,002 €"}}]
[null,"Töötajate palgamaksud ja soodustused",4,{"v":500,"d":"500 €"},{"v":2000,"d":"2,000 €"},{"v":4000,"d":"4,000 €"}]
[null,"Rendi-/liisingumaksed/kommunaalkulud",4,{"v":750,"d":"750 €"},{"v":3000,"d":"3,000 €"},{"v":6000,"d":"6,000 €"}]
[null,"Posti-/saatekulud",1,{"v":25,"d":"25 €"},{"v":25,"d":"25 €"},{"v":50,"d":"50 €"}]
[null,"HINNANGULINE ALUSTAMISEELARVE",{"$nulls":3},{"$f":"SUM(F6:F9)","v":{"v":24052,"d":"24,052 €"}}]

{"sheet":"Kasumimall","index":4,"n_rows":23,"n_cols":15,"rows_kept":23,"merged":[[1,2,1,14]]}
[null,"ALUSTAMISKULUD"]
[null,{"$f":"'Alustamiskulude mall'!B2","v":"Teie kohvik"},{"$f":"TODAY()","v":"2022-01-18"}]
[]
[null,"TULUD","JAAN","VEEBR","MÄRTS","APR","MAI","JUUNI","JUULI","AUG","SEPT","OKT","NOV","DETS","KOKKU"]
[null,"Hinnanguline toodete müük",{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"$f":"SUM(C5:N5)","v":{"v":0,"d":"0 €"}}]
[null,"Vähemmüügi tagastused ja allahindlused",{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"$f":"SUM(C6:N6)","v":{"v":0,"d":"0 €"}}]
[null,"Teenusetulu",{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"}]
[null,"Muu tulu ",{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"}]
[null,"Netomüük",{"$f":"SUBTOTAL(109,Tulunäited[JAAN])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tulunäited[VEEBR])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tulunäited[MÄRTS])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tulunäited[APR])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tulunäited[MAI])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tulunäited[JUUNI])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tulunäited[JUULI])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tulunäited[AUG])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tulunäited[SEPT])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tulunäited[OKT])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tulunäited[NOV])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Tulunäited[DETS])","v":{"v":0,"d":"0 €"}},{"$f":"SUM(Tulunäited[[#Totals],[JAAN]:[DETS]])","v":{"v":0,"d":"0 €"}}]
[null,"Müüdud kaupade kulu",{"$f":"C5*0.4","v":{"v":0,"d":"0 €"}},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"}]
[null,"Brutokasum",{"$f":"IFERROR(Tulunäited[[#Totals],[JAAN]]-C10,\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(Tulunäited[[#Totals],[VEEBR]]-D10,\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(Tulunäited[[#Totals],[MÄRTS]]-E10,\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(Tulunäited[[#Totals],[APR]]-F10,\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(Tulunäited[[#Totals],[MAI]]-G10,\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(Tulunäited[[#Totals],[JUUNI]]-H10,\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(Tulunäited[[#Totals],[JUULI]]-I10,\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(Tulunäited[[#Totals],[AUG]]-J10,\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(Tulunäited[[#Totals],[SEPT]]-K10,\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(Tulunäited[[#Totals],[OKT]]-L10,\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(Tulunäited[[#Totals],[NOV]]-M10,\"\")","v":{"v":0,"d":"0 €"}},{"$f":"IFERROR(Tulunäited[[#Totals],[DETS]]-N10,\"\")","v":{"v":0,"d":"0 €"}},{"v":0,"d":"0 €"}]
[]
[null,"KULUD","JAAN","VEEBR","MÄRTS","APR","MAI","JUUNI","JUULI","AUG","SEPT","OKT","NOV","DETS","KOKKU"]
[null,"Palgad ja tasud",{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"$f":"SUM(C14:N14)","v":{"v":0,"d":"0 €"}}]
[null,"Turundus/reklaam",{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"$f":"SUM(C15:N15)","v":{"v":0,"d":"0 €"}}]
[null,"Vahendustasud",{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"}]
[null,"Üür",{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"}]
[null,"Muu 1",{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"}]
[null,"Kogukulu",{"$f":"IF(SUM(C14:C18)=0,\"\",SUM(C14:C18))","v":""},"","","","","","","","","","","",{"$f":"SUM(Väljaminekunäited[[#Totals],[JAAN]:[DETS]])","v":{"v":0,"d":"0 €"}}]
[null,"Tulud enne maksustamist",{"$f":"IFERROR(Kasumimall!$C$11-Väljaminekunäited[[#Totals],[JAAN]],\"\")","v":""},{"$f":"IFERROR(Kasumimall!$C$11-Väljaminekunäited[[#Totals],[VEEBR]],\"\")","v":""},{"$f":"IFERROR(Kasumimall!$C$11-Väljaminekunäited[[#Totals],[MÄRTS]],\"\")","v":""},{"$f":"IFERROR(Kasumimall!$C$11-Väljaminekunäited[[#Totals],[APR]],\"\")","v":""},{"$f":"IFERROR(Kasumimall!$C$11-Väljaminekunäited[[#Totals],[MAI]],\"\")","v":""},{"$f":"IFERROR(Kasumimall!$C$11-Väljaminekunäited[[#Totals],[JUUNI]],\"\")","v":""},{"$f":"IFERROR(Kasumimall!$C$11-Väljaminekunäited[[#Totals],[JUULI]],\"\")","v":""},{"$f":"IFERROR(Kasumimall!$C$11-Väljaminekunäited[[#Totals],[AUG]],\"\")","v":""},{"$f":"IFERROR(Kasumimall!$C$11-Väljaminekunäited[[#Totals],[SEPT]],\"\")","v":""},{"$f":"IFERROR(Kasumimall!$C$11-Väljaminekunäited[[#Totals],[OKT]],\"\")","v":""},{"$f":"IFERROR(Kasumimall!$C$11-Väljaminekunäited[[#Totals],[NOV]],\"\")","v":""},{"$f":"IFERROR(Kasumimall!$C$11-Väljaminekunäited[[#Totals],[DETS]],\"\")","v":""},{"v":0,"d":"0 €"}]
[null,"Tulumaksukulu",{"$f":"IFERROR(C20*0.15,\" \")","v":" "},{"$f":"IFERROR(D20*0.15,\" \")","v":" "},{"$f":"IFERROR(E20*0.15,\" \")","v":" "}," "," "," "," "," "," "," "," "," ",{"$f":"SUM(Kasumimall!$C$21:$N$21)","v":{"v":0,"d":"0 €"}}]
[]
[null,"NETOTULU",{"$f":"IFERROR(C20-Kasumimall!$C$21,\"\")","v":""},{"$f":"IFERROR(D20-Kasumimall!$D$21,\"\")","v":""},{"$f":"IFERROR(E20-Kasumimall!$E$21,\"\")","v":""},{"$f":"IFERROR(F20-Kasumimall!$F$21,\"\")","v":""},{"$f":"IFERROR(G20-Kasumimall!$G$21,\"\")","v":""},{"$f":"IFERROR(H20-Kasumimall!$H$21,\"\")","v":""},{"$f":"IFERROR(I20-Kasumimall!$I$21,\"\")","v":""},{"$f":"IFERROR(J20-Kasumimall!$J$21,\"\")","v":""},{"$f":"IFERROR(K20-Kasumimall!$K$21,\"\")","v":""},{"$f":"IFERROR(L20-Kasumimall!$L$21,\"\")","v":""},{"$f":"IFERROR(M20-Kasumimall!$M$21,\"\")","v":""},{"$f":"IFERROR(N20-Kasumimall!$N$21,\"\")","v":""},{"$f":"IFERROR(O20-Kasumimall!$O$21,\"\")","v":{"v":0,"d":"0 €"}}]

{"sheet":"Kasuminäide","index":5,"n_rows":22,"n_cols":15,"rows_kept":22,"merged":[[1,2,1,14]]}
[null,"ALUSTAMISKULUD"]
[null,{"$f":"'Alustamiskulude mall'!B2","v":"Teie kohvik"},{"$f":"TODAY()","v":"2022-01-18"}]
[]
[null,"TULUD","JAAN","VEEBR","MÄRTS","APR","MAI","JUUNI","JUULI","AUG","SEPT","OKT","NOV","DETS","KOKKU"]
[null,"Hinnanguline toodete müük",{"v":5000,"d":"5,000 €"},{"v":13000,"d":"13,000 €"},{"v":16000,"d":"16,000 €"},{"v":7000,"d":"7,000 €"},{"v":14500,"d":"14,500 €"},{"v":16400,"d":"16,400 €"},{"v":22500,"d":"22,500 €"},{"v":23125,"d":"23,125 €"},{"v":24549,"d":"24,549 €"},{"v":22000,"d":"22,000 €"},{"v":25000,"d":"25,000 €"},{"v":27349,"d":"27,349 €"},{"$f":"SUM(C5:N5)","v":{"v":216423,"d":"216,423 €"}}]
[null,"Vähemmüügi tagastused ja allahindlused",{"v":0,"d":"0 €"},{"v":-350,"d":"-350 €"},{"v":0,"d":"0 €"},{"v":-206,"d":"-206 €"},{"v":-234,"d":"-234 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":-280,"d":"-280 €"},{"v":-1200,"d":"-1,200 €"},{"v":-1600,"d":"-1,600 €"},{"v":0,"d":"0 €"},{"v":-2400,"d":"-2,400 €"},{"$f":"SUM(C6:N6)","v":{"v":-6270,"d":"-6,270 €"}}]
[null,"Teenusetulu",{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":250,"d":"250 €"},{"v":350,"d":"350 €"},{"v":100,"d":"100 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":1245,"d":"1,245 €"},{"v":1360,"d":"1,360 €"},{"v":3305,"d":"3,305 €"}]
[null,"Muu tulu ",{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":1500,"d":"1,500 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":0,"d":"0 €"},{"v":1500,"d":"1,500 €"}]
[null,"Netomüük",{"$f":"SUBTOTAL(109,TegelikTulu[JAAN])","v":{"v":5000,"d":"5,000 €"}},{"$f":"SUBTOTAL(109,TegelikTulu[VEEBR])","v":{"v":12650,"d":"12,650 €"}},{"$f":"SUBTOTAL(109,TegelikTulu[MÄRTS])","v":{"v":16000,"d":"16,000 €"}},{"$f":"SUBTOTAL(109,TegelikTulu[APR])","v":{"v":6794,"d":"6,794 €"}},{"$f":"SUBTOTAL(109,TegelikTulu[MAI])","v":{"v":14266,"d":"14,266 €"}},{"$f":"SUBTOTAL(109,TegelikTulu[JUUNI])","v":{"v":16650,"d":"16,650 €"}},{"$f":"SUBTOTAL(109,TegelikTulu[JUULI])","v":{"v":22850,"d":"22,850 €"}},{"$f":"SUBTOTAL(109,TegelikTulu[AUG])","v":{"v":24445,"d":"24,445 €"}},{"$f":"SUBTOTAL(109,TegelikTulu[SEPT])","v":{"v":23349,"d":"23,349 €"}},{"$f":"SUBTOTAL(109,TegelikTulu[OKT])","v":{"v":20400,"d":"20,400 €"}},{"$f":"SUBTOTAL(109,TegelikTulu[NOV])","v":{"v":26245,"d":"26,245 €"}},{"$f":"SUBTOTAL(109,TegelikTulu[DETS])","v":{"v":26309,"d":"26,309 €"}},{"$f":"SUM(TegelikTulu[[#Totals],[JAAN]:[DETS]])","v":{"v":214958,"d":"214,958 €"}}]
[null,"Müüdud kaupade kulu",{"$f":"C5*0.4","v":{"v":2000,"d":"2,000 €"}},{"v":5200,"d":"5,200 €"},{"v":6400,"d":"6,400 €"},{"v":2800,"d":"2,800 €"},{"v":5800,"d":"5,800 €"},{"v":6560,"d":"6,560 €"},{"v":9000,"d":"9,000 €"},{"v":9250,"d":"9,250 €"},{"v":9819.6,"d":"9,820 €"},{"v":8800,"d":"8,800 €"},{"v":10000,"d":"10,000 €"},{"v":10939.6,"d":"10,940 €"},{"v":86569.20000000001,"d":"86,569 €"}]
[null,"Brutokasum",{"$f":"IFERROR(TegelikTulu[[#Totals],[JAAN]]-C10,\"\")","v":{"v":3000,"d":"3,000 €"}},{"$f":"IFERROR(TegelikTulu[[#Totals],[VEEBR]]-D10,\"\")","v":{"v":7450,"d":"7,450 €"}},{"$f":"IFERROR(TegelikTulu[[#Totals],[MÄRTS]]-E10,\"\")","v":{"v":9600,"d":"9,600 €"}},{"$f":"IFERROR(TegelikTulu[[#Totals],[APR]]-F10,\"\")","v":{"v":3994,"d":"3,994 €"}},{"$f":"IFERROR(TegelikTulu[[#Totals],[MAI]]-G10,\"\")","v":{"v":8466,"d":"8,466 €"}},{"$f":"IFERROR(TegelikTulu[[#Totals],[JUUNI]]-H10,\"\")","v":{"v":10090,"d":"10,090 €"}},{"$f":"IFERROR(TegelikTulu[[#Totals],[JUULI]]-I10,\"\")","v":{"v":13850,"d":"13,850 €"}},{"$f":"IFERROR(TegelikTulu[[#Totals],[AUG]]-J10,\"\")","v":{"v":15195,"d":"15,195 €"}},{"$f":"IFERROR(TegelikTulu[[#Totals],[SEPT]]-K10,\"\")","v":{"v":13529.4,"d":"13,529 €"}},{"$f":"IFERROR(TegelikTulu[[#Totals],[OKT]]-L10,\"\")","v":{"v":11600,"d":"11,600 €"}},{"$f":"IFERROR(TegelikTulu[[#Totals],[NOV]]-M10,\"\")","v":{"v":16245,"d":"16,245 €"}},{"$f":"IFERROR(TegelikTulu[[#Totals],[DETS]]-N10,\"\")","v":{"v":15369.4,"d":"15,369 €"}},{"v":128388.79999999999,"d":"128,389 €"}]
[]
[null,"KULUD","JAAN","VEEBR","MÄRTS","APR","MAI","JUUNI","JUULI","AUG","SEPT","OKT","NOV","DETS","KOKKU"]
[null,"Palgad ja tasud",{"v":2500,"d":"2,500 €"},{"v":2500,"d":"2,500 €"},{"v":3500,"d":"3,500 €"},{"v":5000,"d":"5,000 €"},{"v":5000,"d":"5,000 €"},{"v":5000,"d":"5,000 €"},{"v":8000,"d":"8,000 €"},{"v":9000,"d":"9,000 €"},{"v":9000,"d":"9,000 €"},{"v":9000,"d":"9,000 €"},{"v":9000,"d":"9,000 €"},{"v":9000,"d":"9,000 €"},{"$f":"SUM(C14:N14)","v":{"v":76500,"d":"76,500 €"}}]
[null,"Turundus/reklaam",{"v":400,"d":"400 €"},{"v":450,"d":"450 €"},{"v":450,"d":"450 €"},{"v":450,"d":"450 €"},{"v":900,"d":"900 €"},{"v":900,"d":"900 €"},{"v":900,"d":"900 €"},{"v":900,"d":"900 €"},{"v":900,"d":"900 €"},{"v":900,"d":"900 €"},{"v":1200,"d":"1,200 €"},{"v":1200,"d":"1,200 €"},{"$f":"SUM(C15:N15)","v":{"v":9550,"d":"9,550 €"}}]
[null,"Vahendustasud",{"v":250,"d":"250 €"},{"v":650,"d":"650 €"},{"v":800,"d":"800 €"},{"v":350,"d":"350 €"},{"v":725,"d":"725 €"},{"v":820,"d":"820 €"},{"v":1125,"d":"1,125 €"},{"v":1156.25,"d":"1,156 €"},{"v":1227.45,"d":"1,227 €"},{"v":1100,"d":"1,100 €"},{"v":1250,"d":"1,250 €"},{"v":1367.45,"d":"1,367 €"},{"v":10821.150000000001,"d":"10,821 €"}]
[null,"Üür",{"v":1250,"d":"1,250 €"},{"v":1250,"d":"1,250 €"},{"v":1250,"d":"1,250 €"},{"v":1250,"d":"1,250 €"},{"v":1250,"d":"1,250 €"},{"v":1250,"d":"1,250 €"},{"v":1250,"d":"1,250 €"},{"v":1250,"d":"1,250 €"},{"v":1250,"d":"1,250 €"},{"v":1250,"d":"1,250 €"},{"v":1250,"d":"1,250 €"},{"v":1250,"d":"1,250 €"},{"v":15000,"d":"15,000 €"}]
[null,"Kogukulu",{"$f":"IF(SUM(C14:C17)=0,\"\",SUM(C14:C17))","v":{"v":4400,"d":"4,400 €"}},{"v":4850,"d":"4,850 €"},{"v":6000,"d":"6,000 €"},{"v":7050,"d":"7,050 €"},{"v":7875,"d":"7,875 €"},{"v":7970,"d":"7,970 €"},{"v":11275,"d":"11,275 €"},{"v":12306.25,"d":"12,306 €"},{"v":12377.45,"d":"12,377 €"},{"v":12250,"d":"12,250 €"},{"v":12700,"d":"12,700 €"},{"v":12817.45,"d":"12,817 €"},{"$f":"SUM(TegelikudVäljaminekud[[#Totals],[JAAN]:[DETS]])","v":{"v":111871.15,"d":"111,871 €"}}]
[null,"Tulud enne maksustamist",{"$f":"IFERROR(Kasuminäide!$C$11-TegelikudVäljaminekud[[#Totals],[JAAN]],\"\")","v":{"v":-1400,"d":"-1,400 €"}},{"$f":"IFERROR(Kasuminäide!$D$11-TegelikudVäljaminekud[[#Totals],[VEEBR]],\"\")","v":{"v":2600,"d":"2,600 €"}},{"$f":"IFERROR(Kasuminäide!$E$11-TegelikudVäljaminekud[[#Totals],[MÄRTS]],\"\")","v":{"v":3600,"d":"3,600 €"}},{"$f":"IFERROR(Kasuminäide!$F$11-TegelikudVäljaminekud[[#Totals],[APR]],\"\")","v":{"v":-3056,"d":"-3,056 €"}},{"$f":"IFERROR(Kasuminäide!$G$11-TegelikudVäljaminekud[[#Totals],[MAI]],\"\")","v":{"v":591,"d":"591 €"}},{"$f":"IFERROR(Kasuminäide!$H$11-TegelikudVäljaminekud[[#Totals],[JUUNI]],\"\")","v":{"v":2120,"d":"2,120 €"}},{"$f":"IFERROR(Kasuminäide!$I$11-TegelikudVäljaminekud[[#Totals],[JUULI]],\"\")","v":{"v":2575,"d":"2,575 €"}},{"$f":"IFERROR(Kasuminäide!$J$11-TegelikudVäljaminekud[[#Totals],[AUG]],\"\")","v":{"v":2888.75,"d":"2,889 €"}},{"$f":"IFERROR(Kasuminäide!$K$11-TegelikudVäljaminekud[[#Totals],[SEPT]],\"\")","v":{"v":1151.949999999999,"d":"1,152 €"}},{"$f":"IFERROR(Kasuminäide!$L$11-TegelikudVäljaminekud[[#Totals],[OKT]],\"\")","v":{"v":-650,"d":"-650 €"}},{"$f":"IFERROR(Kasuminäide!$M$11-TegelikudVäljaminekud[[#Totals],[NOV]],\"\")","v":{"v":3545,"d":"3,545 €"}},{"$f":"IFERROR(Kasuminäide!$N$11-TegelikudVäljaminekud[[#Totals],[DETS]],\"\")","v":{"v":2551.949999999999,"d":"2,552 €"}},{"$f":"SUM(C19:N19)","v":{"v":16517.649999999998,"d":"16,518 €"}}]
[null,"Tulumaksukulu",{"$f":"C19*0.15","v":{"v":-210,"d":"-210 €"}},{"v":390,"d":"390 €"},{"$f":"E19*0.15","v":{"v":540,"d":"540 €"}},{"$f":"F19*0.15","v":{"v":-458.4,"d":"-458 €"}},{"$f":"G19*0.15","v":{"v":88.64999999999999,"d":"89 €"}},{"$f":"H19*0.15","v":{"v":318,"d":"318 €"}},{"$f":"I19*0.15","v":{"v":386.25,"d":"386 €"}},{"$f":"J19*0.15","v":{"v":433.3125,"d":"433 €"}},{"$f":"K19*0.15","v":{"v":172.79249999999982,"d":"173 €"}},{"$f":"L19*0.15","v":{"v":-97.5,"d":"-98 €"}},{"$f":"M19*0.15","v":{"v":531.75,"d":"532 €"}},{"$f":"N19*0.15","v":{"v":382.79249999999985,"d":"383 €"}},{"$f":"SUM(Kasuminäide!$C$20:$N$20)","v":{"v":2477.6474999999996,"d":"2,478 €"}}]
[]
[null,"NETOTULU",{"$f":"IFERROR(C19-Kasuminäide!$C$20,\" \")","v":{"v":-1190,"d":"-1,190 €"}},{"$f":"IFERROR(D19-Kasuminäide!$D$20,\" \")","v":{"v":2210,"d":"2,210 €"}},{"$f":"IFERROR(E19-Kasuminäide!$E$20,\"\")","v":{"v":3060,"d":"3,060 €"}},{"$f":"IFERROR(F19-Kasuminäide!$F$20,\"\")","v":{"v":-2597.6,"d":"-2,598 €"}},{"$f":"IFERROR(G19-Kasuminäide!$G$20,\"\")","v":{"v":502.35,"d":"502 €"}},{"$f":"IFERROR(H19-Kasuminäide!$H$20,\"\")","v":{"v":1802,"d":"1,802 €"}},{"$f":"IFERROR(I19-Kasuminäide!$I$20,\"\")","v":{"v":2188.75,"d":"2,189 €"}},{"$f":"IFERROR(J19-Kasuminäide!$J$20,\"\")","v":{"v":2455.4375,"d":"2,455 €"}},{"$f":"IFERROR(K19-Kasuminäide!$K$20,\"\")","v":{"v":979.1574999999991,"d":"979 €"}},{"$f":"IFERROR(L19-Kasuminäide!$L$20,\"\")","v":{"v":-552.5,"d":"-553 €"}},{"$f":"IFERROR(M19-Kasuminäide!$M$20,\"\")","v":{"v":3013.25,"d":"3,013 €"}},{"$f":"IFERROR(N19-Kasuminäide!$N$20,\"\")","v":{"v":2169.157499999999,"d":"2,169 €"}},{"$f":"IFERROR(O19-Kasuminäide!$O$20,\"\")","v":{"v":14040.002499999999,"d":"14,040 €"}}]