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) | |||||||||||||
| Haarschnitte19% | 15.173 | 16.065 | 17.850 | 19.635 | 20.528 | 19.635 | 17.850 | 16.958 | 17.850 | 17.850 | 19.635 | 21.420 | 220.449 |
| Farbe & Strähnchen19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Kosmetik-Behandlungen19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Produktverkauf19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Summe Einnahmen | 15.173 | 16.065 | 17.850 | 19.635 | 20.528 | 19.635 | 17.850 | 16.958 | 17.850 | 17.850 | 19.635 | 21.420 | 220.449 |
| USt vereinnahmt | 2.423 | 2.565 | 2.850 | 3.135 | 3.278 | 3.135 | 2.850 | 2.708 | 2.850 | 2.850 | 3.135 | 3.420 | 35.199 |
| VARIABLE KOSTEN (BRUTTO) | |||||||||||||
| Friseur-/Kosmetikbedarf19% | 1.517 | 1.607 | 1.785 | 1.964 | 2.053 | 1.964 | 1.785 | 1.696 | 1.785 | 1.785 | 1.964 | 2.142 | 22.047 |
| Personal | 5.738 | 6.075 | 6.750 | 7.425 | 7.763 | 7.425 | 6.750 | 6.413 | 6.750 | 6.750 | 7.425 | 8.100 | 83.364 |
| Summe Variable Kosten | 7.255 | 7.682 | 8.535 | 9.389 | 9.816 | 9.389 | 8.535 | 8.109 | 8.535 | 8.535 | 9.389 | 10.242 | 105.411 |
| Vorsteuer variabel | 242 | 257 | 285 | 314 | 328 | 314 | 285 | 271 | 285 | 285 | 314 | 342 | 3.522 |
| FIXKOSTEN (BRUTTO) | |||||||||||||
| Miete/Laden | 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 |
| Nebenkosten19% | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 5.004 |
| Versicherungen | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 3.000 |
| Marketing19% | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 2.856 |
| Steuerberater19% | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 4.284 |
| Sonstige Fixkosten19% | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 2.856 |
| Kredit-Tilgung | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 4.800 |
| Summe Fixkosten | 3.400 | 3.400 | 3.400 | 3.400 | 3.400 | 3.400 | 3.400 | 3.400 | 3.400 | 3.400 | 3.400 | 3.400 | 40.800 |
| Vorsteuer fix | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 200 | 2.400 |
| Gesamtausgaben (brutto) | 10.655 | 11.082 | 11.935 | 12.789 | 13.216 | 12.789 | 11.935 | 11.509 | 11.935 | 11.935 | 12.789 | 13.642 | 146.211 |
| UMSATZSTEUER (Monatlich) | |||||||||||||
| USt-Zahllast (USt − Vorsteuer) | 1.981 | 2.108 | 2.365 | 2.621 | 2.750 | 2.621 | 2.365 | 2.237 | 2.365 | 2.365 | 2.621 | 2.878 | 29.277 |
| USt-Zahlung (Liquiditätswirksam) | 0 | 1.981 | 2.108 | 2.365 | 2.621 | 2.750 | 2.621 | 2.365 | 2.237 | 2.365 | 2.365 | 2.621 | 26.399 |
| Monatssaldo | 4.518 | 4.983 | 5.915 | 6.846 | 7.312 | 6.846 | 5.915 | 5.449 | 5.915 | 5.915 | 6.846 | 7.778 | 74.238 |
| Liquidität kumulativ | 12.518 | 15.520 | 19.327 | 23.808 | 28.499 | 32.595 | 35.889 | 38.973 | 42.651 | 46.201 | 50.682 | 55.839 | 55.839 |