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) | |||||||||||||
| Brot & Brötchen7% | 33.705 | 31.833 | 35.578 | 37.450 | 39.323 | 37.450 | 35.578 | 35.578 | 37.450 | 39.323 | 41.195 | 48.685 | 453.148 |
| Feingebäck & Kuchen7% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Café-Verkauf19% | 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 | 33.705 | 31.833 | 35.578 | 37.450 | 39.323 | 37.450 | 35.578 | 35.578 | 37.450 | 39.323 | 41.195 | 48.685 | 453.148 |
| USt vereinnahmt | 2.205 | 2.083 | 2.328 | 2.450 | 2.573 | 2.450 | 2.328 | 2.328 | 2.450 | 2.573 | 2.695 | 3.185 | 29.648 |
| VARIABLE KOSTEN (BRUTTO) | |||||||||||||
| Rohstoffe/Zutaten7% | 8.426 | 7.959 | 8.895 | 9.363 | 9.831 | 9.363 | 8.895 | 8.895 | 9.363 | 9.831 | 10.299 | 12.171 | 113.291 |
| Personal (Bäcker/Verkauf) | 12.600 | 11.900 | 13.300 | 14.000 | 14.700 | 14.000 | 13.300 | 13.300 | 14.000 | 14.700 | 15.400 | 18.200 | 169.400 |
| Summe Variable Kosten | 21.026 | 19.859 | 22.195 | 23.363 | 24.531 | 23.363 | 22.195 | 22.195 | 23.363 | 24.531 | 25.699 | 30.371 | 282.691 |
| Vorsteuer variabel | 551 | 521 | 582 | 613 | 643 | 613 | 582 | 582 | 613 | 643 | 674 | 796 | 7.413 |
| FIXKOSTEN (BRUTTO) | |||||||||||||
| Miete/Laden | 2.500 | 2.500 | 2.500 | 2.500 | 2.500 | 2.500 | 2.500 | 2.500 | 2.500 | 2.500 | 2.500 | 2.500 | 30.000 |
| Energie19% | 1.071 | 1.071 | 1.071 | 1.071 | 1.071 | 1.071 | 1.071 | 1.071 | 1.071 | 1.071 | 1.071 | 1.071 | 12.852 |
| Versicherungen | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 4.800 |
| Marketing19% | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 2.856 |
| 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 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 9.600 |
| Summe Fixkosten | 5.961 | 5.961 | 5.961 | 5.961 | 5.961 | 5.961 | 5.961 | 5.961 | 5.961 | 5.961 | 5.961 | 5.961 | 71.532 |
| Vorsteuer fix | 361 | 361 | 361 | 361 | 361 | 361 | 361 | 361 | 361 | 361 | 361 | 361 | 4.332 |
| Gesamtausgaben (brutto) | 26.987 | 25.820 | 28.156 | 29.324 | 30.492 | 29.324 | 28.156 | 28.156 | 29.324 | 30.492 | 31.660 | 36.332 | 354.223 |
| UMSATZSTEUER (Monatlich) | |||||||||||||
| USt-Zahllast (USt − Vorsteuer) | 1.293 | 1.201 | 1.385 | 1.476 | 1.569 | 1.476 | 1.385 | 1.385 | 1.476 | 1.569 | 1.660 | 2.028 | 17.903 |
| USt-Zahlung (Liquiditätswirksam) | 0 | 1.293 | 1.201 | 1.385 | 1.476 | 1.569 | 1.476 | 1.385 | 1.385 | 1.476 | 1.569 | 1.660 | 15.875 |
| Monatssaldo | 6.718 | 6.013 | 7.422 | 8.126 | 8.831 | 8.126 | 7.422 | 7.422 | 8.126 | 8.831 | 9.535 | 12.353 | 98.925 |
| Liquidität kumulativ | 18.718 | 23.438 | 29.659 | 36.400 | 43.755 | 50.312 | 56.258 | 62.295 | 69.036 | 76.391 | 84.357 | 95.050 | 95.050 |