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) | |||||||||||||
| Frachtaufträge19% | 85.680 | 85.680 | 95.200 | 99.960 | 99.960 | 99.960 | 95.200 | 90.440 | 99.960 | 104.720 | 104.720 | 95.200 | 1.156.680 |
| Kurierdienst19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Lagerlogistik19% | 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 | 85.680 | 85.680 | 95.200 | 99.960 | 99.960 | 99.960 | 95.200 | 90.440 | 99.960 | 104.720 | 104.720 | 95.200 | 1.156.680 |
| USt vereinnahmt | 13.680 | 13.680 | 15.200 | 15.960 | 15.960 | 15.960 | 15.200 | 14.440 | 15.960 | 16.720 | 16.720 | 15.200 | 184.680 |
| VARIABLE KOSTEN (BRUTTO) | |||||||||||||
| Kraftstoff/Diesel19% | 25.704 | 25.704 | 28.560 | 29.988 | 29.988 | 29.988 | 28.560 | 27.132 | 29.988 | 31.416 | 31.416 | 28.560 | 347.004 |
| Personal (Fahrer) | 25.200 | 25.200 | 28.000 | 29.400 | 29.400 | 29.400 | 28.000 | 26.600 | 29.400 | 30.800 | 30.800 | 28.000 | 340.200 |
| Maut/Straßengebühren19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Summe Variable Kosten | 50.904 | 50.904 | 56.560 | 59.388 | 59.388 | 59.388 | 56.560 | 53.732 | 59.388 | 62.216 | 62.216 | 56.560 | 687.204 |
| Vorsteuer variabel | 4.104 | 4.104 | 4.560 | 4.788 | 4.788 | 4.788 | 4.560 | 4.332 | 4.788 | 5.016 | 5.016 | 4.560 | 55.404 |
| FIXKOSTEN (BRUTTO) | |||||||||||||
| Hallenmiete | 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 |
| Nebenkosten19% | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 714 | 8.568 |
| KFZ-Versicherungen | 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 |
| Marketing19% | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 4.284 |
| Steuerberater19% | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 7.140 |
| Fahrzeug-Leasing19% | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 952 | 11.424 |
| Kredit-Tilgung | 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 |
| Summe Fixkosten | 9.618 | 9.618 | 9.618 | 9.618 | 9.618 | 9.618 | 9.618 | 9.618 | 9.618 | 9.618 | 9.618 | 9.618 | 115.416 |
| Vorsteuer fix | 418 | 418 | 418 | 418 | 418 | 418 | 418 | 418 | 418 | 418 | 418 | 418 | 5.016 |
| Gesamtausgaben (brutto) | 60.522 | 60.522 | 66.178 | 69.006 | 69.006 | 69.006 | 66.178 | 63.350 | 69.006 | 71.834 | 71.834 | 66.178 | 802.620 |
| UMSATZSTEUER (Monatlich) | |||||||||||||
| USt-Zahllast (USt − Vorsteuer) | 9.158 | 9.158 | 10.222 | 10.754 | 10.754 | 10.754 | 10.222 | 9.690 | 10.754 | 11.286 | 11.286 | 10.222 | 124.260 |
| USt-Zahlung (Liquiditätswirksam) | 0 | 9.158 | 9.158 | 10.222 | 10.754 | 10.754 | 10.754 | 10.222 | 9.690 | 10.754 | 11.286 | 11.286 | 114.038 |
| Monatssaldo | 25.158 | 25.158 | 29.022 | 30.954 | 30.954 | 30.954 | 29.022 | 27.090 | 30.954 | 32.886 | 32.886 | 29.022 | 354.060 |
| Liquidität kumulativ | 55.158 | 71.158 | 91.022 | 111.754 | 131.954 | 152.154 | 170.422 | 187.290 | 208.554 | 230.686 | 252.286 | 270.022 | 270.022 |