{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Deckblatt","Gruenderprofil","Kapitalbedarf_Finanzierung","Umsatzplanung","Rentabilitaetsvorschau","Liquiditaetsplanung","Unternehmerlohn"],"not_rendered":{"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Deckblatt","index":0,"n_rows":23,"n_cols":8,"rows_kept":23,"merged":[[0,0,1,7],[3,2,3,7],[4,2,4,4],[4,6,4,7],[6,2,6,4],[6,6,6,7],[8,2,9,7],[11,0,11,7],[13,0,13,2],[13,4,13,6],[15,0,15,2],[15,4,15,6],[17,0,17,2],[17,4,17,6],[19,0,19,2],[22,0,23,7]]}
["Businessplan"]
[]
[]
["Unternehmensname",null,"Nordlicht Digitalstudio"]
["Name des Gründers / der Gründerin",null,"Anna Becker",null,null,"Branche","Webdesign & Branding"]
["Standort",null,"Berlin",null,null,"Datum","2026-03-11"]
["E-Mail",null,"anna@nordlicht-digital.de",null,null,"Telefon","+49 30 555 88 21"]
[]
["Geschäftsidee / Kurzbeschreibung",null,"Digitalstudio für Webdesign, Markenauftritt, SEO-Betreuung und laufende Website-Pflege für kleine Unternehmen und Selbstständige."]
[]
[]
["Kurzüberblick"]
[]
["Gesamter Kapitalbedarf",null,null,{"$f":"Kapitalbedarf_Finanzierung!B35","v":{"v":37200,"d":"37,200.00 €"}},"Geplanter Jahresumsatz netto",null,null,{"$f":"Umsatzplanung!I31","v":{"v":100900,"d":"100,900.00 €"}}]
[]
["Eigenkapital",null,null,{"$f":"Kapitalbedarf_Finanzierung!B43","v":{"v":20500,"d":"20,500.00 €"}},"Betriebsergebnis Folgejahr",null,null,{"$f":"Rentabilitaetsvorschau!F32","v":{"v":46420,"d":"46,420.00 €"}}]
[]
["Finanzierungsbedarf",null,null,{"$f":"Kapitalbedarf_Finanzierung!B51","v":{"v":16700,"d":"16,700.00 €"}},"Jahresendliquidität",null,null,{"$f":"Liquiditaetsplanung!M32","v":{"v":29610,"d":"29,610.00 €"}}]
[]
["Unternehmerbedarf pro Monat",null,null,{"$f":"Unternehmerlohn!B18","v":{"v":2750,"d":"2,750.00 €"}}]
[]
[]
["Hinweis: Alle Zahlen in diesem Workbook sind Beispieldaten. Die Eingabezellen können frei überschrieben werden."]

{"sheet":"Gruenderprofil","index":1,"n_rows":40,"n_cols":3,"rows_kept":40,"merged":[[0,0,1,3],[3,0,3,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[11,0,11,3],[17,0,17,3],[23,0,23,3],[29,0,29,3],[30,1,31,3],[33,1,34,3],[36,1,37,3],[39,1,40,3]]}
["Gründerprofil"]
[]
[]
["Persönliche Angaben"]
["Vor- und Nachname","Anna Becker"]
["Anschrift","Rykestraße 14, 10405 Berlin"]
["Geburtsdatum","1990-06-18"]
["Geburtsort","Hamburg"]
["Telefon","+49 30 555 88 21"]
["E-Mail","anna@nordlicht-digital.de"]
[]
["Ausbildung"]
["Zeitraum","Schule / Studium / Ausbildung","Abschluss"]
["2009 - 2012","B.A. Kommunikationsdesign, Hochschule Hannover","Bachelor"]
["2013 - 2014","Weiterbildung UX/UI Design, Berlin","Zertifikat"]
["2015 - 2016","SEO & Content Marketing Weiterbildung","Zertifikat"]
[]
["Weiterbildungen"]
["Zeitraum","Weiterbildung","Abschluss / Zertifikat"]
["2018","Google Analytics Intensivkurs","Teilnahme"]
["2020","WordPress Developer Training","Zertifikat"]
["2023","KI-gestützte Content-Workflows","Workshop"]
[]
["Berufserfahrung"]
["Zeitraum","Tätigkeit","Unternehmen / Ort"]
["2012 - 2015","Junior Designerin","Brandagentur Nord, Hamburg"]
["2015 - 2019","Senior Webdesignerin","Studio Pixel, Berlin"]
["2019 - heute","Freelance Webdesignerin & Beraterin","Berlin"]
[]
["Relevante Kenntnisse"]
["Fachkenntnisse","WordPress, Shopify, Webflow, Figma, Elementor, SEO-Grundlagen, Conversion-orientierte Landingpages"]
[]
[]
["Vertrieb / Marketing","Angebotserstellung, Kundengespräche, lokale SEO, E-Mail-Marketing, Social Media Setups"]
[]
[]
["Technik / Produktion","Responsive Websites, CMS-Einrichtung, Performance-Optimierung, Tracking-Setups"]
[]
[]
["Sonstiges","Projektmanagement, Kundenworkshops, Netzwerk in Berlin, Zusammenarbeit mit Fotografen und Textern"]

{"sheet":"Kapitalbedarf_Finanzierung","index":2,"n_rows":57,"n_cols":2,"rows_kept":57,"merged":[[0,0,1,3],[3,0,3,3],[13,0,13,3],[23,0,23,3],[33,0,33,3],[36,0,36,3],[44,0,44,3],[52,0,52,3]]}
["Kapitalbedarf und Finanzierung"]
[]
[]
["A. Investitionen für die Betriebsbereitschaft"]
["Position","Betrag €"]
["Gebäude / Umbau",{"v":3500,"d":"3,500.00 €"}]
["Maschinen / Geräte",0]
["Geschäftsausstattung",{"v":1800,"d":"1,800.00 €"}]
["EDV / Software",{"v":6200,"d":"6,200.00 €"}]
["Fahrzeug",0]
["Sonstiges",{"v":1200,"d":"1,200.00 €"}]
["Zwischensumme Investitionen",{"$f":"SUM(B6:B11)","v":{"v":12700,"d":"12,700.00 €"}}]
[]
["B. Anlauf- und Betriebsmittelbedarf"]
["Position","Betrag €"]
["Warenlager / Material",{"v":800,"d":"800.00 €"}]
["Roh-, Hilfs- und Betriebsstoffe",0]
["Anlaufkosten",{"v":4500,"d":"4,500.00 €"}]
["Marketing zum Start",{"v":2500,"d":"2,500.00 €"}]
["Liquiditätsreserve",{"v":9000,"d":"9,000.00 €"}]
["Sonstiges",{"v":1200,"d":"1,200.00 €"}]
["Zwischensumme Betriebsmittel",{"$f":"SUM(B16:B21)","v":{"v":18000,"d":"18,000.00 €"}}]
[]
["C. Gründungskosten"]
["Position","Betrag €"]
["Beratung",{"v":1800,"d":"1,800.00 €"}]
["Notar / Rechtskosten",{"v":700,"d":"700.00 €"}]
["Anmeldungen / Eintragungen",{"v":350,"d":"350.00 €"}]
["Kautionen",{"v":2000,"d":"2,000.00 €"}]
["Versicherungen",{"v":900,"d":"900.00 €"}]
["Sonstiges",{"v":750,"d":"750.00 €"}]
["Zwischensumme Gründungskosten",{"$f":"SUM(B26:B31)","v":{"v":6500,"d":"6,500.00 €"}}]
[]
["D. Gesamter Kapitalbedarf"]
["Gesamter Kapitalbedarf",{"$f":"B12+B22+B32","v":{"v":37200,"d":"37,200.00 €"}}]
[]
["E. Eigenkapital"]
["Barvermögen",{"v":6000,"d":"6,000.00 €"}]
["Bankguthaben",{"v":12000,"d":"12,000.00 €"}]
["Sacheinlagen",{"v":2500,"d":"2,500.00 €"}]
["Zuschüsse / Schenkungen",0]
["Sonstiges",0]
["Summe Eigenkapital",{"$f":"SUM(B38:B42)","v":{"v":20500,"d":"20,500.00 €"}}]
[]
["F. Fremdfinanzierung"]
["Bankdarlehen",{"v":10000,"d":"10,000.00 €"}]
["Förderdarlehen",{"v":4500,"d":"4,500.00 €"}]
["Kontokorrentkredit",0]
["Familie / private Darlehen",{"v":2200,"d":"2,200.00 €"}]
["Sonstige Finanzierung",0]
["Summe Fremdfinanzierung",{"$f":"SUM(B46:B50)","v":{"v":16700,"d":"16,700.00 €"}}]
[]
["G. Finanzierungsergebnis"]
["Gesamter Kapitalbedarf",{"$f":"B35","v":{"v":37200,"d":"37,200.00 €"}}]
["Eigenkapital + Fremdfinanzierung",{"$f":"B43+B51","v":{"v":37200,"d":"37,200.00 €"}}]
["Finanzierungslücke / Überschuss",{"$f":"B55-B54","v":0}]
["Status",{"$f":"IF(B55>=B54,\"Finanzierung gedeckt\",\"Finanzierung nicht vollständig gedeckt\")","v":"Finanzierung gedeckt"}]

{"sheet":"Umsatzplanung","index":3,"n_rows":33,"n_cols":11,"rows_kept":33,"merged":[[0,0,1,10],[2,3,2,10],[5,0,5,10],[11,0,11,10],[17,0,17,10],[23,0,23,10],[28,0,28,10]]}
["Umsatzplanung"]
[]
["Umsatzsteuersatz",{"v":0.19,"d":"19.0%"},null,"Bitte nur realistische Durchschnittswerte eingeben."]
[]
["Kategorie","Produkt / Leistung","Ø Auftragswert H1","Monate H1","Umsatz H1","Ø Auftragswert H2","Monate H2","Umsatz H2","Jahresumsatz netto","Akquise / Kanal","Notiz"]
["Produktgruppen"]
["Produktgruppen","Webdesign Paket",{"v":2500,"d":"2,500.00 €"},4,{"$f":"C7*D7","v":{"v":10000,"d":"10,000.00 €"}},{"v":2800,"d":"2,800.00 €"},5,{"$f":"F7*G7","v":{"v":14000,"d":"14,000.00 €"}},{"$f":"E7+H7","v":{"v":24000,"d":"24,000.00 €"}},"Empfehlungen","KMU-Websites"]
["Produktgruppen","Branding Paket",{"v":1800,"d":"1,800.00 €"},3,{"$f":"C8*D8","v":{"v":5400,"d":"5,400.00 €"}},{"v":2000,"d":"2,000.00 €"},4,{"$f":"F8*G8","v":{"v":8000,"d":"8,000.00 €"}},{"$f":"E8+H8","v":{"v":13400,"d":"13,400.00 €"}},"Netzwerk","Logo & Corporate Design"]
["Produktgruppen","SEO Betreuung",{"v":900,"d":"900.00 €"},6,{"$f":"C9*D9","v":{"v":5400,"d":"5,400.00 €"}},{"v":1100,"d":"1,100.00 €"},6,{"$f":"F9*G9","v":{"v":6600,"d":"6,600.00 €"}},{"$f":"E9+H9","v":{"v":12000,"d":"12,000.00 €"}},"Bestandskunden","monatliche Betreuung"]
[null,"Zwischensumme",null,null,{"$f":"SUM(E7:E9)","v":{"v":20800,"d":"20,800.00 €"}},null,null,{"$f":"SUM(H7:H9)","v":{"v":28600,"d":"28,600.00 €"}},{"$f":"SUM(I7:I9)","v":{"v":49400,"d":"49,400.00 €"}}]
[]
["Bestandskunden"]
["Bestandskunden","Wartungsverträge",{"v":650,"d":"650.00 €"},6,{"$f":"C13*D13","v":{"v":3900,"d":"3,900.00 €"}},{"v":750,"d":"750.00 €"},6,{"$f":"F13*G13","v":{"v":4500,"d":"4,500.00 €"}},{"$f":"E13+H13","v":{"v":8400,"d":"8,400.00 €"}},"Bestandskunden","laufende Pflege"]
["Bestandskunden","Schulungen",{"v":1200,"d":"1,200.00 €"},2,{"$f":"C14*D14","v":{"v":2400,"d":"2,400.00 €"}},{"v":1400,"d":"1,400.00 €"},3,{"$f":"F14*G14","v":{"v":4200,"d":"4,200.00 €"}},{"$f":"E14+H14","v":{"v":6600,"d":"6,600.00 €"}},"Direktvertrieb","Website-Schulungen"]
["Bestandskunden","Content Updates",{"v":500,"d":"500.00 €"},3,{"$f":"C15*D15","v":{"v":1500,"d":"1,500.00 €"}},{"v":600,"d":"600.00 €"},4,{"$f":"F15*G15","v":{"v":2400,"d":"2,400.00 €"}},{"$f":"E15+H15","v":{"v":3900,"d":"3,900.00 €"}},"Bestandskunden","kleinere Pakete"]
[null,"Zwischensumme",null,null,{"$f":"SUM(E13:E15)","v":{"v":7800,"d":"7,800.00 €"}},null,null,{"$f":"SUM(H13:H15)","v":{"v":11100,"d":"11,100.00 €"}},{"$f":"SUM(I13:I15)","v":{"v":18900,"d":"18,900.00 €"}}]
[]
["Neukunden"]
["Neukunden","E-Commerce Projekt",{"v":3500,"d":"3,500.00 €"},1,{"$f":"C19*D19","v":{"v":3500,"d":"3,500.00 €"}},{"v":4200,"d":"4,200.00 €"},2,{"$f":"F19*G19","v":{"v":8400,"d":"8,400.00 €"}},{"$f":"E19+H19","v":{"v":11900,"d":"11,900.00 €"}},"LinkedIn / Partner","Shopify / WooCommerce"]
["Neukunden","Local SEO Projekt",{"v":1500,"d":"1,500.00 €"},2,{"$f":"C20*D20","v":{"v":3000,"d":"3,000.00 €"}},{"v":1800,"d":"1,800.00 €"},3,{"$f":"F20*G20","v":{"v":5400,"d":"5,400.00 €"}},{"$f":"E20+H20","v":{"v":8400,"d":"8,400.00 €"}},"SEO / Website","lokale Anbieter"]
["Neukunden","Social Media Setup",{"v":1000,"d":"1,000.00 €"},2,{"$f":"C21*D21","v":{"v":2000,"d":"2,000.00 €"}},{"v":1200,"d":"1,200.00 €"},3,{"$f":"F21*G21","v":{"v":3600,"d":"3,600.00 €"}},{"$f":"E21+H21","v":{"v":5600,"d":"5,600.00 €"}},"Empfehlungen","Starterpaket"]
[null,"Zwischensumme",null,null,{"$f":"SUM(E19:E21)","v":{"v":8500,"d":"8,500.00 €"}},null,null,{"$f":"SUM(H19:H21)","v":{"v":17400,"d":"17,400.00 €"}},{"$f":"SUM(I19:I21)","v":{"v":25900,"d":"25,900.00 €"}}]
[]
["Sonstiges"]
["Sonstiges","Hosting / Affiliate",{"v":300,"d":"300.00 €"},6,{"$f":"C25*D25","v":{"v":1800,"d":"1,800.00 €"}},{"v":350,"d":"350.00 €"},6,{"$f":"F25*G25","v":{"v":2100,"d":"2,100.00 €"}},{"$f":"E25+H25","v":{"v":3900,"d":"3,900.00 €"}},"Partner","wiederkehrend"]
["Sonstiges","Fotografie Add-on",{"v":800,"d":"800.00 €"},1,{"$f":"C26*D26","v":{"v":800,"d":"800.00 €"}},{"v":1000,"d":"1,000.00 €"},2,{"$f":"F26*G26","v":{"v":2000,"d":"2,000.00 €"}},{"$f":"E26+H26","v":{"v":2800,"d":"2,800.00 €"}},"Kooperationspartner","optionale Zusatzleistung"]
[null,"Zwischensumme",null,null,{"$f":"SUM(E25:E26)","v":{"v":2600,"d":"2,600.00 €"}},null,null,{"$f":"SUM(H25:H26)","v":{"v":4100,"d":"4,100.00 €"}},{"$f":"SUM(I25:I26)","v":{"v":6700,"d":"6,700.00 €"}}]
[]
["Gesamtergebnis"]
[null,"Gesamtumsatz H1",null,null,{"$f":"SUM(E10,E16,E22,E27)","v":{"v":39700,"d":"39,700.00 €"}}]
[null,"Gesamtumsatz netto Jahr",{"$nulls":6},{"$f":"SUM(I10,I16,I22,I27)","v":{"v":100900,"d":"100,900.00 €"}}]
[null,"Umsatzsteuer Betrag",{"$nulls":6},{"$f":"I31*$B$3","v":{"v":19171,"d":"19,171.00 €"}}]
[null,"Gesamtumsatz brutto",{"$nulls":6},{"$f":"I31+I32","v":{"v":120071,"d":"120,071.00 €"}}]

{"sheet":"Rentabilitaetsvorschau","index":4,"n_rows":32,"n_cols":7,"rows_kept":32,"merged":[[0,0,1,6],[13,0,13,6]]}
["Rentabilitätsvorschau"]
[]
["Monate im Rumpfjahr",6,null,null,"USt.-Satz",{"$f":"Umsatzplanung!$B$3","v":{"v":0.19,"d":"19.0%"}}]
[]
[null,"Monatlich","Rumpfjahr","%","Monatlich","Folgejahr","%"]
["Umsatz brutto",null,{"$f":"Umsatzplanung!$I$33*($B$3/12)","v":{"v":60035.5,"d":"60,035.50 €"}},null,null,{"$f":"Umsatzplanung!$I$33","v":{"v":120071,"d":"120,071.00 €"}}]
["Umsatzsteuer",null,{"$f":"C6-C8","v":{"v":9585.5,"d":"9,585.50 €"}},null,null,{"$f":"F6-F8","v":{"v":19171,"d":"19,171.00 €"}}]
["Umsatz netto",null,{"$f":"Umsatzplanung!$I$31*($B$3/12)","v":{"v":50450,"d":"50,450.00 €"}},null,null,{"$f":"Umsatzplanung!$I$31","v":{"v":100900,"d":"100,900.00 €"}}]
["Materialeinsatz",{"v":120,"d":"120.00 €"},{"$f":"B9*$B$3","v":{"v":720,"d":"720.00 €"}},{"$f":"IF(C8=0,\"\",C9/C8)","v":{"v":0.01427155599603568,"d":"1.4%"}},{"v":150,"d":"150.00 €"},{"$f":"E9*12","v":{"v":1800,"d":"1,800.00 €"}},{"$f":"IF(F8=0,\"\",F9/F8)","v":{"v":0.017839444995044598,"d":"1.8%"}}]
["Rohgewinn I",null,{"$f":"C8-C9","v":{"v":49730,"d":"49,730.00 €"}},{"$f":"IF(C8=0,\"\",C10/C8)","v":{"v":0.9857284440039643,"d":"98.6%"}},null,{"$f":"F8-F9","v":{"v":99100,"d":"99,100.00 €"}},{"$f":"IF(F8=0,\"\",F10/F8)","v":{"v":0.9821605550049554,"d":"98.2%"}}]
["Personalkosten",{"v":1800,"d":"1,800.00 €"},{"$f":"B11*$B$3","v":{"v":10800,"d":"10,800.00 €"}},{"$f":"IF(C8=0,\"\",C11/C8)","v":{"v":0.21407333994053518,"d":"21.4%"}},{"v":2500,"d":"2,500.00 €"},{"$f":"E11*12","v":{"v":30000,"d":"30,000.00 €"}},{"$f":"IF(F8=0,\"\",F11/F8)","v":{"v":0.29732408325074333,"d":"29.7%"}}]
["Rohgewinn II",null,{"$f":"C10-C11","v":{"v":38930,"d":"38,930.00 €"}},{"$f":"IF(C8=0,\"\",C12/C8)","v":{"v":0.7716551040634292,"d":"77.2%"}},null,{"$f":"F10-F11","v":{"v":69100,"d":"69,100.00 €"}},{"$f":"IF(F8=0,\"\",F12/F8)","v":{"v":0.6848364717542121,"d":"68.5%"}}]
[]
["Sonstige betriebliche Kosten"]
["Laden- / Raummiete",{"v":450,"d":"450.00 €"},{"$f":"B15*$B$3","v":{"v":2700,"d":"2,700.00 €"}},null,{"v":550,"d":"550.00 €"},{"$f":"E15*12","v":{"v":6600,"d":"6,600.00 €"}}]
["Raumnebenkosten",{"v":120,"d":"120.00 €"},{"v":720,"d":"720.00 €"},null,{"v":140,"d":"140.00 €"},{"v":1680,"d":"1,680.00 €"}]
["Werbung / Marketing",{"v":250,"d":"250.00 €"},{"v":1500,"d":"1,500.00 €"},null,{"v":300,"d":"300.00 €"},{"v":3600,"d":"3,600.00 €"}]
["Fahrzeugkosten",{"v":90,"d":"90.00 €"},{"v":540,"d":"540.00 €"},null,{"v":110,"d":"110.00 €"},{"v":1320,"d":"1,320.00 €"}]
["Büro / Material",{"v":80,"d":"80.00 €"},{"v":480,"d":"480.00 €"},null,{"v":90,"d":"90.00 €"},{"v":1080,"d":"1,080.00 €"}]
["Telefon / Internet",{"v":70,"d":"70.00 €"},{"v":420,"d":"420.00 €"},null,{"v":80,"d":"80.00 €"},{"v":960,"d":"960.00 €"}]
["Versicherungen",{"v":40,"d":"40.00 €"},{"v":240,"d":"240.00 €"},null,{"v":50,"d":"50.00 €"},{"v":600,"d":"600.00 €"}]
["Rechts- / Steuerberatung",{"v":85,"d":"85.00 €"},{"v":510,"d":"510.00 €"},null,{"v":95,"d":"95.00 €"},{"v":1140,"d":"1,140.00 €"}]
["Fachliteratur",{"v":25,"d":"25.00 €"},{"v":150,"d":"150.00 €"},null,{"v":30,"d":"30.00 €"},{"v":360,"d":"360.00 €"}]
["Beiträge / Gebühren",{"v":30,"d":"30.00 €"},{"v":180,"d":"180.00 €"},null,{"v":35,"d":"35.00 €"},{"v":420,"d":"420.00 €"}]
["Kontoführung",{"v":18,"d":"18.00 €"},{"v":108,"d":"108.00 €"},null,{"v":20,"d":"20.00 €"},{"v":240,"d":"240.00 €"}]
["Sonstiges",{"v":60,"d":"60.00 €"},{"v":360,"d":"360.00 €"},null,{"v":70,"d":"70.00 €"},{"v":840,"d":"840.00 €"}]
["Total sonstige Kosten",null,{"$f":"SUM(C15:C26)","v":{"v":7908,"d":"7,908.00 €"}},{"$f":"IF(C8=0,\"\",C27/C8)","v":{"v":0.15674925668979187,"d":"15.7%"}},null,{"$f":"SUM(F15:F26)","v":{"v":18840,"d":"18,840.00 €"}},{"$f":"IF(F8=0,\"\",F27/F8)","v":{"v":0.1867195242814668,"d":"18.7%"}}]
["Erweiterter Cashflow",null,{"$f":"C12-C27","v":{"v":31022,"d":"31,022.00 €"}},{"$f":"IF(C8=0,\"\",C28/C8)","v":{"v":0.6149058473736373,"d":"61.5%"}},null,{"$f":"F12-F27","v":{"v":50260,"d":"50,260.00 €"}},{"$f":"IF(F8=0,\"\",F28/F8)","v":{"v":0.4981169474727453,"d":"49.8%"}}]
["Zinsen",{"v":60,"d":"60.00 €"},{"$f":"B29*$B$3","v":{"v":360,"d":"360.00 €"}},{"$f":"IF(C8=0,\"\",C29/C8)","v":{"v":0.00713577799801784,"d":"0.7%"}},{"v":60,"d":"60.00 €"},{"$f":"E29*12","v":{"v":720,"d":"720.00 €"}},{"$f":"IF(F8=0,\"\",F29/F8)","v":{"v":0.00713577799801784,"d":"0.7%"}}]
["Cashflow",null,{"$f":"C28-C29","v":{"v":30662,"d":"30,662.00 €"}},{"$f":"IF(C8=0,\"\",C30/C8)","v":{"v":0.6077700693756194,"d":"60.8%"}},null,{"$f":"F28-F29","v":{"v":49540,"d":"49,540.00 €"}},{"$f":"IF(F8=0,\"\",F30/F8)","v":{"v":0.4909811694747275,"d":"49.1%"}}]
["Abschreibungen",{"v":200,"d":"200.00 €"},{"$f":"B31*$B$3","v":{"v":1200,"d":"1,200.00 €"}},{"$f":"IF(C8=0,\"\",C31/C8)","v":{"v":0.023785926660059464,"d":"2.4%"}},{"v":260,"d":"260.00 €"},{"$f":"E31*12","v":{"v":3120,"d":"3,120.00 €"}},{"$f":"IF(F8=0,\"\",F31/F8)","v":{"v":0.030921704658077306,"d":"3.1%"}}]
["Betriebsergebnis",null,{"$f":"C30-C31","v":{"v":29462,"d":"29,462.00 €"}},{"$f":"IF(C8=0,\"\",C32/C8)","v":{"v":0.58398414271556,"d":"58.4%"}},null,{"$f":"F30-F31","v":{"v":46420,"d":"46,420.00 €"}},{"$f":"IF(F8=0,\"\",F32/F8)","v":{"v":0.46005946481665017,"d":"46.0%"}}]

{"sheet":"Liquiditaetsplanung","index":5,"n_rows":38,"n_cols":14,"rows_kept":38,"merged":[[0,0,1,13],[3,0,3,13],[13,0,13,13],[29,0,29,13],[33,0,33,13]]}
["Liquiditätsplanung"]
[]
["Anfangsliquidität",{"v":15000,"d":"15,000.00 €"}]
["Einzahlungen"]
[null,"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez","Gesamt"]
["Umsatzerlöse 1",{"v":2500,"d":"2,500.00 €"},{"v":3000,"d":"3,000.00 €"},{"v":4000,"d":"4,000.00 €"},{"v":4500,"d":"4,500.00 €"},{"v":5500,"d":"5,500.00 €"},{"v":6000,"d":"6,000.00 €"},{"v":6500,"d":"6,500.00 €"},{"v":7500,"d":"7,500.00 €"},{"v":8000,"d":"8,000.00 €"},{"v":9000,"d":"9,000.00 €"},{"v":10000,"d":"10,000.00 €"},{"v":11000,"d":"11,000.00 €"},{"$f":"SUM(B6:M6)","v":{"v":77500,"d":"77,500.00 €"}}]
["Umsatzerlöse 2",0,{"v":300,"d":"300.00 €"},{"v":600,"d":"600.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1200,"d":"1,200.00 €"},{"v":1500,"d":"1,500.00 €"},{"v":1800,"d":"1,800.00 €"},{"v":2200,"d":"2,200.00 €"},{"v":2600,"d":"2,600.00 €"},{"v":2800,"d":"2,800.00 €"},{"v":3000,"d":"3,000.00 €"},{"v":3300,"d":"3,300.00 €"},{"v":20300,"d":"20,300.00 €"}]
["Sonstige Einzahlungen",{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":200,"d":"200.00 €"},{"v":200,"d":"200.00 €"},{"v":200,"d":"200.00 €"},0,0,0,{"v":2400,"d":"2,400.00 €"}]
["Zuschüsse",{"v":5000,"d":"5,000.00 €"},0,0,0,0,0,0,0,0,0,0,0,{"v":5000,"d":"5,000.00 €"}]
["Private Einlagen",{"v":2000,"d":"2,000.00 €"},0,0,0,0,0,0,0,0,0,0,0,{"v":2000,"d":"2,000.00 €"}]
["Sonstiges",0,0,0,0,0,0,0,0,0,0,0,0,0]
["Summe Einzahlungen",{"$f":"SUM(B6:B11)","v":{"v":9800,"d":"9,800.00 €"}},{"v":3600,"d":"3,600.00 €"},{"v":4900,"d":"4,900.00 €"},{"v":5800,"d":"5,800.00 €"},{"v":7000,"d":"7,000.00 €"},{"v":7800,"d":"7,800.00 €"},{"v":8500,"d":"8,500.00 €"},{"v":9900,"d":"9,900.00 €"},{"v":10800,"d":"10,800.00 €"},{"v":11800,"d":"11,800.00 €"},{"v":13000,"d":"13,000.00 €"},{"v":14300,"d":"14,300.00 €"},{"v":107200,"d":"107,200.00 €"}]
[]
["Auszahlungen"]
[null,"Jan","Feb","Mär","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez","Gesamt"]
["Investitionen",{"v":6000,"d":"6,000.00 €"},{"v":3000,"d":"3,000.00 €"},{"v":1500,"d":"1,500.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":500,"d":"500.00 €"},0,0,0,0,0,0,0,{"$f":"SUM(B16:M16)","v":{"v":12000,"d":"12,000.00 €"}}]
["Personalkosten Geschäftsführung",{"v":1800,"d":"1,800.00 €"},{"v":1800,"d":"1,800.00 €"},{"v":1800,"d":"1,800.00 €"},{"v":1800,"d":"1,800.00 €"},{"v":1800,"d":"1,800.00 €"},{"v":1800,"d":"1,800.00 €"},{"v":1800,"d":"1,800.00 €"},{"v":1800,"d":"1,800.00 €"},{"v":1800,"d":"1,800.00 €"},{"v":1800,"d":"1,800.00 €"},{"v":1800,"d":"1,800.00 €"},{"v":1800,"d":"1,800.00 €"},{"v":21600,"d":"21,600.00 €"}]
["Personalkosten Mitarbeiter",0,0,0,0,0,0,{"v":900,"d":"900.00 €"},{"v":900,"d":"900.00 €"},{"v":900,"d":"900.00 €"},{"v":900,"d":"900.00 €"},{"v":900,"d":"900.00 €"},{"v":900,"d":"900.00 €"},{"v":5400,"d":"5,400.00 €"}]
["Material / Waren",{"v":150,"d":"150.00 €"},{"v":180,"d":"180.00 €"},{"v":220,"d":"220.00 €"},{"v":250,"d":"250.00 €"},{"v":300,"d":"300.00 €"},{"v":350,"d":"350.00 €"},{"v":380,"d":"380.00 €"},{"v":420,"d":"420.00 €"},{"v":450,"d":"450.00 €"},{"v":500,"d":"500.00 €"},{"v":550,"d":"550.00 €"},{"v":600,"d":"600.00 €"},{"v":4350,"d":"4,350.00 €"}]
["Laufende Betriebsausgaben",{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":1000,"d":"1,000.00 €"},{"v":12000,"d":"12,000.00 €"}]
["Marketing",{"v":500,"d":"500.00 €"},{"v":500,"d":"500.00 €"},{"v":400,"d":"400.00 €"},{"v":400,"d":"400.00 €"},{"v":350,"d":"350.00 €"},{"v":350,"d":"350.00 €"},{"v":300,"d":"300.00 €"},{"v":300,"d":"300.00 €"},{"v":250,"d":"250.00 €"},{"v":250,"d":"250.00 €"},{"v":250,"d":"250.00 €"},{"v":250,"d":"250.00 €"},{"v":4100,"d":"4,100.00 €"}]
["Miete / Nebenkosten",{"v":650,"d":"650.00 €"},{"v":650,"d":"650.00 €"},{"v":650,"d":"650.00 €"},{"v":650,"d":"650.00 €"},{"v":650,"d":"650.00 €"},{"v":650,"d":"650.00 €"},{"v":650,"d":"650.00 €"},{"v":650,"d":"650.00 €"},{"v":650,"d":"650.00 €"},{"v":650,"d":"650.00 €"},{"v":650,"d":"650.00 €"},{"v":650,"d":"650.00 €"},{"v":7800,"d":"7,800.00 €"}]
["Zinsen",{"v":60,"d":"60.00 €"},{"v":60,"d":"60.00 €"},{"v":60,"d":"60.00 €"},{"v":60,"d":"60.00 €"},{"v":60,"d":"60.00 €"},{"v":60,"d":"60.00 €"},{"v":60,"d":"60.00 €"},{"v":60,"d":"60.00 €"},{"v":60,"d":"60.00 €"},{"v":60,"d":"60.00 €"},{"v":60,"d":"60.00 €"},{"v":60,"d":"60.00 €"},{"v":720,"d":"720.00 €"}]
["Tilgung",0,0,0,{"v":250,"d":"250.00 €"},{"v":250,"d":"250.00 €"},{"v":250,"d":"250.00 €"},{"v":250,"d":"250.00 €"},{"v":250,"d":"250.00 €"},{"v":250,"d":"250.00 €"},{"v":250,"d":"250.00 €"},{"v":250,"d":"250.00 €"},{"v":250,"d":"250.00 €"},{"v":2250,"d":"2,250.00 €"}]
["Umsatzsteuer",0,0,{"v":350,"d":"350.00 €"},0,0,{"v":450,"d":"450.00 €"},0,0,{"v":600,"d":"600.00 €"},0,0,{"v":750,"d":"750.00 €"},{"v":2150,"d":"2,150.00 €"}]
["Sonstige Steuern",0,0,0,0,0,0,0,0,{"v":300,"d":"300.00 €"},0,0,{"v":300,"d":"300.00 €"},{"v":600,"d":"600.00 €"}]
["Privatentnahmen",{"v":1500,"d":"1,500.00 €"},{"v":1500,"d":"1,500.00 €"},{"v":1500,"d":"1,500.00 €"},{"v":1500,"d":"1,500.00 €"},{"v":1500,"d":"1,500.00 €"},{"v":1500,"d":"1,500.00 €"},{"v":1500,"d":"1,500.00 €"},{"v":1500,"d":"1,500.00 €"},{"v":1500,"d":"1,500.00 €"},{"v":1500,"d":"1,500.00 €"},{"v":1500,"d":"1,500.00 €"},{"v":1500,"d":"1,500.00 €"},{"v":18000,"d":"18,000.00 €"}]
["Sonstiges",{"v":120,"d":"120.00 €"},{"v":120,"d":"120.00 €"},{"v":150,"d":"150.00 €"},{"v":120,"d":"120.00 €"},{"v":120,"d":"120.00 €"},{"v":120,"d":"120.00 €"},{"v":120,"d":"120.00 €"},{"v":150,"d":"150.00 €"},{"v":150,"d":"150.00 €"},{"v":150,"d":"150.00 €"},{"v":150,"d":"150.00 €"},{"v":150,"d":"150.00 €"},{"v":1620,"d":"1,620.00 €"}]
["Summe Auszahlungen",{"$f":"SUM(B16:B28)","v":{"v":11780,"d":"11,780.00 €"}},{"v":8810,"d":"8,810.00 €"},{"v":7630,"d":"7,630.00 €"},{"v":7030,"d":"7,030.00 €"},{"v":6530,"d":"6,530.00 €"},{"v":6530,"d":"6,530.00 €"},{"v":6960,"d":"6,960.00 €"},{"v":7030,"d":"7,030.00 €"},{"v":7910,"d":"7,910.00 €"},{"v":7060,"d":"7,060.00 €"},{"v":7110,"d":"7,110.00 €"},{"v":8210,"d":"8,210.00 €"},{"v":92590,"d":"92,590.00 €"}]
["Ergebnis"]
["Überschuss / Fehlbetrag",{"$f":"B12-B29","v":{"v":-1980,"d":"(1,980.00 €)"}},{"v":-5210,"d":"(5,210.00 €)"},{"v":-2730,"d":"(2,730.00 €)"},{"v":-1230,"d":"(1,230.00 €)"},{"v":470,"d":"470.00 €"},{"v":1270,"d":"1,270.00 €"},{"v":1540,"d":"1,540.00 €"},{"v":2870,"d":"2,870.00 €"},{"v":2890,"d":"2,890.00 €"},{"v":4740,"d":"4,740.00 €"},{"v":5890,"d":"5,890.00 €"},{"v":6090,"d":"6,090.00 €"},{"v":14610,"d":"14,610.00 €"}]
["Kumulierte Liquidität",{"$f":"$B$3+B31","v":{"v":13020,"d":"13,020.00 €"}},{"$f":"B32+C31","v":{"v":7810,"d":"7,810.00 €"}},{"v":5080,"d":"5,080.00 €"},{"v":3850,"d":"3,850.00 €"},{"v":4320,"d":"4,320.00 €"},{"v":5590,"d":"5,590.00 €"},{"v":7130,"d":"7,130.00 €"},{"v":10000,"d":"10,000.00 €"},{"v":12890,"d":"12,890.00 €"},{"v":17630,"d":"17,630.00 €"},{"v":23520,"d":"23,520.00 €"},{"v":29610,"d":"29,610.00 €"},{"$f":"M32","v":{"v":29610,"d":"29,610.00 €"}}]
[]
["Abgleich"]
["Jahresumsatz netto lt. Umsatzplanung",{"$nulls":12},{"$f":"Umsatzplanung!$I$31","v":{"v":100900,"d":"100,900.00 €"}}]
["Jahresumsatz aus Liquiditätsplanung (Umsatzerlöse 1+2)",{"$nulls":12},{"$f":"N6+N7","v":{"v":97800,"d":"97,800.00 €"}}]
["Abweichung",{"$nulls":12},{"$f":"N36-N35","v":{"v":-3100,"d":"(3,100.00 €)"}}]
["Status",{"$nulls":12},{"$f":"IF(ABS(N37)<=N35*0.1,\"Plausibel\",\"Bitte prüfen\")","v":"Plausibel"}]

{"sheet":"Unternehmerlohn","index":6,"n_rows":21,"n_cols":2,"rows_kept":21,"merged":[[0,0,1,2],[3,0,3,2],[20,0,21,2]]}
["Unternehmerlohn"]
[]
[]
["Private Ausgaben pro Jahr"]
["Kranken- und Pflegeversicherung",{"v":3000,"d":"3,000.00 €"}]
["Altersvorsorge",{"v":2400,"d":"2,400.00 €"}]
["Lebens- / Berufsunfähigkeitsversicherung",{"v":900,"d":"900.00 €"}]
["Sonstige private Versicherungen",{"v":600,"d":"600.00 €"}]
["Miete und Nebenkosten privat",{"v":10200,"d":"10,200.00 €"}]
["Lebenshaltungskosten",{"v":7200,"d":"7,200.00 €"}]
["Mobilität privat",{"v":1200,"d":"1,200.00 €"}]
["Kinder / Familie",{"v":1800,"d":"1,800.00 €"}]
["Einkommenssteuer privat",{"v":2500,"d":"2,500.00 €"}]
["Sonstige private Ausgaben",{"v":1200,"d":"1,200.00 €"}]
["Summe private Fixkosten pro Jahr",{"$f":"SUM(B5:B14)","v":{"v":31000,"d":"31,000.00 €"}}]
[]
["Zusätzlicher Puffer",{"v":2000,"d":"2,000.00 €"}]
["Unternehmerbedarf pro Monat",{"$f":"B19/12","v":{"v":2750,"d":"2,750.00 €"}}]
["Gesamter Unternehmerbedarf pro Jahr",{"$f":"B15+B17","v":{"v":33000,"d":"33,000.00 €"}}]
[]
["Dieser Wert dient als Orientierung für notwendige Privatentnahmen."]