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) | |||||||||||||
| Verkaufsprovision19% | 16.660 | 19.040 | 23.800 | 26.180 | 27.370 | 28.560 | 26.180 | 21.420 | 23.800 | 26.180 | 23.800 | 17.850 | 280.840 |
| Vermietungsprovision19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Hausverwaltung19% | 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 | 16.660 | 19.040 | 23.800 | 26.180 | 27.370 | 28.560 | 26.180 | 21.420 | 23.800 | 26.180 | 23.800 | 17.850 | 280.840 |
| USt vereinnahmt | 2.660 | 3.040 | 3.800 | 4.180 | 4.370 | 4.560 | 4.180 | 3.420 | 3.800 | 4.180 | 3.800 | 2.850 | 44.840 |
| VARIABLE KOSTEN (BRUTTO) | |||||||||||||
| Exposé/Fotos19% | 333 | 381 | 476 | 524 | 547 | 571 | 524 | 428 | 476 | 524 | 476 | 357 | 5.617 |
| Personal | 3.500 | 4.000 | 5.000 | 5.500 | 5.750 | 6.000 | 5.500 | 4.500 | 5.000 | 5.500 | 5.000 | 3.750 | 59.000 |
| Fahrtkosten19% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Summe Variable Kosten | 3.833 | 4.381 | 5.476 | 6.024 | 6.297 | 6.571 | 6.024 | 4.928 | 5.476 | 6.024 | 5.476 | 4.107 | 64.617 |
| Vorsteuer variabel | 53 | 61 | 76 | 84 | 87 | 91 | 84 | 68 | 76 | 84 | 76 | 57 | 897 |
| FIXKOSTEN (BRUTTO) | |||||||||||||
| Büromiete | 1.200 | 1.200 | 1.200 | 1.200 | 1.200 | 1.200 | 1.200 | 1.200 | 1.200 | 1.200 | 1.200 | 1.200 | 14.400 |
| Nebenkosten19% | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 357 | 4.284 |
| Versicherungen | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 4.800 |
| 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% | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 595 | 7.140 |
| Kredit-Tilgung | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| Summe Fixkosten | 4.932 | 4.932 | 4.932 | 4.932 | 4.932 | 4.932 | 4.932 | 4.932 | 4.932 | 4.932 | 4.932 | 4.932 | 59.184 |
| Vorsteuer fix | 532 | 532 | 532 | 532 | 532 | 532 | 532 | 532 | 532 | 532 | 532 | 532 | 6.384 |
| Gesamtausgaben (brutto) | 8.765 | 9.313 | 10.408 | 10.956 | 11.229 | 11.503 | 10.956 | 9.860 | 10.408 | 10.956 | 10.408 | 9.039 | 123.801 |
| UMSATZSTEUER (Monatlich) | |||||||||||||
| USt-Zahllast (USt − Vorsteuer) | 2.075 | 2.447 | 3.192 | 3.564 | 3.751 | 3.937 | 3.564 | 2.820 | 3.192 | 3.564 | 3.192 | 2.261 | 37.559 |
| USt-Zahlung (Liquiditätswirksam) | 0 | 2.075 | 2.447 | 3.192 | 3.564 | 3.751 | 3.937 | 3.564 | 2.820 | 3.192 | 3.564 | 3.192 | 35.298 |
| Monatssaldo | 7.895 | 9.727 | 13.392 | 15.224 | 16.141 | 17.057 | 15.224 | 11.560 | 13.392 | 15.224 | 13.392 | 8.811 | 157.039 |
| Liquidität kumulativ | 32.895 | 40.547 | 51.492 | 63.524 | 76.101 | 89.407 | 100.694 | 108.690 | 119.262 | 131.294 | 141.122 | 146.741 | 146.741 |