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) | |||||||||||||
| Mitgliedsbeiträge19% | 38.675 | 35.700 | 32.725 | 29.750 | 28.263 | 25.288 | 23.800 | 23.800 | 29.750 | 31.238 | 29.750 | 26.775 | 355.514 |
| Personal Training19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Kurse19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Getränke/Supplements19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Summe Einnahmen | 38.675 | 35.700 | 32.725 | 29.750 | 28.263 | 25.288 | 23.800 | 23.800 | 29.750 | 31.238 | 29.750 | 26.775 | 355.514 |
| USt vereinnahmt | 6.175 | 5.700 | 5.225 | 4.750 | 4.513 | 4.038 | 3.800 | 3.800 | 4.750 | 4.988 | 4.750 | 4.275 | 56.764 |
| VARIABLE KOSTEN (BRUTTO) | |||||||||||||
| Wareneinsatz (Getränke etc.)19% | 1.934 | 1.785 | 1.636 | 1.488 | 1.414 | 1.265 | 1.190 | 1.190 | 1.488 | 1.562 | 1.488 | 1.339 | 17.779 |
| Personal (Trainer) | 9.750 | 9.000 | 8.250 | 7.500 | 7.125 | 6.375 | 6.000 | 6.000 | 7.500 | 7.875 | 7.500 | 6.750 | 89.625 |
| Summe Variable Kosten | 11.684 | 10.785 | 9.886 | 8.988 | 8.539 | 7.640 | 7.190 | 7.190 | 8.988 | 9.437 | 8.988 | 8.089 | 107.404 |
| Vorsteuer variabel | 309 | 285 | 261 | 238 | 226 | 202 | 190 | 190 | 238 | 249 | 238 | 214 | 2.840 |
| FIXKOSTEN (BRUTTO) | |||||||||||||
| Studiomiete | 4.000 | 4.000 | 4.000 | 4.000 | 4.000 | 4.000 | 4.000 | 4.000 | 4.000 | 4.000 | 4.000 | 4.000 | 48.000 |
| Energie19% | 1.428 | 1.428 | 1.428 | 1.428 | 1.428 | 1.428 | 1.428 | 1.428 | 1.428 | 1.428 | 1.428 | 1.428 | 17.136 |
| Versicherungen | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 6.000 |
| Marketing19% | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 11.424 |
| Steuerberater19% | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 5.712 |
| Geräte-Leasing19% | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 7.140 |
| Kredit-Tilgung | 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 |
| Summe Fixkosten | 9.451 | 9.451 | 9.451 | 9.451 | 9.451 | 9.451 | 9.451 | 9.451 | 9.451 | 9.451 | 9.451 | 9.451 | 113.412 |
| Vorsteuer fix | 551 | 551 | 551 | 551 | 551 | 551 | 551 | 551 | 551 | 551 | 551 | 551 | 6.612 |
| Gesamtausgaben (brutto) | 21.135 | 20.236 | 19.337 | 18.439 | 17.990 | 17.091 | 16.641 | 16.641 | 18.439 | 18.888 | 18.439 | 17.540 | 220.816 |
| UMSATZSTEUER (Monatlich) | |||||||||||||
| USt-Zahllast (USt − Vorsteuer) | 5.315 | 4.864 | 4.413 | 3.961 | 3.736 | 3.285 | 3.059 | 3.059 | 3.961 | 4.188 | 3.961 | 3.510 | 47.312 |
| USt-Zahlung (Liquiditätswirksam) | 0 | 5.315 | 4.864 | 4.413 | 3.961 | 3.736 | 3.285 | 3.059 | 3.059 | 3.961 | 4.188 | 3.961 | 43.802 |
| Monatssaldo | 17.540 | 15.464 | 13.388 | 11.311 | 10.273 | 8.197 | 7.159 | 7.159 | 11.311 | 12.350 | 11.311 | 9.235 | 134.698 |
| Liquidität kumulativ | 32.540 | 42.689 | 51.213 | 58.111 | 64.423 | 68.884 | 72.758 | 76.858 | 85.110 | 93.499 | 100.622 | 105.896 | 105.896 |