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) | |||||||||||||
| Branding/Corporate Design19% | 26.775 | 28.560 | 33.915 | 37.485 | 39.270 | 39.270 | 30.345 | 28.560 | 37.485 | 41.055 | 39.270 | 30.345 | 412.335 |
| Kampagnen-Design19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Print & Packaging19% | 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 | 26.775 | 28.560 | 33.915 | 37.485 | 39.270 | 39.270 | 30.345 | 28.560 | 37.485 | 41.055 | 39.270 | 30.345 | 412.335 |
| USt vereinnahmt | 4.275 | 4.560 | 5.415 | 5.985 | 6.270 | 6.270 | 4.845 | 4.560 | 5.985 | 6.555 | 6.270 | 4.845 | 65.835 |
| VARIABLE KOSTEN (BRUTTO) | |||||||||||||
| Freelancer/Designer19% | 2.678 | 2.856 | 3.392 | 3.749 | 3.927 | 3.927 | 3.035 | 2.856 | 3.749 | 4.106 | 3.927 | 3.035 | 41.237 |
| Personal | 11.250 | 12.000 | 14.250 | 15.750 | 16.500 | 16.500 | 12.750 | 12.000 | 15.750 | 17.250 | 16.500 | 12.750 | 173.250 |
| Produktion/Druck19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Summe Variable Kosten | 13.928 | 14.856 | 17.642 | 19.499 | 20.427 | 20.427 | 15.785 | 14.856 | 19.499 | 21.356 | 20.427 | 15.785 | 214.487 |
| Vorsteuer variabel | 428 | 456 | 542 | 599 | 627 | 627 | 485 | 456 | 599 | 656 | 627 | 485 | 6.587 |
| FIXKOSTEN (BRUTTO) | |||||||||||||
| Büromiete | 1.800 | 1.800 | 1.800 | 1.800 | 1.800 | 1.800 | 1.800 | 1.800 | 1.800 | 1.800 | 1.800 | 1.800 | 21.600 |
| Nebenkosten19% | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 417 | 5.004 |
| Versicherungen | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 3.600 |
| Marketing19% | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 7.140 |
| Steuerberater19% | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 476 | 5.712 |
| Design-Software/Lizenzen19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Kredit-Tilgung | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Summe Fixkosten | 3.588 | 3.588 | 3.588 | 3.588 | 3.588 | 3.588 | 3.588 | 3.588 | 3.588 | 3.588 | 3.588 | 3.588 | 43.056 |
| Vorsteuer fix | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 238 | 2.856 |
| Gesamtausgaben (brutto) | 17.516 | 18.444 | 21.230 | 23.087 | 24.015 | 24.015 | 19.373 | 18.444 | 23.087 | 24.944 | 24.015 | 19.373 | 257.543 |
| UMSATZSTEUER (Monatlich) | |||||||||||||
| USt-Zahllast (USt − Vorsteuer) | 3.609 | 3.866 | 4.635 | 5.148 | 5.405 | 5.405 | 4.122 | 3.866 | 5.148 | 5.661 | 5.405 | 4.122 | 56.392 |
| USt-Zahlung (Liquiditätswirksam) | 0 | 3.609 | 3.866 | 4.635 | 5.148 | 5.405 | 5.405 | 4.122 | 3.866 | 5.148 | 5.661 | 5.405 | 52.270 |
| Monatssaldo | 9.259 | 10.116 | 12.685 | 14.398 | 15.255 | 15.255 | 10.972 | 10.116 | 14.398 | 16.111 | 15.255 | 10.972 | 154.792 |
| Liquidität kumulativ | 29.259 | 35.766 | 44.585 | 54.348 | 64.455 | 74.305 | 79.872 | 85.866 | 96.398 | 107.361 | 116.955 | 122.522 | 122.522 |