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) | |||||||||||||
| Fleisch & Wurst7% | 38.520 | 36.380 | 40.660 | 44.940 | 47.080 | 44.940 | 42.800 | 42.800 | 42.800 | 44.940 | 44.940 | 51.360 | 522.160 |
| Mittagstisch19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Catering/Party-Service19% | 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.520 | 36.380 | 40.660 | 44.940 | 47.080 | 44.940 | 42.800 | 42.800 | 42.800 | 44.940 | 44.940 | 51.360 | 522.160 |
| USt vereinnahmt | 2.520 | 2.380 | 2.660 | 2.940 | 3.080 | 2.940 | 2.800 | 2.800 | 2.800 | 2.940 | 2.940 | 3.360 | 34.160 |
| VARIABLE KOSTEN (BRUTTO) | |||||||||||||
| Wareneinkauf (Fleisch)7% | 15.408 | 14.552 | 16.264 | 17.976 | 18.832 | 17.976 | 17.120 | 17.120 | 17.120 | 17.976 | 17.976 | 20.544 | 208.864 |
| Personal (Metzger/Verkauf) | 10.800 | 10.200 | 11.400 | 12.600 | 13.200 | 12.600 | 12.000 | 12.000 | 12.000 | 12.600 | 12.600 | 14.400 | 146.400 |
| Summe Variable Kosten | 26.208 | 24.752 | 27.664 | 30.576 | 32.032 | 30.576 | 29.120 | 29.120 | 29.120 | 30.576 | 30.576 | 34.944 | 355.264 |
| Vorsteuer variabel | 1.008 | 952 | 1.064 | 1.176 | 1.232 | 1.176 | 1.120 | 1.120 | 1.120 | 1.176 | 1.176 | 1.344 | 13.664 |
| FIXKOSTEN (BRUTTO) | |||||||||||||
| Miete/Laden | 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 |
| Energie19% | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 11.424 |
| Versicherungen | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 4.800 |
| Marketing19% | 179 | 179 | 179 | 179 | 179 | 179 | 179 | 179 | 179 | 179 | 179 | 179 | 2.148 |
| Steuerberater19% | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 5.712 |
| Sonstige Fixkosten19% | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 5.712 |
| Kredit-Tilgung | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 7.200 |
| Summe Fixkosten | 5.083 | 5.083 | 5.083 | 5.083 | 5.083 | 5.083 | 5.083 | 5.083 | 5.083 | 5.083 | 5.083 | 5.083 | 60.996 |
| Vorsteuer fix | 333 | 333 | 333 | 333 | 333 | 333 | 333 | 333 | 333 | 333 | 333 | 333 | 3.996 |
| Gesamtausgaben (brutto) | 31.291 | 29.835 | 32.747 | 35.659 | 37.115 | 35.659 | 34.203 | 34.203 | 34.203 | 35.659 | 35.659 | 40.027 | 416.260 |
| UMSATZSTEUER (Monatlich) | |||||||||||||
| USt-Zahllast (USt − Vorsteuer) | 1.179 | 1.095 | 1.263 | 1.431 | 1.515 | 1.431 | 1.347 | 1.347 | 1.347 | 1.431 | 1.431 | 1.683 | 16.500 |
| USt-Zahlung (Liquiditätswirksam) | 0 | 1.179 | 1.095 | 1.263 | 1.431 | 1.515 | 1.431 | 1.347 | 1.347 | 1.347 | 1.431 | 1.431 | 14.817 |
| Monatssaldo | 7.229 | 6.545 | 7.913 | 9.281 | 9.965 | 9.281 | 8.597 | 8.597 | 8.597 | 9.281 | 9.281 | 11.333 | 105.900 |
| Liquidität kumulativ | 17.229 | 22.595 | 29.413 | 37.431 | 45.965 | 53.731 | 60.897 | 68.147 | 75.397 | 83.331 | 91.181 | 101.083 | 101.083 |