{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Kapitalbedarf"],"not_rendered":{"charts":1},"read":"whole","date_system":"1900"}

{"sheet":"Kapitalbedarf","index":0,"n_rows":51,"n_cols":26,"rows_kept":51,"merged":[[0,0,0,13],[2,10,2,11],[3,1,3,8],[5,0,5,8],[10,10,10,11],[18,0,18,6],[28,0,28,24],[38,0,38,24],[45,0,45,8]]}
["Kapitalbedarfsplan",{"$nulls":24},0]
[{"$nulls":25},0.07]
["Unternehmen","Beispiel GmbH",null,"Planungsjahr",2026,null,"Währung","EUR",null,null,"Zusammenfassung",{"$nulls":14},0.19]
["Hinweis","Gelbe Felder = Eingabe · Graue Felder = automatisch",{"$nulls":8},"Summe Investitionen (brutto)",{"$f":"G16","v":{"v":31207.4,"d":"€ 31,207.40"}}]
[{"$nulls":10},"Summe Gründungskosten (brutto)",{"$f":"E26","v":{"v":3087,"d":"€ 3,087.00"}}]
["A) Investitionen (einmalig)",{"$nulls":9},"Laufende Auszahlungen (Jahr)",{"$f":"Y37","v":{"v":132772,"d":"€ 132,772.00"}}]
["Kategorie","Position","Menge","Einzelpreis (netto)","MwSt %","Netto (berechnet)","Brutto (berechnet)","Zahlungsmonat","Notiz",null,"Peak Finanzierungsbedarf",{"$f":"MAX(0,-MIN(M51:X51))","v":{"v":33594.9,"d":"€ 33,594.90"}},"Jan","Feb","Mrz","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez","Total 12M"]
["IT","Laptops",3,{"v":1200,"d":"€ 1,200.00"},{"v":0.19,"d":"19.0%"},{"$f":"IF(OR($C8=\"\",$D8=\"\"),\"\",$C8*$D8)","v":{"v":3600,"d":"€ 3,600.00"}},{"$f":"IF($F8=\"\",\"\",$F8*(1+$E8))","v":{"v":4284,"d":"€ 4,284.00"}},1,"Arbeitsgeräte",null,"Reserve/Puffer (Eingabe)",{"v":5000,"d":"€ 5,000.00"},{"$f":"IF($H8=1,$G8,0)","v":{"v":4284,"d":"€ 4,284.00"}},{"$f":"IF($H8=2,$G8,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($H8=3,$G8,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($H8=4,$G8,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($H8=5,$G8,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($H8=6,$G8,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($H8=7,$G8,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($H8=8,$G8,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($H8=9,$G8,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($H8=10,$G8,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($H8=11,$G8,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($H8=12,$G8,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUM(M8:X8)","v":{"v":4284,"d":"€ 4,284.00"}}]
["Büro","Schreibtische",4,{"v":250,"d":"€ 250.00"},{"v":0.19,"d":"19.0%"},{"v":1000,"d":"€ 1,000.00"},{"v":1190,"d":"€ 1,190.00"},1,"",null,"Gesamtkapitalbedarf",{"$f":"L7+L8","v":{"v":38594.9,"d":"€ 38,594.90"}},{"v":1190,"d":"€ 1,190.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":1190,"d":"€ 1,190.00"}]
["Büro","Stühle",4,{"v":140,"d":"€ 140.00"},{"v":0.19,"d":"19.0%"},{"v":560,"d":"€ 560.00"},{"v":666.4,"d":"€ 666.40"},1,"",{"$nulls":3},{"v":666.4,"d":"€ 666.40"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":666.4,"d":"€ 666.40"}]
["Software","ERP/Tools (Setup)",1,{"v":800,"d":"€ 800.00"},{"v":0.19,"d":"19.0%"},{"v":800,"d":"€ 800.00"},{"v":952,"d":"€ 952.00"},2,"Einmalig",null,"Finanzierung",null,{"v":0,"d":"€ 0.00"},{"v":952,"d":"€ 952.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":952,"d":"€ 952.00"}]
["Marketing","Branding & Design",1,{"v":1500,"d":"€ 1,500.00"},{"v":0.19,"d":"19.0%"},{"v":1500,"d":"€ 1,500.00"},{"v":1785,"d":"€ 1,785.00"},2,"",null,"Eigenkapital",{"v":25000,"d":"€ 25,000.00"},{"v":0,"d":"€ 0.00"},{"v":1785,"d":"€ 1,785.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":1785,"d":"€ 1,785.00"}]
["Fahrzeug","Lieferwagen (Anzahlung)",1,{"v":5000,"d":"€ 5,000.00"},{"v":0.19,"d":"19.0%"},{"v":5000,"d":"€ 5,000.00"},{"v":5950,"d":"€ 5,950.00"},3,"Anzahlung",null,"Bankdarlehen",{"v":20000,"d":"€ 20,000.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":5950,"d":"€ 5,950.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":5950,"d":"€ 5,950.00"}]
["Maschinen","Produktionsgerät",1,{"v":12000,"d":"€ 12,000.00"},{"v":0.19,"d":"19.0%"},{"v":12000,"d":"€ 12,000.00"},{"v":14280,"d":"€ 14,280.00"},3,"",null,"Fördermittel/Zuschüsse",{"v":5000,"d":"€ 5,000.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":14280,"d":"€ 14,280.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":14280,"d":"€ 14,280.00"}]
["Sonstiges","Kaution Büro",1,{"v":2100,"d":"€ 2,100.00"},{"v":0,"d":"0.0%"},{"v":2100,"d":"€ 2,100.00"},{"v":2100,"d":"€ 2,100.00"},1,"3 Monatsmieten",null,"Gesellschafterdarlehen",{"v":0,"d":"€ 0.00"},{"v":2100,"d":"€ 2,100.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":2100,"d":"€ 2,100.00"}]
[{"$nulls":4},"Summe Investitionen",{"$f":"SUM(F8:F15)","v":{"v":26560,"d":"€ 26,560.00"}},{"$f":"SUM(G8:G15)","v":{"v":31207.4,"d":"€ 31,207.40"}},{"$nulls":3},"Sonstiges",{"v":0,"d":"€ 0.00"}]
[null,"Investitionen pro Monat",{"$nulls":8},"Summe Finanzierung",{"$f":"SUM(L12:L16)","v":{"v":50000,"d":"€ 50,000.00"}},{"$f":"SUM(M8:M15)","v":{"v":8240.4,"d":"€ 8,240.40"}},{"v":2737,"d":"€ 2,737.00"},{"v":20230,"d":"€ 20,230.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"$f":"SUM(M17:X17)","v":{"v":31207.4,"d":"€ 31,207.40"}}]
[{"$nulls":10},"Finanzierungslücke",{"$f":"L9-L17","v":{"v":-11405.099999999999,"d":"-€ 11,405.10"}}]
["B) Gründungskosten (einmalig)"]
["Kategorie","Position","Betrag (netto)","MwSt %","Brutto (berechnet)","Zahlungsmonat","Notiz",{"$nulls":5},"Jan","Feb","Mrz","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez","Total 12M"]
["Recht","Notar & Gründung",{"v":900,"d":"€ 900.00"},{"v":0.19,"d":"19.0%"},{"$f":"IF($C21=\"\",\"\",$C21*(1+$D21))","v":{"v":1071,"d":"€ 1,071.00"}},1,"",{"$nulls":5},{"$f":"IF($F21=1,$E21,0)","v":{"v":1071,"d":"€ 1,071.00"}},{"$f":"IF($F21=2,$E21,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F21=3,$E21,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F21=4,$E21,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F21=5,$E21,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F21=6,$E21,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F21=7,$E21,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F21=8,$E21,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F21=9,$E21,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F21=10,$E21,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F21=11,$E21,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F21=12,$E21,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUM(M21:X21)","v":{"v":1071,"d":"€ 1,071.00"}}]
["Behörden","Gebühren/Registrierung",{"v":350,"d":"€ 350.00"},{"v":0,"d":"0.0%"},{"$f":"IF($C22=\"\",\"\",$C22*(1+$D22))","v":{"v":350,"d":"€ 350.00"}},1,"",{"$nulls":5},{"$f":"IF($F22=1,$E22,0)","v":{"v":350,"d":"€ 350.00"}},{"$f":"IF($F22=2,$E22,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F22=3,$E22,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F22=4,$E22,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F22=5,$E22,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F22=6,$E22,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F22=7,$E22,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F22=8,$E22,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F22=9,$E22,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F22=10,$E22,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F22=11,$E22,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F22=12,$E22,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUM(M22:X22)","v":{"v":350,"d":"€ 350.00"}}]
["Web","Website (Setup)",{"v":600,"d":"€ 600.00"},{"v":0.19,"d":"19.0%"},{"$f":"IF($C23=\"\",\"\",$C23*(1+$D23))","v":{"v":714,"d":"€ 714.00"}},2,"",{"$nulls":5},{"$f":"IF($F23=1,$E23,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F23=2,$E23,0)","v":{"v":714,"d":"€ 714.00"}},{"$f":"IF($F23=3,$E23,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F23=4,$E23,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F23=5,$E23,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F23=6,$E23,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F23=7,$E23,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F23=8,$E23,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F23=9,$E23,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F23=10,$E23,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F23=11,$E23,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F23=12,$E23,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUM(M23:X23)","v":{"v":714,"d":"€ 714.00"}}]
["Beratung","Steuerberater (Setup)",{"v":500,"d":"€ 500.00"},{"v":0.19,"d":"19.0%"},{"$f":"IF($C24=\"\",\"\",$C24*(1+$D24))","v":{"v":595,"d":"€ 595.00"}},1,"",{"$nulls":5},{"$f":"IF($F24=1,$E24,0)","v":{"v":595,"d":"€ 595.00"}},{"$f":"IF($F24=2,$E24,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F24=3,$E24,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F24=4,$E24,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F24=5,$E24,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F24=6,$E24,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F24=7,$E24,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F24=8,$E24,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F24=9,$E24,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F24=10,$E24,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F24=11,$E24,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F24=12,$E24,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUM(M24:X24)","v":{"v":595,"d":"€ 595.00"}}]
["Versicherung","Betriebshaftpflicht (Start)",{"v":300,"d":"€ 300.00"},{"v":0.19,"d":"19.0%"},{"$f":"IF($C25=\"\",\"\",$C25*(1+$D25))","v":{"v":357,"d":"€ 357.00"}},2,"",{"$nulls":5},{"$f":"IF($F25=1,$E25,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F25=2,$E25,0)","v":{"v":357,"d":"€ 357.00"}},{"$f":"IF($F25=3,$E25,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F25=4,$E25,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F25=5,$E25,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F25=6,$E25,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F25=7,$E25,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F25=8,$E25,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F25=9,$E25,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F25=10,$E25,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F25=11,$E25,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($F25=12,$E25,0)","v":{"v":0,"d":"€ 0.00"}},{"$f":"SUM(M25:X25)","v":{"v":357,"d":"€ 357.00"}}]
[null,"Summe Gründungskosten",{"$f":"SUM(C21:C25)","v":{"v":2650,"d":"€ 2,650.00"}},null,{"$f":"SUM(E21:E25)","v":{"v":3087,"d":"€ 3,087.00"}}]
[null,"Gründungskosten pro Monat",{"$nulls":10},{"$f":"SUM(M21:M25)","v":{"v":2016,"d":"€ 2,016.00"}},{"v":1071,"d":"€ 1,071.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"v":0,"d":"€ 0.00"},{"$f":"SUM(M27:X27)","v":{"v":3087,"d":"€ 3,087.00"}}]
[]
["C) Laufende Kosten (monatlich)"]
["Kostenart","Position","Monatlicher Betrag (netto)","MwSt %","Monatlicher Betrag (brutto)","Startmonat","Endmonat","Steigerung %/Monat","Notiz",{"$nulls":3},"Jan","Feb","Mrz","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez","Total Jahr"]
["Miete","Büromiete",{"v":1200,"d":"€ 1,200.00"},{"v":0,"d":"0.0%"},{"$f":"IF($C31=\"\",\"\",$C31*(1+$D31))","v":{"v":1200,"d":"€ 1,200.00"}},1,12,null,"",{"$nulls":3},{"$f":"IF($E31=\"\",\"\",IF(1<$F31,0,IF(1>$G31,0,$E31)))","v":{"v":1200,"d":"€ 1,200.00"}},{"$f":"IF($E31=\"\",\"\",IF(2<$F31,0,IF(2>$G31,0,$E31)))","v":{"v":1200,"d":"€ 1,200.00"}},{"$f":"IF($E31=\"\",\"\",IF(3<$F31,0,IF(3>$G31,0,$E31)))","v":{"v":1200,"d":"€ 1,200.00"}},{"$f":"IF($E31=\"\",\"\",IF(4<$F31,0,IF(4>$G31,0,$E31)))","v":{"v":1200,"d":"€ 1,200.00"}},{"$f":"IF($E31=\"\",\"\",IF(5<$F31,0,IF(5>$G31,0,$E31)))","v":{"v":1200,"d":"€ 1,200.00"}},{"$f":"IF($E31=\"\",\"\",IF(6<$F31,0,IF(6>$G31,0,$E31)))","v":{"v":1200,"d":"€ 1,200.00"}},{"$f":"IF($E31=\"\",\"\",IF(7<$F31,0,IF(7>$G31,0,$E31)))","v":{"v":1200,"d":"€ 1,200.00"}},{"$f":"IF($E31=\"\",\"\",IF(8<$F31,0,IF(8>$G31,0,$E31)))","v":{"v":1200,"d":"€ 1,200.00"}},{"$f":"IF($E31=\"\",\"\",IF(9<$F31,0,IF(9>$G31,0,$E31)))","v":{"v":1200,"d":"€ 1,200.00"}},{"$f":"IF($E31=\"\",\"\",IF(10<$F31,0,IF(10>$G31,0,$E31)))","v":{"v":1200,"d":"€ 1,200.00"}},{"$f":"IF($E31=\"\",\"\",IF(11<$F31,0,IF(11>$G31,0,$E31)))","v":{"v":1200,"d":"€ 1,200.00"}},{"$f":"IF($E31=\"\",\"\",IF(12<$F31,0,IF(12>$G31,0,$E31)))","v":{"v":1200,"d":"€ 1,200.00"}},{"$f":"IF($E31=\"\",\"\",SUM(M31:X31))","v":{"v":14400,"d":"€ 14,400.00"}}]
["Personal","Gehälter",{"v":8000,"d":"€ 8,000.00"},{"v":0,"d":"0.0%"},{"v":8000,"d":"€ 8,000.00"},1,12,null,"",{"$nulls":3},{"v":8000,"d":"€ 8,000.00"},{"v":8000,"d":"€ 8,000.00"},{"v":8000,"d":"€ 8,000.00"},{"v":8000,"d":"€ 8,000.00"},{"v":8000,"d":"€ 8,000.00"},{"v":8000,"d":"€ 8,000.00"},{"v":8000,"d":"€ 8,000.00"},{"v":8000,"d":"€ 8,000.00"},{"v":8000,"d":"€ 8,000.00"},{"v":8000,"d":"€ 8,000.00"},{"v":8000,"d":"€ 8,000.00"},{"v":8000,"d":"€ 8,000.00"},{"v":96000,"d":"€ 96,000.00"}]
["Software","SaaS Abos",{"v":350,"d":"€ 350.00"},{"v":0.19,"d":"19.0%"},{"v":416.5,"d":"€ 416.50"},1,12,null,"",{"$nulls":3},{"v":416.5,"d":"€ 416.50"},{"v":416.5,"d":"€ 416.50"},{"v":416.5,"d":"€ 416.50"},{"v":416.5,"d":"€ 416.50"},{"v":416.5,"d":"€ 416.50"},{"v":416.5,"d":"€ 416.50"},{"v":416.5,"d":"€ 416.50"},{"v":416.5,"d":"€ 416.50"},{"v":416.5,"d":"€ 416.50"},{"v":416.5,"d":"€ 416.50"},{"v":416.5,"d":"€ 416.50"},{"v":416.5,"d":"€ 416.50"},{"v":4998,"d":"€ 4,998.00"}]
["Marketing","Online Ads",{"v":1000,"d":"€ 1,000.00"},{"v":0.19,"d":"19.0%"},{"v":1190,"d":"€ 1,190.00"},2,12,null,"",{"$nulls":3},{"v":0,"d":"€ 0.00"},{"v":1190,"d":"€ 1,190.00"},{"v":1190,"d":"€ 1,190.00"},{"v":1190,"d":"€ 1,190.00"},{"v":1190,"d":"€ 1,190.00"},{"v":1190,"d":"€ 1,190.00"},{"v":1190,"d":"€ 1,190.00"},{"v":1190,"d":"€ 1,190.00"},{"v":1190,"d":"€ 1,190.00"},{"v":1190,"d":"€ 1,190.00"},{"v":1190,"d":"€ 1,190.00"},{"v":1190,"d":"€ 1,190.00"},{"v":13090,"d":"€ 13,090.00"}]
["Versicherung","Versicherungen",{"v":180,"d":"€ 180.00"},{"v":0.19,"d":"19.0%"},{"v":214.2,"d":"€ 214.20"},1,12,null,"",{"$nulls":3},{"v":214.2,"d":"€ 214.20"},{"v":214.2,"d":"€ 214.20"},{"v":214.2,"d":"€ 214.20"},{"v":214.2,"d":"€ 214.20"},{"v":214.2,"d":"€ 214.20"},{"v":214.2,"d":"€ 214.20"},{"v":214.2,"d":"€ 214.20"},{"v":214.2,"d":"€ 214.20"},{"v":214.2,"d":"€ 214.20"},{"v":214.2,"d":"€ 214.20"},{"v":214.2,"d":"€ 214.20"},{"v":214.2,"d":"€ 214.20"},{"v":2570.3999999999996,"d":"€ 2,570.40"}]
["Sonstiges","Bürobedarf",{"v":120,"d":"€ 120.00"},{"v":0.19,"d":"19.0%"},{"v":142.79999999999998,"d":"€ 142.80"},1,12,null,"",{"$nulls":3},{"v":142.79999999999998,"d":"€ 142.80"},{"v":142.79999999999998,"d":"€ 142.80"},{"v":142.79999999999998,"d":"€ 142.80"},{"v":142.79999999999998,"d":"€ 142.80"},{"v":142.79999999999998,"d":"€ 142.80"},{"v":142.79999999999998,"d":"€ 142.80"},{"v":142.79999999999998,"d":"€ 142.80"},{"v":142.79999999999998,"d":"€ 142.80"},{"v":142.79999999999998,"d":"€ 142.80"},{"v":142.79999999999998,"d":"€ 142.80"},{"v":142.79999999999998,"d":"€ 142.80"},{"v":142.79999999999998,"d":"€ 142.80"},{"v":1713.5999999999997,"d":"€ 1,713.60"}]
[null,"Summe laufende Auszahlungen",{"$nulls":10},{"$f":"SUM(M31:M36)","v":{"v":9973.5,"d":"€ 9,973.50"}},{"v":11163.5,"d":"€ 11,163.50"},{"v":11163.5,"d":"€ 11,163.50"},{"v":11163.5,"d":"€ 11,163.50"},{"v":11163.5,"d":"€ 11,163.50"},{"v":11163.5,"d":"€ 11,163.50"},{"v":11163.5,"d":"€ 11,163.50"},{"v":11163.5,"d":"€ 11,163.50"},{"v":11163.5,"d":"€ 11,163.50"},{"v":11163.5,"d":"€ 11,163.50"},{"v":11163.5,"d":"€ 11,163.50"},{"v":11163.5,"d":"€ 11,163.50"},{"$f":"SUM(M37:X37)","v":{"v":132772,"d":"€ 132,772.00"}}]
[]
["D) Einnahmen (optional)"]
["Einnahmeart","Position","Monatlicher Betrag","Startmonat","Endmonat","Steigerung %/Monat","Notiz",{"$nulls":5},"Jan","Feb","Mrz","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez","Total Jahr"]
["Umsatz","Produktverkäufe",{"v":12000,"d":"€ 12,000.00"},2,12,null,"",{"$nulls":5},{"$f":"IF($C41=\"\",\"\",IF(1<$D41,0,IF(1>$E41,0,$C41)))","v":{"v":0,"d":"€ 0.00"}},{"$f":"IF($C41=\"\",\"\",IF(2<$D41,0,IF(2>$E41,0,$C41)))","v":{"v":12000,"d":"€ 12,000.00"}},{"$f":"IF($C41=\"\",\"\",IF(3<$D41,0,IF(3>$E41,0,$C41)))","v":{"v":12000,"d":"€ 12,000.00"}},{"$f":"IF($C41=\"\",\"\",IF(4<$D41,0,IF(4>$E41,0,$C41)))","v":{"v":12000,"d":"€ 12,000.00"}},{"$f":"IF($C41=\"\",\"\",IF(5<$D41,0,IF(5>$E41,0,$C41)))","v":{"v":12000,"d":"€ 12,000.00"}},{"$f":"IF($C41=\"\",\"\",IF(6<$D41,0,IF(6>$E41,0,$C41)))","v":{"v":12000,"d":"€ 12,000.00"}},{"$f":"IF($C41=\"\",\"\",IF(7<$D41,0,IF(7>$E41,0,$C41)))","v":{"v":12000,"d":"€ 12,000.00"}},{"$f":"IF($C41=\"\",\"\",IF(8<$D41,0,IF(8>$E41,0,$C41)))","v":{"v":12000,"d":"€ 12,000.00"}},{"$f":"IF($C41=\"\",\"\",IF(9<$D41,0,IF(9>$E41,0,$C41)))","v":{"v":12000,"d":"€ 12,000.00"}},{"$f":"IF($C41=\"\",\"\",IF(10<$D41,0,IF(10>$E41,0,$C41)))","v":{"v":12000,"d":"€ 12,000.00"}},{"$f":"IF($C41=\"\",\"\",IF(11<$D41,0,IF(11>$E41,0,$C41)))","v":{"v":12000,"d":"€ 12,000.00"}},{"$f":"IF($C41=\"\",\"\",IF(12<$D41,0,IF(12>$E41,0,$C41)))","v":{"v":12000,"d":"€ 12,000.00"}},{"$f":"IF($C41=\"\",\"\",SUM(M41:X41))","v":{"v":132000,"d":"€ 132,000.00"}}]
["Umsatz","Service/Retainer",{"v":3000,"d":"€ 3,000.00"},1,12,null,"",{"$nulls":5},{"$f":"IF($C42=\"\",\"\",IF(1<$D42,0,IF(1>$E42,0,$C42)))","v":{"v":3000,"d":"€ 3,000.00"}},{"$f":"IF($C42=\"\",\"\",IF(2<$D42,0,IF(2>$E42,0,$C42)))","v":{"v":3000,"d":"€ 3,000.00"}},{"$f":"IF($C42=\"\",\"\",IF(3<$D42,0,IF(3>$E42,0,$C42)))","v":{"v":3000,"d":"€ 3,000.00"}},{"$f":"IF($C42=\"\",\"\",IF(4<$D42,0,IF(4>$E42,0,$C42)))","v":{"v":3000,"d":"€ 3,000.00"}},{"$f":"IF($C42=\"\",\"\",IF(5<$D42,0,IF(5>$E42,0,$C42)))","v":{"v":3000,"d":"€ 3,000.00"}},{"$f":"IF($C42=\"\",\"\",IF(6<$D42,0,IF(6>$E42,0,$C42)))","v":{"v":3000,"d":"€ 3,000.00"}},{"$f":"IF($C42=\"\",\"\",IF(7<$D42,0,IF(7>$E42,0,$C42)))","v":{"v":3000,"d":"€ 3,000.00"}},{"$f":"IF($C42=\"\",\"\",IF(8<$D42,0,IF(8>$E42,0,$C42)))","v":{"v":3000,"d":"€ 3,000.00"}},{"$f":"IF($C42=\"\",\"\",IF(9<$D42,0,IF(9>$E42,0,$C42)))","v":{"v":3000,"d":"€ 3,000.00"}},{"$f":"IF($C42=\"\",\"\",IF(10<$D42,0,IF(10>$E42,0,$C42)))","v":{"v":3000,"d":"€ 3,000.00"}},{"$f":"IF($C42=\"\",\"\",IF(11<$D42,0,IF(11>$E42,0,$C42)))","v":{"v":3000,"d":"€ 3,000.00"}},{"$f":"IF($C42=\"\",\"\",IF(12<$D42,0,IF(12>$E42,0,$C42)))","v":{"v":3000,"d":"€ 3,000.00"}},{"$f":"IF($C42=\"\",\"\",SUM(M42:X42))","v":{"v":36000,"d":"€ 36,000.00"}}]
[]
[null,"Summe Einzahlungen",{"$nulls":10},{"$f":"SUM(M41:M42)","v":{"v":3000,"d":"€ 3,000.00"}},{"v":15000,"d":"€ 15,000.00"},{"v":15000,"d":"€ 15,000.00"},{"v":15000,"d":"€ 15,000.00"},{"v":15000,"d":"€ 15,000.00"},{"v":15000,"d":"€ 15,000.00"},{"v":15000,"d":"€ 15,000.00"},{"v":15000,"d":"€ 15,000.00"},{"v":15000,"d":"€ 15,000.00"},{"v":15000,"d":"€ 15,000.00"},{"v":15000,"d":"€ 15,000.00"},{"v":15000,"d":"€ 15,000.00"},{"$f":"SUM(M44:X44)","v":{"v":168000,"d":"€ 168,000.00"}}]
[]
["E) Liquidität & Kapitalbedarf"]
["Monat",{"$nulls":11},"Jan","Feb","Mrz","Apr","Mai","Jun","Jul","Aug","Sep","Okt","Nov","Dez","Total"]
["Einzahlungen",{"$nulls":11},{"$f":"M44","v":{"v":3000,"d":"€ 3,000.00"}},{"v":15000,"d":"€ 15,000.00"},{"v":15000,"d":"€ 15,000.00"},{"v":15000,"d":"€ 15,000.00"},{"v":15000,"d":"€ 15,000.00"},{"v":15000,"d":"€ 15,000.00"},{"v":15000,"d":"€ 15,000.00"},{"v":15000,"d":"€ 15,000.00"},{"v":15000,"d":"€ 15,000.00"},{"v":15000,"d":"€ 15,000.00"},{"v":15000,"d":"€ 15,000.00"},{"v":15000,"d":"€ 15,000.00"},{"$f":"SUM(M48:X48)","v":{"v":168000,"d":"€ 168,000.00"}}]
["Auszahlungen",{"$nulls":11},{"$f":"M17+M27+M37","v":{"v":20229.9,"d":"€ 20,229.90"}},{"v":14971.5,"d":"€ 14,971.50"},{"v":31393.5,"d":"€ 31,393.50"},{"v":11163.5,"d":"€ 11,163.50"},{"v":11163.5,"d":"€ 11,163.50"},{"v":11163.5,"d":"€ 11,163.50"},{"v":11163.5,"d":"€ 11,163.50"},{"v":11163.5,"d":"€ 11,163.50"},{"v":11163.5,"d":"€ 11,163.50"},{"v":11163.5,"d":"€ 11,163.50"},{"v":11163.5,"d":"€ 11,163.50"},{"v":11163.5,"d":"€ 11,163.50"},{"$f":"SUM(M49:X49)","v":{"v":167066.4,"d":"€ 167,066.40"}}]
["Netto Cashflow",{"$nulls":11},{"$f":"M48-M49","v":{"v":-17229.9,"d":"-€ 17,229.90"}},{"v":28.5,"d":"€ 28.50"},{"v":-16393.5,"d":"-€ 16,393.50"},{"v":3836.5,"d":"€ 3,836.50"},{"v":3836.5,"d":"€ 3,836.50"},{"v":3836.5,"d":"€ 3,836.50"},{"v":3836.5,"d":"€ 3,836.50"},{"v":3836.5,"d":"€ 3,836.50"},{"v":3836.5,"d":"€ 3,836.50"},{"v":3836.5,"d":"€ 3,836.50"},{"v":3836.5,"d":"€ 3,836.50"},{"v":3836.5,"d":"€ 3,836.50"},{"$f":"SUM(M50:X50)","v":{"v":933.5999999999985,"d":"€ 933.60"}}]
["Kumuliert",{"$nulls":11},{"$f":"M50","v":{"v":-17229.9,"d":"-€ 17,229.90"}},{"$f":"M51+N50","v":{"v":-17201.4,"d":"-€ 17,201.40"}},{"v":-33594.9,"d":"-€ 33,594.90"},{"v":-29758.4,"d":"-€ 29,758.40"},{"v":-25921.9,"d":"-€ 25,921.90"},{"v":-22085.4,"d":"-€ 22,085.40"},{"v":-18248.9,"d":"-€ 18,248.90"},{"v":-14412.400000000001,"d":"-€ 14,412.40"},{"v":-10575.900000000001,"d":"-€ 10,575.90"},{"v":-6739.4000000000015,"d":"-€ 6,739.40"},{"v":-2902.9000000000015,"d":"-€ 2,902.90"},{"v":933.5999999999985,"d":"€ 933.60"},{"$f":"X51","v":{"v":933.5999999999985,"d":"€ 933.60"}}]