← Branche wechseln
🛍
Liquiditätsplan: Einzelhandel
12-Monats-Planung mit branchenspezifischen Werten
Anfangsbestand:20.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) | |||||||||||||
| Ladenverkauf19% | 53.550 | 49.980 | 60.690 | 64.260 | 71.400 | 67.830 | 64.260 | 60.690 | 71.400 | 74.970 | 85.680 | 103.530 | 828.240 |
| Online-Shop19% | 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 | 53.550 | 49.980 | 60.690 | 64.260 | 71.400 | 67.830 | 64.260 | 60.690 | 71.400 | 74.970 | 85.680 | 103.530 | 828.240 |
| USt vereinnahmt | 8.550 | 7.980 | 9.690 | 10.260 | 11.400 | 10.830 | 10.260 | 9.690 | 11.400 | 11.970 | 13.680 | 16.530 | 132.240 |
| VARIABLE KOSTEN (BRUTTO) | |||||||||||||
| Wareneinsatz19% | 26.775 | 24.990 | 30.345 | 32.130 | 35.700 | 33.915 | 32.130 | 30.345 | 35.700 | 37.485 | 42.840 | 51.765 | 414.120 |
| Personal | 9.000 | 8.400 | 10.200 | 10.800 | 12.000 | 11.400 | 10.800 | 10.200 | 12.000 | 12.600 | 14.400 | 17.400 | 139.200 |
| Versandkosten19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Summe Variable Kosten | 35.775 | 33.390 | 40.545 | 42.930 | 47.700 | 45.315 | 42.930 | 40.545 | 47.700 | 50.085 | 57.240 | 69.165 | 553.320 |
| Vorsteuer variabel | 4.275 | 3.990 | 4.845 | 5.130 | 5.700 | 5.415 | 5.130 | 4.845 | 5.700 | 5.985 | 6.840 | 8.265 | 66.120 |
| FIXKOSTEN (BRUTTO) | |||||||||||||
| Miete | 4.000 | 4.000 | 4.000 | 4.000 | 4.000 | 4.000 | 4.000 | 4.000 | 4.000 | 4.000 | 4.000 | 4.000 | 48.000 |
| Nebenkosten19% | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 8.568 |
| Versicherungen | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 350 | 4.200 |
| Marketing19% | 1.428 | 1.428 | 1.428 | 1.428 | 1.428 | 1.428 | 1.428 | 1.428 | 1.428 | 1.428 | 1.428 | 1.428 | 17.136 |
| Steuerberater19% | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 5.712 |
| Sonstige Fixkosten19% | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 7.140 |
| Kredit-Tilgung | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 600 | 7.200 |
| Summe Fixkosten | 8.163 | 8.163 | 8.163 | 8.163 | 8.163 | 8.163 | 8.163 | 8.163 | 8.163 | 8.163 | 8.163 | 8.163 | 97.956 |
| Vorsteuer fix | 513 | 513 | 513 | 513 | 513 | 513 | 513 | 513 | 513 | 513 | 513 | 513 | 6.156 |
| Gesamtausgaben (brutto) | 43.938 | 41.553 | 48.708 | 51.093 | 55.863 | 53.478 | 51.093 | 48.708 | 55.863 | 58.248 | 65.403 | 77.328 | 651.276 |
| UMSATZSTEUER (Monatlich) | |||||||||||||
| USt-Zahllast (USt − Vorsteuer) | 3.762 | 3.477 | 4.332 | 4.617 | 5.187 | 4.902 | 4.617 | 4.332 | 5.187 | 5.472 | 6.327 | 7.752 | 59.964 |
| USt-Zahlung (Liquiditätswirksam) | 0 | 3.762 | 3.477 | 4.332 | 4.617 | 5.187 | 4.902 | 4.617 | 4.332 | 5.187 | 5.472 | 6.327 | 52.212 |
| Monatssaldo | 9.612 | 8.427 | 11.982 | 13.167 | 15.537 | 14.352 | 13.167 | 11.982 | 15.537 | 16.722 | 20.277 | 26.202 | 176.964 |
| Liquidität kumulativ | 29.612 | 34.277 | 42.782 | 51.617 | 62.537 | 71.702 | 79.967 | 87.332 | 98.537 | 110.072 | 124.877 | 144.752 | 144.752 |