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) | |||||||||||||
| Firmenevents19% | 17.850 | 21.420 | 28.560 | 35.700 | 42.840 | 49.980 | 46.410 | 39.270 | 42.840 | 39.270 | 32.130 | 42.840 | 439.110 |
| Privatveranstaltungen19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Messen/Kongresse19% | 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 | 17.850 | 21.420 | 28.560 | 35.700 | 42.840 | 49.980 | 46.410 | 39.270 | 42.840 | 39.270 | 32.130 | 42.840 | 439.110 |
| USt vereinnahmt | 2.850 | 3.420 | 4.560 | 5.700 | 6.840 | 7.980 | 7.410 | 6.270 | 6.840 | 6.270 | 5.130 | 6.840 | 70.110 |
| VARIABLE KOSTEN (BRUTTO) | |||||||||||||
| Catering/Zulieferer19% | 7.140 | 8.568 | 11.424 | 14.280 | 17.136 | 19.992 | 18.564 | 15.708 | 17.136 | 15.708 | 12.852 | 17.136 | 175.644 |
| Event-Personal | 3.750 | 4.500 | 6.000 | 7.500 | 9.000 | 10.500 | 9.750 | 8.250 | 9.000 | 8.250 | 6.750 | 9.000 | 92.250 |
| Technik-/Location-Miete19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Summe Variable Kosten | 10.890 | 13.068 | 17.424 | 21.780 | 26.136 | 30.492 | 28.314 | 23.958 | 26.136 | 23.958 | 19.602 | 26.136 | 267.894 |
| Vorsteuer variabel | 1.140 | 1.368 | 1.824 | 2.280 | 2.736 | 3.192 | 2.964 | 2.508 | 2.736 | 2.508 | 2.052 | 2.736 | 28.044 |
| FIXKOSTEN (BRUTTO) | |||||||||||||
| Büromiete | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 18.000 |
| Nebenkosten19% | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 5.004 |
| Versicherungen | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 6.000 |
| Marketing19% | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 8.568 |
| Steuerberater19% | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 5.712 |
| Lagermiete | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 1.500 | 18.000 |
| Kredit-Tilgung | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 6.000 |
| Summe Fixkosten | 5.607 | 5.607 | 5.607 | 5.607 | 5.607 | 5.607 | 5.607 | 5.607 | 5.607 | 5.607 | 5.607 | 5.607 | 67.284 |
| Vorsteuer fix | 257 | 257 | 257 | 257 | 257 | 257 | 257 | 257 | 257 | 257 | 257 | 257 | 3.084 |
| Gesamtausgaben (brutto) | 16.497 | 18.675 | 23.031 | 27.387 | 31.743 | 36.099 | 33.921 | 29.565 | 31.743 | 29.565 | 25.209 | 31.743 | 335.178 |
| UMSATZSTEUER (Monatlich) | |||||||||||||
| USt-Zahllast (USt − Vorsteuer) | 1.453 | 1.795 | 2.479 | 3.163 | 3.847 | 4.531 | 4.189 | 3.505 | 3.847 | 3.505 | 2.821 | 3.847 | 38.982 |
| USt-Zahlung (Liquiditätswirksam) | 0 | 1.453 | 1.795 | 2.479 | 3.163 | 3.847 | 4.531 | 4.189 | 3.505 | 3.847 | 3.505 | 2.821 | 35.135 |
| Monatssaldo | 1.353 | 2.745 | 5.529 | 8.313 | 11.097 | 13.881 | 12.489 | 9.705 | 11.097 | 9.705 | 6.921 | 11.097 | 103.932 |
| Liquidität kumulativ | 21.353 | 22.645 | 26.379 | 32.213 | 40.147 | 50.181 | 58.139 | 63.655 | 71.247 | 77.105 | 80.521 | 88.797 | 88.797 |