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) | |||||||||||||
| Kampagnen/Projekte19% | 38.080 | 40.460 | 47.600 | 49.980 | 52.360 | 49.980 | 40.460 | 38.080 | 49.980 | 54.740 | 54.740 | 42.840 | 559.300 |
| Retainer19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Beratung/Strategie19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Sonstige19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Summe Einnahmen | 38.080 | 40.460 | 47.600 | 49.980 | 52.360 | 49.980 | 40.460 | 38.080 | 49.980 | 54.740 | 54.740 | 42.840 | 559.300 |
| USt vereinnahmt | 6.080 | 6.460 | 7.600 | 7.980 | 8.360 | 7.980 | 6.460 | 6.080 | 7.980 | 8.740 | 8.740 | 6.840 | 89.300 |
| VARIABLE KOSTEN (BRUTTO) | |||||||||||||
| Freelancer/Zulieferer19% | 3.046 | 3.237 | 3.808 | 3.998 | 4.189 | 3.998 | 3.237 | 3.046 | 3.998 | 4.379 | 4.379 | 3.427 | 44.742 |
| Personal | 17.600 | 18.700 | 22.000 | 23.100 | 24.200 | 23.100 | 18.700 | 17.600 | 23.100 | 25.300 | 25.300 | 19.800 | 258.500 |
| Ad-Spend (Durchlauf)19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Summe Variable Kosten | 20.646 | 21.937 | 25.808 | 27.098 | 28.389 | 27.098 | 21.937 | 20.646 | 27.098 | 29.679 | 29.679 | 23.227 | 303.242 |
| Vorsteuer variabel | 486 | 517 | 608 | 638 | 669 | 638 | 517 | 486 | 638 | 699 | 699 | 547 | 7.142 |
| FIXKOSTEN (BRUTTO) | |||||||||||||
| Büromiete | 2.000 | 2.000 | 2.000 | 2.000 | 2.000 | 2.000 | 2.000 | 2.000 | 2.000 | 2.000 | 2.000 | 2.000 | 24.000 |
| Nebenkosten19% | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 5.712 |
| 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% | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 7.140 |
| 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.421 | 3.421 | 3.421 | 3.421 | 3.421 | 3.421 | 3.421 | 3.421 | 3.421 | 3.421 | 3.421 | 3.421 | 41.052 |
| Vorsteuer fix | 171 | 171 | 171 | 171 | 171 | 171 | 171 | 171 | 171 | 171 | 171 | 171 | 2.052 |
| Gesamtausgaben (brutto) | 24.067 | 25.358 | 29.229 | 30.519 | 31.810 | 30.519 | 25.358 | 24.067 | 30.519 | 33.100 | 33.100 | 26.648 | 344.294 |
| UMSATZSTEUER (Monatlich) | |||||||||||||
| USt-Zahllast (USt − Vorsteuer) | 5.423 | 5.772 | 6.821 | 7.171 | 7.520 | 7.171 | 5.772 | 5.423 | 7.171 | 7.870 | 7.870 | 6.122 | 80.106 |
| USt-Zahlung (Liquiditätswirksam) | 0 | 5.423 | 5.772 | 6.821 | 7.171 | 7.520 | 7.171 | 5.772 | 5.423 | 7.171 | 7.870 | 7.870 | 73.984 |
| Monatssaldo | 14.013 | 15.102 | 18.371 | 19.461 | 20.550 | 19.461 | 15.102 | 14.013 | 19.461 | 21.640 | 21.640 | 16.192 | 215.006 |
| Liquidität kumulativ | 39.013 | 48.692 | 61.291 | 73.931 | 87.310 | 99.251 | 107.182 | 115.423 | 129.461 | 143.930 | 157.700 | 166.022 | 166.022 |