← Branche wechseln
🍽
Liquiditätsplan: Gastronomie
12-Monats-Planung mit branchenspezifischen Werten
Anfangsbestand:15.000 €|USt: MonatlichKlicke auf eine Zelle zum Bearbeiten
| Kategorie USt% | Jan | Feb | Mär | Apr | Mai | Jun | Jul | Aug | Sep | Okt | Nov | Dez | Σ Jahr |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EINNAHMEN (BRUTTO) | |||||||||||||
| Speisen19% | 37.485 | 40.163 | 45.518 | 50.873 | 58.905 | 61.583 | 64.260 | 61.583 | 56.228 | 50.873 | 45.518 | 69.615 | 642.604 |
| Getränke19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Catering19% | 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 | 37.485 | 40.163 | 45.518 | 50.873 | 58.905 | 61.583 | 64.260 | 61.583 | 56.228 | 50.873 | 45.518 | 69.615 | 642.604 |
| USt vereinnahmt | 5.985 | 6.413 | 7.268 | 8.123 | 9.405 | 9.833 | 10.260 | 9.833 | 8.978 | 8.123 | 7.268 | 11.115 | 102.604 |
| VARIABLE KOSTEN (BRUTTO) | |||||||||||||
| Wareneinsatz19% | 11.246 | 12.049 | 13.655 | 15.262 | 17.672 | 18.475 | 19.278 | 18.475 | 16.868 | 15.262 | 13.655 | 20.885 | 192.782 |
| Personal | 11.025 | 11.813 | 13.388 | 14.963 | 17.325 | 18.113 | 18.900 | 18.113 | 16.538 | 14.963 | 13.388 | 20.475 | 189.004 |
| Summe Variable Kosten | 22.271 | 23.862 | 27.043 | 30.225 | 34.997 | 36.588 | 38.178 | 36.588 | 33.406 | 30.225 | 27.043 | 41.360 | 381.786 |
| Vorsteuer variabel | 1.796 | 1.924 | 2.180 | 2.437 | 2.822 | 2.950 | 3.078 | 2.950 | 2.693 | 2.437 | 2.180 | 3.335 | 30.782 |
| FIXKOSTEN (BRUTTO) | |||||||||||||
| Miete | 3.500 | 3.500 | 3.500 | 3.500 | 3.500 | 3.500 | 3.500 | 3.500 | 3.500 | 3.500 | 3.500 | 3.500 | 42.000 |
| Nebenkosten19% | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 11.424 |
| Versicherungen | 450 | 450 | 450 | 450 | 450 | 450 | 450 | 450 | 450 | 450 | 450 | 450 | 5.400 |
| Marketing19% | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 7.140 |
| Steuerberater19% | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 5.712 |
| Sonstige Fixkosten19% | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 8.568 |
| Kredit-Tilgung | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 9.600 |
| Summe Fixkosten | 7.487 | 7.487 | 7.487 | 7.487 | 7.487 | 7.487 | 7.487 | 7.487 | 7.487 | 7.487 | 7.487 | 7.487 | 89.844 |
| Vorsteuer fix | 437 | 437 | 437 | 437 | 437 | 437 | 437 | 437 | 437 | 437 | 437 | 437 | 5.244 |
| Gesamtausgaben (brutto) | 29.758 | 31.349 | 34.530 | 37.712 | 42.484 | 44.075 | 45.665 | 44.075 | 40.893 | 37.712 | 34.530 | 48.847 | 471.630 |
| UMSATZSTEUER (Monatlich) | |||||||||||||
| USt-Zahllast (USt − Vorsteuer) | 3.752 | 4.052 | 4.651 | 5.249 | 6.146 | 6.446 | 6.745 | 6.446 | 5.848 | 5.249 | 4.651 | 7.343 | 66.578 |
| USt-Zahlung (Liquiditätswirksam) | 0 | 3.752 | 4.052 | 4.651 | 5.249 | 6.146 | 6.446 | 6.745 | 6.446 | 5.848 | 5.249 | 4.651 | 59.235 |
| Monatssaldo | 7.727 | 8.814 | 10.988 | 13.161 | 16.421 | 17.508 | 18.595 | 17.508 | 15.335 | 13.161 | 10.988 | 20.768 | 170.974 |
| Liquidität kumulativ | 22.727 | 27.789 | 34.725 | 43.235 | 54.407 | 65.769 | 77.918 | 88.681 | 97.570 | 104.883 | 110.622 | 126.739 | 126.739 |