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) | |||||||||||||
| Übernachtungen7% | 38.520 | 41.730 | 51.360 | 60.990 | 70.620 | 80.250 | 86.670 | 86.670 | 70.620 | 60.990 | 48.150 | 57.780 | 754.350 |
| Frühstück19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Veranstaltungen19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Sonstige Einnahmen19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Summe Einnahmen | 38.520 | 41.730 | 51.360 | 60.990 | 70.620 | 80.250 | 86.670 | 86.670 | 70.620 | 60.990 | 48.150 | 57.780 | 754.350 |
| USt vereinnahmt | 2.520 | 2.730 | 3.360 | 3.990 | 4.620 | 5.250 | 5.670 | 5.670 | 4.620 | 3.990 | 3.150 | 3.780 | 49.350 |
| VARIABLE KOSTEN (BRUTTO) | |||||||||||||
| F&B-Wareneinsatz19% | 6.426 | 6.962 | 8.568 | 10.175 | 11.781 | 13.388 | 14.459 | 14.459 | 11.781 | 10.175 | 8.033 | 9.639 | 125.846 |
| Personal (Hotel) | 12.600 | 13.650 | 16.800 | 19.950 | 23.100 | 26.250 | 28.350 | 28.350 | 23.100 | 19.950 | 15.750 | 18.900 | 246.750 |
| Summe Variable Kosten | 19.026 | 20.612 | 25.368 | 30.125 | 34.881 | 39.638 | 42.809 | 42.809 | 34.881 | 30.125 | 23.783 | 28.539 | 372.596 |
| Vorsteuer variabel | 1.026 | 1.112 | 1.368 | 1.625 | 1.881 | 2.138 | 2.309 | 2.309 | 1.881 | 1.625 | 1.283 | 1.539 | 20.096 |
| FIXKOSTEN (BRUTTO) | |||||||||||||
| Miete | 5.000 | 5.000 | 5.000 | 5.000 | 5.000 | 5.000 | 5.000 | 5.000 | 5.000 | 5.000 | 5.000 | 5.000 | 60.000 |
| Energie19% | 2.380 | 2.380 | 2.380 | 2.380 | 2.380 | 2.380 | 2.380 | 2.380 | 2.380 | 2.380 | 2.380 | 2.380 | 28.560 |
| Versicherungen | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 800 | 9.600 |
| Marketing/Portale19% | 1.785 | 1.785 | 1.785 | 1.785 | 1.785 | 1.785 | 1.785 | 1.785 | 1.785 | 1.785 | 1.785 | 1.785 | 21.420 |
| Steuerberater19% | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 7.140 |
| Sonstige Fixkosten19% | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 11.424 |
| Kredit-Tilgung | 3.000 | 3.000 | 3.000 | 3.000 | 3.000 | 3.000 | 3.000 | 3.000 | 3.000 | 3.000 | 3.000 | 3.000 | 36.000 |
| Summe Fixkosten | 14.512 | 14.512 | 14.512 | 14.512 | 14.512 | 14.512 | 14.512 | 14.512 | 14.512 | 14.512 | 14.512 | 14.512 | 174.144 |
| Vorsteuer fix | 912 | 912 | 912 | 912 | 912 | 912 | 912 | 912 | 912 | 912 | 912 | 912 | 10.944 |
| Gesamtausgaben (brutto) | 33.538 | 35.124 | 39.880 | 44.637 | 49.393 | 54.150 | 57.321 | 57.321 | 49.393 | 44.637 | 38.295 | 43.051 | 546.740 |
| UMSATZSTEUER (Monatlich) | |||||||||||||
| USt-Zahllast (USt − Vorsteuer) | 582 | 706 | 1.080 | 1.453 | 1.827 | 2.200 | 2.449 | 2.449 | 1.827 | 1.453 | 955 | 1.329 | 18.310 |
| USt-Zahlung (Liquiditätswirksam) | 0 | 582 | 706 | 1.080 | 1.453 | 1.827 | 2.200 | 2.449 | 2.449 | 1.827 | 1.453 | 955 | 16.981 |
| Monatssaldo | 4.982 | 6.606 | 11.480 | 16.353 | 21.227 | 26.100 | 29.349 | 29.349 | 21.227 | 16.353 | 9.855 | 14.729 | 207.610 |
| Liquidität kumulativ | 34.982 | 41.006 | 51.780 | 67.053 | 86.827 | 111.100 | 138.249 | 165.149 | 183.927 | 198.453 | 206.855 | 220.629 | 220.629 |