{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["Anl 2","Anl 3","Anl 4","Anl 5 - GewSt","Risikozuschlag (nach Steuern)"],"not_rendered":{"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Anl 2","index":0,"n_rows":62,"n_cols":22,"rows_kept":62,"flags":["formulas_cached_only"]}
[{"$nulls":3},"Ertragsermittlung (Betriebsergebnisse / Durchschnittsertrag) gültig für Bewertungsstichtage ab 01.01.2005"]
["Zeile","Tz"]
[1,"1.2",null,"Referenzzeitraum:",null,"bis",{"$nulls":3},0,null,null,"",null,null,"",null,null,"",null,null,""]
[]
[2,{"$nulls":6},"1 = DM / 2 = Euro",null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[]
[3,"1.2.1",null,"Zu versteuerndes Einkommen"]
[4,"1.2.2",null,"Hinzurechnungen / Kürzungen (soweit sich die Beträge"]
[{"$nulls":3},"auf das z.v.E. ausgewirkt haben)"]
[]
[5,"1.2.2.1",null,"Hinzurechnungen"]
[6,null,"+","Sonder-AfA, Teilwertabschreibungen (ohne Beteiligungen)",{"$nulls":4},"+",null,null,"+",null,null,"+",null,null,"+",null,null,"+"]
[7,null,"+","Zuführung zu steuerfreien Rücklagen",{"$nulls":4},"+",null,null,"+",null,null,"+",null,null,"+",null,null,"+"]
[8,null,"+","AfA auf Firmenwert u. firmenwertähnliche WG",{"$nulls":4},"+",null,null,"+",null,null,"+",null,null,"+",null,null,"+"]
[9,null,"+","Verlustabzug",{"$nulls":4},"+",null,null,"+",null,null,"+",null,null,"+",null,null,"+"]
[10,null,"+","einmalige Veräußerungsverluste",{"$nulls":4},"+",null,null,"+",null,null,"+",null,null,"+",null,null,"+"]
[11,null,"+","einmalige Aufwendungen, außerordentliche Zuführungen zu Rückstellungen",{"$nulls":4},"+",null,null,"+",null,null,"+",null,null,"+",null,null,"+"]
[{"$nulls":3},"(z.B. Kosten für Sozialpläne)"]
[12,null,"+","Aufwendungen im Zusammenhang mit Beteiligungen an anderen"]
[{"$nulls":3},"Unternehmen",{"$nulls":4},"+",null,null,"+",null,null,"+",null,null,"+",null,null,"+"]
[{"$nulls":3},"(soweit für die Beteiligungen ein gesonderter UW angesetzt wird)"]
[13,null,"+","Verluste aus nicht betriebsnotwendigem Vermögen",{"$nulls":4},"+",null,null,"+",null,null,"+",null,null,"+",null,null,"+"]
[14,null,"+","Sonstige Hinzurechnungen (z.B. GewSt-Erstattung auf Summe d. Kürzungen/Hinzurechnungen)",{"$nulls":4},"+",null,null,"+",null,null,"+",null,null,"+",null,null,"+"]
[]
[15,"1.2.2.2",null,"Kürzungen"]
[16,null,"-","Erträge im Zusammenhang mit Beteiligungen an anderen Unternehmen",{"$nulls":4},"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
[{"$nulls":3},"(soweit für die Beteiligungen ein gesonderter UW angesetzt wird)"]
[17,null,"-","einmalige Veräußerungsgewinne",{"$nulls":4},"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
[18,null,"-","einmalige Erträge aus Auflösung von Rückstellungen",{"$nulls":4},"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
[19,null,"-","Auflösung steuerfreier Rücklagen",{"$nulls":4},"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
[20,null,"-","einmalige Wertaufholungen nach § 6 EStG",{"$nulls":4},"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
[21,null,"-","nichtabziehbare Ausgaben (ohne KSt und SoZ), ",{"$nulls":4},"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
[22,null,"-","Hinzurechnungen nach § 8a KStG",{"$nulls":4},"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
[23,null,"-","Erträge (Überschüsse) aus nichtbetriebsnotwendigem Vermögen",{"$nulls":4},"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
[24,null,"-","Sonstige Kürzungen (z.B. GewSt-Erhöhung auf Summe d.Hinzurechnungen/Kürzungen)",{"$nulls":4},"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
[{"$nulls":15},0]
[25,null,null,"Zwischensumme  ",{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0]
[]
[26,"1.2.3","-","Körperschaftsteuer (25 vH)",{"$nulls":4},"-",0,null,"-",0,null,"-",0,null,"-",0,null,"-",0]
[27,null,"-","Solidaritätszuschlag (5,5 vH der KSt)",{"$nulls":4},"-",0,null,"-",0,null,"-",0,null,"-",0,null,"-",0]
[28,null,"-","Körperschaftsteuer + Solidaritätszuschlag auf die nicht abziehbaren Ausga-",{"$nulls":4},"-",0,null,"-",0,null,"-",0,null,"-",0,null,"-",0]
[{"$nulls":3},"ben lt Zeile 21  und Hinzurechnungen nach § 8a KStG lt. Zeile 22 (26,38 vH)"]
[]
[29,null,null,"Zwischensumme  ",{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0]
[]
[30,"1.2.4","+","steuerfreie Vermögensmehrungen",{"$nulls":4},"+",null,null,"+",null,null,"+",null,null,"+",null,null,"+"]
[{"$nulls":3},"(ohne Erträge aus Beteiligungen, für die ein gesonderter UW angesetzt wird)"]
[]
[31,null,null,"Betriebsergebnis in DM",{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0]
[32,null,null,"Umrechnung in EUR",{"$nulls":5},{"v":0,"d":"0.00000"},null,null,{"v":0,"d":"0.00000"},null,null,{"v":0,"d":"0.00000"},null,null,{"v":0,"d":"0.00000"},null,null,{"v":0,"d":"0.00000"}]
[]
[33,"1.2.5",null,"Betriebsergebnis  in EUR",{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0]
[]
[34,"1.2.6",null,"Gewichtung der Betriebsergebnisse"]
[35,null,null,"Faktor"]
[36,null,null,"Gewichtete Betriebsergebnisse",{"$nulls":5},0,null,null,0,null,null,0,null,null,0,null,null,0]
[]
[{"$nulls":9},"EURO"]
[37,null,null,"Summe der gewichteten Betriebsergebnisse lt Zeile 36",{"$nulls":5},0]
[38,null,null,"Dividiert durch die Summe der Faktoren lt Zeile 35",{"$nulls":5},0]
[]
[39,"1.2.6",null,"Durchschnittsertrag ",{"$nulls":5},{"$error":"#DIV/0!"}]

{"sheet":"Anl 3","index":1,"n_rows":35,"n_cols":10,"rows_kept":35,"merged":[[31,3,31,4],[32,3,32,4]],"flags":["formulas_cached_only"]}
["Zeile","Tz"]
[1,null,null,"Ertragswertverfahren"]
[]
[2,"1.2.6",null,"Durchschnittsertrag ",{"$nulls":5},{"$error":"#DIV/0!"}]
[null,"1.1.2",null,"abzüglich typisierte Ertragsteuerbelastung (1/2 v. 35% = 17,5%)",{"$nulls":4},"-",{"$error":"#DIV/0!"}]
[3,null,null,"Anzusetzender Ertrag",{"$nulls":5},{"$error":"#DIV/0!"}]
[]
[]
[4,"1.3.",null,"Kapitalisierungsfaktor (K)"]
[]
[5,"1.3.1",null,"Kapitalisierungszinsfuß"]
[6,null,null,"Basiszins",null,null,{"v":5,"d":"5.00"},"%",null,{"v":5,"d":"5.00"}]
[]
[7,null,"-","abzüglich typisierte Ertragsteuerbelastung (= 35%)",{"$nulls":4},"-",-1.75]
[]
[null,null,"+","Risikozuschlag (nach Steuern)",null,null,{"v":3.6,"d":"3.60"},"%","+",{"v":3.6,"d":"3.60"}]
[]
[8,null,null,"Kapitalisierungszinsfuß",{"$nulls":5},6.85]
[]
[9,"1.3.2",null,"Kapitalisierungsfaktor",{"$nulls":5},14.5985]
[{"$nulls":3},"(K = 100 / Kapitalisierungszinsfuß)"]
[]
[{"$nulls":9},"EURO"]
[10,"1.4",null,"Ertragswert",{"$nulls":5},{"$error":"#DIV/0!"}]
[{"$nulls":3},"(anzusetzender Ertrag x Kapitalisierungsfaktor)"]
[]
[11,"1.4.1","+","(Unternehmens-)Wert der Beteiligungen (sofern gesondert bewertet)",{"$nulls":4},"+",0]
[12,"1.4.2","+","Liquidationswert nichtbetriebsnotwendiges Vermögen",{"$nulls":4},"+"]
[13,"1.4.3","+","\"Anspruch auf Gewinnausschüttung\"",{"$nulls":4},"+"]
[14,"1.4.4","+","Körperschaftsteuerguthaben nach § 37 KStG"]
[]
[{"$nulls":3},0,null,"x",75,null,"+",0]
[{"$nulls":3},"(KSt-Guthaben)",null,null,"(Ansatz in der Regel mit 75 vH)"]
[]
[15,"1.4.5",null,"Ertrags-Unternehmenswert",{"$nulls":5},{"$error":"#DIV/0!"}]

{"sheet":"Anl 4","index":2,"n_rows":47,"n_cols":10,"rows_kept":47,"flags":["formulas_cached_only"]}
["Zeile","Tz"]
[1,"2.1/2.2",null,"Substanzwertermittlung / -verfahren"]
[]
[]
[]
[{"$nulls":9},"EURO"]
[]
[2,"2.2.1",null,"Eigenkapital lt. HB / StB"]
[3,"2.2.2","+","stille Reserven Grundstücke",{"$nulls":4},"+"]
[4,"2.2.3","-","Buchwert der Beteiligungen",{"$nulls":4},"-"]
[{"$nulls":3},"(soweit für die Beteiligungen ein gesonderter UW ermittelt wird)"]
[5,"2.2.3","+","(Unternehmens-)Wert der Beteiligungen",{"$nulls":4},"+"]
[6,"2.2.4","+","stille Reserven übriges Anlagevermögen",{"$nulls":4},"+"]
[{"$nulls":3},"(ohne Grundstücke u. Beteiligungen)"]
[7,"2.2.5","+","stille Reserven immaterielle WG",{"$nulls":4},"+"]
[8,"2.2.6","+","stille Reserven Umlaufvermögen",{"$nulls":4},"+"]
[9,"2.2.7","+","Körperschaftsteuer-Guthaben gem. § 37 KStG"]
[{"$nulls":4},"x",75,null,null,"+",0]
[{"$nulls":3},"(KSt-Guthaben)",null,"(Ansatz in der Regel mit 75 vH)"]
[{"$nulls":5},"(Ansatz im Liquidationsfall 100 vH)"]
[10,"2.2.8","-","Stille Lasten",{"$nulls":4},"-"]
[11,null,"+","Sonstiges",{"$nulls":4},"+"]
[]
[12,"2.2.9","=","Substanz-Unternehmenswert",{"$nulls":5},0]
[]
[13,null,null,"Im Liquidationsfall",null,"ja = 1"]
[]
[14,null,null,"Substanz-Unternehmenswert lt. Zeile 12",{"$nulls":5},0]
[15,"2.2.10","-","Liquidationskosten ",{"$nulls":4},"-"]
[{"$nulls":3},"(einschl. der Steuern auf den Liquidationsgewinn)"]
[16,"2.2.11","-","Abzinsung für den Liquidationszeitraum",{"$nulls":4},"-"]
[]
[]
[17,"2.2.12","=","Liquidations-Unternehmenswert",{"$nulls":5},0]
[]
[]
[]
[]
[]
[]
[17,"3.",null,"Abschließende Wertfindung",{"$nulls":5},"EURO"]
[]
[18,null,null,"Ertrags-Unternehmenswert (1.4.5)",{"$nulls":5},{"$error":"#DIV/0!"}]
[]
[19,"3.2",null,"Wertuntergrenze:"]
[]
[20,null,null,"Substanz-Unternehmenswert (2.2.9 / 2.2.12)",{"$nulls":5},0]

{"sheet":"Anl 5 - GewSt","index":3,"n_rows":42,"n_cols":19,"rows_kept":42,"flags":["formulas_cached_only"]}
[null,"Ermittlung des gewerbesteuerlichen Mehr-/Minderaufwandes "]
[null,"aufgrund der Hinzurechnungen/Kürzungen bei der Ermittlung der Betriebsergebnisse"]
[]
[]
["Zeile","Tz"]
[1,{"$nulls":5},0,null,null,"",null,null,"",null,null,"",null,null,""]
[]
[2,{"$nulls":4},0,0,null,0,0,null,0,0,null,0,0,null,0,0]
[]
[3,null,null,"Gewerbeertrag bisher"]
[]
[4,"1.2.2.1",null,"Hinzurechnungen"]
[5,null,"+","Sonder-AfA, Teilwertabschreibungen (ohne Beteiligungen)",null,"+",0,null,"+",0,null,"+",0,null,"+",0,null,"+",0]
[6,null,"+","Zuführung zu steuerfreien Rücklagen",null,"+",0,null,"+",0,null,"+",0,null,"+",0,null,"+",0]
[7,null,"+","einmalige Veräußerungsverluste",null,"+",0,null,"+",0,null,"+",0,null,"+",0,null,"+",0]
[8,null,"+","einmalige Aufwendungen, außerordentliche Zuführungen zu Rückstellungen",null,"+",0,null,"+",0,null,"+",0,null,"+",0,null,"+",0]
[9,null,"+","Sonstige Hinzurechnungen",null,"+",null,null,"+",null,null,"+",null,null,"+",null,null,"+"]
[]
[10,"1.2.2.2",null,"Kürzungen"]
[11,null,"-","einmalige Veräußerungsgewinne",null,"-",0,null,"-",0,null,"-",0,null,"-",0,null,"-",0]
[12,null,"-","einmalige Erträge aus Auflösung von Rückstellungen",null,"-",0,null,"-",0,null,"-",0,null,"-",0,null,"-",0]
[13,null,"-","Auflösung steuerfreier Rücklagen",null,"-",0,null,"-",0,null,"-",0,null,"-",0,null,"-",0]
[14,null,"-","einmalige Wertaufholungen nach § 6 EStG",null,"-",0,null,"-",0,null,"-",0,null,"-",0,null,"-",0]
[15,null,"-","Sonstige Kürzungen",null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
[]
[16,null,null,"Zwischensumme",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[]
[17,null,"+","durch Änderungen des Gewerbeverlustes/-vortrags",null,"+",null,null,"+",null,null,"+",null,null,"+",null,null,"+"]
[18,null,"-","durch Änderungen des Gewerbeverlustes/-vortrags",null,"-",null,null,"-",null,null,"-",null,null,"-",null,null,"-"]
[]
[19,null,null,"Gewerbeertrag nach Korrekturen",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[20,null,null,"Gewerbeertrag bisher",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[]
[21,null,null,"Mehr/Weniger Gewerbeertrag",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[]
[22,null,null,"vorläufige GewSt"]
[23,{"$nulls":3},"Änderung GewSt-Meßbetrag",null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[24,{"$nulls":3},"x Hebesatz"]
[25,{"$nulls":3},"vorläufiger Gewerbesteuermehr- (-)/minderaufwand",null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[]
[26,null,null,"Gewerbesteueraufwand (-)/ -erstattung",null,null,0,null,null,0,null,null,0,null,null,0,null,null,0]
[{"$nulls":3},"(Devisormethode: Devisor = 1+1/2 Hebesatz)"]

{"sheet":"Risikozuschlag (nach Steuern)","index":4,"n_rows":33,"n_cols":12,"rows_kept":33,"flags":["formulas_cached_only"]}
["Ermittlung des Risikozuschlags nach Steuern"]
[]
[]
[]
["lt IDW (Beispiel)","Kurs-",null,"Dividenden-",null,"Gesamt-",null,"Basis-",null,"Risikozuschlag",null,"Zuschlag n."]
[null,"rendite",null,"rendite",null,"rendite",null,"zinssatz",{"$nulls":3},"Steuern gerundet"]
["Vor Steuern",{"v":0.0475,"d":"4.75%"},"+",{"v":0.0475,"d":"4.75%"},"=",{"v":0.095,"d":"9.50%"},"-",{"v":0.05,"d":"5.00%"},"=",{"v":0.045,"d":"4.50%"}]
["Steuern (0% / 17,5% / 35%)",{"v":0,"d":"0.00%"},null,{"v":-0.008312499999999999,"d":"-0.83%"},{"$nulls":3},{"v":-0.017499999999999998,"d":"-1.75%"}]
["Nach Steuern",{"v":0.0475,"d":"4.75%"},"+",{"v":0.0391875,"d":"3.92%"},"=",{"v":0.0866875,"d":"8.67%"},"-",{"v":0.0325,"d":"3.25%"},"=",{"v":0.0541875,"d":"5.42%"},null,{"v":0.0541875,"d":"5.4%"}]
[]
[]
[]
[]
["lt Leitfaden"]
[]
["bei Kapitalgesellschaften"]
[]
[null,"Gesamt-",null,"Basis-",null,"Risikozuschlag",null,"Wachstums-",null,"Zuschlag",null,"Zuschlag n."]
[null,"rendite",null,"zinssatz",{"$nulls":3},"abschlag",null,"nach Steuern",null,"Steuern gerundet"]
["Vor Steuern",{"v":0.095,"d":"9.50%"},"-",{"v":0.05,"d":"5.00%"},"=",{"v":0.045,"d":"4.50%"}]
["Steuern (17,5% / 35%)",{"v":-0.0166,"d":"-1.66%"},null,{"v":-0.0175,"d":"-1.75%"}]
["Nach Steuern",{"v":0.0784,"d":"7.84%"},"-",{"v":0.0325,"d":"3.25%"},"=",{"v":0.045899999999999996,"d":"4.59%"},"-",{"v":0.01,"d":"1.00%"},"=",{"v":0.035899999999999994,"d":"3.59%"},null,{"v":0.035899999999999994,"d":"3.6%"}]
[]
[]
["bei Personengesellschaften"]
[]
[null,"Gesamt-",null,"Basis-",null,"Risikozuschlag",null,"Wachstums-",null,"Zuschlag",null,"Zuschlag n."]
[null,"rendite",null,"zinssatz",{"$nulls":3},"abschlag",null,"nach Steuern",null,"Steuern gerundet"]
["Vor Steuern",{"v":0.095,"d":"9.50%"},"-",{"v":0.05,"d":"5.00%"},"=",{"v":0.045,"d":"4.50%"}]
["Steuern (35%)",{"v":-0.0333,"d":"-3.33%"},null,{"v":-0.0175,"d":"-1.75%"}]
["anrechenbare GewSt",{"v":0.0086,"d":"0.86%"}]
["(Gesamtrendite x 5% X 1,8)"]
["Nach Steuern",{"v":0.0703,"d":"7.03%"},"-",{"v":0.0325,"d":"3.25%"},"=",{"v":0.0378,"d":"3.78%"},"-",{"v":0.01,"d":"1.00%"},"=",{"v":0.0278,"d":"2.78%"},null,{"v":0.0278,"d":"2.8%"}]