Anfangsbestand:|USt:|Klicke auf eine Zelle zum Bearbeiten
| Kategorie USt% | Jan | Feb | Mär | Apr | Mai | Jun | Jul | Aug | Sep | Okt | Nov | Dez | Σ Jahr |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EINNAHMEN (BRUTTO) | |||||||||||||
| PR-Retainer19% | 35.403 | 37.485 | 43.733 | 43.733 | 43.733 | 41.650 | 33.320 | 33.320 | 45.815 | 45.815 | 45.815 | 35.403 | 485.225 |
| Kampagnen/Projekte19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Krisenkommunikation19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Events/Pressekonferenzen19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Summe Einnahmen | 35.403 | 37.485 | 43.733 | 43.733 | 43.733 | 41.650 | 33.320 | 33.320 | 45.815 | 45.815 | 45.815 | 35.403 | 485.225 |
| USt vereinnahmt | 5.653 | 5.985 | 6.983 | 6.983 | 6.983 | 6.650 | 5.320 | 5.320 | 7.315 | 7.315 | 7.315 | 5.653 | 77.475 |
| VARIABLE KOSTEN (BRUTTO) | |||||||||||||
| Freelancer/Texter19% | 1.771 | 1.874 | 2.187 | 2.187 | 2.187 | 2.083 | 1.666 | 1.666 | 2.291 | 2.291 | 2.291 | 1.771 | 24.265 |
| Personal | 16.363 | 17.325 | 20.213 | 20.213 | 20.213 | 19.250 | 15.400 | 15.400 | 21.175 | 21.175 | 21.175 | 16.363 | 224.265 |
| Medienmonitoring/Clipping19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Summe Variable Kosten | 18.134 | 19.199 | 22.400 | 22.400 | 22.400 | 21.333 | 17.066 | 17.066 | 23.466 | 23.466 | 23.466 | 18.134 | 248.530 |
| Vorsteuer variabel | 283 | 299 | 349 | 349 | 349 | 333 | 266 | 266 | 366 | 366 | 366 | 283 | 3.875 |
| FIXKOSTEN (BRUTTO) | |||||||||||||
| Büromiete | 1.800 | 1.800 | 1.800 | 1.800 | 1.800 | 1.800 | 1.800 | 1.800 | 1.800 | 1.800 | 1.800 | 1.800 | 21.600 |
| Nebenkosten19% | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 5.004 |
| Versicherungen | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 4.200 |
| Eigenes Marketing19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Steuerberater19% | 536 | 536 | 536 | 536 | 536 | 536 | 536 | 536 | 536 | 536 | 536 | 536 | 6.432 |
| PR-Software/Tools19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Kredit-Tilgung | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Summe Fixkosten | 3.103 | 3.103 | 3.103 | 3.103 | 3.103 | 3.103 | 3.103 | 3.103 | 3.103 | 3.103 | 3.103 | 3.103 | 37.236 |
| Vorsteuer fix | 153 | 153 | 153 | 153 | 153 | 153 | 153 | 153 | 153 | 153 | 153 | 153 | 1.836 |
| Gesamtausgaben (brutto) | 21.237 | 22.302 | 25.503 | 25.503 | 25.503 | 24.436 | 20.169 | 20.169 | 26.569 | 26.569 | 26.569 | 21.237 | 285.766 |
| UMSATZSTEUER (Monatlich) | |||||||||||||
| USt-Zahllast (USt − Vorsteuer) | 5.217 | 5.533 | 6.481 | 6.481 | 6.481 | 6.164 | 4.901 | 4.901 | 6.796 | 6.796 | 6.796 | 5.217 | 71.764 |
| USt-Zahlung (Liquiditätswirksam) | 0 | 5.217 | 5.533 | 6.481 | 6.481 | 6.481 | 6.164 | 4.901 | 4.901 | 6.796 | 6.796 | 6.796 | 66.547 |
| Monatssaldo | 14.166 | 15.183 | 18.230 | 18.230 | 18.230 | 17.214 | 13.151 | 13.151 | 19.246 | 19.246 | 19.246 | 14.166 | 199.459 |
| Liquidität kumulativ | 34.166 | 44.132 | 56.829 | 68.578 | 80.327 | 91.060 | 98.047 | 106.297 | 120.642 | 133.092 | 145.542 | 152.912 | 152.912 |